Raids

[Rocker8956]

KLS,
Is this the database structure you plan on using for raids? (atleast for a while)

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;

I am asking because I am getting ready to write the quest function for handing out instance flags to a raid. I will really only be using the raidid and charid field. I just want to be certain I write code that works with your implementation of raids.

Thank you