[tbworld]

Originally Posted by Amaury

With deleting styles, spam bots and whatever else, there are now big gaps in IDs. For example, User 1, User 2, User 3, User 15 and User 50.

Is there a query that would rebuild all IDs (threads, posts, users, styles, etc.)? So going by the example above, User 15 would become User 4 and User 50 would become User 5.

Thanks!

You need to forget about this one, but I know it is hard. What happens when a third party 'mod' uses the users 'userid' in their table/field. If a query was written it would not know about that particular 'mod' and the field would not be updated -- things would break. It is why you will not find such a query easily, dangerous in the wrong hands.