<?php
require_once("baglan.php");

//$_SESSION['login_pass'] = $login_pass;
//$_SESSION['login_user'] = $login_user;
session_register("login_pass");
session_register("login_user");


$tablo_login = "SELECT * FROM login WHERE user = '$login_user' AND pass = '$login_pass' AND tur = '1'";
$sorgu_login = mysql_query($tablo_login);
$pass = @mysql_result($sorgu_login, 0, "pass");


if(mysql_num_rows($sorgu_login) </s>

-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Anamakine: localhost
-- Üretim Zamanı: 03 Şubat 2008 saat 17:05:43
-- Sunucu sürümü: 4.1.22
-- PHP Sürümü: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Veritabanı: `xxxxxxxxxx`
--

-- --------------------------------------------------------

--
-- Tablo yapısı: `ayarlar`
--

CREATE TABLE `ayarlar` (
  `id` int(3) NOT NULL auto_increment,
  `copy` text NOT NULL,
  `title` text NOT NULL,
  `description` text NOT NULL,
  `keywords` text NOT NULL,
  `tarih` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Tablo döküm verisi `ayarlar`
--

INSERT INTO `ayarlar` VALUES(1, 'Optimizasyon IE 5+ ve FF1+[ 1024 x 768 ] & Macromedia Flash\r\nTüm içerikler deneme yayýný için eklenmiþtir.                                                                     ', 'Siverek', 'Haberi Uzmanýndan Takip Edin.', 'haber, haberler', '2008-01-01');

-- --------------------------------------------------------

--
-- Tablo yapısı: `haberler`
--

CREATE TABLE `haberler` (
  `id` int(5) NOT NULL auto_increment,
  `kategori` int(2) NOT NULL default '0',
  `baslik` varchar(200) NOT NULL default '',
  `giris` varchar(255) NOT NULL default '',
  `icerik` longtext NOT NULL,
  `kaynak` varchar(100) default NULL,
  `resim` varchar(100) NOT NULL default '',
  `video` enum('0','1') NOT NULL default '0',
  `tarih` date NOT NULL default '0000-00-00',
  `saat` time NOT NULL default '00:00:00',
  `gizle` int(1) NOT NULL default '0',
  `izlenme` int(5) NOT NULL default '0',
  `yorum` int(5) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `haberler`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `haber_kat`
--

CREATE TABLE `haber_kat` (
  `id` int(2) NOT NULL auto_increment,
  `kategori` varchar(100) NOT NULL default '',
  `sira` int(2) NOT NULL default '0',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `haber_kat`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `haber_yorum`
--

CREATE TABLE `haber_yorum` (
  `id` int(5) NOT NULL auto_increment,
  `haber_id` int(5) NOT NULL default '0',
  `isim` varchar(75) NOT NULL default '',
  `email` varchar(75) NOT NULL default '',
  `baslik` varchar(100) NOT NULL default '',
  `yorum` text NOT NULL,
  `tarih` date NOT NULL default '0000-00-00',
  `saat` time NOT NULL default '00:00:00',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `haber_yorum`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `icerik`
--

CREATE TABLE `icerik` (
  `id` int(7) NOT NULL auto_increment,
  `katana` int(3) NOT NULL default '0',
  `katid` int(3) NOT NULL default '0',
  `baslik` varchar(150) NOT NULL default '',
  `yazi` longtext NOT NULL,
  `izlenme` int(6) NOT NULL default '0',
  `tarih` date NOT NULL default '0000-00-00',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `icerik`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `icerik_ana`
--

CREATE TABLE `icerik_ana` (
  `id` int(3) NOT NULL auto_increment,
  `kategori` varchar(100) NOT NULL default '',
  `sira` int(3) NOT NULL default '0',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Tablo döküm verisi `icerik_ana`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `icerik_kat`
--

CREATE TABLE `icerik_kat` (
  `id` int(3) NOT NULL auto_increment,
  `katana` int(3) NOT NULL default '0',
  `kategori` varchar(100) NOT NULL default '',
  `sira` int(3) NOT NULL default '0',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `icerik_kat`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `iletisim`
--

CREATE TABLE `iletisim` (
  `id` int(6) NOT NULL auto_increment,
  `tur` int(2) NOT NULL default '0',
  `isim` varchar(50) NOT NULL default '',
  `email` varchar(75) NOT NULL default '',
  `bilgiler` longtext NOT NULL,
  `baslik` varchar(100) NOT NULL default '',
  `mesaj` longtext NOT NULL,
  `tarih` date NOT NULL default '0000-00-00',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Tablo döküm verisi `iletisim`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `istatistikler`
--

CREATE TABLE `istatistikler` (
  `tarih` varchar(50) NOT NULL default '',
  `gun_adi` varchar(15) NOT NULL default '',
  `hafta` int(2) NOT NULL default '0',
  `gun` int(2) NOT NULL default '0',
  `ay` int(2) NOT NULL default '0',
  `yil` int(4) NOT NULL default '0',
  `ipler` text NOT NULL,
  `sayfa` int(6) NOT NULL default '0',
  `exp` int(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Tablo döküm verisi `istatistikler`
--

INSERT INTO `istatistikler` VALUES('03 Subat 2008', 'Pazar', 5, 3, 2, 2008, '85.110.173.70,85.110.173.70,88.245.222.96,88.245.222.96,88.245.222.96,88.245.222.96,88.245.222.96,88.245.222.96,88.245.222.96,88.245.222.96,88.245.222.96,88.245.222.96,88.245.222.96,85.110.173.70,85.110.173.70,85.110.173.70,85.110.173.70,85.110.173.70,85.110.173.70,85.110.173.70,85.110.173.70,85.110.173.70,85.110.173.70,85.110.173.70,85.110.173.70,85.110.173.70,85.110.173.70', 0, 0);

-- --------------------------------------------------------

--
-- Tablo yapısı: `kunye`
--

CREATE TABLE `kunye` (
  `id` int(2) NOT NULL auto_increment,
  `icerik` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Tablo döküm verisi `kunye`
--

INSERT INTO `kunye` VALUES(6, '<div><img src="http://www.melkam.net/images_up/melkamkunye.gif" alt="" alignment="" border="" hspace="" vspace=""></div><br>');
INSERT INTO `kunye` VALUES(7, '<DIV>&nbsp;</DIV><BR>');
INSERT INTO `kunye` VALUES(8, '<DIV>&nbsp;</DIV><BR>');
INSERT INTO `kunye` VALUES(9, '<DIV>&nbsp;</DIV><BR>deneme');
INSERT INTO `kunye` VALUES(10, '<DIV><img alt="" src="http://www.uzmanhaber.com/images_up/melkamkunye.gif" border=0 alignment=""></DIV>');

-- --------------------------------------------------------

--
-- Tablo yapısı: `linkler`
--

CREATE TABLE `linkler` (
  `id` int(5) NOT NULL auto_increment,
  `katid` int(2) NOT NULL default '0',
  `isim` varchar(50) NOT NULL default '',
  `web` varchar(100) NOT NULL default '',
  `anasayfa` int(2) NOT NULL default '0',
  `izlenme` int(5) NOT NULL default '0',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `linkler`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `link_kat`
--

CREATE TABLE `link_kat` (
  `id` int(2) NOT NULL auto_increment,
  `kategori` varchar(50) NOT NULL default '',
  `sira` int(2) NOT NULL default '0',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `link_kat`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `login`
--

CREATE TABLE `login` (
  `id` int(1) NOT NULL auto_increment,
  `user` char(50) NOT NULL default '',
  `pass` char(50) NOT NULL default '',
  `adsoyad` char(100) NOT NULL default '',
  `tur` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Tablo döküm verisi `login`
--

INSERT INTO `login` VALUES(1, 'Seretan', 'cfa07dfea19b188e17da7e7ff16ddd1c', 'Kamuran Sabak', 1);
INSERT INTO `login` VALUES(18, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin', 1);

-- --------------------------------------------------------

--
-- Tablo yapısı: `manset`
--

CREATE TABLE `manset` (
  `id` int(7) NOT NULL auto_increment,
  `kategori` int(5) NOT NULL default '0',
  `resim` varchar(100) NOT NULL default '',
  `tarih` date NOT NULL default '0000-00-00',
  `gizle` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Tablo döküm verisi `manset`
--

INSERT INTO `manset` VALUES(1, 4, '1r.jpg', '2007-08-30', '0');
INSERT INTO `manset` VALUES(2, 4, '2r.jpg', '2007-08-30', '0');
INSERT INTO `manset` VALUES(3, 4, '3r.jpg', '2007-08-30', '0');
INSERT INTO `manset` VALUES(4, 4, '4r.jpg', '2007-08-30', '0');
INSERT INTO `manset` VALUES(5, 4, '5r.jpg', '2007-08-30', '0');
INSERT INTO `manset` VALUES(6, 4, '6r.jpg', '2007-08-30', '0');
INSERT INTO `manset` VALUES(7, 4, '7r.bmp', '0000-00-00', '0');
INSERT INTO `manset` VALUES(8, 4, '8r.jpg', '0000-00-00', '0');
INSERT INTO `manset` VALUES(9, 4, '9r.jpg', '0000-00-00', '0');
INSERT INTO `manset` VALUES(10, 4, '10r.jpg', '0000-00-00', '0');

-- --------------------------------------------------------

--
-- Tablo yapısı: `manset_alt`
--

CREATE TABLE `manset_alt` (
  `id` int(5) NOT NULL auto_increment,
  `haber1` int(7) NOT NULL default '0',
  `haber2` int(7) NOT NULL default '0',
  `haber3` int(7) NOT NULL default '0',
  `haber4` int(7) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

--
-- Tablo döküm verisi `manset_alt`
--

INSERT INTO `manset_alt` VALUES(1, 70, 30, 11, 56);
INSERT INTO `manset_alt` VALUES(2, 73, 62, 59, 27);
INSERT INTO `manset_alt` VALUES(3, 74, 75, 75, 75);
INSERT INTO `manset_alt` VALUES(4, 72, 75, 75, 75);
INSERT INTO `manset_alt` VALUES(5, 66, 75, 75, 75);
INSERT INTO `manset_alt` VALUES(6, 66, 75, 75, 75);
INSERT INTO `manset_alt` VALUES(7, 75, 59, 75, 75);
INSERT INTO `manset_alt` VALUES(8, 75, 59, 75, 75);
INSERT INTO `manset_alt` VALUES(9, 59, 74, 68, 58);
INSERT INTO `manset_alt` VALUES(10, 75, 74, 73, 72);
INSERT INTO `manset_alt` VALUES(11, 99, 96, 101, 97);
INSERT INTO `manset_alt` VALUES(12, 89, 18, 68, 69);
INSERT INTO `manset_alt` VALUES(13, 101, 67, 101, 101);
INSERT INTO `manset_alt` VALUES(14, 54, 10, 22, 26);
INSERT INTO `manset_alt` VALUES(15, 90, 101, 101, 101);
INSERT INTO `manset_alt` VALUES(16, 94, 70, 74, 93);
INSERT INTO `manset_alt` VALUES(17, 93, 74, 67, 57);

-- --------------------------------------------------------

--
-- Tablo yapısı: `Online`
--

CREATE TABLE `Online` (
  `timestamp` int(15) NOT NULL default '0',
  `ip` varchar(40) NOT NULL default '',
  `FILE` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`timestamp`),
  KEY `ip` (`ip`),
  KEY `FILE` (`FILE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Tablo döküm verisi `Online`
--

INSERT INTO `Online` VALUES(1183563553, '66.249.65.106', '/haber_detay.php');
INSERT INTO `Online` VALUES(1183563541, '66.249.65.106', '/kunye.php');

-- --------------------------------------------------------

--
-- Tablo yapısı: `reklam`
--

CREATE TABLE `reklam` (
  `id` int(5) NOT NULL auto_increment,
  `katno` int(2) NOT NULL default '0',
  `isim` varchar(150) NOT NULL default '',
  `web` varchar(100) NOT NULL default '',
  `resim` varchar(100) NOT NULL default '',
  `flash` varchar(100) NOT NULL default '',
  `kod` text NOT NULL,
  `tarih` date NOT NULL default '0000-00-00',
  `izlenme` int(5) NOT NULL default '0',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;

--
-- Tablo döküm verisi `reklam`
--

INSERT INTO `reklam` VALUES(32, 8, 'hhh', 'www.mynet.com', '', '', '', '2008-01-01', 0, 0);

-- --------------------------------------------------------

--
-- Tablo yapısı: `reklam_poz`
--

CREATE TABLE `reklam_poz` (
  `id` int(2) NOT NULL auto_increment,
  `pozisyon` varchar(100) NOT NULL default '',
  `tur` enum('text','banner') NOT NULL default 'text',
  `gizle` enum('1','0') NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Tablo döküm verisi `reklam_poz`
--

INSERT INTO `reklam_poz` VALUES(1, 'Ust', 'text', '0');
INSERT INTO `reklam_poz` VALUES(2, 'Sol Ust', 'text', '0');
INSERT INTO `reklam_poz` VALUES(3, 'Sol Alt', 'text', '0');
INSERT INTO `reklam_poz` VALUES(4, 'Orta Ust', 'text', '0');
INSERT INTO `reklam_poz` VALUES(5, 'Orta Alt', 'text', '0');
INSERT INTO `reklam_poz` VALUES(6, 'Sag Ust', 'text', '0');
INSERT INTO `reklam_poz` VALUES(7, 'Sag Alt', 'text', '0');
INSERT INTO `reklam_poz` VALUES(8, 'Alt', 'text', '0');

-- --------------------------------------------------------

--
-- Tablo yapısı: `resimler`
--

CREATE TABLE `resimler` (
  `id` int(5) NOT NULL auto_increment,
  `katid` int(3) NOT NULL default '0',
  `resim` varchar(75) NOT NULL default '',
  `ekleyen` varchar(50) NOT NULL default '',
  `baslik` varchar(100) NOT NULL default '',
  `sira` int(5) NOT NULL default '0',
  `tarih` date NOT NULL default '0000-00-00',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `resimler`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `resim_kat`
--

CREATE TABLE `resim_kat` (
  `id` int(3) NOT NULL auto_increment,
  `kategori` varchar(100) NOT NULL default '',
  `resim` varchar(75) NOT NULL default '',
  `sira` int(3) NOT NULL default '0',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `resim_kat`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `video`
--

CREATE TABLE `video` (
  `id` int(10) NOT NULL auto_increment,
  `katid` int(3) NOT NULL default '0',
  `embed` text NOT NULL,
  `video_adi` varchar(150) NOT NULL default '',
  `resim` varchar(100) NOT NULL default '',
  `aciklama` text NOT NULL,
  `etiketler` varchar(200) NOT NULL default '',
  `tarih` date NOT NULL default '0000-00-00',
  `izlenme` int(8) NOT NULL default '0',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `video`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `video_kat`
--

CREATE TABLE `video_kat` (
  `id` int(3) NOT NULL auto_increment,
  `kategori` varchar(100) NOT NULL default '',
  `sira` int(3) NOT NULL default '0',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `video_kat`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `video_yorum`
--

CREATE TABLE `video_yorum` (
  `id` int(5) NOT NULL auto_increment,
  `video_id` int(5) NOT NULL default '0',
  `isim` varchar(75) NOT NULL default '',
  `email` varchar(75) NOT NULL default '',
  `baslik` varchar(100) NOT NULL default '',
  `yorum` text NOT NULL,
  `tarih` date NOT NULL default '0000-00-00',
  `saat` time NOT NULL default '00:00:00',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `video_yorum`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `yazarlar`
--

CREATE TABLE `yazarlar` (
  `id` int(3) NOT NULL auto_increment,
  `yazar` int(3) NOT NULL default '0',
  `baslik` varchar(200) NOT NULL default '',
  `icerik` longtext NOT NULL,
  `tarih` date NOT NULL default '0000-00-00',
  `izlenme` int(5) NOT NULL default '0',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `yazarlar`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `yazar_kat`
--

CREATE TABLE `yazar_kat` (
  `id` int(3) NOT NULL auto_increment,
  `yazar` varchar(150) NOT NULL default '',
  `resim` varchar(100) default 'yazar_resim_yok.jpg',
  `email` varchar(100) NOT NULL default '',
  `tur` int(1) NOT NULL default '1',
  `sira` int(3) NOT NULL default '0',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `yazar_kat`
--


-- --------------------------------------------------------

--
-- Tablo yapısı: `yazar_yorum`
--

CREATE TABLE `yazar_yorum` (
  `id` int(5) NOT NULL auto_increment,
  `yazi_id` int(5) NOT NULL default '0',
  `isim` varchar(75) NOT NULL default '',
  `email` varchar(75) NOT NULL default '',
  `baslik` varchar(100) NOT NULL default '',
  `yorum` text NOT NULL,
  `tarih` date NOT NULL default '0000-00-00',
  `saat` time NOT NULL default '00:00:00',
  `gizle` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `yazar_yorum`
--