<?php
// +-------------------------------------------------------------+
// | HiveMail™ version 1.3.1
// +-------------------------------------------------------------+
// | HIVEMAIL™ IS NOT FREE SOFTWARE
// | If you have downloaded this software from a website other
// | than Hivemail or if you have otherwise received
// | this software from someone who is not a representative of
// | this organization you are involved in an illegal activity.
// +-------------------------------------------------------------+
// +-------------------------------------------------------------+

// ############################################################################
// Table structure
$tables[9] = array(
);

// ############################################################################
// Records
$inserts[9] = array(
	'INSERT INTO hive_settinggroup SET settinggroupid = 20, title = "Subscription Settings", description = "subs", display = 0',
	'INSERT INTO hive_setting SET title = "PayPal Email Address", settinggroupid = 20, description = "If you have a PayPal account and are going to use it to accept payments for subscriptions, enter your PayPal account\'s email address.", variable = "subs_paypalemail", value = "", type = "text", display = 1',
	'INSERT INTO hive_setting SET title = "2Checkout Seller ID", settinggroupid = 20, description = "If you have a 2Checkout account and are going to use it to accept payments for subscriptions, enter the seller ID that 2Checkout has assigned to you.", variable = "subs_2cosellerid", value = "", type = "text", display = 2',
	'INSERT INTO hive_setting SET title = "2Checkout Secret Key", settinggroupid = 20, description = "If you have a 2Checkout account and are going to use it to accept payments for subscriptions, enter the Secret Key that you selected in the 2Checkout admin panel. (It\'s located at the bottom of the \"Return\" settings page.)", variable = "subs_2cosecretkey", value = "", type = "text", display = 3',
	'UPDATE hive_setting SET description = "The full path to the directory in which the message files will be stored. It is STRONGLY recommended that this directory not be below the \"web root\", so users will not be able to access the files directly. PHP must have write permission in this folder, i.e CHMOD 0777.<br />NOTE: If you change this setting, you must rename the original directory to reflect the change. The script will not do this for you." WHERE variable="flat_path"',
	'UPDATE hive_setting SET description = "The server that holds the POP3 account. If you are not sure what the mail server is, contact your host and ask them." WHERE variable="pop3_server"',
	'UPDATE hive_setting SET description = "The port that\'s used to connect to the mail server above; this is usually 110." WHERE variable="pop3_port"',
	'UPDATE hive_setting SET description = "Use this setting to control how many users can simultaneously use the system. Concurrent users are determined from averages over 15 minute periods. Set to 0 to disable this feature.<br /> You can set individual user groups to override this setting." WHERE variable="maxonline"',
	'UPDATE hive_setting SET description = "Turn this off if you do not want to accept new users.<br /> Note that if you are using vBulletin integration, you must leave this on even if you only accept new users who sign up through your vBulletin, but you can disable registration through HiveMail in the \'Allow regular registration\' setting below." WHERE variable="regopen"',
	'UPDATE hive_setting SET description = "Whenever a new user registers, an email notification will be sent to these addresses.<br />Separate address with space or new line.<br />The message and subject of this email can be edited in the <i>signup_notify_subject</i> and <i>signup_notify_message</i> templates." WHERE variable="newuseremail"',
	'UPDATE hive_setting SET description = "Turn this on to send a welcome email to all new users.<br />The message and subject of this email can be edited in the <i>signup_welcome_subject</i> and <i>signup_welcome_message</i> templates." WHERE variable="sendgreeting"',
	'UPDATE hive_setting SET description = "If you would like outside links (in emails) to open in a new window with a top frame that will allow users to return to the message they were reading, enable this option. Otherwise outside links will open in their own window." WHERE variable="framelinks"',
	'UPDATE hive_setting SET description = "Turn this on to give users the option to bounce a message back to its\' sender, so it looks like the message never reached the user." WHERE variable="allowbouncing"',
	'UPDATE hive_setting SET description = "The address that users need to connect to in order to read their mail via the POP3 protocol in an external mail client." WHERE variable="hivepop_serveraddr"',
	'UPDATE hive_setting SET description = "The port number that should be used to connect to the HivePOP3 server. (This must be the same as the <i>Listen</i> setting in HivePOP3.conf.)" WHERE variable="hivepop_serverport"',
	'UPDATE hive_setting SET description = "Enter the absolute path to the folder that contains the message and data files. (This must be the same as the <i>MailRoot</i> setting in HivePOP3.conf.)" WHERE variable="hivepop_path"',
	'UPDATE hive_setting SET description = "Allow users to store incoming messages in their online mailbox as well as in the HivePOP3 account?", display = 5 WHERE variable="hivepop_allowdupe"',
	'UPDATE hive_setting SET description = "Any addresses you enter here will be blocked for all users, <i>even</i> if they are defined as \"safe\" for a user. Please use with care!<br />Wildcards may be used. Specify one email address per line. Use just a domain name (e.g \"yourdomain.c0m\") to block all messages from that domain." WHERE variable="globalblock"',
	'UPDATE hive_setting SET description = "Addresses that you add here will never be blocked for any user in the system, <i>even</i> if the user would like to block it. Useful, for example, if you don\'t want users to ignore emails from the webmaster.<br />Wildcards may be used. Specify one email address per line. Use just a domain name (e.g \"yourdomain.c0m\") to block all messages from that domain." WHERE variable="globalsafe"',
	'UPDATE hive_setting SET description = "If you would like to ignore messages that are sent to certain addresses, write down those addresses here. This can be a list of just names (i.e \"nobody\") or full email address (i.e \"nobody@yourdomain.c0m\"). Wildcards may be used. Separate addresses and names with space or a new line." WHERE variable="ignore_addys"',
	'UPDATE hive_setting SET description = "Format for displaying the date.<br />For example: \"F j, Y\" will display July 1, 2002. \"m-d-Y\" will display 07-01-2002.<br />The syntax is identical to that of the PHP <a href=\"http://www.php.net/date\" target=\"_blank\">date function</a>." WHERE variable="dateformat"',
	'UPDATE hive_setting SET description = "Format for displaying the time.<br />For example: \"H:i\" will display 15:49. \"h:i A\" will display 03:49 PM.<br />The syntax is identical to that of the PHP <a href=\"http://www.php.net/date\" target=\"_blank\">date function</a>." WHERE variable="timeformat"',
	'UPDATE hive_setting SET description = "HiveMail&trade; will contact this time server to synchronize the time every 24 hours. This will allow HiveMail&trade; to automatically correct the time of the server it is running on, based on the time from that was received from the time server. Leave this field empty to disable this feature. A full list of available time servers is available <a href=\"http://www.bldrdoc.gov/timefreq/service/time-servers.html\" target=\"_blank\">here</a>." WHERE variable="time_server"',
	'UPDATE hive_setting SET description = "HiveMail&trade; can open one connection to the SMTP server when sending multiple messages, which reduces the load on the server and improves performance. However, some SMTP server do not support this feature and will not allow HiveMail&trade; to stay connected, and as a result messages may not be sent correctly. If you are experiencing such problems, please disable this option." WHERE variable="stmp_persistent"',
	'UPDATE hive_setting SET description = "Messages that are sent to non-existent users will be forwarded to this user. Enter only the username, not the full email address. If you would like to bounce such messages back to the sender, please leave this setting empty." WHERE variable="catchalluser"',
	'UPDATE hive_setting SET description = "The level of GZIP compression, from 1 to 9. The higher the level is, the better the compression rate, but above 1, the performance costs start to outweigh any benefits. 0 means no compression at all. We strongly recommend that you do set this above 1 for performance reasons." WHERE variable="gzip_level"',
	'UPDATE hive_setting SET description = "Turn this on to enable integration with vBulletin version 3.0.0 or higher. You must first read install documents and make the necessary changes to vBulletin. If this is enabled please be sure to fill in the rest of the settings in this category." WHERE variable="vb_use"',
	'UPDATE hive_setting SET description = "The complete URL of your forums. This is the same as the one you input in vBulletin\'s control panel. Please do not add a trailing slash." WHERE variable="vb_url"',
	'UPDATE hive_setting SET description = "If this is set to Yes, the system will generate a statistics display for the main page of the Admin Control Panel. Depending on how many users and messages your system has, this may take a while (up to several minutes) to generate, so you may wish to disable it." WHERE variable="cp_showstats"',
	'UPDATE hive_setting SET title = "Leave messages on server" WHERE variable="pop3_nodelete"',
	'UPDATE hive_setting SET title = "Temporary directory for attachments" WHERE variable="tmppath"',
	'UPDATE hive_setting SET display = 1 WHERE variable="cp_templatetree"',
	'UPDATE hive_setting SET display = 2 WHERE variable="cp_links"',
	'UPDATE hive_setting SET display = 3 WHERE variable="cp_showannouncements"',
	'UPDATE hive_setting SET display = 4 WHERE variable="cp_showstats"',
	'UPDATE hive_setting SET display = 4 WHERE variable="hivepop_path"',
	'UPDATE hive_setting SET display = 1 WHERE variable="maintain"',
	'UPDATE hive_setting SET display = 7 WHERE variable="defaultskin"',
	'UPDATE hive_setting SET display = 5 WHERE variable="useredirect"',
	'DELETE FROM hive_setting WHERE variable="cp_topmenu"',
	'DELETE FROM hive_setting WHERE variable="cp_plus"',
);

?>