1
mrphilong
smartfaq => smartsection
  • 2007/7/24 8:48

  • mrphilong

  • Quite a regular

  • Posts: 351

  • Since: 2006/7/14


I've got data in smartfaq that I would like to imported into smartsection, what are my choices?
www.UcChau.Net
www.XoopsViet.Org

2
christian
Re: smartfaq => smartsection
  • 2007/7/24 21:05

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


You can use this query in phpMyAdmin for migrate smartfaq_categories into smartsection_categories

insert into xoops_smartsection_categories (categoryidparentidnamedescriptiontotalweightcreated)
select categoryidparentidnamedescriptiontotalweightcreated from xoops_smartfaq_categories;


For answers it's more complex because for one question you can to have many answers, you can try this :

insert into xoops_smartsection_items (categoryidtitlebody,uid,datesubstatusimagecounterweightdohtmldosmiley,doxcode,dobr,cancomment)
SELECT f.categoryid,f.question,a.answera.uidf.datesub,f.status,f.imagef.counter,f.weightf.htmlf.smileyf.xcodesf.linebreakf.cancomment
FROM xoops_smartfaq_faq 
as f left join xoops_smartfaq_answers as a ON f.faqid a.faqid;


to adapt the prefix of the tables to your situation
setting the authorizations manually

Enjoy

3
mrphilong
Re: smartfaq => smartsection
  • 2007/7/25 20:26

  • mrphilong

  • Quite a regular

  • Posts: 351

  • Since: 2006/7/14


Your script saved me hours of work! Thankyou so much.
www.UcChau.Net
www.XoopsViet.Org

Login

Who's Online

158 user(s) are online (111 user(s) are browsing Support Forums)


Members: 0


Guests: 158


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits