JasonWoof Got questions, comments, patches, etc.? Contact Jason Woofenden
raise limit on listings 100 -> 1000
[wfpl.git] / metaform / template.php
index 6ae0602..30c0de8 100644 (file)
@@ -9,10 +9,10 @@
 
 
 # SETUP
-<!--~opt_email_1 {~-->
+~opt_email {~
 # To send results by e-mail, all you have to do is set your e-mail address here:
 $GLOBALS['~file_name~_form_recipient'] = 'fixme@example.com';
-<!--~}~--><!--~opt_db_1 {~-->
+~}~~opt_db {~
 # To save results to a database, you'll need to create the ~table_name~ table
 # (the file ~file_name~.sql should help with this), and create the file
 # 'code/db_connect.php' which calls db_connect() see:
@@ -21,148 +21,163 @@ $GLOBALS['~file_name~_form_recipient'] = 'fixme@example.com';
 # if you rename any of the database fields, you'll need to update this:
 
 define('~file_name upper~_DB_FIELDS', '~db_fields~');
-<!--~}~--><!--~upload_settings {~-->
+~}~~upload_settings {~
 # Set this to the path to your uploads directory. It can be relative to the
 # location of this script. IT MUST END WITH A SLASH
 $GLOBALS['upload_directory'] = 'uploads/';
-<!--~}~--><!--~image_settings {~-->
+~}~~file_settings {~
+$GLOBALS['~name~_file_name'] = uniqid() . getmypid() . '.txt'; # comment this out to use uploader's filename
+~}~~image_settings {~
 $GLOBALS['~name~_max_width'] = '400';
-$GLOBALS['~name~_max_height'] = '400';<!--~thumb_settings {~-->
+$GLOBALS['~name~_max_height'] = '400';~thumb_settings {~
 $GLOBALS['~name~_thumb_max_width'] = '70';
 $GLOBALS['~name~_thumb_max_height'] = '70';
 $GLOBALS['~name~_file_name'] = uniqid() . getmypid() . '.jpg'; # comment this out to use uploader's filename
-<!--~}~--><!--~}~-->
+~}~~}~
 
-require_once('code/wfpl/template.php');
 require_once('code/wfpl/format.php');
-require_once('code/wfpl/messages.php');
-require_once('code/wfpl/email.php');<!--~opt_db_2 {~-->
-require_once('code/db_connect.php');<!--~}~--><!--~image_include {~-->
-require_once('code/wfpl/upload.php');<!--~}~-->
+require_once('code/wfpl/email.php');~uploads_include {~
+require_once('code/wfpl/upload.php');~}~
 
 function ~file_name~_get_fields() {
        $data = array();
-<!--~formats {~-->
-       $data['~name~'] = format_~format~($_REQUEST['~name~']<!--~pulldown_format_extra {~-->, '~name~'<!--~}~-->);<!--~}~--><!--~image_upload {~-->
+~formats {~
+       $data['~name~'] = format_~format~(_REQUEST_cut('~name~')~pulldown_format_extra {~, '~name~'~}~);~}~~image_upload {~
+
        if($_FILES['~name~'] && $_FILES['~name~']['error'] == 0) {
-               $data['~name~'] = convert_uploaded_image('~name~', $GLOBALS['upload_directory'] . $GLOBALS['~name~_file_name'], $GLOBALS['~name~_max_width'], $GLOBALS['~name~_max_height']<!--~thumb_upload_params {~-->, $GLOBALS['~name~_thumb_max_width'], $GLOBALS['~name~_thumb_max_height']<!--~}~-->);
+               $data['~name~'] = convert_uploaded_image('~name~', $GLOBALS['upload_directory'] . $GLOBALS['~name~_file_name'], $GLOBALS['~name~_max_width'], $GLOBALS['~name~_max_height']~thumb_upload_params {~, $GLOBALS['~name~_thumb_max_width'], $GLOBALS['~name~_thumb_max_height']~}~);
        } else {
-               if($_REQUEST['delete_~name~'] == 'Yes') {
+               if(_REQUEST_cut('delete_~name~') == 'Yes') {
                        $data['~name~'] = '';
                } else {
-                       $data['~name~'] = format_image_w_h<!--~thumb_w_h {~-->_thumb_w_h<!--~}~-->($_REQUEST['old_~name~']);
+                       $data['~name~'] = format_image_w_h~thumb_w_h {~_thumb_w_h~}~(_REQUEST_cut('old_~name~'));
                }
-       }<!--~}~-->
-
-       return $data;
-}
-
-<!--~opt_listing_2 {~-->
-# You may pass a "where clause" for the db query.
-function ~file_name~_display_listing($where = 'order by ~always_field~ limit 100') {
-       $rows = db_get_assocs('~table_name~', 'id<!--~listing_fields_1 {~-->,~name~<!--~}~-->', $where);
-       if($rows == false || count($rows) == 0) {
-               tem_set('listings', array('empty_listing' => true));
-               return;
        }
+       unset($_FILES['~name~']);~}~~file_upload {~
 
-       # make sure there's something clickable
-       foreach($rows as &$row) {
-               if($row['~always_field~'] == '') {
-                       $row['~always_field~'] = '--';
+       $~name~_filename_tmp = $GLOBALS['~name~_file_name'];
+       if(!$~name~_filename_tmp) {
+               $~name~_filename_tmp = format_filename(_REQUEST_cut('~name~'));
+       }
+       if($_FILES['~name~'] && $_FILES['~name~']['error'] == 0) {
+               $data['~name~'] = save_uploaded_file('~name~', $GLOBALS['upload_directory'] . $~name~_filename_tmp);
+       } else {
+               if(_REQUEST_cut('delete_~name~') == 'Yes') {
+                       $data['~name~'] = '';
+               } else {
+                       $data['~name~'] = format_path(_REQUEST_cut('old_~name~'));
                }
        }
-       tem_set('listings', array(
-               'populated_listing' => true,
-               'rows' => $rows));
-       return true;
-}
-<!--~}~-->
-function ~file_name~_main() {<!--~opt_pass {~-->
-       if(!logged_in_as_admin()) {
-               $GLOBALS['url'] = this_url();
+       unset($_FILES['~name~']);~}~
+
+       return $data;
+}~opt_public_something {~
+
+
+function ~public_file_name~_main() {~opt_public_display {~
+       $id = _REQUEST_cut('id');
+       if($id) {
+               return ~file_name~_main_display($id);~opt_public_form unset {~
+       } else {
+               message("Error: Broken Link (~singular cap~ #$id not found)");
+               return './'; # FIXME where should this go?~}~
+       }~}~~opt_public_form {~
+       return ~file_name~_main_form();~}~
+}~}~
+
+
+function ~file_name~_main() {~opt_pass {~
+       if(logged_in_as_admin()) {
+               tem_set('admin_privs');
+       } else {
+               $_REQUEST['url'] = this_url();
                return 'admin_login';
        }
-<!--~}~--><!--~opt_display_1 {~-->
-       if(isset($_REQUEST['~file_name~_id'])) {
-               return ~file_name~_display_main();
-       } else {
-               return ~file_name~_edit_main();
+~}~~opt_db {~
+       $id = _REQUEST_cut('edit_id');
+       if($id) {
+               return ~file_name~_main_form($id);
        }
-<!--~}~--><!--~opt_display_1_else {~-->
-       return ~file_name~_edit_main();
-<!--~}~-->
-}<!--~opt_display_2 {~-->
-
-function ~file_name~_display_main() {
-       $id = format_int($_REQUEST['~file_name~_id']);
-       unset($_REQUEST['~file_name~_id']);
-       if(!$id) {
-               message('Error: Broken link');
-               return './~file_name~';
+
+       $id = _REQUEST_cut('~file_name~_delete_id');
+       if($id) {
+               return ~file_name~_main_delete($id);
        }
-       $row = db_get_assoc('~table_name~', 'id,'.~file_name upper~_DB_FIELDS, 'where id=%i', $id);
-       if(!$row) {
-               message('Error: ~singular cap~ not found');
-               return './~file_name~';
+
+       if(_REQUEST_cut('new')) {
+               return ~file_name~_main_form();
        }
-       tem_set('display', $row);
-}<!--~}~-->
-
-function ~file_name~_edit_main() {<!--~pulldowns {~-->
-       pulldown('~name~', array('option 1', 'option 2', 'option 3'));
-<!--~}~--><!--~opt_db_3 {~-->
-       $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', 'show');
-               tem_set('edit_msg', 'show');
+~}~~opt_listing {~
+       if(_REQUEST_cut('list')) {
+               return ~file_name~_main_listing();
        }
-
-       $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~';
+~}~~opt_display {~
+       $id = _REQUEST_cut('id');
+       if($id) {
+               return ~file_name~_main_display($id);
+       }
+~}~~opt_listing {~
+       if(isset($_POST['~always_field~'])) {
+               return ~file_name~_main_form();
        }
 
-       if(!$edit_id) {<!--~opt_listing_1 {~-->
-               if(!isset($_REQUEST['~file_name~_new']) && !isset($_REQUEST['~always_field~'])) {
-                       ~file_name~_display_listing();
-                       return;
-               }
-<!--~}~-->
-               tem_set('new_msg', 'show');
-       }<!--~}~-->
-
+       # default action:
+       return ~file_name~_main_listing();~}~~opt_listing unset {~
+       return ~file_name~_main_form();~}~
+}~opt_display {~
+
+function ~file_name~_main_display($id) {
+       $data = db_get_assoc('~table_name~', 'id,'.~file_name upper~_DB_FIELDS, 'where id=%i', $id);
+       if(!$data) {
+               message("Error: Broken Link (~singular cap~ #$id not found)");~opt_public_something {~
+               return './' . $GLOBALS['wfpl_basename'];~}~~opt_public_something unset {~
+               return './~file_name~';~}~
+       }
+       tem_set('display', $data);
+}~}~~opt_db {~
+
+function ~file_name~_main_delete($id) {
+       db_delete('~table_name~', 'where id=%i', $id);
+       message('~singular cap~ deleted.');
+       return './~file_name~';
+}~}~~opt_listing {~
+
+function ~file_name~_main_listing() {
+       $listing_rows = db_get_assocs('~table_name~', 'id~listing_fields_1 {~,~name~~}~', 'order by ~always_field~ limit 1000');
+       tem_set('listings', $listing_rows);
+}~}~
+
+function ~file_name~_main_form($id = false) {~pulldowns {~
+       pulldown('~name~', ~pulldown_options~);~}~~has_pulldowns {~
+~}~~opt_db {~
+       if($id) {
+               tem_set('id', $id);
+       }
+~}~
        if(isset($_POST['~always_field~'])) {
                $data = ~file_name~_get_fields();
 
-               if("you're happy with the POSTed values") {<!--~opt_db_4 {~-->
-                       if($edit_id) {
-                               db_update_assoc('~table_name~', $data, 'where id=%i', $edit_id);
+               if("you're happy with the POSTed values") {~opt_db {~
+                       if($id) {
+                               db_update_assoc('~table_name~', $data, 'where id=%i', $id);
                                message('~singular cap~ updated.');
                        } else {
                                db_insert_assoc('~table_name~', $data);
                                message('~singular cap~ saved.');
-                       }<!--~}~--><!--~opt_email_2 {~-->
+                       }~}~~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>";
+                               if(isset($data['email']) and valid_email($data['email'])) {
+                                       $reply_to = $data['email'];
+                                       if($data['name'] and ereg('^[a-zA-Z0-9_\' -]*$', $data['name']) !== false) {
+                                               $reply_to = "$data[name] <$reply_to>";
                                        }
                                }
                                $subject = '~plural cap~ form submitted';
                                $email_template = new tem();
-                               $email_template->load('~file_name~.email.txt');
+                               $email_template->load('~public_file_name~.email.txt');
                                $email_template->sets($data);
                                $message = $email_template->run();
                                $cc = '';
@@ -173,28 +188,33 @@ function ~file_name~_edit_main() {<!--~pulldowns {~-->
                                } else {
                                        message('Message sent');
                                }
-                       }<!--~}~-->
-                       if($error !== true) {
-                               return './~file_name~'; # FIXME is this the page you want to go to after successful form submission?
+                       }~}~
+                       if($error !== true) {~opt_public_something {~
+                               if($GLOBALS['wfpl_basename'] == '~file_name~') {
+                                       return './~file_name~';
+                               } else {
+                                       # FIXME create this page or change this to go elsewhere
+                                       return './~public_file_name~_thanks';
+                               }~}~~opt_public_something unset {~~opt_db unset {~
+                               # FIXME create this page or change this to go elsewhere~}~
+                               return './~file_name~~opt_db unset {~_thanks~}~';~}~
                        }
                }
                # 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_5 {~-->
-       } elseif($edit_id) {
+               # fix their entry in whatever way you require.~opt_db {~
+       } elseif($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);<!--~}~-->
+               $data = db_get_assoc('~table_name~', ~file_name upper~_DB_FIELDS, 'where id=%i', $id);~}~
        } else {
                # form not submitted, you can set default values like so:
                #$data = array('~always_field~' => 'Yes');
                $data = array();
-       }<!--~upload_max {~-->
+       }~upload_max {~
 
-       tem_set('upload_max_filesize', upload_max_filesize());<!--~}~-->
+       tem_set('upload_max_filesize', upload_max_filesize());~}~
 
-       tem_set('form', $data);<!--~show_extra_headers {~-->
-       tem_set('extra_headers', 'show');<!--~}~-->
+       tem_set('form', $data);~show_extra_headers {~
+       tem_set('$head');~}~
 }
-
-?>