vb.org Archive - vB3 Member Album 2.0

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

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - vB3 Member Album 2.0 (https://vborg.vbsupport.ru/showthread.php?t=63733)

Okay, I think I'm too stupid to understand the hack...
Now the right pictures are shown in admincp but only with 100 Pixel instead of 200. Also in album.php the pictures are still 100 pixel...

Quote:

Originally Posted by Onkel_Tom

Okay, I think I'm too stupid to understand the hack...
Now the right pictures are shown in admincp but only with 100 Pixel instead of 200. Also in album.php the pictures are still 100 pixel...

Hello Onkel_Tom,

just a question. This hack is for version 3.0.0 from VBulletin. Your board is running 2.3.5 ( yes, i just registered there ;-) ). Are you in the process of upgrading ?

If not, there is a version for 2.3.x VBs out.

How long does it take until a member gets full status on your site ?

Cheers,

I have more than one board ;)
It depends on the admins how long the activation needs, I will have a look in 2 Minutes...
The board for the Hack is a vB3.0.1 !

Quote:

Originally Posted by Onkel_Tom

I have more than one board ;)
It depends on the admins how long the activation needs, I will have a look in 2 Minutes...
The board for the Hack is a vB3.0.1 !

Oh. Ok. Do you have ICQ ? It would make this much more easier. My number is in my profile.

Cheers,

I am attaching a file with 3 minor add-ons for anyone interested.

Included:

1. Ties the album viewing permissions to the memberlist viewing permissions
2. Adds the ability to add/update the photo with a comment in the Admin CP
3. Adds the ability to add/update the photo with a comment in the Mod CP

Thanks again, Velocd -- my members LOVE the album!!

Quote:

Originally Posted by Pseudomizer

Now i will add a link to my menu, but after reading your second answer with the permissions how about addind this to the memberlist as a pop-up like the search button ?

I really liked this idea, as adding the donations link for subscriptions is making Navbar a bit crowded.

Attached is a template mod for Navbar that will put the Memberlist and Velocd's album into a dropdown menu like QuickLinks is, with a fallback for those who can't view the JS.

:)

Quote:

Originally Posted by Christine

What goes into the phrases? You have the titles for the phrases, but no content. ;)

Quote:

Originally Posted by Boofo

What goes into the phrases? You have the titles for the phrases, but no content. ;)

members and members_list are already there -- the only one that needs to be added is photo_album, unless I missed something, and if so, please let me know which ones!!

Quote:

Originally Posted by Christine

members and members_list are already there -- the only one that needs to be added is photo_album, unless I missed something, and if so, please let me know which ones!!

You're right, my bad. I didn't look at it close enough. You didn't have Type, Varnme or Text there, it threw me off. Sorry about that. ;)

Installing on 3.0.1 and receive this error in albumcp.php?do=approve

Code:

Invalid SQL: 

                SELECT customprofilepic.*, user.username 

                FROM vb3_customprofilepic 

                LEFT JOIN vb3_user 

                USING (userid) 

                ORDER BY visible, username

        

mysql error: Unknown table 'customprofilepic'



mysql error number: 1051

This corresponds to line 56 of albumcp.php so for gits and shiggles I tried:

Code:

SELECT " . TABLE_PREFIX . "customprofilepic.*, " . TABLE_PREFIX . "user.username

...and it worked, except I got broken images in the ACP exactly like Bofoo was getting, and the MySQL 1064 error on album.php Calvin got.

Now you say ACP -> vB3 Member Photo -> Settings (which is actually 'Options') is the key, so I set entries per page from 18 to 12. Making progress. Now I get this error on album.php:

Code:

Invalid SQL: 

                SELECT user.userid, dateline, 

                comment, user.username, user.usertitle, 

                user.joindate, user.usergroupid

                FROM vb3_customprofilepic 

                LEFT JOIN vb3_user USING (userid) 

                WHERE visible=1

                 

                ORDER BY posts desc

                LIMIT 0, 12

        

mysql error: Unknown table 'user' in field list



mysql error number: 1109

Yet another table prefixing issue, right? This around line 193 in album.php, so now I have:

Code:

        $images = $DB_site->query("

                SELECT ".TABLE_PREFIX."user.userid, dateline, 

                comment, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usertitle, 

                ".TABLE_PREFIX."user.joindate, ".TABLE_PREFIX."user.usergroupid

                FROM ".TABLE_PREFIX."customprofilepic 

                LEFT JOIN ".TABLE_PREFIX."user USING (userid) 

                WHERE visible=1

Now it appears to be working. Beginning to look like you need to update a couple of files in your zip though.

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 (4)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)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.01688 seconds Memory Usage 1,750KB 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 (4)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)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: