is_error = 796; // NEW MESSAGE if( !$convo_id ) { // ORGANIZE RECIPIENTS $tos = array_filter(preg_split('/[\s,;]+?/', $to)); array_splice($tos, $this->level_info['level_message_recipients']); // LOOP OVER RECIPIENTS foreach( $tos as $to_username ) { // CANT SEND TO SELF if( strtolower($to_username)==strtolower($this->user_info['user_username']) ) continue; // GET TO USER OBJECT $to_user = new SEUser(array(NULL, $to_username)); // CANT SEND TO NON EXISTENT USER. BLOCKED USER, OR USERS NOT ALLOWED TO USE MESSAGES if( !$to_user->user_exists ) continue; //if( $to_user->user_blocked($this->user_info['user_id']) ) continue; if( !$this->level_info['level_message_allow'] ) continue; // CHECK MESSAGE TYPES AND ADD RECIPIENT if( $this->level_info['level_message_allow']==2 || ($this->level_info['level_message_allow']==1 && $this->user_friended($to_user->user_info['user_id'])) ) { $recipients_full[$to_user->user_info['user_id']] =& $to_user; $recipients[] = $to_user->user_info['user_id']; } } //var_dump($recipients); // ENSURE THERE ARE RECIPIENTS if( empty($recipients) ) { //var_dump($recipients); $this->is_error = 795; } // IF NO ERROR, CREATE CONVERSATION if( !$this->is_error ) { // CREATE CONVO $sql = "INSERT INTO se_pmconvos (pmconvo_subject, pmconvo_recipients) VALUES ('".addslashes($subject)."', '".(count($recipients)+1)."')"; $resource = $database->database_query($sql); $convo_id = $database->database_insert_id(); // CREATE CONVOOPS $sql = " INSERT INTO se_pmconvoops (pmconvoop_pmconvo_id, pmconvoop_user_id, pmconvoop_deleted_outbox, pmconvoop_deleted_inbox) VALUES ('{$convo_id}', '{$this->user_info['user_id']}', 0, 1)"; //$is_first = TRUE; foreach( $recipients as $to_user_id ) $sql .= ", ('{$convo_id}', '{$to_user_id}', 1, 0)"; // EXECUTE QUERY $resource = $database->database_query($sql); } } // GET RECIPIENTS AND VERIFY USER IS PART OF CONVERSATION else { $sql = "SELECT pmconvoop_user_id FROM se_pmconvoops WHERE pmconvoop_pmconvo_id='{$convo_id}'"; $resource = $database->database_query($sql); $unauthorized = TRUE; while( $pmconvoop_info=$database->database_fetch_assoc($resource) ) { if( $pmconvoop_info['pmconvoop_user_id']!=$this->user_info['user_id'] ) $recipients[] = $pmconvoop_info['pmconvoop_user_id']; else $unauthorized = FALSE; } // USER WAS NOT IN CONVERSATION if( $unauthorized ) $this->is_error = 39; // FIX THIS CODE RANDOM NUMBER TEMP } // IF NO ERROR, ADD MESSAGE TO CONVERSATION if( !$this->is_error ) { // LINK ALL LINKS //$message = preg_replace("~http(?:s)?\://([.]?[a-zA-Z0-9_/-?])*~", "\\0", $message); //$message = preg_replace("~(^| |\n)(www([.]?[a-zA-Z0-9_/-?])*)~", "\\1\\2", $message); // RUN SECURITY ON THE MESSAGE TO ENSURE NO XSS ATTACKS WITH LINKS //$message = cleanHTML($message, "a"); // REPLACE NEWLINES IN BODY WITH BREAKS $message = str_replace("\n", "
", $message); //$message = str_replace("'", "\'", $message); $message=json_encode(htmlentities($message, ENT_QUOTES)); // INSERT MESSAGE $pm_date = time(); $sql = " INSERT INTO se_pms (pm_authoruser_id, pm_pmconvo_id, pm_date, pm_body) VALUES ('{$this->user_info['user_id']}', '{$convo_id}', '{$pm_date}', '".$database->database_real_escape_string($message)."') "; $resource = $database->database_query($sql); // UPDATE PMCONVOOPS $sql = "UPDATE se_pmconvoops SET pmconvoop_deleted_outbox=0, pmconvoop_pmdate='{$pm_date}' WHERE pmconvoop_pmconvo_id='{$convo_id}' && pmconvoop_user_id='{$this->user_info['user_id']}'"; $resource = $database->database_query($sql); $sql = "UPDATE se_pmconvoops SET pmconvoop_deleted_inbox=0, pmconvoop_read=0, pmconvoop_pmdate='{$pm_date}' WHERE pmconvoop_pmconvo_id='{$convo_id}' && pmconvoop_user_id!='{$this->user_info['user_id']}'"; $resource = $database->database_query($sql); // INSERT/SEND NOTIFICATIONS FOR RECIPIENTS // GET RECIPIENTS IF NOT INITIAL MESSAGE foreach( $recipients as $recipient_user_id ) { //if( empty($recipients_full[$recipient_user_id]) ) //{ $recipients_full[$recipient_user_id] = new SEUser(array($recipient_user_id)); //} $current_recipient =& $recipients_full[$recipient_user_id]; // NOT A USER if( !is_object($current_recipient) || !$current_recipient->user_exists ) continue; // ADD NOTIFICATION $notify->notify_add($current_recipient->user_info['user_id'], 'message', $convo_id, array(), array(), TRUE, $this->user_info["user_id"]); // SEND EMAIL $current_recipient->user_settings('usersetting_notify_message'); if( $current_recipient->usersetting_info['usersetting_notify_message'] ) { $replace = array( '[username]' => $current_recipient->user_info["user_username"], '[displayname]' => $current_recipient->user_displayname, '[email]' => $current_recipient->user_info["user_email"], "[sender]"=>$this->user_displayname, '[userid]' => $user_id, '[link]' => "url_base}login.php\">{$url->url_base}login.php" ); send_systememail('message', $current_recipient->user_info["user_email"], $replace); // send_systememail('message', $current_recipient->user_info["user_email"], array($current_recipient->user_displayname, $this->user_displayname, "url_base}login.php\">{$url->url_base}login.php")); } // CLEAN OUT THEM OLD MESSAGES $num_inbox = $current_recipient->user_message_total(0, 0); $num_outbox = $current_recipient->user_message_total(1, 0); $num_inbox_delete = $num_inbox - 100;//$current_recipient->level_info['level_message_inbox']; $num_outbox_delete = $num_outbox - 100;//$current_recipient->level_info['level_message_outbox']; // CLEAN OUT INBOX if( $num_inbox_delete>0 ) { $sql = " SELECT se_pmconvoops.pmconvoop_pmconvo_id AS pmconvo_id FROM se_pmconvoops LEFT JOIN se_pmconvos ON se_pmconvos.pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id WHERE se_pmconvoops.pmconvoop_user_id='{$current_recipient->user_info['user_id']}' && se_pmconvoops.pmconvoop_deleted_inbox=0 && se_pms.pm_id=(SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id) ORDER BY se_pms.pm_date ASC LIMIT {$num_inbox_delete} "; $resource = $database->database_query($sql); while( $result=$database->database_fetch_assoc($resource) ) $delete_array[] = $result['pmconvo_id']; // DELETE $current_recipient->user_message_delete_selected($delete_array, 0); } // CLEAN OUT OUTBOX if( $num_outbox_delete>0 ) { $sql = " SELECT se_pmconvoops.pmconvoop_pmconvo_id AS pmconvo_id FROM se_pmconvoops LEFT JOIN se_pmconvos ON se_pmconvos.pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id WHERE se_pmconvoops.pmconvoop_user_id='{$current_recipient->user_info['user_id']}' && se_pmconvoops.pmconvoop_deleted_outbox=0 && se_pms.pm_id=(SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id) ORDER BY se_pms.pm_date ASC LIMIT {$num_outbox_delete} "; $resource = $database->database_query($sql); while( $result=$database->database_fetch_assoc($resource) ) $delete_array[] = $result['pmconvo_id']; // DELETE $current_recipient->user_message_delete_selected($delete_array, 1); } // CLEAR INACTIVE CONVERSATIONS $this->user_message_cleanup(); } } return $convo_id; } function set_user_photo($photo_name) { global $database, $url; // ENSURE USER DIRECTORY IS ADDED $user_directory = $url->url_userdir($this->user_info['user_id']); $database->database_query("UPDATE se_users SET user_photo='{$photo_name}' WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); $this->user_info['user_photo'] = $photo_name; } function __construct($user_unique = Array('0', '', ''), $select_fields = Array('*', '*', '*', '*'), $socket=false) { global $database,$adminpage, $url; if($socket){$this->user_info["safefromverify"]=1;} // SET VARS $this->is_error = 0; $this->user_exists = 0; $this->user_info['user_id'] = 0; $this->user_info['user_subnet_id'] = 0; $this->moderation_privacy = 1; $user_unique_id = ( !empty($user_unique[0]) ? $user_unique[0] : NULL ); $user_unique_username = ( !empty($user_unique[1]) ? $user_unique[1] : NULL ); $user_unique_email = ( !empty($user_unique[2]) ? $user_unique[2] : NULL ); // VERIFY USER_ID/USER_USERNAME/USER_EMAIL IS VALID AND SET APPROPRIATE OBJECT VARIABLES if( $user_unique_id || $user_unique_username || $user_unique_email ) { // SET USERNAME AND EMAIL TO LOWERCASE if(is_array($user_unique_username)){$x=implode($user_unique_username); $user_unique_username=$x; } $user_username = strtolower($user_unique_username); $user_email = strtolower($user_unique_email); // SELECT USER USING SPECIFIED SELECTION PARAMETER $sql_array = array(); if( !empty($user_unique[0]) ){ $sql_array[] = "SELECT {$select_fields[0]} FROM se_users WHERE user_id='".$database->database_real_escape_string($user_unique_id)."' LIMIT 1"; $cache = \SECache::getInstance('serial', array('lifetime' => 3600)); /* // Get from cache if( is_object($cache) ) { $this->user_info = $cache->get('user_info_'.$user_unique_id); //if(SE_DEBUG1){echo $this->user_info["user_id"]." ";} }*/ } if( !empty($user_unique[1]) ){ $sql_array[] = "SELECT {$select_fields[0]} FROM se_users WHERE user_username='".$database->database_real_escape_string($user_username)."' LIMIT 1"; } if( !empty($user_unique[2]) ){ $sql_array[] = "SELECT {$select_fields[0]} FROM se_users WHERE user_email='".$database->database_real_escape_string($user_email)."' LIMIT 1"; } if( count($sql_array)>1 ) $sql = '('.join(') UNION (', $sql_array).')'; else $sql = $sql_array[0]; if($this->user_info["user_id"]==""||$this->user_info["user_id"]==0) { $user = $database->database_query($sql); } if($database->database_num_rows($user) == 1||$this->user_info["user_id"]>0) { $this->user_exists = 1; if($this->user_info["user_id"]==0){ $this->user_info = $database->database_fetch_assoc($user); /* if( is_object($cache) ) { $this->user_info = $cache->store($this->user_info, 'user_info_'.$this->user_info["user_id"]); }*/ } $query=$database->database_query("SELECT SUM(points) AS user_points FROM bateworldcom_wall.user_points WHERE user_id={$this->user_info["user_id"]}"); $row=$database->database_fetch_assoc($query); $this->user_points=$row["user_points"]; $ex=explode(".", $this->user_info["user_photo"]); if(is_numeric($ex[0])){ $query=$database->database_query("SELECT approved FROM se_media WHERE media_id='".$ex[0]."'"); $row=$database->database_fetch_assoc($query); if($row["approved"]!=1){$this->user_info["user_photo"]="";} } $query=$database->database_query("SELECT status, id FROM status WHERE user_id={$this->user_info["user_id"]} ORDER by id DESC LIMIT 1"); if($database->database_num_rows($query)>0){ $row=$database->database_fetch_assoc($query); $this->user_info["user_status"]=$row["status"]; $query1=$database->database_query("SELECT * FROM status_media WHERE status_id='".$row["id"]."' ORDER by id DESC"); $i=1; while($row1=$database->database_fetch_assoc($query1)) { if($i==1){$this->user_info["user_status"].="
";} $query2=$database->database_query("SELECT * FROM se_media WHERE media_id='".$row1["media_id"]."'"); $row2=$database->database_fetch_assoc($query2); $this->user_info["user_status"].=""; $i++; } } if($this->user_info["user_enabled"]<="0"&&$this->user_info["user_enabled"]!="-6"&&$adminpage!=1){$this->user_exists = 0;} // SET USER SALT $this->user_salt = $this->user_info['user_code']; // SET DISPLAY NAME (BACKWARDS COMPAT) //$this->user_displayname = $this->user_info['user_displayname']; $this->user_displayname(); // SELECT PROFILE CATEGORY INFO if( !empty($this->user_info['user_profilecat_id']) ) $this->profilecat_info =& \SEUser::getProfileCategoryInfo($this->user_info['user_profilecat_id']); //if(isset($this->user_info["user_profilecat_id"])) { $this->profilecat_info = $database->database_fetch_assoc($database->database_query("SELECT profilecat_id, profilecat_title FROM se_profilecats WHERE profilecat_id=".$this->user_info["user_profilecat_id"]." LIMIT 1")); } // SELECT PROFILE INFO if( !empty($select_fields[1]) ) $this->profile_info =& \SEUser::getProfileValues($this->user_info['user_id']); //if($select_fields[1] != "") { $this->profile_info = $database->database_fetch_assoc($database->database_query("SELECT $select_fields[1] FROM se_profilevalues WHERE profilevalue_user_id='".$this->user_info[user_id]."'")); } // SELECT LEVEL INFO if( !empty($select_fields[2]) ) $this->level_info =& \SEUser::getLevelSettings($this->user_info['user_level_id']); //if($select_fields[2] != "") { $this->level_info = $database->database_fetch_assoc($database->database_query("SELECT * FROM se_levels WHERE level_id='".$this->user_info["user_level_id"]."'")); } // GET USER SETTINGS $this->usersetting_info =& \SEUser::getUserSettings($this->user_info['user_id']); // SELECT SUBNET INFO if( $this->user_info['user_subnet_id'] ) { if( !empty($select_fields[3]) ) $this->subnet_info =& \SECore::getSubnetworkInfo($this->user_info['user_subnet_id']); //if($select_fields[3] != "") { $this->subnet_info = $database->database_fetch_assoc($database->database_query("SELECT subnet_id, subnet_name FROM se_subnets WHERE subnet_id='".$this->user_info["user_subnet_id"]."'")); } } else { $this->subnet_info['subnet_id'] = 0; $this->subnet_info['subnet_name'] = 152; } \SE_Language::_preload($this->subnet_info['subnet_name']); } } } // END SEUser() METHOD function online_now() { global $database; //$online_users_array = online_users(); //if(in_array($this->user_info['user_username'], $online_users_array[2])) { $this->is_online = 1; } else { $this->is_online = 0; } if($this->profile_info["profilevalue_22"]==""){ $profile_query = "SELECT profilevalue_22 FROM se_profilevalues WHERE profilevalue_user_id='".$this->user_info['user_id']."'"; $query=$database->database_query($profile_query); $row=$database->database_fetch_array($query); $this->profile_info["profilevalue_22"]=$row["profilevalue_22"]; } if($this->profile_info["profilevalue_22"]==1){return false;} if($this->user_info['online']==""||$this->user_info['online']==null) { $query=$database->database_query("SELECT `online` FROM se_users WHERE user_id='".$this->user_info['user_id']."'"); $row=$database->database_fetch_array($query); $this->user_info['online']=$row["online"]; } $this->is_online = $this->user_info['online']; return $this->is_online; } function &getLevelSettings($level_id) { static $level_settings; if( !is_array($level_settings) ) $level_settings = array(); if( !isset($level_settings[$level_id]) ) { $cache = \SECache::getInstance('serial', array('lifetime' => 3600)); // Get from cache if( is_object($cache) ) { $level_settings[$level_id] = $cache->get('site_level_settings_'.$level_id); } // Get from database if( !is_array($level_settings[$level_id]) ) { $database = \SEDatabase::getInstance(); $resource = $database->database_query("SELECT * FROM se_levels WHERE level_id='{$level_id}' LIMIT 1"); $level_settings[$level_id] = $database->database_fetch_assoc($resource); // Store in cache if( is_object($cache) ) { $cache->store($level_settings[$level_id], 'site_level_settings_'.$level_id); } } } return $level_settings[$level_id]; } function &getUserSettings($user_id) { static $user_settings; if( !is_array($user_settings) ) $user_settings = array(); if( !isset($user_settings[$user_id]) ) { //if(SE_DEBUG1) { $cache = \SECache::getInstance('serial', array('lifetime' => 7200)); // Get from cache if( is_object($cache) ) { $user_settings[$user_id] = $cache->get('site_user_settings_'.$user_id); } } // Get from database if( !is_array($user_settings[$user_id]) ) { $database = \SEDatabase::getInstance(); $resource = $database->database_query("SELECT * FROM se_usersettings WHERE usersetting_user_id='{$user_id}' LIMIT 1"); $user_settings[$user_id] = $database->database_fetch_assoc($resource); //if(SE_DEBUG1) { // Store in cache if( is_object($cache) ) { $cache->store($user_settings[$user_id], 'site_user_settings_'.$user_id); } } } } return $user_settings[$user_id]; } function &getProfileCategoryInfo($profilecat_id) { static $profile_cats; if( !is_array($profile_cats) ) $profile_cats = array(); if( !isset($profile_cats[$profilecat_id]) ) { $cache = \SECache::getInstance('serial', array('lifetime' => 3600)); // Get from cache if( is_object($cache) ) { $profile_cats[$profilecat_id] = $cache->get('site_profile_categories_'.$profilecat_id); } // Get from database if( !is_array($profile_cats[$profilecat_id]) ) { $database = \SEDatabase::getInstance(); $resource = $database->database_query("SELECT profilecat_id, profilecat_title FROM se_profilecats WHERE profilecat_id='{$profilecat_id}' LIMIT 1"); $profile_cats[$profilecat_id] = $database->database_fetch_assoc($resource); // Store in cache if( is_object($cache) ) { $cache->store($profile_cats[$profilecat_id], 'site_profile_categories_'.$profilecat_id); } } } return $profile_cats[$profilecat_id]; } function &getProfileValues($user_id) { static $user_profiles; if( !is_array($user_profiles) ) $user_profiles = array(); if( !isset($user_profiles[$user_id]) ) { $cache = \SECache::getInstance('serial', array('lifetime' => 3600)); // Get from cache if( is_object($cache) ) { $user_profiles[$user_id] = $cache->get('site_user_profiles_'.$user_id); } // Get from database if( !is_array($user_profiles[$user_id]) ) { $database = \SEDatabase::getInstance(); $resource = $database->database_query("SELECT * FROM se_profilevalues WHERE profilevalue_user_id='{$user_id}' LIMIT 1"); $user_profiles[$user_id] = $database->database_fetch_assoc($resource); // Store in cache if( is_object($cache) ) { $cache->store($user_profiles[$user_id], 'site_user_profiles_'.$user_id); } } } return $user_profiles[$user_id]; } // // THIS METHOD SETS A USER'S DISPLAY NAME // // INPUT: // void // // OUTPUT: // void // function user_displayname() { // SET DISPLAY NAME if( !empty($this->user_info['user_displayname']) && trim($this->user_info['user_displayname']) ) $this->user_displayname = $this->user_info['user_displayname']; elseif( !empty($this->user_info['user_username']) ) $this->user_info['user_displayname'] = $this->user_info['user_username']; elseif( !empty($this->user_info['user_fname']) && !empty($this->user_info['user_lname']) && trim($this->user_info['user_fname']) && trim($this->user_info['user_lname']) ) $this->user_info['user_displayname'] = $this->user_displayname = $this->user_info['user_fname'].' '.$this->user_info['user_lname']; elseif( !empty($this->user_info['user_fname']) && trim($this->user_info['user_fname']) ) $this->user_info['user_displayname'] = $this->user_displayname = $this->user_info['user_fname']; elseif( !empty($this->user_info['user_lname']) && trim($this->user_info['user_lname']) ) $this->user_info['user_displayname'] = $this->user_displayname = $this->user_info['user_lname']; elseif( !empty($this->user_info['user_username']) && trim($this->user_info['user_username']) ) $this->user_info['user_displayname'] = $this->user_displayname = $this->user_info['user_username']; else $this->user_info['user_displayname'] = $this->user_displayname = $this->user_info['user_id']; // $this->user_displayname_short = ( !empty($this->user_info['user_fname']) && trim($this->user_info['user_fname']) ? $this->user_info['user_fname'] : $this->user_info['user_username'] ); $this->user_displayname = $this->user_info['user_displayname']; $this->user_displayname_short = $this->user_displayname; } // END user_displayname() METHOD // // THIS METHOD UPDATES A USER'S DISPLAY NAME IN THE DATABASE // // INPUT: // $mode - Denotes the method used to generate the displayname // // OUTPUT: // void // function user_displayname_update($user_fname=NULL, $user_lname=NULL) { global $setting, $database; // Check user exists and allowed method if( !$this->user_exists || (!$user_fname && !$user_lname) ) return; if( empty($this->usersetting_info) ) $this->user_settings(); $delimiter = ''; $user_displayname = ''; $user_fname = trim((string)$user_fname); $user_lname = trim((string)$user_lname); switch( (int)$this->usersetting_info['usersetting_displayname_method'] ) { // {First name} {Last name} case 1: default: if( $user_fname && $user_lname ) $delimiter = ' '; $user_displayname = $user_fname.$delimiter.$user_lname; break; // {Last name} {First name} case 2: if( $user_fname && $user_lname ) $delimiter = ' '; $user_displayname = $user_lname.$delimiter.$user_fname; break; // {Last name}, {First name} case 3: if( $user_fname && $user_lname ) $delimiter = ', '; $user_displayname = $user_lname.$delimiter.$user_fname; break; // {Last name} case 4: $user_displayname = $user_lname; break; // {First name} case 5: $user_displayname = $user_fname; break; // Custom (TODO) case 6: $user_displayname = sprintf($setting['setting_displayname_method_custom'], $user_fname, $user_lname); break; } // Fallback to username or user id if( !$user_displayname && $user_username ) $user_displayname = $this->user_info['user_username']; elseif( !$user_displayname ) $user_displayname = $this->user_info['user_id']; // Update the current user object? $this->user_info['user_displayname'] = $this->user_displayname = $user_displayname; // Update database $sql = "UPDATE se_users SET user_displayname='".addslashes($user_displayname)."' WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"; $database->database_query($sql); } // END user_displayname_update() METHOD // // THIS METHOD POPULATES THE USERSETTING VARIABLE // // INPUT: // $select_fields (OPTIONAL) REPRESENTING THE FIELDS TO SELECT FROM THE USERSETTINGS TABLE // // OUTPUT: // void // function user_settings($select_fields = "*") { global $database; // $this->usersetting_info =& SEUser::getUserSettings($this->user_info['user_id']); $this->usersetting_info = $database->database_fetch_assoc($database->database_query("SELECT $select_fields FROM se_usersettings WHERE usersetting_user_id='".$this->user_info["user_id"]."'")); } // END user_settings() METHOD // THIS METHOD VERIFIES LOGIN COOKIES, SETS APPROPRIATE OBJECT VARIABLES, AND UPDATES LAST ACTIVE TIME // INPUT: // OUTPUT: function user_checkCookies() { global $database, $setting, $admin, $page; $session_object =& \SESession::getInstance(); // Ignore bots if( strpos($_SERVER['HTTP_USER_AGENT'], 'Googlebot')!==FALSE ) return; if( strpos($_SERVER['HTTP_USER_AGENT'], 'msnbot')!==FALSE ) return; // Check if user exists $user_id = $session_object->get('user_id'); $user_email = $session_object->get('user_email'); $user_pass = $session_object->get('user_pass'); // Check for auth token if( !$user_id ) { $this->user_auth_token_check(); } if( isset($user_id) && isset($user_email) && isset($user_pass) ) { // Only create if not already exists to help with caching if( !$this->user_exists ) { $this->__construct(Array($user_id)); } // VERIFY USER EXISTS, LOGIN COOKIE VALUES ARE CORRECT, AND EMAIL HAS BEEN VERIFIED - ELSE RESET USER CLASS switch( TRUE ) { case ( !$this->user_exists ): case ( $user_email != $this->user_password_crypt($this->user_info['user_email']) ): case ( $user_pass != $this->user_info['user_password'] ): case ( !$this->user_info['user_verified'] && $setting['setting_signup_verify'] ): case ( !$this->user_info['user_enabled'] && (!is_object($admin) || !$admin->admin_exists) ): $this->user_clear(); break; } // MIGHT REMOVE THIS IN FAVOR OF SESSIONS? if( $this->user_exists && time()>$this->user_info['user_lastactive']+600 ) { $time_current = time(); if($this->user_info['verified']==0){ if($this->user_info['user_lastactive']!=$_SERVER['REMOTE_ADDR']) { $detectip=detectIpVersion($_SERVER["REMOTE_ADDR"]); if($detectip==1){ $query=$database->database_query("SELECT * FROM bateworldcom_location.city_ip4, bateworldcom_location.de WHERE bateworldcom_location.city_ip4.geoname_id= bateworldcom_location.de.geoname_id AND (bateworldcom_location.de.country_name='United States' OR bateworldcom_location.de.country_name='United Kingdom') AND INET_ATON('".$_SERVER["REMOTE_ADDR"]."') BETWEEN INET_ATON(SUBSTRING_INDEX(network, '/', 1)) AND INET_ATON(SUBSTRING_INDEX(network, '/', 1)) + POW(2, 32 - CAST(SUBSTRING_INDEX(network, '/', -1) AS UNSIGNED)) - 1 LIMIT 1; ");/*/ $query=$database->database_query("SELECT * FROM bateworldcom_location.city_ip4 FORCE INDEX (idx_ip_range) JOIN bateworldcom_location.de USING (geoname_id) WHERE INET_ATON('".$_SERVER["REMOTE_ADDR"]."') BETWEEN ip_start AND ip_end");*/ $row=$database->database_fetch_array($query); $database->database_query("UPDATE se_users SET user_lastactive='{$time_current}', user_ip_lastactive='{$_SERVER['REMOTE_ADDR']}', online='1', state='".$row["subdivision_1_name"]."', country='".$row["country_name"]."' WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); $this->user_info['state']=$row["subdivision_1_name"]; $this->user_info['country']=$row["country_name"]; } elseif($detectip==2){ $query=$database->database_query("SELECT * FROM bateworldcom_location.city_ip6, bateworldcom_location.de WHERE bateworldcom_location.city_ip6.geoname_id= bateworldcom_location.de.geoname_id AND (bateworldcom_location.de.country_name='United States' OR bateworldcom_location.de.country_name='United Kingdom') AND INET6_ATON('".$_SERVER["REMOTE_ADDR"]."') BETWEEN INET6_ATON(SUBSTRING_INDEX(network, '/', 1)) AND ADDDATE( INET6_ATON(SUBSTRING_INDEX(network, '/', 1)), POW(2, 128 - CAST(SUBSTRING_INDEX(network, '/', -1) AS UNSIGNED)) - 1 ) LIMIT 1; "); $row=$database->database_fetch_array($query); $database->database_query("UPDATE se_users SET user_lastactive='{$time_current}', user_ip_lastactive='{$_SERVER['REMOTE_ADDR']}', online='1', state='".$row["subdivision_1_name"]."', country='".$row["country_name"]."' WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); $this->user_info['state']=$row["subdivision_1_name"]; $this->user_info['country']=$row["country_name"]; } // $database->database_query("UPDATE se_users SET user_lastactive='{$time_current}', user_ip_lastactive='{$_SERVER['REMOTE_ADDR']}', online='1' WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); } } } } // VISITOR HANDLING (ONLY UPDATE ONCE EVERY TWO MINUTES) $user_lastactive = $session_object->get('user_lastactive', 0); if( empty($user_lastactive) || ($user_lastactive < time() - 120) ) { $visitor_ip = ip2long($_SERVER['REMOTE_ADDR']); $visitor_browser = md5($_SERVER['HTTP_USER_AGENT']); $visitor_lastactive = time(); if( $this->user_exists && $this->user_info['user_invisible'] ){ $visitor_invisible = 1; }else{$visitor_invisible = 0;} $visitor_user_id = ( $this->user_exists ? $this->user_info['user_id'] : '0' ); $visitor_user_username = ( $this->user_exists ? "'".addslashes($this->user_info['user_username'])."'" : 'NULL' ); $visitor_user_displayname = ( $this->user_exists ? "'".addslashes($this->user_displayname)."'" : 'NULL' ); $q=$database->database_query("SELECT id FROM se_visitors WHERE visitor_ip='".$database->database_real_escape_string($visitor_ip )."' AND visitor_browser='".$database->database_real_escape_string($visitor_browser )."' AND visitor_user_id='".$database->database_real_escape_string($visitor_user_id )."' LIMIT 1"); if($database->database_num_rows($q)>0){ $e=$database->database_fetch_array($q); $sql = " UPDATE se_visitors SET visitor_ip='{$visitor_ip}', visitor_browser='{$visitor_browser}', visitor_lastactive='{$visitor_lastactive}', visitor_invisible='{$visitor_invisible}', visitor_user_id='{$visitor_user_id}', visitor_user_username='".$database->database_real_escape_string($visitor_user_username)."', visitor_user_displayname='".$database->database_real_escape_string($visitor_user_displayname)."' WHERE id='".$e["id"]."'"; } else{ $sql = " INSERT INTO se_visitors ( visitor_ip, visitor_browser, visitor_lastactive, visitor_invisible, visitor_user_id, visitor_user_username, visitor_user_displayname ) VALUES ( '{$visitor_ip}', '{$visitor_browser}', '{$visitor_lastactive}', '{$visitor_invisible}', '{$visitor_user_id}', {$visitor_user_username}, /* PRE-QUOTED */ {$visitor_user_displayname} /* PRE-QUOTED */ ) ON DUPLICATE KEY UPDATE visitor_lastactive=VALUES(visitor_lastactive), visitor_invisible=VALUES(visitor_invisible)/* visitor_lastactive='{$visitor_lastactive}', visitor_invisible='{$visitor_invisible}' /* , visitor_user_id='{$visitor_user_id}', visitor_user_username='{$visitor_user_username}', visitor_user_displayname='{$visitor_user_displayname}' */ "; /* $sql = " INSERT INTO se_visitors ( visitor_ip, visitor_browser, visitor_lastactive, visitor_invisible, visitor_user_id, visitor_user_username, visitor_user_displayname ) VALUES ( '{$visitor_ip}', '{$visitor_browser}', '{$visitor_lastactive}', '{$visitor_invisible}', '{$visitor_user_id}', {$visitor_user_username}, {$visitor_user_displayname} )";*/ } $database->database_query($sql); // UPDATE USER LAST ACTIVE IF LOGGED IN if( $this->user_exists ) { if($this->user_info['verified']==0){ if($this->user_info['user_lastactive']!=$_SERVER['REMOTE_ADDR']) { //$rand=rand(0,4); $rand=1; if($rand==1) { if(detectIpVersion($_SERVER["REMOTE_ADDR"])==1){ $query=$database->database_query("SELECT * FROM bateworldcom_location.city_ip4, bateworldcom_location.de WHERE bateworldcom_location.city_ip4.geoname_id= bateworldcom_location.de.geoname_id AND (bateworldcom_location.de.country_name='United States' OR bateworldcom_location.de.country_name='United Kingdom') AND INET_ATON('".$_SERVER["REMOTE_ADDR"]."') BETWEEN INET_ATON(SUBSTRING_INDEX(network, '/', 1)) AND INET_ATON(SUBSTRING_INDEX(network, '/', 1)) + POW(2, 32 - CAST(SUBSTRING_INDEX(network, '/', -1) AS UNSIGNED)) - 1 LIMIT 1; ");/*/ $query=$database->database_query("SELECT * FROM bateworldcom_location.city_ip4 FORCE INDEX (idx_ip_range) JOIN bateworldcom_location.de USING (geoname_id) WHERE INET_ATON('".$_SERVER["REMOTE_ADDR"]."') BETWEEN ip_start AND ip_end");*/ $row=$database->database_fetch_array($query); $database->database_query("UPDATE se_users SET user_lastactive='{$time_current}', user_ip_lastactive='{$_SERVER['REMOTE_ADDR']}', online='1', state='".$row["subdivision_1_name"]."', country='".$row["country_name"]."' WHERE user_id='{$visitor_user_id}' LIMIT 1"); $this->user_info['state']=$row["subdivision_1_name"]; $this->user_info['country']=$row["country_name"]; } elseif(detectIpVersion($_SERVER["REMOTE_ADDR"])==2){ $query=$database->database_query("SELECT * FROM bateworldcom_location.city_ip6, bateworldcom_location.de WHERE bateworldcom_location.city_ip6.geoname_id= bateworldcom_location.de.geoname_id AND (bateworldcom_location.de.country_name='United States' OR bateworldcom_location.de.country_name='United Kingdom') AND INET6_ATON('".$_SERVER["REMOTE_ADDR"]."') BETWEEN INET6_ATON(SUBSTRING_INDEX(network, '/', 1)) AND ADDDATE( INET6_ATON(SUBSTRING_INDEX(network, '/', 1)), POW(2, 128 - CAST(SUBSTRING_INDEX(network, '/', -1) AS UNSIGNED)) - 1 ) LIMIT 1; "); $row=$database->database_fetch_array($query); $database->database_query("UPDATE se_users SET user_lastactive='{$time_current}', user_ip_lastactive='{$_SERVER['REMOTE_ADDR']}', online='1', state='".$row["subdivision_1_name"]."', country='".$row["country_name"]."' WHERE user_id='{$visitor_user_id}' LIMIT 1"); $this->user_info['state']=$row["subdivision_1_name"]; $this->user_info['country']=$row["country_name"]; } } } $states=array(); if($this->user_info["verified"]==0&&$this->user_info["safefromverify"]==0){ //if(SE_DEBUG1){echo "bbb";exit;} $states[]="Louisiana"; $states[]="Utah"; $states[]="Mississippi"; $states[]="Virginia"; $states[]="Arkansas"; $states[]="Texas"; $states[]="Montana"; $states[]="North Carolina"; $states[]="Idaho"; $states[]="Kansas"; $states[]="Kentucky"; $states[]="Nebraska"; $states[]="Indiana"; $states[]="Alabama"; $states[]="Oklahoma"; $states[]="Florida"; $states[]="South Carolina"; $states[]="Tennessee"; $states[]="Missouri"; $states[]="Georgia"; $states[]="Wyoming"; $states[]="South Dakota"; $states[]="North Dakota"; $states[]="Arizona"; $states[]="Ohio"; if($page != "loggedout/requiredverify"&&$page != "loggedout/requiredverifyfl"&&$page != "loggedout/blocked"&&$page != "loggedout/requiredverify2"&&$page != "verified"&&$page != "login"&&$page != "signup-confirm"&&$page != "set_password"&&$page != "setpassword"&&$page != "settings"&&$page != "verify"&&$page != "misc_js"&&$page != "logout"&&$page != "user_logout"&&$page != "user_account_delete"&&$page != "verified1"){ header("Cache-Control: no-store, no-cache, must-revalidate, max-age=0"); header("Pragma: no-cache"); header("Expires: Sat, 01 Jan 2000 00:00:00 GMT"); if($this->user_info["country"]=="United States"){ if(in_array($this->user_info["state"], $states)) { if($this->user_info["state"]=="North Carolina"||$this->user_info["state"]=="Alabama"){ header("LOCATION: /blocked.php"); exit; } if($this->user_info["state"]=="Florida"){ header("LOCATION: /requiredverifyfl.php"); exit; }else{ header("LOCATION: /requiredverify.php"); exit; } } } elseif($user->user_info["country"]=="United Kingdom"){ header("LOCATION: /requiredverify.php"); exit;} elseif($user->user_info["country"]=="France"){ header("LOCATION: /requiredverify.php"); exit;} } } } //$database->database_query("UPDATE se_users SET user_lastactive='{$time_current}', user_ip_lastactive='{$_SERVER['REMOTE_ADDR']}', online='1' WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); $sql = "UPDATE se_users SET user_lastactive='{$visitor_lastactive}', user_ip_lastactive='{$_SERVER['REMOTE_ADDR']}', online='1' WHERE user_id='{$visitor_user_id}' LIMIT 1"; //$database->database_query($sql); } $session_object->set('user_lastactive', $visitor_lastactive); //setcookie("se_user_lastactive", , 0, "/"); } // REMOVE OLD VISITORS (20% chance) /*if( rand(1,100)<5 ) { $removal_limit = time() - 600; $sql = "DELETE FROM se_visitors WHERE visitor_lastactive<'{$removal_limit}'"; $database->database_query($sql); }*/ } // END user_checkCookies() METHOD // THIS METHOD VERIFIES LOGIN COOKIES, SETS APPROPRIATE OBJECT VARIABLES, AND UPDATES LAST ACTIVE TIME // INPUT: // OUTPUT: function user_checkCookies1() { global $database, $setting, $admin; $session_object =& \SESession::getInstance(); // Ignore bots if( strpos($_SERVER['HTTP_USER_AGENT'], 'Googlebot')!==FALSE ) return; if( strpos($_SERVER['HTTP_USER_AGENT'], 'msnbot')!==FALSE ) return; // Check if user exists $user_id = $session_object->get('user_id'); $user_email = $session_object->get('user_email'); $user_pass = $session_object->get('user_pass'); // Check for auth token if( !$user_id ) { $this->user_auth_token_check(); } if( isset($user_id) && isset($user_email) && isset($user_pass) ) { // Only create if not already exists to help with caching if( !$this->user_exists ) { $this->__construct(Array($user_id)); } // VERIFY USER EXISTS, LOGIN COOKIE VALUES ARE CORRECT, AND EMAIL HAS BEEN VERIFIED - ELSE RESET USER CLASS switch( TRUE ) { case ( !$this->user_exists ): case ( $user_email != $this->user_password_crypt($this->user_info['user_email']) ): case ( $user_pass != $this->user_info['user_password'] ): case ( !$this->user_info['user_verified'] && $setting['setting_signup_verify'] ): case ( !$this->user_info['user_enabled'] && (!is_object($admin) || !$admin->admin_exists) ): $this->user_clear(); break; } // MIGHT REMOVE THIS IN FAVOR OF SESSIONS? if( $this->user_exists && time()>$this->user_info['user_lastactive']+600 ) { $time_current = time(); $database->database_query("UPDATE se_users SET user_lastactive='{$time_current}', user_ip_lastactive='{$_SERVER['REMOTE_ADDR']}', online='1' WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); } } // VISITOR HANDLING (ONLY UPDATE ONCE EVERY TWO MINUTES) $user_lastactive = $session_object->get('user_lastactive', 0); if( empty($user_lastactive) || ($user_lastactive < time() - 120) ) { $visitor_ip = ip2long($_SERVER['REMOTE_ADDR']); $visitor_browser = md5($_SERVER['HTTP_USER_AGENT']); $visitor_lastactive = time(); $visitor_invisible = (bool) ( $this->user_exists && $this->user_info['user_invisible'] ); $visitor_user_id = ( $this->user_exists ? $this->user_info['user_id'] : '0' ); $visitor_user_username = ( $this->user_exists ? "'".addslashes($this->user_info['user_username'])."'" : 'NULL' ); $visitor_user_displayname = ( $this->user_exists ? "'".addslashes($this->user_displayname)."'" : 'NULL' ); $sql = " INSERT INTO se_visitors ( visitor_ip, visitor_browser, visitor_lastactive, visitor_invisible, visitor_user_id, visitor_user_username, visitor_user_displayname ) VALUES ( '{$visitor_ip}', '{$visitor_browser}', '{$visitor_lastactive}', '{$visitor_invisible}', '{$visitor_user_id}', {$visitor_user_username}, /* PRE-QUOTED */ {$visitor_user_displayname} /* PRE-QUOTED */ ) ON DUPLICATE KEY UPDATE visitor_lastactive=VALUES(visitor_lastactive), visitor_invisible=VALUES(visitor_invisible)/* visitor_lastactive='{$visitor_lastactive}', visitor_invisible='{$visitor_invisible}' /* , visitor_user_id='{$visitor_user_id}', visitor_user_username='{$visitor_user_username}', visitor_user_displayname='{$visitor_user_displayname}' */ "; //$database->database_query($sql); // UPDATE USER LAST ACTIVE IF LOGGED IN if( $this->user_exists ) { $sql = "UPDATE se_users SET user_lastactive='{$visitor_lastactive}', user_ip_lastactive='{$_SERVER['REMOTE_ADDR']}', online='1' WHERE user_id='{$visitor_user_id}' LIMIT 1"; //$database->database_query($sql); } //$session_object->set('user_lastactive', $visitor_lastactive); //setcookie("se_user_lastactive", , 0, "/"); } } // THIS METHOD TRIES TO LOG A USER IN IF THERE IS NO ERROR // INPUT: $email REPRESENTING THE LOGIN EMAIL // $password REPRESENTING THE LOGIN PASSWORD // $javascript_disabled (OPTIONAL) A BOOLEAN REPRESENTING WHETHER JAVASCRIPT IS DISABLED OR NOT // $persistent (OPTIONAL) A BOOLEAN SPECIFYING WHETHER COOKIES SHOULD BE PERSISTENT OR NOT // OUTPUT: function user_login($email, $password, $javascript_disabled = 0, $persistent = 0) { global $database, $setting; $this->__construct(Array(0, "", $email)); $current_time = time(); $login_result = 0; if($this->user_info['user_enabled']==0){ if($this->user_info["user_id"]>0){ if($this->user_info['pendingdelete']!=0) { $database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='{$this->user_info['user_id']}', time='".time()."', action='User has cancelled their profile deletion by logging in'"); $database->database_query("UPDATE se_users SET pendingdelete='0', activitystatuschangedate='".time()."' WHERE user_id='".$this->user_info["user_id"]."'"); } else { $database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='{$this->user_info['user_id']}', time='".time()."', action='User has re-enabled their account by logging in'"); if($this->user_info['user_id']==0){mail("leprakhauns@gmail.com", "User logged in???", var_export($this, true));} } } $this->user_info['user_enabled']=1; $this->user_exists=1; $setemailon=1;} // SHOW ERROR IF JAVASCRIPT IS DIABLED if( $javascript_disabled ) { $this->is_error = 31; } elseif($this->user_info['user_enabled']==-6) { $login_result = TRUE; $this->user_setcookies($persistent); $database->database_query("INSERT INTO se_logins (login_email, login_date, login_ip, login_result) VALUES ('{$email}', '{$current_time}', '{$_SERVER['REMOTE_ADDR']}', '{$login_result}')"); $database->database_query("UPDATE se_users SET user_lastlogindate='{$current_time}', user_logins=user_logins+1, user_lastactive='{$current_time}', user_ip_lastactive='{$_SERVER['REMOTE_ADDR']}', online='1' WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); header("Location: verifying.php"); exit; } // SHOW ERROR IF NO USER ROW FOUND elseif($this->user_exists == 0) { $this->is_error = 676; } // VALIDATE PASSWORD elseif( !trim($password) || $this->user_password_crypt($password) != $this->user_info['user_password'] ) { //if(SE_DEBUG1){echo $this->user_password_crypt($password); exit;} $this->is_error = 676; } // CHECK IF USER IS ENABLED elseif( $this->user_info['user_enabled']==-1||$this->user_info['user_enabled']==-2 ) { $this->is_error = 677; } elseif( $this->user_info['user_enabled']==-5||$this->user_info['user_enabled']==-4) { $this->is_error = "a41"; } // CHECK IF EMAIL IS VERIFIED elseif( !$this->user_info['user_verified'] && $setting['setting_signup_verify'] ) { $this->is_error = 678; } // INITIATE LOGIN AND ENCRYPT COOKIES else { if($this->user_info['user_enabled']==0){$this->user_info['user_enabled']=1;} // SET LOGIN RESULT VAR $login_result = TRUE; // UPDATE USER LOGIN INFO $database->database_query("UPDATE se_users SET user_enabled=1, user_lastlogindate='{$current_time}', user_logins=user_logins+1, user_lastactive='{$current_time}', user_ip_lastactive='{$_SERVER['REMOTE_ADDR']}', online='1' WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); if($setemailon==1) { $database->database_query("UPDATE se_users SET user_pdp_evc=1 WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); } // LOG USER IN $this->user_setcookies($persistent); // FIX VISITOR TABLE $visitor_ip = ip2long($_SERVER['REMOTE_ADDR']); $visitor_browser = md5($_SERVER['HTTP_USER_AGENT']); $database->database_query("DELETE FROM se_visitors WHERE visitor_ip='{$visitor_ip}' && visitor_browser LIKE '{$visitor_browser}' && visitor_user_id='0'"); // UPDATE LOGIN STATS update_stats("logins"); } // BUMP LOG $database->database_query("INSERT INTO se_logins (login_email, login_date, login_ip, login_result) VALUES ('{$email}', '{$current_time}', '{$_SERVER['REMOTE_ADDR']}', '{$login_result}')"); bumplog(); } // END user_login() METHOD function user_friend_needingconfirmation($other_user_id, $friend_status = 1) { global $database; $resource = $database->database_query(" SELECT friend_id FROM se_friends WHERE friend_user_id1='{$other_user_id}' && friend_user_id2='{$this->user_info['user_id']}' && friend_status='{$friend_status}' "); if($database->database_num_rows($resource)>0) { return true; } else{return false;} //return (int) $database->database_num_rows($resource); } // // THIS METHOD SETS USER LOGIN COOKIES // // INPUT: // $persistent (OPTIONAL) REPRESENTING WHETHER THE COOKIES SHOULD BE PERSISTENT OR NOT // // OUTPUT: // void // function user_setcookies($persistent = false) { // TODO: PERSISTENT $session_object =& \SESession::getInstance(); $user_id = ( !empty($this->user_info['user_id']) ? $this->user_info['user_id'] : '' ); $user_email = ( !empty($this->user_info['user_email']) ? $this->user_password_crypt($this->user_info['user_email']) : '' ); $user_password = ( !empty($this->user_info['user_password']) ? $this->user_info['user_password'] : '' ); // We don't need to do this any more because of the auth tokens // Set cookie parameters $cookie_lifetime = ( $persistent ? time() + (60 * 60 * 24 * 30 * 6) : 0 ); $host = "bateworld.com"; //setcookie('se_auth_token', $id, $cookie_lifetime, '/', $host); //if( $cookie_lifetime ) //{ // session_set_cookie_params(10);//$cookie_lifetime); //} // Get new id for security $session_object->copy(); // Set user login info $session_object->set('user_id', $user_id); $session_object->set('user_email', $user_email); $session_object->set('user_pass', $user_password); $session_object->set('user_persist', (bool) $persistent); $session_object->set('user_lastactive', time() - 3600); // Create new key if logging in, delete old key if logging out if( $user_id ) { //unset($_COOKIE["user_id"]); //setcookie("user_id", $user_id,-1); setcookie("user_id", $user_id, $cookie_lifetime, '/', $host); $this->user_auth_token_create((bool)$persistent); } else { $this->user_auth_token_delete(); } } // END user_setcookies() METHOD // THIS METHOD CLEARS ALL THE CURRENT OBJECT VARIABLES // INPUT: // OUTPUT: function user_clear() { $this->is_error = FALSE; $this->user_exists = FALSE; $this->user_info = array(); $this->profile_info = array(); $this->level_info = array(); $this->subnet_info = array(); $this->new_pms_total = 0; $this->friend_requests_total = 0; } // END user_clear() METHOD // THIS METHOD LOGS A USER OUT // INPUT: // OUTPUT: function user_logout() { global $database; $session_object =& \SESession::getInstance(); // REMOVE AUTH TOKEN $this->user_auth_token_delete(); // CLEAR LAST ACTIVITY DATE $database->database_query("DELETE FROM se_visitors WHERE visitor_user_id='{$this->user_info['user_id']}'"); $database->database_query("UPDATE se_users SET `online`=0 WHERE user_id='{$this->user_info['user_id']}'"); $session_object->clear('user_lastactive'); // CREATE PLAINTEXT USER EMAIL COOKIE WHILE LOGGED OUT setcookie("prev_email", $this->user_info['user_email'], time()+99999999, "/"); $this->user_clear(); $this->user_setcookies(); setcookie("user_id", $user_id,-1); } // END user_logout() METHOD // THIS METHOD VALIDATES USER ACCOUNT INPUT // INPUT: $email REPRESENTING THE DESIRED EMAIL // $username REPRESENTING THE DESIRED USERNAME // OUTPUT: function user_account($email, $username, $return_json="") { global $database, $setting; // MAKE SURE FIELDS ARE FILLED OUT if( !trim($email) || (!trim($username) && $setting['setting_username'])){ $this->is_error = 51; if($return_json==1){http_response_code(400); echo json_encode(['success' => false, 'errors' => $this->is_error, "error"=>"You're missing a field"]); exit;} } // MAKE SURE USERNAME IS ALPHANUMERIC if( preg_match('~[^A-Za-z0-9]~', $username) && $setting['setting_username'] ){ $this->is_error = 694; if($return_json==1){http_response_code(400); echo json_encode(['success' => false, 'errors' => $this->is_error, "error"=>"Your username must be alphanumeric"]);exit;} } if(!$this->allowedusername($username)) { $this->is_error = 695; if($return_json==1){http_response_code(400); echo json_encode(['success' => false, 'errors' => $this->is_error, "error"=>"Your username is not allowed"]);exit;} } // MAKE SURE USERNAME IS NOT BANNED $banned_usernames = explode(",", strtolower($setting['setting_banned_usernames'])); if( in_array(strtolower($username), $banned_usernames) && trim($username) && $setting['setting_username'] ){ $this->is_error = 695; if($return_json==1){http_response_code(400); echo json_encode(['success' => false, 'errors' => $this->is_error, "error"=>"Your username is not allowed"]);exit;} } // MAKE SURE USERNAME IS NOT RESERVED if( is_dir($username) && $setting['setting_username'] ) $this->is_error = 696; // MAKE SURE EMAIL IS NOT BANNED $banned_emails = explode(",", strtolower($setting['setting_banned_emails'])); $wildcard_ban = "*".strstr(strtolower($email), "@"); if( trim($email) && in_array(strtolower($email), $banned_emails) ) $this->is_error = 697; if( trim($email) && in_array(strtolower($wildcard_ban), $banned_emails) ) $this->is_error = 697; // MAKE SURE EMAIL IS VALID if( !is_email_address($email) ) $this->is_error = 698; // MAKE SURE USERNAME IS UNIQUE $lowercase_username = strtolower($username); if( $setting['setting_username'] && strtolower($this->user_info['user_username']) != $lowercase_username ) { $username_query = $database->database_query("SELECT user_username FROM se_users WHERE user_username='{$lowercase_username}' LIMIT 1"); if( $database->database_num_rows($username_query) ){ $this->is_error = 699; if($return_json==1){http_response_code(400); echo json_encode(['success' => false, 'errors' => $this->is_error, "error"=>"The username you provided has already been taken."]);exit;} } } // MAKE SURE EMAIL IS UNIQUE $lowercase_email = strtolower($email); if( strtolower($this->user_info['user_email']) != $lowercase_email ) { $email_query = $database->database_query("SELECT user_email FROM se_users WHERE user_email='{$lowercase_email}' LIMIT 1"); if( $database->database_num_rows($email_query) ){ $this->is_error = 700; if($return_json==1){http_response_code(400); echo json_encode(['success' => false, 'errors' => $this->is_error, "error"=>"The email address you provided has already been taken."]);exit;} } } } // END user_account() METHOD function user_account_admin($email, $username) { global $database, $setting; // MAKE SURE FIELDS ARE FILLED OUT if( !trim($email) || (!trim($username) && $setting['setting_username'])) $this->is_error = 51; // MAKE SURE USERNAME IS ALPHANUMERIC if( preg_match('~[^A-Za-z0-9]~', $username) && $setting['setting_username'] ) $this->is_error = 694; if(!$this->allowedusername($username)) { $this->is_error = 695; } // MAKE SURE USERNAME IS NOT BANNED $banned_usernames = explode(",", strtolower($setting['setting_banned_usernames'])); if( in_array(strtolower($username), $banned_usernames) && trim($username) && $setting['setting_username'] ) $this->is_error = 695; // MAKE SURE USERNAME IS NOT RESERVED if( is_dir($username) && $setting['setting_username'] ) $this->is_error = 696; // MAKE SURE EMAIL IS NOT BANNED $banned_emails = explode(",", strtolower($setting['setting_banned_emails'])); $wildcard_ban = "*".strstr(strtolower($email), "@"); if( trim($email) && in_array(strtolower($email), $banned_emails) ) //$this->is_error = 697; if( trim($email) && in_array(strtolower($wildcard_ban), $banned_emails) ) ///$this->is_error = 697; // MAKE SURE EMAIL IS VALID if( !is_email_address($email) ) $this->is_error = 698; // MAKE SURE USERNAME IS UNIQUE $lowercase_username = strtolower($username); if( $setting['setting_username'] && strtolower($this->user_info['user_username']) != $lowercase_username ) { $username_query = $database->database_query("SELECT user_username FROM se_users WHERE user_username='{$lowercase_username}' LIMIT 1"); if( $database->database_num_rows($username_query) ) $this->is_error = 699; } // MAKE SURE EMAIL IS UNIQUE $lowercase_email = strtolower($email); if( strtolower($this->user_info['user_email']) != $lowercase_email ) { $email_query = $database->database_query("SELECT user_email FROM se_users WHERE user_email='{$lowercase_email}' LIMIT 1"); if( $database->database_num_rows($email_query) ) $this->is_error = 700; } } function allowedusername($username) { global $setting; $split=explode(",", $setting["username_bans"]); foreach($split as $s) { if(strpos(strtolower($username), trim(strtolower($s)))!==false) { return false; } } return true; } // THIS METHOD VALIDATES USER PASSWORD INPUT // INPUT: $password_old REPRESENTING THE EXISTING PASSWORD // $password REPRESENTING THE DESIRED PASSWORD // $password_confirm REPRESENTING THE PASSWORD CONFIRMATION FIELD // $check_old (OPTIONAL) REPRESENTING WHETHER THE OLD PASSWORD SHOULD BE VERIFIED OR NOT // OUTPUT: function user_password($password_old, $password, $password_confirm, $check_old = 1) { // CHECK FOR EMPTY PASSWORDS if( !trim($password) || !trim($password_confirm) || ($check_old && !trim($password_old)) ) $this->is_error = 51; // CHECK FOR OLD PASSWORD MATCH if( $check_old && $this->user_password_crypt($password_old) != $this->user_info['user_password'] ) $this->is_error = 701; // MAKE SURE BOTH PASSWORDS ARE IDENTICAL if( $password != $password_confirm ) $this->is_error = 702; // MAKE SURE PASSWORD IS LONGER THAN 5 CHARS if( trim($password) && strlen($password) < 8 ) $this->is_error = 703; // MAKE SURE PASSWORD IS ALPHANUMERIC //if( preg_match('~[^A-Za-z0-9]~', $password) ) //$this->is_error = 704; } // END user_password() METHOD // THIS METHOD ENCRYPTS A USERS PASsWORD // INPUT: UNENCRYPTED PASSWORD // OUTPUT: ENCRYPTED PASSWORD function user_password_crypt($user_password) { global $setting; if( !$this->user_exists ) { $method = $setting['setting_password_method']; $this->user_salt = randomcode($setting['setting_password_code_length']); } else { $method = $this->user_info['user_password_method']; } // For new methods if( $method>0 ) { if( !empty($this->user_salt) ) { list($salt1, $salt2) = str_split($this->user_salt, ceil(strlen($this->user_salt) / 2)); $salty_password = $salt1.$user_password.$salt2; } else { $salty_password = $user_password; } } switch( $method ) { // crypt() default: case 0: $user_password_crypt = crypt($user_password, '$1$'.str_pad(substr($this->user_salt, 0, 8), 8, '0', STR_PAD_LEFT).'$'); break; // md5() case 1: $user_password_crypt = md5($salty_password); break; // sha1() case 2: $user_password_crypt = sha1($salty_password); break; // crc32() case 3: $user_password_crypt = sprintf("%u", crc32($salty_password)); break; } return $user_password_crypt; } // END user_password_crypt() METHOD // THIS METHOD RETURNS A SUBNETWORK ID DEPENDENT ON GIVEN INPUTS // INPUT: $email (OPTIONAL) REPRESENTING THE USER'S EMAIL // $category (OPTIONAL) REPRESENTING THE USER'S PROFILE CATEGORY // $profile_info (OPTIONAL) REPRESENTING THE USER'S PROFILE INFO // OUTPUT: RETURNS AN ARRAY CONTAINING THE SUBNETWORK ID AND RESULT STRINGS function user_subnet_select($email = "", $category = "", $profile_info = "") { global $database, $datetime, $setting; // SET DEFAULTS if( !$email ) $email = $this->user_info['user_email']; if( !$category ) $category = $this->user_info['user_profilecat_id']; if( !$profile_info ) $profile_info = $this->profile_info; $subnet_id = ( $this->user_info['user_subnet_id'] ? $this->user_info['user_subnet_id'] : 0 ); // DETERMINE USER'S PRIMARY SUBNETWORK FIELD VALUE $field1_val = ""; switch($setting['setting_subnet_field1_id']) { case -2: break; case -1: $field1_val = $category; break; case 0: $field1_val = $email; break; default: $field1 = $database->database_query("SELECT profilefield_id AS field_id, profilefield_special AS field_special FROM se_profilefields WHERE profilefield_id='{$setting['setting_subnet_field1_id']}'"); if( $database->database_num_rows($field1) ) { $field1_info = $database->database_fetch_assoc($field1); if( $field1_info['field_special'] == 1 ) { $field1_val = $datetime->age($profile_info["profilevalue_".$field1_info['field_id']]); } else { $field1_val = $profile_info["profilevalue_".$field1_info['field_id']]; } } } // DETERMINE USER'S SECONDARY SUBNETWORK FIELD VALUE $field2_val = ""; switch($setting['setting_subnet_field2_id']) { case -2: break; case -1: $field2_val = $category; break; case 0: $field2_val = $email; break; default: $field2 = $database->database_query("SELECT profilefield_id AS field_id, profilefield_special AS field_special FROM se_profilefields WHERE profilefield_id='{$setting['setting_subnet_field2_id']}'"); if( $database->database_num_rows($field2) ) { $field2_info = $database->database_fetch_assoc($field2); if($field2_info['field_special'] == 1) { $field2_val = $datetime->age($profile_info["profilevalue_".$field2_info['field_id']]); } else { $field2_val = $profile_info["profilevalue_".$field2_info['field_id']]; } } } // IF FIELD VALUES NOT EMPTY, RUN QUERY if( $field1_val ) { // SET NUMERICAL VALUES $field1_val_num = "'{$field1_val}'"; $field2_val_num = "'{$field2_val}'"; if(is_numeric($field1_val)) { $field1_val_num = str_replace(" ", "", $field1_val); } if(is_numeric($field2_val)) { $field2_val_num = str_replace(" ", "", $field2_val); } /* // SET SUBNETWORK QUERY $subnet_query = "SELECT subnet_id, subnet_name FROM se_subnets WHERE ( (subnet_field1_qual='==' AND '{$field1_val}' LIKE REPLACE(subnet_field1_value, '*', '%')) OR (subnet_field1_qual='!=' AND '{$field1_val}' NOT LIKE REPLACE(subnet_field1_value, '*', '%')) OR (subnet_field1_qual='>' AND subnet_field1_value<'{$field1_val_num}') OR (subnet_field1_qual='<' AND subnet_field1_value>'{$field1_val_num}') OR (subnet_field1_qual='>=' AND subnet_field1_value<='{$field1_val_num}') OR (subnet_field1_qual='<=' AND subnet_field1_value>='{$field1_val_num}') OR (subnet_field1_qual='' AND subnet_field1_value='') ) AND ( (subnet_field2_qual='==' AND '{$field2_val}' LIKE REPLACE(subnet_field2_value, '*', '%')) OR (subnet_field2_qual='!=' AND '{$field2_val}' NOT LIKE REPLACE(subnet_field2_value, '*', '%')) OR (subnet_field2_qual='>' AND subnet_field2_value<'{$field2_val_num}') OR (subnet_field2_qual='<' AND subnet_field2_value>'{$field2_val_num}') OR (subnet_field2_qual='>=' AND subnet_field2_value<='{$field2_val_num}') OR (subnet_field2_qual='<=' AND subnet_field2_value>='{$field2_val_num}') OR (subnet_field2_qual='' AND subnet_field2_value='') ) LIMIT 1"; // RUN SUBNETWORK QUERY AND FIND USER'S SUBNETWORK ID $subnet = $database->database_query($subnet_query); if( $database->database_num_rows($subnet) ) { $subnet_info = $database->database_fetch_assoc($subnet); $subnet_id = $subnet_info['subnet_id']; } else { $subnet_id = 0; }*/ $subnet_id = 0; } // IF SUBNETWORK CHANGED, ADD NOTE if( $subnet_id != $this->user_info['user_subnet_id'] ) { $new_subnet = ( $subnet_id ? $subnet_info['subnet_name'] : 152 ); } return Array($subnet_id, $new_subnet, $this->subnet_info['subnet_name']); } // END user_subnet_select() METHOD // THIS METHOD UPDATES THE USER'S LAST UPDATE DATE // INPUT: // OUTPUT: function user_lastupdate() { global $database; $database->database_query("UPDATE se_users SET user_dateupdated='".time()."' WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); } // END user_lastupdate() METHOD // THIS METHOD OUTPUTS THE PATH TO THE USER'S PHOTO OR THE GIVEN NOPHOTO IMAGE // INPUT: $nophoto_image (OPTIONAL) REPRESENTING THE PATH TO AN IMAGE TO OUTPUT IF NO PHOTO EXISTS // $thumb (OPTIONAL) REPRESENTING WHETHER TO RETRIEVE THE SQUARE THUMBNAIL OR NOT // OUTPUT: A STRING CONTAINING THE PATH TO THE USER'S PHOTO function user_photo($nophoto_image = "", $thumb = FALSE) { global $url; //if( !$user->user_exists || !$this->user_info['user_photo'] ) if( !$this->user_info['user_photo'] ) return $nophoto_image; $this->user_info['user_photo']=str_replace("_thumb", "", $this->user_info['user_photo']); $user_photo = $url->url_userdir($this->user_info['user_id']).$this->user_info['user_photo']; if( $thumb ) { $user_thumb = substr($user_photo, 0, strrpos($user_photo, "."))."_thumb".substr($user_photo, strrpos($user_photo, ".")); //if( file_exists($user_thumb) ){ $user_thumb=str_replace("./", "", $user_thumb); return IMAGECDN1.$user_thumb; //} } //if( file_exists($user_photo) ){ $user_photo = $url->cloud_userdir($this->user_info['user_id']).$this->user_info['user_photo']; return $user_photo; //} return $nophoto_image; } function user_photo_admin($nophoto_image = "", $thumb = FALSE) { global $url; //if( !$user->user_exists || !$this->user_info['user_photo'] ) if( !$this->user_info['user_photo'] ) return $nophoto_image; $user_photo = "../".$url->url_userdir($this->user_info['user_id']).$this->user_info['user_photo']; if( $thumb ) { $user_thumb = substr($user_photo, 0, strrpos($user_photo, "."))."_thumb".substr($user_photo, strrpos($user_photo, ".")); if( file_exists($user_thumb) ){ $user_thumb=str_replace("./", "", $user_thumb); return IMAGECDN.$user_thumb; } } //if( file_exists($user_photo) ) { $user_photo = IMAGECDN1.str_replace("./", "", $url->url_userdir($this->user_info['user_id']).$this->user_info['user_photo']); return $user_photo;} return $nophoto_image; } function user_photo1($nophoto_image = "", $thumb = FALSE) { global $url; //if( !$user->user_exists || !$this->user_info['user_photo'] ) if( !$this->user_info['user_photo'] ){ return $nophoto_image;} $user_photo = $url->url_userdir($this->user_info['user_id']).$this->user_info['user_photo']; if( $thumb ) { $user_thumb = substr($user_photo, 0, strrpos($user_photo, "."))."_thumb".substr($user_photo, strrpos($user_photo, ".")); return IMAGECDN1.str_replace("../", "", str_replace("./", "", $user_thumb)); } return IMAGECDN1.str_replace("../", "", str_replace("./", "", $user_photo)); return substr($user_photo,1); return $nophoto_image; } // END user_photo() METHOD // THIS METHOD UPLOADS A USER PHOTO ACCORDING TO SPECIFICATIONS AND RETURNS USER PHOTO // INPUT: $photo_name REPRESENTING THE NAME OF THE FILE INPUT // OUTPUT: function user_photo_upload($photo_name) { global $database, $url; // ENSURE USER DIRECTORY IS ADDED $user_directory = $url->url_userdir($this->user_info['user_id']); $user_path_array = explode("/", $user_directory); array_pop($user_path_array); array_pop($user_path_array); $subdir = implode("/", $user_path_array)."/"; /*if( !is_dir($subdir) ) { mkdir($subdir, 0777); chmod($subdir, 0777); $handle = fopen($subdir."index.php", 'x+'); fclose($handle); } if( !is_dir($user_directory) ) { mkdir($user_directory, 0777); chmod($user_directory, 0777); $handle = fopen($user_directory."/index.php", 'x+'); fclose($handle); }*/ // SET KEY VARIABLES $file_maxsize = "4194304"; $file_exts = explode(",", str_replace(" ", "", strtolower($this->level_info['level_photo_exts']))); $file_types = explode(",", str_replace(" ", "", strtolower("image/jpeg, image/jpg, image/jpe, image/pjpeg, image/pjpg, image/x-jpeg, x-jpg, image/gif, image/x-gif, image/png, image/x-png"))); $file_maxwidth = $this->level_info['level_photo_width']; $file_maxheight = $this->level_info['level_photo_height']; $photo_newname = "0_".rand(1000, 9999).".jpg"; $pathinfo = pathinfo($_FILES[$photo_name]['name']); $filename = $pathinfo['filename']; $filename = md5(uniqid()); $ext = $pathinfo['extension']; $uniq=uniqid(); $photo_newname = $uniq.".".$ext; $photo_newname1 = $uniq."_thumb.".$ext; $file_dest = $url->url_userdir($this->user_info['user_id']).$photo_newname; $thumb_dest = $url->url_userdir($this->user_info['user_id']).$photo_newname1; $new_photo = new se_upload(); $new_photo->new_upload($photo_name, $file_maxsize, $file_exts, $file_types, $file_maxwidth, $file_maxheight); // UPLOAD AND RESIZE PHOTO IF NO ERROR if( !$new_photo->is_error ) { // DELETE OLD AVATAR IF EXISTS $this->user_photo_delete(); // UPLOAD THUMB // CHECK IF IMAGE RESIZING IS AVAILABLE, OTHERWISE MOVE UPLOADED IMAGE if( $new_photo->is_image ) { $new_photo->upload_photo($file_dest); } else { $new_photo->upload_file($file_dest); } $new_photo->upload_thumb($thumb_dest); $new_photo->upload_thumb1($thumb_dest); // if(!$database->database_ping()) if (!is_object($database) && !$database instanceof mysqli) { global $database, $database_host, $database_username, $database_password, $database_name; $database =NULL; $database =& \SEDatabase::getInstance(); } // UPDATE USER INFO WITH IMAGE IF STILL NO ERROR if( !$new_photo->is_error ) { if($photo_newname!="."){ $database->database_query("UPDATE se_users SET user_photo='{$photo_newname}' WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); /* $database->database_query("INSERT INTO images SET image='{$photo_newname}', albumid='".$album."', userid='".$this->user_info['user_id']."', caption='".$caption."'"); if($database->database_result($database->database_query("SELECT COUNT(*) FROM images WHERE albumid='".$album."', userid='".$this->user_info['user_id']."'"),0)==0) { $database->database_query("UPDATE images SET albumcover='1' WHERE image='{$photo_newname}' AND albumid='".$album."' AND userid='".$this->user_info['user_id']."' AND caption='".$caption."'"); }*/ $this->user_info['user_photo'] = $photo_newname; } else{$this->user_info['user_photo'] = "";} } } $this->is_error = $new_photo->is_error; } // END user_photo_upload() METHOD // THIS METHOD DELETES A USER PHOTO // INPUT: // OUTPUT: function user_photo_delete() { global $database; $user_photo = $this->user_photo(); if( $user_photo ) { //@unlink($user_photo); //@unlink(substr($user_photo, 0, strrpos($user_photo, "."))."_thumb".substr($user_photo, strrpos($user_photo, "."))); $database->database_query("UPDATE se_users SET user_photo='' WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); $this->user_info['user_photo'] = NULL; } } function adminuser_intro_delete() { global $database, $url; //$user_photo = $this->user_photo(); //if( $user_photo ) //{ //@unlink($url->url_userdir($this->user_info['user_id'])."a12541a"); @unlink("../".$url->url_userdir($this->user_info['user_id'])."a12541a_thumb.jpg"); $client = new MyS3Wrapper([ 'region' => 'us-north-1', 'version' => 'latest', 'endpoint' => ENDPOINT, 'credentials' => [ 'key' => AWS_KEY, 'secret' => AWS_SECRET_KEY ], // Set the S3 class to use objects.dreamhost.com/bucket // instead of bucket.objects.dreamhost.com 'use_path_style_endpoint' => true ]); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$url->url_userdir($this->user_info['user_id'])."a12541a_thumb.jpg"), ));}catch (Exception $e) {} @unlink("../".$url->url_userdir($this->user_info['user_id'])."a12541a.flv"); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$url->url_userdir($this->user_info['user_id'])."a12541a.flv"), ));}catch (Exception $e) {} @unlink("../".$url->url_userdir($this->user_info['user_id'])."a12541a.mp4"); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$url->url_userdir($this->user_info['user_id'])."a12541a.mp4"), ));}catch (Exception $e) {} @unlink("../".$url->url_userdir($this->user_info['user_id'])."a12541a-1080.mp4"); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$url->url_userdir($this->user_info['user_id'])."a12541a-1080.mp4"), ));}catch (Exception $e) {} @unlink("../".$url->url_userdir($this->user_info['user_id'])."a12541a-720.mp4"); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$url->url_userdir($this->user_info['user_id'])."a12541a-720.mp4"), ));}catch (Exception $e) {} @unlink("../".$url->url_userdir($this->user_info['user_id'])."a12541a-480.mp4"); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$url->url_userdir($this->user_info['user_id'])."a12541a-480.mp4"), ));}catch (Exception $e) {} @unlink("../".$url->url_userdir($this->user_info['user_id'])."a12541a-240.mp4"); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$url->url_userdir($this->user_info['user_id'])."a12541a-240.mp4"), ));}catch (Exception $e) {} highwindsdelete(IMAGECDN.substr($url->url_userdir($this->user_info['user_id']),2)."a12541a_thumb.jpg"); //highwindsdelete(IMAGECDN.$url->url_userdir($this->user_info['user_id'])."a12541a.flv"); highwindsdelete(IMAGECDN.substr($url->url_userdir($this->user_info['user_id']),2)."a12541a.mp4"); highwindsdelete(IMAGECDN.substr($url->url_userdir($this->user_info['user_id']),2)."a12541a-1080.mp4"); highwindsdelete(IMAGECDN.substr($url->url_userdir($this->user_info['user_id']),2)."a12541a-720.mp4"); highwindsdelete(IMAGECDN.substr($url->url_userdir($this->user_info['user_id']),2)."a12541a-480.mp4"); highwindsdelete(IMAGECDN.substr($url->url_userdir($this->user_info['user_id']),2)."a12541a-240.mp4"); //@unlink(substr($user_photo, 0, strrpos($user_photo, "."))."_thumb".substr($user_photo, strrpos($user_photo, "."))); $database->database_query("UPDATE se_users SET introvid='', introapproved=0, ai=0 WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); //$this->user_info['user_photo'] = NULL; //} } function user_intro_delete() { global $database, $url; //$user_photo = $this->user_photo(); //if( $user_photo ) //{ //@unlink($url->url_userdir($this->user_info['user_id'])."a12541a"); @unlink($url->url_userdir($this->user_info['user_id'])."a12541a_thumb.jpg"); $client = new MyS3Wrapper([ 'region' => 'us-north-1', 'version' => 'latest', 'endpoint' => ENDPOINT, 'credentials' => [ 'key' => AWS_KEY, 'secret' => AWS_SECRET_KEY ], // Set the S3 class to use objects.dreamhost.com/bucket // instead of bucket.objects.dreamhost.com 'use_path_style_endpoint' => true ]); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$url->url_userdir($this->user_info['user_id'])."a12541a_thumb.jpg"), ));}catch (Exception $e) {} highwindsdelete(IMAGECDN.substr($url->url_userdir($this->user_info['user_id']),2)."a12541a_thumb.jpg"); if(file_exists($url->url_userdir($this->user_info['user_id'])."a12541a.flv")){ @unlink($url->url_userdir($this->user_info['user_id'])."a12541a.flv"); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$url->url_userdir($this->user_info['user_id'])."a12541a.flv"), ));}catch (Exception $e) {} } if(file_exists($url->url_userdir($this->user_info['user_id'])."a12541a.mp4")){ @unlink($url->url_userdir($this->user_info['user_id'])."a12541a.mp4"); highwindsdelete(IMAGECDN.substr($url->url_userdir($this->user_info['user_id']),2)."a12541a.mp4"); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$url->url_userdir($this->user_info['user_id'])."a12541a.mp4"), ));}catch (Exception $e) {} } if(file_exists($url->url_userdir($this->user_info['user_id'])."a12541a-1080.mp4")){ @unlink($url->url_userdir($this->user_info['user_id'])."a12541a-1080.mp4"); highwindsdelete(IMAGECDN.substr($url->url_userdir($this->user_info['user_id']),2)."a12541a-1080.mp4"); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$url->url_userdir($this->user_info['user_id'])."a12541a-1080.mp4"), ));}catch (Exception $e) {} } if(file_exists($url->url_userdir($this->user_info['user_id'])."a12541a-720.mp4")){ @unlink($url->url_userdir($this->user_info['user_id'])."a12541a-720.mp4"); highwindsdelete(IMAGECDN.substr($url->url_userdir($this->user_info['user_id']),2)."a12541a-720.mp4"); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$url->url_userdir($this->user_info['user_id'])."a12541a-720.mp4"), ));}catch (Exception $e) {} } if(file_exists($url->url_userdir($this->user_info['user_id'])."a12541a-480.mp4")){ @unlink($url->url_userdir($this->user_info['user_id'])."a12541a-480.mp4"); highwindsdelete(IMAGECDN.substr($url->url_userdir($this->user_info['user_id']),2)."a12541a-480.mp4"); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$url->url_userdir($this->user_info['user_id'])."a12541a-480.mp4"), ));}catch (Exception $e) {} } if(file_exists($url->url_userdir($this->user_info['user_id'])."a12541a.mp4")){ @unlink($url->url_userdir($this->user_info['user_id'])."a12541a-240.mp4"); highwindsdelete(IMAGECDN.substr($url->url_userdir($this->user_info['user_id']),2)."a12541a-240.mp4"); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$url->url_userdir($this->user_info['user_id'])."a12541a-240.mp4"), ));}catch (Exception $e) {} } $directory=str_replace("./", "", $url->url_userdir($this->user_info['user_id'])); $cf_cache_v1 = new cloudflare_cache( array( "tkn" => "b4fafa93f2bcd7ce518553d2df2793edd06e8", "email" => "lepslair@gmail.com", "z" => "bateworld.com" ) ); //$res = $cf_cache_v1->purge_file("https://bateworld.com/".$directory."a12541a.mp4"); //highwindsdelete(IMAGECDN.$directory."a12541a.mp4"); //highwindsdelete(IMAGECDN.$directory."a12541a.mp4"); //$res = $cf_cache_v1->purge_file("https://bateworld.com/".$directory."a12541a_thumb.jpg"); // highwindsdelete(IMAGECDN.$directory."a12541a_thumb.jpg"); //highwindsdelete(IMAGECDN.$directory."a12541a_thumb.jpg"); //@unlink(substr($user_photo, 0, strrpos($user_photo, "."))."_thumb".substr($user_photo, strrpos($user_photo, "."))); $database->database_query("UPDATE se_users SET introvid='', introapproved=0, contacted=0, introapproved2=0, introtime='0000-00-00 00:00:00', introduration=0, second=0, video_is_converted=0, introapproveddate=0, ai=0 WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); //$this->user_info['user_photo'] = NULL; //} } // END user_photo_delete() METHOD // THIS METHOD RETURNS THE TOTAL NUMBER OF FRIENDS // INPUT: $direction (OPTIONAL) REPRESENTING A "0" FOR OUTGOING CONNECTIONS AND A "1" FOR INCOMING CONNECTIONS // $friend_status (OPTIONAL) REPRESENTING THE FRIEND STATUS (1 FOR CONFIRMED, 0 FOR PENDING REQUESTS) // $user_details (OPTIONAL) REPRESENTING WHETHER THE QUERY SHOULD JOIN TO THE USER TABLE OR NOT // $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE // OUTPUT: AN INTEGER REPRESENTING THE NUMBER OF FRIENDS function user_friend_total($direction = 0, $friend_status = 1, $user_details = 0, $where = "") { global $database, $setting; if( !$setting['setting_connection_allow'] ) return 0; // BEGIN FRIEND QUERY $friend_query = " SELECT NULL FROM se_friends "; // JOIN TO FRIEND TABLE IF NECESSARY //if( $user_details ) $friend_query .= " LEFT JOIN se_users ON "; if( $direction==1 ) $friend_query .= "se_friends.friend_user_id1=se_users.user_id "; else $friend_query .= "se_friends.friend_user_id2=se_users.user_id "; // CONTINUE QUERY $friend_query .= " WHERE friend_status='{$friend_status}' "; // EITHER "LIST OF WHO USER IS A FRIEND OF" OR "LIST OF USER'S FRIENDS" if( $direction == 1 ) $friend_query .= " && friend_user_id2='{$this->user_info['user_id']}' "; if( $direction != 1 ) $friend_query .= " && friend_user_id1='{$this->user_info['user_id']}' "; $friend_query .= " && se_users.user_enabled=1"; // ADD ADDITIONAL WHERE CLAUSE IF EXISTS if( $where ) $friend_query .= " && {$where} "; //if(SE_DEBUG1){echo $friend_query."";} return (int) $database->database_num_rows($database->database_query($friend_query)); } function user_friend_total_requests($direction = 0, $friend_status = 1, $user_details = 0, $where = "") { global $database, $setting; if( !$setting['setting_connection_allow'] ) return 0; // BEGIN FRIEND QUERY $friend_query = " SELECT NULL FROM se_friends "; // JOIN TO FRIEND TABLE IF NECESSARY $friend_query .= " LEFT JOIN se_users ON "; if($direction==1 ){ $friend_query .= "se_friends.friend_user_id1=se_users.user_id "; } else{ $friend_query .= "se_friends.friend_user_id2=se_users.user_id "; } // CONTINUE QUERY $friend_query .= " WHERE friend_status='{$friend_status}' AND user_enabled='1' "; // EITHER "LIST OF WHO USER IS A FRIEND OF" OR "LIST OF USER'S FRIENDS" if( $direction == 1 ) $friend_query .= " && friend_user_id2='{$this->user_info['user_id']}' "; if( $direction != 1 ) $friend_query .= " && friend_user_id1='{$this->user_info['user_id']}' "; // ADD ADDITIONAL WHERE CLAUSE IF EXISTS if( $where ) $friend_query .= " && {$where} "; return (int) $database->database_num_rows($database->database_query($friend_query)); } // END user_friend_total() METHOD // THIS METHOD RETURNS AN ARRAY OF USER'S FRIENDS // INPUT: $start REPRESENTING THE FRIEND TO START WITH // $limit REPRESENTING THE NUMBER OF FRIENDS TO RETURN // $direction (OPTIONAL) REPRESENTING A "0" FOR OUTGOING CONNECTIONS AND A "1" FOR INCOMING CONNECTIONS // $friend_status (OPTIONAL) REPRESENTING THE FRIEND STATUS (1 FOR CONFIRMED, 0 FOR PENDING REQUESTS) // $sort_by (OPTIONAL) REPRESENTING THE ORDER BY CLAUSE // $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE // $friend_details (OPTIONAL) REPRESENTING A BOOLEAN THAT DETERMINES WHETHER OR NOT TO RETRIEVE THE "FRIEND TYPE" AND "FRIEND EXPLANATION" // OUTPUT: AN ARRAY OF THE USER'S FRIENDS function user_friend_list_request($start, $limit, $direction = 0, $friend_status = 1, $sort_by = "se_users.user_dateupdated DESC", $where = "", $friend_details = 0, $other_user_id = 0) { // echo $sort_by; global $database, $setting, $user; if( !$other_user_id && $user->user_info['user_id'] != $this->user_info['user_id'] ) { $other_user_id = $user->user_info['user_id']; } // SET VARIABLE $friend_array = Array(); // MAKE SURE CONNECTIONS ARE ALLOWED if( $setting['setting_connection_allow'] ) { // BEGIN FRIEND QUERY $friend_query = " SELECT se_friends.friend_id, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo, se_users.user_lastlogindate, se_users.user_dateupdated "; if( $other_user_id ) { $friend_query .= ", CASE WHEN (SELECT TRUE FROM se_friends WHERE friend_user_id1='{$other_user_id}' AND friend_user_id2=se_users.user_id AND friend_status='1' LIMIT 1) THEN 2 WHEN (SELECT TRUE FROM se_friends WHERE friend_user_id1='{$other_user_id}' AND friend_user_id2=se_users.user_id AND friend_status='0' LIMIT 1) THEN 1 ELSE 0 END AS is_viewers_friend "; } $friend_query .= ", CASE WHEN (SELECT TRUE FROM se_users AS se_users2 WHERE se_users2.user_id=se_users.user_id AND (user_blocklist LIKE '{$this->user_info['user_id']},%' OR user_blocklist LIKE '%,{$this->user_info['user_id']}' OR user_blocklist LIKE '%,{$this->user_info['user_id']},%') LIMIT 1) THEN TRUE ELSE FALSE END AS is_viewers_blocklisted "; // GET FRIEND EXPLAIN, IF NECESSARY if( $friend_details ) $friend_query .= ", se_friends.friend_type, se_friendexplains.friendexplain_body "; // CONTINUE QUERY $friend_query .= " FROM se_friends LEFT JOIN se_users ON "; // MAKE SURE TO JOIN ON THE CORRECT FIELD (DEPENDENT ON DIRECTION) if( $direction == 1 ) $friend_query .= " se_friends.friend_user_id1=se_users.user_id "; if( $direction != 1 ) $friend_query .= " se_friends.friend_user_id2=se_users.user_id "; // JOIN ON FRIEND EXPLAIN TABLE, IF NECESSARY if( $friend_details ) $friend_query .= " LEFT JOIN se_friendexplains ON se_friends.friend_id=se_friendexplains.friendexplain_friend_id "; // CONTINUE QUERY $friend_query .= " WHERE friend_status='{$friend_status}' AND user_enabled='1' "; // EITHER "LIST OF WHO USER IS A FRIEND OF" OR "LIST OF USER'S FRIENDS" if( $direction == 1 ) $friend_query .= " && friend_user_id2='{$this->user_info['user_id']}' "; if( $direction != 1 ) $friend_query .= " && friend_user_id1='{$this->user_info['user_id']}' "; // ADD ADDITIONAL WHERE CLAUSE IF EXISTS if( $where ) $friend_query .= " && {$where} "; // SET SORT AND LIMIT $friend_query .= " ORDER BY {$sort_by} LIMIT {$start}, {$limit} "; //if(SE_DEBUG){echo $friend_query;} // LOOP OVER FRIENDS $friends = $database->database_query($friend_query); while($friend_info = $database->database_fetch_assoc($friends)) { // CREATE AN OBJECT FOR FRIEND $friend = new SEUser(); $friend->user_info['user_id'] = $friend_info['user_id']; $friend->user_info['user_username'] = $friend_info['user_username']; $friend->user_info['user_fname'] = $friend_info['user_fname']; $friend->user_info['user_lname'] = $friend_info['user_lname']; $friend->user_info['user_photo'] = $friend_info['user_photo']; $friend->user_info['user_lastlogindate'] = $friend_info['user_lastlogindate']; $friend->user_info['user_dateupdated'] = $friend_info['user_dateupdated']; $friend->is_viewers_friend = @$friend_info['is_viewers_friend']; $friend->is_viewers_blocklist = @$friend_info['is_viewers_blocklist']; $friend->user_displayname(); // SET FRIEND TYPE/EXPLANATION VARS if( $friend_details ) { $friend->friend_type = $friend_info['friend_type']; $friend->friend_explain = $friend_info['friendexplain_body']; } // SET FRIEND ARRAY $friend_array[] = $friend; } } // RETURN FRIEND ARRAY return $friend_array; } function user_friend_list_all() { // echo $sort_by; global $database, $setting, $user; // SET VARIABLE $friend_array = Array(); // MAKE SURE CONNECTIONS ARE ALLOWED if( $setting['setting_connection_allow'] ) { // BEGIN FRIEND QUERY $friend_query = " SELECT se_friends.friend_id, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo, se_users.user_lastlogindate, se_users.user_dateupdated "; if( $other_user_id ) { $friend_query .= ", CASE WHEN (SELECT TRUE FROM se_friends WHERE friend_user_id1='{$other_user_id}' AND friend_user_id2=se_users.user_id AND friend_status='1' LIMIT 1) THEN 2 WHEN (SELECT TRUE FROM se_friends WHERE friend_user_id1='{$other_user_id}' AND friend_user_id2=se_users.user_id AND friend_status='0' LIMIT 1) THEN 1 ELSE 0 END AS is_viewers_friend "; } /*$friend_query .= ", CASE WHEN (SELECT TRUE FROM se_users AS se_users2 WHERE se_users2.user_id=se_users.user_id AND (user_blocklist LIKE '{$this->user_info['user_id']},%' OR user_blocklist LIKE '%,{$this->user_info['user_id']}' OR user_blocklist LIKE '%,{$this->user_info['user_id']},%') LIMIT 1) THEN TRUE ELSE FALSE END AS is_viewers_blocklisted ";*/ // GET FRIEND EXPLAIN, IF NECESSARY if( $friend_details ) $friend_query .= ", se_friends.friend_type, se_friendexplains.friendexplain_body "; // CONTINUE QUERY $friend_query .= " FROM se_friends LEFT JOIN se_users ON "; // MAKE SURE TO JOIN ON THE CORRECT FIELD (DEPENDENT ON DIRECTION) if( $direction == 1 ) $friend_query .= " se_friends.friend_user_id1=se_users.user_id "; if( $direction != 1 ) $friend_query .= " se_friends.friend_user_id2=se_users.user_id "; // JOIN ON FRIEND EXPLAIN TABLE, IF NECESSARY if( $friend_details ) $friend_query .= " LEFT JOIN se_friendexplains ON se_friends.friend_id=se_friendexplains.friendexplain_friend_id "; // CONTINUE QUERY $friend_query .= " WHERE friend_status='1' "; // EITHER "LIST OF WHO USER IS A FRIEND OF" OR "LIST OF USER'S FRIENDS" if( $direction == 1 ) $friend_query .= " && friend_user_id2='{$this->user_info['user_id']}' "; if( $direction != 1 ) $friend_query .= " && friend_user_id1='{$this->user_info['user_id']}' "; $friend_query .= " && se_users.user_enabled=1"; // ADD ADDITIONAL WHERE CLAUSE IF EXISTS if( $where ) $friend_query .= " && {$where} "; // LOOP OVER FRIENDS $friends = $database->database_query($friend_query); while($friend_info = $database->database_fetch_assoc($friends)) { // CREATE AN OBJECT FOR FRIEND // SET FRIEND ARRAY $friend_array[] = $friend_info['user_id']; } } // RETURN FRIEND ARRAY return $friend_array; } function user_friend_list($start, $limit, $direction = 0, $friend_status = 1, $sort_by = "se_users.user_dateupdated DESC", $where = "", $friend_details = 0, $other_user_id = 0) { // echo $sort_by; global $database, $setting, $user; if( !$other_user_id && $user->user_info['user_id'] != $this->user_info['user_id'] ) { $other_user_id = $user->user_info['user_id']; } // SET VARIABLE $friend_array = Array(); // MAKE SURE CONNECTIONS ARE ALLOWED if( $setting['setting_connection_allow'] ) { // BEGIN FRIEND QUERY $friend_query = " SELECT se_friends.friend_id, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo, se_users.user_lastlogindate, se_users.user_dateupdated "; if( $other_user_id ) { $friend_query .= ", CASE WHEN (SELECT TRUE FROM se_friends WHERE friend_user_id1='{$other_user_id}' AND friend_user_id2=se_users.user_id AND friend_status='1' LIMIT 1) THEN 2 WHEN (SELECT TRUE FROM se_friends WHERE friend_user_id1='{$other_user_id}' AND friend_user_id2=se_users.user_id AND friend_status='0' LIMIT 1) THEN 1 ELSE 0 END AS is_viewers_friend "; } /*$friend_query .= ", CASE WHEN (SELECT TRUE FROM se_users AS se_users2 WHERE se_users2.user_id=se_users.user_id AND (user_blocklist LIKE '{$this->user_info['user_id']},%' OR user_blocklist LIKE '%,{$this->user_info['user_id']}' OR user_blocklist LIKE '%,{$this->user_info['user_id']},%') LIMIT 1) THEN TRUE ELSE FALSE END AS is_viewers_blocklisted ";*/ // GET FRIEND EXPLAIN, IF NECESSARY if( $friend_details ) $friend_query .= ", se_friends.friend_type, se_friendexplains.friendexplain_body "; // CONTINUE QUERY $friend_query .= " FROM se_friends LEFT JOIN se_users ON "; // MAKE SURE TO JOIN ON THE CORRECT FIELD (DEPENDENT ON DIRECTION) if( $direction == 1 ) $friend_query .= " se_friends.friend_user_id1=se_users.user_id "; if( $direction != 1 ) $friend_query .= " se_friends.friend_user_id2=se_users.user_id "; // JOIN ON FRIEND EXPLAIN TABLE, IF NECESSARY if( $friend_details ) $friend_query .= " LEFT JOIN se_friendexplains ON se_friends.friend_id=se_friendexplains.friendexplain_friend_id "; // CONTINUE QUERY $friend_query .= " WHERE friend_status='{$friend_status}' "; // EITHER "LIST OF WHO USER IS A FRIEND OF" OR "LIST OF USER'S FRIENDS" if( $direction == 1 ) $friend_query .= " && friend_user_id2='{$this->user_info['user_id']}' "; if( $direction != 1 ) $friend_query .= " && friend_user_id1='{$this->user_info['user_id']}' "; $friend_query .= " && se_users.user_enabled=1"; // ADD ADDITIONAL WHERE CLAUSE IF EXISTS if( $where ) $friend_query .= " && {$where} "; // SET SORT AND LIMIT $friend_query .= " ORDER BY {$sort_by} LIMIT {$start}, {$limit} "; //if(SE_DEBUG1){echo $friend_query;} // LOOP OVER FRIENDS $friends = $database->database_query($friend_query); while($friend_info = $database->database_fetch_assoc($friends)) { // CREATE AN OBJECT FOR FRIEND $friend = new SEUser(); $friend->user_info['user_id'] = $friend_info['user_id']; $friend->user_info['user_username'] = $friend_info['user_username']; $friend->user_info['user_fname'] = $friend_info['user_fname']; $friend->user_info['user_lname'] = $friend_info['user_lname']; $friend->user_info['user_photo'] = $friend_info['user_photo']; $friend->user_info['user_lastlogindate'] = $friend_info['user_lastlogindate']; $friend->user_info['user_dateupdated'] = $friend_info['user_dateupdated']; $friend->is_viewers_friend = @$friend_info['is_viewers_friend']; $friend->is_viewers_blocklist = @$friend_info['is_viewers_blocklist']; $friend->user_displayname(); // SET FRIEND TYPE/EXPLANATION VARS if( $friend_details ) { $friend->friend_type = $friend_info['friend_type']; $friend->friend_explain = $friend_info['friendexplain_body']; } // SET FRIEND ARRAY $friend_array[] = $friend; } } // RETURN FRIEND ARRAY return $friend_array; } // END user_friend_list() METHOD // THIS METHOD ADDS A USER AS A FRIEND OF THE CURRENT USER // INPUT: $other_user_id REPRESENTING THE USER ID OF THE FRIEND TO BE ADDED // $friend_status REPRESENTING WHETHER THE FRIENDSHIP IS CONFIRMED OR NOT // $friend_type REPRESENTING A STRING WITH THE TYPE OF FRIEND // $friend_explain REPRESENTING A TEXTUAL EXPLANATION OF THE FRIENDSHIP // OUTPUT: function user_friend_add($other_user_id, $friend_status, $friend_type, $friend_explain) { global $database; // CHECK EXISTANCE OF FRIENDSHIP if( $database->database_num_rows($database->database_query("SELECT TRUE FROM se_friends WHERE friend_user_id1='{$this->user_info['user_id']}' AND friend_user_id2='{$other_user_id}' LIMIT 1")) ) return; $numberofrequests=$database->database_num_rows($database->database_query("SELECT TRUE FROM se_friends WHERE friend_user_id1='{$this->user_info['user_id']}' AND time>".(time()-(60*60))."")); if($numberofrequests>=30){return;} // ADD USER TO FRIENDS $database->database_query(" INSERT INTO se_friends (friend_user_id1, friend_user_id2, friend_status, friend_type, time) VALUES ('{$this->user_info['user_id']}', '{$other_user_id}', '{$friend_status}', '{$friend_type}', '".time()."' ) "); $friend_id = $database->database_insert_id(); $database->database_query(" INSERT INTO se_friendexplains (friendexplain_friend_id, friendexplain_body) VALUES ('{$friend_id}', '{$friend_explain}') "); // REMOVE FRIEND FROM BLOCKLIST if( $this->user_blocked($other_user_id) ) { $blocklist = explode(",", $this->user_info['user_blocklist']); $user_key = array_search($other_user_id, $blocklist); $blocklist[$user_key] = ""; $this->user_info['user_blocklist'] = implode(",", $blocklist); $database->database_query("UPDATE se_users SET user_blocklist='{$this->user_info['user_blocklist']}' WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); } } // END user_friend_add() METHOD // THIS METHOD REMOVES A USER AS A FRIEND OF THE CURRENT USER // INPUT: $other_user_id REPRESENTING THE FRIEND'S USER ID // OUTPUT: function user_friend_remove($other_user_id) { global $database, $setting; // REMOVE IF FRIEND $friend1 = $database->database_query("SELECT friend_id FROM se_friends WHERE friend_user_id1='{$this->user_info['user_id']}' AND friend_user_id2='{$other_user_id}'"); if( $database->database_num_rows($friend1) ) { $friendship = $database->database_fetch_assoc($friend1); $database->database_query("DELETE FROM se_friends WHERE friend_id='{$friendship['friend_id']}' LIMIT 1"); $database->database_query("DELETE FROM se_friendexplains WHERE friendexplain_friend_id='{$friendship['friend_id']}' LIMIT 1"); } // REMOVE ADDITIONAL ROW IF TWO-DIRECTIONAL $friend2 = $database->database_query("SELECT friend_id FROM se_friends WHERE friend_user_id2='{$this->user_info['user_id']}' AND friend_user_id1='{$other_user_id}'"); if( $database->database_num_rows($friend2) && ($setting['setting_connection_framework'] == 0 || $setting['setting_connection_framework'] == 2) ) { $friendship = $database->database_fetch_assoc($friend2); $database->database_query("DELETE FROM se_friends WHERE friend_id='{$friendship['friend_id']}' LIMIT 1"); $database->database_query("DELETE FROM se_friendexplains WHERE friendexplain_friend_id='{$friendship['friend_id']}' LIMIT 1"); } } // END user_friend_remove() METHOD // THIS METHOD RETURNS TRUE IF THE SPECIFIED USER IS A FRIEND OF A FRIEND OF THE EXISTING USER IN THIS CLASS // INPUT: $other_user_id REPRESENTING A USER'S USER ID // OUTPUT: RETURNS A BOOLEAN REPRESENTING WHETHER THE SPECIFIED USER IS A FRIEND OF A FRIEND OR NOT function user_friend_of_friend($other_user_id) { global $database; $resource = $database->database_query(" SELECT t2.friend_user_id2 FROM se_friends AS t1 LEFT JOIN se_friends AS t2 ON t1.friend_user_id2=t2.friend_user_id1 WHERE t1.friend_user_id1='{$this->user_info['user_id']}' && t2.friend_user_id2='{$other_user_id}' && t1.friend_status<>'0' && t2.friend_status<>'0' "); return (bool) $database->database_num_rows($resource); } // END user_friend_of_friend() METHOD // THIS METHOD RETURNS TRUE IF THE SPECIFIED USER HAS BEEN FRIENDED BY THE EXISTING USER IN THIS CLASS // INPUT: $other_user_id REPRESENTING A USER'S USER ID // $friend_status (OPTIONAL) REPRESENTING WHETHER THE FRIENDSHIP IS CONFIRMED OR NOT // OUTPUT: RETURNS A BOOLEAN REPRESENTING WHETHER THE SPECIFIED USER IS FRIENDED OR NOT function user_friended($other_user_id, $friend_status = 1) { global $database; $resource = $database->database_query(" SELECT friend_id FROM se_friends WHERE friend_user_id1='{$this->user_info['user_id']}' && friend_user_id2='{$other_user_id}' && friend_status='{$friend_status}' "); return (bool) $database->database_num_rows($resource); } // END user_friended() METHOD // THIS METHOD RETURNS TRUE IF THE SPECIFIED USER HAS BEEN BLOCKED BY THE EXISTING USER IN THIS CLASS // INPUT: $other_user_id REPRESENTING A USER'S USER ID // OUTPUT: RETURNS A BOOLEAN REPRESENTING WHETHER THE SPECIFIED USER IS BLOCKED OR NOT function user_blocked($other_user_id) { if( isset($this->level_info['level_profile_block']) && !$this->level_info['level_profile_block'] ) { return false; } if( !$this->user_info['user_blocklist'] ) { return false; } $blocklist = explode(",", $this->user_info['user_blocklist']); return in_array($other_user_id, $blocklist); } // END user_blocked() METHOD function blocked_group($group_id) { if( !$this->user_info['blocked_groups'] ) { return false; } $blocklist = explode(",", $this->user_info['blocked_groups']); return in_array($group_id, $blocklist); } function blocked_club($group_id) { if( !$this->user_info['blocked_clubs'] ) { return false; } $blocklist = explode(",", $this->user_info['blocked_clubs']); return in_array($group_id, $blocklist); } function blocked_event($event_id) { if( !$this->user_info['blocked_events'] ) { return false; } $blocklist = explode(",", $this->user_info['blocked_events']); return in_array($event_id, $blocklist); } // THIS METHOD RETURNS MAXIMUM PRIVACY LEVEL VIEWABLE BY A USER WITH REGARD TO THE CURRENT USER // INPUT: $other_user REPRESENTING A ANOTHER USER OBJECT // OUTPUT: RETURNS PRIVACY LEVEL OF GIVEN USER WITH RESPECT TO CURRENT USER function user_privacy_max($other_user) { global $database; // UNREGISTERED USER if( !$other_user->user_exists ) return 32; switch(TRUE) { // OWNER case( $this->user_info['user_id'] == $other_user->user_info['user_id'] ): return 1; break; // FRIEND case( $this->user_friended($other_user->user_info['user_id']) ): return 2; break; // FRIEND OF FRIEND WITHIN SAME SUBNETWORK case( $this->user_info['user_subnet_id'] == $other_user->user_info['user_subnet_id'] && $this->user_friend_of_friend($other_user->user_info['user_id']) ): return 4; break; // SAME SUBNETWORK case( $this->user_info['user_subnet_id'] == $other_user->user_info['user_subnet_id'] ): return 8; break; // REGISTERED USER case( $other_user->user_exists ): return 16; break; // DEFAULT EVERYONE default: return 32; } } // END user_privacy_max() METHOD // THIS METHOD CREATES A USER ACCOUNT USING THE GIVEN INFORMATION // INPUT: $signup_email REPRESENTING THE DESIRED EMAIL // $signup_username REPRESENTING THE DESIRED USERNAME // $signup_password REPRESENTING THE DESIRED PASSWORD // $signup_timezone REPRESENTING THE USER'S TIMEZONE // $signup_language REPRESENTING THE USER'S SELECTED LANGUAGE // $signup_cat REPRESENTING THE USER'S SELECTED PROFILE CATEGORY // $profile_field_query REPRESENTING THE PARTIAL QUERY TO SAVE IN THE USER'S PROFILE VALUE TABLE // OUTPUT: function user_create($signup_email, $signup_username, $signup_password, $signup_timezone, $signup_language, $signup_cat, $profile_field_query, $landingpage=0, $return_json="") { global $database, $setting, $url, $actions, $field, $utm_keyword, $utm_source, $utm_campaign; // PRESET VARS $signup_subnet_id = 0; $signup_level_info = $database->database_fetch_assoc($database->database_query("SELECT level_id, level_profile_privacy, level_profile_comments FROM se_levels WHERE level_default='1' LIMIT 1")); $signup_date = time(); $signup_dateupdated = $signup_date; $signup_invitesleft = $setting['setting_signup_invite_numgiven']; $signup_notify_friendrequest = 0; $signup_notify_message = 0; $signup_notify_profilecomment = 0; $signup_profile_search = 1; $signup_ip = $_SERVER['REMOTE_ADDR']; // SET SIGNUP_USERNAME TO A PLACEHOLDER IF USERNAMES ARE NOT BEING USED if( !$setting['setting_username'] ) $signup_username = randomcode(15); // SET WHETHER USER IS ENABLED OR NOT $signup_enabled = (bool) $setting['setting_signup_enable']; // SET EMAIL VERIFICATION VARIABLE $signup_verified = !$setting['setting_signup_verify']; // CREATE RANDOM PASSWORD IF NECESSARY $signup_password = randomcode(10); // ENCODE PASSWORD WITH MD5 $crypt_password = $this->user_password_crypt($signup_password); $signup_code = $user_salt = $this->user_salt; // SET PRIVACY DEFAULT $allowable_privacy = unserialize($signup_level_info['level_profile_privacy']); rsort($allowable_privacy); $profile_privacy = $allowable_privacy[0]; // SET COMMENT DEFAULT $allowable_comments = unserialize($signup_level_info['level_profile_comments']); rsort($allowable_comments); $profile_comments = $allowable_comments[0]; // ADD USER TO USER TABLE $database->database_query(" INSERT INTO se_users ( user_level_id, user_profilecat_id, user_email, user_newemail, user_username, user_password, user_password_method, user_code, user_enabled, user_verified, user_signupdate, user_invitesleft, user_timezone, user_language_id, user_dateupdated, user_search, user_privacy, user_comments, user_ip_signup, user_ip_lastactive, user_lastactive, user_lastlogindate, signupfrom, activitystatuschangedate, utm_keyword, utm_source, utm_campaign ) VALUES ( '{$signup_level_info['level_id']}', '{$signup_cat}', '{$signup_email}', '{$signup_email}', '{$signup_username}', '{$crypt_password}', '{$setting['setting_password_method']}', '{$signup_code}', '{$signup_enabled}', '{$signup_verified}', '{$signup_date}', '{$signup_invitesleft}', '{$signup_timezone}', '{$signup_language}', '{$signup_dateupdated}', '{$signup_profile_search}', '{$profile_privacy}', '{$profile_comments}', '{$signup_ip}', '{$signup_ip}', '{$signup_date}', '{$signup_date}', '{$landingpage}', '".$database->database_real_escape_string($signup_date)."', '".$database->database_real_escape_string($utm_keyword)."', '".$database->database_real_escape_string($utm_source)."', '".$database->database_real_escape_string($utm_campaign)."' ) "); // RETRIEVE USER ID $user_id = $database->database_insert_id(); // echo $user_id; exit; if( $user_id ) $this->user_exists = TRUE; // UPDATE USERNAME IF NECESSARY if( !$setting['setting_username'] ) $database->database_query("UPDATE se_users SET user_username=user_id WHERE user_id='{$user_id}' LIMIT 1"); // GET USER INFO $this->user_info = $database->database_fetch_assoc($database->database_query("SELECT * FROM se_users WHERE user_id='{$user_id}' LIMIT 1")); $this->level_info = $database->database_fetch_assoc($database->database_query("SELECT * FROM se_levels WHERE level_id='{$this->user_info['user_level_id']}' LIMIT 1")); $this->subnet_info["subnet_id"]=0; //$this->subnet_info = $database->database_fetch_assoc($database->database_query("SELECT subnet_id, subnet_name FROM se_subnets WHERE subnet_id='{$this->user_info['user_subnet_id']}' LIMIT 1")); // ADD USER PROFILE $database->database_query("INSERT INTO se_profilevalues (profilevalue_user_id) VALUES ('{$this->user_info['user_id']}')"); if( $profile_field_query ){ $database->database_query("UPDATE se_profilevalues SET $profile_field_query WHERE profilevalue_user_id='{$this->user_info['user_id']}' LIMIT 1"); }else{ } // GET PROFILE INFO $this->profile_info = $database->database_fetch_assoc($database->database_query("SELECT * FROM se_profilevalues WHERE profilevalue_user_id='{$this->user_info['user_id']}' LIMIT 1")); // GET SUBNET ID $signup_subnet = $this->user_subnet_select($signup_email, $signup_cat, $this->profile_info); $signup_subnet_id = $signup_subnet[0]; //$database->database_query("UPDATE se_users SET user_subnet_id='{$signup_subnet_id}' WHERE user_id='{$user_id}' LIMIT 1"); $this->user_info['user_subnet_id'] = $signup_subnet_id; // ADD ROW IN STYLES TABLE // $database->database_query("INSERT INTO se_profilestyles (profilestyle_user_id, profilestyle_css) VALUES ('{$this->user_info['user_id']}', '')"); // ADD ROW IN SETTINGS TABLE $actiontypes = $database->database_query("SELECT actiontype_id FROM se_actiontypes"); $action_ids = Array(); while( $actiontype = $database->database_fetch_assoc($actiontypes) ) $action_ids[] = $actiontype['actiontype_id']; if($_POST["sendoffers"]==1){ $database->database_query(" INSERT INTO se_usersettings ( usersetting_user_id, usersetting_notify_friendrequest, usersetting_notify_message, usersetting_notify_profilecomment, usersetting_actions_display, usersetting_notify_pollcomment, usersetting_notify_mediacomment, usersetting_notify_newtag, usersetting_notify_mediatag, usersetting_notify_eventinvite, usersetting_notify_eventcomment, usersetting_notify_eventmediacomment, usersetting_notify_eventmemberrequest, usersetting_notify_neweventtag, usersetting_notify_eventmediatag, usersetting_notify_videocomment, usersetting_notify_classifiedcomment, usersetting_notify_groupinvite, usersetting_notify_groupcomment, usersetting_notify_groupmediacomment, usersetting_notify_groupmemberrequest, usersetting_notify_newgrouptag, usersetting_notify_groupmediatag, usersetting_notify_grouppost, usersetting_notify_blogcomment, usersetting_notify_blogtrackback, usersetting_notify_newblogsubscriptionentry, usersetting_notify_forumreply, usersetting_notify_friendacceptsrequest, usersetting_notify_2daynotice, usersetting_notify_7daynotice, usersetting_notify_birthday ) VALUES ( '{$this->user_info['user_id']}', '1', '1', '1', '".implode(",", $action_ids)."', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1' ) ") or die($database->database_error()); } else{ $database->database_query(" INSERT INTO se_usersettings ( usersetting_user_id, usersetting_notify_friendrequest, usersetting_notify_message, usersetting_notify_profilecomment, usersetting_actions_display ) VALUES ( '{$this->user_info['user_id']}', '{$signup_notify_friendrequest}', '{$signup_notify_message}', '{$signup_notify_profilecomment}', '".implode(",", $action_ids)."' ) ") or die($database->database_error()); } // ADD USER DIRECTORY $user_directory = $url->url_userdir($this->user_info['user_id']); $user_path_array = explode("/", $user_directory); array_pop($user_path_array); array_pop($user_path_array); $subdir = implode("/", $user_path_array)."/"; /*if( !is_dir($subdir) ) { mkdir($subdir, 0777); chmod($subdir, 0777); $handle = fopen($subdir."index.php", 'x+'); fclose($handle); } if( !is_dir($user_directory) ) { mkdir($user_directory, 0777); chmod($user_directory, 0777); $handle = fopen($user_directory."/index.php", 'x+'); fclose($handle); } */ // SAVE FIRST/LAST NAME, IF RELEVANT if( trim($field->field_special[2]) ) { $flquery[] = "user_fname='".$field->field_special[2]."'"; $this->user_info['user_fname'] = $field->field_special[2]; } if( trim($field->field_special[3]) ) { $flquery[] = "user_lname='".$field->field_special[3]."'"; $this->user_info['user_lname'] = $field->field_special[3]; } if( !empty($flquery) ) { $database->database_query("UPDATE se_users SET ".implode(", ", $flquery)." WHERE user_id='{$this->user_info['user_id']}'"); $this->user_displayname_update($field->field_special[2], $field->field_special[3]); } // SET DISPLAY NAME $this->user_displayname(); // CALL SIGNUP HOOK ($hook = \SE_Hook::exists('se_signup_success')) ? \SE_Hook::call($hook, array()) : NULL; // SEND RANDOM PASSWORD IF NECESSARY if( $setting['setting_signup_randpass'] ) { // send_systememail('newpassword', $this->user_info['user_email'], Array($this->user_displayname, $this->user_info['user_email'], $signup_password, "url_base."login.php\">".$url->url_base."login.php")); } // SEND VERIFICATION EMAIL IF REQUIRED // if( $setting['setting_signup_verify'] ) { $verify_code = md5($this->user_info['user_code']); $time = time(); $verify_link = $url->url_base."signup-confirm.php?u={$this->user_info['user_id']}&verify={$verify_code}&d={$time}"; // send_systememail('verification', $this->user_info['user_email'], Array($this->user_displayname, $this->user_info['user_email'], "$verify_link")); $replace=array("[displayname]"=>$this->user_displayname, "[email]"=>$this->user_info['user_email'], "[password]"=>$signup_password, "[link]"=>"$verify_link"); send_systememail('confirmationandpassword', $this->user_info['user_email'], $replace); //send_systememail('confirmationandpassword', $this->user_info['user_email'], Array($this->user_displayname, $this->user_info['user_email'], $signup_password, "$verify_link")); } /* // INSERT ACTION IF VERIFICATION NOT NECESSARY else { $actions->actions_add($this, "signup", Array($this->user_info['user_username'], $this->user_displayname), Array(), 0, false, "user", $this->user_info['user_id'], $this->user_info['user_privacy']); } */ // SEND WELCOME EMAIL IF REQUIRED (AND IF VERIFICATION EMAIL IS NOT BEING SENT) if( $setting['setting_signup_welcome'] && !$setting['setting_signup_verify'] ) { if($_POST["sendoffers"]==1){ // send_systememail('welcome', $this->user_info['user_email'], Array($this->user_displayname, $this->user_info['user_email'], $signup_password, "url_base."login.php\">".$url->url_base."login.php")); } } } // END user_create() METHOD // THIS METHOD DELETES THE USER CURRENTLY ASSOCIATED WITH THIS OBJECT // INPUT: // OUTPUT: function user_delete(){ global $database, $url, $global_plugins; $client = new MyS3Wrapper([ 'region' => 'us-north-1', 'version' => 'latest', 'endpoint' => ENDPOINT, 'credentials' => [ 'key' => AWS_KEY, 'secret' => AWS_SECRET_KEY ], // Set the S3 class to use objects.dreamhost.com/bucket // instead of bucket.objects.dreamhost.com 'use_path_style_endpoint' => true ]); $query=$database->database_query("SELECT * FROM se_users WHERE user_id='".$this->user_info["user_id"]."' ORDER BY datedisabled ASC LIMIT 50") or die($database->database_error()); $row=$database->database_fetch_array($query); $query=$database->database_query("DELETE FROM se_users WHERE user_id='".$this->user_info["user_id"]."'") or die($database->database_error()); //mail("leprakhauns@gmail.com", "Birthday Emails", "Sent"); $user_id=$row["user_id"]; $subdir = $user_id+999-(($user_id-1)%1000); $userdir = "uploads_user/$subdir/$user_id/"; $videodir = "uploads_video/$subdir/$user_id/"; $database->database_query("DELETE FROM arrowchat_status WHERE userid='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM airbnbate WHERE userid='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM arrowchat WHERE `to`='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM arrowchat WHERE `from`='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM batelist WHERE userid='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM batelistcontent WHERE owner='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM bateoffcomments WHERE authoruser_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM bate_videocomments WHERE authoruser_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM batortrainingcomments WHERE authoruser_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM cockology_stats WHERE userid='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM community_user_ads WHERE userid='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM community_wall WHERE userid='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM contest WHERE user='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM contestratings WHERE videorating_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM cp_blogroll_rec WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM favorites WHERE user='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM groupvideocomments WHERE authoruser_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM groupvideoratings WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM halloween_contest WHERE hcuid='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM ips WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM likedbatetube WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM likedbatortraining WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM likedeventmedia WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM likedgroupmedia WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM likedgroupvideos WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM likedmedia WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM likedvideos WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM mail_cybersocket WHERE userid='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM meditations_stats WHERE userid='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM mms_comments WHERE userid='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM motm_answers WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM travelers WHERE userid='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM bateworldcom_wall.notifications WHERE userid='".$row["user_id"]."'") or die($database->database_error()); $query1=$database->database_query("SELECT * FROM bateworldcom_wall.wall WHERE userid='".$row["user_id"]."'") or die($database->database_error()); while($row1=$database->database_fetch_array($query1)) { //call from cloud $database->database_query("DELETE FROM bateworldcom_wall.wall_media WHERE action_id='".$row["user_id"]."'") or die($database->database_error()); } $database->database_query("DELETE FROM bateworldcom_wall.wall WHERE userid='".$row["user_id"]."'") or die($database->database_error()); //$database->database_query("DELETE FROM bateworldcom_zips.bateoffvotes WHERE userid='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM bateworldcom_zips.profileinteresttagged WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM bateworldcom_zips.mediainteresttagged WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM bateworldcom_zips.videointeresttagged WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM bateworldcom_zips.bloginteresttagged WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM bateworldcom_zips.pollinteresttagged WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $query1=$database->database_query("SELECT * FROM se_albums WHERE album_user_id='".$row["user_id"]."'") or die($database->database_error()); while($row1=$database->database_fetch_array($query1)){ $query2=$database->database_query("SELECT * FROM se_media WHERE media_album_id='".$row1["album_id"]."'") or die($database->database_error()); while($row2=$database->database_fetch_array($query2)){ try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $userdir.$row2["media_id"].".".$row2["media_ext"] )); }catch (Exception $e) {echo "NO";} try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $userdir.$row2["media_id"]."_thumb.".$row2["media_ext"] )); }catch (Exception $e) {echo "NO";} //call from cloud $database->database_query("DELETE FROM se_mediacomments WHERE mediacomment_media_id='".$row2["media_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_mediatags WHERE mediatag_media_id='".$row2["media_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM likedmedia WHERE media_id='".$row2["media_id"]."'") or die($database->database_error()); } $database->database_query("DELETE FROM se_media WHERE media_album_id='".$row1["album_id"]."'") or die($database->database_error()); } $database->database_query("DELETE FROM se_albums WHERE album_user_id='".$row["user_id"]."'") or die($database->database_error()); $query1=$database->database_query("SELECT * FROM se_blogentries WHERE blogentry_user_id='".$row["user_id"]."'") or die($database->database_error()); while($row1=$database->database_fetch_array($query1)){ $database->database_query("DELETE FROM se_blogcomments WHERE blogcomment_blogentry_id='".$row1["blogentry_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_blogpings WHERE blogping_blogentry_id='".$row1["blogentry_id"]."'") or die($database->database_error()); } $database->database_query("DELETE FROM se_blogentries WHERE blogentry_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_blogentrycats WHERE blogentrycat_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_blogdrafts WHERE blogentry_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_blogsubscriptions WHERE blogsubscription_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_blogsubscriptions WHERE blogsubscription_owner_id='".$row["user_id"]."'") or die($database->database_error()); $query3=$database->database_query("SELECT * FROM se_events WHERE event_user_id='".$row["user_id"]."'") or die($database->database_error()); while($row3=$database->database_fetch_array($query3)){ $query1=$database->database_query("SELECT * FROM se_eventalbums WHERE eventalbum_event_id='".$row3["event_id"]."'") or die($database->database_error()); while($row1=$database->database_fetch_array($query1)){ $subdir = $row1["eventalbum_event_id"]+999-(($row1["eventalbum_event_id"]-1)%1000); $eventdir = "uploads_event/$subdir/".$row1["eventalbum_event_id"]."/"; $query2=$database->database_query("SELECT * FROM se_eventmedia WHERE eventmedia_eventalbum_id='".$row1["eventalbum_id"]."'") or die($database->database_error()); while($row2=$database->database_fetch_array($query2)){ try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $eventdir.$row2["eventmedia_id"].".".$row2["eventmedia_ext"] )); }catch (Exception $e) {echo "NO";} try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $eventdir.$row2["eventmedia_id"]."_thumb.".$row2["eventmedia_ext"] )); }catch (Exception $e) {echo "NO";} //call from cloud $database->database_query("DELETE FROM se_eventmediacomments WHERE eventmediacomment_eventmedia_id='".$row2["eventmedia_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_eventmediatags WHERE eventmediatag_eventmedia_id='".$row2["eventmedia_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM likedeventmedia WHERE media_id='".$row2["eventmedia_id"]."'") or die($database->database_error()); } $database->database_query("DELETE FROM se_eventmedia WHERE eventmedia_eventalbum_id='".$row1["eventalbum_id"]."'") or die($database->database_error()); } $database->database_query("DELETE FROM se_eventvalues WHERE eventvalue_event_id='".$row3["event_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_eventcomments WHERE eventcomment_event_id='".$row3["event_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_eventmembers WHERE eventmember_event_id='".$row3["event_id"]."'") or die($database->database_error()); } $query2=$database->database_query("SELECT * FROM se_eventmedia WHERE eventmedia_user_id='".$row["user_id"]."'") or die($database->database_error()); while($row2=$database->database_fetch_array($query2)){ $query3=$database->database_query("SELECT * FROM se_events, se_eventalbums WHERE eventalbum_event_id=event_id AND eventalbum_id='".$row2["eventmedia_eventalbum_id"]."'") or die($database->database_error()); $row3=$database->database_fetch_array($query3); $subdir = $row3["eventalbum_event_id"]+999-(($row3["eventalbum_event_id"]-1)%1000); $eventdir = "uploads_event/$subdir/".$row3["eventalbum_event_id"]."/"; try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $eventdir.$row2["eventmedia_id"].".".$row2["eventmedia_ext"] )); }catch (Exception $e) {echo "NO";} try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $eventdir.$row2["eventmedia_id"]."_thumb.".$row2["eventmedia_ext"] )); }catch (Exception $e) {echo "NO";} //call from cloud $database->database_query("DELETE FROM se_eventmediacomments WHERE eventmediacomment_eventmedia_id='".$row2["eventmedia_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_eventmediatags WHERE eventmediatag_eventmedia_id='".$row2["eventmedia_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM likedeventmedia WHERE media_id='".$row2["eventmedia_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_eventmedia WHERE eventmedia_id='".$row2["eventmedia_id"]."'") or die($database->database_error()); } $database->database_query("DELETE FROM se_eventmembers WHERE eventmember_user_id='".$row["user_id"]."'") or die($database->database_error()); $query2=$database->database_query("SELECT * FROM se_groupmedia WHERE groupmedia_user_id='".$row["user_id"]."'") or die($database->database_error()); while($row2=$database->database_fetch_array($query2)){ $query3=$database->database_query("SELECT * FROM se_groups, se_groupalbums WHERE groupalbum_group_id=group_id AND groupalbum_id='".$row2["groupmedia_groupalbum_id"]."'") or die($database->database_error()); $row3=$database->database_fetch_array($query3); $subdir = $row3["groupalbum_group_id"]+999-(($row3["groupalbum_group_id"]-1)%1000); $groupdir = "uploads_group/$subdir/".$row3["groupalbum_group_id"]."/"; try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $groupdir.$row2["groupmedia_id"].".".$row2["groupmedia_ext"] )); }catch (Exception $e) {echo "NO";} try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $groupdir.$row2["groupmedia_id"]."_thumb.".$row2["groupmedia_ext"] )); }catch (Exception $e) {echo "NO";} //call from cloud $database->database_query("DELETE FROM se_groupmediacomments WHERE groupmediacomment_groupmedia_id='".$row2["groupmedia_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_groupmediatags WHERE groupmediatag_groupmedia_id='".$row2["groupmedia_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM likedgroupmedia WHERE media_id='".$row2["groupmedia_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_groupmedia WHERE groupmedia_id='".$row2["groupmedia_id"]."'") or die($database->database_error()); } $query2=$database->database_query("SELECT * FROM se_group_videos WHERE video_user_id='".$row["user_id"]."'") or die($database->database_error()); while($row2=$database->database_fetch_array($query2)){ $subdir = $row3["video_group_id"]+999-(($row3["video_group_id"]-1)%1000); $eventdir = "uploads_group/$subdir/".$row3["video_group_id"]."/"; try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $groupdir."video_".$row2["video_id"].".mp4" )); }catch (Exception $e) {echo "NO";} try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $groupdir."video_".$row2["video_id"]."-1080.mp4" )); }catch (Exception $e) {echo "NO";} try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $groupdir."video_".$row2["video_id"]."-720.mp4" )); }catch (Exception $e) {echo "NO";} try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $groupdir."video_".$row2["video_id"]."-480.mp4" )); }catch (Exception $e) {echo "NO";} try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $groupdir."video_".$row2["video_id"]."-240.mp4" )); }catch (Exception $e) {echo "NO";} try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $groupdir."video_".$row2["video_id"]."_thumb.jpg" )); }catch (Exception $e) {echo "NO";} //call from cloud $database->database_query("DELETE FROM groupvideocomments WHERE object_id='".$row2["video_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM groupvideoratings WHERE video_id='".$row2["video_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM likedgroupvideos WHERE media_id='".$row2["video_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_groupvideotags WHERE mediatag_media_id='".$row2["video_id"]."'") or die($database->database_error()); } $database->database_query("DELETE FROM groupvideocomments WHERE authoruser_id='".$row["user_id"]."'") or die($database->database_error()); $query2=$database->database_query("DELETE FROM se_group_videos WHERE video_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_groupmembers WHERE groupmember_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_forumlogs WHERE forumlog_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_he_user_note WHERE viewer_id='".$row["user_id"]."'") or die($database->database_error()); $query1=$database->database_query("SELECT * FROM se_music WHERE music_user_id='".$row["user_id"]."'") or die($database->database_error()); while($row1=$database->database_fetch_array($query1)){ try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $userdir.$row1["music_id"].".".$row1["music_ext"] )); }catch (Exception $e) {echo "NO";} //call from cloud $database->database_query("DELETE FROM se_music WHERE music_id='".$row1["music_id"]."'") or die($database->database_error()); } $database->database_query("DELETE FROM se_notifys WHERE notify_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_pmconvoops WHERE pmconvoop_user_id='".$row["user_id"]."'") or die($database->database_error()); $query1=$database->database_query("SELECT * FROM se_pms WHERE pm_authoruser_id='".$row["user_id"]."'") or die($database->database_error()); while($row1=$database->database_fetch_array($query1)){ //call from cloud $database->database_query("DELETE FROM se_pmconvos WHERE pmconvo_id='".$row1["pm_pmconvo_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_pmconvoops WHERE pmconvoop_pmconvo_id='".$row1["pm_pmconvo_id"]."'") or die($database->database_error()); } $database->database_query("DELETE FROM se_pms WHERE pm_authoruser_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_pollcomments WHERE pollcomment_authoruser_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_polls WHERE poll_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_profilecomments WHERE profilecomment_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_profilecomments WHERE profilecomment_authoruser_id='".$row["user_id"]."'") or die($database->database_error()); //$database->database_query("UPDATE se_profilevalues SET profilevalue_5=-1, profilevalue_9=-1, profilevalue_10=-1, profilevalue_13='', profilevalue_15=-1, profilevalue_16=-1, profilevalue_17='', profilevalue_21='', profilevalue_22='', profilevalue_27='', profilevalue_28=-1, profilevalue_29=-1, profilevalue_30=-1, profilevalue_31=-1, profilevalue_32=-1, profilevalue_33='', profilevalue_34='', profilevalue_35='', profilevalue_37='', profilevalue_38='', profilevalue_39='', profilevalue_41='', profilevalue_42='', profilevalue_43='', profilevalue_44='', profilevalue_46='', profilevalue_47='', profilevalue_48='', profilevalue_49='', profilevalue_50='', profilevalue_51='', profilevalue_53='', profilevalue_54='', profilevalue_55='', weight='', height='', girthsize='', cocksize='', unitofmeasurement='' WHERE profilevalue_user_id='".$row["user_id"]."'") or die($database->database_error()); //$query=$database->database_query("DELETE FROM se_users WHERE profilevalue_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_profileviews WHERE profileview_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_usersettings WHERE usersetting_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_videoalbums WHERE album_user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_videocomments WHERE videocomment_authoruser_id ='".$row["user_id"]."'") or die($database->database_error()); $query2=$database->database_query("SELECT * FROM se_videos WHERE video_user_id ='".$row["user_id"]."'") or die($database->database_error()); while($row2=$database->database_fetch_array($query2)){ $database->database_query("DELETE FROM se_videocomments WHERE videocomment_video_id='".$row2["video_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_videoratings WHERE videorating_video_id='".$row2["video_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM se_videotags WHERE mediatag_media_id='".$row2["video_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM likedvideos WHERE media_id='".$row2["video_id"]."'") or die($database->database_error()); //call from cloud try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $videodir.$row2["video_id"].".mp4" )); }catch (Exception $e) {echo "NO";} try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $videodir.$row2["video_id"]."-1080.mp4" )); }catch (Exception $e) {echo "NO";} try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $videodir.$row2["video_id"]."-720.mp4" )); }catch (Exception $e) {echo "NO";} try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $videodir.$row2["video_id"]."-480.mp4" )); }catch (Exception $e) {echo "NO";} try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $videodir.$row2["video_id"]."-240.mp4" )); }catch (Exception $e) {echo "NO";} try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => $videodir.$row2["video_id"]."_thumb.jpg" )); }catch (Exception $e) {echo "NO";} $database->database_query("DELETE FROM se_videos WHERE video_id='".$row2["video_id"]."'") or die($database->database_error()); } $database->database_query("DELETE FROM status WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM status_media WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); $database->database_query("DELETE FROM travelers WHERE userid='".$row["user_id"]."'") or die($database->database_error()); //$database->database_query("UPDATE se_users SET pendingdelete=0 WHERE user_id='".$row["user_id"]."'") or die($database->database_error()); //$database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='{$row["user_id"]}', time='".time()."', action='User profile has been deleted'"); } function user_delete_old() { global $database, $url, $global_plugins; return; // CALL USER DELETE HOOK ($hook = \SE_Hook::exists('se_user_delete')) ? \SE_Hook::call($hook, $this->user_info['user_id']) : NULL; // DELETE USER, USERSETTING, PROFILE, STYLES TABLE ROWS $database->database_query("DELETE FROM se_users WHERE user_id='{$this->user_info['user_id']}' LIMIT 1"); $database->database_query("DELETE FROM se_usersettings WHERE usersetting_user_id='{$this->user_info['user_id']}' LIMIT 1"); $database->database_query("DELETE FROM se_profilevalues WHERE profilevalue_user_id='{$this->user_info['user_id']}' LIMIT 1"); // $database->database_query("DELETE FROM se_profilestyles WHERE profilestyle_user_id='{$this->user_info['user_id']}' LIMIT 1"); // DELETE USER-OWNED AND PROFILE COMMENTS $database->database_query("DELETE FROM se_profilecomments WHERE profilecomment_user_id='{$this->user_info['user_id']}'"); // DELETE NOTIFICATIONS SENT TO OTHER USERS FOR A PM THEY SENT $database->database_query("DELETE se_notifys.* FROM se_pmconvoops LEFT JOIN se_notifys ON se_notifys.notify_object_id=se_pmconvoops.pmconvoop_pmconvo_id WHERE se_notifys.notify_notifytype_id=2 && se_pmconvoops.pmconvoop_user_id='{$this->user_info['user_id']}'"); // DELETE PMCONVOS AND PMS WHERE THE DELETED USER AND THE OTHER USER ARE THE ONLY TWO INSIDE, OR WHERE THE DELETED USER WAS THE INITIAL SENDER $database->database_query("UPDATE se_pmconvos LEFT JOIN se_pmconvoops ON pmconvoop_pmconvo_id=pmconvo_id SET pmconvo_recipients=pmconvo_recipients-1 WHERE pmconvoop_user_id='{$this->user_info['user_id']}'"); $database->database_query("UPDATE se_pmconvos LEFT JOIN se_pmconvoops ON pmconvoop_pmconvo_id=pmconvo_id SET pmconvo_recipients=0 WHERE pmconvoop_user_id='{$this->user_info['user_id']}' && pmconvoop_user_id=(SELECT pm_authoruser_id FROM se_pms WHERE pm_pmconvo_id=pmconvo_id ORDER BY pm_id ASC)"); $database->database_query("DELETE FROM se_pmconvoops WHERE pmconvoop_user_id='{$this->user_info['user_id']}'"); // THIS MAY ALSO DELETE OTHER CONVOS THAT WERE PARTIALLY REMOVED $database->database_query("DELETE se_pms.*, se_pmconvos.*, se_pmconvoops.* FROM se_pmconvos LEFT JOIN se_pms ON pm_pmconvo_id=pmconvo_id LEFT JOIN se_pmconvoops ON pmconvoop_pmconvo_id=pmconvo_id WHERE pmconvo_recipients<2"); // DELETE CONNECTIONS TO AND FROM USER $database->database_query("DELETE FROM se_friends, se_friendexplains USING se_friends LEFT JOIN se_friendexplains ON se_friends.friend_id=se_friendexplains.friendexplain_friend_id WHERE se_friends.friend_user_id1='{$this->user_info['user_id']}' OR se_friends.friend_user_id2='{$this->user_info['user_id']}'"); // DELETE ALL OF THIS USER'S REPORTS $database->database_query("DELETE FROM se_reports WHERE report_user_id='{$this->user_info['user_id']}'"); // DELETE USER ACTIONS //$database->database_query("DELETE FROM se_actions, se_actionmedia USING se_actions LEFT JOIN se_actionmedia ON se_actions.action_id=se_actionmedia.actionmedia_action_id WHERE action_user_id='{$this->user_info['user_id']}'"); // DELETE USER NOTIFICATIONS // $database->database_query("DELETE FROM se_notifys WHERE notify_user_id='{$this->user_info['user_id']}'"); $database->database_query("UPDATE se_notifys SET isread=1 WHERE notify_user_id='{$this->user_info['user_id']}'"); // DELETE NOTIFICATIONS BY USER //$database->database_query("DELETE FROM se_notifys WHERE notify_notifytype_id=1 AND notify_object_id='{$this->user_info['user_id']}'"); $database->database_query("UPDATE se_notifys SET isread=1 WHERE notify_notifytype_id=1 AND notify_object_id='{$this->user_info['user_id']}'"); // DELETE USER'S FILES if( is_dir($url->url_userdir($this->user_info['user_id'])) ) $dir = $url->url_userdir($this->user_info['user_id']); else $dir = ".".$url->url_userdir($this->user_info['user_id']); if( $dh = @opendir($dir) ) { $client = new MyS3Wrapper([ 'region' => 'us-north-1', 'version' => 'latest', 'endpoint' => ENDPOINT, 'credentials' => [ 'key' => AWS_KEY, 'secret' => AWS_SECRET_KEY ], // Set the S3 class to use objects.dreamhost.com/bucket // instead of bucket.objects.dreamhost.com 'use_path_style_endpoint' => true ]); while( ($file = @readdir($dh)) !== false ) { if( $file != "." && $file != ".." ) { @unlink($dir.$file); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$dir.$file), ));}catch (Exception $e) {} } } @closedir($dh); } @rmdir($dir); if( is_dir(video_dir($this->user_info['user_id'])) ) $dir = video_dir($this->user_info['user_id']); else $dir = ".".video_dir($this->user_info['user_id']); if( $dh = @opendir($dir) ) { $client = new MyS3Wrapper([ 'region' => 'us-north-1', 'version' => 'latest', 'endpoint' => ENDPOINT, 'credentials' => [ 'key' => AWS_KEY, 'secret' => AWS_SECRET_KEY ], // Set the S3 class to use objects.dreamhost.com/bucket // instead of bucket.objects.dreamhost.com 'use_path_style_endpoint' => true ]); while( ($file = @readdir($dh)) !== false ) { if( $file != "." && $file != ".." ) { @unlink($dir.$file); try { $client->deleteObject(array( 'Bucket'=>'bateworld', 'Key' => str_replace("./", "",$dir.$file), ));}catch (Exception $e) {} } } @closedir($dh); } @rmdir($dir); $this->user_clear(); } function user_spam(){ global $database, $url, $global_plugins; $database->database_query("UPDATE se_users SET user_enabled=-1, user_pdp_evc = '0', activitystatuschangedate='".time()."' WHERE user_id='".$this->user_info["user_id"]."'"); $database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='".$user->user_info["user_id"]."', action='Admin changed user status updated', time='".time()."'"); $query = $database->database_query("SELECT * FROM ips WHERE user_id='".$this->user_info["user_id"]."'"); while($row = $database->database_fetch_array($query)) { $database->database_query("Insert into bateworldcom_zips.abuseips SET ip = '".$row["ip"]."', date='".time()."'"); } $database->database_query("Insert into bateworldcom_zips.abuseips SET ip = '".$this->user_info["user_ip_signup"]."', date='".time()."'"); $database->database_query("Insert into bateworldcom_zips.abuseips SET ip = '".$this->user_info["user_ip_lastactive"]."', date='".time()."'"); } function user_disable(){ global $database, $url, $global_plugins; $database->database_query("UPDATE se_users SET user_enabled=0, user_pdp_evc = '0', activitystatuschangedate='".time()."' WHERE user_id='".$this->user_info["user_id"]."'"); $database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='".$user->user_info["user_id"]."', action='Admin changed user status updated', time='".time()."'"); $database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='{$user->user_info['user_id']}', time='".time()."', action='User has disabled their account'"); } // END user_delete() METHOD // // THIS METHOD RETURNS THE TOTAL NUMBER OF MESSAGES // // INPUT: // $direction (OPTIONAL) REPRESENTING A "0" FOR MESSAGES SENT TO USER AND "1" FOR MESSAGES SENT BY USER // $unread_only (OPTIONAL) REPRESENTING A "0" FOR ALL MESSAGES AND A "1" FOR UNREAD MESSAGES ONLY // // OUTPUT: // AN INTEGER REPRESENTING THE NUMBER OF MESSAGES // function user_message_total($direction=0, $unread_only=FALSE, $where=NULL, $do_joins=FALSE, $club=0) { global $database; $message_total = 0; // MAKE SURE MESSAGES ARE ALLOWED if( empty($this->level_info['level_message_allow']) ) return FALSE; // BEGIN MESSAGE QUERY $sql = " SELECT COUNT(pmconvoop_id) as pm_total FROM se_pmconvoops "; // JOIN TO PM AND PMCONVO TABLES if( $do_joins ) $sql .= " LEFT JOIN se_pmconvos ON se_pmconvos.pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id LEFT JOIN se_users ON se_users.user_id=se_pmconvoops_other.pmconvoop_user_id "; $sql .= " WHERE se_pmconvoops.pmconvoop_user_id='{$this->user_info['user_id']}' "; //if( $direction ) { $sql .= " AND club='".$club."' ";//} // INCOMING MESSAGES if( !$direction ) $sql .= " && se_pmconvoops.pmconvoop_deleted_inbox=0 "; // OUTGOING MESSAGES if( $direction ) $sql .= " && /* THIS IS REMOVED BECAUSE I AM HOPING THE deleted_outbox WILL HANDLE IT se_pms.pm_authoruser_id='{$this->user_info['user_id']}' && */ se_pmconvoops.pmconvoop_deleted_outbox=0 "; // READ ONLY if( $unread_only ) $sql .= " && se_pmconvoops.pmconvoop_read=0 "; // ADD WHERE if( $where ) $sql .= " && {$where} "; // ADD GROUP BY IF JOINING if( $do_joins ) $sql .= " GROUP BY se_pmconvoops.pmconvoop_pmconvo_id "; // RUN QUERY AND RETURN $resource = $database->database_query($sql); $result = $database->database_fetch_assoc($resource); //return (int) $database->database_num_rows($resource); return (int) $result['pm_total']; } // END user_message_total() METHOD function &admin_user_message_list($start=NULL, $limit=NULL, $direction=0, $where=NULL) { global $database; $message_array = array(); // MAKE SURE MESSAGES ARE ALLOWED if( empty($this->level_info['level_message_allow']) ) return FALSE; // BEGIN MESSAGE QUERY $sql = " SELECT se_pmconvos.*, se_pms.*, se_pms.club AS club1,se_pmconvoops.club AS club2, se_pmconvoops_user.pmconvoop_read, se_users.user_id, se_users.user_enabled, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo "; // GET MESSAGE AUTHOR, REPLIED STATUS if( !$direction ) $sql .= ", (SELECT TRUE FROM se_pms WHERE pm_pmconvo_id=se_pmconvos.pmconvo_id && pm_authoruser_id='{$this->user_info['user_id']}' ORDER BY pm_id DESC LIMIT 1) AS pm_replied "; // CONTINUE QUERY $sql .= " FROM se_pmconvoops AS se_pmconvoops_user LEFT JOIN se_pmconvos ON se_pmconvoops_user.pmconvoop_pmconvo_id=se_pmconvos.pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id "; // INCOMING MESSAGES - JOIN TO USER TABLE TO GET AUTHOR if( !$direction ) $sql .= " LEFT JOIN se_users ON se_users.user_id=se_pms.pm_authoruser_id"; // OUTGOING MESSAGES - JOIN TO PMCONVOOPS AND USER TABLE TO GET RECIPIENT if( $direction ) $sql .= " LEFT JOIN se_pmconvoops AS se_pmconvoops_other ON (se_pmconvoops_other.pmconvoop_pmconvo_id=se_pmconvos.pmconvo_id && se_pmconvoops_other.pmconvoop_user_id!='{$this->user_info['user_id']}') LEFT JOIN se_users ON se_users.user_id=se_pmconvoops_other.pmconvoop_user_id "; // CONTINUE QUERY $sql .= " WHERE se_pmconvoops_user.pmconvoop_user_id='{$this->user_info['user_id']}' "; // INCOMING MESSAGES if( !$direction ) $sql .= " && se_pmconvoops_user.pmconvoop_deleted_inbox=0 "; // OUTGOING MESSAGES if( $direction ) $sql .= " && se_pmconvoops_user.pmconvoop_deleted_outbox=0 "; // CONTINUE QUERY $sql .= " && se_pms.pm_id=( SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvos.pmconvo_id "; // INCOMING MESSAGES if( !$direction ) $sql .= " && se_pms.pm_authoruser_id!='{$this->user_info['user_id']}' "; // OUTGOING MESSAGES if( $direction ) $sql .= " && se_pms.pm_authoruser_id='{$this->user_info['user_id']}' "; // CONTINUE QUERY $sql .= " ) "; // ADD WHERE if( $where ) $sql .= " && {$where}"; /* GROUP BY se_pmconvoops_user.pmconvoop_pmconvo_id */ if($_GET["s"]=="unread"||$_POST["s"]=="unread") { $sql .= " ORDER BY se_pmconvoops_user.pmconvoop_read ASC, se_pmconvoops_user.pmconvoop_pmdate DESC /* se_pms.pm_date DESC */ LIMIT $start, $limit "; } elseif($_GET["s"]=="u"||$_POST["s"]=="u"){ $sql .= " ORDER BY se_users.user_username ASC /* se_pms.pm_date DESC */ LIMIT $start, $limit "; }else{ $sql .= " ORDER BY se_pmconvoops_user.pmconvoop_pmdate DESC /* se_pms.pm_date DESC */ LIMIT $start, $limit "; } // EXECUTE QUERY $resource = $database->database_query($sql); // GET MESSAGES while( $message_info=$database->database_fetch_assoc($resource) ) { // CREATE AN OBJECT FOR MESSAGE AUTHOR/RECIPIENT $pm_user = new SEUser(); $pm_user->user_info['user_id'] = $message_info['user_id']; $pm_user->user_info['user_username'] = $message_info['user_username']; $pm_user->user_info['user_photo'] = $message_info['user_photo']; $pm_user->user_info['user_fname'] = $message_info['user_fname']; $pm_user->user_info['user_lname'] = $message_info['user_lname']; $pm_user->user_info['user_enabled'] = $message_info['user_enabled']; $pm_user->user_displayname(); // Remove breaks for preview $message_info['pm_body'] = str_replace("
", "", $message_info['pm_body']); // SET MESSAGE ARRAY $message_array[] = array( 'pmconvo_id' => $message_info['pmconvo_id'], 'pmconvo_subject' => $message_info['pmconvo_subject'], 'pm_date' => $message_info['pm_date'], 'pm_read' => (bool) $message_info['pmconvoop_read'], 'pm_replied' => $message_info['pm_replied'], 'pm_body' => $message_info['pm_body'], 'pm_user' => &$pm_user, 'pm_recipients' => $message_info['pmconvo_recipients'] - 1 ); unset($pm_user); } return $message_array; } // // THIS METHOD RETURNS AN ARRAY OF USER'S MESSAGES // // INPUT: // $start REPRESENTING THE MESSAGE TO START WITH // $limit REPRESENTING THE NUMBER OF MESSAGES TO RETURN // $direction (OPTIONAL) REPRESENTING A "0" FOR MESSAGES SENT TO USER AND "1" FOR MESSAGES SENT BY USER // $where (OPTIONAL) // // OUTPUT: // AN ARRAY OF THE USER'S MESSAGES // function &sean_user_message_list($start=NULL, $limit=NULL, $direction=0, $where=NULL, $club=0) { global $database; $message_array = array(); // MAKE SURE MESSAGES ARE ALLOWED if( empty($this->level_info['level_message_allow']) ) return FALSE; // BEGIN MESSAGE QUERY $sql = " SELECT se_pmconvos.*, se_pms.*, se_pmconvoops_user.pmconvoop_read, se_users.user_id, se_users.user_enabled, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo "; // GET MESSAGE AUTHOR, REPLIED STATUS if( !$direction ) $sql .= ", (SELECT TRUE FROM se_pms WHERE pm_pmconvo_id=se_pmconvos.pmconvo_id && pm_authoruser_id='{$this->user_info['user_id']}' AND club='".$club."' ORDER BY pm_id DESC LIMIT 1) AS pm_replied "; // CONTINUE QUERY $sql .= " FROM se_pmconvoops AS se_pmconvoops_user LEFT JOIN se_pmconvos ON se_pmconvoops_user.pmconvoop_pmconvo_id=se_pmconvos.pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id "; // INCOMING MESSAGES - JOIN TO USER TABLE TO GET AUTHOR if( !$direction ) $sql .= " LEFT JOIN se_users ON se_users.user_id=se_pms.pm_authoruser_id"; // OUTGOING MESSAGES - JOIN TO PMCONVOOPS AND USER TABLE TO GET RECIPIENT if( $direction ) $sql .= " LEFT JOIN se_pmconvoops AS se_pmconvoops_other ON (se_pmconvoops_other.pmconvoop_pmconvo_id=se_pmconvos.pmconvo_id && se_pmconvoops_other.pmconvoop_user_id!='{$this->user_info['user_id']}') LEFT JOIN se_users ON se_users.user_id=se_pmconvoops_other.pmconvoop_user_id "; // CONTINUE QUERY $sql .= " WHERE se_pmconvoops_user.pmconvoop_user_id='{$this->user_info['user_id']}' "; if( $direction ) {$sql .= " AND club='".$club."'";} // INCOMING MESSAGES if( !$direction ) $sql .= " && se_pmconvoops_user.pmconvoop_deleted_inbox=0 "; // OUTGOING MESSAGES if( $direction ) $sql .= " && se_pmconvoops_user.pmconvoop_deleted_outbox=0 "; // CONTINUE QUERY $sql .= " && se_pms.pm_id=( SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvos.pmconvo_id "; // INCOMING MESSAGES if( !$direction ) $sql .= " && se_pms.pm_authoruser_id!='{$this->user_info['user_id']}' "; // OUTGOING MESSAGES if( $direction ) $sql .= " && se_pms.pm_authoruser_id='{$this->user_info['user_id']}' "; // CONTINUE QUERY $sql .= " ) "; // ADD WHERE if( $where ) $sql .= " && {$where}"; /* GROUP BY se_pmconvoops_user.pmconvoop_pmconvo_id */ if($_GET["s"]=="unread"||$_POST["s"]=="unread") { $sql .= " ORDER BY se_pmconvoops_user.pmconvoop_read ASC, se_pmconvoops_user.pmconvoop_pmdate DESC /* se_pms.pm_date DESC */ LIMIT $start, $limit "; } elseif($_GET["s"]=="u"||$_POST["s"]=="u"){ $sql .= " ORDER BY se_users.user_username ASC /* se_pms.pm_date DESC */ LIMIT $start, $limit "; }else{ $sql .= " ORDER BY se_pmconvoops_user.pmconvoop_pmdate DESC /* se_pms.pm_date DESC */ LIMIT $start, $limit "; } // EXECUTE QUERY $resource = $database->database_query($sql); // GET MESSAGES while( $message_info=$database->database_fetch_assoc($resource) ) { // CREATE AN OBJECT FOR MESSAGE AUTHOR/RECIPIENT if($message_info["club"]==0){ $pm_user = new SEUser(); $pm_user->user_info['user_id'] = $message_info['user_id']; $pm_user->user_info['user_username'] = $message_info['user_username']; $pm_user->user_info['user_photo'] = $message_info['user_photo']; $pm_user->user_info['user_fname'] = $message_info['user_fname']; $pm_user->user_info['user_lname'] = $message_info['user_lname']; $pm_user->user_info['user_enabled'] = $message_info['user_enabled']; $pm_user->user_displayname(); }else{ $query = $database->database_query("SELECT club_title, club_photo FROM se_clubs WHERE club_id='".$database->database_real_escape_string($message_info['pm_authoruser_id'])."'"); // GET MESSAGES $row=$database->database_fetch_array($query); $pm_user = new SEUser(); $pm_user->user_info['user_id'] = $message_info['pm_authoruser_id']; $pm_user->user_info['user_username'] = $row["club_title"];// $message_info['user_username']; $pm_user->user_info['user_photo'] = $message_info['club_photo']; $pm_user->user_info['user_enabled'] = 1; $pm_user->user_displayname(); } // Remove breaks for preview $message_info['pm_body'] = str_replace("
", "", $message_info['pm_body']); // SET MESSAGE ARRAY $message_array[] = array( 'pmconvo_id' => $message_info['pmconvo_id'], 'pmconvo_subject' => $message_info['pmconvo_subject'], 'pm_date' => $message_info['pm_date'], 'pm_read' => (bool) $message_info['pmconvoop_read'], 'pm_replied' => $message_info['pm_replied'], 'pm_body' => $message_info['pm_body'], 'pm_user' => &$pm_user, 'pm_recipients' => $message_info['pmconvo_recipients'] - 1, 'club' => $message_info['club'] ); unset($pm_user); } return $message_array; } function &user_message_list($start=NULL, $limit=NULL, $direction=0, $where=NULL, $club=0) { global $database; $message_array = array(); // MAKE SURE MESSAGES ARE ALLOWED if( empty($this->level_info['level_message_allow']) ) return FALSE; // BEGIN MESSAGE QUERY $sql = " SELECT se_pmconvos.*, se_pms.*, se_pmconvoops_user.pmconvoop_read, se_users.user_id, se_users.user_enabled, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo , se_pms.club AS se_pms_club1,se_pmconvoops_user.club AS se_pms_club2 "; //$sql .= ""; // GET MESSAGE AUTHOR, REPLIED STATUS if( !$direction ) $sql .= ", (SELECT TRUE FROM se_pms WHERE pm_pmconvo_id=se_pmconvos.pmconvo_id && pm_authoruser_id='{$this->user_info['user_id']}' AND club='".$club."' ORDER BY pm_id DESC LIMIT 1) AS pm_replied "; // CONTINUE QUERY $sql .= " FROM se_pmconvoops AS se_pmconvoops_user LEFT JOIN se_pmconvos ON se_pmconvoops_user.pmconvoop_pmconvo_id=se_pmconvos.pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id "; // INCOMING MESSAGES - JOIN TO USER TABLE TO GET AUTHOR if( !$direction ) $sql .= " LEFT JOIN se_users ON se_users.user_id=se_pms.pm_authoruser_id"; // OUTGOING MESSAGES - JOIN TO PMCONVOOPS AND USER TABLE TO GET RECIPIENT if( $direction ) $sql .= " LEFT JOIN se_pmconvoops AS se_pmconvoops_other ON (se_pmconvoops_other.pmconvoop_pmconvo_id=se_pmconvos.pmconvo_id && se_pmconvoops_other.pmconvoop_user_id!='{$this->user_info['user_id']}') LEFT JOIN se_users ON se_users.user_id=se_pmconvoops_other.pmconvoop_user_id "; // CONTINUE QUERY $sql .= " WHERE se_pmconvoops_user.pmconvoop_user_id='{$this->user_info['user_id']}' "; if( $direction ) {$sql .= " AND se_pms.club='".$club."'";} // INCOMING MESSAGES if( !$direction ) $sql .= " && se_pmconvoops_user.pmconvoop_deleted_inbox=0 "; // OUTGOING MESSAGES if( $direction ) $sql .= " && se_pmconvoops_user.pmconvoop_deleted_outbox=0 "; // CONTINUE QUERY $sql .= " && se_pms.pm_id=( SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvos.pmconvo_id "; // INCOMING MESSAGES if( !$direction ) $sql .= " && se_pms.pm_authoruser_id!='{$this->user_info['user_id']}' "; // OUTGOING MESSAGES if( $direction ) $sql .= " && se_pms.pm_authoruser_id='{$this->user_info['user_id']}' "; // CONTINUE QUERY $sql .= " ) "; // ADD WHERE if( $where ) $sql .= " && {$where}"; /* GROUP BY se_pmconvoops_user.pmconvoop_pmconvo_id */ if($_GET["s"]=="unread"||$_POST["s"]=="unread") { $sql .= " ORDER BY se_pmconvoops_user.pmconvoop_read ASC, se_pmconvoops_user.pmconvoop_pmdate DESC /* se_pms.pm_date DESC */ LIMIT $start, $limit "; } elseif($_GET["s"]=="u"||$_POST["s"]=="u"){ $sql .= " ORDER BY se_users.user_username ASC /* se_pms.pm_date DESC */ LIMIT $start, $limit "; }else{ $sql .= " ORDER BY se_pmconvoops_user.pmconvoop_pmdate DESC /* se_pms.pm_date DESC */ LIMIT $start, $limit "; } //if(SE_DEBUG1){echo $sql;} // EXECUTE QUERY $resource = $database->database_query($sql); // GET MESSAGES while( $message_info=$database->database_fetch_assoc($resource, MYSQLI_BOTH) ) { $is_club=0; $inconvo=false; $query=$database->database_query("SELECT club FROM se_pmconvoops WHERE pmconvoop_pmconvo_id='".$message_info["pmconvo_id"]."' AND pmconvoop_user_id='".$this->user_info["user_id"]."' AND club='".$club."'"); if($database->database_num_rows($query)>0){$inconvo=true;} if($inconvo){ // CREATE AN OBJECT FOR MESSAGE AUTHOR/RECIPIENT if($message_info["club"]==0&&$is_club==0){ $pm_user = new SEUser(); $pm_user->user_info['user_id'] = $message_info['user_id']; $pm_user->user_info['user_username'] = $message_info['user_username']; $pm_user->user_info['user_photo'] = $message_info['user_photo']; $pm_user->user_info['user_fname'] = $message_info['user_fname']; $pm_user->user_info['user_lname'] = $message_info['user_lname']; $pm_user->user_info['user_enabled'] = $message_info['user_enabled']; $pm_user->user_displayname(); }else{ $query = $database->database_query("SELECT club_title, club_photo, club_id FROM se_clubs WHERE club_id='".$database->database_real_escape_string($message_info['pm_authoruser_id'])."'"); // GET MESSAGES $row=$database->database_fetch_array($query); $pm_user = new SEUser(); $pm_user->user_info['user_id'] = $row['club_id']; $pm_user->user_info['user_username'] = $row["club_title"];// $message_info['user_username']; $pm_user->user_info['user_photo'] = $row['club_photo']; $pm_user->user_info['club']=1; $pm_user->user_info['user_enabled'] = 1; $pm_user->user_displayname(); } // Remove breaks for preview $message_info['pm_body'] = str_replace("
", "", $message_info['pm_body']); // SET MESSAGE ARRAY $message_array[] = array( 'pmconvo_id' => $message_info['pmconvo_id'], 'pmconvo_subject' => $message_info['pmconvo_subject'], 'pm_date' => $message_info['pm_date'], 'pm_read' => (bool) $message_info['pmconvoop_read'], 'pm_replied' => $message_info['pm_replied'], 'pm_body' => $message_info['pm_body'], 'pm_user' => &$pm_user, 'pm_recipients' => $message_info['pmconvo_recipients'] - 1, 'club' => $message_info['club'] ); unset($pm_user); } } return $message_array; } // END user_message_list() METHOD // // THIS METHOD SENDS A MESSAGE TO ANOTHER USER // // INPUT: // $to REPRESENTING A SEMI-COLON DELIMITED STRING OF USERNAMES OF THE RECIPIENTS // $subject REPRESENTING THE SUBJECT OF THE MESSAGE // $message REPRESENTING THE MESSAGE BODY // $convo_id (OPTIONAL) REPRESENTING THE CONVERSATION ID // // OUTPUT: // void // function user_message_send1($to, $subject, $message, $convo_id=NULL, $club=0) { global $database, $notify, $url; $recipients = array(); $recipients_full = array(); // VALIDATE CONVERSATION ID if( !$convo_id || !is_numeric($convo_id) ) $convo_id = 0; // CHECK TO SEE IF MESSAGE IS EMPTY if( !trim($message) ) $this->is_error = 796; // NEW MESSAGE if( !$convo_id ) { // ORGANIZE RECIPIENTS $tos = array_filter(preg_split('/[\s,;]+?/', $to)); array_splice($tos, $this->level_info['level_message_recipients']); // LOOP OVER RECIPIENTS foreach( $tos as $to_username ) { // CANT SEND TO SELF if( strtolower($to_username)==strtolower($this->user_info['user_username']) ) continue; // GET TO USER OBJECT $to_user = new \SEUser(array(NULL, $to_username)); // CANT SEND TO NON EXISTENT USER. BLOCKED USER, OR USERS NOT ALLOWED TO USE MESSAGES if( !$to_user->user_exists ) continue; if($this->user_info["staff"]!=1){if( $to_user->user_blocked($this->user_info['user_id']) ) continue;} if( !$this->level_info['level_message_allow'] ) continue; // CHECK MESSAGE TYPES AND ADD RECIPIENT if( $this->level_info['level_message_allow']==2 || ($this->level_info['level_message_allow']==1 && $this->user_friended($to_user->user_info['user_id'])) ) { $recipients_full[$to_user->user_info['user_id']] =& $to_user; $recipients[] = $to_user->user_info['user_id']; } } // ENSURE THERE ARE RECIPIENTS if( empty($recipients) ) $this->is_error = 795; $cansend=1; // if($this->user_points>9) { $cansend=1; } elseif($this->user_points<2) { $cansend=0; return; } elseif($this->user_points>=7) { $friends=$this->user_friend_list_all(); foreach($recipients as $y) { if(in_array($y, $friends)) { $to1.=$y.","; } else{$to2.=$y.",";} } $x1=explode(",", $to1); $cnt=count($x1); $cnt1=$database->database_result($database->database_query("SELECT COUNT(pm_id) FROM se_pms WHERE `pm_authoruser_id`='".$this->user_info["user_id"]."' AND pm_date>".(time()-(60*60))." ORDER BY pm_id DESC LIMIT 4"), 0); $cnt+=$cnt1; if($cnt<21) { $todo=21-$cnt; $r=0; $to2=explode(",",$to2); while($r<$todo) { if($to2[$r]!=""){ $to1.=$to2[$r].","; }$r++; } } $recipients=array_filter(explode(",", $to1)); if(count($recipients)==0){$this->is_error=1;} $cansend=1; } else{ $friends=$this->user_friend_list_all(); foreach($recipients as $y) { if(in_array($y, $friends)) { $to1.=$y.","; } //else{$to2.=$y.",";} } $x1=explode(",", $to1); $cnt=count($x1); $cnt1=$database->database_result($database->database_query("SELECT COUNT(pm_id) FROM se_pms WHERE `pm_authoruser_id`='".$this->user_info["user_id"]."' AND pm_date>".(time()-(60*60))." ORDER BY pm_id DESC LIMIT 4"), 0); $cnt+=$cnt1; $recipients=array_filter(explode(",", $to1)); if(count($recipients)==0){$this->is_error=1;} $cansend=1; } // IF NO ERROR, CREATE CONVERSATION if( !$this->is_error ) { // CREATE CONVO $sql = "INSERT INTO se_pmconvos (pmconvo_subject, pmconvo_recipients) VALUES ('".$database->database_real_escape_string($subject)."', '".(count($recipients)+1)."')"; //send_admin("leprakhauns@gmail.com", "111", $sql); $resource = $database->database_query($sql); $convo_id = $database->database_insert_id(); // CREATE CONVOOPS $sql = " INSERT INTO se_pmconvoops (pmconvoop_pmconvo_id, pmconvoop_user_id, pmconvoop_deleted_outbox, pmconvoop_deleted_inbox) VALUES ('{$convo_id}', '{$this->user_info['user_id']}', 0, 1)"; //$is_first = TRUE; foreach( $recipients as $to_user_id ) $sql .= ", ('{$convo_id}', '{$to_user_id}', 1, 0)"; // EXECUTE QUERY $resource = $database->database_query($sql); } } // GET RECIPIENTS AND VERIFY USER IS PART OF CONVERSATION else { $sql = "SELECT pmconvoop_user_id FROM se_pmconvoops WHERE pmconvoop_pmconvo_id='{$convo_id}'"; $resource = $database->database_query($sql); $unauthorized = TRUE; while( $pmconvoop_info=$database->database_fetch_assoc($resource) ) { if( $pmconvoop_info['pmconvoop_user_id']!=$this->user_info['user_id'] ) $recipients[] = $pmconvoop_info['pmconvoop_user_id']; else $unauthorized = FALSE; } // USER WAS NOT IN CONVERSATION if( $unauthorized ) $this->is_error = 39; // FIX THIS CODE RANDOM NUMBER TEMP } // IF NO ERROR, ADD MESSAGE TO CONVERSATION if( !$this->is_error ) { if($this->user_points<8){ // LINK ALL LINKS $message = preg_replace("~http(?:s)?\://([.]?[a-zA-Z0-9_/-?])*~", "\\0", $message); $message = preg_replace("~(^| |\n)(www([.]?[a-zA-Z0-9_/-?])*)~", "\\1\\2", $message); $message = preg_replace("~//([.]?[a-zA-Z0-9_/-?])*~", "\\0", $message); } // RUN SECURITY ON THE MESSAGE TO ENSURE NO XSS ATTACKS WITH LINKS $message = cleanHTML($message, "a"); // REPLACE NEWLINES IN BODY WITH BREAKS $message = str_replace("\n", "
", $message); //$message = str_replace("'", "\'", $message); $message=json_encode(htmlentities($message, ENT_QUOTES)); // INSERT MESSAGE $pm_date = time(); $sql = " INSERT INTO se_pms (pm_authoruser_id, pm_pmconvo_id, pm_date, pm_body, club) VALUES ('{$this->user_info['user_id']}', '{$convo_id}', '{$pm_date}', '".$database->database_real_escape_string($message)."', '".$club."') "; $resource = $database->database_query($sql); // UPDATE PMCONVOOPS $sql = "UPDATE se_pmconvoops SET pmconvoop_deleted_outbox=0, pmconvoop_pmdate='{$pm_date}' WHERE pmconvoop_pmconvo_id='{$convo_id}' && pmconvoop_user_id='{$this->user_info['user_id']}'"; $resource = $database->database_query($sql); $sql = "UPDATE se_pmconvoops SET pmconvoop_deleted_inbox=0, pmconvoop_read=0, pmconvoop_pmdate='{$pm_date}' WHERE pmconvoop_pmconvo_id='{$convo_id}' && pmconvoop_user_id!='{$this->user_info['user_id']}'"; $resource = $database->database_query($sql); // INSERT/SEND NOTIFICATIONS FOR RECIPIENTS // GET RECIPIENTS IF NOT INITIAL MESSAGE foreach( $recipients as $recipient_user_id ) { //if( empty($recipients_full[$recipient_user_id]) ) //{ $recipients_full[$recipient_user_id] = new \SEUser(array($recipient_user_id)); //} $current_recipient =& $recipients_full[$recipient_user_id]; // NOT A USER if( !is_object($current_recipient) || !$current_recipient->user_exists ) continue; // ADD NOTIFICATION $notify->notify_add($current_recipient->user_info['user_id'], 'message', $convo_id, array(), array(), TRUE, $this->user_info["user_id"]); // SEND EMAIL $current_recipient->user_settings('usersetting_notify_message'); if( $current_recipient->usersetting_info['usersetting_notify_message'] ) { $replace = array( '[username]' => $current_recipient->user_info["user_username"], '[displayname]' => $current_recipient->user_displayname, '[email]' => $current_recipient->user_info["user_email"], "[sender]"=>$this->user_displayname, '[userid]' => $user_id, '[link]' => "url_base}login.php\">{$url->url_base}login.php" ); send_systememail1('message', $current_recipient->user_info["user_email"], $replace); //send_systememail('message', $current_recipient->user_info["user_email"], array($current_recipient->user_displayname,$this->user_displayname,"url_base}login.php\">{$url->url_base}login.php")); } // CLEAN OUT THEM OLD MESSAGES $num_inbox = $current_recipient->user_message_total(0, 0); $num_outbox = $current_recipient->user_message_total(1, 0); $num_inbox_delete = $num_inbox - 100;//$current_recipient->level_info['level_message_inbox']; $num_outbox_delete = $num_outbox - 100;//$current_recipient->level_info['level_message_outbox']; // CLEAN OUT INBOX if( $num_inbox_delete>0 ) { $sql = " SELECT se_pmconvoops.pmconvoop_pmconvo_id AS pmconvo_id FROM se_pmconvoops LEFT JOIN se_pmconvos ON se_pmconvos.pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id WHERE se_pmconvoops.pmconvoop_user_id='{$current_recipient->user_info['user_id']}' && se_pmconvoops.pmconvoop_deleted_inbox=0 && se_pms.pm_id=(SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id) ORDER BY se_pms.pm_date ASC LIMIT {$num_inbox_delete} "; $resource = $database->database_query($sql); while( $result=$database->database_fetch_assoc($resource) ) $delete_array[] = $result['pmconvo_id']; // DELETE $current_recipient->user_message_delete_selected($delete_array, 0); } // CLEAN OUT OUTBOX if( $num_outbox_delete>0 ) { $sql = " SELECT se_pmconvoops.pmconvoop_pmconvo_id AS pmconvo_id FROM se_pmconvoops LEFT JOIN se_pmconvos ON se_pmconvos.pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id WHERE se_pmconvoops.pmconvoop_user_id='{$current_recipient->user_info['user_id']}' && se_pmconvoops.pmconvoop_deleted_outbox=0 && se_pms.pm_id=(SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id) ORDER BY se_pms.pm_date ASC LIMIT {$num_outbox_delete} "; $resource = $database->database_query($sql); while( $result=$database->database_fetch_assoc($resource) ) $delete_array[] = $result['pmconvo_id']; // DELETE $current_recipient->user_message_delete_selected($delete_array, 1); } // CLEAR INACTIVE CONVERSATIONS $this->user_message_cleanup(); } } return $convo_id; } function user_message_send($to, $subject, $message, $convo_id=NULL, $club=0) { global $database, $notify, $url, $newpmid, $pmtime; $recipients = array(); $recipients_full = array(); // VALIDATE CONVERSATION ID if( !$convo_id || !is_numeric($convo_id) ) $convo_id = 0; // CHECK TO SEE IF MESSAGE IS EMPTY if( !trim($message) ) $this->is_error = 796; // NEW MESSAGE if( !$convo_id ) { // ORGANIZE RECIPIENTS $tos = array_filter(preg_split('/[\s,;]+?/', $to)); array_splice($tos, $this->level_info['level_message_recipients']); // LOOP OVER RECIPIENTS foreach( $tos as $to_username ) { // CANT SEND TO SELF if( strtolower($to_username)==strtolower($this->user_info['user_username']) ) continue; // GET TO USER OBJECT $to_user = new \SEUser(array(NULL, $to_username)); // CANT SEND TO NON EXISTENT USER. BLOCKED USER, OR USERS NOT ALLOWED TO USE MESSAGES if( !$to_user->user_exists ) continue; if($this->user_info["staff"]!=1){if( $to_user->user_blocked($this->user_info['user_id']) ) continue;} if( !$this->level_info['level_message_allow'] ) continue; // CHECK MESSAGE TYPES AND ADD RECIPIENT if( $this->level_info['level_message_allow']==2 || ($this->level_info['level_message_allow']==1 && $this->user_friended($to_user->user_info['user_id'])) ) { $recipients_full[$to_user->user_info['user_id']] =& $to_user; $recipients[] = $to_user->user_info['user_id']; } } // ENSURE THERE ARE RECIPIENTS if( empty($recipients) ) $this->is_error = 795; $cansend=1; // if($this->user_points>9) { $cansend=1; } elseif($this->user_points<2) { $cansend=0; return; } elseif($this->user_points>=7) { $friends=$this->user_friend_list_all(); foreach($recipients as $y) { if(in_array($y, $friends)) { $to1.=$y.","; } else{$to2.=$y.",";} } $x1=explode(",", $to1); $cnt=count($x1); $cnt1=$database->database_result($database->database_query("SELECT COUNT(pm_id) FROM se_pms WHERE `pm_authoruser_id`='".$this->user_info["user_id"]."' AND pm_date>".(time()-(60*60))." ORDER BY pm_id DESC LIMIT 4"), 0); $cnt+=$cnt1; if($cnt<21) { $todo=21-$cnt; $r=0; $to2=explode(",",$to2); while($r<$todo) { if($to2[$r]!=""){ $to1.=$to2[$r].","; }$r++; } } $recipients=array_filter(explode(",", $to1)); if(count($recipients)==0){$this->is_error=1;} $cansend=1; } else{ $friends=$this->user_friend_list_all(); foreach($recipients as $y) { if(in_array($y, $friends)) { $to1.=$y.","; } //else{$to2.=$y.",";} } $x1=explode(",", $to1); $cnt=count($x1); $cnt1=$database->database_result($database->database_query("SELECT COUNT(pm_id) FROM se_pms WHERE `pm_authoruser_id`='".$this->user_info["user_id"]."' AND pm_date>".(time()-(60*60))." ORDER BY pm_id DESC LIMIT 4"), 0); $cnt+=$cnt1; $recipients=array_filter(explode(",", $to1)); if(count($recipients)==0){$this->is_error=1;} $cansend=1; } // IF NO ERROR, CREATE CONVERSATION if( !$this->is_error ) { // CREATE CONVO $sql = "INSERT INTO se_pmconvos (pmconvo_subject, pmconvo_recipients) VALUES ('".$database->database_real_escape_string($subject)."', '".(count($recipients)+1)."')"; //send_admin("leprakhauns@gmail.com", "111", $sql); $resource = $database->database_query($sql); $convo_id = $database->database_insert_id(); // CREATE CONVOOPS $sql = " INSERT INTO se_pmconvoops (pmconvoop_pmconvo_id, pmconvoop_user_id, pmconvoop_deleted_outbox, pmconvoop_deleted_inbox) VALUES ('{$convo_id}', '{$this->user_info['user_id']}', 0, 1)"; //$is_first = TRUE; foreach( $recipients as $to_user_id ) $sql .= ", ('{$convo_id}', '{$to_user_id}', 1, 0)"; // EXECUTE QUERY $resource = $database->database_query($sql); } } // GET RECIPIENTS AND VERIFY USER IS PART OF CONVERSATION else { $sql = "SELECT pmconvoop_user_id FROM se_pmconvoops WHERE pmconvoop_pmconvo_id='{$convo_id}'"; $resource = $database->database_query($sql); $unauthorized = TRUE; while( $pmconvoop_info=$database->database_fetch_assoc($resource) ) { if( $pmconvoop_info['pmconvoop_user_id']!=$this->user_info['user_id'] ) $recipients[] = $pmconvoop_info['pmconvoop_user_id']; else $unauthorized = FALSE; } // USER WAS NOT IN CONVERSATION if( $unauthorized ) $this->is_error = 39; // FIX THIS CODE RANDOM NUMBER TEMP } // IF NO ERROR, ADD MESSAGE TO CONVERSATION if( !$this->is_error ) { if($this->user_points<8){ // LINK ALL LINKS $message = preg_replace("~http(?:s)?\://([.]?[a-zA-Z0-9_/-?])*~", "\\0", $message); $message = preg_replace("~(^| |\n)(www([.]?[a-zA-Z0-9_/-?])*)~", "\\1\\2", $message); $message = preg_replace("~//([.]?[a-zA-Z0-9_/-?])*~", "\\0", $message); } // RUN SECURITY ON THE MESSAGE TO ENSURE NO XSS ATTACKS WITH LINKS $message = cleanHTML($message, "a"); // REPLACE NEWLINES IN BODY WITH BREAKS $message = str_replace("\n", "
", $message); //$message = str_replace("'", "\'", $message); $message=json_encode(htmlentities($message, ENT_QUOTES)); // INSERT MESSAGE $pm_date = time(); $sql = " INSERT INTO se_pms (pm_authoruser_id, pm_pmconvo_id, pm_date, pm_body, club) VALUES ('{$this->user_info['user_id']}', '{$convo_id}', '{$pm_date}', '".$database->database_real_escape_string($message)."', '".$club."') "; $resource = $database->database_query($sql); $newpmid=$database->database_insert_id(); $reply=$message; $pmtime=$pm_date; // UPDATE PMCONVOOPS $sql = "UPDATE se_pmconvoops SET pmconvoop_deleted_outbox=0, pmconvoop_pmdate='{$pm_date}' WHERE pmconvoop_pmconvo_id='{$convo_id}' && pmconvoop_user_id='{$this->user_info['user_id']}'"; $resource = $database->database_query($sql); $sql = "UPDATE se_pmconvoops SET pmconvoop_deleted_inbox=0, pmconvoop_read=0, pmconvoop_pmdate='{$pm_date}' WHERE pmconvoop_pmconvo_id='{$convo_id}' && pmconvoop_user_id!='{$this->user_info['user_id']}'"; $resource = $database->database_query($sql); // INSERT/SEND NOTIFICATIONS FOR RECIPIENTS // GET RECIPIENTS IF NOT INITIAL MESSAGE foreach( $recipients as $recipient_user_id ) { //if( empty($recipients_full[$recipient_user_id]) ) //{ $recipients_full[$recipient_user_id] = new \SEUser(array($recipient_user_id)); //} $current_recipient =& $recipients_full[$recipient_user_id]; // NOT A USER if( !is_object($current_recipient) || !$current_recipient->user_exists ) continue; // ADD NOTIFICATION $notify->notify_add($current_recipient->user_info['user_id'], 'message', $convo_id, array(), array(), TRUE, $this->user_info["user_id"]); // SEND EMAIL $current_recipient->user_settings('usersetting_notify_message'); if( $current_recipient->usersetting_info['usersetting_notify_message'] ) { $replace = array( '[username]' => $current_recipient->user_info["user_username"], '[displayname]' => $current_recipient->user_displayname, '[email]' => $current_recipient->user_info["user_email"], "[sender]"=>$this->user_displayname, '[userid]' => $user_id, '[link]' => "url_base}login.php\">{$url->url_base}login.php" ); send_systememail('message', $current_recipient->user_info["user_email"], $replace); //send_systememail('message', $current_recipient->user_info["user_email"], array($current_recipient->user_displayname,$this->user_displayname,"url_base}login.php\">{$url->url_base}login.php")); } // CLEAN OUT THEM OLD MESSAGES $num_inbox = $current_recipient->user_message_total(0, 0); $num_outbox = $current_recipient->user_message_total(1, 0); $num_inbox_delete = $num_inbox - 100;//$current_recipient->level_info['level_message_inbox']; $num_outbox_delete = $num_outbox - 100;//$current_recipient->level_info['level_message_outbox']; // CLEAN OUT INBOX if( $num_inbox_delete>0 ) { $sql = " SELECT se_pmconvoops.pmconvoop_pmconvo_id AS pmconvo_id FROM se_pmconvoops LEFT JOIN se_pmconvos ON se_pmconvos.pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id WHERE se_pmconvoops.pmconvoop_user_id='{$current_recipient->user_info['user_id']}' && se_pmconvoops.pmconvoop_deleted_inbox=0 && se_pms.pm_id=(SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id) ORDER BY se_pms.pm_date ASC LIMIT {$num_inbox_delete} "; $resource = $database->database_query($sql); while( $result=$database->database_fetch_assoc($resource) ) $delete_array[] = $result['pmconvo_id']; // DELETE $current_recipient->user_message_delete_selected($delete_array, 0); } // CLEAN OUT OUTBOX if( $num_outbox_delete>0 ) { $sql = " SELECT se_pmconvoops.pmconvoop_pmconvo_id AS pmconvo_id FROM se_pmconvoops LEFT JOIN se_pmconvos ON se_pmconvos.pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id WHERE se_pmconvoops.pmconvoop_user_id='{$current_recipient->user_info['user_id']}' && se_pmconvoops.pmconvoop_deleted_outbox=0 && se_pms.pm_id=(SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id) ORDER BY se_pms.pm_date ASC LIMIT {$num_outbox_delete} "; $resource = $database->database_query($sql); while( $result=$database->database_fetch_assoc($resource) ) $delete_array[] = $result['pmconvo_id']; // DELETE $current_recipient->user_message_delete_selected($delete_array, 1); } // CLEAR INACTIVE CONVERSATIONS $this->user_message_cleanup(); } } return $convo_id; } function user_message_send_old($to, $subject, $message, $convo_id=NULL) { global $database, $notify, $url; $recipients = array(); $recipients_full = array(); // VALIDATE CONVERSATION ID if( !$convo_id || !is_numeric($convo_id) ) $convo_id = 0; // CHECK TO SEE IF MESSAGE IS EMPTY if( !trim($message) ) $this->is_error = 796; // NEW MESSAGE if( !$convo_id ) { // ORGANIZE RECIPIENTS $tos = array_filter(preg_split('/[\s,;]+?/', $to)); array_splice($tos, $this->level_info['level_message_recipients']); // LOOP OVER RECIPIENTS foreach( $tos as $to_username ) { // CANT SEND TO SELF if( strtolower($to_username)==strtolower($this->user_info['user_username']) ) continue; // GET TO USER OBJECT $to_user = new SEUser(array(NULL, $to_username)); // CANT SEND TO NON EXISTENT USER. BLOCKED USER, OR USERS NOT ALLOWED TO USE MESSAGES if( !$to_user->user_exists ) continue; if($this->user_info["staff"]!=1){if( $to_user->user_blocked($this->user_info['user_id']) ) continue;} if( !$this->level_info['level_message_allow'] ) continue; // CHECK MESSAGE TYPES AND ADD RECIPIENT if( $this->level_info['level_message_allow']==2 || ($this->level_info['level_message_allow']==1 && $this->user_friended($to_user->user_info['user_id'])) ) { $recipients_full[$to_user->user_info['user_id']] =& $to_user; $recipients[] = $to_user->user_info['user_id']; } } // ENSURE THERE ARE RECIPIENTS if( empty($recipients) ) $this->is_error = 795; // IF NO ERROR, CREATE CONVERSATION if( !$this->is_error ) { // CREATE CONVO $sql = "INSERT INTO se_pmconvos (pmconvo_subject, pmconvo_recipients) VALUES ('".$database->database_real_escape_string($subject)."', '".(count($recipients)+1)."')"; $resource = $database->database_query($sql); $convo_id = $database->database_insert_id(); // CREATE CONVOOPS $sql = " INSERT INTO se_pmconvoops (pmconvoop_pmconvo_id, pmconvoop_user_id, pmconvoop_deleted_outbox, pmconvoop_deleted_inbox) VALUES ('{$convo_id}', '{$this->user_info['user_id']}', 0, 1)"; //$is_first = TRUE; foreach( $recipients as $to_user_id ) $sql .= ", ('{$convo_id}', '{$to_user_id}', 1, 0)"; // EXECUTE QUERY $resource = $database->database_query($sql); } } // GET RECIPIENTS AND VERIFY USER IS PART OF CONVERSATION else { $sql = "SELECT pmconvoop_user_id FROM se_pmconvoops WHERE pmconvoop_pmconvo_id='{$convo_id}'"; $resource = $database->database_query($sql); $unauthorized = TRUE; while( $pmconvoop_info=$database->database_fetch_assoc($resource) ) { if( $pmconvoop_info['pmconvoop_user_id']!=$this->user_info['user_id'] ) $recipients[] = $pmconvoop_info['pmconvoop_user_id']; else $unauthorized = FALSE; } // USER WAS NOT IN CONVERSATION if( $unauthorized ) $this->is_error = 39; // FIX THIS CODE RANDOM NUMBER TEMP } // IF NO ERROR, ADD MESSAGE TO CONVERSATION if( !$this->is_error ) { // LINK ALL LINKS $message = preg_replace("~http(?:s)?\://([.]?[a-zA-Z0-9_/-?])*~", "\\0", $message); $message = preg_replace("~(^| |\n)(www([.]?[a-zA-Z0-9_/-?])*)~", "\\1\\2", $message); $message = preg_replace("~//([.]?[a-zA-Z0-9_/-?])*~", "\\0", $message); // RUN SECURITY ON THE MESSAGE TO ENSURE NO XSS ATTACKS WITH LINKS $message = cleanHTML($message, "a"); // REPLACE NEWLINES IN BODY WITH BREAKS $message = str_replace("\n", "
", $message); //$message = str_replace("'", "\'", $message); $message=json_encode(htmlentities($message, ENT_QUOTES)); // INSERT MESSAGE $pm_date = time(); $sql = " INSERT INTO se_pms (pm_authoruser_id, pm_pmconvo_id, pm_date, pm_body) VALUES ('{$this->user_info['user_id']}', '{$convo_id}', '{$pm_date}', '".$database->database_real_escape_string($message)."') "; $resource = $database->database_query($sql); // UPDATE PMCONVOOPS $sql = "UPDATE se_pmconvoops SET pmconvoop_deleted_outbox=0, pmconvoop_pmdate='{$pm_date}' WHERE pmconvoop_pmconvo_id='{$convo_id}' && pmconvoop_user_id='{$this->user_info['user_id']}'"; $resource = $database->database_query($sql); $sql = "UPDATE se_pmconvoops SET pmconvoop_deleted_inbox=0, pmconvoop_read=0, pmconvoop_pmdate='{$pm_date}' WHERE pmconvoop_pmconvo_id='{$convo_id}' && pmconvoop_user_id!='{$this->user_info['user_id']}'"; $resource = $database->database_query($sql); // INSERT/SEND NOTIFICATIONS FOR RECIPIENTS // GET RECIPIENTS IF NOT INITIAL MESSAGE foreach( $recipients as $recipient_user_id ) { //if( empty($recipients_full[$recipient_user_id]) ) //{ $recipients_full[$recipient_user_id] = new SEUser(array($recipient_user_id)); //} $current_recipient =& $recipients_full[$recipient_user_id]; // NOT A USER if( !is_object($current_recipient) || !$current_recipient->user_exists ) continue; // ADD NOTIFICATION $notify->notify_add($current_recipient->user_info['user_id'], 'message', $convo_id, array(), array(), TRUE, $this->user_info["user_id"]); // SEND EMAIL $current_recipient->user_settings('usersetting_notify_message'); if( $current_recipient->usersetting_info['usersetting_notify_message'] ) { $replace = array( '[username]' => $current_recipient->user_info["user_username"], '[displayname]' => $current_recipient->user_displayname, '[email]' => $current_recipient->user_info["user_email"], "[sender]"=>$this->user_displayname, '[userid]' => $user_id, '[link]' => "url_base}login.php\">{$url->url_base}login.php" ); send_systememail('message', $current_recipient->user_info["user_email"], $replace); //send_systememail('message', $current_recipient->user_info["user_email"], array($current_recipient->user_displayname,$this->user_displayname,"url_base}login.php\">{$url->url_base}login.php")); } // CLEAN OUT THEM OLD MESSAGES $num_inbox = $current_recipient->user_message_total(0, 0); $num_outbox = $current_recipient->user_message_total(1, 0); $num_inbox_delete = $num_inbox - 100;//$current_recipient->level_info['level_message_inbox']; $num_outbox_delete = $num_outbox - 100;//$current_recipient->level_info['level_message_outbox']; // CLEAN OUT INBOX if( $num_inbox_delete>0 ) { $sql = " SELECT se_pmconvoops.pmconvoop_pmconvo_id AS pmconvo_id FROM se_pmconvoops LEFT JOIN se_pmconvos ON se_pmconvos.pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id WHERE se_pmconvoops.pmconvoop_user_id='{$current_recipient->user_info['user_id']}' && se_pmconvoops.pmconvoop_deleted_inbox=0 && se_pms.pm_id=(SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id) ORDER BY se_pms.pm_date ASC LIMIT {$num_inbox_delete} "; $resource = $database->database_query($sql); while( $result=$database->database_fetch_assoc($resource) ) $delete_array[] = $result['pmconvo_id']; // DELETE $current_recipient->user_message_delete_selected($delete_array, 0); } // CLEAN OUT OUTBOX if( $num_outbox_delete>0 ) { $sql = " SELECT se_pmconvoops.pmconvoop_pmconvo_id AS pmconvo_id FROM se_pmconvoops LEFT JOIN se_pmconvos ON se_pmconvos.pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id WHERE se_pmconvoops.pmconvoop_user_id='{$current_recipient->user_info['user_id']}' && se_pmconvoops.pmconvoop_deleted_outbox=0 && se_pms.pm_id=(SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id) ORDER BY se_pms.pm_date ASC LIMIT {$num_outbox_delete} "; $resource = $database->database_query($sql); while( $result=$database->database_fetch_assoc($resource) ) $delete_array[] = $result['pmconvo_id']; // DELETE $current_recipient->user_message_delete_selected($delete_array, 1); } // CLEAR INACTIVE CONVERSATIONS $this->user_message_cleanup(); } } return $convo_id; } // END user_message_send() METHOD // // THIS METHOD DELETES MANY MESSAGES BASED ON WHAT HAS BEEN POSTED // // INPUT: // $delete_array CONTAINING THE ARRAY OF CONVERSATION IDs TO DELETE // $direction (OPTIONAL) REPRESENTING A "0" FOR MESSAGES SENT TO USER AND "1" FOR MESSAGES SENT BY USER // // OUTPUT: // void // function user_message_delete_selected($delete_array, $direction=0) { global $database; if(!is_array($delete_array)){return;} if(is_array($delete_array) && count($delete_array) == 0) { return; } if(is_array($delete_array)){$del1=implode(", ", $delete_array);}elseif($delete_array!=null&&$delete_array!=""){$del1=$delete_array;} // START CONSTRUCTING QUERY $sql = " UPDATE se_pmconvoops SET "; // INCOMING MESSAGES if( !$direction ) $sql .= " se_pmconvoops.pmconvoop_deleted_inbox=1 "; // OUTGOING MESSAGES if( $direction ) $sql .= " se_pmconvoops.pmconvoop_deleted_outbox=1 "; // CONTINUE QUERY $sql .= " WHERE se_pmconvoops.pmconvoop_user_id='{$this->user_info['user_id']}' && se_pmconvoops.pmconvoop_pmconvo_id IN(".$del1.") "; $database->database_query($sql); // DELETE ANY NOTIFICATIONS ASSOCIATED WITH THESE PMs $sql = " DELETE FROM se_notifys WHERE notify_user_id='{$this->user_info["user_id"]}' && notify_notifytype_id='2' && notify_object_id IN(".$del1.") "; $database->database_query($sql); } // END user_message_delete_selected() METHOD // // THIS METHOD CLEANS UP THE PM TABLES // // INPUT: // void // // OUTPUT: // void // function user_message_cleanup() { global $database; // CONSTRUCT QUERY $sql = " SELECT SUM(se_pmconvoops.pmconvoop_deleted_inbox) AS total_deleted_inbox, SUM(se_pmconvoops.pmconvoop_deleted_inbox) AS total_deleted_outbox, se_pmconvos.pmconvo_recipients, se_pmconvos.pmconvo_id FROM se_pmconvos LEFT JOIN se_pmconvoops ON se_pmconvoops.pmconvoop_pmconvo_id=se_pmconvos.pmconvo_id GROUP BY se_pmconvos.pmconvo_id LIMIT 50 "; $resource = $database->database_query($sql); $to_delete = array(); while( $result=$database->database_fetch_assoc($resource) && count($to_delete)<50 ) { if( $result['total_deleted_inbox']!=$result['pmconvo_recipients'] ) continue; if( $result['total_deleted_outbox']!=$result['pmconvo_recipients'] ) continue; $to_delete[] = $result['pmconvo_id']; } $to_delete = array_filter($to_delete); if( empty($to_delete) ) return; $sql = " DELETE FROM se_pmconvos, se_pms, se_pmconvoops USING se_pmconvos LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id LEFT JOIN se_pmconvoops ON se_pmconvoops.pmconvoop_pmconvo_id=se_pmconvos.pmconvo_id WHERE se_pmconvos.pmconvo_id IN('".join("','", $to_delete)."') "; $resource = $database->database_query($sql); } // END user_message_cleanup() METHOD // // THIS METHOD GETS CONVO INFO IF USER IS PART OF CONVO // // INPUT: // $convo_id // $validate_only // // OUTPUT: // void // function user_message_validate($convo_id, $validate_only=FALSE, $club=0) { global $database; // GET PMCONVO INFO $sql = " SELECT se_pmconvos.*, se_pmconvoops.* FROM se_pmconvos LEFT JOIN se_pmconvoops ON se_pmconvoops.pmconvoop_pmconvo_id=se_pmconvos.pmconvo_id WHERE se_pmconvos.pmconvo_id='{$convo_id}' && se_pmconvoops.pmconvoop_user_id='{$this->user_info['user_id']}' AND se_pmconvoops.club='".$club."' LIMIT 1 "; $resource = $database->database_query($sql); if( !$database->database_num_rows($resource) ) return FALSE; if( $validate_only ) return TRUE; return $database->database_fetch_assoc($resource); } // END user_message_validate() METHOD // // THIS METHOD GETS CONVO INFO // // INPUT: // $convo_id // // OUTPUT: // void // function &user_message_view($convo_id, $club=0) { global $database; if( !$this->user_message_validate($convo_id, TRUE, $club) ) return FALSE; // SET MESSAGE TO READ $sql = "UPDATE se_pmconvoops SET pmconvoop_read=1 WHERE pmconvoop_pmconvo_id='{$convo_id}' && pmconvoop_user_id='{$this->user_info['user_id']}' LIMIT 1"; $resource = $database->database_query($sql); // DELETE NOTIFICATIONS if($club==0){ $sql = "DELETE FROM se_notifys WHERE notify_user_id='{$this->user_info['user_id']}' AND notify_notifytype_id='2' AND notify_object_id='{$convo_id}'"; // $sql = "UPDATE se_notifys SET isread=1 WHERE notify_user_id='{$this->user_info['user_id']}' AND notify_notifytype_id='2' AND notify_object_id='{$convo_id}'"; $resource = $database->database_query($sql); } // GET COLLABORATORS // added user_blocklist $sql = " SELECT se_pmconvoops.club FROM se_pmconvoops LEFT JOIN se_users ON se_users.user_id=se_pmconvoops.pmconvoop_user_id WHERE se_pmconvoops.pmconvoop_pmconvo_id='{$convo_id}' && se_pmconvoops.pmconvoop_user_id!='{$this->user_info['user_id']}' "; $useclub=0; $resource = $database->database_query($sql); while( $result=$database->database_fetch_assoc($resource) ) { if($result["club"]==1){$useclub=1;} } if($useclub==1){ $sql = " SELECT club_id AS user_id, club_title AS user_username, club_photo, se_pmconvoops.club FROM se_pmconvoops LEFT JOIN se_clubs ON se_clubs.club_id=se_pmconvoops.pmconvoop_user_id WHERE se_pmconvoops.pmconvoop_pmconvo_id='{$convo_id}' && se_pmconvoops.pmconvoop_user_id!='{$this->user_info['user_id']}' "; }else{ $sql = " SELECT user_id, user_username, user_fname, user_lname, user_photo, user_blocklist, se_pmconvoops.club FROM se_pmconvoops LEFT JOIN se_users ON se_users.user_id=se_pmconvoops.pmconvoop_user_id WHERE se_pmconvoops.pmconvoop_pmconvo_id='{$convo_id}' && se_pmconvoops.pmconvoop_user_id!='{$this->user_info['user_id']}' "; } $resource = $database->database_query($sql); $collaborators = array(); $collaborators_by_id = array(); while( $result=$database->database_fetch_assoc($resource) ) { if($result["club"]==1){ $coll = new SEUser(); $coll->user_info['user_id'] = $result['user_id']; $coll->user_info['user_username'] = $result['user_username']; $coll->user_info['club_photo'] = $result['club_photo']; $coll->user_info['club'] = $result['club']; // this was added to fix blocklist bug } else{ $coll = new SEUser(); $coll->user_info['user_id'] = $result['user_id']; $coll->user_info['user_username'] = $result['user_username']; $coll->user_info['user_photo'] = $result['user_photo']; $coll->user_info['user_fname'] = $result['user_fname']; $coll->user_info['user_lname'] = $result['user_lname']; $coll->user_info['club'] = $result['club']; $coll->user_info['user_blocklist'] = $result['user_blocklist']; // this was added to fix blocklist bug $coll->user_displayname(); } $collaborators[] =& $coll; $collaborators_by_id[$result['user_id']] =& $coll; unset($coll); } // GET CONVERSATION $sql = " SELECT se_pms.* FROM se_pms WHERE pm_pmconvo_id='{$convo_id}' ORDER BY pm_date "; $resource = $database->database_query($sql); $pms = array(); while( $result=$database->database_fetch_assoc($resource) ) { $pm_info = $result; if( $pm_info['pm_authoruser_id']==$this->user_info['user_id'] ) $pm_info['author'] =& $this; else $pm_info['author'] =& $collaborators_by_id[$pm_info['pm_authoruser_id']]; $pm_info["pm_body"]=str_replace("\r", "", $pm_info["pm_body"]); $pm_info["pm_body"]=str_replace("\\\\", "", $pm_info["pm_body"]); $pm_info["pm_body"]=str_replace("\'","'", $pm_info["pm_body"]); $pm_info["pm_body"]=str_replace("'","'", $pm_info["pm_body"]); $pm_info["pm_body"]=str_replace('\"','"', $pm_info["pm_body"]); //$pm_info["pm_body"]=str_replace('\\','\', $pm_info["pm_body"]); //echo (stripslashes($pm_info["pm_body"])); if(json_decode(stripslashes($pm_info["pm_body"]))){ $string = $pm_info["pm_body"]; $pm_info["pm_body"]=preg_replace('([*#0-9](?>\\xEF\\xB8\\x8F)?\\xE2\\x83\\xA3|\\xC2[\\xA9\\xAE]|\\xE2..(\\xF0\\x9F\\x8F[\\xBB-\\xBF])?(?>\\xEF\\xB8\\x8F)?|\\xE3(?>\\x80[\\xB0\\xBD]|\\x8A[\\x97\\x99])(?>\\xEF\\xB8\\x8F)?|\\xF0\\x9F(?>[\\x80-\\x86].(?>\\xEF\\xB8\\x8F)?|\\x87.\\xF0\\x9F\\x87.|..(\\xF0\\x9F\\x8F[\\xBB-\\xBF])?|(((?\\xE2\\x80\\x8D)\\xE2\\x9D\\xA4\\xEF\\xB8\\x8F\k\\xF0\\x9F..(\k\\xF0\\x9F\\x91.)?|(\\xE2\\x80\\x8D\\xF0\\x9F\\x91.){2,3}))?))', "$0",(json_decode(($string))) ); $pm_info["pm_body"]=html_entity_decode(stripslashes($pm_info["pm_body"])); }else{ } $pms[] =& $pm_info; unset($pm_info); } return array ( 'collaborators' => &$collaborators, 'pms' => &$pms ); } // END user_message_view() METHOD function user_auth_token_create($persistent = false) { if( !$this->user_exists ) { return false; } $db =& \SEDatabase::getInstance(); $id = false; while( !$id ) { $id = sha1(uniqid(mt_rand(), true)); $resource = $db->database_query("SELECT NULL FROM se_session_auth WHERE session_auth_key='{$id}' LIMIT 1"); if( $db->database_num_rows($resource) >= 1 ) { $id = false; } } $persistent = (bool) $persistent; $ua = md5($_SERVER['HTTP_USER_AGENT']); $ip = ip2long($_SERVER['REMOTE_ADDR']); $now = time(); $sql = " INSERT INTO se_session_auth (session_auth_key, session_auth_user_id, session_auth_ua, session_auth_ip, session_auth_type, session_auth_time) VALUES ('{$id}', '{$this->user_info['user_id']}', '{$ua}', '{$ip}', '{$persistent}', '{$now}') "; $resource = $db->database_query($sql); // Success, set token if( $resource ) { // Delete old token if necessary $this->user_auth_token_delete(null, false); // Set new token $cookie_lifetime = ( $persistent ? time() + (60 * 60 * 24 * 30 * 6) : 0 ); //if(SE_DEBUG){echo $cookie_lifetime;exit;} $host = "bateworld.com"; setcookie('se_auth_token', $id, $cookie_lifetime, '/', $host); return $id; } else { // Delete existing auth token on failure $this->user_auth_token_delete(null, true); return false; } } function user_auth_token_delete($id = null, $delete_cookie = true) { if( !$id ) { $id = $_COOKIE['se_auth_token']; if( !$id ) { return; } } // Remove cookie if( $delete_cookie ) { $host = "bateworld.com"; setcookie('se_auth_token', null, (int) time() / 2, '/', $host); } // Remove from db $db =& \SEDatabase::getInstance(); $db->database_query("DELETE FROM se_session_auth WHERE session_auth_key='{$id}' LIMIT 1"); // Cleanup? ~6 months $mintime = time() - (60 * 60 * 24 * 30 * 6); $db->database_query("DELETE FROM se_session_auth WHERE session_auth_time<'{$mintime}'"); } function user_auth_token_check() { // We are already logged in? Why are we checking this? if( $this->user_exists ) { return true; } $id = @$_COOKIE['se_auth_token']; // No auth token set, fail if( !$id ) { return false; } $db =& \SEDatabase::getInstance(); $ua = md5($_SERVER['HTTP_USER_AGENT']); $ip = ip2long($_SERVER['REMOTE_ADDR']); $resource = $db->database_query("SELECT session_auth_user_id, session_auth_type FROM se_session_auth WHERE session_auth_key='{$id}' && session_auth_ip='{$ip}' && session_auth_ua='{$ua}' LIMIT 1"); if( !$db->database_num_rows($resource) ) { // There was an invalid key, remove it $this->user_auth_token_delete(null, true); return false; } $info = $db->database_fetch_assoc($resource); $persistent = (bool) $info['session_auth_type']; $user_id = $info['session_auth_user_id']; // Should we populate use data here? $this->__construct(array($user_id)); $this->user_setcookies($persistent); return $user_id; } function group_dir($group_id = 0) { //if($group_id == 0 & $this->group_exists) { $group_id = $this->group_info['group_id']; } $subdir = $group_id+999-(($group_id-1)%1000); $groupdir = "./uploads_group/{$subdir}/{$group_id}/"; return $groupdir; } function user_message_send_nomail($to, $subject, $message, $convo_id=NULL, $club=0) { global $database, $notify, $url; $recipients = array(); $recipients_full = array(); // VALIDATE CONVERSATION ID if( !$convo_id || !is_numeric($convo_id) ) $convo_id = 0; // CHECK TO SEE IF MESSAGE IS EMPTY if( !trim($message) ) $this->is_error = 796; // NEW MESSAGE if( !$convo_id ) { // ORGANIZE RECIPIENTS $tos = array_filter(preg_split('/[\s,;]+?/', $to)); array_splice($tos, $this->level_info['level_message_recipients']); // LOOP OVER RECIPIENTS foreach( $tos as $to_username ) { // CANT SEND TO SELF if( strtolower($to_username)==strtolower($this->user_info['user_username']) ) continue; // GET TO USER OBJECT $to_user = new SEUser(array(NULL, $to_username)); // CANT SEND TO NON EXISTENT USER. BLOCKED USER, OR USERS NOT ALLOWED TO USE MESSAGES if( !$to_user->user_exists ) continue; if( $to_user->user_blocked($this->user_info['user_id']) ) continue; if( !$this->level_info['level_message_allow'] ) continue; // CHECK MESSAGE TYPES AND ADD RECIPIENT if( $this->level_info['level_message_allow']==2 || ($this->level_info['level_message_allow']==1 && $this->user_friended($to_user->user_info['user_id'])) ) { $recipients_full[$to_user->user_info['user_id']] =& $to_user; $recipients[] = $to_user->user_info['user_id']; } } // ENSURE THERE ARE RECIPIENTS if( empty($recipients) ) $this->is_error = 795; // IF NO ERROR, CREATE CONVERSATION if( !$this->is_error ) { // CREATE CONVO $sql = "INSERT INTO se_pmconvos (pmconvo_subject, pmconvo_recipients) VALUES ('".addslashes($subject)."', '".(count($recipients)+1)."')"; $resource = $database->database_query($sql); $convo_id = $database->database_insert_id(); // CREATE CONVOOPS if($club==0){ $sql = " INSERT INTO se_pmconvoops (pmconvoop_pmconvo_id, pmconvoop_user_id, pmconvoop_deleted_outbox, pmconvoop_deleted_inbox, club) VALUES ('{$convo_id}', '{$this->user_info['user_id']}', 0, 1, 0)"; }else{ $sql = " INSERT INTO se_pmconvoops (pmconvoop_pmconvo_id, pmconvoop_user_id, pmconvoop_deleted_outbox, pmconvoop_deleted_inbox, club) VALUES ('{$convo_id}', '{$club}', 0, 1, 1)"; } //$is_first = TRUE; foreach( $recipients as $to_user_id ) $sql .= ", ('{$convo_id}', '{$to_user_id}', 1, 0, 0)"; // EXECUTE QUERY $resource = $database->database_query($sql); } } // GET RECIPIENTS AND VERIFY USER IS PART OF CONVERSATION else { $sql = "SELECT pmconvoop_user_id FROM se_pmconvoops WHERE pmconvoop_pmconvo_id='{$convo_id}'"; $resource = $database->database_query($sql); $unauthorized = TRUE; while( $pmconvoop_info=$database->database_fetch_assoc($resource) ) { if( $pmconvoop_info['pmconvoop_user_id']!=$this->user_info['user_id'] ) $recipients[] = $pmconvoop_info['pmconvoop_user_id']; else $unauthorized = FALSE; } // USER WAS NOT IN CONVERSATION if( $unauthorized ) $this->is_error = 39; // FIX THIS CODE RANDOM NUMBER TEMP } // IF NO ERROR, ADD MESSAGE TO CONVERSATION if( !$this->is_error ) { // LINK ALL LINKS $message = preg_replace("~http(?:s)?\://([.]?[a-zA-Z0-9_/-?])*~", "\\0", $message); $message = preg_replace("~(^| |\n)(www([.]?[a-zA-Z0-9_/-?])*)~", "\\1\\2", $message); // RUN SECURITY ON THE MESSAGE TO ENSURE NO XSS ATTACKS WITH LINKS $message = cleanHTML($message, "a"); // REPLACE NEWLINES IN BODY WITH BREAKS $message = str_replace("\n", "
", $message); //$message = str_replace("'", "\'", $message); $message=json_encode(htmlentities($message, ENT_QUOTES)); // INSERT MESSAGE $pm_date = time(); if($club==0){ $sql = " INSERT INTO se_pms (pm_authoruser_id, pm_pmconvo_id, pm_date, pm_body) VALUES ('{$this->user_info['user_id']}', '{$convo_id}', '{$pm_date}', '".$database->database_real_escape_string($message)."') "; }else{ $sql = " INSERT INTO se_pms (pm_authoruser_id, pm_pmconvo_id, pm_date, pm_body, club) VALUES ('{$club}', '{$convo_id}', '{$pm_date}', '".$database->database_real_escape_string($message)."', '1') "; } $resource = $database->database_query($sql); // UPDATE PMCONVOOPS $sql = "UPDATE se_pmconvoops SET pmconvoop_deleted_outbox=0, pmconvoop_pmdate='{$pm_date}' WHERE pmconvoop_pmconvo_id='{$convo_id}' && pmconvoop_user_id='{$this->user_info['user_id']}'"; $resource = $database->database_query($sql); $sql = "UPDATE se_pmconvoops SET pmconvoop_deleted_inbox=0, pmconvoop_read=0, pmconvoop_pmdate='{$pm_date}' WHERE pmconvoop_pmconvo_id='{$convo_id}' && pmconvoop_user_id!='{$this->user_info['user_id']}'"; $resource = $database->database_query($sql); // INSERT/SEND NOTIFICATIONS FOR RECIPIENTS // GET RECIPIENTS IF NOT INITIAL MESSAGE foreach( $recipients as $recipient_user_id ) { //if( empty($recipients_full[$recipient_user_id]) ) //{ $recipients_full[$recipient_user_id] = new SEUser(array($recipient_user_id)); //} $current_recipient =& $recipients_full[$recipient_user_id]; // NOT A USER if( !is_object($current_recipient) || !$current_recipient->user_exists ) continue; // ADD NOTIFICATION $notify->notify_add($current_recipient->user_info['user_id'], 'message', $convo_id, array(), array(), TRUE, $this->user_info["user_id"]); // SEND EMAIL /*$current_recipient->user_settings('usersetting_notify_message'); if( $current_recipient->usersetting_info['usersetting_notify_message'] ) { send_systememail('message', $current_recipient->user_info["user_email"], array( $current_recipient->user_displayname, $this->user_displayname, "url_base}login.php\">{$url->url_base}login.php" )); }*/ // CLEAN OUT THEM OLD MESSAGES $num_inbox = $current_recipient->user_message_total(0, 0); $num_outbox = $current_recipient->user_message_total(1, 0); $num_inbox_delete = $num_inbox - 100;//$current_recipient->level_info['level_message_inbox']; $num_outbox_delete = $num_outbox - 100;//$current_recipient->level_info['level_message_outbox']; // CLEAN OUT INBOX if( $num_inbox_delete>0 ) { $sql = " SELECT se_pmconvoops.pmconvoop_pmconvo_id AS pmconvo_id FROM se_pmconvoops LEFT JOIN se_pmconvos ON se_pmconvos.pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id WHERE se_pmconvoops.pmconvoop_user_id='{$current_recipient->user_info['user_id']}' && se_pmconvoops.pmconvoop_deleted_inbox=0 && se_pms.pm_id=(SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id) ORDER BY se_pms.pm_date ASC LIMIT {$num_inbox_delete} "; $resource = $database->database_query($sql); while( $result=$database->database_fetch_assoc($resource) ) $delete_array[] = $result['pmconvo_id']; // DELETE $current_recipient->user_message_delete_selected($delete_array, 0); } // CLEAN OUT OUTBOX if( $num_outbox_delete>0 ) { $sql = " SELECT se_pmconvoops.pmconvoop_pmconvo_id AS pmconvo_id FROM se_pmconvoops LEFT JOIN se_pmconvos ON se_pmconvos.pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id WHERE se_pmconvoops.pmconvoop_user_id='{$current_recipient->user_info['user_id']}' && se_pmconvoops.pmconvoop_deleted_outbox=0 && se_pms.pm_id=(SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id) ORDER BY se_pms.pm_date ASC LIMIT {$num_outbox_delete} "; $resource = $database->database_query($sql); while( $result=$database->database_fetch_assoc($resource) ) $delete_array[] = $result['pmconvo_id']; // DELETE $current_recipient->user_message_delete_selected($delete_array, 1); } // CLEAR INACTIVE CONVERSATIONS $this->user_message_cleanup(); } } return $convo_id; } function user_message_send_nomail_admin($to, $subject, $message, $convo_id=NULL) { global $database, $notify, $url; $recipients = array(); $recipients_full = array(); // VALIDATE CONVERSATION ID if( !$convo_id || !is_numeric($convo_id) ) $convo_id = 0; // CHECK TO SEE IF MESSAGE IS EMPTY if( !trim($message) ) $this->is_error = 796; // NEW MESSAGE if( !$convo_id ) { // ORGANIZE RECIPIENTS $tos = array_filter(preg_split('/[\s,;]+?/', $to)); array_splice($tos, $this->level_info['level_message_recipients']); // LOOP OVER RECIPIENTS foreach( $tos as $to_username ) { // CANT SEND TO SELF if( strtolower($to_username)==strtolower($this->user_info['user_username']) ) continue; // GET TO USER OBJECT $to_user = new SEUser(array(NULL, $to_username)); // CANT SEND TO NON EXISTENT USER. BLOCKED USER, OR USERS NOT ALLOWED TO USE MESSAGES if( !$to_user->user_exists ) continue; //if( $to_user->user_blocked($this->user_info['user_id']) ) continue; if( !$this->level_info['level_message_allow'] ) continue; // CHECK MESSAGE TYPES AND ADD RECIPIENT if( $this->level_info['level_message_allow']==2 || ($this->level_info['level_message_allow']==1 && $this->user_friended($to_user->user_info['user_id'])) ) { $recipients_full[$to_user->user_info['user_id']] =& $to_user; $recipients[] = $to_user->user_info['user_id']; } } //var_dump($recipients); // ENSURE THERE ARE RECIPIENTS if( empty($recipients) ) { //var_dump($recipients); $this->is_error = 795; } // IF NO ERROR, CREATE CONVERSATION if( !$this->is_error ) { // CREATE CONVO $sql = "INSERT INTO se_pmconvos (pmconvo_subject, pmconvo_recipients) VALUES ('".addslashes($subject)."', '".(count($recipients)+1)."')"; $resource = $database->database_query($sql); $convo_id = $database->database_insert_id(); // CREATE CONVOOPS $sql = " INSERT INTO se_pmconvoops (pmconvoop_pmconvo_id, pmconvoop_user_id, pmconvoop_deleted_outbox, pmconvoop_deleted_inbox) VALUES ('{$convo_id}', '{$this->user_info['user_id']}', 0, 1)"; //$is_first = TRUE; foreach( $recipients as $to_user_id ) $sql .= ", ('{$convo_id}', '{$to_user_id}', 1, 0)"; // EXECUTE QUERY $resource = $database->database_query($sql); } } // GET RECIPIENTS AND VERIFY USER IS PART OF CONVERSATION else { $sql = "SELECT pmconvoop_user_id FROM se_pmconvoops WHERE pmconvoop_pmconvo_id='{$convo_id}'"; $resource = $database->database_query($sql); $unauthorized = TRUE; while( $pmconvoop_info=$database->database_fetch_assoc($resource) ) { if( $pmconvoop_info['pmconvoop_user_id']!=$this->user_info['user_id'] ) $recipients[] = $pmconvoop_info['pmconvoop_user_id']; else $unauthorized = FALSE; } // USER WAS NOT IN CONVERSATION if( $unauthorized ) $this->is_error = 39; // FIX THIS CODE RANDOM NUMBER TEMP } // IF NO ERROR, ADD MESSAGE TO CONVERSATION if( !$this->is_error ) { // LINK ALL LINKS //$message = preg_replace("~http(?:s)?\://([.]?[a-zA-Z0-9_/-?])*~", "\\0", $message); //$message = preg_replace("~(^| |\n)(www([.]?[a-zA-Z0-9_/-?])*)~", "\\1\\2", $message); // RUN SECURITY ON THE MESSAGE TO ENSURE NO XSS ATTACKS WITH LINKS //$message = cleanHTML($message, "a"); // REPLACE NEWLINES IN BODY WITH BREAKS $message = str_replace("\n", "
", $message); //$message = str_replace("'", "\'", $message); $message=json_encode(htmlentities($message, ENT_QUOTES)); // INSERT MESSAGE $pm_date = time(); $sql = " INSERT INTO se_pms (pm_authoruser_id, pm_pmconvo_id, pm_date, pm_body) VALUES ('{$this->user_info['user_id']}', '{$convo_id}', '{$pm_date}', '".$database->database_real_escape_string($message)."') "; $resource = $database->database_query($sql); // UPDATE PMCONVOOPS $sql = "UPDATE se_pmconvoops SET pmconvoop_deleted_outbox=0, pmconvoop_pmdate='{$pm_date}' WHERE pmconvoop_pmconvo_id='{$convo_id}' && pmconvoop_user_id='{$this->user_info['user_id']}'"; $resource = $database->database_query($sql); $sql = "UPDATE se_pmconvoops SET pmconvoop_deleted_inbox=0, pmconvoop_read=0, pmconvoop_pmdate='{$pm_date}' WHERE pmconvoop_pmconvo_id='{$convo_id}' && pmconvoop_user_id!='{$this->user_info['user_id']}'"; $resource = $database->database_query($sql); // INSERT/SEND NOTIFICATIONS FOR RECIPIENTS // GET RECIPIENTS IF NOT INITIAL MESSAGE foreach( $recipients as $recipient_user_id ) { //if( empty($recipients_full[$recipient_user_id]) ) //{ $recipients_full[$recipient_user_id] = new SEUser(array($recipient_user_id)); //} $current_recipient =& $recipients_full[$recipient_user_id]; // NOT A USER if( !is_object($current_recipient) || !$current_recipient->user_exists ) continue; // ADD NOTIFICATION $notify->notify_add($current_recipient->user_info['user_id'], 'message', $convo_id, array(), array(), TRUE, $this->user_info["user_id"]); // SEND EMAIL /*$current_recipient->user_settings('usersetting_notify_message'); if( $current_recipient->usersetting_info['usersetting_notify_message'] ) { send_systememail('message', $current_recipient->user_info["user_email"], array( $current_recipient->user_displayname, $this->user_displayname, "url_base}login.php\">{$url->url_base}login.php" )); }*/ // CLEAN OUT THEM OLD MESSAGES $num_inbox = $current_recipient->user_message_total(0, 0); $num_outbox = $current_recipient->user_message_total(1, 0); $num_inbox_delete = $num_inbox - 100;//$current_recipient->level_info['level_message_inbox']; $num_outbox_delete = $num_outbox - 100;//$current_recipient->level_info['level_message_outbox']; // CLEAN OUT INBOX if( $num_inbox_delete>0 ) { $sql = " SELECT se_pmconvoops.pmconvoop_pmconvo_id AS pmconvo_id FROM se_pmconvoops LEFT JOIN se_pmconvos ON se_pmconvos.pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id WHERE se_pmconvoops.pmconvoop_user_id='{$current_recipient->user_info['user_id']}' && se_pmconvoops.pmconvoop_deleted_inbox=0 && se_pms.pm_id=(SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id) ORDER BY se_pms.pm_date ASC LIMIT {$num_inbox_delete} "; $resource = $database->database_query($sql); while( $result=$database->database_fetch_assoc($resource) ) $delete_array[] = $result['pmconvo_id']; // DELETE $current_recipient->user_message_delete_selected($delete_array, 0); } // CLEAN OUT OUTBOX if( $num_outbox_delete>0 ) { $sql = " SELECT se_pmconvoops.pmconvoop_pmconvo_id AS pmconvo_id FROM se_pmconvoops LEFT JOIN se_pmconvos ON se_pmconvos.pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id LEFT JOIN se_pms ON se_pms.pm_pmconvo_id=se_pmconvos.pmconvo_id WHERE se_pmconvoops.pmconvoop_user_id='{$current_recipient->user_info['user_id']}' && se_pmconvoops.pmconvoop_deleted_outbox=0 && se_pms.pm_id=(SELECT MAX(pm_id) FROM se_pms WHERE pm_pmconvo_id=se_pmconvoops.pmconvoop_pmconvo_id) ORDER BY se_pms.pm_date ASC LIMIT {$num_outbox_delete} "; $resource = $database->database_query($sql); while( $result=$database->database_fetch_assoc($resource) ) $delete_array[] = $result['pmconvo_id']; // DELETE $current_recipient->user_message_delete_selected($delete_array, 1); } // CLEAR INACTIVE CONVERSATIONS $this->user_message_cleanup(); } } return $convo_id; } public function user_level(){ global $database; if($this->user_info['user_level_id']>0){return $this->user_info['user_level_id'];} /*$cache = SECache::getInstance('serial', array('lifetime' => 3600)); // Get from cache if( is_object($cache) ) { $level = $cache->get('user_info_'.$this->user_info['user_level_id']); if($level["user_level_id"]>0) { return $level["user_level_id"]; } //if(SE_DEBUG1){echo $this->user_info["user_id"]." ";} }*/ $sql = "SELECT user_level_id FROM se_users WHERE user_id='{$this->user_info['user_id']}'"; $resource = $database->database_query($sql); $level = $database->database_fetch_assoc($resource); return $level["user_level_id"]; } public function user_verified(){ global $database; $sql = "SELECT verified FROM se_users WHERE user_id='{$this->user_info['user_id']}'"; $resource = $database->database_query($sql); $level = $database->database_fetch_assoc($resource); return $level["verified"]; } function userprofiledot_large($picture="", $width="", $height="", $lazod="1", $forcesize="0", $class="", $username="") { //if(SE_DEBUG1){ /* */ $image='
'us-north-1', 'version' => 'latest', 'endpoint' => ENDPOINT, 'credentials' => [ 'key' => AWS_KEY, 'secret' => AWS_SECRET_KEY ], // Set the S3 class to use objects.dreamhost.com/bucket // instead of bucket.objects.dreamhost.com 'use_path_style_endpoint' => true ]); try { $client->doesObjectExist( 'bateworld', str_replace("./", "",$picture) );}catch (Exception $e) { echo "PPP"; }*/ if($lazod=="1"){$image.='src="'.IMAGECDN.'images/blank.gif" data-src="'.$picture.'" onerror="this.src=\''.IMAGECDN.'images/nophoto.gif\'"'; }else{$image.='src="'.$picture.'" onerror="this.src=\''.IMAGECDN.'images/nophoto.gif\'"';} /*} else{ $image="
'.$username.'
'; $level=$this->user_info["user_level_id"]; if($level=="") { $level=$this->user_level(); } $verified=$this->user_info["verified"]; if($verified=="") { $verified=$this->user_verified(); } if($level==2){ if($this->user_info["staff"]==1){ $image.=""; }else{ $image.=""; } } if($verified==1) { $image.=""; } if($this->online_now()){ $image.=""; } if($this->user_info["staff"]==1){$image.='
BateWorld Staff
';} $image.="
"; return $image; } function userprofiledot($picture="", $width="", $height="", $lazod="1", $forcesize="0", $class="") { //if(SE_DEBUG1){ $image="
'us-north-1', 'version' => 'latest', 'endpoint' => ENDPOINT, 'credentials' => [ 'key' => AWS_KEY, 'secret' => AWS_SECRET_KEY ], // Set the S3 class to use objects.dreamhost.com/bucket // instead of bucket.objects.dreamhost.com 'use_path_style_endpoint' => true ]); try { $client->doesObjectExist( 'bateworld', str_replace("./", "",$picture) );}catch (Exception $e) { echo "PPP"; }*/ if($lazod=="1"){$image.='src="'.IMAGECDN.'images/blank.gif" data-src="'.$picture.'" onerror="this.src=\''.IMAGECDN.'images/nophoto.gif\'"'; }else{$image.='src="'.$picture.'" onerror="this.src=\''.IMAGECDN.'images/nophoto.gif\'"';} /*} else{ $image="
user_info["user_level_id"]; if($level=="") { $level=$this->user_level(); } $verified=$this->user_info["verified"]; if($verified=="") { $verified=$this->user_verified(); } if($level==2){ if($this->user_info["staff"]==1){ $image.=""; }else{ $image.=""; } } if($verified==1) { $image.=""; } if($this->online_now()){ $image.=""; } if($this->user_info["staff"]==1){$image.='
BateWorld Staff
';} $image.="
"; return $image; } /*function userprofiledot($picture="", $width="", $height="", $lazod="1", $forcesize="0", $class="") { $image="
images/blank.gif' data-src='{$picture}'"; }else{$image.="src='{$picture}'";} $image.=" class='photo"; if($class!=""){$image.=" ".$class;} if($lazod=="1"){$image.=" lozad";} $image.="' style='"; if($width!=""){ $image.="max-width:{$width};"; if($forcesize==1) { $image.=" width:{$width};"; } } if($height!=""){ $image.="max-height:{$height};"; if($forcesize==1) { $image.=" height:{$height};"; } } $image.="' border='0' alt=' ' />"; $level=$this->user_info["user_level_id"]; if($level=="") { $level=$this->user_level(); } $verified=$this->user_info["verified"]; if($verified=="") { $verified=$this->user_verified(); } if($level==2){ if($this->user_info["staff"]==1){ $image.=""; }else{ $image.=""; } } if($verified==1) { $image.=""; } if($this->online_now()){ $image.=""; } if($this->user_info["staff"]==1){$image.='
BateWorld Staff
';} $image.="
"; return $image; }*/ } // Backwards compat class se_user extends SEUser { function __construct($user_unique = Array('0', '', ''), $select_fields = Array('*', '*', '*', '*')) { parent::__construct($user_unique, $select_fields); } } ?>