[vbadvanced Gallery & Links] Number of contributed pics & links in profile

[Lea Verou]

This modification will add to a member's profile the number of pictures and links he has contributed. It needs vbadvanced links and vbadvanced gallery installed.
The code for the gallery is Brian's (Tigga here) but I made it as a plugin and added the code for the links too.

Installation
1. Import the attached plugin.
2. Add in the MEMBERINFO template wherever you'd like it:
Pictures Contributed: $userimages[count] for the images and
Links contributed: $userlinks[count] for the links.

Please click install if you use this.
If you only have vba Gallery or vba Links then delete (or comment) the other section of the plugin.

[Ramsesx]

Nice idea, quickly and easy installation. Thank you

[trackpads]

Michelle!!! Great work! How would I go about adding this to the posbit?

[Lea Verou]

Michelle!!! Great work! How would I go about adding this to the posbit?

Try changing the hook location of the plugin to postbit_complete and performing the same template changes but on the postbit (or postbit_legacy) template. tell me if it works

[trackpads]

I hope this will contribute some here.

I used this code in my memberinfo:


<!-- Start Photos and Links Hack -->
<fieldset class="fieldset">
<legend>Photos & Links</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td>
Pictures Contributed: <strong>$userimages[count]</strong>
</td>
</tr>
<tr>
<td><a href="http://www.trackpads.com/media/browseimages.php?c=500&u=$userinfo[userid]" rel="nofollow"><phrase 1="$userinfo[username]">$vbphrase[find_all_photos_by_x]</phrase></a></td>
</tr>
<tr>
<td>
Links Contributed: <strong>$userlinks[count]</strong>
</td>
</tr>
<tr>
<td><a href="http://www.trackpads.com/media/browseimages.php?c=500&u=$userinfo[userid]" rel="nofollow"><phrase 1="$userinfo[username]">$vbphrase[find_all_links_by_x]</phrase></a></td>
</tr>
</table>
</fieldset>


<!-- / Photos and Links Hack -->



I had to create the 2 new phrases 'find_all_photos_by_x' & 'find_all_links_by_x'.

The only problem I have is what the heck is the code to search the links by username? Above I have the same search string for both. Any ideas?

Thanks again,

-Jason

[trackpads]

Try changing the hook location of the plugin to postbit_complete and performing the same template changes. tell me if it works

Will do!

[Lea Verou]

I hope this will contribute some here.

I used this code in my memberinfo:


<!-- Start Photos and Links Hack -->
<fieldset class="fieldset">
<legend>Photos & Links</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td>
Pictures Contributed: <strong>$userimages[count]</strong>
</td>
</tr>
<tr>
<td><a href="http://www.trackpads.com/media/browseimages.php?c=500&u=$userinfo[userid]" rel="nofollow"><phrase 1="$userinfo[username]">$vbphrase[find_all_photos_by_x]</phrase></a></td>
</tr>
<tr>
<td>
Links Contributed: <strong>$userlinks[count]</strong>
</td>
</tr>
<tr>
<td><a href="http://www.trackpads.com/media/browseimages.php?c=500&u=$userinfo[userid]" rel="nofollow"><phrase 1="$userinfo[username]">$vbphrase[find_all_links_by_x]</phrase></a></td>
</tr>
</table>
</fieldset>


<!-- / Photos and Links Hack -->



I had to create the 2 new phrases 'find_all_photos_by_x' & 'find_all_links_by_x'.

The only problem I have is what the heck is the code to search the links by username? Above I have the same search string for both. Any ideas?

Thanks again,

-Jason

http://www.vbadvanced.com/forum/showthread.php?t=11534

[trackpads]

http://www.vbadvanced.com/forum/showthread.php?t=11534

Psychic, eery really :) :) :) :)

THANKS!!!!!!

[trackpads]

Will do!

No luck, there is no postbit_complete, I tried the postbit_display_complete but got an error when I tried to view a thread

[Lea Verou]

No luck, there is no postbit_complete, I tried the postbit_display_complete but got an error when I tried to view a thread

Try all the other postbit hook locations :)

What error did you get?

[dieselpowered]

I do not have the link software, however, do have the gallery. Anyway to add it just for gallery?

Thanks!

[Lea Verou]

I do not have the link software, however, do have the gallery. Anyway to add it just for gallery?

Thanks!

Read ALL the first post please. :)

[trackpads]

Try all the other postbit hook locations :)

What error did you get?

Ok no luck I tried all four postbit locations and here was the error on the postbit_start and postbit_factory hooks:

Fatal error: Call to a member function on a non-object in /home/trackpad/public_html/forum/includes/class_postbit.php(97) : eval()'d code on line 2

[Lea Verou]

Ok no luck I tried all four postbit locations and here was the error on the postbit_start and postbit_factory hooks:

Fatal error: Call to a member function on a non-object in /home/trackpad/public_html/forum/includes/class_postbit.php(97) : eval()'d code on line 2

Darn, I'll look into the code later as currently I am on the phone :p

[dieselpowered]

LOL I will have another drink...sorry.

[trackpads]

Darn, I'll look into the code later as currently I am on the phone :p

Np, thanks!!!

[Lea Verou]

Np, thanks!!!

Just finished the phone call :)
Try changing $userinfo['userid'] to $post['userid'].
If this doesn't work (and probably it won't) then I can't help you with that. I had that issue in one of my other hacks (thread count in profile) and I couldn't make it to work with the postbit because I don't know what I should write to get the userid in a plugin that is on the postbit hook. :(

[trackpads]

Just finished the phone call :)
Try changing $userinfo['userid'] to $post['userid'].
If this doesn't work (and probably it won't) then I can't help you with that. I had that issue in one of my other hacks (thread count in profile) and I couldn't make it to work with the postbit because I don't know what I should write to get the userid in a plugin that is on the postbit hook. :(

drats no luck, thanks anyway!

-Jason

[Lea Verou]

drats no luck, thanks anyway!

-Jason

Ask spongebobrox for it. He certainly can do it as he made the modification with the thread count in postbit that I couldn't :)

[Snake]

Nice and thanks!

[Tradjick]

Would it possible to integrate AndrewD´ Links and Download Manager instead of Brian´s?

[Lea Verou]

Would it possible to integrate AndrewD? Links and Download Manager instead of Brian?s?

Nope, I am not familiar with those.

[dieselpowered]

Works great!!!

**clicks install**

I did edit the .xml seeing as I do not have the links directory.

You can see what I did with it HERE (http://www.weapondepot.com/forums/member.php?u=1)

[dieselpowered]

Michelle, just wanted to let you know that this works with 3.5.2, incase you wanted to change the version at the top of the thread :)

[Lea Verou]

Michelle, just wanted to let you know that this works with 3.5.2, incase you wanted to change the version at the top of the thread :)

Thank you :)

[aksi78]

Thanks for this mod!

Will it be possible to integrate it into postbit some time later?

[Lea Verou]

Thanks for this mod!

Will it be possible to integrate it into postbit some time later?

Do not try this at home :p

At least not with some optimization. It would add 2 queries per post which would mean 100 more queries in a page with 50 posts...

[Aken]

Is it possible this plugin could be setup to allow it's use for somebody with ONLY the Gallery or Links?

I just attempted to install on vB 3.5.3, and got a database error because it could not find the Links table. This would be a cool little addition to my website, but I don't intend on using vBa's Links system.

Not a big deal, but could be a nice feature to use one or both of the counts. :)

[Lea Verou]

If you only have vba Gallery or vba Links then delete (or comment) the other section of the plugin.
:rolleyes:

[djjeffa]

I installed and now when i go to my profile I get this

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(*) AS count FROM vb_links WHERE userid = '3' AND valid = 1;

MySQL Error : Table 'djjeffa_djjeffavb.vb_links' doesn't exist
Error Number : 1146
Date : Tuesday, March 7th 2006 @ 07:30:46 PM
Script : http://www.djjeffa.com/vb/member.php?u=3
Referrer :
IP Address : 69.141.31.247
Username : djjeffa
Classname : vb_database

[Lea Verou]

Do you have vba links installed? If not, comment out that section of the plugin ;)

[iChambers]

I had a issue adding the xml file to mine it said invalid file so I had to enter it into the Product Manager by hand without the [CDATA thing in it.

[Dsyn11]

I have photopost instead of vBa gallery. How do I change the product to pull the count from there?

Also, I'm using ReviewsPost for my Links manager... same question as above. If this is a problem, I can pay for your services, if that's possible. Thanks very much!

[Lea Verou]

I need to know the database structure of the photopost tables. Can you look into it via phpmyadmin and tell me?
About paid services: I don't accept international projects at the moment :)

[jarcher]

This modification will add to a member's profile the number of pictures and links he has contributed. It needs vbadvanced links and vbadvanced gallery installed.
so I cannot use this without vbadvanced links and vbadvanced gallery already installed?
and I cannot install vbadvanced links and vbadvanced gallery unless I purchase a PhotoPost board?

[Lea Verou]

You need to have at least one of them installed.
I'm not sure what you mean by "Photopost board". These work with vbulletin, there is no such thing as a "photopost forum software".

[jarcher]

all I know is that when I went looking for vbadvanced gallery, I was led to many discussions of it being sold to photopost.
so, where can I find it to install?

[MorrisMcD]

all I know is that when I went looking for vbadvanced gallery, I was led to many discussions of it being sold to photopost.
so, where can I find it to install?
vbadvanced.com will have a link to where you can find it..

[jarcher]

so. .there is nothing "free" for vb board owners

[MorrisMcD]

so. .there is nothing "free" for vb board owners
Those 2 cost money.. But there is another one on this board somewhere.. I cant remember the name of it.. That one is free

[T3MEDIA]

You need to have at least one of them installed.
I'm not sure what you mean by "Photopost board". These work with vbulletin, there is no such thing as a "photopost forum software".I THINK they mean photo-post for vb boards.
I have pp as well but had bad experiences with the kind attitudes they give off.

I was thinking of using PhotoPlog
Any ideas of how to get that puppy to work?

[wii]

I´ve installed this, and added:

Pictures Contributed: $userimages[count]

In the postbit, but no count is showing - what am I missing here ?

[Lea Verou]

I?ve installed this, and added:

Pictures Contributed: $userimages[count]

In the postbit, but no count is showing - what am I missing here ?
It's supposed to be for the profile, not the postbit.

[wii]

Ok, Got it working in the profile,

How I add a link to the users gallery from the counter ?

[wii]

Any news about getting this to work in the postbit ?

[i_pirlanti]

Do you have vba links installed? If not, comment out that section of the plugin ;)


where can i install vba??

my english is not so good please help me :(

[ztempuser]

anyone up for porting this to menalto's gallery2 with the vb intergration and the user own album module already made?

[guwebby]

works with 3.5.4 also.

You can download and PURCHASE Photopost vBGallery from photopost.com

[Serenity]

i was having an issue with searching members gallery pics but i found this thread and i'm sure it will help out some people here who want this displayed in the postbit.

https://vborg.vbsupport.ru/showthread.php?t=114195

[UncoderMom]

can this be ported to photoplog? please?!?

[puregraf]

Hi, I am getting this error:




Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(*) AS count FROM links WHERE userid = '1' AND valid = 1;

MySQL Error : Table 'puregraf_peegee.links' doesn't exist
Error Number : 1146
Date : Saturday, July 1st 2006 @ 02:18:49 PM
Script : http://www.puregraffiti.com/graffiti-space/member.php?u=1
Referrer : http://www.puregraffiti.com/graffiti-space/index.php
IP Address : ***
Username : puregraffiti
Classname : vb_database



can you please help me fix this?
THANKS!
:bunny:

[Lea Verou]

You obviously don't hve vbdvanced links directory installed. Comment out the section of the plugin that refers to links and don't do the template edit for links, just for the gallery.

[criscokid]

I have photopost instead of vBa gallery. How do I change the product to pull the count from there?
Has anyone modified this mod to work with PhotoPost?

[puregraf]

You obviously don't hve vbdvanced links directory installed. Comment out the section of the plugin that refers to links and don't do the template edit for links, just for the gallery.
i found Links contributed: $userlinks[count]
in MEMBERINFO and removed it and stil same error when i click on the usernames name, takes me to a page with that error.

what else could it be?

is there a way to restore things without restore the database. i tried uninstalling the plugin re-installing but didnt work either.

thank you i appreciate your help, im not very good with php.

[puregraf]

<!--
Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(*) AS count FROM links WHERE userid = '35' AND valid = 1;

MySQL Error : Table 'puregraf_peegee.links' doesn't exist
Error Number : 1146
Date : Monday, July 3rd 2006 @ 05:03:44 PM
Script : http://www.puregraffiti.com/graffiti-space/member.php?find=lastposter&amp;f=5
Referrer : http://www.puregraffiti.com/graffiti-space/index.php
IP Address : *****
Username : cartman
Classname : vb_database
-->:( :( :( :( need to fix this please asap

[Eggie]

I need to know the database structure of the photopost tables. Can you look into it via phpmyadmin and tell me?
About paid services: I don't accept international projects at the moment :)


hi Michelle,

I too would be intrested in using this with PhotoPost.. here are the tables for it

# Browse pp_admingroups
# Browse pp_admlog
# Browse pp_cache
# Browse pp_categories
# Browse pp_comments
# Browse pp_ecards
# Browse pp_exif
# Browse pp_extrafields
# Browse pp_favorites
# Browse pp_ipcache
# Browse pp_iponline
# Browse pp_laston
# Browse pp_notify
# Browse pp_photoextras
# Browse pp_photos
# Browse pp_photoviews
# Browse pp_settings
# Browse pp_sort
# Browse pp_sortmemb
# Browse pp_usergroups
# Browse pp_users

any help getting this to work would be great!

[Eggie]

/me bumps in hopes of an answer.

[Spikeman]

Works perfect with vB 3.6.1, thanks :)

[FleaBag]

Hi, I am getting this error:




Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(*) AS count FROM links WHERE userid = '1' AND valid = 1;

MySQL Error : Table 'puregraf_peegee.links' doesn't exist
Error Number : 1146
Date : Saturday, July 1st 2006 @ 02:18:49 PM
Script : http://www.puregraffiti.com/graffiti-space/member.php?u=1
Referrer : http://www.puregraffiti.com/graffiti-space/index.php
IP Address : ***
Username : puregraffiti
Classname : vb_database



can you please help me fix this?
THANKS!
:bunny:

Hi Michelle; I am getting this error since upgrading to the latest version of Links. It seems the hack is not compatible.

[gilbert]

Anyone get this working with photopost yet?

[gnubittol]

this is my solution for the postbit
only images ... no links.

vb v3.5.7