File: /home/awaldron/public_html/archive/demo/blogs.php
<?php
session_start();
include("_functions.php");
dbconnect();
$blogjava = TRUE;
$page_title = "Employee Blogs";
$GLOBALS["breadcrumb"] = "<a href=\"/content.php?p=1\">Intranet Home</a> > <a href=\"/content.php?p=209\">Social</a> > ".$page_title;
$GLOBALS["ext_page"] = $page_title; // SET FAUX PAGE NAME
$_GET["p"] = 209; // SET FAUX PARENT ID
$lnav_mods = get_layout($_GET["p"],1);
$rnav_mods = get_layout($_GET["p"],3);
include("_pagestart.php");
// NOT THE GREATEST SQL QUERY, BUT IT'LL HAVE TO DO BECAUSE THERE IS NO NESTED SELECTS IN MYSQL
mysql_select_db("intrablog");
$sql = "SELECT A.id, A.blog, B.user, C.fname, C.lname FROM intrablog.lt1_blogs as A, intrablog.lt1_users as B, intranet.tbl_employees as C ";
$sql .= "WHERE A.status=1 AND A.owner_id=B.id AND B.user=C.username ";
$sql .= "ORDER BY C.username ASC";
$res = mysql_query($sql);
//echo mysql_error();
mysql_select_db("intranet");
$ins = "<P><div id=\"heading\">All Bloggers</a></div><div id=\"box\"><table border=0>\n";
for ($i=0; $row = mysql_fetch_array($res); $i++) {
$ins .= "<tr><td><img src=\"/gui/bullet.gif\"></td><td><a href=\"http://".DOMAIN."/blog/index.php?blogId=".$row["id"]."\">".get_user($row["user"],"fullname2")."</a></td></tr>\n";
}
$ins .= "</table></div>\n";
$s = "<P><div id=\"heading\">Search Blogs</a></div><div id=\"box\"><table border=0>\n";
$s .= "<form id=\"searchForm\" method=\"get\" action=\"/blogs.php\">\n";
$s .= "<tr><td><input type=\"hidden\" name=\"op\" value=\"summarySearch\" /> \n";
$s .= "<b>Search terms:</b><br><input type=\"text\" tabindex=\"20\" name=\"searchTerms\" id=\"searchTerms\" value=\"".$_GET["searchTerms"]."\" /> <input type=\"submit\" class=\"btn\" name=\"summarySearch\" value=\"search\" tabindex=\"21\" />\n";
$s .= "</td></tr></form>\n";
$s .= "</table></div>\n";
echo "<div class=\"headline\">".$page_title."</div>\n";
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "http://intranet.vocollect.int/blog/summary.php");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
$out = curl_exec($ch);
curl_close($ch);
$start = strpos($out,"<h4>Latest Posts");
$out = substr($out,$start);
$out = str_replace("<img ","<img border=0 ",$out);
$out = str_replace("\"imgs/","\"/blog/imgs/",$out);
$out = str_replace("<h4>","<P><div id=\"heading\">",$out);
$out = str_replace("</h4>","</div>",$out);
$out = str_replace("<h5>","<span id=\"vred\" style=\"margin-bottom:5px;\">",$out);
$out = str_replace("</h5>","</span>",$out);
$out = str_replace("</p>","<br>",$out);
$out = str_replace("<p>","",$out);
$out = str_replace("class=\"noborder\"","style=\"text-decoration:none;\"",$out);
$out = str_replace("class=\"peu\"","style=\"color:#999999;margin-top:6px;\"",$out);
//$out = str_replace("<P><div id=\"heading\">Latest Posts","<P><div id=\"heading\" style=\"margin-bottom:12px;\">Latest Posts",$out);
$out = str_replace("id=\"column-right\"","style=\"float:right\"",$out);
$out = str_replace("<div class=\"subtitle\">","<div style=\"margin:0px 0px 25px 15px;\"><div class=\"subtitle\" style=\"margin:6px 0px 6px 0px;\">",$out);
$out = str_replace("<br style=\"clear: both;\" />","",$out);
$out = str_replace("Comment</a>","Comment</a></div>",$out);
$out = str_replace("Comments</a>","Comments</a></div>",$out);
//$out = preg_replace("|Comment</a></div>[^<]*</div>|","Comment</a></div></div>",$out);
//$out = preg_replace("|Comments</a></div>[^<]*</div>|","Comments</a></div></div>",$out);
$out = str_replace("<div id=\"heading\">Search Blogs</div>","<span id=\"vred\">Search Blogs</span><br><br>",$out);
$out = str_replace("Search terms</label><br />","Search terms</label>",$out);
$out = str_replace(" </body>\n\r</html>","<br><br><br>",$out);
$out = str_replace("method=\"post\" action=\".\"","method=\"get\" action=\"/blogs.php\"",$out);
$out = str_replace("<ul class=\"itemList\">","<div id=\"box\"><table border=0>",$out);
$out = str_replace("</ul>","</table></div>",$out);
$out = str_replace("<li class=\"item\">","<tr><td><img src=\"/gui/bullet.gif\"></td><td>",$out);
$out = str_replace("</li>","</td></tr>\n",$out);
$out = str_replace("rss_logo_small.gif","rss_logo_small2.gif",$out);
$out = str_replace("Blog <a","Blog : <a",$out);
$out = str_replace("<form id=\"searchForm\"","<!--\n<form id=\"searchForm\"",$out);
$out = str_replace("</form>","</form>\n-->",$out);
$out = preg_replace("|</div>[^<]*</div>[^<]*</body>[^<]*</html>|","",$out);
$start = strpos($out,"<div style=\"float:right");
$rpanel = substr($out,$start);
$lpanel = substr($out,0,$start);
$rpanel = str_replace("<div style=\"float:right\">","",$rpanel);
$lpanel = str_replace("</div></div>","</div>",$lpanel);
$start = strpos($lpanel,"</div>") + 6;
$lpanel1 = substr($lpanel,0,$start);
$lpanel2 = "<div id=\"box\">".substr($lpanel,$start)."</div>\n";
if (isset($_GET["searchTerms"])) {
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "http://".DOMAIN."/blog/summary.php?op=summarySearch&searchTerms=".str_replace(" ","+",$_GET["searchTerms"]));
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
$out = curl_exec($ch);
curl_close($ch);
$start = strpos($out,"<div id=\"onecolumn\">") + 20;
$out = substr($out,$start);
$out = substr($out,0,-40);
$out = str_replace("<img ","<img border=0 ",$out);
$out = str_replace("\"imgs/","\"/blog/imgs/",$out);
$out = str_replace("<h4>","<P><div id=\"heading\">",$out);
$out = str_replace("</h4>","</div>",$out);
$out = str_replace("<h5>","<span id=\"vred\" style=\"margin-bottom:5px;\">",$out);
$out = str_replace("</h5>","</span>",$out);
$out = str_replace("</p>","<br>",$out);
$out = str_replace("<p>","",$out);
$out = str_replace("class=\"noborder\"","style=\"text-decoration:none;\"",$out);
$out = str_replace("class=\"peu\"","style=\"color:#999999;margin-top:6px;\"",$out);
$out = str_replace("id=\"column-right\"","style=\"float:right\"",$out);
$out = str_replace("<div class=\"subtitle\">","<div style=\"margin:0px 0px 25px 15px;\"><div class=\"subtitle\" style=\"margin:6px 0px 6px 0px;\">",$out);
$out = str_replace("<br style=\"clear: both;\" />","",$out);
$out = str_replace("Comment</a>","Comment</a></div>",$out);
$out = str_replace("Comments</a>","Comments</a></div>",$out);
$search = "<div id=\"heading\">Search Blogs</div><div id=\"box\">\n".$out."</div>\n";
}
echo "<div class=\"pagebody\">\n";
echo "<br><div style=\"float:right\"><a href=\"/blog/admin.php\" target=\"_blank\">Blog Admin Login</a></div>Would you like to start your own Employee Blog? <a href=\"mailto:awaldron@vocollect.com\">Email Alan Waldron to get set up.</a><br>\n";
echo "<br><table border=0><tr><td widht=75% valign=\"top\">\n\n\n".($search?$search:$lpanel1.$lpanel2)."\n\n\n</td><td width=12><img src=\"/gui/clear.gif\" width=12 height=1></td><td width=25% valign=\"top\">\n\n\n".$s.$rpanel.$ins."</td></tr></table>\n";
echo "</div>\n";
include("_pageend.php");
?>