/* * Copyright (c) OpenSim project, http://sim.opensecondlife.org/ * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright * notice, this list of conditions and the following disclaimer. * * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * * Neither the name of the <organization> nor the * names of its contributors may be used to endorse or promote products * derived from this software without specific prior written permission. * * THIS SOFTWARE IS PROVIDED BY <copyright holder> ``AS IS'' AND ANY * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE * DISCLAIMED. IN NO EVENT SHALL <copyright holder> BE LIABLE FOR ANY * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. * */ // SQLite Support // A bad idea, but the IRC people told me to! using System; using System.Collections.Generic; using System.Data; using System.Data.SQLite; using libsecondlife; using OpenSim.Framework.Interfaces; using OpenSim.Framework.Types; using OpenSim.Framework.Terrain; namespace OpenSim.Storage.LocalStorageSQLite { public class SQLiteLocalStorage : ILocalStorage { IDbConnection db; public SQLiteLocalStorage() { try { string connectionstring = "URI=file:localsim.sdb"; db = (IDbConnection)new SQLiteConnection(connectionstring); db.Open(); } catch (Exception e) { db.Close(); OpenSim.Framework.Console.MainConsole.Instance.WriteLine(OpenSim.Framework.Console.LogPriority.MEDIUM,"SQLiteLocalStorage :Constructor - Exception occured"); OpenSim.Framework.Console.MainConsole.Instance.WriteLine(OpenSim.Framework.Console.LogPriority.MEDIUM,e.ToString()); } } public void Initialise(string file) { // Blank } public void StorePrim(PrimData prim) { IDbCommand cmd = db.CreateCommand(); //SECURITY WARNING: // These parameters wont produce SQL injections since they are all integer based, however. // if inserting strings such as name or description, you will need to use appropriate // measures to prevent SQL injection (although the value of SQL injection in this is limited). string sql = "REPLACE INTO prim (OwnerID,PCode,PathBegin,PathEnd,PathScaleX,PathScaleY,PathShearX,PathShearY,PathSkew,ProfileBegin,ProfileEnd,Scale,PathCurve,ProfileCurve,ParentID,ProfileHollow,PathRadiusOffset,PathRevolutions,PathTaperX,PathTaperY,PathTwist,PathTwistBegin,Texture,CreationDate,OwnerMask,NextOwnerMask,GroupMask,EveryoneMask,BaseMask,Position,Rotation,LocalID,FullID) "; sql += "VALUES ("; sql += "\"" + prim.OwnerID.ToStringHyphenated() + "\","; // KILL ME NOW! sql += "\"" + prim.PCode.ToString() + "\","; sql += "\"" + prim.PathBegin.ToString() + "\","; sql += "\"" + prim.PathEnd.ToString() + "\","; sql += "\"" + prim.PathScaleX.ToString() + "\","; sql += "\"" + prim.PathScaleY.ToString() + "\","; sql += "\"" + prim.PathShearX.ToString() + "\","; sql += "\"" + prim.PathShearY.ToString() + "\","; sql += "\"" + prim.PathSkew.ToString() + "\","; sql += "\"" + prim.ProfileBegin.ToString() + "\","; sql += "\"" + prim.ProfileEnd.ToString() + "\","; sql += "\"" + prim.Scale.ToString() + "\","; sql += "\"" + prim.PathCurve.ToString() + "\","; sql += "\"" + prim.ProfileCurve.ToString() + "\","; sql += "\"" + prim.ParentID.ToString() + "\","; sql += "\"" + prim.ProfileHollow.ToString() + "\","; sql += "\"" + prim.PathRadiusOffset.ToString() + "\","; sql += "\"" + prim.PathRevolutions.ToString() + "\","; sql += "\"" + prim.PathTaperX.ToString() + "\","; sql += "\"" + prim.PathTaperY.ToString() + "\","; sql += "\"" + prim.PathTwist.ToString() + "\","; sql += "\"" + prim.PathTwistBegin.ToString() + "\","; sql += "\"" + prim.Texture.ToString() + "\","; sql += "\"" + prim.CreationDate.ToString() + "\","; sql += "\"" + prim.OwnerMask.ToString() + "\","; sql += "\"" + prim.NextOwnerMask.ToString() + "\","; sql += "\"" + prim.GroupMask.ToString() + "\","; sql += "\"" + prim.EveryoneMask.ToString() + "\","; sql += "\"" + prim.BaseMask.ToString() + "\","; sql += "\"" + prim.Position.ToString() + "\","; sql += "\"" + prim.Rotation.ToString() + "\","; sql += "\"" + prim.LocalID.ToString() + "\","; sql += "\"" + prim.FullID.ToString() + "\")"; cmd.CommandText = sql; try { cmd.ExecuteNonQuery(); } catch (Exception e) { OpenSim.Framework.Console.MainConsole.Instance.WriteLine(OpenSim.Framework.Console.LogPriority.MEDIUM,"SQLiteLocalStorage :StorePrim - Exception occured"); OpenSim.Framework.Console.MainConsole.Instance.WriteLine(OpenSim.Framework.Console.LogPriority.MEDIUM,e.ToString()); } cmd.Dispose(); cmd = null; } public void RemovePrim(LLUUID primID) { IDbCommand cmd = db.CreateCommand(); //SECURITY WARNING: // These parameters wont produce SQL injections since they are all integer based, however. // if inserting strings such as name or description, you will need to use appropriate // measures to prevent SQL injection (although the value of SQL injection in this is limited). string sql = "DELETE FROM prim WHERE FullID = \"" + primID.ToStringHyphenated() + "\""; cmd.CommandText = sql; try { cmd.ExecuteNonQuery(); } catch (Exception e) { OpenSim.Framework.Console.MainConsole.Instance.WriteLine(OpenSim.Framework.Console.LogPriority.MEDIUM,"SQLiteLocalStorage :RemovePrim - Exception occured"); OpenSim.Framework.Console.MainConsole.Instance.WriteLine(OpenSim.Framework.Console.LogPriority.MEDIUM,e.ToString()); } cmd.Dispose(); cmd = null; } public void LoadPrimitives(ILocalStorageReceiver receiver) { } public float[] LoadWorld() { return new float[65536]; } public void SaveMap(float[] heightmap) { } public void ShutDown() { db.Close(); db = null; } } }