vB3 Member Album 2.0

[Malfunktion]

The main problem is that somehow it doesn't work in vBulletin 3.0.3. I see you're still running 3.0.0, so maybe something was changed in the coding from then.

It's okay though, take your time! vBulletin hacks never come before your life, hopefully! :p

well.. 3.0.2 to be exact :p

[FleaBag]

Nuno boy. ;)

[ambrosious]

The Edit Profile Pic link in the user's control panel is not showing up for anyone lower than ADMIN. Is there a check box somewhere I'm missing?

[Pseudomizer]

The Edit Profile Pic link in the user's control panel is not showing up for anyone lower than ADMIN. Is there a check box somewhere I'm missing?

I would guess that you placed the code in the wrong section?

Cheers,

[MissKalunji]

Did n e one figure out how to fix the thumbnail problem???

[ambrosious]

I would guess that you placed the code in the wrong section?

Cheers,

In which template or php file? I'll try to reinstall it. LOL, but I don't know.

Thanks!

[indiamike]

So as to make things a bit easier when I do go to update (and help me from reading through the pages), could someone summarize the problems, or main problem, with this hack? I've had it running on my forum for months now and haven't had any issues with it. I may be able to do a quick update, if it doesn't seem to be a huge issue.

Like a few others, I did a fresh install on vb 3.0.3 and the only problem I could find was that the thumbs were not getting generated and the album shows all broken images http://www.indiamike.com/india/album.php

Hopefully there is a simple fix since this is probably the number one hack at least for me that I really looked forward to using here at vbulletin.org

Mike

[Velocd]

Work has been vicious as always, but I'm forseeing some free time the first week of school (that is, 23rd-29th, and yes, that sounds odd). I'll make a good bug fix for this hack then, and perhaps some other features. I plan to upgrade my board to vB 3.0.3 to see just what the errors are.

[ambrosious]

In which template or php file? I'll try to reinstall it. LOL, but I don't know.

Thanks!

I can't find it, anyone know where to look? Just point me int he right direction and I'll take it from there!

[Zelda-King]

I noticed even back on 3.0.1, after I changed my thumbnail sizes, the option to rebuild profile pictures didn't have any affect (see 1st attachment for what I see during the process). [I did rebuild attachment thumbnails. I even tried disabling everything and re-enabling.]

Since upgrading to 3.0.3 the couple of my users that uploaded a profile pic, those come out blank. Perhaps this is to do with the 'unapproved' status? I tried on my test account (which already had a disapproved pic) and that uploaded fine (obviously not showing in the album because it's disapproved).

Another problem I had: profile pictures are no longer showing in profiles (even back on 3.0.1). Only in the album. This is even after upgrading the forums so it's nothing to do with the PHP. Even approved images just don't show there... however, the test one mentioned above that I did AFTER upgrading everything: THAT worked but one of my users tried to update their picture after that and still nothing shows in their profile though it shows in the album.

[ambrosious]

One more time, only my ADMINS can see the option to upload a pic in their User CP.

Can anyone tell me why? I've rechecked all files and everything is as should be according to instructions.

[jp2]

Nice hack, Ive been waiting for something like this for a while now. Im going to install it tonight. :)

[Zelda-King]

One more time, only my ADMINS can see the option to upload a pic in their User CP.

Can anyone tell me why? I've rechecked all files and everything is as should be according to instructions.Have you set the usergroup permissions in the admin cp so that other usergroups are cleared to upload profile pics?

[Zelda-King]

I noticed even back on 3.0.1, after I changed my thumbnail sizes, the option to rebuild profile pictures didn't have any affect (see 1st attachment for what I see during the process). [I did rebuild attachment thumbnails. I even tried disabling everything and re-enabling.]

Since upgrading to 3.0.3 the couple of my users that uploaded a profile pic, those come out blank. Perhaps this is to do with the 'unapproved' status? I tried on my test account (which already had a disapproved pic) and that uploaded fine (obviously not showing in the album because it's disapproved).

Another problem I had: profile pictures are no longer showing in profiles (even back on 3.0.1). Only in the album. This is even after upgrading the forums so it's nothing to do with the PHP. Even approved images just don't show there... however, the test one mentioned above that I did AFTER upgrading everything: THAT worked but one of my users tried to update their picture after that and still nothing shows in their profile though it shows in the album.
Now out of nowhere all the pictures have disappeared from the album, and don't even show in the admin cp. Rebuilding thumbnails/pics doesn't fix it. I know this has been touched on. Just confirming the status on 3.0.3.

[ambrosious]

Have you set the usergroup permissions in the admin cp so that other usergroups are cleared to upload profile pics?

You rock! I looked once, thought the link wasn't there, but second time I looked, there you go.

[ambrosious]

Ok, is there a way to shut out non members from viewing the album? Just curious.

[Zelda-King]

I fancy doing this myself actually. Watch this space...

[MissKalunji]

Anybody figured out the problem with the pictures not showing???

[Zelda-King]

Ok, is there a way to shut out non members from viewing the album? Just curious.In album.php;

Above: // Verify arguments
Add: // No guests please. :/ (added by King-X)
if ($bbuserinfo['userid'] == 0) {
print_no_permission();
}

[ambrosious]

In album.php;

Above: // Verify arguments
Add: // No guests please. :/
if ($bbuserinfo['userid'] == 0) {
print_no_permission();

I now bow down to you, all wise and powerful Oz...

[Zelda-King]

Not really. I missed a parse when posting it. Code updated. Here it is again for reference;
// No guests please. :/
if ($bbuserinfo['userid'] == 0) {
print_no_permission();
}It's vBulletin's own code.

[ambrosious]

Not really. I missed a parse when posting it. Code updated. Here it is again for reference;
// No guests please. :/
if ($bbuserinfo['userid'] == 0) {
print_no_permission();
}It's vBulletin's own code.

I bow down to you, all somewhat smart and semi powerful vBulletin guy...


;)

[58sniper]

Has anyone got this to work in a clean install of 3.03?

[Zelda-King]

The author posted saying they were going to look into it over the next couple of weeks. This is a known issue.

[Omega Prime]

Yep - I've got the same problem on a clean install on 3.03. I get the avatar photos for each person who has a profile photo. http://www.efhs84.com/forum/album.php? for the example...

I also have this problem. Anyone know what would cause avatars to show instead of profile pics? Cool hack, btw :)

[Zelda-King]

You do? I'm running 3.0.3 and I see nothing, AND profile pics don't show in profiles.

[Lion's Heart]

plz checking again your GD system on the vbulletin options :)
perhaps it not enable

[Zelda-King]

It is enabled. They were showing before I upgraded. This has already been discussed anyway. I was just reiterating. It's a known problem. In any case, GD would have nothing to do with the fact profile pics aren't showing for me in profiles any more (which is a seperate issue).

[Weasel]

Perhaps this is because vBulletin changed the return type of fetch_thumbnail_from_image to an array? The filedata is stored in key 'filedata', for example $thumbnail['filedata']. This is just a guess, I don't have this hack installed.

Edit: ya, #16 in the install file uses this function call, you probably want to change it to:


$thumbnail = fetch_thumbnail_from_image($image); //Take out second parameter.
$thumbnail = $thumbnail['filedata']; //Add this line.

[Zelda-King]

That hasn't fixed it. Should "$thumbnail =" appear twice like that?

[Weasel]

That hasn't fixed it. Should "$thumbnail =" appear twice like that?
That's because there is a second fetch function call in albumcp.php you will have to fix. There are also some various bugs relating to TABLE_PREFIX in both album.php and albumcp.php that will cause MySQL errors.

I have modified this hack to work with 3.0.3 and have confirmed it working on a clean installation. See attached.

And BTW, that syntax is pefectly legal in the same way that $foo = $foo + 3; is legal.

[Zelda-King]

Excellent! Especially from someone who hadn't even installed the hack initially. Are there easy steps to upgrade or are we best off going through the whole installation?

[Ted S]

Weasel,
using your files alone plus your change from your previous post, I still get broken thumbnails, is there anything we need to change in the other portions of the hack (i.e. in the normal vb files)?

Thanks

[Weasel]

Weasel,
using your files alone plus your change from your previous post, I still get broken thumbnails, is there anything we need to change in the other portions of the hack (i.e. in the normal vb files)?

Thanks

did you make sure to rebuild thumbnails in the verify section after you made the two $thumbnail = fetch... changes? There should by instances in both inlclude_upload.php and albumcp.php

Otherwise those should be the only two changes you have to make (except in the case where you use a table_prefix in your database). Also try pressing ctrl-R to do a hard-refresh of your album.php page.

If you go into your database using phpmyadmin and go to customprofilepic and browse, you should be able to see the raw thumbnail data. If you see "Array" that means you have not yet rebuilt the thumbnails using the two thumbnail code changes.

[Zelda-King]

I get broken thumbnails too and I redid the whole hack (not the database tables though). Then again the Rebuild Profile Pic Thumbnails function always worked strange for me even before the upgrade.

Having said that, it's insanely late here. I'll reserve final judgement until I give this another go tomorrow morning.

[Weasel]

I get broken thumbnails too and I redid the whole hack (not the database tables though. Then again the Rebuild Profile Pic Thumbnails function always worked strange for me even before the upgrade.

Can you go into your database and see what you have in your customprofilepic table under profilepicdata?

[Velocd]

From the readings, this hack runs utterly buggy on 3.0.3, most likely due to function changes or my code is just vB deprecated. I still hope to have a bug fix release by the end of this month (it has yet to be worked on), but my schedule is crammed so I'm not entirely sure it's possible.

[Weasel]

I have made a couple of other changes in my upload in post #281. It fixed thumbnails not displaying in the admincp because of the &s=y at the end of the img src url (not sure what that's for?)

Anyway, zelda-king you can try re-uploading the two php files and rebuilding..see if that works, because I have it running fine on 3.0.3 and those are the files im using.

[Ted S]

Wierd... the hack worked (I am using the files you attached) but the admin script was still calling &type=pthumb which does not work. I have changed the admincp and the output template and will test a bit more but so far so good. Thanks again!

[Ted S]

Odd... I seem to be showing a few avatars instead of profile pictures now, any idea why?

[Weasel]

http://www.almostsmart.com/forums/album.php?type=1&sort=joindate&order=asc :)

[MissKalunji]

http://www.almostsmart.com/forums/album.php?type=1&sort=joindate&order=asc :)


What did you do to fix it caz i still have the same problem

its calling the : pthumbn

Still not working......did everything.... :ermm:

if i go in my phpadmin and custom profile ... it shows a bunch of chararacters no array........
I saved and rebuild from the option in vb album and also the attachemeht

i redid all the steps and it still shows the none available and the album.php also.....


Still nuthing :surprised:

[Zelda-King]

Can you go into your database and see what you have in your customprofilepic table under profilepicdata?Well this is from one username:
????\0JFIF\0

\0\0
\0
\0\0??\0>CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), default quality\n??\0C\0 \n\r\Z\Z $.\' \",#(7),01444\'9=82<.342??\0C
\r\r2!!2222222222222222222222222222222222222222 2222222222??\0\0d\0X
\"\0

??\0\0\0






\0\0\0\0\0\0\0\0
 \n??\0?\0
\0\0
}
\0!1AQa\"q2???#B??R??$3br? \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz?????? ?????????????????????????????????????????????????? ???????????????????\0
\0








\0\0\0\0\0\0
  \n??\0?\0
\0
w\0
!1AQaq\"2?B???? #3R?br?\n$4?%?\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz??????? ?????????????????????????????????????????????????? ?????????????????\0
\0\0?\0??[fʁB?\0???h?HzRQH.T???Ӵ뛹\0?\'????O??\'?}-?????¶????m H?h$?|??=)<s5?kkf??????PO\\?Q\\5?\Z??<Zj????%??)#?l?????\'?9?˵???J??????!??5%xe???K?? W?.?p.?;????OP?8潃M??0?u?o?a???{??g?Tg?-5??E4{??Z)( ???\0)JZ?յ?+D?[R???w?Wo??\0?O?@%??G?uY??U?BD??C`)?⸩?????fۆ d\0?琣?ι?j???Mv???\"?fPIU uf<?OºO\nE.?{?H?K<?Y?p?sϰ???5??q~?=???\0??\Zţ?jf?\0]????9????C??ky??%U?? ????\\????c?(~????Nޥr??t?OR????d?l?$+?{??8???t ??$FI??1??Fk???<???aD?
#?????b?剤(?G??F??C??\Z???Q?Ee??m%??K! ???`NG??kR?N?aES
C_9?@???V?$vi/,?p??I(?e?6??=???Ҽ???|{??????p??ғ?????J??h?m ?$Kg???????:\\?,Ϲ?}?{/`?*???4???c??fe??I??IU>????qVGi/?4?lc?Vنd\n}?1|kVm\n??%??3??W<x|?U?C6?\r????|?£?n????-3_T????ݱ$ă+,I?{u??<u??_ǩ뗉$ے.+?)\0?
ױ??????L^d+?HU?`O?Q??j[MG??-?(????gv?{g\'?+8N??s??;?S???ɍԍ??????l\n??--cv%?F?$??8??A??V???9XQE?!?_??[?\0?E???bv?^2?uX??)?+ڼO??????? <p????x_Ԋ??N??????Jc#??\r ????|THh?i.N???wD?$Ȋ??8<֓*.Y?P?B?=?1??BC}?\0g??#???c??N[E??;\"\03???Z??????`KiJʟ?Lp;??}??ok:??\"?BH??cGV ?d??ܟ|wƹ?^?N\Z?????\\????????N????&????&?῵??+???\r??Q?^?Wr?<m\Z?7?a???ZLv?jr?%??T????|?d?6q^?r֓?U&N??U??????\n?#?x:7i<R?Q??????}??c??&?κ??+ ??\\?w?g??+QEY
EP????>?wyr8???H?; m?h?
\0妛??Mq??q?ǜ?)#?@:?Y?ڕ???з?P?>?H????\0????????6??b???m??g?ƧdQ?!bK?????jw !ey;??F?o? ???V??k????F?v\0?8?@
?+?ғN?V)??k?Al:??:c֜?Z-^?????q3?Ol?ͤ?<???\0?y5c?zp7?t+&??Ipc?(??a?^x??k??Y&Ҽ?ʯ??J?}&???k????x?f???n9ϯ?[OB?m??e????KA??-?r[?9?% ?k??sk~?V??K??g%??L????+???c?8???<Q=?+????],???a+?\0?GO????x/?V?k?+??\r?ֈ|?Q7F?Nx?ws?tA驔??F?Ə???=mo3mp?? ?_??kO?i?ʯ-?!???{Vbj>???F?O??Pщ??a?sT????[??Y?|~???Q?q????V?$?U?(`A??+7E????^\\G6?\nFW\0w&?`x??1?c}둗???u# (???<׵?????T\n?\0??FO?My^?????`v[?$???\'??^$?}??:????$\">?x_Ԋ?:\r??5(????un???R2?!?\'???՘???F?6?P?IU? ??SŠ4???cǧ??kF,\"?\nɽKH??֛?hn\0YQ??\r?=??#??h\'x? ???{?
o?59[pX?)$?+??+??5??9-??.Ll0~????Zz?vّ??PD??*c??!??n?xc???>?ּ???\0>??????8%??g!X??=???zW??????a???5?gq?t#??#? ??Eu?}B\'KY$????r?????}T[{?s?#?[R?\r?Z?q<Pn??????t?l?g$\Z????0?+,??QXn$??#o?Y?9?-??iu?h6???w2\0?O???~?^?/ß???׋u5?,?Ѯ?\0?s???5t?n록?;Z(??\0??\0?x ???????????????4?HA?Kp7?\\@??\0?Ve????P:????? z?֯??????ݴ???QY\"?>??Q??*???$?????שh C?(N????Z(?P??t6?Xq?ה?b?b?t??Ty??,nF\0?2?E4 ?!L?<??_I???.w??\\x%?w??ׯn=??ln$?U???e?}?(??zMX_e??QEnf??
Anyway, zelda-king you can try re-uploading the two php files and rebuilding..see if that works, because I have it running fine on 3.0.3 and those are the files im using.Yes I even turned off my firewall, cleaned my cache, hard-refreshed and redownloaded then uploaded album.php and albumcp.php again, redoing the functions_upload.php edits. There appears to be nothing wrong with functions_upload because when I rebuilt attachments and uploaded a test one, that worked. I uploaded a profile pic of me and that's actually showing in my profile now. But it doesn't show in the album or in the albumcp. Either nothing appears or there's a HUGE broken image. The case is different from user to user.

Edit: I've fixed the broken image problem by temporarily using an old albumcp file, processing the thumbnails then using the new file again, so that's ok. It still doesn't show the images though.

On another note, I did some fiddling around and noticed when someone uploads a profile pic it shows in their profile (this is with 'picture moderation' settings enabled) but when you approve it the image no longer shows in their profile. I'd mentioned disappearing profile pics before but I've only just realised the condition under which that happens.

Edit 2: After some more fiddling in the admincp I got the odd huge broken image again, though this time it only shows on the profile page, not the cp. After more messing around and uploading it was gone again, so that looks temperamental.

[Weasel]

out of my 140 profile pictures I got about 10 where the thumbnail was corrupted. This seems to be some sort of problem with vbulletin's thumbnail generation function or just errors with the image itself. After I re-saved the image in photoshop then it generated correctly.

If you have the "random" characters in your database then the thumbnail should be visible by going to /forums/image.php?u=userid&type=pthumb

[Zelda-King]

There's nothing wrong with my thumbnails. They work in attachments just fine. The difference between me and you is: on your board you can see the thumbnails in the Album hack. I don't. Just the members are listed.

I'm using your code:

http://www.gamercrossfire.net/bb/album.php

Now, though I have quite a few hacks installed, as far as I recall, none of them modify functions_upload.php.

Edit: For the record - I've even tried redoing the hack on virgin vBulletin PHP files. There was no difference.

[MissKalunji]

n e one?? do i have to change n e thing in the php files besides the functions_upload????

and the sql???

What am i doing wrong :surprised:

[Zelda-King]

If you have the "random" characters in your database then the thumbnail should be visible by going to /forums/image.php?u=userid&type=pthumbI have 'random' characters in the database but if I go to the URL I just get the message: "The image ?http://www.domain.com/forum/image.php?u=userid&type=pthumb? cannot be displayed, because it contains errors.".

Here's what I have in the thumbnaildata table for the image I got that error message for:
????\0JFIF\0

\0\0
\0
\0\0??\0>CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), default quality\n??\0C\0 \n\r\Z\Z $.\' \",#(7),01444\'9=82<.342??\0C
\r\r2!!2222222222222222222222222222222222222222 2222222222??\0\0d\0d
\"\0

??\0\0\0






\0\0\0\0\0\0\0\0
 \n??\0?\0
\0\0
}
\0!1AQa\"q2???#B??R??$3br? \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz?????? ?????????????????????????????????????????????????? ???????????????????\0
\0








\0\0\0\0\0\0
  \n??\0?\0
\0
w\0
!1AQaq\"2?B???? #3R?br?\n$4?%?\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz??????? ?????????????????????????????????????????????????? ?????????????????\0
\0\0?\0??L!???{T??@Q?pE8K9B??j??r ??e??4?зG_nh??;K9f??ƈY??\0 }+{P??4?%??b? +??+???\"?_°[??\\?ᱸ?{W??\0?x?[????1?\"=\0?>?????ql???{?#??W\\*J?̝8?Z???}D?t\n?}?\'??k?? ׌4?\08???`?\'
!?\0?5??i??4DUdH?;?8???[?\n?;-J?]b&.??ɷ?B2??\0
?\"??OSf????v?`n*???f)e\\v\r[RRQib#P???2`rj b\07???]?r31??L?????? ??w+\\M0#?J ?{?q[??&*??X?&L???+X,ĨXp3??V^???\'?\'??[?7W-so??e?X}EEq?[??*g?>l?4??y_??=???8?n?K??#x`RAu?s׵|?q ??I@Vb@?i?*:?rԫ\'?w????v??????EG?m???<s???E?i??%?\rKqm??2p7^?Z??r\n?z???k???h??????/#??S?V?Nm?3cš\rֳ??Kf?;dT?0ÿ??+?e???&?O:?b?u?qՇc??*????4?ɯ?0???k{\Z_?:??u?N`+? \nB?\0??ɪ獛??FIYj?z.??O?M???,?????ҵ?3??O???I?|??v7
?s??^???P?????L<????f=????\0ë?J??W????n?zo???Ս?G莯??+?o??1?>+???H`I ?!w*????Q??3?a+???o?7?,ۃ
?kq??????+??X?-? n?N~??o?g????ćm?j?!?????»+?]j??m\'???D????)?Z[??x9????\0Æ]?ZM???\\d~u??~+f????G?S+?֕H7 Ca\nG?H?{?EI?\"a?e?B?+-M??+?:?#?Z??,????\\d?ӥ|??{???K&?u?????\r???4???j?d
n\"#r???Һ??r??Éi4s?V?u?jqX???\\H~D??޽?F?u??|%??? ?9???+????{??n?C?-mf?b}?Z8p?????ۊ???Lگ?<?p?c (l???L????t-??l`?jzk????6?UY????]\'?M?????B?p??3Տ??q3j2?4??[???n ??\ZKF\r?aպs?R??ғ?????Jz??k??[[??Ti???l???w??u:.??A^k??7?Ԅ?N6 ?@??^u????y?f?`v?o??9_Kk?I??ѱ??p??4?М=?voL?[??C_\\K?g?^??s2?(Q?? qY)tt?b?m?2?H??????F}^??D?C%????N?$?u;?=~?k?~?׵???ь?03?V?R}?
[P????Fʰ?V?z~#??????t?GW}???(?\\`???#?z?]??\rV?Z?~aа#????Zu֊?MͬsY?F\'
???◁ǀ?hn? Kٖ?蝱?;?a?9?=*??u9??iM}???,q?=???Q_\"Y|I?E?????^??\'???#???^???D???w^c??+??~????ۇ ?aK?o+v?<?fӬb??#??W$A?? ?ʶ???lag|?\\??]h7?b?3???n?B????S????Å`:?k[??|vZ???{+???D!???=3Q?y/0??;f?Ĭ?v\0w8#?\0?j\\??K?d?a??Q??0 8?Xb?i?\'v?ܾ?? ??bq~#?m#S??c?D?+*?H?\"?D~]????B7
?r*I??P?K?ݝ??I5???졏=??YMr?S??/g.hl˯?5ě??N?@S#p?ƛ-?I?H?\0?t??? ???V4???Q?9c??-?>??NJ*??nM?u?f??)?h??[??̇\0a???>??|b?}???w?#??]۲??\0Ux??\0?浚+T-mJ ?H?@???5?OV?6~|?%l??Is?????=)?Y?L??n?????4{g{m2 9u{???~?,????y??>#??Ķ&?P?`??f?@s?x!??V?????d\\Y.?v_???5??Y??t????A?h??4T ??<;\"???Mgy$!K??+??ۜ?ŧcҾ)j??k??+~??Cwr ?}???5ļp?7=}z?ƽ_[?r5hn??O.?s?8;??s?ז?.Ki?s??6?_q\\??#?^?????VqF?? +Đ??j????\"C!?I?#?x?W1+?2????\Z?;?Է?i??f#К?>1X+_<???ղ????????@??}?*???Ƣ?~d܂c9??\0??<?YN2?Z???m?????\0+oK??/0|?1-???x??)?.??Oui???&~? ??ZZ????_+?Q?a?ݽ??M\'S???Z?c??y7oq???M??Y?\'???\Z?l\"???>??s?HNk\n??,`???C*mu?d0?qU[ʺ?R?I???ܧ?z???Z?K??[;k}Q?.d?iOD?w^??|=????ܴ\Zj8?$????d|=??È?Z?Lo???? {e??\r?J??5?T?%;%??V?ZpM9?G[{????!Z??ɢ??z?sE/m?r{I???m?漣?~??ēj6?f??K?(????V?m?Xd?Y?XĒy ɮ?.?m\n?RG??e???ҩ??k+????j?<(??߷?A?|?0????????}-V\ni????Mv1;W??ٮS?x?䳶O?H???k?@I??]?????Y???k?(?4???0*H=i5???Ǧko??q+?a?-r>??M]?5?^y ??j*???ҋQ????xԉ?gr+?<6??P_???5??9Y?9??z׆.?t??z?kF{???&???Zˁ?\rf???W-?Ԓg1t??Nz+gݒ??sɢ???t@?ִ?}F??0`?T??p,?,9??E ??s\0?#G-?f?8?{~ ?r???Ee?\rWe/?\'????3???+t??)??0O֩
Ep????7Z????$C7|\"???@[?ξ?Д}??$QEyxω???+I?:?E?y?????.
It has the same kind of thing in the profilepicdata table too but that won't paste here properly.

[trackpads]

Well not sure what the heck is wrong. Some will show up and some wont. I made all the changes above and even removed the extra 'y' stuff at the end. Mine is one of the ones that will not show up so I even deleted and uploaded a new one. No luck.

-Jason

http://www.trackpads.com/forum/album.php (go to the 'G's to see working ones.

[MissKalunji]

What did ya'll do to fix it???

[trackpads]

What did ya'll do to fix it???
I want to know too!! This hack is awesome if I can get it to work!!

[Slynderdale]

In vBulletin 3.0.3 the thumbnail code changed a bit so invalid thumbnails were made.

If you already installed this hack and Weasel's update:
( Weasles update can be found here: https://vborg.vbsupport.ru/showpost.php?p=546244&postcount=281 )
In the file path/to/forums/includes/functions_upload.php, find

if ($thumbnail)
{
$image['update'] = ", thumbnaildata = '". $DB_site->escape_string($thumbnail)."'";
$image['insert'] = "'".$DB_site->escape_string($thumbnail)."',";


Replace that with:

if ($thumbnail)
{
$image['update'] = ", thumbnaildata = '$thumbnail'";
$image['insert'] = "'$thumbnail',";


and then in admincp/albumcp.php find:

$DB_site->query("
UPDATE " . TABLE_PREFIX . "customprofilepic
SET thumbnaildata = '" . $DB_site->escape_string($thumbnail) . "'
WHERE picture_id = $image[picture_id]
");


and replace it with:

$DB_site->query("
UPDATE " . TABLE_PREFIX . "customprofilepic
SET thumbnaildata = '$thumbnail'
WHERE picture_id = $image[picture_id]
");

[indiamike]

THANK YOU Slynderdale!!

Fixes applied and it works.

Thank you, thank you, thank you. :) :) :)

http://www.indiamike.com/india/album.php

For those applying these changes make sure that you empty your browsers cache or you may not see the results immediately.

Thank you again it works dammit....it works :)

Mike

[Onkel_Tom]

Many thanks to Slynderdale !
your fix has done it ;)

[Ted S]

Awesome! Out of 1100 photos atleast 85% built properly with this new code which is a lot better than 0%!!! Hopefully the hack creator can include this all in an update along with some system to have multiple pages in the acp for verrifying photos. Thanks!

[Zelda-King]

Just a note to say the posts I'd made about not seeing other's profile pics' are void now I've discovered what was going on and it had nothing to do with this hack.

[Slynderdale]

Working out a couple bugs if you have it so attachments are saved to the file system and writing some code that lets you rebuild the album thumbnails.

Make my above fixes, that will fix images from being escapes twice. The image gets escaped already if you have it so your attachments are saved in the MySQL data base. This would cause errors with the thumbnails. The thumbnail doesn't get escaped when you save the files to the file system so this code fixes that and also fixes a small bug if theres an error with the thumbnail.


After you installed this hack and weasles fix,
find in path/to/forums/includes/functions_upload.php:

if ($type == 'profilepic')
{
require_once('./includes/functions_image.php');

$image['name'] = $upload_name;
$image['tmp_name'] = $filename;

$thumbnail = fetch_thumbnail_from_image($image);
$thumbnail = $thumbnail['filedata'];

// Display thumbnail error to admins in an attempt to cut down on support requests due to failed thumbnails.
if (!$thumbnail AND $imageerror AND $permissions['adminpermissions'] & CANCONTROLPANEL)
{
eval('$error = "' . fetch_phrase($imageerror, PHRASETYPEID_ERROR) . '";');
$errors[] = array(
'filename' => $attachment_name,
'error' => $error
);
}
}


and replace it with:

if ($type == 'profilepic')
{
require_once('./includes/functions_image.php');

$image['name'] = $upload_name;
$image['tmp_name'] = $filename;

$thumbnail = fetch_thumbnail_from_image($image);
$imageerror = $thumbnail['imageerror'];
$thumbnail = $thumbnail['filedata'];

if ($vboptions['attachfile'])
{
$thumbnail = $DB_site->escape_string($thumbnail);
}

// Display thumbnail error to admins in an attempt to cut down on support requests due to failed thumbnails.
if (!$thumbnail AND $imageerror AND $permissions['adminpermissions'] & CANCONTROLPANEL)
{
eval('$error = "' . fetch_phrase($imageerror, PHRASETYPEID_ERROR) . '";');
$errors[] = array(
'filename' => $attachment_name,
'error' => $error
);
}
}


The rebuilding of the album thumbnails code is almost done.

[MissKalunji]

Working out a couple bugs if you have it so attachments are saved to the file system and writing some code that lets you rebuild the album thumbnails.

Make my above fixes, that will fix images from being escapes twice. The image gets escaped already if you have it so your attachments are saved in the MySQL data base. This would cause errors with the thumbnails. The thumbnail doesn't get escaped when you save the files to the file system so this code fixes that and also fixes a small bug if theres an error with the thumbnail.

After you installed this hack and weasles fix, find:

if ($type == 'profilepic')
{
require_once('./includes/functions_image.php');

$image['name'] = $upload_name;
$image['tmp_name'] = $filename;

$thumbnail = fetch_thumbnail_from_image($image);
$thumbnail = $thumbnail['filedata'];

// Display thumbnail error to admins in an attempt to cut down on support requests due to failed thumbnails.
if (!$thumbnail AND $imageerror AND $permissions['adminpermissions'] & CANCONTROLPANEL)
{
eval('$error = "' . fetch_phrase($imageerror, PHRASETYPEID_ERROR) . '";');
$errors[] = array(
'filename' => $attachment_name,
'error' => $error
);
}
}


and replace it with:

if ($type == 'profilepic')
{
require_once('./includes/functions_image.php');

$image['name'] = $upload_name;
$image['tmp_name'] = $filename;

$thumbnail = fetch_thumbnail_from_image($image);
$imageerror = $thumbnail['imageerror'];
$thumbnail = $thumbnail['filedata'];

if ($vboptions['attachfile'])
{
$thumbnail = $DB_site->escape_string($thumbnail);
}

// Display thumbnail error to admins in an attempt to cut down on support requests due to failed thumbnails.
if (!$thumbnail AND $imageerror AND $permissions['adminpermissions'] & CANCONTROLPANEL)
{
eval('$error = "' . fetch_phrase($imageerror, PHRASETYPEID_ERROR) . '";');
$errors[] = array(
'filename' => $attachment_name,
'error' => $error
);
}
}


The rebuilding of the album thumbnails code is almost done.


IN wich file should i replace?

[Onkel_Tom]

It's in file /includes/functions_upload.php

[Slynderdale]

IN wich file should i replace?
Oops, I'll update my above fix, its:
path/to/forums/includes/functions_upload.php

[Zelda-King]

I tested the fixes. Just to confirm they seem to be running ok on 3.0.3.

[58sniper]

Ok, I still can't get this to work. I originally had the problem with a clean install on 3.03 of it showing the avatars.

I've uploaded the two updated files, and applied the changes from posts 301, 306, and 310. Now, I get broken images, with the URLs being something like
http://www.mydomain.com/forum/image.php?u=1&type=pthumb

What am I missing here?

[Slynderdale]

Another small bug fix. This is a small fix for those who are storing attachments in the file system. This will cause thumbnails to be rebuilt inccorrectly from albumcp.php.

Note: Install Weasles fixed files and my updates above first.

In admincp/albumcp.php find:


$thumbnail = fetch_thumbnail_from_image($fileinfo);
$thumbnail = $thumbnail['filedata'];


and add under it:


if ($vboptions['attachfile'])
{
$thumbnail = $DB_site->escape_string($thumbnail);
}

[Slynderdale]

Ok, I still can't get this to work. I originally had the problem with a clean install on 3.03 of it showing the avatars.

I've uploaded the two updated files, and applied the changes from posts 301, 306, and 310. Now, I get broken images, with the URLs being something like
http://www.mydomain.com/forum/image.php?u=1&type=pthumb

What am I missing here?
Try rebuilding the picture thmbnails using admincp/albumcp.php and see if that fixes your problem, if not, PM me the link to your album.

[Pseudomizer]

Hi Slynderdale,

could you please create one file where you enter all your and Weasles changes? This is getting weird now and too many people describe too many different situations.

Could this be done please?

And the best option would be:

Option 1: For DB users

Option 2: For Filesystem users

Thanks in advance.

Cheers,

[MissKalunji]

Try rebuilding the picture thmbnails using admincp/albumcp.php and see if that fixes your problem, if not, PM me the link to your album.



IT works!!!!!!!!! thank you

* MissKalunji click install

[MissKalunji]

Where do i go to change the size of the pictures???

[PitchouneN64ngc]

Where do i go to change the size of the pictures???
You can change the limit size of profile pictures in each usergroup.

[58sniper]

Try rebuilding the picture thmbnails using admincp/albumcp.php and see if that fixes your problem, if not, PM me the link to your album.

Okay, looks like this was some rogue caching issue. Once I got sorted out, it wsa working fine. Very nice hack!

[MissKalunji]

You can change the limit size of profile pictures in each usergroup.


Thank you :nervous:

[Slynderdale]

Hi Slynderdale,

could you please create one file where you enter all your and Weasles changes? This is getting weird now and too many people describe too many different situations.

Could this be done please?

And the best option would be:

Option 1: For DB users

Option 2: For Filesystem users

Thanks in advance.

Cheers,The fixes I've been posting work in both DB and Filesystem users. A couple fixes were added mainly for filesystem users and DB users shouldn't worry about them unless they plan to use the Filesystem in the future. Wanted to make the fixes compatible for both users. Also I'll uploaded a zip file of all my fixes and edits.

[kira]

Thanks, Slynderdale! But I'm confused.

Also I'll uploaded a zip file of all my fixes and edits.

(Bolding mine) Does this mean your latest zip file doesn't incorporate Weasel's changes too, as Pseudomizer mentioned in his request? I'm so confused! I can't figure out who's done what to this hack, what with three different zip files of hack instructions and changed files!

(Edited 'cause my thumbs are working now!)

[Slynderdale]

Thanks, Slynderdale! But I'm confused.



(Bolding mine) Does this mean your latest zip file doesn't incorporate Weasel's changes too, as Pseudomizer mentioned in his request? I'm so confused! I can't figure out who's done what to this hack, what with three different zip files of hack instructions and changed files!

(Edited 'cause my thumbs are working now!)
It contains Weasels fixes as well as mine.

[venomx]

Ok I tried this on vb3.0.3 and the small image doesnt show. I tried to rebuild in admin and I get a page with just this in the source..

<!-- START CONTROL PANEL FOOTER -->
<p align="center"><a href="http://www.vbulletin.com/" target="_blank" class="copyright">vBulletin v3.0.3, Copyright &copy;2000-2004, Jelsoft Enterprises Ltd.</a></p>
</div>
</body>
</html>

[venomx]

If I View/Prop.. in IE for the thumbnail and copy the url of the image and then paste it to IE and hit enter I get this in the window..
Array

I have GD2 and its on in the admin.. :(

[venomx]

Ok just got one problem.. thumbnails dont show :(

[venomx]

Ok mine doesnt show but a test accounts does...

[Nordinho]

Hello,

When I try to run the sql-queries, I get this error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';
ALTER TABLE `customprofilepic` ADD comment varchar(255) NOT

Does anyone have an idea how to fix this??

Greets,

[Nordinho]

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';
ALTER TABLE `customprofilepic` ADD comment varchar(255) NOT

Anyone???

[Ganon]

I'm getting broken images for all of them, even after trying to rebuild thumbnails. I have GD version 2+ and I followed all the installation instructions exactly. Any ideas?

[Pseudomizer]

I'm getting broken images for all of them, even after trying to rebuild thumbnails. I have GD version 2+ and I followed all the installation instructions exactly. Any ideas?

https://vborg.vbsupport.ru/showpost.php?p=548467&postcount=320

or scroll up to the top.

Cheers,

[Ganon]

Got it working now, thanks!

[venomx]

I am getting a brpken image for members that do NOT have a image uploaded. This shows in the admin and on the album.... Any fixes?

[PitchouneN64ngc]

Just a suggestion :)

After you applied modifications into ./profile.php file, when you want to upload a picture and you have never picture uploaded before, you have a part of the 'modifyprofilepic' template who appears. This corresponding with this php code:

$profilepic = $DB_site->query_first("
SELECT userid, dateline, comment, visible, disapproved, reason
FROM " . TABLE_PREFIX . "customprofilepic
WHERE userid = $bbuserinfo[userid]
");

$profilepic['comment'] = fetch_censored_text($profilepic['comment']);
$show['profilepic'] = iif($profilepic, true, false);

It is possible to hide this part of the template?

[Pseudomizer]

Just a suggestion :)

After you applied modifications into ./profile.php file, when you want to upload a picture and you have never picture uploaded before, you have a part of the 'modifyprofilepic' template who appears. This corresponding with this php code:

$profilepic = $DB_site->query_first("
SELECT userid, dateline, comment, visible, disapproved, reason
FROM " . TABLE_PREFIX . "customprofilepic
WHERE userid = $bbuserinfo[userid]
");

$profilepic['comment'] = fetch_censored_text($profilepic['comment']);
$show['profilepic'] = iif($profilepic, true, false);

It is possible to hide this part of the template?

This php code will never be visible in the template. Or do you want to hide the output of this php code via template? Please clarify.

Cheers,

[PitchouneN64ngc]

After i have made modifications into ./profile.php, i have like i have posted in attachment (profilepic.jpg).

And i have this code for the editprofilepic do into the profile.php file:

if ($_REQUEST['do'] == 'editprofilepic')
{
if ($vboptions['profilepicenabled'] AND ($permissions['genericpermissions'] & CANPROFILEPIC))
{
$profilepic = $DB_site->query_first("
SELECT userid, dateline, comment, visible, disapproved, reason
FROM " . TABLE_PREFIX . "customprofilepic
WHERE userid = $bbuserinfo[userid]
");
$profilepic['comment'] = fetch_censored_text($profilepic['comment']);
$show['profilepic'] = iif($profilepic, true, false);
$permissions['profilepicmaxsize'] = vb_number_format($permissions['profilepicmaxsize'], 1, true);

// draw cp nav bar
construct_usercp_nav('profilepic');
$navbits[''] = $vbphrase['edit_profile_picture'];
$templatename = 'modifyprofilepic';
}
else
{
print_no_permission();
}
}

And I have no entries in the table customprofilepic.

[zer026]

This hack has too many issues...and considering vb already displays a member's profile pic on the memberlist(if enabled in ACP), all of this struggling seems rather odd. I apologize if i seem negative, it''s just an opinion and doesn't really count anyway...right on.

[Ted S]

zer026,
I have the hack working fine and it only took following one person's changes. If you don't like it and don't find it functional then don't use it... no one needs every hack out there.

[PitchouneN64ngc]

I have resolved my problem ^^

On the ./profile.php file, you have this part of the code:

$profilepic['comment'] = fetch_censored_text($profilepic['comment']);

$show['profilepic'] = iif($profilepic, true, false);

You must to change this 2 lines like this:

$show['profilepic'] = iif($profilepic, true, false);

$profilepic['comment'] = fetch_censored_text($profilepic['comment']);

And all is ok ;)

[joergh]

Great hack,

I used the old member hack in vb2. After upgrading to vb3 i didn?t had the gallery live for months:

Today I tried to (re)install it on a vb3.0.3:

1) I used this file:

https://vborg.vbsupport.ru/showpost.php?p=548467&postcount=320

2) then I used the migrating tool from Pseudomizer: THX!

https://vborg.vbsupport.ru/showpost.php?p=503583&postcount=76

Everything went well!

If you like to see it:

http://www.revierloewenfans.de/forums/album.php

joergh :)

[FleaBag]

Works like a dream right out of the box!

[venomx]

Mine is showing a Red X for members without a pic for some reason :(

Any ideas?
http://www.discussionjunction.com/forums/album.php

[FleaBag]

I don't see any red crosses?

[maddawg138]

2 problems still

1. half of the pics still dont show up even after doing all the updates

2. admin cp still doesnt show any of the thumbnails

ive done all the updates and what not and still nothing

http://happymojo.com/forum/album.php theres the link to the album

P.S. I still need to edit the template so it'll fit the album the right way...just too lazy to go do it right now

[FleaBag]

If you have installed this before here's my advice...

Use clean vB3 files, follow all the instructions in the instruction file - run the 2 update queries - bingo, it'll work. :)

[venomx]

I don't see any red crosses?


Maybe its because I am Admin?

[FleaBag]

I was thinking the same thing, but I couldn't say for sure.

[maddawg138]

nvm i forgot to clear my cookies and clean my cache...its fine now

[Dead End Society]

Hello,

When I try to run the sql-queries, I get this error:


An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';
ALTER TABLE `customprofilepic` ADD comment varchar(255) NOT

Does anyone have an idea how to fix this??

Greets,
I solved this problem by executing each SQL command (line) separately, leaving out the semicolon. There's got to be an easier way, but oh well, it worked.

[nautiqeman]

Is there any way to change the fact that people can only upload just one?

[FleaBag]

OK so maybe I jumped the gun... I just get clear like images when users update their profile pictures... In the profile they show up fine, so it's something to do with the thumbnails I guess...

[Reeve of shinra]

hmmm I am getting an error where only red-x's show up. I rebuilt the thumbnails and while on that page, I click the link to a members thumbnail and it gives me an error saying that "http://www.shinraonline.com/board/image.php?u=1570&type=pthumb" cant be displayed because of errors. Any idea on what it refers to?

[Slynderdale]

hmmm I am getting an error where only red-x's show up. I rebuilt the thumbnails and while on that page, I click the link to a members thumbnail and it gives me an error saying that "http://www.shinraonline.com/board/image.php?u=1570&type=pthumb" cant be displayed because of errors. Any idea on what it refers to?

If you use vBulletin 3.0.3 try the fixes here:
https://vborg.vbsupport.ru/showpost.php?p=548467&postcount=320

[Boofo]

Has anyone come up with a way to send an pm or email to the Admin when someone uploads a pic that needs to be verified?

[Reeve of shinra]

Slynderdale -- thanks. I will check it out this weekend when I have a chance. I dont know how I missed that. :-p

[Slynderdale]

Slynderdale -- thanks. I will check it out this weekend when I have a chance. I dont know how I missed that. :-p

Remember to rebuild the thumbnails after you install the fixes in that file for them to show properly.

[HarryBO]

After 3 hours hard work, the Hack runs perfect!

Just one question? See the Screenshot!

Is there something missing?

[PitchouneN64ngc]

Have you executed all queries?

[HarryBO]

Yes, but I became an error message!

This part doesn?t work

INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9231, 0, 'settinggroup_vb3album', 'vB3 Member Album', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9232, 0, 'setting_album_perpage_title', 'Entries Per Page', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9233, 0, 'setting_album_perpage_desc', 'Specify how many entries will show for each page.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9234, 0, 'setting_album_pertr_title', 'Entries Per Row', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9235, 0, 'setting_album_pertr_desc', 'Specify how many entries will show for each row.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9236, 0, 'setting_album_approval_title', 'Require Approval', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9237, 0, 'setting_album_approval_desc', 'If selected, pictures will have to be approved via the AdminCP before visible by the public.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9238, 0, 'setting_album_exempt_title', 'Exempted Usergroups', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9239, 0, 'setting_album_exempt_desc', 'If you have approval enabled, but would like specific usergroups to be exempt from it, then <u>in a comma separated list</u>, specify those usergroup IDs.', 5000);

[PitchouneN64ngc]

Try this:

INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'settinggroup_vb3album', 'vB3 Member Album', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_perpage_title', 'Entries Per Page', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_perpage_desc', 'Specify how many entries will show for each page.', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_pertr_title', 'Entries Per Row', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_pertr_desc', 'Specify how many entries will show for each row.', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_approval_title', 'Require Approval', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_approval_desc', 'If selected, pictures will have to be approved via the AdminCP before visible by the public.', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_exempt_title', 'Exempted Usergroups', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_exempt_desc', 'If you have approval enabled, but would like specific usergroups to be exempt from it, then <u>in a comma separated list</u>, specify those usergroup IDs.', 5000);

[HarryBO]

Fehler

SQL-Befehl :

INSERT INTO `phrase` ( `languageid` , `varname` , `text` , `phrasetypeid` )
VALUES ( 0, 'settinggroup_vb3album', 'vB3 Member Album', 5000 )

MySQL meldet:


#1062 - Duplicate entry 'settinggroup_vb3album-0-5000' for key 2

Same as before!

[PitchouneN64ngc]

No, this query was executed successfully during the first attempt (during the installation).

Try the other queries and see if all is ok after :)

[HarryBO]

Yor?re my personal Jesus! Big Thx that works! :D

[HarryBO]

Argh! I´ve found some error again! When User Update there Pic, it would be changed in ACP! There´s ever there first postet Pic!

[Hades-1]

these ae my errors, i swear to god i tried eveythign inthis thread and nothing works, please help.

Invalid SQL:
SELECT customprofilepic.*, user.username
FROM vb3_customprofilepic
LEFT JOIN vb3_user
USING (userid)
ORDER BY username

mysql error: Unknown table 'customprofilepic'

ALSO

Warning: Division by zero in /home/rvadmin/public_html/x-six/V.3/VB3/album.php on line 142

Warning: Division by zero in /home/rvadmin/public_html/x-six/V.3/VB3/includes/functions.php on line 1730
Invalid SQL:
SELECT user.userid, dateline,
comment, user.username, user.usertitle,
user.joindate, user.usergroupid
FROM vb3_customprofilepic
LEFT JOIN vb3_user USING (userid)
WHERE visible=1

ORDER BY posts desc
LIMIT 0,

I even ran the entire installation again, someone help please

[ecarabin]

Hi all, here's my first post.

Thanx for this hack. ^_^

I'm trying to install it on my board, and it seems to work. ( I installed the fixed version for 3.0.3 )
The queries were successfully executed, the first look at the album was ok ...

But I have some troubles

* In the Admincp, I just get red crosses for new picture profiles that have to be approved

* In the album, some of new pictures are ok, but some just show red crosses. I dont really understand.

* When I try type2 ( should show signatures ) I get this error


Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT user.userid, user.username, user.usergroupid,
user.usertitle, usertextfield.signature, usertextfield.sigdateline,
avatar.avatarpath, user.avatarrevision, NOT ISNULL(customavatar.avatardata) AS hascustomavatar,
customavatar.dateline AS avatardateline
FROM vb3_user
LEFT JOIN vb3_usertextfield AS usertextfield
USING (userid)
LEFT JOIN vb3_avatar AS avatar
ON(avatar.avatarid = user.avatarid)
LEFT JOIN vb3_customavatar AS customavatar
ON(customavatar.userid = user.userid)
WHERE usertextfield.signature!=''
ORDER BY posts desc
LIMIT 0, 18

mysql error: Unknown table 'user' in field list

mysql error number: 1109


I don't understand, since the table vb3_user exists ?!

An idea please ? ^_^

( sorry if there are english mistakes, I'm french ).

[Boofo]

Hi all, here's my first post.

Thanx for this hack. ^_^

I'm trying to install it on my board, and it seems to work. ( I installed the fixed version for 3.0.3 )
The queries were successfully executed, the first look at the album was ok ...

But I have some troubles

* In the Admincp, I just get red crosses for new picture profiles that have to be approved

* In the album, some of new pictures are ok, but some just show red crosses. I dont really understand.

* When I try type2 ( should show signatures ) I get this error


Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT user.userid, user.username, user.usergroupid,
user.usertitle, usertextfield.signature, usertextfield.sigdateline,
avatar.avatarpath, user.avatarrevision, NOT ISNULL(customavatar.avatardata) AS hascustomavatar,
customavatar.dateline AS avatardateline
FROM vb3_user
LEFT JOIN vb3_usertextfield AS usertextfield
USING (userid)
LEFT JOIN vb3_avatar AS avatar
ON(avatar.avatarid = user.avatarid)
LEFT JOIN vb3_customavatar AS customavatar
ON(customavatar.userid = user.userid)
WHERE usertextfield.signature!=''
ORDER BY posts desc
LIMIT 0, 18

mysql error: Unknown table 'user' in field list

mysql error number: 1109


I don't understand, since the table vb3_user exists ?!

An idea please ? ^_^

( sorry if there are english mistakes, I'm french ).
Try changing:

FROM vb3_user

to

FROM vb3_user AS user

[Hades-1]

Working out a couple bugs if you have it so attachments are saved to the file system and writing some code that lets you rebuild the album thumbnails.

Make my above fixes, that will fix images from being escapes twice. The image gets escaped already if you have it so your attachments are saved in the MySQL data base. This would cause errors with the thumbnails. The thumbnail doesn't get escaped when you save the files to the file system so this code fixes that and also fixes a small bug if theres an error with the thumbnail.


After you installed this hack and weasles fix,
find in path/to/forums/includes/functions_upload.php:

if ($type == 'profilepic')
{
require_once('./includes/functions_image.php');

$image['name'] = $upload_name;
$image['tmp_name'] = $filename;

$thumbnail = fetch_thumbnail_from_image($image);
$thumbnail = $thumbnail['filedata'];

// Display thumbnail error to admins in an attempt to cut down on support requests due to failed thumbnails.
if (!$thumbnail AND $imageerror AND $permissions['adminpermissions'] & CANCONTROLPANEL)
{
eval('$error = "' . fetch_phrase($imageerror, PHRASETYPEID_ERROR) . '";');
$errors[] = array(
'filename' => $attachment_name,
'error' => $error
);
}
}


and replace it with:

if ($type == 'profilepic')
{
require_once('./includes/functions_image.php');

$image['name'] = $upload_name;
$image['tmp_name'] = $filename;

$thumbnail = fetch_thumbnail_from_image($image);
$imageerror = $thumbnail['imageerror'];
$thumbnail = $thumbnail['filedata'];

if ($vboptions['attachfile'])
{
$thumbnail = $DB_site->escape_string($thumbnail);
}

// Display thumbnail error to admins in an attempt to cut down on support requests due to failed thumbnails.
if (!$thumbnail AND $imageerror AND $permissions['adminpermissions'] & CANCONTROLPANEL)
{
eval('$error = "' . fetch_phrase($imageerror, PHRASETYPEID_ERROR) . '";');
$errors[] = array(
'filename' => $attachment_name,
'error' => $error
);
}
}


The rebuilding of the album thumbnails code is almost done.


what do i do if neither of these codes are in functions_upload?

can someon post their functions_upload file for this hack?

[Pseudomizer]

i hate you all

all people care about is themselves, everyone just ignores other peopls problems and posts and goes ahead and posts their own.

I could help but go to hell instead!!

Hello Hades,


these are not nice words. If you would have read the thread you should have seen that the checkbox "supported" is NOT checked. If you install a hack where the author didn't check this box, you should not expect that people will run to help you. All people here are not paid for support.

So pleaes don't blame people here like this and calm down. ;-)


Try Bofo's hints because he is very experienced in coding.

Cheers,

[Hades-1]

Hello Hades,


these are not nice words. If you would have read the thread you should have seen that the checkbox "supported" is NOT checked. If you install a hack where the author didn't check this box, you should not expect that people will run to help you. All people here are not paid for support.

So pleaes don't blame people here like this and calm down. ;-)


Try Bofo's hints because he is very experienced in coding.

Cheers,

yeah i know and i did not mean the author.

it seems like people post a problem but it get burried by other people who dont even to read to see if its the same as theirs and they dont care, they dont care if you die they just want their album to work and i hate that.

[ecarabin]

* Thank you Boofo ! now it works fine !
Merci beaucoup :-)

* Hades I did read all posts of this topic before posting.
Not answering you didn't mean I didn't care about your problem.
If I could have helped you ... I would have done it !
but I really don't know what to do !!
I even find my question stupid now that I see it was so easy ... :-(

So even if I go to hell, I wish someone could help you.

bye.

[Boofo]

* Thank you Boofo ! now it works fine !
Merci beaucoup :-)

* Hades I did read all posts of this topic before posting.
Not answering you didn't mean I didn't care about your problem.
If I could have helped you ... I would have done it !
but I really don't know what to do !!
I even find my question stupid now that I see it was so easy ... :-(

So even if I go to hell, I wish someone could help you.

bye.
For future reference, any time you have more than one table accessed in a query, you must have each table AS table. ;)

Glad I could help. ;)

[Boofo]

what do i do if neither of these codes are in functions_upload?

can someon post their functions_upload file for this hack?
That code is added in the hack. Look at the install.html file and you will see it needs to be added first. ;)

[Hades-1]

That code is added in the hack. Look at the install.html file and you will see it needs to be added first. ;)

no what i ment was the directions were like

replace

blah blah

with

blah blah blah blah

but neither were int he file so i wanted to see what someone elses looks like, but instead i am going to unzip it form the original zip and hack it

thanks for the help and sorry for being rude it was not intended.

[Hades-1]

i take it back i need help

the gallery works except for images the are linked, i did every file edit here, i download the vb 3.0.3 fix zip and everything.

If some uploads it works, if they link it shows red x or whatever.

I thought if i edit the upload picture page and made it say "if you want your image to appear in the gallery you must upload it from your pc"

but that did'nt work because when they do that it shows red x on gallery so there is a bunch of red x's for all the linked images.

Any ideas?

[engquist]

i take it back i need help


the gallery works except for images the are linked, i did every file edit here, i download the vb 3.0.3 fix zip and everything.

If some uploads it works, if they link it shows red x or whatever.

I thought if i edit the upload picture page and made it say "if you want your image to appear in the gallery you must upload it from your pc"

but that did'nt work because when they do that it shows red x on gallery so there is a bunch of red x's for all the linked images.

Any ideas?

I have a gallery full of red x's too, can we fix this? Even if I reupload a pic, it's still a red x, but it's not a red x on the memberlist

I have VBulletin 3.0.3

[engquist]

Now I've tried Slynderdale's fixes that were in that zip.

When I did that, I made all file chages again, then I got to the database part to do those changes again. I executed all those queries again (I assumed there were changes) and then it told me that they already existed so the query didn't finish or something.

so I ignored it. Then I finished the directions, and I still have red x's for pictures.

I decided I would try to re-upload my profile pic as a test. So I deleted in in my user CP, then I went to re-upload it and I got a database error something like this:


Database error in vBulletin 3.0.3:

Invalid SQL:
INSERT INTO customprofilepic
(userid, profilepicdata, thumbnaildata, comment, visible, thumbnaildata, comment, visible, dateline, filename, filesize)
VALUES


mysql error: Column count doesn't match value count at row 1

mysql error number: 1136



can someone help me by giving me some sql queries I need to run so at least people can add profile pictures again without a database error, because I don't know any SQL.

thank you.

[paulmjno]

Having a prob: everything works fine, with the exception of the actual profile pics in the member album and in the album cp. The images do not display. I rebuilt the album thumbnails.

The image src's are: /path/to/foum/image.php?u=2132&type=pthumb

When I visit that URL, I get a page which displays: Array

[paulmjno]

Hm... I realise that this is yet another unsupported script... *uninstalling*

[Pseudomizer]

Hm... I realise that this is yet another unsupported script... *uninstalling*

Before you unistall it please read the thread. Your problem has been asked 19223462346 times. RTFM.

Cheers,

[paulmjno]

Before you unistall it please read the thread. Your problem has been asked 19223462346 times. RTFM.

Cheers,
Could you direct me to where the full fix is? And, why hasn't the zip file been updated with the fix?

I am using 3.0.3.

[Pseudomizer]

Could you direct me to where the full fix is? And, why hasn't the zip file been updated with the fix?

I am using 3.0.3.

I would have to search on my own. Sorry. And the reason why it is not in the zip file is very easy... unsupported thread but great hack.

Cheers,

[paulmjno]

OK, I downloaded the zip file, and made the changes. Things are better, but not completely fine. For instance, most pics show... but a few dont. Also, the signature dates are set to 1970...

[mackers8923]

I'm getting nothing but Red "X's" where the images should be. Is there a fix for this or have I missed something?

[engquist]

Now I've tried Slynderdale's fixes that were in that zip.

When I did that, I made all file chages again, then I got to the database part to do those changes again. I executed all those queries again (I assumed there were changes) and then it told me that they already existed so the query didn't finish or something.

so I ignored it. Then I finished the directions, and I still have red x's for pictures.

I decided I would try to re-upload my profile pic as a test. So I deleted in in my user CP, then I went to re-upload it and I got a database error something like this:


Database error in vBulletin 3.0.3:

Invalid SQL:
INSERT INTO customprofilepic
(userid, profilepicdata, thumbnaildata, comment, visible, thumbnaildata, comment, visible, dateline, filename, filesize)
VALUES


mysql error: Column count doesn't match value count at row 1

mysql error number: 1136



can someone help me by giving me some sql queries I need to run so at least people can add profile pictures again without a database error, because I don't know any SQL.

thank you.

this is my issue if anyone can help ^^ *BUMP*

[Hades-1]

what i say is.....

finish this hack, or take it off this site.

its 100% im complete and probably just messing up most peoples boards.

I got this hack working as good as possible and it still sucks.

So i am removing it, what a waste.

[venomx]

This hack works fine for me.

[Natch]

what i say is.....

finish this hack, or take it off this site.

its 100% im complete and probably just messing up most peoples boards.

I got this hack working as good as possible and it still sucks.

So i am removing it, what a waste.
And for me...

[Slynderdale]

This hack does work, if you look above, this hack was made for vB 3.0.0, any versions higher then that, your basicly installing it at your own risk. There has been several changes to vB 3.0.3 that breaks this hack. I included some fixes for it that worked on my 3.0.3 after a clean install.


If you have an old member gallery 1.1, theres a migrating tool here that lets you migrate your old album over to the new one:
https://vborg.vbsupport.ru/showpost.php?p=503583&postcount=76

If you have vBulletin 3.0.3, do a clean install with these fixes I posted here:
https://vborg.vbsupport.ru/showpost.php?p=548467&postcount=320

After you made these changes, you will have to rebuild the thumbnails to get them to show without coming up as an error or a red x. After doing so, clear your browsers cache and refresh the page.

If you already installed this hack, but not my fix above, first install weasel's update here:
https://vborg.vbsupport.ru/showpost.php?p=546244&postcount=281

and then make the updates in the posts on this page or could do a fresh install with the fixed version above which is recommended:
https://vborg.vbsupport.ru/showthread.php?t=63733&page=21&pp=15

Note: If you already ran the SQL queries, you don't have to do so again. Only file changes are needed to get this hack to work for 3.0.3. This isn't my hack, but Ill try to give limited support for 3.0.3 forums when I can. I was hit by a car in a hit and run incident the other day so I haven't been able to use the computer without being in some pain the past couple days.

[docvader]

Installed easily and working well on 3.03. Thanks very much!

rich
http://x.russbo.com/index.php

[MikaK]

Nice hack for the very purpose. I started installing this on 303 based on the original hack... Boy... I suffered tearing hair off my head... Untill I came a cross the 303 -fix.zip by Sly... err... something (too darn tired to remeber) + a comment by Boofo and the sun started to shine - and that made my day:D

Thanks!*installs*
-Mika-

[tobkat]

I've installed the Hack successfully and it seems to work. I tried to upload a picture with the admin account but the picture won't show up in the album. the name "admin" is displayed but there is no picture beside it. help, anyone ?

[tobkat]

Now I've tried Slynderdale's fixes that were in that zip.

When I did that, I made all file chages again, then I got to the database part to do those changes again. I executed all those queries again (I assumed there were changes) and then it told me that they already existed so the query didn't finish or something.

so I ignored it. Then I finished the directions, and I still have red x's for pictures.

I decided I would try to re-upload my profile pic as a test. So I deleted in in my user CP, then I went to re-upload it and I got a database error something like this:


Database error in vBulletin 3.0.3:

Invalid SQL:
INSERT INTO customprofilepic
(userid, profilepicdata, thumbnaildata, comment, visible, thumbnaildata, comment, visible, dateline, filename, filesize)
VALUES


mysql error: Column count doesn't match value count at row 1

mysql error number: 1136



can someone help me by giving me some sql queries I need to run so at least people can add profile pictures again without a database error, because I don't know any SQL.

thank you.


Same Problem here....

[Boofo]

Same Problem here....
List that whole query and maybe we can look at it. What are the values? ;)

[boo.3]

ok for the GD Graphics Library how do i know if i have it?

[PitchouneN64ngc]

ok for the GD Graphics Library how do i know if i have it?
View your phpinfo if it says "GD" inside :)

[MajorFm.com]

Im gettin a small error...

When i rebuild the thumbs, it displays the list on a white page without any styles and then goes stagnant, nothing happens...

And the images are not showing...

www.majorfm.com/forum/album.php

[MajorFm.com]

In vBulletin 3.0.3 the thumbnail code changed a bit so invalid thumbnails were made.

If you already installed this hack and Weasel's update:
( Weasles update can be found here: https://vborg.vbsupport.ru/showpost.php?p=546244&postcount=281 )
In the file path/to/forums/includes/functions_upload.php, find

if ($thumbnail)
{
$image['update'] = ", thumbnaildata = '". $DB_site->escape_string($thumbnail)."'";
$image['insert'] = "'".$DB_site->escape_string($thumbnail)."',";


Replace that with:

if ($thumbnail)
{
$image['update'] = ", thumbnaildata = '$thumbnail'";
$image['insert'] = "'$thumbnail',";


and then in admincp/albumcp.php find:

$DB_site->query("
UPDATE " . TABLE_PREFIX . "customprofilepic
SET thumbnaildata = '" . $DB_site->escape_string($thumbnail) . "'
WHERE picture_id = $image[picture_id]
");


and replace it with:

$DB_site->query("
UPDATE " . TABLE_PREFIX . "customprofilepic
SET thumbnaildata = '$thumbnail'
WHERE picture_id = $image[picture_id]
");


I did these changes, still no luck... also... the link for Weasel's update seems to be a fresh install, which means i can't actually follow it as its asking me to find and replace items that have already been replaced...

I know this hack/thread is kinda old now... but i hope someone can help.

[boo.3]

ok i get this error and don't know why..

when you say run the querys.. i see it has space in some do u run the "3" or all of them 1 at a time? i ran 1 at a time

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

Warning: Division by zero in /home/*****/public_html/forums/includes/functions.php on line 1730


any idea what i did wrong?

[Pseudomizer]

ok i get this error and don't know why..

when you say run the querys.. i see it has space in some do u run the "3" or all of them 1 at a time? i ran 1 at a time

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

Warning: Division by zero in /home/*****/public_html/forums/includes/functions.php on line 1730


any idea what i did wrong?

This has been handled already in this thread ( if i am not wrong ).

Cheers,

[MajorFm.com]

any help with me...?

[Martin64]

Readded after upgrading from 3.0.0 to 3.0.4, works perfectly. Thanks. :)

[SiXXGuNNZ]

Im gettin a small error...

When i rebuild the thumbs, it displays the list on a white page without any styles and then goes stagnant, nothing happens...

And the images are not showing...

www.majorfm.com/forum/album.php (http://www.majorfm.com/forum/album.php)me too

vb 3.0.5 and newest version of hack

error: http://tehru.org/image.php?u=1&type=pthumb

gd is installed and working because it works with the attachment thumbs and registration system.

any help would be cool, since this hack looks like a bugger to try and reverse.

[Slynderdale]

me too

vb 3.0.5 and newest version of hack

error: http://tehru.org/image.php?u=1&type=pthumb

gd is installed and working because it works with the attachment thumbs and registration system.

any help would be cool, since this hack looks like a bugger to try and reverse.
The updates for 3.0.3 will most likely not work for 3.0.4 and greater. I believe they changed how thumbnails were handled with avatars and user images.

[MissKalunji]

The updates for 3.0.3 will most likely not work for 3.0.4 and greater. I believe they changed how thumbnails were handled with avatars and user images.


half of my thumbnail works on my album.....
n i just updated to 3.0.5

[SandsUSA]

Man, this "simple to install" hack sure needs an installer -- 30+ steps!? Hopefully an installer gets made -- I'll INSTALL it then.....

[ecarabin]

Upgraded my board, and it works fine on vB 3.0.5 :)

[aranthorn]

Thanks to Slynderdale for helping out

[FleaBag]

Can anyone else confirm it working with 3.0.5?

[MissKalunji]

Can anyone else confirm it working with 3.0.5?

i confirm i upgraded it to 3.0.5 n works even better then when i was on 3.0.3

[FleaBag]

OK so how did you do it, a fresh install? Or using the steps in this thread?

[MissKalunji]

OK so how did you do it, a fresh install? Or using the steps in this thread?


Fresh install with the template modification...

[FleaBag]

OK cool, time to sift through 28 pages lol.

[MorrisMcD]

I am getting the following after installing

Warning: Division by zero in C:\Inetpub\site.com\album.php on line 142

Warning: Division by zero in C:\Inetpub\site.com\includes\functions.php on line 1713



There seems to have been a slight problem with the Site database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

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

Date: Thursday 13th of January 2005 07:41:13 PM
Script: http://site.com/album.php
Referer:
Username: MorrisMcD
IP Address: x.x.x.x



Any ideas?

Thanks in advance

[Pseudomizer]

You should upgrade immediately to 3.0.5 before you start troubleshooting this old version. It will not help if you get the member album running and people hack your site.

Cheers,

[devilchill]

PLEASE HELP!

I get broken images for all the photos!
http://www.devilchill.com/forums/album.php

[Slynderdale]

PLEASE HELP!

I get broken images for all the photos!
http://www.devilchill.com/forums/album.php
What version of vbulletin are you using?

[MissKalunji]

What version of vbulletin are you using?

i have the same problem...i did all the fix running 3.0.5 half of the pics shows up and the othe rone just a red x....

see it here : www.dancehallareaz.com/forum/album.php

[devilchill]

3.0.5... the latest.

[MajorFm.com]

I would love this hack to work but no matter how many time i cried on this thread...

It was never fixed... gave up on it after a while...

[MissKalunji]

well i just did a rebuild n it works now i'de like to know....where do i fix how big the picture appears in the album.php??

[Oblivion Knight]

i have the same problem...i did all the fix running 3.0.5 half of the pics shows up and the othe rone just a red x....

see it here : www.dancehallareaz.com/forum/album.phpHmm, I notice that all the pics that are working are in .jpg format. Try clicking on a user profile where a red x is shown, right click and save their profile picture and see what format it attempts to save it as.

I suspect that this may be an issue with .gif or .png formats.. I could be wrong though.

[MorrisMcD]

You should upgrade immediately to 3.0.5 before you start troubleshooting this old version. It will not help if you get the member album running and people hack your site.

Cheers,

I upgrade my site to 3.0.5.. Made all the file edits and made sure the templates still existed..

album.php works now at least... But it doesnt have the pictures.. And exactly where is this linked from?

[MissKalunji]

I upgrade my site to 3.0.5.. Made all the file edits and made sure the templates still existed..

album.php works now at least... But it doesnt have the pictures.. And exactly where is this linked from?


rebuild your thumbnail and you should be good 2 go...

[MorrisMcD]

rebuild your thumbnail and you should be good 2 go...
Is that a template? I didnt see one.. I'm not sure what you mean.. Sorry

[MissKalunji]

Is that a template? I didnt see one.. I'm not sure what you mean.. Sorry


when you go into your admincp (on the left vb3 album....Verify picture you should see : rebuild profile picture thumbnail....i know it worked for me...if not you can also try the rebuild from the update counter (import maintenance) if you did everything you should be able... to find rebuild thumbnail there also))

hope that helps ;)

[MorrisMcD]

I dont have the GD enabled and to be quite honest, I am not sure what that is.. Or if I need something more before this hack will work...

:confused: Looks like I might have to read through this 29 page thread sometime :)

[MissKalunji]

I dont have the GD enabled and to be quite honest, I am not sure what that is.. Or if I need something more before this hack will work...

:confused: Looks like I might have to read through this 29 page thread sometime :)


go into your vbulletin and click on php info and check to see if php is enabled...if its not you will have to contact your provider and ask him to enable it you might have to pay for it

gd is for your thumbnails.....thats what generates thumbnail...

[MorrisMcD]

go into your vbulletin and click on php info and check to see if php is enabled...if its not you will have to contact your provider and ask him to enable it you might have to pay for it

gd is for your thumbnails.....thats what generates thumbnail...
Wouldnt PHP have to be enabled for anything to work? I actually host my own server.. I dont see anything is there about GD though.. In the server settings and optimization, it isnt set, but I didnt know if there was a prerequisite before turning it on.. That is all

Thanks for your replies BTW

[Pseudomizer]

Does a car need an engine? Does vbulletin need PHP?

Create a file calle phpinfo.php and write in there:

<?php
phpinfo();
?>


Open this file in your browser. Look for GD support. If you don't have it then you have to install it manually. Many PHP Versions have GD support built in but not all versions. You can configure it during the compilation of PHP.

All this are hosting questions and have nothing to do with VBulletin. So if you have any further questions please look in the appropriate places.

Cheers,

[MorrisMcD]

All this are hosting questions and have nothing to do with VBulletin. So if you have any further questions please look in the appropriate places.

Cheers,

It may not have anything to do with VBulletin. but it does have to do with this hack. Rather than responding like this, you could just as easily point me in the right direction

But thanks anyway

[Pseudomizer]

It may not have anything to do with VBulletin. but it does have to do with this hack. Rather than responding like this, you could just as easily point me in the right direction

But thanks anyway

Hello Morris,

google for GD support or GD installation manual. You will find a lot of places and manuals.

Cheers,

[Oblivion Knight]

Using Slynderdale's fixed zip here (https://vborg.vbsupport.ru/showpost.php?p=577786&postcount=388), this is working very well on 3.0.5.. :)


[EDIT]
I spoke to soon, the approval part of the mod isn't 100%.

[eblivion]

In albumcp.php



$images = $DB_site->query("

SELECT customprofilepic.*, user.username

FROM " . TABLE_PREFIX . "customprofilepic

LEFT JOIN " . TABLE_PREFIX . "user

USING (userid)

ORDER BY username




Should be:



$images = $DB_site->query("

SELECT " . TABLE_PREFIX . "customprofilepic.*, " . TABLE_PREFIX . "user.username

FROM " . TABLE_PREFIX . "customprofilepic

LEFT JOIN " . TABLE_PREFIX . "user

USING (userid)

ORDER BY username




Also, similar problem in album.php in both select statements.

[eblivion]

Fatal error: Call to undefined function: build_image() in /home/httpd/vhosts/URL/httpdocs/forum/includes/functions_upload.php on line 204



I'm was getting the call to undefined function: build_image() error too. I reverted the functions_upload.php file to what it was prior to modification and re-did it. It then worked.

My album thumbnail images are broken. The profile pics display properly, though. Does anyone know what is causing it to be broken. I do have GD 2+ installed and enabled on the forum.

[deta]

Hello

I have in addition times questions:

1. My MySQL tables is called thus always vb3_user..., a vb3 _ before it.
What here do I have to change, so that also then with me functions?

2. A Member Voting would not be bad. With announcement of the TopVotings for man and woman. Is that feasible?

cu Deta

[eblivion]

If the table is:

user

then you should change it to

" . TABLE_PREFIX . "user

Use the same format for all the table names.

[bbwlva]

I'm getting this error;
Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT user.userid, dateline,
comment, user.username, user.usertitle,
user.joindate, user.usergroupid
FROM vb3_customprofilepic
LEFT JOIN vb3_user USING (userid)
WHERE visible=1

ORDER BY posts desc
LIMIT 0, 18

mysql error: Unknown table 'user' in field list

mysql error number: 1109

Date: Tuesday 25th of January 2005 09:11:53 PM
Script: http://forums/album.php
Referer:

[Andreas]

In album.php FIND (2 instances)

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


REPLACE that with

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


FIND

FROM ".TABLE_PREFIX."customprofilepic


REPLACE that with

FROM ".TABLE_PREFIX."customprofilepic AS customprofilepic

FIND

LEFT JOIN ".TABLE_PREFIX."usertextfield


REPLACE that with

LEFT JOIN ".TABLE_PREFIX."usertextfield AS usertextfield


FIND

FROM ".TABLE_PREFIX."user


REPLACE that with

FROM ".TABLE_PREFIX."user AS user


This should take care of table prefixes.

[eblivion]

Does anyone know how to fix the broken images? I have GD 2+ andthe profile pictures show correctly on the memberlist and profile page,but all the images are broken in the album and the admincp.

[deta]

Does anyone know how to fix the broken images? I have GD 2+ andthe profile pictures show correctly on the memberlist and profile page,but all the images are broken in the album and the admincp.

The Same i have

[deta]

In album.php FIND (2 instances)

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


REPLACE that with

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


FIND

FROM ".TABLE_PREFIX."customprofilepic


REPLACE that with

FROM ".TABLE_PREFIX."customprofilepic AS customprofilepic

FIND

LEFT JOIN ".TABLE_PREFIX."usertextfield


REPLACE that with

LEFT JOIN ".TABLE_PREFIX."usertextfield AS usertextfield


FIND

FROM ".TABLE_PREFIX."user


REPLACE that with

FROM ".TABLE_PREFIX."user AS user


This should take care of table prefixes.

Hello

Now I changed in such a way, but now I get one mysql errors.
Before I still "AS user" an "AS.." attached hattte was not the error.
Only the pictures were not indicated.
Neither in the Admincp nor in the album

Ungueltige SQL-Abfrage:
SELECT vb3_user.userid, dateline, comment, vb3_user.username, vb3_user.usertitle, vb3_user.joindate, vb3_user.usergroupid
FROM vb3_customprofilepic AS customprofilepic
LEFT JOIN vb3_user AS user USING (userid)
WHERE visible=1

ORDER BY posts desc
LIMIT 0, 18

mysql error: Unknown table 'vb3_user' in field list

mysql error number: 1109

The tables are called with me all vb3 _ and are also present. Also the vb3 _ table.

cu Deta

[bbwlva]

Now I get this error in the albumcp

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT customprofilepic.*, user.username
FROM vb3_customprofilepic
LEFT JOIN vb3_user
USING (userid)
ORDER BY username

mysql error: Unknown table 'customprofilepic'

mysql error number: 1051

Date: Wednesday 26th of January 2005 02:39:33 AM
Script: http://forums/admincp/albumcp.php
Referer: http://forums/admincp/index.php?do=nav
Username: bbwlva
IP Address:

[eblivion]

Now I get this error in the albumcp

See: https://vborg.vbsupport.ru/showpost.php?p=600611&postcount=433

[bbwlva]

See: https://vborg.vbsupport.ru/showpost.php?p=600611&postcount=433
Now I get a parse error instead. :[

Also images arent even showing on the album.

[deta]

Hello,

after which I tinkered much and it does not go yet with the pictures,
now times the question.
I have the version 3.0.5 Vbulletin to to run.
What exact do I have to make in this version, which the pictures are indicated with me?
I have the GD2 on the Webserver.

At present I only one X get in the Gallerie indicated.

cu Deta

[eblivion]

PLEASE HELP!!!!!

I still cannot get the thumbnail images to display in the album or admincp, even though the profile pics display correctly.

I have GD2+ installed & enabled.

Do I have to enable attachment thumbnails in posts for the album to work?

If so, is there another way to get it to work because I want the regular sized pics in the posts, not thumbnails?

[deta]

PLEASE HELP!!!!!

I still cannot get the thumbnail images to display in the album or admincp, even though the profile pics display correctly.

I have GD2+ installed & enabled.

Do I have to enable attachment thumbnails in posts for the album to work?

If so, is there another way to get it to work because I want the regular sized pics in the posts, not thumbnails?


Hello I Fond the problem.
Look hier: https://vborg.vbsupport.ru/showpost.php?p=596684&postcount=432

You must install all Files, an alle Patches... inkl. Templates..

:-)

cu Deta

[eblivion]

Hello I Fond the problem.
Look hier: https://vborg.vbsupport.ru/showpost.php?p=596684&postcount=432

You must install all Files, an alle Patches... inkl. Templates..

:-)

cu Deta


Thanks. I still couldn't get the images to load after redoing it. Ijustended up displaying the actual profile picture instead of thethumbnail by changing type=pthumb to type=profile in albumcp.php and the album_image_list template.

[MustangLisa]

Thanks, this is great. Everything installed fine, but the profile pics display as red X 's. How can I fix this? Thanks.

[MissKalunji]

Thanks, this is great. Everything installed fine, but the profile pics display as red X 's. How can I fix this? Thanks.


theres a fix for that browse the msg board...theres a thread about it

[Megareus Rex]

theres a fix for that browse the msg board...theres a thread about it
What message board, where? I just installed this and I'm having the same problem.

EDIT: Oh, nvm, I went one page back in this thread and it had a link to a post with all the info required. It works fine now.

[MissKalunji]

What message board, where? I just installed this and I'm having the same problem.

EDIT: Oh, nvm, I went one page back in this thread and it had a link to a post with all the info required. It works fine now.


good 2 go :nervous:

[computer1]

I have tray to install this to v 3.0.6 but I dont nowe howe I can Create a new template can some one help me ??

[Pseudomizer]

I have tray to install this to v 3.0.6 but I dont nowe howe I can Create a new template can some one help me ??

RTFM = Read the f. manual. http://www.vbulletin.com

Cheers,

[VMV]

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT user.userid, dateline,
comment, user.username, user.usertitle,
user.joindate, user.usergroupid
FROM vb_customprofilepic
LEFT JOIN vb_user USING (userid)
WHERE visible=1

ORDER BY posts desc
LIMIT 0, 20

mysql error: Unknown table 'user' in field list

mysql error number: 1109

Date: Sunday 20th of February 2005 07:39:13 PM
Script: http://10.0.20.65/VB/album.php

[TomerK]

This Mod Work on 3.0.7 to?

[MissKalunji]

This Mod Work on 3.0.7 to?


yeah it does...even better ...

[venomx]

I got it to work in 3.0.7 but for some reason the images never show in the admincp when going to approve them....

[psico]

I got it to work in 3.0.7 but for some reason the images never show in the admincp when going to approve them....
I have the same problem, and in the profile the image is broken too...

[Pseudomizer]

Hello guys,

if I would like to add a short image next to each member name who has uploaded a profile pic in the showthread view, how would you implement something like this?

My understanding would be that it would do a query for each user to check if the blob data is in the DB and it would react upon the answer. This is fine if you would use this way of checking the DB for one pic but if you are viewing a thread with many postings of many users, this could kill your database performance.

Someone any idea how I could achieve this without killing my board?

Thanks in advance.

Cheers,

[venomx]

There is a hack for that right here on vb.org

[LambHyjoo]

edit : problem is solved !

[ianskate]

When it's confirmed that this works with 0.7 I am so installing this!

[MissKalunji]

There is a hack for that right here on vb.org

Do you knwo how its named?

[osariase]

Hi,
I love this hack especially when my users are looking for place to display their pictures to their friends and admirers after installing i get this error message when i click on verify pictures i get this error message below:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT customprofilepic.*, user.username
FROM nwvb3customprofilepic
LEFT JOIN nwvb3user
USING (userid)
ORDER BY username

mysql error: Unknown table 'customprofilepic'

mysql error number: 1051

Can someone please help me fix this problem I will really appreciate it

thanks alot

[Marco van Herwaarden]

Change the line:
FROM " . TABLE_PREFIX . "customprofilepic
LEFT JOIN " . TABLE_PREFIX . "user to:FROM " . TABLE_PREFIX . "customprofilepic AS customprofilepic
LEFT JOIN " . TABLE_PREFIX . "user AS user

[osariase]

Hi Marco,
after doing what you told me to do I think it fixed it but I cant see pictures on the admin cp and there is no link to the photo album. Do you think there is something I missed? Please advise

thanks for your help

[Marco van Herwaarden]

Just double check the instructions, or wait for the help of the coder.

Sorry i don't have this hack installed myself, so a bit difficult to help you more.

[osariase]

Hi VeloCD,
I have a problem with this hack, the problems keep shifting. I have installed and reinstalled this hack and I was able to see the admincp controls but I only have two options there, 1 is options and the 2nd one is verify pictures. I don't see anything else. When I click on the album link on the navbar i get an error message, please click below to see error message:

http://www.naijaworld.com/album.php


I would really appreciate it if you could help me, everybody seems to have it working except for me.

thanks

[osariase]

Hi all,
anyone here that have used this hack on vb3 successfully, please send me instructions on how to get this thing setup. I will really appreciate it, since he owner of the hack has suspended all support for the hack.

Anyone who think they can help me this hack please contact me at ozinetdot@yahoo.com

I get this error message whenever i try to run the queries requested in step #33, below is the error message

Error
SQL-query:

ALTER TABLE `customprofilepic` DROP PRIMARY KEY
MySQL said:

#1146 - Table 'naijawor_testvbdb.customprofilepic' doesn't exist


I have been getting this error message and I don't know what to do with it. If I am understanding this currectly it is saying customprofilepic doesn't exist which is true, but I do have something else

vb3_customprofilepic.

I am not sure if I should edit the query to match what I already have anyone please help thanks

I will appreciate it

[Marco van Herwaarden]

Seems you are using a table prefix and the hack script on't support that here. Edit the file and put your table prefix in fron of the table names.

[boeserwolf]

Does this hack work with the 3.07 too.

Not found a suitable answer here

yours

Markus

[MichaelJM13k]

Every time i try to install this hack i get an error:

Warning: Division by zero in /album.php on line 142
Warning: Division by zero in /includes/functions.php on line 1861

There seems to have been a slight problem with the xbimpulse.com forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.7:

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

Date: Friday 06th of May 2005 12:38:22 AM
Script: http://www.xbimpulse.com/forums/album.php
Referer: http://www.xbimpulse.com/
Username: MY USERNAME
IP Address: MY IP



Could you help me please? :surprised:

[blueuniverse]

Funnily enough, I get exactly the same error. I'd appreciate any help you could give us.

[blueuniverse]

Can somebody help me reverse the queries. To be honest, I've spent ages on this, installing all the fixes and I still get the same errors. :S

The initial queries are

ALTER TABLE `customprofilepic` ADD thumbnaildata mediumtext NOT NULL AFTER profilepicdata;
ALTER TABLE `customprofilepic` ADD comment varchar(255) NOT NULL AFTER filename;
ALTER TABLE `customprofilepic` ADD disapproved smallint(5) not null default'0';
ALTER TABLE `customprofilepic` ADD reason varchar(100) not null;
ALTER TABLE `usertextfield` ADD sigdateline int(10) unsigned NOT NULL default '0';

ALTER TABLE `customprofilepic` DROP PRIMARY KEY;
ALTER TABLE `customprofilepic` ADD picture_id int(10) unsigned NOT NULL default '0' AUTO_INCREMENT PRIMARY KEY AFTER userid;

INSERT INTO `settinggroup` (`grouptitle`, `displayorder`, `volatile`) VALUES ('vb3album', 968, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_perpage', 'vb3album', '18', '18', '', 10, 0, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_pertr', 'vb3album', '3', '3', '', 20, 0, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_approval', 'vb3album', '0', '0', 'yesno', 30, 0, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_exempt', 'vb3album', '6,7,5', '6, 7, 5', '', 40, 0, 0);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9231, 0, 'settinggroup_vb3album', 'vB3 Member Album', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9232, 0, 'setting_album_perpage_title', 'Entries Per Page', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9233, 0, 'setting_album_perpage_desc', 'Specify how many entries will show for each page.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9234, 0, 'setting_album_pertr_title', 'Entries Per Row', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9235, 0, 'setting_album_pertr_desc', 'Specify how many entries will show for each row.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9236, 0, 'setting_album_approval_title', 'Require Approval', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9237, 0, 'setting_album_approval_desc', 'If selected, pictures will have to be approved via the AdminCP before visible by the public.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9238, 0, 'setting_album_exempt_title', 'Exempted Usergroups', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9239, 0, 'setting_album_exempt_desc', 'If you have approval enabled, but would like specific usergroups to be exempt from it, then <u>in a comma separated list</u>, specify those usergroup IDs.', 5000);

[MichaelJM13k]

Yeah, this hack sucks.
We need support!

[dsboyce8624]

Velocd hasn't posted since last year, I doubt he'll be helping. Maybe sombody else could pickup the slack. I would love to use this, but I'm too noob-ish to do it without the chance of help.

Dennis

[dsboyce8624]

Yeah, this hack sucks.
We need support!

Yeah, there's a good way to get help.

[dsboyce8624]

Okay, I muddled through this. Of course I installed before I found there were fixes throughout the thread.

I found this link:

https://vborg.vbsupport.ru/showpost.php?p=577786&postcount=388

Which a mod should put up top and maybe replace the file to save some of us a bit of work.

I poked through the new file and if memory serves I found one difference which I edited in. Then I replaced the files.

I also noticed that if you paste all of the SQL lines in at once it errors, that's because they have CR/LF crap at the end of each line. Do them individually.

The only one I couldn't get was:

ALTER TABLE `customprofilepic` ADD picture_id int(10) unsigned NOT NULL default '0' AUTO_INCREMENT PRIMARY KEY AFTER userid;

Which (prolly screwed myself somehow) I removed "AUTO_INCREMENT PRIMARY KEY AFTER userid" from and it took. If somebody has a better way please post it. Or a way to fix what my change screwed up.

The only problem I have now is that my thumb nails aren't working. I clicked the rebuild and got the attached pic.

If you intend to install this please follow the link above first.

Now, suggestions on fixing my thumbs please?

EDIT: Actually, if somebody who does and somebody who doesn't have this installed could screen shot me the above mentioned table from MSQLAdmin I'd appreciate it.

EDIT: Okay, I created a test user and his thumb works. This one I don't understand.

EDIT: Okay, now I feel really stupid. After closing all windows everything works fine.

Go figure.

[Marco van Herwaarden]

You should have left the AUTO_INCREMENT in that statement, only remove the default value there.

[dsboyce8624]

You should have left the AUTO_INCREMENT in that statement, only remove the default value there.

So what would I do to correct it?

[Marco van Herwaarden]

Do the following SQL statement and i post the output here.
show create table customprofilepic;

[dsboyce8624]

Attached.

[blueuniverse]

Can somebody help me reverse the queries. To be honest, I've spent ages on this, installing all the fixes and I still get the same errors. :S

The initial queries are

ALTER TABLE `customprofilepic` ADD thumbnaildata mediumtext NOT NULL AFTER profilepicdata;
ALTER TABLE `customprofilepic` ADD comment varchar(255) NOT NULL AFTER filename;
ALTER TABLE `customprofilepic` ADD disapproved smallint(5) not null default'0';
ALTER TABLE `customprofilepic` ADD reason varchar(100) not null;
ALTER TABLE `usertextfield` ADD sigdateline int(10) unsigned NOT NULL default '0';

ALTER TABLE `customprofilepic` DROP PRIMARY KEY;
ALTER TABLE `customprofilepic` ADD picture_id int(10) unsigned NOT NULL default '0' AUTO_INCREMENT PRIMARY KEY AFTER userid;

INSERT INTO `settinggroup` (`grouptitle`, `displayorder`, `volatile`) VALUES ('vb3album', 968, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_perpage', 'vb3album', '18', '18', '', 10, 0, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_pertr', 'vb3album', '3', '3', '', 20, 0, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_approval', 'vb3album', '0', '0', 'yesno', 30, 0, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_exempt', 'vb3album', '6,7,5', '6, 7, 5', '', 40, 0, 0);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9231, 0, 'settinggroup_vb3album', 'vB3 Member Album', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9232, 0, 'setting_album_perpage_title', 'Entries Per Page', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9233, 0, 'setting_album_perpage_desc', 'Specify how many entries will show for each page.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9234, 0, 'setting_album_pertr_title', 'Entries Per Row', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9235, 0, 'setting_album_pertr_desc', 'Specify how many entries will show for each row.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9236, 0, 'setting_album_approval_title', 'Require Approval', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9237, 0, 'setting_album_approval_desc', 'If selected, pictures will have to be approved via the AdminCP before visible by the public.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9238, 0, 'setting_album_exempt_title', 'Exempted Usergroups', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9239, 0, 'setting_album_exempt_desc', 'If you have approval enabled, but would like specific usergroups to be exempt from it, then <u>in a comma separated list</u>, specify those usergroup IDs.', 5000);

Thanks, sorry to repost but it is quite urgent.

[osariase]

Hi Guys,
I am still struggling with this hack, but i'm making head way, my latest issue is the error that I am getting when i click on upload picture, below is the error message i receive:

Parse error: parse error, unexpected '{' in /home/naijawor/public_html/includes/functions_upload.php on line 448

can someone please tell me how to fix it, I am not good with this code

Marco, you are the man please help thanks man

[MissKalunji]

i gave up on this hack...i've uninstall it...half of the pictures dont even show up....

[dsboyce8624]

Hi Guys,
I am still struggling with this hack, but i'm making head way, my latest issue is the error that I am getting when i click on upload picture, below is the error message i receive:

Parse error: parse error, unexpected '{' in /home/naijawor/public_html/includes/functions_upload.php on line 448

can someone please tell me how to fix it, I am not good with this code

Marco, you are the man please help thanks man

Open the file and go to that line. Compare any changes you made to what the instructions say. You probably have a stray bracket that should have been part of the edit.

[dsboyce8624]

Do the following SQL statement and i post the output here.
show create table customprofilepic;

Okay, so it was working fine, despite the SQL mess up.

Something else happened and I had to start over. I followed the new install without a hitch and left out the default value in the one SQL statement.

Seemed great, I was happy. Wrong. Still bunches of little red x's.

Anything else I can try? I cleared the browser cache and even rebooted the server.

Thanks,

[Marco van Herwaarden]

Hi Guys,
I am still struggling with this hack, but i'm making head way, my latest issue is the error that I am getting when i click on upload picture, below is the error message i receive:

Parse error: parse error, unexpected '{' in /home/naijawor/public_html/includes/functions_upload.php on line 448

can someone please tell me how to fix it, I am not good with this code

Marco, you are the man please help thanks manOops sorry, i missed your reply. Still need help on this?
PS Better send me a PM, or i might miss your reply again.

[Boofo]

Has anyone come up with a way of notifying the Admin when a member uploads a pic that needs to be approved?

[blueuniverse]

Is there any way at all to uninstall this???

[blueuniverse]

Ok, I've finally managed to sort it by using phpmyadmin and manually uninstalling each table entry.

[dsboyce8624]

Marco, did you get my PM?

Dennis

[dsboyce8624]

Okay, so it was working fine, despite the SQL mess up.

Something else happened and I had to start over. I followed the new install without a hitch and left out the default value in the one SQL statement.

Seemed great, I was happy. Wrong. Still bunches of little red x's.

Anything else I can try? I cleared the browser cache and even rebooted the server.

Thanks,

Anybody?

[Chadi]

In admin cp under vb3 gallery "verify pictures" they are all X for some reason. I do have GD2 installed and working fine.

How do I correct this?

[venomx]

Most of us have that problem :(

[dsboyce8624]

Most of us have that problem :(

Mine look like that in album.php as well.

[Skyline]

How do I "Run the following queries from PhpMyAdmin"?

sorry, might be a stupid question, but I'm kinda new....THANKS!

[MissKalunji]

How do I "Run the following queries from PhpMyAdmin"?


sorry, might be a stupid question, but I'm kinda new....THANKS!

when you select your database click on sql : )

[dsboyce8624]

I think the only thing wrong with this hack is that the thumb images are not generated. This seems to be due to some issue with the database.

If I read things correctly the thumbs are stored there.

Can't anybody have a look at this and get it fixed? It's a great hack, shame to let it die from something so simple.