A place to discuss all things Wonderland!
https://www.pcpuzzle.com/forum/
You posted over 5000 times on Wefight?Nobody wrote: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.
Well, IDK. It did get to almost 500 pages, and it was mainly me and MNIK that posted in it.yot yot5 wrote:You posted over 5000 times on Wefight?Nobody wrote: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.
Well, I had a look at the old wefight, not there anymore.Master Wonder Mage wrote:Maybe there were so many posts in old wefight that removing it allowed higher attachment limits?
DARN!Nobody wrote:AHAHAHAHAHAHAHAHA, MS NERFED MNIK! BWAAHAHAHAHAHAHA!
WHAT?! MY NOSTALGIA IS DEAD FOREVER!!!Nobody wrote:the Old Wefight Topic is gone.
AND KIKI IS THE TOP POSTER AGAIN!!! YOU'RE NOT.MyNameIsKooky wrote: WHAT?! MY NOSTALGIA IS DEAD FOREVER!!!
THAT MAKES IT EVEN WORSE!!! TIME TO START SPAMMING.yot yot5 wrote:AND KIKI IS THE TOP POSTER AGAIN!!! YOU'RE NOT.MyNameIsKooky wrote: WHAT?! MY NOSTALGIA IS DEAD FOREVER!!!
THAT WAS THE POINT!!!!! MWAHAHAHAHAHAHAHAHAHAHAHAHAHA!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!111111111[size=100000000000000]MyNameIsKooky wrote:THAT MAKES IT EVEN WORSE!!!
[/size] EDIT: Nope.
Midnight Synergy killed Wefight.Midnight Synergy wrote: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.Midnight Synergy wrote: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.
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;