<?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;
	$mydirname = basename( dirname( dirname( __FILE__ ) ) ) ;

	if ($mydirname == 'wordpress'){
		$wp_prefix = 'wp';
	} else {
		$wp_prefix = $mydirname;
	}

	$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;
}
function xoops_uid_to_wp_uid($xoops_uid = ''){
	global $xoopsDB;
	$mydirname = basename( dirname( dirname( __FILE__ ) ) ) ;

	if ($mydirname == 'wordpress'){
		$wp_prefix = 'wp';
	} else {
		$wp_prefix = $mydirname;
	}

	$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;
}
?>