Fixed missing table_prefix in generate_rank_sql()
authorDan
Thu, 26 Jun 2008 17:01:42 -0400
changeset 584 04a6ea3da279
parent 583 c97d5f0d6636
child 585 35e91d16ecf5
Fixed missing table_prefix in generate_rank_sql()
includes/sessions.php
--- a/includes/sessions.php	Thu Jun 26 16:56:52 2008 -0400
+++ b/includes/sessions.php	Thu Jun 26 17:01:42 2008 -0400
@@ -2447,19 +2447,19 @@
          . "       ( ru.rank_id IS NULL AND rg.rank_id IS NOT NULL ) AS using_group,"
          . "       $gid_col\n"
          . "  FROM " . table_prefix . "users AS u\n"
-         . "  LEFT JOIN groups AS g\n"
+         . "  LEFT JOIN " . table_prefix . "groups AS g\n"
          . "    ON ( g.group_id = u.user_group )\n"
          . "  LEFT JOIN " . table_prefix . "group_members AS m\n"
          . "    ON ( u.user_id = m.user_id )\n"
-         . "  LEFT JOIN ranks AS ru\n"
+         . "  LEFT JOIN " . table_prefix . "ranks AS ru\n"
          . "    ON ( u.user_rank = ru.rank_id )\n"
-         . "  LEFT JOIN ranks AS rg\n"
+         . "  LEFT JOIN " . table_prefix . "ranks AS rg\n"
          . "    ON ( g.group_rank = rg.rank_id )\n"
-         . "  LEFT JOIN ranks AS rl\n"
+         . "  LEFT JOIN " . table_prefix . "ranks AS rl\n"
          . "    ON (\n"
          . $assoc
          . "      )\n"
-         . "  LEFT JOIN ranks AS rd\n"
+         . "  LEFT JOIN " . table_prefix . "ranks AS rd\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"