Hendrik Brummermann
|
cdf6f71bba
|
fixed halloffame.sql issuing warnings because of existing table
|
2023-03-12 07:31:40 +01:00 |
|
Jordan Irwin
|
7d7f59e211
|
Store best maze time in database
Closes: https://github.com/arianne/stendhal/issues/485
|
2022-12-21 23:59:02 -08:00 |
|
Jordan Irwin
|
5109808a7b
|
Undo changes to best player calculations in hall of fame script
|
2022-12-19 09:33:28 -08:00 |
|
Jordan Irwin
|
9970e66442
|
Remove karma from best player calculation
|
2022-12-11 12:32:39 -08:00 |
|
Jordan Irwin
|
953f31f024
|
Remove money from best player calculation
|
2022-12-11 11:47:09 -08:00 |
|
Jordan Irwin
|
77725ad527
|
Factor maze & deathmatch scores when calculating best players
References:
- https://github.com/arianne/stendhal/issues/453
- https://stendhalgame.org/chat/2022-07-05.html
|
2022-12-11 00:02:08 -08:00 |
|
Jordan Irwin
|
d1f8b19b79
|
Inlude karma & money when calculating HoF best players scores
References:
- https://github.com/arianne/stendhal/issues/453
- https://stendhalgame.org/chat/2022-07-05.html
|
2022-12-11 00:02:07 -08:00 |
|
Jordan Irwin
|
f111ee3c22
|
Don't factor in age when calculating best players
References:
- https://github.com/arianne/stendhal/issues/453
- https://stendhalgame.org/chat/2022-07-05.html
|
2022-12-11 00:02:07 -08:00 |
|
Jordan Irwin
|
7ca6dbd7df
|
Clean trailing whitespace in halloffame script
|
2022-12-11 00:02:07 -08:00 |
|
Jordan Irwin
|
3863100f43
|
Change charname from varchar(255) to varchar(32)
|
2022-12-07 19:41:22 -08:00 |
|
Jordan Irwin
|
3a99610148
|
Create cid table if not exists when calculating HoF
|
2022-12-07 16:55:17 -08:00 |
|
Jordan Irwin
|
fc049fdf45
|
"rank" is reserved keyword in MySQL 8
|
2022-12-07 16:54:49 -08:00 |
|
Hendrik Brummermann
|
ee2ed6fc4a
|
fixed achievement queries
|
2020-05-05 20:54:54 +02:00 |
|
Hendrik Brummermann
|
e00f4d5376
|
store number of reached achivements
|
2020-05-04 22:34:38 +02:00 |
|
Hendrik Brummermann
|
240f8e186e
|
set transaction level to dirty read for hall of fame calculations
|
2020-02-27 21:50:21 +01:00 |
|
Hendrik Brummermann
|
66a5dd10b1
|
mysql 5.7 support: ensure complete group-by-lists and non zero ln
|
2018-07-29 22:44:43 +02:00 |
|
Hendrik Brummermann
|
6a01adcf94
|
improved documentation
|
2013-10-04 16:39:36 +00:00 |
|
Hendrik Brummermann
|
27ba7fd09f
|
unified plural
|
2012-05-08 06:56:47 +00:00 |
|
Hendrik Brummermann
|
eee235caee
|
created new table statistics_archive and added a calculation script for the number recently online accounts and characters
|
2012-05-08 06:28:09 +00:00 |
|
Hendrik Brummermann
|
44f4ad407c
|
stabilized achievement ranking
|
2011-06-15 21:03:13 +00:00 |
|
Hendrik Brummermann
|
aea596b819
|
first do the calculation for recent players to reduce the midnight gap
|
2011-06-15 20:11:04 +00:00 |
|
Hendrik Brummermann
|
9519485990
|
fixed RP point calculation as discussed on http://stendhalgame.org/wiki/Fixing_RP_Score_2011
|
2011-06-15 19:28:05 +00:00 |
|
Hendrik Brummermann
|
d41604b8ed
|
fixed off by one error
|
2011-06-04 22:02:18 +00:00 |
|
Hendrik Brummermann
|
555c714ead
|
added minimum requirements for players to show up in the halloffame ranking so that we save 100000 rows per day because of characters abonded directly after account creation. The minimum requirements are: age >= 5 minutes; atk, def, xp, xp/age: >= level 2; rich > 100 money; achievement: > 500 (which means no achievements), rp > 0
|
2011-06-04 21:14:23 +00:00 |
|
Hendrik Brummermann
|
39da3c9fd2
|
exclude inactive achievements from halloffame
|
2011-04-02 14:54:54 +00:00 |
|
Katie Russell
|
90033aff38
|
exclude special category achievements
|
2011-03-14 21:13:29 +00:00 |
|
Hendrik Brummermann
|
576b0bb4ea
|
revert because mysql gets confused on counting ranks
|
2011-03-12 01:37:13 +00:00 |
|
Hendrik Brummermann
|
db23724662
|
use xp desc, karma desc, name as additional sorting criteria on all ranks to make the result stable
|
2011-03-11 07:36:56 +00:00 |
|
Katie Russell
|
8d574c1922
|
store the raw achievement score as * 1000000 in the archive because thats an integer type
|
2011-03-08 21:21:08 +00:00 |
|
Katie Russell
|
1f18f936e0
|
if the player has no achievement score at all (hasn't reached any or has not logged in since we started to log them) then don't exclude from the new score rank which combines xp,age,achievements - give a minimum achievement score
|
2011-03-06 18:05:01 +00:00 |
|
Katie Russell
|
c4bfe4a9ed
|
start storing achievement score and a score combining achievements, x and age
|
2011-03-06 17:02:32 +00:00 |
|
Hendrik Brummermann
|
db065c7b8e
|
use karma as second order in xp statistics (fixes #3108060)
|
2010-11-13 09:46:42 +00:00 |
|
Hendrik Brummermann
|
884b390407
|
added best player xp/(age+1)
|
2010-09-19 17:11:34 +00:00 |
|
Hendrik Brummermann
|
4dd4108388
|
fill hall of fame archive
|
2010-09-19 13:13:43 +00:00 |
|