SMF Support > phpBB

The PHPBB => SMF convertor

<< < (2/5) > >>

Kerux:
* Kerux kicks computer *
Normally I am pretty level headed with stuff, but this is getting to be a little nerving. I am doing a fresh install of 1 beta 4.1 (some reason beta 5 wont do a straight install due to other problems with my host's settings) then going to upgrade, then think about trying to convert....

Oldiesmann:
One thing I found when upgrading someone's phpBB: phpBB allows certain characters in usernames that SMF doesn't, such as spaces, commas and apostrophes, so make sure you run these queries after you update if you have any members with these "forbidden" characters in their names:


--- Code: ---#Replace all spaces with underscores
UPDATE smf_members SET memberName=replace(memberName,' ','_'), realName=replace(realName,' ','_');

#Strip out commas
UPDATE smf_members SET memberName=replace(memberName,',',''), realName=replace(realName,',','');

#Strip out apostrophes
UPDATE smf_members SET memberName=replace(memberName,'\'',''), realName=replace(realName,'\'','');
--- End code ---

Apostrophes cause all kinds of problems, and so do spaces. Commas don't cause as many problem, but keep you from being able to set that person as a moderator (since you can seperate the names of moderators with commas), and might cause other problems.

Grudge:
Hey,

Believe it or not I was working on adding this to the converter for the last 30 minutes (yes - it did take me that long!). Anyway - I added this line to the converter before the dat is changed:

--- Code: ---$row['memberName'] = preg_replace('/[^\s0-9A-Za-z#,-\.:=?@^_äöéèöüçåãâáàßêìíîïðñòóôõøùúûýÿ]/is', '-', $row['memberName']);

--- End code ---

and that seems to work - replacing everything illegal with a hypen I hope :|

Oldiesmann:
I think replacing spaces with _ and stripping the rest is more fun :P

Kerux:

--- Quote from: Grudge on May 03, 2004, 10:22:01 AM ---Hey,

Believe it or not I was working on adding this to the converter for the last 30 minutes (yes - it did take me that long!). Anyway - I added this line to the converter before the dat is changed:

--- Code: ---$row['memberName'] = preg_replace('/[^\s0-9A-Za-z#,-\.:=?@^_äöéèöüçåãâáàßêìíîïðñòóôõøùúûýÿ]/is', '-', $row['memberName']);

--- End code ---

and that seems to work - replacing everything illegal with a hypen I hope :|

--- End quote ---


And this makes it better yes?

Navigation

[0] Message Index

[#] Next page

[*] Previous page