<?php
include "globals.php";
include "java.php";
if($ir['jail'] or $ir['hospital']) { die("This page cannot be accessed while in jail or hospital."); }
global $db,$ir,$c,$userid,$gangdata;



//PROCESS
$salefin = $_GET['sale'];
if($salefin == 'energy') {
$type = 'Energy';
$a = mysql_fetch_array(mysql_query("select * from `gangs` where `gangID`='{$ir['gang']}'")) or die('You do not belong with this gang.');
$b = mysql_fetch_array(mysql_query("select * from `gang_upgrades` where `gangid`='{$ir['gang']}'")) or die('Failed to grab upgrades');
$c = $b['energy'];
$d = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b['energy']}' and `type`='{$type}'")) or die('a');
//$e = mysql_fetch_array(mysql_query("select * from `gang_uplevels`
$f = $c+1;

if($d['exp'] >= $ir['money']) {
print "You don't have enough money to upgrade.";
exit();
}
mysql_query("update `users` set money=money-{$d['exp']} where `userid`='{$userid}'") or die('taking money failed');
mysql_query("update `gang_upgrades` set `energy`=energy+1 where `gangid`='{$ir['gang']}'") or die('promote failed');
print "<h3>SOLD</h3>";
print "<center><br />You have purchased a level for energy regains for your gang!<br />Gang ID: {$a['gangNAME']}<br />Current level: $c<br />New level: $f<br

/>Cost: {$d['exp']}";
exit;
}


if($salefin == 'stats') {
$type = 'stats';
$a1 = mysql_fetch_array(mysql_query("select * from `gangs` where `gangID`='{$ir['gang']}'")) or die('You do not belong with this gang.');
$b1 = mysql_fetch_array(mysql_query("select * from `gang_upgrades` where `gangid`='{$ir['gang']}'")) or die('Failed to grab upgrades');
$c1 = $b['energy'];
$d1 = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b1['stats']}' and `type`='{$type}'")) or die('a');
//$e = mysql_fetch_array(mysql_query("select * from `gang_uplevels`
$f1 = $c1+1;

if($d1['exp'] >= $ir['money']) {
print "You don't have enough money to upgrade.";
exit();
}
mysql_query("update `users` set money=money-{$d1['exp']} where `userid`='{$userid}'") or die('taking money failed');
mysql_query("update `gang_upgrades` set `stats`=stats+1 where `gangid`='{$ir['gang']}'") or die('promote failed');
print "<h3>SOLD</h3>";
print "<center><br />You have purchased a level for extra stats during a fight for your gang!<br />Gang ID: {$a1['gangNAME']}<br />Current level: $c1<br

/>New level: $f1<br />Cost: {$d1['exp']}";
exit;
}

if($salefin == 'cash') {
$type = 'cash';
$a2 = mysql_fetch_array(mysql_query("select * from `gangs` where `gangID`='{$ir['gang']}'")) or die('You do not belong with this gang.');
$b2 = mysql_fetch_array(mysql_query("select * from `gang_upgrades` where `gangid`='{$ir['gang']}'")) or die('Failed to grab upgrades');
$c2 = $b['energy'];
$d2 = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b2['cash']}' and `type`='{$type}'")) or die('a');
//$e = mysql_fetch_array(mysql_query("select * from `gang_uplevels`
$f2 = $c2+1;

if($d['exp'] >= $ir['money']) {
print "You don't have enough money to upgrade.";
exit();
}
mysql_query("update `users` set money=money-{$d2['exp']} where `userid`='{$userid}'") or die('taking money failed');
mysql_query("update `gang_upgrades` set `cash`=cash+1 where `gangid`='{$ir['gang']}'") or die('promote failed');
print "<h3>SOLD</h3>";
print "<center><br />You have purchased a level for extra cash from crimes for your gang!<br />Gang ID: {$a2['gangNAME']}<br />Current level: $c2<br />New

level: $f2<br />Cost: {$d2['exp']}";
exit;
}


if($salefin == 'training') {
$type = 'training';
$a3 = mysql_fetch_array(mysql_query("select * from `gangs` where `gangID`='{$ir['gang']}'")) or die('You do not belong with this gang.');
$b3 = mysql_fetch_array(mysql_query("select * from `gang_upgrades` where `gangid`='{$ir['gang']}'")) or die('Failed to grab upgrades');
$c3 = $b['energy'];
$d3 = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b3['training']}' and `type`='{$type}'")) or die('a');
//$e = mysql_fetch_array(mysql_query("select * from `gang_uplevels`
$f3 = $c3+1;

if($d3['exp'] >= $ir['money']) {
print "You don't have enough money to upgrade.";
exit();
}
mysql_query("update `users` set money=money-{$d3['exp']} where `userid`='{$userid}'") or die('taking money failed');
mysql_query("update `gang_upgrades` set `training`=training+1 where `gangid`='{$ir['gang']}'") or die('promote failed');
print "<h3>SOLD</h3>";
print "<center><br />You have purchased a level for extra stats from training for your gang!<br />Gang ID: {$a3['gangNAME']}<br />Current level: $c3<br />New

level: $f3<br />Cost: {$d3['exp']}";
exit;
}

if($salefin == 'reducehj') {
$type = 'reducehj';
$a4 = mysql_fetch_array(mysql_query("select * from `gangs` where `gangID`='{$ir['gang']}'")) or die('You do not belong with this gang.');
$b4 = mysql_fetch_array(mysql_query("select * from `gang_upgrades` where `gangid`='{$ir['gang']}'")) or die('Failed to grab upgrades');
$c4 = $b['energy'];
$d4 = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b4['reducehj']}' and `type`='{$type}'")) or die('a');
//$e = mysql_fetch_array(mysql_query("select * from `gang_uplevels`
$f4 = $c4+1;

if($d4['exp'] >= $ir['money']) {
print "You don't have enough money to upgrade.";
exit();
}
mysql_query("update `users` set money=money-{$d['exp']} where `userid`='{$userid}'") or die('taking money failed');
mysql_query("update `gang_upgrades` set `reducehj`=reducehj+1 where `gangid`='{$ir['gang']}'") or die('promote failed');
print "<h3>SOLD</h3>";
print "<center><br />You have purchased a level for your gang! <br />You now will get $f% off of your hospital and jail time<br />Gang ID:

{$a4['gangNAME']}<br />Current level: $c4<br />New level: $f4<br />Cost: {$d4['exp']}";
exit;
}

print "<h3>Gang Upgrading</h3>
<table width='75%' class=\"table\" border=\"0\" cellspacing=\"1\">
    <tr bgcolor=gray>
        <th>Name</th>
        <th>Level</th>
        <th>Cost per level</th>
        <th>Actions</th>
    </tr>";
$own = mysql_numrows(mysql_query("select * from `users` where `gang`='{$gangdata['gangID']}' && `userid`='{$userid}'"));
if($owner >= 1) {
print "Gangid = {$gangdata['gangID']} - $gangown You can't upgrade a gang you don't have";
exit();
}

//Level pricing.

//Process upgrade
//Purchase
$pricefor = mysql_fetch_array(mysql_query("select * from `gang_uplevels`")) or die('failed');

$a = mysql_fetch_array(mysql_query("select * from `gangs` where `gangID`='{$ir['gang']}'")) or die('You do not belong with this gang.');
$b = mysql_fetch_array(mysql_query("select * from `gang_upgrades` where `gangid`='{$ir['gang']}'")) or die('Failed to grab upgrades');
$type = 'energy';
$type2 = 'stats';
$type3 = 'cash';
$type4 = 'training';
$type5 = 'reducehj';
$type6 = 'discount';
$type7 = 'armorcell';
$eh = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b['energy']}' and `type`='{$type}'")) or die('a');
$eh1 = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b['stats']}' and `type`='{$type2}'")) or die('a');
$eh2 = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b['cash']}' and `type`='{$type3}'")) or die('a');
$eh3 = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b['training']}' and `type`='{$type4}'")) or die('a');
$eh4 = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b['reducehj']}' and `type`='{$type5}'")) or die('a');
$levels = mysql_fetch_array(mysql_query("select * from `gang_upgrades` where `gangid`='{$ir['gang']}'")) or die('epic');

print "
<tr>
            <td>x% less energy required for crimes.</td>
            <td>{$levels['energy']}</td><td>$ {$eh['exp']}</td><td><a href='?sale=energy' method='get' onclick='energy()'>Purchase</a> - <a href='#'>Sell

off</a></td>
        </tr>

<tr>
            <td>Upgrade % extra stats during fight.</td>
            <td>{$levels['stats']}</td><td>$ {$eh1['exp']}</td><td><a href='?sale=stats' method='get' onclick='stats()'>Purchase</a> - <a href='#'>Sell

off</a></td>
        </tr>

<tr>
            <td>x% extra cash from crimes.</td>
            <td>{$levels['cash']}</td><td>$ {$eh2['exp']}</td><td><a href='?sale=cash' method='get' onclick='stats()'>Purchase</a> - <a href='#'>Sell

off</a></td>
        </tr>
<tr>
 <td>x% training bonus.</td>
            <td>{$levels['training']}</td><td>$ {$eh3['exp']}</td><td><a href='?sale=training' method='get' onclick='stats()'>Purchase</a> - <a href='#'>Sell

off</a></td>
        </tr>
<tr>
<td>-x% hospital and jail (Reduces both)</td>
            <td>{$levels['reducehj']}</td><td>$ {$eh4['exp']}</td><td><a href='?sale=reducehj' method='get' onclick='stats()''>Purchase</a> - <a

href='#'>Sell off</a></td>
        </tr>

<tr>
<td>Store discount (Gives the whole gang 10% off shop items)</td>
            <td>--</td><td>250c</td><td><a href='#'>Purchase</a> - <a href='#'>Sell off</a></td>
        </tr>

<tr>
<td>Armor shipments (Gives everyone a vest daily and offers them at a discount)</td>
            <td>--</td><td>75CC</td><td><a href='#'>Purchase</a> - <a href='#'>Sell off</a></td>
        </tr>
";

print "</table><br /><center>$ - Cash || c - Crystals || CC - Credits</center>";
$h->endpage();
?>