Untitled

 avatar
unknown
plain_text
18 days ago
3.9 kB
4
Indexable
#ifdef ENABLE_SPECIAL_STORAGE
#ifdef ENABLE_SWITCHBOT //Replace your old line with the whole ifdef/else statement
#ifdef CHANGE_EQUIP_WORLDARD
		snprintf(queryStr, sizeof(queryStr), "DELETE FROM item%s WHERE owner_id=%d AND (window < %d or window = %d or window = %d or window = %d or window = %d or window = %d or window = %d or window = %d or window = %d or window = %d)", 
		GetTablePostfix(), pi->player_id, SAFEBOX, DRAGON_SOUL_INVENTORY, UPGRADE_INVENTORY, BOOK_INVENTORY, STONE_INVENTORY, CHANGE_INVENTORY, COSTUME_INVENTORY, CHEST_INVENTORY, SWITCHBOT, CHANGE_EQUIP);
#else
		snprintf(queryStr, sizeof(queryStr), "DELETE FROM item%s WHERE owner_id=%d AND (window < %d or window = %d or window = %d or window = %d or window = %d or window = %d or window = %d or window = %d or window = %d)", 
		GetTablePostfix(), pi->player_id, SAFEBOX, DRAGON_SOUL_INVENTORY, UPGRADE_INVENTORY, BOOK_INVENTORY, STONE_INVENTORY, CHANGE_INVENTORY, COSTUME_INVENTORY, CHEST_INVENTORY, SWITCHBOT);
#endif
#else
#ifdef CHANGE_EQUIP_WORLDARD
		snprintf(queryStr, sizeof(queryStr), "DELETE FROM item%s WHERE owner_id=%d AND (window < %d or window = %d or window = %d or window = %d or window = %d or window = %d or window = %d or window = %d or window = %d)", 
		GetTablePostfix(), pi->player_id, SAFEBOX, DRAGON_SOUL_INVENTORY, UPGRADE_INVENTORY, BOOK_INVENTORY, STONE_INVENTORY, CHANGE_INVENTORY, COSTUME_INVENTORY, CHEST_INVENTORY, CHANGE_EQUIP);
#else
		snprintf(queryStr, sizeof(queryStr), "DELETE FROM item%s WHERE owner_id=%d AND (window < %d or window = %d or window = %d or window = %d or window = %d or window = %d or window = %d or window = %d)", 
		GetTablePostfix(), pi->player_id, SAFEBOX, DRAGON_SOUL_INVENTORY, UPGRADE_INVENTORY, BOOK_INVENTORY, STONE_INVENTORY, COSTUME_INVENTORY, CHANGE_INVENTORY, CHEST_INVENTORY);
#endif
#endif
#else
#ifdef ENABLE_SWITCHBOT //Replace your old line with the whole ifdef/else statement
#ifdef CHANGE_EQUIP_WORLDARD
		snprintf(queryStr, sizeof(queryStr), "DELETE FROM item%s WHERE owner_id=%d AND (window < %d or window = %d or window = %d or window = %d)", GetTablePostfix(), pi->player_id, SAFEBOX, DRAGON_SOUL_INVENTORY, SWITCHBOT, CHANGE_EQUIP);
#else
		snprintf(queryStr, sizeof(queryStr), "DELETE FROM item%s WHERE owner_id=%d AND (window < %d or window = %d or window = %d)", GetTablePostfix(), pi->player_id, SAFEBOX, DRAGON_SOUL_INVENTORY, SWITCHBOT);
#endif
#else
#ifdef CHANGE_EQUIP_WORLDARD
		snprintf(queryStr, sizeof(queryStr), "DELETE FROM item%s WHERE owner_id=%d AND (window < %d or window = %d or window = %d)", GetTablePostfix(), pi->player_id, SAFEBOX, DRAGON_SOUL_INVENTORY, CHANGE_EQUIP);

#else
		snprintf(queryStr, sizeof(queryStr), "DELETE FROM item%s WHERE owner_id=%d AND (window < %d or window = %d)", GetTablePostfix(), pi->player_id, SAFEBOX, DRAGON_SOUL_INVENTORY);
#endif
#endif
#endif
----------------------------------------------------------------------------------------------------------------------------
change to
----------------------------------------------------------------------------------------------------------------------------
		snprintf(queryStr, sizeof(queryStr),
			"DELETE FROM item%s WHERE owner_id=%d AND (window < %d or window = %d"
#ifdef ENABLE_SPECIAL_STORAGE
			" or window = %d or window = %d or window = %d or window = %d or window = %d or window = %d"
#endif
#ifdef CHANGE_EQUIP_WORLDARD
			" or window = %d"
#endif
#ifdef ENABLE_SWITCHBOT
			" or window = %d"
#endif
			")"
			,GetTablePostfix(), pi->player_id, SAFEBOX, DRAGON_SOUL_INVENTORY
#ifdef ENABLE_SPECIAL_STORAGE
			, UPGRADE_INVENTORY, BOOK_INVENTORY, STONE_INVENTORY, CHANGE_INVENTORY, COSTUME_INVENTORY, CHEST_INVENTORY
#endif
#ifdef ENABLE_SWITCHBOT
			, SWITCHBOT
#endif
#ifdef CHANGE_EQUIP_WORLDARD
			, CHANGE_EQUIP
#endif
			);
Leave a Comment