$dbData['orchidslingshot'] = array(
'db' => 'orchidslingshot',
'dbUser' => 'orchidslingshot',
'dbPassword' => '$orchidslingshot',
'dbHost' => 'arctosgroup.com',
);
modxDBClient createDocument project1-dev 50
ps -A | grep modxDBServer
2826 ? 00:00:03 modxDBServer
kill 2826
/usr/local/bin/modxDBServer/modxDBServer
[modxDBServer] accepted connection from 192.168.1.3 received: getDB?name=mydb&db=mydb&localdb=mydb-dev--END-- connecting to yourserver.com log in successful retrieving /files/mydb-content.sql.gz ftp done [modxDBServer] 192.168.1.3 disconnected
die("header: " . $header['ID'] . ", parent: " . $params['parent']);
Undefined index: ID in /path/to/modxDBServer/modxDBClient on line 423
// call the correct handler, and pass parameters
switch ($resource)
{
case 'createDocument':
case 'unpublishDocument':
case 'createSnippet':
//case 'deleteSnippet':
case 'createChunk':
//case 'deleteChunk':
$this->connectToDB($params['localdb']);
case 'getDB':
return $this->$resource($headerArray, $params);
break;
default:
throw new Exception("Invalid method '$resource' requested.");
break;
} private function createDocument($header, $params)
{
die("header: " . $header['ID'] . ", parent: " . $params['parent']);
// insert the new doc
$stmt = $this->dbh->prepare('INSERT INTO `modx_site_content` (`id`, `parent`) VALUES (?, ?)');
$stmt->bind_param('ii', $header['ID'], $params['parent']);
$stmt->execute();
echo "{$params['resource']}: Inserted {$stmt->affected_rows} row(s).\n";
$stmt->close();
// make the parent a folder
$stmt = $this->dbh->query('UPDATE `modx_site_content` SET `isfolder`=1 WHERE `id`=?');
$stmt->bind_param('i', $params['parent']);
$stmt->execute();
$stmt->close();
die("header: " . $header['ID'] . ", parent: " . $params['parent']);
}return $this->$resource($headerArray, $params);
private function createDocument($header, $params)
{
// insert the new doc
$stmt = $this->dbh->prepare("INSERT INTO `modx_site_content` (`id`, `parent`) VALUES (?, ?) ON DUPLICATE KEY UPDATE `parent`=?,`pagetitle`='',`longtitle`='',`description`='',`alias`='',`content`=''");
$stmt->bind_param('iii', $header['ID'], $params['parent'], $params['parent']);
$stmt->execute();
echo "{$params['resource']}: Inserted {$stmt->affected_rows} row with ID {$header['ID']}.\n";
$stmt->close();
// add the ID to the index file in /sql/documents/indexes
$indexFile = realpath(dirname(__FILE__) . '/../../sql/documents') . '/indexes';
system("echo '{$header['ID']}' >> $indexFile");
// make the parent a folder
$stmt = $this->dbh->prepare('UPDATE `modx_site_content` SET `isfolder`=1 WHERE `id`=?');
$stmt->bind_param('i', $params['parent']);
$stmt->execute();
$stmt->close();
}