C# Class SagaDB.MSSQLCharacterDB

Inheritance: ActorDB
显示文件 Open project: Willyham/SagaRO2 Class Usage Examples

Public Methods

Method Description
CharExists ( byte worldID, string name ) : bool
Connect ( ) : bool
CreateChar ( ActorPC &aChar, int account_id ) : void
DeleteChar ( ActorPC aChar ) : void
DeleteItem ( ActorPC pc, Item item ) : void
DeleteJobLevel ( ActorPC pc, JobType type ) : void
DeleteMail ( uint id ) : void
DeleteMapInfo ( ActorPC pc, byte mapID ) : void
DeleteMarketItem ( MarketplaceItem item ) : void
DeleteNpc ( ActorNPC aNpc ) : void
DeleteQuest ( ActorPC pc, Quest quest ) : void
DeleteSkill ( ActorPC pc, SkillInfo skill ) : void
DeleteStorage ( ActorPC pc, Item item ) : void
GetChar ( uint charID ) : ActorPC
GetCharIDs ( int account_id ) : uint[]
GetCharName ( uint id ) : string
GetMail ( Mail type, string value ) : List
GetMarketItem ( uint id ) : MarketplaceItem
GetNpc ( string scriptName ) : ActorNPC
MSSQLCharacterDB ( string host, int port, string database, string user, string pass ) : System
NewItem ( ActorPC pc, Item item ) : void
NewJobLevel ( ActorPC pc, JobType type, byte level ) : void
NewMail ( Mail mail ) : void
NewMapInfo ( ActorPC pc, byte mapID, byte value ) : void
NewQuest ( ActorPC pc, Quest type, Quest quest ) : void
NewSkill ( ActorPC pc, SkillType type, SkillInfo skill ) : void
NewStorage ( ActorPC pc, Item item ) : void
RegisterMarketItem ( MarketplaceItem item ) : void
SaveChar ( ActorPC aChar ) : void
SaveMail ( Mail mail ) : void
SaveNpc ( ActorNPC aNpc ) : void
SearchMarketItem ( MarketSearchOption option, ushort pageindex, object vars ) : List
UpdateItem ( ActorPC pc, Item item ) : void
UpdateJobLevel ( ActorPC pc, JobType type, byte level ) : void
UpdateMapInfo ( ActorPC pc, byte mapID, byte value ) : void
UpdateQuest ( ActorPC pc, Quest type, Quest quest ) : void
UpdateSkill ( ActorPC pc, SkillType type, SkillInfo skill ) : void
UpdateStorage ( ActorPC pc, Item item ) : void
isConnected ( ) : bool

Private Methods

Method Description
HexStr2Bytes ( string s ) : byte[]
HexStr2uint ( string s ) : uint[]
LoadInv ( ActorPC &aChar ) : void
LoadJLevel ( ActorPC &aChar ) : void
LoadMapInfo ( ActorPC &aChar ) : void
LoadQuest ( ActorPC &aChar ) : void
LoadShortcuts ( ActorPC &aChar ) : void
LoadSkills ( ActorPC &aChar ) : void
LoadStorage ( ActorPC &aChar ) : void
LoadWeapon ( ActorPC &aChar ) : void
SaveInv ( ActorPC aChar ) : void
SaveJLevel ( ActorPC aChar ) : void
SaveMapInfo ( ActorPC aChar ) : void
SaveQuest ( ActorPC aChar ) : void
SaveShortcuts ( ActorPC aChar ) : void
SaveSkills ( ActorPC aChar ) : void
SaveStorage ( ActorPC aChar ) : void
SaveWeapon ( ActorPC aChar ) : void
bytes2HexString ( byte b ) : string
getCharID ( string name ) : uint
uint2HexString ( uint b ) : string

Method Details

CharExists() public method

public CharExists ( byte worldID, string name ) : bool
worldID byte
name string
return bool

Connect() public method

public Connect ( ) : bool
return bool

CreateChar() public method

public CreateChar ( ActorPC &aChar, int account_id ) : void
aChar SagaDB.Actors.ActorPC
account_id int
return void

DeleteChar() public method

public DeleteChar ( ActorPC aChar ) : void
aChar SagaDB.Actors.ActorPC
return void

DeleteItem() public method

public DeleteItem ( ActorPC pc, Item item ) : void
pc SagaDB.Actors.ActorPC
item Item
return void

DeleteJobLevel() public method

public DeleteJobLevel ( ActorPC pc, JobType type ) : void
pc SagaDB.Actors.ActorPC
type JobType
return void

DeleteMail() public method

public DeleteMail ( uint id ) : void
id uint
return void

DeleteMapInfo() public method

public DeleteMapInfo ( ActorPC pc, byte mapID ) : void
pc SagaDB.Actors.ActorPC
mapID byte
return void

DeleteMarketItem() public method

public DeleteMarketItem ( MarketplaceItem item ) : void
item SagaDB.Items.MarketplaceItem
return void

DeleteNpc() public method

public DeleteNpc ( ActorNPC aNpc ) : void
aNpc SagaDB.Actors.ActorNPC
return void

DeleteQuest() public method

public DeleteQuest ( ActorPC pc, Quest quest ) : void
pc SagaDB.Actors.ActorPC
quest Quest
return void

DeleteSkill() public method

public DeleteSkill ( ActorPC pc, SkillInfo skill ) : void
pc SagaDB.Actors.ActorPC
skill SagaDB.Actors.SkillInfo
return void

DeleteStorage() public method

public DeleteStorage ( ActorPC pc, Item item ) : void
pc SagaDB.Actors.ActorPC
item Item
return void

GetChar() public method

public GetChar ( uint charID ) : ActorPC
charID uint
return SagaDB.Actors.ActorPC

GetCharIDs() public method

public GetCharIDs ( int account_id ) : uint[]
account_id int
return uint[]

GetCharName() public method

public GetCharName ( uint id ) : string
id uint
return string

GetMail() public method

public GetMail ( Mail type, string value ) : List
type Mail
value string
return List

GetMarketItem() public method

public GetMarketItem ( uint id ) : MarketplaceItem
id uint
return SagaDB.Items.MarketplaceItem

GetNpc() public method

public GetNpc ( string scriptName ) : ActorNPC
scriptName string
return SagaDB.Actors.ActorNPC

MSSQLCharacterDB() public method

public MSSQLCharacterDB ( string host, int port, string database, string user, string pass ) : System
host string
port int
database string
user string
pass string
return System

NewItem() public method

public NewItem ( ActorPC pc, Item item ) : void
pc SagaDB.Actors.ActorPC
item Item
return void

NewJobLevel() public method

public NewJobLevel ( ActorPC pc, JobType type, byte level ) : void
pc SagaDB.Actors.ActorPC
type JobType
level byte
return void

NewMail() public method

public NewMail ( Mail mail ) : void
mail Mail
return void

NewMapInfo() public method

public NewMapInfo ( ActorPC pc, byte mapID, byte value ) : void
pc SagaDB.Actors.ActorPC
mapID byte
value byte
return void

NewQuest() public method

public NewQuest ( ActorPC pc, Quest type, Quest quest ) : void
pc SagaDB.Actors.ActorPC
type Quest
quest Quest
return void

NewSkill() public method

public NewSkill ( ActorPC pc, SkillType type, SkillInfo skill ) : void
pc SagaDB.Actors.ActorPC
type SkillType
skill SagaDB.Actors.SkillInfo
return void

NewStorage() public method

public NewStorage ( ActorPC pc, Item item ) : void
pc SagaDB.Actors.ActorPC
item Item
return void

RegisterMarketItem() public method

public RegisterMarketItem ( MarketplaceItem item ) : void
item SagaDB.Items.MarketplaceItem
return void

SaveChar() public method

public SaveChar ( ActorPC aChar ) : void
aChar SagaDB.Actors.ActorPC
return void

SaveMail() public method

public SaveMail ( Mail mail ) : void
mail Mail
return void

SaveNpc() public method

public SaveNpc ( ActorNPC aNpc ) : void
aNpc SagaDB.Actors.ActorNPC
return void

SearchMarketItem() public method

public SearchMarketItem ( MarketSearchOption option, ushort pageindex, object vars ) : List
option MarketSearchOption
pageindex ushort
vars object
return List

UpdateItem() public method

public UpdateItem ( ActorPC pc, Item item ) : void
pc SagaDB.Actors.ActorPC
item Item
return void

UpdateJobLevel() public method

public UpdateJobLevel ( ActorPC pc, JobType type, byte level ) : void
pc SagaDB.Actors.ActorPC
type JobType
level byte
return void

UpdateMapInfo() public method

public UpdateMapInfo ( ActorPC pc, byte mapID, byte value ) : void
pc SagaDB.Actors.ActorPC
mapID byte
value byte
return void

UpdateQuest() public method

public UpdateQuest ( ActorPC pc, Quest type, Quest quest ) : void
pc SagaDB.Actors.ActorPC
type Quest
quest Quest
return void

UpdateSkill() public method

public UpdateSkill ( ActorPC pc, SkillType type, SkillInfo skill ) : void
pc SagaDB.Actors.ActorPC
type SkillType
skill SagaDB.Actors.SkillInfo
return void

UpdateStorage() public method

public UpdateStorage ( ActorPC pc, Item item ) : void
pc SagaDB.Actors.ActorPC
item Item
return void

isConnected() public method

public isConnected ( ) : bool
return bool