/**
* page main code
*/
function go_page()
{
if ($this->page != "") {
$reslut = mysql::fn_select($this->table, 'count(*) as `total`', $this->condition, '', $this->limit);
$rs = mysql::fetch_array($reslut);
$message_count = $rs['total'];
//get the messages's count number
$page_count = ceil($message_count / $this->page_size);
//get the page's count number
$offset = ($this->page - 1) * $this->page_size;
//get the first value of sql's limit
if ($message_count <= $this->page_size) {
$page_code = array("", "", "", "");
} else {
if ($this->page == 1) {
$page_code = array("", "", "<A name=code href=" . $this->href . "?page=" . ($this->page + 1) . "&action=" . $this->action_value . "&" . $this->url_value . ">下一页</a>", "<A name=code href=" . $this->href . "?page=" . $page_count . "&action=" . $this->action_value . "&" . $this->url_value . ">尾页</a>");
} else {
if ($this->page == $page_count) {
$page_code = array("<A name='code' href=" . $this->href . "?page=1&action=" . $this->action_value . "&" . $this->url_value . ">首页</a>", "<A name='code' href=" . $this->href . "?page=" . ($this->page - 1) . "&action=" . $this->action_value . "&" . $this->url_value . ">上一页</a>", "", "");
} else {
$page_code = array("<A name='code' href=" . $this->href . "?page=1&action=" . $this->action_value . "&" . $this->url_value . ">首页</a>", "<A name='code' href=" . $this->href . "?page=" . ($this->page - 1) . "&action=" . $this->action_value . "&" . $this->url_value . ">上一页</a>", "<A name='code' href=" . $this->href . "?page=" . ($this->page + 1) . "&action=" . $this->action_value . "&" . $this->url_value . ">下一页</a>", "<A name='code' href=" . $this->href . "?page=" . $page_count . "&action=" . $this->action_value . "&" . $this->url_value . ">尾页</a>");
}
}
}
$page_info = array("message_count" => $message_count, "page_count" => $page_count, "offset" => $offset, "page_size" => $this->page_size, "page_now" => $this->page, "page_first" => $page_code[0], "page_up" => $page_code[1], "page_next" => $page_code[2], "page_one_last" => $page_code[3]);
return $page_info;
}
}
/**
* SELECT
*/
public function select()
{
$select_sql = 'SELECT {FIELD} FROM {TABLE}{WHERE}{GROUP}{HAVING}{ORDER}{LIMIT}';
$this->sql = str_replace(array('{TABLE}', '{FIELD}', '{WHERE}', '{GROUP}', '{HAVING}', '{ORDER}', '{LIMIT}'), array($this->_parseTable(), $this->_parseField(), $this->_parseWhere(), $this->_parseGroup(), $this->_parseHaving(), $this->_parseOrder(), $this->_parseLimit()), $select_sql);
$data = array();
$query = $this->query($this->sql);
$key = $this->_parseKey();
while ($row = $this->db->fetch_array($query)) {
if ($key) {
$data[$row[$key]] = $row;
} else {
$data[] = $row;
}
}
return $data;
}
function synlogin($user)
{
global $timestamp, $uc_key;
list($winduid, $windid, $windpwd) = explode("\t", $this->base->strcode($user, false));
header('P3P: CP="CURa ADMa DEVa PSAo PSDo OUR BUS UNI PUR INT DEM STA PRE COM NAV OTC NOI DSP COR"');
require_once "../../config/db.config.php";
require_once "../../app/include/mysql.class.php";
require_once "../../app/include/public.function.php";
require_once "../../data/plus/config.php";
$ip = fun_ip_get();
$time = time();
if ($config[sy_pw_type] == "pw_center") {
$db = new mysql($db_config['dbhost'], $db_config['dbuser'], $db_config['dbpass'], $db_config['dbname'], ALL_PS, $db_config['charset']);
$user_query = $db->query("SELECT * FROM {$db_config['def']}member WHERE `username`='{$windid}'");
while ($userrs = $db->fetch_array($user_query)) {
$userinfo = $userrs;
}
//判断是否是重名用户
if ($userinfo["uid"] > 0) {
if ($userinfo["pw_repeat"] != "1") {
//判断账户名密码是否一致
if ($userinfo["password"] == md5($windpwd . $userinfo[salt])) {
$db->query("UPDATE {$db_config['def']}member SET `pwuid`='{$winduid}' WHERE `uid`='{$userinfo['uid']}'");
$this->unset_cookie();
$this->add_cookie($userinfo[uid], $userinfo[username], $userinfo[salt], $userinfo[email], $userinfo[password]);
} else {
//不一致标注为重名用户
$db->query("UPDATE {$db_config['def']}member SET `pw_repeat`='1' WHERE `uid`='{$userinfo['uid']}'");
}
}
} else {
//用户不存在 新建一个用户
$salt = substr(uniqid(rand()), -6);
$pass = md5($windpwd . $salt);
$db->query("INSERT INTO {$db_config['def']}member SET `username`='{$windid}',`password`='{$pass}',`salt`='{$salt}',`usertype`='1',`reg_ip`='{$ip}',`reg_date`='{$time}',`pwuid`='{$winduid}'");
$uid = $db->insert_id();
$db->query("INSERT INTO {$db_config['def']}resume SET `uid`='" . $uid . "'");
$db->query("INSERT INTO {$db_config['def']}member_statis SET `uid`='" . $uid . "'");
$this->unset_cookie();
$this->add_cookie($winduid, $windid, $salt, "", $pass);
}
}
}
$wheresql .= " AND experience={$experience} ";
}
if ($nature != '') {
$wheresql .= " AND nature={$nature} ";
}
if ($scale != '') {
$wheresql .= " AND scale={$scale} ";
}
if (!empty($wheresql)) {
$wheresql = " WHERE " . ltrim(ltrim($wheresql), 'AND');
$wheresql .= " AND map_x!='' AND map_y!='' ";
}
$id = array();
if (!empty($lng) && !empty($lat)) {
$idresult = $db->query("SELECT id , ROUND(6378.138*2*ASIN(SQRT(POW(SIN((" . $lat . "*PI()/180-map_y*PI()/180)/2),2)+COS(" . $lat . "*PI()/180)*COS(map_y*PI()/180)*POW(SIN((" . $lng . "*PI()/180-map_x*PI()/180)/2),2)))*1000) AS juli FROM {$jobstable} " . $wheresql . " ORDER BY juli ASC LIMIT {$offset},{$rows}");
while ($row = $db->fetch_array($idresult)) {
$id[] = $row['id'];
}
}
if (!empty($id)) {
$wheresql = " WHERE id IN (" . implode(',', $id) . ") ";
$sql = "SELECT *, ROUND(6378.138*2*ASIN(SQRT(POW(SIN((" . $lat . "*PI()/180-map_y*PI()/180)/2),2)+COS(" . $lat . "*PI()/180)*COS(map_y*PI()/180)*POW(SIN((" . $lng . "*PI()/180-map_x*PI()/180)/2),2)))*1000) AS juli FROM " . table('jobs') . $wheresql . " ORDER BY juli ASC , stick DESC , refreshtime DESC ";
$jobs_list = $db->getall($sql);
foreach ($jobs_list as $key => $value) {
$jobs_list[$key]["juli"] = distancerange($value["juli"]);
}
} else {
$jobs_list = array();
}
$smarty->assign('jobs', $jobs_list);
$smarty->assign('goback', $_SERVER["HTTP_REFERER"]);
<?php
include "config/config.php";
include "common/mysql.class.php";
$db = new mysql($mydbhost, $mydbuser, $mydbpw, $mydbname, $mydbcharset);
session_start();
$username = $_SESSION['username'];
$uid = $_SESSION['uid'];
$confsql = "select sitename,ensitename,keywords,enkeywords,des,endes,title,entitle from `th_config` where id=1";
$confquery = $db->query($confsql);
$confrow = $db->fetch_array($confquery);
define('INDTITLE', $confrow['title']);
define('SN', $confrow['sitename']);
define('KW', $confrow['keywords']);
define('DES', $confrow['des']);
define('ENINDTITLE', $confrow['entitle']);
define('ENSN', $confrow['ensitename']);
define('ENKW', $confrow['enkeywords']);
define('ENDES', $confrow['endes']);
function getPicUrl($picId)
{
global $db;
$sql = "select url from `th_uploads` where id=" . $picId;
$query = $db->query($sql);
$row = $db->fetch_array($query);
return $url = $row['url'];
}
function getPicThumb($picId)
{
global $db;
$sql = "select thumb from `th_uploads` where id=" . $picId;
require ROOT_PATH . '/inc/mysql.class.php';
require ROOT_PATH . '/inc/global.func.php';
include ROOT_PATH . '/inc/session.class.php';
include ROOT_PATH . '/inc/xml.class.php';
include_once ROOT_PATH . '/inc/Taoapi.php';
//初始化session
$session = new session();
if ($_REQUEST) {
$_REQUEST['sid'] = $session->get_id();
}
//初始化数据连接
$db = new mysql();
$db->connect($dbhost, $dbuser, $dbpw, $dbname);
if (!checkfile('setting', 0)) {
$query = $db->query('select variable,content from ' . tname('setting'));
while ($rows = $db->fetch_array($query)) {
$setting[$rows['variable']] = $rows['content'];
}
//网站类型设定
$setting['sitelogType'] = array(1 => '网购商城', 2 => '名站导航', 3 => '团购网站', 4 => '综合平台');
write('setting', $setting);
} else {
$setting = read('setting');
}
/*--------------------系统变量--------------------------*/
define('TPLDIR', !empty($_GET['tplview']) ? $_GET['tplview'] : ($setting['site_template_dir'] ? $setting['site_template_dir'] : 'default'));
define("SITE_ROOT", 'http://' . str_replace('://', '', str_replace('http', '', $setting['site_url'])));
define('VERSION', 'KaKa101_zidan v1.1');
$timezone = 'Asia/Shanghai';
$timestamp = time();
$tplrefresh = 5;
function synlogin($get, $post)
{
if (!API_SYNLOGIN) {
return API_RETURN_FORBIDDEN;
}
header('P3P: CP="CURa ADMa DEVa PSAo PSDo OUR BUS UNI PUR INT DEM STA PRE COM NAV OTC NOI DSP COR"');
require_once "../../data/db.config.php";
require_once "../../include/mysql.class.php";
require_once "../../include/public.function.php";
require_once "../../plus/config.php";
$ip = fun_ip_get();
$time = time();
if ($config[sy_uc_type] == "uc_center") {
$db = new mysql($db_config['dbhost'], $db_config['dbuser'], $db_config['dbpass'], $db_config['dbname'], ALL_PS, $db_config['charset']);
$user_query = $db->query("SELECT * FROM {$db_config['def']}member WHERE `username`='{$get['username']}'");
while ($userrs = $db->fetch_array($user_query)) {
$userinfo[] = $userrs;
}
if ($config[sy_onedomain] != "") {
$weburl = str_replace("http://www", "", $config[sy_onedomain]);
} elseif ($config[sy_indexdomain] != "") {
$weburl = str_replace("http://www", "", $config[sy_indexdomain]);
} else {
$weburl = str_replace("http://www", "", $config[sy_weburl]);
}
if (is_array($userinfo)) {
$uid = $userinfo[0][uid];
$certokquery = $db->query("SELECT * FROM {$db_config['def']}company_cert where `uid`='{$uid} ' and `type`='1'");
while ($certrow = $db->fetch_array($certokquery)) {
$certstatus = $certrow[status];
}
if ($userinfo[0][username] == $get[username] && $userinfo[0][name_repeat] != "1") {
$this->unset_cookie($weburl);
if ($userinfo[0][password] == $get[password]) {
if ($certstatus == "1" || $config[user_status] != "1" || $userinfo[0][usertype] == "2") {
$this->add_cookie($weburl, $userinfo[0][uid], $userinfo[0][username], $userinfo[0][salt], $userinfo[0][email], $userinfo[0][password], $userinfo[0][usertype]);
}
} else {
$db->query("UPDATE {$db_config['def']}member SET `password`='{$get['password']}',`email`='{$get['email']}',`salt`='{$get['salt']}' WHERE `uid`='{$uid}'");
if ($certstatus == "1" || $config[user_status] != "1") {
$this->add_cookie($weburl, $userinfo[0][uid], $userinfo[0][username], $get[salt], $get[email], $get[password], $userinfo[0][usertype]);
}
}
$db->query("UPDATE {$db_config['def']}member SET `login_ip`='{$ip}',`login_date`='{$time}',`login_hits`=`login_hits`+1 where `uid`='{$uid}'");
}
} else {
$db->query("INSERT INTO {$db_config['def']}member SET `username`='{$get['username']}',`password`='{$get['password']}',`email`='{$get['email']}',`salt`='{$get['salt']}',`usertype`='1',`reg_ip`='{$ip}',`reg_date`='{$time}'");
$uid = $db->insert_id();
$db->query("INSERT INTO {$db_config['def']}resume SET `uid`='" . $uid . "'");
$db->query("INSERT INTO {$db_config['def']}member_statis SET `uid`='" . $uid . "'");
$randstr = rand(10000000, 99999999);
$db->query("INSERT INTO {$db_config['def']}company_cert SET `status`='0',`step`='1',`check`='{$get['email']}',`check2`='{$randstr}',`ctime`='" . mktime() . "',`type`='1',`uid`='" . $uid . "'");
$this->unset_cookie($weburl);
if ($config[user_status] != "1") {
$this->add_cookie($weburl, $uid, $get[username], $get[salt], $get[email], $get[password]);
}
}
}
}
$smarty->cache = true;
$smarty->cache_lifetime = $mypage['caching'];
} else {
$smarty->cache = false;
}
$cached_id = $alias . (isset($_GET['id']) ? "|" . intval($_GET['id']) % 100 . '|' . intval($_GET['id']) : '') . (isset($_GET['page']) ? "|p" . intval($_GET['page']) % 100 : '');
require_once QISHI_ROOT_PATH . 'include/mysql.class.php';
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
//统计测评类型参与人数
$sql = "SELECT * FROM " . table('evaluation_type') . " ";
$type_info = $db->getall($sql);
foreach ($type_info as $key => $value) {
$num = 0;
$sql_num = "SELECT * FROM " . table('evaluation_paper') . " WHERE type_id=" . $value['id'];
$type_num = $db->query($sql_num);
while ($row = $db->fetch_array($type_num)) {
$num = $num + intval($row['join_num']);
}
$type_info[$key]['join_num'] = $num;
}
//热门测评
$paper_sql = "SELECT * FROM " . table('evaluation_paper') . " ORDER BY join_num LIMIT 10 ";
$paper_info = $db->getall($paper_sql);
foreach ($paper_info as $key => $value) {
$paper_info[$key]['key'] = $key + 1;
}
$smarty->assign('type_info', $type_info);
$smarty->assign('paper_info', $paper_info);
if (!$smarty->is_cached($mypage['tpl'], $cached_id)) {
require_once QISHI_ROOT_PATH . 'include/mysql.class.php';
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
function synlogin($get, $post)
{
if (!API_SYNLOGIN) {
return API_RETURN_FORBIDDEN;
}
header('P3P: CP="CURa ADMa DEVa PSAo PSDo OUR BUS UNI PUR INT DEM STA PRE COM NAV OTC NOI DSP COR"');
//TODO:暂时不知道如何改成PLUS_PATH
require_once $this->appdir . "config/db.config.php";
require_once $this->appdir . "app/include/mysql.class.php";
require_once $this->appdir . "app/include/public.function.php";
require_once dirname(dirname(dirname(__FILE__))) . "/data/plus/config.php";
//$ip = fun_ip_get();
$time = time();
if ($config[sy_uc_type] == "uc_center") {
$db = new mysql($db_config['dbhost'], $db_config['dbuser'], $db_config['dbpass'], $db_config['dbname'], ALL_PS, $db_config['charset']);
$user_query = $db->query("SELECT * FROM {$db_config['def']}member WHERE `username`='{$get['username']}'");
while ($userrs = $db->fetch_array($user_query)) {
$userinfo[] = $userrs;
}
if ($config[sy_onedomain] != "") {
$weburl = "." . $config[sy_onedomain];
} else {
$weburl = str_replace("http://www", "", $config[sy_weburl]);
}
if (is_array($userinfo)) {
$uid = $userinfo[0][uid];
$certokquery = $db->query("SELECT * FROM {$db_config['def']}company_cert where `uid`='{$uid} ' and `type`='1'");
while ($certrow = $db->fetch_array($certokquery)) {
$certstatus = $certrow[status];
}
//$pass = md5($userinfo[0][password].$get[salt]);
if ($userinfo[0][username] == $get[username] && $userinfo[0][name_repeat] != "1") {
$this->unset_cookie($weburl);
if ($userinfo[0][password] == $get[password]) {
if ($certstatus == "1" || $config[user_status] != "1" || $userinfo[0][usertype] == "2") {
$this->add_cookie($weburl, $userinfo[0][uid], $userinfo[0][username], $userinfo[0][salt], $userinfo[0][email], $userinfo[0][password], $userinfo[0][usertype]);
}
} else {
$db->query("UPDATE {$db_config['def']}member SET `password`='{$get['password']}',`email`='{$get['email']}',`salt`='{$get['salt']}' WHERE `uid`='{$uid}'");
if ($certstatus == "1" || $config[user_status] != "1") {
$this->add_cookie($weburl, $userinfo[0][uid], $userinfo[0][username], $get[salt], $get[email], $get[password], $userinfo[0][usertype]);
}
}
$db->query("UPDATE {$db_config['def']}member SET `login_ip`='{$ip}',`login_date`='{$time}',`login_hits`=`login_hits`+1 where `uid`='{$uid}'");
}
} else {
//创建用户但是无会员身份（usertype）
$db->query("INSERT INTO {$db_config['def']}member SET `username`='{$get['username']}',`password`='{$get['password']}',`email`='{$get['email']}',`salt`='{$get['salt']}',`reg_ip`='{$ip}',`reg_date`='{$time}',`usertype`='0'");
$uid = $db->insert_id();
}
}
}
