if (check_submit($_POST['dosubmit'], $_POST['formhash'])) {
if (empty($_POST['content'])) {
show_message('answer_null', '');
exit;
}
$query = $dblink->query("SELECT count(*) FROM {$tablepre}answer WHERE uid={$cyask_uid} AND qid={$qid}");
if ($dblink->result($query, 0)) {
show_message('answer_more', '');
exit;
} else {
$content = filters_content($_POST['content']);
$sql = "INSERT INTO {$tablepre}answer set qid={$qid},uid={$cyask_uid},answertime={$timestamp}";
if ($dblink->query($sql)) {
$aid = $dblink->insert_id();
$dblink->query("INSERT INTO {$tablepre}answer_1 SET aid='{$aid}',username='******',content='{$content}'");
update_score($cyask_uid, $score_answer, '+');
$dblink->query("UPDATE {$tablepre}question SET answercount=answercount+1 WHERE qid={$qid}");
$referer = get_referer('./');
header("location:signal.php?resultno=109&url={$referer}");
exit;
}
}
} else {
show_message('url_error', './');
exit;
}
} elseif ($command == 'answer_response') {
$aid = intval($_POST['aid']);
$query = $dblink->query("select * from {$tablepre}answer where aid={$aid}");
if (!$dblink->num_rows($query)) {
show_message('action_error', './');
$sid2 = $sortrow['sid2'];
$sid3 = $sortrow['sid'];
break;
}
} else {
show_message('class_error', '');
exit;
}
$give_score = intval($_POST['givescore']);
if ($give_score) {
$my_score = get_score($cyask_uid);
if ($give_score > $my_score) {
show_message('score_error', '');
exit;
} else {
update_score($cyask_uid, $give_score, '-');
//┐█ио
}
}
$ques_title = filters_title($_POST['qtitle']);
$ques_supplement = filters_content($_POST['qsupply']);
$ques_hidanswer = $_POST['hidanswer'] ? 1 : 0;
$overdue_days = intval($overdue_days);
$endtime = $timestamp + $overdue_days * 86400;
$sql = "INSERT INTO {$tablepre}question SET sid='{$sid}',sid1='{$sid1}',sid2='{$sid2}',sid3='{$sid3}',uid='{$cyask_uid}',username='******',title='{$ques_title}',score='{$give_score}',asktime='{$timestamp}',endtime='{$endtime}',hidanswer='{$ques_hidanswer}'";
if ($dblink->query($sql)) {
$qid = $dblink->insert_id();
}
$do = $dblink->query("INSERT INTO {$tablepre}question_1 SET qid='{$qid}',supplement='{$ques_supplement}'");
if ($do) {
header("location:signal.php?resultno=101&url={$url}");
$rounds_number = 1;
if ($data->rounds_number > $rounds_number) {
$rounds_number = $data->rounds_number;
}
$score = $data->score->{$r->player_id}->gamepoints / 3;
// 3 gamepoints per game win
foreach ($deck->main as $id => $card) {
// Played cards
if (count($exts) == 0 || count(array_intersect($card->exts, $exts)) > 0) {
update_score($card, $rounds_number, $rounds_number, $score);
}
}
foreach ($deck->side as $id => $card) {
// Not played cards
if (count($exts) == 0 || count(array_intersect($card->exts, $exts)) > 0) {
update_score($card, $rounds_number);
}
}
$lparsed++;
}
$parsed += $lparsed;
echo "Parsed {$lparsed} decks\n";
}
echo "\n</pre>Parsed {$parsed} decks";
echo "<ul><li>Total time : " . (microtime(true) - $start) . '</li>';
echo "<li>Tournament data JSON decoding : {$json_parse}</li>";
echo "<li>Decks parsing (cards/extensions searching): {$deck_parse}</li></ul>";
$result = new stdClass();
if ($date != '') {
$result->date = $date;
}
$query = $dblink->query("select title,score,answercount from {$tablepre}question where qid={$qid}");
$question = $dblink->fetch_array($query);
$ques_title = $question['title'];
$ques_score = $question['score'];
$answercount = $question['answercount'];
include template('handle_ques_close');
} elseif ($command == 'ques_close_submit') {
$query = $dblink->query("select score from {$tablepre}question where qid={$qid}");
if (!$dblink->num_rows($query)) {
show_message('action_error', './');
exit;
}
if (check_submit($_POST['quesclosesubmit'], $_POST['formhash'])) {
$ques_score = $dblink->result($query, 0);
$dblink->query("UPDATE {$tablepre}question SET status=4 where qid={$qid}");
update_score($cyask_uid, $ques_score, '+');
header("location:signal.php?resultno=107&url={$url}");
exit;
} else {
show_message('url_error', './');
exit;
}
} elseif ($command == 'ques_vote') {
$query = $dblink->query("select title,score from {$tablepre}question where qid={$qid}");
if (!$dblink->num_rows($query)) {
show_message('action_error', './');
exit;
}
$title = $site_name;
$question = $dblink->fetch_array($query);
$ques_title = $question['title'];
