https://www.icyphoenix.com/viewtopic.php?f=26&t=2457 ----------------------------------- nims Thu 12 Jul, 2007 07:59 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 Re: User Personal Galleries Page Customization ----------------------------------- looks fine to me, all it needs is a few pictures now :D ----------------------------------- nims Fri 13 Jul, 2007 07:13 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 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 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 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 [b]I strongly recommend to make a back up of your board and files before doing any changes. [/b] ----------------------------------- nims Sat 14 Jul, 2007 09:59 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 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 Re: User Personal Galleries Page Customization ----------------------------------- I am getting this error [code linenumbers=false]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 [/code] in file [b]album_personal_index.php[/b] for this query [code linenumbers=false]$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 ";[/code] Can you help. ----------------------------------- lefty74 Sun 15 Jul, 2007 12:59 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 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 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 Re: User Personal Galleries Page Customization ----------------------------------- Thanks Lefty and nims. I like the layout. 8) ----------------------------------- Fabiomaticus Sun 14 Oct, 2007 15:52 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 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 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 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 Re: User Personal Galleries Page Customization ----------------------------------- Here is what I have using the above mod by lefty74 [img]http://www.icyphoenix.com/files/images/3543/albumindex1.jpg[/img] 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? [img]http://www.icyphoenix.com/files/images/3543/albumindex2.jpg[/img] ----------------------------------- lefty74 Thu 13 Mar, 2008 23:47 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 [b]album_personal_index.php[/b] FIND [codeblock]} $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)) ) { [/codeblock] BEFORE, ADD [codeblock] $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' => '' . $row2['cat_title'] . '', 'DESC' => $row2['cat_desc'], )); } [/codeblock] OPEN [b]album_personal_index_body.tpl[/b] FIND [codeblock]  {memberrow.ALBUM_IMG}[/codeblock] REPLACE WITH [codeblock]
 • ; {memberrow.cats.TITLE}
    {memberrow.cats.DESC}
[/codeblock] note:  • ; {memberrow.cats.TITLE}
should in the beginning be "  & # 8226 ; " but it makes a • out of the &# 8 226 ----------------------------------- losthillsguy Thu 13 Mar, 2008 23:49 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}
should in the beginning be "  & # 8226 ; " but it makes a • out of the &# 8 226 ----------------------------------- lefty74 Thu 13 Mar, 2008 23:52 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 Re: User Personal Galleries Page Customization ----------------------------------- Let me try that again. :oops: • ----------------------------------- lefty74 Fri 14 Mar, 2008 00:05 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 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 Re: User Personal Galleries Page Customization ----------------------------------- try this OPEN [b]album_personal_index_body.tpl [/b] FIND [codeblock]
 • ; {memberrow.cats.TITLE}
    {memberrow.cats.DESC}
[/codeblock] REPLACE WITH [codeblock]
 • ; {memberrow.cats.TITLE}
    {memberrow.cats.DESC}
[/codeblock] ----------------------------------- losthillsguy Fri 14 Mar, 2008 00:49 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. :D ----------------------------------- losthillsguy Thu 03 Apr, 2008 21:04 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. [img]http://www.icyphoenix.com/files/images/3543/albumindex3.jpg[/img] ----------------------------------- losthillsguy Fri 04 Apr, 2008 06:00 Re: User Personal Galleries Page Customization ----------------------------------- Never mind, with a little trial and error I got it to work. Thanks! [img]http://www.icyphoenix.com/files/images/3543/albumindex4.jpg[/img] ----------------------------------- lefty74 Sat 05 Apr, 2008 16:26 Re: User Personal Galleries Page Customization ----------------------------------- great :up: