Extension talk:CategoryLink

• v1.5 Archive

Archive

I archived discussion relating to the older version Kyle van der Meer 16:42, 10 February 2010 (UTC)

Forked code (refactored, more configurable)

Hi Kyle, thanks for this extension. I needed to fork it for my purposes and thought you and your users might find it usefull. All I did is that I threw out dependecy on external CSS, cleaned the main cycle and added few variables for strings. Use it as you wish. My changed printcategorylinks() function looks like this:

     function printcategorylinks() {
		/* begin config */
                $columns = 3;//change this number to the number of columns you want.
		$html_list_begin = "\n\t\t".'<table class="category_link">';
		$html_list_end = "\n\t\t".'</table>';
		$html_line_begin = "\n\t\t\t".'<tr>';
		$html_line_end = "\n\t\t\t".'</tr>';
		$html_cell_begin = "\n\t\t\t\t".'<td style="vertical-align: top; padding-right: 20px; font-size: 120%;">';
		$html_cell_end = '</td>';
		$html_emptycell_placeholder = "<span class=\"empty\"> </span>";

		/* end config */

                global $wgDBuser,$wgDBpassword, $wgDBname,$wgDBserver,$IP, $wgDBprefix;
                $link = mysql_connect($wgDBserver, $wgDBuser, $wgDBpassword)
			or die('Could not connect: ' . mysql_error());
                mysql_select_db($wgDBname) 
			or die('Could not select database');
                $query = 'SELECT DISTINCT cl_to FROM '.$wgDBprefix.'categorylinks';
                $result = mysql_query($query) 
			or die('Query failed: ' . mysql_error());
                $cell_count = 0;
		
		$output = $html_list_begin;
		$output .= $html_line_begin;
                while($row = mysql_fetch_row($result)) {
                        $category_code = $row[0];
			$category_name = preg_replace("/_/"," ",$row[0]);

			$output .= $html_cell_begin."\n\t\t\t\t".'<a href="../index.php/Category:'.$category_code.'">'.$category_name."</a>".$html_cell_end;
 			$cell_count++;
			if($cell_count%$columns==0)
				$output .= $html_line_end.$html_line_begin;
		}

		for($i=($columns - $cell_count%$columns)%$columns; $i>0; $i--)
			$output .= $html_cell_begin . $html_emptycell_placeholder . $html_cell_end;

		$output .= $html_line_end;
                $output .= $html_list_end;

		return (''.$output.'');
        }