This is a mod I am trying to release to vb.org for users that have vbindex.
WAIT WAIT before you click back... what I am doing is a detailed mod. but one part I am stuck on. I want in the online users a flag to show up.
example :dead: <-pretend that is a flag.
:dead: T3media
:lick: Your name
:devious: his name.
This "flag" is sitting in the users profile field. (say 20)
Now I know already that:
PHP Code:
SELECT field20
FROM myvb3_userfield
WHERE userid = x
where x is the user's id number will bring back the text that the flag is...
In this example it is the "dead" icon so it would just say dead.
but in the php I would have it set like $flag.gif which would print the flag that has the same name.
now vbindex wol code is as such....
PHP Code:
// ####################### PROCESS vBindex WOL ##########################
if ($vbindex['options'] & VBI_WOL) {
$online['datecut'] = TIMENOW - $vboptions['cookietimeout'];
$buddies = explode(' ', $bbuserinfo['buddylist']);
$onlineusers = $DB_site->query("
## GET ONLINE USERS ##
SELECT user.username, (user.options & $_USEROPTIONS[invisible]) AS invisible,
user.usergroupid, session.userid, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM ".TABLE_PREFIX."session AS session
LEFT JOIN ".TABLE_PREFIX."user AS user ON (user.userid = session.userid)
WHERE session.lastactivity > $online[datecut]
ORDER BY ".iif($permissions['genericpermissions'] & CANSEEHIDDEN, 'invisible ASC, ')."username ASC");
$home['onlinetotal'] = 0;
$home['onlineguesttotal'] = 0;
$home['onlinemembertotal'] = 0;
$done = array();
while($onlineuser = $DB_site->fetch_array($onlineusers)) {
if ($onlineuser['userid'] && !$done["$onlineuser[userid]"]) {
$done["$onlineuser[userid]"] = true;
$home['onlinetotal']++;
$home['onlinemembertotal']++;
// do invisible users
if (($permissions['genericpermissions'] & CANSEEHIDDEN) && $onlineuser['invisible']) {
$onlineuser['invisiblemark'] = '*';
} elseif ($onlineuser['invisible']) {
$home['onlineguesttotal']++;
$home['onlinemembertotal']--;
break 1;
}
// do buddies
if (in_array($onlineuser['userid'], $buddies)) {
$onlineuser['buddymark'] = '+';
}
$onlineuser['musername'] = fetch_musername($onlineuser);
eval("\$home[onlineusers] .= \", ".fetch_template('vbindex_onlineuser')."\";");
} elseif ($onlineuser['userid'] == 0) {
$home['onlineguesttotal']++;
$home['onlinetotal']++;
}
}
if ($vbindex['options'] & VBI_24WOL) {
// show users from the last 24 hours
$show['last24'] = true;
unset($onlineuser);
$starttime = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
if ($vbindex['options'] & VBI_24WOLUSER) {
// show user names and count
$show['last24user'] = true;
$fetchusers = $DB_site->query("
## USERS IN PAST 24HRS ##
SELECT username, userid, usergroupid,
(user.options & $_USEROPTIONS[invisible]) AS invisible,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM ".TABLE_PREFIX."user AS user
WHERE lastactivity >= $starttime
ORDER BY username ASC
");
while($onlineuser = $DB_site->fetch_array($fetchusers)) {
$home['last24count']++;
$onlineuser['musername'] = fetch_musername($onlineuser);
if (($permissions['genericpermissions'] & CANSEEHIDDEN) && $onlineuser['invisible']) {
$onlineuser['invisiblemark'] = '*';
} elseif ($onlineuser['invisible']) {
$onlineuser['musername'] = '';
$home['last24count']--;
}
eval("\$home[last24] .= \", ".fetch_template('vbindex_onlineuser')."\";");
}
// removed inital comma in online list
$home['last24'] = substr($home['last24'], 2);
// memory saving
unset($user);
$DB_site->free_result($fetchusers);
} else {
// show count only
$show['last24user'] = false;
$onlinetoday = $DB_site->query_first(" ## USERS IN LAST 24HRS COUNT ##
SELECT COUNT(*) AS count
FROM ".TABLE_PREFIX."user
WHERE lastactivity >= $starttime
");
$home['last24count'] = $onlinetoday['count'];
}
}
// removed inital comma in online list
$home['onlineusers'] = substr($home['onlineusers'], 2);
eval("\$side[onlineusers] .= \"".fetch_template('vbindex_onlineusers')."\";");
// memory saving
unset($onlineuser, $done, $online, $buddies);
$DB_site->free_result($onlineusers);
}
where you suggest I should put the small piece of code? I need help becuase I am not making progress.
Thank you!!!
More Information