Menu

#18 Multiple Guilds not Working

open
nobody
None
5
2005-02-23
2005-02-23
Anonymous
No

My guild is spread out on two different servers due to
lag concerns. While both servers have different guild
names, we share the same website and so thus we
noticed this problem.

In the membersList.php file the query:
$query = "SELECT members.name, members.class,
members.level, members.note, members.guild_rank,
members.guild_title, " .

"DATE_FORMAT(members.last_online, '%b %d %l%p')
AS last_online, players.server, members.guild_id ".

" FROM `members` LEFT JOIN `players` ON
members.member_id = players.member_id AND
members.guild_id = $guildId";

is the culprit. By changing the AND at the end to
WHERE we were able to not have both guild rosters be
displayed at once.

Just thought I'd point this out...

Discussion


Log in to post a comment.