1
asche
database related questions - update of bb_topics and bb_posts
  • 2005/5/17 19:45

  • asche

  • Not too shy to talk

  • Posts: 116

  • Since: 2004/4/5 9


I just wanted to relocate (sorry if I dont hit teh exact term, because I user german language) some postings from one forum to another forum (functionality provided by role of forum moderator?) with sql update query.

Now I have a very basic question:
Is it really necessary to hold the forum_id in table bb_topics and bb_posts? This makes updates with sql very akward, because for relocating a posting, I have to update 2 keys. To update forum_id in bb_topics should be enough (if I need to know how many posts I have in a certain forum, I can query from bb_posts with a join over bb-topics to bb_forum)?

Is it possible to "read" the function for "relocation of posts" in "post-options"? Maybe I can get my update sql by reading this function?

Some more questions:
Where can I post database related questions:
- sql syntax for updates, subselects
- Database schene of XOOPS
- Tools for reading database scheme from flatfile
- admin toole better than phpadmin (more like Oracle PL/SQL Developer if there are any)
- Projects for running XOOPS on other online databases like postgresql, maxdb and ...?

Curious to get some database related infos

Best regards asche

Login

Who's Online

185 user(s) are online (88 user(s) are browsing Support Forums)


Members: 0


Guests: 185


more...

Donat-O-Meter

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

Latest GitHub Commits