[Cep}|{]

Player Announcer

Description:

Announce some players on joined to server.
Players & announce info stored in MySQL database.

Cvars:

sm_player_announcer_version - Plugin version
sm_player_announcer_enable - Enable\Disable this plugin. Default: "1"
sm_player_announcer_serverid - Server ID for multiservers projects. Eg 1,2,3,CSSDM,public..., 'all' - for all servers, 'off' - Inactive this record.
sm_player_announcer_dbconfig - Name of database config in database.cfg

DB structure:
Table `player_announcer`

`steam_id` -
`chat_text` - message to chat, with colors ( {DEFAULT},{LIGHTGREEN},{GREEN},{YELLOW},{OLIV E} )
`top_text` - message to top-left, with colors ({WHITE},{RED},{GREEN},{BLUE},{YELLOW},{PURPL E},{CYAN},{ORANGE},{PINK},{OLIVE},{LIME},{VIO LET},{LIGHTBLUE} )
`center_text` - message to center
`menu_text` - message to menu-panel
`hint_text` - message to hint
`sound` - path to soundfile (if use)
`server_id` - serverID

!! In top-message write space after color (eg. {RED} text)

Autoreplaceing in text:
- {NAME} to player name
- \n to newline

Installation:

1. Place your sound files (if messages use sound) in the 'sound/...' folder on server.
2. Upload the plugin in the 'addons/sourcemod/plugins/' folder and change map or restart server.

Web-interface planned.

[sinblaster]

Announce some players. What players are added, how are they added? Manually added to database?

[Cep}|{]

Manually. Soon make webinterface.

[Cep}|{]

Beta version webinterface, based on SourceBans.

[IMG]http://img545.**************/img545/3884/playerannouncer.th.jpg[/IMG]

Planned SourceBans, HLstatsX and stand-alone interfaces.

[mycologist]

Looking good. Any updates for the web interface?

[Cep}|{]

In this weekend.

[Inflikted]

did you ever get a chance of releasing the web interface?

[Inflikted]

think there might be an issue with this plugin, getting massive amounts of errors after inserts the first couple people into the player announce database

L 09/16/2012 - 00:03:48: [SM] Native "SQL_TQuery" reported: Invalid database Handle de1c0328 (error: 3)
L 09/16/2012 - 00:03:48: [SM] Displaying call stack trace for plugin "player_announcer.smx":
L 09/16/2012 - 00:03:48: [SM] [0] Line 73, /home/groups/alliedmodders/forums/files/6/3/9/1/5/94850.attach::CheckPlayer()
L 09/16/2012 - 00:03:48: [SM] [1] Line 80, /home/groups/alliedmodders/forums/files/6/3/9/1/5/94850.attach::OnClientPostAdminCheck()