ya...mob drops are clean

[hootzoo]

ya... if ANY one gots a mobitem query that would be alsome as hell

[[Dev]Ansem]

"ya mob drops are clean" ?
you want a query that cleans your mobitem, right?
(hard to understand)

[SirFailzAlot]

Well if you want to add drops, You can use this

 Spoiler

UPDATE [PS_GameDefs].[dbo].[MobItems]

SET [MobItems].[Grade] =
WHERE [MobItems].[MobID] = AND [MobItems].[ItemOrder] =
AND [MobItems].[DropRate] =

Personally i find it easier to edit mobs individually,Via the MobItems.dbo

But if you want to Delete Items from mobs the query as far as i can work out would be along these lines or atleast something to this effect,

 Spoiler

UPDATE [PS_GameDefs].[dbo].[MobItems]

SET [Mobitems].[GRADE] = 0
WHERE [MobItems.[MobID] = all AND [MobItems].[ItemOrder] = all
AND [MobItems].[DropRate] = 0

Dont Quote me on that last one Mind you

Unless your asking for someones MobItems.Dbo In which case your better off Grabbing one from a Database Download & Transfering it into your own database.

[hootzoo]

nope my server dc 3 times and then did a roll back but also under mobitem vary clean not 1 grade not 1 drop no nothing but mobs names now....and let me ask this how the hell does that happen????

[JohnHeatz]

Not sure why did it get deleted, because if this happens, not just the grades/rates would be deleted but everything; hope that you had a backup because adding manually all the drops to every mob of the game is a real time consuming task (believe me, I have done it before)

[SirFailzAlot]

Well Either Somebody got into your database with Sql injection, Or someone you have working with you Did something stupid like delete the table's data, If you dont have a backup, Like john said its going to be very Time consumming,

Imho, I'd restart from fresh, Although its going to be a pain for yourself, But its the least time consumming way to do it.

[hootzoo]

it was just to many people on server for a home pc to take so that was the dc's but got dedi now now i gatta do the mobitems plus now got 3000+ new mobs added in so 6903 mobs in mobitems to fix yay....

[vovavlyki2]

Сообщение 156, уровень 15, состояние 1, строка 4
Неправильный синтаксис около ключевого слова "and".

[Autrux]

#closed