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)

Quote:

Originally Posted by Pseudomizer

Ok. The reason why i asked was if you have seen my migration script from the old version to this new version. But you don't need it any more.

Cheers,

Maybe I don't... but many members likely need your hack, so I would suggest to publish this useful link anyway! ;D

Quote:

Originally Posted by highlander_RD

Maybe I don't... but many members likely need your hack, so I would suggest to publish this useful link anyway! ;D

Just read the first posting. It's already in there as 3-rd party add-on. I thought you missed that but in fact you don't need it. :-)

Cheers,

I've read this whole thread but I can't find the solution for my problem..

Warning: Division by zero in /usr/home/elimina/public_html/drive/forums/album.php on line 142

Warning: Division by zero in /usr/home/elimina/public_html/drive/forums/includes/functions.php on line 1707

Code:

Database error in vBulletin 3.0.1:



Invalid SQL: 

                SELECT user.userid, dateline, 

                comment, user.username, user.usertitle, 

                user.joindate, user.usergroupid

                FROM customprofilepic 

                LEFT JOIN user USING (userid) 

                WHERE visible=1

                 

                ORDER BY posts desc

                LIMIT 0, 

        

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 '' at line 9



mysql error number: 1064

can someone help me??

Edit - nevermind, nevermind at all :rolleyes:

Quote:

Originally Posted by Photon

the problem is caused by LIMIT=0 in SQL.
In fact the SQL syntax in album.php is:

PHP Code:


		
			
    // Query: fetch profile pictures

    ////////////////////////////////////





    $images = $DB_site->query("

        SELECT user.userid, dateline, 

        comment, user.username, user.usertitle, 

        user.joindate, user.usergroupid, user.notescount

        FROM ".TABLE_PREFIX."customprofilepic 

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

        WHERE visible=1

        $condition 

        ORDER BY $sort $order

        LIMIT " . ($minlimit-1) . ", $perpage

    ");

LIMIT is determined by the variable $minlimit in album.php that shouldn't give 0.
$minlimit is determined so:

PHP Code:


		
			
// Build page scope

///////////////////////





$pagenumber = $page > 0 ? $page : 1;



$rows = $result['count'];



$pages = ceil($rows / $perpage);



if ($pagenumber < 1)

{

    $pagenumber = 1;

}

else if ($pagenumber > $rows)

{

    $pagenumber = $rows;

}



$minlimit = ($pagenumber - 1) * $perpage+1;

$maxlimit = ($pagenumber) * $perpage;



if ($maxlimit > $rows)

{

    $maxlimit = $rows;

    

    $minlimit = $minlimit > $rows ? $rows-$perpage : $minlimit;

}



$minlimit = $minlimit <= 0 ? 1 : $minlimit;



$pagenav = construct_page_nav(

    $rows, 

    "album.php?$session[sessionurl]type=$_REQUEST[type]", 

    "&amp;pp=$perpage&ltr=$ltr&sort=$sort&order=$order"

);

maybe you need to change the setting perpage and rows?
Or better reinstalling the whole hack?
:-D

Great hack, this should be lots of fun. Feel free to link from our album from the first post:

http://www.emutalk.net/album.php?

Though at the moment I'm the only member with a profile pic, there should be more soon. :)

Quote:

Originally Posted by Photon

Code:

Database error in vBulletin 3.0.1:

 

Invalid SQL: 

                SELECT user.userid, dateline, 

                comment, user.username, user.usertitle, 

                user.joindate, user.usergroupid

                FROM customprofilepic 

                LEFT JOIN user USING (userid) 

                WHERE visible=1

 

                ORDER BY posts desc

                LIMIT 0, 

 

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 '' at line 9

 

mysql error number: 1064

can someone help me??

I got that error too. It was simple to fix.

Just go into your admincp and save your settings for the member album.

I've got it running at http://forums.asiansinc.com/gallery.php

You can use mine as an example, if you want.

Bug?

All of my signatures show this:

Last modified:
12.31.69, 07:00 PM

Hi
just installed this on 3.0.1 and have a few questions.
My album seems to run fine however when i upload a picture there is no feild to add a comment,is the comment portion an addon or has it been added and i missed something?

great hack !

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 (2)bbcode_code_printable (2)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01241 seconds Memory Usage 1,763KB 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 (2)bbcode_code_printable (2)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
Messages: