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})"); } }