Hi Saptadeep Bhowmik,
Please open \wp-content\plugins\contus-video-gallery\admin\models\video.php and find public function get_videodata($searchValue,$searchBtn,$order,$orderDirection) and replace with the following code.
function get_current_user_role() {
global $current_user;
get_currentuserinfo();
$user_roles = $current_user->roles;
$user_role = array_shift($user_roles);
return $user_role;
}
public function get_videodata($searchValue,$searchBtn,$order,$orderDirection)
{//function for getting search videos starts
$where='';
$user_role = $this->get_current_user_role();
$current_user = wp_get_current_user();
if($user_role!='administrator'){
$where .= " WHERE a.member_id=".$current_user->ID;
}
$pagenum = isset( $_GET['pagenum'] ) ? absint( $_GET['pagenum'] ) : 1;
$limit = 20;
$offset = ( $pagenum - 1 ) * $limit;
if(isset($searchBtn))
{
if(empty($where)){
$where .= " WHERE";
} else {
$where .= " AND";
}
$where .= " (a.name LIKE '%" . $searchValue . "%' || a.description LIKE '%" . $searchValue . "%')";
}
if(!isset($orderDirection))
{
$orderDirection = 'DESC';
}
$query = "SELECT DISTINCT (a.vid),a.*,u.display_name FROM ".$this->_videotable .' a
LEFT JOIN '. $this->_wpdb->prefix .'users u
ON u.ID=a.member_id
LEFT JOIN '. $this->_wpdb->prefix .'hdflvvideoshare_med2play p
ON p.media_id=a.vid
LEFT JOIN '. $this->_wpdb->prefix .'hdflvvideoshare_playlist pl
ON pl.pid=p.playlist_id
'.$where ."
ORDER BY ". $order . ' '.$orderDirection."
LIMIT $offset, $limit";
return $this->_wpdb->get_results($query);
}//function for getting search videos ends
Now find public function video_edit($videoId) { and replace with the following function.
public function video_edit($videoId) {
global $current_user, $wpdb;
if (isset($videoId) && !current_user_can('manage_options')) {
$user_id = $current_user->ID;
$video_count = $wpdb->get_var("SELECT count(*) FROM $this->_videotable WHERE vid = $videoId and member_id = $user_id");
if ($video_count == 0) {
wp_die( __( 'You do not have permission to access this page.' ) );
}
}
//function for getting single video starts
return $this->_wpdb->get_row("SELECT a.*,b.tags_name FROM " . $this->_videotable . " as a LEFT JOIN " . $this->_wpdb->prefix . "hdflvvideoshare_tags b ON b.media_id=a.vid WHERE a.vid ='$videoId'");
}
If you are still facing the same issue feel free to contact us.
