Changeset 19 for trunk/bin/module_maker/sql.cli.php
- Timestamp:
- Nov 14, 2005 6:22:44 AM (19 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/bin/module_maker/sql.cli.php
r18 r19 73 73 // Toggle types. 74 74 $c[$field] = "'\" . isset(\$frm['$field']) . \"'"; 75 } else if ('added_by_ admin_id' == $field || 'modified_by_admin_id' == $field) {75 } else if ('added_by_user_id' == $field || 'modified_by_user_id' == $field) { 76 76 // Toggle types. 77 77 $c[$field] = "'\" . addslashes(\$auth->getVal('user_id')) . \"'"; … … 94 94 // Insert SQL. 95 95 if (!isset($op) || 'insert' == $op) { 96 $insert_skip_columns = array('modified_datetime', 'modified_by_ admin_id');96 $insert_skip_columns = array('modified_datetime', 'modified_by_user_id'); 97 97 $insert_c = array(); 98 98 foreach ($c as $k=>$v) { … … 120 120 // Update SQL. 121 121 if (!isset($op) || 'update' == $op) { 122 $update_skip_columns = array('added_datetime', 'added_by_ admin_id');122 $update_skip_columns = array('added_datetime', 'added_by_user_id'); 123 123 $comma = ''; 124 124 $key_eq_val = ''; … … 181 181 // Search SQL 182 182 if (!isset($op) || 'search' == $op) { 183 $search_skip_columns = array('added_datetime', 'added_by_ admin_id', 'modified_datetime', 'modified_by_admin_id', 'publish', 'featured');183 $search_skip_columns = array('added_datetime', 'added_by_user_id', 'modified_datetime', 'modified_by_user_id', 'publish', 'featured'); 184 184 $search_columns = $db_tbl . '.' . join(" LIKE '%\" . addslashes(\$qry_words[\$i]) . \"%'\n OR $db_tbl.", array_diff(array_keys($c), $search_skip_columns)); 185 185 echo <<<E_O_F
Note: See TracChangeset
for help on using the changeset viewer.