prefix.'video_gallery'; $v_id = $_REQUEST['videoid']; $nonce = $_REQUEST['nonce']; if( current_user_can('editor') || current_user_can('administrator') || current_user_can('author')){ if( ! wp_verify_nonce( $nonce, 'my-nonce' )){ echo '

You are not allowed to edit Videos

'; die(); }else{ $q_result = $wpdb->prepare( "UPDATE `$tablename` SET `video_title` = %s, `video_url` = %s WHERE `id` = %d", array( sanitize_text_field($_REQUEST['AQVG_video_title']), esc_url_raw($_REQUEST['AQVG_video_url']), $v_id)); $wpdb->query($q_result); if($q_result == false){ echo '

There was a problem editing your video

'; }else{ echo '

Video Update Successfully

'; } $wpdb->flush(); } }else{ echo '

You dont have right or permission to edit video

'; die(); } } if(isset($_REQUEST['videoid'])){ if(is_numeric($_REQUEST['videoid'])){ global $wpdb; $tablename = $wpdb->prefix.'video_gallery'; $v_id = $_REQUEST['videoid']; $results = $wpdb->get_results( "SELECT * FROM $tablename WHERE id = $v_id"); foreach ($results as $result) { $video_title = $result->video_title; $video_url = $result->video_url; } ?>

Edit Video

window.location.replace("'.get_site_url().'/wp-admin/admin.php?page=AQVG");'; echo "no"; }}else{ echo ''; echo "no"; } ?>