WordPress.org

1. pieceoplastic
   Member
   Posted 6 years ago #

   i am a creature of habit and i love narchives for its searchable archives. maybe there now is a plugin doing this, i have not found it yet ...

   however under wp 2.0 it now creates an error:

   WordPress database error: [Unknown column 'user_level' in 'where clause']
   SELECT * FROM pbusers WHERE user_level > 0

   obviously because the user_level has dissappered from the db structure.
   can someone help me fix this?
   i believe the lines concerned are these:

   function show_author_select() {
   global $wpdb, $tableusers, $author;
   $users = $wpdb->get_results("SELECT * FROM $tableusers WHERE user_level > 0", ARRAY_A);
   $output .= '<option value="">All Authors</option>'.NL;
   foreach ($users as $user) {
   $output .= '<option value="'.$user['ID'].'"';
   if ($user['ID'] == $author) {
   $output .= 'selected="selected"';
   }
   $output .= '>'.$user['user_nickname'].'</option>'.NL;
   }
   $output = '<select name="author">'.NL.$output.'</select>'.NL;
   echo $output;
   }

2. jimatwork
   Member
   Posted 6 years ago #

   I believe I did get this to work. However, I am not at home and can't look at the script file. I think the user_level field has a different name. If no one gets back to you with the correct answer, please email me at jwurster at comcast dot net.

3. pieceoplastic
   Member
   Posted 6 years ago #

   cool thx, i wait till tomorrow to see, then would email ya

4. Bricolou
   Member
   Posted 6 years ago #

   I'd be interested in the reply to this one too, please. I've seen it working with 2 but not themed.

5. pieceoplastic
   Member
   Posted 6 years ago #

   its working now, please let me know where i should send the fixed code ...

6. jwurster
   Member
   Posted 6 years ago #

   You can get it at http://www.jwurster.us/wordpress/plugins/.

7. DianeV
   Member
   Posted 5 years ago #

   Oh, bless you. I prefer narchives to just about anything else. :))

8. gadlen
   Member
   Posted 5 years ago #

   R0x0r. Thanks very much, jwurster. NArchives is my favorite too. Your mod works peachy on my lee.org

9. DianeV
   Member
   Posted 5 years ago #

   Unfortunately, I never was able to get it to work for 2.0.7.

Topic Closed

This topic has been closed to new replies.