34 Responses to “Level10 Blog Matrix WordPress Plugin”

1. onenationunderdog Says:
   October 8th, 2005 at 1:09 am

   Wonderful contribution to the WordPress community - thank you so much!

   Could you explain the technique you employ to switch headers per category (i.e. different graphic and wrap for local local).

   With this kind of filtering, do you still employ conditionals and/or category templates? If so, when?

   Thanks again:>)

2. Tom Says:
   October 9th, 2005 at 7:27 pm

   For the switching of header graphics we use the following code in the header.php file:
   
$rootCats = array (
"default" => "insite",
"local" => "local",
"search-happens" => "search-happens"
);

   if(isset($rootCats[$_GET[category_name]])) {
$_SESSION[CatRootName] = $rootCats[$_GET[category_name]];
} else if(!isset($_SESSION[CatRootName])) {
$_SESSION[CatRootName] = $rootCats['default'];
}


   Then just use $_SESSION[CatRootName] to specify the src on the header image.

3. ioreyes Says:
   December 23rd, 2005 at 10:34 pm

   Hi, Looks like a great plugin, but it doesn’t render properly in safari 2.0.1. The sidebar ends up on the left side of the page and covers half your content.

4. tomas Says:
   January 10th, 2006 at 3:55 pm

   hello tom, first of all thanks for the GREAT plugin. I’m currently having an issue with the manual filters. basically, what i want to do is that on a single post page, i can also see the “personal categories” from that author. since the auto filters doesn’t recognize that page as the main author page, it just makes a list with all the categories, so i’m trying with the following:

   ID,’author’); ?>

   but no luck. it just puts all categories in there too. is this the correct way to use the manual filters? thanks again!

5. tomas Says:
   January 10th, 2006 at 3:55 pm

   sorry, it seems the code isn’t being displayed by WP

   ID,'author'); ?>

6. jim Says:
   January 28th, 2006 at 5:02 pm

   Hi. I am running into an issue with the plugin. From a clean install of the latest wordpress I am seeing this error under “All authors” on the sidebar.

   Any ideas? It’s a great plugin.

   WordPress database error: [Unknown column ‘user_nickname’ in ‘field list’]
   SELECT wp_users.ID, user_nickname, user_firstname, user_lastname, user_nicename FROM wp_users WHERE user_login ‘admin’ ORDER BY user_nickname

   Warning: Invalid argument supplied for foreach() in /home/.karamazov/deathnewt/deathnewt.net/calendar/wp-content/plugins/level10_blog_matrix.php on line 511

7. markbadger Says:
   January 31st, 2006 at 1:01 am

   Great plug-in. I have a question about level10bm_get_calendar() on an author or category page. It creates the current month correctly, but when I select previous month posts, it moves to a monthly archive, forgetting the author or category that was selected. Is there a method to “remember” the category or author as we go to the archive page? Thanks.

   Mark

8. Aylwin Says:
   January 31st, 2006 at 1:52 am

   I’m fairly new to Wordpress. I’ve always felt that the various CMS packages were better than the ‘blog format’ for multi-user, multi-author sites. For me, this plugin is one of the key factors which make the switch to Wordpress worthwhile. So, thanks a lot!

   Anyway, with WP 2.0.1 around the corner, I’m just about ready to upgrade my site. Are you planning to release a new version of this plugin compatible with WP2.0+? I was thinking of trying to make the necessary changes myself but thought I should ask about your plans first.

9. jj Says:
   February 2nd, 2006 at 9:39 am

   Will you be updating this plugin for Wordpress 2.0?

10. fandreta Says:
    May 8th, 2006 at 11:38 pm

    Please tell us if you are gonna update this plugin for Wordpress 2.0.2!
    Or how could do it!
    Great Plugin!
    Thanks!

11. Sarit Says:
    May 9th, 2006 at 2:05 am

    hi
    This is a wonderful plugin and it’s exactly what I needed.
    I wanted you (and everyone else) to know that so far it’s working in Wordpress 2.

    I was wondering though, if there’s a way to show date and time next to each recent post, for example?

    Thanks!

12. Links Webkatalog Says:
    July 2nd, 2006 at 8:05 am

    downloaded and installed but must 1-2 days test

13. joes Says:
    November 10th, 2006 at 6:30 am

    Hi,

    As above would love to know if there is any fix for the latest WP install or a workaround to the error:

    WordPress database error: [Unknown column ‘user_nickname’ in ‘field list’]
    SELECT wp_users.ID, user_nickname, user_firstname, user_lastname, user_nicename FROM wp_users WHERE user_login ‘admin’ ORDER BY user_nickname

    Thanks for your help.

    Joe

14. Vasco Says:
    April 17th, 2007 at 10:28 am

    I recently found the same problem (Unknown column ‘user_nickname’) and I spent the good part of the day fixing this. This might be late but better late than never

    Due to the changed layout of the DB I decided to not modify the logic in the code (as I’m not that good with php) and just work on the SQL. Boy that was some monstrous SQL query at the end… btw I couldn’t get my-hacks.php to work, as I don’t know how to get to the variable containing the category (if somebody helps, surely). The patch is kinda big, but let’s try if it is accepted as a single post. Here it goes:

    — level10_blog_matrix.php 2005-10-03 15:52:00.000000000 +0200
    +++ /usr/share/wordpress/wp-content/plugins/level10_blog_matrix.php 2007-04-16 21:59:07.000000000 +0200
    @@ -74,7 +74,7 @@
    //echo “Focus on “.$_SESSION[sl10bmFocus].”";
    if($author) {
    $_SESSION[sl10bmAuthor] = $author;
    - $sql = “SELECT user_nickname,user_nicename FROM $wpdb->users WHERE ID=”.$author;
    + $sql = “SELECT $wpdb->usermeta.meta_value AS user_nickname,$wpdb->users.user_nicename FROM $wpdb->users, $wpdb->usermeta WHERE $wpdb->users.ID=$author AND $wpdb->usermeta.user_id=$author and $wpdb->usermeta.meta_key=’nickname’”;
    $results = $wpdb->get_results($sql);
    $_SESSION[sl10bmAuthorName] = $results[0]->user_nickname;
    $_SESSION[sl10bmAuthorSlug] = $results[0]->user_nicename;
    @@ -133,7 +133,7 @@
    list($l10bmAuthor,$l10bmCategory,$l10bmFocus,$l10bmAuthorName,$l10bmAuthorSlug,$l10bmCategoryName,$l10bmCategorySlug) = level10bm_get_focus($l10bmAuthor,$l10bmCategory,$l10bmFocus);

    $categoryName = ($_SESSION[sl10bmCategoryName]) ? $_SESSION[sl10bmCategoryName] : single_cat_title(”,false);
    - $authorName = ($_SESSION[sl10bmAuthorName]) ? $_SESSION[sl10bmAuthorName] : the_author(’nickname’,false);
    + $authorName = ($_SESSION[sl10bmAuthorName]) ? $_SESSION[sl10bmAuthorName] : $l10bmAuthorSlug;
    $a = $authorName;
    if(substr($a, -1, 1) != ’s’) {
    $a .= “’s”;
    @@ -146,7 +146,7 @@
    switch ($element) {
    case ‘categories’:
    if($l10bmAuthor && ($l10bmFocus==’author’)) {
    - return “$authorNamePossessive Catagories”;
    + return “$authorNamePossessive Categories”;
    } else {
    return “Categories”;
    }
    @@ -381,8 +381,8 @@
    if($l10bmAuthor && ($_SESSION[sl10bmFocus]==’author’) && ($l10bm_data[permalinkCategory] && $l10bm_data[permalinkAuthor])) {
    $url2 = $l10bm_data[ac_permalink_structure];
    $url2 = str_replace(”%category%”,$category->category_nicename,$url2);
    - $url2 = get_bloginfo(’url’).str_replace(”%author%”,the_author(’nickname’,false),$url2);
    - $link .= ‘cat_name) . ‘ by ‘.the_author(’nickname’,false).’”>’.intval($category_posts_byAuthor[”$category->cat_ID”]).’/’;
    + $url2 = get_bloginfo(’url’).str_replace(”%author%”,$l10bmAuthorSlug,$url2);
    + $link .= ‘cat_name) . ‘ by ‘.$l10bmAuthorSlug.’”>’.intval($category_posts_byAuthor[”$category->cat_ID”]).’/’;
    }
    $link .= ‘cat_name).’”>’. intval($category_posts[”$category->cat_ID”]).’)’;
    }
    @@ -441,10 +441,10 @@
    list($l10bmAuthor,$l10bmCategory,$l10bmFocus,$l10bmAuthorName,$l10bmAuthorSlug,$l10bmCategoryName,$l10bmCategorySlug) = level10bm_get_focus($l10bmAuthor,$l10bmCategory,$l10bmFocus);

    if($l10bmCategory && ($_SESSION[sl10bmFocus]==’category’)) {
    - $sql = “SELECT $wpdb->users.ID,count($wpdb->posts.ID) as post_count, user_nickname, user_firstname, user_lastname, user_nicename
    - FROM $wpdb->users, $wpdb->posts, $wpdb->post2cat
    - WHERE $wpdb->posts.post_author=$wpdb->users.ID AND $wpdb->posts.ID=$wpdb->post2cat.post_id AND $wpdb->post2cat.category_id=$l10bmCategory
    - GROUP BY $wpdb->users.ID
    + $sql = “SELECT t.ID,count($wpdb->posts.ID) as post_count, t1.meta_value AS user_nickname, t2.meta_value AS user_firstname, t3.meta_value AS user_lastname, user_nicename
    + FROM $wpdb->users AS t, $wpdb->posts, $wpdb->post2cat, $wpdb->usermeta AS t1, $wpdb->usermeta AS t2, $wpdb->usermeta AS t3
    + WHERE $wpdb->posts.post_author=t.ID AND $wpdb->posts.ID=$wpdb->post2cat.post_id AND $wpdb->post2cat.category_id=$l10bmCategory and t1.user_id = t.id and t2.user_id = t.id and t3.user_id = t.id and t1.meta_key = ‘nickname’ and t2.meta_key = ‘first_name’ and t3.meta_key = ‘last_name’
    + GROUP BY t.ID
    ORDER BY “.((L10M_AUTHOR_SORT_BY_POSTS)?”post_count DESC “:”user_nickname “).
    ((L10M_MAX_AUTHORS>0) ? “LIMIT “.L10M_MAX_AUTHORS:”");
    $authors = $wpdb->get_results($sql);
    @@ -465,10 +465,10 @@
    $authorPostCount[$cat->cat_ID] = $cat->post_count;
    }

    - $sql = “SELECT $wpdb->users.ID,count($wpdb->posts.ID) as post_count,$wpdb->post2cat.category_id, user_nickname, user_firstname, user_lastname, user_nicename
    - FROM $wpdb->users, $wpdb->posts, $wpdb->post2cat
    - WHERE $wpdb->posts.post_author=$wpdb->users.ID AND $wpdb->posts.ID=$wpdb->post2cat.post_id AND $wpdb->post2cat.category_id in ($qCats)
    - GROUP BY $wpdb->users.ID, $wpdb->post2cat.category_id
    + $sql = “SELECT t.ID,count($wpdb->posts.ID) as post_count,$wpdb->post2cat.category_id, t1.meta_value AS user_nickname, t2.meta_value AS user_firstname, t3.meta_value AS user_lastname, user_nicename
    + FROM $wpdb->users AS t, $wpdb->posts, $wpdb->post2cat, $wpdb->usermeta AS t1, $wpdb->usermeta AS t2, $wpdb->usermeta AS t3
    + WHERE $wpdb->posts.post_author=t.ID AND $wpdb->posts.ID=$wpdb->post2cat.post_id AND $wpdb->post2cat.category_id in ($qCats) and t1.user_id = t.id and t2.user_id = t.id and t3.user_id = t.id and t1.meta_key = ‘nickname’ and t2.meta_key = ‘first_name’ and t3.meta_key = ‘last_name’
    + GROUP BY t.ID, $wpdb->post2cat.category_id
    ORDER BY post_count DESC
    LIMIT 100″;

    @@ -502,7 +502,7 @@

    } else {
    - $sql = “SELECT $wpdb->users.ID, user_nickname, user_firstname, user_lastname, user_nicename FROM $wpdb->users “. (($exclude_admin) ? “WHERE user_login ‘admin’ ” : ”) . ” ORDER BY user_nickname”;
    + $sql = “SELECT ID, t1.meta_value AS user_nickname, t2.meta_value AS user_firstname, t3.meta_value AS user_lastname, user_nicename FROM $wpdb->users, $wpdb->usermeta as t1, $wpdb->usermeta as t2, $wpdb->usermeta as t3 WHERE “. (($exclude_admin) ? “user_login ‘admin’ and ” : ”) . ” t1.user_id = id and t2.user_id = id and t3.user_id = id and t1.meta_key = ‘nickname’ and t2.meta_key = ‘first_name’ and t3.meta_key = ‘last_name’ ORDER BY user_nickname”;
    $authors = $wpdb->get_results($sql);
    }
    //echo “$l10bmAuthor-$sql”;
    @@ -1552,4 +1552,4 @@
    return $output;
    }

    -?>
    \ No newline at end of file
    +?>

15. Vasco Says:
    April 17th, 2007 at 11:01 am

    Stupid me. Comments strip all formatting, including indentation, so the patch is ruined. Ah well, there’s a uuencoded version. Definitely looks like a lot of spam, but let’s try again:

    begin 644 patch.diff
    M+2TM(&QE=F5L,3!?8FQO9U]M871R:7@N”YP:’`@,C`P
    M-RTP-”TQ-B`R,3HU.3HP-RXP,#`P,#`P,#`@*S`R,#`*0$`@+3PH@)%]315-324].6W-L,3!B
    M;4%U=&AO*`G2XD875T:&]R.PHK(”1S4YA;64L)&PQ,&)M0V%T
    M96=O4YA;65=*2`_(”1?4T534TE/
    M3EMS;#$P8FU#871E9V]R>4YA;65=(#H@5T@)B8@)&PQ,&)M7V1A=&%;27B@)TL)&-A=&5G;W)Y+3YC871E9V]R>5]N:6-E;F%M92PD=7)L
    M,BD[”BT@)’5R;#(@/2!G971?8FQO9VEN9F\HXH”9=7)LXH”9*2YS=’)?*`G2QT:&5?875T:&]R*.*`F6YI8VMN86UEXH”9
    M+&9A;’-E*2PD=7)L,BD[”BT@)&QI;FL@+CT@XH”88V%T7VYA;64I(”X@XH”8
    M(&)Y(.*`F”YT:&5?875T:&]R*.*`F6YI8VMN86UEXH”9+&9A;’-E*2[B@)GB
    M@)T^XH”9+FEN=’9A;”@D8V%T96=O*`G3[B@)DN
    M:6YT=F%L*”1C871E9V]R>5]P;W-T4%U=&AO5]P;W-T5-L=6>*`F2DI(’L*+2`D2`](.*`F&YI
    M8VMN86UEXH”9(&%N9″!T,BYM971A7VME>2`](.*`F&9I5]I
    M9`HK(”1S2`](.*`
    MF&YI8VMN86UEXH”9(&%N9″!T,BYM971A7VME>2`](.*`F&9IPHM(”1S&-L=61E7V%D;6EN*2`_(.*`G’5S97)?
    M;&]G:6X@XH”8861M:6[B@)D@86YD(.*`G2`Z(.*`G2D@+B#B@)T@=#$N=7-E
    M*`F2!A;F0@=#(N
    M;65T85]K97D@/2#B@)AF:7)S=%]N86UEXH”9(&%N9″!T,RYM971A7VME>2`]
    M(.*`F&QA*`F2!/4D1%4B!”62!U

16. Vasco Says:
    April 17th, 2007 at 11:06 am

    Whatever. Someone delete the previous posts and if anyone is interested and there’s a way to upload the patch, let me know.

17. lola Says:
    May 1st, 2007 at 6:58 am

    Excellent clause, thanks for work.

18. Ritland Says:
    May 22nd, 2007 at 10:07 am

    Vasco, I am interested in the fix. If you can, please email me the command at ritland@gmail.com. Also, how do I run this query? Is it a single commend or a series of commands?

    Thanks.

19. Mike Says:
    August 12th, 2007 at 5:55 am

    It’s very beautifully.

20. Makis T. Says:
    August 13th, 2007 at 11:26 pm

    I recently came accross the same problem described previously with my Wordpress v2 installation for my personal web portfolio at Make Sites

    WordPress database error: [Unknown column ‘user_nickname’ in ‘field list’]
    SELECT wp_users.ID, user_nickname, user_firstname, user_lastname, user_nicename FROM …

    As Wordpress v2.X has a different database structure this is to be expected. Specifically there are neither “user_nickname”, “user_firstname” nor “user_lastname” in the user table.

    I wanted this up and running as soon as possible, so I pathed it up quickly without necesserily choosing the best solutions.

    But just because there seem to be many people with the same problem I’m recording here what I did.

    So, To fix this…

    Open the “level10_blog_matrix.php” from your plugins folder with your favorite text editor

    1. Search and replace “user_nickname” with “user_login”

    2. Remove all “user_firstname” and “user_lastname” database calls

    3. Go to line 516:

    if ($show_fullname && ($author->user_firstname != ” && $author->user_lastname != ”)) {
    $name = “$author->user_firstname $author->user_lastname”;
    }

    I personally didn’t mind the full names not appearing so I just replaced the above with this:

    if ($show_fullname && $author->user_login) {
    $name = ucfirst ( “$author->user_login” );
    }

    Optionally you can use the same ucfirst() function anywhere we have inserted the user_login to make the first letter capital.

21. Makis T. Says:
    August 13th, 2007 at 11:30 pm

    This is a follow up of my previous post…

    In addition I had problems with my permalinks. Specifically, the category links didn’t have the required “category/” in the path as well as the author links didn’t have the “author/”.

    To fix these problems…

    1. Go to line 335:

    if(($l10bm_data[permalinkCategory]==1) || $l10bm_data[matrixPrimeSubdirectory]) {
    $url = str_replace(”/category/”,”/”,$url);
    }

    Comment out the entire condition:

    //if(($l10bm_data[permalinkCategory]==1) || $l10bm_data[matrixPrimeSubdirectory]) {
    // $url = str_replace(”/category/”,”/”,$url);
    //}

    2. Go to line 526:

    if(($l10bm_data[permalinkAuthor]==1) || $l10bm_data[matrixPrimeSubdirectory]) {
    $url = str_replace(”/author/”,”/”,$url);
    }

    Comment out this entire condition as well:

    //if(($l10bm_data[permalinkAuthor]==1) || $l10bm_data[matrixPrimeSubdirectory]) {
    // $url = str_replace(”/author/”,”/”,$url);
    //}

    Other Bugs:

    - There is a bug with the category listings when you select to see the posts of an author for a specific category. In specific, it returns the display to the default category listing and not the category listing for the author. To fix this, goto line 82:

    if(is_author() && !is_category()) {

    and remove the second condition,

    if(is_author()) {

    - There is a misspelled word: “Catagories” (instad of “Categories” - just search and replace)

    - I had problems with the “Uncategorized” category showing up in the category listings. In my database that category had cat_ID=1 with no other category having a smaller number than that. In the plugin though it has database queries searching for “cat_ID > 0″ so I searhed and replaced them with “cat_ID > 1″, just to bypass that category all together.

    Overall it was kinda easy but had a bit of work to do . I think it’s entitled of a post of its own on my blog

    Hope that helps you.

    ____________________________________
    Make Sites - www.makesites.cc
    The web design portfolio of Makis & Maria

22. Daniel Says:
    September 27th, 2007 at 6:01 am

    I couldn’t understand some parts of this article Blog Matrix WordPress Plugin | LevelTen Blog, but I guess I just need to check some more resources regarding this, because it sounds interesting.

23. David Says:
    October 4th, 2007 at 9:15 am

    This plugin is great. He is help promotion my blog.

24. Michael Says:
    October 17th, 2007 at 6:34 am

    Yes I same to This plugin is great .I love Wordpress.

25. Webkatalog Says:
    October 20th, 2007 at 3:30 pm

    if u would understand this code i will be glad, but i must learn more ;/

26. Armin Says:
    November 2nd, 2007 at 1:28 pm

    This plugin is great, i use his and work well.

27. Manele Says:
    January 5th, 2008 at 3:35 am

    the plugin is very useful! thx a lot!!!

    Manele

28. manele noi Says:
    March 7th, 2008 at 7:34 am

    Excellent clause, thanks for work.

29. mehedi Says:
    March 29th, 2008 at 6:39 am

    Hey, I run a multi author blog. I need the plugin. But the pluging is not working with wp 2.3 as it use terms & taxonomy. Can anyone give me a fixed version of Blog Matrix. or any solution? Please I need it.

30. T1 Says:
    March 29th, 2008 at 8:33 am

    Is the bug fixed yet?

31. Jorge Martinez Says:
    April 8th, 2008 at 11:55 am

    Would you be willing to help me install this? I can pay you.
    Thanks.

32. MoreNiche Affiliate Program Says:
    May 3rd, 2008 at 2:51 am

    MoreNiche affiliate program, the worlds best affiliate network. Start your own home based business and make a success out of niche affiliate marketing and visit our affiliate marketing forum for advice and tips.
    http://www.moreniche.tk

33. radixa Says:
    May 16th, 2008 at 4:52 am

    Nice Info .. thanks !

34. Acomplia Says:
    June 26th, 2008 at 4:24 am

    Acomplia (rimonabant) is an anti-obesity drug. It was approved for marketing in the European Union in June 2006. Rimonabant is not yet approved for use in the United States, where it is known as Zimulti. www.acompliaonline.com

Leave a Reply