phpBB.de

Code: Alles auswählen

$sql->query("UPDATE phpbb_users SET user_id = user_id + 1 ORDER BY user_id DESC");

Code: Alles auswählen

$sql->query("UPDATE phpbb_topics SET topic_poster = topic_poster + 1 ORDER BY topic_poster DESC");

Code: Alles auswählen

#avatar paths
#you can use relative or full paths
#note: don't add slashes on the end
$wbb_path = '../forum/wbblite/images/avatars';
$phpbb_path = './images/avatars';

$rows = 50; // Anzahl der Zeilen, die pro Selbstaufruf bearbeitet werden

Code: Alles auswählen

  if (is_writeable($phpbb_path)){
  $exts = array('jpg', 'gif', 'png');
  $d = dir($phpbb_path);
  while (false !== ($entry = $d->read())){
   $file = $phpbb_path.'/'.$entry;
   $ext = ext($entry);
   if (is_file($file) && in_array($ext, $exts)) unlink($file);
  }
  $d->close();
 }else{
  $die  = 'Can\'t write in '.$phpbb_path."\n";
  $die .= 'Please check if the path is correct and that the permissions are set to 777';
  die($die);
 }

#get the file extension of filename
function ext($filename){
 return strtolower(substr(strrchr($filename, '.'), 1));
}

Code: Alles auswählen

}elseif ($step == 8){
#step 8
#copy avatars
 $pos = ($p*$rows)-$rows;
 $res = $sql->query("SELECT * FROM bb".$wbbn."_avatars LIMIT ".$pos.",".$rows);
 while ($row = $sql->fetch($res)){
  $old_avatar = $wbb_path.'/avatar-'.$row['avatarid'].'.'.$row['avatarextension'];
  $new_avatar = $phpbb_path.'/'.uniqid(rand()).'.'.$row['avatarextension'];
  // $new_avatar = $phpbb_path.'/avatar-'.$row['avatarid'].'.'.$row['avatarextension'];
  if (is_readable($old_avatar)){
   if (copy($old_avatar, $new_avatar)){
    @chmod($new_avatar, 0777);
    $sql->query("UPDATE `".$phpbb_prefix."users` SET `user_avatar` = '".basename($new_avatar)."', `user_avatar_type` = 1 WHERE `user_id` = ".$row['userid']);
   }
  }
 }
 $p++;
 $pos = ($p*$rows)-$rows;
 $countres = $sql->query("SELECT * FROM bb".$wbbn."_avatars LIMIT ".$pos.",".$rows);
 $countres = mysql_num_rows($countres);
 if ($countres == 0) nextstep('9');
 else nextstep('8&p='.$p);
}elseif ($step == 9){

}

Code: Alles auswählen

$sql->query("UPDATE phpbb_config SET config_value = 1 WHERE config_name = 'allow_avatar_upload'");

Code: Alles auswählen

function nextstep($nextstep){
 echo '<script language="Javascript">window.location.href = "'.$_SERVER['PHP_SELF'].'?step='.$nextstep.'"</script>';
 #echo '<a href="'.$_SERVER['PHP_SELF'].'?step='.$nextstep.'">click</a>';
 exit;
}

Code: Alles auswählen

 $pos1 = ($p-1)*50;
 $pos2 = $p*50;
 $res = $sql->query("SELECT * FROM bb".$wbbn."_users ORDER BY userid DESC LIMIT ".$pos1.",".$pos2);

 while ($row = $sql->fetch($res)){
	// some code
 }#end while

 $p++;
 $pos1 = ($p-1)*50;
 $pos2 = $p*50;
 $countres = $sql->query("SELECT * FROM bb".$wbbn."_users LIMIT ".$pos1.",".$pos2);
 $countres = mysql_num_rows($countres);
// exit;
 if ($countres == 0) nextstep('3');
 else nextstep('2&p='.$p);