summaryrefslogtreecommitdiffstats
path: root/create_database.sql
AgeCommit message (Collapse)AuthorFilesLines
2013-01-12updated copyright for 2013Arun Persaud1-1/+1
2012-09-22updated to better password hash: use crypt instead of md5Arun Persaud1-2/+2
the upgrade will be done automatically when a user logs in, password recovery is still based on md5, but that should be OK, since it's a random generated password anyway
2012-06-09Remove games from digest where the player already movedArun Persaud1-0/+2
2012-02-10updated copyright notice for 2012Arun Persaud1-1/+1
2012-02-04fixed showing re/contra call at beginning of game; allowed pre-game ↵Arun Persaud1-0/+1
comments; DB upgrade the problem with re/contra at the beginning of a game was that no playid was set yet, so we couldn't record when the call was made. Added two special playid (-1 and -2), for pre-game comments and re/contra calls before the first card is played. For this we need to record the gameid in the comment table => DB update
2010-03-13NEW FEATURE: having only low trump (fox and below) can now be a VorbehaltArun Persaud1-3/+4
The low trump can either be treated as poverty or similar to 5 nines, that is the game is canceled unless someone plays a solo. Also minor code cleanup.
2010-03-04fixed typo in create statementArun Persaud1-1/+1
2010-02-06added copyright notice and GPL referenceArun Persaud1-0/+19
2009-06-23added option for email digestArun Persaud1-0/+12
you can now select to get emails only every N hours. They are saved in the database and a cron script will send them out.
2009-04-25NEW FEATURE: added OpenID supportArun Persaud1-0/+8
Users can add and delete OpenIDs on the settings page and then log in user those OpenIds. They can also use their OpenIDs to register.
2009-03-29BUGFIX: store canceled games, don't delete themArun Persaud1-4/+26
deleting the games could result in the same people getting the same hand redealt over and over again. By just keeping track of the hands in the game table, this problem should be gone. Fixed issue #50.
2009-02-12NEW FEATURE + CLEANUP: added some table sorting to the statistics page via ↵Arun Persaud1-1/+2
jquery using jquery to add table sorting, might also use it for other things later. Also optimized some DB-queries and cleaned up some code.
2008-07-13NEW FEATURE: in poverty you can now see what cards have been handed overArun Persaud1-0/+26
cards exchanged during poverty show now up in the pre-game trick. Signed-off-by: Arun Persaud <arun@nubati.net>
2008-05-22BUGFIX: typo in create_databaseArun Persaud1-1/+1
missed a comma (found by Sean). Signed-off-by: Arun Persaud <arun@nubati.net>
2008-03-11NEW FEATURE: Ability to add personal notes for each gameArun Persaud1-0/+24
In case a player is involed in too many games it can get quite confusing with whom your playing, etc. so now the player can add notes on the side that only show up on his/her screen. Signed-off-by: Arun Persaud <arun@nubati.net>
2008-03-01FEATURE: display names of new players and last logged in playersArun Persaud1-0/+1
instead of showing all registered players, just display the above. Signed-off-by: Arun Persaud <arun@nubati.net>
2007-12-16BUGFIX: added indecis to tables for faster lookupArun Persaud1-11/+17
this should make the database part a bit faster. not quit sure if this is the correct way of doing it though :)
2007-12-16BUGFIX: time display used wrong timezones. also optimized things a bitArun Persaud1-1/+1
Got rid of a few db-queries for getting the right timezone. The timezone was also set after the timefunction was called and therefore the timezone didn't have any effect.
2007-12-02BUGFIX: finished scoring algorithmArun Persaud1-3/+3
now all games are scored. Rules can be looked up in the wiki.
2007-11-02NEW FEATURE: count game points, partly done ;)Arun Persaud1-1/+3
a table will be shown now for score keeping. fox, karlchen and dokos are accounted for normal win, calling something and winning should be accounted for still missing: both parties call or one party calls and doesn't acchieve it's goal
2007-10-08NEW FEATURE: send out reminder emailArun1-3/+23
if a player hasn't moved for a week a reminder email can be send out. only one per day is possible, tracking in the db
2007-06-25CLEANUP: counting points, prepare for keeping track of game pointsArun Persaud1-1/+6
use the database now to add up points, cleaned up the code a bit (counting points was done in different places), don't use score table for points from cards any more
2007-06-23NEW FEATURE: password recovery is now workingArun Persaud1-3/+31
Added a simple form of password recovery. The user gets send an email with the new password, which is valid for 24h. The user can request a maximum of 5 passwords within 24h to prevent filling up the database with garbage.
2007-06-07bugfix: typo in last commitarun1-1/+1
2007-06-07* FIX: added extra check for calling 120, etc. so that people can't cheatarun1-0/+2
* NEW: display sessions * NEW: display who's turn it is on the userpage (change in DB) * NEW: different ways when to say 90, 60, etc. (change in DB) * MISC: some clean up, e.g. display of final score
2007-05-17wedding should work now, started working on calling 120/90/60/30/0, small ↵arun1-3/+1
bugfixes
2007-04-12poverty should work now! added german card deck, tons of small fixesarun1-0/+1
2007-02-07fixed: bug in routine to figure out the next playerarun1-0/+28
added rulesets (change in database): at the beginning of a game differnt rules can be chosen
2007-02-03added session to databasearun1-1/+1
2007-01-08FEATURE: added solo and now you also can only play cards that are valid on a ↵arun1-1/+2
trick
2006-12-08playing games should work now... new games can be started automatically at ↵arun1-0/+1
the end of an old one.
2006-12-07tables seems to be case sensitive on dreamhost...fixed itarun1-0/+1
2006-12-07new database backend... kind of workingarun1-0/+292