need help creating/modifying a block

elb0m · **need help creating/modifying a block -** 04-11-2003, 10:16 AM

i need help creating a block or even modifying the "who is online" block
i need to see who's online [ by their username] under the line that says There are 5 members online

Code:

$member_online_num = $db->sql_numrows($result);

that shows the number of the members online i guess

what about their username ?

Code:

$content .= "<form action=\"modules.php?name=Your_Account\" method=\"post\">";

if (is_user($user)) {
    $content .= "
<img src=\"images/blocks/group-4.gif\" height=\"14\" width=\"17\"> "._BWEL.", $uname.
\n<hr>\n";
    $sql = "SELECT user_id FROM $user_prefix"._users." WHERE username='$uname'";
    $result = $db->sql_query($sql);
    $row = $db->sql_fetchrow($result);

thats it ? i would appreciate it very much
thanks =) :wink:

mikem · 04-11-2003, 11:21 AM

are you taling about how our User Menu block shows the users names?
If so, then why not download ours and check the code in it to see what you need.
There is some SQL calls that need to be included in order for it to list the users online and their names.

mikem

elb0m · 04-11-2003, 11:45 AM

thats why i need help for
i need to help me call the SQL queries ..
i also need the SQL queries so that i can make a block with my Active Avatar !
its not that hard i guess
thats what i have but nothing comes out ,empty block it says

Code:

<?php
require_once("mainfile.php");
if ( ereg( "(http)", $userinfo[user_avatar]) ) 
   { 
$content .= "
<center><img src=\"$userinfo[user_avatar]\">
</center>\n"; 
} 
else 
if ($userinfo[user_avatar]) 
{ 
$content .= "
<center><img src=\"modules/Forums/images/avatars/$userinfo[user_avatar]\" alt=\"\"></center>
\n"; 
   }
	?>

mikem · 04-11-2003, 12:16 PM

Code:

<?php 
require_once("mainfile.php"); 
global $user, $cookie, $prefix, $anonymous, $dbi, $user_prefix, $username, $stop, $module_name, $redirect, $mode, $t, $f, $admin, $userinfo;

getusrinfo($user);

if ( ereg( "(http)", $userinfo[user_avatar]) ) 
   { 
$content .= "
<center><img src=\"$userinfo[user_avatar]\">
</center>\n"; 
} 
else 
if ($userinfo[user_avatar]) 
{ 
$content .= "
<center><img src=\"modules/Forums/images/avatars/$userinfo[user_avatar]\" alt=\"\"></center>
\n"; 
   } 
   ?>

try that

elb0m · 04-11-2003, 02:15 PM

is there a block that shows the 10 Latest Active REPLYS ? not topics .. like the Center Up but a block to the left ?

ops:

elb0m · 04-13-2003, 04:44 AM

Code:

<?php

global $prefix, $dbi, $sitename;

$result = sql_query("SELECT ".$prefix."_topicsbb.topic_id, ".$prefix."_topicsbb.topic_title,".$prefix."_topicsbb.forum_id,".$prefix."_forums.forum_id FROM ".$prefix."_topicsbb,".$prefix."_forums where ".$prefix."_topicsbb.forum_id=".$prefix."_forums.forum_id and auth_view=0 ORDER BY ".$prefix."_topicsbb.topic_last_post_id DESC LIMIT 10", $dbi);
$content = "
";
while(list($topic_id, $topic_title) = sql_fetch_row($result, $dbi)) {
$content .= "<big>&</big><a href=\"modules.php?name=Forums&file=viewtopic&t=$topic_id\">$topic_title</a>
";
}
$content .= "
<center>[ <a href=\"modules.php?name=Forums\">$sitename Forums</a> ]</center>";

?>

i've done this but an error comes up

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/moh-ogan/public_html/includes/sql_layer.php on line 286

elb0m · **eh ? -** 04-17-2003, 06:30 AM

eh ?