Jump to content
Eternal Lands Official Forums
Entropy

El item stats

Recommended Posts

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

I think that this is a great idea :lipssealed:

 

though I doubt I'll be on any lists lol

Share this post


Link to post
Share on other sites

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 by Atlantis

Share this post


Link to post
Share on other sites

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

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 :lipssealed:

Share this post


Link to post
Share on other sites

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 by freeone3000

Share this post


Link to post
Share on other sites

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

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 by Placid

Share this post


Link to post
Share on other sites

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 :lipssealed:

 

I'd love to see some stats... thumb up on my part!

Share this post


Link to post
Share on other sites

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

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 :lipssealed:

 

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

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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×