Revision [16931]

This is an old revision of JamesMcl made by JamesMcl on 2007-05-31 23:27:22.

 

Hi there.
As you've probably guessed my name is James and I'm from Edinburgh in Scotland.
I am interested in Wikka following on from my brief experience with Wakka, which now appears to be defunct.

Wakka like Wikka was being developed to include similar features to those that are being discussed and developed on this site. One developer was TomG who had managed to develop the code to include user groups, e-mail, registration and administration functions.

One of Tom's sites can be seen at Soul Dynamics

Hi James. Any progress on generating a PDF file output from wikka? -- Mike Bowen (GmBowen)

http://www.jamesmcl.co.uk/fpdf/try_pdf.php
As you can see it picks the Page Name and Content fromm the database alright. The script needs a little refinement to format the page layout correctly and as I said earlier to restrict the results set from the sl query. The code is below.

<?php
define('FPDF_FONTPATH','font/');
require('mysql_table.php');

class PDF extends PDF_MySQL_Table
{
function Header()
{
	//Title
	$this->SetFont('Arial','',18);
	$this->Cell(0,6,'Wikka Output To PDF',0,1,'C');
	$this->Ln(10);
	//Ensure table header is output
	parent::Header();
}
}

//Connect to database
mysql_connect('localhost','user','password');
mysql_select_db('dbname');


$pdf=new PDF();
$pdf->Open();
$pdf->AddPage();
//First table: put all columns automatically
$pdf->Table('select tag,body from main_wikka_pages');
$pdf->AddPage();
//Second table: specify 2 columns,
$pdf->AddCol('tag',50,'tag','C');
$pdf->AddCol('body',50,'body','C');
$prop=array('HeaderColor'=>array(255,150,100),
			'color1'=>array(210,245,255),
			'color2'=>array(255,255,210),
			'padding'=>2);
//$pdf->Table('select tag,body from main_wikka_pages order by tag limit 0,10',$prop);
$pdf->Output(wikka,I);
?>


Thanks James. I've got an undergrad programmer hired for a few weeks in May....and I found the pdf generating code for wikini as well (which is now only in a google cache).....so I'm probably going to have him try and get pdf output working (using a handler). I found a "footnoting/endnoting" action for wikini too, so I'll get him working on that also. When either are working I'll post them up (um, I hope this is okay and you don't feel like your efforts are being hi-jacked.....some people are really touchy about such things, but I really do need PDF output from wikka.). Cheers. --GmBowen


CategoryUsers
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki