database_fetch_assoc($database->database_query("SELECT * FROM se_actiontypes WHERE actiontype_name='$actiontype_name' LIMIT 1")); // DONT PUBLISH IF PRIVACY IS TURNED ON AND USER DISALLOWED THIS ACTION TYPE, OR IS NOT ENABLED BY ADMIN $user->user_settings(); $dontpublish_array = array_filter(explode(",", $user->usersetting_info['usersetting_actions_dontpublish'])); $publish = ( $actiontype_info['actiontype_enabled'] && ( ($setting['setting_actions_privacy'] == 1 && !in_array($actiontype_info['actiontype_id'], $dontpublish_array)) || !$setting['setting_actions_privacy'] ) ); // PUBLISH ACTION if( !$publish ){$deleted=1;}else{$deleted=0;} // DELETE OLDEST ACTION(S) FOR THIS USER IF MAX ACTIONS STORED PER USER IS REACHED $totalactions = $database->database_num_rows($database->database_query("SELECT id as action_id FROM bateworldcom_wall.wall WHERE userid='{$user->user_info['user_id']}'")); /*if( $totalactions>$setting['setting_actions_actionsonprofile'] ) { $database->database_query("DELETE FROM se_actions WHERE action_user_id='{$user->user_info['user_id']}' ORDER BY action_id ASC LIMIT ".($totalactions-$setting['setting_actions_actionsonprofile'])); // CLEANUP THE ACTION MEDIA TABLE $database->database_query("DELETE se_actionmedia.* FROM se_actionmedia LEFT JOIN se_actions ON se_actions.action_id=se_actionmedia.actionmedia_action_id WHERE action_id IS NULL"); }*/ // GET PREVIOUS ACTION OF THE SAME TYPE WITH TIMEFRAME SPECIFICATIONS $difference = ( ($nowdate < $timeframe) ? 0 : $nowdate - $timeframe ); //$prev_query = $database->database_query("SELECT action_id FROM se_actions WHERE action_user_id='{$user->user_info['user_id']}' AND action_actiontype_id='{$actiontype_info['actiontype_id']}' AND action_date>'{$difference}' ORDER BY action_actiontype_id DESC LIMIT 1"); //$update = (bool) $database->database_num_rows($prev_query); //if( $update ) $prev = $database->database_fetch_assoc($prev_query); $prev_query1 = $database->database_query("SELECT id FROM bateworldcom_wall.wall WHERE userid='{$user->user_info['user_id']}' AND actiontype='{$actiontype_info['actiontype_id']}' AND date>'{$difference}' ORDER BY actiontype DESC LIMIT 1"); $update1 = (bool) $database->database_num_rows($prev_query1); if( $update1 ) $prev1 = $database->database_fetch_assoc($prev_query1); if($update){ if($prev1["id"]==""){ //mail("leprakhauns@gmail.com", "Editedra", "SELECT action_id FROM se_actions WHERE action_user_id='{$user->user_info['user_id']}' AND action_actiontype_id='{$actiontype_info['actiontype_id']}' AND action_date>'{$difference}' ORDER BY action_actiontype_id DESC LIMIT 1"); } } // SERIALIZE APPROPRIATE VARS $replace = array_map('stripslashes', $replace); $action_text = addslashes(serialize($replace)); // UPDATE OLD ACTION if( $update ) { /*$database->database_query(" UPDATE se_actions SET action_date='{$nowdate}', action_text='{$action_text}', action_object_privacy='{$action_object_privacy}' WHERE action_id='{$prev['action_id']}' AND action_user_id='{$user->user_info['user_id']}' AND action_actiontype_id='{$actiontype_info['actiontype_id']}' ");*/ $database->database_query(" UPDATE bateworldcom_wall.wall SET date='{$nowdate}', object_privacy='{$action_object_privacy}' WHERE id='{$prev1['id']}' AND userid='{$user->user_info['user_id']}' AND actiontype='{$actiontype_info['actiontype_id']}' "); if($prev1['id']==""){ //mail("leprakhauns@gmail.com", "Editedra", "SELECT action_id FROM se_actions WHERE action_user_id='{$user->user_info['user_id']}' AND action_actiontype_id='{$actiontype_info['actiontype_id']}' AND action_date>'{$difference}' ORDER BY action_actiontype_id DESC LIMIT 1"); } $edited=2; // DELETE OLD MEDIA IF NECESSARY if( $replace_media ) { //$database->database_query("DELETE FROM se_actionmedia WHERE actionmedia_action_id='{$prev['action_id']}'"); $database->database_query("DELETE FROM bateworldcom_wall.wall_media WHERE action_id='{$prev1['id']}'"); $edited=1; } // $action_id = $prev['action_id']; $action_id1 = $prev1['id']; } // INSERT NEW ACTION else { /*$database->database_query(" INSERT INTO se_actions ( action_actiontype_id, action_date, action_user_id, action_text, action_object_owner, action_object_owner_id, action_object_privacy ) VALUES ( '{$actiontype_info['actiontype_id']}', '{$nowdate}', '{$user->user_info['user_id']}', '{$action_text}', '{$action_object_owner}', '{$action_object_owner_id}', '{$action_object_privacy}' ) "); $action_id = $database->database_insert_id(); */ /* $format = SE_Language::get($actiontype_info["actiontype_text"]); $args = [$user->user_info["user_username"]]; if (strpos($format, '%') === false) { $txt = $format; } else { while (substr_count($format, '%s') > count($args)) { $args[] = ''; } $txt = vsprintf($format, $args); } //$txt=vsprintf($format, $args); send_admin("sean@bateworld.com", "bbb", $txt);*/ //$database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='".$user->user_info["user_id"]."', time='".time()."', action='User Notification Added: ".$database->database_real_escape_string($txt)."'"); $database->database_query(" INSERT INTO bateworldcom_wall.wall ( actiontype, date, userid, objectowner, objectowner_id, object_privacy, media, link, original_action_id, objectid2, deleted ) VALUES ( '{$actiontype_info['actiontype_id']}', '{$nowdate}', '{$user->user_info['user_id']}', '{$action_object_owner}', '{$action_object_owner_id}', '{$action_object_privacy}', '{$action_media_data['media_path']}', '{$action_media_data['media_link']}', '{$action_id}', '{$secondowner}', {$deleted} ) "); $action_id1 = $database->database_insert_id(); } // INSERT MEDIA if( is_array($action_media) && !empty($action_media) && $action_id1 ) { foreach( $action_media as $action_media_index=>$action_media_data ) { /*$database->database_query(" INSERT INTO se_actionmedia ( actionmedia_action_id, actionmedia_path, actionmedia_link, actionmedia_width, actionmedia_height ) VALUES ( '{$action_id}', '{$action_media_data['media_path']}', '{$action_media_data['media_link']}', '{$action_media_data['media_width']}', '{$action_media_data['media_height']}' ) ");*/ $database->database_query(" INSERT INTO bateworldcom_wall.wall_media ( `action_id`, `media`, `link`,`originalactionid`, `edited` ) VALUES ( '{$action_id1}', '{$action_media_data['media_path']}', '{$action_media_data['media_link']}', '{$action_id}', '{$edited}' ) "); } } } // END actions_add() METHOD // THIS METHOD DISPLAYS A LIST OF RECENT UPDATES (ACTIONS) // INPUT: $visibility REPRESENTING A VISIBILITY SETTING // $actionsperuser REPRESENTING HOW MANY ACTIONS PER USER TO DISPLAY // $where (OPTIONAL) REPRESENTING A WHERE CLAUSE // OUTPUT: LIST OF RECENT ACTIONS function actions_display($visibility, $actionsperuser, $where = "") { global $database, $user, $owner, $setting; $actions_array = array(); // CACHING $cache_object = SECache::getInstance('serial'); $cache_id = 'actions_'.( $visibility ? $visibility : '0').'_'.$actionsperuser.'_'.( $owner->user_exists ? $owner->user_info['user_id'] : '0' ).'_'.( $user->user_exists ? $user->user_info['user_id'] : '0' ).( $where ? '_'.md5($where) : ''); if( is_object($cache_object) ) { //$actions_array = $cache_object->get($cache_id); } // GET ACTIONS if( empty($actions_array) ) { // GET CURRENT DATE $nowdate = time(); // GET USER PREFERENCES, IF USER LOGGED IN $user_pref_where = ""; if( $setting['setting_actions_preference'] == 1 && $user->user_exists ) { if( empty($user->usersetting_info) ) $user->user_settings(); $usersetting_actions_display = join(',', array_filter(explode(',', $user->usersetting_info['usersetting_actions_display']))); $user_pref_where = " se_actiontypes.actiontype_id IN ({$usersetting_actions_display}) AND"; } if($usersetting_actions_display!=""){ // BEGIN BUILDING QUERY //$actions_query = "SELECT se_actions.*, se_actiontypes.actiontype_icon, se_actiontypes.actiontype_text, se_actiontypes.actiontype_media FROM se_actions USE INDEX (action_date) LEFT JOIN se_actiontypes ON se_actions.action_actiontype_id=se_actiontypes.actiontype_id"; //mail("leprakhauns@gmail.com", "RRR", $visibility." ".$_SERVER["PHP_SELF"]); switch($visibility) { // ALL ACTIONS, NO USER PREFS case 0: $actions_query .= " WHERE"; break; // ALL REGISTERED USERS, EXCLUDING LOGGED IN USER case 1: $actions_query .= " WHERE se_actions.action_user_id<>'{$user->user_info['user_id']}' AND"; $actions_query .= $user_pref_where; break; // ONLY MY FRIENDS AND EVERYONE IN MY SUBNET, EXCLUDING LOGGED IN USER case 2: $actions_query .= " LEFT JOIN se_friends ON se_friends.friend_user_id2=se_actions.action_user_id AND se_friends.friend_user_id1='{$user->user_info['user_id']}' AND se_friends.friend_status='1'"; $actions_query .= " LEFT JOIN se_users ON se_users.user_id=se_actions.action_user_id"; $actions_query .= " WHERE se_actions.action_user_id<>'{$user->user_info['user_id']}' AND"; $actions_query .= " (se_friends.friend_id <> 'NULL' OR se_users.user_subnet_id='{$user->user_info['user_subnet_id']}') AND"; $actions_query .= $user_pref_where; break; // ONLY MY FRIENDS, EXCLUDING LOGGED IN USER case 4: $actions_query .= " RIGHT JOIN se_friends ON se_friends.friend_user_id2=se_actions.action_user_id AND se_friends.friend_user_id1='{$user->user_info['user_id']}' AND se_friends.friend_status='1'"; $actions_query .= " WHERE se_actions.action_user_id<>'{$user->user_info['user_id']}' AND"; $actions_query .= $user_pref_where; break; case 5: $actions_query .= " WHERE"; $actions_query .= $user_pref_where; break; } // CHECK PRIVACY $actions_query .= " CASE WHEN se_actions.action_object_owner='user' THEN CASE WHEN se_actions.action_user_id='{$user->user_info['user_id']}' THEN TRUE "./* WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0) THEN TRUE WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0) THEN TRUE*/" WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_SELF) AND se_actions.action_object_owner_id='{$user->user_info['user_id']}') THEN TRUE WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_FRIEND) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_actions.action_object_owner_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1)) THEN TRUE "./*WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_SUBNET) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_users WHERE user_id=se_actions.action_object_owner_id AND user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1)) THEN TRUE*/" WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_FRIEND2) AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_users ON friends_primary.friend_user_id1=se_users.user_id LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE "./*friends_primary.friend_user_id1=se_actions.action_object_owner_id AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' AND se_users.user_subnet_id='{$user->user_info['user_subnet_id']}'*/" LIMIT 1)) THEN TRUE ELSE FALSE END "; // CALL HOOK ($hook = SE_Hook::exists('se_action_privacy')) ? SE_Hook::call($hook, array('actions_query' => &$actions_query)) : NULL; // RESUME CASE STATEMENT $actions_query .= " ELSE TRUE END AND "; // ADD WHERE CLAUSE IF NECESSARY if($where != "") { $actions_query .= " ($where) AND"; } // LIMIT RESULTS TO TIME PERIOD SPECIFIED BY ADMIN $actions_query .= " se_actions.action_date>".($nowdate-$setting['setting_actions_showlength']); // ORDER BY ACTION ID DESCENDING $actions_query .= " ORDER BY action_date DESC"; // LIMIT RESULTS TO MAX NUMBER SPECIFIED BY ADMIN $actions_query .= " LIMIT {$setting['setting_actions_actionsinlist']}"; //if(SE_DEBUG){echo $actions_query;} //if($user->user_info["user_id"]==7653){mail("leprakhauns@gmail.com", "query", $actions_query);} // GET RECENT ACTIVITY FEED $actions = $database->database_query($actions_query); $actions_array = Array(); $actions_users_array = Array(); while($action = $database->database_fetch_assoc($actions)) { // ONLY DISPLAY THIS ACTION IF MAX OCCURRANCES PER USER HAS NOT YET BEEN REACHED $actions_users_array[] = $action['action_user_id']; $occurrances = array_count_values($actions_users_array); if($occurrances[$action['action_user_id']] <= $actionsperuser) { // UNSERIALIZE VARIABLES // NOTE: I don't like mb_unserialize: it ignores the strlen param. But it works... if( ($action_vars = unserialize($action['action_text']))===FALSE ) $action_vars = mb_unserialize($action['action_text']); // REGISTER PRELOADED TEXT SE_Language::_preload($action['actiontype_text']); // RETRIEVE MEDIA IF NECESSARY $action_media = false; if( $action['actiontype_media'] ) { $action_media = Array(); $media = $database->database_query("SELECT * FROM se_actionmedia WHERE actionmedia_action_id='{$action['action_id']}'"); while( $media_info = $database->database_fetch_assoc($media) ) { $action_media[] = $media_info; } } // ADD THIS ACTION TO OUTPUT ARRAY $actions_array[] = array( 'action_id' => $action['action_id'], 'action_date' => $action['action_date'], 'action_actiontype_id' => $action['action_actiontype_id'], 'action_text' => $action['actiontype_text'], 'action_vars' => $action_vars, 'action_user_id' => $action['action_user_id'], //'action_username' => $action_username_info['user_username'], 'action_icon' => $action['actiontype_icon'], 'action_media' => $action_media ); } } // CACHE if( is_object($cache_object) ) { $cache_object->store($actions_array, $cache_id); } } } // Process actions (load language) foreach( $actions_array as $action ) { SE_Language::_preload($action['action_text']); } // RETURN LIST OF ACTIONS return $actions_array; } function actions_display_new2($visibility, $actionsperuser, $where = "") { global $database, $user, $owner, $setting, $blockobject; $actions_array = array(); // CACHING $cache_object = SECache::getInstance('serial'); $cache_id = 'actions_'.( $visibility ? $visibility : '0').'_'.$actionsperuser.'_'.( $owner->user_exists ? $owner->user_info['user_id'] : '0' ).'_'.( $user->user_exists ? $user->user_info['user_id'] : '0' ).( $where ? '_'.md5($where) : ''); if( is_object($cache_object) ) { //$actions_array = $cache_object->get($cache_id); } // GET ACTIONS if( empty($actions_array) ) { // GET CURRENT DATE $nowdate = time(); $user_pref_where = ""; if( $setting['setting_actions_preference'] == 1 && $user->user_exists ) { if( empty($user->usersetting_info) ) $user->user_settings(); $usersetting_actions_display = join(',', array_filter(explode(',', $user->usersetting_info['usersetting_actions_display']))); $user_pref_where = " se_actiontypes.actiontype_id IN ({$usersetting_actions_display}) AND"; } if($usersetting_actions_display!=""){ $blockobject=array(); $query=$database->database_query("SELECT user_id FROM se_users WHERE user_enabled=1 AND MATCH(user_blocklist) AGAINST('".$user->user_info["user_id"]."' IN NATURAL LANGUAGE MODE)"); while($row2=$database->database_fetch_array($query)) { if($blocked==""){$blocked=$database->database_real_escape_string($row2["user_id"]);} else{ $blocked.=",".$database->database_real_escape_string($row2["user_id"]); } $blockobject[]=$row2["user_id"]; } if($blocked==""){$blocked="0";} $blocklist="";//" bateworldcom_wall.wall.userid NOT IN (".$blocked.") AND "; $blocklist3=" bateworldcom_wall.wall.objectowner_id NOT IN (".$blocked.") AND "; // BEGIN BUILDING QUERY if($visibility!=0){$actions_query = "SELECT bateworldcom_wall.wall.*, se_actiontypes.actiontype_icon, se_actiontypes.actiontype_text, se_actiontypes.actiontype_media FROM bateworldcom_wall.wall USE INDEX (`date`) LEFT JOIN se_actiontypes ON bateworldcom_wall.wall.actiontype=se_actiontypes.actiontype_id"; }else{ $actions_query = "SELECT bateworldcom_wall.wall.*, se_actiontypes.actiontype_icon, se_actiontypes.actiontype_text, se_actiontypes.actiontype_media FROM bateworldcom_wall.wall JOIN se_actiontypes ON bateworldcom_wall.wall.actiontype=se_actiontypes.actiontype_id"; } // GET USER PREFERENCES, IF USER LOGGED IN $ex=explode(",", $user->user_info["user_blocklist"]); foreach($ex as $e){ if($e!=""){ $blockobject[]=$e; } } //mail("leprakhauns@gmail.com", "RRR", $visibility." ".$_SERVER["PHP_SELF"]); switch($visibility) { // ALL ACTIONS, NO USER PREFS case 0: $actions_query .= " WHERE"; break; // ALL REGISTERED USERS, EXCLUDING LOGGED IN USER case 1: $actions_query .= " WHERE bateworldcom_wall.wall.userid<>'{$user->user_info['user_id']}' AND"; $actions_query .= $user_pref_where; break; // ONLY MY FRIENDS AND EVERYONE IN MY SUBNET, EXCLUDING LOGGED IN USER case 2: $actions_query .= " LEFT JOIN se_friends ON se_friends.friend_user_id2=bateworldcom_wall.wall.userid AND se_friends.friend_user_id1='{$user->user_info['user_id']}' AND se_friends.friend_status='1'"; $actions_query .= " LEFT JOIN se_users ON se_users.user_id=bateworldcom_wall.wall.userid"; $actions_query .= " WHERE bateworldcom_wall.wall.userid<>'{$user->user_info['user_id']}' AND"; $actions_query .= " (se_friends.friend_id <> 'NULL' OR se_users.user_subnet_id='{$user->user_info['user_subnet_id']}') AND"; $actions_query .= $user_pref_where; break; // ONLY MY FRIENDS, EXCLUDING LOGGED IN USER case 4: $actions_query .= " RIGHT JOIN se_friends ON se_friends.friend_user_id2=bateworldcom_wall.wall.userid AND se_friends.friend_user_id1='{$user->user_info['user_id']}' AND se_friends.friend_status='1'"; $actions_query .= " WHERE bateworldcom_wall.wall.userid<>'{$user->user_info['user_id']}' AND"; $actions_query .= $user_pref_where; break; case 5: $actions_query .= " WHERE"; foreach($ex as $e){ if($e!=""){ if($blocklistown==""){$blocklistown=$database->database_real_escape_string($e);} else{ $blocklistown.=",".$database->database_real_escape_string($e); } } } $blocklistown=""; if($blocklistown==""){$blocklistown="0";} //$actions_query.=" bateworldcom_wall.wall.userid NOT IN(".$database->database_real_escape_string($blocklistown)."0) AND ".$blocklist; $actions_query .= $user_pref_where; break; } // CHECK PRIVACY $actions_query .= " CASE WHEN bateworldcom_wall.wall.objectowner='user' THEN CASE WHEN bateworldcom_wall.wall.userid='{$user->user_info['user_id']}' THEN TRUE "./* WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0) THEN TRUE WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0) THEN TRUE*/" WHEN ((bateworldcom_wall.wall.object_privacy & @SE_PRIVACY_SELF & actiontype!=12) AND bateworldcom_wall.wall.objectowner_id='{$user->user_info['user_id']}') THEN TRUE WHEN ((bateworldcom_wall.wall.object_privacy & @SE_PRIVACY_FRIEND & actiontype!=12) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=bateworldcom_wall.wall.objectowner_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1)) THEN TRUE "./*WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_SUBNET) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_users WHERE user_id=se_actions.action_object_owner_id AND user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1)) THEN TRUE*/" WHEN ((bateworldcom_wall.wall.object_privacy & @SE_PRIVACY_FRIEND2 & actiontype!=12) AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_users ON friends_primary.friend_user_id1=se_users.user_id LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 LIMIT 1)) THEN TRUE ELSE FALSE END "; action_privacy_event_new(array('actions_query' => &$actions_query)); action_privacy_group_new(array('actions_query' => &$actions_query)); action_privacy_forum_new(array('actions_query' => &$actions_query)); // CALL HOOK //($hook = SE_Hook::exists('se_action_privacy')) ? SE_Hook::call($hook, array('actions_query' => &$actions_query)) : NULL; // RESUME CASE STATEMENT $actions_query .= " ELSE TRUE END AND "; // ADD WHERE CLAUSE IF NECESSARY if($where != "") { $actions_query .= " ($where) AND"; } // LIMIT RESULTS TO TIME PERIOD SPECIFIED BY ADMIN //$actions_query .= " bateworldcom_wall.wall.date>".($nowdate-$setting['setting_actions_showlength']); if($_GET["loadfrom"]!=""){ $actions_query .= " bateworldcom_wall.wall.id<".$database->database_real_escape_string($_GET["loadfrom"])." AND "; } // ORDER BY ACTION ID DESCENDING $actions_query .= " 1=1 ORDER BY date DESC"; //if($_GET["loadfrom"]==""){ $actions_query .= " LIMIT 50"; if(SE_DEBUG1){ //echo $actions_query; } // else{$actions_query .= " LIMIT ".$_GET["loadfrom"].", 50";}*/ // LIMIT RESULTS TO MAX NUMBER SPECIFIED BY ADMIN //{$setting['setting_actions_actionsinlist']}"; // echo $actions_query; // GET RECENT ACTIVITY FEED if(SE_DEBUG1){ $actions = $database->database_query($actions_query) or die($database->database_error()); }else{ $actions = $database->database_query($actions_query); } $actions_array = Array(); $actions_users_array = Array(); while($action = $database->database_fetch_assoc($actions)) { if(!in_array($action["userid"], $blockobject)){ // ONLY DISPLAY THIS ACTION IF MAX OCCURRANCES PER USER HAS NOT YET BEEN REACHED $actions_users_array[] = $action['action_user_id']; //$occurrances = array_count_values($actions_users_array); //if($occurrances[$action['action_user_id']] <= $actionsperuser) { // UNSERIALIZE VARIABLES // NOTE: I don't like mb_unserialize: it ignores the strlen param. But it works... if( ($action_vars = unserialize($action['action_text']))===FALSE ) $action_vars = mb_unserialize($action['action_text']); // REGISTER PRELOADED TEXT SE_Language::_preload($action['actiontype_text']); // RETRIEVE MEDIA IF NECESSARY $action_media = false; if( $action['actiontype_media'] ) { $action_media = Array(); $media = $database->database_query("SELECT * FROM se_actionmedia WHERE actionmedia_action_id='{$action['action_id']}'"); while( $media_info = $database->database_fetch_assoc($media) ) { $action_media[] = $media_info; } } // ADD THIS ACTION TO OUTPUT ARRAY $actions_array[] = array( 'action_id' => $action['id'], 'action_date' => $action['date'], 'action_actiontype_id' => $action['actiontype'], 'action_text' => $action['actiontype_text'], 'action_vars' => $action_vars, 'action_user_id' => $action['userid'], 'action_username' => $action_username_info['user_username'], 'objectowner_id' => $action['objectowner_id'], 'objectid2' => $action['objectid2'], 'action_icon' => $action['actiontype_icon'], 'action_media' => $action_media ); } } } // CACHE if( is_object($cache_object) ) { $cache_object->store($actions_array, $cache_id); } } // Process actions (load language) foreach( $actions_array as $action ) { SE_Language::_preload($action['action_text']); } } // RETURN LIST OF ACTIONS return $actions_array; } function actions_display_new_admin($visibility, $actionsperuser, $where = "") { global $database, $user, $owner, $setting, $blockobject; $actions_array = array(); // CACHING //$cache_object = SECache::getInstance('serial'); //$cache_id = 'actions_'.( $visibility ? $visibility : '0').'_'.$actionsperuser.'_'.( $owner->user_exists ? $owner->user_info['user_id'] : '0' ).'_'.( $user->user_exists ? $user->user_info['user_id'] : '0' ).( $where ? '_'.md5($where) : ''); //if( is_object($cache_object) ) //{ //$actions_array = $cache_object->get($cache_id); //} if($visibility==4){ $useindex=""; } else{ $useindex=" USE INDEX(`date`) "; // $useindex=""; } // GET ACTIONS if( empty($actions_array) ) { // GET CURRENT DATE $nowdate = time(); $user_pref_where = ""; /*if( $setting['setting_actions_preference'] == 1 && $user->user_exists ) { if( empty($user->usersetting_info) ) $user->user_settings(); $usersetting_actions_display = join(',', array_filter(explode(',', $user->usersetting_info['usersetting_actions_display']))); $user_pref_where = " se_actiontypes.actiontype_id IN ({$usersetting_actions_display}) AND"; }*/ //if($usersetting_actions_display!="") { $blockobject=array(); $query=$database->database_query("SELECT user_id FROM se_users WHERE user_enabled=1 AND MATCH(user_blocklist) AGAINST('".$user->user_info["user_id"]."' IN NATURAL LANGUAGE MODE)"); while($row2=$database->database_fetch_array($query)) { if($blocked==""){$blocked=$database->database_real_escape_string($row2["user_id"]);} else{ $blocked.=",".$database->database_real_escape_string($row2["user_id"]); } $blockobject[]=$row2["user_id"]; } if($blocked==""){$blocked="0";} $blocklist="";//" bateworldcom_wall.wall.userid NOT IN (".$blocked.") AND "; $blocklist3=" bateworldcom_wall.wall.objectowner_id NOT IN (".$blocked.") AND "; // BEGIN BUILDING QUERY if($visibility!=0){$actions_query = "SELECT bateworldcom_wall.wall.*, se_actiontypes.actiontype_icon, se_actiontypes.actiontype_text, se_actiontypes.actiontype_media FROM bateworldcom_wall.wall ".$useindex." LEFT JOIN se_actiontypes ON bateworldcom_wall.wall.actiontype=se_actiontypes.actiontype_id"; }else{ $actions_query = "SELECT bateworldcom_wall.wall.*, se_actiontypes.actiontype_icon, se_actiontypes.actiontype_text, se_actiontypes.actiontype_media FROM bateworldcom_wall.wall JOIN se_actiontypes ON bateworldcom_wall.wall.actiontype=se_actiontypes.actiontype_id"; } // GET USER PREFERENCES, IF USER LOGGED IN $ex=explode(",", $user->user_info["user_blocklist"]); foreach($ex as $e){ if($e!=""){ $blockobject[]=$e; } } //mail("leprakhauns@gmail.com", "RRR", $visibility." ".$_SERVER["PHP_SELF"]); switch($visibility) { // ALL ACTIONS, NO USER PREFS case 0: $actions_query .= " WHERE"; break; // ALL REGISTERED USERS, EXCLUDING LOGGED IN USER case 1: $actions_query .= " WHERE bateworldcom_wall.wall.userid<>'{$user->user_info['user_id']}' AND"; $actions_query .= $user_pref_where; break; // ONLY MY FRIENDS AND EVERYONE IN MY SUBNET, EXCLUDING LOGGED IN USER case 2: $actions_query .= " LEFT JOIN se_friends ON se_friends.friend_user_id2=bateworldcom_wall.wall.userid AND se_friends.friend_user_id1='{$user->user_info['user_id']}' AND se_friends.friend_status='1'"; $actions_query .= " LEFT JOIN se_users ON se_users.user_id=bateworldcom_wall.wall.userid"; $actions_query .= " WHERE bateworldcom_wall.wall.userid<>'{$user->user_info['user_id']}' AND"; $actions_query .= " (se_friends.friend_id <> 'NULL' OR se_users.user_subnet_id='{$user->user_info['user_subnet_id']}') AND"; $actions_query .= $user_pref_where; break; // ONLY MY FRIENDS, EXCLUDING LOGGED IN USER case 4: $actions_query .= " RIGHT JOIN se_friends ON se_friends.friend_user_id2=bateworldcom_wall.wall.userid AND se_friends.friend_user_id1='{$user->user_info['user_id']}' AND se_friends.friend_status='1'"; $actions_query .= " WHERE bateworldcom_wall.wall.userid<>'{$user->user_info['user_id']}' AND"; $actions_query .= $user_pref_where; break; case 5: $actions_query .= " WHERE"; foreach($ex as $e){ if($e!=""){ if($blocklistown==""){$blocklistown=$database->database_real_escape_string($e);} else{ $blocklistown.=",".$database->database_real_escape_string($e); } } } $blocklistown=""; if($blocklistown==""){$blocklistown="0";} //$actions_query.=" bateworldcom_wall.wall.userid NOT IN(".$database->database_real_escape_string($blocklistown)."0) AND ".$blocklist; $actions_query .= $user_pref_where; break; } // CHECK PRIVACY $actions_query .= " CASE WHEN bateworldcom_wall.wall.objectowner='user' THEN CASE WHEN bateworldcom_wall.wall.userid='{$user->user_info['user_id']}' THEN TRUE "./* WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0) THEN TRUE WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0) THEN TRUE*/" WHEN ((bateworldcom_wall.wall.object_privacy & @SE_PRIVACY_SELF & actiontype!=12) AND bateworldcom_wall.wall.objectowner_id='{$user->user_info['user_id']}') THEN TRUE WHEN ((bateworldcom_wall.wall.object_privacy & @SE_PRIVACY_FRIEND & actiontype!=12) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=bateworldcom_wall.wall.objectowner_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1)) THEN TRUE "./*WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_SUBNET) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_users WHERE user_id=se_actions.action_object_owner_id AND user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1)) THEN TRUE*/" WHEN ((bateworldcom_wall.wall.object_privacy & @SE_PRIVACY_FRIEND2 & actiontype!=12) AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_users ON friends_primary.friend_user_id1=se_users.user_id LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 LIMIT 1)) THEN TRUE ELSE FALSE END "; action_privacy_event_new(array('actions_query' => &$actions_query)); action_privacy_group_new(array('actions_query' => &$actions_query)); action_privacy_forum_new(array('actions_query' => &$actions_query)); // CALL HOOK //($hook = SE_Hook::exists('se_action_privacy')) ? SE_Hook::call($hook, array('actions_query' => &$actions_query)) : NULL; // RESUME CASE STATEMENT $actions_query .= " ELSE TRUE END AND "; // ADD WHERE CLAUSE IF NECESSARY if($where != "") { $actions_query .= " ($where) AND"; } // LIMIT RESULTS TO TIME PERIOD SPECIFIED BY ADMIN //$actions_query .= " bateworldcom_wall.wall.date>".($nowdate-$setting['setting_actions_showlength']); if($_GET["loadfrom"]!=""){ $actions_query .= " bateworldcom_wall.wall.id<".$database->database_real_escape_string($_GET["loadfrom"])." AND "; } // ORDER BY ACTION ID DESCENDING $actions_query .= " 1=1 ORDER BY date DESC"; //if($_GET["loadfrom"]==""){ $actions_query .= " LIMIT 250"; // else{$actions_query .= " LIMIT ".$_GET["loadfrom"].", 50";}*/ // LIMIT RESULTS TO MAX NUMBER SPECIFIED BY ADMIN //{$setting['setting_actions_actionsinlist']}"; // echo $actions_query; // GET RECENT ACTIVITY FEED $actions = $database->database_query($actions_query); $actions_array = Array(); $actions_users_array = Array(); while($action = $database->database_fetch_assoc($actions)) { //if(!in_array($action["userid"], $blockobject)) { // ONLY DISPLAY THIS ACTION IF MAX OCCURRANCES PER USER HAS NOT YET BEEN REACHED $actions_users_array[] = $action['action_user_id']; //$occurrances = array_count_values($actions_users_array); //if($occurrances[$action['action_user_id']] <= $actionsperuser) { // UNSERIALIZE VARIABLES // NOTE: I don't like mb_unserialize: it ignores the strlen param. But it works... if( ($action_vars = unserialize($action['action_text']))===FALSE ) $action_vars = mb_unserialize($action['action_text']); // REGISTER PRELOADED TEXT SE_Language::_preload($action['actiontype_text']); // RETRIEVE MEDIA IF NECESSARY $action_media = false; if( $action['actiontype_media'] ) { $action_media = Array(); if($action['action_id']!=""){ $media = $database->database_query("SELECT * FROM se_actionmedia WHERE actionmedia_action_id='{$action['action_id']}'"); while( $media_info = $database->database_fetch_assoc($media) ) { $action_media[] = $media_info; } } } // ADD THIS ACTION TO OUTPUT ARRAY $actions_array[] = array( 'action_id' => $action['id'], 'action_date' => $action['date'], 'action_actiontype_id' => $action['actiontype'], 'action_text' => $action['actiontype_text'], 'action_vars' => $action_vars, 'action_user_id' => $action['userid'], 'action_username' => $action_username_info['user_username'], 'objectowner_id' => $action['objectowner_id'], 'objectid2' => $action['objectid2'], 'action_icon' => $action['actiontype_icon'], 'action_media' => $action_media ); } } } // CACHE } // Process actions (load language) foreach( $actions_array as $action ) { SE_Language::_preload($action['action_text']); } } // RETURN LIST OF ACTIONS return $actions_array; } function actions_display_new1($visibility, $actionsperuser, $where = "") { global $database, $user, $owner, $setting, $blockobject; $actions_array = array(); // CACHING $cache_object = SECache::getInstance('serial'); $cache_id = 'actions_'.( $visibility ? $visibility : '0').'_'.$actionsperuser.'_'.( $owner->user_exists ? $owner->user_info['user_id'] : '0' ).'_'.( $user->user_exists ? $user->user_info['user_id'] : '0' ).( $where ? '_'.md5($where) : ''); if( is_object($cache_object) ) { //$actions_array = $cache_object->get($cache_id); } if($visibility==4){ $useindex=""; } else{ $useindex=" USE INDEX(`date`) "; // $useindex=""; } // GET ACTIONS if( empty($actions_array) ) { // GET CURRENT DATE $nowdate = time(); $user_pref_where = ""; if( $setting['setting_actions_preference'] == 1 && $user->user_exists ) { if( empty($user->usersetting_info) ) $user->user_settings(); $usersetting_actions_display = join(',', array_filter(explode(',', $user->usersetting_info['usersetting_actions_display']))); $user_pref_where = " se_actiontypes.actiontype_id IN ({$usersetting_actions_display}) AND"; } if($usersetting_actions_display!=""){ $blockobject=array(); $query=$database->database_query("SELECT user_id FROM se_users WHERE user_enabled=1 AND MATCH(user_blocklist) AGAINST('".$user->user_info["user_id"]."' IN NATURAL LANGUAGE MODE)"); while($row2=$database->database_fetch_array($query)) { if($blocked==""){$blocked=$database->database_real_escape_string($row2["user_id"]);} else{ $blocked.=",".$database->database_real_escape_string($row2["user_id"]); } $blockobject[]=$row2["user_id"]; } if($blocked==""){$blocked="0";} $blocklist="";//" bateworldcom_wall.wall.userid NOT IN (".$blocked.") AND "; $blocklist3=" bateworldcom_wall.wall.objectowner_id NOT IN (".$blocked.") AND "; // BEGIN BUILDING QUERY if($visibility!=0){$actions_query = "SELECT bateworldcom_wall.wall.*, se_actiontypes.actiontype_icon, se_actiontypes.actiontype_text, se_actiontypes.actiontype_media FROM bateworldcom_wall.wall ".$useindex." LEFT JOIN se_actiontypes ON bateworldcom_wall.wall.actiontype=se_actiontypes.actiontype_id"; }else{ $actions_query = "SELECT bateworldcom_wall.wall.*, se_actiontypes.actiontype_icon, se_actiontypes.actiontype_text, se_actiontypes.actiontype_media FROM bateworldcom_wall.wall JOIN se_actiontypes ON bateworldcom_wall.wall.actiontype=se_actiontypes.actiontype_id"; } // GET USER PREFERENCES, IF USER LOGGED IN $ex=explode(",", $user->user_info["user_blocklist"]); foreach($ex as $e){ if($e!=""){ $blockobject[]=$e; } } //mail("leprakhauns@gmail.com", "RRR", $visibility." ".$_SERVER["PHP_SELF"]); switch($visibility) { // ALL ACTIONS, NO USER PREFS case 0: $actions_query .= " WHERE"; break; // ALL REGISTERED USERS, EXCLUDING LOGGED IN USER case 1: $actions_query .= " WHERE bateworldcom_wall.wall.userid<>'{$user->user_info['user_id']}' AND"; $actions_query .= $user_pref_where; break; // ONLY MY FRIENDS AND EVERYONE IN MY SUBNET, EXCLUDING LOGGED IN USER case 2: $actions_query .= " LEFT JOIN se_friends ON se_friends.friend_user_id2=bateworldcom_wall.wall.userid AND se_friends.friend_user_id1='{$user->user_info['user_id']}' AND se_friends.friend_status='1'"; $actions_query .= " LEFT JOIN se_users ON se_users.user_id=bateworldcom_wall.wall.userid"; $actions_query .= " WHERE bateworldcom_wall.wall.userid<>'{$user->user_info['user_id']}' AND"; $actions_query .= " (se_friends.friend_id <> 'NULL' OR se_users.user_subnet_id='{$user->user_info['user_subnet_id']}') AND"; $actions_query .= $user_pref_where; break; // ONLY MY FRIENDS, EXCLUDING LOGGED IN USER case 4: $actions_query .= " RIGHT JOIN se_friends ON se_friends.friend_user_id2=bateworldcom_wall.wall.userid AND se_friends.friend_user_id1='{$user->user_info['user_id']}' AND se_friends.friend_status='1'"; $actions_query .= " WHERE bateworldcom_wall.wall.userid<>'{$user->user_info['user_id']}' AND"; $actions_query .= $user_pref_where; break; case 5: $actions_query .= " WHERE"; foreach($ex as $e){ if($e!=""){ if($blocklistown==""){$blocklistown=$database->database_real_escape_string($e);} else{ $blocklistown.=",".$database->database_real_escape_string($e); } } } $blocklistown=""; if($blocklistown==""){$blocklistown="0";} //$actions_query.=" bateworldcom_wall.wall.userid NOT IN(".$database->database_real_escape_string($blocklistown)."0) AND ".$blocklist; $actions_query .= $user_pref_where; break; } // CHECK PRIVACY $actions_query .= " CASE WHEN bateworldcom_wall.wall.objectowner='user' THEN CASE WHEN bateworldcom_wall.wall.userid='{$user->user_info['user_id']}' THEN TRUE "./* WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0) THEN TRUE WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0) THEN TRUE*/" WHEN ((bateworldcom_wall.wall.object_privacy & @SE_PRIVACY_SELF & actiontype!=12) AND bateworldcom_wall.wall.objectowner_id='{$user->user_info['user_id']}') THEN TRUE WHEN ((bateworldcom_wall.wall.object_privacy & @SE_PRIVACY_FRIEND & actiontype!=12) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=bateworldcom_wall.wall.objectowner_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1)) THEN TRUE "./*WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_SUBNET) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_users WHERE user_id=se_actions.action_object_owner_id AND user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1)) THEN TRUE*/" WHEN ((bateworldcom_wall.wall.object_privacy & @SE_PRIVACY_FRIEND2 & actiontype!=12) AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_users ON friends_primary.friend_user_id1=se_users.user_id LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 LIMIT 1)) THEN TRUE ELSE FALSE END "; action_privacy_event_new(array('actions_query' => &$actions_query)); action_privacy_group_new(array('actions_query' => &$actions_query)); action_privacy_forum_new(array('actions_query' => &$actions_query)); // CALL HOOK //($hook = SE_Hook::exists('se_action_privacy')) ? SE_Hook::call($hook, array('actions_query' => &$actions_query)) : NULL; // RESUME CASE STATEMENT $actions_query .= " ELSE TRUE END AND "; // ADD WHERE CLAUSE IF NECESSARY if($where != "") { $actions_query .= " ($where) AND"; } // LIMIT RESULTS TO TIME PERIOD SPECIFIED BY ADMIN //$actions_query .= " bateworldcom_wall.wall.date>".($nowdate-$setting['setting_actions_showlength']); if($_GET["loadfrom"]!=""){ $actions_query .= " bateworldcom_wall.wall.id<".$database->database_real_escape_string($_GET["loadfrom"])." AND "; } // ORDER BY ACTION ID DESCENDING $actions_query .= " bateworldcom_wall.wall.deleted=0 ORDER BY date DESC"; //if($_GET["loadfrom"]==""){ $actions_query .= " LIMIT 50"; // else{$actions_query .= " LIMIT ".$_GET["loadfrom"].", 50";}*/ // LIMIT RESULTS TO MAX NUMBER SPECIFIED BY ADMIN //{$setting['setting_actions_actionsinlist']}"; // echo $actions_query; // GET RECENT ACTIVITY FEED if(SE_DEBUG1){ //echo $actions_query; $actions = $database->database_query($actions_query) or die($database->database_error()); }else{ $actions = $database->database_query($actions_query); } $actions_array = Array(); $actions_users_array = Array(); while($action = $database->database_fetch_assoc($actions)) { if(!in_array($action["userid"], $blockobject)){ // ONLY DISPLAY THIS ACTION IF MAX OCCURRANCES PER USER HAS NOT YET BEEN REACHED $actions_users_array[] = $action['action_user_id']; //$occurrances = array_count_values($actions_users_array); //if($occurrances[$action['action_user_id']] <= $actionsperuser) { // UNSERIALIZE VARIABLES // NOTE: I don't like mb_unserialize: it ignores the strlen param. But it works... if( ($action_vars = unserialize($action['action_text']))===FALSE ) $action_vars = mb_unserialize($action['action_text']); // REGISTER PRELOADED TEXT SE_Language::_preload($action['actiontype_text']); // RETRIEVE MEDIA IF NECESSARY $action_media = false; if( $action['actiontype_media'] ) { $action_media = Array(); if($action['action_id']!=""){ $media = $database->database_query("SELECT * FROM se_actionmedia WHERE actionmedia_action_id='{$action['action_id']}'"); while( $media_info = $database->database_fetch_assoc($media) ) { $action_media[] = $media_info; } } } // ADD THIS ACTION TO OUTPUT ARRAY $actions_array[] = array( 'action_id' => $action['id'], 'action_date' => $action['date'], 'action_actiontype_id' => $action['actiontype'], 'action_text' => $action['actiontype_text'], 'action_vars' => $action_vars, 'action_user_id' => $action['userid'], 'action_username' => $action_username_info['user_username'], 'objectowner_id' => $action['objectowner_id'], 'objectid2' => $action['objectid2'], 'action_icon' => $action['actiontype_icon'], 'action_media' => $action_media ); } } } // CACHE if( is_object($cache_object) ) { $cache_object->store($actions_array, $cache_id); } } // Process actions (load language) foreach( $actions_array as $action ) { SE_Language::_preload($action['action_text']); } } // RETURN LIST OF ACTIONS return $actions_array; } // END actions_display() METHOD function actions_display_new($visibility, $actionsperuser, $where = "") { global $database, $user, $owner, $setting; $actions_array = array(); // CACHING $cache_object = SECache::getInstance('serial'); $cache_id = 'actions_'.( $visibility ? $visibility : '0').'_'.$actionsperuser.'_'.( $owner->user_exists ? $owner->user_info['user_id'] : '0' ).'_'.( $user->user_exists ? $user->user_info['user_id'] : '0' ).( $where ? '_'.md5($where) : ''); if( is_object($cache_object) ) { //$actions_array = $cache_object->get($cache_id); } // GET ACTIONS if( empty($actions_array) ) { // GET CURRENT DATE $nowdate = time(); $user_pref_where = ""; if( $setting['setting_actions_preference'] == 1 && $user->user_exists ) { if( empty($user->usersetting_info) ) $user->user_settings(); $usersetting_actions_display = join(',', array_filter(explode(',', $user->usersetting_info['usersetting_actions_display']))); $user_pref_where = " se_actiontypes.actiontype_id IN ({$usersetting_actions_display}) AND"; } if($usersetting_actions_display!=""){ $blockobject=array(); $query=$database->database_query("SELECT user_id FROM se_users WHERE user_enabled=1 AND MATCH(user_blocklist) AGAINST('".$user->user_info["user_id"]."' IN NATURAL LANGUAGE MODE)"); while($row2=$database->database_fetch_array($query)) { if($blocked==""){$blocked=$database->database_real_escape_string($row2["user_id"]);} else{ $blocked.=",".$database->database_real_escape_string($row2["user_id"]); } $blockobject[]=$row2["user_id"]; } if($blocked==""){$blocked="0";} $blocklist=" bateworldcom_wall.wall.userid NOT IN (".$blocked.") AND "; $blocklist3=" bateworldcom_wall.wall.objectowner_id NOT IN (".$blocked.") AND "; // BEGIN BUILDING QUERY if($visibility!=0){$actions_query = "SELECT bateworldcom_wall.wall.*, se_actiontypes.actiontype_icon, se_actiontypes.actiontype_text, se_actiontypes.actiontype_media FROM bateworldcom_wall.wall USE INDEX (`date`) LEFT JOIN se_actiontypes ON bateworldcom_wall.wall.actiontype=se_actiontypes.actiontype_id"; }else{ $actions_query = "SELECT bateworldcom_wall.wall.*, se_actiontypes.actiontype_icon, se_actiontypes.actiontype_text, se_actiontypes.actiontype_media FROM bateworldcom_wall.wall JOIN se_actiontypes ON bateworldcom_wall.wall.actiontype=se_actiontypes.actiontype_id"; } // GET USER PREFERENCES, IF USER LOGGED IN //mail("leprakhauns@gmail.com", "RRR", $visibility." ".$_SERVER["PHP_SELF"]); switch($visibility) { // ALL ACTIONS, NO USER PREFS case 0: $actions_query .= " WHERE"; break; // ALL REGISTERED USERS, EXCLUDING LOGGED IN USER case 1: $actions_query .= " WHERE bateworldcom_wall.wall.userid<>'{$user->user_info['user_id']}' AND"; $actions_query .= $user_pref_where; break; // ONLY MY FRIENDS AND EVERYONE IN MY SUBNET, EXCLUDING LOGGED IN USER case 2: $actions_query .= " LEFT JOIN se_friends ON se_friends.friend_user_id2=bateworldcom_wall.wall.userid AND se_friends.friend_user_id1='{$user->user_info['user_id']}' AND se_friends.friend_status='1'"; $actions_query .= " LEFT JOIN se_users ON se_users.user_id=bateworldcom_wall.wall.userid"; $actions_query .= " WHERE bateworldcom_wall.wall.userid<>'{$user->user_info['user_id']}' AND"; $actions_query .= " (se_friends.friend_id <> 'NULL' OR se_users.user_subnet_id='{$user->user_info['user_subnet_id']}') AND"; $actions_query .= $user_pref_where; break; // ONLY MY FRIENDS, EXCLUDING LOGGED IN USER case 4: $actions_query .= " RIGHT JOIN se_friends ON se_friends.friend_user_id2=bateworldcom_wall.wall.userid AND se_friends.friend_user_id1='{$user->user_info['user_id']}' AND se_friends.friend_status='1'"; $actions_query .= " WHERE bateworldcom_wall.wall.userid<>'{$user->user_info['user_id']}' AND"; $actions_query .= $user_pref_where; break; case 5: $actions_query .= " WHERE"; $ex=explode(",", $user->user_info["user_blocklist"]); foreach($ex as $e){ if($e!=""){ if($blocklistown==""){$blocklistown=$database->database_real_escape_string($e);} else{ $blocklistown.=",".$database->database_real_escape_string($e); } $blockobject[]=$e; } } if($blocklistown==""){$blocklistown="0";} $actions_query.=" bateworldcom_wall.wall.userid NOT IN(".$database->database_real_escape_string($blocklistown)."0) AND ".$blocklist; $actions_query .= $user_pref_where; break; } // CHECK PRIVACY $actions_query .= " CASE WHEN bateworldcom_wall.wall.objectowner='user' THEN CASE WHEN bateworldcom_wall.wall.userid='{$user->user_info['user_id']}' THEN TRUE "./* WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0) THEN TRUE WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0) THEN TRUE*/" WHEN ((bateworldcom_wall.wall.object_privacy & @SE_PRIVACY_SELF) AND bateworldcom_wall.wall.objectowner_id='{$user->user_info['user_id']}') THEN TRUE WHEN ((bateworldcom_wall.wall.object_privacy & @SE_PRIVACY_FRIEND) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=bateworldcom_wall.wall.objectowner_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1)) THEN TRUE "./*WHEN ((se_actions.action_object_privacy & @SE_PRIVACY_SUBNET) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_users WHERE user_id=se_actions.action_object_owner_id AND user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1)) THEN TRUE*/" WHEN ((bateworldcom_wall.wall.object_privacy & @SE_PRIVACY_FRIEND2) AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_users ON friends_primary.friend_user_id1=se_users.user_id LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE "./*friends_primary.friend_user_id1=se_actions.action_object_owner_id AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' AND se_users.user_subnet_id='{$user->user_info['user_subnet_id']}'*/" LIMIT 1)) THEN TRUE ELSE FALSE END "; action_privacy_event_new(array('actions_query' => &$actions_query)); action_privacy_group_new(array('actions_query' => &$actions_query)); action_privacy_forum_new(array('actions_query' => &$actions_query)); // CALL HOOK //($hook = SE_Hook::exists('se_action_privacy')) ? SE_Hook::call($hook, array('actions_query' => &$actions_query)) : NULL; // RESUME CASE STATEMENT $actions_query .= " ELSE TRUE END AND "; // ADD WHERE CLAUSE IF NECESSARY if($where != "") { $actions_query .= " ($where) AND"; } // LIMIT RESULTS TO TIME PERIOD SPECIFIED BY ADMIN //$actions_query .= " bateworldcom_wall.wall.date>".($nowdate-$setting['setting_actions_showlength']); if($_GET["loadfrom"]!=""){ $actions_query .= " bateworldcom_wall.wall.id<".$database->database_real_escape_string($_GET["loadfrom"])." AND "; } // ORDER BY ACTION ID DESCENDING $actions_query .= " 1=1 ORDER BY date DESC"; //if($_GET["loadfrom"]==""){ $actions_query .= " LIMIT 50"; /*if(SE_DEBUG){ echo $visibility; }* // else{$actions_query .= " LIMIT ".$_GET["loadfrom"].", 50";}*/ // LIMIT RESULTS TO MAX NUMBER SPECIFIED BY ADMIN //{$setting['setting_actions_actionsinlist']}"; // echo $actions_query; // GET RECENT ACTIVITY FEED if(SE_DEBUG1){ $actions = $database->database_query($actions_query) or die($database->database_error()); }else{ $actions = $database->database_query($actions_query); } $actions_array = Array(); $actions_users_array = Array(); while($action = $database->database_fetch_assoc($actions)) { if(SE_DEBUG1){ //if($action["objectowner"]=="user" && in_array($objectowner_id, $blockobject)){echo "AAAAAA";} } // ONLY DISPLAY THIS ACTION IF MAX OCCURRANCES PER USER HAS NOT YET BEEN REACHED $actions_users_array[] = $action['action_user_id']; //$occurrances = array_count_values($actions_users_array); //if($occurrances[$action['action_user_id']] <= $actionsperuser) { // UNSERIALIZE VARIABLES // NOTE: I don't like mb_unserialize: it ignores the strlen param. But it works... if( ($action_vars = unserialize($action['action_text']))===FALSE ) $action_vars = mb_unserialize($action['action_text']); // REGISTER PRELOADED TEXT SE_Language::_preload($action['actiontype_text']); // RETRIEVE MEDIA IF NECESSARY $action_media = false; if( $action['actiontype_media'] ) { $action_media = Array(); $media = $database->database_query("SELECT * FROM se_actionmedia WHERE actionmedia_action_id='{$action['action_id']}'"); while( $media_info = $database->database_fetch_assoc($media) ) { $action_media[] = $media_info; } } // ADD THIS ACTION TO OUTPUT ARRAY $actions_array[] = array( 'action_id' => $action['id'], 'action_date' => $action['date'], 'action_actiontype_id' => $action['actiontype'], 'action_text' => $action['actiontype_text'], 'action_vars' => $action_vars, 'action_user_id' => $action['userid'], 'action_username' => $action_username_info['user_username'], 'objectowner_id' => $action['objectowner_id'], 'objectid2' => $action['objectid2'], 'action_icon' => $action['actiontype_icon'], 'action_media' => $action_media ); } } // CACHE if( is_object($cache_object) ) { $cache_object->store($actions_array, $cache_id); } } // Process actions (load language) foreach( $actions_array as $action ) { SE_Language::_preload($action['action_text']); } } // RETURN LIST OF ACTIONS return $actions_array; } function actions_allowed() { global $user, $setting, $database; if( !$setting['setting_actions_preference'] ) return FALSE; $actiontypes_array = NULL; // CACHING $cache_object = SECache::getInstance('serial'); if( is_object($cache_object) ) { $actiontypes_array = $cache_object->get('actiontypes'); } // RETRIEVAL if( !is_array($actiontypes_array) || empty($actiontypes_array) ) { $resource = $database->database_query("SELECT actiontype_id, actiontype_desc FROM se_actiontypes WHERE actiontype_enabled=1"); while( $actiontype = $database->database_fetch_assoc($resource) ) { $actiontypes_array[] = $actiontype; } // CACHE if( is_object($cache_object) ) { $cache_object->store($actiontypes_array, 'actiontypes'); } } // POST PROCESSING if( empty($user->usersetting_info) ) $user->user_settings(); $actiontypes_display = explode(",", $user->usersetting_info['usersetting_actions_display']); foreach( $actiontypes_array as $actiontype_index=>$actiontype ) { SE_Language::_preload($actiontype['actiontype_desc']); // MAKE THIS ACTION TYPE SELECTED IF ITS NOT DISALLOWED BY USER $actiontypes_array[$actiontype_index]['actiontype_selected'] = ( in_array($actiontype['actiontype_id'], $actiontypes_display) ); } return $actiontypes_array; } } ?>