is it possible to join topics?

[Martin]

I had to close a topic due to the server strain on UBB and opened a part 2.

There are a toal of about 5k posts between the 2, and I was wondering if it was possible to join them so they are one again?

[werehere]

I bet it is possible with some manipulation to the database, mind you I would not be touching that, but I am sure many people out there could:)

[John]

If you have access to the MySQL client then do this:



UPDATE post SET threadid=longthreadid WHERE threadid=part2id;
DELETE FROM thread WHERE threadid=part2id;


If you do not, then use this PHP code in the forums dir:



<?php

require("global.php");
$DB_site->query("UPDATE post SET threadid=longthreadid WHERE threadid=part2id");
$DB_site->query("DELETE FROM thread WHERE threadid=part2id");

?>


John

[Martin]

I'll try it like that :)