Problem po instlacji plusminus w pliku viewtopic.php

 

Strona 1 z 1 [ 3 posty(ów) ]

Widok do druku | « Poprzedni temat | Następny temat »

Temat

• Wysłany: 11 Maj 2007, 21:31

  Black Qur

  

  
  Rejestracja: 14 Mar 2006, 07:56
  Posty: 146
  Pochwały: 1
  Witam!
  Kolejna przeszkoda na drodze do sławy..
  Instalowałem dziś Plusminus i coś dzienie nie wszystko pasowało, gdy skończyłem i chce otworzyc temat pokazuje się to:
  
  

  Kod:

  Could not obtain post/user 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 'LEFT JOIN phpbb_banlist b ON u.user_id=b.ban_userid)phpbb_users u, phpbb_posts_t' at line 2
  
  SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, ( LEFT JOIN phpbb_banlist b ON u.user_id=b.ban_userid)phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 4 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
  
  Line : 394
  File : viewtopic.php

  
  
  Instalowałem dotąd Spider Firendly, Color Ranks i teraz przy Plusminus się skrzaniło....
  
  Macie kod plusminus, znaczy linijki 381 - 410 proszę o pomoc
  
  

  Kod:

  //
  // Go ahead and pull all data for this topic
  //
  $sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id, p.*,  pt.post_text, pt.post_subject, pt.bbcode_uid
     FROM " . POSTS_TABLE . " p, ( LEFT JOIN ".BANLIST_TABLE." b ON u.user_id=b.ban_userid)" . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt
     WHERE p.topic_id = $topic_id
        $limit_posts_time
        AND pt.post_id = p.post_id
        AND u.user_id = p.poster_id
     ORDER BY p.post_time $post_time_order
     LIMIT $start, ".$board_config['posts_per_page'];
  if ( !($result = $db->sql_query($sql)) )
  {
     message_die(GENERAL_ERROR, "Could not obtain post/user information.", '', __LINE__, __FILE__, $sql);
  }
  
  $postrow = array();
  if ($row = $db->sql_fetchrow($result))
  {
     do
     {
        $postrow[] = $row;
     }
     while ($row = $db->sql_fetchrow($result));
     $db->sql_freeresult($result);
  
     $total_posts = count($postrow);
  }
  else
  {

  

Odpowiedzi

• Wysłany: 11 Maj 2007, 22:15

  kiziu

  

  

  
  Rejestracja: 31 Sie 2005, 20:27
  Posty: 2042
  Miejscowość: Niezdara
  Pochwały: 293
  Black Qur napisał(a):

  $sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid
  FROM " . POSTS_TABLE . " p, ( LEFT JOIN ".BANLIST_TABLE." b ON u.user_id=b.ban_userid)" . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt
  WHERE p.topic_id = $topic_id
  $limit_posts_time
  AND pt.post_id = p.post_id
  AND u.user_id = p.poster_id
  ORDER BY p.post_time $post_time_order
  LIMIT $start, ".$board_config['posts_per_page'];

  
  zamien na :
  

  Kod:

  $sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id, p.*,  pt.post_text, pt.post_subject, pt.bbcode_uid
     FROM " . POSTS_TABLE . " p, (" . USERS_TABLE . " u  LEFT JOIN ".BANLIST_TABLE." b ON u.user_id=b.ban_userid), " . POSTS_TEXT_TABLE . " pt
     WHERE p.topic_id = $topic_id
        $limit_posts_time
        AND pt.post_id = p.post_id
        AND u.user_id = p.poster_id
     ORDER BY p.post_time $post_time_order
     LIMIT $start, ".$board_config['posts_per_page'];

  Autor postu otrzymał pochwałę

  ---

  Daj biedakowi rybę, a zje ją i będzie głodny. Daj biedakowi wędkę, a sam sobie bedzie łowił ryby!

  

• Wysłany: 11 Maj 2007, 22:20

  Black Qur

  

  
  Rejestracja: 14 Mar 2006, 07:56
  Posty: 146
  Pochwały: 1
  Dziękuje plus dla ciebie, temat do zamknięcia

  

 

Strona 1 z 1 [ 3 posty(ów) ]