All pastes #287637 Raw Edit

Untitled

public text v1 · immutable
#287637 ·published 2006-12-21 17:16 UTC
rendered paste body
<?php
error_reporting(E_ALL);
header("Cache-Control: no-cache, must-revalidate");
if ( !@mysql_connect('localhost', 'root', '') ) die(mysql_error());
if ( !@mysql_select_db('blog') ) die(mysql_error());
$ozel_sayfalar = array('index', 'source', 'arama', 'tum_sayfalar');
$icerik = false;
$sag = true;

if ( isset($_GET['adres']) ) $adres = mysql_real_escape_string(htmlspecialchars($_GET['adres']));
else $adres = false;

if ( isset($_GET['q']) && strlen($_GET['q']) > 2 ) 
$q = mysql_real_escape_string(htmlspecialchars($_GET['q']));
else $q = false;

if ( isset($_GET['sayfa']) && is_numeric($_GET['sayfa']) ) $sayfa = mysql_real_escape_string(htmlspecialchars($_GET['sayfa']));
else $sayfa = 1;

//title okunuyor
if ( $adres ) {
	$result = mysql_query('SELECT `title` FROM `sayfalar` WHERE `adi` = \'' . $adres . '\' LIMIT 1;');
	$row = mysql_fetch_assoc($result);
	if ( $row['title'] ) $title = $row['title'];
	else $title = false;
}
else $title = false;


?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9">
<meta name="description" content="Ono a.k.a Debian ki&#351;isel web sitesi">
<meta name="keywords" content="Ono, Onur, Debian, Siyahport, Onur Aslan, Onur Cigicigi, Onur Siyahport, Turkfantezi, Ono Kimdir, PHP, MySQL, Blog, Hakk&#305;mda">
<meta name="verify-v1" content="cKdZH6robVlt1DnsGSDDV5QiM0LJvXuiaBfUJBfEP3g=">
<title><?php if ( $title ) echo $title . ' - '; ?>Ono'nun Blo&#287;u</title>
<style type="text/css">
<!--
body, input, textarea {
	font-family: sans-serif, Arial, Helvetica;
	font-size: 14px;
	margin: 0px;
}
a:link, a:active, a:visited {
	color: #660000;
	font-weight: bold;
	text-decoration: none;
}
.logo:link, .logo:active, .logo:visited, .logo:hover {
	color: #FFFFFF;
	font-weight: bold;
	text-decoration: none;
}
a:hover {
	color: #000000;
}
h1 {
	font-size: 24px;
	margin: 0px;
}
h2 {
	font-size: 20px;
	margin: 0px;
	margin-bottom: 5px;
}
h3 {
	font-size: 18px;
	margin: 5px;
	margin-left: 0px;
}
td {
	vertical-align:top;
}
textarea {
	height: 100px;
}
form {
	margin: 0px;
	padding: 0px;
}
.yorum {
	margin: 8px;
}
.ufak {
	font-size: 10px;
}
.blur{
	background-color: #ccc; /*shadow color*/
	color: inherit;
	margin-left: 4px;
	margin-top: 4px;
}
.shadow, .content{
	position: relative;
	bottom: 2px;
	right: 2px;
}
.shadow{
	background-color: #666; /*shadow color*/
	color: inherit;
}
.content{
	background-color: #fff; /*background color of content*/
	color: #000; /*text color of content*/
	border: 1px solid #000; /*border color*/
	padding: .5em 2ex;
}
-->
</style>
</head>

<body>

<!-- ROOT TABLO -->
<table width="1000" border="0" cellspacing="0" cellpadding="0" align="center">
<tr><td>

<!-- UST TABLO -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td style="background-color: #000033; color:#FFFFFF; padding: 5px; height: 35px; vertical-align: middle;" align="right"><form name="arama_sag" method="get" action="arama.html"><input name="q" type="text" value="<?php echo $q; ?>" style="width: 100px;">
<input type="submit" style="width: 50px;" value="Ara">
</form></td>
  </tr>
  <tr>
    <td style="background-color:  #003366; color:#FFFFFF; padding: 25px 0px 25px 0px;" align="center"><h1><a href="index.html" class="logo">Klaus Von Eisenerz - Der Übermensch </a></h1></td>
  </tr>    
  <tr>
    <td style="background-color: #000033; color:#FFFFFF; font-size: 11px; padding: 8px; height: 35px; vertical-align: middle;" align="right"><a href="tum_sayfalar.html" class="logo">[ Tüm Sayfalar&#305; Listele ]</a></td>
  </tr>
</table>
<!-- / UST TABLO -->

<br>

<!-- ANA TABLO -->
<div style="margin: 0px;">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td style="padding-right: 15px;">
<!-- SOL SÜTUN -->
<?php

if ( $adres == $ozel_sayfalar[0] ) $adres = false;

if ( $adres == $ozel_sayfalar[1] ) {
	echo '<div class="blur"><div class="shadow"><div class="content"><pre style="font-size: 10px">' . htmlspecialchars(fread(fopen($_SERVER['SCRIPT_FILENAME'], 'r'), filesize($_SERVER['SCRIPT_FILENAME']))) . '</pre></div></div></div>';
	$sag = false;
}
else if ( $adres == $ozel_sayfalar[2] ) {
	echo '<div class="blur"><div class="shadow"><div class="content"><h2>Arama</h2>';
	
	echo '<form name="arama" method="get" action="arama.html">
<input name="q" type="text" value="' . $q . '" style="width: 200px;">
<input type="submit" style="width: 120px;" value="Ara">
</form>';
	
	if ( $q ) {
		$i = 0;
		echo '<br><br>Aranan <strong>' . $q . '</strong> için bulunan sonuçlar:<br>';
		$result = mysql_query('SELECT `adi`, `title` FROM `sayfalar` WHERE `title` LIKE \'%' . $q . '%\' OR `icerik` LIKE \'%' . $q . '%\' OR `devami` LIKE \'%' . $q . '%\' LIMIT 100;');
		while ( $row = mysql_fetch_assoc($result) ) {
			echo '<div class="yorum">+ <a href="' . $row['adi'] . '.html">' . $row['title'] . '</a></div><br>';
		}
		
	}
	
	echo '</div></div></div>';
}
else if ( $adres == $ozel_sayfalar[3] ) {
	
	$i = 0;

	echo '<div class="blur"><div class="shadow"><div class="content"><h1>Tüm Sayfalar</h1>';

	//Öncelikle kategoriler seçiliyor
	$result = mysql_query('SELECT * FROM `kategoriler` ORDER BY `adi` ASC');
	while ( $row = mysql_fetch_assoc($result) ) {
		echo '<br><a name="' . $row['adi'] . '"></a><strong>' . $row['adi'] . '</strong><br>';
		$result2 = mysql_query('SELECT `adi`, `title` FROM `sayfalar` WHERE `cid` = \'' . $row['id'] . '\' ORDER BY `title` ASC LIMIT 50;');
		while ( $row2 = mysql_fetch_assoc($result2) ) {
			echo '- <a href="' . $row2['adi'] . '.html">' . $row2['title'] . '</a><br>' . "\n";
			$i++;
		}
	}

	mysql_free_result($result);

	echo '<br><a name="Di&#287;er"></a><strong>Di&#287;er</strong><br>';
	$result = mysql_query('SELECT `adi`, `title` FROM `sayfalar` WHERE `cid` = \'0\' ORDER BY `title` ASC LIMIT 50;');
	while ( $row = mysql_fetch_assoc($result) ) {
		echo '- <a href="' . $row['adi'] . '.html">' . $row['title'] . '</a><br>' . "\n";
		$i++;
	}

	echo '<br><font class="ufak">Toplam <strong>' . $i . '</strong> adet sayfa bulunmaktad&#305;r.</font></div></div></div>';

}

else if ( $adres ) {
	$result = mysql_query('SELECT * FROM `sayfalar` WHERE `adi` = \'' . $adres . '\' LIMIT 1;');
	$row = mysql_fetch_assoc($result);
	if ( $row['id'] && $row['script'] ) { 
		echo '<div class="blur"><div class="shadow"><div class="content"><h2>' . $row['title'] . '</h2>' . $row['icerik'] . '<br><br>' . "\n"; include 'scripts/' . $row['devami'];
		$row['count']++;
		mysql_query('UPDATE `sayfalar` SET `count` = \'' . $row['count'] . '\' WHERE `id` = \'' . $row['id'] . '\' LIMIT 1;');
		$icerik .= '<br><br>' . "\n" . '<font class="ufak">Bu sayfa <strong>' . date('d.m.Y H:i', $row['date']) . '</strong> tarihinde eklendi ve toplam <strong>' . $row['count'] . '</strong> kere gösterildi.</font></div></div></div>';
	}
	else if ( $row['id'] ) {
		//Sayaç artt&#305;r&#305;l&#305;yor
		$row['count']++;
		mysql_query('UPDATE `sayfalar` SET `count` = \'' . $row['count'] . '\' WHERE `id` = \'' . $row['id'] . '\' LIMIT 1;');
		$icerik .=  '<div class="blur"><div class="shadow"><div class="content"><h2>' . $row['title'] . '</h2>'  . "\n" . $row['icerik']  . "\n";
		if ( $row['devami'] ) $icerik .= '<br><br>' . "\n" . $row['devami'] . "\n";
		$icerik .= '<br><br>' . "\n" . '<font class="ufak">Bu sayfa <strong>' . date('d.m.Y H:i', $row['date']) . '</strong> tarihinde eklendi ve toplam <strong>' . $row['count'] . '</strong> kere gösterildi.</font></div></div></div><br>';
		
		//Yorumlar aç&#305;ksa yorumlar gösterilecek
		if ( $row['yorumlar'] ) {
			if ( isset($_POST['Submit']) ) {
				//E&#287;er adam yorum gönderdiyse
				//echo '<div class="blur"><div class="shadow"><div class="content"><h2>Yorum Gönder</h2>';
				if ( !isset($_POST['nick']) || !isset($_POST['email']) || 
				!isset($_POST['yorum']) || strlen($_POST['nick']) > 255 || strlen($_POST['email']) > 255 || strlen($_POST['yorum']) > 3000 ||
				!$_POST['nick'] || !$_POST['yorum'] ) 
				echo '<div class="blur"><div class="shadow"><div class="content"><strong>HATA</strong> Yorumunuz eklenmedi.</div></div></div><br>'; 
			 
				else {
				if ( !$_POST['email'] ) $_POST['email'] = 'nobody@nobody.com';
				mysql_query('INSERT INTO `yorumlar` ( `id`, `sid`, `yazar`, `email`, `yorum`, `date` ) VALUES
				( NULL, \'' . $row['id'] . '\', \'' . mysql_real_escape_string(htmlspecialchars($_POST['nick'])) . '\',
				\'' . mysql_real_escape_string(htmlspecialchars($_POST['email'])) . '\',
				\'' . mysql_real_escape_string(htmlspecialchars($_POST['yorum'])) . '\',
				\'' . time() . '\' );');
					//echo 'Yorumunuz eklendi, geldi&#287;iniz sayfaya geri dönmek için <a href="' . htmlspecialchars($_POST['ref']) . '">buray&#305;</a> t&#305;klay&#305;n&#305;z.';
				}
				//echo '</div></div></div>';
			}

			$icerik .=  '<div class="blur"><div class="shadow"><div class="content"><h2>Yorumlar</h2>';
			$result = mysql_query('SELECT * FROM `yorumlar` WHERE `sid` = \'' . $row['id'] . '\' ORDER BY `id` ASC LIMIT 50;');
			$i = 1;
			while ( $yorumrow = mysql_fetch_assoc($result) ) {
				$icerik .= '<strong>#' . $i . '</strong> <a href="mailto:' . $yorumrow['email'] . '">' . $yorumrow['yazar'] . '</a><br>
' . "\n" . '<div class="yorum">' . str_replace("\n", '<br>', $yorumrow['yorum']) . '</div><font class="ufak"><strong>' . date('d.m.Y H:i', $yorumrow['date']) . '</strong> tarihinde eklendi</strong></font><br><br>' . "\n";
				$i++;
			}
			if ( $i == 1 ) $icerik .= '<font class="ufak">Bu sayfaya kimse yorum göndermemi&#351;.</font><br><br>';
			$icerik .= '<hr><form name="yorumla" method="post" action="">
<table width="400" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="150">Nickiniz:</td>
    <td><input name="nick" type="text" id="nick"></td>
  </tr>
  <tr>
    <td>E-Mail Adresiniz: </td>
    <td><input name="email" type="text" id="email"></td>
  </tr>
  <tr>
    <td>Yorumunuz:</td>
    <td><textarea name="yorum" id="yorum"></textarea></td>
  </tr>
  <tr>
    <td><input type="submit" name="Submit" value="Gönder" style="width: 100px;"></td>
    <td>&nbsp;</td>
  </tr>
</table>
</form>';
		}
	}
	else echo '<div class="blur"><div class="shadow"><div class="content"><strong>Arad&#305;&#287;&#305;n&#305;z ' . $adres . '.html sayfas&#305; veritaban&#305;nda bulunamad&#305;</strong></div></div></div></div>';
}
else {

	$limit = ( $sayfa - 1 ) * 10;

	$result = mysql_query('SELECT * FROM `sayfalar` ORDER BY `id` DESC LIMIT ' . $limit . ' , 10;');
	while ( $row = mysql_fetch_assoc($result) ) {
		$icerik .=  '<div class="blur"><div class="shadow"><div class="content"><h2><a href="' . $row['adi'] . '.html">' . $row['title'] . '</a></h2>'  . "\n" . $row['icerik']  . "\n" . '<br><br><font class="ufak">' . date('d.m.Y', $row['date']) . ' tarihinde eklendi.</font>';
		if ( $row['devami'] ) $icerik .= ' <a href="' . $row['adi'] . '.html" class="ufak">Devam&#305;</a>';
		$icerik .=  '</div></div></div>' . "\n\n" . '<br>';
		//$icerik .= '<br><br>' . "\n" . 'Bu sayfa <strong>' . date('d.m.Y H:i', $row['date']) . '</strong> tarihinde eklendi ve toplam <strong>' . $row['count'] . '</strong> kere gösterildi.';
	}
	mysql_free_result($result);

	//Sayfalar
	function get_rows($table, $where) {
		if ( $where ) $sql = "SELECT SQL_CALC_FOUND_ROWS * FROM $table WHERE $where LIMIT 1";
		else $sql = "SELECT SQL_CALC_FOUND_ROWS * FROM $table LIMIT 1";
		$temp = mysql_query($sql);
		$result = mysql_query("SELECT FOUND_ROWS()");
		$total = mysql_fetch_row($result);
		return $total[0];
	}

	if ( ( $sayfalar = get_rows('sayfalar', '') ) > 10 ) {
		$icerik .= '<div align="center" class="ufak">Sayfalar: ';
		$sayfa_sayisi = $sayfalar / 10;
		settype($sayfa_sayisi, 'integer');
		for ( $i = 0; $i < $sayfa_sayisi+1; $i++ ) {
			$sayfa_s = $i+1;
			if ( $sayfa_s == $sayfa ) $icerik .= ' <a href="index.html?sayfa=' . $sayfa_s . '">' . $sayfa_s . '</a>';
			else $icerik .= ' <a href="index.html?sayfa=' . $sayfa_s . '" style="color: #000000;">' . $sayfa_s . '</a>';
		}
		$icerik .= '</div>';
	}

}


if ( $icerik ) echo $icerik;

?>

<!-- / SOL SÜTUN -->
     </td>

<?php if ( $sag ) { ?>

    <td width="200" style="font-size: 11px;">
<!-- SA&#286; SÜTUN -->
<div class="blur"><div class="shadow"><div class="content" style="background-color: #F1F1F1; padding: 6px;">
<strong>Arama</strong><br>
<form name="arama_sag" method="get" action="arama.html">
<input name="q" type="text" value="<?php echo $q; ?>" style="width: 100px;">
<input type="submit" style="width: 50px;" value="Ara">
</form>
<br>
<strong>Son 10 Sayfa</strong><br>
<?php

$result = mysql_query('SELECT `adi`, `title` FROM `sayfalar` ORDER BY `id` DESC LIMIT 10;');
while ( $row = mysql_fetch_assoc($result) ) {
	echo '- <a href="' . $row['adi'] . '.html">' . $row['title'] . '</a><br>' . "\n";
}


?>
<br>
- <a href="tum_sayfalar.html">Tüm Sayfalar</a>
</div></div></div>

<br>

<div class="blur"><div class="shadow"><div class="content" style="background-color: #F1F1F1; padding: 6px;">
<strong>Kategoriler</strong><br>
<?php
//Öncelikle kategoriler seçiliyor
$result = mysql_query('SELECT * FROM `kategoriler` ORDER BY `adi` ASC');
while ( $row = mysql_fetch_assoc($result) ) echo '- <a href="tum_sayfalar.html#' . $row['adi'] . '">' . $row['adi'] . '</a><br>' . "\n";

?>
</div></div></div>

<br>

<div class="blur"><div class="shadow"><div class="content" style="background-color: #F1F1F1; padding: 10px; text-align: center;">

    <a href="http://validator.w3.org/check?uri=referer"><img
        src="http://www.w3.org/Icons/valid-html401"
        alt="Valid HTML 4.01 Transitional" height="31" width="88" border="0"></a>

<br>

 <a href="http://jigsaw.w3.org/css-validator/">
  <img style="border:0;width:88px;height:31px"
       src="http://jigsaw.w3.org/css-validator/images/vcss" 
       alt="Valid CSS!" border="0">
 </a>

</div></div></div>

<!-- / SA&#286; SÜTUN -->
    </td>

<?php } ?>
	
  </tr>
</table>
</div>
<!-- / ANA TABLO -->
<br>
<hr>
<div align="center" class="ufak">
Copyleft 2006 <a href="http://www.0nur.net">Ono</a><br>
<?php echo $_SERVER['SERVER_SIGNATURE']; ?>
System time: <?php echo date('d.m.Y H:i'); ?><br>
Uptime: <?php echo exec('uptime'); ?><br><?php echo exec('uname -a'); ?><br>
</div>

</td></tr></table>
<!-- / ROOT TABLO -->

</body>
</html>