classes/BannerStatisticsHelper.php
protected function getBannersByCatID($CatID = 0)
    {
        $arrBanners = array();
        
        if ($CatID == -1)
        { // all Categories
            $objBanners = \Database::getInstance()
                            ->prepare("SELECT 
                                            tb.id
                                          , tb.banner_type
                                          , tb.banner_name
                                          , tb.banner_url
                                          , tb.banner_jumpTo
                                          , tb.banner_image
                                          , tb.banner_image_extern
                                          , tb.banner_weighting
                                          , tb.banner_start
                                          , tb.banner_stop
                                          , tb.banner_published
                                          , tb.banner_until
                                          , tb.banner_comment
                                          , tb.banner_views_until
                                          , tb.banner_clicks_until
                                          , tbs.banner_views
                                          , tbs.banner_clicks
                                       FROM 
                                            tl_banner tb
                                          , tl_banner_stat tbs
                                       WHERE 
                                            tb.id=tbs.id
                                       ORDER BY 
                                            tb.pid
                                          , tb.sorting")
                            ->execute();
        }
        else
        {
            $objBanners = \Database::getInstance()
                            ->prepare("SELECT
                                            tb.id
                                          , tb.banner_type
                                          , tb.banner_name
                                          , tb.banner_url
                                          , tb.banner_jumpTo
                                          , tb.banner_image
                                          , tb.banner_image_extern
                                          , tb.banner_weighting
                                          , tb.banner_start
                                          , tb.banner_stop
                                          , tb.banner_published
                                          , tb.banner_until
                                          , tb.banner_comment
                                          , tb.banner_views_until
                                          , tb.banner_clicks_until
                                          , tbs.banner_views
                                          , tbs.banner_clicks
                                       FROM
                                            tl_banner tb
                                          , tl_banner_stat tbs
                                       WHERE
                                            tb.id=tbs.id
                                       AND
                                            tb.pid =?
                                       ORDER BY
                                            tb.sorting")
                            ->execute($CatID);
        }
        $intRows = $objBanners->numRows;
        if ($intRows > 0)
        {
            while ($objBanners->next())
            {
                $arrBanners[] = array('id'                  => $objBanners->id
                                    , 'banner_type'         => $objBanners->banner_type
                                    , 'banner_name'         => $objBanners->banner_name
                                    , 'banner_url'          => $objBanners->banner_url
                                    , 'banner_jumpTo'       => $objBanners->banner_jumpTo
                                    , 'banner_image'        => $objBanners->banner_image
                                    , 'banner_image_extern' => $objBanners->banner_image_extern
                                    , 'banner_weighting'    => $objBanners->banner_weighting
                                    , 'banner_start'        => $objBanners->banner_start
                                    , 'banner_stop'         => $objBanners->banner_stop
                                    , 'banner_published'    => $objBanners->banner_published
                                    , 'banner_until'        => $objBanners->banner_until
                                    , 'banner_comment'      => $objBanners->banner_comment
                                    , 'banner_views_until'  => $objBanners->banner_views_until
                                    , 'banner_clicks_until' => $objBanners->banner_clicks_until
                                    , 'banner_views'        => $objBanners->banner_views
                                    , 'banner_clicks'       => $objBanners->banner_clicks                        
                                     );
            } // while
        }
        
        return $arrBanners;
    }
protected function getBannersByCatID($CatID = 0)
    {
        $arrBanners = array();
        
        if ($CatID == -1)
        { // all Categories
            $objBanners = \Database::getInstance()
                            ->prepare("SELECT 
                                            tb.id
                                          , tb.banner_type
                                          , tb.banner_name
                                          , tb.banner_url
                                          , tb.banner_jumpTo
                                          , tb.banner_image
                                          , tb.banner_image_extern
                                          , tb.banner_weighting
                                          , tb.banner_start
                                          , tb.banner_stop
                                          , tb.banner_published
                                          , tb.banner_until
                                          , tb.banner_comment
                                          , tb.banner_views_until
                                          , tb.banner_clicks_until
                                          , tbs.banner_views
                                          , tbs.banner_clicks
                                       FROM 
                                            tl_banner tb
                                          , tl_banner_stat tbs
                                       WHERE 
                                            tb.id=tbs.id
                                       ORDER BY 
                                            tb.pid
                                          , tb.sorting")
                            ->execute();
        }
        else
        {
            $objBanners = \Database::getInstance()
                            ->prepare("SELECT
                                            tb.id
                                          , tb.banner_type
                                          , tb.banner_name
                                          , tb.banner_url
                                          , tb.banner_jumpTo
                                          , tb.banner_image
                                          , tb.banner_image_extern
                                          , tb.banner_weighting
                                          , tb.banner_start
                                          , tb.banner_stop
                                          , tb.banner_published
                                          , tb.banner_until
                                          , tb.banner_comment
                                          , tb.banner_views_until
                                          , tb.banner_clicks_until
                                          , tbs.banner_views
                                          , tbs.banner_clicks
                                       FROM
                                            tl_banner tb
                                          , tl_banner_stat tbs
                                       WHERE
                                            tb.id=tbs.id
                                       AND
                                            tb.pid =?
                                       ORDER BY
                                            tb.sorting")
                            ->execute($CatID);
        }
        $intRows = $objBanners->numRows;
        if ($intRows > 0)
        {
            while ($objBanners->next())
            {
                $arrBanners[] = array('id'                  => $objBanners->id
                                    , 'banner_type'         => $objBanners->banner_type
                                    , 'banner_name'         => $objBanners->banner_name
                                    , 'banner_url'          => $objBanners->banner_url
                                    , 'banner_jumpTo'       => $objBanners->banner_jumpTo
                                    , 'banner_image'        => $objBanners->banner_image
                                    , 'banner_image_extern' => $objBanners->banner_image_extern
                                    , 'banner_weighting'    => $objBanners->banner_weighting
                                    , 'banner_start'        => $objBanners->banner_start
                                    , 'banner_stop'         => $objBanners->banner_stop
                                    , 'banner_published'    => $objBanners->banner_published
                                    , 'banner_until'        => $objBanners->banner_until
                                    , 'banner_comment'      => $objBanners->banner_comment
                                    , 'banner_views_until'  => $objBanners->banner_views_until
                                    , 'banner_clicks_until' => $objBanners->banner_clicks_until
                                    , 'banner_views'        => $objBanners->banner_views
                                    , 'banner_clicks'       => $objBanners->banner_clicks                        
                                     );
            } // while
        }
        
        return $arrBanners;
    }
protected function getBannersByCatID ( $ CatID = 0 ) { $ arrBanners = array ( ) ; if ( $ CatID == - 1 ) { // all Categories $ objBanners = \ Database :: getInstance ( ) -> prepare ( "SELECT 
                                            tb.id
                                          , tb.banner_type
                                          , tb.banner_name
                                          , tb.banner_url
                                          , tb.banner_jumpTo
                                          , tb.banner_image
                                          , tb.banner_image_extern
                                          , tb.banner_weighting
                                          , tb.banner_start
                                          , tb.banner_stop
                                          , tb.banner_published
                                          , tb.banner_until
                                          , tb.banner_comment
                                          , tb.banner_views_until
                                          , tb.banner_clicks_until
                                          , tbs.banner_views
                                          , tbs.banner_clicks
                                       FROM 
                                            tl_banner tb
                                          , tl_banner_stat tbs
                                       WHERE 
                                            tb.id=tbs.id
                                       ORDER BY 
                                            tb.pid
                                          , tb.sorting" ) -> execute ( ) ; } else { $ objBanners = \ Database :: getInstance ( ) -> prepare ( "SELECT
                                            tb.id
                                          , tb.banner_type
                                          , tb.banner_name
                                          , tb.banner_url
                                          , tb.banner_jumpTo
                                          , tb.banner_image
                                          , tb.banner_image_extern
                                          , tb.banner_weighting
                                          , tb.banner_start
                                          , tb.banner_stop
                                          , tb.banner_published
                                          , tb.banner_until
                                          , tb.banner_comment
                                          , tb.banner_views_until
                                          , tb.banner_clicks_until
                                          , tbs.banner_views
                                          , tbs.banner_clicks
                                       FROM
                                            tl_banner tb
                                          , tl_banner_stat tbs
                                       WHERE
                                            tb.id=tbs.id
                                       AND
                                            tb.pid =?
                                       ORDER BY
                                            tb.sorting" ) -> execute ( $ CatID ) ; } $ intRows = $ objBanners -> numRows ; if ( $ intRows > 0 ) { while ( $ objBanners -> next ( ) ) { $ arrBanners [ ] = array ( 'id' => $ objBanners -> id , 'banner_type' => $ objBanners -> banner_type , 'banner_name' => $ objBanners -> banner_name , 'banner_url' => $ objBanners -> banner_url , 'banner_jumpTo' => $ objBanners -> banner_jumpTo , 'banner_image' => $ objBanners -> banner_image , 'banner_image_extern' => $ objBanners -> banner_image_extern , 'banner_weighting' => $ objBanners -> banner_weighting , 'banner_start' => $ objBanners -> banner_start , 'banner_stop' => $ objBanners -> banner_stop , 'banner_published' => $ objBanners -> banner_published , 'banner_until' => $ objBanners -> banner_until , 'banner_comment' => $ objBanners -> banner_comment , 'banner_views_until' => $ objBanners -> banner_views_until , 'banner_clicks_until' => $ objBanners -> banner_clicks_until , 'banner_views' => $ objBanners -> banner_views , 'banner_clicks' => $ objBanners -> banner_clicks ) ; } // while } return $ arrBanners ; }
Get banners by category id

@param integer   $CatID
@return array    $arrBanners
Get banners by category id