[GhostMan]

Could you make a quick guide how to set up database properly so that bans would work? Because I clearly do something wrong.
When executing PugProcedures.sql I get this error > http://prntscr.com/6xs3a5

PHP Code:

#1064 - 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 'iMax;
END' at line 6 


[perforator]

Originally Posted by GhostMan Could you make a quick guide how to set up database properly so that bans would work? Because I clearly do something wrong. When executing PugProcedures.sql I get this error > http://prntscr.com/6xs3a5 PHP Code: #1064 - 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 'iMax; END' at line 6

Old version phpMyAdmin on hosting.

[GhostMan]

http://prntscr.com/6xycga
I use version 3.4.11.1deb2+deb7u1. Could somebody edit code so it would fit me?

[perforator]

ban bug:

I give a ban player "cosmos".


He got a ban


but kick me

[^SmileY]

Originally Posted by perforator ban bug: I give a ban player "cosmos". He got a ban but kick me

LOL thanks for report, i really need to check this

EDIT: Fixed

[GhostMan]

I'd like to suggest a few more improvements.

1. As for now if player leaves server when match started (LIVE) he gets instantly banned. I'd suggest to give a player like 2 minutes to reconnect. Also add chat messages like "X player left LIE match, he has X seconds to reconnect before being banned" and "X player has been banned because he left LIVE match".

2. Add ability to turn of godmode in spawn.

3. Sometimes few players leaves and you left to play 2x5 or 3x5 or whatever. These kind of matches are very frustrating. When this happens you have two options: play and get destroyed or leave and get banned. Neither of these options are good. So maybe it would be smart to add functions like:

pug_team_difference "2" - minimum player difference number between teams to start counting down rounds until 'game over'.
pug_team_difference_rounds "3" - how many rounds has to pass when 'pug_team_difference' reached to set 'game over'.

With these settings it would be "game over" if there is 2 or more player difference between teams (for example 3x5 or 2x5) and 3 rounds passed.

[perforator]

Originally Posted by ^SmileY LOL thanks for report, i really need to check this EDIT: Fixed

Love you!

Originally Posted by GhostMan I'd like to suggest a few more improvements. 2. Add ability to turn of godmode in spawn. If you'd add these improvement it would be really awesome.

Mb like this:
pug_spawn "0" - permanent godmode
pug_spawn "1-999" - seconds

[perforator]

Originally Posted by ^SmileY LOL thanks for report, i really need to check this EDIT: Fixed

Originally Posted by perforator Love you!

Hm...i rewrite sma. Compile. And now ban, but not kick (me or banned player)

!ban player 1337 bla bla bla

player got a ban, but not kicked.

[^SmileY]

I will try to make some changes as suggested, i am under Windows 10 for tests and i need to install Steam first

Ps. Thanks for suggestions

EDIT:
GhostMan and perforator, Add-me on steam to better communication or send-me via PM..

SteamIDConverter.com/_SmileY

More issues fixed:

- !Ban Command not kick the correct player;
- !msg command is not displayed at !help command
- Cvars descriptions updated (Sorry for my english again :S)

Updated [at] my github and main post thanks.

[GhostMan]

Nice!

Next I would love to see you improving ban system as I suggested earlier. Make that player would have 2 minutes or so to reconnect. If he does not come back - ban for leaving match.

Also, maybe add ability for admins to ban disconnected players? Just like amxbans has this feature.