html leaderboard

Comments

• ar2rsawseen Maintainer

  July 2016

  I did something like this myself once too:
  http://appcodingeasy.com/Mobile-Backend/Score-REST-API-on-PHP5-and-MySQL

  http://appcodingeasy.com/Gideros-Mobile

  +1 -1Share on Facebook
• billydb Member

  July 2016

  Oh cool. It's all a bit over my head though. How would you use it from gideros?
  
  something like:
  
  application:openUrl( "http://yoururl/score.php?action=insert&pass=dAS7M2qXT&app=testapp&game=level1points&username=ar2rsawseen&score")
  
  ?

  +1 -1Share on Facebook
• SinisterSoft Maintainer

  July 2016

  I'll have a tinker with it today.
  

  Coder, video game industry veteran (since the '80s, ❤'s assembler), arrested - never convicted hacker (in the '90s), dad of five, he/him (if that even matters!).
  https://deluxepixel.com

  +1 -1Share on Facebook
• SinisterSoft Maintainer

  July 2016

  @ar2rsawseen, what changes would you make so that the same player can have multiple scores in the top 10?
  

  Coder, video game industry veteran (since the '80s, ❤'s assembler), arrested - never convicted hacker (in the '90s), dad of five, he/him (if that even matters!).
  https://deluxepixel.com

  +1 -1Share on Facebook
• SinisterSoft Maintainer

  July 2016 edited July 2016

  Also, because database information is in the php files, should they be chmod'ed to 600 ?
  
  Also is this .htaccess file ok to put in there to make it obscure the fact php is used?

  Options -Indexes Options +FollowSymlinks RewriteEngine On RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteCond %{REQUEST_FILENAME}.php -f RewriteRule ^(.+)$ /$1.php [L,QSA]

  Or should I use something better?

  Coder, video game industry veteran (since the '80s, ❤'s assembler), arrested - never convicted hacker (in the '90s), dad of five, he/him (if that even matters!).
  https://deluxepixel.com

  +1 -1Share on Facebook
• ar2rsawseen Maintainer

  July 2016

  @billydb no, you would need to use UrlLoader to provide and get data and then you need to display the data your self, it only provides the backend to store data and retrieve it, no visualization, sorry

  http://appcodingeasy.com/Gideros-Mobile

  +1 -1Share on Facebook
• ar2rsawseen Maintainer

  July 2016

  @SinisterSoft well you need to make sure file is not accessible from the outside, which I think php does by itself.
  other concern if someone uploads php to read and display that file, so you need to protect and validate all file uploads on your server, but it has nothing to do with the script.
  
  about htaccess, then -Indexes is a good idea yes, you don't need an url rewrite really, unless you want to and know how it would rewrite urls

  http://appcodingeasy.com/Gideros-Mobile

  +1 -1Share on Facebook
• ar2rsawseen Maintainer

  July 2016 Accepted Answer

  and about multiple scores for user, currently it supports multiple games per app, so you can have top of fastest, slowest, etc users
  
  But if you need multiple scores of same user in the same game, you need to modify code, basically this checks if there is already a score:
  
  $score = $q->select_byvar("*", "score", "where gameID = '".$_GET["gameID"]."' and username = '".$_GET["username"]."' LIMIT 1");
  
  and if there is it modifies it, if not it inserts it
  
  so you can modify to always insert it

  http://appcodingeasy.com/Gideros-Mobile

  +1 -1Share on Facebook
• SinisterSoft Maintainer

  July 2016

  
  

  Coder, video game industry veteran (since the '80s, ❤'s assembler), arrested - never convicted hacker (in the '90s), dad of five, he/him (if that even matters!).
  https://deluxepixel.com

  +1 -1Share on Facebook
• antix Member

  July 2016

  You could probably achieve the same thing using noobhub and lokijs but I think hosting for this type of system would be more expensive.

  +1 -1Share on Facebook