/**
* This function is used to create a new playlist
* in add video page without refreshing the page
*
* @param string $name
* @param string $media
*/
public function hd_ajax_add_playlist($name, $media)
{
global $wpdb;
/** Get name from param */
$p_name = addslashes(trim($name));
/** sanitize name and get slug name */
$p_slugname = sanitize_title($name);
$p_description = '';
/** Query to get last palylist order from playlist table */
$playlist_order = getAllPlaylistCount();
/** Query to get playlist name from playlist table if the given name is exist */
$playlistname1 = 'SELECT playlist_name FROM ' . $wpdb->prefix . 'hdflvvideoshare_playlist WHERE playlist_name="' . $p_name . '"';
$planame1 = $wpdb->get_row($playlistname1);
/** Check the playlist name is already exist */
if (count($planame1) > 0) {
/** Display error message category already exist */
render_error(__('Failed, category name already exist', APPTHA_VGALLERY)) . $this->get_playlist_for_dbx($media);
return;
}
/** If new playlist name is exist, then create new data */
if (!empty($p_name)) {
/** Set palylsit details as array */
$videoData = array('playlist_name' => $p_name, 'playlist_desc' => $p_description, 'is_publish' => 1, 'playlist_order' => $playlist_order, 'playlist_slugname' => $p_slugname);
/** Insert the new data array into playlist table */
$insert_plist = $wpdb->insert($wpdb->prefix . 'hdflvvideoshare_playlist', $videoData);
/** Check data is insert into database */
if ($insert_plist != 0) {
/** Display success message */
$this->render_message(__('Category', APPTHA_VGALLERY) . ' ' . $name . ' ' . __('added successfully', APPTHA_VGALLERY)) . $this->get_playlist_for_dbx($media);
}
}
/** Return to new videos page */
return;
}
/**
* Function for add/ update playlist data.
*/
public function add_playlist()
{
global $wpdb;
/** Check if sttus is exists */
if (isset($this->_status)) {
/** Call function to update stauts */
$this->status_update($this->_playListId, $this->_status);
}
/** Check whether to add new playlist */
if (isset($this->_addnewPlaylist)) {
/** Get playlistname parameters from request URL */
$playlistName = filter_input(INPUT_POST, 'playlistname');
/** Sanitize playlist title */
$playlist_slugname = sanitize_title($playlistName);
/** Get ispublish parameters from request URL */
$playlistPublish = filter_input(INPUT_POST, 'ispublish');
/** Check given playlist name is exist in playlist table */
$playlist_slug = $this->_wpdb->get_var('SELECT COUNT(playlist_slugname) FROM ' . $wpdb->prefix . 'hdflvvideoshare_playlist WHERE playlist_slugname LIKE "' . $playlist_slugname . '%"');
/** Check playlist slug is already exist */
if ($playlist_slug > 0) {
/** If exist then increase count with slug name */
$playlist_slugname = $playlist_slugname . '-' . intval($playlist_slug + 1);
}
/** Store all parameters into single array */
$playlsitData = array('playlist_name' => $playlistName, 'playlist_slugname' => $playlist_slugname, 'is_publish' => $playlistPublish);
/**
* Check whether playlist id is exist
* If exist, then update records in db,
* else insert new record
*/
if ($this->_playListId) {
$updateflag = $this->playlist_update($playlsitData, $this->_playListId);
/** Redirect to playlist page after updating record */
$this->redirectPlaylistPage($updateflag, 'update', '');
} else {
/** Ordering starts from 0,
* so count of playlist is order + 1 value */
$ordering = getAllPlaylistCount();
$playlsitData['playlist_order'] = $ordering;
/** Insert new playlist into db */
$addflag = $this->insert_playlist($playlsitData);
/** Redirect to playlist page once action is done */
$this->redirectPlaylistPage($addflag, 'add', '');
}
}
}
