+function ~file_name~_edit_main() {<!--~}~--><!--~pulldowns {~-->
+ pulldown('~name~', ~pulldown_options~);<!--~}~--><!--~opt_db {~-->
+ $edit_id = format_int($_REQUEST['~file_name~_edit_id']);
+ unset($_REQUEST['~file_name~_edit_id']);
+ if($edit_id) {
+ # add hidden field for database id of row we're editing
+ tem_set('~file_name~_edit_id', $edit_id);
+ tem_set('editing');
+ tem_set('edit_msg');
+ }
+
+ $delete_id = format_int($_REQUEST['~file_name~_delete_id']);
+ unset($_REQUEST['~file_name~_delete_id']);
+ if($delete_id) {
+ db_delete('~table_name~', 'where id=%i', $delete_id);
+ message('~singular cap~ deleted.');
+
+ return './~file_name~';
+ }
+
+ if(!$edit_id) {<!--~opt_listing {~-->
+ if(!isset($_REQUEST['~file_name~_new']) && !isset($_REQUEST['~always_field~'])) {
+ $listing_rows = db_get_assocs('~table_name~', 'id<!--~listing_fields_1 {~-->,~name~<!--~}~-->', 'order by ~always_field~ limit 100');
+ tem_set('listings', $listing_rows);
+ return;
+ }
+<!--~}~-->
+ tem_set('new_msg');
+ }
+<!--~}~-->
+ if(isset($_POST['~always_field~'])) {
+ $data = ~file_name~_get_fields();
+
+ if("you're happy with the POSTed values") {<!--~opt_db {~-->
+ if($edit_id) {
+ db_update_assoc('~table_name~', $data, 'where id=%i', $edit_id);
+ message('~singular cap~ updated.');
+ } else {
+ db_insert_assoc('~table_name~', $data);
+ message('~singular cap~ saved.');
+ }<!--~}~--><!--~opt_email {~-->
+ if($GLOBALS['~file_name~_form_recipient'] != 'fixme@example.com') {
+ $to = $GLOBALS['~file_name~_form_recipient'];
+ $from = 'noreply@~this_domain~';
+ $reply_to = $to;
+ if(isset($_REQUEST['email']) and valid_email($_REQUEST['email'])) {
+ $reply_to = $_REQUEST['email'];
+ if($_REQUEST['name'] and ereg('^[a-zA-Z0-9_\' -]*$', $_REQUEST['name']) !== false) {
+ $reply_to = "$_REQUEST[name] <$reply_to>";
+ }
+ }
+ $subject = '~plural cap~ form submitted';
+ $email_template = new tem();
+ $email_template->load('~file_name~.email.txt');
+ $email_template->sets($data);
+ $message = $email_template->run();
+ $cc = '';
+ $bcc = '';
+ if(email($from, $to, $subject, $message, $reply_to, $cc, $bcc)) {
+ message('Due to an internal error, your message could not be sent. Please try again later.');
+ $error = true;
+ } else {
+ message('Message sent');
+ }
+ }<!--~}~-->
+ if($error !== true) {
+ return './~file_name~'; # FIXME is this the page you want to go to after successful form submission?
+ }
+ }
+ # otherwise, we display the form again. ~file_name~_get_fields() has
+ # already put the posted values back into the template engine, so they will
+ # show up in the form fields. You should add some message asking people to
+ # fix their entry in whatever way you require.<!--~opt_db {~-->
+ } elseif($edit_id) {
+ # we've recieved an edit id, but no data. So we grab the values to be edited from the database
+ $data = db_get_assoc('~table_name~', ~file_name upper~_DB_FIELDS, 'where id=%i', $edit_id);<!--~}~-->
+ } else {
+ # form not submitted, you can set default values like so:
+ #$data = array('~always_field~' => 'Yes');
+ $data = array();
+ }<!--~upload_max {~-->
+
+ tem_set('upload_max_filesize', upload_max_filesize());<!--~}~-->
+
+ tem_set('form', $data);<!--~show_extra_headers {~-->
+ tem_set('extra_headers');<!--~}~-->
+}