Initial import from Dropbox

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;