Raised This Month: $ Target: $400
 0% 

[ANY] Server Redirect - A full featured server listing/hoper (v0.2.6, 24/01/2016)


Post New Thread Reply   
AlliedModders Forum Index > SourceMod > Plugins > Plugins
Page 38 of 49 « First 283637 38 394048 Last »
 
Thread Tools Display Modes
EMKO
Junior Member
Join Date: Jan 2016
Old 01-20-2016 , 03:53   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.5, 29/12/2015)
Reply With Quote #371
Quote:
Originally Posted by h3bus View Post
Sent you that debug version, please let me know what it says!

@primofernando I can send it to you too, request me by PM!
where do i find what it says? logs show nothing
also again i set players 0 and 10 seconds
only time ad displays is when i type !hop seems like the timer does not execute the ad its self or update the database.

i am running it "Server Redirect" (0.2.6_DBG) by H3bus
Last edited by EMKO; 01-20-2016 at 03:54.
EMKO is offline
h3bus
AlliedModders Donor
Join Date: Nov 2013
Old 01-20-2016 , 03:56   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.5, 29/12/2015)
Reply With Quote #372
Should log a lot of stuf in sourcemod logs :/

Edit: addons/sourcemod/logs/LXXXXXXX.log
Last edited by h3bus; 01-20-2016 at 03:58.
h3bus is offline
EMKO
Junior Member
Join Date: Jan 2016
Old 01-20-2016 , 03:57   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.5, 29/12/2015)
Reply With Quote #373
Quote:
Originally Posted by h3bus View Post
Should log a lot of stuf in sourcemod logs :/
found it in a different log

Code:
L 01/20/2016 - 08:50:21: [redirect.smx] database_GeneralCallback: Database success on query: DELETE FROM `redirect_follow` WHERE time < (NOW() - INTERVAL 1 DAY)

L 01/20/2016 - 08:50:21: World triggered "Round_Start"

L 01/20/2016 - 08:50:21: [mapchooser_extended.smx] Loaded map list for csgo.

L 01/20/2016 - 08:50:21: [redirect.smx] database_GeneralCallback: Database success on query: DELETE FROM `redirect_servers` WHERE refresh_failures > 10 AND last_online < (NOW() - INTERVAL 20 MINUTE)

UTIL_GetListenServerHost() called from a dedicated server or single-player game.

L 01/20/2016 - 08:50:21: [redirect.smx] database_GeneralCallback: Database success on query: INSERT INTO `redirect_servers` (ip, query_ip, query_ip_for_groups, last_online, refresh_failures, short_hostname, my_groups, show_in_groups, expose_pw_for_groups, advertise_in_groups, advertise_min_players, advertise_min_slots, game, `order`, pw, rcon_pw) VALUES ('162.248.88.212:27025', '', '', NOW(), 0, 'Chicago Aim DeathMatch', 'A', 'A', '', 'A', 0, 0, 'csgo', 1, '', '') ON DUPLICATE KEY UPDATE query_ip = VALUES(query_ip), query_ip_for_groups = VALUES(query_ip_for_groups), refresh_failures = VALUES(refresh_failures), short_hostname = VALUES(short_hostname), my_groups = VALUES(my_groups), show_in_groups = VALUES(show_in_groups), expose_pw_for_groups = VALUES(expose_pw_for_groups), advertise_in_groups = VALUES(advertise_in_groups), advertise_min_players = VALUES(advertise_min_players), advertise_min_slots = VALUES(advertise_min_slots), game = VALUES(game), `order` = VALUES(`order`), pw = VALUES(pw), rcon_pw = VALUES(L 01/20/2016 - 08:50:21: [redirect.smx] database_GeneralCallback: Database success on query: UPDATE `redirect_follow` SET state = 'confirmed', time = NOW() WHERE steam = 'STEAM_1:1:9265743' AND time BETWEEN NOW() - INTERVAL 2 MINUTE AND NOW()

L 01/20/2016 - 08:50:21: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:50:21: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:50:21: [redirect.smx] database_GeneralCallback: Database success on query: SELECT f.steam,f.name, IF(s.query_ip != '' AND s.query_ip_for_groups REGEXP '[A]', s.query_ip, s.ip) AS server, s.rcon_pw FROM `redirect_follow` f INNER JOIN `redirect_servers` s WHERE s.ip = f.server AND f.steam = 'STEAM_1:1:9265743' AND f.state = 'confirmed'

L 01/20/2016 - 08:50:21: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:50:21: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:50:22: World triggered "Restart_Round_(1_second)"

L 01/20/2016 - 08:50:22: Team "CT" scored "0" with "0" players

L 01/20/2016 - 08:50:22: Team "TERRORIST" scored "0" with "0" players

EVERYONE CAN BUY!

L 01/20/2016 - 08:50:23: World triggered "Match_Start" on "workshop/122443683/aim_map"

L 01/20/2016 - 08:50:23: World triggered "Round_Start"

L 01/20/2016 - 08:50:24: "EMKO<7><STEAM_1:1:9265743><>" entered the game

L 01/20/2016 - 08:50:24: "EMKO<7><STEAM_1:1:9265743><Unassigned>" triggered "clantag" (value "EAZY.GG")

L 01/20/2016 - 08:50:25: "EMKO<7><STEAM_1:1:9265743>" switched from team <Unassigned> to <CT>

L 01/20/2016 - 08:50:25: World triggered "Game_Commencing"

L 01/20/2016 - 08:50:25: "EMKO<7><STEAM_1:1:9265743><CT>" triggered "clantag" (value "EAZY.GG")

EVERYONE CAN BUY!

L 01/20/2016 - 08:50:25: World triggered "Match_Start" on "workshop/122443683/aim_map"

L 01/20/2016 - 08:50:25: Team playing "CT": EAZY.GG

L 01/20/2016 - 08:50:27: World triggered "Round_Start"

EVERYONE CAN BUY!

L 01/20/2016 - 08:50:30: World triggered "Match_Start" on "workshop/122443683/aim_map"

L 01/20/2016 - 08:50:30: Team playing "CT": EAZY.GG

L 01/20/2016 - 08:50:30: World triggered "Round_Start"

L 01/20/2016 - 08:50:31: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:50:31: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:50:31: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:50:41: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:50:41: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:50:41: [redirect.smx] database_GeneralCallback: plugin callback returned

EMKO: !hop

L 01/20/2016 - 08:50:48: "EMKO<7><STEAM_1:1:9265743><CT>" say "!hop"

L 01/20/2016 - 08:50:48: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date, hostname,short_hostname,private,players,bots,maxplayers,map,pw, (expose_pw_for_groups REGEXP '[A]') as expose_pw FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND show_in_groups REGEXP '[A]' AND (refresh_failures <= 10 OR last_online >= (NOW() - INTERVAL 20 MINUTE)) ORDER BY `order`

L 01/20/2016 - 08:50:48: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:50:48: [redirect.smx] a2s_queryServer: 162.248.88.212:27045 on IP 162.248.88.212:27045

L 01/20/2016 - 08:50:48: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:50:49: [redirect.smx] A2S success on server 162.248.88.212:27045, map: am_crashz_dust_v2, players: 0, bots: 0, maxplayers: 24

L 01/20/2016 - 08:50:49: [redirect.smx] database_GeneralCallback: Database success on query: UPDATE `redirect_servers` SET hostname = 'Eazy.GG | Chicago | 1v1 Multi-Arena | Stats + Drops | 128 Tick', private = 0, players = 0, bots = 0, maxplayers = 24, map = 'am_crashz_dust_v2', last_online = NOW(), refresh_failures = 0, last_refresh = NOW() WHERE ip = '162.248.88.212:27045'

L 01/20/2016 - 08:50:51: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:50:51: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:50:51: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:51:01: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:51:01: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:51:01: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:51:11: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:51:11: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:51:11: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:51:21: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:51:21: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:51:21: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:51:31: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:51:31: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:51:31: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:51:41: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:51:41: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:51:41: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:51:51: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:51:51: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:51:51: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:52:01: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:52:01: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:52:01: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:52:11: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:52:11: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:52:11: [redirect.smx] database_GeneralCallback: plugin callback returned

EMKO: !hop

L 01/20/2016 - 08:52:12: "EMKO<7><STEAM_1:1:9265743><CT>" say "!hop"

L 01/20/2016 - 08:52:12: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date, hostname,short_hostname,private,players,bots,maxplayers,map,pw, (expose_pw_for_groups REGEXP '[A]') as expose_pw FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND show_in_groups REGEXP '[A]' AND (refresh_failures <= 10 OR last_online >= (NOW() - INTERVAL 20 MINUTE)) ORDER BY `order`

L 01/20/2016 - 08:52:12: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:52:12: [redirect.smx] a2s_queryServer: 162.248.88.212:27045 on IP 162.248.88.212:27045

L 01/20/2016 - 08:52:12: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:52:12: [redirect.smx] A2S success on server 162.248.88.212:27045, map: am_crashz_dust_v2, players: 0, bots: 0, maxplayers: 24

L 01/20/2016 - 08:52:12: [redirect.smx] database_GeneralCallback: Database success on query: UPDATE `redirect_servers` SET hostname = 'Eazy.GG | Chicago | 1v1 Multi-Arena | Stats + Drops | 128 Tick', private = 0, players = 0, bots = 0, maxplayers = 24, map = 'am_crashz_dust_v2', last_online = NOW(), refresh_failures = 0, last_refresh = NOW() WHERE ip = '162.248.88.212:27045'

EMKO: !hop

L 01/20/2016 - 08:52:18: "EMKO<7><STEAM_1:1:9265743><CT>" say "!hop"

L 01/20/2016 - 08:52:18: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date, hostname,short_hostname,private,players,bots,maxplayers,map,pw, (expose_pw_for_groups REGEXP '[A]') as expose_pw FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND show_in_groups REGEXP '[A]' AND (refresh_failures <= 10 OR last_online >= (NOW() - INTERVAL 20 MINUTE)) ORDER BY `order`

L 01/20/2016 - 08:52:18: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:52:18: [redirect.smx] a2s_queryServer: 162.248.88.212:27045 on IP 162.248.88.212:27045

L 01/20/2016 - 08:52:18: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:52:18: [redirect.smx] A2S success on server 162.248.88.212:27045, map: am_crashz_dust_v2, players: 0, bots: 0, maxplayers: 24

L 01/20/2016 - 08:52:18: [redirect.smx] database_GeneralCallback: Database success on query: UPDATE `redirect_servers` SET hostname = 'Eazy.GG | Chicago | 1v1 Multi-Arena | Stats + Drops | 128 Tick', private = 0, players = 0, bots = 0, maxplayers = 24, map = 'am_crashz_dust_v2', last_online = NOW(), refresh_failures = 0, last_refresh = NOW() WHERE ip = '162.248.88.212:27045'

L 01/20/2016 - 08:52:21: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:52:21: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:52:21: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:52:31: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:52:31: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:52:31: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:52:41: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:52:41: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:52:41: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:52:51: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:52:51: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:52:51: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:53:01: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:53:01: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:53:01: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:53:11: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:53:11: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:53:11: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:53:21: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:53:21: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:53:21: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:53:31: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:53:31: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:53:31: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:53:41: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:53:41: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:53:41: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:53:51: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:53:51: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:53:51: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:54:01: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:54:01: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:54:01: [redirect.smx] database_GeneralCallback: plugin callback returned

[SM] Listing 27 plugins:

  01 "Client Preferences" (1.7.3-dev+5289) by AlliedModders LLC

  02 "Reserved Slots" (1.7.3-dev+5289) by AlliedModders LLC

  03 "Basic Commands" (1.7.3-dev+5289) by AlliedModders LLC

  04 "Basic Info Triggers" (1.7.3-dev+5289) by AlliedModders LLC

  05 "Admin File Reader" (1.7.3-dev+5289) by AlliedModders LLC

  06 "Server Redirect: Ask connect in chat" (0.2.5) by H3bus

  07 "Map Nominations Extended" (1.10.0) by Powerlord and AlliedModders LLC

  08 "Admin Menu" (1.7.3-dev+5289) by AlliedModders LLC

  09 "Fun Commands" (1.7.3-dev+5289) by AlliedModders LLC

  10 "Admin Help" (1.7.3-dev+5289) by AlliedModders LLC

  11 "Server Advertisement" (2.5) by ESK0

  12 "SQL Admins (Threaded)" (1.7.3-dev+5289) by AlliedModders LLC

  13 "Basic Comm Control" (1.7.3-dev+5289) by AlliedModders LLC

  14 "Nextmap" (1.7.3-dev+5289) by AlliedModders LLC

  15 "Player Commands" (1.7.3-dev+5289) by AlliedModders LLC

  16 "MapChooser Extended" (1.10.2) by Powerlord, Zuko, and AlliedModders LLC

  17 "Basic Chat" (1.7.3-dev+5289) by AlliedModders LLC

  18 "Basic Votes" (1.7.3-dev+5289) by AlliedModders LLC

  19 "Sound Commands" (1.7.3-dev+5289) by AlliedModders LLC

  20 "Anti-Flood" (1.7.3-dev+5289) by AlliedModders LLC

  21 "Fun Votes" (1.7.3-dev+5289) by AlliedModders LLC

  22 "Rock The Vote Extended" (1.10.0) by Powerlord and AlliedModders LLC

  23 "SQL Admin Manager" (1.7.3-dev+5289) by AlliedModders LLC

  24 "Server Redirect: Ask connect in console" (0.2.5) by H3bus

  25 "Deathmatch" (0.13.7) by H3bus

  26 "Basic Ban Commands" (1.7.3-dev+5289) by AlliedModders LLC

  27 "Server Redirect" (0.2.6_DBG) by H3bus

L 01/20/2016 - 08:54:09: rcon from "68.145.147.149:60462": command "sm plugins list"

L 01/20/2016 - 08:54:11: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:54:11: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:54:11: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:54:21: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:54:21: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:54:21: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:54:31: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:54:31: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:54:31: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:54:41: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:54:41: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:54:41: [redirect.smx] database_GeneralCallback: plugin callback returned

L 01/20/2016 - 08:54:51: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

L 01/20/2016 - 08:54:51: [redirect.smx] database_GeneralCallback: calling plugin callback

L 01/20/2016 - 08:54:51: [redirect.smx] database_GeneralCallback: plugin callback returned
sorry is this what you are looking for?
Attached Files
File Type: log L20160120.log (74.9 KB, 98 views)
Last edited by EMKO; 01-20-2016 at 04:05.
EMKO is offline
EMKO
Junior Member
Join Date: Jan 2016
Old 01-20-2016 , 04:06   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.5, 29/12/2015)
Reply With Quote #374
sorry found the log forgot to refresh the ftp its 2 am here i posted the log file in last post
EMKO is offline
h3bus
AlliedModders Donor
Join Date: Nov 2013
Old 01-20-2016 , 04:16   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.5, 29/12/2015)
Reply With Quote #375
So first thing I can see is that your DB is updated right after A2S query (when server info is displayed the !hop menu):
Code:
L 01/20/2016 - 08:50:48: [redirect.smx] a2s_queryServer: 162.248.88.212:27045 on IP 162.248.88.212:27045
L 01/20/2016 - 08:50:48: [redirect.smx] database_GeneralCallback: plugin callback returned
L 01/20/2016 - 08:50:49: [redirect.smx] A2S success on server 162.248.88.212:27045, map: am_crashz_dust_v2, players: 0, bots: 0, maxplayers: 24
L 01/20/2016 - 08:50:49: [redirect.smx] database_GeneralCallback: Database success on query: UPDATE `redirect_servers` SET hostname = 'Eazy.GG | Chicago | 1v1 Multi-Arena | Stats + Drops | 128 Tick', private = 0, players = 0, bots = 0, maxplayers = 24, map = 'am_crashz_dust_v2', last_online = NOW(), refresh_failures = 0, last_refresh = NOW() WHERE ip = '162.248.88.212:27045'
Second thing is that I can see the database being requested for servers to advertise, but for some reasons, no A2S queries are output after that:
Code:
L 01/20/2016 - 08:50:41: [redirect.smx] database_GeneralCallback: Database success on query: SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip, (last_refresh BETWEEN NOW() - INTERVAL 5 SECOND AND NOW()) AS up_to_date,hostname,short_hostname,private,players,bots,maxplayers,map,advertise_min_players,advertise_min_slots FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`
L
This may be due to a setting or a bug.
To find out, can you send me e print screen (or dump) of the content of your table 'redirect_server'?

If I can't find anything there, I'll add some log to see what could be happening.
h3bus is offline
EMKO
Junior Member
Join Date: Jan 2016
Old 01-20-2016 , 04:53   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.5, 29/12/2015)
Reply With Quote #376
here is the dump of the table you wanted
Attached Files
File Type: zip redirect_servers.zip (925 Bytes, 142 views)
Last edited by EMKO; 01-20-2016 at 04:55.
EMKO is offline
h3bus
AlliedModders Donor
Join Date: Nov 2013
Old 01-20-2016 , 05:15   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.5, 29/12/2015)
Reply With Quote #377
Found nothing wrong, I've sent you a version with more debug info.
h3bus is offline
EMKO
Junior Member
Join Date: Jan 2016
Old 01-20-2016 , 05:25   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.5, 29/12/2015)
Reply With Quote #378
Quote:
Originally Posted by h3bus View Post
Found nothing wrong, I've sent you a version with more debug info.
new logs with new debug
Attached Files
File Type: log L20160120.log (15.1 KB, 97 views)
Last edited by EMKO; 01-20-2016 at 05:25.
EMKO is offline
h3bus
AlliedModders Donor
Join Date: Nov 2013
Old 01-20-2016 , 05:35   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.5, 29/12/2015)
Reply With Quote #379
Can you run this query:
Code:
SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`
ang give me the results? (Sorry there is something I just don't understand )
h3bus is offline
EMKO
Junior Member
Join Date: Jan 2016
Old 01-20-2016 , 05:52   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.5, 29/12/2015)
Reply With Quote #380
Quote:
Originally Posted by h3bus View Post
Can you run this query:
Code:
SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`
ang give me the results? (Sorry there is something I just don't understand )

[SQL]SELECT ip, IF(query_ip != '' AND query_ip_for_groups REGEXP '[A]', query_ip, ip) AS query_ip FROM `redirect_servers` WHERE ip!='162.248.88.212:27025' AND game='csgo' AND advertise_in_groups REGEXP '[A]' ORDER BY `order`

Affected rows: 0
Time: 0.032s

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

result is
ip 162.248.88.212:27045
query_ip 162.248.88.212:27045


just to make sure with you that when i do !hop with a low advertise time value like 10 seconds
i can force a ad to show up if i time it right is there something stoping a ad from showing?

for example i bind n "say !hop" spam it 10-15 times a Ad shows
Last edited by EMKO; 01-20-2016 at 05:55.
EMKO is offline
Reply
AlliedModders Forum Index > SourceMod > Plugins > Plugins
Page 38 of 49 « First 283637 38 394048 Last »

« Previous Thread | Next Thread »


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -4. The time now is 08:11.

DMCA - Archive - Top

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode