function get_asstOptions($id) { $return = replace_output(HH_SELECT_OPTION1, array('id' => '', 'name' => ' - Select Assortment -')); $query = "select rca.id as id, asst.name as name from rel_cac_assts rca \n\t\t\t\t\tjoin rel_cats_cols rcac on rca.cacid=rcac.id \n\t\t\t\t\tleft join categories cat on rcac.catid=cat.id\n\t\t\t\t\tleft join collections col on rcac.colid=col.id\n\t\t\t\t\tleft join assortments asst on rca.asstid = asst.id\n\t\t\t\t\t\twhere rca.cacid='" . $id . "'\n\t\t\t\t\t\torder by asst.sortOrder asc, asst.name asc"; $result = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_assoc($result)) { $return .= replace_output(HH_SELECT_OPTION1, array('id' => $row['id'], 'name' => htmlentities(stripslashes($row['name'])))); } return $return; }
function get_biz() { // INIT VARS \\ global $path_site; $return = NULL; $LIMIT = " LIMIT 9"; // GET TOTAL FEATURED COUNT AND PUT IN ARRAY $time = time(); $query = "select b.urlPM as name,b.name as title, b.desc as `desc`, i.filepath as fp, i.file as f from business b \n\t\t\t\t\tleft join images i on b.id = i.itemid\n\t\t\t\t\t\twhere i.item='businessicon' and b.flag_feat='1' and b.feat_start < '" . $time . "' and b.feat_end > '" . $time . "' and b.`status`='active' and b.dateExpires > '" . $time . "'\n\t\t\t\t\t\t\torder by RAND()" . $LIMIT; $result = mysql_query($query) or die(mysql_error()); $count = mysql_num_rows($result); if ($count > 0) { while ($row = mysql_fetch_assoc($result)) { $seoPhrase = preg_replace('/[[:punct:]]*/i', '', stripslashes($row['desc'])); $seoPhrase = preg_replace('/[[:space:]]+/i', '-', $seoPhrase); $return .= replace_output(HH_PM_FM1, array('name' => stripslashes($row['title']), 'description' => stripslashes($row['desc']), 'p_link' => SITE_BASEURL . $row['name'] . '/' . $seoPhrase, 'src' => SITE_BASEURL . $row['fp'] . $row['f'])); } } else { $return = ERROR_MS_BIZ1; } $return = replace_output(file_get_contents($path_site . 'inc/cb/favorite_business_box.inc'), array('path_site' => SITE_BASEURL, 'business_list' => $return)); return $return; }
<?php session_start(); require 'include.php'; $ID = replace_input($_GET['id']); $Query = mysql_query("Select `Page`,`Time`,`Data`,`Deleted`\n\t\t\t\t\t\tfrom `Pages`\n\t\t\t\t\t\twhere `ID`='{$ID}'\n\t\t\t\t\t\tlimit 1"); list($Page, $Time, $Data, $Deleted) = mysql_fetch_array($Query); if ($Time and !$Deleted) { echo replace_output($Data); }
<a href='javascript:Render()' style='font-weight:bold'>Render HTML</a> | <a href='javascript:UnRender()' style='font-weight:bold'>UnRender HTML</a> <?php $ID = replace_input($_GET['id']); $Query = mysql_query("Select `Page`,`Time`,`Data`,`Deleted`\n\t\t\t\t\t\tfrom `Pages`\n\t\t\t\t\t\twhere `ID`='{$ID}'\n\t\t\t\t\t\tlimit 1"); list($Page, $Time, $Data, $Deleted) = mysql_fetch_array($Query); if ($Time and (!$Deleted or $_SESSION['Click']['User'])) { $Time = date("G:i:s T", $Time); echo "<!-- Start Click Nav --> <div style='float:right' id='click-nav'>"; if (in_array($_SESSION['Click']['User'], array('click', 'rachel', 'wetfish', 'guthbrandr'))) { echo "\t<a href='#Submit' id='click-submit'>Submit</a>\n\t\t\t\t \n\t\t\t\t<a href='#Edit' id='click-edit'>Edit</a>\n\t\t\t\t \n\t\t\t\t<a href='delete.php?id={$ID}'>Delete</a>\n\t\t\t"; } else { echo " <a href='/login.php' id='click-login'>Login</a>"; } $Data = replace_output($Data); echo " <a href='/{$Page}' id='click-thread'>View Thread</a>"; echo "<!-- Close Click Nav --> </div>"; echo "<!-- Close Click Header --> <hr /></div>"; echo "<div id='click-content'>{$Data}</div>"; } ?> <hr /> <center> <iframe id='leader-friend' src='https://ads.wetfish.net/friendship/leader.html' style='width:750px; height:115px; border:0; outline:0; overflow:hidden;' scrolling="no"></iframe> </center>