bug z guilds

[Grabek980]

Witam mam problem z guilds -.- chodzi o to że gdy robię guilds to mnie w niej niema .... brakuje mi jakiegoś zapytania do bazy danych na pewno .

Dedyk mam na netshoot.pl

 

[sn3ejk]

Podrzuć plik guilds.php to poradzimy.

 

[Vendeliko]

Musisz byc wylogowany jak robisz guild

 

[Grabek980]

haha zabawne bardzo tylko że robiłem jak serwer jest off i pisze że to nie wina guild.php tylko brak jakiegoś zapytania no ale masz

Wklej.to - po prostu wklej to! - paste: dw2sW

 

[averatec]

zapodałbyś treść błędu?

 

[Grabek980]

jak bym mógł to bym dał ... netshoot nie chce mi włączyć pokazywania błedów... wiem że na to było jakieś zapytanie do bazy danych

 

[Aleh]

na pc sobie sobacz

 

[Grabek980]

na pc nie mam tego bugu dodam że na dedyku jest linux

dzięki że się staracie pomóc

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 command denied to user 'baza_6055'@'localhost' for table 'players' (1142)

Trigger: ondelete_players does not exist, creating it...

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 command denied to user 'baza_6055'@'localhost' for table 'players' (1142)
[20:10:54.853] > Trigger: oncreate_players does not exist, creating it...
[20:10:54.850] 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 command denied to user 'baza_6055'@'localhost' for table 'guilds' (1142)

[20:10:54.850] > Trigger: ondelete_guilds does not exist, creating it...
[20:10:54.847] 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 command denied to user 'baza_6055'@'localhost' for table 'guilds' (1142)
[20:10:54.846] > Trigger: oncreate_guilds does not exist, creating it...
[20:10:54.843] 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 command denied to user 'baza_6055'@'localhost' for table 'accounts' (1142)

Oto lista bugów w tfs

 

[Grabek980]

odświeżam

 

[Grabek980]

odświeżam

 

[cyna]

W config.lua zmień z true na false:

ingameGuildManagement = false

Powinno pomóc.

A co do tych błędów do dodaj to, czego brakuje, masz pokazane:

`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 command denied to user 'baza_6055'@'localhost' for table 'guilds' (1142)

CREATE TRIGGER `ondelete_accounts`