You might want to display all comments, and this script will retrieve them:
Wiki Output Sample Copy to clipboard {LIST(cache="n")}
{filter type="comment"}
{pagination max="10"}
{OUTPUT( template="table")}
{column field="title"}
{column field="comment_content"}
{column field="object_link" mode="raw"}
{column field="date"}
{OUTPUT}
{FORMAT( name="object_link")}
{display name="object_id" format="objectlink"}
{FORMAT}
{sort mode="date_desc"}
{LIST}
The FORMAT control block defines an object with the name object_link which is displayed in such a way that it is object_id which is displayed and formatted as objectlink; which makes the id clickable. This object reference is then used in the column control block in the body of the OUTPUT table.
This gives us the following result:
Title
|
Comment
|
Thread Id
|
Date
|
Re: Border in {img}? |
The HTML img border tag is deprecated and so isn't recommended. CSS is the modern way to give an image a border. Currently (as of Tiki 1.10 anyway) the Quicktag image syntax includes a "class" argument, so it would be easy to add a "borderimage" (or something) class to your stylesheet specifying a border that suits you, and you'd get a whole lot more control than with HTML. 😊. |
596 |
2008-02-21 06:47:00 |
Border in {img}? |
Been searching all over tw.o and doc.tw.o for any mention of the BORDER modifier in the syntax, which does not appear be included. I've seen the ^ tag used to frame images, but it leaves whitespace around the image, so isn't quite the same thing. Was this left out for a reason? Does everyone just use HTML when they want a border? |
595 |
2008-02-14 19:34:48 |
Syntax Pages List Incomplete - Found Orphaned 'Heading' Page |
While trying to learn Tiki syntax, I found this (apparently orphaned) page: http://doc.tikiwiki.org/tiki-index_raw.php?page=Wiki-Syntax+Separators&highlight=syntax%20heading It has syntax information not listed in the other syntax pages. I would have plugged it in, but the syntax pages are linked with a (TOC) element, and I have not figured that out yet |
592 |
2008-02-14 02:09:39 |
textarea usage |
😑 When you add a field as a textarea, then TIKI should allow you to use the functionality similar to Tiki pages where you can bold, colour, change font etc for the contents of that textarea. |
590 |
2008-02-04 19:39:45 |
Comment on Overview |
The documentation reads: Each tracker has its own mini database. Is this actually correct? Is a new MySQL database set up for each tracker OR is it that a NEW TABLE withing the existing MySQL database is set up. Having a table set up would be much more logical in my opinion. perhaps this needs to be corrected?? I'd like to hear from someone as to which is correct. |
589 |
2008-02-04 17:29:03 |
some more bugs |
There is some problems when I include anything else except text in an expandable area, for example html tables. The next item is interpreted as a part of previos one. |
588 |
2008-01-27 12:16:15 |
You can enable that permission setting in apache |
I use cPanel. Could you please state these instructions in cPanel terms? I have phpMyAdmin, not apache. Please help. Thanks. |
581 |
2008-01-10 18:15:26 |
Re: Page image bugs |
fixed picture not found img/icons2/alert.gif Thanks! |
565 |
2007-12-13 10:29:58 |
Non-fatal errors during ugrade |
Moving from 1.9.8.3 to 1.10 (3rd Dec) gives a lot of error messages - AFAICS all the ones I saw could be ignored as the changes had already been applied. It would be nice if the setup could detect this a bit more cleanly. MySQL 5.0.45, table type is MYISAM, results are based on post install checks 1) Command: ALTER IGNORE TABLE tiki_comments ADD UNIQUE parentId(parentId, userName, title, commentDate, message_id, in_reply_to) Message: Specified key was too long; max key length is 1000 bytes - Index currently exists as 'no_repeats' with this structure 2) Command: #2005-10-24 sylvieg to boost tiki_stats and tiki_orphan CREATE INDEX toPage on tiki_links (toPage) Message: Duplicate key name 'toPage' - index already exists with this structure 3) Command: #2005-10-25 sylvieg sped up refresh index CREATE INDEX locationPage on tiki_searchindex (location, page) Message: Specified key was too long; max key length is 1000 bytes - index currently exists as 'location' with this structure 4) Command: #2005-11-14 sylvieg CREATE INDEX positionType ON tiki_modules (position, type) Message: Duplicate key name 'positionType' - index currently exists with this structure 5) Command: CREATE INDEX login ON users_users (login) Message: Duplicate key name 'login' - index already exists with this structure 6) Command: # 2006-06-07 sylvieg (merge from 1.9) insert into users_permissions (permName,permDesc,level,type) values ('tiki_p_admin_objects','Can edit object permissions', 'admin', 'tiki') Message: Duplicate entry 'tiki_p_admin_objects' for key 1 - row already exists 7) Command: insert into users_permissions (permName,permDesc,level,type) values ('tiki_p_admin_polls','Can admin polls', 'admin', 'tiki') Message: Duplicate entry 'tiki_p_admin_polls' for key 1 - row already exists 8) Command: INSERT INTO users_permissions (permName,permDesc,level,type) values ('tiki_p_admin_rssmodules','Can admin rss modules', 'admin', 'tiki') Message: Duplicate entry 'tiki_p_admin_rssmodules' for key 1 - row already exists 9) Command: #sylvieg 2006-12-08 ALTER TABLE tiki_objects ADD KEY type (type, objectId) Message: Duplicate key name 'type' - index already exists but with structure 'type','itemId' 10) Command: ALTER TABLE tiki_comments DROP KEY parentId Message: Can't DROP 'parentId'; check that column/key exists - no such index - see 1 above 11) Command: ALTER TABLE tiki_comments DROP KEY parentId_2 Message: Can't DROP 'parentId_2'; check that column/key exists Command: ALTER TABLE tiki_comments DROP KEY parentId_3 Message: Can't DROP 'parentId_3'; check that column/key exists Command: ALTER TABLE tiki_comments DROP KEY parentId_4 Message: Can't DROP 'parentId_4'; check that column/key exists Command: ALTER TABLE tiki_comments DROP KEY parentId_5 Message: Can't DROP 'parentId_5'; check that column/key exists Command: ALTER TABLE tiki_comments DROP KEY parentId_6 Message: Can't DROP 'parentId_6'; check that column/key exists Command: ALTER TABLE tiki_comments DROP KEY parentId_8 Message: Can't DROP 'parentId_8'; check that column/key exists - keys do not exist 12) Command: ALTER TABLE tiki_comments DROP KEY no_repeats Message: Can't DROP 'no_repeats'; check that column/key exists - ? see 1 above. Was this created later? 13) Command: alter table tiki_comments change userName userName varchar(200) not null default '' Message: Specified key was too long; max key length is 1000 bytes - Error seems incongruous since 200 |
548 |
2007-12-03 15:05:14 |
Re: Not in my install |
> I've just done a clean install of v1.9.8.3, and there is no WYSIWYG editor in the features, no FCKeditor dir in lib/ > > 🙁 > Note at the top of the documentation page for this feature that it says Since version 1.10, Tikiwiki includes a Wysiwyg... 1.9.8.x still uses the normal editor. You need to upgrade to 1.10 in order to use the new one. Mike. |
547 |
2007-11-29 21:55:35 |
We see that this only gives us the information about the object (the comment in this case), but what if I want to have more information before visiting the comment?
One way to do this is to add a column which indicates the item being commented on. It is typically a wiki page or tracker item which is clickable and takes me there.
So let's make some changes and see what we have:
Wiki Output Sample Copy to clipboard {LIST(cache="n")}
{filter type="comment"}
{pagination max="10"}
{OUTPUT( template="table")}
{column field="contributors"}
{column field="title"}
{column field="comment_content"}
{column field="parent_object_title" mode="raw"}
{column field="object_link" mode="raw"}
{column field="date"}
{OUTPUT}
{FORMAT( name="object_link")}
{display name="object_id" format="objectlink"}
{FORMAT}
{FORMAT( name="parent_object_title")}
{display name="parent_object_type"}: {display name="wikiplugin_objectlink" format="wikiplugin" type="parent_object_type" id="parent_object_id"}
{FORMAT}
{sort mode="date_desc"}
{LIST}
Here we have just added a new column whose label is "Parent Object".
The new FORMAT control block formats the parent_object_title field, which is the title of the comment's parent object, then with {display} tag we first display the name of the parent object, which is stored in the parent_object_type field. For example, if the parent object is a trackeritem, it will display "trackeritem:", and finally we display the link to the parent object, using the wikiplugin_objectlink plugin. This plugin allows you to create a link to a Tiki object according to its type and its identifier. Here you specify the link format as "wikiplugin", the object type as parent_object_type, and the object id as parent_object_id. For example, if the parent object is a trackeritem with id 1, this will generate a link to "tiki-view_tracker_item.php?itemId=1".
So you get a field that displays the name and link of the comment's parent object. For example, if the comment is linked to an item called "This is my first item", you display "trackeritem: This is my first item".
This gives us the following result:
Title
|
Comment
|
Parent Object
|
Thread Id
|
Date
|
Re: Border in {img}? |
The HTML img border tag is deprecated and so isn't recommended. CSS is the modern way to give an image a border. Currently (as of Tiki 1.10 anyway) the Quicktag image syntax includes a "class" argument, so it would be easy to add a "borderimage" (or something) class to your stylesheet specifying a border that suits you, and you'd get a whole lot more control than with HTML. 😊. |
wiki page: Wiki-Syntax Images |
596 |
2008-02-21 06:47:00 |
Border in {img}? |
Been searching all over tw.o and doc.tw.o for any mention of the BORDER modifier in the syntax, which does not appear be included. I've seen the ^ tag used to frame images, but it leaves whitespace around the image, so isn't quite the same thing. Was this left out for a reason? Does everyone just use HTML when they want a border? |
wiki page: Wiki-Syntax Images |
595 |
2008-02-14 19:34:48 |
Syntax Pages List Incomplete - Found Orphaned 'Heading' Page |
While trying to learn Tiki syntax, I found this (apparently orphaned) page: http://doc.tikiwiki.org/tiki-index_raw.php?page=Wiki-Syntax+Separators&highlight=syntax%20heading It has syntax information not listed in the other syntax pages. I would have plugged it in, but the syntax pages are linked with a (TOC) element, and I have not figured that out yet |
wiki page: Using Wiki Pages |
592 |
2008-02-14 02:09:39 |
textarea usage |
😑 When you add a field as a textarea, then TIKI should allow you to use the functionality similar to Tiki pages where you can bold, colour, change font etc for the contents of that textarea. |
wiki page: Tracker User |
590 |
2008-02-04 19:39:45 |
Comment on Overview |
The documentation reads: Each tracker has its own mini database. Is this actually correct? Is a new MySQL database set up for each tracker OR is it that a NEW TABLE withing the existing MySQL database is set up. Having a table set up would be much more logical in my opinion. perhaps this needs to be corrected?? I'd like to hear from someone as to which is correct. |
wiki page: Trackers |
589 |
2008-02-04 17:29:03 |
some more bugs |
There is some problems when I include anything else except text in an expandable area, for example html tables. The next item is interpreted as a part of previos one. |
wiki page: Wiki-Syntax Lists |
588 |
2008-01-27 12:16:15 |
You can enable that permission setting in apache |
I use cPanel. Could you please state these instructions in cPanel terms? I have phpMyAdmin, not apache. Please help. Thanks. |
wiki page: Mods Admin |
581 |
2008-01-10 18:15:26 |
Re: Page image bugs |
fixed picture not found img/icons2/alert.gif Thanks! |
wiki page: Wiki-Syntax Lists |
565 |
2007-12-13 10:29:58 |
Non-fatal errors during ugrade |
Moving from 1.9.8.3 to 1.10 (3rd Dec) gives a lot of error messages - AFAICS all the ones I saw could be ignored as the changes had already been applied. It would be nice if the setup could detect this a bit more cleanly. MySQL 5.0.45, table type is MYISAM, results are based on post install checks 1) Command: ALTER IGNORE TABLE tiki_comments ADD UNIQUE parentId(parentId, userName, title, commentDate, message_id, in_reply_to) Message: Specified key was too long; max key length is 1000 bytes - Index currently exists as 'no_repeats' with this structure 2) Command: #2005-10-24 sylvieg to boost tiki_stats and tiki_orphan CREATE INDEX toPage on tiki_links (toPage) Message: Duplicate key name 'toPage' - index already exists with this structure 3) Command: #2005-10-25 sylvieg sped up refresh index CREATE INDEX locationPage on tiki_searchindex (location, page) Message: Specified key was too long; max key length is 1000 bytes - index currently exists as 'location' with this structure 4) Command: #2005-11-14 sylvieg CREATE INDEX positionType ON tiki_modules (position, type) Message: Duplicate key name 'positionType' - index currently exists with this structure 5) Command: CREATE INDEX login ON users_users (login) Message: Duplicate key name 'login' - index already exists with this structure 6) Command: # 2006-06-07 sylvieg (merge from 1.9) insert into users_permissions (permName,permDesc,level,type) values ('tiki_p_admin_objects','Can edit object permissions', 'admin', 'tiki') Message: Duplicate entry 'tiki_p_admin_objects' for key 1 - row already exists 7) Command: insert into users_permissions (permName,permDesc,level,type) values ('tiki_p_admin_polls','Can admin polls', 'admin', 'tiki') Message: Duplicate entry 'tiki_p_admin_polls' for key 1 - row already exists 8) Command: INSERT INTO users_permissions (permName,permDesc,level,type) values ('tiki_p_admin_rssmodules','Can admin rss modules', 'admin', 'tiki') Message: Duplicate entry 'tiki_p_admin_rssmodules' for key 1 - row already exists 9) Command: #sylvieg 2006-12-08 ALTER TABLE tiki_objects ADD KEY type (type, objectId) Message: Duplicate key name 'type' - index already exists but with structure 'type','itemId' 10) Command: ALTER TABLE tiki_comments DROP KEY parentId Message: Can't DROP 'parentId'; check that column/key exists - no such index - see 1 above 11) Command: ALTER TABLE tiki_comments DROP KEY parentId_2 Message: Can't DROP 'parentId_2'; check that column/key exists Command: ALTER TABLE tiki_comments DROP KEY parentId_3 Message: Can't DROP 'parentId_3'; check that column/key exists Command: ALTER TABLE tiki_comments DROP KEY parentId_4 Message: Can't DROP 'parentId_4'; check that column/key exists Command: ALTER TABLE tiki_comments DROP KEY parentId_5 Message: Can't DROP 'parentId_5'; check that column/key exists Command: ALTER TABLE tiki_comments DROP KEY parentId_6 Message: Can't DROP 'parentId_6'; check that column/key exists Command: ALTER TABLE tiki_comments DROP KEY parentId_8 Message: Can't DROP 'parentId_8'; check that column/key exists - keys do not exist 12) Command: ALTER TABLE tiki_comments DROP KEY no_repeats Message: Can't DROP 'no_repeats'; check that column/key exists - ? see 1 above. Was this created later? 13) Command: alter table tiki_comments change userName userName varchar(200) not null default '' Message: Specified key was too long; max key length is 1000 bytes - Error seems incongruous since 200 |
wiki page: Upgrade 1.9.7 to 1.10 |
548 |
2007-12-03 15:05:14 |
Re: Not in my install |
> I've just done a clean install of v1.9.8.3, and there is no WYSIWYG editor in the features, no FCKeditor dir in lib/ > > 🙁 > Note at the top of the documentation page for this feature that it says Since version 1.10, Tikiwiki includes a Wysiwyg... 1.9.8.x still uses the normal editor. You need to upgrade to 1.10 in order to use the new one. Mike. |
wiki page: Wysiwyg Editor Admin |
547 |
2007-11-29 21:55:35 |
|