コード例 #1
0
ファイル: home_space.php プロジェクト: pan289091315/Discuz
<?php

/**
 * DiscuzX Convert
 *
 * $Id: home_space.php 17393 2010-10-18 02:18:12Z zhengqingpeng $
 */
$curprg = basename(__FILE__);
$oldpre = $db_source->tablepre;
$newpre = $db_target->tablepre;
$limit = $setting['limit']['space'] ? $setting['limit']['space'] : 500;
$nextid = 0;
$start = getgpc('start');
$home = load_process('home');
$defaultgid = $db_target->result_first("SELECT groupid FROM " . $db_target->table('common_usergroup') . " WHERE type='member' AND 0>=creditshigher AND 0<creditslower LIMIT 1");
$query = $db_source->query("SELECT s.*, sf.*\n\tFROM {$oldpre}space s\n\tLEFT JOIN {$oldpre}spacefield sf ON sf.uid=s.uid\n\tWHERE s.uid>'{$start}' ORDER BY s.uid\n\tLIMIT {$limit}");
while ($space = $db_source->fetch_array($query)) {
    $username = daddslashes($space['username']);
    foreach (array('member', 'member_count', 'member_field_forum', 'member_field_home', 'member_profile', 'member_status') as $value) {
        if ($value == 'member') {
            $db_target->query("INSERT INTO {$newpre}common_{$value} (uid, username) VALUES ('{$space['uid']}', '{$username}')", 'SILENT');
        } else {
            $db_target->query("INSERT INTO {$newpre}common_{$value} (uid) VALUES ('{$space['uid']}')", 'SILENT');
        }
    }
    $nextid = $space['uid'];
    if (!empty($space['privacy'])) {
        $space['privacy'] = unserialize($space['privacy']);
        $space['privacy']['feed'] = array();
        $space['privacy'] = serialize($space['privacy']);
    } else {
コード例 #2
0
ファイル: do_convert.inc.php プロジェクト: tanxiniao/bce
<?php

$config = loadconfig();
$db_source = new db_mysql($config['source']);
$db_source->connect();
$db_target = new db_mysql($config['target']);
$db_target->connect();
$db_uc = new db_mysql($config['ucenter']);
if ($setting['config']['ucenter']) {
    $db_uc->connect();
}
$process = load_process('main');
if (empty($process)) {
    showmessage("请首先选择转换程序", "index.php?action=select&source={$source}");
}
$prg = getgpc('prg');
$prg_dir['tables'] = DISCUZ_ROOT . './source/' . $source . '/table/';
$prg_dir['start'] = DISCUZ_ROOT . './source/' . $source . '/';
$prg_dir['steps'] = DISCUZ_ROOT . './source/' . $source . '/';
$prg_done = 0;
$prg_next = '';
$prg_total = $prg_total = count($process['tables']) + count($process['start']) + count($process['steps']);
foreach (array('start', 'tables', 'steps') as $program) {
    if (!empty($process[$program]) && !$process[$program . '_is_end']) {
        foreach ($process[$program] as $k => $v) {
            if ($v) {
                $prg_done++;
            } elseif ($prg_next == '') {
                $prg_next = $k;
            }
        }