Two annoying bugs
 

1. Some users avatars are not showing up - I cannot see any reason why this would be as the users whose avatars are displaying correctly don't seem to have any differences set up.

2. When searching if a user puts an apostrophe ( ' ) in the search term it will generate a database error.

Forum Software: VBulletin
Photopost version: 6.02

I would supply a link to my site but as it contains adult content and may offend some I will supply a link on demand via PM to a mod/admin

For avatars try this

In vb3.php find this

replace with this and see if it works

As far as search terms if I enter an apostrophe I get this

Please pm a link and login and test to try

Your code edit didn't work, however I made a further code edit which fixed the problem. I changed:
to
which did the trick :)

I also made a mistake in my original post as I hadn't tested the error properly. When typing an apostrophe into the search box everything works fine. The problem comes when a user clicks on a keyword link that contains an apostrophe like http://XXXXXXXX.com/gallery/search.php?keywords=Don't

This returns the error:
Login details sent by pm

(NOTE: url has been removed from this post as site contains adult content and may offend some)

I replied with a question thats not a photopost table at all which makes no sense here. Thats not even a photopost query.

After a bit of searching I have narrowed down the hack it belongs to. It was a rules and agreement hack (which I cannot find on vbulletin.org anymore for some reason and does not contain a link) that I used to make users agree to a set of rules before they uploaded a picture or joined in a roleplay. The script should only have executed on http://xxxxxx.com/gallery/uploadphoto.php but I assume it was checking the database on every url to see if it matched one it had to trigger. I have now disabled the product and upon testing everything appears to now work as it should.

Is there going to be an easy way of coding in an agreement that users will need to accept the first time they attempt to upload a picture (but only the first time for each account) to the gallery?

Okay glad you found your hack that caused your issue.

I could not say there but if some one has the need and means to work something like that out I am sure they could. Good discussion for the MOD CORNER outside the product support area.

[quote=rsj1;1223168]Your code edit didn't work, however I made a further code edit which fixed the problem. I changed:
to
which did the trick :)

I too have this problem with random user profiles not showing avatars, I have updated the file above, but did not help. Any suggestions on what to do?

How about applying both what I said and what he said?

All fixed, thank you again.

Not a problem glad to assist buddy have a good weekend.