DWORD CGuildManager::CreateGuild(TGuildCreateParameter& gcp)
{
if (!gcp.master)
return 0;

if (!check_name(gcp.name))
{
gcp.master->ChatPacket(CHAT_TYPE_INFO, LC_TEXT("<ąćľĺ> ąćľĺ Ŕ̸§ŔĚ ŔűÇŐÇĎÁö žĘ˝Ŕ´Ď´Ů."));
return 0;
}

// @fixme143 BEGIN
static char __guild_name[GUILD_NAME_MAX_LEN*2+1];
DBManager::instance().EscapeString(__guild_name, sizeof(__guild_name), gcp.name, strnlen(gcp.name, sizeof(gcp.name)));
if (strncmp(__guild_name, gcp.name, strnlen(gcp.name, sizeof(gcp.name))))
return 0;
// @fixme143 END

std::auto_ptr<SQLMsg> pmsg(DBManager::instance().DirectQuery("SELECT COUNT(*) FROM guild%s WHERE name = '%s'",
get_table_postfix(), __guild_name));

if (pmsg->Get()->uiNumRows > 0)
{
MYSQL_ROW row = mysql_fetch_row(pmsg->Get()->pSQLResult);

if (!(row[0] && row[0][0] == '0'))
{
gcp.master->ChatPacket(CHAT_TYPE_INFO, LC_TEXT("<ąćľĺ> ŔĚšĚ °°Ŕş Ŕ̸§ŔÇ ąćľĺ°Ą ŔÖ˝Ŕ´Ď´Ů."));
return 0;
}
}
else
{
gcp.master->ChatPacket(CHAT_TYPE_INFO, LC_TEXT("<ąćľĺ> ąćľĺ¸Ś ťýźşÇŇ źö žř˝Ŕ´Ď´Ů."));
return 0;
}

// new CGuild(gcp) queries guild tables and tell dbcache to notice other game servers.
// other game server calls CGuildManager::LoadGuild to load guild.
CGuild * pg = M2_NEW CGuild(gcp);
m_mapGuild.insert(std::make_pa

void MessengerManager::RemoveFromList(MessengerManager::keyA account, MessengerManager::keyA companion)
{
if (companion.size() == 0)
return;

// @fixme142 BEGIN
DBManager::instance().EscapeString(__account, sizeof(__account), account.c_str(), account.size());
DBManager::instance().EscapeString(__companion, sizeof(__companion), companion.c_str(), companion.size());
if (account.compare(__account) || companion.compare(__companion))
return;
// @fixme142 END

sys_log(1, "Messenger Remove %s %s", account.c_str(), companion.c_str());
DBManager::instance().Query("DELETE FROM messenger_list%s WHERE account='%s' AND companion = '%s'",
get_table_postfix(), __account, __companion);

__RemoveFromList(account, companion);

TPacketGGMessenger p2ppck;

p2ppck.bHeader = HEADER_GG_MESSENGER_REMOVE;
strlcpy(p2ppck.szAccount, account.c_str(), sizeof(p2ppck.szAccount));
strlcpy(p2ppck.szCompanion, companion.c_str(), sizeof(p2ppck.szCompanion));
P2P_MANAGER::instance().Send(&p2ppck, sizeof(TPacketGGMessenger));
}

DWORD CGuildManager::CreateGuild(TGuildCreateParameter& gcp)
{
if (!gcp.master)
return 0;

if (!check_name(gcp.name))
{
gcp.master->ChatPacket(CHAT_TYPE_INFO, LC_TEXT("<ąćľĺ> ąćľĺ Ŕ̸§ŔĚ ŔűÇŐÇĎÁö žĘ˝Ŕ´Ď´Ů."));
return 0;
}

// @fixme143 BEGIN
static char __guild_name[GUILD_NAME_MAX_LEN*2+1];
DBManager::instance().EscapeString(__guild_name, sizeof(__guild_name), gcp.name, strnlen(gcp.name, sizeof(gcp.name)));
if (strncmp(__guild_name, gcp.name, strnlen(gcp.name, sizeof(gcp.name))))
return 0;
// @fixme143 END

std::auto_ptr<SQLMsg> pmsg(DBManager::instance().DirectQuery("SELECT COUNT(*) FROM guild%s WHERE name = '%s'",
get_table_postfix(), __guild_name));

if (pmsg->Get()->uiNumRows > 0)
{
MYSQL_ROW row = mysql_fetch_row(pmsg->Get()->pSQLResult);

if (!(row[0] && row[0][0] == '0'))
{
gcp.master->ChatPacket(CHAT_TYPE_INFO, LC_TEXT("<ąćľĺ> ŔĚšĚ °°Ŕş Ŕ̸§ŔÇ ąćľĺ°Ą ŔÖ˝Ŕ´Ď´Ů."));
return 0;
}
}
else
{
gcp.master->ChatPacket(CHAT_TYPE_INFO, LC_TEXT("<ąćľĺ> ąćľĺ¸Ś ťýźşÇŇ źö žř˝Ŕ´Ď´Ů."));
return 0;
}

// new CGuild(gcp) queries guild tables and tell dbcache to notice other game servers.
// other game server calls CGuildManager::LoadGuild to load guild.
CGuild * pg = M2_NEW CGuild(gcp);
m_mapGuild.insert(std::make_pa