summaryrefslogtreecommitdiff
path: root/ChangeLog
blob: 18c972ad8568c0291d6e41088e1ef41945943bda (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
2.3 - ?
	- No page reload needed when changing rlist status from vn page
	- Random VN quotes to the footer of every page
	- Fixed case-sensitivity for BBCode
	- Homepage shows platform icons for releases
	- Don't show deleted items on /u+ recent changes

2.2 - 2009-01-16
	- Additional custom CSS field to user profile
	- Search dropdown calls the return function automatically on select
	- Revised the media list
	- Added a checkbox to releases to indicate a patch
	- VN popularity ranking
	- Limit account creation to one account in 24 hours per IP address
	- Fixed error message when uploading VN images larger than 500kB
	- Fixed 3 grammar mistakes related to singular/plural
	- Don't show hidden release relations on producer pages
	- Hide the vote dropdown on v+ pages when the VN is already on the wishlist
	- Don't search for the ADV category when searching for the Game Boy Advance
	- Keep VN relations on r+ pages ordered by title
	- VN search doesn't match on titles of older release revisions anymore
	- Don't forget to update the vn.c_* columns when hiding/unhiding a release
	- Fixed month display on VNBrowse
	- VN search also matches on original title field of the vn entry

2.1 - 2008-12-29
	- Skin support
	- 'show all items' tab to large forms
	- Allow items to be selected using the mouse on the dropdown search
	- [spoiler] tag produces mouseover-style spoilers instead of ROT13
	- Fixed tiny timezone-related bug
	- Re-added release list dropdown on VN pages
	- Added [quote] tag to bb2html
	- fixed URL parser in bb2html

2.0 - 2008-12-20
	- New layout
	- Massive code rewrite:
	  - Switched to YAWF
	  - Removed template system
	  - Split DB functions in several files
	  - Converted absolute paths to be relative to the root directory
	- Database changes:
	  - Added caching of edit and vote counts in users.c_votes and .c_changes
	  - Split users.flags into users.show_nsfw and .show_list (boolean type)
	  - Global statistics are cached in stats_cache
	- URL changes:
	  - /p and /v don't work anymore, use /[pv]/all
	  - /u/list/* -> /u/* and /u/list -> /u/all
	  - Revert URL changed from /x99/edit?rev=1 to /x99.1/edit
	  - /v+/stats and /v+/scr moved into /v+
	- Functionality changes:
	  - Ability to sort the userlist on vote and change counts
	  - Added threads and posts counts to the global statistics
	  - Improved diff calculation
	  - Whitespace around input fields are removed
	  - Automated edits filter to history browser
	  - Number of threads is shown in the discussion tab for each item
	  - Boardmods can edit threads without updating the last edited field
	  - No more RSS feeds for changes (will be replaced with a notification
	    system in the future)
	  - Improved formsub interface
	  - Improved VN relation editor interface
	  - Voted/non-voted filter to user's VNLists
	  - VNList status can only be changed from release pages
	  - More stats + recent changes on user pages

1.23 - 2008-10-22 (r117)
	- Removed redirects for old revision URLs (the code wasn't very secure...)
	- Fixed bug when using unicode in the AJAX vn/producers/release search box
	- Added original title field to VN entries
	- Fixed incorrect quoting in producer select form
	- Improved display of original titles

1.22 - 2008-08-29 (r106)
	- Inverted vote graph
	- Relation graph image maps are now stored in the DB
	- Properly fixed the command synchronisation issues with Multi
	- Fixed display of wrong ID in the screenshot diff
	- Fixed bug with the infinite thumbnail generation message when the server
	  doesn't respond within one second.
	- Rewrote VNDB::Util::DB::sqlprint to use server-side prepared statements
	- Added two new foreign key constraints:
	    changes (causedby) -> changes (id)
	    threads (id, count) -> threads_posts (tid, num)
	- Converted relation graphs to PNG
	- Added link between screenshots and releases

1.21 - 2008-08-16 (r90)
	- Added !vn and !uptime commands to Multi::IRC
	- Added realtime IRC notifications for actions on the site
	- Added screenshots to VNs
	- Rewrote Multi::Image
	- Renamed the 'anime check' command to 'anime' for consistency
	- Moved to PostgreSQL's boolean data type to store boolean data

1.20 - 2008-08-06 (r79)
	- Admins can change someone's username
	- Fixed the automatic relogin after changing password
	- Added lock indicator when browsing threads on a tag
	- Re-added the vote stats to VN pages
	- Searching for 'Chinese' doesn't select 'NES'
	- Place/time category order on VN pages is now consistent
	- Admins can delete users from the DB
	- Added small NSFW indication for users who have disabled the warning
	- Added noindex tag to iid-ttag browser
	- Replaced last poster with age of last post on home page
	- Added release list feature and removed the old VNList
	- Merged user vote list into the new release list (and removed 'hide my
	  votes' option)
	- Merged Votes.pm into VNLists.pm
	- Auto-expand edit summary form when adding a release
	- Added wishlist

1.19 - 2008-07-08 (r62)
	- Integrated discussion board
	- Colored diff for alies field
	- 'ttabs' for user entries
	- Removed the rating system

1.18 - 2008-07-02 (r51)
	- Releases, producers and visual novel items can't be fully deleted anymore
	- Hidden vote and vnlist items from the 'recent' lists on VN stat pages for
	  users who don't want that to be seen
	- Added warnings for empty edit summary and extreme votes
	- Changed earliest release date to 1980
	- Added NES and MSX platforms
	- All revision numbers are now local to their item ID
	- Rewrote Multi's VNDBID matching

1.17 - 2008-06-21 (r33)
	- Added PS3 and Xbox 360 to platforms
	- Relation graph generation improvements: Unicode, anti-aliassing, async
	- Removed all passwords from the main code, and created a seperate config
	  file to override all options - not available on SVN
	- Dynamic loading, several bugfixes, and code cleanup for Multi
	- Added 'School Life' and 'Protagonist' categories
	- Time and Place categories are now boolean
	- Added GTIN field to releases
	- Added links to encubed and renai.us

1.16 - 2008-05-22
	- Release dates in the current year or month without a specified day will
	  be considered as not yet released
	- Added platform and language icons to the VN browser
	- Grouped producers, user stats and general information on the VN page
	- Added language icons to producer browser
	- A little CSS cleanup
	- Grouped category browser and search into one advanced search
	- Updated sitemap generator
	- Pattern matching bug fixes in Multi::IRC, and better handling of commands
	- Added .xml extention to all RSS URLs

1.15 - 2008-05-04
	- Relation graph now also updated on VN title change
	- Anime relations
	- [js] Position of the dropdown box is now relative to the link element
	- Used inline-block for icon image sprites (to avoid stupid float hacks)
	- Used icons to indicate the release status type on VN pages
	- Give a 'not logged in' dropdown edit box when the user isn't logged in
	- Fixed the redirects for old URLs
	- Designed a better system to handle documentation
	- Created a centralised system for site errors within the same layout
	- Wrote some more documentation
	- Multi::IRC now also handles d[0-9] IDs
	- Multi::Maintenance automatically rotates Multi's logs

1.14 - 2008-04-26
	- Removed the ID gap prevention method
	- Moved static content to static.vndb.org (and rely on lighty for js/css
	  compression)
	- relation graphs and cover images now get an ID instead of MD5-sum
	- Added Nintendo Wii to platforms
	- Added 'hidden' flag, which should now be used instead of the delete option
	- Fixed the ordering of nodes in the relation graphs
	- Used global.pl as the central location of the PgSQL login info
	- Wrote a daemon which handles several tasks:
	  - Generation of relation graphs
	  - Generation of the sitemap.xml.gz
	  - The IRC bot
	  - scaling/compressing of cover images
	  - General maintenance
	- Fixed bug with categories not being re-selected after an error submitting
	  a new VN
	- Relation graphs are now automatically updated when a change in a related
	  release causes information in the graph to be outdated

1.13 - 2008-04-04
	- Fixed update_prev
	- Split revision insert queries into a seperate function for code reuse
	- Fixed wiki links
	- Fixed search for VN's without releases
	- Fixed bug with accepting zero-padded VNDB ID's
	- Fixed bug with V-N.net link getting lost after reverse relation update
	- Added .xml extension to AJAX requests
	- Switched to ';' seperator instead of '&' for some URL's (=cleaner)
	- Added language filter to category browser
	- Stored release dates as integers and added NOT NULL constraint
	- Used a newline to seperate multiple relations on a VN	page
	- Multi will get credits for a reverse relation edit
	- Going to an edit-page without logging in will redirect
	- Added rankings to the categories
	- Fixed automated relation graph updates
	- Added /nospam page
	- Changed vote treshold to 3

1.12 - 2008-03-09
	- Color coded diffs
	- Added noindex on ?ref= pages
	- Added TBA to release dates
	- Possibility to change vote without revoking first
	- Added VN/ADV categories
	- Replaced the Release summary with Producers on VN pages
	- Added foreign key constrains

1.11 - 2008-02-29
	- [bug] Home page layout got screwed up when line wrapping occurs
	- [bug] Multiple revisions got counted at the category browser
	- Added GBA platform
	- Added Gameplay and Plot categories
	- Added link to V-N.net review
	- Added vote count to the global statistics in the main menu
	- [hidden] Added language filter to category browser
	- Created user pages
	- Redirect to VN page if someone visits an rX page from google/yahoo
	- Added link to latest revision in the diff-browser
	- Renamed "comments" to "Personal note" at VN List

1.10 - 2008-02-09
	- [bug] Long revision summaries incorrectly chopped
	- Added GD-ROM and Blu-ray disk to media
	- Platform icons will be kept in a consistent order
	- ?rev= pages now show information about the change + diffs + links to
	  previous/next revisions
	- Removed diff and revert links on history pages
	- Added rel="nofollow" to edit links
	- Changed lowest selectable year at releases to 1990
	- Use Bayesian ratings and added extra char to c_votes
	- A few small internal DB changes
	- Allowed [url]-tag in edit summary, and used same function to parse vn/p/r
	  descriptions
	- Added line wrapping on long words at diff-viewer
	- VN search matches on release titles again
	- Added producer search
	- [bug] Releases in the future don't count as new language
	- Release dates in the future are now red
	- multiple vns for releases
	- Redirect to specific revision after editing
	- Redirect to the page you were at after logging in
	- Added "Other" status and "comments" field to VN lists

1.9 - 2008-02-01
	- Redirect to VN when changing VN List status
	- [bug] All ages was not automatically selected
	- [bug] Description field ignored when adding or requesting edit of producer
	- Rewrote diff calculation
	- Added wildcard support to URI-mappings
	- Changed some URI's:
	  /vn/*         -> /v/*
	  /u/_*         -> /u/*
	  /u/[username] -> /u[uid]
	- id-gaps for producers and releases are now also filled automatically
	- Switched producers name and romaji
	- Added visitor as rank for non-logged in visitors, and losers for banned
	  users
	- Added history pages & feeds
	- Removed everything related to "pending changes"
	- Producers are lockable
	- Combined DBGetVN and DBGetVNs
	- Moved code for releases from VN.pm to Releases.pm
	- Denormalized vn_categories
	- Added "tabs" to visual novels, releases & producers
	- Made several changes to the visual novel page layout
	- Added mass-change/delete option to vnlists
	- Renamed vnr* to releases*
	- Fixed relation graphs generator to work with the new DB structure, and to
	  delete graphs for VN's where the relation was deleted
	- Removed option to hide a user from the userlist
	- ResDenied will show the regiser-new-account-page
	- Usernames linkified at history and vn-stats pages
	- Added noindex tag on pages that include usernames
	- Swapped title <-> romaji for releases
	- Removed relation field and added type field for releases
	- Also allow [url]-bbcode tag for the notes field for releases and producers
	- [bug] Self-refering vn relations are not possible anymore
	- Wrote update_vncache as a plpgsql function
	- Updated homepage layout: added a few lists 
	- Added filters to recent changes pages
	- Added platform icons to releases
	- Added user menu to vn pages
	- De-JS'ed the platform select form, used checkboxes instead
	- Updated FAQ

1.8 - 2007-12-05
	- Added [url]-tag to vn description field
	- Changed category input to checkboxes
	- Used image sprites for category browser icons
	- Fixed bug with media-select-form
	- Fixed bug with pending producer changes showing up in the producer search
	- Added hack to exclude trial versions in the release dates
	- Removed audience category and added age rating field to releases
	- Fixed typo: "game hes either" -> "game has either"
	- Added Wikipedia & CISVisual link
	- Added small vertical padding between releases
	- Added length of visual novel
	- Renamed continues back to Sequel/Prequel

1.7 - 2007-11-25
	- Bugfix: The visual novel itself is now also listed at the Pending Changes
	under the releases
	- Bugfix: Comments and Moderation subforms cannot be automatically hidden
	- Made release and vn-links in the edit-dropdown clickable, to edit all
	- Added "show all pending changes" option for moderators
	- Removed official (japanese) titles from producer list
	- Added description field for producers
	- Added a red asterisk for fields that are required
	- Combined 4 flag-columns in the users table to one
	- Added cronjob to delete unused relation graphs

1.6 - 2007-11-11
	- vnr.released accepts NULL
	- vn.c_years renamed to vn.c_released, and only stores year+month of first
	release
	- Removed vn_releases.lastmod
	- Fixed CSS bug in releases layout
	- Renamed Sequel/Prequel to Continuation/continues...
	- Added relation graphs (/vX/rg)

1.5 - 2007-11-04
	- Automatically hiding form parts is now done server-side
	- Release id's are hidden for not logged in visitors
	- Added cron job to compress images and remove Exif information
	- Possibility to add planned releases to 5 years in the future
	- Bugfix: When editing a VN that's waiting for moderation, the 'added'
	column won't be updated
	- Added NSFW-option to VN-images
	- Added small edit-dropdown when clicked on release-id
	- Pending changes tab for VN removed and contents moved to relations tab
	- Added Visual Novel Relations

1.4 - 2007-10-28
	- 'Mina' category renamed to 'All Ages'
	- Added 'Clear selection' button to the category browser
	- New visual novels will get unused/lower ID's
	- Added notes-field to releases
	- Subforms can be dynamically hidden/shown
	- Bugfix: user stats will always stay under the votes at /vX/stats
	- Bugfix: syntax error in dyna.js in Opera
	- Combined all the add/edit/del-buttons into one menu
	- Changed VN page layout: description moved to relations page and categories
	have their own sub-item

1.3 - 2007-10-21
	- Bugfix: checkbox at producer-search now works
	- VN ratings don't count of only one user has voted
	- Added VN list size and number of votes to user list
	- Added categories 'Drama' & 'Mystery'
	- Added exclude filters to the category browser
	- Added a few statistics to the right bottom of the page

1.2 - 2007-10-14
	- Bugfix: vnr_producers rows weren't deleted when deleting a release
	- Added number of pending changes at "Pending changes" menu item
	- Long items (>30 chars) at the top 5's (right bottom) will be shortened
	- Added visual novel descriptions to the RSS feed
	- Bugfix: fixed msg when browsing votes of someone who hasn't voted yet
	- Bugfix: Voting now also works when viewing the vote stats of a VN
	- Added user VN lists
	- Added profile option to hide VN list
	- Changed 'votes' tab on VN page to 'stats' and added user stats.

1.1 - 2007-10-07
	- Bugfix: you can now empty columns of the vn table
	- Japanese is automatically selected when adding a release or producer
	- User list has been made public
	- Possible to browse other people's votes
	- Added two options to "my account" to hide in user list and votes
	- Bugfix: username is now shown when accepting a producer
	- Bugfix: variable typo in tpl->pedit
	- Bugfix: c_*-update-function wasn't called correctly when changing/deleting
	releases
	- Bugfix: 'added' column in releases, vn and vnr is now updated at accepting
	- Added "Most Popular" vns to every page, and added "More..."-links.
	- Added RSS feed for recent additions
	- Changes visual novel page layout
	- Added vote graph + latest votes to the visual novel pages
	- Added compression on javascript files
	- Replaced relation-selection-box with an input field

1.0 - 2007-09-30
	- First release