function moveLink($lid, $direction) { global $db, $cfg; if (!isset($lid) && !isset($direction) && $direction !== "up" && $direction !== "down") { header("location: admin.php?op=editLinks"); } $idx = getLinkSortOrder($lid); $position = array("up" => -1, "down" => 1); $new_idx = $idx + $position[$direction]; $sql = "UPDATE tf_links SET sort_order={$idx} WHERE sort_order={$new_idx}"; $db->Execute($sql); showError($db, $sql); $sql = "UPDATE tf_links SET sort_order={$new_idx} WHERE lid={$lid}"; $db->Execute($sql); showError($db, $sql); header("Location: admin.php?op=editLinks"); }
function deleteOldLink($lid) { global $db; // Get Current sort order index of link with this link id: $idx = getLinkSortOrder($lid); // Fetch all link ids and their sort orders where the sort order is greater // than the one we're removing - we need to shuffle each sort order down // one: $sql = "SELECT sort_order, lid FROM tf_links "; $sql .= "WHERE sort_order > {$idx} ORDER BY sort_order ASC"; $result = $db->Execute($sql); showError($db, $sql); $arLinks = $result->GetAssoc(); // Decrement the sort order of each link: foreach ($arLinks as $sid => $this_lid) { $sql = "UPDATE tf_links SET sort_order=sort_order-1 WHERE lid={$this_lid}"; $db->Execute($sql); showError($db, $sql); } // Finally delete the link: $sql = "DELETE FROM tf_links WHERE lid=" . $lid; $result = $db->Execute($sql); showError($db, $sql); }
/** * Delete Link * * @param $lid */ function deleteOldLink($lid) { global $db; // Link Mod //$sql = "delete from tf_links where lid=".$lid; // Get Current sort order index of link with this link id: $idx = getLinkSortOrder($lid); // Fetch all link ids and their sort orders where the sort order is greater // than the one we're removing - we need to shuffle each sort order down // one: $sql = "SELECT sort_order, lid FROM tf_links "; $sql .= "WHERE sort_order > " . $db->qstr($idx) . " ORDER BY sort_order ASC"; $result = $db->Execute($sql); if ($db->ErrorNo() != 0) { dbError($sql); } $arLinks = $result->GetAssoc(); // Decrement the sort order of each link: foreach ($arLinks as $sid => $this_lid) { $sql = "UPDATE tf_links SET sort_order=sort_order-1 WHERE lid=" . $db->qstr($this_lid); $db->Execute($sql); if ($db->ErrorNo() != 0) { dbError($sql); } } // Finally delete the link: $sql = "DELETE FROM tf_links WHERE lid=" . $db->qstr($lid); $result = $db->Execute($sql); if ($db->ErrorNo() != 0) { dbError($sql); } // flush session-cache cacheFlush(); }