Page 24 of 24 FirstFirst ... 14222324
Results 231 to 238 of 238
  1. #231
    Good afternoon. I am looking to add end of round most headshots and log them to serverkills db stats, Anyone have any idea?

  2. #232
    Senior Member
    Join Date
    Oct 2015
    Location
    Germany
    Posts
    279
    you can do it with the plugin "ProCon Chat, GUID, Stats and Map Logger"

    https://forum.myrcon.com/showthread....Logger-1-0-0-2

  3. #233
    Quote Originally Posted by maxdralle View Post
    you can do it with the plugin "ProCon Chat, GUID, Stats and Map Logger"

    https://forum.myrcon.com/showthread....Logger-1-0-0-2
    Ty. True. which I am using now. But I would like to add end of round most headshot stats. is it possible to add to the code?

    Example here: ------------------------ END OF ROUND STATS ------------------------
    Most Kills: %mkp% with %mkn% kills
    Most Knife Kills: %mkkp% with %mkkn% knife kills
    Most Headshots:
    Highest Kill Streak: %hksp% with %hksn% kills in a row

  4. #234
    you can do this with proconrulz easily, but it wont add it to the stats in your database for that plugin

  5. #235
    Quote Originally Posted by TimSad View Post
    I've been using it and everything seems to work out just fine.
    we are using it too, works nice except the End of Round stats will not be shown
    they never worked for us on Hardline, the rest of it works perfectly fine


  6. #236
    I started using it on my own server, I wanted to know how to solve it?
    Is there a way to use mysql localhost instead of remote?

    [08:52:17 51] [Server Kills] Error! Task: createTables() Index #0 - Message: [Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified NativeError: 0 Source: SQL: IM002
    Last edited by XaosBr; 14-07-2017 at 13:01.

  7. #237
    Senior Member
    Join Date
    Feb 2015
    Location
    netherlands
    Posts
    322
    kicking some new life in it.
    Ok, it doesnt make the tables it self.

    creating the table by hand is no isue.
    but how many colloms i need?

  8. #238
    Super Moderator
    Join Date
    Jul 2010
    Location
    Very North Darwin
    Posts
    1,555
    The plugin, IF connecting correctly should be creating the tables if they dont exist
    "_overall_kills"
    "_overall_knife_kills"
    and a buch of tables for each weapopn code eg this.weaponCodes[i]


    this.sqlCommand = "CREATE TABLE IF NOT EXISTS `" + this.dbName + "`.`" + this.dbTable + "_overall_kills` (`Time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `Kills` INT UNSIGNED NOT NULL)";

    using (OdbcCommand command = new OdbcCommand(this.sqlCommand, this.odbcConnection))
    {
    command.ExecuteNonQuery();
    command.CommandText = "CREATE TABLE IF NOT EXISTS `" + this.dbName + "`.`" + this.dbTable + "_overall_knife_kills` (`Time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `Kills` INT UNSIGNED NOT NULL)";
    command.ExecuteNonQuery();

    for (int i = 0; i < this.weaponCodes.Count; i++)
    {
    command.CommandText = "CREATE TABLE IF NOT EXISTS `" + this.dbName + "`.`" + this.dbTable + "_" + this.weaponCodes[i] + "` (`Time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `Kills` INT UNSIGNED NOT NULL)";
    command.ExecuteNonQuery();
    }
    }
    Last edited by leibhold; 01-05-2018 at 00:17. Reason: I LOVE TYPOS and fkn capslock

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •