Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require 'db_.php';
- $countBad = 0;
- $countOk = 0;
- $query = MySQL_Query("SELECT nid, body, field_brand_name_value FROM `content_type_page` LEFT JOIN `node_revisions` USING(nid) WHERE field_brand_name_value IS NOT NULL") or die (mysql_error());
- while($result = mysql_fetch_array($query))
- {
- $ret = $result['body'];
- echo "<hr/>";
- if(StrriPos($ret, "src=\"")===false)
- {
- $countBad++;
- echo "NID: ".$result['nid']." Link: ODKAZ NENALEZEN!!!";
- }
- else
- {
- $countOk++;
- $pattern=".*src=\"";
- $ret=ereg_replace(".*src=\"", "", $ret);
- $ret=ereg_replace("\".*", "", $ret);
- echo "NID: ".$result['nid']." Link: ".$ret;
- }
- }
- $sum = $countBad+$countOk;
- echo "
- <br/><hr/> Záznamů bez odkazu: ".$countBad."
- <br/> Záznamů s odkazem: ".$countOk."
- <br/> Záznamů celkem: ".$sum."
- ";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement