if (isset($row['nletter_active'])) { $nletter_activation = $cfg['mainurl'] . "/plug.php?e=newsletter&email=" . $nletter_email . "&activate=" . $row['nletter_activation']; } else { $sql = sed_sql_query("INSERT INTO sed_newsletter (nletter_email, nletter_date, nletter_activation) values ('{$nletter_email}', '" . $sys['now'] . "', '{$nletter_activation}')"); $nletter_activation = $cfg['mainurl'] . "/plug.php?e=newsletter&email=" . $nletter_email . "&activate=" . $nletter_activation; } $nlsubject = $L['plu_amail_subject']; $nlbody = sprintf($L['plu_amail_body'], $nletter_activation); sed_mail($nletter_email, $nlsubject, $nlbody); $plugin_body = "<p style=\"text-align:center;\">" . $L['plu_joined'] . "</p>"; } } elseif ($a == $L['plu_cancel']) { $sql = sed_sql_query("SELECT nletter_activation FROM sed_newsletter WHERE nletter_email='{$nletter_email}' LIMIT 1"); $error_string .= sed_sql_numrows($sql) != 1 ? $L['plu_email_cancelfailed'] . "<br />" : ''; if (empty($error_string)) { $row = sed_sql_fetcharray($sql); $nletter_cancel = $cfg['mainurl'] . "/plug.php?e=newsletter&email=" . $nletter_email . "&cancel=" . $row['nletter_activation']; $nlsubject = $L['plu_cmail_subject']; $nlbody = sprintf($L['plu_cmail_body'], $nletter_cancel); sed_mail($nletter_email, $nlsubject, $nlbody); $plugin_body = "<p style=\"text-align:center;\">" . $L['plu_canceled'] . "</p>"; } } if (empty($plugin_body)) { $plugin_body .= $L['plu_intro']; $plugin_body .= $error_string ? "<p><span style=\"color:red;\">" . $error_string . "</span></p>" : ""; $plugin_body .= "<form name='newsletter' action='plug.php?e=newsletter' method='post'>"; $plugin_body .= "<p>" . $L['plu_email'] . ":<input type=\"text\" name=\"nletter_email\" value=\"\" size=\"36\" maxlength=\"64\">"; $plugin_body .= "<input type='submit' name='a' value='" . $L['plu_join'] . "'>"; $plugin_body .= "<input type='submit' name='a' value='" . $L['plu_cancel'] . "'></p>"; $plugin_body .= "</form>";
$uwd_setreprievedate = TRUE; } if ($uwd_setreprievedate == TRUE) { //send them a mail to give them a chance to come back 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";
$sql = sed_sql_query("SELECT page_ownerid, page_cat FROM {$db_pages} WHERE page_id='{$id}' LIMIT 1"); if ($row = sed_sql_fetcharray($sql)) { $usr['isadmin'] = sed_auth('page', $row['page_cat'], 'A'); $usr['isadmin'] = $row['page_ownerid'] == $usr['id'] ? TRUE : $usr['isadmin']; sed_block($usr['isadmin']); $sql = sed_sql_query("UPDATE {$db_pages} SET page_state=1 WHERE page_id='{$id}'"); sed_cache_clear('latestpages'); header("Location: list.php?c=" . $row['page_cat']); exit; } else { sed_die(); } } $sql = sed_sql_query("SELECT * FROM {$db_pages} WHERE page_id='{$id}' LIMIT 1"); sed_die(sed_sql_numrows($sql) == 0); $pag = sed_sql_fetcharray($sql); $pag['page_date'] = sed_selectbox_date($pag['page_date'] + $usr['timezone'] * 3600, 'long'); $pag['page_begin'] = sed_selectbox_date($pag['page_begin'] + $usr['timezone'] * 3600, 'long', '_beg'); $pag['page_expire'] = sed_selectbox_date($pag['page_expire'] + $usr['timezone'] * 3600, 'long', '_exp'); list($usr['auth_read'], $usr['auth_write'], $usr['isadmin']) = sed_auth('page', $pag['page_cat']); $usr['isadmin'] = $pag['page_ownerid'] == $usr['id'] ? TRUE : $usr['isadmin']; sed_block($usr['isadmin']); $page_form_delete = "<input type=\"radio\" class=\"radio\" name=\"rpagedelete\" value=\"1\" />" . $L['Yes'] . " <input type=\"radio\" class=\"radio\" name=\"rpagedelete\" value=\"0\" checked=\"checked\" />" . $L['No']; $page_form_categories = sed_selectbox_categories($pag['page_cat'], 'rpagecat'); $page_form_type = "<select name=\"rpagetype\" size=\"1\">"; $selected0 = $pag['page_type'] == 0 ? "selected=\"selected\"" : ''; $selected1 = $pag['page_type'] == 1 ? "selected=\"selected\"" : ''; $selected2 = $pag['page_type'] == 2 && $usr['maingrp'] == 5 ? "selected=\"selected\"" : ''; $page_form_type .= "<option value=\"0\" {$selected0}>" . $L['Default'] . "</option>"; $page_form_type .= "<option value=\"1\" {$selected1}>HTML</option>"; $page_form_type .= $usr['maingrp'] == 5 && $cfg['allowphp_pages'] ? "<option value=\"2\" {$selected2}>PHP</option>" : '';