MYSQL Highscores Databse

[all mighty 1]

Ok I have a dynamic signature databse, and i was wondering if there is any good tutorial around so that i can make a highscore table?

thanks

 

[learning_brain]

Weirdly, most google results are for flash or other games.... no good tuts I can readily find.

However, a highscore table would be simple enough to do depending on what you want.

For instance, you could add another column in your mysql db with score.

Then simple do a recordset using "ORDER BY score ASC" in your sql query.

To output, create a repeating region (do{......} while()) to output the scores in a table.

If you can be more specific, we can help you through it step by step.

How skilled are you in php?

 

[smithee]

What would your high scores be based on? I assume it's for a game, but is it in Flash, Java, JavaScript, etc...?

 

[all mighty 1]

yes it is for a game runescape*java*, im using it for a bot for when the bots finishs it calculates the timeran etc

the code that updates to php is java

All i want it to output is the

user, timeran, exp, naturesmade:

public void updateStats(boolean update) {
		if (System.currentTimeMillis() - lastUpdateMillis > 300000 || update) {
			if (lastExp == 0)
				lastExp = skills
				.getCurrentSkillExp(Constants.STAT_RUNECRAFTING);
			if (lastUpdateMillis == 0)
				lastUpdateMillis = startTime;
			try {
				new URL(
						//http://scaper.elementfx.com/sig/submit.php?user=
						"http://scaper.freehostia.com/sig/submit.php?user="
						+ user
						+ "&time="
						+ Math
						.round((System.currentTimeMillis() - lastUpdateMillis) / 1000)
						+ "&nats="
						+ naturerunecount
						+ "&xp="
						+ (skills
								.getCurrentSkillExp(Constants.STAT_RUNECRAFTING) - lastExp)).openStream();
			} catch (final MalformedURLException e1) {
			} catch (final IOException e1) {
			}

			lastUpdateMillis = System.currentTimeMillis();
			lastExp = skills.getCurrentSkillExp(Constants.STAT_RUNECRAFTING);
		}
	}

 

[callumacrae]

You can't host a runescape bot on your account

~Callum

 

[all mighty 1]

You can't host a runescape bot on your account

~Callum

uhhh i am not hosting a runescape bot :/

im hosting a dynamic signature and its stats from a script for a bot that is not hosted anywere nere these forums all i do is send data from the script to my mysql databse

 

[all mighty 1]

Can anyone please help me?

My question now is

How can i make a php file read my mysql databse for the users.?

Then im going to output the data with html