/**
 * Unregister the Droplet $droplet_name from the $page_id with the settings
 * $module_directory, $file_type and $file_name
 * 
 * @param integer $page_id
 * @param string $droplet_name
 * @param sring $module_directory
 * @param string $file_type - 'css' or 'js'
 * @param string $file_name
 */
function unregister_droplet($page_id, $droplet_name, $module_directory, $file_type, $file_name)
{
    global $database;
    if (is_registered_droplet($page_id, $droplet_name, $module_directory, $file_type)) {
        $table = TABLE_PREFIX . 'mod_droplets_load';
        $SQL = "DELETE FROM `{$table}` WHERE `page_id`='{$page_id}' AND `register_name`='{$droplet_name}' AND " . "`module_directory`='{$module_directory}' AND `file_type`='{$file_type}' AND `file_name`='{$file_name}'";
        if (!$database->query($SQL)) {
            trigger_error(sprintf('[%s - %s] %s', __FUNCTION__, __LINE__, $database->get_error()));
        }
    }
    return true;
}
/**
 * Register the Droplet $droplet_name for the $page_id for the $file_type 'css' or 'js'
 * with the specified $file_name.
 * If $file_path is specified the file will be loaded from $file_path, otherwise the
 * file will be loaded from the desired $module_directory.
 * If $page_id is set to -1 the CSS/JS file will be loaded at every page (for usage 
 * in templates)
 * 
 * @param integer $page_id
 * @param string $droplet_name
 * @param string $module_directory - only the directory name
 * @param string $file_type - may be 'css' or 'js'
 * @param string $file_name - the filename with extension
 * @param string $file_path - relative to the root
 * @return boolean on success
 */
function register_droplet($page_id, $droplet_name, $module_directory, $file_type, $file_name = 'frontend.css', $file_path = '')
{
    global $database;
    $option = array();
    if (defined('POST_ID')) {
        $option['POST_ID'] = POST_ID;
    }
    if (defined('TOPIC_ID')) {
        $option['TOPIC_ID'] = TOPIC_ID;
    }
    $option_str = serialize($option);
    if (is_registered_droplet($page_id, $droplet_name, $module_directory, $file_type)) {
        return true;
    }
    $table = TABLE_PREFIX . 'mod_droplets_load';
    $SQL = "INSERT INTO `{$table}` (page_id, register_name, register_type, file_type, module_directory, file_name, file_path, options) " . "VALUES ('{$page_id}', '{$droplet_name}', 'droplet', '{$file_type}', '{$module_directory}', '{$file_name}', '{$file_path}', '{$option_str}')";
    if (!$database->query($SQL)) {
        trigger_error(sprintf('[%s - %s] %s', __FUNCTION__, __LINE__, $database->get_error()));
    }
    return true;
}