get_results("SELECT * FROM " . $wpdb->prefix . "bannerimages ORDER BY bann_imgid DESC LIMIT 0,$queue"); $p = 1; foreach($res as $results) { $phtsrc[$p]['bann_img'] = $results->bann_img; $phtsrc[$p]['bann_imgid'] = $results->bann_imgid; $phtsrc[$p]['bann_imgname'] = $results->bann_imgname; $phtsrc[$p]['bann_imgdesc'] = $results->bann_imgdesc; $phtsrc[$p]['bann_imgurl'] = $results->bann_imgurl; $p++; } $banner_styles .= "
Following are the list of images that has been uploaded
"; $banner_styles .=''; for($i=1;$i<=$queue;$i++) { $banner_styles .= "
"; $banner_styles .='
'; $banner_styles .=''; $banner_styles .='
'; $banner_styles .='

'.$phtsrc[$i]['bann_imgname'].'

'; $banner_styles .='
'; } echo $banner_styles ; } /****************************************** UPDATE THE BANNER IMAGE NAME AND DESCRIPTION ******************************************/ else if($_REQUEST['bannedit_phtid'] != '') { $bannedit_name = $_REQUEST['bannedit_name']; $bannedit_desc = $_REQUEST['bannedit_desc']; $bannedit_id = $_REQUEST['bannedit_phtid']; $bannedit_url = $_REQUEST['bannedit_url']; $sql = $wpdb->get_results("UPDATE " . $wpdb->prefix . "bannerimages SET `bann_imgname` = '$bannedit_name', `bann_imgdesc` = '$bannedit_desc' , `bann_imgurl` = '$bannedit_url' WHERE `bann_imgid` = '$bannedit_id'"); } /****************************************** ENABLE AND DISABLE THE STATUS OF THE IMAGE ******************************************/ else if($_REQUEST['bannpht_id'] != '') { $bannpht_id = $_REQUEST['bannpht_id']; if($_REQUEST['status'] == '1') { $photo_img = $wpdb->query("UPDATE " . $wpdb->prefix . "bannerimages SET bann_imgstatus='1' WHERE bann_imgid='$bannpht_id'"); echo ""; } 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 = '
'; $div .= '
'; $div .= '
'; $div .= ' '; $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') { $get_pageid = $wpdb->get_var("SELECT bann_tempid FROM " . $wpdb->prefix . "bannerstyles WHERE bann_status= '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)"); echo " ++$get_pageid++"; } else { echo " ++$tmp_id++"; } } ?>