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;