Modern Acc Sample Character Missing Help Fast :/

[Printer]

Modern Acc Sample Character Missing Help Fast :/

Rep!

 

[Ninja]

You can get the SQL query from install/dbSCHEMA.

 

[Printer]

Where can i find that?

 

[Ninja]

The location is /var/www/install/dbSCHEMA if you're using Linux.

I'm not sure if the query from the MAAC version I'm using is working, but you could try.

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.');

 

[Printer]

I get this error:

#1452 - Cannot add or update a child row: a foreign key constraint fails (`pportal`.`players`, CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE)

 

[Bassam421]

are you using mysql or sqlite?

 

[Printer]

Mysql

 

[zippy]

I had similar problem, i try to search after solution.

 

[Herpicus]

Make sure you have an account with account_id 1 too..

INSERT INTO `players` (`name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`) VALUES ('Rook Sample', 0, 1, 1, 1, 0),('Sorcerer Sample', 0, 1, 1, 1, 1),('Druid Sample', 0, 1, 1, 1, 2),('Paladin Sample', 0, 1, 1, 1, 3),('Knight Sample', 0, 1, 1, 1, 4);

 

[Meed]

When i try to do that it just says Column count doesn't match value count at row 1

- - - Updated - - -

Ey guys? do u know how to fix the character samples in the Database Modern AAC? i have the samples as chars, but when i make a new character it says loss_experience = 10, loss_mana = 10, loss_skills, 10 but loss_containers is 100 and so is loss_items please help me and replie as soon as possible