From cc1d8051f5eb7a53cbf9e11773f23e650ce88c5d Mon Sep 17 00:00:00 2001 From: BlueRaja Date: Mon, 27 May 2013 22:32:26 -0500 Subject: Added index to increase speed of stats updating --- db updates.sql | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/db updates.sql b/db updates.sql index d248ef2..9a20ade 100644 --- a/db updates.sql +++ b/db updates.sql @@ -3,4 +3,8 @@ --Dialog to challenges: ALTER TABLE `challenges` ADD `dialogStart` VARCHAR( 200 ) DEFAULT NULL , ADD `dialogFail` VARCHAR( 200 ) DEFAULT NULL , -ADD `dialogSuccess` VARCHAR( 200 ) DEFAULT NULL ; \ No newline at end of file +ADD `dialogSuccess` VARCHAR( 200 ) DEFAULT NULL ; + +-- Add index necessary for stats updates +ALTER TABLE `bluePathery`.`solutions` +ADD INDEX `mapIDMoves` ( `mapID` , `moves` ) \ No newline at end of file -- cgit v1.2.3 From 77b0bd5e51aeefb0d09e7a5bcab633657f299d22 Mon Sep 17 00:00:00 2001 From: BlueRaja Date: Tue, 28 May 2013 01:53:27 -0500 Subject: Fixed bug causing SQLi errors after user has been logged in for 30 minutes --- globe.php | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/globe.php b/globe.php index 526d306..dd9902d 100644 --- a/globe.php +++ b/globe.php @@ -4,7 +4,7 @@ if (!session_id()) session_start(); //session_regenerate_id(); -include_once('includes/db.inc.php'); +include_once "includes/sqlEmbedded.php"; function LogError($error) { @@ -69,7 +69,6 @@ function sql_clean($string) { function CookieLogin() { global $accepted, $mydomain; - include_once "includes/sqlEmbedded.php"; $userID = $_COOKIE['userID']; $auth = $_COOKIE['auth']; -- cgit v1.2.3