summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--db updates.sql4
-rw-r--r--includes/datas.php2
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;