Unreal Portal i Ostatnie wisy na blogu

[Bartman]

W wersji 3.0 Forum miałem "custom block" w Unreal Portalu wyświetlający ostatnie wpisy na blogu, po upgradzie do 3.1 nie wyświetlają się w nim ikonki użytkowników - autorów wpisu.

Zamieszczam kod, może ktoś wyszuka chochlika.

<?php                /* Unserialize blog permissions */                if( ! $this->memberData['g_blog_settings'] )                {                        return '';                }                                if( ! is_array( $this->memberData['g_blog_settings'] ) )                {                        $this->memberData['g_blog_settings'] = unserialize( $this->memberData['g_blog_settings'] );                }                                /* Check permission */                if( $this->memberData['g_blog_settings']['g_blog_allowview'] )                {                        /* Query bits */                        $extra                  = '';                        $allowguests    = '';                                                if( ! $this->memberData['member_id'] )                        {                                $allowguests .= " AND b.blog_allowguests = 1";                        }                                                if( ! $this->memberData['_blogmod']['moderate_can_view_private'] )                        {                                $extra = " AND ( ( ( p.owner_only=1 AND b.member_id={$this->memberData['member_id']} ) OR p.owner_only=0 ) AND ( p.authorized_users LIKE '%,{$this->memberData['member_id']},%' OR p.authorized_users IS NULL ) ) ";                        }                        /* Query the entires */                        $this->DB->build( array(                                                                                 'select'        => "e.*",                                                                                'from'          => array('blog_entries' => 'e'),                                                                                'add_join'      => array(                                                                                                                         array(                                                                                                                                         'select'        => 'b.blog_name',                                                                                                                                        'from'          => array( 'blog_blogs' => 'b' ),                                                                                                                                        'where'         => "e.blog_id=b.blog_id",                                                                                                                                        'type'          => 'left'                                                                                                                                ),                                                                                                                        array(                                                                                                                                        'from'          => array( 'permission_index' => 'p' ),                                                                                                                                        'where'         => "p.perm_type_id=b.blog_id AND p.perm_type='blog'",                                                                                                                                        'type'          => 'left'                                                                                                                                ),                                                                                                                        array(                                                                                                                                        'select'        => 'm.members_display_name, m.members_seo_name',                                                                                                                                        'from'          => array( 'members' => 'm' ),                                                                                                                                        'where'         => 'e.entry_author_id=m.member_id',                                                                                                                                        'type'          => 'left'                                                                                                                                )                                                                                                                ),                                                                                'where'         => "b.blog_type='local' AND e.entry_status='published'".$allowguests.$extra,                                                                                'order'         => 'e.entry_date DESC',                                                                                'limit'         => array( 0, 5 )                                                          )     );                        $this->DB->execute();                        /* Loop through and build the blog entries array */                        $entries_array = array();                        while( $entry = $this->DB->fetch() )                        {                                $entry['_seo_entry_name'] = IPSText::makeSeoTitle( $entry['entry_name'] );                                $entries_array[] = $entry;                        }                                                echo $this->registry->output->getTemplate( 'boards' )->hookRecentBlogEntries( $entries_array );                }                else                {                        echo '';                }?>

[DawPi]

Tak, w tym kodzie na pewno - pokaż ten kod z wcięciami, a nie w jednej linijce.

[Bartman]

<table class='ipb_table' cellspacing="1">
   <tbody>
       <tr>
           <td class='row2'>

<?php


               /* Unserialize blog permissions */
               if( ! $this->memberData['g_blog_settings'] )
               {
                       return '';
               }

               if( ! is_array( $this->memberData['g_blog_settings'] ) )
               {
                       $this->memberData['g_blog_settings'] = unserialize( $this->memberData['g_blog_settings'] );
               }

               /* Check permission */
               if( $this->memberData['g_blog_settings']['g_blog_allowview'] )
               {
                       /* Query bits */
                       $extra                  = '';
                       $allowguests    = '';

                       if( ! $this->memberData['member_id'] )
                       {
                               $allowguests .= " AND b.blog_allowguests = 1";
                       }

                       if( ! $this->memberData['_blogmod']['moderate_can_view_private'] )
                       {
                               $extra = " AND ( ( ( p.owner_only=1 AND b.member_id={$this->memberData['member_id']} ) OR p.owner_only=0 ) AND ( p.authorized_users LIKE '%,{$this->memberData['member_id']},%' OR p.authorized_users IS NULL ) ) ";
                       }

                       /* Query the entires */
                       $this->DB->build( array( 
                                                                               'select'        => "e.*",
                                                                               'from'          => array('blog_entries' => 'e'),
                                                                               'add_join'      => array( 
                                                                                                                       array( 
                                                                                                                                       'select'        => 'b.blog_name',
                                                                                                                                       'from'          => array( 'blog_blogs' => 'b' ),
                                                                                                                                       'where'         => "e.blog_id=b.blog_id",
                                                                                                                                       'type'          => 'left'
                                                                                                                               ),
                                                                                                                       array(
                                                                                                                                       'from'          => array( 'permission_index' => 'p' ),
                                                                                                                                       'where'         => "p.perm_type_id=b.blog_id AND p.perm_type='blog'",
                                                                                                                                       'type'          => 'left'
                                                                                                                               ),
                                                                                                                       array(
                                                                                                                                       'select'        => 'm.members_display_name, m.members_seo_name',
                                                                                                                                       'from'          => array( 'members' => 'm' ),
                                                                                                                                       'where'         => 'e.entry_author_id=m.member_id',
                                                                                                                                       'type'          => 'left'
                                                                                                                               )
                                                                                                               ),
                                                                               'where'         => "b.blog_type='local' AND e.entry_status='published'".$allowguests.$extra,
                                                                               'order'         => 'e.entry_date DESC',
                                                                               'limit'         => array( 0, 5 )
                                                         )     );
                       $this->DB->execute();

                       /* Loop through and build the blog entries array */
                       $entries_array = array();

                       while( $entry = $this->DB->fetch() )
                       {
                               $entry['_seo_entry_name'] = IPSText::makeSeoTitle( $entry['entry_name'] );
                               $entries_array[] = $entry;
                       }

                       echo $this->registry->output->getTemplate( 'boards' )->hookRecentBlogEntries( $entries_array );
               }
               else
               {
                       echo '';
               }

?>

           </td>
       </tr>
   </tbody>
</table>

[DawPi]

Nie testowane, próbuj:

<table class='ipb_table' cellspacing="1">
   <tbody>
       <tr>
           <td class='row2'>

<?php


               /* Unserialize blog permissions */
               if( ! $this->memberData['g_blog_settings'] )
               {
                       return '';
               }

               if( ! is_array( $this->memberData['g_blog_settings'] ) )
               {
                       $this->memberData['g_blog_settings'] = unserialize( $this->memberData['g_blog_settings'] );
               }

               /* Check permission */
               if( $this->memberData['g_blog_settings']['g_blog_allowview'] )
               {
                       /* Query bits */
                       $extra                  = '';
                       $allowguests    = '';

                       if( ! $this->memberData['member_id'] )
                       {
                               $allowguests .= " AND b.blog_allowguests = 1";
                       }

                       if( ! $this->memberData['_blogmod']['moderate_can_view_private'] )
                       {
                               $extra = " AND ( ( ( p.owner_only=1 AND b.member_id={$this->memberData['member_id']} ) OR p.owner_only=0 ) AND ( p.authorized_users LIKE '%,{$this->memberData['member_id']},%' OR p.authorized_users IS NULL ) ) ";
                       }

                       /* Query the entires */
                       $this->DB->build( array( 
                                                                               'select'        => "e.*",
                                                                               'from'          => array('blog_entries' => 'e'),
                                                                               'add_join'      => array( 
                                                                                                                       array( 
                                                                                                                                       'select'        => 'b.blog_name',
                                                                                                                                       'from'          => array( 'blog_blogs' => 'b' ),
                                                                                                                                       'where'         => "e.blog_id=b.blog_id",
                                                                                                                                       'type'          => 'left'
                                                                                                                               ),
                                                                                                                       array(
                                                                                                                                       'from'          => array( 'permission_index' => 'p' ),
                                                                                                                                       'where'         => "p.perm_type_id=b.blog_id AND p.perm_type='blog'",
                                                                                                                                       'type'          => 'left'
                                                                                                                               ),
                                                                                                                       array(
                                                                                                                                       'select'        => 'm.members_display_name, m.members_seo_name',
                                                                                                                                       'from'          => array( 'members' => 'm' ),
                                                                                                                                       'where'         => 'e.entry_author_id=m.member_id',
                                                                                                                                       'type'          => 'left'
                                                                                                                               )
                                                                                                               ),
                                                                               'where'         => "b.blog_type='local' AND e.entry_status='published'".$allowguests.$extra,
                                                                               'order'         => 'e.entry_date DESC',
                                                                               'limit'         => array( 0, 5 )
                                                         )     );
                       $this->DB->execute();

                       /* Loop through and build the blog entries array */

					$entries = array();

                       while( $entry = $this->DB->fetch() )
                       {
                               $entry['_seo_entry_name'] = IPSText::makeSeoTitle( $entry['entry_name'] );
                               $entries[] = $entry;
                       }

					if( count( $entries ) > 0 )
					{
						if( is_array( $entries ) )
						{
							foreach( $entries as $eid => $entry )
							{
								$entry                = IPSMember::buildDisplayData( $entry );
								$entry['_entry_date'] = $this->registry->getClass('class_localization')->getDate( $entry['entry_date'], 'SHORT2' );

								$entry['_lastRead'] = $this->registry->classItemMarking->fetchTimeLastMarked( array( 'blogID' => $entry['blog_id'], 'itemID' => $entry['entry_id'] ), 'blog' );

								if( $entry['entry_last_update'] > $entry['_lastRead'] )
								{
									$entry['newpost'] = true;
								}
								else
								{
									$entry['newpost'] = false;
								}

								$entries[ $eid ] = $entry;
							}

							echo $this->registry->output->getTemplate( 'boards' )->hookRecentBlogEntries( $entries );
						}
					}                                  
               }
               else
               {
                       echo '';
               }

?>

           </td>
       </tr>
   </tbody>
</table>

[Bartman]

Teraz wyświetla ale obrazek domyślny a nie foto użytkownika, nawet jeśli je posiada.

[DawPi]

Nie analizowałem tego kodu, nie robi się tego w parę sekund.