C# Class cs_elbot.MySqlManager

description of MySqlManager.

Mostrar archivo Open project: Sir-Odie/CS-ELBot Class Usage Examples

Public Properties

Property	Type	Description
playerguildstored	string
usernamestored	string

Public Methods

Method	Description
AddInventoryItem ( cs_elbot.Inventory item, int botid, bool delayed ) : void
BanGuild ( string guildname, int banned, string username ) : void
CheckIfBannedGuild ( string username, int botid ) : int
CheckIfCommandIsDisabled ( string Command, int botid ) : bool
CheckIfGuildMember ( string username, int botid ) : bool
CheckIfTextCommandIsDisabled ( string Command, int botid ) : bool
CheckIfTradeMember ( string username, int botid ) : bool
ClearInventoryList ( int botid ) : void
ClearStorage ( ) : void
DeleteStorageItem ( Storage MyStorageItem ) : void
GetBotAdverts ( int botid ) : System.Collections.ArrayList
GetBotAltAdverts ( int botid ) : System.Collections.ArrayList
GetBotCoordination ( int botid ) : int
GetBotPhysqiue ( int botid ) : int
GetBotUsedSlots ( int botid ) : int
GetBotUsedSpace ( int botid ) : int
GetCommandRank ( string Command, int botid ) : int
GetDescription ( int ITEMID ) : string
GetDescriptionExtra ( int ITEMID ) : string
GetGuildRank ( string username, int botid ) : int
GetItemID ( string name, bool fromStorage ) : int
GetItemID ( string name, int botid, bool fromStorage ) : int
GetKnownItemsSQLID ( TradeHandler MyTradeItem ) : int
GetKnownItemsname ( int SQLID ) : string
GetSellingItemList ( int advertIndcator ) : System.Collections.Hashtable
GetSellingList ( int advertIndcator ) : System.Collections.ArrayList
GetStorageSQLID ( TradeHandler MyTradeItem ) : int
GetTextCommandRank ( string Command, int botid ) : int
GetTimeoutInterval ( int botid ) : int
GetUserRank ( string username, int botid ) : int
GetWantedItemList ( int advertIndicator ) : System.Collections.Hashtable
GetWantedItemListIDs ( ) : System.Collections.ArrayList
GetWantedList ( int advertIndicator ) : System.Collections.ArrayList
Getgreeting ( string username, int botid ) : string
ImLoggedIn ( int botID ) : void
ImLoggedOut ( int botID ) : void
ImPending ( string botName ) : void
ImStarted ( int botID ) : void
InsertStorageCategory ( Storage MyStorageCategory ) : void
InsertStorageItems ( System myStorage ) : void
KillSleepingMySQLConnections ( int iMinSecondsToExpire ) : void
LogTrade ( TradeHandler MyTradeLogItem, string username, int botid, bool sendCoinPMs ) : void
MySqlManager ( string SqlServer, string SqlUsername, string SqlPassword, string SqlDatabase, int SqlPort, Logger MyLogger, TCPWrapper MyTCPWrapper, cs_elbot.errorHandler MyErrorHandler ) : System
PlayerGuild ( string username ) : string
ReservedAmount ( int SQLID ) : uint
ReservedAmountForUser ( int SQLID, string userid ) : uint
SendHNHtoGM ( int botid ) : int
SendHNHtoLocal ( int botid ) : int
SetSQLID ( cs_elbot.Inventory item ) : int
SetupConstants ( int botid ) : void
TextCommandHelpText ( string Command, int botid ) : string
TextCommandText ( string Command, int botid ) : string
TextCommandlist ( int botid ) : string
UpdateAllStats ( int botid, byte data ) : void
UpdatePlayer ( string name, int rank, string username ) : void
UpdatePlayer ( string name, string guild ) : void
UpdateSingleStat ( string str, int value ) : void
UpdateStorageItem ( TradeHandler MyTradeLogItem, bool replaceQuantity ) : void
advertchannel ( int botid ) : uint
advertendmessage ( ) : string
advertise ( ) : bool
advertlog ( string adverttext ) : void
altadvertchannel ( int botid ) : uint
altadvertise ( ) : bool
botname ( int botid ) : string
botowner ( int botid ) : string
currenthealth ( int botid ) : int
deleteBuddy ( string buddyName ) : void
enabledebuging ( int botid ) : bool
foodlevel ( int botid ) : int
getAdvertTextRate ( ) : double
getConnectionStatus ( string botName ) : string
getDestination ( string mapName, string targetDest, int &objectID, int &useWithObject, int &lastMoveNumber ) : cs_elbot.AdvancedCommunication.ActorHandler.position
getHomeInfo ( ) : void
getInvFiller ( ) : char
getItemInfo ( TradeHandler &MyTradeItem ) : void
getItemPos ( int itemID ) : int
getNPCPosition ( int npcID ) : cs_elbot.AdvancedCommunication.ActorHandler.position
getObjectPosition ( string mapName, int objectID, int &useWithObject ) : cs_elbot.AdvancedCommunication.ActorHandler.position
getSellRate ( ) : double
getShowZeroPrice ( ) : bool
getStorageNPCName ( ) : string
getTextAdvert ( ) : string
getURL ( ) : string
getWantedFiller ( ) : char
guildlongname ( int botid ) : string
hnhmessage ( int botid ) : string
isBot ( string name ) : bool
lastadverttime ( int botid ) : Int32
lastaltadverttime ( int botid ) : Int32
locationdescription ( int botid ) : string
loggotpms ( int botid ) : bool
logsendpms ( int botid ) : bool
maxhealth ( int botid ) : int
minadverttime ( ) : int
minaltadverttime ( ) : int
newhourcolor ( int botid ) : int
numberoftextcommands ( int botid ) : int
playerIsOnline ( string playerName ) : bool
playerjoinedguildcolor ( int botid ) : int
playerleftguildcolor ( int botid ) : int
playerloggedoffcolor ( int botid ) : int
playerloggedoncolor ( int botid ) : int
pmmonitorlist ( int botid ) : string
randomadvertdelay ( ) : Int32
randomaltadvertdelay ( ) : int
raw_sql ( string sql ) : void
reserveItem ( int itemId, uint numberToReserve, string username ) : bool
reserveItem ( int itemId, uint numberToReserve, string username, bool prizeIndicator ) : bool
sendCoinPMs ( ) : bool
senderrorpms ( int botid ) : bool
sendreceivedpms ( int botid ) : bool
sendtextcommandtogm ( string Command, int botid ) : bool
setPlayerOffline ( string playerName ) : void
setPlayerOnline ( string playerName ) : void
updateGreeting ( string username, int botid ) : void
updateMyLocation ( ) : void
updatePerks ( string botPerks ) : void
updateVersion ( ) : void
updateknownitems ( cs_elbot.Inventory item, int id ) : void
validLaunch ( string botName, string userName ) : bool
welcomedescription ( int botid ) : string

Private Methods

Method	Description
IGamble ( ) : bool
checkForPrizes ( string prizeLevel ) : bool
displayPrizes ( string argument, string username ) : void
getBotType ( int p ) : int
getGambleInfo ( string prizeLevel, decimal &oddsOfWinning, uint &priceOfTicket ) : void
getJackpotNumber ( string prizeLevel, UInt32 &jackpotAmount ) : decimal
isPlayerOnline ( string username, string playerName, string serverName ) : bool
listBuddies ( string username ) : void
listPrizesWon ( string username ) : void
putPrizesInWindow ( string username ) : int
reservePrize ( string prizeLevel, string username ) : string
reservedDelete ( int botid, string username, Int32 rowIndex ) : bool
reservedDetails ( int botid, string username ) : void
setBuddyOffline ( string playerName ) : void
setBuddyOnline ( string playerName ) : void
updateCoins ( uint priceOfTicket ) : void
updateJackpotAmount ( string prizeLevel, bool resetJackpotAmount ) : void
updatePrizes ( string username ) : void
writeSigils ( string sigilsWeHave ) : void

Method Details

AddInventoryItem() public method

public AddInventoryItem ( cs_elbot.Inventory item, int botid, bool delayed ) : void
item	cs_elbot.Inventory
botid	int
delayed	bool
return	void

BanGuild() public method

public BanGuild ( string guildname, int banned, string username ) : void
guildname	string
banned	int
username	string
return	void

CheckIfBannedGuild() public method

public CheckIfBannedGuild ( string username, int botid ) : int
username	string
botid	int
return	int

CheckIfCommandIsDisabled() public method

public CheckIfCommandIsDisabled ( string Command, int botid ) : bool
Command	string
botid	int
return	bool

CheckIfGuildMember() public method

public CheckIfGuildMember ( string username, int botid ) : bool
username	string
botid	int
return	bool

CheckIfTextCommandIsDisabled() public method

public CheckIfTextCommandIsDisabled ( string Command, int botid ) : bool
Command	string
botid	int
return	bool

CheckIfTradeMember() public method

public CheckIfTradeMember ( string username, int botid ) : bool
username	string
botid	int
return	bool

ClearInventoryList() public method

public ClearInventoryList ( int botid ) : void
botid	int
return	void

ClearStorage() public method

public ClearStorage ( ) : void
return	void

DeleteStorageItem() public method

public DeleteStorageItem ( Storage MyStorageItem ) : void
MyStorageItem	Storage
return	void

GetBotAdverts() public method

public GetBotAdverts ( int botid ) : System.Collections.ArrayList
botid	int
return	System.Collections.ArrayList

GetBotAltAdverts() public method

public GetBotAltAdverts ( int botid ) : System.Collections.ArrayList
botid	int
return	System.Collections.ArrayList

GetBotCoordination() public method

public GetBotCoordination ( int botid ) : int
botid	int
return	int

GetBotPhysqiue() public method

public GetBotPhysqiue ( int botid ) : int
botid	int
return	int

GetBotUsedSlots() public method

public GetBotUsedSlots ( int botid ) : int
botid	int
return	int

GetBotUsedSpace() public method

public GetBotUsedSpace ( int botid ) : int
botid	int
return	int

GetCommandRank() public method

public GetCommandRank ( string Command, int botid ) : int
Command	string
botid	int
return	int

GetDescription() public method

public GetDescription ( int ITEMID ) : string
ITEMID	int
return	string

GetDescriptionExtra() public method

public GetDescriptionExtra ( int ITEMID ) : string
ITEMID	int
return	string

GetGuildRank() public method

public GetGuildRank ( string username, int botid ) : int
username	string
botid	int
return	int

GetItemID() public method

public GetItemID ( string name, bool fromStorage ) : int
name	string
fromStorage	bool
return	int

GetItemID() public method

public GetItemID ( string name, int botid, bool fromStorage ) : int
name	string
botid	int
fromStorage	bool
return	int

GetKnownItemsSQLID() public method

public GetKnownItemsSQLID ( TradeHandler MyTradeItem ) : int
MyTradeItem	TradeHandler
return	int

GetKnownItemsname() public method

public GetKnownItemsname ( int SQLID ) : string
SQLID	int
return	string

GetSellingItemList() public method

public GetSellingItemList ( int advertIndcator ) : System.Collections.Hashtable
advertIndcator	int
return	System.Collections.Hashtable

GetSellingList() public method

public GetSellingList ( int advertIndcator ) : System.Collections.ArrayList
advertIndcator	int
return	System.Collections.ArrayList

GetStorageSQLID() public method

public GetStorageSQLID ( TradeHandler MyTradeItem ) : int
MyTradeItem	TradeHandler
return	int

GetTextCommandRank() public method

public GetTextCommandRank ( string Command, int botid ) : int
Command	string
botid	int
return	int

GetTimeoutInterval() public method

public GetTimeoutInterval ( int botid ) : int
botid	int
return	int

GetUserRank() public method

public GetUserRank ( string username, int botid ) : int
username	string
botid	int
return	int

GetWantedItemList() public method

public GetWantedItemList ( int advertIndicator ) : System.Collections.Hashtable
advertIndicator	int
return	System.Collections.Hashtable

GetWantedItemListIDs() public method

public GetWantedItemListIDs ( ) : System.Collections.ArrayList
return	System.Collections.ArrayList

GetWantedList() public method

public GetWantedList ( int advertIndicator ) : System.Collections.ArrayList
advertIndicator	int
return	System.Collections.ArrayList

Getgreeting() public method

public Getgreeting ( string username, int botid ) : string
username	string
botid	int
return	string

ImLoggedIn() public method

public ImLoggedIn ( int botID ) : void
botID	int
return	void

ImLoggedOut() public method

public ImLoggedOut ( int botID ) : void
botID	int
return	void

ImPending() public method

public ImPending ( string botName ) : void
botName	string
return	void

ImStarted() public method

public ImStarted ( int botID ) : void
botID	int
return	void

InsertStorageCategory() public method

public InsertStorageCategory ( Storage MyStorageCategory ) : void
MyStorageCategory	Storage
return	void

InsertStorageItems() public method

public InsertStorageItems ( System myStorage ) : void
myStorage	System
return	void

KillSleepingMySQLConnections() public method

public KillSleepingMySQLConnections ( int iMinSecondsToExpire ) : void
iMinSecondsToExpire	int
return	void

LogTrade() public method

public LogTrade ( TradeHandler MyTradeLogItem, string username, int botid, bool sendCoinPMs ) : void
MyTradeLogItem	TradeHandler
username	string
botid	int
sendCoinPMs	bool
return	void

MySqlManager() public method

public MySqlManager ( string SqlServer, string SqlUsername, string SqlPassword, string SqlDatabase, int SqlPort, Logger MyLogger, TCPWrapper MyTCPWrapper, cs_elbot.errorHandler MyErrorHandler ) : System
SqlServer	string
SqlUsername	string
SqlPassword	string
SqlDatabase	string
SqlPort	int
MyLogger	Logger
MyTCPWrapper	TCPWrapper
MyErrorHandler	cs_elbot.errorHandler
return	System

PlayerGuild() public method

public PlayerGuild ( string username ) : string
username	string
return	string

ReservedAmount() public method

public ReservedAmount ( int SQLID ) : uint
SQLID	int
return	uint

ReservedAmountForUser() public method

public ReservedAmountForUser ( int SQLID, string userid ) : uint
SQLID	int
userid	string
return	uint

SendHNHtoGM() public method

public SendHNHtoGM ( int botid ) : int
botid	int
return	int

SendHNHtoLocal() public method

public SendHNHtoLocal ( int botid ) : int
botid	int
return	int

SetSQLID() public method

public SetSQLID ( cs_elbot.Inventory item ) : int
item	cs_elbot.Inventory
return	int

SetupConstants() public method

public SetupConstants ( int botid ) : void
botid	int
return	void

TextCommandHelpText() public method

public TextCommandHelpText ( string Command, int botid ) : string
Command	string
botid	int
return	string

TextCommandText() public method

public TextCommandText ( string Command, int botid ) : string
Command	string
botid	int
return	string

TextCommandlist() public method

public TextCommandlist ( int botid ) : string
botid	int
return	string

UpdateAllStats() public method

public UpdateAllStats ( int botid, byte data ) : void
botid	int
data	byte
return	void

UpdatePlayer() public method

public UpdatePlayer ( string name, int rank, string username ) : void
name	string
rank	int
username	string
return	void

UpdatePlayer() public method

public UpdatePlayer ( string name, string guild ) : void
name	string
guild	string
return	void

UpdateSingleStat() public method

public UpdateSingleStat ( string str, int value ) : void
str	string
value	int
return	void

UpdateStorageItem() public method

public UpdateStorageItem ( TradeHandler MyTradeLogItem, bool replaceQuantity ) : void
MyTradeLogItem	TradeHandler
replaceQuantity	bool
return	void

advertchannel() public method

public advertchannel ( int botid ) : uint
botid	int
return	uint

advertendmessage() public method

public advertendmessage ( ) : string
return	string

advertise() public method

public advertise ( ) : bool
return	bool

advertlog() public method

public advertlog ( string adverttext ) : void
adverttext	string
return	void

altadvertchannel() public method

public altadvertchannel ( int botid ) : uint
botid	int
return	uint

altadvertise() public method

public altadvertise ( ) : bool
return	bool

botname() public method

public botname ( int botid ) : string
botid	int
return	string

botowner() public method

public botowner ( int botid ) : string
botid	int
return	string

currenthealth() public method

public currenthealth ( int botid ) : int
botid	int
return	int

deleteBuddy() public method

public deleteBuddy ( string buddyName ) : void
buddyName	string
return	void

enabledebuging() public method

public enabledebuging ( int botid ) : bool
botid	int
return	bool

foodlevel() public method

public foodlevel ( int botid ) : int
botid	int
return	int

getAdvertTextRate() public method

public getAdvertTextRate ( ) : double
return	double

getConnectionStatus() public method

public getConnectionStatus ( string botName ) : string
botName	string
return	string

getDestination() public method

public getDestination ( string mapName, string targetDest, int &objectID, int &useWithObject, int &lastMoveNumber ) : cs_elbot.AdvancedCommunication.ActorHandler.position
mapName	string
targetDest	string
objectID	int
useWithObject	int
lastMoveNumber	int
return	cs_elbot.AdvancedCommunication.ActorHandler.position

getHomeInfo() public method

public getHomeInfo ( ) : void
return	void

getInvFiller() public method

public getInvFiller ( ) : char
return	char

getItemInfo() public method

public getItemInfo ( TradeHandler &MyTradeItem ) : void
MyTradeItem	TradeHandler
return	void

getItemPos() public method

public getItemPos ( int itemID ) : int
itemID	int
return	int

getNPCPosition() public method

public getNPCPosition ( int npcID ) : cs_elbot.AdvancedCommunication.ActorHandler.position
npcID	int
return	cs_elbot.AdvancedCommunication.ActorHandler.position

getObjectPosition() public method

public getObjectPosition ( string mapName, int objectID, int &useWithObject ) : cs_elbot.AdvancedCommunication.ActorHandler.position
mapName	string
objectID	int
useWithObject	int
return	cs_elbot.AdvancedCommunication.ActorHandler.position

getSellRate() public method

public getSellRate ( ) : double
return	double

getShowZeroPrice() public method

public getShowZeroPrice ( ) : bool
return	bool

getStorageNPCName() public method

public getStorageNPCName ( ) : string
return	string

getTextAdvert() public method

public getTextAdvert ( ) : string
return	string

getURL() public method

public getURL ( ) : string
return	string

getWantedFiller() public method

public getWantedFiller ( ) : char
return	char

guildlongname() public method

public guildlongname ( int botid ) : string
botid	int
return	string

hnhmessage() public method

public hnhmessage ( int botid ) : string
botid	int
return	string

isBot() public method

public isBot ( string name ) : bool
name	string
return	bool

lastadverttime() public method

public lastadverttime ( int botid ) : Int32
botid	int
return	System.Int32

lastaltadverttime() public method

public lastaltadverttime ( int botid ) : Int32
botid	int
return	System.Int32

locationdescription() public method

public locationdescription ( int botid ) : string
botid	int
return	string

loggotpms() public method

public loggotpms ( int botid ) : bool
botid	int
return	bool

logsendpms() public method

public logsendpms ( int botid ) : bool
botid	int
return	bool

maxhealth() public method

public maxhealth ( int botid ) : int
botid	int
return	int

minadverttime() public method

public minadverttime ( ) : int
return	int

minaltadverttime() public method

public minaltadverttime ( ) : int
return	int

newhourcolor() public method

public newhourcolor ( int botid ) : int
botid	int
return	int

numberoftextcommands() public method

public numberoftextcommands ( int botid ) : int
botid	int
return	int

playerIsOnline() public static method

public static playerIsOnline ( string playerName ) : bool
playerName	string
return	bool

playerjoinedguildcolor() public method

public playerjoinedguildcolor ( int botid ) : int
botid	int
return	int

playerleftguildcolor() public method

public playerleftguildcolor ( int botid ) : int
botid	int
return	int

playerloggedoffcolor() public method

public playerloggedoffcolor ( int botid ) : int
botid	int
return	int

playerloggedoncolor() public method

public playerloggedoncolor ( int botid ) : int
botid	int
return	int

pmmonitorlist() public method

public pmmonitorlist ( int botid ) : string
botid	int
return	string

randomadvertdelay() public method

public randomadvertdelay ( ) : Int32
return	System.Int32

randomaltadvertdelay() public method

public randomaltadvertdelay ( ) : int
return	int

raw_sql() public method

public raw_sql ( string sql ) : void
sql	string
return	void

reserveItem() public method

public reserveItem ( int itemId, uint numberToReserve, string username ) : bool
itemId	int
numberToReserve	uint
username	string
return	bool

reserveItem() public method

public reserveItem ( int itemId, uint numberToReserve, string username, bool prizeIndicator ) : bool
itemId	int
numberToReserve	uint
username	string
prizeIndicator	bool
return	bool

sendCoinPMs() public method

public sendCoinPMs ( ) : bool
return	bool

senderrorpms() public method

public senderrorpms ( int botid ) : bool
botid	int
return	bool

sendreceivedpms() public method

public sendreceivedpms ( int botid ) : bool
botid	int
return	bool

sendtextcommandtogm() public method

public sendtextcommandtogm ( string Command, int botid ) : bool
Command	string
botid	int
return	bool

setPlayerOffline() public static method

public static setPlayerOffline ( string playerName ) : void
playerName	string
return	void

setPlayerOnline() public static method

public static setPlayerOnline ( string playerName ) : void
playerName	string
return	void

updateGreeting() public method

public updateGreeting ( string username, int botid ) : void
username	string
botid	int
return	void

updateMyLocation() public method

public updateMyLocation ( ) : void
return	void

updatePerks() public method

public updatePerks ( string botPerks ) : void
botPerks	string
return	void

updateVersion() public method

public updateVersion ( ) : void
return	void

updateknownitems() public method

public updateknownitems ( cs_elbot.Inventory item, int id ) : void
item	cs_elbot.Inventory
id	int
return	void

validLaunch() public method

public validLaunch ( string botName, string userName ) : bool
botName	string
userName	string
return	bool

welcomedescription() public method

public welcomedescription ( int botid ) : string
botid	int
return	string

Property Details

playerguildstored public_oe property

public string playerguildstored
return	string

usernamestored public_oe property

public string usernamestored
return	string