[Question]Update cq_item through action ?

03/23/2011 00:10 T.h.u.n.d.e.r#1
Hello , any body know if it possible to update cq_item through cq_action , lets say this line 4 examble cant be goes through cq_action instead of updating ?
Quote:
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '9' where player_id=32 and position=1
03/24/2011 12:24 ~*Kronic*~#2
I'm not sure on this but I don't beleive it's possible to change the stats of an item after it's been made through cq_action unless your using the hardcoded stuff like stone upgrade.. if anyone knows of a way to do this I would be interested in the answer to :)
03/24/2011 20:15 magewarior2#3
maybe study on this

Code:
		ACTION_ITEM_HOLE = 504, // weapon burrow.the param support “ChkHole HoleNum” or " MakeHole HoleNum ", Num is 1 or 2
		ACTION_ITEM_REPAIR = 505, // equips the repair.data is assigns the equipment the position.
		ACTION_ITEM_MULTIDEL = 506, // deletes many kinds of goods, param is “idType0 idType1 num”, namely deletes num idType0-idType1 the goods.
		ACTION_ITEM_MULTICHK = 507, // examines many kinds of goods, param is “idType0 idType1 num”, namely examines num idType0-idType1 the goods.
		ACTION_ITEM_LEAVESPACE = 508, // inspection knapsack surplus space.param="space weight packtype"
													// packtype value scope is 50 ~ 53
													// 50:Ordinary goods knapsack
													// 51:Evil spirit soul gem knapsack
													// 52:Imaginary beastly egg knapsack
													// 53:Imaginary beastly knapsack

		ACTION_ITEM_UPEQUIPMENT = 509, // equips the operation, the param form is " cmd position ", 
													// cmd support " up_lev ", “up_quality”, “recover_dur”
													// position is equips the position, the definition is as follows
													/* ITEMPOSITION_HELMET = 1;
														ITEMPOSITION_NECKLACE = 2;
														ITEMPOSITION_ARMOR = 3;
														ITEMPOSITION_WEAPONR = 4;
														ITEMPOSITION_WEAPONL = 5;
														ITEMPOSITION_RINGR = 6;
														ITEMPOSITION_RINGL = 7;
														ITEMPOSITION_SHOES = 8;
														ITEMPOSITION_MOUNT = 9*/

		ACTION_ITEM_EQUIPTEST = 510, // goods quality restriction, 
													// param “equip_pos cmd opt num”, 
													// equip_pos with on position definition, 
													// cmd support " level ", “quality”, “durability”, “max_dur”
													// opt support " ==, >=, <= ",
													when // num is the data, cmd is " durability " and " max_dur ", -1 is the maximum value
		ACTION_ITEM_EQUIPEXIST = 511, // equips the existence examination, data is equips the position
		ACTION_ITEM_EQUIPCOLOR = 512, // equipment color change, param = “equip_pos color”, equip_pos supports as follows
													/* ITEMPOSITION_HELMET = 1;
														ITEMPOSITION_ARMOR = 3;
														ITEMPOSITION_WEAPONL = 5; */// ITEMPOSITION_WEAPONL must be the shield only then has an effect
		ACTION_ITEM_FIND = 513, // searches goods, type has in user iterator.data=itemtype_id.Or data is the thing commodity name which the 0, param expression must search.
		ACTION_ENCASH_CHIP = 514, // changes money with the chip, Qian Shu in Item Data field
08/25/2011 20:14 moroccan#4
hi i deleted everything on cq_item exept my weapons and when i buy something and den log off and den log back on its not there any more help please ??