Are you the admin on this board? That SQL error only shows if you are not the admin...
Look for:
<br />// Show IPs on user profile screen for Admins and Mods - CB added 2/28/03<br /> $query = "<br /> SELECT O_CurrentIP<br /> FROM {$config['tbprefix']}Online<br /> WHERE O_Uid = '$UNumber'<br /> ";<br /><br /> $stj = $dbh -> do_query($query);<br /> list($curIP) = $dbh -> fetch_array($stj);<br /><br /> if (($thisuser['U_Status'] == "Administrator") || ($thisuser['U_Status'] == "Moderator")) {<br /> $IPInfo = "<br /> <tr><br /> <td valign=\"top\" class=\"darktable\">Reged IP</td><br /> <td>$RegIP</td><br /> </tr><br /> <tr><br /> <td valign=\"top\" class=\"darktable\">Current IP</td><br /> <td>$curIP</td><br /> </tr><br /> ";<br /> }<br /><br />---------------------------------------------------------------------<br />in your showprofile.php... this stuff relys on another mod, and I didn't realize it was in there.
Make it look like this:
<br />// Show IPs on user profile screen for Admins and Mods - CB added 2/28/03<br /> if (($thisuser['U_Status'] == "Administrator") || ($thisuser['U_Status'] == "Moderator")) {<br /> $IPInfo = "<br /> <tr><br /> <td valign=\"top\" class=\"darktable\">Reged IP</td><br /> <td>$RegIP</td><br /> </tr><br /> ";<br /> }<br />---------------------------------------------------------------------<br />You will not see the current IP for logged in users because that requires JustDave's Current IP mod.
Sorry for the hassle... I have been pretty sick lately and haven't been thinking clearly. I will update the attachment.
Cheers,
Chris
