• 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] Character Creation

hellyea

hellyea

OT-Fan
Joined
Jan 26, 2009
Messages
92
Reaction score
6
Location
Germany
Hello guys,

i cannot create any Characters with a Vocation im using the MYAAC Website and when i create a new Character it let me pick wich Vocation but it does not work.. ( Hes using the Rook Sample ). Also it wont let me change the Towns even tho i edited the Config.php from myaac.

Update* I found out that in my Database there are the Samples for Knight etc.. but they are all level 1 with no Vocation. I know that i can change them in the Database but isnt there an easy option for that? And still they dont have any EQ

Help! :D
 
Last edited:
Sort by date Sort by votes
so you must use phpmyadmin and client phpmyadmin to execute queries and client to give items to each character(or hard way do it by sql queries)

here is query to change vocation from 0 to original one for vocation
Code: 
UPDATE players SET vocation = 1 WHERE name LIKE "%sorcerer%" AND vocation = 0;
UPDATE players SET vocation = 2 WHERE name LIKE "%druid%" AND vocation = 0;
UPDATE players SET vocation = 3 WHERE name LIKE "%paladin%" AND vocation = 0;
UPDATE players SET vocation = 4 WHERE name LIKE "%knight%" AND vocation = 0;
 
Upvote 0 Downvote
Thanks for that, and how do i know wich Account Datas are for the Samples so i can log in and give them items? I mean they the Passwords are encrypted.
 
Upvote 0 Downvote
SELECT name as login, password FROM accounts WHERE id = 1

oh... encrypted wait

@edit
@hellyea
"UPDATE accounts SET password = "601f1889667efaebb33b8c12572835da3f027f78" WHERE id = 1"
and try to login via account name and password set as "123123" this one is hashed in sha1
OR this
"UPDATE accounts SET password = "4297f44b13955235245b2497399d7a93" WHERE id = 1"
this is md5 "123123"
 
Upvote 0 Downvote
Hello, I have a problem with the site when creating a character moves me to a white page and nothing more happens does not appear in the database database could you help me?


PL:
Witam, mam problem ze strona przy tworzeniu charakteru przenosi mnie do białęj strony i nic więcej sie nie dzieje charakter nie pojawił sie w bazie danych moglibyście mi pomoc?
 

Attachments

Upvote 0 Downvote
Kaszana1p2l said:
Hello, I have a problem with the site when creating a character moves me to a white page and nothing more happens does not appear in the database database could you help me?


PL:
Witam, mam problem ze strona przy tworzeniu charakteru przenosi mnie do białęj strony i nic więcej sie nie dzieje charakter nie pojawił sie w bazie danych moglibyście mi pomoc?
Click to expand...

Hello,

please take a look in your Apache 2 error log. under linux it is typically /var/log/apache2/error.log. there will be more info in the file about issue you are having
 
Upvote 0 Downvote
I managed to extract such a thing from the error log on the nature of characters



Code: 
Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kafsdfsdfdadsas__10293__2212.myaac_spells' doesn't exist [Tue Mar 05 04:47:00.500773 2019] [:error] [pid 20980] [client --------] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kafsdfsdfdadsas__10293__2212.myaac_spells' 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('SELECT `name` F...')\n#1 /var/www/html/system/libs/validator.php(313): OTS_Base_DB->query('SELECT `name` F...')\n#2 /var/www/html/system/pages/account/create_character.php(29): Validator::newCharacterName('Afggafgadf')\n#3 /var/www/html/system/pages/accountmanagement.php(137): 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://polishotsclub.ddns.net/?account/character/create
[Tue Mar 05 04:47:03.540328 2019] [:error] [pid 21553] [client -----] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'k4545.myaac_spells' 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('SELECT `name` F...')\n#1 /var/www/html/system/libs/validator.php(313): OTS_Base_DB->query('SELECT `name` F...')\n#2 /var/www/html/system/pages/account/create_character.php(29): Validator::newCharacterName('Afggafgadf')\n#3 /var/www/html/system/pages/accountmanagement.php(137): 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://polishotsclub.ddns.net/?account/character/create
 
Upvote 0 Downvote
Kaszana1p2l said:
I managed to extract such a thing from the error log on the nature of characters



Code: 
Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kafsdfsdfdadsas__10293__2212.myaac_spells' doesn't exist [Tue Mar 05 04:47:00.500773 2019] [:error] [pid 20980] [client --------] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kafsdfsdfdadsas__10293__2212.myaac_spells' 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('SELECT `name` F...')\n#1 /var/www/html/system/libs/validator.php(313): OTS_Base_DB->query('SELECT `name` F...')\n#2 /var/www/html/system/pages/account/create_character.php(29): Validator::newCharacterName('Afggafgadf')\n#3 /var/www/html/system/pages/accountmanagement.php(137): 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://polishotsclub.ddns.net/?account/character/create
[Tue Mar 05 04:47:03.540328 2019] [:error] [pid 21553] [client -----] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'k4545.myaac_spells' 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('SELECT `name` F...')\n#1 /var/www/html/system/libs/validator.php(313): OTS_Base_DB->query('SELECT `name` F...')\n#2 /var/www/html/system/pages/account/create_character.php(29): Validator::newCharacterName('Afggafgadf')\n#3 /var/www/html/system/pages/accountmanagement.php(137): 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://polishotsclub.ddns.net/?account/character/create
Click to expand...
looks like you don't have the myaac_spells table. sounds like a uncompleted installation. look in phpmyadmin if you have other myaac tables like myaac_config or myaac_forum. in my opinion you should try to install the AAC again and see if there are any errors during installation.
 
Upvote 0 Downvote
Upvote 0 Downvote
Kaszana1p2l said:
What does it mean?

If it comes from missing a table in the database, it's not because it's this table, I'm already lost



View attachment 35200
Click to expand...

SOLVED

MariaDB accept only 1000 bytes.

SQL: 
CREATE TABLE `myaac_spells`
(
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `spell` VARCHAR(255) NOT NULL,
    `name` VARCHAR(255) NOT NULL,
    `words` VARCHAR(255) NOT NULL,
    `category` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '1 - attack, 2 - healing, 3 - summon, 4 - supply, 5 - support',
    `type` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '1 - instant, 2 - conjure, 3 - rune',
    `level` INT(11) NOT NULL DEFAULT 0,
    `maglevel` INT(11) NOT NULL DEFAULT 0,
    `mana` INT(11) NOT NULL DEFAULT 0,
    `soul` TINYINT(3) NOT NULL DEFAULT 0,
    `conjure_count` TINYINT(3) NOT NULL DEFAULT 0,
    `item_id` INT(11) NOT NULL DEFAULT 0,
    `premium` TINYINT(1) NOT NULL DEFAULT 0,
    `vocations` VARCHAR(100) NOT NULL DEFAULT '',
    `hidden` TINYINT(1) NOT NULL DEFAULT 0,
    PRIMARY KEY (`id`),
    UNIQUE (`name`)
) ENGINE = MyISAM;

Change for example this "spell VARCHAR(255)" to spell VARCHAR(100)

You can change it here "install/includes/schema.sql"
Or make a SQL Query after Installation.

OR upgrade your database to MySQL 5.7 or MariaDB 10.2

I can create a character now.
 
Last edited:
Upvote 0 Downvote

Similar threads

abdala ragab
  • Question
AAC MyAAC v0.8.15 After completing the installation
Replies
4
Views
260
abdala ragab
abdala ragab
E
  • Question
No Towns in AAC webpage and admin panel. No city to choose on character creation!
Replies
0
Views
206
endziu2222
E
Sanzenkai
  • Solved
TFS 0.X Wrong sex at character creation
Replies
4
Views
475
Sanzenkai
Sanzenkai
error656
  • Question
MyAAC v0.8.10 / MyAAC v0.9.0-alpha Character name with numbers
Replies
2
Views
261
error656
error656
Jpstafe
  • Solved
Erro Rook_Sample created(MYACC)
Replies
2
Views
304
Jpstafe
Jpstafe
S
  • Question
Problem with acc maker. Cant create a character.
Replies
4
Views
259
Shenzai
S
T
  • Question
TFS 1.X+ Reset accounts and characters with SQL Query
Replies
2
Views
471
Error 502
Error 502
Jpstafe
  • Question
MYACC CONFIGURE IP,DUDE
Replies
0
Views
193
Jpstafe
Jpstafe
PuszekLDZ
  • Question
Different corpse by vocation in 0.3.6
Replies
7
Views
351
djblah
D
Back
Top