function check_level($advance) { global $CONST; if (!$_SESSION["advance-level"] || $advance != $_SESSION["prev-salt"] || $_SESSION["prev-salt"] === "") { return NULL; } global $db_connection; $query = "SELECT COUNT(*) FROM `Questions-{$_SESSION["username"]}` AS `Q-U` " . "WHERE `Q-U`.`Question Number` LIKE '{$_SESSION["level"]}_'; "; $query = mysqli_fetch_array(mysqli_query($db_connection, $query)); if (intval($query["COUNT(*)"]) < 6) { return NULL; } $query = "SELECT COUNT(*) FROM `Questions-{$_SESSION["username"]}` AS `Q-U` " . "WHERE `Q-U`.`Time Opened` != '-1' AND `Q-U`.`Time Answered` = '-1' " . "AND `Q-U`.`Question Number` LIKE '{$_SESSION["level"]}_'; "; $query = mysqli_fetch_array(mysqli_query($db_connection, $query)); $query_count = intval($query["COUNT(*)"]); if ($query_count > 0) { push_increase("Unsolved Question Penalty", -$query_count * $CONST["question-penalty"]); } $_SESSION["question"] = ""; $_SESSION["advance-level"] = FALSE; $_SESSION["level"]++; $_SESSION["level-score"] = 0; load_constants(); push_increase("Level Advanced", $CONST["advance-bonus"]); sync_scores(); $query = "UPDATE `ContestantsData` " . "SET `Level` = '{$_SESSION["level"]}' " . "WHERE `Username` = '{$_SESSION["username"]}';"; mysqli_query($db_connection, $query); return "Level Advanced"; }
function bepro_create_post_type() { $labels = array('name' => _x('BePro Listings', 'post type general name'), 'singular_name' => _x('Listing', 'post type singular name'), 'add_new' => _x('Add New', 'Listing'), 'add_new_item' => __('Add New Listing'), 'edit_item' => __('Edit Listing'), 'new_item' => __('New Listing'), 'view_item' => __('View Listing'), 'search_items' => __('Search Listing'), 'not_found' => __('Nothing found'), 'not_found_in_trash' => __('Nothing found in Trash'), 'parent_item_colon' => ''); $args = array('labels' => $labels, 'public' => true, 'publicly_queryable' => true, 'show_ui' => true, 'query_var' => true, 'menu_icon' => plugins_url("images/blogs.png", __FILE__), 'rewrite' => array("slug" => "listings", 'with_front' => false), 'capability_type' => 'post', 'hierarchical' => false, 'menu_position' => null, 'supports' => array('title', 'editor', 'thumbnail', 'comments', 'revisions', 'custom-fields', 'page-attributes', 'author')); register_post_type('bepro_listings', $args); register_taxonomy("bepro_listing_types", "bepro_listings", array('hierarchical' => true, 'label' => __('BePro Listing Categories', 'bepro_listings'), 'labels' => array('name' => __('Listing Categories', 'bepro_listings'), 'singular_name' => __('Listing Category', 'bepro_listings'), 'menu_name' => _x('Categories', 'Admin menu name', 'bepro_listings'), 'search_items' => __('Search Listing Categories', 'bepro_listings'), 'all_items' => __('All Listing Categories', 'bepro_listings'), 'parent_item' => __('Parent Listing Category', 'bepro_listings'), 'parent_item_colon' => __('Parent Listing Category:', 'bepro_listings'), 'edit_item' => __('Edit Listing Category', 'bepro_listings'), 'update_item' => __('Update Listing Category', 'bepro_listings'), 'add_new_item' => __('Add New Listing Category', 'bepro_listings'), 'new_item_name' => __('New Listing Category Name', 'bepro_listings')), 'show_ui' => true, 'query_var' => true, 'rewrite' => array("slug" => "listing_types", 'with_front' => false))); register_taxonomy_for_object_type('bepro_listing_types', 'bepro_listings'); load_constants(); }
$query = "SELECT * FROM `ContestantsData` WHERE `username` = '{$user}'"; $query = mysqli_fetch_array(mysqli_query($db_connection, $query)); $_SESSION["username"] = $user; $_SESSION["level"] = $query["Level"]; $_SESSION["question"] = ""; $_SESSION["level-score"] = $query["Level Score"]; $_SESSION["total-score"] = $query["Total Score"]; $_SESSION["increase"] = array(); $_SESSION["prev-salt"] = ""; $_SESSION["salt"] = ""; $query = "SELECT COUNT(*) FROM `Questions-{$_SESSION["username"]}` AS `Q-U` " . "WHERE `Q-U`.`Question Number` LIKE '{$_SESSION["level"]}_' " . "AND `Q-U`.`Time Answered` != '-1'"; $query = mysqli_fetch_array(mysqli_query($db_connection, $query)); $_SESSION["advance-level"] = intval($query["COUNT(*)"]) >= $CONST["advance"]; unset($user); } load_constants(); $_SESSION["prev-salt"] = $_SESSION["salt"]; $_SESSION["salt"] = sha1("arindam"); // $query = "SELECT `Disqualified` FROM `Contestants` WHERE `username` = '{$_SESSION["username"]}'"; // $query = mysqli_fetch_array(mysqli_query($db_connection, $query)); // if (!isset($query["Disqualified"]) || $query["Disqualified"] == 1) { // destroy_session(); // mysqli_close($db_connection); // header("Location: ./index.php?msg=You%20have%20been%20disqualified..."); // die(); // } // unset($query); if (isset($from)) { if (checkFromVariable_Outside($from)) { header("Location: ./profile.php"); die;