Addition of Storm Giant Heart recipe to your database.. SQL query. Take into account a new recipe ID number would be as I am using the stock database.. Yours may be different and need to modify it.
Code:
DELETE FROM tradeskill_recipe WHERE id = 13334;
INSERT INTO tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container, notes, must_learn, quest, enablec) VALUES ("13334", "Storm Giant Heart", "75", "0", "0", "1", "0". "Storm Giant Heart", "0", "0", "1");
DELETE FROM tradeskill_recipe_entries WHERE recipe_id - 13334;
INSERT INTO tradeskill_recipe_entries (id, recipe_id, successcount, failcount, componentcount, salvagecount, isocontainer) VALUES ("154925", "13334", "62807", "0", "0", "0", "0", "1");
INSERT INTO tradeskill_recipe_entries (id, recipe_id, successcount, failcount, componentcount, salvagecount, isocontainer) VALUES ("154926", "13334", "62805", "0", "0", "1", "1", "0");
INSERT INTO tradeskill_recipe_entries (id, recipe_id, successcount, failcount, componentcount, salvagecount, isocontainer) VALUES ("154927", "13334", "62806", "0", "0", "1", "1", "0");
INSERT INTO tradeskill_recipe_entries (id, recipe_id, successcount, failcount, componentcount, salvagecount, isocontainer) VALUES ("154928", "13334", "62808", "1", "0", "0", "0", "0");
This will allow combining pure rain water and corrupt storm giant heart in the cleansing bowl to make the Storm Giant Heart.
Below is to add Earthy Loam into the forage table for Innothule Swamp (Id maybe different for you) and Pure Rain Water to PoStorms, and redwood seed to Growth plane.
Code:
INSERT INTO forage (id, zoneid, Itemid, level, chance)
VALUES ("767", "46", "62803", "0", "50");
INSERT INTO forage (id, zoneid, Itemid, level, chance)
VALUES ("768", "210", "62806", "0", "10");
INSERT INTO forage (id, zoneid, Itemid, level, chance)
VALUES ("769", "127", "62800", "0", "20");
Below is entry for Wrath Seed combine
Code:
DELETE FROM tradeskill_recipe WHERE id = 13335;
INSERT INTO tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container, notes, must_learn, quest, enablec)
VALUES ("13335", "Seed of Wrath", "75", "0", "0", "1", "1","Druid Epic 1.5 recipe", "0", "0", "1");
INSERT INTO tradeskill_recipe_entries (id, recipe_id, successcount, failcount, componentcount, salvagecount, isocontainer) VALUES ("154934", "13335", "62809", "1", "0", "0", "0", "0");
INSERT INTO tradeskill_recipe_entries (id, recipe_id, successcount, failcount, componentcount, salvagecount, isocontainer) VALUES ("154933", "13335", "62800", "0", "0", "1", "1", "0");
INSERT INTO tradeskill_recipe_entries (id, recipe_id, successcount, failcount, componentcount, salvagecount, isocontainer) VALUES ("154932", "13335", "62804", "0", "0", "1", "1", "0");
INSERT INTO tradeskill_recipe_entries (id, recipe_id, successcount, failcount, componentcount, salvagecount, isocontainer) VALUES ("154931", "13335", "62808", "0", "0", "1", "1", "0");
INSERT INTO tradeskill_recipe_entries (id, recipe_id, successcount, failcount, componentcount, salvagecount, isocontainer) VALUES ("154930", "13335", "62802", "0", "0", "0", "0", "1");
INSERT INTO tradeskill_recipe_entries (id, recipe_id, successcount, failcount, componentcount, salvagecount, isocontainer) VALUES ("154929", "13335", "62803", "0", "0", "1", "1", "0");
Last edited by Greyhelm; 02-18-2015 at 10:17 AM..
Reason: edited Storm Giant combine to not take pot when combined. Added seed of wrath combine where it removes pot after combine.
|