Jump to content
MakeWebGames

Need help inserting a revive bit into my points page :/ dont know how to do it.

LearningCoder

By LearningCoder
in Game Support

 Share

Recommended Posts

LearningCoder Newbie

LearningCoder

Posted
Posted (edited)

the bit if users are alive is status='alive' and i dont know how to add it :/

......

 

 

<?php include"mainmenu.php"; ?>




<?php


if($_POST['invitebg']){

$id=mysql_real_escape_string(strip_tags($_POST['id']));
$invitename=mysql_real_escape_string(strip_tags($_POST['bginame']));


$sql="SELECT * FROM users WHERE username='$invitename' LIMIT 1";
$result=mysql_query($sql);
$numresult=mysql_num_rows($result);
while($rows=mysql_fetch_array($result)){ // Start looping table row  


$rankid=mysql_real_escape_string(htmlentities($rows['rankid']));

}//end loop

if($rankid<="7"){
echo "Your BodyGuard must be ranked ateast $rank_8!";

}else{

if(strtolower($username)==strtolower($invitename)){
echo "You can not invite your self to be your bodyguard.";
}else{

mysql_query("UPDATE BG SET bodyguard='$invitename', status='Pending' WHERE username='$username' AND id='$id'");
echo "You invited $invitename to be your BodyGuard";

}//invite self
}//user not ranked high enough
}//if submit invite bg

?>






<?php

if($_POST['deleteinvite']){

$id=mysql_real_escape_string(strip_tags($_POST['id']));


mysql_query("UPDATE BG SET bodyguard='', status='None' WHERE username='$username' AND id='$id'");
echo "You cancelled the invite!";


}//if submit kick member

?>





<?php



if($_POST['dropbg']){

$id=mysql_real_escape_string(strip_tags($_POST['id']));


mysql_query("UPDATE BG SET bodyguard='', status='None' WHERE username='$username' AND id='$id'");
echo "You dropped your BodyGuard!";


}//if submit kick member

?>


<?php

if($_POST['accept']){

$id=mysql_real_escape_string(strip_tags($_POST['id']));


$bgnum=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE status='Ready' AND bodyguard='$username'"));
if($bgnum >= "1"){
die("You are allready a body guard for someone!");
}else{

mysql_query("UPDATE BG SET status='Ready' WHERE bodyguard='$username' AND id='$id'");
echo "You accepted your BodyGuard invite!";

}

}//if submit kick member

?>




<?php

if($_POST['reject']){

$id=mysql_real_escape_string(strip_tags($_POST['id']));


mysql_query("UPDATE BG SET status='None' WHERE bodyguard='$username' AND id='$id'");
echo "You rejected your BodyGuard invite!";


}//if submit kick member

?>





<?php



if ($_POST['give'] && strlen($_POST['giveamount'])<7){

$giveto = mysql_real_escape_string(strip_tags($_POST['giveto']));
$giveamount = $_POST['giveamount'];

if(strtolower($username)==strtolower($giveto)){
echo"You can not send points to yourself!";
}else{

if (ereg('[^0-9]', $_POST['giveamount'])){
echo "Invalid amount.";
}else{

if ($giveamount<=0){
echo "Invalid amount.";
}else{

$checkname = mysql_query("SELECT * FROM users WHERE username='$giveto'");
$NameCount = mysql_num_rows($checkname);

if ($NameCount < 1){
echo "No such user";
}else{

if($points < $giveamount){
echo"You do not have enough points";
}else{

$sendamount1=number_format($_POST['giveamount']);

mysql_query("UPDATE users SET `points`=`points`+'$giveamount' WHERE username='$giveto'");
mysql_query("UPDATE users SET `points`=`points`-'$giveamount' WHERE username='$username'");
mysql_query("INSERT INTO `pointtransfers` ( `id` , `reciever` , `sender` , `amount` ,`place` ) VALUES ('', '$giveto', '$username', '$giveamount', 'bank')");






$sql2="SELECT * FROM iptrack WHERE username='$username' ORDER BY id ASC";
$result2=mysql_query($sql2);
while($rows=mysql_fetch_array($result2)){ // Start looping table row  

$id = $rows['id'];
$ip = $rows['ip'];
$name = $rows['username'];


$select = mysql_query("SELECT * FROM iptrack WHERE ip='$ip' AND username='$name' AND id<'$id'");
$num = mysql_num_rows($select);

if($num<="0"){


$sql2="SELECT * FROM iptrack WHERE ip='$ip' ORDER BY id ASC";
$result2=mysql_query($sql2);
while($rows=mysql_fetch_array($result2)){ // Start looping table row  

$id = $rows['id'];
$ip = $rows['ip'];
$name = $rows['username'];

$select = mysql_query("SELECT * FROM iptrack WHERE username='$name' AND id<'$id'");
$num = mysql_num_rows($select);



if(strtolower($name)==strtolower($giveto)){
$addippoint="1";
}
}
}
}

if($addippoint=="1"){
$newippoints=$ippoints+1;
mysql_query("UPDATE users SET ippoints='$newippoints' WHERE username='$username'");
}


echo "You sent $sendamount1 points to $giveto";

}//if not enough points
}//no such user
}//send money less then 1
}//if send amount not numbers
}// if send to self
}//if submit

?>




<?php
if($_POST['buy']){
$item=mysql_real_escape_string(strip_tags($_POST['item']));


if($item){

if($item=="1"){

if($points>="50"){
$newpoints=$points-50;

mysql_query("UPDATE users SET rankbar='1' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'50' WHERE username='$username'");

echo "You Bought a rank bar!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 1 aka rankbar





if($item=="2"){

if($points>="150"){
$newpoints=$points-150;
$newbullets=$bullets+3500;
mysql_query("UPDATE users SET bullets='$newbullets' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'150' WHERE username='$username'");

echo "You Bought 3,500 Bullets!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 2 aka 3500 bullets






if($item=="3"){

if($points>="250"){
$newpoints=$points-250;
$newbullets=$bullets+8000;
mysql_query("UPDATE users SET bullets='$newbullets' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'250' WHERE username='$username'");

echo "You Bought 8,000 Bullets!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 3 aka 8000 bullets





if($item=="157"){

if($points>="150"){
$newpoints=$points-150;
mysql_query("UPDATE users SET status='Dead' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

echo "You Commited Suicide!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 157 aka Commit Suicide





if($item=="4"){

if($points>="500"){
$newpoints=$points-500;
$newbullets=$bullets+25000;
mysql_query("UPDATE users SET bullets='$newbullets' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'500' WHERE username='$username'");

echo "You Bought 25,000 Bullets!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 4 aka 25000 bullets







if($item=="5"){

if($points>="1"){
$newpoints=$points-1;
mysql_query("DELETE FROM jail WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'1' WHERE username='$username'");

echo "You left jail!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 5 aka leave jail





if($item=="6"){

if($points>="15"){
$newpoints=$points-15;
$newhealth=$health+5;
mysql_query("UPDATE users SET health='$newhealth' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'15' WHERE username='$username'");

echo "You Bought 5% health!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 6 aka 5percent health





if($item=="7"){

if($points>="30"){
$newpoints=$points-30;
$newhealth=$health+15;
mysql_query("UPDATE users SET health='$newhealth' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'30' WHERE username='$username'");

echo "You Bought 15% health!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 7 aka 15percent health









if($item=="8"){

if($points>="45"){
$newpoints=$points-45;
$newhealth=$health+25;
mysql_query("UPDATE users SET health='$newhealth' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'45' WHERE username='$username'");

echo "You Bought 25% health!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 8 aka 25percent health






if($item=="9"){

if($points>="3"){
$newpoints=$points-3;
$time=time()-1;
mysql_query("UPDATE times SET gta='$time' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'3' WHERE username='$username'");

echo "Your GTA timer has been reset!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 9 aka reset GTA timer





if($item=="10"){

if($points>="3"){
$newpoints=$points-3;
$time=time()-1;
mysql_query("UPDATE times SET melt='$time' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'3' WHERE username='$username'");

echo "Your Melt timer has been reset!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 10 aka reset melt timer





if($item=="11"){

if($points>="150"){
$newpoints=$points-150;

$numcheck=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE bodyguard='$username' AND status='Ready'"));

if($numcheck>="1"){
die("You can not buy a body guard spot because you are allready a bodyguard for someone!");
}




$numcheck1=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE username='$username' AND slot='1'"));

if($numcheck1=="0"){

mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");
mysql_query("INSERT INTO `BG` (`id`, `username`, `bodyguard`, `status`, `slot`) VALUES ('', '$username', '', 'None', '1')");


mysql_query("UPDATE users SET `pointspent`=`pointspent`+'150' WHERE username='$username'");

echo "You Bought a BodyGuard spot";

}else{
echo "You allready have a BodyGuard spot 1!";
}


}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 11 aka bosyguard spot 1







if($item=="12"){

if($points>="225"){
$newpoints=$points-225;

$numcheck=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE bodyguard='$username' AND status='Ready'"));

if($numcheck>="1"){
die("You can not buy a body guard spot because you are allready a bodyguard for someone!");
}




$numcheck1=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE username='$username' AND slot='1'"));

if($numcheck1=="1"){



$numcheck1=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE username='$username' AND slot='2'"));

if($numcheck1=="0"){

mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");
mysql_query("INSERT INTO `BG` (`id`, `username`, `bodyguard`, `status`, `slot`) VALUES ('', '$username', '', 'None', '2')");


mysql_query("UPDATE users SET `pointspent`=`pointspent`+'225' WHERE username='$username'");

echo "You Bought a BodyGuard spot";

}else{
echo "You allready have a BodyGuard spot 2!";
}


}else{
echo "You need to buy a bodyguard spot 1 first!";
}


}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 12 aka bosyguard spot 2










if($item=="13"){

if($points>="350"){
$newpoints=$points-350;

$numcheck=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE bodyguard='$username' AND status='Ready'"));

if($numcheck>="1"){
die("You can not buy a body guard spot because you are allready a bodyguard for someone!");
}




$numcheck1=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE username='$username' AND slot='2'"));

if($numcheck1=="1"){



$numcheck1=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE username='$username' AND slot='3'"));

if($numcheck1=="0"){

mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");
mysql_query("INSERT INTO `BG` (`id`, `username`, `bodyguard`, `status`, `slot`) VALUES ('', '$username', '', 'None', '3')");


mysql_query("UPDATE users SET `pointspent`=`pointspent`+'350' WHERE username='$username'");

echo "You Bought a BodyGuard spot";

}else{
echo "You allready have a BodyGuard spot 3!";
}


}else{
echo "You need to buy a bodyguard spot 2 first!";
}


}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 13 aka bosyguard spot 3










if($item=="14"){

if($points>="400"){
$newpoints=$points-400;

$numcheck=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE bodyguard='$username' AND status='Ready'"));

if($numcheck>="1"){
die("You can not buy a body guard spot because you are allready a bodyguard for someone!");
}




$numcheck1=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE username='$username' AND slot='3'"));

if($numcheck1=="1"){



$numcheck1=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE username='$username' AND slot='4'"));

if($numcheck1=="0"){

mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");
mysql_query("INSERT INTO `BG` (`id`, `username`, `bodyguard`, `status`, `slot`) VALUES ('', '$username', '', 'None', '4')");


mysql_query("UPDATE users SET `pointspent`=`pointspent`+'400' WHERE username='$username'");

echo "You Bought a BodyGuard spot";

}else{
echo "You allready have a BodyGuard spot 4!";
}


}else{
echo "You need to buy a bodyguard spot 3 first!";
}


}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 14 aka bosyguard spot 4



if($item=="15"){

if($points>="500"){
$newpoints=$points-500;

$numcheck=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE bodyguard='$username' AND status='Ready'"));

if($numcheck>="1"){
die("You can not buy a body guard spot because you are allready a bodyguard for someone!");
}




$numcheck1=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE username='$username' AND slot='4'"));

if($numcheck1=="1"){



$numcheck1=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE username='$username' AND slot='5'"));

if($numcheck1=="0"){

mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");
mysql_query("INSERT INTO `BG` (`id`, `username`, `bodyguard`, `status`, `slot`) VALUES ('', '$username', '', 'None', '5')");


mysql_query("UPDATE users SET `pointspent`=`pointspent`+'650' WHERE username='$username'");

echo "You Bought a BodyGuard spot";

}else{
echo "You allready have a BodyGuard spot 5!";
}


}else{
echo "You need to buy a bodyguard spot 4 first!";
}


}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 15 aka bosyguard spot 5












if($item=="16"){

if($points>="15"){
$newpoints=$points-15;
$time=time()-1;
mysql_query("UPDATE users SET nextshoot='$time' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'15' WHERE username='$username'");

echo "Your Kill timer has been reset!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 16 aka reset shoot timer





if($item=="17"){

if($points>="100"){
$newpoints=$points-100;
mysql_query("UPDATE users SET `customs`=`customs`+'1' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'100' WHERE username='$username'");

echo "You Bought a custom car spot!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 17 aka custom car spot



if($item=="300"){

if($points>="300"){
$newpoints=$points-300;
mysql_query("UPDATE users SET `findkiller`=`findkiller`+'1' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'300' WHERE username='$username'");

echo "You can now find the killer!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 300 


if($item=="18"){

if($points>="25"){
$newpoints=$points-25;

if($specialvest>="1"){
die("You allready have a Light Military Vest.");
}
mysql_query("UPDATE users SET specialvest='1' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'25' WHERE username='$username'");

echo "You Bought a Light Military Vest!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 18 aka light miletry vest




if($item=="19"){

if($points>="50"){
$newpoints=$points-50;

if($specialvest<="0"){
die("You need to buy a Light Military Vest first.");
}

if($specialvest>="2"){
die("You allready have a Medium Military Vest.");
}

mysql_query("UPDATE users SET specialvest='2' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'50' WHERE username='$username'");

echo "You Bought a Medium Military Vest!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 19 aka Medium miletry vest





if($item=="20"){

if($points>="100"){
$newpoints=$points-100;

if($specialvest<="1"){
die("You need to buy a Medium Military Vest first.");
}

if($specialvest>="3"){
die("You allready have a Heavy Military Vest.");
}

mysql_query("UPDATE users SET specialvest='3' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'100' WHERE username='$username'");

echo "You Bought a Heavy Military Vest!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 20 aka heavy miletry vest







if($item=="21"){

if($points>="100"){
$newpoints=$points-100;


mysql_query("UPDATE users SET `octimer`='8' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'100' WHERE username='$username'");

echo "Your oc timer has been changed to 8 hours!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 21 aka 8 hours oc time




if($item=="22"){

if($points>="3"){
$newpoints=$points-3;
mysql_query("UPDATE users SET `repaircar`=`repaircar`+'1' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'3' WHERE username='$username'");

echo "The next car you attempt to repair will be successfull!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 22 aka repair car










if($item=="23"){

if($points>="500"){
$newpoints=$points-500;

$numcheck=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE bodyguard='$username' AND status='Ready'"));

if($numcheck>="1"){
die("You can not buy a body guard spot because you are allready a bodyguard for someone!");
}




$numcheck1=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE username='$username' AND slot='3'"));

if($numcheck1=="1"){



$numcheck1=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE username='$username' AND status='Ready' AND slot='4'"));

if($numcheck1=="0"){


mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

$bgname=time().rand(10,99);

$bgrand=rand(1,3);

if($bgrand==1){
$bgrank="$rank_9";
$bgrankpoints = $rank_8_exp+200;
$bgrankid=8;
}elseif($bgrand==2){
$bgrank="$rank_10";
$bgrankpoints = $rank_9_exp+250;
$bgrankid=9;
}else{
$bgrank="$rank_13";
$bgrankpoints = $rank_10_exp+250;
$bgrankid=10;
}

mysql_query("DELETE FROM `BG` WHERE username='$username' AND slot='4'");

mysql_query("INSERT INTO `users` (`id`, `username`, `password`, `rank`, `rankpoints`, `rankid`, `robotbg`) VALUES ('', '$bgname', '5(9$fg&*gf6%54)65%', '$bgrank', '$bgrankpoints', '$bgrankid', '1')");
mysql_query("INSERT INTO `BG` (`id`, `username`, `bodyguard`, `status`, `slot`) VALUES ('', '$username', '$bgname', 'Ready', '4')");


mysql_query("UPDATE users SET `pointspent`=`pointspent`+'500' WHERE username='$username'");

echo "You Bought a Robot BodyGuard";


}else{
echo "You allready have a BodyGuard spot 4!";
}

}else{
echo "You need to buy a bodyguard spot 3 first!";
}


}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 22 aka robot bosyguard spot 4











if($item=="24"){

if($points>="600"){
$newpoints=$points-600;

$numcheck=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE bodyguard='$username' AND status='Ready'"));

if($numcheck>="1"){
die("You can not buy a body guard spot because you are allready a bodyguard for someone!");
}




$numcheck1=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE username='$username' AND slot='4'"));

if($numcheck1=="1"){




$numcheck1=mysql_num_rows(mysql_query("SELECT * FROM BG WHERE username='$username' AND status='Ready' AND slot='5'"));

if($numcheck1=="0"){


mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

$bgname=time().rand(10,99);

$bgrand=rand(1,3);

if($bgrand==1){
$bgrank="$rank_10";
$bgrankpoints = $rank_8_exp+200;
$bgrankid=8;
}elseif($bgrand==2){
$bgrank="$rank_12";
$bgrankpoints = $rank_9_exp+250;
$bgrankid=9;
}else{
$bgrank="$rank_15";
$bgrankpoints = $rank_10_exp+2550;
$bgrankid=10;
}

mysql_query("DELETE FROM `BG` WHERE username='$username' AND slot='5'");

mysql_query("INSERT INTO `users` (`id`, `username`, `password`, `rank`, `rankpoints`, `rankid`, `robotbg`) VALUES ('', '$bgname', 'trt()Ggf5&$$^fg6£$^hi', '$bgrank', '$bgrankpoints', '$bgrankid', '1')");
mysql_query("INSERT INTO `BG` (`id`, `username`, `bodyguard`, `status`, `slot`) VALUES ('', '$username', '$bgname', 'Ready', '5')");


mysql_query("UPDATE users SET `pointspent`=`pointspent`+'700' WHERE username='$username'");

echo "You Bought a Robot BodyGuard";

}else{
echo "You allready have a BodyGuard spot 5!";
}


}else{
echo "You need to buy a bodyguard spot 4 first!";
}


}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 22 aka robot bosyguard spot 5









if($item=="25"){

if($points>="75"){
$newpoints=$points-75;




if ($gun1 != $gun_9){

echo "You need to buy a $gun_9 before you can buy this Gun!";
}else{

mysql_query("UPDATE users SET gun='$gun_10', gunid='10', points='$newpoints' WHERE username='$username'");

mysql_query("INSERT INTO `logs` ( `id` , `who` , `action` , `date` ) VALUES ('', '$username', 'Bought a $gun_10', '$date')");

echo "You Bought the gun!";

}


}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 25 aka gun





if($item=="26" && $rankbar<="0"){

if($points>="50"){
$newpoints=$points-50;

mysql_query("UPDATE users SET points='$newpoints', rankbar='1' WHERE username='$username'");
mysql_query("UPDATE users SET `pointspent`=`pointspent`+'50' WHERE username='$username'");

echo "Your Bought a rank bar!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 26 aka rank bar





if($item=="27" && $rankbar<="1"){

if($points>="100"){
$newpoints=$points-100;

mysql_query("UPDATE users SET points='$newpoints', rankbar='2' WHERE username='$username'");
mysql_query("UPDATE users SET `pointspent`=`pointspent`+'100' WHERE username='$username'");

echo "Your Bought a rank bar!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 27 aka rank bar




if($item=="28" && $rankbar<="1"){

if($points>="350"){
$newpoints=$points-350;

mysql_query("UPDATE users SET points='$newpoints', rankbar='2' WHERE username='$username'");
mysql_query("UPDATE users SET `pointspent`=`pointspent`+'350' WHERE username='$username'");
mysql_query("UPDATE users SET find='1' WHERE username='$username'");

echo "You can now use kill finder once only!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 28 aka Find The Killer



if($item=="50"){

if($points>="500"){
$newpoints=$points-500;
$newrankpoints=$rankpoints+325;
mysql_query("UPDATE users SET rankpoints='$newrankpoints' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'500' WHERE username='$username'");

echo "You Bought 325 Rank Points!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 2 aka 325 Rank Points



if($item=="333"){

if($points>="650"){
$newpoints=$points-650;
$newcash=$cash+250000000;
mysql_query("UPDATE users SET cash='$newcash' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'650' WHERE username='$username'");

echo "You Bought $250,000,000!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 2 aka 250 Million in cash.



if($item=="51"){

if($points>="999"){
$newpoints=$points-999;
$newrankpoints=$rankpoints+750;
mysql_query("UPDATE users SET rankpoints='$newrankpoints' WHERE username='$username'");
mysql_query("UPDATE users SET points='$newpoints' WHERE username='$username'");

mysql_query("UPDATE users SET `pointspent`=`pointspent`+'999' WHERE username='$username'");

echo "You Bought 750 Rank Points!";
}else{
echo "You do not have enough points!";
}//not enough points
}//item equels 2 aka 350 Rank Points






}//item
}//buy subit
?>



<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=topleft NOWRAP>
</td>
<td class=leftbar NOWRAP>
</td>
<td class=bar NOWRAP>

</td>
<td class=rightbar NOWRAP>
</td>
<td class=topright NOWRAP>
</td>
</tr>
</tbody>
</table>
<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=left NOWRAP>
</td>
<td class=main>
<div align="center">


<a href="PayPal.php">Click Here To Buy Points with PayPal <b><font color="lime">X4</font></b>!</a></font>

</div>
</td>
<td class=right NOWRAP>
</td>
</tr>
</Tbody>
</table>


<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=bottomleft NOWRAP>
</td>
<td class=bottom NOWRAP>
</td>
<td class=bottomright NOWRAP>
</td>
</tr>
</tbody>
</table>

<br>


<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=topleft NOWRAP>
</td>
<td class=leftbar NOWRAP>
</td>
<td class=bar NOWRAP>

</td>
<td class=rightbar NOWRAP>
</td>
<td class=topright NOWRAP>
</td>
</tr>
</tbody>
</table>
<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=left NOWRAP>
</td>
<td class=main>
<div align="center">

   	<link REL="stylesheet" TYPE="text/css" HREF="nlstyle.css">
<script type="text/javascript" language="javascript" src="SuspectedGangsters.js"></script>

<table cellpadding=0 width="85%" align=center><tr><td>
<Br><Br>
<table width=100% cellpadding=0 cellspacing=0><tr><td width="55%" valign="top">
<table cellpadding=0 cellspacing=2 width=80%>
<form method="post">
<tr><td width=75% bgcolor=<?php echo "$tabcolor"; ?> class=tab NOWRAP colspan=2><font color=silver face=verdana size=1><div class="CM"></div>Item<div class="CM"></div></font></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> class=tab NOWRAP><font color=silver face=verdana size=1><div class="CM"></div>Price<div class="CM"></div> </font></td></tr>

<tr>
 <td bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=157></td>
 <td bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1><b>Commit Suicide</b></font></td>
 <td bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>150</font></td>
</tr>
<tr>
 <td bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=17></td>
 <td bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>Create Custom Car </font></td>
 <td bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>100</font></td>
</tr>

<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=300></td>
 <td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>Find The Killer </font></td>
 <td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>300</font></td>
</tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=18></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>Light Military Vest  </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>25</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=19></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>Medium Military Vest  </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>50</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=20></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>Heavy Military Vest </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>100</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=21></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>Change oc timer to 8 hours </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>100</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=22></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>Successfully repair car</font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>3</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=5></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>Leave Jail </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>1</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=2></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>3,500 Bullets </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>150</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=3></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>8,000 Bullers </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>250</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=4></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>25,000 Bullets </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>500</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=6></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>5% Health </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>15</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=7></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>15% Health </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>30</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=8></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>25% Health </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>45</font></td></tr>

<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=25></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1><?php echo "$gun_10"; ?> </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>75</font></td></tr>

<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=16></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>Reset Kill Timer </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>15</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=9></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>Reset GTA Timer </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>3</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=10></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>Reset Melt Timer </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>3</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=11></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>BodyGuard spot 1 </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>150</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=12></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>BodyGuard spot 2 </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>225</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=13></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>BodyGuard spot 3 </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>350</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=14></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>BodyGuard spot 4 </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>400</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=23></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=darkgrey face=verdana size=1><b><font color="red">Robot BodyGuard 4</font> </b></font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>600</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=15></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>BodyGuard spot 5 </font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>650</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=24></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=darkgrey face=verdana size=1><b><font color="red">Robot BodyGuard 5</font> </b></font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>700</font></td></tr>

<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=26></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>Rank Bar</font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>50</font></td></tr>

<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=27></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>Advanced Rank Bar</font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>100</font></td></tr>

<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=50></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>325 Rank Points</font> <font color="lime"><i>(New)</i></font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>500</font></td></tr>
<tr><td width=1% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><input type=radio name=item value=51></td><td width=75% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver face=verdana size=1>750 Rank Points</font> <font color="lime"><i>(New)</i></font></td><td width=25% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP><font color=silver  face=verdana size=1>999</font></td></tr>

<tr><td width=100% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP colspan=2><font color=silver  face=verdana size=1><b>Current points: <?php echo number_format($points); ?></b> </font></td>
<td width=100% bgcolor=<?php echo "$tabcolor"; ?> NOWRAP colspan="1"><input type=submit name=buy value="Buy" class="tbox" style="width:100%;"></td></tr>

</form>
</table>
</td><td width="100%" valign="top">

<table width="100%" cellspacing="2" cellpadding="2" style="border-bottom: 0px solid #3D4456; border-left: 0px solid #7885A7; border-right: 0px solid #3D4456; border-top: 0px solid #6F7B9A;">
		<tr>
			<td class="tab" colspan="3">
			<div align="center" class="unnamed1"><div class="CM"></div>Last 10 sent:<div class="CM"></div></div>
			</td>
		</tr>

<?php

//desplay data

$get = mysql_query("SELECT * FROM pointtransfers WHERE sender='$username'ORDER BY id DESC LIMIT 0 , 10");
while($row = mysql_fetch_assoc($get))
{
//get data
$reciever = $row['reciever'];
$amount = number_format($row['amount']);

?>



<tr>
<td bgcolor="<?php echo "$tabcolor"; ?>">
<font color="#999999">
 You sent <?php echo $amount ?> points to <a href="viewprofile.php?viewuser=<?php echo $reciever ?>"><font color="#999999"><?php echo $reciever ?></font></a>.</font>
</td>
</tr>

<?php
}
?>



			<td class="tab" colspan="3">
			<div align="center" class="unnamed1"><div class="CM"></div>Last 10 received:<div class="CM"></div></div>



	</td>
                                  </tr>


<?php

//desplay data

$get = mysql_query("SELECT * FROM pointtransfers WHERE reciever='$username'ORDER BY id DESC LIMIT 0 , 10");
while($row = mysql_fetch_assoc($get))
{
//get data
$from = $row['sender'];
$amount = number_format($row['amount']);

?>



<tr>
<td bgcolor="<?php echo "$tabcolor"; ?>">
<font color="#999999">
 You received <?php echo $amount ?> points from <a href="viewprofile.php?viewuser=<?php echo $from ?>"><font color="#999999"><?php echo $from ?></font></a>.</font>
</td>
</tr>

<?php
}
?>

	</table>


<br><br><table width="25%" cellpadding="0" cellspacing="1" align="center">
<tr><td bgcolor=<?php echo "$tabcolor"; ?> class=tab align="center" NOWRAP colspan="2"><font color="silver" size="2" face="verdana"><div class="CM"></div>Send Points<div class="CM"></div></font></td></tr>
<form action="" method="post"><tr><td width="100%" bgcolor="<?php echo "$tabcolor"; ?>" NOWRAP><font color="silver" size="1" face="verdana">Username:</font></td><td width="50%" colspan="1"><input type="text" name="giveto" class="tbox"></td></tr>
<tr><td width="100%" bgcolor="<?php echo "$tabcolor"; ?>"  NOWRAP><font color="silver" size="1" face="verdana">Amount:</font></td><td width="50%" colspan="1"><input type="text" name="giveamount" class="tbox"></td></tr>
<tr><td height="15" width="100%" bgcolor="<?php echo "$tabcolor"; ?>" NOWRAP colspan="2"><input height="18" type="submit" value="Send" class="header" name="give" style="width: 100%; height:100%;"></td></tr></form>


</table>

<br><br>

<form method="post" action="">
<table width="100%" cellspacing="2" cellpadding="2" style=" border-bottom: 0px solid #3D4456;	border-left: 0px solid #7885A7;	border-right: 0px solid #3D4456;	border-top: 0px solid #6F7B9A;	">
<tr>
<td class="tab" colspan="3"><div align="center" class="unnamed1"><div class="CM"></div>Bodyguards:<div class="CM"></div></div></td>
</tr>


<?php



$query=mysql_query("SELECT * FROM BG WHERE username='$username'");
$num=mysql_num_rows($query);
if($num<=0){



//not owner of bg spot show invites or whos bg

$query=mysql_query("SELECT * FROM BG WHERE bodyguard='$username'");
$num=mysql_num_rows($query);
if($num<=0){
echo "";
}else{
$query=mysql_query("SELECT * FROM BG WHERE bodyguard='$username'");
while($row = mysql_fetch_assoc($query))
{
//fetch rows of where user equals bodyguard
$bgstatus = $row['status'];
$bgname = $row['username'];
$id = $row['id'];


if($bgstatus==Pending){
//show all things with accept tool

?>
<form method="post" action="">
<tr>
<td bgcolor="<?php echo "$tabcolor"; ?>">
<font color="#999999">
 <input type="hidden" name="id" value="<?php echo $id; ?>"><a href="viewprofile.php?viewuser=<?php echo $bgname ?>"><font color="#999999"><?php echo $bgname ?></font></a> Invited you to be his BodyGuard</font>
  <input type=submit name=accept value="Accept" class="tbox"><input type=submit name=reject value="Reject" class="tbox">
</td>
</tr>
</form>
<?php

}else{
?>
<tr>
<td bgcolor="<?php echo "$tabcolor"; ?>">
<font color="#999999">
 You are a bodyguard of <a href="viewprofile.php?viewuser=<?php echo $bgname ?>"><font color="#999999"><?php echo $bgname ?></font></a>.</font>
</td>
</tr>
<?php
}//not accepted
}//not invited
}//endloop











//owner of bg spot show management

}else{




$query=mysql_query("SELECT * FROM BG WHERE username='$username' ORDER BY slot ASC");
while($row = mysql_fetch_assoc($query))
{
//fetch rows of where user equals bodyguard
$bgstatus = $row['status'];
$bgname = $row['bodyguard'];
$id = $row['id'];

if($bgstatus==None){
//show all things with accept tool
?>
<form method="post" action="">
<tr>
<td bgcolor="<?php echo "$tabcolor"; ?>">
<font color="#999999">
 <input type="hidden" name="id" value="<?php echo $id; ?>"><input type="text" class="tbox" name="bginame" value="">  <input type="submit" name="invitebg" value="Invite" class="tbox">
</td>
</tr>
</form>
<?php
}else{

if($bgstatus==Pending){
//show all things with accept tool

?>
<form method="post" action="">
<tr>
<td bgcolor="<?php echo "$tabcolor"; ?>">
<font color="#999999">
 <input type="hidden" name="id" value="<?php echo $id; ?>">You invited <a href="viewprofile.php?viewuser=<?php echo $bgname ?>"><font color="#999999"><?php echo $bgname ?></font></a> to be your BodyGuard</font>
  <input type=submit name=deleteinvite value="Cancel Invite" class="tbox">
</td>
</tr>
</form>
<?php

}else{
?>
<form method="post" action="">
<tr>
<td bgcolor="<?php echo "$tabcolor"; ?>">
<font color="#999999">
 <input type="hidden" name="id" value="<?php echo $id; ?>">You have a bodyguard named <a href="viewprofile.php?viewuser=<?php echo $bgname ?>"><font color="#999999"><?php echo $bgname ?></font></a>.</font>
  <input type=submit name=dropbg value="Drop" class="tbox">
</td>
</tr>
</form>
<?php
}//not accepted
}//not invited anyone
}//endloop











}

?>


</table>




</td></tr></table>
</table>





</div>
</td>
<td class=right NOWRAP>
</td>
</tr>
</Tbody>
</table>


<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=bottomleft NOWRAP>
</td>
<td class=bottom NOWRAP>
</td>
<td class=bottomright NOWRAP>
</td>
</tr>
</tbody>
</table>


<?php include"playerstats.php"; ?>
Edited by LearningCoder
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...