} if (check_submit($_POST['dosubmit'], $_POST['formhash'])) { if (empty($_POST['content'])) { show_message('answer_null', ''); exit; } $query = $dblink->query("SELECT count(*) FROM {$dbprefix}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 {$dbprefix}answer set qid={$qid},uid={$cyask_uid},username='******',answer='{$content}',answertime={$timestamp}"; if ($dblink->query($sql)) { //$aid=$dblink->insert_id(); add_score($cyask_uid, $score_answer); $dblink->query("UPDATE {$dbprefix}ques SET answercount=answercount+1 WHERE qid={$qid}"); $referer = get_referer($default = './'); 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 {$dbprefix}answer where aid={$aid}"); if (!$dblink->num_rows($query)) { show_message('action_error', './');
ini_set('display_errors', 1); echo 'start testing<br>'; require_once 'connect_redis.php'; require_once '../Controllers/add_score.php'; require_once '../Controllers/get_ranklist.php'; //try to insert new entry $input = ' { "func":"add_score", "user":10, "username":"******", "score_add":720 } '; $input = json_decode($input, true); add_score($input); //try to get inserted rank data $query_param = ' { "func":"get_ranklist", "user":"******", "size":1 } '; $query_param = json_decode($query_param, true); $result = get_ranklist($query_param); echo 'result:'; print_r($result); echo 'verify result:'; //verify(); function verify($expected, $real, $matchtype = false)
} } else { // Ignore doubleposts if (strval($entries[$i]["author"]) == strval($entries[$i + 1]["author"])) { continue; } $interval = abs($entries[$i]["date"] - $entries[$i + 1]["date"]); $min = round($interval / 60); $score = ceil(pow($min, 1.1)); // Insert to database $q = $db->prepare("INSERT INTO posts (id, author, date) VALUES (:id, :a, :d)"); $q->bindValue(":id", $entries[$i]["id"]); $q->bindValue(":a", $entries[$i]["author"]); $q->bindValue(":d", strftime("%F %T", $entries[$i]["date"])); $q->execute(); add_score($db, $entries[$i]["author"], $score); print $score . " points to " . $entries[$i]["id"] . " (" . $entries[$i]["author"] . ")\n"; } } // Set "last updated"-date file_put_contents(NECRO_PATH . "update.txt", date("Y-m-d H:i:s")); } else { // If HTTP request // GET DATA & GENERATE IMAGE $q = $db->prepare("SELECT author, score, (SELECT COUNT(*) FROM posts WHERE author = score.author) AS post_count FROM score ORDER BY score DESC"); $r = $q->execute(); $res = array(); while ($row = $r->fetchArray()) { $res[] = $row; } // Determine image height, longest author text and longest points text
$query = $dblink->query("select title,score,answercount from {$dbprefix}ques 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 {$dbprefix}ques 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 {$dbprefix}ques SET status=4 where qid={$qid}"); add_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 {$dbprefix}ques 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'];
* OL * final * Sameer Jain * 12/18/15 */ require '../model/database.php'; require '../model/product_db.php'; $student_id = filter_input(INPUT_POST, 'student_id'); $score = filter_input(INPUT_POST, 'score'); $event_id = filter_input(INPUT_POST, 'event_id'); $students = get_students(); $events = get_grades(); $event_counter = 0; $student_counter = 0; foreach ($events as $event) { if (in_array($event_id, $event)) { $event_counter++; } } foreach ($students as $student) { if (in_array($student_id, $student)) { $student_counter++; } } if ($student_id == NULL || $event_id == NULL || $score == NULL || $student_counter == 0 || $event_counter == 0) { $error = "Invalid product data. Check all fields and try again."; include '../errors/error.php'; } else { add_score($student_id, $event_id, $score); header("Location: .."); }