Converting success

[airgasm]

Hello, I have been successful in converting a Snitz forum to SMF and everything is fine. Naturally I am relieved with the outcome.

Only one problem remains and unfortunately, I am not a wiz with MySQL scripts so I am posting here for some assistance please. In the smf_members table the conversion program appeared to place nothing in the user name (memberName) and place "user name" or "log on" name into the Real Name (realName) field.

Is there or can someone write me a small script that will copy the name in the realName field into the memberName field or tell me how to achieve this please.

I used to play around with Dbase and Clipper once so I am a little familiar with code. 

Thankyou in advance

[Elmacik]

I think running an SQL query like below may help;

Code Select Expand

UPDATE smf_members SET memberName = realName;

[airgasm]

Thankyou, I had a good look at the sql file and found what was happening. All fixed now.