XPressME Integration Kit

Trac

Context Navigation

source: trunk/xpressme_integration_kit/wp-content/plugins/xpressme/include/user_sync_xoops.php @ 534

Visit:

Last change on this file since 534 was 534, checked in by toemon, 14 years ago
グループ権限のMultiBlog対応 Fixes #298
File size: 14.4 KB

Line
1	<?php
2	/*
3	* Get The level from the capabillities name.
4	*/
5	function get_role_level($capabillities){
6	if ($capabillities == 'default') $capabillities = get_option('default_role');;
7	switch($capabillities) {
8	case 'administrator':
9	return 5;
10	case 'editor':
11	return 4;
12	case 'author':
13	return 3;
14	case 'contributor':
15	return 2;
16	case 'subscriber':
17	return 1;
18	default:
19	return 0;
20	}
21	}
22
23	/*
24	* The highest authority and the accompanying data
25	* in the WordPress authority given to the group to which the user belongs are obtained.
26	*/
27	function get_xoops_group_role($uid=0){
28	if ($uid == 0){
29	return '';
30	}
31
32	global $xoops_db;
33
34	$db_groups_users_link = get_xoops_prefix() . 'groups_users_link';
35	$db_group_role = get_wp_prefix() . 'group_role';
36	$db_groups = get_xoops_prefix() . 'groups';
37
38	$blog_id_list = array();
39
40	if (function_exists('is_multisite') && is_multisite()){
41	$blog_id_sql = "SELECT blog_id FROM $db_group_role GROUP BY blog_id";
42	$blog_id_list = $xoops_db->get_results($blog_id_sql);
43	} else {
44	$std = new stdClass();
45	$std->blog_id = 1;
46	$blog_id_list[] = $std;
47	}
48
49	$ans_array = array();
50	foreach($blog_id_list as $blog_id){
51	$ans = array();
52	$sql = "SELECT * ";
53	$sql .= "FROM $db_groups_users_link ";
54	$sql .= "LEFT JOIN $db_group_role ON $db_groups_users_link.groupid = $db_group_role.groupid ";
55	$sql .= "LEFT JOIN $db_groups ON $db_groups_users_link.groupid = $db_groups.groupid ";
56	$sql .= "WHERE uid = $uid AND $db_group_role.blog_id = $blog_id->blog_id";
57	$user_groups = $xoops_db->get_results($sql);
58
59	//default value set
60	$ans['blog_id'] = $blog_id->blog_id;
61	$ans['capabillities'] = '';
62	$ans['allway_update'] = 0;
63
64	//get maximum role
65	foreach($user_groups as $user_group){
66	if ($user_group->group_type == 'Admin'){
67	$ans['capabillities'] = 'administrator';
68	if ($user_group->groupid =1){
69	//It always rewrites it as WordPress adninistrator for an initial admin group of XOOPS.
70	$ans['allway_update'] = 1;
71	} else {
72	// admin groups other than initial admin group of XOOPS
73	// It group rewrites group_type of the data base in Admin.
74	$ans['allway_update'] = $user_group->login_all;
75	}
76	break;
77	}
78	$before_level = get_role_level($ans['capabillities']);
79
80	$now_level = get_role_level($user_group->role);
81	if ($now_level > $before_level){
82	$ans['capabillities'] = $user_group->role;
83	$ans['allway_update'] = $user_group->login_all;
84	}
85	}
86	$ans_array[] = $ans;
87	}
88	return $ans_array;
89	}
90
91	// for Multi Blog group_role delete
92	function blog_group_role_delete($blog_id,$drop = false) {
93	global $xoops_db;
94
95	$db_group_role = get_wp_prefix() . 'group_role';
96	if ($drop){
97	$delsql = "DELETE FROM $db_group_role WHERE blog_id = $blog_id";
98	$xoops_db->query($delsql);
99	}
100	}
101
102	// for Multi Blog group_role add
103	function blog_group_role_add($blog_id,$uid = 0) {
104	global $xoops_db,$xpress_config;
105	$xpress_config->GroupeRoleCheck($blog_id);
106	}
107
108	// check user has groupe role
109	function has_group_role($uid = 0) {
110	if (empty($uid)) return false;
111	$user_roles = get_xoops_group_role($uid);
112	foreach ($user_roles as $user_role){
113	if (!empty($user_role['capabillities']))
114	return true;
115	}
116	return false;
117	}
118
119	/*
120	* WP User ID exists is checked..
121	*/
122	function set_user_role($uid=0,$new_user = false){
123	$roles = get_xoops_group_role($uid);
124
125	foreach($roles as $role){
126	$b_id = $role['blog_id'];
127	$capabillities_name = $role['capabillities'];
128	$allway_update = $role['allway_update'];
129	if ($allway_update \|\| $new_user ){
130	$sycc_user = new WP_User($uid);
131	if (function_exists('is_multisite') && is_multisite()){
132	$sycc_user->for_blog($b_id); // for Multi blog
133	}
134	// check user role is admin
135	$is_blog_admin = false;
136	$user_roles = $sycc_user->roles;
137	foreach ($user_roles as $user_role){
138	if (strcmp($user_role , 'administrator') == 0){
139	$is_blog_admin = true;
140	break;
141	}
142	}
143	if (!$is_blog_admin){ // admin not change role
144	$sycc_user->set_role($capabillities_name);
145	}
146	}
147	// $message .= '...UPDATE ' . $xoops_user->uname . '(' . $capabillities_name . ')';
148	// $message .= '...INSERT ' . $user_login_name . '(' . $capabillities_name . ')';
149	}
150
151	}
152
153	/*
154	* Get User ID of WordPress from the login name.
155	*/
156	function get_wp_user_id($login_name){
157	global $xoops_db;
158	$sql = "SELECT ID FROM " . get_wp_prefix() . "users WHERE user_login = '$login_name'";
159	$uid = $xoops_db->get_var($sql);
160	return $uid;
161	}
162
163	/*
164	* WP User ID exists is checked..
165	*/
166	function is_used_wp_user_id($uid){
167	global $xoops_db;
168	$sql = "SELECT ID FROM " . get_wp_prefix() . "users WHERE ID = $uid";
169	$uid = $xoops_db->get_var($sql);
170	if (empty($uid))
171	return false;
172	else
173	return true;
174	}
175
176	/*
177	* The user data of XOOPS is written in the WordPress user data.
178	* If $sync_uid is 0, all users are written.
179	*/
180	function user_sync_to_wordpress($sync_uid = 0, &$message){
181	global $xoops_db;
182
183	$db_xoops_users = get_xoops_prefix() . 'users';
184	$db_xpress_users = get_wp_prefix() . 'users';
185
186	$message = 'Do Sync';
187
188	if ($sync_uid == 0) {
189	$xu_sql = "SELECT uid ,name ,uname ,pass ,email, url, user_regdate, user_aim, user_yim FROM $db_xoops_users";
190	} else {
191	$xu_sql = "SELECT uid ,name ,uname ,pass ,email, url, user_regdate, user_aim, user_yim FROM $db_xoops_users WHERE uid = $sync_uid";
192	}
193
194	$xoops_users = $xoops_db->get_results($xu_sql);
195
196	if (empty($xoops_users)){
197	$message .= '...ERR ('. $xu_sql . ')';
198	return false;
199	}
200
201	foreach($xoops_users as $xoops_user){
202
203	$wp_user_id = get_wp_user_id($xoops_user->uname) ;
204
205
206	$has_role = has_group_role($xoops_user->uid);
207	if (!$has_role){
208	if ($sync_uid != 0){
209	if ($wp_user_id) {
210	if ($allway_update){
211	$message .= '...NOT XPRESS USER ' . $xoops_user->uname;
212	return false;
213	}
214	} else {
215	$message .= '...NOT XPRESS USER ' . $xoops_user->uname;
216	return false;
217	}
218	} else {
219	$message .= "...PASS '" . $xoops_user->uname ."'[uid=".$xoops_user->uid ."](not xpress user)";
220	continue;
221	}
222	}
223
224	$user_regist_time = date('Y-m-d H:i:s' , $xoops_user->user_regdate);
225	$user_status = 0;
226	$user_display_name =empty($xoops_user->name) ? $xoops_user->uname :$xoops_user->name ;
227
228	$is_update = false;
229
230	if ($wp_user_id){
231	$add_user = true;
232	$wu_sql = "UPDATE $db_xpress_users ";
233	$wu_sql .= 'SET ';
234	$wu_sql .= "user_pass = '$xoops_user->pass', ";
235	$wu_sql .= "user_email = '$xoops_user->email', ";
236	$wu_sql .= "user_url = '$xoops_user->url', ";
237	$wu_sql .= "user_nicename = '$xoops_user->uname', ";
238	$wu_sql .= "user_registered = '$user_regist_time', ";
239	$wu_sql .= "user_status = 0 ";
240	$wu_sql .= "WHERE (user_login = '$xoops_user->uname' )";
241
242	$xoops_db->query($wu_sql);
243
244	$message .= set_user_role($wp_user_id,$add_user);
245
246	if (!check_user_meta_prefix($wp_user_id)){
247	repair_user_meta_prefix();
248	}
249
250	$is_update = true;
251	}else{
252	$add_user = false;
253	if (is_used_wp_user_id($xoops_user->uid) ) { // WP User ID has already been used.
254	$wu_sql = "INSERT INTO $db_xpress_users ";
255	$wu_sql .= "(user_login , user_pass ,user_email , user_url , user_nicename " ;
256	$wu_sql .= " , user_registered , user_status , display_name) ";
257	$wu_sql .= "VALUES ";
258	$wu_sql .= "('$xoops_user->uname', '$xoops_user->pass', '$xoops_user->email', '$xoops_user->url', '$xoops_user->uname' ";
259	$wu_sql .= " , '$user_regist_time', $user_status, '$user_display_name')";
260	$xoops_db->query($wu_sql);
261	$wp_user_id = mysql_insert_id();
262	} else { // WP User ID has not been used yet.
263	$wu_sql = "INSERT INTO $db_xpress_users ";
264	$wu_sql .= "(ID , user_login , user_pass ,user_email , user_url , user_nicename " ;
265	$wu_sql .= " , user_registered , user_status , display_name) ";
266	$wu_sql .= "VALUES ";
267	$wu_sql .= "('$xoops_user->uid', '$xoops_user->uname', '$xoops_user->pass', '$xoops_user->email', '$xoops_user->url', '$xoops_user->uname' ";
268	$wu_sql .= " , '$user_regist_time', $user_status, '$user_display_name')";
269	$xoops_db->query($wu_sql);
270	$wp_user_id = $xoops_user->uid;
271	}
272	$message .= set_user_role($wp_user_id,$add_user);
273	}
274
275	$user_nickname = empty($xoops_user->name) ? $xoops_user->uname :$xoops_user->name ;
276	$user_rich_editing = 'true';
277	$user_first_name = $xoops_user->uname;
278	$user_last_name = '';
279	$user_description = '';
280	$user_jabber = '';
281
282	update_usermeta( $wp_user_id,'nickname',$user_nickname);
283	update_usermeta( $wp_user_id,'first_name',$user_first_name);
284	update_usermeta( $wp_user_id,'last_name',$user_last_name);
285	update_usermeta( $wp_user_id,'description',$user_description);
286	update_usermeta( $wp_user_id,'jabber',$user_jabber);
287	update_usermeta( $wp_user_id,'aim',$xoops_user->user_aim);
288	update_usermeta( $wp_user_id,'yim',$xoops_user->user_yim);
289	if ($is_update === false ) {
290	update_usermeta( $wp_user_id,'rich_editing',$user_rich_editing);
291	}
292
293	}
294	$message .= "...END";
295	return true;
296	}
297
298	/*
299	* Get User ID of XOOPS from the login name.
300	*/
301	function get_xoops_user_id($login_name){
302	global $xoops_db;
303	$sql = "SELECT uid FROM " . get_xoops_prefix() . "users WHERE uname = '$login_name'";
304	$uid = $xoops_db->get_var($sql);
305	return $uid;
306	}
307
308	/*
309	*The user data of wordpress is written in the xoops user data.
310	*/
311	function user_sync_to_xoops($user_ID){
312	global $xoops_db;
313
314	$user_info = get_userdata($user_ID);
315	$xoops_uid = get_xoops_user_id($user_info->user_login);
316	$db_xoops_users = get_xoops_prefix() . "users";
317	$user_regdate = strtotime($user_info->user_registered);
318	$aim = get_usermeta($user_ID,'aim');
319	$yim = get_usermeta($user_ID,'yim');
320
321	if ($xoops_uid){
322	$wu_sql = "UPDATE $db_xoops_users ";
323	$wu_sql .= 'SET ';
324	$wu_sql .= "uname = '$user_info->user_login', ";
325	$wu_sql .= "pass = '$user_info->user_pass', ";
326	$wu_sql .= "email = '$user_info->user_email', ";
327	$wu_sql .= "url = '$user_info->user_url', ";
328	$wu_sql .= "name = '$user_info->display_name', ";
329	$wu_sql .= "user_aim = '$aim', ";
330	$wu_sql .= "user_yim = '$yim', ";
331	$wu_sql .= "user_regdate = $user_regdate ";
332	$wu_sql .= "WHERE (uid = $xoops_uid )";
333	$xoops_db->query($wu_sql);
334	}else{
335	$wu_sql = "INSERT INTO $db_xoops_users ";
336	$wu_sql .= "(uname , pass ,email , url , name , user_aim , user_yim , user_regdate) " ;
337	$wu_sql .= "VALUES ";
338	$wu_sql .= "('$user_info->user_login', '$user_info->user_pass', '$user_info->user_email', '$user_info->user_url', '$user_info->display_name' ";
339	$wu_sql .= " , '$aim' , '$yim' , $user_regdate )";
340	$xoops_db->query($wu_sql);
341	// get xoops users default groupe ID
342	$db_xoops_group = get_xoops_prefix() . 'groups';
343	$default_xoops_group_id = $xoops_db->get_var("SELECT groupid FROM $db_xoops_group WHERE group_type = 'User'");
344	// get insert users ID
345	$db_xoops_group = get_xoops_prefix() . 'users';
346	$user_id = $xoops_db->get_var("SELECT uid FROM $db_xoops_group WHERE uname = '$user_info->user_login'");
347	// insert groups_users_link
348	$db_xoops_group_users_link = get_xoops_prefix() . 'groups_users_link';
349	$default_xoops_group_id = $xoops_db->get_var("INSERT INTO $db_xoops_group_users_link (groupid , uid ) VALUES ($default_xoops_group_id , $user_id)");
350	}
351	}
352
353
354	/*
355	* When I changed the pre-fix of the database in XOOPS Protector Module, user authority data of WordPress read it and cannot do it.
356	* This is because a meta_key pre-fix of the usermeta table of WordPress is not changed.
357	* and user_roles option_name pre-fix of the option table of WordPress is not changed.
358	*/
359	function check_user_meta_prefix($uid){
360	global $xoops_db;
361	$db_xpress_usermeta = get_wp_prefix() . 'usermeta';
362	$user_meta_prefix = get_wp_prefix();
363
364	$sql = "SELECT * FROM $db_xpress_usermeta WHERE user_id = $uid AND meta_key = '" . $user_meta_prefix ."user_level'" ;
365
366	$user_level = $xoops_db->get_results($sql);
367	if (empty($user_level)) return false ;
368
369	$sql = "SELECT * FROM $db_xpress_usermeta WHERE user_id = $uid AND meta_key = '" . $user_meta_prefix ."capabilities'" ;
370	$capabilities = $xoops_db->get_results($sql);
371	if (empty($capabilities)) return false ;
372
373	return true;
374	}
375
376	function repair_user_meta_prefix(){
377	global $xoops_db;
378	// repair usermeta db
379	$db_xpress_usermeta = get_wp_prefix() . 'usermeta';
380	$wp_prefix_only = get_wp_prefix_only();
381	$user_meta_prefix = get_wp_prefix();
382	$sql = "SELECT * FROM $db_xpress_usermeta WHERE meta_key LIKE '%_" . $wp_prefix_only . "%'" ;
383	$user_metas = $xoops_db->get_results($sql);
384	foreach($user_metas as $user_meta){
385	if (strpos($user_meta->meta_key,$user_meta_prefix) === false) {
386	$new_meta_key = '';
387	if (strpos($user_meta->meta_key,$wp_prefix_only.'user_level'))
388	$new_meta_key = $user_meta_prefix . 'user_level';
389	if (strpos($user_meta->meta_key,$wp_prefix_only.'capabilities'))
390	$new_meta_key = $user_meta_prefix . 'capabilities';
391	if (strpos($user_meta->meta_key,$wp_prefix_only.'autosave_draft_ids'))
392	$new_meta_key = $user_meta_prefix . 'autosave_draft_ids';
393	if (strpos($user_meta->meta_key,$wp_prefix_only.'usersettings')){
394	if (strpos($user_meta->meta_key,$wp_prefix_only.'usersettingstime'))
395	$new_meta_key = $user_meta_prefix . 'usersettingstime';
396	else
397	$new_meta_key = $user_meta_prefix . 'usersettings';
398	}
399	if (!empty($new_meta_key)){
400	$repair_sql = "UPDATE $db_xpress_usermeta ";
401	$repair_sql .= 'SET ';
402	$repair_sql .= "meta_key = '$new_meta_key' ";
403	$repair_sql .= "WHERE (umeta_id = $user_meta->umeta_id )";
404	$xoops_db->query($repair_sql);
405	}
406	}
407	}
408
409	// repair option db user_roles
410	include_once (ABSPATH . '/include/general_functions.php');
411
412	$prefix = get_wp_prefix();
413	$option_tables = get_table_list($prefix,'options');
414	foreach( $option_tables as $option_table){
415	$mid_prefix = get_multi_mid_prefix($prefix,'options' , $option_table);
416
417	$new_option_name = $prefix .$mid_prefix . 'user_roles';
418	$sql = "SELECT option_id , option_name FROM $option_table WHERE option_name LIKE '%_user_roles'" ;
419	$option= $xoops_db->get_row($sql);
420	if ($option->option_name != $new_option_name){
421	$repair_sql = "UPDATE $db_wp_option ";
422	$repair_sql .= 'SET ';
423	$repair_sql .= "option_name = '$new_option_name' ";
424	$repair_sql .= "WHERE (option_id = $option->option_id )";
425	$xoops_db->query($repair_sql);
426	}
427	}
428	}
429	?>

Note: See TracBrowser for help on using the repository browser.

Download in other formats: