| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/hkosl.com/litedemo/webadmin/ |
Upload File : |
<?php
include 'config.php';
// Check if the user is logged in
if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1'))
{
header("Location: login.php");
exit;
}
require("configure.php");
$bannerid = $_GET["bannerid"];
$result = mysql_query("SELECT * FROM banner WHERE bannerid=". $_GET["bannerid"] ." ");
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$menuid = $row{'menuid'};
$footpageid = $row{'footpageid'};
$bannersort = $_GET["bannersort"];
// Delete db
$sql = "DELETE FROM banner WHERE bannerid=". $bannerid ." ";
mysql_query($sql);
if( mysql_errno() > 0 ){
echo 'Delete Banner Error:<br />'. mysql_error() .'<br />SQL: '. $sql;
exit;
}
if( (!empty($menuid )) && (empty($footpageid)) ){
mysql_query("UPDATE banner SET bannersort = bannersort-1 WHERE bannersort >= $bannersort AND menuid = $menuid ");
} else if( (empty($menuid )) && (!empty($footpageid)) ){
mysql_query("UPDATE banner SET bannersort = bannersort-1 WHERE bannersort >= $bannersort AND footpageid = $footpageid ");
}
mysql_close($dbh);
header("Location: banner_index.php?menuid=".$menuid."&footpageid=".$footpageid."&msg=Delete Successful");
?>