Exemple #1
0
 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);
 }
Exemple #2
0
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;

}