summaryrefslogtreecommitdiff
AgeCommit message (Collapse)AuthorFilesLines
2019-12-08dbdump.pl: Do an explicit rollback before disconnecting the DBYorhel1-0/+1
Fixes a (harmless) warning: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=vndb at util/dbdump.pl line 247.
2019-12-08Discussions: Add exception for uid 2 in sql_visible_threads()Yorhel1-0/+1
Turns out the recent update didn't allow me to moderate private threads anymore. :( I decided not make it a boardmod feature this time, one person for moderating private threads is enough.
2019-12-07dbdump.pl: Ensure consistent exportsYorhel1-1/+2
Today's export had a little inconsistency caused by a database update while the export script was running.
2019-12-07ulist: Display useful message when list is empty or privateYorhel1-5/+10
2019-12-06Handle BBCode spoiler tags in CSSYorhel2-13/+3
Also fixes the hover effect for threads, which I broke earlier due to the threads moving to v2rw.js.
2019-12-06Add link to d9#3 to quick reply box + allow customizing TextPreview headerYorhel6-30/+34
2019-12-05v2rw: Convert thread reply form to ElmYorhel4-19/+103
So we can apply the new preview functionality. I got rid of the "Go advanced" button, because there's really nothing advanced about it.
2019-12-05ulist: Add search box + tabindex on filter input fieldsYorhel1-6/+10
2019-12-03API: Add labels field to "set ulist"Yorhel1-1/+15
2019-12-03API: Add "set ulist" commandYorhel1-0/+44
TODO: - Managing labels - Assigning labels to VNs Not yet sure what the API for the latter should look like.
2019-12-03API: Add "get ulist-labels" and "get ulist"Yorhel2-3/+81
To directly query the new list feature. I'll migrate the old vnlist/wishlist/votelist APIs later to query the 'ulist' tables.
2019-12-01JS: Remove old "This is not VNDB!" domain checkYorhel1-11/+0
This is a remnant from when I was running a public sandbox VNDB, to avoid getting people confused and wasting their time contributing to the sandbox. Removed for consistency with pages that have migrated to the new v2rw.js, which doesn't have the message, and for the new .onion address.
2019-12-01Discussions: Do not highlight post when nagivating to the "last post"Yorhel4-6/+13
That behavior was more distracting, especially when the intention of the link isn't to link to that post in particular, but just to the more recent part of the thread. As an additional advantage, this doesn't rely on the t#.# redirect anymore, this making browsing the forums slightly faster.
2019-12-01v2rw: Convert thread display + poll votingYorhel18-239/+411
I did not reimplement the 'poll_recast' and 'poll_preview' settings, these actions are now always permitted. Updated CSS a little bit to highlight the linked post and fix the double border at the bottom. The nice thing about the sql_visible_threads() function I wrote earlier is that is can also be used for access control on a single thread. More code re-use. \o/
2019-12-01Christmas theme \o/Yorhel2-1/+1
2019-11-28ulist: Fix display of vote date when not votedYorhel1-1/+1
2019-11-28Use plain links for JS-ified linkradio inputs + fix focus of non-JS linkradiosYorhel6-41/+56
Kind of backwards to use input elements to display a link when they're backed by Javascript anyway. This also avoids the need to create a unique id for each linkradio element.
2019-11-27ulist: Add column selection + voted, modified, release date & rating columnsYorhel7-51/+198
It works pretty well, but Lists.pm is getting *really* ugly now. :(
2019-11-27Elm: Use fieldset to disable the form while loadingYorhel8-7/+15
I wasn't able to do this while the .maintabs used floats.
2019-11-27CSS: Less hacky .maintabsYorhel6-187/+115
Flexbox instead of floats. Apart from that, it's still very hacky. Uses relative positioning in order to overlay 1px over the .mainbox. This should fix the ages-old 'bottom tabs overlay next mainbox' bug and provide more flexibility with adding a top-level <fieldset> or centered buttons.
2019-11-27Multi: Fix parsing of ExtLinks.pm when TUWF::XML isn't loadedYorhel1-1/+1
2019-11-23ulist: Add some test menu linksYorhel1-0/+8
2019-11-23ulist: Make labels column sortableYorhel1-17/+18
This is pretty slow for large lists, but let's just see how it goes.
2019-11-19ulist: Keep sort column when updating filtersYorhel1-0/+2
2019-11-19Increase CSRF token validity window to 12 hoursYorhel1-4/+2
People leave their window open for a while, and that's fine.
2019-11-19ulist: Focus and select label input when adding a new labelYorhel1-2/+6
2019-11-19ulist: Remove the notes iconYorhel2-2/+0
It's redundant. The goal was to make the notes feature more prominent so it'd stand out more, but in hindsight it seems more like a distraction.
2019-11-19ulist: Compact the notes field and "add release" link in the expanded viewYorhel2-12/+22
Less clutter when not editing.
2019-11-19Minor refactor: Use dbPage() in scalar context where applicableYorhel4-5/+5
Requires the latest git version of TUWF.
2019-11-19Discussions: Fix index linkYorhel1-1/+1
2019-11-19Fix consistency between discussion counter in the dbentry tabs and actual ↵Yorhel2-6/+10
listing i.e. private and hidden threads are now included in the counter if you can see those threads.
2019-11-19v2rw: Convert discussion board listings + change link structure a bitYorhel5-132/+84
A board-wide "tab"-like structure rather than breadcrumbs, has a more consistent feeling.
2019-11-15Discussions::Lib: Use same WHERE clause for counting and listingYorhel1-3/+3
2019-11-15Move pubskin fetching responsibility to VNWeb::HTML::framework_Yorhel7-20/+19
Requiring callers to fetch the right fields and pass it along to framework_() just seems brittle. This implementation requires an extra query but does make an effort to avoid fetching the skin and css when it's not needed.
2019-11-15threadlist: Automatically hide threads the user should not see + display ↵Yorhel3-5/+11
hidden/private flags
2019-11-15v2rw: Convert discussion board indexYorhel4-103/+130
Not super happy with the layout of the thread listing table, maybe I'll revisit that after converting the board listings. Also not super happy with the overall (lack of) structure in the board listing pages, should be able to find something for that as well.
2019-11-15Fix Wikipedia linksYorhel1-2/+2
Broken due to confusion over whether a 'fmt' subroutine returns an fmt string or a full URL. In the case of Wikidata, it should return the full URL...
2019-11-15v2rw: Convert discussion board searchYorhel4-133/+212
With minor styling improvements and full pagination for thread title search. I did combine a few queries which I initially separated for performance reasons. A few quick benchmarks show that it's fast enough, but I'll have to see how it performs in production.
2019-11-14v2rw: Convert staff pagesYorhel7-253/+256
This is where the ExtLink module comes in handy: generating the revision comparison thing is much easier now. Did find and fix a bunch of issues with the new revision box generator code, but that was to be expected, I hadn't tested that code well yet and this is its first more demanding use. Rest of this is a pretty direct rewrite, nothing too special.
2019-11-12v2rw: Move entryLinks() into separate VNDB::ExtLinks moduleYorhel9-167/+269
This is yak shaving. The new module doesn't have much value as it is, apart from having a central place to define link formats. This new enrich_extlinks() approach is also a bit more efficient in that it can avoid separate SQL queries for multiple objects. But the real reason for these changes is that I can use that %LINKS hash table to automatically generate the links part in the edit summary and it should (hopefully) also be useful to generate a more convenient/streamlined Elm edit form.
2019-11-11ulist: Improve date editing experience for browsers that fall back to a text ↵Yorhel1-5/+8
field
2019-11-11ulist: Add a "no label" filterYorhel1-9/+29
2019-11-11ulist: Update lastmod when changing labels or voteYorhel1-1/+3
2019-11-10ulist: Fix migration script to properly delete tables & handle concurrent ↵Yorhel1-2/+7
changes
2019-11-10ulist: Beta modeYorhel1-0/+17
2019-11-10ulist: Improve page load time by lazily loading some thingsYorhel4-14/+32
Instantiating 100 <input type="date"> takes about 180ms on my system with Firefox, so doing that lazily is a big win. UList.Opt is typically hidden, lazily initializing that saves an additional 60ms. Also increase the mouse-over div for the date editor a bit so that there's more hover space.
2019-11-10ulist: SQL: Create labels for new users + auto-assign Voted label + import ↵Yorhel2-5/+58
rlisted VNs
2019-11-10ulist: Add feature to add releases to the listYorhel5-18/+98
2019-11-10ulist: Dynamically update releases summary on changeYorhel4-7/+16
2019-11-10ulist: Generalize Elm dropdown + add release status change & removalYorhel5-67/+168
Found a cleaner way to recognize outside-of-dropdown clicks, so that gets rid of the weird and unreliable message timing workarounds. TODO: - Dynamically updating that releases summary thing (1/1 blah) - Adding releases - Add "linkradio" styling for plain <a> tags? These hidden checkboxes are silly for stuff that requires JS anyway.