= ($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; } ?>