/**
* Delete a user
*
* @param int $uid id of user to delete
* @return string HTML redirect
*
*/
function deleteUser($uid)
{
global $_CONF;
if (!USER_deleteAccount($uid)) {
return COM_refresh($_CONF['site_admin_url'] . '/user.php');
}
return COM_refresh($_CONF['site_admin_url'] . '/user.php?msg=22');
}
/**
* Delete an account
*
* @param string form_reqid request id
* @return string redirection to main page (+ success msg)
*
*/
function deleteUserAccount($form_reqid)
{
global $_CONF, $_TABLES, $_USER;
if (DB_count($_TABLES['users'], array('pwrequestid', 'uid'), array($form_reqid, $_USER['uid'])) != 1) {
// not found - abort
return COM_refresh($_CONF['site_url'] . '/index.php');
}
if (!USER_deleteAccount($_USER['uid'])) {
return COM_refresh($_CONF['site_url'] . '/index.php');
}
return COM_refresh($_CONF['site_url'] . '/index.php?msg=57');
}
function SFS_delUsers()
{
global $_USER, $_CONF, $_TABLES, $LANG_SFS, $LANG28;
$msg = '';
if (isset($_POST['actionitem']) and is_array($_POST['actionitem'])) {
foreach ($_POST['actionitem'] as $actionitem) {
$uid = COM_applyFilter($actionitem);
if ($uid != 2 && $uid != $_USER['uid']) {
if (defined('DVLP_VERSION')) {
print "We would delete userid " . $uid . " here<br />";
} else {
if (!USER_deleteAccount($uid)) {
$msg .= "<strong>{$LANG28[2]} {$delitem} {$LANG28[70]}</strong><br/>\n";
}
}
}
}
}
CACHE_remove_instance('mbmenu');
return $LANG_SFS['confirmation_del'] . '<br />' . $msg;
}
function fncdelete()
{
global $_CONF;
global $_TABLES;
global $LANG_DATABOX_ADMIN;
$id = COM_applyFilter($_POST['id'], true);
$username = DB_getItem($_TABLES['users'], "username", "uid={$id}");
$email = DB_getItem($_TABLES['users'], "email", "uid={$id}");
// CHECK
$err = "";
if ($err != "") {
$retval['title'] = $LANG_DATABOX_ADMIN['err'];
$retval['display'] = $err;
return $retval;
}
// if (!USER_deleteAccount ($id)) {
// $return_page=$_CONF['site_admin_url'] . '/plugins/'.THIS_SCRIPT.'?msg=3';
// }else{
// $return_page=$_CONF['site_admin_url'] . '/plugins/'.THIS_SCRIPT.'?msg=2';
// }
if (!USER_deleteAccount($id)) {
$msg = 3;
} else {
$msg = 2;
}
$rt = fncsendmail('data_delete', $id, $username, $email);
$cacheInstance = 'userbox__' . $id . '__';
CACHE_remove_instance($cacheInstance);
//exit;// debug 用
//return COM_refresh ($return_page);
$retval['title'] = $LANG_USERBOX_ADMIN['piname'];
$retval['display'] = COM_showMessage($msg, 'userbox');
$retval['display'] .= fncList();
return $retval;
}
/**
* Delete a user
*
* @param int $uid id of user to delete
* @return string HTML redirect
*
*/
function USER_delete($uid)
{
global $_CONF;
if (!USER_deleteAccount($uid)) {
return COM_refresh($_CONF['site_admin_url'] . '/user.php');
}
CACHE_remove_instance('mbmenu');
COM_setMessage(22);
return COM_refresh($_CONF['site_admin_url'] . '/user.php');
}
/**
* Moderate user submissions
*
* Users from the user submission queue are either appoved (an email containing
* the password is sent out) or deleted.
*
* @param int $uid Array of items
* @param array $action Action to perform ('delete', 'approve')
* @param int $count Number of items
* @return string HTML for "command and control" page
*
*/
function moderateusers($uid, $action, $count)
{
global $_CONF, $_TABLES, $LANG04;
$retval = '';
// Set true if an valid action other then delete_all is selected
$formaction = false;
for ($i = 0; $i < $count; $i++) {
if (isset($action[$i]) and $action[$i] != '') {
$formaction = true;
} else {
continue;
}
switch ($action[$i]) {
case 'delete':
// Ok, delete everything related to this user
if ($uid[$i] > 1) {
USER_deleteAccount($uid[$i]);
}
break;
case 'approve':
$uid[$i] = COM_applyFilter($uid[$i], true);
$result = DB_query("SELECT email,username, uid FROM {$_TABLES['users']} WHERE uid = {$uid[$i]}");
$nrows = DB_numRows($result);
if ($nrows == 1) {
$A = DB_fetchArray($result);
$sql = "UPDATE {$_TABLES['users']} SET status=3 WHERE uid={$A['uid']}";
DB_query($sql);
USER_createAndSendPassword($A['username'], $A['email'], $A['uid']);
}
break;
}
}
// Check if there was no direct action used on the form
// and if the delete_all submit action was used
if (!$formaction and isset($_POST['delitem'])) {
foreach ($_POST['delitem'] as $del_uid) {
$del_uid = COM_applyFilter($del_uid, true);
if ($del_uid > 1) {
USER_deleteAccount($del_uid);
}
}
}
$retval .= commandcontrol(SEC_createToken());
return $retval;
}
function fncdelete()
{
global $_CONF;
global $_TABLES;
global $LANG_DATABOX_ADMIN;
global $_USER;
$pi_name = "userbox";
$id = COM_applyFilter($_POST['id'], true);
$username = DB_getItem($_TABLES['users'], "username", "uid={$id}");
$email = DB_getItem($_TABLES['users'], "email", "uid={$id}");
// CHECK
$err = "";
if ($err != "") {
$page_title = $LANG_DATABOX_ADMIN['err'];
$retval .= DATABOX_siteHeader($pi_name, '_admin', $page_title);
$retval .= COM_startBlock($LANG_USERBOX_ADMIN['err'], '', COM_getBlockTemplate('_msg_block', 'header'));
$retval .= $err;
$retval .= COM_endBlock(COM_getBlockTemplate('_msg_block', 'footer'));
$retval .= DATABOX_siteFooter($pi_name, '_admin');
return $retval;
}
if (!USER_deleteAccount($id)) {
$return_page = $_CONF['site_url'] . '/index.php';
}
$return_page = $_CONF['site_url'] . '/index.php?msg=57';
$rt = fncsendmail('data_delete', $id, $username, $email);
$cacheInstance = 'userbox__' . $id . '__';
CACHE_remove_instance($cacheInstance);
//exit;// debug 用
return COM_refresh($return_page);
}
/**
* Moderates a single item
*
* This will actually perform moderation (approve or delete) one or more items
*
* @param string $action Action to perform ('delete' or 'approve')
* @param string $type Type of item ('user', 'draftstory', 'story', etc.)
* @param string $id ID of item to approve or delete
* @return string HTML for "command and control" page
*
*/
function MODERATE_item($action = '', $type = '', $id = '')
{
global $_CONF, $_TABLES;
$retval = '';
if (empty($action)) {
// null action
$retval .= COM_errorLog("Submissions Error: An attempt was made to moderate an item with a null action.");
return $retval;
}
if (empty($type)) {
// null item type
$retval .= COM_errorLog("Submissions Error: An attempt was made to moderate a null item type.");
return $retval;
}
if (empty($id)) {
// null item type
$retval .= COM_errorLog("Submissions Error: An attempt was made to moderate an item with a null id.");
return $retval;
}
list($key, $table, $fields, $submissiontable) = PLG_getModerationValues($type);
switch ($action) {
case 'delete':
switch ($type) {
case 'user':
// user
if ($id > 1) {
USER_deleteAccount($id);
}
break;
case 'story':
// story (needs to move to a plugin)
DB_delete($submissiontable, "{$key}", $id);
break;
case 'draftstory':
// draft story
STORY_deleteStory($id);
break;
default:
// plugin
$retval .= PLG_deleteSubmission($type, $id);
DB_delete($submissiontable, "{$key}", $id);
break;
}
break;
case 'approve':
switch ($type) {
case 'story':
// story (needs to move to a plugin)
$result = DB_query("SELECT * FROM {$submissiontable} WHERE {$key} = '{$id}'");
$A = DB_fetchArray($result);
$A['related'] = DB_escapeString(implode("\n", STORY_extractLinks($A['introtext'])));
$A['owner_id'] = $A['uid'];
$A['title'] = DB_escapeString($A['title']);
$A['introtext'] = DB_escapeString($A['introtext']);
$A['bodytext'] = DB_escapeString($A['bodytext']);
$result = DB_query("SELECT group_id,perm_owner,perm_group,perm_members,perm_anon,archive_flag FROM {$_TABLES['topics']} WHERE tid = '{$A['tid']}'");
$T = DB_fetchArray($result);
if ($T['archive_flag'] == 1) {
$frontpage = 0;
} else {
if (isset($_CONF['frontpage'])) {
$frontpage = $_CONF['frontpage'];
} else {
$frontpage = 1;
}
}
DB_save($table, 'sid,uid,tid,title,introtext,bodytext,related,date,show_topic_icon,commentcode,trackbackcode,postmode,frontpage,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon', "'{$A['sid']}',{$A['uid']},'{$A['tid']}','{$A['title']}','{$A['introtext']}','{$A['bodytext']}','{$A['related']}','{$A['date']}','{$_CONF['show_topic_icon']}','{$_CONF['comment_code']}','{$_CONF['trackback_code']}','{$A['postmode']}',{$frontpage},{$A['owner_id']},{$T['group_id']},{$T['perm_owner']},{$T['perm_group']},{$T['perm_members']},{$T['perm_anon']}");
DB_delete($submissiontable, "{$key}", $id);
PLG_itemSaved($A['sid'], 'article');
COM_rdfUpToDateCheck();
COM_olderStuff();
break;
case 'draftstory':
// draft story
DB_query("UPDATE {$table} SET draft_flag = 0 WHERE {$key} = '{$id}'");
COM_rdfUpToDateCheck();
COM_olderStuff();
break;
case 'user':
// user
$result = DB_query("SELECT {$fields} FROM {$table} WHERE {$key} = '{$id}'");
$nrows = DB_numRows($result);
if ($nrows == 1) {
$A = DB_fetchArray($result);
if ($_CONF['registration_type'] == 1) {
$sql = "UPDATE {$table} SET status=" . USER_ACCOUNT_AWAITING_VERIFICATION . " WHERE {$key} = '{$A['uid']}'";
} else {
$sql = "UPDATE {$table} SET status=" . USER_ACCOUNT_AWAITING_ACTIVATION . " WHERE {$key} = '{$A['uid']}'";
}
DB_query($sql);
USER_createAndSendPassword($A['username'], $A['email'], $A['uid']);
}
break;
default:
// plugin
DB_copy($table, $fields, $fields, $submissiontable, $key, $id);
$retval .= PLG_approveSubmission($type, $id);
break;
}
break;
}
// switch ($action)
return $retval;
}
/**
* Delete a user
*
* @param int $uid id of user to delete
* @return string HTML redirect
*
*/
function deleteUser($uid)
{
global $_CONF;
if (!USER_deleteAccount($uid)) {
COM_redirect($_CONF['site_admin_url'] . '/user.php');
}
COM_redirect($_CONF['site_admin_url'] . '/user.php?msg=22');
}
function fncdeleteexec()
{
global $_CONF;
global $_TABLES;
global $LANG_ASSIST_ADMIN;
require_once $_CONF['path_system'] . 'lib-user.php';
// true:画面にもOKNG経過表示,ログファイルへ出力
// false:ログファイルへ出力のみ
$verbose_delete = true;
$retval = '';
$uidfrom = "";
$uidto = "";
if (isset($_REQUEST['uidfrom'])) {
$uidfrom = COM_applyFilter($_REQUEST['uidfrom'], true);
if ($uidfrom <= 0) {
$uidfrom = 3;
}
}
if (isset($_REQUEST['uidto'])) {
$uidto = COM_applyFilter($_REQUEST['uidto'], true);
if ($uidfrom <= 0) {
$uidfrom = 3;
}
}
$sql = "SELECT ";
$sql .= " t.uid ";
$sql .= " FROM ";
$sql .= " {$_TABLES['users']} AS t ";
$sql .= " WHERE ";
$sql .= " t.uid>={$uidfrom}";
$sql .= " AND t.uid<={$uidto}";
$result = DB_query($sql);
$numrows = DB_numRows($result);
$retval .= COM_startBlock($LANG_ASSIST_ADMIN['delete'], '', COM_getBlockTemplate('_admin_block', 'header'));
$c = 0;
if ($numrows > 0) {
for ($i = 0; $i < $numrows; $i++) {
$A = DB_fetchArray($result);
if (!USER_deleteAccount($A["uid"])) {
$w = "<br" . XHTML . ">";
$w .= "<b>{$A['uid']}</b> delete error";
$w .= "<br" . XHTML . ">\n";
COM_errorLog($w, 1);
if ($verbose_delete) {
$retval .= $w;
}
} else {
$c++;
// count the deleted users
$w = "<br" . XHTML . ">";
$w .= "<b>{$A['uid']}</b> deleted";
$w .= "<br" . XHTML . ">\n";
COM_errorLog($w, 1);
if ($verbose_delete) {
$retval .= $w;
}
}
}
}
COM_numberFormat($c);
$retval .= "delete count: {$c}<br" . XHTML . ">\n";
$retval .= COM_endBlock(COM_getBlockTemplate('_admin_block', 'footer'));
return $retval;
}
