aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorp0wer <none@none>2010-02-23 21:09:55 -0600
committerp0wer <none@none>2010-02-23 21:09:55 -0600
commit98b72c52994b4b0f31a2b135850f87f59c523411 (patch)
tree39c5f8575c90fe77b9f381629bdc89ce56454024 /sql
parent50e878acba2a92d8193cfcef3dceadf16c370a9d (diff)
Through DB you can now disable password changing by non-gm's simply by changing m_public to 0. Make channels public by default.
--HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/7417_characters_channels.sql1
-rw-r--r--sql/updates/7417_world_trinity_string.sql1
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/7417_characters_channels.sql b/sql/updates/7417_characters_channels.sql
new file mode 100644
index 00000000000..f61a810da18
--- /dev/null
+++ b/sql/updates/7417_characters_channels.sql
@@ -0,0 +1 @@
+ALTER TABLE channels ADD COLUMN m_public tinyint(1) NOT NULL DEFAULT 1 AFTER m_moderate; \ No newline at end of file
diff --git a/sql/updates/7417_world_trinity_string.sql b/sql/updates/7417_world_trinity_string.sql
new file mode 100644
index 00000000000..105be373309
--- /dev/null
+++ b/sql/updates/7417_world_trinity_string.sql
@@ -0,0 +1 @@
+INSERT INTO trinity_string (entry, content_default) VALUES (5022, "Channel password not changed due to channel being marked public. GM Powers required."); \ No newline at end of file