[Help] Shaiya EP5 Drop

I have never used sql before; however, thanks to people like abrasive, castor, tnelis, and a larger list, I have been figuring out some of the sql commands. Castor made a fantastic editor program that has been publicly released, which is what i used to change the bags of 1119 1120 1124 and 1125 to some other number i dont remember at this time.

If the simple steps in his instructions are followed you can quickly and easily update these 75 mobs with the proper value in a relatively short amount of time, of which i will leave undetermined.

Quote:

Originally Posted by castor4878 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). 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 or you can GOOGLE SQL UPDATE & learn a bit, yet said.

not that i want to be rude or anything but this you said was

Quote:

useless,a non-sense, and so on

i did last night. and changed all mobs just the way i want them to drop in 8 hours. all 70 maps are now done..

so thanks to all that gave me the:

select * from ps_gamedefs.dbo.items
where grade= ' x '

and

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

sure worked for me. this was easy:-)

Quote:

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)

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

does work. and ItemID is ItemID, all have it. this is normaly done when i like have a 1000+ grade i want to change to 998 or lower. just put in all the item id's from the old grade and your done.

or if you need stuff from the BIG 999 list. just pick the stuff you want. put it in:

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

with a new grade you find that have nothing in it before. and you have a new bag of stuff you can grade a monster with.

for me this looks easy. fast and well for me fun:-)

Quote:

Originally Posted by Svinseladden this is what i did: 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' 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

Quote:

Originally Posted by Svinseladden select * from ps_gamedefs.dbo.items where grade= ' x ' and UPDATE ps_gamedefs.dbo.items SET Grade= 'x' WHERE ItemID= 'itemid' OR ItemID= 'itemid' OR ItemID= 'itemid' [...] for me this looks easy. fast and well for me fun

so "fast & funny" since "that will take weeks or something".

everything's perfect, I haven't more comments.

i was going up and down the table before i found that i could change gade easy with:

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

before that i would have taken weeks to get everything done:-)

drop rate 1 = 100%?

Quote:

Originally Posted by dranest drop rate 1 = 100%?

The drop rates are in percentages (%) this means -besides some other "non-sense" numbers) that when you input a number between 0 and 100 that will be the specific drop rate for the item.

So 1 = 1%

just strange then, why in the database some values ​​far as 100

[Only registered and activated users can see links. Click Here To Register...]

All those drop rates which are higher than 100 are set to be random drops, so they do not have an exact rate.