slawkens / myaac Goto Github PK
View Code? Open in Web Editor NEWA free and open-source Automatic Account Creator (AAC) written in PHP
Home Page: https://my-aac.org
License: GNU General Public License v3.0
A free and open-source Automatic Account Creator (AAC) written in PHP
Home Page: https://my-aac.org
License: GNU General Public License v3.0
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
Change in line 806 if($rank_of_player->isLoaded()) { to if($rank_of_player->isLoaded()) {
login.php not working
i get this error
[Network error - Connection::parseHeader] Invalid Client Login
Buy Points, Shop Offer, and Shop History do not work.
it says the page does not exist, in the admin panel it does though?
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);
Error while fetching version info from http://my-aac.org. Site might be offline.
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.
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
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()
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
Emma layout plizzz
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.
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
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?
Quotes on big messages doesnt works or idk, i paste you the link to an example:
http://eurotibia.com/?forum/thread/63/0
help
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',
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.
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.
The file you are trying to upload is not a .zip file. Please try again.
permissions applied and extensions loaded, linux debian 7.
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
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
hi, I would like to know if MyAAC without its own system of "gifts" or shop?
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?
debian 7, othire
empera.online não consegue atender a esta solicitação no momento.
HTTP ERROR 500
I have a problem when setting up a new account.
The white page with error 500 is displayed
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?
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?
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 -->
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.
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.
Forget it, my mistake.
i cant firnd any webservice for client 11
where the login.php
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?
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?
Error while fetching version info from http://my-aac.org. Site might be offline.
i get wrong account status while its premmy i get it as a free acc
Account Status: | Free Account
Based on this otland post myaac does not have house auction system.
https://github.com/slawkens/myaac/blob/master/system/templates/downloads.html.twig
The links are no longer functional.
Go into download area from any template.
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.
I've tried to adapt Gesior's script but could not make it work.
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.
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.
guilds are not compatible with othire, change rank id, and guildnick in players.
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
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.