Changeset 863

Timestamp:

02/11/2004 04:51:19 AM (21 years ago)

Author:

rboren

Message:

Add author_name query and author permalinks.

Location:

trunk

Files:

• wp-admin/options-permalink.php (modified) (2 diffs)
• wp-admin/upgrade-functions.php (modified) (1 diff)
• wp-admin/users.php (modified) (2 diffs)
• wp-blog-header.php (modified) (2 diffs)

trunk/wp-admin/options-permalink.php

@@ -178 +178 @@
         $catmatch = $front . 'category/';
         $catmatch = preg_replace('|^/+|', '', $catmatch);
+        $authormatch = $front . 'author/';
+        $authormatch = preg_replace('|^/+|', '', $authormatch);
 
 ?> 
@@ -188 +190 @@
 RewriteRule ^<?php echo $catmatch; ?>(.*)/<?php echo $feedregex ?>$ <?php echo $site_root; ?>wp-feed.php?category_name=$1&feed=$2 [QSA]
 RewriteRule ^<?php echo $catmatch; ?>?(.*) <?php echo $site_root; ?>index.php?category_name=$1 [QSA]
+RewriteRule ^<?php echo $authormatch; ?>(.*)/<?php echo $feedregex ?>$ <?php echo $site_root; ?>wp-feed.php?author_name=$1&feed=$2 [QSA]
+RewriteRule ^<?php echo $authormatch; ?>?(.*) <?php echo $site_root; ?>index.php?author_name=$1 [QSA]
 RewriteRule ^<?php echo $sitefeedmatch; ?> <?php echo $sitefeedquery ?> [QSA]
 RewriteRule ^<?php echo $sitecommentfeedmatch; ?> <?php echo $sitecommentfeedquery ?> [QSA]</textarea>

trunk/wp-admin/upgrade-functions.php

@@ -681 +681 @@
     $wpdb->query("ALTER TABLE `$tableposts` CHANGE `comment_status` `comment_status` ENUM( 'open', 'closed', 'registered_only' ) DEFAULT 'open' NOT NULL");
 
+    maybe_add_column($tableusers, 'user_nicename', "ALTER TABLE `$tableusers` ADD `user_nicename` VARCHAR(50) DEFAULT '' NOT NULL ;");
+
+    // Set user_nicename.
+    $users = $wpdb->get_results("SELECT ID, user_nickname, user_nicename FROM $tableusers");
+    foreach ($users as $user) {
+        if ('' == $user->user_nicename) { 
+            $newname = sanitize_title($user->user_nickname);
+            $wpdb->query("UPDATE $tableusers SET user_nicename = '$newname' WHERE ID = '$user->ID'");
+        }
+    }
+
     // Convert passwords to MD5 and update table appropiately
     $query = 'DESCRIBE '.$tableusers.' user_pass';

trunk/wp-admin/users.php

@@ -67 +67 @@
     $pass1 = addslashes(stripslashes($pass1));
     $user_nickname = addslashes(stripslashes($user_nickname));
+    $user_nicename = sanitize_title($user_nickname);
     $user_firstname = addslashes(stripslashes($user_firstname));
     $user_lastname = addslashes(stripslashes($user_lastname));
@@ -72 +73 @@
 
     $result = $wpdb->query("INSERT INTO $tableusers 
-        (user_login, user_pass, user_nickname, user_email, user_ip, user_domain, user_browser, dateYMDhour, user_level, user_idmode, user_firstname, user_lastname)
+        (user_login, user_pass, user_nickname, user_email, user_ip, user_domain, user_browser, dateYMDhour, user_level, user_idmode, user_firstname, user_lastname, user_nicename)
     VALUES 
-        ('$user_login', MD5('$pass1'), '$user_nickname', '$user_email', '$user_ip', '$user_domain', '$user_browser', '$now', '$new_users_can_blog', 'nickname', '$user_firstname', '$user_lastname')");
+        ('$user_login', MD5('$pass1'), '$user_nickname', '$user_email', '$user_ip', '$user_domain', '$user_browser', '$now', '$new_users_can_blog', 'nickname', '$user_firstname', '$user_lastname', '$user_nicename')");
     
     if ($result == false) {

trunk/wp-blog-header.php

@@ -11 +11 @@
 require($curpath.'/wp-config.php');
 
-$wpvarstoreset = array('m','p','posts','w', 'cat','withcomments','s','search','exact', 'sentence','poststart','postend','preview','debug', 'calendar','page','paged','more','tb', 'pb','author','order','orderby', 'year', 'monthnum', 'day', 'name', 'category_name', 'feed');
+$wpvarstoreset = array('m','p','posts','w', 'cat','withcomments','s','search','exact', 'sentence','poststart','postend','preview','debug', 'calendar','page','paged','more','tb', 'pb','author','order','orderby', 'year', 'monthnum', 'day', 'name', 'category_name', 'feed', 'author_name');
 
     for ($i=0; $i<count($wpvarstoreset); $i += 1) {
@@ -226 +226 @@
 }
 
+// Author stuff for nice URIs
+
+if ('' != $author_name) {
+    if (stristr($author_name,'/')) {
+        $author_name = explode('/',$author_name);
+        if ($author_name[count($author_name)-1]) {
+        $author_name = $author_name[count($author_name)-1];#no trailing slash
+        } else {
+        $author_name = $author_name[count($author_name)-2];#there was a trailling slash
+        }
+    }
+    $author_name = preg_replace('|[^a-z0-9-]|', '', strtolower($author_name));
+    $author = $wpdb->get_var("SELECT ID FROM $tableusers WHERE user_nicename='".$author_name."'");
+    $whichauthor .= ' AND (post_author = '.intval($author).')';
+}
+
 $where .= $search.$whichcat.$whichauthor;