Page 1 of 1

Working with database

PostPosted: Thu Feb 23, 2012 7:02 am
by Neka
Hi!
I want to write addon, which will be write each win into database with timestamp (one win - one row).

1. How can i disable included win count system?
2.
["name"]=>
string(17) "Nickname"
["uniqueid"]=>
string(19) "STEAM_x:x:xxxxxxxxx"
["wins"]=>
string(1) "4"
["timestamp"]=>
string(20) "strftime("%s","now")"

You write string "strftime("%s","now")" instead of result of this function:) Because of this:
def insert_winner(name, uniqueid, wins, timestamp='strftime("%s","now")'):
 

PostPosted: Fri Feb 24, 2012 5:44 pm
by Neka
I want to make addon, which:
1. Store record of win
2. Count wins in this month (start counting from 1th each month) and this week (count starts from Monday)
3. Show who win and who lose at end of the round, and show his own stats for each player what have a team at the moment of end of the round in 2 nice HTML-tables for each team

But my implementation occurs awful delays, because it has a lot of interraction with database (sqlite3). I cannot mind (dont know how it in Englis:( ) the architecture of table / tables for this plugin to make delays smaller.

Can you help me with this?

Thank you