XF 1.5 Problem with not secure signatures

Jalo

Member
Hi all,

I'm running Xenforo 1.5.16 and I have a problem. Users on my forum have tickers in there signature but these tickers come from a not secure (SSL) website. Members complained about the warning they get about not being safe etc.

I'd like to run a SQL query to search for signatures that contain a certain phrase. Let's say: lilypie. If the signature contains "lilypie" I'd like to delete the signature.

Or maybe even better is there a way to display all users with signatures that contain the phrase? Then I could edit them manually.

Either way I need to get rid of the not secure signatures. Can you help me with the sql queries and if you have other/better suggestion, please do :)

Thanks!
 

Mouth

Well-known member
I'd like to run a SQL query to search for signatures that contain a certain phrase.
Code:
select xf_user_profile.user_id, username from xf_user_profile join xf_user on xf_user_profile.user_id = xf_user.user_id where signature like '%lilypie%';

If the signature contains "lilypie" I'd like to delete the signature.
Lilypie tickers are also available with https, so you could just edit the user signature and change their URL from http to https

Alternatively, you could turn on your image proxy via /admin.php?options/list/messageOptions so that the http images used by the tickers are retrieved and cached by your server, and then delivered as https from your site, thereby eliminating the issue you describe.
 
Top