I just finished Sparckman's Hi Score Tutorial. What now?

[Emerson3]

Hey Schro,

Thank you sir. I checked out your updates and added some things myself. I added a feature for when the player dies that triggers to send the score to frame 3 or to start the frame over. I also skinned the first frame. The only issue, I know I created it, is that if I type my full name and beat the lowest score on the hi score table, it overlaps the name that was already there. Here is an update! Also, is there a way to clear the names so the table is fresh?

https://drive.google.com/file/d/0B0v...ew?usp=sharing

[schrodinger]

As for overlapping names,
I think that ninth (now last) line being "test test test test test" is too long and goes to the following line,
overlapping the tenth

You have two simple ways to tackle this problem,
I'd go for the first:

1) on name input (first frame) for the edit box add a condition stating:
start of frame
>>> control - limit text size (maximum nr. of characters)

2) on name output (third frame) cut each line to a maximum fixed length >> like "left$(string,maximumnumberofchars)"


As for hi-score resetting,
keep in mind that frame 3 outputs what you have stored in your mySql table on the server,
so best way would be clearing your "score" SQL table on the server.
But if you don't have experience with SQL database management (and the hoster doesn't offer easy tools to interact with it)
maybe easier would be editing your config.php file (you can change it locally and then overwrite the one you have uploaded)

in short...
I thing you could simply track this line on config.php:

// Your table name for mySQL
// You can change this is you wish
$tname= 'scores';

and change to:

// Your table name for mySQL
// You can change this is you wish
$tname= 'scores1';


You may repeat this procedure at will,
each time you change the table name in you config file,
simply tells the script to create a new (empty) table if he doesn't already find that.
Previous table would still exist in your database, but there are no space issues in this scenario.

[Emerson3]

Schro,

You are a life saver! I got everything working just like I needed. Breath of fresh air. Thank you for generously lending your knowledge.