[Help]Reward

[linja12]

where can i change Trivia,family,Pk reward?

[funhacker]

Originally Posted by linja12

where can i change Trivia,family,Pk reward?

Just change the cq_action associated with the reward item.

[linja12]

but Im cant find where is cq_action all these

[funhacker]

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

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:

select id from cq_user where name = 'INSERT_CHARACTER_NAME';

run the following (using the previous code result)

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

[Eurion]

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.

[linja12]

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