function select_info_admin($bdd2, $id) { $id = protect_sql($id, "intval"); $finish = array(); $sql = "SELECT id_admin, login, email, id_ranks FROM `administrators` WHERE id_admin = " . $id . ""; if ($data = $bdd2->query_select($sql)) { $sql_2 = "SELECT * FROM `administrators_ranks` WHERE id_rank = " . $data[0]['id_ranks'] . ""; if ($data_2 = $bdd2->query_select($sql_2)) { $data[0]['rank'] = $data_2[0]['name']; return $data[0]; } return 0; } else { return 0; } }
function select_info_user($bdd2, $id) { $id = protect_sql($id, "intval"); $finish = array(); $sql = "SELECT id_player, login, email, nbr_points FROM `players` WHERE id_player = " . $id . ""; if ($data = $bdd2->query_select($sql)) { $sql_2 = "SELECT * FROM `players_grades` WHERE " . $data[0]['nbr_points'] . " BETWEEN min_points AND max_points"; if ($data_2 = $bdd2->query_select($sql_2)) { $data[0]['grade'] = $data_2[0]['name']; return $data[0]; } return 0; } else { return 0; } }
function delete_type($bdd2, $id) { $id = protect_sql($id, "intval"); $sql = "DELETE FROM type_of_games WHERE id_type_game = '" . $id . "'"; if ($bdd2->query($sql)) { return 1; } else { return 0; } }
function update_article_sql($id, $title, $firstname, $name, $desc, $age, $price) { $title = protect_sql($title, "none"); $firstname = protect_sql($firstname, "none"); $name = protect_sql($name, "none"); $desc = protect_sql($desc, "none"); $age = protect_sql($age, "intval"); $price = protect_sql($price, "intval"); $sql = 'UPDATE articles SET title = "' . $title . '", firstname_articles = "' . $firstname . '", name_articles = "' . $name . '", desc_articles = "' . $desc . '", age = "' . $age . '", price = "' . $price . '" WHERE id_articles = "' . $id . '"'; $bdd = connect_bdd(); if (mysqli_query($bdd, $sql)) { mysqli_close($bdd); return 1; } else { echo mysqli_error($bdd); mysqli_close($bdd); return 0; } }
function check_game($bdd2, $id) { $id = protect_sql($id, "intval"); $sql = "SELECT id_game FROM `play_in` WHERE id_player = '" . $id . "'"; if ($data = $bdd2->query_select($sql)) { foreach ($data as $key => $value) { $sql2 = "SELECT state FROM `games` WHERE id_game = '" . $data[0]['id_game'] . "'"; if ($data2 = $bdd2->query_select($sql2)) { if ($data2[0]['state'] != "Finie") { return 1; } } } return 0; } else { return 0; } }