unflyingobject

DELETE FROM punmessages; 

INSERT INTO punmessages (subject,sender_id, sender, owner, posted, message, sender_ip,smileys,showed)  

(SELECT privmsgs_subject, privmsgs_from_userid,  

(SELECT username FROM phpbb_users WHERE phpbb_users.user_id = privmsgs_from_userid), 

privmsgs_to_userid, privmsgs_date, privmsgs_text, INET_NTOA(CONV(privmsgs_ip,16,10)), privmsgs_enable_smilies, 

(SELECT user_new_privmsg FROM phpbb_users WHERE phpbb_users.user_id = privmsgs_from_userid) 

FROM phpbb_privmsgs, phpbb_privmsgs_text  

WHERE privmsgs_id = privmsgs_text_id);