diff options
author | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-07-08 12:33:05 +0000 |
---|---|---|
committer | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-07-08 12:33:05 +0000 |
commit | b7f866432cc3a44e9c62d4ad081f62e3ca791d1c (patch) | |
tree | 887ffe53a21019448be0dd197c3c9d01d4194396 | |
parent | 0d177e5bfb3ffd531f8904d99758cbc171261cdb (diff) |
Added primary key to threads_tags, added documentation, and mods can now hide DB entries
git-svn-id: svn://vndb.org/vndb@60 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
-rw-r--r-- | data/docs/5 | 5 | ||||
-rw-r--r-- | data/docs/7 | 2 | ||||
-rw-r--r-- | data/docs/9 | 65 | ||||
-rw-r--r-- | lib/global.pl | 2 | ||||
-rw-r--r-- | util/updates/update_1.19.sql | 3 |
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. </p> -:SUB:TODO +:SUB:Descriptions <p> -Misc documentation:<br /> -- Quoting sources in descriptions<br /> + <i>TODO: Something about quoting sources in descriptions here</i> </p> 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 @@ :SUB:History <p> - yeah, interesting... + <i>TODO...</i> </p> 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 +:INC:notfinished +:INC:index + + +:SUB:Introduction +<p> + <i>todo...</i> +</p> + + +:SUB:Tags +<p> + 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: +</p> +<dl> + <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> +</dl> + + +:SUB:Formatting +<p> + The following codes can be used to format your message: +</p> +<dl> + <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: 'http://vndb.org/' will be formatted as '<a href="http://vndb.org/">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=http://blicky.net/]some external website[/url]' + will be displayed as '<a href="/v">List of visual novels</a> and <a href="http://blicky.net/">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> +</dl> +<p> + 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="http://tinypic.com/" rel="nofollow">TinyPic</a>) and link to them + in your post. +</p> + + diff --git a/lib/global.pl b/lib/global.pl index a4c0d9ec..abd46b62 100644 --- a/lib/global.pl +++ b/lib/global.pl @@ -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 ( tid integer NOT NULL DEFAULT 0 REFERENCES threads (id) DEFERRABLE INITIALLY DEFERRED, 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) ) WITHOUT OIDS; CREATE TABLE threads_posts ( |