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
(An attempt at) The top 40 TPA players from leaderboard scores
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="invitro" data-source="post: 199590" data-attributes="member: 446"><p>Wowee, the LAW finally caught me... <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite3" alt=":(" title="Frown :(" loading="lazy" data-shortname=":(" /> <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></p><p></p><p></p><p>No. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /> It is almost certainly more work than you think to duplicate this with the little tidbits like glitched-score ignoring. I say "no" because there are some things you could do that would help greatly for hopefully tiny bits of work! See below...</p><p></p><p></p><p>I don't like to overload servers. I was a webmaster / databasemaster / serveradmin for some years myself.</p><p></p><p>The main reason the method takes so long is that your webpage can only show 10 scores at a time. If it showed 100 at a time, it would take 10 times less time.</p><p></p><p></p><p>The optimum solution for me would be to allow me to <strong>download the leaderboards as a single .csv file</strong>, through the web. No API needed <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /> and one export of the .csv daily, with the data being what they are now, <strong>*plus* the platform that the score was made on</strong>. (Many people including me think these rankings could be improved a good bit with platform data, which you can't get from the webpage.) Well, if you have the date/time the score was made/stored as a field, then that would potentially be useful too.</p><p></p><p>You could even just copy the raw database file to a web-accessible place if it didn't have anything sensitive... I'm sure there is a way to extract data from any non-encrypted database.</p><p></p><p>I would prefer that the data be available to everyone but if privacy is important you could slap a simple serverauth on the .csv URL and throw me (and certain other people) a username/passwd.</p><p></p><p>I hope there is a way to come to an easy solution that everyone likes. I will do what I can to continue these rankings up to but not including the point of making Farsight sore at me. <strong>I do thank you guys for not coming down on me or hiding the leaderboards.</strong> But I understand that you may want or need to stop the scraping of the data.</p><p></p><p>(I hope that is sensible... I don't have much time to post/edit now but wanted to reply ASAP.)</p></blockquote><p></p>
[QUOTE="invitro, post: 199590, member: 446"] Wowee, the LAW finally caught me... :( :) No. :) It is almost certainly more work than you think to duplicate this with the little tidbits like glitched-score ignoring. I say "no" because there are some things you could do that would help greatly for hopefully tiny bits of work! See below... I don't like to overload servers. I was a webmaster / databasemaster / serveradmin for some years myself. The main reason the method takes so long is that your webpage can only show 10 scores at a time. If it showed 100 at a time, it would take 10 times less time. The optimum solution for me would be to allow me to [B]download the leaderboards as a single .csv file[/B], through the web. No API needed :) and one export of the .csv daily, with the data being what they are now, [B]*plus* the platform that the score was made on[/B]. (Many people including me think these rankings could be improved a good bit with platform data, which you can't get from the webpage.) Well, if you have the date/time the score was made/stored as a field, then that would potentially be useful too. You could even just copy the raw database file to a web-accessible place if it didn't have anything sensitive... I'm sure there is a way to extract data from any non-encrypted database. I would prefer that the data be available to everyone but if privacy is important you could slap a simple serverauth on the .csv URL and throw me (and certain other people) a username/passwd. I hope there is a way to come to an easy solution that everyone likes. I will do what I can to continue these rankings up to but not including the point of making Farsight sore at me. [B]I do thank you guys for not coming down on me or hiding the leaderboards.[/B] But I understand that you may want or need to stop the scraping of the data. (I hope that is sensible... I don't have much time to post/edit now but wanted to reply ASAP.) [/QUOTE]
Verification
Post reply
Members online
Replacement
Home
Forums
Farsight Studios
The Pinball Arcade / Farsight Studios
(An attempt at) The top 40 TPA players from leaderboard scores
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