if ($newkeyword){
$newkeyword = ereg_replace(' ','_',$newkeyword);
header("Location: /marketplace/$newkeyword");
}
?>
<%insert_title%> - Software Store
<%include:header%>
$kwarray = explode("/",$REQUEST_URI);
if (!$offset){
$keyword = $kwarray[2];}
if (($offset)||($offset == '0')){
$keyword = $kwarray[3];}
$keyword = ereg_replace('_',' ',$keyword);
?>
include 'leaderboard.php'; ?>
<%include:ticker%>
Visit our RegNow Store, Click here to visit!
if (!$keyword){
echo "Please type in a keyword to begin your search.
";
} else {
if (strlen($keyword) < 3){
echo "Your search must be atleast 3 characters.";
} else {
$limit=20; // rows to return
if (!$offset)
$offset = 0;
$goodcounter = $offset + 1;
$numrows = mysql_num_rows(mysql_query("SELECT link_name, inl_links.link_id, cust1, cust3, cust7, cust20 FROM inl_links LEFT JOIN inl_custom ON inl_links.link_cust=inl_custom.cust_id where link_name like '%$keyword%' AND cust1 not like '%Free%'"));
if ($numrows < 1) {
echo "no results, try again";
}
else {
$sqlquery = "SELECT link_name, link_desc, inl_links.link_id, cust1, cust3, cust7, cust20, cat_id FROM inl_links LEFT JOIN inl_custom ON inl_links.link_cust=inl_custom.cust_id LEFT JOIN inl_lc ON inl_links.link_id=inl_lc.link_id where link_name like '%$keyword%' AND cust1 not like '%Free%' group by link_name order by link_hits DESC LIMIT $offset,$limit";
$result = mysql_query($sqlquery);
$numcounter = ($offset + $limit);
if ($numcounter > $numrows)
{
$numcounter = $numrows;
}
$pages=intval($numrows/$limit);
if ($numrows%$limit){
$pages++;}
$pagenumber = ($offset / $limit) + 1;
$middle = ($offset + $limit) - 9;
?>
| |
Product |
License |
Price |
Purchase |
$i = 0;
while ($row = mysql_fetch_array($result)) {
$pulledcat = mysql_result($result,$i,"cat_id");
$id = mysql_result($result,$i,"link_id");
$product = mysql_result($result,$i,"link_name");
$desc = mysql_result($result,$i,"link_desc");
$version = mysql_result($result,$i,"cust7");
$license = mysql_result($result,$i,"cust1");
$price = mysql_result($result,$i,"cust3");
$aff = mysql_result($result,$i,"cust20");
$price = number_format($price,2);
$fproduct = ereg_replace(' ','_',$product);
$fproduct = ereg_replace('\'','',$fproduct);
$count = $i + $goodcounter;
?>
if ($count == '4') { ?>
include 'leaderboard.php'; ?>
|
} ?>
if ($count == $middle) { ?>
|
include 'leaderboard.php'; ?> |
| =$count?>. |
=$product?> =$version?> if ($aff){ ?>EDITOR'S PICK } ?> |
=$license?> |
$=$price?> |
Buy Now |
 |
| =$desc?> |
} else { ?>
| =$count?>. |
=$product?> =$version?> if ($aff){ ?>EDITOR'S PICK } ?> |
=$license?> |
$=$price?> |
Buy Now |
 |
| =$desc?> |
} $i++; }?>
}}} ?>
<%include:footer%> |