Things you really want to see in "Cantr Statististics

[SekoETC]

Most keys per lock is 28, and this has been mentioned before. Of course I can't say where it is.

As for keys that don't go anywhere or locks with no keys, I'm not sure if such a query would be possible because locks and keys are in the same table and it can't join itself. I think queries like that are done by copying stuff into a new table and dropping it once you're done. Correct me if I'm wrong.

There are 24312 different kinds of keys and 15450 locks, so if we assumed there were no locks that didn't have a key (although such do exist) that would leave 8862 types of key with no lock, and there can naturally be several copies.

[SumBum]

I think queries like that are done by copying stuff into a new table and dropping it once you're done. Correct me if I'm wrong.

That is correct. Well, there may be other ways, too.

[Doug R.]

So what is the oldest lock number?

[SekoETC]

6125. It's also the only lock with four digits so if your key has four or less digits and is not that one, you can crush it.

[Doug R.]

6125. It's also the only lock with four digits so if your key has four or less digits and is not that one, you can crush it.

Using that knowledge would be a CRB

[Cdls]

6125. It's also the only lock with four digits so if your key has four or less digits and is not that one, you can crush it.

Would like to know how many people started to crush those keys since you said that.....

[YugoStrikesBack]

What towns have seen the most amount of murders in the past year?

[returner]

How many English residents are there on the biggest continent? I believe it's called Fu. Some people call it Fu Island, but by god it's bigger than a continent. It's like a fricken lack of ocean.

[SekoETC]

Murder is a subjective term, but as for characters killed violently per location... well, I think it's more like where they have been buried, but corpses rarely get transported between towns. This also contains buildings since I grouped by coordinates.

Top ten - Within a real-life year:

Violent deaths / Location

Code: Select all

60   Longinazy
51   Vlotryan
38   Plaekur
28   Seatown Hills
25   Grande Chifre
25   Djorf Hills (north)
23   San D'Oria
22   Bojholm
20   Sorgo / Lamparcia Łączka / Sorgo Laivu Garazas
17   Plaekur forest (west)

For comparison: All-time top ten

Code: Select all

136   Vlotryan
106   Longinazy
102   Olipifirovash forest
100   Seatown Forest
97   Moku (south)
81   Bojholm
71   Cechowice
68   Karnon Forest
60   Devrapolis
56   Plaekur

If you meant within the last Cantr year, I think that's too recent. There was one town with 7 violent deaths and if there has been a massacre, this is not the way I wanted to find out about it. While all the others have only 3, 2 or 1, so it doesn't make much statistics.

There are 87 living English characters on Fu. This only includes people that are outdoors and not in vehicles. The most English characters in one location there is 19.

[Rebma]

That's wicked Seko, as always. Surprised to see Seatown Forest on the all-time highest violent death. Karnon Forest a bit too.

[Doug R.]

Surprised to see Seatown Forest on the all-time highest violent death. Karnon Forest a bit too.

Um...Karnon Forest was the original home of the Blackrocks, and Nick and Naedell are cut from the same cloth when it comes to the dispensability of...well...everyone. Seatown Forest was the ruled by the Mailey/Mary/Sabine dynasty, and I can testify that Mary killed off belligerent newspawns like people now kill squirrels.

[returner]

That's wicked Seko, as always. Surprised to see Seatown Forest on the all-time highest violent death. Karnon Forest a bit too.

Haha, those two are the only ones I could understand why the murder rate is so high!

Karnon Forest was home to the Blackrocks, remember?

Seatown Forest, as I recall, used to be controlled by some crazy b***h who murdered anyone who went against her rule, for a very long time. Two or three of my characters were lost to her, back in '05 or '06.

[Doug R.]

Two or three of my characters were lost to her, back in '05 or '06.

My character was in love with her

She was very misunderstood.

[Rebma]

Well Karnon I knew. I just didn't think they killed that many there. I thought a lot of the deaths were in other towns.

And I guess I forgot about SF. It was pleasant both times I've played cantr. Kinda. Or I just got lucky.

[SekoETC]

I'm a bit surprised about Longina--- no wait, didn't the Blackrocks move there? Anyway, I was also surprised that LFE didn't show up, since I assumed the Blackrocks had killed more people there. I'm not surprised about San D'Oria, or Plaekur/Seatown Hills/DHN. I'm guessing Vlotryan only shows up high on the lists because it has such a high population overall. Then that Sorgo place was named as pirate town by a few people.