prefix . "ai_album"; $ai_show_table_photos = $wpdb->prefix . "ai_photos"; if($_REQUEST['action'] == 'Delete') { $ai_album_get_image=$wpdb->get_results("SELECT album_cover_image from $ai_show_table_album WHERE album_id = '".$_REQUEST['id']."'",ARRAY_A); if(file_exists(AI_GALLERY_DIR_PATH.'/'.$ai_album_get_image[0]['album_cover_image'])){ @unlink(AI_GALLERY_DIR_PATH.'/'.$ai_album_get_image[0]['album_cover_image']); } $ai_album_thumb_name= explode('.',$ai_album_get_image[0]['album_cover_image']); $ai_thumb_album_name=$ai_album_thumb_name[0].'-thumb'.'.'.$ai_album_thumb_name[1]; if(file_exists(AI_GALLERY_THUMB_DIR_PATH.'/'.$ai_thumb_album_name)){ @unlink(AI_GALLERY_THUMB_DIR_PATH.'/'. $ai_thumb_album_name); } $ai_photo_get_image=$wpdb->get_results("SELECT photo_filename from $ai_show_table_photos WHERE photo_album_id = '".$_REQUEST['id']."'",ARRAY_A); foreach($ai_photo_get_image as $photo_key => $photo_val) { if(file_exists(AI_PHOTO_DIR_PATH.'/'.$photo_val['photo_filename'])){ @unlink(AI_PHOTO_DIR_PATH.'/'.$photo_val['photo_filename']); } $ai_photo_thumb_name= explode('.',$photo_val['photo_filename']); $ai_thumb_photo_name=$ai_photo_thumb_name[0].'-thumb'.'.'.$ai_photo_thumb_name[1]; if(file_exists(AI_PHOTO_THUMB_DIR_PATH.'/'.$ai_thumb_photo_name)){ @unlink(AI_PHOTO_THUMB_DIR_PATH.'/'. $ai_thumb_photo_name); } } $wpdb->query($wpdb->prepare("DELETE FROM $ai_show_table_album WHERE album_id =%d",$_REQUEST['id'])); $wpdb->query($wpdb->prepare("DELETE FROM $ai_show_table_photos WHERE photo_album_id =%d",$_REQUEST['id'])); $location=admin_url().'admin.php?page=ai_gallery&album_delete_success=1'; echo' '; } if($_REQUEST['action'] == 'Disable') { $wpdb->query($wpdb->prepare("UPDATE $ai_show_table_album SET album_visible=0 WHERE album_id =%d",$_REQUEST['id'])); $location=admin_url().'admin.php?page=ai_gallery&album_disable_success=1'; echo' '; } if($_REQUEST['action'] == 'Enable') { $wpdb->query($wpdb->prepare("UPDATE $ai_show_table_album SET album_visible=1 WHERE album_id =%d",$_REQUEST['id'])); $location= admin_url().'admin.php?page=ai_gallery&album_enable_success=1'; echo' '; } if($_REQUEST['Action'] == 'EnableDisableSelected') { $edittable=$_POST['selector']; $params = join(',', $edittable); $wpdb->query($wpdb->prepare("UPDATE $ai_show_table_album SET album_visible='".$_POST['visible']."' WHERE album_id IN ($params)",ARRAY_N)); if($_POST['visible'] == '1') { $location= admin_url().'admin.php?page=ai_gallery&album_enable_success=1'; echo' '; } if($_POST['visible'] == '0') { $location= admin_url().'admin.php?page=ai_gallery&album_disable_success=1'; echo' '; } } if ($_REQUEST['Action'] == 'DeleteSelected') { $edittable=$_POST['selector']; $params = join(',', $edittable); //unlink album image from uploaded path $ai_album_get_image=$wpdb->get_results("SELECT album_cover_image from $ai_show_table_album WHERE album_id IN ($params)",ARRAY_A); foreach($ai_album_get_image as $album_key => $album_val) { if(file_exists(AI_GALLERY_DIR_PATH.'/'.$album_val['album_cover_image'])){ @unlink(AI_GALLERY_DIR_PATH.'/'.$album_val['album_cover_image']); } $ai_album_thumb_name= explode('.',$album_val['album_cover_image']); $ai_thumb_album_name=$ai_album_thumb_name[0].'-thumb'.'.'.$ai_album_thumb_name[1]; if(file_exists(AI_GALLERY_THUMB_DIR_PATH.'/'.$ai_thumb_album_name)){ @unlink(AI_GALLERY_THUMB_DIR_PATH.'/'. $ai_thumb_album_name); } } //unlink photo image from uploaded path $ai_photo_get_image=$wpdb->get_results("SELECT photo_filename from $ai_show_table_photos WHERE photo_album_id IN ($params)",ARRAY_A); foreach($ai_photo_get_image as $photo_key => $photo_val) { if(file_exists(AI_PHOTO_DIR_PATH.'/'.$photo_val['photo_filename'])){ @unlink(AI_PHOTO_DIR_PATH.'/'.$photo_val['photo_filename']); } $ai_photo_thumb_name= explode('.',$photo_val['photo_filename']); $ai_thumb_photo_name=$ai_photo_thumb_name[0].'-thumb'.'.'.$ai_photo_thumb_name[1]; if(file_exists(AI_PHOTO_THUMB_DIR_PATH.'/'.$ai_thumb_photo_name)){ @unlink(AI_PHOTO_THUMB_DIR_PATH.'/'. $ai_thumb_photo_name); } } // use the IN operator in your WHERE-clause $wpdb->query($wpdb->prepare("DELETE FROM $ai_show_table_album WHERE album_id IN ($params)",ARRAY_N)); $wpdb->query($wpdb->prepare("DELETE FROM $ai_show_table_photos WHERE photo_album_id IN ($params)",ARRAY_N)); $location=admin_url().'admin.php?page=ai_gallery&album_delete_success=1'; echo' '; } $ai_get_album_res=$wpdb->get_results("select * from $ai_show_table_album ORDER BY album_order ASC "); ?>

+ Add New Album


Album Inserted Successfully.
"; } if(isset($_GET['album_update_success']) && $_GET['album_update_success']==1) { echo "
Selected Album Update Successfully.
"; } if(isset($_GET['album_delete_success']) && $_GET['album_delete_success']==1) { echo "
Selected Album Delete Successfully.
"; } if(isset($_GET['album_disable_success']) && $_GET['album_disable_success']==1) { echo "
Selected Album Disable Successfully.
"; } if(isset($_GET['album_enable_success']) && $_GET['album_enable_success']==1) { echo "
Selected Album Enable Successfully.
"; } ?>
prefix . "ai_photos"; if(count($ai_get_album_res) > 0) { foreach($ai_get_album_res as $key => $val) { $ai_album_micro_images=$wpdb->get_results("select photo_filename from $ai_show_table_photo WHERE photo_album_id='".$val->album_id."'",ARRAY_A); if(!empty($val->album_cover_image)) { $file_thumb=AI_GALLERY_THUMB_URL_PATH.'/'; $album_name= explode('.',$val->album_cover_image); $thumb_album_name=$album_name[0].'-thumb'.'.'.$album_name[1]; } else { $file_thumb = AI_URL_PATH.'/images/'; $thumb_album_name= 'no_photo.jpg'; } $color='style="background-color:#CCCCCC;"'; $ai_getcount_album_images=$wpdb->get_results("select count(*) as albumcount,photo_filename from $ai_show_table_photo WHERE photo_album_id='".$val->album_id."'",ARRAY_A); ?> album_visible == 0){echo $color;}?> id="recordsArray_album_id ;?>" class="ui-state-default">
+ Add New Album
   Album Title Album Cover Image Album Date Album Micro Images Album ShortCode Total Images Action
album_id; ?>> album_title; ?> No Image album_date; ?>
$mval) { foreach($mval as $mick => $micv) { if(!empty($micv)) { $ai_file_thumb=AI_PHOTO_THUMB_URL_PATH.'/'; $ai_photo_name= explode('.',$micv); $ai_thumb_photo_name=$ai_photo_name[0].'-thumb'.'.'.$ai_photo_name[1]; } ?> No Image
Photos Edit Delete album_visible == 1) { ?> Disable Enable
   Album Title Album Cover Image Album Date Album Micro Images Album ShortCode Total Images Action
Check All / Uncheck All