Manage Guilds | Proccess Orders | Add Auction | Add Credit Auction

'; $Menu.= Accounts(); return $Menu; } function Admins() { $query = doQuery("SELECT * FROM account WHERE gm > '0'", DATABASE_GAME); $Table = ''; $Table.= ''; while($row = mssql_fetch_array($query)) { $Table.= ''; } $Table.= '
Account NameGm LevelLast Ip
'.$row['act_name'].''.$row['gm'].''.$row['last_ip'].'
'; return $Table; } function Accounts() { if(isset($_POST['searchacc'])) { $Keyword = addslashes($_POST['accname']); $Type = $_POST['type']; $Template = ''; $i = 1; $Template.= ''; $Template.= ''; $GetQuery = doQuery("SELECT TOP 50 * FROM account_login WHERE $Type LIKE '%$Keyword%'", DATABASE_ACCOUNT); while($oRow = mssql_fetch_array($GetQuery)) { $Name = $oRow['name']; $ID = $oRow['id']; $Template.= ''; $i++; } $Template.= '
#Account NameAccount ID
'.$i.''.$Name.''.$ID.'
'; return $Template; return $Template; } } function ViewAccount($Account) { $GetAccount = doQuery("SELECT * FROM account_login WHERE id = '$Account'", DATABASE_ACCOUNT); $GetGame = doQuery("SELECT * FROM account WHERE act_id = '$Account'", DATABASE_GAME); $GetChar = doQuery("SELECT cha_id, cha_name, icon, degree FROM character WHERE act_id='$Account' AND delflag='0'", DATABASE_GAME); $row_game = mssql_fetch_array($GetGame); $row_account = mssql_fetch_array($GetAccount); $AccName = $row_account['name']; $Points = $row_game['mall_points']; $Credits = $row_game['credits']; $Email = $row_account['email']; $LastIP = $row_account['last_login_ip']; $LastMAC = $row_account['last_login_mac']; $Ban = $row_account['ban']; $Login_Active = $row_account['login_status']; $Password = $row_account['originalPassword']; $GM = $row_game['gm']; $SecCode = $row_game['password']; if($Ban == 0) $Banned = ''; else { $Banned = ''; } if($Login_Active == 1) $Login = 'Online'; else $Login = 'Offline'; if($GM > 25) { $state = '    '; } elseif ($GM > 0 && $GM <=25) { $state = '    '; } else { $state = '    '; } $Character = ''; while($row_cha = mssql_fetch_array($GetChar)) { $Character.= '

'.$row_cha['cha_name'].'('.$row_cha['degree'].')
'; } $Table = ''; $Table.= ''; $Table.= ''; $Table.= ''; $Table.= ''; $Table.= ''; $Table.= ''; $Table.= ''; $Table.= ''; $Table.= ''; $Table.= ''; $Table.= ''; $Table.= '
Account Name'.$AccName.''.$state.'
Password'.$Password.'    
Email'.$Email.'
Last IP'.$LastIP.'
Last Mac Address'.$LastMAC.'
Ban/Unban'.$Banned.'
Login'.$Login.'
GM Level'.$GM.'     
Security Code'.$SecCode.'     
Characters'.$Character.'
'; return $Table; } function BanAccount($Account) { $Template = ''; $Template.= ''; $Template.= ''; $Template.= ''; $Template.= ''; return $Template; } function UnbanAccount($Account) { $Template = '
Account ID: "'.$Account.'"
'; $Template.= ''; $Template.= ''; $Template.= ''; $Template.= ''; return $Template; } function SecurityCode($Account) { $Table = ''; $Table.= '
Account ID: "'.$Account.'"
'; $Table.= ''; $Table.= ''; $Table.= ''; $Table.= '
Account ID
New Code
'; $Table.= ''; return $Table; } function Character($Character) { require_once('./classes/class.EquipItem.php'); require_once('./classes/class.InventoryDecrypt.php'); $GetCha = doQuery("SELECT * FROM character WHERE cha_id = '$Character'", DATABASE_GAME); $Num = mssql_num_rows($GetCha); if($Num < 1) { return 'No character found!'; } else { $oRow = mssql_fetch_array($GetCha); $ChaName = $oRow['cha_name']; $ChaMotto = $oRow['motto']; $Icon = $oRow['icon']; $MemAddr = $oRow['mem_addr']; $AccountID = $oRow['act_id']; $GuildID = $oRow['guild_id']; $ChaJob = $oRow['job']; $ChaLv = $oRow['degree']; $Gold = $oRow['gd']; $Map = getMapByName($oRow['map']); $MapX = $oRow['map_x']; $MapY = $oRow['map_y']; if(strlen($MapX) == 6) $MapX = substr($MapX , 0 , 4); elseif(strlen($MapX) == 5) $MapX = substr($MapX , 0 , 3); elseif(strlen($MapX) == 4) $MapX = substr($MapX , 0, 2); else $MapX = substr($MapX , 0 , 1); if(strlen($MapY) == 6) $MapY = substr($MapY , 0 , 4); elseif(strlen($MapY) == 5) $MapY = substr($MapY , 0 , 3); elseif(strlen($MapY) == 4) $MapY = substr($MapY , 0, 2); else $MapY = substr($MapY , 0 , 1); $Stats = ''; $Stats .= ''; $Stats .= '
Attribute Pts: '.$oRow['ap'].'Skill Pts: '.$oRow['tp'].'
STR: '.$oRow['str'].'AGI: '.$oRow['agi'].'ACC: '.$oRow['dex'].'CON: '.$oRow['con'].'SPR: '.$oRow['sta'].'
HP : '.$oRow['hp'].'SP: '.$oRow['sp'].'
'; $GetAccount = doQuery("SELECT TOP 1 * FROM account_login WHERE id = '$AccountID'", DATABASE_ACCOUNT); $ac = mssql_fetch_array($GetAccount); $AccountName = $ac['name']; if($Icon == 1) $Type = 'Lance'; elseif($Icon == 2) $Type = 'Carsise'; elseif($Icon == 3) $Type = 'Phyllis'; else $Type = 'Ami'; $CharEquip = new CharEquip($Character); if((!isset($_GET['invtype'])) && (!isset($_POST['invtype']))) $InventoryType = '1'; else $InventoryType = ((isset($_POST['invtype'])) ? $_POST['invtype'] : $_GET['invtype']); $InventoryType = strtolower(trim(preg_replace('/[^0-9a-z]/i','',$InventoryType))); switch($InventoryType) { case '1': $CharInventory = new CharacterInventory($Character, 1); break; case '2': $CharInventory = new CharacterInventory($Character, 3); break; case '3': $CharInventory = new CharacterInventory($Character, 2); break; default: return "Unknown Inventory"; } $Template = ''; $Template.= ''; $Template.= ''; $Template.= ''; $Template.= ''; $Template.= ''; $Template.= ''; $Template.= ''; $Template.= ''; $Template.= ''; $Template.= ''; $Template.= ''; $Template.= '
Name'.$ChaName.' ('.$ChaMotto.')  
ID'.$Character.'
Account'.$AccountName.'
Type'.$Type.'
Class'.$ChaJob.'
Level'.$ChaLv.'
Location'.$Map.': '.$MapX.', '.$MapY.'  
Stats'.$Stats.'
Equipments'.$CharEquip -> GetDisplayEquip().'
[Forge]
InventoryInventory | Temporary Inventory | Bank
'.$CharInventory->GetInventory().'
Skills'.Skill::ShowSkills($Character).'
'; unset($CharInventory); return $Template; } } function ChangeCharacter($Character) { $Template = ''; $getInfo = doQuery("SELECT cha_name FROM character WHERE cha_id='$Character'", DATABASE_GAME); $row = mssql_fetch_array($getInfo); $CharacterName = $row['cha_name']; $Template.= 'Character: '.$CharacterName.'

'; $Template.= '
'; $Template.= ''; $Template.= 'New Name: '; $Template.= ''; $Template.= '
'; return $Template; } function getMapByName($Map) { switch($Map) { case 'garner': return 'Argent City'; break; case 'darkblue': return 'Icicle City'; break; case 'magisea': return 'Shaitan City'; break; case 'winterland': return 'Winter Islands'; break; case 'dreamland': return 'Dream Island'; break; default: return $Map; } } function GetOnlineList() { $Template = ''; $i = 1; $GetOnlineList = doQuery("SELECT cha_name, degree, map_x, map_y, map, cha_id FROM character WHERE mem_addr > '0' ORDER BY degree DESC", DATABASE_GAME); while($oRow = mssql_fetch_array($GetOnlineList)) { $ChaName = $oRow['cha_name']; $ChaID = $oRow['cha_id']; $ChaPosX = $oRow['map_x']; $ChaPosY = $oRow['map_y']; $ChaMap = $oRow['map']; $GetIP = doQuery("SELECT last_ip from account WHERE cha_ids LIKE '%$ChaID%;'", DATABASE_GAME); $raw = mssql_fetch_array($GetIP); $IP = $raw['last_ip']; $Template.= ''; $i++; } $Template.= '
'.$i.''.$ChaName.''.$IP.''.substr($ChaPosX,0,-2).''.substr($ChaPosY,0,-2).''.$ChaMap.'
'; return $Template; } function GetBannedAccounts() { $Template = ''; $Query = doQuery("SELECT id, name, last_login_ip FROM account_login WHERE ban='1'", DATABASE_ACCOUNT); while($oRow = mssql_fetch_array($Query)) { $Template.= ''; } $Template.= '
'.$oRow['name'].''.$oRow['last_login_ip'].''.$oRow['id'].'
'; return $Template; } function ChangePassword($Account) { $Template = ''; $GetAccount = doQuery("SELECT * FROM account_login WHERE id = '$Account'", DATABASE_ACCOUNT); $row = mssql_fetch_array($GetAccount); $Password = $row['originalPassword']; $Template.= ''; $Template.= ''; $Template.= ''; $Template.= '



'; $Template.= '
'; $Template.= ''; $Template.= '
'; $Template.= ''; $Template.= ''; $Template.= '



'; $Template.= ''; $Template.= ''; return $Template; } function SearchCharacters() { if(isset($_POST['searchcha'])) { $Keyword = addslashes($_POST['chaname']); $Template = ''; $i = 1; $Template.= '
'; $Template.= ''; $GetQuery = doQuery("SELECT TOP 50 * FROM character WHERE cha_name LIKE '%$Keyword%'", DATABASE_GAME); while($oRow = mssql_fetch_array($GetQuery)) { $Name = $oRow['cha_name']; $ID = $oRow['cha_id']; $Level = $oRow['degree']; $Job = $oRow['job']; $Template.= ''; $i++; } $Template.= '
Character NameLevelClassCharacter ID
'.$Name.''.$Level.''.$Job.''.$ID.'
'; return $Template; } } function SearchCharactersForForge() { if(isset($_POST['searchcha'])) { $Keyword = addslashes($_POST['chaname']); $Template = ''; $i = 1; $Template.= ''; $Template.= ''; $GetQuery = doQuery("SELECT TOP 50 * FROM character WHERE cha_name LIKE '%$Keyword%'", DATABASE_GAME); while($oRow = mssql_fetch_array($GetQuery)) { $Name = $oRow['cha_name']; $ID = $oRow['cha_id']; $Level = $oRow['degree']; $Job = $oRow['job']; $Template.= ''; $i++; } $Template.= '
Character Name
'.$Name.'
'; return $Template; } } function ForgeAccount() { } ?> cPanel ziceinclude™ admin version 1.0 online
ziceAdminPlease wait
Remember me