<?php
$rank_check = 1;
$page_title = "Combine";
include "header.inc.php";

echo "<script type=\"text/javascript\">alert(\"loaded\");</script>";

$ajax = $_GET['ajax'];
if ($ajax == 0) {
print "$openHTML";
}

if (isset($_POST["combine"])) {
    extract($_POST);
        $getitem1 = mysql_query("SELECT * FROM usersitems2 WHERE id='$item1' AND combine='1'");
        $invitem1 = mysql_fetch_array($getitem1);
        if ($invitem1[amount] > 1)
{
        mysql_query("UPDATE usersitems2 SET amount=$invitem1[amount]-1 id='$item1' AND combine='1'");
}
        $getitemname1 = mysql_query("SELECT * FROM items2 WHERE id='".$invitem1['item_id']."'");
        $iname1 = mysql_fetch_array($getitemname1);

        $getitem2 = mysql_query("SELECT * FROM usersitems2 WHERE id='$item2' AND combine='1'");
        $invitem2 = mysql_fetch_array($getitem2);
                if ($invitem2[amount] > 1)
{
        mysql_query("UPDATE usersitems2 SET amount=$invitem2[amount]-1 WHERE id='$item2' AND combine='1'");
}
        $getitemname2 = mysql_query("SELECT * FROM items2 WHERE id='".$invitem2['item_id']."'");
        $iname2 = mysql_fetch_array($getitemname2);
        $getitem3 = mysql_query("SELECT * FROM usersitems2 WHERE id='$item3' AND combine='1'");
        $invitem3 = mysql_fetch_array($getitem3);
                        if ($invitem3[amount] > 1)
{
        mysql_query("UPDATE usersitems2 SET amount=$invitem3[amount]-1 WHERE id='$item3' AND combine='1'");
}
        $getitemname3 = mysql_query("SELECT * FROM items2 WHERE id='".$invitem3['item_id']."'");
        $iname3 = mysql_fetch_array($getitemname3);

$findmake = mysql_query("SELECT * FROM builditem WHERE itemid1='$iname1[item_name]' AND itemid2='$iname2[item_name]' AND itemid3='$iname3[item_name]'");
$make = mysql_fetch_array($findmake);
$itembase = mysql_query("SELECT * FROM items2 WHERE item_name='$make[make]'");
$grabitem = mysql_fetch_array($itembase);
 if (mysql_num_rows($findmake) == 0) {echo "<p class='infobox' align=center><Center><font size='3'>Oh No!</font><BR>You tried to make a combination, but it dosn't exist.</center></p>$closeHTML";}
 if (mysql_num_rows($findmake) != 0) {echo "<p class='infobox' align=center><center><b>Hooray!</b><BR>Success! you made a<BR><img src='images/items/$make[make].png'><BR> <strong>$make[make]</strong>! <BR> <i>It has been added to <a href='myitems.php'>your items!</a></i></center></p>$closeHTML";
 $newexp = $getInfo[cookingexp] + $make[expgiven];
 mysql_query("UPDATE members2 SET cookingexp = '$newexp' WHERE id = '$userid'");
 if ($newexp == $cxp){
 systemmessage("1", "combine.php?game=1", "$userid", "You have gained a level in cooking! You have unlocked new recipies!");
 }
 mysql_query("INSERT INTO usersitems2 (owner,item_id,parts_left,game) VALUES ('$userid','$grabitem[id]','$grabitem[parts]','1')");}
        if ($invitem1[amount] <= 1)
{
 mysql_query("DELETE FROM usersitems2 WHERE id='$item1' AND owner='$userid'");
}
        if ($invitem2[amount] <= 1)
{
mysql_query("DELETE FROM usersitems2 WHERE id='$item2' AND owner='$userid'");
}
        if ($invitem3[amount] <= 1)
{
mysql_query("DELETE FROM usersitems2 WHERE id='$item3' AND owner='$userid'");
}
 die();
}



$getitems = mysql_query("SELECT * FROM usersitems2 WHERE combine=1 AND owner='$userid'");

while($inv= mysql_fetch_array($getitems)){
    $getiteminfo = mysql_query("SELECT * FROM items2 WHERE id='$inv[item_id]'");
    $itm = mysql_fetch_array($getiteminfo);
$list .= "


<img src='images/items/".$itm['item_name'].".png' width=\"80\" height=\"80\">

";
}
 if (mysql_num_rows($getitems) == 0) {$list2 = "No combinable items.";}
$widthhp = ceil(($getInfo[cookingexp] / $cxp ) * 100);
echo "<div><b>$cookinglevel</b> $getInfo[cookingexp]/ $cxp <BR>
 <div style='width:200px;height:19px;background-image: url(\"images/cookexpgrey.gif\");'><div style='width:".$widthhp."%;height:19px;background-image: url(\"images/cookexp.gif\");'></div></div></div>";
echo "<BR><P class=infobox> Here you can combine items for cooking. To make items combinable you must first select them from your items and choose \"Add to Combine Basket\".</p>



";
echo "<B>Your Combine Basket:</b><BR> $list $list2";


    echo "<form action=\"combine.php\" method=\"post\" name=\"post\">";

$getcombos = mysql_query("SELECT * FROM usersitems2 WHERE combine='1' AND owner='$userid'");
while($combos=mysql_fetch_array($getcombos)){
        $itemsquery = mysql_query("SELECT * FROM items2 WHERE id='".$combos['item_id']."'");
        $itemsrow = mysql_fetch_array($itemsquery);
$itemlist .= "<option value=$combos[id]>$itemsrow[item_name]</option>";
}

 if (mysql_num_rows($getitems) < 3) { echo "You need at least three items to combine";}
  if (mysql_num_rows($getitems) > 2) {
echo "<select name=item1 value=''><option value=0>None</option>$itemlist</select> + ";
echo "<select name=item2 value=''><option value=0>None</option>$itemlist</select> + ";
echo "<select name=item3 value=''><option value=0>None</option>$itemlist</select> ";
echo "<input type=\"submit\" name=\"combine\" value=\"Combine!\" />
    </form>";
  }
  $getcombolist = mysql_query("SELECT * FROM builditem WHERE expneeded < 200 ");
  echo "<h2>Combo list</h2>";
  while($combolist=mysql_fetch_array($getcombolist)){
  $comblist .= " ".$combolist['itemid1']." + ".$combolist['itemid2']." + ".$combolist['itemid3']." = ".$combolist['make']." <BR>";
}

echo "
<div id='accordion'>
            <div>
                <h3><a href='#'>Level 1</a></h3>
                <div>$comblist</div>
            </div>
            <div>
                <h3><a href='#'>Level 2</a></h3>
                <div>None</div>
            </div>
            <div>
                <h3><a href='#'>Level 3</a></h3>
                <div>None</div>
            </div>
        </div>";



if ($ajax == 0) {
print "$closeHTML";
}

?>