• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Set prefix_id from VB iconid

nrep

Well-known member
#1
Hi folks,

I'm converting an old vBulletin forum that has lots of thread icons which were used in a similar way to XF prefixes.

I've re-created the prefixes in XF, but now I'd like to transfer them over from VB to XF. The VB thread table is "thread" and the XF thread table is "xf_thread". They are in the same DB for now.

For example, in table thread, each entry with iconid = 26 should update table xf_thread with prefix_id = 1, where thread.threadid = xf_thread.thread_id.

Can someone help me with the SQL query for this please? I'm terrible with SQL and can't see where to begin when I read tutorials using UPDATE/SET across 2 tables.
 
Last edited: