EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Quests::need work (https://www.eqemulator.org/forums/forumdisplay.php?f=635)
-   -   James the Watchman Tasks Not working (https://www.eqemulator.org/forums/showthread.php?t=42024)

Riklin 08-08-2018 11:03 PM

James the Watchman Tasks Not working
 
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 08-09-2018 02:52 AM

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

Code:

UPDATE spawn2 SET enabled = 1, animation = 1 wHERE id = 148628;
I had a more complex query also, though yours is for sure simpler
Code:

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);



All times are GMT -4. The time now is 12:59 PM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.