[ClassicGuzzi]

Auto Kitsfor TF2

Description
Place and save medkits and ammo in the map. When you spawn them, they are saved in a database.
This is based in the DarthNinja's Auto Pumpkins. This plugin is pretty basic, but it's awesome for some Orange maps that don't have any health or ammo in it.
To spawn a kit you need to be an admin with the root flag and type !akmenu. You can also delete the nearest kit (but you have to be close to it to delete).

Features

• You can place small, medium and full medkits and ammokits.
• Kits re-spawn after 10 seconds and emit the spawn sound, like normal kits.
• The medkits don't spawn on sudden death.

Changelog

2014-12-05 (v0.1.0) * Initial release.

Installation instructions
Just place the auto_kit.smx in your sourcemod/plugins/ folder.
This plugin doesn't have any cvar but you need to setup your database.
The config name must be "autokits" and your database "TF2_AutoKits", here is my server's config:

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

Credit
DarthNinja for his Auto Pumpkins plugin.

Note: I'm not that good with SQL and my plugin uses really simple queries. Feel free to post any suggestion to improve it!

[ocwoody]

Great plugin!

Will definitely test this on my orange server!

[Michalplyoutube]

Well nice plugin but you should use the materialize netprop thing to make itself regenerate on pickup

[ClassicGuzzi]

Originally Posted by Michalplyoutube Well nice plugin but you should use the materialize netprop thing to make itself regenerate on pickup

I'm not aware of this method could you give me more info about it?

[404UserNotFound]

With this, I may be able to re-code the Annotations plugin to use a database to store locations of placed annotations

[friagram]

You could just edit the map with entspy on the server to add the entities yourself, or use stripper source.
Either is a better solution for one time map fixes.

[ClassicGuzzi]

Originally Posted by abrandnewday With this, I may be able to re-code the Annotations plugin to use a database to store locations of placed annotations

One of my objectives was to learn about SQL in sourcemod, that's why it's most of the SQL-related part is commented (I got part of the code from another post about SQL examples, I don't remember which right now). Also I would love to get a database-based annotations plugin!

Originally Posted by friagram You could just edit the map with entspy on the server to add the entities yourself, or use stripper source. Either is a better solution for one time map fixes.

I wasn't going to post this as a new plugin at first, because it was just a quick fix for some maps. I didn't know about entspy (and for what you are saying people would have to download the map again?), and I have never used stripper source (I want to learn how to use it in order to play FF2 in normal maps).

This is heavily based on the auto pumpkin plugin so it wasn't that hard, and my main objective was to learn about queries in sm. After I got this code working exactly as I wanted, I was going to post it as a snippet, but it ended as a new plugin because I really wanted feedback and help to improve it.

This plugin is easy to install, you just need the plugin and the database cfg, and to spawn&save a kit it's a matter of one button in a menu. It can't get simpler than that, you say that you have two solution that are better than this, but that's relative. This a simple solution that don't requires any extension or map re-download.

[Stylee32]

Thanks for this useful plugin!

[eraserhead]

Thank you, finally some ammopacks in the middle of Turbine. No more running up the stairs. Although this was also possible with the stripper mod but this is easier.

[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.