Age | Commit message (Collapse) | Author | Files | Lines |
|
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)
|
|
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.
|
|
|
|
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.
|
|
|
|
TODO:
- document the relations
- emit a relgraph notify when needed
|
|
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
|
|
This is a very important column in a very important table, I hope I
didn't forget to update a piece of code somewhere...
|
|
|
|
That was the last one. I hope I haven't forgotten to update anything.
|
|
Using the same method as 203509ffd8fc2fbbd76129d701a6c20110f6050d
|
|
dbProducerGet()
Added an 'extended' flag to the 'what' argument, which should be used
if more columns are desired.
|
|
|
|
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
|
|
DB/{Votes,VNList,WishList}.pm into ULists.pm
|
|
go to Multi again
|
|
They pretty much all work the same anyway
|
|
...and those URL regexes are getting more and more complex >.>
|
|
Though there's no diff viewer or revision browser yet, so you can't
really see the changelog itself
|
|
|
|
|
|
dbProducerGet is mostly stolen from 1.x
|