i was trying to run this from the ultimate blogs
<?
set_time_limit(9999999);
/***************************************************************************
* Dolphin Smart Community Builder
* -----------------
* begin : Mon Mar 23 2006
* copyright : (C) 2006 BoonEx Group
* website : http://www.boonex.com/
* This file is part of Dolphin - Smart Community Builder
*
* Dolphin is free software. This work is licensed under a Creative Commons Attribution 3.0 License.
* http://creativecommons.org/licenses/by/3.0/
*
* Dolphin is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
* without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
* See the Creative Commons Attribution 3.0 License for more details.
* You should have received a copy of the Creative Commons Attribution 3.0 License along with Dolphin,
* see license.txt file; if not, write to marketing@boonex.com
***************************************************************************/
require_once( 'inc/header.inc.php' );
require_once( BX_DIRECTORY_PATH_INC . 'design.inc.php' );
require_once( BX_DIRECTORY_PATH_INC . 'admin_design.inc.php' );
require_once( BX_DIRECTORY_PATH_INC . 'languages.inc.php' );
require_once( BX_DIRECTORY_PATH_INC . 'utils.inc.php' );
echo "START .....<br /><br />";
echo "UPDATING DATABASE .....<br /><br />";
db_res("UPDATE `sys_modules` SET `title`='Ultimate Blogs', `version`='2.0.8', `vendor`='modzzz.com' WHERE `uri` = 'blogs' AND `db_prefix` = 'bx_blogs'");
db_res("ALTER TABLE `bx_blogs_main` CHANGE `Description` `Description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''");
db_res("
CREATE TABLE IF NOT EXISTS `bx_blogs_activity` (
`id` int(10) unsigned NOT NULL auto_increment,
`blog_id` int(11) NOT NULL,
`lang_key` varchar(100) collate utf8_unicode_ci NOT NULL,
`params` text collate utf8_unicode_ci NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
`type` enum('add','delete','change','commentPost','rate','featured','unfeatured') collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `blog_id` (`blog_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
");
db_res("
CREATE TABLE IF NOT EXISTS `bx_blogs_watch` (
`blog_id` int(11) NOT NULL,
`member_id` int(11) NOT NULL,
`watch_date` datetime default NULL ,
KEY `watch_list` ( `blog_id` , `member_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8;
");
db_res("ALTER TABLE `bx_blogs_posts` ADD `VideoEmbed` TEXT NOT NULL,
ADD `Mood` varchar(10) NOT NULL,
ADD `Sticky` tinyint(1) NOT NULL DEFAULT '0'
");
db_res("
INSERT INTO `sys_pre_values` (`Key`, `Value`, `Order`, `LKey`) VALUES
('BlogMood', '0', 0, '_bx_blogs_mood_none'),
('BlogMood', '90', 90, '_bx_blogs_mood_accomplished'),
('BlogMood', '1', 1, '_bx_blogs_mood_aggravated'),
('BlogMood', '44', 44, '_bx_blogs_mood_amused'),
('BlogMood', '2', 2, '_bx_blogs_mood_angry'),
('BlogMood', '3', 3, '_bx_blogs_mood_annoyed'),
('BlogMood', '4', 4, '_bx_blogs_mood_anxious'),
('BlogMood', '114', 114, '_bx_blogs_mood_apathetic'),
('BlogMood', '108', 108, '_bx_blogs_mood_artistic'),
('BlogMood', '87', 87, '_bx_blogs_mood_awake'),
('BlogMood', '110', 110, '_bx_blogs_mood_bitchy'),
('BlogMood', '92', 92, '_bx_blogs_mood_blah'),
('BlogMood', '113', 113, '_bx_blogs_mood_blank'),
('BlogMood', '5', 5, '_bx_blogs_mood_bored'),
('BlogMood', '59', 59, '_bx_blogs_mood_bouncy'),
('BlogMood', '91', 91, '_bx_blogs_mood_busy'),
('BlogMood', '68', 68, '_bx_blogs_mood_calm'),
('BlogMood', '125', 125, '_bx_blogs_mood_cheerful'),
('BlogMood', '99', 99, '_bx_blogs_mood_chipper'),
('BlogMood', '84', 84, '_bx_blogs_mood_cold'),
('BlogMood', '63', 63, '_bx_blogs_mood_complacent'),
('BlogMood', '6', 6, '_bx_blogs_mood_confused'),
('BlogMood', '101', 101, '_bx_blogs_mood_contemplative'),
('BlogMood', '64', 64, '_bx_blogs_mood_content'),
('BlogMood', '8', 8, '_bx_blogs_mood_cranky'),
('BlogMood', '7', 7, '_bx_blogs_mood_crappy'),
('BlogMood', '106', 106, '_bx_blogs_mood_crazy'),
('BlogMood', '107', 107, '_bx_blogs_mood_creative'),
('BlogMood', '129', 129, '_bx_blogs_mood_crushed'),
('BlogMood', '56', 56, '_bx_blogs_mood_curious'),
('BlogMood', '104', 104, '_bx_blogs_mood_cynical'),
('BlogMood', '9', 9, '_bx_blogs_mood_depressed'),
('BlogMood', '45', 45, '_bx_blogs_mood_determined'),
('BlogMood', '130', 130, '_bx_blogs_mood_devious'),
('BlogMood', '119', 119, '_bx_blogs_mood_dirty'),
('BlogMood', '55', 55, '_bx_blogs_mood_disappointed'),
('BlogMood', '10', 10, '_bx_blogs_mood_discontent'),
('BlogMood', '127', 127, '_bx_blogs_mood_distressed'),
('BlogMood', '35', 35, '_bx_blogs_mood_ditzy'),
('BlogMood', '115', 115, '_bx_blogs_mood_dorky'),
('BlogMood', '40', 40, '_bx_blogs_mood_drained'),
('BlogMood', '34', 34, '_bx_blogs_mood_drunk'),
('BlogMood', '98', 98, '_bx_blogs_mood_ecstatic'),
('BlogMood', '79', 79, '_bx_blogs_mood_embarrassed'),
('BlogMood', '11', 11, '_bx_blogs_mood_energetic'),
('BlogMood', '12', 12, '_bx_blogs_mood_enraged'),
('BlogMood', '13', 13, '_bx_blogs_mood_enthralled'),
('BlogMood', '80', 80, '_bx_blogs_mood_envious'),
('BlogMood', '78', 78, '_bx_blogs_mood_exanimate'),
('BlogMood', '41', 41, '_bx_blogs_mood_excited'),
('BlogMood', '14', 14, '_bx_blogs_mood_exhausted'),
('BlogMood', '67', 67, '_bx_blogs_mood_flirty'),
('BlogMood', '47', 47, '_bx_blogs_mood_frustrated'),
('BlogMood', '93', 93, '_bx_blogs_mood_full'),
('BlogMood', '103', 103, '_bx_blogs_mood_geeky'),
('BlogMood', '120', 120, '_bx_blogs_mood_giddy'),
('BlogMood', '72', 72, '_bx_blogs_mood_giggly'),
('BlogMood', '38', 38, '_bx_blogs_mood_gloomy'),
('BlogMood', '126', 126, '_bx_blogs_mood_good'),
('BlogMood', '132', 132, '_bx_blogs_mood_grateful'),
('BlogMood', '51', 51, '_bx_blogs_mood_groggy'),
('BlogMood', '95', 95, '_bx_blogs_mood_grumpy'),
('BlogMood', '111', 111, '_bx_blogs_mood_guilty'),
('BlogMood', '15', 15, '_bx_blogs_mood_happy'),
('BlogMood', '16', 16, '_bx_blogs_mood_high'),
('BlogMood', '43', 43, '_bx_blogs_mood_hopeful'),
('BlogMood', '17', 17, '_bx_blogs_mood_horny'),
('BlogMood', '83', 83, '_bx_blogs_mood_hot'),
('BlogMood', '18', 18, '_bx_blogs_mood_hungry'),
('BlogMood', '52', 52, '_bx_blogs_mood_hyper'),
('BlogMood', '116', 116, '_bx_blogs_mood_impressed'),
('BlogMood', '48', 48, '_bx_blogs_mood_indescribable'),
('BlogMood', '65', 65, '_bx_blogs_mood_indifferent'),
('BlogMood', '19', 19, '_bx_blogs_mood_infuriated'),
('BlogMood', '128', 128, '_bx_blogs_mood_intimidated'),
('BlogMood', '20', 20, '_bx_blogs_mood_irate'),
('BlogMood', '112', 112, '_bx_blogs_mood_irritated'),
('BlogMood', '133', 133, '_bx_blogs_mood_jealous'),
('BlogMood', '21', 21, '_bx_blogs_mood_jubilant'),
('BlogMood', '33', 33, '_bx_blogs_mood_lazy'),
('BlogMood', '75', 75, '_bx_blogs_mood_lethargic'),
('BlogMood', '76', 76, '_bx_blogs_mood_listless'),
('BlogMood', '22', 22, '_bx_blogs_mood_lonely'),
('BlogMood', '86', 86, '_bx_blogs_mood_loved'),
('BlogMood', '39', 39, '_bx_blogs_mood_melancholy'),
('BlogMood', '57', 57, '_bx_blogs_mood_mellow'),
('BlogMood', '36', 36, '_bx_blogs_mood_mischievous'),
('BlogMood', '23', 23, '_bx_blogs_mood_moody'),
('BlogMood', '37', 37, '_bx_blogs_mood_morose'),
('BlogMood', '117', 117, '_bx_blogs_mood_naughty'),
('BlogMood', '97', 97, '_bx_blogs_mood_nauseated'),
('BlogMood', '102', 102, '_bx_blogs_mood_nerdy'),
('BlogMood', '134', 134, '_bx_blogs_mood_nervous'),
('BlogMood', '60', 60, '_bx_blogs_mood_nostalgic'),
('BlogMood', '124', 124, '_bx_blogs_mood_numb'),
('BlogMood', '61', 61, '_bx_blogs_mood_okay'),
('BlogMood', '70', 70, '_bx_blogs_mood_optimistic'),
('BlogMood', '58', 58, '_bx_blogs_mood_peaceful'),
('BlogMood', '73', 73, '_bx_blogs_mood_pensive'),
('BlogMood', '71', 71, '_bx_blogs_mood_pessimistic'),
('BlogMood', '24', 24, '_bx_blogs_mood_pissed off'),
('BlogMood', '109', 109, '_bx_blogs_mood_pleased'),
('BlogMood', '118', 118, '_bx_blogs_mood_predatory'),
('BlogMood', '89', 89, '_bx_blogs_mood_productive'),
('BlogMood', '105', 105, '_bx_blogs_mood_quixotic'),
('BlogMood', '77', 77, '_bx_blogs_mood_recumbent'),
('BlogMood', '69', 69, '_bx_blogs_mood_refreshed'),
('BlogMood', '123', 123, '_bx_blogs_mood_rejected'),
('BlogMood', '62', 62, '_bx_blogs_mood_rejuvenated'),
('BlogMood', '53', 53, '_bx_blogs_mood_relaxed'),
('BlogMood', '42', 42, '_bx_blogs_mood_relieved'),
('BlogMood', '54', 54, '_bx_blogs_mood_restless'),
('BlogMood', '100', 100, '_bx_blogs_mood_rushed'),
('BlogMood', '25', 25, '_bx_blogs_mood_sad'),
('BlogMood', '26', 26, '_bx_blogs_mood_satisfied'),
('BlogMood', '46', 46, '_bx_blogs_mood_scared'),
('BlogMood', '122', 122, '_bx_blogs_mood_shocked'),
('BlogMood', '82', 82, '_bx_blogs_mood_sick'),
('BlogMood', '66', 66, '_bx_blogs_mood_silly'),
('BlogMood', '49', 49, '_bx_blogs_mood_sleepy'),
('BlogMood', '27', 27, '_bx_blogs_mood_sore'),
('BlogMood', '28', 28, '_bx_blogs_mood_stressed'),
('BlogMood', '121', 121, '_bx_blogs_mood_surprised'),
('BlogMood', '81', 81, '_bx_blogs_mood_sympathetic'),
('BlogMood', '131', 131, '_bx_blogs_mood_thankful'),
('BlogMood', '29', 29, '_bx_blogs_mood_thirsty'),
('BlogMood', '30', 30, '_bx_blogs_mood_thoughtful'),
('BlogMood', '31', 31, '_bx_blogs_mood_tired'),
('BlogMood', '32', 32, '_bx_blogs_mood_touched'),
('BlogMood', '74', 74, '_bx_blogs_mood_uncomfortable'),
('BlogMood', '96', 96, '_bx_blogs_mood_weird'),
('BlogMood', '88', 88, '_bx_blogs_mood_working'),
('BlogMood', '85', 85, '_bx_blogs_mood_worried');
");
$iMaxOrder = db_value("SELECT `Order` FROM `sys_page_compose_pages` ORDER BY `Order` DESC LIMIT 1");
$iMaxOrder++;
db_res("
INSERT INTO `sys_page_compose_pages` (`Name`, `Title`, `Order`) VALUES ('bx_blogs_main', 'Main Blogs Page', $iMaxOrder)
");
db_res("
INSERT INTO `sys_page_compose` (`Page`, `PageWidth`, `Desc`, `Caption`, `Column`, `Order`, `Func`, `Content`, `DesignBox`, `ColWidth`, `Visible`, `MinWidth`) VALUES
('bx_blogs_main', '998px', 'Blog Categories', '_bx_blogs_block_common_categories', '1', '0', 'Categories', '', '1', '34', 'non,memb', '0'),
('bx_blogs_main', '998px', 'Recent Blogs', '_bx_blog_Recent_blog', '1', '1', 'RecentBlogs', '', '1', '34', 'non,memb', '0'),
('bx_blogs_main', '998px', 'Top Blogs', '_bx_blog_Top_blog', '1', '2', 'TopBlogs', '', '1', '34', 'non,memb', '0'),
('bx_blogs_main', '998px', 'Watched Blogs', '_bx_blog_Watched_blog', '1', '3', 'WatchedBlogs', '', '1', '34', 'non,memb', '0'),
('bx_blogs_main', '998px', 'Blog Archive', '_bx_blog_Archive', '1', '4', 'Archive', '', '1', '34', 'non,memb', '0'),
('bx_blogs_main', '998px', 'Blog Comments', '_bx_blogs_block_latest_comments', '1', '5', 'Comments', '', '1', '34', 'non,memb', '0'),
('bx_blogs_main', '998px', 'Blog Tags', '_bx_blog_tags', '1', '6', 'Tags', '', '1', '34', 'non,memb', '0'),
('bx_blogs_main', '998px', 'Create Blog', '_bx_blogs_block_create', '2', '0', 'Create', '', '1', '66', 'non,memb', '0'),
('bx_blogs_main', '998px', 'Featured Blogs', '_bx_blog_Featured_Posts', '2', '1', 'FeaturedPosts', '', '1', '66', 'non,memb', '0'),
('bx_blogs_main', '998px', 'Top Blog Posts', '_bx_blog_Latest_posts', '2', '2', 'RecentPosts', '', '1', '34', 'non,memb', '0'),
('bx_blogs_main', '998px', 'Top Blog Posts', '_bx_blog_Top_Posts', '2', '3', 'TopPosts', '', '1', '34', 'non,memb', '0'),
('bx_blogs_main', '998px', 'Popular Blogs', '_bx_blog_Popular_Posts', '2', '4', 'PopularPosts', '', '1', '34', 'non,memb', '0'),
('bx_blogs_main', '998px', 'Blogs Calendar', '_bx_blog_Calendar', '2', '5', 'Calendar', '', '1', '66', 'non,memb', '0'),
('bx_blogs_main', '998px', 'Blog Activities', '_bx_blogs_block_latest_activities', '2', '6', 'Activities', '', '1', '66', 'non,memb', '0')
");
db_res("
INSERT INTO `sys_page_compose` (`Page`, `PageWidth`, `Desc`, `Caption`, `Column`, `Order`, `Func`, `Content`, `DesignBox`, `ColWidth`, `Visible`, `MinWidth`) VALUES
('bx_blogs', '998px', 'Blog''s reactions block', '_bx_blogs_block_reactions', '2', '1', 'Reactions', '', '1', '66', 'non,memb', '0'),
('bx_blogs', '998px', 'Blog''s embed block', '_bx_blogs_block_video_embed', '2', '2', 'VideoEmbed', '', '1', '66', 'non,memb', '0')
");
db_res("UPDATE `sys_page_compose` SET `Order`=3 WHERE `Func`='PostComments'");
$iCategId = db_value("SELECT `id` FROM `sys_options_cats` WHERE `name`='Blogs'");
db_res("INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES
('bx_blogs_comments_max_preview', '150', $iCategId, 'length of comments snippets to show on main page', 'digit', '', '', '0', ''),
('bx_blogs_perpage_main_comment', '5', $iCategId, 'Number of comments to show in main page block', 'digit', '', '', '0', ''),
('bx_blogs_perpage_main_feed', '5', $iCategId, 'Number of activity feed entries to show in main page block', 'digit', '', '', '0', ''),
('bx_blogs_post_length', '65535', $iCategId, 'Max. allowable length of blog post', 'digit', '', '', '0', ''),
('bx_blogs_perpage_main', '4', $iCategId, 'Number of blog posts to show in main page blocks', 'digit', '', '', '0', '')
");
db_res("
CREATE TABLE IF NOT EXISTS `bx_blogs_react_tracking` (
`ReactID` int(11) NOT NULL,
`PostID` int(11) NOT NULL,
`MemberID` int(11) NOT NULL,
PRIMARY KEY (`ReactID`,`PostID`,`MemberID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ;
");
db_res("
CREATE TABLE IF NOT EXISTS `bx_blogs_react_admin` (
`ID` int(11) NOT NULL auto_increment,
`Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '',
`Active` int(11) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ;
");
db_res("
INSERT INTO `bx_blogs_react_admin` (`ID`, `Name`, `Active`) VALUES
(1, 'overwhelmed', 1),
(2, 'entertained', 1),
(3, 'happy', 1),
(4, 'inspired', 1),
(5, 'sad', 1),
(6, 'sympathetic', 1),
(7, 'surprised', 1),
(8, 'angry', 1),
(9, 'confused', 1),
(10, 'worried', 1);
");
db_res("
INSERT INTO `sys_objects_actions` (`ID`, `Caption`, `Icon`, `Url`, `Script`, `Eval`, `Order`, `Type`, `bDisplayInSubMenuHeader`) VALUES
(NULL, '{evalResult}', 'modules/boonex/blogs/|action_watch.png', '{blog_watch_link}&do=watch&id={blog_id}', '', '\$iPostWatched = (int){post_watched};
return (({visitor_id}=={owner_id}) && ({owner_id}>0)) ? '''' : ((\$iPostWatched==1) ? _t(''_bx_blogs_unwatch_this'') : _t(''_bx_blogs_watch_this''));', 5, 'bx_blogs_m', 0)
");
db_res("
INSERT INTO `sys_objects_actions` (`ID`, `Caption`, `Icon`, `Url`, `Script`, `Eval`, `Order`, `Type`, `bDisplayInSubMenuHeader`) VALUES
(NULL, '{evalResult}', 'modules/boonex/blogs/|action_sticky.png', '{post_entry_url}&do=sticky&id={post_id}', '', '\$iPostSticky = (int){post_sticky};\r\nif (({visitor_id}=={owner_id} && {owner_id}>0) || {admin_mode} == true) {\r\nreturn (\$iPostSticky==1) ? _t(''_bx_blogs_unsticky_this'') : _t(''_bx_blogs_sticky_this'');\r\n}\r\nelse\r\nreturn null;', 11, 'bx_blogs', 0)
");
db_res("
INSERT INTO `sys_email_templates` (`Name`, `Subject`, `Body`, `Desc`, `LangID`) VALUES
('bx_blogs_new_post_notify', 'New Post in a Watched Blog at <SiteName>', '<html><head></head><body style=\"font: 12px Verdana; color:#000000\"> <p>Hello <NickName>,</p> <p>A new Post, <a href=\"<PostUrl>\"><PostTitle></a>, has just been made in <a href=\"<BlogUrl>\"><BlogName></a></p> <p>--</p> <p style=\"font: bold 10px Verdana; color:red\"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Blog Post Notification', '0');
");
db_res("
INSERT INTO `sys_email_templates` (`Name`, `Subject`, `Body`, `Desc`, `LangID`) VALUES
('bx_blogs_update_post_notify', 'Updated Post in a Watched Blog at <SiteName>', '<html><head></head><body style=\"font: 12px Verdana; color:#000000\"> <p>Hello <NickName>,</p> <p>A Post, <a href=\"<PostUrl>\"><PostTitle></a>, has just been updated in <a href=\"<BlogUrl>\"><BlogName></a></p> <p>--</p> <p style=\"font: bold 10px Verdana; color:red\"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Blog Post Update Notification', '0');
");
echo "SUCCESSFULLY UPDATED DATABASE ..... <br /><br />";
echo "FINISHED <br />";
?>
and i got ... "database query" error
MY SITES http://viptopia.net general social networking | http://www.rangerschat.com/ niche site