Shared Tasks

[Akkadius]

Originally Posted by Jaekob

If you need a collect for expeditions talk to KLS. Robregen collected those some time back and passed them along to her. Getting expeditions functional would be very nice.

Well that or what I was getting to is getting specific monster missions collected so we can extract them into database form once we get a schema and source established. Because this is going to require collects of tons of different monster profiles via AA, items etc. etc. I'm sure it's going to be quite the project.

[Akkadius]

Does anyone still have a diff as to where they got with this as well as identified opcodes and structs?

Derision, Caryatis?

[Derision]

For shared tasks ? The last few posts in this thread seem to be about Shrouds and Expeditions.

This is the diff I sent Caryatis for the work I had done on Shared Tasks a couple of years ago.

http://www.rama.demon.co.uk/sharedtasks.diff

[Akkadius]

Originally Posted by Derision

For shared tasks ? The last few posts in this thread seem to be about Shrouds and Expeditions.

This is the diff I sent Caryatis for the work I had done on Shared Tasks a couple of years ago.

http://www.rama.demon.co.uk/sharedtasks.diff

Alright thanks.

What did you not quite like about this? Is there anything you can tell me that would help anyone who just starts going through this diff?

Edit: I also see that you have three new tables that are referenced in the Mysql portions of this diff. Do you happen to have these as well before I start guessing at what the field types were and your intentions.

`shared_task_activities`
`shared_task_members`
`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.