-
You've discovered RedGuides, an EverQuest multi-boxing and scripting community 🧙♀️⚙️. We want you to play several EQ characters at once, come join us and say hello! 👋
Release Tradeskill Construction Set |Quests:GOD,TSS,POK,POR Freebie Assister [Deleted]
- Thread starter jb321
- Start date
- Status
- Joined
- Feb 9, 2017
- RedCents
- 1,387¢
Downloaded the latest and add the files.
- Joined
- Feb 9, 2017
- RedCents
- 1,387¢
rouneq has the right idea for normalizing the data. It also lets you create separate tables for things like what vendors (permanently) sell what items and from there you can query by zone.
ShinNoir/Xackery had a scrape of eqtraders data that he was using, though I think he had yet to normalize the data. If you search the forums, alynel also exported tradeskill information at one point, though I believe it is older. Either way, probably a good idea to check with them and combine efforts, or at least get a jump start on data harvesting.
ShinNoir/Xackery had a scrape of eqtraders data that he was using, though I think he had yet to normalize the data. If you search the forums, alynel also exported tradeskill information at one point, though I believe it is older. Either way, probably a good idea to check with them and combine efforts, or at least get a jump start on data harvesting.
I will be embarking on this data journey shortly, it is not as sexy as making things happen (user experience) but it looks sharp and has turbo handling on the back end.. having a single DB for all things would be great.. !
I also need to think it through, if I can pull items from a online data source based on ID, that could be very helpful for plucking individual item ids for a recipe..
walking through it.. I think I would get any vendor name in POK if the item id has it, and then pick the 1st vendor..
Scrape: recipes, sources, ID, trivial, yield, stacakble, value, on failure return item
I have not delved into multi-vendor with same item in same zone dynamics yet.. (nearest.vendor).. the reason I mention this..
I have been deconstructing the buy routine for individual recipes.. it is now only coupled to the shopping list solely for the purpose of picking a vendor..
I will remove that and have it associate an item with a vendor using the vendor_file.. to do it the cool way I could add in more vendors and have it sort by nearest and pick that vendor.. however, most of the vendors are all by dogle so I usually choose those. the one offs darius and those other guys.. they are far away from the main ts area with all the crafting tables.
I am working on 2 things currently..
1) if we have to make a recipe and it can use 20 different methods to achieve the main method we will pick whatever one has the required items in inventory and convert it to complete the the main recipe.
2) create a item vendor sort routine that reads a recipe, removes dups, counts required items, assign vendor, then sort by vendor so when we do go shopping it doesn't run to Darius and then to Nonny, and then back to Darius.. This will open the way for single recipe shopping, added benefit is this can be used for non-quests to do shopping..
and work on other stuff that I didn't mention because why not do everything all at once
thinking again. I should just put in itemcounts for each item in a recipe so I will not need to remove dupes, nor will I have to do counts..
which removes some steps.. I can phase it in.. so it will start with shopping and then work it's way into the TSC_Core..
Last edited:
So.. this is awesome..
docs.google.com
buut is it updated..? :p
Tradeskill Recipes
All Recipes Item,Source,Zone,Mob/Vendor Name,Vendor Location,Tradeskill,Trivial,Yield,Container,Ingredients,Also Returns,On Failure Returns,Already Known,Counts Towards 350 Abysmal Sea Breathing Potion,Created,Alchemy,31,1,Medicine Bag|Reinforced Medicine Bag|Foldable Medicine Bag|Foldable Reinf...
buut is it updated..? :p
- Joined
- Feb 9, 2017
- RedCents
- 1,387¢
Might have to edit the trophy commands, but here is the help section for the needed items.
INI:
Sub Mats_Help
/echo \atTC Support Set: \at[Mats Help]
/echo \ag This is a list of supplies needed for each trophy quest. Once you obtain these items, you can run the corrosponding quest using \at/mac TSC ShopMake TheTrophyYouWantToMake
/echo \ay---[\aoResearch\ay]---
/echo \agAll Items are Vendor Bought Using \at/mac TSC Shop ResearchTrophy \agor \at/mac TSC ShopMake ResearchTrophy
/echo \ay---[\aoFletching\ay]---
/echo \agAll Items are Vendor Bought Using \at/mac TSC Shop FletchingTrophy \agor \at/mac TSC ShopMake FletchingTrophy
/echo \ay---[\aoPottery\ay]---
/echo \agAll Items are Vendor Bought Using \at/mac TSC Shop PotteryTrophy \agor \at/mac TSC ShopMake PotteryTrophy
/echo \ay---[\aoAlchemy\ay]---
/echo \agAll Items are Vendor Bought Using \at/mac TSC Shop AlchemyTrophy \agor \at/mac TSC ShopMake AlchemyTrophy
/echo \ay---[\aoJewelry\ay]---
/echo \agNeed \ay[\apBlack Pearl\ay]\at: Bought from a \ay[\atResupply Agent\ay] \ay(\apSummon Agent AA\ay) \agor farmed.
/echo \agThen Run \at/mac TSC Shop JewelryTrophy \agor \at/mac TSC ShopMake JewelryTrophy
/echo \ay---[\aoSmithing\ay]---
/echo \agNeed \ay[\apSmall Brick of Acrylia Ore\ay]\at: \agFarmed in Acrylia Caverns
/echo \ag(Or recipe will Break Down a \ay[\apLarge Brick of Acrylia Ore\ay] \agor \ay[\apBlock of Acrylia Ore\ay]
/echo \agThen Run \at/mac TSC Shop SmithingTrophy \agor \at/mac TSC ShopMake SmithingTrophy
/echo \ay---[\aoBrewing\ay]---
/echo \agNeed \ay[\apSylvan Berries\ay]\at: \agForaged in just about any zone
/echo \agNeed \ay[\apFruit\ay]\at: \agForaged and Farmed in Lesser Faydark
/echo \agNeed \ay[\apAerated Mineral Water\ay]\at: \agBought in West Freeport \ay[\atPink Fuzzlecutter\ay]
/echo \agNeed \ay[\apRoyal Jelly\ay]\at: \agBought in Kelethin \ay[\atMerchant Weaolanae\ay] \agand \ay[\atMerchant Kanoldar\ay] \agFarmed in Lesser Faydark (Various Giant Wasps)
/echo \agThen Run \at/mac TSC Shop BrewingTrophy \agor \at/mac TSC ShopMake BrewingTrophy
/echo \ay---[\aoBaking\ay]---
/echo \agNeed \ay[\apSpit\ay]\at: \agSold in POK by \ay[\atChef Denrun\ay] \ag(You should have one if you did the Freebies)
/echo \agNeed \ay[\apRat Ears\ay]\at: \agSold in Commonlands by \ay[\atKatha Firespinner\ay] \agFarmed from various rats.
/echo \agNeed \ay[\apWolf Meat\ay]\at: \agFarmed various wolfs (The Jaggedpine Forest) recommended.
/echo \agNeed \ay[\apSpider Legs\ay]\at: \agFarmed various spiders (Most starting zones with spiders)
/echo \agNeed \ay[\apSaltwater Crab\ay]\at: \agUsed to make \ay[\apSawltwater Crab Meat\ay] \agFarmed in Abysmal Sea - Crab Traps (Fished in various zone in GOD)
/echo \agNeed \ay[\apSaltwater Tuna\ay]\at: \agUsed to make \ay[\apTuna Meat\ay] \agFished in various zone in GOD
/echo \agNeed \ay[\apAnaconda Meat\ay]\at: \agFarmed in The Jagged Pine Forest and Nedaria's Landing from Anocanda
/echo \agNeed \ay[\apBixie Parts\ay]\at: \agFarmed in Commonlands, Kithicor Woods, Misty Thicket, Nectulos Forest from various bixie
/echo \agNeed \ay[\apGriffon Meat\ay]\at: \agFarmed in East Karana, Nedaria's Landing, The Jaggedpine Forest from various griffawn and griffon
/echo \agNeed \ay[\apSnake Egg\ay]\at: \agFarmed in various starting zones from snake and Moccasin
/echo \agThen Run \at/mac TSC Shop BakingTrophy \agor \at/mac TSC ShopMake BakingTrophy
/echo \ay---[\aoTinkering\ay]---
/echo \agAll You will need \ay[\apRaw Dark Matter\ay] \agUsed to make \ay[\apDark Matter\ay] \agand \ay[\apGrain of Dark Matter\ay] \ag- \agFarmed from various mobs in Barindu, Ferubi, Natimbi, Qinimi, Riwwi and Tipt
/echo \agThen Run \at/mac TSC Shop TinkeringTrophy \agor \at/mac TSC ShopMake TinkeringTrophy
/echo \ay---[\aoTailoring\ay]---
/echo \agNeed \ay[\apSpiderling Silk\ay] \agFarmed from various spiders, spiderling and hatchling Also, Foraged in Mistmoore Catacombs
/echo \agNeed \ay[\apSpider Silk\ay] \agFarmed from various spiders, spiderling and hatchling and Foraged in Mistmoore Catacombs
/echo \agNeed \ay[\apRuined Bear Pelt\ay] \agFarmed from various bears in Commonlands, Everfrost Peaks, Kithicor Woods, Rathe Mountains and Surefall Glade
/echo \agNeed \ay[\apRuined Cat Pelt\ay] \agFarmed from various Lions, Lioness and Young Puma in Commonlands, Everfrost Peaks, East Karana, Emerald Junble, North Karana and South Karana
/echo \agNeed \ay[\apRuined Wolf Pelt\ay] \agFarmed from various Wolf in Commonlands, Everfrost Peaks, Greater Faydark, Icefall Glacier, Qeynos Hills and South Karana
/echo \agNeed \ay[\apLow Quality Bear Skin\ay] \agFarmed from various Bears in Commonlands, Everfrost Peaks, Feerrott, Misty Thicket, Qeynos Hills and South Karana
/echo \agNeed \ay[\apLow Quality Cat Pelt\ay] \agFarmed from various Leopard and Panther in The Jaggedpine Forest
/echo \agNeed \ay[\apShade Silk\ay] \agFarmed from various shak dratha in Shadeweaver's Thicket
/echo \agNeed \ay[\apFish Eggs\ay] \agFarmed and Foraged in Reef of Coirnav (Plane of Water) by Hraquis grunt, Sharpnose in Buried Sea (Also made with various fish and a skinning knife)
/echo \agNeed \ay[\apRaw-Hide Gorget\ay] \agFarmed from various ice goblins in Permafrost Caverns, rock breaker in Blightfire Moors, most common in South Desert of Ro by an orc warrior
/echo \agThen Run \at/mac TSC Shop TailoringTrophy \agor \at/mac TSC ShopMake TailoringTrophy
/echo \ay---[\aoToxicology\ay]---
/echo \agNeed \ay[\apSpider Venom Sac\ay] \agFarmed from various spiders
/echo \agNeed \ay[\apFroglok Poison Gland\ay] \agFarmed from various froglok in Upper Guk and Lower Guk
/echo \agNeed \ay[\apUticating Hairs\ay] \agFarmed from drachnid recluce in Dreadlands
/echo \agNeed \ay[\apAsp Poison Sac\ay] \agFarmed from various asp in Commonland and cistern asp in Southern Desert of Ro
/echo \agNeed \ay[\apBasilisk Eye Stalk\ay] \agFarmed from various Basilisk in Lavastorm Mountains, Butcherblock Mountains, The Jaggedpine Forest and Rathe Mountains
/echo \agNeed \ay[\apGrave Mold\ay] \agFarmed from various undead in Estate of Unrest
/echo \agNeed \ay[\apCrystallized Marrow\ay] \agFarmed from Ice Bone Skeleton in Everfrost Peaks (many place holders kill everything)
/echo \agNeed \ay[\apCyclamine Corm\ay] \agFarmed from various orcs in Everfrost Peaks
/echo \agNeed \ay[\apSnake Venom Sac\ay] \agFarmed from various snakes and mamba in East Karana, Goru`kar Mesa, The Steppes, Toxxulia Forest and the Jaggedpine Forest
/echo \agNeed \ay[\apPutrid Bile\ay] \agFarmed from various fire drake and a magma war drake in Lavastorm Mountains
/echo \agThen Run \at/mac TSC Shop ToxicologyTrophy \agor \at/mac TSC ShopMake ToxicologyTrophy
}
/return false- Joined
- Feb 9, 2017
- RedCents
- 1,387¢
could always duplicate it and update if needed.
web data scrapers?
where did u get info for vendor file? or did u just look it up..and does the experimental version work...??
...
Last edited:
would be perfect if it had the item id 
bah
bah
| Small Piece of Ore | Created | Smithing | 27 | 2 | Forge | Small Brick of Ore|1|Smithing Chisel|1 | Smithing Chisel|1 | Smithing Chisel|1 | FALSE | Plz halp | |||
| Small Piece of Ore | Created | Smithing | 21 | 1 | Forge | Tarnished Short Sword|1|Water Flask|1 | FALSE | Plz halp | |||||
| Small Piece of Ore | Created | Smithing | 21 | 1 | Forge|Tanaan Forge|Forge - Floor (Placeable)|Forge - Standing (Placeable)|Guild Forge | Tarnished Dagger|1|Water Flask|1 | FALSE | Plz halp | |||||
| Small Piece of Ore | Created | Smithing | 21 | 2 | Forge|Tanaan Forge|Forge - Floor (Placeable)|Forge - Standing (Placeable)|Guild Forge | Tarnished Axe|1|Water Flask|1 | FALSE | Plz halp | |||||
| Small Piece of Ore | Created | Smithing | 21 | 1 | Forge | Tarnished Shortened Spear|1|Water Flask|1 | FALSE | Plz halp | |||||
| Small Piece of Ore | Created | Smithing | 21 | 1 | Forge | Tarnished Rapier|1|Water Flask|1 | FALSE | Plz halp | |||||
| Small Piece of Ore | Created | Smithing | 21 | 2 | Forge | Tarnished Mining Pick|1|Water Flask|1 | FALSE | Plz halp | |||||
| Small Piece of Ore | Created | Smithing | 21 | 2 | Forge|Teir`Dal Forge | Tarnished Spear|1|Water Flask|1 | FALSE | Plz halp | |||||
| Small Piece of Ore | Vendor | Abysmal Sea | Snokin Breaksteel | @ 95, 275, 114 | FALSE |
| Plate Boot Template Mold | Vendor | Plane of Knowledge | Blacksmith Gerta |
| Plate Bracer Mold | Vendor | Plane of Knowledge | Blacksmith Gerta |
| Plate Bracer Template Mold | Vendor | Plane of Knowledge | Blacksmith Gerta |
| Plate Cloak Template Mold | Vendor | Plane of Knowledge | Blacksmith Gerta |
Last edited:
- Joined
- Feb 9, 2017
- RedCents
- 1,387¢
There are lots of databases out there from the emulator servers with item, merchant, tradeskill ect.
http://items.sodeq.org (might be useful, 13th floor item database) not sure how to use it.
Attachments
Last edited:
There is an items list or itemlist with all kindsa info, but specifically it has the ID and the Name.. which I can do some parsing magic I am sure.. to add a field to the current list and populate it.. but nothing that ties the item to the id to the vendor.. so far..
- Joined
- Feb 9, 2017
- RedCents
- 1,387¢
Not sure how accurate this would be with the newer content.
If you are talking just specific vendors it could be made. But to do the whole database of eq would be well...
If you are talking just specific vendors it could be made. But to do the whole database of eq would be well...
A POK vendor dump specific...
- Joined
- Feb 9, 2017
- RedCents
- 1,387¢
What fields do you want in it, VendorID|VendorName|ItemID|ItemName|Cost|LVL|Stackable
Ho Ho..
Well at least we can look up items by vendor from a SQL !!!!!
Well at least we can look up items by vendor from a SQL !!!!!
| ItemID | ItemName | VendorName | VendorZone |
34478 | Anthracite Coal | Blacksmith Gerta | Plane of Knowledge |
18113 | Armor and Weapons Guide | Blacksmith Gerta | Plane of Knowledge |
22077 | Axe Head Mold | Blacksmith Gerta | Plane of Knowledge |
62479 | Barb Mold | Blacksmith Gerta | Plane of Knowledge |
18112 | Basic Blacksmithing | Blacksmith Gerta | Plane of Knowledge |
63219 | Bastard Blade Mold | Blacksmith Gerta | Plane of Knowledge |
72054 | Bearing Mold | Blacksmith Gerta | Plane of Knowledge |
12042 | Belt Sectional Mold | Blacksmith Gerta | Plane of Knowledge |
34479 | Bituminous Coal | Blacksmith Gerta | Plane of Knowledge |
34475 | Black Nitrous Coal | Blacksmith Gerta | Plane of Knowledge |
48909 | Block of Crude Weapon Grade Ore | Blacksmith Gerta | Plane of Knowledge |
48918 | Block of Ductile Weapon Grade Ore | Blacksmith Gerta | Plane of Knowledge |
48912 | Block of Fair Weapon Grade Ore | Blacksmith Gerta | Plane of Knowledge |
129755 | Block of Glossy Weapon Grade Ore | Blacksmith Gerta | Plane of Knowledge |
60912 | Block of Indurate Weapon Grade Ore | Blacksmith Gerta | Plane of Knowledge |
135559 | Block of Luminescent Weapon Grade Ore | Blacksmith Gerta | Plane of Knowledge |
|
/declare dirstring string local ProgramData\RedGuides\DesktopUtility\MQ2\Live\Release\Macros\TSC\TCSDB.db
/sqlite query D:\${dirstring} itemquery SELECT * FROM ItemTable WHERE ItemID LIKE '11001%';
I know the answer is out there but if anyone knows the % to do the pathing so if people have MQ in C: D: E drive it defaults the pathing there.. not tied to a drive
sqlite's relative directory in Live is in the root of MQ2, just use relative paths. But the above assumes your macros are in the macros folder (which is editable).
I'd do what Nav does and make your own subfolder. So dir string would just be TCS\TCScore.db
I'd do what Nav does and make your own subfolder. So dir string would just be TCS\TCScore.db
- Joined
- Feb 9, 2017
- RedCents
- 1,387¢
Was messing with this myself.
SQL:
INSERT INTO `merchant` (`VendorName`, `ItemID`, `ItemName`, `Cost`, `Stackable`, `VendorZone`) VALUES
('Brewmaster Berina', '37977', 'Absinthe Glass', '0.104', '1000', Plane of Knowledge),
('Brewmaster Berina', '37978', 'Absinthe Spoon', '1.049', '1000', Plane of Knowledge),
('Brewmaster Berina', '13039', 'Ale', '0.031', '1000', Plane of Knowledge),
('Brewmaster Berina', '16590', 'Barley', '0.015', '1000', Plane of Knowledge),
('Brewmaster Berina', '16598', 'Bottle', '0.005', '1000', Plane of Knowledge),
('Brewmaster Berina', '39949', 'Brasse\'s Bitter Brew', '10.499', '20', Plane of Knowledge),
('Brewmaster Berina', '152556', 'Brewing Odds', '104.998', '1', Plane of Knowledge),
('Brewmaster Berina', '13034', 'Brandy', '0.078', '1000', Plane of Knowledge),
('Brewmaster Berina', '13817', 'Capt. Orlin\'s Spiced Ale', '0.052', '20', Plane of Knowledge),
('Brewmaster Berina', '13977', 'Carrot', '0.026', '1000', Plane of Knowledge),
('Brewmaster Berina', '16580', 'Cask', '0.031', '1000', Plane of Knowledge),
('Brewmaster Berina', '16851', 'Cork', '0.001', '1000', Plane of Knowledge),
('Brewmaster Berina', '33833', 'Distilled Essence of Fire', '10.499', '20', Plane of Knowledge),
('Brewmaster Berina', '13036', 'Dwarven Ale', '0.068', '1000', Plane of Knowledge),
('Brewmaster Berina', '13035', 'Elven Wine', '0.068', '1000', Plane of Knowledge),
('Brewmaster Berina', '12767', 'Emerald Orange', '0.068', '1000', Plane of Knowledge),
('Brewmaster Berina', '27970', 'Emerald Leaf Tea', '0.524', '1000', Plane of Knowledge),
('Brewmaster Berina', '13040', 'Fish Wine', '0.026', '1000', Plane of Knowledge),
('Brewmaster Berina', '13547', 'Freshly Cleaned Vegetables', '0.052', '20', Plane of Knowledge),
('Brewmaster Berina', '13037', 'Gnomish Spirits', '0.062', '1000', Plane of Knowledge),
('Brewmaster Berina', '16592', 'Grapes', '0.020', '1000', Plane of Knowledge),
('Brewmaster Berina', '13033', 'Honey Mead', '0.015', '20', Plane of Knowledge),
('Brewmaster Berina', '16591', 'Hops', '0.015', '1000', Plane of Knowledge),
('Brewmaster Berina', '17007', 'Large Box', '0.524', '1', Plane of Knowledge),
('Brewmaster Berina', '13976', 'Lettuce', '0.026', '1000', Plane of Knowledge),
('Brewmaster Berina', '81841', 'Making a Mixed Drink', '0.001', '1', Plane of Knowledge),
('Brewmaster Berina', '13008', 'Mead', '0.052', '1000', Plane of Knowledge),
('Brewmaster Berina', '16595', 'Malt', '0.015', '1000', Plane of Knowledge),
('Brewmaster Berina', '17906', 'Mixing Bowl', '0.010', '1', Plane of Knowledge),
('Brewmaster Berina', '18196', 'Natures Beverages', '0.104', '1', Plane of Knowledge),
('Brewmaster Berina', '41237', 'Nectar of the Green Fairy', '26.149', '1', Plane of Knowledge),
('Brewmaster Berina', '13038', 'Ogre Swill', '0.020', '1000', Plane of Knowledge),
('Brewmaster Berina', '16481', 'Packet of Kiola Sap', '0.115', '1000', Plane of Knowledge),
('Brewmaster Berina', '16565', 'Packet of Paeala Sap', '0.115', '1000', Plane of Knowledge),
('Brewmaster Berina', '6179', 'Paeala Bark', '1.889', '1000', Plane of Knowledge),
('Brewmaster Berina', '13030', 'Red Wine', '0.062', '1000', Plane of Knowledge),
('Brewmaster Berina', '16593', 'Rice', '0.073', '1000', Plane of Knowledge),
('Brewmaster Berina', '13018', 'Short Ale', '0.052', '1000', Plane of Knowledge),
('Brewmaster Berina', '13032', 'Short Beer', '0.015', '1000', Plane of Knowledge),
('Brewmaster Berina', '16599', 'Shotglass', '0.078', '1000', Plane of Knowledge),
('Brewmaster Berina', '41238', 'The Drink of Timeless Energy', '26.249', '1', Plane of Knowledge),
('Brewmaster Berina', '12791', 'Timorous Coconut', '0.062', '1', Plane of Knowledge00),
('Brewmaster Berina', '96811', 'Tomato', '0.001', '1000', Plane of Knowledge),
('Brewmaster Berina', '13979', 'Turnip', '0.026', '1000', Plane of Knowledge),
('Brewmaster Berina', '75847', 'Unusual Wine and Ale - Part 1', '0.001', '1', Plane of Knowledge),
('Brewmaster Berina', '75848', 'Unusual Wine and Ale - Part 2', '0.001', '1', Plane of Knowledge),
('Brewmaster Berina', '13006', 'Water Flask', '0.010', '1000', Plane of Knowledge),
('Brewmaster Berina', '13001', 'White Wine', '0.062', '1000', Plane of Knowledge),
('Brewmaster Berina', '16597', 'Wine Yeast', '0.010', '1000', Plane of Knowledge),
('Brewmaster Berina', '16596', 'Yeast', '0.015', '1000', Plane of Knowledge),
('Chef Denrun', '13039', 'Ale', '0.031', '1000', Plane of Knowledge),
('Chef Denrun', '14220', 'Allspice', '0.524', '1000', Plane of Knowledge);
/*!40000 ALTER TABLE `merchant` ENABLE KEYS */;
Last edited:
here we goo..
/sqlite query \macros\TSC\TCSDB.db itemquery SELECT * FROM ItemTable WHERE ItemID LIKE '11001%';
/sqlite query \macros\TSC\TCSDB.db itemquery SELECT * FROM ItemTable WHERE ItemID LIKE '11001%';
\macros isn't a relative directory. That's an absolute directory and it means "The root of the drive this is running from." If you wanted the macros part to be hardcoded (which you shouldn't, because people can change their macros directory) then leave off the first slash. /sqlite query macros\TCS\TCS.db
I believe /mac tsc bake..
but wait there's more..
/sqlite query \macros\TSC\TCSDB.db rq SELECT * FROM RecipeTable
INNER JOIN RecipeComponentTable ON RecipeTable.RecipeID = RecipeComponentTable.RecipeID
INNER JOIN ItemTable ON RecipeComponentTable.ItemId = ItemTable.ItemID
INNER JOIN VendorTable ON ItemTable.ItemId = VendorTable.ItemID
WHERE RecipeTable.RecipeID = 16905;
/sqlite query \macros\TSC\TCSDB.db rq SELECT * FROM RecipeTable
INNER JOIN RecipeComponentTable ON RecipeTable.RecipeID = RecipeComponentTable.RecipeID
INNER JOIN ItemTable ON RecipeComponentTable.ItemId = ItemTable.ItemID
INNER JOIN VendorTable ON ItemTable.ItemId = VendorTable.ItemID
WHERE RecipeTable.RecipeID = 16905;
This is correct. Thank you!
np
I also did notice for clump of dough you can use a bunch of items.. and they have different yields.. which brings up another problem to solve, or bury my head somewhere..
Spitballin:
RecipeID = 1234 RecipeName = Clump Of Dough
RecipeComponents
Bottle of Milk
Cup Of Flour
Snake Egg
Dragon Egg
Free-Range Egg
Cockatrice Egg
Match to source..
if source is vendor GOOOOOD
if source is foraged.. iterate..
Match ItemID to YieldTable
whatever one we find in inventory.. use it.. and get yield count..
YieldTable:
ItemID Dragon Egg 17
ItemID Snake Egg 1
ItemID Free-Range Egg 1
ItemID Cockatrice Egg 42
of course we could just do a source table that provides ALL for vendors and everything else...
source is vendor - buy it
source is farmed, do we have any of the farmed items?
Kinda involved.. but hey.. why are we here.. and kinda dangerous.. if Dragon Eggs are a premium and you are just turning them into batter.. bad juju
Which then brings about the need to have a list that only allows the usage of non-rared items..
aghh!
Last edited:
- Joined
- Feb 9, 2017
- RedCents
- 1,387¢
I understand 2.8 is old news, however being really interested in this project and the work you have done here I have learned a great bit about the depth of your madness. This is a copy of what I envisioned this macro to do the first time I ran it. It will start out and shop for all of your kits needed, run through the god quests and switch out kits with any empty bag in the bottom right corner (slot 32), then proceed to finish the research and get the trophy quests. All of the recipes were modified (except Alchemy, Tinkering and Toxicology)to make enough items needed for the trophy with a 66% fail rate on anything with a trivial of 45 or above. I changed all of the references of Poison to Toxicology and changed all the short names to match the trophy quests such as pois to toxicology and alch to alchemy etc. I added mats to the help section to list everything that needs farmed or foraged. jb321 you have done some pretty amazing work here out of goodness and I for one much appreciate it. Minor changes and a great learning experience. I am looking forward to what you are doing with the new version. Thanks again for sharing to the community.
Well as you may have noticed TCS 1.0 was Brewing 300 Macro (your macro) / Rooster Tradeskill.mac which turned into GOD Brew.
I like solving logic problems more than pathing issues..
I also make lots of spaghetti code that somehow works, and then I go back in an deconstruct it and throw stuff out, and it somehow still works..
This DB effort should have been done from the get go.. I made a lot of routines to stay compliant and true to Roosters original vision for TS files and how they were read..
which spawned some pretty clever routines, but was over-engineered for a final solution..
That all being said..
We are heading into a new era.. with data structure and more symmetry, peace, and serenity
The TSC_POR is a template to handle all tradeskill tasks that show up in the quest journal.. We can always work around the who and where, but the main effort will be buying, making the item, and delivery..
TSC_Shoplist could use some sprucing..
TSC_Travel could do with some love..
TSC_POK needs medical assistance..
TSC_TSS could work towards the rest of the CR freebies, but I am an anti-pather.. so we will see on this one..
TSC_Support needs a broom
GOD and Core are well I guess some of the less dirty files..
- Joined
- Feb 9, 2017
- RedCents
- 1,387¢
I got a toon finishing up with the research and headed to get trophy quests on v2.9 then gonna pop the files you posted above experimental release and try running all the trophies. wish me luck. haha
sorry, 2.8 or something like that. I don't know why i keep calling it 2.9 haha
sorry, 2.8 or something like that. I don't know why i keep calling it 2.9 haha
- Status