From 328883700a15e4216bf7b251ac099d38f413375e Mon Sep 17 00:00:00 2001
From: BlueWall
Date: Mon, 13 May 2013 22:11:28 -0400
Subject: UserProfiles
UserProfiles for Robust and Standalone. Includes service and connectors for Robust and standalone opensim plus matching region module.
---
OpenSim/Data/IProfilesData.cs | 29 +
OpenSim/Data/MySQL/MySQLUserProfilesData.cs | 1023 ++++++++++++++++++++
.../Data/MySQL/Resources/UserProfiles.migrations | 83 ++
3 files changed, 1135 insertions(+)
create mode 100644 OpenSim/Data/IProfilesData.cs
create mode 100644 OpenSim/Data/MySQL/MySQLUserProfilesData.cs
create mode 100644 OpenSim/Data/MySQL/Resources/UserProfiles.migrations
(limited to 'OpenSim/Data')
diff --git a/OpenSim/Data/IProfilesData.cs b/OpenSim/Data/IProfilesData.cs
new file mode 100644
index 0000000..eeccbf6
--- /dev/null
+++ b/OpenSim/Data/IProfilesData.cs
@@ -0,0 +1,29 @@
+using System;
+using OpenMetaverse;
+using OpenMetaverse.StructuredData;
+using OpenSim.Framework;
+
+namespace OpenSim.Data
+{
+
+ public interface IProfilesData
+ {
+ OSDArray GetClassifiedRecords(UUID creatorId);
+ bool UpdateClassifiedRecord(UserClassifiedAdd ad, ref string result);
+ bool DeleteClassifiedRecord(UUID recordId);
+ OSDArray GetAvatarPicks(UUID avatarId);
+ UserProfilePick GetPickInfo(UUID avatarId, UUID pickId);
+ bool UpdatePicksRecord(UserProfilePick pick);
+ bool DeletePicksRecord(UUID pickId);
+ bool GetAvatarNotes(ref UserProfileNotes note);
+ bool UpdateAvatarNotes(ref UserProfileNotes note, ref string result);
+ bool GetAvatarProperties(ref UserProfileProperties props, ref string result);
+ bool UpdateAvatarProperties(ref UserProfileProperties props, ref string result);
+ bool UpdateAvatarInterests(UserProfileProperties up, ref string result);
+ bool GetClassifiedInfo(ref UserClassifiedAdd ad, ref string result);
+ bool GetUserAppData(ref UserAppData props, ref string result);
+ bool SetUserAppData(UserAppData props, ref string result);
+ OSDArray GetUserImageAssets(UUID avatarId);
+ }
+}
+
diff --git a/OpenSim/Data/MySQL/MySQLUserProfilesData.cs b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
new file mode 100644
index 0000000..09bd448
--- /dev/null
+++ b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
@@ -0,0 +1,1023 @@
+using System;
+using System.Data;
+using System.Reflection;
+using OpenSim.Data;
+using OpenSim.Framework;
+using MySql.Data.MySqlClient;
+using OpenMetaverse;
+using OpenMetaverse.StructuredData;
+using log4net;
+
+namespace OpenSim.Data.MySQL
+{
+ public class UserProfilesData: IProfilesData
+ {
+ static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType);
+
+ #region Properites
+ string ConnectionString
+ {
+ get; set;
+ }
+
+ protected object Lock
+ {
+ get; set;
+ }
+
+ protected virtual Assembly Assembly
+ {
+ get { return GetType().Assembly; }
+ }
+
+ #endregion Properties
+
+ #region class Member Functions
+ public UserProfilesData(string connectionString)
+ {
+ ConnectionString = connectionString;
+ Init();
+ }
+
+ void Init()
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+
+ Migration m = new Migration(dbcon, Assembly, "UserProfiles");
+ m.Update();
+ }
+ }
+ #endregion Member Functions
+
+ #region Classifieds Queries
+ ///
+ /// Gets the classified records.
+ ///
+ ///
+ /// Array of classified records
+ ///
+ ///
+ /// Creator identifier.
+ ///
+ public OSDArray GetClassifiedRecords(UUID creatorId)
+ {
+ OSDArray data = new OSDArray();
+
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ string query = "SELECT classifieduuid, name FROM classifieds WHERE creatoruuid = ?Id";
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?Id", creatorId);
+ using( MySqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default))
+ {
+ if(reader.HasRows)
+ {
+ while (reader.Read())
+ {
+ OSDMap n = new OSDMap();
+ UUID Id = UUID.Zero;
+
+ string Name = null;
+ try
+ {
+ UUID.TryParse(Convert.ToString( reader["classifieduuid"]), out Id);
+ Name = Convert.ToString(reader["name"]);
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": UserAccount exception {0}", e.Message);
+ }
+ n.Add("classifieduuid", OSD.FromUUID(Id));
+ n.Add("name", OSD.FromString(Name));
+ data.Add(n);
+ }
+ }
+ }
+ }
+ }
+ return data;
+ }
+
+ public bool UpdateClassifiedRecord(UserClassifiedAdd ad, ref string result)
+ {
+ string query = string.Empty;
+
+
+ query += "INSERT INTO classifieds (";
+ query += "`classifieduuid`,";
+ query += "`creatoruuid`,";
+ query += "`creationdate`,";
+ query += "`expirationdate`,";
+ query += "`category`,";
+ query += "`name`,";
+ query += "`description`,";
+ query += "`parceluuid`,";
+ query += "`parentestate`,";
+ query += "`snapshotuuid`,";
+ query += "`simname`,";
+ query += "`posglobal`,";
+ query += "`parcelname`,";
+ query += "`classifiedflags`,";
+ query += "`priceforlisting`) ";
+ query += "VALUES (";
+ query += "?ClassifiedId,";
+ query += "?CreatorId,";
+ query += "?CreatedDate,";
+ query += "?ExpirationDate,";
+ query += "?Category,";
+ query += "?Name,";
+ query += "?Description,";
+ query += "?ParcelId,";
+ query += "?ParentEstate,";
+ query += "?SnapshotId,";
+ query += "?SimName,";
+ query += "?GlobalPos,";
+ query += "?ParcelName,";
+ query += "?Flags,";
+ query += "?ListingPrice ) ";
+ query += "ON DUPLICATE KEY UPDATE ";
+ query += "category=?Category, ";
+ query += "expirationdate=?ExpirationDate, ";
+ query += "name=?Name, ";
+ query += "description=?Description, ";
+ query += "parentestate=?ParentEstate, ";
+ query += "posglobal=?GlobalPos, ";
+ query += "parcelname=?ParcelName, ";
+ query += "classifiedflags=?Flags, ";
+ query += "priceforlisting=?ListingPrice, ";
+ query += "snapshotuuid=?SnapshotId";
+
+ if(string.IsNullOrEmpty(ad.ParcelName))
+ ad.ParcelName = "Unknown";
+ if(ad.ParcelId == null)
+ ad.ParcelId = UUID.Zero;
+ if(string.IsNullOrEmpty(ad.Description))
+ ad.Description = "No Description";
+
+ DateTime epoch = new DateTime(1970, 1, 1);
+ DateTime now = DateTime.Now;
+ TimeSpan epochnow = now - epoch;
+ TimeSpan duration;
+ DateTime expiration;
+ TimeSpan epochexp;
+
+ if(ad.Flags == 2)
+ {
+ duration = new TimeSpan(7,0,0,0);
+ expiration = now.Add(duration);
+ epochexp = expiration - epoch;
+ }
+ else
+ {
+ duration = new TimeSpan(365,0,0,0);
+ expiration = now.Add(duration);
+ epochexp = expiration - epoch;
+ }
+ ad.CreationDate = (int)epochnow.TotalSeconds;
+ ad.ExpirationDate = (int)epochexp.TotalSeconds;
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?ClassifiedId", ad.ClassifiedId.ToString());
+ cmd.Parameters.AddWithValue("?CreatorId", ad.CreatorId.ToString());
+ cmd.Parameters.AddWithValue("?CreatedDate", ad.CreationDate.ToString());
+ cmd.Parameters.AddWithValue("?ExpirationDate", ad.ExpirationDate.ToString());
+ cmd.Parameters.AddWithValue("?Category", ad.Category.ToString());
+ cmd.Parameters.AddWithValue("?Name", ad.Name.ToString());
+ cmd.Parameters.AddWithValue("?Description", ad.Description.ToString());
+ cmd.Parameters.AddWithValue("?ParcelId", ad.ParcelId.ToString());
+ cmd.Parameters.AddWithValue("?ParentEstate", ad.ParentEstate.ToString());
+ cmd.Parameters.AddWithValue("?SnapshotId", ad.SnapshotId.ToString ());
+ cmd.Parameters.AddWithValue("?SimName", ad.SimName.ToString());
+ cmd.Parameters.AddWithValue("?GlobalPos", ad.GlobalPos.ToString());
+ cmd.Parameters.AddWithValue("?ParcelName", ad.ParcelName.ToString());
+ cmd.Parameters.AddWithValue("?Flags", ad.Flags.ToString());
+ cmd.Parameters.AddWithValue("?ListingPrice", ad.Price.ToString ());
+
+ cmd.ExecuteNonQuery();
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": ClassifiedesUpdate exception {0}", e.Message);
+ result = e.Message;
+ return false;
+ }
+ return true;
+ }
+
+ public bool DeleteClassifiedRecord(UUID recordId)
+ {
+ string query = string.Empty;
+
+ query += "DELETE FROM classifieds WHERE ";
+ query += "classifieduuid = ?ClasifiedId";
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?ClassifiedId", recordId.ToString());
+
+ lock(Lock)
+ {
+ cmd.ExecuteNonQuery();
+ }
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": DeleteClassifiedRecord exception {0}", e.Message);
+ return false;
+ }
+ return true;
+ }
+
+ public bool GetClassifiedInfo(ref UserClassifiedAdd ad, ref string result)
+ {
+ string query = string.Empty;
+
+ query += "SELECT * FROM classifieds WHERE ";
+ query += "classifieduuid = ?AdId";
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?AdId", ad.ClassifiedId.ToString());
+
+ using (MySqlDataReader reader = cmd.ExecuteReader())
+ {
+ if(reader.Read ())
+ {
+ ad.CreatorId = new UUID(reader.GetGuid("creatoruuid"));
+ ad.ParcelId = new UUID(reader.GetGuid("parceluuid"));
+ ad.SnapshotId = new UUID(reader.GetGuid("snapshotuuid"));
+ ad.CreationDate = Convert.ToInt32(reader["creationdate"]);
+ ad.ExpirationDate = Convert.ToInt32(reader["expirationdate"]);
+ ad.ParentEstate = Convert.ToInt32(reader["parentestate"]);
+ ad.Flags = (byte)reader.GetUInt32("classifiedflags");
+ ad.Category = reader.GetInt32("category");
+ ad.Price = reader.GetInt16("priceforlisting");
+ ad.Name = reader.GetString("name");
+ ad.Description = reader.GetString("description");
+ ad.SimName = reader.GetString("simname");
+ ad.GlobalPos = reader.GetString("posglobal");
+ ad.ParcelName = reader.GetString("parcelname");
+
+ }
+ }
+ }
+ dbcon.Close();
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": GetPickInfo exception {0}", e.Message);
+ }
+ return true;
+ }
+ #endregion Classifieds Queries
+
+ #region Picks Queries
+ public OSDArray GetAvatarPicks(UUID avatarId)
+ {
+ string query = string.Empty;
+
+ query += "SELECT `pickuuid`,`name` FROM userpicks WHERE ";
+ query += "creatoruuid = ?Id";
+ OSDArray data = new OSDArray();
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?Id", avatarId.ToString());
+
+ using (MySqlDataReader reader = cmd.ExecuteReader())
+ {
+ if(reader.HasRows)
+ {
+ while (reader.Read())
+ {
+ OSDMap record = new OSDMap();
+
+ record.Add("pickuuid",OSD.FromString((string)reader["pickuuid"]));
+ record.Add("name",OSD.FromString((string)reader["name"]));
+ data.Add(record);
+ }
+ }
+ }
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": GetAvatarPicks exception {0}", e.Message);
+ }
+ return data;
+ }
+
+ public UserProfilePick GetPickInfo(UUID avatarId, UUID pickId)
+ {
+ string query = string.Empty;
+ UserProfilePick pick = new UserProfilePick();
+
+ query += "SELECT * FROM userpicks WHERE ";
+ query += "creatoruuid = ?CreatorId AND ";
+ query += "pickuuid = ?PickId";
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?CreatorId", avatarId.ToString());
+ cmd.Parameters.AddWithValue("?PickId", pickId.ToString());
+
+ using (MySqlDataReader reader = cmd.ExecuteReader())
+ {
+ if(reader.HasRows)
+ {
+ reader.Read();
+
+ string description = (string)reader["description"];
+
+ if (string.IsNullOrEmpty(description))
+ description = "No description given.";
+
+ UUID.TryParse((string)reader["pickuuid"], out pick.PickId);
+ UUID.TryParse((string)reader["creatoruuid"], out pick.CreatorId);
+ UUID.TryParse((string)reader["parceluuid"], out pick.ParcelId);
+ UUID.TryParse((string)reader["snapshotuuid"], out pick.SnapshotId);
+ pick.GlobalPos = (string)reader["posglobal"];
+ bool.TryParse((string)reader["toppick"], out pick.TopPick);
+ bool.TryParse((string)reader["enabled"], out pick.Enabled);
+ pick.Name = (string)reader["name"];
+ pick.Desc = description;
+ pick.User = (string)reader["user"];
+ pick.OriginalName = (string)reader["originalname"];
+ pick.SimName = (string)reader["simname"];
+ pick.SortOrder = (int)reader["sortorder"];
+ }
+ }
+ }
+ dbcon.Close();
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": GetPickInfo exception {0}", e.Message);
+ }
+ return pick;
+ }
+
+ public bool UpdatePicksRecord(UserProfilePick pick)
+ {
+ string query = string.Empty;
+
+ query += "INSERT INTO userpicks VALUES (";
+ query += "?PickId,";
+ query += "?CreatorId,";
+ query += "?TopPick,";
+ query += "?ParcelId,";
+ query += "?Name,";
+ query += "?Desc,";
+ query += "?SnapshotId,";
+ query += "?User,";
+ query += "?Original,";
+ query += "?SimName,";
+ query += "?GlobalPos,";
+ query += "?SortOrder,";
+ query += "?Enabled) ";
+ query += "ON DUPLICATE KEY UPDATE ";
+ query += "parceluuid=?ParcelId,";
+ query += "name=?Name,";
+ query += "description=?Desc,";
+ query += "snapshotuuid=?SnapshotId,";
+ query += "pickuuid=?PickId,";
+ query += "posglobal=?GlobalPos";
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?PickId", pick.PickId.ToString());
+ cmd.Parameters.AddWithValue("?CreatorId", pick.CreatorId.ToString());
+ cmd.Parameters.AddWithValue("?TopPick", pick.TopPick.ToString());
+ cmd.Parameters.AddWithValue("?ParcelId", pick.ParcelId.ToString());
+ cmd.Parameters.AddWithValue("?Name", pick.Name.ToString());
+ cmd.Parameters.AddWithValue("?Desc", pick.Desc.ToString());
+ cmd.Parameters.AddWithValue("?SnapshotId", pick.SnapshotId.ToString());
+ cmd.Parameters.AddWithValue("?User", pick.User.ToString());
+ cmd.Parameters.AddWithValue("?Original", pick.OriginalName.ToString());
+ cmd.Parameters.AddWithValue("?SimName",pick.SimName.ToString());
+ cmd.Parameters.AddWithValue("?GlobalPos", pick.GlobalPos);
+ cmd.Parameters.AddWithValue("?SortOrder", pick.SortOrder.ToString ());
+ cmd.Parameters.AddWithValue("?Enabled", pick.Enabled.ToString());
+
+ cmd.ExecuteNonQuery();
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": UpdateAvatarNotes exception {0}", e.Message);
+ return false;
+ }
+ return true;
+ }
+
+ public bool DeletePicksRecord(UUID pickId)
+ {
+ string query = string.Empty;
+
+ query += "DELETE FROM userpicks WHERE ";
+ query += "pickuuid = ?PickId";
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?PickId", pickId.ToString());
+
+ cmd.ExecuteNonQuery();
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": DeleteUserPickRecord exception {0}", e.Message);
+ return false;
+ }
+ return true;
+ }
+ #endregion Picks Queries
+
+ #region Avatar Notes Queries
+ public bool GetAvatarNotes(ref UserProfileNotes notes)
+ { // WIP
+ string query = string.Empty;
+
+ query += "SELECT `notes` FROM usernotes WHERE ";
+ query += "useruuid = ?Id AND ";
+ query += "targetuuid = ?TargetId";
+ OSDArray data = new OSDArray();
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?Id", notes.UserId.ToString());
+ cmd.Parameters.AddWithValue("?TargetId", notes.TargetId.ToString());
+
+ using (MySqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow))
+ {
+ if(reader.HasRows)
+ {
+ reader.Read();
+ notes.Notes = OSD.FromString((string)reader["notes"]);
+ }
+ }
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": GetAvatarNotes exception {0}", e.Message);
+ }
+ return true;
+ }
+
+ public bool UpdateAvatarNotes(ref UserProfileNotes note, ref string result)
+ {
+ string query = string.Empty;
+ bool remove;
+
+ if(string.IsNullOrEmpty(note.Notes))
+ {
+ remove = true;
+ query += "DELETE FROM usernotes WHERE ";
+ query += "useruuid=?UserId AND ";
+ query += "targetuuid=?TargetId";
+ }
+ else
+ {
+ remove = false;
+ query += "INSERT INTO usernotes VALUES ( ";
+ query += "?UserId,";
+ query += "?TargetId,";
+ query += "?Notes )";
+ query += "ON DUPLICATE KEY ";
+ query += "UPDATE ";
+ query += "notes=?Notes";
+ }
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ if(!remove)
+ cmd.Parameters.AddWithValue("?Notes", note.Notes);
+ cmd.Parameters.AddWithValue("?TargetId", note.TargetId.ToString ());
+ cmd.Parameters.AddWithValue("?UserId", note.UserId.ToString());
+
+ cmd.ExecuteNonQuery();
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": UpdateAvatarNotes exception {0}", e.Message);
+ return false;
+ }
+ return true;
+
+ }
+ #endregion Avatar Notes Queries
+
+ #region Avatar Properties
+ public bool GetAvatarProperties(ref UserProfileProperties props, ref string result)
+ {
+ string query = string.Empty;
+
+ query += "SELECT * FROM userprofile WHERE ";
+ query += "useruuid = ?Id";
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?Id", props.UserId.ToString());
+
+ using (MySqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow))
+ {
+ if(reader.HasRows)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": Getting data for {0}.", props.UserId);
+ reader.Read();
+ props.WebUrl = (string)reader["profileURL"];
+ UUID.TryParse((string)reader["profileImage"], out props.ImageId);
+ props.AboutText = (string)reader["profileAboutText"];
+ UUID.TryParse((string)reader["profileFirstImage"], out props.FirstLifeImageId);
+ props.FirstLifeText = (string)reader["profileFirstText"];
+ UUID.TryParse((string)reader["profilePartner"], out props.PartnerId);
+ props.WantToMask = (int)reader["profileWantToMask"];
+ props.WantToText = (string)reader["profileWantToText"];
+ props.SkillsMask = (int)reader["profileSkillsMask"];
+ props.SkillsText = (string)reader["profileSkillsText"];
+ props.Language = (string)reader["profileLanguages"];
+ }
+ else
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": No data for {0}", props.UserId);
+
+ props.WebUrl = string.Empty;
+ props.ImageId = UUID.Zero;
+ props.AboutText = string.Empty;
+ props.FirstLifeImageId = UUID.Zero;
+ props.FirstLifeText = string.Empty;
+ props.PartnerId = UUID.Zero;
+ props.WantToMask = 0;
+ props.WantToText = string.Empty;
+ props.SkillsMask = 0;
+ props.SkillsText = string.Empty;
+ props.Language = string.Empty;
+
+ query = "INSERT INTO userprofile (`useruuid`) VALUES (?userId)";
+
+ dbcon.Close();
+ dbcon.Open();
+
+ using (MySqlCommand put = new MySqlCommand(query, dbcon))
+ {
+ put.Parameters.AddWithValue("?userId", props.UserId.ToString());
+ put.ExecuteNonQuery();
+ }
+ }
+ }
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": Requst properties exception {0}", e.Message);
+ result = e.Message;
+ return false;
+ }
+ return true;
+ }
+
+ public bool UpdateAvatarProperties(ref UserProfileProperties props, ref string result)
+ {
+ string query = string.Empty;
+
+ query += "UPDATE userprofile SET ";
+ query += "profileURL=?profileURL, ";
+ query += "profileImage=?image, ";
+ query += "profileAboutText=?abouttext,";
+ query += "profileFirstImage=?firstlifeimage,";
+ query += "profileFirstText=?firstlifetext ";
+ query += "WHERE useruuid=?uuid";
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?profileURL", props.WebUrl);
+ cmd.Parameters.AddWithValue("?image", props.ImageId.ToString());
+ cmd.Parameters.AddWithValue("?abouttext", props.AboutText);
+ cmd.Parameters.AddWithValue("?firstlifeimage", props.FirstLifeImageId.ToString());
+ cmd.Parameters.AddWithValue("?firstlifetext", props.FirstLifeText);
+ cmd.Parameters.AddWithValue("?uuid", props.UserId.ToString());
+
+ cmd.ExecuteNonQuery();
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": AgentPropertiesUpdate exception {0}", e.Message);
+
+ return false;
+ }
+ return true;
+ }
+ #endregion Avatar Properties
+
+ #region Avatar Interests
+ public bool UpdateAvatarInterests(UserProfileProperties up, ref string result)
+ {
+ string query = string.Empty;
+
+ query += "UPDATE userprofile SET ";
+ query += "profileWantToMask=?WantMask, ";
+ query += "profileWantToText=?WantText,";
+ query += "profileSkillsMask=?SkillsMask,";
+ query += "profileSkillsText=?SkillsText, ";
+ query += "profileLanguages=?Languages ";
+ query += "WHERE useruuid=?uuid";
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?WantMask", up.WantToMask);
+ cmd.Parameters.AddWithValue("?WantText", up.WantToText);
+ cmd.Parameters.AddWithValue("?SkillsMask", up.SkillsMask);
+ cmd.Parameters.AddWithValue("?SkillsText", up.SkillsText);
+ cmd.Parameters.AddWithValue("?Languages", up.Language);
+ cmd.Parameters.AddWithValue("?uuid", up.UserId.ToString());
+
+ cmd.ExecuteNonQuery();
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": AgentInterestsUpdate exception {0}", e.Message);
+ result = e.Message;
+ return false;
+ }
+ return true;
+ }
+ #endregion Avatar Interests
+
+ public OSDArray GetUserImageAssets(UUID avatarId)
+ {
+ OSDArray data = new OSDArray();
+ string query = "SELECT `snapshotuuid` FROM {0} WHERE `creatoruuid` = ?Id";
+
+ // Get classified image assets
+
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+
+ using (MySqlCommand cmd = new MySqlCommand(string.Format (query,"`classifieds`"), dbcon))
+ {
+ cmd.Parameters.AddWithValue("?Id", avatarId.ToString());
+
+ using (MySqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow))
+ {
+ if(reader.HasRows)
+ {
+ while (reader.Read())
+ {
+ data.Add(new OSDString((string)reader["snapshotuuid"].ToString ()));
+ }
+ }
+ }
+ }
+
+ dbcon.Close();
+ dbcon.Open();
+
+ using (MySqlCommand cmd = new MySqlCommand(string.Format (query,"`userpicks`"), dbcon))
+ {
+ cmd.Parameters.AddWithValue("?Id", avatarId.ToString());
+
+ using (MySqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow))
+ {
+ if(reader.HasRows)
+ {
+ while (reader.Read())
+ {
+ data.Add(new OSDString((string)reader["snapshotuuid"].ToString ()));
+ }
+ }
+ }
+ }
+
+ dbcon.Close();
+ dbcon.Open();
+
+ query = "SELECT `profileImage`, `profileFirstImage` FROM `userprofile` WHERE `useruuid` = ?Id";
+
+ using (MySqlCommand cmd = new MySqlCommand(string.Format (query,"`userpicks`"), dbcon))
+ {
+ cmd.Parameters.AddWithValue("?Id", avatarId.ToString());
+
+ using (MySqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow))
+ {
+ if(reader.HasRows)
+ {
+ while (reader.Read())
+ {
+ data.Add(new OSDString((string)reader["profileImage"].ToString ()));
+ data.Add(new OSDString((string)reader["profileFirstImage"].ToString ()));
+ }
+ }
+ }
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": GetAvatarNotes exception {0}", e.Message);
+ }
+ return data;
+ }
+
+ #region User Preferences
+ public OSDArray GetUserPreferences(UUID avatarId)
+ {
+ string query = string.Empty;
+
+ query += "SELECT imviaemail,visible,email FROM ";
+ query += "usersettings WHERE ";
+ query += "useruuid = ?Id";
+
+ OSDArray data = new OSDArray();
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?Id", avatarId.ToString());
+
+ using (MySqlDataReader reader = cmd.ExecuteReader())
+ {
+ if(reader.HasRows)
+ {
+ reader.Read();
+ OSDMap record = new OSDMap();
+
+ record.Add("imviaemail",OSD.FromString((string)reader["imviaemail"]));
+ record.Add("visible",OSD.FromString((string)reader["visible"]));
+ record.Add("email",OSD.FromString((string)reader["email"]));
+ data.Add(record);
+ }
+ else
+ {
+ using (MySqlCommand put = new MySqlCommand(query, dbcon))
+ {
+ query = "INSERT INTO usersettings VALUES ";
+ query += "(?Id,'false','false', '')";
+
+ lock(Lock)
+ {
+ put.ExecuteNonQuery();
+ }
+ }
+ }
+ }
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": Get preferences exception {0}", e.Message);
+ }
+ return data;
+ }
+
+ public bool UpdateUserPreferences(bool emailIm, bool visible, UUID avatarId )
+ {
+ string query = string.Empty;
+
+ query += "UPDATE userpsettings SET ";
+ query += "imviaemail=?ImViaEmail, ";
+ query += "visible=?Visible,";
+ query += "WHERE useruuid=?uuid";
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?ImViaEmail", emailIm.ToString().ToLower ());
+ cmd.Parameters.AddWithValue("?WantText", visible.ToString().ToLower ());
+ cmd.Parameters.AddWithValue("?uuid", avatarId.ToString());
+
+ lock(Lock)
+ {
+ cmd.ExecuteNonQuery();
+ }
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": AgentInterestsUpdate exception {0}", e.Message);
+ return false;
+ }
+ return true;
+ }
+ #endregion User Preferences
+
+ #region Integration
+ public bool GetUserAppData(ref UserAppData props, ref string result)
+ {
+ string query = string.Empty;
+
+ query += "SELECT * FROM `userdata` WHERE ";
+ query += "UserId = ?Id AND ";
+ query += "TagId = ?TagId";
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?Id", props.UserId.ToString());
+ cmd.Parameters.AddWithValue ("?TagId", props.TagId.ToString());
+
+ using (MySqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow))
+ {
+ if(reader.HasRows)
+ {
+ reader.Read();
+ props.DataKey = (string)reader["DataKey"];
+ props.DataVal = (string)reader["DataVal"];
+ }
+ else
+ {
+ query += "INSERT INTO userdata VALUES ( ";
+ query += "?UserId,";
+ query += "?TagId,";
+ query += "?DataKey,";
+ query += "?DataVal) ";
+
+ using (MySqlCommand put = new MySqlCommand(query, dbcon))
+ {
+ put.Parameters.AddWithValue("?Id", props.UserId.ToString());
+ put.Parameters.AddWithValue("?TagId", props.TagId.ToString());
+ put.Parameters.AddWithValue("?DataKey", props.DataKey.ToString());
+ put.Parameters.AddWithValue("?DataVal", props.DataVal.ToString());
+
+ lock(Lock)
+ {
+ put.ExecuteNonQuery();
+ }
+ }
+ }
+ }
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": Requst application data exception {0}", e.Message);
+ result = e.Message;
+ return false;
+ }
+ return true;
+ }
+
+ public bool SetUserAppData(UserAppData props, ref string result)
+ {
+ string query = string.Empty;
+
+ query += "UPDATE userdata SET ";
+ query += "TagId = ?TagId, ";
+ query += "DataKey = ?DataKey, ";
+ query += "DataVal = ?DataVal WHERE ";
+ query += "UserId = ?UserId AND ";
+ query += "TagId = ?TagId";
+
+ try
+ {
+ using (MySqlConnection dbcon = new MySqlConnection(ConnectionString))
+ {
+ dbcon.Open();
+ using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
+ {
+ cmd.Parameters.AddWithValue("?UserId", props.UserId.ToString());
+ cmd.Parameters.AddWithValue("?TagId", props.TagId.ToString ());
+ cmd.Parameters.AddWithValue("?DataKey", props.DataKey.ToString ());
+ cmd.Parameters.AddWithValue("?DataVal", props.DataKey.ToString ());
+
+ lock(Lock)
+ {
+ cmd.ExecuteNonQuery();
+ }
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ m_log.DebugFormat("[PROFILES_DATA]" +
+ ": SetUserData exception {0}", e.Message);
+ return false;
+ }
+ return true;
+ }
+ #endregion Integration
+ }
+}
+
diff --git a/OpenSim/Data/MySQL/Resources/UserProfiles.migrations b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations
new file mode 100644
index 0000000..c29f1ab
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations
@@ -0,0 +1,83 @@
+:VERSION 1 # -------------------------------
+
+begin;
+
+CREATE TABLE IF NOT EXISTS `classifieds` (
+ `classifieduuid` char(36) NOT NULL,
+ `creatoruuid` char(36) NOT NULL,
+ `creationdate` int(20) NOT NULL,
+ `expirationdate` int(20) NOT NULL,
+ `category` varchar(20) NOT NULL,
+ `name` varchar(255) NOT NULL,
+ `description` text NOT NULL,
+ `parceluuid` char(36) NOT NULL,
+ `parentestate` int(11) NOT NULL,
+ `snapshotuuid` char(36) NOT NULL,
+ `simname` varchar(255) NOT NULL,
+ `posglobal` varchar(255) NOT NULL,
+ `parcelname` varchar(255) NOT NULL,
+ `classifiedflags` int(8) NOT NULL,
+ `priceforlisting` int(5) NOT NULL,
+ PRIMARY KEY (`classifieduuid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+
+CREATE TABLE IF NOT EXISTS `usernotes` (
+ `useruuid` varchar(36) NOT NULL,
+ `targetuuid` varchar(36) NOT NULL,
+ `notes` text NOT NULL,
+ UNIQUE KEY `useruuid` (`useruuid`,`targetuuid`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+
+CREATE TABLE IF NOT EXISTS `userpicks` (
+ `pickuuid` varchar(36) NOT NULL,
+ `creatoruuid` varchar(36) NOT NULL,
+ `toppick` enum('true','false') NOT NULL,
+ `parceluuid` varchar(36) NOT NULL,
+ `name` varchar(255) NOT NULL,
+ `description` text NOT NULL,
+ `snapshotuuid` varchar(36) NOT NULL,
+ `user` varchar(255) NOT NULL,
+ `originalname` varchar(255) NOT NULL,
+ `simname` varchar(255) NOT NULL,
+ `posglobal` varchar(255) NOT NULL,
+ `sortorder` int(2) NOT NULL,
+ `enabled` enum('true','false') NOT NULL,
+ PRIMARY KEY (`pickuuid`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+
+CREATE TABLE IF NOT EXISTS `userprofile` (
+ `useruuid` varchar(36) NOT NULL,
+ `profilePartner` varchar(36) NOT NULL,
+ `profileAllowPublish` binary(1) NOT NULL,
+ `profileMaturePublish` binary(1) NOT NULL,
+ `profileURL` varchar(255) NOT NULL,
+ `profileWantToMask` int(3) NOT NULL,
+ `profileWantToText` text NOT NULL,
+ `profileSkillsMask` int(3) NOT NULL,
+ `profileSkillsText` text NOT NULL,
+ `profileLanguages` text NOT NULL,
+ `profileImage` varchar(36) NOT NULL,
+ `profileAboutText` text NOT NULL,
+ `profileFirstImage` varchar(36) NOT NULL,
+ `profileFirstText` text NOT NULL,
+ PRIMARY KEY (`useruuid`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+commit;
+
+:VERSION 2 # -------------------------------
+
+begin;
+CREATE TABLE IF NOT EXISTS `userdata` (
+ `UserId` char(36) NOT NULL,
+ `TagId` varchar(64) NOT NULL,
+ `DataKey` varchar(255),
+ `DataVal` varchar(255),
+ PRIMARY KEY (`UserId`,`TagId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+commit;
+
--
cgit v1.1
From bf035233232885b798a56a1687319ba167e4bf60 Mon Sep 17 00:00:00 2001
From: BlueWall
Date: Fri, 31 May 2013 10:40:47 -0400
Subject: Fill in fields with default values on profile creation
---
OpenSim/Data/MySQL/MySQLUserProfilesData.cs | 50 +++++++++++++++++++++++++++--
1 file changed, 48 insertions(+), 2 deletions(-)
(limited to 'OpenSim/Data')
diff --git a/OpenSim/Data/MySQL/MySQLUserProfilesData.cs b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
index 09bd448..5d7149b 100644
--- a/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
+++ b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
@@ -622,7 +622,7 @@ namespace OpenSim.Data.MySQL
{
m_log.DebugFormat("[PROFILES_DATA]" +
": No data for {0}", props.UserId);
-
+
props.WebUrl = string.Empty;
props.ImageId = UUID.Zero;
props.AboutText = string.Empty;
@@ -634,8 +634,38 @@ namespace OpenSim.Data.MySQL
props.SkillsMask = 0;
props.SkillsText = string.Empty;
props.Language = string.Empty;
+ props.PublishProfile = false;
+ props.PublishMature = false;
- query = "INSERT INTO userprofile (`useruuid`) VALUES (?userId)";
+ query = "INSERT INTO userprofile (";
+ query += "useruuid, ";
+ query += "profilePartner, ";
+ query += "profileAllowPublish, ";
+ query += "profileMaturePublish, ";
+ query += "profileURL, ";
+ query += "profileWantToMask, ";
+ query += "profileWantToText, ";
+ query += "profileSkillsMask, ";
+ query += "profileSkillsText, ";
+ query += "profileLanguages, ";
+ query += "profileImage, ";
+ query += "profileAboutText, ";
+ query += "profileFirstImage, ";
+ query += "profileFirstText) VALUES (";
+ query += "?userId, ";
+ query += "?profilePartner, ";
+ query += "?profileAllowPublish, ";
+ query += "?profileMaturePublish, ";
+ query += "?profileURL, ";
+ query += "?profileWantToMask, ";
+ query += "?profileWantToText, ";
+ query += "?profileSkillsMask, ";
+ query += "?profileSkillsText, ";
+ query += "?profileLanguages, ";
+ query += "?profileImage, ";
+ query += "?profileAboutText, ";
+ query += "?profileFirstImage, ";
+ query += "?profileFirstText)";
dbcon.Close();
dbcon.Open();
@@ -643,6 +673,20 @@ namespace OpenSim.Data.MySQL
using (MySqlCommand put = new MySqlCommand(query, dbcon))
{
put.Parameters.AddWithValue("?userId", props.UserId.ToString());
+ put.Parameters.AddWithValue("?profilePartner", props.PartnerId.ToString());
+ put.Parameters.AddWithValue("?profileAllowPublish", props.PublishProfile);
+ put.Parameters.AddWithValue("?profileMaturePublish", props.PublishMature);
+ put.Parameters.AddWithValue("?profileURL", props.WebUrl);
+ put.Parameters.AddWithValue("?profileWantToMask", props.WantToMask);
+ put.Parameters.AddWithValue("?profileWantToText", props.WantToText);
+ put.Parameters.AddWithValue("?profileSkillsMask", props.SkillsMask);
+ put.Parameters.AddWithValue("?profileSkillsText", props.SkillsText);
+ put.Parameters.AddWithValue("?profileLanguages", props.Language);
+ put.Parameters.AddWithValue("?profileImage", props.ImageId.ToString());
+ put.Parameters.AddWithValue("?profileAboutText", props.AboutText);
+ put.Parameters.AddWithValue("?profileFirstImage", props.FirstLifeImageId.ToString());
+ put.Parameters.AddWithValue("?profileFirstText", props.FirstLifeText);
+
put.ExecuteNonQuery();
}
}
@@ -665,6 +709,7 @@ namespace OpenSim.Data.MySQL
string query = string.Empty;
query += "UPDATE userprofile SET ";
+ query += "profilePartner=?profilePartner, ";
query += "profileURL=?profileURL, ";
query += "profileImage=?image, ";
query += "profileAboutText=?abouttext,";
@@ -680,6 +725,7 @@ namespace OpenSim.Data.MySQL
using (MySqlCommand cmd = new MySqlCommand(query, dbcon))
{
cmd.Parameters.AddWithValue("?profileURL", props.WebUrl);
+ cmd.Parameters.AddWithValue("?profilePartner", props.PartnerId.ToString());
cmd.Parameters.AddWithValue("?image", props.ImageId.ToString());
cmd.Parameters.AddWithValue("?abouttext", props.AboutText);
cmd.Parameters.AddWithValue("?firstlifeimage", props.FirstLifeImageId.ToString());
--
cgit v1.1
From d7fa9f671eefebd49c0e8f56e56088b0c0b3d93c Mon Sep 17 00:00:00 2001
From: BlueWall
Date: Fri, 31 May 2013 22:03:27 -0400
Subject: Adding standard OpenSim header to source files
---
OpenSim/Data/IProfilesData.cs | 27 +++++++++++++++++++++++++++
OpenSim/Data/MySQL/MySQLUserProfilesData.cs | 27 +++++++++++++++++++++++++++
2 files changed, 54 insertions(+)
(limited to 'OpenSim/Data')
diff --git a/OpenSim/Data/IProfilesData.cs b/OpenSim/Data/IProfilesData.cs
index eeccbf6..0de7f68 100644
--- a/OpenSim/Data/IProfilesData.cs
+++ b/OpenSim/Data/IProfilesData.cs
@@ -1,3 +1,30 @@
+/*
+ * Copyright (c) Contributors, http://opensimulator.org/
+ * See CONTRIBUTORS.TXT for a full list of copyright holders.
+ *
+ * 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 OpenSimulator Project 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 THE DEVELOPERS ``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 THE CONTRIBUTORS 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.
+ */
+
using System;
using OpenMetaverse;
using OpenMetaverse.StructuredData;
diff --git a/OpenSim/Data/MySQL/MySQLUserProfilesData.cs b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
index 5d7149b..4c6c8e3 100644
--- a/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
+++ b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
@@ -1,3 +1,30 @@
+/*
+ * Copyright (c) Contributors, http://opensimulator.org/
+ * See CONTRIBUTORS.TXT for a full list of copyright holders.
+ *
+ * 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 OpenSimulator Project 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 THE DEVELOPERS ``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 THE CONTRIBUTORS 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.
+ */
+
using System;
using System.Data;
using System.Reflection;
--
cgit v1.1