Database Familiarity Guide

Results 1 to 7 of 7
  1. #1
    FFVIII SeiferXIII is offline
    ModeratorRank
    Sep 2007 Join Date
    SomewhereLocation
    1,953Posts

    config Database Familiarity Guide

    Episode 3 to Episode 7 Database Guide

    Database Table Purpose
    RanGame1 ChaFriend Character's Friendlist
    ChaInfo Character Data
    GuildInfo Guild Data
    GuildRegion Club Wars E-Room Owner list
    GuildAlliance Guild Alliance list
    PetInfo Character Pet Data
    PetInven Pet Inventory
    UserInven User Locker
    VehicleInfo Character Vehicle Data
    RanLog LogAction Character, Accounts Log (see EMLOGACTION enum on source code for Type)
    LogItemExchange Item and Gold flow history (based on chanum and or usernum, see EMIDTYPE for the basis of ItemFrom and ItemTo)
    LogItemRandom Item randomizer logs
    LogPetAction Pet related history
    LogVehicleAction Vehicle related history
    LogServerState Session Server Heartbeat, logs the current peak player count of the server
    RanShop ShopItemMap List of items for the item shop
    ShopPurchase User item bank, depends on ShopItemMap ProductNum
    RanUser UserInfo User Account List
    LogLogin User Login record history
    StatGameTime Daily tally of all gametime of accounts
    StatLogin Hourly tally of online count


    GS Database Guide


    Database Table Purpose
    RanGameS1 ActivityInfo Character Activity Data
    ActivityRewardBadge Badges acquired by Character
    ActivityRewardPoint Points acquired by Character
    AttendanceInfo Character Attendance Info
    AttendanceTaskInfo Character Ongoing Attendance
    ChaFriend Character's Friend List
    ChaFriendGroup Character Friend list Group
    ChaHireSummonInfo Character Summon Hiring Data
    ChaInfo Character Data
    ChaSlotsInfo Character Slots Info (See A, B, C, D on Character Window),

    SelectCharSlot on usefeatures_gs.lua must be true to enable this feature
    GuildAlliance Guild Alliance List
    GuildBattle Guild Wars History
    GuildInfo Guild Data
    GuildRegion Club Wars E-Room Owner list
    Item Item Data (Equivalent to EP7's UserInven, ChaInven and other item related info, it's not binary anymore, it's now human readable)
    LottoBuyList
    LottoBuyMoney
    LottoDrawingMachine
    LottoNumInfo
    LottoSystemInfo
    LottoSystemTurn
    LotoTurnInfo
    LottoWinManList
    Lotto related tables, these are system generated, so don't touch it unless you know what you are doing.
    PetInfo Character Pet Data
    PetInven Pet Inventory
    PostInfo Mailbox Data
    ProductBook Crafting Category Data
    RanLog LogAction Character, Accounts Log (see EMLOGACTION enum on source code for Type)
    LogItemExchange Item and Gold flow history (based on chanum and or usernum, see EMIDTYPE for the basis of ItemFrom and ItemTo)
    LogItemRandom Item randomizer logs
    LogPetAction Pet related history
    LogVehicleAction Vehicle related history
    LogServerState Session Server Heartbeat, logs the current peak player count of the server
    AttendanceLog
    AttendanceTaskLog
    Attendance Related logs
    CTFPlayLog
    CTFResult
    CTFStatLog
    Tyranny Related logs (rewards sent to character, items sent to each school, how many participated on specific tyranny battle time)
    ItemLog Item Transaction history
    ItemLogAddon Logs for Item Addon Value
    ItemLogBasicStat Item Basic Stats History (if OPItemCheck is true on usefeatures_gs.lua, it will automatically delete overpowered item)
    ItemLogRandom Item Rebuild Card Item RV Logs
    LogGMChat GM Character chat audit log
    LogGmCommand GM Character command audit log
    LogMoney Money related logs see EMGAME_MONEY_CHANGE on MoneyLogDefine.h
    RanShop ShopItemMap List of items for the item shop
    ShopPurchase User item bank, depends on ShopItemMap ProductNum
    PointShop In-game Itemshop using RanPoint as currency
    ConsignmentSale Item for sale by character via ranpoint
    RanUser GSUserInfo User Account List
    LogLogin User Login record history
    StatGameTime Daily tally of all gametime of accounts
    StatLogin Hourly tally of online count
    Last edited by SeiferXIII; 30-04-21 at 12:11 PM.


  2. #2
    Registered soske98 is offline
    MemberRank
    Jun 2020 Join Date
    10Posts

    Re: Database Familiarity Guide

    Thanks seiferxiii for the info.

  3. #3
    FFVIII SeiferXIII is offline
    ModeratorRank
    Sep 2007 Join Date
    SomewhereLocation
    1,953Posts

    Re: Database Familiarity Guide

    Updated with GS database guide

  4. #4
    Hardcore Member arwekaj09 is online now
    MemberRank
    Mar 2020 Join Date
    NowhereLocation
    120Posts

    Re: Database Familiarity Guide

    Quote Originally Posted by SeiferXIII View Post
    Updated with GS database guide
    Hi sir Seifer, may I know where to get the Character PK Win / Loss?
    LET'S HELP EACH OTHER WHILE WE CAN
    CHECK OUT MY RELEASE OR SHARE:
    JUVER SOURCE COMPATIBLE CLIENT

  5. #5
    Registered amperejr is offline
    MemberRank
    Feb 2015 Join Date
    10Posts

    Re: Database Familiarity Guide

    RanGame1>Chainfo

  6. #6
    Hardcore Member arwekaj09 is online now
    MemberRank
    Mar 2020 Join Date
    NowhereLocation
    120Posts

    Re: Database Familiarity Guide

    Quote Originally Posted by amperejr View Post
    RanGame1>Chainfo
    Yeah, but for the GS is different. I cant find it
    LET'S HELP EACH OTHER WHILE WE CAN
    CHECK OUT MY RELEASE OR SHARE:
    JUVER SOURCE COMPATIBLE CLIENT

  7. #7
    Kayo na! ANg galing nyo e chumleader is online now
    True MemberRank
    May 2014 Join Date
    wwwLocation
    353Posts

    Re: Database Familiarity Guide

    Correction for ItemLogAddon is the logs for Item Addon Value (The green stats of Item ). this is when one uses Additional Stats Reform Card.
    Based on my tests if OPItemCheck is set to true, if the addon stats is greater than the max addon value. it will not delete the item. OPItem check is for RV Only, it checks if RV is greater than the max RV then it will be deleted





Advertisement