<?php
-# This form requires wfpl. If you didn't recieve wfpl along with this file,
-# see: http://jasonwoof.org/wfpl
+# This form requires wfpl. See: http://sametwice.com/wfpl
-# This form was auto-generated. If you would like to alter the parameters and
-# generate a new one try this URL:
+# This form was initially auto-generated. If you would like to alter the
+# parameters and generate a new one try this URL:
#
# ~metaform_url~
# SETUP
-<!--~opt_email_1 start~-->
+~opt_email {~
# To send results by e-mail, all you have to do is set your e-mail address here:
-$GLOBALS['~form_name~_form_recipient'] = "fixme@example.com";
-<!--~end~--><!--~opt_db_1 start~-->
-# To save results to a database, you'll need to create the ~form_name~ table
-# (the file ~form_name~.sql should help with this), and create the file
-# 'code/db_connect.php' which calls db_connect() see:
-# code/wfpl/examples/db_connect.php
+$GLOBALS['~file_name~_form_recipient'] = 'fixme@example.com';
+~}~~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
#
# if you rename any of the database fields, you'll need to update this:
-
-define('~form_name.upper~_DB_FIELDS', '~db_fields~');
-<!--~end~--><!--~upload_settings start~-->
+define('~file_name upper~_DB_FIELDS', '~db_fields~');
+~}~~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/';
-<!--~end~--><!--~opt_http_pass_1 start~-->
-# Define the username and password required to view this form:
-define('AUTH_REALM', '~form_name~ administration area');
-define('AUTH_USER', 'fixme');
-define('AUTH_PASS', 'fixme');
-<!--~end~-->
-
-if(!file_exists('code/wfpl/template.php')) { die('This form requires <a href="http://jasonwoof.org/wfpl">wfpl</a>.'); }
-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 start~-->
-require_once('code/db_connect.php');<!--~end~--><!--~image_include start~-->
-require_once('code/wfpl/upload.php');<!--~end~-->
-
-function ~form_name~_get_fields() {<!--~formats start~-->
- $~name~ = format_~format~($_REQUEST['~name~']<!--~pulldown_format_extra start~-->, '~name~'<!--~end~-->);<!--~end~--><!--~image_upload start~-->
- if($_FILES['~name~'] && $_FILES['~name~']['error'] == 0) {
- $~name~ = substr(save_uploaded_image('~name~', $GLOBALS['upload_directory']), strlen($GLOBALS['upload_directory']));
+~}~~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~_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(__DIR__.'/'.'inc/wfpl/format.php');~opt_email {~
+require_once(__DIR__.'/'.'inc/wfpl/email.php');~}~~uploads_include {~
+require_once(__DIR__.'/'.'inc/wfpl/upload.php');~}~
+
+$GLOBALS['~file_name~_field_to_caption'] = array(~name_to_caption {~
+ '~name~' => '~caption phpsq~'~ sep {~,~}~~}~
+);
+
+function ~file_name~_get_fields() {
+ $data = array();
+~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']~}~);
} else {
- $~name~ = format_filename($_REQUEST['old_~name~']);
- }<!--~end~-->
+ if (_REQUEST_cut('delete_~name~') == 'Yes') {
+ $data['~name~'] = '';
+ } else {
+ $data['~name~'] = format_image_w_h~thumb_w_h {~_thumb_w_h~}~(_REQUEST_cut('old_~name~'));
+ }
+ }
+ unset($_FILES['~name~']);~}~~file_upload {~
- ~form_name~_tem_sets(~php_fields~);
+ $~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~'));
+ }
+ }
+ unset($_FILES['~name~']);~}~
- return array(~php_fields~);
-}
+ return $data;
+}~opt_public_something {~
-function ~form_name~_tem_sets(~php_fields~) {<!--~tem_sets start~-->
- tem_set('~name~', $~name~);<!--~end~-->
-}
-<!--~opt_listing_2 start~-->
-# You may pass a "where clause" for the db query.
-function ~form_name~_display_listing($where = 'order by ~always_field~ limit 100') {
- $rows = db_get_rows('~form_name~', 'id,~always_field~', $where);
- if($rows == false || count($rows) == 0) {
- return false;
+
+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 {~
+ session_auth_must('admin_~file_name~');
+~}~~opt_db {~
+ $id = _REQUEST_cut('edit_id');
+ if ($id) {
+ return ~file_name~_main_form($id);
}
- foreach($rows as $row) {
- list($id, $~always_field~) = $row;
- tem_set('id', $id);
- if($~always_field~ == '') {
- $~always_field~ = '--';
- }
- tem_set('~always_field~', $~always_field~);
- tem_sub('listing_row');
+ $id = _REQUEST_cut('~file_name~_delete_id');
+ if ($id) {
+ return ~file_name~_main_delete($id);
}
- tem_sub('listings');
- return true;
-}
-<!--~end~-->
-function ~form_name~_main() {<!--~opt_http_pass_2 start~-->
- # To remove password protection, just delete this block:
- if (!isset($_SERVER['PHP_AUTH_USER']) || $_SERVER['PHP_AUTH_USER'] != AUTH_USER || $_SERVER['PHP_AUTH_PW'] != AUTH_PASS) {
- header('WWW-Authenticate: Basic realm="' . AUTH_REALM . '"');
- header('HTTP/1.0 401 Unauthorized');
- echo '401 Unauthorized';
- exit;
+
+ if (_REQUEST_cut('new')) {
+ return ~file_name~_main_form();
+ }
+~}~~opt_listing {~
+ if (_REQUEST_cut('list')) {
+ return ~file_name~_main_listing();
}
- <!--~end~--><!--~pulldowns start~-->
- pulldown('~name~', array('option 1', 'option 2', 'option 3'));
- <!--~end~--><!--~opt_db_3 start~-->
- $edit_id = format_int($_REQUEST['~form_name~_edit_id']);
- unset($_REQUEST['~form_name~_edit_id']);
- if($edit_id) {
- # add hidden field for database id of row we're editing
- tem_set('~form_name~_edit_id', $edit_id);
- tem_sub('editing');
+~}~~opt_display {~
+ $id = _REQUEST_cut('id');
+ if ($id) {
+ return ~file_name~_main_display($id);
+ }
+~}~~opt_listing {~
+ if (_REQUEST_cut('download_csv')) {
+ return ~file_name~_csv_download();
}
- $delete_id = format_int($_REQUEST['~form_name~_delete_id']);
- unset($_REQUEST['~form_name~_delete_id']);
- if($delete_id) {
- db_delete('~form_name~', 'where id=%i', $delete_id);
- message('Entry deleted.');<!--~opt_listing_3 start~-->
+ if (isset($_POST['~always_field~'])) {
+ return ~file_name~_main_form();
+ }
- if(~form_name~_display_listing()) {
- return;
+ # 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~_csv_download() {
+ require_once(__DIR__.'/'.'inc/wfpl/csv.php');
+ $rows = db_get_rows('~table_name~', 'id,'.~file_name upper~_DB_FIELDS, 'order by id');
+ $fields = explode(',', 'id,'.~file_name upper~_DB_FIELDS);
+ $header = array();
+ foreach ($fields as $field) {
+ if (isset($GLOBALS['~file_name~_field_to_caption'][$field])) {
+ $header[] = $GLOBALS['~file_name~_field_to_caption'][$field];
+ } else {
+ $header[] = $field;
}
- unset($delete_id);<!--~end~--><!--~opt_listing_3_else start~-->
+ }
+ array_unshift($rows, $header);
+ array2d_to_csv_download($rows, '~file_name~.csv');
+}
- # FIXME: what to do after delete?
- return;<!--~end~-->
+function ~file_name~_main_listing() {
+ $data = array();
+ $desc = '';
+ $sort = _REQUEST_cut('sort');
+ if ($sort && substr($sort, 0, 1) === '-') {
+ $sort = substr($sort, 1);
+ $desc = ' DESC ';
+ } else {
+ $data["sorting-by-$sort"] = '-';
+ }
+ $legal_sorts = explode(',', ~file_name upper~_DB_FIELDS);
+ if (!$sort || !in_array($sort, $legal_sorts)) {
+ $sort = '~always_field~';
}
- if(!$edit_id) {<!--~opt_listing_1 start~-->
- if(!isset($_REQUEST['~form_name~_new']) && !isset($_REQUEST['~always_field~'])) {
- if(~form_name~_display_listing()) {
- return;
- }
- }
- <!--~end~-->
- tem_sub('new_msg');
- }<!--~end~-->
-
- if(isset($_REQUEST['~always_field~'])) {
- list(~php_fields~) = ~form_name~_get_fields();
-
- if("you're happy with the POSTed values") {<!--~opt_db_4 start~-->
- if($edit_id) {<!--~image_db start~-->
- # uploading nothing means leaving it as is.
- if(!$~name~ && $delete_~name~ != 'Yes') {
- $~name~ = db_get_value('~form_name~', '~name~', 'where id=%i', $edit_id);
- }
- <!--~end~-->
- db_update('~form_name~', ~form_name.upper~_DB_FIELDS, ~php_fields~, 'where id=%i', $edit_id);
- message('Entry updated.');
+ $data['rows'] = db_get_assocs('~table_name~', 'id~listing_fields_1 {~,~name~~}~', "order by $sort $desc limit 1000");
+ tem_set('listings', $data);
+}~}~
+
+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 {~
+ if ($id) {
+ db_update_assoc('~table_name~', $data, 'where id=%i', $id);
+ message('~singular cap~ updated.');
} else {
- db_insert('~form_name~', ~form_name.upper~_DB_FIELDS, ~php_fields~);
- message('Entry saved.');
- }<!--~end~--><!--~opt_email_2 start~-->
- if($GLOBALS['~form_name~_form_recipient'] != "fixme@example.com") {
- $to = $GLOBALS['~form_name~_form_recipient'];
- if(isset($_REQUEST['email']) and valid_email($_REQUEST['email'])) {
- $from = $_REQUEST['email'];
- if($_REQUEST['name'] and ereg('^[a-zA-Z0-9_\' -]*$', $_REQUEST['name']) !== false) {
- $from = "$_REQUEST[name] <$from>";
+ 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($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>";
}
- } else {
- $from = $to;
}
- $subject = '~form_name~ form submitted';
- $message = tem_run('~form_name~.email.txt');
+ $subject = '~plural cap~ form submitted';
+ $email_template = new tem();
+ $email_template->load('~public_file_name~.email.txt');
+ $email_template->sets($data);
+ $message = $email_template->run();
$cc = '';
$bcc = '';
- if(email($from, $to, $subject, $message, $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');
}
- }<!--~end~-->
- if($error !== true) {<!--~opt_listing_4 start~-->
- ~form_name~_display_listing();<!--~end~--><!--~opt_listing_4_else start~-->
- tem_sub('thankyou');<!--~end~-->
- return;
+ }~}~
+ 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. ~form_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 start~-->
- } elseif($edit_id) {
+ # else fall through to display the form again. Field values are in $data~opt_db {~
+ } elseif ($id) {
# we've recieved an edit id, but no data. So we grab the values to be edited from the database
- list(~php_fields~) = db_get_row('~form_name~', ~form_name.upper~_DB_FIELDS, 'where id=%i', $edit_id);
- ~form_name~_tem_sets(~php_fields~);<!--~end~-->
+ $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:
- #tem_set('~always_field~', 'Yes');
- }<!--~upload_max start~-->
-
- tem_set('upload_max_filesize', upload_max_filesize());<!--~end~-->
+ #$data = array('~always_field~' => 'Yes');
+ $data = array();
+ }~upload_max {~
- # this has to be later in the file because it requres that ~always_field~ be set already
- if($edit_id) {
- tem_sub('edit_msg');
- }
+ tem_set('$upload_max_filesize', upload_max_filesize());~}~
- tem_sub('form');
+ tem_set('form', $data);~show_extra_headers {~
+ tem_set('$head');~}~
}
-
-?>