Online Highscore

Posted by Viper on Sept. 9, 2006, 9:45 a.m.

Working on topdown got boring, so I decided to make a little side-project minigame. Don't worry, the topdown game's production will resume as soon as this one is finished. I already have the basic engine, what I need now is someone to help me with an online highscore table. If someone wants to help, then I'll tell them what the game is, and send the the .gm6. Also, I've checked the examples and tutorials on the GMC, but those don't really explain the whole hosting and mysql thing very well, so I don't really understand how to put it in my game.

All help is appreciated, and credit will be given as usual.

Thanks,

Viper

Comments

sinkhead 17 years, 8 months ago

Uh, your banner is too big. It's about 170Kb and there's a limit of 120Kb.

And I'll give you some free, fast, paid for by me SQL databases if you wants me to.

hobomonkeyc 17 years, 8 months ago

The whole banner thing is dependable…

Its not streching out the page and it wont nuke your computer

Who cares?

Viper 17 years, 8 months ago

I don't wanna sound mean here, but what, do you just go around checking how big peoples banners are? If it actually causes someone's computer to lag some, then I'll change it, but I doubt 50kb is reason to have to change it.

sinkhead 17 years, 8 months ago

No, I don't go round checking people's banners, it's just that I could actually see it loading and that doesn't happen often with my connection. Anyway, do you want these database(s)?

Viper 17 years, 8 months ago

I guess, but I honestly don't know exactly what to do with them yet, that's what I'm asking for help with. I can find a free sql server if I had to.

ludamad 17 years, 8 months ago

I see no problem with the banner, but others might. My own banner got taken away, and I'm an admin *grumbles*.

sinkhead 17 years, 8 months ago

Database tables are a little like spreadsheets.

Inside the database you have numerous tables. You can get info from them using a query similar to:

<?php

$query = "SELECT name, subject, message FROM contact";

$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))

{

echo "Name :{$row['name']} <br>" .

"Subject : {$row['subject']} <br>" .

"Message : {$row['message']} <br><br>";

}

?>