<?php
$db_host = 'localhost';  // adres serwera bazy danych mysql
$db_user = '****';  // login do serwera bazy danych
$db_passwd = '****'; // haslo do serwera bazy danych
$db_name = '****'; // nazwa bazy danych
 
$connect = mysql_connect($db_host,$db_user,$db_passwd) or
    die("Could not connect: " . mysql_error());
 
mysql_select_db($db_name,$connect);
 
$query = "SELECT user_id, username
FROM phpbb_users 
WHERE user_regdate < 1292025600  
AND user_type != 2 
"; //user_regdate =UNIX time 1292025600 is 12/11/2010 12:00am GMT., user_type =2 to boty je tez wyzucam
$sql1 = mysql_query($query,$connect);
 echo "<table border=1px>";// otwarcei tabeli z zestawieniem userow i nowych wartosci licznika
while($res = mysql_fetch_array($sql1) ) {
  $query2 = 'SELECT COUNT(poster_id) AS licznik 
    FROM phpbb_posts 
    WHERE poster_id = '. $res[0] . ' 
    AND forum_id != 11 
    AND forum_id != 13 
    AND forum_id != 6 
    '; // AND forum_id !=  <--wpisac numery for ktore NIE maja byc zliczane
  $sql2 = mysql_query($query2,$connect);
  while($res2 = mysql_fetch_array($sql2) ) {
    $query3 = "UPDATE phpbb_users 
      SET user_posts = " . $res2['0'] . " 
      WHERE user_id= " . $res['0'] 
      ; //nadpisuje licznik postow na nowe wartosci
    $sql3 = mysql_query($query3,$connect);
      if($sql3) { $zapis="<B> zapisano do bazy</B>";} else {$zapis="<B>NIE UDALO SIE ZAPISAC !!!</B>";} //kontrola zapisu (dla swietego spokoju)
      echo "<tr>";//male gowno do wyswietlania wynikow juz przerobionych w formie tabeli
      echo "<td width =80px>user_id: </td><td width =50px><B>". $res['0'] . "</B></td><td width =75px> o nicku: </td><td width =250px><B>" . $res[1]. "</B></td><td width =80px> napisal </td><td width =100px ><B>" . $res2['0']. "</B></td><td width =400px> postow poza offtopickiem, ". $zapis . " </td>"; 
      echo "</tr>";
  }
}
 echo "</table>";
?>