Example #1
0
 public function index_action()
 {
     $_GET['per_page'] = $_GET['per_page'] ? intval($_GET['per_page']) : get_setting('contents_per_page');
     $result = $this->model('search')->search(cjk_substr($_GET['q'], 0, 64), $_GET['type'], $_GET['page'], $_GET['per_page'], $_GET['topic_ids'], $_GET['is_recommend']);
     if (!$result) {
         $result = array();
     }
     if ($_GET['is_question_id'] and is_digits($_GET['q'])) {
         $question_info = $this->model('question')->get_question_info_by_id($_GET['q']);
         if ($question_info) {
             $result[] = $this->model('search')->prase_result_info($question_info);
         }
     }
     if ($result) {
         $key_arr = array('type', 'search_id', 'name', 'detail');
         foreach ($result as $key => $val) {
             foreach ($val as $k => $v) {
                 if (!in_array($k, $key_arr)) {
                     unset($result[$key][$k]);
                 }
             }
         }
     }
     H::ajax_json_output(AWS_APP::RSM(array('total_rows' => count($result), 'rows' => $result), 1, null));
 }
Example #2
0
 function refresh_access_token($id, $sina_token)
 {
     if (!is_digits($id) or empty($sina_token['access_token'])) {
         return false;
     }
     return $this->update('users_sina', array('access_token' => $sina_token['access_token'], 'expires_time' => time() + $sina_token['expires_in']), 'id = ' . $id);
 }
Example #3
0
 public function set_slide_sort($id, $order)
 {
     if (!is_digits($id) or !is_digits($order) or $order < 0 or $order > 99) {
         return false;
     }
     return $this->update('slide', array('order' => intval($order)), 'id = ' . intval($id));
 }
Example #4
0
 public function index_action()
 {
     if (is_digits($_GET['id'])) {
         $feature_info = $this->model('feature')->get_feature_by_id($_GET['id']);
     } else {
         $feature_info = $this->model('feature')->get_feature_by_url_token($_GET['id']);
     }
     if (!$feature_info) {
         header('HTTP/1.1 404 Not Found');
         H::redirect_msg(AWS_APP::lang()->_t('专题不存在'), '/');
     }
     if (!$feature_info['enabled']) {
         H::redirect_msg(AWS_APP::lang()->_t('专题未启用'), '/');
     }
     if ($feature_info['url_token'] != $_GET['id'] and !$_GET['sort_type'] and !$_GET['is_recommend']) {
         HTTP::redirect('/feature/' . $feature_info['url_token']);
     }
     if (!($topic_list = $this->model('topic')->get_topics_by_ids($this->model('feature')->get_topics_by_feature_id($feature_info['id'])))) {
         H::redirect_msg(AWS_APP::lang()->_t('专题下必须包含一个以上话题'), '/');
     }
     if ($feature_info['seo_title']) {
         TPL::assign('page_title', $feature_info['seo_title']);
     } else {
         $this->crumb($feature_info['title'], '/feature/' . $feature_info['url_token']);
     }
     TPL::assign('sidebar_hot_topics', $topic_list);
     TPL::assign('feature_info', $feature_info);
     TPL::import_js('js/app/feature.js');
     TPL::output('feature/detail');
 }
Example #5
0
 public function index_action()
 {
     if (isset($_GET['notification_id'])) {
         $this->model('notify')->read_notification($_GET['notification_id'], $this->user_id);
     }
     if (is_mobile()) {
         HTTP::redirect('/m/people/' . $_GET['id']);
     }
     if (is_digits($_GET['id'])) {
         if (!($user = $this->model('account')->get_user_info_by_uid($_GET['id'], TRUE))) {
             $user = $this->model('account')->get_user_info_by_username($_GET['id'], TRUE);
         }
     } else {
         if ($user = $this->model('account')->get_user_info_by_username($_GET['id'], TRUE)) {
         } else {
             $user = $this->model('account')->get_user_info_by_url_token($_GET['id'], TRUE);
         }
     }
     if (!$user) {
         header('HTTP/1.1 404 Not Found');
         H::redirect_msg(AWS_APP::lang()->_t('用户不存在'), '/');
     }
     if ($user['forbidden'] and !$this->user_info['permission']['is_administortar'] and !$this->user_info['permission']['is_moderator']) {
         header('HTTP/1.1 404 Not Found');
         H::redirect_msg(AWS_APP::lang()->_t('该用户已被封禁'), '/');
     }
     if (urldecode($user['url_token']) != $_GET['id']) {
         HTTP::redirect('/people/' . $user['url_token']);
     }
     $this->model('people')->update_views($user['uid']);
     TPL::assign('user', $user);
     $job_info = $this->model('account')->get_jobs_by_id($user['job_id']);
     TPL::assign('job_name', $job_info['job_name']);
     if ($user['weibo_visit']) {
         if ($users_sina = $this->model('openid_weibo_oauth')->get_weibo_user_by_uid($user['uid'])) {
             TPL::assign('sina_weibo_url', 'http://www.weibo.com/' . $users_sina['id']);
         }
     }
     TPL::assign('education_experience_list', $this->model('education')->get_education_experience_list($user['uid']));
     $jobs_list = $this->model('work')->get_jobs_list();
     if ($work_experience_list = $this->model('work')->get_work_experience_list($user['uid'])) {
         foreach ($work_experience_list as $key => $val) {
             $work_experience_list[$key]['job_name'] = $jobs_list[$val['job_id']];
         }
     }
     TPL::assign('work_experience_list', $work_experience_list);
     TPL::assign('user_follow_check', $this->model('follow')->user_follow_check($this->user_id, $user['uid']));
     $this->crumb(AWS_APP::lang()->_t('%s 的个人主页', $user['user_name']), 'people/' . $user['url_token']);
     TPL::import_css('css/user.css');
     TPL::assign('reputation_topics', $this->model('people')->get_user_reputation_topic($user['uid'], $user['reputation'], 12));
     TPL::assign('fans_list', $this->model('follow')->get_user_fans($user['uid'], 5));
     TPL::assign('friends_list', $this->model('follow')->get_user_friends($user['uid'], 5));
     TPL::assign('focus_topics', $this->model('topic')->get_focus_topic_list($user['uid'], 10));
     TPL::assign('user_actions_questions', $this->model('actions')->get_user_actions($user['uid'], 5, ACTION_LOG::ADD_QUESTION, $this->user_id));
     TPL::assign('user_actions_answers', $this->model('actions')->get_user_actions($user['uid'], 5, ACTION_LOG::ANSWER_QUESTION, $this->user_id));
     TPL::assign('user_actions', $this->model('actions')->get_user_actions($user['uid'], 5, implode(',', array(ACTION_LOG::ADD_QUESTION, ACTION_LOG::ANSWER_QUESTION, ACTION_LOG::ADD_REQUESTION_FOCUS, ACTION_LOG::ADD_AGREE, ACTION_LOG::ADD_TOPIC, ACTION_LOG::ADD_TOPIC_FOCUS, ACTION_LOG::ADD_ARTICLE)), $this->user_id));
     TPL::output('people/index');
 }
Example #6
0
 public function send($email, $subject, $message, $link = null, $link_title = null, $server = 'master')
 {
     if (is_digits($email)) {
         if (!($user_info = $this->model('account')->get_user_info_by_uid($email))) {
             return false;
         }
         $user_name = $user_info['user_name'];
         $email = $user_info['email'];
     }
     return AWS_APP::mail()->send($email, $subject, $this->get_mail_template($user_name, $subject, $message, $link, $link_title), get_setting('site_name'), $user_name, $server);
 }
Example #7
0
 public function get_article_info_by_id($article_id)
 {
     if (!is_digits($article_id)) {
         return false;
     }
     static $articles;
     if (!$articles[$article_id]) {
         $articles[$article_id] = $this->fetch_row('article', 'id = ' . $article_id);
     }
     return $articles[$article_id];
 }
Example #8
0
File: common.php Project: steem/qwp
function get_joined_digits(&$v, &$ids)
{
    $ids = explode(',', $v);
    if (count($ids) === 0) {
        return false;
    }
    foreach ($ids as $id) {
        if (!is_digits($id)) {
            return false;
        }
    }
    return true;
}
Example #9
0
 public function search_action()
 {
     $result = $this->model('search')->search(cjk_substr($_GET['q'], 0, 64), $_GET['type'], 1, $_GET['limit'], $_GET['topic_ids'], $_GET['is_recommend']);
     if (!$result) {
         $result = array();
     }
     if ($_GET['is_question_id'] and is_digits($_GET['q'])) {
         $question_info = $this->model('question')->get_question_info_by_id($_GET['q']);
         if ($question_info) {
             $result[] = $this->model('search')->prase_result_info($question_info);
         }
     }
     H::ajax_json_output($result);
 }
Example #10
0
function list_users(&$msg, &$data)
{
    get_user_data_modal($user_modal);
    $user_id = P('id');
    $options = array('data modal' => $user_modal, 'left join' => array(array('qwp_role', 'r', 'r.id=u.role')), 'where' => 'u.id<>1 and role<>1');
    if ($user_id) {
        $data = array();
        if ($user_id != '1' && is_digits($user_id)) {
            $options['where'] .= ' and u.id=' . $user_id;
            qwp_db_get_data(array('qwp_user', 'u'), $data, null, $options);
        }
    } else {
        $options['default order'] = array('role', array('id', 'desc'));
        $options['search condition'] = array('condition' => array('fields' => array('u.name' => 'like', 'avatar' => 'set_avatar_condition', 'gender' => array('s' => array('<>', 'x'))), 'condition' => array('op' => 'or', 'fields' => array('phone' => 'like', 'account' => 'like', 'email' => 'like', 'name' => 'like'))));
        $options['search converter'] = 'convert_search_data';
        qwp_db_retrieve_data(array('qwp_user', 'u'), $data, $options);
    }
}
 public static function save_action($uid, $associate_id, $action_type, $action_id, $action_content = null, $action_attch = null, $add_time = null, $anonymous = null, $addon_data = null)
 {
     if (!$uid or !$associate_id) {
         return false;
     }
     if (is_digits($action_attch)) {
         $action_attch_insert = $action_attch;
     } else {
         $action_attch_insert = '-1';
         $action_attch_update = $action_attch;
     }
     if (!$add_time) {
         $add_time = time();
     }
     $history_id = AWS_APP::model()->insert('user_action_history', array('uid' => intval($uid), 'associate_type' => $action_type, 'associate_action' => $action_id, 'associate_id' => $associate_id, 'associate_attached' => $action_attch_insert, 'add_time' => $add_time, 'anonymous' => intval($anonymous)));
     AWS_APP::model()->insert('user_action_history_data', array('history_id' => $history_id, 'associate_content' => htmlspecialchars($action_content), 'associate_attached' => htmlspecialchars($action_attch_update), 'addon_data' => $addon_data ? serialize($addon_data) : ''));
     self::associate_fresh_action($history_id, $associate_id, $action_type, $action_id, $uid, $anonymous, $add_time);
     return $history_id;
 }
Example #12
0
 public function update_third_party_login($id = null, $action, $name, $url, $token, $enabled = null, $account_id = null, $rank = null)
 {
     if ($action == 'update' and !is_digits($id) or $action == 'add' and !is_digits($account_id)) {
         return false;
     }
     $to_save_rule = array();
     if ($name) {
         $to_save_rule['name'] = $name;
     }
     if ($url) {
         $to_save_rule['url'] = $url;
     }
     if ($token) {
         $to_save_rule['token'] = $token;
     }
     if ($enabled !== null) {
         if ($enabled == 1) {
             $to_save_rule['enabled'] = '1';
         } else {
             $to_save_rule['enabled'] = '0';
         }
     }
     if (is_digits($account_id)) {
         $to_save_rule['account_id'] = $account_id;
     }
     if (is_digits($rank) and $rank >= 0 and $rank <= 99) {
         $to_save_rule['rank'] = $rank;
     }
     switch ($action) {
         case 'add':
             return $this->insert('weixin_third_party_login', $to_save_rule);
             break;
         case 'update':
             return $this->update('weixin_third_party_login', $to_save_rule, 'id = ' . $id);
             break;
         default:
             return false;
             break;
     }
 }
Example #13
0
 /**
  *
  * 增加问题内容
  * @param string $question_content //问题内容
  * @param string $question_detail  //问题说明
  *
  * @return boolean true|false
  */
 public function save_question($question_content, $question_detail, $published_uid, $question_difficulty, $quiz_id, $anonymous = 0, $ip_address = null, $from = null)
 {
     if (!$ip_address) {
         $ip_address = fetch_ip();
     }
     $now = time();
     $to_save_question = array('question_content' => htmlspecialchars($question_content), 'question_detail' => htmlspecialchars($question_detail), 'add_time' => $now, 'update_time' => $now, 'published_uid' => intval($published_uid), 'difficulty' => intval($question_difficulty), 'quiz_id' => intval($quiz_id), 'anonymous' => intval($anonymous), 'ip' => ip2long($ip_address));
     if ($from and is_array($from)) {
         foreach ($from as $type => $from_id) {
             if (!is_digits($from_id)) {
                 continue;
             }
             $to_save_question[$type . '_id'] = $from_id;
         }
     }
     $question_id = $this->insert('question', $to_save_question);
     if ($question_id) {
         $this->shutdown_update('users', array('question_count' => $this->count('question', 'published_uid = ' . intval($published_uid))), 'uid = ' . intval($published_uid));
         $this->model('search_fulltext')->push_index('question', $question_content, $question_id);
     }
     return $question_id;
 }
Example #14
0
function remove_assoc($from, $type, $id)
{
    if (!$from or !$type or !is_digits($id)) {
        return false;
    }
    return $this->query('UPDATE ' . $this->get_table($from) . ' SET `' . $type . '_id` = NULL WHERE `' . $type . '_id` = ' . $id);
}
Example #15
0
 public function check_username_char($user_name)
 {
     if (is_digits($user_name)) {
         return AWS_APP::lang()->_t('用户名不能为纯数字');
     }
     if (strstr($user_name, '-')) {
         return AWS_APP::lang()->_t('用户名不能包含 -');
     }
     $length = strlen(convert_encoding($user_name, 'UTF-8', 'GB2312'));
     $length_min = intval(get_setting('username_length_min'));
     $length_max = intval(get_setting('username_length_max'));
     if ($length < $length_min || $length > $length_max) {
         $flag = true;
     }
     switch (get_setting('username_rule')) {
         default:
             break;
         case 1:
             if (!preg_match('/^[\\x{4e00}-\\x{9fa5}_a-zA-Z0-9]+$/u', $user_name) or $flag) {
                 return AWS_APP::lang()->_t('请输入大于 %s 字节的用户名, 允许汉字、字母与数字', $length_min . ' - ' . $length_max);
             }
             break;
         case 2:
             if (!preg_match("/^[a-zA-Z0-9_]+\$/i", $user_name) or $flag) {
                 return AWS_APP::lang()->_t('请输入 %s 个字母、数字或下划线', $length_min . ' - ' . $length_max);
             }
             break;
         case 3:
             if (!preg_match("/^[\\x{4e00}-\\x{9fa5}]+\$/u", $user_name) or $flag) {
                 return AWS_APP::lang()->_t('请输入 %s 个汉字', ceil($length_min / 2) . ' - ' . floor($length_max / 2));
             }
             break;
     }
     return false;
 }
Example #16
0
 public function index_square_action()
 {
     $this->crumb(AWS_APP::lang()->_t('问题'), '/question/');
     // 导航
     if (TPL::is_output('block/content_nav_menu.tpl.htm', 'question/square')) {
         TPL::assign('content_nav_menu', $this->model('menu')->get_nav_menu_list('question'));
     }
     //边栏可能感兴趣的人
     if (TPL::is_output('block/sidebar_recommend_users_topics.tpl.htm', 'question/square')) {
         TPL::assign('sidebar_recommend_users_topics', $this->model('module')->recommend_users_topics($this->user_id));
     }
     //边栏热门用户
     if (TPL::is_output('block/sidebar_hot_users.tpl.htm', 'question/square')) {
         TPL::assign('sidebar_hot_users', $this->model('module')->sidebar_hot_users($this->user_id, 5));
     }
     //边栏热门话题
     if (TPL::is_output('block/sidebar_hot_topics.tpl.htm', 'question/square')) {
         TPL::assign('sidebar_hot_topics', $this->model('module')->sidebar_hot_topics($_GET['category']));
     }
     //边栏专题
     if (TPL::is_output('block/sidebar_feature.tpl.htm', 'question/square')) {
         TPL::assign('feature_list', $this->model('module')->feature_list());
     }
     if ($_GET['category']) {
         if (is_digits($_GET['category'])) {
             $category_info = $this->model('system')->get_category_info($_GET['category']);
         } else {
             $category_info = $this->model('system')->get_category_info_by_url_token($_GET['category']);
         }
     }
     if ($category_info) {
         TPL::assign('category_info', $category_info);
         $this->crumb($category_info['title'], '/question/category-' . $category_info['id']);
         $meta_description = $category_info['title'];
         if ($category_info['description']) {
             $meta_description .= ' - ' . $category_info['description'];
         }
         TPL::set_meta('description', $meta_description);
     }
     if ($_GET['feature_id']) {
         $feature_info = $this->model('feature')->get_feature_by_id($_GET['feature_id']);
         TPL::assign('feature_info', $feature_info);
     }
     if ($feature_info['id']) {
         $topic_ids = $this->model('feature')->get_topics_by_feature_id($feature_info['id']);
     }
     if (!$_GET['sort_type']) {
         $_GET['sort_type'] = 'new';
     }
     if ($_GET['sort_type'] == 'hot') {
         $question_list = $this->model('posts')->get_hot_posts('question', $category_info['id'], $topic_ids, $_GET['day'], $_GET['page'], get_setting('contents_per_page'));
     } else {
         $question_list = $this->model('posts')->get_posts_list('question', $_GET['page'], get_setting('contents_per_page'), $_GET['sort_type'], $topic_ids, $category_info['id'], $_GET['answer_count'], $_GET['day'], $_GET['is_recommend']);
     }
     if ($question_list) {
         foreach ($question_list as $key => $val) {
             if ($val['answer_count']) {
                 $question_list[$key]['answer_users'] = $this->model('question')->get_answer_users_by_question_id($val['question_id'], 2, $val['published_uid']);
             }
         }
     }
     TPL::assign('pagination', AWS_APP::pagination()->initialize(array('base_url' => get_js_url('/question/sort_type-' . preg_replace("/[\\(\\)\\.;']/", '', $_GET['sort_type']) . '__category-' . $category_info['id'] . '__day-' . intval($_GET['day']) . '__is_recommend-' . $_GET['is_recommend']) . '__feature_id-' . $feature_info['id'], 'total_rows' => $this->model('posts')->get_posts_list_total(), 'per_page' => get_setting('contents_per_page')))->create_links());
     TPL::assign('posts_list', $question_list);
     TPL::assign('question_list_bit', TPL::output('explore/ajax/list', false));
     TPL::output('question/square');
 }
Example #17
0
 public function topic_action()
 {
     if (is_digits($_GET['id'])) {
         if (!($topic_info = $this->model('topic')->get_topic_by_id($_GET['id']))) {
             $topic_info = $this->model('topic')->get_topic_by_title($_GET['id']);
         }
     } else {
         if (!($topic_info = $this->model('topic')->get_topic_by_title($_GET['id']))) {
             $topic_info = $this->model('topic')->get_topic_by_url_token($_GET['id']);
         }
     }
     if (!$topic_info) {
         H::redirect_msg(AWS_APP::lang()->_t('话题不存在'), '/m/');
     }
     if ($topic_info['merged_id']) {
         if ($this->model('topic')->get_topic_by_id($topic_info['merged_id'])) {
             HTTP::redirect('/m/topic/' . $topic_info['merged_id'] . '?rf=' . $topic_info['topic_id']);
         } else {
             $this->model('topic')->remove_merge_topic($topic_info['topic_id'], $topic_info['merged_id']);
         }
     }
     if (urldecode($topic_info['url_token']) != $_GET['id']) {
         HTTP::redirect('/m/topic/' . $topic_info['url_token'] . '?rf=' . $_GET['rf']);
     }
     if (is_digits($_GET['rf']) and $_GET['rf']) {
         if ($from_topic = $this->model('topic')->get_topic_by_id($_GET['rf'])) {
             $redirect_message[] = AWS_APP::lang()->_t('话题 (%s) 已与当前话题合并', $from_topic['topic_title']);
         }
     }
     if ($merged_topics = $this->model('topic')->get_merged_topic_ids($topic_info['topic_id'])) {
         foreach ($merged_topics as $key => $val) {
             $merged_topic_ids[] = $val['source_id'];
         }
         $contents_topic_id = $topic_info['topic_id'] . ',' . implode(',', $merged_topic_ids);
         if ($merged_topics_info = $this->model('topic')->get_topics_by_ids($merged_topic_ids)) {
             foreach ($merged_topics_info as $key => $val) {
                 $contents_topic_title[] = $val['topic_title'];
             }
         }
         $contents_topic_title = $topic_info['topic_title'] . ',' . implode(',', $contents_topic_title);
     } else {
         $contents_topic_id = $topic_info['topic_id'];
         $contents_topic_title = $topic_info['topic_title'];
     }
     TPL::assign('contents_topic_id', $contents_topic_id);
     TPL::assign('contents_topic_title', $contents_topic_title);
     if ($this->user_id) {
         $topic_info['has_focus'] = $this->model('topic')->has_focus_topic($this->user_id, $topic_info['topic_id']);
     }
     TPL::assign('topic_info', $topic_info);
     $this->crumb(AWS_APP::lang()->_t('话题'), '/m/topic/');
     $this->crumb($topic_info['topic_title'], '/m/topic/' . $topic_info['topic_title']);
     TPL::assign('redirect_message', $redirect_message);
     TPL::assign('best_answer_users', $this->model('topic')->get_best_answer_users_by_topic_id($topic_info['topic_id'], 5));
     TPL::output('m/topic');
 }
Example #18
0
<?php

if (!defined('IN_ANWSION')) {
    die;
}
if (!is_digits($_GET['page'])) {
    $_GET['page'] = 1;
}
$user_list = $this->model('account')->fetch_page('users', null, 'uid ASC', $_GET['page'], 300);
if ($user_list) {
    foreach ($user_list as $user_info) {
        $article_count = $this->model('article')->count('article', 'uid = ' . $user_info['uid']);
        $this->model('account')->update('users', array('article_count' => $article_count), 'uid = ' . $user_info['uid']);
    }
    H::redirect_msg(AWS_APP::lang()->_t('正在升级数据库') . ', ' . AWS_APP::lang()->_t('批次: %s', $_GET['page']), '/upgrade/script/page-' . ($_GET['page'] + 1));
}
Example #19
0
 public function update_receiving_email_config($id = null, $action, $receiving_email_config = array())
 {
     if ($action == 'update' and !is_digits($id)) {
         return false;
     }
     switch ($action) {
         case 'add':
             return $this->insert('receiving_email_config', $receiving_email_config);
             break;
         case 'update':
             return $this->update('receiving_email_config', $receiving_email_config, 'id = ' . $id);
             break;
         default:
             return false;
             break;
     }
 }
Example #20
0
 public function remove_weixin_account($account_id)
 {
     if (!is_digits($account_id) or $account_id === 0 or $account_id === '0') {
         return false;
     }
     $this->delete('weixin_accounts', 'id = ' . $account_id);
     $reply_rules_info = $this->fetch_all('weixin_reply_rule', 'account_id = ' . $account_id);
     if ($reply_rules_info) {
         $this->delete('weixin_reply_rule', 'account_id = ' . $account_id);
         foreach ($reply_rules_info as $reply_rule_info) {
             if ($reply_rule_info['image_file']) {
                 unlink(get_setting('upload_dir') . '/weixin/' . $reply_rule_info['image_file']);
                 unlink(get_setting('upload_dir') . '/weixin/square_' . $reply_rule_info['image_file']);
             }
         }
     }
     $this->model('openid_weixin_third')->remove_third_party_api_by_account_id($account_id);
 }
Example #21
0
/**
 * 检查字符串或数组内的字符串是否为纯数字(十进制数字,不包括负数和小数)
 *
 * @param string or array
 * @return boolean
 */
function is_digits($num)
{
    if (!$num and $num !== '0') {
        return false;
    }
    if (is_array($num)) {
        foreach ($num as $val) {
            if (!is_digits($val)) {
                return false;
            }
        }
        return true;
    }
    return Zend_Validate::is($num, 'Digits');
}
Example #22
0
 public function update_attach($weibo_msg_id, $item_type, $item_id, $attach_access_key)
 {
     if (!is_digits($weibo_msg_id) or !is_digits($item_id) or !$attach_access_key) {
         return false;
     }
     $update_result = $this->update('attach', array('item_type' => $item_type, 'item_id' => $item_id), 'item_type = "weibo_msg" AND item_id = ' . $weibo_msg_id . ' AND access_key = "' . $this->quote($attach_access_key) . '"');
     $this->shutdown_update($item_type, array('has_attach' => 1), $item_type . '_id = ' . $item_id);
     return $update_result;
 }
Example #23
0
 public function get_facebook_user_by_uid($uid)
 {
     if (!is_digits($uid)) {
         return false;
     }
     static $facebook_user_info;
     if (!$facebook_user_info[$uid]) {
         $facebook_user_info[$uid] = $this->fetch_row('users_facebook', 'uid = ' . $uid);
     }
     return $facebook_user_info[$uid];
 }
Example #24
0
 public function get_google_user_by_uid($uid)
 {
     if (!is_digits($uid)) {
         return false;
     }
     static $google_user_info;
     if (!$google_user_info[$uid]) {
         $google_user_info[$uid] = $this->fetch_row('users_google', 'uid = ' . $uid);
     }
     return $google_user_info[$uid];
 }
 /**
  *
  * 阅读段信息
  * @param int $notification_id 信息id
  *
  * @return array信息内容数组
  */
 public function read_notification($notification_id, $uid = null)
 {
     $notification_ids = explode(',', $notification_id);
     array_walk_recursive($notification_ids, 'intval_string');
     if (count($notification_ids) == 1 and intval($notification_id) > 0) {
         $notify_info = $this->get_notification_by_id($notification_id, $uid);
         $unread_notifys = $this->get_unread_notification($uid);
         if (!$notify_info or !$unread_notifys) {
             return false;
         }
         $unread_extends = array();
         foreach ($unread_notifys as $key => $val) {
             $unread_extends[$val['model_type']][$val['source_id']][] = $val;
         }
         $notifications = $unread_extends[$notify_info['model_type']][$notify_info['source_id']];
         $notification_ids = array();
         if (!$notifications) {
             $notification_ids[] = $notification_id;
         } else {
             foreach ($notifications as $key => $val) {
                 $notification_ids[] = $val['notification_id'];
             }
         }
     }
     if ($notification_ids) {
         foreach ($notification_ids as $key => $val) {
             if (!is_digits($val)) {
                 return false;
             }
             $notification_ids[$key] = intval($val);
         }
         $this->update('notification', array('read_flag' => 1), 'recipient_uid = ' . intval($uid) . ' AND notification_id IN (' . implode(',', $notification_ids) . ')');
         $this->model('account')->update_notification_unread($uid);
         return true;
     }
 }
 public function get_posts_list_by_topic_ids($post_type, $topic_type, $topic_ids, $category_id = null, $answer_count = null, $order_by = 'post_id DESC', $is_recommend = false, $page = 1, $per_page = 10)
 {
     if (!is_array($topic_ids)) {
         return false;
     }
     array_walk_recursive($topic_ids, 'intval_string');
     $result_cache_key = 'posts_list_by_topic_ids_' . md5(implode(',', $topic_ids) . $answer_count . $category_id . $order_by . $is_recommend . $page . $per_page . $post_type . $topic_type);
     $found_rows_cache_key = 'posts_list_by_topic_ids_found_rows_' . md5(implode(',', $topic_ids) . $answer_count . $category_id . $is_recommend . $per_page . $post_type . $topic_type);
     $topic_relation_where[] = '`topic_id` IN(' . implode(',', $topic_ids) . ')';
     if ($topic_type) {
         $topic_relation_where[] = "`type` = '" . $this->quote($topic_type) . "'";
     }
     if ($topic_relation_query = $this->query_all("SELECT `item_id`, `type` FROM " . get_table('topic_relation') . " WHERE " . implode(' AND ', $topic_relation_where))) {
         foreach ($topic_relation_query as $key => $val) {
             $post_ids[$val['type']][$val['item_id']] = $val['item_id'];
         }
     }
     if (!$post_ids) {
         return false;
     }
     foreach ($post_ids as $key => $val) {
         $post_id_where[] = "(post_id IN (" . implode(',', $val) . ") AND post_type = '" . $this->quote($key) . "')";
     }
     if ($post_id_where) {
         $where[] = '(' . implode(' OR ', $post_id_where) . ')';
     }
     if (is_digits($answer_count)) {
         if ($answer_count == 0) {
             $where[] = "answer_count = " . $answer_count;
         } else {
             if ($answer_count > 0) {
                 $where[] = "answer_count >= " . $answer_count;
             }
         }
     }
     if ($is_recommend) {
         $where[] = 'is_recommend = 1';
     }
     if ($post_type) {
         $where[] = "post_type = '" . $this->quote($post_type) . "'";
     }
     if ($category_id) {
         $where[] = 'category_id IN(' . implode(',', $this->model('system')->get_category_with_child_ids('question', $category_id)) . ')';
     }
     if (!($result = AWS_APP::cache()->get($result_cache_key))) {
         $result = $this->fetch_page('posts_index', implode(' AND ', $where), $order_by, $page, $per_page);
         AWS_APP::cache()->set($result_cache_key, $result, get_setting('cache_level_high'));
     }
     if (!($found_rows = AWS_APP::cache()->get($found_rows_cache_key))) {
         $found_rows = $this->found_rows();
         AWS_APP::cache()->set($found_rows_cache_key, $found_rows, get_setting('cache_level_high'));
     }
     $this->posts_list_total = $found_rows;
     return $result;
 }
Example #27
0
 public function save_receiving_email_config_action()
 {
     if ($_POST['id']) {
         $receiving_email_config = $this->model('edm')->get_receiving_email_config_by_id($_POST['id']);
         if (!$receiving_email_config) {
             H::ajax_json_output(AWS_APP::RSM(null, -1, AWS_APP::lang()->_t('该账号不存在')));
         }
     }
     $_POST['server'] = trim($_POST['server']);
     if (!$_POST['server']) {
         H::ajax_json_output(AWS_APP::RSM(null, -1, AWS_APP::lang()->_t('请输入服务器地址')));
     }
     if (!$_POST['protocol'] or !in_array($_POST['protocol'], array('pop3', 'imap'))) {
         H::ajax_json_output(AWS_APP::RSM(null, -1, AWS_APP::lang()->_t('请选择协议')));
     }
     if ($_POST['port'] and (!is_digits($_POST['port']) or $_POST['port'] < 0 or $_POST['port'] > 65535)) {
         H::ajax_json_output(AWS_APP::RSM(null, -1, AWS_APP::lang()->_t('请输入有效的端口号(0 ~ 65535)')));
     }
     if (!$_POST['uid']) {
         H::ajax_json_output(AWS_APP::RSM(null, -1, AWS_APP::lang()->_t('请选择此账号对应的用户')));
     }
     $user_info = $this->model('account')->get_user_info_by_uid($_POST['uid']);
     if (!$user_info) {
         H::ajax_json_output(AWS_APP::RSM(null, -1, AWS_APP::lang()->_t('所选用户不存在')));
     }
     $receiving_email_config = array('server' => $_POST['server'], 'protocol' => $_POST['protocol'], 'ssl' => $_POST['ssl'] == '1' ? '1' : '0', 'username' => trim($_POST['username']), 'password' => trim($_POST['password']), 'uid' => $user_info['uid']);
     if ($_POST['port']) {
         $receiving_email_config['port'] = $_POST['port'];
     }
     if ($_POST['id']) {
         $this->model('edm')->update_receiving_email_config($_POST['id'], 'update', $receiving_email_config);
         H::ajax_json_output(AWS_APP::RSM(null, -1, AWS_APP::lang()->_t('保存设置成功')));
     } else {
         $config_id = $this->model('edm')->update_receiving_email_config(null, 'add', $receiving_email_config);
         H::ajax_json_output(AWS_APP::RSM(array('url' => get_js_url('/admin/edm/receiving/id-' . $config_id)), 1, null));
     }
 }
Example #28
0
 public function get_weibo_user_by_uid($uid)
 {
     if (!is_digits($uid)) {
         return false;
     }
     static $weibo_user_info;
     if (!$weibo_user_info[$uid]) {
         $weibo_user_info[$uid] = $this->fetch_row('users_sina', 'uid = ' . $uid);
     }
     return $weibo_user_info[$uid];
 }
Example #29
0
 public function response_message($input_message)
 {
     switch ($input_message['msgType']) {
         case 'event':
             if (substr($input_message['eventKey'], 0, 8) == 'COMMAND_') {
                 if ($input_message['eventKey'] == 'COMMAND_MORE') {
                     $input_message['content'] = 'yes';
                     $input_message['msgType'] = 'text';
                     $response = $this->response_message($input_message);
                 } else {
                     if (strstr($input_message['eventKey'], '__')) {
                         $event_key = explode('__', substr($input_message['eventKey'], 8));
                         $content = $event_key[0];
                         $param = $event_key[1];
                     } else {
                         $content = substr($input_message['eventKey'], 8);
                     }
                     $response = $this->message_parser(array('content' => $content, 'fromUsername' => $input_message['fromUsername'], 'param' => $param));
                 }
                 $response_message = $response['message'];
                 $action = $response['action'];
             } else {
                 if (substr($input_message['eventKey'], 0, 11) == 'REPLY_RULE_') {
                     if ($reply_rule = $this->get_reply_rule_by_id(substr($input_message['eventKey'], 11))) {
                         $response_message = $this->create_response_by_reply_rule_keyword($reply_rule['keyword']);
                     } else {
                         $response_message = '菜单指令错误';
                     }
                 } else {
                     switch (strtolower($input_message['event'])) {
                         case 'subscribe':
                             if (substr($input_message['eventKey'], 0, 8) == 'qrscene_') {
                                 $this->query('UPDATE ' . get_table('weixin_qr_code') . ' SET subscribe_num = subscribe_num + 1 WHERE scene_id = ' . intval(substr($input_message['eventKey'], 8)));
                             }
                             if ($this->account_info['weixin_subscribe_message_key']) {
                                 $response_message = $this->create_response_by_reply_rule_keyword($this->account_info['weixin_subscribe_message_key']);
                             }
                             break;
                         case 'location':
                             if ($this->user_id) {
                                 $this->update('users_weixin', array('latitude' => $input_message['latitude'], 'longitude' => $input_message['longitude'], 'location_update' => time()), 'uid = ' . $this->user_id);
                             }
                             break;
                         case 'masssendjobfinish':
                             $msg_id = $input_message['msgID'];
                             $msg_details = array('create_time' => intval($input_message['createTime']), 'filter_count' => intval($input_message['filterCount']));
                             if ($input_message['status'] == 'send success' or $input_message['status'] == 'sendsuccess') {
                                 $msg_details['status'] = 'success';
                             } else {
                                 if ($input_message['status'] == 'send fail' or $input_message['status'] == 'sendfail') {
                                     $msg_details['status'] = 'fail';
                                 } else {
                                     if (substr($input_message['status'], 0, 3) == 'err') {
                                         $msg_details['status'] = 'wrong';
                                         $msg_details['error_num'] = intval(substr($input_message['status'], 4, 9));
                                     }
                                 }
                             }
                             if (is_digits($msg_id)) {
                                 $this->update('weixin_msg', $msg_details, 'msg_id = ' . $msg_id);
                             }
                             break;
                     }
                 }
             }
             break;
         case 'location':
             if ($near_by_questions = $this->model('people')->get_near_by_users($input_message['location_X'], $input_message['location_y'], $this->user_id, 5)) {
                 foreach ($near_by_questions as $key => $val) {
                     if (!$response_message) {
                         $image_file = AWS_APP::config()->get('weixin')->default_list_image;
                     } else {
                         $image_file = get_avatar_url($val['published_uid'], 'max');
                     }
                     $response_message[] = array('title' => $val['question_content'], 'link' => get_js_url('/m/question/' . $val['question_id']), 'image_file' => $image_file);
                 }
             } else {
                 $response_message = '你的附近暂时没有主题';
             }
             break;
         case 'voice':
             if ($input_message['recognition']) {
                 $input_message['content'] = $input_message['recognition'];
                 $input_message['msgType'] = 'text';
                 $response_message = $this->response_message($input_message);
             } else {
                 $response_message = '无法识别语音或相关功能未启用';
             }
             break;
         case 'image':
             if (get_setting('weixin_account_role') != 'subscription' and get_setting('weixin_account_role') != 'service') {
                 break;
             }
             if ($input_message['mediaID'] and $input_message['picUrl']) {
                 AWS_APP::cache()->set('weixin_pic_url_' . md5($input_message['mediaID']), $input_message['picUrl'], 259200);
                 $response_message = '您想提交图片到社区么?<a href="' . $this->model('openid_weixin_weixin')->redirect_url('/m/publish/weixin_media_id-' . base64_encode($input_message['mediaID'])) . '">点击进入提交页面</a>';
             } else {
                 $response_message = '无法识别图片';
             }
             break;
         default:
             if ($response_message = $this->create_response_by_reply_rule_keyword($input_message['content'])) {
                 // response by reply rule keyword...
             } else {
                 if ($response = $this->model('openid_weixin_third')->send_message_to_third_party($this->account_info['id'], $this->post_data)) {
                     exit($response);
                 } else {
                     if ($response = $this->message_parser($input_message)) {
                         // Success...
                         $response_message = $response['message'];
                         $action = $response['action'];
                     } else {
                         if ($this->is_language($input_message['content'], 'ok')) {
                             $response = $this->process_last_action($input_message['fromUsername']);
                             $response_message = $response['message'];
                             $action = $response['action'];
                         } else {
                             if ($this->is_language($input_message['content'], 'cancel')) {
                                 $this->delete('weixin_message', "weixin_id = '" . $this->quote($input_message['fromUsername']) . "'");
                                 $response_message = '好的, 还有什么可以帮您的吗?';
                             } else {
                                 if (!($response_message = $this->create_response_by_reply_rule_keyword($this->account_info['weixin_no_result_message_key']))) {
                                     $response_message = '您的主题: ' . $input_message['content'] . ', 目前没有人提到过, <a href="' . $this->model('openid_weixin_weixin')->redirect_url('/m/publish/') . '">点此提问</a>';
                                 }
                             }
                         }
                     }
                 }
             }
             break;
     }
     $response = is_array($response_message) ? $this->create_image_response($input_message, $response_message, $action) : $this->create_txt_response($input_message, $response_message, $action);
     if ($input_message['encryption']) {
         $response = $this->encrypt_msg($response);
     }
     exit($response);
 }
 public function index_action()
 {
     if (!($question_info = $this->model('question')->get_question_info_by_id($_GET['id']))) {
         H::ajax_json_output(AWS_APP::RSM(null, -1, AWS_APP::lang()->_t('问题不存在或已被删除')));
     }
     if (!$_GET['sort'] or $_GET['sort'] != 'ASC') {
         $_GET['sort'] = 'DESC';
     } else {
         $_GET['sort'] = 'ASC';
     }
     if (get_setting('unfold_question_comments') == 'Y') {
         $_GET['comment_unfold'] = 'all';
     }
     $question_info['redirect'] = $this->model('question')->get_redirect($question_info['question_id']);
     if ($question_info['redirect']['target_id']) {
         $target_question = $this->model('question')->get_question_info_by_id($question_info['redirect']['target_id']);
     }
     if (is_digits($_GET['rf']) and $_GET['rf']) {
         if ($from_question = $this->model('question')->get_question_info_by_id($_GET['rf'])) {
             $redirect_message[] = AWS_APP::lang()->_t('从问题 %s 跳转而来', '<a href="' . get_js_url('/question/' . $_GET['rf'] . '?rf=false') . '">' . $from_question['question_content'] . '</a>');
         }
     }
     if ($question_info['redirect'] and !$_GET['rf']) {
         if ($target_question) {
             HTTP::redirect('/question/' . $question_info['redirect']['target_id'] . '?rf=' . $question_info['question_id']);
         } else {
             $redirect_message[] = AWS_APP::lang()->_t('重定向目标问题已被删除, 将不再重定向问题');
         }
     } else {
         if ($question_info['redirect']) {
             if ($target_question) {
                 $message = AWS_APP::lang()->_t('此问题将跳转至') . ' <a href="' . get_js_url('/question/' . $question_info['redirect']['target_id'] . '?rf=' . $question_info['question_id']) . '">' . $target_question['question_content'] . '</a>';
                 if ($this->user_id and ($this->user_info['permission']['is_administortar'] or $this->user_info['permission']['is_moderator'] or !$this->question_info['lock'] and $this->user_info['permission']['redirect_question'])) {
                     $message .= '&nbsp; (<a href="javascript:;" onclick="AWS.ajax_request(G_BASE_URL + \'/question/ajax/redirect/\', \'item_id=' . $question_info['question_id'] . '\');">' . AWS_APP::lang()->_t('撤消重定向') . '</a>)';
                 }
                 $redirect_message[] = $message;
             } else {
                 $redirect_message[] = AWS_APP::lang()->_t('重定向目标问题已被删除, 将不再重定向问题');
             }
         }
     }
     $question_info['user_info'] = $this->model('account')->get_user_info_by_uid($question_info['published_uid'], true);
     if ($_GET['column'] != 'log') {
         $this->model('question')->calc_popular_value($question_info['question_id']);
         $this->model('question')->update_views($question_info['question_id']);
         if (is_digits($_GET['uid'])) {
             $answer_list_where[] = 'uid = ' . intval($_GET['uid']);
             $answer_count_where = 'uid = ' . intval($_GET['uid']);
         } else {
             if ($_GET['uid'] == 'focus' and $this->user_id) {
                 if ($friends = $this->model('follow')->get_user_friends($this->user_id, false)) {
                     foreach ($friends as $key => $val) {
                         $follow_uids[] = $val['uid'];
                     }
                 } else {
                     $follow_uids[] = 0;
                 }
                 $answer_list_where[] = 'uid IN(' . implode($follow_uids, ',') . ')';
                 $answer_count_where = 'uid IN(' . implode($follow_uids, ',') . ')';
                 $answer_order_by = 'add_time ASC';
             } else {
                 if ($_GET['sort_key'] == 'add_time') {
                     $answer_order_by = $_GET['sort_key'] . " " . $_GET['sort'];
                 } else {
                     $answer_order_by = "agree_count " . $_GET['sort'] . ", against_count ASC, add_time ASC";
                 }
             }
         }
         if ($answer_count_where) {
             $answer_count = $this->model('answer')->get_answer_count_by_question_id($question_info['question_id'], $answer_count_where);
         } else {
             $answer_count = $question_info['answer_count'];
         }
         if (isset($_GET['answer_id']) and (!$this->user_id or $_GET['single'])) {
             $answer_list = $this->model('answer')->get_answer_list_by_question_id($question_info['question_id'], 1, 'answer_id = ' . intval($_GET['answer_id']));
         } else {
             if (!$this->user_id and !$this->user_info['permission']['answer_show']) {
                 if ($question_info['best_answer']) {
                     $answer_list = $this->model('answer')->get_answer_list_by_question_id($question_info['question_id'], 1, 'answer_id = ' . intval($question_info['best_answer']));
                 } else {
                     $answer_list = $this->model('answer')->get_answer_list_by_question_id($question_info['question_id'], 1, null, 'agree_count DESC');
                 }
             } else {
                 if ($answer_list_where) {
                     $answer_list_where = implode(' AND ', $answer_list_where);
                 }
                 $answer_list = $this->model('answer')->get_answer_list_by_question_id($question_info['question_id'], calc_page_limit($_GET['page'], 100), $answer_list_where, $answer_order_by);
             }
         }
         // 最佳回复预留
         $answers[0] = '';
         if (!is_array($answer_list)) {
             $answer_list = array();
         }
         $answer_ids = array();
         $answer_uids = array();
         foreach ($answer_list as $answer) {
             $answer_ids[] = $answer['answer_id'];
             $answer_uids[] = $answer['uid'];
             if ($answer['has_attach']) {
                 $has_attach_answer_ids[] = $answer['answer_id'];
             }
         }
         if (!in_array($question_info['best_answer'], $answer_ids) and intval($_GET['page']) < 2) {
             $answer_list = array_merge($this->model('answer')->get_answer_list_by_question_id($question_info['question_id'], 1, 'answer_id = ' . $question_info['best_answer']), $answer_list);
         }
         if ($answer_ids) {
             $answer_vote_status = $this->model('answer')->get_answer_vote_status($answer_ids, $this->user_id);
             $answer_users_rated_thanks = $this->model('answer')->users_rated('thanks', $answer_ids, $this->user_id);
             $answer_users_rated_uninterested = $this->model('answer')->users_rated('uninterested', $answer_ids, $this->user_id);
         }
         foreach ($answer_list as $answer) {
             $answer['user_rated_thanks'] = $answer_users_rated_thanks[$answer['answer_id']];
             $answer['user_rated_uninterested'] = $answer_users_rated_uninterested[$answer['answer_id']];
             $answer['answer_content'] = cjk_substr(strip_ubb($answer['answer_content']), 0, 100);
             //$answer['agree_users'] = $answer_agree_users[$answer['answer_id']];
             $answer['agree_status'] = $answer_vote_status[$answer['answer_id']];
             $answer['user_info']['avatar_file'] = get_avatar_url($answer['uid']);
             if ($question_info['best_answer'] == $answer['answer_id'] and intval($_GET['page']) < 2) {
                 $answers[0] = $answer;
             } else {
                 $answers[] = $answer;
             }
         }
         if (!$answers[0]) {
             unset($answers[0]);
         }
         $question_info['user_answered'] = 0;
         //如果系统设置了用户只能回答一次
         if (get_setting('answer_unique') == 'Y') {
             if ($this->model('answer')->has_answer_by_uid($question_info['question_id'], $this->user_id)) {
                 $question_info['user_answered'] = 1;
             } else {
                 $question_info['user_answered'] = 0;
             }
         }
     }
     $question_info['user_follow_check'] = 0;
     $question_info['user_question_focus'] = 0;
     $question_info['user_thanks'] = 0;
     if ($this->user_id) {
         if ($this->model('question')->get_question_thanks($question_info['question_id'], $this->user_id)) {
             $question_info['user_thanks'] = 1;
         }
         //当前用户是否已关注该问题作者
         if ($this->model('follow')->user_follow_check($this->user_id, $question_info['published_uid'])) {
             $question_info['user_follow_check'] = 1;
         }
         if ($this->model('question')->has_focus_question($question_info['question_id'], $this->user_id)) {
             $question_info['user_question_focus'] = 1;
         }
     }
     $question_info['question_detail'] = FORMAT::parse_attachs(nl2br(FORMAT::parse_bbcode($question_info['question_detail'])));
     $question_topics = $this->model('topic')->get_topics_by_item_id($question_info['question_id'], 'question');
     $question_info['answer_count'] = $answer_count;
     //clean
     $question_key = array('question_id', 'question_content', 'question_detail', 'add_time', 'update_time', 'answer_count', 'view_count', 'agree_count', 'focus_count', 'against_count', 'thanks_count', 'comment_count', 'user_info', 'user_answered', 'user_thanks', 'user_follow_check', 'user_question_focus');
     $user_key = array('uid', 'user_name', 'namecard_pic', 'signature');
     $topics_key = array('topic_id', 'topic_title');
     foreach ($question_info as $k => $v) {
         if (!in_array($k, $question_key)) {
             unset($question_info[$k]);
         }
     }
     //作者信息
     if (!empty($question_info['user_info'])) {
         foreach ($question_info['user_info'] as $k => $v) {
             if (!in_array($k, $user_key)) {
                 unset($question_info['user_info'][$k]);
             }
         }
         $question_info['user_info']['avatar_file'] = get_avatar_url($question_info['user_info']['uid'], 'mid');
     }
     if (!empty($answers)) {
         foreach ($answers as $key => $value) {
             if (!empty($value['user_info'])) {
                 foreach ($value['user_info'] as $k => $v) {
                     if (!in_array($k, $user_key)) {
                         unset($answers[$key]['user_info'][$k]);
                     }
                 }
                 $answers[$key]['user_info']['avatar_file'] = get_avatar_url($answers[$key]['user_info']['uid'], 'mid');
             }
             $answers[$key]['answer_content'] = strip_tags($value['answer_content']);
         }
     }
     if (!empty($question_topics)) {
         foreach ($question_topics as $key => $val) {
             foreach ($val as $k => $v) {
                 if (!in_array($k, $topics_key)) {
                     unset($question_topics[$key][$k]);
                 }
             }
         }
     }
     //$question_info['answers'] = $answers;
     H::ajax_json_output(AWS_APP::RSM(array('question_info' => $question_info, 'question_topics' => $question_topics, 'answers' => array_values($answers)), 1, null));
 }