Changing the Permalink structure, should I..?

Hmm, I thought people usually jump, hop and skip on topics like this lol!! Oh well lol.. Much thanks goes to Sean again for doing this little PHP script, and Mod_rewrite rule up for me lol. =)

<?php
mysql_connect("dbHost", "dbUser", "dbPass") or die("connect failed");

mysql_select_db("dbDatabase") or die("can't get to the database");

$result = mysql_query("SELECT ID FROM wp_users WHERE post_name = '".addslashes($_GET['q'])."';")
while($row = mysql_fetch_assoc($result)) {
foreach($row as $var => $val) {
$post = $val;
}
}
mysql_free_result($result);

header("Location: /archive/".$post);
?>

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteRule ^(.+).htm /wp-content/themes/specerp/wp-newuri.php?q=$1 [QSA,L]
</IfModule>

I didn’t try it yet though sigh, but will soon. Jeremy Visser did though, said he got 404’s for the pages, but that’s expected I guess lol. Welp..going to try it on the localhost once.. see what happens.

spencerp

Hahaha.. hells no! =P Well, I’ll just try her out on the localhost first anyways.. so it’s all good. 😉 [Lights up a Marlboro]

spencerp

Didn’t want to intrude as I’m not “whooami or a few others.” Glad you got something sorted out. Keep us posted.

Aww..come on Handy lol, you *are* part of the “few others” lol. =) 😉 You’re always welcome to reply to anything I thread about or whatever. 😉 I shouldn’t have added that little bit I guess sigh. =(

Like I said though, you’re always welcome to reply, you’re one of the “best” people to get answers from, for these types of questions. 😉 Goes for *alot* of other people too. =P

spencerp

I think I’ll change this to “resolved” now..there really isn’t any need to keep it “tagged” as “unresolved”, or whatever.. 😉

Also, if I have problems with the above script and mod_rewrite. I could always just hit Sean or Jeremy up on GoogleTalk, or something.. =P

spencerp

For your .htaccess file, for being on the *root* of the domain name, here below is what I used, in the .htaccess file.

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.+).htm wp-newuri.php?q=$1 [QSA,L]
</IfModule>

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>

# END WordPress

Then for the wp-newuri.php file. Uploaded to the *root* of your domain.

<?php
mysql_connect("localhost", "DATABASE-USERNAME", "DATABASE-PASSWORD") or die("connect failed");

mysql_select_db("DATABASE-NAME") or die("can't get to the database");

$result = mysql_query("SELECT ID FROM wp_posts WHERE post_name = '".addslashes($_GET['q'])."';");
while($row = mysql_fetch_assoc($result)) {
foreach($row as $var => $val) {
$post = $val;
}
}
mysql_free_result($result);

header("HTTP/1.1 301 Moved Permanently");
header("Location: /id/".$post);

?>

As in the above one, this line here:
or die(“connect failed”);’

Spit out a T-STRING error message on redirecting..because the little: ” ‘ ” at the end had to be removed..like this:
or die(“connect failed”);

I hope this might help someone else.. =)

spencerp