vb.org Archive - Geek Gallery Popup 4.0

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

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Geek Gallery Popup 4.0 (https://vborg.vbsupport.ru/showthread.php?t=99011)

Try this fix:

In geek-gallery-popup.php

Find

Code:

require_once('gallery_global.php');

Replace with

Code:

$categorycache =& $vbulletin->gallery_c_cache;

That does not fix the problem for me

Then I don't know what your issue is. A white page suggests that something is wrong - check your php error logs, perhaps?

Perhaps try a test board and downgrade to 2.2.

It's frustrating that the Geek won't support this hack which is one of the most important ones for our boards.

Quote:

Originally Posted by cellarius (Post 1199055)

Hot fix, quick and dirty:

in geek-gallery-popup.php in/around line 219 replace

PHP Code:


		
			
$pages = $db->query_first("SELECT count(id) total FROM $gallery_db" . $pp_prefix . "photos WHERE userid=$userid ");

with

PHP Code:


		
			
$pages = $db->query_first("SELECT count(id) total FROM $gallery_db" . $pp_prefix . "photos WHERE userid=$userid and storeid=0 ");

and in/around line 228 replace

PHP Code:


		
			
WHERE images.userid=$userid and images.approved=1 ORDER BY images.date DESC LIMIT $start ," . ($perpage);

with

PHP Code:


		
			
WHERE images.userid=$userid and images.approved=1 and images.storeid=0 ORDER BY images.date DESC LIMIT $start ," . ($perpage);

No guarantee whatsoever, works well for me.

HTH,
cellarius

I've gotten this to work somewhat with vBGallery v2.3 and vB3.6.8 by downloading jluerken provided geek-gallery-popup.php. Since I use vBGallery the above mod didn't work so I just followed your idea for the "vba" queries, which it's similar to what you did by default.

I replaced:

Code:

WHERE images.userid=$userid and extension in ($media_ext) $catwhere ORDER BY dateline DESC LIMIT $start ," . $perpage ;

With:

Code:

WHERE images.userid=$userid and images.catid=$catid and extension in ($media_ext) $catwhere ORDER BY dateline DESC LIMIT $start ," . $perpage ;

In which the and images.catid=VALUE did no really matter what I put there.

In my gallery I only have one main category and the rest is all sub-cats which works fine with what I added to the code since I hard coded in the popup options?data dir to /files/1 cause I can't get the code to count the different dirs within it. So if you have multiple Main Cats this would problem still show up with images as they weren't there since it's looking in the wrong dir.

Does anyone have a fix for this? Everything else works fine ;)

I hope the above makes since! :P

Photopost and VB in Different Directories and In Different Databases
So Different database usernames and passwords

Hello,

Wow what a super mess this whole thread is!

I have photopost and vbulletin installed in two different directories and in two different databases. So how do I hard code in my photopost database username and password. Right now I get an error that says:

MySQL Error : Access denied for user: 'dbo193309201@%' to database 'dbo193075408'

It is using my VB database username trying to connect to my photopost database!

So to be real clear where can I add in my correct photopost database info and how!?

Quote:

Originally Posted by mindbuster (Post 1119160)

For those who are using photopost vBGallery, and not the ordinary photopost, you can edit the geek_gallery_popup.php file and rename the tables, any occurance of "adv_gallery_whatever" should be changed to "ppgal_whatever", that makes geek_popup work with vB3.6, i just went through it, works fine.
Just a hint :)

YES!! That worked, thanks, don't know what I would do without this hack, and I need LOTSA hints ;) LOL
Clicks Installed for vb3.6.8 running PhotoPost vBGallery v2.3 AND CMPS3.0 - ~yahoooooo~

Note: Make sure you change adv_gallery not just adv_, which is how I screwed this fix up the first time....

Can someone please upload the file which is working with v 3.6.8?
This would help also all others without the need to modify the file by themself!

Quote:

Originally Posted by jluerken (Post 1328718)

Can someone please upload the file which is working with v 3.6.8?
This would help also all others without the need to modify the file by themself!

This one is working fine for me with the exception of the clinch mentioned on my post above!

Quote:

Originally Posted by gldtn (Post 1319807)

In my gallery I only have one main category and the rest is all sub-cats which works fine with what I added to the code since I hard coded in the popup options?data dir to /files/1 cause I can't get the code to count the different dirs within it. So if you have multiple Main Cats this would problem still show up with images as they weren't there since it's looking in the wrong dir.

Does anyone have a fix for this? Everything else works fine ;)

I am not sure if this will help, I have a new forum set-up and only a few pictures. BUT, I used the Geek Gallery pop-up before and compared files.

Around line 177 the following was commented it out:

Code:

$folderstring .= '/' . $uid;

I just removed the comment and my categories worked fine.

I hope this helps.

PS: VB 3.68 & vBa 2.3

Still working fine for us with the fix mentioned above

https://vborg.vbsupport.ru/showpost....&postcount=202

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 (5)bbcode_code_printable (4)bbcode_php_printable (4)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.01376 seconds Memory Usage 1,759KB 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 (5)bbcode_code_printable (4)bbcode_php_printable (4)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: