Search titles only
By:
Home
Forums
New posts
Search forums
Articles
New articles
New comments
Search articles
Pinball DB
Pinball Tables
Pinball Games
What's new
New posts
New articles
New profile posts
New article comments
Latest activity
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Welcome Back to Digital Pinball Fans -
please read this first
For latest updates, follow Digital Pinball Fans on
Facebook
and
Twitter
Home
Forums
Farsight Studios
The Pinball Arcade / Farsight Studios
Platform Specific
PC
Some way of showing relative leaderboard position
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="RetroDude" data-source="post: 119364" data-attributes="member: 187"><p>I didn't know that the left arrow would wrap to the bottom of the list. Thank you.</p><p></p><p>Since that little tidbit of info wasn't on the web page, it would have been helpful to know. If I had known this, it would have totally negated the purpose for my reply as well as for your snippy, but more informative response.</p><p></p><p>Thank you for the original information and thank you again for your second post that had the rest of what I wanted to know.</p><p></p><p></p><p></p><p></p><p>FarSight already has an individual position number for every entry in each table's leader board.</p><p>They also know how many entries there are in each leader board. </p><p></p><p>The calculation to get a percentage number is just a minor change to the database query used to post the table along with an additional variable added to the output script for the web page table. </p><p></p><p>No cutoff in number of players is needed. No maintaining anything other than the data already present in their current database would be required.</p><p></p><p></p><p>Examples:</p><p></p><p>You are position 20 on a list of 200.</p><p></p><p>(20 / 200) * 100 = 10</p><p>This would mean that you are in the top 10% of the list.</p><p></p><p>The alternate percentage value would simply be subtracting the result from 100%.</p><p>(1 - (20 / 200) ) * 100 = 90</p><p>Position 20 on the list would be better than 90% of the scores on the list.</p><p></p><p>The only data required that's not currently shown on the leader board web pages is the number of entries recorded for each table.</p><p>That's a trivial query if the database is anything remotely normalized.</p><p></p><p>Something like this:</p><p></p><p>SELECT COUNT(*) As PlayerCount</p><p>FROM tblLeaderBoard</p><p>WHERE TableName = {current table}</p><p></p><p></p><p>(Yes, I know that if the leader boards are cached off-line and only repopulated on a certain schedule, the cached view would need to hold either the player count per table or the percentage value per entry. Still not rocket science, nor a complicated change to make.)</p></blockquote><p></p>
[QUOTE="RetroDude, post: 119364, member: 187"] I didn't know that the left arrow would wrap to the bottom of the list. Thank you. Since that little tidbit of info wasn't on the web page, it would have been helpful to know. If I had known this, it would have totally negated the purpose for my reply as well as for your snippy, but more informative response. Thank you for the original information and thank you again for your second post that had the rest of what I wanted to know. FarSight already has an individual position number for every entry in each table's leader board. They also know how many entries there are in each leader board. The calculation to get a percentage number is just a minor change to the database query used to post the table along with an additional variable added to the output script for the web page table. No cutoff in number of players is needed. No maintaining anything other than the data already present in their current database would be required. Examples: You are position 20 on a list of 200. (20 / 200) * 100 = 10 This would mean that you are in the top 10% of the list. The alternate percentage value would simply be subtracting the result from 100%. (1 - (20 / 200) ) * 100 = 90 Position 20 on the list would be better than 90% of the scores on the list. The only data required that's not currently shown on the leader board web pages is the number of entries recorded for each table. That's a trivial query if the database is anything remotely normalized. Something like this: SELECT COUNT(*) As PlayerCount FROM tblLeaderBoard WHERE TableName = {current table} (Yes, I know that if the leader boards are cached off-line and only repopulated on a certain schedule, the cached view would need to hold either the player count per table or the percentage value per entry. Still not rocket science, nor a complicated change to make.) [/QUOTE]
Verification
Post reply
Members online
No members online now.
Latest posts
Z
Strategies.
Latest: Zaphod77
Apr 18, 2024
WHO dunnit (1995)
Y
AtGames Legends pinball
Latest: yespage
Apr 15, 2024
Digital Pinball Cabinets
Master List of Issues: Pinball FX
Latest: Pinballwiz45b
Apr 13, 2024
Pinball FX (4)
We are back with a new site
Latest: Ian Longstaff
Apr 8, 2024
Other Pinball Games
Z
5X Jackpot build strategy (POTO)
Latest: Zaphod77
Apr 5, 2024
Phantom of the Opera (1990)
Home
Forums
Farsight Studios
The Pinball Arcade / Farsight Studios
Platform Specific
PC
Some way of showing relative leaderboard position
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept
Learn more…
Top