Source Code Useful Xenforo MySQL Queries & Tips

Hexui Undetected CSGO Cheats Sinkicheat PUBG Cheat

Rake

I'm not your friend
Administrator
Jan 21, 2014
12,497
78,998
2,417
How long you been coding/hacking?
7 years
Convert various hotlinked images from http to https on Xenforo. I tested that each of these domains does serve HTTPS if you link correctly. This query fixed full HTTPS on over 400 threads, thereby increasing their ranking in search results.

C++:
UPDATE xf_post SET message = replace(message, 'http://puu.sh/', 'https://puu.sh/');
UPDATE xf_post SET message = replace(message, 'http://i.imgur.com/', 'https://i.imgur.com/');
UPDATE xf_post SET message = replace(message, 'http://i62.tinypic.com/', 'https://i62.tinypic.com/');
UPDATE xf_post SET message = replace(message, 'http://i63.tinypic.com/', 'https://i63.tinypic.com/');
UPDATE xf_post SET message = replace(message, 'http://i64.tinypic.com/', 'https://i64.tinypic.com/');
UPDATE xf_post SET message = replace(message, 'http://i65.tinypic.com/', 'https://i65.tinypic.com/');
UPDATE xf_post SET message = replace(message, 'http://i66.tinypic.com/', 'https://i66.tinypic.com/');
UPDATE xf_post SET message = replace(message, 'http://i67.tinypic.com/', 'https://i67.tinypic.com/');
UPDATE xf_post SET message = replace(message, 'http://i68.tinypic.com/', 'https://i68.tinypic.com/');
UPDATE xf_post SET message = replace(message, 'http://i69.tinypic.com/', 'https://i69.tinypic.com/');
UPDATE xf_post SET message = replace(message, 'http://i70.tinypic.com/', 'https://i70.tinypic.com/');
UPDATE xf_post SET message = replace(message, 'http://www.reactiongifs.com/', 'https://www.reactiongifs.com/');
UPDATE xf_post SET message = replace(message, 'http://1.bp.blogspot.com/', 'https://1.bp.blogspot.com/');
UPDATE xf_post SET message = replace(message, 'http://prntscr.com/', 'https://prntscr.com/');
 
  • Like
Reactions: JackSkellington
Attention! Before you post:

Read the How to Ask Questions Guide
99% of questions are answered in the Beginner's Guide, do it before asking a question.

No Hack Requests. Post in the correct section.  Search the forum first. Read the rules.

How to make a good post:

  • Fill out the form correctly
  • Tell us the game name & coding language
  • Post everything we need to know to help you
  • Ask specific questions, be descriptive
  • Post errors, line numbers & screenshots
  • Post code snippets using code tags
  • If it's a large project, zip it up and attach it

If you do not comply, your post may be deleted.  We want to help, please make a good post and we will do our best to help you.

Similar threads

Community Mods