Entropy Report post Posted March 20, 2007 I spent the last week or so working at a program to place all the player data (well, only the data I am interested in anyway) in a database. Right now the program is functional but slightly buggy and slow. As me and Learner work to perfect it, we will use it for more reliable top players. So having all this info in an SQL database (I am using Sqlite), it is trivial to calculate all kind of statistics, such as how many items of a kind in the game, the top players in a certain item, etc. For example, there are 203M GC in the game, 13.5K EFEs, 15K serpent stones, 80 titanium serpent swords of thermal, 9.3M coal, 17M bones.. I was wondering if you guys would be interested in posting some top 100 in various items, together with the quantities. For example, top 100 richest people in gold coins. So what do you think? If you think you are part of the top and don't want to be there, let me know and I will remove your name. Post here if you don't want to be in the top 100 richest players. P.S. There are 101K players in the game (we prune the inactive newbie accounts), and those quantities include banned players and those who didn't log in in ages. Share this post Link to post Share on other sites
Rockfall Report post Posted March 20, 2007 I think that this is a great idea though I doubt I'll be on any lists lol Share this post Link to post Share on other sites
neildog Report post Posted March 20, 2007 I LOVE this idea. I'm actually a total geek who loves this kinda useless information and statistics (hence why I've been tracking special days for a while http://www.eternal-lands.com/forum/index.p...st&p=343964 ) Big thumbs up from me and about the only thing I might make into the top 100 is Tree mushrooms Share this post Link to post Share on other sites
Atlantis Report post Posted March 20, 2007 (edited) I think you should post the number of items in the game (maybe only of players that logged on in last 1 month or so, if possible) but not the richest player names. Otherwise it becomes a sort of contest to see who is richest, and that's not what the game is about imho. ed: but i wouldn't mind if you did post them Edited March 20, 2007 by Atlantis Share this post Link to post Share on other sites
Quimbly Report post Posted March 20, 2007 not that i would ever be the richest but i would prefer to be left off the list. i might win lottery and being on top list might invite beggars Share this post Link to post Share on other sites
2coolfool Report post Posted March 20, 2007 great idea.. i'll probably turn up on top afk harver Share this post Link to post Share on other sites
WildIce Report post Posted March 20, 2007 what about best magic swords collectors? nice idea Share this post Link to post Share on other sites
redsoxlovr10 Report post Posted March 20, 2007 Hmmm, will this info be available to the public, such as the top 100 players list on the main website? Cause I guess if your a pk'er, it can be useful to know who has a brod and who doesn't along with other things like that. And only 80 tit therm swords ingame???? I thought there was ALOT more than that. Great job and great idea though, wish I was rich so I could be on the list Share this post Link to post Share on other sites
Vanyel Report post Posted March 20, 2007 Not interested in top wealthiest playres. More interested in general item stats. Share this post Link to post Share on other sites
freeone3000 Report post Posted March 20, 2007 (edited) Now that you have some player data in a DB, would it be beneficial to migrate the remainder? I've always had faster loading with a DB than text files, and it may allow for some features (for instance, people offline in your buddy list) that cannot be done with the current save system (at least, according to Learner). Also, the richest players? Good idea. Edited March 20, 2007 by freeone3000 Share this post Link to post Share on other sites
Entropy Report post Posted March 20, 2007 Ok, here is the top of the tree mushroomers in the game. I hope no one minds having their name and quantity disclosed, as those tree mushrooms are not really important yet: Ghrae|419657 Thanidel|370972 BloodyFist|315377 Apparition|259018 GorionW|242128 Tarby|239901 SlimPickins|232317 Dobbsie|222468 Sanddragon|222394 Queens|214028 Steve91|206773 Jarld|202944 Syllenia|183518 Szczupaczek|183111 The_Piper|182268 Atahn|179147 boognish|168505 Igrigel|165742 Ladogar|157879 Marc|147028 Kabuya|144678 geritt|143185 Kuldor|137557 restarter|136888 BoWRiS|132267 Coleonyx|130293 Amakuni|127122 Cyberwulf|125133 Eifi|124981 northstar|122364 Moraf|121669 piscator|112604 Sandtiger|110822 DarK09|110557 Selvast|110440 McLane|108556 marack|106189 TirunCollimdus|103714 AlvaRon|102831 Usul|102486 smalul|101785 Segal|99341 Miiks|95553 Kurok|95140 algernon|93258 Nolgrim|92439 dmz|88360 Boerendal|84844 selyob|82177 henker|80994 Barandur|80394 Bruno49|80098 kobajagi|78385 Senkrad_Luna|78357 sir_Mythgor|77839 Soldus|77453 EvilTina|75927 Kickey|72596 hoputa|72345 Buck_Wild|71464 crymrd|70762 Toomass|70236 SirTifiable|70231 Ikaris|70175 Florian|70044 DevilDog03|68707 Shallara|68477 imana|68232 Dejan|67271 BaDFliP|66914 Freddie_Grenade|65699 Gampa|63140 GarfieldClown|61816 SulMatuul|61535 Dezm|60534 AtavaR|60386 leahatwood|59963 BlueJay|59577 GeekBoy|58256 Djinn|57588 temospena|57307 Spare|56386 Aduard|56213 DragonCairn|55838 Kinalor|55830 Erstad|55590 Maxine|55361 SparHawk|55281 Aki|55243 shamara|55116 Breaker|54641 0ctane|54337 artie1|53173 Shadowwalker|53170 Beanmaster|52859 Uzb|51274 wolfmom|50004 Dragami|49699 4ernij_kot|49611 GabberGandalf|49375 Now that you have some player data in a DB, would it be beneficial to migrate the remainder? I've always had faster loading with a DB than text files, and it may allow for some features (for instance, people offline in your buddy list) that cannot be done with the current save system (at least, according to Learner). Also, the richest players? Good idea. No, I don't like DBs for the server. The only thing I find them useful for is stats, but the server doesn't need stats like that. Share this post Link to post Share on other sites
LevinMage Report post Posted March 20, 2007 I doubt I am on the richest list atm, but I would not prefer to have my name on it in the future, or any other list if that is possible. Share this post Link to post Share on other sites
Placid Report post Posted March 20, 2007 (edited) Jesus Christ Ghrae, do you realise you can develop schizophrenia from Hallucinogen abuse?! I've always had faster loading with a DB than text files Firstly, a text file is a database. Therefore I assume you mean DBMS (Database Management System). Lastly, you are the first person on earth to find a DBMS faster than flat files. Grats. Edited March 20, 2007 by Placid Share this post Link to post Share on other sites
Usl Report post Posted March 20, 2007 Nice idea indeed. The Top 100 lists would be funny to peruse, but even more interesting is the ability to check which goods are suffering inflation and which ones deflation, to keep the M3 monetary mass in check, to verify that the mixing rates for various artefacts are appropriate, etc... which I imagine is the real reason why this feature was worth spending a week on I'd love to see some stats... thumb up on my part! Share this post Link to post Share on other sites
Beaverhunter Report post Posted March 20, 2007 This is soooo good=) Thanks alot for trying this out, I have been wanting more stats for a long time now, this sure would do pretty fine, even if the counter could need some update too including events and rare stones. But still, very nice!=) Share this post Link to post Share on other sites
agis29 Report post Posted March 20, 2007 Good idea.Even the tree mushroomers top list looks interesting. Share this post Link to post Share on other sites
Entropy Report post Posted March 20, 2007 Top 2 rostogolers (with permission from both) Soldus - 81 Heu - 51 Share this post Link to post Share on other sites
Looter Report post Posted March 20, 2007 i like this idea too, would be cool too see who the top 100 hydro harvesters ect are Share this post Link to post Share on other sites
RolandR1 Report post Posted March 20, 2007 Top 2 rostogolers (with permission from both) Soldus - 81 Heu - 51 wow 81 rostogals!? Share this post Link to post Share on other sites
Entropy Report post Posted March 20, 2007 Nice idea indeed. The Top 100 lists would be funny to peruse, but even more interesting is the ability to check which goods are suffering inflation and which ones deflation, to keep the M3 monetary mass in check, to verify that the mixing rates for various artefacts are appropriate, etc... which I imagine is the real reason why this feature was worth spending a week on I'd love to see some stats... thumb up on my part! Well, actually I made this for a few reasons: 1. To check if there is any item dupe bug in the game. (there is none, and this is confirmed by the database) 2. To find out fast how many items of one type are in the game. 2b. To adjust the stats of the items that are too many or too little. For example, 13K of EFEs is too much, so the rate needs to be decreased again. 2c. To find new uses for some items that are too many, like the serpent stones. 3. Because it's cool, and I needed a break from coding at the server. 4. So we can have more reliable top 50s for the skills. Share this post Link to post Share on other sites
Ghrae Report post Posted March 20, 2007 Jesus Christ Ghrae, do you realise you can develop schizophrenia from Hallucinogen abuse?! I haven't *twitch* noticed any sideffects *twitch* *twitch* yet. In fact *twitch*, I consider myself *twitch* to be extremely *twitch* normal. *twitch*. I think *twitch* that you just *twitch* *twitch* want all of my *twitch* *twitch* *twitch* shrooms! They're mine! Mine, *twitch* I tell you! *twitch* And no, I'm not *twitch* paranoid!! *twitch* *twitch* Share this post Link to post Share on other sites
Atlantis Report post Posted March 20, 2007 I think it'd be cooler if you put up a sort of global version of the counters... "most fluffies killed", "most FEs made", "most sr's made", "most giants/dragons/w.e killed" etc. Share this post Link to post Share on other sites
Entropy Report post Posted March 20, 2007 Yes, I thought of that too, probably I am going to do it some time in the future. Share this post Link to post Share on other sites
2coolfool Report post Posted March 20, 2007 more reliable to 50s? what is that? Share this post Link to post Share on other sites
Entropy Report post Posted March 20, 2007 Sorry, I meant top 50. Share this post Link to post Share on other sites