Registruotis Prisijungti Forumas Ieškoti DUK |
Acp neleidzia pasirinkti charo [Pagalba]
1 pranešimas
• Puslapis 1 iš 1
Acp neleidzia pasirinkti charo [Pagalba]
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:
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` = ?;";
?>
1 pranešimas
• Puslapis 1 iš 1
Dabar prisijungę
Vartotojai naršantys šį forumą: Registruotų vartotojų nėra ir 1 svečias