Server « [3.2.2a] Fantasy Netgames SK Free WoW Server

0) { // user je prihlaseny // $flags nie je, pouziva sa $lang['transfer_flag_'] if (isset($_POST['character_race'])) { // vyberieme vsetky ziadosti pre kontrolu ci sa postnuta ziadost uz nenachadza $query = " SELECT `charactername_original` as `transfer_character_original_name` FROM `transfers` WHERE `accid` = '".$user['id']."' ORDER BY `posted` DESC"; $requests = $DB->selectCol($query); // ak taka ziadost este neexistuje if(!in_array($_POST['character_original_name'], $requests)){ $trueKeys = array( "original_server_web" => "web", "original_server_realmlist" => "realmlist", "original_server_account" => "account", "original_server_password" => "password", "character_original_name" => "charactername_original", "character_new_name" => "charactername_new", "character_race" => "char_race", "character_level" => "char_level", "character_class" => "char_class", "comment" => "comment" ); $needed = array( "original_server_web", "original_server_realmlist", "original_server_account", "character_original_name", "character_level", "character_race", "character_class" ); $allSet = ( !empty($_POST["original_server_web"]) && !empty($_POST["original_server_realmlist"]) && !empty($_POST["original_server_account"]) && !empty($_POST["character_original_name"]) && !empty($_POST["character_race"]) && !empty($_POST["character_level"]) && !empty($_POST["character_class"]) ); echo ($allSet ? "All set" : "ERROR"); if ($allSet) { $query = "INSERT INTO `transfers` SET "; // data od uzivatela foreach ($_POST as $key=>$value) { if (array_key_exists($key, $trueKeys)) $query .= "`$trueKeys[$key]` = '$value', "; } // systemove data $query .= "`posted` = ".time().", `accid` = ".$user['id'].", `flag` = 0"; $DB->query($query); //echo $query; } else{ foreach ($needed as $key) { if(empty($_POST[$key])) $error[$key] = $lang["transfer_".$key]." ".$lang['transfer_error_missing']; } } } else{ // ak uz existuje $error[] = $lang["transfer_request_exist"]; } /* echo '

';
   print_r($error);
   echo '

'; */ } // zmazeme ziadost, ak si to uzivatel praje if(!empty($_GET["transfer_delete"])) { $query = " DELETE FROM `transfers` WHERE `id` = '".$_GET["transfer_delete"]."' AND `accid` = '".$user['id']."' AND `flag` IN (0,1,3)"; $DB->query($query); } // vyberieme vsetky ziadosti $query = " SELECT `id` as `transfer_id`, `realmlist` as `transfer_original_server`, `charactername_original` as `transfer_character_original_name`, `charactername_new` as `transfer_character_new_name`, `posted` as `transfer_posted`, `flag` as `transfer_status` FROM `transfers` WHERE `accid` = '".$user['id']."' ORDER BY `posted` DESC"; $requests = $DB->query($query); } else{ // user nie je prihlaseny, musi sa prihlasit $error[] = $lang["transfer_user_not_logged"]; } ?> Server « [3.2.2a] Fantasy Netgames SK Free WoW Server