Codezwiz >> Forums >> Codezwiz BBtoNuke Mods Help >> Rating system Help please

hello i just installed this Rating system and looks like everything is ok but when you click on a users name to go to there profile you get this message

Could not obtain rating information

DEBUG MODE

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 'AND p.post_id = r.post_id LIMIT 1' at line 1

SELECT p.post_id FROM nuke_bbposts p, nuke_bbrating r WHERE p.poster_id = AND p.post_id = r.post_id LIMIT 1

Line : 344
File : /home/stealths/public_html/html/includes/usercp_viewprofile.php

so here is the code they said to add to the usercp_viewprofile.php

define('RATING_PATH', $phpbb_root_path.'mods/rating/');
include (RATING_PATH.'functions_rating.'.$phpEx);
$rating_config = get_rating_config('1');
if ( $rating_config[1] == 1 )
{
// Rated posts by this user
$sql = 'SELECT p.post_id FROM '.POSTS_TABLE.' p, '.RATING_TABLE.' r WHERE p.poster_id = '.$profiledata['user_id'].' AND p.post_id = r.post_id LIMIT 1';
if ( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, 'Could not obtain rating information', '', __LINE__, __FILE__, $sql);
}
if ( $row = $db->sql_fetchrow($result) )
{
   $u_link = append_sid('ratings.'.$phpEx.'?type=p&postedby='.$profiledata['user_id']);
   $l_link = sprintf($lang['Rated_posts_by'], $profiledata['username']);
   $template->assign_block_vars('rating', array(
      "L_LINK" => $l_link,
      "U_LINK" => $u_link
      )
   );
}

// If not anonymous
if ( $profiledata['rating_status'] != 1 )
{
   // Ratings by this user
   $sql = 'SELECT user_id FROM '.RATING_TABLE.' WHERE user_id = '.$profiledata['user_id'].' LIMIT 1';
   if ( !($result = $db->sql_query($sql)) )
   {
      message_die(GENERAL_ERROR, 'Could not obtain rating information', '', __LINE__, __FILE__, $sql);
   }
   if ( $row = $db->sql_fetchrow($result) )
   {
      $u_link = append_sid('ratings.'.$phpEx.'?type=p&ratedby='.$profiledata['user_id']);
      $l_link = sprintf($lang['Ratings_by'], $profiledata['username']);
      $template->assign_block_vars('rating', array(
         "L_LINK" => $l_link,
         "U_LINK" => $u_link
         )
      );
   }
}
}

re-upload your table sql...it may just have been corrupted during the transfer

ok that worked the only thing is i don't see anything to do anything with LOL

have you read what the mod actually does before adding it to your site?

yes it is to let your members vote for topics and post.