<?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 = array (
  'hive_adminlog' => 'CREATE TABLE hive_adminlog (
  adminlogid int(10) unsigned NOT NULL auto_increment,
  dateline int(10) unsigned NOT NULL default \'0\',
  do varchar(200) NOT NULL default \'\',
  filename varchar(200) NOT NULL default \'\',
  userid int(10) unsigned NOT NULL default \'0\',
  id int(10) unsigned NOT NULL default \'0\',
  success tinyint(4) NOT NULL default \'-1\',
  notes text NOT NULL,
  ipaddress varchar(20) NOT NULL default \'\',
  PRIMARY KEY  (adminlogid),
  UNIQUE KEY adminlogid (adminlogid)
) TYPE=MyISAM',
  'hive_alias' => 'CREATE TABLE hive_alias (
  aliasid int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default \'0\',
  alias varchar(255) NOT NULL default \'\',
  PRIMARY KEY  (aliasid),
  UNIQUE KEY alias (alias),
  KEY userid (userid)
) TYPE=MyISAM',
  'hive_ban' => 'CREATE TABLE hive_ban (
  banid int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default \'0\',
  adminid int(10) unsigned NOT NULL default \'0\',
  dateline int(10) unsigned NOT NULL default \'0\',
  duration int(11) NOT NULL default \'0\',
  reason mediumtext NOT NULL,
  PRIMARY KEY  (banid),
  KEY userid (userid)
) TYPE=MyISAM',
  'hive_cart' => 'CREATE TABLE hive_cart (
  cartid int(10) unsigned NOT NULL auto_increment,
  planid int(10) unsigned NOT NULL default \'0\',
  userid int(10) unsigned NOT NULL default \'0\',
  dateline int(10) unsigned NOT NULL default \'0\',
  PRIMARY KEY  (cartid),
  KEY dateline (dateline)
) TYPE=MyISAM',
  'hive_contact' => 'CREATE TABLE hive_contact (
  contactid int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default \'0\',
  usergroupids varchar(100) NOT NULL default \'\',
  email varchar(100) NOT NULL default \'\',
  emailinfo text NOT NULL,
  name varchar(255) NOT NULL default \'\',
  nameinfo text NOT NULL,
  birthday date NOT NULL default \'0000-00-00\',
  timezone float NOT NULL default \'0\',
  webpage varchar(200) NOT NULL default \'\',
  notes text NOT NULL,
  addressinfo mediumtext NOT NULL,
  phoneinfo mediumtext NOT NULL,
  PRIMARY KEY  (contactid),
  KEY userid (userid)
) TYPE=MyISAM',
  'hive_contactgroup' => 'CREATE TABLE hive_contactgroup (
  contactgroupid int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default \'0\',
  title varchar(255) NOT NULL default \'\',
  contacts text NOT NULL,
  PRIMARY KEY  (contactgroupid),
  KEY userid (userid)
) TYPE=MyISAM',
  'hive_cplink' => 'CREATE TABLE hive_cplink (
  cplinkid smallint(5) unsigned NOT NULL auto_increment,
  title varchar(255) NOT NULL default \'\',
  url varchar(255) NOT NULL default \'\',
  display tinyint(3) unsigned NOT NULL default \'0\',
  newwin tinyint(3) unsigned NOT NULL default \'1\',
  PRIMARY KEY  (cplinkid),
  UNIQUE KEY cplinkid (cplinkid)
) TYPE=MyISAM',
  'hive_distlist' => 'CREATE TABLE hive_distlist (
  distlistid smallint(5) unsigned NOT NULL auto_increment,
  toalias varchar(100) NOT NULL default \'\',
  recipients mediumtext NOT NULL,
  PRIMARY KEY  (distlistid)
) TYPE=MyISAM',
  'hive_draft' => 'CREATE TABLE hive_draft (
  draftid int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default \'0\',
  dateline int(10) unsigned NOT NULL default \'0\',
  data mediumtext NOT NULL,
  PRIMARY KEY  (draftid),
  KEY dateline (dateline,userid)
) TYPE=MyISAM',
  'hive_emailid' => 'CREATE TABLE hive_emailid (
  userid int(10) unsigned NOT NULL default \'0\',
  emailid varchar(255) NOT NULL default \'\',
  KEY userid (userid),
  KEY emailid (emailid)
) TYPE=MyISAM',
  'hive_event' => 'CREATE TABLE hive_event (
  eventid int(10) unsigned NOT NULL auto_increment,
  userid int(10) NOT NULL default \'0\',
  title varchar(255) NOT NULL default \'\',
  message mediumtext NOT NULL,
  addresses mediumtext NOT NULL,
  eventtype int(10) NOT NULL default \'0\',
  from_date int(10) unsigned NOT NULL default \'0\',
  to_date int(10) unsigned NOT NULL default \'0\',
  to_date_real int(10) unsigned NOT NULL default \'0\',
  from_time time NOT NULL default \'00:00:00\',
  to_time time NOT NULL default \'00:00:00\',
  allday tinyint(1) unsigned NOT NULL default \'0\',
  type tinyint(3) unsigned NOT NULL default \'0\',
  options varchar(20) NOT NULL default \'\',
  maxtimes smallint(5) unsigned NOT NULL default \'0\',
  aliasids mediumtext NOT NULL,
  shareoptions int(10) unsigned NOT NULL default \'0\',
  notes mediumtext NOT NULL,
  PRIMARY KEY  (eventid),
  KEY userdate (userid,to_date_real,from_date)
) TYPE=MyISAM',
  'hive_eventlog' => 'CREATE TABLE hive_eventlog (
  eventlogid int(10) unsigned NOT NULL auto_increment,
  dateline int(10) unsigned NOT NULL default \'0\',
  userid int(10) unsigned NOT NULL default \'0\',
  level tinyint(3) unsigned NOT NULL default \'0\',
  event smallint(5) unsigned default NULL,
  debuginfo text,
  PRIMARY KEY  (eventlogid),
  KEY userid (userid)
) TYPE=MyISAM',
  'hive_field' => 'CREATE TABLE hive_field (
  fieldid int(10) unsigned NOT NULL auto_increment,
  title varchar(50) NOT NULL default \'\',
  description text NOT NULL,
  module set(\'user\',\'book\') NOT NULL default \'user\',
  type varchar(15) NOT NULL default \'text\',
  display smallint(6) unsigned NOT NULL default \'0\',
  required tinyint(3) unsigned NOT NULL default \'0\',
  min smallint(5) unsigned NOT NULL default \'0\',
  max smallint(5) unsigned NOT NULL default \'0\',
  width tinyint(3) unsigned NOT NULL default \'0\',
  perline smallint(5) unsigned NOT NULL default \'0\',
  height tinyint(3) unsigned NOT NULL default \'0\',
  defvalue varchar(255) NOT NULL default \'\',
  signup tinyint(3) unsigned NOT NULL default \'0\',
  error text NOT NULL,
  data text NOT NULL,
  custom tinyint(3) unsigned NOT NULL default \'0\',
  PRIMARY KEY  (fieldid),
  KEY dispmod (display,module)
) TYPE=MyISAM',
  'hive_fieldinfo' => 'CREATE TABLE hive_fieldinfo (
  fieldid int(10) unsigned NOT NULL default \'0\',
  userid int(10) unsigned NOT NULL default \'0\',
  contactid int(10) unsigned NOT NULL default \'0\',
  choices varchar(255) NOT NULL default \'\',
  value text NOT NULL,
  dateline int(10) unsigned NOT NULL default \'0\',
  PRIMARY KEY  (fieldid,userid,contactid),
  KEY userid (userid)
) TYPE=MyISAM',
  'hive_folder' => 'CREATE TABLE hive_folder (
  folderid int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default \'0\',
  title varchar(50) NOT NULL default \'\',
  msgcount int(10) unsigned NOT NULL default \'0\',
  display smallint(5) unsigned NOT NULL default \'0\',
  PRIMARY KEY  (folderid),
  UNIQUE KEY folderid (folderid),
  KEY userid (userid)
) TYPE=MyISAM',
  'hive_hash' => 'CREATE TABLE hive_hash (
  hashid int(10) unsigned NOT NULL auto_increment,
  type tinyint(3) unsigned NOT NULL default \'0\',
  value varchar(32) NOT NULL default \'\',
  info mediumtext NOT NULL,
  PRIMARY KEY  (hashid),
  KEY value (value)
) TYPE=MyISAM',
  'hive_iplog' => 'CREATE TABLE hive_iplog (
  iplogid int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned default \'0\',
  datefirstseen int(10) unsigned default \'0\',
  datelastseen int(10) unsigned default \'0\',
  ipaddr varchar(16) default \'0\',
  PRIMARY KEY  (iplogid),
  KEY userid (userid)
) TYPE=MyISAM',
  'hive_language' => 'CREATE TABLE hive_language (
  languageid int(10) unsigned NOT NULL auto_increment,
  title varchar(100) NOT NULL default \'\',
  phrases text NOT NULL,
  userselectable tinyint(3) unsigned NOT NULL default \'0\',
  textdir char(3) NOT NULL default \'\',
  langcode varchar(20) NOT NULL default \'\',
  htmlcharset varchar(40) NOT NULL default \'\',
  emailcharset varchar(40) NOT NULL default \'\',
  dateformat varchar(30) NOT NULL default \'\',
  timeformat varchar(30) NOT NULL default \'\',
  cal_use24 tinyint(3) unsigned NOT NULL default \'0\',
  PRIMARY KEY  (languageid)
) TYPE=MyISAM',
  'hive_message' => 'CREATE TABLE hive_message (
  messageid int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default \'0\',
  folderid int(11) NOT NULL default \'0\',
  dateline int(10) unsigned NOT NULL default \'0\',
  email varchar(255) NOT NULL default \'\',
  name varchar(255) NOT NULL default \'\',
  subject varchar(255) NOT NULL default \'\',
  message longtext NOT NULL,
  recipients text NOT NULL,
  attach tinyint(4) NOT NULL default \'0\',
  flagged tinyint(3) unsigned NOT NULL default \'0\',
  status smallint(5) unsigned NOT NULL default \'0\',
  emailid varchar(255) NOT NULL default \'\',
  priority tinyint(3) unsigned NOT NULL default \'3\',
  bgcolor varchar(15) NOT NULL default \'\',
  popid int(10) unsigned NOT NULL default \'0\',
  size int(10) unsigned NOT NULL default \'0\',
  popsize int(10) unsigned NOT NULL default \'0\',
  uniquestr varchar(15) NOT NULL default \'\',
  source longtext NOT NULL,
  notes text NOT NULL,
  PRIMARY KEY  (messageid),
  KEY userfolder (userid,folderid)
) TYPE=MyISAM',
  'hive_messagefile' => 'CREATE TABLE hive_messagefile (
  filename varchar(65) NOT NULL default \'\',
  messages int(10) unsigned NOT NULL default \'0\',
  PRIMARY KEY  (filename),
  UNIQUE KEY filename (filename)
) TYPE=MyISAM',
  'hive_payment' => 'CREATE TABLE hive_payment (
  paymentid int(10) unsigned NOT NULL auto_increment,
  planid smallint(5) unsigned NOT NULL default \'0\',
  subscriptionid int(10) unsigned NOT NULL default \'0\',
  userid int(10) unsigned NOT NULL default \'0\',
  processor varchar(10) NOT NULL default \'\',
  dateline int(10) unsigned NOT NULL default \'0\',
  remoteid varchar(150) NOT NULL default \'\',
  amount float NOT NULL default \'0\',
  pseudo tinyint(3) unsigned NOT NULL default \'0\',
  trial tinyint(3) unsigned NOT NULL default \'0\',
  refunddate int(10) unsigned NOT NULL default \'0\',
  debuginfo mediumtext NOT NULL,
  PRIMARY KEY  (paymentid),
  UNIQUE KEY remoteid (remoteid,processor),
  KEY subscriptionid (subscriptionid),
  KEY userid (userid)
) TYPE=MyISAM',
  'hive_phrase' => 'CREATE TABLE hive_phrase (
  phraseid int(10) unsigned NOT NULL auto_increment,
  phraseareaid int(10) unsigned NOT NULL default \'0\',
  languageid int(10) NOT NULL default \'0\',
  variable varchar(200) NOT NULL default \'\',
  value text NOT NULL,
  PRIMARY KEY  (phraseid)
) TYPE=MyISAM PACK_KEYS=0',
  'hive_phrasegroup' => 'CREATE TABLE hive_phrasegroup (
  phrasegroupid int(10) unsigned NOT NULL auto_increment,
  phraseareaid int(10) unsigned NOT NULL default \'0\',
  title varchar(100) NOT NULL default \'\',
  PRIMARY KEY  (phrasegroupid)
) TYPE=MyISAM',
  'hive_plan' => 'CREATE TABLE hive_plan (
  planid smallint(5) unsigned NOT NULL auto_increment,
  name varchar(50) NOT NULL default \'\',
  usergroupid smallint(5) unsigned NOT NULL default \'0\',
  fromusergroups varchar(100) NOT NULL default \'\',
  processors varchar(255) NOT NULL default \'\',
  description mediumtext NOT NULL,
  cost float NOT NULL default \'0\',
  length mediumint(8) unsigned NOT NULL default \'0\',
  unit char(1) NOT NULL default \'m\',
  canpayadvance tinyint(3) unsigned NOT NULL default \'1\',
  trial tinyint(3) unsigned NOT NULL default \'0\',
  triallength mediumint(8) unsigned NOT NULL default \'0\',
  triallengthunit char(1) NOT NULL default \'m\',
  reminder mediumint(8) unsigned NOT NULL default \'0\',
  PRIMARY KEY  (planid)
) TYPE=MyISAM',
  'hive_pop' => 'CREATE TABLE hive_pop (
  popid int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default \'0\',
  accountname varchar(25) NOT NULL default \'\',
  displayname varchar(50) NOT NULL default \'\',
  displayemail varchar(100) NOT NULL default \'\',
  server varchar(75) NOT NULL default \'\',
  username varchar(50) NOT NULL default \'\',
  password text NOT NULL,
  port varchar(10) NOT NULL default \'110\',
  autopoll tinyint(3) unsigned NOT NULL default \'1\',
  deletemails tinyint(3) unsigned NOT NULL default \'1\',
  folderid int(11) NOT NULL default \'-1\',
  color varchar(20) NOT NULL default \'none\',
  smtp_server varchar(75) NOT NULL default \'\',
  smtp_port varchar(10) NOT NULL default \'25\',
  smtp_username varchar(50) NOT NULL default \'\',
  smtp_password text NOT NULL,
  replyto varchar(100) NOT NULL default \'\',
  usessl tinyint(3) unsigned NOT NULL default \'0\',
  UNIQUE KEY popid (popid),
  KEY userid (userid)
) TYPE=MyISAM',
  'hive_report' => 'CREATE TABLE hive_report (
  reportid int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default \'0\',
  opendate int(10) unsigned NOT NULL default \'0\',
  closedate int(10) unsigned NOT NULL default \'0\',
  email varchar(255) NOT NULL default \'\',
  name varchar(255) NOT NULL default \'\',
  subject varchar(255) NOT NULL default \'\',
  source mediumtext NOT NULL,
  reason mediumtext NOT NULL,
  PRIMARY KEY  (reportid),
  KEY email (email)
) TYPE=MyISAM',
  'hive_response' => 'CREATE TABLE hive_response (
  responseid int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default \'0\',
  name varchar(50) NOT NULL default \'\',
  response text NOT NULL,
  isdefault tinyint(3) unsigned NOT NULL default \'1\',
  response_tagless text NOT NULL,
  UNIQUE KEY autoresponsesid (responseid),
  KEY userid (userid)
) TYPE=MyISAM',
  'hive_rule' => 'CREATE TABLE hive_rule (
  ruleid int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default \'0\',
  cond varchar(255) NOT NULL default \'\',
  action varchar(255) NOT NULL default \'\',
  active tinyint(3) unsigned NOT NULL default \'1\',
  display smallint(5) unsigned NOT NULL default \'0\',
  allowoverride tinyint(3) unsigned NOT NULL default \'1\',
  UNIQUE KEY ruleid (ruleid),
  KEY userid (userid)
) TYPE=MyISAM',
  'hive_search' => 'CREATE TABLE hive_search (
  searchid int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default \'0\',
  dateline int(10) unsigned NOT NULL default \'0\',
  data mediumtext NOT NULL,
  UNIQUE KEY searchid (searchid),
  KEY dateline (dateline)
) TYPE=MyISAM',
  'hive_setting' => 'CREATE TABLE hive_setting (
  settingid smallint(5) unsigned NOT NULL auto_increment,
  grouptitle varchar(20) NOT NULL default \'\',
  title varchar(50) NOT NULL default \'\',
  description text NOT NULL,
  variable varchar(100) NOT NULL default \'\',
  value mediumtext NOT NULL,
  type varchar(250) NOT NULL default \'\',
  typeoptions mediumtext NOT NULL,
  display tinyint(3) unsigned NOT NULL default \'0\',
  PRIMARY KEY  (settingid),
  UNIQUE KEY variable (variable),
  KEY optiongroupid (grouptitle)
) TYPE=MyISAM',
  'hive_settinggroup' => 'CREATE TABLE hive_settinggroup (
  grouptitle varchar(20) NOT NULL default \'\',
  title varchar(50) NOT NULL default \'\',
  description text NOT NULL,
  display tinyint(3) NOT NULL default \'0\',
  UNIQUE KEY optiongroupid (grouptitle)
) TYPE=MyISAM',
  'hive_sig' => 'CREATE TABLE hive_sig (
  sigid int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default \'0\',
  name varchar(50) NOT NULL default \'\',
  signature text NOT NULL,
  isdefault tinyint(3) unsigned NOT NULL default \'1\',
  signature_tagless text NOT NULL,
  UNIQUE KEY sigid (sigid),
  KEY userid (userid)
) TYPE=MyISAM',
  'hive_skin' => 'CREATE TABLE hive_skin (
  skinid smallint(6) NOT NULL auto_increment,
  title varchar(25) NOT NULL default \'\',
  templatesetid smallint(5) unsigned NOT NULL default \'0\',
  vars longtext NOT NULL,
  UNIQUE KEY skinid (skinid)
) TYPE=MyISAM',
  'hive_sound' => 'CREATE TABLE hive_sound (
  soundid int(10) unsigned NOT NULL auto_increment,
  userid int(11) NOT NULL default \'0\',
  title varchar(50) NOT NULL default \'\',
  filename varchar(100) NOT NULL default \'\',
  data mediumtext NOT NULL,
  UNIQUE KEY soundid (soundid),
  KEY userid (userid)
) TYPE=MyISAM',
  'hive_subscription' => 'CREATE TABLE hive_subscription (
  subscriptionid int(10) unsigned NOT NULL auto_increment,
  planid smallint(5) unsigned NOT NULL default \'0\',
  userid int(10) unsigned NOT NULL default \'0\',
  oldusergroup smallint(5) unsigned NOT NULL default \'0\',
  processor varchar(10) NOT NULL default \'\',
  active tinyint(3) unsigned NOT NULL default \'1\',
  payments tinyint(3) unsigned NOT NULL default \'0\',
  startdate int(10) unsigned NOT NULL default \'0\',
  lastpaydate int(10) unsigned NOT NULL default \'0\',
  expirydate int(11) NOT NULL default \'0\',
  PRIMARY KEY  (subscriptionid),
  KEY planid (planid),
  KEY expirydate (expirydate)
) TYPE=MyISAM',
  'hive_subscriptionlog' => 'CREATE TABLE hive_subscriptionlog (
  subscriptionid int(10) unsigned NOT NULL default \'0\',
  action tinyint(3) unsigned NOT NULL default \'0\',
  dateline int(10) unsigned NOT NULL default \'0\',
  pseudo tinyint(3) unsigned NOT NULL default \'0\',
  KEY subscriptionid (subscriptionid)
) TYPE=MyISAM',
  'hive_temp' => 'CREATE TABLE hive_temp (
  tempid int(10) unsigned NOT NULL auto_increment,
  tempdata text NOT NULL,
  PRIMARY KEY  (tempid)
) TYPE=MyISAM',
  'hive_template' => 'CREATE TABLE hive_template (
  templateid int(10) unsigned NOT NULL auto_increment,
  title varchar(50) NOT NULL default \'\',
  templatesetid smallint(6) NOT NULL default \'0\',
  templategroupid smallint(5) unsigned NOT NULL default \'0\',
  user_data mediumtext NOT NULL,
  parsed_data mediumtext NOT NULL,
  backup_data mediumtext NOT NULL,
  upgraded tinyint(3) unsigned NOT NULL default \'0\',
  UNIQUE KEY templateid (templateid),
  KEY titleset (title,templatesetid)
) TYPE=MyISAM',
  'hive_templategroup' => 'CREATE TABLE hive_templategroup (
  templategroupid smallint(5) unsigned NOT NULL auto_increment,
  title varchar(25) NOT NULL default \'\',
  display smallint(5) unsigned NOT NULL default \'0\',
  description text NOT NULL,
  UNIQUE KEY templategroupid (templategroupid)
) TYPE=MyISAM',
  'hive_templateset' => 'CREATE TABLE hive_templateset (
  templatesetid smallint(5) unsigned NOT NULL auto_increment,
  title varchar(25) NOT NULL default \'\',
  UNIQUE KEY templatesetid (templatesetid)
) TYPE=MyISAM',
  'hive_user' => 'CREATE TABLE hive_user (
  userid int(10) unsigned NOT NULL auto_increment,
  username varchar(35) NOT NULL default \'\',
  password varchar(32) NOT NULL default \'\',
  regipaddr varchar(15) NOT NULL default \'\',
  altemail varchar(200) NOT NULL default \'\',
  usergroupid smallint(5) unsigned NOT NULL default \'0\',
  skinid smallint(5) unsigned NOT NULL default \'0\',
  languageid int(10) unsigned NOT NULL default \'0\',
  realname varchar(50) NOT NULL default \'\',
  regdate int(10) unsigned NOT NULL default \'0\',
  lastvisit int(10) unsigned NOT NULL default \'0\',
  lastactivity int(10) unsigned NOT NULL default \'0\',
  timezone float NOT NULL default \'0\',
  emptybin smallint(6) NOT NULL default \'-1\',
  lastbinempty int(10) unsigned NOT NULL default \'0\',
  blocked text NOT NULL,
  safe text NOT NULL,
  forward varchar(50) NOT NULL default \'\',
  notifyemail varchar(50) NOT NULL default \'\',
  autorefresh smallint(5) unsigned NOT NULL default \'0\',
  cols varchar(255) NOT NULL default \'\',
  birthday date NOT NULL default \'0000-00-00\',
  question varchar(200) NOT NULL default \'\',
  answer varchar(32) NOT NULL default \'\',
  country char(2) NOT NULL default \'ot\',
  state char(2) NOT NULL default \'ot\',
  zip varchar(10) NOT NULL default \'\',
  font varchar(200) NOT NULL default \'\',
  sendread tinyint(4) NOT NULL default \'1\',
  options int(10) unsigned NOT NULL default \'0\',
  options2 int(10) unsigned NOT NULL default \'0\',
  haspop tinyint(3) unsigned NOT NULL default \'0\',
  perpage smallint(5) unsigned NOT NULL default \'15\',
  replyto varchar(100) NOT NULL default \'\',
  replychar varchar(15) NOT NULL default \'\',
  preview varchar(10) NOT NULL default \'none\',
  soundid int(10) unsigned NOT NULL default \'0\',
  spamaction tinyint(4) default \'-4\',
  forumuserid int(10) unsigned NOT NULL default \'0\',
  spampass varchar(50) NOT NULL default \'\',
  domain varchar(255) NOT NULL default \'\',
  markread tinyint(3) unsigned NOT NULL default \'0\',
  fieldcache mediumtext NOT NULL,
  aliases mediumtext NOT NULL,
  aliaslog mediumtext NOT NULL,
  weekstart tinyint(3) unsigned NOT NULL default \'0\',
  lastsent int(10) unsigned NOT NULL default \'0\',
  lastpassword int(10) unsigned NOT NULL default \'0\',
  adminnotes mediumtext NOT NULL,
  calreminder tinyint(3) unsigned NOT NULL default \'0\',
  defcompose varchar(45) NOT NULL default \'\',
  draftcache mediumtext NOT NULL,
  foldercache mediumtext NOT NULL,
  subexpiry int(10) unsigned NOT NULL default \'0\',
  savetopop tinyint(3) unsigned NOT NULL default \'0\',
  lastexpirynotice int(10) unsigned NOT NULL default \'0\',
  UNIQUE KEY userid (userid),
  KEY visitgroup (lastvisit,usergroupid),
  KEY username (username),
  KEY lastactivity (lastactivity),
  KEY regdate (regdate)
) TYPE=MyISAM',
  'hive_usergroup' => 'CREATE TABLE hive_usergroup (
  usergroupid smallint(5) unsigned NOT NULL auto_increment,
  title varchar(25) NOT NULL default \'\',
  maxmb float NOT NULL default \'0\',
  groupsig_text text NOT NULL,
  groupsig_html text NOT NULL,
  allowedskins varchar(250) NOT NULL default \'\',
  perms int(10) unsigned NOT NULL default \'0\',
  maxattach float NOT NULL default \'0\',
  maxsigs smallint(5) unsigned NOT NULL default \'0\',
  maxcontacts smallint(5) unsigned NOT NULL default \'0\',
  maxresponses smallint(5) unsigned NOT NULL default \'0\',
  maxrecips smallint(5) unsigned NOT NULL default \'0\',
  emptytime smallint(5) unsigned NOT NULL default \'0\',
  removetime smallint(5) unsigned NOT NULL default \'0\',
  notifytime varchar(50) NOT NULL default \'\',
  maxaliases smallint(5) unsigned NOT NULL default \'0\',
  msgpersec varchar(255) NOT NULL default \'\',
  changepass smallint(5) unsigned NOT NULL default \'0\',
  permlink varchar(100) NOT NULL default \'\',
  maxpopstorage float NOT NULL default \'0\',
  PRIMARY KEY  (usergroupid)
) TYPE=MyISAM',
  'hive_word' => 'CREATE TABLE hive_word (
  userid int(10) unsigned NOT NULL default \'0\',
  word char(50) NOT NULL default \'\',
  metaphone char(50) NOT NULL default \'\',
  PRIMARY KEY  (userid,word)
) TYPE=MyISAM',
);

// ############################################################################
// Records
$inserts = array (
  0 => 'INSERT INTO hive_cplink SET title = \'HiveMail\', url = \'http://www.yourdomain.c0m/\', display = 1, newwin = 1',
  1 => 'INSERT INTO hive_cplink SET title = \'HiveMail&trade; Support\', url = \'#\', display = 2, newwin = 1',
  2 => 'INSERT INTO hive_cplink SET title = \'HiveMail&trade; Forums\', url = \'#\', display = 3, newwin = 1',
  3 => 'INSERT INTO hive_cplink SET title = \'PHP Manual\', url = \'http://www.php.net/manual/en/\', display = 5, newwin = 1',
  4 => 'INSERT INTO hive_cplink SET title = \'MySQL Manual\', url = \'http://www.mysql.com/doc/en/\', display = 6, newwin = 1',
  5 => 'INSERT INTO hive_cplink SET title = \'HiveMail&trade; Manual\', url = \'#\', display = 4, newwin = 1',
  6 => 'INSERT INTO hive_language SET title = \'English\', userselectable = 1, textdir = \'ltr\', langcode = \'en\', htmlcharset = \'ISO-8859-1\', emailcharset = \'iso-8859-1\', dateformat = \'\', timeformat = \'\', cal_use24 = 0',
  8 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'global_event\', value = \'Global Event\'',
  9 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'shared_event\', value = \'Shared Event\'',
  10 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'x_added_to_userlist_by_x\', value = \'{1} added to userlist by {2}\'',
  11 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'preferences\', value = \'Preferences\'',
  12 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'calendar_options\', value = \'Calendar Options\'',
  13 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'send_new_mail\', value = \'Send New Mail\'',
  14 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'spell_checker\', value = \'Spell Checker\'',
  15 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'move_up\', value = \'Move Up\'',
  16 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'move_down\', value = \'Move Down\'',
  17 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'folder_management\', value = \'Folder Management\'',
  18 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'and\', value = \'and\'',
  19 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'unread_message\', value = \'unread message\'',
  20 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'unread_messages\', value = \'unread messages\'',
  21 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'in_your\', value = \'in your\'',
  22 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'folder\', value = \'folder\'',
  23 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'top\', value = \'top\'',
  24 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'bottom\', value = \'bottom\'',
  25 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'aliases\', value = \'Aliases\'',
  26 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'autoresponder\', value = \'Autoresponder\'',
  27 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'compose_options\', value = \'Compose Options\'',
  28 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'folder_view_options\', value = \'Folder View Options\'',
  29 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'general_options\', value = \'General Options\'',
  30 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'password_and_security\', value = \'Password and Security\'',
  31 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'personal_information\', value = \'Personal Information\'',
  32 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'reading_options\', value = \'Reading Options\'',
  33 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'signatures\', value = \'Signatures\'',
  34 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'subscription_options\', value = \'Subscription Options\'',
  35 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'no_subject\', value = \'no subject\'',
  36 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'message_high_priority\', value = \'This message is high priority\'',
  37 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'message_low_priority\', value = \'This message is low priority\'',
  38 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'pop_accounts\', value = \'POP Accounts\'',
  39 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'read_mail\', value = \'Read Mail\'',
  40 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'copy_it_to_folder\', value = \'copy it to folder\'',
  41 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'move_it_to_folder\', value = \'move it to folder\'',
  42 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'highlight_it_in\', value = \'highlight it in\'',
  43 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'message_rules\', value = \'Message Rules\'',
  44 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'apply_rule\', value = \'Apply Rule\'',
  45 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'search_messages\', value = \'Search Messages\'',
  46 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'sign_up\', value = \'Sign Up\'',
  47 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'unread\', value = \'unread\'',
  48 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'total\', value = \'total\'',
  49 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'last_x_unread_messages_in_folder\', value = \'Last {1} unread messages in folder\'',
  50 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'from\', value = \'From\'',
  51 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'subject\', value = \'Subject\'',
  52 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'link\', value = \'Link\'',
  53 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'no_unread_in_folder\', value = \'No unread messages in this folder\'',
  54 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'last_checked_at_x\', value = \'Last checked at {1}\'',
  55 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'folder_inbox\', value = \'Inbox\'',
  56 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'folder_sentitems\', value = \'Sent Items\'',
  57 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'folder_trashcan\', value = \'Trash Can\'',
  58 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'folder_junkmail\', value = \'Junk Mail\'',
  59 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'rich_text_mode\', value = \'Rich Text Mode\'',
  60 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'plain_text_mode\', value = \'Plain Text Mode\'',
  61 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'when\', value = \'when\'',
  62 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'email_address\', value = \'email address\'',
  63 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'message\', value = \'message\'',
  64 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'recipients\', value = \'recipients\'',
  65 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'equals\', value = \'equals\'',
  66 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'contains\', value = \'contains\'',
  67 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'does_not_contain\', value = \'does not contain\'',
  68 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'begins_with\', value = \'begins with\'',
  69 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'ends_with\', value = \'ends with\'',
  70 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'email_is_from_account\', value = \'email is from account\'',
  71 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'delete_it\', value = \'delete it\'',
  72 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'mark_it_as_read\', value = \'mark it as read\'',
  73 => 'INSERT INTO hive_phrase SET phraseareaid = 1, languageid = -1, variable = \'flag_it\', value = \'flag it\'',
  74 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'day_sun_long\', value = \'Sunday\'',
  75 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'day_mon_long\', value = \'Monday\'',
  76 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'day_tue_long\', value = \'Tuesday\'',
  77 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'day_wed_long\', value = \'Wednesday\'',
  78 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'day_thu_long\', value = \'Thursday\'',
  79 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'day_fri_long\', value = \'Friday\'',
  80 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'day_sat_long\', value = \'Saturday\'',
  81 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'day_sun_short\', value = \'S\'',
  82 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'day_mon_short\', value = \'M\'',
  83 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'day_tue_short\', value = \'T\'',
  84 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'day_wed_short\', value = \'W\'',
  85 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'day_thu_short\', value = \'T\'',
  86 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'day_fri_short\', value = \'F\'',
  87 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'day_sat_short\', value = \'S\'',
  88 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_jan_long\', value = \'January\'',
  89 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_jan_short\', value = \'Jan\'',
  90 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_feb_long\', value = \'February\'',
  91 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_feb_short\', value = \'Feb\'',
  92 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_mar_long\', value = \'March\'',
  93 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_mar_short\', value = \'Mar\'',
  94 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_apr_long\', value = \'April\'',
  95 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_apr_short\', value = \'Apr\'',
  96 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_may_long\', value = \'May\'',
  97 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_may_short\', value = \'May\'',
  98 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_jun_long\', value = \'June\'',
  99 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_jun_short\', value = \'Jun\'',
  100 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_jul_long\', value = \'July\'',
  101 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_jul_short\', value = \'July\'',
  102 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_aug_long\', value = \'August\'',
  103 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_aug_short\', value = \'Aug\'',
  104 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_sep_long\', value = \'September\'',
  105 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_sep_short\', value = \'Sep\'',
  106 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_oct_long\', value = \'October\'',
  107 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_oct_short\', value = \'Oct\'',
  108 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_nov_long\', value = \'November\'',
  109 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_nov_short\', value = \'Nov\'',
  110 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_dec_long\', value = \'December\'',
  111 => 'INSERT INTO hive_phrase SET phraseareaid = 2, languageid = -1, variable = \'month_dec_short\', value = \'Dec\'',
  112 => 'INSERT INTO hive_phrasegroup SET phraseareaid = 1, title = \'Global\'',
  113 => 'INSERT INTO hive_phrasegroup SET phraseareaid = 2, title = \'Calendar\'',
  114 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Application name\', description = \'This is the name of the program that will be running. It will be viewable on every page.\', variable = \'appname\', value = \'HiveMail 13\', type = \'text\', typeoptions = \'\', display = 2',
  115 => 'INSERT INTO hive_setting SET grouptitle = \'registration\', title = \'Open for registration\', description = \'Turn this off if you do not want to accept new users.<br />\\nNote 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.\', variable = \'regopen\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 1',
  116 => 'INSERT INTO hive_setting SET grouptitle = \'registration\', title = \'Require new user validation\', description = \'If this is turned on, users will not be able to use HiveMail&trade; until you activate their account. Otherwise, after registering the user\\\'s account will be activated immediately.\', variable = \'moderate\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 2',
  117 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Default skin\', description = \'This is the default skin that will be used when a user is not logged in or when a user first registers.\', variable = \'defaultskin\', value = 1, type = \'select\', typeoptions = \'hive_skin\', display = 6',
  118 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Domain names\', description = \'The domain name HiveMail&trade; is running on, with a preceding \\\'@\\\' character.<br />To specify multiple domain names, put each one on its own line.<br />The first domain name on the list is the primary one.<br /><br />For example:<br />@yourdomain.c0m<br />@yourdomain.net\', variable = \'domainname\', value = \'\', type = \'textarea\', typeoptions = \'\', display = 4',
  119 => 'INSERT INTO hive_setting SET grouptitle = \'user\', title = \'Threshold for storage gauge\', description = \'The space gauge will not show up for users until they hit this minimum percentage.<br />It is recommended to set this to a high value, such as 80. Do not include \\\'%\\\'.\', variable = \'minpercentforgauge\', value = 80, type = \'text\', typeoptions = \'\', display = 6',
  120 => 'INSERT INTO hive_setting SET grouptitle = \'datetime\', title = \'Date format\', 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>.\', variable = \'dateformat\', value = \'m-d-Y\', type = \'text\', typeoptions = \'\', display = 2',
  121 => 'INSERT INTO hive_setting SET grouptitle = \'datetime\', title = \'Time format\', 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>.\', variable = \'timeformat\', value = \'h:i A\', type = \'text\', typeoptions = \'\', display = 3',
  122 => 'INSERT INTO hive_setting SET grouptitle = \'fileg\', title = \'Path to the mail messages\', description = \'Please enter the path to where the mail is kept on your system. If you are accessing an mbox-formatted account, enter the complete path to the file in which messages are saved. In the case of MH or Maildir, only enter the directory in which the files are kept.\', variable = \'fg_path\', value = \'\', type = \'text\', typeoptions = \'\', display = 2',
  123 => 'INSERT INTO hive_setting SET grouptitle = \'pop3g\', title = \'Mail server\', description = \'The server that holds the POP3 account. If you are not sure what the mail server is, contact your host and ask them.\', variable = \'pop3_server\', value = \'\', type = \'text\', typeoptions = \'\', display = 2',
  124 => 'INSERT INTO hive_setting SET grouptitle = \'pop3g\', title = \'Server port\', description = \'The port that\\\'s used to connect to the mail server above; this is usually 110.\', variable = \'pop3_port\', value = 110, type = \'text\', typeoptions = \'\', display = 3',
  125 => 'INSERT INTO hive_setting SET grouptitle = \'pop3g\', title = \'Username\', description = \'The username that is used to log on to the mail server and connect to the POP3 account.\', variable = \'pop3_username\', value = \'\', type = \'text\', typeoptions = \'\', display = 4',
  126 => 'INSERT INTO hive_setting SET grouptitle = \'pop3g\', title = \'Password\', description = \'The password that is used to log on to the mail server and connect to the POP3 account.\', variable = \'pop3_password\', value = \'\', type = \'text\', typeoptions = \'\', display = 5',
  127 => 'INSERT INTO hive_setting SET grouptitle = \'pop3o\', title = \'Use IMAP functions\', description = \'If PHP on this server is compiled with the IMAP extension, HiveMail&trade; can use it to connect to outside POP3 accounts. Turning this option on will also allow your users to connect to POP3 servers that require SSL authorization, something that otherwise would not be possible.\', variable = \'pop3_useimap\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 8',
  128 => 'INSERT INTO hive_setting SET grouptitle = \'email\', title = \'Sender Name\', description = \'The name that\\\'s sent as the \\\'From\\\' header when sending bounces or other messages through the system.<br />This can be an email address only (e.g mail@yourdomain.c0m) or a name with the email address enclosed in < and > (e.g Mail Delivery System &lt;mail@yourdomain.com&gt;).\', variable = \'smtp_errorfrom\', value = \'Mail Delivery System <postmaster@kevin>\', type = \'text\', typeoptions = \'\', display = 1',
  129 => 'INSERT INTO hive_setting SET grouptitle = \'processing\', title = \'Forward postmaster to administrator\', description = \'If this is enabled messages sent to the postmaster address will be forwarded the first administrator account, unless a user with the name postmaster exists.\', variable = \'fwdpostmaster\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 7',
  130 => 'INSERT INTO hive_setting SET grouptitle = \'user\', title = \'Maximum messages per page\', description = \'Set this to the maximum number of mail messages users can request to see per page.\', variable = \'maxperpage\', value = 50, type = \'text\', typeoptions = \'\', display = 1',
  131 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Program location\', description = \'The complete URL (without any trailing slashes) of the program, e.g: http://www.yourdomain.c0m/webmail.\', variable = \'appurl\', value = \'\', type = \'text\', typeoptions = \'\', display = 3',
  132 => 'INSERT INTO hive_setting SET grouptitle = \'datetime\', title = \'Time zone offset\', description = \'The time (in hours) this server is offset from GMT. Please select the most appropriate option.<br />For a complete list of time zones, please <a href=\\"http://greenwichmeantime.com/info/timezone.htm\\" target=\\"_blank\\">click here</a>.\', variable = \'timeoffset\', value = -5, type = \'timezone\', typeoptions = \'\', display = 1',
  133 => 'INSERT INTO hive_setting SET grouptitle = \'internal\', title = \'Last time POP3 was checked\', description = \'Do not touch.\', variable = \'pop3_lastrun\', value = 1091563976, type = \'text\', typeoptions = \'\', display = 0',
  134 => 'INSERT INTO hive_setting SET grouptitle = \'pop3g\', title = \'Check the account every:\', description = \'The frequency for checking the POP3 account for messages, in minutes.<br />Set this to 0 to check the account whenever a user visits the system (not advisable).\', variable = \'pop3_runevery\', value = 2, type = \'text\', typeoptions = \'\', display = 6',
  135 => 'INSERT INTO hive_setting SET grouptitle = \'pop3g\', title = \'Using cron job script?\', description = \'If you are using the cron script, set this to Yes. If this is set to Yes, email will not be checked from within the program but only using the cron job script.<br />Note: You need to set up the script yourself, this is not automatic!\', variable = \'pop3_cron\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 1',
  136 => 'INSERT INTO hive_setting SET grouptitle = \'registration\', title = \'Send new users a greeting message\', 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.\', variable = \'sendgreeting\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 6',
  137 => 'INSERT INTO hive_setting SET grouptitle = \'registration\', title = \'Reserved names\', description = \'Text in this setting (one entry per line) will not be allowed in usernames or real names. This can contain wildcards. Examples:<br />\\nadmin* - name beginning with admin<br />\\n*hive* - name containing hive<br />\\n*site - name ending in site<br />\\nweb*master - name beginning with web and ending in master (including webmaster)\', variable = \'reservedtext\', value = \'admin*\\n*master\', type = \'textarea\', typeoptions = \'\', display = 4',
  138 => 'INSERT INTO hive_setting SET grouptitle = \'user\', title = \'Maximum size of sound files (in bytes)\', description = \'This is the maximum file size of custom sound files users can upload. 1024 bytes = 1kb.\', variable = \'maxsoundfile\', value = 102400, type = \'text\', typeoptions = \'\', display = 2',
  139 => 'INSERT INTO hive_setting SET grouptitle = \'reading\', title = \'Self-referenced attachments\', description = \'Sometimes messages contain attachments that are used inside the message itself (background images, sounds, etc.). This option allows you to enable this self-reference, but unfortunately this behavior is sometimes used by viruses. This is why we give you the option to disable this feature altogether.\', variable = \'allowcid\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 1',
  140 => 'INSERT INTO hive_setting SET grouptitle = \'registration\', title = \'Notification of new users\', 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.\', variable = \'newuseremail\', value = \'\', type = \'textarea\', typeoptions = \'\', display = 7',
  141 => 'INSERT INTO hive_setting SET grouptitle = \'pop3o\', title = \'Maximum messages to process\', description = \'This is the maximum number of messages that are processed every time a connection is made to a POP3 account.\', variable = \'pop3_maxmsgs\', value = 50, type = \'text\', typeoptions = \'\', display = 9',
  142 => 'INSERT INTO hive_setting SET grouptitle = \'admincp\', title = \'Enable enhanced template tree\', description = \'Whether or not the dynamic template tree will be used in the template editor. This feature may only work in certain browsers.\', variable = \'cp_templatetree\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 1',
  143 => 'INSERT INTO hive_setting SET grouptitle = \'pop3g\', title = \'Leave messages on server\', description = \'If this is set to yes, messages will be left on the server even after HiveMail&trade; downloads them. We strongly recommended that you leave this option turned off.\', variable = \'pop3_nodelete\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 7',
  144 => 'INSERT INTO hive_setting SET grouptitle = \'internal\', title = \'HiveMail&trade; Version\', description = \'Don\\\'t touch!\', variable = \'versionnum\', value = 1.3, type = \'text\', typeoptions = \'\', display = 0',
  145 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Use redirection messages\', description = \'HiveMail&trade; displays redirection messages when users perform an action that requires processing. You can disable these messages here, and then your users will be redirected immediately, without any confirmation for their action.\', variable = \'useredirect\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 5',
  146 => 'INSERT INTO hive_setting SET grouptitle = \'safemode\', title = \'Upload attachments in safe mode\', description = \'If your server is running in Safe Mode or if open_basedir restrictions are in effect, enable this option and update the setting below.\', variable = \'safeupload\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 1',
  147 => 'INSERT INTO hive_setting SET grouptitle = \'safemode\', title = \'Temporary directory for attachments\', description = \'If you enable uploads in Safe Mode, this must be set to the folder in which the attachments will be <i>temporarily</i> stored. PHP must have write permission in this folder, i.e CHMOD 0777.\', variable = \'tmppath\', value = \'/tmp\', type = \'text\', typeoptions = \'\', display = 2',
  148 => 'INSERT INTO hive_setting SET grouptitle = \'registration\', title = \'Terms of Service\', description = \'If the service you offer has any terms, enter them in this box. When users sign up, they will be required to agree to these terms.\', variable = \'termsofservice\', value = \'\', type = \'textarea\', typeoptions = \'\', display = 5',
  149 => 'INSERT INTO hive_setting SET grouptitle = \'registration\', title = \'Registration code check\', description = \'Turning this on will force users to enter a random number, as it appears in an image. This protection method drastically reduces the chances of having a machine create new accounts automatically.\', variable = \'regcodecheck\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 8',
  150 => 'INSERT INTO hive_setting SET grouptitle = \'registration\', title = \'Use the same effect for all numbers\', description = \'If you enable the registration code check above, users will be presented with a series of random images. Each image uses a different effect to \\"hide\\" the number from machines. However, you have the option to use the same effect on all numbers. This will make it somewhat easier for users to enter the number, but at the same time also make it easier for automatic bots to detect the number.\', variable = \'regcodesameset\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 9',
  151 => 'INSERT INTO hive_setting SET grouptitle = \'reading\', title = \'Open links in frames\', 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.\', variable = \'framelinks\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 2',
  152 => 'INSERT INTO hive_setting SET grouptitle = \'reading\', title = \'Allow manual bouncing\', 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.\', variable = \'allowbouncing\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 3',
  153 => 'INSERT INTO hive_setting SET grouptitle = \'processing\', title = \'DNS Blocking Lists\', description = \'If you wish to use anti-spam DNS blocking lists, please input each server you would like e-mail checked against. One entry per line.<br />\\nE.g. relays.osirusoft.com\', variable = \'dnsbls\', value = \'\', type = \'textarea\', typeoptions = \'\', display = 4',
  154 => 'INSERT INTO hive_setting SET grouptitle = \'processing\', title = \'Global blocked senders\', 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.\', variable = \'globalblock\', value = \'\', type = \'textarea\', typeoptions = \'\', display = 2',
  155 => 'INSERT INTO hive_setting SET grouptitle = \'processing\', title = \'Global safe senders\', 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.\', variable = \'globalsafe\', value = \'\', type = \'textarea\', typeoptions = \'\', display = 3',
  156 => 'INSERT INTO hive_setting SET grouptitle = \'admincp\', title = \'Display quick links\', description = \'Whether or not to show the list of quick links in the control panel navigation. You can edit those links <a href=\\"cplink.php\\">here</a>.\', variable = \'cp_links\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 2',
  157 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Maintenance mode\', description = \'During maintenance mode, users can only login and logout - they cannot use any other functions. Useful for when you upgrading the program or performing back-ups. Administrators are unaffected by this setting.\', variable = \'maintain\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 1',
  158 => 'INSERT INTO hive_setting SET grouptitle = \'storage\', title = \'Store messages in files\', description = \'Turn this on if you would like to store the message data in the file-system, and not in the database. If this is enabled, you must set the other options in this section as well for this feature to work correctly. You can ignore the rest of the options if this is disabled.\', variable = \'flat_use\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 1',
  159 => 'INSERT INTO hive_setting SET grouptitle = \'storage\', title = \'Directory to save files in\', description = \'The full path to the directory in which the message files will be stored. It is <b>STRONGLY</b> 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 /><b>NOTE:</b> If you change this setting, you must rename the original directory to reflect the change. The script will <b>not</b> do this for you.\', variable = \'flat_path\', value = \'\', type = \'text\', typeoptions = \'\', display = 2',
  160 => 'INSERT INTO hive_setting SET grouptitle = \'internal\', title = \'File prefix\', description = \'The message files will be named \\"&lt;prefix&gt;&lt;random hash&gt;.dat\\". You can set the &lt;prefix&gt; in this option, for example \\"message_\\".\', variable = \'flat_prefix\', value = \'message_\', type = \'text\', typeoptions = \'\', display = 3',
  161 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Display skin menu on login\', description = \'Whether or not to show the skin selection menu on the login screen, so users can choose a different skin while logging into their account.\', variable = \'skinonlogin\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 7',
  162 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Usergroup permissions for skin menu\', description = \'If you have turned on the skin menu above, please select the usergroup whose skin permissions will be used to determine which skins to show.\', variable = \'skinonlogingroup\', value = 2, type = \'select\', typeoptions = \'hive_usergroup\', display = 8',
  163 => 'INSERT INTO hive_setting SET grouptitle = \'user\', title = \'Automatic trash collection maximum value\', description = \'Limit the number of days for users to automatically empty their trash can.\', variable = \'maxemptybindays\', value = 30, type = \'text\', typeoptions = \'\', display = 3',
  164 => 'INSERT INTO hive_setting SET grouptitle = \'email\', title = \'Enable message bounces\', description = \'If this is turned on, messages that were sent to non-existent users will be bounced back to the sender. Otherwise, the messages will not be processed and the sender will not be notified of the error.\', variable = \'bounceback\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 2',
  165 => 'INSERT INTO hive_setting SET grouptitle = \'gzip\', title = \'Enable GZIP compression\', description = \'Whether or not to use GZIP compression, which would reduce the size of HiveMail&trade; generated pages and respectively reduce the loading time of those pages.\', variable = \'gzip_use\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 1',
  166 => 'INSERT INTO hive_setting SET grouptitle = \'gzip\', title = \'Level of compression\', description = \'The level of GZIP compression, from 1 to 9. The higher the level is, the better the compression rate but the slower it takes to compress the pages. 0 means no compression at all. We strongly recommend that you do set this above 1 for performance reasons.\', variable = \'gzip_level\', value = 1, type = \'text\', typeoptions = \'\', display = 2',
  167 => 'INSERT INTO hive_setting SET grouptitle = \'registration\', title = \'Require secondary email\', description = \'If you have enabled manual validation of new users (see above), new registrants will be required to enter a secondary email address through which they will be notified when their account is activated. You can cancel this requirement by turning off this option.\', variable = \'reg_requirealtemail\', value = 1, type = \'radio\', typeoptions = \'1||Always require//-1||Only if needed//0||Never require\', display = 3',
  168 => 'INSERT INTO hive_setting SET grouptitle = \'smtp\', title = \'Server name\', description = \'The hostname or IP address of the SMTP server you would like to use. Leave this empty to use PHP\\\'s built-in functions.\', variable = \'smtp_host\', value = \'\', type = \'text\', typeoptions = \'\', display = 1',
  169 => 'INSERT INTO hive_setting SET grouptitle = \'smtp\', title = \'Server port\', description = \'The port that\\\'s used to connect to the SMTP server above, usually this is either 25, 465, 24 or 209.\', variable = \'smtp_port\', value = 25, type = \'text\', typeoptions = \'\', display = 2',
  170 => 'INSERT INTO hive_setting SET grouptitle = \'smtp\', title = \'HELO greeting\', description = \'The \\\'greeting\\\' that will be used when connecting to the SMTP server. This setting is not very important, and is typically the same as your domain name or hostname.\', variable = \'smtp_helo\', value = \'\', type = \'text\', typeoptions = \'\', display = 3',
  171 => 'INSERT INTO hive_setting SET grouptitle = \'smtp\', title = \'Use authentication\', description = \'Whether or not the SMTP server requires authentication. If you turn this on, you must specify a username and password in	the settings below.\', variable = \'smtp_auth\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 4',
  172 => 'INSERT INTO hive_setting SET grouptitle = \'smtp\', title = \'Username\', description = \'The username that will be used for authenticating to the SMTP server. If the server requires a username and password, the setting above (Use authentication) must be turned on.\', variable = \'smtp_user\', value = \'\', type = \'text\', typeoptions = \'\', display = 5',
  173 => 'INSERT INTO hive_setting SET grouptitle = \'smtp\', title = \'Password\', description = \'The password that will be used for authenticating to the SMTP server.\', variable = \'smtp_pass\', value = \'\', type = \'text\', typeoptions = \'\', display = 6',
  174 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Allow login from domains\', description = \'If set, logins will <b>only</b> be allowed from these domains. To specify multiple domain names, put each one on its own line.<br /><br />e.g. yourdomain.c0m would allow logins from users who login at mail.yourdomain.c0m, while users who fill out a login form at example2.net will be rejected<br /><br />Leaving this box blank allows logins from any domain.\', variable = \'logindomains\', value = \'\', type = \'textarea\', typeoptions = \'\', display = 11',
  175 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Banned IP addresses or hostnames\', description = \'IP addresses or hostnames which you wish to ban from using HiveMail&trade;. Wildcards may be used. One entry per line.<br /><br />e.g. 127.* would ban all users with IP addresses beginning with 127.<br />*.yourdomain.c0m would ban all users in the yourdomain.c0m domain.\', variable = \'bannedips\', value = \'\', type = \'textarea\', typeoptions = \'\', display = 12',
  176 => 'INSERT INTO hive_setting SET grouptitle = \'smtp\', title = \'Enable keep-alive\', 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.\', variable = \'smtp_persistent\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 7',
  177 => 'INSERT INTO hive_setting SET grouptitle = \'integration\', title = \'Enable forum integration\', description = \'Turn this on to enable forum integration. Depending on which forum system you use, you may need to make additional modifications to your forums.\', variable = \'integ_use\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 1',
  178 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Default language\', description = \'Choose the default language that users will see if they are not logged in or have not chosen a specific language.\', variable = \'defaultlang\', value = 1, type = \'select\', typeoptions = \'hive_language\', display = 9',
  179 => 'INSERT INTO hive_setting SET grouptitle = \'integration\', title = \'Location of forum files\', description = \'Please enter the complete absolute path to the forum program files. This is <i>not</i> the URL to your board! If you are not sure what the path to the files is, please contact your host.\', variable = \'integ_filepath\', value = \'\', type = \'text\', typeoptions = \'\', display = 3',
  180 => 'INSERT INTO hive_setting SET grouptitle = \'integration\', title = \'URL to forums\', description = \'The complete URL of your forums. Please do not add a trailing slash.\', variable = \'integ_url\', value = \'\', type = \'text\', typeoptions = \'\', display = 4',
  181 => 'INSERT INTO hive_setting SET grouptitle = \'integration\', title = \'Allow regular registration\', description = \'Enable this option if you want to allow users to sign up for a HiveMail&trade; account only, without first obtaining a forum account.\', variable = \'integ_allownormal\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 5',
  182 => 'INSERT INTO hive_setting SET grouptitle = \'internal\', title = \'Last expiry check\', description = \'\', variable = \'last_expiry_check\', value = 1103750831, type = \'text\', typeoptions = \'\', display = 0',
  183 => 'INSERT INTO hive_setting SET grouptitle = \'internal\', title = \'Current messages subfolder\', description = \'DO NOT ALTER\', variable = \'flat_curfolder\', value = \'7a20bdab0509dfdcd7f7e1f556e63e4f\', type = \'text\', typeoptions = \'\', display = 0',
  184 => 'INSERT INTO hive_setting SET grouptitle = \'internal\', title = \'Current message count in subfolder\', description = \'DO NOT ALTER\', variable = \'flat_curcount\', value = 123, type = \'text\', typeoptions = \'\', display = 0',
  185 => 'INSERT INTO hive_setting SET grouptitle = \'pop3o\', title = \'Maximum size of processed messages\', description = \'The maximum accumulated size of all messages that are proccesed per session, in megabytes. Please note that if one message alone is larger than this limit, it will be processed alone after all other messages were cleared (unless it is bigger than maximum allowed size - see below). Set this to 0 to have messages processed in the order of their arrival without any size limits.\', variable = \'pop3_maxsize\', value = 2, type = \'text\', typeoptions = \'\', display = 10',
  186 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Cookie domain\', description = \'Domain for which cookies will be set. Leave blank to use automatic setting.<br /><br /><b>Note:</b> All domains must contain at least 2 periods (e.g. yourdomain.c0m should be written as .yourdomain.c0m)\', variable = \'cookiedomain\', value = \'\', type = \'text\', typeoptions = \'\', display = 13',
  187 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Cookie Path\', description = \'Path for which cookies will be set.\', variable = \'cookiepath\', value = \'/\', type = \'text\', typeoptions = \'\', display = 14',
  188 => 'INSERT INTO hive_setting SET grouptitle = \'user\', title = \'Maximum online users\', 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.\', variable = \'maxonline\', value = 0, type = \'text\', typeoptions = \'\', display = 14',
  189 => 'INSERT INTO hive_setting SET grouptitle = \'email\', title = \'Catch-all user\', 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.\', variable = \'catchalluser\', value = \'\', type = \'text\', typeoptions = \'\', display = 3',
  190 => 'INSERT INTO hive_setting SET grouptitle = \'processing\', title = \'Ignore messages by address\', 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.\', variable = \'ignore_addys\', value = \'nobody postmaster\', type = \'textarea\', typeoptions = \'\', display = 5',
  191 => 'INSERT INTO hive_setting SET grouptitle = \'internal\', title = \'Default user options\', description = \'Don\\\'t touch!\', variable = \'defuseroptions\', value = \'a:2:{i:0;d:879820626;i:1;d:49;}\', type = \'text\', typeoptions = \'\', display = 0',
  192 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Inbox file name\', description = \'If you change the name of the file index.php, please enter the new name here so HiveMail&trade; will know where it is located. Don\\\'t forget the extension, i.e home.php.\', variable = \'indexname\', value = \'index.php\', type = \'text\', typeoptions = \'\', display = 15',
  193 => 'INSERT INTO hive_setting SET grouptitle = \'processing\', title = \'Check for SpamAssassin flags\', description = \'If <a href=\\"http://www.spamassassin.org/\\" target=\\"_blank\\">SpamAssassin</a> is installed on the server and it is checking incoming messages, turn this on to filter messages that were marked as spam.\', variable = \'checkassassin\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 6',
  194 => 'INSERT INTO hive_setting SET grouptitle = \'internal\', title = \'Last atomic clock check\', description = \'\', variable = \'last_atomic_clock_check\', value = 0, type = \'text\', typeoptions = \'\', display = 0',
  195 => 'INSERT INTO hive_setting SET grouptitle = \'internal\', title = \'Atomic clock time difference\', description = \'\', variable = \'atomic_clock_time_diff\', value = 0, type = \'text\', typeoptions = \'\', display = 0',
  196 => 'INSERT INTO hive_setting SET grouptitle = \'datetime\', title = \'Automatically correct time\', 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>.\', variable = \'time_server\', value = \'\', type = \'text\', typeoptions = \'\', display = 4',
  197 => 'INSERT INTO hive_setting SET grouptitle = \'internal\', title = \'Email gateway type\', description = \'Do not modify!\', variable = \'gatewaytype\', value = \'pop3\', type = \'text\', typeoptions = \'\', display = 0',
  198 => 'INSERT INTO hive_setting SET grouptitle = \'fileg\', title = \'Format of the mailbox\', description = \'Choose the format of the mailbox HiveMail&trade; is going to access. If are you not sure which format is the correct one, please contact your host.\', variable = \'fg_format\', value = \'mbox\', type = \'select\', typeoptions = \'mbox||mbox//maildir||Maildir//mh||MH\', display = 1',
  199 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'New-line character\', description = \'Possible values: \\\\r\\\\n (default), \\\\n.\', variable = \'crlf\', value = \'\\\\r\\\\n\', type = \'text\', typeoptions = \'\', display = 16',
  200 => 'INSERT INTO hive_setting SET grouptitle = \'registration\', title = \'Maximum IP Usage\', description = \'Set this to a whole number to limit the number\\nof times any single IP address can be used for registration. Set it to 0 to disable.\\n(<i>Remember</i>, this may not prevent users from registering multiple times if they are using a service which provides a dynamic IP address!\\nAdditionally, it may prevent innocent users from registering if they happen to use the same ISP as other users.)\', variable = \'reg_maxipusage\', value = 0, type = \'text\', typeoptions = \'\', display = 10',
  201 => 'INSERT INTO hive_setting SET grouptitle = \'user\', title = \'Send Password to Secondary Email\', description = \'If you set this option to Yes, instead of allowing a user to reset his own password, the password will be sent to the secondary email address he provided on registration. (Therefore, if you do not require a secondary email address, this option will not work.)\', variable = \'sendpwtoalt\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 5',
  202 => 'INSERT INTO hive_setting SET grouptitle = \'processing\', title = \'Maximum message size\', description = \'Messages that are larger than this value (in megabytes) will not be processed by HiveMail&trade;, but instead sent back to the sender with a message saying that the email was too large. Set the value to 0 to disable this feature.\', variable = \'maxprocsize\', value = \'\', type = \'text\', typeoptions = \'\', display = 1',
  203 => 'INSERT INTO hive_setting SET grouptitle = \'admincp\', title = \'Display announcements\', description = \'Turn this on to display announcements from HiveMail on the control panel home page.\', variable = \'cp_showannouncements\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 3',
  204 => 'INSERT INTO hive_setting SET grouptitle = \'internal\', title = \'Last time announcements were updated\', description = \'Do not touch!\', variable = \'cp_lastannouncementcheck\', value = 1091563385, type = \'text\', typeoptions = \'\', display = 0',
  205 => 'INSERT INTO hive_setting SET grouptitle = \'internal\', title = \'Announcements cache\', description = \'\', variable = \'cp_announcementcache\', value = \'error\', type = \'text\', typeoptions = \'\', display = 0',
  206 => 'INSERT INTO hive_setting SET grouptitle = \'datetime\', title = \'Use 24-hour format\', description = \'Turn this on to use 24-hour format for calendar events.\', variable = \'cal_use24\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 5',
  207 => 'INSERT INTO hive_setting SET grouptitle = \'internal\', title = \'Last time subscriptions were audited\', description = \'Do not modify!\', variable = \'subs_lastcheck\', value = 1091563975, type = \'text\', typeoptions = \'\', display = 0',
  208 => 'INSERT INTO hive_setting SET grouptitle = \'hivepop3\', title = \'Enable HivePOP3\', description = \'Enable the functions and features of the HivePOP3 server.\', variable = \'hivepop_enabled\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 1',
  209 => 'INSERT INTO hive_setting SET grouptitle = \'hivepop3\', title = \'Server address\', description = \'The address that users need to connect to in order to read their mail via the POP3 protocol in an external mail client.\', variable = \'hivepop_serveraddr\', value = \'\', type = \'text\', typeoptions = \'\', display = 2',
  210 => 'INSERT INTO hive_setting SET grouptitle = \'hivepop3\', title = \'Server port\', 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.)\', variable = \'hivepop_serverport\', value = 1110, type = \'text\', typeoptions = \'\', display = 3',
  211 => 'INSERT INTO hive_setting SET grouptitle = \'hivepop3\', title = \'Allow duplicate storing\', description = \'Allow users to store incoming messages in their online mailbox as well as in the HivePOP3 account?\', variable = \'hivepop_allowdupe\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 5',
  212 => 'INSERT INTO hive_setting SET grouptitle = \'hivepop3\', title = \'Path to message files\', 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.)\', variable = \'hivepop_path\', value = \'\', type = \'text\', typeoptions = \'\', display = 4',
  213 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Support email address\', description = \'Enter the email address you wish to be displayed to your users as the support email address. It appears in the footer of every page as well as in the Global Address Book. (Updating this option will update the Support contact that was inserted in the Global Address Book during installation.)\', variable = \'supportemail\', value = \'\', type = \'text\', typeoptions = \'\', display = 17',
  214 => 'INSERT INTO hive_setting SET grouptitle = \'admincp\', title = \'Show statistics on index\', 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.\', variable = \'cp_showstats\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 4',
  215 => 'INSERT INTO hive_setting SET grouptitle = \'subs\', title = \'PayPal Email Address\', 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\', typeoptions = \'\', display = 1',
  216 => 'INSERT INTO hive_setting SET grouptitle = \'subs\', title = \'2Checkout Seller ID\', 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\', typeoptions = \'\', display = 2',
  217 => 'INSERT INTO hive_setting SET grouptitle = \'subs\', title = \'2Checkout Secret Key\', 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\', typeoptions = \'\', display = 3',
  218 => 'INSERT INTO hive_setting SET grouptitle = \'registration\', title = \'Send greeting message as HTML\', description = \'Turn this on to send the welcome email for new users, should you enable that option, in HTML format. Please remember to format the message template, signup_welcome_message, as HTML.\', variable = \'sendgreeting_html\', value = 0, type = \'radio\', typeoptions = \'yesno\', display = 6',
  219 => 'INSERT INTO hive_setting SET grouptitle = \'email\', title = \'Mailer name\', description = \'This name will be included as a hidden header with every email that your users send.\', variable = \'mailer_name\', value = \'HiveMail\', type = \'text\', typeoptions = \'\', display = 1',
  220 => 'INSERT INTO hive_setting SET grouptitle = \'integration\', title = \'Forum system\', description = \'Choose the forum system that you are enabling integration with.\', variable = \'integ_system\', value = \'vb3\', type = \'select\', typeoptions = \'vb3||vBulletin 3.0.x//ipb13||Invision Power Board v1.2 or 1.3\', display = 2',
  221 => 'INSERT INTO hive_setting SET grouptitle = \'general\', title = \'Display language menu on login\', description = \'Whether or not to show the language selection menu on the login screen, so users can choose a different language while logging into their account. This option will override the user\\\'s default language setting for that session.\', variable = \'langonlogin\', value = 1, type = \'radio\', typeoptions = \'yesno\', display = 10',
  222 => 'INSERT INTO hive_settinggroup SET grouptitle = \'general\', title = \'General Options\', description = \'Overall options that don\\\'t fit in other groups.\', display = 1',
  223 => 'INSERT INTO hive_settinggroup SET grouptitle = \'user\', title = \'User Options\', description = \'Settings that control global user limits.\', display = 2',
  224 => 'INSERT INTO hive_settinggroup SET grouptitle = \'internal\', title = \'Internal Variables\', description = \'Do NOT edit these variables, or your HiveMail installation may stop functioning correctly.\', display = 0',
  225 => 'INSERT INTO hive_settinggroup SET grouptitle = \'pop3o\', title = \'POP3 Options\', description = \'Settings related to connecting to external POP3 accounts.\', display = 5',
  226 => 'INSERT INTO hive_settinggroup SET grouptitle = \'pipeg\', title = \'Pipe Gateway\', description = \'pipe\', display = -1',
  227 => 'INSERT INTO hive_settinggroup SET grouptitle = \'fileg\', title = \'File Gateway\', description = \'Options relating to the File Gateway method of email collection. (At the current time, the File Gateway does not function.)\', display = 0',
  228 => 'INSERT INTO hive_settinggroup SET grouptitle = \'pop3g\', title = \'POP3 Gateway\', description = \'Settings related to using the POP3 email gateway.\', display = 0',
  229 => 'INSERT INTO hive_settinggroup SET grouptitle = \'admincp\', title = \'Admin Control Panel\', description = \'The settings in this section only affect the Admin Control Panel of HiveMail&trade;.\', display = 14',
  230 => 'INSERT INTO hive_settinggroup SET grouptitle = \'email\', title = \'Email Settings\', description = \'Configuration values for sending email from the software.\', display = 10',
  231 => 'INSERT INTO hive_settinggroup SET grouptitle = \'datetime\', title = \'Time and Date\', description = \'Set the time zone offset of the server and change display formats.\', display = 8',
  232 => 'INSERT INTO hive_settinggroup SET grouptitle = \'safemode\', title = \'Safe Mode\', description = \'If PHP is running in Safe Mode you may need to modify these settings to make sure the program operates correctly.\', display = 11',
  233 => 'INSERT INTO hive_settinggroup SET grouptitle = \'registration\', title = \'Registration\', description = \'Settings related to user registration and new accounts.\', display = 3',
  234 => 'INSERT INTO hive_settinggroup SET grouptitle = \'reading\', title = \'Email Reading\', description = \'\', display = 4',
  235 => 'INSERT INTO hive_settinggroup SET grouptitle = \'processing\', title = \'Email Processing\', description = \'Settings related to processing emails and spam.\', display = 7',
  236 => 'INSERT INTO hive_settinggroup SET grouptitle = \'storage\', title = \'Message Storage\', description = \'Settings related to storing messages in files (instead of in the database).\', display = 0',
  237 => 'INSERT INTO hive_settinggroup SET grouptitle = \'gzip\', title = \'GZIP Compression\', description = \'If your server supports it, GZIP can reduce the amount of bandwidth your site uses by compressing pages before they are sent to the user\\\'s browser.\', display = 12',
  238 => 'INSERT INTO hive_settinggroup SET grouptitle = \'smtp\', title = \'SMTP Settings\', description = \'If you need to use an external SMTP server to send emails from HiveMail, fill in the details in this section.\', display = 9',
  239 => 'INSERT INTO hive_settinggroup SET grouptitle = \'integration\', title = \'Forum Integration\', description = \'HiveMail&trade; can integrate with several forum packages, including vBulletin and Invision Power Board. See the Forum Integration section of the manual for more information. If you enable forum integration, be sure to fill out all settings in this section.\', display = 13',
  240 => 'INSERT INTO hive_settinggroup SET grouptitle = \'hivepop3\', title = \'HivePOP3 Settings\', description = \'Settings related to the HivePOP3 plugin. (At the current time, the HivePOP3 plugin is not available.)\', display = 0',
  241 => 'INSERT INTO hive_settinggroup SET grouptitle = \'subs\', title = \'Subscription Settings\', description = \'Settings related to using the Subscriptions feature.\', display = 0',
  242 => 'INSERT INTO hive_skin SET title = \'Original\', templatesetid = 1, vars = \'array(\\n	\\\'doctype\\\' => \\\'<!DOCTYPE html PUBLIC \\"-//W3C//DTD XHTML 1.0 Transitional//EN\\" \\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\\">\\\',\\n	\\\'images\\\' => \\\'images\\\',\\n	\\\'body\\\' => \\\'topmargin=\\"0\\" leftmargin=\\"0\\" marginheight=\\"0\\" marginwidth=\\"0\\"\\\',\\n	\\\'fontface\\\' => \\\'Verdana, sans-serif\\\',\\n	\\\'normalsize\\\' => \\\'12px\\\',\\n	\\\'smallsize\\\' => \\\'10px\\\',\\n	\\\'tableheadfontcolor\\\' => \\\'#447892\\\',\\n	\\\'timecolor\\\' => \\\'#42517A\\\',\\n	\\\'linkhovercolor\\\' => \\\'#999999\\\',\\n	\\\'highcolor\\\' => \\\'red\\\',\\n	\\\'linkcolor\\\' => \\\'#000020\\\',\\n	\\\'border_normal_horizonal_width\\\' => \\\'1px\\\',\\n	\\\'border_normal_vertical_width\\\' => \\\'0px\\\',\\n	\\\'border_normal_edges_width\\\' => \\\'1px\\\',\\n	\\\'border_normal_color\\\' => \\\'#E1E1E1\\\',\\n	\\\'border_normal_style\\\' => \\\'solid\\\',\\n	\\\'border_header_horizonal_width\\\' => \\\'1px\\\',\\n	\\\'border_header_vertical_width\\\' => \\\'0px\\\',\\n	\\\'border_header_edges_width\\\' => \\\'1px\\\',\\n	\\\'border_header_color\\\' => \\\'#80B4DB\\\',\\n	\\\'border_header_style\\\' => \\\'solid\\\',\\n	\\\'tableheadbgcolor\\\' => \\\'#E9F3F8 url(\\\\\\\'images/tableheadbg.gif\\\\\\\')\\\',\\n	\\\'firstalt\\\' => \\\'#FAFAFA\\\',\\n	\\\'secondalt\\\' => \\\'#F0F0F0\\\',\\n	\\\'formbackground\\\' => \\\'#E1E4E5\\\',\\n	\\\'pagebgcolor\\\' => \\\'#FFFFFF\\\',\\n	\\\'folder_inbox\\\' => \\\'Inbox\\\',\\n	\\\'folder_sentitems\\\' => \\\'Sent Items\\\',\\n	\\\'folder_trashcan\\\' => \\\'Trash Can\\\',\\n	\\\'folder_junkmail\\\' => \\\'Junk Mail\\\',\\n	\\\'cal_sun_long\\\' => \\\'Sunday\\\',\\n	\\\'cal_mon_long\\\' => \\\'Monday\\\',\\n	\\\'cal_tue_long\\\' => \\\'Tuesday\\\',\\n	\\\'cal_wed_long\\\' => \\\'Wednesday\\\',\\n	\\\'cal_thu_long\\\' => \\\'Thursday\\\',\\n	\\\'cal_fri_long\\\' => \\\'Friday\\\',\\n	\\\'cal_sat_long\\\' => \\\'Saturday\\\',\\n	\\\'cal_sun_short\\\' => \\\'S\\\',\\n	\\\'cal_mon_short\\\' => \\\'M\\\',\\n	\\\'cal_tue_short\\\' => \\\'T\\\',\\n	\\\'cal_wed_short\\\' => \\\'W\\\',\\n	\\\'cal_thu_short\\\' => \\\'T\\\',\\n	\\\'cal_fri_short\\\' => \\\'F\\\',\\n	\\\'cal_sat_short\\\' => \\\'S\\\',\\n	\\\'cal_jan_long\\\' => \\\'January\\\',\\n	\\\'cal_feb_long\\\' => \\\'February\\\',\\n	\\\'cal_mar_long\\\' => \\\'March\\\',\\n	\\\'cal_apr_long\\\' => \\\'April\\\',\\n	\\\'cal_may_long\\\' => \\\'May\\\',\\n	\\\'cal_jun_long\\\' => \\\'June\\\',\\n	\\\'cal_jul_long\\\' => \\\'July\\\',\\n	\\\'cal_aug_long\\\' => \\\'August\\\',\\n	\\\'cal_sep_long\\\' => \\\'September\\\',\\n	\\\'cal_oct_long\\\' => \\\'October\\\',\\n	\\\'cal_nov_long\\\' => \\\'November\\\',\\n	\\\'cal_dec_long\\\' => \\\'December\\\',\\n	\\\'cal_jan_short\\\' => \\\'Jan\\\',\\n	\\\'cal_feb_short\\\' => \\\'Feb\\\',\\n	\\\'cal_mar_short\\\' => \\\'Mar\\\',\\n	\\\'cal_apr_short\\\' => \\\'Apr\\\',\\n	\\\'cal_may_short\\\' => \\\'May\\\',\\n	\\\'cal_jun_short\\\' => \\\'Jun\\\',\\n	\\\'cal_jul_short\\\' => \\\'Jul\\\',\\n	\\\'cal_aug_short\\\' => \\\'Aug\\\',\\n	\\\'cal_sep_short\\\' => \\\'Sep\\\',\\n	\\\'cal_oct_short\\\' => \\\'Oct\\\',\\n	\\\'cal_nov_short\\\' => \\\'Nov\\\',\\n	\\\'cal_dec_short\\\' => \\\'Dec\\\',\\n	\\\'custom1\\\' => \\\'\\\',\\n	\\\'custom2\\\' => \\\'\\\',\\n	\\\'custom3\\\' => \\\'\\\',\\n	\\\'custom4\\\' => \\\'\\\',\\n	\\\'custom5\\\' => \\\'\\\',\\n	)\'',
  243 => 'INSERT INTO hive_templategroup SET title = \'Compose Screen\', display = 4, description = \'\'',
  244 => 'INSERT INTO hive_templategroup SET title = \'General\', display = 1, description = \'\'',
  245 => 'INSERT INTO hive_templategroup SET title = \'Folder View\', display = 2, description = \'\'',
  246 => 'INSERT INTO hive_templategroup SET title = \'Address Book\', display = 5, description = \'\'',
  247 => 'INSERT INTO hive_templategroup SET title = \'Searching\', display = 7, description = \'\'',
  248 => 'INSERT INTO hive_templategroup SET title = \'Email Reading\', display = 6, description = \'\'',
  249 => 'INSERT INTO hive_templategroup SET title = \'Error Messages\', display = 8, description = \'\'',
  250 => 'INSERT INTO hive_templategroup SET title = \'Redirect Messages\', display = 9, description = \'\'',
  251 => 'INSERT INTO hive_templategroup SET title = \'Folders Management\', display = 10, description = \'\'',
  252 => 'INSERT INTO hive_templategroup SET title = \'Message Rules\', display = 11, description = \'\'',
  253 => 'INSERT INTO hive_templategroup SET title = \'Page Navigation\', display = 12, description = \'\'',
  254 => 'INSERT INTO hive_templategroup SET title = \'Miscellaneous\', display = 19, description = \'\'',
  255 => 'INSERT INTO hive_templategroup SET title = \'Preferences\', display = 14, description = \'\'',
  256 => 'INSERT INTO hive_templategroup SET title = \'Signup Process\', display = 15, description = \'\'',
  257 => 'INSERT INTO hive_templategroup SET title = \'POP Accounts Management\', display = 13, description = \'\'',
  258 => 'INSERT INTO hive_templategroup SET title = \'Mail Display\', display = 3, description = \'\'',
  259 => 'INSERT INTO hive_templategroup SET title = \'Expiry Notifications\', display = 16, description = \'\'',
  260 => 'INSERT INTO hive_templategroup SET title = \'Calendar\', display = 17, description = \'\'',
  261 => 'INSERT INTO hive_templategroup SET title = \'Subscriptions\', display = 18, description = \'\'',
  262 => 'INSERT INTO hive_templateset SET title = \'Default\'',
  263 => 'INSERT INTO hive_usergroup SET title = \'Administrators\', maxmb = 0, groupsig_text = \'\', groupsig_html = \'\', allowedskins = 1, perms = 201048063, maxattach = 0, maxsigs = 0, maxcontacts = 0, maxresponses = 0, maxrecips = 0, emptytime = 0, removetime = 0, notifytime = \'\', maxaliases = 0, msgpersec = \'a:2:{s:5:\\"every\\";i:0;s:4:\\"unit\\";i:60;}\', changepass = 0, permlink = \'\', maxpopstorage = 0',
  264 => 'INSERT INTO hive_usergroup SET title = \'Regular Users\', maxmb = 5, groupsig_text = \'\', groupsig_html = \'\', allowedskins = 1, perms = 268406687, maxattach = 2, maxsigs = 0, maxcontacts = 0, maxresponses = 0, maxrecips = 10, emptytime = 0, removetime = 0, notifytime = \'\', maxaliases = 5, msgpersec = \'a:2:{s:5:\\"every\\";i:0;s:4:\\"unit\\";i:60;}\', changepass = 30, permlink = \'\', maxpopstorage = 0',
  265 => 'INSERT INTO hive_usergroup SET title = \'Awaiting Validation\', maxmb = 0, groupsig_text = \'\', groupsig_html = \'\', allowedskins = 1, perms = 0, maxattach = 0, maxsigs = 0, maxcontacts = 0, maxresponses = 0, maxrecips = 0, emptytime = 0, removetime = 0, notifytime = \'\', maxaliases = 0, msgpersec = \'a:2:{s:5:\\"every\\";i:0;s:4:\\"unit\\";i:60;}\', changepass = 0, permlink = \'\', maxpopstorage = 0',
  266 => 'INSERT INTO hive_sound VALUES (1, -1, \'Default\', \'youvegotmail.wav\', \''.base64_decode('[encoded data, 41340 characters]').'\')',
);

?>