[Help]Reward

04/02/2012 20:44 linja12#1

where can i change Trivia,family,Pk reward? :)

04/02/2012 22:30 funhacker#2

Quote:

Originally Posted by linja12

where can i change Trivia,family,Pk reward? :)

Just change the cq_action associated with the reward item.

04/03/2012 01:27 linja12#3

but Im cant find where is cq_action all these

04/03/2012 04:10 funhacker#4

well it can be complex selecting "all" the action lines of a single item using just mysql

but I can give you the following that will select the id of the first line which you can then follow from there

Code:

select id_action from cq_itemtype where id = INSERT_ITEMTYPE_ID;

if you're unsure of the item's ID do the following:

empty all items from your inventory EXCEPT the PK prize item

run the following:

Code:

select id from cq_user where name = 'INSERT_CHARACTER_NAME';

run the following (using the previous code result)

Code:

select TYPE from cq_item where player_id = PREVIOUS_RESULT and owner_id = PREVIOUS_RESULT and position = 50;

04/03/2012 04:15 Eurion#5

WisdomPouch (ItemId 729062) = ActionId = 8500100
AcumenPouch (ItemId 729063) = ActionId = 8500120
LorePouch (ItemId 729064) = ActionId = 8500140

WeeklyPkBagB (ItemId 729082) = ActionId = 5400400
WeeklyPkBagC (ItemId 729083) = ActionId = 5400430
WeeklyPkBagD (ItemId 729084) = ActionId = 5400460
WeeklyPkBagE (ItemId 729085) = ActionId = 5400490
MonthlyPkBagB (ItemId 729086) = ActionId = 5400520
MonthlyPkBagC (ItemId 729087) = ActionId = 5400550
MonthlyPkBagD (ItemId 729088) = ActionId = 5400580
MonthlyPkBagE (ItemId 729089) = ActionId = 5400600

Those are the items I found regarding this.

04/03/2012 05:56 linja12#6

Woah TQ all. Eurion. what is item ID for PKBag A ? my Db in chinese.