Age | Commit message (Collapse) | Author | Files | Lines |
|
|
|
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
|
|
|
|
|
|
|
|
I could swear I'd found and fixed a similar bug in the past...
|
|
|
|
|
|
This fixes a strange issue that the ordering changes when browsing to
the next page, resulting in some VNs not showing up at all.
|
|
<@EchoMateria> for example I searched for 'Maika' in Visual Novels
<@EchoMateria> then remembered that it was a producer not a game and
clicked Producers instead
<@EchoMateria> can you set it so that entry in the search field would
stay and it would search for it in the producers instead?
|
|
Performance improvement of ~15ms for all release and VN browse pages.
There are in total 20 known languages in the DB, and 12 of them are
actually used (i.e. a release in that language exists). Which means 8 of
the listed language filters won't produce any results (yet), but I'd say
that's an accaptable trade-off.
|
|
Most of the columns are only used in some rare situations, so fetching
all that information is unecessary. To fetch this information, a
what => 'extended'
is now required. This change should be most noticable for the user list
(now less than half of the previous data is fetched from the database).
|
|
Instead of displaying the total number of threads. Posts are marked as
read when the thread is opened.
|
|
They aren't displayed on the site yet, though.
|
|
|
|
|
|
|
|
+ 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.
|
|
Mainly because someone offered to translate the interface into
Hungarian, and interface languages are directly linked with database
languages.
|
|
Again, two separate but related things.
|
|
Interface consistency
|
|
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.
|
|
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.
|
|
+ updated changelog
|
|
|
|
This was *supposed* to be done in
ce6d43aed955effe136f1ce3682828d2d43109cb
|
|
As they would soon be dead links, anyway.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Had to increase the size of icons.png a bit...
|
|
|
|
|
|
|
|
To make sure we can still see a troll if he marks his list as hidden.
Only admins have this usermod privilege, and admins are assumed to have
raw SQL access anyway.
|
|
|
|
It's still not perfect, though:
- New version is table-based - meh.
- Uses negative margins more than once - meh!
- Only works if any of the columns has enough content to wrap. If all
content fits in the columns without wrapping, the total table width
falls back to the "min-width: 100%" statement - which, with the
negative margins, isn't really 100%. MEH!
Still... it looks better than the previous solution.
So far tested on FF3.5, Opera 9.something, and some semi-recent version
of webkit. Reported to work fine on IE7 as well.
|
|
|
|
That was the last one. I hope I haven't forgotten to update anything.
|
|
|
|
+ ChangeLog update
|
|
It seems not all setups display the fonts at the same size when
specifying the sizes in pt. At least, my awesome setup makes all fonts
even smaller than they already were...
I'm also still not really happy with the current font size, but making
it even a tiny bit larger makes everything look ugly. :-(
|
|
|
|
|
|
Now the last unused space in icons.png is used as well. Another icon and
we'll need to enlarge it a bit.
|
|
Conflicts:
util/dump.sql
util/updates/update_2.6.sql
Also updated ChangeLog and made some tiny style changes.
|
|
|