function deleteAction() { $id = AF::get($_POST, 'id', 0); $modelsID = explode(',', $id); $errors = FALSE; foreach ($modelsID as $id) { $model = new Profile(); $model->model_uset_id = $this->user->user_id; if ($model->findByPk($id)) { $model->delete($id); } else { $errors = TRUE; } if ($model->getErrors()) { $errors = TRUE; } unset($model); } if (isset($_POST['ajax'])) { AF::setJsonHeaders('json'); if ($errors) { Message::echoJsonError(__('profile_not_deleted')); } else { $countE = AF::get($_POST, 'countE', 100000); if (count($modelsID) >= $countE) { $link = AF::link(array('profiles' => 'view')); Message::echoJsonRedirect($link); } else { Message::echoJsonSuccess(__('profile_deleted')); } } } $this->redirect(); }
*/ define('INSTALLDIR', realpath(dirname(__FILE__) . '/..')); $shortoptions = 'y'; $longoptions = array('yes'); $helptext = <<<END_OF_HELP clean_profiles.php [options] Deletes all profile table entries where the profile does not occur in the notice table, is not a group and is not a local user. Very MySQL specific I think. WARNING: This has not been tested thoroughly. Maybe we've missed a table to compare somewhere. -y --yes do not wait for confirmation END_OF_HELP; require_once INSTALLDIR . '/scripts/commandline.inc'; if (!have_option('y', 'yes')) { print "About to delete profiles that we think are useless to save. Are you sure? [y/N] "; $response = fgets(STDIN); if (strtolower(trim($response)) != 'y') { print "Aborting.\n"; exit(0); } } print "Deleting"; $profile = new Profile(); $profile->query('SELECT * FROM profile WHERE ' . 'NOT (SELECT COUNT(*) FROM notice WHERE profile_id=profile.id) ' . 'AND NOT (SELECT COUNT(*) FROM user WHERE user.id=profile.id) ' . 'AND NOT (SELECT COUNT(*) FROM user_group WHERE user_group.profile_id=profile.id) ' . 'AND NOT (SELECT COUNT(*) FROM subscription WHERE subscriber=profile.id OR subscribed=profile.id) '); while ($profile->fetch()) { echo ' ' . $profile->getID() . ':' . $profile->getNickname(); $profile->delete(); } print "\nDONE.\n";
<?php /** * Created by PhpStorm. * User: OldManVin * Date: 1/22/2016 * Time: 12:01 PM */ require_once "/etc/apache2/capstone-mysql/encrypted -config.php"; $pdo = connectToEncryptedMySQL("/ect/apache2/data-design/dfontaine1/ini"); require_once "/etc/apache2/capstone-mysql/encrypted-config.php"; require_once "your-class-file.php"; //now use the PDO object normally $tweet = new Profile(null, 1, "this is from php"); $tweet->insert($pdo); $tweet->setProfile("now i change the message"); $tweet->update($pdo); $tweet->delete($pdo);
/** * test creating a Profile and then deleting it **/ public function testDeleteValidProfile() { // count the number of rows and save it for later $numRows = $this->getConnection()->getRowCount("profile"); // create a new Profile and insert to into mySQL $profile = new Profile(null, $this->VALID_ATHANDLE, $this->VALID_EMAIL, $this->VALID_PHONE); $profile->insert($this->getPDO()); // delete the Profile from mySQL $this->assertSame($numRows + 1, $this->getConnection()->getRowCount("profile")); $profile->delete($this->getPDO()); // grab the data from mySQL and enforce the Profile does not exist $pdoProfile = Profile::getProfileByProfileId($this->getPDO(), $profile->getProfileId()); $this->assertNull($pdoProfile); $this->assertSame($numRows, $this->getConnection()->getRowCount("profile")); }
<?php require_once "/etc/apache2/capstone-mysql/encrypted-config.php"; require_once "profile.php"; $pdo = connectToEncryptedMySQL("/etc/apache2/data-design/vhooker.ini"); $profile = new Profile(null, 1, "this is from PHP"); $profile->insert($pdo); $profile->setProfile("now I changed the message"); $profile->update($pdo); $profile->delete($pdo);
*/ include '../inc/includes.php'; Session::checkRight("profile", READ); if (!isset($_GET['id'])) { $_GET['id'] = ""; } $prof = new Profile(); if (isset($_POST["add"])) { $prof->check(-1, CREATE, $_POST); $ID = $prof->add($_POST); // We need to redirect to form to enter rights Html::redirect($CFG_GLPI["root_doc"] . "/front/profile.form.php?id={$ID}"); } else { if (isset($_POST["purge"])) { $prof->check($_POST['id'], PURGE); if ($prof->delete($_POST, 1)) { $prof->redirectToList(); } else { Html::back(); } } else { if (isset($_POST["update"]) || isset($_POST["interface"])) { $prof->check($_POST['id'], UPDATE); $prof->update($_POST); Html::back(); } } } Html::header(Profile::getTypeName(Session::getPluralNumber()), $_SERVER['PHP_SELF'], "admin", "profile"); $prof->display(array('id' => $_GET["id"])); Html::footer();
*/ include '../inc/includes.php'; Session::checkRight("profile", "r"); if (!isset($_GET['id'])) { $_GET['id'] = ""; } $prof = new Profile(); if (isset($_POST["add"])) { $prof->check(-1, 'w', $_POST); $ID = $prof->add($_POST); // We need to redirect to form to enter rights Html::redirect($CFG_GLPI["root_doc"] . "/front/profile.form.php?id={$ID}"); } else { if (isset($_POST["delete"])) { $prof->check($_POST['id'], 'd'); if ($prof->delete($_POST)) { $prof->redirectToList(); } else { Html::back(); } } else { if (isset($_POST["update"]) || isset($_POST["interface"])) { $prof->check($_POST['id'], 'w'); $prof->update($_POST); Html::back(); } } } Html::header(Profile::getTypeName(2), $_SERVER['PHP_SELF'], "admin", "profile"); $prof->showForm($_GET["id"]); Html::footer();
// Original Author of file: Julien Dombre // Purpose of file: // ---------------------------------------------------------------------- define('GLPI_ROOT', '..'); include GLPI_ROOT . "/inc/includes.php"; checkRight("profile", "r"); if (!isset($_GET['id'])) { $_GET['id'] = ""; } $prof = new Profile(); if (isset($_POST["add"])) { $prof->check(-1, 'w', $_POST); $ID = $prof->add($_POST); // We need to redirect to form to enter rights glpi_header($CFG_GLPI["root_doc"] . "/front/profile.form.php?id={$ID}"); } else { if (isset($_POST["delete"])) { $prof->check($_POST['id'], 'w'); $prof->delete($_POST); $prof->redirectToList(); } else { if (isset($_POST["update"]) || isset($_POST["interface"])) { $prof->check($_POST['id'], 'w'); $prof->update($_POST); glpi_header($_SERVER['HTTP_REFERER']); } } } commonHeader($LANG['Menu'][35], $_SERVER['PHP_SELF'], "admin", "profile"); $prof->showForm($_GET["id"]); commonFooter();