Se los dejo por si lo llegan a usar:
Código
<?php //--------------------------------------------------------------+ // Include module settings | //--------------------------------------------------------------+ require_once("settings.php"); //--------------------------------------------------------------+ // Case Up | //--------------------------------------------------------------+ if($var['order']=="up"){ //--------------------------------------------------------------+ // First get the pre Number ID slot | //--------------------------------------------------------------+ $DBQuery->attrib['query'] = "SELECT slot FROM `banner` WHERE `id_banner` ='".$var['idpreslot']."'"; //echo $DBQuery->attrib['query']; $getPreSlot = $DBQuery->RunQuery(); //--------------------------------------------------------------+ // Update the pre item with last number ID slot | //--------------------------------------------------------------+ $DBQuery->attrib['query'] = "UPDATE `banner` SET `slot` = '".$var['slot']."' WHERE `id_banner` ='".$var['idpreslot']."'"; //echo $DBQuery->attrib['query']; $upPreSlot=$DBQuery->RunQuery(); //--------------------------------------------------------------+ // As finaly, update the item with pre number ID slot | //--------------------------------------------------------------+ $DBQuery->attrib['query'] = "UPDATE `banner` SET `slot` = '".$getPreSlot[0]['slot']."' WHERE `id_banner` ='".$var['id_banner']."'"; //echo $DBQuery->attrib['query']; $upSlot=$DBQuery->RunQuery(); } //--------------------------------------------------------------+ // Case Down | //--------------------------------------------------------------+ if($var['order']=="down"){ //--------------------------------------------------------------+ // First get the next Number ID slot and ID_banner | //--------------------------------------------------------------+ $DBQuery->attrib['query'] = "SELECT id_banner, slot FROM `banner` WHERE `slot` ='".$var['idnextslot']."'"; //echo $DBQuery->attrib['query']."<br>"; $getNextSlot = $DBQuery->RunQuery(); //--------------------------------------------------------------+ // Update the original entry with the new id_slot | //--------------------------------------------------------------+ $DBQuery->attrib['query'] = "UPDATE `banner` SET `slot` = '".$var['idnextslot']."' WHERE `id_banner` ='".$var['id_banner']."'"; //echo $DBQuery->attrib['query']."<br>"; $downSlot=$DBQuery->RunQuery(); //--------------------------------------------------------------+ // Update the entry target with the old slot | //--------------------------------------------------------------+ $DBQuery->attrib['query'] = "UPDATE `banner` SET `slot` = '".$var['slot']."' WHERE `id_banner` ='".$getNextSlot[0]['id_banner']."'"; //echo $DBQuery->attrib['query']."<br>"; $downSlot=$DBQuery->RunQuery(); } Location("index.php?action=".$lo_mod_name.".banshort"); ?>
Igual y no le entienden porque es parte de un FM que estoy haciendo pero bueno, cualquier consejo es bienvenido