sed_mail($uwd_email, $uwd_title, $uwd_message);
//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);
}
<?php
/* ====================
[BEGIN_SED_EXTPLUGIN]
Code=hidefuturepages
Part=admin
File=hidefuturepages.admin.page.queue.validate
Hooks=admin.page.queue.validate
Tags=
Order=10
[END_SED_EXTPLUGIN]
==================== */
defined('SED_CODE') or die('Wrong URL');
$sql_select_page = sed_sql_query("SELECT page_state, page_id, page_cat, page_begin FROM {$db_pages} WHERE page_id='{$id}' LIMIT 1");
$result = sed_sql_fetchassoc($sql_select_page);
if ((int) $result['page_begin'] > (int) $sys['now_offset'] && (int) $result['page_state'] == 1) {
sed_block(sed_auth('page', $result['page_cat'], 'A'));
$id = (int) $id;
$sql = sed_sql_query("UPDATE {$db_pages} SET page_state='3' WHERE page_id='{$id}'");
sed_cache_clear('latestpages');
$adminwarnings = '#' . $id . ' - ' . $L['adm_queue_validated'];
sed_redirect(sed_url('admin', 'm=page&s=queue', NULL, TRUE));
}
<?php
/* ====================
[BEGIN_SED_EXTPLUGIN]
Code=hidefuturepages
Part=page
File=hidefuturepages.page.edit.update.first
Hooks=page.edit.update.first
Tags=
Order=10
[END_SED_EXTPLUGIN]
==================== */
defined('SED_CODE') or die('Wrong URL');
$sql_pagestate = sed_sql_query("SELECT page_state FROM {$db_pages} WHERE page_id='{$id}'");
$result_currentpagestate = sed_sql_fetchassoc($sql_pagestate);
$currentpagestate = $result_currentpagestate['page_state'];
Hooks=global
Tags=
Order=1
[END_SED_EXTPLUGIN]
==================== */
defined('SED_CODE') or die('Wrong URL');
sed_sql_query("UPDATE {$db_pages} SET page_state='0' WHERE page_state='3' AND page_begin<=" . (int) $sys['now_offset']);
if (isset($cfg['allowpageexpire']) && $cfg['allowpageexpire']) {
$expirepages_count = 0;
$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;
function hfp_tool_action_set_to_display($id)
{
global $db_pages, $cfg, $sys, $usr, $db_structure;
sed_check_xg();
$id = (int) $id;
$state = sed_import('state', 'G', 'INT', 1);
if ($id > 0) {
$sql = sed_sql_query("SELECT page_cat FROM {$db_pages} WHERE page_id='" . $id . "'");
if ($result = sed_sql_fetchassoc($sql)) {
$pageexpire = hfp_tool_get_yearstillexpire();
sed_sql_query("UPDATE {$db_pages} SET page_begin='" . (int) $sys['now_offset'] . "', page_expire='" . $pageexpire . "', page_state='0' WHERE page_id='{$id}'");
sed_sql_query("UPDATE {$db_structure} SET structure_pagecount=structure_pagecount+1 WHERE structure_code='" . sed_sql_prep($result['page_cat']) . "'");
}
}
sed_redirect(sed_url('admin', 'm=tools&p=hidefuturepages&state=' . $state, NULL, TRUE));
}
