0 ORDER BY rand() LIMIT 0,19"); while($scatrow = mysql_fetch_array($scat)) { if($scatrow["pcatname"]) { $sslug = $scatrow["pslug"].'/'; $pages["featured"] .= ''.$scatrow["mcatname"].', '.$scatrow["pcatname"].'
'; } } $pcat = mysql_query("SELECT a.id, a.title, a.slug, a.catid, a.content, b.slug AS cslug, c.slug AS pslug FROM ms_site_page AS a LEFT JOIN ms_category AS b ON (a.catid=b.catid) LEFT JOIN ms_category AS c ON (c.catid=b.parentid) WHERE a.slug!='index' ORDER BY rand() LIMIT 0,9"); $i = 0; while($pcatrow = mysql_fetch_array($pcat)) { $slug1 = $pcatrow["pslug"]; $slug2 = $pcatrow["cslug"]; $slug3 = $pcatrow["slug"]; $doc=new DOMDocument(); @$doc->loadHTML($pcatrow["content"]); @$xml=simplexml_import_dom($doc); // just to make xpath more simple $images=$xml->xpath('//img'); foreach ($images as $img) { $image = $img['src']; break; } $path = str_replace('/new/','/',$config["site_path"].''.$img['src']); if(file_exists($path)) { $pages["gallery"] .= '

'; if($i==2) { $pages["gallery"] .= '
'; $i = 0; } else { ++$i; } } } //$pages["content"] .= latest_articles(); } if($page_type==2) { // article page $config["tid"] = "article"; $pages = display_article($var_slug1,$var_slug2,$var_slug3,1); $metainfo["title"] = $pages["title"]; $metainfo["description"] = $pages["description"]; $metainfo["keywords"] = $pages["keywords"]; $cat = mysql_query("SELECT catid,parentid,catname,description FROM ms_category WHERE slug='".$var_slug2."'"); $catrow = mysql_fetch_array($cat); $nav = navigation($catrow["catid"]); } if($page_type==3) { //category page $config["tid"] = "article"; if($var_slug1 && !$var_slug2) { $slug = $var_slug1; } if($var_slug1 && $var_slug2) { $slug = $var_slug2; } $cat = mysql_query("SELECT catid,parentid,catname,description,keywords,content FROM ms_category WHERE slug='".$slug."'"); $catrow = mysql_fetch_array($cat); $pages["content"] .= '

'.stripslashes($catrow["catname"]).'

'; $pages["content"] .= stripslashes($catrow["content"]).'

'.$ad[0].'

'; $metainfo["title"] .= stripslashes($catrow["catname"]); $metainfo["description"] .= $catrow["description"]; $metainfo["keywords"] .= $catrow["keywords"]; if($var_slug3 == "index") { $pages["content"] = ''; $intro = display_article($var_slug1,$var_slug2,'index','1'); $pages["content"] .= '

'.$intro["content"]; } // subcategories $pages["content"] .= ""; $pages["content"] .= '

'; $scat = mysql_query("SELECT catid,catname,description,keywords,slug FROM ms_category WHERE parentid='".$catrow["catid"]."'"); $n =0; while($scatrow = mysql_fetch_array($scat)) { $pages["content"] .= '

'.stripslashes($scatrow["catname"]).'

'; if($n==2) { $pages["content"] .= '
'; $n = 0; } else { ++$n; } } $pages["content"] .= '

'; if($scatrow["catname"]) { $metainfo["title"] .= stripslashes($scatrow["catname"]); } //list articles if any $pages["content"] .= '

'; $pcat = mysql_query("SELECT id,title,slug,content FROM ms_site_page WHERE catid='".$catrow["catid"]."' AND slug!='index'"); $i = 0; while($pcatrow = mysql_fetch_array($pcat)) { $doc=new DOMDocument(); @$doc->loadHTML($pcatrow["content"]); @$xml=simplexml_import_dom($doc); // just to make xpath more simple $images=$xml->xpath('//img'); foreach ($images as $img) { $image = $img['src']; break; } $path = str_replace('/new/','/',$config["site_path"].''.$img['src']); if(file_exists($path)) { $pages["content"] .= '

'; if($i==3) { $pages["content"] .= '
'; $i = 0; } else { ++$i; } } } $pages["content"] .= '

'; if($catrow["parentid"]>0) { $pcat2 = mysql_query("SELECT catname FROM ms_category WHERE catid='".$catrow["parentid"]."'"); $pcatrow2 = mysql_fetch_row($pcat2); $metainfo["title"] .= ' - ' . stripslashes($pcatrow2[0]); } $nav = navigation($catrow["catid"]); } // /England/Apothecary/ page_templates($config,$pages,$metainfo); ?>