HowTo: Add a dynamic footer to XenForo

<?php

class TuxFooter_Listener_Footer {

    public static function includeTuxFooter($hookName, &$contents, array $hookParams, XenForo_template_Abstract $template) {

        if($hookName == 'ad_below_bottom_breadcrumb') {

            ob_start();

            ?>
            <div class="forum_footer">

            <div class="forum_posts_leftside">

            <h3>latest tux reports network resources</h3>

            <?php



            /* Script to pull the latest updated resources from the XF Resource Manager */

            /** @var $resModel  XenResource_Model_Resource */
            $resModel = XenForo_Model::create('XenResource_Model_Resource');
            $fetchOptions = array('limit' => 5, 'order' => 'resource_date', 'direction' => 'desc');

            $rmupdates = $resModel->getResources(array(), $fetchOptions);

            foreach ($rmupdates AS $rmupdate) {
                echo ("<div class='entry-meta'><a href='http://community.tuxreportsnetwork.com/" . XenForo_Link::buildPublicLink('resources', $rmupdate) . "' >" . XenForo_Helper_String::wholeWordTrim($rmupdate['title'], 55) . "</a> <br /></div>"); // Echo the title with a link.
            }



            ?>

                    </div><!-- Close forum_posts_leftside -->

                    <div class="forum_posts">

                        <h3>latest posts from our community</h3>

                        <?php

                        /* Script to pull the latest posts from the XF Forum */

                        $db = XenForo_Application::getDb();

                        if ( !$db ) {

                            die( 'This script did not connect to the database' . mysql_error() );
                        }

                        $thread_qry = "
                                    SELECT * FROM `xf_thread`
                                    ORDER BY `last_post_date` DESC
                                    LIMIT 5
                                    ";

                        $threads = XenForo_Application::get('db')->fetchAll($thread_qry);

                        foreach (    $threads AS $thread ) {

                            echo ("<div class='entry-meta'><a href='http://community.tuxreportsnetwork.com/" . XenForo_Link::buildPublicLink('threads', $thread) . "' >" . XenForo_Helper_String::wholeWordTrim($thread['title'], 48) . "</a> <span style='float:right; margin-right:60px'>Viewed: " . $thread['view_count']
                                    . "</span><br /></div>"); // Echo the title with a link.

                        }

                        ?>

                    </div><!-- Close forum_posts -->

                </div><!-- Forum Footer -->
<?php
                $contents .= ob_get_contents();
                ob_end_clean();
            }

    }

}
?>

$config['debug'] = true;