Changeset 2011776
- Timestamp:
- 01/14/2019 04:43:57 AM (7 years ago)
- Location:
- nubuilder-forte/trunk
- Files:
-
- 5 edited
-
nubuilder-forte.php (modified) (3 diffs)
-
nubuilder-include.js (modified) (2 diffs)
-
nubuilder-include.php (modified) (18 diffs)
-
nubuilder4.sql (modified) (4 diffs)
-
readme.txt (modified) (5 diffs)
Legend:
- Unmodified
- Added
- Removed
-
nubuilder-forte/trunk/nubuilder-forte.php
r1992309 r2011776 2 2 /** 3 3 * @package nubuilder-forte 4 * @version 1. 24 * @version 1.3 5 5 */ 6 6 … … 10 10 Description: nuBuilder is a low-code, open-source application builder. Build reports and forms using Wordpress tables and any other table created in your Wordpress database. 11 11 Author: nuSoftware 12 Version: 1. 212 Version: 1.3 13 13 Text Domain: nubuilder-forte 14 14 */ … … 107 107 $nubuilder_session_data->SHORT_CODE_SESSION_NAME = nuID(); 108 108 $nubuilder_session_data->SHORT_CODE_ACCESS_LEVEL = $validated_short_code_attributes[NU_SHORT_CODE_AL]; 109 110 if ( is_user_logged_in() ) { 111 112 $auth_info = wp_get_current_user(); 113 $nubuilder_session_data->USER_LOGIN = $auth_info->user_login; 114 $nubuilder_session_data->USER_PASS = $auth_info->user_pass; 115 $nubuilder_session_data->USER_EMAIL = $auth_info->user_email; 116 $nubuilder_session_data->USER_DISPLAY_NAME = $auth_info->display_name; 117 $nubuilder_session_data->USER_ROLES = $auth_info->roles; 118 119 $nubuilder_session_data->SHORT_CODE_USER = 'Y'; 120 121 } else { 122 123 $nubuilder_session_data->USER_LOGIN = ''; 124 $nubuilder_session_data->USER_PASS = ''; 125 $nubuilder_session_data->USER_EMAIL = ''; 126 $nubuilder_session_data->USER_DISPLAY_NAME = ''; 127 $nubuilder_session_data->USER_ROLES = ''; 128 129 $nubuilder_session_data->SHORT_CODE_USER = 'N'; 130 } 131 109 132 $json = json_encode($nubuilder_session_data); 110 133 $encode = base64_encode($json); -
nubuilder-forte/trunk/nubuilder-include.js
r1990306 r2011776 983 983 } 984 984 985 if(window.nuTimesSaved > 0){985 // if(window.nuTimesSaved > 0){ 986 986 window.nuTimesSaved = -1; 987 }987 // } 988 988 989 989 … … 4744 4744 } 4745 4745 4746 if(nuSERVERRESPONSE.shortcode_session != ''){$('#nulogo').remove();} 4747 4746 4748 } 4747 4749 -
nubuilder-forte/trunk/nubuilder-include.php
r1992309 r2011776 3 3 if (basename(__FILE__) === basename($_SERVER['SCRIPT_NAME']) ) die('error no: 101 - permission denied'); 4 4 5 define('NU_BUILD', '1. 2.0.2018');5 define('NU_BUILD', '1.3.0.2018'); 6 6 define('NU_PRODUCTION_MODE', true); 7 7 define('NU_USE_APACHE_ERROR_LOG', false); … … 175 175 'nuSetup' => null, 176 176 'SHORT_CODE_SESSION_NAME' => '', 177 'SHORT_CODE_ACCESS_LEVEL' => '' 177 'SHORT_CODE_ACCESS_LEVEL' => '', 178 'SHORT_CODE_USER' => 'N' 178 179 ); 179 180 … … 187 188 self::$nubuilder['PLUGIN'] = true; 188 189 if ( $wpdata->GLOBEADMIN === true ) { 190 189 191 self::$nubuilder['GLOBEADMIN_NAME'] = $wpdata->USER_LOGIN; 190 192 self::$nubuilder['GLOBEADMIN_PASS'] = $wpdata->USER_PASS; 191 193 self::$nubuilder['GLOBEADMIN'] = true; 192 194 self::$nubuilder['isGlobeadmin'] = true; 193 } 195 196 } else { 197 198 self::$nubuilder['GLOBEADMIN_NAME'] = nuID(); 199 self::$nubuilder['GLOBEADMIN_PASS'] = nuID(); 200 self::$nubuilder['GLOBEADMIN'] = false; 201 self::$nubuilder['isGlobeadmin'] = false; 202 } 203 194 204 self::$nubuilder['USER_LOGIN'] = $wpdata->USER_LOGIN; 195 205 self::$nubuilder['USER_PASS'] = $wpdata->USER_PASS; … … 219 229 220 230 if ( isset($wpdata->SHORT_CODE_SESSION_NAME) ) { 221 self::$nubuilder['SHORT_CODE_SESSION_NAME'] = $wpdata->SHORT_CODE_SESSION_NAME;231 self::$nubuilder['SHORT_CODE_SESSION_NAME'] = $wpdata->SHORT_CODE_SESSION_NAME; 222 232 } 223 233 if ( isset($wpdata->SHORT_CODE_ACCESS_LEVEL) ) { 224 self::$nubuilder['SHORT_CODE_ACCESS_LEVEL'] = $wpdata->SHORT_CODE_ACCESS_LEVEL;234 self::$nubuilder['SHORT_CODE_ACCESS_LEVEL'] = $wpdata->SHORT_CODE_ACCESS_LEVEL; 225 235 } 236 if ( isset($wpdata->SHORT_CODE_USER) ) { 237 self::$nubuilder['SHORT_CODE_USER'] = $wpdata->SHORT_CODE_USER; 238 } 226 239 } 227 240 } … … 734 747 if ( true === $_SESSION[NU_NUBUILDER_SESSION_DATA]['NEW'] ) { 735 748 736 if ( $_SESSION[NU_NUBUILDER_SESSION_DATA]['SHORT_CODE_ACCESS_LEVEL'] == '' ) { 737 738 // Check if from wordpress and make sure they have an access level inside nubuiler 739 nuCheckWPUser(); 740 741 // check if views are missing and creates them if needed 742 nuCreateViews(); 743 } 749 // Check if we have a logged in user from wordpress and make sure they have an access level inside nubuiler 750 nuCheckWPUser(); 744 751 745 752 // update setup info, process login and put permission into session 746 753 nuAfterSessionInitializationNewSession(); // dies if login is invalid 747 } else { 754 755 } else { 748 756 // check session 749 757 nuAfterSessionInitializationExistingSession(); // dies if session has timed out … … 759 767 // this function runs during loading index.php and requires $_SESSION['nubuilder_session_data'] to be loaded 760 768 function nuCheckWPUser() { 769 770 if ( $_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_LOGIN'] == '' ) { 771 return; 772 } 761 773 762 774 $zzzzsys_user_id = nuID(); … … 838 850 $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_TIMESTAMP] = time(); 839 851 } 852 853 nuCheckTimeout(); // add SG 4 Jan 2019 854 } 855 856 857 function nuCheckTimeout(){ 858 859 $i = $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_ID]; 860 $m = time() - (60*60*2); //-- 2 hours 861 862 nuRunQuery('DELETE FROM zzzzsys_session WHERE sss_time < ' . $m); 863 864 $t = nuRunQuery('SELECT zzzzsys_session_id FROM zzzzsys_session WHERE zzzzsys_session_id = ? ',[$i]); 865 866 if(db_fetch_row($t)[0] == ''){ 867 868 nuDisplayError('Session has timed out.'); 869 return; 870 871 } 872 873 nuRunQuery('UPDATE zzzzsys_session SET sss_time = ? WHERE zzzzsys_session_id = ?', [time(), $i]); 840 874 } 841 875 … … 850 884 851 885 function nuAfterSessionInitializationNewSession() { 886 887 // check if views are missing and creates them if needed 888 nuCreateViews(); 852 889 853 890 // update setup info … … 1050 1087 $f->forms[0]->callback = $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_NUCALLBACK]; 1051 1088 $f->forms[0]->errors = $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_NUERRORS]; 1089 $f->forms[0]->form_access = $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_NUSETUP]->set_denied; 1090 $f->forms[0]->javascript = $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_EXTRAJS]; 1091 $f->forms[0]->target = $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_VALIDATED_INPUT][NU_POST_NUSTATE]['target']; 1052 1092 $f->forms[0]->global_access = $_SESSION[NU_NUBUILDER_SESSION_DATA]['GLOBAL_ACCESS']; 1053 $f->forms[0]->form_access = $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_NUSETUP]->set_denied; 1054 $f->forms[0]->javascript = $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_EXTRAJS]; 1055 $f->forms[0]->target = $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_VALIDATED_INPUT][NU_POST_NUSTATE]['target']; 1093 $f->forms[0]->shortcode_session = $_SESSION[NU_NUBUILDER_SESSION_DATA]['SHORT_CODE_SESSION_NAME']; 1056 1094 $b = nuButtons(); 1057 1095 $f->forms[0]->buttons = $b[0]; … … 5859 5897 } 5860 5898 5899 5900 function nuFormType($form_id){ 5901 5902 $t = nuRunQuery('SELECT sfo_type FROM zzzzsys_form WHERE zzzzsys_form_id = ?', [$form_id]); 5903 5904 return db_fetch_row($t)[0]; 5905 5906 } 5907 5908 5861 5909 function nuGatherFormAndSessionData($home) { 5862 5910 … … 5871 5919 } else { 5872 5920 5873 $formAndSessionData->record_id = '-1'; 5921 if(substr(nuFormType($home), 0, 1) == 'b'){ 5922 $formAndSessionData->record_id = ''; 5923 }else{ 5924 $formAndSessionData->record_id = '-1'; 5925 } 5926 5874 5927 } 5875 5928 … … 6006 6059 $_record_id = $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_VALIDATED_INPUT][NU_POST_NUSTATE]['record_id']; 6007 6060 6008 $ C= '';6009 $ D= '';6010 $a = nuFormAccess($formid, $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_PERMISSIONS][NU_SESSION_PERMS_FORMS]);6061 $code = ''; 6062 $description = ''; 6063 $access = nuFormAccess($formid, $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_PERMISSIONS][NU_SESSION_PERMS_FORMS]); 6011 6064 $f = nuFormProperties($formid); 6012 6065 6013 if($_call_type == 'getphp' or $_call_type == 'getreport'){ 6014 6015 6016 $t = nuRunQuery('SELECT * FROM zzzzsys_php WHERE zzzzsys_php_id = ?',[$_record_id]); 6017 $P = db_fetch_object($t); 6018 6019 $t = nuRunQuery('SELECT * FROM zzzzsys_report WHERE zzzzsys_report_id = ?',[$_record_id]); 6020 $R = db_fetch_object($t); 6021 6022 }else{ 6023 6024 $t = nuRunQuery('SELECT * FROM zzzzsys_php WHERE sph_code = ?',[$_record_id]); 6025 $P = db_fetch_object($t); 6026 6027 $t = nuRunQuery('SELECT * FROM zzzzsys_report WHERE sre_code = ? ', [$_record_id]); 6028 $R = db_fetch_object($t); 6029 6030 } 6031 6032 if($_call_type == 'getphp'){ 6033 6034 $C = $P->sph_code; 6035 $D = $P->sph_description; 6036 6037 if($P->sph_run == 'hide') { 6038 return [array('Add' => 0, 'Print' => 0, 'Save' => 0, 'Clone' => 0, 'Delete' => 0, 'Run' => '', 'RunHidden' => 'nuRunPHPHidden("'.$C.'")'), $C, $D]; 6066 if ( $_call_type == 'getphp' or $_call_type == 'getreport' ) { 6067 6068 $php = nuRunQueryObject('SELECT * FROM zzzzsys_php WHERE zzzzsys_php_id = ?',[$_record_id]); 6069 $report = nuRunQueryObject('SELECT * FROM zzzzsys_report WHERE zzzzsys_report_id = ?',[$_record_id]); 6070 } else { 6071 6072 $php = nuRunQueryObject('SELECT * FROM zzzzsys_php WHERE sph_code = ?',[$_record_id]); 6073 $report = nuRunQueryObject('SELECT * FROM zzzzsys_report WHERE sre_code = ? ', [$_record_id]); 6074 } 6075 6076 if ( $_call_type == 'getphp' ) { 6077 6078 $code = $php->sph_code; 6079 $description = $php->sph_description; 6080 6081 if($php->sph_run == 'hide') { 6082 return [array('Add' => 0, 'Print' => 0, 'Save' => 0, 'Clone' => 0, 'Delete' => 0, 'Run' => '', 'RunHidden' => 'nuRunPHPHidden("'.$code.'")'), $code, $description]; 6039 6083 }else{ 6040 return [array('Add' => 0, 'Print' => 0, 'Save' => 0, 'Clone' => 0, 'Delete' => 0, 'Run' => 'nuRunPHP("'.$ C.'")', 'RunHidden' => ''), $C, $D];6041 } 6042 } 6043 6044 if ($_call_type == 'getreport'){6045 6046 $ C = $R->sre_code;6047 $ D = $R->sre_description;6048 6049 return [array('Add' => 0, 'Print' => 0, 'Save' => 0, 'Clone' => 0, 'Delete' => 0, 'Run' => 'nuRunReport("'.$ C.'")', 'RunHidden' => ''), $C, $D];6050 } 6051 6052 if ($_call_type != 'getphp' and $c != 'getreport'){6053 return [array('Add' => $a [0], 'Print' => $a[1], 'Save' => $a[2], 'Clone' => $a[3], 'Delete' => $a[4], 'Run' => '', 'RunHidden' => ''), $C, $D];6084 return [array('Add' => 0, 'Print' => 0, 'Save' => 0, 'Clone' => 0, 'Delete' => 0, 'Run' => 'nuRunPHP("'.$code.'")', 'RunHidden' => ''), $code, $description]; 6085 } 6086 } 6087 6088 if ( $_call_type == 'getreport' ) { 6089 6090 $code = $report->sre_code; 6091 $description = $report->sre_description; 6092 6093 return [array('Add' => 0, 'Print' => 0, 'Save' => 0, 'Clone' => 0, 'Delete' => 0, 'Run' => 'nuRunReport("'.$code.'")', 'RunHidden' => ''), $code, $description]; 6094 } 6095 6096 if ( $_call_type != 'getphp' and $_call_type != 'getreport' ) { 6097 return [array('Add' => $access[0], 'Print' => $access[1], 'Save' => $access[2], 'Clone' => $access[3], 'Delete' => $access[4], 'Run' => '', 'RunHidden' => ''), $code, $description]; 6054 6098 } 6055 6099 } … … 6326 6370 $storeSessionInTableJSON = json_encode($storeSessionInTable); 6327 6371 6328 $values = array( $storeSessionInTableJSON, $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_ID] );6329 6330 nuRunQuery('INSERT INTO zzzzsys_session SET sss_ access = ?, zzzzsys_session_id = ?', $values);6372 $values = array(time(), $storeSessionInTableJSON, $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_ID] ); 6373 6374 nuRunQuery('INSERT INTO zzzzsys_session SET sss_time = ?, sss_access = ?, zzzzsys_session_id = ?', $values); 6331 6375 } 6332 6376 … … 6335 6379 $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_ID] = nuIDTEMP(); 6336 6380 $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_TIMESTAMP] = time(); 6337 $_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_LOGIN'] = ''; 6338 $_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_EMAIL'] = ''; 6339 $_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_DISPLAY_NAME'] = ''; 6340 $_SESSION[NU_NUBUILDER_SESSION_DATA]['translation'] = nuGetTranslation($_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_NUSETUP]->set_language); 6341 $_SESSION[NU_NUBUILDER_SESSION_DATA]['isGlobeadmin'] = false; 6342 6381 $_SESSION[NU_NUBUILDER_SESSION_DATA]['isGlobeadmin'] = false; 6382 $_SESSION[NU_NUBUILDER_SESSION_DATA]['GLOBAL_ACCESS'] = '0'; 6383 6384 if ( $_SESSION[NU_NUBUILDER_SESSION_DATA]['SHORT_CODE_USER'] == 'Y' ) { 6385 6386 6387 $checkLoginDetailsSQL = "SELECT * FROM zzzzsys_user WHERE sus_login_name = ?"; 6388 $checkLoginDetailsValues = array($_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_LOGIN']); 6389 $checkLoginDetailsOBJ = nuRunQueryObject($checkLoginDetailsSQL, $checkLoginDetailsValues); 6390 6391 $_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_ID'] = $checkLoginDetailsOBJ->zzzzsys_user_id; 6392 $_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_LOGIN'] = $checkLoginDetailsOBJ->sus_login_name; 6393 $_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_EMAIL'] = $checkLoginDetailsOBJ->sus_email; 6394 $_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_DISPLAY_NAME'] = $checkLoginDetailsOBJ->sus_name; 6395 $_SESSION[NU_NUBUILDER_SESSION_DATA]['translation'] = nuGetTranslation($checkLoginDetailsOBJ->sus_language); 6396 //$translationQRY = nuRunQuery(NU_SELECT_LANGUAGE, [$checkLoginDetailsOBJ->sus_language]); 6397 } else { 6398 6399 $_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_ID'] = ''; 6400 $_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_LOGIN'] = ''; 6401 $_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_EMAIL'] = ''; 6402 $_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_DISPLAY_NAME'] = ''; 6403 $_SESSION[NU_NUBUILDER_SESSION_DATA]['translation'] = nuGetTranslation($_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_NUSETUP]->set_language); 6404 } 6405 6343 6406 $sal_code = $_SESSION[NU_NUBUILDER_SESSION_DATA]['SHORT_CODE_ACCESS_LEVEL']; 6344 6407 $nuprepare = "SELECT * FROM zzzzsys_access WHERE sal_code = ? "; … … 6353 6416 $sessionIds = new stdClass; 6354 6417 $sessionIds->zzzzsys_access_id = $getAccessLevelOBJ->zzzzsys_access_id; 6355 $sessionIds->zzzzsys_user_id = '';6418 $sessionIds->zzzzsys_user_id = $_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_LOGIN']; 6356 6419 $sessionIds->zzzzsys_form_id = $getAccessLevelOBJ->sal_zzzzsys_form_id; 6357 6420 $sessionIds->global_access = '0'; … … 6361 6424 $storeSessionInTable->access_level_code = $getAccessLevelOBJ->zzzzsys_access_id; 6362 6425 6363 6364 6426 $_SESSION[NU_NUBUILDER_SESSION_DATA]['ACCESS_LEVEL_CODE'] = $getAccessLevelOBJ->sal_code; 6365 6427 $_SESSION[NU_NUBUILDER_SESSION_DATA]['ACCESS_LEVEL_ID'] = $getAccessLevelOBJ->zzzzsys_access_id; 6366 $_SESSION[NU_NUBUILDER_SESSION_DATA]['USER_ID'] = '';6367 6428 $_SESSION[NU_NUBUILDER_SESSION_DATA]['HOME_FORM_ID'] = $getAccessLevelOBJ->sal_zzzzsys_form_id; 6368 $_SESSION[NU_NUBUILDER_SESSION_DATA]['GLOBAL_ACCESS'] = '0';6369 6429 6370 6430 // form ids … … 6416 6476 $storeSessionInTableJSON = json_encode($storeSessionInTable); 6417 6477 6418 nuRunQuery('INSERT INTO zzzzsys_session SET sss_ access = ?, zzzzsys_session_id = ?', array($storeSessionInTableJSON, $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_ID]));6478 nuRunQuery('INSERT INTO zzzzsys_session SET sss_time = ?, sss_access = ?, zzzzsys_session_id = ?', array(time(), $storeSessionInTableJSON, $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_ID])); 6419 6479 } 6420 6480 … … 6514 6574 $storeSessionInTableJSON = json_encode($storeSessionInTable); 6515 6575 6516 nuRunQuery('INSERT INTO zzzzsys_session SET sss_ access = ?, zzzzsys_session_id = ?', array($storeSessionInTableJSON, $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_ID]));6576 nuRunQuery('INSERT INTO zzzzsys_session SET sss_time = ?, sss_access = ?, zzzzsys_session_id = ?', array(time(), $storeSessionInTableJSON, $_SESSION[NU_NUBUILDER_SESSION_DATA][NU_SESSION_ID])); 6517 6577 6518 6578 } -
nubuilder-forte/trunk/nubuilder4.sql
r1992309 r2011776 267 267 LOCK TABLES `zzzzsys_form` WRITE; 268 268 /*!40000 ALTER TABLE `zzzzsys_form` DISABLE KEYS */; 269 INSERT INTO `zzzzsys_form` VALUES ('nuhome','launch','nuhome','Home','','','',0,0,'','\n\nnuAttachButtonImage(\'run_php\',\'RP\');\nnuAttachButtonImage(\'run_setup\',\'SET\');\nnuAttachButtonImage(\'form_button\',\'F\');\nnuAttachButtonImage(\'run_lang\',\'TR\');\nnuAttachButtonImage(\'run_report\',\'RR\');\nnuAttachButtonImage(\'user_home\',\'UH\');\nnuAttachButtonImage(\'run_user\',\'U\');\nnuAttachButtonImage(\'run_file\',\'FILE\');\nnuAttachButtonImage(\'edit_php\',\'P\');\nnuAttachButtonImage(\'edit_report\',\'R\');\nnuAttachButtonImage(\'run_access\',\'KEY\');\nnuAttachButtonImage(\'run_fast_form\',\'FF\');\nnuAttachButtonImage(\'run_format\',\'FMT\');\nnuAttachButtonImage(\'run_fast_report\',\'FR\');\nnuAttachButtonImage(\'object_button\',\'OB\');\nnuAttachButtonImage(\'run_sql\',\'SQL\');\nnuAttachButtonImage(\'run_chart\',\'CH\');\nnuAttachButtonImage(\'open_database\',\'DB\');\nnuAttachButtonImage(\'system_update\',\'SU\');\n\n\n$(\'.nuActionButton\').hide();\n\n$(\'#user_home\').addClass(\'nuUserHomeButton\');\n\n$(\'#open_database\')\n.attr(\'title\', \'PHPMyAdmin\')\n//.click(function(){\n// window.open(\'nupmalogin.php\');\n//});\n\n\n$(\'#run_php\')\n.css(\'text-align\', \'left\')\n.css(\'padding\', \'0px 0px 0px 35px\')\n.css(\'background-size\', \'30px\')\n.css(\'background-repeat\', \'no-repeat\');\n\nnuGetStartingTab();\n'),('nubrowse','subform','nubrowse','Browse Columns','zzzzsys_browse','zzzzsys_browse_id','',0,5,'SELECT * FROM zzzzsys_browse\nORDER BY sbr_order\n','$(\'#nuSearchButton\').remove();\n$(\'#nuSearchField\').remove();\n$(\'#nuPrintButton\').remove();\n\nnuSetTitle($(\'#sbr_title\').val());\n\nvar pid = parent.nuFORM.getCurrent().record_id;\n\nif(nuFORM.getCurrent().record_id == -1){\n $(\'#sbr_zzzzsys_form_id\').val(pid).change();\n}\n'),('nutab','browse','nutab','Form Tab','zzzzsys_tab','zzzzsys_tab_id','',0,0,'SELECT * FROM zzzzsys_tab\nJOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id\nORDER BY syt_order','\n$(\"[data-nu-column=\'3\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n'),('nuobject','browseedit','nuobject','Object','zzzzsys_object','zzzzsys_object_id','',0,0,'SELECT * FROM zzzzsys_object\nJOIN #TABLE_ID# ON zzzzsys_object_id = theid\nJOIN zzzzsys_tab ON zzzzsys_tab_id = sob_all_zzzzsys_tab_id\nJOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id \n','\n$(\'#add_total\').css(\'overflow-y\',\'scroll\').css(\'background-color\',\'#ebebeb\');\n\n$(\'#zzzzsys_event_sfsev_javascript\').attr(\'id\',\'jsfuntitle\');\n$(\'#sob_calc_formula\').addClass(\'nuCalculatorCurrency\').css(\'font-size\', 12);\n$(\'#sob_all_display_condition\').addClass(\'sql\');\n$(\'#sob_all_default_value_sql\').addClass(\'sql\');\n$(\'#sob_display_sql\').addClass(\'sql\');\n$(\'#sob_select_sql\').addClass(\'sql\');\n$(\'#sob_lookup_php\').addClass(\'php\');\n$(\'#sob_lookup_javascript\').addClass(\'js\');\n$(\'#sob_input_javascript\').addClass(\'js\');\n$(\'#sob_html_javascript\').addClass(\'js\');\n$(\'#sob_html_code\').addClass(\'html\');\n$(\"[id$=\'sev_javascript\']\").addClass(\'js\');\n$(\"#title_zzzzsys_event_sfsev_javascript\").removeClass(\'js\');\n\n$(\'#nuTab8\').click(function(){nuTestChart();});\n\nnuAttachButtonImage(\'icon\', \'LUJS\');\nnuAttachButtonImage(\'ab_event\',\'AB\');\nnuAttachButtonImage(\'di_sql\',\'SQL\');\nnuAttachButtonImage(\'se_sql\',\'SQL\');\n\n$(\'#sob_lookup_javascript\')\n.css(\'padding\', \'3px 3px 3px 3px\')\n\n$(\'#viewflowchart\')\n.css(\'padding\', \'46px 0px 0px 3px\')\n.css(\'text-align\', \'left\')\n.css(\'background-size\', \'75px\')\n\n\nif($(\'#zzzzsys_event_sf000sev_event\').val() != \'\'){\n $(\'#nuTab10\').css(\'font-weight\', \'bold\');\n}\n\n\nif(nuFORM.getCurrent().record_id == -1){\n \n $(\'#sob_all_top\').val(0).change();\n $(\'#sob_all_left\').val(0).change();\n $(\'#sob_all_height\').val(0).change();\n $(\'#sob_all_width\').val(0).change();\n $(\'#sob_all_validate\').val(0).change();\n $(\'#sob_all_access\').val(0).change();\n $(\'#sob_all_align\').val(\'left\').change();\n $(\'#sob_all_cloneable\').val(1).change();\n \n nuHasNotBeenEdited();\n}\n\nvar v = $(\'#sob_input_type\').val();\n\nif(nuFormType() == \'edit\'){\n \n nuShowInputJS(v);\n nuHideCalcObjects();\n nuSetTitle($(\'#sob_all_id\').val());\n nuPopulateHTML();\n \n}\n\nvar filter = String(window.filter).split(\'|\');\n\nif(filter[0] == \'fromfastform\'){\n \n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#nuSaveButton\').remove();\n $(\'#sob_all_id\').val(filter[1]).addClass(\'nuHighlight\');\n $(\'#sob_all_label\').val(filter[2]).addClass(\'nuHighlight\');\n \n}\n\n\n\n$(\'.js\').dblclick(function() {nuOpenAce(\'Javascript\', this.id);});\n$(\'.sql\').dblclick(function() {nuOpenAce(\'SQL\', this.id);});\n$(\'.html\').dblclick(function() {nuOpenAce(\'HTML\', this.id);});\n$(\'.php\').dblclick(function() {nuOpenAce(\'PHP\', this.id);});\n\nnuObjectColor();\n\n$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\nnuHide(\'sob_input_format\');\n\nvar sit = $(\'#sob_input_type\').val();\n\nif(sit == \'nuDate\' || sit == \'nuNumber\'){\n nuShow(\'sob_input_format\');\n}\n\nif(sit == \'nuScroll\'){\n nuShow(\'sob_input_javascript\');\n}else{\n nuHide(\'sob_input_javascript\');\n}\n\nnuGetStartingTab();\n\nfunction nuTestChart(){\n \n var g = $(\'#sob_html_chart_type\').val();\n var t = $(\'#sob_all_type\').val();\n \n if(g == \'\' || t != \'html\'){$(\'#google_chart\').html(\'\');return;}\n \n var c = \'ComboChart\';\n var t = $(\'#sob_html_title\').val();\n var x = $(\'#sob_html_vertical_label\').val();\n var y = $(\'#sob_html_horizontal_label\').val();\n var l = \'bars\';\n var s = false;\n var a = [\n [\'Month\', \'Shane\', \'Dave\', \'Adam\', \'Paul\', \'Chris\'],\n [\'2004\', 100, 200, 300, 400, 500],\n [\'2005\', 165, 238, 322, 498, 550],\n [\'2006\', 165, 938, 522, 998, 450],\n [\'2007\', 135, 1120, 599, 1268, 288]\n ];\n \n if(g == \'p\') {c = \'PieChart\';}\n if(g == \'l\') {l = \'lines\';}\n if(g == \'bh\') {c = \'BarChart\';}\n if(g == \'bhs\') {c = \'BarChart\';}\n if(g == \'bs\') {s = true;}\n if(g == \'bhs\') {s = true;}\n\n nuChart(\'google_chart\', c, a, t, x, y, l, s);\n\n}\n\n\n\n\n\nfunction nuObjectColor(){\n \n $(\'.nuValidate\').removeClass(\'nuValidate\');\n\n var e = $(\'#sob_all_type\').hasClass(\'nuEdited\');\n var o = [];\n\n o[\'run\'] = 1;\n o[\'display\'] = 2;\n o[\'select\'] = 3;\n o[\'lookup\'] = 4;\n o[\'subform\'] = 5;\n o[\'image\'] = 6;\n o[\'input\'] = 7;\n o[\'html\'] = 8;\n o[\'calc\'] = 9;\n \n\n $(\'#sob_all_type\').removeClass();\n \n if(e){ //-- keep class if edited\n $(\'#sob_all_type\').addClass(\'nuEdited\');\n }\n \n $(\'#sob_all_type\').addClass(\'nu_\'+$(\'#sob_all_type\').val());\n \n $(\"#sob_all_type > option\").each(function() {\n $(this).addClass(\'nu_\'+this.value);\n });\n \n $(\"#sob_input_type > option\").each(function() {\n $(this).addClass(\'input_\'+this.value);\n });\n \n var t = o[$(\'#sob_all_type\').val()];\n \n $(\"[id^=\'nuTab\']\").removeClass(\'nuRelatedTab\');\n \n for(var i = 1 ; i < o.length ; i++){\n $(\'#nuTab\' + i).removeClass(\'nuRelatedTab\');\n }\n \n $(\'#nuTab0\').addClass(\'nuRelatedTab\');\n $(\'#nuTab\' + t).addClass(\'nuRelatedTab\');\n \n} \n\n\nfunction nuAddToFormula(e){\n \n var fld = e.target.innerHTML;\n var frm = $(\'#sob_calc_formula\').val();\n \n if(fld == \'Clear\'){\n \n $(\'#sob_calc_formula\')\n .val(\'\')\n .addClass(\'nuEdited\');\n return;\n \n }\n\n $(\'#sob_calc_formula\')\n .addClass(\'nuEdited\')\n .val(frm + fld);\n \n nuHasBeenEdited();\n \n}\n\nfunction nuShowInputJS(t){\n\n nuHide(\'sob_input_format\');\n nuHide(\'sob_input_count\');\n nuHide(\'sob_input_javascript\');\n \n if(t == \'nuScroll\'){\n nuShow(\'sob_input_javascript\');\n }\n\n if(t == \'nuAutoNumber\'){\n \n nuShow(\'sob_input_count\');\n $(\'#sob_input_javascript\').val(\'\').change();\n \n }\n\n if(t == \'nuDate\' || t == \'nuNumber\'){\n \n nuShow(\'sob_input_format\');\n\n $(\'#sob_input_format\').children().each(function(index) {\n \n $(this).show();\n \n if($(this).val()[0] == \'D\' && t != \'nuDate\') {$(this).hide();}\n if($(this).val()[0] == \'N\' && t != \'nuNumber\') {$(this).hide();}\n \n });\n \n }\n \n}\n\n\nfunction nuHideCalcObjects(){\n\n var f = $(\'#sob_all_zzzzsys_form_id\').val();\n\n $(\'#add_total\').children().each(function(index) {\n\n\n if($(this).val() != f){\n $(this).hide();\n }\n if($(this).text() == $(\'#sob_all_id\').val()){\n $(this).hide();\n }\n\n });\n \n}\n\n\nfunction nuAddCalcObject(t){\n \n var f = $(\'#sob_calc_formula\').val();\n var i = $(t).attr(\'data-nu-ids\');\n var s = f + \"nuTotal(\'\" + i + \"\')\";\n \n if(i == \'\'){return;}\n\n $(\'#sob_calc_formula\')\n .addClass(\'nuEdited\')\n .val(s);\n\n $(\'#add_total\').val(\'\');\n \n nuHasBeenEdited();\n \n}\n\n\nfunction nuPopulateHTML(){\n\n var o = nuCalcObjects();\n var a = [];\n\n for(var i = 0 ; i < o.length ; i++){\n \n var ids = String(o[i].ids);\n var ty = o[i].type;\n var id = String(o[i].ids).split(\'.\');\n var sp = \' \';\n\n if(id.length == 1){\n a.push(\'<tr><td><div title=\"\'+ty+\'\" style=\"overflow:hidden;width:314px;text-align:left;padding:2px\" onclick=\"nuAddCalcObject(this);\" class=\"nuCalculatorButton nu_\' + o[i].type + \'\" data-nu-ids=\"\' + ids + \'\">\' + ids + \'</div></td></tr>\');\n }else{\n \n var h = \'<span title=\"subform\" class=\"nu_subform\">\' + id[0] + \'</span>.<span title=\"\'+ty+\'\" class=\"nu_input\" style=\"padding:7px 5px 7px 5px\">\' + id[1] + sp.repeat(200) + \'</span>\';\n a.push(\'<tr><td><div style=\"overflow:hidden;width:314px;text-align:left;padding:2px\" onclick=\"nuAddCalcObject(this);\" class=\"nuCalculatorButton nu_subform\" data-nu-ids=\"\' + ids + \'\">\' + h + \'</div></td></tr>\');\n \n }\n \n }\n\n $(\'#add_total\').html(\'<table>\' + a.join(\'\') + \'</table>\');\n\n}\n\n\n'),('nufflaunch','launch','nufflaunch','Form Builder','','','',0,0,'SELECT * FROM zzzzsys_form','\n$(\"[id$=\'ff_browse\']\").hide();\n$(\'#title_obj_sfff_browse\').show();\n$(\'#ffwrd\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'#wrdaddable\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'.nuActionButton\').hide();\n$(\'#nuTab0\').remove();\n$(\'#fastform_type\').focus();\n\nnuSetFK();\n\nnuAddActionButton(\'nuRunPHPHidden\', \'Build Fast Form\', \'nuRunPHPHidden(\"RUNFF\")\');\n\n$(\"#fastform_type > option\").each(function() {\n $(this).addClass(\'nu_\' + this.value);\n});\n\nfunction nuFormColor(){\n\n var t = String($(\'#fastform_type\').val());\n \n $(\'#fastform_type\').removeClass();\n $(\'#fastform_type\').addClass(\'nu_\'+$(\'#fastform_type\').val());\n \n if(t == \'launch\'){\n \n $(\'#fastform_table\').hide();\n $(\'#label_fastform_table\').hide();\n\n }else{\n $(\'#fastform_table\').show();\n $(\'#label_fastform_table\').show();\n }\n \n \n if(t == \'browse\' || t == \'browseedit\'){\n \n $(\"[id$=\'ff_browse\']:checkbox\").each(function(index){\n \n var fld = \'#\' + this.id.substr(0, 6) + nuPad3(index + 1) + \'ff_field\';\n\n if($(fld).length == 1){\n $(this).show();\n }\n \n });\n \n }else{\n $(\"[id$=\'ff_browse\']:checkbox\").hide();\n }\n\n nuSetFK();\n\n}\n\n\nfunction nuSetFFTable(){\n \n var v = $(\'#fastform_table\').val();\n\n if(nuFORM.getTables().indexOf(v) == -1){\n \n $(\"[data-nu-field=\'ff_field\']\")\n .removeClass(\'input_nuScroll\')\n .removeClass(\'nuScroll\');\n\n }else{\n \n $(\"[data-nu-field=\'ff_field\']\")\n .addClass(\'input_nuScroll\')\n .addClass(\'nuScroll\');\n\n }\n\n $(\"#title_obj_sfff_field\")\n .removeClass(\'input_nuScroll\')\n .removeClass(\'nuScroll\');\n \n var l = $(\"[id$=\'ff_browse\']\").length-2;\n \n $(\'#obj_sf\' + nuPad3(l) + \'ff_browse\').hide();\n\n nuSetFK();\n \n}\n\n\nfunction nuSetFK(){\n \n $(\'#fastform_fk\').hide();\n $(\'#label_fastform_fk\').hide();\n\n var v = $(\'#fastform_table\').val();\n\n if(v != \'\' && nuFORM.getTables().indexOf(v) == -1 && $(\'#fastform_type\').val() == \'subform\'){\n \n $(\'#fastform_fk\').show().focus();\n $(\'#label_fastform_fk\').show();\n\n }\n \n}\n\n\nfunction nuShowFFO(e){\n \n var t = $(\'#\' + e.target.id).attr(\'data-nu-prefix\');\n var i = $(\'#\' + t + \'ff_id\').val();\n var l = $(\'#\' + t + \'ff_label\').val();\n var f = $(\'#\' + t + \'ff_field\').val();\n var fff = \'fromfastform|\' + f + \'|\' + l;\n\n nuPopup(\'nuobject\', i, fff);\n\n}\n\nfunction nuFocusFFObject(e){\n\n var p = $(e.target).attr(\'data-nu-prefix\');\n \n if($(\'#\' + p + \'ff_id\').val() == \'\'){\n $(\'#fastform_table\').focus();\n }\n \n}\n\n\n\n\nfunction nuMoveFF(){\n \n var i = $(\'#new_id\').val();\n\n nuPopup(i, -2);\n\n}\n\nfunction nuCreateSQLPrefix(){\n \n var p = $(\'#fastform_prefix\');\n var t = $(\'#fastform_table\');\n \n p.val(String(t.val()).substr(0, 3));\n \n}\n\n\nfunction nuBeforeSave(){\n \n var table = $(\'#fastform_table\').val();\n var type = String($(\'#fastform_type\').val());\n var browse = type.substr(0, 6) == \'browse\';\n\n if(table == \'\' && type != \'launch\'){\n \n nuMessage([\'Table Name cannot be left blank..\']);\n \n return false;\n\n }\n \n if(type == \'\'){\n \n nuMessage([\'Must select <b>Form Type</b>...\']);\n \n return false;\n\n }\n \n if(browse){\n \n if($(\"[data-nu-field=\'ff_browse\']:checked\").length == 0){\n \n nuMessage([\'At least 1 Browse needs to be checked..\']);\n \n return false;\n \n }\n \n }\n\n var v = $(\'#fastform_table\').val();\n var t = $(\'#fastform_type\').val();\n var f = $(\'#fastform_fk\').val();\n\n if(v != \'\' && nuFORM.getTables().indexOf(v) == -1 && t == \'subform\' && f == \'\'){\n \n nuMessage([\'<b>Foreign Key Field Name</b> cannot be left blank...\']);\n \n return false;\n\n }\n \n var a = [];\n \n for(var i = 0 ; i < nuSubformObject(\'obj_sf\').rows.length ; i++){\n a.push(nuSubformObject(\'obj_sf\').rows[i][2]);\n }\n\n\n if(f != \'\' && a.indexOf(f) > -1 && t == \'subform\'){\n \n nuMessage([\'<b>Foreign Key Field Name</b> is already used...\']);\n \n return false;\n\n }\n \n\n\n\n\n \n \n if(!nuValidColumn()){\n return false;\n }\n\n return true;\n \n}\n\n\nfunction nuValidColumn(){\n \n var tn = $(\'#fastform_table\').val();\n \n if(nuFORM.getTables().indexOf(tn) == -1){return true;}\n \n var sf = nuSubformObject(\'obj_sf\');\n \n for(var i = 0 ; i < sf.rows.length ; i++){\n \n if(sf.rows[i][4] == 1 && sf.deleted[i] != 1){ //-- ticked column checkbox\n \n var valid = nuFORM.tableSchema[tn].names.indexOf(sf.rows[i][2]) //-- fieldname\n \n if(valid == -1){\n \n nuMessage([\'Invalid column name <b>\' + sf.rows[i][2] + \'</b>\']);\n \n return false;\n \n }\n }\n \n }\n \n return true;\n\n}\n\n\nfunction nuSelectFFObjects(e){\n \n var classes = e.target.className.split(\' \');\n var id = e.target.id;\n var rowno = nuPad3($(\"[id^=\'obj_sf\'][id$=\'ff_label\']\", document).length-1);\n var rowsuf = nuPad2(rowno);\n var sfrow = \'#obj_sf\' + rowno;\n var h = String(e.target.innerHTML).split(\':\');\n \n $(sfrow + \'ff_label\')\n .val(h[h.length-1] + rowsuf)\n .addClass(classes[1])\n .change();\n\n $(sfrow + \'ff_field\')\n .val(\'field\' + rowsuf)\n .change();\n\n $(sfrow + \'ff_id\')\n .val(id)\n .change();\n \n var nb = [\'Word\', \'Subform\', \'Image\', \'HTML\', \'Display\', \'Input:file\', \'Input:button\', \'Select:multiselect\'].indexOf(e.target.innerHTML); \n\n if(nb == -1){\n $(sfrow + \'ff_browse\').show();\n }else{\n $(sfrow + \'ff_browse\').remove();\n }\n \n $(\'#fastform_type\').change();\n\n}\n\n\n\n'),('nuevent','edit','nuevent','Object Events','zzzzsys_event','zzzzsys_event_id','',0,0,'SELECT * FROM zzzzsys_event',''),('nuaccess','browseedit','nuaccess','Access Levels','zzzzsys_access','zzzzsys_access_id','',0,0,'SELECT * FROM zzzzsys_access\nORDER BY sal_code\n','nuSetTitle($(\'#sal_code\').val());'),('nunonsystemform','edit','nunonsystemform','nuBuilder non-System Form','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nWHERE ((zzzzsys_form_id NOT LIKE \'nu%\' AND sfo_type != \'subform\')\nOR zzzzsys_form_id IN (\'nuaccess\', \'nuuser\', \'nulaunchdates\', \'nutranslate\', \'nupassword\', \'nufile\', \'nuuserhome\', \'nublank\', \'nurunreport\'))\nORDER BY sfo_code','$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\n'),('nuaccessforms','edit','nuaccessforms','Accessible Forms','zzzzsys_access_form','zzzzsys_access_form_id','',0,0,'SELECT * FROM zzzzsys_access_form\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = slf_zzzzsys_form_id\nORDER BY sfo_code\n',''),('nuuser','browseedit','nuuser','User','zzzzsys_user','zzzzsys_user_id','',0,15,'SELECT * \nFROM zzzzsys_user \nLEFT JOIN zzzzsys_access ON zzzzsys_access_id = sus_zzzzsys_access_id\nORDER BY sus_name',''),('nubuildreport','browseedit','nubuildreport','Build Report','zzzzsys_report','zzzzsys_report_id','',0,0,'SELECT * FROM zzzzsys_report\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = sre_zzzzsys_form_id','\n$(\'#sre_layout\').addClass(\'nuEdited\'); \n\nnuAttachButtonImage(\'open_builder\',\'RD\');\n\n\nfunction nuPickTableType(){\n \n var i = $(\'#sre_zzzzsys_php_id\').val();\n \n var f = \'\';\n var r = \'\';\n \n if(i.substr(0,10) == \'PROCEDURE:\'){\n \n f = \'nuphp\';\n r = i.substr(10);\n \n }\n \n if(i == \'\'){\n \n nuMessage([nuTranslate(\'Table selected must be an SQL or Procedure\')]);\n return;\n\n }\n \n if(i.substr(0,6) == \'TABLE:\'){\n \n nuMessage(nuTranslate([\'To edit a table go to the Database Button\']));\n return;\n\n }\n \n if(i.substr(0,4) == \'SQL:\'){\n \n f = \'nuselect\';\n r = i.substr(4);\n\n }\n \n nuPopup(f,r);\n \n}\n'),('nuphp','browseedit','nuphp','Build Procedure','zzzzsys_php','zzzzsys_php_id','',0,0,'SELECT * FROM zzzzsys_php\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = sph_zzzzsys_form_id\nWHERE (sph_system != \'1\' || sph_system IS NULL)\nORDER BY sph_code\n','\nwindow.nuImages = parent.nuImages;\n\n$(\'#sph_php\')\n.addClass(\'php\')\n.dblclick(function() {\n nuOpenAce(\'PHP\', this.id);\n})\n\n\nwindow.nuHelp = \'Procedures\';\n\nif(window.filter == \'justphp\'){\n\n nuHelp = \'Functions\';\n var ev = [];\n ev[\'BB\'] = \'Before Browse\';\n ev[\'BE\'] = \'Before Edit\';\n ev[\'BS\'] = \'Before Save\';\n ev[\'AS\'] = \'After Save\';\n ev[\'BD\'] = \'Before Delete\';\n ev[\'AD\'] = \'After Delete\';\n ev[\'AB\'] = \'After Browse\';\n \n var suf = nuFORM.getCurrent().record_id.substr(-2);\n var e = ev[suf];\n var f = $(\'#sfo_description\', window.parent.document).val();\n\n if(e == \'After Browse\'){\n var f = $(\'#sob_all_label\', window.parent.document).val();\n }\n\n nuAttachButtonImage(\'icon\', suf);\n \n $(\'#sph_php\')\n .css(\'padding\', \'3px 3px 3px 3px\')\n .css(\'top\', \'40px\')\n .css(\'height\', \'200px\')\n .css(\'left\', \'90px\')\n .focus()\n\n \n $(\'#wiki\')\n .css(\'left\', \'670px\')\n\n $(\'#nu_bc_0\').html(\'<b>\' + e + \'</b> for : \' + f);\n $(\'#sph_code\').val(nuFORM.getCurrent().record_id).change();\n $(\'#sph_description\').val(\'System PHP\').change();\n $(\'#sph_system\').val(\'1\').change();\n $(\'#label_sph_php\').css(\'top\', \'40px\').css(\'left\', \'20px\');\n $(\'.nuSaveButtonEdited\').removeClass(\'nuSaveButtonEdited\');\n \n nuHide(\'sph_code\');\n nuHide(\'sph_description\');\n nuHide(\'sph_zzzzsys_form_id\');\n nuHide(\'sph_group\');\n nuHide(\'sph_system\');\n nuHide(\'sph_run\');\n\n nuSetTitle(e);\n \n}else{\n nuSetTitle($(\'#sph_code\').val());\n}\n\nnuHasNotBeenEdited();\n\n\n'),('nublank','launch','nublank','Blank','','','',0,0,'','\nnuSetTitle(nuFORM.getCurrent().run_description);\n'),('nuaccessgroup','subform','nuaccessgroup','Groups Access Level','zzzzsys_user_group_access_level','zzzzsys_user_group_access_level_id','',0,0,'SELECT * FROM zzzzsys_user_group_access_level',''),('nurunlist','browse','nurunlist','Run Form, Report or Procedure','zzzzsys_run_list','id','',0,0,'SELECT * FROM zzzzsys_run_list','\n$(\"[data-nu-column=\'nucolumn000\']\").each(function() {\n\n $(this).addClass(\'nu_\'+this.innerHTML);\n\n});'),('nudebug','browseedit','nudebug','nuDebug Entries','zzzzsys_debug','zzzzsys_debug_id','',21,15,'SELECT * FROM zzzzsys_debug\nORDER BY zzzzsys_debug_id DESC','\n$(\'#deb_message\')\n .css(\'font-size\', 10)\n .css(\'background-color\', \'#FFEEA6\')\n .prop(\'readonly\', true)\n .dblclick(function() {\n nuOpenAce(\'Text\', this.id);\n });\n\n\n\n\n\n$(\'#delete_option\').val(0);\n$(\'#nuAddButton\').remove();\n$(\'#nuOptions\').remove();\n\nvar mess = String($(\'#deb_message\').val());\nvar i = mess.indexOf(\'<br>\');\nvar m = mess.substr(i + 6);\nvar t = mess.substr(0,i);\n\nnuSetTitle(mess.substr(0, i))\n\n$(\'#nuTab0\').remove();\n\n$(\'#nuBreadcrumb1\')\n.css(\'text-align\', \'center\')\n.css(\'width\', \'95%\')\n.css(\'color\', \'black\')\n.css(\'padding\', \'5px\')\n.html(t + \' :: \' + nuWhen($(\'#deb_added\').val()))\n.appendTo(\"#nuTabHolder\");\n\n$(\'#deb_message\').val(m);\n\n\n$(\"[data-nu-column=\'1\']\").each(function( index ) {\n \n if($(this).html().trim() != \'\'){\n \n var nunow = Date.now();\n var nuhtm = nuWhen(Number($(this).html()));\n \n $(this).html(nuhtm);\n \n }\n \n});\n\nif(nuFORM.getCurrent().record_id != \'\'){\n\n $(\'.nuActionButton\').remove();\n nuAddActionButton(\'Delete\');\n nuAddActionButton(\'DeleteAll\',\'Delete All\', \'nuDeleteAllAction()\');\n\n}else{\n nuAddActionButton(\'DeleteAll\',\'Delete All\', \'nuDeleteAllAction()\');\n}\n\n'),('nuaccessreport','browseedit','nuaccessreport','Access To Procedures','zzzzsys_access_php','zzzzsys_access_php_id','',0,0,'SELECT * \nFROM zzzzsys_access_php\nJOIN zzzzsys_php ON zzzzsys_php_id = slp_zzzzsys_php_id\nORDER BY sph_code',''),('nuaccesslevelreport','browseedit','nuaccesslevelreport','Access To Report','zzzzsys_access_report','zzzzsys_access_report_id','',0,0,'SELECT * \nFROM zzzzsys_access_report\nJOIN zzzzsys_report ON zzzzsys_report_id = sre_zzzzsys_report_id\nORDER BY sre_code',''),('nurunreport','browseedit','nurunreport','Run Report','zzzzsys_report','zzzzsys_report_id','',0,0,'SELECT * FROM zzzzsys_report\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = sre_zzzzsys_form_id','\nnuSetTitle(nuFORM.getCurrent().run_description);\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\nfunction nuSelectBrowse(e){\n \n var r = $(\'#\' + e.target.id).attr(\'data-nu-row\');\n var f = $(\'#nucell_\' + r + \'_0\').html();\n var p = $(\'#\' + e.target.id).attr(\'data-nu-primary-key\');\n\n nuGetReport(f, p);\n \n}\n\n'),('nurunphp','browseedit','nurunphp','Run Procedure','zzzzsys_php','zzzzsys_php_id','',0,0,'SELECT * FROM zzzzsys_php\nJOIN zzzzsys_form ON zzzzsys_form_id = sph_zzzzsys_form_id\nWHERE (sph_system != \'1\' || sph_system IS NULL)\nORDER BY sph_code','\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\nfunction nuSelectBrowse(e){\n\n var r = $(\'#\' + e.target.id).attr(\'data-nu-row\');\n var p = $(\'#nucell_\' + r + \'_0\').html();\n var f = $(\'#\' + e.target.id).attr(\'data-nu-primary-key\');\n\n nuGetPHP(p, f);\n\n}\n\n'),('nulaunchdates','launch','nulaunchdates','Between 2 Dates','','','',0,0,'','\nnuSetTitle(nuFORM.getCurrent().run_description);'),('nutimezone','browse','nutimezone','Time Zone','zzzzsys_timezone','zzzzsys_timezone_id','',0,0,'SELECT * \nFROM zzzzsys_timezone\nORDER BY stz_timezone',''),('nusetup','edit','nusetup','Setup','zzzzsys_setup','zzzzsys_setup_id','',0,0,'','$(\'#set_header\').addClass(\'html\');\n \n$(\'.html\').dblclick(function() {\n nuOpenAce(\'HTML\', this.id);\n});\n\n'),('nutranslate','browseedit','nutranslate','Translation','zzzzsys_translate','zzzzsys_translate_id','',0,0,'SELECT * \nFROM zzzzsys_translate\nORDER BY trl_language, trl_english',''),('nupassword','edit','nupassword','Change Password','zzzzsys_user','zzzzsys_user_id','',0,0,'SELECT * FROM zzzzsys_user\nJOIN zzzzsys_user_group ON sus_zzzzsys_user_group_id = zzzzsys_user_group_id\nORDER BY sus_name','$(\'#nuTab0\').hide();'),('nusample','launch','nusample','Default Fast Form Objects','','','',0,0,'','//$(\'#nuBreadcrumbHolder\').remove();\n$(\'#nuActionHolder\').remove();\n//$(\'#nuTabHolder\').remove();\n\n$(\'#nuOptions\').hide();\n\n$(\'#inputtextsample\').val(\'text\');\n$(\'#inputnumbersample\').val(4);\n$(\'#inputnunumbersample\').val(\'$ 1,234.56\');\n$(\'#inputnudatesample\').val(\'20-Apr-2017\');\n$(\'#inputnuscrollsample\').val(\'East\');\n$(\'#calcsample\').val(\'$ 1,238.56\');\n\n$(\'#selectsample\').val(1);\n$(\'#selectmultiselectsample\').val(0);\n$(\'#textareasample\').val(\"text-area blah blah blah blah \");\n\n$(\"[id^=\'label\']\").addClass(\'nu_input\').css({width:120, left:10, \'text-align\':\'center\'});\n\n$(\'#label_imagesample\').addClass(\'nu_image\').removeClass(\'nu_input\');\n$(\'#label_textareasample\').addClass(\'nu_textarea\').removeClass(\'nu_input\');\n$(\'#label_displaysample\').addClass(\'nu_display\').removeClass(\'nu_input\');\n$(\'#label_htmlsample\').addClass(\'nu_html\').removeClass(\'nu_input\');\n$(\'#label_calcsample\').addClass(\'nu_calc\').removeClass(\'nu_input\');\n$(\'#label_selectsample\').addClass(\'nu_select\').removeClass(\'nu_input\');\n$(\'#label_selectmultiselectsample\').addClass(\'nu_select\').removeClass(\'nu_input\');\n$(\'#label_lookupsample\').addClass(\'nu_lookup\').removeClass(\'nu_input\');\n$(\'#labelword\').addClass(\'nu_word\').removeClass(\'nu_input\');\n$(\'#label_subformsample\').addClass(\'nu_subform\').removeClass(\'nu_input\').css({left:10});\n\n$(\"[id^=\'label\']\")\n.addClass(\'nuCalculatorButton\')\n.removeClass(\'nuWord\')\n.css({\'height\':30, \'width\':220})\n\n\n\n\n'),('nufastformobjects','subform','nufastformobjects','Fast Form Objects','zzzzsys_debug','zzzzsys_debug_id','',0,0,'SELECT count()* FROM zzzzsys_debug',''),('nucalcobjects','browse','nucalcobjects','Calc values On This Form And Its Subforms','#TABLE_ID#','thevalue','',0,4,'SELECT * FROM #TABLE_ID#','\nwindow.nuBrowseFunction = \'nuSelectCalcField\';\n\nfunction nuSelectCalcField(e){\n\n var row = e.target.id.substr(0,8);\n var fld = $(\'#\' + row + \'003\').html();\n var frm = $(\'#sob_calc_formula\', parent.window.document).val();\n\n $(\'#sob_calc_formula\', parent.window.document)\n .val(frm + \'nuTotal(\"\' + fld + \'\")\')\n .trigger(\'change\');\n\n}\n\n'),('nuformat','browseedit','nuformat','Input Formats','zzzzsys_format','zzzzsys_format_id','',0,0,'SELECT * FROM zzzzsys_format','\n$(\'#nucalculator\').css(\'border\',\'none\');\n$(\'#currencysign\').hide().addClass(\'nuCalculatorCurrency\').val(\'$\');\n$(\'#currencydecimals\').hide().addClass(\'nuCalculatorCurrency\').val(\'2\');\n$(\'#srm_format\').addClass(\'nuReadonly nuCalculatorCurrency\').css(\'font-size\', 12);\n$(\'.nuWord\').css(\'font-style\', \'bold\');\n\nnuSetFormatType();\n\n\nfunction nuAddToFormat(e){\n \n var v = String(e.target.innerHTML);\n \n if(v == \'Space\'){v = \' \';}\n \n if($(\'#srm_type\').val() == \'Date\'){\n \n $(\'#srm_format\')\n .val($(\'#srm_format\').val() + v)\n .change();\n \n }else{\n \n var c = String($(\'#currencysign\').val()).trim();\n var d = String(Number($(\'#currencydecimals\').val()));\n \n d = d == \'NaN\' ? 0 : Number(d);\n v = d == 0 ? v.substr(0, v.length - 1) : v;\n \n $(\'#srm_format\')\n .val(c + \' \' + v + String(0).repeat(d))\n .change();\n \n }\n \n}\n\n\nfunction nuSetFormatType(a){\n\n $(\'#format_title\').hide();\n $(\'#nucalculator\').hide();\n $(\'#currencysign\').hide();\n $(\'#currencydecimals\').hide();\n $(\'.date\').hide();\n $(\'.number\').hide();\n\n if(arguments.length == 1){\n $(\'#srm_format\').val(\'\');\n }\n \n if($(\'#srm_type\').val() == \'Date\'){\n $(\'.date\').show();\n }\n \n if($(\'#srm_type\').val() == \'Number\'){\n \n $(\'#currencysign\').show();\n $(\'#currencydecimals\').show();\n $(\'.number\').show();\n\n }\n\n $(\'#format_title\').show();\n $(\'#nucalculator\').show();\n \n}\n\n\n\n'),('nuformatcurrency','edit','nuformatcurrency','Format Currency','zzzzsys_format','zzzzsys_format_id','',0,0,'','$(\'#sign\').focus();\n\n\n$(\'#nuActionHolder\').remove();\n$(\'#nuBreadcrumbHolder\').remove();\n$(\'#nuTabHolder\').remove();\n\n\n\n\n\nfunction nuCreateCurrencyFormat(){\n console.log(\'in nuCreateCurrencyFormat()\');\n}\n'),('nuform','browseedit','nuform','nuBuilder Form','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nINNER JOIN #TABLE_ID# ON zzzzsys_form_id = theid\nORDER BY sfo_code\n','$(\'#title_zzzzsys_tab_sfsyt_help\').attr(\'id\', \'help_title\');\n$(\"[id$=\'syt_help\']\").addClass(\'js\');\nnuAttachButtonImage(\'previewbrowse\',\'PB\');\nnuAttachButtonImage(\'previewedit\',\'PE\');\nnuAttachButtonImage(\'bb_event\',\'BB\');\nnuAttachButtonImage(\'be_event\',\'BE\');\nnuAttachButtonImage(\'bs_event\',\'BS\');\nnuAttachButtonImage(\'as_event\',\'AS\');\nnuAttachButtonImage(\'bd_event\',\'BD\');\nnuAttachButtonImage(\'ad_event\',\'AD\');\nnuAttachButtonImage(\'icon\',\'JS\');\nnuAttachButtonImage(\'br_sql\',\'SQL\');\n\n$(\'#sfo_javascript\')\n.css(\'padding\', \'3px 3px 3px 3px\')\n\n\n$(\'#user_home\')\n.css({\n \'color\' : \'white\',\n \'font-size\' : 13,\n \'display\' : \'inline\',\n \'border-style\' : \'solid\',\n \'height\' : 30,\n \'font-size\' : 16,\n \'text-shadow\' : \'0 1px 2px #9AB973\',\n \'border-color\' : \'#9AB973\',\n \'border-width\' : \'0px 0px 1px 0px\',\n \'background-color\' : \'#88cb51\'\n});\n\n\n$(\'#sfo_javascript\').addClass(\'js\');\n$(\'#sfo_browse_sql\').addClass(\'sql\')\n.css(\'font-size\', 10)\n\nnuSetTitle($(\'#sfo_table\').val());\n\n$(\'.js\')\n.dblclick(function() {\n nuOpenAce(\'Javascript\', this.id);\n});\n\n$(\'.sql\').dblclick(function() {\n nuOpenAce(\'SQL\', this.id);\n});\n\n$(\'.html\')\n.dblclick(function() {\n nuOpenAce(\'HTML\', this.id);\n});\n\n\nif(window.filter == \'justjs\'){\n \n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#nuTab0\').remove();\n $(\'#nuTab1\').remove();\n $(\'#nuTab2\').click();\n $(\'#nuTab2\').remove();\n \n nuSetTitle($(\'#sfo_description\').val());\n \n}\n\n\nfunction nuFormColor(){\n\n var t = String($(\'#sfo_type\').val());\n\n var pb = \'previewbrowse\';\n var pe = \'previewedit\';\n\n var bb = \'bb_event\';\n var be = \'be_event\';\n var bs = \'bs_event\';\n var as = \'as_event\';\n var bd = \'bd_event\';\n var ad = \'ad_event\';\n \n if(t == \'browse\'){\n \n nuDisable(pe);\n\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'edit\'){\n \n nuDisable(pb);\n nuDisable(bb);\n \n }\n\n if(t == \'launch\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'subform\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n nuDisable(\'sfo_javascript\');\n \n }\n\n if(nuFORM.getCurrent().record_id == \'nuuserhome\'){\n // nuDisable(\'sfo_javascript\');\n }\n \n var h = $(\'#sfo_type\').addClass(\'nuEdited\');\n var o = [];\n o[\'browse\'] = [0,1,2];\n o[\'edit\'] = [0,2];\n o[\'browseedit\'] = [0,1,2];\n o[\'launch\'] = [0,2];\n o[\'subform\'] = [0,1];\n \n $(\'#sfo_type\').removeClass();\n $(\'#sfo_type\').addClass(\'nu_\'+$(\'#sfo_type\').val());\n \n if(h){\n $(\'#sfo_type\').addClass(\'nuEdited\');\n }\n \n $(\"#sfo_type > option\").each(function() {\n $(this).addClass(\'nu_\'+this.value);\n });\n\n for(var i = 0 ; i < 7 ; i++){\n $(\'#nuTab\' + i).removeClass(\'nuRelatedTab\');\n }\n var t = o[$(\'#sfo_type\').val()];\n\n if(t !== undefined){\n \n for(var i = 0 ; i < t.length ; i++){\n $(\'#nuTab\' + t[i]).addClass(\'nuRelatedTab\'); \n }\n \n }\n \n}\n\nnuFormColor();\n\n$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\ndefault_description();\n\nfunction nuEventList(){\n \n if($(\'sob_all_type\').val() == \'subform\'){\n return [\'onchange\',\'onadd\'];\n }else{\n return [\'onblur\',\'onchange\',\'onfocus\',\'onkeydown\'];\n }\n \n}\n\nfunction default_description(){\n \n var s = \'zzzzsys_browse_sf\';\n var r = nuSubformObject(s).rows.length - 1;\n var o = \'#\' + s + nuPad3(r) + \'sbr_title\';\n var d = \'Something\';\n\n $(o).val(d);\n\n}\n\n\n'),('nufile','browseedit','nufile','Stored Files','zzzzsys_file','zzzzsys_file_id','',150,3,'SELECT * FROM zzzzsys_file\nORDER BY sfi_code','\nnuSetNoSearchColumns([2,3]);\n\n$(\'[data-nu-column=\"0\"]\').each(function( index ) {\n\n var code = \'#nucell_\' + index + \'_\';\n window.nuImages[$(code + \'0\').text()] = $(code + \'2\').text();\n \n});\n\n\n\nif(nuFormType() == \'browse\'){\n nuShowBrowseImages()\n}else{\n nuShowFile();\n}\n\n\n\n\nfunction nuBeforeSave(){\n\n var f = $(\'#sfi_json_file\').val();\n \n if(f != \'\'){\n \n $(\'#sfi_json\')\n .val(f)\n .change();\n \n }\n \n return true;\n\n}\n\n\nfunction nuShowFile(){\n \n var j = $(\'#sfi_json\').val();\n \n nuEmbedObject(j, \'view_image\');\n \n}\n\n\nfunction nuShowBrowseImages(){\n\n $(\'[data-nu-column=\"0\"]\').each(function( index ) {\n \n var p = $(this).attr(\'id\');\n var r = String(p).split(\'_\')[1];\n var i = \"nucell_\" + r + \"_2\";\n var e = \"nucell_\" + r + \"_3\";\n var h = $(\'#\' + i).html();\n\n if(h != \'\' && h !== undefined){\n \n nuEmbedObject(h, e, 140, 140);\n\n }\n \n });\n\n}\n\n'),('nuselect','browseedit','nuselect','SQL Builder','zzzzsys_select','zzzzsys_select_id','',0,0,'SELECT * FROM zzzzsys_select \nWHERE (sse_system != 1 || sse_system IS NULL)\nORDER BY sse_description ASC\n\n','\nif(nuIsNewRecord()){\n $(\'#sse_edit\').val(0);\n}\n\n$(\"#sse_edit option[value=\'\']\").remove();\n\n$(\'#sse_sql\')\n.css(\'font-size\', 10)\n.addClass(\'sql\')\n.dblclick(function() {\n nuOpenAce(\'SQL\', this.id);\n});\n\n$(\'#label_sse_sql\').remove();\n\nnuSetSFCB();\n\nif(window.filter == \'justsql\'){\n\n var sid = String(nuFORM.getCurrent().record_id);\n var from = sid.substring(sid.length-2);\n var targ = \'#sfo_browse_sql\';\n\n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#sse_description\').val(sid);\n \n nuHide(\'sse_description\');\n \n if(nuFORM.getCurrent().record_id != -1){\n \n $(\'#nuSaveButton\').hide();\n \n if(from == \'BR\'){\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Form Browse SQL\', \'nuCopySQL(\"sfo_browse_sql\")\');\n }\n \n if(from == \'SE\'){\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Select Object SQL\', \'nuCopySQL(\"sob_select_sql\")\');\n }\n \n\n if(from == \'DI\'){\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Display Object SQL\', \'nuCopySQL(\"sob_display_sql\")\');\n }\n \n }\n\n}\n\n\n\nnuSetTitle($(\'#sal_code\').val());\n\n$(\'#sse_sql\')\n.css({\n \'white-space\' : \'nowrap\',\n \'overflow-x\' : \'scroll\',\n})\n\nnuWhereClauses();\n\n\nfunction nuCopySQL(targ){\n \n var s = $(\'#sse_sql\').val();\n \n parent.$(\'#\' + targ).val(s).change();\n \n parent.$(\'#dialogClose\').click();\n\n}\n\n\nfunction nuTempPHP(){\n \n var p = [];\n \n p.push(\'\');\n p.push(\'$sql = \"\');\n p.push(\'\');\n p.push(\'CREATE TABLE #TABLE_ID#\');\n p.push($(\'#sse_sql\').val());\n p.push(\'\');\n p.push(\'\";\');\n p.push(\'\');\n p.push(\"nuRunQuery($sql);\");\n p.push(\'\');\n nuMessage(p);\n// $(\"#nuAlertDiv\").css(\'text-align\', \'left\')\n $(\"#nuMessageDiv\").css(\'text-align\', \'left\')\n\n}\n\nfunction nuBeforeSave(){\n \n $(\'#sqlframe\')[0].contentWindow.nuSQL.buildSQL();\n return true;\n \n}\n\n\n\n\nfunction nuWhereClauses(){\n\n $(\"[id$=\'ssc_type\']select\").each(function(index){\n \n var p = $(this).attr(\'data-nu-prefix\');\n var t = $(this).val();\n \n if(t == 2 || t == 3){\n \n if($(\'#\' + p + \'ssc_sort\').val() == \'\'){\n $(\'#\' + p + \'ssc_sort\').val(\'ASC\');\n }\n \n $(\'#\' + p + \'ssc_clause\').hide();\n $(\'#\' + p + \'ssc_sort\').show();\n \n }else{\n \n $(\'#\' + p + \'ssc_clause\').show();\n $(\'#\' + p + \'ssc_sort\').hide();\n \n }\n\n });\n\n}\n\n\nfunction nuWhereClausesold(){\n\n $(\"[id$=\'ssc_type\']select\").each(function(index){\n \n var p = $(this).attr(\'data-nu-prefix\');\n var t = $(this).val();\n \n if(t == 2 || t == 3){\n \n if($(\'#\' + p + \'ssc_sort\').val() == \'\'){\n $(\'#\' + p + \'ssc_sort\').val(\'ASC\');\n }\n \n $(\'#\' + p + \'ssc_clause\').hide();\n $(\'#\' + p + \'ssc_sort\').show();\n \n }else{\n \n $(\'#\' + p + \'ssc_clause\').show();\n $(\'#\' + p + \'ssc_sort\').hide();\n \n }\n\n });\n\n}\n\n\nfunction nuAddSQLTable(e){\n \n var s = $(\'#sqlframe\')[0].contentWindow.nuSQL;\n \n s.addBox(e.target.value);\n e.target.value = \'\';\n s.buildSQL();\n\n}\n\n\nfunction nuSFCB(){\n \n nuWhereClauses();\n $(\'#sqlframe\')[0].contentWindow.nuSQL.buildSQL();\n\n}\n\n\nfunction nuSetSFCB(){\n \n $(\'.nuSubformCheckbox.zzzzsys_select_clause\')\n .click(function(){\n nuSFCB();\n });\n \n}\n\n\n\nfunction nuResizeSQL(){\n\n if($(\'#sqlframe\').css(\'height\') == \'470px\'){\n $(\'#sqlframe\').css(\'height\', 180);\n }else{\n $(\'#sqlframe\').css(\'height\', 470);\n }\n \n}\n\n\n'),('nulaunchable','browse','nulaunchable','Launchable Forms','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nWHERE sfo_type IN (\'edit\', \'browseedit\', \'launch\')\nAND (\n SUBSTRING(zzzzsys_form_id, 1, 2) != \'nu\'\n OR zzzzsys_form_id = \'nublank\'\n OR zzzzsys_form_id = \'nuuserhome\'\n )\nORDER BY sfo_code\n','$(\'#sfo_breadcrumb_title\').addClass(\'sql\');\n$(\'#sfo_browse_sql\').addClass(\'sql\');\n$(\'#sfo_javascript\').addClass(\'js\');\n\nnuSetTitle($(\'#sfo_table\').val());\n\n$(\'.js\').dblclick(function() {\n nuOpenAce(\'Javascript\', this.id);\n});\n\n$(\'.sql\').dblclick(function() {\n nuOpenAce(\'SQL\', this.id);\n});\n\n$(\'.html\').dblclick(function() {\n nuOpenAce(\'HTML\', this.id);\n});\n\n$(\'.php\').dblclick(function() {\n nuOpenAce(\'PHP\', this.id);\n});\n\nif(window.filter == \'justjs\'){\n \n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#nuTab0\').remove();\n $(\'#nuTab1\').remove();\n $(\'#nuTab2\').click();\n $(\'#nuTab2\').remove();\n \n nuSetTitle($(\'#sfo_description\').val());\n \n}\n\n\n\nfunction nuFormColor(){\n\n var t = String($(\'#sfo_type\').val());\n\n var pb = \'previewbrowse\';\n var pe = \'previewedit\';\n\n var bb = \'bb_event\';\n var be = \'be_event\';\n var bs = \'bs_event\';\n var as = \'as_event\';\n var bd = \'bd_event\';\n var ad = \'ad_event\';\n \n if(t == \'browse\'){\n \n nuDisable(pe);\n\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'edit\'){\n \n nuDisable(pb);\n nuDisable(bb);\n \n }\n\n if(t == \'launch\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'subform\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n nuDisable(\'sfo_javascript\');\n \n }\n\n var h = $(\'#sfo_type\').addClass(\'nuEdited\');\n var o = [];\n o[\'browse\'] = [0,1,2];\n o[\'edit\'] = [0,2];\n o[\'browseedit\'] = [0,1,2];\n o[\'launch\'] = [0,2];\n o[\'subform\'] = [0,1];\n \n $(\'#sfo_type\').removeClass();\n $(\'#sfo_type\').addClass(\'nu_\'+$(\'#sfo_type\').val());\n \n if(h){\n $(\'#sfo_type\').addClass(\'nuEdited\');\n }\n \n $(\"#sfo_type > option\").each(function() {\n $(this).addClass(\'nu_\'+this.value);\n });\n\n for(var i = 0 ; i < 7 ; i++){\n $(\'#nuTab\' + i).removeClass(\'nuRelatedTab\');\n }\n var t = o[$(\'#sfo_type\').val()];\n\n if(t !== undefined){\n \n for(var i = 0 ; i < t.length ; i++){\n $(\'#nuTab\' + t[i]).addClass(\'nuRelatedTab\'); \n }\n \n }\n \n}\n\nnuFormColor();\n\n//nuBuildSubformArray(\'zzzzsys_tab_sf\');\n//nuBuildSubformArray(\'zzzzsys_browse_sf\');\n\n$(\"[data-nu-column=\'nucolumn000\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n\n\nfunction nuEventList(){\n \n if($(\'sob_all_type\').val() == \'subform\'){\n return [\'onchange\',\'onadd\'];\n }else{\n return [\'onblur\',\'onchange\',\'onfocus\',\'onkeydown\'];\n }\n \n}\n\n\n'),('nuclause','subform','nuclause','Select Clauses','zzzzsys_select_clause','zzzzsys_select_clause_id','',0,0,'SELECT * FROM zzzzsys_select_clause\nORDER BY ssc_type, ssc_order',''),('nubuildtable','browse','nubuildtable','PHP or SELECT or TABLE','zzzzsys_report_data','id','nuselect',0,0,'SELECT * FROM zzzzsys_report_data',''),('nuuserhome','launch','nuuserhome','Home','','','',0,0,'',''),('nufrlaunch','launch','nufrlaunch','Fast Report','','','',0,0,'SELECT * FROM Launch Form 0','\n$(\'#wrdaddable\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'#frwrd\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'#nufr\').css(\'text-align\', \'left\').css(\'padding\', \'3px\');\n$(\'#list\').addClass(\'nuScroll\').removeClass(\'nuReadonly\');\n\n$(\'.nuActionButton\').hide();\nnuAddActionButton(\'nuRunPHPHidden\', \'Build Fast Report\', \'nuRunPHPHidden(\"RUNFR\")\');\n\n\nfunction nuAddReportField(t){\n\n var f = nuPad3($(\"[data-nu-label=\'Field Name\']\").length - 1);\n\n $(\'#fast_report_sf\' + f + \'field\').val($(t).html()).change();\n $(\'#fast_report_sf\' + f + \'width\').val(100).change();\n $(\'#fast_report_sf\' + f + \'sum\').val(\'no\').change();\n $(\'#fast_report_sf\' + f + \'title\').val($(t).html()).change().select();\n \n}\n\n\nfunction nuBeforeSave(){\n \n if($(\'#table\').val() == \'\'){\n \n nuMessage([\'<b>Table Data</b>\', \'Cannot be left blank...\'])\n return false;\n \n }\n \n \n if($(\'#orderby\').val() == \'\'){\n \n nuMessage([\'<b>Order By</b>\', \'Cannot be left blank...\'])\n return false;\n \n }\n \n nuBuildFastReport();\n \n return true;\n \n}\n\n'),('nufastreportobjects','subform','nufastreportobjects','Fast Report Objects','zzzzsys_debug','zzzzsys_debug_id','',0,0,'SELECT count(*) FROM zzzzsys_debug',''),('nusamplesubformform','launch','nusamplesubformform','Sample Subform Form','','','',0,0,'SELECT * FROM Launch Form 0',''),('nulaunchform','edit','nulaunchform','nuBuilder non-System Form','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nWHERE sfo_type = \'launch\' AND zzzzsys_form_id != \'nuhome\'\nORDER BY sfo_code\n','$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\n'),('nutablookup','browse','nutablookup','Form Tab Lookup','zzzzsys_tab','zzzzsys_tab_id','',0,0,'SELECT * FROM zzzzsys_tab\nJOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id\nJOIN #TABLE_ID# ON zzzzsys_form_id = theid\nORDER BY syt_order','\n$(\"[data-nu-column=\'3\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\n');269 INSERT INTO `zzzzsys_form` VALUES ('nuhome','launch','nuhome','Home','','','',0,0,'','\n\nnuAttachButtonImage(\'run_php\',\'RP\');\nnuAttachButtonImage(\'run_setup\',\'SET\');\nnuAttachButtonImage(\'form_button\',\'F\');\nnuAttachButtonImage(\'run_lang\',\'TR\');\nnuAttachButtonImage(\'run_report\',\'RR\');\nnuAttachButtonImage(\'user_home\',\'UH\');\nnuAttachButtonImage(\'run_user\',\'U\');\nnuAttachButtonImage(\'run_file\',\'FILE\');\nnuAttachButtonImage(\'edit_php\',\'P\');\nnuAttachButtonImage(\'edit_report\',\'R\');\nnuAttachButtonImage(\'run_access\',\'KEY\');\nnuAttachButtonImage(\'run_fast_form\',\'FF\');\nnuAttachButtonImage(\'run_format\',\'FMT\');\nnuAttachButtonImage(\'run_fast_report\',\'FR\');\nnuAttachButtonImage(\'object_button\',\'OB\');\nnuAttachButtonImage(\'run_sql\',\'SQL\');\nnuAttachButtonImage(\'run_chart\',\'CH\');\nnuAttachButtonImage(\'open_database\',\'DB\');\nnuAttachButtonImage(\'system_update\',\'SU\');\n\n\n$(\'.nuActionButton\').hide();\n\n$(\'#user_home\').addClass(\'nuUserHomeButton\');\n\n$(\'#open_database\')\n.attr(\'title\', \'PHPMyAdmin\')\n//.click(function(){\n// window.open(\'nupmalogin.php\');\n//});\n\n\n$(\'#run_php\')\n.css(\'text-align\', \'left\')\n.css(\'padding\', \'0px 0px 0px 35px\')\n.css(\'background-size\', \'30px\')\n.css(\'background-repeat\', \'no-repeat\');\n\nnuGetStartingTab();\n'),('nubrowse','subform','nubrowse','Browse Columns','zzzzsys_browse','zzzzsys_browse_id','',0,5,'SELECT * FROM zzzzsys_browse\nORDER BY sbr_order\n','$(\'#nuSearchButton\').remove();\n$(\'#nuSearchField\').remove();\n$(\'#nuPrintButton\').remove();\n\nnuSetTitle($(\'#sbr_title\').val());\n\nvar pid = parent.nuFORM.getCurrent().record_id;\n\nif(nuFORM.getCurrent().record_id == -1){\n $(\'#sbr_zzzzsys_form_id\').val(pid).change();\n}\n'),('nutab','browse','nutab','Form Tab','zzzzsys_tab','zzzzsys_tab_id','',0,0,'SELECT * FROM zzzzsys_tab\nJOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id\nORDER BY syt_order','\n$(\"[data-nu-column=\'3\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n'),('nuobject','browseedit','nuobject','Object','zzzzsys_object','zzzzsys_object_id','',0,0,'SELECT * FROM zzzzsys_object\nJOIN #TABLE_ID# ON zzzzsys_object_id = theid\nJOIN zzzzsys_tab ON zzzzsys_tab_id = sob_all_zzzzsys_tab_id\nJOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id \n','\n$(\'#add_total\').css(\'overflow-y\',\'scroll\').css(\'background-color\',\'#ebebeb\');\n\n$(\'#zzzzsys_event_sfsev_javascript\').attr(\'id\',\'jsfuntitle\');\n$(\'#sob_calc_formula\').addClass(\'nuCalculatorCurrency\').css(\'font-size\', 12);\n$(\'#sob_all_display_condition\').addClass(\'sql\');\n$(\'#sob_all_default_value_sql\').addClass(\'sql\');\n$(\'#sob_display_sql\').addClass(\'sql\');\n$(\'#sob_select_sql\').addClass(\'sql\');\n$(\'#sob_lookup_php\').addClass(\'php\');\n$(\'#sob_lookup_javascript\').addClass(\'js\');\n$(\'#sob_input_javascript\').addClass(\'js\');\n$(\'#sob_html_javascript\').addClass(\'js\');\n$(\'#sob_html_code\').addClass(\'html\');\n$(\"[id$=\'sev_javascript\']\").addClass(\'js\');\n$(\"#title_zzzzsys_event_sfsev_javascript\").removeClass(\'js\');\n\n$(\'#nuTab8\').click(function(){nuTestChart();});\n\nnuAttachButtonImage(\'icon\', \'LUJS\');\nnuAttachButtonImage(\'ab_event\',\'AB\');\nnuAttachButtonImage(\'di_sql\',\'SQL\');\nnuAttachButtonImage(\'se_sql\',\'SQL\');\n\n$(\'#sob_lookup_javascript\')\n.css(\'padding\', \'3px 3px 3px 3px\')\n\n$(\'#viewflowchart\')\n.css(\'padding\', \'46px 0px 0px 3px\')\n.css(\'text-align\', \'left\')\n.css(\'background-size\', \'75px\')\n\n\nif($(\'#zzzzsys_event_sf000sev_event\').val() != \'\'){\n $(\'#nuTab10\').css(\'font-weight\', \'bold\');\n}\n\n\nif(nuFORM.getCurrent().record_id == -1){\n \n $(\'#sob_all_top\').val(0).change();\n $(\'#sob_all_left\').val(0).change();\n $(\'#sob_all_height\').val(0).change();\n $(\'#sob_all_width\').val(0).change();\n $(\'#sob_all_validate\').val(0).change();\n $(\'#sob_all_access\').val(0).change();\n $(\'#sob_all_align\').val(\'left\').change();\n $(\'#sob_all_cloneable\').val(1).change();\n \n nuHasNotBeenEdited();\n}\n\nvar v = $(\'#sob_input_type\').val();\n\nif(nuFormType() == \'edit\'){\n \n nuShowInputJS(v);\n nuHideCalcObjects();\n nuSetTitle($(\'#sob_all_id\').val());\n nuPopulateHTML();\n \n}\n\nvar filter = String(window.filter).split(\'|\');\n\nif(filter[0] == \'fromfastform\'){\n \n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#nuSaveButton\').remove();\n $(\'#sob_all_id\').val(filter[1]).addClass(\'nuHighlight\');\n $(\'#sob_all_label\').val(filter[2]).addClass(\'nuHighlight\');\n \n}\n\n\n\n$(\'.js\').dblclick(function() {nuOpenAce(\'Javascript\', this.id);});\n$(\'.sql\').dblclick(function() {nuOpenAce(\'SQL\', this.id);});\n$(\'.html\').dblclick(function() {nuOpenAce(\'HTML\', this.id);});\n$(\'.php\').dblclick(function() {nuOpenAce(\'PHP\', this.id);});\n\nnuObjectColor();\n\n$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\nnuHide(\'sob_input_format\');\n\nvar sit = $(\'#sob_input_type\').val();\n\nif(sit == \'nuDate\' || sit == \'nuNumber\'){\n nuShow(\'sob_input_format\');\n}\n\nif(sit == \'nuScroll\'){\n nuShow(\'sob_input_javascript\');\n}else{\n nuHide(\'sob_input_javascript\');\n}\n\nnuGetStartingTab();\n\nfunction nuTestChart(){\n \n var g = $(\'#sob_html_chart_type\').val();\n var t = $(\'#sob_all_type\').val();\n \n if(g == \'\' || t != \'html\'){$(\'#google_chart\').html(\'\');return;}\n \n var c = \'ComboChart\';\n var t = $(\'#sob_html_title\').val();\n var x = $(\'#sob_html_vertical_label\').val();\n var y = $(\'#sob_html_horizontal_label\').val();\n var l = \'bars\';\n var s = false;\n var a = [\n [\'Month\', \'Shane\', \'Dave\', \'Adam\', \'Paul\', \'Chris\'],\n [\'2004\', 100, 200, 300, 400, 500],\n [\'2005\', 165, 238, 322, 498, 550],\n [\'2006\', 165, 938, 522, 998, 450],\n [\'2007\', 135, 1120, 599, 1268, 288]\n ];\n \n if(g == \'p\') {c = \'PieChart\';}\n if(g == \'l\') {l = \'lines\';}\n if(g == \'bh\') {c = \'BarChart\';}\n if(g == \'bhs\') {c = \'BarChart\';}\n if(g == \'bs\') {s = true;}\n if(g == \'bhs\') {s = true;}\n\n nuChart(\'google_chart\', c, a, t, x, y, l, s);\n\n}\n\n\n\n\n\nfunction nuObjectColor(){\n \n $(\'.nuValidate\').removeClass(\'nuValidate\');\n\n var e = $(\'#sob_all_type\').hasClass(\'nuEdited\');\n var o = [];\n\n o[\'run\'] = 1;\n o[\'display\'] = 2;\n o[\'select\'] = 3;\n o[\'lookup\'] = 4;\n o[\'subform\'] = 5;\n o[\'image\'] = 6;\n o[\'input\'] = 7;\n o[\'html\'] = 8;\n o[\'calc\'] = 9;\n \n\n $(\'#sob_all_type\').removeClass();\n \n if(e){ //-- keep class if edited\n $(\'#sob_all_type\').addClass(\'nuEdited\');\n }\n \n $(\'#sob_all_type\').addClass(\'nu_\'+$(\'#sob_all_type\').val());\n \n $(\"#sob_all_type > option\").each(function() {\n $(this).addClass(\'nu_\'+this.value);\n });\n \n $(\"#sob_input_type > option\").each(function() {\n $(this).addClass(\'input_\'+this.value);\n });\n \n var t = o[$(\'#sob_all_type\').val()];\n \n $(\"[id^=\'nuTab\']\").removeClass(\'nuRelatedTab\');\n \n for(var i = 1 ; i < o.length ; i++){\n $(\'#nuTab\' + i).removeClass(\'nuRelatedTab\');\n }\n \n $(\'#nuTab0\').addClass(\'nuRelatedTab\');\n $(\'#nuTab\' + t).addClass(\'nuRelatedTab\');\n \n} \n\n\nfunction nuAddToFormula(e){\n \n var fld = e.target.innerHTML;\n var frm = $(\'#sob_calc_formula\').val();\n \n if(fld == \'Clear\'){\n \n $(\'#sob_calc_formula\')\n .val(\'\')\n .addClass(\'nuEdited\');\n return;\n \n }\n\n $(\'#sob_calc_formula\')\n .addClass(\'nuEdited\')\n .val(frm + fld);\n \n nuHasBeenEdited();\n \n}\n\nfunction nuShowInputJS(t){\n\n nuHide(\'sob_input_format\');\n nuHide(\'sob_input_count\');\n nuHide(\'sob_input_javascript\');\n \n if(t == \'nuScroll\'){\n nuShow(\'sob_input_javascript\');\n }\n\n if(t == \'nuAutoNumber\'){\n \n nuShow(\'sob_input_count\');\n $(\'#sob_input_javascript\').val(\'\').change();\n \n }\n\n if(t == \'nuDate\' || t == \'nuNumber\'){\n \n nuShow(\'sob_input_format\');\n\n $(\'#sob_input_format\').children().each(function(index) {\n \n $(this).show();\n \n if($(this).val()[0] == \'D\' && t != \'nuDate\') {$(this).hide();}\n if($(this).val()[0] == \'N\' && t != \'nuNumber\') {$(this).hide();}\n \n });\n \n }\n \n}\n\n\nfunction nuHideCalcObjects(){\n\n var f = $(\'#sob_all_zzzzsys_form_id\').val();\n\n $(\'#add_total\').children().each(function(index) {\n\n\n if($(this).val() != f){\n $(this).hide();\n }\n if($(this).text() == $(\'#sob_all_id\').val()){\n $(this).hide();\n }\n\n });\n \n}\n\n\nfunction nuAddCalcObject(t){\n \n var f = $(\'#sob_calc_formula\').val();\n var i = $(t).attr(\'data-nu-ids\');\n var s = f + \"nuTotal(\'\" + i + \"\')\";\n \n if(i == \'\'){return;}\n\n $(\'#sob_calc_formula\')\n .addClass(\'nuEdited\')\n .val(s);\n\n $(\'#add_total\').val(\'\');\n \n nuHasBeenEdited();\n \n}\n\n\nfunction nuPopulateHTML(){\n\n var o = nuCalcObjects();\n var a = [];\n\n for(var i = 0 ; i < o.length ; i++){\n \n var ids = String(o[i].ids);\n var ty = o[i].type;\n var id = String(o[i].ids).split(\'.\');\n var sp = \' \';\n\n if(id.length == 1){\n a.push(\'<tr><td><div title=\"\'+ty+\'\" style=\"overflow:hidden;width:314px;text-align:left;padding:2px\" onclick=\"nuAddCalcObject(this);\" class=\"nuCalculatorButton nu_\' + o[i].type + \'\" data-nu-ids=\"\' + ids + \'\">\' + ids + \'</div></td></tr>\');\n }else{\n \n var h = \'<span title=\"subform\" class=\"nu_subform\">\' + id[0] + \'</span>.<span title=\"\'+ty+\'\" class=\"nu_input\" style=\"padding:7px 5px 7px 5px\">\' + id[1] + sp.repeat(200) + \'</span>\';\n a.push(\'<tr><td><div style=\"overflow:hidden;width:314px;text-align:left;padding:2px\" onclick=\"nuAddCalcObject(this);\" class=\"nuCalculatorButton nu_subform\" data-nu-ids=\"\' + ids + \'\">\' + h + \'</div></td></tr>\');\n \n }\n \n }\n\n $(\'#add_total\').html(\'<table>\' + a.join(\'\') + \'</table>\');\n\n}\n\n\n'),('nufflaunch','launch','nufflaunch','Form Builder','','','',0,0,'SELECT * FROM zzzzsys_form','\n$(\"[id$=\'ff_browse\']\").hide();\n$(\'#title_obj_sfff_browse\').show();\n$(\'#ffwrd\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'#wrdaddable\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'.nuActionButton\').hide();\n$(\'#nuTab0\').remove();\n$(\'#fastform_type\').focus();\n\nnuSetFK();\n\nnuAddActionButton(\'nuRunPHPHidden\', \'Build Fast Form\', \'nuRunPHPHidden(\"RUNFF\")\');\n\n$(\"#fastform_type > option\").each(function() {\n $(this).addClass(\'nu_\' + this.value);\n});\n\nfunction nuFormColor(){\n\n var t = String($(\'#fastform_type\').val());\n \n $(\'#fastform_type\').removeClass();\n $(\'#fastform_type\').addClass(\'nu_\'+$(\'#fastform_type\').val());\n \n if(t == \'launch\'){\n \n $(\'#fastform_table\').hide();\n $(\'#label_fastform_table\').hide();\n\n }else{\n $(\'#fastform_table\').show();\n $(\'#label_fastform_table\').show();\n }\n \n \n if(t == \'browse\' || t == \'browseedit\'){\n \n $(\"[id$=\'ff_browse\']:checkbox\").each(function(index){\n \n var fld = \'#\' + this.id.substr(0, 6) + nuPad3(index + 1) + \'ff_field\';\n\n if($(fld).length == 1){\n $(this).show();\n }\n \n });\n \n }else{\n $(\"[id$=\'ff_browse\']:checkbox\").hide();\n }\n\n nuSetFK();\n\n}\n\n\nfunction nuSetFFTable(){\n \n var v = $(\'#fastform_table\').val();\n\n if(nuFORM.getTables().indexOf(v) == -1){\n \n $(\"[data-nu-field=\'ff_field\']\")\n .removeClass(\'input_nuScroll\')\n .removeClass(\'nuScroll\');\n\n }else{\n \n $(\"[data-nu-field=\'ff_field\']\")\n .addClass(\'input_nuScroll\')\n .addClass(\'nuScroll\');\n\n }\n\n $(\"#title_obj_sfff_field\")\n .removeClass(\'input_nuScroll\')\n .removeClass(\'nuScroll\');\n \n var l = $(\"[id$=\'ff_browse\']\").length-2;\n \n $(\'#obj_sf\' + nuPad3(l) + \'ff_browse\').hide();\n\n nuSetFK();\n \n}\n\n\nfunction nuSetFK(){\n \n $(\'#fastform_fk\').hide();\n $(\'#label_fastform_fk\').hide();\n\n var v = $(\'#fastform_table\').val();\n\n if(v != \'\' && nuFORM.getTables().indexOf(v) == -1 && $(\'#fastform_type\').val() == \'subform\'){\n \n $(\'#fastform_fk\').show().focus();\n $(\'#label_fastform_fk\').show();\n\n }\n \n}\n\n\nfunction nuShowFFO(e){\n \n var t = $(\'#\' + e.target.id).attr(\'data-nu-prefix\');\n var i = $(\'#\' + t + \'ff_id\').val();\n var l = $(\'#\' + t + \'ff_label\').val();\n var f = $(\'#\' + t + \'ff_field\').val();\n var fff = \'fromfastform|\' + f + \'|\' + l;\n\n nuPopup(\'nuobject\', i, fff);\n\n}\n\nfunction nuFocusFFObject(e){\n\n var p = $(e.target).attr(\'data-nu-prefix\');\n \n if($(\'#\' + p + \'ff_id\').val() == \'\'){\n $(\'#fastform_table\').focus();\n }\n \n}\n\n\n\n\nfunction nuMoveFF(){\n \n var i = $(\'#new_id\').val();\n\n nuPopup(i, -2);\n\n}\n\nfunction nuCreateSQLPrefix(){\n \n var p = $(\'#fastform_prefix\');\n var t = $(\'#fastform_table\');\n \n p.val(String(t.val()).substr(0, 3));\n \n}\n\n\nfunction nuBeforeSave(){\n \n var table = $(\'#fastform_table\').val();\n var type = String($(\'#fastform_type\').val());\n var browse = type.substr(0, 6) == \'browse\';\n\n if(table == \'\' && type != \'launch\'){\n \n nuMessage([\'Table Name cannot be left blank..\']);\n \n return false;\n\n }\n \n if(type == \'\'){\n \n nuMessage([\'Must select <b>Form Type</b>...\']);\n \n return false;\n\n }\n \n if(browse){\n \n if($(\"[data-nu-field=\'ff_browse\']:checked\").length == 0){\n \n nuMessage([\'At least 1 Browse needs to be checked..\']);\n \n return false;\n \n }\n \n }\n\n var v = $(\'#fastform_table\').val();\n var t = $(\'#fastform_type\').val();\n var f = $(\'#fastform_fk\').val();\n\n if(v != \'\' && nuFORM.getTables().indexOf(v) == -1 && t == \'subform\' && f == \'\'){\n \n nuMessage([\'<b>Foreign Key Field Name</b> cannot be left blank...\']);\n \n return false;\n\n }\n \n var a = [];\n \n for(var i = 0 ; i < nuSubformObject(\'obj_sf\').rows.length ; i++){\n a.push(nuSubformObject(\'obj_sf\').rows[i][2]);\n }\n\n\n if(f != \'\' && a.indexOf(f) > -1 && t == \'subform\'){\n \n nuMessage([\'<b>Foreign Key Field Name</b> is already used...\']);\n \n return false;\n\n }\n \n\n\n\n\n \n \n if(!nuValidColumn()){\n return false;\n }\n\n return true;\n \n}\n\n\nfunction nuValidColumn(){\n \n var tn = $(\'#fastform_table\').val();\n \n if(nuFORM.getTables().indexOf(tn) == -1){return true;}\n \n var sf = nuSubformObject(\'obj_sf\');\n \n for(var i = 0 ; i < sf.rows.length ; i++){\n \n if(sf.rows[i][4] == 1 && sf.deleted[i] != 1){ //-- ticked column checkbox\n \n var valid = nuFORM.tableSchema[tn].names.indexOf(sf.rows[i][2]) //-- fieldname\n \n if(valid == -1){\n \n nuMessage([\'Invalid column name <b>\' + sf.rows[i][2] + \'</b>\']);\n \n return false;\n \n }\n }\n \n }\n \n return true;\n\n}\n\n\nfunction nuSelectFFObjects(e){\n \n var classes = e.target.className.split(\' \');\n var id = e.target.id;\n var rowno = nuPad3($(\"[id^=\'obj_sf\'][id$=\'ff_label\']\", document).length-1);\n var rowsuf = nuPad2(rowno);\n var sfrow = \'#obj_sf\' + rowno;\n var h = String(e.target.innerHTML).split(\':\');\n \n $(sfrow + \'ff_label\')\n .val(h[h.length-1] + rowsuf)\n .addClass(classes[1])\n .change();\n\n $(sfrow + \'ff_field\')\n .val(\'field\' + rowsuf)\n .change();\n\n $(sfrow + \'ff_id\')\n .val(id)\n .change();\n \n var nb = [\'Word\', \'Subform\', \'Image\', \'HTML\', \'Display\', \'Input:file\', \'Input:button\', \'Select:multiselect\'].indexOf(e.target.innerHTML); \n\n if(nb == -1){\n $(sfrow + \'ff_browse\').show();\n }else{\n $(sfrow + \'ff_browse\').remove();\n }\n \n $(\'#fastform_type\').change();\n\n}\n\n\n\n'),('nuevent','edit','nuevent','Object Events','zzzzsys_event','zzzzsys_event_id','',0,0,'SELECT * FROM zzzzsys_event',''),('nuaccess','browseedit','nuaccess','Access Levels','zzzzsys_access','zzzzsys_access_id','',0,0,'SELECT * FROM zzzzsys_access\nORDER BY sal_code\n','nuSetTitle($(\'#sal_code\').val());'),('nunonsystemform','edit','nunonsystemform','nuBuilder non-System Form','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nWHERE ((zzzzsys_form_id NOT LIKE \'nu%\' AND sfo_type != \'subform\')\nOR zzzzsys_form_id IN (\'nuaccess\', \'nuuser\', \'nulaunchdates\', \'nutranslate\', \'nupassword\', \'nufile\', \'nuuserhome\', \'nublank\', \'nurunreport\'))\nORDER BY sfo_code','$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\n'),('nuaccessforms','edit','nuaccessforms','Accessible Forms','zzzzsys_access_form','zzzzsys_access_form_id','',0,0,'SELECT * FROM zzzzsys_access_form\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = slf_zzzzsys_form_id\nORDER BY sfo_code\n',''),('nuuser','browseedit','nuuser','User','zzzzsys_user','zzzzsys_user_id','',0,15,'SELECT * \nFROM zzzzsys_user \nLEFT JOIN zzzzsys_access ON zzzzsys_access_id = sus_zzzzsys_access_id\nORDER BY sus_name',''),('nubuildreport','browseedit','nubuildreport','Build Report','zzzzsys_report','zzzzsys_report_id','',0,0,'SELECT * FROM zzzzsys_report\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = sre_zzzzsys_form_id','\n$(\'#sre_layout\').addClass(\'nuEdited\'); \n\nnuAttachButtonImage(\'open_builder\',\'RD\');\n\n\nfunction nuPickTableType(){\n \n var i = $(\'#sre_zzzzsys_php_id\').val();\n \n var f = \'\';\n var r = \'\';\n \n if(i.substr(0,10) == \'PROCEDURE:\'){\n \n f = \'nuphp\';\n r = i.substr(10);\n \n }\n \n if(i == \'\'){\n \n nuMessage([nuTranslate(\'Table selected must be an SQL or Procedure\')]);\n return;\n\n }\n \n if(i.substr(0,6) == \'TABLE:\'){\n \n nuMessage(nuTranslate([\'To edit a table go to the Database Button\']));\n return;\n\n }\n \n if(i.substr(0,4) == \'SQL:\'){\n \n f = \'nuselect\';\n r = i.substr(4);\n\n }\n \n nuPopup(f,r);\n \n}\n'),('nuphp','browseedit','nuphp','Build Procedure','zzzzsys_php','zzzzsys_php_id','',0,0,'SELECT * FROM zzzzsys_php\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = sph_zzzzsys_form_id\nWHERE (sph_system != \'1\' || sph_system IS NULL)\nORDER BY sph_code\n','\nwindow.nuImages = parent.nuImages;\n\n$(\'#sph_php\')\n.addClass(\'php\')\n.dblclick(function() {\n nuOpenAce(\'PHP\', this.id);\n})\n\n\nwindow.nuHelp = \'Procedures\';\n\nif(window.filter == \'justphp\'){\n\n nuHelp = \'Functions\';\n var ev = [];\n ev[\'BB\'] = \'Before Browse\';\n ev[\'BE\'] = \'Before Edit\';\n ev[\'BS\'] = \'Before Save\';\n ev[\'AS\'] = \'After Save\';\n ev[\'BD\'] = \'Before Delete\';\n ev[\'AD\'] = \'After Delete\';\n ev[\'AB\'] = \'After Browse\';\n \n var suf = nuFORM.getCurrent().record_id.substr(-2);\n var e = ev[suf];\n var f = $(\'#sfo_description\', window.parent.document).val();\n\n if(e == \'After Browse\'){\n var f = $(\'#sob_all_label\', window.parent.document).val();\n }\n\n nuAttachButtonImage(\'icon\', suf);\n \n $(\'#sph_php\')\n .css(\'padding\', \'3px 3px 3px 3px\')\n .css(\'top\', \'40px\')\n .css(\'height\', \'200px\')\n .css(\'left\', \'90px\')\n .focus()\n\n \n $(\'#wiki\')\n .css(\'left\', \'670px\')\n\n $(\'#nu_bc_0\').html(\'<b>\' + e + \'</b> for : \' + f);\n $(\'#sph_code\').val(nuFORM.getCurrent().record_id).change();\n $(\'#sph_description\').val(\'System PHP\').change();\n $(\'#sph_system\').val(\'1\').change();\n $(\'#label_sph_php\').css(\'top\', \'40px\').css(\'left\', \'20px\');\n $(\'.nuSaveButtonEdited\').removeClass(\'nuSaveButtonEdited\');\n \n nuHide(\'sph_code\');\n nuHide(\'sph_description\');\n nuHide(\'sph_zzzzsys_form_id\');\n nuHide(\'sph_group\');\n nuHide(\'sph_system\');\n nuHide(\'sph_run\');\n\n nuSetTitle(e);\n \n}else{\n nuSetTitle($(\'#sph_code\').val());\n}\n\nnuHasNotBeenEdited();\n\n\n'),('nublank','launch','nublank','Blank','','','',0,0,'','\nnuSetTitle(nuFORM.getCurrent().run_description);\n'),('nuaccessgroup','subform','nuaccessgroup','Groups Access Level','zzzzsys_user_group_access_level','zzzzsys_user_group_access_level_id','',0,0,'SELECT * FROM zzzzsys_user_group_access_level',''),('nurunlist','browse','nurunlist','Run Form, Report or Procedure','zzzzsys_run_list','id','',0,0,'SELECT * FROM zzzzsys_run_list','\n$(\"[data-nu-column=\'nucolumn000\']\").each(function() {\n\n $(this).addClass(\'nu_\'+this.innerHTML);\n\n});'),('nudebug','browseedit','nudebug','nuDebug Entries','zzzzsys_debug','zzzzsys_debug_id','',21,15,'SELECT * FROM zzzzsys_debug\nORDER BY zzzzsys_debug_id DESC','\n$(\'#deb_message\')\n .css(\'font-size\', 10)\n .css(\'background-color\', \'#FFEEA6\')\n .prop(\'readonly\', true)\n .dblclick(function() {\n nuOpenAce(\'Text\', this.id);\n });\n\n\n\n\n\n$(\'#delete_option\').val(0);\n$(\'#nuAddButton\').remove();\n$(\'#nuOptions\').remove();\n\nvar mess = String($(\'#deb_message\').val());\nvar i = mess.indexOf(\'<br>\');\nvar m = mess.substr(i + 6);\nvar t = mess.substr(0,i);\n\nnuSetTitle(mess.substr(0, i))\n\n$(\'#nuTab0\').remove();\n\n$(\'#nuBreadcrumb1\')\n.css(\'text-align\', \'center\')\n.css(\'width\', \'95%\')\n.css(\'color\', \'black\')\n.css(\'padding\', \'5px\')\n.html(t + \' :: \' + nuWhen($(\'#deb_added\').val()))\n.appendTo(\"#nuTabHolder\");\n\n$(\'#deb_message\').val(m);\n\n\n$(\"[data-nu-column=\'1\']\").each(function( index ) {\n \n if($(this).html().trim() != \'\'){\n \n var nunow = Date.now();\n var nuhtm = nuWhen(Number($(this).html()));\n \n $(this).html(nuhtm);\n \n }\n \n});\n\nif(nuFORM.getCurrent().record_id != \'\'){\n\n $(\'.nuActionButton\').remove();\n nuAddActionButton(\'Delete\');\n nuAddActionButton(\'DeleteAll\',\'Delete All\', \'nuDeleteAllAction()\');\n\n}else{\n nuAddActionButton(\'DeleteAll\',\'Delete All\', \'nuDeleteAllAction()\');\n}\n\n'),('nuaccessreport','browseedit','nuaccessreport','Access To Procedures','zzzzsys_access_php','zzzzsys_access_php_id','',0,0,'SELECT * \nFROM zzzzsys_access_php\nJOIN zzzzsys_php ON zzzzsys_php_id = slp_zzzzsys_php_id\nORDER BY sph_code',''),('nuaccesslevelreport','browseedit','nuaccesslevelreport','Access To Report','zzzzsys_access_report','zzzzsys_access_report_id','',0,0,'SELECT * \nFROM zzzzsys_access_report\nJOIN zzzzsys_report ON zzzzsys_report_id = sre_zzzzsys_report_id\nORDER BY sre_code',''),('nurunreport','browseedit','nurunreport','Run Report','zzzzsys_report','zzzzsys_report_id','',0,0,'SELECT * FROM zzzzsys_report\nLEFT JOIN zzzzsys_form ON zzzzsys_form_id = sre_zzzzsys_form_id','\nnuSetTitle(nuFORM.getCurrent().run_description);\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\nfunction nuSelectBrowse(e){\n \n var r = $(\'#\' + e.target.id).attr(\'data-nu-row\');\n var f = $(\'#nucell_\' + r + \'_0\').html();\n var p = $(\'#\' + e.target.id).attr(\'data-nu-primary-key\');\n\n nuGetReport(f, p);\n \n}\n\n'),('nurunphp','browseedit','nurunphp','Run Procedure','zzzzsys_php','zzzzsys_php_id','',0,0,'SELECT * FROM zzzzsys_php\nJOIN zzzzsys_form ON zzzzsys_form_id = sph_zzzzsys_form_id\nWHERE (sph_system != \'1\' || sph_system IS NULL)\nORDER BY sph_code','\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\nfunction nuSelectBrowse(e){\n\n var r = $(\'#\' + e.target.id).attr(\'data-nu-row\');\n var p = $(\'#nucell_\' + r + \'_0\').html();\n var f = $(\'#\' + e.target.id).attr(\'data-nu-primary-key\');\n\n nuGetPHP(p, f);\n\n}\n\n'),('nulaunchdates','launch','nulaunchdates','Between 2 Dates','','','',0,0,'','\nnuSetTitle(nuFORM.getCurrent().run_description);'),('nutimezone','browse','nutimezone','Time Zone','zzzzsys_timezone','zzzzsys_timezone_id','',0,0,'SELECT * \nFROM zzzzsys_timezone\nORDER BY stz_timezone',''),('nusetup','edit','nusetup','Setup','zzzzsys_setup','zzzzsys_setup_id','',0,0,'','$(\'#set_header\').addClass(\'html\');\n \n$(\'.html\').dblclick(function() {\n nuOpenAce(\'HTML\', this.id);\n});\n\n'),('nutranslate','browseedit','nutranslate','Translation','zzzzsys_translate','zzzzsys_translate_id','',0,0,'SELECT * \nFROM zzzzsys_translate\nORDER BY trl_language, trl_english',''),('nupassword','edit','nupassword','Change Password','zzzzsys_user','zzzzsys_user_id','',0,0,'SELECT * FROM zzzzsys_user\nJOIN zzzzsys_user_group ON sus_zzzzsys_user_group_id = zzzzsys_user_group_id\nORDER BY sus_name','$(\'#nuTab0\').hide();'),('nusample','launch','nusample','Default Fast Form Objects','','','',0,0,'','//$(\'#nuBreadcrumbHolder\').remove();\n$(\'#nuActionHolder\').remove();\n//$(\'#nuTabHolder\').remove();\n\n$(\'#nuOptions\').hide();\n\n$(\'#inputtextsample\').val(\'text\');\n$(\'#inputnumbersample\').val(4);\n$(\'#inputnunumbersample\').val(\'$ 1,234.56\');\n$(\'#inputnudatesample\').val(\'20-Apr-2017\');\n$(\'#inputnuscrollsample\').val(\'East\');\n$(\'#calcsample\').val(\'$ 1,238.56\');\n\n$(\'#selectsample\').val(1);\n$(\'#selectmultiselectsample\').val(0);\n$(\'#textareasample\').val(\"text-area blah blah blah blah \");\n\n$(\"[id^=\'label\']\").addClass(\'nu_input\').css({width:120, left:10, \'text-align\':\'center\'});\n\n$(\'#label_imagesample\').addClass(\'nu_image\').removeClass(\'nu_input\');\n$(\'#label_textareasample\').addClass(\'nu_textarea\').removeClass(\'nu_input\');\n$(\'#label_displaysample\').addClass(\'nu_display\').removeClass(\'nu_input\');\n$(\'#label_htmlsample\').addClass(\'nu_html\').removeClass(\'nu_input\');\n$(\'#label_calcsample\').addClass(\'nu_calc\').removeClass(\'nu_input\');\n$(\'#label_selectsample\').addClass(\'nu_select\').removeClass(\'nu_input\');\n$(\'#label_selectmultiselectsample\').addClass(\'nu_select\').removeClass(\'nu_input\');\n$(\'#label_lookupsample\').addClass(\'nu_lookup\').removeClass(\'nu_input\');\n$(\'#labelword\').addClass(\'nu_word\').removeClass(\'nu_input\');\n$(\'#label_subformsample\').addClass(\'nu_subform\').removeClass(\'nu_input\').css({left:10});\n\n$(\"[id^=\'label\']\")\n.addClass(\'nuCalculatorButton\')\n.removeClass(\'nuWord\')\n.css({\'height\':30, \'width\':220})\n\n\n\n\n'),('nufastformobjects','subform','nufastformobjects','Fast Form Objects','zzzzsys_debug','zzzzsys_debug_id','',0,0,'SELECT count()* FROM zzzzsys_debug',''),('nucalcobjects','browse','nucalcobjects','Calc values On This Form And Its Subforms','#TABLE_ID#','thevalue','',0,4,'SELECT * FROM #TABLE_ID#','\nwindow.nuBrowseFunction = \'nuSelectCalcField\';\n\nfunction nuSelectCalcField(e){\n\n var row = e.target.id.substr(0,8);\n var fld = $(\'#\' + row + \'003\').html();\n var frm = $(\'#sob_calc_formula\', parent.window.document).val();\n\n $(\'#sob_calc_formula\', parent.window.document)\n .val(frm + \'nuTotal(\"\' + fld + \'\")\')\n .trigger(\'change\');\n\n}\n\n'),('nuformat','browseedit','nuformat','Input Formats','zzzzsys_format','zzzzsys_format_id','',0,0,'SELECT * FROM zzzzsys_format','\n$(\'#nucalculator\').css(\'border\',\'none\');\n$(\'#currencysign\').hide().addClass(\'nuCalculatorCurrency\').val(\'$\');\n$(\'#currencydecimals\').hide().addClass(\'nuCalculatorCurrency\').val(\'2\');\n$(\'#srm_format\').addClass(\'nuReadonly nuCalculatorCurrency\').css(\'font-size\', 12);\n$(\'.nuWord\').css(\'font-style\', \'bold\');\n\nnuSetFormatType();\n\n\nfunction nuAddToFormat(e){\n \n var v = String(e.target.innerHTML);\n \n if(v == \'Space\'){v = \' \';}\n \n if($(\'#srm_type\').val() == \'Date\'){\n \n $(\'#srm_format\')\n .val($(\'#srm_format\').val() + v)\n .change();\n \n }else{\n \n var c = String($(\'#currencysign\').val()).trim();\n var d = String(Number($(\'#currencydecimals\').val()));\n \n d = d == \'NaN\' ? 0 : Number(d);\n v = d == 0 ? v.substr(0, v.length - 1) : v;\n \n $(\'#srm_format\')\n .val(c + \' \' + v + String(0).repeat(d))\n .change();\n \n }\n \n}\n\n\nfunction nuSetFormatType(a){\n\n $(\'#format_title\').hide();\n $(\'#nucalculator\').hide();\n $(\'#currencysign\').hide();\n $(\'#currencydecimals\').hide();\n $(\'.date\').hide();\n $(\'.number\').hide();\n\n if(arguments.length == 1){\n $(\'#srm_format\').val(\'\');\n }\n \n if($(\'#srm_type\').val() == \'Date\'){\n $(\'.date\').show();\n }\n \n if($(\'#srm_type\').val() == \'Number\'){\n \n $(\'#currencysign\').show();\n $(\'#currencydecimals\').show();\n $(\'.number\').show();\n\n }\n\n $(\'#format_title\').show();\n $(\'#nucalculator\').show();\n \n}\n\n\n\n'),('nuformatcurrency','edit','nuformatcurrency','Format Currency','zzzzsys_format','zzzzsys_format_id','',0,0,'','$(\'#sign\').focus();\n\n\n$(\'#nuActionHolder\').remove();\n$(\'#nuBreadcrumbHolder\').remove();\n$(\'#nuTabHolder\').remove();\n\n\n\n\n\nfunction nuCreateCurrencyFormat(){\n console.log(\'in nuCreateCurrencyFormat()\');\n}\n'),('nuform','browseedit','nuform','nuBuilder Form','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nINNER JOIN #TABLE_ID# ON zzzzsys_form_id = theid\nORDER BY sfo_code\n','$(\'#title_zzzzsys_tab_sfsyt_help\').attr(\'id\', \'help_title\');\n$(\"[id$=\'syt_help\']\").addClass(\'js\');\nnuAttachButtonImage(\'previewbrowse\',\'PB\');\nnuAttachButtonImage(\'previewedit\',\'PE\');\nnuAttachButtonImage(\'bb_event\',\'BB\');\nnuAttachButtonImage(\'be_event\',\'BE\');\nnuAttachButtonImage(\'bs_event\',\'BS\');\nnuAttachButtonImage(\'as_event\',\'AS\');\nnuAttachButtonImage(\'bd_event\',\'BD\');\nnuAttachButtonImage(\'ad_event\',\'AD\');\nnuAttachButtonImage(\'icon\',\'JS\');\nnuAttachButtonImage(\'br_sql\',\'SQL\');\n\n$(\'#sfo_javascript\')\n.css(\'padding\', \'3px 3px 3px 3px\')\n\n\n$(\'#user_home\')\n.css({\n \'color\' : \'white\',\n \'font-size\' : 13,\n \'display\' : \'inline\',\n \'border-style\' : \'solid\',\n \'height\' : 30,\n \'font-size\' : 16,\n \'text-shadow\' : \'0 1px 2px #9AB973\',\n \'border-color\' : \'#9AB973\',\n \'border-width\' : \'0px 0px 1px 0px\',\n \'background-color\' : \'#88cb51\'\n});\n\n\n$(\'#sfo_javascript\').addClass(\'js\');\n$(\'#sfo_browse_sql\').addClass(\'sql\')\n.css(\'font-size\', 10)\n\nnuSetTitle($(\'#sfo_table\').val());\n\n$(\'.js\')\n.dblclick(function() {\n nuOpenAce(\'Javascript\', this.id);\n});\n\n$(\'.sql\').dblclick(function() {\n nuOpenAce(\'SQL\', this.id);\n});\n\n$(\'.html\')\n.dblclick(function() {\n nuOpenAce(\'HTML\', this.id);\n});\n\n\nif(window.filter == \'justjs\'){\n \n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#nuTab0\').remove();\n $(\'#nuTab1\').remove();\n $(\'#nuTab2\').click();\n $(\'#nuTab2\').remove();\n \n nuSetTitle($(\'#sfo_description\').val());\n \n}\n\n\nfunction nuFormColor(){\n\n var t = String($(\'#sfo_type\').val());\n\n var pb = \'previewbrowse\';\n var pe = \'previewedit\';\n\n var bb = \'bb_event\';\n var be = \'be_event\';\n var bs = \'bs_event\';\n var as = \'as_event\';\n var bd = \'bd_event\';\n var ad = \'ad_event\';\n \n if(t == \'browse\'){\n \n nuDisable(pe);\n\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'edit\'){\n \n nuDisable(pb);\n nuDisable(bb);\n \n }\n\n if(t == \'launch\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'subform\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n nuDisable(\'sfo_javascript\');\n \n }\n\n if(nuFORM.getCurrent().record_id == \'nuuserhome\'){\n // nuDisable(\'sfo_javascript\');\n }\n \n var h = $(\'#sfo_type\').addClass(\'nuEdited\');\n var o = [];\n o[\'browse\'] = [0,1,2];\n o[\'edit\'] = [0,2];\n o[\'browseedit\'] = [0,1,2];\n o[\'launch\'] = [0,2];\n o[\'subform\'] = [0,1];\n \n $(\'#sfo_type\').removeClass();\n $(\'#sfo_type\').addClass(\'nu_\'+$(\'#sfo_type\').val());\n \n if(h){\n $(\'#sfo_type\').addClass(\'nuEdited\');\n }\n \n $(\"#sfo_type > option\").each(function() {\n $(this).addClass(\'nu_\'+this.value);\n });\n\n for(var i = 0 ; i < 7 ; i++){\n $(\'#nuTab\' + i).removeClass(\'nuRelatedTab\');\n }\n var t = o[$(\'#sfo_type\').val()];\n\n if(t !== undefined){\n \n for(var i = 0 ; i < t.length ; i++){\n $(\'#nuTab\' + t[i]).addClass(\'nuRelatedTab\'); \n }\n \n }\n \n}\n\nnuFormColor();\n\n$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\ndefault_description();\n\nfunction nuEventList(){\n \n if($(\'sob_all_type\').val() == \'subform\'){\n return [\'onchange\',\'onadd\'];\n }else{\n return [\'onblur\',\'onchange\',\'onfocus\',\'onkeydown\'];\n }\n \n}\n\nfunction default_description(){\n \n var s = \'zzzzsys_browse_sf\';\n var r = nuSubformObject(s).rows.length - 1;\n var o = \'#\' + s + nuPad3(r) + \'sbr_title\';\n var d = \'Something\';\n\n $(o).val(d);\n\n}\n\n\n'),('nufile','browseedit','nufile','Stored Files','zzzzsys_file','zzzzsys_file_id','',150,3,'SELECT * FROM zzzzsys_file\nORDER BY sfi_code','\nnuSetNoSearchColumns([2,3]);\n\n$(\'[data-nu-column=\"0\"]\').each(function( index ) {\n\n var code = \'#nucell_\' + index + \'_\';\n window.nuImages[$(code + \'0\').text()] = $(code + \'2\').text();\n \n});\n\n\n\nif(nuFormType() == \'browse\'){\n nuShowBrowseImages()\n}else{\n nuShowFile();\n}\n\n\n\n\nfunction nuBeforeSave(){\n\n var f = $(\'#sfi_json_file\').val();\n \n if(f != \'\'){\n \n $(\'#sfi_json\')\n .val(f)\n .change();\n \n }\n \n return true;\n\n}\n\n\nfunction nuShowFile(){\n \n var j = $(\'#sfi_json\').val();\n \n nuEmbedObject(j, \'view_image\');\n \n}\n\n\nfunction nuShowBrowseImages(){\n\n $(\'[data-nu-column=\"0\"]\').each(function( index ) {\n \n var p = $(this).attr(\'id\');\n var r = String(p).split(\'_\')[1];\n var i = \"nucell_\" + r + \"_2\";\n var e = \"nucell_\" + r + \"_3\";\n var h = $(\'#\' + i).html();\n\n if(h != \'\' && h !== undefined){\n \n nuEmbedObject(h, e, 140, 140);\n\n }\n \n });\n\n}\n\n'),('nuselect','browseedit','nuselect','SQL Builder','zzzzsys_select','zzzzsys_select_id','',0,0,'SELECT * FROM zzzzsys_select \nWHERE (sse_system != 1 || sse_system IS NULL)\nORDER BY sse_description ASC\n\n','\nif(nuIsNewRecord()){\n $(\'#sse_edit\').val(0);\n}\n\n$(\"#sse_edit option[value=\'\']\").remove();\n\n$(\'#sse_sql\')\n.css(\'font-size\', 10)\n.addClass(\'sql\')\n.dblclick(function() {\n nuOpenAce(\'SQL\', this.id);\n});\n\n$(\'#label_sse_sql\').remove();\n\nnuSetSFCB();\n\nif(window.filter == \'justsql\'){\n\n var sid = String(nuFORM.getCurrent().record_id);\n var from = sid.substring(sid.length-2);\n var targ = \'#sfo_browse_sql\';\n\n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#sse_description\').val(sid);\n \n nuHide(\'sse_description\');\n \n if(nuFORM.getCurrent().record_id != -1){\n \n $(\'#nuSaveButton\').hide();\n \n if(from == \'BR\'){\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Form Browse SQL\', \'nuCopySQL(\"sfo_browse_sql\")\');\n }\n \n if(from == \'SE\'){\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Select Object SQL\', \'nuCopySQL(\"sob_select_sql\")\');\n }\n \n\n if(from == \'DI\'){\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Display Object SQL\', \'nuCopySQL(\"sob_display_sql\")\');\n }\n \n }\n\n}\n\n\n\nnuSetTitle($(\'#sal_code\').val());\n\n$(\'#sse_sql\')\n.css({\n \'white-space\' : \'nowrap\',\n \'overflow-x\' : \'scroll\',\n})\n\nnuWhereClauses();\n\n\nfunction nuCopySQL(targ){\n \n var s = $(\'#sse_sql\').val();\n \n parent.$(\'#\' + targ).val(s).change();\n \n parent.$(\'#dialogClose\').click();\n\n}\n\n\nfunction nuTempPHP(){\n \n var p = [];\n \n p.push(\'\');\n p.push(\'$sql = \"\');\n p.push(\'\');\n p.push(\'CREATE TABLE #TABLE_ID#\');\n p.push($(\'#sse_sql\').val());\n p.push(\'\');\n p.push(\'\";\');\n p.push(\'\');\n p.push(\"nuRunQuery($sql);\");\n p.push(\'\');\n nuMessage(p);\n// $(\"#nuAlertDiv\").css(\'text-align\', \'left\')\n $(\"#nuMessageDiv\").css(\'text-align\', \'left\')\n\n}\n\nfunction nuBeforeSave(){\n \n $(\'#sqlframe\')[0].contentWindow.nuSQL.buildSQL();\n return true;\n \n}\n\n\n\n\nfunction nuWhereClauses(){\n\n $(\"[id$=\'ssc_type\']select\").each(function(index){\n \n var p = $(this).attr(\'data-nu-prefix\');\n var t = $(this).val();\n \n if(t == 2 || t == 3){\n \n if($(\'#\' + p + \'ssc_sort\').val() == \'\'){\n $(\'#\' + p + \'ssc_sort\').val(\'ASC\');\n }\n \n $(\'#\' + p + \'ssc_clause\').hide();\n $(\'#\' + p + \'ssc_sort\').show();\n \n }else{\n \n $(\'#\' + p + \'ssc_clause\').show();\n $(\'#\' + p + \'ssc_sort\').hide();\n \n }\n\n });\n\n}\n\n\nfunction nuWhereClausesold(){\n\n $(\"[id$=\'ssc_type\']select\").each(function(index){\n \n var p = $(this).attr(\'data-nu-prefix\');\n var t = $(this).val();\n \n if(t == 2 || t == 3){\n \n if($(\'#\' + p + \'ssc_sort\').val() == \'\'){\n $(\'#\' + p + \'ssc_sort\').val(\'ASC\');\n }\n \n $(\'#\' + p + \'ssc_clause\').hide();\n $(\'#\' + p + \'ssc_sort\').show();\n \n }else{\n \n $(\'#\' + p + \'ssc_clause\').show();\n $(\'#\' + p + \'ssc_sort\').hide();\n \n }\n\n });\n\n}\n\n\nfunction nuAddSQLTable(e){\n \n var s = $(\'#sqlframe\')[0].contentWindow.nuSQL;\n \n s.addBox(e.target.value);\n e.target.value = \'\';\n s.buildSQL();\n\n}\n\n\nfunction nuSFCB(){\n \n nuWhereClauses();\n $(\'#sqlframe\')[0].contentWindow.nuSQL.buildSQL();\n\n}\n\n\nfunction nuSetSFCB(){\n \n $(\'.nuSubformCheckbox.zzzzsys_select_clause\')\n .click(function(){\n nuSFCB();\n });\n \n}\n\n\n\nfunction nuResizeSQL(){\n\n if($(\'#sqlframe\').css(\'height\') == \'470px\'){\n $(\'#sqlframe\').css(\'height\', 180);\n }else{\n $(\'#sqlframe\').css(\'height\', 470);\n }\n \n}\n\n\n'),('nulaunchable','browse','nulaunchable','Launchable Forms','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nWHERE sfo_type IN (\'edit\', \'browseedit\', \'launch\')\nAND (\n SUBSTRING(zzzzsys_form_id, 1, 2) != \'nu\'\n OR zzzzsys_form_id = \'nublank\'\n OR zzzzsys_form_id = \'nuuserhome\'\n )\nORDER BY sfo_code\n','$(\'#sfo_breadcrumb_title\').addClass(\'sql\');\n$(\'#sfo_browse_sql\').addClass(\'sql\');\n$(\'#sfo_javascript\').addClass(\'js\');\n\nnuSetTitle($(\'#sfo_table\').val());\n\n$(\'.js\').dblclick(function() {\n nuOpenAce(\'Javascript\', this.id);\n});\n\n$(\'.sql\').dblclick(function() {\n nuOpenAce(\'SQL\', this.id);\n});\n\n$(\'.html\').dblclick(function() {\n nuOpenAce(\'HTML\', this.id);\n});\n\n$(\'.php\').dblclick(function() {\n nuOpenAce(\'PHP\', this.id);\n});\n\nif(window.filter == \'justjs\'){\n \n $(\'#nuDeleteButton\').remove();\n $(\'#nuCloneButton\').remove();\n $(\'#nuTab0\').remove();\n $(\'#nuTab1\').remove();\n $(\'#nuTab2\').click();\n $(\'#nuTab2\').remove();\n \n nuSetTitle($(\'#sfo_description\').val());\n \n}\n\n\n\nfunction nuFormColor(){\n\n var t = String($(\'#sfo_type\').val());\n\n var pb = \'previewbrowse\';\n var pe = \'previewedit\';\n\n var bb = \'bb_event\';\n var be = \'be_event\';\n var bs = \'bs_event\';\n var as = \'as_event\';\n var bd = \'bd_event\';\n var ad = \'ad_event\';\n \n if(t == \'browse\'){\n \n nuDisable(pe);\n\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'edit\'){\n \n nuDisable(pb);\n nuDisable(bb);\n \n }\n\n if(t == \'launch\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n\n }\n \n if(t == \'subform\'){\n \n nuDisable(pb);\n nuDisable(bb);\n nuDisable(be);\n nuDisable(bs);\n nuDisable(as);\n nuDisable(bd);\n nuDisable(ad);\n nuDisable(\'sfo_javascript\');\n \n }\n\n var h = $(\'#sfo_type\').addClass(\'nuEdited\');\n var o = [];\n o[\'browse\'] = [0,1,2];\n o[\'edit\'] = [0,2];\n o[\'browseedit\'] = [0,1,2];\n o[\'launch\'] = [0,2];\n o[\'subform\'] = [0,1];\n \n $(\'#sfo_type\').removeClass();\n $(\'#sfo_type\').addClass(\'nu_\'+$(\'#sfo_type\').val());\n \n if(h){\n $(\'#sfo_type\').addClass(\'nuEdited\');\n }\n \n $(\"#sfo_type > option\").each(function() {\n $(this).addClass(\'nu_\'+this.value);\n });\n\n for(var i = 0 ; i < 7 ; i++){\n $(\'#nuTab\' + i).removeClass(\'nuRelatedTab\');\n }\n var t = o[$(\'#sfo_type\').val()];\n\n if(t !== undefined){\n \n for(var i = 0 ; i < t.length ; i++){\n $(\'#nuTab\' + t[i]).addClass(\'nuRelatedTab\'); \n }\n \n }\n \n}\n\nnuFormColor();\n\n//nuBuildSubformArray(\'zzzzsys_tab_sf\');\n//nuBuildSubformArray(\'zzzzsys_browse_sf\');\n\n$(\"[data-nu-column=\'nucolumn000\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n\n\nfunction nuEventList(){\n \n if($(\'sob_all_type\').val() == \'subform\'){\n return [\'onchange\',\'onadd\'];\n }else{\n return [\'onblur\',\'onchange\',\'onfocus\',\'onkeydown\'];\n }\n \n}\n\n\n'),('nuclause','subform','nuclause','Select Clauses','zzzzsys_select_clause','zzzzsys_select_clause_id','',0,0,'SELECT * FROM zzzzsys_select_clause\nORDER BY ssc_type, ssc_order',''),('nubuildtable','browse','nubuildtable','PHP or SELECT or TABLE','zzzzsys_report_data','id','nuselect',0,0,'SELECT * FROM zzzzsys_report_data',''),('nuuserhome','launch','nuuserhome','Home','','','',0,0,'',''),('nufrlaunch','launch','nufrlaunch','Fast Report','','','',0,0,'SELECT * FROM Launch Form 0','\n$(\'#wrdaddable\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'#frwrd\').css({\'font-size\' : 14, \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\n$(\'#nufr\').css(\'text-align\', \'left\').css(\'padding\', \'3px\');\n$(\'#list\').addClass(\'nuScroll\').removeClass(\'nuReadonly\');\n\n$(\'.nuActionButton\').hide();\nnuAddActionButton(\'nuRunPHPHidden\', \'Build Fast Report\', \'nuRunPHPHidden(\"RUNFR\")\');\n\n\nfunction nuAddReportField(t){\n\n var f = nuPad3($(\"[data-nu-label=\'Field Name\']\").length - 1);\n\n $(\'#fast_report_sf\' + f + \'field\').val($(t).html()).change();\n $(\'#fast_report_sf\' + f + \'width\').val(100).change();\n $(\'#fast_report_sf\' + f + \'sum\').val(\'no\').change();\n $(\'#fast_report_sf\' + f + \'title\').val($(t).html()).change().select();\n \n}\n\n\nfunction nuBeforeSave(){\n \n if($(\'#table\').val() == \'\'){\n \n nuMessage([\'<b>Table Data</b>\', \'Cannot be left blank...\'])\n return false;\n \n }\n \n \n if($(\'#orderby\').val() == \'\'){\n \n nuMessage([\'<b>Order By</b>\', \'Cannot be left blank...\'])\n return false;\n \n }\n \n nuBuildFastReport();\n \n return true;\n \n}\n\n'),('nufastreportobjects','subform','nufastreportobjects','Fast Report Objects','zzzzsys_debug','zzzzsys_debug_id','',0,0,'SELECT count(*) FROM zzzzsys_debug',''),('nusamplesubformform','launch','nusamplesubformform','Sample Subform Form','','','',0,0,'SELECT * FROM Launch Form 0',''),('nulaunchform','edit','nulaunchform','nuBuilder non-System Form','zzzzsys_form','zzzzsys_form_id','',0,0,'SELECT * FROM zzzzsys_form\nWHERE sfo_type != \'subform\' AND zzzzsys_form_id != \'nuhome\'\nORDER BY sfo_code\n','$(\"[data-nu-column=\'0\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\n'),('nutablookup','browse','nutablookup','Form Tab Lookup','zzzzsys_tab','zzzzsys_tab_id','',0,0,'SELECT * FROM zzzzsys_tab\nJOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id\nJOIN #TABLE_ID# ON zzzzsys_form_id = theid\nORDER BY syt_order','\n$(\"[data-nu-column=\'3\']\").each(function() {\n $(this).addClass(\'nu_\'+this.textContent);\n});\n\n$(\'#nuAddButton\').remove();\n$(\'#nuPrintButton\').remove();\n\n'); 270 270 /*!40000 ALTER TABLE `zzzzsys_form` ENABLE KEYS */; 271 271 UNLOCK TABLES; … … 513 513 LOCK TABLES `zzzzsys_session` WRITE; 514 514 /*!40000 ALTER TABLE `zzzzsys_session` DISABLE KEYS */; 515 INSERT INTO `zzzzsys_session` VALUES ('s15474324483313','{\"session\":{\"zzzzsys_access_id\":\"\",\"zzzzsys_user_id\":\"globeadmin\",\"zzzzsys_form_id\":\"nuhome\",\"global_access\":\"1\"},\"forms\":[[\"nuaccess\"],[\"nuaccessforms\"],[\"nuaccessgroup\"],[\"nuaccesslevelreport\"],[\"nuaccessreport\"],[\"nublank\"],[\"nubrowse\"],[\"nubuildreport\"],[\"nubuildtable\"],[\"nucalcobjects\"],[\"nuclause\"],[\"nudebug\"],[\"nuevent\"],[\"nufastformobjects\"],[\"nufastreportobjects\"],[\"nufflaunch\"],[\"nufile\"],[\"nuform\"],[\"nuformat\"],[\"nuformatcurrency\"],[\"nufrlaunch\"],[\"nuhome\"],[\"nulaunchable\"],[\"nulaunchdates\"],[\"nulaunchform\"],[\"nunonsystemform\"],[\"nuobject\"],[\"nupassword\"],[\"nuphp\"],[\"nurunlist\"],[\"nurunphp\"],[\"nurunreport\"],[\"nusample\"],[\"nusamplesubformform\"],[\"nuselect\"],[\"nusetup\"],[\"nutab\"],[\"nutablookup\"],[\"nutimezone\"],[\"nutranslate\"],[\"nuuser\"],[\"nuuserhome\"]],\"reports\":[[\"5bc68a6c08986e0\",\"nublank\"],[\"5bc68f8fd43b779\",\"nublank\"],[\"5bd1137a601c5bb\",\"nublank\"]],\"procedures\":[[\"nuform_BS\",\"\"],[\"nuphp_BS\",\"\"],[\"nupassword_BS\",\"\"],[\"nudebug_BE\",\"\"],[\"nuuser_AS\",\"\"],[\"nurunlist_BB\",\"\"],[\"nudebug_BD\",\"\"],[\"nuobject_BS\",\"\"],[\"nuform_AS\",\"\"],[\"nucalcobjects_BB\",\"\"],[\"nuform_AD\",\"\"],[\"nufastform\",\"nufflaunch\"],[\"nuobject_BB\",\"\"],[\"nuform_BB\",\"\"],[\"nuphp_BB\",\"\"],[\"nuselect_BS\",\"\"],[\"nuphp_BE\",\"\"],[\"nutranslate_AS\",\"\"],[\"nuaccessreport_BB\",\"\"],[\"nutranslate_BE\",\"\"],[\"nuhome_BE\",\"\"],[\"nuphp_AD\",\"\"],[\"nuform_BE\",\"\"],[\"nuupdatesystemids\",\"nublank\"],[\"nu5bad6cb329dcb6e_AB\",\"\"],[\"nu5bad6cb32c9102c_AB\",\"\"],[\"nu5bad6cb32dcbcb4_AB\",\"\"],[\"nu5bad6cb33715015_AB\",\"\"],[\"nuaccess_AD\",\"\"],[\"nuaccessreport_AD\",\"\"],[\"nuaccess_BE\",\"\"],[\"\",\"\"],[\"nuaccessforms_AD\",\"\"],[\"nuaccess_AS\",\"\"],[\"nuaccess_BB\",\"\"],[\"nuaccess_BD\",\"\"],[\"nu5bad6cb32600c97_AB\",\"\"],[\"nu5bad6cb35f2188f_AB\",\"\"],[\"nufastreport\",\"nufflaunch\"],[\"nuobject_BE\",\"\"],[\"nuaccessforms_BE\",\"\"],[\"nupassword_BE\",\"\"],[\"nudebug_BS\",\"\"],[\"nudebug_AS\",\"\"],[\"nudebug_BB\",\"\"],[\"nudebug_AD\",\"\"],[\"nutab_BB\",\"\"],[\"nutablookup_BB\",\"\"],[\"nuuser_BS\",\"\"],[\"5bd1116f5bb7571\",\"nublank\"]],\"access_level_code\":\"\",\"nufirsttime\":\"non\",\"clientTableSchema\":{\"zzzzsys_access\":{\"names\":[\"zzzzsys_access_id\",\"sal_code\",\"sal_description\",\"sal_zzzzsys_form_id\"],\"types\":[\"varchar(25)\",\"varchar(50)\",\"varchar(200)\",\"varchar(25)\"],\"primary_key\":[\"zzzzsys_access_id\"],\"valid\":1},\"zzzzsys_access_form\":{\"names\":[\"zzzzsys_access_form_id\",\"slf_zzzzsys_access_id\",\"slf_zzzzsys_form_id\",\"slf_add_button\",\"slf_save_button\",\"slf_delete_button\",\"slf_clone_button\",\"slf_new_button\",\"slf_print_button\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(25)\",\"varchar(1)\",\"varchar(1)\",\"varchar(1)\",\"varchar(1)\",\"varchar(1)\",\"varchar(1)\"],\"primary_key\":[\"zzzzsys_access_form_id\"],\"valid\":1},\"zzzzsys_access_php\":{\"names\":[\"zzzzsys_access_php_id\",\"slp_zzzzsys_access_id\",\"slp_zzzzsys_php_id\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(25)\"],\"primary_key\":[\"zzzzsys_access_php_id\"],\"valid\":1},\"zzzzsys_access_report\":{\"names\":[\"zzzzsys_access_report_id\",\"sre_zzzzsys_access_id\",\"sre_zzzzsys_report_id\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(25)\"],\"primary_key\":[\"zzzzsys_access_report_id\"],\"valid\":1},\"zzzzsys_browse\":{\"names\":[\"zzzzsys_browse_id\",\"sbr_zzzzsys_form_id\",\"sbr_title\",\"sbr_display\",\"sbr_align\",\"sbr_format\",\"sbr_order\",\"sbr_width\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(100)\",\"varchar(512)\",\"char(1)\",\"varchar(300)\",\"int(11)\",\"int(11)\"],\"primary_key\":[\"zzzzsys_browse_id\"],\"valid\":1},\"zzzzsys_debug\":{\"names\":[\"zzzzsys_debug_id\",\"deb_message\",\"deb_added\"],\"types\":[\"varchar(25)\",\"longtext\",\"int(11)\"],\"primary_key\":[\"zzzzsys_debug_id\"],\"valid\":1},\"zzzzsys_event\":{\"names\":[\"zzzzsys_event_id\",\"sev_zzzzsys_object_id\",\"sev_event\",\"sev_javascript\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(100)\",\"varchar(3000)\"],\"primary_key\":[\"zzzzsys_event_id\"],\"valid\":1},\"zzzzsys_file\":{\"names\":[\"zzzzsys_file_id\",\"sfi_code\",\"sfi_description\",\"sfi_group\",\"sfi_json\",\"sfi_system\"],\"types\":[\"varchar(25)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"longtext\",\"char(1)\"],\"primary_key\":[\"zzzzsys_file_id\"],\"valid\":1},\"zzzzsys_form\":{\"names\":[\"zzzzsys_form_id\",\"sfo_type\",\"sfo_code\",\"sfo_description\",\"sfo_table\",\"sfo_primary_key\",\"sfo_browse_redirect_form_id\",\"sfo_browse_row_height\",\"sfo_browse_rows_per_page\",\"sfo_browse_sql\",\"sfo_javascript\"],\"types\":[\"varchar(25)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"int(11)\",\"int(11)\",\"text\",\"longtext\"],\"primary_key\":[\"zzzzsys_form_id\"],\"valid\":1},\"zzzzsys_format\":{\"names\":[\"zzzzsys_format_id\",\"srm_type\",\"srm_format\"],\"types\":[\"varchar(25)\",\"varchar(10)\",\"varchar(300)\"],\"primary_key\":[\"zzzzsys_format_id\"],\"valid\":1},\"zzzzsys_object\":{\"names\":[\"zzzzsys_object_id\",\"sob_all_zzzzsys_form_id\",\"sob_all_table\",\"sob_all_type\",\"sob_all_id\",\"sob_all_label\",\"sob_all_zzzzsys_tab_id\",\"sob_all_order\",\"sob_all_top\",\"sob_all_left\",\"sob_all_width\",\"sob_all_height\",\"sob_all_cloneable\",\"sob_all_align\",\"sob_all_validate\",\"sob_all_access\",\"sob_calc_formula\",\"sob_calc_format\",\"sob_run_zzzzsys_form_id\",\"sob_run_filter\",\"sob_run_method\",\"sob_run_id\",\"sob_display_sql\",\"sob_select_multiple\",\"sob_select_sql\",\"sob_lookup_code\",\"sob_lookup_description\",\"sob_lookup_description_width\",\"sob_lookup_autocomplete\",\"sob_lookup_zzzzsys_form_id\",\"sob_lookup_javascript\",\"sob_lookup_php\",\"sob_lookup_table\",\"sob_subform_zzzzsys_form_id\",\"sob_subform_foreign_key\",\"sob_subform_add\",\"sob_subform_delete\",\"sob_subform_type\",\"sob_subform_table\",\"sob_input_count\",\"sob_input_format\",\"sob_input_type\",\"sob_input_javascript\",\"sob_html_code\",\"sob_html_chart_type\",\"sob_html_javascript\",\"sob_html_title\",\"sob_html_vertical_label\",\"sob_html_horizontal_label\",\"sob_image_zzzzsys_file_id\"],\"types\":[\"varchar(25)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(1000)\",\"varchar(300)\",\"int(11)\",\"int(11)\",\"int(11)\",\"int(11)\",\"int(11)\",\"varchar(300)\",\"varchar(10)\",\"varchar(1)\",\"varchar(1)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(1)\",\"varchar(300)\",\"text\",\"varchar(300)\",\"text\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"text\",\"varchar(25)\",\"varchar(500)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"bigint(20)\",\"varchar(300)\",\"varchar(300)\",\"text\",\"text\",\"varchar(1000)\",\"varchar(1000)\",\"varchar(1000)\",\"varchar(1000)\",\"varchar(1000)\",\"varchar(25)\"],\"primary_key\":[\"zzzzsys_object_id\"],\"valid\":1},\"zzzzsys_php\":{\"names\":[\"zzzzsys_php_id\",\"sph_code\",\"sph_description\",\"sph_group\",\"sph_php\",\"sph_run\",\"sph_zzzzsys_form_id\",\"sph_system\",\"sph_hide\"],\"types\":[\"varchar(25)\",\"varchar(300)\",\"varchar(300)\",\"varchar(100)\",\"longtext\",\"varchar(20)\",\"varchar(25)\",\"varchar(1)\",\"varchar(1)\"],\"primary_key\":[\"zzzzsys_php_id\"],\"valid\":1},\"zzzzsys_report\":{\"names\":[\"zzzzsys_report_id\",\"sre_code\",\"sre_description\",\"sre_group\",\"sre_zzzzsys_php_id\",\"sre_zzzzsys_form_id\",\"sre_layout\"],\"types\":[\"varchar(25)\",\"varchar(300)\",\"varchar(300)\",\"varchar(100)\",\"varchar(25)\",\"varchar(25)\",\"longtext\"],\"primary_key\":[\"zzzzsys_report_id\"],\"valid\":1},\"zzzzsys_report_data\":{\"names\":[\"id\",\"code\",\"description\"],\"types\":[\"varchar(306)\",\"varchar(300)\",\"varchar(300)\"],\"primary_key\":[],\"valid\":1},\"zzzzsys_run_list\":{\"names\":[\"id\",\"run\",\"code\",\"description\"],\"types\":[\"varchar(25)\",\"varchar(9)\",\"varchar(300)\",\"varchar(300)\"],\"primary_key\":[],\"valid\":1},\"zzzzsys_select\":{\"names\":[\"zzzzsys_select_id\",\"sse_description\",\"sse_json\",\"sse_sql\",\"sse_edit\",\"sse_system\"],\"types\":[\"varchar(25)\",\"varchar(300)\",\"mediumtext\",\"mediumtext\",\"varchar(1)\",\"varchar(1)\"],\"primary_key\":[\"zzzzsys_select_id\"],\"valid\":1},\"zzzzsys_select_clause\":{\"names\":[\"zzzzsys_select_clause_id\",\"ssc_zzzzsys_select_id\",\"ssc_type\",\"ssc_field\",\"ssc_clause\",\"ssc_sort\",\"ssc_order\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(300)\",\"varchar(500)\",\"varchar(500)\",\"varchar(10)\",\"varchar(500)\"],\"primary_key\":[\"zzzzsys_select_clause_id\"],\"valid\":1},\"zzzzsys_session\":{\"names\":[\"zzzzsys_session_id\",\"sss_access\",\"sss_time\"],\"types\":[\"varchar(25)\",\"mediumtext\",\"int(11)\"],\"primary_key\":[\"zzzzsys_session_id\"],\"valid\":1},\"zzzzsys_setup\":{\"names\":[\"zzzzsys_setup_id\",\"set_time_out_minutes\",\"set_zzzzsys_timezone_id\",\"set_language\",\"set_smtp_username\",\"set_smtp_password\",\"set_smtp_host\",\"set_smtp_from_address\",\"set_smtp_from_name\",\"set_smtp_port\",\"set_smtp_use_authentication\",\"set_header\",\"set_denied\"],\"types\":[\"varchar(25)\",\"int(11)\",\"varchar(25)\",\"varchar(20)\",\"varchar(255)\",\"varchar(255)\",\"varchar(255)\",\"varchar(255)\",\"varchar(255)\",\"int(4)\",\"varchar(1)\",\"longtext\",\"varchar(1)\"],\"primary_key\":[\"zzzzsys_setup_id\"],\"valid\":1},\"zzzzsys_tab\":{\"names\":[\"zzzzsys_tab_id\",\"syt_zzzzsys_form_id\",\"syt_title\",\"syt_order\",\"syt_help\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(250)\",\"int(11)\",\"varchar(3000)\"],\"primary_key\":[\"zzzzsys_tab_id\"],\"valid\":1},\"zzzzsys_table\":{\"names\":[\"zzzzsys_table_id\"],\"types\":[\"varchar(300)\"],\"primary_key\":[],\"valid\":1},\"zzzzsys_timezone\":{\"names\":[\"zzzzsys_timezone_id\",\"stz_timezone\"],\"types\":[\"varchar(25)\",\"mediumtext\"],\"primary_key\":[\"zzzzsys_timezone_id\"],\"valid\":1},\"zzzzsys_translate\":{\"names\":[\"zzzzsys_translate_id\",\"trl_language\",\"trl_english\",\"trl_translation\"],\"types\":[\"varchar(25)\",\"varchar(20)\",\"varchar(500)\",\"varchar(500)\"],\"primary_key\":[\"zzzzsys_translate_id\"],\"valid\":1},\"zzzzsys_user\":{\"names\":[\"zzzzsys_user_id\",\"sus_zzzzsys_access_id\",\"sus_language\",\"sus_name\",\"sus_email\",\"sus_login_name\",\"sus_login_password\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(20)\",\"varchar(50)\",\"varchar(255)\",\"varchar(20)\",\"varchar(300)\"],\"primary_key\":[\"zzzzsys_user_id\"],\"valid\":1}},\"clientFormSchema\":{\"nuaccess\":[[\"nu5bad6cb336a9f96\",\"sal_code\",\"Code\",\"input\",\"text\"],[\"nu5bd10c9148543a6\",\"sal_description\",\"Description\",\"input\",\"text\"],[\"nu5bad6cb3351b6a4\",\"sal_zzzzsys_form_id\",\"Home\",\"lookup\",\"\"]],\"nuaccessforms\":[[\"nu5bad6cb337ab8d0\",\"slf_add_button\",\"<br>  <span class=\'nuActionButton\'>Add<\\/span>\",\"input\",\"checkbox\"],[\"nu5bad6cb3399c9cf\",\"slf_clone_button\",\"<br> <span class=\'nuActionButton\'>Clone<\\/span>\",\"input\",\"checkbox\"],[\"nu5bad6cb338c7612\",\"slf_delete_button\",\"<br> <span class=\'nuActionButton\'>Delete<\\/span>\",\"input\",\"checkbox\"],[\"nu5bad6cb33a4e07f\",\"slf_print_button\",\"<br> <span class=\'nuActionButton\'>Print<\\/span>\",\"input\",\"checkbox\"],[\"nu5bad6cb338330bb\",\"slf_save_button\",\"<br> <span class=\'nuActionButton\'>Save<\\/span>\",\"input\",\"checkbox\"],[\"nu5bad6cb33715015\",\"slf_zzzzsys_form_id\",\"Form\",\"lookup\",\"\"]],\"nuaccessgroup\":[[\"nu5bad6cb34130517\",\"gal_zzzzsys_access_id\",\"Access To..\",\"lookup\",\"\"]],\"nuaccesslevelreport\":[[\"nu5bad6cb342de027\",\"sre_zzzzsys_report_id\",\"Report\",\"lookup\",\"\"]],\"nuaccessreport\":[[\"nu5bad6cb341fdfc3\",\"slp_zzzzsys_php_id\",\"Procedure\",\"lookup\",\"\"]],\"nublank\":[],\"nubrowse\":[[\"nu5bad6cb328350f1\",\"sbr_align\",\"Align\",\"select\",\"text\"],[\"nu5bad6cb327ee8dc\",\"sbr_display\",\"Display\",\"input\",\"nuScroll\"],[\"nu5bad6cb32856f55\",\"sbr_format\",\"Format\",\"select\",\"text\"],[\"nu5bad6cb3289c6f6\",\"sbr_order\",\"Order\",\"input\",\"number\"],[\"nu5bad6cb327ca554\",\"sbr_title\",\"Title\",\"input\",\"text\"],[\"nu5bad6cb328796fe\",\"sbr_width\",\"Width\",\"input\",\"number\"]],\"nubuildreport\":[[\"nu5bad6cb32930450\",\"open_builder\",\"Report Designer\",\"input\",\"button\"],[\"nu5bad6cb3670b7db\",\"open_sql\",\"Open\",\"input\",\"button\"],[\"nu5bad6cb340c5469\",\"sre_code\",\"Code\",\"input\",\"text\"],[\"nu5bad6cb340fb412\",\"sre_description\",\"Description\",\"input\",\"text\"],[\"nu5bad6cb343a3176\",\"sre_group\",\"Group\",\"input\",\"text\"],[\"nu5bad6cb3295b165\",\"sre_layout\",\"Layout\",\"textarea\",\"\"],[\"nu5bad6cb3400c80a\",\"sre_zzzzsys_form_id\",\"Launch From\",\"lookup\",\"\"],[\"nu5bad6cb345094c6\",\"sre_zzzzsys_php_id\",\"Table\",\"lookup\",\"\"]],\"nubuildtable\":[],\"nucalcobjects\":[],\"nuclause\":[[\"nu5bad6cb35ad7f0a\",\"ssc_clause\",\"Clause\",\"input\",\"text\"],[\"nu5bad6cb35afa1d0\",\"ssc_field\",\"Field\",\"input\",\"nuScroll\"],[\"nu5bad6cb35a8885a\",\"ssc_order\",\"Order\",\"input\",\"number\"],[\"nu5bad6cb35b860e2\",\"ssc_sort\",\"Sort\",\"select\",\"number\"],[\"nu5bad6cb35ab1f0a\",\"ssc_type\",\"Type\",\"select\",\"number\"]],\"nudebug\":[[\"nu5bad6cb35977ed6\",\"deb_added\",\" \",\"input\",\"text\"],[\"nu5bad6cb3416c803\",\"deb_message\",\" \",\"textarea\",\"\"]],\"nuevent\":[[\"nu5bad6cb331a6d3e\",\"sev_event\",\"Event\",\"input\",\"nuScroll\"],[\"nu5bad6cb3316ef87\",\"sev_javascript\",\"Javascript\",\"input\",\"text\"]],\"nufastformobjects\":[[\"nu5bad6cb35d6b273\",\"ff_browse\",\"Browse<br>Column\",\"input\",\"checkbox\"],[\"nu5bad6cb34ebf5bd\",\"ff_field\",\"Field Name\",\"input\",\"nuScroll\"],[\"nu5bad6cb35304ffd\",\"ff_id\",\" \",\"input\",\"text\"],[\"nu5bad6cb34ee220e\",\"ff_label\",\" Label\",\"input\",\"text\"]],\"nufastreportobjects\":[[\"nu5bad6cb3618939f\",\"field\",\"Field Name\",\"input\",\"text\"],[\"nu5bad6cb3608c14b\",\"sum\",\"Sum\",\"input\",\"checkbox\"],[\"nu5bad6cb3604269d\",\"title\",\"Title\",\"input\",\"text\"],[\"nu5bad6cb35f5d25f\",\"width\",\"Width\",\"input\",\"number\"]],\"nufflaunch\":[[\"nu5bad6cb366e865e\",\"fastform_fk\",\"Foreign Key Field Name\",\"input\",\"text\"],[\"nu5bad6cb352dce42\",\"fastform_table\",\"Table Name\",\"input\",\"nuScroll\"],[\"nu5bad6cb35dadfc5\",\"fastform_type\",\"Form Type\",\"select\",\"\"],[\"nu5bad6cb3532d677\",\"new_id\",\"New ID\",\"input\",\"text\"],[\"nu5bad6cb3568c736\",\"run_sam\",\"?\",\"input\",\"button\"]],\"nufile\":[[\"nu5bad6cb35724861\",\"sfi_code\",\"Code\",\"input\",\"text\"],[\"nu5bad6cb3574909c\",\"sfi_description\",\"Description\",\"input\",\"text\"],[\"nu5bad6cb357ff16d\",\"sfi_group\",\"Group\",\"input\",\"text\"],[\"nu5bad6cb35d8ed3e\",\"sfi_json\",\"Upload File \",\"textarea\",\"file\"],[\"nu5bad6cb35772a8c\",\"sfi_json_file\",\"Upload File \",\"input\",\"file\"]],\"nuform\":[[\"nu5bad6cb34e2eaec\",\"ad_event\",\"After Delete\",\"input\",\"button\"],[\"nu5bad6cb34d23de5\",\"as_event\",\"After Save\",\"input\",\"button\"],[\"nu5bad6cb329136ba\",\"bb_event\",\"Before Browse\",\"input\",\"button\"],[\"nu5bad6cb34d7e1db\",\"bd_event\",\"Before Delete\",\"input\",\"button\"],[\"nu5bad6cb34c005d7\",\"be_event\",\"Before Edit\",\"input\",\"button\"],[\"nu5bad6cb35cf61c0\",\"br_sql\",\"SQL Builder\",\"input\",\"button\"],[\"nu5bad6cb34c4775c\",\"bs_event\",\"Before Save\",\"input\",\"button\"],[\"nu5bad6cb3518a9c0\",\"previewbrowse\",\"Preview Browse Form\",\"input\",\"button\"],[\"nu5bad6cb34e5cc53\",\"previewedit\",\"Preview Edit Form\",\"input\",\"button\"],[\"nu5bad6cb3275e50e\",\"sfo_browse_redirect_form_id\",\"Redirect To\",\"lookup\",\"\"],[\"nu5bad6cb32737662\",\"sfo_browse_rows_per_page\",\"Rows Per Page\",\"input\",\"number\"],[\"nu5bad6cb327181a4\",\"sfo_browse_row_height\",\"Row Height\",\"input\",\"number\"],[\"nu5bad6cb3278653c\",\"sfo_browse_sql\",\"SQL\",\"textarea\",\"\"],[\"nu5bad6cb3265cea1\",\"sfo_code\",\"Code\",\"input\",\"text\"],[\"nu5bad6cb32680d97\",\"sfo_description\",\"Description\",\"input\",\"text\"],[\"nu5bad6cb32976d5d\",\"sfo_javascript\",\"Javascript\",\"textarea\",\"\"],[\"nu5bad6cb326ddb36\",\"sfo_primary_key\",\"Primary Key\",\"input\",\"nuScroll\"],[\"nu5bad6cb326a4367\",\"sfo_table\",\"Table Name\",\"input\",\"nuScroll\"],[\"nu5bad6cb3263f2a8\",\"sfo_type\",\"Form Type\",\"select\",\"\"]],\"nuformat\":[[\"nu5bad6cb351686ed\",\"currencydecimals\",\" \",\"input\",\"nuScroll\"],[\"nu5bad6cb3513b16c\",\"currencysign\",\" \",\"input\",\"nuScroll\"],[\"nu5bad6cb34fcb8ad\",\"srm_format\",\"Format\",\"input\",\"text\"],[\"nu5bad6cb34fa79c0\",\"srm_type\",\"Input Type\",\"select\",\"text\"]],\"nuformatcurrency\":[],\"nufrlaunch\":[[\"nu5bad6cb35fcf854\",\"fieldlist\",\"list\",\"input\",\"text\"],[\"nu5bad6cb36334ee9\",\"orderby\",\"Order By\",\"select\",\"\"],[\"nu5bad6cb35f2188f\",\"table\",\"Table Data\",\"lookup\",\"nuScroll\"]],\"nuhome\":[[\"nu5bad6cb35cce14b\",\"open_database\",\"Database\",\"input\",\"button\"],[\"nu5bad6cb362370eb\",\"system_update\",\"Update\",\"input\",\"button\"]],\"nulaunchable\":[],\"nulaunchdates\":[[\"nu5bad6cb344b93ac\",\"from_date\",\"Between\",\"input\",\"nuDate\"],[\"nu5bad6cb344dffcc\",\"to_date\",\"And\",\"input\",\"nuDate\"]],\"nulaunchform\":[],\"nunonsystemform\":[],\"nuobject\":[[\"nu5bad6cb34b050a0\",\"ab_event\",\"After Browse\",\"input\",\"button\"],[\"nu5bad6cb35d26e8f\",\"di_sql\",\"SQL Builder\",\"input\",\"button\"],[\"nu5bad6cb35d48819\",\"se_sql\",\"SQL Builder\",\"input\",\"button\"],[\"nu5bad6cb32b5c449\",\"sob_all_access\",\"Access\",\"select\",\"text\"],[\"nu5bad6cb32b263c1\",\"sob_all_align\",\"Align\",\"select\",\"text\"],[\"nu5bad6cb32b06a65\",\"sob_all_cloneable\",\"Cloneable\",\"select\",\"text\"],[\"nu5bad6cb32ae0077\",\"sob_all_height\",\"Height\",\"input\",\"number\"],[\"nu5bad6cb32a1c004\",\"sob_all_id\",\"ID\",\"input\",\"nuScroll\"],[\"nu5bad6cb32a36c23\",\"sob_all_label\",\"Label\",\"input\",\"text\"],[\"nu5bad6cb32a9998f\",\"sob_all_left\",\"Left\",\"input\",\"number\"],[\"nu5bad6cb32a5798c\",\"sob_all_order\",\"Tabbing Order\",\"input\",\"text\"],[\"nu5bad6cb34f64fa1\",\"sob_all_table\",\"Table\",\"input\",\"text\"],[\"nu5bad6cb32a7637b\",\"sob_all_top\",\"Top\",\"input\",\"number\"],[\"nu5bad6cb329fdf13\",\"sob_all_type\",\"Type\",\"select\",\"\"],[\"nu5bad6cb32b417d0\",\"sob_all_validate\",\"Validation\",\"select\",\"text\"],[\"nu5bad6cb32abf6a9\",\"sob_all_width\",\"Width\",\"input\",\"number\"],[\"nu5bad6cb3364460a\",\"sob_all_zzzzsys_form_id\",\"Form ID\",\"input\",\"text\"],[\"nu5bad6cb329dcb6e\",\"sob_all_zzzzsys_tab_id\",\"Form Tab\",\"lookup\",\"\"],[\"nu5bad6cb3502b8ec\",\"sob_calc_format\",\"Format\",\"select\",\"text\"],[\"nu5bad6cb34f4618a\",\"sob_calc_formula\",\"Formula\",\"textarea\",\"text\"],[\"nu5bad6cb32bf6285\",\"sob_display_sql\",\"SQL\",\"textarea\",\"text\"],[\"nu5bad6cb363bb5b7\",\"sob_html_chart_type\",\"Chart Type\",\"select\",\"\"],[\"nu5bad6cb32bd0b0a\",\"sob_html_code\",\"HTML\",\"textarea\",\"text\"],[\"nu5bad6cb36568f2b\",\"sob_html_horizontal_label\",\"Horizontal Label\",\"input\",\"text\"],[\"nu5bad6cb3658e2e6\",\"sob_html_javascript\",\"Javascript Array\",\"input\",\"text\"],[\"nu5bad6cb3647b4cb\",\"sob_html_title\",\"Title\",\"input\",\"text\"],[\"nu5bad6cb364add63\",\"sob_html_vertical_label\",\"Vertical Label\",\"input\",\"text\"],[\"nu5bad6cb3582c2ca\",\"sob_image_zzzzsys_file_id\",\"Image\",\"lookup\",\"\"],[\"nu5bad6cb356dfe23\",\"sob_input_count\",\"Next Number\",\"input\",\"number\"],[\"nu5bad6cb32c708be\",\"sob_input_format\",\"Format\",\"select\",\"text\"],[\"nu5bad6cb34feb6d2\",\"sob_input_javascript\",\"Javascript Array\",\"input\",\"text\"],[\"nu5bad6cb32c4d9de\",\"sob_input_type\",\"Input Type (and class)\",\"select\",\"text\"],[\"nu5bad6cb32e1a66a\",\"sob_lookup_code\",\"Code\",\"input\",\"nuScroll\"],[\"nu5bad6cb32e47d18\",\"sob_lookup_description\",\"Description\",\"input\",\"nuScroll\"],[\"nu5bad6cb32e8733c\",\"sob_lookup_description_width\",\"Width\",\"input\",\"number\"],[\"nu5bad6cb32ec104d\",\"sob_lookup_javascript\",\"Javascript\",\"textarea\",\"text\"],[\"nu5bad6cb34e80d7e\",\"sob_lookup_table\",\"Code\",\"input\",\"text\"],[\"nu5bad6cb32dcbcb4\",\"sob_lookup_zzzzsys_form_id\",\"Form\",\"lookup\",\"\"],[\"nu5bad6cb32d3ef22\",\"sob_run_filter\",\"Filter\",\"input\",\"text\"],[\"nu5bad6cb32d6add9\",\"sob_run_id\",\"Record ID\",\"input\",\"text\"],[\"nu5bad6cb32d8ec39\",\"sob_run_method\",\"Method\",\"select\",\"text\"],[\"nu5bad6cb32d22215\",\"sob_run_zzzzsys_form_id\",\"Run\",\"lookup\",\"\"],[\"nu5bad6cb32c2f35b\",\"sob_select_multiple\",\"Multiple\",\"select\",\"text\"],[\"nu5bad6cb32c14343\",\"sob_select_sql\",\"SQL<br>or<br>List\",\"textarea\",\"text\"],[\"nu5bad6cb32cd0b84\",\"sob_subform_add\",\"Addable\",\"select\",\"text\"],[\"nu5bad6cb32ced09b\",\"sob_subform_delete\",\"Deleteable\",\"select\",\"text\"],[\"nu5bad6cb32cb28dd\",\"sob_subform_foreign_key\",\"Foreign Key\",\"input\",\"nuScroll\"],[\"nu5bad6cb3528f51c\",\"sob_subform_table\",\"Code\",\"input\",\"text\"],[\"nu5bad6cb32d07376\",\"sob_subform_type\",\"Type\",\"select\",\"text\"],[\"nu5bad6cb32c9102c\",\"sob_subform_zzzzsys_form_id\",\"Form\",\"lookup\",\"\"]],\"nupassword\":[[\"nu5bad6cb34a592fd\",\"new_password\",\"Enter New Password\",\"input\",\"password\"],[\"nu5bad6cb34a11c21\",\"new_password_check\",\"Re-Enter New Password\",\"input\",\"password\"],[\"nu5bad6cb34a8d913\",\"old_password\",\"Enter Current Password\",\"input\",\"password\"]],\"nuphp\":[[\"nu5bad6cb33e17c28\",\"sph_code\",\"Code\",\"input\",\"text\"],[\"nu5bad6cb33fe854c\",\"sph_description\",\"Description\",\"input\",\"text\"],[\"nu5bad6cb3452cdfe\",\"sph_group\",\"Group\",\"input\",\"text\"],[\"nu5bad6cb33ed5ffe\",\"sph_php\",\"PHP\",\"textarea\",\"\"],[\"nu5bad6cb341ba4c3\",\"sph_run\",\"Run\",\"select\",\"text\"],[\"nu5bad6cb359524be\",\"sph_system\",\"Group\",\"input\",\"text\"],[\"nu5bad6cb3299aecf\",\"sph_zzzzsys_form_id\",\"Launch from\",\"lookup\",\"\"]],\"nurunlist\":[],\"nurunphp\":[],\"nurunreport\":[],\"nusample\":[[\"nu59e446589adce4d\",\"inputbuttonsample\",\"Run\",\"input\",\"button\"],[\"nu59e446589b4c69b\",\"inputcheckboxsample\",\"Input:checkbox\",\"input\",\"checkbox\"],[\"nu59e446589cf91a2\",\"inputfilesample\",\"Input:file\",\"input\",\"file\"],[\"nu59e446589bce3d7\",\"inputnuautonumbersample\",\"Input:nuAutoNumber\",\"input\",\"nuAutoNumber\"],[\"nu59e446589b0af4c\",\"inputnudatesample\",\"Input:nuDate\",\"input\",\"nuDate\"],[\"nu59e446589af5d86\",\"inputnumbersample\",\"Input:number\",\"input\",\"number\"],[\"nu59e446589b20a14\",\"inputnunumbersample\",\"Input:nuNumber\",\"input\",\"nuNumber\"],[\"nu59e446589b61190\",\"inputnuscrollsample\",\"Input:nuScroll\",\"input\",\"nuScroll\"],[\"nu59e446589a370ca\",\"inputtextsample\",\"Input:text\",\"input\",\"text\"],[\"nu59e446589ab1797\",\"lookupsample\",\"Lookup\",\"lookup\",\"nuScroll\"],[\"nu59e446589a9b145\",\"selectmultiselectsample\",\"Select:multiselect\",\"select\",\"\"],[\"nu59e446589a6400f\",\"selectsample\",\"Select\",\"select\",\"\"],[\"nu59e446589b75a6d\",\"textareasample\",\"Textarea\",\"textarea\",\"nuScroll\"]],\"nusamplesubformform\":[[\"nu5bad6cb361c6536\",\"todo\",\"To Do List\",\"input\",\"text\"]],\"nuselect\":[[\"nu5bad6cb35a52325\",\"addtable\",\"Add Table\",\"select\",\"range\"],[\"nu5bad6cb3599e41f\",\"sse_description\",\"Description\",\"input\",\"text\"],[\"nu5bad6cb35c4c4ab\",\"sse_edit\",\"SQL\",\"select\",\"text\"],[\"nu5bad6cb35beaf10\",\"sse_json\",\"JSON\",\"textarea\",\"text\"],[\"nu5bad6cb35a0a29e\",\"sse_resize\",\"Resize\",\"input\",\"button\"],[\"nu5bad6cb35b51370\",\"sse_sql\",\"SQL\",\"textarea\",\"text\"]],\"nusetup\":[[\"nu5bad6cb347da00e\",\"set_header\",\"Header\",\"textarea\",\"\"],[\"nu5bad6cb35e1d998\",\"set_language\",\"Language\",\"select\",\"\"],[\"nu5bad6cb34724534\",\"set_smtp_from_address\",\"Address\",\"input\",\"text\"],[\"nu5bad6cb3475031f\",\"set_smtp_from_name\",\"From Name\",\"input\",\"text\"],[\"nu5bad6cb34701820\",\"set_smtp_host\",\"Host\",\"input\",\"text\"],[\"nu5bad6cb346df926\",\"set_smtp_password\",\"Password\",\"input\",\"text\"],[\"nu5bad6cb3477c73b\",\"set_smtp_port\",\"Port\",\"input\",\"number\"],[\"nu5bad6cb346a7c3b\",\"set_smtp_username\",\"User Name\",\"input\",\"text\"],[\"nu5bad6cb346642c0\",\"set_smtp_use_authentication\",\"Use Authentication\",\"select\",\"\"],[\"nu5bad6cb345bcd24\",\"set_zzzzsys_timezone_id\",\"Time Zone\",\"lookup\",\"\"]],\"nutab\":[[\"nu5bad6cb362c74c4\",\"syt_help\",\"Help\",\"input\",\"text\"],[\"nu5bad6cb328f889b\",\"syt_order\",\"Order\",\"input\",\"number\"],[\"nu5bad6cb328dde63\",\"syt_title\",\"Title\",\"input\",\"text\"]],\"nutablookup\":[],\"nutimezone\":[],\"nutranslate\":[[\"nu5bad6cb3498f4e8\",\"trl_english\",\"English\",\"input\",\"text\"],[\"nu5bad6cb3482a7d5\",\"trl_language\",\"Language\",\"input\",\"nuScroll\"],[\"nu5bad6cb349c926f\",\"trl_translation\",\"Translation\",\"input\",\"text\"]],\"nuuser\":[[\"nu5bad6cb33d2481a\",\"check_password\",\"Reenter New Password\",\"input\",\"password\"],[\"nu5bad6cb33b84bf4\",\"new_password\",\"Enter New Password\",\"input\",\"password\"],[\"nu5bad6cb33b1013c\",\"sus_email\",\"Email\",\"input\",\"text\"],[\"nu5bad6cb3462cd79\",\"sus_language\",\"Language\",\"select\",\"\"],[\"nu5bad6cb33b42890\",\"sus_login_name\",\"Login Name\",\"input\",\"text\"],[\"nu5bad6cb33ad88b7\",\"sus_name\",\"Name\",\"input\",\"text\"],[\"nu5bad6cb33d99a4b\",\"sus_zzzzsys_access_id\",\"Access Level\",\"lookup\",\"text\"]],\"nuuserhome\":[]},\"5c3bf2062ed8ca0\":\"valid\"}',1547432454),('s15474324626855','{\"session\":{\"zzzzsys_access_id\":\"\",\"zzzzsys_user_id\":\"globeadmin\",\"zzzzsys_form_id\":\"nuhome\",\"global_access\":\"1\"},\"forms\":[[\"nuaccess\"],[\"nuaccessforms\"],[\"nuaccessgroup\"],[\"nuaccesslevelreport\"],[\"nuaccessreport\"],[\"nublank\"],[\"nubrowse\"],[\"nubuildreport\"],[\"nubuildtable\"],[\"nucalcobjects\"],[\"nuclause\"],[\"nudebug\"],[\"nuevent\"],[\"nufastformobjects\"],[\"nufastreportobjects\"],[\"nufflaunch\"],[\"nufile\"],[\"nuform\"],[\"nuformat\"],[\"nuformatcurrency\"],[\"nufrlaunch\"],[\"nuhome\"],[\"nulaunchable\"],[\"nulaunchdates\"],[\"nulaunchform\"],[\"nunonsystemform\"],[\"nuobject\"],[\"nupassword\"],[\"nuphp\"],[\"nurunlist\"],[\"nurunphp\"],[\"nurunreport\"],[\"nusample\"],[\"nusamplesubformform\"],[\"nuselect\"],[\"nusetup\"],[\"nutab\"],[\"nutablookup\"],[\"nutimezone\"],[\"nutranslate\"],[\"nuuser\"],[\"nuuserhome\"]],\"reports\":[[\"5bc68a6c08986e0\",\"nublank\"],[\"5bc68f8fd43b779\",\"nublank\"],[\"5bd1137a601c5bb\",\"nublank\"]],\"procedures\":[[\"nuform_BS\",\"\"],[\"nuphp_BS\",\"\"],[\"nupassword_BS\",\"\"],[\"nudebug_BE\",\"\"],[\"nuuser_AS\",\"\"],[\"nurunlist_BB\",\"\"],[\"nudebug_BD\",\"\"],[\"nuobject_BS\",\"\"],[\"nuform_AS\",\"\"],[\"nucalcobjects_BB\",\"\"],[\"nuform_AD\",\"\"],[\"nufastform\",\"nufflaunch\"],[\"nuobject_BB\",\"\"],[\"nuform_BB\",\"\"],[\"nuphp_BB\",\"\"],[\"nuselect_BS\",\"\"],[\"nuphp_BE\",\"\"],[\"nutranslate_AS\",\"\"],[\"nuaccessreport_BB\",\"\"],[\"nutranslate_BE\",\"\"],[\"nuhome_BE\",\"\"],[\"nuphp_AD\",\"\"],[\"nuform_BE\",\"\"],[\"nuupdatesystemids\",\"nublank\"],[\"nu5bad6cb329dcb6e_AB\",\"\"],[\"nu5bad6cb32c9102c_AB\",\"\"],[\"nu5bad6cb32dcbcb4_AB\",\"\"],[\"nu5bad6cb33715015_AB\",\"\"],[\"nuaccess_AD\",\"\"],[\"nuaccessreport_AD\",\"\"],[\"nuaccess_BE\",\"\"],[\"\",\"\"],[\"nuaccessforms_AD\",\"\"],[\"nuaccess_AS\",\"\"],[\"nuaccess_BB\",\"\"],[\"nuaccess_BD\",\"\"],[\"nu5bad6cb32600c97_AB\",\"\"],[\"nu5bad6cb35f2188f_AB\",\"\"],[\"nufastreport\",\"nufflaunch\"],[\"nuobject_BE\",\"\"],[\"nuaccessforms_BE\",\"\"],[\"nupassword_BE\",\"\"],[\"nudebug_BS\",\"\"],[\"nudebug_AS\",\"\"],[\"nudebug_BB\",\"\"],[\"nudebug_AD\",\"\"],[\"nutab_BB\",\"\"],[\"nutablookup_BB\",\"\"],[\"nuuser_BS\",\"\"],[\"5bd1116f5bb7571\",\"nublank\"]],\"access_level_code\":\"\",\"nufirsttime\":\"non\",\"clientTableSchema\":{\"zzzzsys_access\":{\"names\":[\"zzzzsys_access_id\",\"sal_code\",\"sal_description\",\"sal_zzzzsys_form_id\"],\"types\":[\"varchar(25)\",\"varchar(50)\",\"varchar(200)\",\"varchar(25)\"],\"primary_key\":[\"zzzzsys_access_id\"],\"valid\":1},\"zzzzsys_access_form\":{\"names\":[\"zzzzsys_access_form_id\",\"slf_zzzzsys_access_id\",\"slf_zzzzsys_form_id\",\"slf_add_button\",\"slf_save_button\",\"slf_delete_button\",\"slf_clone_button\",\"slf_new_button\",\"slf_print_button\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(25)\",\"varchar(1)\",\"varchar(1)\",\"varchar(1)\",\"varchar(1)\",\"varchar(1)\",\"varchar(1)\"],\"primary_key\":[\"zzzzsys_access_form_id\"],\"valid\":1},\"zzzzsys_access_php\":{\"names\":[\"zzzzsys_access_php_id\",\"slp_zzzzsys_access_id\",\"slp_zzzzsys_php_id\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(25)\"],\"primary_key\":[\"zzzzsys_access_php_id\"],\"valid\":1},\"zzzzsys_access_report\":{\"names\":[\"zzzzsys_access_report_id\",\"sre_zzzzsys_access_id\",\"sre_zzzzsys_report_id\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(25)\"],\"primary_key\":[\"zzzzsys_access_report_id\"],\"valid\":1},\"zzzzsys_browse\":{\"names\":[\"zzzzsys_browse_id\",\"sbr_zzzzsys_form_id\",\"sbr_title\",\"sbr_display\",\"sbr_align\",\"sbr_format\",\"sbr_order\",\"sbr_width\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(100)\",\"varchar(512)\",\"char(1)\",\"varchar(300)\",\"int(11)\",\"int(11)\"],\"primary_key\":[\"zzzzsys_browse_id\"],\"valid\":1},\"zzzzsys_debug\":{\"names\":[\"zzzzsys_debug_id\",\"deb_message\",\"deb_added\"],\"types\":[\"varchar(25)\",\"longtext\",\"int(11)\"],\"primary_key\":[\"zzzzsys_debug_id\"],\"valid\":1},\"zzzzsys_event\":{\"names\":[\"zzzzsys_event_id\",\"sev_zzzzsys_object_id\",\"sev_event\",\"sev_javascript\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(100)\",\"varchar(3000)\"],\"primary_key\":[\"zzzzsys_event_id\"],\"valid\":1},\"zzzzsys_file\":{\"names\":[\"zzzzsys_file_id\",\"sfi_code\",\"sfi_description\",\"sfi_group\",\"sfi_json\",\"sfi_system\"],\"types\":[\"varchar(25)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"longtext\",\"char(1)\"],\"primary_key\":[\"zzzzsys_file_id\"],\"valid\":1},\"zzzzsys_form\":{\"names\":[\"zzzzsys_form_id\",\"sfo_type\",\"sfo_code\",\"sfo_description\",\"sfo_table\",\"sfo_primary_key\",\"sfo_browse_redirect_form_id\",\"sfo_browse_row_height\",\"sfo_browse_rows_per_page\",\"sfo_browse_sql\",\"sfo_javascript\"],\"types\":[\"varchar(25)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"int(11)\",\"int(11)\",\"text\",\"longtext\"],\"primary_key\":[\"zzzzsys_form_id\"],\"valid\":1},\"zzzzsys_format\":{\"names\":[\"zzzzsys_format_id\",\"srm_type\",\"srm_format\"],\"types\":[\"varchar(25)\",\"varchar(10)\",\"varchar(300)\"],\"primary_key\":[\"zzzzsys_format_id\"],\"valid\":1},\"zzzzsys_object\":{\"names\":[\"zzzzsys_object_id\",\"sob_all_zzzzsys_form_id\",\"sob_all_table\",\"sob_all_type\",\"sob_all_id\",\"sob_all_label\",\"sob_all_zzzzsys_tab_id\",\"sob_all_order\",\"sob_all_top\",\"sob_all_left\",\"sob_all_width\",\"sob_all_height\",\"sob_all_cloneable\",\"sob_all_align\",\"sob_all_validate\",\"sob_all_access\",\"sob_calc_formula\",\"sob_calc_format\",\"sob_run_zzzzsys_form_id\",\"sob_run_filter\",\"sob_run_method\",\"sob_run_id\",\"sob_display_sql\",\"sob_select_multiple\",\"sob_select_sql\",\"sob_lookup_code\",\"sob_lookup_description\",\"sob_lookup_description_width\",\"sob_lookup_autocomplete\",\"sob_lookup_zzzzsys_form_id\",\"sob_lookup_javascript\",\"sob_lookup_php\",\"sob_lookup_table\",\"sob_subform_zzzzsys_form_id\",\"sob_subform_foreign_key\",\"sob_subform_add\",\"sob_subform_delete\",\"sob_subform_type\",\"sob_subform_table\",\"sob_input_count\",\"sob_input_format\",\"sob_input_type\",\"sob_input_javascript\",\"sob_html_code\",\"sob_html_chart_type\",\"sob_html_javascript\",\"sob_html_title\",\"sob_html_vertical_label\",\"sob_html_horizontal_label\",\"sob_image_zzzzsys_file_id\"],\"types\":[\"varchar(25)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(1000)\",\"varchar(300)\",\"int(11)\",\"int(11)\",\"int(11)\",\"int(11)\",\"int(11)\",\"varchar(300)\",\"varchar(10)\",\"varchar(1)\",\"varchar(1)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(1)\",\"varchar(300)\",\"text\",\"varchar(300)\",\"text\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"text\",\"varchar(25)\",\"varchar(500)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"varchar(300)\",\"bigint(20)\",\"varchar(300)\",\"varchar(300)\",\"text\",\"text\",\"varchar(1000)\",\"varchar(1000)\",\"varchar(1000)\",\"varchar(1000)\",\"varchar(1000)\",\"varchar(25)\"],\"primary_key\":[\"zzzzsys_object_id\"],\"valid\":1},\"zzzzsys_php\":{\"names\":[\"zzzzsys_php_id\",\"sph_code\",\"sph_description\",\"sph_group\",\"sph_php\",\"sph_run\",\"sph_zzzzsys_form_id\",\"sph_system\",\"sph_hide\"],\"types\":[\"varchar(25)\",\"varchar(300)\",\"varchar(300)\",\"varchar(100)\",\"longtext\",\"varchar(20)\",\"varchar(25)\",\"varchar(1)\",\"varchar(1)\"],\"primary_key\":[\"zzzzsys_php_id\"],\"valid\":1},\"zzzzsys_report\":{\"names\":[\"zzzzsys_report_id\",\"sre_code\",\"sre_description\",\"sre_group\",\"sre_zzzzsys_php_id\",\"sre_zzzzsys_form_id\",\"sre_layout\"],\"types\":[\"varchar(25)\",\"varchar(300)\",\"varchar(300)\",\"varchar(100)\",\"varchar(25)\",\"varchar(25)\",\"longtext\"],\"primary_key\":[\"zzzzsys_report_id\"],\"valid\":1},\"zzzzsys_report_data\":{\"names\":[\"id\",\"code\",\"description\"],\"types\":[\"varchar(306)\",\"varchar(300)\",\"varchar(300)\"],\"primary_key\":[],\"valid\":1},\"zzzzsys_run_list\":{\"names\":[\"id\",\"run\",\"code\",\"description\"],\"types\":[\"varchar(25)\",\"varchar(9)\",\"varchar(300)\",\"varchar(300)\"],\"primary_key\":[],\"valid\":1},\"zzzzsys_select\":{\"names\":[\"zzzzsys_select_id\",\"sse_description\",\"sse_json\",\"sse_sql\",\"sse_edit\",\"sse_system\"],\"types\":[\"varchar(25)\",\"varchar(300)\",\"mediumtext\",\"mediumtext\",\"varchar(1)\",\"varchar(1)\"],\"primary_key\":[\"zzzzsys_select_id\"],\"valid\":1},\"zzzzsys_select_clause\":{\"names\":[\"zzzzsys_select_clause_id\",\"ssc_zzzzsys_select_id\",\"ssc_type\",\"ssc_field\",\"ssc_clause\",\"ssc_sort\",\"ssc_order\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(300)\",\"varchar(500)\",\"varchar(500)\",\"varchar(10)\",\"varchar(500)\"],\"primary_key\":[\"zzzzsys_select_clause_id\"],\"valid\":1},\"zzzzsys_session\":{\"names\":[\"zzzzsys_session_id\",\"sss_access\",\"sss_time\"],\"types\":[\"varchar(25)\",\"mediumtext\",\"int(11)\"],\"primary_key\":[\"zzzzsys_session_id\"],\"valid\":1},\"zzzzsys_setup\":{\"names\":[\"zzzzsys_setup_id\",\"set_time_out_minutes\",\"set_zzzzsys_timezone_id\",\"set_language\",\"set_smtp_username\",\"set_smtp_password\",\"set_smtp_host\",\"set_smtp_from_address\",\"set_smtp_from_name\",\"set_smtp_port\",\"set_smtp_use_authentication\",\"set_header\",\"set_denied\"],\"types\":[\"varchar(25)\",\"int(11)\",\"varchar(25)\",\"varchar(20)\",\"varchar(255)\",\"varchar(255)\",\"varchar(255)\",\"varchar(255)\",\"varchar(255)\",\"int(4)\",\"varchar(1)\",\"longtext\",\"varchar(1)\"],\"primary_key\":[\"zzzzsys_setup_id\"],\"valid\":1},\"zzzzsys_tab\":{\"names\":[\"zzzzsys_tab_id\",\"syt_zzzzsys_form_id\",\"syt_title\",\"syt_order\",\"syt_help\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(250)\",\"int(11)\",\"varchar(3000)\"],\"primary_key\":[\"zzzzsys_tab_id\"],\"valid\":1},\"zzzzsys_table\":{\"names\":[\"zzzzsys_table_id\"],\"types\":[\"varchar(300)\"],\"primary_key\":[],\"valid\":1},\"zzzzsys_timezone\":{\"names\":[\"zzzzsys_timezone_id\",\"stz_timezone\"],\"types\":[\"varchar(25)\",\"mediumtext\"],\"primary_key\":[\"zzzzsys_timezone_id\"],\"valid\":1},\"zzzzsys_translate\":{\"names\":[\"zzzzsys_translate_id\",\"trl_language\",\"trl_english\",\"trl_translation\"],\"types\":[\"varchar(25)\",\"varchar(20)\",\"varchar(500)\",\"varchar(500)\"],\"primary_key\":[\"zzzzsys_translate_id\"],\"valid\":1},\"zzzzsys_user\":{\"names\":[\"zzzzsys_user_id\",\"sus_zzzzsys_access_id\",\"sus_language\",\"sus_name\",\"sus_email\",\"sus_login_name\",\"sus_login_password\"],\"types\":[\"varchar(25)\",\"varchar(25)\",\"varchar(20)\",\"varchar(50)\",\"varchar(255)\",\"varchar(20)\",\"varchar(300)\"],\"primary_key\":[\"zzzzsys_user_id\"],\"valid\":1}},\"clientFormSchema\":{\"nuaccess\":[[\"nu5bad6cb336a9f96\",\"sal_code\",\"Code\",\"input\",\"text\"],[\"nu5bd10c9148543a6\",\"sal_description\",\"Description\",\"input\",\"text\"],[\"nu5bad6cb3351b6a4\",\"sal_zzzzsys_form_id\",\"Home\",\"lookup\",\"\"]],\"nuaccessforms\":[[\"nu5bad6cb337ab8d0\",\"slf_add_button\",\"<br>  <span class=\'nuActionButton\'>Add<\\/span>\",\"input\",\"checkbox\"],[\"nu5bad6cb3399c9cf\",\"slf_clone_button\",\"<br> <span class=\'nuActionButton\'>Clone<\\/span>\",\"input\",\"checkbox\"],[\"nu5bad6cb338c7612\",\"slf_delete_button\",\"<br> <span class=\'nuActionButton\'>Delete<\\/span>\",\"input\",\"checkbox\"],[\"nu5bad6cb33a4e07f\",\"slf_print_button\",\"<br> <span class=\'nuActionButton\'>Print<\\/span>\",\"input\",\"checkbox\"],[\"nu5bad6cb338330bb\",\"slf_save_button\",\"<br> <span class=\'nuActionButton\'>Save<\\/span>\",\"input\",\"checkbox\"],[\"nu5bad6cb33715015\",\"slf_zzzzsys_form_id\",\"Form\",\"lookup\",\"\"]],\"nuaccessgroup\":[[\"nu5bad6cb34130517\",\"gal_zzzzsys_access_id\",\"Access To..\",\"lookup\",\"\"]],\"nuaccesslevelreport\":[[\"nu5bad6cb342de027\",\"sre_zzzzsys_report_id\",\"Report\",\"lookup\",\"\"]],\"nuaccessreport\":[[\"nu5bad6cb341fdfc3\",\"slp_zzzzsys_php_id\",\"Procedure\",\"lookup\",\"\"]],\"nublank\":[],\"nubrowse\":[[\"nu5bad6cb328350f1\",\"sbr_align\",\"Align\",\"select\",\"text\"],[\"nu5bad6cb327ee8dc\",\"sbr_display\",\"Display\",\"input\",\"nuScroll\"],[\"nu5bad6cb32856f55\",\"sbr_format\",\"Format\",\"select\",\"text\"],[\"nu5bad6cb3289c6f6\",\"sbr_order\",\"Order\",\"input\",\"number\"],[\"nu5bad6cb327ca554\",\"sbr_title\",\"Title\",\"input\",\"text\"],[\"nu5bad6cb328796fe\",\"sbr_width\",\"Width\",\"input\",\"number\"]],\"nubuildreport\":[[\"nu5bad6cb32930450\",\"open_builder\",\"Report Designer\",\"input\",\"button\"],[\"nu5bad6cb3670b7db\",\"open_sql\",\"Open\",\"input\",\"button\"],[\"nu5bad6cb340c5469\",\"sre_code\",\"Code\",\"input\",\"text\"],[\"nu5bad6cb340fb412\",\"sre_description\",\"Description\",\"input\",\"text\"],[\"nu5bad6cb343a3176\",\"sre_group\",\"Group\",\"input\",\"text\"],[\"nu5bad6cb3295b165\",\"sre_layout\",\"Layout\",\"textarea\",\"\"],[\"nu5bad6cb3400c80a\",\"sre_zzzzsys_form_id\",\"Launch From\",\"lookup\",\"\"],[\"nu5bad6cb345094c6\",\"sre_zzzzsys_php_id\",\"Table\",\"lookup\",\"\"]],\"nubuildtable\":[],\"nucalcobjects\":[],\"nuclause\":[[\"nu5bad6cb35ad7f0a\",\"ssc_clause\",\"Clause\",\"input\",\"text\"],[\"nu5bad6cb35afa1d0\",\"ssc_field\",\"Field\",\"input\",\"nuScroll\"],[\"nu5bad6cb35a8885a\",\"ssc_order\",\"Order\",\"input\",\"number\"],[\"nu5bad6cb35b860e2\",\"ssc_sort\",\"Sort\",\"select\",\"number\"],[\"nu5bad6cb35ab1f0a\",\"ssc_type\",\"Type\",\"select\",\"number\"]],\"nudebug\":[[\"nu5bad6cb35977ed6\",\"deb_added\",\" \",\"input\",\"text\"],[\"nu5bad6cb3416c803\",\"deb_message\",\" \",\"textarea\",\"\"]],\"nuevent\":[[\"nu5bad6cb331a6d3e\",\"sev_event\",\"Event\",\"input\",\"nuScroll\"],[\"nu5bad6cb3316ef87\",\"sev_javascript\",\"Javascript\",\"input\",\"text\"]],\"nufastformobjects\":[[\"nu5bad6cb35d6b273\",\"ff_browse\",\"Browse<br>Column\",\"input\",\"checkbox\"],[\"nu5bad6cb34ebf5bd\",\"ff_field\",\"Field Name\",\"input\",\"nuScroll\"],[\"nu5bad6cb35304ffd\",\"ff_id\",\" \",\"input\",\"text\"],[\"nu5bad6cb34ee220e\",\"ff_label\",\" Label\",\"input\",\"text\"]],\"nufastreportobjects\":[[\"nu5bad6cb3618939f\",\"field\",\"Field Name\",\"input\",\"text\"],[\"nu5bad6cb3608c14b\",\"sum\",\"Sum\",\"input\",\"checkbox\"],[\"nu5bad6cb3604269d\",\"title\",\"Title\",\"input\",\"text\"],[\"nu5bad6cb35f5d25f\",\"width\",\"Width\",\"input\",\"number\"]],\"nufflaunch\":[[\"nu5bad6cb366e865e\",\"fastform_fk\",\"Foreign Key Field Name\",\"input\",\"text\"],[\"nu5bad6cb352dce42\",\"fastform_table\",\"Table Name\",\"input\",\"nuScroll\"],[\"nu5bad6cb35dadfc5\",\"fastform_type\",\"Form Type\",\"select\",\"\"],[\"nu5bad6cb3532d677\",\"new_id\",\"New ID\",\"input\",\"text\"],[\"nu5bad6cb3568c736\",\"run_sam\",\"?\",\"input\",\"button\"]],\"nufile\":[[\"nu5bad6cb35724861\",\"sfi_code\",\"Code\",\"input\",\"text\"],[\"nu5bad6cb3574909c\",\"sfi_description\",\"Description\",\"input\",\"text\"],[\"nu5bad6cb357ff16d\",\"sfi_group\",\"Group\",\"input\",\"text\"],[\"nu5bad6cb35d8ed3e\",\"sfi_json\",\"Upload File \",\"textarea\",\"file\"],[\"nu5bad6cb35772a8c\",\"sfi_json_file\",\"Upload File \",\"input\",\"file\"]],\"nuform\":[[\"nu5bad6cb34e2eaec\",\"ad_event\",\"After Delete\",\"input\",\"button\"],[\"nu5bad6cb34d23de5\",\"as_event\",\"After Save\",\"input\",\"button\"],[\"nu5bad6cb329136ba\",\"bb_event\",\"Before Browse\",\"input\",\"button\"],[\"nu5bad6cb34d7e1db\",\"bd_event\",\"Before Delete\",\"input\",\"button\"],[\"nu5bad6cb34c005d7\",\"be_event\",\"Before Edit\",\"input\",\"button\"],[\"nu5bad6cb35cf61c0\",\"br_sql\",\"SQL Builder\",\"input\",\"button\"],[\"nu5bad6cb34c4775c\",\"bs_event\",\"Before Save\",\"input\",\"button\"],[\"nu5bad6cb3518a9c0\",\"previewbrowse\",\"Preview Browse Form\",\"input\",\"button\"],[\"nu5bad6cb34e5cc53\",\"previewedit\",\"Preview Edit Form\",\"input\",\"button\"],[\"nu5bad6cb3275e50e\",\"sfo_browse_redirect_form_id\",\"Redirect To\",\"lookup\",\"\"],[\"nu5bad6cb32737662\",\"sfo_browse_rows_per_page\",\"Rows Per Page\",\"input\",\"number\"],[\"nu5bad6cb327181a4\",\"sfo_browse_row_height\",\"Row Height\",\"input\",\"number\"],[\"nu5bad6cb3278653c\",\"sfo_browse_sql\",\"SQL\",\"textarea\",\"\"],[\"nu5bad6cb3265cea1\",\"sfo_code\",\"Code\",\"input\",\"text\"],[\"nu5bad6cb32680d97\",\"sfo_description\",\"Description\",\"input\",\"text\"],[\"nu5bad6cb32976d5d\",\"sfo_javascript\",\"Javascript\",\"textarea\",\"\"],[\"nu5bad6cb326ddb36\",\"sfo_primary_key\",\"Primary Key\",\"input\",\"nuScroll\"],[\"nu5bad6cb326a4367\",\"sfo_table\",\"Table Name\",\"input\",\"nuScroll\"],[\"nu5bad6cb3263f2a8\",\"sfo_type\",\"Form Type\",\"select\",\"\"]],\"nuformat\":[[\"nu5bad6cb351686ed\",\"currencydecimals\",\" \",\"input\",\"nuScroll\"],[\"nu5bad6cb3513b16c\",\"currencysign\",\" \",\"input\",\"nuScroll\"],[\"nu5bad6cb34fcb8ad\",\"srm_format\",\"Format\",\"input\",\"text\"],[\"nu5bad6cb34fa79c0\",\"srm_type\",\"Input Type\",\"select\",\"text\"]],\"nuformatcurrency\":[],\"nufrlaunch\":[[\"nu5bad6cb35fcf854\",\"fieldlist\",\"list\",\"input\",\"text\"],[\"nu5bad6cb36334ee9\",\"orderby\",\"Order By\",\"select\",\"\"],[\"nu5bad6cb35f2188f\",\"table\",\"Table Data\",\"lookup\",\"nuScroll\"]],\"nuhome\":[[\"nu5bad6cb35cce14b\",\"open_database\",\"Database\",\"input\",\"button\"],[\"nu5bad6cb362370eb\",\"system_update\",\"Update\",\"input\",\"button\"]],\"nulaunchable\":[],\"nulaunchdates\":[[\"nu5bad6cb344b93ac\",\"from_date\",\"Between\",\"input\",\"nuDate\"],[\"nu5bad6cb344dffcc\",\"to_date\",\"And\",\"input\",\"nuDate\"]],\"nulaunchform\":[],\"nunonsystemform\":[],\"nuobject\":[[\"nu5bad6cb34b050a0\",\"ab_event\",\"After Browse\",\"input\",\"button\"],[\"nu5bad6cb35d26e8f\",\"di_sql\",\"SQL Builder\",\"input\",\"button\"],[\"nu5bad6cb35d48819\",\"se_sql\",\"SQL Builder\",\"input\",\"button\"],[\"nu5bad6cb32b5c449\",\"sob_all_access\",\"Access\",\"select\",\"text\"],[\"nu5bad6cb32b263c1\",\"sob_all_align\",\"Align\",\"select\",\"text\"],[\"nu5bad6cb32b06a65\",\"sob_all_cloneable\",\"Cloneable\",\"select\",\"text\"],[\"nu5bad6cb32ae0077\",\"sob_all_height\",\"Height\",\"input\",\"number\"],[\"nu5bad6cb32a1c004\",\"sob_all_id\",\"ID\",\"input\",\"nuScroll\"],[\"nu5bad6cb32a36c23\",\"sob_all_label\",\"Label\",\"input\",\"text\"],[\"nu5bad6cb32a9998f\",\"sob_all_left\",\"Left\",\"input\",\"number\"],[\"nu5bad6cb32a5798c\",\"sob_all_order\",\"Tabbing Order\",\"input\",\"text\"],[\"nu5bad6cb34f64fa1\",\"sob_all_table\",\"Table\",\"input\",\"text\"],[\"nu5bad6cb32a7637b\",\"sob_all_top\",\"Top\",\"input\",\"number\"],[\"nu5bad6cb329fdf13\",\"sob_all_type\",\"Type\",\"select\",\"\"],[\"nu5bad6cb32b417d0\",\"sob_all_validate\",\"Validation\",\"select\",\"text\"],[\"nu5bad6cb32abf6a9\",\"sob_all_width\",\"Width\",\"input\",\"number\"],[\"nu5bad6cb3364460a\",\"sob_all_zzzzsys_form_id\",\"Form ID\",\"input\",\"text\"],[\"nu5bad6cb329dcb6e\",\"sob_all_zzzzsys_tab_id\",\"Form Tab\",\"lookup\",\"\"],[\"nu5bad6cb3502b8ec\",\"sob_calc_format\",\"Format\",\"select\",\"text\"],[\"nu5bad6cb34f4618a\",\"sob_calc_formula\",\"Formula\",\"textarea\",\"text\"],[\"nu5bad6cb32bf6285\",\"sob_display_sql\",\"SQL\",\"textarea\",\"text\"],[\"nu5bad6cb363bb5b7\",\"sob_html_chart_type\",\"Chart Type\",\"select\",\"\"],[\"nu5bad6cb32bd0b0a\",\"sob_html_code\",\"HTML\",\"textarea\",\"text\"],[\"nu5bad6cb36568f2b\",\"sob_html_horizontal_label\",\"Horizontal Label\",\"input\",\"text\"],[\"nu5bad6cb3658e2e6\",\"sob_html_javascript\",\"Javascript Array\",\"input\",\"text\"],[\"nu5bad6cb3647b4cb\",\"sob_html_title\",\"Title\",\"input\",\"text\"],[\"nu5bad6cb364add63\",\"sob_html_vertical_label\",\"Vertical Label\",\"input\",\"text\"],[\"nu5bad6cb3582c2ca\",\"sob_image_zzzzsys_file_id\",\"Image\",\"lookup\",\"\"],[\"nu5bad6cb356dfe23\",\"sob_input_count\",\"Next Number\",\"input\",\"number\"],[\"nu5bad6cb32c708be\",\"sob_input_format\",\"Format\",\"select\",\"text\"],[\"nu5bad6cb34feb6d2\",\"sob_input_javascript\",\"Javascript Array\",\"input\",\"text\"],[\"nu5bad6cb32c4d9de\",\"sob_input_type\",\"Input Type (and class)\",\"select\",\"text\"],[\"nu5bad6cb32e1a66a\",\"sob_lookup_code\",\"Code\",\"input\",\"nuScroll\"],[\"nu5bad6cb32e47d18\",\"sob_lookup_description\",\"Description\",\"input\",\"nuScroll\"],[\"nu5bad6cb32e8733c\",\"sob_lookup_description_width\",\"Width\",\"input\",\"number\"],[\"nu5bad6cb32ec104d\",\"sob_lookup_javascript\",\"Javascript\",\"textarea\",\"text\"],[\"nu5bad6cb34e80d7e\",\"sob_lookup_table\",\"Code\",\"input\",\"text\"],[\"nu5bad6cb32dcbcb4\",\"sob_lookup_zzzzsys_form_id\",\"Form\",\"lookup\",\"\"],[\"nu5bad6cb32d3ef22\",\"sob_run_filter\",\"Filter\",\"input\",\"text\"],[\"nu5bad6cb32d6add9\",\"sob_run_id\",\"Record ID\",\"input\",\"text\"],[\"nu5bad6cb32d8ec39\",\"sob_run_method\",\"Method\",\"select\",\"text\"],[\"nu5bad6cb32d22215\",\"sob_run_zzzzsys_form_id\",\"Run\",\"lookup\",\"\"],[\"nu5bad6cb32c2f35b\",\"sob_select_multiple\",\"Multiple\",\"select\",\"text\"],[\"nu5bad6cb32c14343\",\"sob_select_sql\",\"SQL<br>or<br>List\",\"textarea\",\"text\"],[\"nu5bad6cb32cd0b84\",\"sob_subform_add\",\"Addable\",\"select\",\"text\"],[\"nu5bad6cb32ced09b\",\"sob_subform_delete\",\"Deleteable\",\"select\",\"text\"],[\"nu5bad6cb32cb28dd\",\"sob_subform_foreign_key\",\"Foreign Key\",\"input\",\"nuScroll\"],[\"nu5bad6cb3528f51c\",\"sob_subform_table\",\"Code\",\"input\",\"text\"],[\"nu5bad6cb32d07376\",\"sob_subform_type\",\"Type\",\"select\",\"text\"],[\"nu5bad6cb32c9102c\",\"sob_subform_zzzzsys_form_id\",\"Form\",\"lookup\",\"\"]],\"nupassword\":[[\"nu5bad6cb34a592fd\",\"new_password\",\"Enter New Password\",\"input\",\"password\"],[\"nu5bad6cb34a11c21\",\"new_password_check\",\"Re-Enter New Password\",\"input\",\"password\"],[\"nu5bad6cb34a8d913\",\"old_password\",\"Enter Current Password\",\"input\",\"password\"]],\"nuphp\":[[\"nu5bad6cb33e17c28\",\"sph_code\",\"Code\",\"input\",\"text\"],[\"nu5bad6cb33fe854c\",\"sph_description\",\"Description\",\"input\",\"text\"],[\"nu5bad6cb3452cdfe\",\"sph_group\",\"Group\",\"input\",\"text\"],[\"nu5bad6cb33ed5ffe\",\"sph_php\",\"PHP\",\"textarea\",\"\"],[\"nu5bad6cb341ba4c3\",\"sph_run\",\"Run\",\"select\",\"text\"],[\"nu5bad6cb359524be\",\"sph_system\",\"Group\",\"input\",\"text\"],[\"nu5bad6cb3299aecf\",\"sph_zzzzsys_form_id\",\"Launch from\",\"lookup\",\"\"]],\"nurunlist\":[],\"nurunphp\":[],\"nurunreport\":[],\"nusample\":[[\"nu59e446589adce4d\",\"inputbuttonsample\",\"Run\",\"input\",\"button\"],[\"nu59e446589b4c69b\",\"inputcheckboxsample\",\"Input:checkbox\",\"input\",\"checkbox\"],[\"nu59e446589cf91a2\",\"inputfilesample\",\"Input:file\",\"input\",\"file\"],[\"nu59e446589bce3d7\",\"inputnuautonumbersample\",\"Input:nuAutoNumber\",\"input\",\"nuAutoNumber\"],[\"nu59e446589b0af4c\",\"inputnudatesample\",\"Input:nuDate\",\"input\",\"nuDate\"],[\"nu59e446589af5d86\",\"inputnumbersample\",\"Input:number\",\"input\",\"number\"],[\"nu59e446589b20a14\",\"inputnunumbersample\",\"Input:nuNumber\",\"input\",\"nuNumber\"],[\"nu59e446589b61190\",\"inputnuscrollsample\",\"Input:nuScroll\",\"input\",\"nuScroll\"],[\"nu59e446589a370ca\",\"inputtextsample\",\"Input:text\",\"input\",\"text\"],[\"nu59e446589ab1797\",\"lookupsample\",\"Lookup\",\"lookup\",\"nuScroll\"],[\"nu59e446589a9b145\",\"selectmultiselectsample\",\"Select:multiselect\",\"select\",\"\"],[\"nu59e446589a6400f\",\"selectsample\",\"Select\",\"select\",\"\"],[\"nu59e446589b75a6d\",\"textareasample\",\"Textarea\",\"textarea\",\"nuScroll\"]],\"nusamplesubformform\":[[\"nu5bad6cb361c6536\",\"todo\",\"To Do List\",\"input\",\"text\"]],\"nuselect\":[[\"nu5bad6cb35a52325\",\"addtable\",\"Add Table\",\"select\",\"range\"],[\"nu5bad6cb3599e41f\",\"sse_description\",\"Description\",\"input\",\"text\"],[\"nu5bad6cb35c4c4ab\",\"sse_edit\",\"SQL\",\"select\",\"text\"],[\"nu5bad6cb35beaf10\",\"sse_json\",\"JSON\",\"textarea\",\"text\"],[\"nu5bad6cb35a0a29e\",\"sse_resize\",\"Resize\",\"input\",\"button\"],[\"nu5bad6cb35b51370\",\"sse_sql\",\"SQL\",\"textarea\",\"text\"]],\"nusetup\":[[\"nu5bad6cb347da00e\",\"set_header\",\"Header\",\"textarea\",\"\"],[\"nu5bad6cb35e1d998\",\"set_language\",\"Language\",\"select\",\"\"],[\"nu5bad6cb34724534\",\"set_smtp_from_address\",\"Address\",\"input\",\"text\"],[\"nu5bad6cb3475031f\",\"set_smtp_from_name\",\"From Name\",\"input\",\"text\"],[\"nu5bad6cb34701820\",\"set_smtp_host\",\"Host\",\"input\",\"text\"],[\"nu5bad6cb346df926\",\"set_smtp_password\",\"Password\",\"input\",\"text\"],[\"nu5bad6cb3477c73b\",\"set_smtp_port\",\"Port\",\"input\",\"number\"],[\"nu5bad6cb346a7c3b\",\"set_smtp_username\",\"User Name\",\"input\",\"text\"],[\"nu5bad6cb346642c0\",\"set_smtp_use_authentication\",\"Use Authentication\",\"select\",\"\"],[\"nu5bad6cb345bcd24\",\"set_zzzzsys_timezone_id\",\"Time Zone\",\"lookup\",\"\"]],\"nutab\":[[\"nu5bad6cb362c74c4\",\"syt_help\",\"Help\",\"input\",\"text\"],[\"nu5bad6cb328f889b\",\"syt_order\",\"Order\",\"input\",\"number\"],[\"nu5bad6cb328dde63\",\"syt_title\",\"Title\",\"input\",\"text\"]],\"nutablookup\":[],\"nutimezone\":[],\"nutranslate\":[[\"nu5bad6cb3498f4e8\",\"trl_english\",\"English\",\"input\",\"text\"],[\"nu5bad6cb3482a7d5\",\"trl_language\",\"Language\",\"input\",\"nuScroll\"],[\"nu5bad6cb349c926f\",\"trl_translation\",\"Translation\",\"input\",\"text\"]],\"nuuser\":[[\"nu5bad6cb33d2481a\",\"check_password\",\"Reenter New Password\",\"input\",\"password\"],[\"nu5bad6cb33b84bf4\",\"new_password\",\"Enter New Password\",\"input\",\"password\"],[\"nu5bad6cb33b1013c\",\"sus_email\",\"Email\",\"input\",\"text\"],[\"nu5bad6cb3462cd79\",\"sus_language\",\"Language\",\"select\",\"\"],[\"nu5bad6cb33b42890\",\"sus_login_name\",\"Login Name\",\"input\",\"text\"],[\"nu5bad6cb33ad88b7\",\"sus_name\",\"Name\",\"input\",\"text\"],[\"nu5bad6cb33d99a4b\",\"sus_zzzzsys_access_id\",\"Access Level\",\"lookup\",\"text\"]],\"nuuserhome\":[]}}',1547432470); 515 516 /*!40000 ALTER TABLE `zzzzsys_session` ENABLE KEYS */; 516 517 UNLOCK TABLES; … … 575 576 LOCK TABLES `zzzzsys_tab` WRITE; 576 577 /*!40000 ALTER TABLE `zzzzsys_tab` DISABLE KEYS */; 577 INSERT INTO `zzzzsys_tab` VALUES ('nu5bad6cb36757b92','nuform','Browse',20,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Forms\');'),('nu5bad6cb36791fd5','nuform','Main',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Forms\');'),('nu5bad6cb367c5125','nuhome','Setup',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php\');'),('nu5bad6cb36804778','nubuildreport','Report',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Reports\');'),('nu5bad6cb3683fa36','nubrowse','Browse',10,''),('nu5bad6cb3686cb0d','nuobject','All',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects_#Tab_-_All\');'),('nu5bad6cb368d9c40','nuobject','Run',20,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Run\');'),('nu5bad6cb36974818','nuobject','Display',30,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Display\');'),('nu5bad6cb369a6ee3','nuobject','Select',40,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects_#Tab_-_Select\');'),('nu5bad6cb369d0088','nuobject','Lookup',50,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Lookup\');'),('nu5bad6cb36a1c024','nuobject','Subform',60,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Subform\');'),('nu5bad6cb36a4af06','nuobject','Input',80,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Input\');'),('nu5bad6cb36a71012','nuobject','HTML',90,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_HTML\');'),('nu5bad6cb36aaa539','nuevent','Event',10,''),('nu5bad6cb36ac903f','nuaccess','User',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/User_Access#Creating_an_Access_Level\');'),('nu5bad6cb36af0c58','nuaccess','Forms',20,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/User_Access#Creating_an_Access_Level\');'),('nu5bad6cb36b12637','nunonsystemform','Forms',10,''),('nu5bad6cb36b27343','nuphp','PHP',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Procedures\');'),('nu5bad6cb36b63cae','nuuser','User Details',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/User_Access#Adding_a_User\');'),('nu5bad6cb36b994d2','nuaccessforms','Form',10,''),('nu5bad6cb36bc9e21','nublank','Launch',10,''),('nu5bad6cb36bdec72','nuaccessgroup','Access Group',10,''),('nu5bad6cb36bf8d38','nudebug','Debug',10,''),('nu5bad6cb36c16b42','nuaccess','Procedures',30,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/User_Access#Creating_an_Access_Level\');'),('nu5bad6cb36c39fc8','nuaccess','Reports',40,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/User_Access#Creating_an_Access_Level\');'),('nu5bad6cb36c55179','nuaccessreport','Access',10,''),('nu5bad6cb36c75655','nuaccesslevelreport','Access',10,''),('nu5bad6cb36c9250f','nutab','Tabs',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Forms#Tabs_.28Subform.29\');'),('nu5bad6cb36cb6102','nurunreport','Report',10,''),('nu5bad6cb36ce06d9','nurunphp','PHP',10,''),('nu5bad6cb36cfbbfa','nulaunchdates','Launch',10,''),('nu5bad6cb36d2177c','nurunlist','Test',10,''),('nu5bad6cb36d582df','nutimezone','Zone',10,''),('nu5bad6cb36d97acd','nusetup','Setup',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Setup#Setup\');'),('nu5bad6cb36e31edf','nusetup','Email Settings',20,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Setup#Email_Settings\');'),('nu5bad6cb36e9143a','nusetup','Header',30,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Setup#Header\');'),('nu5bad6cb36eb07f0','nutranslate','Phrase',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Translations\');'),('nu5bad6cb36ed494f','nupassword','Change Password',10,''),('nu5bad6cb36efb50c','nuhome','Builders',20,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php\');'),('nu5bad6cb36f36433','nufflaunch','Form',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Form_Builder\');'),('nu5bad6cb36f72f8e','nufastformobjects','Label',10,''),('nu5bad6cb36f99a7e','nuobject','Calc',100,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Calc\');'),('nu5bad6cb36fcbc18','nuformat','Format',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Format_Builder\');'),('nu5bad6cb36ffc300','nuformatcurrency','Currency',10,''),('nu5bad6cb37026348','nuform','Custom Code',30,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Functions\');'),('nu5bad6cb370b409e','nuobject','Custom Code',110,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Custom_Code\');'),('nu5bad6cb370eb06a','nusample','Other Objects',30,''),('nu5bad6cb3719774c','nufile','Main',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Files\');'),('nu5bad6cb371c865e','nuobject','Image',70,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Image\');'),('nu5bad6cb371e2de7','nuselect','SQL',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/SQL_Builder\');'),('nu5bad6cb3721b534','nulaunchable','Main',10,''),('nu5bad6cb3722f122','nulaunchable','Browse',20,''),('nu5bad6cb3724c6ca','nulaunchable','Custom Code',30,''),('nu5bad6cb37296979','nuclause','Clause',10,''),('nu5bad6cb3732c76e','nusample','Subform',20,''),('nu5bad6cb3734c18f','nufastreportobjects','Label',10,''),('nu5bad6cb3737e773','nufrlaunch','Main',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Report_Builder\');'),('nu5bad6cb373c384f','nusample','Inputs',10,''),('nu5bad6cb37405d73','nusamplesubformform','Main',10,''),('nu 5bad6cb374207e3','nuuserhome','Main',20,''),('nufastforms','nuuserhome','Fast Forms',10,''),('nu5bad6cb37434d3a','nulaunchform','Forms',10,''),('nu5bad6cb374482e8','nutablookup','Tabs',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Forms#Tabs_.28Subform.29\');');578 INSERT INTO `zzzzsys_tab` VALUES ('nu5bad6cb36757b92','nuform','Browse',20,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Forms\');'),('nu5bad6cb36791fd5','nuform','Main',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Forms\');'),('nu5bad6cb367c5125','nuhome','Setup',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php\');'),('nu5bad6cb36804778','nubuildreport','Report',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Reports\');'),('nu5bad6cb3683fa36','nubrowse','Browse',10,''),('nu5bad6cb3686cb0d','nuobject','All',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects_#Tab_-_All\');'),('nu5bad6cb368d9c40','nuobject','Run',20,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Run\');'),('nu5bad6cb36974818','nuobject','Display',30,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Display\');'),('nu5bad6cb369a6ee3','nuobject','Select',40,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects_#Tab_-_Select\');'),('nu5bad6cb369d0088','nuobject','Lookup',50,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Lookup\');'),('nu5bad6cb36a1c024','nuobject','Subform',60,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Subform\');'),('nu5bad6cb36a4af06','nuobject','Input',80,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Input\');'),('nu5bad6cb36a71012','nuobject','HTML',90,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_HTML\');'),('nu5bad6cb36aaa539','nuevent','Event',10,''),('nu5bad6cb36ac903f','nuaccess','User',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/User_Access#Creating_an_Access_Level\');'),('nu5bad6cb36af0c58','nuaccess','Forms',20,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/User_Access#Creating_an_Access_Level\');'),('nu5bad6cb36b12637','nunonsystemform','Forms',10,''),('nu5bad6cb36b27343','nuphp','PHP',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Procedures\');'),('nu5bad6cb36b63cae','nuuser','User Details',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/User_Access#Adding_a_User\');'),('nu5bad6cb36b994d2','nuaccessforms','Form',10,''),('nu5bad6cb36bc9e21','nublank','Launch',10,''),('nu5bad6cb36bdec72','nuaccessgroup','Access Group',10,''),('nu5bad6cb36bf8d38','nudebug','Debug',10,''),('nu5bad6cb36c16b42','nuaccess','Procedures',30,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/User_Access#Creating_an_Access_Level\');'),('nu5bad6cb36c39fc8','nuaccess','Reports',40,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/User_Access#Creating_an_Access_Level\');'),('nu5bad6cb36c55179','nuaccessreport','Access',10,''),('nu5bad6cb36c75655','nuaccesslevelreport','Access',10,''),('nu5bad6cb36c9250f','nutab','Tabs',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Forms#Tabs_.28Subform.29\');'),('nu5bad6cb36cb6102','nurunreport','Report',10,''),('nu5bad6cb36ce06d9','nurunphp','PHP',10,''),('nu5bad6cb36cfbbfa','nulaunchdates','Launch',10,''),('nu5bad6cb36d2177c','nurunlist','Test',10,''),('nu5bad6cb36d582df','nutimezone','Zone',10,''),('nu5bad6cb36d97acd','nusetup','Setup',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Setup#Setup\');'),('nu5bad6cb36e31edf','nusetup','Email Settings',20,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Setup#Email_Settings\');'),('nu5bad6cb36e9143a','nusetup','Header',30,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Setup#Header\');'),('nu5bad6cb36eb07f0','nutranslate','Phrase',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Translations\');'),('nu5bad6cb36ed494f','nupassword','Change Password',10,''),('nu5bad6cb36efb50c','nuhome','Builders',20,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php\');'),('nu5bad6cb36f36433','nufflaunch','Form',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Form_Builder\');'),('nu5bad6cb36f72f8e','nufastformobjects','Label',10,''),('nu5bad6cb36f99a7e','nuobject','Calc',100,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Calc\');'),('nu5bad6cb36fcbc18','nuformat','Format',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Format_Builder\');'),('nu5bad6cb36ffc300','nuformatcurrency','Currency',10,''),('nu5bad6cb37026348','nuform','Custom Code',30,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Functions\');'),('nu5bad6cb370b409e','nuobject','Custom Code',110,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Custom_Code\');'),('nu5bad6cb370eb06a','nusample','Other Objects',30,''),('nu5bad6cb3719774c','nufile','Main',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Files\');'),('nu5bad6cb371c865e','nuobject','Image',70,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Objects#Tab_-_Image\');'),('nu5bad6cb371e2de7','nuselect','SQL',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/SQL_Builder\');'),('nu5bad6cb3721b534','nulaunchable','Main',10,''),('nu5bad6cb3722f122','nulaunchable','Browse',20,''),('nu5bad6cb3724c6ca','nulaunchable','Custom Code',30,''),('nu5bad6cb37296979','nuclause','Clause',10,''),('nu5bad6cb3732c76e','nusample','Subform',20,''),('nu5bad6cb3734c18f','nufastreportobjects','Label',10,''),('nu5bad6cb3737e773','nufrlaunch','Main',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Report_Builder\');'),('nu5bad6cb373c384f','nusample','Inputs',10,''),('nu5bad6cb37405d73','nusamplesubformform','Main',10,''),('nufastforms','nuuserhome','Fast Forms',10,''),('nu5bad6cb374207e3','nuuserhome','Main',20,''),('nu5bad6cb37434d3a','nulaunchform','Forms',10,''),('nu5bad6cb374482e8','nutablookup','Tabs',10,'window.open(\'http://wiki.nubuilder.net/nubuilderforte/index.php/Forms#Tabs_.28Subform.29\');'); 578 579 /*!40000 ALTER TABLE `zzzzsys_tab` ENABLE KEYS */; 579 580 UNLOCK TABLES; … … 689 690 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 690 691 691 -- Dump completed on 201 8-12-11 14:22:43692 -- Dump completed on 2019-01-14 12:57:33 -
nubuilder-forte/trunk/readme.txt
r1992309 r2011776 5 5 Tags: database, low-code, reports, manage data, inventory, statistics, report, customer report, user report, custom application, build application 6 6 Requires at least: 4.9.8 7 Tested up to: 5.0 8 Stable tag: 5.0 7 Tested up to: 5.0.3 8 Stable tag: 5.0.3 9 9 Requires PHP: 5.2.4 10 10 License: GPLv3 … … 56 56 nuBuilder stores all forms, reports, company data and PHP/JavaScript code in MySQL. You can backup your entire application within a single database file. 57 57 58 = Alternative to Oracle Application Express =59 nuBuilder is a enterprise level application builder but with no limitations on database size or CPU usage.60 61 58 == Installation == 62 59 … … 80 77 * Added a few tweaks to using shortcodes 81 78 79 = 1.3 = 80 * Fixed missing user_id in short code 81 * Changed Access Level home Form to include all Form types 82 * Fixed missing function to clear old sessions 83 82 84 == Upgrade Notice == 83 85 … … 96 98 * Added a few tweaks to using shortcodes 97 99 100 = 1.3 = 101 * Fixed missing user_id in short code 102 * Changed Access Level home Form to include all Form types 103 * Fixed missing function to clear old sessions 104 98 105 == Documentation == 99 106 … … 104 111 == Frequently Asked Questions == 105 112 106 = Does this plugin work with my exi tisng standalone alone version of nuBuilder4 ? =113 = Does this plugin work with my existing standalone alone version of nuBuilder4 ? = 107 114 Yes, your existing nuBuilder4 database will need to be imported into your Wordpress database, then 108 115 you will need to click on 'activate' plugin, then login as globeadmin and run the nubuilder updater.
Note: See TracChangeset
for help on using the changeset viewer.