Beiträge von Chris3k

<?php
/*
Plugin Name: phpBB Post
Plugin URI: http://www.tecnosquad.com/
Description: Plugin creates topics in your phpBB forum, when you publish posts in WP.
Version: 0.001
Author: Amenadiel
Author http://www.tecnosquad.com/
*/
// ------------ definitions --------------




$posterID   =7; // ID of the poster bot
$postername ='Blog-Beitrag'; // Name of the poster bot
$defboard =2; // The board in which the comments posts will be
$forumprefix='phpbb_'; // prefix of your forum tables
$forumURL= 'http://lateknightsgang.la.funpic.de/forum/'; // URL of the forum http://lateknightsgang.la.funpic.de/
$blogURL=      'http://lateknightsgang.la.funpic.de'; // URL of the blog http://www.yourblog.com/
$discusstext= 'Im Forum besprechen'; // text of the blog link: "Comment this on the forum"
$backtext='Kommentiere diesen Artikel'; //text of the forum post: "Comment this article"


// ------------ actions --------------




add_action('activate_phpbb_post/phpbb_post.php', 'phpbb_install');
add_action('publish_post', 'phpbb_setpost');
add_filter('the_content', 'phpbb_add_forumlink');


if (isset($_GET['activate']) && $_GET['activate'] == 'true') {
   add_action('init', 'phpbb_install');
}




function phpbb_install() {
  global $table_prefix, $wpdb;
  
 $posts_table   = $table_prefix . "phpbb_post_posts";


    $sql0 = "CREATE TABLE ".$posts_table." (      `id` int(10) NOT NULL AUTO_INCREMENT,      `post_id` int(10) NOT NULL default '1',      `topic_id` int(10) NOT NULL default '1',      PRIMARY KEY (`id`)    );";
require_once(ABSPATH . 'wp-admin/upgrade-functions.php');
  dbDelta($sql0);




}




















function phpbb_add_forumlink($content = '') {
    global $id, $wpdb, $table_prefix, $forumURL, $discusstext, $forumprefix;


    $posts_table = $table_prefix . "phpbb_post_posts";


    $topic_id = $wpdb->get_var("SELECT topic_id FROM `$posts_table` WHERE `post_id` = $id LIMIT 1;");
    if ($topic_id != "") {
        $content = $content . "<p><a href='".$forumURL."viewtopic.php?t=".$topic_id."'>".$discusstext;
    
    
    $topic_posts = $wpdb->get_var("SELECT topic_replies FROM `".$forumprefix."topics` WHERE `topic_id` = $topic_id LIMIT 1;");
    
    
        $content = $content . " (".$topic_posts.")";
        $content = $content . "</a></p> ";
    }
    return $content;
}


























function phpbb_setpost($post_ID) {        // function for publish & save actions
    global $wpdb, $table_prefix, $backtext, $blogURL, $defboard ;
    $posts_table   = $table_prefix . "phpbb_post_posts";
    $post = get_post($post_ID);


    $title       = mysql_real_escape_string($post->post_title);
    $content     = mysql_real_escape_string(nl2br($post->post_content));
    $author      = $post->post_author;
    $author_name = get_author_name( $author );
    $now         = gmdate('Y-m-d H:i:s');
//    $forum       = phpbb_getoption('bb_forum');
    $meta        = get_post_meta($post_ID, "tags");




        if (phpbb_topic_exist($post_ID)) {






        } else {


            $topic_id = phpbb_bb_new_topic( $title, $defboard, $author, $author_name, $now );
            if ($topic_id) {
                phpbb_set_permlinks($topic_id,$post_ID);
                $contenido='<font size=4>'.$backtext.'<br><a href="'.$blogURL.'?p='.$post_ID.'">'.$title.'</a></font>';
                phpbb_bb_new_post($topic_id, $contenido, $forum, $author, $now);
                if ($meta[0] != "") { phpbb_tags($meta[0], $topic_id, $author); }
            }
        }


    return $post_ID;
}












function phpbb_topic_exist($post_id) {        // Exists topic or not
    global $table_prefix, $wpdb;
    $posts_table   = $table_prefix . "phpbb_post_posts";


    $topic_id=$wpdb->get_var("SELECT topic_id FROM `$posts_table` WHERE `post_id` = $post_id LIMIT 1;");


    if ($topic_id != '') {
        return true;
    } else {
        return false;
    }
}






function phpbb_set_permlinks($topic_id,$post_ID) {        // adding ID's of topic in forum & post in WP to db
    global $table_prefix, $wpdb, $forumprefix, $defboard;


    $posts_table   = $table_prefix . "phpbb_post_posts";


    $wpdb->query("INSERT INTO `$posts_table` VALUES ('', ". $post_ID .", ". $topic_id .");");
    return true;
}


function phpbb_bb_new_topic( $title, $forum, $author, $author_name, $now ) {    // making new topic in phpbb
    global $wpdb ,$otherdb, $defboard, $posterID, $postername, $forumprefix;
//    $bb_table_prefix = phpbb_getoption('bb_prefix');


    if ( $forum && $title ) {


            $wpdb->query("INSERT INTO `".$forumprefix."topics` (forum_id, topic_title, topic_poster,  topic_time)
                                              VALUES ($defboard, '$title', $posterID,  '$now')");
            $topic_id = $wpdb->insert_id;


            $wpdb->query("UPDATE `".$forumprefix."forums` SET forum_topics = forum_topics + 1 WHERE forum_id = ".$defboard."");
            $wpdb->query("UPDATE `".$forumprefix."forums` SET forum_posts = forum_posts + 1 WHERE forum_id = ".$defboard."");










        return $topic_id;
    } else {
        return false;
    }
}


function phpbb_bb_new_post( $topic_id, $content, $forum, $author, $now ) {        // making new post in phpbb
    global $wpdb, $otherdb, $posterID, $postername, $defboard, $forumprefix;
    $ora         = gmdate('Y-m-d H:i:s');
    


$wpdb->query("INSERT INTO `".$forumprefix."posts` (
`post_id` ,
`topic_id` ,
`forum_id` ,
`poster_id` ,
`post_time` ,
`poster_ip` ,
`post_username` ,
`enable_bbcode` ,
`enable_html` ,
`enable_smilies` ,
`enable_sig` ,
`post_edit_time` ,
`post_edit_count`
)
VALUES (
NULL , $topic_id, '$defboard', '$posterID', '$ora', '127.0.0.1', '$postername', '1', '0', '1', '1', NULL , '0'
);");






$post_id= $wpdb->insert_id;






 $wpdb->query("INSERT INTO `".$forumprefix."posts_text` (
`post_id` ,
`bbcode_uid` ,
`post_subject` ,
`post_text`
)
VALUES ('$post_id', '', '', '$content');");










        
                $wpdb->query("UPDATE `".$forumprefix."topics` SET `topic_first_post_id` = '$post_id',
`topic_last_post_id` = '$post_id' WHERE `".$forumprefix."topics`.`topic_id` ='$topic_id' LIMIT 1 ;");








              $wpdb->query("UPDATE `".$forumprefix."forums` SET forum_last_post_id =".$post_id."  WHERE forum_id = 1");
    }          
              
              
?>