$cg_localize = array( 'customers.acct_code'=>'Acct', 'customers.cust_add1'=>'Address 1', 'customers.cust_add2'=>'Address 2', 'customers.cust_cell_num'=>'Cell Phone', 'customers.cust_city'=>'City', 'customers.cust_fax_num'=>'Fax Number', 'customers.cust_name'=>'Name', 'customers.cust_phone_num'=>'Phone Number', 'customers.cust_postal_code'=>'Zip Code', 'customers.cust_pri_email'=>'Primary Email', 'customers.cust_sec_email'=>'Secondary Email', 'customers.cust_state'=>'State', 'customers.cust_lat'=>'Latitude', 'customers.cust_long'=>'Longitude', 'customers.id'=>'row', 'customer_invoices.inv_cust_id'=>'Inv Cust Id', 'customer_invoices.inv_num'=>'Inv Number', 'customer_invoices.inv_date'=>'Inv Date', 'customer_invoices.inv_desc'=>'Inv Description', 'customer_invoices.inv_amt'=>'Inv Amount', 'customer_invoices.id'=>'row', 'cg_users.id'=>'row', 'cg_users.user_id'=>'User ID', 'cg_users.user_forum_id'=>'User Forum ID', 'cg_users.user_name'=>'User Name', 'cg_users.user_pswd'=>'Password', 'cg_users.user_email'=>'Primary Email', 'cg_users.user_menu_name'=>'Menu Name', 'cg_users.user_dflt_menu'=>'Dflt Menu', 'cg_users.user_start_pages'=>'Auto Load Pages', 'cg_users.user_last_login'=>'Last Login Date-Time', 'cg_users.user_created_on'=>'Created On Date-Time', 'cg_users.user_mbr_type'=>'Member Type', 'cg_users.user_mbr_renewal'=>'Member Renewal', 'cg_users.user_host_type'=>'Hosting Type', 'cg_users.user_host_renewal'=>'Hosting Renewal', 'cg_users.user_path'=>'User Path', 'cg_menus.id'=>'Menu Num', 'cg_menus.menu_name'=>'Name', 'cg_menus.menu_choices'=>'Select Items', 'cg_menus.menu_start_pages'=>'Start Pages', 'cg_data_columns.dc_default_val'=>'Default Val', 'cg_data_columns.dc_display_label'=>'Disp Label Name', 'cg_data_columns.dc_display_rows'=>'Text Area Rows', 'cg_data_columns.dc_display_type'=>'Disp Type', 'cg_data_columns.dc_is_nullable'=>'Is Nullable', 'cg_data_columns.dc_name'=>'Column Name', 'cg_data_columns.dc_table_id'=>'Column Table Link', 'cg_data_columns.dc_type'=>'Column Type', 'cg_data_columns.dc_format'=>'Format', 'cg_data_columns.dc_db_format'=>'DB Format', 'cg_data_columns.dc_align'=>'Align', 'cg_data_columns.dc_validate'=>'Validation', 'cg_data_columns.dc_sel_data_link'=>'Select Table Data Link Info', 'cg_data_columns.dc_sel_text_type'=>'Select Text Type', 'cg_data_columns.dc_link_to_tbl'=>'Link To Table', 'cg_data_columns.dc_link_type'=>'Link Type', 'cg_data_columns.dc_display_width'=>'Display Width', 'cg_data_columns.dc_def_size'=>'Defined Size', 'cg_data_columns.dc_display_loc'=>'Display Loc', 'cg_data_columns.dc_spcl_col'=>'Special Col', 'cg_data_columns.dc_spcl_col_exp'=>'Spcl Col Expr', 'cg_data_columns.dc_html_encode'=>'HTML Encode', 'cg_data_columns.dc_unique'=>'Unique', 'cg_data_columns.dc_allow_null'=>'Allow Null', 'cg_data_columns.dc_def_order'=>'Def Order', 'cg_data_columns.dc_ts_type'=>'TS Type', 'cg_data_columns.dc_tooltip'=>'Tooltip', 'cg_data_columns.id'=>'row', 'cg_dc_simple.dc_name'=>'Fld Name', 'cg_dc_simple.dc_display_type'=>'Type', 'cg_dc_simple.dc_display_label'=>'Label', 'cg_data_links.id'=>'row', 'cg_data_links.dl_link_type'=>'Link Type', 'cg_data_links.dl_table'=>'Table', 'cg_data_links.dl_link_to_table'=>'Link To Table', 'cg_data_links.dl_link_to_column'=>'Link To Col', 'cg_data_links.dl_sib_table_name'=>'Sib Tbl Name', 'cg_data_tables.dt_description'=>'Table Description', 'cg_data_tables.dt_name'=>'Table Name', 'cg_forms.id'=>'row', 'cg_forms.form_name'=>'Form Name', 'cg_forms.form_table_name'=>'Data Table', 'cg_forms.form_type'=>'Type', 'cg_forms.form_spaces'=>'Spaces', 'cg_forms.form_group_validate'=>'Validate by Fld', 'cg_forms.form_css_file'=>'CSS File Name', 'cg_forms.form_form_class'=>'Form Class', 'cg_forms.form_label_class'=>'Label Class', 'cg_forms.form_input_class'=>'Input Class', 'cg_form_columns.id'=>'row', 'cg_form_columns.fc_form_id'=>'cg_form_id', 'cg_form_columns.fc_name'=>'Fld Name', 'cg_form_columns.fc_display_label'=>'Label', 'cg_form_columns.fc_label_snip'=>'Label Snip', 'cg_form_columns.fc_data_snip'=>'Data Snip', 'cg_form_columns.fc_display_order'=>'Order', 'cg_form_columns.fc_label_num_cols'=>'Lbl Cols', 'cg_form_columns.fc_data_num_cols'=>'Data Cols', 'cg_form_columns.fc_read_only'=>'Is Read Only', 'cg_form_columns.fc_hidden'=>'Is Hidden', 'cg_form_columns.fc_validate'=>'Validate', 'cg_grids.grid_add'=>'Allow New', 'cg_grids.grid_snips'=>'Snips', 'cg_grids.grid_snips_link'=>'Disp Snips', 'cg_grids.grid_caption'=>'Grid Caption', 'cg_grids.grid_del'=>'Allow Del', 'cg_grids.grid_del_confirm_msg'=>'Del Confirm Msg', 'cg_grids.grid_dflt_sort_fld'=>'Dflt Sort Fld', 'cg_grids.grid_dflt_sort_ord'=>'Dflt Sort Ord', 'cg_grids.grid_dsp_scrn_height'=>'Disp Scrn Ht', 'cg_grids.grid_disp_scrn_view'=>'Disp Scrn View', 'cg_grids.grid_disp_scrn_edit'=>'Disp Scrn Edit', 'cg_grids.grid_dsp_scrn_width'=>'Disp Scrn Wdth', 'cg_grids.grid_start_mode'=>'Start Mode', 'cg_grids.grid_allow_toggle'=>'Allow Toggle', 'cg_grids.grid_edit'=>'Allow Edit', 'cg_grids.grid_filter'=>'Allow Search', 'cg_grids.grid_height'=>'Height', 'cg_grids.grid_html_file'=>'HTML Template', 'cg_grids.grid_js_file'=>'JS Template', 'cg_grids.grid_js_oth_file'=>'JS Function Template', 'cg_grids.grid_list_view'=>'Alt List View', 'cg_grids.grid_link_fld'=>'Link Fld', 'cg_grids.grid_link_section_name'=>'Link Section Name', 'cg_grids.grid_link_type'=>'Link Type', 'cg_grids.grid_multi_select'=>'Allow Multi-select', 'cg_grids.grid_name'=>'Grid Name', 'cg_grids.grid_php_file'=>'PHP Template', 'cg_grids.grid_table_name'=>'Data Table', 'cg_grids.grid_type_msg_label'=>'Type Msg', 'cg_grids.grid_view'=>'Allow View', 'cg_grids.grid_width'=>'Width', 'cg_grids.grid_group_del'=>'Allow Grp Del', 'cg_grids.grid_num_rows'=>'Initial Num Rows', 'cg_grids.grid_nav_actions'=>'Nav Actions', 'cg_grids.id'=>'id', 'cg_grid_columns.id'=>'row', 'cg_grid_columns.gc_display_label'=>'Disp Label', 'cg_grid_columns.gc_display_width'=>'Disp Width', 'cg_grid_columns.gc_display_order'=>'Order', 'cg_grid_columns.gc_grid_id'=>'Parent Id', 'cg_grid_columns.gc_name'=>'Fld Name', 'cg_grid_columns.gc_hidden'=>'Hidden', 'cg_grid_columns.gc_formatter'=>'Formatter', 'cg_grid_columns.gc_unformatter'=>'Unformatter', 'cg_grid_columns.gc_editable'=>'Editable', 'cg_grid_columns.gc_edit_snip'=>'Edit Snip', 'cg_grid_columns.gc_viewable'=>'Viewable', 'cg_grid_columns.gc_view_snip'=>'View Snip', 'cg_grid_columns.gc_searchable'=>'Searchable', 'cg_grid_columns.gc_read_only'=>'Is Read Only', 'cg_grid_columns.gc_validate'=>'Validate', 'cg_pages.id'=>'row', 'cg_pages.pg_body_script'=>'Body HTML Template', 'cg_pages.pg_disp_title'=>'Page Title', 'cg_pages.pg_hdr_script'=>'Header HTML Template', 'cg_pages.pg_html_template'=>'Main HTML Template', 'cg_pages.pg_name'=>'Name', 'cg_pages.pg_save_path'=>'Save To Path', 'cg_pages.pg_snips'=>'Snips', 'cg_pages.pg_snips_disp'=>'Disp Snips', 'cg_pages.pg_finals'=>'Final Replacements', 'cg_page_sections.id'=>'row', 'cg_page_sections.page_id'=>'cg_page Row Id', 'cg_page_sections.section_disp_order'=>'Disp Order', 'cg_page_sections.section_id'=>'Section Row Id', 'cg_page_sections.section_type'=>'Section Type', 'cg_page_sections.section_link'=>'Link Type', 'cg_page_sections.section_page_name'=>'cg_page Name', 'cg_page_sections.section_sec_name'=>'Section Name', 'cg_page_sections.section_pat'=>'Place At Tag', 'cg_code_storage.code_description'=>'Description', 'cg_code_storage.code_description_link'=>'Disp Desc', 'cg_code_storage.code_name'=>'Name', 'cg_code_storage.code_text'=>'Code', 'cg_code_storage.code_text_link'=>'Disp Code', 'cg_code_storage.code_tags'=>'Code Tags', 'cg_code_storage.id'=>'row', 'cg_code_tags.tag_name'=>'Name', 'cg_code_tags.id'=>'row', 'cg_dialogs.dlg_name'=>'Name', 'cg_dialogs.dlg_title'=>'Title', 'cg_dialogs.dlg_height'=>'Height', 'cg_dialogs.dlg_width'=>'Width', 'cg_dialogs.dlg_modal'=>'Modal', 'cg_dialogs.dlg_html_file'=>'HTML Template', 'cg_dialogs.dlg_js_file'=>'JS Template', 'cg_dialogs.dlg_js_oth_file'=>'JS Function Template', 'cg_dialogs.dlg_php_file'=>'PHP Template', 'cg_dialogs.dlg_snips'=>'Snips', 'cg_html_segments.id'=>'Row', 'cg_html_segments.html_name'=>'Name', 'cg_html_segments.html_html_file'=>'HTML Template', 'cg_html_segments.html_js_file'=>'JS Template', 'cg_html_segments.html_js_oth_file'=>'JS Function Template', 'cg_html_segments.html_php_file'=>'PHP Template', 'cg_html_segments.html_snips'=>'Snips', 'cg_html_segments.html_snips_disp'=>'Disp Snips', 'cg_options.id'=>'row', 'cg_options.opt_name'=>'Name', 'cg_options.opt_desc'=>'Description', 'cg_options.opt_used_where'=>'Used Where', 'cg_musers.id'=>'Row', 'cg_musers.muser_id'=>'User ID', 'cg_musers.muser_name'=>'Name', 'cg_musers.muser_pswd'=>'Password', 'cg_musers.muser_email'=>'Email', 'cg_musers.muser_master_user'=>'Master User', 'cg_musers.muser_menu_name'=>'Menu Name', 'cg_musers.muser_last_login'=>'Last Login', 'cg_musers.muser_created_on'=>'Created On', 'selAlign'=>array('Left','Right','Center'), 'selYN'=>array('No','Yes'), 'selYNChar'=>array('N'=>'No','Y'=>'Yes'), 'selYNF'=>array('No','Yes','Force'), 'selYNFChar'=>array('N'=>'No','Y'=>'Yes','F'=>'Force'), 'selYNCChar'=>array('N'=>'No','Y'=>'Yes','C'=>'CSV'), 'selYNEmailChar'=>array('N'=>'No','Y'=>'Yes','X'=>'New','C'=>'Customer'), 'selSortOrd'=>array('Asc','Desc'), 'selTimestamp'=>array('None','Create','Update'), 'selEmailActType'=>array('Sent','Clickthrough','Unsubscribe'), 'selDataColType'=>array('tinyint'=>'Tiny Int','int'=>'Int','char'=>'Character','varchar'=>'Varchar','text'=>'Text','date'=>'Date','time'=>'Time','datetime'=>'Date Time','decimal'=>'Decimal','float'=>'Float','ts_create'=>'Create Timestamp','ts_update'=>'Update Timestamp'), 'selDispType'=>array('Text','TextArea','Numeric','Date','Time','DateTime','SelectLocText','SelectTblData','SelectTblText','SelectSiblings','Password'), 'selDispTypeSimple'=>array('Text','TextArea','Numeric','Date','Time'), 'selLinkTypes'=>array('None','Parent','Child','Both'), 'selLinkTableTypes'=>array('Choose Link Type','Parent','Sibling'), 'selSelTypes'=>array('Locale','Text','Table'), 'selSectionTypes'=>array('Choose Section Type','Grid','HTML','Dialog','Form'), 'selScrnWhere'=>array('Default'), 'selLabelWhere'=>array('Left','Above'), 'selFormType'=>array('View','Edit'), 'selFormUse'=>array('General','Calendar','Email','Answering'), 'selStartMode'=>array('Grid','Form','None'), 'selToolbarLoc'=>array('None', 'Top', 'Bottom'), 'selRenewal'=>array('None','Monthly','Yearly'), 'selDOW_MF_Only'=>array('All', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday'), 'selDOW_all'=>array('All','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday'), 'selEmailSDT'=>array('hours','days','weeks','months'), 'selHowToContact'=>array('Email','Daytime Phone','Evening Phone','Fax'), 'selSvcsNeededIn'=>array('Within 1 Month','Within 3 Months','Within 6 Months','Within 1 year'), 'selBizType'=>array('Residential','Commercial','Industrial'), 'selTitle'=>array(''=>'','Mr'=>'Mr','Ms'=>'Ms','Mrs'=>'Mrs','Dr'=>'Dr'), 'selMktSources'=>array('Google','Yahoo','MSN','AltaVista','Lycos','Superpages','Dex','Others'), 'selLocType'=>array('City','State'), 'selMapIconShape'=>array('circle','rect'), 'selCourtRoom'=>array('15A','13A','14D','14A'), 'selPCLoginRoles'=>array('Cust Main','Admin','User','On Call','Form'), 'selCalSlotLen'=>array(5=>'5 mins',10=>'10 mins',15=>'15 mins',30=>'30 mins',50=>'50 mins',60=>'60 mins',100=>'100 mins',120=>'120 mins'), 'selCalDays'=>array('All','Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday'), 'selCalUseWhat'=>array('No Cal','Use Default','Use This'), 'selCalRecurApptFreq'=>array('Daily','Weekly','Monthly'), 'selCalColors'=>array('#39F|#FFF'=>'None','#F00|#FFF'=>'Red','#0C0|#000'=>'Green','#39F|#FFF'=>'Blue','#FF0|#000'=>'Yellow','#F60|#FFF'=>'Orange','#000|#FFF'=>'Black','#0FF|#000'=>'Cyan','#F0F|#FFF'=>'Purple','#999|#FFF'=>'Gray','#F30|#FFF'=>'RRO','#FCC|#000'=>'PWR','#FCF|#000'=>'PWM','#F39|#FFF'=>'LHP','#3CC|#000'=>'MFC','#CCC|#000'=>'PG'), 'selPCMOType'=>array('S'=>'SubAcct','R'=>'Round Robin'), 'selSched'=>array('none'=>'None','our_server'=>'Unlimited appointment taking, our server','their server'=>'Appointment taking, their server'), 'selVFax'=>array('none'=>'None','in_only'=>'Incoming Only','in_out'=>'Incoming + Outgoing'), 'selService'=>array('basic'=>'Basic Service','enhanced'=>'Enhanced Service','premium'=>'Premium Service'), 'selTollFree'=>array('none'=>'None','std'=>'Standard','custom'=>'Custom'), 'selSendSummary'=>array('none'=>'None','daily'=>'Daily (Sun-Sat)','workdays'=>'Workdays (Mon-Fri)'), 'selPATType'=>array('z_Dflt'=>'24/7','b_Daytime'=>'Day/Time','c_From'=>'From/Thru','a_Over'=>'Override'), 'selDOW'=>array('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday'), 'selDoWhat'=>array('normal'=>'Normal Msg Delivery','hold_msgs'=>'Hold All Msgs','no_xfer'=>'No Call Transfers'), 'selPMLAtEnd'=>array('restart'=>'Restart w/First','dlvatend'=>'Delivered at end'), 'selPMLSADlvHow'=>array('eft'=>'Email/Fax/Text','xtopa'=>'Xfer to Phone Announce','xtopb'=>'Xfer to Phone Blind','xtovm'=>'Xfer to VM','relay'=>'Make Call and Relay','msgtovm'=>'Msg to VM','dlvr'=>'Must Deliver','nomsg'=>'No Messages'), 'selPMLSASendWhen'=>array('now'=>'Immediately','after'=>'After Contact','both'=>'Both'), 'selPEMFreq'=>array('once'=>'Once','hourly'=>'Hourly','daily'=>'Daily','weekly'=>'Weekly','monthly'=>'Monthly','quarterly'=>'Quarterly','yearly'=>'Yearly'), 'selInvType'=>array('I'=>'Invoice','P'=>'Payment','C'=>'Credit','F'=>'Fee','D'=>'Deleted'), 'selSvcType'=>array('N'=>'Normal','P'=>'Plan','W'=>'Web'), 'selPostType'=>array('cash'=>'Cash','sale'=>'Sale'), 'selDrCr'=>array('dr'=>'Debit','cr'=>'Credit'), 'selActive'=>array('Y'=>'Yes','N'=>'No','C'=>'Cancel','X'=>'Last Mo','Z'=>'No Bill'), 'selMsgFldType'=>array('text'=>'Text','textarea'=>'TextArea','sel'=>'Select List','date'=>'Date','time'=>'Time'), 'selEmailSentForType'=>array('cust'=>'Customer','sub'=>'SubAcct','msg'=>'Message','form'=>'Form Entry','cal'=>'Calendar','inv'=>'Invoice','stmt'=>'Statement','sales'=>'Sales','signup'=>'New Cust Sign Up','xfer'=>'Call Transfers'), 'selWebType'=>array('web'=>'Web Site','form'=>'Form Entry'), 'selCallsDeducts'=>array('C'=>'Calls','D'=>'Deductions','W'=>'Web'), 'selWUCAnswered'=>array('S'=>'Scheduled','C'=>'Calling','Y'=>'Yes','N'=>'No Answer!!'), 'caption.none'=>'NONE', 'caption.dt_maint'=>'Data Table Design', 'caption.dc_maint'=>'Data Column Design DB', 'caption.dc_maint_spcl'=>'Data Column Desigm Special', 'caption.dl_maint'=>'Data Links Design', 'caption.sel_maint'=>'Select Types Design', 'caption.page_maint'=>'Page Design', 'caption.section_maint'=>'Section Design', 'caption.form_maint'=>'Form Design', 'caption.fc_maint'=>'Form Column Design', 'caption.grid_maint'=>'Grid Design', 'caption.gc_maint'=>'Grid Column Design', 'caption.cust_maint'=>'Customer Management', 'caption.cust_invoices'=>'Customer Invoices', 'caption.sched_events'=>'Scheduled Appointments', 'caption.code_storage'=>'Code Storage', 'caption.code_tags'=>'Code Tags', 'caption.dialogs'=>'Dialogs', 'caption.html_segments'=>'HTML Segments', 'caption.options'=>'Options', 'caption.menus'=>'Menu Design', 'caption.musers'=>'User Management', 'pglbl.data_tables'=>'Data Tables / Columns', 'pglbl.data_columns'=>'Data Columns', 'pglbl.data_links'=>'Data Links', 'pglbl.selects'=>'Select Options', 'pglbl.page_sections'=>'Page / Sections', 'pglbl.sections'=>'Sections', 'pglbl.form_maint'=>'Forms / Form Columns', 'pglbl.grid_maint'=>'Grids / Grid Columns', 'pglbl.grid_cols'=>'Grid Columns', 'pglbl.customers'=>'Customers', 'pglbl.cust_inv'=>'Customers / Invoices', 'pglbl.sched_events'=>'Scheduled Appointments', 'pglbl.code_storage'=>'Code Storage / Tags', 'pglbl.dialogs'=>'Dialogs', 'pglbl.html_segments'=>'HTML Segments', 'pglbl.options'=>'Options', 'pglbl.cappgen'=>'CAppGen - Cloud Application Generator', 'pglbl.users'=>'Users', 'pglbl.musers'=>'Users', 'pglbl.menus'=>'Menus', 'pglbl.login'=>'Please Log In', 'title.edit_add_code_tags'=>'Edit/Add Code Tags', 'title.mtm_tag_sel'=>'Select the appropriate tags', 'title.mtm_tag_new'=>'Enter new tags here (separate with comma)', 'type.customer'=>'Customer', 'type.cust_inv'=>'Customer Invoice', 'type.data_table'=>'Data Table', 'type.data_column'=>'Data Column', 'type.data_link'=>'Data Link', 'type.page'=>'Page', 'type.section'=>'Section', 'type.select'=>'Select Type', 'type.form'=>'Form', 'type.form_column'=>'Form Column', 'type.grid'=>'Grid', 'type.grid_column'=>'Grid Column', 'type.sched_event'=>'Appointment', 'type.code_storage'=>'Code Block', 'type.code_tag'=>'Tag', 'type.dialogs'=>'Dialog', 'type.html_segment'=>'HTML Segment', 'type.options'=>'Option', 'type.user'=>'User', 'type.musers'=>'User', 'type.menus'=>'Menu', //date, time formats 'date_fmt'=>'m/d/y', 'date_fmt_db'=>array('date_format(*,\'%m/%d/%Y\') as *','str_to_date(?,\'%m/%d/%Y\')'), 'time_fmt'=>'h:m:s', 'time_fmt_db'=>array('time_format(*,\'%h:%i %p\') as *','str_to_date(?,\'%h:%i %p\')'), 'time_fmt_db_ndf'=>array('*','str_to_date(?,\'%h:%i %p\')'), 'time_fmt_secs_db'=>array('time_format(*,\'%r\') as *','str_to_date(?,\'%r\')'), 'd_t_fmt'=>'m/d/y h:m:s', 'd_t_fmt_db'=>array('date_format(*,\'%m/%d/%Y %h:%i %p\') as *','?'), 'd_t_none'=>array('*','?'), 'save_upcase_db'=>array('*','upper(?)'), //valid error messages 'valid.grid_name'=>'You must specify a grid name.', 'wait_for_options'=>'Waiting for options...' );