daim 5 Posted March 9, 2016 (edited) Hi there, Today i just have time to spent to check item duplication if posibble. And im using this command to check my storage. SELECT unique_idFROM STORAGE GROUP BY unique_idHAVING COUNT( * ) >=2 And as a results i found several item have same Unique_Id (unstackable items). My question is, is it duplicate item possible by players or it's system failure to give uniqe id for each eq? Edited March 9, 2016 by daim Quote Share this post Link to post Share on other sites
0 hemagx 69 Posted March 9, 2016 it's not possible to get duplicated unique_id unless it's a stackable item Quote Share this post Link to post Share on other sites
0 daim 5 Posted March 9, 2016 Could other server owner test it out and see? If they facing this issues mean the system not working right. Quote Share this post Link to post Share on other sites
0 vykimo 68 Posted March 11, 2016 Yes, we saw on our db duplicate unique_id... Don't know how it happens. Quote Share this post Link to post Share on other sites
0 kyeme 71 Posted March 11, 2016 See here https://github.com/HerculesWS/Hercules/issues/1191https://github.com/HerculesWS/Hercules/commit/7420249057e038fe1cc799938e03d28ffe321e2f Quote Share this post Link to post Share on other sites
0 Dastgir 1246 Posted March 11, 2016 Yes, we saw on our db duplicate unique_id... Don't know how it happens. It was just duplicate ID and not duplicated items. Quote Share this post Link to post Share on other sites
Hi there,
Today i just have time to spent to check item duplication if posibble. And im using this command to check my storage.
SELECT unique_id
FROM STORAGE GROUP BY unique_id
HAVING COUNT( * ) >=2
And as a results i found several item have same Unique_Id (unstackable items).
My question is, is it duplicate item possible by players or it's system failure to give uniqe id for each eq?
Edited by daimShare this post
Link to post
Share on other sites