[CShadowRun]

This is a plugin i mainly made for my server, it used to only work through RCON. But a few people kept bugging me to release it. So i figured i would. I doubt it'll get approved as...it's not really designed for release.
[edit]Woot, it got approved o.O anyone got any suggestions?[/edit]
It was originally designed to only communicate with my IRC bot that sits on RCON and my IRC bot would authenticate the inputs and stuff, But none the less here it is for anyone that wants to use it

In order to access the mute commands you must have the kick flag, for the bans you must have the ban flag.

The Ban/MuteRef is the UnixTime of when you muted the player, so you can look it up in your logs if you keep any.

Commands:
You MUST use quotes, Overwise the plugin will bug out, and thats no good.
/csr_ban "TIME STEAMID REASON"
/csr_unban "STEAMID"
/csr_mute "TIME STEAMID REASON"
/csr_unmute "STEAMID"
You can also use any of the above commands from RCON, just without the /

Time is the number of minutes you want the person to be muted for.
SteamID is the persons steam_id. I opted against using names as i always used to get muddled with stupid clan tags, and unicode names. Stupid people :@
Reason is a reason why the person was banned or muted, like "Being a lamer"

Examples:
/csr_ban "10 STEAM_0:123456 You are lame!"
/csr_unban "STEAM_0:123456"
/csr_mute "10 STEAM_0:123456 I hate you!"
/csr_unmute "STEAM_0:123456"

Installation:
First you must make a MySQL Database with a table called banmutes The table must have 7 colums, exactly as follows.
"id" varchar(25)
"bantime" int(4)
"banref" int(4)
"banreason" varchar(1024)
"mutetime" int(4)
"muteref" int(4)
"mutereason" varchar(1024)

When you have created this table, you must open sourcemod/configs/databases.cfg and make a new entry called CShadowRunBanMutes with all your SQL connection information.

Next copy CShadowRunBanMutes.smx to your plugin folder, and your all done

Hope this helps some people, have fun

[ferret]

Keep in mind that SM's basecomm will interfere if sm_deadtalk is active.

[MoggieX]

howdy,

Can you provide a sql export of the database you're using, as the limit to a varchar type is 255, so 1024 is invalid. Plus no mention of primary key either.

Then we're getting this in the error logs:

L 01/13/2008 - 01:29:59: SourceMod error session started
L 01/13/2008 - 01:29:59: Info (map "de_dust2_night") (file "errors_20080113.log")
L 01/13/2008 - 01:29:59: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 01/13/2008 - 01:29:59: [SM] Displaying call stack trace for plugin "CShadowRunBanMutes.smx":
L 01/13/2008 - 01:29:59: [SM]   [0]  Line 131, /home/groups/alliedmodders/forums/files/2/9/3/3/3/22156.attach::OnClientAuthorized()
L 01/13/2008 - 01:30:00: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 01/13/2008 - 01:30:00: [SM] Displaying call stack trace for plugin "CShadowRunBanMutes.smx":
L 01/13/2008 - 01:30:00: [SM]   [0]  Line 131, /home/groups/alliedmodders/forums/files/2/9/3/3/3/22156.attach::OnClientAuthorized()
L 01/13/2008 - 01:30:00: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 01/13/2008 - 01:30:00: [SM] Displaying call stack trace for plugin "CShadowRunBanMutes.smx":

And this as well

L 01/13/2008 - 01:30:15: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 01/13/2008 - 01:30:15: [SM] Displaying call stack trace for plugin "CShadowRunBanMutes.smx":
L 01/13/2008 - 01:30:15: [SM]   [0]  Line 270, /home/groups/alliedmodders/forums/files/2/9/3/3/3/22156.attach::Command_Ban()
L 01/13/2008 - 01:30:21: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 01/13/2008 - 01:30:21: [SM] Displaying call stack trace for plugin "CShadowRunBanMutes.smx":
L 01/13/2008 - 01:30:21: [SM]   [0]  Line 131, /home/groups/alliedmodders/forums/files/2/9/3/3/3/22156.attach::OnClientAuthorized()
L 01/13/2008 - 01:31:38: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 01/13/2008 - 01:31:38: [SM] Displaying call stack trace for plugin "CShadowRunBanMutes.smx":

Created a new connection, db and followed the instructions and all we can get back is the above errors.

Matt

[Graf]

Does it works with IP? I have local server with STEAM_ID_LAN

[MoggieX]

Originally Posted by Graf Does it works with IP? I have local server with STEAM_ID_LAN

No idea on that, I can't get it working at all, when I got a DBA to look at the code he was supprised it even worked for the chap who coded it

Matt :-(

[mikeym9]

Help?