Modern AAC Character Samples Problem

[undead mage]

When im trying to create a character on my site (modern aac) im getting this error

An Error Was Encountered
Sample character could not be found!

So I googled a bit and checked out otland to and found that I should add this into my database

INSERT INTO `players` (`name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `worldtransfer`, `comment`) VALUES
('Rook Sample', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
('Sorcerer Sample', 0, 1, 1, 8, 1, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
('Druid Sample', 0, 1, 1, 8, 2, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
('Paladin Sample', 0, 1, 1, 8, 3, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
('Knight Sample', 0, 1, 1, 8, 4, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.');

But then it gave me this error

#1054 - Unknown column 'world_id' in 'field list'

Can anyone please help?

 

[Lava Titan]

Delete your current database and instal MAAC again I guess

 

[undead mage]

I dont see how that would help

 

[Cornex]

ALTER TABLE `players` ADD `world_id` int(11)

 

[Lava Titan]

well Cornex query will solve your problem, but world_id should not be missing I guess, unless you did something wrong, thats why I said that :X
cuz if world_id is missing, more tables may be missing too

 

[undead mage]

Now all my passwords are encrypted with sha1 I have checked otland and saw that some people said that with modern aac it isn't possible to use plain passwords is that true?

 

[Lava Titan]

Not sure but I think thats related to ur config.lua

 

[undead mage]

No I already changed it in config.lua so the server works with plain now but now modern aac needs also to be changed to plain because now when people are creating accounts on the site their passwords are getting encrypted with sha1 and that has to change

 

[undead mage]

Bump

 

[Cornex]

Now all my passwords are encrypted with sha1 I have checked otland and saw that some people said that with modern aac it isn't possible to use plain passwords is that true?

Could be true. And I don't see why anyone would like to use plain other than the otland haxxors that want to hack on other servers haha.
My AAC (bitaac) will not support plain per default just because of above and I think that players have the right to have their passwords hashed in some way, even is sha1 is not the best pick.

Anyhow, if you give me a link to the AAC you using I could check it out for you.

 

[undead mage]

Could be true. And I don't see why anyone would like to use plain other than the otland haxxors that want to hack on other servers haha.
My AAC (bitaac) will not support plain per default just because of above and I think that players have the right to have their passwords hashed in some way, even is sha1 is not the best pick.

Anyhow, if you give me a link to the AAC you using I could check it out for you.

I just prefer plain ofc everyone says that even the hackers but I could just download gesior that does support plain if I would want to hack. I will pm you the link

 

[undead mage]

Close thread it has been solved by Cornex thank you very much!