settings.sql

jsp程序开发系统

INSERT INTO settings VALUES (94,'Show Priorities to User','priority_user_viewable','1',107,'If this is enabled, your users will be shown what priority their tickets have been assigned to.','radio',0,'');
INSERT INTO settings VALUES (95,'Priorities User Selectable','priority_user_editable','1',107,'If this is enabled, your users will be allowed to edit what priority their tickets are been assigned to.','radio',0,'');
INSERT INTO settings VALUES (96,'Require Priority Selection','priority_require_selection','1',107,'If this is enabled, all tickets must be assigned to a priority.','radio',0,'');
INSERT INTO settings VALUES (104,'Return-To: address','email_return','returns@yourdomain.c0m',100,'This is the return address that is used for emails concerning a specific ticket. It is also the email address that you should either be pipeing to the return.php file in the /email folder or should be creating a POP3 account for. This ensures that any autoresponses that a user might send are added to the ticket but do not generate a loop and do not alert technicians.','text',0,'');
INSERT INTO settings VALUES (105,'From: name','email_from_name','yourDomain Support System',8,'This is the human readable portion of the from header for mail sent by DeskPRO.','text',0,'');
INSERT INTO settings VALUES (158,'SMTP Authorization?','smtp_auth','0',110,'If this is set to \"yes,\" and SMTP mailing is enabled, DeskPRO will authenticate itself to the SMTP server using standard SMTP authentication. The username and password you provide below will be used.','radio',24,'');
INSERT INTO settings VALUES (121,'DeskPRO Version','deskpro_version','2.0.1',111,'The current DeskPRO version (not user adjustable)','text',0,'');
INSERT INTO settings VALUES (122,'Only show FAQ to logged in users','faq_restrict','',5,'If set to \"yes,\" only show FAQ articles to logged-in users. Guests cannot view the FAQ.','text',0,'');
INSERT INTO settings VALUES (130,'Technicians Must Validate New Registrations','manual_validation','0',2,'If set to \"yes,\" your technicians must manually approve all new registrations before those accounts can be used to create new tickets. Note that enabling this will prevent new users from creating tickets until they have been approved.','radio',5,'');
INSERT INTO settings VALUES (131,'Maximum Message Size (POP)','max_message_size_pop','1048576',100,'This value specifies the largest size (in bytes) message that will be accepted by DeskPRO when it retrieves mail from a POP3 server. Messages larger than this size will be left on the server and ignored.','text',12,'');
INSERT INTO settings VALUES (132,'Maximum Message Size (pipe)','max_message_size_pipe','1048576',100,'This value specifies the largest size (in bytes) message that will be accepted by DeskPRO when it receives mail via a pipe. Messages larger than this size will be rejected and ignored.','text',13,'');
INSERT INTO settings VALUES (156,'SMTP Port','smtp_port','25',110,'If SMTP mailing is enabled, this value specifies the port number to connect to on the SMTP server for mailing. The default value, 25, is almost universally standard; you should change this only if you know your SMTP server is running on a non-standard port.','text',22,'');
INSERT INTO settings VALUES (157,'SMTP HELO String','smtp_helo','localhost',110,'If SMTP mailing is enabled, this value specifies what identification string DeskPRO will send to the SMTP server as part of its introductory \"HELO\" command to start an SMTP transaction. This should generally just be your domain name, or the name of your DeskPRO server.','text',23,'');
INSERT INTO settings VALUES (134,'Add footer to all e-mails','email_footer','1',8,'If set to \"yes\", the template EMAIL_footer will be appended to all emails. This is useful in providing contact information or including a disclaimer.','radio',2,'');
INSERT INTO settings VALUES (135,'Cookie Lifespan','cookie_lifespan','3600',108,'This setting determines the length, in seconds, a cookie-based session can idle before it is expired.','text',1,'');
INSERT INTO settings VALUES (136,'Session Timeout Adjustment','session_adjust','300',108,'DeskPRO includes logged-in time when it calculates how much time your technicians spend on the helpdesk. When a session times out due to inactivity, that idle time is normally deducted completely from the technician\'s activity time. This value (specified in seconds) can be used to add some of it back, with the assumption that the technician intended to work on a ticket or other part of the helpdesk, but was called away for some reason.','text',1,'');
INSERT INTO settings VALUES (137,'Cookie Path','cookie_path','',108,'This setting specifies the path portion of the full URL to your DeskPRO installation. For example, if your full URL to HelpDesk is hxxp://www.yourdomain.c0m/support/, specify \"/support/\" here. This is used for cookies, so that you can have more than one DeskPRO instance installed on a single domain.','text',99,'');
INSERT INTO settings VALUES (138,'Ticket Work is Billable?','default_billable','1',115,'If this is enabled and payments are enabled, logged entries are automatically marked as billable. If not, items are logged but not marked billable.','radio',5,'');
INSERT INTO settings VALUES (139,'Log Ticket Work in User Billing?','log_to_billing','1',115,'If set to \"yes,\" ticket work will automatically be logged to the user billing table (regardless of the use of the billing timer).','radio',6,'');
INSERT INTO settings VALUES (140,'Number of New/Most Popular FAQs to Show','faq_front_articles','10',5,'This specifies the number of new/updated FAQs to display on the user FAQ page. Set to 0 to disable this feature.','text',0,'');
INSERT INTO settings VALUES (172,'CSS: Default Text Color','css_default_text_color','#666666',117,'This setting specifies the HTML color value to use for \"default\" text in the user interface. This includes any text element whose color is not specified elsewhere. This must be a CSS-compliant string -- an HTML-format color.','text',0,'');
INSERT INTO settings VALUES (142,'Automatically Start Billing Timer?','autostart_billing_timer','1',115,'If payment are enabled, if this is set to \"yes,\" the billing timer in the Technician\'s ticket reply page is automatically started when the page is loaded.','radio',3,'');
INSERT INTO settings VALUES (144,'Enable Payments','payments','1',115,'If enabled, DeskPRO will display payment tracking functions in the Technician and Administration interfaces. Disabling this feature after enabling it will not delete existing billing information.','radio',0,'');
INSERT INTO settings VALUES (145,'Starting Category','category_user_start','1',106,'If this is enabled, your users can choose the category their tickets are created into.','radio',0,'');
INSERT INTO settings VALUES (146,'Maximum Duration Between Log Entries','max_log_duration','600',108,'DeskPRO calculates technician activity by counting the time between activity log entries. This value specifies, in seconds, how much time can pass between two separate events before DeskPRO no longer merges them together into the same session. If this value is set to 600 (ten minutes), activities less than ten minutes apart will all count together as activity, whereas an activity occurring eleven minutes or more later will count as if the technician had just logged in (the time difference between both events won\'t be included).','text',5,'');
INSERT INTO settings VALUES (147,'Starting Priority','priority_user_start','1',107,'If this is enabled, your users can choose the priority their tickets are created into.','radio',0,'');
INSERT INTO settings VALUES (150,'Max New Tickets Warning','max_new_warning','8',112,'It is important to have a limit on the number of emals a user can send in an hour to prevent a possible autoresponder loop. This setting is the warning amount, when the amount is reached a seperate email is sent to the user asking them to not send new emails so quickly and to explain that they will not receive anymore automatic notifications from DeskPRO.','text',99,'');
INSERT INTO settings VALUES (152,'Max Replies','max_reply','8',112,'This specified the maxium number of replies to a ticket that can be made in an hour. Further replies will be ignored (the user is autoresponding).','text',9999,'');
INSERT INTO settings VALUES (153,'Gateway Reply Quote Handling','gateway_reply_cut','1',100,'When this is set to \"yes,\" DeskPRO will attempt to automatically trim the \"quoted\" part of messages mailed to it. This is done in conjunction with the \"gateway_reply_cut\" language phrase; if that phrase appears in the e-mail, that line and every line beneath it is deleted; what remains is added to the ticket as a reply.','radio',99,'');
INSERT INTO settings VALUES (154,'Server Offset','timezone','0',113,'This setting specifies the timezone DeskPRO should operate in by default. For example, if you want DeskPRO to use Eastern Standard Time (EST), enter \"-5\". Users and technicians who don\'t specify their own timezones will inherit this one by default.','text',9999,'');
INSERT INTO settings VALUES (160,'SMTP Password','smtp_pass','',110,'If SMTP authentication is enabled, this value specifies the password that will be used during SMTP authentication.','text',26,'');
INSERT INTO settings VALUES (161,'Use SMTP?','use_smtp','1',110,'If set to \"yes,\" DeskPRO will use the following settings to directly send mail via an SMTP mail server as specified. If set to \"no,\" DeskPRO will send mail using PHP\'s built-in mail() function. SMTP is generally more flexible than mail(), but in some instances, an SMTP server may not be available.','radio',20,'');
INSERT INTO settings VALUES (162,'Desired Timezone','timezone_offset','0',113,'This setting specifies how many hours away from Greenwich Mean Time (GMT) your server runs. For example, if you\'re in Pacific Standard Time (PST), enter \"-8\".','text',0,'');
INSERT INTO settings VALUES (163,'Max New Tickets','max_new','12',112,'This setting is the maximum amount of tickets that a user can create in an hour. It should be slightly larger than the max_emails_warning variab','text',0,'');
INSERT INTO settings VALUES (164,'User Disabled Attachment Types','user_disabled_attachments','',6,'This specifies a list of extensions that DeskPRO will refuse for attachments uploaded by users. Specify this in a comma-separated list. Leave blank to disable.','text',0,'');
INSERT INTO settings VALUES (165,'User Enabled Attachment Types','user_extensions_allowed','',6,'This specifies a list of extensions that DeskPRO will permit for attachments uploaded by users. Specify this in a comma-separated list. If left blank, all attachments will be accepted, if any attachments are entered then nothing apart from those attachments will be accepted.','text',0,'');
INSERT INTO settings VALUES (171,'Max Error Emails','max_error_emails','5',112,'The maximum error emails sent to a user in 1 hour period. Another method to prevent an autoresponder loop.','text',0,'');
INSERT INTO settings VALUES (173,'CSS: Default Text Font','css_default_font','tahoma, verdana, geneva, lucida, \'lucida grande\', arial, helvetica, sans-serif',117,'This setting specifies the font to use for \"default\" text in the user interface. This includes any text element whose font is not specified elsewhere. This must be a CSS-compliant string -- a list of fonts, each entry separated by a comma.','text',0,'');
INSERT INTO settings VALUES (174,'CSS: Default Text Size','css_default_size','11px',117,'This setting specifies the font size to use for \"default\" text in the user interface. This includes any text element whose font size is not specified elsewhere. This must be a CSS-compliant string, such as \"11px\".','text',0,'');
INSERT INTO settings VALUES (175,'CSS: Default Link Color (inactive)','css_link_inactive_color','#424242',117,'This setting specifies the color of all \"default\", inactive (not being clicked, etc.) links in the user interface. This must be a CSS-compliant string -- an HTML-format color.','text',0,'');
INSERT INTO settings VALUES (176,'CSS: Default Link Color (active)','css_link_active_color','#BF4444',117,'This setting specifies the color of all \"default\", active (hovered or clicked) links in the user interface. This must be a CSS-compliant string -- an HTML-format color.','text',0,'');
INSERT INTO settings VALUES (177,'CSS: Default Element Color','css_default_element_color','#000000',117,'This setting specifies the color of all SELECT, INPUT, and TEXTAREA form elements in the user interface. This must be a CCS-compliant string -- an HTML-format color.','text',0,'');
INSERT INTO settings VALUES (178,'CSS: Emphasized Text Color','css_emphasis_color','#BF4343',117,'This setting specifies the color of emphasized text elements in the user interface. This must be a CSS-compliant string -- an HTML-format color.','text',0,'');
INSERT INTO settings VALUES (179,'CSS: Title Font','css_title_font','Arial, Helvetica, sans-serif',117,'This setting specifies the font used for all title elements in the user interface. This must be a CSS-compliant string -- a list of fonts, each separated by a comma.','text',0,'');
INSERT INTO settings VALUES (180,'CSS: Title Font Size','css_title_size','15px',117,'This setting specifies the font size used for all title elements in the user interface. This must be a CSS-compliant string, such as \"15px\".','text',0,'');
INSERT INTO settings VALUES (181,'CSS: Light Text Color','css_light_color','#BF4444',117,'This setting specifies the font color used for all \"light\" text elements in the user interface. This must be a CSS-compliant string -- an HTML-format color.','text',0,'');