/ Register

  1. REGISTRATION REQUIREMENTS:

    Your username here MUST MATCH your XenForo username (connected to your XF license).

    Once you have registered here, then you need to start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

Reset all Sportsbook stats

Discussion in 'Sportsbook Support' started by tajhay, Feb 2, 2013.

  1. Feb 2, 2013 #1
    tajhay

    tajhay Active Member AMS Premium CAS Premium SC Premium Pickem Power Rankings Sportsbook Survivor

    Hi, is there a way to resent all sportsbook stats, even a sql query i can run?

    Need this urgently.
     
  2. Feb 3, 2013 #2
    Bob

    Bob Developer Staff Member

    Yes and No. The stats are dynamically generated from data within Events, so the only way to "reset" is to remove archived events. What "stats" are you most concerned with?
     
  3. Feb 3, 2013 #3
    tajhay

    tajhay Active Member AMS Premium CAS Premium SC Premium Pickem Power Rankings Sportsbook Survivor

    pretty much everything in the sportsbook-stats/page...i dont mind deleting whatever is needed bro, perhaps a quick sql u can give me that i can run?
     
  4. Feb 4, 2013 #4
    tajhay

    tajhay Active Member AMS Premium CAS Premium SC Premium Pickem Power Rankings Sportsbook Survivor

    any idea if there is a quick way of removing archived events? Either via Sql (too scared to try something on my own haha), or do i need to manually remove each archived event?
     
  5. Feb 4, 2013 #5
    Bob

    Bob Developer Staff Member

    To remove an event, you also need to remove all outcomes for that event (they are stored in the outcomes table) and all wagers associated with each outcome (wagers are stored in the wagers table). You also need to remove comments, newsfeed items, alerts, likes (for both comments and the item). So an event consists of a lot of chained data. It really needs to be done via php because of the complexity.

    So to answer, no, there is no "quick" way and there is a reason for that (as explained above).

    I can add in a feature to remove ALL archived events. Just start a thread in the Spostsbook suggestions forum asking for it.
     
    tajhay likes this.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...