|
|
<?php
|
|
|
|
|
|
/**
|
|
|
* 前台公用函數庫
|
|
|
* $Author: wayne $
|
|
|
* $Id: lib_main.php 17217 2011-01-19 06:29:08Z wayne $
|
|
|
*/
|
|
|
|
|
|
if (!defined('IN_ASC'))
|
|
|
{
|
|
|
die('Hacking attempt');
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 更新用户SESSION,COOKIE及登錄時間、登錄次數。
|
|
|
*
|
|
|
* @access public
|
|
|
* @return void
|
|
|
*/
|
|
|
function update_user_info()
|
|
|
{
|
|
|
if (!$_SESSION['user_id'])
|
|
|
{
|
|
|
return false;
|
|
|
}
|
|
|
|
|
|
/* 查詢客戶信息 */
|
|
|
$time = date('Y-m-d');
|
|
|
$sql = 'SELECT u.user_money,u.email, u.pay_points, u.user_rank, u.rank_points, '.
|
|
|
' IFNULL(b.type_money, 0) AS user_bonus, u.last_login, u.last_ip'.
|
|
|
' FROM ' .$GLOBALS['ecs']->table('users'). ' AS u ' .
|
|
|
' LEFT JOIN ' .$GLOBALS['ecs']->table('user_bonus'). ' AS ub'.
|
|
|
' ON ub.user_id = u.user_id AND ub.used_time = 0 ' .
|
|
|
' LEFT JOIN ' .$GLOBALS['ecs']->table('bonus_type'). ' AS b'.
|
|
|
" ON b.type_id = ub.bonus_type_id AND b.use_start_date <= '$time' AND b.use_end_date >= '$time' ".
|
|
|
" WHERE u.user_id = '$_SESSION[user_id]'";
|
|
|
if ($row = $GLOBALS['db']->getRow($sql))
|
|
|
{
|
|
|
/* 更新SESSION */
|
|
|
$_SESSION['last_time'] = $row['last_login'];
|
|
|
$_SESSION['last_ip'] = $row['last_ip'];
|
|
|
$_SESSION['login_fail'] = 0;
|
|
|
$_SESSION['email'] = $row['email'];
|
|
|
|
|
|
/*判斷是否是特殊等級，可能後台把特殊客戶組更改普通客戶組*/
|
|
|
if($row['user_rank'] >0)
|
|
|
{
|
|
|
$sql="SELECT special_rank from ".$GLOBALS['ecs']->table('user_rank')."where rank_id='$row[user_rank]'";
|
|
|
if($GLOBALS['db']->getOne($sql)==='0' || $GLOBALS['db']->getOne($sql)===null)
|
|
|
{
|
|
|
$sql="update ".$GLOBALS['ecs']->table('users')."set user_rank='0' where user_id='$_SESSION[user_id]'";
|
|
|
$GLOBALS['db']->query($sql);
|
|
|
$row['user_rank']=0;
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/* 取得用户等級和折扣 */
|
|
|
if ($row['user_rank'] == 0)
|
|
|
{
|
|
|
// 非特殊等級，根據等級積分計算用户等級（注意：不包括特殊等級）
|
|
|
$sql = 'SELECT rank_id, discount FROM ' . $GLOBALS['ecs']->table('user_rank') . " WHERE special_rank = '0' AND min_points <= " . intval($row['rank_points']) . ' AND max_points > ' . intval($row['rank_points']);
|
|
|
if ($row = $GLOBALS['db']->getRow($sql))
|
|
|
{
|
|
|
$_SESSION['user_rank'] = $row['rank_id'];
|
|
|
$_SESSION['discount'] = $row['discount'] / 100.00;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$_SESSION['user_rank'] = 0;
|
|
|
$_SESSION['discount'] = 1;
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
// 特殊等級
|
|
|
$sql = 'SELECT rank_id, discount FROM ' . $GLOBALS['ecs']->table('user_rank') . " WHERE rank_id = '$row[user_rank]'";
|
|
|
if ($row = $GLOBALS['db']->getRow($sql))
|
|
|
{
|
|
|
$_SESSION['user_rank'] = $row['rank_id'];
|
|
|
$_SESSION['discount'] = $row['discount'] / 100.00;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$_SESSION['user_rank'] = 0;
|
|
|
$_SESSION['discount'] = 1;
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/* 更新登錄時間，登錄次數及登錄ip */
|
|
|
$sql = "UPDATE " .$GLOBALS['ecs']->table('users'). " SET".
|
|
|
" visit_count = visit_count + 1, ".
|
|
|
" last_ip = '" .real_ip(). "',".
|
|
|
" last_login = '" .gmtime(). "'".
|
|
|
" WHERE user_id = '" . $_SESSION['user_id'] . "'";
|
|
|
$GLOBALS['db']->query($sql);
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 獲取用户信息數組
|
|
|
*
|
|
|
* @access public
|
|
|
* @param
|
|
|
*
|
|
|
* @return array $user 用户信息數組
|
|
|
*/
|
|
|
function get_user_info($id=0)
|
|
|
{
|
|
|
if ($id == 0)
|
|
|
{
|
|
|
$id = $_SESSION['user_id'];
|
|
|
}
|
|
|
$time = date('Y-m-d');
|
|
|
$sql = 'SELECT u.user_id, u.email, u.user_name, u.user_money, u.pay_points'.
|
|
|
' FROM ' .$GLOBALS['ecs']->table('users'). ' AS u ' .
|
|
|
" WHERE u.user_id = '$id'";
|
|
|
$user = $GLOBALS['db']->getRow($sql);
|
|
|
$bonus = get_user_bonus($id);
|
|
|
|
|
|
$user['username'] = $user['user_name'];
|
|
|
$user['user_points'] = $user['pay_points'] . $GLOBALS['_CFG']['integral_name'];
|
|
|
$user['user_money'] = price_format($user['user_money'], false);
|
|
|
$user['user_bonus'] = price_format($bonus['bonus_value'], false);
|
|
|
|
|
|
return $user;
|
|
|
}
|
|
|
/**
|
|
|
* 取得當前位置和頁面標題
|
|
|
*
|
|
|
* @access public
|
|
|
* @param integer $cat 分類編號（只有產品及分類、文章及分類用到）
|
|
|
* @param string $str 產品名、文章標題或其他附加的內容（無鏈接）
|
|
|
* @return array
|
|
|
*/
|
|
|
function assign_ur_here($cat = 0, $str = '')
|
|
|
{
|
|
|
/* 判斷是否重寫，取得文件名 */
|
|
|
$cur_url = basename(PHP_SELF);
|
|
|
if (intval($GLOBALS['_CFG']['rewrite']))
|
|
|
{
|
|
|
$filename = strpos($cur_url,'-') ? substr($cur_url, 0, strpos($cur_url,'-')) : substr($cur_url, 0, -4);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$filename = substr($cur_url, 0, -4);
|
|
|
}
|
|
|
|
|
|
/* 初始化“頁面標題”和“當前位置” */
|
|
|
$page_title = $GLOBALS['_CFG']['shop_title'];
|
|
|
if($filename != 'goods')
|
|
|
{
|
|
|
$ur_here = '<a href=".">' . $GLOBALS['_LANG']['home'] . '</a>';
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$ur_here = '<a href=".">' . $GLOBALS['_LANG']['home'] . '</a>';
|
|
|
}
|
|
|
|
|
|
|
|
|
/* 根據文件名分別處理中間的部分 */
|
|
|
if ($filename != 'index')
|
|
|
{
|
|
|
/* 處理有分類的 */
|
|
|
if (in_array($filename, array('category', 'goods', 'article_cat', 'article', 'brand')))
|
|
|
{
|
|
|
/* 產品分類或產品 */
|
|
|
if ('category' == $filename || 'goods' == $filename || 'brand' == $filename)
|
|
|
{
|
|
|
if ($cat > 0)
|
|
|
{
|
|
|
$cat_arr = get_parent_cats($cat);
|
|
|
|
|
|
$key = 'cid';
|
|
|
$type = 'category';
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$cat_arr = array();
|
|
|
}
|
|
|
}
|
|
|
/* 文章分類或文章 */
|
|
|
elseif ('article_cat' == $filename || 'article' == $filename)
|
|
|
{
|
|
|
if ($cat > 0)
|
|
|
{
|
|
|
$cat_arr = get_article_parent_cats($cat);
|
|
|
|
|
|
$key = 'acid';
|
|
|
$type = 'article_cat';
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$cat_arr = array();
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/* 循環分類 */
|
|
|
if (!empty($cat_arr))
|
|
|
{
|
|
|
krsort($cat_arr);
|
|
|
foreach ($cat_arr AS $val)
|
|
|
{
|
|
|
$page_title = htmlspecialchars($val['cat_name']) . '_' . $page_title;
|
|
|
$args = array($key => $val['cat_id']);
|
|
|
$ur_here .= ' <code>></code> <a href="' . build_uri($type, $args, $val['cat_name']) . '">' .
|
|
|
htmlspecialchars($val['cat_name']) . '</a>';
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
/* 處理無分類的 */
|
|
|
else
|
|
|
{
|
|
|
/* 團購 */
|
|
|
if ('group_buy' == $filename)
|
|
|
{
|
|
|
$page_title = $GLOBALS['_LANG']['group_buy_goods'] . '_' . $page_title;
|
|
|
$args = array('gbid' => '0');
|
|
|
$ur_here .= ' <code>></code> <a href="group_buy.php">' .
|
|
|
$GLOBALS['_LANG']['group_buy_goods'] . '</a>';
|
|
|
}
|
|
|
/* 秒殺 */
|
|
|
if ('pre_spike' == $filename)
|
|
|
{
|
|
|
$page_title = $GLOBALS['_LANG']['pre_spike_goods'] . '_' . $page_title;
|
|
|
$args = array('gbid' => '0');
|
|
|
$ur_here .= ' <code>></code> <a href="pre_spike.php">' .
|
|
|
$GLOBALS['_LANG']['pre_spike_goods'] . '</a>';
|
|
|
}
|
|
|
/* 預售 */
|
|
|
if ('pre_sale' == $filename)
|
|
|
{
|
|
|
$page_title = $GLOBALS['_LANG']['pre_sale_goods'] . '_' . $page_title;
|
|
|
$args = array('gbid' => '0');
|
|
|
$ur_here .= ' <code>></code> <a href="pre_sale.php">' .
|
|
|
$GLOBALS['_LANG']['pre_sale_goods'] . '</a>';
|
|
|
}
|
|
|
/* 拍賣 */
|
|
|
elseif ('auction' == $filename)
|
|
|
{
|
|
|
$page_title = $GLOBALS['_LANG']['auction'] . '_' . $page_title;
|
|
|
$args = array('auid' => '0');
|
|
|
$ur_here .= ' <code>></code> <a href="auction.php">' .
|
|
|
$GLOBALS['_LANG']['auction'] . '</a>';
|
|
|
}
|
|
|
/* 奪寶 */
|
|
|
elseif ('snatch' == $filename)
|
|
|
{
|
|
|
$page_title = $GLOBALS['_LANG']['snatch'] . '_' . $page_title;
|
|
|
$args = array('id' => '0');
|
|
|
$ur_here .= ' <code> > </code><a href="snatch.php">' . $GLOBALS['_LANG']['snatch_list'] . '</a>';
|
|
|
}
|
|
|
/* 批發 */
|
|
|
elseif ('wholesale' == $filename)
|
|
|
{
|
|
|
$page_title = $GLOBALS['_LANG']['wholesale'] . '_' . $page_title;
|
|
|
$args = array('wsid' => '0');
|
|
|
$ur_here .= ' <code>></code> <a href="wholesale.php">' .
|
|
|
$GLOBALS['_LANG']['wholesale'] . '</a>';
|
|
|
}
|
|
|
/* 積分兑換 */
|
|
|
elseif ('exchange' == $filename)
|
|
|
{
|
|
|
$page_title = $GLOBALS['_LANG']['exchange'] . '_' . $page_title;
|
|
|
$args = array('wsid' => '0');
|
|
|
$ur_here .= ' <code>></code> <a href="exchange.php">' .
|
|
|
$GLOBALS['_LANG']['exchange'] . '</a>';
|
|
|
}
|
|
|
/* 預售 start*/
|
|
|
elseif ('pre_sale' == $filename)
|
|
|
{
|
|
|
$page_title = $GLOBALS['_LANG']['pre_sale'] . '_' . $page_title;
|
|
|
$args = array('wsid' => '0');
|
|
|
$ur_here .= ' <code>></code> <a href="pre_sale.php">' .
|
|
|
$GLOBALS['_LANG']['pre_sale'] . '</a>';
|
|
|
}
|
|
|
/* 預售 end */
|
|
|
|
|
|
/* 其他的在這裏補充 */
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/* 處理最後一部分 */
|
|
|
if (!empty($str))
|
|
|
{
|
|
|
$page_title = $str . '_' . $page_title;
|
|
|
$ur_here .= ' <code>></code> ' . $str;
|
|
|
}
|
|
|
|
|
|
/* 返回值 */
|
|
|
return array('title' => $page_title, 'ur_here' => $ur_here);
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 獲得指定分類的所有上級分類
|
|
|
*
|
|
|
* @access public
|
|
|
* @param integer $cat 分類編號
|
|
|
* @return array
|
|
|
*/
|
|
|
function get_parent_cats($cat)
|
|
|
{
|
|
|
if ($cat == 0)
|
|
|
{
|
|
|
return array();
|
|
|
}
|
|
|
|
|
|
$arr = $GLOBALS['db']->GetAll('SELECT cat_id, cat_name, parent_id FROM ' . $GLOBALS['ecs']->table('category'));
|
|
|
|
|
|
if (empty($arr))
|
|
|
{
|
|
|
return array();
|
|
|
}
|
|
|
|
|
|
$index = 0;
|
|
|
$cats = array();
|
|
|
|
|
|
while (1)
|
|
|
{
|
|
|
foreach ($arr AS $row)
|
|
|
{
|
|
|
if ($cat == $row['cat_id'])
|
|
|
{
|
|
|
$cat = $row['parent_id'];
|
|
|
|
|
|
$cats[$index]['cat_id'] = $row['cat_id'];
|
|
|
$cats[$index]['cat_name'] = $row['cat_name'];
|
|
|
|
|
|
$index++;
|
|
|
break;
|
|
|
}
|
|
|
}
|
|
|
|
|
|
if ($index == 0 || $cat == 0)
|
|
|
{
|
|
|
break;
|
|
|
}
|
|
|
}
|
|
|
|
|
|
return $cats;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 根據提供的數組編譯成頁面標題
|
|
|
*
|
|
|
* @access public
|
|
|
* @param string $type 類型
|
|
|
* @param array $arr 分類數組
|
|
|
* @return string
|
|
|
*/
|
|
|
function build_pagetitle($arr, $type = 'category')
|
|
|
{
|
|
|
$str = '';
|
|
|
|
|
|
foreach ($arr AS $val)
|
|
|
{
|
|
|
$str .= htmlspecialchars($val['cat_name']) . '_';
|
|
|
}
|
|
|
|
|
|
return $str;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 根據提供的數組編譯成當前位置
|
|
|
*
|
|
|
* @access public
|
|
|
* @param string $type 類型
|
|
|
* @param array $arr 分類數組
|
|
|
* @return void
|
|
|
*/
|
|
|
function build_urhere($arr, $type = 'category')
|
|
|
{
|
|
|
krsort($arr);
|
|
|
|
|
|
$str = '';
|
|
|
foreach ($arr AS $val)
|
|
|
{
|
|
|
switch ($type)
|
|
|
{
|
|
|
case 'category':
|
|
|
case 'brand':
|
|
|
$args = array('cid' => $val['cat_id']);
|
|
|
break;
|
|
|
case 'article_cat':
|
|
|
$args = array('acid' => $val['cat_id']);
|
|
|
break;
|
|
|
}
|
|
|
|
|
|
$str .= ' <code>></code> <a href="' . build_uri($type, $args). '">' . htmlspecialchars($val['cat_name']) . '</a>';
|
|
|
}
|
|
|
|
|
|
return $str;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 獲得指定頁面的動態內容
|
|
|
*
|
|
|
* @access public
|
|
|
* @param string $tmp 模板名稱
|
|
|
* @return void
|
|
|
*/
|
|
|
function assign_dynamic($tmp)
|
|
|
{
|
|
|
$sql = 'SELECT id, number, type FROM ' . $GLOBALS['ecs']->table('template') .
|
|
|
" WHERE filename = '$tmp' AND type > 0 AND remarks ='' AND theme='" . $GLOBALS['_CFG']['template'] . "'";
|
|
|
$res = $GLOBALS['db']->getAll($sql);
|
|
|
|
|
|
foreach ($res AS $row)
|
|
|
{
|
|
|
switch ($row['type'])
|
|
|
{
|
|
|
case 1:
|
|
|
/* 分類下的產品 */
|
|
|
$GLOBALS['smarty']->assign('goods_cat_' . $row['id'], assign_cat_goods($row['id'], $row['number']));
|
|
|
break;
|
|
|
case 2:
|
|
|
/* 品牌的產品 */
|
|
|
$brand_goods = assign_brand_goods($row['id'], $row['number']);
|
|
|
|
|
|
$GLOBALS['smarty']->assign('brand_goods_' . $row['id'], $brand_goods['goods']);
|
|
|
$GLOBALS['smarty']->assign('goods_brand_' . $row['id'], $brand_goods['brand']);
|
|
|
break;
|
|
|
case 3:
|
|
|
/* 文章列表 */
|
|
|
$cat_articles = assign_articles($row['id'], $row['number']);
|
|
|
|
|
|
$GLOBALS['smarty']->assign('articles_cat_' . $row['id'], $cat_articles['cat']);
|
|
|
$GLOBALS['smarty']->assign('articles_' . $row['id'], $cat_articles['arr']);
|
|
|
break;
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 分配文章列表給smarty
|
|
|
*
|
|
|
* @access public
|
|
|
* @param integer $id 文章分類的編號
|
|
|
* @param integer $num 文章數量
|
|
|
* @return array
|
|
|
*/
|
|
|
function assign_articles($id, $num)
|
|
|
{
|
|
|
$sql = 'SELECT cat_name FROM ' . $GLOBALS['ecs']->table('article_cat') . " WHERE cat_id = '" . $id ."'";
|
|
|
|
|
|
$cat['id'] = $id;
|
|
|
$cat['name'] = $GLOBALS['db']->getOne($sql);
|
|
|
$cat['url'] = build_uri('article_cat', array('acid' => $id), $cat['name']);
|
|
|
|
|
|
$articles['cat'] = $cat;
|
|
|
$articles['arr'] = get_cat_articles($id, 1, $num);
|
|
|
|
|
|
return $articles;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 分配幫助信息
|
|
|
*
|
|
|
* @access public
|
|
|
* @return array
|
|
|
*/
|
|
|
function get_shop_help()
|
|
|
{
|
|
|
$sql = 'SELECT c.cat_id, c.cat_name, c.sort_order, a.article_id, a.title, a.file_url, a.open_type ' .
|
|
|
'FROM ' .$GLOBALS['ecs']->table('article'). ' AS a ' .
|
|
|
'LEFT JOIN ' .$GLOBALS['ecs']->table('article_cat'). ' AS c ' .
|
|
|
'ON a.cat_id = c.cat_id WHERE c.cat_type = 5 AND a.is_open = 1 ' .
|
|
|
'ORDER BY c.sort_order ASC, a.article_id';
|
|
|
$res = $GLOBALS['db']->getAll($sql);
|
|
|
|
|
|
$arr = array();
|
|
|
foreach ($res AS $key => $row)
|
|
|
{
|
|
|
$arr[$row['cat_id']]['cat_id'] = build_uri('article_cat', array('acid'=> $row['cat_id']), $row['cat_name']);
|
|
|
$arr[$row['cat_id']]['cat_name'] = $row['cat_name'];
|
|
|
$arr[$row['cat_id']]['article'][$key]['article_id'] = $row['article_id'];
|
|
|
$arr[$row['cat_id']]['article'][$key]['title'] = $row['title'];
|
|
|
$arr[$row['cat_id']]['article'][$key]['short_title'] = $GLOBALS['_CFG']['article_title_length'] > 0 ?
|
|
|
sub_str($row['title'], $GLOBALS['_CFG']['article_title_length']) : $row['title'];
|
|
|
$arr[$row['cat_id']]['article'][$key]['url'] = $row['open_type'] != 1 ?
|
|
|
build_uri('article', array('aid' => $row['article_id']), $row['title']) : trim($row['file_url']);
|
|
|
}
|
|
|
|
|
|
return $arr;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 創建分頁信息
|
|
|
*
|
|
|
* @access public
|
|
|
* @param string $app 程序名稱，如category
|
|
|
* @param string $cat 分類ID
|
|
|
* @param string $record_count 記錄總數
|
|
|
* @param string $size 每頁記錄數
|
|
|
* @param string $sort 排序類型
|
|
|
* @param string $order 排序順序
|
|
|
* @param string $page 當前頁
|
|
|
* @param string $keywords 查詢關鍵字
|
|
|
* @param string $brand 品牌
|
|
|
* @param string $price_min 最小价格
|
|
|
* @param string $price_max 最高價格
|
|
|
* @return void
|
|
|
*/
|
|
|
function assign_pager($app, $cat, $record_count, $size, $sort, $order, $page = 1,
|
|
|
$keywords = '', $brand = 0, $price_min = 0, $price_max = 0, $display_type = 'list', $filter_attr='', $url_format='', $sch_array='')
|
|
|
{
|
|
|
$sch = array('keywords' => $keywords,
|
|
|
'sort' => $sort,
|
|
|
'order' => $order,
|
|
|
'cat' => $cat,
|
|
|
'brand' => $brand,
|
|
|
'price_min' => $price_min,
|
|
|
'price_max' => $price_max,
|
|
|
'filter_attr'=>$filter_attr,
|
|
|
'display' => $display_type
|
|
|
);
|
|
|
|
|
|
$page = intval($page);
|
|
|
if ($page < 1)
|
|
|
{
|
|
|
$page = 1;
|
|
|
}
|
|
|
|
|
|
$page_count = $record_count > 0 ? intval(ceil($record_count / $size)) : 1;
|
|
|
|
|
|
$pager['page'] = $page;
|
|
|
$pager['size'] = $size;
|
|
|
$pager['sort'] = $sort;
|
|
|
$pager['order'] = $order;
|
|
|
$pager['record_count'] = $record_count;
|
|
|
$pager['page_count'] = $page_count;
|
|
|
$pager['display'] = $display_type;
|
|
|
|
|
|
switch ($app)
|
|
|
{
|
|
|
case 'category':
|
|
|
$uri_args = array('cid' => $cat, 'bid' => $brand, 'price_min'=>$price_min, 'price_max'=>$price_max, 'filter_attr'=>$filter_attr, 'sort' => $sort, 'order' => $order, 'display' => $display_type);
|
|
|
break;
|
|
|
case 'article_cat':
|
|
|
$uri_args = array('acid' => $cat, 'sort' => $sort, 'order' => $order);
|
|
|
break;
|
|
|
case 'brand':
|
|
|
$uri_args = array('cid' => $cat, 'bid' => $brand, 'sort' => $sort, 'order' => $order, 'display' => $display_type);
|
|
|
break;
|
|
|
case 'search':
|
|
|
$uri_args = array('cid' => $cat, 'bid' => $brand, 'sort' => $sort, 'order' => $order);
|
|
|
break;
|
|
|
case 'exchange':
|
|
|
$uri_args = array('cid' => $cat, 'integral_min'=>$price_min, 'integral_max'=>$price_max, 'sort' => $sort, 'order' => $order, 'display' => $display_type);
|
|
|
break;
|
|
|
}
|
|
|
/* 分頁樣式 */
|
|
|
$pager['styleid'] = isset($GLOBALS['_CFG']['page_style'])? intval($GLOBALS['_CFG']['page_style']) : 0;
|
|
|
|
|
|
$page_prev = ($page > 1) ? $page - 1 : 1;
|
|
|
$page_next = ($page < $page_count) ? $page + 1 : $page_count;
|
|
|
if ($pager['styleid'] == 0)
|
|
|
{
|
|
|
if (!empty($url_format))
|
|
|
{
|
|
|
$pager['page_first'] = $url_format . 1;
|
|
|
$pager['page_prev'] = $url_format . $page_prev;
|
|
|
$pager['page_next'] = $url_format . $page_next;
|
|
|
$pager['page_last'] = $url_format . $page_count;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$pager['page_first'] = build_uri($app, $uri_args, '', 1, $keywords);
|
|
|
$pager['page_prev'] = build_uri($app, $uri_args, '', $page_prev, $keywords);
|
|
|
$pager['page_next'] = build_uri($app, $uri_args, '', $page_next, $keywords);
|
|
|
$pager['page_last'] = build_uri($app, $uri_args, '', $page_count, $keywords);
|
|
|
}
|
|
|
$pager['array'] = array();
|
|
|
|
|
|
for ($i = 1; $i <= $page_count; $i++)
|
|
|
{
|
|
|
$pager['array'][$i] = $i;
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$_pagenum = 10; // 顯示的頁碼
|
|
|
$_offset = 2; // 當前頁偏移值
|
|
|
$_from = $_to = 0; // 開始頁, 結束頁
|
|
|
if($_pagenum > $page_count)
|
|
|
{
|
|
|
$_from = 1;
|
|
|
$_to = $page_count;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$_from = $page - $_offset;
|
|
|
$_to = $_from + $_pagenum - 1;
|
|
|
if($_from < 1)
|
|
|
{
|
|
|
$_to = $page + 1 - $_from;
|
|
|
$_from = 1;
|
|
|
if($_to - $_from < $_pagenum)
|
|
|
{
|
|
|
$_to = $_pagenum;
|
|
|
}
|
|
|
}
|
|
|
elseif($_to > $page_count)
|
|
|
{
|
|
|
$_from = $page_count - $_pagenum + 1;
|
|
|
$_to = $page_count;
|
|
|
}
|
|
|
}
|
|
|
if (!empty($url_format))
|
|
|
{
|
|
|
$pager['page_first'] = ($page - $_offset > 1 && $_pagenum < $page_count) ? $url_format . 1 : '';
|
|
|
$pager['page_prev'] = ($page > 1) ? $url_format . $page_prev : '';
|
|
|
$pager['page_next'] = ($page < $page_count) ? $url_format . $page_next : '';
|
|
|
$pager['page_last'] = ($_to < $page_count) ? $url_format . $page_count : '';
|
|
|
$pager['page_kbd'] = ($_pagenum < $page_count) ? true : false;
|
|
|
$pager['page_number'] = array();
|
|
|
for ($i=$_from;$i<=$_to;++$i)
|
|
|
{
|
|
|
$pager['page_number'][$i] = $url_format . $i;
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$pager['page_first'] = ($page - $_offset > 1 && $_pagenum < $page_count) ? build_uri($app, $uri_args, '', 1, $keywords) : '';
|
|
|
$pager['page_prev'] = ($page > 1) ? build_uri($app, $uri_args, '', $page_prev, $keywords) : '';
|
|
|
$pager['page_next'] = ($page < $page_count) ? build_uri($app, $uri_args, '', $page_next, $keywords) : '';
|
|
|
$pager['page_last'] = ($_to < $page_count) ? build_uri($app, $uri_args, '', $page_count, $keywords) : '';
|
|
|
$pager['page_kbd'] = ($_pagenum < $page_count) ? true : false;
|
|
|
$pager['page_number'] = array();
|
|
|
for ($i=$_from;$i<=$_to;++$i)
|
|
|
{
|
|
|
$pager['page_number'][$i] = build_uri($app, $uri_args, '', $i, $keywords);
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
if (!empty($sch_array))
|
|
|
{
|
|
|
$pager['search'] = $sch_array;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$pager['search']['category'] = $cat;
|
|
|
foreach ($sch AS $key => $row)
|
|
|
{
|
|
|
$pager['search'][$key] = $row;
|
|
|
}
|
|
|
}
|
|
|
$GLOBALS['smarty']->assign('pager', $pager);
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 生成給pager.lbi賦值的數組
|
|
|
*
|
|
|
* @access public
|
|
|
* @param string $url 分頁的鏈接地址(必須是帶有參數的地址，若不是可以偽造一個無用參數)
|
|
|
* @param array $param 鏈接參數 key為參數名，value為參數值
|
|
|
* @param int $record 記錄總數量
|
|
|
* @param int $page 當前頁數
|
|
|
* @param int $size 每頁大小
|
|
|
*
|
|
|
* @return array $pager
|
|
|
*/
|
|
|
function get_pager($url, $param, $record_count, $page = 1, $size = 10)
|
|
|
{
|
|
|
$size = intval($size);
|
|
|
if ($size < 1)
|
|
|
{
|
|
|
$size = 10;
|
|
|
}
|
|
|
|
|
|
$page = intval($page);
|
|
|
if ($page < 1)
|
|
|
{
|
|
|
$page = 1;
|
|
|
}
|
|
|
|
|
|
$record_count = intval($record_count);
|
|
|
|
|
|
$page_count = $record_count > 0 ? intval(ceil($record_count / $size)) : 1;
|
|
|
if ($page > $page_count)
|
|
|
{
|
|
|
$page = $page_count;
|
|
|
}
|
|
|
/* 分頁樣式 */
|
|
|
$pager['styleid'] = isset($GLOBALS['_CFG']['page_style'])? intval($GLOBALS['_CFG']['page_style']) : 0;
|
|
|
|
|
|
$page_prev = ($page > 1) ? $page - 1 : 1;
|
|
|
$page_next = ($page < $page_count) ? $page + 1 : $page_count;
|
|
|
|
|
|
/* 將參數合成url字串 */
|
|
|
$param_url = '?';
|
|
|
foreach ($param AS $key => $value)
|
|
|
{
|
|
|
$param_url .= $key . '=' . $value . '&';
|
|
|
}
|
|
|
|
|
|
$pager['url'] = $url;
|
|
|
$pager['start'] = ($page -1) * $size;
|
|
|
$pager['page'] = $page;
|
|
|
$pager['size'] = $size;
|
|
|
$pager['record_count'] = $record_count;
|
|
|
$pager['page_count'] = $page_count;
|
|
|
|
|
|
if ($pager['styleid'] == 0)
|
|
|
{
|
|
|
$pager['page_first'] = $url . $param_url . 'page=1';
|
|
|
$pager['page_prev'] = $url . $param_url . 'page=' . $page_prev;
|
|
|
$pager['page_next'] = $url . $param_url . 'page=' . $page_next;
|
|
|
$pager['page_last'] = $url . $param_url . 'page=' . $page_count;
|
|
|
$pager['array'] = array();
|
|
|
for ($i = 1; $i <= $page_count; $i++)
|
|
|
{
|
|
|
$pager['array'][$i] = $i;
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$_pagenum = 10; // 顯示的頁碼
|
|
|
$_offset = 2; // 當前頁偏移值
|
|
|
$_from = $_to = 0; // 開始頁, 結束頁
|
|
|
if($_pagenum > $page_count)
|
|
|
{
|
|
|
$_from = 1;
|
|
|
$_to = $page_count;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$_from = $page - $_offset;
|
|
|
$_to = $_from + $_pagenum - 1;
|
|
|
if($_from < 1)
|
|
|
{
|
|
|
$_to = $page + 1 - $_from;
|
|
|
$_from = 1;
|
|
|
if($_to - $_from < $_pagenum)
|
|
|
{
|
|
|
$_to = $_pagenum;
|
|
|
}
|
|
|
}
|
|
|
elseif($_to > $page_count)
|
|
|
{
|
|
|
$_from = $page_count - $_pagenum + 1;
|
|
|
$_to = $page_count;
|
|
|
}
|
|
|
}
|
|
|
$url_format = $url . $param_url . 'page=';
|
|
|
$pager['page_first'] = ($page - $_offset > 1 && $_pagenum < $page_count) ? $url_format . 1 : '';
|
|
|
$pager['page_prev'] = ($page > 1) ? $url_format . $page_prev : '';
|
|
|
$pager['page_next'] = ($page < $page_count) ? $url_format . $page_next : '';
|
|
|
$pager['page_last'] = ($_to < $page_count) ? $url_format . $page_count : '';
|
|
|
$pager['page_kbd'] = ($_pagenum < $page_count) ? true : false;
|
|
|
$pager['page_number'] = array();
|
|
|
for ($i=$_from;$i<=$_to;++$i)
|
|
|
{
|
|
|
$pager['page_number'][$i] = $url_format . $i;
|
|
|
}
|
|
|
}
|
|
|
$pager['search'] = $param;
|
|
|
|
|
|
return $pager;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 調用調查內容
|
|
|
*
|
|
|
* @access public
|
|
|
* @param integer $id 調查的編號
|
|
|
* @return array
|
|
|
*/
|
|
|
function get_vote($id = '')
|
|
|
{
|
|
|
/* 隨機取得一個調查的主題 */
|
|
|
if (empty($id))
|
|
|
{
|
|
|
$time = gmtime();
|
|
|
$sql = 'SELECT vote_id, vote_name, can_multi, vote_count, RAND() AS rnd' .
|
|
|
' FROM ' . $GLOBALS['ecs']->table('vote') .
|
|
|
" WHERE start_time <= '$time' AND end_time >= '$time' ".
|
|
|
' ORDER BY rnd LIMIT 1';
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$sql = 'SELECT vote_id, vote_name, can_multi, vote_count' .
|
|
|
' FROM ' . $GLOBALS['ecs']->table('vote').
|
|
|
" WHERE vote_id = '$id'";
|
|
|
}
|
|
|
|
|
|
$vote_arr = $GLOBALS['db']->getRow($sql);
|
|
|
|
|
|
if ($vote_arr !== false && !empty($vote_arr))
|
|
|
{
|
|
|
/* 通過調查的ID,查詢調查選項 */
|
|
|
$sql_option = 'SELECT v.*, o.option_id, o.vote_id, o.option_name, o.option_count ' .
|
|
|
'FROM ' . $GLOBALS['ecs']->table('vote') . ' AS v, ' .
|
|
|
$GLOBALS['ecs']->table('vote_option') . ' AS o ' .
|
|
|
"WHERE o.vote_id = v.vote_id AND o.vote_id = '$vote_arr[vote_id]' ORDER BY o.option_order ASC, o.option_id DESC";
|
|
|
$res = $GLOBALS['db']->getAll($sql_option);
|
|
|
|
|
|
/* 總票數 */
|
|
|
$sql = 'SELECT SUM(option_count) AS all_option FROM ' . $GLOBALS['ecs']->table('vote_option') .
|
|
|
" WHERE vote_id = '" . $vote_arr['vote_id'] . "' GROUP BY vote_id";
|
|
|
$option_num = $GLOBALS['db']->getOne($sql);
|
|
|
|
|
|
$arr = array();
|
|
|
$count = 100;
|
|
|
foreach ($res AS $idx => $row)
|
|
|
{
|
|
|
if ($option_num > 0 && $idx == count($res) - 1)
|
|
|
{
|
|
|
$percent = $count;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$percent = ($row['vote_count'] > 0 && $option_num > 0) ? round(($row['option_count'] / $option_num) * 100) : 0;
|
|
|
|
|
|
$count -= $percent;
|
|
|
}
|
|
|
$arr[$row['vote_id']]['options'][$row['option_id']]['percent'] = $percent;
|
|
|
|
|
|
$arr[$row['vote_id']]['vote_id'] = $row['vote_id'];
|
|
|
$arr[$row['vote_id']]['vote_name'] = $row['vote_name'];
|
|
|
$arr[$row['vote_id']]['can_multi'] = $row['can_multi'];
|
|
|
$arr[$row['vote_id']]['vote_count'] = $row['vote_count'];
|
|
|
|
|
|
$arr[$row['vote_id']]['options'][$row['option_id']]['option_id'] = $row['option_id'];
|
|
|
$arr[$row['vote_id']]['options'][$row['option_id']]['option_name'] = $row['option_name'];
|
|
|
$arr[$row['vote_id']]['options'][$row['option_id']]['option_count'] = $row['option_count'];
|
|
|
}
|
|
|
|
|
|
$vote_arr['vote_id'] = (!empty($vote_arr['vote_id'])) ? $vote_arr['vote_id'] : '';
|
|
|
|
|
|
$vote = array('id' => $vote_arr['vote_id'], 'content' => $arr);
|
|
|
|
|
|
return $vote;
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 獲得瀏覽器名稱和版本
|
|
|
*
|
|
|
* @access public
|
|
|
* @return string
|
|
|
*/
|
|
|
function get_user_browser()
|
|
|
{
|
|
|
if (empty($_SERVER['HTTP_USER_AGENT']))
|
|
|
{
|
|
|
return '';
|
|
|
}
|
|
|
|
|
|
$agent = $_SERVER['HTTP_USER_AGENT'];
|
|
|
$browser = '';
|
|
|
$browser_ver = '';
|
|
|
|
|
|
if (preg_match('/MSIE\s([^\s|;]+)/i', $agent, $regs))
|
|
|
{
|
|
|
$browser = 'Internet Explorer';
|
|
|
$browser_ver = $regs[1];
|
|
|
}
|
|
|
elseif (preg_match('/FireFox\/([^\s]+)/i', $agent, $regs))
|
|
|
{
|
|
|
$browser = 'FireFox';
|
|
|
$browser_ver = $regs[1];
|
|
|
}
|
|
|
elseif (preg_match('/Maxthon/i', $agent, $regs))
|
|
|
{
|
|
|
$browser = '(Internet Explorer ' .$browser_ver. ') Maxthon';
|
|
|
$browser_ver = '';
|
|
|
}
|
|
|
elseif (preg_match('/Opera[\s|\/]([^\s]+)/i', $agent, $regs))
|
|
|
{
|
|
|
$browser = 'Opera';
|
|
|
$browser_ver = $regs[1];
|
|
|
}
|
|
|
elseif (preg_match('/OmniWeb\/(v*)([^\s|;]+)/i', $agent, $regs))
|
|
|
{
|
|
|
$browser = 'OmniWeb';
|
|
|
$browser_ver = $regs[2];
|
|
|
}
|
|
|
elseif (preg_match('/Netscape([\d]*)\/([^\s]+)/i', $agent, $regs))
|
|
|
{
|
|
|
$browser = 'Netscape';
|
|
|
$browser_ver = $regs[2];
|
|
|
}
|
|
|
elseif (preg_match('/safari\/([^\s]+)/i', $agent, $regs))
|
|
|
{
|
|
|
$browser = 'Safari';
|
|
|
$browser_ver = $regs[1];
|
|
|
}
|
|
|
elseif (preg_match('/NetCaptor\s([^\s|;]+)/i', $agent, $regs))
|
|
|
{
|
|
|
$browser = '(Internet Explorer ' .$browser_ver. ') NetCaptor';
|
|
|
$browser_ver = $regs[1];
|
|
|
}
|
|
|
elseif (preg_match('/Lynx\/([^\s]+)/i', $agent, $regs))
|
|
|
{
|
|
|
$browser = 'Lynx';
|
|
|
$browser_ver = $regs[1];
|
|
|
}
|
|
|
|
|
|
if (!empty($browser))
|
|
|
{
|
|
|
return addslashes($browser . ' ' . $browser_ver);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
return 'Unknow browser';
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 判斷是否為搜索引擎蜘蛛
|
|
|
*
|
|
|
* @access public
|
|
|
* @return string
|
|
|
*/
|
|
|
function is_spider($record = true)
|
|
|
{
|
|
|
static $spider = NULL;
|
|
|
|
|
|
if ($spider !== NULL)
|
|
|
{
|
|
|
return $spider;
|
|
|
}
|
|
|
|
|
|
if (empty($_SERVER['HTTP_USER_AGENT']))
|
|
|
{
|
|
|
$spider = '';
|
|
|
|
|
|
return '';
|
|
|
}
|
|
|
|
|
|
$searchengine_bot = array(
|
|
|
'googlebot',
|
|
|
'mediapartners-google',
|
|
|
'baiduspider+',
|
|
|
'yodaobot',
|
|
|
'yahoo! slurp;',
|
|
|
'yahoo! slurp china;',
|
|
|
'iaskspider',
|
|
|
'sogou web spider',
|
|
|
'sogou push spider'
|
|
|
);
|
|
|
|
|
|
$searchengine_name = array(
|
|
|
'GOOGLE',
|
|
|
'GOOGLE ADSENSE',
|
|
|
'BAIDU',
|
|
|
'YODAO',
|
|
|
'YAHOO',
|
|
|
'Yahoo China',
|
|
|
'IASK',
|
|
|
'SOGOU',
|
|
|
'SOGOU'
|
|
|
);
|
|
|
|
|
|
$spider = strtolower($_SERVER['HTTP_USER_AGENT']);
|
|
|
|
|
|
foreach ($searchengine_bot AS $key => $value)
|
|
|
{
|
|
|
if (strpos($spider, $value) !== false)
|
|
|
{
|
|
|
$spider = $searchengine_name[$key];
|
|
|
|
|
|
if ($record === true)
|
|
|
{
|
|
|
$GLOBALS['db']->autoReplace($GLOBALS['ecs']->table('searchengine'), array('date' => local_date('Y-m-d'), 'searchengine' => $spider, 'count' => 1), array('count' => 1));
|
|
|
}
|
|
|
|
|
|
return $spider;
|
|
|
}
|
|
|
}
|
|
|
|
|
|
$spider = '';
|
|
|
|
|
|
return '';
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 獲得客户端的操作系統
|
|
|
*
|
|
|
* @access private
|
|
|
* @return void
|
|
|
*/
|
|
|
function get_os()
|
|
|
{
|
|
|
if (empty($_SERVER['HTTP_USER_AGENT']))
|
|
|
{
|
|
|
return 'Unknown';
|
|
|
}
|
|
|
|
|
|
$agent = strtolower($_SERVER['HTTP_USER_AGENT']);
|
|
|
$os = '';
|
|
|
|
|
|
if (strpos($agent, 'win') !== false)
|
|
|
{
|
|
|
if (strpos($agent, 'nt 5.1') !== false)
|
|
|
{
|
|
|
$os = 'Windows XP';
|
|
|
}
|
|
|
elseif (strpos($agent, 'nt 5.2') !== false)
|
|
|
{
|
|
|
$os = 'Windows 2003';
|
|
|
}
|
|
|
elseif (strpos($agent, 'nt 5.0') !== false)
|
|
|
{
|
|
|
$os = 'Windows 2000';
|
|
|
}
|
|
|
elseif (strpos($agent, 'nt 6.0') !== false)
|
|
|
{
|
|
|
$os = 'Windows Vista';
|
|
|
}
|
|
|
elseif (strpos($agent, 'nt') !== false)
|
|
|
{
|
|
|
$os = 'Windows NT';
|
|
|
}
|
|
|
elseif (strpos($agent, 'win 9x') !== false && strpos($agent, '4.90') !== false)
|
|
|
{
|
|
|
$os = 'Windows ME';
|
|
|
}
|
|
|
elseif (strpos($agent, '98') !== false)
|
|
|
{
|
|
|
$os = 'Windows 98';
|
|
|
}
|
|
|
elseif (strpos($agent, '95') !== false)
|
|
|
{
|
|
|
$os = 'Windows 95';
|
|
|
}
|
|
|
elseif (strpos($agent, '32') !== false)
|
|
|
{
|
|
|
$os = 'Windows 32';
|
|
|
}
|
|
|
elseif (strpos($agent, 'ce') !== false)
|
|
|
{
|
|
|
$os = 'Windows CE';
|
|
|
}
|
|
|
}
|
|
|
elseif (strpos($agent, 'linux') !== false)
|
|
|
{
|
|
|
$os = 'Linux';
|
|
|
}
|
|
|
elseif (strpos($agent, 'unix') !== false)
|
|
|
{
|
|
|
$os = 'Unix';
|
|
|
}
|
|
|
elseif (strpos($agent, 'sun') !== false && strpos($agent, 'os') !== false)
|
|
|
{
|
|
|
$os = 'SunOS';
|
|
|
}
|
|
|
elseif (strpos($agent, 'ibm') !== false && strpos($agent, 'os') !== false)
|
|
|
{
|
|
|
$os = 'IBM OS/2';
|
|
|
}
|
|
|
elseif (strpos($agent, 'mac') !== false && strpos($agent, 'pc') !== false)
|
|
|
{
|
|
|
$os = 'Macintosh';
|
|
|
}
|
|
|
elseif (strpos($agent, 'powerpc') !== false)
|
|
|
{
|
|
|
$os = 'PowerPC';
|
|
|
}
|
|
|
elseif (strpos($agent, 'aix') !== false)
|
|
|
{
|
|
|
$os = 'AIX';
|
|
|
}
|
|
|
elseif (strpos($agent, 'hpux') !== false)
|
|
|
{
|
|
|
$os = 'HPUX';
|
|
|
}
|
|
|
elseif (strpos($agent, 'netbsd') !== false)
|
|
|
{
|
|
|
$os = 'NetBSD';
|
|
|
}
|
|
|
elseif (strpos($agent, 'bsd') !== false)
|
|
|
{
|
|
|
$os = 'BSD';
|
|
|
}
|
|
|
elseif (strpos($agent, 'osf1') !== false)
|
|
|
{
|
|
|
$os = 'OSF1';
|
|
|
}
|
|
|
elseif (strpos($agent, 'irix') !== false)
|
|
|
{
|
|
|
$os = 'IRIX';
|
|
|
}
|
|
|
elseif (strpos($agent, 'freebsd') !== false)
|
|
|
{
|
|
|
$os = 'FreeBSD';
|
|
|
}
|
|
|
elseif (strpos($agent, 'teleport') !== false)
|
|
|
{
|
|
|
$os = 'teleport';
|
|
|
}
|
|
|
elseif (strpos($agent, 'flashget') !== false)
|
|
|
{
|
|
|
$os = 'flashget';
|
|
|
}
|
|
|
elseif (strpos($agent, 'webzip') !== false)
|
|
|
{
|
|
|
$os = 'webzip';
|
|
|
}
|
|
|
elseif (strpos($agent, 'offline') !== false)
|
|
|
{
|
|
|
$os = 'offline';
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$os = 'Unknown';
|
|
|
}
|
|
|
|
|
|
return $os;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 統計訪問信息
|
|
|
*
|
|
|
* @access public
|
|
|
* @return void
|
|
|
*/
|
|
|
function visit_stats()
|
|
|
{
|
|
|
if (isset($GLOBALS['_CFG']['visit_stats']) && $GLOBALS['_CFG']['visit_stats'] == 'off')
|
|
|
{
|
|
|
return;
|
|
|
}
|
|
|
$time = gmtime();
|
|
|
/* 檢查客户端是否存在訪問統計的cookie */
|
|
|
$visit_times = (!empty($_COOKIE['ECS']['visit_times'])) ? intval($_COOKIE['ECS']['visit_times']) + 1 : 1;
|
|
|
setcookie('ECS[visit_times]', $visit_times, $time + 86400 * 365, '/');
|
|
|
|
|
|
$browser = get_user_browser();
|
|
|
$os = get_os();
|
|
|
$ip = real_ip();
|
|
|
$area = ecs_geoip($ip);
|
|
|
|
|
|
/* 語言 */
|
|
|
if (!empty($_SERVER['HTTP_ACCEPT_LANGUAGE']))
|
|
|
{
|
|
|
$pos = strpos($_SERVER['HTTP_ACCEPT_LANGUAGE'], ';');
|
|
|
$lang = addslashes(($pos !== false) ? substr($_SERVER['HTTP_ACCEPT_LANGUAGE'], 0, $pos) : $_SERVER['HTTP_ACCEPT_LANGUAGE']);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$lang = '';
|
|
|
}
|
|
|
|
|
|
/* 來源 */
|
|
|
if (!empty($_SERVER['HTTP_REFERER']) && strlen($_SERVER['HTTP_REFERER']) > 9)
|
|
|
{
|
|
|
$pos = strpos($_SERVER['HTTP_REFERER'], '/', 9);
|
|
|
if ($pos !== false)
|
|
|
{
|
|
|
$domain = substr($_SERVER['HTTP_REFERER'], 0, $pos);
|
|
|
$path = substr($_SERVER['HTTP_REFERER'], $pos);
|
|
|
|
|
|
/* 來源關鍵字 */
|
|
|
if (!empty($domain) && !empty($path))
|
|
|
{
|
|
|
save_searchengine_keyword($domain, $path);
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$domain = $path = '';
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$domain = $path = '';
|
|
|
}
|
|
|
|
|
|
$sql = 'INSERT INTO ' . $GLOBALS['ecs']->table('stats') . ' ( ' .
|
|
|
'ip_address, visit_times, browser, os, language, area, ' .
|
|
|
'referer_domain, referer_path, access_url, access_time' .
|
|
|
') VALUES (' .
|
|
|
"'$ip', '$visit_times', '$browser', '$os', '$lang', '$area', ".
|
|
|
"'" . addslashes($domain) ."', '" . addslashes($path) ."', '" . htmlspecialchars(addslashes(PHP_SELF)) ."', '" . $time . "')";
|
|
|
$GLOBALS['db']->query($sql);
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 保存搜索引擎關鍵字
|
|
|
*
|
|
|
* @access public
|
|
|
* @return void
|
|
|
*/
|
|
|
function save_searchengine_keyword($domain, $path)
|
|
|
{
|
|
|
if (strpos($domain, 'google.com.tw') !== false && preg_match('/q=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'GOOGLE TAIWAN';
|
|
|
$keywords = urldecode($regs[1]); // google taiwan
|
|
|
}
|
|
|
if (strpos($domain, 'google.cn') !== false && preg_match('/q=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'GOOGLE CHINA';
|
|
|
$keywords = urldecode($regs[1]); // google china
|
|
|
}
|
|
|
if (strpos($domain, 'google.com') !== false && preg_match('/q=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'GOOGLE';
|
|
|
$keywords = urldecode($regs[1]); // google
|
|
|
}
|
|
|
elseif (strpos($domain, 'baidu.') !== false && preg_match('/wd=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'BAIDU';
|
|
|
$keywords = urldecode($regs[1]); // baidu
|
|
|
}
|
|
|
elseif (strpos($domain, 'baidu.') !== false && preg_match('/word=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'BAIDU';
|
|
|
$keywords = urldecode($regs[1]); // baidu
|
|
|
}
|
|
|
elseif (strpos($domain, '114.vnet.cn') !== false && preg_match('/kw=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'CT114';
|
|
|
$keywords = urldecode($regs[1]); // ct114
|
|
|
}
|
|
|
elseif (strpos($domain, 'iask.com') !== false && preg_match('/k=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'IASK';
|
|
|
$keywords = urldecode($regs[1]); // iask
|
|
|
}
|
|
|
elseif (strpos($domain, 'soso.com') !== false && preg_match('/w=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'SOSO';
|
|
|
$keywords = urldecode($regs[1]); // soso
|
|
|
}
|
|
|
elseif (strpos($domain, 'sogou.com') !== false && preg_match('/query=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'SOGOU';
|
|
|
$keywords = urldecode($regs[1]); // sogou
|
|
|
}
|
|
|
elseif (strpos($domain, 'so.163.com') !== false && preg_match('/q=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'NETEASE';
|
|
|
$keywords = urldecode($regs[1]); // netease
|
|
|
}
|
|
|
elseif (strpos($domain, 'yodao.com') !== false && preg_match('/q=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'YODAO';
|
|
|
$keywords = urldecode($regs[1]); // yodao
|
|
|
}
|
|
|
elseif (strpos($domain, 'zhongsou.com') !== false && preg_match('/word=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'ZHONGSOU';
|
|
|
$keywords = urldecode($regs[1]); // zhongsou
|
|
|
}
|
|
|
elseif (strpos($domain, 'search.tom.com') !== false && preg_match('/w=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'TOM';
|
|
|
$keywords = urldecode($regs[1]); // tom
|
|
|
}
|
|
|
elseif (strpos($domain, 'live.com') !== false && preg_match('/q=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'MSLIVE';
|
|
|
$keywords = urldecode($regs[1]); // MSLIVE
|
|
|
}
|
|
|
elseif (strpos($domain, 'tw.search.yahoo.com') !== false && preg_match('/p=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'YAHOO TAIWAN';
|
|
|
$keywords = urldecode($regs[1]); // yahoo taiwan
|
|
|
}
|
|
|
elseif (strpos($domain, 'cn.yahoo.') !== false && preg_match('/p=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'YAHOO CHINA';
|
|
|
$keywords = urldecode($regs[1]); // yahoo china
|
|
|
}
|
|
|
elseif (strpos($domain, 'yahoo.') !== false && preg_match('/p=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'YAHOO';
|
|
|
$keywords = urldecode($regs[1]); // yahoo
|
|
|
}
|
|
|
elseif (strpos($domain, 'msn.com.tw') !== false && preg_match('/q=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'MSN TAIWAN';
|
|
|
$keywords = urldecode($regs[1]); // msn taiwan
|
|
|
}
|
|
|
elseif (strpos($domain, 'msn.com.cn') !== false && preg_match('/q=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'MSN CHINA';
|
|
|
$keywords = urldecode($regs[1]); // msn china
|
|
|
}
|
|
|
elseif (strpos($domain, 'msn.com') !== false && preg_match('/q=([^&]*)/i', $path, $regs))
|
|
|
{
|
|
|
$searchengine = 'MSN';
|
|
|
$keywords = urldecode($regs[1]); // msn
|
|
|
}
|
|
|
|
|
|
if (!empty($keywords))
|
|
|
{
|
|
|
$gb_search = array('YAHOO CHINA', 'TOM', 'ZHONGSOU', 'NETEASE', 'SOGOU', 'SOSO', 'IASK', 'CT114', 'BAIDU');
|
|
|
if (EC_CHARSET == 'utf-8' && in_array($searchengine, $gb_search))
|
|
|
{
|
|
|
$keywords = ecs_iconv('GBK', 'UTF8', $keywords);
|
|
|
}
|
|
|
if (EC_CHARSET == 'gbk' && !in_array($searchengine, $gb_search))
|
|
|
{
|
|
|
$keywords = ecs_iconv('UTF8', 'GBK', $keywords);
|
|
|
}
|
|
|
|
|
|
$GLOBALS['db']->autoReplace($GLOBALS['ecs']->table('keywords'), array('date' => local_date('Y-m-d'), 'searchengine' => $searchengine, 'keyword' => htmlspecialchars(addslashes($keywords)), 'count' => 1), array('count' => 1));
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 獲得指定用户、產品的所有標記
|
|
|
*
|
|
|
* @access public
|
|
|
* @param integer $goods_id
|
|
|
* @param integer $user_id
|
|
|
* @return array
|
|
|
*/
|
|
|
function get_tags($goods_id = 0, $user_id = 0)
|
|
|
{
|
|
|
$where = '';
|
|
|
if ($goods_id > 0)
|
|
|
{
|
|
|
$where .= " goods_id = '$goods_id'";
|
|
|
}
|
|
|
|
|
|
if ($user_id > 0)
|
|
|
{
|
|
|
if ($goods_id > 0)
|
|
|
{
|
|
|
$where .= " AND";
|
|
|
}
|
|
|
$where .= " user_id = '$user_id'";
|
|
|
}
|
|
|
|
|
|
if ($where > '')
|
|
|
{
|
|
|
$where = ' WHERE' . $where;
|
|
|
}
|
|
|
|
|
|
$sql = 'SELECT tag_id, user_id, tag_words, COUNT(tag_id) AS tag_count' .
|
|
|
' FROM ' . $GLOBALS['ecs']->table('tag') .
|
|
|
"$where GROUP BY tag_words";
|
|
|
$arr = $GLOBALS['db']->getAll($sql);
|
|
|
|
|
|
return $arr;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 獲取指定主題某個模板的主題的動態模塊
|
|
|
*
|
|
|
* @access public
|
|
|
* @param string $theme 模板主題
|
|
|
* @param string $tmp 模板名稱
|
|
|
*
|
|
|
* @return array()
|
|
|
*/
|
|
|
function get_dyna_libs($theme, $tmp)
|
|
|
{
|
|
|
$tmp_arr = explode('.', $tmp);
|
|
|
$ext = end($tmp_arr);
|
|
|
$tmp = basename($tmp,".$ext");
|
|
|
$sql = 'SELECT region, library, sort_order, id, number, type' .
|
|
|
' FROM ' . $GLOBALS['ecs']->table('template') .
|
|
|
" WHERE theme = '$theme' AND filename = '" . $tmp . "' AND type > 0 AND remarks=''".
|
|
|
' ORDER BY region, library, sort_order';
|
|
|
$res = $GLOBALS['db']->getAll($sql);
|
|
|
|
|
|
$dyna_libs = array();
|
|
|
foreach ($res AS $row)
|
|
|
{
|
|
|
$dyna_libs[$row['region']][$row['library']][] = array(
|
|
|
'id' => $row['id'],
|
|
|
'number' => $row['number'],
|
|
|
'type' => $row['type']
|
|
|
);
|
|
|
}
|
|
|
|
|
|
return $dyna_libs;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 替換動態模塊
|
|
|
*
|
|
|
* @access public
|
|
|
* @param string $matches 匹配內容
|
|
|
*
|
|
|
* @return string 結果
|
|
|
*/
|
|
|
function dyna_libs_replace($matches)
|
|
|
{
|
|
|
$key = '/' . $matches[1];
|
|
|
|
|
|
if ($row = array_shift($GLOBALS['libs'][$key]))
|
|
|
{
|
|
|
$str = '';
|
|
|
switch($row['type'])
|
|
|
{
|
|
|
case 1:
|
|
|
// 分類的產品
|
|
|
$str = '{assign var="cat_goods" value=$cat_goods_' .$row['id']. '}{assign var="goods_cat" value=$goods_cat_' .$row['id']. '}';
|
|
|
break;
|
|
|
case 2:
|
|
|
// 品牌的產品
|
|
|
$str = '{assign var="brand_goods" value=$brand_goods_' .$row['id']. '}{assign var="goods_brand" value=$goods_brand_' .$row['id']. '}';
|
|
|
break;
|
|
|
case 3:
|
|
|
// 文章列表
|
|
|
$str = '{assign var="articles" value=$articles_' .$row['id']. '}{assign var="articles_cat" value=$articles_cat_' .$row['id']. '}';
|
|
|
break;
|
|
|
case 4:
|
|
|
//廣告位
|
|
|
$str = '{assign var="ads_id" value=' . $row['id'] . '}{assign var="ads_num" value=' . $row['number'] . '}';
|
|
|
break;
|
|
|
}
|
|
|
return $str . $matches[0];
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
return $matches[0];
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 處理上傳文件，並返回上傳圖片名(上傳失敗時返回圖片名為空）
|
|
|
*
|
|
|
* @access public
|
|
|
* @param array $upload $_FILES 數組
|
|
|
* @param array $type 圖片所屬類別，即data目錄下的文件夾名
|
|
|
*
|
|
|
* @return string 上傳圖片名
|
|
|
*/
|
|
|
function upload_file($upload, $type)
|
|
|
{
|
|
|
if (!empty($upload['tmp_name']))
|
|
|
{
|
|
|
$ftype = check_file_type($upload['tmp_name'], $upload['name'], '|png|jpg|jpeg|gif|doc|xls|txt|zip|ppt|pdf|rar|docx|xlsx|pptx|');
|
|
|
if (!empty($ftype))
|
|
|
{
|
|
|
$name = date('Ymd');
|
|
|
for ($i = 0; $i < 6; $i++)
|
|
|
{
|
|
|
$name .= chr(mt_rand(97, 122));
|
|
|
}
|
|
|
|
|
|
$name = $_SESSION['user_id'] . '_' . $name . '.' . $ftype;
|
|
|
|
|
|
$target = ROOT_PATH . DATA_DIR . '/' . $type . '/' . $name;
|
|
|
if (!move_upload_file($upload['tmp_name'], $target))
|
|
|
{
|
|
|
$GLOBALS['err']->add($GLOBALS['_LANG']['upload_file_error'], 1);
|
|
|
|
|
|
return false;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
return $name;
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$GLOBALS['err']->add($GLOBALS['_LANG']['upload_file_type'], 1);
|
|
|
|
|
|
return false;
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$GLOBALS['err']->add($GLOBALS['_LANG']['upload_file_error']);
|
|
|
return false;
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 顯示一個提示信息
|
|
|
*
|
|
|
* @access public
|
|
|
* @param string $content
|
|
|
* @param string $link
|
|
|
* @param string $href
|
|
|
* @param string $type 信息類型：warning, error, info
|
|
|
* @param string $auto_redirect 是否自動跳轉
|
|
|
* @return void
|
|
|
*/
|
|
|
function show_message($content, $links = '', $hrefs = '', $type = 'info', $auto_redirect = true)
|
|
|
{
|
|
|
assign_template();
|
|
|
|
|
|
$msg['content'] = $content;
|
|
|
if (is_array($links) && is_array($hrefs))
|
|
|
{
|
|
|
if (!empty($links) && count($links) == count($hrefs))
|
|
|
{
|
|
|
foreach($links as $key =>$val)
|
|
|
{
|
|
|
$msg['url_info'][$val] = $hrefs[$key];
|
|
|
}
|
|
|
$msg['back_url'] = $hrefs['0'];
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$link = empty($links) ? $GLOBALS['_LANG']['back_up_page'] : $links;
|
|
|
$href = empty($hrefs) ? 'javascript:history.back()' : $hrefs;
|
|
|
$msg['url_info'][$link] = $href;
|
|
|
$msg['back_url'] = $href;
|
|
|
}
|
|
|
|
|
|
$msg['type'] = $type;
|
|
|
$position = assign_ur_here(0, $GLOBALS['_LANG']['sys_msg']);
|
|
|
$GLOBALS['smarty']->assign('page_title', $position['title']); // 頁面標題
|
|
|
$GLOBALS['smarty']->assign('ur_here', $position['ur_here']); // 當前位置
|
|
|
|
|
|
if (is_null($GLOBALS['smarty']->get_template_vars('helps')))
|
|
|
{
|
|
|
$GLOBALS['smarty']->assign('helps', get_shop_help()); // 網店幫助
|
|
|
}
|
|
|
$GLOBALS['smarty']->assign('categories', get_categories_tree()); // 分類樹
|
|
|
$GLOBALS['smarty']->assign('auto_redirect', $auto_redirect);
|
|
|
$GLOBALS['smarty']->assign('message', $msg);
|
|
|
$GLOBALS['smarty']->display('message.dwt');
|
|
|
|
|
|
exit;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 將一個形如+10, 10, -10, 10%的字串轉換為相應數字，並返回操作符號
|
|
|
*
|
|
|
* @access public
|
|
|
* @param string str 要格式化的數據
|
|
|
* @param char operate 操作符號，只能返回‘+’或‘*’;
|
|
|
* @return float value 浮點數
|
|
|
*/
|
|
|
function parse_rate_value($str, &$operate)
|
|
|
{
|
|
|
$operate = '+';
|
|
|
$is_rate = false;
|
|
|
|
|
|
$str = trim($str);
|
|
|
if (empty($str))
|
|
|
{
|
|
|
return 0;
|
|
|
}
|
|
|
if ($str[strlen($str) - 1] == '%')
|
|
|
{
|
|
|
$value = floatval($str);
|
|
|
if ($value > 0)
|
|
|
{
|
|
|
$operate = '*';
|
|
|
|
|
|
return $value / 100;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
return 0;
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
return floatval($str);
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 重新計算購物車中的產品價格：目的是當用户登錄時享受客戶價格，當用户退出登錄時不享受客戶價格
|
|
|
* 如果產品有促銷，價格不變
|
|
|
*
|
|
|
* @access public
|
|
|
* @return void
|
|
|
*/
|
|
|
function recalculate_price()
|
|
|
{
|
|
|
/* 取得有可能改變價格的產品：除配件和贈品之外的產品 */
|
|
|
$sql = 'SELECT c.rec_id, c.goods_id, c.goods_attr_id, g.promote_price, g.promote_start_date, c.goods_number,'.
|
|
|
"g.promote_end_date, IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS member_price ".
|
|
|
'FROM ' . $GLOBALS['ecs']->table('cart') . ' AS c '.
|
|
|
'LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON g.goods_id = c.goods_id '.
|
|
|
"LEFT JOIN " . $GLOBALS['ecs']->table('member_price') . " AS mp ".
|
|
|
"ON mp.goods_id = g.goods_id AND mp.user_rank = '" . $_SESSION['user_rank'] . "' ".
|
|
|
"WHERE session_id = '" .SESS_ID. "' AND c.parent_id = 0 AND c.is_gift = 0 AND c.goods_id > 0 " .
|
|
|
"AND c.rec_type = '" . CART_GENERAL_GOODS . "' AND c.extension_code <> 'package_buy'";
|
|
|
|
|
|
$res = $GLOBALS['db']->getAll($sql);
|
|
|
|
|
|
foreach ($res AS $row)
|
|
|
{
|
|
|
$attr_id = empty($row['goods_attr_id']) ? array() : explode(',', $row['goods_attr_id']);
|
|
|
|
|
|
|
|
|
$goods_price = get_final_price($row['goods_id'], $row['goods_number'], true, $attr_id);
|
|
|
|
|
|
|
|
|
$goods_sql = "UPDATE " .$GLOBALS['ecs']->table('cart'). " SET goods_price = '$goods_price' ".
|
|
|
"WHERE goods_id = '" . $row['goods_id'] . "' AND session_id = '" . SESS_ID . "' AND rec_id = '" . $row['rec_id'] . "'";
|
|
|
|
|
|
$GLOBALS['db']->query($goods_sql);
|
|
|
}
|
|
|
|
|
|
/* 增加購物車選擇性結算--開始--青蜂網絡www.0769web.net */
|
|
|
$sql = "select rec_id,goods_id,goods_attr,goods_number ".
|
|
|
" from ".$GLOBALS['ecs']->table('cart') ." where user_id=0 ".
|
|
|
" AND session_id = '" .SESS_ID. "' AND parent_id = 0 ".
|
|
|
" AND is_gift = 0 AND goods_id > 0 " .
|
|
|
"AND rec_type = '" . CART_GENERAL_GOODS . "' ";
|
|
|
$res = $GLOBALS['db']->query($sql);
|
|
|
while ($row = $GLOBALS['db']->fetchRow($res))
|
|
|
{
|
|
|
$sql = "select rec_id from ".$GLOBALS['ecs']->table('cart')." where user_id='". $_SESSION['user_id'] ."' ".
|
|
|
" AND goods_id='$row[goods_id]' and goods_attr= '$row[goods_attr]' ";
|
|
|
$sql2 = "select goods_number from ".$GLOBALS['ecs']->table('cart')." where user_id='". $_SESSION['user_id'] ."' ".
|
|
|
" AND goods_id='$row[goods_id]' and goods_attr= '$row[goods_attr]' ";
|
|
|
$rec_id = $GLOBALS['db']->getOne($sql);
|
|
|
$goods_number = $GLOBALS['db']->getOne($sql2);
|
|
|
$rec_id_new = $row['rec_id'];
|
|
|
if($rec_id)
|
|
|
{
|
|
|
$sql = "update ".$GLOBALS['ecs']->table('cart')." set user_id='". $_SESSION['user_id'] ."',goods_number= goods_number + ".$goods_number.
|
|
|
" where rec_id='$rec_id_new' ";
|
|
|
$GLOBALS['db']->query($sql);
|
|
|
$sql="delete from ".$GLOBALS['ecs']->table('cart')." where rec_id='$rec_id'";
|
|
|
$GLOBALS['db']->query($sql);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$sql = "update ".$GLOBALS['ecs']->table('cart')." set user_id='$_SESSION[user_id]' ".
|
|
|
" where rec_id='".$row['rec_id']."'";
|
|
|
$GLOBALS['db']->query($sql);
|
|
|
}
|
|
|
}
|
|
|
/* 增加購物車選擇性結算--結束--青蜂網絡www.0769web.net */
|
|
|
|
|
|
/* 刪除贈品，重新選擇 */
|
|
|
$GLOBALS['db']->query('DELETE FROM ' . $GLOBALS['ecs']->table('cart') .
|
|
|
" WHERE session_id = '" . SESS_ID . "' AND is_gift > 0");
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 查詢評論內容
|
|
|
*
|
|
|
* @access public
|
|
|
* @params integer $id
|
|
|
* @params integer $type
|
|
|
* @params integer $page
|
|
|
* @return array
|
|
|
*/
|
|
|
function assign_comment($id, $type = 1, $page = 1)
|
|
|
{
|
|
|
/* 取得評論列表 */
|
|
|
$count = $GLOBALS['db']->getOne('SELECT COUNT(*) FROM ' .$GLOBALS['ecs']->table('comment').
|
|
|
" WHERE id_value = '$id' AND comment_type = '$type' AND status = 1 AND parent_id = 0");
|
|
|
$size = !empty($GLOBALS['_CFG']['comments_number']) ? $GLOBALS['_CFG']['comments_number'] : 5;
|
|
|
|
|
|
$page_count = ($count > 0) ? intval(ceil($count / $size)) : 1;
|
|
|
|
|
|
$sql = 'SELECT * FROM ' . $GLOBALS['ecs']->table('comment') .
|
|
|
" WHERE id_value = '$id' AND comment_type = '$type' AND status = 1 AND parent_id = 0".
|
|
|
' ORDER BY comment_id DESC';
|
|
|
$res = $GLOBALS['db']->selectLimit($sql, $size, ($page-1) * $size);
|
|
|
|
|
|
$arr = array();
|
|
|
$ids = '';
|
|
|
while ($row = $GLOBALS['db']->fetchRow($res))
|
|
|
{
|
|
|
$ids .= $ids ? ",$row[comment_id]" : $row['comment_id'];
|
|
|
$arr[$row['comment_id']]['id'] = $row['comment_id'];
|
|
|
$arr[$row['comment_id']]['email'] = $row['email'];
|
|
|
$arr[$row['comment_id']]['username'] = $row['user_name'];
|
|
|
$arr[$row['comment_id']]['content'] = str_replace('\r\n', '<br />', htmlspecialchars($row['content']));
|
|
|
$arr[$row['comment_id']]['content'] = nl2br(str_replace('\n', '<br />', $arr[$row['comment_id']]['content']));
|
|
|
$arr[$row['comment_id']]['rank'] = $row['comment_rank'];
|
|
|
$arr[$row['comment_id']]['rank_w'] = $row['comment_rank']*20;
|
|
|
$arr[$row['comment_id']]['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $row['add_time']);
|
|
|
}
|
|
|
/* 取得已有回覆的評論 */
|
|
|
|
|
|
if ($ids)
|
|
|
{
|
|
|
$sql = 'SELECT * FROM ' . $GLOBALS['ecs']->table('comment') .
|
|
|
" WHERE parent_id IN( $ids )";
|
|
|
$res = $GLOBALS['db']->query($sql);
|
|
|
|
|
|
while ($row = $GLOBALS['db']->fetch_array($res))
|
|
|
{
|
|
|
|
|
|
$arr[$row['parent_id']]['re_content'] = nl2br(str_replace('\n', '<br />', htmlspecialchars($row['content'])));
|
|
|
$arr[$row['parent_id']]['re_add_time'] = local_date($GLOBALS['_CFG']['time_format'], $row['add_time']);
|
|
|
$arr[$row['parent_id']]['re_email'] = $row['email'];
|
|
|
$arr[$row['parent_id']]['re_username'] = $row['user_name'];
|
|
|
}
|
|
|
}
|
|
|
|
|
|
|
|
|
/* 分頁樣式 */
|
|
|
//$pager['styleid'] = isset($GLOBALS['_CFG']['page_style'])? intval($GLOBALS['_CFG']['page_style']) : 0;
|
|
|
$pager['page'] = $page;
|
|
|
$pager['size'] = $size;
|
|
|
$pager['record_count'] = $count;
|
|
|
$pager['page_count'] = $page_count;
|
|
|
$pager['page_first'] = "javascript:gotoPage(1,$id,$type)";
|
|
|
$pager['page_prev'] = $page > 1 ? "javascript:gotoPage(" .($page-1). ",$id,$type)" : 'javascript:;';
|
|
|
$pager['page_next'] = $page < $page_count ? 'javascript:gotoPage(' .($page + 1) . ",$id,$type)" : 'javascript:;';
|
|
|
$pager['page_last'] = $page < $page_count ? 'javascript:gotoPage(' .$page_count. ",$id,$type)" : 'javascript:;';
|
|
|
|
|
|
$comment_percent = comment_percent($id); //獲取評分
|
|
|
|
|
|
$cmt = array('comments' => $arr, 'pager' => $pager , 'comment_percent' => $comment_percent);
|
|
|
|
|
|
return $cmt;
|
|
|
}
|
|
|
|
|
|
function assign_template($ctype = '', $catlist = array())
|
|
|
{
|
|
|
global $smarty;
|
|
|
|
|
|
$smarty->assign('image_width', $GLOBALS['_CFG']['image_width']);
|
|
|
$smarty->assign('image_height', $GLOBALS['_CFG']['image_height']);
|
|
|
$smarty->assign('points_name', $GLOBALS['_CFG']['integral_name']);
|
|
|
$smarty->assign('qq', explode(',', $GLOBALS['_CFG']['qq']));
|
|
|
$smarty->assign('ww', explode(',', $GLOBALS['_CFG']['ww']));
|
|
|
$smarty->assign('ym', explode(',', $GLOBALS['_CFG']['ym']));
|
|
|
$smarty->assign('msn', explode(',', $GLOBALS['_CFG']['msn']));
|
|
|
$smarty->assign('skype', explode(',', $GLOBALS['_CFG']['skype']));
|
|
|
$smarty->assign('stats_code', $GLOBALS['_CFG']['stats_code']);
|
|
|
$smarty->assign('copyright', sprintf($GLOBALS['_LANG']['copyright'], date('Y'), $GLOBALS['_CFG']['shop_name']));
|
|
|
$smarty->assign('shop_name', $GLOBALS['_CFG']['shop_name']);
|
|
|
$smarty->assign('service_email', $GLOBALS['_CFG']['service_email']);
|
|
|
$smarty->assign('service_phone', $GLOBALS['_CFG']['service_phone']);
|
|
|
$smarty->assign('shop_address', $GLOBALS['_CFG']['shop_address']);
|
|
|
$smarty->assign('licensed', license_info());
|
|
|
$smarty->assign('ecs_version', VERSION);
|
|
|
$smarty->assign('icp_number', $GLOBALS['_CFG']['icp_number']);
|
|
|
$smarty->assign('username', !empty($_SESSION['user_name']) ? $_SESSION['user_name'] : '');
|
|
|
$smarty->assign('category_list', cat_list(0, 0, true, 2, false));
|
|
|
$smarty->assign('catalog_list', cat_list(0, 0, false, 1, false));
|
|
|
$smarty->assign('navigator_list', get_navigator($ctype, $catlist)); //自定義導航欄
|
|
|
|
|
|
if (!empty($GLOBALS['_CFG']['search_keywords']))
|
|
|
{
|
|
|
$searchkeywords = explode(',', trim($GLOBALS['_CFG']['search_keywords']));
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$searchkeywords = array();
|
|
|
}
|
|
|
$smarty->assign('searchkeywords', $searchkeywords);
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 將一個本地時間戳轉成GMT時間戳
|
|
|
*
|
|
|
* @access public
|
|
|
* @param int $time
|
|
|
*
|
|
|
* @return int $gmt_time;
|
|
|
*/
|
|
|
function time2gmt($time)
|
|
|
{
|
|
|
return strtotime(gmdate('Y-m-d H:i:s', $time));
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 查詢客戶的紅包金額
|
|
|
*
|
|
|
* @access public
|
|
|
* @param integer $user_id
|
|
|
* @return void
|
|
|
*/
|
|
|
function get_user_bonus($user_id = 0)
|
|
|
{
|
|
|
if ($user_id == 0)
|
|
|
{
|
|
|
$user_id = $_SESSION['user_id'];
|
|
|
}
|
|
|
|
|
|
$sql = "SELECT SUM(bt.type_money) AS bonus_value, COUNT(*) AS bonus_count ".
|
|
|
"FROM " .$GLOBALS['ecs']->table('user_bonus'). " AS ub, ".
|
|
|
$GLOBALS['ecs']->table('bonus_type') . " AS bt ".
|
|
|
"WHERE ub.user_id = '$user_id' AND ub.bonus_type_id = bt.type_id AND ub.order_id = 0";
|
|
|
$row = $GLOBALS['db']->getRow($sql);
|
|
|
|
|
|
return $row;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 保存推薦uid
|
|
|
*
|
|
|
* @access public
|
|
|
* @param void
|
|
|
*
|
|
|
* @return void
|
|
|
* @author xuanyan
|
|
|
**/
|
|
|
function set_affiliate()
|
|
|
{
|
|
|
$config = unserialize($GLOBALS['_CFG']['affiliate']);
|
|
|
if (!empty($_GET['u']) && $config['on'] == 1)
|
|
|
{
|
|
|
if(!empty($config['config']['expire']))
|
|
|
{
|
|
|
if($config['config']['expire_unit'] == 'hour')
|
|
|
{
|
|
|
$c = 1;
|
|
|
}
|
|
|
elseif($config['config']['expire_unit'] == 'day')
|
|
|
{
|
|
|
$c = 24;
|
|
|
}
|
|
|
elseif($config['config']['expire_unit'] == 'week')
|
|
|
{
|
|
|
$c = 24 * 7;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$c = 1;
|
|
|
}
|
|
|
// setcookie('shop_affiliate_uid', intval($_GET['u']), gmtime() + 3600 * $config['config']['expire'] * $c);
|
|
|
setcookie('refer_code', $_GET['refer'], time() + 3600 * $config['config']['expire'] * $c);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
// setcookie('shop_affiliate_uid', intval($_GET['u']), gmtime() + 3600 * 24); // 過期時間為 1 天
|
|
|
setcookie('refer_code', $_GET['refer'], time() + 3600 * 24); // 過期時間為 1 天
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 獲取推薦uid
|
|
|
*
|
|
|
* @access public
|
|
|
* @param void
|
|
|
*
|
|
|
* @return int
|
|
|
**/
|
|
|
function get_affiliate()
|
|
|
{
|
|
|
if (!empty($_COOKIE['refer_code']))
|
|
|
{
|
|
|
$refer_code = $_COOKIE['refer_code'];
|
|
|
if ($GLOBALS['db']->getOne('SELECT user_id FROM ' . $GLOBALS['ecs']->table('users') . "WHERE user_id = '$uid'"))
|
|
|
{
|
|
|
return $uid;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
setcookie('refer_code', '', 1);
|
|
|
}
|
|
|
}
|
|
|
|
|
|
return 0;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 獲得指定分類同級的所有分類以及該分類下的子分類
|
|
|
*
|
|
|
* @access public
|
|
|
* @param integer $cat_id 分類編號
|
|
|
* @return array
|
|
|
*/
|
|
|
function article_categories_tree($cat_id = 0)
|
|
|
{
|
|
|
if ($cat_id > 0)
|
|
|
{
|
|
|
$sql = 'SELECT parent_id FROM ' . $GLOBALS['ecs']->table('article_cat') . " WHERE cat_id = '$cat_id'";
|
|
|
$parent_id = $GLOBALS['db']->getOne($sql);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$parent_id = 0;
|
|
|
}
|
|
|
|
|
|
/*
|
|
|
判斷當前分類中全是是否是底級分類，
|
|
|
如果是取出底級分類上級分類，
|
|
|
如果不是取當前分類及其下的子分類
|
|
|
*/
|
|
|
$sql = 'SELECT count(*) FROM ' . $GLOBALS['ecs']->table('article_cat') . " WHERE parent_id = '$parent_id'";
|
|
|
if ($GLOBALS['db']->getOne($sql))
|
|
|
{
|
|
|
/* 獲取當前分類及其子分類 */
|
|
|
$sql = 'SELECT a.cat_id, a.cat_name, a.sort_order AS parent_order, a.cat_id, ' .
|
|
|
'b.cat_id AS child_id, b.cat_name AS child_name, b.sort_order AS child_order ' .
|
|
|
'FROM ' . $GLOBALS['ecs']->table('article_cat') . ' AS a ' .
|
|
|
'LEFT JOIN ' . $GLOBALS['ecs']->table('article_cat') . ' AS b ON b.parent_id = a.cat_id ' .
|
|
|
"WHERE a.parent_id = '$parent_id' and a.cat_id<>1 ORDER BY parent_order ASC, a.cat_id ASC, child_order ASC";
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
/* 獲取當前分類及其父分類 */
|
|
|
$sql = 'SELECT a.cat_id, a.cat_name, b.cat_id AS child_id, b.cat_name AS child_name, b.sort_order ' .
|
|
|
'FROM ' . $GLOBALS['ecs']->table('article_cat') . ' AS a ' .
|
|
|
'LEFT JOIN ' . $GLOBALS['ecs']->table('article_cat') . ' AS b ON b.parent_id = a.cat_id ' .
|
|
|
"WHERE b.parent_id = '$parent_id' and a.cat_id<>1 ORDER BY sort_order ASC";
|
|
|
}
|
|
|
$res = $GLOBALS['db']->getAll($sql);
|
|
|
|
|
|
$cat_arr = array();
|
|
|
foreach ($res AS $row)
|
|
|
{
|
|
|
$cat_arr[$row['cat_id']]['id'] = $row['cat_id'];
|
|
|
$cat_arr[$row['cat_id']]['name'] = $row['cat_name'];
|
|
|
$cat_arr[$row['cat_id']]['url'] = build_uri('article_cat', array('acid' => $row['cat_id']), $row['cat_name']);
|
|
|
|
|
|
if ($row['child_id'] != NULL)
|
|
|
{
|
|
|
$cat_arr[$row['cat_id']]['child'][$row['child_id']]['id'] = $row['child_id'];
|
|
|
$cat_arr[$row['cat_id']]['child'][$row['child_id']]['name'] = $row['child_name'];
|
|
|
$cat_arr[$row['cat_id']]['child'][$row['child_id']]['url'] = build_uri('article_cat', array('acid' => $row['child_id']), $row['child_name']);
|
|
|
}
|
|
|
}
|
|
|
|
|
|
return $cat_arr;
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
/**
|
|
|
* 獲得指定文章分類的所有上級分類
|
|
|
*
|
|
|
* @access public
|
|
|
* @param integer $cat 分類編號
|
|
|
* @return array
|
|
|
*/
|
|
|
function get_article_parent_cats($cat)
|
|
|
{
|
|
|
if ($cat == 0)
|
|
|
{
|
|
|
return array();
|
|
|
}
|
|
|
|
|
|
$arr = $GLOBALS['db']->GetAll('SELECT cat_id, cat_name, parent_id FROM ' . $GLOBALS['ecs']->table('article_cat'));
|
|
|
|
|
|
if (empty($arr))
|
|
|
{
|
|
|
return array();
|
|
|
}
|
|
|
|
|
|
$index = 0;
|
|
|
$cats = array();
|
|
|
|
|
|
while (1)
|
|
|
{
|
|
|
foreach ($arr AS $row)
|
|
|
{
|
|
|
if ($cat == $row['cat_id'])
|
|
|
{
|
|
|
$cat = $row['parent_id'];
|
|
|
|
|
|
$cats[$index]['cat_id'] = $row['cat_id'];
|
|
|
$cats[$index]['cat_name'] = $row['cat_name'];
|
|
|
|
|
|
$index++;
|
|
|
break;
|
|
|
}
|
|
|
}
|
|
|
|
|
|
if ($index == 0 || $cat == 0)
|
|
|
{
|
|
|
break;
|
|
|
}
|
|
|
}
|
|
|
|
|
|
return $cats;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 取得某模板某庫設置的數量
|
|
|
* @param string $template 模板名，如index
|
|
|
* @param string $library 庫名，如recommend_best
|
|
|
* @param int $def_num 默認數量：如果沒有設置模板，顯示的數量
|
|
|
* @return int 數量
|
|
|
*/
|
|
|
function get_library_number($library, $template = null)
|
|
|
{
|
|
|
global $page_libs;
|
|
|
|
|
|
if (empty($template))
|
|
|
{
|
|
|
$template = basename(PHP_SELF);
|
|
|
$template = substr($template, 0, strrpos($template, '.'));
|
|
|
}
|
|
|
$template = addslashes($template);
|
|
|
|
|
|
static $lib_list = array();
|
|
|
|
|
|
/* 如果沒有該模板的信息，取得該模板的信息 */
|
|
|
if (!isset($lib_list[$template]))
|
|
|
{
|
|
|
$lib_list[$template] = array();
|
|
|
$sql = "SELECT library, number FROM " . $GLOBALS['ecs']->table('template') .
|
|
|
" WHERE theme = '" . $GLOBALS['_CFG']['template'] . "'" .
|
|
|
" AND filename = '$template' AND remarks='' ";
|
|
|
$res = $GLOBALS['db']->query($sql);
|
|
|
|
|
|
while ($row = $GLOBALS['db']->fetchRow($res))
|
|
|
{
|
|
|
$lib = basename(strtolower(substr($row['library'], 0, strpos($row['library'], '.'))));
|
|
|
$lib_list[$template][$lib] = $row['number'];
|
|
|
}
|
|
|
}
|
|
|
|
|
|
$num = 0;
|
|
|
if (isset($lib_list[$template][$library]))
|
|
|
{
|
|
|
$num = intval($lib_list[$template][$library]);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
/* 模板設置文件查找默認值 */
|
|
|
include_once(ROOT_PATH . ADMIN_PATH . '/includes/lib_template.php');
|
|
|
static $static_page_libs = null;
|
|
|
if ($static_page_libs == null)
|
|
|
{
|
|
|
$static_page_libs = $page_libs;
|
|
|
}
|
|
|
$lib = '/library/' . $library . '.lbi';
|
|
|
|
|
|
$num = isset($static_page_libs[$template][$lib]) ? $static_page_libs[$template][$lib] : 10;
|
|
|
}
|
|
|
|
|
|
return $num;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 取得自定義導航欄列表
|
|
|
* @param string $type 位置，如top、bottom、middle
|
|
|
* @return array 列表
|
|
|
*/
|
|
|
function get_navigator($ctype = '', $catlist = array())
|
|
|
{
|
|
|
$sql = 'SELECT * FROM '. $GLOBALS['ecs']->table('nav') . '
|
|
|
WHERE ifshow = \'1\' ORDER BY type, vieworder';
|
|
|
$res = $GLOBALS['db']->query($sql);
|
|
|
|
|
|
$cur_url = substr(strrchr($_SERVER['REQUEST_URI'],'/'),1);
|
|
|
|
|
|
if (intval($GLOBALS['_CFG']['rewrite']))
|
|
|
{
|
|
|
if(strpos($cur_url, '-'))
|
|
|
{
|
|
|
preg_match('/([a-z]*)-([0-9]*)/',$cur_url,$matches);
|
|
|
$cur_url = $matches[1].'.php?id='.$matches[2];
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$cur_url = substr(strrchr($_SERVER['REQUEST_URI'],'/'),1);
|
|
|
}
|
|
|
|
|
|
$noindex = false;
|
|
|
$active = 0;
|
|
|
$navlist = array(
|
|
|
'top' => array(),
|
|
|
'middle' => array(),
|
|
|
'bottom' => array()
|
|
|
);
|
|
|
while ($row = $GLOBALS['db']->fetchRow($res))
|
|
|
{
|
|
|
$navlist[$row['type']][] = array(
|
|
|
'name' => $row['name'],
|
|
|
'opennew' => $row['opennew'],
|
|
|
'url' => $row['url'],
|
|
|
'ctype' => $row['ctype'],
|
|
|
'cid' => $row['cid'],
|
|
|
);
|
|
|
}
|
|
|
|
|
|
/*遍歷自定義是否存在currentPage*/
|
|
|
foreach($navlist['middle'] as $k=>$v)
|
|
|
{
|
|
|
$condition = empty($ctype) ? (strpos($cur_url, $v['url']) === 0) : (strpos($cur_url, $v['url']) === 0 && strlen($cur_url) == strlen($v['url']));
|
|
|
if ($condition)
|
|
|
{
|
|
|
$navlist['middle'][$k]['active'] = 1;
|
|
|
$noindex = true;
|
|
|
$active += 1;
|
|
|
}
|
|
|
}
|
|
|
|
|
|
if(!empty($ctype) && $active < 1)
|
|
|
{
|
|
|
foreach($catlist as $key => $val)
|
|
|
{
|
|
|
foreach($navlist['middle'] as $k=>$v)
|
|
|
{
|
|
|
if(!empty($v['ctype']) && $v['ctype'] == $ctype && $v['cid'] == $val && $active < 1)
|
|
|
{
|
|
|
$navlist['middle'][$k]['active'] = 1;
|
|
|
$noindex = true;
|
|
|
$active += 1;
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
|
|
|
if ($noindex == false) {
|
|
|
$navlist['config']['index'] = 1;
|
|
|
}
|
|
|
|
|
|
return $navlist;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 授權信息內容
|
|
|
*
|
|
|
* @return str
|
|
|
*/
|
|
|
function license_info()
|
|
|
{
|
|
|
if($GLOBALS['_CFG']['licensed'] > 0)
|
|
|
{
|
|
|
/* 獲取HOST */
|
|
|
if (isset($_SERVER['HTTP_X_FORWARDED_HOST']))
|
|
|
{
|
|
|
$host = $_SERVER['HTTP_X_FORWARDED_HOST'];
|
|
|
}
|
|
|
elseif (isset($_SERVER['HTTP_HOST']))
|
|
|
{
|
|
|
$host = $_SERVER['HTTP_HOST'];
|
|
|
}
|
|
|
$url_domain=url_domain();
|
|
|
$host = 'http://' . $host .$url_domain ;
|
|
|
$license = '<a href="http://www.xxx.com/license.php?product=shop_b2c&url=' . urlencode($host) . '" target="_blank"
|
|
|
> Licensed</a>';
|
|
|
return $license;
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
return '';
|
|
|
}
|
|
|
}
|
|
|
function url_domain()
|
|
|
{
|
|
|
$curr = strpos(PHP_SELF, ADMIN_PATH . '/') !== false ?
|
|
|
preg_replace('/(.*)(' . ADMIN_PATH . ')(\/?)(.)*/i', '\1', dirname(PHP_SELF)) :
|
|
|
dirname(PHP_SELF);
|
|
|
|
|
|
$root = str_replace('\\', '/', $curr);
|
|
|
|
|
|
if (substr($root, -1) != '/')
|
|
|
{
|
|
|
$root .= '/';
|
|
|
}
|
|
|
|
|
|
return $root;
|
|
|
}
|
|
|
function get_advlist_position_name_pc($position_name,$type,$num)
|
|
|
{
|
|
|
$arr = array( );
|
|
|
$sql = "select ap.ad_width,ap.ad_height,ad.ad_id,ad.ad_name,ad.ad_code,ad.media_type,ad.ad_link,ad.ad_id,ad.link_man from ".$GLOBALS['ecs']->table( "ad_position" )." as ap left join ".$GLOBALS['ecs']->table( "ad" )." as ad on ad.position_id = ap.position_id where ap.position_name='".$position_name.( "' and UNIX_TIMESTAMP()>ad.start_time and UNIX_TIMESTAMP()<ad.end_time and ad.media_type=".$type." and ad.enabled=1 limit ".$num );
|
|
|
$res = $GLOBALS['db']->getAll( $sql );
|
|
|
foreach ( $res as $idx => $row )
|
|
|
{
|
|
|
$arr[$row['ad_id']]['name'] = $row['ad_name'];
|
|
|
$arr[$row['ad_id']]['code'] = $row['ad_code'];
|
|
|
$arr[$row['ad_id']]['url'] = "affiche.php?ad_id=".$row['ad_id']."&uri=".$row['ad_link'];
|
|
|
$arr[$row['ad_id']]['image'] = "data/afficheimg/".$row['ad_code'];
|
|
|
$arr[$row['ad_id']]['content'] = "<a href='".$arr[$row['ad_id']]['url']."' target='_blank'><img src='data/afficheimg/".$row['ad_code']."' width='".$row['ad_width']."' height='".$row['ad_height']."' /></a>";
|
|
|
$arr[$row['ad_id']]['width'] = $row['ad_width'];
|
|
|
$arr[$row['ad_id']]['height'] = $row['ad_height'];
|
|
|
$arr[$row['ad_id']]['link_man'] = $row['link_man'];
|
|
|
}
|
|
|
return $arr;
|
|
|
}
|
|
|
?>
|
