";
}
else
{
$photo_img = $wpdb->query("UPDATE " . $wpdb->prefix . "bannerimages SET bann_imgstatus='0' WHERE bann_imgid='$bannpht_id'");
echo "
";
}
}
/****************************************** QUICK EDIT FORM FOR THE IMAGE NAME AND DESCRIPTION ******************************************/
else if($_GET['bann_editid'] != '')
{
$bann_editid = $_GET['bann_editid'];
$fet_res = $wpdb->get_row("SELECT * FROM " . $wpdb->prefix . "bannerimages WHERE bann_imgid='$bann_editid'");
$div = '' ;
echo $div;
}
/****************************************** QUICK EDIT UPDATION FOR THE IMAGE NAME AND DESCRIPTION ******************************************/
else if($_REQUEST['bann_fieldid'] != '' )
{
$bann_fieldid = $_GET['bann_fieldid'];
$bannImg_name = $_GET['bannImg_name'];
$bannImg_desc = $_GET['bannImg_desc'];
$bannImg_url = $_GET['bannImg_url'];
$sql = $wpdb->get_results("UPDATE " . $wpdb->prefix . "bannerimages SET `bann_imgname`='$bannImg_name',`bann_imgdesc` ='$bannImg_desc',
`bann_imgurl`='$bannImg_url' WHERE `bann_imgid` = '$bann_fieldid'");
}
/****************************************** PUBLISHING THE BANNER ******************************************/
else if($_GET['publish'] != '')
{
$publish = $_GET['publish'];
$tmp_id = $_GET['tmp_id'];
$banner_url = $_GET['banner_url'];
if($publish == 'ON')
{
$album_cover = $wpdb->query("UPDATE " . $wpdb->prefix . "bannerstyles SET bann_status=(CASE WHEN bann_tempid='$tmp_id' THEN 'ON' WHEN bann_tempid!='$tmp_id' THEN 'OFF' END)");
$get_pageid = $wpdb->get_row("SELECT bann_tempimg,bann_tempname,bann_tempid FROM " . $wpdb->prefix . "bannerstyles WHERE bann_status= 'ON'");
echo '
++'.'Style Settings';
}
}
else if(isset($_REQUEST['temp_id']))
{
$tempid = $_REQUEST['temp_id'];
$album_remove = $wpdb->query("DELETE FROM " . $wpdb->prefix . "bannerstyles WHERE bann_tempid='$tempid'");
}
else {
$bann_imgid= $_REQUEST['bann_imgid'];
foreach ($_GET['listItem'] as $position => $item) :
// Sort order updated in the table
$sql[] =$wpdb->query("UPDATE " . $wpdb->prefix . "bannerimages SET `bann_imgsort` = '$position' WHERE `bann_imgid` = $item");
endforeach;
}
?>