summaryrefslogtreecommitdiff
path: root/lib
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-27Added release link to screenshotsyorhel3-7/+10
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 PNGyorhel2-3/+7
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 ↵yorhel1-1/+1
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 ↵yorhel1-1/+1
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 ↵yorhel1-0/+2
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 ↵yorhel5-12/+19
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 ↵yorhel6-35/+23
/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 graphyorhel1-1/+5
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.21yorhel2-26/+28
boolean type. git-svn-id: svn://vndb.org/vndb@90 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-14Fixed bug with an edit being comitted without any changes, renamed anime ↵yorhel3-11/+13
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 ↵yorhel3-46/+86
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 ↵yorhel6-59/+236
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.20yorhel2-2/+1
and rlist features git-svn-id: svn://vndb.org/vndb@79 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-01Added wishlist feature and re-added "my profile" link to user menuyorhel6-2/+155
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 ↵yorhel2-1/+2
tpl/rlist git-svn-id: svn://vndb.org/vndb@76 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-29- Further polished the rlist featureyorhel5-91/+12
- 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 featureyorhel9-93/+264
- 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 warningyorhel1-0/+1
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 ↵yorhel4-3/+27
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 matchyorhel1-2/+2
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 ↵yorhel2-1/+1
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 ↵yorhel3-5/+8
'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 ↵yorhel3-11/+17
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-08Upped the character limit of posts to 5000 and fixed a few typosyorhel1-1/+1
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 ↵yorhel1-1/+1
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 homepageyorhel1-1/+1
git-svn-id: svn://vndb.org/vndb@58 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-08Added recent posts, upcoming releases and just released lists to the ↵yorhel3-2/+10
homepage, and removed the vote count git-svn-id: svn://vndb.org/vndb@56 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-08Removed the rating system and small cleanup on the homepageyorhel4-12/+9
git-svn-id: svn://vndb.org/vndb@55 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-08Wrote an integrated messageboard, and fixed a few (very) small things along ↵yorhel9-21/+459
the way git-svn-id: svn://vndb.org/vndb@54 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-07Added d+.+ refirectyorhel1-0/+1
git-svn-id: svn://vndb.org/vndb@53 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-02Small layout change to /hist and preperations for version 1.181.18yorhel1-1/+1
git-svn-id: svn://vndb.org/vndb@51 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-06-30Small prev -> rev fix, and removed unnesessary $prep in Multi's repliesyorhel2-8/+9
git-svn-id: svn://vndb.org/vndb@50 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-06-30Revision numers are now local to their item ID and better integrated into ↵yorhel7-161/+187
VNDBIDs git-svn-id: svn://vndb.org/vndb@48 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-06-30Fixed a few typos, the edit summary is optional again, and added warnings ↵yorhel4-4/+5
for extreme votes and empty edit summaries git-svn-id: svn://vndb.org/vndb@47 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-06-30Added MSX and NES platforms (icons could use some improvements, though...)yorhel1-0/+2
git-svn-id: svn://vndb.org/vndb@46 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
generated by cgit v1.2.3 (git 2.25.1) at 2024-04-20 09:44:22 +0000