From d7b0c04459a6ec42a37255c38d67cea14fb60e61 Mon Sep 17 00:00:00 2001 From: BlueRaja Date: Sat, 26 Jan 2013 03:30:45 -0600 Subject: Moved usersData table to users table, added a few more columns to users (currently unused) --- includes/chats.php | 8 +++----- 1 file changed, 3 insertions(+), 5 deletions(-) (limited to 'includes/chats.php') diff --git a/includes/chats.php b/includes/chats.php index 56c88d1..4ecf6ce 100644 --- a/includes/chats.php +++ b/includes/chats.php @@ -37,12 +37,10 @@ function getChat($startID = 0) { SELECT chat.ID, chat.userID, chat.message, chat.dateSent, users.displayName, - userData.displayColor, - userData.wallColor, - userData.wallEmblem + users.displayColor, + users.wallColor, + users.wallEmblem FROM `chat` - LEFT JOIN `userData` - ON chat.userID = userData.userID LEFT JOIN `users` ON chat.userID = users.ID WHERE chat.ID > '$startID' -- cgit v1.2.3