Simple Machines Community Forum

Customizing SMF => Modifications and Packages => Mod Requests => Aiheen aloitti: Vagrancy - joulukuu 10, 2007, 07:11:23 IP

Otsikko: Topic Exporter/Importer/Rebuilder
Kirjoitti: Vagrancy - joulukuu 10, 2007, 07:11:23 IP
This may seem like a very complex and.. specialized request.. But I thought I'd give it a go still. I wasn't sure if it ought to go here or in the mod requests, so I'm sorry if I hit the wrong board.

On to business.

Topic Exporter/Importer:

It's a bit more than "regular" import/export. I want to be able to move topics between databases. The idea is to have one "archive" forum and one active one. I don't think I need to move topics from the archive to the active forum, and even then I don't know if that's possible right off the bat due to auto_increment and all that (though it might be possible if you factor in the next request)?

Anyway. The gist of it: Two forums, that are in essence the same, only difference being the smf_messages table. I want a script (embedded into a function directly in the forum, preferably) to move topic_#xxxx from smf1_messages to smf2_messages.

Additionally, an option to export a topic to a specified file (like mysqldump, but for selected topics only) would be awesome.

Topic Rebuilder:

A script that reads a selected topic and reposts everything in it. Preferably, I would also want configuration to choose wether or not to retain the following: old post dates (posted on xx/xx/xxxx etc), the original poster accounts (wether to post it on the accounts that posted in the original topic or to post everything from a specified account), and maybe other variables I've forgotten about? The idea is to create new IDs for the topics and posts.

This may seem useless... and in a way, I guess it is. I can't really formulate why I need this tool.. I've spent alot of time around computers though, and the geek inside me wants a script that performs this function.

End:

So. Any thoughts? Is any of it even possible? What I'm hoping is that with those two tools, I can, among other things, move topics back and forth between databases that are and are not in use. This is of interest to me for several reasons; security, performance, and ease of management.