Senior Member
|
02-22-2012
, 19:30
Re: Achievment Plugin + Webinterface
|
#6
|
Moin. Ok so schaut es jetzt aus. www.renemoerke.de/joschi/ach_alle.php oder www.renemoerke.de/joschi/ach_nur_id.php
der code für alle IDs:
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>
|
Wie bekomme ich die Daten nun in ne schöne HTML Tabelle?
3 Spalten z.B. SteamID Name Puntke (Pnkte ist der letzte ausgelesene Wert) am besten sortiert nach punkten.
Hm....
|
|