Senior Member
|
02-23-2012
, 08:42
Re: Achievements
|
#131
|
got the output working with this code:
See here: http://www.renemoerke.de/joschi/ach_alle.php
Quote:
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
</head>
<body>
<?php
$host = "meinDBServer";
$user = "derUser";
$pass = "meinPW";
$dbase = "DB";
$db = mysql_connect($host, $user, $pass) or die ("verbindung fehlgeschlagen");
mysql_select_db($dbase, $db) or die ("verbindung zur datenbank fehlgeschlagen");
$Waffen = array("p228",
"scout",
"hegrenade",
"xm1014",
"c4",
"mac10",
"aug",
"smokegrenade",
"elite",
"fiveseven",
"ump45",
"sg550",
"galil",
"famas",
"usp",
"glock18",
"awp",
"mp5navy",
"m249",
"m3",
"m4a1",
"tmp",
"g3sg1",
"flashbang",
"deagle",
"sg552",
"ak47",
"knife",
"p90");
$Erfolge = array("Ultimate Server Lover",
"Boom Head-Shot",
"Distance Killed",
"Distance Walked",
"OMFG that was close",
"Short Fuse",
"Boomala Boomala",
"Nothing Can Blow Up",
"God of War",
"Pistol Master",
"Rifle Master",
"Shotgun Master",
"Spray and Pray",
"Master At Arms",
"Play Around",
"Stand Alone",
"1 Hp Hero",
"Bad Friend",
"Urban Designer",
"Graffiti Is My Second Name",
"Ammo Conservation",
"Fly Away",
"Reloader",
"Camp Fire",
"Hat Trick",
"Cowboy Diplomacy",
"You've Made Your Points");
$query = "select * from Achievement";
$result = mysql_query($query,$db);
while ($row = mysql_fetch_array($result)) {
echo $row['name'];
echo '<br>';
echo $row['authid'];
echo '<br>';
$test = explode (" ", $row['data']);
$i = 1;
foreach($Waffen as $v)
{
echo $v.": ".$test [$i]." Kills<br />";
$i++;
}
$j = 0;
foreach($Erfolge as $v)
{
echo $v." - Level: ".$test [$i+$j]."<br />";
$j++;
}
}
?>
</body>
</html>
|
How to make a good looking table to implement the data? anyone an Idea how it should/could look?
regards
Amokossi
|
|