if ($newletter){
$newletter = ereg_replace(' ','_',$newletter);
header("Location: /software/$newletter");
}
?>
<%insert_title%> - Software software
<%include:header%>
$kwarray = explode("/",$REQUEST_URI);
if (!$offset){
$letter = $kwarray[2];}
if (($offset)||($offset == '0')){
$letter = $kwarray[3];}
$letter = ereg_replace('_',' ',$letter);
?>
include 'leaderboard.php'; ?>
<%include:ticker%>
echo "";
if ($letter == 'a') echo "A"; else echo "A";
echo " | ";
if ($letter == 'b') echo "B"; else echo "B";
echo " | ";
if ($letter == 'c') echo "C"; else echo "C";
echo " | ";
if ($letter == 'd') echo "D"; else echo "D";
echo " | ";
if ($letter == 'e') echo "E"; else echo "E";
echo " | ";
if ($letter == 'f') echo "F"; else echo "F";
echo " | ";
if ($letter == 'g') echo "G"; else echo "G";
echo " | ";
if ($letter == 'h') echo "H"; else echo "H";
echo " | ";
if ($letter == 'i') echo "I"; else echo "I";
echo " | ";
if ($letter == 'j') echo "J"; else echo "J";
echo " | ";
if ($letter == 'k') echo "K"; else echo "K";
echo " | ";
if ($letter == 'l') echo "L"; else echo "L";
echo " | ";
if ($letter == 'm') echo "M"; else echo "M";
echo " | ";
if ($letter == 'n') echo "N"; else echo "N";
echo " | ";
if ($letter == 'o') echo "O"; else echo "O";
echo " | ";
if ($letter == 'p') echo "P"; else echo "P";
echo " | ";
if ($letter == 'q') echo "Q"; else echo "Q";
echo " | ";
if ($letter == 'r') echo "R"; else echo "R";
echo " | ";
if ($letter == 's') echo "S"; else echo "S";
echo " | ";
if ($letter == 't') echo "T"; else echo "T";
echo " | ";
if ($letter == 'u') echo "U"; else echo "U";
echo " | ";
if ($letter == 'v') echo "V"; else echo "V";
echo " | ";
if ($letter == 'w') echo "W"; else echo "W";
echo " | ";
if ($letter == 'x') echo "X"; else echo "X";
echo " | ";
if ($letter == 'y') echo "Y"; else echo "Y";
echo " | ";
if ($letter == 'z') echo "Z"; else echo "Z";
echo " ";
?>
if (!$letter){
echo "Please choose a character";
} else {
if (strlen($letter) > 1){
echo "You can only choose one character";
} else {
$limit=30; // rows to return
if (!$offset)
$offset = 0;
$goodcounter = $offset + 1;
$numrows = mysql_num_rows(mysql_query("SELECT DISTINCT (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 '$letter%'"));
if ($numrows < 1) {
echo "no results, try again";
}
else {
$sqlquery = "SELECT link_name, link_desc, inl_links.link_id, cust1, cust7, link_rating, link_votes, link_hits, 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 '$letter%' group by link_name order by link_name ASC 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 |
User Rating |
Votes |
Downloads |
$i = 0;
while ($row = mysql_fetch_array($result)) {
$id = mysql_result($result,$i,"link_id");
$pulledcat = mysql_result($result,$i,"cat_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");
$rating = mysql_result($result,$i,"link_rating");
$votes = mysql_result($result,$i,"link_votes");
$downloads = mysql_result($result,$i,"link_hits");
$fproduct = ereg_replace(' ','_',$product);
$fproduct = ereg_replace('\'','',$fproduct);
$rating = number_format($rating,2);
if ($rating == '0.00')
$rating = "Not Rated";
else
$rating = "$rating/5.00";
$count = $i + $goodcounter;
?>
if ($count == '4') { ?>
include 'leaderboard.php'; ?>
|
} ?>
if ($count == $middle) { ?>
|
include 'leaderboard.php'; ?>
|
| =$count?>. |
=$product?> =$version?> if ($aff){ ?>EDITOR'S PICK } ?> |
=$license?> |
=$rating?> |
=$votes?> |
=$downloads?> |
 |
| =$desc?> |
} else { ?>
| =$count?>. |
=$product?> =$version?> if ($aff){ ?>EDITOR'S PICK } ?> |
=$license?> |
=$rating?> |
=$votes?> |
=$downloads?> |
 |
| =$desc?> |
} $i++; }?>
}}} ?>
<%include:footer%> |