Y’all are messing up my counts!

So here I am, working really hard on data mining C:SI data without changing the existing C:SI code or database schema (because you can’t change any existing non-trivial system without introducing bugs), and while I’ve gotten farther than I originally thought I would by this point, I keep running into stuff like this:

dual-clan membership problem

Here’s another, possibly clearer way to envision it :

dual-clan membership problem 2

Basically, people that belong to more than one clan are throwing off my attempts to calculate how active each clan has been recently, in terms of its members actively fighting.  You’ll probably notice that I’m one of those people, haha.

Okay, now that I’ve got that off my chest, I’m getting back to work on it :) 

Popularity: 18% [?]

9 Responses to “Y’all are messing up my counts!”


  1. 1 Colin

    Hmm, Shika is actually not in Kyousei, but she’s a ‘visitor’ which is a role in our clan group. I will double-check, but I’m pretty sure people with the ‘visitor’ role are excluded from the ‘everyone’ role, but I guess that isn’t taken into account in the database. I suppose the solution is have a separate visitors group.

  2. 2 Colin

    Yeah, I was wrong. It’s impossible to exclude someone from ‘everone’. Having a separate group for visitors is kind of a pain. Since you can only set one group for a parcel, we can’t just say “both the visitors group and clan group have access”. Instead, we have to have everyone in the clan in both the clan group AND the visitors group, and then allow access to the visitors group. Can anyone think of a better solution? We actually aren’t restricting access to our dojo now, but there’s always the possibility that this sim will start getting greifers or something.

  3. 3 Takuan

    I am not in-world to check right now, but I believe that you can specifically change the visibility of just the “Visitors” role, rather than needing an actual group, which is nice in some cases but ultimately isn’t the best option available.

    I too am a visitor in a clan, Shadow Samurai, but my primary active clan (before I joined C:SI as a developer) was Tendai-shu. While many (most?) clans have “clan rules” that prohibit membership in more than one clan, I know that there are some clans that have no problem with it. I don’t want this technical problem to add any extra work or rules to the system, so I’m willing to just live with it for now, until I figure out something better.

    Mostly this post was just a way for me to vent a little bit, as database work is really not my strongest skill or my favorite, as well as to indirectly let people know that I’m working on C:SI - related stuff even though I’ve not been in-world much this last week.

  4. 4 Takuan

    Lemme pick me (RobbyRacoon) as an example:

    The way I am currently calculating the numbers, when a member of more than one clan fights, his duel count is reflected for *each* clan he’s a member of. That means that if I fight 20 duels this week, Shadow Samurai’s number will go up by 20 as well and Tendai-shu going up by the same amount.

    I don’t think that’s a disaster in the short term, and I’ve been thinking that it’s probably not terribly hard to fix that issue programmatically.

  5. 5 JulieAnne Rau

    *giggles*
    This is a side of you that I have never seen before. I think I like it!

  6. 6 Malachi Rothschild

    Colin,

    What we’ve done in setting up The Final Stand is set the everyone role for guests. That way we can make guests invisible without running into the problem of having the guests in a role that requires visibility by default. It would take a bit of time to migrate everyone but that might be a more effective solution for you guys than having two groups.

  7. 7 Shika

    Yep, I’m in Kyousei as a visitor so I can spar on their land. Hmm.

  8. 8 Takuan

    I don’t think that’s really a problem, or at least I don’t want to go shaking things up with this issue. I mostly posted about it, as I said earlier, to rant a little and let people know I was working on the “behind the scenes” stuff.

    I am not recommending that anyone change anything about their groups, or at least I’m not doing so yet. I’d rather find a way to work around the issue from my side.

  9. 9 Shika

    Okay. Let me know how it goes.. I don’t go there often anyway >.> It wouldn’t break my heart to leave it.

Comments are currently closed.


Bad Behavior has blocked 158 access attempts in the last 7 days.

Close
E-mail It