Re: BF2 Server Status Module... [Module reviews]

41

Re: BF2 Server Status Module...

2006/1/17 23:25
talunceford
Just can't stay away
Posts: 532
Since: 2002/8/14

On some things yes, but luckily I grabbed about 6800 server ips via kquery before they tightened the ropes some. As far as the script itself, it works like a champ.

Tim
http://www.tswn.com | http://www.bf2online.com | aquaria.tswn.com | http://www.bf2142online.org

42

Re: BF2 Server Status Module...

2006/1/30 18:23
birdie
Just popping in
Posts: 10
Since: 2005/12/5

nice after quickly seeing the code, i can basically see how it works, not bad.

43

Re: BF2 Server Status Module...

2006/1/31 4:03
talunceford
Just can't stay away
Posts: 532
Since: 2002/8/14

Yeah, it works real well, but the biggest problem I have right now is the excecution time of the script. Being that the db is getting SOOOOOOO big it takes forever to display results. Any tips on speeding queries up?

Tim
http://www.tswn.com | http://www.bf2online.com | aquaria.tswn.com | http://www.bf2142online.org

44

Re: BF2 Server Status Module...

2006/1/31 16:46
birdie
Just popping in
Posts: 10
Since: 2005/12/5

hmm maybe u could index the servers in the MySQL database?

this might sound stupid but is there a set function which connects to the bf2 database.. i found it and lost it already

lol

thanks

45

Re: BF2 Server Status Module...

2006/2/1 13:19
talunceford
Just can't stay away
Posts: 532
Since: 2002/8/14

I don't think its the server list that is giving me the trouble. I am capturing player stats as well. Right now there are probably close to 400000 players that have been captured. I think that might be the problem. I need to look over the sql queries to see whats bogging them down. Hell it might be the fact that my db server is just too slow... who knows.

Tim
http://www.tswn.com | http://www.bf2online.com | aquaria.tswn.com | http://www.bf2142online.org

46

Re: BF2 Server Status Module...

2006/2/1 20:17
birdie
Just popping in
Posts: 10
Since: 2005/12/5

is the server dedicated? and what type are the tables that u saved them in?

Stats
Goal:	$100.00
Due Date:	Jun 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Re: BF2 Server Status Module...

Re: BF2 Server Status Module...

Re: BF2 Server Status Module...

Re: BF2 Server Status Module...

Re: BF2 Server Status Module...

Re: BF2 Server Status Module...

Login

Search

Recent Posts

Re: Combine AND/OR in a CriteriaCompo

Re: Test 3

Test 3

Re: Test2

Re: Test2

Re: Test2

Test2

Re: Xlanguage Module - Default Language Issue

Re: Xlanguage Module - Default Language Issue

Re: Xlanguage Module - Default Language Issue

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}