<?php
/*
 * XPressME - WordPress for XOOPS
 *
 * @copyright	XPressME Project http://www.toemon.com
 * @license		http://www.fsf.org/copyleft/gpl.html GNU public license
 * @author		toemon
 * @package		module::xpress
 */

function wp_uid_to_xoops_uid($wp_uid = ''){
	global $xoopsDB,$xoops_db;
	$mydirname = basename( dirname( dirname( __FILE__ ) ) ) ;

	if ($mydirname == 'wordpress'){
		$wp_prefix = 'wp';
	} else {
		$wp_prefix = $mydirname;
	}

	if (empty($xoops_db)) { // not load XPressME
		$xoops_user_tbl = $xoopsDB->prefix('users');
		$wp_user_tbl = $xoopsDB->prefix($wp_prefix . "_users");

		$wp_user_SQL ="SELECT user_login FROM $wp_user_tbl WHERE ID = $wp_uid ";
		$wp_user_Res = $xoopsDB->query($wp_user_SQL, 0, 0);
		if ($xoopsDB->getRowsNum($wp_user_Res)  > 0){
			$wp_user_Row = $xoopsDB->fetchArray($wp_user_Res);
			$wp_user_name = $wp_user_Row['user_login'];
		
			$xoops_user_SQL ="SELECT uid FROM $xoops_user_tbl WHERE uname LIKE '$wp_user_name'";
			$xoops_user_Res = $xoopsDB->query($xoops_user_SQL, 0, 0);
			if ($xoopsDB->getRowsNum($xoops_user_Res)  > 0){
				$xoops_user_Row = $xoopsDB->fetchArray($xoops_user_Res);
				$xoops_uid = $xoops_user_Row['uid'];	
				return $xoops_uid;
			}
		}
		return 0;
	} else { // load XPressME or not Load XOOPS
		$xoops_user_tbl = get_xoops_prefix() . 'users';
		$wp_user_tbl = get_wp_prefix() . 'users';
		$wp_user_name = $xoops_db->get_var("SELECT user_login FROM $wp_user_tbl WHERE ID = $wp_uid ");
		if (empty($wp_user_name)) return 0;
		$xoops_uid = $xoops_db->get_var("SELECT uid FROM $xoops_user_tbl WHERE uname LIKE '$wp_user_name'");
		if (!empty($xoops_uid)) return $xoops_uid; else return 0;
	}
}
function xoops_uid_to_wp_uid($xoops_uid = ''){
	global $xoopsDB,$xoops_db;
	$mydirname = basename( dirname( dirname( __FILE__ ) ) ) ;

	if ($mydirname == 'wordpress'){
		$wp_prefix = 'wp';
	} else {
		$wp_prefix = $mydirname;
	}

	if (empty($xoops_db)) { // not load XPressME
		$xoops_user_tbl = $xoopsDB->prefix('users');
		$wp_user_tbl = $xoopsDB->prefix($wp_prefix . "_users");

		$xoops_user_SQL ="SELECT uname FROM $xoops_user_tbl WHERE uid =  $xoops_uid";
		$xoops_user_Res = $xoopsDB->query($xoops_user_SQL, 0, 0);
		if ($xoopsDB->getRowsNum($xoops_user_Res)  > 0){
			$xoops_user_Row = $xoopsDB->fetchArray($xoops_user_Res);
			$xoops_user_name = $xoops_user_Row['uname'];	

			$wp_user_SQL ="SELECT ID FROM $wp_user_tbl WHERE user_login LIKE '$xoops_user_name'";
			$wp_user_Res = $xoopsDB->query($wp_user_SQL, 0, 0);
			if ($xoopsDB->getRowsNum($wp_user_Res)  > 0){
				$wp_user_Row = $xoopsDB->fetchArray($wp_user_Res);
				$wp_user_id = $wp_user_Row['ID'];
				return $wp_user_id;
			}
		}
		return 0;
	} else { // load XPressME or not Load XOOPS
		$xoops_user_tbl = get_xoops_prefix() . 'users';
		$wp_user_tbl = get_wp_prefix() . 'users';
		$xoops_user_name = $xoops_db->get_var("SELECT uname FROM $xoops_user_tbl WHERE uid =  $xoops_uid");
		if (empty($xoops_user_name)) return 0;
		$wp_user_id = $xoops_db->get_var("SELECT ID FROM $wp_user_tbl WHERE user_login LIKE '$xoops_user_name'");
		if (!empty($wp_user_id)) return $wp_user_id; else return 0;
	}
	
}
?>