Icy Phoenix

Archived phpBB Topics (Styles, Mods, Support) - FAP CUSTOMIZATION - User Personal Galleries Page Customization

nims [ Thu 12 Jul, 2007 07:59 ]
Post subject: FAP CUSTOMIZATION - User Personal Galleries Page Customization

Hi, Thanks for a superb MOD.

I have seen many forums have customized their users personal galleries page to show thumbnail, latest comment, number of times viewed etc.
The format looks like
User Thumbnail posting date latest comment number of times viewed etc.
I have seen such an album here -http://www.lefty74.com/forum/album.php

Also, I downloaded this MOD from phpbbhacks, so I just wanted to check if my files are ok. My album page doesnt show latest pics, random pics etc. I currently do not have any Public category or pictures, but have few personal user galleries.
Can someone kindly check if it is fine here http://www.newindianmodels.com/forum/album.php

lefty74 [ Thu 12 Jul, 2007 18:14 ]
Post subject: Re: User Personal Galleries Page Customization

looks fine to me, all it needs is a few pictures now

nims [ Fri 13 Jul, 2007 07:13 ]
Post subject: Re: User Personal Galleries Page Customization

Hi lefty

Actually I have removed that MOD now since it did not do anything.
What I want is my users personal galleries page to appear like yours at http://www.lefty74.com/forum/album_personal_index.php

lefty74 [ Fri 13 Jul, 2007 12:34 ]
Post subject: Re: User Personal Galleries Page Customization

I will post my files later if anyone else wants to have them, however, you need to be aware that there may be some code edits that are referring to other mods. I don't have time to go through it to see which ones they are so you will need to check yourself.

nims [ Fri 13 Jul, 2007 13:05 ]
Post subject: Re: User Personal Galleries Page Customization

Will check that, can u be kind enough to point me in the right direction. Which all files do I need to edit and where are the thumbnails being generated (the code) that I can put in the layout.

Also, if u can guide me to put latest thumbnail picture (if the user has created an album and uploaded any pic) in-place of avatar in posts.

lefty74 [ Fri 13 Jul, 2007 17:59 ]
Post subject: Re: User Personal Galleries Page Customization

here it is
I think i cleaned out the code from other mods,
the album_personal_index.php goes into the root folder, the language file in the language folder and the album_personal_index.tpl file in your template folder

I strongly recommend to make a back up of your board and files before doing any changes.

nims [ Sat 14 Jul, 2007 09:59 ]
Post subject: Re: User Personal Galleries Page Customization

Thanks lefty,

I will manage the rest.

Just one more favor ... what if I need to use the thumbnail of the last uploaded picture as avatar or may be I completely remove the avatar option and instead show the thumbnail of recently uploaded picture below the username in the posts on left side. I already have a MOD to put a link to user's personal album below avatar, I just want to replace it with latest thumbnail. Can you guide me a bit which files need to be edited and where is the code for thumbnail.

nims [ Sat 14 Jul, 2007 14:47 ]
Post subject: Re: User Personal Galleries Page Customization

Its not working. I guess I need to have a closer look to rectify the problems.

nims [ Sun 15 Jul, 2007 12:18 ]
Post subject: Re: User Personal Galleries Page Customization

I am getting this error

Code: [Hide] [Select]

SQL error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND p.pic_id = AND ct.cat_view_level IN ('-1','0','1','2','3') ORDER BY p' at line 5

SELECT ct.cat_id, ct.cat_view_level, p.pic_id, p.pic_title, p.pic_desc, p.pic_time FROM phpbb_album AS p LEFT JOIN phpbb_album_cat AS ct ON p.pic_cat_id = ct.cat_id WHERE p.pic_user_id = AND p.pic_id = AND ct.cat_view_level IN ('-1','0','1','2','3') ORDER BY p.pic_id desc LIMIT 1

in file album_personal_index.php

for this query

Code: [Hide] [Select]

$sql = "SELECT ct.cat_id, ct.cat_view_level, p.pic_id, p.pic_title, p.pic_desc, p.pic_time

			FROM ". ALBUM_TABLE ." AS p

					LEFT JOIN ". ALBUM_CAT_TABLE ." AS ct ON p.pic_cat_id = ct.cat_id

			WHERE p.pic_user_id = " . $user_id ."

			AND p.pic_id = " . $memberrow[$i]['last_pic'] . "

			AND ct.cat_view_level IN ($cat_view_level)

			ORDER BY p.pic_id desc

			LIMIT 1

			";

Can you help.

lefty74 [ Sun 15 Jul, 2007 12:59 ]
Post subject: Re: User Personal Galleries Page Customization

strange, if i am not mistaken, it looks like there are no pictures to be found in the personal galleries...

could this be?

lefty74 [ Sun 15 Jul, 2007 20:51 ]
Post subject: Re: User Personal Galleries Page Customization

updated the attachments. now also includes modified album_upload.php file that sets the uploaded file as your avatar by default.

only tested briefly so backup files before trying.!!!

nims [ Mon 16 Jul, 2007 10:34 ]
Post subject: Re: User Personal Galleries Page Customization

Thanks for the files.
I am posting the working files here.

Pete_Z [ Tue 04 Sep, 2007 05:48 ]
Post subject: Re: User Personal Galleries Page Customization

Thanks Lefty and nims. I like the layout.

Fabiomaticus [ Sun 14 Oct, 2007 15:52 ]
Post subject: Re: User Personal Galleries Page Customization

This is my personal gallery list

http://www.500forum.it/member-galleries.html

Why thumb not appaer?

darkone [ Thu 17 Jan, 2008 06:03 ]
Post subject: Re: User Personal Galleries Page Customization

I haven't had time to look at the files but Lefty this mod doesn't work with latest version of ICY.

Any ideas?

lefty74 [ Sun 20 Jan, 2008 18:18 ]
Post subject: Re: User Personal Galleries Page Customization

no ideas, sorry.

i had to delete my site so i converted my board to phpbb3. i lost my album but maybe one day i will be able to reupload and convert them.

Fusione [ Sun 20 Jan, 2008 21:52 ]
Post subject: Re: User Personal Galleries Page Customization

Thank you for this mod! The old page looked too simple and I have been looking fr this type of layout for a long time.

losthillsguy [ Thu 13 Mar, 2008 21:13 ]
Post subject: Re: User Personal Galleries Page Customization

Here is what I have using the above mod by lefty74

Here is what I would like to have... it doesn't need the slideshow link or the text under the category.
I just would like the personal categories listed for each user. Anyone up for taking a look at this?

lefty74 [ Thu 13 Mar, 2008 23:47 ]
Post subject: Re: User Personal Galleries Page Customization

it has been a while since i looked at phpbb2 code.

i jsut quickly did below, there may well be functions etc that need including.
below simply lists the categories that a user has with the description. it does not separate subcats and all that so a. make a backup b. you install this at your own risk
OPEN album_personal_index.php
FIND

Code: [Hide] [Select]

}

$sql = "SELECT COUNT(DISTINCT u.user_id) AS total

		FROM ". USERS_TABLE ." AS u, ". ALBUM_TABLE ." AS p, " . ALBUM_CAT_TABLE . " AS c

		WHERE u.user_id <> ". ANONYMOUS ."

			AND c.cat_user_id = u.user_id

			AND c.cat_id = p.pic_cat_id";

if ( !($result = $db->sql_query($sql)) )

{

BEFORE, ADD

Code: [Hide] [Select]

			$sql = "SELECT cat_id, cat_view_level, cat_title, cat_desc, cat_user_id

			FROM ". ALBUM_CAT_TABLE ." 

			WHERE cat_user_id = " . $user_id ."

			AND cat_parent <> 0

			AND cat_view_level IN ($cat_view_level)

			ORDER BY cat_title

			";

			if( !($result = $db->sql_query($sql)) )

			{

				message_die(GENERAL_ERROR, 'Could not query last pic on profile information', '', __LINE__, __FILE__, $sql);

			}

		while( $row2 = $db->sql_fetchrow($result) )

{

		$row_cat_id = $row2['cat_id'];

		$pers_ind_cat_url = append_sid(album_append_uid("album_cat.$phpEx?cat_id=" . $row_cat_id . "&user_id=" . $user_id));

$template->assign_block_vars('memberrow.cats', array(

		'TITLE' => '<a href="' . $pers_ind_cat_url . '">' . $row2['cat_title'] . '</a>',

		'DESC' => $row2['cat_desc'],

));

}

OPEN album_personal_index_body.tpl
FIND

Code: [Hide] [Select]

		<td class="{memberrow.ROW_CLASS}" align="center">&nbsp;<span class="gen">{memberrow.ALBUM_IMG}</span></td>

REPLACE WITH

Code: [Hide] [Select]

		<td class="{memberrow.ROW_CLASS}" align="left"><span class="genmed"><table><tr><td>

			<!-- BEGIN cats -->

		&nbsp;• ;&nbsp;{memberrow.cats.TITLE}<br/>

		<span class="gensmall">&nbsp;&nbsp;&nbsp;&nbsp;{memberrow.cats.DESC}<br/><br/></span>

		<!-- END cats -->

		</td></tr></table></span></td>

note:  • ; {memberrow.cats.TITLE}<br/> should in the beginning be "  & # 8226 ; " but it makes a • out of the &# 8 226

losthillsguy [ Thu 13 Mar, 2008 23:49 ]
Post subject: Re: User Personal Galleries Page Customization

Hey Thanks

I can handle the first part of the instructions. But I'm not sure about this...

note:  • ; {memberrow.cats.TITLE}<br/> should in the beginning be "  & # 8226 ; " but it makes a • out of the &# 8 226

lefty74 [ Thu 13 Mar, 2008 23:52 ]
Post subject: Re: User Personal Galleries Page Customization

sorry, wasnt quite sure how to write this

 • ;  you will need to write the html code for the • which is 8226

losthillsguy [ Thu 13 Mar, 2008 23:57 ]
Post subject: Re: User Personal Galleries Page Customization

Let me try that again.

•

lefty74 [ Fri 14 Mar, 2008 00:05 ]
Post subject: Re: User Personal Galleries Page Customization

yeah almost,
http://www.w3.org/TR/html401/sgml/entities.html#h-24.2.1
it is not just 8226 but if i put the code in here it makes an icon out of it.
have a look at the link and search for 8226, that will show you the code you need to use

losthillsguy [ Fri 14 Mar, 2008 00:22 ]
Post subject: Re: User Personal Galleries Page Customization

lefty74. you are a very generous person and much good will come your way!

Check it out!!
http://356registry.com/forum/album_personal_index.php

One thing and it will be perfect. Can i make the font smaller that lists the categories?

lefty74 [ Fri 14 Mar, 2008 00:38 ]
Post subject: Re: User Personal Galleries Page Customization

try this

OPEN album_personal_index_body.tpl
FIND

Code: [Hide] [Select]

        <td class="{memberrow.ROW_CLASS}" align="left"><span class="genmed"><table><tr><td>

            <!-- BEGIN cats -->

        &nbsp;• ;&nbsp;{memberrow.cats.TITLE}<br/>

        <span class="gensmall">&nbsp;&nbsp;&nbsp;&nbsp;{memberrow.cats.DESC}<br/><br/></span>

        <!-- END cats -->

        </td></tr></table></span></td>

REPLACE WITH

Code: [Hide] [Select]

        <td class="{memberrow.ROW_CLASS}" align="left"><table><tr><td>

            <!-- BEGIN cats -->

        <span class="genmed">&nbsp;• ;&nbsp;{memberrow.cats.TITLE}</span><br/>

        <span class="gensmall">&nbsp;&nbsp;&nbsp;&nbsp;{memberrow.cats.DESC}<br/><br/></span>

        <!-- END cats -->

        </td></tr></table></td>

losthillsguy [ Fri 14 Mar, 2008 00:49 ]
Post subject: Re: User Personal Galleries Page Customization

Thanks a bunch. I will play with it a bit now. I like the avatar and the last photo posted thumbnail.

But if we get about 100 or 200 cars listed we'll want to make the rows shorter. I think eliminating the avatar and thumbnail will do that.

I can play with the code to eliminate those.

losthillsguy [ Thu 03 Apr, 2008 21:04 ]
Post subject: Re: User Personal Galleries Page Customization

OK Lefty, one more challenge I'm facing. I made the updated changes and now have a really good looking Personal Gallery Index.

One flaw is if someone has photos in their gallery WITHOUT creating a sub category there is no link. So I guess on the link column it needs a link to their gallery without categories similar to the original personal index in FAP.

In the example Omar #3 has 4 photos posted but no link available. I used the code in the above posts to make the mods to this gallery index.

losthillsguy [ Fri 04 Apr, 2008 06:00 ]
Post subject: Re: User Personal Galleries Page Customization

Never mind, with a little trial and error I got it to work. Thanks!

lefty74 [ Sat 05 Apr, 2008 16:26 ]
Post subject: Re: User Personal Galleries Page Customization

great