0){ //already exists $message['type'] = "error"; $message['text'] = " Group ".$groupText." already exists"; }else{ $sql=" INSERT INTO dw_group ( groupText, groupOrder, groupModUser , groupSite , groupModDate, groupActive) VALUES ( ? , ? , ? , ? , now() , 1 ) "; if(!savesql($link, $sql, "siii", array($groupText, $groupOrder, $_SESSION['userID'], $_SESSION['userSite'] ), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); } }else{ if(isset($_POST['edit_id']) && $_POST['edit_id']!='' && $_POST['edit_id']!=null){ $edit_id = clean($_POST['edit_id']); $groupTextx = explode(' [',clean($_POST['edit_group'])); $edit_group = $groupTextx[0]; //the first part (minus the id) $edit_order = clean($_POST['edit_order']); $edit_order_old = clean($_POST['edit_order_old']); if(isset($_POST['edit_active'])) $edit_active = clean($_POST['edit_active']); else $edit_active = 0; $edit_reason = clean($_POST['edit_reason']); if($edit_order_old!= $edit_order){ $sql=" # update all the group orders +1 Select dw_group.groupID, dw_group.groupOrder From dw_group Where dw_group.groupText = ? And dw_group.groupOrder > ? And dw_group.groupOrder <= ? And dw_group.groupSite = ? "; if(!$qrygroups = mysqli_prepared_query($link, $sql, "iiii", array($edit_group, $edit_order_old, $edit_order, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); foreach($qrygroups as $group_row){ $sql=" UPDATE dw_group SET groupOrder = ? WHERE groupID = ? "; if(!savesql($link, $sql, "ii", array(($group_row['groupOrder']+1), $group_row['groupID']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); } } $sql=" # update this group UPDATE dw_group SET groupText = ?, groupOrder = ?, groupActive = ?, groupChangeCode = ?, groupModDate = now(), groupModUser = ? WHERE groupID = ? "; if(!savesql($link, $sql, "siisii", array($edit_group, $edit_order, $edit_active, $edit_reason, $_SESSION['userID'], $edit_id), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); } } $title = "Group"; require "inc/head.php"; $menu="group"; require "inc/menu.php"; if($debug) showdebug(); ?>

99 Order By dw_group.groupOrder DESC, dw_group.groupText DESC Limit 1 "; if(!$order_query = mysqli_prepared_query($link, $sql, "i", array($_SESSION['userSite']), FILE, LINE)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], FILE, LINE); if(mysqli_prepared_num_rows($order_query)>0){ $order_row = $order_query[0]; }else{ $order_row=array('groupID'=>1); } ?>

Please wait while loading...