Hall of Fame

1. Ray_Pas...511,968
2. hielo161,679
3. VanHack...112,234
4. bportlock110,491
5. john-for...102,904
6. leakim971101,755
7. kalmax100,896
8. RQuadling94,639
9. ludofulop75,516
10. theremon70,976
11. angelIII64,382
12. jet-black60,187
13. DrDamnit53,768
14. maduic50,560
15. gr8gonzo47,571
16. zac_char...46,304
17. nahime37,184
18. asafadis36,365
19. logudotcom35,904
20. SleepinDe...32,896
21. hernst4229,828
22. pradyahuja28,400
23. CSecurity27,864
24. tbsgadi27,728
25. steveo22525,532

1. Ray_Pas...3,654,806
2. hernst422,596,625
3. hielo2,559,562
4. Roonaan2,144,811
5. cxr1,483,854
6. angelIII1,393,895
7. TeRReF1,246,909
8. Squinky1,065,477
9. RQuadling1,064,963
10. Diablo841,046,676
11. bportlock868,616
12. glcummins767,295
13. logudotcom717,682
14. steelseth12658,695
15. snoyes_jw600,563
16. yodercm578,319
17. routinet576,560
18. Michael701564,674
19. gamebits537,129
20. Zyloch499,430
21. ddrudik496,821
22. b0lsc0tt482,122
23. nizsmo472,554
24. ldbkutty468,085
25. Batalf452,611

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.8

Help with Mysql and php

Asked by cstallings in PHP Scripting Language

Tags: mysql, table

I am running a gaming server. Here is the link. Now when you look at a pilots profile it will award them medals depending on what they do in the game. I would like to depending on what level they are on have it change to a different medal or add another medal that is different. Here is the link to the site. http://www.aceshigh.ws/run2/stats/index.php
Here is a link to one of the players details page as you can see dependent on a medals txt file that has the different levels he gets the little white ace's http://www.aceshigh.ws/run2/stats/playerdetails.php?id=35 . I would also like if they bomb so many ships get a different kind of medal or something like that. Any ideas would be greatly appreciated. Please let me know what you need and I will gladly get it to you. Thanks.

Here is the code for the player details page.

<?php
/*************************************************
$Id: playerdetails.php,v 1.1 2004/12/16 01:07:50 administrator Exp $
file: playerdetails.php

description: Displayes a players details and stats
**************************************************/

/*
%actionid = (
kia => 1,
crash => 2,
mia => 3,
enemyk => 4,
teamk => 5,
aik => 6,
vulchk => 7,
chutek => 8,
bail => 9,
land => 10,
wing => 11,
controls => 12,
escape => 13,
disconnect => 14
);
*/

// Get set up and under way
require('../config.php');
$image = "images/playerdetails.gif";
$page_title = "FBD Stats - $site_name";
include('./includes/header.inc');
include('./includes/player.inc');

$player = get_player($_REQUEST['id']);

?>

<table width=90% align=center border=0 cellspacing=0 cellpadding=0>
<tr valign=top>
<td width=50%>
<?php

$img = preg_replace("/\s/", "%20", $player['country']);
$img .= ".gif";

echo "<a href='./playerdetails.php?id=".$player['id']."'>".$player['callsign']."</a>   ";

if ($player['country'] != "0") {
 echo "<img src='images/flags/$img'>  ";
}

$cnt = 0;
while ($cnt < $player['medals']) {
 echo " <img border=0 src='./images/medal-kills-1.gif'>";
 $cnt++;
}

?></td>

<td width=50% align=right>Player Details</td>
</tr>
</table>
 

<?php

// Dont do details in list mode
if ($_REQUEST['list'] < 1 || $_REQUEST['list'] > 4) {
print_details($player);

?>

<table width=90% align=center border=0 cellspacing=0 cellpadding=0>
<tr>
<td width=22.5% valign=top align=left colspan=2>Enemy Victories</td>
<td width=22.5% valign=top align=right>Top 10</td>

<td width=10% valign=top align=left> </td>
<td width=22.5% valign=top align=left colspan=2>Enemy Defeats</td>
<td width=22.5% valign=top align=right>Top 10</td>
</tr>
<tr>
<td width=5%></td>
<td width=35% valign=top align=left colspan=2>
  

<div align=center>
<table border=0 cellpadding=2 cellspacing=1 width=100% bgcolor=#333333>
<tr>
<td bgcolor=#000000 valign=top align=left>Callsign</td>
<td bgcolor=#000000 valign=top align=right>Times</td>
</tr>

<?php

}
else {

// ********************************************************
?>

<div align=center>
<table border=0 cellpadding=2 cellspacing=1 width=75% bgcolor=#333333>
<tr>
<td bgcolor=#FFFFFF valign=top align=Center colspan=2>

<?php
if ($_REQUEST['list'] == 1) {
echo "Enemy Victories";
}
else if ($_REQUEST['list'] == 2) {
echo "Enemy Defeats";
}
else if ($_REQUEST['list'] == 3) {
echo "Friendly Victims";
}
else if ($_REQUEST['list'] == 4) {
echo "Friendly Attackers";
}

?>
</td>

</tr>
<tr>
<td bgcolor=#000000 valign=top align=left>Callsign</td>
<td bgcolor=#000000 valign=top align=right>Times</td>
</tr>

<?php

if ($_REQUEST['list'] == 1) {
$query = "SELECT archivestats.callsign, COUNT(*) as count, playerdetails.victimid FROM playerdetails, archivestats WHERE playerdetails.killerid ='" . $_REQUEST['id'] . "' AND playerdetails.victimid = archivestats.id AND playerdetails.typeofactionid='4' GROUP BY playerdetails.victimid ORDER BY count DESC";
}
else if ($_REQUEST['list'] == 2) {
$query = "SELECT archivestats.callsign, COUNT(*) as count, playerdetails.killerid FROM playerdetails, archivestats WHERE playerdetails.victimid='" . $_REQUEST['id'] . "' AND playerdetails.killerid = archivestats.id AND playerdetails.typeofactionid = '4' GROUP BY playerdetails.killerid ORDER BY count DESC";
}
else if ($_REQUEST['list'] == 3) {
$query = "SELECT archivestats.callsign, COUNT(*) as count, playerdetails.victimid FROM playerdetails, archivestats WHERE playerdetails.killerid ='" . $_REQUEST['id'] . "' AND playerdetails.victimid = archivestats.id AND playerdetails.typeofactionid='5' GROUP BY playerdetails.victimid ORDER BY count DESC";
}
else if ($_REQUEST['list'] == 4) {
$query = "SELECT archivestats.callsign, COUNT(*) as count, playerdetails.killerid FROM playerdetails, archivestats WHERE playerdetails.victimid='" . $_REQUEST['id'] . "' AND playerdetails.killerid = archivestats.id AND playerdetails.typeofactionid = '5' GROUP BY playerdetails.killerid ORDER BY count DESC LIMIT 0, 10";
}
$result = @mysql_query($query);
if (!$result) {
print_error("Mysql croaked: " . mysql_error());
}

$bgcolor = "#000000";
while ($row = mysql_fetch_row($result)) {
 if ($bgcolor == "#202020") {
 $bgcolor = "#000000";
 }
 else {
 $bgcolor = "#202020";
}
echo "<tr bgcolor=$bgcolor>
<td align=left valign=top>
<a href='./playerdetails.php?id=$row[2]'>$row[0]</a></td>
<td align=right valign=top>$row[1]</td>
</tr>";
}
mysql_free_result($result);

?>
</table>
</div>
<?php

include('./includes/footer.inc');
exit(0);

// ********************************************************
}

// Top 10 kills
$result = @mysql_query("SELECT archivestats.callsign, COUNT(*) as count, playerdetails.victimid FROM playerdetails, archivestats WHERE playerdetails.killerid ='" . $_REQUEST['id'] . "' AND playerdetails.victimid = archivestats.id AND playerdetails.typeofactionid='4' GROUP BY playerdetails.victimid ORDER BY count DESC LIMIT 0, 10");
if (!$result) {
print_error("Mysql croaked: " . mysql_error());
}

$bgcolor = "#000000";
$cnt = 0;
while ($row = mysql_fetch_row($result)) {
 if ($bgcolor == "#202020") {
 $bgcolor = "#000000";
 }
 else {
 $bgcolor = "#202020";
 }
echo "<tr bgcolor=$bgcolor>
<td align=left valign=top>
<a href='./playerdetails.php?id=$row[2]'>$row[0]</a></td>
<td align=right valign=top>$row[1]</td>
</tr>";
$cnt++;
}
mysql_free_result($result);

if ($cnt == 10) {
echo "</table><table><tr><td align=center valign=top colspan=2>

<a href='./playerdetails.php?id=".$player['id']."&list=1'>Show All</a></td></tr>";
}

?>

</table>
</div>
</td>
<td width=10%>  
</td>
<td width=5% valign=top align=left>

</td>
<td width=35% valign=top align=left colspan=2>
  
<div align=center>
<center>
<table border=0 cellpadding=2 cellspacing=1 width=100% bgcolor=#333333>
<tr>
<td width=50% bgcolor=#000000 valign=top align=left>Callsign</td>

<td width=50% bgcolor=#000000 valign=top align=right>Times</td>
</tr>
<?php

// Top 10 killed by's
$result = @mysql_query("SELECT archivestats.callsign, COUNT(*) as count, playerdetails.killerid FROM playerdetails, archivestats WHERE playerdetails.victimid='" . $_REQUEST['id'] . "' AND playerdetails.killerid = archivestats.id AND playerdetails.typeofactionid = '4' GROUP BY playerdetails.killerid ORDER BY count DESC LIMIT 0, 10");
if (!$result) {
print_error("Mysql croaked: " . mysql_error());
}

$bgcolor="#000000";
$cnt = 0;
while ($row = mysql_fetch_row($result)) {
 if ($bgcolor == "#202020") {
 $bgcolor = "#000000";
 }
 else {
 $bgcolor = "#202020";
}
echo "<tr bgcolor=$bgcolor>
<td align=left valign=top>
<a href='./playerdetails.php?id=$row[2]'>$row[0]</a></td>
<td align=right valign=top>$row[1]</td>
</tr>";
$cnt++;
}
mysql_free_result($result);

if ($cnt == 10) {
echo "</table><table><tr><td align=center valign=top colspan=2>

<a href='./playerdetails.php?id=".$player['id']."&list=2'>Show All</a></td></tr>";
}
?>
</table>
</center>
</div>
</td>
</tr>
</table>

 

<table width=90% align=center border=0 cellspacing=0 cellpadding=0>
<tr>
<td width=22.5% valign=top align=left colspan=2>Friendly Victims</td>
<td width=22.5% valign=top align=right>Top 10</td>
<td width=10% valign=top align=left> </td>
<td width=22.5% valign=top align=left colspan=2>Friendly Attackers</td>
<td width=22.5% valign=top align=right>Top 10</td>

</tr>
<tr>
<td width=5%></td>
<td width=35% valign=top align=left colspan=2>
  
<div align=center>
<table border=0 cellpadding=2 cellspacing=1 width=100% bgcolor=#333333>
<tr>
<td bgcolor=#000000 valign=top align=left>Callsign</td>

<td bgcolor=#000000 valign=top align=right>Times</td>
</tr>

<?php

// Top 10 TK's
$result = @mysql_query("SELECT archivestats.callsign, COUNT(*) as count, playerdetails.victimid FROM playerdetails, archivestats WHERE playerdetails.killerid ='" . $_REQUEST['id'] . "' AND playerdetails.victimid = archivestats.id AND playerdetails.typeofactionid='5' GROUP BY playerdetails.victimid ORDER BY count DESC LIMIT 0, 25");
if (!$result) {
print_error("Mysql croaked: " . mysql_error());
}

$bgcolor="#000000";
$cnt = 0;
while ($row = mysql_fetch_row($result)) {
 if ($bgcolor == "#202020") {
 $bgcolor = "#000000";
 }
 else {
 $bgcolor = "#202020";
}
echo "<tr bgcolor=$bgcolor>
<td align=left valign=top>
<a href='./playerdetails.php?id=$row[2]'>$row[0]</a></td>
<td align=right valign=top>$row[1]</td>
</tr>";
$cnt++;
}
mysql_free_result($result);

if ($cnt == 10) {
echo "</table><table><tr><td align=center valign=top colspan=2>

<a href='./playerdetails.php?id=".$player['id']."&list=3'>Show All</a></td></tr>";
}
?>

</table>
</div>
</td>
<td width=10%>  
</td>
<td width=5% valign=top align=left>

</td>
<td width=35% valign=top align=left colspan=2>
  
<div align=center>
<center>
<table border=0 cellpadding=2 cellspacing=1 width=100% bgcolor=#333333>
<tr>
<td width=50% bgcolor=#000000 valign=top align=left>Callsign</td>

<td width=50% bgcolor=#000000 valign=top align=right>Times</td>
</tr>
<?php

// Top 10 TK'ed by
$result = @mysql_query("SELECT archivestats.callsign, COUNT(*) as count, playerdetails.killerid FROM playerdetails, archivestats WHERE playerdetails.victimid='" . $_REQUEST['id'] . "' AND playerdetails.killerid = archivestats.id AND playerdetails.typeofactionid = '5' GROUP BY playerdetails.killerid ORDER BY count DESC LIMIT 0, 10");
if (!$result) {
print_error("Mysql croaked: " . mysql_error());
}

$bgcolor="#000000";
$cnt = 0;
while ($row = mysql_fetch_row($result)) {
 if ($bgcolor == "#202020") {
 $bgcolor = "#000000";
 }
 else {
 $bgcolor = "#202020";
}
echo "<tr bgcolor=$bgcolor>
<td align=left valign=top>
<a href='./playerdetails.php?id=$row[2]'>$row[0]</a></td>
<td align=right valign=top>$row[1]</td>
</tr>";
$cnt++;
}
mysql_free_result($result);

if ($cnt == 10) {
echo "</table><table><tr><td align=center valign=top colspan=2>

<a href='./playerdetails.php?id=".$player['id']."&list=4'>Show All</a></td></tr>";
}
?>

</table>
</center>
</div>
</td>
</tr>
</table>


 

<table width=90% align=center border=0 cellspacing=0 cellpadding=0>
<tr>
<td valign=top align=left>Last 25 Sorties Flown  </td>
</tr>

</table>
<table border=0 align=center cellpadding=2 cellspacing=1 width=85% bgcolor=#333333>
<tr>
<td bgcolor=#FFFFFF valign=top align=center><a href='playerdetails.php?id=<?php echo $_REQUEST['id']; ?>&sort=1'>MISSION</a></td>
<td bgcolor=#FFFFFF valign=top align=center><a href='playerdetails.php?id=<?php echo $_REQUEST['id']; ?>'>START TIME</a></td>
<td bgcolor=#FFFFFF valign=top align=center><a href='playerdetails.php?id=<?php echo $_REQUEST['id']; ?>&sort=2'>ARMY</a></td>
<td bgcolor=#FFFFFF valign=top align=center><a href='playerdetails.php?id=<?php echo $_REQUEST['id']; ?>&sort=3'>PLANE</a></td>
<td bgcolor=#FFFFFF valign=top align=center><a href='playerdetails.php?id=<?php echo $_REQUEST['id']; ?>&sort=4'>SCORE</a></td>
<td bgcolor=#FFFFFF valign=top align=center><a href='playerdetails.php?id=<?php echo $_REQUEST['id']; ?>&sort=5'>AIRCRAFT KILLS</a></td>
<td bgcolor=#FFFFFF valign=top align=center><a href='playerdetails.php?id=<?php echo $_REQUEST['id']; ?>&sort=6'>GROUND KILLS</a></td>
<td bgcolor=#FFFFFF valign=top align=center> SORTIE </td> </tr>

<?php

$query = "SELECT
missionid.missionname ,
missionstats.id as sid,
archivestats.callsign,
sortiestats.*,
aircraftid.aircraft,
(eAir + eSAir) AS airkills,
(eTank + eCar + eArt + eAaa + eWag + eShip) as groundkills,
(fAir + fSAir + fTank + fCar + fArt + fAaa + fWag + fShip) as friendlykills
FROM
sortiestats,
archivestats,
missionstats,
missionid,
aircraftid
WHERE
sortiestats.playerid = ".$_REQUEST['id']."
AND archivestats.id = sortiestats.playerid
AND missionstats.starttime = sortiestats.missionstarttime
AND missionid.id = missionstats.missionid
AND aircraftid.id = sortiestats.plane
ORDER BY ";

if ($_REQUEST['sort'] == 1) {
$query .= "missionid.missionname, sortieid DESC";
}
elseif ($_REQUEST['sort'] == 2) {
$query .= "army, sortieid DESC";
}
elseif ($_REQUEST['sort'] == 3) {
$query .= "aircraft, sortieid DESC";
}
elseif ($_REQUEST['sort'] == 4) {
$query .= "score DESC, sortieid DESC";
}
elseif ($_REQUEST['sort'] == 5) {
$query .= "airkills DESC, sortieid DESC";
}
elseif ($_REQUEST['sort'] == 6) {
$query .= "groundkills DESC, sortieid DESC";
}
else {
$query .= "sortieid DESC";
}

$query .= " LIMIT 0, 25";

$result = @mysql_query($query);

//MissionID stored in $row[0]
$bgcolor = "#000000";
if ($result) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$bgcolor = $bgcolor == "#202020" ? "#000000" : "#020202";
$army = $row['army'] == 1 ? "Blue" : "Red";
$plink = "<a href='missiondetails.php?id=".$row['sid']."'>".$row['missionname']."</a>";
$slink = "<a href='sortiedetails.php?id=".$row['sortieid']."&playerid=".$row['playerid']."'>[SORTIE]</a>";
echo "
<tr>
<td bgcolor=$bgcolor valign=top align=left>$plink</td>
<td bgcolor=$bgcolor valign=top align=left>" . strftime("%b %d - %I:%M %p", $row['sortieid']) . "</td>
<td bgcolor=$bgcolor valign=top align=left>$army</td>
<td bgcolor=$bgcolor valign=top align=left>".$row['aircraft']."</td>
<td bgcolor=$bgcolor valign=top align=right>".$row['score']."</td>
<td bgcolor=$bgcolor valign=top align=right>".$row['airkills']."</td>
<td bgcolor=$bgcolor valign=top align=right>".$row['groundkills']."</td>
<td bgcolor=$bgcolor valign=top align=center>$slink</td>
</tr> \n";

}
mysql_free_result($result);
}
else {
print_error("Mysql croaked: " . mysql_error());
}

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

 

<?php
include('./includes/footer.inc');

// ***************************************************************************************************************************
// ***************************************************************************************************************************
// print details
// ***************************************************************************************************************************
// ***************************************************************************************************************************
function print_details ($player) {
?>

<table width=90% align=center border=0 cellspacing=0 cellpadding=0>
<tr>
<td width=22.5% valign=top align=left colspan=2>Information</td>
<td width=22.5% valign=top align=right> </td>
<td width=10% valign=top align=left> </td>

<td width=22.5% valign=top align=left colspan=2>Statistics</td>
<td width=22.5% valign=top align=right> </td>
</tr>
<tr>
<td width=5%></td>
<td width=35% valign=top align=left colspan=2>
  
<div align=center>

<table border=0 cellpadding=2 cellspacing=1 width=100% bgcolor=#333333>
<tr><td align=left valign=top bgcolor=#000000>Stats ID</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['id']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Country</td>
<td align=right valign=top bgcolor=#000000><?php
 if ($player['country'] != "0") { echo $player['country']; }
 else { echo "Unknown"; }
 echo "</td>"; ?>
</tr>

<tr><td align=left valign=top bgcolor=#000000>Last Sighting</td>
<td align=right valign=top bgcolor=#000000><?php echo date("F jS Y h:i A", $player['currenttime']); ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Total Time Played</td>
<td align=right valign=top bgcolor=#000000><?php echo number_format($player['totaltimeplayed']/3600, 1, ".", "") ?> hours</td>
</tr>

</table>
</div>
 
<div align=center>
<table border=0 cellpadding=2 cellspacing=1 width=100% bgcolor=#333333>
<tr><td align=left valign=top bgcolor=#000000>K/D Ratio</td>
<td align=right valign=top bgcolor=#000000>
<?php

// K/D ratio
if ($player['deaths'] != 0) {
echo number_format(($player['enemyaircraftkills'] / $player['deaths']), 1, ".", "");
}
else {
echo $player['enemyaircraftkills'] . ".0";
}

?>
</td>
</tr>

<tr><td align=left valign=top bgcolor=#000000>Hit %</td>
<td align=right valign=top bgcolor=#000000>

<?php

// Hit %
if ($player['firedbullets']) {
echo number_format((($player['hitbullets'] / $player['firedbullets']) * 100), 1, ".", "");
}
else {
echo "0.0";
}

?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Hit Air %</td>
<td align=right valign=top bgcolor=#000000>

<?php

// Hit air %
if ($player['firedbullets']) {
echo number_format((($player['hitairbullets'] / $player['firedbullets']) * 100), 1, ".", "");
}
else {
echo "0.0";
}

?></td>
</tr>

</table>
</div>
 
<div align=center>
<table border=0 cellpadding=2 cellspacing=1 width=100% bgcolor=#333333>
<tr><td bgcolor=#000000 valign=top align=left>Aircraft Flown</td>
<td bgcolor=#000000 valign=top align=right>Top 10</td>
</tr>

<?php

// Top 10 Aircraft
$result = @mysql_query("SELECT aircraftid.aircraft, aircraftstats.count, aircraftid.id FROM aircraftid, aircraftstats WHERE playerid ='" . $_REQUEST['id'] . "' AND aircraftid.id=aircraftstats.aircraft ORDER BY count DESC LIMIT 0, 10");
if (!$result) {
print_error("Mysql croaked: " . mysql_error());
}

$bgcolor = "#000000";
$cnt = 0;
while ($row = mysql_fetch_row($result)) {
 if ($bgcolor == "#202020") {
 $bgcolor = "#000000";
 }
 else {
 $bgcolor = "#202020";
}
echo "<tr bgcolor=$bgcolor>
<td align=left valign=top><a href='aircraftdetails.php?id=$row[2]'>
$row[0]</a></td>
<td align=right valign=top>$row[1]</td>
</tr>";
$cnt++;
}
mysql_free_result($result);

//if ($cnt == 10) {
// echo "</table><table><tr><td align=center valign=top colspan=2>
// 
// <a href='./playerdetails.php?id=".$player['id']."&list=3'>Show All</a></td></tr>";
//}
?>

</table>
</div> 
</td>
<td width=10%>  
</td>

<td width=5% valign=top align=left>
</td>
<td width=35% valign=top align=left colspan=2>
  
<div align=center>
<center>
<table border=0 cellpadding=2 cellspacing=1 width=100% bgcolor=#333333>

<tr><td align=left valign=top bgcolor=#000000>Enemy Aircraft Kills</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['enemyaircraftkills']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Killed In Action</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['deaths']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Friendly Aircraft Kills</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['friendlyaircraftkills']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Killed By Friendly Aircraft</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['tdeaths']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Enemy Static Aircraft Kills</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['enemystaticaircraftkills']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Friendly Static Aircraft Kills</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['friendlystaticaircraftkills']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Tanks Destroyed</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['enemytankkills']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Vehicles Destroyed</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['enemycarkills']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Artillery Destroyed</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['enemyartillerykills']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>AAA Destroyed</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['enemyaaakills']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Train Cars Destroyed</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['enemywagonkills']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Ships Sunk</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['enemyshipkills']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Fired Bullets</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['firedbullets']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Hit Bullets</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['hitbullets']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Hit Air Bullets</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['hitairbullets']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Fired Rockets</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['firedrockets']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Direct Hit Rockets</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['hitrockets']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Dropped Bombs</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['droppedbombs']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Landed Safely</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['landings']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Crashed</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['crashes']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Bailed Out</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['bails']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Missing in Action</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['miadeaths']; ?></td>
</tr>
<tr><td align=left valign=top bgcolor=#000000>Escaped From Enemy</td>
<td align=right valign=top bgcolor=#000000><?php echo $player['escapes']; ?></td>
</tr>

</table>
</center>

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

<?php

} // End of player_details
?>

Here is the TXT file for the award levels:
LevelOne=5
LevelTwo=20
LevelThree=50
LevelFour=100
LevelFive=200

View the Solution FREE for 30 Days

20100204-EE-VQP-115

Help with Mysql and php

Asked by cstallings in PHP Scripting Language

Tags: mysql, table

About this solution