include("ajax_header.php");
switch($_GET['function']) {
case "doTraining":
if($CharacterInfo['last_training_day'] != date("Y-m-d")) {
if($CharacterInfo['money'] >= ($CharacterInfo['level'] * 1000)) {
$sql = mysql_query("INSERT INTO training (user_id, time_expires) VALUES ('{$CharacterInfo['id']}', DATE_ADD(NOW(), INTERVAL 10 MINUTE))");
$cost = ($CharacterInfo['level'] * 1000);
updateCharacter("money", "(money - {$cost})", $CharacterInfo['id']);
updateCharacter("last_training_day", "CURRENT_DATE()", $CharacterInfo['id']);
print "Your training has begun. Cost " . format($cost) . " KD";
} else
print "Please withdraw at least " . format($CharacterInfo['level'] * 1000) . " KD";
} else
print "Ahem. You've already trained today!";
break;
case "checkName":
$sql = mysql_query("SELECT COUNT(id) FROM characters WHERE name = '{$get_safe['name']}'");
if(mysql_result($sql, 0) > 0)
print "
";
else
print "
";
break;
case "getMoney":
print format($CharacterInfo['money']);
break;
case "deleteAlert":
$sqlCheck = mysql_query("SELECT id FROM alerts WHERE id = '{$post_safe['id']}' AND receiver_id = '{$CharacterInfo['id']}'") or print(mysql_error());
if(mysql_num_rows($sqlCheck) == 1) {
mysql_query("DELETE FROM alerts WHERE id = '{$post_safe['id']}' AND receiver_id = '{$CharacterInfo['id']}'");
$result["status"] = true;
$result["message"] = "";
} else {
$result["status"] = false;
$result["message"] = "No.";
}
print json_encode($result);
break;
case "deleteAlerts":
$alerts = explode("&", urldecode($post_safe['alerts']));
foreach($alerts as $id) {
$t_id = explode("=", $id);
$rid = $t_id[1];
$sqlCheck = mysql_query("SELECT id FROM alerts WHERE id = '{$rid}' AND receiver_id = '{$CharacterInfo['id']}'") or print(mysql_error());
if(mysql_num_rows($sqlCheck) == 1) {
mysql_query("DELETE FROM alerts WHERE id = '{$rid}' AND receiver_id = '{$CharacterInfo['id']}'");
}
}
break;
case "getCharacterNames":
$sql = mysql_query("SELECT name FROM characters WHERE name LIKE '{$get_safe['q']}%' ORDER by name");
while($r = mysql_fetch_array($sql)) {
print "{$r['name']}\n";
}
mysql_free_result($sql);
break;
}
?>