- bitweaver

TikiPro Technical Documentation » WorkInProgress » TikiExportUpdate

Differences from version 2 to 3

@@ -1,7 +1,7 @@

(This appears to be code for exporting Wiki data.)

Here are 2 updated files, tiki-export_wiki_pages.php and exportlib.php. They have a couple minor hacks

-1) new filename for a complete export: "tiki_export-<datestamp>.tar"

+1) new filename for a complete export: "tiki_export-<datestamp>.tar"

2) better headers (fixed wget, etc)

3) put directory and filenames into variables

4) tarfile is no longer passed as a Location: header, readfile() is used to send file contents to the client so file may be moved to some arbitrary point outside of the document root

@@ -9,9 +9,10 @@

Tested download with: Konqueror 3.1.3, Opera 7.23 Linux, Mozilla 1.6 Linux, Mozilla 1.4 Win, IE 6

-=tiki-export_wiki_pages.php=-

-^

-<?php

+{code in="php"}

+

+<?php

// $Header: /cvsroot/tikiwiki/tiki/tiki-export_wiki_pages.php,v 1.6 2003/12/04 10:40:53 mose Exp $

@@ -25,7 +26,7 @@

// Initialization

require_once ('setup.php');

-include_once ("lib/ziplib.php");

+include_once ("lib/ziplib.php");

include_once ('lib/wiki/exportlib.php');

/* I hate ifs without brackets ;) */

@@ -35,14 +36,14 @@

}

// this should probably use a global date format

-$datestamp = date("dMY");

+$datestamp = date("dMY");

-if (!isset($_REQUEST["page"])) {

+if (!isset($_REQUEST["page"])) {

-$exportlib->MakeWikiZip();

+ $exportlib->MakeWikiZip();

/* This var should actually come from a global setting for a writable directory, but since there isn't one yet I'll just set it here */

-$dumpdir = "dump";

+ $dumpdir = "dump";

/*

I'm not even sure yet if this next variable would show up here

@@ -50,11 +51,11 @@

*/

if(!empty($tikidomain))

{

-$filename = "$dumpdir/$tikidomain/tiki_export-$datestamp.tar";

+ $filename = "$dumpdir/$tikidomain/tiki_export-$datestamp.tar";

}

else

{

-$filename = "$dumpdr/tiki_export-$datestamp.tar";

+ $filename = "$dumpdr/tiki_export-$datestamp.tar";

}

/*

@@ -66,55 +67,56 @@

if(file_exists($filename))

{

-header("Pragma: public");

-header("Expires: 0");

-header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

-header("Content-Type: application/octet-stream");

-header("Content-Disposition: attachment; filename=\"tiki_export-$datestamp.tar\"");

-header("Content-Description: File Transfer");

+ header("Pragma: public");

+ header("Expires: 0");

+ header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

+ header("Content-Type: application/octet-stream");

+ header("Content-Disposition: attachment; filename=\"tiki_export-$datestamp.tar\"");

+ header("Content-Description: File Transfer");

-@readfile("$filename");

+ @readfile("$filename");

}

else

{

-header("Status: 404 Not Found");

+ header("Status: 404 Not Found");

}

} else {

-if (isset($_REQUEST["all"]))

+ if (isset($_REQUEST["all"]))

$all = 0;

else

$all = 1;

-$data = $exportlib->export_wiki_page($_REQUEST["page"], $all);

-$page = $_REQUEST["page"];

+ $data = $exportlib->export_wiki_page($_REQUEST["page"], $all);

+ $page = $_REQUEST["page"];

-header("Pragma: public");

-header("Expires: 0");

-header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

-header("Content-Type: application/octet-stream");

-header("Content-Disposition: inline; filename=\"$page-$datestamp\"");

-header("Content-Description: File Transfer");

+ header("Pragma: public");

+ header("Expires: 0");

+ header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

+ header("Content-Type: application/octet-stream");

+ header("Content-Disposition: inline; filename=\"$page-$datestamp\"");

+ header("Content-Description: File Transfer");

echo $data;

}

-?>

+?>

-^

+{code}

-=exportlib.php=-

-^

-<?php

+{code in="php"}

+

+<?php

class ExportLib extends TikiLib {

function ExportLib($db) {

# this is probably uneeded now

if (!$db) {

-die ("Invalid db object passed to ExportLib constructor");

+ die ("Invalid db object passed to ExportLib constructor");

}

-$this->db = $db;

+ $this->db = $db;

}

function MakeWikiZip() {

@@ -122,41 +124,41 @@

// added datestamp, changed filenames - mkc

-$datestamp = date("dMY");

-$zipname = "wikidb-$datestamp.zip";

-include_once ("lib/tar.class.php");

+ $datestamp = date("dMY");

+ $zipname = "wikidb-$datestamp.zip";

+ include_once ("lib/tar.class.php");

$tar = new tar();

-$query = "select `pageName` from `tiki_pages` order by ".$this->convert_sortmode("pageName_asc");

-$result = $this->query($query,array());

+ $query = "select `pageName` from `tiki_pages` order by ".$this->convert_sortmode("pageName_asc");

+ $result = $this->query($query,array());

-while ($res = $result->fetchRow()) {

-$page = $res["pageName"];

-$content = $this->export_wiki_page($page, 0);

-$tar->addData($page, $content, date("U"));

+ while ($res = $result->fetchRow()) {

+ $page = $res["pageName"];

+ $content = $this->export_wiki_page($page, 0);

+ $tar->addData($page, $content, date("U"));

}

-$tar->toTar("dump/$tikidomain/tiki_export-$datestamp.tar", FALSE);

+ $tar->toTar("dump/$tikidomain/tiki_export-$datestamp.tar", FALSE);

return '';

}

function export_wiki_page($pageName, $nversions = 1) {

$head = '';

-$head .= "Date: " . $this->get_rfc2822_datetime(). "\r\n";

-$head .= sprintf("Mime-Version: 1.0 (Produced by Tiki)\r\n");

-$iter = $this->get_page_history($pageName);

-$info = $this->get_page_info($pageName);

+ $head .= "Date: " . $this->get_rfc2822_datetime(). "\r\n";

+ $head .= sprintf("Mime-Version: 1.0 (Produced by Tiki)\r\n");

+ $iter = $this->get_page_history($pageName);

+ $info = $this->get_page_info($pageName);

$parts = array();

$parts[] = MimeifyPageRevision($info);

-if ($nversions > 1 || $nversions == 0) {

+ if ($nversions > 1 || $nversions == 0) {

foreach ($iter as $revision) {

$parts[] = MimeifyPageRevision($revision);

-if ($nversions > 0 && count($parts) >= $nversions)

+ if ($nversions > 0 && count($parts) >= $nversions)

break;

}

-if (count($parts) > 1)

+ if (count($parts) > 1)

return $head . MimeMultipart($parts);

assert ($parts);

@@ -166,21 +168,21 @@

// Returns all the versions for this page

// without the data itself

function get_page_history($page) {

-$query = "select `pageName`, `description`, `version`, `lastModif`, `user`, `ip`, `data`, `comment` from `tiki_history` where `pageName`=? order by ".$this->convert_sortmode("version_desc");

-$result = $this->query($query,array($page));

+ $query = "select `pageName`, `description`, `version`, `lastModif`, `user`, `ip`, `data`, `comment` from `tiki_history` where `pageName`=? order by ".$this->convert_sortmode("version_desc");

+ $result = $this->query($query,array($page));

$ret = array();

-while ($res = $result->fetchRow()) {

+ while ($res = $result->fetchRow()) {

$aux = array();

-$aux["version"] = $res["version"];

-$aux["lastModif"] = $res["lastModif"];

-$aux["user"] = $res["user"];

-$aux["ip"] = $res["ip"];

-$aux["data"] = $res["data"];

-$aux["pageName"] = $res["pageName"];

-$aux["description"] = $res["description"];

-$aux["comment"] = $res["comment"];

-//$aux["percent"] = levenshtein($res["data"],$actual);

+ $aux["version"] = $res["version"];

+ $aux["lastModif"] = $res["lastModif"];

+ $aux["user"] = $res["user"];

+ $aux["ip"] = $res["ip"];

+ $aux["data"] = $res["data"];

+ $aux["pageName"] = $res["pageName"];

+ $aux["description"] = $res["description"];

+ $aux["comment"] = $res["comment"];

+ //$aux["percent"] = levenshtein($res["data"],$actual);

$ret[] = $aux;

}

return $ret;

@@ -189,6 +191,6 @@

$exportlib = new ExportLib($dbTiki);

-?>

+?>

-^

+{code}

Page History
Date/Comment	User	IP	Version
16 May 2005 (20:12 UTC) Categorized and added a comment at beginning	spiderr	66.93.240.204	3
Current • Source
01 May 2004 (06:18 UTC) Categorized and added a comment at beginning	SEWilco	209.98.144.16	2
View • Compare • Difference • Source

History of TikiExportUpdate

Differences from version 2 to 3