function name($id) { $name = ''; $attr1 = settings::getInstance()->getrow(array('tag'=>'table-archive')); if ($attr1['value']) self::$var = @unserialize($attr1['value']); else self::$var = array(); preg_match_all('/\(([\d\w]+)\)(\S+)/is',self::$var['attr1'],$result,PREG_SET_ORDER); $id_arr = explode(',',$id); foreach($result as $v){ foreach($id_arr as $t_v){ if(in_array($t_v,$v)) $name .= $v[2].' / '; } } return $name; }
function list_action() { chkpw('union_list'); $set1=settings::getInstance(); $sets1=$set1->getrow(array('tag'=>'table-'.$this->table)); $setsdata1=unserialize($sets1['value']); $this->view->settings=$setsdata1; $where=null; $ordre='`userid` DESC'; $limit=((front::get('page') -1) * $this->_pagesize).','.$this->_pagesize; $this->_view_table=$this->_table->getrows($where,$limit,$ordre,$this->_table->getcols('manage')); $this->view->record_count=$this->_table->record_count; $this->_view_user = new user; foreach($this->_view_table as $key=>$val) { $userunion = $this->_view_user->getrow(array('userid'=>$val['userid'])); $val['point'] = $userunion['point']; $this->_view_table[$key] = $val; } }
static function getTags() { $data=array(); $data[0] = '请选择'; $otag = new tag(); $row = $otag->getrows('',0,'tagid ASC'); if(is_array($row)){ foreach ($row as $arr){ $data[$arr['tagname']] = $arr['tagname']; } } //return $data; $sets=settings::getInstance()->getrow(array('tag'=>'table-hottag')); if (!is_array($sets)){ return $data; } $data1=unserialize($sets['value']); preg_match_all('%\(([\d\w\/\.-]+)\)(\S+)%m',$data1['hottag'],$result,PREG_SET_ORDER); foreach ($result as $res) $data[$res[2]]=$res[2]; return $data; }
function gettypes() { $sets=settings::getInstance()->getrow(array('tag'=>'table-friendlink')); if (!is_array($sets)) return; $data=unserialize($sets['value']); preg_match_all('%\(([\d\w\/\.-]+)\)(\S+)%m',$data['types'],$result,PREG_SET_ORDER); $data=array(); foreach ($result as $res) $data[$res[1]]=$res[2]; return $data; }
function setting_action() { $this->_view_table=false; $set=settings::getInstance(); $sets=$set->getrow(array('tag'=>'table-'.$this->table)); $data=unserialize($sets['value']); if (front::post('submit')) { $var=front::$post; unset($var['submit']); $set->rec_replace(array('value'=>serialize($var),'tag'=>'table-'.$this->table,'array'=>var_export($var,true))); front::flash("{$this->tname}配置成功!"); } $this->view->settings=$data; }
function esearch_action() { front::check_type(front::get('keyword'), 'safe'); $this->view->keyword = trim(front::get('keyword')); if($this->view->keyword){ $path = ROOT . '/data/hotsearch/' . urlencode($this->view->keyword) . '.txt'; $mtime = @filemtime($path); $time = intval(config::get('search_time'))?intval(config::get('search_time')):30; if(time() - $mtime < $time && !front::get('page')){ alertinfo($time.'秒内不能重复搜索','index.php?t='.front::get('t')); } $keywordcount = @file_get_contents($path); $keywordcount = $keywordcount + 1; file_put_contents($path, $keywordcount); $type = $this->view->category; $condition = ""; if (front::get('catid')) { $condition .= "catid = '" . front::get('catid') . "' AND "; } $condition .= "(title like '%" . $this->view->keyword . "%'"; $sets = settings::getInstance()->getrow(array('tag' => 'table-fieldset')); $arr = unserialize($sets['value']); if (is_array($arr['archive']) && !empty($arr['archive'])) { foreach ($arr['archive'] as $v) { if ($v['issearch'] == '1' && front::get($v['name'])) { if($v['selecttype']){ $condition .= " AND {$v['name']} = '".front::get($v['name'])."'"; }else{ $condition .= " AND {$v['name']} like '%".front::get($v['name'])."%'"; } } } } $condition .= ")"; $order = "`listorder`,1 DESC"; $limit = (($this->view->page - 1) * $this->pagesize) . ',' . $this->pagesize; $articles = $this->archive->getrows($condition, $limit, $order); foreach ($articles as $order => $arc) { $articles[$order]['url'] = archive::url($arc); $articles[$order]['catname'] = category::name($arc['catid']); $articles[$order]['caturl'] = category::url($arc['catid']); $articles[$order]['adddate'] = sdate($arc['adddate']); $articles[$order]['stitle'] = strip_tags($arc['title']); } $this->view->articles = $articles; $this->view->archives = $articles; $this->view->record_count = $this->archive->record_count; } $this->view->field = $this->archive->getFields(); }
function setting_action() { if($this->table == 'archive'){ chkpw('archive_setting'); } if($this->table == 'friendlink'){ chkpw('seo_friendlink_setting'); } $this->_view_table=false; $set=settings::getInstance(); $sets=$set->getrow(array('tag'=>'table-'.$this->table)); $data=unserialize($sets['value']); if (front::post('submit')) { $var=front::$post; unset($var['submit']); $set->rec_replace(array('value'=>mysql_escape_string(serialize($var)),'tag'=>'table-'.$this->table,'array'=>mysql_escape_string(var_export($var,true)))); event::log("修改{$this->tname}配置",'成功'); front::flash("配置成功!"); } $this->view->settings=$data; }
function search_action() { if(front::get('keyword') &&!front::post('keyword')) front::$post['keyword']=front::get('keyword'); front::check_type(front::post('keyword'),'safe'); if(front::post('keyword')) { $this->view->keyword=trim(front::post('keyword')); session::set('keyword',$this->view->keyword); } else { session::set('keyword',null); $this->view->keyword=session::get('keyword'); } $type = $this->view->type; $condition = ""; if(front::post('catid')) { $condition .= "catid = '".front::post('catid')."' AND "; } $condition .= "(title like '%".$this->view->keyword."%'"; $sets=settings::getInstance()->getrow(array('tag'=>'table-fieldset')); $arr = unserialize($sets['value']); if(is_array($arr['archive']) &&!empty($arr['archive'])) { foreach ($arr['archive'] as $v) { if($v['issearch'] == '1') { $condition .= " OR {$v['name']} like '%{$this->view->keyword}%'"; } } } $condition .= ")"; $order = "`listorder` desc,1 DESC"; $limit=(($this->view->page-1)*$this->pagesize).','.$this->pagesize; $articles=$this->archive->getrows($condition,$limit,$order); foreach($articles as $order=>$arc) { $articles[$order]['url']=archive::url($arc); $articles[$order]['catname']=category::name($arc['catid']); $articles[$order]['caturl']=category::url($arc['catid']); $articles[$order]['adddate']= sdate($arc['adddate']); $articles[$order]['stitle']= strip_tags($arc['title']); } $this->view->articles=$articles; $this->view->archives=$articles; $this->view->record_count=$this->archive->record_count; }
function getattrs($att_order=1) { $attr='attr'.$att_order; $sets=settings::getInstance()->getrow(array('tag'=>'table-archive')); if (!is_array($sets)) return; $data=unserialize($sets['value']); preg_match_all('%\(([\d\w\/\.-]+)\)(\S+)%m',$data[$attr],$result,PREG_SET_ORDER); $data=array(); foreach ($result as $res) $data[$res[1]]=$res[2]; return $data; }
function init() { } function getcnzz_action(){
function phpwebinsert_action(){ chkpw('func_data_phpweb'); //插入数据库的总条目数 $total_num = 0; $set=settings::getInstance(); $set->name = $set->prefix.'user'; //目标表前缀 $d_prefix = $set->prefix; $user_info = $set->rec_select_one("`username`='{$_COOKIE['login_username']}'","*","`userid`"); if(!empty(front::$post['submit'])){ //判断是否填写原表前缀 if(!empty(front::$post['phpweb_prefix'])){ $s_prefix = front::$post['phpweb_prefix'].'_'; }else{ front::flash('请填写原表前缀'); return ; } //判断上传的数据库文件是否存在 $filename = ROOT.'/'.front::$post['data']; if(!file_exists(ROOT.'/'.front::$post['data'])){ front::flash('请检查是否正确上传数据库文件'); return ; } //记录前面插入的category的id $cat_id = array(); $sql_file = fopen($filename,'r'); while ($row = fgets($sql_file)){ //如果这一行不是INSERT语句就略过 if(!strstr($row,'INSERT')) continue; $tmp = strstr($row,'('); $tmp = trim($tmp,"\n\t\r\0\x0B(); "); $tmp_arr = explode('),(',$tmp); //如果是feedback_info表,则选择对应数据插入guestbook中 if(strstr($row,$s_prefix.'feedback_info')){ foreach($tmp_arr as $v){ $arr = super_explode($v); $arr_data = array( 'username' =>$arr[4], 'adddate' =>date('Y-m-d H:i:s',$arr[26]), 'state' =>$arr[29], 'guesttel' =>$arr[6], 'guestemail'=>$arr[8], 'guestqq' =>$arr[10], 'title' =>$arr[2], 'content' =>$arr[3], ); $id = put_into_db($d_prefix.'guestbook',$arr_data); if($id) $total_num++; } continue; } //如果是advs_link表,则选择对应数据插入linkword中 if(strstr($row,$s_prefix.'advs_link')){ foreach($tmp_arr as $v){ $arr = super_explode($v); $arr_data = array( 'linkword' =>$arr[2], 'linkurl' =>$arr[3], 'linktimes' =>mktime(), ); $id = put_into_db($d_prefix.'linkword',$arr_data); if($id) $total_num++; } continue; } //如果是pollindex表,则选择对应数据插入ballot中 if(strstr($row,$s_prefix.'tools_pollindex')){ foreach($tmp_arr as $v){ $arr = super_explode($v); $arr_data = array( 'id' =>$arr[0], 'title' =>$arr[1], 'type' =>'radio', ); $id = put_into_db($d_prefix.'ballot',$arr_data); if($id) $total_num++; } continue; } //如果是tools_polldata表,则选择对应数据插入option中 if(strstr($row,$s_prefix.'tools_polldata')){ foreach($tmp_arr as $v){ $arr = super_explode($v); $arr_data = array( 'bid' =>$arr[1], 'name' =>$arr[3], 'num' =>$arr[5], 'order'=>$arr[2], ); $id = put_into_db($d_prefix.'option',$arr_data); if($id) $total_num++; } continue; } //如果是product_cat表,则选择对应数据插入b_category中 if(strstr($row,$s_prefix.'product_cat')){ foreach($tmp_arr as $v){ $arr = super_explode($v); $arr_data = array( 'parentid' =>3, 'catname' =>$arr[2], 'listorder' => $arr[3], 'htmldir' =>pinyin::get($arr[2]), 'showtemplate' =>0, 'template' =>'archive/list_pic.html', 'listtemplate' =>'archive/list_pic.html', 'showtemplate' =>'archive/show_products.html', 'includecatarchives'=>1, 'ispages' =>1, 'ishtml' =>0, 'includecatarchives'=>1, 'thumb_width' =>0, 'thumb_height' =>0, 'isnav' =>0, //是否在导航栏显示字段 ); $id = put_into_db($d_prefix.'b_category',$arr_data); $cat_id['product_cat'][$arr[0]] = $id; if($id) $total_num++; } continue; } //如果是product_con表,则选择对应数据插入archive中 if(strstr($row,$s_prefix.'product_con')){ foreach($tmp_arr as $v){ $arr = super_explode($v); $arr_data = array( 'catid' =>isset($cat_id['product_cat'][$arr[1]]) ? $cat_id['product_cat'][$arr[1]] : -1, 'title' =>$arr[5], 'username' =>$user_info['username'], 'userid' =>$user_info['userid'], 'view' =>7,//确认首页是以图片的版面来显示 'spid' =>0, 'tag' =>$arr[43], 'keyword' =>$arr[43], 'listorder' =>0, 'adddate' =>date('Y-m-d H:i:s',$arr[16]), 'author' =>$arr[17], 'thumb' =>$arr[15],//列表显示的图片 'state' =>1, 'checked' =>1, 'introduce' =>$arr[22], 'introduce_len'=>200, 'content' =>$arr[6], 'template' =>'archive/show_products.html', 'ishtml' =>0, 'attr2' =>9,//产品金额 'pics' =>'a:1:{i:0;s:0:"";}',//内容多图 'city_id' =>0, 'section_id' =>0, ); $id = put_into_db($d_prefix.'archive',$arr_data); if($id) $total_num++; } continue; } //如果是news_cat表,则选择对应数据插入b_category中 if(strstr($row,$s_prefix.'news_cat')){ foreach($tmp_arr as $v){ $arr = super_explode($v); $arr_data = array( 'parentid' =>2, 'catname' =>$arr[2], 'listorder' =>$arr[3], 'htmldir' =>pinyin::get($arr[2]), 'template' =>'archive/list_text.html', 'listtemplate' =>'archive/list_text.html', 'showtemplate' =>0, 'includecatarchives'=>1, 'ispages' =>1, 'ishtml' =>0, 'includecatarchives'=>1, 'thumb_width' =>0, 'thumb_height' =>0, 'isnav' =>0, //是否在导航栏显示字段 ); $id = put_into_db($d_prefix.'b_category',$arr_data); $cat_id['news_cat'][$arr[0]] = $id; if($id) $total_num++; } continue; } //如果是news_con表,则选择对应数据插入archive中 if(strstr($row,$s_prefix.'news_con')){ foreach($tmp_arr as $v){ $arr = super_explode($v); $arr_data = array( 'catid' =>isset($cat_id['news_cat'][$arr[1]]) ? $cat_id['news_cat'][$arr[1]] : -1 , 'title' =>$arr[5], 'tag' =>$arr[46], 'username' =>$user_info['username'], 'userid' =>$user_info['userid'], 'view' =>0,//确认首页是以文本版面显示 'spid' =>0, 'keyword' =>$arr[46], 'listorder' =>0, 'adddate' =>date('Y-m-d H:i:s',$arr[16]), 'author' =>$arr[17], 'thumb' =>'',//列表显示的图片 'state' =>1, 'checked' =>1, 'introduce' =>$arr[22], 'introduce_len'=>200, 'content' =>$arr[6], 'template' =>0, 'ishtml' =>0, 'attr2' =>'',//产品金额 'pics' =>'a:0:{}', 'city_id' =>0, 'section_id' =>0, ); $id = put_into_db($d_prefix.'archive',$arr_data); if($id) $total_num++; } continue; } //如果是down_cat表,则选择对应数据插入b_category中 if(strstr($row,$s_prefix.'down_cat')){ foreach($tmp_arr as $v){ $arr = super_explode($v); $arr_data = array( 'parentid' =>6, 'catname' =>$arr[2], 'listorder' =>$arr[3], 'htmldir' =>pinyin::get($arr[2]), 'template' =>'archive/list_down.html', 'listtemplate' =>'archive/list_down.html', 'showtemplate' =>0, 'includecatarchives'=>1, 'ispages' =>1, 'ishtml' =>0, 'includecatarchives'=>1, 'thumb_width' =>0, 'thumb_height' =>0, 'isnav' =>0, //是否在导航栏显示字段 ); $id = put_into_db($d_prefix.'b_category',$arr_data); $cat_id['down_cat'][$arr[0]] = $id; if($id) $total_num++; } continue; } //如果是down_con表,则选择对应数据插入archive中 if(strstr($row,$s_prefix.'down_con')){ foreach($tmp_arr as $v){ $arr = super_explode($v); $arr_data = array( 'catid' =>isset($cat_id['down_cat'][$arr[1]]) ? $cat_id['down_cat'][$arr[1]] : -1 , 'title' =>$arr[5], 'tag' =>$arr[45], 'username' =>$user_info['username'], 'userid' =>$user_info['userid'], 'view' =>0,//确认首页是以文本版面显示 'spid' =>0, 'keyword' =>$arr[45], 'listorder' =>0, 'adddate' =>date('Y-m-d H:i:s',$arr[16]), 'author' =>$arr[17], 'thumb' =>'',//列表显示的图片 'state' =>1, 'checked' =>1, 'introduce' =>$arr[22], 'introduce_len'=>200, 'content' =>$arr[6], 'template' =>0, 'ishtml' =>0, 'linkto' =>$arr[43], 'attr1' =>$arr[44],//存放文件被下载的次数 'pics' =>'a:1:{i:0;s:0:"";}', 'city_id' =>0, 'section_id' =>0, ); $id = put_into_db($d_prefix.'archive',$arr_data); if($id) $total_num++; } continue; } //如果是photo_cat表,则选择对应数据插入b_category中 if(strstr($row,$s_prefix.'photo_cat')){ foreach($tmp_arr as $v){ $arr = super_explode($v); $arr_data = array( 'parentid' =>2, 'catname' =>$arr[2], 'listorder' => $arr[3], 'htmldir' =>pinyin::get($arr[2]), 'template' =>'archive/list_text.html', 'listtemplate' =>'archive/list_text.html', 'showtemplate' =>0, 'includecatarchives'=>1, 'ispages' =>1, 'ishtml' =>0, 'includecatarchives'=>1, 'thumb_width' =>0, 'thumb_height' =>0, 'isnav' =>0, //是否在导航栏显示字段 ); $id = put_into_db($d_prefix.'b_category',$arr_data); $cat_id['photo_cat'][$arr[0]] = $id; if($id) $total_num++; } continue; } //如果是photo_con表,则选择对应数据插入archive中 if(strstr($row,$s_prefix.'photo_con')){ foreach($tmp_arr as $v){ $arr = super_explode($v); $arr_data = array( 'catid' =>isset($cat_id['photo_cat'][$arr[1]]) ? $cat_id['photo_cat'][$arr[1]] : -1 , 'title' =>$arr[5], 'tag' =>$arr[22], 'username' =>$user_info['username'], 'userid' =>$user_info['userid'], 'view' =>0,//确认首页是以文本版面显示 'spid' =>0, 'keyword' =>$arr[22], 'listorder' =>0, 'adddate' =>date('Y-m-d H:i:s',$arr[16]), 'author' =>$arr[17], 'image' =>$arr[15],//列表显示的图片 'state' =>1, 'checked' =>1, 'introduce' =>$arr[22], 'introduce_len'=>200, 'content' =>$arr[6], 'template' =>0, 'ishtml' =>0, 'attr2' =>'',//产品金额 'pics' =>'a:0:{}', 'city_id' =>0, 'section_id' =>0, ); $id = put_into_db($d_prefix.'archive',$arr_data); if($id) $total_num++; } continue; } } front::flash('已共插入'.$total_num.'条数据'); } }
echo '<td width="19%" align="right">调用置顶内容<td width="1%"> </td><td width="70%">'; echo form::select('istop', $tag_config['istop'], array( '1'=>'是', '0'=>'否', )); echo "</td></tr><tr onmouseover=this.bgColor='#FFFFF0'; onmouseout=this.bgColor=''; bgcolor=''>"; echo '<td width="19%" align="right">调用记录条数<td width="1%"> </td><td width="70%">'; echo form::input('limit', $tag_config['limit'], 'class="input_c"'); echo "</td></tr><tr onmouseover=this.bgColor='#FFFFF0'; onmouseout=this.bgColor=''; bgcolor=''>"; echo '<td width="19%" align="right">缩略图<td width="1%"> </td><td width="70%">'; if($tag_config['thumb'] == 'on') $checked = 'checked'; echo '<input type="checkbox" name="thumb" id="thumb" '.$checked.' />'; echo "</td></tr><tr onmouseover=this.bgColor='#FFFFF0'; onmouseout=this.bgColor=''; bgcolor=''>"; echo '<td width="19%" align="right">推荐位<td width="1%"> </td><td width="70%">'; $set=settings::getInstance(); $sets=$set->getrow(array('tag'=>'table-archive')); $ds=unserialize($sets['value']); preg_match_all('%\(([\d\w\/\.-]+)\)(\S+)%s',$ds['attr1'],$result,PREG_SET_ORDER); $sdata=array(); foreach ($result as $res) $sdata[$res[1]]=$res[2]; echo form::select('attr1', $tag_config['attr1'], $sdata); echo "</td></tr><tr onmouseover=this.bgColor='#FFFFF0'; onmouseout=this.bgColor=''; bgcolor=''>"; echo '<td width="19%" align="right">标签模板<td width="1%"> </td><td width="70%">'; echo form::select('tagtemplate', $tag_config['tagtemplate'], $tplarray); echo '<span class="hotspot" onmouseover="tooltip.show(\'标签模板文件存放在 template/当前使用模板目录/tpltag/tag_content_*.html!\');" onmouseout="tooltip.hide();"><img src="images/remind.gif" alt="" width="14" height="20" style="margin-left:10px; margin-right:5px;"></span><br/><div style="display:none">'; //echo form::getform('tagcontent',$form,$field,$data); echo form::textarea('tagcontent', 'null', 'cols="70" rows="20"'); echo '</td></tr>';