Request about element gear

[fixways]

First Say Hello

Person that im tag : SoulNecturn
I know in your server has this this thing right ?

GearBoxI ( After right will get this )

Bonus : +12
F-Soul : 8
Air Attack : +12
Water Attack : +12
EarthAttack : +12
FireAttack : +12

I wonder how you do that ? can you teach us please ? i have try but its only for bonus not elementry , because cq_itemtype doest have air_attack1 colum , it only in cq_item . I Hope you will teach me master , thanks.

[stedabest321]

You would have to add it... in an action to make them come out like that...

[no_1]

Originally Posted by stedabest321

You would have to add it... in an action to make them come out like that...

talking about this? ACTION_ITEM_ADD = 501, // increase goods.data=itemtype_id, param= " amount_limit ident gem1 gem2 magic1 magic2 magic3 data warghostexp gemtype availabletime "

This doesn't work for adding element to gears.

[fixways]

Originally Posted by no_1

talking about this? ACTION_ITEM_ADD = 501, // increase goods.data=itemtype_id, param= " amount_limit ident gem1 gem2 magic1 magic2 magic3 data warghostexp gemtype availabletime "

This doesn't work for adding element to gears.

Hmm , yes i have check it . Its not by cq_action because cq_action only for bonus and f-soul , im wondering how soul necturn do it Hope someone will answer this thread as well.

#Bump

[haizamlee]

anybody wanna share it with us ?

[fixways]

bump, funhacker,mage warrior or other ? help us please

[magewarior2]

Originally Posted by fixways

bump, funhacker,mage warrior or other ? help us please

try this

INSERT INTO `cq_action` VALUES ('70000524', '70000525', '70000539', '1001', '0', 'profession == 10');
INSERT INTO `cq_action` VALUES ('70000525', '70000526', '0000', '0502', '1021083', '');
INSERT INTO `cq_action` VALUES ('70000526', '70000527', '0000', '0501', '440244', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000527', '70000528', '0000', '0501', '165134', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000528', '70000529', '0000', '0501', '135154', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000529', '70000530', '0000', '0501', '145154', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000530', '70000531', '0000', '0501', '125154', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000531', '70000532', '0000', '0501', '115154', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000532', '70000533', '0000', '1010', '2005', 'Congratulations! You got your Super+12 Items!');
INSERT INTO `cq_action` VALUES ('70000533', '0', '0000', '0506', '0', '1021083 1021083 1');
INSERT INTO `cq_action` VALUES ('70000539', '70000540', '70000547', '1001', '0', 'profession == 20');
INSERT INTO `cq_action` VALUES ('70000540', '70000541', '0000', '0502', '1021083', '');
INSERT INTO `cq_action` VALUES ('70000541', '70000542', '0000', '0501', '420244', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000542', '70000543', '0000', '0501', '161134', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000543', '70000544', '0000', '0501', '131154', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000544', '70000545', '0000', '0501', '141154', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000545', '70000546', '0000', '0501', '121154', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000546', '70000532', '0000', '0501', '111154', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000547', '70000548', '0000', '1001', '0', 'profession == 30');
INSERT INTO `cq_action` VALUES ('70000548', '70000549', '0000', '0502', '1021083', '');
INSERT INTO `cq_action` VALUES ('70000549', '70000550', '0000', '0501', '490244', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000550', '70000551', '0000', '0501', '163134', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000551', '70000552', '0000', '0501', '133144', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000552', '70000553', '0000', '0501', '143154', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000553', '70000554', '0000', '0501', '123144', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000554', '70000532', '0000', '0501', '113144', '0 0 0 18 18 0 0 12 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('70000520', '70000521', '70000522', '0508', '0', '6 0 50');
INSERT INTO `cq_action` VALUES ('70000521', '70000524', '70000523', '0508', '0', '1 0 52');
INSERT INTO `cq_action` VALUES ('70000522', '0000', '0000', '1010', '2005', 'Please~leve~6~free~invetory~slots');
INSERT INTO `cq_action` VALUES ('70000523', '0000', '0000', '1010', '2005', 'asks~your~excellency~to~recognize~that~the~Eudemons~egg~knapsack~has~1~space,~because~we~will~deliver~a~lovable~baby~to~give~yo');
INSERT INTO `cq_itemtype` VALUES ('1021083', 'Top12Gears', '0', '0', '0', '0', '0', '0', '0', '0', '17', '0', '0', '70000520', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '120000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

something i found...

it is possible it is with no elements... if so... let me know

[Gekru]

That wont add the elements to the gear. The 18's in the query is the gem, the 12 is the + bonus, the 1024 is the fsoul.

[magewarior2]

Originally Posted by Gekru

That wont add the elements to the gear. The 18's in the query is the gem, the 12 is the + bonus, the 1024 is the fsoul.

have you tried the query?

[Gekru]

I don't need to try the query, I know what it does. Anyone who has studied the cq_action table would know what it does.

[fixways]

yea,its only add bonus,f-soul.

[pretzel666]

Mages query will work just fine , all yous have to do is add eud. atk into the values ._. dont complain

[magewarior2]

its because i have no database i cannot test it myself ... maybe you should see in cq_item and from gems see what table`s there are...

fill the 0 in 12 where you think there must be air atk ect..


you will find it!

good luck.

[Khalidmadkour]

old post and no answer :O

[stedabest321]

There is no way of making items +255 Element using Action lines, if you only have +255 available for donors or from a quest item, what ever... Then you can use a code as a bat file to actually make all +255 Gears in your server Element +255 for example

UPDATE `cq_item` SET `ident`='4', `eudemon_attack1`='255', `eudemon_attack2`='255', `eudemon_attack3`='255', `eudemon_attack4`='255', `special_effect`='8' WHERE (`magic3`='255')

This will make Every Item in the server that is +255, Element +255

Meanings -
ident`='4' Makes your item indestructible
eudemon_attack1
eudemon_attack2
eudemon_attack3
eudemon_attack4 - Are all your +255 elements

to make this run auto you can simply put it all into a bat file for example
i will upload the SQL version of it and the bat file for it

make sure you right click the batfile and open in note pad and edit where need to and remove where need to. then you can run the batfile in the Task scheduler. Easy