ROZWIĄZANY: Top reputation

[barthav]

Witam, do poniższego kodu chcę dodać joina, który pobierze avatary. Jednak w rezultacie otrzymuję drive error na forum.

$this->DB->build( array(
    'select'  => 'pp.pp_member_id, pp.pp_reputation_points',
    'from'  => array( 'profile_portal' => 'pp' ),
    'where'  => 'pp_reputation_points > 0',
    'order'  => 'pp_reputation_points DESC',
    'limit'  => array( 0, $this->settings['dp30topx_items'] ),	 
    'add_join' => array(
		 array(
		   'select' => 'm.members_display_name, m.member_id, m.members_seo_name, m.member_group_id',
		   'from'   => array( 'members' => 'm' ),
		   'where'  => 'm.member_id=pp.pp_member_id',
		   'type'   => 'left',
		  ),
		 array(
		   'select' => 'pp.*',
		   'from'  => array( 'profile_portal' => 'pp' ),
		   'where'  => 'm.member_id=pp.pp_member_id',
		   'type'  => 'left',
		  ),

	    )	 
  ) );

 $q = $this->DB->execute();

[DawPi]

Jakiego driver errora? Daj log z cache/.

[DawPi]

Automatyczna wiadomość

Temat przeniesiony z forum:

"Invision Power Board → Invision Power Board 3.2 → Modyfikacje - pomoc"

do:

"Invision Power Board → Zaawansowane programowanie"

[barthav]

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Fri, 30 Dec 2011 12:25:17 +0000
Error: 1066 - Not unique table/alias: 'm'
IP Address: 78.31.89.1 - /
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT pp.pp_member_id, pp.pp_reputation_points,m.members_display_name, m.member_id, m.members_seo_name, m.member_group_id,m.members_display_name, m.member_id, m.members_seo_name, m.member_group_id FROM profile_portal pp  LEFT JOIN members m ON ( m.member_id=pp.pp_member_id )
LEFT JOIN members m ON ( m.member_id=pp.pp_member_id )   WHERE pp_reputation_points > 0 ORDER BY pp_reputation_points DESC LIMIT 0,5
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/classes/output/publicOutput.php							  | [dp30topxreputation].getOutput											    | 3371			  |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php							  | [output].templateHooks													    | 2673			  |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/dp32_cwc_outputOverload_738136425f945402bd3be1019d07bc98.php		 | [output].sendOutput														   | 35			    |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php				 | [dp32_cwc_outputOverload].sendOutput										  | 127			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [public_forums_forums_boards].doExecute									   | 302			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

[DawPi]

Dziwne to wszystko. Pobierasz dane z tabeli profile_portal, by za chwilę joinować ją. Po co?

Daj tak:

$this->DB->build( array(
           'select'  => 'pp.*',
           'from'  => array( 'profile_portal' => 'pp' ),
           'where'  => 'pp_reputation_points > 0',
           'order'  => 'pp_reputation_points DESC',
           'limit'  => array( 0, $this->settings['dp30topx_items'] ),   
           'add_join' => array(
                        array(
                          'select' => 'm.members_display_name, m.member_id, m.members_seo_name, m.member_group_id',
                          'from'   => array( 'members' => 'm' ),
                          'where'  => 'm.member_id=pp.pp_member_id',
                          'type'   => 'left',
                         )                        
                   )    
         ) );

 $q = $this->DB->execute();

[barthav]

Dziwne to jest dla mnie - człowiek uczy się całe życie. Dzięki, oczywiście zadziałało, jednak wybrałem IPSMember.

Do zamknięcia.

[Jakub]

Problem ROZWIĄZANY. Jeśli są jakiekolwiek wątpliwości, pytania proszę o założenie nowego tematu.

Wszelkie uzasadnione reklamacje/pretensje/sugestie/rady przyjmuje ekipa forum.