[TranceCan]

Originally Posted by MrZeropage

@Zidane007nl:
@TraceCan:
Games normally submit their score to arcade.php or index.php (depending on gametype) so I think this is somehow "hardcoded" in the games itself.
Maybe you try some htaccess-rewrite-rules to solve this for you ? (just an idea)

Hey, thanks for the suggestion. Yes it is hardcoded into the flash to submit to arcade.php, but the problem isn't where it's submitting to, it just never actually does the submit (when it's on an https:// page).

When I am at:

https://www.mysite.com/forums/arcade.php the game loads, I can play, but no scores, just sites there after the game ends....

http://www.mysite.com/forums/arcade.php everything works fine

In the flash code that is hardcoded into the games itself it has this line:

this.prequestvars.sendAndLoad("./arcade.php", this.pranswer, "POST");

So, that shouldn't be a problem if it's https:// instead of http://

I think it's something else, possibly in the HTML that loads the flash movie??


Oh, it gets more interesting....it seems to work in Firefox! HOWEVER, when it goes to actually do the submit I get this error:

Fatal error: Cannot use object of type mysqli_result as array in /var/www/html/forums/arcade.php on line 1203


OK I'm back AGAIN and confirmed it DOES work in Firefox. The error I just posted above happens whenever a score is submitted that is not a new highscore. It is related to this code around like 1203 in arcade.php, I suspect because I am using mysqli instead of plain old mysql..anyone have a fix??

                       $check = $db->query_first("SELECT COUNT(*)+1 AS rank FROM " . TABLE_PREFIX . "arcade_sessions AS arcade_sessions
                        WHERE arcade_sessions.valid=1 AND arcade_sessions.gameid=$game[gameid] AND score" . iif($game['isreverse']==1, '<', '>') . "$game[score]");

                        $check2 = $db->query_first("SELECT COUNT(*)+1 AS rank FROM " . TABLE_PREFIX . "arcade_sessions AS arcade_sessions
                        WHERE arcade_sessions.valid=1 AND arcade_sessions.gameid=$game[gameid] AND score='$game[score]' AND finish>$game[finish]");
                }
                $highscore = $check['rank'] + $check2['rank'];