Menu
What's new

DB scheme for allods online

al5yal511

al5yal511

Administrator
Staff member
Admin
Guide Author
This topic will talk specifically on DBs, If you have any infos you can include it here please.

  • v_ChangeRoom_Additional Accessing content of the relation gm.ChangeRoom.Additional
    • "v_ChangeRoom_Additional".id - 'record identificator';
    • "v_ChangeRoom_Additional".avatar - 'avatar id';
    • "v_ChangeRoom_Additional"."avatarLevel" - 'Avatar Level';
    • "v_ChangeRoom_Additional"."avatarRaceClass" - 'Avatar Race Class';
    • "v_ChangeRoom_Additional"."characterSex" - 'Character Sex';
    • "v_ChangeRoom_Additional"."fromMainSet" - 'true if a new variation comes from general set';
    • "v_ChangeRoom_Additional"."cost" - 'Price';
    • "v_ChangeRoom_Additional"."oldItem" - 'old visualItem';
    • "v_ChangeRoom_Additional"."newItem" - 'new visualItem';
    • "v_ChangeRoom_Additional"."eventTimestamp" - 'time of an event';
  • v_ChangeRoom_Body Accessing content of the relation gm.ChangeRoom.Body
    • "v_ChangeRoom_Body".id - 'record id';
    • "v_ChangeRoom_Body".avatar - 'avatar id';
    • "v_ChangeRoom_Body"."avatarLevel" - 'Avatar Level';
    • "v_ChangeRoom_Body"."avatarRaceClass" - 'Avatar Race Class';
    • "v_ChangeRoom_Body"."characterSex" - 'Character Sex';
    • "v_ChangeRoom_Body"."fromMainSet" - 'true if a new variation comes from general set';
    • "v_ChangeRoom_Body"."cost" - 'Price';
    • "v_ChangeRoom_Body"."oldItem" - 'Old visualItem';
    • "v_ChangeRoom_Body"."newItem" - 'New visualItem';
    • "v_ChangeRoom_Body"."eventTimestamp" - 'Time of event';
  • v_ChangeRoom_Faces Accessing content of the relation gm.ChangeRoom.Faces
    • "v_ChangeRoom_Faces".id - 'Record id';
    • "v_ChangeRoom_Faces".avatar - 'Avatar id';
    • "v_ChangeRoom_Faces"."avatarLevel" - 'Avatar Level';
    • "v_ChangeRoom_Faces"."avatarRaceClass" - 'Avatar Race Class';
    • "v_ChangeRoom_Faces"."characterSex" - 'Character Sex';
    • "v_ChangeRoom_Faces"."fromMainSet" - 'true if a new variation comes from general set';
    • "v_ChangeRoom_Faces"."cost" - 'Price';
    • "v_ChangeRoom_Faces"."oldItem" - 'Old visualItem';
    • "v_ChangeRoom_Faces"."newItem" - 'New visualItem';
    • "v_ChangeRoom_Faces"."eventTimestamp" - 'Time of event';
 
OP
al5yal511

al5yal511

Administrator
Staff member
Admin
Guide Author
  • v_ChangeRoom_Facial Accessing content of the relation gm.ChangeRoom.Facial
    • "v_ChangeRoom_Facial".id - 'Record id';
    • "v_ChangeRoom_Facial".avatar - 'Avatar id';
    • "v_ChangeRoom_Facial"."avatarLevel" - 'Avatar Level';
    • "v_ChangeRoom_Facial"."avatarRaceClass" - 'Avatar Race Class';
    • "v_ChangeRoom_Facial"."characterSex" - 'Character Sex';
    • "v_ChangeRoom_Facial"."fromMainSet" - 'true if a new variation comes from general set';
    • "v_ChangeRoom_Facial"."cost" - 'Price';
    • "v_ChangeRoom_Facial"."oldItem" - 'Old visualItem';
    • "v_ChangeRoom_Facial"."newItem" - 'New visualItem';
    • "v_ChangeRoom_Facial"."eventTimestamp" - 'Time of event';
  • v_ChangeRoom_FacialColor Accessing content of the relation gm.ChangeRoom.FacialColor
    • "v_ChangeRoom_FacialColor".id - 'Record id';
    • "v_ChangeRoom_FacialColor".avatar - 'Avatar id';
    • "v_ChangeRoom_FacialColor"."avatarLevel" - 'Avatar Level';
    • "v_ChangeRoom_FacialColor"."avatarRaceClass" - 'Avatar Race Class';
    • "v_ChangeRoom_FacialColor"."characterSex" - 'Character Sex';
    • "v_ChangeRoom_FacialColor"."fromMainSet" - 'true if a new variation comes from general set';
    • "v_ChangeRoom_FacialColor"."cost" - 'Price';
    • "v_ChangeRoom_FacialColor"."oldColor" - 'Old color';
    • "v_ChangeRoom_FacialColor"."newColor" - 'New color';
    • "v_ChangeRoom_FacialColor"."eventTimestamp" - 'Time of event';
  • v_ChangeRoom_Hairs Accessing content of the relation gm.ChangeRoom.Hairs
    • "v_ChangeRoom_Hairs".id - 'Record id';
    • "v_ChangeRoom_Hairs".avatar - 'Avatar id';
    • "v_ChangeRoom_Hairs"."avatarLevel" - 'Avatar Level';
    • "v_ChangeRoom_Hairs"."avatarRaceClass" - 'Avatar Race Class';
    • "v_ChangeRoom_Hairs"."characterSex" - 'Character Sex';
    • "v_ChangeRoom_Hairs"."fromMainSet" - 'true if a new variation comes from general set';
    • "v_ChangeRoom_Hairs"."cost" - 'Price';
    • "v_ChangeRoom_Hairs"."oldItem" - 'Old visualItem';
    • "v_ChangeRoom_Hairs"."newItem" - 'New visualItem';
    • "v_ChangeRoom_Hairs"."eventTimestamp" - 'Time of event';
  • v_ChangeRoom_HairsColor Accessing content of the relation gm.ChangeRoom.HairsColor
    • "v_ChangeRoom_HairsColor".id - 'Record id';
    • "v_ChangeRoom_HairsColor".avatar - 'Avatar id';
    • "v_ChangeRoom_HairsColor"."avatarLevel" - 'Avatar Level';
    • "v_ChangeRoom_HairsColor"."avatarRaceClass" - 'Avatar Race Class';
    • "v_ChangeRoom_HairsColor"."characterSex" - 'Character Sex';
    • "v_ChangeRoom_HairsColor"."fromMainSet" - 'true if a new variation comes from general set';
    • "v_ChangeRoom_HairsColor"."cost" - 'Price';
    • "v_ChangeRoom_HairsColor"."oldColor" - 'Old color';
    • "v_ChangeRoom_HairsColor"."newColor" - 'New color';
    • "v_ChangeRoom_HairsColor"."eventTimestamp" - 'Time of event';
  • v_ChangeRoom_PetName Accessing content of the relation gm.ChangeRoom.PetName
    • "v_ChangeRoom_PetName".id - 'Record id';
    • "v_ChangeRoom_PetName".avatar - 'Avatar id';
    • "v_ChangeRoom_PetName"."avatarLevel" - 'Avatar Level';
    • "v_ChangeRoom_PetName"."avatarRaceClass" - 'Avatar Race Class';
    • "v_ChangeRoom_PetName"."characterSex" - 'Character Sex';
    • "v_ChangeRoom_PetName"."cost" - 'Price';
    • "v_ChangeRoom_PetName"."oldItem" - 'Old variant';
    • "v_ChangeRoom_PetName"."newItem" - 'New variant';
    • "v_ChangeRoom_PetName"."eventTimestamp" - 'Time of event';
  • v_ChangeRoom_PetVisual Accessing content of the relation gm.ChangeRoom.PetVisual
    • "v_ChangeRoom_PetVisual".id - 'Record id';
    • "v_ChangeRoom_PetVisual".avatar - 'Avatar id';
    • "v_ChangeRoom_PetVisual"."avatarLevel" - 'Avatar Level';
    • "v_ChangeRoom_PetVisual"."avatarRaceClass" - 'Avatar Race Class';
    • "v_ChangeRoom_PetVisual"."characterSex" - 'Character Sex';
    • "v_ChangeRoom_PetVisual"."cost" - 'Price';
    • "v_ChangeRoom_PetVisual"."oldItem" - 'Old visualItem';
    • "v_ChangeRoom_PetVisual"."newItem" - 'New visualItem';
    • "v_ChangeRoom_PetVisual"."eventTimestamp" - 'Time of event';
  • v_ChangeRoom_SexChanged Accessing content of the relation gm.ChangeRoom.SexChanged
    • "v_ChangeRoom_SexChanged".id - 'Record id';
    • "v_ChangeRoom_SexChanged".avatar - 'Avatar id';
    • "v_ChangeRoom_SexChanged"."avatarLevel" - 'Avatar Level';
    • "v_ChangeRoom_SexChanged"."avatarRaceClass" - 'Avatar Race Class';
    • "v_ChangeRoom_SexChanged"."characterOldSex" - 'Character Old Sex';
    • "v_ChangeRoom_SexChanged"."characterNewSex" - 'Character New Sex';
    • "v_ChangeRoom_SexChanged"."cost" - 'Price';
    • "v_ChangeRoom_SexChanged"."eventTimestamp" - 'Time of event';
  • v_ChangeRoom_Skin Accessing content of the relation gm.ChangeRoom.Skin
    • "v_ChangeRoom_Skin".id - 'Record id';
    • "v_ChangeRoom_Skin".avatar - 'Avatar id';
    • "v_ChangeRoom_Skin"."avatarLevel" - 'Avatar Level';
    • "v_ChangeRoom_Skin"."avatarRaceClass" - 'Avatar Race Class';
    • "v_ChangeRoom_Skin"."characterSex" - 'Character Sex';
    • "v_ChangeRoom_Skin"."fromMainSet" - 'true if a new variation comes from general set';
    • "v_ChangeRoom_Skin"."cost" - 'Price';
    • "v_ChangeRoom_Skin"."oldItem" - 'Old visualItem';
    • "v_ChangeRoom_Skin"."newItem" - 'New visualItem';
    • "v_ChangeRoom_Skin"."eventTimestamp" - 'Time of event';
 
OP
al5yal511

al5yal511

Administrator
Staff member
Admin
Guide Author
  • v_ChangeRoom_SkinColor Accessing content of the relation gm.ChangeRoom.SkinColor
    • "v_ChangeRoom_SkinColor".id - 'Record id';
    • "v_ChangeRoom_SkinColor".avatar - 'Avatar id';
    • "v_ChangeRoom_SkinColor"."avatarLevel" - 'Avatar Level';
    • "v_ChangeRoom_SkinColor"."avatarRaceClass" - 'Avatar Race Class';
    • "v_ChangeRoom_SkinColor"."characterSex" - 'Character Sex';
    • "v_ChangeRoom_SkinColor"."fromMainSet" - 'true if a new variation comes from general set';
    • "v_ChangeRoom_SkinColor"."cost" - 'Price';
    • "v_ChangeRoom_SkinColor"."oldColor" - 'Old color';
    • "v_ChangeRoom_SkinColor"."newColor" - 'New color';
    • "v_ChangeRoom_SkinColor"."eventTimestamp" - 'Time of event';
  • v_account_ReferralAdded
    • "v_account_ReferralAdded".id - 'Record id';
    • "v_account_ReferralAdded"."eventTimestamp" - 'Time of event';
    • "v_account_ReferralAdded".account - 'Referral account (who is invited)';
    • "v_account_ReferralAdded"."accountReffOwner" - 'Referrer account (who invites)';
  • v_astral_chest_avatar_history
    • v_astral_chest_avatar_history.id - 'Id of this record';
    • v_astral_chest_avatar_history."chestHistory" - 'Id of record in chest history';
    • v_astral_chest_avatar_history.avatar - 'Avatar id that can share loot of chest';
  • v_astral_chest_bound_history
    • v_astral_chest_bound_history.id - 'Id of history record';
    • v_astral_chest_bound_history."settledTimestamp" - 'Moment when chest occured/dissapeared on ship';
    • v_astral_chest_bound_history.ship - 'Ship where chest occured/dissapeared';
    • v_astral_chest_bound_history."isBound" - 'Whether chest was bound or unbound from ship';
  • v_astral_chest_drops
    • v_astral_chest_drops.id - 'Drop record id';
    • v_astral_chest_drops.shard - 'Shard where drop occured';
    • v_astral_chest_drops."chestResource" - 'Resource of dropped chest';
    • v_astral_chest_drops."islandResource" - 'Resource of island where chest dropped';
    • v_astral_chest_drops."mobResource" - 'Resource of mob who dropped chest';
    • v_astral_chest_drops."eventTimestamp" - 'Moment when chest was dropped';
  • v_astral_chest_history
    • v_astral_chest_history.id - 'Id of history record';
    • v_astral_chest_history."settledTimestamp" - 'Moment when chest occured on ship';
    • v_astral_chest_history.ship - 'Ship where chest occured';
  • v_astral_chest_items
    • v_astral_chest_items.id - 'Unique id of chest item information';
    • v_astral_chest_items.chest - 'Chest id that contains item';
    • v_astral_chest_items."itemResource" - 'Resource of item';
  • v_astral_chests
    • v_astral_chests.id - 'Unique id of chest in gametool';
    • v_astral_chests.shard - 'Shard id';
    • v_astral_chests.ship - 'Ship id where chest was last';
    • v_astral_chests."chestResource" - 'Resource of chest';
    • v_astral_chests."isLost" - 'True when chest is lost';
    • v_astral_chests."lostTimestamp" - 'Moment of lost or null if chest was not lost';
    • v_astral_chests."isOpened" - 'True when chest is opened';
    • v_astral_chests."openTimestamp" - 'Moment when chest was opened or null if chest was not opened';
  • v_astral_island_farm
    • v_astral_island_farm.id - 'Record id';
    • v_astral_island_farm."enterTimestamp" - 'Time of entering island';
    • v_astral_island_farm."exitTimestamp" - 'Time of leaving island';
    • v_astral_island_farm."islandResource" - 'island resource id';
    • v_astral_island_farm."isBossKilled" - 'Is final boss killed';
    • v_astral_island_farm."bossDeathTimestamp" - 'Time of boss kill';
    • v_astral_island_farm."bossResource" - 'Killed boss resource id';
    • v_astral_island_farm.ship - 'Ship';
  • v_astral_ship_dead
    • v_astral_ship_dead."eventTimestamp" - 'Time of death';
    • v_astral_ship_dead.code - 'Event type: P - PvP, E - PvE, I - Instability zone, D - unknown';
    • v_astral_ship_dead.ship - 'destroyed ship id';
    • v_astral_ship_dead."killerResource" - 'if PvE - mob resource id';
    • v_astral_ship_dead."killerShip" - 'if PvP – killer ship id';
  • v_auction_buy Log of buying items in the auction
    • v_auction_buy.creater - 'Id of owner avatar';
    • v_auction_buy.winner - 'Id of avatar who purchased the lot';
    • v_auction_buy."createTime" - 'Time of action lot creation';
    • v_auction_buy."startPrice" - 'Starting price';
    • v_auction_buy."buyPrice" - 'Purchasing price';
    • v_auction_buy."itemResourceId" - 'ResourceId of the item';
    • v_auction_buy."itemType" - 'Type of item resource (can be empty in case of non-actual resource xml file in gametool)';
    • v_auction_buy."itemName" - 'Name of item resource (can be empty in case of non-actual resource xml file in gametool)';
    • v_auction_buy."runeResourceId" - 'ResourceId of the item rune (0 in the case of absence)';
    • v_auction_buy."runeName" - 'Name of item rune resource (can be empty in case of absence or non-actual resource xml file in gametool)';
    • v_auction_buy."itemCount" - 'Count of item instances';
  • v_avatar
    • v_avatar.title - 'Name of avatar';
    • v_avatar."avatarId" - 'Id of avatar inside shard';
    • v_avatar."userId" - 'Id of account';
    • v_avatar."typeResource" - 'Resource of race-class combination';
    • v_avatar."registrationTimestamp" - 'Moment of registration in gametool DB';
    • v_avatar."login" - 'Account name';
    • v_avatar."recentLoginTimestamp" - 'Last login moment';
    • v_avatar."currentGuildId" - 'Id of current avatar guild';
    • v_avatar."level" - 'Level of avatar';
    • v_avatar.honor - 'Honor of avatar';
    • v_avatar."isDeleted" - 'Indicates whether avatar deleted or not on shard';
    • v_avatar."isOnline" - 'Indicates whether avatar online or not on shard';
    • v_avatar."synchronizationTimestamp" - 'Moment of last synchronization of avatar data with shard';
    • v_avatar.race - 'Resource of avatar race';
    • v_avatar."class" - 'Resource of avatar class';
    • v_avatar.racename - 'Name of avatar race';
    • v_avatar.classname - 'Name of avatar class';
    • v_avatar."recentAddress" - 'Recent avatar address on shard';
    • v_avatar.shard - 'Id of shard of avatar';
    • v_avatar."shardName" - 'Name of shard';
    • v_avatar.soul - 'Soul (equals to soulId from shard)';
    • v_avatar."remortParent" - 'Main avatar (not null for remorts)';
  • v_avatar_achievement Accessing content of the relation gm.avatar.achievement
    • v_avatar_achievement.id - 'Record id';
    • v_avatar_achievement.map - 'Event map';
    • v_avatar_achievement."mapAddress" - 'map address';
    • v_avatar_achievement."avatarId" - 'Avatar';
    • v_avatar_achievement.achievement - 'achievement';
    • v_avatar_achievement."shardTime" - 'achievement time';
    • v_avatar_achievement."eventTimestamp" - 'Time of event';
  • v_avatar_brief
    • v_avatar_brief.title - 'Name';
    • v_avatar_brief."avatarId" - 'Avatar id on the shard';
    • v_avatar_brief."userId" - 'Account id';
    • v_avatar_brief."typeResource" - 'race-class combination resource';
    • v_avatar_brief."registrationTimestamp" - 'registration date in the base';
    • v_avatar_brief."deleteTimestamp" - 'deletion date';
    • v_avatar_brief."login" - 'Account';
    • v_avatar_brief."recentLoginTimestamp" - 'last login date';
    • v_avatar_brief."recentLogoutTimestamp" - 'last logout date';
    • v_avatar_brief."currentGuildId" - 'Guild';
    • v_avatar_brief."level" - 'Level';
    • v_avatar_brief.honor - 'Honor';
    • v_avatar_brief."isDeleted" - 'shard deletion flag';
    • v_avatar_brief."isNoStat" - ' statistic exception flag';
    • v_avatar_brief."isOnline" - 'online flag';
    • v_avatar_brief."synchronizationTimestamp" - 'last shard synchronization date';
    • v_avatar_brief."raceResource" - 'Race resource';
    • v_avatar_brief."classResource" - 'class resource';
    • v_avatar_brief."recentAddress" - 'last net address';
    • v_avatar_brief.shard - 'shard';
    • v_avatar_brief.soul - 'soul (same as soulId in the shard database)';
    • v_avatar_brief."remortParent" - 'main avatar (if incarnation then is not equal null)';
  • v_avatar_craft current avatar profession skills
    • v_avatar_craft.avatar - 'same as gm.avatar id table';
    • v_avatar_craft."craftResource" - 'profession resource';
    • v_avatar_craft.score - 'profession level';
  • v_avatar_explog Log of avatar experience
    • v_avatar_explog."operationCode" - 'Reason of experience';
    • v_avatar_explog."questResource" - 'Resource of quest';
    • v_avatar_explog."containerResource" - 'Container resource where impact referenced';
    • v_avatar_explog.caster - 'Id of avatar that casted';
    • v_avatar_explog."mobResource" - 'Resource of mob';
    • v_avatar_explog."value" - 'Experience';
    • v_avatar_explog."valueForRate" - 'Experience part given for rates';
    • v_avatar_explog.avatar - 'If of recipient avatar';
    • v_avatar_explog."level" - 'Level of recipient avatar';
  • v_avatar_honor
    • ???
  • v_avatar_inoutmap Accessing content of the relation gm.avatar.inoutmap
    • v_avatar_inoutmap.id - 'Record id';
    • v_avatar_inoutmap.avatar - 'Avatar id';
    • v_avatar_inoutmap."avatarLevel" - 'Avatar Level';
    • v_avatar_inoutmap.map - 'Map';
    • v_avatar_inoutmap."mapAddress" - 'Map address';
    • v_avatar_inoutmap.enter - 'enters (leaves) map';
    • v_avatar_inoutmap."eventTimestamp" - 'Time of event';
  • v_avatar_kill_avatar Log of avatar murber by avatar
    • v_avatar_kill_avatar.id - 'Primary key';
    • v_avatar_kill_avatar."eventTimestamp" - 'Moment of event';
    • v_avatar_kill_avatar."eventSubjtime" - 'Subjective time of killer';
    • v_avatar_kill_avatar."zoneResource" - 'Zone resource of murder';
    • v_avatar_kill_avatar."mapResource" - 'Map resource of murder';
    • v_avatar_kill_avatar."victimLevel" - 'Level of victim';
    • v_avatar_kill_avatar."victimRaceResource" - 'Resource of victim race';
    • v_avatar_kill_avatar."victimClassResource" - 'Resource of victim class';
    • v_avatar_kill_avatar.killer - 'Killer avatar id';
    • v_avatar_kill_avatar.victim - 'Victim avatar id';
 
OP
al5yal511

al5yal511

Administrator
Staff member
Admin
Guide Author
  • v_avatar_kill_mob Log of murder of mob by avatar
    • v_avatar_kill_mob.id - 'Primary key';
    • v_avatar_kill_mob."eventTimestamp" - 'Moment of murder event';
    • v_avatar_kill_mob."mobResource" - 'Resource of killed mob';
    • v_avatar_kill_mob."mapResource" - 'Resource of map where murder occured';
    • v_avatar_kill_mob."xCoordinate" - 'x';
    • v_avatar_kill_mob."yCoordinate" - 'y';
    • v_avatar_kill_mob."zCoordinate" - 'z';
    • v_avatar_kill_mob."zoneResource" - 'Zone resource';
    • v_avatar_kill_mob."experienceBefore" - 'Experience before event';
    • v_avatar_kill_mob."experienceAdd" - 'Added experience';
    • v_avatar_kill_mob."reputationFraction" - 'Fraction';
    • v_avatar_kill_mob."reputationBefore" - 'Reputation before event';
    • v_avatar_kill_mob."reputationAdd" - 'Added reputation';
    • v_avatar_kill_mob."killerLevel" - 'Killers level at the time of the event';
    • v_avatar_kill_mob.money - 'Money for murder';
    • v_avatar_kill_mob.killer - 'Killer avatar id on shard';
  • v_avatar_kill_mob_items Items related to mob murder by avatar
    • v_avatar_kill_mob_items.id - 'Primary key';
    • v_avatar_kill_mob_items."itemResource" - 'Resource of item';
    • v_avatar_kill_mob_items.count - 'Count of items';
    • v_avatar_kill_mob_items."killEntry" - 'Reference to master id in v_avatar_kill_mob';
  • v_avatar_levelup_diff
    • v_avatar_levelup_diff."level" - 'New level of levelup';
    • v_avatar_levelup_diff.min_stime - 'Minimum subject time between level-1 and level during last 90 days';
    • v_avatar_levelup_diff.avg_stime - 'Average subject time between level-1 and level during last 90 days';
    • v_avatar_levelup_diff.max_stime - 'Maximum subject time between level-1 and level during last 90 days';
    • v_avatar_levelup_diff.size - 'Count of avatars that go through this level during last 90 days';
  • v_avatar_levelups
    • v_avatar_levelups."level" - 'New level of levelup';
    • v_avatar_levelups."time" - 'Moment of levelup';
    • v_avatar_levelups.map - 'Place of levelup (map resource)';
    • v_avatar_levelups.x - 'X-coordinate of levelup';
    • v_avatar_levelups.y - 'Y-coordinate of levelup';
    • v_avatar_levelups.z - 'Z-coordinate of levelup';
  • v_avatar_moneydelta Log of avatar money change
    • v_avatar_moneydelta.money - 'Money of avatar';
    • v_avatar_moneydelta."level" - 'Level of avatar at the moment';
    • v_avatar_moneydelta.avatar - 'Id of avatar';
  • v_avatar_quest Log of avatar quests
    • v_avatar_quest."questResource" - 'Quest resource';
    • v_avatar_quest."takeTimestamp" - 'Moment of taking quest';
    • v_avatar_quest."completeTimestamp" - 'Moment of completing quest';
    • v_avatar_quest."cancelTimestamp" - 'Moment of cancelling quest';
    • v_avatar_quest."experienceGained" - 'Experience as quest reward';
    • v_avatar_quest."moneyGained" - 'Money as quest reward';
    • v_avatar_quest."rewardResource" - 'Resource of reward';
    • v_avatar_quest."errorText" - 'Error (e.g. no space in bag)';
    • v_avatar_quest."isClosed" - 'Quest inactivity flag';
    • v_avatar_quest.avatar - 'Id of avatar';
  • v_avatar_quest_event Accessing content of the relation gm.avatar.quest.event
    • v_avatar_quest_event."eventCode" - 'Event code: take/cancel/complete';
    • v_avatar_quest_event."eventTimestamp" - 'Time of event';
    • v_avatar_quest_event."questResource" - 'Quest resource';
    • v_avatar_quest_event."eventSubjtime" - 'Ingame time event';
    • v_avatar_quest_event."experienceGained" - 'gained experience';
    • v_avatar_quest_event."moneyGained" - 'earned money';
    • v_avatar_quest_event."rewardResource" - 'reward id';
    • v_avatar_quest_event."errorText" - 'Error (e.g., [no space in bag])';
    • v_avatar_quest_event.avatar - 'Avatar';
  • v_avatar_rename Accessing content of the relation gm.avatar.rename
    • v_avatar_rename.id - 'Record id';
    • v_avatar_rename."newName" - 'new avatar name';
    • v_avatar_rename."oldName" - 'old avatar name';
    • v_avatar_rename."renameTimestamp" - 'time of rename';
    • v_avatar_rename.avatar - 'Avatar';
  • v_avatar_runes
    • ???
  • v_avatar_sell_item Log of selling items to vendors
    • v_avatar_sell_item.avatar - 'Id of avatar';
    • v_avatar_sell_item."eventTimestamp" - 'Moment of selling event';
    • v_avatar_sell_item."itemResourceId" - 'ResourceId of the item';
    • v_avatar_sell_item."itemType" - 'Type of item resource (can be empty in case of non-actual resource xml file in gametool)';
    • v_avatar_sell_item."itemName" - 'Name of item resource (can be empty in case of non-actual resource xml file in gametool)';
    • v_avatar_sell_item."itemCount" - 'Count of item instances';
    • v_avatar_sell_item."cost" - 'Common money amount got from vendor';
    • v_avatar_sell_item."vendorResourceId" - 'ResourceId of vendor';
    • v_avatar_sell_item."vendorType" - 'Type of vendor resource (can be empty in case of non-actual resource xml file in gametool)';
    • v_avatar_sell_item."vendorName" - 'Name of vendor resource (can be empty in case of non-actual resource xml file in gametool)';
  • v_billing_AccountChange Accessing content of the relation gm.billing.AccountChange
    • "v_billing_AccountChange".id - 'Record id';
    • "v_billing_AccountChange".account - 'account name.';
    • "v_billing_AccountChange".money - 'sum, which is operated';
    • "v_billing_AccountChange".currency - 'Currency';
    • "v_billing_AccountChange"."operatorMoney" - 'spent operator money';
    • "v_billing_AccountChange".operation - 'operation name.';
    • "v_billing_AccountChange"."txId" - 'transaction id.';
    • "v_billing_AccountChange"."eventTimestamp" - 'Time of event';
  • v_billing_ReferralChanged First set or change of referrer deduction from referral buys in alternative currency.
    • "v_billing_ReferralChanged".id - 'Record id';
    • "v_billing_ReferralChanged"."eventTimestamp" - 'Time of event';
    • "v_billing_ReferralChanged".account - 'Account';
    • "v_billing_ReferralChanged"."accountOwner" - 'targeted account (who receives money)';
    • "v_billing_ReferralChanged".percent - 'potential deducted percent';
  • v_billing_entry Log of billing
    • v_billing_entry."timestamp" - 'Moment of event';
    • v_billing_entry."login" - 'Account login';
    • v_billing_entry.code - 'Event code';
    • v_billing_entry."currencyCode" - 'Currency';
    • v_billing_entry.money - 'Money amount';
    • v_billing_entry."originalId" - 'Id of original operation';
    • v_billing_entry."alternativeMoney" - 'Alternative money amount';
  • v_billing_entry_dupe Accessing content of the relation gm.billing.entry.dupe
    • v_billing_entry_dupe.id - 'Record id';
    • v_billing_entry_dupe."timestamp" - 'Дата события';
    • v_billing_entry_dupe."login" - 'Account';
    • v_billing_entry_dupe.code - 'Event code';
    • v_billing_entry_dupe."currencyCode" - 'Currency code';
    • v_billing_entry_dupe.money - 'money';
    • v_billing_entry_dupe."originalId" - 'original operation ID ;
    • v_billing_entry_dupe."alternativeMoney" - 'alternative currency which referrer receives';
  • v_billing_item Element of billing log (entry can contain more than one element)
    • v_billing_item.operation - 'Reference to the billing entry id';
    • v_billing_item.resource - 'Resource of item';
    • v_billing_item."stackCount" - 'Count of items in stack';
  • v_bosskill Accessing content of the relation gm.bosskill
    • v_bosskill.id - 'Record id';
    • v_bosskill."eventTimestamp" - 'Boss kill time';
    • v_bosskill."bossResource" - 'Resource босса';
    • v_bosskill."isFinal" - 'Final boss flag';
    • v_bosskill.ship - 'ship';
  • v_bosskill_killer Accessing content of the relation gm.bosskill.killer
    • v_bosskill_killer.id - 'Record id';
    • v_bosskill_killer."eventTimestamp" - 'Boss kill time';
    • v_bosskill_killer."bossResource" - 'Resource босса';
    • v_bosskill_killer."isFinal" - 'Final boss flag';
    • v_bosskill_killer.ship - ship;
    • v_bosskill_killer.avatar - 'Avatar';
    • v_bosskill_killer.event - 'Event';
  • v_client_hack Accessing content of the relation gm.client.hack
    • v_client_hack.id - 'Record id';
    • v_client_hack.avatar - 'Avatar id';
    • v_client_hack.reason - 'code of cheat: 0 - PROTECTION_THREAD, 1 - SYSTEM_TIME, 2 - MEMORY_CHANGED_POSITION, 3 - MEMORY_CHANGED_SPEED';
    • v_client_hack.info - 'test description';
    • v_client_hack."cheatCode" - cheat type'';
    • v_client_hack."timestamp" - 'Time of event';
 
OP
al5yal511

al5yal511

Administrator
Staff member
Admin
Guide Author
  • v_contest_reward Accessing content of the relation gm.ContestReward
    • v_contest_reward.id - 'Record id';
    • v_contest_reward.avatar - 'Avatar id';
    • v_contest_reward.place - 'avatar prize-winning place';
    • v_contest_reward.reward - 'item which is given to avatar as reward';
    • v_contest_reward."stackCount" - 'item quantity, which is given to avatar as reward ';
    • v_contest_reward."contestResource" - 'contest Resource';
    • v_contest_reward.score - 'amount of opened chests';
    • v_contest_reward."eventTimestamp" - 'Time of event';
  • v_core_entity_stat_detail Accessing content of the relation core.entity.stat.detail
    • v_core_entity_stat_detail.id - 'Record id';
    • v_core_entity_stat_detail."timestamp" - 'time stamp';
    • v_core_entity_stat_detail.entity - 'entity';
    • v_core_entity_stat_detail."createCount" - 'Number of created class emtity';
    • v_core_entity_stat_detail."loadCount" - 'Number of loads';
    • v_core_entity_stat_detail."insertCount" - 'number of insterts';
    • v_core_entity_stat_detail."updateCount" - 'number of renews;
    • v_core_entity_stat_detail."deleteCount" - 'number of deletions';
    • v_core_entity_stat_detail."duplicateCount" - 'number of duplicates';
    • v_core_entity_stat_detail."minTimestamp" - 'min time (for segmented tables)';
    • v_core_entity_stat_detail."maxTimestamp" - 'max time (for segmented tables)';
    • v_core_entity_stat_detail."group" - 'metrics group;
  • v_core_entity_stat_group Accessing content of the relation core.entity.stat.group
    • v_core_entity_stat_group.id - 'Record id';
    • v_core_entity_stat_group."timestamp" - 'time of taking metrics';
    • v_core_entity_stat_group."durationSec" - 'taking metrics duration (сек.)';
v_craft_alchemy
v_craft_alchemy_items
v_craft_armor
v_craft_armor_items
v_craft_disasm
v_craft_disasm_items
v_craft_foraging
v_craft_foraging_items

  • v_currency_reserve Accessing content of the relation gm.currency.reserve
    • v_currency_reserve.id - 'Record id';
    • v_currency_reserve."crystalReserveModification" - this value represents number of crystal reserve change
    • v_currency_reserve."moneyReserveModification" - this value represents number of money reserve change
    • v_currency_reserve.kind - 'type of change (см. CurrencyExchangeReserveModificationKind enum)';
    • v_currency_reserve."eventTimestamp" - 'Time of event';
  • v_currency_status Accessing content of the relation gm.currency.status
    • v_currency_status.id - 'Record id';
    • v_currency_status.status - new Status of currency exchange service (see CurrencyExchangeServiceStatus enum)';
    • v_currency_status."eventTimestamp" - 'Time of event';
  • v_currency_transaction Accessing content of the relation gm.currency.transaction
    • v_currency_transaction.id - 'Record id';
    • v_currency_transaction.avatar - 'Avatar id';
    • v_currency_transaction."crystalsBought" - amount of crystals received ( "-" stands for sell)
    • v_currency_transaction."moneySpent" - amount of money received ( "-" stands for sell)
    • v_currency_transaction."rateDeviation" - real to planned rate deviation
    • v_currency_transaction."newRate" - new rate (without tax)
    • v_currency_transaction."moneyDestroyed" - money lost by taxes
    • v_currency_transaction.result - 'operation result (see CurrencyExchangeResultCode enum)';
    • v_currency_transaction."eventTimestamp" - 'Time of event';
  • v_currency_tunnel Accessing content of the relation gm.currency.tunnel
    • v_currency_tunnel.id - 'Record id';
    • v_currency_tunnel."lowerBound" - lower rate bound
    • v_currency_tunnel."upperBound" - upper rate bound
    • v_currency_tunnel."eventTimestamp" - 'Time of event';
  • v_explog_agg Accessing content of the relation gm.avatar.explog.agg
    • v_explog_agg.id - 'Record id';
    • v_explog_agg."dayTimestamp" - 'time';
    • v_explog_agg.avatar - 'Avatar
    • v_explog_agg."operationCode" - 'operation code';
    • v_explog_agg."sumValue" - 'total experience';
  • v_fairy_feed
  • v_guild Guilds
    • v_guild."guildId" - 'guild id on guild base';
    • v_guild.title -guild name
    • v_guild."createTimestamp" - 'creation time
    • v_guild."disbandTimestamp" -disband time
    • v_guild."isDisbanded" -is guild disbanded?
    • v_guild."level" - guild level
    • v_guild.symbol - 'herldic';
    • v_guild.authority - 'authprity';
    • v_guild.shard - 'Shard';
    • v_guild."owner" - 'guild leader';
    • v_guild.founder - 'first leader of guild';
  • v_guild_authority guild authority changing history
    • v_guild_authority.id - 'Record id';
    • v_guild_authority."eventTimestamp" - 'time of change';
    • v_guild_authority."totalAuthority" - 'total authority';
    • v_guild_authority."addedAuthority" - 'added authority';
    • v_guild_authority."providerResource" - what caused gaining authority
    • v_guild_authority.avatar - who brought
    • v_guild_authority.guild - 'Guild';
 
OP
al5yal511

al5yal511

Administrator
Staff member
Admin
Guide Author
  • v_guild_log_level Accessing content of the relation gm.guild.log.level
    • v_guild_log_level."eventTimestamp" - 'Time of event';
    • v_guild_log_level.guild - 'Guild';
  • v_guild_log_member Accessing content of the relation gm.guild.log.member
    • v_guild_log_member."eventTimestamp" - 'Time of event';
    • v_guild_log_member."operationCode" - 'operation code: add, remove, leader';
    • v_guild_log_member.avatar -who brought
    • v_guild_log_member.guild - 'Guild';
  • v_guild_log_rank Accessing content of the relation gm.guild.log.rank
    • v_guild_log_rank."eventTimestamp" - 'Time of event';
    • v_guild_log_rank."rankId" - 'rank id in shard database';
    • v_guild_log_rank.avatar - who brought
    • v_guild_log_rank.guild - 'Guild';
  • v_guild_member Guild members
    • v_guild_member."memberId" - 'member id in guild base';
    • v_guild_member."guildId" - 'guild id in guild base'';
    • v_guild_member."rankId" - rank id in guild base';
    • v_guild_member.authority - 'member authority
    • v_guild_member.shard - 'Shard';
    • v_guild_member.guild - 'Guild';
    • v_guild_member.avatar - 'member';
  • v_guild_rank_type Accessing content of the relation gm.guild.rank.type
    • v_guild_rank_type."rankId" -rank id in guild base';
    • v_guild_rank_type."rankResource" - 'id resourceof rank';
    • v_guild_rank_type.guild - 'Guild';
  • v_guild_symbol Accessing content of the relation gm.guild.symbol
    • v_guild_symbol."timestamp" - 'heraldics renew time;
    • v_guild_symbol.guild - 'Guild';
  • v_item_metaupgrade Accessing content of the relation gm.item.metaupgrade
    • v_item_metaupgrade.id - 'Record id';
    • v_item_metaupgrade.avatar - 'Avatar';
    • v_item_metaupgrade."itemSource" - 'Resource of upgrading item';
    • v_item_metaupgrade."sourceCursed" - 'is upgraded item cursed;
    • v_item_metaupgrade."upgradeProvider" - 'Resource of upgrader item';
    • v_item_metaupgrade."providerCursed" - 'is upgrader item cursed;
    • v_item_metaupgrade."sourceQuality" - 'initial item quality;
    • v_item_metaupgrade."resultQuality" - 'result item quality';
    • v_item_metaupgrade.agent - 'reagent Resource';
    • v_item_metaupgrade.count - 'number of reagents';
    • v_item_metaupgrade."cost" - 'Price of upgrade';
    • v_item_metaupgrade.success - 'result;
    • v_item_metaupgrade."resultCursed" - 'is result cursed';
    • v_item_metaupgrade."resultItemStateType" - 'type of item state';
    • v_item_metaupgrade."resultItemStateData" - 'data of item state';
    • v_item_metaupgrade."eventTimestamp" - 'Time of event';
  • v_itemopen_extracted Accessing content of the relation gm.itemopen.extracted
    • v_itemopen_extracted.id - 'Record id';
    • v_itemopen_extracted."eventTimestamp" - 'time';
    • v_itemopen_extracted."itemId" - 'ID of extracted item';
    • v_itemopen_extracted."itemResource" - 'Resource of extracted item';
    • v_itemopen_extracted.count - 'number of items in stack';
    • v_itemopen_extracted."runeResource" - Rune
    • v_itemopen_extracted."itemStateType" - 'type of item state';
    • v_itemopen_extracted."itemStateData" -'data of item state';
    • v_itemopen_extracted.operation - 'operation that causes exctraction of item;
  • v_itemopen_master Accessing content of the relation gm.itemopen.master
    • v_itemopen_master.id - 'Record id';
    • v_itemopen_master."eventTimestamp" - 'time';
    • v_itemopen_master."masterItemId" - 'ID of opened item';
    • v_itemopen_master."masterItemResource" - 'Resource of opened item
    • v_itemopen_master."actionCode" - 'operation type;
    • v_itemopen_master.gold - 'gold given by opening
    • v_itemopen_master.avatar - 'Avatar who opened
  • v_itemoper Accessing content of the relation gm.itemoper
    • v_itemoper."eventTimestamp" - 'time';
    • v_itemoper.code - 'add (receiveing item excluding exchange, see table actionKindCode), destroy (see поле actionKindCode), sell (sell to vendor), buy (buy from vendor)';
    • v_itemoper.count - 'number of items
    • v_itemoper."cost" - 'money receiving (from sell) or given (for buy) to vendor';
    • v_itemoper."actionResource" - 'Id resource of operation (quest, spell, etc)';
    • v_itemoper."actionKindCode" - 'for code=add
      , values TakeLoot, QuestReward, AddItemImpact, ConvertItems, CreateRune, CreateItemOnExtractingRune, CreateItemOnMakingRuneSlot, QuestReward, CreateItemCheat, QuestCheat, fore code=destroy
      , values ConsumeItemByResource, DestroyItem, ConsumeMatsOnShipRepair, ConvertItems, DropItem, DestroyRuneOnInsert, DestroyItemOnDisassemble, DeathInsuranceUse, RemoveQuestItem, ClearQuestGivenItems;
    • v_itemoper."itemResource" - 'Id resourceа of item
    • v_itemoper."questResource" - is not used yet
    • v_itemoper."npcResource" - 'only for code sell or buy';
    • v_itemoper."moneyInvited" - is not used yet
    • v_itemoper."moneyId" - 'Id operation to which alternative currency buy data is linked
    • v_itemoper."itemId" - 'Id of item';
    • v_itemoper."itemStateType" - 'type of item state';
    • v_itemoper."itemStateData" - 'data of item state';
    • v_itemoper.avatar - 'Avatar';
  • v_itemoper_altcurrency Accessing content of the relation gm.itemoper.altcurrency
    • v_itemoper_altcurrency.currency - currency
    • v_itemoper_altcurrency.price - price
    • v_itemoper_altcurrency."moneyId" - 'id of operation to link AvatarMoneyChannel';
    • v_itemoper_altcurrency."eventTimestamp" - 'Time of event';
  • v_mail Accessing content of the relation gm.mail
    • v_mail.id - 'Record id';
    • v_mail."mailId" - mail code';
    • v_mail.subject - 'subject';
    • v_mail.body - 'mail body;
    • v_mail.money - 'attached money';
    • v_mail."sentTimestamp" - 'send date';
    • v_mail."receiveTimestamp" - 'receive date';
    • v_mail."extractTimestamp" - 'date of extracting contents';
    • v_mail."mailResource" - 'Resource of system message
    • v_mail."fromAvatar" - sender
    • v_mail."toAvatar" - 'receiver
    • v_mail."recentEvent" - 'last event';
    • v_mail.shard - 'Shard';
  • v_mail_event Accessing content of the relation gm.mail.event
    • v_mail_event.id - 'Record id';
    • v_mail_event.status - state
    • v_mail_event."eventTimestamp" - 'date of event;
    • v_mail_event.mail - mail
  • v_mail_item Accessing content of the relation gm.mail.item
    • v_mail_item.id - 'Record id';
    • v_mail_item."itemResource" - 'Resource of item;
    • v_mail_item."runeResource" - 'Resource of rune
    • v_mail_item."slotPosition" - slot
    • v_mail_item."stackCount" - 'number in stack
    • v_mail_item.counter - counter
    • v_mail_item."itemId" - 'Id of item in Shard database';
    • v_mail_item."itemStateType" - 'type of item state';
    • v_mail_item."itemStateData" - 'data of item state';
    • v_mail_item.mail - 'mail
  • v_mail_itemremovestate Accessing content of the relation gm.mail.itemremovestate
    • v_mail_itemremovestate.id - 'Record id';
    • v_mail_itemremovestate.avatar - 'Avatar who extracted items (if no so it is mail owner)';
    • v_mail_itemremovestate."mailId" - 'mail Id
    • v_mail_itemremovestate."slotPosition" - 'slot number of item in mail
    • v_mail_itemremovestate."itemId" - 'Id of item on shard
    • v_mail_itemremovestate.state - State: 0 - taken in bag, 1 - deleted by avatar, 2 -deleted by system in case of lifetime, 3 - lifetime (not supported yet)
    • v_mail_itemremovestate."eventTimestamp" - 'Time of event';
 
OP
al5yal511

al5yal511

Administrator
Staff member
Admin
Guide Author
  • v_mall_SpendAltAccount alternative currency transfer from account to avatar
    • "v_mall_SpendAltAccount".id - 'Record id';
    • "v_mall_SpendAltAccount"."eventTimestamp" - 'Time of event';
    • "v_mall_SpendAltAccount".account - 'Account which spent';
    • "v_mall_SpendAltAccount"."avatarId" - 'Avatar id who receives currency';
    • "v_mall_SpendAltAccount".shard - 'Shard where avatar is';
    • "v_mall_SpendAltAccount".currency - 'currency which is transferred
    • "v_mall_SpendAltAccount".money - 'amount of spent currency
    • "v_mall_SpendAltAccount"."left" - 'amount of remained currency
  • v_mall_obligation Accessing content of the relation gm.mall.obligation
    • v_mall_obligation.id - 'Record id';
    • v_mall_obligation.account - 'Account who bought';
    • v_mall_obligation.avatar - 'Avatar id (on Shard), who sold.';
    • v_mall_obligation."avatarLevel" - 'level of avatar who sold.';
    • v_mall_obligation.shard - 'Shard on which avatar is';
    • v_mall_obligation.amount - 'sum of common crystals.';
    • v_mall_obligation."bonusAmount" - 'sum of bonus crystals.';
    • v_mall_obligation."leftMoney" - 'normal money remain';
    • v_mall_obligation."leftBonusMoney" - 'current bonus money';
    • v_mall_obligation."itemResourceId" - 'ResourceId of used item;
    • v_mall_obligation."stackCount" - 'number.';
    • v_mall_obligation."bundleId" - 'Id of bundle
    • v_mall_obligation."itemStateType" - type of item state
    • v_mall_obligation."itemStateData" - data of item state
    • v_mall_obligation."eventTimestamp" - 'Time of event';
  • v_mall_operation Log of operations with ItemMall
    • v_mall_operation.count - 'Count of items';
    • v_mall_operation."moneyAmount" - 'Money';
    • v_mall_operation.operation - 'Code of performed operation';
    • v_mall_operation.account - 'User account';
    • v_mall_operation.avatar - 'Id of avatar for operation';
    • v_mall_operation."level" - 'Avatar level';
    • v_mall_operation.currency - 'Currency of operation';
  • v_marry_divorce marriage history
    • v_marry_divorce."eventTimestamp" - 'Time of event';
    • v_marry_divorce."familyId" - 'Id of family in Shard database';
    • v_marry_divorce."isDivorce" - divorce (if no then marriage)';
    • v_marry_divorce."providerResource" - 'Resource-provider (only if isDivorce)';
    • v_marry_divorce.husband - 'Avatar-husband
    • v_marry_divorce.wife - 'Avatar-wife
  • v_matchmaking_achievements Accessing content of the relation gm.matchmaking.achievements
    • v_matchmaking_achievements.id - 'Record id';
    • v_matchmaking_achievements."eventId" - 'Id to connect to event ending table;
    • v_matchmaking_achievements.mark - 'group mark
    • v_matchmaking_achievements.achievement - 'achievment type
    • v_matchmaking_achievements."achievementCount" - 'number';
    • v_matchmaking_achievements."eventTimestamp" - 'Time of event';
    • v_matchmaking_achievements.shard - 'Shard';
  • v_matchmaking_in_out Accessing content of the relation gm.matchmaking.in.out
    • v_matchmaking_in_out.id - 'Record id';
    • v_matchmaking_in_out."eventId" -'Id to connect to event ending table;
    • v_matchmaking_in_out."avatarId" - 'Avatar id';
    • v_matchmaking_in_out.mark - 'mark
    • v_matchmaking_in_out."inOut" - '1 - in / 0 - out
    • v_matchmaking_in_out."eventTimestamp" - 'Time of event';
    • v_matchmaking_in_out.shard - 'Shard';
  • v_matchmaking_start Accessing content of the relation gm.matchmaking.start
    • v_matchmaking_start.id - 'Record id';
    • v_matchmaking_start.event - 'Resource of event
    • v_matchmaking_start."eventId" - 'Id of event to link to event ending
    • v_matchmaking_start."eventAddress" - 'Avatar';
    • v_matchmaking_start."minLevel" - min player's level
    • v_matchmaking_start."maxLevel" - 'max player's level
    • v_matchmaking_start."kaniansInQueue" - 'number of kanians in queue
    • v_matchmaking_start."hadagansInQueue" - 'number of xadaganians in queue
    • v_matchmaking_start."eventTimestamp" - 'Time of event';
    • v_matchmaking_start.shard - 'Shard';
    • v_matchmaking_start.status - 'Status code, filled when event finished';
    • v_matchmaking_start."statusName" - 'Status name, filled when event finished; see InstancedEventShutdownCause enum';
    • v_matchmaking_start."finishTimestamp" - 'Finish moment, filled when event finished';
  • v_mob_kill_avatar
    • v_mob_kill_avatar."eventTimestamp" - 'date of event
    • v_mob_kill_avatar."eventSubjtime" - subject avatar'; time
    • v_mob_kill_avatar."mobResource" - 'Resource of mob
    • v_mob_kill_avatar."mapResource" - 'Resource of map
    • v_mob_kill_avatar."victimLevel" - 'Level of victim
    • v_mob_kill_avatar."victimRaceResource" - 'Resource of victim's race
    • v_mob_kill_avatar."victimClassResource" - 'Resource of vicrim's class
    • v_mob_kill_avatar.victim - 'victim
  • v_money_delta2 Accessing content of the relation gm.avatar.moneydelta2
    • v_money_delta2.id - 'Record id';
    • v_money_delta2."eventTimestamp" - 'time';
    • v_money_delta2.avatar - 'Avatar
    • v_money_delta2."eventSubjtime" - 'internal game time of avatar (ms.)';
    • v_money_delta2."level" - 'current level of avatar
    • v_money_delta2.money - 'avatar money delta';
    • v_money_delta2."action" - money change action code
    • v_money_delta2."secondAvatarId" - 'second avatar involved in changing money (-1,if no)';
    • v_money_delta2.resource - 'Id resource of item which is linked with money operation
    • v_money_delta2."resourceCount" - 'number of items in stack
    • v_money_delta2."providerResource" - 'Id of resource provider (vendor, quest, mob, ...)';
    • v_money_delta2.info - additional info (mail subject, ...)';
  • v_money_delta2_agg Accessing content of the relation gm.avatar.moneydelta2.agg
    • v_money_delta2_agg.id - 'Record id';
    • v_money_delta2_agg."dayTimestamp" - 'time';
    • v_money_delta2_agg.avatar - 'Avatar
    • v_money_delta2_agg."action" - money change action code
    • v_money_delta2_agg.resource -'Id resource of item which is linked with money operation
    • v_money_delta2_agg."providerResource" -'Id of resource provider (vendor, quest, mob, ...)';
    • v_money_delta2_agg."secondAvatarId" - 'second avatar involved in changing money (-1,if no)';
    • v_money_delta2_agg."maxLevel" - current level of avatar
    • v_money_delta2_agg."sumMoney" - 'money change of avatar';
    • v_money_delta2_agg."sumResourceCount" - 'number of items in stack
  • v_mount_dismissal Accessing content of the relation gm.mount.dismissal
    • v_mount_dismissal.avatar - 'Avatar id';
    • v_mount_dismissal.mount - 'Resource маунта';
    • v_mount_dismissal.count - 'number of mounts after dismiss
    • v_mount_dismissal."eventTimestamp" - 'Time of event';
    • v_mount_dismissal.shard - 'Shard';
  • v_mount_feeding Accessing content of the relation gm.mount.feeding
    • v_mount_feeding.avatar - 'Avatar id';
    • v_mount_feeding.mount - 'Resource of mount
    • v_mount_feeding."level" - 'Level of mount
    • v_mount_feeding.experience - 'current level experience of mount
    • v_mount_feeding."eventTimestamp" - 'Time of event';
    • v_mount_feeding.shard - 'Shard';
  • v_mount_taming Accessing content of the relation gm.mount.taming
    • v_mount_taming.avatar - 'Avatar id';
    • v_mount_taming.mount - 'Resource of mount
    • v_mount_taming.count - 'number of mount after adding a new one
    • v_mount_taming."eventTimestamp" - 'Time of event';
    • v_mount_taming.shard - 'Shard';
  • v_rates_changed Accessing content of the relation operator.rates.changed
    • v_rates_changed.id - 'Record id';
    • v_rates_changed."rateType" - 'type of changing rate
    • v_rates_changed."scaleReason" - 'Change reason';
    • v_rates_changed."newValue" - 'New value';
    • v_rates_changed."eventTimestamp" - 'Time of event';
  • v_remort_switch_log Accessing content of the relation gm.remort.switch.log
    • v_remort_switch_log.avatar - 'Avatar who switch to incarnation
    • v_remort_switch_log.remort - ' incarnation is switched to
    • v_remort_switch_log.soul - soul who is switched
    • v_remort_switch_log."eventTimestamp" - 'Time of event';
  • v_reputation_agg Accessing content of the relation gm.avatar.reputation.agg
    • v_reputation_agg.id - 'Record id';
    • v_reputation_agg."dayTimestamp" - 'time';
    • v_reputation_agg.avatar - 'Avatar
    • v_reputation_agg."factionResource" - 'Id of faction resource
    • v_reputation_agg."sumLevel" - total reputation level
  • v_resource_name
    • v_resource_name."type" - 'Type of resource';
    • v_resource_name."name" - 'Name of resource according this type';
  • v_session_avatar Avatar sessions
    • v_session_avatar."openTimestamp" - 'Session open time';
    • v_session_avatar."closeTimestamp" - 'Session close time';
    • v_session_avatar.avatar - 'Id of avatar';
    • v_session_avatar."isDemo" - 'Client has demo type';
    • v_session_avatar."level" - 'Level';
 
OP
al5yal511

al5yal511

Administrator
Staff member
Admin
Guide Author
  • v_session_summary
    • v_session_summary."periodStartTimestamp" - 'Period start';
    • v_session_summary."periodEndTimestamp" - 'Period end';
    • v_session_summary."accountCount" - 'Unique accounts for period';
    • v_session_summary."avatarCount" - 'Unique avatars for period';
    • v_shard Accessing content of the relation gm.shard
    • v_shard.id - 'Record id';
    • v_shard."globalId" - global shard ID
    • v_shard.title - ' Shard name';
    • v_shard.description - Shard description';
    • v_shard."startTimestamp" - 'time Shard start';
    • v_shard."logserverHost" - 'logserver addres of this Shard';
    • v_shard."categoryCode" - Category: Shard, base part, etc';
  • v_shard_stat server load statistics (last 91 days)
    • v_shard_stat.stat_time - 'date when stat is taken
    • v_shard_stat.ccu_min - min ccu at taken moment
    • v_shard_stat.ccu_avg - average ccu at taken moment
    • v_shard_stat.ccu_max - max ccu at taken moment
    • v_shard_stat.activity_index - 'Level of logging activity
    • v_shard_stat.shard - 'Id of Shard';
  • v_ship Accessing content of the relation gm.ship
    • v_ship.id - 'Record id';
    • v_ship."shipId" - ship Id in Shard database';
    • v_ship.title - 'Ship name';
    • v_ship."buildStartTimestamp" - 'time of start building;
    • v_ship."buildCompleteTimestamp" - 'time of finish building';
    • v_ship."inAstral" - 'is in astral at this time?
    • v_ship.resource - 'Id of ship resource
    • v_ship."isDeleted" - 'is deleted on the Shardе';
    • v_ship."owner" - 'Avatar';
  • v_ship_device_atship Accessing content of the relation gm.ship.device.atship
    • v_ship_device_atship.id - 'Record id';
    • v_ship_device_atship."deviceResource" - 'device Resource';
    • v_ship_device_atship.entry - 'Hangar leaving Event ';
  • v_ship_device_placed Accessing content of the relation gm.ship.device.placed
    • v_ship_device_placed.id - 'Record id';
    • v_ship_device_placed."deviceResource" -'device Resource';
    • v_ship_device_placed."eventTimestamp" - 'time of install
    • v_ship_device_placed.ship - ship;
  • v_socnet_account Accessing content of the relation gm.socnet.account
    • ** v_socnet_account.id - 'Record id';
    • v_socnet_account."avatarId" - 'Avatar';
    • v_socnet_account."networkId" - 'social network
    • v_socnet_account."actionId" - 'action
    • v_socnet_account."eventTimestamp" - 'Time of event';
    • v_socnet_account.shard - 'Shard';
  • v_socnet_post Accessing content of the relation gm.socnet.post
    • v_socnet_post.id - 'Record id';
    • v_socnet_post."avatarId" - 'Avatar';
    • v_socnet_post."networkId" - 'social network
    • v_socnet_post."postType" - 'action
    • v_socnet_post."postContentType" - contents type
    • v_socnet_post."postStatusType" - 'Status';
    • v_socnet_post."eventTimestamp" - 'Time of event';
    • v_socnet_post.shard - 'Shard';
  • v_twar_auction Astral Confrontation Auction Bids
    • v_twar_auction.id - 'Record id';
    • v_twar_auction."eventTimestamp" - 'Time of event';
    • v_twar_auction."allodResource" - 'Id of contested island resource
    • v_twar_auction.price - 'bid value
    • v_twar_auction."bidderGuild" - 'Guild which did a bid
    • v_twar_auction."bidderAvatar" - 'Avatar who did a bid
    • v_twar_auction.twar - 'Id of war in war history
  • v_twar_checkpoint Astral Confrontation Checkpoint capture
    • v_twar_checkpoint.id - 'Record id';
    • v_twar_checkpoint."eventTimestamp" - 'Time of event';
    • v_twar_checkpoint."checkPointResource" - 'Id of checkpoint resource
    • v_twar_checkpoint."actionType" - 'Action type: 0 - capture start, 1 - capture end, 2 - captured';
    • v_twar_checkpoint.guild - 'Guild who did an action
    • v_twar_checkpoint.twar - Id of war in war history
  • v_twar_device Using Cannons in Astral Confrontation
    • v_twar_device.id - 'Record id';
    • vv_twar_device."eventTimestamp" - 'Time of event';
    • v_twar_device."spellResource" - 'Id of spell resource;
    • v_twar_device."deviceResource" - 'Id of cannon resource
    • v_twar_device."mapResource" - 'Id of map resource
    • v_twar_device."deviceX" - 'x-coordinate of cannon
    • v_twar_device."deviceY" - 'y-coordinate of cannon
    • v_twar_device."deviceZ" - 'z-coordinate of cannon
    • v_twar_device."aimX" - 'x-axe coordinate of target';
    • v_twar_device."aimY" - 'y-axe coordinate of target';
    • v_twar_device."aimZ" - 'z-axe coordinate of target';
    • v_twar_device.avatar - 'Avatar';
    • v_twar_device.twar - Id of war in war history
  • v_twar_dierevive Death and ressurect history on Astral Confrontation
    • v_twar_dierevive.id - 'Record id';
    • v_twar_dierevive."eventTimestamp" - 'Time of event';
    • v_twar_dierevive."avatarClassResource" - 'Id of class resource
    • v_twar_dierevive."isRevive" - dead or revive
    • v_twar_dierevive."mapResource" - 'Id of map resource
    • v_twar_dierevive."posX" - 'x-axe coordinate of target';
    • v_twar_dierevive."posY" - 'y-axe coordinate of target';
    • v_twar_dierevive."posZ" - 'z-axe coordinate of target';
    • v_twar_dierevive.avatar - 'Avatar';
    • v_twar_dierevive.twar - Id of war in war history
  • v_twar_history Astral Confrontation war history
    • v_twar_history.id - 'Record id (Id is taken from active-table after war end)'
    • v_twar_history."startTimestamp" - 'time of war start
    • v_twar_history."endTimestamp" - 'time war end
    • v_twar_history."shardTwarId" - 'Id of war in shard adtabase
    • v_twar_history."allodResource" - 'Id of contested island resource';
    • v_twar_history."finishType" - 'Result of war : 0 - island is defended, 1 - island is captured, 2 - остров сожжен, но не захвачен, 3 -остров стал нейтральным';
    • v_twar_history."attackerGuild" - 'Attacker guild';
    • v_twar_history."defenderGuild" - defender guild (-1, if island is neutral)';
  • v_twar_member History of changing raids in Astral Confrontation
    • v_twar_member.id - 'Record id';
    • v_twar_member."eventTimestamp" - 'Time of event';
    • v_twar_member."avatarClassResource" - 'Id of class resource';
    • v_twar_member."isDefender" - is avatar defender or attacker
    • v_twar_member."runeInfo" - 'avatar runes info
    • v_twar_member."isOut" - 'Avatar is invited or kicked from raid
    • v_twar_member.avatar - 'Avatar';
    • v_twar_member.twar - Id of war in war history
  • v_valuable_altcurrency Accessing content of the relation gm.valuable.altcurrency
    • v_valuable_altcurrency.id - 'Record id';
    • v_valuable_altcurrency.avatar - 'Avatar id';
    • v_valuable_altcurrency.currency - Currency
    • v_valuable_altcurrency.count - counter
    • v_valuable_altcurrency."action" - 'source of gaining\withdrawing currency
    • v_valuable_altcurrency."actionResource" - 'Resource of source
    • v_valuable_altcurrency."eventTimestamp" - 'Time of event';
  • v_vatar_quest_active Active quests of avatar
    • v_vatar_quest_active."questResource" - 'Resource of quest';
    • v_vatar_quest_active."takeTimestamp" - 'Quest take time';
    • v_vatar_quest_active.avatar - 'Id of avatar';

Examples​

Here are some examples of SQL queries into DB views.

1. Account ID of the logged in gamers for a certain period


2. Names of the high level characters and 3. Exact names of the high level characters


4. Shard where high level characters are existing


5. Class of the high level characters


6. Total time of the play for the account ID


7. how we can obtain information about a day when a user logged in
separately for each account?

Execute this query for each slave gametool database:


8. how to extracting information
about connections of game users at Stats/alarm of Base, and found that there
is no information in recentLoginTimestamp column.


where, high_level is max level in the game.

*NOTE:*You should implement this queries on the each slave gmtool database of the each shard.
 
OP
al5yal511

al5yal511

Administrator
Staff member
Admin
Guide Author

DBes Of The Base Part​

Account Server​

sudo -u postgres psql
ALTER USER "allods" with password 'allods_pwd'; #(or any other name)
CREATE DATABASE allods_account with owner="allods"; #(or any other name)

Billing Server​

sudo mysql
GRANT ALL PRIVILEGES ON allods_billing.* TO 'allods'@'ip_of_host_or_none' IDENTIFIED BY 'allods_pwd';
GRANT SUPER ON *.* TO 'allods';
FLUSH PRIVILEGES;

Master Server​

sudo mysql
GRANT ALL PRIVILEGES ON allods_master.* TO 'allods'@'ip_of_host_or_none' IDENTIFIED BY 'allods_pwd';
GRANT SUPER ON *.* TO 'allods';
FLUSH PRIVILEGES;
# exit

DBes Of The Shard Part​

Item Server​

sudo mysql
CREATE DATABASE allods_item; #or any other name
CREATE DATABASE allods_mail; #or any other name
CREATE DATABASE allods_auction; #or any other name
CREATE DATABASE allods_guild; #or any other name
GRANT ALL PRIVILEGES ON allods_item.* TO 'allods'@'ip_of_host_or_none' IDENTIFIED BY 'allods_pwd'; #edit login, password and ip address
GRANT ALL PRIVILEGES ON allods_auction.* TO 'allods'@'localhost' IDENTIFIED BY 'allods_pwd'; #edit login, password and ip address
GRANT ALL PRIVILEGES ON allods_guild.* TO 'allods'@'localhost' IDENTIFIED BY 'allods_pwd'; #edit login, password and ip address
GRANT ALL PRIVILEGES ON allods_mail.* TO 'allods'@'localhost' IDENTIFIED BY 'allods_pwd'; #edit login, password and ip address
GRANT SUPER ON *.* TO 'allods';
FLUSH PRIVILEGES;
# exit

Stats Alarm server​

This is the example how-to setting up the postgres database for GM tool: (We don't have the GM tool)

sudo -u postgres psql
alter user "gmtool" with password 'gmtool';
create database gmtool with owner=gmtool;
CREATE ROLE ro NOINHERIT VALID UNTIL 'infinity';
alter user "gmtool" with CREATEROLE;
Log server
This is the example how-to setting up the postgres database for Log Server:
CREATE USER logserver;
alter user "logserver" with password 'logserver';
create database logserver with owner=logserver;
CREATE ROLE ro NOINHERIT VALID UNTIL 'infinity';
alter user "logserver" with CREATEROLE;

NOTE: If you are using postgres-8.3. You have to input next lines from a common psql console, like this:
*sudo -U postgres psql*
UPDATE pg_authid SET rolcatupdate=true WHERE rolname = 'logserver';


and from a logserver database:
*sudo -U postgres psql logserver*
grant all on table pg_autovacuum to logserver;



Notes​

  1. Do not forget to backup DB
  2. All tables will be created automatically during the start of the server
Post automatically merged:

1709819557484.png
Post automatically merged:

1709819571836.png
 
Last edited:
You must log in or register to reply here.

Top Bottom