<?php
  header("Content-type: text/plain");
  $host1="sveneppler.de";$user1="gehirnsalat";$pw1="gehirnsalat";$db1="gehirnsalat2";
  $host2="...";$user2="...";$pw2="...";$db2="...";

  $link1=mysql_connect($host1,$user1,$pw1); if (!$link1) { die("no connection 1: ".mysql_error()); }
  $link2=mysql_connect($host2,$user2,$pw2); if (!$link2) { die("no connection 2: ".mysql_error()); }

  $result=mysql_select_db($db1,$link1); if (!$result) { die("no db 1: ".mysql_error()); }
  $result=mysql_select_db($db2,$link2); if (!$result) { die("no db 2: ".mysql_error()); }
  
  // first copy users, then posts.
  
  $sql="SELECT added FROM users ORDER BY added DESC LIMIT 1";
  $result=mysql_query($sql,$link2);
  $result=mysql_fetch_row($result);
  $lastadded = $result[0];
  //var_dump($lastadded);
  $sql="SELECT * FROM users ORDER BY uid ASC";
  $result=mysql_query($sql,$link1); 
  while ($line=mysql_fetch_assoc($result)){ 
    //var_dump($line);
    $sql="INSERT IGNORE INTO users (uid,username) VALUES ( ".$line["uid"]." , '".$line["username"]."' )";
    mysql_query($sql,$link2);
  }

  $sql="SELECT pid FROM posts ORDER BY pid DESC LIMIT 1";
  $result=mysql_query($sql,$link2);
  $result=mysql_fetch_row($result);
  $lastadded = $result[0];
  //var_dump($lastadded);
  $sql="SELECT * FROM posts WHERE pid > ".$lastadded." ORDER BY pid ASC";
  $result=mysql_query($sql,$link1); 
  //echo "\n".mysql_num_rows($result)."\n";
  while ($line=mysql_fetch_assoc($result)){ 
    //var_dump($line);
    $sql="INSERT IGNORE INTO posts (pid,uid,title,post,date) VALUES ( ".$line["pid"]." , ".$line["uid"]." , '".$line["title"]."' , '".$line["post"]."' , '".$line["date"]."' )";
    mysql_query($sql,$link2);
  }

  mysql_close($link1);
  mysql_close($link2);
?>

<?php
  header("Content-type: text/plain");
  $host="...";$user="...";$pw="...";$db="...";
  $link=mysql_connect($host,$user,$pw); if (!$link) { die("no connection: ".mysql_error()); }
  $result=mysql_select_db($db,$link); if (!$result) { die("no db: ".mysql_error()); }
  
  echo " stats total:\n";
  echo " -----------\n";
  
  $sql="SELECT username,COUNT(username) FROM users,posts WHERE posts.uid=users.uid GROUP BY username ORDER BY COUNT(username) DESC";
  $result=mysql_query($sql);
  while ($line=mysql_fetch_row($result)) {
    echo sprintf("%6d",$line[1])." ".$line[0]."\n";
  }
  mysql_close($link);
?>

$sql="SELECT pid FROM posts ORDER BY pid DESC LIMIT 1";
  $result=mysql_query($sql,$link2);
  $result=mysql_fetch_row($result);
  $lastadded = $result[0];
  //var_dump($lastadded);
  $sql="SELECT * FROM posts WHERE pid > ".$lastadded." ORDER BY pid ASC";