Raids

[sesmar]

Originally Posted by KLS

Here's where I left off last time I was thinking about potential ways to track them.

CREATE TABLE `raid_ungrouped_members` (
  `raidid` int(4) NOT NULL,
  `charid` int(4) NOT NULL,
  `name` varchar(64) NOT NULL,
  `ismaintank` tinyint(1) NOT NULL,
  PRIMARY KEY (`raidid`, `charid`)
)

CREATE TABLE `raid_groups` (
  `raidid` int(4) NOT NULL,
  `groupid` int(4) NOT NULL,
  `groupindex` tinyint(1) NOT NULL,
  PRIMARY KEY (`raidid`, `groupid`)
)

CREATE TABLE `raid_leader` (
  `raidid` int(4) NOT NULL,
  `name` varchar(64) NOT NULL,
  PRIMARY KEY (`raidid`)
)

I am not very familiar with how the raids work either but from looking at your tables here could you just do something like this:

CREATE TABLE `raid_members` (
  `raidid` int(4) NOT NULL,
  `charid` int(4) NOT NULL,
  `name` varchar(64) NOT NULL,
  `ismaintank` tinyint(1) NOT NULL,
  `isgrouped` tinyint(1) NOT NULL,
  `isleader` tinyint(1) NOT NULL,
  PRIMARY KEY (`raidid`, `charid`)
)

CREATE TABLE `raid_groups` (
  `raidid` int(4) NOT NULL,
  `groupid` int(4) NOT NULL,
  `groupindex` tinyint(1) NOT NULL,
  PRIMARY KEY (`raidid`, `groupid`)
)

Using one table for all of your raid members (same table as your ungrouped_members tables) and add a isgrouped flag and a isleader flag.

One of the issues that I seen with devnoob's suggestion of adding the raid leader flag to the raid_groups table was that the charid is not referenced in that table and therefore does not point the leader to a specific character but only to a group.

Just a suggestion from that I seen only by looking at what you have posted so if this is completely off base I am sorry for that.

[devn00b]

whoops yep...forgot to put that in there :p good catch...teach me to try and think before the 1st cup of coffee..

[KLS]

CREATE TABLE `raid_members` (
  `raidid` int(4) NOT NULL,
  `charid` int(4) NOT NULL,
  `groupid` int(4) NOT NULL,
  `_class` int(4) NOT NULL,
  `level` int(4) NOT NULL,
  `name` varchar(64) NOT NULL,
  `isgroupleader` tinyint(1) NOT NULL,
  `israidleader` tinyint(1) NOT NULL,
  `islooter` tinyint(1) NOT NULL,  
  PRIMARY KEY (`raidid`, `charid`)
)
ENGINE = InnoDB;

CREATE TABLE `raid_details` (
  `raidid` int(4) NOT NULL,
  `loottype` int(4) NOT NULL,
  `locked` tinyint(1) NOT NULL,    
  PRIMARY KEY (`raidid`)
)
ENGINE = InnoDB;

Is what I actually ended up going with.
Got basic creation and inviting ungrouped characters working, so much more to do.

[Giren]

KLS.

Names should not be able to be changed, just don't implement it.

The notes tab is just a minimalist way of showing the first tab. Don't worry too much about it.

Raids should completely overwrite the group function. The groups still function as groups should (buffs stay within groups unless target group buff is turned on). And leaving the group would make you go into the un-grouped portion of the raid.

Oh, and another note, if you didn't know about the looter thing.

Default for raids is: no one but the raid leader can loot anything off corpses until they open up publicly.
Adding a looter just gives the the person the ability to loot at the same time as the leader.

[janusd]

Additionally, things will have to be set so that if the raid leader logs without changing the raid leader flag, the raid leader goes LD, or gets booted while zoning, the raid leader status will default to whomever becomes the group leader of the raid leader's group.

[KLS]

Right now if the leader/group leader leaves the raid for any reason it just gets lost but that will change before release. Right now you don't get kicked from the raid for logging out but I'm not sure if that will stay.

Groups inside the raid mostly work, but there's still several kinks to work out.

[KLS]

Got rsay and gsay working inside raids as well as moving and inviting and disbanding seems to work correct for the most part. Need to do a lot of polishing with some of the packets; some people not getting group leader updates and it's a bit spammy for others but I think that might even wait till after the system gets released as it's cosmetic really.

Figured out notes and motd as well as raid/group leader changes.

Gonna start working on actually getting the system to interact with the world now.