[2023-01-23] 4images 1.10 released
0 Members and 1 Guest are viewing this topic.
CREATE TABLE `4images_lastuser` ( `lastuser_id` smallint(5) NOT NULL auto_increment, `userprofil_id` smallint(10) NOT NULL default '0', `user_on_id` smallint(10) NOT NULL default '0', `last_date` int(15) NOT NULL default '0', PRIMARY KEY (`lastuser_id`)) TYPE=MyISAM ;
define('WORDLIST_TABLE', $table_prefix.'wordlist');
define('LASTUSER_TABLE', $table_prefix.'lastuser');
if ($user_row = get_user_info($user_id)) { $user_homepage = (isset($user_row['user_homepage'])) ? format_url($user_row['user_homepage']) : REPLACE_EMPTY; if (!empty($user_homepage) && $user_homepage != REPLACE_EMPTY) { $user_homepage_button = "<a href=\"".$user_homepage."\" target=\"_blank\"><img src=\"".get_gallery_image("homepage.gif")."\" border=\"0\" alt=\"".$user_homepage."\" /></a>"; } else { $user_homepage_button = REPLACE_EMPTY; }
if($user_info['user_id'] <> GUEST) { if($user_info[user_id] <> $user_row['user_id']) { $query = "SELECT COUNT(*) FROM ".LASTUSER_TABLE." WHERE userprofil_id = '".$user_row['user_id']."' AND user_on_id = '".$user_info[user_id]."' "; $sql = mysql_query($query); $on = mysql_result($sql,0); if($on == "0") { $time = time(); $query = "INSERT INTO ".LASTUSER_TABLE." (userprofil_id, user_on_id, last_date) VALUES ('".$user_row['user_id']."', '".$user_info[user_id]."', '".$time."') "; $sql = mysql_query($query); } if($on == "1") { $new_time = time(); $query = "UPDATE ".LASTUSER_TABLE." SET last_date = '".$new_time."' WHERE userprofil_id = '".$user_row['user_id']."' AND user_on_id = '".$user_info[user_id]."' "; $sql = mysql_query($query); } } $limit = 5; // IF YOU WANT SHOW MORE THEN 5 CHANGE IT ;) $query = "SELECT lastuser_id, userprofil_id, user_on_id, last_date, u.user_id, user_name FROM (".LASTUSER_TABLE." i) LEFT JOIN ".USERS_TABLE." u ON (u.user_id) = i.user_on_id WHERE userprofil_id = ".$user_row['user_id']." ORDER BY i.last_date DESC LIMIT 0 , ".$limit.""; $sql = mysql_query($query); while($ds = mysql_fetch_object($sql)) { $on_time = date("d.m.Y H:i", $ds->last_date); $last_user .= "<a href='member.php?action=showprofile&user_id=".$ds->user_id."'>".$ds->user_name."</a> <small>(".$on_time.")</small> | "; } $query = "SELECT COUNT(*) FROM ".LASTUSER_TABLE." WHERE userprofil_id = '".$user_row['user_id']."' "; $sql = mysql_query($query); $on = mysql_result($sql,0); if($on > $limit) { $query = "SELECT * FROM ".LASTUSER_TABLE." WHERE userprofil_id = '".$user_row['user_id']."' ORDER BY last_date DESC LIMIT ".$limit.", ".$limit." "; $sql = mysql_query($query); $ds = mysql_fetch_object($sql); $query = "DELETE FROM ".LASTUSER_TABLE." WHERE userprofil_id = '".$user_row['user_id']."' AND last_date <= ".$ds->last_date." "; $sql = mysql_query($query); } }
"user_icq" => $user_icq,
"last_user" => $last_user, "lang_last_user" => $lang['last_user'],
?>
//-------------------------------------------//----Last User on Profil -------------------//-------------------------------------------$lang['last_user'] = "Letze User: ";
//-------------------------------------------//----Last User on Profil -------------------//-------------------------------------------$lang['last_user'] = "Last User: ";
<b>{lang_last_user}</b> {last_user}
Great Mod !!!A Question, can we set for 5 (last users) ???
Quote from: Stoleti on August 20, 2006, 04:52:37 PMGreat Mod !!!A Question, can we set for 5 (last users) ??? i dont undersand...
$limit = 5;
you can change this with Code: [Select]$limit = 5;
echo $time;
if($user_id <> GUEST)
if($user_info['user_id'] <> GUEST)
@b.o.fan:Nice mod, but please make it use 4images build-in database class.($site_db)also, debuging leftovers?Code: [Select] echo $time;@Stoleti:Looks like a bug. line Code: [Select] if($user_id <> GUEST)Should be Code: [Select] if($user_info['user_id'] <> GUEST)
I donīt see the names from the last users... I see <b>{lang_last_user}</b> but I donīt see {last_user} in the plofile... My site: http://www.paxykochan.net/myart/member.php?action=showprofile&user_id=2please could you help me??
PLEASE ATTACH THE FILES.DO NOT SHOW CONTENT OF THE FILES IN THE REPLYS, IT ONLY MAKES THIS FORUM SLOWER