View Single Post
  #2  
Old 02-07-2008, 07:22 PM
Morgan's Avatar
Morgan Morgan is offline
Administrator
 
Join Date: Jul 2006
Posts: 2,255
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

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;
But before doing so, how many rows does the GAB_stats table contain right after you run Compress Stats Table via the ACP?
__________________
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
Reply With Quote