summaryrefslogtreecommitdiffstats
path: root/db.php
AgeCommit message (Collapse)AuthorFilesLines
2007-12-16LAYOUT: last login and logout text where displayed incorrectly sometimesArun Persaud1-1/+1
in a previous commit I moved those tings to the output_header function. Turns out you can't do that, so here is the fix.
2007-11-27BUGIX: games in a session were not ordered by date, but by idArun Persaud1-1/+2
when a game gets cancled new games use that game_id in the DB which can mess up the ordering of sessions. fixed now.
2007-11-08NEW FEATURE: addicted people can turn of a lot of the email spam and just ↵Arun Persaud1-13/+61
check online all emails saying: it's your turn can be turned off now by a user preference
2007-11-02NEW FEATURE: count game points, partly done ;)Arun Persaud1-72/+137
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-31BUGFIX: no check for a followup game if someone else already started oneArun Persaud1-0/+12
several people could start a followup game (or one person hitting reload) and several games were started. Now the prog checks if there is already an active game.
2007-10-08NEW FEATURE: send out reminder emailArun1-0/+24
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-07-29BUGFIX: order games by sessionArun Persaud1-3/+4
games are now ordered by sessions, also fixed a typo
2007-07-29LAYOUT: address game by session.gamenrArun Persaud1-0/+13
don't use gameid, but use session.gamenumber instead. needs this for tournaments later. new games will get a session number now by default.
2007-07-20BUGFIX: reusing old randomnumbers didn't workArun Persaud1-5/+8
old numbers got reused, but more than once for the same people should be fixed now.
2007-07-18BUGFIX: using the recovery password to change your passwordArun Persaud1-0/+16
to change your password you needed your old password, the recovery password didn't work, which made it hard to change it, in case you forgot your old password... fixed
2007-07-18NEW FEATURE+BUGFIX: changed calling re/contraArun Persaud1-0/+41
you can call re/contra, etc. now even if it is not your turn. Also fixed rule where you can say 90 with 9 cards, etc. so that you need to say 120 to say 90, 90 to say 60, etc.
2007-07-18NEW FEATURE: use php sessionArun Persaud1-2/+12
used php session, so that people can actually log in and out and linking from one page to another can be done easily without using form to send the password as a hidden parameter over the net all the time
2007-07-01NEW FEATURE: allow multiple commentsArun Persaud1-1/+16
you can now also comment, if it is not your turn, and up to 7 days after the game finished. doubled size of comments too
2007-06-25BUGFIX: fixed bug in getting randomnumbers from a previous gameArun Persaud1-2/+2
DB querry was missing a column
2007-06-25CLEANUP: counting points, prepare for keeping track of game pointsArun Persaud1-1/+1
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-24BUGFIX: include $call in $rulesetArun Persaud1-2/+4
$call wasn't added everywhere where a new ruleset was defined;
2007-06-24CLEANUP: get card names from the databaseArun Persaud1-0/+12
2007-06-23NEW FEATURE: password recovery is now workingArun Persaud1-0/+32
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-19BUGFIX: CC'ed on final game allowed to view different accountsArun Persaud1-8/+0
When people got CC'ed on the final email, they also got copies of everyones email and the link to the game in that email. That way they could go to the user page of a different user. Removed CC option and will just send out two emails from now on. The first one to all players (reply all possible) and the second one with the personal link.
2007-06-17NEW FEATURE: reuse random numbers from old gamesArun Persaud1-0/+15
random numbers generated for old games are reused in case none of the players were in that old game. Will be interesting how different people play with the same hand ;)
2007-06-07* FIX: added extra check for calling 120, etc. so that people can't cheatarun1-0/+32
* 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-22feature: added link to game in final email, CC'ed people in final emailarun1-0/+27
2007-05-17wedding should work now, started working on calling 120/90/60/30/0, small ↵arun1-1/+18
bugfixes
2007-04-12poverty should work now! added german card deck, tons of small fixesarun1-4/+58
2007-04-10added email to first player at the beginning of the game; fixed small layout ↵arun1-0/+26
issue
2007-04-10removed one debug message; added timestamp update for game when playing a cardarun1-0/+7
2007-02-08* rewrote checking for sickness, the player now sees a nice summary before ↵arun1-1/+18
getting to the table... * wedding is now announced * for solo and normal games, re and contra are assigned correctly * the score for re and contra is computed at the end * used one variable $CARDS instead of several global ones e.g. $CARDS["trump"] instead of $TRUMP
2007-02-07fixed: bug in routine to figure out the next playerarun1-3/+39
added rulesets (change in database): at the beginning of a game differnt rules can be chosen
2007-02-06feature request: show complete hand for completed gamesarun1-0/+13
2007-02-03added session to databasearun1-0/+23
2007-02-03you can now cancle games, if they are older than a montharun1-1/+1
2007-01-12added some checks for poverty and wedding, but only nines are handled ↵arun1-0/+12
correctly from now on
2007-01-12server keeps score now, several small bugfixesarun1-3/+30
2007-01-08FEATURE: added solo and now you also can only play cards that are valid on a ↵arun1-1/+54
trick
2006-12-21fixed a lot of bugs, started to work on solos, moved some stuff to output.phparun1-2/+3
2006-12-13added two new features: local time and a link to the user pagearun1-0/+21
2006-12-13small bugfix, had a wrong name for a variablearun1-1/+1
2006-12-12players should get emails again, if it is there turnarun1-0/+11
2006-12-12added a config file (not under VC)arun1-3/+3
2006-12-12small bugfixes to get comments for examples comments workingarun1-1/+4
2006-12-11comments should be working again. not tested thougharun1-1/+9
2006-12-08added local time outputarun1-0/+27
2006-12-08 basic user page, list available users and link to start a new gamearun1-2/+12
2006-12-08playing games should work now... new games can be started automatically at ↵arun1-8/+86
the end of an old one.
2006-12-07tables seems to be case sensitive on dreamhost...fixed itarun1-31/+31
2006-12-07new database backend... kind of workingarun1-0/+264