Guild system bugged :/ (Rep++)

[andurz]

Hi, My guild system on my homepage is bugged, it works to create a guild but i cant controll it . I cannot invite anyone to it or change descriptions and stuffs like that, I'm using Gesior homepage for TFS 0.2 (I will rep you if you can help me)

 

[Teddy]

you/the player most be offline when they creat the guild !
the player you inv most be offline when he join the guild !
If it help rep++

// If you use geisor

 

[andurz]

you/the player most be offline when they creat the guild !
the player you inv most be offline when he join the guild !
If it help rep++

It dident work :/

 

[Teddy]

do you use geisor ?

 

[Artii]

What error do you get?

 

[andurz]

Yes im using Gesior, I dont really got any errors, i can create the guild.But it says that im the leader but i cant controll the guild..

 

[Teddy]

give me you homepage

 

[andurz]

Crystalots.no-ip.org

 

[andurz]

When i press on cleanup guild im getting this

# Deleted guilds (leaders of this guilds are not members of this guild [fix bugged guilds]):Dissaster
# Unholy Mages

 

[Don Daniello]

Some hints:
- Player can be in one guild only -> you cannot invite player who's in guild
- Player must be offline
- yo ushould successfuly clean up guilds and players

 

[Andurzz]

Some hints:
- Player can be in one guild only -> you cannot invite player who's in guild
- Player must be offline
- yo ushould successfuly clean up guilds and players

When i create the guild on the hompage i cant see the guild in-game :/

 

[Cykotitan]

Try executing this SQL query:

DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR EACH ROW
BEGIN
    DELETE FROM `bans` WHERE `account` = OLD.`id`;
END|

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|

CREATE TRIGGER `ondelete_players`
BEFORE DELETE
ON `players`
FOR EACH ROW
BEGIN
    DELETE FROM `bans` WHERE `type` = 2 AND `player` = OLD.`id`;
    UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;
END|

CREATE TRIGGER `oncreate_guilds`
AFTER INSERT
ON `guilds`
FOR EACH ROW
BEGIN
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('the Leader', 3, NEW.`id`);
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Vice-Leader', 2, NEW.`id`);
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Member', 1, NEW.`id`);
END|

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|

DELIMITER ;

In case it fails (shows up any errors), then you must use XAMPP 1.6.6.a

Note that I had the exactly same problem, but I fixed it by using XAMPP 1.6.6a

Download Link for XAMPP 1.6.6a:
http://downloads.sourceforge.net/xampp/xampp-win32-1.6.6a-installer.exe?use_mirror=switch

 

[andurz]

Try executing this SQL query:

DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR EACH ROW
BEGIN
    DELETE FROM `bans` WHERE `account` = OLD.`id`;
END|

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|

CREATE TRIGGER `ondelete_players`
BEFORE DELETE
ON `players`
FOR EACH ROW
BEGIN
    DELETE FROM `bans` WHERE `type` = 2 AND `player` = OLD.`id`;
    UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;
END|

CREATE TRIGGER `oncreate_guilds`
AFTER INSERT
ON `guilds`
FOR EACH ROW
BEGIN
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('the Leader', 3, NEW.`id`);
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Vice-Leader', 2, NEW.`id`);
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Member', 1, NEW.`id`);
END|

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|

DELIMITER ;

In case it fails (shows up any errors), then you must use XAMPP 1.6.6.a

Note that I had the exactly same problem, but I fixed it by using XAMPP 1.6.6a

Download Link for XAMPP 1.6.6a:
SourceForge.net: XAMPP: Downloading ...

Thank you! I installed xampp 1.6.6a

 

[HeberPcL]

Cykotitan, Thanks!!

Rep++