The vB Geek

Go Back   The vB Geek > vB Geek Commons > Lizard Lounge

Lizard Lounge The place to post off topic stuff.

Advertisement
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #21  
Old 10-14-2006, 11:38 AM
Lizard King's Avatar
Lizard King Lizard King is offline
Senior Member
 
Join Date: Oct 2005
Location: Istanbul
Posts: 555
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

In that case there is a easy fix for you. As i don't know photopost table structure you shall modify the following query in geek-gallery-popup.php

Code:
	$pages = $db->query_first("SELECT count(id) total FROM $gallery_db" . $pp_prefix . "photos WHERE userid=$userid ");
    require_once('./includes/functions.php');
	$navigation = construct_page_nav($page, $perpage, $pages['total'], "geek-gallery-popup.php?" . $vbulletin->session->vars['sessionurl'] . "&catid=" . $catid . "&ed=" . $ed);
    $start = ($page-1) * $perpage;
    $query="SELECT
        images.id AS imageid,images.cat,c.catname AS cattitle,'' AS extention,images.title,
        images.bigimage AS filename,images.medsize,images.width owidth, images.height oheight,images.medwidth width,images.medheight height
        FROM $gallery_db" . $pp_prefix . "photos AS images
        INNER JOIN $gallery_db" .  $pp_prefix . "categories AS c on images.cat=c.id
        WHERE images.userid=$userid and images.approved=1 ORDER BY images.date DESC LIMIT $start ," . ($perpage);

but this may work

Code:
	$pages = $db->query_first("SELECT count(id) total FROM ppgal_photos WHERE userid=$userid ");
    require_once('./includes/functions.php');
	$navigation = construct_page_nav($page, $perpage, $pages['total'], "geek-gallery-popup.php?" . $vbulletin->session->vars['sessionurl'] . "&catid=" . $catid . "&ed=" . $ed);
    $start = ($page-1) * $perpage;
    $query="SELECT
        images.id AS imageid,images.cat,c.catname AS cattitle,'' AS extention,images.title,
        images.bigimage AS filename,images.medsize,images.width owidth, images.height oheight,images.medwidth width,images.medheight height
        FROM ppgal_photos AS images
        INNER JOIN ppgal_categories AS c on images.cat=c.id
        WHERE images.userid=$userid and images.approved=1 ORDER BY images.date DESC LIMIT $start ," . ($perpage);
Reply With Quote
  #22  
Old 10-24-2006, 01:52 PM
Lizard King's Avatar
Lizard King Lizard King is offline
Senior Member
 
Join Date: Oct 2005
Location: Istanbul
Posts: 555
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

I had the same problem with the new gallery so i modified the hack a little bit to work with the new one.

If you receive any database error for geek gallery popup download and install the following one.
Attached Files
File Type: zip geek-gallery-popup.zip (3.3 KB, 23 views)
Reply With Quote
  #23  
Old 10-31-2006, 02:58 AM
vissa vissa is offline
Junior Member
 
Join Date: Oct 2006
Posts: 1
Default

I do know that vbagallaery changed every single table when they upgraded to 2.0. That could be the problem. They did it primarily for marketing reasons to remove the old gallery titles from the table names. It broke a lot of other plug-ins, but shouldn't be too hard to fix.

-vissa
Reply With Quote
  #24  
Old 11-01-2006, 05:01 AM
kihon kata kihon kata is offline
Member
 
Join Date: Sep 2005
Posts: 38
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder 
Default

Quote:
Originally Posted by Lizard King
In that case there is a easy fix for you. As i don't know photopost table structure you shall modify the following query in geek-gallery-popup.php

Code:
	$pages = $db->query_first("SELECT count(id) total FROM $gallery_db" . $pp_prefix . "photos WHERE userid=$userid ");
    require_once('./includes/functions.php');
	$navigation = construct_page_nav($page, $perpage, $pages['total'], "geek-gallery-popup.php?" . $vbulletin->session->vars['sessionurl'] . "&catid=" . $catid . "&ed=" . $ed);
    $start = ($page-1) * $perpage;
    $query="SELECT
        images.id AS imageid,images.cat,c.catname AS cattitle,'' AS extention,images.title,
        images.bigimage AS filename,images.medsize,images.width owidth, images.height oheight,images.medwidth width,images.medheight height
        FROM $gallery_db" . $pp_prefix . "photos AS images
        INNER JOIN $gallery_db" .  $pp_prefix . "categories AS c on images.cat=c.id
        WHERE images.userid=$userid and images.approved=1 ORDER BY images.date DESC LIMIT $start ," . ($perpage);

but this may work

Code:
	$pages = $db->query_first("SELECT count(id) total FROM ppgal_photos WHERE userid=$userid ");
    require_once('./includes/functions.php');
	$navigation = construct_page_nav($page, $perpage, $pages['total'], "geek-gallery-popup.php?" . $vbulletin->session->vars['sessionurl'] . "&catid=" . $catid . "&ed=" . $ed);
    $start = ($page-1) * $perpage;
    $query="SELECT
        images.id AS imageid,images.cat,c.catname AS cattitle,'' AS extention,images.title,
        images.bigimage AS filename,images.medsize,images.width owidth, images.height oheight,images.medwidth width,images.medheight height
        FROM ppgal_photos AS images
        INNER JOIN ppgal_categories AS c on images.cat=c.id
        WHERE images.userid=$userid and images.approved=1 ORDER BY images.date DESC LIMIT $start ," . ($perpage);



I tried this fix and this is what I get:
Quote:
Database error in vBulletin 3.6.2:

Invalid SQL:
SELECT count(id) total FROM ppgal_photos WHERE userid=4;

MySQL Error : Table 'makeuptalk.ppgal_photos' doesn't exist
Error Number : 1146
Date : Tuesday, October 31st 2006 @ 08:58:50 PM
Script : http://www.makeuptalk.com/forums/gee...=vB_Editor_001
Referrer : http://www.makeuptalk.com/forums/new...newthread&f=15
IP Address :
Username :
Classname : vB_Database
Looks like it's still trying to attach the first name makeuptalk
Reply With Quote
  #25  
Old 11-01-2006, 10:06 AM
Lizard King's Avatar
Lizard King Lizard King is offline
Senior Member
 
Join Date: Oct 2005
Location: Istanbul
Posts: 555
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

Did you check this post http://www.thevbgeek.com/showpost.ph...7&postcount=22
Reply With Quote
  #26  
Old 11-01-2006, 01:27 PM
kihon kata kihon kata is offline
Member
 
Join Date: Sep 2005
Posts: 38
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder 
Default

Quote:
Originally Posted by Lizard King
Yes, still DB error.
Reply With Quote
  #27  
Old 11-02-2006, 07:37 AM
Lizard King's Avatar
Lizard King Lizard King is offline
Senior Member
 
Join Date: Oct 2005
Location: Istanbul
Posts: 555
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

Quote:
Originally Posted by kihon kata
Yes, still DB error.
What error do you still get and what is your current settings. The second file is working perfect with me.
Reply With Quote
  #28  
Old 11-08-2006, 07:02 AM
cellarius's Avatar
cellarius cellarius is offline
Junior Member
 
Join Date: Dec 2005
Posts: 20
Geek Auto-Linker Pro License Holder 
Default Works perfectly with 3.6.2

Hi there,

just installed Photopost 5.5 and the Popup - really works like a charm and out of the box. No errors whatsoever.

Sven
Reply With Quote
  #29  
Old 11-13-2006, 07:05 PM
LBmtb LBmtb is offline
Junior Member
 
Join Date: Jan 2006
Posts: 3
Geek Article and Review System License Holder 
Default

I have the same problem that this person does. Also . . . instead of using the small thumbnails, can there be an option to insert a clickable medium sized image which links to the large size? That would be awesome. I can pitch in 20 bucks via paypal if it'd help?

Thanks!
Reply With Quote
  #30  
Old 11-14-2006, 04:44 PM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

This vb.org release is totally unsupported and as much as I dig it, I cant spend any time on its development. I may PM Michael about it and see if they want to redev it for their products.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Video Gallery nfn Geek Article and Review System 2 07-23-2008 03:53 AM
Delay popup. Popup without link ult1lar Geek Auto-Linker 3 02-27-2008 03:03 PM
Geek Gallery Popup for PhotoPost htscpl Lizard Lounge 1 01-10-2006 10:23 AM
Geek Gallery? James Goddard Geek Article and Review System 9 01-08-2006 12:43 AM
idea: auto-create avatar w/ geek gallery popup yoyo Lizard Lounge 1 08-27-2005 08:15 AM


All times are GMT. The time now is 01:31 AM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.