Prune doesn't reduce user post count

Someone mentioned this in the other forum (I think it was Castel). It's hardly a hack, as it consists of commenting out 3 lines, but here's how to do it:

In functions.php (in the /admin directory) find

// ###################### Start delete thread #######################

It should be around line 1450, somewhere in there. Now, a few lines below that, find

			if ($countposts) {
				$DB_site->query("UPDATE user SET posts=posts-1 WHERE userid='$post[userid]'");
			}

and replace it with

//			if ($countposts) {
//				$DB_site->query("UPDATE user SET posts=posts-1 WHERE userid='$post[userid]'");
//			}

Then, a few lines below that, find

// ###################### Start delete post #######################

A few lines below that, find

		if ($countposts) {
			$DB_site->query("UPDATE user SET posts=posts-1 WHERE userid='$postinfo[userid]'");
		}

and replace it with

//		if ($countposts) {
//			$DB_site->query("UPDATE user SET posts=posts-1 WHERE userid='$postinfo[userid]'");
//		}

Now when you prune (or a post is deleted) the users' post count won't decrease.

[Jawelin]

Slight different question: when I move/prune thread, HOW could automatically recount posts for all the users within that thread ?

Thanks

[newvbuser]

Hi Neo does your hack you posted in this last page work with version 2.2.5 ?

I really would like to use this hack.

[dotagious]

[QUOTE]Originally posted by newvbuser
Hi Neo does your hack you posted in this last page work with version 2.2.5 ?

I really would like to use this hack.

[newvbuser]

Huh? Avenger are you asking the same question also?

[dotagious]

yup

[Psychdrone]

Neo would be a genious if he could figure out how to also make it so when you update counters it wouldn't delete the users posts

but I don't think he could do THAT

[Zedd]

Can I assume this only works as long as you never update your user post counter?

[mak]

in v.2.2.5- i can't seem to find the

########start delete thread##### part........

i also want this cool hack!

[ExAvIoUr]

hmm there is... its there man.. i m so sure its there..

[N9ne]

Hey can anyone make this hack work with 2.2.6 running the Store hack? I'm about to install the store hack, but i'm stuck on the part where it says this;

------
------------------
find(around line 1897):
------------------

$DB_site->query("UPDATE user SET posts=posts$subtract WHERE userid='$postuserid'");

------------------
change it to:
------------------

$storeadmin = $DB_site->query_first("SELECT * FROM storeadmin");
$storemin=$storeadmin[newthread];
$DB_site->query("UPDATE user SET posts=posts$subtract,storep=storep-'$storemin' WHERE userid='$postuserid'");

------------------
find(around line 1930):
------------------

$DB_site->query("UPDATE user SET posts=posts-1 WHERE userid='$postinfo[userid]'");

------------------
Change it to:
------------------

$storeadmin = $DB_site->query_first("SELECT * FROM storeadmin");
$storem=$storeadmin[newreply];
$DB_site->query("UPDATE user SET posts=posts-1,storep=storep-'$storem' WHERE userid='$postinfo[userid]'");
------

That's in functions.php

The problem here is that i've commented out what ToraTora! has said to do.

I don't know any PHP and not this advanced either. So if anyone could re-write those two steps from the Store Hack taking mind that i've commented out what ToraTora! said to do and I still don't want post counts to be reduced during a prune....

If anyone can do that, which i'm sure is Very simple for someone who knows PHP, I will be very grateful