' . $module['title'] . ' ' . $siteroot . ' Latest ' . $module['title'] . ' comics and news en-us'; $items = array(); $query = "SELECT * FROM cc_" . $tableprefix . "comics WHERE comic='" . $module['id'] . "' AND publishtime <= " . time() . " ORDER BY publishtime DESC LIMIT 20"; $result = $z->query($query); while($row = $result->fetch_assoc()){ $str .= '<![CDATA[' . $module['title'] . ' - ' . html_entity_decode($row['comicname'],ENT_QUOTES) . ']]>'; $desc_data = 'New comic!
Today\'s News:
' . $row['newscontent']; $desc_data = preg_replace("#(<\s*a\s+[^>]*href\s*=\s*[\"'])(?!http)([^\"'>]+)([\"'>]+)#", $siteroot . '$2$3', $desc_data); $desc_data = preg_replace("", '', $desc_data); $desc_data = preg_replace("", '', $desc_data); $desc_data = preg_replace("", '', $desc_data); $desc_data = preg_replace("", '', $desc_data); $dom = new DOMDocument(); @$dom->loadHTML($desc_data); for ($i=0; $i<$dom->getElementsByTagName('img')->length; $i++) { $encoded = implode("/", array_map("rawurlencode", explode("/", $dom->getElementsByTagName('img') ->item($i)->getAttribute('src')))); $dom->getElementsByTagName('img') ->item($i) ->setAttribute('src',$encoded); } $desc_data = $dom->saveHTML(); $desc_data = str_replace("", '', $desc_data); $desc_data = str_replace("", '', $desc_data); $desc_data = str_replace("", '', $desc_data); $desc_data = str_replace("", '', $desc_data); $str .= ''; $str .= '' . $siteroot . $module['slug'] . '/' . $row['slug'] . ''; $str .= 'tech@thehiveworks.com'; $str .= '' . date("D, d M Y H:i:s O", $row['publishtime']) . ''; $str .= '' . $siteroot . $module['slug'] . '/' . $row['slug'] . ''; $str .= '
'; } $str .= '
'; echo $str; ?>