C# Class cs_elbot.MySqlManager

description of MySqlManager.
Datei anzeigen 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