inserts

[mlopez34]

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasecdr, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2, specialability)

VALUES ('Master Loincloth', 'Master version of the Loincloth - loincloth created for the leader of the ogre council', 'belt', 'reduce cooldown of thank by 55%, 50% chance to get 6 tacos, 6 taco per level', 'rare+++', 0, 55, 50, 6, 6, 'thank', 'loinclothmaster', 170, 15, 93, 198, 198, 'tacoheal', 'protect', 'replenish' )

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2)

VALUES ('Master Hiker Boots', 'Master Hiker Boots', 'feet', 'on fetch 80% chance to get 71 tacos, +7 tacos per level', 'rare+++', 0, 80, 71, 7, 'fetch', 'hikerhmaster', 287, 20, 20, 281, 281,'recover', 'empower' )

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2, abovetacoslots)

VALUES ('Refined Sunglasses', 'Refined Sunglasses', 'head', 'on slots win above 2500 tacos, 20% chance to get 500 tacos, +80 taco per level', 'rare+++', 0, 20, 500, 80, 'slots', 'sunglassesmaster', 233, 15, 15, 384, 72, 'drain', 'weaken', 2500)

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2)

VALUES ('Refined Camo Pants', 'Refined Camo Pants', 'legs', 'on scavenge 10% chance to get 32 tacos, +39 tacos per level', 'rare+++', 0, 10, 32, 39, 'scavenge', 'camomaster', 269,20,20,305,   305, 'slash', 'cripple')

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2, specialability )

VALUES ('Master Bandana', 'Master version of the Bandana - You are now the most wanted bandit.', 'head', 'on fetch 10% chance to get 78 tacos, +102 tacos per level', 'rare+++', 0, 10, 78, 102, 'fetch', 'bandanamaster', 174, 103, 15, 234, 92, 'tacowall', 'elixir', 'megaelixir')

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2 )

VALUES ('Master Headset', 'Master Headset', 'head', 'on rpg success 20% chance to get 150 tacos, +69 taco per level x difficulty', 'rare+++', 0, 20, 150, 69, 'rpg', 'headsetmaster', 165, 97, 15,  93, 284, 'revive', 'scold' )

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2 )

VALUES ('Master Stilettos', 'Master Stilettos', 'feet', 'on rpg success 80% chance to get 21 tacos, +17 taco per level x difficulty', 'rare+++', 0, 80, 21, 17, 'rpg', 'stilettosmaster', 278, 20, 20, 78, 508, 'haste', 'freeze' )

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2, experiencegain)

VALUES ('Refined Polyester Blouse', 'Refined version of the Polyester Blouse - The red carpet is at waiting for you', 'chest', 'on sorry 60% chance to get 33 tacos, +20 tacos per level, +13 experience', 'rare+++', 0, 60, 33, 20, 'sorry', 'polyestermaster', 172, 15, 101, 91, 251, 'poison', 'barrier', 13 )

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2 )

VALUES ('Master Thug Shirt', 'Master version of the Thug Shirt - The most extravagant shirt.', 'chest', 'on thank 30% chance to get 31 tacos, +19 tacos per level', 'rare+++', 0, 30, 31, 19, 'thank', 'thugmaster', 181, 101, 15, 240, 81, 'poke', 'freeze' )

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2 )

VALUES ('Master Jeans', 'Master version of the Jeans - Designer brand jeans for the grand taco finder.', 'legs', 'on cook 20% chance to get 320 extra tacos, +215 tacos per level', 'rare+++', 0, 20, 320, 215, 'cook', 'jeansmaster', 189, 15, 80, 272, 141, 'bandaid', 'curse' )

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2, specialability )

VALUES ('Master Running Shoes', 'Master version of the Running Shoes - you are now the fastest man in town', 'feet', 'on prepare 50% chance to get 310 tacos, +165 taco per level', 'rare+++', 0, 50, 310, 165, 'prepare', 'runningmaster', 185, 84, 15, 199, 199, 'haste', 'tacoheal', 'replenish' )

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2 )

VALUES ('Master Explorers Wristbands', 'Master Explorers Wristbands', 'wrist', 'on scavenge 80% chance to get 20 tacos, +3 taco per level', 'rare+++', 0, 80, 20, 3, 'scavenge', 'explorermaster', 141, 15, 128, 185, 91, 'iceshards', 'protect' )

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2 )

VALUES ('Master Turban  ', 'Master Turban', 'head', 'on prepare 10% chance to get 750 tacos, +1200 taco per level', 'rare+++', 0, 10, 750, 1200, 'prepare', 'turbanmaster', 135, 15, 131, 75, 199, 'flameblast', 'weaken' )

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2, abovetacoslots )

VALUES ('Master Yoga Pants', 'Master Yoga Pants', 'legs', 'on slots win above 2500 tacos, 50% chance to get 150 tacos, +75 taco per level', 'rare+++', 0, 50, 150, 75, 'slots', 'yogamaster', 184, 99, 15, 160, 160, 'tackle', 'assist', 2500 )

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2 )

VALUES ('Master Trousers', 'Master Trousers', 'legs', 'on rpg success 50% chance to get 50 tacos, +33 taco per level x difficulty', 'rare+++', 0, 50, 50, 33, 'rpg', 'trousersmaster', 184, 15, 91, 97, 272, 'curse', 'shield')

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2, abovetacoslots )

VALUES ('Master Handcuffs', 'Master Handcuffs', 'wrist', 'on slots win above 2500 tacos, 30% chance to get 250 tacos, +75 taco per level', 'rare+++', 0, 30, 250, 75, 'slots', 'handcuffsmaster', 198, 15, 97, 149, 149, 'shock', 'scold', 2500)

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2 )

VALUES ('Master Leather Cuffs', 'Master Leather Cuffs', 'wrist', 'on fetch 65% chance to get 104 tacos, +9 tacos per level', 'rare+++', 0, 65, 104, 9, 'fetch', 'leathermaster', 168, 15, 97, 267, 109, 'nourish', 'freeze')

INSERT INTO "public"."itemsprod" (itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasetacochance, itembaseextratacos, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2, amuletsource )

VALUES ('Improved Knife', 'used for eating tacos and starting something', 'weapon', 'on thank 50% chance to get 50 tacos', 'uncommon+', 0, 50, 50, 'thank', 'shortsimproved', 38, 47, 0, 42,    42, 'barrier', 'stab', 'shopitem')

[mlopez34]

INSERT INTO "public"."itemsprod"(itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasecdr, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, experiencegain, itemimage, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2, specialability)

VALUES('Hayyims Enchanted Boots of the Grand Magus', 'But my vans lime green, yea, Im flyer than a space ship', 'feet', 'reduce cooldown on cook by 60%, 90% chance to get 110 tacos, 41 tacos per level, +245 experience', 'ancient+++', 0, 60, 90, 110, 41, 'cook', 'magus', 245, 'https://i.imgur.com/aDXApJE.jpg', 223, 10, 220, 141, 431, 'shock', 'iceshards', 'flare' )

INSERT INTO "public"."itemsprod"(itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasecdr, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, guaranteedtacos, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2, specialability)

VALUES('Priams Impenetrable Faceplate ', 'Improved version of the Hectors Conquering War Helm - Infused with fortitude by Apollo', 'head', 'reduce cooldown on scavenge by 50%, 25% chance to get 2 taco, +6 tacos per level. 40 guaranteed tacos', 'ancient+++', 0, 50, 25, 2, 6, 'scavenge', 'priam', 40, 379, 35, 35, 984, 223, 'rockthrow', 'shield', 'earthquake' )

[mlopez34]

INSERT INTO "public"."itemsprod"(itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itembasecdr, itembasetacochance, itembaseextratacos, itemextratacosperlevel, command, itemshortname, hpplus, attackdmgplus, magicdmgplus, armorplus, spiritplus, ability1, ability2, specialability)

VALUES('Boots of the Maleficent Witch', 'cursed are those who wear these laVish boots', 'feet', 'reduce cooldown on sorry by 55%, 20% chance to get 170 tacos, +110 tacos per level', 'ancient+++', 0, 55, 20, 170, 110, 'sorry', 'maleficent', 254, 230, 10, 288, 147, 'tackle', 'freeze', 'replenish' )

[mlopez34]

INSERT INTO "public"."itemsprod"(itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itemshortname,  amuletsource, magicdmgpluspercentage )
VALUES('Banana Cookie', 'Delicious Banana Cookie', 'consumable', 'increase your magic damage by 1% in any RPG started within the next hour', 'uncommon+', 0, 'bananacookie', 'rpgbuff', 1 );

INSERT INTO "public"."itemsprod"(itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itemshortname,  amuletsource, attackdmgpluspercentage )
VALUES('Banana Cake', 'Delicious Banana Cake', 'consumable', 'increase your attack damage by 1% in any RPG started within the next hour', 'uncommon+', 0, 'bananacake', 'rpgbuff', 1 );

INSERT INTO "public"."itemsprod"(itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itemshortname,  amuletsource, armorpluspercentage )
VALUES('Tangerine Sundae', 'Delicious Tangerine Sundae', 'consumable', 'increase your armor by 1% in any RPG started within the next hour', 'uncommon+', 0, 'tangerinesundae', 'rpgbuff', 1 );

INSERT INTO "public"."itemsprod"(itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itemshortname,  amuletsource, spiritpluspercentage )
VALUES('Chocolate Cookie', 'Delicious Chocolate Cookie', 'consumable', 'increase your spirit by 1% in any RPG started within the next hour', 'uncommon+', 0, 'chocolatecookie', 'rpgbuff', 1 );

INSERT INTO "public"."itemsprod"(itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itemshortname,  amuletsource, luckpluspercentage )
VALUES('Brownie', 'Delicious Brownie', 'consumable', 'increase your luck by 1% in any RPG started within the next hour', 'uncommon+', 0, 'brownie', 'rpgbuff', 1 );

INSERT INTO "public"."itemsprod"(itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itemshortname,  amuletsource, critpluspercentage )
VALUES('Banana Pudding', 'Delicious Banana Pudding', 'consumable', 'increase your crit rating by 1% in any RPG started within the next hour', 'uncommon+', 0, 'bananapudding', 'rpgbuff', 1 );

INSERT INTO "public"."itemsprod"(itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itemshortname,  amuletsource )
VALUES('Wedding Cake', 'Delicious Wedding Cake', 'consumable', 'collectible wedding cake', 'uncommon+', 0, 'weddingcake', 'rpgbuff');

#####

INSERT INTO "public"."itemsprod"(itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itemshortname,  amuletsource, critpluspercentage )
VALUES('Cupcake', 'Delicious Cupcake', 'consumable', 'increase your crit rating by 1% in any RPG started within the next hour', 'uncommon+', 0, 'cupcake', 'rpgbuff', 1 );

INSERT INTO "public"."itemsprod"(itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itemshortname,  amuletsource, critpluspercentage )
VALUES('Cupcake', 'Delicious Cupcake', 'consumable', 'increase your crit rating by 1% in any RPG started within the next hour', 'uncommon+', 0, 'cupcake', 'rpgbuff', 1 );

[mlopez34]

INSERT INTO "public"."itemrecipeprod"(itemid, recipename, recipeshortname, tacos, reputationlevel, fruit1name, fruit1count, fruit2name, fruit2count, fruit3name, fruit3count, craftinglevel, type, dayavailable )
VALUES(288, 'Brownie Recipe', 'brownie', 220, 2, 'bananas', 5, 'tangerines', 2, 'eggplants', 3, 10, 'baking', 6);

INSERT INTO "public"."itemrecipeprod"(itemid, recipename, recipeshortname, tacos, reputationlevel, fruit1name, fruit1count, fruit2name, fruit2count, fruit3name, fruit3count, craftinglevel, type, dayavailable )
VALUES(289, 'Banana Pudding Recipe', 'bananapudding', 350, 3, 'bananas', 50, 'tangerines', 20, 'eggplants', 30, 10, 'baking', 7);

INSERT INTO "public"."itemrecipeprod"(itemid, recipename, recipeshortname, tacos, reputationlevel, fruit1name, fruit1count, fruit2name, fruit2count, fruit3name, fruit3count, craftinglevel, type, dayavailable )
VALUES(290, 'Wedding Cake Recipe', 'weddingcake', 15000, 3, 'bananas', 500, 'tangerines', 200, 'eggplants', 300, 30, 'baking', 16);

INSERT INTO "public"."itemrecipeprod"(itemid, recipename, recipeshortname, tacos, reputationlevel, fruit1name, fruit1count, fruit2name, fruit2count, fruit3name, fruit3count, craftinglevel, type, dayavailable )
VALUES(291, 'Cupcake Recipe', 'cupcake', 220, 2, 'eggplants', 3, 'hibiscuses', 10, 'apples', 2, 10, 'baking', 8);

INSERT INTO "public"."itemrecipeprod"(itemid, recipename, recipeshortname, tacos, reputationlevel, fruit1name, fruit1count, fruit2name, fruit2count, fruit3name, fruit3count, craftinglevel, type, dayavailable )
VALUES(292, 'Pear Dumpling Recipe', 'peardumpling', 220, 2, 'hibiscuses', 5, 'apples', 2, 'eggplants', 3, 10, 'baking', 9);

INSERT INTO "public"."itemrecipeprod"(itemid, recipename, recipeshortname, tacos, reputationlevel, fruit1name, fruit1count, fruit2name, fruit2count, fruit3name, fruit3count, craftinglevel, type, dayavailable )
VALUES(293, 'Donut Recipe', 'donut', 220, 2, 'bananas', 5, 'apples', 2, 'tangerines', 3, 10, 'baking', 10);