Padgoi Posted October 30, 2007 Share Posted October 30, 2007 Ok, so I kinda had a problem with my boards. Right now, all of the topics in the sql dbase are in forum_id 369. I need to move them ALL to forum_id 3. I need an sql function to help me so I don't have to manually move 9,000 topics to the correct forum_id. Please any help? The table is ibf_topics and the field I need to change is forum_id for the topics. Link to comment https://forums.phpfreaks.com/topic/75401-sql-quick-question/ Share on other sites More sharing options...
iceblox Posted October 30, 2007 Share Posted October 30, 2007 I had to do the same before. I think its UPDATE you need Link to comment https://forums.phpfreaks.com/topic/75401-sql-quick-question/#findComment-381420 Share on other sites More sharing options...
MadTechie Posted October 30, 2007 Share Posted October 30, 2007 you mean like this UPDATE ibf_topics SET forum_id=3 WHERE forum_id=369 WARNING BACKUP FIRST SQL DUMP Link to comment https://forums.phpfreaks.com/topic/75401-sql-quick-question/#findComment-381421 Share on other sites More sharing options...
Padgoi Posted October 30, 2007 Author Share Posted October 30, 2007 Yes, but I need the exact function. Link to comment https://forums.phpfreaks.com/topic/75401-sql-quick-question/#findComment-381422 Share on other sites More sharing options...
MadTechie Posted October 30, 2007 Share Posted October 30, 2007 mysql_query Okay.. that table is from IPB.. so you can use the SQL toolbox (i think its called that) to execute that statement.. But i do think you can also do a mass move form the admin control panel as well Link to comment https://forums.phpfreaks.com/topic/75401-sql-quick-question/#findComment-381423 Share on other sites More sharing options...
MadTechie Posted October 30, 2007 Share Posted October 30, 2007 Yep.. admin CP, (admin tab) SQL toolbox then at the bottom Run a Query Manual Query (Advanced Users Only) But you can mass move from the forum as well, (tick the top most box) then action move Link to comment https://forums.phpfreaks.com/topic/75401-sql-quick-question/#findComment-381425 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.