• Главная
• cs_elbot
• MySqlManager

C# Класс cs_elbot.MySqlManager

Показать файл Открыть проект Примеры использования класса

Открытые свойства

Свойство	Тип	Описание
playerguildstored	string
usernamestored	string

Открытые методы

Метод	Описание
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

Приватные методы

Метод	Описание
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

Описание методов

Описание свойств