diff options
| author | BlueRaja <BlueRaja.admin@gmail.com> | 2013-01-26 03:30:45 -0600 |
|---|---|---|
| committer | BlueRaja <BlueRaja.admin@gmail.com> | 2013-01-26 03:30:45 -0600 |
| commit | d7b0c04459a6ec42a37255c38d67cea14fb60e61 (patch) | |
| tree | 4269be8ec67fa3f4d12932041d3b37fa1f007daf /includes/chats.php | |
| parent | 1e65273d68ffdec07f49c14e929499af21f7776a (diff) | |
| download | pathery-d7b0c04459a6ec42a37255c38d67cea14fb60e61.tar.xz | |
Moved usersData table to users table, added a few more columns to users (currently unused)
Diffstat (limited to 'includes/chats.php')
| -rw-r--r-- | includes/chats.php | 8 |
1 files changed, 3 insertions, 5 deletions
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'
|