%@ $Language=JScript /* PARA COLORES PHP */ %><%
include("../includes/DB_Conectar.php");
include("../includes/inc_auth.php");
include("../includes/funciones.php");
if(isset($borratodo)){
foreach($_POST as $key => $value ) {
//echo "$key:$value
"; if(substr($key,0,4)=='chk_') { $sql = "select * from SinglePage A, MenuSite B where A.menID=B.menID and spID = '$value'";
$rs = $conn->execute($sql);
$menID = $rs->field(menID);
$sql="select * from MenuSite where menID='$menID'";
$rsmen=$conn->execute($sql);
//reordeno menu
$sql="update MenuSite set menOrden=menOrden-1
where menPosicion='".$rsmen->field("menPosicion")."' and
menOrden>".$rsmen->field("menOrden");
$update=$conn->execute($sql);
//borro menu y single page
$sqdele = "delete from MenuSite where menID = '$menID'";
$qrdele = $conn->execute($sqdele);
$sqdele = "delete from SinglePage where spID = '$value'";
$qrdele = $conn->execute($sqdele);
}
}
}
%>