From 48e4f8df9b1171bb93cc50a7f1f42148e3118026 Mon Sep 17 00:00:00 2001 From: raylu Date: Fri, 9 Sep 2011 23:39:07 -0700 Subject: use InnoDB and utf8 --- changelog/datascheme.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/changelog/datascheme.sql b/changelog/datascheme.sql index bb00b23..7e88d91 100644 --- a/changelog/datascheme.sql +++ b/changelog/datascheme.sql @@ -31,7 +31,7 @@ CREATE TABLE `mapOfTheDay` ( `mapType` tinyint(4) NOT NULL, `mapDate` date NOT NULL, PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- @@ -44,7 +44,7 @@ CREATE TABLE `maps` ( `code` varchar(512) collate latin1_general_ci NOT NULL, `dateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- @@ -61,7 +61,7 @@ CREATE TABLE `solutions` ( `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`ID`), KEY `userID` (`userID`,`mapID`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- @@ -79,4 +79,4 @@ CREATE TABLE `users` ( `isAdmin` tinyint(1) NOT NULL default '0', PRIMARY KEY (`ID`), UNIQUE KEY `openID` (`openID`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- cgit v1.2.3 From 2d64f6e2e79737feb805d8c9b32b60825c5a9dcb Mon Sep 17 00:00:00 2001 From: raylu Date: Fri, 9 Sep 2011 23:42:21 -0700 Subject: move some text around --- pages/about.php | 4 ++-- pages/home.php | 13 ++++++++----- 2 files changed, 10 insertions(+), 7 deletions(-) diff --git a/pages/about.php b/pages/about.php index f5ddb8e..eb1ada8 100644 --- a/pages/about.php +++ b/pages/about.php @@ -14,11 +14,11 @@ echo "
";

Email us: snapems@gmail.com
-

Created by:

Patrick Davison and Rex Ounekeo. +

Created by:

Patrick Davison and Rex Ounekeo

Special thanks:

Programmers:

-
raylu +raylu

Testers:

Steven Gosling
Patrick's Family diff --git a/pages/home.php b/pages/home.php index 928a99e..53c8fe4 100644 --- a/pages/home.php +++ b/pages/home.php @@ -104,15 +104,18 @@ $mergesolution = $map;

News:
- We've moved to www.Pathery.com (look up, you're already there) You'll need to re-allow your email-address with google. -
Don't worry- we've saved all your solutions and history - (soon you'll be able to access it too! hehe) - 09-09-11 -
New maps are generated daily at 9:00 PM Pacific Time. -
Maps for : + We've moved to pathery.com (look up, you're already there)! You'll need to re-login with Google. +
Don't worry – we've saved all your solutions and history (soon you'll even be able to see them! hehe). +

+

Maps for :



+

+ New maps are generated daily at 9:00 PM Pacific Time. +

@@ -170,7 +173,7 @@ echo $solutiondiv;
Send feedback to snapems@gmail.com (or IM me if you know me).
We've been aptly implementing changes from feedback.
This game is being adjusted, some 'rules' may change. -
Copyright © 2011 www.pathery.com +
Copyright © 2011 pathery.com -- cgit v1.2.3