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($userpostcount)) {
        $DB_site->query("UPDATE user SET posts=posts$subtract WHERE userid='$postuserid'");
      }
    }

REPLACE WITH:

//    if (is_array($userpostcount)) {
//      while(list($postuserid,$subtract)=each($userpostcount)) {
//        $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.............