SOLUTION: RESET STATS

Can't get it installed? Not sure how a feature works? Then post here.

Was this helpful?

Yes
18
90%
No
2
10%
 
Total votes : 20

SOLUTION: RESET STATS

Postby Dan.W » 2007-03-03 08:32 am

I saw that alot of people want to reset their stats, heres how you do it:

- Go to phpMyAdmin or what ever you use
- Get to the topsites database
- Run the following SQL Query:

Code: Select all
UPDATE ats_stats SET rank_cache = 0,
rank_cache_time = 0,
old_rank = 0,
days_inactive = 0,
total_rating = 0,
num_ratings = 0,
unq_pv_overall = 0,
tot_pv_overall = 0,
unq_in_overall = 0,
tot_in_overall = 0,
unq_out_overall = 0,
tot_out_overall = 0,
unq_pv_0_daily = 0,
unq_pv_1_daily = 0,
unq_pv_2_daily = 0,
unq_pv_3_daily = 0,
unq_pv_4_daily = 0,
unq_pv_5_daily = 0,
unq_pv_6_daily = 0,
unq_pv_7_daily = 0,
unq_pv_8_daily = 0,
unq_pv_9_daily = 0,
unq_pv_max_daily = 0,
tot_pv_0_daily = 0,
tot_pv_1_daily = 0,
tot_pv_2_daily = 0,
tot_pv_3_daily = 0,
tot_pv_4_daily = 0,
tot_pv_5_daily = 0,
tot_pv_6_daily = 0,
tot_pv_7_daily = 0,
tot_pv_8_daily = 0,
tot_pv_9_daily = 0,
tot_pv_max_daily = 0,
unq_in_0_daily = 0,
unq_in_1_daily = 0,
unq_in_2_daily = 0,
unq_in_3_daily = 0,
unq_in_4_daily = 0,
unq_in_5_daily = 0,
unq_in_6_daily = 0,
unq_in_7_daily = 0,
unq_in_8_daily = 0,
unq_in_9_daily = 0,
unq_in_max_daily = 0,
tot_in_0_daily = 0,
tot_in_1_daily = 0,
tot_in_2_daily = 0,
tot_in_3_daily = 0,
tot_in_4_daily = 0,
tot_in_5_daily = 0,
tot_in_6_daily = 0,
tot_in_7_daily = 0,
tot_in_8_daily = 0,
tot_in_9_daily = 0,
tot_in_max_daily = 0,
unq_out_0_daily = 0,
unq_out_1_daily = 0,
unq_out_2_daily = 0,
unq_out_3_daily = 0,
unq_out_4_daily = 0,
unq_out_5_daily = 0,
unq_out_6_daily = 0,
unq_out_7_daily = 0,
unq_out_8_daily = 0,
unq_out_9_daily = 0,
unq_out_max_daily = 0,
tot_out_0_daily = 0,
tot_out_1_daily = 0,
tot_out_2_daily = 0,
tot_out_3_daily = 0,
tot_out_4_daily = 0,
tot_out_5_daily = 0,
tot_out_6_daily = 0,
tot_out_7_daily = 0,
tot_out_8_daily = 0,
tot_out_9_daily = 0,
tot_out_max_daily = 0,
unq_pv_0_weekly = 0,
unq_pv_1_weekly = 0,
unq_pv_2_weekly = 0,
unq_pv_3_weekly = 0,
unq_pv_4_weekly = 0,
unq_pv_5_weekly = 0,
unq_pv_6_weekly = 0,
unq_pv_7_weekly = 0,
unq_pv_8_weekly = 0,
unq_pv_9_weekly = 0,
unq_pv_max_weekly = 0,
tot_pv_0_weekly = 0,
tot_pv_1_weekly = 0,
tot_pv_2_weekly = 0,
tot_pv_3_weekly = 0,
tot_pv_4_weekly = 0,
tot_pv_5_weekly = 0,
tot_pv_6_weekly = 0,
tot_pv_7_weekly = 0,
tot_pv_8_weekly = 0,
tot_pv_9_weekly = 0,
tot_pv_max_weekly = 0,
unq_in_0_weekly = 0,
unq_in_1_weekly = 0,
unq_in_2_weekly = 0,
unq_in_3_weekly = 0,
unq_in_4_weekly = 0,
unq_in_5_weekly = 0,
unq_in_6_weekly = 0,
unq_in_7_weekly = 0,
unq_in_8_weekly = 0,
unq_in_9_weekly = 0,
unq_in_max_weekly = 0,
tot_in_0_weekly = 0,
tot_in_1_weekly = 0,
tot_in_2_weekly = 0,
tot_in_3_weekly = 0,
tot_in_4_weekly = 0,
tot_in_5_weekly = 0,
tot_in_6_weekly = 0,
tot_in_7_weekly = 0,
tot_in_8_weekly = 0,
tot_in_9_weekly = 0,
tot_in_max_weekly = 0,
unq_out_0_weekly = 0,
unq_out_1_weekly = 0,
unq_out_2_weekly = 0,
unq_out_3_weekly = 0,
unq_out_4_weekly = 0,
unq_out_5_weekly = 0,
unq_out_6_weekly = 0,
unq_out_7_weekly = 0,
unq_out_8_weekly = 0,
unq_out_9_weekly = 0,
unq_out_max_weekly = 0,
tot_out_0_weekly = 0,
tot_out_1_weekly = 0,
tot_out_2_weekly = 0,
tot_out_3_weekly = 0,
tot_out_4_weekly = 0,
tot_out_5_weekly = 0,
tot_out_6_weekly = 0,
tot_out_7_weekly = 0,
tot_out_8_weekly = 0,
tot_out_9_weekly = 0,
tot_out_max_weekly = 0,
unq_pv_0_monthly = 0,
unq_pv_1_monthly = 0,
unq_pv_2_monthly = 0,
unq_pv_3_monthly = 0,
unq_pv_4_monthly = 0,
unq_pv_5_monthly = 0,
unq_pv_6_monthly = 0,
unq_pv_7_monthly = 0,
unq_pv_8_monthly = 0,
unq_pv_9_monthly = 0,
unq_pv_max_monthly = 0,
tot_pv_0_monthly = 0,
tot_pv_1_monthly = 0,
tot_pv_2_monthly = 0,
tot_pv_3_monthly = 0,
tot_pv_4_monthly = 0,
tot_pv_5_monthly = 0,
tot_pv_6_monthly = 0,
tot_pv_7_monthly = 0,
tot_pv_8_monthly = 0,
tot_pv_9_monthly = 0,
tot_pv_max_monthly = 0,
unq_in_0_monthly = 0,
unq_in_1_monthly = 0,
unq_in_2_monthly = 0,
unq_in_3_monthly = 0,
unq_in_4_monthly = 0,
unq_in_5_monthly = 0,
unq_in_6_monthly = 0,
unq_in_7_monthly = 0,
unq_in_8_monthly = 0,
unq_in_9_monthly = 0,
unq_in_max_monthly = 0,
tot_in_0_monthly = 0,
tot_in_1_monthly = 0,
tot_in_2_monthly = 0,
tot_in_3_monthly = 0,
tot_in_4_monthly = 0,
tot_in_5_monthly = 0,
tot_in_6_monthly = 0,
tot_in_7_monthly = 0,
tot_in_8_monthly = 0,
tot_in_9_monthly = 0,
tot_in_max_monthly = 0,
unq_out_0_monthly = 0,
unq_out_1_monthly = 0,
unq_out_2_monthly = 0,
unq_out_3_monthly = 0,
unq_out_4_monthly = 0,
unq_out_5_monthly = 0,
unq_out_6_monthly = 0,
unq_out_7_monthly = 0,
unq_out_8_monthly = 0,
unq_out_9_monthly = 0,
unq_out_max_monthly = 0,
tot_out_0_monthly = 0,
tot_out_1_monthly = 0,
tot_out_2_monthly = 0,
tot_out_3_monthly = 0,
tot_out_4_monthly = 0,
tot_out_5_monthly = 0,
tot_out_6_monthly = 0,
tot_out_7_monthly = 0,
tot_out_8_monthly = 0,
tot_out_9_monthly = 0,
tot_out_max_monthly = 0;


All the stats should now be reset :D
Dan.W
Newbie
 
Posts: 4
Joined: 2005-11-06 04:37 am

Postby lordbdp » 2007-03-19 10:25 pm

If someone know how do this with a command line in the admin panel, it will so great :wink:
Donne et tu seras riche !
lordbdp
Member
 
Posts: 23
Joined: 2007-02-28 06:04 pm

Postby antman » 2007-03-20 02:14 am

Yes it was helpful, thank you :)
antman
Advanced Member
 
Posts: 75
Joined: 2006-04-30 08:47 am

Re: SOLUTION: RESET STATS

Postby misterjoker » 2007-03-21 03:00 am

Dan.W wrote:I saw that alot of people want to reset their stats, heres how you do it:

- Go to phpMyAdmin or what ever you use
- Get to the topsites database
- Run the following SQL Query:

Code: Select all
UPDATE ats_stats SET rank_cache = 0,
rank_cache_time = 0,
old_rank = 0,
days_inactive = 0,
total_rating = 0,
num_ratings = 0,
unq_pv_overall = 0,
tot_pv_overall = 0,
unq_in_overall = 0,
tot_in_overall = 0,
unq_out_overall = 0,
tot_out_overall = 0,
unq_pv_0_daily = 0,
unq_pv_1_daily = 0,
unq_pv_2_daily = 0,
unq_pv_3_daily = 0,
unq_pv_4_daily = 0,
unq_pv_5_daily = 0,
unq_pv_6_daily = 0,
unq_pv_7_daily = 0,
unq_pv_8_daily = 0,
unq_pv_9_daily = 0,
unq_pv_max_daily = 0,
tot_pv_0_daily = 0,
tot_pv_1_daily = 0,
tot_pv_2_daily = 0,
tot_pv_3_daily = 0,
tot_pv_4_daily = 0,
tot_pv_5_daily = 0,
tot_pv_6_daily = 0,
tot_pv_7_daily = 0,
tot_pv_8_daily = 0,
tot_pv_9_daily = 0,
tot_pv_max_daily = 0,
unq_in_0_daily = 0,
unq_in_1_daily = 0,
unq_in_2_daily = 0,
unq_in_3_daily = 0,
unq_in_4_daily = 0,
unq_in_5_daily = 0,
unq_in_6_daily = 0,
unq_in_7_daily = 0,
unq_in_8_daily = 0,
unq_in_9_daily = 0,
unq_in_max_daily = 0,
tot_in_0_daily = 0,
tot_in_1_daily = 0,
tot_in_2_daily = 0,
tot_in_3_daily = 0,
tot_in_4_daily = 0,
tot_in_5_daily = 0,
tot_in_6_daily = 0,
tot_in_7_daily = 0,
tot_in_8_daily = 0,
tot_in_9_daily = 0,
tot_in_max_daily = 0,
unq_out_0_daily = 0,
unq_out_1_daily = 0,
unq_out_2_daily = 0,
unq_out_3_daily = 0,
unq_out_4_daily = 0,
unq_out_5_daily = 0,
unq_out_6_daily = 0,
unq_out_7_daily = 0,
unq_out_8_daily = 0,
unq_out_9_daily = 0,
unq_out_max_daily = 0,
tot_out_0_daily = 0,
tot_out_1_daily = 0,
tot_out_2_daily = 0,
tot_out_3_daily = 0,
tot_out_4_daily = 0,
tot_out_5_daily = 0,
tot_out_6_daily = 0,
tot_out_7_daily = 0,
tot_out_8_daily = 0,
tot_out_9_daily = 0,
tot_out_max_daily = 0,
unq_pv_0_weekly = 0,
unq_pv_1_weekly = 0,
unq_pv_2_weekly = 0,
unq_pv_3_weekly = 0,
unq_pv_4_weekly = 0,
unq_pv_5_weekly = 0,
unq_pv_6_weekly = 0,
unq_pv_7_weekly = 0,
unq_pv_8_weekly = 0,
unq_pv_9_weekly = 0,
unq_pv_max_weekly = 0,
tot_pv_0_weekly = 0,
tot_pv_1_weekly = 0,
tot_pv_2_weekly = 0,
tot_pv_3_weekly = 0,
tot_pv_4_weekly = 0,
tot_pv_5_weekly = 0,
tot_pv_6_weekly = 0,
tot_pv_7_weekly = 0,
tot_pv_8_weekly = 0,
tot_pv_9_weekly = 0,
tot_pv_max_weekly = 0,
unq_in_0_weekly = 0,
unq_in_1_weekly = 0,
unq_in_2_weekly = 0,
unq_in_3_weekly = 0,
unq_in_4_weekly = 0,
unq_in_5_weekly = 0,
unq_in_6_weekly = 0,
unq_in_7_weekly = 0,
unq_in_8_weekly = 0,
unq_in_9_weekly = 0,
unq_in_max_weekly = 0,
tot_in_0_weekly = 0,
tot_in_1_weekly = 0,
tot_in_2_weekly = 0,
tot_in_3_weekly = 0,
tot_in_4_weekly = 0,
tot_in_5_weekly = 0,
tot_in_6_weekly = 0,
tot_in_7_weekly = 0,
tot_in_8_weekly = 0,
tot_in_9_weekly = 0,
tot_in_max_weekly = 0,
unq_out_0_weekly = 0,
unq_out_1_weekly = 0,
unq_out_2_weekly = 0,
unq_out_3_weekly = 0,
unq_out_4_weekly = 0,
unq_out_5_weekly = 0,
unq_out_6_weekly = 0,
unq_out_7_weekly = 0,
unq_out_8_weekly = 0,
unq_out_9_weekly = 0,
unq_out_max_weekly = 0,
tot_out_0_weekly = 0,
tot_out_1_weekly = 0,
tot_out_2_weekly = 0,
tot_out_3_weekly = 0,
tot_out_4_weekly = 0,
tot_out_5_weekly = 0,
tot_out_6_weekly = 0,
tot_out_7_weekly = 0,
tot_out_8_weekly = 0,
tot_out_9_weekly = 0,
tot_out_max_weekly = 0,
unq_pv_0_monthly = 0,
unq_pv_1_monthly = 0,
unq_pv_2_monthly = 0,
unq_pv_3_monthly = 0,
unq_pv_4_monthly = 0,
unq_pv_5_monthly = 0,
unq_pv_6_monthly = 0,
unq_pv_7_monthly = 0,
unq_pv_8_monthly = 0,
unq_pv_9_monthly = 0,
unq_pv_max_monthly = 0,
tot_pv_0_monthly = 0,
tot_pv_1_monthly = 0,
tot_pv_2_monthly = 0,
tot_pv_3_monthly = 0,
tot_pv_4_monthly = 0,
tot_pv_5_monthly = 0,
tot_pv_6_monthly = 0,
tot_pv_7_monthly = 0,
tot_pv_8_monthly = 0,
tot_pv_9_monthly = 0,
tot_pv_max_monthly = 0,
unq_in_0_monthly = 0,
unq_in_1_monthly = 0,
unq_in_2_monthly = 0,
unq_in_3_monthly = 0,
unq_in_4_monthly = 0,
unq_in_5_monthly = 0,
unq_in_6_monthly = 0,
unq_in_7_monthly = 0,
unq_in_8_monthly = 0,
unq_in_9_monthly = 0,
unq_in_max_monthly = 0,
tot_in_0_monthly = 0,
tot_in_1_monthly = 0,
tot_in_2_monthly = 0,
tot_in_3_monthly = 0,
tot_in_4_monthly = 0,
tot_in_5_monthly = 0,
tot_in_6_monthly = 0,
tot_in_7_monthly = 0,
tot_in_8_monthly = 0,
tot_in_9_monthly = 0,
tot_in_max_monthly = 0,
unq_out_0_monthly = 0,
unq_out_1_monthly = 0,
unq_out_2_monthly = 0,
unq_out_3_monthly = 0,
unq_out_4_monthly = 0,
unq_out_5_monthly = 0,
unq_out_6_monthly = 0,
unq_out_7_monthly = 0,
unq_out_8_monthly = 0,
unq_out_9_monthly = 0,
unq_out_max_monthly = 0,
tot_out_0_monthly = 0,
tot_out_1_monthly = 0,
tot_out_2_monthly = 0,
tot_out_3_monthly = 0,
tot_out_4_monthly = 0,
tot_out_5_monthly = 0,
tot_out_6_monthly = 0,
tot_out_7_monthly = 0,
tot_out_8_monthly = 0,
tot_out_9_monthly = 0,
tot_out_max_monthly = 0;


All the stats should now be reset :D


I would like to do it automatically somehow in the admin control panel just by click a button. Is there a way to do this?
misterjoker
Member
 
Posts: 10
Joined: 2007-02-26 07:20 pm

Postby Polymath » 2007-05-19 09:10 pm

Well not yet there is not
(\__/)
(O.o ) *If You need help, best not to ask me*
(> < ) EZMNetwork.com
Gamesocket.geek.nz
Kiwitopsite.co.nz
Polymath
Advanced Member
 
Posts: 55
Joined: 2007-02-25 09:22 am
Location: New Zealand

Postby Tier-Topliste » 2007-07-07 09:29 am

before I'm going to destroy my toplist: does this work with version 5.2.0?
Tier-Topliste
Advanced Member
 
Posts: 41
Joined: 2006-06-04 06:56 am
Location: Germany

Postby Jeremy » 2007-07-07 10:50 am

the ats_stats table didn't change between 5.1 and 5.2, so it should work the same.
Jeremy
Supreme Diety
 
Posts: 8922
Joined: 2003-05-05 04:41 pm
Location: NJ, USA

Postby Tier-Topliste » 2007-07-07 05:42 pm

thanks :)

another question: is it somehow possible to make it that the toplist is automatically resetted after for exampel 30 days (or any other time period ...)?
Tier-Topliste
Advanced Member
 
Posts: 41
Joined: 2006-06-04 06:56 am
Location: Germany

Postby Jeremy » 2007-07-07 07:42 pm

in the admin set the ranking period to monthly and then there is another setting under that where you can set it to rank by only this month, and not an average.
Jeremy
Supreme Diety
 
Posts: 8922
Joined: 2003-05-05 04:41 pm
Location: NJ, USA

Postby Tier-Topliste » 2007-07-08 03:18 am

ups ... how embarassing :oops: ... anyway: thanks :)

edit: is the german version different from the english?
in settings i have:

Platzierungsperiode (ranking period)
daily / weekly / monthly / total -> there i've choosen now monthly

Platzierungsmethode: (ranking method)
sitevisit / hit in / hit out -> at the moment i've choosen sitevisit

Platzierung nach Durchschnitt oder heute (rankig average or daily)
average / daily -> where's the monthly you've mentioned?
Tier-Topliste
Advanced Member
 
Posts: 41
Joined: 2006-06-04 06:56 am
Location: Germany

Postby Jeremy » 2007-07-08 10:43 am

it's the third setting. it should update the text to say daily/weekly/monthly based on your ranking period. it doesn't do this instantly though, you'd have to submit the form to change the ranking period before the text for the other setting updates. but it will still work the same.
Jeremy
Supreme Diety
 
Posts: 8922
Joined: 2003-05-05 04:41 pm
Location: NJ, USA

Postby Tier-Topliste » 2007-07-08 12:16 pm

aha :) ok, got it - thanks :)
Tier-Topliste
Advanced Member
 
Posts: 41
Joined: 2006-06-04 06:56 am
Location: Germany

Postby Jaap » 2007-07-30 03:19 pm

This was very helpfull!!!

is the german version different from the english?

Reply JS
it's the third setting.


I'm this happy, your Aardvark Topsites PHP 5.2.0 is so much beter then your german 8)
Jaap
Member
 
Posts: 23
Joined: 2006-03-19 03:47 am

Postby Jeremy » 2007-07-30 05:25 pm

if you can improve the german version, please do so
Jeremy
Supreme Diety
 
Posts: 8922
Joined: 2003-05-05 04:41 pm
Location: NJ, USA

Postby Jaap » 2007-07-31 04:25 pm

I'm bussy at the moment with a dutch translation.
If finished I will start with a german one.
Jaap
Member
 
Posts: 23
Joined: 2006-03-19 03:47 am

Next

Return to Support

Who is online

Users browsing this forum: No registered users and 3 guests

cron