") !== false) { $xpcont=explode("[/caption]

", $pcont)[1]; } else if (strpos($xpcont, "[/caption]") !== false) { $xpcont=explode("[/caption]", $pcont)[1]; } $paras = explode(" 2) { $oth = explode("<", $paras[1]); $retval = " ... "; for ($i=0; $i", $oth[$i]); $retval .= str_replace("'", "`", str_replace("}", " ", str_replace("{", " ", $huh[-1 + sizeof($huh)]))); } return substr($retval,0,200); } return ""; } function permalinkit($ins) { global $pdate; $outs=strtolower($ins); $outs=str_replace("+","",$outs); $outs=str_replace(".","",$outs); $outs=str_replace("#","",$outs); $outs=str_replace("/","",$outs); $outs=str_replace(" ","-",$outs); $outs=str_replace(" ","-",$outs); $outs=str_replace("\\", "",$outs); $outs=str_replace("!", "",$outs); $outs=str_replace(",", "",$outs); $outs=str_replace("---","-",$outs); $outs=str_replace("--","-",$outs); if (str_replace('code-download-table','',$outs) != $outs) { $xp=explode("GETME", $pdate); $prexp=explode("/", $xp[0]); $postprexp=explode(".", $prexp[-1 + sizeof($prexp)]); $extis = str_replace("GETME","",str_replace("-","",str_replace("_","",$postprexp[-1 + sizeof($postprexp)]))); $outs="../getmelist.htm?topoff=150&tsp=" . rand(100, 2000000) . "#" . $postprexp[0] . "." . str_replace($extis,"",$postprexp[-1 + sizeof($postprexp)]) . "GETME" . $extis; } return $outs; } $delim = "Is Mentioned By - RJM Programming - August, 2016"; $retval = ""; $ourtitle = ""; $yourtitle = ""; $criteria = ""; if (isset($_GET['title'])) { $yourtitle = urldecode($_GET['title']); $ourtitle=str_replace('$%#','',str_replace('"$%#','',($yourtitle . '$%#'))); } else if (isset($_POST['title'])) { $yourtitle = urldecode($_POST['title']); $ourtitle=str_replace('$%#','',str_replace('"$%#','',($yourtitle . '$%#'))); } $ourother = $ourtitle; if ($ourtitle != "") { $words = explode(" ", str_replace(" Tutorial", "", $ourtitle)); if (sizeof($words) > 5) { $criteria = $words[0] . " " . $words[1] . " " . $words[2] . " " . $words[3]; $ourother = $criteria; } else if (sizeof($words) > 4) { $criteria = $words[0] . " " . $words[1] . " " . $words[2]; $ourother = $criteria; } else if (sizeof($words) > 3) { $criteria = $words[0] . " " . $words[1]; $ourother = $criteria; } } if ($ourtitle != "") { $hostname = 'localhost'; /*** mysql username ***/ $username = 'username'; /*** mysql ***/ $password = 'password'; $dbname = 'database_name'; if (isset($_GET['dbname'])) $dbname = $_GET['dbname']; $tname = 'wp_posts'; $link = mysqli_connect($hostname, $username, $password); if (!$link) { die('Could not connect: ' . mysqli_error($link)); } mysqli_select_db($link,$dbname); $secresult=""; if (isset($_GET['debug'])) { file_put_contents("x.xxx","S"); } $afterone=''; $noteq='!'; $midclause=""; $afterand=''; if (strpos($ourtitle, ' ') !== false) { $orbit= " OR " . $tname . ".post_content like '%" . str_replace('youllneverfindthis','%',permalinkit($ourtitle)) . "%' " . " OR " . $tname . ".post_content like '%" . str_replace('youllneverfindthis','%',$ourother) . "%' " . " OR " . $tname . ".post_content like '%" . str_replace('youllneverfindthis','%',$ourtitle) . "%') "; $midclause=" UNION SELECT " . $tname . ".post_title, " . $tname . ".post_content as guid, ' ' as post_content, -1 as tfind, (-480 + TIMESTAMPDIFF(MINUTE,NOW()," . $tname . ".post_modified)) as tother, " . $tname . ".post_modified as post_date FROM " . $tname . " WHERE " . $tname . ".post_status = 'publish' AND " . $tname . ".post_modified > NOW() - INTERVAL 1 MONTH "; $afterand=" (1 = 1" . $afterone . " OR LOWER(" . $tname . ".post_title) " . $noteq . "= LOWER('" . $ourtitle . "')) " . " AND (" . $tname . ".post_content like CONCAT(CONCAT('%?p='," . $tname . ".guid), '%') "; } else { $noteq=''; $afterone='1'; $orbit= " SUBSTRING(" . $tname . ".post_content,1,240) like '%" . str_replace('youllneverfindthis','%',$yourtitle) . "%' "; } if (isset($_GET['debug'])) { file_put_contents("xxx.xxx","SELECT " . $tname . ".post_title, " . $tname . ".guid, " . $tname . ".post_content, LOCATE('" . $ourtitle . "'," . $tname . ".post_content) as tfind, LOCATE('" . $ourother . "'," . $tname . ".post_title) as tother, " . $tname . ".post_date as post_date FROM " . $tname . " WHERE " . $tname . ".post_status = 'publish' " . " AND " . $afterand . $orbit . " UNION SELECT " . $tname . ".post_title, " . $tname . ".post_content as guid, ' ' as post_content, -1 as tfind, (-480 + TIMESTAMPDIFF(MINUTE,NOW()," . $tname . ".post_modified)) as tother, " . $tname . ".post_modified as post_date FROM " . $tname . " WHERE " . $tname . ".post_status = 'publish' AND " . $tname . ".post_modified > NOW() - INTERVAL 1 MONTH " . " UNION SELECT 'Code Download Table' as post_title, " . $tname . ".post_content as guid, '' as post_content, 1 as tfind, 0 as tother, CURTIME() as post_date FROM " . $tname . " WHERE " . $tname . ".post_status = 'publish' " . " AND LOWER(" . $tname . ".post_title) = LOWER('" . $ourtitle . "') " . " AND " . $tname . ".post_content like '%GETME%' ORDER BY post_date "); } $res = mysqli_query($link,"SELECT " . $tname . ".post_title, " . $tname . ".guid, " . $tname . ".post_content, LOCATE('" . $ourtitle . "'," . $tname . ".post_content) as tfind, LOCATE('" . $ourother . "'," . $tname . ".post_title) as tother, " . $tname . ".post_date as post_date FROM " . $tname . " WHERE " . $tname . ".post_status = 'publish' " . " AND " . $afterand . $orbit . $midclause . " UNION SELECT 'Code Download Table' as post_title, " . $tname . ".post_content as guid, '' as post_content, 1 as tfind, 0 as tother, CURTIME() as post_date FROM " . $tname . " WHERE " . $tname . ".post_status = 'publish' " . " AND LOWER(" . $tname . ".post_title) = LOWER('" . $ourtitle . "') " . " AND " . $tname . ".post_content like '%GETME%' ORDER BY post_date "); if (isset($_GET['debug'])) { file_put_contents("x.xx","SELECT " . $tname . ".post_title, " . $tname . ".guid, " . $tname . ".post_content, LOCATE('" . $ourtitle . "'," . $tname . ".post_content) as tfind, LOCATE('" . $ourother . "'," . $tname . ".post_title) as tother, " . $tname . ".post_date as post_date FROM " . $tname . " WHERE " . $tname . ".post_status = 'publish' " . " AND " . $afterand . $orbit . $midclause . " UNION SELECT 'Code Download Table' as post_title, " . $tname . ".post_content as guid, '' as post_content, 1 as tfind, 0 as tother, CURTIME() as post_date FROM " . $tname . " WHERE " . $tname . ".post_status = 'publish' " . " AND LOWER(" . $tname . ".post_title) = LOWER('" . $ourtitle . "') " . " AND " . $tname . ".post_content like '%GETME%' ORDER BY post_date "); } if ($res == 0) { if (isset($_GET['debug'])) { file_put_contents("xx.xxz",""); } if (1 == 2) echo("Error " . mysqli_errno($link) . ": " . mysqli_error($link) . ""); } else if (mysqli_num_rows($res) == 0) { if (isset($_GET['debug'])) { file_put_contents("xx.xxy",""); } if (1 == 2) echo("Query executed successfully"); $retval=$delim; $retval = str_replace(" }", " parent.document.getElementById('d" . permalinkit($ourtitle) . "').innerHTML=''; }", $retval); } else { while (($r_array = mysqli_fetch_row($res))) { if ($r_array[3] == "-1" && strpos(("" . $r_array[4]), "-") !== false) { if (isset($_GET['debug'])) { file_put_contents("xx.xxw",""); } if ($secresult == "") { $secresult="  "; } if ($r_array[4] <= -11520) { $blks=(40 - floor((0 - $r_array[4]) / (24 * 60))); $optv='"; } $secresult=str_replace('>Modified','>Modified' . $optv . '