Quando cria um novo personagem ele vem sem posição

Postado Setembro 2, 2018 6 anos

meu servidor ta rodando mysql e quando eu crio qualquer vocação ele vem sem posição

as vezes quando eu fecho a distro e abro de novo a posição volta ao normal e eu posso logar normalmente, mais se for pra ficar assim desligando o servidor toda hora que uma pessoa criar um boneco ou pra mim ficar mudando a posição pra cada novo boneco é melhor eu desistir e deletar esse ot.... alguém me da um help ai.....

configuração do config.lua

Spoiler

   sqlType = "mysql"
   sqlHost = "127.0.0.1"
   sqlPort = 3306
   sqlUser = "root"
   sqlPass = "Daltro321"
   sqlDatabase = "Tibia Alpha"
   sqlFile = "otxserver.s3db"
   sqlKeepAlive = 0
   mysqlReadTimeout = 1000
   mysqlWriteTimeout = 1000
   mysqlReconnectionAttempts = 5
   encryptionType = "sha1"

   worldId = 0
   ip = "127.0.0.1"
   worldType = "open"
   bindOnlyGlobalAddress = false
   loginPort = 7171
   gamePort = "7172"
   statusPort = 7171
   loginOnlyWithLoginServer = false

   accountManager = true
   namelockManager = false
   newPlayerChooseVoc = true
   newPlayerSpawnPosX = 331
   newPlayerSpawnPosY = 46
   newPlayerSpawnPosZ = 6
   newPlayerTownId = 6
   newPlayerLevel = 8
   newPlayerMagicLevel = 0
   generateAccountNumber = false
   generateAccountSalt = false

meu confing.php

Spoiler

<?PHP
# Account Maker Config
$config['site']['serverPath'] = "C:/Users/CCE/Desktop/Emanuel/Tibia Alpha/";
$config['site']['useServerConfigCache'] = false;
$config['site']['worlds'] = array(0 => 'Tibia Alpha');
$towns_list[0] = array(1 => 'Alpha City', 2 => 'Zarkar', 3 => 'Carlin', 4 => 'Venore', 5 => 'Morgum', 6 => 'New City');

$config['site']['outfit_images_url'] = '/outfit.php';
$config['site']['item_images_url'] = 'http://item-images.ots.me/860/';
$config['site']['item_images_extension'] = '.gif';
$config['site']['flag_images_url'] = 'http://flag-images.ots.me/';
$config['site']['flag_images_extension'] = '.png';
$config['site']['players_group_id_block'] = 3;
$config['site']['limitDeath'] = 5;
$config['site']['levelVideo'] = 150;

# PAGE: donate.php
$config['site']['usePagseguro'] = true; //true show / false hide
$config['site']['usePaypal'] = false;   //true show / false hide
$config['site']['useDeposit'] = true;   //true show / false hide
$config['site']['useZaypay'] = false;   //true show / false hide
$config['site']['useContenidopago'] = false;   //true show / false hide
$config['site']['useOnebip'] = false;   //true show / false hide

# Pagseguro config By IVENSPONTES
$config['pagSeguro']['email'] = "[email protected]"; //Email Pagseguro
$config['pagSeguro']['token'] = "YOURTOKENHERE"; // TOKEN
$config['pagSeguro']['urlRedirect'] = 'http://seusite.com/?subtopic=donate&action=final'; //turn off redirect and notifications in pagseguro.com.br
$config['pagSeguro']['urlNotification'] = 'http://seusite.com/retpagseguro.php'; //your return location

$config['pagSeguro']['productName'] = 'Premium Points';
$config['pagSeguro']['productValue'] = 1.00; // 1.50 = R$ 1,50 etc...
$config['pagSeguro']['doublePoints'] = false; ## Double points - true is on / false is off

$config['pagSeguro']['host'] = 'localhost';       ## YOUR HOST
$config['pagSeguro']['database'] = 'Tibia Alpha';   ## DATABASE
$config['pagSeguro']['databaseUser'] = 'root';   ## USER
$config['pagSeguro']['databasePass'] = 'Daltro321';       ## PASSWORD

# Create Account Options
$config['site']['one_email'] = false;
$config['site']['create_account_verify_mail'] = 0;
$config['site']['verify_code'] = true;
$config['site']['email_days_to_change'] = 3;
$config['site']['newaccount_premdays'] = 0;
$config['site']['send_register_email'] = 1;

# Create Character Options
$config['site']['newchar_vocations'][0] = array(1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample');
$config['site']['max_players_per_account'] = 4;

# Emails Config
$config['site']['send_emails'] = 1; // is acc. maker configured to send e-mails?
$config['site']['mail_address'] = "[email protected]"; // e-mail address
$config['site']['smtp_enabled'] = "yes"; // send by smtp or mail function (set 0 if use mail function)
$config['site']['smtp_host'] = "smtp.gmail.com"; // address
$config['site']['smtp_port'] = 587; // port
$config['site']['smtp_auth'] = "yes"; // need authorization? (set 0 if not need auth)
$config['site']['smtp_user'] = "[email protected]"; // login
$config['site']['smtp_pass'] = "emanuel321"; // password

# PAGE: whoisonline.php
$config['site']['private-servlist.com_server_id'] = 1;
/*
Server id on 'private-servlist.com' to show Players Online Chart (whoisonline.php page), set 0 to disable Chart feature.
To use this feature you must register on 'private-servlist.com' and add your server.
Format: number, 0 [disable] or higher
*/

# PAGE: characters.php
$config['site']['quests'] = array('Annihilator' => 5000,'Demon Helmet' => 2645,'Pits of Inferno' => 5550);
$config['site']['show_skills_info'] = true;
$config['site']['show_vip_storage'] = 0;

# PAGE: accountmanagement.php
$config['site']['send_mail_when_change_password'] = 1;
$config['site']['send_mail_when_generate_reckey'] = 1;
$config['site']['generate_new_reckey'] = true;
$config['site']['generate_new_reckey_price'] = 5;

# PAGE: guilds.php
$config['site']['guild_need_level'] = 100;
$config['site']['guild_need_pacc'] = false;
$config['site']['guild_image_size_kb'] = 50;
$config['site']['guild_description_chars_limit'] = 2000;
$config['site']['guild_description_lines_limit'] = 6;
$config['site']['guild_motd_chars_limit'] = 250;

# PAGE: adminpanel.php
$config['site']['access_admin_panel'] = 3;
$config['site']['access_tickers'] = 3;
$config['site']['access_admin_painel'] = 3;
$config['site']['access_staff_painel'] = 3;
$config['site']['access_news'] = 3;

# PAGE: latestnews.php
$config['site']['news_limit'] = 6;

# PAGE: killstatistics.php
$config['site']['last_deaths_limit'] = 40;

# PAGE: team.php
$config['site']['groups_support'] = array(2, 3, 4, 5, 6, 7);

# PAGE: highscores.php
$config['site']['groups_hidden'] = array(4, 5, 6);
$config['site']['accounts_hidden'] = array(1);

# PAGE: shopsystem.php
$config['site']['shop_system'] = true;
$config['site']['shopguild_system'] = true;

# PAGE: lostaccount.php
$config['site']['email_lai_sec_interval'] = 180;

# Layout Config
$config['site']['layout'] = 'tibiarl';
$config['site']['vdarkborder'] = '#505050';
$config['site']['darkborder'] = '#D4C0A1';
$config['site']['lightborder'] = '#F1E0C6';
$config['site']['download_page'] = true;
$config['site']['serverinfo_page'] = true;

Editado Setembro 2, 2018 6 anos por Emanueldk (veja o histórico de edições)

Citar

Mention

Postado Setembro 2, 2018 6 anos

Autor

@victor4312 bllz funcionou, mais ta dando esse erro Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\classes\website.php on line 222

quando eu crio a conta

website.php

Spoiler

<?php
if(!defined('INITIALIZED'))
exit;

class Website extends WebsiteErrors
{
   public static $serverConfig;
   public static $websiteConfig;
   public static $vocations;
   public static $groups;
   public static $SQL;
   public static $passwordsEncryptions = array(
   'plain' => 'plain',
   'md5' => 'md5',
   'sha1' => 'sha1',
   'sha256' => 'sha256',
   'sha512' => 'sha512',
   'vahash' => 'vahash'
   );
   private static $passwordsEncryption;

   public static function setDatabaseDriver($value)
   {
       self::$SQL = null;

       switch($value)
       {
           case Database::DB_MYSQL:
               self::$SQL = new Database_MySQL();
               break;
           case Database::DB_SQLITE:
               self::$SQL = new Database_SQLite();
               break;
       }
   }

public static function getDBHandle()
 {
 if(isset(self::$SQL))
 return self::$SQL;
 else
 new Error_Critic('#C-9', 'ERROR: #C-9 : Class::Website - getDBHandle(), database driver not set.');
 }

   public static function loadWebsiteConfig()
   {
       self::$websiteConfig = new ConfigPHP();
       global $config;
       self::$websiteConfig->setConfig($config['site']);
   }

   public static function getWebsiteConfig()
   {
       if(!isset(self::$websiteConfig))
           self::loadWebsiteConfig();

return self::$websiteConfig;
}

   public static function loadServerConfig()
   {
       self::$serverConfig = new ConfigPHP();
       global $config;
       self::$serverConfig->setConfig($config['server']);
   }

   public static function getServerConfig()
   {
       if(!isset(self::$serverConfig))
           self::loadServerConfig();

return self::$serverConfig;
}

   public static function getConfig($fileNameArray)
   {
       $fileName = implode('_', $fileNameArray);

if(Functions::isValidFolderName($fileName))
 {
 $_config = new ConfigPHP('./config/' . $fileName . '.php');
 return $_config;
 }
 else
 new Error_Critic('', __METHOD__ . ' - invalid folder/file name ' . htmlspecialchars('./config/' . $fileName . '.php') . '');
 }

   public static function getFileContents($path)
   {
       $file = file_get_contents($path);

if($file === false)
new Error_Critic('', __METHOD__ . ' - Cannot read from file: ' . htmlspecialchars($path) . '');

return $file;
}

   public static function putFileContents($path, $data, $append = false)
   {
       if($append)
           $status = file_put_contents($path, $data, FILE_APPEND);
       else
           $status = file_put_contents($path, $data);

if($status === false)
new Error_Critic('', __METHOD__ . ' - Cannot write to: ' . htmlspecialchars($path) . '');

return $status;
}

   public static function deleteFile($path)
   {
       unlink($path);
   }

   public static function fileExists($path)
   {
       return file_exists($path);
   }

   public static function setPasswordsEncryption($encryption)
   {
       if(isset(self::$passwordsEncryptions[strtolower($encryption)]))
           self::$passwordsEncryption = strtolower($encryption);
       else
           new Error_Critic('#C-12', 'Invalid passwords encryption ( ' . htmlspecialchars($encryption) . '). Must be one of these: ' . implode(', ', self::$passwordsEncryptions));
   }

   public static function getPasswordsEncryption()
   {
       return self::$passwordsEncryption;
   }

   public static function validatePasswordsEncryption($encryption)
   {
       if(isset(self::$passwordsEncryptions[strtolower($encryption)]))
           return true;
       else
           return false;
   }

   public static function encryptPassword($password, $account = null)
   {
       // add SALT for 0.4
       if(isset(self::$passwordsEncryption))
           if(self::$passwordsEncryption == 'plain')
               return $password;
           else
               return hash(self::$passwordsEncryption, $password);
       else
           new Error_Critic('#C-13', 'You cannot use Website::encryptPassword(\$password) when password encryption is not set.');
   }

   public static function loadVocations()
   {
       $path = self::getWebsiteConfig()->getValue('serverPath');
       self::$vocations = new Vocations($path . 'data/XML/vocations.xml');
   }

   public static function getVocations()
   {
       if(!isset(self::$vocations))
           self::loadVocations();

return self::$vocations;
}

   public static function getVocationName($id, $promotion)
   {
       if(!isset(self::$vocations))
           self::loadVocations();

return self::$vocations->getVocationName($id, $promotion);
}

   public static function loadGroups()
   {
       $path = self::getWebsiteConfig()->getValue('serverPath');
       self::$groups = new Groups($path . 'data/XML/groups.xml');
   }

   public static function getGroups()
   {
       if(!isset(self::$groups))
           self::loadGroups();

return self::$groups;
}

   public static function getGroupName($id)
   {
       if(!isset(self::$groups))
           self::loadGroups();

return self::$groups->getGroupName($id);
}

public static function getCountryCode($IP)
 {
 $a = explode(".",$IP);
 if($a[0] == 10) // IPs 10.0.0.0 - 10.255.255.255 = private network, so can't geolocate
 return 'unknown';
 if($a[0] == 127) // IPs 127.0.0.0 - 127.255.255.255 = local network, so can't geolocate
 return 'unknown';
 if($a[0] == 172 && ($a[1] >= 16 && $a[1] <= 31)) // IPs 172.16.0.0 - 172.31.255.255 = private network, so can't geolocate
 return 'unknown';
 if($a[0] == 192 && $a[1] == 168) // IPs 192.168.0.0 - 192.168.255.255 = private network, so can't geolocate
 return 'unknown';
 if($a[0] >= 224) // IPs over 224.0.0.0 are not assigned, so can't geolocate
 return 'unknown';
 $longIP = $a[0] * 256 * 256 * 256 + $a[1] * 256 * 256 + $a[2] * 256 + $a[3]; // we need unsigned value
 if(!file_exists('cache/flags/flag' . $a[0]))
 {
 $flagData = @file_get_contents('http://country-flags.ots.me/flag' . $a[0]);
 if($flagData === false)
 return 'unknown';
 if(@file_put_contents('cache/flags/flag' . $a[0], $flagData) === false)
 return 'unknown';
 }
 $countries = unserialize(file_get_contents('cache/flags/flag' . $a[0])); // load file
 $lastCountryCode = 'unknown';
 foreach($countries as $fromLong => $countryCode)
 {
 if($fromLong > $longIP)
 break;
 $lastCountryCode = $countryCode;
 }
 return $lastCountryCode;
 }
}