<?php
/**
 * Output functions
 *
 * Functions for HTML output generation (Not templates!)
 *
 * @todo    Check if this can be moved to smarty plugins
 *
 * @package Core
 * @author  Andreas Gohr    <hide@address.com>
 * @author  Andreas Goetz   <hide@address.com> 
 * @version $Id: output.php,v 1.24 2008/04/20 17:30:21 andig2 Exp $
 */

require_once './core/functions.php';

/**
 * Return list of valid genres from db
 */
function getGenres()
{
    $SELECT = 'SELECT id, name
                 FROM '.TBL_GENRES.'
             ORDER BY name';
    $result = runSQL($SELECT);
    
    return $result;
}

/**
 * Display genre checkboxes
 *
 * @param  array $selected  selected genre IDs
 * @return                  string HTML for genre checkboxes
 */
function out_genres($selected)
{
    global $config;

    $result = getGenres();
	$out = '<table class="genreselect"><tr>';

    // get list of adult genres
    $adultgenres = array();
    if ($config['multiuser'] && !check_permission(PERM_ADULT))
    {
        $adultgenres = get_adult_genres();
    }

	$row = 0;
	foreach ($result as $res)
	{
        // don't show adult genres if no permissions
        if (in_array($res['id'], $adultgenres)) continue;

		$out .= '<td nowrap="nowrap">';
		$out .= '<input type="checkbox" name="genres[]" id="genreid'.$res['id'].'" value="'.$res['id'].'"';
		if (@in_array ($res['id'], $selected))
        {
			$out .= ' checked="checked"';
		}
		$out .= '/>';
		$out .= '<label for="genreid'.$res['id'].'">';
		$out .= $res['name'];
		$out .= '</label> ';
		$out .= '</td>';
        if ((++$row % 5) == 0)
        {
			$out .= '</tr><tr>';
		}
	}
	$out .= '</tr></table>';
	return $out;
}

/**
 * Display selectbox with available Mediatypes
 *
 * @todo is this still used? can it be replaced by template code?
 * @author <hide@address.com>
 * @return string   HTML of selectbox
 */
function out_mediatypes()
{
	global $config;

    // select mediatypes
	$SELECT = 'SELECT id, name
                 FROM '.TBL_MEDIATYPES.'
			 ORDER BY name';
	$result = runSQL($SELECT);

    // build associative array
    $mediatypes = array('0' => '') + array_associate($result, 'id', 'name');

    return $mediatypes;
}

/**
 * All available language flags for config screen
 *
 * @param  array  $flags   selected flags
 * @return string          HTML of Languageflags
 */
function out_languageflags($flags)
{
	global $config;

	$out	= '';
	$count	= 1;
	
	if (($dh = @opendir('./'.$config['templatedir'].'images/flags')) || ($dh = opendir('./images/flags')))
	{
		while (($file = readdir($dh)) !== false)
		{
			if (preg_match("/(.*)\.gif$/", $file, $matches))
			{
				$CHECK= (in_array($matches[1], $flags)) ? 'checked="checked"' : '';
				$out .= '<input type="checkbox" name="languages[]" '.$CHECK.' id="flag_'.$matches[1].'" value="'.$matches[1].'" />';
				$out .= '<label for="flag_'.$matches[1].'">';
				$out .= '<img src="'.img('flags/'.$matches[1].'.gif').'" width="30" height="15" alt="'.ucwords($matches[1]).'" title="'.ucwords($matches[1]).'" />';
				$out .= '</label> ';
				if ($count++%4 == 0) $out.='<br />';
			}
		}
		closedir($dh);
	}
	return $out;
}

/**
 * List of owners names/ids with valid permissions for use in edit/index/search templates
 *
 * @author  <hide@address.com>
 * @author  Chinamann <hide@address.com>
 * @param   string  $prefix         Predefined additional Array entries
 * @param   string  $permission     Honor permissions for selectbox
 * @return  string                  Array with keys=ownernames and values=ownerids
 */
function out_owners($prefix = null, $permission = false, $keyIsId = false)
{
    global $config;

    // all permissions available if admin
    if (check_permission(PERM_ADMIN)) $permission = false;

    // hide guest if he/she can't login
    $WHERES = ($config['denyguest']) ? " AND B.id != ".$config['guestid'] : '';

    // select user ids- if permissions are required and no all access given, this is done against xrefs
    if ($permission && !check_permission($permission))
    {
        // xref permissions
        // TODO use cached permission table instead
        $SELECT = 'SELECT DISTINCT(B.name) AS name, B.id
                     FROM '.TBL_PERMISSIONS.' A, '.TBL_USERS.' B
                    WHERE A.to_uid = B.id
                          AND A.from_uid = '.$_COOKIE['VDBuserid'].'
                          AND (A.permissions & '.$permission.') = '.$permission.$WHERES.'
                    ORDER BY name';
    }
    else
    {
        // all users +/- guest
        $SELECT = 'SELECT B.id, B.name
                     FROM '.TBL_USERS.' B
                    WHERE 1=1 '.$WHERES.'
                    ORDER BY B.name';
    }
    $result = runSQL($SELECT);

    $key = ($keyIsId) ? 'id' : 'name';

    // build associative array
    $owners = array_unique(array_associate($result, $key, 'name'));

    // return directly or Zend Optimizer 2.5.5 will do ugly things
    if ($prefix) return($prefix + $owners);

    return $owners;
}

/**
 * MySQL-compatible list of owner ids with required access permission
 *
 * @author  Andreas Goetz   <hide@address.com> 
 */
function get_owner_ids($permission)
{
    foreach($_SESSION['vdb']['permissions']['to_uid'] as $to_uid => $perm)
    {
        if ($permission & $perm) $ids[] = $to_uid;
    }
    
    return (count($ids)) ? join(',', $ids) : -1;
}

?>