Request about element gear

07/27/2012 02:48 fixways#1
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. ;)
07/27/2012 13:47 stedabest321#2
You would have to add it... in an action to make them come out like that... :)
07/28/2012 19:57 no_1#3
Quote:
Originally Posted by stedabest321 View Post
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.
08/04/2012 14:29 fixways#4
Quote:
Originally Posted by no_1 View Post
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
09/16/2012 08:19 haizamlee#5
anybody wanna share it with us ?
09/28/2012 17:44 fixways#6
bump, funhacker,mage warrior or other ? help us please
10/03/2012 00:02 magewarior2#7
Quote:
Originally Posted by fixways View Post
bump, funhacker,mage warrior or other ? help us please
try this

Code:
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 ;)
10/03/2012 00:23 Gekru#8
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.
10/03/2012 11:15 magewarior2#9
Quote:
Originally Posted by Gekru View Post
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?
10/03/2012 12:24 Gekru#10
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.
10/03/2012 13:03 fixways#11
yea,its only add bonus,f-soul.
10/03/2012 15:33 pretzel666#12
Mages query will work just fine , all yous have to do is add eud. atk into the values ._. dont complain
10/03/2012 15:37 magewarior2#13
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.
05/07/2017 05:59 Khalidmadkour#14
old post and no answer :O
05/09/2017 10:42 stedabest321#15
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