X-Git-Url: https://jasonwoof.com/gitweb/?a=blobdiff_plain;f=metaform%2Ftemplate.php;h=49e6b741e48dcce17954468c69e194e18ec163ec;hb=51cf6721f37220e1277c71545b87dcc01fbf7e81;hp=0f3acf86adcf2df0a96099b0195d5a3933492842;hpb=5e7ba7c884bd114678e6308a7447e646dee7f838;p=wfpl.git

diff --git a/metaform/template.php b/metaform/template.php
index 0f3acf8..49e6b74 100644
--- a/metaform/template.php
+++ b/metaform/template.php
@@ -13,13 +13,10 @@
 # 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
@@ -39,6 +36,10 @@ require_once('code/wfpl/format.php');
 require_once('code/wfpl/email.php');~uploads_include {~
 require_once('code/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 {~
@@ -149,7 +150,16 @@ function ~file_name~_main_delete($id) {
 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(',',~file_name upper~_DB_FIELDS));
+	$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;
+		}
+	}
+	array_unshift($rows, $header);
 	array2d_to_csv_download($rows, '~file_name~.csv');
 }