static function add(&$in) { $dbo =& Pommo::$_dbo; // set the ordering of field if not provided if (!is_numeric($in['ordering'])) { $query = "\n SELECT field_ordering\n FROM " . $dbo->table['fields'] . "\n ORDER BY field_ordering DESC"; $query = $dbo->prepare($query); $in['ordering'] = $dbo->query($query, 0) + 1; } if (!Pommo_Fields::validate($in)) { return false; } $query = "\n INSERT INTO " . $dbo->table['fields'] . "\n SET\n field_active='%s',\n field_ordering=%i,\n field_name='%s',\n field_prompt='%s',\n field_normally='%s',\n field_array='%s',\n field_required='%s',\n field_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); }