Esempio n. 1
0
                $tstart = 1;
            }
            $user = array_search($r[1], $memberdata);
            $email = '';
            $guest = 0;
            if (empty($user)) {
                $user = $r[1];
                $email = $config['forenmail'];
                $guest = 1;
            }
            if ($r[5] == 'N') {
                $dosmileys = 0;
            } else {
                $dosmileys = 1;
            }
            $comment = convertBB($r[7]);
            $comment = $db->escape_string($comment);
            $db->query("\r\n\t\t\tINSERT INTO `{$db->pre}replies`\r\n\t\t\t\t(`board` , `topic` , `topic_id` , `name` , `guest` , `comment` , `dosmileys` , `email` , `ip` , `date` , `tstart` )\r\n\t\t\tVALUES (\r\n\t\t\t\t{$board}, '{$prefix}{$t[2]}', '{$id}', '{$user}', '{$guest}', '{$comment}', '{$dosmileys}', '{$email}', '{$r[2]}' , '{$r[3]}', '{$tstart}'\r\n\t\t\t)");
            $p_i++;
        }
    }
    ?>
	<p>Es wurden <?php 
    echo $t_i;
    ?>
 Themen mit <?php 
    echo $p_i;
    ?>
 Beiträgen konvertiert.</p>
	<p>Derzeit führen Sie Schritt 5 von 6 aus:
	<ol type="I">
Esempio n. 2
0
        }
        if ($p['inoutbox'] == 1) {
            $db->query("\r\n\t\t\tINSERT INTO `{$config['dbprefix']}pm`\r\n\t\t\t(`topic` , `pm_from` , `pm_to` , `comment` , `date` , `status`, `dir` )\r\n\t\t\tVALUES (\r\n\t\t\t'{$p['subject']}', '{$p['recipientid']}', '{$p['senderid']}', '{$p['message']}', '{$p['sendtime']}', '1', '2'\r\n\t\t\t)") or die($db->error());
        }
        $db->query("\r\n\t\tINSERT INTO `{$config['dbprefix']}pm`\r\n\t\t(`topic` , `pm_from` , `pm_to` , `comment` , `date` , `status`, `dir` )\r\n\t\tVALUES (\r\n\t\t'{$p['subject']}', '{$p['senderid']}', '{$p['recipientid']}', '{$p['message']}', '{$p['sendtime']}', '{$p['view']}', '1'\r\n\t\t)") or die($db->error());
        $i++;
    }
    echo 'PMs eingefügt: ' . $i . '!<br /></div><a href="?action=4" class="continue">Weiter (Beiträge)</a>';
} elseif ($_GET['action'] == '2' && $install) {
    echo '<strong>Mitglieder</strong><br /><br />';
    $i = 0;
    $db->query('TRUNCATE TABLE `' . $config['dbprefix'] . 'user`');
    $res = $db->query("\r\n\tSELECT *\r\n\tFROM bb{$n}_users AS u\r\n\t\tLEFT JOIN bb{$n}_avatars AS a ON u.avatarid = a.avatarid\r\n\t\tLEFT JOIN bb{$n}_userfields AS f ON u.userid = f.userid\r\n\tORDER BY u.userid\r\n\t");
    while ($u = $db->fetch_assoc($res)) {
        $u = array_map('addslashes', $u);
        $u['signature'] = convertBB($u['signature']);
        if (empty($u['icq'])) {
            $u['icq'] = 0;
        }
        if ($u['gender'] == 1) {
            $u['gender'] = 'm';
        } elseif ($u['gender'] == 2) {
            $u['gender'] = 'w';
        } else {
            $u['gender'] = '';
        }
        if ($u['avatarid'] > 0) {
            $oldfile = $wbbdir . '/images/avatars/avatar-' . $u['avatarid'];
            $ext = '';
            if (file_exists($oldfile . '.png')) {
                $ext = '.png';