bad timestamp for guilds and guild

Added by Phantase about 9 years ago

Guilds

If you retrieve the list of all guilds (from Aniro in our example : http://atys.ryzom.com/api/guilds.php?shardid=ani ) you have the creation_date of each guild.

But this creation_date seems to be totaly wrong...

For example, the creation_date for "Legions Fyros" is 156878000 : Sat, 21 Dec 1974 17:13:20 GMT, and the same creation_date for a lot of other guilds.

Another example, the creation_date for "Bijouterie Arca" is 1341192996 : Mon, 02 Jul 2012 01:36:36 GMT

Guild

This is the same issue, with the creation_date, and with the joined_date of each members of the guild.


Replies (10)

RE: [BUG] bad timestamp for guilds and guild - Added by barbaros about 9 years ago

It is the servertick, not a unix timestamp.

For RP reasons it is very nice, however you cannot convert the ticks into timestamp due to downtimes and such.
You can calculate the difference to the current servertick (Member for xyz days etc.)

RE: [BUG] bad timestamp for guilds and guild - Added by Phantase about 9 years ago

Ok, that's not a problem for me to have the servertick instead of a UNIX timestamp ;)

So now I have two points to light on :

First point

Some guilds (2 for Aniro, 6 for Aristople and 2 for Leanon) have a servertick that make the formula used by the php API returns a strange Ryzom date...

e.g. on guild "La karatempete" on Aniro shard :

<guild>
<name>La karatempete</name>
<race>Matis</race>
<icon>407583187980517579</icon>
<creation_date>151536</creation_date>
<description/>
</guild>

Its creation_date corresponds to "-11h - undefined, undefined -26, 0e CA 2524"

The name of guilds are:
for Aniro:
  • La karatempete
  • Onzieme Division
for Aristople:
  • Innerflux
  • Keepers of the Shrine
  • Minious of Ashtaroth
  • The Jenai Academy
  • Ambactus
  • Storage Space
for Leanon:
  • Freunde von Atys
  • SturmReiter

Second point

There is a lot of guild with exactly the same servertick (156878000 on Ani, 165000626 for Ari, 170209578 for Lea), my first player guild is one of them (on Aniro), and I remember that it was the battle to have the first guild created on Aniro, and that's very strange to have a lot of guilds created in the same tick... (in 1/10 seconds...) Is it because there is a time before the server writes the guild in its database (the server writes only every xxx ticks/minutes) ?

RE: [BUG] bad timestamp for guilds and guild - Added by kervala about 9 years ago

Ryzom time API doesn't work with negative server ticks (server tick has been reseted for one patch in 2004).

I added some new tests to fix it.

time.diff - patch (2 kB) Magnifier

RE: [BUG] bad timestamp for guilds and guild - Added by kervala about 9 years ago

I think problem for your second point is this field has been added later :(

RE: [BUG] bad timestamp for guilds and guild - Added by Phantase about 9 years ago

Thanks for your patch, there is no more apparent bug _ (I have retranscribed it in AS3)

But for the second point, I don't understand...

How can some guilds have an older servertick if the creation_date for guild was created after a d date ? In the same idea, how can some guilds have a "negative server ticks" if the field for the server tick was not created at this date ?

RE: [BUG] bad timestamp for guilds and guild - Added by kervala about 9 years ago

I'm adding some other functionalities in Ryzom API client scripts, it should be modified soon.

And that's really strange about creation date.

RE: [BUG] bad timestamp for guilds and guild - Added by nimetu about 9 years ago

Phantase wrote:

How can some guilds have an older servertick if the creation_date for guild was created after a d date ? In the same idea, how can some guilds have a "negative server ticks" if the field for the server tick was not created at this date ?

there is no such thing as negative server tick ;-). there is however negative atys date (-61 ingame days, 3 rl days) because the early start and day '0' (or 1) was launch day.

There also was one or few occasions where server tick was reset back to 0, so guilds created at that time (or players joining to guild) time is fubar.
For Arispotle time log can be seen from http://atys.pri.ee/?page=sync
Some data for Leanon/Aniro too, but not much because it required different community account back then.

to get the approximate RL date, just 'stretch' the ingame timeperiod to rl timeperiod. get the biggest downtimes from Arispotle and figure out which tick it might of been for others, wrap it in nice package and submit for contest ;-)

RE: [BUG] bad timestamp for guilds and guild - Added by vl about 9 years ago

I'll apply the kervala patch in the ryzom API.

The creation_date was added after the release of the game. So for all guild that was created before this field, we don't know the real creation date, so they setuped a default value.

RE: bad timestamp for guilds and guild - Added by vl about 9 years ago

The kervala patch was applied.

RE: bad timestamp for guilds and guild - Added by Houlecorn about 9 years ago

nimetu wrote:

Some data for Leanon/Aniro too, but not much because it required different community account back then.

I've got some info for Aniro (not much) that I tracked down mainly since I wrote a PHP library for translating ig time to irl time. Information since then is quite accurate. Information before that is picked up (& corrected) from http://fondation.bourdu.org/time.htm

Exported info I got for Aniro is :

irl timestamp    tick
1221828240    1095163200
1219885800    1075723200
1218327540    1060171200
1202692140    1043323200
1193398560    951307200
1191136200    943531200
1188408900    916315200
1187629740    908539200
1174729740    780235200
1158873020    624715200
1157657409    613051200
1155280497    589723200
1151707382    554731200
1150488547    543067200
1146304140    504187200
1143968400    480859200
1139683059    438091200
1133016300    371995200
1095285600    2635200
1239297120    1269535260
1240046400    1277023008

(1-10/10)