diff options
author | Tleiades Hax | 2007-10-13 12:35:37 +0000 |
---|---|---|
committer | Tleiades Hax | 2007-10-13 12:35:37 +0000 |
commit | 5a1e896edcb3e5e8341e9d3fb5b3e323c7ec3210 (patch) | |
tree | e2b1b30f60fe91d5b578d39f816925fdc791bae3 /OpenSim/Framework/Data.MySQL/MySQLAssetData.cs | |
parent | Added capbility to use MySQL as the database backend in stand alone mode for ... (diff) | |
download | opensim-SC_OLD-5a1e896edcb3e5e8341e9d3fb5b3e323c7ec3210.zip opensim-SC_OLD-5a1e896edcb3e5e8341e9d3fb5b3e323c7ec3210.tar.gz opensim-SC_OLD-5a1e896edcb3e5e8341e9d3fb5b3e323c7ec3210.tar.bz2 opensim-SC_OLD-5a1e896edcb3e5e8341e9d3fb5b3e323c7ec3210.tar.xz |
OpenSimMain now respects the asset_plugin paramter, and storing of assets will *not* throw an exception
Diffstat (limited to 'OpenSim/Framework/Data.MySQL/MySQLAssetData.cs')
-rw-r--r-- | OpenSim/Framework/Data.MySQL/MySQLAssetData.cs | 23 |
1 files changed, 21 insertions, 2 deletions
diff --git a/OpenSim/Framework/Data.MySQL/MySQLAssetData.cs b/OpenSim/Framework/Data.MySQL/MySQLAssetData.cs index 70e04b6..79f87e0 100644 --- a/OpenSim/Framework/Data.MySQL/MySQLAssetData.cs +++ b/OpenSim/Framework/Data.MySQL/MySQLAssetData.cs | |||
@@ -40,9 +40,28 @@ namespace OpenSim.Framework.Data.MySQL | |||
40 | 40 | ||
41 | } | 41 | } |
42 | 42 | ||
43 | public AssetBase FetchAsset(LLUUID uuid) | 43 | public AssetBase FetchAsset(LLUUID assetID) |
44 | { | 44 | { |
45 | throw new Exception("The method or operation is not implemented."); | 45 | AssetBase asset = null; |
46 | |||
47 | MySqlCommand cmd = new MySqlCommand("SELECT name, description, assetType, invType, local, temporary, data FROM assets WHERE id=?id", _dbConnection.Connection); | ||
48 | MySqlParameter p = cmd.Parameters.Add("?id", MySqlDbType.Binary, 16); | ||
49 | p.Value = assetID.GetBytes(); | ||
50 | using (MySqlDataReader dbReader = cmd.ExecuteReader(System.Data.CommandBehavior.SingleRow)) | ||
51 | { | ||
52 | if (dbReader.Read()) | ||
53 | { | ||
54 | asset = new AssetBase(); | ||
55 | asset.Data = (byte[])dbReader["data"]; | ||
56 | asset.Description = (string)dbReader["description"]; | ||
57 | asset.FullID = assetID; | ||
58 | asset.InvType = (sbyte)dbReader["invType"]; | ||
59 | asset.Local = ((sbyte)dbReader["local"]) != 0 ? true : false; | ||
60 | asset.Name = (string)dbReader["name"]; | ||
61 | asset.Type = (sbyte)dbReader["assetType"]; | ||
62 | } | ||
63 | } | ||
64 | return asset; | ||
46 | } | 65 | } |
47 | 66 | ||
48 | public void CreateAsset(AssetBase asset) | 67 | public void CreateAsset(AssetBase asset) |