path: root/Makefile
AgeCommit message (Collapse)AuthorFilesLines
2017-11-25Remove broken SQL functions from Makefile + add install instructionsYorhel1-109/+3
2017-07-17Makefile: Ensure static/f directory existsYorhel1-7/+7
Fixes a 'make' on a clean checkout
2016-01-23L10N: Remove all remaining traces of the interface translation featureYorhel1-7/+1
...unless I missed something.
2016-01-17L10N: Intern all Javascript strings and rename main JS fileYorhel1-5/+5
This has been mostly automated.
2015-10-21SQL: Fix editing + func.sql + triggers.sql + autocreate editing funcsYorhel1-2/+5
This changes quite a bit to the way the editing functions work. Because these functions are very repetitive and it's easy to keep things out of sync, I created a script to generate them automatically. I had to rename a few function and table names for consistency to make this work. Since database entries don't have a 'latest' column anymore, and since the order in which tables are updated doesn't have to be fixed, I dropped many of the SQL triggers and replaced them with a edit_committed() function which is called from edit_*_commit() and checks for stuff to be done. Don't forget to run 'make' before importing the update script.
2015-08-10Split script.js into multiple smaller filesYorhel1-1/+1
First part of a Javascript cleanup.
2015-05-11Generate icons.png and associated CSS automaticallyYorhel1-24/+38
It became a bit of a hassle to keep updating that file manually in Gimp. This script performs surprisingly well for our set of icons.
2013-09-14Makefile: Fix dependency of 'make skins'Yorhel1-1/+1
If you don't have any style.css files yet, make won't know what files to create. It does with this shell pattern.
2013-01-05Move api/tags.json.gz to the main domainYorhel1-2/+2
I forgot that the static domain is only intended for files that are never modified. Or at least, not without a URL change. The tags.json.gz doesn't fit into that.
2013-01-04Added daily-generated JSON dump of the tag informationYorhel1-2/+2
This isn't documented yet.
2012-06-04Makefile: Fix typo in sql-import targetYorhel1-1/+1
2012-01-09Added language for UkrainianYorhel1-0/+4
And added an update_2.23.sql file which now also includes the previously added indices. Currently, this update file can be run as often as you want, it doesn't make any noticable changes when you run it on a database that has already been updated. (i.e. I can update the main site without a new release)
2011-12-29Maintain VN search cache for hidden entries as wellYorhel1-1/+6
Required in order to search for hidden entries (obviously :P)
2011-08-22Added new platforms: Android, Web and DB-PGYorhel1-1/+6
+ Fixed makefile I haven't been able to properly test this yet as a bug[1] in PostgreSQL 9.0.4 is preventing me from editing release entries. [1]
2011-04-08Generate dbedit/dbdel notifications on character editsYorhel1-1/+7
2011-02-16chardb: Added image to character entriesYorhel1-3/+3
2011-02-13chardb: Added notes file and started implementing the traitsYorhel1-1/+7
2011-02-04Added category field to tags (content/ero/technical)Yorhel1-2/+7
Not very useful at the moment, but will be used to improve several other things.
2011-01-25TUWF: Initial convert from YAWF to TUWFYorhel1-1/+1
There may still be some bugs present and I've only converted the points where TUWF is incompatible with YAWF. The new TUWF features are not in use yet, I'll do that later on. Note that, in order to run the new code, TUWF must be installed on your system. The configuration for the TransAdmin plugin has also changed. Other than that there shouldn't be any issues.
2011-01-03SQL: Added tags_vn.ignore column and updated queries to respect thisYorhel1-1/+6
This is the first step in adding support for overruling tag votes by moderators. Also removed some unused options from dbTagStats(); the tag-vote-stats-by-user pages have been removed in the previous VNDB update, which was the only page using these additional options.
2010-12-17Don't allow NULL for rr.minage and use -1 for unknownYorhel1-1/+6
This can be seen as a partial revert of 0a4f97f0186d6941a4cab2e3bd05201f1fed1441. I used to think using NULL for special values is more "correct" in database terms. But in the end I guess I should be aiming for whatever solution is easier. Both are "correct" in a sense anyway.
2010-12-14VNDBUtil: Consider "senpai" and "sempai" the same in the VN searchYorhel1-0/+4
2010-11-28ChangeLog update for 2.14 + some minor upgrade fixesYorhel1-1/+1
2010-11-25JS: Split script.js into a separate file for each languageYorhel1-5/+6
This greatly reduces the size of the Javascript file. The compressed size has been reduced with about 9kB, and is now a total of 14kB for en.js. A nice property of this is that more translations can be added without increasing the JS size. While I was at it, I made also replace mt() function calls in cases where an exact TL string was requested without any additional arguments and/or formatting codes. This helped reduce the compressed size by about 1kB. My aim is to keep *all* the JS code of VNDB smaller than the jQuery core library, as a general "fuck you" towards users of large and bloated JS libraries. We must keep the VNDB page loading times lower than that of other sites, after all!
2010-11-24Makefile: Reverted back to a single .PHONY targetYorhel1-17/+20
Apparently the trick didn't work, and for some reason I only noticed that now.
2010-11-14Makefile: Replaced .PHONY directive with $(phony ..) targetsYorhel1-25/+18
This is somewhat eaiser to read and maintain
2010-11-14SQL: Added WHEN clause to all TRIGGERs for which it was usefulYorhel1-0/+3
This effectively removes compatibility with all PostgreSQL versions below 9.0. The use of the WHEN clause has two major advantages: 1. Performance: Trigger functions aren't executed when they don't need to. 2. Easier and more general trigger functions; as some of the logic has been placed in the trigger definitions now.
2010-11-13Multi::Feed: Added Atom feedsYorhel1-3/+5
TODO: add links to these feeds from the site
2010-11-10Started on adding an "official" flag to vn<->vn relationsYorhel1-1/+7
This is the first part. The flag is stored in the database, can be edited through the usual VN edit form, and is displayed in the diff viewer. Things to do to make this feature fully functional: - display "official" status on VN page at the relation listing - update relation graphs to display unofficial relations differently - update guidelines
2010-11-02Removed XML sitemapYorhel1-0/+1
Was growing too large and isn't really necessary anymore, now that VNDB is indexed quite well in most search engines.
2010-03-13Improved VN searchYorhel1-1/+5
This adds a new column to the vn table: c_search, which holds the normalized titles for speedy search results using LIKE. Also split some functions from VNDB::Func that didn't require YAWF into a VNDBUtil module, so Multi can also make use of them. The normalization functions are the same for Multi and VNDB, after all. The API and Multi::IRC still use the old search, these should be updated as well.
2010-01-24Versioned the deleting and locking of database entriesYorhel1-5/+9
This is implemented by adding ihid (item hidden) and ilock (item locked) columns to the changes table, The (vn|release|producer).(hidden|locked) columns now work as a cache, refering to the changes.(ihid|ilock) columns with = (vn|release|producer).latest. The cached columns are updated automatically each time a new revision is inserted. This is a pretty large change, bugs are quite likely.
2010-01-09SQL: Split dump.sql into several files and merged update_2.10.sqlYorhel1-2/+2
The functions can now be edited without having to repeat them in the update scripts. Just importing the func.sql file with \i will do the trick.
2009-12-06Added simple SQL manipulation and upgrade functionality to the MakefileYorhel1-11/+48
This makes it possible to do (mostly) automated updates, and makes sure I don't forget to update something, as usual. Of course, this update functionality is not fool-proof, and in no way subsistutes for manually checking what an update requires. It simply does the things that a basic script can do without relying on a specific configuration.
2009-11-02Makefile: Added rules for controlling MultiYorhel1-1/+31
This will come in handy when writing update rules.
2009-11-02Replaced util/ with a MakefileYorhel1-0/+72
I'm planning to add some more stuff to this makefile later, like starting/stopping Multi and performing updates.