API tools faq
paste
Advertisement
uzielweb

Bring Wordpress Featured Image Post to Joomla Intro/Full

uzielweb
May 25th, 2016
197
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 4.68 KB | None | 0 0
raw download clone embed print report
  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  2. <html>  
  3.   <head>  
  4.     <meta http-equiv="content-type" content="text/html; charset=utf-8">  
  5.     <meta name="generator" content="PSPad editor, www.pspad.com">  
  6.     <title>
  7.     </title>  
  8.     <!-- Latest compiled and minified CSS -->
  9.     <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" integrity="sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7" crossorigin="anonymous">
  10.     <!-- Optional theme -->
  11.     <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap-theme.min.css" integrity="sha384-fLW2N01lMqjakBkx3l/M9EahuwpSfeNvV63J5ezn3uZzapT0u7EYsXMjQV+0En5r" crossorigin="anonymous">
  12.     <!-- Latest compiled and minified JavaScript -->
  13. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js" integrity="sha384-0mSbJDEHialfmuBBQP6A4Qrprq5OVfW37PRR3j5ELqxss1yVqOtnepnHVP9aJ7xS" crossorigin="anonymous"></script>  
  14.     <style>           body td{     font-size:14px;     color: #333;                }      body td a{     font-size:14px;     color: #46918C;                }      table td {   padding: 10px; }     thead td, thead td * {   background: #818181 none repeat scroll 0 0;   color: #fff !important;   font-weight: bold;   padding: 10px;   text-align: left !important;   text-transform: uppercase; }   body > .container {   padding-top: 40px;   background-color: white;    } /*  * Responsive stypes  */ @media (max-width: 980px) {   body > .container {     padding-top: 0px;   }   .navbar-fixed-top {     margin-bottom: 0;   } } /* END: @media (max-width: 980px) */
  15.     </style>  
  16.   </head>  
  17.   <body>  
  18.     <div class="container">
  19.       <div class="col-md-12">  
  20. <?php
  21. $servername = "localhost";
  22. $username = "xxx;
  23. $password = "xxx";
  24. $dbname = "xxx";
  25. $dbprefix = "xxx_";
  26. $joomlaprefix = "xxx_";
  27. // Create connection    
  28.  
  29. $conn = new mysqli($servername, $username, $password, $dbname);
  30. mysqli_set_charset($conn, "utf8");
  31. // Check connection
  32. if ($conn->connect_error) {
  33. die("Connection failed: " . $conn->connect_error);
  34. }
  35. // output data of each row  
  36. echo "<table><thead><tr><td><b>ID: </b></td><td><b>TÍTULO: </b></td><td><b>APELIDO: </b></td><td><b>DATA: </b></td><td><span class='col-md-4'>Imagem</span><span class='col-md-4'>Intro/Full JOOMLA</span><span class='col-md-4'>SQL JOOMLA</span></td></tr></thead><tbody>";
  37. foreach ($conn->query('SELECT ID, post_date, post_title, post_type, post_name, guid FROM '.$dbprefix.'posts WHERE post_type = "post" ORDER BY ID ASC') as $row){    
  38. echo "<td>".$row["ID"]."</td><td><a data-toggle='lightbox' rel='modal' href='".$row["guid"]."' target='_blank'>". $row["post_title"]."</a></td><td><a data-toggle='lightbox' rel='modal' href='".$row["guid"]."' target='_blank'>". $row["post_name"]."</a></td><td>". $row["post_date"]."</td><td>";
  39.  
  40.  foreach ($conn->query('SELECT ID, post_parent,guid FROM '.$dbprefix.'posts WHERE post_type = "attachment"') as $row2){
  41. if ($row2["post_parent"] == $row["ID"]) {
  42.        foreach ($conn->query('SELECT post_id,meta_value, meta_key FROM '.$dbprefix.'postmeta WHERE meta_key = "_thumbnail_id"') as $row3)    
  43.          if ($row3["meta_value"] == $row2["ID"]) {
  44.                foreach ($conn->query('SELECT post_id,meta_value, meta_key FROM '.$dbprefix.'postmeta WHERE meta_key = "_wp_attached_file"') as $row4){
  45.                 if ($row4["post_id"] == $row3["meta_value"]) {
  46.                //  Comente essa linha abaixo caso precise  copiar só a coluna com o update da tabela
  47.                 //  echo  "<span class='col-md-4'><a data-toggle='lightbox' rel='modal' href='wp-content/uploads/".$row4["meta_value"]."' target='_blank'>".$row4["meta_value"]."</a></span>";
  48.                 //  Comente essa linha abaixo caso precise  copiar só a coluna com o update da tabela
  49.               //  echo  "<span class='col-md-4'><b>images/".$row4["meta_value"]."</b></span>";
  50.                
  51.                
  52.                 echo "<span class='col-md-4'>UPDATE ".$joomlaprefix."content SET images = '{\"image_intro\":\"images\\\/".str_replace('/', '\\\/',$row4["meta_value"])."\",\"float_intro\":\"\",\"image_intro_alt\":\"\",\"image_intro_caption\":\"\",\"image_fulltext\":\"images\\\/".str_replace('/', '\\\/',$row4["meta_value"])."\",\"float_fulltext\":\"\",\"image_fulltext_alt\":\"\",\"image_fulltext_caption\":\"\"}' WHERE alias = '". $row["post_name"]."';</span>";
  53.                }
  54.                
  55.         }  
  56. }
  57. }
  58. }
  59. echo "</td></tr>";
  60. }
  61. echo "</tbody></table>";
  62. $conn->close();
  63.        ?>      
  64.      </div>
  65.    </div>
  66. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>  
  67.   </body>
  68. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!