O god please (deleting with out taking away post count)

[Psychdrone]

please someone, I can't figure it out, there have a been a couple of posts, but none of them work:(

So could someone please tell me the code I would replace

THanks!

[larryz]

In admin/functions.php


FIND:

if (is_array($userpostcount)) {
while(list($postuserid,$subtract)=each($userpostco unt)) {
$DB_site->query("UPDATE user SET posts=posts$subtract WHERE userid='$postuserid'");
}
}



REPLACE WITH:

// if (is_array($userpostcount)) {
// while(list($postuserid,$subtract)=each($userpostco unt)) {
// $DB_site->query("UPDATE user SET posts=posts$subtract WHERE userid='$postuserid'");
// }
// }


That should take care of the problem for ya ;)

[Psychdrone]

thanks man,

[Psychdrone]

umm actually I am failing to see the difference in the codes????

what am I missing? all he did, was edit out that code??? with the //

[FWC]

That's the update query that reduces the users post count. You edit it out, the count shouldn't reduce.

[Psychdrone]

oooooo well good luck to me~

[amsch]

I was just thinking the same stuff. Now, I have a question. If i prune my boards and use this. it will not lower the counts for the user but what about total threads on the board? My database is huge over 300mb.. and I am trying to find ways to cut it down. My concerns are losing the total # of threads/posts on the main page. Also, does pruning delete attachments and reduce the search index?

Thanks for the help!

[Psychdrone]

Dammit surprisingly it did not work:(

Could some one pretty please, help me out here

I don't see what could be so hard about it, althu I don't know php that good

please help thanks!!!!

[Psychdrone]

OK I am gonna push this one, as I am sure there are a lot of people out there, that might want this, and I don't think it would be that hard........

[Psychdrone]

grrrr.............

[Psychdrone]

time for a bump

[bertje]

thnx , that's usefull

[Stoned Gecko]

Here is a link to the hack:

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

I installed it on 2.2.1 and 2.2.2 and it works for me.

Good luck! :)

[Psychdrone]

can't get the thread delete part to work,

and what about mass prune:(