Powered by Multi-Forums $multiforums_setting[version]"; } else { echo ""; } exit; } if ($act == "delete_old") { $delete_count_no_posts = "0"; $delete_count_admin = "0"; // Start delete check loop $result = mysql_query("SELECT * FROM `multiforums_forums`"); while($this_forums=mysql_fetch_array($result)) { // start // open file $board_start_mysql = mysql_query("SELECT * FROM `$this_forums[access_name]_config` WHERE 1 AND `config_name` = 'board_startdate' LIMIT 0 , 1"); $board_start_result = mysql_fetch_array($board_start_mysql); $board_start_english = date ("d/m/y H:i", $board_start_result[config_value]); $board_start_unix_time = $board_start_result[config_value]; $last_post_sql = "SELECT `post_time` FROM `".$this_forums[access_name]."_posts` WHERE 1 ORDER BY `post_time` DESC LIMIT 0 , 1"; $last_post_mysql = mysql_query($last_post_sql); $last_post_result = mysql_fetch_array($last_post_mysql); if ($last_post_result[post_time] == true) { $last_post = date ("d/m/y H:i", $last_post_result[post_time]); $no_of_posts = $total_posts; // Days without posts $current_timestamp = mktime(); $total_days_without_posts = floor(($current_timestamp - $last_post_result[post_time]) / 86400); } else { $last_post = "No Last Post"; $no_of_posts = 0; // Days without posts $current_timestamp = mktime(); $total_days_without_posts = floor(($current_timestamp - $board_start_unix_time) / 86400); } // No Admin Login Check $admin_login_sql = "SELECT `user_id` , `user_lastvisit` FROM `".$this_forums[access_name]."_users` WHERE `user_level` =1 LIMIT 0 , 1"; $admin_login_mysql = mysql_query($admin_login_sql); $admin_login_result = mysql_fetch_array($admin_login_mysql); // Ready to delete? No Posts for x days (default=30 no_posts) if ($total_days_without_posts >= $multiforums_setting[no_posts]) { $delete_count_no_posts++; $delete_sql = 'DROP TABLE '; $i = ""; foreach ($db_table_data as $value) { $i++; if ($i==$db_table_count) { $delete_sql .= '`'.$this_forums[access_name].$value.'`;'; } else { $delete_sql .= '`'.$this_forums[access_name].$value.'`, '; } } $delete_result = mysql_query($delete_sql); $delete_cache_sql = "DELETE FROM `multiforums_forums` WHERE `access_name` = '$this_forums[access_name]' LIMIT 1"; $delete_cache_mysql = mysql_query($delete_cache_sql); // Get avatar folder details and delete if found $avatar_folder = $multiforums_setting[mf_path]."images/avatars/".$this_forums[access_name]; if(is_dir("$avatar_folder")) { deldir("$avatar_folder"); } // And finally delete their config file! Done, Yippie! unlink("$this_forums[access_name].php"); } // Ready to delete? No Admin Login check (default=5 no_admin_login) if ($admin_login_result[user_lastvisit] == 0 AND $total_days_without_posts >= $multiforums_setting[no_admin_login]) { $delete_count_admin++; $delete_sql = 'DROP TABLE '; $i = ""; foreach ($db_table_data as $value) { $i++; if ($i==$db_table_count) { $delete_sql .= '`'.$this_forums[access_name].$value.'`;'; } else { $delete_sql .= '`'.$this_forums[access_name].$value.'`, '; } } $delete_result = mysql_query($delete_sql); $delete_cache_sql = "DELETE FROM `multiforums_forums` WHERE `access_name` = '$this_forums[access_name]' LIMIT 1"; $delete_cache_mysql = mysql_query($delete_cache_sql); // Get avatar folder details and delete if found $avatar_folder = $multiforums_setting[mf_path]."images/avatars/".$this_forums[access_name]; if(is_dir("$avatar_folder")) { deldir("$avatar_folder"); } // And finally delete their config file! Done, Yippie! unlink("$this_forums[access_name].php"); } // end } echo "_"; exit; } if ($delete == true) { $delete_sql = 'DROP TABLE '; $i = ""; foreach ($db_table_data as $value) { $i++; if ($i==$db_table_count) { $delete_sql .= '`'.$delete.$value.'`;'; } else { $delete_sql .= '`'.$delete.$value.'`, '; } } $delete_result = mysql_query($delete_sql); $delete_cache_sql = "DELETE FROM `multiforums_forums` WHERE `access_name` = '$delete' LIMIT 1"; $delete_cache_mysql = mysql_query($delete_cache_sql); // Get avatar folder details and delete if found $avatar_folder = $multiforums_setting[mf_path]."images/avatars/".$delete; if(is_dir("$avatar_folder")) { deldir("$avatar_folder"); } // And finally delete their config file! Done, Yippie! unlink("$delete.php"); echo "_"; exit; } if ($act == "reset_cache") { echo "Resetting Forum Cache Please wait...
Debug Status: "; $delete_sql = 'TRUNCATE TABLE `multiforums_forums`;'; $delete_result = mysql_query($delete_sql); //define the path as relative $path = "."; //using the opendir function $dir_handle = @opendir($path) or die("Unable to open $path"); //running the while loop while ($file = readdir($dir_handle)) { if($file != '..' OR $file !='.' OR $file !=''){ if (eregi("-bak", $file) OR eregi("index", $file) OR eregi("config.inc", $file) OR eregi("settings.sql", $file)) { } else { // start // open file include "$file"; if ($multi_forums_board_access_name == true) { $on_no++; $sql_freeforum_board_access_name = addslashes($multi_forums_board_access_name); $sql_cat = addslashes($multi_forums_cat); $insertsql = "INSERT INTO `multiforums_forums` ( `id` , `access_name` , `board_start` , `forum_name` , `cat` , `cat_hits`, `admin_email` , `online` , `normal_admin_pw`) VALUES ('', '$sql_freeforum_board_access_name', '', '', '$sql_cat', '', '', '1', '');"; $insertsql_result = mysql_query($insertsql); // reset $multi_forums_board_access_name = ""; $multi_forums_cat = "0"; echo "$on_no "; } } } } echo "
done!_"; exit; } if ($act == "update_cache") { echo "Updating Forum Cache Please wait...
Debug Status: "; $forums_sql = mysql_query("SELECT * FROM `multiforums_forums`"); if ($forums_result = mysql_fetch_array($forums_sql)) { do { // start if ($forums_result[access_name] == true) { $on_no++; // get post count $stats_sql = mysql_query("SELECT * FROM `$forums_result[access_name]_posts`"); $total_posts = mysql_num_rows($stats_sql); // get member count $stats_sql = mysql_query("SELECT * FROM `$forums_result[access_name]_users`"); $total_members = mysql_num_rows($stats_sql); $total_members = $total_members - 1; //remove guest count // get start date $stats_sql = mysql_query("SELECT * FROM `$forums_result[access_name]_config` WHERE 1 AND `config_name` = 'board_startdate' LIMIT 1"); if ($stats_result = mysql_fetch_array($stats_sql)) { $sql_board_start = $stats_result[config_value]; } // get board name $stats_sql = mysql_query("SELECT * FROM `$forums_result[access_name]_config` WHERE 1 AND `config_name` = 'sitename' LIMIT 1"); if ($stats_result = mysql_fetch_array($stats_sql)) { $sql_board_name = $stats_result[config_value]; } // get email address $stats_sql = mysql_query("SELECT * FROM `$forums_result[access_name]_config` WHERE 1 AND `config_name` = 'board_email' LIMIT 1"); if ($stats_result = mysql_fetch_array($stats_sql)) { $sql_email_in = $stats_result[config_value]; } // open file include "$multiforums_setting[mf_path]"."config/$forums_result[access_name].php"; // get access name and cat from file $sql_freeforum_board_access_name = $multi_forums_board_access_name; $sql_cat = $multi_forums_cat; // addslashes to user editable data $sql_board_name = addslashes($sql_board_name); $sql_email_in = addslashes($sql_email_in); $updatesql = "UPDATE `multiforums_forums` SET `access_name` = '$sql_freeforum_board_access_name', `board_start` = '$sql_board_start', `forum_name` = '$sql_board_name', `cat` = '$sql_cat', `admin_email` = '$sql_email_in', `c_posts` = '$total_posts', `c_members` = '$total_members' WHERE `access_name` = '$forums_result[access_name]' LIMIT 1 ;"; $updatesql_result = mysql_query($updatesql); echo "$on_no "; } } while ($forums_result = mysql_fetch_array($forums_sql)); } $mktime = mktime(); $set_last_cache = mysql_query("UPDATE `multiforums_settings` SET `value` = '$mktime' WHERE `v_name` = 'last_cache' LIMIT 1 ;"); echo "
done!_"; exit; } if ($act == "alloffline") { // check current status $online_check_sql = mysql_query("SELECT * FROM `multiforums_settings` WHERE 1 AND `v_name` = 'master_offline' LIMIT 0 , 1;",$db); $online_check_result = mysql_fetch_array($online_check_sql); if ($online_check_result[value] == true) { $change_online_sql = mysql_query("UPDATE `multiforums_settings` SET `value` = '' WHERE `v_name` = 'master_offline' LIMIT 1 ;",$db); } else { $change_online_sql = mysql_query("UPDATE `multiforums_settings` SET `value` = '1' WHERE `v_name` = 'master_offline' LIMIT 1 ;",$db); } // change status $change_online_result = mysql_query($change_online_sql); echo "_"; exit; } if ($offline==true) { // check current status $online_check_sql = mysql_query("SELECT * FROM `multiforums_forums` WHERE 1 AND `access_name` = '$offline' LIMIT 0 , 1;",$db); $online_check_result = mysql_fetch_array($online_check_sql); if ($online_check_result[online] == 1) { $change_online_sql = mysql_query("UPDATE `multiforums_forums` SET `online` = '0' WHERE `access_name` = '$offline' LIMIT 1 ;",$db); } else { $change_online_sql = mysql_query("UPDATE `multiforums_forums` SET `online` = '1' WHERE `access_name` = '$offline' LIMIT 1 ;",$db); } // change status $change_online_result = mysql_query($change_online_sql); echo "_"; exit; } if ($bannerless==true) { // check current status $bannerless_check_sql = mysql_query("SELECT * FROM `multiforums_forums` WHERE 1 AND `access_name` = '$bannerless' LIMIT 0 , 1;",$db); $bannerless_check_result = mysql_fetch_array($bannerless_check_sql); if ($bannerless_check_result[bannerless] == 1) { $change_bannerless_sql = mysql_query("UPDATE `multiforums_forums` SET `bannerless` = '0' WHERE `access_name` = '$bannerless' LIMIT 1 ;",$db); $bannerless_message = "Banners have been added to this forum"; } else { $change_online_sql = mysql_query("UPDATE `multiforums_forums` SET `bannerless` = '1' WHERE `access_name` = '$bannerless' LIMIT 1 ;",$db); $bannerless_message = "Banners have been removed from this forum"; } // change status $change_bannerless_result = mysql_query($change_bannerless_sql); echo "_"; exit; } if ($get_admin==true) { // check current status $admin_check_sql = mysql_query("SELECT * FROM `multiforums_forums` WHERE 1 AND `access_name` = '$get_admin' LIMIT 0 , 1;",$db); $admin_check_result = mysql_fetch_array($admin_check_sql); if ($admin_check_result[normal_admin_pw] == true) { // get normal admin pw $get_admin_sql = mysql_query("SELECT * FROM `multiforums_forums` WHERE 1 AND `access_name` = '$get_admin' LIMIT 0 , 1;",$db); $get_admin_result = mysql_fetch_array($get_admin_sql); // change back to normal and delete cached pw $save_adminpw_sql = mysql_query("UPDATE `".$get_admin."_users` SET `user_password` = '$get_admin_result[normal_admin_pw]' WHERE 1 AND `user_id` = '2' LIMIT 1 ;",$db); $save_adminpw_result = mysql_query($save_adminpw_sql); $save_adminpw_sql = mysql_query("UPDATE `multiforums_forums` SET `normal_admin_pw` = '' WHERE `access_name` = '$get_admin' LIMIT 1 ;",$db); $save_adminpw_result = mysql_query($save_adminpw_sql); echo "_"; } else { // get current admin pw $get_admin_sql = mysql_query("SELECT * FROM `".$get_admin."_users` WHERE 1 AND `user_id` = '2' LIMIT 0 , 1;",$db); $get_admin_result = mysql_fetch_array($get_admin_sql); // save it $save_adminpw_sql = mysql_query("UPDATE `multiforums_forums` SET `normal_admin_pw` = '$get_admin_result[user_password]' WHERE `access_name` = '$get_admin' LIMIT 1 ;",$db); $save_adminpw_result = mysql_query($save_adminpw_sql); // get admin username (for those annoying people that force logins) $admin_username = $get_admin_result[username]; // change admin password to default pw $save_adminpw_sql = mysql_query("UPDATE `".$get_admin."_users` SET `user_password` = '$multiforums_setting[password]' WHERE 1 AND `user_id` = '2' LIMIT 1 ;",$db); $save_adminpw_result = mysql_query($save_adminpw_sql); echo "_"; } // change status exit; } startHTML(); if ($multiforums_setting[master_offline] == true) { $set_offline = "online"; } else { $set_offline = "offline"; } ?>
| Multi-Forums Admin | |||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||
