Things you really want to see in "Cantr Statististics

[Snickie]

Huh. Not many herbal mixtures.

They're completely useless. Of course there aren't many.

[EchoMan]

How old is the oldest character in Cantr? That is, if it's not a bad question c:

Oldest living character registered on day 227, and is currently 188.2 years old.

Code: Select all

no     age
3    188
3    187
4    179
3    176
1    175
1    174
1    167
1    165
2    159
2    158
1    156
8    154
1    153
2    151
3    149
1    148
1    147
2    146
5    144
1    143
3    142
1    141
1    140
2    139
2    138
4    137
5    136
3    135
1    134
2    133
3    132
5    130
4    129
6    128
2    127
4    126
1    125
6    124
7    123
2    122
4    121
3    120
3    119
3    118
15    117
12    116
9    115
7    114
10    113
2    112
3    111
17    110
13    109
13    108
19    107
13    106
17    105
6    104
8    103
4    102
7    101
3    100
8    99
3    98
8    97
5    96
2    95
5    94
11    93
8    92
13    91
2    90
5    89
9    88
2    87
7    86
6    85
12    84
20    83
15    82
14    81
14    80
21    79
16    78
12    77
6    76
5    75
9    74
7    73
6    72
17    71
13    70
23    69
12    68
11    67
12    66
27    65
18    64
5    63
18    62
23    61
26    60
32    59
20    58
29    57
27    56
48    55
34    54
35    53
27    52
21    51
33    50
59    49
59    48
47    47
52    46
49    45
69    44
55    43
55    42
56    41
63    40
64    39
43    38
95    37
80    36
88    35
98    34
76    33
90    32
82    31
122    30
77    29
157    28
119    27
114    26
207    25
181    24
238    23
319    22
379    21
494    20



[NostalgicMelody7]

HOLY BAJEEZUS O_O
That is an old man/woman.

[SekoETC]

The two 158s are mine, although one of them will die relatively soon. Still 19 people older than them. Sometimes I wish I had the oldest character but that would mean a lot of others would have to die first.

[SumBum]

The two 158s are mine, although one of them will die relatively soon.

Stop that, Seko!

[SekoETC]

Sorry, sometimes a story just comes to an end.

[Chris]

Which towns have lost the most people (raw number, not percentage) in the last RL year? Which towns have gained the most people in the last RL year? Thanks!

[EchoMan]

Thatis very hard to find out, unless we take a "snapshot" now and compare at a later date.

[SekoETC]

And in the database, some towns have no names at all and some are called something else than what the current population calls it.

[Chris]

Can you find out by counting number of spawns vs. number of deaths in a place? I am guessing that spawning and dying have time/date information recorded.

[NostalgicMelody7]

Quick question. How do you name the towns? Like, how do you determine what to put in for a town in the database? Is it just the first name that people start calling it in the area or derp

[Cdls]

Can you find out by counting number of spawns vs. number of deaths in a place? I am guessing that spawning and dying have time/date information recorded.

That will not take into account the number of people who have traveled to reside in a particular location though. On the other hand, it would be interesting to see which town(s) have large spawn/death ratios!

Quick question. How do you name the towns? Like, how do you determine what to put in for a town in the database? Is it just the first name that people start calling it in the area or derp :P

A while back, all locations were static and known to the characters. I am guessing the database uses those initial static names in combination with a numerical ID.

[EchoMan]

Naming is individual, and all locations are just a sequence number in the database. All locations are named "unnamed location" until a character names it. As stated, locations used to have a fixed name, so there are still references to those old names.

[EchoMan]

Can you find out by counting number of spawns vs. number of deaths in a place? I am guessing that spawning and dying have time/date information recorded.

All characters (living and dead) have a current location, and their spawn-location is recorded. Locations have no idea who is spawned or buried there. Finding all characters that has moved or are inside buildings would be a tremendous job. We would probably have to make code for it, I don't think a simple sql query would suffice to extract this information.

[jarco]

Would the amount of dutch charries per location (where there are any and without mentioning the town names) be possible?
We are currently talking about the subject of our language group in the Dutch forum and this information could have some usefull data for our discussion.

Bump