From 7463bffe7ac502d69d132d6b2edac8d8e0ed29bd Mon Sep 17 00:00:00 2001 From: Patrick Davison Date: Sun, 24 Mar 2013 13:58:26 -0700 Subject: Missing wallOrientation SQL. Changed back to 25 per-notification. --- db updates.sql | 4 +++- 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; -- cgit v1.2.3 From 77bdf780635398e65942a017d15610ce64041999 Mon Sep 17 00:00:00 2001 From: BlueRaja Date: Sun, 24 Mar 2013 16:59:17 -0500 Subject: Fixes for DB before releasing to production --- db updates.sql | 7 +++++-- includes/constants.php | 2 +- 2 files changed, 6 insertions(+), 3 deletions(-) diff --git a/db updates.sql b/db updates.sql index 5afd88f..739c6e3 100644 --- a/db updates.sql +++ b/db updates.sql @@ -247,6 +247,9 @@ DROP INDEX `mapID` , ADD UNIQUE `mapID` ( `mapID` , `ordering` ); -- Optimizing the daily update queries -ALTER TABLE `solutions` ADD INDEX ( `isHighScore` ) +ALTER TABLE `solutions` ADD INDEX ( `isHighScore` ); -ALTER TABLE `users` ADD `wallOrientation` TINYINT NOT NULL DEFAULT '0' AFTER `wallEmblem` \ No newline at end of file +ALTER TABLE `users` ADD `wallOrientation` TINYINT NOT NULL DEFAULT '0' AFTER `wallEmblem`; + +ALTER TABLE `solutions` DROP INDEX `userIDmapID` , +ADD UNIQUE `mapIDuserID` ( `mapID` , `userID` ); \ No newline at end of file diff --git a/includes/constants.php b/includes/constants.php index f5dfc20..7b4e1b8 100644 --- a/includes/constants.php +++ b/includes/constants.php @@ -3,7 +3,7 @@ /** * The 'starting date' of pathery, from which we begin recording all statistics (ties, wins, champion points, etc) */ -define('STATS_EARLIEST_DATE', '2011-08-01'); +define('STATS_EARLIEST_DATE', '2012-03-11'); /** * The minimum number of champion points you can get for tying a map, regardless of how many other people tied -- cgit v1.2.3