C# Class OpenSim.Data.MySQL.MySQLInventoryData

A MySQL interface for the inventory server
Inheritance: IInventoryDataPlugin
Afficher le fichier Open project: N3X15/VoxelSim

Méthodes publiques

Méthode Description
Dispose ( ) : void

Closes this DB provider

do nothing

Initialise ( ) : void
Initialise ( string connect ) : void

Initialises Inventory interface

Loads and initialises the MySQL storage plugin warns and uses the obsolete mysql_connection.ini if connect string is empty. Check for migration

addInventoryFolder ( OpenSim.Framework.InventoryFolderBase folder ) : void

Creates a new inventory folder

addInventoryItem ( OpenSim.Framework.InventoryItemBase item ) : void

Adds a specified item to the database

deleteInventoryFolder ( UUID folderID ) : void

Deletes an inventory folder

deleteInventoryItem ( UUID itemID ) : void

Detele the specified inventory item

fetchActiveGestures ( UUID avatarID ) : List
getFolderHierarchy ( UUID parentID ) : List

See IInventoryDataPlugin

getInventoryFolder ( UUID folderID ) : OpenSim.Framework.InventoryFolderBase

Returns a specified inventory folder

getInventoryFolders ( UUID parentID ) : List

Return a list of folders in a users inventory contained within the specified folder. This method is only used in tests - in normal operation the user always have one, and only one, root folder.

getInventoryInFolder ( UUID folderID ) : List

Returns a list of items in a specified folder

getInventoryItem ( UUID itemID ) : InventoryItemBase

Returns a specified inventory item

getUserRootFolder ( UUID user ) : InventoryFolderBase

see InventoryItemBase.getUserRootFolder

getUserRootFolders ( UUID user ) : List

Returns a list of the root folders within a users inventory

moveInventoryFolder ( InventoryFolderBase folder ) : void

Move an inventory folder

UPDATE inventoryfolders SET parentFolderID=?parentFolderID WHERE folderID=?folderID

queryInventoryFolder ( UUID folderID ) : InventoryFolderBase
queryInventoryItem ( UUID itemID ) : InventoryItemBase
updateInventoryFolder ( InventoryFolderBase folder ) : void

Updates an inventory folder

updateInventoryItem ( InventoryItemBase item ) : void

Updates the specified inventory item

Méthodes protégées

Méthode Description
deleteItemsInFolder ( UUID folderID ) : void

Delete all item in a folder

deleteOneFolder ( UUID folderID ) : void

Delete a folder from database

getInventoryFolders ( List &folders, UUID parentID ) : void

Append a list of all the child folders of a parent folder

readInventoryFolder ( MySqlDataReader reader ) : InventoryFolderBase

Reads a list of inventory folders returned by a query.

Private Methods

Méthode Description
readInventoryItem ( MySqlDataReader reader ) : InventoryItemBase

Reads a one item from an SQL result

Method Details

Dispose() public méthode

Closes this DB provider
do nothing
public Dispose ( ) : void
Résultat void

Initialise() public méthode

public Initialise ( ) : void
Résultat void

Initialise() public méthode

Initialises Inventory interface

Loads and initialises the MySQL storage plugin warns and uses the obsolete mysql_connection.ini if connect string is empty. Check for migration

public Initialise ( string connect ) : void
connect string connect string
Résultat void

addInventoryFolder() public méthode

Creates a new inventory folder
public addInventoryFolder ( OpenSim.Framework.InventoryFolderBase folder ) : void
folder OpenSim.Framework.InventoryFolderBase Folder to create
Résultat void

addInventoryItem() public méthode

Adds a specified item to the database
public addInventoryItem ( OpenSim.Framework.InventoryItemBase item ) : void
item OpenSim.Framework.InventoryItemBase The inventory item
Résultat void

deleteInventoryFolder() public méthode

Deletes an inventory folder
public deleteInventoryFolder ( UUID folderID ) : void
folderID UUID
Résultat void

deleteInventoryItem() public méthode

Detele the specified inventory item
public deleteInventoryItem ( UUID itemID ) : void
itemID UUID
Résultat void

deleteItemsInFolder() protected méthode

Delete all item in a folder
protected deleteItemsInFolder ( UUID folderID ) : void
folderID UUID the folder UUID
Résultat void

deleteOneFolder() protected méthode

Delete a folder from database
protected deleteOneFolder ( UUID folderID ) : void
folderID UUID the folder UUID
Résultat void

fetchActiveGestures() public méthode

public fetchActiveGestures ( UUID avatarID ) : List
avatarID UUID
Résultat List

getFolderHierarchy() public méthode

See IInventoryDataPlugin
public getFolderHierarchy ( UUID parentID ) : List
parentID UUID
Résultat List

getInventoryFolder() public méthode

Returns a specified inventory folder
public getInventoryFolder ( UUID folderID ) : OpenSim.Framework.InventoryFolderBase
folderID UUID The folder to return
Résultat OpenSim.Framework.InventoryFolderBase

getInventoryFolders() public méthode

Return a list of folders in a users inventory contained within the specified folder. This method is only used in tests - in normal operation the user always have one, and only one, root folder.
public getInventoryFolders ( UUID parentID ) : List
parentID UUID The folder to search
Résultat List

getInventoryFolders() protected méthode

Append a list of all the child folders of a parent folder
protected getInventoryFolders ( List &folders, UUID parentID ) : void
folders List list where folders will be appended
parentID UUID ID of parent
Résultat void

getInventoryInFolder() public méthode

Returns a list of items in a specified folder
public getInventoryInFolder ( UUID folderID ) : List
folderID UUID The folder to search
Résultat List

getInventoryItem() public méthode

Returns a specified inventory item
public getInventoryItem ( UUID itemID ) : InventoryItemBase
itemID UUID
Résultat InventoryItemBase

getUserRootFolder() public méthode

see InventoryItemBase.getUserRootFolder
public getUserRootFolder ( UUID user ) : InventoryFolderBase
user UUID The user UUID
Résultat InventoryFolderBase

getUserRootFolders() public méthode

Returns a list of the root folders within a users inventory
public getUserRootFolders ( UUID user ) : List
user UUID The user whose inventory is to be searched
Résultat List

moveInventoryFolder() public méthode

Move an inventory folder
UPDATE inventoryfolders SET parentFolderID=?parentFolderID WHERE folderID=?folderID
public moveInventoryFolder ( InventoryFolderBase folder ) : void
folder InventoryFolderBase Folder to move
Résultat void

queryInventoryFolder() public méthode

public queryInventoryFolder ( UUID folderID ) : InventoryFolderBase
folderID UUID
Résultat InventoryFolderBase

queryInventoryItem() public méthode

public queryInventoryItem ( UUID itemID ) : InventoryItemBase
itemID UUID
Résultat InventoryItemBase

readInventoryFolder() protected static méthode

Reads a list of inventory folders returned by a query.
protected static readInventoryFolder ( MySqlDataReader reader ) : InventoryFolderBase
reader MySqlDataReader A MySQL Data Reader
Résultat InventoryFolderBase

updateInventoryFolder() public méthode

Updates an inventory folder
public updateInventoryFolder ( InventoryFolderBase folder ) : void
folder InventoryFolderBase Folder to update
Résultat void

updateInventoryItem() public méthode

Updates the specified inventory item
public updateInventoryItem ( InventoryItemBase item ) : void
item InventoryItemBase Inventory item to update
Résultat void