function add(&$in)
{
global $pommo;
$dbo =& $pommo->_dbo;
// set the ordering of field if not provided
if (!is_numeric($in['ordering'])) {
$query = "\n\t\t\t\tSELECT field_ordering\n\t\t\t\tFROM " . $dbo->table['fields'] . "\n\t\t\t\tORDER BY field_ordering DESC";
$query = $dbo->prepare($query);
$in['ordering'] = $dbo->query($query, 0) + 1;
}
if (!PommoField::validate($in)) {
return false;
}
$query = "\n\t\tINSERT INTO " . $dbo->table['fields'] . "\n\t\tSET\n\t\tfield_active='%s',\n\t\tfield_ordering=%i,\n\t\tfield_name='%s',\n\t\tfield_prompt='%s',\n\t\tfield_normally='%s',\n\t\tfield_array='%s',\n\t\tfield_required='%s',\n\t\tfield_type='%s'";
$query = $dbo->prepare($query, @array($in['active'], $in['ordering'], $in['name'], $in['prompt'], $in['normally'], serialize($in['array']), $in['required'], $in['type']));
return $dbo->lastId($query);
}
