This topic contains 5 replies, has 0 voices, and was last updated by  Levi the Oracle 7 years, 6 months ago.

  • Author
    Posts
  • #7369

    Levi the Oracle
    Participant

    Greetings

    I am working on setting up stats logging for the server I host when I run a tournament. I installed MySQL, but I don’t understand how to “source the data/statstables.sql file from the scorched3d data directory”.

    Do I have to create a database first and if so by what name?
    Do I have to create a table first and if so by what name?

    The command I have tried so far to source the statstables.sql file is:

    . C:Program FilesScorched3DDatastatstables.sql

    I know this isn’t correct, but I don’t know what it wants. I think it needs the name of a target table or database but I haven’t created anything yet. Any help would be appreciated.

    #61922

    Thrax
    Participant

    @Levi the Oracle wrote:

    Greetings

    I am working on setting up stats logging for the server I host when I run a
    tournament. I installed MySQL, but I don’t understand how to “source the
    data/statstables.sql file from the scorched3d data directory”.

    Do I have to create a database first and if so by what name?
    Do I have to create a table first and if so by what name?

    The command I have tried so far to source the statstables.sql file is:

    . C:Program FilesScorched3DDatastatstables.sql

    I know this isn’t correct, but I don’t know what it wants. I think it needs the
    name of a target table or database but I haven’t created anything yet. Any
    help would be appreciated.

    the line you’d need would be exactly;

    source C:/Program Files/Scorched3D/Data/statstables.sql

    You’ve done the first part. Installing Mysql.

    That is one of several steps needed to make stats functional on your servers.
    However, In the manner that you spontaniously create servers and
    tournements, it will get quite un-sorted after a while unless you decide on
    a standard method and server-naming system.

    The whole walkthrough of Mysql is explained in the Wiki/Docs.

    http://www.scorched3d.co.uk/wiki/index.php/Stats_logging_for_servers
    Setting up the Database

    1. Install Mysql – Done
    2. Create Stats Tables
    3. Fix Old-Password function in Mysql
    4. Create MYSQL.–.–.XML files for the Server you plan to host.
    5. Alter Server.XML to look for Mysql based Stats.
    6. Enable File Logging on the Server so you can trouble-shoot Errors
    and monitor silently for abuse.
    7. Pick 1 (one) name for that Server, and stick with it.. If you change the
    servers Name by even a single Space or Caps change, you record entirely
    new stats for it’s operating period.
    8. Launch Server and trouble-shoot Errors.

    The File to create the Tables, /data/statstables.sql , is slightly flawed for
    a first-time Table creation. You will need to remove the first 13 lines
    resembling;

    drop table scorched3d_ipaddress

    Most sql clients, including the CMD-line choke on them if the tables don’t
    exist first to drop..

    I use a Windows browser-like tool to manage my Database called Enginsite
    Mysql Client. It make’s setting-up, viewing, and altering stats easier for
    the first-time sql user.

    http://www.enginsite.com/MySQL-client-manager-and-GUI-for-MySQL.htm

    This process has also been asked about in several other threads, and we’ve
    walked them through it either in here, or personally in the chat-room.
    Search for tips here first, but i may be available to chat with later if you
    still need help.

    #61923

    Levi the Oracle
    Participant

    @thrax wrote:

    In the manner that you spontaniously create servers and
    tournements, it will get quite un-sorted after a while unless you decide on
    a standard method and server-naming system.

    I am not entirely certain how I will use the statistics just yet. I suspect I will want a clean slate for each event, so sorting won’t be a problem.

    It might be worthwhile to do some sort of server-naming system depending on how difficult it is to delete old data.

    #61924

    Levi the Oracle
    Participant

    I attempted to investigate the wiki at http://www.scorched3d.co.uk/wiki/index.php/Stats_logging_for_servers but it did not work when I first tried it. I will try again later, but there could be something wrong with this wiki article.

    #61925

    Thrax
    Participant

    @Levi the Oracle wrote:

    I attempted to investigate the wiki at http://www.scorched3d.co.uk/wiki/index.php/Stats_logging_for_servers
    but it did not work when I first tried it. I will try again later, but there could
    be something wrong with this wiki article.

    The link is valid. It’s the same place you reach by using the icon on the
    top-bar labled Docs, then roaming to;

    Server setup > •Stats logging for servers > Setting up the Database

    #61926

    Laptops Daddy
    Participant

    hi levi

    im sure thrax has you covered, but if it helps, you might want to think about setting up a lamp/wamp server. that way you could keep your own stats web page and use a php based mysql admin tool like phpMyAdmin.

    #61927

    Levi the Oracle
    Participant

    @laptops Daddy wrote:

    you might want to think about setting up a lamp/wamp server. that way you could keep your own stats web page

    I would by happy to think about a lamp/wamp server, but first I would need to know what one is. It is an interesting thought though, a web page for stats generated by one or more tournaments.

    If we start to get hundreds of players competing in events, it would be well worth the while, but for the time being, I am just going to get a basic stats server up and see if that has any value for tournament competition.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.