3 # This form requires wfpl. See: http://jasonwoof.org/wfpl
5 # This form was initially auto-generated. If you would like to alter the
6 # parameters and generate a new one try this URL:
8 # http://jasonwoof.com/metaform/?form_name=people&opt_email=No&opt_db=Yes&opt_listing=Yes&opt_http_pass=No&fields=username+textbox%0D%0Apassword+textbox%0D%0Aname+textbox%0D%0Aprivs+int%0D%0Abalance+decimal&edit=yes
13 # To save results to a database, you'll need to create the people table
14 # (the file people.sql should help with this), and create the file
15 # 'code/db_connect.php' which calls db_connect() see:
16 # code/wfpl/examples/db_connect.php
18 # if you rename any of the database fields, you'll need to update this:
20 define('PEOPLE_DB_FIELDS', 'username,password,name,privs,balance');
23 require_once('code/wfpl/template.php');
24 require_once('code/wfpl/format.php');
25 require_once('code/wfpl/messages.php');
26 require_once('code/wfpl/email.php');
27 require_once('code/db_connect.php');
29 function people_get_fields() {
30 $username = format_oneline($_REQUEST['username']);
31 $password = format_oneline($_REQUEST['password']);
32 $name = format_oneline($_REQUEST['name']);
33 $privs = format_int($_REQUEST['privs']);
34 $balance = format_decimal($_REQUEST['balance']);
36 people_tem_sets($username, $password, $name, $privs, $balance);
38 return array($username, $password, $name, $privs, $balance);
41 function people_tem_sets($username, $password, $name, $privs, $balance) {
42 tem_set('username', $username);
43 tem_set('password', $password);
44 tem_set('name', $name);
45 tem_set('privs', $privs);
46 tem_set('balance', $balance);
49 # You may pass a "where clause" for the db query.
50 function people_display_listing($where = 'order by username limit 100') {
51 $rows = db_get_rows('people', 'id,username', $where);
52 if($rows == false || count($rows) == 0) {
53 tem_show('empty_listing');
58 foreach($rows as $row) {
59 list($id, $username) = $row;
64 tem_set('username', $username);
65 tem_show('listing_row');
67 tem_show('populated_listing');
72 function people_main() {
73 if(!logged_in_as_contractor()) {
74 $GLOBALS['url'] = this_url();
75 message('You must be logged in as an administrator to access that function');
79 $ret = _people_main();
83 tem_show('main_body');
86 function _people_main() {
87 $edit_id = format_int($_REQUEST['people_edit_id']);
88 unset($_REQUEST['people_edit_id']);
90 # add hidden field for database id of row we're editing
91 tem_set('people_edit_id', $edit_id);
95 $delete_id = format_int($_REQUEST['people_delete_id']);
96 unset($_REQUEST['people_delete_id']);
98 db_delete('people', 'where id=%i', $delete_id);
99 message('Entry deleted.');
101 return './people.html';
105 if(!isset($_REQUEST['people_new']) && !isset($_REQUEST['username'])) {
106 people_display_listing();
113 if(isset($_REQUEST['username'])) {
114 list($username, $password, $name, $privs, $balance) = people_get_fields();
116 if("you're happy with the POSTed values") {
117 if(strlen($password) == 35 && substr($password, 32, 1) == ':') {
118 $password_hash = $password; # so we can edit a record, and leave the password be
120 $password_hash = encrypt_password($password);
124 db_update('people', PEOPLE_DB_FIELDS, $username, $password_hash, $name, $privs, $balance, 'where id=%i', $edit_id);
125 message('Entry updated.');
127 db_insert('people', PEOPLE_DB_FIELDS, $username, $password_hash, $name, $privs, $balance);
128 message('Entry saved.');
130 if($error !== true) {
134 # otherwise, we display the form again. people_get_fields() has
135 # already put the posted values back into the template engine, so they will
136 # show up in the form fields. You should add some message asking people to
137 # fix their entry in whatever way you require.
139 # we've recieved an edit id, but no data. So we grab the values to be edited from the database
140 list($username, $password, $name, $privs, $balance) = db_get_row('people', PEOPLE_DB_FIELDS, 'where id=%i', $edit_id);
141 people_tem_sets($username, $password, $name, $privs, $balance);
143 # form not submitted, you can set default values like so:
144 #tem_set('username', 'Yes');
147 # this has to be later in the file because it requres that username be set already
149 tem_show('edit_msg');