1.50 testing. Ban for garena not work.

Have you done adding [You must be registered and logged in to see this link.] for your SQL db? It's called GGDragon fix for bans on Garena/Lan

No.

Code:

create trigger setserv before insert on DATABASE_NAME.bans
for each row
begin
set new.server = 'SERVER_NAME';
end;
$$

From Now!!! Trigger works! IDK about bans

p.s.

Code:

[Mon Nov 05 07:42:10 2012] [                GAME: test garena] player [dibaeff(87.224.223.60|RU)] has joined from [LAN] Russia TD Room 11 (1.26a)

[Mon Nov 05 07:43:25 2012] [                GAME: test garena] [Lobby] [russoka]: !ban dib test
[Mon Nov 05 07:43:25 2012] [                GAME: test garena] admin [russoka] sent command [ban] with payload [dib test]
[Mon Nov 05 07:43:25 2012] [                GAME: test garena] player [dib] was banned by player [russoka]
[Mon Nov 05 07:43:25 2012] [                      LOCAL: XPAM] /w dib You have been banned, test

[Mon Nov 05 07:43:29 2012] [                GAME: test garena] [Lobby] [russoka]: !kick dib
[Mon Nov 05 07:43:29 2012] [                GAME: test garena] admin [russoka] sent command [kick] with payload [dib]
[Mon Nov 05 07:43:29 2012] [                GAME: test garena] deleting player [dibaeff]: was kicked by player [russoka]

[Mon Nov 05 07:43:37 2012] [                GAME: test garena] player [dibaeff(87.224.223.60|RU)] has joined from [LAN] Russia TD Room 11 (1.26a)

Database: [You must be registered and logged in to see this link.]

Bans on garena not working.

You got trigger works, but maybe bot + gcb need to be reset.

1st option:
no idea, but you can join my bots with a garena nickname which is other than your own (russoka), download a map & leave immediately after finishing the download to trigger the ban & see if you can rejoin

2nd option:
You can easily test it via LAN, you pick some names from db and enter with each of those name to join through NORMAL Lan (as you're using gcb, you should be able to join on Lan without having to turn on Garena), check if you can join with those name and read ghostlog to see.

P/S: just out of curiosity, can you search your 1 day hosting ghostlog for
"through LAN" if found >> it should be ... is trying to join the game through LAN but is name banned (gcbi detected ... is always found above this line with the exact IP of the player was getting banned)

banned by name >> it should be .... is trying to join the game but is banned by name ( no gcbi for the banned player's IP found above this line)

TELL ME how many results you get for each of those ban msg ?

Those msgs appear on my log so often. And for sure, through LAN is always Garena ppls that can't join the game. I've not seen anything wrong with this (for example, a player tried to join on bnet server but the log says "through LAN")

2. I can not join from normal lan with GCB. GCB blocked 6112 port.

I found too much "through LAN" in log. May be problem with refresh info. So Bans working.

Solved (hope has finally).

can you test !ff command in Dota games? My bots never host Dota, I can't test that.

I'm not played on DOTA. Only TTW.

Code:

[Mon Nov 05 23:42:36 2012] [            GAME: TTW for ALL #21] (00:36) [Team: 1] [All] [russoka]: !ban hy иди нахуй
[Mon Nov 05 23:42:36 2012] [            GAME: TTW for ALL #21] admin [russoka] sent command [ban] with payload [hy иди нахуй]
[Mon Nov 05 23:42:36 2012] [            GAME: TTW for ALL #21] player [HY33] was banned by player [russoka]
[Mon Nov 05 23:42:36 2012] [            GAME: TTW for ALL #21] [Local]: Player [HY33 (77.35.193.10)] was banned by player [russoka] for the next [30] days.
[Mon Nov 05 23:42:36 2012] [            GAME: TTW for ALL #21] [Local]: Ban reason: иди нахуй
[Mon Nov 05 23:42:36 2012] [                      LOCAL: XPAM] /w HY33 You have been banned, иди нахуй
[Mon Nov 05 23:42:37 2012] [                      ERROR: XPAM] That user is not logged on.
[Mon Nov 05 23:42:40 2012] [            GAME: TTW for ALL #21] (00:39) [Team: 1] [All] [russoka]: !kick hy
[Mon Nov 05 23:42:40 2012] [            GAME: TTW for ALL #21] admin [russoka] sent command [kick] with payload [hy]
[Mon Nov 05 23:42:40 2012] [            GAME: TTW for ALL #21] deleting player [HY33]: was kicked by player [russoka]
[Mon Nov 05 23:42:40 2012] [            GAME: TTW for ALL #21] [Local]: HY33 was kicked by player [russoka].

[Mon Nov 05 23:42:58 2012] [                            GCBI] Garena user detected; userid=12194355, roomid=196802, RoomName=Russia TD Room 01 (1.26a), experience=29, country=RU
[Mon Nov 05 23:42:58 2012] [            GAME: TTW for ALL #25] player [HY33(77.35.193.10|RU)] has joined from [LAN] Russia TD Room 01 (1.26a)

[Mon Nov 05 23:45:10 2012] [            GAME: TTW for ALL #25] deleting player [HY33]: was kicked by player [ghost]

[Mon Nov 05 23:45:38 2012] [                            GCBI] Garena user detected; userid=12194355, roomid=196802, RoomName=Russia TD Room 01 (1.26a), experience=29, country=RU
[Mon Nov 05 23:45:38 2012] [            GAME: TTW for ALL #29] player [HY33(77.35.193.10|RU)] has joined from [LAN] Russia TD Room 01 (1.26a)

[Mon Nov 05 23:46:01 2012] [                      UDPCMDSOCK] Relaying cmd [!refresh] to server [server.eurobattle.net]
[Mon Nov 05 23:46:01 2012] [                      WSPR: XPAM] [russoka] !refresh
[Mon Nov 05 23:46:01 2012] [                      BNET: XPAM] admin [russoka] sent command [!refresh]
[Mon Nov 05 23:46:01 2012] [                      BNET: XPAM] refreshed ban list (1 -> 2 bans)
[Mon Nov 05 23:46:03 2012] [                      UDPCMDSOCK] Relaying cmd [!refresh] to server [server.eurobattle.net]
[Mon Nov 05 23:46:03 2012] [                      WSPR: XPAM] [russoka] !refresh
[Mon Nov 05 23:46:03 2012] [                      BNET: XPAM] admin [russoka] sent command [!refresh]
[Mon Nov 05 23:46:03 2012] [                      BNET: XPAM] refreshed ban list (2 -> 2 bans)

[Mon Nov 05 23:47:00 2012] [            GAME: TTW for ALL #29] player [HY33] finished loading in 17.24 seconds
[Mon Nov 05 23:47:11 2012] [            GAME: TTW for ALL #29] non-admin [HY33] sent command [ban] with payload []
[Mon Nov 05 23:47:36 2012] [            GAME: TTW for ALL #29] [Local]: Shortest load by player [HY33] was 17.24 seconds.
[Mon Nov 05 23:47:45 2012] [            GAME: TTW for ALL #29] (00:09) [Team: 2] [Allies] [HY33]: !ban
[Mon Nov 05 23:47:45 2012] [            GAME: TTW for ALL #29] non-admin [HY33] sent command [ban] with payload []
[Mon Nov 05 23:47:56 2012] [            GAME: TTW for ALL #29] deleting player [HY33]: was kicked by player [ghost]
[Mon Nov 05 23:47:56 2012] [            GAME: TTW for ALL #29] [Local]: HY33 was kicked by player [ghost].

[Mon Nov 05 23:48:18 2012] [            GAME: TTW for ALL #35] player [HY33(77.35.193.10)] is trying to join the game through LAN but is name banned
[Mon Nov 05 23:48:19 2012] [            GAME: TTW for ALL #35] player [HY33(77.35.193.10)] is trying to join the game through LAN but is name banned
[Mon Nov 05 23:48:20 2012] [            GAME: TTW for ALL #35] player [HY33(77.35.193.10)] is trying to join the game through LAN but is name banned
... 55 matches

Seems like !refresh not working automatically.

It's always working automatically. Default GhostOne code (3600 is a ghostone default figure) for that.

Code:


in bnet.cpp
// refresh the ban list every 60 minutes (3600s)
   if( !m_CallableBanList && GetTime( ) >= m_LastBanRefreshTime + 3600 )

You shouldn't rush it for small figure. It's fancy if we make it to small figure and every instance of ghost.exe will consume too much memory, SQL couldn't handle too many connections unless you allow like 10000 connections or more at a time. My attempts to take a record of ban list in game_base.cpp haven't been successful yet. Bots must connect to at least a bnet server for checking ban on Lan (which is lame in my opinion, but they programmed ghost++ like that before all of my work). I believe it's the same to all Ghost++ out there. Only Garena HostBot seems to do that task well but they never share the source code. I only have [You must be registered and logged in to see this link.] for [You must be registered and logged in to see this link.].

See r98, I commented the part of the improvised code b'cuz of a lot of SQL database errors with bot, I think it must have hanged the program.

EDIT: 5 mins is okay but still it's not a real-time update ban list from the database, pychop also uses 5 mins but they have functions about Update() separately placed in chop.cpp which there could be a plenty of advantages modifying the bot to not rely on bnet server

and the command you did is exactly this one in bnet.cpp
/w botname !refesh, right?

Code:

//
            // !RB (Refreshes Banlist)
            // !REFRESH
            //

            if( Command == "rb" || Command == "refresh")
            {
               m_LastBanRefreshTime = GetTime() - 3600;
               m_LastAdminRefreshTime = GetTime() - 300;
            }