MyDB Files

MyDB (Beta)
Version 1.0.0.23

---------------------------------------------------------------------------------
Requirements:
---------------------------------------------------------------------------------
• Windows Vista or later.

• MySQL Server 5.1 or later.

• Microsoft .NET Framework 4 or later.

• Run as administrator (or just turn UAC off).

---------------------------------------------------------------------------------
MySQL configuration:
---------------------------------------------------------------------------------

[mysqld]
character-set-server=utf8
ft_min_word_len=3
ft_stopword_file=""

---------------------------------------------------------------------------------
MyDB configuration:
---------------------------------------------------------------------------------
Tools>Management>Configuration

• WatchDirectories - The folders to scan and monitor.

• FileDataSearchDirectory - The folder to search for file data.
This will allow MyDB to search for tags, urls in *.xml files within
this folder whenever the new item is added.
For Cheggit Browser users: set this directory equal to Torrent Details directory.

• Reorganize - For each file in the watch directory will be created the corresponding folder.
Example: 
Watch folder C:\Downloads
File C:\Downloads\example.avi will be moved to C:\Downloads\example\example.avi.

---------------------------------------------------------------------------------
Commandline:
---------------------------------------------------------------------------------
"-config [filename]" - Set the database config file. Eg: -config Default
"-quickscan" - Perform quick scan upon start
"-max" - Start maximized
"-read" - Read-only mode, no datebase or file system actions are performed (not fully working yet)
"-path [path]" - Search for directory or file upon start

---------------------------------------------------------------------------------
XML Data file:
---------------------------------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?>
<FileData
  Tags="tag1 tag2 tag3"
  URL="http://example.com" 
  <FileList>
    <File
      Length="729759744"
      Name="file.avi" />
  </FileList>
</FileData>

---------------------------------------------------------------------------------
Categories:
---------------------------------------------------------------------------------
There are 6 file categories. Each category is based of the list of file extensions.

Category options:

• UseShell - Open with the associated program
• Data - Allow to search for file data
• Move - Allow to reorganize file
• AV - Reserved
• Thumb - Allow thumbnails generation
• Popup - Allow popup messages
• Screen - Allow screenshots generation

---------------------------------------------------------------------------------
Custom Overview entries:
---------------------------------------------------------------------------------
MyDB reads them from "stats.xml" in the application folder.

Example:
<?xml version="1.0" encoding="utf-8"?>
<Statistics>
<Item
  format="total_runtime=%t;total_duration=%t"
  desc="Duration/Runtime"
  sql="SELECT SUM(duration) AS total_duration,SUM(runtime) AS total_runtime FROM files WHERE id IS NOT NULL" />
</Statistics>

• format - (column=value)
	"%s" - Format as size.
	"%t" - Format as timespan
	"%p" - Add percent sign
• desc - Description
• sql - Query