Viên ngọc phương Đông

ruạṛ

<?php 
/**
 * process testimonial ordering
 * @version 0.10
 * @author Robert Urquhart <programmer@activatedesign.co.nz>
 * @package WEP-CMS
 * @since braziers.co.nz
 */
require_once $_SERVER['DOCUMENT_ROOT'].'/admin/scripts-includes/universal.php';
session_start();
$conn_ID = connect_to_db();
//print_r($_POST);
if(!is_array($_POST['positions']))
{
	die('Invalid positions array');
	exit;
}

$message = '';
$positions = array();
$all = mysql_query("select * from testimonials order by position");
while($a = mysql_fetch_assoc($all))
{
	$positions[$a['testimonial_id']] = $a['position'];
}

$sorted = assign_positions($positions); //recursive function

//*
foreach($sorted as $pid => $pos){
	$id = ltrim($pid,'p');
	mysql_query("update testimonials set position = '$pos' where testimonial_id = '$id'");
}
//*/

$message .= "Positions updated.";	
getout($message);
exit;

function assign_positions($positions = array())
{
	global $message;
	$sort = array();

foreach($positions as $id => $curPos)
	{
		if(isset($_POST['positions']["$id"]))
		{
			// validate submitted position
			$pos = is_numeric_id($_POST['positions']["$id"],0);
			if(!$pos)
			{
				$pos = $curPos;
			}
		} //end isset
		else
		{
			$pos = $curPos;
		}
		
		$sort["p$id"] = $pos;//+$i; //prefix with p because array_merge refuses to acknowledge strings consisting of solely numeric characters no matter how firmly defined.
		
	} //end foreach
	//echo 'unsorted ';print_r($sort); //debugging
	$sorted = order_for_db($sort); //just this branch/tier
	//echo 'sorted '; print_r($sort); //debugging
	return $sorted;
}
?>