The Arcive of vBulletin Modifications Site.

About Developer · **Released**: 12-05-2000

Well, here's a little script I wrote to update the post count stored in the user table with the actual number of
posts that user has made. When would you want to run something like this? Well, normally you should
never have to, but in case your user's post counts become inaccurate, you can reset them with this.

The main reason I wrote this, however, was to update a user's post count excluding certain fourms, for
example if you have a testing forum and don't want those posts included in the user's total. If you would
like to do something like this, just look at the comments in the script and make the changes needed.

Just name upload this code to admin/usercounts.php

Enjoy!

Code:

<?php

if (function_exists("set_time_limit")==1 and get_cfg_var("safe_mode")==0) {
  set_time_limit(1200);
}

require ("global.php");

?>
<html>
<head>
<STYLE type=text/css>
BODY {
  font-family: arial;
  font-size: 10pt;
  font-variant: normal;
  font-style: normal;
}
P {
  font-family: arial;
  font-size: 10pt;
  font-variant: normal;
  font-style: normal;
}
</STYLE>
</head>
<body>

<?php
// ###################### Start user choices #######################
if (isset($action)==0 or $action=="") {

  echo "<p><b>Update User Counts</b> - updates user post counts, excluding certain forums<br>\n";

  echo doformheader("usercounts","updateuser");
  echo "<table border=0>";
  echo makeinputcode("Number of users to do per cycle","perpage","500");
  echo doformfooter();

}

// ###################### Start update user #######################
if ($action=="updateuser") {
  if (isset($perpage)==0 or $perpage=="") {
    $perpage=500;
  }
  if (isset($startat)==0 or $startat=="") {
    $startat=0;
  }
  $finishat=$startat+$perpage;

  echo "<p>User ids:</p>";

  $users=$DB_site->query("SELECT userid,username,posts FROM user WHERE userid>=$startat AND userid<$finishat ORDER BY userid DESC");
  while ($user=$DB_site->fetch_array($users)) {

    $userid=$user[userid];

    // update user stuff
    
    // If you want to exclude a certain forum, just add it to the query below
    // Ex.: AND thread.forumid<>1

    if ($posts=$DB_site->query_first("SELECT COUNT(post.postid) AS numberposts FROM post,thread WHERE thread.threadid=post.threadid  AND post.userid=$userid")) {
       $numposts=$posts[numberposts];
    } else {
      $numposts=0;
    }

    $DB_site->query("UPDATE user SET user.posts=$numposts WHERE userid=$user[userid]");

    echo "$user[userid] $user[username] $numposts <br>\n";
    flush();

  }
  if ($checkmore=$DB_site->query_first("SELECT userid FROM user WHERE userid>=$finishat")) {
    echo "<script language=\"javascript\">window.location=\"usercounts.php?action=updateuser&startat=$finishat&perpage=$perpage\";</script>";
    echo "<p><a href=\"usercounts.php?action=updateuser&startat=$finishat&perpage=$perpage\">Click here to continue updating users</a></p>";
  } else {
    echo "<p>All done!</p>";
  }

}


?>
</body>
</html>

#2 12-06-2000, 02:52 AM

It works great!!! Thanks Chris!!

#3 12-06-2000, 11:04 AM

works great, and very easy to integrate into misc.php thnx

#4 12-06-2000, 06:26 PM

I'm glad you guys like it!

#5 12-07-2000, 01:01 AM

I like

Code:

if (function_exists("set_time_limit")==1 and get_cfg_var("safe_mode")==0) {
  set_time_limit(1200);
}

Smart thinkin'! :-)

#6 12-07-2000, 02:06 PM

You could always just do:

@set_time_limit(1200);

"@" suppresses any error message.

#7 12-07-2000, 02:23 PM

Quote:

Originally posted by Ed Sullivan

"@" suppresses any error message.

Ahh I didn't know that, but thanks for the tip!

JJR512 · #8 04-30-2001, 11:33 PM

Can someone tell me if this will work for vB 2, or if not, how to make something similar that will?

Chris Schreiber · #9 04-30-2001, 11:38 PM

Yes it works the same for 2.0.

JJR512 · #10 04-30-2001, 11:59 PM

OK, there's something I don't get.

I ran this script just after I imported from UBB, and peoples counts jumped, in some cases quite a bit. I expected this, because UBB never decriments the post count. So all the posts that were deleted still count for who posted them. Now vB does decriment the post count if you delete someone's posts, so I expected the count to be accurate.

But I just saw someone's post count drop by almost 600 posts. That should not be.

Here's another curious thing. What does this script do...where does it get its number, the number that it sets a person's post count to?

And what does this query do:

Code:

SELECT COUNT(*) FROM post WHERE userid='384';

That's an example using my user ID. After I ran this script, my post count was 6736, which is about what it was before (I don't remember it exactly). But if I run the above query on the database, I get a number of 7056. Which one is right?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08536 seconds Memory Usage 2,320KB Queries Executed 23 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_code (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (3)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end postbit_factory postbit_display_start fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start postbit_imicons pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages: