From ccc18ecfe671803c6d6b9b6dd790c45cdf28c9ac Mon Sep 17 00:00:00 2001 From: skotlex Date: Thu, 16 Aug 2007 03:55:16 +0000 Subject: - Cleaned some more the hotkey code: The order by and limit specifications are not really needed when loading hotkeys, and added hotkey deletion when you delete the character. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11022 54d463be-8e91-2dee-dedb-b68131a5f0ec --- src/char_sql/char.c | 13 +++++++++++-- 1 file changed, 11 insertions(+), 2 deletions(-) (limited to 'src/char_sql') diff --git a/src/char_sql/char.c b/src/char_sql/char.c index 5ff26c0aa..8ec26f6a5 100644 --- a/src/char_sql/char.c +++ b/src/char_sql/char.c @@ -1107,7 +1107,7 @@ int mmo_char_fromsql(int char_id, struct mmo_charstatus* p, bool load_everything #ifdef HOTKEY_SAVING //Hotkeys - sprintf(tmp_sql, "SELECT `hotkey`, `type`, `itemskill_id`, `skill_lvl` FROM `%s` WHERE `char_id`=%d ORDER BY `hotkey` LIMIT %d;", hotkey_db, char_id, HOTKEY_SAVING); + sprintf(tmp_sql, "SELECT `hotkey`, `type`, `itemskill_id`, `skill_lvl` FROM `%s` WHERE `char_id`='%d'", hotkey_db, char_id); if(mysql_query(&mysql_handle, tmp_sql)){ ShowSQL("DB error - %s\n", mysql_error(&mysql_handle)); ShowDebug("at %s:%d - %s\n", __FILE__, __LINE__, tmp_sql); @@ -1492,7 +1492,16 @@ int delete_char_sql(int char_id, int partner_id) ShowSQL("DB error - %s\n",mysql_error(&mysql_handle)); ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql); } - + +#ifdef HOTKEY_SAVING + /* delete hotkeys */ + sprintf(tmp_sql, "DELETE FROM `%s` WHERE `char_id`='%d'", hotkey_db, char_id); + if(mysql_query(&mysql_handle, tmp_sql)) { + ShowSQL("DB error - %s\n",mysql_error(&mysql_handle)); + ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql); + } +#endif + /* delete inventory */ sprintf(tmp_sql,"DELETE FROM `%s` WHERE `char_id`='%d'",inventory_db, char_id); if(mysql_query(&mysql_handle, tmp_sql)) { -- cgit v1.2.3-60-g2f50