The Daily Click ::. Forums ::. Klik Coding Help ::. Internet highscores w/ Vitalize 4
 

Post Reply  Post Oekaki 
 

Posted By Message

Raverider



Registered
  10/09/2007
Points
  126

Has Donated, Thank You!
19th January, 2008 at 12:29:54 -

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?

 
http://loopsoft.dy.fi

eyeangle



Registered
  12/06/2003
Points
  1683
19th January, 2008 at 22:55:52 -

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.

 
theonecardgame.com

~Matt Esch~

Stone Goose

Registered
  30/12/2006
Points
  870

VIP Member
20th January, 2008 at 01:19:37 -

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.

Image Edited by the Author.

 
http://create-games.com/project.asp?id=1875 Image


Cecilectomy

noPE

Registered
  19/03/2005
Points
  305

Has Donated, Thank You!VIP MemberWeekly Picture Me This Winner!Cardboard BoxGhostbuster!Pokemon Ball!ComputerBox RedSanta HatSnowman
I am an April Fool
20th January, 2008 at 01:47:41 -

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

Game of the Week WinnerVIP MemberI'm on a Boat360 OwnerAttention GetterThe Cake is a LieCardboard BoxHero of TimePS3 OwnerIt's-a me, Mario!
I'm a Storm TrooperSonic SpeedStrawberryI like Aliens!Wii OwnerMushroomGhostbuster!
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...

http://create-games.com/article.asp?id=1591
http://create-games.com/article.asp?id=1592
http://create-games.com/article.asp?id=1609

Image Edited by the Author.

 
"Isn't it always amazing how we characterize a person's intelligence by how closely their thinking matches ours?"
~Belgarath

Raverider



Registered
  10/09/2007
Points
  126

Has Donated, Thank You!
20th January, 2008 at 07:21:35 -


Originally Posted by ~Matt Esch~

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.

And thanks Peblo, those were some useful links.

Image Edited by the Author.

 
http://loopsoft.dy.fi

MJK

Possibly Insane

Registered
  22/03/2006
Points
  3592

Game Of The Week Cup 1Game Of The Week Cup 2Game Of The Week Cup 3Game Of The Week Cup 4Game Of The Week Cup 5Game Of The Week Cup 6
20th January, 2008 at 12:45:54 -

Have you already checked out this: http://www.clickteam.com/eng/resources/online_score/onlinescoreboards.html

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.

 
n/a

Jason Orme

Using Klik Products Since 1998

Registered
  24/05/2002
Points
  960

VIP Member360 OwnerWii OwnerAttention GetterThe Cake is a LieCardboard BoxHero of TimeI'm a Storm TrooperI'm on a BoatIt's-a me, Mario!
Sonic SpeedMushroomStrawberryI like Aliens!PS3 OwnerTurtle Power!I am an April Fool
20th January, 2008 at 15:49:56 -


Originally Posted by MJK
Have you already checked out this: http://www.clickteam.com/eng/resources/online_score/onlinescoreboards.html

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:

$service = "yourservice";
$username = "yourusername";
$password = "yourpassword";
$database = "yourdatabase";


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?



 
www.jsofts.com

Jason Orme

Using Klik Products Since 1998

Registered
  24/05/2002
Points
  960

VIP Member360 OwnerWii OwnerAttention GetterThe Cake is a LieCardboard BoxHero of TimeI'm a Storm TrooperI'm on a BoatIt's-a me, Mario!
Sonic SpeedMushroomStrawberryI like Aliens!PS3 OwnerTurtle Power!I am an April Fool
20th January, 2008 at 20:27:10 -

Okay, found the error its within the tutorial.

it says

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, and dateuploaded

then it says,

Set datesubmitted to a "TIMESTAMP", and check CURRENT_TIMESTAMP

Works now i've changed both to datesubmitted

 
www.jsofts.com

eyeangle



Registered
  12/06/2003
Points
  1683
20th January, 2008 at 23:15:48 -

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???

 
theonecardgame.com

Jason Orme

Using Klik Products Since 1998

Registered
  24/05/2002
Points
  960

VIP Member360 OwnerWii OwnerAttention GetterThe Cake is a LieCardboard BoxHero of TimeI'm a Storm TrooperI'm on a BoatIt's-a me, Mario!
Sonic SpeedMushroomStrawberryI like Aliens!PS3 OwnerTurtle Power!I am an April Fool
21st January, 2008 at 00:58:57 -

Looks like you havn't put your site address into it as its returning to google.

I've got my online high score system working, had alittle help from the Mrs (shes a wizz at html/php etc).

http://www.jsofts.com/displayscores.php

Image

Image Edited by the Author.

 
www.jsofts.com

eyeangle



Registered
  12/06/2003
Points
  1683
21st January, 2008 at 01:34:00 -

Shit! That looks great.

What server did you use? Byethost.com by any chance?

 
theonecardgame.com

eyeangle



Registered
  12/06/2003
Points
  1683
21st January, 2008 at 01:34:17 -

How do I fix this error?

Image Edited by the Author.

 
theonecardgame.com

Cecilectomy

noPE

Registered
  19/03/2005
Points
  305

Has Donated, Thank You!VIP MemberWeekly Picture Me This Winner!Cardboard BoxGhostbuster!Pokemon Ball!ComputerBox RedSanta HatSnowman
I am an April Fool
21st January, 2008 at 01:37:55 -


Originally Posted by Jason Orme

Originally Posted by MJK
Have you already checked out this: http://www.clickteam.com/eng/resources/online_score/onlinescoreboards.html

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:

$service = "yourservice";
$username = "yourusername";
$password = "yourpassword";
$database = "yourdatabase";


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.

 
n/a

Jason Orme

Using Klik Products Since 1998

Registered
  24/05/2002
Points
  960

VIP Member360 OwnerWii OwnerAttention GetterThe Cake is a LieCardboard BoxHero of TimeI'm a Storm TrooperI'm on a BoatIt's-a me, Mario!
Sonic SpeedMushroomStrawberryI like Aliens!PS3 OwnerTurtle Power!I am an April Fool
21st January, 2008 at 01:42:33 -


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.

See http://www.jsofts.com/displayscores.php

I'd like to know how to just show 1 up though.



Image Edited by the Author.

Image Edited by the Author.

 
www.jsofts.com

MJK

Possibly Insane

Registered
  22/03/2006
Points
  3592

Game Of The Week Cup 1Game Of The Week Cup 2Game Of The Week Cup 3Game Of The Week Cup 4Game Of The Week Cup 5Game Of The Week Cup 6
21st January, 2008 at 08:15:36 -

"I'd like to know how to just show 1 up though."

Jason, you can try to limit the while() loop in the php file to
while ($loopindex = 1)


Then the loop should stop listing the scores after it has exceeded the row no. 1 in your sql database.

 
n/a

Jason Orme

Using Klik Products Since 1998

Registered
  24/05/2002
Points
  960

VIP Member360 OwnerWii OwnerAttention GetterThe Cake is a LieCardboard BoxHero of TimeI'm a Storm TrooperI'm on a BoatIt's-a me, Mario!
Sonic SpeedMushroomStrawberryI like Aliens!PS3 OwnerTurtle Power!I am an April Fool
21st January, 2008 at 08:21:06 -

How could I just show 1 in game?

 
www.jsofts.com

MJK

Possibly Insane

Registered
  22/03/2006
Points
  3592

Game Of The Week Cup 1Game Of The Week Cup 2Game Of The Week Cup 3Game Of The Week Cup 4Game Of The Week Cup 5Game Of The Week Cup 6
21st January, 2008 at 11:39:14 -

In your highscore board frame:

Start loop "displayscores" 1 times

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:

while ($loopindex = 1)
(or 2)

 
n/a

Jason Orme

Using Klik Products Since 1998

Registered
  24/05/2002
Points
  960

VIP Member360 OwnerWii OwnerAttention GetterThe Cake is a LieCardboard BoxHero of TimeI'm a Storm TrooperI'm on a BoatIt's-a me, Mario!
Sonic SpeedMushroomStrawberryI like Aliens!PS3 OwnerTurtle Power!I am an April Fool
21st January, 2008 at 12:26:01 -

fantastic, thanks.

 
www.jsofts.com

Knudde (Shab)

Administrator
Crazy?

Registered
  31/01/2003
Points
  5125

Has Donated, Thank You!Clickzine StaffKlikCast StarVIP MemberGhostbuster!Dos Rules!I donated an open source project
21st January, 2008 at 12:35:06 -

Flava's pretty good with that online high score stuff too; might try tossing him a few questions.

 
Craps, I'm an old man!

DaVince

This fool just HAD to have a custom rating

Registered
  04/09/2004
Points
  7998

Game of the Week WinnerClickzine StaffHas Donated, Thank You!Cardboard BoxDos Rules!
21st January, 2008 at 16:55:35 -


Originally Posted by Edwin Street
MySQL (whatever that is)


Database system.

 
Old member (~2004-2007).

eyeangle



Registered
  12/06/2003
Points
  1683
21st January, 2008 at 18:56:21 -

Thanks DaVince.

I've uploaded the two files the tutorial talks about to my sitesled page using MySQL from freemysql.net. And they come up like this:
http://eyeangle.sitesled.com/displayscores.php
http://eyeangle.sitesled.com/submitscore.php

But when I used byethost and its MySQL it came out like this:
http://eyeangle.byethost13.com/displayscores.php
http://eyeangle.byethost13.com/submitscore.php

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.

Image Edited by the Author.

 
theonecardgame.com

DaVince

This fool just HAD to have a custom rating

Registered
  04/09/2004
Points
  7998

Game of the Week WinnerClickzine StaffHas Donated, Thank You!Cardboard BoxDos Rules!
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.

Image Edited by the Author.

 
Old member (~2004-2007).

eyeangle



Registered
  12/06/2003
Points
  1683
21st January, 2008 at 21:38:36 -

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?

 
theonecardgame.com

eyeangle



Registered
  12/06/2003
Points
  1683
21st January, 2008 at 21:39:02 -

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

Registered
  04/09/2004
Points
  7998

Game of the Week WinnerClickzine StaffHas Donated, Thank You!Cardboard BoxDos Rules!
22nd January, 2008 at 12:46:37 -

http://www.0php.com/free_PHP_hosting.php

First result on Google.

 
Old member (~2004-2007).
   

Post Reply



 



Advertisement

Worth A Click