$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) {