Guildmaster

[Quickshot]

Hi, i need a guildmaster for my 8.4 server if you can help ill appreciate it

 

[Cykotitan]

Use !createguild, !joinguild and other in-game guild commands, or just use aac with an built-in guild system, instead of the ancient guild NPC.

 

[Quickshot]

when i try to create a guild by using !createguild it crashes my server...
can you show me a tutorial for creating a website so i can use the guild maker on that

 

[Pitufo™]

Tutorial for XAMP(setup your webserver): Here

Download Website(Gesior Website(with Guild creating system)): Here

Tutorial to setup your Gesior Website: Here

Frequent Asked Question(For Gesior Website): Here

 

[Quickshot]

i tryed making the website using you first tutorial you gave me but doesnt work... anyways is there a guildmaster for 8.4 cause i would like to just have one

 

[Cykotitan]

when i try to create a guild by using !createguild it crashes my server...
can you show me a tutorial for creating a website so i can use the guild maker on that

Please note that this now is very important;

What version of XAMPP are you using?

 

[Quickshot]

i guess im using the lastest version not sure exactly which one

 

[Cykotitan]

Please use XAMPP 1.6.6a, and re-import the database.sql/forgottenserver.sql file (or whatever it's called)

If you want to just export your old database, then, you should execute this SQL query once you install XAMPP 1.6.6a:

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 ;

The Query contains all queries which fail executing when someone isn't using XAMPP 1.6.6a

 

[Sir MoX]

pitufo you didnt give right the link to download te website...