aboutsummaryrefslogtreecommitdiffstatshomepage
diff options
context:
space:
mode:
-rw-r--r--OpenSim/Data/MySQL/MySQLRegionData.cs76
-rw-r--r--OpenSim/Data/MySQL/Resources/025_RegionStore.sql78
-rw-r--r--OpenSim/Data/Tests/BasicRegionTest.cs4
-rw-r--r--OpenSim/Region/ScriptEngine/Shared/Api/Runtime/OpenSim.Region.ScriptEngine.Shared.Api.Runtime.mdp1
4 files changed, 82 insertions, 77 deletions
diff --git a/OpenSim/Data/MySQL/MySQLRegionData.cs b/OpenSim/Data/MySQL/MySQLRegionData.cs
index a3ac38e..f64b142 100644
--- a/OpenSim/Data/MySQL/MySQLRegionData.cs
+++ b/OpenSim/Data/MySQL/MySQLRegionData.cs
@@ -1078,38 +1078,38 @@ namespace OpenSim.Data.MySQL
1078 cmd.Parameters.AddWithValue("EveryoneMask", prim.EveryoneMask); 1078 cmd.Parameters.AddWithValue("EveryoneMask", prim.EveryoneMask);
1079 cmd.Parameters.AddWithValue("BaseMask", prim.BaseMask); 1079 cmd.Parameters.AddWithValue("BaseMask", prim.BaseMask);
1080 // vectors 1080 // vectors
1081 cmd.Parameters.AddWithValue("PositionX", prim.OffsetPosition.X); 1081 cmd.Parameters.AddWithValue("PositionX", (double)prim.OffsetPosition.X);
1082 cmd.Parameters.AddWithValue("PositionY", prim.OffsetPosition.Y); 1082 cmd.Parameters.AddWithValue("PositionY", (double)prim.OffsetPosition.Y);
1083 cmd.Parameters.AddWithValue("PositionZ", prim.OffsetPosition.Z); 1083 cmd.Parameters.AddWithValue("PositionZ", (double)prim.OffsetPosition.Z);
1084 cmd.Parameters.AddWithValue("GroupPositionX", prim.GroupPosition.X); 1084 cmd.Parameters.AddWithValue("GroupPositionX", (double)prim.GroupPosition.X);
1085 cmd.Parameters.AddWithValue("GroupPositionY", prim.GroupPosition.Y); 1085 cmd.Parameters.AddWithValue("GroupPositionY", (double)prim.GroupPosition.Y);
1086 cmd.Parameters.AddWithValue("GroupPositionZ", prim.GroupPosition.Z); 1086 cmd.Parameters.AddWithValue("GroupPositionZ", (double)prim.GroupPosition.Z);
1087 cmd.Parameters.AddWithValue("VelocityX", prim.Velocity.X); 1087 cmd.Parameters.AddWithValue("VelocityX", (double)prim.Velocity.X);
1088 cmd.Parameters.AddWithValue("VelocityY", prim.Velocity.Y); 1088 cmd.Parameters.AddWithValue("VelocityY", (double)prim.Velocity.Y);
1089 cmd.Parameters.AddWithValue("VelocityZ", prim.Velocity.Z); 1089 cmd.Parameters.AddWithValue("VelocityZ", (double)prim.Velocity.Z);
1090 cmd.Parameters.AddWithValue("AngularVelocityX", prim.AngularVelocity.X); 1090 cmd.Parameters.AddWithValue("AngularVelocityX", (double)prim.AngularVelocity.X);
1091 cmd.Parameters.AddWithValue("AngularVelocityY", prim.AngularVelocity.Y); 1091 cmd.Parameters.AddWithValue("AngularVelocityY", (double)prim.AngularVelocity.Y);
1092 cmd.Parameters.AddWithValue("AngularVelocityZ", prim.AngularVelocity.Z); 1092 cmd.Parameters.AddWithValue("AngularVelocityZ", (double)prim.AngularVelocity.Z);
1093 cmd.Parameters.AddWithValue("AccelerationX", prim.Acceleration.X); 1093 cmd.Parameters.AddWithValue("AccelerationX", (double)prim.Acceleration.X);
1094 cmd.Parameters.AddWithValue("AccelerationY", prim.Acceleration.Y); 1094 cmd.Parameters.AddWithValue("AccelerationY", (double)prim.Acceleration.Y);
1095 cmd.Parameters.AddWithValue("AccelerationZ", prim.Acceleration.Z); 1095 cmd.Parameters.AddWithValue("AccelerationZ", (double)prim.Acceleration.Z);
1096 // quaternions 1096 // quaternions
1097 cmd.Parameters.AddWithValue("RotationX", prim.RotationOffset.X); 1097 cmd.Parameters.AddWithValue("RotationX", (double)prim.RotationOffset.X);
1098 cmd.Parameters.AddWithValue("RotationY", prim.RotationOffset.Y); 1098 cmd.Parameters.AddWithValue("RotationY", (double)prim.RotationOffset.Y);
1099 cmd.Parameters.AddWithValue("RotationZ", prim.RotationOffset.Z); 1099 cmd.Parameters.AddWithValue("RotationZ", (double)prim.RotationOffset.Z);
1100 cmd.Parameters.AddWithValue("RotationW", prim.RotationOffset.W); 1100 cmd.Parameters.AddWithValue("RotationW", (double)prim.RotationOffset.W);
1101 1101
1102 // Sit target 1102 // Sit target
1103 Vector3 sitTargetPos = prim.SitTargetPositionLL; 1103 Vector3 sitTargetPos = prim.SitTargetPositionLL;
1104 cmd.Parameters.AddWithValue("SitTargetOffsetX", sitTargetPos.X); 1104 cmd.Parameters.AddWithValue("SitTargetOffsetX", (double)sitTargetPos.X);
1105 cmd.Parameters.AddWithValue("SitTargetOffsetY", sitTargetPos.Y); 1105 cmd.Parameters.AddWithValue("SitTargetOffsetY", (double)sitTargetPos.Y);
1106 cmd.Parameters.AddWithValue("SitTargetOffsetZ", sitTargetPos.Z); 1106 cmd.Parameters.AddWithValue("SitTargetOffsetZ", (double)sitTargetPos.Z);
1107 1107
1108 Quaternion sitTargetOrient = prim.SitTargetOrientationLL; 1108 Quaternion sitTargetOrient = prim.SitTargetOrientationLL;
1109 cmd.Parameters.AddWithValue("SitTargetOrientW", sitTargetOrient.W); 1109 cmd.Parameters.AddWithValue("SitTargetOrientW", (double)sitTargetOrient.W);
1110 cmd.Parameters.AddWithValue("SitTargetOrientX", sitTargetOrient.X); 1110 cmd.Parameters.AddWithValue("SitTargetOrientX", (double)sitTargetOrient.X);
1111 cmd.Parameters.AddWithValue("SitTargetOrientY", sitTargetOrient.Y); 1111 cmd.Parameters.AddWithValue("SitTargetOrientY", (double)sitTargetOrient.Y);
1112 cmd.Parameters.AddWithValue("SitTargetOrientZ", sitTargetOrient.Z); 1112 cmd.Parameters.AddWithValue("SitTargetOrientZ", (double)sitTargetOrient.Z);
1113 1113
1114 cmd.Parameters.AddWithValue("PayPrice", prim.PayPrice[0]); 1114 cmd.Parameters.AddWithValue("PayPrice", prim.PayPrice[0]);
1115 cmd.Parameters.AddWithValue("PayButton1", prim.PayPrice[1]); 1115 cmd.Parameters.AddWithValue("PayButton1", prim.PayPrice[1]);
@@ -1131,17 +1131,17 @@ namespace OpenSim.Data.MySQL
1131 cmd.Parameters.AddWithValue("TextureAnimation", prim.TextureAnimation); 1131 cmd.Parameters.AddWithValue("TextureAnimation", prim.TextureAnimation);
1132 cmd.Parameters.AddWithValue("ParticleSystem", prim.ParticleSystem); 1132 cmd.Parameters.AddWithValue("ParticleSystem", prim.ParticleSystem);
1133 1133
1134 cmd.Parameters.AddWithValue("OmegaX", prim.RotationalVelocity.X); 1134 cmd.Parameters.AddWithValue("OmegaX", (double)prim.RotationalVelocity.X);
1135 cmd.Parameters.AddWithValue("OmegaY", prim.RotationalVelocity.Y); 1135 cmd.Parameters.AddWithValue("OmegaY", (double)prim.RotationalVelocity.Y);
1136 cmd.Parameters.AddWithValue("OmegaZ", prim.RotationalVelocity.Z); 1136 cmd.Parameters.AddWithValue("OmegaZ", (double)prim.RotationalVelocity.Z);
1137 1137
1138 cmd.Parameters.AddWithValue("CameraEyeOffsetX", prim.GetCameraEyeOffset().X); 1138 cmd.Parameters.AddWithValue("CameraEyeOffsetX", (double)prim.GetCameraEyeOffset().X);
1139 cmd.Parameters.AddWithValue("CameraEyeOffsetY", prim.GetCameraEyeOffset().Y); 1139 cmd.Parameters.AddWithValue("CameraEyeOffsetY", (double)prim.GetCameraEyeOffset().Y);
1140 cmd.Parameters.AddWithValue("CameraEyeOffsetZ", prim.GetCameraEyeOffset().Z); 1140 cmd.Parameters.AddWithValue("CameraEyeOffsetZ", (double)prim.GetCameraEyeOffset().Z);
1141 1141
1142 cmd.Parameters.AddWithValue("CameraAtOffsetX", prim.GetCameraAtOffset().X); 1142 cmd.Parameters.AddWithValue("CameraAtOffsetX", (double)prim.GetCameraAtOffset().X);
1143 cmd.Parameters.AddWithValue("CameraAtOffsetY", prim.GetCameraAtOffset().Y); 1143 cmd.Parameters.AddWithValue("CameraAtOffsetY", (double)prim.GetCameraAtOffset().Y);
1144 cmd.Parameters.AddWithValue("CameraAtOffsetZ", prim.GetCameraAtOffset().Z); 1144 cmd.Parameters.AddWithValue("CameraAtOffsetZ", (double)prim.GetCameraAtOffset().Z);
1145 1145
1146 if (prim.GetForceMouselook()) 1146 if (prim.GetForceMouselook())
1147 cmd.Parameters.AddWithValue("ForceMouselook", 1); 1147 cmd.Parameters.AddWithValue("ForceMouselook", 1);
@@ -1363,9 +1363,9 @@ byte[] textureEntry = (byte[]) row["Texture"];
1363 // shape is an enum 1363 // shape is an enum
1364 cmd.Parameters.AddWithValue("Shape", 0); 1364 cmd.Parameters.AddWithValue("Shape", 0);
1365 // vectors 1365 // vectors
1366 cmd.Parameters.AddWithValue("ScaleX", s.Scale.X); 1366 cmd.Parameters.AddWithValue("ScaleX", (double)s.Scale.X);
1367 cmd.Parameters.AddWithValue("ScaleY", s.Scale.Y); 1367 cmd.Parameters.AddWithValue("ScaleY", (double)s.Scale.Y);
1368 cmd.Parameters.AddWithValue("ScaleZ", s.Scale.Z); 1368 cmd.Parameters.AddWithValue("ScaleZ", (double)s.Scale.Z);
1369 // paths 1369 // paths
1370 cmd.Parameters.AddWithValue("PCode", s.PCode); 1370 cmd.Parameters.AddWithValue("PCode", s.PCode);
1371 cmd.Parameters.AddWithValue("PathBegin", s.PathBegin); 1371 cmd.Parameters.AddWithValue("PathBegin", s.PathBegin);
diff --git a/OpenSim/Data/MySQL/Resources/025_RegionStore.sql b/OpenSim/Data/MySQL/Resources/025_RegionStore.sql
index 47fb6dd..e8f5d70 100644
--- a/OpenSim/Data/MySQL/Resources/025_RegionStore.sql
+++ b/OpenSim/Data/MySQL/Resources/025_RegionStore.sql
@@ -1,42 +1,46 @@
1BEGIN; 1BEGIN;
2 2
3alter table prims change column `PositionX` `PositionX` float default NULL; 3alter table prims change column `PositionX` `PositionX` double default NULL;
4alter table prims change column `PositionY` `PositionY` float default NULL; 4alter table prims change column `PositionY` `PositionY` double default NULL;
5alter table prims change column `PositionZ` `PositionZ` float default NULL; 5alter table prims change column `PositionZ` `PositionZ` double default NULL;
6alter table prims change column `GroupPositionX` `GroupPositionX` float default NULL; 6alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL;
7alter table prims change column `GroupPositionY` `GroupPositionY` float default NULL; 7alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL;
8alter table prims change column `GroupPositionZ` `GroupPositionZ` float default NULL; 8alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL;
9alter table prims change column `VelocityX` `VelocityX` float default NULL; 9alter table prims change column `VelocityX` `VelocityX` double default NULL;
10alter table prims change column `VelocityY` `VelocityY` float default NULL; 10alter table prims change column `VelocityY` `VelocityY` double default NULL;
11alter table prims change column `VelocityZ` `VelocityZ` float default NULL; 11alter table prims change column `VelocityZ` `VelocityZ` double default NULL;
12alter table prims change column `AngularVelocityX` `AngularVelocityX` float default NULL; 12alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL;
13alter table prims change column `AngularVelocityY` `AngularVelocityY` float default NULL; 13alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL;
14alter table prims change column `AngularVelocityZ` `AngularVelocityZ` float default NULL; 14alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL;
15alter table prims change column `AccelerationX` `AccelerationX` float default NULL; 15alter table prims change column `AccelerationX` `AccelerationX` double default NULL;
16alter table prims change column `AccelerationY` `AccelerationY` float default NULL; 16alter table prims change column `AccelerationY` `AccelerationY` double default NULL;
17alter table prims change column `AccelerationZ` `AccelerationZ` float default NULL; 17alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL;
18alter table prims change column `RotationX` `RotationX` float default NULL; 18alter table prims change column `RotationX` `RotationX` double default NULL;
19alter table prims change column `RotationY` `RotationY` float default NULL; 19alter table prims change column `RotationY` `RotationY` double default NULL;
20alter table prims change column `RotationZ` `RotationZ` float default NULL; 20alter table prims change column `RotationZ` `RotationZ` double default NULL;
21alter table prims change column `RotationW` `RotationW` float default NULL; 21alter table prims change column `RotationW` `RotationW` double default NULL;
22alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` float default NULL; 22alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL;
23alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` float default NULL; 23alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL;
24alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` float default NULL; 24alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL;
25alter table prims change column `SitTargetOrientW` `SitTargetOrientW` float default NULL; 25alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL;
26alter table prims change column `SitTargetOrientX` `SitTargetOrientX` float default NULL; 26alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL;
27alter table prims change column `SitTargetOrientY` `SitTargetOrientY` float default NULL; 27alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL;
28alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` float default NULL; 28alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL;
29alter table prims change column `LoopedSoundGain` `LoopedSoundGain` float NOT NULL default '0'; 29alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0';
30alter table prims change column `OmegaX` `OmegaX` float NOT NULL default '0'; 30alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0';
31alter table prims change column `OmegaY` `OmegaY` float NOT NULL default '0'; 31alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0';
32alter table prims change column `OmegaZ` `OmegaZ` float NOT NULL default '0'; 32alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0';
33alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` float NOT NULL default '0'; 33alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0';
34alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` float NOT NULL default '0'; 34alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0';
35alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` float NOT NULL default '0'; 35alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0';
36alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` float NOT NULL default '0'; 36alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0';
37alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` float NOT NULL default '0'; 37alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0';
38alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` float NOT NULL default '0'; 38alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0';
39alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` float NOT NULL default '0'; 39alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0';
40
41alter table primshapes change column `ScaleX` `ScaleX` double NOT NULL default '0';
42alter table primshapes change column `ScaleY` `ScaleY` double NOT NULL default '0';
43alter table primshapes change column `ScaleZ` `ScaleZ` double NOT NULL default '0';
40 44
41COMMIT; 45COMMIT;
42 46
diff --git a/OpenSim/Data/Tests/BasicRegionTest.cs b/OpenSim/Data/Tests/BasicRegionTest.cs
index 4428e0d..fac0466 100644
--- a/OpenSim/Data/Tests/BasicRegionTest.cs
+++ b/OpenSim/Data/Tests/BasicRegionTest.cs
@@ -220,7 +220,7 @@ namespace OpenSim.Data.Tests
220 uint localid = localID+1; 220 uint localid = localID+1;
221 localID = localID + 1; 221 localID = localID + 1;
222 string name = "Adam West"; 222 string name = "Adam West";
223 byte material = (byte) random.Next(255); 223 byte material = (byte) random.Next(127);
224 ulong regionh = (ulong)random.NextDouble() * (ulong)random.Next(); 224 ulong regionh = (ulong)random.NextDouble() * (ulong)random.Next();
225 int pin = random.Next(); 225 int pin = random.Next();
226 Byte[] partsys = new byte[8]; 226 Byte[] partsys = new byte[8];
@@ -381,7 +381,7 @@ namespace OpenSim.Data.Tests
381 TaskInventoryDictionary dic = new TaskInventoryDictionary(); 381 TaskInventoryDictionary dic = new TaskInventoryDictionary();
382 localID = localID + 1; 382 localID = localID + 1;
383 string name = "West Adam"; 383 string name = "West Adam";
384 byte material = (byte) random.Next(255); 384 byte material = (byte) random.Next(127);
385 ulong regionh = (ulong)random.NextDouble() * (ulong)random.Next(); 385 ulong regionh = (ulong)random.NextDouble() * (ulong)random.Next();
386 int pin = random.Next(); 386 int pin = random.Next();
387 Byte[] partsys = new byte[8]; 387 Byte[] partsys = new byte[8];
diff --git a/OpenSim/Region/ScriptEngine/Shared/Api/Runtime/OpenSim.Region.ScriptEngine.Shared.Api.Runtime.mdp b/OpenSim/Region/ScriptEngine/Shared/Api/Runtime/OpenSim.Region.ScriptEngine.Shared.Api.Runtime.mdp
index baabe65..708afab 100644
--- a/OpenSim/Region/ScriptEngine/Shared/Api/Runtime/OpenSim.Region.ScriptEngine.Shared.Api.Runtime.mdp
+++ b/OpenSim/Region/ScriptEngine/Shared/Api/Runtime/OpenSim.Region.ScriptEngine.Shared.Api.Runtime.mdp
@@ -22,6 +22,7 @@
22 <File name="./LSL_Stub.cs" subtype="Code" buildaction="Compile" dependson="" data="" /> 22 <File name="./LSL_Stub.cs" subtype="Code" buildaction="Compile" dependson="" data="" />
23 <File name="./OSSL_Stub.cs" subtype="Code" buildaction="Compile" dependson="" data="" /> 23 <File name="./OSSL_Stub.cs" subtype="Code" buildaction="Compile" dependson="" data="" />
24 <File name="./ScriptBase.cs" subtype="Code" buildaction="Compile" dependson="" data="" /> 24 <File name="./ScriptBase.cs" subtype="Code" buildaction="Compile" dependson="" data="" />
25 <File name="./ScriptSponsor.cs" subtype="Code" buildaction="Compile" dependson="" data="" />
25 </Contents> 26 </Contents>
26 <References> 27 <References>
27 <ProjectReference type="Assembly" refto="../../../../../../bin/log4net.dll" localcopy="False" /> 28 <ProjectReference type="Assembly" refto="../../../../../../bin/log4net.dll" localcopy="False" />