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.

[Lesane]

Originally posted by Tha Rock
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

Delete post/thread = Decrease points from user but don't decrease user's posts amount, then do the following:

PHP Code:

------------------------
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 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 storep=storep-'$storem' WHERE userid='$postinfo[userid]'");
------ 


[N9ne]

[QUOTE]Originally posted by Lesane

Delete post/thread = Decrease points from user but don't decrease user's posts amount, then do the following:

[Lesane]

hehe, that's no line of code. When you delete a post/thread then the user's post amount won't be decreased but the user's points amount does will be decreased with that code that i posted above.

[N9ne]

Oh so I just don't do anything for that line u put there?

[FFMania]

This hack...can't be installed on a clean version of 2.2.6? I can't find most of the code....

[N9ne]

Ok i'm back with another problem, i've installed about 35 hacks on my forum, so functions.php has changed A LOT. I just noticed that I haven't done this hack! :-/

But my code has changed, I'll paste it here, please can someone show me what to do so whenver a post is deleted, a thread is deleted, or a forum pruned, post counts do NOT go down, infact I never want postcounts to go down.

// ###################### Start delete thread #######################
function deletethread($threadid,$countposts=1) {
  global $DB_site;

  // decrement users post counts
  if ($threadinfo=getthreadinfo($threadid)) {
    $postids="";
    $attachmentids="";

    $posts=$DB_site->query("SELECT userid,attachmentid,postid FROM post WHERE threadid='$threadid'");
    while ($post=$DB_site->fetch_array($posts)) {
      if ($countposts) {
        if (!isset($userpostcount["$post[userid]"])) {
          $userpostcount["$post[userid]"] = -1;
        } else {
          $userpostcount["$post[userid]"]--;
        }
      }
      $postids.=$post['postid'].",";
      if ($post['attachmentid'] != 0) {
		  $attachmentids .= $post['attachmentid'].",";
      }
      unindexpost($post['postid']);
    }

    if ($attachmentids != '' ) {
      // make sure you don't remove attachments that are already in use!
      $checkattachments=$DB_site->query("SELECT DISTINCT attachmentid FROM post WHERE attachmentid IN ($attachmentids"."0) AND threadid<>'$threadid'");
      $omitattachmentids="";
      while ($omitattach=$DB_site->fetch_array($checkattachments)) {
        $omitattachmentids.=$omitattach['attachmentid'].",";
      }
      $DB_site->query("DELETE FROM attachment WHERE attachmentid IN ($attachmentids"."0) AND NOT attachmentid IN ($omitattachmentids"."0)");
    }

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


    if ($postids!="") {
      $DB_site->query("DELETE FROM post WHERE postid IN ($postids"."0)");
    }
    if ($threadinfo['pollid']!=0) {
      $DB_site->query("DELETE FROM poll WHERE pollid='$threadinfo[pollid]'");
      $DB_site->query("DELETE FROM pollvote WHERE pollid='$threadinfo[pollid]'");
    }
    $DB_site->query("DELETE FROM thread WHERE threadid='$threadid'");
    $DB_site->query("DELETE FROM thread WHERE open=10 AND pollid='$threadid'"); // delete redirects
    $DB_site->query("DELETE FROM threadrate WHERE threadid='$threadid'");
    $DB_site->query("DELETE FROM subscribethread WHERE threadid='$threadid'");
  }
}

// ###################### Start delete post #######################
function deletepost($postid,$countposts=1,$threadid=0) {
  global $DB_site;

  // decrement user post count
  if ($postinfo=getpostinfo($postid)) {
$storeadmin = $DB_site->query_first("SELECT * FROM storeadmin");
$storem=$storeadmin[newreply];
$DB_site->query("UPDATE user SET storep=storep-'$storem' WHERE userid='$postinfo[userid]'");
   
   if ($postinfo['attachmentid']) {
			// make sure you don't remove attachments still in use
			$otherattachs=$DB_site->query("SELECT attachmentid FROM post WHERE attachmentid=$postinfo[attachmentid] AND threadid<>'$postinfo[threadid]'");
			if ($DB_site->num_rows($otherattachs)==0) {
				$DB_site->query("DELETE FROM attachment WHERE attachmentid=$postinfo[attachmentid]");
        $DB_site->query("UPDATE thread SET attach = attach - 1 WHERE threadid = '$threadid'");
			}
    }

    $DB_site->query("DELETE FROM post WHERE postid='$postid'");
  }
}

// ###################### Start make login code #######################

[desi]

i got a question guys ... i have the hack working but it only accounts for user posts and not the board posts is there anyway to retain the boards count also ?

its would be really good if thats possible

cheers

[N9ne]

desi: Give me 5 minutes, I'm releasing a hack for what you want.

[The General]

That's 5 long minutes!

Is there a way to retain the board count yet? Bc that would be groovy! =]

[N9ne]

I did indeed release the hack a long time ago General .

https://vborg.vbsupport.ru/showthrea...threadid=45158