File: sql.em

Description: Functions for interacting with a MySQL DBMS. You must have the MySQL headers and libraries installed. Only really tested with dynamically linking mysql libraries on Linux.
Last Modified: 08/31/2015

[-]

Functions:

mysql_affected_rows
mysql_close
mysql_connect
mysql_fetch_row
mysql_field_name
mysql_num_fields
mysql_num_rows
mysql_query
mysql_select_db

[-]

Modules:

[+] Attribute
- AlterAttributeTemporaryMod
- BaseSkillToRawSkill
- CheckSkill
- GetAttribute
- GetAttributeBaseValue
- GetAttributeCap
- GetAttributeDefaultCap
- GetAttributeIntrinsicMod
- GetAttributeLock
- GetAttributeName
- GetAttributeTemporaryMod
- RawSkillToBaseSkill
- SetAttributeBaseValue
- SetAttributeCap
- SetAttributeLock
- SetAttributeTemporaryMod
[+] Basic
- Bin
- Boolean
- CAsc
- CAscZ
- CChr
- CChrZ
- CDbl
- CInt
- CStr
- Compare
- Find
- Hex
- Len
- Lower
- Pack
- PackJSON
- SizeOf
- SplitWords
- StrReplace
- SubStr
- SubStrReplace
- Trim
- TypeOf
- TypeOfInt
- Unpack
- UnpackJSON
- Upper
[+] BasicIO
- Print
[+] Boat
- BoatFromItem
- MoveBoat
- MoveBoatRelative
- MoveBoatXY
- RegisterItemWithBoat
- SystemFindBoatBySerial
- TurnBoat
[+] CfgFile
- AppendConfigFileElem
- FindConfigElem
- GetConfigInt
- GetConfigIntArray
- GetConfigIntKeys
- GetConfigMaxIntKey
- GetConfigReal
- GetConfigString
- GetConfigStringArray
- GetConfigStringDictionary
- GetConfigStringKeys
- ListConfigElemProps
- LoadTusScpFile
- ReadConfigFile
- UnloadConfigFile
[+] CliLoc
- PrintTextAboveCL
- PrintTextAbovePrivateCL
- SendSysMessageCL
[+] DataFile
- CreateDataFile
- ListDataFiles
- OpenDataFile
- UnloadDataFile
[+] File
- AppendToFile
- CreateDirectory
- CreateXmlFile
- FileExists
- ListDirectory
- LogToFile
- OpenBinaryFile
- OpenXmlFile
- ReadFile
- WriteFile
[+] Guild
- CreateGuild
- DestroyGuild
- FindGuild
- ListGuilds
[+] Http
- QueryIP
- QueryParam
- WriteHtml
- WriteHtmlRaw
[+] Math
- ACos
- ASin
- ATan
- Abs
- Ceil
- ConstE
- ConstPi
- Cos
- DegToRad
- Floor
- FormatRealToString
- Log10
- LogE
- Max
- Min
- Pow
- RadToDeg
- Root
- Sin
- Sqrt
- Tan
[+] Npc
- CanMove
- Face
- GetProperty
- IsLegalMove
- MakeBoundingBox
- Move
- RunAwayFrom
- RunAwayFromLocation
- RunToward
- RunTowardLocation
- Say
- SayUC
- Self
- SetAnchor
- SetOpponent
- SetProperty
- SetWarMode
- TurnAwayFrom
- TurnAwayFromLocation
- TurnToward
- TurnTowardLocation
- WalkAwayFrom
- WalkAwayFromLocation
- WalkToward
- WalkTowardLocation
- Wander
[+] OS
- Clear_Event_Queue
- Create_Debug_Context
- Debugger
- Events_Waiting
- GetPid
- GetProcess
- HTTPRequest
- Is_Critical
- OpenConnection
- OpenURL
- PerformanceMeasure
- Run_Script
- Run_Script_To_Completion
- Set_Critical
- Set_Debug
- Set_Event_Queue_Size
- Set_Priority
- Set_Script_Option
- Sleep
- Sleepms
- Start_Script
- Start_Skill_Script
- SysLog
- System_RPM
- Unload_Scripts
- Wait_For_Event
[+] Party
- CreateParty
- DisbandParty
- SendPartyMsg
- SendPrivatePartyMsg
[+] PolSys
- AddRealm
- CreatePacket
- DeleteRealm
- FormatItemDescription
- GetCmdLevelName
- GetCmdLevelNumber
- GetItemDescriptor
- GetPackageByName
- IncRevision
- ListTextCommands
- ListenPoints
- LogCPropProfile
- MD5Encrypt
- Packages
- ReadMillisecondClock
- Realms
- ReloadConfiguration
- SetSysTrayPopupText
[+] Storage
- CreateRootItemInStorageArea
- CreateStorageArea
- DestroyRootItemInStorageArea
- FindRootItemInStorageArea
- FindStorageArea
- StorageAreas
[+] MySQL
- mysql_affected_rows
- mysql_close
- mysql_connect
- mysql_fetch_row
- mysql_field_name
- mysql_num_fields
- mysql_num_rows
- mysql_query
- mysql_select_db
[+] Unicode
- BroadcastUC
- PrintTextAbovePrivateUC
- PrintTextAboveUC
- RequestInputUC
- SendSysMessageUC
[+] UO
- Accessible
- AddAmount
- AddMenuItem
- ApplyConstraint
- AssignRectToWeatherRegion
- Attach
- Broadcast
- CanWalk
- CancelTarget
- CheckLineOfSight
- CheckLosAt
- CheckLosBetween
- CloseGump
- CloseTradeWindow
- CloseWindow
- ConsumeReagents
- ConsumeSubstance
- CoordinateDistance
- CoordinateDistanceEuclidean
- CreateAccount
- CreateItemAtLocation
- CreateItemCopyAtLocation
- CreateItemInBackpack
- CreateItemInContainer
- CreateItemInInventory
- CreateMenu
- CreateMultiAtLocation
- CreateNpcFromTemplate
- DestroyItem
- DestroyMulti
- Detach
- DisableEvents
- DisconnectClient
- Distance
- DistanceEuclidean
- EnableEvents
- EnumerateItemsInContainer
- EnumerateOnlineCharacters
- EquipFromTemplate
- EquipItem
- EraseGlobalProperty
- EraseObjProperty
- FindAccount
- FindObjtypeInContainer
- FindPath
- FindSubstance
- GetAmount
- GetCommandHelp
- GetCoordsInLine
- GetEquipmentByLayer
- GetFacing
- GetGlobalProperty
- GetGlobalPropertyNames
- GetHarvestDifficulty
- GetMapInfo
- GetMenuObjTypes
- GetMidpointCircleCoords
- GetMultiDimensions
- GetObjProperty
- GetObjPropertyNames
- GetObjType
- GetObjTypeByName
- GetRegionLightLevelAtLocation
- GetRegionName
- GetRegionNameAtLocation
- GetRegionString
- GetSpellDifficulty
- GetStandingHeight
- GetStandingLayers
- GetWorldHeight
- GrantPrivilege
- HarvestResource
- IsStackable
- ListAccounts
- ListEquippedItems
- ListGhostsNearLocation
- ListHostiles
- ListItemsAtLocation
- ListItemsNearLocation
- ListItemsNearLocationOfType
- ListItemsNearLocationWithFlag
- ListMobilesInBox
- ListMobilesInLineOfSight
- ListMobilesNearLocation
- ListMobilesNearLocationEx
- ListMultisInBox
- ListObjectsInBox
- ListOfflineMobilesInRealm
- ListStaticsAtLocation
- ListStaticsInBox
- ListStaticsNearLocation
- MoveItemToContainer
- MoveItemToSecureTradeWin
- MoveObjectToLocation
- OpenPaperdoll
- POLCore
- PerformAction
- PlayLightningBoltEffect
- PlayMovingEffect
- PlayMovingEffectEx
- PlayMovingEffectXYZ
- PlayMovingEffectXYZEx
- PlayMusic
- PlayObjectCenteredEffect
- PlayObjectCenteredEffectEx
- PlaySoundEffect
- PlaySoundEffectPrivate
- PlaySoundEffectXYZ
- PlayStationaryEffect
- PlayStationaryEffectEx
- PrintTextAbove
- PrintTextAbovePrivate
- ReadGameClock
- RegisterForSpeechEvents
- ReleaseItem
- RequestInput
- ReserveItem
- RestartScript
- Resurrect
- RevokePrivilege
- SaveWorldState
- SecureTradeWin
- SelectColor
- SelectMenuItem2
- SendBuyWindow
- SendCharProfile
- SendCharacterRaceChanger
- SendDialogGump
- SendEvent
- SendHousingTool
- SendInstaResDialog
- SendOpenBook
- SendOpenSpecialContainer
- SendOverallSeason
- SendPacket
- SendPopUpMenu
- SendQuestArrow
- SendSellWindow
- SendSkillWindow
- SendStatus
- SendStringAsTipWindow
- SendSysMessage
- SendTextEntryGump
- SendViewContainer
- SetGlobalProperty
- SetName
- SetObjProperty
- SetRegionLightLevel
- SetRegionWeatherLevel
- SetScriptController
- Shutdown
- SingleClick
- SpeakPowerWords
- StartSpellEffect
- SubtractAmount
- SystemFindObjectBySerial
- Target
- TargetCoordinates
- TargetMultiPlacement
- UpdateItem
- UpdateMobile
- UseItem
[+] Util
- RandomDiceRoll
- RandomFloat
- RandomInt
- RandomIntMinMax
- StrFormatTime
[+] Vitals
- ApplyDamage
- ApplyRawDamage
- ConsumeMana
- ConsumeVital
- GetVital
- GetVitalMaximumValue
- GetVitalName
- GetVitalRegenRate
- HealDamage
- RecalcVitals
- SetVital

[^]

mysql_affected_rows(result)
Parameters:
Name	Type
`result`	Result object
Explanation
Returns number of rows affected by last query.
Return values
Integer on success

[^]

mysql_close(connection)
Parameters:
Name	Type
`connection`	Connection object
Explanation
Closed the connection to DBMS.
Return values
1 on success

[^]

mysql_connect(host,username,password := "")
Parameters:
Name	Type
`host`	MySQL DBMS hostname, usually 'localhost'
`username`	User Name for the connection
`password`	Password for the connection
Explanation
Connects to DMBS.
Return values
Connection on success

[^]

mysql_fetch_row(result)
Parameters:
Name	Type
`result`	Result object
Explanation
Fetches next row from Result.
Return values
Array on success

[^]

mysql_field_name(result,column_index)
Parameters:
Name	Type
`result`	Result object
`column_index`	index for the field in the result
Explanation
Returns the given field's name in result.
Return values
String on success

[^]

mysql_num_fields(result)
Parameters:
Name	Type
`result`	Result object
Explanation
Returns number of fields in result.
Return values
Integer on success

[^]

mysql_num_rows(result)
Parameters:
Name	Type
`result`	Result object
Explanation
Returns number of rows in result.
Return values
Integer on success

[^]

mysql_query(connection,query,parameters := "")
Parameters:
Name	Type
`connection`	Connection object
`query`	the SQL query to perform
`parameters`	Array of parameters.
Explanation
Performs a query. Every occurrence of ? in the query will be replaced by corresponding parameter in the parameters array (if present). Parameters are automatically escaped. All parameters are handled as string by now.
Example: mysql_query(conn, "SELECT a FROM t WHERE a = ? AND b = ?", array{1,"hel'lo") executes "SELECT a FROM t WHERE a = '1' AND b = 'hel\'lo'"
Return values
Connection on success

[^]

mysql_select_db(connection,database)
Parameters:
Name	Type
`connection`	Connection object
`database`	database name
Explanation
Select a database to perform queries on.
Return values
1 on success