Clan Adverts

www.afgserv.com

www.clan-themes.co.uk :: View topic - BF2 Stats, Live on your website. Caution database problem!!

 Welcome To Clan Themes 

As the board grows please remember the Search Option and we hope you find our community useful.

We also monitor Private Messages to stop members from abusing our sites system.
If you are asking for assistance please provide your site link and nuke version, Thanks.
BF2 Stats, Live on your website. Caution database problem!!

5 Replies / 2218 Views
Post new topic   Reply to topic  

   www.clan-themes.co.uk Forum Index » Modules

View previous topic :: View next topic

OzButcher
Reputation: 464.4
Local time: 1:50 PM

australia.gif

 Status: Offline
0.24 posts per day
Medals: 1 (View more...)
Site Supporter (Amount: 1)

Joined: Jan 16, 2007
Last Visit: 26 Feb 2008
Posts: 164
Points: 250 
Post BF2 Stats, Live on your website. Caution database problem!! Posted: Fri Jun 01, 2007 3:03 pm   
Shop Purchases:Battlefield 2142 PhpNuke Theme (Aviator) · Clan Roster v1.7 Php Nuke Module · Battlefield 2142 X-Theme (Ultimate)
Hey guys,

I use the BF2 Stats module (not to be confused with the BF2 Clan stats module) which allows you and users to view their bf2 stats live on your website. Anyways... the other day when I was going through my SQL database I noticed a HUGE TABLE!! It was the BF2 stats TABLE!! It was about 30megs!! Confused Anyway... for some reason the version I have been using v2.12 doesn't seem to be cleaning the database properly as its supposed to and keeps adding entried when guests check their stats! So please check ur database if your using the same version. Our site feels like its quicker now?? But maybe its just me?

Here is a demo of the module in use on our site if ur not sure which one I mean:
http://www.burnt-clan.com/modules.php?name=BF2_Stats
 

 
View user's profileSend private messageVisit poster's websiteMSN Messenger Reply with quote

TB_DFW
Reputation: 468
Local time: 3:50 PM

blank.gif

 Status: Offline
0.04 posts per day
Medals: 0
Joined: Apr 09, 2007
Last Visit: 01 Dec 2008
Posts: 27
Points: 965 
Post Posted: Sat Jun 02, 2007 8:43 am   
Shop Purchases:Multi Gaming (Warrior) Theme
Yeh don't feel too bad Oz.. I just checked mine after reading this & it was 41,745Kb with 6382 Names!!! Emptied the entire table and re-entered all the players from the clan again! But yeh, my site definately feels like it's on speed now!
 

 
View user's profileSend private message Reply with quote

OzButcher
Reputation: 464.4
Local time: 1:50 PM

australia.gif

 Status: Offline
0.24 posts per day
Medals: 1 (View more...)
Site Supporter (Amount: 1)

Joined: Jan 16, 2007
Last Visit: 26 Feb 2008
Posts: 164
Points: 250 
View user's profileSend private messageVisit poster's websiteMSN Messenger Reply with quote


TB_DFW
Reputation: 468
Local time: 3:50 PM

blank.gif

 Status: Offline
0.04 posts per day
Medals: 0
Joined: Apr 09, 2007
Last Visit: 01 Dec 2008
Posts: 27
Points: 965 
Post Posted: Sun Jun 03, 2007 1:26 pm   
Shop Purchases:Multi Gaming (Warrior) Theme
Yeh thx Oz... I tried what Brady suggested, but then that stops any of the ID's entered in the admin panel from showing in the module which sort of defeats the purpose of having it... Oh well, looks like I'll have to post a reminder to clear every month or two!
 

 
View user's profileSend private message Reply with quote

OzButcher
Reputation: 464.4
Local time: 1:50 PM

australia.gif

 Status: Offline
0.24 posts per day
Medals: 1 (View more...)
Site Supporter (Amount: 1)

Joined: Jan 16, 2007
Last Visit: 26 Feb 2008
Posts: 164
Points: 250 
View user's profileSend private messageVisit poster's websiteMSN Messenger Reply with quote

TB_DFW
Reputation: 468
Local time: 3:50 PM

blank.gif

 Status: Offline
0.04 posts per day
Medals: 0
Joined: Apr 09, 2007
Last Visit: 01 Dec 2008
Posts: 27
Points: 965 
Post Posted: Mon Jun 04, 2007 12:30 am   
Shop Purchases:Multi Gaming (Warrior) Theme
Nah I've got the module - BF2 Tracker.. But it has the same effect. even tho the only names shown are the guys that play BF2 in DFW...

Yeh mine's back up to 670+ names & 3.7Mb in less than 48hrs after clearing it. Only thing i can think of is that it's recording all the queries sent through EA, cos I'm deleting the other entries as I type this and there's new entries showing.

http://www.steezmatic-designs.com/modules.php?name=Forums&file=viewtopic&p=2693#2693
 

 
View user's profileSend private message Reply with quote



Post new topic   Reply to topic  
   www.clan-themes.co.uk Forum Index » Modules


 
5 Replies / 2218 Views
Page 1 of 1
All times are GMT
Display posts from previous:   
 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum