summaryrefslogtreecommitdiffstats
path: root/include/db.php
AgeCommit message (Collapse)AuthorFilesLines
2009-02-24NEW FEATURE: better debugging and optimization code for db-queries.Arun Persaud1-0/+10
added a timer to db_query for debugging/optimizatin
2009-02-12NEW FEATURE + CLEANUP: added some table sorting to the statistics page via ↵Arun Persaud1-81/+68
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.
2009-01-30NEW FEATURE: vacation supportArun Persaud1-0/+23
users can specify a vacation start and end date and a message. Once they are on vacation their name will be shown in a different color at the table and on the user page (in case it is their turn).
2009-01-24NEW FEATURE: show exchanged cards in poverty pre-game phaseArun Persaud1-0/+3
now you can see the cards that are exchanged during the pre-game setup. Also added a "trump back" message in case trump has been given back.
2009-01-18BUGFIX: error in card dealing routineArun Persaud1-1/+1
same hand got dealt twice due to an error in the new routine. Fixed it, but slowed it down again to roughly 2s per request.
2009-01-15NEW FEATURE: new user settings allows people to not be available for new gamesArun Persaud1-1/+28
Players who set their preference on this setting to 'no' are not considered as players in a new game.
2009-01-13BUGFIX: rewrote query for new gamesArun Persaud1-7/+12
old code used a long time to figure out if cards from another game could be reused. The new version should be much faster.
2008-12-02NEW FEATURE: new sorting algorithmArun Persaud1-0/+8
you can now sort your hand "low to high" and change your default using the setting dialog
2008-10-18NEW FEATURE: make it possible to view games where people played with the ↵Arun Persaud1-1/+9
same hand had to change a few things and check more often if people are logge in, so that for example personal notes only show up when you are logged in and not when someone else is looking at your cards Signed-off-by: Arun Persaud <arun@nubati.net>
2008-09-24BUGFIX: error in SQL syntax for querying ruleset idArun Persaud1-9/+9
named a column 'call' which seems to be a reserved word for mysql, so doing a "...AND call='...' " didn't work. Changed to Tabelname.call and everything seems to be ok. Also deleted trailing whitespaces. Signed-off-by: Arun Persaud <arun@nubati.net>
2008-08-19BUGFIX: db_format_game wasn't working any moreArun Persaud1-4/+3
mysql's TIMEDIFF seems to have changed... comparing <=0 didn't work correctly anymore. Changed it to convert to seconds and then compare those against <=0 and use that data to calculate game number Signed-off-by: Arun Persaud <arun@nubati.net>
2008-07-13NEW FEATURE: in poverty you can now see what cards have been handed overArun Persaud1-0/+20
cards exchanged during poverty show now up in the pre-game trick. Signed-off-by: Arun Persaud <arun@nubati.net>
2008-05-26LAYOUT: added a unified table layout for statistics, etcArun Persaud1-0/+11
a table that can be styled via CSS is created from an array. Signed-off-by: Arun Persaud <arun@nubati.net>
2008-05-24NEW FEATURE: automatically accept new gamesArun Persaud1-0/+13
user can set this in the preferences now and won't be asked during a game setup Signed-off-by: Arun Persaud <arun@nubati.net>
2008-05-10NEW FEATURE: new settings page, user can now change timezoneArun Persaud1-1/+12
rewrote the settings page, timezone can now be changed, the user menu shows up on the left on the pref page. Added a link to the pref-page in the left menu. Signed-off-by: Arun Persaud <arun@nubati.net>
2008-05-08CLEANUP: reorganized the 'init' phase of a gameArun Persaud1-3/+14
moved some code around, so that we test the result of the init phase in the init case statement. Made things a bit clearer and removed one page reload by doing this. Signed-off-by: Arun Persaud <arun@nubati.net>
2008-05-08BUGIFX: typo in a call to a database functionArun Persaud1-1/+1
nothing critical Signed-off-by: Arun Persaud <arun@nubati.net>
2008-05-06CLEANUP: removed all calls to mysql functions and replaced them with calls ↵Arun Persaud1-260/+232
to DB_xxx should be very easy now to change to a different database. also made the code look nicer ;) Signed-off-by: Arun Persaud <arun@nubati.net>
2008-05-04NEW FEATURES: show global statisticArun Persaud1-4/+9
show points/game for all players that have 10 or more games Signed-off-by: Arun Persaud <arun@nubati.net>
2008-04-26CLEANUP: make index.php very short and move everything in separate filesArun Persaud1-0/+1064
created an include dir and almost everything that was in index.php is now in separate files and gets only included in index.php... makes index.php look a lot nicer ;) Signed-off-by: Arun Persaud <arun@nubati.net>
generated by cgit.