robindr wrote:Narc0sis wrote:I actually made some cooler looking buttons for a bunch of games. Anyone interested in them? If so ill put up a zip of buttons.
Lightfeather wrote:alegis gensan wrote:Lightfeather wrote:I changed it back to "`score` int(10) unsigned NOT NULL default '0',"
and it works again. I'd rather have moonlander not record a highscore than phuck up all the other highscore listings.
Thanks lightfeather! i suspected monlander beeing the guilty one but didnt know how to fix it
edit: dang! i always get this error in mysql:??
Code: Select all
SQL-query : ALTER TABLE `phpbb_ina_scores` CHANGE `score` `score` INT( 10 ) DEFAULT '0' NOT NULL MySQL retourneerde: Can't create table './admin_oz/#sql-49ca_c002.frm' (errno: 140)
There are two different places where you could have changed this. There is phpbb_ina_scores and iNA_SCORES They both need to match. I found that out. I did the moonlander mod for both of those and you can't just change one. You have ot make sure they sync up. I have no idea why they are duplicated but they are and they are both necessary.
if iNA_SORES has the moonlander patch on it but you reverted the phpbb_ina_scores to what it was before without fixing the other one you'll throw an error =/
I also didn't enter the "`score` int(10) unsigned NOT NULL default '0'," into the sql dump window in phpmyadmin. I actually went to the specified table and hand changed back the variables. I didn't trust the dump window to move things back the way they should.
alegis gensan wrote: well i only got phpbb_ina_scores and when i go to structure and wish to edit scores, and change varchar in that dropdown list to INT i get that error
alegis gensan wrote: Whoo do i have your permission to put your games in downloads?..
that would be the only solution i can think of so far... how does v3arcade solve this?transm wrote: the latest security fix is not working. I can still cheat the score (I followed the install.txt correctly).
I would mod the flash games to write to a file (if writing to the database is too problematic) and the newscore.php file could then check the score in the file on the server!
Strange... When I installed I got six new database entries. Did you only get three?