Merge commit '723fb5d3431b847526c433a13aa74485cfb564a3'

1 files changed, 0 insertions, 2111 deletions

diff --git a/src/char_sql/int_guild.c b/src/char_sql/int_guild.c
deleted file mode 100644
index 7b363a1..0000000
--- a/src/char_sql/int_guild.c
+++ /dev/null
@@ -1,2111 +0,0 @@
-//
-// original code from athena
-// SQL conversion by hack
-//
-
-#include "char.h"
-#include "strlib.h"
-#include "int_storage.h"
-#include "inter.h"
-#include "int_guild.h"
-#include "int_storage.h"
-#include "mmo.h"
-#include "socket.h"
-
-#include <string.h>
-#include <stdio.h>
-#include <stdlib.h>
-
-static struct guild *guild_pt;
-static struct guild *guild_pt2;
-static struct guild_castle *guildcastle_pt;
-static int guild_newid = 10000;
-
-static int guild_exp[100];
-
-int  mapif_parse_GuildLeave (int fd, int guild_id, int account_id,
-                             int char_id, int flag, const char *mes);
-int  mapif_guild_broken (int guild_id, int flag);
-int  guild_check_empty (struct guild *g);
-int  guild_calcinfo (struct guild *g);
-int  mapif_guild_basicinfochanged (int guild_id, int type, const void *data,
-                                   int len);
-int  mapif_guild_info (int fd, struct guild *g);
-int  guild_break_sub (void *key, void *data, va_list ap);
-
-// Save guild into sql
-int inter_guild_tosql (struct guild *g, int flag)
-{
-    // 1 `guild` (`guild_id`, `name`,`master`,`guild_lv`,`connect_member`,`max_member`,`average_lv`,`exp`,`next_exp`,`skill_point`,`castle_id`,`mes1`,`mes2`,`emblem_len`,`emblem_id`,`emblem_data`)
-    // 2 `guild_member` (`guild_id`,`account_id`,`char_id`,`hair`,`hair_color`,`gender`,`class`,`lv`,`exp`,`exp_payper`,`online`,`position`,`rsv1`,`rsv2`,`name`)
-    // 4 `guild_position` (`guild_id`,`position`,`name`,`mode`,`exp_mode`)
-    // 8 `guild_alliance` (`guild_id`,`opposition`,`alliance_id`,`name`)
-    // 16 `guild_expulsion` (`guild_id`,`name`,`mes`,`acc`,`account_id`,`rsv1`,`rsv2`,`rsv3`) 
-    // 32 `guild_skill` (`guild_id`,`id`,`lv`)
-
-    char t_name[100], t_master[24], t_mes1[60], t_mes2[120], t_member[24], t_position[24], t_alliance[24];  // temporay storage for str convertion;
-    char t_ename[24], t_emes[40];
-    char emblem_data[4096];
-    int  i = 0;
-    int  guild_exist = 0, guild_member = 0, guild_online_member = 0;
-
-    if (g->guild_id <= 0)
-        return -1;
-
-    printf ("(\033[1;35m%d\033[0m)  Request save guild - ", g->guild_id);
-
-    jstrescapecpy (t_name, g->name);
-
-    //printf("- Check if guild %d exists\n",g->guild_id);
-    sprintf (tmp_sql, "SELECT count(*) FROM `%s` WHERE `guild_id`='%d'",
-             guild_db, g->guild_id);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (delete `guild`)- %s\n",
-                mysql_error (&mysql_handle));
-    }
-    sql_res = mysql_store_result (&mysql_handle);
-    if (sql_res != NULL && mysql_num_rows (sql_res) > 0)
-    {
-        sql_row = mysql_fetch_row (sql_res);
-        guild_exist = atoi (sql_row[0]);
-        //printf("- Check if guild %d exists : %s\n",g->guild_id,((guild_exist==0)?"No":"Yes"));
-    }
-    mysql_free_result (sql_res);    //resource free
-
-    if (guild_exist > 0)
-    {
-        // Check members in party
-        sprintf (tmp_sql, "SELECT count(*) FROM `%s` WHERE `guild_id`='%d'",
-                 guild_member_db, g->guild_id);
-        if (mysql_query (&mysql_handle, tmp_sql))
-        {
-            printf ("DB server Error - %s\n", mysql_error (&mysql_handle));
-            return -1;
-        }
-        sql_res = mysql_store_result (&mysql_handle);
-        if (sql_res != NULL && mysql_num_rows (sql_res) > 0)
-        {
-            sql_row = mysql_fetch_row (sql_res);
-
-            guild_member = atoi (sql_row[0]);
-            //  printf("- Check members in guild %d : %d \n",g->guild_id,guild_member);
-
-        }
-        mysql_free_result (sql_res);    //resource free
-
-        // Delete old guild from sql
-        if (flag & 1 || guild_member == 0)
-        {
-            //  printf("- Delete guild %d from guild\n",g->guild_id);
-            sprintf (tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d'",
-                     guild_db, g->guild_id);
-            if (mysql_query (&mysql_handle, tmp_sql))
-            {
-                printf ("DB server Error (delete `guild`)- %s\n",
-                        mysql_error (&mysql_handle));
-            }
-        }
-        if (flag & 2 || guild_member == 0)
-        {
-            //  printf("- Delete guild %d from guild_member\n",g->guild_id);
-            sprintf (tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d'",
-                     guild_member_db, g->guild_id);
-            if (mysql_query (&mysql_handle, tmp_sql))
-            {
-                printf ("DB server Error (delete `guild_member`)- %s\n",
-                        mysql_error (&mysql_handle));
-            }
-            sprintf (tmp_sql,
-                     "UPDATE `%s` SET `guild_id`='0' WHERE `guild_id`='%d'",
-                     char_db, g->guild_id);
-            if (mysql_query (&mysql_handle, tmp_sql))
-            {
-                printf ("DB server Error (update `char`)- %s\n",
-                        mysql_error (&mysql_handle));
-            }
-        }
-        if (flag & 32 || guild_member == 0)
-        {
-            //  printf("- Delete guild %d from guild_skill\n",g->guild_id);
-            sprintf (tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d'",
-                     guild_skill_db, g->guild_id);
-            if (mysql_query (&mysql_handle, tmp_sql))
-            {
-                printf ("DB server Error (delete `guild_skill`)- %s\n",
-                        mysql_error (&mysql_handle));
-            }
-        }
-        if (flag & 4 || guild_member == 0)
-        {
-            //  printf("- Delete guild %d from guild_position\n",g->guild_id);
-            sprintf (tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d'",
-                     guild_position_db, g->guild_id);
-            if (mysql_query (&mysql_handle, tmp_sql))
-            {
-                printf ("DB server Error (delete `guild_position`)- %s\n",
-                        mysql_error (&mysql_handle));
-            }
-        }
-        if (flag & 16 || guild_member == 0)
-        {
-            //  printf("- Delete guild %d from guild_expulsion\n",g->guild_id);
-            sprintf (tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d'",
-                     guild_expulsion_db, g->guild_id);
-            if (mysql_query (&mysql_handle, tmp_sql))
-            {
-                printf ("DB server Error (delete `guild_expulsion`)- %s\n",
-                        mysql_error (&mysql_handle));
-            }
-        }
-        if (flag & 8 || guild_member == 0)
-        {
-            //  printf("- Delete guild %d from guild_alliance\n",g->guild_id);
-            sprintf (tmp_sql,
-                     "DELETE FROM `%s` WHERE `guild_id`='%d' OR `alliance_id`='%d'",
-                     guild_alliance_db, g->guild_id, g->guild_id);
-            if (mysql_query (&mysql_handle, tmp_sql))
-            {
-                printf ("DB server Error (delete `guild_alliance`)- %s\n",
-                        mysql_error (&mysql_handle));
-            }
-        }
-        if (flag & 2 || guild_member == 0)
-        {
-            //  printf("- Delete guild %d from char\n",g->guild_id);
-            sprintf (tmp_sql,
-                     "UPDATE `%s` SET `guild_id`='0' WHERE `guild_id`='%d'",
-                     char_db, g->guild_id);
-            if (mysql_query (&mysql_handle, tmp_sql))
-            {
-                printf ("DB server Error (delete `guild_alliance`)- %s\n",
-                        mysql_error (&mysql_handle));
-            }
-        }
-        if (guild_member == 0)
-        {
-            //  printf("- Delete guild %d from guild_castle\n",g->guild_id);
-            sprintf (tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d'",
-                     guild_castle_db, g->guild_id);
-            if (mysql_query (&mysql_handle, tmp_sql))
-            {
-                printf ("DB server Error (delete `guild_castle`)- %s\n",
-                        mysql_error (&mysql_handle));
-            }
-        }
-    }
-
-    guild_online_member = 0;
-    i = 0;
-    while (i < g->max_member)
-    {
-        if (g->member[i].account_id > 0)
-            guild_online_member++;
-        i++;
-    }
-
-    // No member in guild , no need to create it in sql
-    if (guild_member <= 0 && guild_online_member <= 0)
-    {
-        inter_guild_storage_delete (g->guild_id);
-        printf ("No member in guild %d , break it! \n", g->guild_id);
-        return -2;
-    }
-
-    // Insert new guild to sqlserver
-    if (flag & 1 || guild_member == 0)
-    {
-        int  len = 0;
-        //printf("- Insert guild %d to guild\n",g->guild_id);
-        for (i = 0; i < g->emblem_len; i++)
-        {
-            len +=
-                sprintf (emblem_data + len, "%02x",
-                         (unsigned char) (g->emblem_data[i]));
-            //printf("%02x",(unsigned char)(g->emblem_data[i]));
-        }
-        emblem_data[len] = '\0';
-        //printf("- emblem_len = %d \n",g->emblem_len);
-        sprintf (tmp_sql, "INSERT INTO `%s` "
-                 "(`guild_id`, `name`,`master`,`guild_lv`,`connect_member`,`max_member`,`average_lv`,`exp`,`next_exp`,`skill_point`,`castle_id`,`mes1`,`mes2`,`emblem_len`,`emblem_id`,`emblem_data`) "
-                 "VALUES ('%d', '%s', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%s', '%s', '%d', '%d', '%s')",
-                 guild_db, g->guild_id, t_name, jstrescapecpy (t_master,
-                                                               g->master),
-                 g->guild_lv, g->connect_member, g->max_member, g->average_lv,
-                 g->exp, g->next_exp, g->skill_point, g->castle_id,
-                 jstrescapecpy (t_mes1, g->mes1), jstrescapecpy (t_mes2,
-                                                                 g->mes2),
-                 g->emblem_len, g->emblem_id, emblem_data);
-        //printf(" %s\n",tmp_sql);
-        if (mysql_query (&mysql_handle, tmp_sql))
-        {
-            printf ("DB server Error (insert `guild`)- %s\n",
-                    mysql_error (&mysql_handle));
-        }
-    }
-
-    if (flag & 2 || guild_member == 0)
-    {
-        //printf("- Insert guild %d to guild_member\n",g->guild_id);
-        for (i = 0; i < g->max_member; i++)
-        {
-            if (g->member[i].account_id > 0)
-            {
-                struct guild_member *m = &g->member[i];
-                sprintf (tmp_sql, "DELETE FROM `%s` WHERE `char_id`='%d'",
-                         guild_member_db, m->char_id);
-                if (mysql_query (&mysql_handle, tmp_sql))
-                {
-                    printf ("DB server Error (delete `guild_member`)- %s\n",
-                            mysql_error (&mysql_handle));
-                }
-                sprintf (tmp_sql, "INSERT INTO `%s` "
-                         "(`guild_id`,`account_id`,`char_id`,`hair`,`hair_color`,`gender`,`class`,`lv`,`exp`,`exp_payper`,`online`,`position`,`rsv1`,`rsv2`,`name`) "
-                         "VALUES ('%d','%d','%d','%d','%d', '%d','%d','%d','%d','%d','%d','%d','%d','%d','%s')",
-                         guild_member_db, g->guild_id,
-                         m->account_id, m->char_id,
-                         m->hair, m->hair_color, m->gender,
-                         m->class, m->lv, m->exp, m->exp_payper, m->online,
-                         m->position, 0, 0, jstrescapecpy (t_member,
-                                                           m->name));
-                //printf(" %s\n",tmp_sql);
-                if (mysql_query (&mysql_handle, tmp_sql))
-                {
-                    printf ("DB server Error (insert `guild_member`)- %s\n",
-                            mysql_error (&mysql_handle));
-                }
-                sprintf (tmp_sql,
-                         "UPDATE `%s` SET `guild_id`='%d' WHERE `account_id`='%d' AND `char_id`='%d'",
-                         char_db, g->guild_id, m->account_id, m->char_id);
-                if (mysql_query (&mysql_handle, tmp_sql))
-                {
-                    printf ("DB server Error (update `char`)- %s\n",
-                            mysql_error (&mysql_handle));
-                }
-            }
-        }
-    }
-
-    if (flag & 4 || guild_member == 0)
-    {
-        //printf("- Insert guild %d to guild_position\n",g->guild_id);
-        for (i = 0; i < MAX_GUILDPOSITION; i++)
-        {
-            struct guild_position *p = &g->position[i];
-            sprintf (tmp_sql,
-                     "INSERT INTO `%s` (`guild_id`,`position`,`name`,`mode`,`exp_mode`) VALUES ('%d','%d', '%s','%d','%d')",
-                     guild_position_db, g->guild_id, i,
-                     jstrescapecpy (t_position, p->name), p->mode,
-                     p->exp_mode);
-            //printf(" %s\n",tmp_sql);
-            if (mysql_query (&mysql_handle, tmp_sql))
-            {
-                printf ("DB server Error (insert `guild_position`)- %s\n",
-                        mysql_error (&mysql_handle));
-            }
-        }
-    }
-
-    if (flag & 8 || guild_member == 0)
-    {
-        //printf("- Insert guild %d to guild_alliance\n",g->guild_id);
-        for (i = 0; i < MAX_GUILDALLIANCE; i++)
-        {
-            struct guild_alliance *a = &g->alliance[i];
-            if (a->guild_id > 0)
-            {
-                sprintf (tmp_sql,
-                         "INSERT INTO `%s` (`guild_id`,`opposition`,`alliance_id`,`name`) "
-                         "VALUES ('%d','%d','%d','%s')", guild_alliance_db,
-                         g->guild_id, a->opposition, a->guild_id,
-                         jstrescapecpy (t_alliance, a->name));
-                //printf(" %s\n",tmp_sql);
-                if (mysql_query (&mysql_handle, tmp_sql))
-                {
-                    printf ("DB server Error (insert `guild_alliance`)- %s\n",
-                            mysql_error (&mysql_handle));
-                }
-                sprintf (tmp_sql,
-                         "INSERT INTO `%s` (`guild_id`,`opposition`,`alliance_id`,`name`) "
-                         "VALUES ('%d','%d','%d','%s')", guild_alliance_db,
-                         a->guild_id, a->opposition, g->guild_id, t_name);
-                //printf(" %s\n",tmp_sql);
-                if (mysql_query (&mysql_handle, tmp_sql))
-                {
-                    printf ("DB server Error (insert `guild_alliance`)- %s\n",
-                            mysql_error (&mysql_handle));
-                }
-            }
-        }
-    }
-
-    if (flag & 16 || guild_member == 0)
-    {
-        //printf("- Insert guild %d to guild_expulsion\n",g->guild_id);
-        for (i = 0; i < MAX_GUILDEXPLUSION; i++)
-        {
-            struct guild_explusion *e = &g->explusion[i];
-            if (e->account_id > 0)
-            {
-                sprintf (tmp_sql,
-                         "INSERT INTO `%s` (`guild_id`,`name`,`mes`,`acc`,`account_id`,`rsv1`,`rsv2`,`rsv3`) "
-                         "VALUES ('%d','%s','%s','%s','%d','%d','%d','%d')",
-                         guild_expulsion_db, g->guild_id,
-                         jstrescapecpy (t_ename, e->name),
-                         jstrescapecpy (t_emes, e->mes), e->acc,
-                         e->account_id, e->rsv1, e->rsv2, e->rsv3);
-                //printf(" %s\n",tmp_sql);
-                if (mysql_query (&mysql_handle, tmp_sql))
-                {
-                    printf
-                        ("DB server Error (insert `guild_expulsion`)- %s\n",
-                         mysql_error (&mysql_handle));
-                }
-            }
-        }
-    }
-
-    if (flag & 32 || guild_member == 0)
-    {
-        //printf("- Insert guild %d to guild_skill\n",g->guild_id);
-        for (i = 0; i < MAX_GUILDSKILL; i++)
-        {
-            if (g->skill[i].id > 0)
-            {
-                sprintf (tmp_sql,
-                         "INSERT INTO `%s` (`guild_id`,`id`,`lv`) VALUES ('%d','%d','%d')",
-                         guild_skill_db, g->guild_id, g->skill[i].id,
-                         g->skill[i].lv);
-                //printf("%s\n",tmp_sql);
-                if (mysql_query (&mysql_handle, tmp_sql))
-                {
-                    printf ("DB server Error (insert `guild_skill`)- %s\n",
-                            mysql_error (&mysql_handle));
-                }
-            }
-        }
-    }
-
-    printf ("Save guild done\n");
-    return 0;
-}
-
-// Read guild from sql
-int inter_guild_fromsql (int guild_id, struct guild *g)
-{
-    int  i;
-    char emblem_data[4096];
-    char *pstr;
-
-    if (g == NULL)
-        return 0;
-    memset (g, 0, sizeof (struct guild));
-    if (guild_id == 0)
-        return 0;
-
-//  printf("Retrieve guild information from sql ......\n");
-//  printf("- Read guild %d from sql \n",guild_id);
-
-    sprintf (tmp_sql,
-             "SELECT `guild_id`, `name`,`master`,`guild_lv`,`connect_member`,`max_member`,`average_lv`,`exp`,`next_exp`,`skill_point`,`castle_id`,`mes1`,`mes2`,`emblem_len`,`emblem_id`,`emblem_data` "
-             "FROM `%s` WHERE `guild_id`='%d'", guild_db, guild_id);
-    //printf("  %s\n",tmp_sql);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (select `guild`)- %s\n",
-                mysql_error (&mysql_handle));
-        return 0;
-    }
-
-    sql_res = mysql_store_result (&mysql_handle);
-    if (sql_res != NULL && mysql_num_rows (sql_res) > 0)
-    {
-        sql_row = mysql_fetch_row (sql_res);
-        if (sql_row == NULL)
-        {
-            mysql_free_result (sql_res);
-            return 0;
-        }
-
-        g->guild_id = atoi (sql_row[0]);
-        strncpy (g->name, sql_row[1], 24);
-        strncpy (g->master, sql_row[2], 24);
-        g->guild_lv = atoi (sql_row[3]);
-        g->connect_member = atoi (sql_row[4]);
-        g->max_member = atoi (sql_row[5]);
-        g->average_lv = atoi (sql_row[6]);
-        g->exp = atoi (sql_row[7]);
-        g->next_exp = atoi (sql_row[8]);
-        g->skill_point = atoi (sql_row[9]);
-        g->castle_id = atoi (sql_row[10]);
-        strncpy (g->mes1, sql_row[11], 60);
-        strncpy (g->mes2, sql_row[12], 120);
-        g->emblem_len = atoi (sql_row[13]);
-        g->emblem_id = atoi (sql_row[14]);
-        strncpy (emblem_data, sql_row[15], 4096);
-        for (i = 0, pstr = emblem_data; i < g->emblem_len; i++, pstr += 2)
-        {
-            int  c1 = pstr[0], c2 = pstr[1], x1 = 0, x2 = 0;
-            if (c1 >= '0' && c1 <= '9')
-                x1 = c1 - '0';
-            if (c1 >= 'a' && c1 <= 'f')
-                x1 = c1 - 'a' + 10;
-            if (c1 >= 'A' && c1 <= 'F')
-                x1 = c1 - 'A' + 10;
-            if (c2 >= '0' && c2 <= '9')
-                x2 = c2 - '0';
-            if (c2 >= 'a' && c2 <= 'f')
-                x2 = c2 - 'a' + 10;
-            if (c2 >= 'A' && c2 <= 'F')
-                x2 = c2 - 'A' + 10;
-            g->emblem_data[i] = (x1 << 4) | x2;
-        }
-    }
-    mysql_free_result (sql_res);
-
-    //printf("- Read guild_member %d from sql \n",guild_id);
-    sprintf (tmp_sql,
-             "SELECT `guild_id`,`account_id`,`char_id`,`hair`,`hair_color`,`gender`,`class`,`lv`,`exp`,`exp_payper`,`online`,`position`,`rsv1`,`rsv2`,`name` "
-             "FROM `%s` WHERE `guild_id`='%d'  ORDER BY `position`",
-             guild_member_db, guild_id);
-    //printf("  %s\n",tmp_sql);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (select `guild_member`)- %s\n",
-                mysql_error (&mysql_handle));
-        return 0;
-    }
-    sql_res = mysql_store_result (&mysql_handle);
-    if (sql_res != NULL && mysql_num_rows (sql_res) > 0)
-    {
-        int  i;
-        for (i = 0;
-             ((sql_row = mysql_fetch_row (sql_res)) && i < g->max_member);
-             i++)
-        {
-            struct guild_member *m = &g->member[i];
-            m->account_id = atoi (sql_row[1]);
-            m->char_id = atoi (sql_row[2]);
-            m->hair = atoi (sql_row[3]);
-            m->hair_color = atoi (sql_row[4]);
-            m->gender = atoi (sql_row[5]);
-            m->class = atoi (sql_row[6]);
-            m->lv = atoi (sql_row[7]);
-            m->exp = atoi (sql_row[8]);
-            m->exp_payper = atoi (sql_row[9]);
-            m->online = atoi (sql_row[10]);
-            m->position = atoi (sql_row[11]);
-            strncpy (m->name, sql_row[14], 24);
-        }
-    }
-    mysql_free_result (sql_res);
-
-    //printf("- Read guild_position %d from sql \n",guild_id);
-    sprintf (tmp_sql,
-             "SELECT `guild_id`,`position`,`name`,`mode`,`exp_mode` FROM `%s` WHERE `guild_id`='%d'",
-             guild_position_db, guild_id);
-    //printf("  %s\n",tmp_sql);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (select `guild_position`)- %s\n",
-                mysql_error (&mysql_handle));
-        return 0;
-    }
-    sql_res = mysql_store_result (&mysql_handle);
-    if (sql_res != NULL && mysql_num_rows (sql_res) > 0)
-    {
-        int  i;
-        for (i = 0;
-             ((sql_row = mysql_fetch_row (sql_res)) && i < MAX_GUILDPOSITION);
-             i++)
-        {
-            int  position = atoi (sql_row[1]);
-            struct guild_position *p = &g->position[position];
-            strncpy (p->name, sql_row[2], 24);
-            p->mode = atoi (sql_row[3]);
-            p->exp_mode = atoi (sql_row[4]);
-        }
-    }
-    mysql_free_result (sql_res);
-
-    //printf("- Read guild_alliance %d from sql \n",guild_id);
-    sprintf (tmp_sql,
-             "SELECT `guild_id`,`opposition`,`alliance_id`,`name` FROM `%s` WHERE `guild_id`='%d'",
-             guild_alliance_db, guild_id);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (select `guild_alliance`)- %s\n",
-                mysql_error (&mysql_handle));
-        return 0;
-    }
-    sql_res = mysql_store_result (&mysql_handle);
-    if (sql_res != NULL && mysql_num_rows (sql_res) > 0)
-    {
-        int  i;
-        for (i = 0;
-             ((sql_row = mysql_fetch_row (sql_res)) && i < MAX_GUILDALLIANCE);
-             i++)
-        {
-            struct guild_alliance *a = &g->alliance[i];
-            a->opposition = atoi (sql_row[1]);
-            a->guild_id = atoi (sql_row[2]);
-            strncpy (a->name, sql_row[3], 24);
-        }
-    }
-    mysql_free_result (sql_res);
-
-    //printf("- Read guild_expulsion %d from sql \n",guild_id);
-    sprintf (tmp_sql,
-             "SELECT `guild_id`,`name`,`mes`,`acc`,`account_id`,`rsv1`,`rsv2`,`rsv3` FROM `%s` WHERE `guild_id`='%d'",
-             guild_expulsion_db, guild_id);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (select `guild_expulsion`)- %s\n",
-                mysql_error (&mysql_handle));
-        return 0;
-    }
-    sql_res = mysql_store_result (&mysql_handle);
-    if (sql_res != NULL && mysql_num_rows (sql_res) > 0)
-    {
-        int  i;
-        for (i = 0;
-             ((sql_row = mysql_fetch_row (sql_res))
-              && i < MAX_GUILDEXPLUSION); i++)
-        {
-            struct guild_explusion *e = &g->explusion[i];
-
-            strncpy (e->name, sql_row[1], 24);
-            strncpy (e->mes, sql_row[2], 40);
-            strncpy (e->acc, sql_row[3], 24);
-            e->account_id = atoi (sql_row[4]);
-            e->rsv1 = atoi (sql_row[5]);
-            e->rsv2 = atoi (sql_row[6]);
-            e->rsv3 = atoi (sql_row[7]);
-
-        }
-    }
-    mysql_free_result (sql_res);
-
-    //printf("- Read guild_skill %d from sql \n",guild_id);
-    sprintf (tmp_sql,
-             "SELECT `guild_id`,`id`,`lv` FROM `%s` WHERE `guild_id`='%d' ORDER BY `id`",
-             guild_skill_db, guild_id);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (select `guild_skill`)- %s\n",
-                mysql_error (&mysql_handle));
-        return 0;
-    }
-    sql_res = mysql_store_result (&mysql_handle);
-    if (sql_res != NULL && mysql_num_rows (sql_res) > 0)
-    {
-        int  i;
-        for (i = 0;
-             ((sql_row = mysql_fetch_row (sql_res)) && i < MAX_GUILDSKILL);
-             i++)
-        {
-            g->skill[i].id = atoi (sql_row[1]);
-            g->skill[i].lv = atoi (sql_row[2]);
-        }
-    }
-    mysql_free_result (sql_res);
-
-//  printf("Successfully retrieve guild information from sql!\n");
-
-    return 0;
-
-}
-
-// Save guild_castle to sql
-int inter_guildcastle_tosql (struct guild_castle *gc)
-{
-    // `guild_castle` (`castle_id`, `guild_id`, `economy`, `defense`, `triggerE`, `triggerD`, `nextTime`, `payTime`, `createTime`, `visibleC`, `visibleG0`, `visibleG1`, `visibleG2`, `visibleG3`, `visibleG4`, `visibleG5`, `visibleG6`, `visibleG7`)
-
-    if (gc == NULL)
-        return 0;
-    //printf("Save to guild_castle\n");
-    sprintf (tmp_sql, "DELETE FROM `%s` WHERE `castle_id`='%d'",
-             guild_castle_db, gc->castle_id);
-    //printf(" %s\n",tmp_sql);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error - %s\n", mysql_error (&mysql_handle));
-        return 0;
-    }
-
-    sprintf (tmp_sql, "INSERT INTO `%s` "
-             "(`castle_id`, `guild_id`, `economy`, `defense`, `triggerE`, `triggerD`, `nextTime`, `payTime`, `createTime`,"
-             "`visibleC`, `visibleG0`, `visibleG1`, `visibleG2`, `visibleG3`, `visibleG4`, `visibleG5`, `visibleG6`, `visibleG7`,"
-             "`Ghp0`, `Ghp1`, `Ghp2`, `Ghp3`, `Ghp4`, `Ghp5`, `Ghp6`, `Ghp7`)"
-             "VALUES ('%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d')",
-             guild_castle_db, gc->castle_id, gc->guild_id, gc->economy,
-             gc->defense, gc->triggerE, gc->triggerD, gc->nextTime,
-             gc->payTime, gc->createTime, gc->visibleC, gc->visibleG0,
-             gc->visibleG1, gc->visibleG2, gc->visibleG3, gc->visibleG4,
-             gc->visibleG5, gc->visibleG6, gc->visibleG7, gc->Ghp0, gc->Ghp1,
-             gc->Ghp2, gc->Ghp3, gc->Ghp4, gc->Ghp5, gc->Ghp6, gc->Ghp7);
-    //printf(" %s\n",tmp_sql);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error - %s\n", mysql_error (&mysql_handle));
-        return 0;
-    }
-
-    sprintf (tmp_sql,
-             "UPDATE `%s` SET `castle_id`='-1' WHERE `castle_id`='%d'",
-             guild_db, gc->castle_id);
-    //printf(" %s\n",tmp_sql);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error - %s\n", mysql_error (&mysql_handle));
-        return 0;
-    }
-
-    sprintf (tmp_sql,
-             "UPDATE `%s` SET `castle_id`='%d' WHERE `guild_id`='%d'",
-             guild_db, gc->castle_id, gc->guild_id);
-    //printf(" %s\n",tmp_sql);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error - %s\n", mysql_error (&mysql_handle));
-        return 0;
-    }
-
-    return 0;
-}
-
-// Read guild_castle from sql
-int inter_guildcastle_fromsql (int castle_id, struct guild_castle *gc)
-{
-
-    if (gc == NULL)
-        return 0;
-    //printf("Read from guild_castle\n");
-    memset (gc, 0, sizeof (struct guild_castle));
-    gc->castle_id = castle_id;
-    if (castle_id == -1)
-        return 0;
-    sprintf (tmp_sql,
-             "SELECT `castle_id`, `guild_id`, `economy`, `defense`, `triggerE`, `triggerD`, `nextTime`, `payTime`, `createTime`, "
-             "`visibleC`, `visibleG0`, `visibleG1`, `visibleG2`, `visibleG3`, `visibleG4`, `visibleG5`, `visibleG6`, `visibleG7`,"
-             "`Ghp0`, `Ghp1`, `Ghp2`, `Ghp3`, `Ghp4`, `Ghp5`, `Ghp6`, `Ghp7`"
-             " FROM `%s` WHERE `castle_id`='%d'", guild_castle_db, castle_id);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error - %s\n", mysql_error (&mysql_handle));
-        return 0;
-    }
-    sql_res = mysql_store_result (&mysql_handle);
-    if (sql_res != NULL && mysql_num_rows (sql_res) > 0)
-    {
-        sql_row = mysql_fetch_row (sql_res);
-        if (sql_row == NULL)
-        {
-            mysql_free_result (sql_res);
-            return 0;
-        }
-
-        gc->guild_id = atoi (sql_row[1]);
-        gc->economy = atoi (sql_row[2]);
-        gc->defense = atoi (sql_row[3]);
-        gc->triggerE = atoi (sql_row[4]);
-        gc->triggerD = atoi (sql_row[5]);
-        gc->nextTime = atoi (sql_row[6]);
-        gc->payTime = atoi (sql_row[7]);
-        gc->createTime = atoi (sql_row[8]);
-        gc->visibleC = atoi (sql_row[9]);
-        gc->visibleG0 = atoi (sql_row[10]);
-        gc->visibleG1 = atoi (sql_row[11]);
-        gc->visibleG2 = atoi (sql_row[12]);
-        gc->visibleG3 = atoi (sql_row[13]);
-        gc->visibleG4 = atoi (sql_row[14]);
-        gc->visibleG5 = atoi (sql_row[15]);
-        gc->visibleG6 = atoi (sql_row[16]);
-        gc->visibleG7 = atoi (sql_row[17]);
-        gc->Ghp0 = atoi (sql_row[18]);
-        gc->Ghp1 = atoi (sql_row[19]);
-        gc->Ghp2 = atoi (sql_row[20]);
-        gc->Ghp3 = atoi (sql_row[21]);
-        gc->Ghp4 = atoi (sql_row[22]);
-        gc->Ghp5 = atoi (sql_row[23]);
-        gc->Ghp6 = atoi (sql_row[24]);
-        gc->Ghp7 = atoi (sql_row[25]);
-
-        //printf("Read Castle %d of guild %d from sql \n",castle_id,gc->guild_id);
-
-    }
-    mysql_free_result (sql_res);    //resource free
-    return 0;
-}
-
-// Read exp_guild.txt
-int inter_guild_readdb ()
-{
-    int  i;
-    FILE *fp;
-    char line[1024];
-    for (i = 0; i < 100; i++)
-        guild_exp[i] = 0;
-
-    fp = fopen_ ("db/exp_guild.txt", "r");
-    if (fp == NULL)
-    {
-        printf ("can't read db/exp_guild.txt\n");
-        return 1;
-    }
-    i = 0;
-    while (fgets (line, 256, fp) && i < 100)
-    {
-        if (line[0] == '/' && line[1] == '/')
-            continue;
-        guild_exp[i] = atoi (line);
-        i++;
-    }
-    fclose_ (fp);
-
-    return 0;
-}
-
-// Initialize guild sql
-int inter_guild_sql_init ()
-{
-    int  i;
-
-    printf ("interserver guild memory initialize.... (%d byte)\n",
-            sizeof (struct guild));
-    guild_pt = calloc (sizeof (struct guild), 1);
-    guild_pt2 = calloc (sizeof (struct guild), 1);
-    guildcastle_pt = calloc (sizeof (struct guild_castle), 1);
-
-    inter_guild_readdb ();      // Read exp
-
-    sprintf (tmp_sql, "UPDATE `%s` SET `online`='0'", guild_member_db);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (update `char`)- %s\n",
-                mysql_error (&mysql_handle));
-        exit (0);
-    }
-
-    sprintf (tmp_sql, "SELECT count(*) FROM `%s`", guild_db);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error - %s\n", mysql_error (&mysql_handle));
-        exit (0);
-    }
-    sql_res = mysql_store_result (&mysql_handle);
-    sql_row = mysql_fetch_row (sql_res);
-    printf ("total guild data -> '%s'.......\n", sql_row[0]);
-    i = atoi (sql_row[0]);
-    mysql_free_result (sql_res);
-
-    if (i > 0)
-    {
-        //set party_newid
-        sprintf (tmp_sql, "SELECT max(`guild_id`) FROM `%s`", guild_db);
-        if (mysql_query (&mysql_handle, tmp_sql))
-        {
-            printf ("DB server Error - %s\n", mysql_error (&mysql_handle));
-            exit (0);
-        }
-
-        sql_res = mysql_store_result (&mysql_handle);
-        sql_row = mysql_fetch_row (sql_res);
-        guild_newid = atoi (sql_row[0]) + 1;
-        mysql_free_result (sql_res);
-    }
-
-    printf ("set guild_newid: %d.......\n", guild_newid);
-
-    return 0;
-}
-
-// Get guild by its name
-struct guild *search_guildname (char *str)
-{
-    struct guild *g = guild_pt;
-    char t_name[24];
-    int  guild_id = 0;
-    printf ("search_guildname\n");
-    sprintf (tmp_sql, "SELECT `guild_id` FROM `%s` WHERE `name`='%s'",
-             guild_db, jstrescapecpy (t_name, str));
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error - %s\n", mysql_error (&mysql_handle));
-    }
-    sql_res = mysql_store_result (&mysql_handle);
-    if (sql_res != NULL && mysql_num_rows (sql_res) > 0)
-    {
-        sql_row = mysql_fetch_row (sql_res);
-        guild_id = atoi (sql_row[0]);
-    }
-    mysql_free_result (sql_res);
-    inter_guild_fromsql (guild_id, g);
-    return g;
-}
-
-// Check if guild is empty
-int guild_check_empty (struct guild *g)
-{
-    int  i;
-    for (i = 0; i < g->max_member; i++)
-    {
-        if (g->member[i].account_id > 0)
-        {
-            return 0;
-        }
-    }
-
-    // 誰もいないので解散
-    mapif_guild_broken (g->guild_id, 0);
-    inter_guild_storage_delete (g->guild_id);
-    inter_guild_tosql (g, 255);
-    memset (g, 0, sizeof (struct guild));
-    return 1;
-}
-
-int guild_nextexp (int level)
-{
-    if (level < 100 && level > 0)   // Change by hack
-        return guild_exp[level - 1];
-
-    return 0;
-}
-
-// ギルドスキルがあるか確認
-int guild_checkskill (struct guild *g, int id)
-{
-    return g->skill[id - 10000].lv;
-}
-
-// ギルドの情報の再計算
-int guild_calcinfo (struct guild *g)
-{
-    int  i, c, nextexp;
-    struct guild before = *g;
-
-    // スキルIDの設定
-    for (i = 0; i < 5; i++)
-        g->skill[i].id = i + 10000;
-
-    // ギルドレベル
-    if (g->guild_lv <= 0)
-        g->guild_lv = 1;
-    nextexp = guild_nextexp (g->guild_lv);
-    if (nextexp > 0)
-    {
-        while (g->exp >= nextexp && nextexp > 0)
-        {                       // Change by hack
-            g->exp -= nextexp;
-            g->guild_lv++;
-            g->skill_point++;
-            nextexp = guild_nextexp (g->guild_lv);
-        }
-    }
-
-    // ギルドの次の経験値
-    g->next_exp = guild_nextexp (g->guild_lv);
-
-    // メンバ上限（ギルド拡張適用）
-    g->max_member = 100 + guild_checkskill (g, 10004) * 2;   // Updated max_members [PoW]
-
-    // 平均レベルとオンライン人数
-    g->average_lv = 0;
-    g->connect_member = 0;
-    for (i = c = 0; i < g->max_member; i++)
-    {
-        if (g->member[i].account_id > 0)
-        {
-            g->average_lv += g->member[i].lv;
-            c++;
-
-            if (g->member[i].online > 0)
-                g->connect_member++;
-        }
-    }
-    g->average_lv /= c;
-
-    // 全データを送る必要がありそう
-    if (g->max_member != before.max_member ||
-        g->guild_lv != before.guild_lv ||
-        g->skill_point != before.skill_point)
-    {
-        mapif_guild_info (-1, g);
-        return 1;
-    }
-
-    return 0;
-}
-
-//-------------------------------------------------------------------
-// map serverへの通信
-
-// ギルド作成可否
-int mapif_guild_created (int fd, int account_id, struct guild *g)
-{
-    WFIFOW (fd, 0) = 0x3830;
-    WFIFOL (fd, 2) = account_id;
-    if (g != NULL)
-    {
-        WFIFOL (fd, 6) = g->guild_id;
-        printf ("int_guild: created! %d %s\n", g->guild_id, g->name);
-    }
-    else
-    {
-        WFIFOL (fd, 6) = 0;
-    }
-    WFIFOSET (fd, 10);
-    return 0;
-}
-
-// ギルド情報見つからず
-int mapif_guild_noinfo (int fd, int guild_id)
-{
-    WFIFOW (fd, 0) = 0x3831;
-    WFIFOW (fd, 2) = 8;
-    WFIFOL (fd, 4) = guild_id;
-    WFIFOSET (fd, 8);
-    printf ("int_guild: info not found %d\n", guild_id);
-    return 0;
-}
-
-// ギルド情報まとめ送り
-int mapif_guild_info (int fd, struct guild *g)
-{
-    unsigned char buf[16384];
-    WBUFW (buf, 0) = 0x3831;
-    memcpy (buf + 4, g, sizeof (struct guild));
-    WBUFW (buf, 2) = 4 + sizeof (struct guild);
-//  printf("int_guild: sizeof(guild)=%d\n",sizeof(struct guild));
-    if (fd < 0)
-        mapif_sendall (buf, WBUFW (buf, 2));
-    else
-        mapif_send (fd, buf, WBUFW (buf, 2));
-//  printf("int_guild: info %d %s\n",p->guild_id,p->name);
-    return 0;
-}
-
-// メンバ追加可否
-int mapif_guild_memberadded (int fd, int guild_id, int account_id,
-                             int char_id, int flag)
-{
-    WFIFOW (fd, 0) = 0x3832;
-    WFIFOL (fd, 2) = guild_id;
-    WFIFOL (fd, 6) = account_id;
-    WFIFOL (fd, 10) = char_id;
-    WFIFOB (fd, 14) = flag;
-    WFIFOSET (fd, 15);
-    return 0;
-}
-
-// 脱退/追放通知
-int mapif_guild_leaved (int guild_id, int account_id, int char_id, int flag,
-                        const char *name, const char *mes)
-{
-    unsigned char buf[128];
-    WBUFW (buf, 0) = 0x3834;
-    WBUFL (buf, 2) = guild_id;
-    WBUFL (buf, 6) = account_id;
-    WBUFL (buf, 10) = char_id;
-    WBUFB (buf, 14) = flag;
-    memcpy (WBUFP (buf, 15), mes, 40);
-    memcpy (WBUFP (buf, 55), name, 24);
-    mapif_sendall (buf, 79);
-    printf ("int_guild: guild leaved %d %d %s %s\n", guild_id, account_id,
-            name, mes);
-    return 0;
-}
-
-// オンライン状態とLv更新通知
-int mapif_guild_memberinfoshort (struct guild *g, int idx)
-{
-    unsigned char buf[32];
-    WBUFW (buf, 0) = 0x3835;
-    WBUFL (buf, 2) = g->guild_id;
-    WBUFL (buf, 6) = g->member[idx].account_id;
-    WBUFL (buf, 10) = g->member[idx].char_id;
-    WBUFB (buf, 14) = g->member[idx].online;
-    WBUFW (buf, 15) = g->member[idx].lv;
-    WBUFW (buf, 17) = g->member[idx].class;
-    mapif_sendall (buf, 19);
-    return 0;
-}
-
-// 解散通知
-int mapif_guild_broken (int guild_id, int flag)
-{
-    unsigned char buf[16];
-    WBUFW (buf, 0) = 0x3836;
-    WBUFL (buf, 2) = guild_id;
-    WBUFB (buf, 6) = flag;
-    mapif_sendall (buf, 7);
-    printf ("int_guild: broken %d\n", guild_id);
-    return 0;
-}
-
-// ギルド内発言
-int mapif_guild_message (int guild_id, int account_id, char *mes, int len)
-{
-    unsigned char buf[512];
-    WBUFW (buf, 0) = 0x3837;
-    WBUFW (buf, 2) = len + 12;
-    WBUFL (buf, 4) = guild_id;
-    WBUFL (buf, 8) = account_id;
-    memcpy (WBUFP (buf, 12), mes, len);
-    mapif_sendall (buf, len + 12);
-    return 0;
-}
-
-// ギルド基本情報変更通知
-int mapif_guild_basicinfochanged (int guild_id, int type, const void *data,
-                                  int len)
-{
-    unsigned char buf[2048];
-    WBUFW (buf, 0) = 0x3839;
-    WBUFW (buf, 2) = len + 10;
-    WBUFL (buf, 4) = guild_id;
-    WBUFW (buf, 8) = type;
-    memcpy (WBUFP (buf, 10), data, len);
-    mapif_sendall (buf, len + 10);
-    return 0;
-}
-
-// ギルドメンバ情報変更通知
-int mapif_guild_memberinfochanged (int guild_id, int account_id, int char_id,
-                                   int type, const void *data, int len)
-{
-    unsigned char buf[2048];
-    WBUFW (buf, 0) = 0x383a;
-    WBUFW (buf, 2) = len + 18;
-    WBUFL (buf, 4) = guild_id;
-    WBUFL (buf, 8) = account_id;
-    WBUFL (buf, 12) = char_id;
-    WBUFW (buf, 16) = type;
-    memcpy (WBUFP (buf, 18), data, len);
-    mapif_sendall (buf, len + 18);
-    return 0;
-}
-
-// ギルドスキルアップ通知
-int mapif_guild_skillupack (int guild_id, int skill_num, int account_id)
-{
-    unsigned char buf[16];
-    WBUFW (buf, 0) = 0x383c;
-    WBUFL (buf, 2) = guild_id;
-    WBUFL (buf, 6) = skill_num;
-    WBUFL (buf, 10) = account_id;
-    mapif_sendall (buf, 14);
-    return 0;
-}
-
-// ギルド同盟/敵対通知
-int mapif_guild_alliance (int guild_id1, int guild_id2, int account_id1,
-                          int account_id2, int flag, const char *name1,
-                          const char *name2)
-{
-    unsigned char buf[128];
-    WBUFW (buf, 0) = 0x383d;
-    WBUFL (buf, 2) = guild_id1;
-    WBUFL (buf, 6) = guild_id2;
-    WBUFL (buf, 10) = account_id1;
-    WBUFL (buf, 14) = account_id2;
-    WBUFB (buf, 18) = flag;
-    memcpy (WBUFP (buf, 19), name1, 24);
-    memcpy (WBUFP (buf, 43), name2, 24);
-    mapif_sendall (buf, 67);
-    return 0;
-}
-
-// ギルド役職変更通知
-int mapif_guild_position (struct guild *g, int idx)
-{
-    unsigned char buf[128];
-    WBUFW (buf, 0) = 0x383b;
-    WBUFW (buf, 2) = sizeof (struct guild_position) + 12;
-    WBUFL (buf, 4) = g->guild_id;
-    WBUFL (buf, 8) = idx;
-    memcpy (WBUFP (buf, 12), &g->position[idx],
-            sizeof (struct guild_position));
-    mapif_sendall (buf, WBUFW (buf, 2));
-    return 0;
-}
-
-// ギルド告知変更通知
-int mapif_guild_notice (struct guild *g)
-{
-    unsigned char buf[256];
-    WBUFW (buf, 0) = 0x383e;
-    WBUFL (buf, 2) = g->guild_id;
-    memcpy (WBUFP (buf, 6), g->mes1, 60);
-    memcpy (WBUFP (buf, 66), g->mes2, 120);
-    mapif_sendall (buf, 186);
-    return 0;
-}
-
-// ギルドエンブレム変更通知
-int mapif_guild_emblem (struct guild *g)
-{
-    unsigned char buf[2048];
-    WBUFW (buf, 0) = 0x383f;
-    WBUFW (buf, 2) = g->emblem_len + 12;
-    WBUFL (buf, 4) = g->guild_id;
-    WBUFL (buf, 8) = g->emblem_id;
-    memcpy (WBUFP (buf, 12), g->emblem_data, g->emblem_len);
-    mapif_sendall (buf, WBUFW (buf, 2));
-    return 0;
-}
-
-int mapif_guild_castle_dataload (int castle_id, int index, int value)   // <Agit>
-{
-    unsigned char buf[16];
-    WBUFW (buf, 0) = 0x3840;
-    WBUFW (buf, 2) = castle_id;
-    WBUFB (buf, 4) = index;
-    WBUFL (buf, 5) = value;
-    mapif_sendall (buf, 9);
-    return 0;
-}
-
-int mapif_guild_castle_datasave (int castle_id, int index, int value)   // <Agit>
-{
-    unsigned char buf[16];
-    WBUFW (buf, 0) = 0x3841;
-    WBUFW (buf, 2) = castle_id;
-    WBUFB (buf, 4) = index;
-    WBUFL (buf, 5) = value;
-    mapif_sendall (buf, 9);
-    return 0;
-}
-
-int mapif_guild_castle_alldataload (int fd)
-{
-    struct guild_castle *gc = guildcastle_pt;
-    int  i, len = 4;
-
-    WFIFOW (fd, 0) = 0x3842;
-    sprintf (tmp_sql, "SELECT * FROM `%s` ORDER BY `castle_id`",
-             guild_castle_db);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error - %s\n", mysql_error (&mysql_handle));
-    }
-    sql_res = mysql_store_result (&mysql_handle);
-    if (sql_res != NULL && mysql_num_rows (sql_res) > 0)
-    {
-        for (i = 0;
-             ((sql_row = mysql_fetch_row (sql_res)) && i < MAX_GUILDCASTLE);
-             i++)
-        {
-            memset (gc, 0, sizeof (struct guild_castle));
-            gc->castle_id = atoi (sql_row[0]);
-            gc->guild_id = atoi (sql_row[1]);
-            gc->economy = atoi (sql_row[2]);
-            gc->defense = atoi (sql_row[3]);
-            gc->triggerE = atoi (sql_row[4]);
-            gc->triggerD = atoi (sql_row[5]);
-            gc->nextTime = atoi (sql_row[6]);
-            gc->payTime = atoi (sql_row[7]);
-            gc->createTime = atoi (sql_row[8]);
-            gc->visibleC = atoi (sql_row[9]);
-            gc->visibleG0 = atoi (sql_row[10]);
-            gc->visibleG1 = atoi (sql_row[11]);
-            gc->visibleG2 = atoi (sql_row[12]);
-            gc->visibleG3 = atoi (sql_row[13]);
-            gc->visibleG4 = atoi (sql_row[14]);
-            gc->visibleG5 = atoi (sql_row[15]);
-            gc->visibleG6 = atoi (sql_row[16]);
-            gc->visibleG7 = atoi (sql_row[17]);
-            gc->Ghp0 = atoi (sql_row[18]);
-            gc->Ghp1 = atoi (sql_row[19]);
-            gc->Ghp2 = atoi (sql_row[20]);
-            gc->Ghp3 = atoi (sql_row[21]);
-            gc->Ghp4 = atoi (sql_row[22]);
-            gc->Ghp5 = atoi (sql_row[23]);
-            gc->Ghp6 = atoi (sql_row[24]);
-            gc->Ghp7 = atoi (sql_row[25]);
-            memcpy (WFIFOP (fd, len), gc, sizeof (struct guild_castle));
-            len += sizeof (struct guild_castle);
-        }
-    }
-    mysql_free_result (sql_res);
-    WFIFOW (fd, 2) = len;
-    WFIFOSET (fd, len);
-
-    return 0;
-}
-
-//-------------------------------------------------------------------
-// map serverからの通信
-
-// ギルド作成要求
-int mapif_parse_CreateGuild (int fd, int account_id, char *name,
-                             struct guild_member *master)
-{
-    struct guild *g;
-    int  i;
-
-    printf ("CreateGuild\n");
-    g = search_guildname (name);
-    if (g != NULL && g->guild_id > 0)
-    {
-        printf ("int_guild: same name guild exists [%s]\n", name);
-        mapif_guild_created (fd, account_id, NULL);
-        return 0;
-    }
-    g = guild_pt;
-    memset (g, 0, sizeof (struct guild));
-    g->guild_id = guild_newid++;
-    memcpy (g->name, name, 24);
-    memcpy (g->master, master->name, 24);
-    memcpy (&g->member[0], master, sizeof (struct guild_member));
-
-    g->position[0].mode = 0x11;
-    strcpy (g->position[0].name, "GuildMaster");
-    strcpy (g->position[MAX_GUILDPOSITION - 1].name, "Newbie");
-    for (i = 1; i < MAX_GUILDPOSITION - 1; i++)
-        sprintf (g->position[i].name, "Position %d", i + 1);
-
-    // Initialize guild property
-    g->max_member = 100;
-    g->average_lv = master->lv;
-    g->castle_id = -1;
-    for (i = 0; i < 5; i++)
-        g->skill[i].id = i + 10000;
-
-    // Save to sql
-    printf ("Create initialize OK!\n");
-    i = inter_guild_tosql (g, 255);
-
-    if (i < 0)
-    {
-        mapif_guild_created (fd, account_id, NULL);
-        return 0;
-    }
-
-    // Report to client
-    mapif_guild_created (fd, account_id, g);
-    mapif_guild_info (fd, g);
-
-    inter_log ("guild %s (id=%d) created by master %s (id=%d)" RETCODE,
-               name, g->guild_id, master->name, master->account_id);
-
-    return 0;
-}
-
-// Return guild info to client
-int mapif_parse_GuildInfo (int fd, int guild_id)
-{
-    struct guild *g;
-    g = guild_pt;
-    inter_guild_fromsql (guild_id, g);
-    if (g != NULL && g->guild_id > 0)
-    {
-        guild_calcinfo (g);
-        mapif_guild_info (fd, g);
-        //inter_guild_tosql(g,1); // Change guild
-    }
-    else
-        mapif_guild_noinfo (fd, guild_id);
-    return 0;
-}
-
-// Add member to guild
-int mapif_parse_GuildAddMember (int fd, int guild_id, struct guild_member *m)
-{
-    struct guild *g;
-    int  i;
-    g = guild_pt;
-    inter_guild_fromsql (guild_id, g);
-
-    if (g == NULL || g->guild_id <= 0)
-    {
-        mapif_guild_memberadded (fd, guild_id, m->account_id, m->char_id, 1);
-        return 0;
-    }
-
-    for (i = 0; i < g->max_member; i++)
-    {
-        if (g->member[i].account_id == 0)
-        {
-
-            memcpy (&g->member[i], m, sizeof (struct guild_member));
-            mapif_guild_memberadded (fd, guild_id, m->account_id, m->char_id,
-                                     0);
-            guild_calcinfo (g);
-            mapif_guild_info (-1, g);
-            inter_guild_tosql (g, 3);   // Change guild & guild_member
-            return 0;
-        }
-    }
-    mapif_guild_memberadded (fd, guild_id, m->account_id, m->char_id, 1);
-    //inter_guild_tosql(g,3); // Change guild & guild_member
-    return 0;
-}
-
-// Delete member from guild
-int mapif_parse_GuildLeave (int fd, int guild_id, int account_id, int char_id,
-                            int flag, const char *mes)
-{
-    struct guild *g = NULL;
-    g = guild_pt;
-    inter_guild_fromsql (guild_id, g);
-
-    if (g != NULL && g->guild_id > 0)
-    {
-        int  i;
-        for (i = 0; i < g->max_member; i++)
-        {
-            if (g->member[i].account_id == account_id &&
-                g->member[i].char_id == char_id)
-            {
-                printf ("%d %d\n", i, (int) (&g->member[i]));
-                printf ("%d %s\n", i, g->member[i].name);
-
-                if (flag)
-                {               // 追放の場合追放リストに入れる
-                    int  j;
-                    for (j = 0; j < MAX_GUILDEXPLUSION; j++)
-                    {
-                        if (g->explusion[j].account_id == 0)
-                            break;
-                    }
-                    if (j == MAX_GUILDEXPLUSION)
-                    {           // 一杯なので古いのを消す
-                        for (j = 0; j < MAX_GUILDEXPLUSION - 1; j++)
-                            g->explusion[j] = g->explusion[j + 1];
-                        j = MAX_GUILDEXPLUSION - 1;
-                    }
-                    g->explusion[j].account_id = account_id;
-                    memcpy (g->explusion[j].acc, "dummy", 24);
-                    memcpy (g->explusion[j].name, g->member[i].name, 24);
-                    memcpy (g->explusion[j].mes, mes, 40);
-                }
-
-                mapif_guild_leaved (guild_id, account_id, char_id, flag,
-                                    g->member[i].name, mes);
-                printf ("%d %d\n", i, (int) (&g->member[i]));
-                printf ("%d %s\n", i, (&g->member[i])->name);
-                memset (&g->member[i], 0, sizeof (struct guild_member));
-
-                if (guild_check_empty (g) == 0)
-                    mapif_guild_info (-1, g);   // まだ人がいるのでデータ送信
-                /*
-                 * else
-                 * inter_guild_save();  // 解散したので一応セーブ
-                 * return 0; */
-            }
-        }
-        guild_calcinfo (g);
-        inter_guild_tosql (g, 19);  // Change guild & guild_member & guild_expulsion
-    }
-    else
-    {
-        sprintf (tmp_sql,
-                 "UPDATE `%s` SET `guild_id`='0' WHERE `account_id`='%d' AND `char_id`='%d'",
-                 char_db, account_id, char_id);
-        if (mysql_query (&mysql_handle, tmp_sql))
-        {
-            printf ("DB server Error (update `char`)- %s\n",
-                    mysql_error (&mysql_handle));
-        }
-        /* mapif_guild_leaved(guild_id,account_id,char_id,flag,g->member[i].name,mes);  */
-    }
-
-    return 0;
-}
-
-// Change member info
-int mapif_parse_GuildChangeMemberInfoShort (int fd, int guild_id,
-                                            int account_id, int char_id,
-                                            int online, int lv, int class)
-{
-    // Could speed up by manipulating only guild_member
-    struct guild *g;
-    int  i, alv, c;
-    g = guild_pt;
-    inter_guild_fromsql (guild_id, g);
-
-    if (g == NULL || g->guild_id <= 0)
-    {
-        return 0;
-    }
-
-    g->connect_member = 0;
-
-    for (i = 0, alv = 0, c = 0; i < g->max_member; i++)
-    {
-        if (g->member[i].account_id == account_id &&
-            g->member[i].char_id == char_id)
-        {
-
-            g->member[i].online = online;
-            g->member[i].lv = lv;
-            g->member[i].class = class;
-            mapif_guild_memberinfoshort (g, i);
-        }
-        if (g->member[i].account_id > 0)
-        {
-            alv += g->member[i].lv;
-            c++;
-        }
-        if (g->member[i].online)
-            g->connect_member++;
-    }
-    // 平均レベル
-    g->average_lv = alv / c;
-
-    inter_guild_tosql (g, 3);   // Change guild & guild_member
-
-    return 0;
-}
-
-// BreakGuild
-int mapif_parse_BreakGuild (int fd, int guild_id)
-{
-    struct guild *g;
-    g = guild_pt;
-    inter_guild_fromsql (guild_id, g);
-    if (g == NULL)
-    {
-        return 0;
-    }
-
-    // Delete guild from sql
-    //printf("- Delete guild %d from guild\n",guild_id);
-    sprintf (tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d'", guild_db,
-             guild_id);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (delete `guild`)- %s\n",
-                mysql_error (&mysql_handle));
-    }
-    //printf("- Delete guild %d from guild_member\n",guild_id);
-    sprintf (tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d'",
-             guild_member_db, guild_id);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (delete `guild_member`)- %s\n",
-                mysql_error (&mysql_handle));
-    }
-    //printf("- Delete guild %d from guild_skill\n",guild_id);
-    sprintf (tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d'",
-             guild_skill_db, guild_id);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (delete `guild_skill`)- %s\n",
-                mysql_error (&mysql_handle));
-    }
-    //printf("- Delete guild %d from guild_position\n",guild_id);
-    sprintf (tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d'",
-             guild_position_db, guild_id);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (delete `guild_position`)- %s\n",
-                mysql_error (&mysql_handle));
-    }
-    //printf("- Delete guild %d from guild_expulsion\n",guild_id);
-    sprintf (tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d'",
-             guild_expulsion_db, guild_id);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (delete `guild_expulsion`)- %s\n",
-                mysql_error (&mysql_handle));
-    }
-    //printf("- Delete guild %d from guild_alliance\n",guild_id);
-    sprintf (tmp_sql,
-             "DELETE FROM `%s` WHERE `guild_id`='%d' OR `alliance_id`='%d'",
-             guild_alliance_db, guild_id, guild_id);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (delete `guild_position`)- %s\n",
-                mysql_error (&mysql_handle));
-    }
-
-    //printf("- Delete guild %d from guild_castle\n",guild_id);
-    sprintf (tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d'",
-             guild_castle_db, guild_id);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (delete `guild_position`)- %s\n",
-                mysql_error (&mysql_handle));
-    }
-
-    //printf("- Update guild %d of char\n",guild_id);
-    sprintf (tmp_sql, "UPDATE `%s` SET `guild_id`='0' WHERE `guild_id`='%d'",
-             char_db, guild_id);
-    if (mysql_query (&mysql_handle, tmp_sql))
-    {
-        printf ("DB server Error (delete `guild_position`)- %s\n",
-                mysql_error (&mysql_handle));
-    }
-
-    inter_guild_storage_delete (guild_id);
-    mapif_guild_broken (guild_id, 0);
-
-    inter_log ("guild %s (id=%d) broken" RETCODE, g->name, guild_id);
-
-    return 0;
-}
-
-// ギルドメッセージ送信
-int mapif_parse_GuildMessage (int fd, int guild_id, int account_id, char *mes,
-                              int len)
-{
-    return mapif_guild_message (guild_id, account_id, mes, len);
-}
-
-// ギルド基本データ変更要求
-int mapif_parse_GuildBasicInfoChange (int fd, int guild_id,
-                                      int type, const char *data, int len)
-{
-    struct guild *g;
-//  int dd=*((int *)data);
-    short dw = *((short *) data);
-    g = guild_pt;
-    inter_guild_fromsql (guild_id, g);
-
-    if (g == NULL || g->guild_id <= 0)
-    {
-        return 0;
-    }
-    switch (type)
-    {
-        case GBI_GUILDLV:
-        {
-            printf ("GBI_GUILDLV\n");
-            if (dw > 0 && g->guild_lv + dw <= 50)
-            {
-                g->guild_lv += dw;
-                g->skill_point += dw;
-            }
-            else if (dw < 0 && g->guild_lv + dw >= 1)
-                g->guild_lv += dw;
-            mapif_guild_info (-1, g);
-            inter_guild_tosql (g, 1);
-        }
-            return 0;
-        default:
-            printf ("int_guild: GuildBasicInfoChange: Unknown type %d\n",
-                    type);
-            break;
-    }
-    mapif_guild_basicinfochanged (guild_id, type, data, len);
-    //inter_guild_tosql(g,1); // Change guild
-    return 0;
-}
-
-// ギルドメンバデータ変更要求
-int mapif_parse_GuildMemberInfoChange (int fd, int guild_id, int account_id,
-                                       int char_id, int type,
-                                       const char *data, int len)
-{
-    // Could make some improvement in speed, because only change guild_member
-    int  i;
-    struct guild *g;
-    g = guild_pt;
-    inter_guild_fromsql (guild_id, g);
-    //printf("GuildMemberInfoChange %s \n",(type==GMI_EXP)?"GMI_EXP":"OTHER");
-
-    if (g == NULL)
-    {
-        return 0;
-    }
-    for (i = 0; i < g->max_member; i++)
-        if (g->member[i].account_id == account_id &&
-            g->member[i].char_id == char_id)
-            break;
-    if (i == g->max_member)
-    {
-        printf ("int_guild: GuildMemberChange: Not found %d,%d in %d[%s]\n",
-                account_id, char_id, guild_id, g->name);
-        return 0;
-    }
-    switch (type)
-    {
-        case GMI_POSITION:     // 役職
-            g->member[i].position = *((int *) data);
-            break;
-        case GMI_EXP:
-        {                       // EXP
-            int  exp, oldexp = g->member[i].exp;
-            exp = g->member[i].exp = *((unsigned int *) data);
-            g->exp += (exp - oldexp);
-            guild_calcinfo (g); // Lvアップ判断
-            mapif_guild_basicinfochanged (guild_id, GBI_EXP, &g->exp, 4);
-        } break;
-        default:
-            printf ("int_guild: GuildMemberInfoChange: Unknown type %d\n",
-                    type);
-            break;
-    }
-    mapif_guild_memberinfochanged (guild_id, account_id, char_id, type, data,
-                                   len);
-    inter_guild_tosql (g, 3);   // Change guild & guild_member
-    return 0;
-}
-
-// ギルド役職名変更要求
-int mapif_parse_GuildPosition (int fd, int guild_id, int idx,
-                               struct guild_position *p)
-{
-    // Could make some improvement in speed, because only change guild_position
-    struct guild *g;
-    g = guild_pt;
-    inter_guild_fromsql (guild_id, g);
-
-    if (g == NULL || idx < 0 || idx >= MAX_GUILDPOSITION)
-    {
-        return 0;
-    }
-    memcpy (&g->position[idx], p, sizeof (struct guild_position));
-    mapif_guild_position (g, idx);
-    printf ("int_guild: position changed %d\n", idx);
-    inter_guild_tosql (g, 4);   // Change guild_position
-    return 0;
-}
-
-// ギルドスキルアップ要求
-int mapif_parse_GuildSkillUp (int fd, int guild_id, int skill_num,
-                              int account_id)
-{
-    // Could make some improvement in speed, because only change guild_position
-    struct guild *g;
-    g = guild_pt;
-    inter_guild_fromsql (guild_id, g);
-    int  idx = skill_num - 10000;
-    if (g == NULL || skill_num < 10000)
-        return 0;
-    //printf("GuildSkillUp\n");
-
-    if (g->skill_point > 0 && g->skill[idx].id > 0 && g->skill[idx].lv < 10)
-    {
-        g->skill[idx].lv++;
-        g->skill_point--;
-        if (guild_calcinfo (g) == 0)
-            mapif_guild_info (-1, g);
-        mapif_guild_skillupack (guild_id, skill_num, account_id);
-        printf ("int_guild: skill %d up\n", skill_num);
-        inter_guild_tosql (g, 33);  // Change guild & guild_skill
-    }
-
-    return 0;
-}
-
-// ギルド同盟要求
-int mapif_parse_GuildAlliance (int fd, int guild_id1, int guild_id2,
-                               int account_id1, int account_id2, int flag)
-{
-    // Could speed up
-    struct guild *g[2];
-    int  j, i;
-    g[0] = guild_pt;
-    g[1] = guild_pt2;
-    inter_guild_fromsql (guild_id1, g[0]);
-    inter_guild_fromsql (guild_id2, g[1]);
-
-    if (g[0] == NULL || g[1] == NULL || g[0]->guild_id == 0
-        || g[1]->guild_id == 0)
-        return 0;
-
-    if (!(flag & 0x8))
-    {
-        for (i = 0; i < 2 - (flag & 1); i++)
-        {
-            for (j = 0; j < MAX_GUILDALLIANCE; j++)
-                if (g[i]->alliance[j].guild_id == 0)
-                {
-                    g[i]->alliance[j].guild_id = g[1 - i]->guild_id;
-                    memcpy (g[i]->alliance[j].name, g[1 - i]->name, 24);
-                    g[i]->alliance[j].opposition = flag & 1;
-                    break;
-                }
-        }
-    }
-    else
-    {                           // 関係解消
-        for (i = 0; i < 2 - (flag & 1); i++)
-        {
-            for (j = 0; j < MAX_GUILDALLIANCE; j++)
-                if (g[i]->alliance[j].guild_id == g[1 - i]->guild_id &&
-                    g[i]->alliance[j].opposition == (flag & 1))
-                {
-                    g[i]->alliance[j].guild_id = 0;
-                    break;
-                }
-        }
-    }
-    mapif_guild_alliance (guild_id1, guild_id2, account_id1, account_id2,
-                          flag, g[0]->name, g[1]->name);
-    inter_guild_tosql (g[0], 8);    // Change guild_alliance
-    inter_guild_tosql (g[1], 8);    // Change guild_alliance
-    return 0;
-}
-
-// ギルド告知変更要求
-int mapif_parse_GuildNotice (int fd, int guild_id, const char *mes1,
-                             const char *mes2)
-{
-    struct guild *g;
-    g = guild_pt;
-    inter_guild_fromsql (guild_id, g);
-
-    if (g == NULL || g->guild_id <= 0)
-        return 0;
-    memcpy (g->mes1, mes1, 60);
-    memcpy (g->mes2, mes2, 120);
-    inter_guild_tosql (g, 1);   // Change mes of guild
-    return mapif_guild_notice (g);
-}
-
-// ギルドエンブレム変更要求
-int mapif_parse_GuildEmblem (int fd, int len, int guild_id, int dummy,
-                             const char *data)
-{
-    struct guild *g;
-    g = guild_pt;
-    inter_guild_fromsql (guild_id, g);
-
-    if (g == NULL || g->guild_id <= 0)
-        return 0;
-    memcpy (g->emblem_data, data, len);
-    g->emblem_len = len;
-    g->emblem_id++;
-    inter_guild_tosql (g, 1);   // Change guild
-    return mapif_guild_emblem (g);
-}
-
-int mapif_parse_GuildCastleDataLoad (int fd, int castle_id, int index)  // <Agit>
-{
-    struct guild_castle *gc = guildcastle_pt;
-    inter_guildcastle_fromsql (castle_id, gc);
-    if (gc == NULL || gc->castle_id == -1)
-    {
-        return mapif_guild_castle_dataload (castle_id, 0, 0);
-    }
-    switch (index)
-    {
-        case 1:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->guild_id);
-            break;
-        case 2:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->economy);
-            break;
-        case 3:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->defense);
-            break;
-        case 4:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->triggerE);
-            break;
-        case 5:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->triggerD);
-            break;
-        case 6:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->nextTime);
-            break;
-        case 7:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->payTime);
-            break;
-        case 8:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->createTime);
-            break;
-        case 9:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->visibleC);
-            break;
-        case 10:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->visibleG0);
-            break;
-        case 11:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->visibleG1);
-            break;
-        case 12:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->visibleG2);
-            break;
-        case 13:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->visibleG3);
-            break;
-        case 14:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->visibleG4);
-            break;
-        case 15:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->visibleG5);
-            break;
-        case 16:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->visibleG6);
-            break;
-        case 17:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->visibleG7);
-            break;
-        case 18:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->Ghp0);
-            break;              // guardian HP [Valaris]
-        case 19:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->Ghp1);
-            break;
-        case 20:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->Ghp2);
-            break;
-        case 21:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->Ghp3);
-            break;
-        case 22:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->Ghp4);
-            break;
-        case 23:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->Ghp5);
-            break;
-        case 24:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->Ghp6);
-            break;
-        case 25:
-            return mapif_guild_castle_dataload (gc->castle_id, index,
-                                                gc->Ghp7);
-            break;              // end additions [Valaris]
-        default:
-            printf
-                ("mapif_parse_GuildCastleDataLoad ERROR!! (Not found index=%d)\n",
-                 index);
-            return 0;
-    }
-}
-
-int mapif_parse_GuildCastleDataSave (int fd, int castle_id, int index, int value)   // <Agit>
-{
-    struct guild_castle *gc = guildcastle_pt;
-    inter_guildcastle_fromsql (castle_id, gc);
-    if (gc == NULL || gc->castle_id == -1)
-    {
-        return mapif_guild_castle_datasave (castle_id, index, value);
-    }
-    switch (index)
-    {
-        case 1:
-            if (gc->guild_id != value)
-            {
-                int  gid = (value) ? value : gc->guild_id;
-                struct guild *g = guild_pt;
-                inter_guild_fromsql (gid, g);
-                inter_log ("guild %s (id=%d) %s castle id=%d" RETCODE,
-                           (g) ? g->name : "??", gid,
-                           (value) ? "occupy" : "abandon", index);
-            }
-            gc->guild_id = value;
-            break;
-        case 2:
-            gc->economy = value;
-            break;
-        case 3:
-            gc->defense = value;
-            break;
-        case 4:
-            gc->triggerE = value;
-            break;
-        case 5:
-            gc->triggerD = value;
-            break;
-        case 6:
-            gc->nextTime = value;
-            break;
-        case 7:
-            gc->payTime = value;
-            break;
-        case 8:
-            gc->createTime = value;
-            break;
-        case 9:
-            gc->visibleC = value;
-            break;
-        case 10:
-            gc->visibleG0 = value;
-            break;
-        case 11:
-            gc->visibleG1 = value;
-            break;
-        case 12:
-            gc->visibleG2 = value;
-            break;
-        case 13:
-            gc->visibleG3 = value;
-            break;
-        case 14:
-            gc->visibleG4 = value;
-            break;
-        case 15:
-            gc->visibleG5 = value;
-            break;
-        case 16:
-            gc->visibleG6 = value;
-            break;
-        case 17:
-            gc->visibleG7 = value;
-            break;
-        case 18:
-            gc->Ghp0 = value;
-            break;              // guardian HP [Valaris]
-        case 19:
-            gc->Ghp1 = value;
-            break;
-        case 20:
-            gc->Ghp2 = value;
-            break;
-        case 21:
-            gc->Ghp3 = value;
-            break;
-        case 22:
-            gc->Ghp4 = value;
-            break;
-        case 23:
-            gc->Ghp5 = value;
-            break;
-        case 24:
-            gc->Ghp6 = value;
-            break;
-        case 25:
-            gc->Ghp7 = value;
-            break;              // end additions [Valaris]
-        default:
-            printf
-                ("mapif_parse_GuildCastleDataSave ERROR!! (Not found index=%d)\n",
-                 index);
-            return 0;
-    }
-    inter_guildcastle_tosql (gc);
-    return mapif_guild_castle_datasave (gc->castle_id, index, value);
-}
-
-// ギルドチェック要求
-int mapif_parse_GuildCheck (int fd, int guild_id, int account_id, int char_id)
-{
-    // What does this mean? Check if belong to another guild?
-    return 0;
-}
-
-// map server からの通信
-// ・１パケットのみ解析すること
-// ・パケット長データはinter.cにセットしておくこと
-// ・パケット長チェックや、RFIFOSKIPは呼び出し元で行われるので行ってはならない
-// ・エラーなら0(false)、そうでないなら1(true)をかえさなければならない
-int inter_guild_parse_frommap (int fd)
-{
-    switch (RFIFOW (fd, 0))
-    {
-        case 0x3030:
-            mapif_parse_CreateGuild (fd, RFIFOL (fd, 4), RFIFOP (fd, 8),
-                                     (struct guild_member *) RFIFOP (fd, 32));
-            break;
-        case 0x3031:
-            mapif_parse_GuildInfo (fd, RFIFOL (fd, 2));
-            break;
-        case 0x3032:
-            mapif_parse_GuildAddMember (fd, RFIFOL (fd, 4),
-                                        (struct guild_member *) RFIFOP (fd,
-                                                                        8));
-            break;
-        case 0x3034:
-            mapif_parse_GuildLeave (fd, RFIFOL (fd, 2), RFIFOL (fd, 6),
-                                    RFIFOL (fd, 10), RFIFOB (fd, 14),
-                                    RFIFOP (fd, 15));
-            break;
-        case 0x3035:
-            mapif_parse_GuildChangeMemberInfoShort (fd, RFIFOL (fd, 2),
-                                                    RFIFOL (fd, 6),
-                                                    RFIFOL (fd, 10),
-                                                    RFIFOB (fd, 14),
-                                                    RFIFOW (fd, 15),
-                                                    RFIFOW (fd, 17));
-            break;
-        case 0x3036:
-            mapif_parse_BreakGuild (fd, RFIFOL (fd, 2));
-            break;
-        case 0x3037:
-            mapif_parse_GuildMessage (fd, RFIFOL (fd, 4), RFIFOL (fd, 8),
-                                      RFIFOP (fd, 12), RFIFOW (fd, 2) - 12);
-            break;
-        case 0x3038:
-            mapif_parse_GuildCheck (fd, RFIFOL (fd, 2), RFIFOL (fd, 6),
-                                    RFIFOL (fd, 10));
-            break;
-        case 0x3039:
-            mapif_parse_GuildBasicInfoChange (fd, RFIFOL (fd, 4),
-                                              RFIFOW (fd, 8), RFIFOP (fd, 10),
-                                              RFIFOW (fd, 2) - 10);
-            break;
-        case 0x303A:
-            mapif_parse_GuildMemberInfoChange (fd, RFIFOL (fd, 4),
-                                               RFIFOL (fd, 8), RFIFOL (fd,
-                                                                       12),
-                                               RFIFOW (fd, 16), RFIFOP (fd,
-                                                                        18),
-                                               RFIFOW (fd, 2) - 18);
-            break;
-        case 0x303B:
-            mapif_parse_GuildPosition (fd, RFIFOL (fd, 4), RFIFOL (fd, 8),
-                                       (struct guild_position *) RFIFOP (fd,
-                                                                         12));
-            break;
-        case 0x303C:
-            mapif_parse_GuildSkillUp (fd, RFIFOL (fd, 2), RFIFOL (fd, 6),
-                                      RFIFOL (fd, 10));
-            break;
-        case 0x303D:
-            mapif_parse_GuildAlliance (fd, RFIFOL (fd, 2), RFIFOL (fd, 6),
-                                       RFIFOL (fd, 10), RFIFOL (fd, 14),
-                                       RFIFOB (fd, 18));
-            break;
-        case 0x303E:
-            mapif_parse_GuildNotice (fd, RFIFOL (fd, 2), RFIFOP (fd, 6),
-                                     RFIFOP (fd, 66));
-            break;
-        case 0x303F:
-            mapif_parse_GuildEmblem (fd, RFIFOW (fd, 2) - 12, RFIFOL (fd, 4),
-                                     RFIFOL (fd, 8), RFIFOP (fd, 12));
-            break;
-        case 0x3040:
-            mapif_parse_GuildCastleDataLoad (fd, RFIFOW (fd, 2),
-                                             RFIFOB (fd, 4));
-            break;
-        case 0x3041:
-            mapif_parse_GuildCastleDataSave (fd, RFIFOW (fd, 2),
-                                             RFIFOB (fd, 4), RFIFOL (fd, 5));
-            break;
-
-        default:
-            return 0;
-    }
-    return 1;
-}
-
-int inter_guild_mapif_init (int fd)
-{
-    return mapif_guild_castle_alldataload (fd);
-}
-
-// サーバーから脱退要求（キャラ削除用）
-int inter_guild_leave (int guild_id, int account_id, int char_id)
-{
-    return mapif_parse_GuildLeave (-1, guild_id, account_id, char_id, 0,
-                                   "**サーバー命令**");
-}