The Arcive of Official vBulletin Modifications Site.

John Tran · #1 07-20-2011, 07:55 PM

I've been playing around the the memberinfo template for awhile now, I moved the album that appears on the sidebar into a tab. That works, but I would like to find a way to display ALL of the member albums in a new profile tab.

This is the code I used to display the sidebar albums in my current tab "
{vb:raw blocks.albums}" I would like to know if there is a way to display all of my albums while keeping the formatting I all ready created on "album.php"

John Tran · #2 07-28-2011, 01:17 PM

Still nothing? Man, I swear Vbulletin forum is not as helpful as some of the other communities out there, maybe because this isn't open source?

kh99 · #3 07-28-2011, 01:34 PM

I see that you found the article on creating profile tabs. You probably want to look in includes/class_profileblock.php, function vB_ProfileBlock_Albums:

repare_output() around line 1023. Basically it does a query of the album table and formats the output by rendering the memberinfo_albumbit template for each album.

Honourable · #4 06-15-2013, 02:19 PM

any actual way to this???? other than just hinting out?

Lynne · #5 06-15-2013, 02:47 PM

You could see if there is a modification already or you can hire someone to write one. This is a user run community where we help others customize their site. We can't go and code up everything for you, but we are willing to point you in the right direction and when you get stuck, post up your code, and we can help you out.

Honourable · #6 06-16-2013, 11:31 AM

Hey Lynne,

I really tried my best yet I couldnt make yet work

you can check it here the code so far

PHP Code:


			
if (isset($vbulletin->GPC['tab']))
{
    $selected_tab = $vbulletin->GPC['tab'];
}
$blockinfo['title'] = "الصور";
$blockid = "photos";
$taburl = $memberurl = fetch_seo_url('member', $prepared) . "&amp;tab=photos#photos";

$templater = vB_Template::create('memberinfo_tab');
$templater->register('selected_tab', $selected_tab);
$templater->register('relpath', $relpath);
$templater->register('blockinfo', $blockinfo);
$templater->register('blockid', $blockid);
$templater->register('taburl', $taburl);
$template_hook['profile_tabs_last'] .= $templater->render();  

// ### Your code to fill the tab ###
// Don't forget you need to register any variables for use in templates 

    function prepare_output($id = '', $options = array())
    {
        global $show, $vbphrase;

        if (is_array($options))
        {
            $options = array_merge($this->option_defaults, $options);
        }
        else
        {
            $options = $this->option_defaults;
        }

        require_once(DIR . '/includes/functions_album.php');

        $state = array('public');
        if (can_view_private_albums($this->profile->userinfo['userid']))
        {
            $state[] = 'private';
        }
        if (can_view_profile_albums($this->profile->userinfo['userid']))
        {
            $state[] = 'profile';
        }

        if (!$this->profile->prepared['myprofile'])
        {
            if (!can_moderate(0, 'canmoderatepictures'))
            {
                $sql = "AND album.visible > 0";
            }
            else
            {
                $sql = "AND (album.visible > 0 OR album.moderation > 0)";
            }
        }
        else
        {
            $sql = "";
        }

        $hook_query_fields = $hook_query_joins = $hook_query_where = '';
        ($hook = vBulletinHook::fetch_hook('member_profileblock_album_query')) ? eval($hook) : false;

        $albums = $this->registry->db->query_read_slave("
            SELECT album.*,
                a.attachmentid, album.moderation,
                fd.thumbnail_dateline, fd.thumbnail_width, fd.thumbnail_height, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail
                $hook_query_fields
            FROM " . TABLE_PREFIX . "album AS album
            LEFT JOIN " . TABLE_PREFIX . "attachment AS a ON (album.coverattachmentid = a.attachmentid)
            LEFT JOIN " . TABLE_PREFIX . "filedata AS fd ON (fd.filedataid = a.filedataid)
            $hook_query_joins
            WHERE
                album.userid = ". $this->profile->userinfo['userid'] . "
                    AND
                album.state IN ('" . implode("', '", $state) . "')
                $sql
                $hook_query_where
            ORDER BY album.lastpicturedate DESC
        ");
        $albumbits = '';
        while ($album = $this->registry->db->fetch_array($albums))
        {
            $album['picturedate'] = vbdate($this->registry->options['dateformat'], $album['lastpicturedate'], true);
            $album['picturetime'] = vbdate($this->registry->options['timeformat'], $album['lastpicturedate']);
            $album['title_html'] = fetch_word_wrapped_string(fetch_censored_text($album['title']));
            $album['coverdimensions'] = ($album['thumbnail_width'] ? "width=\"$album[thumbnail_width]\" height=\"$album[thumbnail_height]\"" : '');

            if ($album['moderation'])
            {
                $album['moderatedcount'] = vb_number_format($album['moderation']);
                $show['moderated'] = true;
            }
            else
            {
                $show['moderated'] = false;
            }

            $templater = vB_Template::create('memberinfo_block_photos');
            $templater->register('album', $album);
            $albumbits .= $templater->render();
        }

        $photos_tab_content = $albumbits;
    }

$templater = vB_Template::create('memberinfo_block_photos');
$templater->register('selected_tab', $selected_tab);
$templater->register('photos_tab_content', $photos_tab_content);
$template_hook['profile_tabs'] .= $templater->render();

hope if you can help me

as I removed the LIMIT from the sql query

so I registered the array contain everything

added to the templates that already created and delcared

yet it doesnt display the albums????

--------------- Added [DATE]1371390920[/DATE] at [TIME]1371390920[/TIME] ---------------

what I have don so far

PHP Code:


			
if (isset($vbulletin->GPC['tab']))
{
    $selected_tab = $vbulletin->GPC['tab'];
}
$blockinfo['title'] = "الصور";
$blockid = "photos";
$taburl = $memberurl = fetch_seo_url('member', $prepared) . "&amp;tab=photos#photos";

$templater = vB_Template::create('memberinfo_tab');
$templater->register('selected_tab', $selected_tab);
$templater->register('relpath', $relpath);
$templater->register('blockinfo', $blockinfo);
$templater->register('blockid', $blockid);
$templater->register('taburl', $taburl);
$template_hook['profile_tabs_last'] .= $templater->render();  

// ### Your code to fill the tab ###
// Don't forget you need to register any variables for use in templates 

global $show, $vbphrase;

        require_once(DIR . '/includes/functions_album.php');

$state = array('public');
        if (can_view_private_albums($this->profile->userinfo['userid']))
        {
            $state[] = 'private';
        }
        if (can_view_profile_albums($this->profile->userinfo['userid']))
        {
            $state[] = 'profile';
        }

        if (!$this->profile->prepared['myprofile'])
        {
            if (!can_moderate(0, 'canmoderatepictures'))
            {
                $sql = "AND album.visible > 0";
            }
            else
            {
                $sql = "AND (album.visible > 0 OR album.moderation > 0)";
            }
        }
        else
        {
            $sql = "";
        }



        $albums = $this->registry->db->query_read_slave("
            SELECT album.*,
                a.attachmentid, album.moderation,
                fd.thumbnail_dateline, fd.thumbnail_width, fd.thumbnail_height, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail
                $hook_query_fields
            FROM " . TABLE_PREFIX . "album AS album
            LEFT JOIN " . TABLE_PREFIX . "attachment AS a ON (album.coverattachmentid = a.attachmentid)
            LEFT JOIN " . TABLE_PREFIX . "filedata AS fd ON (fd.filedataid = a.filedataid)
            $hook_query_joins
            WHERE
                album.userid = ". $this->profile->userinfo['userid'] . "
                    AND
                album.state IN ('" . implode("', '", $state) . "')
                $sql
                $hook_query_where
            ORDER BY album.lastpicturedate DESC
        ");
        $albumbits = '';
        while ($album = $this->registry->db->fetch_array($albums))
        {
            $album['picturedate'] = vbdate($this->registry->options['dateformat'], $album['lastpicturedate'], true);
            $album['picturetime'] = vbdate($this->registry->options['timeformat'], $album['lastpicturedate']);
            $album['title_html'] = fetch_word_wrapped_string(fetch_censored_text($album['title']));
            $album['coverdimensions'] = ($album['thumbnail_width'] ? "width=\"$album[thumbnail_width]\" height=\"$album[thumbnail_height]\"" : '');

            if ($album['moderation'])
            {
                $album['moderatedcount'] = vb_number_format($album['moderation']);
                $show['moderated'] = true;
            }
            else
            {
                $show['moderated'] = false;
            }

            $templater = vB_Template::create('memberinfo_block_photosbit');
            $templater->register('album', $album);
            $albumbits .= $templater->render();
        }

        
$templater = vB_Template::create('memberinfo_block_photos');
$templater->register('selected_tab', $selected_tab);
$templater->register('albumbits', $albumbits);
$template_hook['profile_tabs'] .= $templater->render();

deleted functions just made straigt away plugin work

also removed

this
$hook_query_fields = $hook_query_joins = $hook_query_where = '';
($hook = vBulletinHook::fetch_hook('member_profileblock_alb um_query')) ? eval($hook) : false;

and added the plugin to work in hook

member_profileblock_album_query

so the tab disappeared

????

--------------- Added [DATE]1371391385[/DATE] at [TIME]1371391385[/TIME] ---------------

so far

splitted the plugin into to plugins

once to work in
member_profileblock_album_query

to retrieve all albums

PHP Code:


			
$albums = $this->registry->db->query_read_slave("
            SELECT album.*,
                a.attachmentid, album.moderation,
                fd.thumbnail_dateline, fd.thumbnail_width, fd.thumbnail_height, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail
                $hook_query_fields
            FROM " . TABLE_PREFIX . "album AS album
            LEFT JOIN " . TABLE_PREFIX . "attachment AS a ON (album.coverattachmentid = a.attachmentid)
            LEFT JOIN " . TABLE_PREFIX . "filedata AS fd ON (fd.filedataid = a.filedataid)
            $hook_query_joins
            WHERE
                album.userid = ". $this->profile->userinfo['userid'] . "
                    AND
                album.state IN ('" . implode("', '", $state) . "')
                $sql
                $hook_query_where
            ORDER BY album.lastpicturedate DESC
        ");
        $albumbits = '';
        while ($album = $this->registry->db->fetch_array($albums))
        {
            $album['picturedate'] = vbdate($this->registry->options['dateformat'], $album['lastpicturedate'], true);
            $album['picturetime'] = vbdate($this->registry->options['timeformat'], $album['lastpicturedate']);
            $album['title_html'] = fetch_word_wrapped_string(fetch_censored_text($album['title']));
            $album['coverdimensions'] = ($album['thumbnail_width'] ? "width=\"$album[thumbnail_width]\" height=\"$album[thumbnail_height]\"" : '');

            $templater = vB_Template::create('memberinfo_block_photosbit');
            $templater->register('album', $album);
            $albumbits .= $templater->render();
        }
        
$templater = vB_Template::create('memberinfo_block_photos');
$templater->register('albumbits', $albumbits);

and the second to add the tab that contained the albums

PHP Code:


			
if (isset($vbulletin->GPC['tab']))
{
    $selected_tab = $vbulletin->GPC['tab'];
}
$blockinfo['title'] = "الصور";
$blockid = "photos";
$taburl = $memberurl = fetch_seo_url('member', $prepared) . "&amp;tab=photos#photos";

$templater = vB_Template::create('memberinfo_tab');
$templater->register('selected_tab', $selected_tab);
$templater->register('relpath', $relpath);
$templater->register('blockinfo', $blockinfo);
$templater->register('blockid', $blockid);
$templater->register('taburl', $taburl);
$template_hook['profile_tabs_last'] .= $templater->render();  

// ### Your code to fill the tab ###
// Don't forget you need to register any variables for use in templates 

$templater = vB_Template::create('memberinfo_block_photos');
$templater->register('selected_tab', $selected_tab);
$template_hook['profile_tabs'] .= $templater->render();

which is in hook member_complete

still not displaying the albums????

Lynne · #7 06-16-2013, 03:11 PM

What about the template memberinfo_block_photos ? We need that code also.

When I create that template and just put in the content:

HTML Code:

This is a test.

it shows up for me. So, that means it is something in your php code itself that is making it not work.

Honourable · #8 06-16-2013, 03:32 PM

Here is what I have done

template memberinfo_block_photos

PHP Code:


			
<div id="view-photos" class="<vb:if condition="$selected_tab == 'photos'">selected_view_section<vb:else />view_section</vb:if><vb:if condition="$userinfo['userid'] != $bbuserinfo['userid']"> vm_other_prof</vb:if>">
    <div class="blocksubhead subsectionhead userprof_headers userprof_headers_border">     
        <h4 class="subsectionhead-understate">User albums</h4>
    </div>

<div class="albums">
    <h5 class="blocksubhead smaller">
        <a class="textcontrol" href="album.php?{vb:raw session.sessionurl}do=addalbum">{vb:rawphrase add_album}</a>
        <span class="albums_total">{vb:raw albumcount}</span> {vb:rawphrase albums}
    </h5>
    <div class="blockbody userprof_content userprof_content_border">
        <ul class="albumslist blockrow image_link_list">
            {vb:raw albumbits}
        </ul>
    </div>
</div>

</div>

template memberinfo_block_photosbit

PHP Code:


			
<li class="floatcontainer">
    <div class="albumthumb_container image_container">
    <a class="album_showcase image_bit" href="album.php?{vb:raw session.sessionurl}albumid={vb:raw album.albumid}">
        <vb:if condition="$album['hasthumbnail']">
        <img alt="{vb:raw album.title_html}" class="album_showcase" src="attachment.php?{vb:raw session.sessionurl}attachmentid={vb:raw album.attachmentid}&amp;thumb=1&amp;d={vb:raw album.thumbnail_dateline}"/>
        <vb:else />
        <img alt="{vb:raw album.title_html}" class="album_showcase" src="{vb:stylevar imgdir_misc}/default-album.png"/>
        </vb:if>
    </a>
    </div>
    <div class="album_content row_content">
        <h6>
            <a href="album.php?{vb:raw session.sessionurl}albumid={vb:raw album.albumid}">{vb:raw album.title_html}</a>
            <vb:if condition="$show['moderated']"> <img class="inlineimg" src="{vb:stylevar imgdir_misc}/moderated_small.gif" alt="{vb:rawphrase x_moderated_pictures, {vb:raw album.moderatedcount}}" /></vb:if>
        </h6>
        <vb:if condition="$album['lastpicturedate']">
        <span class="shade">{vb:raw album.picturedate}<vb:if condition="$show['detailedtime']">{vb:raw album.picturetime}</vb:if></span>
        </vb:if>
    </div>
</li>

and each plugin of the two I mentioned above
works with each template

i.e. the plugin with hook member_profileblock_album_query

create the albums bits alltogather which is temaplate memberinfo_block_photosbit

and the plugin member_complete
create the albums whole template which is memberinfo_block_photos that contains
memberinfo_block_photosbit

hope this cleared everything????

Lynne · #9 06-16-2013, 04:23 PM

You are creating the template memberinfo_block_photos in both plugins. In the first one you simply want to preregister the variables for use in that template, not create it also.

I would change $albumbits to $albumbits2 throughout.

Change the id of the tab from photos to photos2 throughout (both plugin and template).

I got it to work with those changes, although it will need some formatting to be done.

Honourable · #10 06-16-2013, 04:30 PM

please give me two mintues and I will update u with results dont log off please!

thank you

--------------- Added [DATE]1371404477[/DATE] at [TIME]1371404477[/TIME] ---------------

Here is what I have done but is not working

created two templates
created two plugins

one template with name memberinfo_block_mpphotos

contains

PHP Code:


			
<div id="view-photos" class="<vb:if condition="$selected_tab == 'mpphotos'">selected_view_section<vb:else />view_section</vb:if><vb:if condition="$userinfo['userid'] != $bbuserinfo['userid']"> vm_other_prof</vb:if>">
    <div class="blocksubhead subsectionhead userprof_headers userprof_headers_border">     
        <h4 class="subsectionhead-understate">User albums</h4>
    </div>

<div class="albums">
    <h5 class="blocksubhead smaller">
        <a class="textcontrol" href="album.php?{vb:raw session.sessionurl}do=addalbum">{vb:rawphrase add_album}</a>
        <span class="albums_total">{vb:raw albumcount}</span> {vb:rawphrase albums}
    </h5>
    <div class="blockbody userprof_content userprof_content_border">
        <ul class="albumslist blockrow image_link_list">
            {vb:raw albumbits2}
        </ul>
    </div>
</div>

</div>

second template with name memberinfo_block_mpphotosbit

contains

PHP Code:


			
<li class="floatcontainer">
    <div class="albumthumb_container image_container">
    <a class="album_showcase image_bit" href="album.php?{vb:raw session.sessionurl}albumid={vb:raw album.albumid}">
        <vb:if condition="$album['hasthumbnail']">
        <img alt="{vb:raw album.title_html}" class="album_showcase" src="attachment.php?{vb:raw session.sessionurl}attachmentid={vb:raw album.attachmentid}&amp;thumb=1&amp;d={vb:raw album.thumbnail_dateline}"/>
        <vb:else />
        <img alt="{vb:raw album.title_html}" class="album_showcase" src="{vb:stylevar imgdir_misc}/default-album.png"/>
        </vb:if>
    </a>
    </div>
    <div class="album_content row_content">
        <h6>
            <a href="album.php?{vb:raw session.sessionurl}albumid={vb:raw album.albumid}">{vb:raw album.title_html}</a>
            <vb:if condition="$show['moderated']"> <img class="inlineimg" src="{vb:stylevar imgdir_misc}/moderated_small.gif" alt="{vb:rawphrase x_moderated_pictures, {vb:raw album.moderatedcount}}" /></vb:if>
        </h6>
        <vb:if condition="$album['lastpicturedate']">
        <span class="shade">{vb:raw album.picturedate}<vb:if condition="$show['detailedtime']">{vb:raw album.picturetime}</vb:if></span>
        </vb:if>
    </div>
</li>

and with the plugins

first plugin with hook position member_profileblock_album_query

contains

PHP Code:


			
$albums = $this->registry->db->query_read_slave("
            SELECT album.*,
                a.attachmentid, album.moderation,
                fd.thumbnail_dateline, fd.thumbnail_width, fd.thumbnail_height, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail
                $hook_query_fields
            FROM " . TABLE_PREFIX . "album AS album
            LEFT JOIN " . TABLE_PREFIX . "attachment AS a ON (album.coverattachmentid = a.attachmentid)
            LEFT JOIN " . TABLE_PREFIX . "filedata AS fd ON (fd.filedataid = a.filedataid)
            $hook_query_joins
            WHERE
                album.userid = ". $this->profile->userinfo['userid'] . "
                    AND
                album.state IN ('" . implode("', '", $state) . "')
                $sql
                $hook_query_where
            ORDER BY album.lastpicturedate DESC
        ");
        $albumbits2 = '';
        while ($album = $this->registry->db->fetch_array($albums))
        {
            $album['picturedate'] = vbdate($this->registry->options['dateformat'], $album['lastpicturedate'], true);
            $album['picturetime'] = vbdate($this->registry->options['timeformat'], $album['lastpicturedate']);
            $album['title_html'] = fetch_word_wrapped_string(fetch_censored_text($album['title']));
            $album['coverdimensions'] = ($album['thumbnail_width'] ? "width=\"$album[thumbnail_width]\" height=\"$album[thumbnail_height]\"" : '');

            $templater = vB_Template::create('memberinfo_block_mpphotosbit');
            $templater->register('album', $album);
            $albumbits2 .= $templater->render();

$templater = vB_Template::create('memberinfo_block_mpphotos');
$templater->register('albumbits2', $albumbits2);  

        }
        
$templater = vB_Template::create('memberinfo_block_mpphotos');
$templater->register('albumbits2', $albumbits2);

second plugin with hook position member_complete

contains

PHP Code:


			
if (isset($vbulletin->GPC['tab']))
{
    $selected_tab = $vbulletin->GPC['tab'];
}
$blockinfo['title'] = "الصور";
$blockid = "mpphotos";
$taburl = $memberurl = fetch_seo_url('member', $prepared) . "&amp;tab=mpphotos#mpphotos";

$templater = vB_Template::create('memberinfo_tab');
$templater->register('selected_tab', $selected_tab);
$templater->register('relpath', $relpath);
$templater->register('blockinfo', $blockinfo);
$templater->register('blockid', $blockid);
$templater->register('taburl', $taburl);
$template_hook['profile_tabs_last'] .= $templater->render();  

// ### Your code to fill the tab ###
// Don't forget you need to register any variables for use in templates 

$templater = vB_Template::create('memberinfo_block_mpphotos');
$templater->register('selected_tab', $selected_tab);
$template_hook['profile_tabs'] .= $templater->render();

is not really working?????

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07882 seconds Memory Usage 2,470KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_html (10)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!