+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: Sphere 0.56d (/Forum-Sphere-0-56d)
+--- Forum: General Help (/Forum-General-Help)
+--- Thread: MySql (/Thread-MySql)
MySql - Q23A - 06-11-2012 07:56 AM
I don't know I create topic in right place. I hope I'm.
If I understand right with this script I can create auto tournament.
Problem is that I don't have any ideas have to use mysql.
basically what I need is that mysql check when start tournament.
Example monday 20:00 STARTTOURNAMENT1
Tuesday 21:00 STARTTOURNAMENT2
ETC...
Thank you
Code:
[FUNCTION STARTEVENTS]
IF (<db.connected>)
db.query "SELECT `status` FROM `events`"
local.event = <eval <db.row.0>>
db.query "UPDATE `events` SET `status` = 0"
IF (<local.event> == 1)
STARTTOURNAMENT1
ELIF (<local.event> == 2)
STARTTOURNAMENT2
ELIF (<local.event> == 3)
STARTTOURNAMENT3
ELIF (<local.event> == 4)
STARTTOURNAMENT4
ELIF (<local.event> == 5)
STARTTOURNAMENT5
ELIF (<local.event> == 6)
STARTTOURNAMENT6
ELIF (<local.event> == 7)
STARTTOURNAMENT7
ELIF (<local.event> == 8)
STARTTOURNAMENT8
ELIF (<local.event> == 9)
STARTTOURNAMENT9
ELIF (<local.event> == 10)
STARTTOURNAMENT10
ENDIF
ELSE
db.connect
ENDIF