} else {
if ($game_score > $score_game['game_score']) {
$result = mysql_query("update game_scores set game_score={$game_score} where game_id={$game_id} and user_id={$user_id}");
if ($result) {
echo json_encode("Score Saved in Leaderboard !");
} else {
echo json_encode("Score Saved in Leaderboard !");
}
}
}
} else {
$user_overall_points = $total_points;
addNewUserPoints($user_id, $game_id, $total_points, $user_overall_points);
$createdAt = date("Y-m-d H:i:s");
$updatedAt = date("Y-m-d H:i:s");
$game_scores = getGameScoreByUser($user_id, $game_id);
$score_game = mysql_fetch_array($game_scores);
if ($score_game['game_score'] == "") {
$result = mysql_query("insert into game_scores(game_id,user_id,game_score,createdAt,updateAt,isgarbeg) values({$game_id},{$user_id},{$game_score},'{$createdAt}','{$updatedAt}','no')");
if ($result) {
echo json_encode("Score Saved in Leaderboard!");
} else {
echo json_encode("Score Saved in Leaderboard!");
}
} else {
if ($game_score > $score_game['game_score']) {
$result = mysql_query("update game_scores set game_score={$game_score} where game_id={$game_id} and user_id={$user_id}");
if ($result) {
echo json_encode("Score Saved in Leaderboard !");
} else {
echo json_encode("Score Saved in Leaderboard !");
<?php
session_start();
include "dbconnection.php";
$game_score = $_GET['game_score'];
$user_id = $_SESSION['user_loged_id'];
$game_id = $_SESSION['game_id'];
$createdAt = date("Y-m-d H:i:s");
$updatedAt = date("Y-m-d H:i:s");
$result = getGameScoreByUser($user_id, $game_id);
if ($result > 0) {
$user_score = mysql_fetch_array($result);
$game_score_id = $user_score['score_id'];
$result = mysql_query("update game_scores set game_score={$game_score} where score_id={$game_score_id}");
if ($result) {
header('Content-type: application/json');
echo json_encode("Score Saved in Leaderboard !");
} else {
header('Content-type: application/json');
echo json_encode("Score not saved");
}
} else {
$result = mysql_query("insert into game_scores(game_id,user_id,game_score,createdAt,updateAt) values({$game_id},{$user_id},{$game_score},'{$createdAt}','{$updatedAt}')");
if ($result) {
header('Content-type: application/json');
echo json_encode("Score Saved in Leaderboard !");
} else {
header('Content-type: application/json');
echo json_encode("Score not saved");
}
}
