Most recent edit on 2008-12-17 00:44:39 by SocksFan [Typo]
Additions:
$cats_query = 'SELECT * FROM `' . $this->config['table_prefix'] . 'pages` WHERE `body`=\'\{\{category\}\}\ . $unwanted_categories;
Deletions:
$cats_query = 'SELECT * FROM `' . $this->config['table_prefix'] . 'pages` WHERE `body`=\'\{\{category\}\}\ . $unwanted_cateogories;
Edited on 2008-12-17 00:30:41 by SocksFan
Additions:
Related Pages Action
I was pretty surprised that there was no related-pages action that allowed the wiki to "guess" which pages were related to a certain page and link to them. After creating my wiki pages and linking manually to other pages, I realized quickly that it would get out of hand if I did not do something to automate the process - which is detailed below. What this action does is it "guesses" which wiki pages are related to the current page and it will produce a list of links to them.
The way it works is through categories: the action will first determine which pages are categories, and then which categories the current page belongs to. It will then select an X amount of pages from those categories and link to them (X amount - default is 5, though it can be specified). As just stated, you can specify the amount and also "template" which changes the way the action spits out the list; the two current methods are through just regular new lines and through <li> elements (bullet points) in HTML. Default is through new lines.
The action is called through: {{related}}, or with parameters: {{related max="10" template="li"}}
"Max" can be specified to any number - if left blank, it will spit out the default amount of 5; "template" can be set to "li" for bullet points, or it can be left blank for new lines.
This action also requires the use of the modified PageTitle() function in wikka.php, which was edited in the action: LinkUsingPageTitle. The edited PageTitle() function will be posted below as well. Because it uses the modified PageTitle function, the outputted links will be displayed as Page Title as opposed to PageTitle.
Create and save to /actions/related.php
<?
$unwanted_categories =
'';
$tag =
$this->
getPageTag( );
$tag =
$this->
LoadPage( $tag );
$tag =
$tag['tag'];
$max =
( empty( $vars['max'] ) ) ?
5 :
$vars['max'];
$cats_query =
'SELECT * FROM `' .
$this->
config['table_prefix'] .
'pages` WHERE `body`=\'\{\{category\}\}\'' .
$unwanted_cateogories;
$cats_query =
mysql_query( $cats_query );
while( $a =
mysql_fetch_array( $cats_query ) )
{
if( $i ==
0 )
{
$query_build =
'WHERE `to_tag`=\'' .
$a[1] .
'\' AND `from_tag`=\'' .
$tag .
'\'';
}
else
{
$query_build .=
' OR `to_tag`=\'' .
$a[1] .
'\' AND `from_tag`=\'' .
$tag .
'\'';
}
$i++;
}
$page_query =
'SELECT * FROM `' .
$this->
config['table_prefix'] .
'links` ' .
$query_build;
$page_query =
mysql_query( $page_query );
while( $q =
mysql_fetch_array( $page_query ) )
{
$cats[] =
$q[1];
}
for( $i =
0;
$i <
count( $cats );
$i++
)
{
if( $i ==
0 ) { $query_build =
'WHERE `to_tag`=\'' .
$cats[ $i ] .
'\'';
}
else{ $query_build .=
' OR `to_tag`=\'' .
$cats[ $i ] .
'\'';
}
}
$page_links =
'SELECT * FROM `' .
$this->
config['table_prefix'] .
'links` ' .
$query_build .
' AND `from_tag`!=\'' .
$tag .
'\' LIMIT ' .
$max;
$page_links =
mysql_query( $page_links );
while( $h =
mysql_fetch_array( $page_links ) )
{
$site_tag =
$h[0];
$page_info =
$this->
LoadPage( $site_tag );
$text =
$this->
PageTitle($page_info['body'],
'yes');
if($text ==
'') $text =
$site_tag;
switch( $vars['template'] )
{
default:
$link .=
$this->
Link( $site_tag,
'',
$text ) .
'<br />';
break;
case 'li':
$link .=
'<li>' .
$this->
Link( $site_tag,
'',
$text ) .
'</li>';
break;
}
}
echo $link;
?>
As stated above, the above action uses a modified PageTitle() function in /libs/Wakka.class.php. Find and replace function PageTitle() with:
function PageTitle
($text=
'',
$link=
'no') {
$title =
"";
// Edit by Stefan Koopmanschap: argument should be possible
if($text==
'') {
$pagecontent =
$this->
page["body"];
} else {
$pagecontent =
$text;
}
if (ereg( "(=){3,5}([^=\n]+)(=){3,5}",
$pagecontent,
$title)) {
$formatting_tags =
array("**",
"//",
"__",
"##",
"''",
"++",
"#%",
"@@",
"\"\"");
$title =
str_replace($formatting_tags,
"",
$title[2]);
}
// if ($title) return strip_tags($this->Format($title)); # fix for forced links in heading
if ($title) return $title;
else {
if($link==
'no') {
return $this->
GetPageTag();
} else {
return '';
}
}
}
Again, this modified PageTitle() function is originally from LinkUsingPageTitle.
Blocking Categories from Being Listed
On my Wiki, I have a few categories that I didn't want to be listed by this action. This is how I barred the action from listing pages in those categories:
$unwanted_categories = ' AND `tag`!=\'CategoryUnfinished\' AND `tag`!=\'CategoryReviewRequest\'';
The variable is defined as a continuing mysql query.
--SocksFan
CategoryUserContributions
Deletions:
xxxxx Action
See also:
Documentation: xxxxxActionInfo.This is the development page for the xxxxx action.
This page is a template. It belongs to CategoryTemplate (which contains more handy templates). To create an action development page, clone this page∞ to a page called xxxxxAction (where xxxxx is the (capitalized) name of the action), replace all occurrences of 'xxxxx' with the name of the action and replace this paragraph with the actual content.
CategoryDevelopmentActions
Oldest known version of this page was edited on 2008-12-16 23:54:52 by SocksFan [Cloned from ActionTemplate]
Page view:
xxxxx Action
See also:
Documentation: xxxxxActionInfo.This is the development page for the xxxxx action.
This page is a template. It belongs to CategoryTemplate (which contains more handy templates). To create an action development page, clone this page∞ to a page called xxxxxAction (where xxxxx is the (capitalized) name of the action), replace all occurrences of 'xxxxx' with the name of the action and replace this paragraph with the actual content.
CategoryDevelopmentActions