diff options
authoryorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b>2008-07-08 12:33:05 +0000
committeryorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b>2008-07-08 12:33:05 +0000
commitb7f866432cc3a44e9c62d4ad081f62e3ca791d1c (patch)
parent0d177e5bfb3ffd531f8904d99758cbc171261cdb (diff)
Added primary key to threads_tags, added documentation, and mods can now hide DB entries
git-svn-id: svn:// 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
5 files changed, 71 insertions, 6 deletions
diff --git a/data/docs/5 b/data/docs/5
index 95d3bea2..9bef7f9f 100644
--- a/data/docs/5
+++ b/data/docs/5
@@ -60,9 +60,8 @@
If you say so here, another contributor is bound to finish it off.
-Misc documentation:<br />
-- Quoting sources in descriptions<br />
+ <i>TODO: Something about quoting sources in descriptions here</i>
diff --git a/data/docs/7 b/data/docs/7
index 8542d4e5..5eeb5019 100644
--- a/data/docs/7
+++ b/data/docs/7
@@ -18,7 +18,7 @@
- yeah, interesting...
+ <i>TODO...</i>
diff --git a/data/docs/9 b/data/docs/9
new file mode 100644
index 00000000..499787e9
--- /dev/null
+++ b/data/docs/9
@@ -0,0 +1,65 @@
+:TITLE:Discussion board
+ <i>todo...</i>
+ To make sure interested people can find your post, all threads have 'tags'
+ that define what the discussion is about. It's possible to add more than
+ one tag to a thread. The following tags can be used:
+ <dt>db</dt><dd>
+ VNDB Discussions. This is a general tag for threads not about any specific
+ entry in the database.
+ </dd><dt>v#</dt><dd>
+ For discussions about a particular visual novel. The tag <i>v17</i>, for example,
+ is used for all threads related to <a href="/v17">v17</a>.
+ </dd><dt>p#</dt><dd>
+ Same as <i>v#</i>, but for producers.
+ </dd><dt>u#</dt><dd>
+ The <i>u#</i> tag can be used to notify a user on this site about something
+ he/she must see or to discuss about an edit he/she has made. This is similar
+ to the 'private message' feature of most sites, except it's not 'private'...
+ </dd><dt>an</dt><dd>
+ Used for site announcements. Limited to moderators.
+ </dd>
+ The following codes can be used to format your message:
+ <dt>X# or X#.#</dt><dd>
+ A 'VNDBID', as we call them. These are numbers starting with a character (d, p, r, s, u or v),
+ and are optionally followed by a period and a second number. VNDBIDs will automatically be converted
+ into links to the page on the website. For example, typing 'v4.4' will result in '<a href="/v4.4">v4.4</a>'.
+ </dd><dt>URL</dt><dd>
+ Any URL (without the use of the [url]-tag, see below) will be converted into a link, similar to the
+ VNDBIDs. Example: '' will be formatted as '<a href="">link</a>'.
+ </dd><dt>[url]</dt><dd>
+ The classic BBCode [url]-tag. Can only be used in the form of <i>[url=link]link title[/url]</i>.<br />
+ E.g. '[url=/v]List of visual novels[/url] and [url=]some external website[/url]'
+ will be displayed as '<a href="/v">List of visual novels</a> and <a href="">some external website</a>'
+ </dd><dt>[spoiler]</dt><dd>
+ The [spoiler]-tag should be used to hide information that could spoil the enjoyment of playing the
+ visual novel for people who haven't done so yet.
+ </dd>
+ There is no [img]-tag and there won't likely ever be one, if you want to include
+ screenshots or other images, please upload them to an external hosting service
+ (e.g. <a href="" rel="nofollow">TinyPic</a>) and link to them
+ in your post.
diff --git a/lib/ b/lib/
index a4c0d9ec..abd46b62 100644
--- a/lib/
+++ b/lib/
@@ -34,7 +34,7 @@ our %VNDBopts = (
{map{$_,1}qw| hist |}, # 0 - visitor (not logged in)
{map{$_,1}qw| hist |}, # 1 - loser
{map{$_,1}qw| hist board edit |}, # 2 - user
- {map{$_,1}qw| hist board boardmod edit mod lock |}, # 3 - mod
+ {map{$_,1}qw| hist board boardmod edit mod lock del |}, # 3 - mod
{map{$_,1}qw| hist board boardmod edit mod lock del userlist useredit |}, # 4 - admin
postsperpage => 25,
diff --git a/util/updates/update_1.19.sql b/util/updates/update_1.19.sql
index 225cddfb..a28b525a 100644
--- a/util/updates/update_1.19.sql
+++ b/util/updates/update_1.19.sql
@@ -12,7 +12,8 @@ CREATE TABLE threads (
CREATE TABLE threads_tags (
type char(2) NOT NULL DEFAULT 0,
- iid integer NOT NULL DEFAULT 0 -- references to (vn|releases|producers|users).id
+ iid integer NOT NULL DEFAULT 0, -- references to (vn|releases|producers|users).id
+ PRIMARY KEY(tid, type, iid)
CREATE TABLE threads_posts (