XF 1.2 vBSEO categories with no ID's redirects

[Blackbeard]

I'm trying to convert one of my largest sites, and I never used ID's in the redirects.

Is there a less painful way to do the redirects without having to lose that sweet sweet traffic?

 

[Mike]

If there are no IDs, you basically have to do the redirects manually.

 

[Hornstar]

I'll be in the same boat. Which ones do you need to manually do and how do you do that?

 

[Blackbeard]

I have over 200 forums/subforums...this doesn't sound good at all.

 

[Brent W]

You could write a script to do this. Would require querying the database for the forum id based off forum name.

 

[Hornstar]

I have over 200 forums/subforums...this doesn't sound good at all.

How'd you go?

 

[Blackbeard]

no go so far.

Might hire someone for this headache.

 

[briansol]

Assuming you kept ids intact as part of XF install options, it's pretty easy if you still have the old (vb) database still intact and you have the XF redirector scripts (with the vb names) in place...

and apache...


I used this to get my forums in my vbseo format and basically just build a 'rule string' to copy into excel as text and finagle a little bit into a rule set for htaccess (you may have other conditionals for special characters to include or used different replacements, so alter as necessary.) If you used nested like /forum/subforum/ cat urls, this won't work for those

SELECT
 "Redirect 301 "
, replace(replace(replace(replace(replace(replace(lower(title_clean),"'",""),":",""),"/","")," ","-"),"--","-"),"->","")
,"http://yoursite.com/forumdisplay.php?f="
,forumid
 FROM forum

Then just kinda take that data dump into a text file and fine tune it a bit.