MyAAC v0.7.12

[_M4G0_]

I almost got this.

You have changed this line:

        foreach ($config["gifts_system"] as $ServiceCategoryID => $data) {

can you show me original code?

oh sorry
updated

 

[Sizaro]

I found two bugs already, if you make a very long news post, the edit button stops working at the bottom.
If you make a long news ticker the structure of the site breaks and you cannot edit the ticker or remove it.

 

[slaw]

I found two bugs already, if you make a very long news post, the edit button stops working at the bottom.
If you make a long news ticker the structure of the site breaks and you cannot edit the ticker or remove it.

I don't know how long dd you tried, but it seems it have some other reason. Cause i've tried to post a very very long post (more than 1800 words) and it worked fine.

Can you dump me your phpmyadmin myaac_news table?

You need to go to your database, select myaac_news, then there's in right up corner "Export" option. Use that to export that table.

 

[Sizaro]

I don't know how long dd you tried, but it seems it have some other reason. Cause i've tried to post a very very long post (more than 1800 words) and it worked fine.

Can you dump me your phpmyadmin myaac_news table?

You need to go to your database, select myaac_news, then there's in right up corner "Export" option. Use that to export that table.

myaac_news.sql

It's just something random I copied to test the system out.

 

[slaw]

Ticket one has been fixed.

About second one, you exceeded the limit of news. In database there's field limit on body = 10000, your news had more, thats why it has been cut.

Anyway both has been fixed. I adjusted limit of news to 30000, and added a check so it verifies if you try to add longer query.

I will update repository soon.

 

[jakub742]

Hi. Im using myacc version 0.1.3 with OTHire 0.0.3. I have a problem when creating a new account.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ip' cannot be null' 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('INSERT INTO `my...') #1 D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Account.php(919): OTS_Base_DB->query('INSERT INTO `my...') #2 D:\Tibia Projekt\xampp\htdocs\system\pages\createaccount.php(151): OTS_Account->logAction('Account created...') #3 D:\Tibia Projekt\xampp\htdocs\index.php(223): require('D:\\Tibia Projek...') #4 {main} thrown in D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Base_DB.php on line 100

The account is successfully created in account table but there is no record in myaac_account_actions table. Idk why its problem with column ip because it has a default value of 0 so its should not be NULL right ?

Thx for answer

 

[Sizaro]

I set different sample IDS for my samples and I get this error;

    // new character config
    'character_samples' => array( // vocations, format: ID_of_vocation => 'Name of Character to copy'
        2 => 'Rogue Sample',
        3 => 'Sorcerer Sample',
        4 => 'Druid Sample',
        5 => 'Ranger Sample',
        6 => 'Knight Sample',
        7 => 'Paladin Sample'
    ),

 

[Sizaro]

I set the config to this;

    // new character config
    'character_samples' => array( // vocations, format: ID_of_vocation => 'Name of Character to copy'
        0 => 'Rogue Sample',
        1 => 'Sorcerer',
        2 => 'Druid Sample',
        3 => 'Ranger Sample',
        4 => 'Knight Sample',
        5 => 'Paladin Sample'
    ),

Now it shows up correctly on the character creation screen but in-game it uses a completely different sample that doesn't even exist in my database.

 

[jakub742]

You should have only 4 vocations right ? why is there a ranger sample ? Your vocation ids are different than a default ones cause you have one extra vocation. Maybe there's a problem

 

[Sizaro]

You should have only 4 vocations right ? why is there a ranger sample ? Your vocation ids are different than a default ones cause you have one extra vocation. Maybe there's a problem

Because my server has 6 vocations and not 4?

 

[slaw]

Hi. Im using myacc version 0.1.3 with OTHire 0.0.3. I have a problem when creating a new account.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ip' cannot be null' 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('INSERT INTO `my...') #1 D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Account.php(919): OTS_Base_DB->query('INSERT INTO `my...') #2 D:\Tibia Projekt\xampp\htdocs\system\pages\createaccount.php(151): OTS_Account->logAction('Account created...') #3 D:\Tibia Projekt\xampp\htdocs\index.php(223): require('D:\\Tibia Projek...') #4 {main} thrown in D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Base_DB.php on line 100

The account is successfully created in account table but there is no record in myaac_account_actions table. Idk why its problem with column ip because it has a default value of 0 so its should not be NULL right ?

Thx for answer

This has been in latest release. Yeah you are right it should not be NULL as the column has default value, i don't understand why it throws this error.

I set the config to this;

    // new character config
    'character_samples' => array( // vocations, format: ID_of_vocation => 'Name of Character to copy'
        0 => 'Rogue Sample',
        1 => 'Sorcerer',
        2 => 'Druid Sample',
        3 => 'Ranger Sample',
        4 => 'Knight Sample',
        5 => 'Paladin Sample'
    ),

Now it shows up correctly on the character creation screen but in-game it uses a completely different sample that doesn't even exist in my database.

Export your players table and post here.

Also show me your $config['vocations'] and $config['character_samples']

Version 0.1.4 has been released!
Changes:
* added outfit shower, in characters, online, and highscores
* updated database to version 2
* fixed item images (now using item-images.ots.me host by default)
* fixed news ticket and posting long newses
([MyAAC] v0.0.1)
* news body limit increased to 65535 (mysql text field)
* removed some unused code from my old server
* added spells & monsters to kathrine template

 

[slaw]

Hi. Im using myacc version 0.1.3 with OTHire 0.0.3. I have a problem when creating a new account.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ip' cannot be null' 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('INSERT INTO `my...') #1 D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Account.php(919): OTS_Base_DB->query('INSERT INTO `my...') #2 D:\Tibia Projekt\xampp\htdocs\system\pages\createaccount.php(151): OTS_Account->logAction('Account created...') #3 D:\Tibia Projekt\xampp\htdocs\index.php(223): require('D:\\Tibia Projek...') #4 {main} thrown in D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Base_DB.php on line 100

The account is successfully created in account table but there is no record in myaac_account_actions table. Idk why its problem with column ip because it has a default value of 0 so its should not be NULL right ?

Thx for answer

It has been fixed in latest release. Thanks for report.

 

[Sizaro]

Export your players table and post here.

Also show me your $config['vocations'] and $config['character_samples']

@my last post was a fail.

I don't know what you mean with $config['vocations'] I cannot find anything in my config file called vocations.

    // new character config
    'character_samples' => array( // vocations, format: ID_of_vocation => 'Name of Character to copy'
        0 => 'Rogue Sample',
        1 => 'Sorcerer Sample',
        2 => 'Druid Sample',
        3 => 'Ranger Sample',
        4 => 'Knight Sample',
        5 => 'Paladin Sample'
    ),

players.sql

 

[slaw]

Hi. Im using myacc version 0.1.3 with OTHire 0.0.3. I have a problem when creating a new account.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ip' cannot be null' 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('INSERT INTO `my...') #1 D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Account.php(919): OTS_Base_DB->query('INSERT INTO `my...') #2 D:\Tibia Projekt\xampp\htdocs\system\pages\createaccount.php(151): OTS_Account->logAction('Account created...') #3 D:\Tibia Projekt\xampp\htdocs\index.php(223): require('D:\\Tibia Projek...') #4 {main} thrown in D:\Tibia Projekt\xampp\htdocs\system\libs\pot\OTS_Base_DB.php on line 100

The account is successfully created in account table but there is no record in myaac_account_actions table. Idk why its problem with column ip because it has a default value of 0 so its should not be NULL right ?

Thx for answer

Finally I found a solution for this problem.. It was ipv6 that caused that problem. INET_ATON:1) is returning null, while INET6_ATON:1) is returning proper address. I fixed it in latest version on github.

You can download it as always here: Releases · slawkens/myaac · GitHub (Latest version 0.1.5)

 

[Sizaro]

The house page doesn't work?

 

[slaw]

The house page doesn't work?

Its working. Be sure that you /saved server at least once. Check if you got any records in houses table in phpmyadmin.

 

[Sizaro]

Yea got it working, thanks. I want to upgrade to 0.1.5, how do I do that? I don't wanna reinstall / reconfigure the entire AAC again because of 3 and a half files that you've changed, is there any way to patch only the files that you changed?

 

[slaw]

Look on latest commit on github and see what files i've changed. Anyway, you should always place your own config directives in config.local.php, so you can later easily upgrade aac.

If I would you, i would download the newest version, and just replace config.local.php with my own, if you didn't change anything except config.

 

[slaw]

You won't need to install again in that case, cause aac will update itself and upgrade database automatically.

 

[Sizaro]

And when does it do that? How do I force it to?