[zeroibis]

I want to be able to add bans from non sourcemod/sourcebans supported games automatically. In order to do so I plan to create a php script that will add the bans from the non sourcemod games directly to the remote sql sourcebans database. However, I do not know how the bans should be added.

Where in the database should new bans be added? What is the recommended sql call to preform the add of a ban and or the removal of one.

[Peace-Maker]

It only requires an entry in the sb_bans table. Check the plugin's code to see an example query. You should make sure, that the player isn't banned already.

What kind of game are we talking about? No steamids?

[zeroibis]

Natural Selection 2. The game does use steam ids but numerical ones rather than strings. There is a conversion formula that allows the numerical steam id to become a string like normal and vice versa.

I will read over the code and post an example write in here before I do anything. I just do not want to risk corrupting my ban list lol.

[FlyingMongoose]

There was some home grown plans to try to do something like this some time ago, though none of us ever got around to fully implementing it. Ultimately it would work with any game that allows an rcon kick, an rcon ban, and logging or plugin functionality.