summaryrefslogtreecommitdiff
path: root/lib/Multi/RG.pm
AgeCommit message (Collapse)AuthorFilesLines
2017-03-26Multi::RG: Fix inverse check for non-official relationsYorhel1-1/+1
2017-03-26Multi::RG: Remove unofficial relations from graph if #vns > 30Yorhel1-9/+27
This makes the relation graphs useful again for several large (mostly) independent graphs that are sometimes linked together by unofficial relations. e.g. https://vndb.org/t8985
2016-01-17Use Tie::IxHash for some global.pl listsYorhel1-6/+6
This removes the reliance on sort() to provide meaningful ordering (the keys aren't always good for ordering) and removes the 'order' hack used for (vn|prod)_relations.
2016-01-17L10N: Intern VN/producer relations + update relation graphsYorhel1-10/+13
Now that graphviz knows the actual strings, it has a better opportunity to create better graphs. (Most of them still look messy tho)
2015-11-01Switch to HTML5 doctype + s/acronym/abbr/ + s/ / /eYorhel1-5/+3
I'd have preferred to stick with XHTML 1.0, but unfortunately browsers won't allow you to use modern Javascript APIs with an older doctype. Note that most pages don't actually validate correctly as HTML5, I'm relying on browsers to be lenient. In either case, I'd like VNDB to stay valid XML (XHTML5, then), and luckily that shouldn't be a problem.
2015-10-21SQL: Fix Multi to use the new DB schemaYorhel1-6/+6
That should be the last thing to convert to the new schema.
2014-10-22Multi::RG: Converted to use AnyEventYorhel1-191/+189
AnyEvent::Util::run_cmd() is a godsent. POE was such a hassle in that area.
2011-01-27Multi::RG: Use TUWF::XML instead of XML::WriterYorhel1-8/+5
This removes the last dependency on XML::Writer.
2010-11-10Multi::RG: Use dotted line to indicate unofficial status in VN relationsYorhel1-15/+16
Also fixed a minor bug with no change notification being sent to Multi when only the official flag has been changed.
2010-02-02SQL: Converted language columns to an ENUM typeYorhel1-2/+2
And changed vn.c_languages to an array type while I was at it. This required some changes in the Perl code, and I found a bug in DBD::Pg while I was at it: https://rt.cpan.org/Ticket/Display.html?id=54224 Luckily, there's an easy workaround for that.
2009-12-28Highlight opened VN/producer in relation graphsYorhel1-5/+6
The warnbg and warnborder colors from the skins are used for highlighting.
2009-10-24Multi::RG: Minor log format changeYorhel1-1/+1
Better aligned, easier to read.
2009-10-21Added relation graphs for producersYorhel1-76/+141
TODO: - document the relations - emit a relgraph notify when needed
2009-10-21SQL: Renamed vn_graphs to relgraphs and synced dbgraph.plYorhel1-1/+1
As the same table can easily be used to store producer relation graphs as well.
2009-09-27Multi::RG: Removed unused variableYorhel1-1/+0
2009-09-26Display full release dates in relation graphsYorhel1-1/+6
Interface consistency
2009-09-26Converted VN relations to ENUM data type and made them translatableYorhel1-15/+7
OK, these are actually two separate things: to make the relations translatable they didn't necessarily have to be stored as enum, and I could've also converted them to enum but not have it translatable. Nevertheless, it was easier to just do both at the same time. Also note how I used the string "$____vnrel_<rel>____$" as identifier in the relation graphs while I could have used something a lot shorter ("$<rel>$" would have been fine, for example). This is done so that graphviz can make some space for those relations - the long identifier gives a slightly more realistic representation of the actual length of the relation titles.
2009-09-25Use inline SVG for relation graphsYorhel1-31/+60
The graphs are now stored in the DB in SVG format, the static/rg/ directory can be removed (not used anymore). SVG data is stored using the xml data type, so now I can say for sure you'd need at least PostgreSQL 8.3. This feature still needs some tweaking, though. Current state isn't perfect.
2009-07-23Remove session aliases in shutdown handlerYorhel1-0/+1
This isn't really necessary when shutting down the entire process, but it is for the individual session to shut down. This will make it possible to load/unload/reload Multi modules on demand without restarting the process.
2009-07-23Implemented relgraph notify from PgSQL triggerYorhel1-0/+2
This finishes the new relation graph generator, as it'll now regenerate graphs as soon as is needed. This obsletes the VNDB::Util::Misc::vnCacheUpdate() function, this functionality is provided by triggers within PostgreSQL. The update_vncache(0) procedure is now significantly slower due to the trigger on the vn table. It'd be a good idea to rewrite this procedure by using triggers and conditional updates, to drastically lower the number of rows that need to be updated.
2009-07-19Rewrote Multi::RGYorhel1-129/+88
It should be a bit more efficient and non-blocking. Also a lot less verbose with logging.
2008-11-21Updated relation graph generator with new coloursYorhel1-7/+8
...these colours look horrible on light skins, need to find a solution to that >.>
2008-08-20Converted relation graphs to PNGyorhel1-3/+3
git-svn-id: svn://vndb.org/vndb@101 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-18Found a definite and proper solution to fix the command synchronisation ↵yorhel1-1/+0
problems, fixed display of wrong ID for screenshot diff, and increased screenshot JPEG quality to 90 git-svn-id: svn://vndb.org/vndb@95 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-18Stored relgraph image maps in the DB, instead of using plain text files in ↵yorhel1-14/+7
/data/rg/ git-svn-id: svn://vndb.org/vndb@93 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-15Converted smallints used as boolean to PostgreSQL's relatively new (8.1) ↵1.21yorhel1-1/+1
boolean type. git-svn-id: svn://vndb.org/vndb@90 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-06-06Got rid of GraphViz.pm (which is like using CGI.pm to generate HTML), and ↵yorhel1-82/+53
fixed some XHTML validation problems git-svn-id: svn://vndb.org/vndb@21 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-06-05Improvements in the relation graph generator, and a little cleanup in the ↵yorhel1-29/+92
Multi code git-svn-id: svn://vndb.org/vndb@20 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-05-19Too many changes to keep track of. See ChangeLog. (I should commit more ↵yorhel1-1/+1
often -.-) git-svn-id: svn://vndb.org/vndb@13 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-05-01Another batch of changes... see the ChangeLog!yorhel1-2/+2
git-svn-id: svn://vndb.org/vndb@10 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-04-26Changed the 50 dirs for static content to 100, and a version bumpyorhel1-2/+2
git-svn-id: svn://vndb.org/vndb@6 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-04-26Stupid comments - like I can keep track of everything I change...yorhel1-0/+3
git-svn-id: svn://vndb.org/vndb@5 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-04-24See the diff for lib/ChangeLog...yorhel1-0/+248
git-svn-id: svn://vndb.org/vndb@4 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b