phpBB • Free and Open Source Forum Software

well it has to do with this mod:

NV usertopics
http://www.phpbb.com/community/viewtopic.php?t=1164045

for some reason the post is locked, and also, the mod author will not provide support via PM or email.

So little bit stuck.

Any chance you could help me out on this one?

Hi the edits work as mentioned but i have one more request.

I have a mod that shows how many topics a user created on their profile page, under their avatar on the "viewtopic" page, and the memberlist...

Is there a way to ensure this post count does not decrease as well?

Ok just two more question on this quote, its dumb. 1. How do you "comment out" the code? 2. I tried the edits in the first post of yours, and it only retains the total posts after pruning a forum (user only), not the topics. what code do i have to edit to maintain the Topic count for the users as we...

Good point.

I will consider this.

oh i see, so in my case i might not want to do any pruning at all then in order to 100% ensure that post counts are retained.

but lets say you do this:

1. I prune the forum
2. The users and board retain their topic and post counts
3. Then i hit resync.

Will hitting that resync button reduce the users and boards topic and post counts? or will the value they had after the prune still be maintained?

Is there any possible way of getting a listing of IP's that failed with their login attempts?

Does the PHPBB software track this sort of info?


Cause if you can see which IP's failed with their logins you can check it and then make a decision to block it

If after doing this, what happens if we use the resync posts and topics feature afterwards?

Your SQL query has been executed successfully

UPDATE phpbb_users SET user_posts =0 WHERE user_id =5;# 1 row(s) affected.
UPDATE phpbb_users SET user_posts = user_posts +8317 WHERE user_id =5;# 1 row(s) affected.

bna wrote:It would be fantastic to know what phpBB did to protect their forum, I am certain there is the opportunity to share the knowledge and help the community. phpBB representatives, would you like to share anything.

I know we aren't the only ones to ask

I also just tried this method, and it is still the same result as before.

It's not a big deal or anything. but im just trying to speed up my forum, because there are alot of crawlers on the site all the time killing bandwith.

i already pay too much in hosting fees

it says:

user_posts mediumint(8) UNSIGNED

well i dont see that: i just have this Field Type Collation Attributes Null Default Extra Action post_id mediumint(8) UNSIGNED No None AUTO_INCREMENT topic_id mediumint(8) UNSIGNED No 0 forum_id mediumint(8) UNSIGNED No 0 poster_id mediumint(8) UNSIGNED No 0 icon_id mediumint(8) UNSIGNED No 0 poster...

per your request:
first one:

COUNT(post_id)
8317


second one:

user_posts
8317

So today is the first day ever that I tried to press the Resynchronise post counts option in the admin panel. Well i get a number of problems: 1. My users post counts is all out of line, some users are showing 16 million in posts, others now show ZERO. This looks very unprofessional and I got commen...