Creating your own Leaderboard / Highscores Easy and Free (PHP & MySQL) [UPDATED 2020]

You're viewing a single comment in a conversation. View all the comments
  • 4 Comments

  • Order by
  • Olá como vai? gostaria de uma ajuda , está tudo funcionando, porém meu banco de dados não atualiza. fica sempre mostrando a mesma pontuação. Saberia me explicar o que seria?

    • Send a test score and check if the Database table is updated (in phpMyAdmin).

      Then, check is getscores.php is showing the new score.

      Then, check if the C2 game is reading the scores correctly.

      • after the test I found that the page is not updating, for that reason when calling getscore the data is the old one, only when I use the command to update the page that changes the data, is there a way to update this via php?

        • Can you confirm the score is saved correctly in the database (phpMyAdmin)?

          getscores.php only returns the best 10 scores. If the new score is very low, it will not appear. Are you sure the new score is in the top 10?

          You can try to edit the getscores.php and remove the "LIMIT 10" part, so ALL scores will be shown.

          Another possibility. Some hostings have an option for fast loading "optimization". It works like this: the first time you open a URL like myweb.com/something, then they save ("screenshot" or "cache") the current path url and never update it again. So they will show the same cache URL for weeks/months and will not update the content. This could also be one of the reasons?