[Sommaire] [Imprimer]

   1  <?php 
   2  /*
   3  
   4  This is just a simple script for updating the post-count of each user, which
   5  is shown in the user's profile. It can be run multiple times, but should at
   6  least be run once after a conversion from Phorum 3 to Phorum 5.
   7  
   8  How to use?
   9  
  10  Just copy this script to your main Phorum 5 directory and run it either
  11  from your webbrowser or from the console. It will show only some summary
  12  in the end, nothing more.
  13  
  14  Depending on the number of messages and users, it may take some time.
  15  
  16  */
  17  
  18  
  19  // we try to disable the execution timeout
  20  // that command doesn't work in safe_mode :(
  21  set_time_limit(0);
  22  
  23  require  './common.php';
  24  
  25  // no need to change anything below this line
  26  $sql="select user_id, count(*) as postcnt from ".$PHORUM["message_table"]." group by user_id";
  27  $conn = phorum_db_mysql_connect();
  28  $res = mysql_query($sql, $conn);
  29  if ($err = mysql_error()) phorum_db_mysql_error("$err: $sql");
  30  if(mysql_num_rows($res)) {
  31      $usercnt=0;
  32      while($row = mysql_fetch_row($res)) {
  33          $user=array("user_id"=>$row[0],"posts"=>$row[1]);
  34          phorum_user_save_simple($user);
  35          $usercnt++;
  36      }
  37  }
  38  
  39  print "$usercnt Users updated with their current postcounts. Done!<br>\n";
  40  
  41  ?>