/**
* admin_table_postadd() - update the database based on a submitted change
*
* @param $table - the table to act on
* @param $unit - the name of the "units" described by the table's records
* @param $primary_key - the primary key of the table
*/
function admin_table_postadd($table, $unit, $primary_key)
{
if (!form_key_is_valid(getStringFromRequest('form_key'))) {
exit_form_double_submit();
}
$field_list = getStringFromRequest('__fields__');
$fields = split(",", $field_list);
$values = array();
foreach ($fields as $field) {
$values[] = "'" . getStringFromPost($field) . "'";
}
$sql = "INSERT INTO {$table} (" . $field_list . ") VALUES (" . implode(",", $values) . ")";
if (db_query($sql)) {
printf(_('%1$s successfully added.'), ucfirst(getUnitLabel($unit)));
} else {
form_release_key(getStringFromRequest('form_key'));
echo db_error();
}
}
<?php
snippet_footer(array());
} else {
if ($type == 'package') {
/*
Handle insertion of a new package version
*/
/*
See if the package exists first
*/
$result = db_query("SELECT * FROM snippet_package WHERE snippet_package_id='{$id}'");
if (!$result || db_numrows($result) < 1) {
exit_error(_('Error - snippet_package doesn\'t exist'));
}
if (getStringFromRequest('post_changes')) {
if (!form_key_is_valid(getStringFromRequest('form_key'))) {
exit_form_double_submit();
}
$snippet_package_id = getIntFromRequest('snippet_package_id');
$changes = getStringFromRequest('changes');
$version = getStringFromRequest('version');
/*
Create a new snippet entry, then create a new snippet version entry
*/
if ($changes && $snippet_package_id) {
/*
create the snippet package version
*/
$sql = "INSERT INTO snippet_package_version " . "(snippet_package_id,changes,version,submitted_by,post_date) " . "VALUES ('{$snippet_package_id}','" . htmlspecialchars($changes) . "','" . htmlspecialchars($version) . "','" . user_getid() . "','" . time() . "')";
$result = db_query($sql);
if (!$result) {
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with GForge; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
require_once '../../env.inc.php';
require_once $gfwww . 'include/pre.php';
require_once $gfwww . 'include/trove.php';
require_once $gfwww . 'admin/admin_utils.php';
session_require(array('group' => '1', 'admin_flags' => 'A'));
// ########################################################
if (getStringFromRequest('submit')) {
if (!form_key_is_valid(getStringFromRequest("form_key"))) {
exit_form_double_submit();
}
$form_parent = getStringFromRequest('form_parent');
$form_shortname = getStringFromRequest('form_shortname');
$form_fullname = getStringFromRequest('form_fullname');
$form_description = getStringFromRequest('form_description');
$newroot = trove_getrootcat($form_parent);
if ($form_shortname) {
$res = db_query("\n\t\t\tINSERT INTO trove_cat \n\t\t\t\t(shortname,fullname,description,parent,version,root_parent)\n\t\t\tVALUES (\n\t\t\t\t'" . htmlspecialchars($form_shortname) . "',\n\t\t\t\t'" . htmlspecialchars($form_fullname) . "',\n\t\t\t\t'" . htmlspecialchars($form_description) . "',\n\t\t\t\t'{$form_parent}',\n\t\t\t\t'" . date("Ymd", time()) . "01',\n\t\t\t\t'{$newroot}'\n\t\t\t)\n\t\t");
if (!$res || db_affected_rows($res) < 1) {
form_release_key(getStringFromRequest("form_key"));
exit_error(_('Error In Trove Operation'), db_error());
}
}
// update full paths now
