What Query To Run?
 

Ok, I have vBStats installed on my board and I skipped one step accidently until about a few days later. That step was to add the ability in the admin center to do stuff like remove a URL from inclusion in the referrers thing and you were supposed to do that to your own domain. Well, after 3 days of waiting and finally doing it, I got 3303 hits from my own domain. How would I delete the first line:
from the database and have all of the ['id'] numbers go down one? So what query would I run to delete that row and bring all of the other rows' ID numbers down one?

[sql]DELETE FROM tableName WHERE idField = 1;[/sql]
[sql]UPDATE tableName SET idField = idField - 1;[/sql]

Cool, thanks. Since when is [sql] a tag?

Since I wrote it. ;)

It's a special tag that highlights SQL queries, like the PHP tag. It's still not complete nor perfect so you shouldn't use it.

Edit: Lol, haha, nevermind, I'm a retard. I got it, ignore the rest of this post. :p

Cool. Ok, my table for that is 'vbstats_referrer' so how would that query run? When I ran it like this:

DELETE FROM tablevbstats_referrer WHERE idField = 1;

It doesn't work... I also tried a space between 'table' and 'vbstats_referrer' but that didn't work.... I tried a period (.) between 'table' and 'vbstats_referrer'. Heh, sorry... not very good with mySQL. :) I wanted to buy a book on it a few days ago, but it was $40. :(

use this one aswell.

Or don't

:)

Huh... What does that do?

Nothing you want to try...

Lol. What would that have done?

Change everyone's usergroup to 0... Bad neo. ;)