Changeset 264 for branches/Ver2.0/xpressme_integration_kit/include/general_functions.php

Timestamp:

Jun 9, 2009, 8:45:31 AM (15 years ago)

Author:

toemon

Message:

fixed #144 UIDのないコメントの投稿者の名前とメールアドレスからXOOPSユーザIDを取得する

File:

• branches/Ver2.0/xpressme_integration_kit/include/general_functions.php (modified) (1 diff)

branches/Ver2.0/xpressme_integration_kit/include/general_functions.php

@@ -91 +91 @@
         }
 }
+
+// XOOPS user ID is get from the name and the mail address of the contributor of the comment that is not user_id. 
+if (!function_exists('wp_comment_author_to_xoops_uid')){
+        function wp_comment_author_to_xoops_uid($name = '',$email = ''){
+                global $xoopsDB,$xoops_db;
+                if (empty($name) || empty($email)) return 0;
+                
+                if (empty($xoops_db)) { // not load XPressME
+                        $xoops_user_tbl = $xoopsDB->prefix('users');
+                        $wp_user_tbl = $xoopsDB->prefix($wp_prefix . "_users");
+
+                        $xoops_uid = 0;
+                        $xoops_user_SQL ="SELECT uid FROM $xoops_user_tbl WHERE uname = '$name' AND email = '$email'";
+                        $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;
+                } else { // load XPressME or not Load XOOPS
+                        $xoops_user_tbl = get_xoops_prefix() . 'users';
+                        $xoops_uid = $xoops_db->get_var("SELECT uid FROM $xoops_user_tbl WHERE uname = '$name' AND email = '$email'");
+                        if (empty($xoops_uid)) return 0;
+                        return $xoops_uid;
+                }                       
+        }
+}
+
 ?>