Shared Tasks

[Derision]

CREATE TABLE IF NOT EXISTS `shared_tasks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `taskid` int(10) unsigned NOT NULL,
  `leader` varchar(64) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `taskid` (`taskid`,`leader`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `shared_task_activities` (
  `id` int(10) unsigned NOT NULL,
  `activityid` int(10) unsigned NOT NULL,
  `donecount` int(10) unsigned NOT NULL,
  `completed` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`,`activityid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `shared_task_members` (
  `id` int(10) unsigned NOT NULL,
  `member` varchar(64) NOT NULL,
  `charid` int(10) unsigned NOT NULL DEFAULT '0',
  `level` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`,`member`),
  UNIQUE KEY `member` (`member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

EDIT: Looks like I added some columns to the tasks table:

I think sharedtype was 4 for Norrath's Keepers (Radiant crystal reward) and 5 for Dark Reign (Ebon crystals). The lockactivity column was to lock a task from adding new members after that activity was completed.

mysql> describe tasks;
+---------------+---------------------+------+-----+---------+-------+
| Field         | Type                | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+-------+
| id            | int(11) unsigned    | NO   | PRI | 0       |       |
| duration      | int(11) unsigned    | NO   |     | 0       |       |
| title         | varchar(100)        | NO   |     |         |       |
| description   | text                | NO   |     | NULL    |       |
| reward        | varchar(64)         | NO   |     |         |       |
| rewardid      | int(11) unsigned    | NO   |     | 0       |       |
| cashreward    | int(11) unsigned    | NO   |     | 0       |       |
| xpreward      | int(10) unsigned    | NO   |     | 0       |       |
| crystalreward | int(10) unsigned    | NO   |     | 0       |       |
| sharedtype    | tinyint(1) unsigned | NO   |     | 0       |       |
| rewardmethod  | tinyint(3) unsigned | NO   |     | 2       |       |
| startzone     | int(11)             | NO   |     | 0       |       |
| minlevel      | tinyint(3) unsigned | NO   |     | 0       |       |
| maxlevel      | tinyint(3) unsigned | NO   |     | 0       |       |
| repeatable    | tinyint(1) unsigned | NO   |     | 1       |       |
| minmembers    | tinyint(3)          | NO   |     | 0       |       |
| maxmembers    | tinyint(3)          | NO   |     | 0       |       |
| lockactivity  | tinyint(3) unsigned | NO   |     | 100     |       |
+---------------+---------------------+------+-----+---------+-------+
18 rows in set (0.00 sec)

I haven't looked at that code in over two years, but as I said in a previous post, I was trying to retrofit shared tasks into code that wasn't designed for it, and so the code felt a bit fugly and 'hackish' to me. I can't remember specifics.