[Help] Shaiya EP5 Drop

[TumbsUp]

Hey i changed all drops in Database.
So when i spawn ehm for example Dentatus.

He dropp Mystras Wep/Gear box for 100%.

But when i spawn Dentatus( and i kill them 3-5 times) he doesent drop

Any1 know how i can change them or must i change in client?


sincerly


FirstClass [***]

[RebeccaBlack]

Did you restart after?

Also, grades 999+ don't work.

[Alladrios]

Check the grade of your boxes and make sure the value is < 1000 or it wont drop.

[TumbsUp]

k i try it and yes i restarted

[TumbsUp]

Yes Grade is over 999 but grade is the item ID or?

How can i fix that?

[Alladrios]

Grade is located on your item table, every single item has a grade.

[Sinful858]

No the grade is a category that you can place specific items to drop in. Its like saying "grade 1" is OP hammer, recreation runes, and Sonic lapis and "grade 2' is 30day conti, lucky charm" Well lets see OP hammer is ItemId 100 82 so you go and find the ItemId in the dbo.Items list. Well you would scroll all the way over to the right and you will see the "Grade" Column

Now if the grade is set to "999" or anything above it, it will not work if you add it to your dbo.mobitems list. Well 999 might work but I "HIGHLY" do not recommend it!
Ok so you want to make your own grade that is not in with 50 other items right? A simply Query you can do is

select * from ps_gamedefs.dbo.items
where grade= ' grade number 1-999'
Press Execute

So lets say you look for grade 507:

select * from ps_gamedefs.dbo.items
where grade= '507'
Execute

This will display any and all items that are categorized in this grade. If you see nothing under it you can easily change the grade of your OP hammer (Itemid 100 82) from say '999' to '507' Then just add the grade number '507' to the dbo.mobitems list (mob id) and set the % and you are good to go. i will post a query you can use it's rather very simple to use rather then skimming up and down that long list of items.

UPDATE ps_gamedefs.dbo.items
SET Grade= '0'
WHERE ItemID= '0'
OR ItemID= '0'
OR ItemID= '0'
OR ItemID= '0'
OR ItemID= '0'
OR ItemID= '0'

SET grade= 'grade u want'
WHERE ItemId= 'itemId you want to put into the new grade'
OR ItemId= 'another ItemId you wanna add etc'

Hope this made sense.

[TumbsUp]

can change it to /for example\ to 0021 or so?









P.S: I dont begging but any1 has a mob.item table they ready, only normal drops like dentatus ...

[KeyTor]

Hello there i sent you a message

[Svinseladden]

HI. thanks for this. but i have to change all mobs in ep5. is there a query that change the dbo.mobitems list too? i have like 75 i have to change from lets say 1107 - 998 or something like that. is there a query i can use?

or do i realy have to scroll up and down and look/change all manualy?

[RebeccaBlack]

You mean change a range of mobs?

You could use this for a range:

UPDATE PS_GameDefs.dbo.MobItems
SET Grade=0,DropRate=0
WHERE MobID BETWEEN 1 AND 60

Would get all the mobs with an ID between 1 and 60

or, if it's an odd range, like 1, 6, 8, 31...

UPDATE PS_GameDefs.dbo.MobItems
SET Grade=0,DropRate=0
WHERE MobID IN (1, 6, 8, 31)

or maybe I misunderstood what you're trying to do... if so, disregard this post.

[Svinseladden]

heya. no i have lets say 75 mobs that drop the same grade. that grade is atm 1107 and i have changed everything i9n 1107 to 998. now i have 75 mobs i need to change drop from grade 1107 to 998. i need a query for that. i tried:

UPDATE ps_gamedefs.dbo.items
SET Grade= '998'
WHERE Grade= '1107'

just for fun. but that didn't help much:-(

[RebeccaBlack]

in the MobItems table? You'd need to switch PS_GameDefs.dbo.Items to PS_GameDefs.dbo.MobItems and it should work fine.

[Svinseladden]

this is what i did:

i did the:

select * from ps_gamedefs.dbo.items
where grade= ' 998 ' and that was emty.

i then did the select * from ps_gamedefs.dbo.items
where grade= ' 1107 '

and put in all those items there in:

UPDATE ps_gamedefs.dbo.items
SET Grade= '998'
WHERE ItemID= 'itemid'
OR ItemID= 'itemid'
OR ItemID= 'itemid'
OR ItemID= 'itemid'
OR ItemID= 'itemid'
OR ItemID= 'itemid'

now in mobitem i have 75 or more mobs that still drop 1107 that i now need to change to 998.

PS: i have alot above 999 i need to change, i just want a easy way to change them to a working grade.

i can do the same too all of them but if i have to manualy change all of them in the mobitem list that will take weeks or something he he he

[castor4878]

Originally Posted by Svinseladden

this is what i did:

i did the:

select * from ps_gamedefs.dbo.items
where grade= ' 998 ' and that was emty.

i then did the select * from ps_gamedefs.dbo.items
where grade= ' 1107 '

a numerical value is NOT a string, and only string shall be simple-quoted.
so these 2 statements are "invalid" (they work but just because MSSQL try & success to convert your strings to numbers, this useless step SHALL be avoided).

Originally Posted by Svinseladden

and put in all those items there in:

UPDATE ps_gamedefs.dbo.items
SET Grade= '998'
WHERE ItemID= 'itemid'
OR ItemID= 'itemid'
OR ItemID= 'itemid'
OR ItemID= 'itemid'
OR ItemID= 'itemid'
OR ItemID= 'itemid'

is it supposed to have a sense ?!? that's not irony ! it's really meaningless.

Assuming " 'itemid' " means "one of the numerical values found before", Tnelis explained you just before that a "match from a list" statement is written: itemid in (val1, val2, ...., valN)

furthermore, if the 2 statements are supposed to be used together, manual copy of these "itemid" is the worst way, you must do:

UPDATE ps_gamedefs.dbo.items SET Grade=998 WHERE ItemID IN (
SELECT ItemID FROM ps_gamedefs.dbo.items WHERE Grade=1107)

which is of course a non-sense, since if you success to express what you wanna do, it simply comes to "changing all grade equal to 1107 to 998" where the ItemID is *definitively* NOT the concern.

so: UPDATE ps_gamedefs.dbo.items SET Grade=998 WHERE Grade=1107

Originally Posted by Svinseladden

[...]
i can do the same too all of them but if i have to manualy change all of them in the mobitem list that will take weeks or something he he he

or you can GOOGLE SQL UPDATE & learn a bit, yet said.