Fixed SQL syntax error thrown during rank data fetch
authorDan
Wed, 18 Jun 2008 22:43:16 -0400
changeset 580 41c45314ac27
parent 579 6e23d8a99616
child 581 5e8fd89c02ea
Fixed SQL syntax error thrown during rank data fetch
includes/sessions.php
--- a/includes/sessions.php	Mon Jun 16 19:20:13 2008 -0400
+++ b/includes/sessions.php	Wed Jun 18 22:43:16 2008 -0400
@@ -2460,10 +2460,10 @@
          . $assoc
          . "      )\n"
          . "  LEFT JOIN ranks AS rd\n"
-         . "    ON ( rd.rank_id = 1 )\n"
+         . "    ON ( rd.rank_id = 1 )$append\n"
          . "  GROUP BY u.user_id, u.username, u.user_level, u.user_group, u.user_rank, u.user_title, g.group_rank,\n"
          . "       ru.rank_id, ru.rank_title, ru.rank_style,rg.rank_id, rg.rank_title, rg.rank_style,\n"
-         . "       rl.rank_id, rl.rank_title, rl.rank_style,rd.rank_id, rd.rank_title, rd.rank_style$append;";
+         . "       rl.rank_id, rl.rank_title, rl.rank_style,rd.rank_id, rd.rank_title, rd.rank_style;";
     
     return $sql;
   }