<?php require 'newsletter.inc.php'; ?>

<?php

/* This structure encodes the difference between ISO-8859-1 and Windows-1252,

as a map from the UTF-8 encoding of some ISO-8859-1 control characters to

the UTF-8 encoding of the non-control characters that Windows-1252 places

at the equivalent code points. */

$cp1252_map = array(

"\xc2\x80" => "\xe2\x82\xac", /* EURO SIGN */

"\xc2\x82" => "\xe2\x80\x9a", /* SINGLE LOW-9 QUOTATION MARK */

"\xc2\x83" => "\xc6\x92", /* LATIN SMALL LETTER F WITH HOOK */

"\xc2\x84" => "\xe2\x80\x9e", /* DOUBLE LOW-9 QUOTATION MARK */

"\xc2\x85" => "\xe2\x80\xa6", /* HORIZONTAL ELLIPSIS */

"\xc2\x86" => "\xe2\x80\xa0", /* DAGGER */

"\xc2\x87" => "\xe2\x80\xa1", /* DOUBLE DAGGER */

"\xc2\x88" => "\xcb\x86", /* MODIFIER LETTER CIRCUMFLEX ACCENT */

"\xc2\x89" => "\xe2\x80\xb0", /* PER MILLE SIGN */

"\xc2\x8a" => "\xc5\xa0", /* LATIN CAPITAL LETTER S WITH CARON */

"\xc2\x8b" => "\xe2\x80\xb9", /* SINGLE LEFT-POINTING ANGLE QUOTATION */

"\xc2\x8c" => "\xc5\x92", /* LATIN CAPITAL LIGATURE OE */

"\xc2\x8e" => "\xc5\xbd", /* LATIN CAPITAL LETTER Z WITH CARON */

"\xc2\x91" => "\xe2\x80\x98", /* LEFT SINGLE QUOTATION MARK */

"\xc2\x92" => "\xe2\x80\x99", /* RIGHT SINGLE QUOTATION MARK */

"\xc2\x93" => "\xe2\x80\x9c", /* LEFT DOUBLE QUOTATION MARK */

"\xc2\x94" => "\xe2\x80\x9d", /* RIGHT DOUBLE QUOTATION MARK */

"\xc2\x95" => "\xe2\x80\xa2", /* BULLET */

"\xc2\x96" => "\xe2\x80\x93", /* EN DASH */

"\xc2\x97" => "\xe2\x80\x94", /* EM DASH */

"\xc2\x98" => "\xcb\x9c", /* SMALL TILDE */

"\xc2\x99" => "\xe2\x84\xa2", /* TRADE MARK SIGN */

"\xc2\x9a" => "\xc5\xa1", /* LATIN SMALL LETTER S WITH CARON */

"\xc2\x9b" => "\xe2\x80\xba", /* SINGLE RIGHT-POINTING ANGLE QUOTATION*/

"\xc2\x9c" => "\xc5\x93", /* LATIN SMALL LIGATURE OE */

"\xc2\x9e" => "\xc5\xbe", /* LATIN SMALL LETTER Z WITH CARON */

"\xc2\x9f" => "\xc5\xb8" /* LATIN CAPITAL LETTER Y WITH DIAERESIS*/

);

function cp1252_to_utf8($str) {

global $cp1252_map;

return strtr(utf8_encode($str), $cp1252_map);

}

class RtfGenerator

}

$generator = new RtfGenerator($con);

$db = (!isset($_GET['db']) || $_GET['db'] == '') ? 'newsletter': $_GET['db'];

$table = (!isset($_GET['table']) || $_GET['table'] == '') ? 'documents' : $_GET['table'];

$col = (!isset($_GET['col']) || $_GET['col'] == '') ? 'data' : $_GET['col'];

//$random = $_GET['random'] == '' ? date('Ymd_His') : $_GET['random'];

// Changed above to below, RJL 26/1/09

$random = date('Ymd_His');

$query = (!isset($_GET['source']) || $_GET['source'] == '') ? $db.'.'.$table : '('.$generator->fielddata[$_GET['source']]["sql"].') q';

$idcol = (!isset($_GET['id']) || $_GET['id'] == '') ? 'name' : 'id';

$id = (!isset($_GET['id']) ? '' : $_GET['id']).

(!isset($_GET['name']) ? '' : $_GET['name']).

(!isset($_GET['expand']) ? '' : $_GET['expand']);

$pos = strrpos($id,'.');

$ext = $pos === false ? 'html' : str_replace('.','',strtolower(substr($id,$pos)));

$filename = $pos === false ? $id : substr($id,0,$pos);

$data = ValueFromSql($con,"SELECT `$col` FROM $query WHERE `$idcol` = '$id'");

$len = strlen($data);

if ($len == 0)

die("<h1>$idcol with $id not found in $table</h1>");

header("Cache-Control: no-cache"); // RJL 25/3/09. Kill the caching problem at last?!

switch ($ext)

{

case "rtf":

if ($_GET["expand"] != "")

{

$data = $generator->Generate($data);

$len = strlen($data);

}

// Output the RTF file

header("Content-type: application/rtf");

header("Content-length: $len");

header("Content-Disposition: inline; filename=$filename.$random.$ext");

echo $data;

break;

case "doc":

// Output the DOC file

header("Content-type: application/msword");

header("Content-length: $len");

header("Content-Disposition: inline; filename=$filename.$random.$ext");

echo $data;

break;

case "htm":

case "html":

$data = $_GET["id"] == "" ? $data : $generator->PrepareHtml($data);

$data = $_GET["bookmark"] == "" ? $data : '<a name="bookmark">'.$data.'</a>';

$len = strlen($data);

header("Content-type: text/html");

header("Content-length: $len");

header("Content-Disposition: inline; filename=$filename.$random.$ext");

echo $data;

break;

case "xml":

if ($_GET["expand"] != "") {

$data = cp1252_to_utf8($generator->GenerateXml($data));

$len = strlen($data);

}

header("Content-type: text/xml; charset=utf-8");

header("Content-length: $len");

header("Content-Disposition: attachment; filename=$filename.$random.xml");

echo $data;

break;

case "odt":

if ($_GET["expand"] != "")

{

$data = $generator->GenerateOdt($data);

$len = strlen($data);

}

header("Content-type: application/odt; charset=utf-8");

header("Content-length: $len");

header("Content-Disposition: attachment; filename=$filename.odt");

echo $data;

break;

default:

// Output the image

$rtfpagewidth = floatval($generator->fielddata['rtfpagewidth']['value']);

$size = floatval($_GET["size"]);

$type = "image/".str_replace("jpg","jpeg",$ext);

header("Content-type: $type");

header("Content-Disposition: inline; filename=$filename.$random.$ext");

if ($size <= 0 || $rtfpagewidth <= 0)

{

header("Content-length: $len");

echo $data;

}

else

{

$handle = fopen($id,"w");

fwrite($handle,$data,strlen($data));

fclose($handle);

switch ($ext)

{

case ".png": $orig = imagecreatefrompng($id); break;

case ".gif": $orig = imagecreatefromgif($id); break;

default: $orig = imagecreatefromjpeg($id); break;

}

$x = $size * $rtfpagewidth;

$y = $x * imagesy($orig) / imagesx($orig);

$copy = imagecreatetruecolor($x,$y);

imagecopyresized($copy,$orig,0,0,0,0,$x,$y,imagesx($orig),imagesy($orig));

imagejpeg($copy);

imagedestroy($copy);

imagedestroy($orig);

unlink($id);

}

break;

}

?>