Example #1
0
 public function tminiget($pos = '')
 {
     global $_M;
     $pos = $pos ? $pos : '0';
     $posw = $pos == 'all' ? '' : " and pos='{$pos}' ";
     $query = "SELECT * FROM {$_M['table']['templates']} WHERE no='{$this->no}' {$posw} AND lang='{$this->lang}' order by no_order,id ";
     $this->inc = DB::get_all($query);
     return $this->inc;
 }
Example #2
0
 function dolidb()
 {
     global $_M;
     $file = $_M['form']['met_skin_user'] ? $_M['form']['met_skin_user'] : $_M['config']['met_skin_user'];
     $this->checktem($file);
     $tmpincfile = PATH_WEB . "templates/{$_M[form][met_skin_user]}/metinfo.inc.php";
     if (file_exists($tmpincfile)) {
         require $tmpincfile;
     }
     //列表页设置
     $m_now_time = time();
     $met_timetype[0] = array(1 => 'Y-m-d H:i:s', 2 => date('Y-m-d H:i:s', $m_now_time));
     $met_timetype[1] = array(1 => 'Y-m-d', 2 => date('Y-m-d', $m_now_time));
     $met_timetype[2] = array(1 => 'Y/m/d', 2 => date('Y/m/d', $m_now_time));
     $met_timetype[3] = array(1 => 'Ymd', 2 => date('Ymd', $m_now_time));
     $met_timetype[4] = array(1 => 'Y-m', 2 => date('Y-m', $m_now_time));
     $met_timetype[5] = array(1 => 'Y/m', 2 => date('Y/m', $m_now_time));
     $met_timetype[6] = array(1 => 'Ym', 2 => date('Ym', $m_now_time));
     $met_timetype[6] = array(1 => 'm-d', 2 => date('m-d', $m_now_time));
     $met_timetype[7] = array(1 => 'm/d', 2 => date('m/d', $m_now_time));
     $met_timetype[8] = array(1 => 'md', 2 => date('md', $m_now_time));
     $selecthtml = '';
     for ($i = 0; $i < 9; $i++) {
         $selecthtml .= "<option value=\"{$met_timetype[$i][1]}\">{$met_timetype[$i][2]}</option>";
     }
     switch ($_M['form']['listdb']) {
         case 2:
             //全局
             $inilist = $this->iniclass->tminiment(0);
             $temname = $_M[form][mobile] ? 'mobile_overall' : 'oldoverall';
             break;
         case 3:
             //首页
             $wap_ok = $_M[form][mobile] ? 1 : 0;
             if ($_M[form][mobile]) {
                 $set = DB::get_one("select * from {$_M[table][config]} where name='flash_10001' and lang='{$_M[lang]}'");
                 $_M['config']['flash_10001'] = $set['mobile_value'];
             }
             $bannerlist = DB::get_all("select * from {$_M[table][flash]} where wap_ok='{$wap_ok}' and (module like '%,10001,%' or module = 'metinfo') and lang='{$_M[lang]}' and img_path!='' order by no_order ");
             $inbaset = explode('|', $_M['config']['flash_10001']);
             $inilist = $this->iniclass->tminiment(1);
             $temname = $_M[form][mobile] ? 'mobile_home' : 'oldhome';
             break;
         case 4:
             //列表页
             $inilist = $this->iniclass->tminiment(2);
             $temname = $_M[form][mobile] ? 'mobile_page' : 'oldpage';
             break;
         case 5:
             //详情页
             $inilist = $this->iniclass->tminiment(3);
             $temname = $_M[form][mobile] ? 'mobile_details' : 'olddetails';
             break;
     }
     require $this->template('tem/' . $temname);
 }
Example #3
0
/**
 * 获取当前会员信息;
 * @return array  $user 返回记录当前会员信息的数组
 */
function member_information()
{
    global $_M;
    $metinfo_member_name = get_met_cookie('metinfo_member_name');
    $user = load::sys_class('user', 'new')->get_user_by_username($metinfo_member_name);
    $user['usertype'] = $user['groupid'];
    $user['admin_id'] = $user['username'];
    $user['admin_pass'] = $user['password'];
    $query = "SELECT id,name FROM {$_M['table']['column']} WHERE access <= '{$user['groupid']}' AND lang = '{$_M['lang']}'";
    $column = DB::get_all($query);
    $user['column'] = $column;
    return $user;
}
Example #4
0
 public function json_user_list()
 {
     global $_M;
     $groupid = $_M['form']['groupid'];
     $keyword = $_M['form']['keyword'];
     $search = $groupid ? "and groupid = '{$groupid}'" : '';
     $search .= $keyword ? "and (username like '%{$keyword}%' || email like '%{$keyword}%' || tel like '%{$keyword}%')" : '';
     $table = load::sys_class('tabledata', 'new');
     $order = "login_time DESC,register_time DESC";
     $where = "lang='{$_M['lang']}' {$search}";
     $userlist = $table->getdata($_M['table']['user'], '*', $where, $order);
     $user_group = array();
     $group = DB::get_all("SELECT * FROM {$_M[table][user_group]} WHERE lang = '{$_M[form][lang]}'");
     foreach ($group as $key => $val) {
         $user_group[$val['id']] = $val['name'];
     }
     foreach ($userlist as $key => $val) {
         switch ($val['source']) {
             case 'weixin':
                 $val['source'] = '微信登录';
                 break;
             case 'weibo':
                 $val['source'] = '微博登录';
                 break;
             case 'qq':
                 $val['source'] = 'QQ登录';
                 break;
             default:
                 $val['source'] = '注册';
                 break;
         }
         if (!$val['login_time']) {
             $val['login_time'] = $val['register_time'];
         }
         $list = array();
         $list[] = "<input name=\"id\" type=\"checkbox\" value=\"{$val[id]}\">";
         $list[] = $val['username'];
         $list[] = $user_group[$val['groupid']];
         $list[] = timeFormat($val['register_time']);
         $list[] = timeFormat($val['login_time']);
         $list[] = $val['login_count'];
         $list[] = $val['valid'] ? '已激活' : '未激活';
         $list[] = $val['source'];
         $list[] = "<a href=\"{$_M[url][own_form]}a=doeditor&id={$val['id']}\" class=\"edit\">编辑</a><span class=\"line\">|</span><a href=\"{$_M[url][own_form]}a=dodellist&allid={$val['id']}\" class=\"delet\" data-confirm='{$_M[word][js7]}'>删除</a>";
         $rarray[] = $list;
     }
     $table->rdata($rarray);
 }
Example #5
0
 /**
  * 获取表查询数据
  * @param  string $table 表名
  * @param  string $field 表字段
  * @param  string $where where条件
  * @param  string $order order by条件	 
  * @return array  查询数据	
  */
 public function getdata($table, $field = '*', $where = '', $order = '')
 {
     global $_M;
     /*获取表格ajax传递的参数*/
     $length = $_M['form']['length'];
     //每页显示数量
     $start = $_M['form']['start'];
     //读取数据的起点
     $draw = $_M['form']['draw'];
     //累计执行次数,无作用但必须回传
     if ($_M['form']['tablepage'] && $start == 0 & $draw == 1) {
         $cook = explode("|", $_M['form']['tablepage']);
         $u = "{$_M['form']['n']},{$_M['form']['c']},{$_M['form']['a']}";
         if ($cook[1] == $u) {
             $start = $cook[0] * $_M['form']['length'];
         }
     }
     /*查询表*/
     if ($where) {
         $conds .= " WHERE {$where} ";
     }
     if ($order) {
         $conds .= " ORDER BY {$order} ";
     }
     //整理查询条件
     $query = "SELECT {$field} FROM {$table} {$conds} LIMIT {$start},{$length}";
     //mysql语句
     $array = DB::get_all($query);
     //执行查询,获得数组
     $error = DB::error();
     if ($error) {
         $this->error = $query . "<br />" . $error;
     } else {
         $this->error = '';
     }
     $total = DB::counter($table, $conds, '*');
     //获取总数量,计算总页数
     /*回传数组处理*/
     $this->rarray = array();
     $this->rarray['draw'] = $draw;
     //回传执行次数
     $this->rarray['recordsTotal'] = $total;
     //回传总数量
     $this->rarray['recordsFiltered'] = $total;
     //回传筛选过的总数量,暂无作用,但必须回传
     return $array;
 }
Example #6
0
 /**
  * 获取前台模板的语言参数配置,存放在$_M['word']中,系统语言参数数组。
  */
 protected function load_template_lang()
 {
     global $_M;
     //模板文件
     $query = "SELECT * FROM {$_M['table']['templates']} WHERE no='{$_M[config][met_skin_user]}' AND lang='{$_M['lang']}' order by no_order ";
     $inc = DB::get_all($query);
     $tmpincfile = PATH_WEB . "templates/{$_M[config][met_skin_user]}/metinfo.inc.php";
     require $tmpincfile;
     $_M['config']['metinfover'] = $metinfover;
     foreach ($inc as $key => $val) {
         $name = $val['name'];
         if ($val[type] == 7 && strstr($val['value'], "../upload/") && $index == 'index' && $metinfover == 'v1') {
             $val['value'] = explode("../", $val['value']);
             $val['value'] = $val['value'][1];
         }
         $_M['word'][$name] = trim($val['value']);
     }
 }
Example #7
0
 /**
  * 初始化
  */
 public function __construct()
 {
     global $_M;
     parent::__construct();
     $this->check();
     $this->userclass = load::sys_class('user', 'new');
     $query = "SELECT * FROM {$_M['table']['column']} WHERE module='10' AND lang='{$_M['lang']}'";
     $member = DB::get_one($query);
     if ($_M['config']['met_title_type'] == 0) {
         $_M['tem_data']['title'] = $member['name'];
     } else {
         if ($_M['config']['met_title_type'] == 1) {
             $_M['tem_data']['title'] = $member['name'] . '-' . $_M['config']['met_keywords'];
         } else {
             if ($_M['config']['met_title_type'] == 2) {
                 $_M['tem_data']['title'] = $member['name'] . '-' . $_M['config']['met_webname'];
             } else {
                 if ($_M['config']['met_title_type'] == 3) {
                     $_M['tem_data']['title'] = $member['name'] . '-' . $_M['config']['met_keywords'] . '-' . $_M['config']['met_webname'];
                 }
             }
         }
     }
     $query = "SELECT * FROM {$_M['table']['ifmember_left']}";
     $navigation = DB::get_all($query);
     foreach ($navigation as $key => $val) {
         if ($val[columnid]) {
             //$column = $class_list[$val[columnid]];
             $query = "SELECT * FROM {$_M['table']['column']} WHERE id = '{$val[columnid]}'";
             $column = DB::get_one($query);
             $val['foldername'] = $val['foldername'] ? $val['foldername'] : $column['foldername'];
             $val['filename'] = $val['filename'] ? $val['filename'] : 'index.php';
             $list['url'] = "../{$val['foldername']}/{$val['filename']}";
             $list['title'] = $column['name'];
         } else {
             $list['url'] = "../{$val['foldername']}/{$val['filename']}";
             $list['title'] = $val['title'];
         }
         $_M['html']['app_sidebar'][] = $list;
     }
 }
Example #8
0
                //$_SESSION['username'] = "sys";
                //$_SESSION['password'] = md5("sys");
                //$_SESSION['usrDuty'] = 1;
                //$_SESSION['usrcname'] = "管理员";
                //$_SESSION['personshihao'] = "";
                echo "管理员";
            } else {
                echo "fail";
            }
        } else {
            echo "fail";
        }
    }
}
if ($type == "getInterviewList") {
    $result = $dbop->get_all("select interviewid, personshihao, interviewdate, shequname, xiaoquname, loufanghao, interviewrecord.loufangid from interviewrecord, shequ, xiaoqu, loufang where interviewrecord.interviewstatus='待走访' and interviewrecord.loufangid=loufang.loufangid and loufang.xiaoquid=xiaoqu.xiaoquid and shequ.shequid=xiaoqu.shequid order by interviewdate");
    $count = count($result);
    echo "<div class='panel-heading'><span class='badge' style='float:right'>{$count}</span>待走访一览</div>\n          <ul class='list-group'>";
    if ($count > 0) {
        $curDay = date("Y-m-d");
        foreach ($result as $i => $value) {
            // 获取地址
            $interviewid = $result[$i]['interviewid'];
            $shequname = $result[$i]['shequname'];
            $xiaoquname = $result[$i]['xiaoquname'];
            $loufanghao = $result[$i]['loufanghao'];
            $personshihao = $result[$i]['personshihao'];
            $addr = $shequname . " > " . $xiaoquname . " > " . $loufanghao . " > " . $personshihao;
            // 获取访问日期及访问日期与当前日期之差
            $interviewdate = $result[$i]['interviewdate'];
            $dis = ceil((strtotime($interviewdate) - strtotime($curDay)) / 86400);
 public function export($fileName, $fileFormat, $table)
 {
     $content = "";
     $content = "catName\n";
     $db = new DB();
     $result = $db->get_all($table);
     while ($row = mysql_fetch_array($result)) {
         $content .= $row['catName'] . "\n";
     }
     if ($fileFormat == 'csv') {
         header("Content-Type: application/csv");
         header("content-Disposition: attachment; filename=" . $fileName);
     }
     return $content;
 }
Example #10
0
 public function dopos()
 {
     global $_M;
     $metinfo['citylist'][0]['p']['name'] = '全局';
     $metinfo['citylist'][0]['p']['value'] = 0;
     $metinfo['citylist'][0]['c'][0]['n']['name'] = '首项';
     $metinfo['citylist'][0]['c'][0]['n']['value'] = 0;
     $metinfo['citylist'][1]['p']['name'] = '首页';
     $metinfo['citylist'][1]['p']['value'] = 1;
     $query = "SELECT * FROM {$_M['table']['templates']} WHERE no='{$_M['form']['no']}' AND lang='{$_M['form']['lang']}' AND pos = '0' ORDER BY no_order DESC,id DESC ";
     $max_order = DB::get_one($query);
     $max_order['id'] = $max_order['id'] ? $max_order['id'] : 0;
     $metinfo['citylist'][1]['c'][0]['n']['name'] = '首项';
     $metinfo['citylist'][1]['c'][0]['n']['value'] = $max_order['id'];
     $metinfo['citylist'][2]['p']['name'] = '列表页';
     $metinfo['citylist'][2]['p']['value'] = 2;
     $query = "SELECT * FROM {$_M['table']['templates']} WHERE no='{$_M['form']['no']}' AND lang='{$_M['form']['lang']}' AND (pos='0' OR pos='1') ORDER BY no_order DESC,id DESC ";
     $max_order = DB::get_one($query);
     $max_order['id'] = $max_order['id'] ? $max_order['id'] : 0;
     $metinfo['citylist'][2]['c'][0]['n']['name'] = '首项';
     $metinfo['citylist'][2]['c'][0]['n']['value'] = $max_order['id'];
     $metinfo['citylist'][3]['p']['name'] = '详细页';
     $metinfo['citylist'][3]['p']['value'] = 3;
     $query = "SELECT * FROM {$_M['table']['templates']} WHERE no='{$_M['form']['no']}' AND lang='{$_M['form']['lang']}' AND (pos='0' OR pos='1' OR pos='2') ORDER BY no_order DESC,id DESC ";
     $max_order = DB::get_one($query);
     $max_order['id'] = $max_order['id'] ? $max_order['id'] : 0;
     $metinfo['citylist'][3]['c'][0]['n']['name'] = '首项';
     $metinfo['citylist'][3]['c'][0]['n']['value'] = $max_order['id'];
     $query = "SELECT * FROM {$_M['table']['templates']} where no='{$_M['form']['no']}' AND lang='{$_M['form']['lang']}' ORDER BY no_order,id";
     $tems = DB::get_all($query);
     foreach ($tems as $key => $val) {
         $val['pos'] = $val['pos'];
         $tem = array();
         $tem['n']['name'] = $val['valueinfo'];
         $tem['n']['value'] = $val['id'];
         $metinfo['citylist'][$val['pos']]['c'][] = $tem;
     }
     echo jsonencode($metinfo);
 }
Example #11
0
 /**
  * return all possible results for a DB query for specified tables and fields
  */
 protected function all_field_query($tables, $columns, $where, $fields)
 {
     $db_query = DB::get_all('SELECT ' . $columns . ' FROM ' . $tables . ' WHERE ' . $where, $fields);
     return $db_query;
 }
Example #12
0
 function dousercsv()
 {
     global $_M;
     $groupid = $_M['form']['groupid'];
     $keyword = $_M['form']['keyword'];
     $search = $groupid ? "and groupid = '{$groupid}'" : '';
     $search .= $keyword ? "and (username like '%{$keyword}%' || email like '%{$keyword}%' || tel like '%{$keyword}%')" : '';
     /*查询表*/
     $query = "SELECT * FROM {$_M['table']['user']} WHERE lang='{$_M['lang']}' {$search} ORDER BY login_time DESC,register_time DESC";
     //mysql语句
     $array = DB::get_all($query);
     $paralist = $this->paraclass->get_para_list(10);
     foreach ($array as $key => $val) {
         switch ($val['source']) {
             case 'weixin':
                 $val['source'] = '微信登录';
                 break;
             case 'weibo':
                 $val['source'] = '微博登录';
                 break;
             case 'qq':
                 $val['source'] = 'QQ登录';
                 break;
             default:
                 $val['source'] = '注册';
                 break;
         }
         if (!$val['login_time']) {
             $val['login_time'] = $val['register_time'];
         }
         $list = array();
         $list[] = $val['username'];
         $list[] = $user_group[$val['groupid']];
         $list[] = date('Y-m-d H:i:s', $val['register_time']);
         $list[] = date('Y-m-d H:i:s', $val['login_time']);
         $list[] = $val['login_count'];
         $list[] = $val['valid'] ? '已激活' : '未激活';
         $list[] = $val['source'];
         $list[] = $val['email'];
         $list[] = $val['tel'];
         if ($paralist) {
             $para = $this->paraclass->get_para($val['id'], 10);
             foreach ($paralist as $vals) {
                 $list[] = $para['info_' . $vals['id']];
             }
         }
         $rarray[] = $list;
     }
     $filename = "USER_" . date('Y-m-d', time()) . "_ACCLOG";
     $head = array('用户名', '会员组', '注册时间', '最后活跃', '登录次数', '是否激活', '来源', '绑定邮箱', '绑定手机');
     if ($paralist) {
         foreach ($paralist as $val) {
             $head[] = $val['name'];
         }
     }
     $csv = load::sys_class('csv', 'new');
     $csv->get_csv($filename, $rarray, $head);
 }
Example #13
0
 /**
  * 加载插件
  * @param  string $plugin 需要加载的插件系统名
  */
 public static function plugin($plugin, $return = 0)
 {
     global $_M;
     if (!$_M['plugin']) {
         $query = "SELECT * FROM {$_M['table']['app_plugin']}  WHERE effect='1' ORDER BY no_order DESC";
         $plugins = DB::get_all($query);
         foreach ($plugins as $key => $val) {
             $_M['plugin'][$val['m_action']][] = $val['m_name'];
         }
     }
     foreach ($_M['plugin'][$plugin] as $key => $val) {
         $own = $_M['url']['own'];
         $_M['url']['own'] = $_M['url']['app'] . $val . '/';
         if (file_exists(PATH_APP . 'app/' . $val . '/plugin/' . 'plugin_' . $val . '.class.php')) {
             require_once PATH_APP . 'app/' . $val . '/plugin/' . 'plugin_' . $val . '.class.php';
             //self::_load_class(PATH_APP.'app/'.$val.'/plugin/', 'plugin_'.$val, $plugin);
             $name = 'plugin_' . $val;
             if (class_exists($name)) {
                 $newclass = new $name();
                 if (method_exists($newclass, $plugin)) {
                     if ($return == 1) {
                         return call_user_func(array($newclass, $plugin));
                     } else {
                         call_user_func(array($newclass, $plugin));
                     }
                 }
             }
         }
         $_M['url']['own'] = $own;
     }
 }
<?php

include 'functions.php';
$db = new DB();
$table_name = 'triggers_personality';
$result = $db->get_all($table_name);
while ($row = mysql_fetch_array($result)) {
    ?>
	
	<h1><?php 
    echo $row['name'];
    ?>
</h1>
	<h3><?php 
    echo $row['position'];
    ?>
</h3>
	<h5><?php 
    echo $row['desc'];
    ?>
</h5>

	<hr>
	
<?php 
}
Example #15
0
 public function get_para()
 {
     global $_M;
     $query = "SELECT * FROM {$_M['table']['shopv2_para']} WHERE value!=''";
     $para = DB::get_all($query);
     foreach ($para as $val) {
         $valuelist = explode(',', $val['valuelist']);
         $paras[$val['value']] = $valuelist;
     }
     return $paras;
 }
Example #16
0
/**
 * 获取模块编号
 * @param  int    $module 模块编号
 * @return string 返回记录后台导航栏目信息的数组
 */
function modname($module)
{
    global $_M;
    $metmodname = $module;
    switch ($module) {
        case 1:
            $metmodname = $_M['word']['mod1'];
            break;
        case 2:
            $metmodname = $_M['word']['mod2'];
            break;
        case 3:
            $metmodname = $_M['word']['mod3'];
            break;
        case 4:
            $metmodname = $_M['word']['mod4'];
            break;
        case 5:
            $metmodname = $_M['word']['mod5'];
            break;
        case 6:
            $metmodname = $_M['word']['mod6'];
            break;
        case 7:
            $metmodname = $_M['word']['mod7'];
            break;
        case 8:
            $metmodname = $_M['word']['mod8'];
            break;
        case 9:
            $metmodname = $_M['word']['mod9'];
            break;
        case 10:
            $metmodname = $_M['word']['mod10'];
            break;
        case 11:
            $metmodname = $_M['word']['mod11'];
            break;
        case 12:
            $metmodname = $_M['word']['mod12'];
            break;
        case 999:
            $metmodname = $_M['word']['modout'];
            break;
        case 100:
            $metmodname = $_M['word']['mod100'];
            break;
        case 101:
            $metmodname = $_M['word']['mod101'];
            break;
        default:
            $query = "SELECT * FROM {$_M['table']['applist']}";
            $app = DB::get_all($query);
            foreach ($app as $key => $val) {
                if ($module == $val['no']) {
                    $metmodname = get_word($val['appname']);
                }
            }
            break;
    }
    return $metmodname;
}
Example #17
0
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
	<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
	<link rel="stylesheet" type="text/css" href="css/list.css" media="all" />
	<script type="text/javascript" src="../js/jquery.min.js"></script>
	<title>人人网微博应用</title>
	<style type="text/css">
	body {
		behavior:url("../css/csshover3.htc");
	}
	</style>
</head>
<body>
	<div id = 'content'>
		<p id="title">问卷调查数据整理</p>
		<?php 
$th = 3;
$sql = "select `{$th}` , count(*) as choise from answers group by `{$th}` order by `{$th}` LIMIT 0, 30 ";
$result = $db->get_all($sql);
for ($i = 1; $i <= 5; $i++) {
    $choise[$i] = 0;
}
for ($i = 1; $i <= count($result); $i++) {
    $choise[$result[$i - 1][$th]] = $result[$i - 1]['choise'];
}
?>
		<div class="eachitem">
			<div class="eachquiz">是否希望在毕业时和同学朋友拍摄视频留念?</div>
			<div class="eachanwser"><span class="inspector">•</span>是<span id="percentage"><?php 
echo $choise[1] . '/' . $num;
Example #18
0
<?php

require_once "db.php";
//username
if (isset($_GET['username']) && $_GET['username']) {
    $username = $_GET['username'];
} else {
    $username = '';
}
if ($username) {
    $db = new DB();
    $allroomlist = "";
    $sqlRowAll = $db->get_all("select * from ofMucRoom where roomID in(select roomID from ofMucAffiliation where jid='" . $username . "@211.149.195.30')");
    foreach ($sqlRowAll as $k => $v) {
        $allroomlist = $allroomlist . $v['roomID'] . "|" . $v['name'] . "|" . $v['description'] . "|1" . "\$";
    }
    unset($sqlRowAll);
    $sqlRowAll = $db->get_all("select * from ofMucRoom where roomID in(select roomID from ofMucMember where jid='" . $username . "@211.149.195.30')");
    foreach ($sqlRowAll as $k => $v) {
        $allroomlist = $allroomlist . $v['roomID'] . "|" . $v['name'] . "|" . $v['description'] . "|0" . "\$";
    }
    $allroomlist = rtrim($allroomlist, '$');
    echo $allroomlist;
}
Example #19
0
 public function dosetsave()
 {
     global $_M;
     $list = explode(",", $_M[form][allid]);
     $type = $_M[form][submit_type];
     $i = 0;
     foreach ($list as $id) {
         if ($id) {
             $i++;
             if ($type == 'save' || !$type) {
                 $name = $_M['form']['name-' . $id];
                 $defaultvalue = $_M['form']['defaultvalue-' . $id];
                 $valueinfo = $_M['form']['valueinfo-' . $id];
                 $type1 = $_M['form']['type-' . $id];
                 $tips = $_M['form']['tips-' . $id];
                 $selectd = $_M['form']['selectd-' . $id];
                 $style = $_M['form']['style-' . $id];
                 $no = $_M['form']['no'];
                 $pos = $_M['form']['pos-' . $id];
                 $no_order = $i;
                 if ($pos != $_M['form']['pos']) {
                     $counter = DB::counter($_M['table']['templates'], " WHERE no='{$_M['form']['no']}' and pos='{$pos}'  and lang='{$_M['form']['lang']}'", '*');
                     $no_order = $no_order + $counter;
                 }
                 $query = "\n\t\t\t\t\t\tno           = '{$no}',\n\t\t\t\t\t\tpos          = '{$pos}',\n\t\t\t\t\t\tno_order     = '{$no_order}',\n\t\t\t\t\t\tname         = '{$name}',\n\t\t\t\t\t\tdefaultvalue = '{$defaultvalue}',\n\t\t\t\t\t\tvalueinfo    = '{$valueinfo}',\n\t\t\t\t\t\ttype\t     = '{$type1}',\n\t\t\t\t\t\ttips\t     = '{$tips}',\n\t\t\t\t\t\tselectd\t     = '{$selectd}',\n\t\t\t\t\t\tstyle\t     = '{$style}',\n\t\t\t\t\t\tlang         = '{$_M['form']['lang']}'\n\t\t\t\t\t";
                 if (is_number($id)) {
                     //修改
                     $query = "UPDATE {$_M['table']['templates']} SET {$query} WHERE id = '{$id}' ";
                 } else {
                     //新增
                     $query = "INSERT INTO {$_M['table']['templates']} SET value = '{$defaultvalue}', {$query} ";
                 }
             } elseif ($type == 'del') {
                 //删除
                 if (is_number($id)) {
                     $query = "DELETE FROM {$_M['table']['templates']} WHERE id='{$id}' and pos = '{$_M['form']['pos']}' and lang='{$_M['form']['lang']}' ";
                 }
             }
             DB::query($query);
         }
     }
     /*同步到其它语言*/
     $query = "SELECT * FROM {$_M['table']['templates']} where no='{$_M['form']['no']}' AND lang='{$_M['form']['lang']}' ORDER BY no_order,id";
     $tems = DB::get_all($query);
     foreach ($_M['langlist']['web'] as $key => $val) {
         if ($key != $_M['form']['lang']) {
             $query = "DELETE FROM {$_M['table']['templates']} WHERE no='{$_M['form']['no']}' AND lang='{$key}'";
             DB::query($query);
             foreach ($tems as $keytems => $valtems) {
                 $query = "INSERT INTO {$_M['table']['templates']} SET no='{$valtems['no']}',pos ='{$valtems['pos']}',no_order='{$valtems['no_order']}',type='{$valtems['type']}',style='{$valtems['style']}',selectd='{$valtems['selectd']}',name ='{$valtems['name']}',value='{$valtems['value']}',defaultvalue='{$valtems['defaultvalue']}',valueinfo ='{$valtems['valueinfo']}',tips='{$valtems['tips']}',lang='{$key}'";
                 DB::query($query);
             }
         }
     }
     /*生成安装文件*/
     load::sys_func('file');
     $file = "templates/{$_M['form']['no']}/install/install.class.php";
     makefile($file);
     $query = "SELECT * FROM {$_M['table']['skin_table']} where skin_file='{$_M['form']['no']}'";
     $tem = DB::get_one($query);
     $query = "SELECT * FROM {$_M['table']['templates']} where no='{$_M['form']['no']}' AND lang='{$_M['form']['lang']}' ORDER BY no_order,id";
     $tems = DB::get_all($query);
     foreach ($tems as $keytems => $valtems) {
         $sql[] = "pos ='{$valtems['pos']}',no_order='{$valtems['no_order']}',type='{$valtems['type']}',style='{$valtems['style']}',selectd='{$valtems['selectd']}',name ='{$valtems['name']}',value='{$valtems['defaultvalue']}',defaultvalue='{$valtems['defaultvalue']}',valueinfo ='{$valtems['valueinfo']}',tips='{$valtems['tips']}'";
     }
     $sql_info = var_export($sql, true);
     $info .= "\n\$sql = {$sql_info};\n\$no='{$_M['form']['no']}';\n\$devices='{$tem['devices']}';";
     $str = file_get_contents(PATH_OWN_FILE . 'file/install.class.php');
     $str = str_replace('/*<!--sql-->*/', $info, $str);
     file_put_contents(PATH_WEB . $file, $str);
     turnover("{$_M[url][own_form]}a=doset&no={$_M['form']['no']}&pos={$_M['form']['pos']}", '操作成功');
 }
                                        <tr>
                                            <th>Group_ID</th>
                                            <th>Group Name</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    
                             
	
<?php 
session_start();
include 'functions.php';
$uid = $_SESSION['uid'];
$db = new DB();
$table1 = "test_groups";
$result = $db->get_all($table1);
while ($arr = mysql_fetch_assoc($result)) {
    $k[$arr['Group_ID']] = $arr['Group_Name'];
}
foreach ($k as $key => $value) {
    ?>
      	
		<tr>
			<td><?php 
    echo $key;
    ?>
</td>
            <td><a href='data_entry_3_pre_back.php?group=<?php 
    echo $key;
    ?>
' class="col-sm-4 control-label" for="textinput"><?php 
Example #21
0
 function tminisave($have)
 {
     global $_M;
     //新方法
     $this->iniclass->tminisave($have);
     $wap_ok = 0;
     $cglist = $this->configlist;
     if ($have['mobile'] == '1') {
         $have['wap_skin_user'] = $have['met_skin_user'];
         $have['wap_skin_css'] = $have['met_skin_css'];
         $cglist = $this->mobile_configlist;
         //$have['flash_10001'] = $_M['config']['flash_10001'];
         $have['flash_10001'] = '1|' . $have['met_flash_10001_y'];
         $wap_ok = 1;
     } else {
         /*备用字段*/
         $preview['otherinfo']['imgurl1'] = $have['imgurl1'];
         $preview['otherinfo']['imgurl2'] = $have['imgurl2'];
         $query = "update {$_M[table][otherinfo]} SET ";
         for ($i = 1; $i <= 10; $i++) {
             $infoval = $have['info' . $i];
             if (isset($have['info' . $i])) {
                 $query .= "info{$i} = '{$infoval}',";
             }
         }
         $query .= "\n\t\t\t\timgurl1 = '{$have['imgurl1']}',\n\t\t\t\timgurl2 = '{$have['imgurl2']}'\n\t\t\t\twhere id='{$have['otherinfoid']}'\n\t\t\t";
         DB::query($query);
         load::sys_func('file');
         delfile(PATH_WEB . "cache/otherinfo_{$this->lang}.inc.php");
         $have['flash_10001'] = '1|' . $have['met_flash_10001_x'] . '|' . $have['met_flash_10001_y'] . '|' . $have['met_flash_10001_imgtype'];
     }
     $cglist[] = 'met_productTabok';
     $cglist[] = 'met_productTabname';
     $cglist[] = 'met_productTabname_1';
     $cglist[] = 'met_productTabname_2';
     $cglist[] = 'met_productTabname_3';
     $cglist[] = 'met_productTabname_4';
     configsave($cglist, $have, $this->lang);
     /*保存系统配置*/
     /*保存banner设置*/
     $nowidold = array();
     $bannerid = DB::get_all("select * from {$_M[table][flash]} where wap_ok='{$wap_ok}' and (module like '%,10001,%' or module = 'metinfo') and lang='{$this->lang}' and img_path!='' order by no_order ");
     foreach ($bannerid as $key => $val) {
         $nowidold[] = $val['id'];
     }
     $nowidnew = array();
     $have['indexbannerlist'] = str_replace("\\", "", $have['indexbannerlist']);
     $bannerlist = json_decode($have['indexbannerlist'], true);
     foreach ($bannerlist as $key => $val) {
         if ($val['img_path'] != '') {
             if (!strstr($val['img_path'], "../")) {
                 $val['img_path'] = '../' . $val['img_path'];
             }
             if ($val['id']) {
                 $query = "update {$_M[table][flash]} SET \n\t\t\t\t\timg_title = '{$val['img_title']}',\n\t\t\t\t\timg_path  = '{$val['img_path']}',\n\t\t\t\t\timg_link  = '{$val['img_link']}',\n\t\t\t\t\tno_order  = '{$key}'\n\t\t\t\t\tWHERE id  = '{$val['id']}'";
                 $nowidnew[] = $val['id'];
             } else {
                 $query = "INSERT INTO {$_M[table][flash]} SET \n\t\t\t\t\timg_title = '{$val['img_title']}',\n\t\t\t\t\timg_path  = '{$val['img_path']}',\n\t\t\t\t\timg_link  = '{$val['img_link']}',\n\t\t\t\t\tno_order  = '{$key}',\n\t\t\t\t\tmodule    = ',10001,',\n\t\t\t\t\twap_ok    = '{$wap_ok}',\n\t\t\t\t\tlang      = '{$this->lang}'";
             }
             DB::query($query);
         }
     }
     $nowid = array_diff($nowidold, $nowidnew);
     if ($nowid) {
         foreach ($nowid as $key => $val) {
             $query = "delete from {$_M[table][flash]} where id='{$val}'";
             DB::query($query);
         }
     }
 }
Example #22
0
 protected function add_power($no)
 {
     global $_M;
     $query = "SELECT * FROM {$_M['table']['admin_table']} WHERE usertype='3'";
     $admins = DB::get_all($query);
     foreach ($admins as $key => $val) {
         if (is_strinclude($val['admin_type'], 's1505') && !is_strinclude($val['admin_type'], 'a' . $no)) {
             $val['admin_type'] = str_replace('s1505', 's1505-a' . $no, $val['admin_type']);
             $query = "UPDATE {$_M['table']['admin_table']} SET admin_type='{$val['admin_type']}' WHERE id='{$val['id']}'";
             DB::query($query);
         }
     }
 }
Example #23
0
<?php

session_start();
require_once dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . 'lib' . DIRECTORY_SEPARATOR . 'requires.php';
if (!empty($_POST['username']) && !empty($_POST['pwd'])) {
    $db = new DB();
    $sql = "SELECT `id` ,`username` FROM  `" . DAPRE . "account` WHERE  `password` LIKE  '" . md5(trim($_POST['pwd'])) . "'AND  `username` LIKE  '" . $_POST['username'] . "'";
    $result = $db->get_one($sql);
    if ($result) {
        // 主用户登陆信息写入
        $_SESSION['login'] = true;
        $_SESSION['parentusername'] = $result['username'];
        //用户多账号信息写入
        $sql = "SELECT `id`, `name` FROM `" . DAPRE . "user` WHERE `parentusername` = '" . $_SESSION['parentusername'] . "'";
        $account = $db->get_all($sql);
        $_SESSION['account'] = $account;
        //多账户写入account
        header("Location: home.php");
        //初始化完毕。进入用户界面
    } else {
        $result = false;
    }
}
Example #24
0
//载入model基础类,其他所有的model都是继承自MODEL类
include_once END_SYSTEM_DIR . 'library/model.php';
//载入当前模块下的config.php
if (file_exists(END_MODULE_DIR . 'config.php')) {
    include_once END_MODULE_DIR . 'config.php';
}
//连接数据库
//$db变量会贯穿程序的整个执行过程,以统计整个页面运行了多少次 SQL 查询
$db = new DB();
$db->connect($mysql['server'], $mysql['username'], $mysql['password'], $mysql['database']);
//从数据库中读取config信息,覆盖掉$config变量
//这样做的好处就是,在config.php中可以写默认值,可以在后台添加一个同名的设置变量,就可以覆盖该值
if (!is_array($config)) {
    $config = array();
}
$__arr = $db->get_all("SELECT * FROM " . END_MYSQL_PREFIX . "config");
if ($__arr) {
    foreach ($__arr as $__c) {
        $config[$__c['name']] = $__c['value'];
    }
}
//钩子
function_exists('end_on_after_db') && end_on_after_db();
//发送header声明页面编码
header("CONTENT-TYPE:text/html; CHARSET=" . END_CHARSET);
//根据url中的p变量来确定对应的controller
$_page = $_GET['p'] ? $_GET['p'] : 'index';
$_page = preg_replace('/[^a-zA-Z0-9_]/', '', $_page);
define('END_CONTROLLER', $_page);
$_controller = $_page . '.php';
$_viewer = $_page . '.' . END_VIEWER_EXT;
Example #25
0
    $sql = "DELETE FROM " . DAPRE . "message WHERE id = " . $deletenumber;
    $db->query($sql);
}
if (isset($_SESSION['name']) && isset($_SESSION['friendname'])) {
    // 获取总聊天记录数
    $sql = "select count(*) as result_num from chatlog_message where fromname = " . $_SESSION['name'] . " and toname = " . $_SESSION['friendname'] . " and parentusername = '" . $_SESSION['parentusername'] . "'";
    $result = $db->get_one($sql);
    // 当结果为0,自动初始化为小于一页的记录
    if ($result['result_num'] > 0) {
        $pg = new page(10, $result['result_num']);
    } else {
        $pg = new page(10, 1);
    }
    // 获取用户与好友聊天记录
    $sql = "select *  from chatlog_message where fromname = " . $_SESSION['name'] . " and toname = " . $_SESSION['friendname'] . " and parentusername = '" . $_SESSION['parentusername'] . "'and time > " . $_SESSION['searchbytime'] . " order by time desc LIMIT " . $pg->show_page_result() . " , 10";
    $message = $db->get_all($sql);
}
// 处理返回结果给前台
foreach ($message as $key => $item) {
    // 返回主说话者姓名与被说话者姓名
    if ($item['flag']) {
        $item['fromname'] = $_SESSION['name'];
        $item['toname'] = $_SESSION['friendname'];
    } else {
        $item['fromname'] = $_SESSION['friendname'];
        $item['toname'] = $_SESSION['name'];
    }
    $displaymessage[$key]['fromname'] = $item['fromname'];
    $displaymessage[$key]['toname'] = $item['toname'];
    $displaymessage[$key]['message'] = $item['message'];
    $displaymessage[$key]['time'] = date('Y-m-d h:i:s', $item['time']);
Example #26
0
		<button>确定</button>
		<?php 
include 'include/Db.php';
$dbClass = new DB();
$dbClass->connect('localhost', 'root', '123', 'mynewsql');
//$query="SELECT * FROM 'userinfo' WHERE 1=1";
$sql = "SELECT * from userinfo WHERE 1=1";
//插入1
//$mydata = array('userName'=>'地道');
//print_r($mydata);
//$dbClass->insert("userinfo",$mydata);
//插入2
//$sqln = "INSERT INTO userinfo('userName') VALUES ('人间道')";
//$sqln = "INSERT INTO userinfo(userName) VALUES ('人间道')";
//$dbClass->query($sqln);
$rt = $dbClass->get_all($sql);
//print_r($rt);//显示数组
while (list($index, $content) = each($rt)) {
    //读取二维数组
    while (list($key, $val) = each($content)) {
        ?>
	 		<div class="data">
	 		<?php 
        if ($key == "userName") {
            echo "{$key}: ";
            echo "{$val}";
        }
        ?>
	           	 </div>	
	           	 <?php 
    }
Example #27
0
 public function dohome()
 {
     global $_M;
     /*获取统计数据*/
     function statime($ymd, $day = '')
     {
         $day = $day == '' ? time() : strtotime($day);
         $time = strtotime(date($ymd, $day));
         return $time;
     }
     $stat = array();
     for ($i = 1; $i <= 5; $i++) {
         $stats = $i == 1 ? statime("Y-m-d") : statime("Y-m-d", 0 - $i + 1 . " day");
         $query = "select * from {$_M[table][visit_summary]} WHERE stattime ='{$stats}'";
         $stat[$i] = DB::get_one($query);
         if (!$stat[$i]) {
             $stat[$i]['pv'] = 0;
             $stat[$i]['alone'] = 0;
             $stat[$i]['ip'] = 0;
         }
         $stat[$i]['day'] = date('Y-m-d', $stats);
         if ($i == 1) {
             $stat[$i]['day'] = $_M['word']['today'];
         }
         if ($i == 2) {
             $stat[$i]['day'] = $_M['word']['yesterday'];
         }
     }
     /*图表数据*/
     $dm = date('H', time());
     $dt = $dm - 8;
     $dt = $dt < 0 ? $dt + 24 : $dt;
     for ($i = 0; $i <= 23; $i++) {
         if ($i <= $dm && $i >= $dt) {
             $d = $i < 10 ? '0' . $i : $i;
             $chartdata['labels'][] = "{$d}:59";
         }
     }
     $chartcolor[0] = "#23b7e5";
     $chartcolor[1] = "#7266ba";
     $chartcolor[2] = "#23ad44";
     foreach ($chartcolor as $key => $val) {
         $chartdata['datasets'][$key]['fillColor'] = $val;
         $chartdata['datasets'][$key]['strokeColor'] = $val;
         $chartdata['datasets'][$key]['pointColor'] = $val;
         $chartdata['datasets'][$key]['pointStrokeColor'] = '#fff';
     }
     $nowcrt = explode("|", $stat[1]['parttime']);
     $i = 0;
     foreach ($nowcrt as $val) {
         if ($i <= $dm && $i >= $dt) {
             $aowcrt = '';
             if ($val) {
                 $aowcrt = explode("-", $val);
                 $val = array();
                 $val[0] = $aowcrt[0];
                 $val[1] = $aowcrt[1];
                 $val[2] = $aowcrt[2];
             } else {
                 $val[0] = 0;
                 $val[1] = 0;
                 $val[2] = 0;
             }
             $chartdata['datasets'][0]['data'][] = $val[0];
             $chartdata['datasets'][1]['data'][] = $val[1];
             $chartdata['datasets'][2]['data'][] = $val[2];
         }
         $i++;
     }
     $chartdata = jsonencode($chartdata);
     /*我的应用*/
     $query = "select * from {$_M['table']['admin_column']} where bigclass='44'";
     $app_in = DB::get_all($query);
     $privilege = background_privilege();
     require $this->template('tem/home');
 }
Example #28
0
<?php

require_once dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . 'lib' . DIRECTORY_SEPARATOR . 'requires.php';
require_once dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mcontrol.php';
$db = new DB();
$friends = array();
// print_r($_SESSION['account']);
//获取用户好友列表
if (isset($_SESSION['account'])) {
    foreach ($_SESSION['account'] as $key => $item) {
        $sql = " SELECT `id` , `toname` FROM `" . DAPRE . "friend` WHERE `fromname` = " . $item['name'] . "  and `parentusername` = '" . $_SESSION['parentusername'] . "'";
        $friend = $db->get_all($sql);
        //修改id和name
        foreach ($friend as $kr => $fr) {
            $friend[$kr]['touid'] = $fr['toname'];
            $friend[$kr]['name'] = $fr['toname'];
            $friend[$kr]['id'] = $fr['toname'];
        }
        $friends[$key] = $friend;
        $friends[$key]['name'] = $item['name'];
        $friends[$key]['id'] = $item['name'];
        //id已经没有用了。现在以name来查找
    }
    //echo json_encode($friends[0]);
    echo json_encode($friends);
    // print_r($friends);
}
        die('Curl failed: ' . curl_error($ch));
    }
    curl_close($ch);
    return $result;
}
$db = new DB();
if (isset($_POST['message']) && isset($_POST['title']) && isset($_POST['cluster']) && isset($_POST['event_name']) && isset($_POST['type']) && isset($_POST['internalgcmpin'])) {
    $msg = $_POST['message'];
    $title = $_POST['title'];
    $cluster = $_POST['cluster'];
    $type = $_POST['type'];
    $event = $_POST['event_name'];
    $gcmpin = $_POST['internalgcmpin'];
    if ($gcmpin == $_ENV["INTERNAL_GCM_PIN"]) {
        $chunk_size = 300;
        $result = $db->get_all($_ENV["GCM_TABLE"]);
        $reg_ids = array();
        while ($row = mysql_fetch_assoc($result)) {
            array_push($reg_ids, $row['gcm_id']);
        }
        $size = sizeof($reg_ids);
        $msg_arr = array("text" => $msg, "title" => $title, "cluster" => $cluster, "type" => $type, "event" => $event);
        $reg_id_chunks = array_chunk($reg_ids, $chunk_size);
        $db = new DB();
        $db->insert($_ENV["MESSAGE_TABLE"], array("message" => $msg, "title" => $title, "type" => $type, "cluster" => $cluster, "event" => $event, "sent_to" => $size));
        for ($i = 0; $i < sizeof($reg_id_chunks); $i++) {
            sendPushNotificationToGCM($reg_id_chunks[$i], $msg_arr);
        }
        $response = array("status_code" => 200, "description" => "Success");
        echo json_encode($response);
    } else {
Example #30
0
 $config = array('db_config' => $dbConfig, 'limit' => intval($_POST['limit']));
 //87数据库配置判断
 $srcDb = new DB($dbConfig['src_host'], $dbConfig['src_port'], $dbConfig['src_username'], $dbConfig['src_password'], $dbConfig['src_dbname'], $dbConfig['src_dbpre']);
 //nextwind数据库配置判断
 $link = @mysql_connect("{$dbConfig['host']}:{$dbConfig['port']}", $dbConfig['username'], $dbConfig['password'], true);
 if ($link) {
     if (!@mysql_select_db($dbConfig['dbname'], $link)) {
         if (!@mysql_query("CREATE DATABASE " . $dbConfig['dbname'] . " DEFAULT CHARSET=" . $charset, $link)) {
             showError('数据库' . $dbConfig['dbname'] . ' 创建失败! 请检查是否有权限! ');
         }
     }
 } else {
     showError("Access denied for user '{$dbConfig['username']}'@'{$dbConfig['host']}' (using password: YES)");
 }
 //获得分表配置
 $_list = $srcDb->get_all("SELECT * FROM pw_config WHERE db_name IN ('db_plist','db_tlist')", MYSQL_ASSOC, 'db_name');
 $config['db_plist'] = $config['db_tlist'] = array();
 foreach ($_list as $_k => $value) {
     $_list = unserialize($value['db_value']);
     if (is_array($_list)) {
         $_list = array_keys($_list);
         sort($_list);
         $config[$_k] = $_list;
     }
 }
 //获得ftp配置
 $_list = $srcDb->get_all("SELECT * FROM pw_config WHERE db_name LIKE '%ftp%'", MYSQL_ASSOC, 'db_name');
 $config['db_ftp'] = array();
 $config['db_ftp']['db_ifftp'] = $_list['db_ifftp']['db_value'];
 if ($_list['db_ifftp']['db_value']) {
     $config['db_ftp']['db_ftpweb'] = $_list['db_ftpweb']['db_value'];