diff options
| -rw-r--r-- | Changelog.txt | 2 | ||||
| -rw-r--r-- | src/char_sql/char.c | 5 |
2 files changed, 5 insertions, 2 deletions
diff --git a/Changelog.txt b/Changelog.txt index d2fff140c..4ca45ceb8 100644 --- a/Changelog.txt +++ b/Changelog.txt @@ -1,6 +1,8 @@ Date Added 01/29 + * Fixed Storage Bug with Named Stackable items. Thanks to Nimion [Lupus] + e.g. Arrows, Iron, Elemental stones, etc... * Added a crash check to Safety Wall, thanks to LebrEf[TaVu] / Freya for pointing it out [celest] * Added some optimisations in clif_parse_MapMove, by Ilpalazzo-sama [celest] diff --git a/src/char_sql/char.c b/src/char_sql/char.c index b745ea504..4c8d7e29f 100644 --- a/src/char_sql/char.c +++ b/src/char_sql/char.c @@ -815,10 +815,11 @@ int memitemdata_to_sql(struct itemtemp mapitem, int eqcount, int noteqcount, int //printf("the same item : %d ; i : %d ; flag : %d\n", mapitem.notequip[i].nameid, i, mapitem.notequip[i].flag); //DEBUG-STRING } else{ + //named item dupe bugfix by Nimion [Lupus] sprintf(tmp_sql,"UPDATE `%s` SET `amount`='%d', `equip`='%d', `identify`='%d'," - "`attribute`='%d' WHERE `%s`='%d' AND `nameid`='%d'", + "`attribute`='%d' WHERE `%s`='%d' AND `nameid`='%d' AND `card0`='%d' AND `card2`='%d'", tablename, mapitem.notequip[i].amount, mapitem.notequip[i].equip, mapitem.notequip[i].identify, mapitem.notequip[i].attribute, - selectoption, char_id, mapitem.notequip[i].nameid); + selectoption, char_id, mapitem.notequip[i].nameid,mapitem.notequip[i].card[0],mapitem.notequip[i].card[2]); //printf("%s",tmp_sql); if(mysql_query(&mysql_handle, tmp_sql)) printf("DB server Error (UPdate `notequ %s`)- %s\n",tablename ,mysql_error(&mysql_handle)); |