ghost mode (chatroom)

[brand]

hi there friends i am looking for ghost mode for chat rooms i now it can be done on the site its self but looking for it in the chatrooms so no one would now that u are there i am needing it for the wapdesire v_2 script please

[brand]

right i have tryed my self and this is what i got so far

function chatonline($sid)
{
if(ghosts(getuid_sid($sid))){
$chatonline=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM users a INNER JOIN online b ON a.id=b.uid"));
$chatonline2=$chatonline[0];
}else{
$chatonline=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM users a INNER JOIN online b ON a.id=b.uid"));
$chatonline2=$chatonline[0];
$count=mysql_fetch_array(mysql_query("SELECT COUNT(*)  FROM users a INNER JOIN online b ON a.id=b.uid WHERE a.hidden='1' AND a.id!='".getuid_sid($sid)."'"));
if($count[0]>0)$chatonline2=($chatonline[0]-$count[0]);
}
return $chatonline2;
}

but i get databse error on my screen and when i try this

function chatonline($sid)
{
if(ghosts(getuid_sid($sid))){
$chatonline=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM hidden a INNER JOIN chatonline b ON a.id=b.uid"));
$chatonline2=$chatonline[0];
}else{
$chatonline=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM hidden a INNER JOIN chatonline b ON a.id=b.uid"));
$chatonline2=$chatonline[0];
$count=mysql_fetch_array(mysql_query("SELECT COUNT(*)  FROM hidden a INNER JOIN chatonline b ON a.id=b.uid WHERE a.hidden='1' AND a.id!='".getuid_sid($sid)."'"));
if($count[0]>0)$chatonline2=($chatonline[0]-$count[0]);
}
return $chatonline2;
}

i get this error on the site

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/******/public_html/core/functions.inc on line 625

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/******/public_html/core/functions.inc on line 627

o
Database Error!

i have also added this bit in to the chatrooms and chatonline in the database

hidden char (1) latin1_swedish_ci default 0


please help me on where i gone wrong please i am using wapdesire v_2 script

[m4ster_v4]

why u select hidden table if u doest have it..

function chatonline($sid)
{
if(ghosts(getuid_sid($sid))){
$chatonline=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM chatonline"));
$chatonline2=$chatonline[0];
}else{
$chatonline=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM chatonline"));
$chatonline2=$chatonline[0];
$count=mysql_fetch_array(mysql_query("SELECT COUNT(*) chatonline WHERE hidden='1' AND id!='".getuid_sid($sid)."'"));
if($count[0]>0)$chatonline2=($chatonline[0]-$count[0]);
}
return $chatonline2;
}