Creating a "starting pack"

Post Reply
Ragonz
Site Admin
Posts: 669
Joined: Sat Apr 20, 2013 11:16 pm

Creating a "starting pack"

Post by Ragonz » Tue May 10, 2016 10:22 pm

WARNING THIS IS OUTDATED NOW AND FOLLOWING THE BELOW MAY BREAK YOUR DATABASE


To make new characters start with useful items just run this query on your sql database.

Code: Select all

DELIMITER #
CREATE TRIGGER `character_after_insert` AFTER INSERT ON `character` FOR EACH ROW BEGIN
   SET @sack = f_createContainer(NEW.RootContainerID, 459, 0);
   SET @temp = f_insertNewItemInventory(@backpack, 33, 100, 1, 50000, 50000, '', 0,0,0,0, 0,0); /* sickle */
   SET @temp = f_insertNewItemInventory(@backpack, 31, 100, 1, 50000, 50000, '', 0,0,0,0, 0,0); /* shovel */
   SET @temp = f_insertNewItemInventory(@backpack, 36, 100, 1, 50000, 50000, '', 0,0,0,0, 0,0); /* saw */
   SET @temp = f_insertNewItemInventory(@backpack, 216, 100, 1, 50000, 50000, '', 0,0,0,0, 0,0); /* knife */
   SET @temp = f_insertNewItemInventory(@backpack, 32, 100, 1, 50000, 50000, '', 0,0,0,0, 0,0); /* hammer */
   SET @temp = f_insertNewItemInventory(@backpack, 48, 100, 1, 50000, 50000, '', 0,0,0,0, 0,0); /* pickaxe */
   SET @temp = f_insertNewItemInventory(@backpack, 46, 100, 1, 50000, 50000, '', 0,0,0,0, 0,0); /* hatchet */
   SET @temp = f_insertNewItemInventory(@backpack, 773, 100, 1, 50000, 50000, '', 0,0,0,0, 0,0); /* horse */
   SET @temp = f_insertNewItemInventory(@backpack, 974, 50, 25, 50000, 50000, '', 0,0,0,0, 0,0); /* 25x q50 Apple Buns */
   SET @temp = f_insertNewItemInventory(@backpack, 299, 50, 1, 15000, 15000, '', 0,0,0,0, 0,0); /* simple clothes */
END #

Please note that any sql manipulation can be dangerous and we cannot be held responsible if you break your server.
Grab a game server from us by clicking the picture below
Image
Got an issue? Submit a Support Ticket

Post Reply

Return to “Life is Feudal”