query("UPDATE " . $wpdb->prefix . "asgallalbum SET asgallAlbum_status='ON' WHERE asgallAlbum_id='$mac_albId'");
echo "
";
}
else
{
$alumImg = $wpdb->query("UPDATE " . $wpdb->prefix . "asgallalbum SET asgallAlbum_status='OFF' WHERE asgallAlbum_id='$mac_albId'");
echo "
";
}
}
// Photos status change respect to album
else if($_REQUEST['asgallPhoto_id'] != '')
{
$asgallPhoto_id = $_REQUEST['asgallPhoto_id'];
$mac_photoStat = $_REQUEST['status'];
if($_REQUEST['status'] == 'ON')
{
$photoImg = $wpdb->query("UPDATE " . $wpdb->prefix . "asgallphotos SET asgallPhoto_status='ON' WHERE asgallPhoto_id='$asgallPhoto_id'");
echo "";
}
else
{
$photoImg = $wpdb->query("UPDATE " . $wpdb->prefix . "asgallphotos SET asgallPhoto_status='OFF' WHERE asgallPhoto_id='$asgallPhoto_id'");
echo "";
}
}
else if($_REQUEST['macDelid'] != '')
{
$asgallPhoto_id = $_REQUEST['macDelid'];
$photoImg = $wpdb->get_var("SELECT asgallPhoto_image FROM " . $wpdb->prefix . "asgallphotos WHERE asgallPhoto_id='$asgallPhoto_id' ");
$uploadDir = wp_upload_dir();
$path = $uploadDir['baseurl'];
$path = "$path/";
unlink($path . $photoImg);
$extense = explode('.', $photoImg);
if(is_int($asgallPhoto_id)){
unlink($path . $asgallPhoto_id . '.' .$extense[1]);
$wpdb->get_results("DELETE FROM " . $wpdb->prefix . "asgallphotos WHERE asgallPhoto_id='$asgallPhoto_id'");
}
}
// For photo edit form
else if($_REQUEST['macPhotoname_id'] != '')
{
$asgallPhoto_id = $_REQUEST['macPhotoname_id'];
$div = ' | ';
$div .= ' | ' ;
echo $div;
}
// Add as album cover from the photos
else if ($_REQUEST['macCovered_id'] != '')
{
$macPhotoid = $_REQUEST['macCovered_id'];
$albumCover = $_REQUEST['albumCover'];
$albumId = $_REQUEST['albumId'];
$flag = $_REQUEST['featuredCover'];
//print_r($_REQUEST);
if(isset($flag)){ // FOR FEATURED IMAGE
$wpdb->query("UPDATE " . $wpdb->prefix . "asgallphotos SET asgallFeaturedCover = $flag WHERE asgallPhoto_id='$macPhotoid' and asgallAlbum_id='$albumId'");
echo "";
}
if($albumCover == 'ON')
{
$albumCover = $wpdb->query("UPDATE " . $wpdb->prefix . "asgallphotos SET asgallAlbum_cover='ON' WHERE asgallPhoto_id='$macPhotoid' and asgallAlbum_id='$albumId'");
$albumCoveroff = $wpdb->query("UPDATE " . $wpdb->prefix . "asgallphotos SET asgallAlbum_cover='OFF' WHERE asgallPhoto_id !='$macPhotoid' and asgallAlbum_id='$albumId'");
$photoImg = $wpdb->get_var("SELECT asgallPhoto_image FROM " . $wpdb->prefix . "asgallphotos WHERE asgallPhoto_id='$macPhotoid' ");
$addtoAlbum = $wpdb->query("UPDATE " . $wpdb->prefix . "asgallalbum SET asgallAlbum_image='$photoImg' WHERE asgallAlbum_id='$albumId'");
echo "";
}
}
// update photo name
else if($_REQUEST['macPhoto_name'] != '')
{
$asgallPhoto_id = $_REQUEST['macPhotos_id'];
$macPhoto_name = strip_tags($_REQUEST['macPhoto_name']);
$macPhoto_name = preg_replace("/[^a-zA-Z0-9\/_-\s]/", '', $macPhoto_name);
if(is_int((int)$asgallPhoto_id)){
$sql = $wpdb->get_results("UPDATE " . $wpdb->prefix . "asgallphotos SET `asgallPhoto_name` = '$macPhoto_name' WHERE `asgallPhoto_id` = $asgallPhoto_id");
echo $macPhoto_name;
}
}
//Album name edit form
else if($_REQUEST['asgallAlbumname_id'] != '')
{
$asgallAlbum_id = $_REQUEST['asgallAlbumname_id'];
$fet_res = $wpdb->get_row("SELECT * FROM " . $wpdb->prefix . "asgallalbum WHERE asgallAlbum_id='$asgallAlbum_id'");
$div = '' ;
echo $div;
}
else if($_REQUEST['macGallery_id'] != '')
{
$macGallery_id = $_REQUEST['macGallery_id'];
$fet_res = $wpdb->get_row("SELECT * FROM " . $wpdb->prefix . "asgallgallery WHERE macGallery_id='$_id'");
$div = '' ;
echo $div;
$macGal_name = strip_tags($_REQUEST['macGallery_name']) ;
$macGal_name = preg_replace("/[^a-zA-Z0-9\/_-\s]/", '', $macGal_name);
$macGallery_id = $_REQUEST ['macGallery_id'];
if(is_int($macGallery_id)){
$sql = $wpdb->query("UPDATE " . $wpdb->prefix . "asgallgallery SET `macGallery_name` = '" .$macGal_name. "' WHERE `macGallery_id` = ".$macGallery_id);
echo $macGal_name;
}
}
// Album description update
else if($_REQUEST['macGallery_id'] != '')
{
$macGal_name = strip_tags($_REQUEST['macGallery_name']) ;
$macGal_name = preg_replace("/[^a-zA-Z0-9\/_-\s]/", '', $macGal_name);
$macGallery_id = $_REQUEST['macGallery_id'];
if(is_int($macGallery_id)){
$sql = $wpdb->query("UPDATE " . $wpdb->prefix . "asgallgallery SET `macGallery_name` = '$macGal_name' WHERE `macGallery_id` = '$macGallery_id'");
echo $macGal_name;
}
}
else if($_REQUEST['asgallAlbum_id'] != '' )
{
$asgallAlbum_id = $_GET['asgallAlbum_id'];
$asgallAlbum_name = strip_tags($_GET['asgallAlbum_name']);
$asgallAlbum_desc = strip_tags($_GET['asgallAlbum_desc']);
$asgallAlbum_name = preg_replace("/[^a-zA-Z0-9\/_-\s]/", '', $asgallAlbum_name);
if(is_int($asgallAlbum_id)){
$wpdb->get_results("UPDATE " . $wpdb->prefix . "asgallalbum SET `asgallAlbum_name`='$asgallAlbum_name',`asgallAlbum_description` ='$asgallAlbum_desc'
WHERE `asgallAlbum_id` = '$asgallAlbum_id'");
}
}
// Album description update
else
{
$asgallAlbum_desc = addslashes($_REQUEST['asgallAlbum_desc']) ;
$asgallAlbum_id = $_REQUEST['asgallAlbum_id'];
if(is_int($asgallAlbum_id)){
$sql = $wpdb->query("UPDATE " . $wpdb->prefix . "asgallalbum SET `asgallAlbum_description` = '$asgallAlbum_desc' WHERE `asgallAlbum_id` = '$asgallAlbum_id'");
echo $asgallAlbum_desc;
}
}
?>