MyAAC v0.7.12

kaszanalubizryc · Jan 5, 2018

slawkens said:
Can you post your giant spider.xml monster file? And also elaborate more what is wrong, cause I didn't understand you fully. What's exactly wrong with the loot?

i fixed it with change varchar(500) to (5000)
there is on homepay.pl problems in scirpts
Class 'Account' not found in C:\xampp\htdocs\xxxx\system\pages\points.php on line 320

Fix change
[

PHP:

new Account();

to

PHP:

new OTS_Account();

and change set

PHP:

        $account->set('premium_points', ($account->getCustomField('premium_points')+$number_of_points));

to

PHP:

        $account->setCustomField('premium_points', ($account->getCustomField('premium_points')+$number_of_points));

MxSoft · Jan 11, 2018

Is there a way to create only admin visible menus in template?

slaw · Jan 11, 2018

MxSoft said:
Is there a way to create only admin visible menus in template?

Currently not, but I plan such a feature into 0.8 release.

Seksy · Jan 13, 2018

Ok perhaps something went wonky during an update but switched to latest version and it wont pull up house list. Anyone else with this issue?

kret · Jan 13, 2018

Which mysql.schema installer of this website support?
Im using old otserv 0.6.3 based on 8.52 probably with schema_info 19 and at step 7 have errors

Code:

[Sat Jan 13 16:58:47.031507 2018] [:error] [pid 31698] [client 178.217.142.85:58800] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ots`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)) in /var/www/html/system/libs/pot/OTS_Base_DB.php:108\nStack trace:\n#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(108): PDO->query('INSERT INTO `pl...')\n#1 /var/www/html/system/libs/pot/OTS_Player.php(469): OTS_Base_DB->query('INSERT INTO `pl...')\n#2 /var/www/html/install/steps/7-finish.php(100): OTS_Player->save()\n#3 /var/www/html/install/index.php(182): require('/var/www/html/i...')\n#4 {main}\n  thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 108, referer: http://127.0.0.1/install/
[Sat Jan 13 16:59:43.642250 2018] [:error] [pid 31756] [client 178.217.142.85:58829] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ots`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)) in /var/www/html/system/libs/pot/OTS_Base_DB.php:108\nStack trace:\n#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(108): PDO->query('INSERT INTO `pl...')\n#1 /var/www/html/system/libs/pot/OTS_Player.php(469): OTS_Base_DB->query('INSERT INTO `pl...')\n#2 /var/www/html/install/steps/7-finish.php(100): OTS_Player->save()\n#3 /var/www/html/install/index.php(182): require('/var/www/html/i...')\n#4 {main}\n  thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 108, referer: http://127.0.0.1/install/
[Sat Jan 13 17:00:37.396087 2018] [:error] [pid 31699] [client 178.217.142.85:58915] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ots`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)) in /var/www/html/system/libs/pot/OTS_Base_DB.php:108\nStack trace:\n#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(108): PDO->query('INSERT INTO `pl...')\n#1 /var/www/html/system/libs/pot/OTS_Player.php(469): OTS_Base_DB->query('INSERT INTO `pl...')\n#2 /var/www/html/install/steps/7-finish.php(100): OTS_Player->save()\n#3 /var/www/html/install/index.php(182): require('/var/www/html/i...')\n#4 {main}\n  thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 108, referer: http://127.0.0.1/install/
[Sat Jan 13 17:00:38.177533 2018] [:error] [pid 31698] [client 178.217.142.85:58918] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ots`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)) in /var/www/html/system/libs/pot/OTS_Base_DB.php:108\nStack trace:\n#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(108): PDO->query('INSERT INTO `pl...')\n#1 /var/www/html/system/libs/pot/OTS_Player.php(469): OTS_Base_DB->query('INSERT INTO `pl...')\n#2 /var/www/html/install/steps/7-finish.php(100): OTS_Player->save()\n#3 /var/www/html/install/index.php(182): require('/var/www/html/i...')\n#4 {main}\n  thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 108, referer: http://127.0.0.1/install/

No groups, no character samples.

slaw · Jan 13, 2018

kret said:

Which mysql.schema installer of this website support?
Im using old otserv 0.6.3 based on 8.52 probably with schema_info 19 and at step 7 have errors

Code:

[Sat Jan 13 16:58:47.031507 2018] [:error] [pid 31698] [client 178.217.142.85:58800] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ots`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)) in /var/www/html/system/libs/pot/OTS_Base_DB.php:108\nStack trace:\n#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(108): PDO->query('INSERT INTO `pl...')\n#1 /var/www/html/system/libs/pot/OTS_Player.php(469): OTS_Base_DB->query('INSERT INTO `pl...')\n#2 /var/www/html/install/steps/7-finish.php(100): OTS_Player->save()\n#3 /var/www/html/install/index.php(182): require('/var/www/html/i...')\n#4 {main}\n  thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 108, referer: http://127.0.0.1/install/
[Sat Jan 13 16:59:43.642250 2018] [:error] [pid 31756] [client 178.217.142.85:58829] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ots`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)) in /var/www/html/system/libs/pot/OTS_Base_DB.php:108\nStack trace:\n#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(108): PDO->query('INSERT INTO `pl...')\n#1 /var/www/html/system/libs/pot/OTS_Player.php(469): OTS_Base_DB->query('INSERT INTO `pl...')\n#2 /var/www/html/install/steps/7-finish.php(100): OTS_Player->save()\n#3 /var/www/html/install/index.php(182): require('/var/www/html/i...')\n#4 {main}\n  thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 108, referer: http://127.0.0.1/install/
[Sat Jan 13 17:00:37.396087 2018] [:error] [pid 31699] [client 178.217.142.85:58915] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ots`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)) in /var/www/html/system/libs/pot/OTS_Base_DB.php:108\nStack trace:\n#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(108): PDO->query('INSERT INTO `pl...')\n#1 /var/www/html/system/libs/pot/OTS_Player.php(469): OTS_Base_DB->query('INSERT INTO `pl...')\n#2 /var/www/html/install/steps/7-finish.php(100): OTS_Player->save()\n#3 /var/www/html/install/index.php(182): require('/var/www/html/i...')\n#4 {main}\n  thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 108, referer: http://127.0.0.1/install/
[Sat Jan 13 17:00:38.177533 2018] [:error] [pid 31698] [client 178.217.142.85:58918] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ots`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)) in /var/www/html/system/libs/pot/OTS_Base_DB.php:108\nStack trace:\n#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(108): PDO->query('INSERT INTO `pl...')\n#1 /var/www/html/system/libs/pot/OTS_Player.php(469): OTS_Base_DB->query('INSERT INTO `pl...')\n#2 /var/www/html/install/steps/7-finish.php(100): OTS_Player->save()\n#3 /var/www/html/install/index.php(182): require('/var/www/html/i...')\n#4 {main}\n  thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 108, referer: http://127.0.0.1/install/

No groups, no character samples.

Weird, I tried OTServ 0.6.4 schema from here: Releases · opentibia/server · GitHub

And it worked fine.

Seems there are no any groups in your groups table. But they should be there by default.

Can you send me link to that distro?

kret said:

Which mysql.schema installer of this website support?
Im using old otserv 0.6.3 based on 8.52 probably with schema_info 19 and at step 7 have errors

Code:

[Sat Jan 13 16:58:47.031507 2018] [:error] [pid 31698] [client 178.217.142.85:58800] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ots`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)) in /var/www/html/system/libs/pot/OTS_Base_DB.php:108\nStack trace:\n#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(108): PDO->query('INSERT INTO `pl...')\n#1 /var/www/html/system/libs/pot/OTS_Player.php(469): OTS_Base_DB->query('INSERT INTO `pl...')\n#2 /var/www/html/install/steps/7-finish.php(100): OTS_Player->save()\n#3 /var/www/html/install/index.php(182): require('/var/www/html/i...')\n#4 {main}\n  thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 108, referer: http://127.0.0.1/install/
[Sat Jan 13 16:59:43.642250 2018] [:error] [pid 31756] [client 178.217.142.85:58829] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ots`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)) in /var/www/html/system/libs/pot/OTS_Base_DB.php:108\nStack trace:\n#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(108): PDO->query('INSERT INTO `pl...')\n#1 /var/www/html/system/libs/pot/OTS_Player.php(469): OTS_Base_DB->query('INSERT INTO `pl...')\n#2 /var/www/html/install/steps/7-finish.php(100): OTS_Player->save()\n#3 /var/www/html/install/index.php(182): require('/var/www/html/i...')\n#4 {main}\n  thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 108, referer: http://127.0.0.1/install/
[Sat Jan 13 17:00:37.396087 2018] [:error] [pid 31699] [client 178.217.142.85:58915] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ots`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)) in /var/www/html/system/libs/pot/OTS_Base_DB.php:108\nStack trace:\n#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(108): PDO->query('INSERT INTO `pl...')\n#1 /var/www/html/system/libs/pot/OTS_Player.php(469): OTS_Base_DB->query('INSERT INTO `pl...')\n#2 /var/www/html/install/steps/7-finish.php(100): OTS_Player->save()\n#3 /var/www/html/install/index.php(182): require('/var/www/html/i...')\n#4 {main}\n  thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 108, referer: http://127.0.0.1/install/
[Sat Jan 13 17:00:38.177533 2018] [:error] [pid 31698] [client 178.217.142.85:58918] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ots`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)) in /var/www/html/system/libs/pot/OTS_Base_DB.php:108\nStack trace:\n#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(108): PDO->query('INSERT INTO `pl...')\n#1 /var/www/html/system/libs/pot/OTS_Player.php(469): OTS_Base_DB->query('INSERT INTO `pl...')\n#2 /var/www/html/install/steps/7-finish.php(100): OTS_Player->save()\n#3 /var/www/html/install/index.php(182): require('/var/www/html/i...')\n#4 {main}\n  thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 108, referer: http://127.0.0.1/install/

No groups, no character samples.

You can execute this query on your database:

Code:

INSERT INTO `groups` VALUES (1, 'Player', 0, 0, 0, 2000, 100),(2, 'Tutor', 16777216, 0, 0, 2000, 100),(3, 'Sennior Tutor', 274894684160, 0, 0, 2000, 100),(4, 'Community Manager', 69681547968463, 2, 0, 1000, 100),(5, 'Game Master', 69681547968463, 2, 0, 1000, 100),(6, 'GOD/OWNER', 57171953819640, 3, 0, 2000, 100);

Then delete/clear config.local.php, and follow installation again.

kret · Jan 13, 2018

Ye, my friend dont have any groups in database, i add manually and now working, thanks

Kaspersky Internet Security

avpui_2018-01-13_18-57-35-eeaaf8b9-81f4-4ece-ab85-45c7e898100b.png

Why can't edit posts?
I don't know why script detect engine as TFS_03? because in stamina for new character gives 2520 instead of default 151200000

slaw · Jan 13, 2018

kret said:
Why can't edit posts?
I don't know why script detect engine as TFS_03? because in stamina for new character gives 2520 instead of default 151200000

It detects as OTSERV_06, its right. But the problem is, i didn't take this distro into consideration at the beginning.

Anyway, I've fixed it. And now it uses default stamina from your samples characters.

Fixed version:
* when you use 0.7.x series: https://github.com/slawkens/myaac/archive/0.7.zip
* when you use 0.8.0-dev: https://github.com/slawkens/myaac/archive/master.zip

Its enough when you update system/pages/account/create_character.php

kret · Jan 16, 2018

What about these strange alerts from kaspersky when visiting website?

Kaspersky Internet Security

slaw · Jan 16, 2018

kret said:
What about these strange alerts from kaspersky when visiting website?

Its strange, that's right. I specially downloaded Kaspersky Internet Security to test it. But on all my 3 sites using MyAAC this alert is not shown. Maybe I need to restart my computer before using it? I don't know.

Does this alert appear on all sites from MyAAC? Or only on create account or login?

LeOnArd0 · Jan 25, 2018

Hi @slawkens i have a problem. I installed the site, all right, but the Knight Sample is visible without highscore. The other characters are normal, can you help me?

slaw · Jan 25, 2018

LeOnArd0 said:
Hi @slawkens i have a problem. I installed the site, all right, but the Knight Sample is visible without highscore. The other characters are normal, can you help me?

Which version you installed? 0.7 or 0.8?

Also, you need to check in database table players what id got that Sample and then paste it into config.local.php into this array:

Code:

$config['highscores_ids_hidden'] = array(2, 3, 4, 5, 6);

Where 2, 3, 4 ,5 ,6 are ids of your Sample characters that you want to hide.

karudotpl · Jan 26, 2018

i cant install..
after make chown -R www-data.www-data /var/www/*
and reload site i see only: File not found.

no idea how to fix this..

slaw · Jan 26, 2018

karudotpl said:
i cant install..
after make chown -R www-data.www-data /var/www/*
and reload site i see only: File not found.

no idea how to fix this..

This error does not come from MyAAC. Most likely your web server cannot load the index.php file.

What OS (Operating System) are you running? What is your web server (Apache, Nginx, Lighttpd)?

Is index.php located in your directory like this: /var/www/index.php?

karudotpl · Jan 26, 2018

I use Debian 8, Web server apache, I got var /www/sitename/ Index. PHP but even if i write the whole address in command is the same error, if I change www-data to root or my admin user I have error 403.. Can't reach my site anymore even if I delete myaac from server.. Weird.. U used Note before with no problems...

MxSoft · Jan 27, 2018

Dont u have a html folder?

karudotpl · Jan 27, 2018

is this really matter? its just a path to file.. i dont know how to restore this command to default one to try again..

slaw · Jan 27, 2018

karudotpl said:
is this really matter? its just a path to file.. i dont know how to restore this command to default one to try again..

What do you have in your /etc/apache2/sites-enabled/000-default.conf under DocumentRoot?

karudotpl · Jan 27, 2018

ServerAdmin webmaster@localhost
DocumentRoot /var/www/html

its wierd cause plesk create directory for site in: /var/www/vhosts/briall.pl/httpdocs/

Lyky · Feb 2, 2018

@slawkens
I was wondering if you could make a standard option to turn on custom client on ?downloads page rather than forcing to edit the php by user. (Edit option like we have on latest news etc; would be great addition)

MyAAC v0.7.12

New Member

Leave Tibia, Live Life.

Software Developer

Member

K R E T O W N A G E

Software Developer

K R E T O W N A G E

Software Developer

K R E T O W N A G E

Software Developer

Member

Software Developer

briall.pl

Software Developer

briall.pl

Leave Tibia, Live Life.

briall.pl

Software Developer

briall.pl

Well-Known Member

Similar threads