<?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";
}

?>