Post trimming does not decrease post count... v2.2.0

[SharkY-GA]

I know tubedog made it for 2.0.x but could someone do this for v2.2.x?

tubedogs:
https://vborg.vbsupport.ru/showthread.php?s=&threadid=12420

I just cant find it...

[almightyone]

^bump^

[Barret]

I don`t think anyone knows how to do this yet.
If you ask me, this should have been an option on the board "Vbb" to
delete posts with prune or not to.
Unfortunately, it was not. :(

[squawell]

ok~~i already do it!!

find admin/functions

$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]"]--;
}
}

to this

$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]"]--;
//}
//}

i already test on vbb220 and it's work!!

[Barret]

Well thank you so very much man!
That did the trick for sure!
Great work and thanks again!!

[squawell]

Originally posted by Barret
Well thank you so very much man!
That did the trick for sure!
Great work and thanks again!!
ur welcome~

i'm happy it work to u

[almightyone]

well i juts did this hack and it doesnt reduce on thread deletion but if i delete an individual post in a thread it drops count i posted a thread then a reply i deleted the reply it lowered by 1 i deleted the thread it didnt :confused:

[squawell]

that should be two parts~~

i only fixed one part make it can work on 203 and 220

another part u find out early post u'll find

[SharkY-GA]

Originally posted by almightyone
well i juts did this hack and it doesnt reduce on thread deletion but if i delete an individual post in a thread it drops count i posted a thread then a reply i deleted the reply it lowered by 1 i deleted the thread it didnt :confused:

This is because their seperate peices of code... I have this done... I will post it tommorow...

[CoolaShacka]

Originally posted by SharkY-GA (11-17-01 01:19 PM)
This is because their seperate peices of code... I have this done... I will post it tommorow...


*gg* ;)

[KuraFire]

I thought the prune posts option that comes with vB itself did the trick already??

[JTMON]

Up until 2.2.0 you could do a mass prune and it wouldn't drop the postcount. Now it does, as does deletion of single posts/threads

[KuraFire]

Originally posted by JTMON
Up until 2.2.0 you could do a mass prune and it wouldn't drop the postcount. Now it does, as does deletion of single posts/threads


That is quite sucky. Why did they change that?? Mass Prune should *always* not drop postcounts!

It was fine the way it worked, now why change it then??? :confused:

:(

[JTMON]

Originally posted by KuraFire



That is quite sucky. Why did they change that?? Mass Prune should *always* not drop postcounts!

It was fine the way it worked, now why change it then??? :confused:

:(

My thoughts exactly. So now, you have to use a Non Jelsoft supported HACK to accomplish this :rolleyes:

[Rose]

So, does anyone have a complete hack for this that will work for v 2.2.1? OR is that what Squawell posted up top?

[squawell]

this can do well with 221 look below:

open admin/functions.php find:

// ###################### 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]"]--;
}
}

replace with this:

// ###################### 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]"]--;
// }
// }

and find this:

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

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

replace with this:

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

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


i do this in my forum and it's work~~

[Rose]

Originally posted by squawell
this can do well with 221 look below:
... ... ... ... ... ... ... ... ... ... ... ... ... ...
i do this in my forum and it's work~~


Thank you, Squawell! I will install this right away. :)

[squawell]

Rose ur welcome ~~ :D :D :D

[Rose]

Umm, that didn't seem to work. I got errors when I tried to access my board, then the cp. But, I may have had server interference at the same time so I'll try again tomorrow. :s Evil servers!

[Psychdrone]

damn I tried this and it dosn't work??

I really need this too!!

:(