My Community

Archive => EN [x30] Archive => Archive => Bug Reports => Topic started by: Labas on January 10, 2010, 08:56:35 PM

Title: Clan/pvp/castles status on web
Post by: Labas on January 10, 2010, 08:56:35 PM
Its just for me or no1 can see the lists on web for some time already?
Tried opera, explorer and wap on mobile.
Title: Re: Clan/pvp/castles status on web
Post by: trollencio on January 10, 2010, 09:07:57 PM
Yep some problem, sometimes load others not
Title: Re: Clan/pvp/castles status on web
Post by: ..MinDiuSe.. on January 10, 2010, 09:35:14 PM
no they doesn't load for weeks
Title: Re: Clan/pvp/castles status on web
Post by: Deathwish on January 11, 2010, 10:15:44 AM
Quote from: ..MinDiuSe.. on January 10, 2010, 09:35:14 PM
no they doesn't load for weeks

No, sometimes and i mean about once an hour it loads
Title: Re: Clan/pvp/castles status on web
Post by: ve3k on January 12, 2010, 11:04:24 PM
java scripts dont laod informations, when u have peak time on server, it uses same database for reportas as it does for server items :)
Title: Re: Clan/pvp/castles status on web
Post by: kornes on January 12, 2010, 11:48:33 PM
Quote from: ve3k on January 12, 2010, 11:04:24 PM
java scripts dont laod informations, when u have peak time on server, it uses same database for reportas as it does for server items :)
Fail a bit, cuz there are not any js ;d
Also, it would be the biggest failure ever to allow connection to server db from outside hosts... especially from php script xD
Title: Re: Clan/pvp/castles status on web
Post by: ve3k on January 13, 2010, 12:03:48 AM
itis external program, based on scripts, making querries in database
Title: Re: Clan/pvp/castles status on web
Post by: kornes on January 13, 2010, 12:36:14 AM
Quote from: ve3k on January 13, 2010, 12:03:48 AM
itis external program, based on scripts, making querries in database
Dont rly know what u meant, but ur suggestion isn't looks rly secure and optimized ;p
imo this script should works like this:
- host with game server db should do localy dump (for ex. once a day) of some needed table to txt file.
- this file should be accessible from local network
- web server, through simple php script should get content of this file and show information on web page.

its most secure and optimized solution ;p
Title: Re: Clan/pvp/castles status on web
Post by: Corkscreewe on January 13, 2010, 01:22:50 AM
best solution is to disable it all and keep only rename / ban lists and such
Title: Re: Clan/pvp/castles status on web
Post by: Bubbleh on January 13, 2010, 01:23:50 AM
and castle status
i always forget where i sign with alt clan to farm some fame
Title: Re: Clan/pvp/castles status on web
Post by: Tiax on January 13, 2010, 10:15:47 PM
I bet it's not even cached results but live queries.

QuoteAlso, it would be the biggest failure ever to allow connection to server db from outside hosts... especially from php script xD
doubt they got their own datacenter/hosting on same network..

rpg-club.net resolves to: 217.16.16.123
server's ip was smth with 77.*


Title: Re: Clan/pvp/castles status on web
Post by: kornes on January 13, 2010, 10:31:13 PM
maybe its failover ip ;p
but prolly that was like u said live query and they just disable that ranks to reduced db traffic.
Title: Re: Clan/pvp/castles status on web
Post by: Tiax on January 14, 2010, 02:34:53 AM
Which makes the item lags and spikes during peak times no real surprise ::)