Whats the best Chat module?

Mighty_Y · 08-09-2003, 12:14 PM

can you post line 80-90 of the index.php file??

paycheck · 08-09-2003, 12:18 PM

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=mysql_query($sql);
  if(mysql_num_rows($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>";

P.S. The top is off of MrCulinary.com the one that has the error message. and the bottom one is from JSM-Inc.com

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=mysql_query($sql);
  if(mysql_num_rows($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>";

Mighty_Y · 08-09-2003, 12:43 PM

replace the code with this one

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=sql_fetcharray($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>";

paycheck · 08-09-2003, 12:58 PM

MikeM I am dissapointed that you would think I have not thought of using the index from the site that works already

It still gives me the same errors so the mystery goes on. I did not see any hcanges in that block of code you said to use, or did you change something.

JM

Mighty_Y · 08-09-2003, 01: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>";