Attachments have been deleted vb 4.2.3

[dariyos]

first step:

uncomment /includes/cron/cleanup2.php

// Unused filedata is removed after one hour
//$attachdata =& datamanager_init('Filedata', $vbulletin, ERRTYPE_SILENT, 'attachment');
//$attachdata->set_condition("fd.refcount = 0 AND fd.dateline < " . (TIMENOW - 3600));
//$attachdata->delete(true, false);

2) restore a old DB in a testforum
3) search for all entrys where the attachments was assigned a post with this query:

SELECT * FROM post a, attachment b, filedata c WHERE c.refcount =0 AND a.postid = b.contentid AND b.filedataid = c.filedataid

3) Update the refcount value from 0 to 1.
4) Search for the newest IDs from the tables (testforum):
-post
-attachment
-filedata
-thread

5) Search for the IDs (in acutal DB) bigger (>) than the IDs from testforum in:
-post
-attachment
-filedata
-thread

6) export the "new" entrys (bigger (>) than newest ids from testforum) from these tables.

8) Import the new entrys in testforum.

then you have all the entrys from old database and new database mixed and the right refcount value.

9) export the mixed tables
-post
-attachment
-filedata
-thread
from testforum

10) import it to actual db.
11) upload all deleted files in your filesystem


BACKUP FIRST, IF SOMETHING WENT WRONG!