summaryrefslogtreecommitdiff
path: root/lib/VNDB/Handler/VNEdit.pm
AgeCommit message (Collapse)AuthorFilesLines
2011-02-04Don't save uploaded image to a temporary location before checksYorhel1-37/+19
This takes less code and may (or may not) be more efficient since it does not require any HDD I/O while performing some checks.
2011-02-03TUWF: Replaced reqParam() with reqGet() or reqPost() where applicableYorhel1-2/+2
Cleaner this way. Also found two occurences of manually HTML-escaping text for textareas, which isn't necessary anymore.
2011-01-27TUWF: Added tag name to several end() callsYorhel1-2/+2
Haven't found any bugs this way, yet. I doubt there'll be any problems, but it's a nice new feature that could help quite a bit. :-D
2011-01-25TUWF: Initial convert from YAWF to TUWFYorhel1-29/+30
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.
2010-12-17Check for editsum = description and give an easier to understand errorYorhel1-1/+3
The check is quite basic and you can easily get around it. It's just intended to warn about common mistakes.
2010-11-11Handler::VNEdit: Fixed bug with reverse relation update of "official"Yorhel1-1/+1
The official flag of untouched relations wasn't properly copied from the old revision.
2010-11-11Bugfix: reverting a VN image now worksYorhel1-2/+5
This is a very old bug. Never fixed it before because I couldn't think of a clean/easy solution and it wasn't important to waste my time on.
2010-11-10Started on adding an "official" flag to vn<->vn relationsYorhel1-9/+11
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-06Fixed cross-site request forgery vulnerabilitiesYorhel1-0/+1
2010-11-03Automatically remove duplicate aliases on /v+/editYorhel1-3/+12
And clean up the alias field before it gets inserted into the DB. Does not provide any feedback to the user, let's just hope our users are clever enough to figure out what happened.
2010-10-31Added more comparison VNs for the length fieldYorhel1-1/+1
2010-10-31Display friendly message in the VN edit scr tab when no release is knownYorhel1-2/+4
2010-02-06Handler::VNEdit: Removed useless line breakYorhel1-1/+1
The layout looks better without that.
2010-01-24Versioned the deleting and locking of database entriesYorhel1-2/+7
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 changes.id = (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-01SQL: Made a start on revision insertion abstractionYorhel1-17/+7
This will make it easier to do automated edits, either from cron jobs, Multi, update scripts, or from within SQL triggers. So far only the VN related functions have been defined/updated, trying to edit/add releases or producers will not work at the moment. The functions for editing or adding a new database entry have been merged, as the procedure is rather similar. util/dump.sql will be updated later on.
2009-12-28JS: Various fixes in the screenshot uploaderYorhel1-1/+3
Some browser compatibility stuff and some stupid bugs.
2009-12-05SQL: Removed changes.causedbyYorhel1-8/+7
This column was used to differentiate between automated edits and user edits, but that later changed to checking for changes.requester = 1. The column has since never really been used, and due to a bug introduced in VNDB 2.0, it has never been updated, either. Meaning it's not even accurate for any database changes made after december 2008...
2009-12-05Merged db[VN|Producer|Release][Edit|Add] into dbItemEdit and dbItemAddYorhel1-3/+3
And also changed the way the item_table.latest column was updated: it is now only updated after the revision insert has completed, making it easier to write trigger functions in SQL.
2009-10-07L10N: Extracted VN screenshot uploaderYorhel1-2/+1
2009-10-07L10N: Extracted VN relation editorYorhel1-4/+3
2009-10-05JS: Moved, split and rewrote release <-> VN & producer linkingYorhel1-1/+1
+ removed last traces of forms.js + converted code to use tables, as that is easier to expand more accurate for this purpose. The reason I probably didn't use tables before was that the innerHTML property doesn't work on tr elements. The split was mainly because the producer linking is going to be expanded with an additional field later on.
2009-10-04JS: Moved and rewrote VN relations editorYorhel1-10/+10
+ Some fixes and improvements in the dropdown search + Renamed 'relations' field to 'vnrelations', as other relations are going to be implemented as well New relation editor code is somewhat smaller than the old, mostly thanks to the tag() function. Also tried to make things less error-prone and easier to maintain by referencing things using self-explainable class names instead of the ordering of the HTML tags.
2009-09-26Converted VN relations to ENUM data type and made them translatableYorhel1-8/+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-25Handler::VNEdit: Fixed l_vnn = NULL bug when adding a VNYorhel1-1/+1
2009-09-13Removed visual-novels.net link from the interfaceYorhel1-2/+1
As they would soon be dead links, anyway.
2009-09-12Added reminders to write English to several form fieldsYorhel1-1/+1
2009-09-10L10N: Extracted VN lenghtsYorhel1-2/+2
2009-09-05L10N: Converted Handler::VNBrowse and Handler::VNEditYorhel1-47/+29
2009-08-18htmlForm(): Don't generate subform id from the titleYorhel1-4/+4
The subform id is now passed to htmlForm() as first formpart item. This way the id won't change even if the title does, which will be the case with the interface translation.
2009-08-17L10N: Converted htmlEditMessage, htmlItemMessage and htmlSearchBoxYorhel1-2/+3
This finishes Util::CommonHTML, with the exception of htmlVoteStats
2009-08-16Allow empty VN descriptionsYorhel1-1/+1
2009-08-08Removed last traces of the category systemYorhel1-4/+3
2009-08-05Removed last traces of the shared memory processing queueYorhel1-6/+0
Everything has now finally been converted to use the PgSQL LISTEN/NOTIFY feature. This commit removes the last Tie::ShareLite dependency.
2009-07-19Notify Multi::Image via PostgreSQL for new screenshotsYorhel1-1/+0
This finished the rewrite of Multi::Image and everything surrounding it.
2009-07-18Notify Multi::Image for new cover images via LISTEN/NOTIFYYorhel1-2/+1
Yay! Another weird shared-memory-command optimized away. And the image resizer reacts a lot faster now. Noticably, even.
2009-07-18Use PostgreSQL's LISTEN/NOTIFY to notify Multi::Anime for new animeYorhel1-1/+0
The notify is called from a trigger function, which is called on any UPDATE or INSERT INTO query of which the lastfetch column is NULL. This guarantees that anime info in the DB will always be updated, no matter how its inserted.
2009-07-05Updated VN screenshot uploader to handle multilanguage releasesYorhel1-1/+1
2009-05-31Don't give a 500 when inputting the same anime ID twice on /v+/editYorhel1-3/+3
2009-03-21Partly removed the category systemYorhel1-29/+1
The categories are still available for viewing and editing to aid in the transition to the tagging system, but editing has been removed.
2008-12-20Fix perl warning when adding a new VN with VN relationsYorhel1-1/+1
2008-12-09Code cleanup: removed leading spaces and combined ↵Yorhel1-2/+2
DB/{Votes,VNList,WishList}.pm into ULists.pm
2008-12-04Added noindex tag on pages I don't want to see indexedYorhel1-1/+1
Including anything related to editing, item histories, etc. No need to have those pages in google, is there?
2008-11-29VN add bugfixYorhel1-1/+1
2008-11-29Added interface to upload and modify the screenshotsYorhel1-9/+85
Interface and code are mostly the same as the 1.x version, but with some tiny improvements.
2008-11-29Screenshots can be edited through a textboxYorhel1-17/+20
...but not yet uploaded, and we'll need a more userfriendly interface
2008-11-28Renamed the image upload form to avoid scrolling down when opening the image tabYorhel1-4/+4
2008-11-28VN image upload worksYorhel1-7/+63
2008-11-26Javascript VN search for the relation editorYorhel1-3/+3
The dropdown search (ds* functions) is pretty generic, and could be used for other things as well.
2008-11-23Adding VN relations using the new interface worksYorhel1-3/+28
By specifying an ID, we still need a JS-powered search >.>
2008-11-23Started on user interface for the relationsYorhel1-1/+30
Viewing, changing and deleting relations already works, adding not yet.