Need some assistance on the following

01/13/2009 11:07 ratson#1
Ned help on how to change the following:

1. VIP status in account, it always start at 4. How to change it to 0 or normal.

2. In the dropitemrule, what does the following do and values can be used: (need some explanation)

- id
- groupid
- ruleid
- chance
- item0 ~ 14

3. In the cq_goods, what does the values in itemtype means? And what are their equivalent meaning.


Thanks for the assistance.
01/13/2009 17:34 dani-filth0#2
Quote:
Originally Posted by ratson View Post
Ned help on how to change the following:

1. VIP status in account, it always start at 4. How to change it to 0 or normal.

2. In the dropitemrule, what does the following do and values can be used: (need some explanation)

- id
- groupid
- ruleid
- chance
- item0 ~ 14

3. In the cq_goods, what does the values in itemtype means? And what are their equivalent meaning.


Thanks for the assistance.
1 - go to cq_accounts or it may be accounts that on navicat , then select the player and scroll to right untill u find VIP then change it to the lvl u want to , if u need all start at vip lvl 1 just set the default of the vip to 1

2- chance : is the chance that this monster drop the items u've added into item# , make it 50000 for good drop rate ,
and about item0 - 14 that is the items u need monsters to drop u can add the id of 270 EO card to drops it or whatever u ned the drop , u better use query , cuz its hard to change every thing there
if u need the query , just go to helping center or search it , its already posted

- groupid , that is the group of monsters , like lizard normal , refindBoss , Unique Boss , EliteBoss
sry i dont know what is ID and ruleid , cuz i dont have my db atm
01/14/2009 02:56 ratson#3
Thanks dani, manage to fondle around the Mysql and found something to make the VIP to normal to all and manual set to people I just need to give.

Here is what I did:

1. Open account using mysql
2. Click ctrl+D or file->design table on the tool menu
3. this will open a new tab design table
4. look for VIP, and click on the gray bar on the left side of its name
5. on default add 0 or what vip level you would like to start
6. then click save and close design table

*note do not add or change other values inside the table besides the default. Also you can change the starting gold inhand and on storage, use same process in cq_user. do not edit the emoney it will crash the EO.

Anyone know the remaining question on my thread?

1. In the dropitemrule, what does the following do and values can be used: (need some explanation)

- id
- groupid (what are the values for lizard normal and so on)
- ruleid

2. In the cq_goods, what does the values in itemtype means? And what are their equivalent meaning.


Thanks for any assistance.