Post Changes

[L'Carpetron Dookmarriot 3]

Umm... I see that everyone's post count has substantially decreased except for the low-posters like me. Like MyNameIsKooky, he had 13400 posts before and now he only has about 8000. Am I imagining this?

[yot yot5]

Mine has stayed at 1399 (or whatever it is now). Really odd.

[yot yot5]

Sorry for DP, but it seems the ONLY account who's number has changed is MNIK!!! He's obviously posted too much.

This is really odd, though. The 2nd highest poster, Kiki, hasn't lost any posts at all.

EDIT: Also, whenever searching MNIK's posts, the words "No topics or posts to the search criteria" or whatever appears.

EDIT2: My 1400th post! Yay!

[Nobody]

AHAHAHAHAHAHAHAHA, MS NERFED MNIK! BWAAHAHAHAHAHAHA!

*sees I only have 4000+ posts instead of 9000+*

...Bother.

EDIT: I found the cause. When I noticed that it was me and MyNameIsKooky who both took a huge beating to our post counts, I checked the first post of the New Wefight Topic, and sure enough, the Old Wefight Topic is gone. I'm gonna miss it, but at least that explains stuff.

[yot yot5]

EDIT: I found the cause. When I noticed that it was me and MyNameIsKooky who both took a huge beating to our post counts, I checked the first post of the New Wefight Topic, and sure enough, the Old Wefight Topic is gone. I'm gonna miss it, but at least that explains stuff.

You posted over 5000 times on Wefight?

[jdl]

It looks like mine changed as well. o_O
I know for a fact that I should have more than 2100 posts (or in this case, 2101).

Something strange has been going on with the forum lately.

[Master Wonder Mage]

Maybe there were so many posts in old wefight that removing it allowed higher attachment limits?

[Nobody]

EDIT: I found the cause. When I noticed that it was me and MyNameIsKooky who both took a huge beating to our post counts, I checked the first post of the New Wefight Topic, and sure enough, the Old Wefight Topic is gone. I'm gonna miss it, but at least that explains stuff.

You posted over 5000 times on Wefight?

Well, IDK. It did get to almost 500 pages, and it was mainly me and MNIK that posted in it.

[dig 222]

Maybe there were so many posts in old wefight that removing it allowed higher attachment limits?

Well, I had a look at the old wefight, not there anymore.
Maybe all our posts there were deleted?

[Nobody]

I already said that.

[MyNameIsKooky]

AHAHAHAHAHAHAHAHA, MS NERFED MNIK! BWAAHAHAHAHAHAHA!

DARN!

the Old Wefight Topic is gone.

WHAT?! MY NOSTALGIA IS DEAD FOREVER!!!

[yot yot5]

WHAT?! MY NOSTALGIA IS DEAD FOREVER!!!

AND KIKI IS THE TOP POSTER AGAIN!!! YOU'RE NOT.

[MyNameIsKooky]

WHAT?! MY NOSTALGIA IS DEAD FOREVER!!!

AND KIKI IS THE TOP POSTER AGAIN!!! YOU'RE NOT.

THAT MAKES IT EVEN WORSE!!! TIME TO START SPAMMING.

[yot yot5]

THAT MAKES IT EVEN WORSE!!!

THAT WAS THE POINT!!!!! MWAHAHAHAHAHAHAHAHAHAHAHAHAHA!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!111111111[size=100000000000000] [/size]

[Emerald141]

‎

[L'Carpetron Dookmarriot 3]

Ok, well, at least I know why everyone is losing posts now. (And, when I say everyone I mean no-one except for MNIK and NbDy)

BTW-500 pages!?!?!? Dang.

[Wonderman109]

I don't think ending the Old We-fight topic would cause this. Did my post count change? EDIT: Nope.

[VirtLands]

I haven't noticed any post changes on my account. Maybe mine is unaffected, as it remains near 589 posts.

Using a PCPuzzle website snapshot I had from about 43 weeks ago, (=on March 2012)
I was able to retrieve the following statistics...:

{A} MyNameIsKooky had ≈ 12673 posts. (truly diminished)
{B} Nobody had ≈≈≈≈≈≈≈≈ 8359 posts. (truly diminished)

{C} yot yot5 had ≈≈≈≈≈≈≈≈≈ 192 posts, (not diminished)

{D} j.d.l. had ≈≈≈≈≈≈≈≈≈≈ 1806 posts, (probably diminished)
{E} Master Wonder Mage had ≈ 1109 posts, (not diminished)
{F} dig 222 had ≈≈≈≈≈≈≈ 416 posts, (not diminished)

LCD3 is quite observant about the forum details.

[Master Wonder Mage]

Well, considering it's MNIK...

[boywhoflies]

Old Wefight blew up? OH NOOOOOOOOOOOO

[Midnight Synergy]

Yes, old Wefight is gone, and I apologize for that. The forum wasn't accepting a higher attachment limit (I'm not sure why) so I looked for some ways to get # of attachments down... it had to be any kind of substantial impact, so that post got it.

After I got the attachment size under the limit I was able to reset the limit.

[yot yot5]

Yes, old Wefight is gone, and I apologize for that. The forum wasn't accepting a higher attachment limit (I'm not sure why) so I looked for some ways to get # of attachments down... it had to be any kind of substantial impact, so that post got it.

After I got the attachment size under the limit I was able to reset the limit.

Midnight Synergy killed Wefight.

[tyteen4a03]

Yes, old Wefight is gone, and I apologize for that. The forum wasn't accepting a higher attachment limit (I'm not sure why) so I looked for some ways to get # of attachments down... it had to be any kind of substantial impact, so that post got it.

After I got the attachment size under the limit I was able to reset the limit.

Well I blame phpBB2. The fields are too small to hold large forums. Please, please, please. Move away. Use XenForo, it's much better.

Run this. This will allow the forum to hold 18446744073709551615 everything so you won't have to worry for another few centuries.

This assumes the forum's table prefix is phpbb_. Change if necessary.

This assumes you have phpMyAdmin - if you don't PM me and I'll make an executable script.

Code: Select all

ALTER TABLE  `phpbb_attachments` CHANGE  `attach_id`  `attach_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `post_id`  `post_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `privmsgs_id`  `privmsgs_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `user_id_1`  `user_id_1` BIGINT NOT NULL ,
CHANGE  `user_id_2`  `user_id_2` BIGINT NOT NULL;

ALTER TABLE  `phpbb_attachments_desc` CHANGE  `attach_id`  `attach_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
CHANGE  `download_count`  `download_count` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `filesize`  `filesize` BIGINT NOT NULL;

ALTER TABLE  `phpbb_attach_quota` CHANGE  `user_id`  `user_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `group_id`  `group_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `quota_limit_id`  `quota_limit_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0';

ALTER TABLE  `phpbb_forums` CHANGE  `forum_id`  `forum_id` BIGINT UNSIGNED NOT NULL ,
CHANGE  `cat_id`  `cat_id` BIGINT UNSIGNED NOT NULL ,
CHANGE  `forum_name`  `forum_name` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

ALTER TABLE  `phpbb_posts_text` CHANGE  `post_id`  `post_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `bbcode_uid`  `bbcode_uid` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT  '',
CHANGE  `post_subject`  `post_subject` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

ALTER TABLE  `phpbb_posts` CHANGE  `post_id`  `post_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
CHANGE  `topic_id`  `topic_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `forum_id`  `forum_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `poster_id`  `poster_id` BIGINT( 8 ) NOT NULL DEFAULT  '0',
CHANGE  `post_username`  `post_username` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
CHANGE  `post_edit_count`  `post_edit_count` INT UNSIGNED NOT NULL DEFAULT  '0';

ALTER TABLE  `phpbb_privmsgs` CHANGE  `privmsgs_id`  `privmsgs_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
CHANGE  `privmsgs_from_userid`  `privmsgs_from_userid` BIGINT NOT NULL DEFAULT  '0',
CHANGE  `privmsgs_to_userid`  `privmsgs_to_userid` BIGINT NOT NULL DEFAULT  '0';

ALTER TABLE  `phpbb_privmsgs_text` CHANGE  `privmsgs_text_id`  `privmsgs_text_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `privmsgs_bbcode_uid`  `privmsgs_bbcode_uid` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT  '0';

ALTER TABLE  `phpbb_quota_limits` CHANGE  `quota_limit_id`  `quota_limit_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;

ALTER TABLE  `phpbb_search_wordlist` CHANGE  `word_text`  `word_text` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT  '',
CHANGE  `word_id`  `word_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;

ALTER TABLE  `phpbb_search_wordmatch` CHANGE  `post_id`  `post_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `word_id`  `word_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0';

ALTER TABLE  `phpbb_sessions` CHANGE  `session_user_id`  `session_user_id` BIGINT NOT NULL DEFAULT  '0';

ALTER TABLE  `phpbb_sessions_keys` CHANGE  `user_id`  `user_id` BIGINT NOT NULL DEFAULT  '0';

ALTER TABLE  `phpbb_topics` CHANGE  `topic_id`  `topic_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
CHANGE  `forum_id`  `forum_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `topic_title`  `topic_title` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE  `topic_poster`  `topic_poster` BIGINT NOT NULL DEFAULT  '0',
CHANGE  `topic_views`  `topic_views` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `topic_replies`  `topic_replies` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `topic_first_post_id`  `topic_first_post_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `topic_last_post_id`  `topic_last_post_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `topic_moved_id`  `topic_moved_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0';

ALTER TABLE  `phpbb_topics_watch` CHANGE  `topic_id`  `topic_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `user_id`  `user_id` BIGINT NOT NULL DEFAULT  '0';

ALTER TABLE  `phpbb_users` CHANGE  `user_id`  `user_id` BIGINT NOT NULL ,
CHANGE  `username`  `username` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE  `user_posts`  `user_posts` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `user_new_privmsg`  `user_new_privmsg` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `user_unread_privmsg`  `user_unread_privmsg` BIGINT UNSIGNED NOT NULL DEFAULT  '0';

ALTER TABLE  `phpbb_user_group` CHANGE  `user_id`  `user_id` BIGINT NOT NULL DEFAULT  '0';

ALTER TABLE  `phpbb_vote_desc` CHANGE  `vote_id`  `vote_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
CHANGE  `topic_id`  `topic_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0';

ALTER TABLE  `phpbb_vote_results` CHANGE  `vote_id`  `vote_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `vote_option_id`  `vote_option_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0';

ALTER TABLE  `phpbb_vote_voters` CHANGE  `vote_id`  `vote_id` BIGINT UNSIGNED NOT NULL DEFAULT  '0',
CHANGE  `vote_user_id`  `vote_user_id` BIGINT NOT NULL DEFAULT  '0';

ALTER TABLE  `phpbb_categories` CHANGE  `cat_id`  `cat_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
CHANGE  `cat_title`  `cat_title` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
CHANGE  `cat_order`  `cat_order` BIGINT UNSIGNED NOT NULL;

ALTER TABLE  `phpbb_banlist` CHANGE  `ban_id`  `ban_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
CHANGE  `ban_userid`  `ban_userid` BIGINT NOT NULL;

ALTER TABLE  `phpbb_forum_prune` CHANGE  `prune_id`  `prune_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
CHANGE  `forum_id`  `forum_id` BIGINT UNSIGNED NOT NULL;