public function delete()
{
include_once "models/Users.php";
$users = new Users();
$users->delete();
//header("Location: ../logout");
}
public function deleteAction($userId)
{
$user = new Users();
$user->id = $userId;
$user->delete();
return $this->dispatcher->forward(array('action' => 'index'));
}
public function pdoDeleteModelAction($id)
{
$users = new Users();
$row = $users->get($id);
if (!empty($row)) {
$users->delete($id);
}
redirect('pdo-database/pdo-model/pdo-model');
}
public function testUserCreate()
{
$model = new Users();
$model->attributes = array('email' => '*****@*****.**', 'password' => 'example_password', 'username' => 'example_user2', 'user_role' => '9', 'status' => '1');
// Verify that we can save a new record
$this->assertTrue($model->save());
// Verify that bcrypt password validation passes
$this->assertTrue(password_verify('example_password', $model->password));
$this->assertTrue($model->delete());
}
/**
* testExists function
* @return void
*/
public function testExists()
{
$this->loadFixtures('User');
$TestModel = new Users();
$this->assertTrue($TestModel->exists(1));
$TestModel->id = 2;
$this->assertTrue($TestModel->exists());
$TestModel->delete();
$this->assertFalse($TestModel->exists());
$this->assertFalse($TestModel->exists(2));
}
/**
* Page
*/
public function usersAction()
{
$usersModel = new Users();
if ($this->getRequest()->isPost()) {
$data = $this->getRequest()->getPost();
if (@$data['method'] == 'create') {
//CREATE NEW USER
unset($data['method']);
if ($data['email'] == '' || $data['password'] == '') {
$this->view->error = "Please complete all fields.";
$this->view->data = $data;
} else {
$data['password'] = sha1($data['password']);
$usersModel->insert($data);
$this->view->success = "New User Created.";
}
}
if (@$data['method'] == 'update') {
//UPDATE USER
unset($data['method']);
if ($data['password'] == '') {
unset($data['password']);
} else {
$data['password'] = sha1($data['password']);
}
$usersModel->updateRecord($data['id'], $data);
$this->view->success = "User Record Updated.";
}
if (@$data['method'] == 'delete') {
//DELETE USER
$where = "id=" . $data['id'];
$usersModel->delete($where);
}
}
$users = $usersModel->getAll();
$page = $this->_getParam('page', 1);
$paginator = Zend_Paginator::factory($users);
$paginator->setItemCountPerPage(20);
$paginator->setCurrentPageNumber($page);
$this->view->users = $paginator;
$locationsModel = new Locations();
$this->view->locations = $locationsModel->getAll();
}
<?php
require_once "config.php";
require_once WWW_DIR . "/lib/content.php";
require_once WWW_DIR . "/lib/adminpage.php";
$page = new AdminPage();
if (isset($_GET['id'])) {
$users = new Users();
$users->delete($_GET['id']);
}
if (isset($_GET['redir'])) {
header("Location: " . $_GET['redir']);
} else {
$referrer = $_SERVER['HTTP_REFERER'];
header("Location: " . $referrer);
}
/**
* Finish the installation - create owner company and administrator
*
* @param void
* @return null
*/
function complete_installation()
{
if (Companies::getOwnerCompany() instanceof Company) {
die('Owner company already exists');
// Somebody is trying to access this method even if the user already exists
}
// if
$this->setLayout('complete_install');
$form_data = array_var($_POST, 'form');
tpl_assign('form_data', $form_data);
if (array_var($form_data, 'submitted') == 'submitted') {
try {
$admin_password = trim(array_var($form_data, 'admin_password'));
$admin_password_a = trim(array_var($form_data, 'admin_password_a'));
if (trim($admin_password) == '') {
throw new Error(lang('password value required'));
}
// if
if ($admin_password != $admin_password_a) {
throw new Error(lang('passwords dont match'));
}
// if
DB::beginWork();
Users::delete();
// clear users table
Companies::delete();
// clear companies table
// Create the administrator user
$administrator = new User();
$administrator->setId(1);
$administrator->setUsername(array_var($form_data, 'admin_username'));
$administrator->setEmail(array_var($form_data, 'admin_email'));
$administrator->setPassword($admin_password);
$administrator->setIsAdmin(true);
$administrator->setAutoAssign(true);
$administrator->save();
// Create the contact for administrator
$administrator_contact = new Contact();
$administrator_contact->setId(1);
$administrator_contact->setCompanyId(1);
$administrator_contact->setEmail(array_var($form_data, 'admin_email'));
$administrator_contact->setUserId($administrator->getId());
$administrator_contact->setDisplayName($administrator->getUsername());
$administrator_contact->save();
// Create a company
$company = new Company();
$company->setId(1);
$company->setClientOfId(0);
$company->setName(array_var($form_data, 'company_name'));
$company->setCreatedById(1);
$company->save();
DB::commit();
$this->redirectTo('access', 'login');
} catch (Exception $e) {
tpl_assign('error', $e);
DB::rollback();
}
// try
}
// if
}
function delete($id)
{
$usersModel = new Users();
$usersModel->delete($id);
redirect('admin/user');
}
function cancelAction()
{
$users_table = new Users();
$username = $this->_identity->username;
if ($this->getRequest()->isPost())
{
$del = strtolower($this->_request->getPost('delete'));
if ($del == 'yes' && !is_null($username))
{
$params = array('username' => $username, 'delete_row' => true);
$params = $this->_rivety_plugin->doFilter($this->_mca . "_pre_delete", $params); // FILTER HOOK
if ($params['delete_row'])
{
$where = $users_table->getAdapter()->quoteInto('username = ?', $username);
$users_table->delete($where);
}
$this->_rivety_plugin->doAction($this->_mca . "_post_delete", $params); // ACTION HOOK
}
$this->_redirect('/default/auth/logout');
}
else
{
if (!is_null($username))
{
$user = $users_table->fetchByUsername($username);
if (!is_null($user)) $this->view->user = $user->toArray();
else $this->_redirect('/');
}
}
}
public function wizard_deleteUser()
{
if (!isset($_SESSION['CATS']) || empty($_SESSION['CATS'])) {
echo 'CATS has lost your session!';
return;
}
/* Bail out if the user doesn't have SA permissions. */
if ($this->_realAccessLevel < ACCESS_LEVEL_SA) {
echo 'You do not have access to delete a user.';
return;
}
if (isset($_GET[$id = 'userID'])) {
$userID = intval($_GET[$id]);
} else {
echo 'Unable to find the user you are trying to delete.';
return;
}
if ($userID == $_SESSION['CATS']->getUserID()) {
echo 'You cannot delete yourself!';
return;
}
$users = new Users($this->_siteID);
$users->delete($userID);
echo 'Ok';
}
/**
* Test nested transaction
*
* @return void
*/
public function testNestedTransaction()
{
$this->skipIf($this->Dbo->nestedTransactionSupported() === false, 'The Sqlite version do not support nested transaction');
$this->loadFixtures('User');
$model = new Users();
$model->hasOne = $model->hasMany = $model->belongsTo = $model->hasAndBelongsToMany = array();
$model->cacheQueries = false;
$this->Dbo->cacheMethods = false;
$this->assertTrue($this->Dbo->begin());
$this->assertNotEmpty($model->read(null, 1));
$this->assertTrue($this->Dbo->begin());
$this->assertTrue($model->delete(1));
$this->assertEmpty($model->read(null, 1));
$this->assertTrue($this->Dbo->rollback());
$this->assertNotEmpty($model->read(null, 1));
$this->assertTrue($this->Dbo->begin());
$this->assertTrue($model->delete(1));
$this->assertEmpty($model->read(null, 1));
$this->assertTrue($this->Dbo->commit());
$this->assertEmpty($model->read(null, 1));
$this->assertTrue($this->Dbo->rollback());
$this->assertNotEmpty($model->read(null, 1));
}
if ($_POST['_method'] == 'put') {
$user = new Users($_GET['id']);
$user->id = $_GET['id'];
$user->name = $_POST['name'];
$user->birthday = $_POST['birthday'];
$user->address = $_POST['address'];
$user->username = $_POST['username'];
$user->email = $_POST['email'];
$user->password = $_POST['password'];
$user->credit = $_POST['credit'];
$user->image = $_POST['image'];
$user->update();
} else {
if ($_POST['_method'] == 'delete') {
$user = new Users($_GET['id']);
$user->delete();
$rest = new User_server();
$rest->handle_response('Deleted', 400);
// $response['data'] = 'Deleted';
// $response['status'] = 'Bad Request';
// $json_response = json_encode($response);
// echo $json_response;
}
}
} else {
//insert action
$user = new Users();
$user->name = $_POST['name'];
$user->birthday = $_POST['birthday'];
$user->address = $_POST['address'];
$user->username = $_POST['username'];
return putJsonBody(array('error' => true, 'error_code' => $code, 'msg' => $body), 400, $response);
}
/* Handle new user */
$app->post('/user/new', function ($request, $response) {
$data = parseJsonBody($request);
return Users::create($response, $data);
});
/* Handle authenticate user */
$app->post('/user/me', function ($request, $response) {
$data = parseJsonBody($request);
return Users::auth($response, $data);
});
/* Handle delete current user */
$app->delete('/user/me', function ($request, $response) {
$token = parseToken($request);
return Users::delete($response, $token);
});
/* Handle get user info */
$app->get('/user/{id:[0-9]+}/info', function ($request, $response, $args) {
$token = parseToken($request);
$friend_id = $args['id'];
return UsersInfo::get($response, $token, $friend_id);
});
/* Handle get my info */
$app->get('/user/me/info', function ($request, $response) {
$token = parseToken($request);
return UsersInfo::get($response, $token, null);
});
/* Handle update my info */
$app->put('/user/me/info', function ($request, $response) {
$token = parseToken($request);
<?php
require_once CODE_ROOT . '/classes/users.php';
$users = new Users();
if (empty($request_uri[2])) {
$request_uri[2] = '';
}
$userId = filter_input(INPUT_GET, 'userId', FILTER_VALIDATE_INT);
switch ($request_uri[2]) {
case '':
case 'edit':
if (!empty($request_uri[3]) && is_numeric($request_uri[3])) {
$urlData['id'] = $request_uri[3];
} else {
$urlData['id'] = 0;
}
$users->edit($urlData['id']);
$users->_list();
break;
case 'delete':
if (!empty($request_uri[3])) {
$urlData['id'] = $request_uri[3];
if (is_numeric($urlData['id'])) {
$users->delete($urlData['id']);
}
}
break;
}
$result = $users->result;
function deleteAction()
{
$request = new RivetyCore_Request($this->getRequest());
$users_table = new Users();
$username = $request->username;
if ($this->getRequest()->isPost()) {
$del = strtolower($request->delete);
if ($del == 'yes' && !is_null($username)) {
$params = array('username' => $username, 'delete_row' => true);
$params = $this->_rivety_plugin->doFilter($this->_mca . "_pre_delete", $params); // FILTER HOOK
if ($params['delete_row']) {
$where = $users_table->getAdapter()->quoteInto('username = ?', $username);
$users_table->delete($where);
}
$this->_rivety_plugin->doAction($this->_mca . "_post_delete", $params); // ACTION HOOK
$this->view->success = "User '".$username."' has been deleted.";
$this->view->username = $username;
} else {
$this->_redirect('/default/useradmin/index');
}
} else {
$this->view->notice = "Warning: You are about to delete user '".$username."'. This cannot be undone.";
if (!is_null($username)) {
$user = $users_table->fetchByUsername($username);
if (!is_null($user)) {
$this->view->user = $user->toArray();
$this->view->username = $user->username;
} else {
$this->_redirect('/default/useradmin/index');
}
}
}
}
public static function delete()
{
if ($_GET['delete'] != "") {
try {
Users::delete($_GET['delete']);
$_SESSION['msg'] = 'success">Deletado!';
} catch (pdoexception $e) {
$_SESSION['msg'] = 'fail">Erro.';
}
}
header('Location: ../views/subscribers');
}
if (!defined('DOCROOT')) {
die('No direct access');
}
require DOCROOT . '/includes/classes/users.php';
$Users = new Users();
$api_action = $GPXIN['action'];
$api_relid = $GPXIN['id'];
$usr_userid = $GPXIN['userid'];
$usr_username = $GPXIN['username'];
$usr_password = $GPXIN['password'];
$usr_email = $GPXIN['email'];
$usr_first_name = $GPXIN['first_name'];
$usr_last_name = $GPXIN['last_name'];
$usr_language = $GPXIN['language'];
$usr_theme = $GPXIN['theme'];
// Create user
if ($api_action == 'create') {
// Returns a userid if successful
$result_create = $Users->create($usr_username, $usr_password, $usr_email, $usr_first_name, $usr_last_name);
if (is_numeric($result_create)) {
echo 'success';
} else {
echo $result_create;
}
} elseif ($api_action == 'update') {
echo $Users->update($usr_userid, $usr_username, $usr_password, $usr_email, $usr_first_name, $usr_last_name, $usr_language, $usr_theme);
} elseif ($api_action == 'delete') {
echo $Users->delete($usr_userid);
} else {
die('Unknown API action');
}
public static function delete($id)
{
session_start();
$headers = apache_request_headers();
$token = $headers['X-Auth-Token'];
if (!$headers['X-Auth-Token']) {
header('Invalid CSRF Token', true, 401);
return print json_encode(array('success' => false, 'status' => 400, 'msg' => 'Invalid CSRF Token / Bad Request / Unauthorized ... Please Login again'), JSON_PRETTY_PRINT);
die;
} else {
if ($token != $_SESSION['form_token']) {
header('Invalid CSRF Token', true, 401);
return print json_encode(array('success' => false, 'status' => 400, 'msg' => 'Invalid CSRF Token / Bad Request / Unauthorized ... Please Login again'), JSON_PRETTY_PRINT);
die;
} else {
Users::delete($id);
}
}
}
function testdataAction()
{
$request = new Bolts_Request($this->getRequest());
if ($this->getRequest()->isPost()) {
$errors = array();
$data_path = $request->data_path;
$data_file = $data_path . "/users.dat";
$image_dir = $data_path . "/images";
$users_table = new Users();
$users_roles_table = new UsersRoles();
if ($request->has("email_domain")) {
$email_domain = $request->email_domain;
} else {
$email_domain = "nowhere.com";
}
if (!file_exists($data_file)) {
$errors[] = $this->_T("Data file missing. Check path.");
} else {
$users = unserialize(file_get_contents($data_file));
if (!is_array($users)) {
$errors[] = $this->_T("Data file is corrupt or something.");
}
}
if (count($errors) == 0) {
$old_users = $users_table->fetchAll();
foreach ($old_users as $old_user) {
if ($users_table->getMetaData($old_user->username, "is_test_user") == "true") {
$where = $users_table->getAdapter()->quoteInto("username = ?", $old_user->username);
$users_table->delete($where);
$users_roles_table->delete($where);
}
}
$count = 0;
foreach ($users as $user) {
$tmp_user = array();
foreach ($user as $key => $value) {
if ($key != "avatar") {
$tmp_user[$key] = $value;
}
}
$tmp_user['email'] = strtolower($tmp_user['username'] . "@" . $email_domain);
$tmp_user['password'] = "******";
$destination_path = $users_table->getAvatarPath($user['username']);
$destination_filename = $users_table->getAvatarPath($user['username'], true);
if (!is_dir($destination_path)) {
mkdir($destination_path, 0777, true);
}
if (file_exists($destination_filename)) {
unlink($destination_filename);
}
$source_image = $image_dir . "/" . $user['avatar'];
copy($source_image, $destination_filename);
$role_data = array("username" => $tmp_user['username'], "role_id" => $tmp_user['role_id']);
$users_roles_table->insert($role_data);
unset($tmp_user['role_id']);
$users_table->insert($tmp_user);
$users_table->setMetaData($tmp_user['username'], "is_test_user", "true");
$save_users[] = $user;
$count++;
}
$this->view->success = "User data loaded. Created " . $count . " users.";
Bolts_Registry::set('test_data_path', $request->data_path);
$this->view->data_path = Bolts_Registry::get('test_data_path');
$this->view->email_domain = $email_domain;
} else {
$this->view->errors = $errors;
$this->view->data_path = Zend_Registry::get('basepath') . "/tmp/testdata";
$this->view->email_domain = $request->email_domain;
}
} else {
$this->view->data_path = Zend_Registry::get('basepath') . "/tmp/testdata";
$this->view->email_domain = "nowhere.com";
$this->view->notice = $this->_T("Warning: If you are reinstalling the test data, the old test data will be overwritten. Users created outside the test data should not be affected.");
}
}
}
$result_create = $Users->create($url_username, $url_password, $url_email, $url_first_name, $url_last_name);
// This outputs the userid created for the API mainly, so print success here
if (is_numeric($result_create)) {
echo 'success';
} else {
echo $result_create;
}
} elseif ($url_do == 'save') {
if (isset($_SESSION['gpx_admin'])) {
$use_userid = $url_id;
} else {
$use_userid = $gpx_userid;
}
echo $Users->update($use_userid, $url_username, $url_password, $url_email, $url_first_name, $url_last_name, $url_language, $url_theme);
} elseif ($url_do == 'delete') {
echo $Users->delete($url_id);
} elseif ($url_do == 'save_perms') {
$perm_ftp = $GPXIN['ftp'];
$perm_files = $GPXIN['fm'];
$perm_startup = $GPXIN['str'];
$perm_chpass = $GPXIN['chpass'];
$perm_updetails = $GPXIN['upd'];
// Admins only
if (isset($_SESSION['gpx_admin'])) {
@mysql_query("UPDATE users SET perm_ftp = '{$perm_ftp}',perm_files = '{$perm_files}',perm_startup = '{$perm_startup}',perm_chpass = '******',perm_updetails = '{$perm_updetails}' WHERE id = '{$url_id}'") or die('Failed to update permissions!');
} else {
die('You are not authorized to do this!');
}
echo 'success';
}
/**
* 删除
*/
public function actionDelete($id)
{
$id = (int) $id;
$Users = new Users();
$Users->delete(array('userid' => $id));
$this->Log->saveLogs('删除用户', 1, array('userid' => $id));
$this->Common->exportResult(true, '成功！');
}
/**
* Delete users by company
*
* @param Company $company
* @return boolean
*/
function deleteByCompany($company)
{
return Users::delete(array('company_id = ?', $company->getId()));
}
public function post_delete($userID)
{
Users::delete($userID);
return Redirect::to('admin/users');
}
// permission denied
} elseif (!$permitted) {
Safe::header('Status: 401 Unauthorized', TRUE, 401);
Logger::error(i18n::s('You are not allowed to perform this operation.'));
// no deletion in demo mode
} elseif (isset($_REQUEST['confirm']) && $_REQUEST['confirm'] == 'yes' && file_exists($context['path_to_root'] . 'parameters/demo.flag')) {
Safe::header('Status: 401 Unauthorized', TRUE, 401);
Logger::error(i18n::s('You are not allowed to perform this operation in demonstration mode.'));
// deletion is confirmed
} elseif (isset($_REQUEST['confirm']) && $_REQUEST['confirm'] == 'yes') {
// close the session on self-deletion
if (Surfer::get_id() == $item['id']) {
Surfer::reset();
}
// attempt to delete
if (Users::delete($item['id'])) {
// log item deletion
$label = sprintf(i18n::c('Deletion: %s'), strip_tags($item['nick_name']));
$description = Users::get_permalink($item);
Logger::remember('users/delete.php: ' . $label, $description);
// this can appear anywhere
Cache::clear();
// back to the index page
Safe::redirect($context['url_to_home'] . $context['url_to_root'] . 'users/');
}
// deletion has to be confirmed
} elseif (isset($_SERVER['REQUEST_METHOD']) && $_SERVER['REQUEST_METHOD'] == 'POST') {
Logger::error(i18n::s('The action has not been confirmed.'));
} else {
// the submit button
if (Surfer::is($item['id'])) {
function deleteUser()
{
$users = new Users();
if ($_POST["conf"]) {
$conf = $_POST["conf"];
}
$users->delete($conf["personid"]);
goHere("/Maxine/?listusers");
}
}
class Users extends Table
{
// 针对于Users表的操作
function getById()
{
$sql = '.....';
}
}
class Products extends Table
{
// 针对Products表的操作
function showoff()
{
$sql = 'XXXX products';
}
}
class Admins extends Table
{
function changePermissions()
{
$sql = '....';
}
}
$users = new Users();
$users->delete();
echo '这张表叫', $users->getTableName(), '<br/><br/>';
$p = new Products();
$p->update();
$a = new Admins();
$a->insert();
function deleteUser()
{
$users = new Users();
if ($_POST["conf"]) {
$conf = $_POST["conf"];
}
$users->delete($conf["personid"]);
goHere("index.php?mode=maxine/index&action=listusers");
}
/**
* Finish the installation - create owner company and administrator
*
* @param void
* @return null
*/
function complete_installation()
{
if (Companies::getOwnerCompany() instanceof Company) {
die('Owner company already exists');
// Somebody is trying to access this method even if the user already exists
}
// if
$form_data = array_var($_POST, 'form');
tpl_assign('form_data', $form_data);
if (array_var($form_data, 'submited') == 'submited') {
try {
$admin_password = trim(array_var($form_data, 'admin_password'));
$admin_password_a = trim(array_var($form_data, 'admin_password_a'));
if (trim($admin_password) == '') {
throw new Error(lang('password value required'));
}
// if
if ($admin_password != $admin_password_a) {
throw new Error(lang('passwords dont match'));
}
// if
DB::beginWork();
Users::delete();
// clear users table
Companies::delete();
// clear companies table
// Create the administrator user
$administrator = new User();
$administrator->setId(1);
$administrator->setCompanyId(1);
$administrator->setUsername(array_var($form_data, 'admin_username'));
$administrator->setEmail(array_var($form_data, 'admin_email'));
$administrator->setPassword($admin_password);
$administrator->setCanEditCompanyData(true);
$administrator->setCanManageConfiguration(true);
$administrator->setCanManageSecurity(true);
$administrator->setCanManageWorkspaces(true);
$administrator->setCanManageContacts(true);
$administrator->setCanManageTemplates(true);
$administrator->setCanManageReports(true);
$administrator->setCanManageTime(true);
$administrator->setCanAddMailAccounts(true);
$administrator->setAutoAssign(false);
$administrator->setPersonalProjectId(1);
$administrator->setType('admin');
$administrator->save();
$group = new Group();
$group->setName('administrators');
$group->setAllPermissions(true);
$group->setId(Group::CONST_ADMIN_GROUP_ID);
$group->save();
$group_user = new GroupUser();
$group_user->setGroupId(Group::CONST_ADMIN_GROUP_ID);
$group_user->setUserId($administrator->getId());
$group_user->save();
$project = new Project();
$project->setId(1);
$project->setP1(1);
$project->setName(new_personal_project_name($administrator->getUsername()));
$project->setDescription(lang('files'));
$project->setCreatedById($administrator->getId());
$project->save();
$project_user = new ProjectUser();
$project_user->setProjectId($project->getId());
$project_user->setUserId($administrator->getId());
$project_user->setCreatedById($administrator->getId());
$project_user->setAllPermissions(true);
$project_user->save();
// Create a company
$company = new Company();
$company->setId(1);
$company->setClientOfId(0);
$company->setName(array_var($form_data, 'company_name'));
$company->setCreatedById(1);
$company->save();
DB::commit();
$this->redirectTo('access', 'login');
} catch (Exception $e) {
tpl_assign('error', $e);
DB::rollback();
}
// try
}
// if
}
