function Province()
{
$pid = (int) $this->Get['pid'];
if ($pid) {
$province_ary = DB::fetch_first("SELECT *\r\n\t\t\t\t\t\tFROM " . DB::table('common_district') . "\r\n\t\t\t\t\t\twhere `id` = '{$pid}' ");
$categoryname = $province_ary['name'];
$province_where_list = "where `upid` = 0";
$province_ary = $this->ValidateLogic->CategoryCityList($province_where_list);
$city_where_list = "where `upid` = '{$pid}'";
$is_check_user = 1;
$city_ary = $this->ValidateLogic->CategoryCityList($city_where_list, $is_check_user);
$config = jconf::get();
$people_config = $config['validate_people_setting'];
$where = "where `is_push` = 2";
$limit = $people_config['proviect_user_limit'] ? $people_config['proviect_user_limit'] : 20;
$members_arr = $this->ValidateLogic->CategoryUserList($where, $limit, $people_config['proviect_user_orderby']);
$member_list = $members_arr['member'];
$member_uids = $members_arr['uids'];
Load::logic("topic_list");
$TopicListLogic = new TopicListLogic($this);
$per_page_num = $people_config['proviect_topic_limit'] ? $people_config['proviect_topic_limit'] : 10;
$query_link = "index.php?mod=" . ($_GET['mod_original'] ? get_safe_code($_GET['mod_original']) : $this->Module) . ($this->Code ? "&code={$this->Code}&d={$d}" : "");
$options = array('perpage' => $per_page_num, 'page_url' => $query_link, 'type' => 'first', 'where' => " `uid` in('" . implode("','", $member_uids) . "') ", 'order' => "`dateline` DESC ");
$topic_list = $TopicListLogic->get_data($options);
if (!empty($topic_list)) {
$page_arr = $topic_list['page'];
$topics = $topic_list['list'];
$total_record = $topic_list['count'];
}
$limit = 9;
if ($city_ary) {
foreach ($city_ary as $row) {
$where_list['city'] = build_like_query('city', $row['name']);
$where = ' where ' . implode(' AND ', $where_list) . ' and `validate` !="" order by `fans_count` desc limit 0,9';
$_list = $this->TopicLogic->GetMember($where, "`uid`,`ucuid`,`city`,`username`,`aboutme`,`nickname`,`face_url`,`face`,`validate`,`validate_category`");
if ($_list) {
foreach ($_list as $row) {
$row['validate_html'] = $row['validate_html'];
$members[] = $row;
}
}
}
}
}
$this->Title = "名人堂";
include template("people/people_province_view");
}
function View()
{
$uid = MEMBER_ID;
$member = $this->_topicLogicGetMember($uid);
$params = array();
$tag = get_safe_code($this->Code);
if (!$tag) {
$this->Messager("请输入正确的链接地址", null);
}
$f_rets = filter($tag, 0, 0);
if ($f_rets && $f_rets['error']) {
$this->Messager("输入的话题 " . $f_rets['msg'], null);
}
$sql = "select * from `" . TABLE_PREFIX . "tag` where `name`='" . addslashes($tag) . "'";
$query = $this->DatabaseHandler->Query($sql);
$tag_info = $query->GetRow();
$tag_id = $tag_info['id'];
$total_record = $tag_info['topic_count'];
$this->TopicLogic = jlogic('topic');
if ($total_record > 0) {
$params['tag_id'] = $tag_id;
$query_link = "index.php?mod=" . ($_GET['mod_original'] ? get_safe_code($_GET['mod_original']) : $this->Module) . ($tag ? "&code=" . urlencode($tag) : "");
$per_page_num = 10;
$page_arr = wap_page($total_record, $per_page_num, $query_link, array('return' => "Array"));
$sql = "select `item_id` from `" . TABLE_PREFIX . "topic_tag` where `tag_id`='{$tag_id}' order by `item_id` desc {$page_arr['limit']}";
$query = $this->DatabaseHandler->Query($sql);
$topic_ids = array();
while (false != ($row = $query->GetRow())) {
$topic_ids[$row['item_id']] = $row['item_id'];
}
Load::logic("topic_list");
$TopicListLogic = new TopicListLogic();
$options = array('limit' => $per_page_num, 'order' => " dateline DESC ", 'type' => get_topic_type(), 'tid' => $topic_ids);
$info = $TopicListLogic->get_data($options, 'wap');
$topic_list = array();
if (!empty($info)) {
$topic_list = wap_iconv($info['list']);
}
$topic_list_count = 0;
if ($topic_list) {
$parent_id_list = array();
foreach ($topic_list as $row) {
if (0 < ($p = (int) $row['parent_id'])) {
$parent_id_list[$p] = $p;
}
if (0 < ($p = (int) $row['top_parent_id'])) {
$parent_id_list[$p] = $p;
}
unset($topic_ids[$row['tid']]);
$topic_list_count++;
}
if ($topic_ids) {
$topic_ids_count = count($topic_ids);
$total_record = $total_record - $topic_ids_count;
$sql = "delete from `" . TABLE_PREFIX . "topic_tag` where `item_id` in('" . implode("','", $topic_ids) . "')";
$this->DatabaseHandler->Query($sql);
$sql = "update `" . TABLE_PREFIX . "tag` set `topic_count`=`topic_count`-{$topic_ids_count} where `id`='{$tag_info['id']}'";
if ($total_record >= 0 && $tag_info) {
$this->DatabaseHandler->Query($sql);
}
}
if ($parent_id_list) {
$parent_list = $this->_topicLogicGet($parent_id_list);
}
}
}
$show_config = jconf::get('show');
$is_favorite = false;
if ($tag_info) {
if (MEMBER_ID > 0) {
$is_favorite = jlogic('tag_favorite')->info($tag, MEMBER_ID);
}
$tag_favorite_list = jlogic('tag_favorite')->favorite_users($tag, 12, '`uid`, `username`, `nickname`, `face_url`, `face`, `ucuid`');
}
$tag = wap_iconv($tag);
$tag_value = '#' . $tag . '#';
$topic_count = $tag_info['topic_count'];
$this->Title = $tag;
include template('tag_list_topic_box');
}
function View()
{
$params = array();
$content_dstr = $this->Config['in_publish_notice_str'];
$content_ostr = $this->Config['on_publish_notice_str'];
$tag = get_safe_code($this->Code);
if (!$tag) {
$this->Messager("请输入正确的链接地址", null);
}
$f_rets = filter($tag, 0, 0);
if ($f_rets && $f_rets['error']) {
$this->Messager("输入的话题 " . $f_rets['msg'], null);
}
$sql = "select * from `" . TABLE_PREFIX . "tag` where `name`='" . addslashes($tag) . "'";
$query = $this->DatabaseHandler->Query($sql);
$tag_info = $query->GetRow();
$tag_id = $tag_info['id'];
$total_record = $tag_info['topic_count'];
$tag_count = $tag_info['tag_count'];
$TopicLogic = jlogic('topic');
Load::logic("topic_list");
$TopicListLogic = new TopicListLogic();
$params['tag_id'] = $tag_id;
$this->Get['type'] = in_array($this->Get['type'], array('pic', 'video', 'music')) ? $this->Get['type'] : '';
$gets = array('mod' => $_GET['mod_original'] ? get_safe_code($_GET['mod_original']) : $this->Module, 'code' => $this->Code ? $tag : "", 'type' => $this->Get['type'], 'view' => $this->Get['view']);
$query_link = "index.php?" . url_implode($gets);
unset($gets['type']);
$type_url = "index.php?" . url_implode($gets);
$per_page_num = max(0, (int) $this->ShowConfig['tag_view']['tag']);
$options = array('type' => get_topic_type(), 'filter' => $this->Get['type']);
$view = trim($this->Get['view']);
if ($tag_id > 0 && $per_page_num > 0) {
if ($view == 'recd') {
$p = array('where' => " tr.recd <= 2 AND tr.item='tag' AND tr.item_id='{$tag_id}' ", 'perpage' => $per_page_num, 'filter' => $this->Get['type']);
$info = $TopicListLogic->get_recd_list($p);
if (!empty($info)) {
$total_record = $info['count'];
$topic_list = $info['list'];
$page_arr = $info['page'];
}
} else {
if (empty($this->Get['type'])) {
$rets = jtable('topic_tag')->get_ids(array('tag_id' => $tag_id, 'sql_order' => ' `item_id` DESC ', 'result_count' => $total_record, 'per_page_num' => $per_page_num, 'page_url' => $query_link), 'item_id', 1);
$total_record = $rets['count'];
$page_arr = $rets['page'];
$topic_list = $total_record > 0 && $rets['ids'] ? $TopicLogic->Get($rets['ids']) : array();
} else {
$sql = "select `item_id` from `" . TABLE_PREFIX . "topic_tag` where `tag_id`='{$tag_id}' order by `item_id` desc LIMIT 2000 ";
$query = $this->DatabaseHandler->Query($sql);
$topic_ids = array();
while (false != ($row = $query->GetRow())) {
$topic_ids[$row['item_id']] = $row['item_id'];
}
$options['tid'] = $topic_ids;
$options['filter'] = trim($this->Get['type']);
$options['page_url'] = $query_link;
$options['perpage'] = $per_page_num;
$info = $TopicListLogic->get_data($options);
$topic_list = array();
if (!empty($info)) {
$topic_list = $info['list'];
if (isset($info['page'])) {
$page_arr = $info['page'];
$total_record = $info['count'];
}
}
}
}
if ($topic_list) {
$parent_list = $TopicLogic->GetParentTopic($topic_list);
}
}
if (!$topic_list) {
$total_record = 0;
}
$show_config = jconf::get('show');
$day1_r_tags = cache_file('get', "misc/recommendTopicTag-1-{$show_config['topic_index']['hot_tag']}");
$day7_r_tags = cache_file('get', "misc/recommendTopicTag-7-{$show_config['topic_index']['hot_tag']}");
$is_favorite = false;
if ($tag_info) {
if (MEMBER_ID > 0) {
$is_favorite = jlogic('tag_favorite')->info($tag, MEMBER_ID);
}
$tag_favorite_count = jtable('tag_favorite')->count(array('tag' => $tag));
if ($tag_favorite_count > 0) {
$tag_favorite_list = jlogic('tag_favorite')->favorite_users($tag, 12);
}
}
$my_favorite_tags = jlogic('tag_favorite')->my_favorite(MEMBER_ID, 12);
$tag_extra = array();
if ($tag_info && $tag_info['extra']) {
Load::logic('tag_extra');
$TagExtraLogic = new TagExtraLogic();
$tag_extra_info = $TagExtraLogic->get_info($tag_info['id']);
$tag_extra = $tag_extra_info['data'];
}
$_GET['searchKeyword'] = $this->Title = $tag;
$this->MetaKeywords = $tag;
$content = "#{$tag}#";
if (MEMBER_ID > 0) {
$member = jsg_member_info(MEMBER_ID);
if ($member['medal_id']) {
$medal_list = $this->TopicLogic->GetMedal($member['medal_id'], $member['uid']);
}
}
include template('tag/tag_list_topic_box');
}
