summaryrefslogtreecommitdiff
AgeCommit message (Collapse)AuthorFilesLines
2008-08-29Fixed the removal of screenshots on a reverse relation update1.22yorhel1-1/+2
git-svn-id: svn://vndb.org/vndb@106 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-29Reworded d5.2yorhel1-7/+6
git-svn-id: svn://vndb.org/vndb@105 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-27Some additions in the guidelinesyorhel2-4/+20
git-svn-id: svn://vndb.org/vndb@104 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-27Added release link to screenshotsyorhel11-24/+82
git-svn-id: svn://vndb.org/vndb@103 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-20Fixed two other boolean inputs, and if we're going to write subroutines with ↵yorhel1-9/+10
only one-character variable names, we've got to do it right, don't we? ^^ git-svn-id: svn://vndb.org/vndb@102 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-20Converted relation graphs to PNGyorhel6-35/+26
git-svn-id: svn://vndb.org/vndb@101 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-20Fixed error when creating a new thread, changed type of threads_posts.num to ↵yorhel3-2/+9
smallint, and added (yet another) foreign key constraint to the threads table git-svn-id: svn://vndb.org/vndb@100 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-20Another internal database change: changes.causedby accepts NULL values and ↵yorhel3-2/+13
properly references changes.id git-svn-id: svn://vndb.org/vndb@99 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-19Rewrote parts of DB.pm to use server-side prepared statements. I'm pretty ↵yorhel3-312/+282
sure this change will break something; excessive testing required. Advantages: - True server-side prepared statements (PgSQL didn't support them at the time I wrote the previous sqlprint) - Proper support for the NULL value (just pass undef) - Absolutely no room for SQL injection vulnerabilities (at least... when you don't use %s) - Automatic type detection: no separate quoting functions for bool, integer or string data types - Doesn't conflict with sprintf, you can call both without having to escape things - !W and !H accept both hashrefs and arrayrefs, allowing multiple formats with different values - !W and !H automatically add or omit the 'WHERE' and 'SET' clause where needed Performance? I have absolutely no idea which method is faster. git-svn-id: svn://vndb.org/vndb@98 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-19Fixed infinite thumbnail generation bug and added note about submitting the ↵yorhel3-3/+8
screenshot form git-svn-id: svn://vndb.org/vndb@97 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-18No need to access Multi's shared memory when you don't do anything with it...yorhel2-1/+3
git-svn-id: svn://vndb.org/vndb@96 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-18Found a definite and proper solution to fix the command synchronisation ↵yorhel6-13/+20
problems, fixed display of wrong ID for screenshot diff, and increased screenshot JPEG quality to 90 git-svn-id: svn://vndb.org/vndb@95 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-18Multi can be a bit too fast sometimes...yorhel1-1/+1
git-svn-id: svn://vndb.org/vndb@94 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-18Stored relgraph image maps in the DB, instead of using plain text files in ↵yorhel11-39/+75
/data/rg/ git-svn-id: svn://vndb.org/vndb@93 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-18Fixed Multi's !update formattingyorhel1-2/+2
git-svn-id: svn://vndb.org/vndb@92 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-18Inverted vote graphyorhel2-2/+6
git-svn-id: svn://vndb.org/vndb@91 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-15Converted smallints used as boolean to PostgreSQL's relatively new (8.1) ↵1.21yorhel4-40/+139
boolean type. git-svn-id: svn://vndb.org/vndb@90 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-15Small code cleanup in /tpl/tindex, and added link to start a new thread on ↵yorhel1-9/+4
the db tag git-svn-id: svn://vndb.org/vndb@89 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-15Added some guidelines and docs for the screenshot featureyorhel3-2/+41
git-svn-id: svn://vndb.org/vndb@88 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-15Further polishing of the screenshots feature: added loading indicator, link ↵yorhel4-35/+66
to full-size image when downscaled, and image viewer for the upload manager git-svn-id: svn://vndb.org/vndb@87 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-14Deleted /util/OLD, because, seriously, that -is- old!yorhel5-491/+0
git-svn-id: svn://vndb.org/vndb@86 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-14Fixed bug with an edit being comitted without any changes, renamed anime ↵yorhel4-11/+16
check command and added small but useful note to multi.pl git-svn-id: svn://vndb.org/vndb@85 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-14Added screenshots table to store the dimensions of all images, moved to AJAX ↵yorhel10-108/+159
for determining when a thumbnail has been generated after uploading a screenshot, and got rid of the javascript image preloader git-svn-id: svn://vndb.org/vndb@84 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-14Added screenshots (not entirely finished, still needs some tweaking and ↵yorhel18-75/+687
polishing) git-svn-id: svn://vndb.org/vndb@83 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-09Added an optional debug console to Multi, dynamically loading ↵yorhel1-7/+17
Plugin::Console and NickServID only when needed, and decided to not allow PM-notifies for now git-svn-id: svn://vndb.org/vndb@82 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-09Implemented a notification system and made some general improvements in Multi.yorhel9-63/+87
git-svn-id: svn://vndb.org/vndb@81 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-08Rewrote Multi::IRC's command processing and added !vn and !uptime commands ↵yorhel2-45/+174
and support for multi-channel !me and !say. git-svn-id: svn://vndb.org/vndb@80 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-05Added icons for rlist and vlist statuses and further polished the wishlist ↵1.20yorhel8-28/+47
and rlist features git-svn-id: svn://vndb.org/vndb@79 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-01Forgot to upload new file (as usual...)yorhel1-0/+55
git-svn-id: svn://vndb.org/vndb@78 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-01Added wishlist feature and re-added "my profile" link to user menuyorhel14-11/+212
git-svn-id: svn://vndb.org/vndb@77 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-30Auto-expand edit summary form when adding a release, and forgot to upload ↵yorhel3-1/+91
tpl/rlist git-svn-id: svn://vndb.org/vndb@76 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-29- Further polished the rlist featureyorhel13-137/+35
- Re-added old VN list, delete-only and with a warning - Small code cleanup git-svn-id: svn://vndb.org/vndb@75 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-29- Added release list featureyorhel23-216/+444
- Added noindex tag to iid-ttag browser - Replaced last poster with age of last post on home page - Merged user vote lists into new vnlist - Removed 'hide votes' feature - Fixed users+1 stats bug - Fixed FF3 JS hack - Old VNList code is still present, need to decide what to do with that git-svn-id: svn://vndb.org/vndb@74 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-28Two (rewritten - I love playing around with code) patches by applehq: added ↵yorhel1-4/+9
!list and !vndb commands to Multi::IRC git-svn-id: svn://vndb.org/vndb@73 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-27Basic multi-channel support for Multi::IRC, and unknown commands will get ↵yorhel1-7/+10
ignored git-svn-id: svn://vndb.org/vndb@72 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-27Fixed several major SQL injection bugs introduced in r26yorhel8-7/+20
git-svn-id: svn://vndb.org/vndb@71 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-16Added small NSFW indication for users who have disabled the warningyorhel3-0/+5
git-svn-id: svn://vndb.org/vndb@70 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-16Accounts can be deleted, home page now shows age of last post instead of ↵yorhel14-30/+68
user, removed the /u+/pending URL, and small bugfix in dump.sql git-svn-id: svn://vndb.org/vndb@69 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-13Zero-padded VNDBIDs shouldn't matchyorhel2-4/+4
git-svn-id: svn://vndb.org/vndb@68 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-13Added an SQL script to initialize the database needed to run the site, and ↵yorhel4-1/+370
some minor code fixes git-svn-id: svn://vndb.org/vndb@67 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-13Re-added the vote stats to VN pages, Searching for 'Chinese' doesn't select ↵yorhel5-14/+15
'NES' and Place/time category order on VN pages is now consistent git-svn-id: svn://vndb.org/vndb@66 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-13Admins can change someones username, Fixed the automatic relogin after ↵yorhel6-16/+26
changing password and Added lock indicator when browsing threads on a tag git-svn-id: svn://vndb.org/vndb@65 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-09Oops, forgot to remove the reference to the POE method...yorhel1-1/+1
git-svn-id: svn://vndb.org/vndb@64 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-09Added possibility to create a hidden thread and removed ratings calculation ↵yorhel3-13/+11
from Multi git-svn-id: svn://vndb.org/vndb@63 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-08Please welcome a new moderator: applehq!1.19yorhel1-1/+1
git-svn-id: svn://vndb.org/vndb@62 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-08Upped the character limit of posts to 5000 and fixed a few typosyorhel2-3/+4
git-svn-id: svn://vndb.org/vndb@61 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-08Added primary key to threads_tags, added documentation, and mods can now ↵yorhel5-6/+71
hide DB entries git-svn-id: svn://vndb.org/vndb@60 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-08Bugfix: a tag can only be added one time to a threadyorhel1-2/+3
git-svn-id: svn://vndb.org/vndb@59 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-08Replaced recent producers with random visual novels on the homepageyorhel2-5/+5
git-svn-id: svn://vndb.org/vndb@58 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-08Updated some links and added documentation page for the discussion boardyorhel5-7/+17
git-svn-id: svn://vndb.org/vndb@57 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b