diff options
| -rw-r--r-- | Changelog.txt | 2 | ||||
| -rw-r--r-- | src/char_sql/char.c | 12 |
2 files changed, 14 insertions, 0 deletions
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; |