mybb_db_found) { $wordbb_post_author=get_option('wordbb_post_author'); if(false===$wordbb_post_author || empty($wordbb_post_author)) $errors[]='Default post author field empty'; else { if(!wordbb_get_user_info_by_username($wordbb_post_author)) $errors[]='Default post author username does not exist on MyBB'; } } if(!empty($errors)) wordbb_set_errors('Configuration is not complete. Go to WordBB Options',$errors,false); return (empty($errors)); } function wordbb_init() { global $wordbb, $wpdb; $wordbb = new stdClass(); $wordbb->errors=array(); $wordbb->bridges=array(); $wordbb->loop_started=false; // check if meta table exists, if not create it $wpdb->query("CREATE TABLE IF NOT EXISTS `wordbb_meta` (`type` enum('cat','post','user'),`wp_id` int(11),`mybb_id` int(11))"); $prefix=get_option('wordbb_dbprefix'); if(empty($prefix)) $prefix='mybb_'; // store mybb db table names $wordbb->table_forums=$prefix.'forums'; $wordbb->table_forumpermissions=$prefix.'forumpermissions'; $wordbb->table_users=$prefix.'users'; $wordbb->table_posts=$prefix.'posts'; $wordbb->table_threads=$prefix.'threads'; $wordbb->table_settings=$prefix.'settings'; $wordbb->mybb_db_found=wordbb_select_mybb_db(); if($wordbb->mybb_db_found) { $configured=wordbb_check_config(); } wordbb_display_errors(); if($configured) { // store mybb url $wordbb->mybb_url=get_option('wordbb_mybb_url'); // store mybb inc folder path $wordbb->mybb_inc=get_option('wordbb_mybb_abs'); // wordbb plugin url $wordbb->plugin_url=get_bloginfo('wpurl'). "/wp-content/plugins/" . plugin_basename(dirname(__FILE__)); // wordbb js url $wordbb->js_url=$wordbb->plugin_url.'/wordbb.js'; // plugin action file url $wordbb->action_url=$wordbb->plugin_url.'/actions.php'; // mybb settings $wordbb->mybbsettings=_wordbb_get_mybb_settings(); // forums array $wordbb->forums=_wordbb_get_forums(); /*$users=_wordbb_get_users(); $wordbb->users=$users['usernames']; $wordbb->usersinfo=$users['usersinfo'];*/ // store default author's id $post_author=wordbb_get_user_info_by_username($wordbb_post_author); if(!empty($post_author)) $wordbb_post_author=$post_author->uid; // get currently logged in info (if any) $mybbuser=$_COOKIE['mybbuser']; if(isset($mybbuser) && !empty($mybbuser)) { $mybbuser=explode('_',$mybbuser); $uid=$mybbuser[0]; $key=$mybbuser[1]; $userinfo=wordbb_get_user_info($uid); if($userinfo->loginkey==$key) $wordbb->loggeduserinfo=$userinfo; } // store IDs of forums non visible by the currently logged in user $usergroup=1; if(!empty($wordbb->loggeduserinfo)) { $usergroup=(int)$wordbb->loggeduserinfo->usergroup; } $exclude_fids=array(); $forums=$wordbb->mybbdb->get_results($wordbb->mybbdb->prepare("SELECT fid FROM {$wordbb->table_forumpermissions} WHERE gid=%d AND (canview=0 OR canviewthreads=0)",$usergroup)); foreach($forums as $forum) { $exclude_fids[]=$forum->fid; } $wordbb->exclude_fids=$exclude_fids; // define WP pluggables functions wordbb_pluggables(); } return $configured; } function wordbb_admin_head() { global $wordbb; echo ' '; } function wordbb_admin_init() { global $wordbb; // register settings register_setting( 'wordbb', 'wordbb_post_forum', 'intval' ); register_setting( 'wordbb', 'wordbb_post_author', '' ); register_setting( 'wordbb', 'wordbb_mybb_url' ); register_setting( 'wordbb', 'wordbb_mybb_abs', 'wordbb_mybb_abs_sanitize' ); register_setting( 'wordbb', 'wordbb_dbname' ); register_setting( 'wordbb', 'wordbb_dbuser' ); register_setting( 'wordbb', 'wordbb_dbpass' ); register_setting( 'wordbb', 'wordbb_dbhost' ); register_setting( 'wordbb', 'wordbb_dbprefix' ); register_setting( 'wordbb', 'wordbb_create_thread' ); register_setting( 'wordbb', 'wordbb_create_thread_excerpt' ); register_setting( 'wordbb', 'wordbb_create_thread_post_link' ); register_setting( 'wordbb', 'wordbb_create_thread_post_link_place' ); register_setting( 'wordbb', 'wordbb_create_thread_post_link_text' ); register_setting( 'wordbb', 'wordbb_delete_thread' ); register_setting( 'wordbb', 'wordbb_use_mybb_comments' ); register_setting( 'wordbb', 'wordbb_show_mybb_comments' ); register_setting( 'wordbb', 'wordbb_redirect_mybb' ); register_setting( 'wordbb', 'wordbb_langtoday', 'wordbb_langtoday_sanitize' ); register_setting( 'wordbb', 'wordbb_langyesterday', 'wordbb_langyesterday_sanitize' ); function wordbb_mybb_abs_sanitize($v) { return str_replace('\\', '/', $v); } function wordbb_langtoday_sanitize($v) { if(empty($v)) $v='Today'; return $v; } function wordbb_langyesterday_sanitize($v) { if(empty($v)) $v='Yesterday'; return $v; } // enqueue wordbb js wp_enqueue_script('wordbb_js',$wordbb->js_url,array('jquery'),'0.1'); } function wordbb_register_widget() { // register_sidebar_widget('WordBB Latest Threads', 'wordbb_widget'); // register_widget_control('WordBB Latest Threads', 'wordbb_widget_control'); $widget_options = array('classname' => 'wordbb_widget', 'description' => "Shows latest MyBB threads/posts on your sidebar." ); wp_register_sidebar_widget('wordbb_widget','WordBB Latest Threads','wordbb_widget',$widget_options); wp_register_widget_control('wordbb_widget','WordBB Latest Threads','wordbb_widget_control',$widget_options); } function wordbb_widget_control() { if($_POST['wordbb_widget_submit']) { $mode=$_POST['wordbb_widget_mode']; $title=$_POST['wordbb_widget_title']; if(!isset($title) || empty($title)) $title='Forums Latest '.($mode=='threads'?'Threads':'Posts'); $exclude=$_POST['wordbb_widget_exclude']; $usernames=$_POST['wordbb_widget_usernames']; if(!empty($exclude)) { $exclude=explode(',',trim($exclude)); $fids=array(); for($i=0; $i0) $fids[]=$fid; } $exclude=implode(',',$fids); } $count=intval($_POST['wordbb_widget_count']); if($count<=0) $count=10; update_option('wordbb_widget_title',$title); update_option('wordbb_widget_mode',$mode); update_option('wordbb_widget_exclude',$exclude); update_option('wordbb_widget_usernames',$usernames); update_option('wordbb_widget_count',$count); } $title=get_option('wordbb_widget_title'); $mode=get_option('wordbb_widget_mode'); $exclude=get_option('wordbb_widget_exclude'); $usernames=get_option('wordbb_widget_usernames'); $count=get_option('wordbb_widget_count'); ?> errors['title']; $errors_array=$wordbb->errors['errors']; $errors=''; if(is_array($errors_array)) { $errors.='errors_title='.urlencode($errors_title).'&'; foreach($errors_array as $wordbb_error) { $errors.='errors[]='.urlencode($wordbb_error).'&'; } $errors=rtrim($errors,'&'); } if(!empty($errors)) $location.='&'.$errors; return $location; } function wordbb_set_errors($title,$errors,$getparams=true) { global $wordbb; $wordbb->errors=array('title'=>$title,'errors'=>$errors); if($getparams) add_filter('wp_redirect',wordbb_error_handling); } function wordbb_display_errors() { global $wordbb; if(empty($wordbb->errors)) { $wordbb->errors['title']=$_GET['errors_title']; $wordbb->errors['errors']=$_GET['errors']; } // display error messages if(isset($wordbb->errors['errors'])) { function wordbb_error() { global $wordbb; $errors_message=''; echo "

".__('WordBB errors — “'.$wordbb->errors['title'].'” ')."

".$errors_message."

"; } add_action('admin_notices', 'wordbb_error'); } } function wordbb_do_action($action,$params) { global $wordbb; $params['wordbb_mybb_abs']=get_option('wordbb_mybb_abs'); $params['_wordbbnonce']=wordbb_create_nonce($action); // uses parse_url to validate data // tnx to Tikitiki $url = parse_url($wordbb->action_url); if(!$url['host']) { return false; } if(!$url['port']) { $url['port'] = 80; } if(!$url['path']) { $url['path'] = "/"; } if($url['query']) { $url['path'] .= "?{$url['path']}"; } $reqbody = ""; $reqbody.= "action=".urlencode($action); foreach($params as $key=>$val) { if (!empty($reqbody)) $reqbody.= "&"; $reqbody.= $key."=".urlencode($val); } $contentlength = strlen("$reqbody\r\n"); // tnx to Rog // tnx to mike for letting me discover the Host \r\n bug $reqheader = "POST {$url['path']} HTTP/1.0\r\n". "Host: {$url['host']}\r\n". "User-Agent: PostIt\r\n". "Connection: Close\r\n". "Content-Type: application/x-www-form-urlencoded\r\n". "Content-Length: $contentlength\r\n\r\n". "$reqbody\r\n"; $socket = @fsockopen($url['host'], $url['port'], $errno, $errstr); @stream_set_timeout($socket, 10); if(!$socket) { return false; } fputs($socket, $reqheader); while(!feof($socket)) { $result .= fgets($socket, 12800); } fclose($socket); //separate header and content $data = explode("\r\n\r\n", $result, 2); //$result=array('header'=>$data[0],'body'=>$data[1]); $result=unserialize($data[1]); if($result===false) $result=$data[1]; return $result; } function wordbb_plugin_menu() { add_posts_page('WordBB Categories', 'WordBB Categories', 8, 'wordbb-categories', 'wordbb_categories_page'); } function wordbb_plugin_options_menu() { add_options_page('WordBB Options', 'WordBB Options', 8, 'wordbb-options', 'wordbb_options_page'); } function wordbb_options_page() { global $wordbb; ?>

WordBB Options

'); ?>

MyBB data

Bridge settings and comment system

/>
/>
/>  /> />

/>
/>
/>
/>
forums,'wordbb_post_forum',get_option('wordbb_post_forum'),'',array(),'fid'); if(empty($html)) echo '(mybb forums table not available)'; else echo $html; ?>

Friendly last visit

* Leaving the database fields empty, the plugin will assume that MyBB is installed on the same database as WordPress.

** When this option is active, comments links will redirect to the corresponding MyBB threads (if any).

*** When this option is active, MyBB posts will be displayed as WordPress comments in WP blog posts.
WARNING: Note that your comment form will still use WordPress' comment system, so if MyBB posts are displayed as comments on a specific post, any comment sent on that post will not be displayed when this option is active. You may want to encapsulate the comment form in your WordPress theme in an if statement using the wordbb_get_thread_id() function, e.g. if(!wordbb_get_thread_id()) { // show WP comment form } else { // show link to MyBB thread using wordbb_thread_link() }. For more details, please refer to this page.


http://valadilene.org/wordbb (documentation) (changelog) - Follow me on Twitter!
If you find this plugin useful or want to motivate me in my projects, please send me some pizza money! You can use the form in the sidebar over at http://valadilene.org/wordbb or the button below. Thanks!'); ?>

WordBB Categories

Do not forget to activate HTML code on the MyBB forums you link to WordPress.
'); ?>

add_query_arg( 'pagenum', '%#%' ), 'format' => '', 'prev_text' => __('«'), 'next_text' => __('»'), 'total' => ceil(wp_count_terms($taxonomy) / $tags_per_page), 'current' => $pagenum )); if ( $page_links ) echo "
$page_links
"; ?>
'post', 'child_of' => 0, 'orderby' => 'name', 'order' => 'ASC', 'exclude' => $exclude, 'hide_empty' => false, 'include_last_update_time' => false, 'hierarchical' => true, 'pad_counts' => true); $cats = get_categories($args); ?> cat_ID); if($bridge) { $cat_forum=$bridge->mybb_id; } $html=wordbb_get_array_html($wordbb->forums,"wordbb_cat_forums[$cat->cat_ID]",$cat_forum,'(default)',array(get_option('wordbb_post_forum')),'fid'); ?> >
Name Description Slug MyBB Forum
Name Description Slug MyBB Forum
name ?>
Edit | Quick Edit | Delete
 slug ?>

mybb_id; } return wordbb_get_array_html($wordbb->forums,"wordbb_cat_forums[$id]",$cat_forum,'(default)',array(get_option('wordbb_post_forum')),'fid'); } break; } }*/ function wordbb_get_array_html($array,$name,$default='',$blank='',$exclude=array(),$id_text='id') { global $wordbb; if(!$array) return false; $html=''; $html.=''; return $html; } function wordbb_filter_post_content($content) { // remove more tag $content=str_replace('','',$content); return $content; } function wordbb_get_post_teaser($post) { $content=$post->post_content; $excerpt=$post->post_excerpt; if(!empty($excerpt)) return $excerpt; // remove more tag $content=explode('',$content); return $content[0]; } function wordbb_publish_post($id) { global $wordbb; if(get_option('wordbb_create_thread')!="on") return; wordbb_bridge_wp_post($id); } function wordbb_bridge_wp_post($id) { $post_bridge=wordbb_get_bridge(WORDBB_POST,$id); $post=get_post($id); if(get_option('wordbb_create_thread_excerpt')=="on") { $post_content=wordbb_get_post_teaser($post); } else { $post_content=wordbb_filter_post_content($post->post_content); } if(get_option('wordbb_create_thread_post_link')=="on") { $link_text=get_option('wordbb_create_thread_post_link_text'); if(empty($link_text)) { $link_text=__('Read the full article on the blog.'); } $link_text=str_replace('%title%',$post->post_title,$link_text); $link=''.$link_text.''; if(get_option('wordbb_create_thread_post_link_place')=='before') { $post_content=$link.'
'.$post_content; } else { $post_content=$post_content.'
'.$link; } } $categories=get_the_category($post->ID); foreach($categories as $category) { // get mybb forum corresponding to wp post category $fid=false; $bridge=wordbb_get_bridge(WORDBB_CAT,$category->cat_ID); if($bridge) $fid=$bridge->mybb_id; if(empty($fid)) { // if a bridge was not found, use default forum $fid=get_option('wordbb_post_forum'); if(empty($fid)) { // still nothing, give up continue; } } // get mybb user corresponding to wp post author $uid=false; $bridge=wordbb_get_bridge(WORDBB_USER,$post->post_author); if($bridge) $uid=$bridge->mybb_id; if(empty($uid)) { // if a bridge was not found, use default author $post_author=wordbb_get_user_info_by_username(get_option('wordbb_post_author')); if(!empty($post_author)) $uid=$post_author->uid; if(!$uid) return; } if($post_bridge) { $params=array(); $params['tid']=$post_bridge->mybb_id; $params['subject']=$post->post_title; $params['message']=$post_content; $params['fid']=$fid; $params['uid']=$uid; $params['ip']=wordbb_get_ip(); $ret=wordbb_do_action('update_thread',$params); if(is_array($ret)) { wordbb_set_errors($post->post_title,$ret); return; } } else { $params=array(); $params['subject']=$post->post_title; $params['message']=$post_content; $params['fid']=$fid; $params['uid']=$uid; $params['ip']=wordbb_get_ip(); $ret=wordbb_do_action('create_thread',$params); if(is_array($ret)) { if(!isset($ret['tid'])) { wordbb_set_errors($post->post_title,$ret); return; } // create bridge wordbb_bridge(WORDBB_POST,$id,$ret['tid'],WORDBB_WP); } } } } function wordbb_delete_bridge_thread($post,$force=false) { if(!$force && get_option('wordbb_delete_thread')!="on") return; $bridge=wordbb_get_bridge(WORDBB_POST,$post); if($bridge) { $params=array(); $params['tid']=$bridge->mybb_id; $ret=wordbb_do_action('delete_thread',$params); if(intval($ret)===1) { wordbb_bridge(WORDBB_POST,$post,'',WORDBB_WP); } } } function wordbb_users_columns($defaults) { $defaults['wordbb_mybb_user'] = __('MyBB user'); return $defaults; } function wordbb_users_custom_column($value, $column_name, $id) { global $wordbb; if($column_name!='wordbb_mybb_user') return; $bridge=wordbb_get_bridge(WORDBB_USER,$id); $mybb_uid=$bridge->mybb_id; /* $users=array(); foreach($wordbb->users as $uid=>$user) { $user_bridge=wordbb_get_bridge(WORDBB_USER,'',$uid); if(empty($user_bridge) || (!empty($user_bridge) && $user_bridge->wp_id==$id)) $users[$uid]=$user; } return wordbb_get_array_html($users,"wordbb_users[$id]",$mybb_uid,'',array(),'uid');*/ $mybb_user=wordbb_get_user_info($mybb_uid); if(!empty($mybb_user)) $username=$mybb_user->username; return ''; } function wordbb_posts_columns($defaults) { $defaults['wordbb_mybb_thread'] = "MyBB thread"; // unset($defaults['tags']); return $defaults; } function wordbb_posts_custom_column($column_name, $id) { global $wordbb; if(!$wordbb->postcounts) { // act like this is a WP loop, so we can have postcounts and stuff wordbb_loop_start(); } $post=get_post($id); $bridge=wordbb_get_bridge(WORDBB_POST,$id); if($bridge) { $tid=$bridge->mybb_id; } switch($column_name) { case 'wordbb_mybb_thread': { echo "
"; if(empty($tid)) { ?> Create thread post_title."\'\\n\'Cancel\' to stop, \'OK\' to delete.')"; ?> Sync - Delete - View (postcounts[$tid]; ?>)
loop_started) { return; } $tids=array(); $posts=&$wp_query->posts; if($posts) { foreach($posts as $post) { $bridge=wordbb_get_bridge(WORDBB_POST,$post->ID); if(!empty($bridge)) $tids[]=$bridge->mybb_id; } if(!empty($tids)) { $wordbb->postcounts=_wordbb_get_threads_postcounts($tids); $wordbb->posts=_wordbb_get_threads_posts($tids); $wordbb->lastposters=_wordbb_get_threads_lastposters($tids); $wordbb->comment=0; } } $wordbb->loop_started=true; } function wordbb_loop_end() { global $wordbb; $wordbb->loop_started=false; } function wordbb_comment_loop_start() { $wordbb->comment=0; } function wordbb_admin_users_update() { $wordbb_users=$_GET['wordbb_users']; if(!isset($wordbb_users)) return; foreach($wordbb_users as $id=>$wordbb_user) { $mybb_user=wordbb_get_user_info_by_username($wordbb_user); if(!empty($mybb_user)) { wordbb_bridge(WORDBB_USER,$id,$mybb_user->uid,WORDBB_WP); } else { wordbb_bridge(WORDBB_USER,$id,'',WORDBB_WP); } } } function wordbb_comment_on_post($comment_post_ID) { global $wordbb; $bridge=wordbb_get_bridge(WORDBB_POST,$comment_post_ID); if(!empty($bridge)) { // post this reply to the corresponding thread $comment_content = ( isset($_POST['comment']) ) ? trim($_POST['comment']) : null; $params=array(); $params['message']=stripslashes($comment_content); $params['uid']=$wordbb->loggeduserinfo->uid; $params['tid']=$bridge->mybb_id; $params['ip']=wordbb_get_ip(); $ret=wordbb_do_action('create_post',$params); $pid=$ret['pid']; if(get_option('wordbb_redirect_mybb')=='on') $location=$wordbb->mybb_url.'/showthread.php?tid='.$bridge->mybb_id.'&pid='.$pid.'#pid'.$pid; else $location=get_permalink($comment_post_ID).'#comment-'.$pid; header('Location: '.$location); exit; } } function wordbb_get_comments_number($count) { global $wordbb, $post; $bridge=wordbb_get_bridge(WORDBB_POST,$post->ID); if(!empty($bridge)) return $wordbb->postcounts[$bridge->mybb_id]; return $count; } function wordbb_get_comments_array($comments) { global $wordbb, $post; $bridge=wordbb_get_bridge(WORDBB_POST,$post->ID); if(!empty($bridge)) { $comments=null; $replies=&$wordbb->posts[$bridge->mybb_id]; if(!empty($replies)) { $comments=array(); foreach($replies as $reply) { $comment = null; $comment->comment_ID = $reply->pid; $comment->comment_post_ID = $post->ID; $comment->comment_author = $reply->username; $comment->comment_author_email = ""; $comment->comment_author_url = $wordbb->mybb_url.'/member.php?action=profile&uid='.$reply->uid; $comment->comment_author_IP = $reply->ipaddress; $comment->comment_date = date('Y-m-d H:i:s',$reply->dateline); $comment->comment_date_gmt = date('Y-m-d H:i:s',$reply->dateline); $comment->comment_content = $reply->message; $comment->comment_karma = "0"; $comment->comment_approved = "1"; $comment->comment_agent = ""; $comment->comment_type = ""; $comment->comment_parent = $reply->replyto; $comment->user_id = "0"; $comments[]=$comment; } } } return $comments; } function wordbb_get_comment_link($link,$comment,$args) { global $wordbb, $post; if(empty($post_ID)) $post_ID=$post->ID; $wordbb->last_comment=$wordbb->comment; $bridge=wordbb_get_bridge(WORDBB_POST,$post_ID); $tid=$bridge->mybb_id; $pid=$wordbb->posts[$tid][$wordbb->last_comment]->pid; // increment current comment counter $wordbb->comment++; return $wordbb->mybb_url.'/showthread.php?tid='.$tid.'&pid='.$pid.'#pid'.$pid; } function wordbb_comment_reply_link($link,$args,$comment,$post) { global $wordbb; extract($args, EXTR_SKIP); $bridge=wordbb_get_bridge(WORDBB_POST,$post->ID); if(!empty($bridge)) { $tid=$bridge->mybb_id; $pid=$wordbb->posts[$tid][$wordbb->last_comment]->pid; $url=$wordbb->mybb_url.'/newreply.php?tid='.$tid.'&pid='.$pid.'#pid'.$pid; $link="{$reply_text}"; } return $before.$link.$after; } /* function wordbb_user_register($id) { $user=get_userdata($id); $params=array(); $params['username']=$user->user_login; $params['password']=$_POST['pass1']; $params['email']=$user->user_email; $ret=wordbb_do_action('create_mybb_user',$params); if(is_array($ret)) { wordbb_set_errors('MyBB user registration',$ret); return; } // create bridge wordbb_bridge(WORDBB_USER,$id,$ret['tid'],WORDBB_WP); } function wordbb_user_delete($id) { // remove user bridge wordbb_bridge(WORDBB_USER,$id); }*/ ?>