public function executePromote() {
$page_id = $this->getRequestParameter('page_id');
 
$connection = Propel::getConnection();
$promoting_RS = $connection->query("SELECT order_num, parent_id FROM static_pages WHERE page_id='{$page_id}'");
$promoting = $promoting_RS->fetch(PDO::FETCH_ASSOC);
$promoting_num = $promoting['order_num'];
$promoting_parent = $promoting['parent_id'];
 
if ($promoting_num < 2) {
  $this->redirect('static_pages/index');
}
$demoting_num_RS = $connection->query("SELECT MAX(order_num) AS order_num, page_id FROM static_pages WHERE parent_id='{$promoting_parent}' AND order_num < '{$promoting_num}' GROUP BY NULL");
$demoting = $demoting_num_RS->fetch(PDO::FETCH_ASSOC);
$demoting_num = $demoting['order_num'];
 
$query = "UPDATE static_pages SET order_num = CASE
   WHEN page_id = '".$page_id."' THEN '".$demoting_num."'
   WHEN parent_id='{$promoting_parent}' AND order_num='{$demoting_num}' THEN '".$promoting_num."'
   END
   WHERE page_id = ".$page_id." OR (parent_id={$promoting_parent} AND order_num={$demoting_num})";
 
$connection->query($query);
$this->redirect('static_pages/index');
return sfView::NONE;
}