kitsunechao
New Member
- Joined
- Feb 23, 2011
- Messages
- 9
- Reaction score
- 0
Anyone help me? sample characters skills aren't copied.
CREATE TABLE `player_skills`
(
`player_id` INT NOT NULL DEFAULT 0,
`skillid` TINYINT(2) NOT NULL DEFAULT 0,
`value` INT UNSIGNED NOT NULL DEFAULT 0,
`count` INT UNSIGNED NOT NULL DEFAULT 0,
KEY (`player_id`), UNIQUE (`player_id`, `skillid`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;
CREATE TRIGGER `oncreate_players`
AFTER INSERT
ON `players`
FOR EACH ROW
BEGIN
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END|
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Scout Sample' LIMIT 1), 0, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Scout Sample' LIMIT 1), 1, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Scout Sample' LIMIT 1), 2, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Scout Sample' LIMIT 1), 3, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Scout Sample' LIMIT 1), 4, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Scout Sample' LIMIT 1), 5, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Scout Sample' LIMIT 1), 6, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Pyro Sample' LIMIT 1), 0, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Pyro Sample' LIMIT 1), 1, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Pyro Sample' LIMIT 1), 2, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Pyro Sample' LIMIT 1), 3, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Pyro Sample' LIMIT 1), 4, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Pyro Sample' LIMIT 1), 5, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Pyro Sample' LIMIT 1), 6, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Engineer Sample' LIMIT 1), 0, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Engineer Sample' LIMIT 1), 1, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Engineer Sample' LIMIT 1), 2, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Engineer Sample' LIMIT 1), 3, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Engineer Sample' LIMIT 1), 4, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Engineer Sample' LIMIT 1), 5, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Engineer Sample' LIMIT 1), 6, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Soldier Sample' LIMIT 1), 0, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Soldier Sample' LIMIT 1), 1, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Soldier Sample' LIMIT 1), 2, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Soldier Sample' LIMIT 1), 3, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Soldier Sample' LIMIT 1), 4, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Soldier Sample' LIMIT 1), 5, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Soldier Sample' LIMIT 1), 6, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Spy Sample' LIMIT 1), 0, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Spy Sample' LIMIT 1), 1, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Spy Sample' LIMIT 1), 2, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Spy Sample' LIMIT 1), 3, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Spy Sample' LIMIT 1), 4, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Spy Sample' LIMIT 1), 5, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Spy Sample' LIMIT 1), 6, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Demoman Sample' LIMIT 1), 0, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Demoman Sample' LIMIT 1), 1, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Demoman Sample' LIMIT 1), 2, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Demoman Sample' LIMIT 1), 3, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Demoman Sample' LIMIT 1), 4, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Demoman Sample' LIMIT 1), 5, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Demoman Sample' LIMIT 1), 6, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Medic Sample' LIMIT 1), 0, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Medic Sample' LIMIT 1), 1, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Medic Sample' LIMIT 1), 2, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Medic Sample' LIMIT 1), 3, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Medic Sample' LIMIT 1), 4, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Medic Sample' LIMIT 1), 5, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Medic Sample' LIMIT 1), 6, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Sniper Sample' LIMIT 1), 0, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Sniper Sample' LIMIT 1), 1, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Sniper Sample' LIMIT 1), 2, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Sniper Sample' LIMIT 1), 3, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Sniper Sample' LIMIT 1), 4, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Sniper Sample' LIMIT 1), 5, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Sniper Sample' LIMIT 1), 6, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Heavy Sample' LIMIT 1), 0, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Heavy Sample' LIMIT 1), 1, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Heavy Sample' LIMIT 1), 2, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Heavy Sample' LIMIT 1), 3, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Heavy Sample' LIMIT 1), 4, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Heavy Sample' LIMIT 1), 5, 10, 0);
INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Heavy Sample' LIMIT 1), 6, 10, 0);
Execute this and then try to create a new character.SQL:INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Scout Sample' LIMIT 1), 0, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Scout Sample' LIMIT 1), 1, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Scout Sample' LIMIT 1), 2, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Scout Sample' LIMIT 1), 3, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Scout Sample' LIMIT 1), 4, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Scout Sample' LIMIT 1), 5, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Scout Sample' LIMIT 1), 6, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Pyro Sample' LIMIT 1), 0, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Pyro Sample' LIMIT 1), 1, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Pyro Sample' LIMIT 1), 2, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Pyro Sample' LIMIT 1), 3, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Pyro Sample' LIMIT 1), 4, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Pyro Sample' LIMIT 1), 5, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Pyro Sample' LIMIT 1), 6, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Engineer Sample' LIMIT 1), 0, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Engineer Sample' LIMIT 1), 1, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Engineer Sample' LIMIT 1), 2, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Engineer Sample' LIMIT 1), 3, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Engineer Sample' LIMIT 1), 4, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Engineer Sample' LIMIT 1), 5, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Engineer Sample' LIMIT 1), 6, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Soldier Sample' LIMIT 1), 0, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Soldier Sample' LIMIT 1), 1, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Soldier Sample' LIMIT 1), 2, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Soldier Sample' LIMIT 1), 3, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Soldier Sample' LIMIT 1), 4, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Soldier Sample' LIMIT 1), 5, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Soldier Sample' LIMIT 1), 6, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Spy Sample' LIMIT 1), 0, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Spy Sample' LIMIT 1), 1, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Spy Sample' LIMIT 1), 2, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Spy Sample' LIMIT 1), 3, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Spy Sample' LIMIT 1), 4, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Spy Sample' LIMIT 1), 5, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Spy Sample' LIMIT 1), 6, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Demoman Sample' LIMIT 1), 0, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Demoman Sample' LIMIT 1), 1, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Demoman Sample' LIMIT 1), 2, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Demoman Sample' LIMIT 1), 3, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Demoman Sample' LIMIT 1), 4, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Demoman Sample' LIMIT 1), 5, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Demoman Sample' LIMIT 1), 6, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Medic Sample' LIMIT 1), 0, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Medic Sample' LIMIT 1), 1, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Medic Sample' LIMIT 1), 2, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Medic Sample' LIMIT 1), 3, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Medic Sample' LIMIT 1), 4, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Medic Sample' LIMIT 1), 5, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Medic Sample' LIMIT 1), 6, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Sniper Sample' LIMIT 1), 0, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Sniper Sample' LIMIT 1), 1, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Sniper Sample' LIMIT 1), 2, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Sniper Sample' LIMIT 1), 3, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Sniper Sample' LIMIT 1), 4, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Sniper Sample' LIMIT 1), 5, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Sniper Sample' LIMIT 1), 6, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Heavy Sample' LIMIT 1), 0, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Heavy Sample' LIMIT 1), 1, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Heavy Sample' LIMIT 1), 2, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Heavy Sample' LIMIT 1), 3, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Heavy Sample' LIMIT 1), 4, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Heavy Sample' LIMIT 1), 5, 10, 0); INSERT INTO `player_skills` VALUES ((SELECT `id` FROM `players` WHERE `name` = 'Heavy Sample' LIMIT 1), 6, 10, 0);
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')