Sveiki atrodo jau susitvarkiau visa acp bet kazkodel prisijungti leidzia o kai bandau chara pasirinkti jo nerodo toks jausmas kad neranda ID,atrodo viska perziurejau tiek cfg tiek duom. baze nu ir viskas atrodo ok bet vistiek taspats sudas.

Gal kazka praleidau uzmeskite aki patys:

čia acp ss ir duom bazes: Noredami padidinti image spauskite atidaryti naujame lange.



Na o čia pacio acp configas:

Kodas: Pasirinkti visus

<?php
   $queryLogin['checkAccount']               = "SELECT `login`,`email` FROM `accounts` WHERE `login` = ? OR `email` = ?;";
   $queryLogin['checkEmail']               = "SELECT `email` FROM `accounts` WHERE `email` = ?;";
   $queryLogin['updateEmail']               = "UPDATE `accounts` SET `email` = ? WHERE `login` = ?;";
   $queryLogin['createAccount']            = "INSERT INTO `accounts` (`login`,`password`,`email`,`access_level`,`lastIP`) VALUES (?,?,?,?,?);";
   $queryLogin['loginToAccount']            = "SELECT `login` FROM `accounts` WHERE `login` = ? AND `password` = ?;";
   $queryLogin['changePassword']            = "UPDATE `accounts` SET `password` = ? WHERE `login` = ?;";
   $queryLogin['selectAccountData']         = "SELECT `email`,`access_level`,`lastIP` FROM `accounts` WHERE `login` = ?;";
   $queryLogin['updatePlayerBan']            = "UPDATE `accounts` SET `access_level` = 0 WHERE `login` = ? AND `access_level` < -1;";
   
   $queryLogin['disableAccount']            = "UPDATE `accounts` SET `access_level` = -100 WHERE `login` = ?;";
   
   $queryGame['selectAllCharacters']         = "SELECT `obj_Id`,`char_name` FROM `characters` WHERE `account_name` = ?;";
   $queryGame['selectCharacterData']         = "SELECT `char_name`,`online` FROM `characters` WHERE `account_name` = ? AND `obj_Id` = ?;";

   $queryGame['selectPlayerItemData']         = "SELECT `obj_Id` FROM `items` WHERE `owner_id` = ? AND `item_id` = ?;";
   $queryGame['updatePlayerItemCount']         = "UPDATE `items` SET `count` = count+? WHERE `obj_Id` = ?;";
   $queryGame['addItemToPlayerInventory']      = "INSERT INTO `items` (`owner_id`,`obj_Id`,`item_id`,`count`,`enchant_level`,`loc`,`time`) VALUES (?,(SELECT MAX(obj_Id)+1 FROM items AS obj_Id),?,?,?,'INVENTORY',-1);";
   $queryGame['selectAllPlayerItems']         = "SELECT `obj_Id`,`item_id`,`enchant_level` FROM `items` WHERE `owner_id` = ? AND `count` = 1 ORDER BY `item_id` DESC, `enchant_level` DESC;";
   $queryGame['selectPlayerItemEnchantData']   = "SELECT `enchant_level`,`item_id` FROM `items` WHERE `obj_Id` = ? AND `owner_id` = ?;";
   $queryGame['updateEnchantOnItem']         = "UPDATE `items` SET `enchant_level` = enchant_level+1 WHERE `obj_Id` = ?;";

   $queryGame['updatePlayerSex']            = "UPDATE `characters` SET `sex` = 1-sex WHERE `obj_Id` = ?;";
   $queryGame['removePlayerPK']            = "UPDATE `characters` SET `pkkills` = 0 WHERE `obj_Id` = ?;";
   $queryGame['removePlayerKarma']            = "UPDATE `characters` SET `karma` = 0 WHERE `obj_Id` = ?;";
   $queryGame['updatePlayerNoblesse']         = "UPDATE `characters` SET `nobless` = 1 WHERE `obj_Id` = ?;";
   $queryGame['updatePlayerJail']            = "UPDATE `characters` SET `punish_level` = 0, `punish_timer` = 0 WHERE `obj_Id` = ?;";
   $queryGame['updatePlayerLocation']         = "UPDATE `characters` SET `x` = ?, `y` = ?, `z` = ? WHERE `obj_Id` = ?;";
?>