Así es soy un estupido, lo he dejado así y todo bien
Código PHP:
Ver original$max_post_time = 0;
$sql = $db->sql_build_query('SELECT', array( 'SELECT' => 'u.*, z.friend, z.foe, p.*, pb.id AS pb_id, pb.holding AS pb_holding',
USERS_TABLE => 'u',
POSTS_TABLE => 'p',
),
'FROM' => array(ZEBRA_TABLE
=> 'z'), 'ON' => 'z.user_id = ' . $user->data['user_id'] . ' AND z.zebra_id = p.poster_id'
),
'FROM' => array(POINTS_BANK_TABLE
=> 'pb'), 'ON' => 'pb.user_id = p.poster_id'
)
),
'WHERE' => $db->sql_in_set('p.post_id', $post_list) . '
AND u.user_id = p.poster_id'
));
muchas gracias señor pateke y rpv +karma