<br />INSERT INTO <yourdatabasename>.user ( <br />userid, username, password, altemail, usergroupid, <br />skinid, realname, regdate, lastvisit, cols, birthday, <br />question, answer, country, state, zip, options, replyto, font, timezone) <br />select U_Number, U_LoginName, U_Password, U_FakeEmail,<br /> 3, '<customskinname>', U_Name, U_Registered, U_LastOn, <br />'a:6:{i:0;s:8:"priority";i:1;s:6:"attach";i:2;s:4:"from";i:3;s:7:"subject";i:4;s:8:"datetime";i:5;s:4:"size";}', <br />'0000-00-00', '', '', 'ot', 'ot', '', '21842', concat( U_loginname, '@<yourdomainname.com>' ), <br />'Verdana|10|Regular|Black|None', U_TimeOffset <br />From w3t_Users<br />where u_number = <thenewusernumber><br />