/
export.php
executable file
·62 lines (52 loc) · 2.15 KB
/
export.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
<? /* $Id$ */
include("config.inc.php");
include("functions.inc.php");
include("dbwrapper.inc.php");
db_connect($dbhost, $dbuser, $dbpass, $dbdb);
$dhost = "badger.middlebury.edu";
$duser = "sitesdb";
$dpass = "sitesdb#%&";
$ddb = "sitesdb";
if ($site) {
serverCopySite($site,$dest);
}
function serverCopySite($orig,$dest) {
$sections = decode_array(db_get_value("sites","sections","name='$orig'"));
$nsections = array();
foreach ($sections as $s) {
$sa = db_get_line("sections","id=$s");
$squery = "insert into sections set addedby='".addslashes($_SESSION['auser'])."', addedtimestamp=NOW()";
$squery .= ",title='$sa[title]', active=$sa[active], type='$sa[type]', url='$sa[url]'";
$pages = decode_array($sa[pages]);
$npages = array();
foreach ($pages as $p) {
$pa = db_get_line("pages","id=$p");
$pquery = "insert into pages set addedby='".addslashes($_SESSION['auser'])."', addedtimestamp=NOW()";
$pquery .= ",ediscussion=1,archiveby='$pa[archiveby]',url='$pa[url]',type='$pa[type]',title='$pa[title]', showcreator=$pa[showcreator], showdate=$pa[showdate], locked=$pa[locked], active=$pa[active]";
$stories = decode_array($pa[stories]);
$nstories = array();
foreach ($stories as $st) {
$sta = db_get_line("stories","id=$st");
$stquery = "insert into stories set addedby='".addslashes($_SESSION['auser'])."', addedtimestamp=NOW()";
$stquery.=",type='$sta[type]',texttype='$sta[texttype]',category='$sta[category]',title='$sta[title]', discuss=$sta[discuss], discusspermissions='$sta[discusspermissions]', shorttext='$sta[shorttext]', longertext='$sta[longertext]', locked=$sta[locked], url='$sa[url]'";
db_query($stquery);
// print "$stquery<br />";
$nstories[] = lastid();
}
$stories = encode_array($nstories);
$pquery.=",stories='$stories'";
db_query($pquery);
$npages[]=lastid();
// print "$pquery<br />";
}
$pages = encode_array($npages);
$squery.=",pages='$pages'";
db_query($squery);
$nsections[] = lastid();
// print "$squery<br />";
}
$sections = encode_array($nsections);
$query = "update sites set sections='$sections' where name='$dest'";
db_query($query);
// print "$query<br />";
}