Used in "friend list" to display the icon next to the char name probably Joymax was uber lazy that they didn't do simple query to fetch refobjid from _Char table
Used in "friend list" to display the icon next to the char name probably Joymax was uber lazy that they didn't do simple query to fetch refobjid from _Char table
My bad, I through it was shown too on the PM's, but seems the race icon only appear on the friend list (maybe the old PM window had the race icon, who knows).
It probably has no use right now.
Used in "friend list" to display the icon next to the char name probably Joymax was uber lazy that they didn't do simple query to fetch refobjid from _Char table
They weren't lazy
It's just a question of performance
It's better to save it in another table than to query it every time
And the character model changes like never
Their database is not THAT bad
Sure they missed quite a lot of things, but they know what they're doing, you can see that.
I doubt that anyone here could do it better
They weren't lazy
It's just a question of performance
It's better to save it in another table than to query it every time
And the character model changes like never
Their database is not THAT bad
Sure they missed quite a lot of things, but they know what they're doing, you can see that.
I doubt that anyone here could do it better
Because SELECT RefObjID FROM _Char WHERE CharID = '123123' will take more time to execute than SELECT RefObjID FROM _Memo WHERE CharID = '123123'
_Memo will most likely contain less records than _Char and the chance of the record at _Memo being locked by another transaction (Assuming they aren't using the NOLOCK hint in their query; query executed on _Memo is "SELECT ID64,FromCharName,Message,Date,RefObjID,Status FROM _Memo WHERE CharID = %d") is far less than on _Char that is frequently updated and used to select character information.
I don't know though why they store the ObjID rather than the CountryID
_Memo will most likely contain less records than _Char and the chance of the record at _Memo being locked by another transaction (Assuming they aren't using the NOLOCK hint in their query; query executed on _Memo is "SELECT ID64,FromCharName,Message,Date,RefObjID,Status FROM _Memo WHERE CharID = %d") is far less than on _Char that is frequently updated and used to select character information.
I don't know though why they store the ObjID rather than the CountryID
Because is not a good structured method to store reference data on a non-reference table. If for some reason they decide that the countryID is now 4 for china chars instead of 0, and 2 for european, they just have to change the reference tables, and since the other tables obtain the data by the primary key of the reference table there will never be data corruption.
Because is not a good structured method to store reference data on a non-reference table. If for some reason they decide that the countryID is now 4 for china chars instead of 0, and 2 for european, they just have to change the reference tables, and since the other tables obtain the data by the primary key of the reference table there will never be data corruption.
By storing the CountryID I actually meant that the _Memo_Add procedure shall get the Country.dbo._RefObjCommon and store it instead of the RefObjID that is passed to it.
I doubt that they ever gonna change the country id's when they've already considered the arabian race in the current setup
By storing the CountryID I actually meant that the _Memo_Add procedure shall get the Country.dbo._RefObjCommon and store it instead of the RefObjID that is passed to it.
I doubt that they ever gonna change the country id's when they've already considered the arabian race in the current setup
Yeah that was the only thing I was wondering about
Maybe they wanted to be able to display an icon for every char
dunno lol
What was the best character type? 03/27/2010 - Silkroad Online - 27 Replies WHAT WAS THE BEST CHARACTER TYPE???
STR BLADE???:confused:
STR GLAVIE??:confused:
NUKER SWORD/SHIELD??:confused:
NUKER SPEAR??:confused:
OR EUROPIANS AND WHAT TYPE OF BUILD AND WEAPON??
Need item type and token type boot 03/18/2008 - Conquer Online 2 - 1 Replies Hi All programers and makers of boots, Great job. Could some one make item and token type boot for patch 5118. Please
