AgeCommit message (Collapse)AuthorFilesLines
2009-08-09ChangeLog version bump to 2.62.6Yorhel1-1/+1
2009-08-09Multi::IRC: Got rid of crash in the throttle functionYorhel1-1/+1
2009-08-09Multi::IRC: Fix double-notify bugYorhel1-0/+1
timestamptz data types have sub-second precision, but we use time() with second precision for comparing, resulting in false positives. Using Time::HiRes::time should give the same precision as PostgreSQL's NOW(), so things should be working fine now. It's still a bad idea to use Multi's time instead of a PostgreSQL value for comparing... should really think of a clean way of fixing this.
2009-08-09Don't check for double post when editing a postYorhel1-1/+1
There's no need to disallow someone to edit their post within 30 seconds after posting...
2009-08-09Multi::IRC: Fixed authentication level checking bugYorhel1-3/+4
Everyone had access to the commands with the |8 flag enabled. Oops!
2009-08-09Multi::Maintenance: Added logging of important statisticsYorhel1-8/+11
Requires the new PoCo-Pg
2009-08-09Removed select.pngYorhel1-0/+0
That image hasn't been used for a while. Used to be a selection indicator for category filters.
2009-08-09Multi::Core: Actually log to file instead of stdoutYorhel1-1/+1
2009-08-09Converted changes.added to timestamptzYorhel9-20/+29
That was the last one. I hope I haven't forgotten to update anything.
2009-08-08Don't show hidden VN items on g+ pagesYorhel1-0/+1
Ideally, all tag relations should be removed when hiding a VN, but that would make hiding a destructive action, while currently it can still be reverted easilily.
2009-08-08Converted tags.added to timestamptzYorhel4-4/+11
2009-08-08Converted users.registered to timestamptzYorhel3-6/+12
Just a few more to go...
2009-08-08Converted to timestamptz and use NOW() as defaultYorhel3-4/+10
2009-08-08Converted and edited to timestamptzYorhel4-8/+19
Everything still seems to be working fine so far.
2009-08-08Converted wlists.added and rlists.added to timestamptzYorhel3-4/+15
I like how the rlists.added column isn't used anywhere in the code, makes the conversion a lot easier. :-)
2009-08-08Improved handling of the timestamp columns in anime and session tablesYorhel3-9/+4
Anything fetched from the DB to Perl should be converted to a UNIX timestamp, and everything that goes from Perl to the DB should be converted from a UNIX timestamp to a timestamptz data type. Also, when creating a session, don't rely on the fact that the expiration default happens to be the same as the cookie expiration time calculated in Perl. It's cleaner to calculate the date at one place and then use that everywhere else.
2009-08-08Added note on g+ pages about cachingYorhel1-0/+1
Ideally, that shouldn't be necessary, but I can't think of a way to keep the tags_vn_bayesian table up-to-date without a huge performance penalty.
2009-08-08Removed last traces of the category systemYorhel19-193/+9
2009-08-08Convert old category relations to tags and remove vn_categoriesYorhel2-11/+52
This will currently generate a 500 error for VN pages, because they still try to look something up in the vn_categories table. Will fix that soon. Obviously, this conversion script only works on the actual VNDB database, if you run your own VNDB you can safely ignore the INSERT error when executing update_2.6.sql.
2009-08-08Merge branch '3dev' of git:// into betaYorhel4-1/+9
+ ChangeLog update
2009-08-08css: Converted all pt units to pxYorhel2-59/+18
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. :-(
2009-08-06More logical naming of dbGetPost date filter3dB2-4/+4
2009-08-06Post checking now alows one new thread in 30s3dB1-1/+1
2009-08-06Use timestamptz data type instead of timestampYorhel2-4/+4
It took me a while to figure out that the "timestamp with timezone" PostgreSQL type doesn't actually store the time zone, it simply stores and calculates on UTC, and only converts it to the connection time zone in the formatting stage before sending it to the SQL client. When working with date/times in PgSQL, the NOW() (and related) functions return a timestamp with time zone. Upon converting that to a timestamp without time zone type, the current timezone setting is used. Meaning that comparing a column of type timestamp without timezone to NOW() will only work if all data in the columns is stored in the same timezone as that of the current connection, which in turn means that changing this setting at any point will cause all data in timestamp without timezone columns to be incorrectly interpreted. I often praise PostgreSQL for their comprehensive documentation, but they could've pointed this out more clearly...
2009-08-06Added OpenSearch plugin + autodetectionYorhel3-1/+23
2009-08-05Removed unnecessary export.3dB1-1/+1
-- Removed unneeded export of previously deleted subroutine dbPostCheckDouble
2009-08-05Reworked double post checking to use existing code3dB2-22/+5
-- Removed dbPostCheckDouble -- Added more filters to dbPostGet to serve similar purpose
2009-08-05Multi::Core: Got rid of 'undefined' warning in pg_error + ChangeLog updateYorhel2-1/+7
2009-08-05Multi::IRC: Added !p producer search and fixed tiny bug in !vnYorhel1-5/+31
2009-08-05Removed last traces of the shared memory processing queueYorhel7-52/+0
Everything has now finally been converted to use the PgSQL LISTEN/NOTIFY feature. This commit removes the last Tie::ShareLite dependency.
2009-08-05Multi::IRC: Reimplemented notifications using PgSQL LISTEN/NOTIFYYorhel3-22/+104
2009-08-05Multi::IRC: Spam random quotes in idle channelsYorhel1-1/+15
'idle' is currently defined as 60+rand(300) minutes, so it'll only occur in *very* idle channels... might be an idea to lower these numbers later on.
2009-08-05Multi::IRC: Wrote generic throttle function and put a limit on !vn usageYorhel1-12/+40
2009-08-05Multi::IRC: Added !quote command to reply with a random quote from the DBYorhel1-2/+13
2009-08-05Multi::IRC: Re-added the !vn commandYorhel1-36/+36
Works as it did before. But maybe it's time to add a small throttle to prevent misuse?
2009-08-05Multi::IRC: Don't listen to unaddressed commands without the ! triggerYorhel1-2/+2
Tiny bug introduced in a recent commit.
2009-08-05Multi::IRC: Allow commands to be called by addressing the botYorhel1-10/+13
And force this for some commands. Calling !die in a channel with multiple bots isn't a good idea, after all...
2009-08-05Multi::IRC: Display edit summary on edit linksYorhel1-3/+9
2009-08-05Multi::IRC: Display board titles in thread linkingYorhel1-2/+19
Nothing beats seeing a: <Multi> [t2.7] Reply to Alias: added Japanese title Posted in db, u:retardsrox, u:nacchi, v:Natsu, Semi, Shoujo, v:Dal-eu Jajang-ga By applehq @
2009-08-04Started on Multi::IRC rewriteYorhel1-254/+246
Most of the functionality of the old IRC bot should be present again, with notifications and the !vn command being the only exceptions. I'll reimplement those later. The configuration has changed a little: - 'user' variable renamed to 'nick' - 'channel' renamed to 'channels' (it's an arrayref, after all) - the 'masters' variable now uses IRC masks rather than nicks This new version also has three user levels rather than two: regular users, OPs in the first channel, and 'masters'. This way #vndb OPs can get control over some useful functions as well. The 'master' functions are far too powerful and as such should only be used by the person operating the bot.
2009-08-04Implemented double-post prevention3dB3-1/+25
-- Created a subroutine to check for any recent posts made by a user -- Added double-post checking and error messages to the form handler & html generator
2009-08-01Don't try to DELETE FROM vnlists in dbUserDel()Yorhel1-1/+0
The vnlists table has been removed in an earlier update. Though I don't think I've explicitely removed it from an update script. For those who still have this table, check commit 9a07126464f4ca05f33e7375883ada66abe7dcf4 - it has some changes not present in any of the update scripts but which are done on the main ( & beta) databases.
2009-08-01Added Vietnamese to the language listYorhel4-0/+4
Now the last unused space in icons.png is used as well. Another icon and we'll need to enlarge it a bit.
2009-07-31Use bytea data type to store session tokensYorhel3-12/+10
To be consistent with users.passwd - hashes are stored in binary. All conversion from/to hex is done in the DB layer.
2009-07-31Fetch hex hashes from dbUserGet() and do comparison in hexYorhel2-12/+9
For consistency, it's best to do everything related to hashes in hexadecimal notation in Perl.
2009-07-31Added encode_utf8() on $salt and $pass in _authEncryptPass()Yorhel1-3/+5
This forces $salt and $pass to be 'downgraded' to byte strings in case we are given unicode strings (i.e. when fetched from database or YAWF). This, in turn, prevents global_salt from 'upgrading', which allows binary data to be used for this string.
2009-07-30Added sessions table to dbgraph.plYorhel1-1/+1
The graph looks even worse now, oh well.
2009-07-30Util::Auth: check cookie for sanity and delete incorrect cookiesYorhel1-5/+14
This fixes a 500 error when the cookie was longer than 40 bytes but the characters after the 40th byte aren't a number. (i.e. the cookies of the previous auth system) This will also purge the cookie from the user's browser when dbSessionCheck() returns false. (There's no sense in keeping it in such a case)
2009-07-30Fixed syntax error in update_2.6.sql and removed leading spaces in dump.sqlYorhel2-4/+4
That syntax error was partly 3dB's fault, and partly my fault for changing too much in that merge, heh.
2009-07-30Merge branch 'auth' of git:// into betaYorhel7-34/+141
Conflicts: util/dump.sql util/updates/update_2.6.sql Also updated ChangeLog and made some tiny style changes.