PHP implode_field_value函数代码示例

    $db_target->query("INSERT INTO {$table_target}_field_home SET {$data}");
    $db_target->query("INSERT INTO {$table_target}_log SET {$data}");
    $db_target->query("INSERT INTO {$table_target}_profile SET {$data}");
    $db_target->query("INSERT INTO {$table_target}_status SET {$data}");
    $db_uc->query("INSERT INTO {$table_target_uc_memberfields} SET {$data}");
    $row = daddslashes($row, 1);
    $unset = array('regip', 'lastip', 'lastvisit', 'lastactivity', 'lastpost', 'posts', 'threads', 'digestposts', 'pageviews', 'extcredits1', 'extcredits2', 'extcredits3', 'extcredits4', 'extcredits5', 'extcredits6', 'extcredits7', 'extcredits8', 'bday', 'sigstatus', 'tpp', 'ppp', 'styleid', 'dateformat', 'timeformat', 'pmsound', 'showemail', 'newsletter', 'invisible', 'prompt', 'editormode', 'customshow', 'xspacestatus', 'customaddfeed', 'newbietaskid', 'secques', 'gender');
    list($year, $month, $day) = explode('-', $row['bday']);
    $row['notifysound'] = $row['pmsound'];
    $update = array('status' => array('regip' => $row['regip'], 'lastip' => $row['lastip'], 'lastvisit' => $row['lastvisit'], 'lastactivity' => $row['lastactivity'], 'lastpost' => $row['lastpost'], 'buyercredit' => $row['buyercredit'], 'sellercredit' => $row['sellercredit']), 'count' => array('posts' => $row['posts'], 'threads' => $row['threads'], 'digestposts' => $row['digestposts'], 'extcredits1' => $row['extcredits1'], 'extcredits2' => $row['extcredits2'], 'extcredits3' => $row['extcredits3'], 'extcredits4' => $row['extcredits4'], 'extcredits5' => $row['extcredits5'], 'extcredits6' => $row['extcredits6'], 'extcredits7' => $row['extcredits7'], 'extcredits8' => $row['extcredits8'], 'oltime' => $row['oltime']), 'profile' => array('birthyear' => $year, 'birthmonth' => $month, 'birthday' => $day, 'gender' => $row['gender'], 'site' => $rowfield['site'], 'alipay' => $rowfield['alipay'], 'icq' => $rowfield['icq'], 'qq' => $rowfield['qq'], 'yahoo' => $rowfield['yahoo'], 'msn' => $rowfield['msn'], 'taobao' => $rowfield['taobao'], 'address' => $rowfield['location'], 'bio' => $rowfield['bio']), 'field_forum' => array('customshow' => $row['customshow'], 'customstatus' => $rowfield['customstatus'], 'medals' => $rowfield['medals'], 'sightml' => $rowfield['sightml'], 'groupterms' => $rowfield['groupterms'], 'authstr' => $rowfield['authstr']));
    foreach ($unset as $k) {
        unset($row[$k]);
    }
    foreach ($update as $table => $trow) {
        $data = implode_field_value($trow, ',', db_table_fields($db_target, $table_target . '_' . $table));
        $db_target->query("UPDATE {$table_target}_{$table} SET {$data} WHERE uid='{$row['uid']}'");
    }
    $data = implode_field_value($row, ',', db_table_fields($db_target, $table_target));
    $db_target->query("INSERT INTO {$table_target} SET {$data}");
    $salt = rand(100000, 999999);
    $row['password'] = md5($row['password'] . $salt);
    $row['salt'] = $salt;
    $rows = array('uid' => $row['uid'], 'username' => $row['username'], 'password' => $row['password'], 'email' => $row['email'], 'myid' => '', 'myidkey' => '', 'regip' => $row['regip'], 'regdate' => $row['regdate'], 'lastloginip' => '', 'lastlogintime' => '', 'salt' => $row['salt'], 'secques' => $row['secques']);
    $data = implode_field_value($rows, ',', db_table_fields($db_uc, $table_target_uc_member));
    $db_uc->query("INSERT INTO {$table_target_uc_member} SET {$data}");
}
if ($nextid) {
    showmessage("继续转换数据表 " . $table_source . " uid > {$nextid}", "index.php?a={$action}&source={$source}&prg={$curprg}&start={$nextid}");
} else {
    $db_target->query("UPDATE {$table_target} SET emailstatus=1 WHERE groupid<>8");
}

<?php

/**
 * DiscuzX Convert
 *
 * $Id: access.php 10469 2010-05-11 09:12:14Z monkey $
 * English by Valery Votintsev at sources.ru
 */
$curprg = basename(__FILE__);
$table_source = $db_source->tablepre . 'access';
$table_target = $db_target->tablepre . 'forum_access';
$limit = 2000;
$nextid = 0;
$start = getgpc('start');
if (empty($start)) {
    $start = 0;
    $db_target->query("TRUNCATE {$table_target}");
}
$query = $db_source->query("SELECT * FROM {$table_source} LIMIT {$start}, {$limit}");
while ($row = $db_source->fetch_array($query)) {
    $nextid = 1;
    $row = daddslashes($row, 1);
    $data = implode_field_value($row, ',', db_table_fields($db_target, $table_target));
    $db_target->query("INSERT INTO {$table_target} SET {$data}");
}
if ($nextid) {
    showmessage(lang('continue_convert_table') . $table_source . lang('from') . $start . lang('to') . ($start + $limit) . lang('lines'), "index.php?a={$action}&source={$source}&prg={$curprg}&start=" . ($start + $limit));
    //vot
}

function block_import($data)
{
    global $_G;
    if (!is_array($data['block'])) {
        return;
    }
    $data = daddslashes($data);
    $stylemapping = array();
    if ($data['style']) {
        $hashes = $styles = array();
        foreach ($data['style'] as $value) {
            $hashes[] = $value['hash'];
            $styles[$value['hash']] = $value['styleid'];
        }
        $query = $_G['db']->query('SELECT styleid, hash FROM ' . $_G['tablepre'] . "common_block_style WHERE hash IN (" . dimplode($hashes) . ')');
        while ($value = $_G['db']->fetch_array($query)) {
            $id = $styles[$value['hash']];
            $stylemapping[$id] = intval($value['styleid']);
            unset($styles[$value['hash']]);
        }
        foreach ($styles as $id) {
            $style = $data['style'][$id];
            $style['styleid'] = '';
            if (is_array($style['template'])) {
                $style['template'] = dstripslashes($style['template']);
                $style['template'] = addslashes(serialize($style['template']));
            }
            $sql = implode_field_value($style);
            $_G['db']->query('INSERT INTO ' . $_G['tablepre'] . 'common_block_style SET ' . $sql);
            $newid = $_G['db']->insert_id();
            $stylemapping[$id] = $newid;
        }
    }
    $blockmapping = array();
    foreach ($data['block'] as $block) {
        $oid = $block['bid'];
        if (!empty($block['styleid'])) {
            $block['styleid'] = intval($stylemapping[$block['styleid']]);
        }
        $block['bid'] = '';
        $block['uid'] = $_G['uid'];
        $block['username'] = $_G['username'];
        $block['dateline'] = 0;
        if (is_array($block['param'])) {
            $block['param'] = dstripslashes($block['param']);
            $block['param'] = addslashes(serialize($block['param']));
        }
        $sql = implode_field_value($block);
        $_G['db']->query('INSERT INTO ' . $_G['tablepre'] . 'common_block SET ' . $sql);
        $newid = $_G['db']->insert_id();
        $blockmapping[$oid] = $newid;
    }
    return $blockmapping;
}

<?php

/**
 * DiscuzX Convert
 *
 * $Id: trades.php 10469 2010-05-11 09:12:14Z monkey $
 */
$curprg = basename(__FILE__);
$table_source = $db_source->tablepre . 'trades';
$table_target = $db_target->tablepre . 'forum_trade';
$limit = 2000;
$nextid = 0;
$start = getgpc('start');
if ($start == 0) {
    $start = 0;
    $db_target->query("TRUNCATE {$table_target}");
}
$query = $db_source->query("SELECT * FROM {$table_source} LIMIT {$start}, {$limit}");
while ($data = $db_source->fetch_array($query)) {
    $nextid = 1;
    $data = daddslashes($data, 1);
    $datalist = implode_field_value($data, ',', db_table_fields($db_target, $table_target));
    $db_target->query("INSERT INTO {$table_target} SET {$datalist}");
}
if ($nextid) {
    showmessage("繼續轉換數據表 " . $table_source . " {$start} 至 " . ($start + $limit) . " 行", "index.php?a={$action}&source={$source}&prg={$curprg}&start=" . ($start + $limit));
}

<?php

/**
 * DiscuzX Convert
 *
 * $Id: home_comment.php 15720 2010-08-25 23:56:08Z monkey $
 * English by Valery Votintsev at sources.ru
 */
$curprg = basename(__FILE__);
$table_source = $db_source->tablepre . 'comment';
$table_target = $db_target->tablepre . 'home_comment';
$limit = $setting['limit']['comment'] ? $setting['limit']['comment'] : 1000;
$nextid = 0;
$start = getgpc('start');
if ($start == 0) {
    $db_target->query("TRUNCATE {$table_target}");
}
$query = $db_source->query("SELECT  * FROM {$table_source} WHERE cid>'{$start}' AND (idtype='blogid' OR idtype='uid' OR idtype='picid' OR idtype='sid') ORDER BY cid LIMIT {$limit}");
while ($comment = $db_source->fetch_array($query)) {
    $nextid = $comment['cid'];
    $comment = daddslashes($comment, 1);
    $data = implode_field_value($comment, ',', db_table_fields($db_target, $table_target));
    $db_target->query("INSERT INTO {$table_target} SET {$data}");
}
if ($nextid) {
    showmessage(lang('update', 'continue_convert_table') . $table_source . " cid> {$nextid}", "index.php?a={$action}&source={$source}&prg={$curprg}&start={$nextid}");
}

<?php

/**
 * DiscuzX Convert
 *
 * $Id: threadtypes.php 10469 2010-05-11 09:12:14Z monkey $
 */
$curprg = basename(__FILE__);
$table_source = $db_source->tablepre . 'threadtypes';
$table_target = $db_target->tablepre . 'forum_threadtype';
$limit = 100;
$nextid = 0;
$start = getgpc('start');
if ($start == 0) {
    $db_target->query("TRUNCATE {$table_target}");
}
$query = $db_source->query("SELECT * FROM {$table_source} WHERE typeid>'{$start}' AND special='1' ORDER BY typeid LIMIT {$limit}");
while ($threadtype = $db_source->fetch_array($query)) {
    $nextid = $threadtype['typeid'];
    $threadtype = daddslashes($threadtype, 1);
    $data = implode_field_value($threadtype, ',', db_table_fields($db_target, $table_target));
    $db_target->query("INSERT INTO {$table_target} SET {$data}");
}
if ($nextid) {
    showmessage("繼續轉換數據表 " . $table_source . " typeid > {$nextid}", "index.php?a={$action}&source={$source}&prg={$curprg}&start={$nextid}");
}

    $data = daddslashes($data, 1);
    foreach ($usergroup as $field) {
        $userdata[$field] = $data[$field];
    }
    $data['allowsearch'] = $data['allowsearch'] ? 63 : 0;
    foreach ($usergroup_field as $field) {
        $userfielddata[$field] = $data[$field];
    }
    $userfielddata['allowpostimage'] = $userfielddata['allowpostattach'];
    if ($userfielddata['raterange']) {
        $raterangearray = array();
        foreach (explode("\n", $userfielddata['raterange']) as $range) {
            $range = explode("\t", $range);
            if (count($range) == 4) {
                $raterangearray[$range[0]] = implode("\t", array($range[0], 'isself' => 0, 'min' => $range[1], 'max' => $range[2], 'mrpd' => $range[3]));
            }
        }
        if (!empty($raterangearray)) {
            $userfielddata['raterange'] = implode("\n", $raterangearray);
        }
    }
    $userdatalist = implode_field_value($userdata, ',', db_table_fields($db_target, $table_target));
    $userfielddatalist = implode_field_value($userfielddata, ',', db_table_fields($db_target, $table_target_field));
    $db_target->query("INSERT INTO {$table_target} SET {$userdatalist}");
    $db_target->query("INSERT INTO {$table_target_field} SET {$userfielddatalist}");
}
if ($nextid) {
    showmessage("继续转换数据表 " . $table_source . " groupid > {$nextid}", "index.php?a={$action}&source={$source}&prg={$curprg}&start={$nextid}");
} else {
    $db_target->query("UPDATE {$table_target} SET allowvisit='2' WHERE groupid='1'");
}

$table_source = $db_source->tablepre . 'mailcron';
$table_target = $db_target->tablepre . 'common_mailcron';
$table_source_rel = $db_source->tablepre . 'mailqueue';
$table_target_rel = $db_target->tablepre . 'common_mailqueue';
$limit = 1000;
$nextid = 0;
$start = getgpc('start');
if ($start == 0) {
    $db_target->query("TRUNCATE {$table_target}");
    $db_target->query("TRUNCATE {$table_target_rel}");
}
$query = $db_source->query("SELECT  * FROM {$table_source} WHERE cid>'{$start}' ORDER BY cid LIMIT {$limit}");
$mcids = array();
while ($rs = $db_source->fetch_array($query)) {
    $mcids[] = $rs['cid'];
    $nextid = $rs['cid'];
    $rs = daddslashes($rs, 1);
    $data = implode_field_value($rs, ',', db_table_fields($db_target, $table_target));
    $db_target->query("INSERT INTO {$table_target} SET {$data}");
}
if (!empty($mcids)) {
    $query = $db_source->query("SELECT  * FROM {$table_source_rel} WHERE cid IN (" . dimplode($mcids) . ")");
    while ($rs = $db_source->fetch_array($query)) {
        $rs = daddslashes($rs, 1);
        $data = implode_field_value($rs, ',', db_table_fields($db_target, $table_target_rel));
        $db_target->query("INSERT INTO {$table_target_rel} SET {$data}");
    }
}
if ($nextid) {
    showmessage(lang('update', 'continue_convert_table') . $table_source . " mcid> {$nextid}", "index.php?a={$action}&source={$source}&prg={$curprg}&start={$nextid}");
}

/**
 * DiscuzX Convert
 *
 * $Id: spacenews.php 15777 2010-08-26 04:00:58Z zhengqingpeng $
 * English by Valery Votintsev at sources.ru
 */
$curprg = basename(__FILE__);
$table_source = $db_source->tablepre . 'spacenews';
$table_target = $db_target->tablepre . 'portal_article_content';
$limit = 1000;
$nextid = 0;
$start = getgpc('start');
if ($start == 0) {
    $db_target->query("TRUNCATE {$table_target}");
}
$query = $db_source->query("SELECT * FROM {$table_source} WHERE nid>'{$start}' ORDER BY nid LIMIT {$limit}");
while ($news = $db_source->fetch_array($query)) {
    $nextid = $news['nid'];
    $setcontent = array();
    $setcontent['cid'] = $news['nid'];
    $setcontent['aid'] = $news['itemid'];
    $setcontent['content'] = $news['message'];
    $setcontent['pageorder'] = $news['pageorder'];
    $setcontent['dateline'] = $news['dateline'];
    $setcontent = daddslashes($setcontent, 1);
    $data = implode_field_value($setcontent, ',', db_table_fields($db_target, $table_target));
    $db_target->query("INSERT INTO {$table_target} SET {$data}");
}
if ($nextid) {
    showmessage(lang('update', 'continue_convert_table') . $table_source . " nid> {$nextid}", "index.php?a={$action}&source={$source}&prg={$curprg}&start={$nextid}");
}

    if ($value['type'] == 'zone') {
        $menuzone[] = $value;
    }
    if ($value['type'] == 'group') {
        $menugroup[] = $value;
    }
    if ($value['type'] == 'item') {
        $itemstrarray[$value['node']][] = "'{$value['mcode']}' : ['{$value['mname']}','{$value['murl']}','']";
    }
}
foreach ($menuzone as $value) {
    foreach ($menugroup as $value1) {
        if ($value1['node'] == $value['mid']) {
            $groupstrarray[$value['mid']][] = "'{$value1['mcode']}' : {" . implode_field_value($itemstrarray[$value1['mid']], ',') . "}";
        }
    }
}
foreach ($menuzone as $value) {
    $zonestrarray[] = "'{$value['mcode']}' : {" . implode_field_value($groupstrarray[$value['mid']], ',') . "}";
}
function implode_field_value($array, $glue = ',')
{
    $sql = $comma = '';
    foreach ($array as $k => $v) {
        $sql .= $comma . "{$v}";
        $comma = $glue;
    }
    return $sql;
}
//包含后台模板文件
include "tpl/index.htm";

        }
        //出错！
        if (strlen($adminpwd) != 32) {
            $adminpwd = md5($adminpwd);
        }
        //用户密码加密
        if (is_array($mid)) {
            $adminmid = getdotstring($mid, 'int');
        }
        //格式化成id,id形式
        foreach ($menuarray as $value) {
            if (in_array($value['mid'], $mid)) {
                $temparray[] = $value['mcode'];
            }
        }
        $adminpurview = implode_field_value($temparray);
        //格式化成id,id形式
        $arrayadd = array("adminname" => Char_cv($adminname), "adminpwd" => Char_cv($adminpwd), "adminmid" => $adminmid, "adminpurview" => $adminpurview);
        $info = $Table->edit($adminid, $arrayadd);
        if ($info == "OK") {
            exit("<script language='javascript'>alert('编辑成功');parent.\$.fn.colorbox.close();</script>");
        } else {
            exit("<script language='javascript'>alert('编辑失败');history.go(-1);</script>");
        }
    } else {
        $evalue = $Table->getone($adminid);
        //print_r($evalue);
        include "tpl/admin_add.htm";
    }
} else {
    showmsg("未知请求", "-1");