aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r--OpenSim/Data/MySQL/MySQLRegionData.cs14
-rw-r--r--OpenSim/Data/MySQL/Resources/029_RegionStore.sql5
2 files changed, 17 insertions, 2 deletions
diff --git a/OpenSim/Data/MySQL/MySQLRegionData.cs b/OpenSim/Data/MySQL/MySQLRegionData.cs
index b13813f..8a24fec 100644
--- a/OpenSim/Data/MySQL/MySQLRegionData.cs
+++ b/OpenSim/Data/MySQL/MySQLRegionData.cs
@@ -196,6 +196,7 @@ namespace OpenSim.Data.MySQL
196 "ColorR, ColorG, ColorB, ColorA, "+ 196 "ColorR, ColorG, ColorB, ColorA, "+
197 "ParticleSystem, ClickAction, Material, "+ 197 "ParticleSystem, ClickAction, Material, "+
198 "CollisionSound, CollisionSoundVolume, "+ 198 "CollisionSound, CollisionSoundVolume, "+
199 "PassTouches, "+
199 "LinkNumber) values (" + "?UUID, "+ 200 "LinkNumber) values (" + "?UUID, "+
200 "?CreationDate, ?Name, ?Text, "+ 201 "?CreationDate, ?Name, ?Text, "+
201 "?Description, ?SitName, ?TouchName, "+ 202 "?Description, ?SitName, ?TouchName, "+
@@ -227,7 +228,7 @@ namespace OpenSim.Data.MySQL
227 "?SaleType, ?ColorR, ?ColorG, "+ 228 "?SaleType, ?ColorR, ?ColorG, "+
228 "?ColorB, ?ColorA, ?ParticleSystem, "+ 229 "?ColorB, ?ColorA, ?ParticleSystem, "+
229 "?ClickAction, ?Material, ?CollisionSound, "+ 230 "?ClickAction, ?Material, ?CollisionSound, "+
230 "?CollisionSoundVolume, ?LinkNumber)"; 231 "?CollisionSoundVolume, ?PassTouches, ?LinkNumber)";
231 232
232 FillPrimCommand(cmd, prim, obj.UUID, regionUUID); 233 FillPrimCommand(cmd, prim, obj.UUID, regionUUID);
233 234
@@ -950,6 +951,9 @@ namespace OpenSim.Data.MySQL
950 951
951 prim.CollisionSound = new UUID(row["CollisionSound"].ToString()); 952 prim.CollisionSound = new UUID(row["CollisionSound"].ToString());
952 prim.CollisionSoundVolume = Convert.ToSingle(row["CollisionSoundVolume"]); 953 prim.CollisionSoundVolume = Convert.ToSingle(row["CollisionSoundVolume"]);
954
955 if (Convert.ToInt16(row["PassTouches"]) != 0)
956 prim.PassTouches = true;
953 prim.LinkNum = Convert.ToInt32(row["LinkNumber"]); 957 prim.LinkNum = Convert.ToInt32(row["LinkNumber"]);
954 958
955 return prim; 959 return prim;
@@ -1272,6 +1276,12 @@ namespace OpenSim.Data.MySQL
1272 1276
1273 cmd.Parameters.AddWithValue("CollisionSound", prim.CollisionSound.ToString()); 1277 cmd.Parameters.AddWithValue("CollisionSound", prim.CollisionSound.ToString());
1274 cmd.Parameters.AddWithValue("CollisionSoundVolume", prim.CollisionSoundVolume); 1278 cmd.Parameters.AddWithValue("CollisionSoundVolume", prim.CollisionSoundVolume);
1279
1280 if (prim.PassTouches)
1281 cmd.Parameters.AddWithValue("PassTouches", 1);
1282 else
1283 cmd.Parameters.AddWithValue("PassTouches", 0);
1284
1275 cmd.Parameters.AddWithValue("LinkNumber", prim.LinkNum); 1285 cmd.Parameters.AddWithValue("LinkNumber", prim.LinkNum);
1276 } 1286 }
1277 1287
@@ -1534,4 +1544,4 @@ namespace OpenSim.Data.MySQL
1534 } 1544 }
1535 } 1545 }
1536 } 1546 }
1537} \ No newline at end of file 1547}
diff --git a/OpenSim/Data/MySQL/Resources/029_RegionStore.sql b/OpenSim/Data/MySQL/Resources/029_RegionStore.sql
new file mode 100644
index 0000000..b5962a2
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/029_RegionStore.sql
@@ -0,0 +1,5 @@
1BEGIN;
2
3ALTER TABLE prims ADD COLUMN PassTouches tinyint not null default 0;
4
5COMMIT;