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

[cyberghoser1]

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

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):

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 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

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

to

[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

[mama12]

Thanks , you r the best. It is awsome you are back!!!

[Knight^Hawk]

Theres alot easier way

do a filter data 725518

then change the data field to the item u want to give out to the new players

Note: for the newbie gift you well need to set it up first. ie.. Diablo69rs' release above.

have fun guys.

[.Ash]

Welcome back brotha and Good Job

[magewarior2]

why not just add a new param? instead of changing the one`s of the letter`s ..

[cyberghoser1]

Because i just forgot my old method

[T.h.u.n.d.e.r]

i have aproplem the Shelley's Letter and Queen`s Letter dont appears with the newcomer so when i add the Newbue gift its wont appears as it replaced with the letters so what to do =/ ?!?!

[bani8874]

hai.. i want change starter level to 1 back..

[reloaded90]

thanks master

[s7ns035sog]

Man i just created my server from guide

and my files the cq_itemtype and those arent same as yours myn is just symbols which i dont understand anything of so how do i get the same as yours ? and are those files in mysql?

[deadmaker999]

just copy and past the Quary he gives you into the Quary section, that should correct it..

[deltajunior]

hey Guys, ive got a Question..
could some1 fix me the Query so theres also Elementary with it?

thanks