$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>"; } } //} }