$filecontent = $moduleSnippet[2];
$properties = mysql_real_escape_string($moduleSnippet[3]);
$category = mysql_real_escape_string($moduleSnippet[4]);
if (!file_exists($filecontent)) {
echo "<p> {$name}: <span class=\"notok\">" . $_lang['unable_install_snippet'] . " '{$filecontent}' " . $_lang['not_found'] . ".</span></p>";
} else {
// Create the category if it does not already exist
$category = getCreateDbCategory($category, $sqlParser);
$snippet = end(preg_split("/(\\/\\/)?\\s*\\<\\?php/", file_get_contents($filecontent)));
// remove installer docblock
$snippet = preg_replace("/^.*?\\/\\*\\*.*?\\*\\/\\s+/s", '', $snippet, 1);
$snippet = mysql_real_escape_string($snippet);
$rs = mysql_query("SELECT * FROM {$dbase}.`" . $table_prefix . "site_snippets` WHERE name='{$name}'", $sqlParser->conn);
if (mysql_num_rows($rs)) {
$row = mysql_fetch_assoc($rs);
$props = propUpdate($properties, mysql_real_escape_string($row['properties']));
if (!@mysql_query("UPDATE {$dbase}.`" . $table_prefix . "site_snippets` SET snippet='{$snippet}', description='{$desc}', properties='{$props}' WHERE name='{$name}';", $sqlParser->conn)) {
echo "<p>" . mysql_error() . "</p>";
return;
}
echo "<p> {$name}: <span class=\"ok\">" . $_lang['upgraded'] . "</span></p>";
} else {
if (!@mysql_query("INSERT INTO {$dbase}.`" . $table_prefix . "site_snippets` (name,description,snippet,properties,category) VALUES('{$name}','{$desc}','{$snippet}','{$properties}',{$category});", $sqlParser->conn)) {
echo "<p>" . mysql_error() . "</p>";
return;
}
echo "<p> {$name}: <span class=\"ok\">" . $_lang['installed'] . "</span></p>";
}
}
}
}
$si = (int) trim($si);
$name = mysql_real_escape_string($moduleSnippets[$si][0]);
$desc = mysql_real_escape_string($moduleSnippets[$si][1]);
$type = $moduleSnippets[$si][2];
// 0:file, 1:content
$filecontent = $moduleSnippets[$si][3];
$properties = mysql_real_escape_string($moduleSnippets[$si][4]);
if ($type == 0 && !file_exists($filecontent)) {
echo "<p> {$name}: <span class=\"notok\">" . $_lang['unable_install_snippet'] . " '{$filecontent}' " . $_lang['not_found'] . ".</span></p>";
} else {
$snippet = $type == 1 ? $filecontent : implode('', file($filecontent));
$snippet = mysql_real_escape_string($snippet);
$rs = mysql_query("SELECT * FROM {$dbase}.`" . $table_prefix . "site_snippets` WHERE name='{$name}'", $sqlParser->conn);
if (mysql_num_rows($rs)) {
$row = mysql_fetch_assoc($rs);
$props = propUpdate($properties, $row['properties']);
if (!@mysql_query("UPDATE {$dbase}.`" . $table_prefix . "site_snippets` SET snippet='{$snippet}', description='{$desc}', properties='{$props}' WHERE name='{$name}';", $sqlParser->conn)) {
echo "<p>" . mysql_error() . "</p>";
return;
}
echo "<p> {$name}: <span class=\"ok\">" . $_lang['upgraded'] . "</span></p>";
} else {
if (!@mysql_query("INSERT INTO {$dbase}.`" . $table_prefix . "site_snippets` (name,description,snippet,properties) VALUES('{$name}','{$desc}','{$snippet}','{$properties}');", $sqlParser->conn)) {
echo "<p>" . mysql_error() . "</p>";
return;
}
echo "<p> {$name}: <span class=\"ok\">" . $_lang['installed'] . "</span></p>";
}
}
}
}
$filecontent = $moduleSnippet[2];
$properties = $modx->db->escape($moduleSnippet[3]);
$category = $modx->db->escape($moduleSnippet[4]);
if (!file_exists($filecontent)) {
echo "<p> {$name}: <span class=\"notok\">" . $_lang['unable_install_snippet'] . " '{$filecontent}' " . $_lang['not_found'] . ".</span></p>";
} else {
// Create the category if it does not already exist
$category = getCreateDbCategory($category, $sqlParser);
$snippet = end(preg_split("/(\\/\\/)?\\s*\\<\\?php/", file_get_contents($filecontent)));
// remove installer docblock
$snippet = preg_replace("/^.*?\\/\\*\\*.*?\\*\\/\\s+/s", '', $snippet, 1);
$snippet = $modx->db->escape($snippet);
$rs = $modx->db->query("SELECT * FROM `" . $table_prefix . "site_snippets` WHERE name='{$name}'");
if ($modx->db->getRecordCount($rs)) {
$row = $modx->db->getRow($rs, 'assoc');
$props = propUpdate($properties, $modx->db->escape($row['properties']));
if (!$modx->db->query("UPDATE `" . $table_prefix . "site_snippets` SET snippet='{$snippet}', description='{$desc}', properties='{$props}' WHERE name='{$name}';")) {
echo "<p>" . mysql_error() . "</p>";
return;
}
echo "<p> {$name}: <span class=\"ok\">" . $_lang['upgraded'] . "</span></p>";
} else {
if (!$modx->db->query("INSERT INTO `" . $table_prefix . "site_snippets` (name,description,snippet,properties,category) VALUES('{$name}','{$desc}','{$snippet}','{$properties}',{$category});")) {
echo "<p>" . mysql_error() . "</p>";
return;
}
echo "<p> {$name}: <span class=\"ok\">" . $_lang['installed'] . "</span></p>";
}
}
//}
}
