settings.sql

jsp程序开发系统

INSERT INTO settings VALUES (1,'Allow Registrations','allow_registration','1',2,'If set to \"yes,\" users can register new accounts. If set to \"no,\" no new users can create accounts on your helpdesk (existing users are unaffected).','radio',2,'');
INSERT INTO settings VALUES (170,'Time Display Format','date_time','g:i a',113,'DeskPRO uses this value to format \"time\" date displays (used when just the time is to be displayed). This is based on the specification shown PHP manual.','text',0,'');
INSERT INTO settings VALUES (4,'Send Autoresponse for New Tickets','email_autonew','1',8,'If set to \"yes\", a confirmation will be sent to users when they create a new ticket via the web interface.','radio',1,'');
INSERT INTO settings VALUES (5,'Contact Email Address','email_offemail','contact@yourdomain',8,'This specifies the address of an administrator who can be notified of problems. The address is also shown to users when DeskPRO encounters a problem. It is very important that this email is checked.','text',4,'');
INSERT INTO settings VALUES (6,'From: address','email_from','DO_NOT_REPLY@yourdomain',8,'If you are using the email gateway, notification emails that are not about a specific ticket will be sent from this email address (for example faq subscription emails). If you are not using the email gateway, all emails sent by DeskPRO will be sent from this email. (Note there are a number of exceptions for which other settings control the from: email address).','text',3,'');
INSERT INTO settings VALUES (8,'The URL to DeskPRO','helpdesk_url','hxxp://www.yourdomain/',1,'This setting specifies the base URL your users will use to access your DeskPRO installation. This is used to generate links within DeskPRO\'s interface. In most cases, the installation and upgrade scripts\' autodetected value are correct.','text',2,'');
INSERT INTO settings VALUES (9,'Your Site URL','site_url','hxxp://yourdomain.c0m/2',1,'This setting specifies the URL to your company\'s main web site. This is not DeskPRO\'s URL, but just a link of convenience to make available to your users. They can click this link to exit your support pages and return here. This can be any link you desire; it does not affect DeskPRO\'s behavior.','text',1,'');
INSERT INTO settings VALUES (10,'Your Site Name','site_name','yourdomain.c0m',1,'This setting specifies the human-readable name DeskPRO will display on the pages it generates, and in some e-mails it sends.','text',3,'');
INSERT INTO settings VALUES (11,'Require Registrations','require_registration','0',2,'If set to \"yes,\" users must create an account before submitting tickets (no \"anonymous\" tickets are permitted).','radio',1,'');
INSERT INTO settings VALUES (13,'Allow Users to Upload Attachments','attachments_user','1',6,'Do you wish to allow attachments to be uploaded by users of DeskPro.','radio',1,'');
INSERT INTO settings VALUES (14,'Notify an Admin Upon New Registration','email_registeradmin','',8,'Enter emails for anyone you wish to be notified by new user registrations (seperate with commas).','text',5,'');
INSERT INTO settings VALUES (128,'Email Bounce','email_bounce','',8,'If an email sent by DeskPRO is bounced by the user because their accout is full or the email is wrong, where would you like this bounce notification sent?','text',0,'');
INSERT INTO settings VALUES (17,'Tickets Per Page','ticket_number','20',3,'This is the number of tickets (by default) to display per page on ticket searches run by your technicians. This also affects the number of items shown per page on the calendar.','text',1,'');
INSERT INTO settings VALUES (18,'Maximum Attachment Size for Users','attachments_user_size','1',6,'This value specifies the maximum size (in megabytes) an attachment can be when uploaded by a user.','text',2,'');
INSERT INTO settings VALUES (19,'Max Attachment Size for Technicians','attachments_tech_size','1',6,'This value specifies the maximum size (in megabytes) an attachment can be when uploaded by a technician.','text',4,'');
INSERT INTO settings VALUES (20,'Date Display Format','date_full','D, jS M Y g:i a',113,'DeskPRO uses this value to format \"full\" date displays (used when both the date and time are to be displayed). This is based on the specification shown PHP manual.','text',1,'');
INSERT INTO settings VALUES (21,'Send Autoresponse for Ticket Replies','email_autoreply','1',8,'If set to \"yes\", a confirmation will be sent to users when they submit a reply to a ticket view the web interface.','radio',2,'');
INSERT INTO settings VALUES (166,'Cron Hour','cron_hour','1076',111,'Used internally to determine when to run the cron script','text',0,'');
INSERT INTO settings VALUES (167,'Category Columns','faq_columns','4',5,'The number of columns used to display knowledgebase categories.','text',0,'');
INSERT INTO settings VALUES (25,'Technician Reply-to: Address','email_tech','tech@yourdomain',100,'This specifies the address to use in the \"Reply-to:\" field of e-mails sent to technicians (so they can reply to tickets via e-mail).','text',5,'');
INSERT INTO settings VALUES (168,'Enable Tech -> User email gateway','send_email_gateway','0',116,'Enabling this gateway allows technicians to send emails through DeskPRO and have any replies tracked. You should only enable this once you have configured DeskPRO to collect these emails.','radio',0,'');
INSERT INTO settings VALUES (169,'Tech -> User email','tech_send_email','',116,'This is the email address that a user would reply to when receiving an email through the Tech -> User gateway. It is this email you should be pipeing to techmail.php or being collected via POP3.','text',0,'');
INSERT INTO settings VALUES (49,'Maximum Message Size','max_size','50000',4,'This value specifies the largest message (in bytes) DeskPRO will accept for a ticket message or reply. Messages larger than this value will be rejected. This is useful in preventing users from attempting to \"overload\" the installation by submitting huge messages repeatedly.','text',2,'');
INSERT INTO settings VALUES (50,'Allow User Ticket Reopening','user_reopen','1',4,'If set to \"yes,\" your users can re-open tickets when your technicians close them. If you select \"no,\" users cannot re-open tickets once they\'ve been closed.','radio',3,'');
INSERT INTO settings VALUES (52,'Max Replies Warning','max_reply_warning','5',112,'This specified the maximum replies that can be made in an hour to a ticket before a user is marked as autoresponding and is warned. Note that if a tech replies to the ticket the number is reset.','text',5,'');
INSERT INTO settings VALUES (51,'Use Email Interface','use_email','0',100,'Selecting \"Yes\" here will enable DeskPRO\'s e-mail gateway interface, permitting your users and technicians to submit tickets (and respond to them) via e-mail. Your email templates will automatically be updated to show users how to reply to tickets.','radio',1,'');
INSERT INTO settings VALUES (56,'Require Registration','gateway_require_reg','0',100,'If this is set to \"yes,\" users must first be registered on your helpdesk before they can submit tickets via e-mail. If set to \"no,\" anyone can submit a ticket via e-mail, whether registered or not.','radio',7,'');
INSERT INTO settings VALUES (57,'Short Date Display Format','date_day','D, dS M Y',113,'DeskPRO uses this value to format \"short\" date displays (used when just the date is to be displayed). This is based on the specification shown PHP manual.','text',2,'');
INSERT INTO settings VALUES (60,'Reopen Closed Tickets','gateway_ticket_reopen','1',100,'If you specify \"yes\" here, if a reply is sent (via e-mail) to a closed ticket, DeskPRO will automatically re-open the ticket. Otherwise, the mail will be rejected (since the ticket is already closed).','radio',9,'');
INSERT INTO settings VALUES (68,'Enable User Language Choice','language_on','1',10,'If set to \"yes\", your users will be able to change the deskpro interface to the languages you have enabled in the <a href=\"languages.php\">language section</a>.','radio',0,'');
INSERT INTO settings VALUES (69,'Validate Email Upon Registration','validate_email','0',2,'If set to \"yes,\" users are sent a confirmation e-mail before they can submit new tickets.','radio',0,'');
INSERT INTO settings VALUES (71,'Default Language','default_language','1',111,'The default language','text',0,'');
INSERT INTO settings VALUES (79,'Tech Disabled Attachment Types','tech_disabled_attachments','',6,'This specifies a list of extensions that DeskPRO will refuse for attachments uploaded by technicians. Specify this in a comma-separated list. Leave blank to disable.','text',0,'');
INSERT INTO settings VALUES (78,'Tech Enabled Attachment Types','tech_extensions_allowed','',6,'This specifies a list of extensions that DeskPRO will permit for attachments uploaded by technicians. 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 (97,'Session Length','session_length','3600',108,'This setting determines the length, in seconds, a session can idle before it is expired.','text',0,'');
INSERT INTO settings VALUES (82,'Send Welcome Email','register_welcome','1',2,'If set to \"yes\", DeskPRO will send a confirmation message to new users when they register containing their username and password. Note that if you are requring user validation then an email will be sent irrespective of this setting.','radio',0,'');
INSERT INTO settings VALUES (155,'SMTP Host','smtp_host','localhost',110,'If SMTP mailing is enabled, this value specifies the server to use for SMTP mailing.','text',21,'');
INSERT INTO settings VALUES (84,'Allow users to submit new FAQ entries for moderation','faq_new','1',5,'If set to \"yes,\" your users can submit new articles for your FAQ system, to be moderated by a technician later.','radio',0,'');
INSERT INTO settings VALUES (85,'Permit Users to Rate Articles?','faq_rating','1',5,'If set to \"yes,\" your users can rate your FAQ articles and submit comments about them.','radio',0,'');
INSERT INTO settings VALUES (159,'SMTP Username','smtp_user','',110,'If SMTP authentication is enabled, this value specifies the username that will be used during SMTP authentication.','text',25,'');
INSERT INTO settings VALUES (87,'Length of time new/updated','faq_days','14',5,'This value specifies how long articles remain marked \"new\" in the FAQ.','text',0,'');
INSERT INTO settings VALUES (88,'Technical Email Address','technical_email','technic@yourdomain.c0m',8,'This is the email address any urgent errors generated by DeskPRO will be sent to. It is important that you set this email address and monitor it.','text',0,'');
INSERT INTO settings VALUES (90,'Show Categories to User','category_user_viewable','1',106,'If this is enabled, your users will be shown what category their tickets have been assigned to.','radio',0,'');
INSERT INTO settings VALUES (91,'Categories User Selectable','category_user_editable','1',106,'If this is enabled, your users will be allowed to edit what category their tickets are been assigned to.','radio',0,'');
INSERT INTO settings VALUES (92,'Require Category Selection','category_require_selection','1',106,'If this is enabled, all tickets must be assigned to a category.','radio',0,'');
INSERT INTO settings VALUES (93,'Disable Priorities','priority_disable','0',107,'If you don\'t want to use priorities at all, set this to \"yes.\"','radio',0,'');