Go Back   EQEmulator Home > EQEmulator Forums > Quests > Quests::need work

Quests::need work This is where quests that are outdated or still need work

Reply
 
Thread Tools Display Modes
  #1  
Old 08-08-2018, 11:03 PM
Riklin
Hill Giant
 
Join Date: May 2003
Location: Tacoma, WA
Posts: 164
Default 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/>
Reply With Quote
  #2  
Old 08-09-2018, 02:52 AM
volek_the_fn_dwarf's Avatar
volek_the_fn_dwarf
Fire Beetle
 
Join Date: Aug 2018
Location: Charlotte NC
Posts: 2
Default

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);
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3