Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> CZforum blocks mod

Register

Great addition..but I'm having a conflict with the buddies mod when you click on a members name in the block.

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

SELECT buddy_id FROM nuke_bbbuddies WHERE user_id = 8 AND buddy_id =

Line : 269
File : /home/virtual/site44/fst/var/www/html/one/phpnuke/includes/usercp_viewprofile.php

All other username links on the site work fine.

Register

I've only just found this error myself m8.

The install file is incorrect.

Several instances of $uid and $username required changing in index.php
This is the updated code required after

//
// Generate the page
//
$template->pparse('body');

// Begin Latest Members
global $prefix;
// How Many to display
$tdsize = 20;
$members = 5;
$query="SELECT username, theme, user_from, user_regdate, user_id from $prefix"._users." ORDER BY user_id DESC LIMIT $members";
$result=mysql_query($query);
while(list($username, $theme, $user_from, $user_regdate, $user_id) = mysql_fetch_row($result)) {

   if ($theme == "") {
      $theme = "Default";
      }
   if ($user_from == "") {
      $user_from = "N/A";
      }
$ShowLatest .="<td width=\"$tdsize%\" class=\"row1\"><font class=\"content\"><A HREF=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$user_id\">$username</a><br>Theme: <b>$theme</b><br>Joined: <b>$user_regdate</b><br>Location: <b>$user_from</b></font></td>";
}
echo "<hr width=\"100%\" noShade><br><table border=\"1\" cellspacing=\"2\" width=\"100%\" class=\"forumline\"><tr><td class=\"cat\" colspan=\"2\">$members Latest Members</font></td></tr></table>";
echo "<table border=\"1\" cellspacing=\"1\" cellpadding=\"5\" width=\"100%\" class=\"forumline\" align=\"center\"><tr>";
echo "$ShowLatest";
echo "</tr></table><br />";
// End Latest Members
// Begin Top Posters
global $user_prefix, $dbi;
$tdsize = 20;
$members = 5;
$result=sql_query("SELECT user_id, username, user_posts, user_avatar FROM ".$user_prefix."_users ORDER BY user_posts DESC LIMIT 0,$members", $dbi);
while(list($user_id, $username, $user_posts, $user_avatar) = sql_fetch_row($result, $dbi)) {
if ( ereg( "(http://)", $user_avatar) )
{
$avatar2 = "<img src=\"$user_avatar\" border=\"0\" vspace=\"10\" hspace=\"10\" width=\"48\" align=\"left\">";
} else {
$avatar = $user_avatar;
$avatar2 = "<img src=\"modules/Forums/images/avatars/$avatar\" border=\"0\" vspace=\"10\" hspace=\"10\" width=\"48\" align=\"left\">";
}
if ($avatar2 == "<img src=\"modules/Forums/images/avatars/") {
$avatar2 = "";
}
if ( empty($user_avatar) )

{
}
$Topposters .="<td width=\"$tdsize%\" class=\"row1\"><font class=\"content\"><a href=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$user_id\">$avatar2</a><br><a href=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$user_id\">$username</a><br>Posts: <a href=\"modules.php?name=Forums&file=search&search_author=$user_id\">$user_posts</a></font></td>";
}
echo "<hr width='95%' noShade><br><table border=\"1\" cellspacing=\"2\" width=\"100%\" class=\"forumline\"><tr><td class=\"cat\" colspan=\"2\">Top 5 Posters</font></td></tr></table>";
echo "<table border=\"1\" cellspacing=\"1\" cellpadding=\"5\" width=\"100%\" class=\"forumline\" align=\"center\"><tr>";
echo "$Topposters";
echo "</tr></table>";
/*Copyright notice - Do not remove*/
echo "<div align=\"right\"><small>";
echo "<a href=\"http://codezwiz.com\">Forum Blocks ©</a></small><br></div>";
/*Copyright notice - Do not remove*/
// End Top Posters

Register

You are correct sir

I found that as well a few weeks ago but moved across the country and I'm just now getting back into straightening up this moving mess and didn't have time to post back that I had fixed my site...thanks for posting the fix for everyone!!

Must have been a problem with uid or username. The list method lists what you pull from the database regardless of the field name. Some other mod or hack using uid will cause problems. The original mod is just fine but if you have other mods installed this method will work. Thanks for posting.

Register

Ah.... thanks for that Telli, I could of sworn it was working a while ago. Thought I was going mad.

Register

One more edit needs to be made to the above code

Find
search_author=$user_id\">$user_posts

Replace with
search_author=$username\">$user_posts

This makes the post count number search link work right