From c2e295b8edf9effae1f7f4db0e0c80bcdb4e188c Mon Sep 17 00:00:00 2001 From: amber Date: Tue, 28 Dec 2004 23:07:49 +0000 Subject: update git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@849 54d463be-8e91-2dee-dedb-b68131a5f0ec --- Changelog.txt | 2 ++ src/char_sql/char.c | 12 ++++++++++++ 2 files changed, 14 insertions(+) diff --git a/Changelog.txt b/Changelog.txt index e46c90624..ed385876a 100644 --- a/Changelog.txt +++ b/Changelog.txt @@ -1,5 +1,7 @@ Date Added 12/28 + * When restarting the char-server, reset the online status + of all characters and guild-members (SVN 949) [MouseJstr] * Fix double timer_delete caused by pc_alive_timer (SVN 848) [MouseJstr] * Fixed typo in npcs_athena.conf (mc_cameri verses mc_Cameri), diff --git a/src/char_sql/char.c b/src/char_sql/char.c index e95651e7a..be8611889 100644 --- a/src/char_sql/char.c +++ b/src/char_sql/char.c @@ -1186,6 +1186,18 @@ int mmo_char_sql_init(void) { } else printf("set char_id_count: %d.......\n",char_id_count); + sprintf(tmp_sql , "REPLACE INTO `%s` SET `online`=0", char_db); + if (mysql_query(&mysql_handle, tmp_sql)) + printf("DB server Error - %s\n", mysql_error(&mysql_handle)); + + sprintf(tmp_sql , "REPLACE INTO `%s` SET `online`=0", guild_member_db); + if (mysql_query(&mysql_handle, tmp_sql)) + printf("DB server Error - %s\n", mysql_error(&mysql_handle)); + + sprintf(tmp_sql , "REPLACE INTO `%s` SET `connect_member`=0", guild_db); + if (mysql_query(&mysql_handle, tmp_sql)) + printf("DB server Error - %s\n", mysql_error(&mysql_handle)); + printf("init end.......\n"); return 0; -- cgit v1.2.3-60-g2f50