"; } if(isset($reset_out)){ $sql = sql_query(" alter table $tb_links drop HitsOut "); $sql = sql_query(" alter table $tb_links add HitsOut int(7) unsigned default '0' not null "); $html .= ""; } if(isset($search_terms)){ $sql = sql_query(" delete from $tb_terms "); $html .= ""; } if(isset($referrers)){ $sql = sql_query(" alter table $tb_links drop InIP "); $sql = sql_query(" alter table $tb_links drop OutIP "); $sql = sql_query(" alter table $tb_links add InIP varchar(15) not null "); $sql = sql_query(" alter table $tb_links add OutIP varchar(15) not null "); $html .= ""; } if(!isset($reset_in) && !isset($reset_out) && !isset($search_terms) && !isset($referrers)){ $html .= ""; } echo $html; } else { ?>

Reset Database Values
Hits In have been reset.
Hits Out have been reset.
Search Terms have been reset.
All Referrer IPs have been reset.
Nothing has been reset.
Reset Hit In: This will reset all HitsIn counts to zero for all sites.
Reset Hits Out: This will reset all HitsOut counts to zero for all sites.
Reset Search Terms: This will delete all recorded search terms.
Reset Referrer IPs This will reset all incoming and outgoing Referrer IPs.