function _sitemap_xpress($mydirname) { global $sitemap_configs, $xoopsDB; if (!file_exists(XOOPS_ROOT_PATH . '/modules/' . $mydirname . '/wp-includes/version.php')) { return ''; } include XOOPS_ROOT_PATH . '/modules/' . $mydirname . '/wp-includes/version.php'; if ($wp_db_version < 6124) { // UNDER WP2.3 $block = sitemap_get_categoires_map($xoopsDB->prefix("wp_categories"), "cat_ID", "category_parent", "cat_name", "index.php?cat=", "cat_name"); return $block; } $disp_sub = @$sitemap_configs["show_subcategoris"]; $prefix = preg_replace('/wordpress/', 'wp', $mydirname); $prefix = $xoopsDB->prefix($prefix); require_once XOOPS_ROOT_PATH . '/modules/' . $mydirname . '/include/general_functions.php'; $options_tables = get_table_list($prefix, 'options'); $index = 0; $blogs = array(); foreach ($options_tables as $options_table) { $blog_url = get_blog_option($options_table, 'siteurl'); $blog_sub_url = preg_replace('/.*\\/' . $mydirname . '/', '', $blog_url); $blog_sub_url = preg_replace('/\\//', '', $blog_sub_url); if (!empty($blog_sub_url)) { $blog_sub_url = $blog_sub_url . '/'; } $blog_name = get_blog_option($options_table, 'blogname'); $db_prefix = get_multi_prefix($options_table, 'options'); $data = array('blog_name' => $blog_name, 'blog_sub_url' => $blog_sub_url, 'term_taxonomy' => $db_prefix . 'term_taxonomy', 'terms' => $db_prefix . 'terms'); $blogs[$index] = $data; $index++; } return xpress_get_categoires_map($blogs, $disp_sub); }
function _xpress_data($mydirname,$limit=0, $offset=0) { // get $mydirnumber if( ! preg_match( '/^(\D+)(\d*)$/' , $mydirname , $regs ) ) echo ( "invalid dirname: " . htmlspecialchars( $mydirname ) ) ; global $xoopsDB; $wp_prefix = preg_replace('/wordpress/','wp',$mydirname); require_once (XOOPS_ROOT_PATH . '/modules/'.$mydirname . '/include/general_functions.php'); $prefix = $xoopsDB->prefix($wp_prefix); $options_tables = get_table_list($prefix,'options'); $table_count = count($options_tables); $sql = ''; foreach( $options_tables as $options_table){ $blog_url = get_blog_option($options_table , 'siteurl'); $blog_url = preg_replace('/\/$/', '' ,$blog_url); $blogname = get_blog_option($options_table , 'blogname'); $table_prefix = get_multi_prefix($options_table,'options'); $table_posts = $table_prefix . "posts"; $sub_sql = "SELECT ID, post_author, post_title, post_content, post_type, comment_count, post_date, UNIX_TIMESTAMP(post_date) AS unix_post_date, UNIX_TIMESTAMP(post_modified) AS unix_post_modified, post_status, '$blog_url' AS blog_url, '$table_prefix' AS table_prefix, '$blogname' AS blogname "; $sub_sql .= " FROM ".$table_posts; $sub_sql .= " WHERE (post_status='publish') AND (UNIX_TIMESTAMP(post_date) <= UNIX_TIMESTAMP()) "; if ($table_count > 1){ $sub_sql = '(' . $sub_sql . ')'; if (!empty($sql)) $sql = $sql . ' UNION '; $sql = $sql . $sub_sql; } else { $sql = $sub_sql; } } $result = $xoopsDB->queryF($sql,$limit,$offset); $i = 0; $ret = array(); while($row1 = $xoopsDB->fetchArray($result)) { $id = $row1['ID']; $blog_url = $row1['blog_url']; $blogname = $row1['blogname']; $ret[$i]['id'] = $id; $ret[$i]['link'] = $blog_url . "/index.php?p=".$id; $ret[$i]['title'] = $row1['post_title']; $ret[$i]['time'] = $row1['unix_post_date']; $i++; } return $ret; }