charliebrown
New Member
I did a toplist reset but only hits in went back to 0
how to reset hits out?
how to reset hits out?
<?php
//===========================================================================\\
// VisioList is a proud derivative work of: \\
// Aardvark Topsites PHP \\
// Copyright (c) 2000-2009 Jeremy Scheff. All rights reserved. \\
//---------------------------------------------------------------------------\\
// http://www.aardvarktopsitesphp.com/ http://www.avatic.com/ \\
//---------------------------------------------------------------------------\\
// This program is free software; you can redistribute it and/or modify it \\
// under the terms of the GNU General Public License as published by the \\
// Free Software Foundation; either version 2 of the License, or (at your \\
// option) any later version. \\
// \\
// This program is distributed in the hope that it will be useful, but \\
// WITHOUT ANY WARRANTY; without even the implied warranty of \\
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General \\
// Public License for more details. \\
//===========================================================================\\
// Help prevent register_globals injection
define('VISIOLIST', 1);
$CONF = array();
$FORM = array();
$TMPL = array();
// Set encoding for multi-byte string functions
mb_internal_encoding("UTF-8");
// Change the path to your full path if necessary
$CONF['path'] = '.';
// Connect to the database
// Set the last argument of $DB->connect to 1 to enable debug mode
require_once ("{$CONF['path']}/settings_sql.php");
require_once ("{$CONF['path']}/sources/sql/{$CONF['sql']}.php");
$DB = "sql_{$CONF['sql']}";
$DB = new $DB;
$DB->connect($CONF['sql_host'], $CONF['sql_username'], $CONF['sql_password'], $CONF['sql_database'], 0);
$update_stats = "tot_out_overall = 0";
$update_stats .= ", unq_out_overall = 0";
for($i = 0; $i <= 9; $i++) {
$update_stats .= ", tot_out_{$i}_daily = 0";
$update_stats .= ", tot_out_{$i}_weekly = 0";
$update_stats .= ", tot_out_{$i}_monthly = 0";
$update_stats .= ", unq_out_{$i}_daily = 0";
$update_stats .= ", unq_out_{$i}_weekly = 0";
$update_stats .= ", unq_out_{$i}_monthly = 0";
}
$update_stats .= ", tot_out_max_daily = 0";
$update_stats .= ", tot_out_max_weekly = 0";
$update_stats .= ", tot_out_max_monthly = 0";
$update_stats .= ", unq_out_max_daily = 0";
$update_stats .= ", unq_out_max_weekly = 0";
$update_stats .= ", unq_out_max_monthly = 0";
// Update stats
$DB->query("UPDATE {$CONF['sql_prefix']}_stats SET {$update_stats}", __FILE__, __LINE__);
$DB->close();