//save the reprieve date in the banexpire field $sqltmp = sed_sql_query("UPDATE {$db_users} SET " . $uwd_reprieveslot . "='{$uwd_now}' WHERE user_id='{$uwd_userid}'"); $uwd_counter++; } } if ($uwd_counter > 0) { sed_log("User watchdog plugin sent " . $uwd_counter . " inactivity warning(s)", 'adm'); } //delete user which reached the reprieve date $sql = sed_sql_query("SELECT user_id, user_name FROM {$db_users} WHERE " . $uwd_reprieveslot . ">'0' AND " . $uwd_reprieveslot . "<'{$uwd_reprieve}'"); while ($row = sed_sql_fetcharray($sql)) { //if there is the trashcan enabled, we put it there if ($cfg['trash_user']) { $sqltrash = sed_sql_query("SELECT * FROM {$db_users} WHERE user_id='" . $row['user_id'] . "'"); if ($rowtrash = sed_sql_fetchassoc($sqltrash)) { sed_trash_put('user', $L['User'] . " #" . $rowtrash['user_id'] . " " . $rowtrash['user_name'], $rowtrash['user_id'], $rowtrash); } } $sqldel = sed_sql_query("DELETE FROM {$db_users} WHERE user_id='" . $row['user_id'] . "'"); $sqldel = sed_sql_query("DELETE FROM {$db_groups_users} WHERE gru_userid='" . $row['user_id'] . "'"); if ($cfg['plugin']['userwatchdog']['uwd_delpfs']) { sed_pfs_deleteall($row['user_id']); //Avatar, Photo, Signature cleaning idea by Kilandor $uwd_avatar = $cfg['av_dir'] . $row['user_id'] . "-avatar.gif"; $uwd_photo = $cfg['photos_dir'] . $row['user_id'] . "-photo.gif"; $uwd_signature = $cfg['sig_dir'] . $row . "-signature.gif"; @unlink($avatar); @unlink($photo); @unlink($signature); } if ($cfg['trash_user']) {
$pageexpireaction = trim(strtolower($cfg['plugin']['hidefuturepages']['pageexpireaction'])); if ($cfg['trash_page']) { $sql_expiredpages = sed_sql_query("SELECT * FROM {$db_pages} WHERE page_expire<" . (int) $sys['now_offset'] . " && page_state!='4'"); } else { $sql_expirepages = sed_sql_query("SELECT page_id, page_cat FROM {$db_pages} WHERE page_expire<" . (int) $sys['now_offset'] . " && page_state!='4'"); } while ($expirepages_result = sed_sql_fetchassoc($sql_expiredpages)) { $pageid = (int) $expirepages_result['page_id']; switch ($pageexpireaction) { case 'delete': if ($cfg['trash_page']) { $newtempexpiredate = $sys['now_offset'] + 31556926 * 7; $expirepages_result['page_expire'] = (int) $newtempexpiredate; $expirepages_result['page_state'] = 1; $expirepages_result['page_comcount'] = 0; sed_trash_put('page', $expirepages_result['page_title'], $expirepages_result['page_id'], $expirepages_result); } $sql_pagestatus = sed_sql_query("DELETE FROM {$db_pages} WHERE page_id='" . (int) $expirepages_result['page_id'] . "'"); sed_log("Deleted page #" . (int) $expirepages_result['page_id'], 'adm'); sed_sql_query("UPDATE {$db_structure} SET structure_pagecount=structure_pagecount-1 WHERE structure_code='" . sed_sql_prep($expirepages_result['page_cat']) . "'"); if ($cfg['plugin']['hidefuturepages']['deletepagerelated'] == 'Yes') { $pagecode = "p" . $pageid; sed_sql_query("DELETE FROM {$db_ratings} WHERE rating_code='{$pagecode}'"); sed_sql_query("DELETE FROM {$db_rated} WHERE rated_code='{$pagecode}'"); sed_sql_query("DELETE FROM {$db_com} WHERE com_code='{$pagecode}'"); } break; case 'hide': $sql_pagestatus = sed_sql_query("UPDATE {$db_pages} SET page_state='4' WHERE page_id='{$pageid}'"); break; }