Codezwiz >> Forums >> General PHP Nuke Help >> Alittle prob

Hi guys, i didn;t notice a forum for normal php scripting so please accept my apologies if this is the wrong forum as this is a NON NUKE question.

i have babstats which is a stats tracker for an online game called delta force, it tracks various stats like kills, deaths, knife kills, ect (a vast amount). It's a php program that uses mysql to store all the data in different tables. I am trying build a top 10 list with the players names and the amount of murders they have had listed from top to bottom, the player with the most murders at the top (using murders as an example) everything is working fine except one thing..........the script does the list as it should with the players name being a link to there stats within babstats, but the name appears as it does in the database which is some sort of coding...........i require the name to display the players name. i am trying to pull data from 2 tables, 1 has the players name and id and the other has various stats, the only relation to link the 2 tables is the player id.

you can see the script in action at this link: [ Register or login to view links on this board. ]

and heres the script:

<?php

// Database settings
$dbhost = "localhost"; // Database host
$dbname = "******"; // Database name
$dbusername = "******"; // Database user name
$dbuserpw = "******"; // Database password

$link_id = mysql_connect($dbhost,$dbusername,$dbuserpw)
or die("Could not connect to MySQL.");
//echo("Connection Successfull.<br>");
$selected = mysql_select_db($dbname,$link_id)
or die("Could not select database");
//echo("Selection Successfull.");

$statURL = "/stats/"; // Please include the trailing slash /
$result = mysql_query("SELECT player, murders FROM chronos_stats WHERE 1 ORDER BY `murders` DESC LIMIT 0, 10");
while ($a_row = mysql_fetch_row($result ) ) {
$resultR2 = mysql_query("SELECT name, id, rating FROM `chronos_players`where id =$a_row[0]" );
while ($a_rowR2 = mysql_fetch_row($resultR2 ) ) {
$tnrn = $a_row[1] ;
$tnn = $a_rowR2[0] ;
}
$PlayerName = htmlspecialchars(base64_decode($a_rowR2[0]));
print "<table width=140>";
print "<tr>";
print "<td>";
$outputstat = "<a href=".$statURL."index.php?action=player_stats&id=".$a_row[0].">".$PlayerName."</td><td>$tnn $tnrn</td>";
print "</table>";
print $outputstat;
}
?>

" which is some sort of coding " What are you reffering to is it a function to scramble the name? What does the name look like in the database? Can you post the function that sets the player name in the database?

thanks for the reply Telli,

what i mean is that the actual name for instance is "TDO DEMON" on the stats page, but in the database it is "VERPIERFTU9O"

if i just pull the names from the table on there own, i can list the names with this query "$PlayerName = htmlspecialchars(base64_decode( )); " changing the name from whats in the database to whats in the stats page. But for some reason, when i have the names pulled on the second query of the code above, that query doesn't do that. I have to have the table with the names as the second query due to sorting by most murders.

if it's any help, i can post a pic of both tables i'm pulling the data from?

thanks again.

$tnn = $a_rowR2[0] ;
}
$PlayerName = htmlspecialchars(base64_decode($a_rowR2[0]));
print "<table width=140>";
print "<tr>";
print "<td>";
$outputstat = "<a href=".$statURL."index.php?action=player_stats&id=".$a_row[0].">".$PlayerName."</td><td>$tnn $tnrn</td>";

i got rid of the $tnn altogether and now it works, thanks Telli................i would never have got it, if you didn't mention that.

it's great to see someone taking the time to help us Newbies with there knowledge.
once again, many thanks

best regards
Azrael