<?php
	session_start();
	if (!isset($_SESSION['User'])){
		header("Location: login.php");
	}
	$user = trim($_SESSION['User']);
	require 'config.php';
	require 'itemInfo.php';
	require_once '../classes/Auction.php';
	$auctionId = mysql_real_escape_string(stripslashes($_GET['id']));
	$auction = new Auction($auctionId);
	$queryEnchantLinks = mysql_query("SELECT * FROM WA_EnchantLinks WHERE itemId = '$auction->id' AND itemTableId = '1'");
		//return mysql_num_rows($queryEnchantLinks);
	$itemEnchantsArray = array ();
		
	while(list($idt, $enchIdt, $itemTableIdt, $itemIdt)= mysql_fetch_row($queryEnchantLinks))
	{  
		$itemEnchantsArray[] = $enchIdt;
			
	}
	if (strcasecmp($auction->owner,$user) == 0){
		$queryPlayerItems =mysql_query("SELECT * FROM WA_Items WHERE player='$user'");
		$foundItem = false;
		$stackId = 0;
		$stackQuant = 0;
		while(list($pid, $pitemName, $pitemDamage, $pitemOwner, $pitemQuantity)= mysql_fetch_row($queryPlayerItems))
		{	
			if($auction->name == $pitemName)
			{
				if ($auction->damage == $pitemDamage)
				{
					$queryEnchantLinksMarket = mysql_query("SELECT * FROM WA_EnchantLinks WHERE itemTableId = '0' AND itemId = '$pid'");
					$marketEnchantsArray = array ();
					while(list($idt, $enchIdt, $itemTableIdt, $itemIdt)= mysql_fetch_row($queryEnchantLinksMarket))
					{  
						$marketEnchantsArray[] = $enchIdt;
					}	
					if((array_diff($itemEnchantsArray, $marketEnchantsArray) == null)&&(array_diff($marketEnchantsArray, $itemEnchantsArray) == null))
					{
						$foundItem = true;
						$stackId = $pid;
						$stackQuant = $pitemQuantity;
					}
				}
			}
		}
		if ($foundItem == true)
		{
			$newQuantity = $auction->quantity + $stackQuant;
			$itemQuery = mysql_query("UPDATE WA_Items SET quantity='$newQuantity' WHERE id='$stackId'");
		}else
		{
			$itemQuery = mysql_query("INSERT INTO WA_Items (name, damage, player, quantity) VALUES ('$auction->name', '$auction->damage', '$auction->owner', '$auction->quantity')");
			$queryLatestAuction = mysql_query("SELECT id FROM WA_Items ORDER BY id DESC");
			list($latestId)= mysql_fetch_row($queryLatestAuction);
					
			$queryEnchants=mysql_query("SELECT * FROM WA_EnchantLinks WHERE itemId='$auctionId' AND itemTableId ='1'"); 
			while(list($idk,$enchIdk, $tableIdk, $itemIdk)= mysql_fetch_row($queryEnchants))
			{ 
				$updateEnch = mysql_query("INSERT INTO WA_EnchantLinks (enchId, itemTableId, itemId) VALUES ('$enchIdk', '0', '$latestId')");
			}
					
		}
		$auction->delete();
		$_SESSION['success'] = 'Removed auction successfully';
		header("Location: ../myauctions.php");
	}else{
		$_SESSION['error'] = 'Error removing that auction.';
		header("Location: ../myauctions.php");
	}
?>