Help to Changing PKT Prize

04/05/2010 03:00 corey88#1

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:cool:

04/05/2010 05:13 King_Arthur#2

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.

04/05/2010 08:08 PraDevil[ELITE]#3

or u can use a simple query to find it;)

Code:

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

04/05/2010 12:37 magewarior2#4

Quote:
Originally Posted by PraDevil
or u can use a simple query to find it;)
Code:
SELECT * FROM `cq_action` where type=501 and data=742806;

Nice msql command 0.0 :bandit:

04/05/2010 15:29 King_Arthur#5

Quote:
Originally Posted by PraDevil
or u can use a simple query to find it;)
Code:
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.

04/05/2010 17:31 corey88#6

Thanks, I managed to solve my problem