vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - [DBTech] Dragonbyte Gallery v1 (vB4) (https://vborg.vbsupport.ru/showthread.php?t=285074)

AusPhotography 10-21-2012 03:19 AM

Some feature requests (we have the Pro version)...
  1. File size limits on uploads (per category)
  2. Pixel size limits (per category)

Thanks!

Kym

AusPhotography 10-21-2012 06:53 AM

After import from PP vBgallery all the images show with size = 0

Work around in dbtech/gallery/modules/gallery/actions/view_image.php:
PHP Code:

if (!$image_data['is_youtube'])
{
    
$img_location DBTECH_GALLERY::fetch_image_path($image_data['imageid'], 'local'$image_data['instanceid']) . '/full/' $image_data['imageid'] . '_' $image_data['dateline'] . '.' $image_data['filetype'];

    
$img_info getimagesize($img_location);
    
$image_data['filesize'] = filesize($img_location);  // this line added



DragonByte Tech 10-24-2012 03:49 PM

Quote:

Originally Posted by Alibass (Post 2373460)
@Dylan

I've noticed you logged in at my site, did you see see what I'm talking about when it comes to deleting albums by users?

I just released 1.2.5 which should fix this problem. I also incorporated ricktas' suggestions for the importer and image size. Sorry it took me a bit to get this worked out, hard to code when you can only sit at the computer for short periods of time heh.

Dylan

DragonByte Tech 10-24-2012 04:13 PM

Quote:

Originally Posted by ejbreeze (Post 2371452)
Box shadows only show up in explorer and not chrome or mozilla. Is that a function of chrome and mozilla not showing them?

I'm not sure what the problem is really, I installed the style you sent me and it looks fine with IE, Chrome and FF. Have you made any major modifications to it?

If you want to give me a temp admin account I can login to your site to see if I can figure out what's wrong.

Dylan

Alibass 10-24-2012 08:16 PM

Quote:

Originally Posted by DragonByte Tech (Post 2375664)
I just released 1.2.5 which should fix this problem. I also incorporated ricktas' suggestions for the importer and image size. Sorry it took me a bit to get this worked out, hard to code when you can only sit at the computer for short periods of time heh.

Dylan

Dylan, that solved the problem :):up:

Thanks so much, hope you get to feeling better.

AusPhotography 10-26-2012 06:57 AM

Found a bug...

dbtech/gallery/modules/gallery/functions/class_module.php added '&&' to line 'gi.deleted = 0 &&'
PHP Code:

            $thiscount self::$vbulletin->db->query_first("
                SELECT 
                    COUNT(imageid) AS thiscount 
                FROM " 
TABLE_PREFIX "dbtech_gallery_images gi 
                LEFT JOIN " 
TABLE_PREFIX "dbtech_gallery_albums ga ON gi.albumid = ga.albumid 
                WHERE 
                    ((gi.albumid = 0) || ((ga.hidden     = 0) && (ga.password = '')) || (gi.userid = " 
intval(self::$vbulletin->userinfo['uerid']) . ")) && 
                    gi.instanceid    = " 
intval(self::$current_instance['instanceid']) . " && 
                    gi.approved        = 1 && 
                    gi.deleted        = 0 &&  
                MATCH 
                    (gi.title, gi.text, gi.tagging, gi.username) 
                AGAINST 
                    " 
$boolean_query
            
); 


AusPhotography 10-26-2012 11:15 AM

Another error... looks like some strings need escaping...

('+king's* +canyon* ') needs to be ('+king\'s* +canyon* ')

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:

                                SELECT
                                        *,
                                        gc.catname,
                                        MATCH (gi.title, gi.text, gi.tagging, gi.username) AGAINST ('+king's* +canyon* ')
                                        AS relevance,
                                        u.username,
                                        ga.hidden,
                                        ga.title as albumname
                                FROM dbtech_gallery_images gi
                                LEFT JOIN dbtech_gallery_categories gc ON gi.catid = gc.catid
                                LEFT JOIN dbtech_gallery_albums ga ON gi.albumid = ga.albumid
                                LEFT JOIN user u ON gi.userid = u.userid
                                WHERE
                                        ((gi.albumid = 0) || ((ga.hidden = 0) && (ga.password = '')) || (gi.userid = 0)) &&
                                        gi.instanceid  = 1 &&
                                        gi.approved    = 1 &&
                                        gi.deleted      = 0 &&
                                MATCH
                                        (gi.title, gi.text, gi.tagging, gi.username)
                                AGAINST
                                        ('+king's* +canyon* ' IN BOOLEAN MODE)
                                ORDER BY
                                        relevance DESC
                                LIMIT
                                        0, 14;

MySQL Error  : 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 's* +canyon* ')
                                        AS relevance,
                                        u.username,
                                        ga.hidden,
                                        ga.ti' at line 4
Error Number  : 1064
Request Date  : Friday, October 26th 2012 @ 07:40:58 PM


FIX: dbtech/gallery/modules/gallery/functions/class_module.php in public static function fetch_display_images

PHP Code:

            $boolean_query "('";
            for(
$i=0$i count($query_array); $i++)
            {
                
$boolean_query .= '+' self::$vbulletin->db->escape_string($query_array[$i]) . '* ';
            }

            
$select_query "MATCH (gi.title, gi.text, gi.tagging, gi.username) AGAINST " $boolean_query "')";
            
$boolean_query .= "' IN BOOLEAN MODE)"


AusPhotography 10-26-2012 10:41 PM

1 Attachment(s)
I found a couple of other bits that needed escaping.

Fixed file attached.

Bounce 10-27-2012 09:03 PM

Quote:

File path is not writeable. The script does not have access to write files to the correct directory.
get this error and driving me nuts as ive set permissions to uploads to 777, ive also searched thread and tried 755....

to no avail as yet :confused:

Bounce 10-27-2012 09:12 PM

im also getting Error:
You did not enter a valid value for this setting.

in admin cp on the settings

Image Options > Image Upload Path


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

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.01750 seconds
  • Memory Usage 1,772KB
  • 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
  • (1)bbcode_code_printable
  • (3)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
  • (2)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