Help to Changing PKT Prize

[corey88]

How do I change the prize PKT?
Anyone have any query?
the item ID is "742806"
For those who can help me thank you.

Att Corey88

[King_Arthur]

Look at the action id for that item you mentioned in cq_item. Find that id in cq_action then look at the action that follows it. You will see the 501 lines that award other items. Change the data field of those 501s to the items you want to give for that prize. Pretty basic stuff there.

[PraDevil[ELITE]]

or u can use a simple query to find it

SELECT * FROM `cq_action` where type=501 and data=742806;

[magewarior2]

Originally Posted by PraDevil

or u can use a simple query to find it

SELECT * FROM `cq_action` where type=501 and data=742806;

Nice msql command 0.0

[King_Arthur]

Originally Posted by PraDevil

or u can use a simple query to find it

SELECT * FROM `cq_action` where type=501 and data=742806;

That may work if you only want to give one prize and no choice on the prize. Normally pk prizes are in a box and you are given the two or three choices with as many as 6 items in any given choice.

[corey88]

Thanks, I managed to solve my problem