General Forum

Post count... 24 replies

AK47 said on: 2007-05-16 10:43 pm
3867 Days, 8 Hrs, 3 Min, 10 Sec ago

so why has everyone's post counts dropped?
ex: i went from 1800+ to 300+.
Bottlecruiser said on: 2007-05-16 10:48 pm
3867 Days, 7 Hrs, 58 Min, 25 Sec ago
Tbrown (Admin) said on: 05/17/07 12:13 am
(34 Minutes, 45 Seconds ago)
It was everyone. I was performing some unscheduled maintenance to improve server performance. FYI, I have archived forum posts older than about 8 months old...



So let it be written, so let it be done! -- Admin

(Tbrown (Admin) has posted: 3 forum posts)

User ID: 23 / Joined: 6/3/2002
Jing said on: 2007-05-16 10:49 pm
3867 Days, 7 Hrs, 57 Min, 43 Sec ago
2k to 400...
wow...
LagunaCid said on: 2007-05-16 11:11 pm
3867 Days, 7 Hrs, 36 Min, 6 Sec ago
So THAT was why the server went down...
TBrown (Admin) said on: 2007-05-16 11:11 pm
3867 Days, 7 Hrs, 35 Min, 16 Sec ago
Sorry guys! We really need a better forum system *sigh*...

But I've gotta say, tarsonis and now truesource have been a great help and I really appreciate everything they've done for this site!
Entity-Neo said on: 2007-05-17 12:34 am
3867 Days, 6 Hrs, 12 Min, 39 Sec ago
I lost over 2000 posts :P
LoL
Shows how much ive dropped of in posting recently :P
Oh well
Justtt a number
Elmy said on: 2007-05-17 02:42 am
3867 Days, 4 Hrs, 4 Min, 46 Sec ago
OOoohhh, I should be in the double-digits, I would imagine.

[Added at 05/17/2007 04:42:57 by Elminster]
Damn! This very post made me double-digits.
Cllander said on: 2007-05-17 05:04 am
3867 Days, 1 Hr, 42 Min, 35 Sec ago
I prefer the look and feel of this forum than to most forums I've visited.
Red (Tester) said on: 2007-05-17 05:46 am
3867 Days, 1 Hr, 51 Sec ago
Actually elm, post count isn't affected in General Forums.

You were double-digits. xD
SPAZZA said on: 2007-05-17 06:10 am
3867 Days, 36 Minutes, 51 Seconds ago
and my post is..
DrakenRahl said on: 2007-05-17 07:18 am
3866 Days, 23 Hrs, 28 Min, 20 Sec ago
I went from over 3.3k to 100 :P
Jeany said on: 2007-05-17 08:31 am
3866 Days, 22 Hrs, 15 Min, 48 Sec ago
I've dropped from 6000 in the past :P
Gemz said on: 2007-05-17 08:46 am
3866 Days, 22 Hrs, 56 Sec ago
So have i :)

Anyways tom, i actualy like this layout.

So if you do get a new fourm, try to get it somewhat like this layout.
VoDkA said on: 2007-05-17 02:22 pm
3866 Days, 16 Hrs, 24 Min, 41 Sec ago
3200 => 34
ShadyKnight (Mod) said on: 2007-05-17 11:10 pm
3866 Days, 7 Hrs, 36 Min, 38 Sec ago
I kept like 10% of my posts... I was nearing my user-number.
Ayanami said on: 2007-05-18 07:46 am
3865 Days, 23 Hrs, 26 Sec ago
play bnt!

/checks posts count
Cruzader said on: 2007-05-18 10:59 am
3865 Days, 19 Hrs, 47 Min, 50 Sec ago
Oh.
Pixie said on: 2007-05-18 03:27 pm
3865 Days, 15 Hrs, 20 Min, 5 Sec ago
wow I post alot :P
TheWhiteDemon said on: 2007-05-20 08:07 pm
3863 Days, 10 Hrs, 39 Min, 49 Sec ago
I post like Baron
Space-Monkey said on: 2007-05-20 09:08 pm
3863 Days, 9 Hrs, 38 Min, 59 Sec ago
im the bomb diggity dog at posting yo
SunnO said on: 2007-05-20 10:16 pm
3863 Days, 8 Hrs, 30 Min, 54 Sec ago
Why would post counts drop when you deleted/archived old posts?

(The following is from the biggest noob when it comes to databases).
That would, as far as I know, mean the post count was calculated from all the posts the user has made when a page with a post count is requested. Wouldn't it make better sense to use a simple increment system where the post count isn't really linked with the amount of posts a user has in the database?
VoDkA said on: 2007-05-21 08:16 pm
3862 Days, 10 Hrs, 30 Min, 44 Sec ago
(The following is from someone who has worked with databases for years now)

I don't think NN forums actually "calculate", every time a page requests a user's post count, the amount of posts this user has made since the last archiving. It would be way too tedious to go through the whole database and find every of his posts. Forums most probably use an auto increment system as you said. However, to keep the post count accurate, every time one or more posts are deleted, the code takes the ID of the user who had posted the concerned thread/reply and modifies his post count in the database consequently. That way, post counts remain accurate, even when posts are deleted/archived.

That said, when Tom purges the posts, he might do it directly from the database. If so, the code isn't run and can't adjust everybody's post count. That time, he can just run a script that will go through the whole database once to recalculate all the post counts. That done, the other system I described above takes the task over.

Hope my pedagogy was good enough and you understood what I explained.

Lesson 1 - Introduction to databases => Done.


Your almighty webmaster,
VoDkA
Red (Tester) said on: 2007-05-21 08:18 pm
3862 Days, 10 Hrs, 28 Min, 30 Sec ago
........Okay....

Voddy just OWNT somebody.. No joke. Vodka, this was too severe an ownage. I think this post needs to be deleted. Someone could have a traumatic experiences from this ownage.. O_O
LagunaCid said on: 2007-05-21 08:19 pm
3862 Days, 10 Hrs, 27 Min, 45 Sec ago
Vodka, assuming this forum is efficient =]
SunnO said on: 2007-05-21 10:33 pm
3862 Days, 8 Hrs, 13 Min, 12 Sec ago
Duh, I should know that. I don't know why I posted that.:/