vb.org Archive - Forum Home Enhancements - New Latest Album Pictures

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Forum Home Enhancements - New Latest Album Pictures - Forum Home (https://vborg.vbsupport.ru/showthread.php?t=228618)

Quote:

Originally Posted by Octavius. (Post 2110520)

Where the hell is 'Show Albums' at? I don't even see it. Only registered members can view albums. I want guests to be able to view the random pictures, but not be able to bring up any licks if they click on them. How do I set that up?

I want to know that, too.

Quote:

Originally Posted by ivanp (Post 2117574)

SQL query is very slow, should be optimized:

Code:

mysql> explain SELECT albumpicture.*, album.*, user.username, user.usergroupid,

    ->   IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

    ->   FROM attachment AS albumpicture

    ->   LEFT JOIN album AS album ON(album.albumid = albumpicture.contentid)

    ->   LEFT JOIN user AS user ON(user.userid = album.userid)

    ->   WHERE album.state = 'public' and albumpicture.contenttypeid = 8

    ->   ORDER BY dateline DESC LIMIT 0, 5;



+----+-------------+--------------+--------+--------------------------------------+-----------+---------+---------------------+------+----------------------------------------------+

| id | select_type | table        | type   | possible_keys                        | key       | key_len | ref                 | rows | Extra                                        |

+----+-------------+--------------+--------+--------------------------------------+-----------+---------+---------------------+------+----------------------------------------------+

|  1 | SIMPLE      | album        | ALL    | PRIMARY                              | NULL      | NULL    | NULL                | 4929 | Using where; Using temporary; Using filesort |

|  1 | SIMPLE      | albumpicture | ref    | contentid,contenttypeid              | contentid | 4       | forum.album.albumid |    3 | Using where                                  |

|  1 | SIMPLE      | user         | eq_ref | PRIMARY                              | PRIMARY   | 4       | forum.album.userid  |    1 |                                              |

+----+-------------+--------------+--------+--------------------------------------+-----------+---------+---------------------+------+----------------------------------------------+

3 rows in set (0.00 sec)

I'm in Admin Control Panel. I clicked on Execute SQL Query. I copy-n-pasted that code, nothing happened but an error.

Quote:

Originally Posted by Octavius. (Post 2118146)

I'm in Admin Control Panel. I clicked on Execute SQL Query. I copy-n-pasted that code, nothing happened but an error.

This was a remark for author of this add-on. There is nothing to do with it in Admin Panel.

Quote:

Originally Posted by MikesSite (Post 1919226)

Looks good, can't wait for some more options! Also want to be able to move this below the navbar.

Yes. Just like the 3.8 one.

Quote:

Originally Posted by The Coon (Post 2113186)

Provisional arrangement after upgrading to 4.0.8:

Change template: newalbum_print

Search:

PHP Code:


		
			
<h3>

Replace with:

PHP Code:


		
			
<h3 class="blocksubhead">

In this way, not ok..

Replace newalbum_print with this.
This works on our site. Note the new vBullentin class "wgo_subblock section" and "h3 class blocksubhead".

PHP Code:


		
			
<div id="wgo_onlineusers" class="wgo_subblock section">

                <h3 class="blocksubhead"><img src="{vb:stylevar imgdir_misc}/users_online.png" alt="{vb:rawphrase currently_active_users}" />{vb:raw resimlery}</h3>

                <div align="center">

<table cellpadding="4" cellspacing="0" border="0" width="100%" align="center">

<tr>

{vb:raw resimler}

</tr>

</table>



                </div>

            </div>

Quote:

Originally Posted by bjarne2 (Post 2125264)

Replace newalbum_print with this.
This works on our site. Note the new vBullentin class "wgo_subblock section" and "h3 class blocksubhead".

PHP Code:


		
			
<div id="wgo_onlineusers" class="wgo_subblock section">

                <h3 class="blocksubhead"><img src="{vb:stylevar imgdir_misc}/users_online.png" alt="{vb:rawphrase currently_active_users}" />{vb:raw resimlery}</h3>

                <div align="center">

<table cellpadding="4" cellspacing="0" border="0" width="100%" align="center">

<tr>

{vb:raw resimler}

</tr>

</table>



                </div>

            </div>

Thank's but not ok again...
Help me

Valerio

Quote:

Originally Posted by PinoyRepublic (Post 1957066)

i manage to move it on different location (any location you prefer). Here's how:

1. Goto to plugin manager then search for "New Album Picture Forum Home" there are two result select the one under "forumhome_start" hook.

2. Scroll down thru the php code and find this line

PHP Code:


		
			
$template_hook['forumhome_wgo_pos1'] .= $templater->render();

then replace it with this

PHP Code:


		
			
//$template_hook['forumhome_wgo_pos1'] .= $templater->render();
$ad_location['ad_navbar_below'] .= $templater->render();

then save it.

The above code means that instead of showing the album under whats going on it will now be shown under the position of the advertisement position below the navigation bar. :)

Thanks, this works great on 4.0.8 PL2

Quote:

Originally Posted by Derapata (Post 2125295)

Thank's but not ok again...
Help me

Valerio

News??

The picture view extra whidt e height.

Help me
Thank
Valerio

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (6)bbcode_php_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01624 seconds Memory Usage 1,771KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (6)bbcode_php_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: