Working with database

Ask questions and share info about GunGame 5

Working with database

Postby Neka » Thu Feb 23, 2012 7:02 am

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")'):
 
Neka

Private
Private
 
Posts: 40
Joined: Thu Sep 01, 2011 4:22 am

Postby Neka » Fri Feb 24, 2012 5:44 pm

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
Neka

Private
Private
 
Posts: 40
Joined: Thu Sep 01, 2011 4:22 am



Return to General Discussion

Who is online

Users browsing this forum: No registered users and 3 guests

cron