About this Page
This is a discussion on Whats the best Chat module? within the Nuke 6.5 to 6.9 - Modules forums, part of the PHP-Nuke 6.5 to 6.9 category; can you post line 80-90 of the index.php file??...

Mighty_Y · #11 (**permalink**) 08-09-2003, 01:14 PM

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

paycheck · #12 (**permalink**) 08-09-2003, 01: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 · #13 (**permalink**) 08-09-2003, 01: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 · #14 (**permalink**) 08-09-2003, 01: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 · #15 (**permalink**) 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>";

About this PageThis is a discussion on Whats the best Chat module? within the Nuke 6.5 to 6.9 - Modules forums, part of the PHP-Nuke 6.5 to 6.9 category; can you post line 80-90 of the index.php file??...

Whats the best Chat module?

About this Page
This is a discussion on Whats the best Chat module? within the Nuke 6.5 to 6.9 - Modules forums, part of the PHP-Nuke 6.5 to 6.9 category; can you post line 80-90 of the index.php file??...