and some blatant self-promotion: an interview with the antville creators is currently online at netzeitung.de.

Hi,

just noticed that it's not easily possible to generate a link to a specific comment without displaying the title. I wanted to display the comment in the recently modified area with e.g. a [more] link. <% this.link text="[more]" %> in the item skin renders incorrect urls for comments, using a / instead of a #.

and, <% this.url %> for comments has a small typo, using twice the prefix and no suffix:

function url_macro(param) { res.write(param.prefix); res.write(this.story.href() + "#" + this._id); res.write(param.prefix); }

to ensure that antville works with other databases than mysql in the backend we must change table- and column-names to avoid the use of reserved words (eg. "USER" is a reserved word in oracle and PostgreSQL). therefor i'd like to propose the following naming-convention:

• every table's name is prefixed with "AV_" (for "Antville").
• every column-name is prefixed with a three-character abbreviation of the table-name this column belongs to (plus some of the tables are renamed too): ACC_ in table AV_ACCESSLOG CHO_ in table AV_CHOICE FIL_ in table AV_FILE (the former GOODIE-table) IMG_ in table AV_IMAGE MBS_ in table AV_MEMBERSHIP (the former MEMBER-table) PLL_ in table AV_POLL SKN_ in table AV_SKIN SLG_ in table AV_SYSLOG TXT_ in table AV_TXT USR_ in table AV_USER VTE_ in table AV_VOTE SIT_ in table AV_SITE (the former WEBLOG-table)
• primary keys are named [table-abbreviation]_ID
• foreign keys are named [table-abbreviation]_F_[foreign table][_meaning], eg. IMG_F_USR_CREATOR, TXT_F_SIT, TXT_F_TXT_STORY, IMG_F_IMG_THUMB etc. (as an alternative, foreign keys could also be named as they're now (plus the abbreviation-prefix), but i personally think it's less consistent: think of TXT_CREATOR which actually references a record in the usertable). anyway, this is imo one of the points we should discuss

as a result the following prototypes should be renamed:

• weblog -> site
• goodie -> file (although this could easily be confused with File i agree with hns that it's easier to understand for users)
• member -> membership
• membership -> membermgr (the mountpoint "members" stays the same)

and for consistency-reasons the column AUTHOR in AV_TEXT should be renamed to TXT_F_USR_CREATOR (this is the only occurrence of AUTHOR in the whole db-structure).

please let me know what you think about it.

links: Oracle Reserved Words (v.9i) SQL Key Words (PostgreSQL) MySQL Reserved words

inside

i just checkd into cvs the file messages_en.js which contains the edited messages.

please read through the text and let me know if this generally is the right direction we're aiming at. myself, i am not fully satisfied with the result. i tried to add instructional texts wherever i thought it would be necessary and i had an idea of where the message would appear. but some messages could fail in their context, so i am currently testing out misbehaviour and its results.

i also added some comments, mostly about condensing two texts into one message. could be that there are even more possibilities like that. what do you think about it?

the new parameters as="popup" and as="thumbnail" in the image macro fail if the image doesn't have a thumbnail. why don't you make the creation of thumbnails a default and not an option? i can't think of any situation where someone doesn't want to create a thumbnails.

also: the possibility to change the image name can result in data loss. imagine i upload a gif called "image1". its filename will be "image1.gif". i can rename the image name into "image2", but the filename will remain "image1.gif". the image file will be overwritten when i upload a new gif called "image1". i propose that only alt-attribute of an image should be editable. the image name is not that important and if you want to change the name you can always delete it and upload it with a new name.

(when you change the image scripts here is an old related suggestion.)

What is the state of the current Anville version from the CVS? The version I installed about two weeks ago has some undefined macros and i want to replace it. Is this a good idea or is it better to wait for a couple of days?