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:
Here’s another, possibly clearer way to envision it :
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 
9 Comments
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.
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.
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.
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.
*giggles*
This is a side of you that I have never seen before. I think I like it!
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.
Yep, I’m in Kyousei as a visitor so I can spar on their land. Hmm.
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.
Okay. Let me know how it goes.. I don’t go there often anyway >.> It wouldn’t break my heart to leave it.