当前位置: 首页>>代码示例>>PHP>>正文


PHP GetValueInArrayByCurrent函数代码示例

本文整理汇总了PHP中GetValueInArrayByCurrent函数的典型用法代码示例。如果您正苦于以下问题:PHP GetValueInArrayByCurrent函数的具体用法?PHP GetValueInArrayByCurrent怎么用?PHP GetValueInArrayByCurrent使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。


在下文中一共展示了GetValueInArrayByCurrent函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: AuditRecords_AddMenu

function AuditRecords_AddMenu(&$m)
{
    global $zbp;
    array_unshift($m, '');
    $n = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(log_ID) AS num FROM ' . $GLOBALS['table']['Post'] . ' WHERE log_Type=0 AND log_Status=2'), 'num');
    $m[0] = $m[1];
    $m[1] = MakeLeftMenu("audit", "(" . $n . ")审核管理", $zbp->host . "zb_users/plugin/AuditRecords/main.php", "nav_AuditRecords", "aAuditRecords", "");
}
开发者ID:zblogcn,项目名称:zblogphp,代码行数:8,代码来源:include.php

示例2: buildCreate

 /**
  * @todo
  * @override
  */
 protected function buildCreate()
 {
     $sqlAll = array();
     foreach ($this->table as $tableIndex => $table) {
         $sql = array();
         $sql[] = 'CREATE TABLE ' . $table;
         $sql[] = ' (';
         $createData = array();
         $idname = GetValueInArrayByCurrent($this->data, 0);
         $i = 0;
         foreach ($this->data as $key => $value) {
             if ($value[1] == 'integer') {
                 if ($i == 0) {
                     $createData[] = $value[0] . ' integer primary key' . ($this->dbclass == 'DbSQLite' ? '' : ' autoincrement');
                 } else {
                     $createData[] = $value[0] . ' integer NOT NULL DEFAULT \'' . $value[3] . '\'';
                 }
             }
             if ($value[1] == 'boolean') {
                 $createData[] = $value[0] . ' bit NOT NULL DEFAULT \'' . (int) $value[3] . '\'';
             }
             if ($value[1] == 'string') {
                 if ($value[2] != '') {
                     if (strpos($value[2], 'char') !== false) {
                         $createData[] = $value[0] . ' char(' . str_replace('char', '', $value[2]) . ') NOT NULL DEFAULT \'' . $value[3] . '\'';
                     } elseif (is_int($value[2])) {
                         $createData[] = $value[0] . ' varchar(' . $value[2] . ') NOT NULL DEFAULT \'' . $value[3] . '\'';
                     } else {
                         $createData[] = $value[0] . ' text NOT NULL DEFAULT \'\'';
                     }
                 } else {
                     $createData[] = $value[0] . ' text NOT NULL DEFAULT \'\'';
                 }
             }
             if ($value[1] == 'double' || $value[1] == 'float') {
                 $createData[] = $value[0] . " {$value['1']} NOT NULL DEFAULT 0";
             }
             if ($value[1] == 'date' || $value[1] == 'datetime') {
                 $createData[] = $value[0] . " {$value['1']} NOT NULL";
             }
             if ($value[1] == 'timestamp') {
                 $createData[] = $value[0] . " {$value['1']} NOT NULL DEFAULT CURRENT_TIMESTAMP";
             }
             $i += 1;
         }
         $sql[] = implode(', ', $createData);
         $sql[] = ');';
         $sql[] = 'CREATE UNIQUE INDEX ' . $table . '_' . $idname;
         $sql[] = ' on ' . $table . ' (' . $idname . ');';
         $sqlAll[] = implode($sql, ' ');
     }
     $this->_sql = $sqlAll;
 }
开发者ID:zblogcn,项目名称:zblogphp,代码行数:57,代码来源:sqlsqlite.php

示例3: Zbp_Admin_Addcmtsubmenu

/**
 * 添加评论管理子菜单
 */
function Zbp_Admin_Addcmtsubmenu()
{
    global $zbp;
    if ($zbp->CheckRights('CommentAll')) {
        $n = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(comm_ID) AS num FROM ' . $GLOBALS['table']['Comment'] . ' WHERE comm_Ischecking=1'), 'num');
        if ($n != 0) {
            $n = ' (' . $n . ')';
        } else {
            $n = '';
        }
        echo '<a href="../cmd.php?act=CommentMng&amp;ischecking=1"><span class="m-left ' . (GetVars('ischecking') ? 'm-now' : '') . '">' . $GLOBALS['lang']['msg']['check_comment'] . $n . '</span></a>';
    }
}
开发者ID:jdjjdkdkdm,项目名称:zblogphp,代码行数:16,代码来源:c_system_admin.php

示例4: misc_statistic

function misc_statistic()
{
    global $zbp;
    $zbp->BuildTemplate();
    $r = null;
    CountNormalArticleNums();
    CountTopArticle(null, null);
    CountCommentNums(null, null);
    $all_comments = $zbp->cache->all_comment_nums;
    $xmlrpc_address = $zbp->xmlrpcurl;
    $current_member = $zbp->user->Name;
    $current_version = ZC_VERSION_FULL;
    $all_artiles = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(*) AS num FROM ' . $GLOBALS['table']['Post'] . ' WHERE log_Type=\'0\''), 'num');
    $all_pages = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(*) AS num FROM ' . $GLOBALS['table']['Post'] . ' WHERE log_Type=\'1\''), 'num');
    $all_categorys = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(*) AS num FROM ' . $GLOBALS['table']['Category']), 'num');
    $all_views = $zbp->option['ZC_VIEWNUMS_TURNOFF'] == true ? 0 : GetValueInArrayByCurrent($zbp->db->Query('SELECT SUM(log_ViewNums) AS num FROM ' . $GLOBALS['table']['Post']), 'num');
    $all_tags = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(*) as num FROM ' . $GLOBALS['table']['Tag']), 'num');
    $all_members = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(*) AS num FROM ' . $GLOBALS['table']['Member']), 'num');
    $current_theme = '{$zbp->theme}';
    $current_style = '{$zbp->style}';
    $current_member = '{$zbp->user->Name}';
    $current_version = '{$zbp->version}';
    $system_environment = '{$system_environment}';
    if ($zbp->option['ZC_DEBUG_MODE']) {
        $r .= "<tr><td colspan='4' style='text-align: center'>{$zbp->lang['msg']['debugging_warning']}</td></tr>";
    }
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['current_member']}</td><td class='td30'><a href='../cmd.php?act=misc&type=vrs' target='_blank'>{$current_member}</a></td><td class='td20'>{$zbp->lang['msg']['current_version']}</td><td class='td30'>{$current_version}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['all_artiles']}</td><td>{$all_artiles}</td><td>{$zbp->lang['msg']['all_categorys']}</td><td>{$all_categorys}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['all_pages']}</td><td>{$all_pages}</td><td>{$zbp->lang['msg']['all_tags']}</td><td>{$all_tags}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['all_comments']}</td><td>{$all_comments}</td><td>{$zbp->lang['msg']['all_views']}</td><td>{$all_views}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['current_theme']} / {$zbp->lang['msg']['current_style']}</td><td>{$current_theme}/{$current_style}</td><td>{$zbp->lang['msg']['all_members']}</td><td>{$all_members}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['xmlrpc_address']}</td><td>{$xmlrpc_address}</td><td>{$zbp->lang['msg']['system_environment']}</td><td><a href='../cmd.php?act=misc&type=phpinfo' target='_blank'>{$system_environment}</a></td></tr>";
    $r .= "<script type=\"text/javascript\">\$('#statistic').attr('title','" . date("c", $zbp->cache->reload_statistic_time) . "');</script>";
    $zbp->cache->reload_statistic = $r;
    $zbp->cache->reload_statistic_time = time();
    $zbp->cache->system_environment = GetEnvironment();
    $zbp->cache->all_article_nums = $all_artiles;
    $zbp->cache->all_page_nums = $all_pages;
    $zbp->AddBuildModule('statistics', array($all_artiles, $all_pages, $all_categorys, $all_tags, $all_views, $all_comments));
    $zbp->BuildModule();
    $zbp->SaveCache();
    $r = str_replace('{#ZC_BLOG_HOST#}', $zbp->host, $r);
    $r = str_replace('{$zbp->user->Name}', $zbp->user->Name, $r);
    $r = str_replace('{$zbp->theme}', $zbp->theme, $r);
    $r = str_replace('{$zbp->style}', $zbp->style, $r);
    $r = str_replace('{$zbp->version}', ZC_VERSION_FULL, $r);
    $r = str_replace('{$system_environment}', $zbp->cache->system_environment, $r);
    echo $r;
}
开发者ID:zblogcn,项目名称:zblogphp,代码行数:49,代码来源:c_system_misc.php

示例5: misc_statistic

function misc_statistic()
{
    global $zbp;
    $r = null;
    $zbp->BuildTemplate();
    $xmlrpc_address = $zbp->host . 'zb_system/xml-rpc/';
    $current_member = $zbp->user->Name;
    $current_version = $zbp->option['ZC_BLOG_VERSION'];
    $all_artiles = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(*) AS num FROM ' . $GLOBALS['table']['Post'] . ' WHERE log_Type=0'), 'num');
    $all_pages = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(*) AS num FROM ' . $GLOBALS['table']['Post'] . ' WHERE log_Type=1'), 'num');
    $all_categorys = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(*) AS num FROM ' . $GLOBALS['table']['Category']), 'num');
    $all_comments = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(*) AS num FROM ' . $GLOBALS['table']['Comment']), 'num');
    $all_views = $zbp->option['ZC_VIEWNUMS_TURNOFF'] == true ? 0 : GetValueInArrayByCurrent($zbp->db->Query('SELECT SUM(log_ViewNums) AS num FROM ' . $GLOBALS['table']['Post']), 'num');
    $all_tags = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(*) as num FROM ' . $GLOBALS['table']['Tag']), 'num');
    $all_members = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(*) AS num FROM ' . $GLOBALS['table']['Member']), 'num');
    $current_theme = $zbp->theme;
    $current_style = $zbp->style;
    $current_member = '{$zbp->user->Name}';
    $ajax = Network::Create();
    if ($ajax) {
        $ajax = substr(get_class($ajax), 7);
    }
    $system_environment = PHP_OS . ';' . GetValueInArray(explode(' ', str_replace(array('Microsoft-', '/'), array('', ''), GetVars('SERVER_SOFTWARE', 'SERVER'))), 0) . ';' . 'PHP' . phpversion() . ';' . $zbp->option['ZC_DATABASE_TYPE'] . ';' . $ajax;
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['current_member']}</td><td class='td30'>{$current_member}</td><td class='td20'>{$zbp->lang['msg']['current_version']}</td><td class='td30'>{$current_version}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['all_artiles']}</td><td>{$all_artiles}</td><td>{$zbp->lang['msg']['all_categorys']}</td><td>{$all_categorys}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['all_pages']}</td><td>{$all_pages}</td><td>{$zbp->lang['msg']['all_tags']}</td><td>{$all_tags}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['all_comments']}</td><td>{$all_comments}</td><td>{$zbp->lang['msg']['all_views']}</td><td>{$all_views}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['current_theme']}/{$zbp->lang['msg']['current_style']}</td><td>{$current_theme}/{$current_style}</td><td>{$zbp->lang['msg']['all_members']}</td><td>{$all_members}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['xmlrpc_address']}</td><td>{$xmlrpc_address}</td><td>{$zbp->lang['msg']['system_environment']}</td><td>{$system_environment}</td></tr>";
    $zbp->cache->reload_statistic = $r;
    $zbp->cache->reload_statistic_time = time();
    $zbp->cache->system_environment = $system_environment;
    //$zbp->SaveCache();
    CountNormalArticleNums();
    $zbp->AddBuildModule('statistics', array($all_artiles, $all_pages, $all_categorys, $all_tags, $all_views, $all_comments));
    $zbp->BuildModule();
    $r = str_replace('{#ZC_BLOG_HOST#}', $zbp->host, $r);
    $r = str_replace('{$zbp->user->Name}', $zbp->user->Name, $r);
    echo $r;
}
开发者ID:jdjjdkdkdm,项目名称:zblogphp,代码行数:40,代码来源:c_system_misc.php

示例6: misc_statistic

function misc_statistic()
{
    global $zbp;
    $r = null;
    $zbp->BuildTemplate();
    $xmlrpc_address = $zbp->host . 'zb_system/xml-rpc/';
    $current_member = $zbp->user->Name;
    $current_version = $zbp->option['ZC_BLOG_VERSION'];
    $all_artiles = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(log_ID) AS num FROM ' . $GLOBALS['table']['Post'] . ' WHERE log_Type=0'), 'num');
    $all_pages = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(log_ID) AS num FROM ' . $GLOBALS['table']['Post'] . ' WHERE log_Type=1'), 'num');
    $all_categorys = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(cate_ID) AS num FROM ' . $GLOBALS['table']['Category']), 'num');
    $all_comments = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(comm_ID) AS num FROM ' . $GLOBALS['table']['Comment']), 'num');
    $all_views = GetValueInArrayByCurrent($zbp->db->Query('SELECT SUM(log_ViewNums) AS num FROM ' . $GLOBALS['table']['Post']), 'num');
    $all_tags = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(tag_ID) as num FROM ' . $GLOBALS['table']['Tag']), 'num');
    $all_members = GetValueInArrayByCurrent($zbp->db->Query('SELECT COUNT(mem_ID) AS num FROM ' . $GLOBALS['table']['Member']), 'num');
    $current_theme = $zbp->theme;
    $current_style = $zbp->style;
    $current_member = '{$zbp->user->Name}';
    $system_environment = PHP_OS . ';' . GetValueInArray(explode('/', GetVars('SERVER_SOFTWARE', 'SERVER')), 0) . ';' . 'PHP ' . phpversion() . ';' . $zbp->option['ZC_DATABASE_TYPE'];
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['current_member']}</td><td class='td30'>{$current_member}</td><td class='td20'>{$zbp->lang['msg']['current_version']}</td><td class='td30'>{$current_version}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['all_artiles']}</td><td>{$all_artiles}</td><td>{$zbp->lang['msg']['all_categorys']}</td><td>{$all_categorys}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['all_pages']}</td><td>{$all_pages}</td><td>{$zbp->lang['msg']['all_tags']}</td><td>{$all_tags}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['all_comments']}</td><td>{$all_comments}</td><td>{$zbp->lang['msg']['all_views']}</td><td>{$all_views}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['current_theme']}/{$zbp->lang['msg']['current_style']}</td><td>{$current_theme}/{$current_style}</td><td>{$zbp->lang['msg']['all_members']}</td><td>{$all_members}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['xmlrpc_address']}</td><td>{$xmlrpc_address}</td><td>{$zbp->lang['msg']['system_environment']}</td><td>{$system_environment}</td></tr>";
    $s = $zbp->db->sql->Count($zbp->table['Post'], array(array('COUNT', '*', 'num')), array(array('=', 'log_Type', 0), array('=', 'log_IsTop', 0), array('=', 'log_Status', 0)));
    $num = GetValueInArrayByCurrent($zbp->db->Query($s), 'num');
    $zbp->LoadConfigs();
    $zbp->LoadCache();
    $zbp->cache->reload_statistic = $r;
    $zbp->cache->reload_statistic_time = time();
    $zbp->cache->normal_article_nums = $num;
    $zbp->SaveCache();
    $zbp->AddBuildModule('statistics', array($all_artiles, $all_pages, $all_categorys, $all_tags, $all_views, $all_comments));
    $zbp->BuildModule();
    $r = str_replace('{$zbp->user->Name}', $zbp->user->Name, $r);
    echo $r;
}
开发者ID:jdjjdkdkdm,项目名称:zblogphp,代码行数:38,代码来源:c_system_misc.php

示例7: BuildModule_archives

function BuildModule_archives()
{
    global $zbp;
    $fdate;
    $ldate;
    $sql = $zbp->db->sql->Select($zbp->table['Post'], array('log_PostTime'), null, array('log_PostTime' => 'DESC'), array(1), null);
    $array = $zbp->db->Query($sql);
    if (count($array) == 0) {
        return '';
    }
    $ldate = array(date('Y', $array[0]['log_PostTime']), date('m', $array[0]['log_PostTime']));
    $sql = $zbp->db->sql->Select($zbp->table['Post'], array('log_PostTime'), null, array('log_PostTime' => 'ASC'), array(1), null);
    $array = $zbp->db->Query($sql);
    if (count($array) == 0) {
        return '';
    }
    $fdate = array(date('Y', $array[0]['log_PostTime']), date('m', $array[0]['log_PostTime']));
    $arraydate = array();
    for ($i = $fdate[0]; $i < $ldate[0] + 1; $i++) {
        for ($j = 1; $j < 13; $j++) {
            $arraydate[] = strtotime($i . '-' . $j);
        }
    }
    foreach ($arraydate as $key => $value) {
        if ($value - strtotime($ldate[0] . '-' . $ldate[1]) > 0) {
            unset($arraydate[$key]);
        }
        if ($value - strtotime($fdate[0] . '-' . $fdate[1]) < 0) {
            unset($arraydate[$key]);
        }
    }
    $arraydate = array_reverse($arraydate);
    $s = '';
    foreach ($arraydate as $key => $value) {
        $url = new UrlRule($zbp->option['ZC_DATE_REGEX']);
        $url->Rules['{%date%}'] = date('Y-n', $value);
        $url->Rules['{%year%}'] = date('Y', $value);
        $url->Rules['{%month%}'] = date('n', $value);
        $url->Rules['{%day%}'] = 1;
        $fdate = $value;
        $ldate = strtotime(date('Y-m-t', $value)) + 60 * 60 * 24;
        $sql = $zbp->db->sql->Count($zbp->table['Post'], array(array('COUNT', '*', 'num')), array(array('=', 'log_Type', '0'), array('=', 'log_Status', '0'), array('BETWEEN', 'log_PostTime', $fdate, $ldate)));
        $n = GetValueInArrayByCurrent($zbp->db->Query($sql), 'num');
        if ($n > 0) {
            $s .= '<li><a href="' . $url->Make() . '">' . str_replace(array('%y%', '%m%'), array(date('Y', $fdate), date('n', $fdate)), $zbp->lang['msg']['year_month']) . ' (' . $n . ')</a></li>';
        }
    }
    return $s;
}
开发者ID:jdjjdkdkdm,项目名称:zblogphp,代码行数:49,代码来源:c_system_event.php

示例8: buildCreate

 /**
  * @todo
  * @override
  */
 protected function buildCreate()
 {
     //parent::buildCreate();
     if (!empty($this->index) && empty($this->data)) {
         $this->buildIndex();
         return;
     }
     $sqlAll = array();
     foreach ($this->table as $tableIndex => $table) {
         $sql = array();
         $sql[] = 'CREATE TABLE IF NOT EXISTS ' . $table;
         $sql[] = ' (';
         $engine = $this->option['engine'];
         $idname = GetValueInArrayByCurrent($this->data, 0);
         $i = 0;
         foreach ($this->data as $key => $value) {
             if ($value[1] == 'integer') {
                 if ($i == 0) {
                     $sql[] = $value[0] . ' int(11) NOT NULL AUTO_INCREMENT' . ',';
                 } else {
                     if ($value[2] == '') {
                         $sql[] = $value[0] . ' int(11) NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     } elseif ($value[2] == 'tinyint') {
                         $sql[] = $value[0] . ' tinyint(4) NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     } elseif ($value[2] == 'smallint') {
                         $sql[] = $value[0] . ' smallint(6) NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     } elseif ($value[2] == 'mediumint') {
                         $sql[] = $value[0] . ' mediumint(9) NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     } elseif ($value[2] == 'int') {
                         $sql[] = $value[0] . ' int(11) NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     } elseif ($value[2] == 'bigint') {
                         $sql[] = $value[0] . ' bigint(20) NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     }
                 }
             }
             if ($value[1] == 'boolean') {
                 $sql[] = $value[0] . ' tinyint(1) NOT NULL DEFAULT \'' . (int) $value[3] . '\'' . ',';
             }
             if ($value[1] == 'string') {
                 if ($value[2] != '') {
                     if (strpos($value[2], 'char') !== false) {
                         $sql[] = $value[0] . ' char(' . str_replace('char', '', $value[2]) . ') NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     } elseif (is_int($value[2])) {
                         $sql[] = $value[0] . ' varchar(' . $value[2] . ') NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     } elseif ($value[2] == 'tinytext') {
                         $sql[] = $value[0] . ' tinytext NOT NULL ' . ',';
                     } elseif ($value[2] == 'text') {
                         $sql[] = $value[0] . ' text NOT NULL ' . ',';
                     } elseif ($value[2] == 'mediumtext') {
                         $sql[] = $value[0] . ' mediumtext NOT NULL ' . ',';
                     } elseif ($value[2] == 'longtext') {
                         $sql[] = $value[0] . ' longtext NOT NULL ' . ',';
                     }
                 } else {
                     $sql[] = $value[0] . ' longtext NOT NULL ' . ',';
                 }
             }
             if ($value[1] == 'double' || $value[1] == 'float') {
                 $sql[] = $value[0] . " {$value['1']} NOT NULL DEFAULT 0" . ',';
             }
             if ($value[1] == 'date' || $value[1] == 'time' || $value[1] == 'datetime') {
                 $sql[] = $value[0] . " {$value['1']} NOT NULL,";
             }
             if ($value[1] == 'timestamp') {
                 $sql[] = $value[0] . " {$value['1']} NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,";
             }
             $i += 1;
         }
         $sql[] = 'PRIMARY KEY (' . $idname . ')';
         $myengtype = $this->db->dbengine;
         if ($engine != null) {
             $myengtype = $engine;
         }
         if (!$myengtype) {
             $myengtype = 'MyISAM';
         }
         $sql[] = ') ENGINE=' . $myengtype . ' DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;';
         $sqlAll[] = implode($sql, ' ');
     }
     $this->_sql = $sqlAll;
 }
开发者ID:zblogcn,项目名称:zblogphp,代码行数:85,代码来源:sqlmysql.php

示例9: LargeData_Misc_Statistic

function LargeData_Misc_Statistic()
{
    global $zbp;
    $r = null;
    CountNormalArticleNums();
    CountTopArticle(null, null);
    CountCommentNums(null, null);
    $all_comments = $zbp->cache->all_comment_nums;
    $xmlrpc_address = $zbp->host . 'zb_system/xml-rpc/';
    $current_member = $zbp->user->Name;
    $current_version = ZC_VERSION_FULL;
    $all_artiles = GetValueInArrayByCurrent($zbp->db->Query($zbp->db->sql->Select($zbp->table['Post'], 'Count(log_ID) AS num', array(array('=', 'log_Type', '0')), null, 1, null)), 'num');
    $all_pages = GetValueInArrayByCurrent($zbp->db->Query($zbp->db->sql->Select($zbp->table['Post'], 'Count(log_ID) AS num', array(array('=', 'log_Type', '1')), null, 1, null)), 'num');
    $all_categorys = GetValueInArrayByCurrent($zbp->db->Query($zbp->db->sql->Select($zbp->table['Category'], 'Count(*) AS num', null, null, 1, null)), 'num');
    $all_views = '不计算';
    $all_tags = GetValueInArrayByCurrent($zbp->db->Query($zbp->db->sql->Select($zbp->table['Tag'], 'Count(*) AS num', null, null, 1, null)), 'num');
    $all_members = GetValueInArrayByCurrent($zbp->db->Query($zbp->db->sql->Select($zbp->table['Member'], 'Count(*) AS num', null, null, 1, null)), 'num');
    $current_theme = '{$zbp->theme}';
    $current_style = '{$zbp->style}';
    $current_member = '{$zbp->user->Name}';
    $system_environment = '{$system_environment}';
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['current_member']}" . '' . "</td><td class='td30'>{$current_member}</td><td class='td20'>{$zbp->lang['msg']['current_version']}</td><td class='td30'>{$current_version}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['all_artiles']}" . '' . "</td><td>{$all_artiles}</td><td>{$zbp->lang['msg']['all_categorys']}" . '' . "</td><td>{$all_categorys}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['all_pages']}" . '' . "</td><td>{$all_pages}</td><td>{$zbp->lang['msg']['all_tags']}" . '' . "</td><td>{$all_tags}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['all_comments']}" . '' . "</td><td>{$all_comments}</td><td>{$zbp->lang['msg']['all_views']}" . '' . "</td><td>{$all_views}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['current_theme']}/{$zbp->lang['msg']['current_style']}</td><td>{$current_theme}/{$current_style}</td><td>{$zbp->lang['msg']['all_members']}" . '' . "</td><td>{$all_members}</td></tr>";
    $r .= "<tr><td class='td20'>{$zbp->lang['msg']['xmlrpc_address']}</td><td>{$xmlrpc_address}</td><td>{$zbp->lang['msg']['system_environment']}</td><td>{$system_environment}</td></tr>";
    $r .= "<script type=\"text/javascript\">\$('#statistic').next('small').remove();\$('#statistic').after('<small> 更新时间:" . date("c", $zbp->cache->reload_statistic_time) . "</small>');</script>";
    $zbp->cache->reload_statistic = $r;
    $zbp->cache->reload_statistic_time = time();
    $zbp->cache->system_environment = $system_environment;
    $zbp->cache->all_article_nums = $all_artiles;
    $zbp->cache->all_page_nums = $all_pages;
    $zbp->AddBuildModule('statistics', array($all_artiles, $all_pages, $all_categorys, $all_tags, $all_views, $all_comments));
    $zbp->BuildModule();
    $zbp->SaveCache();
    $r = str_replace('{#ZC_BLOG_HOST#}', $zbp->host, $r);
    $r = str_replace('{$zbp->user->Name}', $zbp->user->Name, $r);
    $r = str_replace('{$zbp->theme}', $zbp->theme, $r);
    $r = str_replace('{$zbp->style}', $zbp->style, $r);
    $r = str_replace('{$system_environment}', GetEnvironment(), $r);
    echo $r;
}
开发者ID:zblogcn,项目名称:zblogphp,代码行数:43,代码来源:include.php

示例10: Archives

 /**
  * 导出文章归档模块数据
  * @return string 模块内容
  */
 public static function Archives()
 {
     global $zbp;
     $template = $zbp->template;
     $tags = array();
     $urls = array();
     //array(url,name,count);
     $maxli = $zbp->modulesbyfilename['archives']->MaxLi;
     if ($maxli < 0) {
         return '';
     }
     $sql = $zbp->db->sql->Select($zbp->table['Post'], array('log_PostTime'), null, array('log_PostTime' => 'DESC'), array(1), null);
     $array = $zbp->db->Query($sql);
     if (count($array) == 0) {
         return '';
     }
     $ldate = array(date('Y', $array[0]['log_PostTime']), date('m', $array[0]['log_PostTime']));
     $sql = $zbp->db->sql->Select($zbp->table['Post'], array('log_PostTime'), null, array('log_PostTime' => 'ASC'), array(1), null);
     $array = $zbp->db->Query($sql);
     if (count($array) == 0) {
         return '';
     }
     $fdate = array(date('Y', $array[0]['log_PostTime']), date('m', $array[0]['log_PostTime']));
     $arraydate = array();
     for ($i = $fdate[0]; $i < $ldate[0] + 1; $i++) {
         for ($j = 1; $j < 13; $j++) {
             $arraydate[] = strtotime($i . '-' . $j);
         }
     }
     foreach ($arraydate as $key => $value) {
         if ($value - strtotime($ldate[0] . '-' . $ldate[1]) > 0) {
             unset($arraydate[$key]);
         }
         if ($value - strtotime($fdate[0] . '-' . $fdate[1]) < 0) {
             unset($arraydate[$key]);
         }
     }
     $arraydate = array_reverse($arraydate);
     $s = '';
     $i = 0;
     foreach ($arraydate as $key => $value) {
         if ($i >= $maxli && $maxli > 0) {
             break;
         }
         $url = new UrlRule($zbp->option['ZC_DATE_REGEX']);
         $url->Rules['{%date%}'] = date('Y-n', $value);
         $url->Rules['{%year%}'] = date('Y', $value);
         $url->Rules['{%month%}'] = date('n', $value);
         $url->Rules['{%day%}'] = 1;
         $fdate = $value;
         $ldate = strtotime(date('Y-m-t', $value)) + 60 * 60 * 24;
         $sql = $zbp->db->sql->Count($zbp->table['Post'], array(array('COUNT', '*', 'num')), array(array('=', 'log_Type', '0'), array('=', 'log_Status', '0'), array('BETWEEN', 'log_PostTime', $fdate, $ldate)));
         $n = GetValueInArrayByCurrent($zbp->db->Query($sql), 'num');
         if ($n > 0) {
             //$urls[]=array($url->Make(),str_replace(array('%y%', '%m%'), array(date('Y', $fdate), date('n', $fdate)), $zbp->lang['msg']['year_month']),$n);
             $meta = new Metas();
             $meta->Url = $url->Make();
             $meta->Name = str_replace(array('%y%', '%m%'), array(date('Y', $fdate), date('n', $fdate)), $zbp->lang['msg']['year_month']);
             $meta->Count = $n;
             $urls[] = $meta;
             $i++;
         }
     }
     $tags['urls'] = $urls;
     $template->SetTagsAll($tags);
     $ret = $template->Output('module-archives');
     return $ret;
 }
开发者ID:zblogcn,项目名称:zblogphp,代码行数:72,代码来源:modulebuilder.php

示例11: Select

 public function Select($table, $select, $where, $order, $limit, $option)
 {
     global $zbp;
     $sqls = '';
     $sqlw = '';
     $sqlo = '';
     $sqll = '';
     if (!empty($select)) {
         if (is_array($select)) {
             $selectstr = implode($select, ',');
             $sqls = "SELECT {$selectstr} FROM {$table} ";
         } else {
             $sqls = "SELECT {$select} FROM {$table} ";
         }
     }
     $sqlw = $this->ParseWhere($where);
     if (!empty($order)) {
         $sqlo .= ' ORDER BY ';
         $comma = '';
         foreach ($order as $k => $v) {
             $sqlo .= $comma . "{$k} {$v}";
             $comma = ',';
         }
     }
     if (!empty($limit)) {
         if (!isset($limit[1])) {
             $sqll .= " LIMIT {$limit['0']}";
         } else {
             if ($limit[1] > 0) {
                 $sqll .= " LIMIT {$limit['0']}, {$limit['1']}";
             }
         }
     }
     if (!empty($option)) {
         if (isset($option['pagebar'])) {
             if ($option['pagebar']->Count === null) {
                 $s2 = $this->Count($table, array(array('COUNT', '*', 'num')), $where);
                 $option['pagebar']->Count = GetValueInArrayByCurrent($zbp->db->Query($s2), 'num');
             }
             $option['pagebar']->Count = (int) $option['pagebar']->Count;
             $option['pagebar']->make();
         }
     }
     return $sqls . $sqlw . $sqlo . $sqll;
 }
开发者ID:jdjjdkdkdm,项目名称:zblogphp,代码行数:45,代码来源:dbsql.php

示例12: Select


//.........这里部分代码省略.........
                 if (trim($selectstr) == '') {
                     $selectstr = '*';
                 }
                 $sqls = "{$sqlp} {$selectstr} ";
             } else {
                 if (trim($sqls) == '') {
                     $sqls = '*';
                 }
                 $sqls = "{$sqlp} {$select} ";
             }
         } else {
             $sqls = "{$sqlp} *";
         }
     }
     $sqls .= " FROM {$table} ";
     if (isset($option['useindex'])) {
         if (is_array($option['useindex'])) {
             $sqls .= 'USE INDEX (' . implode($option['useindex'], ',') . ') ';
         } else {
             $sqls .= 'USE INDEX (' . $option['useindex'] . ') ';
         }
     }
     if (isset($option['forceindex'])) {
         if (is_array($option['forceindex'])) {
             $sqls .= 'FORCE INDEX (' . implode($option['forceindex'], ',') . ') ';
         } else {
             $sqls .= 'FORCE INDEX (' . $option['forceindex'] . ') ';
         }
     }
     if (isset($option['ignoreindex'])) {
         if (is_array($option['ignoreindex'])) {
             $sqls .= 'IGNORE INDEX (' . implode($option['ignoreindex'], ',') . ') ';
         } else {
             $sqls .= 'IGNORE INDEX (' . $option['ignoreindex'] . ') ';
         }
     }
     if (!empty($where)) {
         if (isset($option['changewhere'])) {
             $sqlw = $this->ParseWhere($where, $option['changewhere']);
         } else {
             $sqlw = $this->ParseWhere($where);
         }
     }
     if (isset($option['groupby'])) {
         $sqlg = ' GROUP BY ';
         $comma = '';
         if (!is_array($option['groupby'])) {
             $sqlg .= $option['groupby'];
         } else {
             foreach ($option['groupby'] as $k => $v) {
                 $sqlg .= $comma . "{$v}";
                 $comma = ',';
             }
         }
     }
     if (isset($option['having'])) {
         $sqlh = ' HAVING ';
         $comma = '';
         if (!is_array($option['having'])) {
             $sqlh .= $option['having'];
         } else {
             $sqlh .= $this->ParseWhere($option['having'], '');
         }
     }
     if (!empty($order)) {
         $sqlo .= ' ORDER BY ';
         $comma = '';
         if (!is_array($order)) {
             $sqlo .= $order;
         } else {
             foreach ($order as $k => $v) {
                 $sqlo .= $comma . "{$k} {$v}";
                 $comma = ',';
             }
         }
     }
     if (!empty($limit)) {
         if (!is_array($limit)) {
             $sqll .= " LIMIT {$limit}";
         } elseif (!isset($limit[1])) {
             $sqll .= " LIMIT {$limit['0']}";
         } else {
             if ($limit[1] > 0) {
                 //$sqll .= " LIMIT $limit[0], $limit[1]";
                 $sqll .= " LIMIT {$limit['1']} OFFSET {$limit['0']}";
             }
         }
     }
     if (!empty($option)) {
         if (isset($option['pagebar'])) {
             if ($option['pagebar']->Count === null) {
                 $s2 = $this->Count($table, array(array('COUNT', '*', 'num')), $where);
                 $option['pagebar']->Count = GetValueInArrayByCurrent($this->db->Query($s2), 'num');
             }
             $option['pagebar']->Count = (int) $option['pagebar']->Count;
             $option['pagebar']->make();
         }
     }
     return $sqls . $sqlw . $sqlg . $sqlh . $sqlo . $sqll;
 }
开发者ID:jdjjdkdkdm,项目名称:zblogphp,代码行数:101,代码来源:dbsql.php

示例13: Select

 /**
  * 构造查询语句
  * @param string $table
  * @param string $select
  * @param string $where
  * @param string $order
  * @param string $limit
  * @param array|null $option
  * @return string 返回构造的语句
  */
 public function Select($table, $select = null, $where = null, $order = null, $limit = null, $option = null)
 {
     if (!is_array($option)) {
         $option = array();
     }
     $sql = $this->get()->select($table)->option($option)->where($where)->orderBy($order)->limit($limit);
     if (isset($option['select2count'])) {
         foreach ($select as $key => $value) {
             if (count($value) > 2) {
                 $sql->count(array_slice($value, 1));
             } else {
                 $sql->count($value);
             }
         }
     } else {
         if (!is_array($select)) {
             $select = array($select);
         }
         call_user_func_array(array($sql, 'column'), $select);
     }
     if (!empty($option)) {
         if (isset($option['pagebar'])) {
             if ($option['pagebar']->Count === null) {
                 $s2 = $this->Count($table, array(array('*', 'num')), $where);
                 $option['pagebar']->Count = GetValueInArrayByCurrent($this->db->Query($s2), 'num');
             }
             $option['pagebar']->Count = (int) $option['pagebar']->Count;
             $option['pagebar']->make();
         }
     }
     $sql = $sql->sql;
     return $sql;
 }
开发者ID:zblogcn,项目名称:zblogphp,代码行数:43,代码来源:dbsql.php

示例14: CountMember

/**
 * 统计用户下的文章数、页面数、评论数、附件数等
 * @param $member
 * @param array $plus 设置是否需要完全全表扫描
 */
function CountMember(&$member, $plus = array(null, null, null, null))
{
    global $zbp;
    if (!$member instanceof Member) {
        return;
    }
    $id = $member->ID;
    if ($plus[0] === null) {
        $s = $zbp->db->sql->Count($zbp->table['Post'], array(array('COUNT', '*', 'num')), array(array('=', 'log_AuthorID', $id), array('=', 'log_Type', 0)));
        $member_Articles = GetValueInArrayByCurrent($zbp->db->Query($s), 'num');
        $member->Articles = $member_Articles;
    } else {
        $member->Articles += $plus[0];
    }
    if ($plus[1] === null) {
        $s = $zbp->db->sql->Count($zbp->table['Post'], array(array('COUNT', '*', 'num')), array(array('=', 'log_AuthorID', $id), array('=', 'log_Type', 1)));
        $member_Pages = GetValueInArrayByCurrent($zbp->db->Query($s), 'num');
        $member->Pages = $member_Pages;
    } else {
        $member->Pages += $plus[1];
    }
    if ($plus[2] === null) {
        $s = $zbp->db->sql->Count($zbp->table['Comment'], array(array('COUNT', '*', 'num')), array(array('=', 'comm_AuthorID', $id)));
        $member_Comments = GetValueInArrayByCurrent($zbp->db->Query($s), 'num');
        $member->Comments = $member_Comments;
    } else {
        $member->Comments += $plus[2];
    }
    if ($plus[3] === null) {
        $s = $zbp->db->sql->Count($zbp->table['Upload'], array(array('COUNT', '*', 'num')), array(array('=', 'ul_AuthorID', $id)));
        $member_Uploads = GetValueInArrayByCurrent($zbp->db->Query($s), 'num');
        $member->Uploads = $member_Uploads;
    } else {
        $member->Uploads += $plus[3];
    }
}
开发者ID:zblogcn,项目名称:zblogphp,代码行数:41,代码来源:c_system_event.php

示例15: buildCreate

 /**
  * @todo
  * @override
  */
 protected function buildCreate()
 {
     $sqlAll = array();
     foreach ($this->table as $tableIndex => $table) {
         $sql = array();
         $sql[] = 'CREATE SEQUENCE ' . $table . '_seq;';
         $sql[] = 'CREATE TABLE ' . $table . ' (';
         $idname = GetValueInArrayByCurrent($this->data, 0);
         $i = 0;
         foreach ($this->data as $key => $value) {
             if ($value[1] == 'integer') {
                 if ($i == 0) {
                     $sql[] = $value[0] . ' INT NOT NULL DEFAULT nextval(\'' . $table . '_seq\')' . ',';
                 } else {
                     if ($value[2] == '') {
                         $sql[] = $value[0] . ' integer NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     } elseif ($value[2] == 'tinyint') {
                         $sql[] = $value[0] . ' integer NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     } elseif ($value[2] == 'smallint') {
                         $sql[] = $value[0] . ' smallint NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     } elseif ($value[2] == 'mediumint') {
                         $sql[] = $value[0] . ' integer NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     } elseif ($value[2] == 'int') {
                         $sql[] = $value[0] . ' integer NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     } elseif ($value[2] == 'bigint') {
                         $sql[] = $value[0] . ' bigint NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     }
                 }
             }
             if ($value[1] == 'boolean') {
                 $sql[] = $value[0] . ' char(1) NOT NULL DEFAULT \'' . (int) $value[3] . '\'' . ',';
             }
             if ($value[1] == 'string') {
                 if ($value[2] != '') {
                     if (strpos($value[2], 'char') !== false) {
                         $sql[] = $value[0] . ' char(' . str_replace('char', '', $value[2]) . ') NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     } elseif (is_int($value[2])) {
                         $sql[] = $value[0] . ' varchar(' . $value[2] . ') NOT NULL DEFAULT \'' . $value[3] . '\'' . ',';
                     } else {
                         $sql[] = $value[0] . ' text NOT NULL DEFAULT \'\',';
                     }
                 } else {
                     $sql[] = $value[0] . ' text NOT NULL DEFAULT \'\',';
                 }
             }
             if ($value[1] == 'double') {
                 $sql[] = $value[0] . " double precision NOT NULL DEFAULT 0" . ',';
             }
             if ($value[1] == 'float') {
                 $sql[] = $value[0] . " real NOT NULL DEFAULT 0" . ',';
             }
             if ($value[1] == 'date' || $value[1] == 'time') {
                 $sql[] = $value[0] . " {$value['1']} NOT NULL,";
             }
             if ($value[1] == 'datetime') {
                 $sql[] = $value[0] . " time NOT NULL,";
             }
             if ($value[1] == 'timestamp') {
                 $sql[] = $value[0] . " {$value['1']} NOT NULL DEFAULT CURRENT_TIMESTAMP,";
             }
             $i += 1;
         }
         $sql[] = 'PRIMARY KEY (' . $idname . ')';
         $sql[] = ');';
         $sql[] = 'CREATE INDEX ' . $table . '_ix_id on ' . $table . '(' . $idname . ');';
         $sqlAll[] = implode($sql, ' ');
     }
     $this->_sql = $sqlAll;
 }
开发者ID:zblogcn,项目名称:zblogphp,代码行数:73,代码来源:sqlpgsql.php


注:本文中的GetValueInArrayByCurrent函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。