From f8c9eb5220afaf2f9a62f9a176a45913240f4081 Mon Sep 17 00:00:00 2001 From: raylu Date: Thu, 7 Apr 2011 00:27:27 -0400 Subject: Initial import from Dropbox --- changelog/changelog.txt | 202 +++++++++++++++++++++++++++++++++++++++++++++++ changelog/datascheme.sql | 82 +++++++++++++++++++ 2 files changed, 284 insertions(+) create mode 100644 changelog/changelog.txt create mode 100644 changelog/datascheme.sql (limited to 'changelog') 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 + 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; -- cgit v1.2.3