www.gusucode.com > Destoon B2B仿淘宝电子商务网站 UTF8 v6.0源码程序 > destoon/mobile/know.php

    <?php
/*
	[Destoon B2B System] Copyright (c) 2008-2015 www.destoon.com
	This is NOT a freeware, use is subject to license.txt
*/
$moduleid = 10;
require 'common.inc.php';
require DT_ROOT.'/module/club/common.inc.php';
$head_title = $MOD['name'].$DT['seo_delimiter'].$head_title;
switch($action) {
	case 'user':
		(isset($username) && check_name($username)) or $username = '';
		$username or mobile_msg($L['msg_not_user']);
		$_userid or dheader('login.php?forward='.urlencode('know.php?action='.$action.'&username='.$username));
		$user = userinfo($username);
		$user or mobile_msg($L['msg_not_user']);
		$typeid = (isset($typeid) && $typeid == 1) ? 1 : 0;
		if($typeid == 1) {
			$condition = "status=3 AND username='$username'";
			$r = $db->get_one("SELECT COUNT(*) AS num FROM {$table}_answer WHERE $condition", 'CACHE');
			$items = $r['num'];
			$pages = mobile_pages($items, $page, $pagesize);
			$lists = array();
			if($items) {
				$result = $db->query("SELECT * FROM {$table}_answer WHERE $condition ORDER BY addtime DESC LIMIT $offset,$pagesize");
				while($r = $db->fetch_array($result)) {
					$r['title'] = get_intro($r['content'], 50);
					$r['date'] = timetodate($r['addtime'], 'Y/m/d H:i');
					$lists[] = $r;
				}
				$db->free_result($result);
			}
		} else {
			$condition = "status=3 AND username='$username'";
			$r = $db->get_one("SELECT COUNT(*) AS num FROM {$table} WHERE $condition", 'CACHE');
			$items = $r['num'];
			$pages = mobile_pages($items, $page, $pagesize);
			$lists = array();
			if($items) {
				$result = $db->query("SELECT ".$MOD['fields']." FROM {$table} WHERE $condition ORDER BY addtime DESC LIMIT $offset,$pagesize");
				while($r = $db->fetch_array($result)) {
					$r['date'] = timetodate($r['addtime'], 'Y/m/d H:i');
					$lists[] = $r;
				}
				$db->free_result($result);
			}
		}
		$head_name = $L['user_title'];
		$head_title = $head_name.$DT['seo_delimiter'].$head_title;
		$foot = '';
		include template('know_user', 'mobile');
		if(DT_CHARSET != 'UTF-8') toutf8();
	break;
	case 'answer':
		$itemid or dheader(mobileurl($moduleid));
		$_userid or dheader('login.php?forward='.urlencode('club.php?action='.$action.'&itemid='.$itemid));
		check_group($_groupid, $MOD['group_answer']) or mobile_msg($L['know_msg_right']);
		$item = $db->get_one("SELECT * FROM {$table} WHERE itemid=$itemid");
		($item && $item['status'] > 2) or mobile_msg($L['know_msg_not_question']);
		if($item['process'] != 1 || ($_username && $_username == $item['username'])) mobile_msg($L['know_msg_right']);
		if(!$MOD['answer_repeat']) {
			if($_username) {
				$r = $db->get_one("SELECT itemid FROM {$table_answer} WHERE username='$_username' AND qid=$itemid");
			} else {
				$r = $db->get_one("SELECT itemid FROM {$table_answer} WHERE ip='$DT_IP' AND qid=$itemid AND addtime>$DT_TIME-86400");
			}
			if($r) mobile_msg($L['know_msg_has_answered']);
		}
		$need_captcha = $MOD['captcha_answer'] == 2 ? $MG['captcha'] : $MOD['captcha_answer'];
		$need_question = $MOD['question_answer'] == 2 ? $MG['question'] : $MOD['question_answer'];
		if($need_question) $need_captcha = 1;
		if(isset($_POST['ok'])) {
			require_once DT_ROOT.'/include/post.func.php';
			$captcha = isset($captcha) ? input_trim($captcha) : '';
			$msg = captcha($captcha, $need_captcha, true);
			if($msg) exit('captcha');
			$content = isset($content) ? convert(input_trim(nl2br($content)), 'UTF-8', DT_CHARSET) : '';
			$need_check =  $MOD['check_answer'] == 2 ? $MG['check'] : $MOD['check_answer'];
			$status = get_status(3, $need_check);
			$db->query("INSERT INTO {$table}_answer (qid,content,username,addtime,ip,status) VALUES ('$itemid', '$content', '$_username', '$DT_TIME', '$DT_IP', '$status')");			
			if($status == 3) $db->query("UPDATE {$table} SET answer=answer+1");
			if($MOD['credit_answer'] && $_username && $status == 3) {
				$could_credit = true;
				if($MOD['credit_maxanswer'] > 0) {					
					$r = $db->get_one("SELECT SUM(amount) AS total FROM {$DT_PRE}finance_credit WHERE username='$_username' AND addtime>$DT_TIME-86400  AND reason='".$L['answer']."'");
					if($r['total'] > $MOD['credit_maxanswer']) $could_credit = false;
				}
				if($could_credit) {
					credit_add($_username, $MOD['credit_answer']);
					credit_record($_username, $MOD['credit_answer'], 'system', $L['answer'], 'ID:'.$itemid.'('.$L['know_by_mobile'] .')');
				}
			}
			if($MOD['answer_message'] && $item['username']) {
				$linkurl = $MOD['linkurl'].$item['linkurl'];
				$message = lang($L['answer_message'], array(dsubstr($item['title'], 20, '...'), $item['title'], nl2br($content), $linkurl));
				send_message($item['username'], dsubstr($message, 60, '...'), $message);
			}
			exit($status == 3 ? 'ok' : 'check');
		}
		$head_title = $L['know_title'].$DT['seo_delimiter'].$head_title;
		$foot = '';
		include template('know_answer', 'mobile');
		if(DT_CHARSET != 'UTF-8') toutf8();
	break;
	default:
		dheader(mobileurl($moduleid));
	break;
}
?>