Forum Home Enhancements - New Latest Album Pictures - Forum Home

NEW Latest Album Pictures - Forum Home

It shows the pictures added to the albums on the main page. It shows only the public mentioned files. If not shows the reasons are: vbulletin settings show albums must be enabled.

The user grup that owns the pictures must be enabled show picture setting. Or there is no picture to show.

Additionally you can slect the number of pictures that can be shown.

Hope it works for you as I like it very much.

install

Go to your admin cp, then:
Plugin System -> Manage Products -> [Add/Import Product] -> Select 'product-newalbum.xml' from your computer then press 'Import'

Modifications Info

Plugin : 2
Phrases : 9
Template : 2
Setting : 3
Query : 1 Query

Latest Posts Setting

Go to your admin cp, then:
vBulletin Options -> New Album Picture ->

Versions:
v1.0 -First release

[8thos]

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?

[Goonie]

how do i change the background colour so it matches my style?

[paarmis.queen]

tnx installed

[spider62]

Up !

Hi, how to display the photos on several lines? thank you

[Cicada]

this happened to mine today -- what could be the cause?

http://img232.imageshack.us/img232/7113/oopsf.jpg

[MrBig]

Originally Posted by Cicada

this happened to mine today -- what could be the cause?

http://img232.imageshack.us/img232/7113/oopsf.jpg

did you upgrade you forum? i upgraded my forum to 4.08 and it just went nuts

[Cicada]

Originally Posted by MrBig

did you upgrade you forum? i upgraded my forum to 4.08 and it just went nuts

i havent upgraded to 4.0.8 yet, i'm scheduling that for this weekend.

i _did_ play with image thumbnail settings and upload settings, but i rebuit my thumbnails [after changing the settings back] , and it's still showing the full-sized images

[The Coon]

Provisional arrangement after upgrading to 4.0.8:

Change template: newalbum_print

Search:

PHP Code:

<h3> 


Replace with:

PHP Code:

<h3 class="blocksubhead"> 


[MrBig]

Originally Posted by jacko_162

edit template: newalbum_picture

replace all with:

<td align="center">	
		<a class="picture" href="album.php?albumid={vb:raw lpicture.albumid}&amp;attachmentid={vb:raw lpicture.attachmentid}"><img  src="attachment.php?attachmentid={vb:raw lpicture.attachmentid}&amp;thumb=1&amp;d=1258906442" alt="Image uploaded by: {vb:raw lpicture.musername}" border="0" /></a>
<br />
<a href="member.php?u={vb:raw lpicture.userid}">{vb:raw lpicture.musername}</a> 
<br />
{vb:raw lpicture.title}
</td>

will give you a little more "tool tip" info.

nice!

[ivanp]

SQL query is very slow, should be optimized:

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)