<?php
session_start();
echo "<body bgcolor=\"#6A96E6\" text=\"#333333\" link=\"#000000\" vlink=\"#333333\" alink=\"#FF0000\">";
$user = $_SESSION['username'];
//connect to DB
$link = mysql_connect("localhost","root","");
mysql_select_db("f1racers",$link);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
//Getting the max no men
$sql = "SELECT * FROM recrute WHERE Person = 'Pitmen'";
$result = mysql_query($sql, $link) or die(mysql_error());
while ($stats = mysql_fetch_array($result)) {
$max = $stats['Max'];
}
//getting the pitmen amount for users
$sql = "SELECT pitmen FROM users WHERE username = '$user'";
$result = mysql_query($sql, $link) or die(mysql_error());
$oldpitmen = mysql_result($result, 0);
//getting turns left
$sql = "SELECT turns FROM users WHERE username = '$user'";
$result = mysql_query($sql, $link) or die(mysql_error());
$oldturns = mysql_result($result, 0);
//getting turns left
$sql = "SELECT money FROM users WHERE username = '$user'";
$result = mysql_query($sql, $link) or die(mysql_error());
$oldmoney = mysql_result($result, 0);
echo "<body onload=\"parent.topFrame.location.href='banna.php';\">";
echo "<br><br><br><p><strong><font size=\"4\"> Please select how meny turns you would like to use to
recuit: </font></strong></p>";
echo "<div align=\"left\"><font size=\"3\">You have</font> <strong>
<font color=\"#FFFF00\" size=\"4\">$oldturns</font></strong><font size=\"3\">
turns left</font></div>";
echo "<div align=\"left\"><font size=\"3\">You have</font> <strong>
<font color=\"#FFFF00\" size=\"4\">$oldmoney</font></strong><font size=\"3\">
credit left to recuit</font></div>";
echo "<div align=\"left\"><font size=\"3\">You have</font> <strong>
<font color=\"#FFFF00\" size=\"4\">$oldpitmen</font></strong><font size=\"3\">
total pitmen</font><font size=\"3\"> out of</font> <strong>
<font color=\"#FFFF00\" size=\"4\">$max</font></strong><font size=\"3\">
max pitmen</font></div><br><br><br><br><br>";
//form for prosess
echo "<form name=\"form1\" method=\"post\" action=\"\">
<div align=\"center\">
<select name=\"select\">
<option>0</option>
<option>100</option>
<option>200</option>
<option>300</option>
</select>
</div>
<div align=\"center\">
<input type=\"submit\" name=\"Submit\" value=\"Submit\">
</div>
</form>";
//adding the no. of pitmen to user
$select = $_POST['select'];
if ($select == "0"){
$newpitmen = $oldpitmen + 0;
}elseif ($select == "100"){
$newpitmen = $oldpitmen + 1;
$newturns = $oldturns - $select;
mysql_query("UPDATE users SET pitmen = '$newpitmen' WHERE username='$user'",$link);
mysql_query("UPDATE users SET turns = '$newturns' WHERE username='$user'",$link);
}elseif ($select == "200"){
$newpitmen = $oldpitmen + 2;
$newturns = $oldturns - $select;
mysql_query("UPDATE users SET pitmen = '$newpitmen' WHERE username='$user'",$link);
mysql_query("UPDATE users SET turns = '$newturns' WHERE username='$user'",$link);
}elseif ($select == "300"){
$newpitmen = $oldpitmen +3;
$newturns = $oldturns - $select;
mysql_query("UPDATE users SET pitmen = '$newpitmen' WHERE username='$user'",$link);
mysql_query("UPDATE users SET turns = '$newturns' WHERE username='$user'",$link);
}
