vb.org Archive
Page 5 of 13 « First 34 5 67 Last »
Show 40 post(s) from this thread on one page

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)

Kwak 05-19-2004 04:09 AM
Quote:
Originally Posted by Velocd
CalPoly online eh? San Luis Obispo is my home town ;) I would have gone to that college, except they don't seem to admit the local citizens by huge numbers. :\

As for your problem, I can view the image gallery fine.
What the...working fine now! Cool!
Cal Poly San Luis Obispo is an excellent school, matter of fact, can compete with the top UC campuses. However, there were few cases where the admissions were discriminating ethnic minorities.

More Info: http://www.calpolyonline.com/forums/...read.php?t=987

Clicks Install.

SnowBot 05-24-2004 02:02 AM
aarrrggg Having a major problem with the hack, see screenshot below.

Any help would be greak.

None of the images appear in the admincp :( HELP!!! please.



https://vborg.vbsupport.ru/external/2004/05/1.gif



The path to one of the blank images is

http://www.synergyforums.com/forum/image.php?u=194&type=pthumb&s=y

dont know if that helps at all....

Velocd 05-24-2004 05:33 PM
If you verify an image, does the thumbnail show up in the gallery?

Does the full image show up in the vBulletin profile page?

SnowBot 05-24-2004 06:42 PM
Ok if i verify an image i get this

http://www.synergyforums.com/files/Image1.gif



Then if i click on the red X it takes me to here





http://www.synergyforums.com/files/Image2.gif


BUT if i go to the galary url

www.synergyforums.com/forum/album.php i get this

http://www.synergyforums.com/files/Image3.gif



All the sigs show up fine, its the profile pictures that dont, BUT if i upload a new one that seems to work. Its just the exsisting images people have already got.

Majik? 05-25-2004 06:39 AM
I had the same problem with profile pics that members already had.. They were red Xs. They all had to be uploaded again after installing this hack for hem to display properly.

Pseudomizer 06-08-2004 01:08 AM
Just as a short update for all of you: If someone uploads an anim gif, there will be no thumbnail due to the resizing and new image create. You will see the famous red X in the gallery. But if you go into the members profile you will see the anim gif.

VeloCD ? Any idea why this happens ? If we insert a GIF as blob into the DB it should not matter if it is an anim gif or not. So it works for the profile pic. But is there a way to recognize if a GIF is an anim GIF and then do NO resizing for a thumbnail ? I do not know of any procedure to check this but it does not hurt to ask for it.

Cheers,

redlabour 06-13-2004 10:51 AM
Perfect Hack - excactly something is searched by me for a long time ! :D

Ted S 06-16-2004 12:56 AM
Great hack although changing all those files is never very fun!

If you want another gallery in action feel free to check out http://www.scubaboard.com/album.php?...date&order=asc (stock hack right now but I'll probably modify it a bit this week changing the templates mainly).

Pseudomizer 06-16-2004 01:44 AM
Quote:
Originally Posted by Ted S
Great hack although changing all those files is never very fun!

If you want another gallery in action feel free to check out http://www.scubaboard.com/album.php?...date&order=asc (stock hack right now but I'll probably modify it a bit this week changing the templates mainly).
Then please open a new thread for your advertising and publish your own hack.

Cheers,

Ted S 06-16-2004 04:54 AM
No intent to change the code, just change the templates to better fit the tables (a few of them distort on my templates).... I'm not interested in touching any code when it works so well!

Boofo 06-16-2004 05:22 AM
Is there a way to have this send an email to the Admin when a new pic has been uploaded? I had a user upload a pic and I didn't even know it was there ro be verified until I accidentally checked this in the Admin CP. ;)

Erwin 06-16-2004 05:52 AM
Quote:
Originally Posted by Pseudomizer
Then please open a new thread for your advertising and publish your own hack.

Cheers,
I think you misunderstood Ted - when he said gallery in action, he means he is using this hack, and just wanted to show another gallery using this hack in action. :)

Pseudomizer 06-16-2004 09:06 AM
Upps. Then i am very sorry. I apologize for that. The word "another". Sorry again.

Cheers,

highlander_RD 06-16-2004 09:32 PM
Since I succesfully installed this *must have* hack migrating pics from vB2, I found the way to add a "comment" into the album_image_list:

1) Add this code in profile.php just below:
require_once('./includes/functions_upload.php');
process_image_upload('profilepic', $avatarurl);
PHP Code:
        $DB_site->query("UPDATE " . TABLE_PREFIX . "customprofilepic SET comment = '" . addslashes($_POST['commento']) . "' WHERE userid = $bbuserinfo[userid]"); 
2) Add this code in template modifyprofilepic, just below:
<tr>
<td><phrase 1="$permissions[profilepicmaxwidth]" 2="$permissions[profilepicmaxheight]" 3="$permissions[profilepicmaxsize]">$vbphrase[note_maximum_size_x_y_or_z]</phrase></td>
</tr>
Code:
<tr><td>
Comment: <br />
<input type="text" class="bginput" name="commento" size="50" maxlength="100" /></td></tr>
3) In the same template modifyprofilepic replace
<div class="smallfont" style="margin-top:$stylevar[formspacer]px"><label for="profilepic"><input type="checkbox" name="deleteprofilepic" value="1" id="profilepic">$vbphrase[delete_current_profile_pic] </label></div>
with this:
Code:
<div class="smallfont" style="margin-top:$stylevar[formspacer]px"><label for="profilepic"><input type="checkbox" name="deleteprofilepic" value="1" id="profilepic">$vbphrase[delete_current_profile_pic] - <i>$profilepic[comment]</i></label></div>
4) In template album_image_list the comment will appear as follows:
Code:
    <td valign="top" style="padding-left: 20px"><a style="font-size:11pt" href="member.php?$session[sessionurl]u=$image[userid]"><b>$image[musername]</b></a><br /><span class="smallfont">$image[usertitle]<br /><br /><i>$image[comment]</i></span><br />
    </td>
It works fine for me, if you want to check, my beta link to have a screenshot is:
http://www.egcommunity.it/forumbeta/album.php?
(Sorry, need to be registered in order to view the photo gallery!)

;-)

Boofo 06-16-2004 09:43 PM
Quote:
Originally Posted by highlander_RD
Since I succesfully installed this *must have* hack migrating pics from vB2, I found the way to add a "comment" into the album_image_list:

1) Add this code in profile.php just below:
require_once('./includes/functions_upload.php');
process_image_upload('profilepic', $avatarurl);
PHP Code:
        $DB_site->query("UPDATE " . TABLE_PREFIX . "customprofilepic SET comment = '" . addslashes($_POST['commento']) . "' WHERE userid = $bbuserinfo[userid]"); 
2) Add this code in template modifyprofilepic, just below:
<tr>
<td><phrase 1="$permissions[profilepicmaxwidth]" 2="$permissions[profilepicmaxheight]" 3="$permissions[profilepicmaxsize]">$vbphrase[note_maximum_size_x_y_or_z]</phrase></td>
</tr>
Code:
<tr><td>
Comment: <br />
<input type="text" class="bginput" name="commento" size="50" maxlength="100" /></td></tr>
3) In the same template modifyprofilepic replace
<div class="smallfont" style="margin-top:$stylevar[formspacer]px"><label for="profilepic"><input type="checkbox" name="deleteprofilepic" value="1" id="profilepic">$vbphrase[delete_current_profile_pic] </label></div>
with this:
Code:
<div class="smallfont" style="margin-top:$stylevar[formspacer]px"><label for="profilepic"><input type="checkbox" name="deleteprofilepic" value="1" id="profilepic">$vbphrase[delete_current_profile_pic] - <i>$profilepic[comment]</i></label></div>
4) In template album_image_list the comment will appear as follows:
Code:
<td valign="top" style="padding-left: 20px"><a style="font-size:11pt" href="member.php?$session[sessionurl]u=$image[userid]"><b>$image[musername]</b></a><br /><span class="smallfont">$image[usertitle]<br /><br /><i>$image[comment]</i></span><br />
</td>
It works fine for me, if you want to check, my beta link to have a screenshot is:
http://www.egcommunity.it/forumbeta/album.php?
(Sorry, need to be registered in order to view the photo gallery!)

;-)
How about a screenshot then? ;)

highlander_RD 06-17-2004 11:10 PM
Quote:
Originally Posted by Boofo
How about a screenshot then? ;)
Yes, here they are! :rolleyes: :squareeyed:
the modifyprofilepic page with the input field and the comment below the photo:

Pseudomizer 06-17-2004 11:21 PM
Quote:
Originally Posted by highlander_RD
Yes, here they are! :rolleyes: :squareeyed:
the modifyprofilepic page with the input field and the comment below the photo:
Sorry, but for my understanding. You are running Member Photo album v2.0 on VB 3.0.x and you want to migrate the pics from the member album VB2.3.x to this new version ? Is this correct ?

Cheers,

highlander_RD 06-17-2004 11:23 PM
and here the screenshot of the photo gallery (the comments are on the right in italic fonts):

highlander_RD 06-17-2004 11:28 PM
Quote:
Originally Posted by Pseudomizer
Sorry, but for my understanding. You are running Member Photo album v2.0 on VB 3.0.x and you want to migrate the pics from the member album VB2.3.x to this new version ? Is this correct ?

Cheers,
No.
I had on vB 2.2.9 vb Member Photo by Velocd with the "comment" field.
I installed Member Photo Album v2.0 on vB 3.0.1 but I didn' find the "comment" field, so I just added this option that was present on the earlier version.

Thanks

Pseudomizer 06-18-2004 08:18 PM
Quote:
Originally Posted by highlander_RD
No.
I had on vB 2.2.9 vb Member Photo by Velocd with the "comment" field.
I installed Member Photo Album v2.0 on vB 3.0.1 but I didn' find the "comment" field, so I just added this option that was present on the earlier version.

Thanks
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,

highlander_RD 06-18-2004 10:33 PM
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

Pseudomizer 06-18-2004 11:27 PM
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,

Photon 06-19-2004 12:49 AM
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??

Cypjaxion 06-19-2004 02:38 AM
Edit - nevermind, nevermind at all :rolleyes:

highlander_RD 06-19-2004 07:31 AM
Quote:
Originally Posted by Photon
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
can someone help me??
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

Martin64 06-21-2004 12:54 AM
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. :)

Cold Steel 06-24-2004 08:15 PM
Quote:
Originally Posted by Photon
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??
I got that error too. It was simple to fix.

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

Cold Steel 06-24-2004 08:23 PM
I've got it running at http://forums.asiansinc.com/gallery.php

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

Cold Steel 06-24-2004 09:06 PM
Bug?

All of my signatures show this:

Last modified:
12.31.69, 07:00 PM

will_lean 06-24-2004 11:07 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 !

Cold Steel 06-25-2004 12:29 AM
Would this hack cause me to have this problem "File system directory is not writable. " when trying to upload attachments during normal posting operations? My attachments go into the file server, not the database.

Cold Steel 06-25-2004 05:02 AM
Well, I fixed that by chmodding everything in the attachments folder 777.

However if you check out http://forums.asiansinc.com/album.php sometimes the picture showing up in the album doesn't match with what shows up in the profile. Also, sometimes it replaced either the profile pic or the avatar -- I'm not sure which.

Onkel_Tom 07-01-2004 11:06 AM
updated to version 2.0, works great !
thanks you ;)

Cold Steel 07-01-2004 06:40 PM
All the signatures show this:

Last modified:
12.31.69, 07:00 PM

And now I can't change my profile pic -- it always ends up as my avatar, although the album still shows my old profile pic.

Help, please.

buro9 07-02-2004 07:02 AM
There's a pretty serious problem with your memberlist pages if you have installed this hack.

The hack changed the PRIMARY KEY on the customprofilepic table, and this causes a massive degradation in the speed of the query that memberlist.php uses.

What happens is documented in this thread along with the fix:
https://vborg.vbsupport.ru/showthread.php?t=66765

Note that the fix merely adds an index to restore it more closely to the vBulletin defaults by adding an index back to the table in place of the removed PRIMARY KEY.

I'm pretty furious about it though. IMO no hack should ever touch the vBulletin indexes and schema... they should only extend it. This hack broke that, and in turn created a hundred fold drop in performance of the regular vBulletin memberlist.php

This isn't the first time hacks have done dumb things, but this one was painful because of the 6+ seconds lock on the database table and the resulting performance drop elsewhere on the board.

Add the index back if you run this hack.

Cold Steel 07-04-2004 04:23 AM
Quote:
Originally Posted by Cold Steel
All the signatures show this:

Last modified:
12.31.69, 07:00 PM

And now I can't change my profile pic -- it always ends up as my avatar, although the album still shows my old profile pic.

Help, please.
I had another hack installed (vBSigHosting) that was interfering with this one. I had to rearrange the order of some of the edits. It's fixed, though.

Thanks again for this great hack.

ChuanSE 07-04-2004 06:18 AM
Quote:
Originally Posted by buro9
There's a pretty serious problem with your memberlist pages if you have installed this hack.

The hack changed the PRIMARY KEY on the customprofilepic table, and this causes a massive degradation in the speed of the query that memberlist.php uses.

What happens is documented in this thread along with the fix:
https://vborg.vbsupport.ru/showthread.php?t=66765

Note that the fix merely adds an index to restore it more closely to the vBulletin defaults by adding an index back to the table in place of the removed PRIMARY KEY.

I'm pretty furious about it though. IMO no hack should ever touch the vBulletin indexes and schema... they should only extend it. This hack broke that, and in turn created a hundred fold drop in performance of the regular vBulletin memberlist.php

This isn't the first time hacks have done dumb things, but this one was painful because of the 6+ seconds lock on the database table and the resulting performance drop elsewhere on the board.

Add the index back if you run this hack.


Euhmmmmmm, is this fixed now? I like the idea of a member album, but I don't like a hack that needs patches and mess up my db.

A word from the author plz??!!

ChuanSE 07-04-2004 06:20 AM
Quote:
Originally Posted by Onkel_Tom
updated to version 2.0, works great !
thanks you ;)

So the 2.0 won't mess up anything? Safe to install? :ermm:

nighteyes 07-04-2004 03:27 PM
Does this work with vb 3.02?

Onkel_Tom 07-04-2004 05:48 PM
yes, it works for me with vB3.0.2


All times are GMT. The time now is 09:15 PM.
Page 5 of 13 « First 34 5 67 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.01594 seconds
  • Memory Usage 1,882KB
  • 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
  • (8)bbcode_code_printable
  • (4)bbcode_php_printable
  • (15)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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