[GUIDE]Adding a new item

Hello,It's me again Necron33 with a new guide
This Guide Tells you how to add a new item including everything(Client,Action,Itemtype).
Making Items is divided to:-DataBase,Client
DataBase:-cq_itemtype,cq_action(if you wanna make action).
Client:-Itemtype.dat,shop.dat(if you want to add it in any shop),ItemMinIcon.ani,MapItemIcon.ani
We will begin with DataBase,I will make a EPCard680,which is going to give players(I will explain how to make the items for excat levels,Vip levels)
Most important Thing is cq_itemtype we will go and write this:-

Code:

680EPCard
INSERT INTO `cq_itemtype` (`id`,`name`,`req_profession`,`level`,`req_level`,`req_sex`,`req_force`,`req_dex`,`req_health`,`req_soul`,`monopoly`,`weight`,`price`,`id_action`,`attack_max`,`attack_min`,`defense`,`magic_atk_min`,`dodge`,`life`,`mana`,`amount`,`amount_limit`,`ident`,`gem1`,`gem2`,`magic1`,`magic2`,`magic3`,`magic_atk_max`,`magic_def`,`atk_range`,`atk_speed`,`hitrate`,`monster_type`,`target`,`able_mask`,`exp_type`,`emoney`,`official1`,`official2`,`official3`,`official4`,`official5`,`official6`,`official7`,`official8`,`official9`,`official10`,`official11`,`soul_value`) VALUES ('829680','EPCard680','0','0','0','0','0','0','0','0','0','0','25000','9999000','0','0','0','0','3000','0','0','1','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2500','0','0','0','0','0','0','0','0','0','0','0','0')

Code:

YourItem:-
INSERT INTO `cq_itemtype` (`id`,`name`,`req_profession`,`level`,`req_level`,`req_sex`,`req_force`,`req_dex`,`req_health`,`req_soul`,`monopoly`,`weight`,`price`,`id_action`,`attack_max`,`attack_min`,`defense`,`magic_atk_min`,`dodge`,`life`,`mana`,`amount`,`amount_limit`,`ident`,`gem1`,`gem2`,`magic1`,`magic2`,`magic3`,`magic_atk_max`,`magic_def`,`atk_range`,`atk_speed`,`hitrate`,`monster_type`,`target`,`able_mask`,`exp_type`,`emoney`,`official1`,`official2`,`official3`,`official4`,`official5`,`official6`,`official7`,`official8`,`official9`,`official10`,`official11`,`soul_value`) VALUES ('ITEMID','ITEMNAME','0','0','0','0','0','0','0','0','0','0','PRICE','ACTIONID','0','0','0','0','3000','0','0','1','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','PriceinEPS','0','0','0','0','0','0','0','0','0','0','0','0')

Code:

Columns Means
ID=ItemID(Random)
name=ItemName
req_profession=Class Required to use the item
level=Item Level
req_level=Level required to use the item
req_sex=Sex required to use the item(for myself i didn't ever change it here didn't change with me)
req_force=Unknown
req_dex=dexentry required to use the item
req_health=HP required to use the item
req_soul=MANA required to use the item
monopoly=Unknown
weight=Unknown(didn't make a change with me to change it)
price=Item price in gold
id_action=the first id of the item action in cq_action
attack_max/min=Max and mini attack(have to match in itemtype.dat)
defense=Defense!
magic_atk_min/max=min/max Magic Attack(have to match up with the one in itemtype.dat)
dodge=dodge number.
life=HP which the item can add
mana=MANA which the item can add
Amount=Amount of items
amount_limit=Max amount of items can be put in one place
ident=Unknown
gem1=First gem in the first socket
gem2=Second ----------Second------
magic1&2=Unknown
magic3=Bonus on the item
atk_range=Unknown
atk_speed=Speed of Attacking
hitrate=Hitrate!
monster_type=Cq_monstertype ID(Used mostly when creating new eudemons)
emoney=Price in EPS

Code:

INSERT INTO `cq_action` (`id`,`id_next`,`id_nextfail`,`type`,`data`,`param`) VALUES ('9999903','0','0','1085','0','gmlog/action_log 380,%user_name[%user_id],0,0,0,3800,0,729017,0,0')
INSERT INTO `cq_action` (`id`,`id_next`,`id_nextfail`,`type`,`data`,`param`) VALUES ('9999902','9999903','0','126','0','Congratulations!You~recived~680~EudemonPoints!!')
INSERT INTO `cq_action` (`id`,`id_next`,`id_nextfail`,`type`,`data`,`param`) VALUES ('9999901','9999902','0','1001','0','e_money += 680')
INSERT INTO `cq_action` (`id`,`id_next`,`id_nextfail`,`type`,`data`,`param`) VALUES ('9999900','9999901','0','502','829680','')

**DB Done(thats for the very first stuff (newbies ones,pro ones are much harder :P)**
Client Side(so simple):-
Just go to itemtype.dat open it with the new itemtype.dat tool and Add Item.
now go to ani/ItemMinIcon.ani and write like this

Code:

//EPCard680
[Item829680]
FrameAmount=1
Frame0=data/ItemMinIcon/829680.dds

Code:

//YourItem
[Item+ITEMID]
FrameAmount=1
Frame0=data/ItemMinIcon/FileName.dds

then off to ani/MapItemIcon.ani

Code:

//EPCard680
[829680]
FrameAmount=1
Frame0=data/MapItemIcon/829680.dds

Code:

//YourItem
[ITEMID]
FrameAmount=1
Frame0=data/MapItemIcon/FileName.dds

Now just create their icons & puff your items are ready
Icons must be (W/H=64/64,Hor/Ver=72/72 dpi) and in dds make it first in jpg then convert it using ImageConverterPlus
Thanks would be good :P
my Next Guide will be adding Eudemons ( with client side & DB explained).