Onwards and SQLwards...
The ground spawn for the Crushed Diamonds. Timer is approx from what I remember people complaining about - i.e pretty long.
Code:
insert into ground_spawns (zoneid,max_x,max_y,max_z,min_x,min_y,heading,name,item,max_allowed,comment,respawn_timer) values ('96','-6040.000','-8850.000','26.300','-6040.000','-8850.000','0','Crushed Diamonds','12945','1','Crushed Diamond spawn for Spell: Cannibalize II quest','4200');
This updates the alchemy tradeskill recipes for people doing the diamond the "hard way":
Code:
insert into tradeskill_recipe (name,tradeskill,skillneeded,trivial,nofail,replace_container) values ('Crushed Dread Diamond','59','0','70','0','0','Cannibalize II quest recipe');
Get the recipe ID of the above entry, and replace 9181 below:
Code:
insert into tradeskill_recipe_entries (recipe_id,item_id,successcount,failcount,componentcount,iscontainer) values('9181','12945','1','0','0','0');
insert into tradeskill_recipe_entries (recipe_id,item_id,successcount,failcount,componentcount,iscontainer) values('9181','12947','0','0','1','0');
insert into tradeskill_recipe_entries (recipe_id,item_id,successcount,failcount,componentcount,iscontainer) values('9181','12946','0','1','1','0');
insert into tradeskill_recipe_entries (recipe_id,item_id,successcount,failcount,componentcount,iscontainer) values('9181', '17901','0','0','0','1');
insert into tradeskill_recipe_entries (recipe_id,item_id,successcount,failcount,componentcount,iscontainer) values('9181', '17770','0','0','0','1');
Update Yun shaman drop table for Powder of Yun:
Code:
insert into lootdrop (name) values('1881_Froglok_Yun_Shaman_Quest');
Get the id if the lootdrop row you just inserted, and use it below, replacing 87376 with your own ID
Code:
insert into loottable_entries (loottable_id,lootdrop_id,multiplier, probability) values ('1881','87376','1','100');
insert into lootdrop_entries (lootdrop_id,item_id,item_charges,equip_item,chance) values('87376','12944','1','0','100');
Note:
No posts indicated anything other than 100% drop rate, as the mob was KoS to the rest of the zone mobs and therefore difficult to get. PEQ has non-kos wanderers. Adjust probabilities at your whim.
Also, posts are confused as to whether the powder was black, or white. The truth is that it is both, because the icon gets swapped depending on the zone you're in :p
I'll post up Oowomp's quest Section tomorrow. Plus a dancing skeleton. Happy CannIIing.
