SQLiteSimulationData.cs 129 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956
  1. /*
  2. * Copyright (c) Contributors, http://opensimulator.org/
  3. * See CONTRIBUTORS.TXT for a full list of copyright holders.
  4. *
  5. * Redistribution and use in source and binary forms, with or without
  6. * modification, are permitted provided that the following conditions are met:
  7. * * Redistributions of source code must retain the above copyright
  8. * notice, this list of conditions and the following disclaimer.
  9. * * Redistributions in binary form must reproduce the above copyright
  10. * notice, this list of conditions and the following disclaimer in the
  11. * documentation and/or other materials provided with the distribution.
  12. * * Neither the name of the OpenSimulator Project nor the
  13. * names of its contributors may be used to endorse or promote products
  14. * derived from this software without specific prior written permission.
  15. *
  16. * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY
  17. * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
  18. * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
  19. * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY
  20. * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
  21. * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
  22. * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
  23. * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  24. * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
  25. * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  26. */
  27. using System;
  28. using System.Collections.Generic;
  29. using System.Data;
  30. using System.Drawing;
  31. using System.IO;
  32. using System.Reflection;
  33. using log4net;
  34. #if CSharpSqlite
  35. using Community.CsharpSqlite.Sqlite;
  36. #else
  37. using Mono.Data.Sqlite;
  38. #endif
  39. using OpenMetaverse;
  40. using OpenMetaverse.StructuredData;
  41. using OpenSim.Framework;
  42. using OpenSim.Region.Framework.Interfaces;
  43. using OpenSim.Region.Framework.Scenes;
  44. namespace OpenSim.Data.SQLite
  45. {
  46. /// <summary>
  47. /// A RegionData Interface to the SQLite database
  48. /// </summary>
  49. public class SQLiteSimulationData : ISimulationDataStore
  50. {
  51. private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType);
  52. private static readonly string LogHeader = "[REGION DB SQLLITE]";
  53. private const string primSelect = "select * from prims";
  54. private const string shapeSelect = "select * from primshapes";
  55. private const string itemsSelect = "select * from primitems";
  56. private const string terrainSelect = "select * from terrain limit 1";
  57. private const string landSelect = "select * from land";
  58. private const string landAccessListSelect = "select distinct * from landaccesslist";
  59. private const string regionbanListSelect = "select * from regionban";
  60. private const string regionSettingsSelect = "select * from regionsettings";
  61. private const string regionWindlightSelect = "select * from regionwindlight";
  62. private const string regionEnvironmentSelect = "select * from regionenvironment";
  63. private const string regionSpawnPointsSelect = "select * from spawn_points";
  64. private DataSet ds;
  65. private SqliteDataAdapter primDa;
  66. private SqliteDataAdapter shapeDa;
  67. private SqliteDataAdapter itemsDa;
  68. private SqliteDataAdapter terrainDa;
  69. private SqliteDataAdapter landDa;
  70. private SqliteDataAdapter landAccessListDa;
  71. private SqliteDataAdapter regionSettingsDa;
  72. private SqliteDataAdapter regionWindlightDa;
  73. private SqliteDataAdapter regionEnvironmentDa;
  74. private SqliteDataAdapter regionSpawnPointsDa;
  75. private SqliteConnection m_conn;
  76. private String m_connectionString;
  77. protected virtual Assembly Assembly
  78. {
  79. get { return GetType().Assembly; }
  80. }
  81. public SQLiteSimulationData()
  82. {
  83. }
  84. public SQLiteSimulationData(string connectionString)
  85. {
  86. Initialise(connectionString);
  87. }
  88. // Temporary attribute while this is experimental
  89. /***********************************************************************
  90. *
  91. * Public Interface Functions
  92. *
  93. **********************************************************************/
  94. /// <summary>
  95. /// <list type="bullet">
  96. /// <item>Initialises RegionData Interface</item>
  97. /// <item>Loads and initialises a new SQLite connection and maintains it.</item>
  98. /// </list>
  99. /// </summary>
  100. /// <param name="connectionString">the connection string</param>
  101. public void Initialise(string connectionString)
  102. {
  103. try
  104. {
  105. if (Util.IsWindows())
  106. Util.LoadArchSpecificWindowsDll("sqlite3.dll");
  107. m_connectionString = connectionString;
  108. ds = new DataSet("Region");
  109. m_log.Info("[SQLITE REGION DB]: Sqlite - connecting: " + connectionString);
  110. m_conn = new SqliteConnection(m_connectionString);
  111. m_conn.Open();
  112. SqliteCommand primSelectCmd = new SqliteCommand(primSelect, m_conn);
  113. primDa = new SqliteDataAdapter(primSelectCmd);
  114. SqliteCommand shapeSelectCmd = new SqliteCommand(shapeSelect, m_conn);
  115. shapeDa = new SqliteDataAdapter(shapeSelectCmd);
  116. // SqliteCommandBuilder shapeCb = new SqliteCommandBuilder(shapeDa);
  117. SqliteCommand itemsSelectCmd = new SqliteCommand(itemsSelect, m_conn);
  118. itemsDa = new SqliteDataAdapter(itemsSelectCmd);
  119. SqliteCommand terrainSelectCmd = new SqliteCommand(terrainSelect, m_conn);
  120. terrainDa = new SqliteDataAdapter(terrainSelectCmd);
  121. SqliteCommand landSelectCmd = new SqliteCommand(landSelect, m_conn);
  122. landDa = new SqliteDataAdapter(landSelectCmd);
  123. SqliteCommand landAccessListSelectCmd = new SqliteCommand(landAccessListSelect, m_conn);
  124. landAccessListDa = new SqliteDataAdapter(landAccessListSelectCmd);
  125. SqliteCommand regionSettingsSelectCmd = new SqliteCommand(regionSettingsSelect, m_conn);
  126. regionSettingsDa = new SqliteDataAdapter(regionSettingsSelectCmd);
  127. SqliteCommand regionWindlightSelectCmd = new SqliteCommand(regionWindlightSelect, m_conn);
  128. regionWindlightDa = new SqliteDataAdapter(regionWindlightSelectCmd);
  129. SqliteCommand regionEnvironmentSelectCmd = new SqliteCommand(regionEnvironmentSelect, m_conn);
  130. regionEnvironmentDa = new SqliteDataAdapter(regionEnvironmentSelectCmd);
  131. SqliteCommand regionSpawnPointsSelectCmd = new SqliteCommand(regionSpawnPointsSelect, m_conn);
  132. regionSpawnPointsDa = new SqliteDataAdapter(regionSpawnPointsSelectCmd);
  133. // This actually does the roll forward assembly stuff
  134. Migration m = new Migration(m_conn, Assembly, "RegionStore");
  135. m.Update();
  136. lock (ds)
  137. {
  138. ds.Tables.Add(createPrimTable());
  139. setupPrimCommands(primDa, m_conn);
  140. ds.Tables.Add(createShapeTable());
  141. setupShapeCommands(shapeDa, m_conn);
  142. ds.Tables.Add(createItemsTable());
  143. setupItemsCommands(itemsDa, m_conn);
  144. ds.Tables.Add(createTerrainTable());
  145. setupTerrainCommands(terrainDa, m_conn);
  146. ds.Tables.Add(createLandTable());
  147. setupLandCommands(landDa, m_conn);
  148. ds.Tables.Add(createLandAccessListTable());
  149. setupLandAccessCommands(landAccessListDa, m_conn);
  150. ds.Tables.Add(createRegionSettingsTable());
  151. setupRegionSettingsCommands(regionSettingsDa, m_conn);
  152. ds.Tables.Add(createRegionWindlightTable());
  153. setupRegionWindlightCommands(regionWindlightDa, m_conn);
  154. ds.Tables.Add(createRegionEnvironmentTable());
  155. setupRegionEnvironmentCommands(regionEnvironmentDa, m_conn);
  156. ds.Tables.Add(createRegionSpawnPointsTable());
  157. setupRegionSpawnPointsCommands(regionSpawnPointsDa, m_conn);
  158. // WORKAROUND: This is a work around for sqlite on
  159. // windows, which gets really unhappy with blob columns
  160. // that have no sample data in them. At some point we
  161. // need to actually find a proper way to handle this.
  162. try
  163. {
  164. primDa.Fill(ds.Tables["prims"]);
  165. }
  166. catch (Exception e)
  167. {
  168. m_log.ErrorFormat("[SQLITE REGION DB]: Caught fill error on prims table :{0}", e.Message);
  169. }
  170. try
  171. {
  172. shapeDa.Fill(ds.Tables["primshapes"]);
  173. }
  174. catch (Exception e)
  175. {
  176. m_log.ErrorFormat("[SQLITE REGION DB]: Caught fill error on primshapes table :{0}", e.Message);
  177. }
  178. try
  179. {
  180. itemsDa.Fill(ds.Tables["primitems"]);
  181. }
  182. catch (Exception e)
  183. {
  184. m_log.ErrorFormat("[SQLITE REGION DB]: Caught fill error on primitems table :{0}", e.Message);
  185. }
  186. try
  187. {
  188. terrainDa.Fill(ds.Tables["terrain"]);
  189. }
  190. catch (Exception e)
  191. {
  192. m_log.ErrorFormat("[SQLITE REGION DB]: Caught fill error on terrain table :{0}", e.Message);
  193. }
  194. try
  195. {
  196. landDa.Fill(ds.Tables["land"]);
  197. }
  198. catch (Exception e)
  199. {
  200. m_log.ErrorFormat("[SQLITE REGION DB]: Caught fill error on land table :{0}", e.Message);
  201. }
  202. try
  203. {
  204. landAccessListDa.Fill(ds.Tables["landaccesslist"]);
  205. }
  206. catch (Exception e)
  207. {
  208. m_log.ErrorFormat("[SQLITE REGION DB]: Caught fill error on landaccesslist table :{0}", e.Message);
  209. }
  210. try
  211. {
  212. regionSettingsDa.Fill(ds.Tables["regionsettings"]);
  213. }
  214. catch (Exception e)
  215. {
  216. m_log.ErrorFormat("[SQLITE REGION DB]: Caught fill error on regionsettings table :{0}", e.Message);
  217. }
  218. try
  219. {
  220. regionWindlightDa.Fill(ds.Tables["regionwindlight"]);
  221. }
  222. catch (Exception e)
  223. {
  224. m_log.ErrorFormat("[SQLITE REGION DB]: Caught fill error on regionwindlight table :{0}", e.Message);
  225. }
  226. try
  227. {
  228. regionEnvironmentDa.Fill(ds.Tables["regionenvironment"]);
  229. }
  230. catch (Exception e)
  231. {
  232. m_log.ErrorFormat("[SQLITE REGION DB]: Caught fill error on regionenvironment table :{0}", e.Message);
  233. }
  234. try
  235. {
  236. regionSpawnPointsDa.Fill(ds.Tables["spawn_points"]);
  237. }
  238. catch (Exception e)
  239. {
  240. m_log.ErrorFormat("[SQLITE REGION DB]: Caught fill error on spawn_points table :{0}", e.Message);
  241. }
  242. // We have to create a data set mapping for every table, otherwise the IDataAdaptor.Update() will not populate rows with values!
  243. // Not sure exactly why this is - this kind of thing was not necessary before - justincc 20100409
  244. // Possibly because we manually set up our own DataTables before connecting to the database
  245. CreateDataSetMapping(primDa, "prims");
  246. CreateDataSetMapping(shapeDa, "primshapes");
  247. CreateDataSetMapping(itemsDa, "primitems");
  248. CreateDataSetMapping(terrainDa, "terrain");
  249. CreateDataSetMapping(landDa, "land");
  250. CreateDataSetMapping(landAccessListDa, "landaccesslist");
  251. CreateDataSetMapping(regionSettingsDa, "regionsettings");
  252. CreateDataSetMapping(regionWindlightDa, "regionwindlight");
  253. CreateDataSetMapping(regionEnvironmentDa, "regionenvironment");
  254. CreateDataSetMapping(regionSpawnPointsDa, "spawn_points");
  255. }
  256. }
  257. catch (Exception e)
  258. {
  259. m_log.ErrorFormat("[SQLITE REGION DB]: {0} - {1}", e.Message, e.StackTrace);
  260. Environment.Exit(23);
  261. }
  262. return;
  263. }
  264. public void Dispose()
  265. {
  266. if (m_conn != null)
  267. {
  268. m_conn.Close();
  269. m_conn = null;
  270. }
  271. if (ds != null)
  272. {
  273. ds.Dispose();
  274. ds = null;
  275. }
  276. if (primDa != null)
  277. {
  278. primDa.Dispose();
  279. primDa = null;
  280. }
  281. if (shapeDa != null)
  282. {
  283. shapeDa.Dispose();
  284. shapeDa = null;
  285. }
  286. if (itemsDa != null)
  287. {
  288. itemsDa.Dispose();
  289. itemsDa = null;
  290. }
  291. if (terrainDa != null)
  292. {
  293. terrainDa.Dispose();
  294. terrainDa = null;
  295. }
  296. if (landDa != null)
  297. {
  298. landDa.Dispose();
  299. landDa = null;
  300. }
  301. if (landAccessListDa != null)
  302. {
  303. landAccessListDa.Dispose();
  304. landAccessListDa = null;
  305. }
  306. if (regionSettingsDa != null)
  307. {
  308. regionSettingsDa.Dispose();
  309. regionSettingsDa = null;
  310. }
  311. if (regionWindlightDa != null)
  312. {
  313. regionWindlightDa.Dispose();
  314. regionWindlightDa = null;
  315. }
  316. if (regionEnvironmentDa != null)
  317. {
  318. regionEnvironmentDa.Dispose();
  319. regionEnvironmentDa = null;
  320. }
  321. if (regionSpawnPointsDa != null)
  322. {
  323. regionSpawnPointsDa.Dispose();
  324. regionWindlightDa = null;
  325. }
  326. }
  327. public void StoreRegionSettings(RegionSettings rs)
  328. {
  329. lock (ds)
  330. {
  331. DataTable regionsettings = ds.Tables["regionsettings"];
  332. DataRow settingsRow = regionsettings.Rows.Find(rs.RegionUUID.ToString());
  333. if (settingsRow == null)
  334. {
  335. settingsRow = regionsettings.NewRow();
  336. fillRegionSettingsRow(settingsRow, rs);
  337. regionsettings.Rows.Add(settingsRow);
  338. }
  339. else
  340. {
  341. fillRegionSettingsRow(settingsRow, rs);
  342. }
  343. StoreSpawnPoints(rs);
  344. Commit();
  345. }
  346. }
  347. public void StoreSpawnPoints(RegionSettings rs)
  348. {
  349. lock (ds)
  350. {
  351. // DataTable spawnpoints = ds.Tables["spawn_points"];
  352. // remove region's spawnpoints
  353. using (
  354. SqliteCommand cmd =
  355. new SqliteCommand("delete from spawn_points where RegionID=:RegionID",
  356. m_conn))
  357. {
  358. cmd.Parameters.Add(new SqliteParameter(":RegionID", rs.RegionUUID.ToString()));
  359. cmd.ExecuteNonQuery();
  360. }
  361. }
  362. foreach (SpawnPoint sp in rs.SpawnPoints())
  363. {
  364. using (SqliteCommand cmd = new SqliteCommand("insert into spawn_points(RegionID, Yaw, Pitch, Distance)" +
  365. "values ( :RegionID, :Yaw, :Pitch, :Distance)", m_conn))
  366. {
  367. cmd.Parameters.Add(new SqliteParameter(":RegionID", rs.RegionUUID.ToString()));
  368. cmd.Parameters.Add(new SqliteParameter(":Yaw", sp.Yaw));
  369. cmd.Parameters.Add(new SqliteParameter(":Pitch", sp.Pitch));
  370. cmd.Parameters.Add(new SqliteParameter(":Distance", sp.Distance));
  371. cmd.ExecuteNonQuery();
  372. }
  373. }
  374. }
  375. /// <summary>
  376. /// Load windlight settings from region storage
  377. /// </summary>
  378. /// <param name="regionUUID">RegionID</param>
  379. public RegionLightShareData LoadRegionWindlightSettings(UUID regionUUID)
  380. {
  381. RegionLightShareData wl = null;
  382. lock (ds)
  383. {
  384. DataTable windlightTable = ds.Tables["regionwindlight"];
  385. DataRow windlightRow = windlightTable.Rows.Find(regionUUID.ToString());
  386. if (windlightRow == null)
  387. {
  388. wl = new RegionLightShareData();
  389. wl.regionID = regionUUID;
  390. StoreRegionWindlightSettings(wl);
  391. return wl;
  392. }
  393. wl = buildRegionWindlight(windlightRow);
  394. return wl;
  395. }
  396. }
  397. /// <summary>
  398. /// Remove windlight settings from region storage
  399. /// </summary>
  400. /// <param name="regionID">RegionID</param>
  401. public void RemoveRegionWindlightSettings(UUID regionID)
  402. {
  403. lock (ds)
  404. {
  405. DataTable windlightTable = ds.Tables["regionwindlight"];
  406. DataRow windlightRow = windlightTable.Rows.Find(regionID.ToString());
  407. if (windlightRow != null)
  408. {
  409. windlightRow.Delete();
  410. }
  411. }
  412. Commit();
  413. }
  414. /// <summary>
  415. /// Adds an windlight into region storage
  416. /// </summary>
  417. /// <param name="wl">RegionLightShareData</param>
  418. public void StoreRegionWindlightSettings(RegionLightShareData wl)
  419. {
  420. lock (ds)
  421. {
  422. DataTable windlightTable = ds.Tables["regionwindlight"];
  423. DataRow windlightRow = windlightTable.Rows.Find(wl.regionID.ToString());
  424. if (windlightRow == null)
  425. {
  426. windlightRow = windlightTable.NewRow();
  427. fillRegionWindlightRow(windlightRow, wl);
  428. windlightTable.Rows.Add(windlightRow);
  429. }
  430. else
  431. {
  432. fillRegionWindlightRow(windlightRow, wl);
  433. }
  434. Commit();
  435. }
  436. }
  437. #region Region Environment Settings
  438. public string LoadRegionEnvironmentSettings(UUID regionUUID)
  439. {
  440. lock (ds)
  441. {
  442. DataTable environmentTable = ds.Tables["regionenvironment"];
  443. DataRow row = environmentTable.Rows.Find(regionUUID.ToString());
  444. if (row == null)
  445. {
  446. return String.Empty;
  447. }
  448. return (String)row["llsd_settings"];
  449. }
  450. }
  451. public void StoreRegionEnvironmentSettings(UUID regionUUID, string settings)
  452. {
  453. lock (ds)
  454. {
  455. DataTable environmentTable = ds.Tables["regionenvironment"];
  456. DataRow row = environmentTable.Rows.Find(regionUUID.ToString());
  457. if (row == null)
  458. {
  459. row = environmentTable.NewRow();
  460. row["region_id"] = regionUUID.ToString();
  461. row["llsd_settings"] = settings;
  462. environmentTable.Rows.Add(row);
  463. }
  464. else
  465. {
  466. row["llsd_settings"] = settings;
  467. }
  468. regionEnvironmentDa.Update(ds, "regionenvironment");
  469. }
  470. }
  471. public void RemoveRegionEnvironmentSettings(UUID regionUUID)
  472. {
  473. lock (ds)
  474. {
  475. DataTable environmentTable = ds.Tables["regionenvironment"];
  476. DataRow row = environmentTable.Rows.Find(regionUUID.ToString());
  477. if (row != null)
  478. {
  479. row.Delete();
  480. }
  481. regionEnvironmentDa.Update(ds, "regionenvironment");
  482. }
  483. }
  484. #endregion
  485. public RegionSettings LoadRegionSettings(UUID regionUUID)
  486. {
  487. lock (ds)
  488. {
  489. DataTable regionsettings = ds.Tables["regionsettings"];
  490. string searchExp = "regionUUID = '" + regionUUID.ToString() + "'";
  491. DataRow[] rawsettings = regionsettings.Select(searchExp);
  492. if (rawsettings.Length == 0)
  493. {
  494. RegionSettings rs = new RegionSettings();
  495. rs.RegionUUID = regionUUID;
  496. rs.OnSave += StoreRegionSettings;
  497. StoreRegionSettings(rs);
  498. return rs;
  499. }
  500. DataRow row = rawsettings[0];
  501. RegionSettings newSettings = buildRegionSettings(row);
  502. newSettings.OnSave += StoreRegionSettings;
  503. LoadSpawnPoints(newSettings);
  504. return newSettings;
  505. }
  506. }
  507. private void LoadSpawnPoints(RegionSettings rs)
  508. {
  509. rs.ClearSpawnPoints();
  510. DataTable spawnpoints = ds.Tables["spawn_points"];
  511. string byRegion = "RegionID = '" + rs.RegionUUID + "'";
  512. DataRow[] spForRegion = spawnpoints.Select(byRegion);
  513. foreach (DataRow spRow in spForRegion)
  514. {
  515. SpawnPoint sp = new SpawnPoint();
  516. sp.Pitch = (float)spRow["Pitch"];
  517. sp.Yaw = (float)spRow["Yaw"];
  518. sp.Distance = (float)spRow["Distance"];
  519. rs.AddSpawnPoint(sp);
  520. }
  521. }
  522. /// <summary>
  523. /// Adds an object into region storage
  524. /// </summary>
  525. /// <param name="obj">the object</param>
  526. /// <param name="regionUUID">the region UUID</param>
  527. public void StoreObject(SceneObjectGroup obj, UUID regionUUID)
  528. {
  529. uint flags = obj.RootPart.GetEffectiveObjectFlags();
  530. // Eligibility check
  531. //
  532. if ((flags & (uint)PrimFlags.Temporary) != 0)
  533. return;
  534. if ((flags & (uint)PrimFlags.TemporaryOnRez) != 0)
  535. return;
  536. lock (ds)
  537. {
  538. foreach (SceneObjectPart prim in obj.Parts)
  539. {
  540. // m_log.Info("[REGION DB]: Adding obj: " + obj.UUID + " to region: " + regionUUID);
  541. addPrim(prim, obj.UUID, regionUUID);
  542. }
  543. }
  544. Commit();
  545. // m_log.Info("[Dump of prims]: " + ds.GetXml());
  546. }
  547. /// <summary>
  548. /// Removes an object from region storage
  549. /// </summary>
  550. /// <param name="obj">the object</param>
  551. /// <param name="regionUUID">the region UUID</param>
  552. public void RemoveObject(UUID obj, UUID regionUUID)
  553. {
  554. // m_log.InfoFormat("[REGION DB]: Removing obj: {0} from region: {1}", obj.Guid, regionUUID);
  555. DataTable prims = ds.Tables["prims"];
  556. DataTable shapes = ds.Tables["primshapes"];
  557. string selectExp = "SceneGroupID = '" + obj + "' and RegionUUID = '" + regionUUID + "'";
  558. lock (ds)
  559. {
  560. DataRow[] primRows = prims.Select(selectExp);
  561. foreach (DataRow row in primRows)
  562. {
  563. // Remove shape rows
  564. UUID uuid = new UUID((string)row["UUID"]);
  565. DataRow shapeRow = shapes.Rows.Find(uuid.ToString());
  566. if (shapeRow != null)
  567. {
  568. shapeRow.Delete();
  569. }
  570. RemoveItems(uuid);
  571. // Remove prim row
  572. row.Delete();
  573. }
  574. }
  575. Commit();
  576. }
  577. /// <summary>
  578. /// Remove all persisted items of the given prim.
  579. /// The caller must acquire the necessrary synchronization locks and commit or rollback changes.
  580. /// </summary>
  581. /// <param name="uuid">The item UUID</param>
  582. private void RemoveItems(UUID uuid)
  583. {
  584. DataTable items = ds.Tables["primitems"];
  585. String sql = String.Format("primID = '{0}'", uuid);
  586. DataRow[] itemRows = items.Select(sql);
  587. foreach (DataRow itemRow in itemRows)
  588. {
  589. itemRow.Delete();
  590. }
  591. }
  592. /// <summary>
  593. /// Load persisted objects from region storage.
  594. /// </summary>
  595. /// <param name="regionUUID">The region UUID</param>
  596. /// <returns>List of loaded groups</returns>
  597. public List<SceneObjectGroup> LoadObjects(UUID regionUUID)
  598. {
  599. Dictionary<UUID, SceneObjectGroup> createdObjects = new Dictionary<UUID, SceneObjectGroup>();
  600. List<SceneObjectGroup> retvals = new List<SceneObjectGroup>();
  601. DataTable prims = ds.Tables["prims"];
  602. DataTable shapes = ds.Tables["primshapes"];
  603. string byRegion = "RegionUUID = '" + regionUUID + "'";
  604. lock (ds)
  605. {
  606. DataRow[] primsForRegion = prims.Select(byRegion);
  607. // m_log.Info("[SQLITE REGION DB]: Loaded " + primsForRegion.Length + " prims for region: " + regionUUID);
  608. // First, create all groups
  609. foreach (DataRow primRow in primsForRegion)
  610. {
  611. try
  612. {
  613. SceneObjectPart prim = null;
  614. string uuid = (string)primRow["UUID"];
  615. string objID = (string)primRow["SceneGroupID"];
  616. if (uuid == objID) //is new SceneObjectGroup ?
  617. {
  618. prim = buildPrim(primRow);
  619. DataRow shapeRow = shapes.Rows.Find(prim.UUID.ToString());
  620. if (shapeRow != null)
  621. {
  622. prim.Shape = buildShape(shapeRow);
  623. }
  624. else
  625. {
  626. m_log.Warn(
  627. "[SQLITE REGION DB]: No shape found for prim in storage, so setting default box shape");
  628. prim.Shape = PrimitiveBaseShape.Default;
  629. }
  630. SceneObjectGroup group = new SceneObjectGroup(prim);
  631. createdObjects.Add(group.UUID, group);
  632. retvals.Add(group);
  633. LoadItems(prim);
  634. }
  635. }
  636. catch (Exception e)
  637. {
  638. m_log.Error("[SQLITE REGION DB]: Failed create prim object in new group, exception and data follows");
  639. m_log.Error("[SQLITE REGION DB]: ", e);
  640. foreach (DataColumn col in prims.Columns)
  641. {
  642. m_log.Error("[SQLITE REGION DB]: Col: " + col.ColumnName + " => " + primRow[col]);
  643. }
  644. }
  645. }
  646. // Now fill the groups with part data
  647. foreach (DataRow primRow in primsForRegion)
  648. {
  649. try
  650. {
  651. SceneObjectPart prim = null;
  652. string uuid = (string)primRow["UUID"];
  653. string objID = (string)primRow["SceneGroupID"];
  654. if (uuid != objID) //is new SceneObjectGroup ?
  655. {
  656. prim = buildPrim(primRow);
  657. DataRow shapeRow = shapes.Rows.Find(prim.UUID.ToString());
  658. if (shapeRow != null)
  659. {
  660. prim.Shape = buildShape(shapeRow);
  661. }
  662. else
  663. {
  664. m_log.Warn(
  665. "[SQLITE REGION DB]: No shape found for prim in storage, so setting default box shape");
  666. prim.Shape = PrimitiveBaseShape.Default;
  667. }
  668. createdObjects[new UUID(objID)].AddPart(prim);
  669. LoadItems(prim);
  670. }
  671. }
  672. catch (Exception e)
  673. {
  674. m_log.Error("[SQLITE REGION DB]: Failed create prim object in group, exception and data follows");
  675. m_log.Error("[SQLITE REGION DB]: ", e);
  676. foreach (DataColumn col in prims.Columns)
  677. {
  678. m_log.Error("[SQLITE REGION DB]: Col: " + col.ColumnName + " => " + primRow[col]);
  679. }
  680. }
  681. }
  682. }
  683. return retvals;
  684. }
  685. /// <summary>
  686. /// Load in a prim's persisted inventory.
  687. /// </summary>
  688. /// <param name="prim">the prim</param>
  689. private void LoadItems(SceneObjectPart prim)
  690. {
  691. // m_log.DebugFormat("[SQLITE REGION DB]: Loading inventory for {0} {1}", prim.Name, prim.UUID);
  692. DataTable dbItems = ds.Tables["primitems"];
  693. String sql = String.Format("primID = '{0}'", prim.UUID.ToString());
  694. DataRow[] dbItemRows = dbItems.Select(sql);
  695. IList<TaskInventoryItem> inventory = new List<TaskInventoryItem>();
  696. // m_log.DebugFormat("[SQLITE REGION DB]: Found {0} items for {1} {2}", dbItemRows.Length, prim.Name, prim.UUID);
  697. foreach (DataRow row in dbItemRows)
  698. {
  699. TaskInventoryItem item = buildItem(row);
  700. inventory.Add(item);
  701. // m_log.DebugFormat("[SQLITE REGION DB]: Restored item {0} {1}", item.Name, item.ItemID);
  702. }
  703. prim.Inventory.RestoreInventoryItems(inventory);
  704. }
  705. // Legacy entry point for when terrain was always a 256x256 hieghtmap
  706. public void StoreTerrain(double[,] ter, UUID regionID)
  707. {
  708. StoreTerrain(new HeightmapTerrainData(ter), regionID);
  709. }
  710. /// <summary>
  711. /// Store a terrain revision in region storage
  712. /// </summary>
  713. /// <param name="ter">terrain heightfield</param>
  714. /// <param name="regionID">region UUID</param>
  715. public void StoreTerrain(TerrainData terrData, UUID regionID)
  716. {
  717. lock (ds)
  718. {
  719. using (
  720. SqliteCommand cmd = new SqliteCommand("delete from terrain where RegionUUID=:RegionUUID", m_conn))
  721. {
  722. cmd.Parameters.Add(new SqliteParameter(":RegionUUID", regionID.ToString()));
  723. cmd.ExecuteNonQuery();
  724. }
  725. // the following is an work around for .NET. The perf
  726. // issues associated with it aren't as bad as you think.
  727. String sql = "insert into terrain(RegionUUID, Revision, Heightfield)" +
  728. " values(:RegionUUID, :Revision, :Heightfield)";
  729. int terrainDBRevision;
  730. Array terrainDBblob;
  731. terrData.GetDatabaseBlob(out terrainDBRevision, out terrainDBblob);
  732. m_log.DebugFormat("{0} Storing terrain revision r {1}", LogHeader, terrainDBRevision);
  733. using (SqliteCommand cmd = new SqliteCommand(sql, m_conn))
  734. {
  735. cmd.Parameters.Add(new SqliteParameter(":RegionUUID", regionID.ToString()));
  736. cmd.Parameters.Add(new SqliteParameter(":Revision", terrainDBRevision));
  737. cmd.Parameters.Add(new SqliteParameter(":Heightfield", terrainDBblob));
  738. cmd.ExecuteNonQuery();
  739. }
  740. }
  741. }
  742. /// <summary>
  743. /// Load the latest terrain revision from region storage
  744. /// </summary>
  745. /// <param name="regionID">the region UUID</param>
  746. /// <returns>Heightfield data</returns>
  747. public double[,] LoadTerrain(UUID regionID)
  748. {
  749. TerrainData terrData = LoadTerrain(regionID, (int)Constants.RegionSize, (int)Constants.RegionSize, (int)Constants.RegionHeight);
  750. return terrData.GetDoubles();
  751. }
  752. public TerrainData LoadTerrain(UUID regionID, int pSizeX, int pSizeY, int pSizeZ)
  753. {
  754. TerrainData terrData = null;
  755. lock (ds)
  756. {
  757. String sql = "select RegionUUID, Revision, Heightfield from terrain" +
  758. " where RegionUUID=:RegionUUID order by Revision desc";
  759. using (SqliteCommand cmd = new SqliteCommand(sql, m_conn))
  760. {
  761. cmd.Parameters.Add(new SqliteParameter(":RegionUUID", regionID.ToString()));
  762. using (IDataReader row = cmd.ExecuteReader())
  763. {
  764. int rev = 0;
  765. if (row.Read())
  766. {
  767. rev = Convert.ToInt32(row["Revision"]);
  768. byte[] blob = (byte[])row["Heightfield"];
  769. terrData = TerrainData.CreateFromDatabaseBlobFactory(pSizeX, pSizeY, pSizeZ, rev, blob);
  770. }
  771. else
  772. {
  773. m_log.Warn("[SQLITE REGION DB]: No terrain found for region");
  774. return null;
  775. }
  776. m_log.Debug("[SQLITE REGION DB]: Loaded terrain revision r" + rev.ToString());
  777. }
  778. }
  779. }
  780. return terrData;
  781. }
  782. public void RemoveLandObject(UUID globalID)
  783. {
  784. lock (ds)
  785. {
  786. // Can't use blanket SQL statements when using SqlAdapters unless you re-read the data into the adapter
  787. // after you're done.
  788. // replaced below code with the SqliteAdapter version.
  789. //using (SqliteCommand cmd = new SqliteCommand("delete from land where UUID=:UUID", m_conn))
  790. //{
  791. // cmd.Parameters.Add(new SqliteParameter(":UUID", globalID.ToString()));
  792. // cmd.ExecuteNonQuery();
  793. //}
  794. //using (SqliteCommand cmd = new SqliteCommand("delete from landaccesslist where LandUUID=:UUID", m_conn))
  795. //{
  796. // cmd.Parameters.Add(new SqliteParameter(":UUID", globalID.ToString()));
  797. // cmd.ExecuteNonQuery();
  798. //}
  799. DataTable land = ds.Tables["land"];
  800. DataTable landaccesslist = ds.Tables["landaccesslist"];
  801. DataRow landRow = land.Rows.Find(globalID.ToString());
  802. if (landRow != null)
  803. {
  804. landRow.Delete();
  805. }
  806. List<DataRow> rowsToDelete = new List<DataRow>();
  807. foreach (DataRow rowToCheck in landaccesslist.Rows)
  808. {
  809. if (rowToCheck["LandUUID"].ToString() == globalID.ToString())
  810. rowsToDelete.Add(rowToCheck);
  811. }
  812. for (int iter = 0; iter < rowsToDelete.Count; iter++)
  813. {
  814. rowsToDelete[iter].Delete();
  815. }
  816. }
  817. Commit();
  818. }
  819. /// <summary>
  820. ///
  821. /// </summary>
  822. /// <param name="parcel"></param>
  823. public void StoreLandObject(ILandObject parcel)
  824. {
  825. lock (ds)
  826. {
  827. DataTable land = ds.Tables["land"];
  828. DataTable landaccesslist = ds.Tables["landaccesslist"];
  829. DataRow landRow = land.Rows.Find(parcel.LandData.GlobalID.ToString());
  830. if (landRow == null)
  831. {
  832. landRow = land.NewRow();
  833. fillLandRow(landRow, parcel.LandData, parcel.RegionUUID);
  834. land.Rows.Add(landRow);
  835. }
  836. else
  837. {
  838. fillLandRow(landRow, parcel.LandData, parcel.RegionUUID);
  839. }
  840. // I know this caused someone issues before, but OpenSim is unusable if we leave this stuff around
  841. //using (SqliteCommand cmd = new SqliteCommand("delete from landaccesslist where LandUUID=:LandUUID", m_conn))
  842. //{
  843. // cmd.Parameters.Add(new SqliteParameter(":LandUUID", parcel.LandData.GlobalID.ToString()));
  844. // cmd.ExecuteNonQuery();
  845. // }
  846. // This is the slower.. but more appropriate thing to do
  847. // We can't modify the table with direct queries before calling Commit() and re-filling them.
  848. List<DataRow> rowsToDelete = new List<DataRow>();
  849. foreach (DataRow rowToCheck in landaccesslist.Rows)
  850. {
  851. if (rowToCheck["LandUUID"].ToString() == parcel.LandData.GlobalID.ToString())
  852. rowsToDelete.Add(rowToCheck);
  853. }
  854. for (int iter = 0; iter < rowsToDelete.Count; iter++)
  855. {
  856. rowsToDelete[iter].Delete();
  857. landaccesslist.Rows.Remove(rowsToDelete[iter]);
  858. }
  859. rowsToDelete.Clear();
  860. foreach (LandAccessEntry entry in parcel.LandData.ParcelAccessList)
  861. {
  862. DataRow newAccessRow = landaccesslist.NewRow();
  863. fillLandAccessRow(newAccessRow, entry, parcel.LandData.GlobalID);
  864. landaccesslist.Rows.Add(newAccessRow);
  865. }
  866. }
  867. Commit();
  868. }
  869. /// <summary>
  870. ///
  871. /// </summary>
  872. /// <param name="regionUUID"></param>
  873. /// <returns></returns>
  874. public List<LandData> LoadLandObjects(UUID regionUUID)
  875. {
  876. List<LandData> landDataForRegion = new List<LandData>();
  877. lock (ds)
  878. {
  879. DataTable land = ds.Tables["land"];
  880. DataTable landaccesslist = ds.Tables["landaccesslist"];
  881. string searchExp = "RegionUUID = '" + regionUUID + "'";
  882. DataRow[] rawDataForRegion = land.Select(searchExp);
  883. foreach (DataRow rawDataLand in rawDataForRegion)
  884. {
  885. LandData newLand = buildLandData(rawDataLand);
  886. string accessListSearchExp = "LandUUID = '" + newLand.GlobalID + "'";
  887. DataRow[] rawDataForLandAccessList = landaccesslist.Select(accessListSearchExp);
  888. foreach (DataRow rawDataLandAccess in rawDataForLandAccessList)
  889. {
  890. newLand.ParcelAccessList.Add(buildLandAccessData(rawDataLandAccess));
  891. }
  892. landDataForRegion.Add(newLand);
  893. }
  894. }
  895. return landDataForRegion;
  896. }
  897. /// <summary>
  898. ///
  899. /// </summary>
  900. public void Commit()
  901. {
  902. // m_log.Debug("[SQLITE]: Starting commit");
  903. lock (ds)
  904. {
  905. primDa.Update(ds, "prims");
  906. shapeDa.Update(ds, "primshapes");
  907. itemsDa.Update(ds, "primitems");
  908. terrainDa.Update(ds, "terrain");
  909. landDa.Update(ds, "land");
  910. landAccessListDa.Update(ds, "landaccesslist");
  911. try
  912. {
  913. regionSettingsDa.Update(ds, "regionsettings");
  914. regionWindlightDa.Update(ds, "regionwindlight");
  915. }
  916. catch (SqliteException SqlEx)
  917. {
  918. throw new Exception(
  919. "There was a SQL error or connection string configuration error when saving the region settings. This could be a bug, it could also happen if ConnectionString is defined in the [DatabaseService] section of StandaloneCommon.ini in the config_include folder. This could also happen if the config_include folder doesn't exist or if the OpenSim.ini [Architecture] section isn't set. If this is your first time running OpenSimulator, please restart the simulator and bug a developer to fix this!",
  920. SqlEx);
  921. }
  922. ds.AcceptChanges();
  923. }
  924. }
  925. /// <summary>
  926. /// See <see cref="Commit"/>
  927. /// </summary>
  928. public void Shutdown()
  929. {
  930. Commit();
  931. }
  932. /***********************************************************************
  933. *
  934. * Database Definition Functions
  935. *
  936. * This should be db agnostic as we define them in ADO.NET terms
  937. *
  938. **********************************************************************/
  939. protected void CreateDataSetMapping(IDataAdapter da, string tableName)
  940. {
  941. ITableMapping dbMapping = da.TableMappings.Add(tableName, tableName);
  942. foreach (DataColumn col in ds.Tables[tableName].Columns)
  943. {
  944. dbMapping.ColumnMappings.Add(col.ColumnName, col.ColumnName);
  945. }
  946. }
  947. /// <summary>
  948. ///
  949. /// </summary>
  950. /// <param name="dt"></param>
  951. /// <param name="name"></param>
  952. /// <param name="type"></param>
  953. private static void createCol(DataTable dt, string name, Type type)
  954. {
  955. DataColumn col = new DataColumn(name, type);
  956. dt.Columns.Add(col);
  957. }
  958. /// <summary>
  959. /// Creates the "terrain" table
  960. /// </summary>
  961. /// <returns>terrain table DataTable</returns>
  962. private static DataTable createTerrainTable()
  963. {
  964. DataTable terrain = new DataTable("terrain");
  965. createCol(terrain, "RegionUUID", typeof(String));
  966. createCol(terrain, "Revision", typeof(Int32));
  967. createCol(terrain, "Heightfield", typeof(Byte[]));
  968. return terrain;
  969. }
  970. /// <summary>
  971. /// Creates the "prims" table
  972. /// </summary>
  973. /// <returns>prim table DataTable</returns>
  974. private static DataTable createPrimTable()
  975. {
  976. DataTable prims = new DataTable("prims");
  977. createCol(prims, "UUID", typeof(String));
  978. createCol(prims, "RegionUUID", typeof(String));
  979. createCol(prims, "CreationDate", typeof(Int32));
  980. createCol(prims, "Name", typeof(String));
  981. createCol(prims, "SceneGroupID", typeof(String));
  982. // various text fields
  983. createCol(prims, "Text", typeof(String));
  984. createCol(prims, "ColorR", typeof(Int32));
  985. createCol(prims, "ColorG", typeof(Int32));
  986. createCol(prims, "ColorB", typeof(Int32));
  987. createCol(prims, "ColorA", typeof(Int32));
  988. createCol(prims, "Description", typeof(String));
  989. createCol(prims, "SitName", typeof(String));
  990. createCol(prims, "TouchName", typeof(String));
  991. // permissions
  992. createCol(prims, "ObjectFlags", typeof(Int32));
  993. createCol(prims, "CreatorID", typeof(String));
  994. createCol(prims, "OwnerID", typeof(String));
  995. createCol(prims, "GroupID", typeof(String));
  996. createCol(prims, "LastOwnerID", typeof(String));
  997. createCol(prims, "OwnerMask", typeof(Int32));
  998. createCol(prims, "NextOwnerMask", typeof(Int32));
  999. createCol(prims, "GroupMask", typeof(Int32));
  1000. createCol(prims, "EveryoneMask", typeof(Int32));
  1001. createCol(prims, "BaseMask", typeof(Int32));
  1002. // vectors
  1003. createCol(prims, "PositionX", typeof(Double));
  1004. createCol(prims, "PositionY", typeof(Double));
  1005. createCol(prims, "PositionZ", typeof(Double));
  1006. createCol(prims, "GroupPositionX", typeof(Double));
  1007. createCol(prims, "GroupPositionY", typeof(Double));
  1008. createCol(prims, "GroupPositionZ", typeof(Double));
  1009. createCol(prims, "VelocityX", typeof(Double));
  1010. createCol(prims, "VelocityY", typeof(Double));
  1011. createCol(prims, "VelocityZ", typeof(Double));
  1012. createCol(prims, "AngularVelocityX", typeof(Double));
  1013. createCol(prims, "AngularVelocityY", typeof(Double));
  1014. createCol(prims, "AngularVelocityZ", typeof(Double));
  1015. createCol(prims, "AccelerationX", typeof(Double));
  1016. createCol(prims, "AccelerationY", typeof(Double));
  1017. createCol(prims, "AccelerationZ", typeof(Double));
  1018. // quaternions
  1019. createCol(prims, "RotationX", typeof(Double));
  1020. createCol(prims, "RotationY", typeof(Double));
  1021. createCol(prims, "RotationZ", typeof(Double));
  1022. createCol(prims, "RotationW", typeof(Double));
  1023. // sit target
  1024. createCol(prims, "SitTargetOffsetX", typeof(Double));
  1025. createCol(prims, "SitTargetOffsetY", typeof(Double));
  1026. createCol(prims, "SitTargetOffsetZ", typeof(Double));
  1027. createCol(prims, "SitTargetOrientW", typeof(Double));
  1028. createCol(prims, "SitTargetOrientX", typeof(Double));
  1029. createCol(prims, "SitTargetOrientY", typeof(Double));
  1030. createCol(prims, "SitTargetOrientZ", typeof(Double));
  1031. createCol(prims, "PayPrice", typeof(Int32));
  1032. createCol(prims, "PayButton1", typeof(Int32));
  1033. createCol(prims, "PayButton2", typeof(Int32));
  1034. createCol(prims, "PayButton3", typeof(Int32));
  1035. createCol(prims, "PayButton4", typeof(Int32));
  1036. createCol(prims, "LoopedSound", typeof(String));
  1037. createCol(prims, "LoopedSoundGain", typeof(Double));
  1038. createCol(prims, "TextureAnimation", typeof(String));
  1039. createCol(prims, "ParticleSystem", typeof(String));
  1040. createCol(prims, "OmegaX", typeof(Double));
  1041. createCol(prims, "OmegaY", typeof(Double));
  1042. createCol(prims, "OmegaZ", typeof(Double));
  1043. createCol(prims, "CameraEyeOffsetX", typeof(Double));
  1044. createCol(prims, "CameraEyeOffsetY", typeof(Double));
  1045. createCol(prims, "CameraEyeOffsetZ", typeof(Double));
  1046. createCol(prims, "CameraAtOffsetX", typeof(Double));
  1047. createCol(prims, "CameraAtOffsetY", typeof(Double));
  1048. createCol(prims, "CameraAtOffsetZ", typeof(Double));
  1049. createCol(prims, "ForceMouselook", typeof(Int16));
  1050. createCol(prims, "ScriptAccessPin", typeof(Int32));
  1051. createCol(prims, "AllowedDrop", typeof(Int16));
  1052. createCol(prims, "DieAtEdge", typeof(Int16));
  1053. createCol(prims, "SalePrice", typeof(Int32));
  1054. createCol(prims, "SaleType", typeof(Int16));
  1055. // click action
  1056. createCol(prims, "ClickAction", typeof(Byte));
  1057. createCol(prims, "Material", typeof(Byte));
  1058. createCol(prims, "CollisionSound", typeof(String));
  1059. createCol(prims, "CollisionSoundVolume", typeof(Double));
  1060. createCol(prims, "VolumeDetect", typeof(Int16));
  1061. createCol(prims, "MediaURL", typeof(String));
  1062. createCol(prims, "AttachedPosX", typeof(Double));
  1063. createCol(prims, "AttachedPosY", typeof(Double));
  1064. createCol(prims, "AttachedPosZ", typeof(Double));
  1065. createCol(prims, "DynAttrs", typeof(String));
  1066. createCol(prims, "PhysicsShapeType", typeof(Byte));
  1067. createCol(prims, "Density", typeof(Double));
  1068. createCol(prims, "GravityModifier", typeof(Double));
  1069. createCol(prims, "Friction", typeof(Double));
  1070. createCol(prims, "Restitution", typeof(Double));
  1071. createCol(prims, "KeyframeMotion", typeof(Byte[]));
  1072. // Add in contraints
  1073. prims.PrimaryKey = new DataColumn[] { prims.Columns["UUID"] };
  1074. return prims;
  1075. }
  1076. /// <summary>
  1077. /// Creates "primshapes" table
  1078. /// </summary>
  1079. /// <returns>shape table DataTable</returns>
  1080. private static DataTable createShapeTable()
  1081. {
  1082. DataTable shapes = new DataTable("primshapes");
  1083. createCol(shapes, "UUID", typeof(String));
  1084. // shape is an enum
  1085. createCol(shapes, "Shape", typeof(Int32));
  1086. // vectors
  1087. createCol(shapes, "ScaleX", typeof(Double));
  1088. createCol(shapes, "ScaleY", typeof(Double));
  1089. createCol(shapes, "ScaleZ", typeof(Double));
  1090. // paths
  1091. createCol(shapes, "PCode", typeof(Int32));
  1092. createCol(shapes, "PathBegin", typeof(Int32));
  1093. createCol(shapes, "PathEnd", typeof(Int32));
  1094. createCol(shapes, "PathScaleX", typeof(Int32));
  1095. createCol(shapes, "PathScaleY", typeof(Int32));
  1096. createCol(shapes, "PathShearX", typeof(Int32));
  1097. createCol(shapes, "PathShearY", typeof(Int32));
  1098. createCol(shapes, "PathSkew", typeof(Int32));
  1099. createCol(shapes, "PathCurve", typeof(Int32));
  1100. createCol(shapes, "PathRadiusOffset", typeof(Int32));
  1101. createCol(shapes, "PathRevolutions", typeof(Int32));
  1102. createCol(shapes, "PathTaperX", typeof(Int32));
  1103. createCol(shapes, "PathTaperY", typeof(Int32));
  1104. createCol(shapes, "PathTwist", typeof(Int32));
  1105. createCol(shapes, "PathTwistBegin", typeof(Int32));
  1106. // profile
  1107. createCol(shapes, "ProfileBegin", typeof(Int32));
  1108. createCol(shapes, "ProfileEnd", typeof(Int32));
  1109. createCol(shapes, "ProfileCurve", typeof(Int32));
  1110. createCol(shapes, "ProfileHollow", typeof(Int32));
  1111. createCol(shapes, "State", typeof(Int32));
  1112. // text TODO: this isn't right, but I'm not sure the right
  1113. // way to specify this as a blob atm
  1114. createCol(shapes, "Texture", typeof(Byte[]));
  1115. createCol(shapes, "ExtraParams", typeof(Byte[]));
  1116. createCol(shapes, "Media", typeof(String));
  1117. shapes.PrimaryKey = new DataColumn[] { shapes.Columns["UUID"] };
  1118. return shapes;
  1119. }
  1120. /// <summary>
  1121. /// creates "primitems" table
  1122. /// </summary>
  1123. /// <returns>item table DataTable</returns>
  1124. private static DataTable createItemsTable()
  1125. {
  1126. DataTable items = new DataTable("primitems");
  1127. createCol(items, "itemID", typeof(String));
  1128. createCol(items, "primID", typeof(String));
  1129. createCol(items, "assetID", typeof(String));
  1130. createCol(items, "parentFolderID", typeof(String));
  1131. createCol(items, "invType", typeof(Int32));
  1132. createCol(items, "assetType", typeof(Int32));
  1133. createCol(items, "name", typeof(String));
  1134. createCol(items, "description", typeof(String));
  1135. createCol(items, "creationDate", typeof(Int64));
  1136. createCol(items, "creatorID", typeof(String));
  1137. createCol(items, "ownerID", typeof(String));
  1138. createCol(items, "lastOwnerID", typeof(String));
  1139. createCol(items, "groupID", typeof(String));
  1140. createCol(items, "nextPermissions", typeof(UInt32));
  1141. createCol(items, "currentPermissions", typeof(UInt32));
  1142. createCol(items, "basePermissions", typeof(UInt32));
  1143. createCol(items, "everyonePermissions", typeof(UInt32));
  1144. createCol(items, "groupPermissions", typeof(UInt32));
  1145. createCol(items, "flags", typeof(UInt32));
  1146. items.PrimaryKey = new DataColumn[] { items.Columns["itemID"] };
  1147. return items;
  1148. }
  1149. /// <summary>
  1150. /// Creates "land" table
  1151. /// </summary>
  1152. /// <returns>land table DataTable</returns>
  1153. private static DataTable createLandTable()
  1154. {
  1155. DataTable land = new DataTable("land");
  1156. createCol(land, "UUID", typeof(String));
  1157. createCol(land, "RegionUUID", typeof(String));
  1158. createCol(land, "LocalLandID", typeof(UInt32));
  1159. // Bitmap is a byte[512]
  1160. createCol(land, "Bitmap", typeof(Byte[]));
  1161. createCol(land, "Name", typeof(String));
  1162. createCol(land, "Desc", typeof(String));
  1163. createCol(land, "OwnerUUID", typeof(String));
  1164. createCol(land, "IsGroupOwned", typeof(Boolean));
  1165. createCol(land, "Area", typeof(Int32));
  1166. createCol(land, "AuctionID", typeof(Int32)); //Unemplemented
  1167. createCol(land, "Category", typeof(Int32)); //Enum OpenMetaverse.Parcel.ParcelCategory
  1168. createCol(land, "ClaimDate", typeof(Int32));
  1169. createCol(land, "ClaimPrice", typeof(Int32));
  1170. createCol(land, "GroupUUID", typeof(string));
  1171. createCol(land, "SalePrice", typeof(Int32));
  1172. createCol(land, "LandStatus", typeof(Int32)); //Enum. OpenMetaverse.Parcel.ParcelStatus
  1173. createCol(land, "LandFlags", typeof(UInt32));
  1174. createCol(land, "LandingType", typeof(Byte));
  1175. createCol(land, "MediaAutoScale", typeof(Byte));
  1176. createCol(land, "MediaTextureUUID", typeof(String));
  1177. createCol(land, "MediaURL", typeof(String));
  1178. createCol(land, "MusicURL", typeof(String));
  1179. createCol(land, "PassHours", typeof(Double));
  1180. createCol(land, "PassPrice", typeof(UInt32));
  1181. createCol(land, "SnapshotUUID", typeof(String));
  1182. createCol(land, "UserLocationX", typeof(Double));
  1183. createCol(land, "UserLocationY", typeof(Double));
  1184. createCol(land, "UserLocationZ", typeof(Double));
  1185. createCol(land, "UserLookAtX", typeof(Double));
  1186. createCol(land, "UserLookAtY", typeof(Double));
  1187. createCol(land, "UserLookAtZ", typeof(Double));
  1188. createCol(land, "AuthbuyerID", typeof(String));
  1189. createCol(land, "OtherCleanTime", typeof(Int32));
  1190. createCol(land, "Dwell", typeof(Int32));
  1191. createCol(land, "MediaType", typeof(String));
  1192. createCol(land, "MediaDescription", typeof(String));
  1193. createCol(land, "MediaSize", typeof(String));
  1194. createCol(land, "MediaLoop", typeof(Boolean));
  1195. createCol(land, "ObscureMedia", typeof(Boolean));
  1196. createCol(land, "ObscureMusic", typeof(Boolean));
  1197. land.PrimaryKey = new DataColumn[] { land.Columns["UUID"] };
  1198. return land;
  1199. }
  1200. /// <summary>
  1201. /// create "landaccesslist" table
  1202. /// </summary>
  1203. /// <returns>Landacceslist DataTable</returns>
  1204. private static DataTable createLandAccessListTable()
  1205. {
  1206. DataTable landaccess = new DataTable("landaccesslist");
  1207. createCol(landaccess, "LandUUID", typeof(String));
  1208. createCol(landaccess, "AccessUUID", typeof(String));
  1209. createCol(landaccess, "Flags", typeof(UInt32));
  1210. return landaccess;
  1211. }
  1212. private static DataTable createRegionSettingsTable()
  1213. {
  1214. DataTable regionsettings = new DataTable("regionsettings");
  1215. createCol(regionsettings, "regionUUID", typeof(String));
  1216. createCol(regionsettings, "block_terraform", typeof(Int32));
  1217. createCol(regionsettings, "block_fly", typeof(Int32));
  1218. createCol(regionsettings, "allow_damage", typeof(Int32));
  1219. createCol(regionsettings, "restrict_pushing", typeof(Int32));
  1220. createCol(regionsettings, "allow_land_resell", typeof(Int32));
  1221. createCol(regionsettings, "allow_land_join_divide", typeof(Int32));
  1222. createCol(regionsettings, "block_show_in_search", typeof(Int32));
  1223. createCol(regionsettings, "agent_limit", typeof(Int32));
  1224. createCol(regionsettings, "object_bonus", typeof(Double));
  1225. createCol(regionsettings, "maturity", typeof(Int32));
  1226. createCol(regionsettings, "disable_scripts", typeof(Int32));
  1227. createCol(regionsettings, "disable_collisions", typeof(Int32));
  1228. createCol(regionsettings, "disable_physics", typeof(Int32));
  1229. createCol(regionsettings, "terrain_texture_1", typeof(String));
  1230. createCol(regionsettings, "terrain_texture_2", typeof(String));
  1231. createCol(regionsettings, "terrain_texture_3", typeof(String));
  1232. createCol(regionsettings, "terrain_texture_4", typeof(String));
  1233. createCol(regionsettings, "elevation_1_nw", typeof(Double));
  1234. createCol(regionsettings, "elevation_2_nw", typeof(Double));
  1235. createCol(regionsettings, "elevation_1_ne", typeof(Double));
  1236. createCol(regionsettings, "elevation_2_ne", typeof(Double));
  1237. createCol(regionsettings, "elevation_1_se", typeof(Double));
  1238. createCol(regionsettings, "elevation_2_se", typeof(Double));
  1239. createCol(regionsettings, "elevation_1_sw", typeof(Double));
  1240. createCol(regionsettings, "elevation_2_sw", typeof(Double));
  1241. createCol(regionsettings, "water_height", typeof(Double));
  1242. createCol(regionsettings, "terrain_raise_limit", typeof(Double));
  1243. createCol(regionsettings, "terrain_lower_limit", typeof(Double));
  1244. createCol(regionsettings, "use_estate_sun", typeof(Int32));
  1245. createCol(regionsettings, "sandbox", typeof(Int32));
  1246. createCol(regionsettings, "sunvectorx", typeof(Double));
  1247. createCol(regionsettings, "sunvectory", typeof(Double));
  1248. createCol(regionsettings, "sunvectorz", typeof(Double));
  1249. createCol(regionsettings, "fixed_sun", typeof(Int32));
  1250. createCol(regionsettings, "sun_position", typeof(Double));
  1251. createCol(regionsettings, "covenant", typeof(String));
  1252. createCol(regionsettings, "covenant_datetime", typeof(Int32));
  1253. createCol(regionsettings, "map_tile_ID", typeof(String));
  1254. createCol(regionsettings, "TelehubObject", typeof(String));
  1255. createCol(regionsettings, "parcel_tile_ID", typeof(String));
  1256. regionsettings.PrimaryKey = new DataColumn[] { regionsettings.Columns["regionUUID"] };
  1257. return regionsettings;
  1258. }
  1259. /// <summary>
  1260. /// create "regionwindlight" table
  1261. /// </summary>
  1262. /// <returns>RegionWindlight DataTable</returns>
  1263. private static DataTable createRegionWindlightTable()
  1264. {
  1265. DataTable regionwindlight = new DataTable("regionwindlight");
  1266. createCol(regionwindlight, "region_id", typeof(String));
  1267. createCol(regionwindlight, "water_color_r", typeof(Double));
  1268. createCol(regionwindlight, "water_color_g", typeof(Double));
  1269. createCol(regionwindlight, "water_color_b", typeof(Double));
  1270. createCol(regionwindlight, "water_color_i", typeof(Double));
  1271. createCol(regionwindlight, "water_fog_density_exponent", typeof(Double));
  1272. createCol(regionwindlight, "underwater_fog_modifier", typeof(Double));
  1273. createCol(regionwindlight, "reflection_wavelet_scale_1", typeof(Double));
  1274. createCol(regionwindlight, "reflection_wavelet_scale_2", typeof(Double));
  1275. createCol(regionwindlight, "reflection_wavelet_scale_3", typeof(Double));
  1276. createCol(regionwindlight, "fresnel_scale", typeof(Double));
  1277. createCol(regionwindlight, "fresnel_offset", typeof(Double));
  1278. createCol(regionwindlight, "refract_scale_above", typeof(Double));
  1279. createCol(regionwindlight, "refract_scale_below", typeof(Double));
  1280. createCol(regionwindlight, "blur_multiplier", typeof(Double));
  1281. createCol(regionwindlight, "big_wave_direction_x", typeof(Double));
  1282. createCol(regionwindlight, "big_wave_direction_y", typeof(Double));
  1283. createCol(regionwindlight, "little_wave_direction_x", typeof(Double));
  1284. createCol(regionwindlight, "little_wave_direction_y", typeof(Double));
  1285. createCol(regionwindlight, "normal_map_texture", typeof(String));
  1286. createCol(regionwindlight, "horizon_r", typeof(Double));
  1287. createCol(regionwindlight, "horizon_g", typeof(Double));
  1288. createCol(regionwindlight, "horizon_b", typeof(Double));
  1289. createCol(regionwindlight, "horizon_i", typeof(Double));
  1290. createCol(regionwindlight, "haze_horizon", typeof(Double));
  1291. createCol(regionwindlight, "blue_density_r", typeof(Double));
  1292. createCol(regionwindlight, "blue_density_g", typeof(Double));
  1293. createCol(regionwindlight, "blue_density_b", typeof(Double));
  1294. createCol(regionwindlight, "blue_density_i", typeof(Double));
  1295. createCol(regionwindlight, "haze_density", typeof(Double));
  1296. createCol(regionwindlight, "density_multiplier", typeof(Double));
  1297. createCol(regionwindlight, "distance_multiplier", typeof(Double));
  1298. createCol(regionwindlight, "max_altitude", typeof(Int32));
  1299. createCol(regionwindlight, "sun_moon_color_r", typeof(Double));
  1300. createCol(regionwindlight, "sun_moon_color_g", typeof(Double));
  1301. createCol(regionwindlight, "sun_moon_color_b", typeof(Double));
  1302. createCol(regionwindlight, "sun_moon_color_i", typeof(Double));
  1303. createCol(regionwindlight, "sun_moon_position", typeof(Double));
  1304. createCol(regionwindlight, "ambient_r", typeof(Double));
  1305. createCol(regionwindlight, "ambient_g", typeof(Double));
  1306. createCol(regionwindlight, "ambient_b", typeof(Double));
  1307. createCol(regionwindlight, "ambient_i", typeof(Double));
  1308. createCol(regionwindlight, "east_angle", typeof(Double));
  1309. createCol(regionwindlight, "sun_glow_focus", typeof(Double));
  1310. createCol(regionwindlight, "sun_glow_size", typeof(Double));
  1311. createCol(regionwindlight, "scene_gamma", typeof(Double));
  1312. createCol(regionwindlight, "star_brightness", typeof(Double));
  1313. createCol(regionwindlight, "cloud_color_r", typeof(Double));
  1314. createCol(regionwindlight, "cloud_color_g", typeof(Double));
  1315. createCol(regionwindlight, "cloud_color_b", typeof(Double));
  1316. createCol(regionwindlight, "cloud_color_i", typeof(Double));
  1317. createCol(regionwindlight, "cloud_x", typeof(Double));
  1318. createCol(regionwindlight, "cloud_y", typeof(Double));
  1319. createCol(regionwindlight, "cloud_density", typeof(Double));
  1320. createCol(regionwindlight, "cloud_coverage", typeof(Double));
  1321. createCol(regionwindlight, "cloud_scale", typeof(Double));
  1322. createCol(regionwindlight, "cloud_detail_x", typeof(Double));
  1323. createCol(regionwindlight, "cloud_detail_y", typeof(Double));
  1324. createCol(regionwindlight, "cloud_detail_density", typeof(Double));
  1325. createCol(regionwindlight, "cloud_scroll_x", typeof(Double));
  1326. createCol(regionwindlight, "cloud_scroll_x_lock", typeof(Int32));
  1327. createCol(regionwindlight, "cloud_scroll_y", typeof(Double));
  1328. createCol(regionwindlight, "cloud_scroll_y_lock", typeof(Int32));
  1329. createCol(regionwindlight, "draw_classic_clouds", typeof(Int32));
  1330. regionwindlight.PrimaryKey = new DataColumn[] { regionwindlight.Columns["region_id"] };
  1331. return regionwindlight;
  1332. }
  1333. private static DataTable createRegionEnvironmentTable()
  1334. {
  1335. DataTable regionEnvironment = new DataTable("regionenvironment");
  1336. createCol(regionEnvironment, "region_id", typeof(String));
  1337. createCol(regionEnvironment, "llsd_settings", typeof(String));
  1338. regionEnvironment.PrimaryKey = new DataColumn[] { regionEnvironment.Columns["region_id"] };
  1339. return regionEnvironment;
  1340. }
  1341. private static DataTable createRegionSpawnPointsTable()
  1342. {
  1343. DataTable spawn_points = new DataTable("spawn_points");
  1344. createCol(spawn_points, "regionID", typeof(String));
  1345. createCol(spawn_points, "Yaw", typeof(float));
  1346. createCol(spawn_points, "Pitch", typeof(float));
  1347. createCol(spawn_points, "Distance", typeof(float));
  1348. return spawn_points;
  1349. }
  1350. /***********************************************************************
  1351. *
  1352. * Convert between ADO.NET <=> OpenSim Objects
  1353. *
  1354. * These should be database independant
  1355. *
  1356. **********************************************************************/
  1357. /// <summary>
  1358. ///
  1359. /// </summary>
  1360. /// <param name="row"></param>
  1361. /// <returns></returns>
  1362. private SceneObjectPart buildPrim(DataRow row)
  1363. {
  1364. // Code commented. Uncomment to test the unit test inline.
  1365. // The unit test mentions this commented code for the purposes
  1366. // of debugging a unit test failure
  1367. // SceneObjectGroup sog = new SceneObjectGroup();
  1368. // SceneObjectPart sop = new SceneObjectPart();
  1369. // sop.LocalId = 1;
  1370. // sop.Name = "object1";
  1371. // sop.Description = "object1";
  1372. // sop.Text = "";
  1373. // sop.SitName = "";
  1374. // sop.TouchName = "";
  1375. // sop.UUID = UUID.Random();
  1376. // sop.Shape = PrimitiveBaseShape.Default;
  1377. // sog.SetRootPart(sop);
  1378. // Add breakpoint in above line. Check sop fields.
  1379. // TODO: this doesn't work yet because something more
  1380. // interesting has to be done to actually get these values
  1381. // back out. Not enough time to figure it out yet.
  1382. SceneObjectPart prim = new SceneObjectPart();
  1383. prim.UUID = new UUID((String)row["UUID"]);
  1384. // explicit conversion of integers is required, which sort
  1385. // of sucks. No idea if there is a shortcut here or not.
  1386. prim.CreationDate = Convert.ToInt32(row["CreationDate"]);
  1387. prim.Name = row["Name"] == DBNull.Value ? string.Empty : (string)row["Name"];
  1388. // various text fields
  1389. prim.Text = (String)row["Text"];
  1390. prim.Color = Color.FromArgb(Convert.ToInt32(row["ColorA"]),
  1391. Convert.ToInt32(row["ColorR"]),
  1392. Convert.ToInt32(row["ColorG"]),
  1393. Convert.ToInt32(row["ColorB"]));
  1394. prim.Description = (String)row["Description"];
  1395. prim.SitName = (String)row["SitName"];
  1396. prim.TouchName = (String)row["TouchName"];
  1397. // permissions
  1398. prim.ObjectFlags = Convert.ToUInt32(row["ObjectFlags"]);
  1399. prim.CreatorIdentification = (String)row["CreatorID"];
  1400. prim.OwnerID = new UUID((String)row["OwnerID"]);
  1401. prim.GroupID = new UUID((String)row["GroupID"]);
  1402. prim.LastOwnerID = new UUID((String)row["LastOwnerID"]);
  1403. prim.OwnerMask = Convert.ToUInt32(row["OwnerMask"]);
  1404. prim.NextOwnerMask = Convert.ToUInt32(row["NextOwnerMask"]);
  1405. prim.GroupMask = Convert.ToUInt32(row["GroupMask"]);
  1406. prim.EveryoneMask = Convert.ToUInt32(row["EveryoneMask"]);
  1407. prim.BaseMask = Convert.ToUInt32(row["BaseMask"]);
  1408. // vectors
  1409. prim.OffsetPosition = new Vector3(
  1410. Convert.ToSingle(row["PositionX"]),
  1411. Convert.ToSingle(row["PositionY"]),
  1412. Convert.ToSingle(row["PositionZ"])
  1413. );
  1414. prim.GroupPosition = new Vector3(
  1415. Convert.ToSingle(row["GroupPositionX"]),
  1416. Convert.ToSingle(row["GroupPositionY"]),
  1417. Convert.ToSingle(row["GroupPositionZ"])
  1418. );
  1419. prim.Velocity = new Vector3(
  1420. Convert.ToSingle(row["VelocityX"]),
  1421. Convert.ToSingle(row["VelocityY"]),
  1422. Convert.ToSingle(row["VelocityZ"])
  1423. );
  1424. prim.AngularVelocity = new Vector3(
  1425. Convert.ToSingle(row["AngularVelocityX"]),
  1426. Convert.ToSingle(row["AngularVelocityY"]),
  1427. Convert.ToSingle(row["AngularVelocityZ"])
  1428. );
  1429. prim.Acceleration = new Vector3(
  1430. Convert.ToSingle(row["AccelerationX"]),
  1431. Convert.ToSingle(row["AccelerationY"]),
  1432. Convert.ToSingle(row["AccelerationZ"])
  1433. );
  1434. // quaternions
  1435. prim.RotationOffset = new Quaternion(
  1436. Convert.ToSingle(row["RotationX"]),
  1437. Convert.ToSingle(row["RotationY"]),
  1438. Convert.ToSingle(row["RotationZ"]),
  1439. Convert.ToSingle(row["RotationW"])
  1440. );
  1441. prim.SitTargetPositionLL = new Vector3(
  1442. Convert.ToSingle(row["SitTargetOffsetX"]),
  1443. Convert.ToSingle(row["SitTargetOffsetY"]),
  1444. Convert.ToSingle(row["SitTargetOffsetZ"]));
  1445. prim.SitTargetOrientationLL = new Quaternion(
  1446. Convert.ToSingle(
  1447. row["SitTargetOrientX"]),
  1448. Convert.ToSingle(
  1449. row["SitTargetOrientY"]),
  1450. Convert.ToSingle(
  1451. row["SitTargetOrientZ"]),
  1452. Convert.ToSingle(
  1453. row["SitTargetOrientW"]));
  1454. prim.ClickAction = Convert.ToByte(row["ClickAction"]);
  1455. prim.PayPrice[0] = Convert.ToInt32(row["PayPrice"]);
  1456. prim.PayPrice[1] = Convert.ToInt32(row["PayButton1"]);
  1457. prim.PayPrice[2] = Convert.ToInt32(row["PayButton2"]);
  1458. prim.PayPrice[3] = Convert.ToInt32(row["PayButton3"]);
  1459. prim.PayPrice[4] = Convert.ToInt32(row["PayButton4"]);
  1460. prim.Sound = new UUID(row["LoopedSound"].ToString());
  1461. prim.SoundGain = Convert.ToSingle(row["LoopedSoundGain"]);
  1462. prim.SoundFlags = 1; // If it's persisted at all, it's looped
  1463. if (!row.IsNull("TextureAnimation"))
  1464. prim.TextureAnimation = Convert.FromBase64String(row["TextureAnimation"].ToString());
  1465. if (!row.IsNull("ParticleSystem"))
  1466. prim.ParticleSystem = Convert.FromBase64String(row["ParticleSystem"].ToString());
  1467. prim.AngularVelocity = new Vector3(
  1468. Convert.ToSingle(row["OmegaX"]),
  1469. Convert.ToSingle(row["OmegaY"]),
  1470. Convert.ToSingle(row["OmegaZ"])
  1471. );
  1472. prim.SetCameraEyeOffset(new Vector3(
  1473. Convert.ToSingle(row["CameraEyeOffsetX"]),
  1474. Convert.ToSingle(row["CameraEyeOffsetY"]),
  1475. Convert.ToSingle(row["CameraEyeOffsetZ"])
  1476. ));
  1477. prim.SetCameraAtOffset(new Vector3(
  1478. Convert.ToSingle(row["CameraAtOffsetX"]),
  1479. Convert.ToSingle(row["CameraAtOffsetY"]),
  1480. Convert.ToSingle(row["CameraAtOffsetZ"])
  1481. ));
  1482. if (Convert.ToInt16(row["ForceMouselook"]) != 0)
  1483. prim.SetForceMouselook(true);
  1484. prim.ScriptAccessPin = Convert.ToInt32(row["ScriptAccessPin"]);
  1485. if (Convert.ToInt16(row["AllowedDrop"]) != 0)
  1486. prim.AllowedDrop = true;
  1487. if (Convert.ToInt16(row["DieAtEdge"]) != 0)
  1488. prim.DIE_AT_EDGE = true;
  1489. prim.SalePrice = Convert.ToInt32(row["SalePrice"]);
  1490. prim.ObjectSaleType = Convert.ToByte(row["SaleType"]);
  1491. prim.Material = Convert.ToByte(row["Material"]);
  1492. prim.CollisionSound = new UUID(row["CollisionSound"].ToString());
  1493. prim.CollisionSoundVolume = Convert.ToSingle(row["CollisionSoundVolume"]);
  1494. if (Convert.ToInt16(row["VolumeDetect"]) != 0)
  1495. prim.VolumeDetectActive = true;
  1496. if (!(row["MediaURL"] is System.DBNull))
  1497. {
  1498. // m_log.DebugFormat("[SQLITE]: MediaUrl type [{0}]", row["MediaURL"].GetType());
  1499. prim.MediaUrl = (string)row["MediaURL"];
  1500. }
  1501. prim.AttachedPos = new Vector3(
  1502. Convert.ToSingle(row["AttachedPosX"]),
  1503. Convert.ToSingle(row["AttachedPosY"]),
  1504. Convert.ToSingle(row["AttachedPosZ"])
  1505. );
  1506. if (!(row["DynAttrs"] is System.DBNull))
  1507. {
  1508. //m_log.DebugFormat("[SQLITE]: DynAttrs type [{0}]", row["DynAttrs"].GetType());
  1509. prim.DynAttrs = DAMap.FromXml((string)row["DynAttrs"]);
  1510. }
  1511. else
  1512. {
  1513. prim.DynAttrs = new DAMap();
  1514. }
  1515. prim.PhysicsShapeType = Convert.ToByte(row["PhysicsShapeType"]);
  1516. prim.Density = Convert.ToSingle(row["Density"]);
  1517. prim.GravityModifier = Convert.ToSingle(row["GravityModifier"]);
  1518. prim.Friction = Convert.ToSingle(row["Friction"]);
  1519. prim.Restitution = Convert.ToSingle(row["Restitution"]);
  1520. if (!(row["KeyframeMotion"] is DBNull))
  1521. {
  1522. Byte[] data = (byte[])row["KeyframeMotion"];
  1523. if (data.Length > 0)
  1524. prim.KeyframeMotion = KeyframeMotion.FromData(null, data);
  1525. else
  1526. prim.KeyframeMotion = null;
  1527. }
  1528. else
  1529. {
  1530. prim.KeyframeMotion = null;
  1531. }
  1532. return prim;
  1533. }
  1534. /// <summary>
  1535. /// Build a prim inventory item from the persisted data.
  1536. /// </summary>
  1537. /// <param name="row"></param>
  1538. /// <returns></returns>
  1539. private static TaskInventoryItem buildItem(DataRow row)
  1540. {
  1541. TaskInventoryItem taskItem = new TaskInventoryItem();
  1542. taskItem.ItemID = new UUID((String)row["itemID"]);
  1543. taskItem.ParentPartID = new UUID((String)row["primID"]);
  1544. taskItem.AssetID = new UUID((String)row["assetID"]);
  1545. taskItem.ParentID = new UUID((String)row["parentFolderID"]);
  1546. taskItem.InvType = Convert.ToInt32(row["invType"]);
  1547. taskItem.Type = Convert.ToInt32(row["assetType"]);
  1548. taskItem.Name = (String)row["name"];
  1549. taskItem.Description = (String)row["description"];
  1550. taskItem.CreationDate = Convert.ToUInt32(row["creationDate"]);
  1551. taskItem.CreatorIdentification = (String)row["creatorID"];
  1552. taskItem.OwnerID = new UUID((String)row["ownerID"]);
  1553. taskItem.LastOwnerID = new UUID((String)row["lastOwnerID"]);
  1554. taskItem.GroupID = new UUID((String)row["groupID"]);
  1555. taskItem.NextPermissions = Convert.ToUInt32(row["nextPermissions"]);
  1556. taskItem.CurrentPermissions = Convert.ToUInt32(row["currentPermissions"]);
  1557. taskItem.BasePermissions = Convert.ToUInt32(row["basePermissions"]);
  1558. taskItem.EveryonePermissions = Convert.ToUInt32(row["everyonePermissions"]);
  1559. taskItem.GroupPermissions = Convert.ToUInt32(row["groupPermissions"]);
  1560. taskItem.Flags = Convert.ToUInt32(row["flags"]);
  1561. return taskItem;
  1562. }
  1563. /// <summary>
  1564. /// Build a Land Data from the persisted data.
  1565. /// </summary>
  1566. /// <param name="row"></param>
  1567. /// <returns></returns>
  1568. private LandData buildLandData(DataRow row)
  1569. {
  1570. LandData newData = new LandData();
  1571. newData.GlobalID = new UUID((String)row["UUID"]);
  1572. newData.LocalID = Convert.ToInt32(row["LocalLandID"]);
  1573. // Bitmap is a byte[512]
  1574. newData.Bitmap = (Byte[])row["Bitmap"];
  1575. newData.Name = (String)row["Name"];
  1576. newData.Description = (String)row["Desc"];
  1577. newData.OwnerID = (UUID)(String)row["OwnerUUID"];
  1578. newData.IsGroupOwned = (Boolean)row["IsGroupOwned"];
  1579. newData.Area = Convert.ToInt32(row["Area"]);
  1580. newData.AuctionID = Convert.ToUInt32(row["AuctionID"]); //Unemplemented
  1581. newData.Category = (ParcelCategory)Convert.ToInt32(row["Category"]);
  1582. //Enum OpenMetaverse.Parcel.ParcelCategory
  1583. newData.ClaimDate = Convert.ToInt32(row["ClaimDate"]);
  1584. newData.ClaimPrice = Convert.ToInt32(row["ClaimPrice"]);
  1585. newData.GroupID = new UUID((String)row["GroupUUID"]);
  1586. newData.SalePrice = Convert.ToInt32(row["SalePrice"]);
  1587. newData.Status = (ParcelStatus)Convert.ToInt32(row["LandStatus"]);
  1588. //Enum. OpenMetaverse.Parcel.ParcelStatus
  1589. newData.Flags = Convert.ToUInt32(row["LandFlags"]);
  1590. newData.LandingType = (Byte)row["LandingType"];
  1591. newData.MediaAutoScale = (Byte)row["MediaAutoScale"];
  1592. newData.MediaID = new UUID((String)row["MediaTextureUUID"]);
  1593. newData.MediaURL = (String)row["MediaURL"];
  1594. newData.MusicURL = (String)row["MusicURL"];
  1595. newData.PassHours = Convert.ToSingle(row["PassHours"]);
  1596. newData.PassPrice = Convert.ToInt32(row["PassPrice"]);
  1597. newData.SnapshotID = (UUID)(String)row["SnapshotUUID"];
  1598. newData.Dwell = Convert.ToInt32(row["Dwell"]);
  1599. newData.MediaType = (String)row["MediaType"];
  1600. newData.MediaDescription = (String)row["MediaDescription"];
  1601. newData.MediaWidth = Convert.ToInt32((((string)row["MediaSize"]).Split(','))[0]);
  1602. newData.MediaHeight = Convert.ToInt32((((string)row["MediaSize"]).Split(','))[1]);
  1603. newData.MediaLoop = Convert.ToBoolean(row["MediaLoop"]);
  1604. newData.ObscureMedia = Convert.ToBoolean(row["ObscureMedia"]);
  1605. newData.ObscureMusic = Convert.ToBoolean(row["ObscureMusic"]);
  1606. try
  1607. {
  1608. newData.UserLocation =
  1609. new Vector3(Convert.ToSingle(row["UserLocationX"]), Convert.ToSingle(row["UserLocationY"]),
  1610. Convert.ToSingle(row["UserLocationZ"]));
  1611. newData.UserLookAt =
  1612. new Vector3(Convert.ToSingle(row["UserLookAtX"]), Convert.ToSingle(row["UserLookAtY"]),
  1613. Convert.ToSingle(row["UserLookAtZ"]));
  1614. }
  1615. catch (InvalidCastException)
  1616. {
  1617. m_log.ErrorFormat("[SQLITE REGION DB]: unable to get parcel telehub settings for {1}", newData.Name);
  1618. newData.UserLocation = Vector3.Zero;
  1619. newData.UserLookAt = Vector3.Zero;
  1620. }
  1621. newData.ParcelAccessList = new List<LandAccessEntry>();
  1622. UUID authBuyerID = UUID.Zero;
  1623. UUID.TryParse((string)row["AuthbuyerID"], out authBuyerID);
  1624. newData.OtherCleanTime = Convert.ToInt32(row["OtherCleanTime"]);
  1625. return newData;
  1626. }
  1627. private RegionSettings buildRegionSettings(DataRow row)
  1628. {
  1629. RegionSettings newSettings = new RegionSettings();
  1630. newSettings.RegionUUID = new UUID((string)row["regionUUID"]);
  1631. newSettings.BlockTerraform = Convert.ToBoolean(row["block_terraform"]);
  1632. newSettings.AllowDamage = Convert.ToBoolean(row["allow_damage"]);
  1633. newSettings.BlockFly = Convert.ToBoolean(row["block_fly"]);
  1634. newSettings.RestrictPushing = Convert.ToBoolean(row["restrict_pushing"]);
  1635. newSettings.AllowLandResell = Convert.ToBoolean(row["allow_land_resell"]);
  1636. newSettings.AllowLandJoinDivide = Convert.ToBoolean(row["allow_land_join_divide"]);
  1637. newSettings.BlockShowInSearch = Convert.ToBoolean(row["block_show_in_search"]);
  1638. newSettings.AgentLimit = Convert.ToInt32(row["agent_limit"]);
  1639. newSettings.ObjectBonus = Convert.ToDouble(row["object_bonus"]);
  1640. newSettings.Maturity = Convert.ToInt32(row["maturity"]);
  1641. newSettings.DisableScripts = Convert.ToBoolean(row["disable_scripts"]);
  1642. newSettings.DisableCollisions = Convert.ToBoolean(row["disable_collisions"]);
  1643. newSettings.DisablePhysics = Convert.ToBoolean(row["disable_physics"]);
  1644. newSettings.TerrainTexture1 = new UUID((String)row["terrain_texture_1"]);
  1645. newSettings.TerrainTexture2 = new UUID((String)row["terrain_texture_2"]);
  1646. newSettings.TerrainTexture3 = new UUID((String)row["terrain_texture_3"]);
  1647. newSettings.TerrainTexture4 = new UUID((String)row["terrain_texture_4"]);
  1648. newSettings.Elevation1NW = Convert.ToDouble(row["elevation_1_nw"]);
  1649. newSettings.Elevation2NW = Convert.ToDouble(row["elevation_2_nw"]);
  1650. newSettings.Elevation1NE = Convert.ToDouble(row["elevation_1_ne"]);
  1651. newSettings.Elevation2NE = Convert.ToDouble(row["elevation_2_ne"]);
  1652. newSettings.Elevation1SE = Convert.ToDouble(row["elevation_1_se"]);
  1653. newSettings.Elevation2SE = Convert.ToDouble(row["elevation_2_se"]);
  1654. newSettings.Elevation1SW = Convert.ToDouble(row["elevation_1_sw"]);
  1655. newSettings.Elevation2SW = Convert.ToDouble(row["elevation_2_sw"]);
  1656. newSettings.WaterHeight = Convert.ToDouble(row["water_height"]);
  1657. newSettings.TerrainRaiseLimit = Convert.ToDouble(row["terrain_raise_limit"]);
  1658. newSettings.TerrainLowerLimit = Convert.ToDouble(row["terrain_lower_limit"]);
  1659. newSettings.UseEstateSun = Convert.ToBoolean(row["use_estate_sun"]);
  1660. newSettings.Sandbox = Convert.ToBoolean(row["sandbox"]);
  1661. newSettings.SunVector = new Vector3(
  1662. Convert.ToSingle(row["sunvectorx"]),
  1663. Convert.ToSingle(row["sunvectory"]),
  1664. Convert.ToSingle(row["sunvectorz"])
  1665. );
  1666. newSettings.FixedSun = Convert.ToBoolean(row["fixed_sun"]);
  1667. newSettings.SunPosition = Convert.ToDouble(row["sun_position"]);
  1668. newSettings.Covenant = new UUID((String)row["covenant"]);
  1669. newSettings.CovenantChangedDateTime = Convert.ToInt32(row["covenant_datetime"]);
  1670. newSettings.TerrainImageID = new UUID((String)row["map_tile_ID"]);
  1671. newSettings.TelehubObject = new UUID((String)row["TelehubObject"]);
  1672. newSettings.ParcelImageID = new UUID((String)row["parcel_tile_ID"]);
  1673. return newSettings;
  1674. }
  1675. /// <summary>
  1676. /// Build a windlight entry from the persisted data.
  1677. /// </summary>
  1678. /// <param name="row"></param>
  1679. /// <returns>RegionLightShareData</returns>
  1680. private RegionLightShareData buildRegionWindlight(DataRow row)
  1681. {
  1682. RegionLightShareData windlight = new RegionLightShareData();
  1683. windlight.regionID = new UUID((string)row["region_id"]);
  1684. windlight.waterColor.X = Convert.ToSingle(row["water_color_r"]);
  1685. windlight.waterColor.Y = Convert.ToSingle(row["water_color_g"]);
  1686. windlight.waterColor.Z = Convert.ToSingle(row["water_color_b"]);
  1687. //windlight.waterColor.W = Convert.ToSingle(row["water_color_i"]); //not implemented
  1688. windlight.waterFogDensityExponent = Convert.ToSingle(row["water_fog_density_exponent"]);
  1689. windlight.underwaterFogModifier = Convert.ToSingle(row["underwater_fog_modifier"]);
  1690. windlight.reflectionWaveletScale.X = Convert.ToSingle(row["reflection_wavelet_scale_1"]);
  1691. windlight.reflectionWaveletScale.Y = Convert.ToSingle(row["reflection_wavelet_scale_2"]);
  1692. windlight.reflectionWaveletScale.Z = Convert.ToSingle(row["reflection_wavelet_scale_3"]);
  1693. windlight.fresnelScale = Convert.ToSingle(row["fresnel_scale"]);
  1694. windlight.fresnelOffset = Convert.ToSingle(row["fresnel_offset"]);
  1695. windlight.refractScaleAbove = Convert.ToSingle(row["refract_scale_above"]);
  1696. windlight.refractScaleBelow = Convert.ToSingle(row["refract_scale_below"]);
  1697. windlight.blurMultiplier = Convert.ToSingle(row["blur_multiplier"]);
  1698. windlight.bigWaveDirection.X = Convert.ToSingle(row["big_wave_direction_x"]);
  1699. windlight.bigWaveDirection.Y = Convert.ToSingle(row["big_wave_direction_y"]);
  1700. windlight.littleWaveDirection.X = Convert.ToSingle(row["little_wave_direction_x"]);
  1701. windlight.littleWaveDirection.Y = Convert.ToSingle(row["little_wave_direction_y"]);
  1702. windlight.normalMapTexture = new UUID((string)row["normal_map_texture"]);
  1703. windlight.horizon.X = Convert.ToSingle(row["horizon_r"]);
  1704. windlight.horizon.Y = Convert.ToSingle(row["horizon_g"]);
  1705. windlight.horizon.Z = Convert.ToSingle(row["horizon_b"]);
  1706. windlight.horizon.W = Convert.ToSingle(row["horizon_i"]);
  1707. windlight.hazeHorizon = Convert.ToSingle(row["haze_horizon"]);
  1708. windlight.blueDensity.X = Convert.ToSingle(row["blue_density_r"]);
  1709. windlight.blueDensity.Y = Convert.ToSingle(row["blue_density_g"]);
  1710. windlight.blueDensity.Z = Convert.ToSingle(row["blue_density_b"]);
  1711. windlight.blueDensity.W = Convert.ToSingle(row["blue_density_i"]);
  1712. windlight.hazeDensity = Convert.ToSingle(row["haze_density"]);
  1713. windlight.densityMultiplier = Convert.ToSingle(row["density_multiplier"]);
  1714. windlight.distanceMultiplier = Convert.ToSingle(row["distance_multiplier"]);
  1715. windlight.maxAltitude = Convert.ToUInt16(row["max_altitude"]);
  1716. windlight.sunMoonColor.X = Convert.ToSingle(row["sun_moon_color_r"]);
  1717. windlight.sunMoonColor.Y = Convert.ToSingle(row["sun_moon_color_g"]);
  1718. windlight.sunMoonColor.Z = Convert.ToSingle(row["sun_moon_color_b"]);
  1719. windlight.sunMoonColor.W = Convert.ToSingle(row["sun_moon_color_i"]);
  1720. windlight.sunMoonPosition = Convert.ToSingle(row["sun_moon_position"]);
  1721. windlight.ambient.X = Convert.ToSingle(row["ambient_r"]);
  1722. windlight.ambient.Y = Convert.ToSingle(row["ambient_g"]);
  1723. windlight.ambient.Z = Convert.ToSingle(row["ambient_b"]);
  1724. windlight.ambient.W = Convert.ToSingle(row["ambient_i"]);
  1725. windlight.eastAngle = Convert.ToSingle(row["east_angle"]);
  1726. windlight.sunGlowFocus = Convert.ToSingle(row["sun_glow_focus"]);
  1727. windlight.sunGlowSize = Convert.ToSingle(row["sun_glow_size"]);
  1728. windlight.sceneGamma = Convert.ToSingle(row["scene_gamma"]);
  1729. windlight.starBrightness = Convert.ToSingle(row["star_brightness"]);
  1730. windlight.cloudColor.X = Convert.ToSingle(row["cloud_color_r"]);
  1731. windlight.cloudColor.Y = Convert.ToSingle(row["cloud_color_g"]);
  1732. windlight.cloudColor.Z = Convert.ToSingle(row["cloud_color_b"]);
  1733. windlight.cloudColor.W = Convert.ToSingle(row["cloud_color_i"]);
  1734. windlight.cloudXYDensity.X = Convert.ToSingle(row["cloud_x"]);
  1735. windlight.cloudXYDensity.Y = Convert.ToSingle(row["cloud_y"]);
  1736. windlight.cloudXYDensity.Z = Convert.ToSingle(row["cloud_density"]);
  1737. windlight.cloudCoverage = Convert.ToSingle(row["cloud_coverage"]);
  1738. windlight.cloudScale = Convert.ToSingle(row["cloud_scale"]);
  1739. windlight.cloudDetailXYDensity.X = Convert.ToSingle(row["cloud_detail_x"]);
  1740. windlight.cloudDetailXYDensity.Y = Convert.ToSingle(row["cloud_detail_y"]);
  1741. windlight.cloudDetailXYDensity.Z = Convert.ToSingle(row["cloud_detail_density"]);
  1742. windlight.cloudScrollX = Convert.ToSingle(row["cloud_scroll_x"]);
  1743. windlight.cloudScrollXLock = Convert.ToBoolean(row["cloud_scroll_x_lock"]);
  1744. windlight.cloudScrollY = Convert.ToSingle(row["cloud_scroll_y"]);
  1745. windlight.cloudScrollYLock = Convert.ToBoolean(row["cloud_scroll_y_lock"]);
  1746. windlight.drawClassicClouds = Convert.ToBoolean(row["draw_classic_clouds"]);
  1747. return windlight;
  1748. }
  1749. /// <summary>
  1750. /// Build a land access entry from the persisted data.
  1751. /// </summary>
  1752. /// <param name="row"></param>
  1753. /// <returns></returns>
  1754. private static LandAccessEntry buildLandAccessData(DataRow row)
  1755. {
  1756. LandAccessEntry entry = new LandAccessEntry();
  1757. entry.AgentID = new UUID((string)row["AccessUUID"]);
  1758. entry.Flags = (AccessList)row["Flags"];
  1759. entry.Expires = 0;
  1760. return entry;
  1761. }
  1762. /// <summary>
  1763. ///
  1764. /// </summary>
  1765. /// <param name="row"></param>
  1766. /// <param name="prim"></param>
  1767. /// <param name="sceneGroupID"></param>
  1768. /// <param name="regionUUID"></param>
  1769. private static void fillPrimRow(DataRow row, SceneObjectPart prim, UUID sceneGroupID, UUID regionUUID)
  1770. {
  1771. row["UUID"] = prim.UUID.ToString();
  1772. row["RegionUUID"] = regionUUID.ToString();
  1773. row["CreationDate"] = prim.CreationDate;
  1774. row["Name"] = prim.Name;
  1775. row["SceneGroupID"] = sceneGroupID.ToString();
  1776. // the UUID of the root part for this SceneObjectGroup
  1777. // various text fields
  1778. row["Text"] = prim.Text;
  1779. row["Description"] = prim.Description;
  1780. row["SitName"] = prim.SitName;
  1781. row["TouchName"] = prim.TouchName;
  1782. // permissions
  1783. row["ObjectFlags"] = prim.ObjectFlags;
  1784. row["CreatorID"] = prim.CreatorIdentification.ToString();
  1785. row["OwnerID"] = prim.OwnerID.ToString();
  1786. row["GroupID"] = prim.GroupID.ToString();
  1787. row["LastOwnerID"] = prim.LastOwnerID.ToString();
  1788. row["OwnerMask"] = prim.OwnerMask;
  1789. row["NextOwnerMask"] = prim.NextOwnerMask;
  1790. row["GroupMask"] = prim.GroupMask;
  1791. row["EveryoneMask"] = prim.EveryoneMask;
  1792. row["BaseMask"] = prim.BaseMask;
  1793. // vectors
  1794. row["PositionX"] = prim.OffsetPosition.X;
  1795. row["PositionY"] = prim.OffsetPosition.Y;
  1796. row["PositionZ"] = prim.OffsetPosition.Z;
  1797. row["GroupPositionX"] = prim.GroupPosition.X;
  1798. row["GroupPositionY"] = prim.GroupPosition.Y;
  1799. row["GroupPositionZ"] = prim.GroupPosition.Z;
  1800. row["VelocityX"] = prim.Velocity.X;
  1801. row["VelocityY"] = prim.Velocity.Y;
  1802. row["VelocityZ"] = prim.Velocity.Z;
  1803. row["AngularVelocityX"] = prim.AngularVelocity.X;
  1804. row["AngularVelocityY"] = prim.AngularVelocity.Y;
  1805. row["AngularVelocityZ"] = prim.AngularVelocity.Z;
  1806. row["AccelerationX"] = prim.Acceleration.X;
  1807. row["AccelerationY"] = prim.Acceleration.Y;
  1808. row["AccelerationZ"] = prim.Acceleration.Z;
  1809. // quaternions
  1810. row["RotationX"] = prim.RotationOffset.X;
  1811. row["RotationY"] = prim.RotationOffset.Y;
  1812. row["RotationZ"] = prim.RotationOffset.Z;
  1813. row["RotationW"] = prim.RotationOffset.W;
  1814. // Sit target
  1815. Vector3 sitTargetPos = prim.SitTargetPositionLL;
  1816. row["SitTargetOffsetX"] = sitTargetPos.X;
  1817. row["SitTargetOffsetY"] = sitTargetPos.Y;
  1818. row["SitTargetOffsetZ"] = sitTargetPos.Z;
  1819. Quaternion sitTargetOrient = prim.SitTargetOrientationLL;
  1820. row["SitTargetOrientW"] = sitTargetOrient.W;
  1821. row["SitTargetOrientX"] = sitTargetOrient.X;
  1822. row["SitTargetOrientY"] = sitTargetOrient.Y;
  1823. row["SitTargetOrientZ"] = sitTargetOrient.Z;
  1824. row["ColorR"] = Convert.ToInt32(prim.Color.R);
  1825. row["ColorG"] = Convert.ToInt32(prim.Color.G);
  1826. row["ColorB"] = Convert.ToInt32(prim.Color.B);
  1827. row["ColorA"] = Convert.ToInt32(prim.Color.A);
  1828. row["PayPrice"] = prim.PayPrice[0];
  1829. row["PayButton1"] = prim.PayPrice[1];
  1830. row["PayButton2"] = prim.PayPrice[2];
  1831. row["PayButton3"] = prim.PayPrice[3];
  1832. row["PayButton4"] = prim.PayPrice[4];
  1833. row["TextureAnimation"] = Convert.ToBase64String(prim.TextureAnimation);
  1834. row["ParticleSystem"] = Convert.ToBase64String(prim.ParticleSystem);
  1835. row["OmegaX"] = prim.AngularVelocity.X;
  1836. row["OmegaY"] = prim.AngularVelocity.Y;
  1837. row["OmegaZ"] = prim.AngularVelocity.Z;
  1838. row["CameraEyeOffsetX"] = prim.GetCameraEyeOffset().X;
  1839. row["CameraEyeOffsetY"] = prim.GetCameraEyeOffset().Y;
  1840. row["CameraEyeOffsetZ"] = prim.GetCameraEyeOffset().Z;
  1841. row["CameraAtOffsetX"] = prim.GetCameraAtOffset().X;
  1842. row["CameraAtOffsetY"] = prim.GetCameraAtOffset().Y;
  1843. row["CameraAtOffsetZ"] = prim.GetCameraAtOffset().Z;
  1844. if ((prim.SoundFlags & 1) != 0) // Looped
  1845. {
  1846. row["LoopedSound"] = prim.Sound.ToString();
  1847. row["LoopedSoundGain"] = prim.SoundGain;
  1848. }
  1849. else
  1850. {
  1851. row["LoopedSound"] = UUID.Zero.ToString();
  1852. row["LoopedSoundGain"] = 0.0f;
  1853. }
  1854. if (prim.GetForceMouselook())
  1855. row["ForceMouselook"] = 1;
  1856. else
  1857. row["ForceMouselook"] = 0;
  1858. row["ScriptAccessPin"] = prim.ScriptAccessPin;
  1859. if (prim.AllowedDrop)
  1860. row["AllowedDrop"] = 1;
  1861. else
  1862. row["AllowedDrop"] = 0;
  1863. if (prim.DIE_AT_EDGE)
  1864. row["DieAtEdge"] = 1;
  1865. else
  1866. row["DieAtEdge"] = 0;
  1867. row["SalePrice"] = prim.SalePrice;
  1868. row["SaleType"] = Convert.ToInt16(prim.ObjectSaleType);
  1869. // click action
  1870. row["ClickAction"] = prim.ClickAction;
  1871. row["SalePrice"] = prim.SalePrice;
  1872. row["Material"] = prim.Material;
  1873. row["CollisionSound"] = prim.CollisionSound.ToString();
  1874. row["CollisionSoundVolume"] = prim.CollisionSoundVolume;
  1875. if (prim.VolumeDetectActive)
  1876. row["VolumeDetect"] = 1;
  1877. else
  1878. row["VolumeDetect"] = 0;
  1879. row["MediaURL"] = prim.MediaUrl;
  1880. row["AttachedPosX"] = prim.AttachedPos.X;
  1881. row["AttachedPosY"] = prim.AttachedPos.Y;
  1882. row["AttachedPosZ"] = prim.AttachedPos.Z;
  1883. if (prim.DynAttrs.CountNamespaces > 0)
  1884. row["DynAttrs"] = prim.DynAttrs.ToXml();
  1885. else
  1886. row["DynAttrs"] = null;
  1887. row["PhysicsShapeType"] = prim.PhysicsShapeType;
  1888. row["Density"] = (double)prim.Density;
  1889. row["GravityModifier"] = (double)prim.GravityModifier;
  1890. row["Friction"] = (double)prim.Friction;
  1891. row["Restitution"] = (double)prim.Restitution;
  1892. if (prim.KeyframeMotion != null)
  1893. row["KeyframeMotion"] = prim.KeyframeMotion.Serialize();
  1894. else
  1895. row["KeyframeMotion"] = new Byte[0];
  1896. }
  1897. /// <summary>
  1898. ///
  1899. /// </summary>
  1900. /// <param name="row"></param>
  1901. /// <param name="taskItem"></param>
  1902. private static void fillItemRow(DataRow row, TaskInventoryItem taskItem)
  1903. {
  1904. row["itemID"] = taskItem.ItemID.ToString();
  1905. row["primID"] = taskItem.ParentPartID.ToString();
  1906. row["assetID"] = taskItem.AssetID.ToString();
  1907. row["parentFolderID"] = taskItem.ParentID.ToString();
  1908. row["invType"] = taskItem.InvType;
  1909. row["assetType"] = taskItem.Type;
  1910. row["name"] = taskItem.Name;
  1911. row["description"] = taskItem.Description;
  1912. row["creationDate"] = taskItem.CreationDate;
  1913. row["creatorID"] = taskItem.CreatorIdentification.ToString();
  1914. row["ownerID"] = taskItem.OwnerID.ToString();
  1915. row["lastOwnerID"] = taskItem.LastOwnerID.ToString();
  1916. row["groupID"] = taskItem.GroupID.ToString();
  1917. row["nextPermissions"] = taskItem.NextPermissions;
  1918. row["currentPermissions"] = taskItem.CurrentPermissions;
  1919. row["basePermissions"] = taskItem.BasePermissions;
  1920. row["everyonePermissions"] = taskItem.EveryonePermissions;
  1921. row["groupPermissions"] = taskItem.GroupPermissions;
  1922. row["flags"] = taskItem.Flags;
  1923. }
  1924. /// <summary>
  1925. ///
  1926. /// </summary>
  1927. /// <param name="row"></param>
  1928. /// <param name="land"></param>
  1929. /// <param name="regionUUID"></param>
  1930. private static void fillLandRow(DataRow row, LandData land, UUID regionUUID)
  1931. {
  1932. row["UUID"] = land.GlobalID.ToString();
  1933. row["RegionUUID"] = regionUUID.ToString();
  1934. row["LocalLandID"] = land.LocalID;
  1935. // Bitmap is a byte[512]
  1936. row["Bitmap"] = land.Bitmap;
  1937. row["Name"] = land.Name;
  1938. row["Desc"] = land.Description;
  1939. row["OwnerUUID"] = land.OwnerID.ToString();
  1940. row["IsGroupOwned"] = land.IsGroupOwned;
  1941. row["Area"] = land.Area;
  1942. row["AuctionID"] = land.AuctionID; //Unemplemented
  1943. row["Category"] = land.Category; //Enum OpenMetaverse.Parcel.ParcelCategory
  1944. row["ClaimDate"] = land.ClaimDate;
  1945. row["ClaimPrice"] = land.ClaimPrice;
  1946. row["GroupUUID"] = land.GroupID.ToString();
  1947. row["SalePrice"] = land.SalePrice;
  1948. row["LandStatus"] = land.Status; //Enum. OpenMetaverse.Parcel.ParcelStatus
  1949. row["LandFlags"] = land.Flags;
  1950. row["LandingType"] = land.LandingType;
  1951. row["MediaAutoScale"] = land.MediaAutoScale;
  1952. row["MediaTextureUUID"] = land.MediaID.ToString();
  1953. row["MediaURL"] = land.MediaURL;
  1954. row["MusicURL"] = land.MusicURL;
  1955. row["PassHours"] = land.PassHours;
  1956. row["PassPrice"] = land.PassPrice;
  1957. row["SnapshotUUID"] = land.SnapshotID.ToString();
  1958. row["UserLocationX"] = land.UserLocation.X;
  1959. row["UserLocationY"] = land.UserLocation.Y;
  1960. row["UserLocationZ"] = land.UserLocation.Z;
  1961. row["UserLookAtX"] = land.UserLookAt.X;
  1962. row["UserLookAtY"] = land.UserLookAt.Y;
  1963. row["UserLookAtZ"] = land.UserLookAt.Z;
  1964. row["AuthbuyerID"] = land.AuthBuyerID.ToString();
  1965. row["OtherCleanTime"] = land.OtherCleanTime;
  1966. row["Dwell"] = land.Dwell;
  1967. row["MediaType"] = land.MediaType;
  1968. row["MediaDescription"] = land.MediaDescription;
  1969. row["MediaSize"] = String.Format("{0},{1}", land.MediaWidth, land.MediaHeight);
  1970. row["MediaLoop"] = land.MediaLoop;
  1971. row["ObscureMusic"] = land.ObscureMusic;
  1972. row["ObscureMedia"] = land.ObscureMedia;
  1973. }
  1974. /// <summary>
  1975. ///
  1976. /// </summary>
  1977. /// <param name="row"></param>
  1978. /// <param name="entry"></param>
  1979. /// <param name="parcelID"></param>
  1980. private static void fillLandAccessRow(DataRow row, LandAccessEntry entry, UUID parcelID)
  1981. {
  1982. row["LandUUID"] = parcelID.ToString();
  1983. row["AccessUUID"] = entry.AgentID.ToString();
  1984. row["Flags"] = entry.Flags;
  1985. }
  1986. private static void fillRegionSettingsRow(DataRow row, RegionSettings settings)
  1987. {
  1988. row["regionUUID"] = settings.RegionUUID.ToString();
  1989. row["block_terraform"] = settings.BlockTerraform;
  1990. row["block_fly"] = settings.BlockFly;
  1991. row["allow_damage"] = settings.AllowDamage;
  1992. row["restrict_pushing"] = settings.RestrictPushing;
  1993. row["allow_land_resell"] = settings.AllowLandResell;
  1994. row["allow_land_join_divide"] = settings.AllowLandJoinDivide;
  1995. row["block_show_in_search"] = settings.BlockShowInSearch;
  1996. row["agent_limit"] = settings.AgentLimit;
  1997. row["object_bonus"] = settings.ObjectBonus;
  1998. row["maturity"] = settings.Maturity;
  1999. row["disable_scripts"] = settings.DisableScripts;
  2000. row["disable_collisions"] = settings.DisableCollisions;
  2001. row["disable_physics"] = settings.DisablePhysics;
  2002. row["terrain_texture_1"] = settings.TerrainTexture1.ToString();
  2003. row["terrain_texture_2"] = settings.TerrainTexture2.ToString();
  2004. row["terrain_texture_3"] = settings.TerrainTexture3.ToString();
  2005. row["terrain_texture_4"] = settings.TerrainTexture4.ToString();
  2006. row["elevation_1_nw"] = settings.Elevation1NW;
  2007. row["elevation_2_nw"] = settings.Elevation2NW;
  2008. row["elevation_1_ne"] = settings.Elevation1NE;
  2009. row["elevation_2_ne"] = settings.Elevation2NE;
  2010. row["elevation_1_se"] = settings.Elevation1SE;
  2011. row["elevation_2_se"] = settings.Elevation2SE;
  2012. row["elevation_1_sw"] = settings.Elevation1SW;
  2013. row["elevation_2_sw"] = settings.Elevation2SW;
  2014. row["water_height"] = settings.WaterHeight;
  2015. row["terrain_raise_limit"] = settings.TerrainRaiseLimit;
  2016. row["terrain_lower_limit"] = settings.TerrainLowerLimit;
  2017. row["use_estate_sun"] = settings.UseEstateSun;
  2018. row["sandbox"] = settings.Sandbox; // unlike other database modules, sqlite uses a lower case s for sandbox!
  2019. row["sunvectorx"] = settings.SunVector.X;
  2020. row["sunvectory"] = settings.SunVector.Y;
  2021. row["sunvectorz"] = settings.SunVector.Z;
  2022. row["fixed_sun"] = settings.FixedSun;
  2023. row["sun_position"] = settings.SunPosition;
  2024. row["covenant"] = settings.Covenant.ToString();
  2025. row["covenant_datetime"] = settings.CovenantChangedDateTime;
  2026. row["map_tile_ID"] = settings.TerrainImageID.ToString();
  2027. row["TelehubObject"] = settings.TelehubObject.ToString();
  2028. row["parcel_tile_ID"] = settings.ParcelImageID.ToString();
  2029. }
  2030. /// <summary>
  2031. ///
  2032. /// </summary>
  2033. /// <param name="row"></param>
  2034. /// <param name="windlight"></param>
  2035. private static void fillRegionWindlightRow(DataRow row, RegionLightShareData windlight)
  2036. {
  2037. row["region_id"] = windlight.regionID.ToString();
  2038. row["water_color_r"] = windlight.waterColor.X;
  2039. row["water_color_g"] = windlight.waterColor.Y;
  2040. row["water_color_b"] = windlight.waterColor.Z;
  2041. row["water_color_i"] = 1; //windlight.waterColor.W; //not implemented
  2042. row["water_fog_density_exponent"] = windlight.waterFogDensityExponent;
  2043. row["underwater_fog_modifier"] = windlight.underwaterFogModifier;
  2044. row["reflection_wavelet_scale_1"] = windlight.reflectionWaveletScale.X;
  2045. row["reflection_wavelet_scale_2"] = windlight.reflectionWaveletScale.Y;
  2046. row["reflection_wavelet_scale_3"] = windlight.reflectionWaveletScale.Z;
  2047. row["fresnel_scale"] = windlight.fresnelScale;
  2048. row["fresnel_offset"] = windlight.fresnelOffset;
  2049. row["refract_scale_above"] = windlight.refractScaleAbove;
  2050. row["refract_scale_below"] = windlight.refractScaleBelow;
  2051. row["blur_multiplier"] = windlight.blurMultiplier;
  2052. row["big_wave_direction_x"] = windlight.bigWaveDirection.X;
  2053. row["big_wave_direction_y"] = windlight.bigWaveDirection.Y;
  2054. row["little_wave_direction_x"] = windlight.littleWaveDirection.X;
  2055. row["little_wave_direction_y"] = windlight.littleWaveDirection.Y;
  2056. row["normal_map_texture"] = windlight.normalMapTexture.ToString();
  2057. row["horizon_r"] = windlight.horizon.X;
  2058. row["horizon_g"] = windlight.horizon.Y;
  2059. row["horizon_b"] = windlight.horizon.Z;
  2060. row["horizon_i"] = windlight.horizon.W;
  2061. row["haze_horizon"] = windlight.hazeHorizon;
  2062. row["blue_density_r"] = windlight.blueDensity.X;
  2063. row["blue_density_g"] = windlight.blueDensity.Y;
  2064. row["blue_density_b"] = windlight.blueDensity.Z;
  2065. row["blue_density_i"] = windlight.blueDensity.W;
  2066. row["haze_density"] = windlight.hazeDensity;
  2067. row["density_multiplier"] = windlight.densityMultiplier;
  2068. row["distance_multiplier"] = windlight.distanceMultiplier;
  2069. row["max_altitude"] = windlight.maxAltitude;
  2070. row["sun_moon_color_r"] = windlight.sunMoonColor.X;
  2071. row["sun_moon_color_g"] = windlight.sunMoonColor.Y;
  2072. row["sun_moon_color_b"] = windlight.sunMoonColor.Z;
  2073. row["sun_moon_color_i"] = windlight.sunMoonColor.W;
  2074. row["sun_moon_position"] = windlight.sunMoonPosition;
  2075. row["ambient_r"] = windlight.ambient.X;
  2076. row["ambient_g"] = windlight.ambient.Y;
  2077. row["ambient_b"] = windlight.ambient.Z;
  2078. row["ambient_i"] = windlight.ambient.W;
  2079. row["east_angle"] = windlight.eastAngle;
  2080. row["sun_glow_focus"] = windlight.sunGlowFocus;
  2081. row["sun_glow_size"] = windlight.sunGlowSize;
  2082. row["scene_gamma"] = windlight.sceneGamma;
  2083. row["star_brightness"] = windlight.starBrightness;
  2084. row["cloud_color_r"] = windlight.cloudColor.X;
  2085. row["cloud_color_g"] = windlight.cloudColor.Y;
  2086. row["cloud_color_b"] = windlight.cloudColor.Z;
  2087. row["cloud_color_i"] = windlight.cloudColor.W;
  2088. row["cloud_x"] = windlight.cloudXYDensity.X;
  2089. row["cloud_y"] = windlight.cloudXYDensity.Y;
  2090. row["cloud_density"] = windlight.cloudXYDensity.Z;
  2091. row["cloud_coverage"] = windlight.cloudCoverage;
  2092. row["cloud_scale"] = windlight.cloudScale;
  2093. row["cloud_detail_x"] = windlight.cloudDetailXYDensity.X;
  2094. row["cloud_detail_y"] = windlight.cloudDetailXYDensity.Y;
  2095. row["cloud_detail_density"] = windlight.cloudDetailXYDensity.Z;
  2096. row["cloud_scroll_x"] = windlight.cloudScrollX;
  2097. row["cloud_scroll_x_lock"] = windlight.cloudScrollXLock;
  2098. row["cloud_scroll_y"] = windlight.cloudScrollY;
  2099. row["cloud_scroll_y_lock"] = windlight.cloudScrollYLock;
  2100. row["draw_classic_clouds"] = windlight.drawClassicClouds;
  2101. }
  2102. /// <summary>
  2103. ///
  2104. /// </summary>
  2105. /// <param name="row"></param>
  2106. /// <returns></returns>
  2107. private PrimitiveBaseShape buildShape(DataRow row)
  2108. {
  2109. PrimitiveBaseShape s = new PrimitiveBaseShape();
  2110. s.Scale = new Vector3(
  2111. Convert.ToSingle(row["ScaleX"]),
  2112. Convert.ToSingle(row["ScaleY"]),
  2113. Convert.ToSingle(row["ScaleZ"])
  2114. );
  2115. // paths
  2116. s.PCode = Convert.ToByte(row["PCode"]);
  2117. s.PathBegin = Convert.ToUInt16(row["PathBegin"]);
  2118. s.PathEnd = Convert.ToUInt16(row["PathEnd"]);
  2119. s.PathScaleX = Convert.ToByte(row["PathScaleX"]);
  2120. s.PathScaleY = Convert.ToByte(row["PathScaleY"]);
  2121. s.PathShearX = Convert.ToByte(row["PathShearX"]);
  2122. s.PathShearY = Convert.ToByte(row["PathShearY"]);
  2123. s.PathSkew = Convert.ToSByte(row["PathSkew"]);
  2124. s.PathCurve = Convert.ToByte(row["PathCurve"]);
  2125. s.PathRadiusOffset = Convert.ToSByte(row["PathRadiusOffset"]);
  2126. s.PathRevolutions = Convert.ToByte(row["PathRevolutions"]);
  2127. s.PathTaperX = Convert.ToSByte(row["PathTaperX"]);
  2128. s.PathTaperY = Convert.ToSByte(row["PathTaperY"]);
  2129. s.PathTwist = Convert.ToSByte(row["PathTwist"]);
  2130. s.PathTwistBegin = Convert.ToSByte(row["PathTwistBegin"]);
  2131. // profile
  2132. s.ProfileBegin = Convert.ToUInt16(row["ProfileBegin"]);
  2133. s.ProfileEnd = Convert.ToUInt16(row["ProfileEnd"]);
  2134. s.ProfileCurve = Convert.ToByte(row["ProfileCurve"]);
  2135. s.ProfileHollow = Convert.ToUInt16(row["ProfileHollow"]);
  2136. s.State = Convert.ToByte(row["State"]);
  2137. s.LastAttachPoint = Convert.ToByte(row["LastAttachPoint"]);
  2138. byte[] textureEntry = (byte[])row["Texture"];
  2139. s.TextureEntry = textureEntry;
  2140. s.ExtraParams = (byte[])row["ExtraParams"];
  2141. if (!(row["Media"] is System.DBNull))
  2142. s.Media = PrimitiveBaseShape.MediaList.FromXml((string)row["Media"]);
  2143. return s;
  2144. }
  2145. /// <summary>
  2146. ///
  2147. /// </summary>
  2148. /// <param name="row"></param>
  2149. /// <param name="prim"></param>
  2150. private static void fillShapeRow(DataRow row, SceneObjectPart prim)
  2151. {
  2152. PrimitiveBaseShape s = prim.Shape;
  2153. row["UUID"] = prim.UUID.ToString();
  2154. // shape is an enum
  2155. row["Shape"] = 0;
  2156. // vectors
  2157. row["ScaleX"] = s.Scale.X;
  2158. row["ScaleY"] = s.Scale.Y;
  2159. row["ScaleZ"] = s.Scale.Z;
  2160. // paths
  2161. row["PCode"] = s.PCode;
  2162. row["PathBegin"] = s.PathBegin;
  2163. row["PathEnd"] = s.PathEnd;
  2164. row["PathScaleX"] = s.PathScaleX;
  2165. row["PathScaleY"] = s.PathScaleY;
  2166. row["PathShearX"] = s.PathShearX;
  2167. row["PathShearY"] = s.PathShearY;
  2168. row["PathSkew"] = s.PathSkew;
  2169. row["PathCurve"] = s.PathCurve;
  2170. row["PathRadiusOffset"] = s.PathRadiusOffset;
  2171. row["PathRevolutions"] = s.PathRevolutions;
  2172. row["PathTaperX"] = s.PathTaperX;
  2173. row["PathTaperY"] = s.PathTaperY;
  2174. row["PathTwist"] = s.PathTwist;
  2175. row["PathTwistBegin"] = s.PathTwistBegin;
  2176. // profile
  2177. row["ProfileBegin"] = s.ProfileBegin;
  2178. row["ProfileEnd"] = s.ProfileEnd;
  2179. row["ProfileCurve"] = s.ProfileCurve;
  2180. row["ProfileHollow"] = s.ProfileHollow;
  2181. row["State"] = s.State;
  2182. row["LastAttachPoint"] = s.LastAttachPoint;
  2183. row["Texture"] = s.TextureEntry;
  2184. row["ExtraParams"] = s.ExtraParams;
  2185. if (s.Media != null)
  2186. row["Media"] = s.Media.ToXml();
  2187. }
  2188. /// <summary>
  2189. /// Persistently store a prim.
  2190. /// </summary>
  2191. /// <param name="prim"></param>
  2192. /// <param name="sceneGroupID"></param>
  2193. /// <param name="regionUUID"></param>
  2194. private void addPrim(SceneObjectPart prim, UUID sceneGroupID, UUID regionUUID)
  2195. {
  2196. DataTable prims = ds.Tables["prims"];
  2197. DataTable shapes = ds.Tables["primshapes"];
  2198. DataRow primRow = prims.Rows.Find(prim.UUID.ToString());
  2199. if (primRow == null)
  2200. {
  2201. primRow = prims.NewRow();
  2202. fillPrimRow(primRow, prim, sceneGroupID, regionUUID);
  2203. prims.Rows.Add(primRow);
  2204. }
  2205. else
  2206. {
  2207. fillPrimRow(primRow, prim, sceneGroupID, regionUUID);
  2208. }
  2209. DataRow shapeRow = shapes.Rows.Find(prim.UUID.ToString());
  2210. if (shapeRow == null)
  2211. {
  2212. shapeRow = shapes.NewRow();
  2213. fillShapeRow(shapeRow, prim);
  2214. shapes.Rows.Add(shapeRow);
  2215. }
  2216. else
  2217. {
  2218. fillShapeRow(shapeRow, prim);
  2219. }
  2220. }
  2221. /// <summary>
  2222. /// </summary>
  2223. /// <param name="primID"></param>
  2224. /// <param name="items"></param>
  2225. public void StorePrimInventory(UUID primID, ICollection<TaskInventoryItem> items)
  2226. {
  2227. // m_log.DebugFormat("[SQLITE REGION DB]: Entered StorePrimInventory with prim ID {0}", primID);
  2228. DataTable dbItems = ds.Tables["primitems"];
  2229. // For now, we're just going to crudely remove all the previous inventory items
  2230. // no matter whether they have changed or not, and replace them with the current set.
  2231. lock (ds)
  2232. {
  2233. RemoveItems(primID);
  2234. // repalce with current inventory details
  2235. foreach (TaskInventoryItem newItem in items)
  2236. {
  2237. // m_log.InfoFormat(
  2238. // "[DATASTORE]: ",
  2239. // "Adding item {0}, {1} to prim ID {2}",
  2240. // newItem.Name, newItem.ItemID, newItem.ParentPartID);
  2241. DataRow newItemRow = dbItems.NewRow();
  2242. fillItemRow(newItemRow, newItem);
  2243. dbItems.Rows.Add(newItemRow);
  2244. }
  2245. }
  2246. Commit();
  2247. }
  2248. /***********************************************************************
  2249. *
  2250. * SQL Statement Creation Functions
  2251. *
  2252. * These functions create SQL statements for update, insert, and create.
  2253. * They can probably be factored later to have a db independant
  2254. * portion and a db specific portion
  2255. *
  2256. **********************************************************************/
  2257. /// <summary>
  2258. /// Create an insert command
  2259. /// </summary>
  2260. /// <param name="table">table name</param>
  2261. /// <param name="dt">data table</param>
  2262. /// <returns>the created command</returns>
  2263. /// <remarks>
  2264. /// This is subtle enough to deserve some commentary.
  2265. /// Instead of doing *lots* and *lots of hardcoded strings
  2266. /// for database definitions we'll use the fact that
  2267. /// realistically all insert statements look like "insert
  2268. /// into A(b, c) values(:b, :c) on the parameterized query
  2269. /// front. If we just have a list of b, c, etc... we can
  2270. /// generate these strings instead of typing them out.
  2271. /// </remarks>
  2272. private static SqliteCommand createInsertCommand(string table, DataTable dt)
  2273. {
  2274. string[] cols = new string[dt.Columns.Count];
  2275. for (int i = 0; i < dt.Columns.Count; i++)
  2276. {
  2277. DataColumn col = dt.Columns[i];
  2278. cols[i] = col.ColumnName;
  2279. }
  2280. string sql = "insert into " + table + "(";
  2281. sql += String.Join(", ", cols);
  2282. // important, the first ':' needs to be here, the rest get added in the join
  2283. sql += ") values (:";
  2284. sql += String.Join(", :", cols);
  2285. sql += ")";
  2286. // m_log.DebugFormat("[SQLITE]: Created insert command {0}", sql);
  2287. SqliteCommand cmd = new SqliteCommand(sql);
  2288. // this provides the binding for all our parameters, so
  2289. // much less code than it used to be
  2290. foreach (DataColumn col in dt.Columns)
  2291. {
  2292. cmd.Parameters.Add(createSqliteParameter(col.ColumnName, col.DataType));
  2293. }
  2294. return cmd;
  2295. }
  2296. /// <summary>
  2297. /// create an update command
  2298. /// </summary>
  2299. /// <param name="table">table name</param>
  2300. /// <param name="pk"></param>
  2301. /// <param name="dt"></param>
  2302. /// <returns>the created command</returns>
  2303. private static SqliteCommand createUpdateCommand(string table, string pk, DataTable dt)
  2304. {
  2305. string sql = "update " + table + " set ";
  2306. string subsql = String.Empty;
  2307. foreach (DataColumn col in dt.Columns)
  2308. {
  2309. if (subsql.Length > 0)
  2310. {
  2311. // a map function would rock so much here
  2312. subsql += ", ";
  2313. }
  2314. subsql += col.ColumnName + "= :" + col.ColumnName;
  2315. }
  2316. sql += subsql;
  2317. sql += " where " + pk;
  2318. SqliteCommand cmd = new SqliteCommand(sql);
  2319. // this provides the binding for all our parameters, so
  2320. // much less code than it used to be
  2321. foreach (DataColumn col in dt.Columns)
  2322. {
  2323. cmd.Parameters.Add(createSqliteParameter(col.ColumnName, col.DataType));
  2324. }
  2325. return cmd;
  2326. }
  2327. /// <summary>
  2328. /// create an update command
  2329. /// </summary>
  2330. /// <param name="table">table name</param>
  2331. /// <param name="pk"></param>
  2332. /// <param name="dt"></param>
  2333. /// <returns>the created command</returns>
  2334. private static SqliteCommand createUpdateCommand(string table, string pk1, string pk2, DataTable dt)
  2335. {
  2336. string sql = "update " + table + " set ";
  2337. string subsql = String.Empty;
  2338. foreach (DataColumn col in dt.Columns)
  2339. {
  2340. if (subsql.Length > 0)
  2341. {
  2342. // a map function would rock so much here
  2343. subsql += ", ";
  2344. }
  2345. subsql += col.ColumnName + "= :" + col.ColumnName;
  2346. }
  2347. sql += subsql;
  2348. sql += " where " + pk1 + " and " + pk2;
  2349. SqliteCommand cmd = new SqliteCommand(sql);
  2350. // this provides the binding for all our parameters, so
  2351. // much less code than it used to be
  2352. foreach (DataColumn col in dt.Columns)
  2353. {
  2354. cmd.Parameters.Add(createSqliteParameter(col.ColumnName, col.DataType));
  2355. }
  2356. return cmd;
  2357. }
  2358. /// <summary>
  2359. ///
  2360. /// </summary>
  2361. /// <param name="dt">Data Table</param>
  2362. /// <returns></returns>
  2363. // private static string defineTable(DataTable dt)
  2364. // {
  2365. // string sql = "create table " + dt.TableName + "(";
  2366. // string subsql = String.Empty;
  2367. // foreach (DataColumn col in dt.Columns)
  2368. // {
  2369. // if (subsql.Length > 0)
  2370. // {
  2371. // // a map function would rock so much here
  2372. // subsql += ",\n";
  2373. // }
  2374. // subsql += col.ColumnName + " " + sqliteType(col.DataType);
  2375. // if (dt.PrimaryKey.Length > 0 && col == dt.PrimaryKey[0])
  2376. // {
  2377. // subsql += " primary key";
  2378. // }
  2379. // }
  2380. // sql += subsql;
  2381. // sql += ")";
  2382. // return sql;
  2383. // }
  2384. /***********************************************************************
  2385. *
  2386. * Database Binding functions
  2387. *
  2388. * These will be db specific due to typing, and minor differences
  2389. * in databases.
  2390. *
  2391. **********************************************************************/
  2392. ///<summary>
  2393. /// This is a convenience function that collapses 5 repetitive
  2394. /// lines for defining SqliteParameters to 2 parameters:
  2395. /// column name and database type.
  2396. ///
  2397. /// It assumes certain conventions like :param as the param
  2398. /// name to replace in parametrized queries, and that source
  2399. /// version is always current version, both of which are fine
  2400. /// for us.
  2401. ///</summary>
  2402. ///<returns>a built sqlite parameter</returns>
  2403. private static SqliteParameter createSqliteParameter(string name, Type type)
  2404. {
  2405. SqliteParameter param = new SqliteParameter();
  2406. param.ParameterName = ":" + name;
  2407. param.DbType = dbtypeFromType(type);
  2408. param.SourceColumn = name;
  2409. param.SourceVersion = DataRowVersion.Current;
  2410. return param;
  2411. }
  2412. /// <summary>
  2413. ///
  2414. /// </summary>
  2415. /// <param name="da"></param>
  2416. /// <param name="conn"></param>
  2417. private void setupPrimCommands(SqliteDataAdapter da, SqliteConnection conn)
  2418. {
  2419. da.InsertCommand = createInsertCommand("prims", ds.Tables["prims"]);
  2420. da.InsertCommand.Connection = conn;
  2421. da.UpdateCommand = createUpdateCommand("prims", "UUID=:UUID", ds.Tables["prims"]);
  2422. da.UpdateCommand.Connection = conn;
  2423. SqliteCommand delete = new SqliteCommand("delete from prims where UUID = :UUID");
  2424. delete.Parameters.Add(createSqliteParameter("UUID", typeof(String)));
  2425. delete.Connection = conn;
  2426. da.DeleteCommand = delete;
  2427. }
  2428. /// <summary>
  2429. ///
  2430. /// </summary>
  2431. /// <param name="da"></param>
  2432. /// <param name="conn"></param>
  2433. private void setupItemsCommands(SqliteDataAdapter da, SqliteConnection conn)
  2434. {
  2435. da.InsertCommand = createInsertCommand("primitems", ds.Tables["primitems"]);
  2436. da.InsertCommand.Connection = conn;
  2437. da.UpdateCommand = createUpdateCommand("primitems", "itemID = :itemID", ds.Tables["primitems"]);
  2438. da.UpdateCommand.Connection = conn;
  2439. SqliteCommand delete = new SqliteCommand("delete from primitems where itemID = :itemID");
  2440. delete.Parameters.Add(createSqliteParameter("itemID", typeof(String)));
  2441. delete.Connection = conn;
  2442. da.DeleteCommand = delete;
  2443. }
  2444. /// <summary>
  2445. ///
  2446. /// </summary>
  2447. /// <param name="da"></param>
  2448. /// <param name="conn"></param>
  2449. private void setupTerrainCommands(SqliteDataAdapter da, SqliteConnection conn)
  2450. {
  2451. da.InsertCommand = createInsertCommand("terrain", ds.Tables["terrain"]);
  2452. da.InsertCommand.Connection = conn;
  2453. }
  2454. /// <summary>
  2455. ///
  2456. /// </summary>
  2457. /// <param name="da"></param>
  2458. /// <param name="conn"></param>
  2459. private void setupLandCommands(SqliteDataAdapter da, SqliteConnection conn)
  2460. {
  2461. da.InsertCommand = createInsertCommand("land", ds.Tables["land"]);
  2462. da.InsertCommand.Connection = conn;
  2463. da.UpdateCommand = createUpdateCommand("land", "UUID=:UUID", ds.Tables["land"]);
  2464. da.UpdateCommand.Connection = conn;
  2465. SqliteCommand delete = new SqliteCommand("delete from land where UUID=:UUID");
  2466. delete.Parameters.Add(createSqliteParameter("UUID", typeof(String)));
  2467. da.DeleteCommand = delete;
  2468. da.DeleteCommand.Connection = conn;
  2469. }
  2470. /// <summary>
  2471. ///
  2472. /// </summary>
  2473. /// <param name="da"></param>
  2474. /// <param name="conn"></param>
  2475. private void setupLandAccessCommands(SqliteDataAdapter da, SqliteConnection conn)
  2476. {
  2477. da.InsertCommand = createInsertCommand("landaccesslist", ds.Tables["landaccesslist"]);
  2478. da.InsertCommand.Connection = conn;
  2479. da.UpdateCommand = createUpdateCommand("landaccesslist", "LandUUID=:landUUID", "AccessUUID=:AccessUUID", ds.Tables["landaccesslist"]);
  2480. da.UpdateCommand.Connection = conn;
  2481. SqliteCommand delete = new SqliteCommand("delete from landaccesslist where LandUUID= :LandUUID and AccessUUID= :AccessUUID");
  2482. delete.Parameters.Add(createSqliteParameter("LandUUID", typeof(String)));
  2483. delete.Parameters.Add(createSqliteParameter("AccessUUID", typeof(String)));
  2484. da.DeleteCommand = delete;
  2485. da.DeleteCommand.Connection = conn;
  2486. }
  2487. private void setupRegionSettingsCommands(SqliteDataAdapter da, SqliteConnection conn)
  2488. {
  2489. da.InsertCommand = createInsertCommand("regionsettings", ds.Tables["regionsettings"]);
  2490. da.InsertCommand.Connection = conn;
  2491. da.UpdateCommand = createUpdateCommand("regionsettings", "regionUUID=:regionUUID", ds.Tables["regionsettings"]);
  2492. da.UpdateCommand.Connection = conn;
  2493. }
  2494. /// <summary>
  2495. ///
  2496. /// </summary>
  2497. /// <param name="da"></param>
  2498. /// <param name="conn"></param>
  2499. private void setupRegionWindlightCommands(SqliteDataAdapter da, SqliteConnection conn)
  2500. {
  2501. da.InsertCommand = createInsertCommand("regionwindlight", ds.Tables["regionwindlight"]);
  2502. da.InsertCommand.Connection = conn;
  2503. da.UpdateCommand = createUpdateCommand("regionwindlight", "region_id=:region_id", ds.Tables["regionwindlight"]);
  2504. da.UpdateCommand.Connection = conn;
  2505. }
  2506. private void setupRegionEnvironmentCommands(SqliteDataAdapter da, SqliteConnection conn)
  2507. {
  2508. da.InsertCommand = createInsertCommand("regionenvironment", ds.Tables["regionenvironment"]);
  2509. da.InsertCommand.Connection = conn;
  2510. da.UpdateCommand = createUpdateCommand("regionenvironment", "region_id=:region_id", ds.Tables["regionenvironment"]);
  2511. da.UpdateCommand.Connection = conn;
  2512. }
  2513. private void setupRegionSpawnPointsCommands(SqliteDataAdapter da, SqliteConnection conn)
  2514. {
  2515. da.InsertCommand = createInsertCommand("spawn_points", ds.Tables["spawn_points"]);
  2516. da.InsertCommand.Connection = conn;
  2517. da.UpdateCommand = createUpdateCommand("spawn_points", "RegionID=:RegionID", ds.Tables["spawn_points"]);
  2518. da.UpdateCommand.Connection = conn;
  2519. }
  2520. /// <summary>
  2521. ///
  2522. /// </summary>
  2523. /// <param name="da"></param>
  2524. /// <param name="conn"></param>
  2525. private void setupShapeCommands(SqliteDataAdapter da, SqliteConnection conn)
  2526. {
  2527. da.InsertCommand = createInsertCommand("primshapes", ds.Tables["primshapes"]);
  2528. da.InsertCommand.Connection = conn;
  2529. da.UpdateCommand = createUpdateCommand("primshapes", "UUID=:UUID", ds.Tables["primshapes"]);
  2530. da.UpdateCommand.Connection = conn;
  2531. SqliteCommand delete = new SqliteCommand("delete from primshapes where UUID = :UUID");
  2532. delete.Parameters.Add(createSqliteParameter("UUID", typeof(String)));
  2533. delete.Connection = conn;
  2534. da.DeleteCommand = delete;
  2535. }
  2536. /***********************************************************************
  2537. *
  2538. * Type conversion functions
  2539. *
  2540. **********************************************************************/
  2541. /// <summary>
  2542. /// Type conversion function
  2543. /// </summary>
  2544. /// <param name="type"></param>
  2545. /// <returns></returns>
  2546. private static DbType dbtypeFromType(Type type)
  2547. {
  2548. if (type == typeof(String))
  2549. {
  2550. return DbType.String;
  2551. }
  2552. else if (type == typeof(Int32))
  2553. {
  2554. return DbType.Int32;
  2555. }
  2556. else if (type == typeof(Double))
  2557. {
  2558. return DbType.Double;
  2559. }
  2560. else if (type == typeof(Byte))
  2561. {
  2562. return DbType.Byte;
  2563. }
  2564. else if (type == typeof(Double))
  2565. {
  2566. return DbType.Double;
  2567. }
  2568. else if (type == typeof(Byte[]))
  2569. {
  2570. return DbType.Binary;
  2571. }
  2572. else
  2573. {
  2574. return DbType.String;
  2575. }
  2576. }
  2577. static void PrintDataSet(DataSet ds)
  2578. {
  2579. // Print out any name and extended properties.
  2580. Console.WriteLine("DataSet is named: {0}", ds.DataSetName);
  2581. foreach (System.Collections.DictionaryEntry de in ds.ExtendedProperties)
  2582. {
  2583. Console.WriteLine("Key = {0}, Value = {1}", de.Key, de.Value);
  2584. }
  2585. Console.WriteLine();
  2586. foreach (DataTable dt in ds.Tables)
  2587. {
  2588. Console.WriteLine("=> {0} Table:", dt.TableName);
  2589. // Print out the column names.
  2590. for (int curCol = 0; curCol < dt.Columns.Count; curCol++)
  2591. {
  2592. Console.Write(dt.Columns[curCol].ColumnName + "\t");
  2593. }
  2594. Console.WriteLine("\n----------------------------------");
  2595. // Print the DataTable.
  2596. for (int curRow = 0; curRow < dt.Rows.Count; curRow++)
  2597. {
  2598. for (int curCol = 0; curCol < dt.Columns.Count; curCol++)
  2599. {
  2600. Console.Write(dt.Rows[curRow][curCol].ToString() + "\t");
  2601. }
  2602. Console.WriteLine();
  2603. }
  2604. }
  2605. }
  2606. public void SaveExtra(UUID regionID, string name, string value)
  2607. {
  2608. }
  2609. public void RemoveExtra(UUID regionID, string name)
  2610. {
  2611. }
  2612. public Dictionary<string, string> GetExtra(UUID regionID)
  2613. {
  2614. return null;
  2615. }
  2616. }
  2617. }