#!/usr/bin/php
<?php
if ($_ENV['ZENDTOPREFS']) {
array_splice($argv, 1, 0, $_ENV['ZENDTOPREFS']);
}
if (count($argv) < 2) {
printf("\n usage:\n \n %s <ZendTo preferences.php file> <email address>\n \n The ZendTo preferences.php file path should be canonical, not relative.\n Alternatively, do\n export ZENDTOPREFS=<full file path of preferences.php>\n %s <email address>\n\n", $argv[0], $argv[0]);
return 0;
}
if (!preg_match('/^\\/.+/', $argv[1])) {
echo "ERROR: You must provide a canonical path to the preference file.\n";
return 1;
}
include $argv[1];
require_once NSSDROPBOX_LIB_DIR . "Smartyconf.php";
include_once NSSDROPBOX_LIB_DIR . "NSSDropoff.php";
if ($theDropbox = new NSSDropbox($NSSDROPBOX_PREFS, FALSE, TRUE)) {
$qResult = $theDropbox->database()->arrayQuery("SELECT rowID,* FROM dropoff", SQLITE_ASSOC);
echo "BEGIN TRANSACTION;\n";
foreach ($qResult as $q) {
echo "INSERT INTO dropoff\n";
echo "( rowID, claimID, claimPasscode, authorizedUser, senderName, senderOrganization, senderEmail, senderIP, confirmDelivery, created, note )\n";
echo sprintf("VALUES (%d,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s');\n", $q[rowID], sqlite_escape_string($q[claimID]), sqlite_escape_string($q[claimPasscode]), sqlite_escape_string($q[authorizedUser]), sqlite_escape_string($q[senderName]), sqlite_escape_string($q[senderOrganization]), sqlite_escape_string($q[senderEmail]), sqlite_escape_string($q[senderIP]), sqlite_escape_string($q[confirmDelivery]), sqlite_escape_string($q[created]), sqlite_escape_string($q[note]));
}
echo "COMMIT;\n";
}
#!/usr/bin/php
<?php
if (count($argv) < 2) {
printf("\n usage:\n \n %s <zendto preference file> {email address}\n \n The zendto preference file path should be canonical, not relative.\n\n", $argv[0]);
return 0;
}
if (!preg_match('/^\\/.+/', $argv[1])) {
echo "ERROR: You must provide a canonical path to the preference file.\n";
return 1;
}
include $argv[1];
require_once NSSDROPBOX_LIB_DIR . "Smartyconf.php";
include_once NSSDROPBOX_LIB_DIR . "NSSDropoff.php";
if ($theDropbox = new NSSDropbox($NSSDROPBOX_PREFS)) {
if (SqlBackend === 'SQLite') {
$qResult = $theDropbox->database()->database->arrayQuery(sprintf("SELECT rowID,* FROM dropoff"), SQLITE_ASSOC);
} else {
$res = $theDropbox->database()->database->query(sprintf("SELECT rowID,* FROM dropoff"));
$i = 0;
$qResult = array();
while ($line = $res->fetch_array()) {
$qResult[$i++] = $line;
}
}
echo "BEGIN TRANSACTION;\n";
foreach ($qResult as $q) {
echo "INSERT INTO dropoff\n";
echo "( rowID, claimID, claimPasscode, authorizedUser, senderName, senderOrganization, senderEmail, senderIP, confirmDelivery, created, note )\n";
echo sprintf("VALUES (%d,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s');\n", $q[rowID], sqlite_escape_string($q[claimID]), sqlite_escape_string($q[claimPasscode]), sqlite_escape_string($q[authorizedUser]), sqlite_escape_string($q[senderName]), sqlite_escape_string($q[senderOrganization]), sqlite_escape_string($q[senderEmail]), sqlite_escape_string($q[senderIP]), sqlite_escape_string($q[confirmDelivery]), sqlite_escape_string($q[created]), sqlite_escape_string($q[note]));
}
echo "COMMIT;\n";
