21 lines
516 B
PHP
21 lines
516 B
PHP
<?php
|
|
|
|
include('connection.php');
|
|
$conn = OpenCon();
|
|
|
|
$username = $_GET['username'];
|
|
$points = $_GET['points'];
|
|
|
|
$selectSql = "SELECT points FROM Leaderboard WHERE username='$username'";
|
|
$selectQuery = mysqli_query($conn, $selectSql);
|
|
$setQuery = "INSERT INTO Leaderboard (username, points) VALUES('$username', $points)";
|
|
if(mysqli_num_rows($selectQuery) > 0){
|
|
//insert
|
|
$setQuery ="UPDATE Leaderboard SET points=$points WHERE username='$username'";
|
|
}
|
|
|
|
if(mysqli_query($conn, $setQuery)){
|
|
echo "0";
|
|
}
|
|
|
|
?>
|