[Help]fix Bug Equiment Level?

11/30/2009 20:17 matrix89#1
I need help here...
i want to know how to fix it..
i just want make higher lvl is 125 only...
what the db make this..
and where line can i delete it...

[Only registered and activated users can see links. Click Here To Register...]
11/30/2009 22:03 .Ash#2
i believe you got more than lvl 125 equips in your itemtypes..
12/01/2009 06:31 funhacker#3
you can either set the req_lev for the higher level gear to 125 or < 125
Or you can delete it from your database all together.

No I do not have the IDs

but if you used this:


Select All gear above lvl125

select id from cq_itemtype where req_lev > 125;


Delete All gear above lvl125

delete from cq_itemtype where req_lev > 125;


Change all gear above lvl125 to level 125

update cq_itemtype set req_lev = 125 where req_lev = 125;
12/01/2009 10:00 matrix89#4
Quote:
Originally Posted by funhacker View Post
you can either set the req_lev for the higher level gear to 125 or < 125
Or you can delete it from your database all together.

No I do not have the IDs

but if you used this:


Select All gear above lvl125

select id from cq_itemtype where req_lev > 125;


Delete All gear above lvl125

delete from cq_itemtype where req_lev > 125;


Change all gear above lvl125 to level 125

update cq_itemtype set req_lev = 125 where req_lev = 125;
Yes .. but I can not find it equiment level above 125
12/01/2009 11:33 PraDevil[ELITE]#5
take a look at cq_itemtype column req_level lolz
12/02/2009 13:55 magewarior2#6
Quote:
Originally Posted by funhacker View Post
you can either set the req_lev for the higher level gear to 125 or < 125
Or you can delete it from your database all together.

No I do not have the IDs

but if you used this:


Select All gear above lvl125

select id from cq_itemtype where req_lev > 125;


Delete All gear above lvl125

delete from cq_itemtype where req_lev > 125;


Change all gear above lvl125 to level 125

update cq_itemtype set req_lev = 125 where req_lev = 125;
if the item is for level +200 and your req_lev is on 125 ...

people of 125 also can wear it ??

or do that need to check on itemtype.dat?
12/02/2009 14:05 matrix89#7
Lol..my itemtype.dat get a problem when edit it....
so hard to use hexeditor
12/02/2009 15:50 funhacker#8
Quote:
Originally Posted by magewarior2 View Post
if the item is for level +200 and your req_lev is on 125 ...

people of 125 also can wear it ??

or do that need to check on itemtype.dat?
If you don't match with cq_itemtype then it won't allow you to wear the gear.

Basicaly requirements work like so


Check Itemtype.dat Requirements -> Send Request -> Check cq_itemtype requirements -> decide to equip/use
12/03/2009 13:22 magewarior2#9
Quote:
Originally Posted by funhacker View Post
If you don't match with cq_itemtype then it won't allow you to wear the gear.

Basicaly requirements work like so


Check Itemtype.dat Requirements -> Send Request -> Check cq_itemtype requirements -> decide to equip/use
but than all equipment for +level 125 is just on level 125 ...
12/03/2009 14:41 sandolkakos#10
If you still dont fixed this problem, look in cq_itemaddition (DB side) and ItemAddition.ini (Client Side).

I dont know if this can help you, but i have tried ^^
12/03/2009 18:09 Eurion#11
Quote:
Originally Posted by sandolkakos View Post
If you still dont fixed this problem, look in cq_itemaddition (DB side) and ItemAddition.ini (Client Side).

I dont know if this can help you, but i have tried ^^
That file controls your bonus' on your equipment such as +1 +2 +3 +4.....
12/03/2009 18:15 sandolkakos#12
Quote:
Originally Posted by Eurion View Post
That file controls your bonus' on your equipment such as +1 +2 +3 +4.....
I think that this file and Table too control Level Upgrade and Quality Upgrade. ^^
12/03/2009 18:57 Eurion#13
I would say you're incorrect, If you look into the file, you'll notice that it has nothing that would control the levels of the items.

Code:
id = Unique Id
typid = cq_itemtype id
level = bonus level, default is 1-12
life = additional life added
attack_max = additional max attk
attack_min = additional min attk
defense = additional def
mgcatk_max = additional max magic attk
mgcatk_min = addition min magic attk
magic_def = additional magic defense
dexterity = additional dexterity
dodge = additional dodge
As you can see, nothing there would control the level of the item such as 125, 130, 150 and so on.
12/03/2009 19:01 tazzy#14
Quote:
Originally Posted by sandolkakos View Post
I think that this file and Table too control Level Upgrade and Quality Upgrade. ^^
hmm ... so, which is which
12/03/2009 19:30 sandolkakos#15
Quote:
Originally Posted by Eurion View Post
I would say you're incorrect, If you look into the file, you'll notice that it has nothing that would control the levels of the items.

Code:
id = Unique Id
typid = cq_itemtype id
level = bonus level, default is 1-12
life = additional life added
attack_max = additional max attk
attack_min = additional min attk
defense = additional def
mgcatk_max = additional max magic attk
mgcatk_min = addition min magic attk
magic_def = additional magic defense
dexterity = additional dexterity
dodge = additional dodge
As you can see, nothing there would control the level of the item such as 125, 130, 150 and so on.
i speak this, cause i put New Equips Paladin 480000 at 480244

and if i dont put the Configs in cq_itemaddtion and in ItemAddition.ini,
The NPCs dont accept the New Equips in Quality and Level Upgrads.

but, if i am unsure, please sorry ;)