Can somebody tell me whats wrong with line of code

Premium Joined: Jan 26, 2003 Posts: 230 Location: USA

$member_online_num = mysql_num_rows($sql);
$i = 1;
while ($session = mysql_fetch_array($sql)) {

Line 196 and 198 are getting some errors on this messager block I am trying to add.

Thanks

Joined: Jan 31, 2004 Posts: -88

lots. First, it doesn't know what to do with those database commands, you've not told it.

Secondly, what's $SQL????

Try adding , $dbi after $sql in those lines.

Artificialintel

Premium Joined: Jan 26, 2003 Posts: 230 Location: USA

Code:

<?php
$refreshtime = 7000; //refresh time in ms

if (!IsSet($mainfile)) { include ("mainfile.php"); }
include('config.php');
include('modules/Private_Messages/functions.php');
include('auth.php');
global $sitename, $bgcolor1,$bgcolor2, $textcolor1, $textcolor2,$lang;

if ($lang=='french')
{
define("_ENLIGNE","En ligne");
define("_TOUSLESMEMBRES","Tous les membres");
define("_VOIRQUIESTENLIGNE","Voir qui est en ligne");
define("_COMMENCANTPAR","Commencant par");
define("_ENVOYERUNMSG","Envoyer un message");
define("_INFOS","infos");
define("_A","à");
define("_MSGENVOYE","Message envoyé");
define("_ENVOYE","Envoyé");
define("_MSGRECU","Message recu de");
define("_MSG","Message");
define("_EFFACER","Effacer ce message de ma boite en répondant");
define("_ENVOYELE","Envoyé le");
define("_INFOSDE","Infos de");
define("_WEBSITE","Site");
define("_EMAIL","E-mail");
define("_ICQ","ICQ");
define("_AIM","AIM");
define("_YIM","YIM");
define("_MSNM","MSNM");
define("_LOCATION","Location");
define("_OCC","Occupations");
define("_CENTRES","Centres d intérêts");
define("_SIGN","Signature");
define("_EXTRA","Extra");
define("_BTFERMER","bouton-fermer.gif");
define("_BTREPONDRE","bouton-repondre.gif");
define("_BTENVOYER","bouton-envoyer.gif");
define("_PAR","par");
define("_PASSLOST","Passe perdu ?");
define("_CREATE","Creer un compte");
define("_ENVOYER","Envoyer");
define("_FERMER","Fermer");
define("_REPONDRE","Repondre");
}
else
{
define("_ENLIGNE","Online");
define("_TOUSLESMEMBRES","All members");
define("_VOIRQUIESTENLIGNE","See online members");
define("_COMMENCANTPAR","Start by");
define("_ENVOYERUNMSG","Send a message");
define("_INFOS","info");
define("_A","to");
define("_MSGENVOYE","Message sent");
define("_ENVOYE","Sent");
define("_MSGRECU","Message from");
define("_MSG","Message");
define("_EFFACER","Delete on reply");
define("_ENVOYELE","Send the");
define("_INFOSDE","Infos from");
define("_WEBSITE","webSite");
define("_EMAIL","E-mail");
define("_ICQ","ICQ");
define("_AIM","AIM");
define("_YIM","YIM");
define("_MSNM","MSNM");
define("_LOCATION","Location");
define("_OCC","Occupation");
define("_CENTRES","Interest");
define("_SIGN","Signature");
define("_EXTRA","Extra");
define("_BTFERMER","bouton-fermer-us.gif");
define("_BTREPONDRE","bouton-repondre-us.gif");
define("_BTENVOYER","bouton-envoyer-us.gif");
define("_PAR","by");
define("_PASSLOST","Password Lost ?");
define("_CREATE","Create an account");
define("_ENVOYER","Send");
define("_FERMER","Close");
define("_REPONDRE","Reply");
}

if(isset($user)) {
$user2 = base64_decode($user);
$cookie = explode(":", $user2);
if($cookie[9]=="") $cookie[9]=$Default_Theme;
if(isset($theme)) $cookie[9]=$theme;
if(!$file=@opendir("./themes/$cookie[9]")) {
include("./themes/$Default_Theme/theme.php");
echo "<html><head>
\n\n\n";
} else {
include("./themes/$cookie[9]/theme.php");
echo "<html><head><SCRIPT type=\"text/javascript\">
function DoSmilie(addSmilie) {
var addSmilie;
var revisedMessage;
var currentMessage = document.coolsus.msg_text.value;
revisedMessage = currentMessage+addSmilie;
document.coolsus.msg_text.value=revisedMessage;
document.coolsus.msg_text.focus();
return;
}

function x() {
return;
}
function IM2(IM2) { var MainWindow = window.open (IM2, \"_blank\",\"width=360,height=200,toolbar=no,location=no,menubar=no,scrollbars=yes,resizeable=no,status=no\");}
</script>\n\n\n";
}
} else {
include("./themes/$Default_Theme/theme.php");

echo "<html><head><title>Messenger</title>";
echo "<LINK REL=\"StyleSheet\" HREF=\"themes/$cookie[9]/style/style.css\" TYPE=\"text/css\">\n\n\n";
echo "<body bgcolor=$bgcolor1 text=\"$textcolor1\" link=\"$textcolor1\" vlink=\"$textcolor1\" alink=\"$textcolor1\" >\n";
echo "<form action=\"modules.php?name=Your_Account\" method=\"post\" target=\"_top\">";
echo "<center><font size=\"1\" face=\"Arial, Helvetica, sans-serif\">"._NICKNAME."</font><br>";
echo "<input type=\"text\" name=\"uname\" size=\"10\" maxlength=\"25\"><br>";
echo "<font size=\"1\" face=\"Arial, Helvetica, sans-serif\">"._PASSWORD."</font><br>";
echo "<input type=\"password\" name=\"pass\" size=\"10\" maxlength=\"20\"><br>";
echo "<input type=\"hidden\" name=\"op\" value=\"login\">";
echo "<input type=\"submit\" value=\""._LOGIN."\">";
echo "<br><font size=\"1\" face=\"Arial, Helvetica, sans-serif\"><a href=\"modules.php?name=Your_Account&op=new_user\" target=\"_top\">"._CREATE."</a><br>
<a href=\"modules.php?name=Your_Account&op=pass_lost\" target=\"_top\">"._PASSLOST."</a>

</font><br>";
// let my link for modifications that i did (mini-coyright)
// there is only here it will see
echo "<br><font size=\"1\" face=\"Arial, Helvetica, sans-serif\">Mod "._PAR." <a href=\"http://www.surf4all.net\">Surf</a></font></center></form></body></html>\n";
exit;
}

function buddylist() {
global $cookie,$refreshtime, $sitename, $bgcolor1, $textcolor1,$timerefresh, $textcolor2, $prefix;

$sql = mysql_query("SELECT * FROM $prefix"._priv_msgs." WHERE to_userid = '$cookie[0]' AND read_msg='0'");

echo "<title>Messenger</title>";

if ($row = mysql_num_rows($sql)) {

while ($msgs = mysql_fetch_array($sql)) {

echo "<SCRIPT LANGUAGE=\"JavaScript\">\n
var telwin = null;\n
telwin = open('BlockMessenger.php?op=buddyread&msg_id=$msgs[msg_id]', '$priv_msg[msg_time]', 'toolbars=0, scrollbars=1, location=0, statusbars=0, menubars=0, resizable=0, width=360, height=200');\n
</SCRIPT>\n\n";
}
}
echo "<script language=\"javascript\">\nfunction IM(IM) { var MainWindow = window.open (IM, \"_blank\",\"width=400,height=240,toolbar=no,location=no,menubar=no,scrollbars=no,resizeable=no,status=no\");}\n
</script>
<style type=\"text/css\">
BODY {scrollbar-face-color: $bgcolor1;scrollbar-highlight-color: #336699;scrollbar-shadow-color: #16397F;scrollbar-3dlight-color: #CFD8EB;scrollbar-arrow-color: #FF9C00;scrollbar-track-color: $bgcolor1;scrollbar-darkshadow-color: #124601}
</style>
</head>";

// echo "<meta http-equiv=\"refresh\" content=\"7;URL=BlockMessenger.php\">";

echo "<body onload=setInterval('self.location.reload()',$refreshtime) bgcolor=$bgcolor1 text=$textcolor1 link=$textcolor1 alink=\"$textcolor1\" vlink=$textcolor1 topmargin=\"0\" marginheight=\"0\">";
echo "<font size=\"1\" face=\"Arial, Helvetica, sans-serif\">"._ENLIGNE.":</font><br>";
$sql = mysql_query("SELECT username FROM $prefix"._session." where guest=0");
$member_online_num = mysql_num_rows($sql);
$i = 1;
while ($session = mysql_fetch_array($sql)) {
if ($i == $member_online_num) {
$who_online .= "<A href=\"javascript:IM2('BlockMessenger.php?op=infos&to=$session[username]')\">?</a><font size=\"1\" face=\"Arial, Helvetica, sans-serif\">& </font><A href=\"javascript:IM2('BlockMessenger.php?op=compose&to=$session[username]')\">$session[username]</a><br>";
$result = mysql_query("SELECT uid, uname FROM $prefix"._users."");
} else {
$who_online .= "<A href=\"javascript:IM2('BlockMessenger.php?op=infos&to=$session[username]')\">?</a><font size=\"1\" face=\"Arial, Helvetica, sans-serif\">& </font><A href=\"javascript:IM2('BlockMessenger.php?op=compose&to=$session[username]')\">$session[username]</a><br>";
$result = mysql_query("SELECT uid, uname FROM $prefix"._users."");
}
}
$i++;
echo "<font size=\"1\" face=\"Arial, Helvetica, sans-serif\">$who_online</font>";
echo "<br><center><a href=BlockMessenger.php?op=allusers&alpha=A><font size=\"1\" face=\"Arial, Helvetica, sans-serif\">"._TOUSLESMEMBRES.".</font></a>
</center>";

echo "</body></html>";
exit;
}

function allusers() {
global $cookie, $sitename, $bgcolor1, $textcolor1, $textcolor2, $prefix, $alpha;
if (!isset($alpha)) { $alpha = "A"; }
$sql = mysql_query("SELECT * FROM $prefix"._priv_msgs." WHERE to_userid = '$cookie[0]' AND read_msg='0'");
echo "<title>Messenger</title>";
if ($row = mysql_num_rows($sql)) {
while ($msgs = mysql_fetch_array($sql)) {
echo "<SCRIPT LANGUAGE=\"JavaScript\">\n
var telwin = null;\n
telwin = open('BlockMessenger.php?op=buddyread&msg_id=$msgs[msg_id]', '$priv_msg[msg_time]', 'toolbars=0, scrollbars=1, location=0, statusbars=0, menubars=0, resizable=0, width=360, height=200');\n
</SCRIPT>\n\n";
}
}

echo "<script language=\"javascript\">\nfunction IM(IM) { var MainWindow = window.open (IM, \"_blank\",\"width=400,height=240,toolbar=no,location=no,menubar=no,scrollbars=no,resizeable=no,status=no\");}
</script>
<style type=\"text/css\">
BODY {scrollbar-face-color: $bgcolor1;scrollbar-highlight-color: #336699;scrollbar-shadow-color: #16397F;scrollbar-3dlight-color: #CFD8EB;scrollbar-arrow-color: #FF9C00;scrollbar-track-color: $bgcolor1;scrollbar-darkshadow-color: #124601}
form {margin: 0px;}
</style></head>

<body bgcolor=$bgcolor1 text=$textcolor1 link=$textcolor1 alink=$textcolor1 vlink=$textcolor1 topmargin=\"0\" marginheight=\"0\">";
echo "<center><font size=\"1\" face=\"Arial, Helvetica, sans-serif\"><a href=BlockMessenger.php>"._VOIRQUIESTENLIGNE."</a></center>";
echo "<form action=\"BlockMessenger.php\" method=\"get\">\n";
echo "<font size=\"1\" face=\"Arial, Helvetica, sans-serif\">"._COMMENCANTPAR.":</font>";
echo "<input type=\"hidden\" name=\"op\" value=\"allusers\">";
echo "<select name=\"alpha\"onChange='submit()'>";
echo "<option value=\"$alpha\">$alpha</option>\n";
echo "<option value=\"A\">A</option>\n";
echo "<option value=\"B\">B</option>\n";
echo "<option value=\"C\">C</option>\n";
echo "<option value=\"D\">D</option>\n";
echo "<option value=\"E\">E</option>\n";
echo "<option value=\"F\">F</option>\n";
echo "<option value=\"G\">G</option>\n";
echo "<option value=\"H\">H</option>\n";
echo "<option value=\"I\">I</option>\n";
echo "<option value=\"J\">J</option>\n";
echo "<option value=\"K\">K</option>\n";
echo "<option value=\"L\">L</option>\n";
echo "<option value=\"M\">M</option>\n";
echo "<option value=\"N\">N</option>\n";
echo "<option value=\"O\">O</option>\n";
echo "<option value=\"P\">P</option>\n";
echo "<option value=\"Q\">Q</option>\n";
echo "<option value=\"R\">R</option>\n";
echo "<option value=\"S\">S</option>\n";
echo "<option value=\"T\">T</option>\n";
echo "<option value=\"U\">U</option>\n";
echo "<option value=\"V\">V</option>\n";
echo "<option value=\"W\">W</option>\n";
echo "<option value=\"X\">X</option>\n";
echo "<option value=\"Y\">Y</option>\n";
echo "<option value=\"Z\">Z</option>\n";
echo "<option value=\"*\">*</option>\n";
echo "</select>\n";
echo "</p></form>";
if ($alpha=="*") {
$sql = mysql_query("SELECT uname FROM $prefix"._users." where uname REGEXP \"^\[1-9]\" order by uname");
} else {
$sql = mysql_query("SELECT uname FROM $prefix"._users." where uname like '".$alpha."%' order by uname");
}
$member_num = mysql_num_rows($sql);
$i = 1;
while ($userlist = mysql_fetch_array($sql)) {
if ($i == $member_num) {
$who .= "<A href=\"javascript:IM2('BlockMessenger.php?op=infos&to=$userlist[uname]')\">?</a><font color=\"$textcolor1\" size=\"1\" face=\"Arial, Helvetica, sans-serif\">& </font><A href=\"javascript:IM2('BlockMessenger.php?op=compose&to=$userlist[uname]')\">$userlist[uname]</a><br>";
$result = mysql_query("SELECT uid, uname FROM $prefix"._users."");
} else {
$who .= "<A href=\"javascript:IM2('BlockMessenger.php?op=infos&to=$userlist[uname]')\">?</a><font color=\"$textcolor1\" size=\"1\" face=\"Arial, Helvetica, sans-serif\">& </font><A href=\"javascript:IM2('BlockMessenger.php?op=compose&to=$userlist[uname]')\">$userlist[uname]</a><br>";
$result = mysql_query("SELECT uid, uname FROM $prefix"._users."");
}
}
$i++;
echo "<p align=left class=tiny>$who</p>";
echo "<p class=normal><a href=BlockMessenger.php>"._VOIRQUIESTENLIGNE."</a></p>";
exit;
}

function compose($to, $subject,$delete, $prev_msg) {
global $sitename, $bgcolor1, $textcolor1, $textcolor2, $prefix, $prev_msg;
$res = mysql_query("SELECT uid, uname FROM $prefix"._users." WHERE uname='$to'");
$to_user = mysql_fetch_array($res);
$to_userid = $to_user[uid];
echo "<title>"._ENVOYERUNMSG."</title><style type=\"text/css\">
BODY {scrollbar-face-color: $bgcolor1;scrollbar-highlight-color: #336699;scrollbar-shadow-color: #16397F;scrollbar-3dlight-color: #CFD8EB;scrollbar-arrow-color: #FF9C00;scrollbar-track-color: $bgcolor1;scrollbar-darkshadow-color: #124601}
form {margin: 0px;}
</style></head>
<body bgcolor=$bgcolor1 text=$textcolor1 link=$textcolor1 alink=$textcolor1 vlink=$textcolor1 topmargin=\"2\" marginheight=\"2\" leftmargin=\"2\" marginwidth=\"2\">";
if ($delete=='1')
{
$res2 = mysql_query("DELETE FROM nuke_priv_msgs WHERE msg_id='$prev_msg'");
};

echo "<center>"._ENVOYERUNMSG." "._A." $to - <A href=\"javascript:IM2('BlockMessenger.php?op=infos&to=$to')\">"._INFOS."</a><br>

<FORM METHOD=POST ACTION=\"BlockMessenger.php\" NAME=\"coolsus\" TARGET=_self>";
?>

<input type=hidden name=to_userid value="<? echo "$to_userid"; ?>"><input type=hidden name=subject value="messenger">
<br><textarea name=msg_text wrap=VIRTUAL cols=30 rows=5 style="FONT-SIZE: 11px; COLOR: $textcolor1"></textarea><br>
<?
global $dbi;
$result2 = sql_query("select user_avatar from nuke_users where uname='$to'", $dbi);
$userinfo2 = sql_fetch_array($result2, $dbi);
?>

<A href="javascript: x()" onClick="DoSmilie(' :-D ');"><IMG src="images/forum/smilies/icon_biggrin.gif" border="0" alt=":-D"></A>&&<A href="javascript: x()" onClick="DoSmilie(' :-) ');"><IMG src="images/forum/smilies/icon_smile.gif" border="0" alt=":-)"></A>&&<A href="javascript: x()" onClick="DoSmilie(' :-( ');"><IMG src="images/forum/smilies/icon_frown.gif" border="0" alt=":-("></A>&&<A href="javascript: x()" onClick="DoSmilie(' :-o ');"><IMG src="images/forum/smilies/icon_eek.gif" border="0" alt=":-o"></A>&&<A href="javascript: x()" onClick="DoSmilie(' :-? ');"><IMG src="images/forum/smilies/icon_confused.gif" border="0" alt=":-?"></A>&&<A href="javascript: x()" onClick="DoSmilie(' 8-) ');"><IMG src="images/forum/smilies/icon_cool.gif" border="0" alt="8-)"></A>&&<A href="javascript: x()" onClick="DoSmilie(' :lol: ');"><IMG src="images/forum/smilies/icon_lol.gif" border="0" alt=":lol:"></A>&&<A href="javascript: x()" onClick="DoSmilie(' :-x ');"><IMG src="images/forum/smilies/icon_mad.gif" border="0" alt=":-x"></A>&&<A href="javascript: x()" onClick="DoSmilie(' :-P ');"><IMG src="images/forum/smilies/icon_razz.gif" border="0" alt=":-P"></A>&&<A href="javascript: x()" onClick="DoSmilie(' :oops: ');"><IMG src="images/forum/smilies/icon_redface.gif" border="0" alt=":oops:"></A>&&<A href="javascript: x()" onClick="DoSmilie(' :cry: ');"><IMG src="images/forum/smilies/icon_cry.gif" border="0" alt=":cry:"></A>&&<A href="javascript: x()" onClick="DoSmilie(' :evil: ');"><IMG src="images/forum/smilies/icon_evil.gif" border="0" alt=":evil:"></A>&&<A href="javascript: x()" onClick="DoSmilie(' :roll: ');"><IMG src="images/forum/smilies/icon_rolleyes.gif" border="0" alt=":roll:"></A>&&<A href="javascript: x()" onClick="DoSmilie(' ;-) ');"><IMG src="images/forum/smilies/icon_wink.gif" border="0" alt=";-)"></A>
<input type=HIDDEN name="op" value="buddysend">
<input type=HIDDEN name="to" alt="" value="<? echo "$to"; ?>">
<br><a href=# onClick='window.close()'><img src="images/buddy-block/<?php echo ""._BTFERMER.""; ?>" border=0 width="51" alt="<?php echo ""._FERMER.""; ?>" height="13"></a>&&
<a href=#><input type=image alt="<?php echo ""._ENVOYER.""; ?>" src="images/buddy-block/<?php echo ""._BTENVOYER.""; ?>" border=0 width="51" height="13"></a>
</form>
</center>

<?php

?>

</body>
</html>
<?
exit;
}

function buddysend($to, $to_userid, $msg_text, $subject) {
global $cookie, $cookie, $sitename, $bgcolor1, $textcolor1, $textcolor2, $prefix;
$msg_text = bbencode($msg_text, 1);
$msg_text = str_replace("\n", "<BR>", $msg_text);
$msg_text = smile($msg_text);
$msg_text = make_clickable($msg_text);
$subject = strip_tags($subject);
$time = date("d/m/Y à G:i");
$subject = addslashes($subject);
$msg_text = addslashes($msg_text);
$sql = "INSERT INTO $prefix"._priv_msgs." (msg_image, subject, from_userid, to_userid, msg_time, msg_text) ";
$sql .= "VALUES ('icon1.gif', '$subject', '$cookie[0]', '$to_userid', '$time', '$msg_text')";
mysql_query($sql);
echo "<title>"._MSGENVOYE."!</title>\n";
?>

</head>
<?php
echo "<body bgcolor=$bgcolor1 text=$textcolor1 link=$textcolor1 alink=$textcolor1 vlink=$textcolor1 topmargin=\"0\" marginheight=\"0\" onLoad=\"self.close()\">\n";

echo "<center>"._MSGENVOYE." "._A." $to
<br><br>
"._ENVOYE." !
<br><br><a href=# onClick='window.close()'><img src=\"images/buddy-block/"._BTFERMER."\" border=0 width=\"51\" height=\"13\">
</a></center>

Thats the whole code.

Premium Joined: Jan 26, 2003 Posts: 230 Location: USA

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/home/raver/www/htdocs/BlockMessenger.php on line 196

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/raver/www/htdocs/BlockMessenger.php on line 198

Is the error

Posted: Wed Feb 26, 2003 10:31 am

If i recall correctly from some of your other posts, you have nuke 6.5 installed, this block seems to be for nuke 6.0 as it uses fields like uid and uname which don't exist in nuke 6.5 and also the old privmsgs table which doesn't exist either.

Premium Joined: Jan 26, 2003 Posts: 230 Location: USA

So can you be so kind to help me what I need to replace to make it work for 6.5 RC 1.

Thanks

Joined: Jan 31, 2004 Posts: -88

in the global lines, make sure $db and $prefix are both called.

Then, change all

mysql_fetch_row to $db->sql_fetchrow
mysql_fetch_array to $db->sql_fetchrow
mysql_num_rows to $db->sql_numrows
mysql_query to $db->sql_query

and any $dbi just get rid of and the commer b4 them

ArtificialIntel