diff options
| author | Patrick Davison <snapwilliam@gmail.com> | 2013-03-24 13:58:26 -0700 |
|---|---|---|
| committer | Patrick Davison <snapwilliam@gmail.com> | 2013-03-24 13:58:26 -0700 |
| commit | a9dcb92d783a77b493d865c655244bb8e5d54a41 (patch) | |
| tree | b1371aa5b5e87c76b7e8676237624134e3827714 | |
| parent | 41acac169cf71b9912a20ffe336dc685b221d74c (diff) | |
| download | pathery-a9dcb92d783a77b493d865c655244bb8e5d54a41.tar.xz | |
Missing wallOrientation SQL. Changed back to 25 per-notification.
| -rw-r--r-- | db updates.sql | 4 | ||||
| -rw-r--r-- | includes/datas.php | 2 |
2 files changed, 4 insertions, 2 deletions
diff --git a/db updates.sql b/db updates.sql index f472392..5afd88f 100644 --- a/db updates.sql +++ b/db updates.sql @@ -247,4 +247,6 @@ DROP INDEX `mapID` , ADD UNIQUE `mapID` ( `mapID` , `ordering` ); -- Optimizing the daily update queries -ALTER TABLE `solutions` ADD INDEX ( `isHighScore` )
\ No newline at end of file +ALTER TABLE `solutions` ADD INDEX ( `isHighScore` ) + +ALTER TABLE `users` ADD `wallOrientation` TINYINT NOT NULL DEFAULT '0' AFTER `wallEmblem`
\ No newline at end of file diff --git a/includes/datas.php b/includes/datas.php index 4d42c1a..934c1d7 100644 --- a/includes/datas.php +++ b/includes/datas.php @@ -18,7 +18,7 @@ function getNotified($userID) { FROM `achievements` WHERE `notified` = false AND userID = '$userID' - LIMIT 5"; + LIMIT 25"; $resultA = mysql_query($sql); if (mysql_num_rows($resultA) <= 0) return false; |