2 files changed, 284 insertions, 0 deletions
diff --git a/changelog/changelog.txt b/changelog/changelog.txt
new file mode 100644
index 0000000..4489604
--- /dev/null
+++ b/changelog/changelog.txt
@@ -0,0 +1,202 @@
+=================
+== NamePending ==
+=================
+04-04-11
+	Setup the leaderboard to show every solution from yesterday. - Snap
+	Modified loadSol() JS function to support other calls. - Snap
+	Added col1 and col2 classes for the columns. They're now used on the	homepage and leaderboard page. - raylu
+	The leaderboard specific CSS is in statsstyle.css. It's currently	included on all pages, unfortunately.  - raylu
+	Cleaned up the leaderboard.php code duplication. - raylu
+	Added some Javascript to only show one stats section at a time on the leaderboard page. - raylu
+
+04-03-11
+	Fixed a database related issue, solution size was insuffecient. - Snap
+	Preferences for mute/speed is now saved - Snap
+	Facebook page semi-started (awaiting name?) - Snap
+	
+03-28-11 - 03-31-11
+	Added maps-per-day. - Snap
+		A few map-types designed and added. - Snap
+	Added deny all .htaccess to /pages. - Snap
+
+03-27-11
+	Added yesterdays best solution to leaderboard. - Snap
+
+03-26-11 (Back from vacation)
+	do.php now confirms that it is a current map. - Snap
+		isCurrentMap() function added to do.php
+	Moved $Links array to index.php. - Snap
+		Fixed an issue with generating links before cookielogin.
+		The logic of having them next to where it checks for those links is better too.
+		
+03-16-11
+	Fixed an issue with the leaderboard. - Snap
+
+03-15-11
+	Some spelling/grammar fixes in how to play. -raylu
+	Redid the layout. -raylu
+		There is no navigation bar anymore; everything is in the top bar.
+		There are now two float:left divs with widths 25%, 50% on the homepage. This gives the
+		illusion that the second one is "centered."
+	Fixed a lot of issues with the animated path. - Snap
+
+03-14-11
+	Added cp.php, control-panel. - Snap
+		Allows users to change their displayname.
+		Link for now is located on their displayname, top right.
+	Fixed an issue where pathing didn't like to overlap. - Snap
+
+03-13-11
+	Turned the Speed into a dropdown. -Snap (Thanks Rory)
+	Login Logout top-bar added. - Snap
+	Your personal best solution is loaded for the map. - Snap
+	Leaderboard added. - Snap
+	Logout link removed from nav, but login link kept. (makes sense, right?) - Snap
+
+03-12-11
+	Tons if little changes to the UI. -Snap
+
+03-11-11
+	Cookie login method added; session data is rebuilt. - Snap
+		!~ Auth is not dependent on a time frame, this will need to be fixed.
+		Cookies are deleted on logout.
+	MapCode is now requested from the database, rather than using the exploitable JS code. - Snap
+	Implemented "formSolution" function into do.php; - Snap
+		Now identical solutions will appear identical.
+			This could be useful in the future, but only if this is implemented now.
+
+03-10-11
+	Updated our pipeline.txt - Snap
+	Added notification of when you beat or tie a record. - Snap
+	Fixed unusual bug where hitting a target could cause an issue with the counter-box. - Snap
+	Added datas.php for SQL statistical output. - Snap
+		Started topscores PHP function.
+
+
+03-09-11
+	Fixed a bug with reset button leaving shadows. - Snap (ty, everyone who mentioned that)
+	Added blink to teleport tiles when in use. - Snap
+	Test Path button is now disabled for the duration of the animation. - Snap
+	Started the 'How To Play' page: - Snap
+		Added optional arguement $example boolean = false to the PHP displayMap function.
+			When true, speed is set to slow, and the border-data is removed.
+	Fixed a height issue with smaller maps, which has been effecting other maps too. - Snap
+	Many improvements made to the "doAnimate" function. - Snap
+
+03-08-11
+	Fixed a bug when removing blocks could currupt the solution. - Snap
+	The animated path now goes 'over' special squares, instead of hoping over them. - Snap
+	New function mapOfTheDay(TYPE). - Snap
+		Returns the map created for that TYPE or generates one that day.
+		TYPES; 1 2 3 4, easy normal hard random. Default: random.
+		new types are created very easily, I.E. $motd = mapOfTheDay(5); will generate the map, unless existing that day.
+			To set custom definitions for that map, just add a case in mapOfTheDay's switch $type.
+
+03-07-11
+	Fixed a bug special where the path could be blocked by blocking a teleport OUT. - Snap (thanks Light)
+		(Special because other rare conditions had to be met too);
+	Tweaked game border-data. - Snap
+	Nice lookin IN and OUT tiles made. - Rex
+	
+03-03-11 - 03-06-11
+	Tweaked colors. - Snap
+	Changed how javascript handled teleports. and gray-ed out teleports. - Snap
+	Pathing now goes INTO the teleport in - rather than teleporting before reaching TPin. - Snap
+		A required change for the animation to properly locate the teleport-in square.
+		Note; this change will add +1 moves per used-teleport in some solutions.
+	Added sounds. Snap
+	Added slow-med-fast animation. Snap
+	Added gray-out checkpoints. Snap
+	mapcode format changed - see documentation.txt. - Snap
+	
+03-02-11
+	Started recording peoples best solution. - Snap
+	Login added. - Snap
+	Pages and links prepared. - Rex
+	Header navigation started. - Rex
+	mapoftheday.php and function mapOfTheDay() added; - Snap
+	Database tables added; maps, users, solutions - Snap
+
+03-01-11
+	Added 'Reset Walls' button. - Snap
+	Once again fixed a counting issue with PHP... - Snap
+	Contained mazes to allow for unlimited mazes to be displayed, animated and solved. - Snap
+
+
+02-28-11
+	Fixed an issue where pathing could run into mapMatrix[0] (headers) - Snap
+	DisplayMap now sneaks in a hidden div containing JSON data for wall count & etc. - Snap
+	$numBlocks arguement changed to optional, default -1 for random. - Snap
+		Random odds currently set to: 
+		$numBlocks = Rand(7, (int)($rows * $cols) * .12);
+	Many, many bug fixes related to having 0 checkpoints & alike. - Snap
+	Fixed snake-color issue adjustable checkpoints. -Snap
+	Routepath correctly handles different amount of checkpoints. - Snap
+	GenerateMap now has 2 optional arguements for checkpoints and teleports.
+		-1 - 5, -1 - 2, default -1 - which is random. - Snap
+	Fixed an issue where php's movecount was off. - Snap
+	Added checkpoints "d" and "e" - Snap
+	Set the "snake"'s color the same as it's next target. - Snap
+	
+02-27-11
+	Added 2nd teleport, and solved the many issues that arised with it. - Snap
+	Solved an issue where the javascript animation caused mapdistoration due to non-set width/height. - Snap
+	Fixed move-count when effected by teleports - Snap
+
+02-26-11
+	Discovered that if you block the teleport-out square, it jumps to the next target... - Snap
+		bewildered by the fact that my code didn't fail, perhaps we should leave it as is? 
+	Semi-implemented arrow-snake. - Snap
+	More attractive images added. - Rex
+
+02-25-11 (Updates from previous days)
+	Added ValidateMap($mapMatrix) function. - Snap
+	Started a database, no tables. - Snap
+		<Link removed for security> contact Snap for DB access.
+	A sweet teleport 't' and 'u' added! w00 h00! - Snap (w/ help).
+	Updated Pathing to support multiple start locations. (['start'] = 'y,x' of start location) - Snap
+	Finished update on javascript to support multiple start locations. - Snap
+	Completed pathing. - Snap
+	Updated visuals.
+	Edited CSS for .grid_table. - Rex
+	Added Website Diagram to /Changelog. - Rex
+	
+
+02-22-11
+	Modified MergeMapSolution function - Snap
+	Added optional $idprefix to DisplayMap, to allow for multiple maps on the same page. - Snap
+	Added required mapid to AnimatePath(path, mapid) - Snap
+	Added solution array, and blocks array, for multiple maps - Snap
+	Added alternate prefixes to CSS Transitions, sadly firefox doesn't support this property
+		but, it still looks good without it. (Opera & Netscape some others do).
+	Started work on gallery. - Snap
+
+02-21-11
+	Started work on AJAX (do.php & home.php). -Snap
+	Added function MergeMapSolution(Map, Solution) -Snap
+	Added JS function AnimatePath(PATHCODE) Fairly pretty :) -Snap
+	Had a lot of fun with css transitions.
+	Worked on FindPath function	-Rex
+
+02/20/11
+	$mapMatrix[0] now holds header data
+	Edited GenerateMapCode - added more headers and adjusted loop
+	Created GenerateMapByCode function.
+	Created GetTile function. (Not working)
+   Fixed Checkpoint spawn
+   Fixed an issue regarding an extra column being generated in GenerateMap
+
+Snap 02/19/11
+
+   Added headers to GenerateMapCode
+   Temporarly moved Functions GenerateMapCode & GenerateMap to map.php
+   Created DisplayMap function
+   Lots of little things.
+
+
+02/18/11
+In Concept.
+
+
+
+
diff --git a/changelog/datascheme.sql b/changelog/datascheme.sql
new file mode 100644
index 0000000..bb00b23
--- /dev/null
+++ b/changelog/datascheme.sql
@@ -0,0 +1,82 @@
+-- phpMyAdmin SQL Dump
+-- version 3.3.8.1
+-- http://www.phpmyadmin.net
+--
+-- Host: db2838.perfora.net
+-- Generation Time: Mar 15, 2011 at 07:14 PM
+-- Server version: 5.0.91
+-- PHP Version: 5.2.17
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+
+--
+-- Database: `db358894438`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `mapOfTheDay`
+--
+
+CREATE TABLE `mapOfTheDay` (
+  `ID` int(11) NOT NULL auto_increment,
+  `mapID` int(11) NOT NULL,
+  `mapType` tinyint(4) NOT NULL,
+  `mapDate` date NOT NULL,
+  PRIMARY KEY  (`ID`)
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `maps`
+--
+
+CREATE TABLE `maps` (
+  `ID` int(11) NOT NULL auto_increment,
+  `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;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `solutions`
+--
+
+CREATE TABLE `solutions` (
+  `ID` int(11) NOT NULL auto_increment,
+  `userID` int(11) NOT NULL,
+  `mapID` int(11) NOT NULL,
+  `solution` varchar(128) collate latin1_general_ci NOT NULL,
+  `moves` int(11) NOT NULL,
+  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  PRIMARY KEY  (`ID`),
+  KEY `userID` (`userID`,`mapID`)
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `users`
+--
+
+CREATE TABLE `users` (
+  `ID` int(11) NOT NULL auto_increment,
+  `openID` varchar(255) collate latin1_general_ci NOT NULL,
+  `email` varchar(128) collate latin1_general_ci NOT NULL,
+  `displayName` varchar(64) collate latin1_general_ci NOT NULL,
+  `dateLogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  `dateJoined` timestamp NOT NULL default '0000-00-00 00:00:00',
+  `isAdmin` tinyint(1) NOT NULL default '0',
+  PRIMARY KEY  (`ID`),
+  UNIQUE KEY `openID` (`openID`)
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;