function D3forum_user_access_set($forum_module_dir, $forum_id, $accsess = 0)
{
global $xoops_db, $user_login;
$user_id = get_xoops_user_id($user_login);
$d3forum_forum_access_tbl = get_xoops_prefix() . $this->d3forum_module_dir . "_forum_access";
if (!$accsess) {
$sql = "DELETE FROM {$d3forum_forum_access_tbl} WHERE forum_id = {$forum_id} AND uid = {$user_id}";
$xoops_db->query($sql);
} else {
$sql = "SELECT * FROM {$d3forum_forum_access_tbl} WHERE forum_id = {$forum_id} AND uid = {$user_id}";
$row = $xoops_db->get_row($sql);
if (!$row) {
$sql = "INSERT INTO {$d3forum_forum_access_tbl} ";
$sql .= "(forum_id, uid, can_post, can_edit, can_delete, post_auto_approved, is_moderator) ";
$sql .= "VALUES ";
$sql .= "({$forum_id}, {$user_id}, 1, 1, 1, 1, 1)";
$xoops_db->query($sql);
}
}
}
function user_sync_to_xoops($user_ID)
{
global $xoops_db;
$user_info = get_userdata($user_ID);
$xoops_uid = get_xoops_user_id($user_info->user_login);
$db_xoops_users = get_xoops_prefix() . "users";
$user_regdate = strtotime($user_info->user_registered);
$aim = get_usermeta($user_ID, 'aim');
$yim = get_usermeta($user_ID, 'yim');
if ($xoops_uid) {
$wu_sql = "UPDATE {$db_xoops_users} ";
$wu_sql .= 'SET ';
$wu_sql .= "uname = '{$user_info->user_login}', ";
$wu_sql .= "pass = '******', ";
$wu_sql .= "email = '{$user_info->user_email}', ";
$wu_sql .= "url = '{$user_info->user_url}', ";
$wu_sql .= "name = '{$user_info->display_name}', ";
$wu_sql .= "user_aim = '{$aim}', ";
$wu_sql .= "user_yim = '{$yim}', ";
$wu_sql .= "user_regdate = {$user_regdate} ";
$wu_sql .= "WHERE (uid = {$xoops_uid} )";
$xoops_db->query($wu_sql);
} else {
$wu_sql = "INSERT INTO {$db_xoops_users} ";
$wu_sql .= "(uname , pass ,email , url , name , user_aim , user_yim , user_regdate) ";
$wu_sql .= "VALUES ";
$wu_sql .= "('{$user_info->user_login}', '{$user_info->user_pass}', '{$user_info->user_email}', '{$user_info->user_url}', '{$user_info->display_name}' ";
$wu_sql .= " , '{$aim}' , '{$yim}' , {$user_regdate} )";
$xoops_db->query($wu_sql);
// get xoops users default groupe ID
$db_xoops_group = get_xoops_prefix() . 'groups';
$default_xoops_group_id = $xoops_db->get_var("SELECT groupid FROM {$db_xoops_group} WHERE group_type = 'User'");
// get insert users ID
$db_xoops_group = get_xoops_prefix() . 'users';
$user_id = $xoops_db->get_var("SELECT uid FROM {$db_xoops_group} WHERE uname = '{$user_info->user_login}'");
// insert groups_users_link
$db_xoops_group_users_link = get_xoops_prefix() . 'groups_users_link';
$default_xoops_group_id = $xoops_db->get_var("INSERT INTO {$db_xoops_group_users_link} (groupid , uid ) VALUES ({$default_xoops_group_id} , {$user_id})");
}
}
