class Category
{
	// Code chua run, code bang notepad de tam tham khao
	var $Info;
	function Parse()
	{
		$QueryStr	= "SELECT * FROM " . CATEGORY_TABLE . " WHERE 1 ORDER BY position DESC";
		$Result		= @mysql_query ($QueryStr) 
		// or return ErrorHandler("MySQL", mysql_error());
		//if (!$Result) return ErrorHandler($Context,$ErrMsg); 
		while ($Row	= @mysql_fetch_assoc($Result))
			$Cat[]	= $Row;
		$this->sortCat($Cat, 0, 1);
		return 1;
	}
	function sortCat($CatArr, $Node, $Level)
	{
		for ($i=0, $i< Count($CatArr); $i++)
		if ($CatArr[$i][parent] == $Node)
			{
				$CatArr[level]	= $Level;
				$this->Info[]	= $CatArr[$i];
				this->sortCat($CatArr, $CatArr[$i][id], $Level+1);
			}
		return 1;
	}
	
	// Ham nay anh tach ra tu bo core cua thang coder ben anh
	// Chi de tham khao vi no lien quan den pattern cua he thong nua
	function moveUp($CatID)
	{
		$QueryStr = "SELECT c1.id, c1.position,c1.parent,c2.id,c2.position,c2.parent 
						FROM " .TBL_CATEGORIES."c1,".TBL_CATEGORIES." c2 
							WHERE c1.position < c2.position 
							  AND c2.id = $CatID 
		          			  AND c1.parent = c2.parent 
										ORDER BY c1.position DESC";
							
		if ($result = MySQL::Query($QueryStr))
		{
			if (@mysql_num_rows($result)!=0)
			{
				$row 	= @mysql_fetch_row($result);
				$cat1 	= array("position"	=>$row[4]);
				$cat2 	= array("position"  =>$row[1]);
			
				return (Category::Update($cat1,"id=$row[0]"))
						&&(Category::Update($cat2,"id=$row[3]"));
			}
		}  
	}
	
}