• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

MyAAC v0.7.12

Status
Not open for further replies.
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.
 
WWp3h4s.png

How can i add samples to my DB?
 
It should be done when you install AAC automatically.

If not, you can execute those queries on db:
Code:
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, '');
 
Sry can't edit.

Use this one:
Code:
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
@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

By old and deprecated versions of TFS you mean 0.2 series? Cause 0.3 is still widely used on otservlist.org. Yeah thats just few lines of code to support it, so i don't see anything wrong here.

And yeah, some help with plugins would be appreciated! :)
 
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.
 
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
 
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

Temporary you can put this into your config.local.php:
Code:
    $config['online_outfit'] = false;
    $config['highscores_outfit'] = false;
    $config['characters']['outfit'] = false;
Cause its caused by outfit shower I've added recently.

Anyway, I'm gonna fix it.
 
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
Ok, this has been fixed.

You can download latest version here: https://github.com/slawkens/myaac/archive/master.zip
 
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.
 
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.

You can edit it in config.php:
Code:
'character_towns' => array(1),
Change 1 to 2.

It's possible to change encryption?
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.
 
Seven days without activity, now comes a bigger update!!

Version 0.2.0 has arrived!

Changes from previous version:
  • added option to change character sex for premium points
  • moved site_closed to database, now you can close your site through admin panel
  • added option to admin panel: clear cache
  • added experiencetable_rows configurable
  • optimized OTS_Account->getGroupId(), now its using like 20 queries less
  • optimized OTS_Player->load($id) function, should be much faster now
  • fixed displaying on highscores special outfits
  • fixed skull images displaying
  • fixed displaying unlimited premium account
  • fixed bug where players.lookaddons doesn't exist (OTHire etc.) ([MyAAC] v0.0.1)
  • fixed signature tibian for OTHire and other servers that doesnt use accounts.premdays field
  • fixed when player name in signature containst space
  • don't show "Create forum thread" when editing news
  • fixed red color table after create account
  • updated download links, as clients.************ isn't working anymore
  • fixed some bugs while installing when field `email_next` or `hidden` already exist
  • fixed movies unexpected comment
  • added template_place_holder('center_top') to kathrine template
Download as always: Releases · slawkens/myaac · GitHub

Also I'm looking for people willing to translate the project to other languages.
The only thing you need to do is copy content of system/locale/en dir to your dir, for example system/locale/es for spanish. And then translate the files inside. And then send me a copy of it with your email that will be included in translators list!!
 
Swedish I double checked it but I didn't triple check it. Enjoy :)

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
TFlA5Ij.png

Doesn't show signature at all? Shouldn't this be configured already after install?

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
 
Last edited by a moderator:
After last step and clicking switch to admin panel

[admERROR: Cannot connect to MySQL database.
Possible reasons:
  • MySQL is not configured propertly in config.lua.
  • MySQL server is not running.
exception 'PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user 'dzoqa'@'localhost' (using password: YES)' in D:\UniServer\UniServerZ\www\system\libs\pot\OTS_DB_MySQL.php:95 Stack trace: #0 D:\UniServer\UniServerZ\www\system\libs\pot\OTS_DB_MySQL.php(95): PDO->__construct('mysql:host=127....', 'dzoqa', 'testxyz') #1 D:\UniServer\UniServerZ\www\system\libs\pot\OTS.php(448): OTS_DB_MySQL->__construct(Array) #2 D:\UniServer\UniServerZ\www\system\database.php(79): POT->connect(1, Array) #3 D:\UniServer\UniServerZ\www\system\init.php(116): require_once('D:\\UniServer\\Un...') #4 D:\UniServer\UniServerZ\www\admin\index.php(23): require('D:\\UniServer\\Un...') #5 {main}in panel]

@up
0cf1c7a4f9c744cc866eb950d48445b9.png
 
Last edited by a moderator:
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

Damn, I always forget something. Thanks for pointing this out!

I shouldn't have released this on Sunday morning, as I wasn't the whole day at home, haha.

Anyway, this has been fixed in latest commit, which you can find here:
https://github.com/slawkens/myaac/archive/master.zip

And if you want to use that existing database, just execute this in your pma:
Code:
ALTER TABLE `myaac_account_actions` ADD `ipv6` BINARY(16) NOT NULL DEFAULT 0;

And big thanks for your translation!


As this message says, you did something wrong. Does your OTS connect with that details?

#Edit

@Sizaro nope, it won't work, you need to do one more time reinstall.

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
TFlA5Ij.png

Doesn't show signature at all? Shouldn't this be configured already after install?

Can you try to open the link of signature? What does it say when you open it? Right click->Open in new window.

Both notices I've fixed in latest commit.
 
Last edited by a moderator:
Status
Not open for further replies.
Back
Top