# HG changeset patch # User Dan # Date 1213843396 14400 # Node ID 41c45314ac27f796ddbb09973762089b92e7cd10 # Parent 6e23d8a99616ca719c18b85492df716f42f195ba Fixed SQL syntax error thrown during rank data fetch diff -r 6e23d8a99616 -r 41c45314ac27 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; }