James the Watchman Tasks Not working

[Riklin]

I spent some time investigating the James the Watchman quests. Once you spawn James the Watchman, he gives tasks, however when you turn in the actual items, nothing happens.

It turns out the Activities table has those tasks set "delivertonpc" set to 202460, which is Channeler Olaemsa. James the Watchman's ID is 202390. Once this change was made, these tasks now all work as they're supposed to...

The fix is a really simple bit of SQL...

<code>
update peq.activities
set delivertonpc=202390
where delivertonpc=202460;
<code/>

[volek_the_fn_dwarf]

I also encountered this issue with James. Though I also had to enable his spawn as by default he was turned off.

UPDATE spawn2 SET enabled = 1, animation = 1 wHERE id = 148628;

I had a more complex query also, though yours is for sure simpler

UPDATE task_activities SET delivertonpc = 202390
WHERE delivertonpc != 0 AND activitytype = 1 AND taskid IN ( SELECt * FROM (
	SELECT ta.taskid
	FROM tasks t
	JOIN task_activities ta ON(t.id = ta.taskid)
	WHERE t.title LIKE '%repair my watch%'
) as RepairTasks);