summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-08-15 14:41:13 +0200
committerYorhel <git@yorhel.nl>2009-08-15 14:41:13 +0200
commitb18be0094764d3afb2ba6f57a5b747ad103b4c1f (patch)
tree0836d69784e0980ae704d51d445903c740728522
parente6bccf922dac29e6307f8dea6319230e67859cff (diff)
Improved VN relations
-rw-r--r--ChangeLog5
-rw-r--r--data/docs/218
-rw-r--r--data/global.pl9
-rw-r--r--util/updates/update_2.7.sql12
4 files changed, 28 insertions, 16 deletions
diff --git a/ChangeLog b/ChangeLog
index 23ee92f7..60e6b7c3 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -3,6 +3,11 @@ git - ?
- Blacklist a users' votes from the VN vote statistics
- usermods can browse a users' votes and list even when they are hidden
- More sensible placing of the submit button on /v+/tagmod
+ - Improved VN relations:
+ - Removed: summary, full story
+ - Added: same series, fandisc, original game
+ - Renamed: same characters to shares characters
+ - Merged: alternative setting into alternative version, and other into same series
2.6 - 2009-08-09
- New screen resolutions: 1024x600 and 1600x1200
diff --git a/data/docs/2 b/data/docs/2
index 2f7095df..77a66169 100644
--- a/data/docs/2
+++ b/data/docs/2
@@ -127,24 +127,20 @@
The definition of "setting" is not always easy to define, but usually it
means that if places or items not existing in the real world described in one
game also exist in the other game, you could use this relation.
- </dd><dt>Alternative setting</dt><dd>
- Same characters and (mostly) the same story, but set in a different universe,
- world, reality or timeline.
</dd><dt>Alternative version</dt><dd>
Same setting, same characters, but the story is told differently.
- </dd><dt>Same characters</dt><dd>
+ </dd><dt>Shares characters</dt><dd>
Different story, but shares some characters.
</dd><dt>Side story</dt><dd>
The story takes place sometime during the parent storyline. &lt;=&gt;<i>Parent story</i>
</dd><dt>Parent story</dt><dd>
Opposite of <i>Side story</i>.
- </dd><dt>Summary</dt><dd>
- Summarizes full story, may contain additional stuff. &lt;=&gt;<i>Full story</i>.
- </dd><dt>Full story</dt><dd>
- Full version of the summarized story. &lt;=&gt;<i>Summary</i>.
- </dd><dt>Other</dt><dd>
- There is a relation, but it's not possible to describe it using the other available
- options. This is a relation that should rarely be used.
+ </dd><dt>Same series</dt><dd>
+ The games are part of the same series.
+ </dd><dt>Fandisc</dt><dd>
+ <a href="http://en.wikipedia.org/wiki/Fan_disc">Fandisc</a>.
+ </dd><dt>Original game</dt><dd>
+ The opposite of fandisc.
</dd>
</dl>
diff --git a/data/global.pl b/data/global.pl
index 673c3777..8cf42b7c 100644
--- a/data/global.pl
+++ b/data/global.pl
@@ -90,14 +90,13 @@ our %S = (%S,
[ 'Sequel', 0 ],
[ 'Prequel', 1 ],
[ 'Same setting', 0 ],
- [ 'Alternative setting', 0 ],
[ 'Alternative version', 0 ],
- [ 'Same characters', 0 ],
+ [ 'Shares characters', 0 ],
[ 'Side story', 0 ],
[ 'Parent story', 1 ],
- [ 'Summary', 0 ],
- [ 'Full story', 1 ],
- [ 'Other', 0 ],
+ [ 'Same series', 0 ],
+ [ 'Fandisc', 0 ],
+ [ 'Original game', 1 ],
],
age_ratings => {
-1 => [ 'Unknown' ],
diff --git a/util/updates/update_2.7.sql b/util/updates/update_2.7.sql
index 1feea9be..ff9b175e 100644
--- a/util/updates/update_2.7.sql
+++ b/util/updates/update_2.7.sql
@@ -19,3 +19,15 @@ BEGIN
END;
$$ LANGUAGE plpgsql;
+
+
+-- VN relations cleanup
+
+UPDATE vn_relations SET relation = relation + 50 WHERE relation IN(8, 9, 10);
+UPDATE vn_relations SET relation = relation - 1 WHERE relation > 3 AND relation < 50;
+UPDATE vn_relations SET relation = 7 WHERE relation = 60;
+DELETE FROM vn_relations WHERE relation > 50;
+
+-- Be sure to execute the following query after restarting Multi, to regenerate the relation graphs:
+-- UPDATE vn SET rgraph = NULL;
+