[Lucky_luck]

hi, can you add Woltlap Burning Board 4

[Neuro Toxin]

Originally Posted by Lucky_luck hi, can you add Woltlap Burning Board 4

Do you have a addon that allows players to login / link their steamid?

If so, I need to see the table structures where the steamid is stored.

If you provide: tablename, feildname and steamid format (formats in first post) I can make a query for youm

[Neuro Toxin]

Originally Posted by snelvuur I assume you already know this one, https://forums.alliedmods.net/showthread.php?p=1655283 but if you have that you can just say registered users have a certain flag and only allow those to talk. Other then that, ofcourse nice work

No I didn't. This was build as per a request at https://forums.alliedmods.net/showthread.php?t=254153

[Neuro Toxin]

I just made a basic page to help people generate their required database queries.

It's really basic.

http://console.aus-tg.com/index.php?page=ruv_dbsetup

[Ejziponken]

Testing this plugin tomorrow.

Sourcebans should be like (?):
reguservoiceenabler_query "SELECT * FROM `sb_admins` WHERE `authid` LIKE '{steamid}|%';"
reguservoiceenabler_steamidformat 1

So that only admins/freeslot can use voice.

[Neuro Toxin]

Originally Posted by Ejziponken Testing this plugin tomorrow. Sourcebans should be like (?): reguservoiceenabler_query "SELECT * FROM `sb_admins` WHERE `authid` LIKE '{steamid}|%';" reguservoiceenabler_steamidformat 1 So that only admins/freeslot can use voice.

That appears ok off top of head. Steamid format will be 2.

Ill check when I get home.

[Ejziponken]

Originally Posted by Neuro Toxin That appears ok off top of head. Steamid format will be 2. Ill check when I get home.

"SELECT * FROM 'sb_admins' WHERE authid = '{steamid}';"

works for sourcebans.

[Neuro Toxin]

. I'll update it into the second post tonight.

[Research]

L 01/18/2015 - 18:13:20: [SM] Native "IsClientConnected" reported: Client index 33 is invalid L 01/18/2015 - 18:13:20: [SM] Displaying call stack trace for plugin "reguservoiceenabler.smx": L 01/18/2015 - 18:13:20: [SM] [0] Line 63, reguservoiceenabler.sp::OnDatabaseConnected() L 01/18/2015 - 18:13:20: [SM] [1] Line 241, reguservoiceenabler.sp::OnDatabaseEndConnect( ) L 01/18/2015 - 18:13:20: [reguservoiceenabler.smx] Error encountered during database query: 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 ''sb_admins' WHERE authid = 'BOT'' at line 1 L 01/18/2015 - 18:13:20: [reguservoiceenabler.smx] Error encountered during database query: 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 ''sb_admins' WHERE authid = 'STEAM_0:0:********'' at line 1

reguservoiceenabler_enabled 1 reguservoiceenabler_query "SELECT * FROM 'sb_admins' WHERE authid = '{steamid}';" reguservoiceenabler_muteondbfailure 1 reguservoiceenabler_steamidformat 2 reguservoiceenabler_alwaysshowmessage 1

have so many error how can I fix that?

[Neuro Toxin]

Originally Posted by Research have so many error how can I fix that?

Version 1.0.1 [18.01.2015]
- Fixed client index out of range errors
- Disabled bot processing

Originally Posted by Research reguservoiceenabler_enabled 1 reguservoiceenabler_query "SELECT * FROM 'sb_admins' WHERE authid = '{steamid}';" reguservoiceenabler_muteondbfailure 1 reguservoiceenabler_steamidformat 2 reguservoiceenabler_alwaysshowmessage 1

SELECT * FROM `sb_admins` WHERE authid = '{steamid}';

Edit: I fixed this typo in the second post also