Request

[m2r007]

i need a favor guy's
i need to know how to add xp potions and pk potions to my DB

[cyberghoser1]

[King_Arthur]

"Request" is not a good thread title. Consider taking a look at this helpful sticky to assist you in future thread naming situations:

As for your request, if you are looking for exp potions to increase the amount of exp you receive, then ignore the rest of this post and look at cyber's link. If you are looking for xp potions and pk potions then take a look at this:

[m2r007]

thanks guy but i mean Xp potions And PK potions that brings ur xp skill and lower Ur pk points i saw it once .
i tried to search about it but i didn't find it .
Do u know about it how to add it to Cq_action . cq_goods and cq_item type.
and so on .
It'd be great and thanks for u great effort.

[cyberghoser1]

not hard to do, this is xp booster:

INSERT INTO `cq_action` VALUES ('100000010', '100000011', '0000', '0502', '1021082', '0');
INSERT INTO `cq_action` VALUES ('100000011', '0000', '0000', '1001', '0', 'xp += 100');
INSERT INTO `cq_itemtype` VALUES ('1021082', 'XP_Booster', '0', '0', '0', '0', '0', '0', '0', '0', '28', '0', '30000000', '100000010', '0', '0', '0', '0', '0', '0', '0', '1', '300', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '20000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_goods` VALUES ('10000001', '1207', '1021082', '0');
INSERT INTO `cq_task` VALUES ('100000010', '100000010', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');

ItemMinIcon.ani

[Item1021082]
FrameAmount=1
Frame0=data/ItemMinIcon/721550.dds

MapItemIcon.ani

[1021082]
FrameAmount=1
Frame0=data/ItemMinIcon/721550.dds


Create an item in itemtype.dat with new id starting with 1021082 stackable not repairable, monopoly 28 min amount 1 max 300
Id action 100000010 and EPCost 20000

Note: i use stackable item for this you can avoid and use amount min and max 1

[m2r007]

thanks m8
and pk potions r the same too right

[cyberghoser1]

This is PK Dropper Potion:

INSERT INTO `cq_action` VALUES ('9960030', '9960031', '9960032', '1001', '0', 'pk += -100');
INSERT INTO `cq_action` VALUES ('9960031', '9960033', '0000', '1001', '0', 'pk += -100');
INSERT INTO `cq_action` VALUES ('9960032', '0000', '0000', '0126', '0', 'You~don\'t~have~100~pk~points~yet.');
INSERT INTO `cq_action` VALUES ('9960033', '9960034', '0000', '0126', '0', 'Congratz!~you~have~reduced~your~pk~points.');
INSERT INTO `cq_action` VALUES ('9960034', '9960035', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,0,0,0,729021,0,0');
INSERT INTO `cq_action` VALUES ('9960035', '0000', '0000', '0498', '729021', '0');
INSERT INTO `cq_itemtype` VALUES ('729021', 'PkPotion', '0', '0', '0', '0', '0', '0', '0', '0', '28', '0', '5000000', '9960030', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_goods` VALUES ('729021', '1207', '729021', '0');

ItemMinIcon

[Item729021]
FrameAmount=1
Frame0=data/ItemMinIcon/721043.dds

MapItemIcon

[729021]
FrameAmount=1
Frame0=data/MapItemIcon/721043.dds

For itemtype.dat use the cq_itemtype above to create the item with the same values with Funhacker's Tool.

[m2r007]

thanks cyberghoser1
1 last question
which tabel's to clean if i want to remove the booth's and the castle's price's
i tried many times and every time i try they still the same high price's .
do u know which table to clean

[cyberghoser1]

play with those two commands:

Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0 where ownerid > 9999;
Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0, price = initial_price, deposit = 0 where ownerid > 9999;