MyBB Community Forums

Full Version: Coding query (mybb_threads)
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I am a fairly good SQL coder, did it in Oracle for a number of years for a living.
I am looking into writing code to rebuild the mybb_threads file from the mybb_posts file.
I thought I would ask to see if anyone thought it could be done.  The issue I see is making 
sure the the firstpost field is accurate.  Any words of wisdom or advice?   Anything else 
to tell me to watch out for...I know MYSQL,  but have less knowledge with MYBB.   

BTW, I have a personal reason to want to rebuild it.  A large part of it is lost, and no backup, and I 
do need to rebuild it if it is possible.  I did do a search to see if anyone ever did it, and did not
find anything.  Thanks for your inputs in advance.
if you haven't traced out yet,
posts table consists of replyto field. if it is 0 (zero) then the content is related to thread (i.e. first post of the thread)