Ziyaretci Defterinde Sorun

Notice: Undefined index: p in /var/www/vhosts/cannakliyat.org/httpdocs/ziyaretci/contents/oku.php on line 35

Notice: Use of undefined constant Y - assumed 'Y' in /var/www/vhosts/cannakliyat.org/httpdocs/ziyaretci/contents/oku.php on line 307

Notice: Use of undefined constant m - assumed 'm' in /var/www/vhosts/cannakliyat.org/httpdocs/ziyaretci/contents/oku.php on line 307

Notice: Use of undefined constant d - assumed 'd' in /var/www/vhosts/cannakliyat.org/httpdocs/ziyaretci/contents/oku.php on line 307

$baslat =date("Y"."-"."m"."-"."d");
$year =substr($baslat, 0,4);
$month =substr($baslat, 5, 2);
$day =substr($baslat, 8, 2);
$bitis =date("Y-m-d", mktime(0, 0, 0, $month, $day-1, $year));
echo "<font size='1'>";
$sorgula = mysql_query("select tarih from ziyaret where tarih='$bitis'");
$dunku = mysql_num_rows($sorgula);
echo $dunku;

echo "&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Bugün : ";

$bugun = date("Y-m-d");
$sorgu = mysql_query("select tarih from ziyaret where tarih='$bugun'");
$bugunku = mysql_num_rows($sorgu);
echo $bugunku;

echo "&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Online Ziyaretçi : ";

$ip = $_SERVER['REMOTE_ADDR'];
$past = time()-150;
mysql_query("DELETE FROM online WHERE time < $past");
$result = mysql_query("SELECT time FROM online WHERE ip='$ip'");
$time = time();
if($row = mysql_fetch_array($result)){
mysql_query("UPDATE online SET time='$time', ip='$ip' WHERE ip='$ip'");
}else{
mysql_query("INSERT INTO online (ip,time) VALUES ('$ip','$time')") or die(mysql_error());
}
$result = mysql_query("SELECT ip FROM online");
$onlinekac = mysql_num_rows($result);
echo $onlinekac;

<?php
/*
Hazırlayan ve Sunan : Duran Ömer çiçek
E-Mail : yorqunqaplan@hotmail.com
Script : PHP Ziyaretçi Defteri V 3.0 Tr
*/
include "contents/son_duyuru.php";

@$defter = mysql_query("select * from defter where onay=1");
@$bak = mysql_num_rows($defter);
if($bak>0){

$page = "?form=oku";
$limit = "8"; // sayfada görüntülenecek kayıt sayısı

if(empty($_GET['p'])) { $sayfa ="1";}
else{ $sayfa=$_GET['p'];
}
@$sorgu1 = mysql_query("select * from defter where onay=1"); //tablomuza baglandik
@$sayi = mysql_num_rows($sorgu1);

$kac_tane = $sayi / $limit;
$kac_tane = ceil($kac_tane);

$limitt = "4"; // gösterilecek sayfa numara sayısı
$i=$sayfa-$limitt+2;

$sinir = $sayfa+$limitt-2;
if($sinir>$kac_tane){
$sinir=$kac_tane;
}
if($i<1){ $i="1";}
$son = ($sayfa-1)*$limit;

if($_GET['p']>$sinir){
header("location:$page");
}

@$sorgu2 = mysql_query("select * from defter where onay=1 order by id DESC limit $son,$limit");
while(@$list=mysql_fetch_array($sorgu2)){ //while

@$id = $list['id'];
@$adsoyad = $list['adsoyad'];
@$mail = $list['mail'];
@$hotmail = $list['hotmail'];
@$yahoo = $list['yahoo'];
@$gmail = $list['gmail'];
@$icq = $list['icq'];
@$mynet = $list['mynet'];
@$internet = $list['internet'];
@$sehir = $list['sehir'];
@$metin = $list['metin'];
@$onay = $list['onay'];
@$zaman = $list['tarih'];
@$admin = $list['admin'];

@$yil = substr($zaman,0,4);
@$ay = substr($zaman,5,2);
@$gun = substr($zaman,8,2);
@$tarih = date("d F Y, D",mktime(0,0,0,$ay,$gun,$yil));
@$bul = array('January','February','March','April','May',' June','July','August','September','October','Novem ber','December','Mon','Tue','Wed','Thu','Fri','Sat ','Sun');
@$yaz = array('Ocak','Şubat','Mart','Nisan','Mayıs','Haz iran','Temmuz','Ağustos','Eylül','Ekim','Kasım' ,'Aralık','Pazartesi','Salı','Çarşamba','Perş embe','Cuma','Cumartesi','Pazar');
@$trtarih = str_replace($bul,$yaz,$tarih);

echo "<table border='0' width='100%' id='table3' cellpadding='0' style='border-collapse: collapse'>
<tr>
<td>
<table border='1' width='100%' id='table4' bordercolorlight='#E9E9E9' cellspacing='0' cellpadding='0' style='border-collapse: collapse' bordercolordark='#E9E9E9'>
<tr>
<td>
<table border='0' width='100%' id='table7' cellpadding='0' style='border-collapse: collapse'>
<tr>
<td width='2%' height='5'></td>
<td width='96%' height='5'></td>
<td width='2%' height='5'></td>
</tr>
<tr>
<td width='2%'>&nbsp;</td>
<td width='96%'>
<table border='0' width='100%' id='table8' cellpadding='0' style='border-collapse: collapse'>
<tr>
<td width='25%' valign='top'>
<table border='1' width='100%' id='table11' bordercolorlight='#F3F3F3' cellspacing='0' cellpadding='0' style='border-collapse: collapse' bordercolordark='#F3F3F3'>
<tr>
<td>

<!--mesaj yazan bilgileri-->
<table border='0' width='100%' id='table12' cellpadding='0' style='border-collapse: collapse'>
<tr>
<td width='13%' height='20' bgcolor='#F9F9F9'>
<p align='center'>
<img border='0' src='images/icon/ziyaretci.gif' width='16' height='16'></td>
<td width='4' height='20' bgcolor='#F9F9F9'>&nbsp;</td>
<td height='20' bgcolor='#F9F9F9'><b>$adsoyad</b></td>
</tr>
<tr>
<td height='5' width='13%'></td>
<td height='5' width='4'></td>
<td height='5'></td>
</tr>
<tr>
<td width='13%' height='20' bgcolor='#F9F9F9'>
<p align='center'>
<img border='0' src='images/icon/zaman.gif' width='16' height='16'></td>
<td width='4' height='20' bgcolor='#F9F9F9'>&nbsp;</td>
<td height='20' bgcolor='#F9F9F9'>$trtarih</td>
</tr>
<tr>
<td height='5' width='13%'></td>
<td height='5' width='4'></td>
<td height='5'></td>
</tr>
<tr>
<td width='13%' height='20' bgcolor='#F9F9F9'>
<p align='center'>
<img border='0' src='images/icon/sehir.gif' width='16' height='16'></td>
<td width='4' height='20' bgcolor='#F9F9F9'>&nbsp;</td>
<td height='20' bgcolor='#F9F9F9'>$sehir</td>
</tr>
<tr>
<td height='5' width='13%'></td>
<td height='5' width='4'></td>
<td height='5'></td>
</tr>";
if($admin==1){
echo "<tr>
<td width='13%' height='20' bgcolor='#F9F9F9'>
<p align='center'>
<img border='0' src='images/icon/mesaj.gif' width='16' height='16'></td>
<td width='4' height='20' bgcolor='#F9F9F9'>&nbsp;</td>
<td height='20' bgcolor='#F9F9F9'><font color='#197FE0'>Ziyaretçi Mesajı</font></td>
</tr>";
}elseif($admin==2){
echo "<tr>
<td width='13%' height='20' bgcolor='#F9F9F9'>
<p align='center'>
<img border='0' src='images/icon/admin.gif' width='16' height='16'></td>
<td width='4' height='20' bgcolor='#F9F9F9'>&nbsp;</td>
<td height='20' bgcolor='#F9F9F9'><font color='#6464AE'>Yönetici Mesajı</font></td>
</tr>";
}else{
echo "<tr>
<td width='13%' height='20' bgcolor='#F9F9F9'>
<p align='center'>
<img border='0' src='images/icon/mesaj.gif' width='16' height='16'></td>
<td width='4' height='20' bgcolor='#F9F9F9'>&nbsp;</td>
<td height='20' bgcolor='#F9F9F9'><font color='#197FE0'>Ziyaretçi Mesajı</font></td>
</tr>";
}
echo "</table>
<!--mesaj yazan bilgileri-->
</td>
</tr>
</table>
</td>
<td width='1%'>&nbsp;</td>
<td width='74%' valign='top'>
<table border='1' width='100%' id='table13' bordercolorlight='#F3F3F3' cellspacing='0' cellpadding='0' bordercolordark='#F3F3F3' style='border-collapse: collapse'>
<tr>
<td>
<table border='0' width='100%' id='table14' cellpadding='0' style='border-collapse: collapse' height='94'>
<tr>
<td height='5' bgcolor='#F9F9F9' width='100%' colspan='3'></td>
</tr>
<tr>
<td height='60' bgcolor='#F9F9F9' width='2%'></td>
<td height='60' bgcolor='#F9F9F9' width='96%' valign='top'>
<p align='justify'>$metin</td>
<td height='60' bgcolor='#F9F9F9' width='2%'>&nbsp;</td>
</tr>
<tr>
<td height='5' bgcolor='#F9F9F9' width='100%' colspan='3'></td>
</tr>
<tr>
<td height='5' colspan='3'></td>
</tr>
<tr>
<td height='20' align='center' bgcolor='#F9F9F9' colspan='3'>

<!--mail iconlar-->
<table border='0' id='table15' cellpadding='0' style='border-collapse: collapse'>
<tr>
<td>";
if($internet==""){
echo "<img border='0' src='images/icon/int_pass.gif' width='60' height='20'>";
}elseif($internet=="http://"){
echo "<img border='0' src='images/icon/int_pass.gif' width='60' height='20'>";
}else{
echo "<a href='$internet' target='_blank'><img border='0' src='images/icon/int.gif' width='60' height='20'></a>";
}
echo "</td>
<td>&nbsp;</td>
<td>";
if($mail==""){
echo "<img border='0' src='images/icon/email_pass.gif' width='60' height='20'>";
}else{
echo "<img border='0' src='images/icon/email.gif' width='60' height='20' alt='$mail'>";
}
echo "</td>
<td>&nbsp;</td>
<td>";
if($hotmail==""){
echo "<img border='0' src='images/icon/msn_pass.gif' width='60' height='20'>";
}else{
echo "<img border='0' src='images/icon/msn.gif' width='60' height='20' alt='$hotmail'>";
}
echo "</td>
<td>&nbsp;</td>
<td>";
if($yahoo==""){
echo "<img border='0' src='images/icon/yahoo_pass.gif' width='60' height='20'>";
}else{
echo "<img border='0' src='images/icon/yahoo.gif' width='60' height='20' alt='$yahoo'>";
}
echo "</td>
<td>&nbsp;</td>
<td>";
if($gmail==""){
echo "<img border='0' src='images/icon/gmail_pass.gif' width='60' height='20'>";
}else{
echo "<img border='0' src='images/icon/gmail.gif' width='60' height='20' alt='$gmail'>";
}
echo "</td>
<td>&nbsp;</td>
<td>";
if($mynet==""){
echo "<img border='0' src='images/icon/mynet_pass.gif' width='60' height='20'>";
}else{
echo "<img border='0' src='images/icon/mynet.gif' width='60' height='20' alt='$mynet'>";
}
echo "</td>
<td>&nbsp;</td>
<td>";
if($icq==""){
echo "<img border='0' src='images/icon/icq_pass.gif' width='60' height='20'>";
}else{
echo "<img border='0' src='images/icon/icq.gif' width='60' height='20' alt='$icq'>";
}
echo "</td>
</tr>
</table>
<!--mail iconlar-->

</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width='2%'>&nbsp;</td>
</tr>
<tr>
<td width='2%' height='5'></td>
<td width='96%' height='5'></td>
<td width='2%' height='5'></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>";
#--Tema Yolu Ayarları-----------------------------------------------------------------------------------------------------------------
@$tema = mysql_query("select * from tema where aktif=1");
@$goster = mysql_fetch_array($tema);
@$renk = $goster['tema'];
#--Tema Yolu Ayarları-----------------------------------------------------------------------------------------------------------------<tr>
echo "<td background='tema/$renk/1.gif' height='1'></td>
</tr>
</table><br>";

} //while


#--sayfalama ve sayaç--------------------------------------------------------------------
echo "<table border='0' width='100%' id='table3' cellpadding='0' style='border-collapse: collapse'><tr><td><table border='1' width='100%' id='table4' bordercolorlight='#E9E9E9' cellspacing='0' cellpadding='0' style='border-collapse: collapse' bordercolordark='#E9E9E9'> <tr><td><table border='0' width='100%' id='table7' cellpadding='0' style='border-collapse: collapse'><tr><td width='2%' height='5'></td><td width='96%' height='5'></td><td width='2%' height='5'></td></tr><tr><td width='2%'>&nbsp;</td><td width='96%'><table border='0' width='100%' id='table8' cellpadding='0' style='border-collapse: collapse'><tr><td><table border='1' width='100%' id='table13' bordercolorlight='#F3F3F3' cellspacing='0' cellpadding='0' bordercolordark='#F3F3F3' style='border-collapse: collapse'> <tr><td><table border='1' width='100%' id='table14' bordercolorlight='#F3F3F3' cellspacing='0' cellpadding='0' style='border-collapse: collapse' bordercolordark='#F3F3F3'> <tr><td><table border='0' width='100%' id='table15' cellpadding='0' style='border-collapse: collapse'><tr><td height='20' bgcolor='#F9F9F9' colspan='3' align='center'>";

$birGeri=$sayfa-1;
if($sayfa==1){
echo ("[««][«]");
}else{
echo ("<a href='$page&p=1'><span style='text-decoration: none'>[««]</span></a><a href=\"$page&p=$birGeri\"><span style='text-decoration: none'>[«]</span></a>");
}
echo "&nbsp;";
for($i; $i<=$sinir; $i++){
if ($sayfa==$i){
echo("<a href=\"$page&p=$i\"><font color='#FF0000'><span style='text-decoration: none'>$i.</span></font></a>");
}else{
echo("<a href=\"$page&p=$i\"><span style='text-decoration: none'>$i.</span></a>");
}
}
echo "&nbsp;";
$birIleri=$sayfa+1;
if($birIleri==$sinir+1){
echo ("[»][»»]&nbsp;[Toplam: $kac_tane » <font color='#FF0000'>$sayfa.</font> Sayfa]");
}else{
echo ("<a href=\"$page&p=$birIleri\"><span style='text-decoration: none'>[»]</span></a><a href=\"$page&p=$kac_tane\"><span style='text-decoration: none'>[»»]</span></a>&nbsp;&nbsp;[Toplam: $kac_tane » <font color='#FF0000'>$sayfa.</font> Sayfa]");
}
ob_end_flush();

echo "</td></tr><tr><td height='5' width='4%'></td><td height='5' width='1%'></td><td height='5'></td></tr><tr><td width='100%' height='20' bgcolor='#F9F9F9' colspan='3' align='center'>Dün : ";

$baslat =date("Y"."-"."m"."-"."d");
$year =substr($baslat, 0,4);
$month =substr($baslat, 5, 2);
$day =substr($baslat, 8, 2);
$bitis =date("Y-m-d", mktime(0, 0, 0, $month, $day-1, $year));
echo "<font size='1'>";
$sorgula = mysql_query("select tarih from ziyaret where tarih='$bitis'");
$dunku = mysql_num_rows($sorgula);
echo $dunku;

echo "&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Bugün : ";

$bugun = date("Y-m-d");
$sorgu = mysql_query("select tarih from ziyaret where tarih='$bugun'");
$bugunku = mysql_num_rows($sorgu);
echo $bugunku;

echo "&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Online Ziyaretçi : ";

$ip = $_SERVER['REMOTE_ADDR'];
$past = time()-150;
mysql_query("DELETE FROM online WHERE time < $past");
$result = mysql_query("SELECT time FROM online WHERE ip='$ip'");
$time = time();
if($row = mysql_fetch_array($result)){
mysql_query("UPDATE online SET time='$time', ip='$ip' WHERE ip='$ip'");
}else{
mysql_query("INSERT INTO online (ip,time) VALUES ('$ip','$time')") or die(mysql_error());
}
$result = mysql_query("SELECT ip FROM online");
$onlinekac = mysql_num_rows($result);
echo $onlinekac;

echo "&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Toplam Ziyaretçi : ";

$ipsi = $_SERVER['REMOTE_ADDR'];
$tarih = date("Y-m-d");

$ipkontrol = mysql_query("select * from ziyaret where ip='$ipsi' order by id desc");
$yaz = mysql_fetch_assoc($ipkontrol);
$vip = $yaz['ip'];
$vtarih= $yaz['tarih'];
$bak = mysql_num_rows($ipkontrol);
if($bak>0){ //if-
if($vtarih<$tarih){
$kayit_1 = mysql_query("insert into ziyaret (ip,tarih) values ('$ipsi','$tarih')");
}
}//if-
else{
$kayit_2 = mysql_query("insert into ziyaret (ip,tarih) values ('$ipsi','$tarih')");
}
$toplamne = mysql_query("select * from ziyaret");
$toplamziyaret = mysql_num_rows($toplamne);
echo $toplamziyaret;

echo "&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Onay Bekleyen : ";

$onaysiz = mysql_query("select * from defter where onay=0");
$onaysizsay = mysql_num_rows($onaysiz);
echo $onaysizsay;

echo "&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Toplam Mesaj : ";

$topmesaj = mysql_query("select * from defter");
$toplammesaj = mysql_num_rows($topmesaj);
echo $toplammesaj;

echo "</font>";
echo "</td></tr></table></td></tr></table></td></tr></table></td></tr></table><tr><td width='2%' height='5'></td><td width='96%' height='5'></td><td width='2%' height='5'></td></tr></td><td width='2%'></td></tr></table></td></tr></table></td></tr></table>";
#--sayfalama ve sayaç--------------------------------------------------------------------


}else{
echo "<table border='0' width='364' id='table1' cellpadding='0' style='border-collapse: collapse'><tr><td align='center' height='20'></td></tr><tr><td align='center' height='56'><img border='0' src='images/icon/bildiri.gif' width='50' height='56'></td></tr><tr><td align='center' height='40'>Defterde Hiç Kayıtlı Mesaj Yok!</td></tr><tr><td align='center' height='20'></td></tr></table>";
}
?>