aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r--OpenSim/Data/MySQL/MySQLAgentPreferencesData.cs73
-rw-r--r--OpenSim/Data/MySQL/Resources/AgentPrefs.migrations18
2 files changed, 91 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/MySQLAgentPreferencesData.cs b/OpenSim/Data/MySQL/MySQLAgentPreferencesData.cs
new file mode 100644
index 0000000..0ea2f64
--- /dev/null
+++ b/OpenSim/Data/MySQL/MySQLAgentPreferencesData.cs
@@ -0,0 +1,73 @@
1/*
2 * Copyright (C) 2015, Cinder Roxley <cinder@sdf.org>
3 *
4 * Permission is hereby granted, free of charge, to any person or organization
5 * obtaining a copy of the software and accompanying documentation covered by
6 * this license (the "Software") to use, reproduce, display, distribute,
7 * execute, and transmit the Software, and to prepare derivative works of the
8 * Software, and to permit third-parties to whom the Software is furnished to
9 * do so, all subject to the following:
10 *
11 * The copyright notices in the Software and this entire statement, including
12 * the above license grant, this restriction and the following disclaimer,
13 * must be included in all copies of the Software, in whole or in part, and
14 * all derivative works of the Software, unless such copies or derivative
15 * works are solely in the form of machine-executable object code generated by
16 * a source language processor.
17 *
18 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
19 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
20 * FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NON-INFRINGEMENT. IN NO EVENT
21 * SHALL THE COPYRIGHT HOLDERS OR ANYONE DISTRIBUTING THE SOFTWARE BE LIABLE
22 * FOR ANY DAMAGES OR OTHER LIABILITY, WHETHER IN CONTRACT, TORT OR OTHERWISE,
23 * ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
24 * DEALINGS IN THE SOFTWARE.
25 */
26
27using System;
28using System.Collections;
29using System.Collections.Generic;
30using System.Data;
31using OpenMetaverse;
32using OpenSim.Framework;
33using MySql.Data.MySqlClient;
34
35namespace OpenSim.Data.MySQL
36{
37 public class MySQLAgentPreferencesData : MySQLGenericTableHandler<AgentPreferencesData>, IAgentPreferencesData
38 {
39 public MySQLAgentPreferencesData(string connectionString, string realm)
40 : base(connectionString, realm, "AgentPrefs")
41 {
42 }
43
44 public AgentPreferencesData GetPrefs(UUID agentID)
45 {
46 AgentPreferencesData[] ret = Get("PrincipalID", agentID.ToString());
47
48 if (ret.Length == 0)
49 return null;
50
51 return ret[0];
52 }
53
54 public void StorePrefs(AgentPreferencesData data)
55 {
56 using (MySqlCommand cmd = new MySqlCommand())
57 {
58 cmd.CommandText = String.Format("replace into `{0}` (`PrincipalID`, `AccessPrefs`, `HoverHeight`, `Language`, `LanguageIsPublic`, `PermEveryone`, `PermGroup`, `PermNextOwner`) VALUES (?Principal, ?AP, ?HH, ?Lang, ?LIP, ?PE, ?PG, ?PNO)", m_Realm);
59 cmd.Parameters.AddWithValue("?Principal", data.PrincipalID.ToString());
60 cmd.Parameters.AddWithValue("?AP", data.AccessPrefs);
61 cmd.Parameters.AddWithValue("?HH", data.HoverHeight);
62 cmd.Parameters.AddWithValue("?Lang", data.Language);
63 cmd.Parameters.AddWithValue("?LIP", data.LanguageIsPublic);
64 cmd.Parameters.AddWithValue("?PE", data.PermEveryone);
65 cmd.Parameters.AddWithValue("?PG", data.PermGroup);
66 cmd.Parameters.AddWithValue("?PNO", data.PermNextOwner);
67
68 ExecuteNonQuery(cmd);
69 }
70 }
71 }
72}
73
diff --git a/OpenSim/Data/MySQL/Resources/AgentPrefs.migrations b/OpenSim/Data/MySQL/Resources/AgentPrefs.migrations
new file mode 100644
index 0000000..e496f72
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/AgentPrefs.migrations
@@ -0,0 +1,18 @@
1:VERSION 1 # -------------------------
2
3BEGIN;
4
5CREATE TABLE `AgentPrefs` (
6 `PrincipalID` CHAR(36) NOT NULL,
7 `AccessPrefs` CHAR(2) NOT NULL DEFAULT 'M',
8 `HoverHeight` DOUBLE(30, 27) NOT NULL DEFAULT 0,
9 `Language` CHAR(5) NOT NULL DEFAULT 'en-us',
10 `LanguageIsPublic` BOOLEAN NOT NULL DEFAULT 1,
11 `PermEveryone` INT(6) NOT NULL DEFAULT 0,
12 `PermGroup` INT(6) NOT NULL DEFAULT 0,
13 `PermNextOwner` INT(6) NOT NULL DEFAULT 532480,
14 UNIQUE KEY `PrincipalID` (`PrincipalID`),
15 PRIMARY KEY(`PrincipalID`)
16) ENGINE=InnoDB DEFAULT CHARSET=utf8;
17
18COMMIT;