public function delete_event()
{
$this->is_admin_or_team_lead();
if (isset($_POST['event_id'])) {
$this->load->model('event_model', 'event');
$event = $this->event->get_with_client_details($this->input->post('event_id'))[0];
if ($event) {
$events = $this->event->get_by_project_id($event->project_id);
$duplicate_count = 0;
$rank = 0;
foreach ($events as $e) {
if ($e->id === $event->id) {
$rank = $duplicate_count + 1;
} else {
if ($e->event_type === $event->event_type) {
$duplicate_count++;
}
}
}
$this->event->delete($this->input->post('event_id'));
$dbxClient = new \Dropbox\Client(getenv('DROPBOX_ACCESS_TOKEN'), "chaar-bhai/1.0");
if ($dbxClient->getMetadata('/' . $event->client_username . '/' . $event->project_name) !== null) {
if ($duplicate_count === 0) {
if (!empty($event->event_status)) {
$dbxClient->delete('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type);
}
if (!empty($event->photoshoot_status)) {
$dbxClient->delete('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' Photoshoot');
}
} elseif ($duplicate_count === 1) {
if (!empty($event->event_status)) {
$dbxClient->delete('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' ' . $rank);
}
if (!empty($event->photoshoot_status)) {
$dbxClient->delete('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' ' . $rank . ' Photoshoot');
}
if ($rank === 1) {
if ($dbxClient->getMetadata('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' 2') !== null) {
$dbxClient->move('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' 2', '/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type);
}
if ($dbxClient->getMetadata('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' 2 Photoshoot') !== null) {
$dbxClient->move('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' 2 Photoshoot', '/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' Photoshoot');
}
} else {
if ($dbxClient->getMetadata('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' 1') !== null) {
$dbxClient->move('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' 1', '/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type);
}
if ($dbxClient->getMetadata('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' 1 Photoshoot') !== null) {
$dbxClient->move('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' 1 Photoshoot', '/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' Photoshoot');
}
}
} else {
if (!empty($event->event_status)) {
$dbxClient->delete('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' ' . $rank);
}
if (!empty($event->photoshoot_status)) {
$dbxClient->delete('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' ' . $rank . ' Photoshoot');
}
if ($rank !== $duplicate_count + 1) {
for ($i = $rank; $i < $duplicate_count + 1; $i++) {
if ($dbxClient->getMetadata('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' ' . ($i + 1)) !== null) {
$dbxClient->move('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' ' . ($i + 1), '/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' ' . $i);
}
if ($dbxClient->getMetadata('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' ' . ($i + 1) . ' Photoshoot') !== null) {
$dbxClient->move('/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' ' . ($i + 1) . ' Photoshoot', '/' . $event->client_username . '/' . $event->project_name . '/' . $event->event_type . ' ' . $i . ' Photoshoot');
}
}
}
}
}
$this->response(array('success' => 'Event deleted'), 200);
} else {
$this->response(array('error' => 'Event could not be deleted'), 200);
}
} else {
$this->response(array('error' => 'Bad request'), 400);
}
}
/**
* Delete file on Dropbox
*
* @since 1.0
* @uses \Dropbox\Client
* @see https://www.dropbox.com/developers/core/docs#fileops-delete
* @see http://dropbox.github.io/dropbox-sdk-php/api-docs/v1.1.x/source-class-Dropbox.Client.html#1274-1303
* @param string $filepath
* @return boolean
*/
public function remove($filepath)
{
$client = new Dropbox\Client($this->getToken(), $this->applicationName);
try {
$client->delete($filepath);
return true;
} catch (Exception $ex) {
$this->pushError($ex->getMessage());
return false;
}
}
<?php
$userId = $_POST["idUser"];
$connect = mysql_connect("localhost", "root", "123");
mysql_select_db("POKS");
$query_relult_email = mysql_query("select * from User where userId={$userId}") or die("Не удалось провести запрос к базе данных -- select clearUser.php");
ini_set('display_errors', 1);
# Include the Dropbox SDK libraries
require_once './dropbox-sdk-php-1.1.5/lib/Dropbox/autoload.php';
//MODX_BASE_PATH.
//use \Dropbox as dbx;
$accessToken = "-QAlimGqvKAAAAAAAAAAjRWBUFnqWI0AuJV06CSJtnvDKFYMpujYYU2h4fN7-Hlv";
// Здесь ваш Access token
$dbxClient = new \Dropbox\Client($accessToken, "ITMO_POKS_FOLDER");
$data = mysql_fetch_array($query_relult_email);
print "In: " . $data[0];
$dbxClient->delete("/" . $data[1]);
$dbxClient->createFolder("/" . $data[1]);
$query_relult = mysql_query("delete from userStorrage where idUser={$userId}") or die("Не удалось провести запрос к базе данных -- deleteclearUser.php");
mysql_close($connect);
header("Location: AdminPlace.php?name=" . $_POST["idName"]);
exit;
<?php
session_start();
$mail = $_SESSION["user"];
$id_image = $_GET["image_id"];
$name_image = $_GET["image_name"];
echo "<br>";
print "mail:" . $mail;
echo "<br>";
print "id:" . $id_image;
echo "<br>";
print "name:" . $name_image;
$connect = mysql_connect("localhost", "root", "123");
mysql_select_db("POKS");
$query_relult_email = mysql_query("select * from User where email='{$mail}'") or die("Не удалось провести запрос к базе данных -- select removeImage.php");
$user = mysql_fetch_array($query_relult_email);
$id_user = $user[0];
$query_relult = mysql_query("delete from userStorrage where idPicture='{$id_image}'") or die("Не удалось провести запрос к базе данных -- removeImage.php");
ini_set('display_errors', 1);
require_once './dropbox-sdk-php-1.1.5/lib/Dropbox/autoload.php';
$accessToken = "-QAlimGqvKAAAAAAAAAAjRWBUFnqWI0AuJV06CSJtnvDKFYMpujYYU2h4fN7-Hlv";
// Здесь ваш Access token
$dbxClient = new \Dropbox\Client($accessToken, "ITMO_POKS_FOLDER");
$dbxClient->delete("/" . $mail . "/" . $name_image);
mysql_close($connect);
header("Location: UserPlace.php");
exit;
