$i = '0';
} else {
$i = $_GET['i'];
}
$num = $oldboard->db->query("SELECT * FROM {$oldboard->pre}messages");
$all = $oldboard->db->num_rows($num);
$sql = "SELECT * FROM {$oldboard->pre}messages LIMIT {$start}, {$oldset['post_inc']}";
$newstart = $start + $oldset['post_inc'];
$result = $oldboard->db->query($sql);
while ($row = $oldboard->db->nqfetch($result)) {
if ($row['ID_MEMBER'] < '1') {
$row['ID_MEMBER'] = '1';
} else {
$row['ID_MEMBER']++;
}
$row['body'] = strip_smf_tags($row['body']);
$qsf->db->query("INSERT INTO {$qsf->pre}posts VALUES( {$row['ID_MSG']}, {$row['ID_TOPIC']}, '{$row['ID_MEMBER']}', '{$row['smiliesEnabled']}', 1, '{$row['body']}', {$row['posterTime']}, '', INET_ATON('{$row['posterIP']}'), '', '{$row['modifiedTime']}' )");
$i++;
}
if ($i == $all) {
$oldset['posts'] = '2';
$oldset['post_count'] = $i;
$oldset['converted'] = '2';
write_olddb_sets($oldset);
echo "<meta http-equiv='Refresh' content='0;URL=convert_smf105.php'>";
} else {
$oldset['posts'] = '1';
$oldset['post_count'] = $i;
write_olddb_sets($oldset);
echo "<meta http-equiv='Refresh' content='0;URL=convert_smf105.php'>";
}
$i = 0;
$qsf->db->query("TRUNCATE %pusers");
$qsf->db->query("INSERT INTO %pusers VALUES( 1, 'Guest', '', 0, 1, '', 0, 3, 'default', 'en', '', 'none', 0, 0, '', 0, 0, '0000-00-00', '151', '', 0, '', 0, '', '', '', 0, 1, '', '', '', 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, '' )");
$result = $oldboard->db->query("SELECT * FROM %pmembers");
while ($row = $oldboard->db->nqfetch($result)) {
$row['ID_MEMBER']++;
if ($row['hideEmail'] == '' || $row['hideEmail'] == 0) {
$showmail = 1;
} else {
$showmail = 0;
}
if ($row['lastLogin'] == '' || $row['lastLogin'] == 0) {
$row['lastLogin'] = $row['dateRegistered'];
}
$row['memberName'] = strip_smf_tags($row['memberName']);
$row['emailAddress'] = strip_smf_tags($row['emailAddress']);
$row['websiteUrl'] = strip_yabbse_tags($row['websiteUrl']);
$row['location'] = strip_yabbse_tags($row['location']);
$row['signature'] = strip_yabbse_tags($row['signature']);
// The default YaBB SE groups: You're either an admin or you're not.
if ($row['memberGroup'] == "Administrator") {
$row['memberGroup'] = 1;
} else {
$row['memberGroup'] = 2;
}
$result2 = $oldboard->db->query("SELECT * FROM %pbanned WHERE type='username' AND value='%s'", $row['memberName']);
while ($row2 = $oldboard->db->nqfetch($result2)) {
$row['memberGroup'] = 4;
}
$pos = strpos($row['avatar'], '://');
if ($pos == 4) {
