summaryrefslogtreecommitdiffstats
path: root/include/db.php
AgeCommit message (Collapse)AuthorFilesLines
2013-03-31added a new set of LGPL licensed cardsArun Persaud1-0/+2
2013-02-25mysql optimization: don't quote integers as strings in WHEREArun Persaud1-20/+21
2013-02-25BUGFIX: mysql needs to return NULL when nothing was foundArun Persaud1-1/+4
2013-02-25better mysql-profiling outputArun Persaud1-5/+13
2013-02-25replaced two DB queries with one that is indexed.Arun Persaud1-10/+0
2013-02-09moved php from old mysql to myslqi to make things more future proofArun Persaud1-18/+13
2013-01-16remove Altenburger Spielkarten, their copyright notice, etc. since the ↵Arun Persaud1-3/+0
licence expired They changed their company police and won't give out a free licence agreement anymore, so might as well remove it completely.
2013-01-12updated copyright for 2013Arun Persaud1-1/+1
2012-09-22updated to better password hash: use crypt instead of md5Arun Persaud1-1/+7
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-4/+7
2012-05-08BUGFIX: removed side effect from getting the user's preferences: the ↵Arun Persaud1-1/+1
language used could be overwritten by another user's choise the DB_get_Prefs($myid) functions used to set the _SESSION variable for the language, but was also called with ids that belonged to other players overwriting the language settings with that from another user
2012-02-18speed up get score tableArun Persaud1-36/+24
instead of looping over all games and have 3 database querries for each gameid, we now only do 5 querries: one for the gameids, scores and gametype and then one for each player to get his party
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-5/+24
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-04-23updated license for german cardsArun Persaud1-1/+1
2010-03-14NEW FEATURE: added localization supportArun Persaud1-0/+7
using gettext to add support for localization
2010-03-13NEW FEATURE: having only low trump (fox and below) can now be a VorbehaltArun Persaud1-6/+9
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-13added check in DB_open for correct DB-versionArun Persaud1-2/+9
2010-02-06added copyright notice and GPL referenceArun Persaud1-0/+19
2010-02-04NEW FEATURE: provide an RSS feed for each user showing in which games it's ↵Arun Persaud1-0/+20
his turn the feed shows the same as the "It's your turn in these games" box.
2009-10-30NEW FEATURE: use gravatars as icons for playersArun Persaud1-0/+11
use icons at the table and on the user page (for last players logged in).
2009-06-23added option for email digestArun Persaud1-4/+50
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-05-11NEW FEATURE: show number of tricks a person madeArun Persaud1-0/+6
only shows 0,1,few or many tricks, so that we don't give too much information away. Might adjust or change this in the future. This addresses issues #11.
2009-04-24CLEANUP: cleaned up some debug message and error checkingArun Persaud1-3/+5
2009-03-29CLEANUP: better debugging option for DB querriesArun Persaud1-6/+7
add option to only log querries that take a long time
2009-03-29CLEANUP: deleted unused functionsArun Persaud1-28/+0
games are not deleted from the DB anymore, so we don't need this function.
2009-03-29BUGFIX: store canceled games, don't delete themArun Persaud1-1/+1
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-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.