Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problem with fusing
#35
Thorr Wrote:Honestly, I am not convinced that there is a unique ID at all. It could be something simpler such as a Time Stamp. Time stamps are very precise and don't need to be sequential. If an item has a unique ID, the growth of that ID number in a game like this would be astounding. Every item would add 1 to the ID number and the count would have to be maintained per server for all items simultaneously. That's a lot of work for the database engine. A simple Time Stamp on the item would make it mostly unique. Thus, a Duped item would have an identical time stamp as another duped item. It would then be likely to be a questionable procedure to delete items based on a Time Stamp since there can be any number of legitimate items that share the time stamp. It is particularly true when there may be certain events in the game that alter the time stamp. MTS trade may do that since it the item can change servers.

(I am using Time Stamp as an example here and not as a fact. None of us knows exactly what the item record contains and thus all of it is speculation.)

Generating unique ID's is a pretty basic function in Oracle, which provides a "sequence" entity that auto-increments every time it is fetched. I don't know whether MSSQL has a similar entity, but it's not that hard to implement one yourself.
Using time-stamps, or any non-unique "item ID" completely defeats the purpose of using the item ID to know what is in your inventory. The reason dupes don't break the game is that all items with the same ID are similar or even identical (e.g., all items with ID 123123123 are a VIP Bow). If you use timestamps or the like, you'll get weird situations like trying to equip a stack of potions.
Reply


Messages In This Thread
Problem with fusing - by Furahi - 2012-02-27, 03:52 AM
Problem with fusing - by Locked - 2012-02-27, 04:26 AM
Problem with fusing - by Furahi - 2012-02-27, 05:57 AM
Problem with fusing - by Thunderbro - 2012-02-27, 06:18 PM
Problem with fusing - by Sephie - 2012-02-27, 08:07 PM
Problem with fusing - by Shidoshi - 2012-02-28, 04:19 AM
Problem with fusing - by Kaasoljoyyx - 2012-02-28, 02:45 PM
Problem with fusing - by Stereo - 2012-02-28, 04:03 PM
Problem with fusing - by Kaasoljoyyx - 2012-02-28, 04:15 PM
Problem with fusing - by Stereo - 2012-02-28, 04:18 PM
Problem with fusing - by Furahi - 2012-03-01, 05:54 PM
Problem with fusing - by Kaasoljoyyx - 2012-03-01, 06:01 PM
Problem with fusing - by Sunshines - 2012-03-01, 07:16 PM
Problem with fusing - by Infernal - 2012-03-01, 07:26 PM
Problem with fusing - by Locked - 2012-03-01, 08:10 PM
Problem with fusing - by Leaves - 2012-03-01, 09:05 PM
Problem with fusing - by Furahi - 2012-03-02, 02:50 AM
Problem with fusing - by Fuzz - 2012-03-03, 04:18 AM
Problem with fusing - by GoreParadise - 2012-03-03, 06:57 AM
Problem with fusing - by ShinkuDragon - 2012-03-03, 07:16 AM
Problem with fusing - by Vanderlust - 2012-03-07, 12:55 PM
Problem with fusing - by Shidoshi - 2012-03-07, 01:26 PM
Problem with fusing - by Vanderlust - 2012-03-07, 01:44 PM
Problem with fusing - by Shidoshi - 2012-03-07, 02:09 PM
Problem with fusing - by Stereo - 2012-03-07, 03:09 PM
Problem with fusing - by Furahi - 2012-03-09, 12:34 PM
Problem with fusing - by Patt - 2012-03-09, 02:10 PM
Problem with fusing - by Takebacker - 2012-03-09, 03:08 PM
Problem with fusing - by Furahi - 2012-03-10, 03:35 AM
Problem with fusing - by ShinkuDragon - 2012-03-10, 04:21 AM
Problem with fusing - by Furahi - 2012-03-10, 05:07 AM
Problem with fusing - by inemnitable - 2012-03-25, 08:42 PM
Problem with fusing - by Thorr - 2012-03-26, 08:19 AM
Problem with fusing - by Phoenix - 2012-03-26, 08:31 AM
Problem with fusing - by SaptaZapta - 2012-03-26, 08:51 AM
Problem with fusing - by Thorr - 2012-03-26, 10:58 AM
Problem with fusing - by SaptaZapta - 2012-03-26, 11:38 AM
Problem with fusing - by Thorr - 2012-03-26, 12:00 PM
Problem with fusing - by SaptaZapta - 2012-03-26, 12:13 PM
Problem with fusing - by Thorr - 2012-03-26, 12:36 PM
Problem with fusing - by SaptaZapta - 2012-03-26, 01:20 PM

Forum Jump:


Users browsing this thread: