The web video script that I’m using, it has been modified(improved) so that purchases are made via a new ‘paid-list’ php file, essentially by-passing the script’s original pay system(‘paid-videos’).
The web script has a Users’ Purchases page, which remains blank, because the new ‘paid-list’ isn’t integrated to it.
I’m attempting to modify the new ‘paid-list’ php file so that purchases appear on the script’s original Users’ Purchases page. But, have yet to accomplish it.
the Paid-List file(below) generates/loads purchased videos to appear on the ‘Paid-List’ html page (currently works successfully).
The Paid-Videos file(below)(no longer used with the script) generated/loaded videos that were purchased onto the paid-videos ‘Purchases’ html page.
I’m trying to get the videos displayed on the ‘Paid-List’ html page to also appear on the Paid-Videos ‘Purchases’ html page.
Paid-List php file:
<?php
if (IS_LOGGED == false) {
header("Location: " . PT_Link('login'));
exit();
}
$user_id = $user->id;
$pt->is_admin = PT_IsAdmin();
$pt->is_settings_admin = false;
$list = '<div class="text-center no-content-found empty_state"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-video-off"><path d="M16 16v1a2 2 0 0 1-2 2H3a2 2 0 0 1-2-2V7a2 2 0 0 1 2-2h2m5.66 0H14a2 2 0 0 1 2 2v3.34l1 1L23 7v10"></path><line x1="1" y1="1" x2="23" y2="23"></line></svg>' . $lang->no_videos_found_for_now . '</div>';
$list2 = '<div class="text-center no-content-found empty_state"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-video-off"><path d="M16 16v1a2 2 0 0 1-2 2H3a2 2 0 0 1-2-2V7a2 2 0 0 1 2-2h2m5.66 0H14a2 2 0 0 1 2 2v3.34l1 1L23 7v10"></path><line x1="1" y1="1" x2="23" y2="23"></line></svg></div>';
$final = '';
$get_videos = $db->rawQuery("SELECT DISTINCT(v.id), v.* FROM u_paid_videos AS upv LEFT JOIN " . T_VIDEOS . " AS v ON (upv.id_video = v.id) WHERE upv.id_user = {$user->id} AND upv.session_key = '{$_SESSION['session_key']}' ORDER BY upv.id DESC");
if (!empty($get_videos)) {
$len = count($get_videos);
foreach ($get_videos as $key => $video) {
$video = PT_GetVideoByID($video, 0, 0, 0);
$pt->last_video = false;
if ($key == $len - 1) {
$pt->last_video = true;
}
$final .= PT_LoadPage('paid-list/list', array(
'ID' => $video->id,
'USER_DATA' => $video->owner,
'THUMBNAIL' => $video->thumbnail,
'URL' => $video->url,
'TITLE' => $video->title,
'DESC' => $video->markup_description,
'VIEWS' => $video->views,
'VIEWS_NUM' => number_format($video->views),
'TIME' => $video->time_ago,
'DURATION' => $video->duration
));
}
}
if (empty($final)) {
$final = $list;
}
$pt->videos = $get_videos;
$pt->page = 'paid-list';
$pt->title = $lang->search . ' | ' . $pt->config->title;
$pt->description = $pt->config->description;
$pt->keyword = $pt->config->keyword;
$pt->content = PT_LoadPage('paid-list/content', array(
'VIDEOS' => $final,
'KEYWORD' => $keyword
));
Paid-Videos php file:
<?php
if (IS_LOGGED == false || $pt->config->sell_videos_system == 'off' ) {
header("Location: " . PT_Link('login'));
exit();
}
$list = '<div class="text-center no-content-found empty_state"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-video-off"><path d="M16 16v1a2 2 0 0 1-2 2H3a2 2 0 0 1-2-2V7a2 2 0 0 1 2-2h2m5.66 0H14a2 2 0 0 1 2 2v3.34l1 1L23 7v10"></path><line x1="1" y1="1" x2="23" y2="23"></line></svg>' . $lang->no_videos_found_paid . '</div>';
$final = '';
$type = 'videos';
if (!empty($_GET['type']) && $_GET['type'] == 'movies' && $pt->config->movies_videos == 'on') {
$get = $db->rawQuery('SELECT * FROM '.T_VIDEOS_TRSNS.' t WHERE `paid_id` = '.$user->id.' AND (SELECT id FROM '.T_VIDEOS.' WHERE id = t.video_id AND `is_movie` = 1) = video_id ORDER BY id DESC LIMIT 20');
$type = 'movies';
}
else{
$get = $db->rawQuery('SELECT * FROM '.T_VIDEOS_TRSNS.' t WHERE `paid_id` = '.$user->id.' AND (SELECT id FROM '.T_VIDEOS.' WHERE id = t.video_id AND `is_movie` != 1) = video_id ORDER BY id DESC LIMIT 20');
//$get = $db->where('paid_id', $user->id)->orderby('id', 'DESC')->get(T_VIDEOS_TRSNS, 20);
}
$get_paid_videos = array();
if (!empty($get)) {
foreach ($get as $key => $video_) {
$fetched_video = $db->where('id', $video_->video_id)->getOne(T_VIDEOS);
if (!empty($fetched_video)) {
$fetched_video->tr_id = $video_->id;
$get_paid_videos[] = $fetched_video;
}
}
}
if (!empty($get_paid_videos)) {
$len = count($get_paid_videos);
foreach ($get_paid_videos as $key => $video) {
$video = PT_GetVideoByID($video, 0, 0, 0);
$pt->last_video = false;
if ($key == $len - 1) {
$pt->last_video = true;
}
$final .= PT_LoadPage('paid-videos/list', array(
'ID' => $video->tr_id,
'USER_DATA' => $video->owner,
'THUMBNAIL' => $video->thumbnail,
'URL' => $video->url,
'TITLE' => $video->title,
'DESC' => $video->markup_description,
'VIEWS' => $video->views,
'TIME' => $video->time_ago,
'VIDEO_ID_' => PT_Slug($video->title, $video->video_id)
));
}
}
if (empty($final)) {
$final = $list;
}
$pt->page_url_ = $pt->config->site_url.'/paid-videos?type='.$type;
$pt->videos = $get_paid_videos;
$pt->page = 'paid-videos';
$pt->title = $lang->paid_videos . ' | ' . $pt->config->title;
$pt->description = $pt->config->description;
$pt->keyword = $pt->config->keyword;
$pt->content = PT_LoadPage('paid-videos/content', array(
'PAID_LIST' => $final
));
any help is much appreciated