I've normally done my online highscore system with ActiveX object and some PHP, but since ActiveX isn't vitalized, I have no clue how to code an online highscores for my vitalize game. Could someone explain/help me?
Sorry, I don't have the answers for you. But I'm very annoyed at this question. Not at Raverider for asking it, but at the people that never answer it.
Online high-scores have been around since the birth of click products and it seems that that only people that have learnt PHP or MySQL (whatever that is), know how to do it.
I've been trying to figure out how to make online highscores for ages now and have found no help what-so-ever. Apart from a very complicated tutorial by DavidN which took me hours to complete, only to find out that it doesn't work anymore because the server he speaks of doesn't allow online highscores anymore.
I'm the kind of person that doesn't know a thing about PHP or hosts (unless it's html and even then I just upload thing), or coding for that matter, hence the reason I use clickteam products, and I still can't find a baby tutorial for people like me to make a simple online highscore table.
If there is anyone one out there that has to time to explain how to do such a thing, please let us know.
Some knowledge of webservers and/or php is a sure requirement if you are aiming to do this kind of thing. Why you ask? If you want to display highscores they have to be stored somewhere. So not only do you need some method for storing these scores, you also need some method for retrieving these scores. This is generally implemented using PHP code (php because it's installed on most webservers) and the scores are stored/retrieved from a MySQL database. If you have webspace, you should see if you have php installed and a mysql server available if you really want to implement your very own online score board. I can code a site where clickers can create a custom online scoreboard for their games with the addition of the ingame code to compliment it if you think this is an adequate solution? If the question is how do you do it then I am sure I have provided at least the starting to an answer, but seeing as you mentioned implementing a php version with activex, I think the alternative is to use moosock? (I can't say I have ever done it before).
So I guess all I need to know is if a premade solution is what you are after? I think it's useful to experiment with php yourself, but it's no fun when some newbie coder tries to make their online scoreboard and it is hacked in seconds due to lack of experience.
when i did online score tables i used php or asp. i think asp. and moosock to send it to a data file where the asp retrieved the scores and names from. i dont have any of that at my disposal anymore and i forgot how
n/a
Peblo Custom ratings must be 50 characters or less
Registered 05/07/2002
Points 185
20th January, 2008 at 02:10:14 -
Usually I try to help people in the code-it forum but this really isn't my expertise. Here's a link that could help...
So I guess all I need to know is if a premade solution is what you are after?
I'm not absolutely sure what you mean, but I'm just trying to get an online high-score table for my game. And I have own webspace with PHP and MySQL, but I'm pretty noob with those. I also forgot to mention, that the PHP-script what I used before was a premade one that someone gave to public use, so I'm not quite sure should I alter it much, I might crash a server or something. I'll try to work with moosock and that script.
It's an excellent tutorial which tells you step-by-step how to implement online highscores into your MMF game by using php/sql/moosock.
Trying this at the moment, got to a certain point but it won't work.
The part in the tutorial after setting up all the sql / php stuff and it tells you to view the displayscores.php for the first time I get the error of.
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'jason'@'74.52.103.50' (using password: YES) in /home/jsofts/public_html/displayscores.php on line 14
Unable to select database
this must be somthing to do with what i've entered in this part:
Name the four fields so that you have some idea of what we're going to do with them - from top to bottom, enter the names id, name, score, anddateuploaded
then it says,
Setdatesubmittedto a "TIMESTAMP", and check CURRENT_TIMESTAMP
I tried that but it still doesn't work. I get this message when I submit a score in my game:
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"><html><head><title>302 Found</title></head><body><h1>Found</h1><p>The document has moved <a href="http://google.com">here</a>.</p></body></html>
I think that's the problem with the tutorial. Anyone know how to fix this???
It's an excellent tutorial which tells you step-by-step how to implement online highscores into your MMF game by using php/sql/moosock.
Trying this at the moment, got to a certain point but it won't work.
The part in the tutorial after setting up all the sql / php stuff and it tells you to view the displayscores.php for the first time I get the error of.
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'jason'@'74.52.103.50' (using password: YES) in /home/jsofts/public_html/displayscores.php on line 14
Unable to select database
this must be somthing to do with what i've entered in this part:
my sites jsofts.com and my main database is jsofts, I then made a new database called tmnt so it was then jsofts_tmnt
What i'm confused about is what username and password? for jsofts.com admin panel? or for the user account I added to the tmnt database?
thats the tutorial i think i learned from. i never could get it to ONLY desplay the top 10. how did you do that part? that would be really helpful in the future.
Originally Posted by Edwin Street Shit! That looks great.
What server did you use? Byethost.com by any chance?
I used my own server jsofts.com which has mySQL.
Originally Posted by cec¿l
thats the tutorial i think i learned from. i never could get it to ONLY desplay the top 10. how did you do that part? that would be really helpful in the future.?
In game I could only get it to list 10 (which is great, thats all I wanted) but on the list online it shows all. I just followed the tutorial and that show it ended up.
That should show only the highest score. But it still has the same loading time because it reads more rows than just one. If you want to reduce the loading time (so that only the highest score is loaded), edit the returnscores.php to something like this:
Which is great and all but byethost doesn't support things coming in from games so that's no use.
Why don't the first two links work? They're exactly the same file, just different MySQL host.
Edited by the Author.
theonecardgame.com
DaVince This fool just HAD to have a custom rating
Registered 04/09/2004
Points 7998
21st January, 2008 at 19:07:53 -
PHP pages are run server-sided, and Sitesled does not provide the PHP service. That's why PHP pages won't work on Sitesled.
Byethost SHOULD be able to fetch your game's data and put it into the database... after all, once you logged into the MySQL database correctly you can fetch and insert any data into the database you like. Well, if your roles are set up correctly, anyway.
I've looked around the freemysql.net site and can't find anywhere to upload the displayscores.php and submitscore.php files. Is it possible to upload them to another php server and have it link back to the database and freemysql.net?
I've looked around the freemysql.net site and can't find anywhere to upload the displayscores.php and submitscore.php files. Is it possible to upload them to another php server and have it link back to the database and freemysql.net?
If so, what's a good php server to upload them to?
theonecardgame.com
DaVince This fool just HAD to have a custom rating
Advertisement
Post Reply
Edited by the Author.
I'll try to work with moosock and that script.
.png)
