示例#1
0
    admin_footer();
    exit;
} elseif ($admin_action == 'ques_edit') {
    if ($_POST['ctype'] == 'edit_submit') {
        $qid = intval($_POST['qid']);
        $sid = intval($_POST['sid']);
        $page = intval($_POST['page']);
        $title = filters_title($_POST['title']);
        $content = filters_content($_POST['content']);
        $dblink->query("UPDATE {$dbprefix}ques SET title='{$title}',content='{$content}' where qid={$qid}");
        header("location:admin.php?admin_action={$backaction}&sid={$sid}&page={$page}");
    } else {
        $qid = intval($_GET['qid']);
        $query = $dblink->query("SELECT qid,title,content FROM {$dbprefix}ques WHERE qid={$qid}");
        $row = $dblink->fetch_array($query);
        $row['content'] = filters_outcontent($row['content']);
        $row['content'] = htmlspecialchars($row['content']);
        admin_header();
        ?>
<table cellspacing="1" cellpadding="0" width="760" align="center" class="tableborder">
<tr><td>
	<table border="0" cellspacing="0" cellpadding="4" width="100%">
	<tr class="header"><td height="22"><?php 
        echo $lang['ques_edit'];
        ?>
</td></tr>
	<tr bgcolor="#f8f8f8"><td>
		<table border="1" bordercolor="#cccccc" cellspacing="0" cellpadding="0" width="100%">
		 <form name=Form1 action="admin.php" method="post">
		 <tr bgcolor="#f8f8f8">
		<td width="100" align="center"><?php 
示例#2
0
    }
    //update_session();
    include template('question_solve');
    exit;
} elseif ($ques_status == 3) {
    $query = $dblink->query("SELECT count(*) FROM {$dbprefix}answer WHERE qid={$qid} AND joinvote=1");
    $vote_count = $dblink->result($query, 0);
    $query = $dblink->query("SELECT aid,qid,uid,username,answer,votevalue,answertime,response FROM {$dbprefix}answer WHERE qid={$qid} AND joinvote=1 ORDER BY aid asc");
    $i = 1;
    while ($vote_tmp = $dblink->fetch_array($query)) {
        $vote_tmp['answer'] = filters_outcontent($vote_tmp['answer']);
        $vote_tmp['answertime'] = date("y-m-d H:i", $vote_tmp['answertime']);
        $vote_list[$i] = $vote_tmp;
        $i++;
    }
    $query = $dblink->query("SELECT count(*) FROM {$dbprefix}answer WHERE qid={$qid} AND joinvote<>1");
    $answer_count = $dblink->result($query, 0);
    $query = $dblink->query("SELECT aid,qid,uid,username,answer,answertime,response FROM {$dbprefix}answer WHERE qid={$qid} AND joinvote<>1 ORDER BY aid desc");
    while ($answer_tmp = $dblink->fetch_array($query)) {
        $answer_tmp['answer'] = filters_outcontent($answer_tmp['answer']);
        $answer_tmp['answertime'] = date("y-m-d H:i", $answer_tmp['answertime']);
        $answer_list[$answer_tmp['aid']] = $answer_tmp;
    }
    //update_session();
    include template('question_vote');
    exit;
} else {
    //update_session();
    include template('question_solve');
    exit;
}
示例#3
0
    if (!$dblink->num_rows($query)) {
        show_message('action_error', './');
        exit;
    }
    $title = $site_name;
    $ques_row = $dblink->fetch_array($query);
    $ques_title = $ques_row['title'];
    $quesscore = $ques_row['score'] ? $ques_row['score'] : 0;
    $my_score = get_score($cyask_uid);
    $query = $dblink->query("select aid,uid,answertime from {$tablepre}answer WHERE aid={$_POST['aid']}");
    $answer_row = $dblink->fetch_array($query);
    $query = $dblink->query("select username,content from {$tablepre}answer_1 WHERE aid={$_POST['aid']}");
    $answer_row2 = $dblink->fetch_array($query);
    $answer_row = array_merge($answer_row, $answer_row2);
    $answerid = intval($answer_row['aid']);
    $ques_answer = filters_outcontent($answer_row['content']);
    $answertime = $answer_row['answertime'];
    $answer_user = '******' . $answer_row['uid'] . '" target="_blank">' . $answer_row['username'] . '</a>';
    include template('handle_answer_adopt');
} elseif ($command == 'answer_adopt_submit') {
    $aid = intval($_POST['aid']);
    $query = $dblink->query("SELECT qid,uid FROM {$tablepre}answer WHERE aid={$aid}");
    if (!$dblink->num_rows($query)) {
        show_message('action_error', './');
        exit;
    }
    $answer = $dblink->fetch_array($query);
    if (check_submit($_POST['adoptsubmit'], $_POST['formhash'])) {
        $content = filters_content($_POST['content']);
        $allscore = intval($_POST['score'] + $_POST['addscore'] + $score_adopt);
        $addscore = intval($_POST['addscore']);
示例#4
0
文件: readc.php 项目: yunsite/cyaskuc
<?php

/*
	[CYASK] (C)2007 Cyask.com QQ: 240508015
	Revision: 3.0.0 for Discuz
	Date: 2007/4/23
*/
define('CURSCRIPT', 'collectread');
require_once './include/common.inc.php';
$title = $site_name;
$id = intval($_GET['id']);
if ($dblink->query("UPDATE {$dbprefix}collect SET click=click+1 WHERE id={$id}")) {
    $query = $dblink->query("SELECT * FROM {$dbprefix}collect WHERE id={$id}");
} else {
    show_message('action_error', './');
    exit;
}
$collect = $dblink->fetch_array($query);
$collect_sortname = $collect['sortname'];
$collect_title = $collect['title'];
$collect_content = filters_outcontent($collect['content']);
$collect_url = $collect['url'];
include template('collect_read');
exit;
示例#5
0
    $title .= '-' . $menu['sort2'] . '-' . $menu['sort1'];
} elseif ($question['sid1']) {
    $query = $dblink->query("SELECT * FROM {$dbprefix}sort WHERE sid={$question['sid1']}");
    $menu = $dblink->fetch_array($query);
    $toplink = '<a class="question" href="./browse.php?sid=' . $menu['sid'] . '">' . $menu['sort1'] . '</a>';
    $query = $dblink->query("SELECT qid,title FROM {$dbprefix}ques WHERE sid1={$question['sid1']} ORDER BY answercount desc,clickcount desc limit 6");
    $sid_more = $question['sid1'];
    $title .= '-' . $menu['sort1'];
}
while ($ques_tmp = $dblink->fetch_array($query)) {
    $ques_tmp['stitle'] = cut_str($ques_tmp['title'], 24);
    $hotques_list[$ques_tmp['qid']] = $ques_tmp;
}
$query = $dblink->query("SELECT * FROM {$dbprefix}res WHERE aid={$aid}");
$response_count = $dblink->num_rows($query);
$i = 1;
while ($ques_tmp = $dblink->fetch_array($query)) {
    if (empty($ques_tmp['username'])) {
        $ques_tmp['userlink'] = '#';
        $uip = explode('.', $ques_tmp['uip']);
        $ques_tmp['username'] = $uip[0] . '.' . $uip[1] . '.' . $uip[2] . '.' . '*';
    } else {
        $ques_tmp['userlink'] = './member.php?uid=' . $ques_tmp['uid'];
    }
    $ques_tmp['time'] = date("y-m-d H:i", $ques_tmp['time']);
    $ques_tmp['content'] = filters_outcontent($ques_tmp['content']);
    $response_list[$i] = $ques_tmp;
    $i++;
}
include template('response');
exit;
示例#6
0
        if ($sid) {
            $query = $dblink->query("SELECT * FROM {$tablepre}sort WHERE sid={$sid}");
            $sort = $dblink->fetch_array($query);
            if ($sort['grade'] == 1) {
                $sort_list = $sort['sort1'];
            } else {
                if ($sort['grade'] == 2) {
                    $sort_list = $sort['sort1'] . ' -&gt; ' . $sort['sort2'];
                } else {
                    if ($sort['grade'] == 3) {
                        $sort_list = $sort['sort1'] . ' -&gt; ' . $sort['sort2'] . ' -&gt; ' . $sort['sort3'];
                    }
                }
            }
        }
        $row['supplement'] = filters_outcontent($row['supplement']);
        $row['supplement'] = htmlspecialchars($row['supplement']);
        admin_header();
        ?>
<script type="text/javascript">
function gcv(f)
{  
	var aa = document.getElementsByName("ra");
	for(var  i=0;  i<aa.length; i++)  
	{
		if(aa[i].checked)
        {
			document.editForm.cid.value = aa[i].value;
        }
	}
}
示例#7
0
</td></tr>
</table>
<?php 
    admin_footer();
    exit;
} elseif ($admin_action == 'answer_edit') {
    if ($_POST['ctype'] == 'edit_submit') {
        $answer = filters_content($_POST['answer']);
        $aid = intval($_POST['aid']);
        $dblink->query("UPDATE {$dbprefix}answer SET answer='{$answer}' where aid={$aid}");
        header("location:admin.php?admin_action={$_POST['backaction']}&page={$_POST['page']}");
    } else {
        $aid = intval($_GET['aid']);
        $query = $dblink->query("SELECT * FROM {$dbprefix}answer WHERE aid={$aid}");
        $row = $dblink->fetch_array($query);
        $row['answer'] = filters_outcontent($row['answer']);
        $row['answer'] = htmlspecialchars($row['answer']);
        admin_header();
        ?>
<table cellspacing="1" cellpadding="0" width="760" align="center" class="tableborder">
<tr><td>
	<table border="0" cellspacing="0" cellpadding="4" width="100%">
	<tr class="header"><td height="22"><?php 
        echo $lang['ans_do_mod'];
        ?>
</td></tr>
	<tr bgcolor="#f8f8f8"><td>
		<table border="1" bordercolor="#cccccc" cellspacing="0" cellpadding="0" width="100%">
		 <form name=Form1 action="admin.php" method="post">
		<tr bgcolor="#f8f8f8">
		<td width="100" align="center"><?php 
示例#8
0
    $vote_count = $dblink->result($query, 0);
    $query = $dblink->query("SELECT aid,qid,uid,votevalue,answertime,response FROM {$tablepre}answer WHERE qid={$qid} AND joinvote=1 ORDER BY aid asc");
    $vote_list = array();
    $i = 1;
    while ($tmp1 = $dblink->fetch_array($query)) {
        $query_c = $dblink->query("SELECT username,content FROM {$tablepre}answer_1 WHERE aid='{$tmp1['aid']}'");
        $tmp2 = $dblink->fetch_array($query_c);
        $tmp = array_merge($tmp1, $tmp2);
        $tmp['answer'] = filters_outcontent($tmp['content']);
        $tmp['time'] = date("y-m-d H:i", $tmp['answertime']);
        $vote_list[$i] = $tmp;
        $i++;
    }
    $query = $dblink->query("SELECT count(*) FROM {$tablepre}answer WHERE qid={$qid} AND joinvote<>1");
    $answer_count = $dblink->result($query, 0);
    $query = $dblink->query("SELECT aid,qid,uid,answertime,response FROM {$tablepre}answer WHERE qid={$qid} AND joinvote<>1 ORDER BY aid desc");
    $answer_list = array();
    while ($tmp1 = $dblink->fetch_array($query)) {
        $query_c = $dblink->query("SELECT username,content FROM {$tablepre}answer_1 WHERE aid='{$tmp1['aid']}'");
        $tmp2 = $dblink->fetch_array($query_c);
        $tmp = array_merge($tmp1, $tmp2);
        $tmp['answer'] = filters_outcontent($tmp['content']);
        $tmp['time'] = date("y-m-d H:i", $tmp['answertime']);
        $answer_list[] = $tmp;
    }
    include template('question_vote');
    exit;
} else {
    include template('question_solve');
    exit;
}