<?php
include_once("includes.php");
// settings
$totalEntries = 0;
$numbCol = 2;
// get download id from GET
@$id = $_GET['dlid'];
if($id == "")
{
// let's make a connection and select the db
mysql_connect($DBserver, $DBuser, $DBpass) or die(mysql_error());
@mysql_select_db("knigga5_news") or die(mysql_error());
// Now we'll pull the downloads
$sqlstring = "SELECT id, name, descShort FROM downloads ORDER BY id;";
$sqlqueryresult = mysql_query($sqlstring) or die(mysql_error());
$downloadsArray = array();
while ($row = mysql_fetch_array($sqlqueryresult)) {
$downloadsArray[] = $row;
$totalEntries++;
};
// Done with SQL stuff, close DB
mysql_close();
// figure total number of rows
$numbRow = (int)($totalEntries / $numbCol);
if(($totalEntries % $numbCol) != 0)
{
$numbRow++;
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<?php include("meta.html"); ?>
<title> www.KNIGGA.com - downloads </title>
</head>
<body>
<p ALIGN="center">
<font SIZE="5">www.KNIGGA.com - downloads</font>
</p>
<hr NOSHADE WIDTH="80%">
<?php include("header.html"); ?>
<table ALIGN="center" BORDER="0" CELLPADDING="4" CELLSPACING="4" WIDTH="80%">
<?php
$pos = 0;
for($y = 0; $y < $numbRow; $y++)
{
echo "<tr>\n";
$rowID = $pos / $numbCol;
for($x = 0; $x < $numbCol; $x++)
{
echo "<td align='justify' valign='top' width='50%'>\n";
echo "<!--\nx: ".$x."\ny: ".$y."\npos: ".$pos."\n-->\n";
if($pos < $totalEntries)
{
?>
<div style="text-align: center; padding: 0; margin: 0;"><a href="/download.php?dlid=<?php echo $downloadsArray[$pos]['id']; ?>"><?php echo $downloadsArray[$pos]['name']; ?></a></div>
<?php echo $downloadsArray[$pos]['descShort']; ?>
<?php
}
echo "</td>\n";
$pos++;
}
echo "</tr>\n";
}
?>
</table>
<table ALIGN="center" CELLPADDING="4" width="80%">
<tr ALIGN="center" VALIGN="top">
<td>
if you use any of my stuff, all i ask is that you <a href="mailto:kris@knigga.com">e-mail me</a> and tell me how you like it. and while i don't require you to send money, or even expect you to, you can always send money to help a poor sysadmin.
<!-- Begin PayPal Logo -->
<table border="0" cellpadding="0" cellspacing="0" align="center"><tr><td align="right"><form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_s-xclick">
<input type="image" src="https://www.paypal.com/en_US/i/btn/x-click-but04.gif" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
<img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">
<input type="hidden" name="encrypted" value="-----BEGIN PKCS7-----MIIHbwYJKoZIhvcNAQcEoIIHYDCCB1wCAQExggEwMIIBLAIBADCBlDCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20CAQAwDQYJKoZIhvcNAQEBBQAEgYDBNoFr2L2Dejv0uV9H9X4QdhQagyOho9U/y32BC24sONu8+XvIWFl2q0DWCEUv1JttuXkY8DSi+RUf9SRzAZEMgsmaFJDsNqJBBMiC7+hcTuR3JP7QukQGZFAQYP6J59NJxfTBZf49ZQ6MjM1jVbVwtoP0tQODNjY7nMgHdz0qXDELMAkGBSsOAwIaBQAwgewGCSqGSIb3DQEHATAUBggqhkiG9w0DBwQIAXrkhlY2sZyAgchegia5OMMaJg1D81NW0Qhv2gbjDC9PLER9ECPQC8zQR3OMF1x3OeTymcy2c55k+ND9BGuKGTxtz6H3MA+HlE4xqC1Liyd5d07fykjjJyfSnF+hYHX5JZDats9IH+oYybtXrR5ZlDuwYLD1RsDPplMMGGVl+XzuNvWk2AkrJgxjTjL5adVRANIHQoxVRRxiMnFVZ4W9yV54McYmGJGov0zsLcM0efPkbNpUMziz/1nGZZaB+RxAgolW+hIwS4lwv2rkL7VvJQi4waCCA4cwggODMIIC7KADAgECAgEAMA0GCSqGSIb3DQEBBQUAMIGOMQswCQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExFjAUBgNVBAcTDU1vdW50YWluIFZpZXcxFDASBgNVBAoTC1BheVBhbCBJbmMuMRMwEQYDVQQLFApsaXZlX2NlcnRzMREwDwYDVQQDFAhsaXZlX2FwaTEcMBoGCSqGSIb3DQEJARYNcmVAcGF5cGFsLmNvbTAeFw0wNDAyMTMxMDEzMTVaFw0zNTAyMTMxMDEzMTVaMIGOMQswCQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExFjAUBgNVBAcTDU1vdW50YWluIFZpZXcxFDASBgNVBAoTC1BheVBhbCBJbmMuMRMwEQYDVQQLFApsaXZlX2NlcnRzMREwDwYDVQQDFAhsaXZlX2FwaTEcMBoGCSqGSIb3DQEJARYNcmVAcGF5cGFsLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAwUdO3fxEzEtcnI7ZKZL412XvZPugoni7i7D7prCe0AtaHTc97CYgm7NsAtJyxNLixmhLV8pyIEaiHXWAh8fPKW+R017+EmXrr9EaquPmsVvTywAAE1PMNOKqo2kl4Gxiz9zZqIajOm1fZGWcGS0f5JQ2kBqNbvbg2/Za+GJ/qwUCAwEAAaOB7jCB6zAdBgNVHQ4EFgQUlp98u8ZvF71ZP1LXChvsENZklGswgbsGA1UdIwSBszCBsIAUlp98u8ZvF71ZP1LXChvsENZklGuhgZSkgZEwgY4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJDQTEWMBQGA1UEBxMNTW91bnRhaW4gVmlldzEUMBIGA1UEChMLUGF5UGFsIEluYy4xEzARBgNVBAsUCmxpdmVfY2VydHMxETAPBgNVBAMUCGxpdmVfYXBpMRwwGgYJKoZIhvcNAQkBFg1yZUBwYXlwYWwuY29tggEAMAwGA1UdEwQFMAMBAf8wDQYJKoZIhvcNAQEFBQADgYEAgV86VpqAWuXvX6Oro4qJ1tYVIT5DgWpE692Ag422H7yRIr/9j/iKG4Thia/Oflx4TdL+IFJBAyPK9v6zZNZtBgPBynXb048hsP16l2vi0k5Q2JKiPDsEfBhGI+HnxLXEaUWAcVfCsQFvd2A1sxRr67ip5y2wwBelUecP3AjJ+YcxggGaMIIBlgIBATCBlDCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20CAQAwCQYFKw4DAhoFAKBdMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA2MDQzMDAzNDMzOVowIwYJKoZIhvcNAQkEMRYEFPk4IQqYjn6shMILEaFnpFTRuP/QMA0GCSqGSIb3DQEBAQUABIGAR1NCyFZi7TQ7lRECAeDxUFZIlOVd4W5bWCRgER142dv/4hBCy77omnS2xAJMvUeVNdFQaJBOV8k84L1ID0aJKdujK6jTY99nAxqdTWEmFfURcuseGIc/efJ9ioetLUVOMN73/JaGlHIhkBzN7pOzCKPeuJocH+yRx24cOqcsODY=-----END PKCS7-----
">
</form></td>
<td align="left"><img src="http://images.paypal.com/images/icon_visa.gif" border="0" alt="Visa"><img src="http://images.paypal.com/images/icon_mastercard.gif" border="0" alt="MasterCard" hspace=2><img src="http://images.paypal.com/images/icon_discover.gif" border="0" alt="Discover"><img src="http://images.paypal.com/images/icon_amex.gif" border="0" alt="American Express" hspace=2></td></tr></table>
<!-- End PayPal Logo -->
</td>
</tr>
</table>
<?php include("footer.html"); ?>
</body>
</html>
<?php
}
else
{
// let's make a connection and select the db
mysql_connect($DBserver, $DBuser, $DBpass) or die(mysql_error());
@mysql_select_db("knigga5_news") or die(mysql_error());
// Now we'll pull the downloads
$escaped_id = addslashes($id);
$sqlstring = "SELECT name, link, descShort, descLong FROM downloads WHERE id = '$escaped_id';";
$sqlqueryresult = mysql_query($sqlstring) or die(mysql_error());
$downloadsArray = array();
while ($row = mysql_fetch_array($sqlqueryresult)) {
$downloadsArray[] = $row;
};
// Done with SQL stuff, close DB
mysql_close();
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<?php include("meta.html"); ?>
<title> www.KNIGGA.com - downloads - <?php echo $downloadsArray[0]['name']; ?></title>
</head>
<body>
<p ALIGN="center">
<font SIZE="5">www.KNIGGA.com - downloads - <?php echo $downloadsArray[0]['name']; ?></font>
</p>
<hr NOSHADE WIDTH="80%">
<?php include("header.html"); ?>
<table ALIGN="center" BORDER="0" CELLPADDING="4" CELLSPACING="4" WIDTH="80%">
<tr>
<td>
<p><?php echo $downloadsArray[0]['name']; ?></p>
<hr>
<p><?php echo $downloadsArray[0]['descShort']; ?></p>
<p><?php echo $downloadsArray[0]['descLong']; ?></p>
<hr>
<p>Download: <a href="<?php echo $downloadsArray[0]['link']; ?>"><?php echo $downloadsArray[0]['name']; ?></a></p>
</td>
</tr>
</table>
<?php include("footer.html"); ?>
</body>
</html>
<?php
}
?>