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'];
$albId = $_REQUEST['albIdIs'];
$sortingId = $_REQUEST['sortingValue'];
if($_REQUEST['status'] == 'ON')
{
$photoImg = $wpdb->query("UPDATE " . $wpdb->prefix . "asgallphotos SET asgallPhoto_status='ON' , asgallPhoto_sorting = asgallPhoto_sorting + 1 WHERE asgallPhoto_id='$asgallPhoto_id'");
$sql = "UPDATE " . $wpdb->prefix . "asgallphotos SET asgallPhoto_sorting = asgallPhoto_sorting + 1
WHERE asgallPhoto_sorting > $sortingId AND asgallPhoto_id != $asgallPhoto_id AND is_delete = 0";
$wpdb->query($sql);
//echo "";
}
else // if u click on status off then it exe
{
$photoImg = $wpdb->query("UPDATE " . $wpdb->prefix . "asgallphotos SET asgallPhoto_status='OFF' WHERE asgallPhoto_id='$asgallPhoto_id'");
$sql = "UPDATE " . $wpdb->prefix . "asgallphotos SET asgallPhoto_sorting = asgallPhoto_sorting - 1
WHERE asgallPhoto_sorting >= $sortingId AND is_delete = 0";
$wpdb->query($sql);
// $wpdb->query("UPDATE " . $wpdb->prefix . "picaphotos SET macPhoto_sorting = macPhoto_sorting - 1 WHERE macPhoto_sorting IS NOT NULL AND `macAlbum_id` = 1 AND `macPhoto_id` >$macPhoto_id AND is_delete = 0");
//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);
unlink($path . $asgallPhoto_id . '.' .$extense[1]);
$deletePhoto = $wpdb->get_results("DELETE FROM " . $wpdb->prefix . "asgallphotos WHERE asgallPhoto_id='$asgallPhoto_id'");
echo '';
}
// 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'");
// $wpdb->query("UPDATE " . $wpdb->prefix . "asgallphotos SET asgallFeaturedCover = $albumCover 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 = addslashes($_REQUEST['macPhoto_name']);
$sql = $wpdb->get_results("UPDATE " . $wpdb->prefix . "asgallphotos SET `asgallPhoto_name` = '$macPhoto_name' WHERE `asgallPhoto_id` = $asgallPhoto_id");
// echo "UPDATE " . $wpdb->prefix . "asgallphotos SET `macPhoto_name` = '$macPhoto_name' WHERE `asgallPhoto_id` = $asgallPhoto_id";
// exit;
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 = addslashes($_REQUEST['macGallery_name']) ;
$macGallery_id = $_REQUEST ['macGallery_id'];
//echo "UPDATE " . $wpdb->prefix . "macgallery SET `macGallery_name` = '" .$macGal_name. "' WHERE `macGallery_id` = ".$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 = addslashes($_REQUEST['macGallery_name']) ;
$macGallery_id = $_REQUEST['macGallery_id'];
$sql = $wpdb->query("UPDATE " . $wpdb->prefix . "asgallgallery SET `macGallery_name` = '$macGal_name' WHERE `macGallery_id` = '$macGallery_id'");
//echo "UPDATE " . $wpdb->prefix . "macgallery 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 = $_GET['asgallAlbum_name'];
$asgallAlbum_desc = $_GET['asgallAlbum_desc'];
$sql = $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'];
$sql = $wpdb->query("UPDATE " . $wpdb->prefix . "asgallalbum SET `asgallAlbum_description` = '$asgallAlbum_desc' WHERE `asgallAlbum_id` = '$asgallAlbum_id'");
echo $asgallAlbum_desc;
}
?>