# 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 {~
-# 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:
-# code/wfpl/examples/db_connect.php
+# 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('~file_name upper~_DB_FIELDS', '~db_fields~');
~}~~upload_settings {~
# Set this to the path to your uploads directory. It can be relative to the
return ~file_name~_main_display($id);
}
~}~~opt_listing {~
+ if(_REQUEST_cut('download_csv')) {
+ return ~file_name~_csv_download();
+ }
+
if(isset($_POST['~always_field~'])) {
return ~file_name~_main_form();
}
return './~file_name~';
}~}~~opt_listing {~
+function ~file_name~_csv_download() {
+ require_once('code/wfpl/csv.php');
+ $rows = db_get_rows('~table_name~', 'id,'.~file_name upper~_DB_FIELDS, 'order by id');
+ array_unshift($rows, explode(',', 'id,'.~file_name upper~_DB_FIELDS));
+ array2d_to_csv_download($rows, '~file_name~.csv');
+}
+
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);
+ $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~';
+ }
+
+ $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 {~