|
Geek Advertising Banner System GAB is a highly configurable banner management system for vBulletin. |
Advertisement | |
This is an HTML example. Isn't it just wonderful?!?!
|
|
Learn how to remove ads |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Clearing GAB stats?
Is there a way to clear
GAB
stats prior to a certain date/time. For example, clearing all stats from 12/31/07 and prior leaving only stats from 2008? My stats tables have grown huge with tracking impressions and I'd like to empty them out some please!
|
#2
|
||||
|
||||
1199059200 is the GMT Unix timestamp for 12/31/07 00:00:00 so you could run a query:
Code:
# add your vB table prefix to the table name if you use one DELETE FROM GAB_stats WHERE dateline < 1199059200;
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks. While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams |
#3
|
|||
|
|||
Quote:
|
#4
|
||||
|
||||
To see the number of rows, you'd need to use phpMyAdmin, select the GAB_stats table, click the Browse tab, and it'll show you the number of rows. If you are using a vB table prefix, it'll be specified in your vB config.php file.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks. While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams |
#5
|
|||
|
|||
Ok this is going to sound like a total newbie question (because I am when it comes to direct MySQL manipulation) but where can I find my vbulletin database? I'm assuming I have to give phpMyAdmin some sort of URL to go look for the database at and then log into the database. I'm assuming my vbulletin config file will have a userid and password for logging into the database too right? Once in phpMyAdmin can I just kill rows of
GAB
stats manually or is it better to do that SQL query you were talking about?
|
#6
|
||||
|
||||
There is a 'databases' link in phpMyAdmin, and yes, your vB config file contains the database name, database username, and database password. Your hosting control panel should have a link to phpMyAdmin, and your login information may or may not be the same as in the vB config file. You can manually kill rows, if you want to do it that way, but before using phpMyAdmin you might want to read some tutorials. You can also run queries via the ACP. See here for how.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks. While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams |
#7
|
|||
|
|||
Quote:
GAB_stats MyISAM 9 Dynamic 1067973 38 41184232 4294967295 8770560 0 2008-02-09 20:22:46 2008-02-09 21:18:40 2008-02-09 20:22:56 latin1_swedish_ci GAB_temp_stats MyISAM 9 Dynamic 1065219 42 45686420 4294967295 1024 0 2008-02-09 20:20:22 2008-02-09 20:22:46 latin1_swedish_ci Last edited by KenDude; 02-10-2008 at 04:33 AM.. |
#8
|
|||
|
|||
Hey I did the ACP command deleting all rows from GAB_stats (should I do GAB_temp_stats as well?) and it deleted 933,079 rows in about 30 seconds.
I go back into the GAB admin tools and I can stillsee all the stats since the beginning of time is that because I haven't done anything to GAB_temp_stats yet? Last edited by KenDude; 02-10-2008 at 04:55 AM.. |
#9
|
||||
|
||||
The GAB_ads table has two fields, views and hits, that hold the number of impressions and the number of clickthroughs, respectively.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks. While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams |
#10
|
|||
|
|||
Ok so then I can clean out GAB_temp_stats then as well too right and still retain the views and hits because those are in the Gab_ads table too?
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
GAB and GAB Stats for vB4 have been released | Morgan | Announcements | 0 | 05-19-2010 01:58 AM |
Advertisers can now see their GAB stats | Morgan | Announcements | 6 | 08-22-2009 02:56 PM |
No stats | Noodles | Geek Auto-Linker | 3 | 07-03-2007 08:19 AM |
Clearing removed articles | BobdeBilder | Geek Article and Review System | 3 | 04-12-2006 04:34 PM |
No stats ? ? | rose | Geek Advertising Banner System | 1 | 12-10-2005 05:22 PM |