Solved

wp pdf file short link problem

Posted on 2014-12-19
8
152 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
  • 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 500 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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 

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 500 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

776 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