[ClassicGuzzi]

Originally Posted by Burninghot Hey. So I've tried installing this on my server, however I get this error: ] rcon sm plugins refresh L 09/06/2015 - 22:18:48: [auto_kit.smx] Database failure: Could not find database conf "autokits" L 09/06/2015 - 22:18:48: [SM] Plugin encountered error 25: Call was aborted L 09/06/2015 - 22:18:48: [SM] Native "SetFailState" reported: Couldn't connect to the database, check logs for more information. L 09/06/2015 - 22:18:48: [SM] Displaying call stack trace for plugin "auto_kit.smx": L 09/06/2015 - 22:18:48: [SM] [0] Line 89, /home/forums/content/files/2/3/8/8/6/4/140486.attach::SQL_OnConnect() [SM] The plugin list has been refreshed and reloaded. > Any ideas? I've placed the plugin into the plugin folder and the other two files were made and placed in the cfg folder. Thank you.

you have to open your databases.cfg that is already on your sourcemond/configs folder and add this:

"autokits"
{
"driver" "sqlite"
"host" "localhost"
"database" "TF2_AutoKits"
"user" "root"
"pass" ""
}

[Burninghot]

Oh my silly me. Thank you for your help!

[Bonkorn]

I don't have SQLite, Can I use mySQL?

PHP Code:

    "autokits"
    {
        "driver"            "mysql"
        "host"                "localhost"
        "database"            "tf2_autokits"
        "user"                "root"
        "pass"                ""
    } 


[Bonkorn]

I get this error with MySQL

L 11/15/2015 - 03:12:24: [auto_kit.smx] Query failed! You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' locY VARCHAR, locZ VARCHAR, type INT, map VARCHAR)' at line 1

[ClassicGuzzi]

Originally Posted by Bonkorn I get this error with MySQL L 11/15/2015 - 03:12:24: [auto_kit.smx] Query failed! You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' locY VARCHAR, locZ VARCHAR, type INT, map VARCHAR)' at line 1

I'm pretty sure that I didn't write this to work with mySQL when I coded this.
So ahmm you have two options, edit it to work with mysql (I think it just needs some ' in the varaibles but I'm not sure, or use SQLite, you do have it, it comes with sourcemod itself (i think), just try using my config.

[Bonkorn]

Thanks for the quick reply, it works now with your config. and these kit location are saved.

PHP Code:

sm plugins unload auto_kit; sm plugins load auto_kit
[SM] Plugin [TF2] Auto Kits unloaded successfully.
[SM] Loaded plugin auto_kit.smx successfully.
[AK] The Auto-Kit table is ready! 


But it doesn't generate anything in database?

[ClassicGuzzi]

Originally Posted by Bonkorn But it doesn't generate anything in database?

sqlite data is saved on sourcemod/data/sqlite/TF2_AutoKits.sq3 try to open that file and see if there is anything in there.

[Argos]

Definitely this would be wonderful with mysql. I think in the ease of having x number of servers with multiple maps and the same database. Please add support for MySQL.

[Arkarr]

Great idea & plugin, but still, I'm confused.

The config name must be "autokits" and your database "TF2_AutoKits", here is my server's config: Code: "autokits" { [...] }

[lugui]

The plugin is not creating the table in the database. anyway, i created it manualy.

Attached .sql file