index
:
vndb
master
Source code of VNDB.org
Yorhel
summary
refs
log
tree
commit
diff
log msg
author
committer
range
path:
root
/
util
/
sql
/
func.sql
Age
Commit message (
Expand
)
Author
Files
Lines
2019-12-30
Minor refactor: Move all trigger functions and declarations to separate file
Yorhel
1
-262
/
+14
2019-12-27
ulists: Update devdump.pl
Yorhel
1
-13
/
+13
2019-12-19
ulist: Update user list with vnlist/votes/wishlist stats
Yorhel
1
-9
/
+21
2019-12-17
ulist: Synchronize changes between rlists and ulist_vns
Yorhel
1
-30
/
+26
2019-12-16
ulist: Convert vn.c_* vote stat updating to use ulist_vns table
Yorhel
1
-13
/
+29
2019-12-16
ulist: Integrate update script into SQL + update notify_listdel()
Yorhel
1
-4
/
+33
2019-10-07
SQL: Improve performance of update_vnpopularity()
Yorhel
1
-15
/
+12
2019-10-07
SQL: Perform incremental updates on traits_chars when characters are edited
Yorhel
1
-8
/
+20
2019-10-07
SQL: Perform incremental updates on tags_vn_inherit when tags are modified
Yorhel
1
-9
/
+19
2019-10-07
SQL: Adjust tag_vn_inherit and trait_chars calculations
Yorhel
1
-48
/
+41
2019-10-03
Disallow changing email address to one already used by another account
Yorhel
1
-2
/
+2
2019-10-03
Require email confirmation when changing email address
Yorhel
1
-6
/
+24
2019-10-03
SQL: Add session types + use sessions for password reset tokens
Yorhel
1
-18
/
+25
2019-10-03
SQL: Change sessions.lastused into sessions.expires
Yorhel
1
-8
/
+5
2019-10-03
SQL: Get rid of the users_prefs table, store preferences in users table
Yorhel
1
-3
/
+3
2019-09-17
Don't send db edit notifications for changes made by Multi
Yorhel
1
-0
/
+1
2019-08-15
Minor util/sql/ reorganization + Make devdump more robust
Yorhel
1
-0
/
+16
2019-08-09
Replace Wikipedia links with Wikidata IDs
Yorhel
1
-0
/
+11
2019-06-28
SQL: Use schema-qualified strip_bb_tags() in bb_tsvector()
Yorhel
1
-1
/
+1
2019-06-26
Traits: Split "meta" field into "searchable" and "applicable"
Yorhel
1
-7
/
+6
2019-06-26
Tags: Split "meta" field into "searchable" and "applicable"
Yorhel
1
-6
/
+6
2018-10-01
Lower the average vote requirement for tag spoilers a bit
Yorhel
1
-1
/
+1
2018-09-29
Add default spoiler level to tags and use it in spoiler calculation
Yorhel
1
-10
/
+14
2018-02-08
Store d+ pages in the DB as versioned entries + use markdown
Yorhel
1
-0
/
+3
2017-12-29
SQL: Don't inherit trait/tag childs if parent is mentioned directly
Yorhel
1
-2
/
+7
2016-11-27
SQL: Use separate role for Multi
2.26
Yorhel
1
-1
/
+1
2016-11-27
SQL: Use separate role for the website + disallow access to user data
Yorhel
1
-0
/
+108
2016-07-03
Generalize substring search relevance + apply to most dropdown searches
Yorhel
1
-0
/
+15
2015-10-24
Improve several discussion board SQL queries
Yorhel
1
-0
/
+8
2015-10-21
SQL: Fix editing + func.sql + triggers.sql + autocreate editing funcs
Yorhel
1
-535
/
+225
2015-10-12
SQL: Split constraints/indices/triggers in new file + use idempotent SQL
Yorhel
1
-1
/
+0
2015-09-07
Handler::Discussions: Use ts_headline() to format search results
Yorhel
1
-1
/
+7
2015-09-07
Implement discussion board search function
Yorhel
1
-0
/
+6
2015-01-12
staff: Add notifications for staff edits/deletes
Yorhel
1
-2
/
+8
2015-01-12
staff: Remove some remnants of the staff images
Yorhel
1
-3
/
+3
2015-01-04
staff: Add some link fields and guidelines
morkt
1
-3
/
+3
2014-12-28
More progress on the staff + cast DB
morkt
1
-1
/
+6
2014-12-22
Initial implementation of a staff/seiyuu database
morkt
1
-2
/
+52
2014-12-02
Completely drop l_vnn column from VN info
Yorhel
1
-2
/
+2
2014-10-13
SQL: Use enum to represent platforms
Yorhel
1
-2
/
+3
2014-09-15
Change normalization factor in popularity ranking calculation
Yorhel
1
-1
/
+1
2013-01-05
Don't use Multi for processing screenshots
Yorhel
1
-7
/
+0
2013-01-05
Don't use Multi for processing character images
Yorhel
1
-7
/
+0
2013-01-05
Don't use Multi for processing VN cover images
Yorhel
1
-7
/
+0
2011-12-29
Maintain VN search cache for hidden entries as well
Yorhel
1
-9
/
+5
2011-05-01
Bugfix in update_stats_cache() resulting in a 500
Yorhel
1
-1
/
+1
2011-04-08
Added char/tag/trait stats to database statistics box
Yorhel
1
-3
/
+13
2011-04-08
Generate dbedit/dbdel notifications on character edits
Yorhel
1
-16
/
+22
2011-03-15
chardb: Added main char field + editing
Yorhel
1
-2
/
+2
2011-02-22
chardb: +char<->vn linking, +vn display on char pages
Yorhel
1
-1
/
+5
[next]