New Features list

[mlopez34]

Stable - 1000 rep reward - more pets, better fetch, train pets to race - pets can eat tacos or other food from green house, can race every 10 days.

Temple - 5000 rep reward - thanking, and sorrying have chance to give recipes to be - ( able to craft specific items ), starts with rares, upgrade to ancients, upgrade to amulets - 24H CD

upgrade Stable Temple and Green House = 5k rep reward

25k Rep reward = reduce the cost of all items in the shop by 20%

Green House - Regular shop 10,000 tacos , harvest requires shears 1k tacos, plant uses soil, upgrade with wood and rocks etc, create potions, cakes, cookies to eat, collect fruits, and flowers/plants - CONSUMABLES

Disassemble - Available if you have a hacksaw - buy from rep shop 1k Rep - 10000 tacos can find keystones 5-7 here

Fishing - Fishing rod from the shop - 5000 tacos - no rep

RPG points will reset and be turned into tacos

RPG points should be resetting every month. they can be turned in for special items such as amulets, unique rares, unique ancients, unique pets, keystones 1-4 - Rep Shop 1k

Keystones 9 + can only drop from their respective challenges

[mlopez34]

-crafting -initialize recipes when bot starts -upgrade buildings -bakings include suppress HP amulets -visual representations of buildings -dissasemble -armaments -keystones -artifacts uses outside RPG -rpg normal expansion -rpgpoints work like honor in v-wow -fishing/race/feed

[mlopez34]

upgrade :

UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock the Stable - Unlock first slot available for pets' WHERE id = 1;
UPDATE "public"."upgradeprod" SET levelinfo = 'Your pets can participate in races - N Y I' WHERE id = 2;
UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock second slot available for pets' WHERE id = 3;
UPDATE "public"."upgradeprod" SET levelinfo = 'On fetch your pets can find items based on the RPG area you are in' WHERE id = 4;
UPDATE "public"."upgradeprod" SET levelinfo = 'Pets have a chance to deal 5% of your damage dealt to your target' WHERE id = 5;
UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock third slot available for pets' WHERE id = 6;
UPDATE "public"."upgradeprod" SET levelinfo = 'Max stat for pets is increased to 150 - N Y I ' WHERE id = 7;
UPDATE "public"."upgradeprod" SET levelinfo = 'Pets have a chance to find seeds when fetching' WHERE id = 8;
UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock fourth slot available for pets' WHERE id = 9;
UPDATE "public"."upgradeprod" SET levelinfo = 'Max stat for pets is increased to 200 - N Y I' WHERE id = 10;
UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock slot 6 for RPG' WHERE id = 11;
UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock fifth slot available for pets' WHERE id = 12;

UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock the Greenhouse - Unlock first nine plots to plant your seeds' WHERE id = 13;
UPDATE "public"."upgradeprod" SET levelinfo = 'Able to create RPG increasing stat potions from your harvested crops' WHERE id = 14;
UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock three extra plots to plant your seeds' WHERE id = 15;
UPDATE "public"."upgradeprod" SET levelinfo = 'Able to bake RPG increasing stat cookies from your harvested crops' WHERE id = 16;
UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock three extra plots to plant your seeds' WHERE id = 17;
UPDATE "public"."upgradeprod" SET levelinfo = 'Reinforced fences - Plots can be harvested for up to 20 times instead of 10' WHERE id = 18;
UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock three extra plots to plant your seeds' WHERE id = 19;
UPDATE "public"."upgradeprod" SET levelinfo = 'Able to bake RPG increasing stat cookies from your harvested crops' WHERE id = 20;
UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock three extra plots to plant your seeds' WHERE id = 21;
UPDATE "public"."upgradeprod" SET levelinfo = 'Able to bake RPG increasing stat cakes from your harvested crops' WHERE id = 22;
UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock three extra plots to plant your seeds' WHERE id = 23;
UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock slot 7 for RPG' WHERE id = 24;

UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock the temple - Able to purchase a hacksaw from the shop' WHERE id = 25;
UPDATE "public"."upgradeprod" SET levelinfo = 'Thanking or Sorrying grants the tagged user tacos based on your level x5' WHERE id = 26;
UPDATE "public"."upgradeprod" SET levelinfo = 'Thanking or Sorrying Bender gives a chance at learning a new crafting recipe - Able to craft Rare quality items' WHERE id = 27;
UPDATE "public"."upgradeprod" SET levelinfo = 'Disassembling has a chance to find elemental crystals from rare items' WHERE id = 28;
UPDATE "public"."upgradeprod" SET levelinfo = 'Disassembling has a chance to find elemental crystals from ancient items' WHERE id = 29;
UPDATE "public"."upgradeprod" SET levelinfo = 'Unlock slot 5 for RPG' WHERE id = 30;
UPDATE "public"."upgradeprod" SET levelinfo = 'Thanking or Sorrying Bender gives a chance at learning two new crafting recipe' WHERE id = 31;
UPDATE "public"."upgradeprod" SET levelinfo = 'Able to craft Ancient quality items' WHERE id = 32;
UPDATE "public"."upgradeprod" SET levelinfo = 'Disassembling has a chance to find elemental crystals from artifact items' WHERE id = 33;
UPDATE "public"."upgradeprod" SET levelinfo = 'Able to craft Artifacts and Amulets' WHERE id = 34;
UPDATE "public"."upgradeprod" SET levelinfo = 'Thanking or Sorrying Bender gives a chance at learning three new crafting recipes' WHERE id = 35;
UPDATE "public"."upgradeprod" SET levelinfo = 'Able to craft items of level requirement 40 or higher' WHERE id = 36;

[mlopez34]

CREATE RPG leveling mechanism

CREATE potions recipes in recipes table CREATE potions items in items table CREATE crafting recipes in recipes table

CREATE new items for lvl 5, 10, 15, 20, 25, 30, 35 CREATE items found in area specific CREATE items found on boss specific CREATE items found on challenge specific CREATE items found on keystone specific UPDATE building requirements

CREATE map

IMPORT all users to new tables using create user functions ADD holy candle to all users above 5k rep ADD 10% of rpgpoints as tacos to everyone RESET rpgpoints to 0 ADD rpglevel SET all users to rpglevel 0

End of season rewards:

-unique pets
-unique achievements
-unique ancient item
-unique amulet

[mlopez34]

INSERT INTO "public"."itemsprod"(itemname, itemdescription, itemslot, itemstatistics, itemraritycategory, itemraritypercentage, itemshortname,  amuletsource, hppluspercentage )
VALUES('Apple Pie', 'Delicious apple pie', 'consumable', 'increase your rpg HP by 1% in any RPG started within the next hour', 'uncommon+', 0, 'applepie', 'rpgbuff', 1 )