Wordpress integration plugin :) (Page 3 of 5)

function foo()
{
global $db;
// the code
}

There is no valid language pack '' installed. Please reinstall a language of that name.

Warning: include(../forum/config.php) [function.include]: failed to open stream: No such file or directory in C:\wamp\www\wp\wp-content\plugins\jl-punbb.php on line 62

$action = isset($_GET['action']) ? $_GET['action'] : null;

if ($action == 'out')
    header('Location: http://www.hugthecenterline.com/blog/wp-login.php?action=logout');
else
    header('Location: http://www.hugthecenterline.com/blog/wp-login.php');

<?php
/*
Plugin Name: punBB integrator
Plugin URI: http://www.rkblog.rk.edu.pl
Description: Allows Wordpress to manager punBB users - login/logout/register/password change etc.
Version: 0.0.13.666
Author: Riklaunim
Author URI: http://www.rkblog.rk.edu.pl
*/
add_action('profile_update', 'punbb_profile_update');
add_action('wp_logout', 'punbb_wp_logout');
add_action('wp_authenticate', 'punbb_wp_authenticate', 1, 2);
add_action('user_register', 'punbb_user_register');
add_action('activate_jl-punbb/jl-punbb.php', 'punbb_sync_tables');

define('PUNPATH', '../forum/'); // path to punbb folder
define('PUNPREFIX', 'pun_'); // punBB table prefix

function punbb_sync_tables()
    {
    global $wpdb;
    // copy users from WP to punBB that doesn't have account on punBB
    $q = $wpdb->get_results("SELECT * FROM ".$wpdb->users." WHERE user_login NOT IN (SELECT username FROM ".PUNPREFIX."users)");
    foreach($q as $u)
        {
        // give forum admin to the WP admin.
        if($u->ID == 1)
            {
            $gid = 1;
            }
        else
            {
            $gid = 4;
            }
        $wpdb->query('INSERT INTO '.PUNPREFIX.'users (username, group_id, password, email, email_setting, save_pass, timezone, language, style, registered, registration_ip, last_visit) VALUES(\''.$u->user_login.'\', '.$gid.', \'BRAK\', \''.$u->user_email.'\', 1, 1, 1 , \'English\', \'Oxygen\', '.time().', \''.strip_tags($_SERVER['REMOTE_ADDR']).'\', '.time().')');
        }
    // turn off emails for "dectivated" accounts on forum
    $wpdb->query('UPDATE '.PUNPREFIX.'users SET email_setting = 2 WHERE username NOT IN (SELECT user_login FROM '.$wpdb->users.') AND id > 1');
    }
    
function punbb_profile_update($id)
    {
    global $wpdb;
    $wpuser = $wpdb->get_row("SELECT user_login, user_email FROM ".$wpdb->users." WHERE ID = ".$id." LIMIT 1");
    $wpdb->query("UPDATE ".PUNPREFIX."users SET email='".$wpuser->user_email."' WHERE username = '".$wpuser->user_login."'");
    }
function punbb_wp_logout()
    {
    include PUNPATH.'/config.php';
    setcookie($cookie_name, NULL, time()-3600, '/', '', '0');
    }
function punbb_wp_authenticate($user_login, $user_pass)
    {
    global $wpdb;
     // wywo?aj przy logowaniu jak masz dane
     if($user_login and $user_pass and strlen($user_login) > 1 and strlen($user_pass) > 1)
         {
        $wpuser = $wpdb->get_row("SELECT id,user_pass FROM ".$wpdb->users." WHERE user_login = '".mysql_real_escape_string($user_login)."' LIMIT 1");
//        AUTHENTICATION FOR WORDPRESS HAS CHANGED IN VERSION 2.5
//        if(md5($user_pass) == $wpuser->user_pass)
        if(wp_check_password($user_pass, $wpuser->user_pass, $wpuser->id))
            {
            $user = $wpdb->get_row("SELECT id, password FROM ".PUNPREFIX."users WHERE username = '".mysql_real_escape_string($user_login)."' LIMIT 1");
            include PUNPATH.'/config.php';
            /*
            punBB uses sha1, wordpress md5. We have to cheat a bit. If the sha1 hash-password in punBB is "BRAK" (look at punbb_user_register)
            or it doesn't match sha1(password from good authentication) then we update it :)
            */

            //DEFINITIONS REQUIRED TO REQUIRE PUNS GLOBALS
            define('PUN_TURN_OFF_MAINT', 1);
            define('PUN_QUIET_VISIT', 1);
            define('PUN_ROOT', '../forum/');
            global $db, $pun_config, $pun_user, $lang_common;
            require PUN_ROOT.'include/common.php';

            //PUNS HASH METHOD HAS CHANGED... CALL THEIR FUNCTION
            if($user->password == 'BRAK' OR pun_hash($user_pass) != $user->password)
                {
                //COMMENTED THIS OUT BECAUSE I DON'T WANT IT TO RUN.  WILL NOT UPDATE PUN'S DB CORRECTLY
//                $wpdb->query("UPDATE ".PUNPREFIX."users SET password='".sha1($user_pass)."' WHERE username = '".mysql_real_escape_string($user_login)."'");
                }

            //SETTINGS REQUIRED TO SET PUNS LOGIN COOKIE
            $user_id = $user->id;
            $form_password_hash = pun_hash($user_pass);    // This could result in either an SHA-1 or an MD5 hash (depends on $sha1_available)    
            $expire = ($save_pass == '1') ? time() + 31536000 : 0;
            $cookie_name="punbb_cookie";
            $cookie_path="/";
            $cookie_secure = 0;
            $cookie_seed = "957942b8";    
            //SET THE COOKIE.  THIS IS TAKEN FROM PUN'S include/functions.php FILE.
            setcookie($cookie_name, serialize(array($user_id, md5($cookie_seed.$form_password_hash))), $expire, $cookie_path, $cookie_domain, $cookie_secure, true);

            }
         }
    }
function punbb_user_register($id)
    {
    global $wpdb;
    $wpuser = $wpdb->get_row("SELECT * FROM ".$wpdb->users." WHERE ID = ".$id." LIMIT 1");
    $user = $wpdb->get_row("SELECT id FROM ".PUNPREFIX."users WHERE username = '".mysql_real_escape_string($wpuser->user_login)."' LIMIT 1");
    // user already exists in punbb
    if($user->id)
        {
        $wpdb->query("UPDATE ".PUNPREFIX."users SET password='BRAK' WHERE username = '".mysql_real_escape_string($wpuser->user_login)."'");
        }
    // user does not exists
    else
        {
        $wpdb->query('INSERT INTO '.PUNPREFIX.'users (username, group_id, password, email, email_setting, save_pass, timezone, language, style, registered, registration_ip, last_visit) VALUES(\''.$wpuser->user_login.'\', 4, \'BRAK\', \''.$wpuser->user_email.'\', 1, 1, 1 , \'Polish\', \'Oxygen\', '.time().', \''.strip_tags($_SERVER['REMOTE_ADDR']).'\', '.time().')');
        }
    }

?>