1. Соблюдайте Правила форума и проявляйте уважение к другим участникам беседы.

Проблема со статистикой. max_user_connections

Тема в разделе 'Запуск и Поддержка', создана пользователем shergin, 28 окт 2010.

  1. fake Старожила

    Сообщения:
    1.624
    Спасибы:
    19
    Дата начала использования бота:
    11.11.11
    скинь лог скорее всего таже трабла что и с сайтом .т.е превышен max_user_connections
  2. shergin Ньюфаг

    Сообщения:
    25
    Спасибы:
    0
    Лог бота? Если бота мне не ясно что Вы там сможете увидить.

    Но вот:
    Код:
       BNET: war3.alkar.net] refreshed ban list (0 -> 20 bans)
    [             BNET: war3.alkar.net] connecting to server [war3.alkar.net] on port 6112
    [             BNET: war3.alkar.net] resolved and cached server IP address 195.248.176.100
    [             BNET: war3.alkar.net] connected
    [             BNET: war3.alkar.net] using custom exe version bnet_custom_exeversion = 243 4 24 1
    [             BNET: war3.alkar.net] using custom exe version hash bnet_custom_exeversionhash = 197 67 68 222
    [             BNET: war3.alkar.net] attempting to auth as Warcraft III: The Frozen Throne
    [             BNET: war3.alkar.net] cd keys accepted
    [             BNET: war3.alkar.net] username [17ka] accepted
    [             BNET: war3.alkar.net] using pvpgn logon type (for pvpgn servers only)
    [             BNET: war3.alkar.net] logon successful
    [             BNET: war3.alkar.net] joining channel [16kakanal]
    [             BNET: war3.alkar.net] joined channel [16kakanal]
    [             INFO: war3.alkar.net] you are now tempOP for this channel
    [             INFO: war3.alkar.net] Internet - Optima Telecom http://optima.ua/
    [             INFO: war3.alkar.net] Games - http://games.alkar.net/
    [             INFO: war3.alkar.net] Games FORUM (FAQ, help) - http://games.alkar.net/phpBB/
    [             INFO: war3.alkar.net]  
    [             INFO: war3.alkar.net] Hello 17ka, welcome to a Alkar Teleport WarCraft III Server!
    [             INFO: war3.alkar.net]  
    [             INFO: war3.alkar.net] There are 25782 user accounts on this server.
    [             INFO: war3.alkar.net] There are currently 2299 users online in 485 games and 158 channels.
    [             INFO: war3.alkar.net] Having trouble with a command?  Type   /help   to
    [             INFO: war3.alkar.net] learn more about it.
    [             INFO: war3.alkar.net]  
    [             INFO: war3.alkar.net] Now supported WarCraft III: The Frozen Throne v1.24e
    [                       UDPCMDSOCK] Relaying cmd [!pub 1x1 apemom by 16ka-autohsot] to server [war3.alkar.net]
    [             WSPR: war3.alkar.net] [16ka] !pub 1x1 apemom by 16ka-autohsot
    [             BNET: war3.alkar.net] admin [16ka] sent command [!pub 1x1 apemom by 16ka-autohsot]
    
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [                       UDPCMDSOCK] Relaying cmd [!map 6.69.w3x] to server [war3.alkar.net]
    [             WSPR: war3.alkar.net] [16ka] !map 6.69.w3x
    [             BNET: war3.alkar.net] admin [16ka] sent command [!map 6.69.w3x]
    
    [                              MAP] loading MPQ file [C:\Program Files\WarCraft III DE\Maps\Download\DotA v6.69.w3x]
    [                              MAP] calculated map_size = 154 43 119 0
    [                              MAP] calculated map_info = 36 125 44 84
    [                              MAP] calculated map_crc = 147 62 5 175
    [                              MAP] calculated map_sha1 = 207 82 86 241 185 107 191 13 11 3 58 18 193 149 18 188 215 126 127 207
    [                              MAP] calculated map_options = 96
    [                              MAP] calculated map_width = 118 0
    [                              MAP] calculated map_height = 120 0
    [                              MAP] calculated map_numplayers = 10
    [                              MAP] calculated map_numteams = 2
    [                              MAP] found 10 slots
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [                       UDPCMDSOCK] Relaying cmd [!pub 1x1 apemom by 16ka-autohsot] to server [war3.alkar.net]
    [             WSPR: war3.alkar.net] [16ka] !pub 1x1 apemom by 16ka-autohsot
    [             BNET: war3.alkar.net] admin [16ka] sent command [!pub 1x1 apemom by 16ka-autohsot]
    [                            GHOST] creating game [1x1 apemom by 16ka-autohsot]
    [           GAME: 1x1 apemom by 16ka-autohsot] loading IP blacklist file [ipblacklist.txt]
    [           GAME: 1x1 apemom by 16ka-autohsot] loaded 635 lines from IP blacklist file
    [           GAME: 1x1 apemom by 16ka-autohsot] attempting to bind to all available addresses
    [           GAME: 1x1 apemom by 16ka-autohsot] listening on port 6113
    
    [           GAME: 1x1 apemom by 16ka-autohsot] player [.mouz] joined the game
    [                            GHOST] received remote command [close] with payload [2 3 4 5]
    [           GAME: 1x1 apemom by 16ka-autohsot] admin [.mouz] sent command [close] with payload [2 3 4 5]
    [                            GHOST] received remote command [close] with payload [7 8 9 10]
    [           GAME: 1x1 apemom by 16ka-autohsot] admin [.mouz] sent command [close] with payload [7 8 9 10]
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] player [Neeks] joined the game
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    
    
    
    
    
    [                            GHOST] received remote command [start] with payload [5]
    [           GAME: 1x1 apemom by 16ka-autohsot] admin [.mouz] sent command [start] with payload [5]
    [                            GHOST] received remote command [p] with payload []
    [           GAME: 1x1 apemom by 16ka-autohsot] admin [.mouz] sent command [p] with payload []
    [           GAME: 1x1 apemom by 16ka-autohsot] started loading with 2 players
    [             BNET: war3.alkar.net] joining channel [16kakanal]
    [             BNET: war3.alkar.net] joined channel [16kakanal]
    [             INFO: war3.alkar.net] you are now tempOP for this channel
    [           GAME: 1x1 apemom by 16ka-autohsot] player [Neeks] finished loading in 6.63 seconds
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] player [.mouz] finished loading in 20.28 seconds
    [           GAME: 1x1 apemom by 16ka-autohsot] finished loading with 2 players
    [                        GHost One] Game 1x1 apemom by 16ka-autohsot loaded, maptype=
    [                        GHost One] Neeks is on slot 1
    [                        GHost One] Auto running modes for 
    [                            GHOST] reserving players from [1x1 apemom by 16ka-autohsot] for next game
    
    
    [           GAME: 1x1 apemom by 16ka-autohsot] loading gameloaded.txt
    
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 45% = 50 ms=110-60 sync=8.0% - .mouz
    
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 50% = 55 ms=110-55 sync=16.0% - Neeks
    
    
    
    
    
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 54% = 60 ms=110-50 sync=16.0% - .mouz
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 58% = 64 ms=110-46 sync=16.0% - .mouz
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 61% = 68 ms=110-42 sync=16.0% - Neeks
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 58% = 64 ms=110-46 sync=8.0% - .mouz
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 64% = 71 ms=110-39 sync=16.0% - .mouz
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 63% = 70 ms=110-40 sync=16.0% - .mouz
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 71% = 79 ms=110-31 sync=16.0% - .mouz
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 71% = 79 ms=110-31 sync=16.0% - .mouz
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 80% = 88 ms=110-22 sync=25.0% - Neeks
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 77% = 85 ms=110-25 sync=16.0% - .mouz
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 80% = 88 ms=110-22 sync=33.0% - .mouz
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 76% = 84 ms=110-26 sync=16.0% - .mouz
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 77% = 85 ms=110-25 sync=16.0% - .mouz
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 75% = 83 ms=110-27 sync=16.0% - .mouz
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 80% = 89 ms=110-21 sync=25.0% - Neeks
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    
    
    
    [           GAME: 1x1 apemom by 16ka-autohsot] [Local]: !bl leaver
    [                            GHOST] received remote command [bl] with payload [leaver]
    [           GAME: 1x1 apemom by 16ka-autohsot] admin [.mouz] sent command [bl] with payload [leaver]
    [           GAME: 1x1 apemom by 16ka-autohsot] player [Neeks] was banned by player [.mouz]
    
    
    
    [           GAME: 1x1 apemom by 16ka-autohsot] [Local]: !end
    [                            GHOST] received remote command [end] with payload []
    [           GAME: 1x1 apemom by 16ka-autohsot] admin [.mouz] sent command [end] with payload []
    [           GAME: 1x1 apemom by 16ka-autohsot] is over (admin ended game)
    
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 70% = 77 ms=110-33 sync=8.0% - .mouz
    [           GAME: 1x1 apemom by 16ka-autohsot] [Local]: 5. . .
    [           GAME: 1x1 apemom by 16ka-autohsot] [Local]: 4. . .
    [           GAME: 1x1 apemom by 16ka-autohsot] [Local]: 3. . .
    [         GAME: GHost++ Admin Game] Dynamic latency at 45% = 50 ms=110-60 sync=0.0% - 
    [           GAME: 1x1 apemom by 16ka-autohsot] [Local]: 2. . .
    [           GAME: 1x1 apemom by 16ka-autohsot] [Local]: 1. . .
    [           GAME: 1x1 apemom by 16ka-autohsot] Dynamic latency at 70% = 78 ms=110-32 sync=16.0% - .mouz
    
    [           GAME: 1x1 apemom by 16ka-autohsot] is over (no players left)
    [           GAME: 1x1 apemom by 16ka-autohsot] saving game data to database
    [                            GHOST] deleting game [1x1 apemom by 16ka-autohsot]
    
    
    [           GAME: 1x1 apemom by 16ka-autohsot] saving player/stats data to database
    [             INFO: war3.alkar.net] No one hears you.
  3. fake Старожила

    Сообщения:
    1.624
    Спасибы:
    19
    Дата начала использования бота:
    11.11.11
    на сколько я помню,судя по логу с ботом всё норм, проверь есть ли после игры в базе нифа?
  4. Zarj Старожила

    Сообщения:
    1.007
    Спасибы:
    23
    Сборка бота GHost:
    Ghost One 1.7.266
    Дата начала использования бота:
    01.01.1992
    Ты нам не показал кусок лога где бот коннектится к мускулу!
  5. shergin Ньюфаг

    Сообщения:
    25
    Спасибы:
    0

    В базе заполняется только:
    bans,downloads (не важно), gameplayers (что интересно в поле elopoint везде по 0),games, heroes .


    А про лог коннекта к БД лог найти немогу
  6. fake Старожила

    Сообщения:
    1.624
    Спасибы:
    19
    Дата начала использования бота:
    11.11.11
    а чито ты с лимитом сделал скажи?
  7. shergin Ньюфаг

    Сообщения:
    25
    Спасибы:
    0
    Да в общем целом и ничего.


    Собственно дело такое - добровольцу дам доступ к БД и к сайту, если тот захочет помочь.


    UPD: На оф.форуме ответа до сих пор тоже нет
  8. shergin Ньюфаг

    Сообщения:
    25
    Спасибы:
    0
    Так что пишите в приват, дам попробывать на своем боте статистику, возможно у Вас заработает и тогда найти смогу свою причину.
  9. shergin Ньюфаг

    Сообщения:
    25
    Спасибы:
    0
    Только что получилось с бота имортировать с Sqlite - Rest где было список игроков...но там видно что они даже не от моего хоста.