View Single Post
  #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