yes, but now when you get a new user, it will fill the gaps :)

Then if I ever do delete any users I should run this again?

How about the quotes, can the same thing be done there?

you have to do tha again, if the autoincrement is higher than the userid which becames deleted..

yes, you can use this query which every autoincremented field.

Thank you very much. I learned something I didn't know today. Looks like it's going to be a good and productive day after all. :)

Bad news...I just tried adding a quote and I still have a 4 quote difference. It didn't fill one of the gaps with the new quote. The query ran successfully. And ideas on this one? :)

the quotes are a hacked function right?
so i don't know, because i haven't included the quote hack..

normaly it should work, but maybe try to ask at the supportthread of the quotes hack.

That query for the users didn't work either. I just had a new user log on and he is number 25 now (which he is actually the 22nd member). :)

I haven't tested it, but i know it should work, firefly has posted this method on vb.com:
http://www.vbulletin.com/forum/showt...threadid=45635

and i found a thread here where it was told it works perfect...
can'T find it anymor, forgot the exact search claus

It might work on the forum table, but it didn't work on the user or quote table for some reason. :)

hmm, then there is no way....