³ò šõÜNc@sdZddklZddklZedƒZdd„Zd d d d d„Zd„Z d „Z d d „Z d d „Z d S(sj $Rev: 571 $ $LastChangedBy: satoon101 $ $LastChangedDate: 2011-10-24 01:05:16 -0400 (Mon, 24 Oct 2011) $ iÿÿÿÿ(t ServerVar(tDatabasetgg_prune_databasesstrftime("%s","now")cCs:tƒ}|iddd||||fƒ|iƒdS(s0 Inserts a new entry into the database. s6INSERT INTO gg_wins (name, uniqueid, wins, timestamp) sVALUES(?, ?, ?, ?)tvaluesN(Rt_querytcommit(tnametuniqueidtwinst timestamptggDB((sV/home/saberrider/srcds/css/cstrike/addons/eventscripts/gungame51/core/sql/shortcuts.pyt insert_winners  c CsÍd}|pdSnt|tƒp |f}nt|tƒp |f}nt|ƒt|ƒjotdƒ‚nx2|D]*}||joqntd|ƒ‚qWh|d<|d<|d<|d<}d} g} x]|D]U} || oDt| ƒp d } n | d 7} | d | 7} | i|| ƒqêqêWd} x7|D]/}t| ƒo| d 7} n| d |7} qPWd| | f} |t| ƒ7}tƒ}|i| d|ƒ|iƒdS(sr Updates the database for the columns in columnTuple with the values in valueTuple of the same index. RRR Ns2columnTuple and valueTuple must be the same lengths,Valid columnTuple entries are %s, %s, and %sRttWHEREs ANDs %s=?s, s%s=?sUPDATE gg_wins SET %s %sR(snameswinss timestamp( t isinstancettupletlent ValueErrort NameErrortappendRRR(t columnTuplet valueTupleRRRR t validEntriestcolumntconditionParamst conditionstconditionValuest conditiont updateStringt queryStringR ((sV/home/saberrider/srcds/css/cstrike/addons/eventscripts/gungame51/core/sql/shortcuts.pyt update_winner&sL          cCsRtƒ}|iddd|ƒ}|djodSn|iddd|ƒdS(Ntgg_winsRswhere uniqueid = "%s"iÿÿÿÿsCOUNT(*)sWHERE ABS(wins) > %si(RtselecttNone(RR t currentWins((sV/home/saberrider/srcds/css/cstrike/addons/eventscripts/gungame51/core/sql/shortcuts.pytget_rankns  cCstƒiddƒS(NRsCOUNT(*)(RR (((sV/home/saberrider/srcds/css/cstrike/addons/eventscripts/gungame51/core/sql/shortcuts.pytget_winner_count}si cCsjt|ƒiƒptd|ƒ‚nt|ƒ}tƒ}|idddt|ƒ}|o|SngS(sj Returns an ordered list dicts of (n) player names in order from highest to lowest win count. s$Expected digit, and got a str() (%s)RRRRsORDER BY ABS(wins) DESC(snamesuniqueidswins(tstrtisdigitRtintRR tTrue(tnR t winner_list((sV/home/saberrider/srcds/css/cstrike/addons/eventscripts/gungame51/core/sql/shortcuts.pytget_winners_lists   cCs^|p%ttƒpdSnttƒ}ntƒ}|iddd|fƒ|iƒdS(sT Prunes the database within n amount of days, defaults to gg_prune_database NsDELETE FROM gg_wins WHERE s,timestamp < strftime("%s","now", "-%s days")s%s(R'RRRR(tdaysR ((sV/home/saberrider/srcds/css/cstrike/addons/eventscripts/gungame51/core/sql/shortcuts.pytprune_winners_db‘s   N( t__doc__tesRtgungame51.core.sqlRRR R!RR#R$R+R-(((sV/home/saberrider/srcds/css/cstrike/addons/eventscripts/gungame51/core/sql/shortcuts.pyss   G