Populate TV Input Option Values with GetResources-snippet

<?php

/**
 * This Snippet is called by the Manager (TV definition)
 * and can't be moved to a file. Also, Snippets like
 * getResources or Wayfinder aren't able to do the work here.
 * The same applies to $modx->getChildIds() etc. - it just
 * remains empty...
 */

function getTvSiteStructure($dbh, $parentId = 0, $level = 1, $maxLevel = 2)
{
    global $table_prefix;

    if ($level > $maxLevel) {
        return '';
    }

    $indent          = '--';
    $thisLevelIndent = (1 == $level) ? '' : str_repeat($indent, $level - 1).' ';

    $sql = "SELECT
                `id`,
                `menutitle`
            FROM
                `".$table_prefix."site_content`
            WHERE
                `parent`        = :parent
                AND `published` = :published
                AND `hidemenu`  = :hidemenu
                AND `deleted`   = :deleted
            ORDER BY
                `menuindex`";
    $stmt = $dbh->prepare($sql);
    $params = array(
        ':parent'    => $parentId,
        ':published' => 1,
        ':hidemenu'  => 0,
        ':deleted'   => 0
    );
    if ($stmt->execute($params)) {
        $menuItems = $stmt->fetchAll();
    }

    $tvSiteStructure = '';

    foreach ($menuItems as $menuItem) {
        $tvSiteStructure .= $thisLevelIndent;
        // Although the charset is used when connecting to the database,
        // utf8_encode() is necessary here (?)
        $tvSiteStructure .= utf8_encode($menuItem['menutitle']).'=='.$menuItem['id'].'||';

        $tvSiteStructure .= ($level == $maxLevel) ? '' : getTvSiteStructure($dbh, $menuItem['id'], $level + 1, $maxLevel);
    }

    return $tvSiteStructure;
}



global $database_type,
       $database_server,
       $dbase,
       $database_user,
       $database_password,
       $database_connection_charset;

$dsn =  $database_type.':host='.$database_server
        .';dbname='.trim($dbase, '`')
        .';charset='.$database_connection_charset;

try {
    $dbh = new PDO($dsn, $database_user, $database_password);
} catch (PDOException $e) {
    echo 'Connection failed: '.$e->getMessage();
}

$tvSiteStructure = getTvSiteStructure($dbh, 0, 1, 5);

// Remove pipe symbols at the end of the string
$tvSiteStructure = trim($tvSiteStructure, '|');

return $tvSiteStructure;

@EVAL return $modx->runSnippet('SiteStructureForTv');

@EVAL return $modx->runSnippet('getResources', array('parents'=>'94', 'showUnpublished'=>'1', 'showHidden'=>'1', 'hideContainers'=>'1', 'tplFirst'=>'tvInputOptionsFirstTpl', 'tpl'=>'tvInputOptionsTpl', 'context'=>'web', 'limit'=>'0'));

[[+pagetitle]]==[[+id]]​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​

||[[+pagetitle]]==[[+id]]​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​

How To Video One==47 ||How To Video Two==51 ||How To Video Three==52 ||How To Video Four==53 ||How To Video Five==61 ||How To Video Six==62 ||How To Video Seven==63 ||How To Video Eight==64 ||How To Video Nine==65 ||How To Video Ten==67 ||How To Video Eleven==68 ||How To Video Twelve==70 ||How To Video Thirteen==71 ||How To Video Fourteen==73 ||How To Video Fifteen==74 ||How To Video Sixteen==75 ||How To Video Seventeen==76 ||HHow To Video Eighteen==83 ||How To Video Nineteen==84 ||How To Video Twenty==85 ||How To Video Twenty One==86 ||How To Video Twenty Two==87

<?php

/* SetTVList
 *
 * Set a list from set of resources
 *
 * @author EQUILIBRE WEBDESIGN - Enzo GRAFTIEAUX
 * @copyright 2011
 * @version 0.2
 * @license http://www.gnu.org/licenses/old-licenses/gpl-2.0.html GNU General Public License
 */

/* Get parameters */
$parentId = $modx->getOption('parent', $scriptProperties, 0);
$templateId = $modx->getOption('templateid', $scriptProperties, '');
$field = $modx->getOption('field', $scriptProperties, 'pagetitle');
if (!$templateId) return false;

/* Select resources */
$fields = array('id', $field);
/*  Prepate SQL request */
$criteria = $modx->newQuery('modResource');
$criteria->where(array(
    'template' => $templateId,
    'published' => true,
    'deleted' => false,
));
/* SQL request*/
$resources = $modx->getCollection('modResource', $criteria);

$output="";
/* Loop on resources found */
foreach ($resources as $resource){
    $docid=$resource->get('id');
    $fieldValue=$resource->get($field);
    $output .= $fieldValue."==".$docid."||";
}

/* Return result */
return rtrim($output,'|');
?>

@EVAL return $modx->runSnippet('setTVList',array("parent"=>"8","field" =>"pagetitle","templateid"=>"9"));