These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

refID is unique or not
Author
Previous Topic Next Topic
Gallente Drone
Doomheim
#1 - 2012-07-19 16:10:46 UTC
I search forums but didn't found an answer. Is refID unique (as characterID) or not? If not, how to save data not to lose while updating new entries? Fro example data is wallet journal.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-07-19 16:12:40 UTC
No, but...

It can be reset by CCP. They won't say they won't reset it.

But it's been mentioned on #eve-dev that they're not /planning/ on resetting it.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Gallente Drone
Doomheim
#3 - 2012-07-19 16:16:12 UTC
Steve Ronuken wrote:
No, but...

It can be reset by CCP. They won't say they won't reset it.

But it's been mentioned on #eve-dev that they're not /planning/ on resetting it.

So how to deal with it? How to change refID "correctly"? Api gives last month "logs", but if we collect a few years? О,О they would be lost cause of "CCP reset refID"?
Lutz Major
Austriae Est Imperare Orbi Universo
#4 - 2012-07-19 18:51:31 UTC
Gallente Drone wrote:
Steve Ronuken wrote:
No, but...

It can be reset by CCP. They won't say they won't reset it.

But it's been mentioned on #eve-dev that they're not /planning/ on resetting it.

So how to deal with it? How to change refID "correctly"? Api gives last month "logs", but if we collect a few years? О,О they would be lost cause of "CCP reset refID"?


Please refer to this Blog (with the most awesome graph): http://community.eveonline.com/devblog.asp?a=blog&nbid=1882

FYI: don't think that the refID is unique per se (as in primary key) : just send your alt money and compare the refID.
Gallente Drone
Doomheim
#5 - 2012-07-19 21:01:09 UTC
Lutz Major wrote:
Gallente Drone wrote:
Steve Ronuken wrote:
No, but...

It can be reset by CCP. They won't say they won't reset it.

But it's been mentioned on #eve-dev that they're not /planning/ on resetting it.

So how to deal with it? How to change refID "correctly"? Api gives last month "logs", but if we collect a few years? О,О they would be lost cause of "CCP reset refID"?


Please refer to this Blog (with the most awesome graph): http://community.eveonline.com/devblog.asp?a=blog&nbid=1882

FYI: don't think that the refID is unique per se (as in primary key) : just send your alt money and compare the refID.

I know that refID will be the same in ownerID1 and ownerID2 (for example simple player donation), and no matter which api you use (ownerID1 or ownerID2). But will this refID uses in other situations?

So refID is id of "transaction" with only two "persons" in other cases will be used another refID, am i right?
Desmont McCallock
#6 - 2012-07-20 06:49:52 UTC
Gallente Drone
Doomheim
#7 - 2012-07-20 10:52:37 UTC
Ok. Let's think another way. If somehow refID will be changed, wich rows we can use set row in db as unique?

For example will be "date + ownerID1 + ownerID2 + refTypeID" unique ?
Dragonaire
Here there be Dragons
#8 - 2012-07-20 20:56:30 UTC
If Eve last long enough to run out of IDs with a 64 bit integer I'm sure by that time CCP will just move to 128 bits Blink

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.
Gallente Drone
Doomheim
#9 - 2012-07-20 21:09:10 UTC
Dragonaire wrote:
If Eve last long enough to run out of IDs with a 64 bit integer I'm sure by that time CCP will just move to 128 bits Blink

i hope not the same way they do patches ;) otherwise we'll return to this question LOL
Chaotic Mind
Republic University
Minmatar Republic
#10 - 2012-07-24 09:51:22 UTC  |  Edited by: Chaotic Mind
I use refID + Date as identifier... if they really reset the refID at same minute I'm boned