Changeset 155 for trunk/wp-content/plugins/xpressme/include/xpress_common_functions.php

Timestamp:

Apr 4, 2009, 6:47:22 PM (15 years ago)

Author:

toemon

Message:

#14 マルチユーザーモードの実装

File:

• trunk/wp-content/plugins/xpressme/include/xpress_common_functions.php (modified) (1 diff)

trunk/wp-content/plugins/xpressme/include/xpress_common_functions.php

@@ -235 +235 @@
 }
 
+function xpress_set_author_cookie()
+{
+        $author_cookie = get_xpress_dir_name() . "_select_author" ;
+        if(xpress_is_multi_user()){
+                if (empty($_GET)){
+        //              $GLOBALS["wp_xoops_author"] = null;
+                        setcookie($author_cookie, 0);
+                        $_COOKIE[$author_cookie] = 0;
+                        
+                } else {
+                        $auth = intval( @$_GET["author"] );
+                        if ($auth > 0){
+                                setcookie($author_cookie, $auth);
+                                $_COOKIE[$author_cookie] = $auth;
+                        }
+                }
+        }else{
+        //      $GLOBALS["wp_xoops_author"] = null;
+                setcookie($author_cookie, 0);
+                $_COOKIE[$author_cookie] = 0;
+        }
+}
+
+function xpress_query_filter(&$query)
+{
+        $author_cookie = get_xpress_dir_name() . "_select_author" ;
+        
+        if (strpos($query,'SELECT') !==0)  return $query;
+
+        $select_pattern = "SELECT(.*)post_author(.*)FROM";
+        if (preg_match ( "/".$select_pattern."/i", $query, $select_match ))
+                return $query;
+
+        $query = preg_replace('/\s\s+/', ' ', $query);
+        if (!empty($_COOKIE[$author_cookie])){
+                $pattern = "WHERE(.*)post_type(.*)=(.*)'post'";
+                if ( preg_match ( "/".$pattern."/i", $query, $match ) ){
+                        $where_str = "$match[0]";
+                        $where_arry = split(' ',$where_str);
+                        $post_prefix = '';
+                        foreach ($where_arry as $p){
+                                if ( preg_match ( "/post_type/", $p, $match3 ) ){
+                                        $post_prefix = preg_replace("/post_type/", "", $p);
+                                        break;
+                                }
+                        }
+                        preg_match ( "/post_type(.*)/", $where_str, $p_match );
+                        $patern = $p_match[0];
+                        $replace = $patern . " AND {$post_prefix}post_author = " . intval($_COOKIE[$author_cookie]) . " ";
+                        $query = preg_replace("/$patern/", $replace, $query);
+                }
+        }
+//      xpress_show_sql_quary($query);
+        return $query;
+}
 ?>