getList("SELECT * FROM ".DB_ARTICLE_CATEGORY." WHERE parent_id='".$frame_id."' ORDER BY category_sort ASC");
if(count($list) > 0) {
$result = "".Chr(13);
}else
$result = '';
$objResponse = new xajaxResponse();
$objResponse->addAssign("article_category_content", "innerHTML", $result);
return $objResponse;
}
// 前台 - 特效呈現 pagesheet
function effect_pagesheet($id, $category_id, $block_id)
{
global $pfcKernel;
$db = &$pfcKernel['db'];
$tpl = &$pfcKernel['tpl'];
$tmp = &$pfcKernel['tmp']; // 為了傳遞文章相關設定 to CallbackFunc_Article: len_title, len_content
// 取得區塊資料
$list = $db->getItem(DB_BLOCK, "ID", $block_id);
// if 區塊內容有設定就使用，else 讀取文章模板內容
if(!empty($list['block_content'])) {
$template = $list['block_content'];
$tmp = $list;
}else{
$list_tpl = $db->getItem(DB_TEMPLATE, "ID", $list['template_id']);
$template = $list_tpl['tpl_content'];
$tmp = $list_tpl;
}
$tpl->setString("result", $template);
// 載入文章資料
if(DB_TYPE == "mysql")
$list_article = $db->getList("SELECT * FROM ".DB_ARTICLE." WHERE category_id='".$category_id."' and accept=1 and disabled=0 ORDER BY date_start DESC, ID DESC LIMIT 0, ".$tmp['len_record']);
else
$list_article = $db->getList("SELECT TOP ".$tmp['len_record']." * FROM ".DB_ARTICLE." WHERE category_id='".$category_id."' and accept=1 and disabled=0 ORDER BY date_start DESC, ID DESC");
// 文章 more
$tpl->setVar('more', PHP_SELF.'?code=list&ids='.$category_id);
// 第一張圖
if($list_article[0]['pic']){
$tpl->setVar('pic', $list_article[0]['pic']);
}else{
$tpl->setVar('pic', '');
}
// 暴力抓資料
for($i=0; $isetVar('date_start_'.($i+1), $list_article[$i]['date_start']);
$tpl->setVar('short_title_'.($i+1), $list_article[$i]['short_title']);
$tpl->setVar('short_content_'.($i+1), $list_article[$i]['short_content']);
if($list_article[$i]['pic']){
$tpl->setVar('pic_'.($i+1), '
');
}else{
$tpl->setVar('pic_'.($i+1), '');
}
/* $tpl->setVar('date_start', $list_article[$i]['date_start']);
$tpl->setVar('short_title', $list_article[$i]['short_title']);
$tpl->setVar('short_content', $list_article[$i]['short_content']);
$tpl->setVar('pic', $list_article[$i]['pic']);*/
}
$tpl->simpleBlock('result', 'RowList', $list_article, 'CallbackFunc_Article');
$objResponse = new xajaxResponse();
$objResponse->addAssign("effect_pagesheet_content_".$id, "innerHTML", $tpl->parse('result'));
return $objResponse;
}
// 前台 - 特效呈現 volume
function effect_volume($category_id, $block_id, $set_id)
{
global $pfcKernel;
$db = &$pfcKernel['db'];
$tpl = &$pfcKernel['tpl'];
$tmp = &$pfcKernel['tmp']; // 為了傳遞文章相關設定 to CallbackFunc_Article: len_title, len_content
// 取得區塊資料
$list = $db->getItem(DB_BLOCK, "ID", $block_id);
// if 區塊內容有設定就使用，else 讀取文章模板內容
if(!empty($list['block_content'])) {
$template = $list['block_content'];
$tmp = $list;
}else{
$list_tpl = $db->getItem(DB_TEMPLATE, "ID", $list['template_id']);
$template = $list_tpl['tpl_content'];
$tmp = $list_tpl;
}
$tpl->setString("result", $template);
// 載入文章資料
if(DB_TYPE == "mysql")
$list_article = $db->getList("SELECT * FROM ".DB_ARTICLE." WHERE category_id='".$category_id."' and accept=1 and disabled=0 ORDER BY date_start DESC, ID DESC LIMIT 0, ".$tmp['len_record']);
else
$list_article = $db->getList("SELECT TOP ".$tmp['len_record']." * FROM ".DB_ARTICLE." WHERE category_id='".$category_id."' and accept=1 and disabled=0 ORDER BY date_start DESC, ID DESC");
// 文章 more
$tpl->setVar('more', PHP_SELF.'?code=list&ids='.$category_id);
// 第一張圖
if($list_article[0]['pic']){
$tpl->setVar('pic', $list_article[0]['pic']);
}else{
$tpl->setVar('pic', '');
}
// 暴力抓資料
for($i=0; $isetVar('date_start_'.($i+1), $list_article[$i]['date_start']);
$tpl->setVar('short_title_'.($i+1), $list_article[$i]['short_title']);
$tpl->setVar('short_content_'.($i+1), $list_article[$i]['short_content']);
if($list_article[$i]['pic']){
$tpl->setVar('pic_'.($i+1), $list_article[$i]['pic']);
}else{
$tpl->setVar('pic_'.($i+1), '');
}
}
$tpl->simpleBlock('result', 'RowList', $list_article, 'CallbackFunc_Article');
$objResponse = new xajaxResponse();
$objResponse->addAssign("effect_volume_1", "innerHTML", '');
$objResponse->addAssign("effect_volume_2", "innerHTML", '');
$objResponse->addAssign("effect_volume_3", "innerHTML", '');
$objResponse->addAssign("effect_volume_4", "innerHTML", '');
$objResponse->addAssign("effect_volume_".$set_id, "innerHTML", $tpl->parse('result'));
return $objResponse;
}
?>Database error: Invalid SQL: SELECT * FROM DB_SETTING
MySQL Error: 1146 (Table 'km_tycc_en.db_setting' doesn't exist)
Session halted.