The following warnings occurred:
Warning [2] Use of undefined constant SAPI_NAME - assumed 'SAPI_NAME' (this will throw an Error in a future version of PHP) - Line: 3388 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3388 errorHandler->error
/showthread.php 116 build_archive_link
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/inc/functions.php 3324 build_forum_breadcrumb
/showthread.php 195 build_forum_breadcrumb
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/showthread.php 195 build_forum_breadcrumb
Warning [2] count(): Parameter must be an array or an object that implements Countable - Line: 786 - File: showthread.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/showthread.php 786 errorHandler->error




SphereCommunity / Sphere 0.56d / General Help v / MySql


Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MySql
Author Message
Q23A
Apprentice
*

Posts: 30
Likes Given: 0
Likes Received: 0 in 0 posts
Joined: Apr 2012
Reputation: 0



Post: #1
MySql
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 Smile


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
06-11-2012 07:56 AM
Find all posts by this user Like Post Quote this message in a reply
Post Reply 


Messages In This Thread
MySql - Q23A - 06-11-2012 07:56 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | SphereCommunity | Return to Top | Return to Content | Mobile Version | RSS Syndication