summaryrefslogtreecommitdiffstats
path: root/create_database.sql
AgeCommit message (Collapse)AuthorFilesLines
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