PDA

View Full Version : Post ID 30,000

Bobby aka Dizzy
August 30th, 2001, 05:45 PM
Woo!
ShadowGPW
August 30th, 2001, 05:46 PM
have fun.. 30,001
Bobby aka Dizzy
August 30th, 2001, 05:46 PM
lol 30,002
ShadowGPW
August 30th, 2001, 05:48 PM
i really couldn't

30,003
Bobby aka Dizzy
August 30th, 2001, 05:48 PM
I am so better than you Shad ;P



(30,004)
ShadowGPW
August 30th, 2001, 05:48 PM
(30,005)

You wish..



(hey isn't this spam?)
Bobby aka Dizzy
August 30th, 2001, 05:49 PM
Darn =(



Kaz posted, evil Kaz ;P Shadow wins ;P
ShadowGPW
August 30th, 2001, 05:50 PM
30,007

YES I WIN .. Spam
EvilMike
August 30th, 2001, 10:16 PM
Spamlyspam
EvilMike
August 30th, 2001, 10:17 PM
Whoops. I guess I'm a bit late.
Hareoic
September 1st, 2001, 02:02 PM
What's the point of this? It's truely pointless.
Ducky
September 1st, 2001, 02:10 PM
I tried for that too. I am so incompetent.

Sigh..

*scrreeches and crys*

`Ducky
Hareoic
September 1st, 2001, 02:17 PM
???

I'm lost...
Tubz
September 2nd, 2001, 03:56 PM
30,255, no wait 30,256. This post will be #30,256. But remember the post counter was messed up. Was it ever fixed, or are these numbers still wrong?
Bobby aka Dizzy
September 2nd, 2001, 04:29 PM
Its right, but deleted topic dont revert the ID remember.
Wild Angel
September 3rd, 2001, 12:02 AM
30,257 in yo' face! >)
Bobby aka Dizzy
September 3rd, 2001, 10:00 AM
See the post counter is correct it uses the count(*) mysql call.



To get the post count you do this



select count(*) from posts





but the ID is just an autoincrement integer. So when a topic is deleted all posts in it are too making it so the ID is higher than the actual count(*)
Enigma
September 9th, 2001, 12:27 AM
*stares at everyone in this topic*



uh, ok, have you guys ever considered seeing a psychiatrist? no? that's what i thought.