KLS,
Is this the database structure you plan on using for raids? (atleast for a while)
Code:
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