<?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 == 'reset') {
if(isset($_POST['submit']) {
$ad = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b['energy']}' and

`type`='{$type}'")) or die('a');
$as = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b['cash']}' and

`type`='{$type}'")) or die('a');
$ass = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b['stats']}' and

`type`='{$type}'")) or die('a');
$asss = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b['training']}' and

`type`='{$type}'")) or die('a');
$assss = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b['reducehj']}' and

`type`='{$type}'")) or die('a');
$aassss = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b['brave']}' and

`type`='{$type}'")) or die('a');
$assss123 = mysql_fetch_array(mysql_query("select * from `gang_uplevels` where `level`='{$b['lessene']}' and

`type`='{$type}'")) or die('a');
$payback = $ad['exp']+$as['exp']+$ass['exp']+$asss['exp']+$assss['exp']+$aassss['exp']+$assss123['exp']/2;

mysql_query("update `users` set money=money+$payback where `userid`='{$userid}'") or die('fa');
mysql_query("update `gang_upgrades` set energy=1,stats=1,brave=1,cash=1,training=1,lessene=1,reducehj=1") or

die('faa');
print "You've been paid out $payback";
exit();

} else {
print "Are you sure you want to reset your upgrades? You'll get 50% of what you paid in return. Thats it.<br /><form

action='?sale=reset' method='post'><input type='submit' name='submit'></form>";
} }

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 /><a

href='gupgrade.php'>> Back <<</a>";
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($d2['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 /><a

href='gupgrade.php'>> Back <<</a>";
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 /><a

href='gupgrade.php'>> Back <<</a>";
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-{$d4['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 /><a href='gupgrade.php'>> Back <<</a>";
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();
?>