[Guide]Spawn Newbie Gift on newcomer inventory(replace method)!

Hello again, i want to show you how to add the newbie gift to the inventory of a new user without adding any npc or add the item to any shop.

Ok let's start.

When u login for the first time you will see in your inventory two not needed items:

Shelley's Letter
Queen`sLetter

Those two items are totally useless so we are gonna to replace them with the newbie gift. Newbie Gift item id is 729012

Part one: Get the ID's of those two items

Shelley's Letter ID: 724021
Queen`sLetter ID: 724007

Here for the example we will use Shelley's Letter with ID 724021

Part two: Database edit:

Now we have to change the id of the newbie gift to the one used by Shelley's Letter so we only delete Shelley's Letter item id from cq_itemtype and replace the id of the newbie gift with the one Shelley's Letter is using

Code:

delete from `cq_itemtype` where id = '724021';
UPDATE `cq_itemtype` SET `id`='724021' WHERE (`id`='729012');

Now here is the cq_action released by Diablo69r for the newbie gift and edited by me to use the id number we replaced above (You can see in red the item id used):

Code:

delete from cq_action where id >= 6000524 and id <= 6000532;
delete from cq_action where id >= 6000539 and id <= 6000546;
delete from cq_action where id >= 6000547 and id <= 6000554;



INSERT INTO `cq_action` VALUES ('6000524', '6000525', '6000539', '1001', '0', 'profession == 10');
INSERT INTO `cq_action` VALUES ('6000525', '6000526', '0000', '0502', '[COLOR="Red"]724021[/COLOR]', '');
INSERT INTO `cq_action` VALUES ('6000526', '6000527', '0000', '0501', '440244', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000527', '6000528', '0000', '0501', '135114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000528', '6000529', '0000', '0501', '115114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000529', '6000530', '0000', '0501', '125114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000530', '6000531', '0000', '0501', '145114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000531', '6000532', '0000', '0501', '165094', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000532', '0', '0000', '1010', '2005', 'Congratulations! You got your Super+255 Gift Items!');
INSERT INTO `cq_action` VALUES ('6000539', '6000540', '6000547', '1001', '0', 'profession == 20');
INSERT INTO `cq_action` VALUES ('6000540', '6000541', '0000', '0502', '[COLOR="Red"]724021[/COLOR]', '');
INSERT INTO `cq_action` VALUES ('6000541', '6000542', '0000', '0501', '420244', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000542', '6000543', '0000', '0501', '131114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000543', '6000544', '0000', '0501', '111114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000544', '6000545', '0000', '0501', '121114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000545', '6000546', '0000', '0501', '141114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000546', '6000532', '0000', '0501', '161094', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000547', '6000548', '0000', '1001', '0', 'profession == 30');
INSERT INTO `cq_action` VALUES ('6000548', '6000549', '0000', '0502', '[COLOR="Red"]724021[/COLOR]', '');
INSERT INTO `cq_action` VALUES ('6000549', '6000550', '0000', '0501', '163094', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000550', '6000551', '0000', '0501', '143114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000551', '6000552', '0000', '0501', '133114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000552', '6000553', '0000', '0501', '123114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000553', '6000554', '0000', '0501', '113114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000554', '6000532', '0000', '0501', '490244', '0 0 0 18 18 0 0 255 0 1024 0 0');

Part three: Client edits.

Now we have to deal with the client side, which is very easy.

Go get [Only registered and activated users can see links. Click Here To Register...] by Funhacker and open your itemtype.dat file located in the ini folder of your client (make a backup in case you screw it up)

Once the items list is filled, search for the id 724021 and change it to an id that doesn't exist, click on change item stats and now search for the newbie gift item id which is 729012, change its id to 724021, click on change item stats, save itemtype.dat file, your'e done!

To change the look of the item edit ItemMinIcon.ANI and MapItemIcon.ANI with a text editor and find/replace those lines on both files and its done.:
Change

Code:

[Item724021]
FrameAmount=1
Frame0=data/ItemMinIcon/724000.dds

Code:

[Item724021]
FrameAmount=1
Frame0=data/ItemMinIcon/729000.dds

Why this method?

Because i forgot how to add newcomers items on inventory long time ago and i don't like to have a lot of cq_actions on the login to give me all the gears and weapon inside my inventory, so i use one of those two items that are useless. I'm sure there are easier or better methods but at least this one works!

Bug: if you do use the item and get your equipment, after re-log the newbie gift is again there if you don't level up