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>
