Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

wp pdf file short link problem

Posted on 2014-12-19
8
Medium Priority
?
162 Views
Last Modified: 2014-12-26
While working on this wordpress site, I was adding text links to pdf files.  I used the shortcode.  Problem is, that the pdf file link, when clicked on, opens up a page which then has another link to the file and it also has the site design.  

Here is an example of how I DON'T want the pdf file displayed.  Click on link to view.
http://beta.citizensequalrightsalliance.org/?attachment_id=538

There are over 20 pdf files that do this in an over 200 page website.  The other pdf files use the long code and work good.  By good, I mean the pdf file itself opens up in a new window (without the site design).

Here is how I want the pdf files to display.  Click on link to view.
http://beta.citizensequalrightsalliance.org/wp-content/uploads/2014/12/action_guide.pdf

So, my question is simple but the answer might not be.  Is there a way to do a search or setup some sort of query so that I can search for the pages that use the shortcode pdf links (I know which ones are bad) and have the wp system tell me which pages they are linked on?
0
Comment
Question by:nsitedesigns
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 40509429
Do you have direct access to the database?
0
 

Author Comment

by:nsitedesigns
ID: 40509443
my programmer does.
0
 
LVL 70

Assisted Solution

by:Jason C. Levine
Jason C. Levine earned 1500 total points
ID: 40509512
So this can be done via MySQL query.  The shortcodes are present exactly as typed in the wp_content table, post_content column.  Your programmer can do an update query using a regular expression to match the PDF shortcode and replacing it with a link.  

The trick will be generating that search/replace query.
0
Looking for a new Web Host?

Lunarpages' assortment of hosting products and solutions ensure a perfect fit for anyone looking to get their vision or products to market. Our award winning customer support and 30-day money back guarantee show the pride we take in being the industry's premier MSP.

 

Author Comment

by:nsitedesigns
ID: 40509535
Won't that also show any shortcodes that also link to pages?  I use the shortcodes for page links and those work great.  Somehow I need to id the shortcodes as ones that go to a pdf file.
0
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 1500 total points
ID: 40509540
The first step is to identify the shortcodes everywhere.  The second step is figuring out the pattern of the PDF ones to isolate just those.
0
 

Author Comment

by:nsitedesigns
ID: 40517652
We have now nearly 300 pages on this site.  Shortcodes are everywhere.  I don't know how we will be able to do what you advise since there is nothing specific about the shortcodes to the handful of links that are bad.  I will give you points anyways just for trying.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 40517655
if there was no identifiable pattern for the bad shortcodes, then there really isn't any other way to do this than manual search and replaces in the database.
0
 

Author Comment

by:nsitedesigns
ID: 40518472
thanks.
0

Featured Post

Looking for a new Web Host?

Lunarpages' assortment of hosting products and solutions ensure a perfect fit for anyone looking to get their vision or products to market. Our award winning customer support and 30-day money back guarantee show the pride we take in being the industry's premier MSP.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
When the s#!t hits the fan, you don’t have time to look up who’s on call, draft emails, call collaborators, or send text messages. An instant chat window is definitely the way to go, especially one like HipChat. HipChat is a true business app. An…
The viewer will learn how to dynamically set the form action using jQuery.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question