2458 . " LEFT JOIN ranks AS rl\n" |
2458 . " LEFT JOIN ranks AS rl\n" |
2459 . " ON (\n" |
2459 . " ON (\n" |
2460 . $assoc |
2460 . $assoc |
2461 . " )\n" |
2461 . " )\n" |
2462 . " LEFT JOIN ranks AS rd\n" |
2462 . " LEFT JOIN ranks AS rd\n" |
2463 . " ON ( rd.rank_id = 1 )\n" |
2463 . " ON ( rd.rank_id = 1 )$append\n" |
2464 . " GROUP BY u.user_id, u.username, u.user_level, u.user_group, u.user_rank, u.user_title, g.group_rank,\n" |
2464 . " GROUP BY u.user_id, u.username, u.user_level, u.user_group, u.user_rank, u.user_title, g.group_rank,\n" |
2465 . " ru.rank_id, ru.rank_title, ru.rank_style,rg.rank_id, rg.rank_title, rg.rank_style,\n" |
2465 . " ru.rank_id, ru.rank_title, ru.rank_style,rg.rank_id, rg.rank_title, rg.rank_style,\n" |
2466 . " rl.rank_id, rl.rank_title, rl.rank_style,rd.rank_id, rd.rank_title, rd.rank_style$append;"; |
2466 . " rl.rank_id, rl.rank_title, rl.rank_style,rd.rank_id, rd.rank_title, rd.rank_style;"; |
2467 |
2467 |
2468 return $sql; |
2468 return $sql; |
2469 } |
2469 } |
2470 |
2470 |
2471 /** |
2471 /** |