ya...mob drops are clean

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

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

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

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,

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.

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????

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)

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.

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....

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

#closed