diff options
| author | shennetsind <shennetsind@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-06-24 00:26:10 +0000 |
|---|---|---|
| committer | shennetsind <shennetsind@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-06-24 00:26:10 +0000 |
| commit | 38b080ef8cebdc883caf6bc51ddedddb2ec066aa (patch) | |
| tree | f604b7fa58d4669ac326f420a0f8a75a97fd397b /src/char/char.c | |
| parent | a8b6ddb7a6d2b0e5d9b8a3140b98b9d8d9fce210 (diff) | |
| download | hercules-38b080ef8cebdc883caf6bc51ddedddb2ec066aa.tar.gz hercules-38b080ef8cebdc883caf6bc51ddedddb2ec066aa.tar.bz2 hercules-38b080ef8cebdc883caf6bc51ddedddb2ec066aa.tar.xz hercules-38b080ef8cebdc883caf6bc51ddedddb2ec066aa.zip | |
Fixed bugreport:5947 Genetic/Mechanics should be displayed properly in their /alchemist /blacksmith ranks, special thanks to Xantara and Aleos.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16335 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'src/char/char.c')
| -rw-r--r-- | src/char/char.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/char/char.c b/src/char/char.c index da5524c93..1f67f8d83 100644 --- a/src/char/char.c +++ b/src/char/char.c @@ -2284,7 +2284,7 @@ void char_read_fame_list(void) memset(chemist_fame_list, 0, sizeof(chemist_fame_list)); memset(taekwon_fame_list, 0, sizeof(taekwon_fame_list)); // Build Blacksmith ranking list - if( SQL_ERROR == Sql_Query(sql_handle, "SELECT `char_id`,`fame`,`name` FROM `%s` WHERE `fame`>0 AND (`class`='%d' OR `class`='%d' OR `class`='%d') ORDER BY `fame` DESC LIMIT 0,%d", char_db, JOB_BLACKSMITH, JOB_WHITESMITH, JOB_BABY_BLACKSMITH, fame_list_size_smith) ) + if( SQL_ERROR == Sql_Query(sql_handle, "SELECT `char_id`,`fame`,`name` FROM `%s` WHERE `fame`>0 AND (`class`='%d' OR `class`='%d' OR `class`='%d' OR `class`='%d' OR `class`='%d' OR `class`='%d') ORDER BY `fame` DESC LIMIT 0,%d", char_db, JOB_BLACKSMITH, JOB_WHITESMITH, JOB_BABY_BLACKSMITH, JOB_MECHANIC, JOB_MECHANIC_T, JOB_BABY_MECHANIC, fame_list_size_smith) ) Sql_ShowDebug(sql_handle); for( i = 0; i < fame_list_size_smith && SQL_SUCCESS == Sql_NextRow(sql_handle); ++i ) { @@ -2299,7 +2299,7 @@ void char_read_fame_list(void) memcpy(smith_fame_list[i].name, data, min(len, NAME_LENGTH)); } // Build Alchemist ranking list - if( SQL_ERROR == Sql_Query(sql_handle, "SELECT `char_id`,`fame`,`name` FROM `%s` WHERE `fame`>0 AND (`class`='%d' OR `class`='%d' OR `class`='%d') ORDER BY `fame` DESC LIMIT 0,%d", char_db, JOB_ALCHEMIST, JOB_CREATOR, JOB_BABY_ALCHEMIST, fame_list_size_chemist) ) + if( SQL_ERROR == Sql_Query(sql_handle, "SELECT `char_id`,`fame`,`name` FROM `%s` WHERE `fame`>0 AND (`class`='%d' OR `class`='%d' OR `class`='%d' OR `class`='%d' OR `class`='%d' OR `class`='%d') ORDER BY `fame` DESC LIMIT 0,%d", char_db, JOB_ALCHEMIST, JOB_CREATOR, JOB_BABY_ALCHEMIST, JOB_GENETIC, JOB_GENETIC_T, JOB_BABY_GENETIC, fame_list_size_chemist) ) Sql_ShowDebug(sql_handle); for( i = 0; i < fame_list_size_chemist && SQL_SUCCESS == Sql_NextRow(sql_handle); ++i ) { |