[Question] Super gears changed to Elite gears

03/13/2010 03:31 [GM]Death[PM]#1
Alright quick question. I'm using the candy db/client. With in the shopping mall are three different type of noobie packs you could say. +30, +60, +155. When you open the pack they come out as super. Could someone please tell me how to change them to Elite. So it will be easier to add stats to users by name once they upgrade the quality.
03/13/2010 03:50 King_Arthur#2
Check out the 501 lines and look at the data field. The last number in a equipment will tell you the quality. 4 - Super | 3 - Elite.
03/13/2010 09:35 [GM]Death[PM]#3
Okay, So I was not successful at changing it. Could you go into a little bit more details?
03/13/2010 11:57 magewarior2#4
Code:
6000552	6000553	0	501	41000[COLOR="Red"]4[/COLOR]	
6000553	6000554	0	501	13100[COLOR="red"]4[/COLOR]	
6000554	6000555	0	501	12100[COLOR="red"]4[/COLOR]	
6000555	6000556	0	501	11100[COLOR="red"]4[/COLOR]	
6000556	6000557	0	501	16100[COLOR="red"]4[/COLOR]	
6000557	6000558	0	501	14100[COLOR="red"]4[/COLOR]
Code:
6000552	6000553	0	501	41000[COLOR="SeaGreen"]3[/COLOR]	
6000553	6000554	0	501	13100[COLOR="SeaGreen"]3[/COLOR]	
6000554	6000555	0	501	12100[COLOR="SeaGreen"]3[/COLOR]	
6000555	6000556	0	501	11100[COLOR="SeaGreen"]3[/COLOR]	
6000556	6000557	0	501	16100[COLOR="SeaGreen"]3[/COLOR]	
6000557	6000558	0	501	14100[COLOR="SeaGreen"]3[/COLOR]
03/14/2010 02:02 [GM]Death[PM]#5
Would you mind making it into a query. Cant seem to find where its located. o.O
03/14/2010 02:10 King_Arthur#6
These lines will be located in cq_action. If your newbie gift isn't at 6000552 then a query wont help because the query wont point to your newbie gift.
03/14/2010 02:37 [GM]Death[PM]#7
It isnt showing up in the cq_action. Okay so they are coming out as elite as I wanted them to. But, Once you relog some if not all of the gears disappear. Would the gears not being in the cq_action have something to do with that?
03/14/2010 03:40 King_Arthur#8
Go to your newbie gift in cq_itemtype and copy the id from the id_action field. Open your cq_action to that id and you should see everything.
03/14/2010 03:50 [GM]Death[PM]#9
Okay problem solve. Thank you for your help.