phpBB.de

Code: Alles auswählen

CREATE TABLE bb1_groupcombinations (
  groupcombinationid int(11) unsigned NOT NULL auto_increment,
  groupids text NOT NULL,
  data longtext NOT NULL,
  PRIMARY KEY  (groupcombinationid)
) TYPE=MyISAM;

Code: Alles auswählen

#step 2
#convert user
 $pos1 = ($p-1)*50;
 $pos2 = $p*50;
 $res = $sql->query("SELECT * FROM bb".$wbbn."_users AS u
                     LEFT JOIN bb".$wbbn."_groupcombinations AS gc ON (gc.groupcombinationid = u.groupcombinationid)
                     ORDER BY userid DESC LIMIT ".$pos1.",".$pos2);
 while ($row = $sql->fetch($res)){
  $checkres = $sql->fetch_query("SELECT * FROM ".$phpbb_prefix."users WHERE user_id='".$row['userid']."'");
  if (!isset($checkres['user_id'])){
   phpBB_createuser($row['userid'],addslashes($row['username']),$row['lastvisit'],$row['regdate'],$row['userposts'],$row['timezoneoffset'],$row['dateformat'],$row['password'],$row['email']);
   $groups = explode(',',$row['groupids']);
   foreach ($groups as $tmp=>$gid){
    if ($gid == '1') phpBB_setadmin($row['userid']);
   }#end foreach
  }#end if
 }#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);
 if ($countres == 0) nextstep('3');
 else nextstep('2&p='.$p);
}elseif ($step == 3){

Code: Alles auswählen

#step 5
#convert boards
 $pos = ($p*$rows)-$rows;
 $res = $sql->query("SELECT * FROM bb".$wbbn."_boards WHERE parentid != 0 LIMIT ".$pos.",".$rows);
...