vb.org Archive
Page 10 of 25 « First 89 10 111220 Last »
Show 40 post(s) from this thread on one page

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)

FASherman 11-08-2005 07:57 PM
To everyone getting an error like this:

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT count(id) total FROM [database].photos WHERE userid=[uid];

MySQL Error : Table '[database].photos' doesn't exist
Error Number : 1146
Date : Friday, November 4th 2005 @ 12:56:25 PM
Script : http://www.yoursite.com/forums/g...d=vB_Editor_001
Referrer :
Classname : vb_database

Do this...

FIND
PHP Code:
$pages = $db->query_first("SELECT count(id) total FROM $gallery_db" . $photo_prefix . "photos WHERE userid=$userid "); 
AND REPLACE WITH:
PHP Code:
$pages = $db->query_first("SELECT count(id) total FROM $gallery_db" . $pp_prefix . "photos WHERE userid=$userid "); 
I'm still looking to see what the problem is with the page links.

EDIT...

Okay, found it.

FIND:
PHP Code:
    $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); 
ADD BEFORE IT:
PHP Code:
$start = ($page-1) * $perpage; 
That should fix the URL problem.

FASherman 11-08-2005 08:07 PM
That only leaves the issue with the image being inserted in the header when the editor looses focus.

The Geek 11-08-2005 08:22 PM
You rock man! Ive just been working on this (tough to do when I dont have PP anymore!) This has saved me loads of time for the PP users.

Thanks again! Ill test and update the package.

FASherman 11-08-2005 08:30 PM
Quote:
Originally Posted by The Geek
You rock man! Ive just been working on this (tough to do when I dont have PP anymore!) This has saved me loads of time for the PP users.

Thanks again! Ill test and update the package.
You're the one coming up with the killer hacks. I just fixed a few minor things. Hardly worth mentioning.

j.kramer 11-08-2005 09:23 PM
Hi All,

Everything works good untill I start a new thread and try to insert images they all appear on top of site instead of message box.
When just reply to a thread everything works fine!!

Anybody know what could cause this problem?

Geek you already got access to my site so maybe you could also take a look at that one while your at it ;-)

FASherman 11-08-2005 09:29 PM
I can explain the problem. When you start a new thread or even a blank reply, you need to activate the cursor in the editor to give the editor focus, then click on the link for your pictures.

If you just hit the new thread or reply button and then the pic link after the page loads, the editor never has focus so the insert is being done in the document root, which is the page itself.

Note to TheGeek...

I'm sure the answer is in the smilie code. If you take and make a reply, click in the title box and then click on a smilie, focus is returned to the editor and the smilie is inserted in the first character position. That should for your hack too.

j.kramer 11-08-2005 09:36 PM
FASherman that's what happens indeed, so that's why I thought a reply on thread worked because I already focused cursor.

The Geek 11-08-2005 09:44 PM
Package update (thanks Fasherman).

The only outstanding issue I know of now is when the image gets dumped into the page instead of the editor.

Talisman 11-09-2005 01:53 AM
Oh this is really nice.... Thanks so much!

GrendelKhan{TSU 11-10-2005 02:16 AM
I get this error:

Quote:
Warning: main(./global.php): failed to open stream: No such file or directory in /home/XXXXMYDBXXX/public_html/forums/gallery/geek-gallery-popup.php on line 43

Fatal error: main(): Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/XXXMYDBXXXX/public_html/forums/gallery/geek-gallery-popup.php on line 43
this only is when replying to an image in vbaGALLERY itself.

anyone else get this? or does it work for everyone else?


All times are GMT. The time now is 09:13 PM.
Page 10 of 25 « First 89 10 111220 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01202 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_php_printable
  • (2)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