Problem with Sample Skill

[exique]

I get this code when I try to create a knight:

Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xamppp\htdocs\pot\OTS_Player.php:1866 Stack trace: #0 C:\xamppp\htdocs\accountmanagement.php(960): OTS_Player->getSkill(1) #1 C:\xamppp\htdocs\index.php(135): include('C:\xamppp\htdoc...') #2 {main} thrown in C:\xamppp\htdocs\pot\OTS_Player.php on line 1866

Only on knight though. There were problems with the other samples before but it's fixed. But the knight sample didn't work the same way...

Knight sample id:6

I've tried with this:

INSERT INTO `player_skills` VALUES (6, 0, 10, 0);
INSERT INTO `player_skills` VALUES (6, 1, 10, 0);
INSERT INTO `player_skills` VALUES (6, 2, 10, 0);
INSERT INTO `player_skills` VALUES (6, 3, 10, 0);
INSERT INTO `player_skills` VALUES (6, 4, 10, 0);
INSERT INTO `player_skills` VALUES (6, 5, 10, 0);
INSERT INTO `player_skills` VALUES (6, 6, 10, 0);

Help!

 

[Fyruz]

ty changing knight id to 4

 

[Strasxni]

Try this

INSERT INTO `player_skills` (`player_id` ,`skillid` ,`value` ,`count`) VALUES ('5', '0', '10', '0'), ('5', '1', '10', '0'), ('5', '2', '10', '0'), ('5', '3', '10', '0'), ('5', '4', '10', '0'), ('5', '5', '10', '0'), ('5', '6', '10', '0'), ('3', '0', '10', '0'), ('3', '1', '10', '0'), ('3', '2', '10', '0'), ('3', '3', '10', '0'), ('3', '4', '10', '0'), ('3', '5', '10', '0'), ('3', '6', '10', '0'), ('4', '0', '10', '0'), ('4', '1', '10', '0'), ('4', '2', '10', '0'), ('4', '3', '10', '0'), ('4', '4', '10', '0'), ('4', '5', '10', '0'), ('4', '6', '10', '0'), ('6', '0', '10', '0'), ('6', '1', '10', '0'), ('6', '2', '10', '0'), ('6', '3', '10', '0'), ('6', '4', '10', '0'), ('6', '5', '10', '0'), ('6', '6', '10', '0')

 

[exique]

Try this

INSERT INTO `player_skills` (`player_id` ,`skillid` ,`value` ,`count`) VALUES ('5', '0', '10', '0'), ('5', '1', '10', '0'), ('5', '2', '10', '0'), ('5', '3', '10', '0'), ('5', '4', '10', '0'), ('5', '5', '10', '0'), ('5', '6', '10', '0'), ('3', '0', '10', '0'), ('3', '1', '10', '0'), ('3', '2', '10', '0'), ('3', '3', '10', '0'), ('3', '4', '10', '0'), ('3', '5', '10', '0'), ('3', '6', '10', '0'), ('4', '0', '10', '0'), ('4', '1', '10', '0'), ('4', '2', '10', '0'), ('4', '3', '10', '0'), ('4', '4', '10', '0'), ('4', '5', '10', '0'), ('4', '6', '10', '0'), ('6', '0', '10', '0'), ('6', '1', '10', '0'), ('6', '2', '10', '0'), ('6', '3', '10', '0'), ('6', '4', '10', '0'), ('6', '5', '10', '0'), ('6', '6', '10', '0')

#1062 - Duplicate entry '5-0' for key 1

 

[Strasxni]

Maybe this

INSERT INTO `player_skills` (`player_id` ,`skillid` ,`value` ,`count`) VALUES ('6', '0', '10', '0'), ('6', '1', '10', '0'), ('6', '2', '10', '0'), ('6', '3', '10', '0'), ('6', '4', '10', '0'), ('6', '5', '10', '0'), ('6', '6', '10', '0')

 

[exique]

Maybe this

INSERT INTO `player_skills` (`player_id` ,`skillid` ,`value` ,`count`) VALUES ('6', '0', '10', '0'), ('6', '1', '10', '0'), ('6', '2', '10', '0'), ('6', '3', '10', '0'), ('6', '4', '10', '0'), ('6', '5', '10', '0'), ('6', '6', '10', '0')

#1062 - Duplicate entry '6-0' for key 1
>.<

 

[Strasxni]

What about this?

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample'), 0, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample'), 1, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample'), 2, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample'), 3, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample'), 4, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample'), 5, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample'), 6, 10);

 

[exique]

What about this?

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample'), 0, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample'), 1, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample'), 2, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample'), 3, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample'), 4, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample'), 5, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Knight Sample'), 6, 10);

#1062 - Duplicate entry '6-0' for key 1

 

[Strasxni]

#1062 - Duplicate entry '6-0' for key 1

So you already have it. Try to remove them first, then execute that command.

 

[exique]

So you already have it. Try to remove them first, then execute that command.

Easiest way to remove it..
I don't want to fuck anything more up :S

 

[exique]

Best way to remove it..?
I don't want to fuck anything more up :S

Bump

 

[exique]

How do i remove it?!

 

[Cykotitan]

DELETE FROM player_skills WHERE player_id = 6
?