• Operating System: Ubuntu 16.04
• MyAAC Version: 0.7.10
• PHP Version: 7.0
• Server name and version (for example: TFS 0.3): OTHire 1.0

Description:

https://github.com/slawkens/myaac/blob/master/system/templates/downloads.html.twig
The links are no longer functional.

Steps To Reproduce:

Go into download area from any template.

Solution

Use download URLs from:
https://drive.google.com/drive/folders/0B2-sMQkWYzhGSFhGVlY2WGk5czQ

Also, since there is no longer an officially supported IP Changer, and the most functional from back in the era I am using (7.4-7.72) was Asprate's IP Changer (which to be honest;), the solution could be teaching OT makers how to edit hex addresses depending on the generic Cipsoft client and upload this somewhere so that it could be downloaded by the users, which could in turn be linked in this module. Alternatively, an APP could be written to do the hex edits automatically, which if my memory doesn't deceive me, used to exist back in the day.

e.g.: http://tornadia.hopto.org/?downloads

The website have a problem to load a few contents with spaces.

1 - Edit a character with a space between names;
2 - Edit guilds a space between names.

Result:

Not Found
The requested URL /account/character/comment/Player%20Test was not found on this server.

login.php not working
i get this error
[Network error - Connection::parseHeader] Invalid Client Login

Error while fetching version info from http://my-aac.org. Site might be offline.

When deleting the character he informs that the deletion was made, the site still continues to point out that the character was not deleted, but in game, it is no longer there, but in the database it is still registered, in the deleting game, but in the bank and site is still active, I do not understand, I restarted everything to see if I had to update or something of the genre, but still the same thing

I just extracted the files, put it on my webserver, opened install and it just keeps getting stuck on: Your database is MySQL. Importing schema now...

Any way how to fix this?

Polls duplicate answers

• Operating System: windows 10
• MyAAC Version: 0.8
• PHP Version: 7.0
• Server name and version (for example: TFS 0.3): nto vendetta TFS 0.4 narutibia

Description:

Previous versions of myaac were not having this problem that I remember, what could it be? it is generating salt and my config.lua is configured not to generate, i use rev trunk 3884, work but i receive error "temple is wrong" etc...
but with my distro i receive invalid password, what could it be?

Gesior forum posts/threads (records) should be kept when migrating to MyAAC.

Currently, the forum posts are not kept, cause MyAAC uses a new table - myaac_forum, and Gesior uses an old table - z_forum.

Most preferably, MyAAC should use the old z_forum table name, as it was originally created for Gesior, and it wasn't changed a lot, just small adjustments were made to the table.

The changes should be made in some new branch, in the beginning - to not break combability with the old installations.

I have a problem in installing this in linux ubuntu 16.04
Gives me the an 500 error i searched the error con mi log and found this.
Table 'global.myaac_visitors' doesn't exist in...

Here is the full error
[Thu Jun 29 19:18:44.632098 2017] [:error] [pid 23937] [client 179.151.249.141:39580] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'global.myaac_visitors' doesn't exist in /var/www/html/system/libs/pot/OTS_Base_DB.php:101\nStack trace:\n#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(101): PDO->query('DELETE FROM my...')\n#1 /var/www/html/system/libs/visitors.php(75): OTS_Base_DB->query('DELETE FROM my...')\n#2 /var/www/html/system/libs/visitors.php(33): Visitors->cleanVisitors()\n#3 /var/www/html/index.php(90): Visitors->__construct(10)\n#4 {main}\n thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 101

i cant firnd any webservice for client 11
where the login.php

Error in forum:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'myaac_forum.post_html' in 'field list'' in /var/www/html/system/libs/pot/OTS_Base_DB.php:101 Stack trace: #0 /var/www/html/system/libs/pot/OTS_Base_DB.php(101): PDO->query('SELECT `players...') #1 /var/www/html/system/pages/forum/show_thread.php(32): OTS_Base_DB->query('SELECT `players...') #2 /var/www/html/system/pages/forum.php(178): require('/var/www/html/s...') #3 /var/www/html/index.php(390): require('/var/www/html/s...') #4 {main} thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 101

Forget it, my mistake.

I am having difficulty implementing the vocation acquisition by the site, my server is from NTO, instead of using item that the person receives the vocation, or NPC that sells the vocation , I'm trying to do the site, so I'm having problems, in the 1st step is to do this addition of vocations manually using the adminsitrador panel, the 2nd is when I click on buy vocation he create another character with the vocation chosen, 2nd stage more I believe that the 1st depends on the 2nd step, thanks again for the help!
follows the image of the first difficulty I'm having and the code that I believe is right
https://imgur.com/a/8Gn45P2

In the file "admin-add.html.twig" I added the following code:

else if(value == 'vocation') { $('#extra').append('<input type="number" name="vocation" style="width: 120px;" min="1" placeholder="Vocation" required/>'); $('#extra').append('<br/><input type="number" name="looktype" style="width: 120px;" min="1" placeholder="LookType" required/>'); }

Gifts.php
inside the "getOfferArray" function, within the "while" i insert:
$offer_array['vocation'][$i_vocation]['id'] = $data['id']; $offer_array['vocation'][$i_vocation]['points'] = $data['points']; $offer_array['vocation'][$i_vocation]['description'] = $data['offer_description']; $offer_array['vocation'][$i_vocation]['name'] = $data['offer_name']; $offer_array['vocation'][$i_vocation]['vocation'] = $data['vocation']; $offer_array['vocation'][$i_vocation]['looktype'] = $data['looktype']; $i_vocation++;

inside in "if ($ action == 'admin_add') {", i insert:

`case 'vocation':
$vocation = isset($_REQUEST['vocation']) ? $_REQUEST['vocation'] : null;
$looktype = isset($_REQUEST['looktype']) ? $_REQUEST['looktype'] : null;
if(!$vocation || !is_numeric($vocation)) {
$error = 'Please fill all fields. Vocation is empty or its not a number.';
}
else if(!$looktype || !is_numeric($looktype)) {
$error = 'Please fill all fields. LookType is empty or its not a number.';
}

                    break;`

And in "offer_list" i insert:

`else if($get_offerType == 'vocation' && isset($offer_list['vocation']) && count($offer_list['vocation']) > 0)
{
foreach($offer_list['vocation'] as $vocation)
{
echo '
'.getItemImage($vocation['vocation']).''.$vocation['looktype'].'
'.''.$vocation['name'].'
'.$vocation['description'].''.$vocation['points'].'';

            if(!$logged)
            {
                echo '<b>Login to buy</b>';
            }
            else
            {
                echo '<form action="?subtopic=gifts&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$vocation['vocation'].'"><input type="submit" value="Buy"><br><b>for '.$vocation['points'].' points</b></form>';
            }
            echo '</td></tr>';
        }

`

And to finish, in "confirm_transaction", i insert:

elseif($buy_offer['type'] == 'vocation') { $query = 'INSERT INTO '.$db->tableName('z_ots_comunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, delete_it) VALUES (NULL, '.$db->quote($buy_player->getName()).', \'login\', \'give_item\', '.$db->quote($buy_offer['vocation']).', '.$db->quote($buy_offer['item_count']).', 0, 0, \'item\', '.$db->quote($buy_offer['name']).', \'\', \'1\');'; $db->query($query); $save_transaction = 'INSERT INTO '.$db->tableName('z_shop_history').' (id, comunication_id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES (NULL, '.$db->lastInsertId().', '.$db->quote($buy_player->getName()).', '.$db->quote($buy_player_account->getId()).', '.$db->quote($buy_from).', '.$db->quote($account_logged->getId()).', '.$db->quote($buy_offer['points']).', '.$db->quote($buy_offer['id']).', \'wait\', '.$db->quote(time()).', \'0\');'; $db->query($save_transaction); $user_premium_points -= $buy_offer['points']; add_points($account_logged, -$buy_offer['points']); echo '<h2>You have bought this item!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' premium points</b> from your account.<br/>Now patiently wait in game MAX 3 minutes to receive this item!<br />Now you have <b>'.$user_premium_points.' premium points</b>.<br /><a href="?subtopic=gifts">GO TO MAIN SHOP SITE</a>'; }
Well, I apologize for anything, I'm still learning and I do not know if I'm going right, can give me a light, I thank you again

I've tried to adapt Gesior's script but could not make it work.

Quotes on big messages doesnt works or idk, i paste you the link to an example:
http://eurotibia.com/?forum/thread/63/0

The file you are trying to upload is not a .zip file. Please try again.

permissions applied and extensions loaded, linux debian 7.

• PDO PHP Extension
• XML PHP Extension
• ZIP PHP Extension
  chown -R www-data.www-data /var/www/*
  chmod 660 config.local.php
  chmod 660 images/guilds
  chmod 660 images/houses
  chmod 660 images/screenshots

tibiacom 100%

hi, I would like to know if MyAAC without its own system of "gifts" or shop?

It's possible to insert special characters in Guild Name && Guild Rank && Guild Nick. Some of those character can crash your server if you look at a player.

Even if you have the latest version of TFS, with fix for the OnLookAt crash, your server can crash. It happens because the line below (player.cpp) can get the "s" value is getting an "" when looking at a player with special character on this rank / guild.

s << guildRank->name << " of the " << guild->getName()

guilds are not compatible with othire, change rank id, and guildnick in players.

Hello,
I've spoted an issue that for some monsters in page "creatures.php" you can not see loot. This is due to column loot lenght. Some of the loot is cut in the middle, then $loot variable is not correct - in example try Demon or Dragon.
If you extend loot column everything works fine.

Try use ALTER TABLE myaac_monsters MODIFY loot VARCHAR(65353);

Path to your TFS main directory shows as not found no matter what I do.

Security issues aside (mockup server) - the path is in the root directory at '/root/forgottenserver/'. Am I perhaps formatting this incorrectly?

Server configuration

• Operating System: Ubuntu 16.04
• Web Server (+ version): nginx
• PHP Version: 7.0
• Server name and version (for example: TFS 0.3): otxserver 3 (base tfs 1.3)
• MyAAC Version: 0.7.1.0

I have a problem. When I try to install in step no. 6, this error pops up for me:

The config file can not be found. Is your path to the correct server directory? Return and check again.
Notice: Undefined index: var_server_path in /home/otsmanager/www/public_html/install/includes/config.php on line 9

The server path is good and I have no idea how to fix it.

You added an extra ' in tr bgcolor =
I fixed for you

<!-- FRAGS --> <br/> <table border="0" cellspacing="1" cellpadding="4" width="100%"> <tr bgcolor="{{ config.vdarkborder }}"> <td colspan="2" class="white"><b>Victims</b></td> </tr> {% set i = 0 %} {% for frag in frags %} <tr bgcolor="{{ getStyle(i) }}"> <td width="20%" align="center">{{ frag.time|date("j M Y, H:i") }}</td> <td>{{ frag.description|raw }}({% if frag.unjustified %}<font size="1" color="red">Unjustified</font>{% else %}<font size="1" color="green">Justified</font>{% endif %})</td> </tr> {% endfor %} </table> <!-- FRAGS_END -->

Hello, I cant install MyAAC in my VPS. the installation steps says that i must add my IP to the file ip.txt and shows an IP wich is not really my VPS's IP.

How should i bypass this?

after i install the shop and i try to pay throw paypal iget this !

Not Found
The requested URL /?subtopic=paypal was not found on this server.

Error

I have a problem when setting up a new account.
The white page with error 500 is displayed

Change in line 806 if($rank_of_player->isLoaded()) { to if($rank_of_player->isLoaded()) {

I've noticed there's a players editor at the admin panel, but nothing to edit a specific account from player (edit their password, email, recovery key, type, etc)

Is this planed?

debian 7, othire

empera.online não consegue atender a esta solicitação no momento.
HTTP ERROR 500

Hello, can you write a plugin which I can see whole logs of premium points for each players? Monthly earnings from all transaction websites(paypal etc.). Something through which I will be able to view everything that what happens with premium points.

Buy Points, Shop Offer, and Shop History do not work.

it says the page does not exist, in the admin panel it does though?

https://www.evolvecraft.com/tibia/

Emma layout plizzz

help

When you generate a new password by email, your new password don't work. I think it's probably caused by the encryptation type.

Result:

You can't login. Wrong password.

Can someone help me every time i try to verify mail i get a error :S

[createaccount.php] An error occorred while sending email: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting. Error:
what do i need to do to fix this ?

here is me PHP :

    // mail
'mail_enabled' => true, // is aac maker configured to send e-mails?
'mail_address' => '[email protected]	', // server e-mail address (from:)
'mail_admin' => '[email protected]', // admin email address, where mails from contact form will be sent
'mail_signature' => array( // signature that will be included at the end of every message sent using _mail function
	'plain' => ''/*'--\nMy Server,\nhttp://www.myserver.com'*/,
	'html' => ''/*'<br/>My Server,\n<a href="http://www.myserver.com">myserver.com</a>'*/
),
'smtp_enabled' => true, // send by smtp or mail function (set false if use mail function)
'smtp_host' => 'smtp.gmail.com', // mail host
'smtp_port' => 587, // 25 (default) / 465 (ssl, e.g. gmail)
'smtp_auth' => true, // need authorization?
'smtp_user' => '[email protected]',
'smtp_pass' => 'test',

when i try to create the guild the aac throw me and error 500 after i checked the error log of my webserver i found this
[Wed Oct 31 19:50:55.507999 2018] [core:error] [pid 41411] (13)Permission denied: [client 186.6.190.230:60177] AH00035: access to /images/guilds/default.gif denied (filesystem path '/var/www/html/images/guilds/default.gif') because search permissions are missing on a component of the path, referer: http://tibianas.com/?guilds

[Wed Oct 31 19:51:03.108948 2018] [php7:error] [pid 41430] [client 186.6.190.230:60181] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1364 Field 'motd' doesn't have a default value in /var/www/html/system/libs/pot/OTS_Base_DB.php:101\nStack trace:\n#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(101): PDO->query('INSERT INTO gu...')\n#1 /var/www/html/system/libs/pot/OTS_Guild.php(199): OTS_Base_DB->query('INSERT INTO gu...')\n#2 /var/www/html/system/pages/guilds/create.php(108): OTS_Guild->save()\n#3 /var/www/html/system/pages/guilds.php(30): require('/var/www/html/s...')\n#4 /var/www/html/index.php(386): require('/var/www/html/s...')\n#5 {main}\n thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 101, referer: http://tibianas.com/?subtopic=guilds&action=create

Error while fetching version info from http://my-aac.org. Site might be offline.

Idk if this is bug but when im not loged in web and i try to a post in forum the message "You are not logged in. Log in to post on the forum." appears in a blank page.
I have my Aac in last rev including your last commit about forums.
Example: http://eurotibia.com/?forum/thread/63

Account premmy status dead again

Based on this otland post myaac does not have house auction system.

i get wrong account status while its premmy i get it as a free acc
Account Status: | Free Account

Hello! In my player i have custom vocations and when for example someone leaves a guild or be named guild leader its vocation change to 0, also in admin when i want to save a change in a player i cant set custom vocation, it says that Vocation id cannot be longer than 1 digits.

Hello, I wanted to thank you for the project you have, it's great, I would ask you to help me, the site is conflicting with my Tibia, it is getting spells from the site, not server spells (spells.xml), I removed the spells table, and the spells.php, because it was entering spells that had nothing to do with the vocations, but even so he is taking other spells that are not yet true, can you help me solve this?

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1364 Field 'rank_id' doesn't have a default value' in /opt/lampp/htdocs/tibia/system/libs/pot/OTS_Base_DB.php:101 Stack trace: #0 /opt/lampp/htdocs/tibia/system/libs/pot/OTS_Base_DB.php(101): PDO->query('INSERT INTO pl...') #1 /opt/lampp/htdocs/tibia/system/libs/pot/OTS_Player.php(450): OTS_Base_DB->query('INSERT INTO pl...') #2 /opt/lampp/htdocs/tibia/system/pages/account/create_character.php(155): OTS_Player->save() #3 /opt/lampp/htdocs/tibia/system/pages/accountmanagement.php(128): require('/opt/lampp/htdo...') #4 /opt/lampp/htdocs/tibia/index.php(340): require('/opt/lampp/htdo...') #5 {main} thrown in /opt/lampp/htdocs/tibia/system/libs/pot/OTS_Base_DB.php on line 101

When you go to Admin Panel - Logs, and your server doesn't include logs/ directory, then logs from MyAAC won't be shown too.

It should show MyAAC logs always - no matter if server logs exist or not.