Online Highscores Help

**dylan99379** · 11th February 2008, 02:10 AM

Hey everyone.

I'm making a game and trying to have online highscores for it.
i'v been following this tutorial http://www.clickteam.com/eng/resources/online_score/onlinescoreboards.html#setu

I just uploaded a notepad file but instead of saying this

pos name score date submitted
1 tom sweeney 172 2008-2-11 12:31:40

I get this

\n"); $loopindex++; } ?>
pos name score date submitted
$thispos $thisname $thisscore $thisdate

I don't really have any idea what i'm doing and dunno what has gone wrong. I'v checked the coding and it all seems fine, the only difference is i changed buttonscore to highscores.

Help very much appreciated
Dylan

**neat_Kliker2** · 11th February 2008, 06:06 AM

sounds like PHP isn't supported on your server, you could try the VCade remote (on the right)

**dylan99379** · 11th February 2008, 08:00 AM

What do you mean?(sorry not experienced with this html stuff)

It was suggested to use this site in the tutorial, and i have not done any coding in my game that even connects to the highscores yet.

Thanks very much for the reply though neat kliker.
If DavidN could reply i would be very grateful.

**neat_Kliker2** · 11th February 2008, 12:40 PM

PHP www.php.net is not HTML, it is a server side coding program and most free hosts do not support it

**DavidN** · 11th February 2008, 03:52 PM

Hi dylan,

It sounds like NK2 is right here - your webspace doesn't support PHP and is trying to interpret the file as HTML instead. Which host are you using?

Although having said that, I'm surprised that a host would have support for SQL and not PHP to go with it - perhaps the reading of the file type is causing a problem? You say you uploaded a "Notepad file", but that could mean anything - it should end with the extension ".php" to be interpreted correctly.

**neat_Kliker2** · 11th February 2008, 04:48 PM

Originally Posted by DavidN

it should end with the extension ".php" to be interpreted correctly.

Enable file extensions using the Tools > Folder Options > View list, else your not actually seeing file extensions at all

**dylan99379** · 11th February 2008, 08:52 PM

Thanks for the replies!

The host i am using is bytehost.com

I put .php at the end of it. Neat kilker ill try this (Tools > Folder Options > View list) in about 7 hours, goto go to school now = )

Thanks again for the replies and i hope to give more info soon.

**dylan99379** · 12th February 2008, 04:40 AM

Ok back.

Originally Posted by neat_Kliker2

Originally Posted by DavidN

it should end with the extension ".php" to be interpreted correctly.

Enable file extensions using the Tools > Folder Options > View list, else your not actually seeing file extensions at all

Are you talking about on bytehost to change the folder options? I can't find it on the site and it's not in notepad.

I know this is asking allot but here is my code, are there any easy to spot errors?

<html>
<head>
<title>Online Scoreboard Tutorial - Scores</title>
</head>
<body>

<?

$service = "sql112.byethost13.com";
$username = "b13_1564643";
$password = "*******";
$database = "highscores";

mysql_connect($service, $username, $password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "SELECT * FROM highscores";
$result = mysql_query($query);
$num = mysql_numrows($result);

?>

<table>
<tr class="header"><td>Pos</td><td>Name</td><td>Score</td><td>Date Submitted</td></tr>

<?

$loopindex = 0;

while ($loopindex < $num) {

$thisname = mysql_result($result, $loopindex, "name");
$thisscore = mysql_result($result, $loopindex, "combatexperience");
$thisdate = mysql_result($result, $loopindex, "datesubmitted");
$thispos = $loopindex+1;

echo ("<tr><td align=left><p>$thispos</p></td>
<td align=center><p>$thisname</p></td>
<td align=center><p>$thisscore</p></td>
<td align=center><p>$thisdate</p></td></tr>\n");

$loopindex++;
}

?>

</table>
</body>
</html>

Also in my ftp client in the htupload(think it's called that) folder, it says "COM SHOULD BE UPLOADED HERE! file" not sure if this is a problem...

Again i very much appreciate this as it will give my game a new dimension of fun = )

**dylan99379** · 12th February 2008, 04:57 AM

i think i have found a problem. In the FTP client it says that the notepad file i uploaded is:

Dislpayscores.php.txt

Again im really not sure..

**KetchupMaster** · 12th February 2008, 05:04 AM

that would probably be the problem, it needs to just be displayscores.php

What happens now? Our existing forums have been reopened!

User Tag List

Thread: Online Highscores Help

Thread Tools

Search Thread

Online Highscores Help

Re: Online Highscores Help

Re: Online Highscores Help

Re: Online Highscores Help

Re: Online Highscores Help

Re: Online Highscores Help

Re: Online Highscores Help

Re: Online Highscores Help

Re: Online Highscores Help

Re: Online Highscores Help

Similar Threads

online highscores

Online highscores?

Online Highscores - error message

How to do online highscores

Posting Permissions