Nukemods Forum - View Single Post

Mighty_Y · 08-09-2003, 02:07 PM

Hey I'm not mikem

Try this one, make sure the file has overwritten the original file and then post back with the error message you got, cause i don't think it will be the same anymore

Code:

<TD WIDTH="55%"><FONT CLASS="newstitle"><?=_WCROOMDESC?></FONT></TD> 
      <TD WIDTH="10%"><FONT CLASS="newstitle"><?=_WCROOMOCCUPANTS?></FONT></TD> 
    </TR> 
<? 
  $sql = "select ".$prefix."_chatroom.*, count(".$prefix."_chatuser.rid) as users from ".$prefix."_chatroom left join ".$prefix."_chatuser on ".$prefix."_chatuser.rid = ".$prefix."_chatroom.rid group by ".$prefix."_chatroom.rid order by ".$prefix."_chatroom.typ, ".$prefix."_chatroom.name"; 
  $q=sql_query($sql);
  if(sql_numrows($q) == 0){
    echo "<TR BGCOLOR=$bgcolor2><TD COLSPAN=\"4\"><FONT CLASS=normal><CENTER>"._WCNOACTIVE."</CENTER></FONT></TD></TR>"; 
  } else { 
    while($row=mysql_fetch_array($q)) { 
      echo "<TR BGCOLOR=$bgcolor2><TD><FONT CLASS=normal><a href=\"modules.php?op=modload&name=".$ModName."&file=index&roomid=$row[rid]\">$row[name]</a></TD>";