/**
* Add a new Id to the set.
* @param object Id $id The Id to add.
* @access public
* @return void
*/
function addItem($id)
{
parent::addItem($id);
$position = $this->getPosition($id);
// Add the item to the database
$query = new InsertQuery();
$query->setTable("sets");
$columns = array("id", "item_id", "item_order");
$values = array("'" . addslashes($this->_setId->getIdString()) . "'", "'" . addslashes($id->getIdString()) . "'", "'" . $position . "'");
$query->setColumns($columns);
$query->setValues($values);
$dbHandler = Services::getService("DatabaseManager");
$dbHandler->query($query, $this->_dbIndex);
}
}
$showorder = "story";
/******************************************************************************
* Reordering of sections
******************************************************************************/
} else {
if ($_REQUEST['reorderSection']) {
$site_id = db_get_value("slot", "FK_site", "slot_name='" . addslashes($_REQUEST['site']) . "'");
$orderedSet = new OrderedSet(null);
$query = "\n\t\tSELECT\n\t\t\tsection_id, section_order\n\t\tFROM\n\t\t\tsection\n\t\tWHERE\n\t\t\tFK_site = '" . addslashes($site_id) . "'\n\t\tORDER BY section_order\t\t\t\n\t";
printpre($query);
$r = db_query($query);
// Populate the Set with the original page order
while ($a = db_fetch_assoc($r)) {
printpre($a['section_order'] . "-" . $a['section_id']);
$orderedSet->addItem($a['section_id']);
}
// Move our page to its new position
$orderedSet->moveToPosition($_REQUEST['reorderSection'], $_REQUEST['newPosition']);
// Save the new order
$orderedSet->reset();
// Make sure the iterator is at the begining.
$order = 0;
while ($orderedSet->hasNext()) {
$item = $orderedSet->next();
printpre($order . "-" . $item);
// Update the db
$query = "\n\t\t\tUPDATE\n\t\t\t\tsection\n\t\t\tSET\n\t\t\t\tsection_order = '" . addslashes($order) . "'\n\t\t\tWHERE\n\t\t\t\tsection_id = '" . addslashes($item) . "'\n\t\t";
//printpre($query);
$r = db_query($query);
$order++;
