Originally Posted by: jralbert 
Joe: can you explain the background of the profile situation? Can Norm/Jeff/I help in the project?
I can't fix the current profiles without deleting messages... so
I wrote the following as a SQLServer script to generate a firefox - selenium script.
This is phase 1 (done).
I now have to change the users to the correct posting type Member2 and create new passwords and send them out.
This script in SQLserver generates the selenium crawler script for the firefox plugin.
select char(60)+'tr>'+char(60)+'td>'+'type'+char(60)+'/td>'
+char(60)+'td>id=forum_ctl03_UserName'+char(60)+'/td>'
+char(60)+'td>'+name+'_2'+char(60)+'/td>'+char(60)+'/tr>' +
char(60)+'tr>'+char(60)+'td>'+'type'+char(60)+'/td>'
+char(60)+'td>id=forum_ctl03_Email'+char(60)+'/td>'
+char(60)+'td>'+email+char(60)+'/td>'+char(60)+'/tr>' +
char(60)+'tr>'+char(60)+'td>'+'type'+char(60)+'/td>'
+char(60)+'td>id=forum_ctl03_Password'+char(60)+'/td>'
+char(60)+'td>'+pwd+char(60)+'/td>'+char(60)+'/tr>' +
char(60)+'tr>'+char(60)+'td>'+'type'+char(60)+'/td>'
+char(60)+'td>id=forum_ctl03_Password2'+char(60)+'/td>'
+char(60)+'td>'+pwd+char(60)+'/td>'+char(60)+'/tr>' +
char(60)+'tr>'+char(60)+'td>'+'type'+char(60)+'/td>'
+char(60)+'td>id=forum_ctl03_Question'+char(60)+'/td>'
+char(60)+'td>'+'Boat'+char(60)+'/td>'+char(60)+'/tr>' +
char(60)+'tr>'+char(60)+'td>'+'type'+char(60)+'/td>'
+char(60)+'td>id=forum_ctl03_Answer'+char(60)+'/td>'
+char(60)+'td>'+'Marinette'+char(60)+'/td>'+char(60)+'/tr>' +
char(60)+'tr>'+char(60)+'td>'+'clickAndWait'+char(60)+'/td>'
+char(60)+'td>id=forum_ctl03_ForumRegister'+char(60)+'/td>'
+char(60)+'td>'+' '+char(60)+'/td>'+char(60)+'/tr>'
from yaf_user
Unzinced ships sink at slips. yep