[Resolved]New Grades

09/10/2012 18:17 x-DoeSn'TxMaTTeR-x#1
Hey guys!I got a question bout grades.
I did some items and i made them drop by some mobs but, everytime i do a new item it take me 3h.
I take a item id,i change it's name,i look at it's grade and i delete the grade from all the items with the same grade...Only this take me 1,5h xD
Then i go to look for all the mobs who drop this item and i delete the drop from them and finally i put my grade to the mobs i want to drop it.

That's a hige job that a noob did already 3 times...
And that's stressing xD

I know there's a faster way but i'm so nub to don't understand it.

So...There's a way to create a new grade with no items,mob associated to it?
Or there are some grades who have no items in it?
i'm sure there's a list of grades from 0 to 999 that are not take by any items.
So, how should i do?



[Problem Resolved]
[Request To Delete]

I had to look better in epvp :(
09/10/2012 18:26 TeddyBear94#2
create table #a (num int)
declare @i int
set @i=0
while @i < 999
begin
set @i=@i+1
if not exists (select * from ps_gamedefs.dbo.items where grade = @i)
insert #a select @i
end
select * from #a


( like that u find unused grades)
credits to zargon