path: root/lib/VNDB/DB/
AgeCommit message (Expand)AuthorFilesLines
2021-01-20v2rw: Rewrite done, time to clean up old v2 codeYorhel1-49/+0
2020-04-15SQL: Split "perm" column into multiple booleansYorhel1-1/+1
2019-11-15Move pubskin fetching responsibility to VNWeb::HTML::framework_Yorhel1-2/+0
2019-10-14v2rw: Convert user listingYorhel1-36/+4
2019-10-14Delete the user deletion featureYorhel1-8/+1
2019-10-12rewards: Fix applying the public skin even when disabledYorhel1-1/+1
2019-10-12v2rw: Convert user notifications interface (/u+/notifies)Yorhel1-70/+0
2019-10-10rewards: Honor public custom css/skinYorhel1-1/+2
2019-10-10rewards: Apply supporters badge and unicode name (almost) everywhereYorhel1-13/+3
2019-10-03Disallow changing email address to one already used by another accountYorhel1-50/+1
2019-10-03Fix 500 when sorting userlist by vote countYorhel1-1/+1
2019-10-03SQL: Get rid of the users_prefs table, store preferences in users tableYorhel1-33/+4
2019-09-18v2rw: Convert authentication code to VNWeb::AuthYorhel1-41/+5
2016-11-27SQL: Use separate role for the website + disallow access to user dataYorhel1-33/+65
2016-01-10DB::Users: Perform case-insensitive email matchingYorhel1-1/+1
2015-06-15d7: Replace "top 5 contributors" with "special users" listingYorhel1-1/+4
2014-10-16Hash session tokens with SHA-1 when storing in DBYorhel1-4/+4
2014-10-15SQL: Merge users.(passwd|salt) in one column + document valuesYorhel1-9/+7
2014-10-11SQL: Convert login_throttle.timeout to a timestamptzYorhel1-3/+3
2014-08-29Throttle failed login attempts (10/day)Yorhel1-0/+16
2013-03-09Allow only one account registration per /48 IPv6 block per dayYorhel1-1/+1
2011-08-23Added email confirmation to registration processYorhel1-3/+3
2011-04-30Replaced user ranks with a permission systemYorhel1-2/+2
2011-04-03Bugfix: use the 'vnlists' table to calculate stats on user pageYorhel1-1/+1
2011-01-27Order "all notifications" with new notifications firstYorhel1-3/+3
2010-12-23Converted the notify_announce and notify_dbedit preferencesYorhel1-3/+3
2010-12-23Converted the show_list pref. to users_prefs and inverted the valueYorhel1-4/+8
2010-12-23Converted the show_nsfw preference to use the users_prefs tableYorhel1-2/+2
2010-12-23Added users_prefs table and removed users.(skin|customcss)Yorhel1-4/+27
2010-11-14SQL: Added ON DELETE clause to all foreign keys referencing users (id)Yorhel1-15/+1
2010-11-06Bugfix: delete/update all references when deleting a userYorhel1-0/+5
2010-02-05Notifications: Added 'announce' notificationYorhel1-2/+2
2010-02-05Notifications: Added 'dbedit' notificationYorhel1-2/+2
2010-02-01Cache the title and userid of the notificationsYorhel1-9/+2
2010-01-26SQL: Replaced sessions.expiration with sessions.addedYorhel1-5/+2
2010-01-26Keep track of when a session has last been usedYorhel1-1/+9
2010-01-26Made a start on the notification systemYorhel1-16/+66
2010-01-24Automatically generate the skin credits on d7Yorhel1-1/+3
2009-11-27DB: Abstracted all ORDER BY clauses in the DB abstraction layerYorhel1-3/+11
2009-11-15Auth: Combined dbSessionCheck into dbUserGetYorhel1-14/+11
2009-10-10Greatly reduced default number of columns returned by dbUserGetYorhel1-3/+7
2009-10-10Get unread posts count in htmlHeader() instead of Util::AuthYorhel1-10/+16
2009-10-10Display number of unread posts in user menuYorhel1-1/+7
2009-08-12Added global user votes ignore listYorhel1-2/+2
2009-08-08Converted users.registered to timestamptzYorhel1-5/+5
2009-08-08Improved handling of the timestamp columns in anime and session tablesYorhel1-7/+2
2009-08-01Don't try to DELETE FROM vnlists in dbUserDel()Yorhel1-1/+0
2009-07-31Use bytea data type to store session tokensYorhel1-10/+8
2009-07-31Fetch hex hashes from dbUserGet() and do comparison in hexYorhel1-3/+2
2009-07-29Changed sessions.expiration column to timestamp3dB1-3/+10