View Issue Details

IDProjectCategoryView StatusLast Update
0000434HTML & PERLFeature Request - Interfacepublic2007-03-31 17:12
ReporterGambit Assigned Toexp  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Summary0000434: reviews / content formatting: Link to other reviews
Description(Author: devildoll)

It is characteristic for my reviewing style to compare anime to other anime, and to build some semantic network amongst related anime (whatever I consider "related").

As support this method within my reviews in aniDB I'd like to have the ability to link to other aniDB reviews (of the same reviewer) within the content of my reviews. Just that - no complete HTML code support.

Let's make an example. I want to link to my review for Aa! Megami-sama The Movie (id: 206) within my review from Aa! Megami-sama OVA (id: 27).

The meta code might look something like
Code:
[review:206]

and would have to be resolved to

http://anidb.info/perl-bin/animedb.pl?show=animeatt&aid=206#2452


Deriving the "AA! Megami-sama - The Movie" string from the id "206" should be no problem.

The tricky thing would be to derive the "2452" from two other data - the "206" (which is the ID of the anime being reviewed) and the "73514" (which happens to be the userid of the user who wrote this review - this information is available in the context of the content where the meta tag were to be interpreted).

Apparently the link targets for reviews are created by some auto-increment column used as primary key for the reviews; it would have been much more flexible to use the pair of reviewer userid and series id as the primary key, and then generate the links from this pair of data (there can be no more than one review per reviewer in a review page, right? So <a name="userid"></a> would work fine as unique link target instead of <a name="review_primary_key"></a> ).

As things are now it might be difficult to change the (assumed) SQL table format to provide the additional information required for the link generation I'd like to have, but there's hope even for this (if my feature request were considered useful, that is). But if the required database changes were considered too complex then I'd be fine with an alternative syntax like
Code:
[review:206#2452]AA! Megami-sama - The Movie[/review]

, i. e. having to supply all required information myself in the meta code.

It would be cool if the generator would check whether the review that serves as link target actually exists (and generate some string like "invalid reference to review for anime 206 by user 73514" instead if it doesn't) but I'm fine with not doing so as to save CPU time for the additional database access (a link to an unknown target would be handled appropriately by all known web browsers).
Additional Informationhttp://www.anidb.net/forum/viewtopic.php?t=3826

Exp:
I am in favor of this style:
Code:
[review:206#2452]AA! Megami-sama - The Movie[/review]



it puts less strain on the database and allows for more flexibility @ link naming.
feel free to create a tracker item :P
TagsNo tags attached.

Relationships

related to 0000227 resolvedexp More bbcode style internal links. 
related to 0000451 resolvedexp Link to review, instead of review-page 
child of 0000498 resolvedRar Use custom markup for all non-trivial text fields in AniDB 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2006-07-21 06:29 DerIdiot New Issue
2006-07-21 06:30 DerIdiot Description Updated
2006-07-21 06:30 DerIdiot Relationship added related to 0000227
2006-07-21 06:30 DerIdiot Assigned To => exp
2006-07-21 06:30 DerIdiot Status new => acknowledged
2006-07-21 06:30 DerIdiot Additional Information Updated
2006-07-21 23:04 fahrenheit Relationship added related to 0000451
2006-07-22 05:29 DerIdiot Reporter DerIdiot => Gambit
2006-08-02 19:35 Rar Relationship added child of 0000498
2007-03-31 17:12 epoximator Status acknowledged => resolved
2007-03-31 17:12 epoximator Resolution open => fixed