ifthd->member['acp']['tools_maint'] )
{
$this->ifthd->skin->error('no_perm');
}
$this->ifthd->skin->set_section( 'Tools & Maintenance' );
$this->ifthd->skin->set_description( 'Run maintenance utilities, recount functions, cleaning utilities and backup functions.' );
switch( $this->ifthd->input['code'] )
{
case 'recount':
$this->show_recount();
break;
case 'rebuild':
$this->show_rebuild();
break;
case 'clean':
$this->show_clean();
break;
case 'syscheck':
$this->syscheck();
break;
case 'dorecount':
$this->do_recount();
break;
case 'doclean':
$this->do_clean();
break;
default:
$this->show_recount();
break;
}
}
#=======================================
# @ Show Recount
# Show the recount page.
#=======================================
function show_recount($alert='')
{
#=============================
# Security Checks
#=============================
if ( ! $this->ifthd->member['acp']['tools_maint_recount'] )
{
$this->ifthd->skin->error('no_perm');
}
#=============================
# Do Output
#=============================
if ( $alert )
{
$alert = "{$alert}
";
}
$this->output = "{$alert}
Recount Functions
Please select a task below.
Members -- The number of members for each group, etc.
Settings -- The number of settings per settings group. ";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Tools",
"Maintenance",
"Recount Functions",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Maintenance' ) );
}
#=======================================
# @ Show Rebuild
# Show the rebuild page.
#=======================================
function show_rebuild($alert='')
{
#=============================
# Security Checks
#=============================
if ( ! $this->ifthd->member['acp']['tools_maint_recount'] )
{
$this->ifthd->skin->error('no_perm');
}
#=============================
# Do Output
#=============================
if ( $alert )
{
$alert = "{$alert}
";
}
$this->output = "{$alert}
Rebuild Functions
Please select a function below to rebuild.
Login Keys -- Regenerate login keys for all members.
RSS Keys -- Regenerate RSS keys for all members. ";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Tools",
"Maintenance",
"Rebuild Functions",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Maintenance' ) );
}
#=======================================
# @ Show Clean
# Show the Spring cleaning page. :D
#=======================================
function show_clean($alert='')
{
#=============================
# Security Checks
#=============================
if ( ! $this->ifthd->member['acp']['tools_maint_clean'] )
{
$this->ifthd->skin->error('no_perm');
}
#=============================
# Do Output
#=============================
if ( $alert )
{
$alert = "{$alert}
";
}
$this->output = "{$alert}
Spring Cleaning
Please select the checkbox next to each action you wish to perform. Then click Start Cleaning.
";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Tools",
"Maintenance",
"Spring Cleaning",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Maintenance' ) );
}
#=======================================
# @ Do Recount
# Perform the appropriate task to
# recount or rebuild.
#=======================================
function do_recount()
{
#=============================
# Security Checks
#=============================
if ( ! $this->ifthd->member['acp']['tools_maint_recount'] )
{
$this->ifthd->skin->error('no_perm');
}
#=============================
# Perform Our Action
#=============================
if ( substr( $this->ifthd->input['type'], 0, 1 ) == 'c' )
{
if ( $this->ifthd->input['type'] == 'cannounce' )
{
$this->ifthd->rebuild_announce_cache();
$this->ifthd->log( 'admin', "Announcement Cache Rebuilt" );
}
elseif ( $this->ifthd->input['type'] == 'ccanned' )
{
$this->ifthd->rebuild_canned_cache();
$this->ifthd->log( 'admin', "Canned Replies Cache Rebuilt" );
}
elseif ( $this->ifthd->input['type'] == 'ckbcat' )
{
$this->ifthd->rebuild_cat_cache();
$this->ifthd->log( 'admin', "Category Cache Rebuilt" );
}
elseif ( $this->ifthd->input['type'] == 'cdepart' )
{
$this->ifthd->rebuild_dprt_cache();
$this->ifthd->log( 'admin', "Department Cache Rebuilt" );
}
elseif ( $this->ifthd->input['type'] == 'cgroup' )
{
$this->ifthd->rebuild_group_cache();
$this->ifthd->log( 'admin', "Group Cache Rebuilt" );
}
elseif ( $this->ifthd->input['type'] == 'clang' )
{
$this->ifthd->rebuild_lang_cache();
$this->ifthd->log( 'admin', "Language Cache Rebuilt" );
}
elseif ( $this->ifthd->input['type'] == 'cskin' )
{
$this->ifthd->rebuild_skin_cache();
$this->ifthd->log( 'admin', "Skin Cache Rebuilt" );
}
elseif ( $this->ifthd->input['type'] == 'cstaff' )
{
$this->ifthd->rebuild_staff_cache();
$this->ifthd->log( 'admin', "Staff Cache Rebuilt" );
}
elseif ( $this->ifthd->input['type'] == 'cconfig' )
{
$this->ifthd->rebuild_set_cache();
$this->ifthd->log( 'admin', "Settings Cache Rebuilt" );
}
elseif ( $this->ifthd->input['type'] == 'ccdfields' )
{
$this->ifthd->rebuild_dfields_cache();
$this->ifthd->log( 'admin', "Custom Department Fields Cache Rebuilt" );
}
elseif ( $this->ifthd->input['type'] == 'ccpfields' )
{
$this->ifthd->rebuild_pfields_cache();
$this->ifthd->log( 'admin', "Custom Profile Fields Cache Rebuilt" );
}
elseif ( $this->ifthd->input['type'] == 'cchmod' )
{
$this->ifthd->core->chmod_cache();
$this->ifthd->log( 'admin', "Cache Files CHMOD to 0777" );
}
elseif ( $this->ifthd->input['type'] == 'crsskeys' )
{
$this->r_rss_keys();
}
elseif ( $this->ifthd->input['type'] == 'cloginkeys' )
{
$this->r_login_keys();
}
#$this->ifthd->skin->redirect( '?section=tools&act=maint&code=rebuild', 'cache_rebuilt' );
$this->show_rebuild( 'The rebuild function has been successfully run.' );
}
elseif ( substr( $this->ifthd->input['type'], 0, 1 ) == 'r' )
{
if ( $this->ifthd->input['type'] == 'rticket' )
{
$this->ifthd->r_ticket_stats();
$this->ifthd->log( 'admin', "Rebuilt Ticket Statistics" );
}
elseif ( $this->ifthd->input['type'] == 'rkb' )
{
$this->ifthd->r_kb_stats();
$this->ifthd->log( 'admin', "Rebuilt KB Statistics" );
}
elseif ( $this->ifthd->input['type'] == 'rmember' )
{
$this->ifthd->r_member_stats();
$this->ifthd->log( 'admin', "Rebuilt Member Statistics" );
}
elseif ( $this->ifthd->input['type'] == 'rreplies' )
{
$this->r_replies_per_ticket();
}
elseif ( $this->ifthd->input['type'] == 'rmemtick' )
{
$this->ifthd->r_tickets_per_member();
}
elseif ( $this->ifthd->input['type'] == 'rdeptick' )
{
$this->ifthd->r_tickets_per_dept();
}
elseif ( $this->ifthd->input['type'] == 'racomments' )
{
$this->r_acomments();
}
elseif ( $this->ifthd->input['type'] == 'rncomments' )
{
$this->r_ncomments();
}
elseif ( $this->ifthd->input['type'] == 'rmembers' )
{
$this->r_members();
}
elseif ( $this->ifthd->input['type'] == 'rartrate' )
{
$this->r_article_ratings();
}
elseif ( $this->ifthd->input['type'] == 'rsettings' )
{
$this->r_settings();
}
elseif ( $this->ifthd->input['type'] == 'rtassign' )
{
$this->r_tassigned();
}
#$this->ifthd->skin->redirect( '?section=tools&act=maint&code=recount', 'maint_recount' );
$this->show_recount( 'The recount function has been successfully run.' );
}
}
#=======================================
# @ Recount: Replies Per Ticket
# Recounts the number of replies per
# ticket.
#=======================================
function r_replies_per_ticket()
{
#=============================
# Grab Replies
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'id', 'tid' ),
'from' => 'replies',
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $r = $this->ifthd->core->db->fetch_row() )
{
$replies[ $r['tid'] ] ++;
}
}
#=============================
# Grab Tickets
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'id' ),
'from' => 'tickets',
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $t = $this->ifthd->core->db->fetch_row() )
{
$tickets[ $t['id'] ] = 1;
}
#=============================
# Update Tickets
#=============================
while ( list( $tid, ) = each( $tickets ) )
{
$this->ifthd->core->db->construct( array(
'update' => 'tickets',
'set' => array( 'replies' => $replies[ $tid ] ),
'where' => array( 'id', '=', $tid ),
) );
$this->ifthd->core->db->execute();
}
}
$this->ifthd->log( 'admin', "Recounted Replies Per Ticket" );
}
#=======================================
# @ Recount: Article Comments
# Recounts the number of comments per
# article.
#=======================================
function r_acomments()
{
#=============================
# Grab Comments
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'id', 'aid' ),
'from' => 'comments',
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $c = $this->ifthd->core->db->fetch_row() )
{
$comments[ $c['aid'] ] ++;
}
}
#=============================
# Grab Articles
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'id' ),
'from' => 'articles',
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $a = $this->ifthd->core->db->fetch_row() )
{
$articles[ $a['id'] ] = 1;
}
#=============================
# Update Articles
#=============================
while ( list( $aid, ) = each( $articles ) )
{
$this->ifthd->core->db->construct( array(
'update' => 'articles',
'set' => array( 'comments' => $comments[ $aid ] ),
'where' => array( 'id', '=', $aid ),
) );
$this->ifthd->core->db->execute();
}
}
$this->ifthd->log( 'admin', "Recounted Article Comments" );
}
#=======================================
# @ Recount: News Comments
# Recounts the number of comments per
# announcement.
#=======================================
function r_ncomments()
{
#=============================
# Grab Comments
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'id', 'nid' ),
'from' => 'news_comments',
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $c = $this->ifthd->core->db->fetch_row() )
{
$comments[ $c['nid'] ] ++;
}
}
#=============================
# Grab Announcements
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'id' ),
'from' => 'announcements',
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $a = $this->ifthd->core->db->fetch_row() )
{
$news[ $a['id'] ] = 1;
}
#=============================
# Update Announcements
#=============================
while ( list( $nid, ) = each( $news ) )
{
$this->ifthd->core->db->construct( array(
'update' => 'announcements',
'set' => array( 'comments' => $comments[ $nid ] ),
'where' => array( 'id', '=', $nid ),
) );
$this->ifthd->core->db->execute();
}
}
$this->ifthd->log( 'admin', "Recounted News Comments" );
}
#=======================================
# @ Recount: Members
# Recounts the number of members per
# group.
#=======================================
function r_members()
{
#=============================
# Grab Members
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'id', 'mgroup' ),
'from' => 'members',
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $m = $this->ifthd->core->db->fetch_row() )
{
$members[ $m['mgroup'] ] ++;
}
}
#=============================
# Grab Groups
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'g_id' ),
'from' => 'groups',
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $g = $this->ifthd->core->db->fetch_row() )
{
$groups[ $g['g_id'] ] = 1;
}
}
#=============================
# Update Groups
#=============================
while ( list( $gid, ) = each( $groups ) )
{
$this->ifthd->core->db->construct( array(
'update' => 'groups',
'set' => array( 'g_members' => $members[ $gid ] ),
'where' => array( 'g_id', '=', $gid ),
) );
$this->ifthd->core->db->execute();
}
$this->ifthd->log( 'admin', "Recounted Members" );
}
#=======================================
# @ Recount: Settings
# Recounts the number of settings per
# settings group.
#=======================================
function r_settings()
{
#=============================
# Grab Settings
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'cf_id', 'cf_group' ),
'from' => 'settings',
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $s = $this->ifthd->core->db->fetch_row() )
{
$settings[ $s['cf_group'] ] ++;
}
}
#=============================
# Grab Settings Groups
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'cg_id' ),
'from' => 'settings_groups',
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $g = $this->ifthd->core->db->fetch_row() )
{
$groups[ $g['cg_id'] ] = 1;
}
}
#=============================
# Update Settings Groups
#=============================
while ( list( $gid, ) = each( $groups ) )
{
$this->ifthd->core->db->construct( array(
'update' => 'settings_groups',
'set' => array( 'cg_set_count' => $settings[ $gid ] ),
'where' => array( 'cg_id', '=', $gid ),
) );
$this->ifthd->core->db->execute();
}
$this->ifthd->log( 'admin', "Recounted Settings" );
}
#=======================================
# @ Recount: Article Ratings
# Recounts the article rating for each
# article.
#=======================================
function r_article_ratings()
{
#=============================
# Grab Ratings
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'id', 'aid', 'rating' ),
'from' => 'article_rate',
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $r = $this->ifthd->core->db->fetch_row() )
{
$rates[ $r['aid'] ] += $r['rating'];
$rate_count[ $r['aid'] ] ++;
}
#=============================
# Calculate Ratings
#=============================
while ( list( $a_id, $t_rate ) = each( $rates ) )
{
$ratings[ $a_id ] = round( ( $t_rate / $rate_count[ $a_id ] ), 2 );
}
#=============================
# Grab Articles
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'id' ),
'from' => 'articles',
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $a = $this->ifthd->core->db->fetch_row() )
{
$articles[ $a['id'] ] = 1;
}
}
#=============================
# Update Articles
#=============================
while ( list( $aid, ) = each( $articles ) )
{
$this->ifthd->core->db->construct( array(
'update' => 'articles',
'set' => array( 'votes' => $rate_count[ $aid ], 'rating' => $ratings[ $aid ] ),
'where' => array( 'id', '=', $aid ),
) );
$this->ifthd->core->db->execute();
}
}
$this->ifthd->log( 'admin', "Recounted Article Ratings" );
}
#=======================================
# @ Recount: RSS Keys
# Regenerates new RSS keys for members.
#=======================================
function r_rss_keys()
{
#=============================
# Grab Members
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'id' ),
'from' => 'members',
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $m = $this->ifthd->core->db->fetch_row() )
{
$members[ $m['id'] ] = 1;
}
}
#=============================
# Generate Keys and Update
#=============================
while ( list( $mid, ) = each( $members ) )
{
$rss_key = md5( 'rk' . uniqid( rand(), true ) . $mid );
$this->ifthd->core->db->construct( array(
'update' => 'members',
'set' => array( 'rss_key' => $rss_key ),
'where' => array( 'id', '=', $mid ),
) );
$this->ifthd->core->db->execute();
}
$this->ifthd->log( 'admin', "RSS Keys Regenerated" );
}
#=======================================
# @ Rebuild: Login Keys
# Regenerates new login keys for members.
#=======================================
function r_login_keys()
{
#=============================
# Grab Members
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'id' ),
'from' => 'members',
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $m = $this->ifthd->core->db->fetch_row() )
{
$members[ $m['id'] ] = 1;
}
}
#=============================
# Generate Keys and Update
#=============================
while ( list( $mid, ) = each( $members ) )
{
$login_key = str_replace( "=", "", base64_encode( strrev( crypt( md5( 'lk'. uniqid( rand(), true ) . $mid ) ) ) ) );
$this->ifthd->core->db->construct( array(
'update' => 'members',
'set' => array( 'login_key' => $login_key ),
'where' => array( 'id', '=', $mid ),
) );
$this->ifthd->core->db->execute();
}
$this->ifthd->log( 'admin', "Login Keys Regenerated" );
}
#=======================================
# @ Recount: Assigned Tickets
# Recounts the number of assigned
# tickets per staff member.
#=======================================
function r_tassigned()
{
#=============================
# Grab Tickets
#=============================
$this->ifthd->core->db->construct( array(
'select' => array( 'id', 'amid' ),
'from' => 'tickets',
'where' => array( array( 'amid', '!=', 0 ), array( 'status', '!=', 6, 'and' ) )
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $t = $this->ifthd->core->db->fetch_row() )
{
$staff[ $t['amid'] ] ++;
}
}
#=============================
# Update Staff
#=============================
while ( list( $smid, ) = each( $staff ) )
{
if ( $this->ifthd->core->cache['staff'][ $smid ] )
{
$this->ifthd->core->db->construct( array(
'update' => 'members',
'set' => array( 'assigned' => $staff[ $smid ] ),
'where' => array( 'id', '=', $smid ),
) );
$this->ifthd->core->db->execute();
}
}
$this->ifthd->log( 'admin', "Recounted Assigned Tickets" );
$this->ifthd->rebuild_staff_cache();
}
#=======================================
# @ System Check
# Perform a self system check.
#=======================================
function syscheck()
{
#=============================
# Security Checks
#=============================
if ( ! $this->ifthd->member['acp']['tools_maint_syscheck'] )
{
$this->ifthd->skin->error('no_perm');
}
$this->output = "System Check
| Table |
Found |
Rows |
";
#=============================
# Check Database
#=============================
$datab_c = array(
'announcements',
'articles',
'article_rate',
'asessions',
'attachments',
'canned',
'categories',
'comments',
'departments',
'depart_fields',
'groups',
'languages',
'logs',
'members',
'news_comments',
'pages',
'profile_fields',
'replies',
'reply_rate',
'sessions',
'settings',
'settings_groups',
'skins',
'tickets',
'tokens',
'upg_history',
'validation',
);
$sql = $this->ifthd->core->db->get_tables();
$num_rows = $this->ifthd->core->db->get_num_rows( $sql );
$row_count = 0; // Initialize for Security
for ( $i = 0; $i < $num_rows; $i++ )
{
$tables[] = mysql_tablename( $sql, $i );
}
while ( list( , $ck_table ) = each( $datab_c ) )
{
$row_count ++;
( $row_count & 1 ) ? $row_class = 'option1-med' : $row_class = 'option2-med';
if ( ! in_array( $this->ifthd->core->db->db_prefix . $ck_table, $tables ) )
{
$this->output .= "
| ". $ck_table ." |
Not Found |
X |
";
}
else
{
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => $ck_table,
) );
$this->ifthd->core->db->execute();
$temp_rows = $this->ifthd->core->db->get_num_rows();
$this->output .= "
| ". $ck_table ." |
Found |
". $temp_rows ." |
";
}
}
$this->output .= "
";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Tools",
"Maintenance",
"System Check",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Maintenance' ) );
}
#=======================================
# @ Do Clean
# Perform a Spring cleaning.
#=======================================
function do_clean()
{
#=============================
# Security Checks
#=============================
if ( ! $this->ifthd->member['acp']['tools_maint_clean'] )
{
$this->ifthd->skin->error('no_perm');
}
#=============================
# Do Some Cleanin'
#=============================
if ( $this->ifthd->input['del_old_tickets'] && $this->ifthd->input['dot_days'] )
{
$this->ifthd->core->db->construct( array(
'delete' => 'tickets',
'where' => array( 'date', '<', ( time() - ( 60 * 60 * 24 * $this->ifthd->input['dot_days'] ) ) ),
) );
$this->ifthd->core->db->execute();
$rticket = 1;
$rmemtick = 1;
$rdeptick = 1;
}
if ( $this->ifthd->input['del_old_comments'] && $this->ifthd->input['doc_days'] )
{
$this->ifthd->core->db->construct( array(
'delete' => 'comments',
'where' => array( 'date', '<', ( time() - ( 60 * 60 * 24 * $this->ifthd->input['doc_days'] ) ) ),
) );
$this->ifthd->core->db->execute();
$rcomments = 1;
}
if ( $this->ifthd->input['del_unapproved_mem'] && $this->ifthd->input['dum_days'] )
{
$this->ifthd->core->db->construct( array(
'delete' => 'members',
'where' => array( array( 'mgroup', '=', 3, ), array( 'joined', '<', ( time() - ( 60 * 60 * 24 * $this->ifthd->input['dum_days'] ) ), 'and' ) ),
) );
$this->ifthd->core->db->execute();
$rmember = 1;
$rmembers = 1;
}
if ( $this->ifthd->input['delete_core_logs'] )
{
if ( $handle = opendir( HD_PATH .'core/logs' ) )
{
while ( ( $file = readdir($handle) ) !== false )
{
if ( $file != "." && $file != ".." && $file != "index.html" )
{
if ( ! is_dir( HD_PATH .'core/logs/' . $file ) )
{
@unlink( HD_PATH .'core/logs/' . $file );
}
}
}
closedir($handle);
}
}
if ( $this->ifthd->input['delete_tmp_files'] )
{
if ( $handle = opendir( HD_PATH .'core/tmp' ) )
{
while ( ( $file = readdir($handle) ) !== false )
{
if ( $file != "." && $file != ".." && $file != "index.html" )
{
if ( ! is_dir( HD_PATH .'core/tmp/' . $file ) )
{
@unlink( HD_PATH .'core/tmp/' . $file );
}
}
}
closedir($handle);
}
}
if ( $this->ifthd->input['del_logs_admin'] && $this->ifthd->input['dla_days'] )
{
$this->ifthd->core->db->construct( array(
'delete' => 'logs',
'where' => array( array( 'type', '=', 2, ), array( 'date', '<', ( time() - ( 60 * 60 * 24 * $this->ifthd->input['dla_days'] ) ), 'and' ) ),
) );
$this->ifthd->core->db->execute();
}
if ( $this->ifthd->input['del_logs_mem'] && $this->ifthd->input['dlm_days'] )
{
$this->ifthd->core->db->construct( array(
'delete' => 'logs',
'where' => array( array( 'type', '=', 6, ), array( 'date', '<', ( time() - ( 60 * 60 * 24 * $this->ifthd->input['dlm_days'] ) ), 'and' ) ),
) );
$this->ifthd->core->db->execute();
}
if ( $this->ifthd->input['del_logs_error'] && $this->ifthd->input['dle_days'] )
{
$this->ifthd->core->db->construct( array(
'delete' => 'logs',
'where' => array( array( 'type', '=', 3, ), array( 'date', '<', ( time() - ( 60 * 60 * 24 * $this->ifthd->input['dle_days'] ) ), 'and' ) ),
) );
$this->ifthd->core->db->execute();
}
if ( $this->ifthd->input['del_logs_sec'] && $this->ifthd->input['dls_days'] )
{
$this->ifthd->core->db->construct( array(
'delete' => 'logs',
'where' => array( array( 'type', '=', 4, ), array( 'date', '<', ( time() - ( 60 * 60 * 24 * $this->ifthd->input['dls_days'] ) ), 'and' ) ),
) );
$this->ifthd->core->db->execute();
}
if ( $this->ifthd->input['del_logs_tick'] && $this->ifthd->input['dlt_days'] )
{
$this->ifthd->core->db->construct( array(
'delete' => 'logs',
'where' => array( array( 'type', '=', 7, ), array( 'date', '<', ( time() - ( 60 * 60 * 24 * $this->ifthd->input['dlt_days'] ) ), 'and' ) ),
) );
$this->ifthd->core->db->execute();
}
if ( $this->ifthd->input['kill_asessions'] )
{
$this->ifthd->core->db->construct( array(
'delete' => 'asessions',
#'where' => array( array( 'type', '=', 2, ), array( 'date', '<', ( time() - ( 60 * 60 * 24 * $this->ifthd->input['dla_days'] ) ), 'and' ) ),
) );
$this->ifthd->core->db->execute();
}
if ( $this->ifthd->input['kill_sessions'] )
{
$this->ifthd->core->db->construct( array(
'delete' => 'sessions',
#'where' => array( array( 'type', '=', 2, ), array( 'date', '<', ( time() - ( 60 * 60 * 24 * $this->ifthd->input['dla_days'] ) ), 'and' ) ),
) );
$this->ifthd->core->db->execute();
}
#=============================
# Do We Need To Rebuild?
#=============================
if ( $rticket )
{
$this->ifthd->r_ticket_stats();
}
if ( $rmemtick )
{
$this->ifthd->r_tickets_per_member();
}
if ( $rdeptick )
{
$this->ifthd->r_tickets_per_dept();
}
if ( $rmember )
{
$this->ifthd->r_member_stats();
}
#=============================
# Redirect
#=============================
$this->ifthd->log( 'admin', "Spring Cleaning Ran", 2 );
#$this->ifthd->skin->redirect( '?section=tools&act=maint&code=clean', 'spring_clean_success' );
$this->show_rebuild( 'Spring cleaning has been successfully run.' );
}
}
?>