Request

04/20/2010 18:31 m2r007#1

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

04/20/2010 18:43 cyberghoser1#2

[Only registered and activated users can see links. Click Here To Register...]

04/20/2010 19:45 King_Arthur#3

"Request" is not a good thread title. Consider taking a look at this helpful sticky to assist you in future thread naming situations: [Only registered and activated users can see links. Click Here To Register...]

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: [Only registered and activated users can see links. Click Here To Register...]

04/20/2010 21:26 m2r007#4

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.:handsdown::handsdown:

04/20/2010 21:33 cyberghoser1#5

not hard to do, this is xp booster:

Code:

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

04/21/2010 15:50 m2r007#6

thanks m8
and pk potions r the same too right ;)

04/21/2010 18:57 cyberghoser1#7

This is PK Dropper Potion:

Code:

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.

04/22/2010 17:30 m2r007#8

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
;)
:handsdown::handsdown::handsdown:

04/22/2010 20:23 cyberghoser1#9

play with those two commands:

Code:

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;