/**
* Delete a record
* @param integer $id ID of record to be deleted
* @return void Record is deleted from database
*/
static function Delete($id)
{
App::LoadClass('Privacy');
App::LoadClass('Avatar');
App::LoadClass('Video');
App::LoadClass('Subscription');
App::LoadClass('Rating');
App::LoadClass('Flag');
App::LoadClass('Favorite');
App::LoadClass('Comment');
App::LoadClass('Post');
App::LoadClass('Message');
$db = Database::GetInstance();
$user = new self($id);
Plugin::Trigger('user.delete');
// Delete Avatar
if (!empty($user->avatar)) {
Avatar::Delete($user->avatar);
}
// Delete Privacy Record
$privacy_id = Privacy::Exist(array('user_id' => $id));
Privacy::Delete($privacy_id);
// Delete Comments
$query = "SELECT comment_id FROM " . DB_PREFIX . "comments WHERE user_id = {$id}";
$result = $db->Query($query);
while ($row = $db->FetchObj($result)) {
Comment::Delete($row->comment_id);
}
// Delete Ratings
$query = "SELECT rating_id FROM " . DB_PREFIX . "ratings WHERE user_id = {$id}";
$result = $db->Query($query);
while ($row = $db->FetchObj($result)) {
Rating::Delete($row->rating_id);
}
// Delete Favorites
$query = "SELECT fav_id FROM " . DB_PREFIX . "favorites WHERE user_id = {$id}";
$result = $db->Query($query);
while ($row = $db->FetchObj($result)) {
Favorite::Delete($row->fav_id);
}
// Delete Flags
$query = "SELECT flag_id FROM " . DB_PREFIX . "flags WHERE id = {$id} AND type = 'user'";
$result = $db->Query($query);
while ($row = $db->FetchObj($result)) {
Flag::Delete($row->flag_id);
}
// Delete Subscriptions
$query = "SELECT sub_id FROM " . DB_PREFIX . "subscriptions WHERE user_id = {$id} OR member = {$id}";
$result = $db->Query($query);
while ($row = $db->FetchObj($result)) {
Subscription::Delete($row->sub_id);
}
// Delete Posts
$query = "SELECT post_id FROM " . DB_PREFIX . "posts WHERE user_id = {$id}";
$result = $db->Query($query);
while ($row = $db->FetchObj($result)) {
Post::Delete($row->post_id);
}
// Delete Messages
$query = "SELECT message_id FROM " . DB_PREFIX . "messages WHERE user_id = {$id} OR recipient = {$id}";
$result = $db->Query($query);
while ($row = $db->FetchObj($result)) {
Message::Delete($row->message_id);
}
// Delete Videos
$query = "SELECT video_id FROM " . DB_PREFIX . "videos WHERE user_id = {$id}";
$result = $db->Query($query);
while ($row = $db->FetchObj($result)) {
Video::Delete($row->video_id);
}
// Delete Privacy
$query = "SELECT privacy_id FROM " . DB_PREFIX . "privacy WHERE user_id = {$id}";
$result = $db->Query($query);
while ($row = $db->FetchObj($result)) {
Privacy::Delete($row->privacy_id);
}
// Delete User
$query = "DELETE FROM " . DB_PREFIX . self::$table . " WHERE " . self::$id_name . " = {$id}";
$db->Query($query);
}
$Video->setSet($Set);
} else {
header('location:index.php');
exit;
}
}
if (array_key_exists('hidAction', $_POST) && $_POST['hidAction'] == 'VideoView') {
$Video->setFileName(Utils::NullIfEmpty($_POST['txtFilename']));
$Video->setFileExtension(Utils::NullIfEmpty($_POST['txtFileExtension']));
$Video->setFileSize(intval($_POST['txtFilesize']));
$Video->setFileCheckSum(Utils::NullIfEmpty($_POST['txtFileChecksum']));
$Video->setFileCRC32(Utils::NullIfEmpty($_POST['txtFileCRC32']));
$tags = Tag::GetTagArray($_POST['txtTags']);
if ($Video->getID()) {
if ($DeleteVideo) {
if (Video::Delete($Video, $CurrentUser)) {
header('location:' . $ReturnURL);
exit;
}
} else {
if (Video::Update($Video, $CurrentUser)) {
Tag2All::HandleTags($tags, $TagsThisVideo, $TagsInDB, $CurrentUser, $ModelID, $SetID, NULL, $Video->getID(), NULL);
header('location:' . $ReturnURL);
exit;
}
}
} else {
if (Video::Insert($Video, $CurrentUser)) {
Tag2All::HandleTags($tags, $TagsThisVideo, $TagsInDB, $CurrentUser, $ModelID, $SetID, NULL, $Video->getID());
header('location:' . $ReturnURL);
exit;
// Establish page variables, objects, arrays, etc
View::InitView('myvideos');
Plugin::Trigger('myvideos.start');
Functions::RedirectIf(View::$vars->logged_in = User::LoginCheck(), HOST . '/login/');
View::$vars->user = new User(View::$vars->logged_in);
$records_per_page = 9;
$url = HOST . '/myaccount/myvideos';
View::$vars->message = null;
/***********************
Handle Form if submitted
***********************/
if (isset($_GET['vid']) && is_numeric($_GET['vid'])) {
$data = array('user_id' => View::$vars->user->user_id, 'video_id' => $_GET['vid']);
$video_id = Video::Exist($data);
if ($video_id) {
Video::Delete($video_id);
View::$vars->message = Language::GetText('success_video_deleted');
View::$vars->message_type = 'success';
Plugin::Trigger('myvideos.delete_video');
}
}
// Retrieve total count
$query = "SELECT video_id FROM " . DB_PREFIX . "videos WHERE user_id = " . View::$vars->user->user_id . " AND status = 'approved'";
$result_count = $db->Query($query);
$total = $db->Count($result_count);
// Initialize pagination
View::$vars->pagination = new Pagination($url, $total, $records_per_page);
$start_record = View::$vars->pagination->GetStartRecord();
// Retrieve limited results
$query .= " LIMIT {$start_record}, {$records_per_page}";
View::$vars->result = $db->Query($query);
$url = ADMIN . '/videos.php';
$query_string = array();
$categories = array();
$message = null;
$sub_header = null;
// Retrieve Category names
$query = "SELECT cat_id, cat_name FROM " . DB_PREFIX . "categories";
$result = $db->Query($query);
while ($row = $db->FetchObj($result)) {
$categories[$row->cat_id] = $row->cat_name;
}
### Handle "Delete" video if requested
if (!empty($_GET['delete']) && is_numeric($_GET['delete'])) {
// Validate video id
if (Video::Exist(array('video_id' => $_GET['delete']))) {
Video::Delete($_GET['delete']);
$message = 'Video has been deleted';
$message_type = 'success';
}
} else {
if (!empty($_GET['feature']) && is_numeric($_GET['feature'])) {
// Validate video id
if (Video::Exist(array('video_id' => $_GET['feature'], 'featured' => 0))) {
$video = new Video($_GET['feature']);
$video->Update(array('featured' => 1));
$message = 'Video has been featured';
$message_type = 'success';
}
} else {
if (!empty($_GET['unfeature']) && is_numeric($_GET['unfeature'])) {
// Validate video id
// page vars
$page_title = "";
$id = $_REQUEST['id'];
// id required
if ($id == "") {
header("Location:mainpage.php");
exit;
}
// if form was submitted
if ($_POST['commit'] == "Cancel") {
header("Location:video_list.php");
exit;
}
if ($_POST['commit'] == "Delete Video") {
$objVideo = new Video();
$objVideo->Delete($id);
header("Location:video_list.php");
exit;
}
$objVideo = new Video($id);
include "includes/pagetemplate.php";
function PageContent()
{
global $objVideo;
global $id;
?>
<div class="layout laymidwidth">
<?php
$aLabels = array();
