DROP TABLE IF EXISTS `bs2-addlinks`; CREATE TABLE IF NOT EXISTS `bs2-addlinks` (  `id` int(11) NOT NULL auto_increment,  `l1g` int(11) NOT NULL default '0',  `l2g` int(11) NOT NULL default '0',  `l1gl` set('0','1') NOT NULL default '0',  `l2gl` set('0','1') NOT NULL default '0',  `hl` int(11) NOT NULL default '0',  `all` set('0','1') NOT NULL default '0',  `link` text NOT NULL,  `text` text NOT NULL, `topic_id` int(11) NOT NULL default '1', PRIMARY KEY  (`id`)) TYPE=MyISAM;
DROP TABLE IF EXISTS `bs2-batch`; CREATE TABLE IF NOT EXISTS `bs2-batch` (  `id` int(11) NOT NULL auto_increment,  `name` text NOT NULL,  `url` text NOT NULL,  `status` set('0','1','2') NOT NULL default '0',  PRIMARY KEY  (`id`)) TYPE=MyISAM;
DROP TABLE IF EXISTS `bs2-blogs`;CREATE TABLE IF NOT EXISTS `bs2-blogs` (  `id` int(11) NOT NULL auto_increment,  `blog` varchar(255) NOT NULL default '',  `kws` text NOT NULL,  `title` varchar(255) NOT NULL default '',  `subtitle` text NOT NULL,  `email` text NOT NULL,  `template` varchar(255) NOT NULL default '',  `l1g` int(11) NOT NULL default '0',  `l2g` int(11) NOT NULL default '0',  `hl` int(11) NOT NULL default '0',  `active` enum('0','1') NOT NULL default '1',   `topic_id` int(11) NOT NULL default '1',  `lig` int(11) NOT NULL default '0', PRIMARY KEY  (`id`)) TYPE=MyISAM;
DROP TABLE IF EXISTS `bs2-counters`;CREATE TABLE IF NOT EXISTS `bs2-counters` (  `l1` int(11) NOT NULL default '0',  `l1g` int(11) NOT NULL default '0',  `l2` int(11) NOT NULL default '0',  `l2g` int(11) NOT NULL default '0',  `lf` int(11) NOT NULL default '0', `topic_id` int(11) NOT NULL default '1') TYPE=MyISAM;
DROP TABLE IF EXISTS `bs2-feeds`;CREATE TABLE IF NOT EXISTS `bs2-feeds` (  `id` int(11) NOT NULL auto_increment,  `address` varchar(255) default NULL,  `blog_id` int(11) NOT NULL default '0',  PRIMARY KEY  (`id`),  KEY `blog_id` (`blog_id`)) TYPE=MyISAM;
DROP TABLE IF EXISTS `bs2-headlines`;CREATE TABLE IF NOT EXISTS `bs2-headlines` (  `id` int(10) unsigned NOT NULL auto_increment,  `blog_id` int(11) default NULL,  `posted` datetime NOT NULL default '0000-00-00 00:00:00',  `item_title` text,  `item_desc` text,  `item_link` text NOT NULL,  `channel_title` text NOT NULL,  `channel_link` text NOT NULL,  `channel_copyright` text NOT NULL,  `active` enum('0','1') NOT NULL default '0', `channel_added` enum('0','1') NOT NULL default '0', PRIMARY KEY  (`id`),  KEY `blog_id` (`blog_id`)) TYPE=MyISAM;
DROP TABLE IF EXISTS `bs2-hints`;CREATE TABLE IF NOT EXISTS `bs2-hints` (  `st` varchar(20) NOT NULL default '',  `val` text NOT NULL,  `tag` varchar(10) NOT NULL default '') TYPE=MyISAM;
DROP TABLE IF EXISTS `bs2-ping_proxies`;CREATE TABLE IF NOT EXISTS `bs2-ping_proxies` (  `id` int(11) NOT NULL auto_increment,  `proxy` text NOT NULL,  PRIMARY KEY  (`id`)) TYPE=MyISAM;
DROP TABLE IF EXISTS `bs2-postlinks`;CREATE TABLE IF NOT EXISTS `bs2-postlinks` (  `id` int(11) NOT NULL auto_increment,  `l1g` int(11) NOT NULL default '0',  `l2g` int(11) NOT NULL default '0',  `l1gl` set('0','1') NOT NULL default '0',  `l2gl` set('0','1') NOT NULL default '0',  `hl` int(11) NOT NULL default '0',  `all` set('0','1') NOT NULL default '0',  `link` text NOT NULL,  `text` text NOT NULL,  `prob` int(11) NOT NULL default '0', `topic_id` int(11) NOT NULL default '1', PRIMARY KEY  (`id`)) TYPE=MyISAM;
DROP TABLE IF EXISTS `bs2-services`;
CREATE TABLE IF NOT EXISTS `bs2-services` (  `domain` varchar(255) NOT NULL default '',  `help` set('1','2') NOT NULL default '',  `license` text NOT NULL,  `feed_urls` text NOT NULL,  `cs_urls` text NOT NULL,  `perpage` int(11) NOT NULL default '0',  `char` int(11) NOT NULL default '0',  `activation` int(11) NOT NULL default '0',  `pwd` text NOT NULL,  `aggregation_percent` int(11) NOT NULL default '0',  `ping_percent` int(11) NOT NULL default '0',  `aggregation_mode` int(11) NOT NULL default '0',  `aggregation_pair` int(11) NOT NULL default '0',  `pending` int(11) NOT NULL default '0',  `linkage_limit` int(4) NOT NULL default '0',  `postlink_prob` int(11) NOT NULL default '0',  `address_model` enum('0','1') NOT NULL default '0',  `magic_word` varchar(50) NOT NULL default '',  `sitename` text NOT NULL,  `lastping` datetime NOT NULL default '0000-00-00 00:00:00',  `lastupdate` datetime NOT NULL default '0000-00-00 00:00:00',  `phpp` varchar(100) NOT NULL default '', `name` text NOT NULL,`email` text NOT NULL, `communicate` enum('1','2','3','4'), `on` text NOT NULL,`index_limit` int(11) NOT NULL default '20', `index_blimit` int(11) NOT NULL default '20', `upto` int(11) NOT NULL default '1') TYPE=MyISAM;
DROP TABLE IF EXISTS `bs2-services_ping`;CREATE TABLE IF NOT EXISTS `bs2-services_ping` (  `id` int(11) NOT NULL auto_increment,  `address` text NOT NULL,  PRIMARY KEY  (`id`),  UNIQUE KEY `address` (`address`(100))) TYPE=MyISAM;
INSERT INTO `bs2-services_ping` VALUES (1, 'http://rpc.pingomatic.com/');
INSERT INTO `bs2-services_ping` VALUES (2, 'http://1470.net/api/ping');
INSERT INTO `bs2-services_ping` VALUES (3, 'http://www.a2b.cc/setloc/bp.a2b');
INSERT INTO `bs2-services_ping` VALUES (4, 'http://api.feedster.com/ping');
INSERT INTO `bs2-services_ping` VALUES (5, 'http://api.moreover.com/RPC2');
INSERT INTO `bs2-services_ping` VALUES (6, 'http://api.moreover.com/ping');
INSERT INTO `bs2-services_ping` VALUES (7, 'http://api.my.yahoo.com/RPC2');
INSERT INTO `bs2-services_ping` VALUES (8, 'http://api.my.yahoo.com/rss/ping');
INSERT INTO `bs2-services_ping` VALUES (9, 'http://www.bitacoles.net/ping.php');
INSERT INTO `bs2-services_ping` VALUES (10, 'http://bitacoras.net/ping');
INSERT INTO `bs2-services_ping` VALUES (11, 'http://www.blogdigger.com/RPC2');
INSERT INTO `bs2-services_ping` VALUES (12, 'http://blogmatcher.com/u.php');
INSERT INTO `bs2-services_ping` VALUES (13, 'http://www.blogoole.com/ping/');
INSERT INTO `bs2-services_ping` VALUES (14, 'http://www.blogoon.net/ping/');
INSERT INTO `bs2-services_ping` VALUES (15, 'http://www.blogshares.com/rpc.php');
INSERT INTO `bs2-services_ping` VALUES (16, 'http://www.blogsnow.com/ping');
INSERT INTO `bs2-services_ping` VALUES (17, 'http://www.blogstreet.com/xrbin/xmlrpc.cgi');
INSERT INTO `bs2-services_ping` VALUES (18, 'http://bulkfeeds.net/rpc');
INSERT INTO `bs2-services_ping` VALUES (19, 'http://coreblog.org/ping/');
INSERT INTO `bs2-services_ping` VALUES (20, 'http://www.lasermemory.com/lsrpc/');
INSERT INTO `bs2-services_ping` VALUES (21, 'http://mod-pubsub.org/kn_apps/blogchatt');
INSERT INTO `bs2-services_ping` VALUES (22, 'http://www.newsisfree.com/xmlrpctest.php');
INSERT INTO `bs2-services_ping` VALUES (23, 'http://ping.amagle.com/');
INSERT INTO `bs2-services_ping` VALUES (24, 'http://ping.bitacoras.com');
INSERT INTO `bs2-services_ping` VALUES (25, 'http://ping.blo.gs/');
INSERT INTO `bs2-services_ping` VALUES (26, 'http://ping.cocolog-nifty.com/xmlrpc');
INSERT INTO `bs2-services_ping` VALUES (27, 'http://ping.exblog.jp/xmlrpc');
INSERT INTO `bs2-services_ping` VALUES (28, 'http://ping.feedburner.com');
INSERT INTO `bs2-services_ping` VALUES (29, 'http://ping.rootblog.com/rpc.php');
INSERT INTO `bs2-services_ping` VALUES (30, 'http://ping.syndic8.com/xmlrpc.php');
INSERT INTO `bs2-services_ping` VALUES (31, 'http://ping.weblogalot.com/rpc.php');
INSERT INTO `bs2-services_ping` VALUES (32, 'http://ping.weblogs.se/');
INSERT INTO `bs2-services_ping` VALUES (34, 'http://www.popdex.com/addsite.php');
INSERT INTO `bs2-services_ping` VALUES (35, 'http://rcs.datashed.net/RPC2/');
INSERT INTO `bs2-services_ping` VALUES (36, 'http://rpc.blogrolling.com/pinger/');
INSERT INTO `bs2-services_ping` VALUES (37, 'http://rpc.icerocket.com:10080/');
INSERT INTO `bs2-services_ping` VALUES (38, 'http://rpc.technorati.com/rpc/ping');
INSERT INTO `bs2-services_ping` VALUES (39, 'http://rpc.weblogs.com/RPC2');
INSERT INTO `bs2-services_ping` VALUES (40, 'http://www.snipsnap.org/RPC2');
INSERT INTO `bs2-services_ping` VALUES (41, 'http://topicexchange.com/RPC2');
INSERT INTO `bs2-services_ping` VALUES (42, 'http://www.weblogues.com/RPC/');
INSERT INTO `bs2-services_ping` VALUES (43, 'http://xping.pubsub.com/ping/');
INSERT INTO `bs2-services_ping` VALUES (44, 'http://xmlrpc.blogg.de/');
INSERT INTO `bs2-counters` VALUES (0, 1, 1, 1, 0, 1);
CREATE TABLE `bs2-topics` (  `id` int(11) NOT NULL auto_increment,  `name` varchar(50) NOT NULL default '',  PRIMARY KEY  (`id`)) TYPE=MyISAM;
INSERT INTO `bs2-topics` VALUES (1, 'Default');
INSERT INTO `bs2-hints` VALUES ('a_batch', 'Activate the specified number of blogs from batch list', 'index');
INSERT INTO `bs2-hints` VALUES ('a_batch_all', 'Activate all blogs in the batch list', 'index');
INSERT INTO `bs2-hints` VALUES ('delete_blogs_all', 'Delete all blogs, including active and inactive blogs in batch list', 'index');
INSERT INTO `bs2-hints` VALUES ('delete_blogs_notactive', 'Delete only inactive blogs from batch list', 'index');
INSERT INTO `bs2-hints` VALUES ('run_update', 'Run automatic update for all active blogs', 'index');
INSERT INTO `bs2-hints` VALUES ('add_mass', 'Manualy add one post to all the active blogs', 'index');
INSERT INTO `bs2-hints` VALUES ('select_templates', 'Select templates you want to use for the blogs you are about to create. Templates will be randomly taken of those selected and assigned to the blogs.', 'add');
INSERT INTO `bs2-hints` VALUES ('put_to_batch', 'If you check this box the blogs will be created but set as Inactive and will be placed in a batch list - this means that they will return 404 - Not Found error when accessed until they remain in batch. Visit the operation center to learn how to activate blogs from batch.', 'add');
INSERT INTO `bs2-hints` VALUES ('ip_entry', 'Enter the IP addresses of Search Engine bots to activate cloaking IP. You can use following options here:<br>1.2.3.4 - as exact ip<br>1.2.3.* - as all ips starting with 1.2.3<br>1.2.3.1-5 - all ips 1.2.3.1, 1.2.3.2 .. 1.2.3.5', 'cloak');
INSERT INTO `bs2-hints` VALUES ('ua_entry', 'Enter the list of user agents of search engine bots to activate cloaking.  The exact name of UA is expected here.  No wildcards allowed.', 'cloak');
INSERT INTO `bs2-hints` VALUES ('ping_all', 'All the active blogs will be put on the ping list and wait for the ping process to be pinged.', 'index');
INSERT INTO `bs2-hints` VALUES ('start_ping', 'Start pinging process - it will ping the  blogs out of ping batch but not more than % you defined in the settings.', 'index');
INSERT INTO `bs2-hints` VALUES ('flush_ping', 'Delete all the blogs from the ping list. No blog will wait to be pinged.', 'index');
INSERT INTO `bs2-hints` VALUES ('convert_pending', 'Update the blogs by activating all the posts that are waiting in the database.', 'index');
INSERT INTO `bs2-hints` VALUES ('delete_pending', 'Delete all posts that are waiting in the database.', 'index');
INSERT INTO `bs2-hints` VALUES ('delete_all_posts', 'Delete all posts from all blogs. This will cause all blogs to be empty.', 'index');
INSERT INTO `bs2-hints` VALUES ('add_l_blogs', 'Add/Edit external links that will be added on your blogs index pages', 'index');
INSERT INTO `bs2-hints` VALUES ('add_l_posts', 'Add/Edit external links that will be permanently added inside the new posts on your blogs', 'index');
INSERT INTO `bs2-hints` VALUES ('del_l_blogs', 'Remove all links that are used on blog index pages', 'index');
INSERT INTO `bs2-hints` VALUES ('del_l_posts', 'Remove all links that are added to blog posts', 'index');
INSERT INTO `bs2-hints` VALUES ('reassign_t', 'Randomly assign a new template to all existing blogs.', 'index');
INSERT INTO `bs2-hints` VALUES ('start_ping', 'Start pinging all the blogs that are waiting to be pinged', 'ping');
INSERT INTO `bs2-hints` VALUES ('run_update', 'Run automatic update for all active blogs according to settings', 'ping');
INSERT INTO `bs2-hints` VALUES ('ping_services', 'List of the ping services to be used to ping your blogs', 'ping');
INSERT INTO `bs2-hints` VALUES ('ping_proxies', 'List of proxies to be used when pinging your blogs.', 'ping');
INSERT INTO `bs2-hints` VALUES ('del_l_blogs', 'Remove all links on your blogs index pages', 'linkage');
INSERT INTO `bs2-hints` VALUES ('del_l_posts', 'remove all links that can be added to your blog posts', 'linkage');
INSERT INTO `bs2-hints` VALUES ('edit_link', 'Edit details of the link', 'linkage');
INSERT INTO `bs2-hints` VALUES ('remove_link', 'Delete this link from the list', 'linkage');
INSERT INTO `bs2-hints` VALUES ('add_link_title', 'Input anchor text for the link', 'linkage');
INSERT INTO `bs2-hints` VALUES ('add_link_url', 'Input URL for the link', 'linkage');
INSERT INTO `bs2-hints` VALUES ('blog_assign', 'Enter ID # of exact blog if you want this link to appear on that specific blog main page', 'linkage');
INSERT INTO `bs2-hints` VALUES ('group_assign', 'Select where this link should appear.', 'linkage');
INSERT INTO `bs2-hints` VALUES ('link_weight', 'Select link weight. Links with higher weight will be included more often to the posts.', 'linkage');
INSERT INTO `bs2-hints` VALUES ('mass_enbatch', 'Check this box to add all blogs to the ping list after the message is posted.', 'mass_message');
INSERT INTO `bs2-hints` VALUES ('post_subject', 'Subject/Title of the post.', 'mass_message');
INSERT INTO `bs2-hints` VALUES ('post_body', 'Content of the post. May include html tags.', 'mass_message');
INSERT INTO `bs2-hints` VALUES ('site_name', 'Name/Title of your site. It can be used as a variable in templates.', 'settings');
INSERT INTO `bs2-hints` VALUES ('php_path', 'Path to php interpreter. Leave the default path if you are not sure about this.', 'settings');
INSERT INTO `bs2-hints` VALUES ('addr_t', 'Name of the virtual folder - blogs will be virtually located inside this folder', 'settings');
INSERT INTO `bs2-hints` VALUES ('password', 'Type your new password here if you want to change it', 'settings');
INSERT INTO `bs2-hints` VALUES ('batch', 'Your batch is your collection of pending blogs.  Each time your batch update runs, it will take this many blogs from your batch and make them active.', 'settings');
INSERT INTO `bs2-hints` VALUES ('lastposts', 'This is number updates that will be shown on your domains (yourdomain.com) index page.', 'settings');
INSERT INTO `bs2-hints` VALUES ('lastblogs', 'This is the number of blogs your domains main index page (yourdomain.com) will show', 'settings');
INSERT INTO `bs2-hints` VALUES ('blogposts', 'This is the number of posts each of your blogs will show.', 'settings');
INSERT INTO `bs2-hints` VALUES ('char', 'This is the number of characters that will display for each blog post before its cut off.', 'settings');
INSERT INTO `bs2-hints` VALUES ('name', 'Your name, to be used when BS will communicate with you.', 'settings');
INSERT INTO `bs2-hints` VALUES ('email', 'The email where you want to receive email notifications from the script', 'settings');
INSERT INTO `bs2-hints` VALUES ('communication', 'Select what kind of notifications you want to receive from the script', 'settings');
INSERT INTO `bs2-hints` VALUES ('feed_urls', 'Add here as many feeds as you want. The content of the feeds will be used to update your blogs. <b>Important</b>: the feeds you enter here should support keyword-oriented searches ability. Which means that google blogsearch or yahoo news are expected here. Please, set the {keyword} tag in the place where keyword should be placed.', 'settings');
INSERT INTO `bs2-hints` VALUES ('cs_urls', 'If you are using ContentSolution you can add here a list of CS projects to be used to update your blogs', 'settings');
INSERT INTO `bs2-hints` VALUES ('sources_used', 'where do you want your blogs getting their updates?', 'settings');
INSERT INTO `bs2-hints` VALUES ('agg_mode', 'Select the aggregation mode for updates. Leave default or read the help for more info.', 'settings');
INSERT INTO `bs2-hints` VALUES ('pending', 'BlogSolution is going to gather a lot of blog posts / updates for you.  Do you want them all going into your blogs at once?  Only post one update at a time and post the others later (put them on pending status)?  Or post one and discard all the rest?  ', 'settings');
INSERT INTO `bs2-hints` VALUES ('agg_percent', 'This function makes it so your blogs update at different times', 'settings');
INSERT INTO `bs2-hints` VALUES ('ping_percent', 'This function makes it so your blogs ping at different times', 'settings');
INSERT INTO `bs2-hints` VALUES ('linklimit', 'If you have specified links for Blogsolution to post, it will post them each time it updates.  This is the maximum # of links it will post with each update to one post. ', 'settings');
INSERT INTO `bs2-hints` VALUES ('link_post_percent', 'Each time BlogSolution updates, it can post links.  Depending on the % you pick, this will determine how often BlogSolution will post your links along with your regular updates.', 'settings');
INSERT INTO `bs2-hints` VALUES ('delete_t', 'Delete this template. This action can not be undone!', 'templates');
INSERT INTO `bs2-hints` VALUES ('t_redirect', 'The URL where you want your surfers to be redirected. Can be used only if cloaking is used.', 'templates');
INSERT INTO `bs2-hints` VALUES ('blog_view_html', 'Html template code to be used as blog index template', 'templates');
INSERT INTO `bs2-hints` VALUES ('post_view_html', 'Html template code to be used as blog post template', 'templates');
INSERT INTO `bs2-hints` VALUES ('cloak_blog_view_html', 'Html template code to be used as blog index template. You only need this if you use cloaking!', 'templates');
INSERT INTO `bs2-hints` VALUES ('cloak_post_view_html', 'Html template code to be used as blog post template . You only need this if you use cloaking!', 'templates');
INSERT INTO `bs2-hints` VALUES ('manupdate', 'Manually add one post to this blog', 'manage');
INSERT INTO `bs2-hints` VALUES ('pdelete', 'Delete all posts from this blog', 'manage');
INSERT INTO `bs2-hints` VALUES ('bdelete', 'Delete this entire blog and it''s posts from the database', 'manage');
INSERT INTO `bs2-hints` VALUES ('b_active', 'Check/Uncheck the box to Activate/Deactivate blog. Blog will not be deleted from database.', 'manage');
INSERT INTO `bs2-hints` VALUES ('b_address', 'Manually edit the address of this blog', 'manage');
INSERT INTO `bs2-hints` VALUES ('b_title', 'Manually edit the title of the blog', 'manage');
INSERT INTO `bs2-hints` VALUES ('b_subtitle', 'Manually edit the subtitle of the blog', 'manage');
INSERT INTO `bs2-hints` VALUES ('b_email', 'Manually edit the contact email for this blog. You can leave anythig there, even empty.', 'manage');
INSERT INTO `bs2-hints` VALUES ('b_template', 'Manually select the template to be used with this blog', 'manage');
INSERT INTO `bs2-hints` VALUES ('b_intlink', 'Manually edit internal linkage for the blog. There is no need to edit the default settings unless you really want that!', 'manage');
INSERT INTO `bs2-hints` VALUES ('b_feeds', 'Add other feeds sourcs to be used with this blog then the default sources set in Settings. This will be used together with the default settings.', 'manage');
INSERT INTO `bs2-hints` VALUES ('b_kws', 'The list of keywords to be used with CS projects and RSS feeds that allow search queries. ', 'manage');