PHP dbtarget函数代码示例

        $valid = 0;
    }
    if (is_null($autoorder)) {
        $autoorder = 0;
    }
    $sql = "update {$plugin_table} set autoorder={$autoorder},valid={$valid} where name='{$path}'";
    if ($dbo->exeUpdate($sql) !== false) {
        comp_plugins_position();
        echo "<script>parent.Dialog.alert('" . $pl_langpackage->pl_update_suc . "')</script>";
    } else {
        echo "<script>parent.Dialog.alert('" . $pl_langpackage->pl_update_false . "')</script>";
    }
}
if (!is_null($path)) {
    //检测是不是有数据库文件
    dbtarget('r', $dbServs);
    $sql = "select *  from {$plugin_table} where name='{$path}'";
    $plugin = $dbo->getRs($sql);
    if (is_array($plugin)) {
        if (isset($plugin[0]['autoorder']) && $plugin[0]['autoorder'] == 1) {
            $autoorder = "checked";
        } else {
            $autoorder = "";
        }
        if (isset($plugin[0]['valid']) && $plugin[0]['valid'] == 1) {
            $valid = "checked";
        } else {
            $valid = "";
        }
        echo <<<EOD
<form method="post" name="uploadform" action="?path={$path}&operator=update">

$m_langpackage = new modulelp();
$ad_langpackage = new adminmenulp();
require "../foundation/fback_search.php";
$is_check = check_rights("c28");
if (!$is_check) {
    echo $m_langpackage->m_no_pri;
    exit;
}
$com_type_select = array("blog_comment" => $m_langpackage->m_blog, "group_subject_comment" => $m_langpackage->m_subject, "album_comment" => $m_langpackage->m_album, "photo_comment" => $m_langpackage->m_photo, "poll_comment" => $m_langpackage->m_poll, "share_comment" => $m_langpackage->m_share, "mood_comment" => $m_langpackage->m_mood);
$com_type = array("photo_comment" => "photo_id", "mood_comment" => "mood_id", "share_comment" => "s_id", "poll_comment" => "p_id", "group_subject_comment" => "subject_id", "album_comment" => "album_id", "blog_comment" => "log_id");
$idtype = get_argg('idtype');
$com_table_str = $idtype ? $idtype : "blog_comment";
$t_table = $tablePreStr . $com_table_str;
$con_id = $com_type[$com_table_str];
$dbo = new dbex();
dbtarget('w', $dbServs);
//当前页面参数
$page_num = trim(get_argg('page'));
//变量区
$c_orderby = short_check(get_argg('order_by'));
$c_ordersc = short_check(get_argg('order_sc'));
$c_perpage = get_argg('perpage') ? intval(get_argg('perpage')) : 20;
$eq_array = array('host_id', 'visitor_id', 'visitor_name', $con_id);
$like_array = array('content');
$date_array = array("add_time");
$num_array = array();
$sql = spell_sql($t_table, $eq_array, $like_array, $date_array, $num_array, $c_orderby, $c_ordersc);
$dbo->setPages($c_perpage, $page_num);
//设置分页
$com_rs = $dbo->getRs($sql);
$page_total = $dbo->totalPage;

function paper_get_unread_papers($user_id)
{
    global $tablePreStr;
    global $dbServs;
    $dbo = new dbex();
    $t_comments = $tablePreStr . "comments";
    $t_papers = $tablePreStr . "papers";
    dbtarget('r', $dbServs);
    $data = array();
    if (null == $user_id) {
        return $data;
    }
    $datasql = "select {$t_papers}.* from {$t_papers} where {$t_papers}.paper_id in \n(select distinct {$t_comments}.paper_id as unread_count from {$t_comments} \n\twhere (({$t_comments}.paper_id in (select {$t_papers}.paper_id from {$t_papers} where {$t_papers}.user_id = {$user_id}) and {$t_comments}.comment_type=1) \n\t\t\t or ({$t_comments}.commenter_id=1 and {$t_comments}.comment_type=2)) \n\t\tand {$t_comments}.comment_status = 0)";
    $data = $dbo->getAll($datasql);
    return $data;
}

function paper_related_update_paper_unread($user_id, $paper_id, $is_user_paper)
{
    global $tablePreStr;
    global $dbServs;
    $dbo = new dbex();
    $t_comments = $tablePreStr . "comments";
    dbtarget('w', $dbServs);
    $updateSql = "";
    if (1 === $is_user_paper) {
        $updateSql = "update {$t_comments} set {$t_comments}.comment_status=1 \n\t\t\t\twhere {$t_comments}.paper_id={$paper_id} and {$t_comments}.comment_type=1";
    } else {
        $updateSql = "update {$t_comments} set {$t_comments}.comment_status=1 \n\t\t\t\twhere {$t_comments}.paper_id={$paper_id} and {$t_comments}.commenter_id = {$user_id} and {$t_comments}.comment_type=2";
    }
    if ($dbo->exeUpdate($updateSql)) {
        return true;
    }
    return false;
}

function comp_plugins($match)
{
    if ($match[1] != '') {
        global $dbo;
        global $tablePreStr;
        global $dbServs;
        if (!isset($dbServs)) {
            require "configuration.php";
            require $webRoot . $baseLibsPath . "conf/dbconf.php";
            require $webRoot . $baseLibsPath . "fdbtarget.php";
            require $webRoot . $baseLibsPath . "libs_inc.php";
            require $webRoot . $baseLibsPath . "cdbex.class.php";
        }
        $plugin_ids = explode(",", $match[1]);
        $sql_str = '';
        foreach ($plugin_ids as $rs) {
            if ($sql_str != '') {
                $sql_str .= ",";
            }
            $sql_str .= "'" . $rs . "'";
        }
        dbtarget('r', $dbServs);
        $dbo = new dbex();
        $plugins_array = array();
        $t_plugins = $tablePreStr . "plugins";
        $t_plugin_url = $tablePreStr . "plugin_url";
        $sql = "SELECT b.* FROM {$t_plugins} a,{$t_plugin_url} b WHERE a.name=b.name and a.valid=1 and b.layout_id in({$sql_str})";
        $rows = $dbo->getRs($sql);
        foreach ($rows as $row) {
            $plugins_array["{$row['layout_id']}"][] = $row;
        }
        $str = serialize($plugins_array);
        return "{sta:\$plugins=unserialize('{$str}');/}";
    }
}

function dbplugin($rw)
{
    global $dbServs;
    dbtarget($rw, $dbServs);
}