Help with skill problem :/

[andrew95434]

The problem is that people skills in training monks.. or wherever, and they go up with skills,
but when they log out and log in, or die, etc..
they have skill 10 :/ plz help what should i do??

 

[Bufo]

In database in players table you must edit this column for 100:

loss_experience
loss_mana
loss_skills
loss_containers
loss_items

 

[Cykotitan]

or you're missing the triggers. http://otland.net/f250/sql-querry-127478/#post1234792

 

[andrew95434]

thx!!! ill try it

 

[andrew95434]

@Bufo
doesnt work :/

@Cykotitan
i cant access the page :/

 

[Cykotitan]

okay, this is what you have to execute in phpMyAdmin:

INSERT IGNORE INTO `player_skills`
SELECT `id` , 0, 10, 0
FROM `players`
UNION SELECT `id` , 1, 10, 0
FROM `players`
UNION SELECT `id` , 2, 10, 0
FROM `players`
UNION SELECT `id` , 3, 10, 0
FROM `players`
UNION SELECT `id` , 4, 10, 0
FROM `players`
UNION SELECT `id` , 5, 10, 0
FROM `players`
UNION SELECT `id` , 6, 10, 0
FROM `players` ;

ideally, all players should be offline

 

[andrew95434]

sorry about my ignorance but, where do i put it :/?

 

[tompan]

phpMyAdmin.. go to your database and go to players and press "SQL" and just copy this in there

 

[andrew95434]

thx bro, ill try it later cuz im not in home ;Z

 

[andrew95434]

okay, this is what you have to execute in phpMyAdmin:

INSERT IGNORE INTO `player_skills`
SELECT `id` , 0, 10, 0
FROM `players`
UNION SELECT `id` , 1, 10, 0
FROM `players`
UNION SELECT `id` , 2, 10, 0
FROM `players`
UNION SELECT `id` , 3, 10, 0
FROM `players`
UNION SELECT `id` , 4, 10, 0
FROM `players`
UNION SELECT `id` , 5, 10, 0
FROM `players`
UNION SELECT `id` , 6, 10, 0
FROM `players` ;

ideally, all players should be offline

that works but.. i have to execute it every time when someone create a new player, how can i do it to always that code works??
sorry about my english :/

 

[Cykotitan]

how do players create their characters? through account manager or website? if website, which AAC are you using?

 

[andrew95434]

trough website, im using gesior acc

 

[Cykotitan]

missing triggers maybe? which XAMPP version?

 

[andrew95434]

maybe is it this:


Trigger: ondelete_accounts does not exist, creating it...
[09/05/2011 16:27:58] mysql_real_query(): CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` NOT IN(1, 2) AND `value` = OLD.`id`; END; - MYSQL ERROR: Trigger already exists (1359)
[09/05/2011 16:27:58] > Trigger: oncreate_guilds does not exist, creating it...
[09/05/2011 16:27:58] mysql_real_query(): CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds` FOR EACH ROW BEGIN INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`); END; - MYSQL ERROR: Trigger already exists (1359)
[09/05/2011 16:27:58] > Trigger: ondelete_guilds does not exist, creating it...
[09/05/2011 16:27:58] mysql_real_query(): CREATE TRIGGER `ondelete_guilds` BEFORE DELETE ON `guilds` FOR EACH ROW BEGIN UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`); END; - MYSQL ERROR: Trigger already exists (1359)
[09/05/2011 16:27:59] > Trigger: oncreate_players does not exist, creating it...
[09/05/2011 16:27:59] mysql_real_query(): 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; - MYSQL ERROR: Trigger already exists (1359)
[09/05/2011 16:27:59] > Trigger: ondelete_players does not exist, creating it...
[09/05/2011 16:27:59] mysql_real_query(): CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` = 2 AND `value` = OLD.`id`; UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`; END; - MYSQL ERROR: Trigger already exists (1359)


that apears in the executer of the server...

 

[Cykotitan]

yup its something wrong with your mysql/database ;p

 

[andrew95434]

how can i fix it?

 

[Cykotitan]

change xampp version/create new db