READ THE INSTRUCTIONS CAREFULLY - Otherwise you won't know how to sort out the database information!

There are ELEVEN (11) files. Here are the basic descriptions:

images.tar.gz: All the images on the site. Anything anyone ever uploaded (including, in some cases, removed/deleted posts). These can be linked to a username (for crediting an author) by going through the files.xml table, then to the file_relationships.xml table, and finally to the users.xml table. I apologize if this is too confusing for some people, and I apologize that your usernames are not contained directly inside this file, but there was really no other way to do it on such short notice without having to process all the files in sequence and re-organize or re-file them, something I don't have time to do.

node_info.xml - The database information containing the info of each node... its title, who uploaded it ("uid" column reference to users.xml), when it was uploaded, etc. The "nid" is important here because it links with other files. This table should only be used for basic information such as title or username. See the node_revisions.xml info below for more information.

node_revisions.xml - The database information containing the actual text of each story or CYOT. You can get some other information by tying the "nid" column here to the "nid" column in the node_info.xml file. Also, some of the stories are only contained within the body column, but some are in both body and teaser, so don't disregard the teaser column entirely. PLEASE NOTE: If you want basic information like the Title or the "uid" column, please use the "nid" along with node_info.xml. But if you want to retrieve the latest data for a certain post (for example, the text of a story), please use the most recent "vid" along with thie file, node_revisions.xml. As a rule of thumb, always use the "vid" and node_revisions.xml whenever possible. Only use node_info.xml if what you are looking for is not contained within the revisions table.

users.xml - The database information containing the usernames. The "uid" column here links into node_info.xml and node_revisions.xml. All of the personal information has been stripped from this file, so it only contains the uid (user id) and the username itself - nothing more. No passwords. No e-mails. No personal information.

story_relationships.xml - The database information containing the relationships of each story (essentially building a "chapter" structure). The "nid" column is the current story, and the "field_story_prev_nid" column is the previous story in a "chapter"-like sequence. With these relationships, you can build a structure similar to what was on TF-Media, where you have "Next" and "Previous" chapter links for each story.

cyot_relationships.xml - The database information containing the relationships for the CYOT stories. Just like the story_relationships.xml file, the "nid" here is the current CYOT node, and the "field_cyot_parent_nid" is the CYOT's parent node. The "delta" column is nothing more than a sort column, you should typically "ORDER BY delta ASC" if at all possible.

cyot_suggested_links.xml - The database information containing the "Suggested Section Links" for CYOT sections. The "vid"/"nid" columns can be linked to the node_revisions.xml/node_info.xml tables (respectively), and the "field_suggested_links_value" column is filled with a single suggested link, as text. Similar to the above "cyot_relationships.xml" file, the "delta" column here should only be used for sorting.

tag_data.xml - The database information containing the tag data. The "name" is the tag name, and the "tid" is the tag ID that you'll need for the file below. Disregard the "Description" column. NOTE: This table also contains the old tags, as well as some other site information related to the tag system. Do NOT use this table directly, instead, link to it from the node_info table or similar!

tag_node.xml - The database information containing the relationship between the tag_data.xml file and the node_info.xml/node_revisions.xml file(s). The "tid" column here can be used with the tag_data.xml file to get the tag name, and the "nid" or "vid" columns can be used to get the node information (or revision information) from the node_info.xml or node_revisions.xml files. In this way, you can link specific stories and CYOT sections with tags.

files.xml - The database information containing the actual file paths. You can safely ignore the "/sites/default/files/" portion of the file paths - the image archive (.tar.gz file) above is the entire contents of the /files/ folder, so the "/sites/default/files/" part can be safely stripped off. The "fid" column is the file ID used in the file_relationships.xml file, and the "uid" is the user who uploaded this file.

file_relationships.xml - The database information containing the relationships between the node_info.xml/node_revisions.xml table(s) and the files.xml table. "nid" and "vid" are node IDs and revision IDs (respectively), and the "fid" is the file ID.

----------------------------

Extra info:

The images.tar.gz file is a GZipped Tar archive. This can be opened with 7zip (free) or WinRAR (not free). It is 2.73 gigabytes, and will take a very long time to download. Please be patient, or use a download manager that supports resume functionality. If someone wants to create a torrent from this file, by all means please do, and I will link to it here (please let me know where you create the torrent file. I prefer TPB and occasionally mininova).

The other ten files are XML exports of a MySQL database. I could not export the database information into .sql files because one of the tables (the table that contained all the story text) was too big and didn't allow the .sql file format, so I decided to use XML instead. These XML files can be easily converted or re-imported into an SQL database if need be, as they contain some table schema information.

I tried to include all the relevant information required for the data on the website. If you feel there was something left out, please send me an e-mail and let me know what you need, and I might see what I can do to release that information. No guarantees, though.

Please note: The files/database tables here are in NO WAY a complete website! TF-Media was hosted on Drupal which comes standard with about 120 tables run on MySQL, and I only give you 10 tables (some weren't even complete tables!). This information can be used to recreate the basic structure of the data on the website, but it most certainly can NOT be used to just recreate TF-Media in its entirety. Also, please don't think that you can install Drupal and just plug this information into it, expecting to get a TF-Media clone. A lot of hard work went into customizing TF-Media, all the way down to its source code, and what's being given here is a very limited subset of all the database information required to run the site.

On that note, it is certainly possible to create an "archive" website of TF-Media using this information, so that people can search and read stories, CYOTs, and images, and I fully hope to see some archive websites pop up on the internet with this data. In fact, if you do create one successfully, let me know about, I'd love to take a look! :)

----------------------------

Download Links:

Note: You will probably have to right-click and hit "Save File As..." for the XML files.