Problem sending vars through urls

Lt Llama · September 15, 2006

I have a problem which has to be a php version or some php setting problem.
The links to player stats on this page http://www.euroskillz.eu/skillsrank/index.php works.
The same page here doesnt work: http://www.grumpys.xmgfree.com/phppages/index.php.

If you click a link on a player name it should send the cvars to playerstats.php.
Thats working in the first page but not the second page.

A link looks like this for example:
[url=http://85.25.141.71:81/skillsrank/playerstats.php?steamid=STEAM_0:0:1236155&nickname=Lt+Llama&nfinished=120&totalrank=7605&primaryrank=63]http://85.25.141.71:81/skillsrank/playerstats.php?steamid=STEAM_0:0:1236155&nickname=Lt+Llama&nfinished=120&totalrank=7605&primaryrank=63[/url]

It is identical on the other page but returns an empty page:
http://www.grumpys.xmgfree.com/phppages/playerstats.php?steamid=STEAM_0:1:2211802&nickname=COMBO+RICO&nfinished=1&totalrank=10&primaryrank=10

Playerstats.php which receives this url follows below:

[code=php:0]<?
include("dbinfo.inc.php");
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT `steamId`, `mapName`, `curDate`, `difficulty`, `runTime` FROM `skillmaps` WHERE `steamId` = \"$steamid\" ORDER BY mapName ASC";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo " <center>Player Stats 
$nickname</center> ";
?>

<title>Skillsrank</title>
<head>
<STYLE type="text/css">
BODY {scrollbar-3dlight-color:#2E8B57;
scrollbar-arrow-color:#F4A21B;
scrollbar-base-color:#4D5546;
scrollbar-track-color:#33382E;
scrollbar-darkshadow-color:#000000;
scrollbar-face-color:#4D5546;
scrollbar-highlight-color:#000000;
scrollbar-shadow-color:#404040;}
</STYLE>
</head>

<BODY BGCOLOR="#4D5546" TEXT="#FFFFFF" LINK="#ff9900" VLINK="#ff9900" ALINK="#ff9900" leftmargin=0 rightmargin=0 topmargin=0 bottommargin=0 marginheight=0 marginwidth=0>
<div align="center">
<table border="1" bordercolor="#000000" cellspacing="0" cellpadding="0" width="570" style="border-collapse: collapse">
<tr>
<th align="center" bgcolor="#403F2E"> Finished maps </th>
<th align="center" bgcolor="#403F2E"> Collected points </th>
<th align="center" bgcolor="#403F2E"> Average Difficulty </th>
</tr>
<tr>
<td align="center" bgcolor="#4c4d43"><? echo "$nfinished"; ?></td>
<td align="center" bgcolor="#4C5844"><? echo "$totalrank"; ?></td>
<td align="center" bgcolor="#4c4d43"><? echo "$primaryrank"; ?></td>
</tr>
</table> 

 <center>Finished Maps 
Ordered by Mapname</center> 
<center>
<?
$stats1url="<a href=playerstats.php?steamid=" . $steamid . "&nickname=" . urlencode($nickname) . "&nfinished=" . $nfinished . "&totalrank=" . $totalrank . "&primaryrank=" . $primaryrank . " style=\"text-decoration:none\"> Mapname </a>";
$stats2url="<a href=pstatsdate.php?steamid=" . $steamid . "&nickname=" . urlencode($nickname) . "&nfinished=" . $nfinished . "&totalrank=" . $totalrank . "&primaryrank=" . $primaryrank . " style=\"text-decoration:none\"> Date </a>";
$stats3url="<a href=pstatsdiff.php?steamid=" . $steamid . "&nickname=" . urlencode($nickname) . "&nfinished=" . $nfinished . "&totalrank=" . $totalrank . "&primaryrank=" . $primaryrank . " style=\"text-decoration:none\"> Difficulty </a>";
$stats4url="<a href=pstatsruntime.php?steamid=" . $steamid . "&nickname=" . urlencode($nickname) . "&nfinished=" . $nfinished . "&totalrank=" . $totalrank . "&primaryrank=" . $primaryrank . " style=\"text-decoration:none\"> Runtime </a>";
?>
Sort by <? echo $stats1url; ?> | <? echo $stats2url; ?> | <? echo $stats3url; ?> | <? echo $stats4url; ?>
 </center> 

<div align="center">
<table border="1" bordercolor="#000000" cellspacing="0" cellpadding="0" width="570" style="border-collapse: collapse">
<tr>
<th align="center" bgcolor="#403F2E"> Mapname </th>
<th align="center" bgcolor="#403F2E"> Date </th>
<th align="center" bgcolor="#403F2E"> Difficulty </th>
<th align="center" bgcolor="#403F2E"> Runtime </th>
</tr>

<?
$i=0;
while ($i < $num) {
$mapname=mysql_result($result,$i,"mapName");
$curdate=mysql_result($result,$i,"curDate");
$difficulty=mysql_result($result,$i,"difficulty");
$runtime=mysql_result($result,$i,"runTime");
if ($runtime == 0) {
$formatTime = "00:00:00";
} else {
$hours = ($runtime / 3600) % 24;
if ($hours < 10)
$hours = "0" . $hours;
$minutes = ($runtime / 60) % 60;
if ($minutes < 10)
$minutes = "0" . $minutes;
$seconds = $runtime % 60;
if ($seconds < 10)
$seconds = "0" . $seconds;
$formatTime = $hours . ":" . $minutes . ":" . $seconds;
}
?>
<tr>
<td align="left" bgcolor="#4C5844"><? echo "$mapname"; ?></td>
<td align="center" bgcolor="#4c4d43"><? echo "$curdate"; ?></td>
<td align="center" bgcolor="#4C5844"><? echo "$difficulty"; ?></td>
<td align="center" bgcolor="#4c4d43"><? echo "$formatTime"; ?></td>
</tr>
<?
++$i;
}
echo "</table>";
?>[/code]

Do anyone have any idea why it works in the first page but not the second?

/Lt.

Sign In

Problem sending vars through urls

Recommended Posts

Lt Llama

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information