AccountServer

From OuroDev
Revision as of 20:34, 3 May 2019 by Bevinsky (talk | contribs) (→‎Table Structures: Redid the tables as wikitable with proper syntax.)

AccountServer handles all inventory-related queries and reads processed payment information. PlaySpan is the original payment backend used before NCSoft shut down City of Heroes.

Configuration

account_server.cfg

ShardName
  ShardName Paragon
  ShardId 1
  Address 127.0.0.1
  NoXferOut
  NoXferIn
  XferDestinations None
ShardEnd
PlayNCAdminWebPageSecretKey Paragon
MtxEnvironment Paragon
MtxSecretKey Paragon
MtxIOThreads 1
SqlDbName cohacc
SqlLogin "Driver={SQL Server Native Client 11.0};server=localhost;database=cohacc;trusted_connection=Yes;"
CatalogTimeStampTestOffsetDays 0
clientAuthTimeout 1800
ShardXfersDayMemory 14
ShardXfersAllowedInMemory 0

Database Schema

An SQL dump will be bundled with future releases of code. Until then, here you go.

Table Structures

Columns are nullable unless denoted by Primary Key or Non Nullable.

account

Column Name Data Type Attributes
auth_id int Primary Key
name varchar(14)
loyalty_bits binary(16)
last_loyalty_point_count smallint
loyalty_points_spent smallint
last_email_date smalldatetime
last_num_emails_sent smallint
free_xfer_date smalldatetime

game_log

Column Name Data Type Attributes
order_id uniqueidentifier Primary Key, Foreign Key to game_transactions.order_id
auth_id int Foreign Key to account.auth_id, Not Nullable
sku_id char(8) Foreign Key to product.sku_id, Not Nullable
transaction_date datetime
shard_id tinyint
ent_id int
granted int
claimed int
csr_did_it bit
parent_order_id uniqueidentifier Foreign Key to game_transactions.order_id, Not Nullable
saved int

game_transactions

Column Name Data Type Attributes
order_id uniqueidentifier Primary Key
auth_id int Foreign Key to account.auth_id, Not Nullable
sku_id char(8) Foreign Key to product.sku_id, Not Nullable
transaction_date datetime
shard_id tinyint
ent_id int
granted int
claimed int
csr_did_it bit
parent_order_id uniqueidentifier Foreign Key to game_transactions.order_id, Not Nullable

inventory

Column Name Data Type Attributes
auth_id int Foreign Key to account.auth_id, Not Nullable
sku_id char(8) Foreign Key to product.sku_id, Not Nullable
granted_total int
claimed_total int
saved_total int
expires smalldatetime

mtx_log

Column Name Data Type Attributes
order_id uniqueidentifier Primary Key, Foreign Key to game_transactions.order_id
auth_id int Foreign Key to account.auth_id, Not Nullable
sku_id char(8) Foreign Key to product.sku_id, Not Nullable
transaction_date datetime
quantity int
points int

product

Column Name Data Type Attributes
sku_id char(8) Primary Key
name varchar(128)
product_type_id int Foreign Key to product_type.product_type_id, Not Nullable
grant_limit int
expiration_seconds int

product_type

Column Name Data Type Attributes
product_type_id int Primary Key
name varchar(128) Not Nullable

Stored Procedures

SP_add_game_transaction

SP_add_micro_transaction

SP_add_multi_game_transaction

SP_find_or_create_account

SP_read_unsaved_game_transactions

SP_revert_game_transaction

SP_save_game_transaction

SP_update_account

Table-Valued Parameters

TVP_game_transaction

Development Notes

[2:14 PM] Searge: nice, you can also get all sku by just changing some code, int AccountGetStoreProductCount2(AccountInventorySet* invSet, const AccountProduct* pProd, bool bActive) in AccountData.c could always return 1
[2:39 PM] Searge: @Pazaz the loyalty bits set by the client when you take all of them are set to 0xFFFFFFFF7FE00F000000000000000000 in the database