summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/Producers.pm
AgeCommit message (Collapse)AuthorFilesLines
2010-11-11Display releases grouped by VNs on producer pagesYorhel1-25/+1
A nice expanded view. It also happens to be faster than the old view in terms of SQL queries. (In most cases at least) Can be improved a little more by: - Adding an 'expand/collapse' feature to list only the VNs - Adding a column indicating the role of the producer (dev/pub)
2010-01-24Versioned the deleting and locking of database entriesYorhel1-1/+1
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: Revision insertion abstraction for producer entriesYorhel1-13/+12
2009-12-05Merged db[VN|Producer|Release][Edit|Add] into dbItemEdit and dbItemAddYorhel1-24/+6
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-11-14Added wikipedia links for producersYorhel1-3/+3
2009-10-21Added relation graphs for producersYorhel1-2/+4
TODO: - document the relations - emit a relgraph notify when needed
2009-10-21Started on the producer relationsYorhel1-3/+25
The current list of relations isn't final yet, may be changed later on. Quite a bit of this code has been copied from the VN relations... need to find a way to use prober code reuse here. TODO: - Nice relation editor interface - Display relations in revision browser - Display relations on producer pages - Generate relation graphs - Sync update_2.8.sql into dump.sql
2009-10-12SQL: Converted changes.type to an ENUMYorhel1-2/+2
This is a very important column in a very important table, I hope I didn't forget to update a piece of code somewhere...
2009-10-10Updated Producer and VN pages with developer/publisher informationYorhel1-1/+2
2009-08-09Converted changes.added to timestamptzYorhel1-1/+1
That was the last one. I hope I haven't forgotten to update anything.
2009-02-21Small performance improvements for dbReleaseGet()Yorhel1-1/+1
Using the same method as 203509ffd8fc2fbbd76129d701a6c20110f6050d
2009-02-21Small performance improvements: Don't always fetch all columns on ↵Yorhel1-1/+2
dbProducerGet() Added an 'extended' flag to the 'what' argument, which should be used if more columns are desired.
2009-02-21Aliases field to producer entriesYorhel1-4/+4
2009-01-10Don't show hidden release relations on producer pagesYorhel1-0/+1
17:00:20 <ImmLff> Can someone explain why p440 have relation to v198 without having a release? 17:00:20 <Multi> [p440] Team Free @ http://vndb.org/p440 17:00:20 <Multi> [v198] Princess Holiday @ http://vndb.org/v198 17:01:07 <applehq> it's deleted... 17:01:14 <Yorhel> oh my, a bug
2008-12-09Code cleanup: removed leading spaces and combined ↵Yorhel1-1/+1
DB/{Votes,VNList,WishList}.pm into ULists.pm
2008-11-26All db*(Edit|add) functions accept an uid option, reverse relation updates ↵Yorhel1-4/+4
go to Multi again
2008-11-22Wrote a generic function to handle all /[vrp]+/(lock|hide) URIsYorhel1-10/+1
They pretty much all work the same anyway
2008-11-14Adding new producer works + abstracted adding of new items and revisionsYorhel1-18/+21
...and those URL regexes are getting more and more complex >.>
2008-11-13W00t, producer editing works!Yorhel1-1/+30
Though there's no diff viewer or revision browser yet, so you can't really see the changelog itself
2008-11-13Locking and hiding producers worksYorhel1-1/+10
2008-11-12Expanded producer page with VN info and created a nice page layoutYorhel1-1/+21
2008-11-12Started on the producer pageYorhel1-0/+62
dbProducerGet is mostly stolen from 1.x