installsql.php

一个全功能的国外博客商业程序

  `contents` text NOT NULL,
  `draft` int(1) NOT NULL default '0',
  `privacy` int(1) NOT NULL default '0',
  `date` int(14) NOT NULL default '0',
  `comments` int(1) NOT NULL default '0',
  `trackbacks` int(1) NOT NULL default '0',
  `tb_to_ping` text NOT NULL,
  `tb_pinged` text NOT NULL,
  PRIMARY KEY  (`e_id`)
)
");



//######### CREATE bhost_entrycategories
mysql_query("CREATE TABLE `bhost_entrycategories` (
  `ec_id` int(8) NOT NULL auto_increment,
  `u_id` int(8) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ec_id`)
)
");




//######### CREATE bhost_faq
mysql_query("CREATE TABLE `bhost_faq` (
  `q_id` int(8) NOT NULL auto_increment,
  `c_id` int(8) NOT NULL default '0',
  `q_order` int(8) NOT NULL default '0',
  `question` varchar(255) NOT NULL default '',
  `answer` text NOT NULL,
  PRIMARY KEY  (`q_id`)
)
");


//######### INSERT DEFAULTS INTO bhost_faq
mysql_query("INSERT INTO `bhost_faq` VALUES (1, 2, 1, 'How do I view my weblog?', 'To view your weblog, click the \"View Weblog\" button on your control panel menu. If you would like to share your weblog with others, simply give them the web address (URL) as shown at the top of your <a href=''index.php''>View Entries</a> page.')");
mysql_query("INSERT INTO `bhost_faq` VALUES (2, 2, 2, 'How do I write a new entry?', 'Adding a new entry to your weblog is easy! Just click the \"Add New Entry\" item on your control panel menu. The following page will provide you with a title field*, contents field, and several advanced options.\r\n<br><br>\r\n\r\nIn the contents field (the large text box) you will write the body of your entry. Feel free to use any of the Rich Text editor tools from the toolbar above the text box. If you would like to edit the HTML directly, click the \"HTML Mode\" checkbox. \r\n<br><br>\r\n\r\nWhen you have finished, click the \"Add New Entry\" button at the bottom of the page, or click the \"Preview Entry\" to see how your new entry will look on your weblog. If you click the \"Save As Draft\" button, the entry will be saved but not displayed on your weblog. You will be able to re-save the draft as a visible entry later.\r\n<br><br>\r\n\r\n*The title field will only be visible if you have set \"Show Title Field?\" to Yes on your <a href='' settings.php''>General Settings</a> page.')");
mysql_query("INSERT INTO `bhost_faq` VALUES (3, 2, 3, 'How do I edit/delete my old entries?', 'To view a list of your previously written entries, click on the \"View Entries\" item on your control panel menu. This page displays a list of all the entries and drafts that are on your weblog. \r\n<br><br>\r\nIf you want to delete multiple entries at once, check their boxes on the left side of each entry row and click the \"Delete Selected Entries\" button at the bottom of the page.\r\n<br><br>\r\nIf you want to change the number of entries displayed per page, you can do so from the \"<a href=''settings.php''>General Settings</a>\" page. This will affect both the number of entries shown on your weblog and the number of entry rows displayed on your \"View Entries\" page.')");
mysql_query("INSERT INTO `bhost_faq` VALUES (4, 2, 4, 'How do I use my mailing list?', 'The mailing list is an optional feature, and is turned off by default. If you want to notify people each time you write a new entry, you can specify their email addresses on the \"<a href=''settings.php''>General Settings</a>\" page in the mailing list field. Each time you add a new entry with \"Send to Mailing List?\" set to Yes, each of the email addresses in your mailing list will be notified of your new entry.\r\n<br><br>\r\nNote: In the mailing list field on your \"General Settings\" page, you must seperate the email addresses with commas only. For example:\r\n<br><br>\r\n<i>[e-mail],[e-mail],[e-mail]</i>')");
mysql_query("INSERT INTO `bhost_faq` VALUES (5, 2, 5, 'What is \"Content Default for New Entries\"?', 'On the \"<a href=''settings.php''>General Settings</a>\", there is a field titled Content Default for New Entries. Any text or HTML that you put into this field will be pre-filled in the contents text box on the \"Add New Entry\" page each time you create a new entry. This is useful if you plan to have something at the beginning of every entry, such as a font tag, your name, an image, etc.')");
mysql_query("INSERT INTO `bhost_faq` VALUES (6, 2, 6, 'What is \"Privacy Default for New Entries\"?', 'If your account has the ability to write private entries, this field will be available on your \"<a href=''settings.php''>General Settings</a>\" page. This pull-down box determines what the \"Who Can Read?\" field on your \"Add New Entry\" page will be preset to. This is useful if you want to set all or most of your entries to one privacy level. ')");
mysql_query("INSERT INTO `bhost_faq` VALUES (7, 2, 7, 'What is \"Show Title Field\"?', 'This pull-down box is visible on your \"<a href=''settings.php''>General Settings</a>\" page. If set to No, the title field on your \"Add New Entry\" page will be hidden and all entries that you write thereafter will have no title. This is useful if you are writing your weblog entries in prose style and don''t want titles for each entry.')");
mysql_query("INSERT INTO `bhost_faq` VALUES (8, 1, 1, 'How do I view my user profile?', 'To view your user profile, click on the \"<a href=''edit_profile.php''>Edit My Profile</a>\" item on your control panel menu. The link to your user profile is displayed at the top of the following page. ')");
mysql_query("INSERT INTO `bhost_faq` VALUES (9, 1, 2, 'What are \"friends\" and how do I add them?', '\"Friends\" are other weblog authors who you know or like to associate with. If you have the ability to write private entries, you have the option to set their privacy level to \"friends only\", which means that only users you have specified on your \"<a href=''members.php''>Manage Friends</a>\" page will be able to view them. \r\n<br><br>\r\nTo add or delete friends, click on the \"<a href=''members.php''>Manage Friends</a>\" item on your control panel menu. To add a new friend, simply enter their username into the text field and click the \"Add Friend\" button. If they have added you to their friends list, you will see a \"Yes\" on their row inside the \"Mutual?\" column. ')");
mysql_query("INSERT INTO `bhost_faq` VALUES (10, 1, 3, 'What is an avatar? How do I add one?', 'An avatar is a small image or icon that you can display on your profile. On some weblogs, your avatar might also be displayed if you post a comment.\r\n<br><br>\r\nAvatars are optional. If you want to specify one, click on the \"<a href=''edit_profile.php''>Edit My Profile</a>\" item on your control panel menu. Look for the field titled \"Avatar Image URL\". Enter the web address (URL) of your avatar in this field.')");
mysql_query("INSERT INTO `bhost_faq` VALUES (11, 1, 4, 'What do I use for a \"brief description\"?', 'The \"Brief Description\" field on your profile is provided so that you can give a short summary of what your weblog is about, why you are writing in it, etc. This will be displayed on your user profile, and depending on your template, in your weblog.')");
mysql_query("INSERT INTO `bhost_faq` VALUES (12, 2, 8, 'How do I change my password?', 'To change your password, go to your \"Edit Profile\" page, or <a href=''changepass.php''>click here</a>.')");
mysql_query("INSERT INTO `bhost_faq` VALUES (13, 3, 1, 'What does my template do? How do I change it?', 'Your weblog template, a combination of HTML and weblog variables, is used to show the entries you have written in a visually attractive and legible way. \r\n<br><br>\r\nTo pick a new template, visit the \"<a href=''choose_template.php''>Choose New Template</a>\" page. Here you can pick from several pre-written templates to use for your weblog.\r\n<br><br>\r\nIf you are using one of the pre-written templates, no changes are necessary for your weblog to display correctly. However, if you want to make custom changes, you will need to edit your template:\r\n<br><br>\r\nTo edit your current template, click the \"<a href=''edit_template.php''>Edit Template</a>\" item on your control panel menu. On this page, you will see a large text box that contains your template code. Here, you can make custom changes to your current template. If you need help with weblog variables, visit the <a href=''support_guide.php''>template guide</a>.')");
mysql_query("INSERT INTO `bhost_faq` VALUES (14, 3, 2, 'How do I use weblog variables?', 'Weblog variables are a very important part of your template - they are used to display all of your written content. For more information on using weblog variables, and for a list of variables that you can use, visit the weblog <a href=''support_guide.php''>template guide</a>.')");
mysql_query("INSERT INTO `bhost_faq` VALUES (15, 2, 9, 'I&#39;m having a problem - how do I contact support?', 'Before contacting support, be sure that your question is not answered in this faq. To contact support via email, <a href=''support_email.php''>click here</a>.')");



//######### CREATE bhost_faqcat
mysql_query("CREATE TABLE `bhost_faqcat` (
  `c_id` int(8) NOT NULL auto_increment,
  `c_order` int(8) NOT NULL default '0',
  `category` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`c_id`)