slaw
Software Developer
And when does it do that? How do I force it to?
It will automatically get version from your database, and upgrades it. Its in index.php, so it will do it on first page refresh. You don't need to do anything.
And when does it do that? How do I force it to?
INSERT INTO `players` (`id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `lastlogout`, `balance`, `$deleted`, `created`, `hidden`, `comment`) VALUES
(null, 'Rook Sample', 1, 1, 8, 0, 185, 185, 4200, 118, 114, 38, 57, 130, 0, 35, 35, 0, 100, 11, 2200, 1298, 7, '', 470, 1, 1255179613, 2453925456, 1, 1255179614, 0, 1, UNIX_TIMESTAMP(), 1, ''),
(null, 'Sorcerer Sample', 1, 1, 8, 1, 185, 185, 4200, 118, 114, 38, 57, 130, 0, 35, 35, 0, 100, 11, 2200, 1298, 7, '', 470, 1, 1255179571, 2453925456, 1, 1255179612, 0, 1, UNIX_TIMESTAMP(), 1, ''),
(null, 'Druid Sample', 1, 1, 8, 2, 185, 185, 4200, 118, 114, 38, 57, 130, 0, 35, 35, 0, 100, 11, 2200, 1298, 7, '', 470, 1, 1255179655, 2453925456, 1, 1255179658, 0, 1, UNIX_TIMESTAMP(), 1, ''),
(null, 'Paladin Sample', 1, 1, 8, 3, 185, 185, 4200, 118, 114, 38, 57, 129, 0, 35, 35, 0, 100, 11, 2200, 1298, 7, '', 470, 1, 1255179854, 2453925456, 1, 1255179858, 0, 1, UNIX_TIMESTAMP(), 1, ''),
(null, 'Knight Sample', 1, 1, 8, 4, 185, 185, 4200, 118, 114, 38, 57, 131, 0, 35, 35, 0, 100, 11, 2200, 1298, 7, '', 470, 1, 1255179620, 2453925456, 1, 1255179654, 0, 1, UNIX_TIMESTAMP(), 1, '');
INSERT INTO `players` (`id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `lastlogout`, `balance`, `deleted`, `created`, `hidden`, `comment`) VALUES
(null, 'Rook Sample', 1, 1, 8, 0, 185, 185, 4200, 118, 114, 38, 57, 130, 0, 35, 35, 0, 100, 11, 2200, 1298, 7, '', 470, 1, 1255179613, 2453925456, 1, 1255179614, 0, 1, UNIX_TIMESTAMP(), 1, ''),
(null, 'Sorcerer Sample', 1, 1, 8, 1, 185, 185, 4200, 118, 114, 38, 57, 130, 0, 35, 35, 0, 100, 11, 2200, 1298, 7, '', 470, 1, 1255179571, 2453925456, 1, 1255179612, 0, 1, UNIX_TIMESTAMP(), 1, ''),
(null, 'Druid Sample', 1, 1, 8, 2, 185, 185, 4200, 118, 114, 38, 57, 130, 0, 35, 35, 0, 100, 11, 2200, 1298, 7, '', 470, 1, 1255179655, 2453925456, 1, 1255179658, 0, 1, UNIX_TIMESTAMP(), 1, ''),
(null, 'Paladin Sample', 1, 1, 8, 3, 185, 185, 4200, 118, 114, 38, 57, 129, 0, 35, 35, 0, 100, 11, 2200, 1298, 7, '', 470, 1, 1255179854, 2453925456, 1, 1255179858, 0, 1, UNIX_TIMESTAMP(), 1, ''),
(null, 'Knight Sample', 1, 1, 8, 4, 185, 185, 4200, 118, 114, 38, 57, 131, 0, 35, 35, 0, 100, 11, 2200, 1298, 7, '', 470, 1, 1255179620, 2453925456, 1, 1255179654, 0, 1, UNIX_TIMESTAMP(), 1, '');
@slawkens
I really like your aac and your effort on this project but why are you trying to support old and deprecated versions of tfs server? This aac should be oriented to tfs 1.0+ but ofc thats only my opinion
I will try to contribute a bit with some plugins
@slawkens
I really like your aac and your effort on this project but why are you trying to support old and deprecated versions of tfs server? This aac should be oriented to tfs 1.0+ but ofc thats only my opinion
I will try to contribute a bit with some plugins
I tried to create the Play button before in MyAAC but couldn't get it to work without breaking everything. Don't know if it has already been made but I haven't found it anywhere yet.
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lookaddons' in 'field list'' in D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Base_DB.php:100 Stack trace: #0 D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Base_DB.php(100): PDO->query('SELECT accounts...') #1 D:\Tibia Projekt\xampp\htdocs\system\pages\highscores.php(139): OTS_Base_DB->query('SELECT accounts...') #2 D:\Tibia Projekt\xampp\htdocs\index.php(225): require('D:\\Tibia Projek...') #3 {main} thrown in D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Base_DB.php on line 100
Code:Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lookaddons' in 'field list'' in D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Base_DB.php:100 Stack trace: #0 D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Base_DB.php(100): PDO->query('SELECT accounts...') #1 D:\Tibia Projekt\xampp\htdocs\system\pages\highscores.php(139): OTS_Base_DB->query('SELECT accounts...') #2 D:\Tibia Projekt\xampp\htdocs\index.php(225): require('D:\\Tibia Projek...') #3 {main} thrown in D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Base_DB.php on line 100
After clicking at highscore or who is online i get this error. After trying to find character through characters i get the white screen only. OTHire 0.0.3. MyAcc 0.1.5
$config['online_outfit'] = false;
$config['highscores_outfit'] = false;
$config['characters']['outfit'] = false;
Ok, this has been fixed.Code:Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lookaddons' in 'field list'' in D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Base_DB.php:100 Stack trace: #0 D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Base_DB.php(100): PDO->query('SELECT accounts...') #1 D:\Tibia Projekt\xampp\htdocs\system\pages\highscores.php(139): OTS_Base_DB->query('SELECT accounts...') #2 D:\Tibia Projekt\xampp\htdocs\index.php(225): require('D:\\Tibia Projek...') #3 {main} thrown in D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Base_DB.php on line 100
After clicking at highscore or who is online i get this error. After trying to find character through characters i get the white screen only. OTHire 0.0.3. MyAcc 0.1.5
It's possible to change encryption?
-- accounts password type
-- options: plain, md5, sha1
passwordtype = "plain"
Great job dude. Thx. One more thing, new characters has default town-id 1 even when character samples has 2. Where can i change the town_id. I was trying to find it but no luck.
'character_towns' => array(1),
Encryption you can change in config.lua. But if you're using TFS 1.0+ then you can't change it, cause by default this TFS uses sha1 as encryption.It's possible to change encryption?
Fresh re-install with completely new database.
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ipv6' in 'field list'' in C:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php:101 Stack trace: #0 C:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php(101): PDO->query('INSERT INTO `my...') #1 C:\xampp\htdocs\system\libs\pot\OTS_Account.php(915): OTS_Base_DB->query('INSERT INTO `my...') #2 C:\xampp\htdocs\install\steps\finish.php(107): OTS_Account->logAction('Account created...') #3 C:\xampp\htdocs\install\index.php(40): require('C:\\xampp\\htdocs...') #4 {main} thrown in C:\xampp\htdocs\system\libs\pot\OTS_Base_DB.php on line 101
ALTER TABLE `myaac_account_actions` ADD `ipv6` BINARY(16) NOT NULL DEFAULT 0;
Fresh re-install. I'm guessing this is because of my database?
On houses page
Notice: Undefined index: guild in C:\xampp\htdocs\system\pages\houses.php on line 72
On characters page
Notice: Undefined index: in C:\xampp\htdocs\system\pages\characters.php on line 265
Notice: Undefined index: town_id in C:\xampp\htdocs\system\pages\characters.php on line 265
On characters page
Doesn't show signature at all? Shouldn't this be configured already after install?