-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Anamakine: 127.0.0.1
-- Üretim Zamanı: 04 Mar 2024, 16:09:33
-- Sunucu sürümü: 5.6.17
-- PHP Sürümü: 5.5.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Veritabanı: `oziygo`
--

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

--
-- Tablo için tablo yapısı `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
  `kullaniciadi` varchar(65) COLLATE utf8_turkish_ci NOT NULL,
  `sifre` longtext COLLATE utf8_turkish_ci NOT NULL,
  `durum` longtext COLLATE utf8_turkish_ci,
  `tarih` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=2 ;

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

INSERT INTO `admin` (`id`, `adi`, `kullaniciadi`, `sifre`, `durum`, `tarih`) VALUES
(1, 'Oziy Web Design', 'admin', '21232f297a57a5a743894a0e4a801fc3', '1', '19.06.2021 13:43:25');

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

--
-- Tablo için tablo yapısı `adreslerim`
--

CREATE TABLE IF NOT EXISTS `adreslerim` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `uyeid` int(11) NOT NULL DEFAULT '0',
  `adres` longtext COLLATE utf8_turkish_ci,
  `il` longtext COLLATE utf8_turkish_ci,
  `ilce` text COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=3 ;

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

INSERT INTO `adreslerim` (`id`, `adi`, `uyeid`, `adres`, `il`, `ilce`) VALUES
(2, 'Ev Adresi', 1, 'Deneme Mah Deneme Cad No.22', 'İstanbul', 'Gülhane');

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

--
-- Tablo için tablo yapısı `anaozellik`
--

CREATE TABLE IF NOT EXISTS `anaozellik` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `urunid` varchar(65) COLLATE utf8_turkish_ci NOT NULL,
  `tip` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=6 ;

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

INSERT INTO `anaozellik` (`id`, `adi`, `urunid`, `tip`) VALUES
(3, 'Renk Seçiniz', '37', 0),
(4, 'Renk', '41', 1),
(5, 'Hafıza ', '41', 0);

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

--
-- Tablo için tablo yapısı `anaozellikalt`
--

CREATE TABLE IF NOT EXISTS `anaozellikalt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `anaid` int(11) NOT NULL,
  `stok` int(11) unsigned DEFAULT NULL,
  `fiyat` decimal(10,2) DEFAULT NULL,
  `ustadi` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=16 ;

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

INSERT INTO `anaozellikalt` (`id`, `adi`, `anaid`, `stok`, `fiyat`, `ustadi`) VALUES
(2, '200x300', 1, 100, '200.00', 'Ebat'),
(3, '300x400', 1, 98, '300.00', 'Ebat'),
(4, '400x500', 1, 100, '400.00', 'Ebat'),
(5, 'Deri', 2, 98, '0.00', 'Kumaş Türü'),
(6, 'Suni Deri', 2, 100, '0.00', 'Kumaş Türü'),
(7, 'Mavi', 3, 200, '0.00', 'Renk Seçiniz'),
(8, 'Beyaz', 3, 100, '0.00', 'Renk Seçiniz'),
(9, 'Açık Mavi', 3, 0, '0.00', 'Renk Seçiniz'),
(10, 'Siyah', 3, 200, '0.00', 'Renk Seçiniz'),
(11, 'Siyah', 4, 0, '0.00', 'Renk'),
(12, 'Gold', 4, 1110, '0.00', 'Renk'),
(13, 'Rose', 4, 111111, '0.00', 'Renk'),
(14, '6 GB', 5, 1, '0.00', 'Hafıza '),
(15, '12 GB', 5, 0, '0.00', 'Hafıza ');

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

--
-- Tablo için tablo yapısı `bankahesaplari`
--

CREATE TABLE IF NOT EXISTS `bankahesaplari` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bankaadi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `alici` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim` longtext COLLATE utf8_turkish_ci,
  `sube` longtext COLLATE utf8_turkish_ci,
  `kod` longtext COLLATE utf8_turkish_ci,
  `hesap` longtext COLLATE utf8_turkish_ci,
  `durum` longtext COLLATE utf8_turkish_ci NOT NULL,
  `iban` longtext COLLATE utf8_turkish_ci,
  `sira` int(11) DEFAULT NULL,
  `tarih` text COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=8 ;

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

INSERT INTO `bankahesaplari` (`id`, `bankaadi`, `alici`, `resim`, `sube`, `kod`, `hesap`, `durum`, `iban`, `sira`, `tarih`) VALUES
(6, 'Türkiye Cumhuriyeti Ziraat Bankası', 'Mehmet ÖZKAN', '3917ac519b3e0fba1ec1d9d11870e4ecG.jpg', 'KAYSERİ', '23123', '3212312', '1', 'TR 234324 234234 342 23 223', 1, '05-03-2020 11:45:14'),
(7, 'Finansbank', 'Mehmet Özkan BOYBEYİ', 'aa1a9a70fda1af9c302317ce544c953e1.png', 'Beşiktaş', '32112', '44444', '1', 'TR 32342343224323423423', 2, '04.06.2021 19:22:54');

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

--
-- Tablo için tablo yapısı `ebulten`
--

CREATE TABLE IF NOT EXISTS `ebulten` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` longtext COLLATE utf8_turkish_ci NOT NULL,
  `eposta` longtext COLLATE utf8_turkish_ci NOT NULL,
  `tarih` text COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=24 ;

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

INSERT INTO `ebulten` (`id`, `ip`, `eposta`, `tarih`) VALUES
(1, '127.0.0.1', 'oziyweb@hotmail.com', '19.06.2021 19:50:48'),
(2, '185.220.101.78', 'dedklokkk@ffo.kr', '12.07.2022 05:43:09'),
(3, '159.146.14.107', 'efdalkulaoglu@gmail.com', '22.07.2022 16:52:51'),
(4, '89.58.27.84', 'puschnoishura@andreicutie.com', '06.08.2022 16:22:59'),
(5, '159.146.45.26', 'efdalkulaoglu@gmail.com', '15.08.2022 15:04:36'),
(6, '78.135.92.34', 'demo@demo.com', '18.08.2022 13:37:42'),
(7, '127.0.0.1', 'de@de.com', '17.01.2024 14:06:52'),
(8, '127.0.0.1', 'de@de.com', '17.01.2024 14:11:51'),
(9, '127.0.0.1', 'de@de.com', '17.01.2024 14:12:34'),
(10, '127.0.0.1', 'de@de.com', '17.01.2024 14:13:49'),
(11, '127.0.0.1', 'de@de.com', '17.01.2024 14:19:39'),
(12, '127.0.0.1', 'de@de.com', '17.01.2024 14:26:39'),
(13, '127.0.0.1', 'de@de.com', '17.01.2024 14:28:28'),
(14, '127.0.0.1', 'de@de.com', '20.01.2024 14:26:34'),
(15, '127.0.0.1', 'de@de.com', '20.01.2024 14:27:11'),
(16, '127.0.0.1', 'de@de.com', '20.01.2024 14:45:30'),
(17, '127.0.0.1', 'de@de.com', '20.01.2024 14:46:18'),
(18, '127.0.0.1', 'de@de.com', '29.02.2024 16:24:22'),
(19, '127.0.0.1', 'de@de.com', '29.02.2024 20:35:04'),
(20, '127.0.0.1', 'de@de.com', '29.02.2024 20:35:12'),
(21, '127.0.0.1', 'de@de.com', '29.02.2024 20:35:49'),
(22, '127.0.0.1', 'de@de.com', '29.02.2024 20:36:53'),
(23, '127.0.0.1', 'de@de.com', '03.03.2024 22:03:03');

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

--
-- Tablo için tablo yapısı `etiketler`
--

CREATE TABLE IF NOT EXISTS `etiketler` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `link` longtext COLLATE utf8_turkish_ci,
  `durum` longtext COLLATE utf8_turkish_ci NOT NULL,
  `sira` int(11) DEFAULT NULL,
  `tarih` text COLLATE utf8_turkish_ci,
  `resim` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=8 ;

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

INSERT INTO `etiketler` (`id`, `adi`, `link`, `durum`, `sira`, `tarih`, `resim`) VALUES
(4, 'Türkçe', 'tr', '1', 1, '24.04.2021 02:10:32', '5b2c3ed3cd7de4a819516ba948095625h.png'),
(5, 'İngilizce', 'en', '1', 2, '28.04.2021 21:56:18', '3788272e11e16f1aa39377b60a7378afh.png'),
(6, 'Almanca', 'de', '1', 3, '24.02.2024 16:28:41', '1a19848a6f47eb5671411b58758e619cn.png'),
(7, 'Arapça', 'ar', '1', 4, '24.02.2024 16:28:59', '6d6b00026a6a8409e744889809d86995c.png');

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

--
-- Tablo için tablo yapısı `favoriler`
--

CREATE TABLE IF NOT EXISTS `favoriler` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `urunid` int(11) NOT NULL,
  `tarih` text COLLATE utf8_turkish_ci,
  `kim` longtext COLLATE utf8_turkish_ci,
  `gelenkim` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=3 ;

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

INSERT INTO `favoriler` (`id`, `urunid`, `tarih`, `kim`, `gelenkim`) VALUES
(2, 41, '04.03.2024 11:18:02', NULL, '1');

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

--
-- Tablo için tablo yapısı `filtre`
--

CREATE TABLE IF NOT EXISTS `filtre` (
  `sira` int(11) NOT NULL DEFAULT '0',
  `fid` int(11) NOT NULL AUTO_INCREMENT,
  `fadi` longtext CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL,
  `kategori` longtext NOT NULL,
  `ozellik` longtext CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL,
  PRIMARY KEY (`fid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

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

INSERT INTO `filtre` (`sira`, `fid`, `fadi`, `kategori`, `ozellik`) VALUES
(1, 2, 'Türü', '1,2,3,4,5,6,', 'Ceviz,Maun,Seramik'),
(2, 3, 'Kumaş', '1,2,3,4,5,6,', 'Deri,Suni Deri,BabyFace'),
(3, 4, 'Ebad', '1,2,3,4,5,6,', '100x200,200x300,300x400,400x500,500x600'),
(0, 5, '', '', ''),
(0, 6, 'Ekran Tipi', '9', 'LCD,LED'),
(0, 7, 'Ram', '9', '8 GB,16 GB,32 GB,64 GB'),
(0, 8, 'İşletim Sistemi', '9', 'Windows 11,FreeDos');

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

--
-- Tablo için tablo yapısı `haberler`
--

CREATE TABLE IF NOT EXISTS `haberler` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `aciklama` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim` longtext COLLATE utf8_turkish_ci,
  `seo` longtext COLLATE utf8_turkish_ci,
  `hit` longtext COLLATE utf8_turkish_ci,
  `stitle` longtext COLLATE utf8_turkish_ci,
  `skey` longtext COLLATE utf8_turkish_ci,
  `sdesc` longtext COLLATE utf8_turkish_ci,
  `seodurum` longtext COLLATE utf8_turkish_ci,
  `durum` longtext COLLATE utf8_turkish_ci NOT NULL,
  `sira` int(11) DEFAULT NULL,
  `tarih` text COLLATE utf8_turkish_ci,
  `dil` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=6 ;

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

INSERT INTO `haberler` (`id`, `adi`, `aciklama`, `resim`, `seo`, `hit`, `stitle`, `skey`, `sdesc`, `seodurum`, `durum`, `sira`, `tarih`, `dil`) VALUES
(1, 'OziyGO Yepyeni Bir Eticaret', '<p>"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do \r\neiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad \r\nminim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip \r\nex ea commodo consequat. Duis aute irure dolor in reprehenderit in \r\nvoluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur \r\nsint occaecat cupidatat non proident, sunt in culpa qui officia deserunt\r\n mollit anim id est laborum."</p><h3>Section 1.10.32 of "de Finibus Bonorum et Malorum", written by Cicero in 45 BC</h3><p>"Sed\r\n ut perspiciatis unde omnis iste natus error sit voluptatem accusantium \r\ndoloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo \r\ninventore veritatis et quasi architecto beatae vitae dicta sunt \r\nexplicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut \r\nodit aut fugit, sed quia consequuntur magni dolores eos qui ratione \r\nvoluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum \r\nquia dolor sit amet, consectetur, adipisci velit, sed quia non numquam \r\neius modi tempora incidunt ut labore et dolore magnam aliquam quaerat \r\nvoluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam \r\ncorporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur?\r\n Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse \r\nquam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo \r\nvoluptas nulla pariatur?"</p>\r\n<h3>1914 translation by H. Rackham</h3>\r\n<p>"But I must explain to you how all this mistaken idea of denouncing \r\npleasure and praising pain was born and I will give you a complete \r\naccount of the system, and expound the actual teachings of the great \r\nexplorer of the truth, the master-builder of human happiness. No one \r\nrejects, dislikes, or avoids pleasure itself, because it is pleasure, \r\nbut because those who do not know how to pursue pleasure rationally \r\nencounter consequences that are extremely painful. Nor again is there \r\nanyone who loves or pursues or desires to obtain pain of itself, because\r\n it is pain, but because occasionally circumstances occur in which toil \r\nand pain can procure him some great pleasure. To take a trivial example,\r\n which of us ever undertakes laborious physical exercise, except to \r\nobtain some advantage from it? But who has any right to find fault with a\r\n man who chooses to enjoy a pleasure that has no annoying consequences, \r\nor one who avoids a pain that produces no resultant pleasure?"</p>', '505f1abc1ac89d381d985627c0d874210.png', 'oziyshop-gereksinimlerimi-karsilar-mi-1', '82', '', '', '', '', '1', 1, '18.06.2021 13:53:36', NULL),
(2, 'OziyGO Yepyeni Bir Eticaret', '<p>"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do \r\neiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad \r\nminim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip \r\nex ea commodo consequat. Duis aute irure dolor in reprehenderit in \r\nvoluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur \r\nsint occaecat cupidatat non proident, sunt in culpa qui officia deserunt\r\n mollit anim id est laborum."</p><h3>Section 1.10.32 of "de Finibus Bonorum et Malorum", written by Cicero in 45 BC</h3><p>"Sed\r\n ut perspiciatis unde omnis iste natus error sit voluptatem accusantium \r\ndoloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo \r\ninventore veritatis et quasi architecto beatae vitae dicta sunt \r\nexplicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut \r\nodit aut fugit, sed quia consequuntur magni dolores eos qui ratione \r\nvoluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum \r\nquia dolor sit amet, consectetur, adipisci velit, sed quia non numquam \r\neius modi tempora incidunt ut labore et dolore magnam aliquam quaerat \r\nvoluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam \r\ncorporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur?\r\n Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse \r\nquam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo \r\nvoluptas nulla pariatur?"</p>\r\n<h3>1914 translation by H. Rackham</h3>\r\n<p>"But I must explain to you how all this mistaken idea of denouncing \r\npleasure and praising pain was born and I will give you a complete \r\naccount of the system, and expound the actual teachings of the great \r\nexplorer of the truth, the master-builder of human happiness. No one \r\nrejects, dislikes, or avoids pleasure itself, because it is pleasure, \r\nbut because those who do not know how to pursue pleasure rationally \r\nencounter consequences that are extremely painful. Nor again is there \r\nanyone who loves or pursues or desires to obtain pain of itself, because\r\n it is pain, but because occasionally circumstances occur in which toil \r\nand pain can procure him some great pleasure. To take a trivial example,\r\n which of us ever undertakes laborious physical exercise, except to \r\nobtain some advantage from it? But who has any right to find fault with a\r\n man who chooses to enjoy a pleasure that has no annoying consequences, \r\nor one who avoids a pain that produces no resultant pleasure?"</p>', '49d75b36e6f060456eb1060e56ea4c5d0.png', 'oziyshop-gereksinimlerimi-karsilar-mi-1', '82', '', '', '', '', '1', 1, '18.06.2021 13:53:36', NULL),
(3, 'OziyGO Yepyeni Bir Eticaret', '<p>"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do \r\neiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad \r\nminim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip \r\nex ea commodo consequat. Duis aute irure dolor in reprehenderit in \r\nvoluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur \r\nsint occaecat cupidatat non proident, sunt in culpa qui officia deserunt\r\n mollit anim id est laborum."</p><h3>Section 1.10.32 of "de Finibus Bonorum et Malorum", written by Cicero in 45 BC</h3><p>"Sed\r\n ut perspiciatis unde omnis iste natus error sit voluptatem accusantium \r\ndoloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo \r\ninventore veritatis et quasi architecto beatae vitae dicta sunt \r\nexplicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut \r\nodit aut fugit, sed quia consequuntur magni dolores eos qui ratione \r\nvoluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum \r\nquia dolor sit amet, consectetur, adipisci velit, sed quia non numquam \r\neius modi tempora incidunt ut labore et dolore magnam aliquam quaerat \r\nvoluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam \r\ncorporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur?\r\n Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse \r\nquam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo \r\nvoluptas nulla pariatur?"</p>\r\n<h3>1914 translation by H. Rackham</h3>\r\n<p>"But I must explain to you how all this mistaken idea of denouncing \r\npleasure and praising pain was born and I will give you a complete \r\naccount of the system, and expound the actual teachings of the great \r\nexplorer of the truth, the master-builder of human happiness. No one \r\nrejects, dislikes, or avoids pleasure itself, because it is pleasure, \r\nbut because those who do not know how to pursue pleasure rationally \r\nencounter consequences that are extremely painful. Nor again is there \r\nanyone who loves or pursues or desires to obtain pain of itself, because\r\n it is pain, but because occasionally circumstances occur in which toil \r\nand pain can procure him some great pleasure. To take a trivial example,\r\n which of us ever undertakes laborious physical exercise, except to \r\nobtain some advantage from it? But who has any right to find fault with a\r\n man who chooses to enjoy a pleasure that has no annoying consequences, \r\nor one who avoids a pain that produces no resultant pleasure?"</p>', '6a1bd1f4a8454f3caf0bc2e8697a98460.png', 'oziyshop-gereksinimlerimi-karsilar-mi-1', '82', '', '', '', '', '1', 1, '18.06.2021 13:53:36', NULL),
(4, 'OziyGO Yepyeni Bir Eticaret', '<p>"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do \r\neiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad \r\nminim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip \r\nex ea commodo consequat. Duis aute irure dolor in reprehenderit in \r\nvoluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur \r\nsint occaecat cupidatat non proident, sunt in culpa qui officia deserunt\r\n mollit anim id est laborum."</p><h3>Section 1.10.32 of "de Finibus Bonorum et Malorum", written by Cicero in 45 BC</h3><p>"Sed\r\n ut perspiciatis unde omnis iste natus error sit voluptatem accusantium \r\ndoloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo \r\ninventore veritatis et quasi architecto beatae vitae dicta sunt \r\nexplicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut \r\nodit aut fugit, sed quia consequuntur magni dolores eos qui ratione \r\nvoluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum \r\nquia dolor sit amet, consectetur, adipisci velit, sed quia non numquam \r\neius modi tempora incidunt ut labore et dolore magnam aliquam quaerat \r\nvoluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam \r\ncorporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur?\r\n Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse \r\nquam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo \r\nvoluptas nulla pariatur?"</p>\r\n<h3>1914 translation by H. Rackham</h3>\r\n<p>"But I must explain to you how all this mistaken idea of denouncing \r\npleasure and praising pain was born and I will give you a complete \r\naccount of the system, and expound the actual teachings of the great \r\nexplorer of the truth, the master-builder of human happiness. No one \r\nrejects, dislikes, or avoids pleasure itself, because it is pleasure, \r\nbut because those who do not know how to pursue pleasure rationally \r\nencounter consequences that are extremely painful. Nor again is there \r\nanyone who loves or pursues or desires to obtain pain of itself, because\r\n it is pain, but because occasionally circumstances occur in which toil \r\nand pain can procure him some great pleasure. To take a trivial example,\r\n which of us ever undertakes laborious physical exercise, except to \r\nobtain some advantage from it? But who has any right to find fault with a\r\n man who chooses to enjoy a pleasure that has no annoying consequences, \r\nor one who avoids a pain that produces no resultant pleasure?"</p>', '7cc44e62aaa5f14b8d6e3b9353ae91aa0.png', 'oziyshop-gereksinimlerimi-karsilar-mi-1', '82', '', '', '', '', '1', 1, '18.06.2021 13:53:36', NULL),
(5, 'OziyGO Yepyeni Bir Eticaret', '<p>"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do \r\neiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad \r\nminim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip \r\nex ea commodo consequat. Duis aute irure dolor in reprehenderit in \r\nvoluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur \r\nsint occaecat cupidatat non proident, sunt in culpa qui officia deserunt\r\n mollit anim id est laborum."</p><h3>Section 1.10.32 of "de Finibus Bonorum et Malorum", written by Cicero in 45 BC</h3><p>"Sed\r\n ut perspiciatis unde omnis iste natus error sit voluptatem accusantium \r\ndoloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo \r\ninventore veritatis et quasi architecto beatae vitae dicta sunt \r\nexplicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut \r\nodit aut fugit, sed quia consequuntur magni dolores eos qui ratione \r\nvoluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum \r\nquia dolor sit amet, consectetur, adipisci velit, sed quia non numquam \r\neius modi tempora incidunt ut labore et dolore magnam aliquam quaerat \r\nvoluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam \r\ncorporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur?\r\n Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse \r\nquam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo \r\nvoluptas nulla pariatur?"</p>\r\n<h3>1914 translation by H. Rackham</h3>\r\n<p>"But I must explain to you how all this mistaken idea of denouncing \r\npleasure and praising pain was born and I will give you a complete \r\naccount of the system, and expound the actual teachings of the great \r\nexplorer of the truth, the master-builder of human happiness. No one \r\nrejects, dislikes, or avoids pleasure itself, because it is pleasure, \r\nbut because those who do not know how to pursue pleasure rationally \r\nencounter consequences that are extremely painful. Nor again is there \r\nanyone who loves or pursues or desires to obtain pain of itself, because\r\n it is pain, but because occasionally circumstances occur in which toil \r\nand pain can procure him some great pleasure. To take a trivial example,\r\n which of us ever undertakes laborious physical exercise, except to \r\nobtain some advantage from it? But who has any right to find fault with a\r\n man who chooses to enjoy a pleasure that has no annoying consequences, \r\nor one who avoids a pain that produces no resultant pleasure?"</p>', '66fa4e9d96151c661f0a5f05d7b1f9cf0.png', 'oziyshop-gereksinimlerimi-karsilar-mi-1', '82', '', '', '', '', '1', 1, '18.06.2021 13:53:36', NULL);

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

--
-- Tablo için tablo yapısı `iletisim`
--

CREATE TABLE IF NOT EXISTS `iletisim` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `isim` longtext COLLATE utf8_turkish_ci NOT NULL,
  `eposta` longtext COLLATE utf8_turkish_ci NOT NULL,
  `konu` longtext COLLATE utf8_turkish_ci,
  `mesaj` longtext COLLATE utf8_turkish_ci,
  `tarih` text COLLATE utf8_turkish_ci,
  `ip` longtext COLLATE utf8_turkish_ci,
  `telefon` longtext COLLATE utf8_turkish_ci,
  `durum` int(11) DEFAULT NULL,
  `ckonu` longtext COLLATE utf8_turkish_ci,
  `cevap` longtext COLLATE utf8_turkish_ci,
  `giden` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=2 ;

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

INSERT INTO `iletisim` (`id`, `isim`, `eposta`, `konu`, `mesaj`, `tarih`, `ip`, `telefon`, `durum`, `ckonu`, `cevap`, `giden`) VALUES
(1, 'mehmet özkan boybeyi', 'info@oziyweb.com', 'Yazılım', 'Merhaba çok beğendim yazılımın paket ve özellikleri hakkında detaylı bir dönüş alabilirmiyim acaba . ', '20.06.2021 15:17:11', '127.0.0.1', '05424922500', 1, NULL, NULL, NULL);

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

--
-- Tablo için tablo yapısı `kampanyalar`
--

CREATE TABLE IF NOT EXISTS `kampanyalar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `aciklama` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim` longtext COLLATE utf8_turkish_ci,
  `seo` longtext COLLATE utf8_turkish_ci,
  `hit` longtext COLLATE utf8_turkish_ci,
  `stitle` longtext COLLATE utf8_turkish_ci,
  `skey` longtext COLLATE utf8_turkish_ci,
  `sdesc` longtext COLLATE utf8_turkish_ci,
  `seodurum` longtext COLLATE utf8_turkish_ci,
  `durum` longtext COLLATE utf8_turkish_ci NOT NULL,
  `sira` int(11) DEFAULT NULL,
  `tarih` text COLLATE utf8_turkish_ci,
  `link` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=9 ;

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

INSERT INTO `kampanyalar` (`id`, `adi`, `aciklama`, `resim`, `seo`, `hit`, `stitle`, `skey`, `sdesc`, `seodurum`, `durum`, `sira`, `tarih`, `link`) VALUES
(3, 'SEÇ AL 10 TL', '', '31ce4576f2e607192d958a400374e1da3.png', 'sec-al-10-tl-3', '46', '', '', '', '', '1', 0, '18.06.2021 14:49:40', '0'),
(4, 'KARGO BEDAVA', '', 'a3e5641573ae2afc8a1debe8bc2b87e32.png', 'kargo-bedava-4', '45', '', '', '', '', '1', 0, '18.06.2021 14:50:35', '0'),
(5, 'YENİ SEZON', '', '585c7f91e766058c154c77fd8587c0911.png', 'yeni-sezon-5', '29', '', '', '', '', '1', 0, '18.06.2021 14:51:53', '0'),
(6, 'KAMPANYALI ÜRÜNLER', '', '9059d1f05ded8743b39859f5ee00e7623.png', 'kampanyali-urunler-6', '3', '', '', '', '', '1', 0, '18.06.2021 14:56:44', 'www.google.com'),
(7, 'BABALAR GÜNÜNE ÖZEL', '', '30fc54e6902b77e824573e8cb72c31f82.png', 'babalar-gunune-ozel-7', '24', '', '', '', '', '1', 0, '18.06.2021 15:22:00', '0'),
(8, 'ANNELER İÇİN', '<p>testt<br></p>', '83038cddbcb0164b35b590e8bfaa169c1.png', 'anneler-icin-8', '27', '', '', '', '', '1', 0, '18.06.2021 15:22:17', '0');

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

--
-- Tablo için tablo yapısı `kargolar`
--

CREATE TABLE IF NOT EXISTS `kargolar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim` longtext COLLATE utf8_turkish_ci,
  `seo` longtext COLLATE utf8_turkish_ci,
  `link` longtext COLLATE utf8_turkish_ci,
  `durum` longtext COLLATE utf8_turkish_ci NOT NULL,
  `sira` int(11) DEFAULT NULL,
  `tarih` text COLLATE utf8_turkish_ci,
  `dil` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=5 ;

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

INSERT INTO `kargolar` (`id`, `adi`, `resim`, `seo`, `link`, `durum`, `sira`, `tarih`, `dil`) VALUES
(4, 'Aras Kargo', 'e070c69df7a51f4764c384e4263c20931.png', 'aras-kargo', 'https://www.yurticikargo.com/tr/online-servisler/gonderi-sorgula?code=', '1', NULL, '24.04.2021 02:10:32', NULL);

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

--
-- Tablo için tablo yapısı `karsilastir`
--

CREATE TABLE IF NOT EXISTS `karsilastir` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `urunid` longtext COLLATE utf8_turkish_ci NOT NULL,
  `tarih` text COLLATE utf8_turkish_ci,
  `dil` longtext COLLATE utf8_turkish_ci,
  `kim` longtext COLLATE utf8_turkish_ci,
  `gelenkim` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=3 ;

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

INSERT INTO `karsilastir` (`id`, `urunid`, `tarih`, `dil`, `kim`, `gelenkim`) VALUES
(1, '32', '04.03.2024 11:23:43', NULL, '127.0.0.1', '1'),
(2, '35', '04.03.2024 11:32:16', NULL, '127.0.0.1', '1');

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

--
-- Tablo için tablo yapısı `kategoriler`
--

CREATE TABLE IF NOT EXISTS `kategoriler` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `aciklama` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim` longtext COLLATE utf8_turkish_ci,
  `seo` longtext COLLATE utf8_turkish_ci,
  `hit` longtext COLLATE utf8_turkish_ci,
  `skey` longtext COLLATE utf8_turkish_ci,
  `sdesc` longtext COLLATE utf8_turkish_ci,
  `seodurum` longtext COLLATE utf8_turkish_ci,
  `durum` longtext COLLATE utf8_turkish_ci NOT NULL,
  `ustkat` int(11) DEFAULT '0',
  `sira` int(11) DEFAULT NULL,
  `dil` longtext COLLATE utf8_turkish_ci,
  `stitle` longtext COLLATE utf8_turkish_ci,
  `ac` int(11) DEFAULT NULL,
  `level` longtext COLLATE utf8_turkish_ci,
  `ustgoster` int(11) DEFAULT NULL,
  `yanresim` longtext COLLATE utf8_turkish_ci,
  `ikon` longtext COLLATE utf8_turkish_ci,
  `nikon` longtext COLLATE utf8_turkish_ci,
  `agoster` int(11) DEFAULT NULL,
  `ikongoster` longtext COLLATE utf8_turkish_ci,
  `renk` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=17 ;

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

INSERT INTO `kategoriler` (`id`, `adi`, `aciklama`, `resim`, `seo`, `hit`, `skey`, `sdesc`, `seodurum`, `durum`, `ustkat`, `sira`, `dil`, `stitle`, `ac`, `level`, `ustgoster`, `yanresim`, `ikon`, `nikon`, `agoster`, `ikongoster`, `renk`) VALUES
(9, 'Bilgisayarlar', '0', 'resimyok.jpg', 'bilgisayarlar-9', '125', '', '', '', '1', 0, 0, NULL, '', 0, '0', 1, NULL, NULL, '4a24c6ec9fb1785cf8663657953978181.png', 0, '1', '#000000'),
(10, 'Televizyonlar', '0', 'resimyok.jpg', 'televizyonlar-10', '0', '', '', '', '1', 0, 0, NULL, '', 0, '0', 1, NULL, NULL, 'c64becbc99852fd442293b57d77b462d7.png', 0, '1', '#000000'),
(11, 'Telefonlar', '0', 'resimyok.jpg', 'telefonlar-11', '0', '', '', '', '1', 0, 0, NULL, '', 0, '0', 1, NULL, NULL, 'e9d77257711827d26fe7421de6807c8d3.png', 1, '1', '#000000'),
(12, 'Tabletler', '0', 'resimyok.jpg', 'tabletler-12', '0', '', '', '', '1', 0, 0, NULL, '', 0, '0', 1, NULL, NULL, '2f0e6c1721c5a38e95acb9d9aceebfa44.png', 1, '1', '#000000'),
(13, 'Joystickler', '0', 'resimyok.jpg', 'joystickler-13', '1', '', '', '', '1', 0, 0, NULL, '', 0, '0', 1, NULL, NULL, 'a1779274d334adc5aacbc4e739471b0b5.png', 0, '1', '#000000'),
(14, 'Fotoğraf Makineleri', '0', 'resimyok.jpg', 'fotograf-makineleri-14', '0', '', '', '', '1', 0, 0, NULL, '', 0, '0', 1, NULL, NULL, 'ceb44be7e6193c2b199de916b332cee76.png', 0, '1', '#000000'),
(15, 'Harddiskler', '0', 'resimyok.jpg', 'harddiskler-15', '0', '', '', '', '1', 0, 0, NULL, '', 0, '0', 0, NULL, NULL, 'c82e1706b8352ea9d0f3d7b290c281f77.png', 0, '1', '#000000'),
(16, 'Beyaz Eşya', '0', 'resimyok.jpg', 'beyaz-esya-16', '0', '', '', '', '1', 0, 0, NULL, '', 0, '0', 0, NULL, NULL, '36ec0ff2263ab5435348acd02f9d90438.png', 0, '1', '#000000');

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

--
-- Tablo için tablo yapısı `kuponlar`
--

CREATE TABLE IF NOT EXISTS `kuponlar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `tip` int(11) NOT NULL,
  `oran` int(11) NOT NULL,
  `stok` int(10) unsigned NOT NULL,
  `slimit` decimal(10,2) NOT NULL DEFAULT '0.00',
  `sekil` int(11) NOT NULL DEFAULT '0',
  `durum` longtext COLLATE utf8_turkish_ci,
  `epostalar` longtext COLLATE utf8_turkish_ci NOT NULL,
  `mesaj` longtext COLLATE utf8_turkish_ci NOT NULL,
  `gelenkim` longtext COLLATE utf8_turkish_ci NOT NULL,
  `tarih` longtext COLLATE utf8_turkish_ci,
  `gtarih` longtext COLLATE utf8_turkish_ci NOT NULL,
  `kullanildi` longtext COLLATE utf8_turkish_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=5 ;

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

INSERT INTO `kuponlar` (`id`, `adi`, `tip`, `oran`, `stok`, `slimit`, `sekil`, `durum`, `epostalar`, `mesaj`, `gelenkim`, `tarih`, `gtarih`, `kullanildi`) VALUES
(2, 'TEST123', 0, 10, 96, '300.00', 0, '1', '', '', '', '30.05.2021', '', '0'),
(3, 'HEDİYEMOLSUN', 1, 10, 10, '20.00', 1, '1', 'oziyweb@hotmail.com', '								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 								 ', '', '02.06.2021', '2021-06-19', '0'),
(4, 'HEDİYEÇEKİM123', 0, 100, 9, '100.00', 1, '1', 'oziyweb@hotmail.com', '								 								 								 								 								 									 \r\n        <table class=" main contenttable" style="font-weight: normal;border-collapse: collapse;border: 0;margin-left: auto;margin-right: auto;padding: 0;font-family: Arial, sans-serif;color: #555559;background-color: white;font-size: 16px;line-height: 26px;width: 600px;" align="center">\r\n		<tbody><tr>\r\n			<td class="border" style="border-collapse: collapse;border: 1px solid #eeeff0;margin: 0;padding: 0;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;">\r\n				<table style="height: 800px !important;font-weight: normal;border-collapse: collapse;border: 0;margin: 0;padding: 0;font-family: Arial, sans-serif;">\r\n					<tbody><tr>\r\n						<td colspan="4" class="image-section" style="border-collapse: collapse;border: 0;margin: 0;padding: 0;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;background-color: #fff;border-bottom: 4px solid #00a5b5" valign="top">\r\n							<a href="http://localhost"><img style="height: 70px;line-height: 1;width: 200px;margin: 10px;" class="top-image" src="http://localhost/resimler/siteayarlari/1619309636o.png" alt="OziySHOP ECommerce Software"></a>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td class="side title" style="border-collapse: collapse;border: 0;margin: 0;padding: 20px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;vertical-align: top;background-color: white;border-top: none;" valign="top">\r\n							<table style="font-weight: normal;border-collapse: collapse;border: 0;margin: 0;padding: 0;font-family: Arial, sans-serif;">\r\n								\r\n							\r\n								<tbody><tr>\r\n									<td class="grey-block" style="border-collapse: collapse;border: 0;margin: 0;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;background-color: #fff; text-align:center;">\r\n									<div class="mktEditable" id="cta">\r\n									<img class="top-image" src="http://localhost/mail/webinar-no-text.png" width="560"><br><br>D<br><br>\r\n									\r\n			                           \r\n			                             <font color="#00FF00"><span style="background-color: rgb(8, 49, 57);">HEDİYEÇEKİM123\r\n									</span></font></div>\r\n									</td>\r\n								</tr>\r\n								\r\n								<tr>\r\n						<td style="border-collapse: collapse;border: 0;margin: 0;padding: 0;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;" valign="top" align="center">\r\n							<table style="font-weight: normal;border-collapse: collapse;border: 0;margin: 0;padding: 0;font-family: Arial, sans-serif;">\r\n								<tbody><tr>\r\n									<td class="social" style="border-collapse: collapse;border: 0;margin: 0;padding: 10px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;text-align: center;" valign="middle" align="center">\r\n										<table style="font-weight: normal;border-collapse: collapse;border: 0;margin: 0;padding: 0;font-family: Arial, sans-serif;">\r\n											<tbody><tr>\r\n												<td style="border-collapse: collapse;border: 0;margin: 0;padding: 5px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;"><a target="_blank" href="http://localhost/blog"><img src="http://localhost/mail/rss-teal.png"></a></td>\r\n									<td style="border-collapse: collapse;border: 0;margin: 0;padding: 5px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;"><a target="_blank" href="https://twitter.com/"><img src="http://localhost/mail/twitter-teal.png"></a></td>\r\n									<td style="border-collapse: collapse;border: 0;margin: 0;padding: 5px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;"><a target="_blank" href="https://www.facebook.com/"><img src="http://localhost/mail/facebook-teal.png"></a></td>\r\n									<td style="border-collapse: collapse;border: 0;margin: 0;padding: 5px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;"><a target="_blank" href="https://www.youtube.com/"><img src="http://localhost/mail/youtube-teal.png"></a></td>\r\n									<td style="border-collapse: collapse;border: 0;margin: 0;padding: 5px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;"><a target="_blank" href="https://www.instagram.com/"><img src="http://localhost/mail/linkedin-teal.png" width="20px" height="20px"></a></td>\r\n									<td style="border-collapse: collapse;border: 0;margin: 0;padding: 5px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;"><a target="_blank" href="https://www.google.com/"><img src="http://localhost/mail/google-teal.png"></a></td>\r\n\r\n											</tr>\r\n										</tbody></table>\r\n									</td>\r\n								</tr>\r\n							</tbody></table>\r\n						</td>\r\n					</tr>\r\n<tr style="border-top: 4px solid #00a5b5;" bgcolor="#fff">\r\n						<td style="border-collapse: collapse;border: 0;margin: 0;padding: 0;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;background: #fff;text-align: center;" valign="top">\r\n							<table style="font-weight: normal;border-collapse: collapse;border: 0;margin: 0;padding: 0;font-family: Arial, sans-serif;">\r\n								<tbody><tr>\r\n									<td class="inside-footer" style="border-collapse: collapse;border: 0;margin: 0;padding: 20px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 12px;line-height: 16px;vertical-align: middle;text-align: center;width: 580px;" valign="middle" align="center">\r\n<div id="address" class="mktEditable">\r\n										<b>OziySHOP ECommerce Software</b><br>\r\n                            Deneme mah. Deneme Cad. Deneme Apt. Deneme Blok Deneme Kat.1 Daire 6 GAZİANTEP / MERKEZ<br>\r\n							444 44 44 siteniz@siteniz.com<br>\r\n                            <a style="color: #00a5b5;" href="http://localhost/iletisim/">Bize Ulaşın</a>\r\n</div>\r\n									</td>\r\n								</tr>\r\n							</tbody></table>\r\n						</td>\r\n					</tr>\r\n							</tbody></table>\r\n						</td>\r\n					</tr>\r\n				\r\n												\r\n					\r\n					\r\n				</tbody></table>\r\n			</td>\r\n		</tr>\r\n	</tbody></table>\r\n  \r\n								 								 								 								 								 								 ', '', '02.06.2021', '2021-06-26', '0,HEDİYEÇEKİM123-oziyweb@hotmail.com');

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

--
-- Tablo için tablo yapısı `markalar`
--

CREATE TABLE IF NOT EXISTS `markalar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim` longtext COLLATE utf8_turkish_ci,
  `seo` longtext COLLATE utf8_turkish_ci,
  `link` longtext COLLATE utf8_turkish_ci,
  `durum` longtext COLLATE utf8_turkish_ci NOT NULL,
  `sira` int(11) DEFAULT NULL,
  `tarih` text COLLATE utf8_turkish_ci,
  `dil` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=3 ;

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

INSERT INTO `markalar` (`id`, `adi`, `resim`, `seo`, `link`, `durum`, `sira`, `tarih`, `dil`) VALUES
(1, 'AEG', 'resimyok.jpg', 'aeg', '', '1', NULL, '23.01.2024 09:08:55', NULL),
(2, 'SONY', 'resimyok.jpg', 'sony', '', '1', NULL, '23.01.2024 09:53:54', NULL);

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

--
-- Tablo için tablo yapısı `sayfalar`
--

CREATE TABLE IF NOT EXISTS `sayfalar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `aciklama` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim` longtext COLLATE utf8_turkish_ci,
  `seo` longtext COLLATE utf8_turkish_ci,
  `hit` longtext COLLATE utf8_turkish_ci,
  `stitle` longtext COLLATE utf8_turkish_ci,
  `skey` longtext COLLATE utf8_turkish_ci,
  `sdesc` longtext COLLATE utf8_turkish_ci,
  `seodurum` longtext COLLATE utf8_turkish_ci,
  `durum` longtext COLLATE utf8_turkish_ci NOT NULL,
  `sira` int(11) DEFAULT NULL,
  `tarih` text COLLATE utf8_turkish_ci,
  `dil` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=13 ;

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

INSERT INTO `sayfalar` (`id`, `adi`, `aciklama`, `resim`, `seo`, `hit`, `stitle`, `skey`, `sdesc`, `seodurum`, `durum`, `sira`, `tarih`, `dil`) VALUES
(1, 'Hakkımızda', '<p>"On the other hand, we denounce with righteous indignation and dislike \nmen who are so beguiled and demoralized by the charms of pleasure of the\n moment, so blinded by desire, that they cannot foresee the pain and \ntrouble that are bound to ensue; and equal blame belongs to those who \nfail in their duty through weakness of will, which is the same as saying\n through shrinking from toil and pain. These cases are perfectly simple \nand easy to distinguish. In a free hour, when our power of choice is \nuntrammelled and when nothing prevents our being able to do what we like\n best, every pleasure is to be welcomed and every pain avoided. But in \ncertain circumstances and owing to the claims of duty or the obligations\n of business it will frequently occur that pleasures have to be \nrepudiated and annoyances accepted. The wise man therefore always holds \nin these matters to this principle of selection: he rejects pleasures to\n secure other greater pleasures, or else he endures pains to avoid worse\n pains."</p>', '20f3a2eb81e75a1b1d5e1d3e4112a452h.jpg', 'hakkimizda-1', '148', '', '', '', '', '1', 1, '18.06.2021 13:55:03', NULL),
(2, 'Güvenli Alışveriş', '<p>"On the other hand, we denounce with righteous indignation and dislike \nmen who are so beguiled and demoralized by the charms of pleasure of the\n moment, so blinded by desire, that they cannot foresee the pain and \ntrouble that are bound to ensue; and equal blame belongs to those who \nfail in their duty through weakness of will, which is the same as saying\n through shrinking from toil and pain. These cases are perfectly simple \nand easy to distinguish. In a free hour, when our power of choice is \nuntrammelled and when nothing prevents our being able to do what we like\n best, every pleasure is to be welcomed and every pain avoided. But in \ncertain circumstances and owing to the claims of duty or the obligations\n of business it will frequently occur that pleasures have to be \nrepudiated and annoyances accepted. The wise man therefore always holds \nin these matters to this principle of selection: he rejects pleasures to\n secure other greater pleasures, or else he endures pains to avoid worse\n pains."</p>', 'resimyok.jpg', 'guvenli-alisveris-2', '28', '', '', '', '', '1', 0, '18.06.2021 13:56:12', NULL),
(3, 'İade Koşulları', '<p>"On the other hand, we denounce with righteous indignation and dislike \nmen who are so beguiled and demoralized by the charms of pleasure of the\n moment, so blinded by desire, that they cannot foresee the pain and \ntrouble that are bound to ensue; and equal blame belongs to those who \nfail in their duty through weakness of will, which is the same as saying\n through shrinking from toil and pain. These cases are perfectly simple \nand easy to distinguish. In a free hour, when our power of choice is \nuntrammelled and when nothing prevents our being able to do what we like\n best, every pleasure is to be welcomed and every pain avoided. But in \ncertain circumstances and owing to the claims of duty or the obligations\n of business it will frequently occur that pleasures have to be \nrepudiated and annoyances accepted. The wise man therefore always holds \nin these matters to this principle of selection: he rejects pleasures to\n secure other greater pleasures, or else he endures pains to avoid worse\n pains."</p>', 'resimyok.jpg', 'iade-kosullar8-3', '32', '', '', '', '', '1', 0, '18.06.2021 13:56:28', NULL),
(4, 'Korona Tedbirleri', '<p>"On the other hand, we denounce with righteous indignation and dislike \nmen who are so beguiled and demoralized by the charms of pleasure of the\n moment, so blinded by desire, that they cannot foresee the pain and \ntrouble that are bound to ensue; and equal blame belongs to those who \nfail in their duty through weakness of will, which is the same as saying\n through shrinking from toil and pain. These cases are perfectly simple \nand easy to distinguish. In a free hour, when our power of choice is \nuntrammelled and when nothing prevents our being able to do what we like\n best, every pleasure is to be welcomed and every pain avoided. But in \ncertain circumstances and owing to the claims of duty or the obligations\n of business it will frequently occur that pleasures have to be \nrepudiated and annoyances accepted. The wise man therefore always holds \nin these matters to this principle of selection: he rejects pleasures to\n secure other greater pleasures, or else he endures pains to avoid worse\n pains."</p>', 'resimyok.jpg', 'korona-tedbirleri-4', '23', '', '', '', '', '1', 0, '18.06.2021 13:56:39', NULL),
(5, 'Mesafeli Satış Sözleşmesi', '<p>"On the other hand, we denounce with righteous indignation and dislike \nmen who are so beguiled and demoralized by the charms of pleasure of the\n moment, so blinded by desire, that they cannot foresee the pain and \ntrouble that are bound to ensue; and equal blame belongs to those who \nfail in their duty through weakness of will, which is the same as saying\n through shrinking from toil and pain. These cases are perfectly simple \nand easy to distinguish. In a free hour, when our power of choice is \nuntrammelled and when nothing prevents our being able to do what we like\n best, every pleasure is to be welcomed and every pain avoided. But in \ncertain circumstances and owing to the claims of duty or the obligations\n of business it will frequently occur that pleasures have to be \nrepudiated and annoyances accepted. The wise man therefore always holds \nin these matters to this principle of selection: he rejects pleasures to\n secure other greater pleasures, or else he endures pains to avoid worse\n pains."</p>', 'resimyok.jpg', 'mesafeli-satis-sozlesmesi-5', '24', '', '', '', '', '1', 0, '18.06.2021 13:56:53', NULL),
(6, 'Üyelik Sözleşmesi', '<p>"On the other hand, we denounce with righteous indignation and dislike \nmen who are so beguiled and demoralized by the charms of pleasure of the\n moment, so blinded by desire, that they cannot foresee the pain and \ntrouble that are bound to ensue; and equal blame belongs to those who \nfail in their duty through weakness of will, which is the same as saying\n through shrinking from toil and pain. These cases are perfectly simple \nand easy to distinguish. In a free hour, when our power of choice is \nuntrammelled and when nothing prevents our being able to do what we like\n best, every pleasure is to be welcomed and every pain avoided. But in \ncertain circumstances and owing to the claims of duty or the obligations\n of business it will frequently occur that pleasures have to be \nrepudiated and annoyances accepted. The wise man therefore always holds \nin these matters to this principle of selection: he rejects pleasures to\n secure other greater pleasures, or else he endures pains to avoid worse\n pains."</p>', 'resimyok.jpg', 'uyelik-sozlesmesi-6', '22', '', '', '', '', '1', 0, '18.06.2021 13:57:37', NULL),
(7, 'Gizlilik Politikası', '<p>"On the other hand, we denounce with righteous indignation and dislike \nmen who are so beguiled and demoralized by the charms of pleasure of the\n moment, so blinded by desire, that they cannot foresee the pain and \ntrouble that are bound to ensue; and equal blame belongs to those who \nfail in their duty through weakness of will, which is the same as saying\n through shrinking from toil and pain. These cases are perfectly simple \nand easy to distinguish. In a free hour, when our power of choice is \nuntrammelled and when nothing prevents our being able to do what we like\n best, every pleasure is to be welcomed and every pain avoided. But in \ncertain circumstances and owing to the claims of duty or the obligations\n of business it will frequently occur that pleasures have to be \nrepudiated and annoyances accepted. The wise man therefore always holds \nin these matters to this principle of selection: he rejects pleasures to\n secure other greater pleasures, or else he endures pains to avoid worse\n pains."</p>', 'resimyok.jpg', 'gizlilik-politikasi-7', '27', '', '', '', '', '1', 0, '18.06.2021 13:58:04', NULL),
(8, 'Çözüm Merkezi', '<p>"On the other hand, we denounce with righteous indignation and dislike \nmen who are so beguiled and demoralized by the charms of pleasure of the\n moment, so blinded by desire, that they cannot foresee the pain and \ntrouble that are bound to ensue; and equal blame belongs to those who \nfail in their duty through weakness of will, which is the same as saying\n through shrinking from toil and pain. These cases are perfectly simple \nand easy to distinguish. In a free hour, when our power of choice is \nuntrammelled and when nothing prevents our being able to do what we like\n best, every pleasure is to be welcomed and every pain avoided. But in \ncertain circumstances and owing to the claims of duty or the obligations\n of business it will frequently occur that pleasures have to be \nrepudiated and annoyances accepted. The wise man therefore always holds \nin these matters to this principle of selection: he rejects pleasures to\n secure other greater pleasures, or else he endures pains to avoid worse\n pains."</p>', 'resimyok.jpg', 'cozum-merkezi-8', '24', '', '', '', '', '1', 0, '18.06.2021 13:58:29', NULL),
(9, 'Çerez Politikası', '<p>"On the other hand, we denounce with righteous indignation and dislike \nmen who are so beguiled and demoralized by the charms of pleasure of the\n moment, so blinded by desire, that they cannot foresee the pain and \ntrouble that are bound to ensue; and equal blame belongs to those who \nfail in their duty through weakness of will, which is the same as saying\n through shrinking from toil and pain. These cases are perfectly simple \nand easy to distinguish. In a free hour, when our power of choice is \nuntrammelled and when nothing prevents our being able to do what we like\n best, every pleasure is to be welcomed and every pain avoided. But in \ncertain circumstances and owing to the claims of duty or the obligations\n of business it will frequently occur that pleasures have to be \nrepudiated and annoyances accepted. The wise man therefore always holds \nin these matters to this principle of selection: he rejects pleasures to\n secure other greater pleasures, or else he endures pains to avoid worse\n pains."</p>', 'resimyok.jpg', 'cerez-politikasi-9', '26', '', '', '', '', '1', 0, '18.06.2021 13:58:58', NULL),
(10, 'KVKK Metni', '<p>"On the other hand, we denounce with righteous indignation and dislike \nmen who are so beguiled and demoralized by the charms of pleasure of the\n moment, so blinded by desire, that they cannot foresee the pain and \ntrouble that are bound to ensue; and equal blame belongs to those who \nfail in their duty through weakness of will, which is the same as saying\n through shrinking from toil and pain. These cases are perfectly simple \nand easy to distinguish. In a free hour, when our power of choice is \nuntrammelled and when nothing prevents our being able to do what we like\n best, every pleasure is to be welcomed and every pain avoided. But in \ncertain circumstances and owing to the claims of duty or the obligations\n of business it will frequently occur that pleasures have to be \nrepudiated and annoyances accepted. The wise man therefore always holds \nin these matters to this principle of selection: he rejects pleasures to\n secure other greater pleasures, or else he endures pains to avoid worse\n pains."</p>', 'resimyok.jpg', 'kvkk-metni-10', '24', '', '', '', '', '1', 0, '18.06.2021 13:59:43', NULL),
(11, 'Ödeme Seçenekleri', '<p>"On the other hand, we denounce with righteous indignation and dislike \nmen who are so beguiled and demoralized by the charms of pleasure of the\n moment, so blinded by desire, that they cannot foresee the pain and \ntrouble that are bound to ensue; and equal blame belongs to those who \nfail in their duty through weakness of will, which is the same as saying\n through shrinking from toil and pain. These cases are perfectly simple \nand easy to distinguish. In a free hour, when our power of choice is \nuntrammelled and when nothing prevents our being able to do what we like\n best, every pleasure is to be welcomed and every pain avoided. But in \ncertain circumstances and owing to the claims of duty or the obligations\n of business it will frequently occur that pleasures have to be \nrepudiated and annoyances accepted. The wise man therefore always holds \nin these matters to this principle of selection: he rejects pleasures to\n secure other greater pleasures, or else he endures pains to avoid worse\n pains."</p>', 'resimyok.jpg', 'odeme-secenekleri-11', '29', '', '', '', '', '1', 0, '18.06.2021 14:01:12', NULL),
(12, 'Nasıl Ürün Alırım ?', '<p>"On the other hand, we denounce with righteous indignation and dislike \nmen who are so beguiled and demoralized by the charms of pleasure of the\n moment, so blinded by desire, that they cannot foresee the pain and \ntrouble that are bound to ensue; and equal blame belongs to those who \nfail in their duty through weakness of will, which is the same as saying\n through shrinking from toil and pain. These cases are perfectly simple \nand easy to distinguish. In a free hour, when our power of choice is \nuntrammelled and when nothing prevents our being able to do what we like\n best, every pleasure is to be welcomed and every pain avoided. But in \ncertain circumstances and owing to the claims of duty or the obligations\n of business it will frequently occur that pleasures have to be \nrepudiated and annoyances accepted. The wise man therefore always holds \nin these matters to this principle of selection: he rejects pleasures to\n secure other greater pleasures, or else he endures pains to avoid worse\n pains."</p>', 'resimyok.jpg', 'nasil-urun-alirim-12', '23', '', '', '', '', '1', 0, '18.06.2021 14:01:25', NULL);

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

--
-- Tablo için tablo yapısı `sepet`
--

CREATE TABLE IF NOT EXISTS `sepet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `urunid` longtext COLLATE utf8_turkish_ci NOT NULL,
  `ekozellikid` varchar(255) COLLATE utf8_turkish_ci NOT NULL DEFAULT '0',
  `ekozellikadet` varchar(255) COLLATE utf8_turkish_ci NOT NULL DEFAULT '0',
  `adet` int(11) unsigned NOT NULL,
  `fiyat` decimal(10,2) unsigned DEFAULT NULL,
  `kdvsizfiyat` decimal(10,2) unsigned DEFAULT NULL,
  `kdv` decimal(10,2) DEFAULT NULL,
  `oran` int(11) DEFAULT '0',
  `havaleindirim` decimal(10,2) unsigned DEFAULT NULL,
  `gelenkim` longtext COLLATE utf8_turkish_ci,
  `efiyat` decimal(10,2) DEFAULT '0.00',
  `ekurun` longtext COLLATE utf8_turkish_ci NOT NULL,
  `kargo` int(11) DEFAULT NULL,
  `alodedurum` int(11) DEFAULT NULL,
  `alodemetin` longtext COLLATE utf8_turkish_ci,
  `alodeadet` varchar(200) COLLATE utf8_turkish_ci NOT NULL DEFAULT '0',
  `kuponid` int(11) DEFAULT '0',
  `kupontutar` decimal(10,2) NOT NULL DEFAULT '0.00',
  `cekid` int(11) DEFAULT '0',
  `cektutar` decimal(10,0) NOT NULL DEFAULT '0',
  `kim` longtext COLLATE utf8_turkish_ci,
  `tarih` text COLLATE utf8_turkish_ci,
  `dil` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=10 ;

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

--
-- Tablo için tablo yapısı `siparis`
--

CREATE TABLE IF NOT EXISTS `siparis` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `siparisno` longtext COLLATE utf8_turkish_ci NOT NULL,
  `odemetipi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `urunid` longtext COLLATE utf8_turkish_ci NOT NULL,
  `adet` longtext COLLATE utf8_turkish_ci NOT NULL,
  `ekozellikid` longtext COLLATE utf8_turkish_ci NOT NULL,
  `ekozellikadet` longtext COLLATE utf8_turkish_ci NOT NULL,
  `uyetip` longtext COLLATE utf8_turkish_ci NOT NULL,
  `vergibilgileri` longtext COLLATE utf8_turkish_ci NOT NULL,
  `adsoyad` longtext COLLATE utf8_turkish_ci,
  `telefon` longtext COLLATE utf8_turkish_ci,
  `email` longtext COLLATE utf8_turkish_ci,
  `adres` longtext COLLATE utf8_turkish_ci,
  `il` longtext COLLATE utf8_turkish_ci,
  `ilce` longtext COLLATE utf8_turkish_ci,
  `faturatip` int(11) NOT NULL DEFAULT '0',
  `faturaadres` longtext COLLATE utf8_turkish_ci,
  `faturail` longtext COLLATE utf8_turkish_ci,
  `faturailce` longtext COLLATE utf8_turkish_ci NOT NULL,
  `mesaj` longtext COLLATE utf8_turkish_ci NOT NULL,
  `onay` int(11) NOT NULL,
  `aratutar` decimal(10,2) DEFAULT NULL,
  `kdvtutari` decimal(10,2) DEFAULT NULL,
  `kargotutari` decimal(10,2) DEFAULT NULL,
  `havaleindirimtutari` decimal(10,2) DEFAULT '0.00',
  `kuponid` int(11) NOT NULL DEFAULT '0',
  `kupontutari` decimal(10,2) NOT NULL DEFAULT '0.00',
  `cekid` int(11) NOT NULL DEFAULT '0',
  `cektutari` decimal(10,2) NOT NULL DEFAULT '0.00',
  `kapitutar` decimal(10,2) NOT NULL DEFAULT '0.00',
  `toplamtutar` decimal(10,2) NOT NULL DEFAULT '0.00',
  `uye` int(11) DEFAULT '0',
  `kim` longtext COLLATE utf8_turkish_ci,
  `gelenkim` longtext COLLATE utf8_turkish_ci NOT NULL,
  `uruntablo` longtext COLLATE utf8_turkish_ci NOT NULL,
  `mailtablo` longtext COLLATE utf8_turkish_ci NOT NULL,
  `durum` longtext COLLATE utf8_turkish_ci NOT NULL,
  `tarih` longtext COLLATE utf8_turkish_ci NOT NULL,
  `ekdurum` int(11) NOT NULL DEFAULT '0',
  `eknot` longtext COLLATE utf8_turkish_ci NOT NULL,
  `kargoid` int(11) NOT NULL DEFAULT '0',
  `takipno` longtext COLLATE utf8_turkish_ci NOT NULL,
  `tarihson` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=19 ;

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

INSERT INTO `siparis` (`id`, `siparisno`, `odemetipi`, `urunid`, `adet`, `ekozellikid`, `ekozellikadet`, `uyetip`, `vergibilgileri`, `adsoyad`, `telefon`, `email`, `adres`, `il`, `ilce`, `faturatip`, `faturaadres`, `faturail`, `faturailce`, `mesaj`, `onay`, `aratutar`, `kdvtutari`, `kargotutari`, `havaleindirimtutari`, `kuponid`, `kupontutari`, `cekid`, `cektutari`, `kapitutar`, `toplamtutar`, `uye`, `kim`, `gelenkim`, `uruntablo`, `mailtablo`, `durum`, `tarih`, `ekdurum`, `eknot`, `kargoid`, `takipno`, `tarihson`) VALUES
(16, 'NHUVMZ', 'Havale/EFT', '11,1', '1,2', '0,5,3', '0,2,2', 'Bireysel', 'TC No : 32342423423', 'M. Özkan Boybeyi', '05424922500', 'oziyweb@hotmail.com', 'test adress', 'İstanbul', 'Göztepe', 0, 'test adress', 'İstanbul', 'Göztepe', '', 1, '52600.00', '10520.00', '0.00', '6720.00', 0, '0.00', 0, '0.00', '0.00', '56400.00', 1, '127.0.0.1', '1', '\r\n			                             <tr>\r\n										 <td class=''product-col''>\r\n												<div class=''product''>\r\n													<figure class=''product-media''>\r\n														<a href=''http://localhost/urun/roma-yatak-odasi-11''>\r\n															<img style=''width: 60px;height: 60px;'' src=''http://localhost/resimler/urunler/4689f8d05eaa167165b1d8cf128bcfbel.jpg''>\r\n														</a>\r\n													</figure>\r\n													<h3 class=''product-title''>\r\n														<a href=''http://localhost/urun/roma-yatak-odasi-11''><b style=''font-weight: 400;''>Roma Yatak Odası</b></br>\r\n														<div style=''font-weight: 400;font-size: 12px;margin-left: 2px;''>\r\n														</div>\r\n														</a>\r\n														<div class=''badges'' style=''margin-top: 10px;display: inline-block;width: 300px;''>\r\n														 \r\n														 \r\n														 \r\n														</div>\r\n													</h3><!-- End .product-title -->\r\n												</div><!-- End .product -->\r\n											</td>\r\n											<td class=''price-col''>22.000,00 TL</td>\r\n											<td class=''price-col'' style=''font-size: 14px;''>(% 20)</br>\r\n											 4.400,00 TL</td>\r\n											<td class=''quantity-col''>\r\n                                                <div class=''cart-product-quantity''>   \r\n											     1\r\n												</div><!-- End .cart-product-quantity -->\r\n                                            </td>\r\n											<td class=''total-col''>26.400,00 TL</td>\r\n										</tr>\r\n                                        \r\n			                             <tr>\r\n										 <td class=''product-col''>\r\n												<div class=''product''>\r\n													<figure class=''product-media''>\r\n														<a href=''http://localhost/urun/yatak-odasi-takimi-1''>\r\n															<img style=''width: 60px;height: 60px;'' src=''http://localhost/resimler/urunler/a78be68db44bf39fbe050c76b64eeb621.jpg''>\r\n														</a>\r\n													</figure>\r\n													<h3 class=''product-title''>\r\n														<a href=''http://localhost/urun/yatak-odasi-takimi-1''><b style=''font-weight: 400;''>Yatak Odası Takımı</b></br>\r\n														<div style=''font-weight: 400;font-size: 12px;margin-left: 2px;''>Kumaş Türü : Deri</br>Ebat : 300x400</br>\r\n														</div>\r\n														</a>\r\n														<div class=''badges'' style=''margin-top: 10px;display: inline-block;width: 300px;''>\r\n														 \r\n														 \r\n														 \r\n														</div>\r\n													</h3><!-- End .product-title -->\r\n												</div><!-- End .product -->\r\n											</td>\r\n											<td class=''price-col''>15.300,00 TL</td>\r\n											<td class=''price-col'' style=''font-size: 14px;''>(% 20)</br>\r\n											 3.060,00 TL</td>\r\n											<td class=''quantity-col''>\r\n                                                <div class=''cart-product-quantity''>   \r\n											     2\r\n												</div><!-- End .cart-product-quantity -->\r\n                                            </td>\r\n											<td class=''total-col''>36.720,00 TL</td>\r\n										</tr>\r\n                                        ', '\r\n <tr style=''direction:ltr!important''>\r\n <td style=''border-bottom-color:#ccc; border-bottom-\r\n style:dotted; border-right-color:#ccc; border-right-style:dotted; direction:ltr!importa\r\n nt; border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0'' valign=''top'' align=''left''>\r\n <table style=''direction:ltr!important; border-collapse:collap\r\n se; border:0'' width=''100%'' cellspacing=''0'' cellpadding=''0'' border=''0''>\r\n <tbody>\r\n <tr style=''direction:ltr!important''>\r\n <td class=''x_product-img'' style=''direction:ltr!important; \r\n border-collapse:collapse; font-weight:normal; padding:0 10px 0 0;\r\n border:0'' width=''80'' valign=''top'' align=''left''>\r\n <a href=''http://localhost/urun/roma-yatak-odasi-11'' target=''_blank'' rel=''noopener noreferrer'' data-auth=''NotApplicable'' style=''direction:ltr!important'' data-linkindex=''1''>\r\n <img data-imagetype=''External'' src=''http://localhost/resimler/urunler/4689f8d05eaa167165b1d8cf128bcfbel.jpg'' style=''display:block; direction:ltr!important;\r\n height:auto; line-height:100%; outline:none; text-decoration:none; border:0'' width=''80'' border=''0''></a>\r\n </td>\r\n <td style=''font-family:Arial; font-size:13px; line-height:18px; color:#484848;\r\n direction:ltr!important; border-collapse:collapse; font-weight:normal; padding:0;\r\n border:0'' valign=''top'' align=''left''>\r\n <a href=''http://localhost/urun/roma-yatak-odasi-11'' target=''_blank'' rel=''noopener noreferrer'' data-auth=''NotApplicable'' style=''font-family:Arial; font-size:13px; \r\n line-height:18px; color:#484848; text-decoration:none; direction:ltr!important'' data-linkindex=''2''>Roma Yatak Odası\r\n <div style=''font-weight: 400;font-size: 12px;margin-left: 2px;''>\r\n </div>\r\n <br style=''direction:ltr!important''>\r\n <span style=''color:#8c8c8c; font-size:11px; direction:ltr!important;display: inline-block;width: 300px;''>\r\n <div class=''badges'' style=''margin-top: 10px;''>\r\n \r\n \r\n </div></span>\r\n </a>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n  <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>22.000,00 TL</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>(% 20)</br>\r\n 4.400,00 TL</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>1</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n font-family:Arial; font-size:13px; line-height:18px; color:#484848;\r\n direction:ltr!important; border-collapse:collapse; font-weight:normal;\r\n padding:10px; border-width:0 0 1px'' valign=''top'' align=''center''>26.400,00 TL</td>\r\n </tr>\r\n\r\n \r\n <tr style=''direction:ltr!important''>\r\n <td style=''border-bottom-color:#ccc; border-bottom-\r\n style:dotted; border-right-color:#ccc; border-right-style:dotted; direction:ltr!importa\r\n nt; border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0'' valign=''top'' align=''left''>\r\n <table style=''direction:ltr!important; border-collapse:collap\r\n se; border:0'' width=''100%'' cellspacing=''0'' cellpadding=''0'' border=''0''>\r\n <tbody>\r\n <tr style=''direction:ltr!important''>\r\n <td class=''x_product-img'' style=''direction:ltr!important; \r\n border-collapse:collapse; font-weight:normal; padding:0 10px 0 0;\r\n border:0'' width=''80'' valign=''top'' align=''left''>\r\n <a href=''http://localhost/urun/yatak-odasi-takimi-1'' target=''_blank'' rel=''noopener noreferrer'' data-auth=''NotApplicable'' style=''direction:ltr!important'' data-linkindex=''1''>\r\n <img data-imagetype=''External'' src=''http://localhost/resimler/urunler/a78be68db44bf39fbe050c76b64eeb621.jpg'' style=''display:block; direction:ltr!important;\r\n height:auto; line-height:100%; outline:none; text-decoration:none; border:0'' width=''80'' border=''0''></a>\r\n </td>\r\n <td style=''font-family:Arial; font-size:13px; line-height:18px; color:#484848;\r\n direction:ltr!important; border-collapse:collapse; font-weight:normal; padding:0;\r\n border:0'' valign=''top'' align=''left''>\r\n <a href=''http://localhost/urun/yatak-odasi-takimi-1'' target=''_blank'' rel=''noopener noreferrer'' data-auth=''NotApplicable'' style=''font-family:Arial; font-size:13px; \r\n line-height:18px; color:#484848; text-decoration:none; direction:ltr!important'' data-linkindex=''2''>Yatak Odası Takımı\r\n <div style=''font-weight: 400;font-size: 12px;margin-left: 2px;''>Kumaş Türü : Deri</br>Ebat : 300x400</br>\r\n </div>\r\n <br style=''direction:ltr!important''>\r\n <span style=''color:#8c8c8c; font-size:11px; direction:ltr!important;display: inline-block;width: 300px;''>\r\n <div class=''badges'' style=''margin-top: 10px;''>\r\n \r\n \r\n </div></span>\r\n </a>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n  <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>15.300,00 TL</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>(% 20)</br>\r\n 3.060,00 TL</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>2</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n font-family:Arial; font-size:13px; line-height:18px; color:#484848;\r\n direction:ltr!important; border-collapse:collapse; font-weight:normal;\r\n padding:10px; border-width:0 0 1px'' valign=''top'' align=''center''>36.720,00 TL</td>\r\n </tr>\r\n\r\n ', 'Sipariş Onaylandı', '31.01.2024 13:33:09', 0, '', 0, '', '2024-01-31'),
(18, 'GBZHMP', 'Kapıda Ödeme', '31,31,41,41', '1,1,1,1', '0,0,12,14,14', '0,0,1,1,1', 'Bireysel', 'TC No : 32342423423', 'M. Özkan Boybeyi', '05424922500', 'oziyweb@hotmail.com', 'Deneme Mah Deneme Cad No.22', 'İstanbul', 'Gülhane', 0, 'Deneme Mah Deneme Cad No.22', 'İstanbul', 'Gülhane', 'dd', 1, '30400.00', '6080.00', '5.00', '12024.00', 0, '0.00', 0, '0.00', '5.00', '36485.00', 1, '127.0.0.1', '1', '\r\n			                             <tr>\r\n										 <td class=''product-col''>\r\n												<div class=''product''>\r\n													<figure class=''product-media''>\r\n														<a href=''http://localhost/urun/laptop-apple-macbook-pro-m1-16gb-512gb''>\r\n															<img style=''width: 60px;height: 60px;'' src=''http://localhost/resimler/urunler/products_12_2.jpg''>\r\n														</a>\r\n													</figure>\r\n													<h3 class=''product-title''>\r\n														<a href=''http://localhost/urun/laptop-apple-macbook-pro-m1-16gb-512gb''><b style=''font-weight: 400;''>Laptop Apple MacBook Pro M1 16GB 512GB</b></br>\r\n														<div style=''font-weight: 400;font-size: 12px;margin-left: 2px;''>\r\n														</div>\r\n														</a>\r\n														<div class=''badges'' style=''margin-top: 10px;display: inline-block;width: 300px;''>\r\n														 \r\n			<span class=''badge'' style=''border: 1px solid #2cc43c;padding: 5px;line-height: 20px !important;color: #2cc43c;''>\r\n			<i style=''font-size: 18px;'' class=''icon-truck''></i> KARGO ÜCRETSİZ\r\n			</span>\r\n			\r\n														 \r\n														 \r\n														</div>\r\n													</h3><!-- End .product-title -->\r\n												</div><!-- End .product -->\r\n											</td>\r\n											<td class=''price-col''>15.000,00 TL</td>\r\n											<td class=''price-col'' style=''font-size: 14px;''>(% 20)</br>\r\n											 3.000,00 TL</td>\r\n											<td class=''quantity-col''>\r\n                                                <div class=''cart-product-quantity''>   \r\n											     1\r\n												</div><!-- End .cart-product-quantity -->\r\n                                            </td>\r\n											<td class=''total-col''>18.000,00 TL</td>\r\n										</tr>\r\n                                        \r\n			                             <tr>\r\n										 <td class=''product-col''>\r\n												<div class=''product''>\r\n													<figure class=''product-media''>\r\n														<a href=''http://localhost/urun/laptop-apple-macbook-pro-m1-16gb-512gb''>\r\n															<img style=''width: 60px;height: 60px;'' src=''http://localhost/resimler/urunler/products_12_2.jpg''>\r\n														</a>\r\n													</figure>\r\n													<h3 class=''product-title''>\r\n														<a href=''http://localhost/urun/laptop-apple-macbook-pro-m1-16gb-512gb''><b style=''font-weight: 400;''>Laptop Apple MacBook Pro M1 16GB 512GB</b></br>\r\n														<div style=''font-weight: 400;font-size: 12px;margin-left: 2px;''>\r\n														</div>\r\n														</a>\r\n														<div class=''badges'' style=''margin-top: 10px;display: inline-block;width: 300px;''>\r\n														 \r\n			<span class=''badge'' style=''border: 1px solid #2cc43c;padding: 5px;line-height: 20px !important;color: #2cc43c;''>\r\n			<i style=''font-size: 18px;'' class=''icon-truck''></i> KARGO ÜCRETSİZ\r\n			</span>\r\n			\r\n														 \r\n														 \r\n														</div>\r\n													</h3><!-- End .product-title -->\r\n												</div><!-- End .product -->\r\n											</td>\r\n											<td class=''price-col''>15.000,00 TL</td>\r\n											<td class=''price-col'' style=''font-size: 14px;''>(% 20)</br>\r\n											 3.000,00 TL</td>\r\n											<td class=''quantity-col''>\r\n                                                <div class=''cart-product-quantity''>   \r\n											     1\r\n												</div><!-- End .cart-product-quantity -->\r\n                                            </td>\r\n											<td class=''total-col''>18.000,00 TL</td>\r\n										</tr>\r\n                                        \r\n			                             <tr>\r\n										 <td class=''product-col''>\r\n												<div class=''product''>\r\n													<figure class=''product-media''>\r\n														<a href=''http://localhost/urun/apple-ipad-pro-m1-11-inch-2021-wi-fi-128gb''>\r\n															<img style=''width: 60px;height: 60px;'' src=''http://localhost/resimler/urunler/products_13_1_1920x.jpg''>\r\n														</a>\r\n													</figure>\r\n													<h3 class=''product-title''>\r\n														<a href=''http://localhost/urun/apple-ipad-pro-m1-11-inch-2021-wi-fi-128gb''><b style=''font-weight: 400;''>Apple iPad Pro M1 11-inch 2021 Wi-Fi 128GB</b></br>\r\n														<div style=''font-weight: 400;font-size: 12px;margin-left: 2px;''>Hafıza  : 6 GB</br>Renk : Gold</br>\r\n														</div>\r\n														</a>\r\n														<div class=''badges'' style=''margin-top: 10px;display: inline-block;width: 300px;''>\r\n														 \r\n														 \r\n														 \r\n														</div>\r\n													</h3><!-- End .product-title -->\r\n												</div><!-- End .product -->\r\n											</td>\r\n											<td class=''price-col''>200,00 TL</td>\r\n											<td class=''price-col'' style=''font-size: 14px;''>(% 20)</br>\r\n											 40,00 TL</td>\r\n											<td class=''quantity-col''>\r\n                                                <div class=''cart-product-quantity''>   \r\n											     1\r\n												</div><!-- End .cart-product-quantity -->\r\n                                            </td>\r\n											<td class=''total-col''>240,00 TL</td>\r\n										</tr>\r\n                                        \r\n			                             <tr>\r\n										 <td class=''product-col''>\r\n												<div class=''product''>\r\n													<figure class=''product-media''>\r\n														<a href=''http://localhost/urun/apple-ipad-pro-m1-11-inch-2021-wi-fi-128gb''>\r\n															<img style=''width: 60px;height: 60px;'' src=''http://localhost/resimler/urunler/products_13_1_1920x.jpg''>\r\n														</a>\r\n													</figure>\r\n													<h3 class=''product-title''>\r\n														<a href=''http://localhost/urun/apple-ipad-pro-m1-11-inch-2021-wi-fi-128gb''><b style=''font-weight: 400;''>Apple iPad Pro M1 11-inch 2021 Wi-Fi 128GB</b></br>\r\n														<div style=''font-weight: 400;font-size: 12px;margin-left: 2px;''>Hafıza  : 6 GB</br>\r\n														</div>\r\n														</a>\r\n														<div class=''badges'' style=''margin-top: 10px;display: inline-block;width: 300px;''>\r\n														 \r\n														 \r\n														 \r\n														</div>\r\n													</h3><!-- End .product-title -->\r\n												</div><!-- End .product -->\r\n											</td>\r\n											<td class=''price-col''>200,00 TL</td>\r\n											<td class=''price-col'' style=''font-size: 14px;''>(% 20)</br>\r\n											 40,00 TL</td>\r\n											<td class=''quantity-col''>\r\n                                                <div class=''cart-product-quantity''>   \r\n											     1\r\n												</div><!-- End .cart-product-quantity -->\r\n                                            </td>\r\n											<td class=''total-col''>240,00 TL</td>\r\n										</tr>\r\n                                        ', '\r\n <tr style=''direction:ltr!important''>\r\n <td style=''border-bottom-color:#ccc; border-bottom-\r\n style:dotted; border-right-color:#ccc; border-right-style:dotted; direction:ltr!importa\r\n nt; border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0'' valign=''top'' align=''left''>\r\n <table style=''direction:ltr!important; border-collapse:collap\r\n se; border:0'' width=''100%'' cellspacing=''0'' cellpadding=''0'' border=''0''>\r\n <tbody>\r\n <tr style=''direction:ltr!important''>\r\n <td class=''x_product-img'' style=''direction:ltr!important; \r\n border-collapse:collapse; font-weight:normal; padding:0 10px 0 0;\r\n border:0'' width=''80'' valign=''top'' align=''left''>\r\n <a href=''http://localhost/urun/laptop-apple-macbook-pro-m1-16gb-512gb'' target=''_blank'' rel=''noopener noreferrer'' data-auth=''NotApplicable'' style=''direction:ltr!important'' data-linkindex=''1''>\r\n <img data-imagetype=''External'' src=''http://localhost/resimler/urunler/products_12_2.jpg'' style=''display:block; direction:ltr!important;\r\n height:auto; line-height:100%; outline:none; text-decoration:none; border:0'' width=''80'' border=''0''></a>\r\n </td>\r\n <td style=''font-family:Arial; font-size:13px; line-height:18px; color:#484848;\r\n direction:ltr!important; border-collapse:collapse; font-weight:normal; padding:0;\r\n border:0'' valign=''top'' align=''left''>\r\n <a href=''http://localhost/urun/laptop-apple-macbook-pro-m1-16gb-512gb'' target=''_blank'' rel=''noopener noreferrer'' data-auth=''NotApplicable'' style=''font-family:Arial; font-size:13px; \r\n line-height:18px; color:#484848; text-decoration:none; direction:ltr!important'' data-linkindex=''2''>Laptop Apple MacBook Pro M1 16GB 512GB\r\n <div style=''font-weight: 400;font-size: 12px;margin-left: 2px;''>\r\n </div>\r\n <br style=''direction:ltr!important''>\r\n <span style=''color:#8c8c8c; font-size:11px; direction:ltr!important;display: inline-block;width: 300px;''>\r\n <div class=''badges'' style=''margin-top: 10px;''>\r\n \r\n			<span class=''badge'' style=''border: 1px solid #2cc43c;padding: 5px;line-height: 20px !important;color: #2cc43c;''>\r\n			<i style=''font-size: 18px;'' class=''icon-truck''></i> KARGO ÜCRETSİZ\r\n			</span>\r\n			\r\n \r\n </div></span>\r\n </a>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n  <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>15.000,00 TL</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>(% 20)</br>\r\n 3.000,00 TL</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>1</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n font-family:Arial; font-size:13px; line-height:18px; color:#484848;\r\n direction:ltr!important; border-collapse:collapse; font-weight:normal;\r\n padding:10px; border-width:0 0 1px'' valign=''top'' align=''center''>18.000,00 TL</td>\r\n </tr>\r\n\r\n \r\n <tr style=''direction:ltr!important''>\r\n <td style=''border-bottom-color:#ccc; border-bottom-\r\n style:dotted; border-right-color:#ccc; border-right-style:dotted; direction:ltr!importa\r\n nt; border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0'' valign=''top'' align=''left''>\r\n <table style=''direction:ltr!important; border-collapse:collap\r\n se; border:0'' width=''100%'' cellspacing=''0'' cellpadding=''0'' border=''0''>\r\n <tbody>\r\n <tr style=''direction:ltr!important''>\r\n <td class=''x_product-img'' style=''direction:ltr!important; \r\n border-collapse:collapse; font-weight:normal; padding:0 10px 0 0;\r\n border:0'' width=''80'' valign=''top'' align=''left''>\r\n <a href=''http://localhost/urun/laptop-apple-macbook-pro-m1-16gb-512gb'' target=''_blank'' rel=''noopener noreferrer'' data-auth=''NotApplicable'' style=''direction:ltr!important'' data-linkindex=''1''>\r\n <img data-imagetype=''External'' src=''http://localhost/resimler/urunler/products_12_2.jpg'' style=''display:block; direction:ltr!important;\r\n height:auto; line-height:100%; outline:none; text-decoration:none; border:0'' width=''80'' border=''0''></a>\r\n </td>\r\n <td style=''font-family:Arial; font-size:13px; line-height:18px; color:#484848;\r\n direction:ltr!important; border-collapse:collapse; font-weight:normal; padding:0;\r\n border:0'' valign=''top'' align=''left''>\r\n <a href=''http://localhost/urun/laptop-apple-macbook-pro-m1-16gb-512gb'' target=''_blank'' rel=''noopener noreferrer'' data-auth=''NotApplicable'' style=''font-family:Arial; font-size:13px; \r\n line-height:18px; color:#484848; text-decoration:none; direction:ltr!important'' data-linkindex=''2''>Laptop Apple MacBook Pro M1 16GB 512GB\r\n <div style=''font-weight: 400;font-size: 12px;margin-left: 2px;''>\r\n </div>\r\n <br style=''direction:ltr!important''>\r\n <span style=''color:#8c8c8c; font-size:11px; direction:ltr!important;display: inline-block;width: 300px;''>\r\n <div class=''badges'' style=''margin-top: 10px;''>\r\n \r\n			<span class=''badge'' style=''border: 1px solid #2cc43c;padding: 5px;line-height: 20px !important;color: #2cc43c;''>\r\n			<i style=''font-size: 18px;'' class=''icon-truck''></i> KARGO ÜCRETSİZ\r\n			</span>\r\n			\r\n \r\n </div></span>\r\n </a>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n  <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>15.000,00 TL</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>(% 20)</br>\r\n 3.000,00 TL</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>1</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n font-family:Arial; font-size:13px; line-height:18px; color:#484848;\r\n direction:ltr!important; border-collapse:collapse; font-weight:normal;\r\n padding:10px; border-width:0 0 1px'' valign=''top'' align=''center''>18.000,00 TL</td>\r\n </tr>\r\n\r\n \r\n <tr style=''direction:ltr!important''>\r\n <td style=''border-bottom-color:#ccc; border-bottom-\r\n style:dotted; border-right-color:#ccc; border-right-style:dotted; direction:ltr!importa\r\n nt; border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0'' valign=''top'' align=''left''>\r\n <table style=''direction:ltr!important; border-collapse:collap\r\n se; border:0'' width=''100%'' cellspacing=''0'' cellpadding=''0'' border=''0''>\r\n <tbody>\r\n <tr style=''direction:ltr!important''>\r\n <td class=''x_product-img'' style=''direction:ltr!important; \r\n border-collapse:collapse; font-weight:normal; padding:0 10px 0 0;\r\n border:0'' width=''80'' valign=''top'' align=''left''>\r\n <a href=''http://localhost/urun/apple-ipad-pro-m1-11-inch-2021-wi-fi-128gb'' target=''_blank'' rel=''noopener noreferrer'' data-auth=''NotApplicable'' style=''direction:ltr!important'' data-linkindex=''1''>\r\n <img data-imagetype=''External'' src=''http://localhost/resimler/urunler/products_13_1_1920x.jpg'' style=''display:block; direction:ltr!important;\r\n height:auto; line-height:100%; outline:none; text-decoration:none; border:0'' width=''80'' border=''0''></a>\r\n </td>\r\n <td style=''font-family:Arial; font-size:13px; line-height:18px; color:#484848;\r\n direction:ltr!important; border-collapse:collapse; font-weight:normal; padding:0;\r\n border:0'' valign=''top'' align=''left''>\r\n <a href=''http://localhost/urun/apple-ipad-pro-m1-11-inch-2021-wi-fi-128gb'' target=''_blank'' rel=''noopener noreferrer'' data-auth=''NotApplicable'' style=''font-family:Arial; font-size:13px; \r\n line-height:18px; color:#484848; text-decoration:none; direction:ltr!important'' data-linkindex=''2''>Apple iPad Pro M1 11-inch 2021 Wi-Fi 128GB\r\n <div style=''font-weight: 400;font-size: 12px;margin-left: 2px;''>Hafıza  : 6 GB</br>Renk : Gold</br>\r\n </div>\r\n <br style=''direction:ltr!important''>\r\n <span style=''color:#8c8c8c; font-size:11px; direction:ltr!important;display: inline-block;width: 300px;''>\r\n <div class=''badges'' style=''margin-top: 10px;''>\r\n \r\n \r\n </div></span>\r\n </a>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n  <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>200,00 TL</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>(% 20)</br>\r\n 40,00 TL</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>1</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n font-family:Arial; font-size:13px; line-height:18px; color:#484848;\r\n direction:ltr!important; border-collapse:collapse; font-weight:normal;\r\n padding:10px; border-width:0 0 1px'' valign=''top'' align=''center''>240,00 TL</td>\r\n </tr>\r\n\r\n \r\n <tr style=''direction:ltr!important''>\r\n <td style=''border-bottom-color:#ccc; border-bottom-\r\n style:dotted; border-right-color:#ccc; border-right-style:dotted; direction:ltr!importa\r\n nt; border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0'' valign=''top'' align=''left''>\r\n <table style=''direction:ltr!important; border-collapse:collap\r\n se; border:0'' width=''100%'' cellspacing=''0'' cellpadding=''0'' border=''0''>\r\n <tbody>\r\n <tr style=''direction:ltr!important''>\r\n <td class=''x_product-img'' style=''direction:ltr!important; \r\n border-collapse:collapse; font-weight:normal; padding:0 10px 0 0;\r\n border:0'' width=''80'' valign=''top'' align=''left''>\r\n <a href=''http://localhost/urun/apple-ipad-pro-m1-11-inch-2021-wi-fi-128gb'' target=''_blank'' rel=''noopener noreferrer'' data-auth=''NotApplicable'' style=''direction:ltr!important'' data-linkindex=''1''>\r\n <img data-imagetype=''External'' src=''http://localhost/resimler/urunler/products_13_1_1920x.jpg'' style=''display:block; direction:ltr!important;\r\n height:auto; line-height:100%; outline:none; text-decoration:none; border:0'' width=''80'' border=''0''></a>\r\n </td>\r\n <td style=''font-family:Arial; font-size:13px; line-height:18px; color:#484848;\r\n direction:ltr!important; border-collapse:collapse; font-weight:normal; padding:0;\r\n border:0'' valign=''top'' align=''left''>\r\n <a href=''http://localhost/urun/apple-ipad-pro-m1-11-inch-2021-wi-fi-128gb'' target=''_blank'' rel=''noopener noreferrer'' data-auth=''NotApplicable'' style=''font-family:Arial; font-size:13px; \r\n line-height:18px; color:#484848; text-decoration:none; direction:ltr!important'' data-linkindex=''2''>Apple iPad Pro M1 11-inch 2021 Wi-Fi 128GB\r\n <div style=''font-weight: 400;font-size: 12px;margin-left: 2px;''>Hafıza  : 6 GB</br>\r\n </div>\r\n <br style=''direction:ltr!important''>\r\n <span style=''color:#8c8c8c; font-size:11px; direction:ltr!important;display: inline-block;width: 300px;''>\r\n <div class=''badges'' style=''margin-top: 10px;''>\r\n \r\n \r\n </div></span>\r\n </a>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n  <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>200,00 TL</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>(% 20)</br>\r\n 40,00 TL</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n border-right-color:#ccc; border-right-style:dotted; font-family:Arial;\r\n font-size:13px; line-height:18px; color:#484848; direction:ltr!important;\r\n border-collapse:collapse; font-weight:normal; padding:10px; border-width:0 1px 1px 0''\r\n valign=''top'' align=''center''>1</td>\r\n <td style=''border-bottom-color:#ccc; border-bottom-style:dotted;\r\n font-family:Arial; font-size:13px; line-height:18px; color:#484848;\r\n direction:ltr!important; border-collapse:collapse; font-weight:normal;\r\n padding:10px; border-width:0 0 1px'' valign=''top'' align=''center''>240,00 TL</td>\r\n </tr>\r\n\r\n ', 'Ödeme Bekleniyor', '04.03.2024 15:23:38', 0, '', 0, '', '2024-03-04');

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

--
-- Tablo için tablo yapısı `siteayarlari`
--

CREATE TABLE IF NOT EXISTS `siteayarlari` (
  `id` int(11) NOT NULL,
  `siteadi` longtext COLLATE utf8_turkish_ci,
  `sitekey` longtext COLLATE utf8_turkish_ci,
  `sitedesc` longtext COLLATE utf8_turkish_ci,
  `logo` longtext COLLATE utf8_turkish_ci,
  `favicon` longtext COLLATE utf8_turkish_ci,
  `google` longtext COLLATE utf8_turkish_ci,
  `yandex` longtext COLLATE utf8_turkish_ci,
  `reklam` longtext COLLATE utf8_turkish_ci,
  `ssldurum` int(11) DEFAULT NULL,
  `bakimdurum` int(11) DEFAULT NULL,
  `bakim` longtext COLLATE utf8_turkish_ci,
  `tel` longtext COLLATE utf8_turkish_ci,
  `ceptel` longtext COLLATE utf8_turkish_ci,
  `whatsapp` longtext COLLATE utf8_turkish_ci,
  `email` longtext COLLATE utf8_turkish_ci,
  `adres` longtext COLLATE utf8_turkish_ci,
  `facebook` longtext COLLATE utf8_turkish_ci,
  `twitter` longtext COLLATE utf8_turkish_ci,
  `pinterest` longtext COLLATE utf8_turkish_ci,
  `linkedin` longtext COLLATE utf8_turkish_ci,
  `instagram` longtext COLLATE utf8_turkish_ci,
  `youtube` longtext COLLATE utf8_turkish_ci,
  `googleplus` longtext COLLATE utf8_turkish_ci,
  `maps` longtext COLLATE utf8_turkish_ci,
  `copy` longtext COLLATE utf8_turkish_ci,
  `tema` longtext COLLATE utf8_turkish_ci,
  `t1` longtext COLLATE utf8_turkish_ci,
  `t2` longtext COLLATE utf8_turkish_ci,
  `t3` longtext COLLATE utf8_turkish_ci,
  `t4` longtext COLLATE utf8_turkish_ci,
  `t5` longtext COLLATE utf8_turkish_ci,
  `t6` longtext COLLATE utf8_turkish_ci,
  `anabanner` longtext COLLATE utf8_turkish_ci,
  `t7` longtext COLLATE utf8_turkish_ci,
  `t8` longtext COLLATE utf8_turkish_ci,
  `siteurl` longtext COLLATE utf8_turkish_ci,
  `dtitle` longtext COLLATE utf8_turkish_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

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

INSERT INTO `siteayarlari` (`id`, `siteadi`, `sitekey`, `sitedesc`, `logo`, `favicon`, `google`, `yandex`, `reklam`, `ssldurum`, `bakimdurum`, `bakim`, `tel`, `ceptel`, `whatsapp`, `email`, `adres`, `facebook`, `twitter`, `pinterest`, `linkedin`, `instagram`, `youtube`, `googleplus`, `maps`, `copy`, `tema`, `t1`, `t2`, `t3`, `t4`, `t5`, `t6`, `anabanner`, `t7`, `t8`, `siteurl`, `dtitle`) VALUES
(1, 'Mobilya Sistemi', '2,sdas,sdasaddas,eeeeee,şş,dd,sadddddddddddddddddddddd,ddddd,tgrgrtgrt,adsasd,ads,das,dsa,da,sd,f,df,fd,ggggggggg,can,canım', '3\r\n\r\nddddddddddd\r\n\r\n', 'd859c4e3bafb65deadb0bc4a5dd20404o.png', '17959d1f1f642edd80c152820a5c5d3ev.png', '', '', '', NULL, NULL, '<div align="center"><h2><b> BAKIMDAYIZ. </b></h2></div><div align="center"><h2><b>LÜTFEN DAHA SONRA TEKRAR DENEYİNİZ.</b></h2></div>', '444 44 44', '0 555 444 33 22', '+905424922500', 'siteniz@siteniz.com', 'Deneme mah. Deneme Cad. Deneme Apt. Deneme Blok Deneme Kat.1 Daire 6 GAZİANTEP / MERKEZ', 'https://www.facebook.com/', 'https://twitter.com/', 'https://www.pinterest.com/', 'https://www.linkedin.com/', 'https://www.instagram.com/', 'https://www.youtube.com/', 'https://www.google.com/', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d25469.378348719816!2d37.36202386751573!3d37.06529180369026!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x1531e1520c5f9b1d%3A0x4b7bd25fec6c1d27!2sGaziantep%20Arkeoloji%20M%C3%BCzesi!5e0!3m2!1str!2str!4v1620684653948!5m2!1str!2str', '2021 @ Copyright Tüm Hakkı Saklıdır. OziyShop bir OziyWeb Projesidir.', 'default', '0ef5044489cfc5fa53f68e47bf8515aa2.png', '67bdfd39ef689baca033d7b9888c506b2.png', 'cd8cab58bd0b9dfdb1563a37cda49e652.png', ' User-agent: *\r\n\r\nAllow: /\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nSitemap: localhost/sitemap.xml', ' ', ' ', '6960ea2211fedc74fbf5f231f83be3df2.png', ' ', ' ', '0', '#Kredi Kartına Faizsiz 12 Taksit İmkanı !');

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

--
-- Tablo için tablo yapısı `slider`
--

CREATE TABLE IF NOT EXISTS `slider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `aciklama` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim` longtext COLLATE utf8_turkish_ci,
  `link` longtext COLLATE utf8_turkish_ci,
  `hit` longtext COLLATE utf8_turkish_ci,
  `stitle` longtext COLLATE utf8_turkish_ci,
  `skey` longtext COLLATE utf8_turkish_ci,
  `sdesc` longtext COLLATE utf8_turkish_ci,
  `seodurum` longtext COLLATE utf8_turkish_ci,
  `durum` longtext COLLATE utf8_turkish_ci NOT NULL,
  `sira` int(11) DEFAULT NULL,
  `tarih` text COLLATE utf8_turkish_ci,
  `dil` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=5 ;

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

INSERT INTO `slider` (`id`, `adi`, `aciklama`, `resim`, `link`, `hit`, `stitle`, `skey`, `sdesc`, `seodurum`, `durum`, `sira`, `tarih`, `dil`) VALUES
(1, '111111111', '', '372cb95ad7e780537c79536e81befb1a3.png', '22222222222222', '0', '', '', '', '', '1', 0, '27.04.2021 03:31:30', NULL),
(4, 'Konsol', '', '160d57693104dd63a95a3592948788691.png', '', '0', '', '', '', '', '1', 8, '02.02.2024 09:37:52', NULL);

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

--
-- Tablo için tablo yapısı `sss`
--

CREATE TABLE IF NOT EXISTS `sss` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `aciklama` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim` longtext COLLATE utf8_turkish_ci,
  `seo` longtext COLLATE utf8_turkish_ci,
  `hit` longtext COLLATE utf8_turkish_ci,
  `stitle` longtext COLLATE utf8_turkish_ci,
  `skey` longtext COLLATE utf8_turkish_ci,
  `sdesc` longtext COLLATE utf8_turkish_ci,
  `seodurum` longtext COLLATE utf8_turkish_ci,
  `durum` longtext COLLATE utf8_turkish_ci NOT NULL,
  `sira` int(11) DEFAULT NULL,
  `tarih` text COLLATE utf8_turkish_ci,
  `dil` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=4 ;

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

INSERT INTO `sss` (`id`, `adi`, `aciklama`, `resim`, `seo`, `hit`, `stitle`, `skey`, `sdesc`, `seodurum`, `durum`, `sira`, `tarih`, `dil`) VALUES
(2, 'Eticaret nedir ?', '<p>Eticaret genel anlamda dijital dünyanın yeni kapısıdır.<br></p>', 'resimyok.jpg', 'eticaret-nedir-2', '0', '', '', '', '', '1', 0, '01.05.2021 23:48:44', NULL),
(3, 'Eticaret nedir ?', '<p>Eticaret genel anlamda dijital dünyanın yeni kapısıdır.<br></p>', 'resimyok.jpg', 'eticaret-nedir-2', '0', '', '', '', '', '1', 0, '01.05.2021 23:48:44', NULL);

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

--
-- Tablo için tablo yapısı `support`
--

CREATE TABLE IF NOT EXISTS `support` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uye` int(11) NOT NULL,
  `siparisno` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
  `konu` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
  `mesaj` longtext COLLATE utf8_turkish_ci NOT NULL,
  `durum` int(11) DEFAULT NULL,
  `tarih` varchar(255) COLLATE utf8_turkish_ci DEFAULT NULL,
  `mid` longtext COLLATE utf8_turkish_ci,
  `email` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=2 ;

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

INSERT INTO `support` (`id`, `uye`, `siparisno`, `konu`, `mesaj`, `durum`, `tarih`, `mid`, `email`) VALUES
(1, 1, 'Genel Destek Talebi', 'deneme', 'mesaj', 1, '21-06-2022 15:46:57', 'TVRIBS', 'oziyweb@hotmail.com');

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

--
-- Tablo için tablo yapısı `support_reply`
--

CREATE TABLE IF NOT EXISTS `support_reply` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uye` int(11) NOT NULL,
  `destekid` int(11) NOT NULL,
  `siparisno` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
  `konu` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
  `mesaj` longtext COLLATE utf8_turkish_ci NOT NULL,
  `tarih` varchar(255) COLLATE utf8_turkish_ci DEFAULT NULL,
  `mid` longtext COLLATE utf8_turkish_ci,
  `email` longtext COLLATE utf8_turkish_ci,
  `durum` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=4 ;

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

INSERT INTO `support_reply` (`id`, `uye`, `destekid`, `siparisno`, `konu`, `mesaj`, `tarih`, `mid`, `email`, `durum`) VALUES
(1, 1, 1, 'Genel Destek Talebi', 'deneme', 'mesaj', '21-06-2022 15:46:57', 'TVRIBS', 'oziyweb@hotmail.com', NULL),
(2, 0, 1, 'Genel Destek Talebi', 'deneme', 'Selamlar en kısa sürede çözeceğiz efendim ', '21.06.2022 03:52', 'TVRIBS', 'oziyweb@hotmail.com', 2),
(3, 1, 1, 'Genel Destek Talebi', 'deneme', 'ddd', '04.03.2024 03:15', 'TVRIBS', 'oziyweb@hotmail.com', 0);

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

--
-- Tablo için tablo yapısı `system`
--

CREATE TABLE IF NOT EXISTS `system` (
  `id` int(11) NOT NULL,
  `kdvdahil` int(11) DEFAULT NULL,
  `kdv` int(2) DEFAULT NULL,
  `fiyatgizle` int(11) DEFAULT NULL,
  `genelkargo` decimal(10,2) DEFAULT '0.00',
  `ucretsizkargo` decimal(10,2) NOT NULL DEFAULT '0.00',
  `uyeonay` int(11) DEFAULT NULL,
  `rizametni` longtext COLLATE utf8_turkish_ci,
  `sozlesme` longtext COLLATE utf8_turkish_ci NOT NULL,
  `yorumgoster` int(11) DEFAULT NULL,
  `sunucum` longtext COLLATE utf8_turkish_ci,
  `epostam` longtext COLLATE utf8_turkish_ci,
  `sifrem` longtext COLLATE utf8_turkish_ci,
  `typem` longtext COLLATE utf8_turkish_ci,
  `portum` longtext COLLATE utf8_turkish_ci,
  `kvk` longtext COLLATE utf8_turkish_ci,
  `ebultenonay` int(11) NOT NULL,
  `blogonay` longtext COLLATE utf8_turkish_ci,
  `iletisimonay` int(11) DEFAULT NULL,
  `uyeblogonay` int(11) DEFAULT NULL,
  `iade` longtext COLLATE utf8_turkish_ci,
  `telefonal` int(11) DEFAULT NULL,
  `whatsapal` int(11) DEFAULT NULL,
  `sinirsizstok` int(11) DEFAULT NULL,
  `urunonay` int(11) DEFAULT NULL,
  `uyeurunonay` int(11) DEFAULT NULL,
  `urungoster` int(11) DEFAULT NULL,
  `cekgonder` int(11) NOT NULL,
  `misafirok` int(11) NOT NULL,
  `havaleok` int(11) NOT NULL,
  `kapidaok` int(11) NOT NULL,
  `kapitutar` decimal(10,2) NOT NULL DEFAULT '0.00',
  `kartok` int(11) NOT NULL,
  `postip` int(11) NOT NULL,
  `iyziapi` longtext COLLATE utf8_turkish_ci,
  `iyzikey` longtext COLLATE utf8_turkish_ci,
  `paytrid` longtext COLLATE utf8_turkish_ci,
  `paytrkey` longtext COLLATE utf8_turkish_ci,
  `paytrsalt` longtext COLLATE utf8_turkish_ci,
  `paytrtest` int(11) DEFAULT NULL,
  `shopapi` longtext COLLATE utf8_turkish_ci,
  `shopkey` longtext COLLATE utf8_turkish_ci,
  `siparisonay` int(11) NOT NULL DEFAULT '0',
  `adminsiparisonay` int(11) NOT NULL DEFAULT '0',
  `destekonay` int(11) NOT NULL DEFAULT '0',
  `admindestekonay` int(11) NOT NULL DEFAULT '0',
  `sifrehatirlat` int(11) NOT NULL DEFAULT '0',
  `stelefon` longtext COLLATE utf8_turkish_ci,
  `sadi` longtext COLLATE utf8_turkish_ci,
  `ssifre` longtext COLLATE utf8_turkish_ci,
  `sbaslik` longtext COLLATE utf8_turkish_ci,
  `sebultenonay` int(11) DEFAULT NULL,
  `sblogonay` int(11) DEFAULT NULL,
  `suyeblogonay` int(11) DEFAULT NULL,
  `siletisimonay` int(11) DEFAULT NULL,
  `surunonay` int(11) DEFAULT NULL,
  `suyeurunonay` int(11) DEFAULT NULL,
  `scekgonder` int(11) DEFAULT NULL,
  `ssiparisonay` int(11) DEFAULT NULL,
  `sadminsiparisonay` int(11) DEFAULT NULL,
  `sdestekonay` int(11) DEFAULT NULL,
  `sadmindestekonay` int(11) DEFAULT NULL,
  `ssifrehatirlat` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

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

INSERT INTO `system` (`id`, `kdvdahil`, `kdv`, `fiyatgizle`, `genelkargo`, `ucretsizkargo`, `uyeonay`, `rizametni`, `sozlesme`, `yorumgoster`, `sunucum`, `epostam`, `sifrem`, `typem`, `portum`, `kvk`, `ebultenonay`, `blogonay`, `iletisimonay`, `uyeblogonay`, `iade`, `telefonal`, `whatsapal`, `sinirsizstok`, `urunonay`, `uyeurunonay`, `urungoster`, `cekgonder`, `misafirok`, `havaleok`, `kapidaok`, `kapitutar`, `kartok`, `postip`, `iyziapi`, `iyzikey`, `paytrid`, `paytrkey`, `paytrsalt`, `paytrtest`, `shopapi`, `shopkey`, `siparisonay`, `adminsiparisonay`, `destekonay`, `admindestekonay`, `sifrehatirlat`, `stelefon`, `sadi`, `ssifre`, `sbaslik`, `sebultenonay`, `sblogonay`, `suyeblogonay`, `siletisimonay`, `surunonay`, `suyeurunonay`, `scekgonder`, `ssiparisonay`, `sadminsiparisonay`, `sdestekonay`, `sadmindestekonay`, `ssifrehatirlat`) VALUES
(1, 1, 20, 0, '20.00', '20000.00', 3, '<div class="_3jV23XF_s65imNtPqbzbQv"><div>Kişisel verilerin işlenmesine ilişkin rıza metni</div></div>\r\n\r\n\r\n\r\n  \r\n  \r\n  \r\n  \r\n\r\n\r\n\r\n  \r\n    \r\n    <p class="klasik">\r\n      Şirketimiz D-Market Elektronik Hizmetler ve Ticaret A.Ş.(“Hepsiburada”, “Hepsifly”, “Hepsiexpress” D-Market\r\n      Elektronik Hizmetler ve Ticaret A.Ş.’nin markalarıdır.)\r\n      tarafından www.hepsiburada.com, www.hepsifly.com ve www.hepsiexpress.com internet siteleri üzerinden\r\n      yürütülen faaliyetlerle ilgili olarak sizleri bilgilendirmek isteriz. Bir elektronik ticaret platformu olan\r\n      Hepsiburada ve Hepsifly’da alışveriş yapabilmek için üyelik şartı bulunmamaktadır. Dolayısıyla platformumuzda\r\n      üyelik\r\n      bir hizmet koşulu olarak sunulmamaktadır. Üye olmadan alışveriş yapma seçeneğinden farklı olarak üyelik seçeneği;\r\n      alışkanlıkları, alışveriş geçmişi, incelemeleri takip edilip değerlendirilerek kendisine özgü kişiselleştirilmiş\r\n      bir hizmet almak isteyen kullanıcılar için tasarlanmıştır. Kişiye özgü bu avantajların sunulması için ise bazı\r\n      kişisel\r\n      verilerinizin aşağıda detaylandırıldığı şekilde belirtilen amaçlarla işlenmesi, anlaşmalı profesyonel iş\r\n      ortaklarımızla paylaşılması ve teknoloji alanındaki tedarikçilerimiz tarafından sağlanan programlarımıza ve/veya\r\n      sistemlerimize kaydedilmesi gerekebilmektedir. Siz müşterilerimizin memnuniyetinin sağlanması için işlenmesi\r\n      gereken\r\n      kişisel verilerinizden bazıları; Kişisel Verilerin Korunması Kanunu’nda yer alan ve rızaya tabi olmayan veri\r\n      işleme\r\n      şartlarının kapsamında olmaması nedeniyle, ancak siz müşterilerimizin konu özelinde beyan edeceği açık rızaya\r\n      bağlıdır. Rıza vermek istemiyorsanız, “Üye Olmadan Devam Et” seçeneği ile sitemize üye olmadan alışveriş\r\n      yapabilirsiniz.\r\n    </p>', '<p>Mesafeli satış sözleşmesi şartlarını yönetim panelinde sistem modülleri kısmı \r\naltındaki sistemayarları > yasal sözleşmeler kısmında bulup \r\ngüncelleyebilirsin :)</p>', 0, 'mail.oziyweb.com', 'oziyshop@oziyweb.com', 'Tamam106', 'ssl', '465', '<p>kullanım kosulları<br></p>', 0, '0', 0, 0, '<p>İade ve değişim şartlarını yönetim panelinde sistem modülleri kısmı altındaki sistemayarları > yasal sözleşmeler kısmında bulup güncelleyebilirsin :)<br></p>', 0, 1, 0, 0, 0, 0, 0, 1, 1, 1, '5.00', 1, 0, '2', '0', '1', '2', '3', 0, '0', '0', 1, 1, 0, 0, 1, '05424922500', '231123', 'B4HEVGQW', 'OZİYWEB', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);

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

--
-- Tablo için tablo yapısı `temalar`
--

CREATE TABLE IF NOT EXISTS `temalar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci,
  `temaresim` longtext COLLATE utf8_turkish_ci NOT NULL,
  `t1` longtext COLLATE utf8_turkish_ci,
  `t2` longtext COLLATE utf8_turkish_ci,
  `t3` longtext COLLATE utf8_turkish_ci,
  `t4` longtext COLLATE utf8_turkish_ci,
  `t5` longtext COLLATE utf8_turkish_ci,
  `t6` longtext COLLATE utf8_turkish_ci,
  `anabanner` longtext COLLATE utf8_turkish_ci,
  `t7` longtext COLLATE utf8_turkish_ci,
  `t8` longtext COLLATE utf8_turkish_ci,
  `t9` longtext COLLATE utf8_turkish_ci,
  `t10` longtext COLLATE utf8_turkish_ci,
  `t11` longtext COLLATE utf8_turkish_ci,
  `t12` longtext COLLATE utf8_turkish_ci,
  `t13` longtext COLLATE utf8_turkish_ci,
  `t14` longtext COLLATE utf8_turkish_ci,
  `t15` longtext COLLATE utf8_turkish_ci,
  `t16` longtext COLLATE utf8_turkish_ci,
  `t17` longtext COLLATE utf8_turkish_ci,
  `t18` longtext COLLATE utf8_turkish_ci,
  `t19` longtext COLLATE utf8_turkish_ci,
  `t20` longtext COLLATE utf8_turkish_ci,
  `t21` longtext COLLATE utf8_turkish_ci,
  `t22` longtext COLLATE utf8_turkish_ci,
  `t23` longtext COLLATE utf8_turkish_ci,
  `t24` longtext COLLATE utf8_turkish_ci,
  `t25` longtext COLLATE utf8_turkish_ci,
  `t26` longtext COLLATE utf8_turkish_ci,
  `t27` longtext COLLATE utf8_turkish_ci,
  `t28` longtext COLLATE utf8_turkish_ci,
  `t29` longtext COLLATE utf8_turkish_ci,
  `t30` longtext COLLATE utf8_turkish_ci,
  `t31` longtext COLLATE utf8_turkish_ci,
  `t32` longtext COLLATE utf8_turkish_ci,
  `t33` longtext COLLATE utf8_turkish_ci,
  `t34` longtext COLLATE utf8_turkish_ci,
  `t35` longtext COLLATE utf8_turkish_ci,
  `t36` longtext COLLATE utf8_turkish_ci,
  `t37` longtext COLLATE utf8_turkish_ci,
  `t38` longtext COLLATE utf8_turkish_ci,
  `t39` longtext COLLATE utf8_turkish_ci,
  `t40` longtext COLLATE utf8_turkish_ci,
  `t41` longtext COLLATE utf8_turkish_ci,
  `t42` longtext COLLATE utf8_turkish_ci,
  `t43` longtext COLLATE utf8_turkish_ci,
  `t44` longtext COLLATE utf8_turkish_ci,
  `t45` longtext COLLATE utf8_turkish_ci,
  `t46` longtext COLLATE utf8_turkish_ci,
  `t47` longtext COLLATE utf8_turkish_ci,
  `t48` longtext COLLATE utf8_turkish_ci,
  `t49` longtext COLLATE utf8_turkish_ci,
  `t50` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=2 ;

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

INSERT INTO `temalar` (`id`, `adi`, `temaresim`, `t1`, `t2`, `t3`, `t4`, `t5`, `t6`, `anabanner`, `t7`, `t8`, `t9`, `t10`, `t11`, `t12`, `t13`, `t14`, `t15`, `t16`, `t17`, `t18`, `t19`, `t20`, `t21`, `t22`, `t23`, `t24`, `t25`, `t26`, `t27`, `t28`, `t29`, `t30`, `t31`, `t32`, `t33`, `t34`, `t35`, `t36`, `t37`, `t38`, `t39`, `t40`, `t41`, `t42`, `t43`, `t44`, `t45`, `t46`, `t47`, `t48`, `t49`, `t50`) VALUES
(1, 'default', 'default.png', '8d7439aea4f04b2f41caf9b693a7e911g.png', 'bb1ac6c4-d505-4a66-82cc-1b290c881457.jpg', '053cd9b07fb7b4fbb11c1291769684d54.jpg', '0', '0', '0', 'd99cbc5feeec589b2e978e9b0c231e443.png', '0', '#1e33fb', '0fee2b784f722dc2bff7101ea7ec05aer.png', 'www.google.com', '1', 'ada6c0e11c4c3931e25721a015952d8e.jpeg', 'PATRON ÇILDIRDI ! TÜM ÜRÜNLERDE <b>ÜCRETSİZ KARGO İMKANI! </b>ONLİNE ÖDEME İLE<b> ANINDA İNDİRİM !</b><br>', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Teknoloji''yi ucuza almanın en güzel hali. E-TEKNOLOJİ ', NULL, NULL, NULL, '0', NULL, '0', '0', '#1e33fb', '0', NULL, '#343434', NULL, NULL, NULL, NULL, NULL, NULL, 'Bu temada kullanılamaz', 'Kategori Hikaye Resmi', 'Bu temada kullanılamaz', 'display:none');

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

--
-- Tablo için tablo yapısı `tiletisim`
--

CREATE TABLE IF NOT EXISTS `tiletisim` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `epostalar` longtext COLLATE utf8_turkish_ci NOT NULL,
  `konu` longtext COLLATE utf8_turkish_ci,
  `mesaj` longtext COLLATE utf8_turkish_ci,
  `tarih` text COLLATE utf8_turkish_ci,
  `ip` longtext COLLATE utf8_turkish_ci,
  `durum` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=13 ;

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

INSERT INTO `tiletisim` (`id`, `adi`, `epostalar`, `konu`, `mesaj`, `tarih`, `ip`, `durum`) VALUES
(12, 'Test Şablonu', 'djozkanfanclub@hotmail.com', 'OziyShop Hakkında', '								 								 								 									 <body link="#00a5b5" vlink="#00a5b5" alink="#00a5b5">\r\n        <table class=" main contenttable" align="center" style="font-weight: normal;border-collapse: collapse;border: 0;margin-left: auto;margin-right: auto;padding: 0;font-family: Arial, sans-serif;color: #555559;background-color: white;font-size: 16px;line-height: 26px;width: 600px;">\r\n		<tr>\r\n			<td class="border" style="border-collapse: collapse;border: 1px solid #eeeff0;margin: 0;padding: 0;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;">\r\n				<table style="height: 800px !important;font-weight: normal;border-collapse: collapse;border: 0;margin: 0;padding: 0;font-family: Arial, sans-serif;">\r\n					<tr>\r\n						<td colspan="4" valign="top" class="image-section" style="border-collapse: collapse;border: 0;margin: 0;padding: 0;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;background-color: #fff;border-bottom: 4px solid #00a5b5">\r\n							<a href="http://localhost"><img style="height: 30px;line-height: 1;width: 140px;margin: 20px;" class="top-image" src="http://localhost/resimler/siteayarlari/1619309636o.png"  alt="OziySHOP ECommerce Software"></a>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td valign="top" class="side title" style="border-collapse: collapse;border: 0;margin: 0;padding: 20px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;vertical-align: top;background-color: white;border-top: none;">\r\n							<table style="font-weight: normal;border-collapse: collapse;border: 0;margin: 0;padding: 0;font-family: Arial, sans-serif;">\r\n								\r\n							\r\n								<tr>\r\n									<td class="grey-block" style="border-collapse: collapse;border: 0;margin: 0;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;background-color: #fff; text-align:center;">\r\n									<div class="mktEditable" id="cta">\r\n									<img class="top-image" src="http://localhost/mail/webinar-no-text.png" width="560"/><br><br>\r\n										<strong>Örnek Mesaj Alanıdır.</strong>\r\n									\r\n			                           \r\n			                             <a href="" style="color:#ffffff; background-color: #ff8300;  border: 10px solid #ff8300; border-radius: 3px; text-decoration:none;" target="_blank">Örnek Buton</a>\r\n									</div>\r\n									</td>\r\n								</tr>\r\n								\r\n								<tr>\r\n						<td valign="top" align="center" style="border-collapse: collapse;border: 0;margin: 0;padding: 0;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;">\r\n							<table style="font-weight: normal;border-collapse: collapse;border: 0;margin: 0;padding: 0;font-family: Arial, sans-serif;">\r\n								<tr>\r\n									<td align="center" valign="middle" class="social" style="border-collapse: collapse;border: 0;margin: 0;padding: 10px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;text-align: center;">\r\n										<table style="font-weight: normal;border-collapse: collapse;border: 0;margin: 0;padding: 0;font-family: Arial, sans-serif;">\r\n											<tr>\r\n												<td style="border-collapse: collapse;border: 0;margin: 0;padding: 5px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;"><a target="_blank"  href="http://localhost/blog"><img src="http://localhost/mail/rss-teal.png"></a></td>\r\n									<td style="border-collapse: collapse;border: 0;margin: 0;padding: 5px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;"><a target="_blank" href="https://twitter.com/"><img src="http://localhost/mail/twitter-teal.png"></a></td>\r\n									<td style="border-collapse: collapse;border: 0;margin: 0;padding: 5px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;"><a target="_blank" href="https://www.facebook.com/"><img src="http://localhost/mail/facebook-teal.png"></a></td>\r\n									<td style="border-collapse: collapse;border: 0;margin: 0;padding: 5px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;"><a target="_blank" href="https://www.youtube.com/"><img src="http://localhost/mail/youtube-teal.png"></a></td>\r\n									<td style="border-collapse: collapse;border: 0;margin: 0;padding: 5px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;"><a target="_blank" href="https://www.instagram.com/"><img width="20px" height="20px" src="http://localhost/mail/linkedin-teal.png"></a></td>\r\n									<td style="border-collapse: collapse;border: 0;margin: 0;padding: 5px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;"><a target="_blank" href="https://www.google.com/"><img src="http://localhost/mail/google-teal.png"></a></td>\r\n\r\n											</tr>\r\n										</table>\r\n									</td>\r\n								</tr>\r\n							</table>\r\n						</td>\r\n					</tr>\r\n<tr bgcolor="#fff" style="border-top: 4px solid #00a5b5;">\r\n						<td valign="top" style="border-collapse: collapse;border: 0;margin: 0;padding: 0;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 16px;line-height: 26px;background: #fff;text-align: center;">\r\n							<table style="font-weight: normal;border-collapse: collapse;border: 0;margin: 0;padding: 0;font-family: Arial, sans-serif;">\r\n								<tr>\r\n									<td class="inside-footer" align="center" valign="middle" style="border-collapse: collapse;border: 0;margin: 0;padding: 20px;-webkit-text-size-adjust: none;color: #555559;font-family: Arial, sans-serif;font-size: 12px;line-height: 16px;vertical-align: middle;text-align: center;width: 580px;">\r\n<div id="address" class="mktEditable">\r\n										<b>OziySHOP ECommerce Software</b><br>\r\n                            Deneme mah. Deneme Cad. Deneme Apt. Deneme Blok Deneme Kat.1 Daire 6 GAZİANTEP / MERKEZ<br>\r\n							444 44 44 siteniz@siteniz.com<br>\r\n                            <a style="color: #00a5b5;" href="http://localhost/iletisim/">Bize Ulaşın</a>\r\n</div>\r\n									</td>\r\n								</tr>\r\n							</table>\r\n						</td>\r\n					</tr>\r\n							</table>\r\n						</td>\r\n					</tr>\r\n				\r\n												\r\n					\r\n					\r\n				</table>\r\n			</td>\r\n		</tr>\r\n	</table>\r\n  </body>\r\n								 								 								 								 ', '11.05.2021 04:09:39', NULL, 1);

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

--
-- Tablo için tablo yapısı `tumresimler`
--

CREATE TABLE IF NOT EXISTS `tumresimler` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sayfaid` int(11) NOT NULL,
  `sayfaresim` text COLLATE utf8_turkish_ci NOT NULL,
  `alan` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=58 ;

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

INSERT INTO `tumresimler` (`id`, `sayfaid`, `sayfaresim`, `alan`) VALUES
(2, 1, '7068e35f6520a85fdd625335dddfd3822.jpg', 'urunler'),
(3, 11, 'd013dc3ccdda110e372c6675aca8b95a1.jpg', 'urunler'),
(4, 11, '6fcd3bb2d3026c997feb4ffb540baac11.jpg', 'urunler'),
(5, 11, '1f4c7b46324c48fcd888c108abd670eb1.jpg', 'urunler'),
(6, 11, 'ca3030998fbd690581c0868d55a1faed1.jpg', 'urunler'),
(7, 11, 'ff87c0b24c1229b15e1ca1d0d013dd341.jpg', 'urunler'),
(12, 31, 'bfb37ae758d04fa373fa981178efd14ex.jpg', 'urunler'),
(13, 31, '30f02ce2b7f972c101edc51760b6d40bx.jpg', 'urunler'),
(14, 31, '0ba66c99207707517c46367f5cb7a08dx.jpg', 'urunler'),
(15, 31, '527256567ad6236cbaef537c0a53daacx.jpg', 'urunler'),
(16, 31, '73cc099e96afe5d18c2e037fdca36b93x.jpg', 'urunler'),
(17, 32, '3f073bafe6df4f47e8fea8bc085507a3x.jpg', 'urunler'),
(18, 33, '03ec842d261ab4fc97dc04307ed2bb41x.jpg', 'urunler'),
(19, 34, 'cc0db30e3a8e96a7fc608407bbc0eca4x.jpg', 'urunler'),
(20, 34, '73807d40230f3be9e956b24b129e35fax.jpg', 'urunler'),
(21, 35, 'b2edb74a2fd98ace12fa193c73b6233dx.jpg', 'urunler'),
(22, 35, '82d06908cbb1e1b5ca049816f26da64cx.jpg', 'urunler'),
(23, 36, '9c45659cb84c4a5c9226997426116e6ax.jpg', 'urunler'),
(24, 36, '5702c68d5ff5835c72cf0de1fe3e7f7dx.jpg', 'urunler'),
(25, 37, 'bcd0cf5c87401d3749d59134e35771b3x.jpg', 'urunler'),
(26, 37, 'ac08a7ec6905c7d3609d80443ff35845x.jpg', 'urunler'),
(27, 37, '857cbeae3c1cb8f681acac7fbf3da433x.jpg', 'urunler'),
(28, 37, '943abe81c8b2ec011c77df246baa1c9bx.jpg', 'urunler'),
(29, 37, 'f44c376b3d97630feb4ade2b0d1f2f9ax.jpg', 'urunler'),
(30, 38, '7dca5043d10062155df3fbd5ab15f60bx.jpg', 'urunler'),
(31, 38, '13048445786048f57aea296aaf4083e8x.jpg', 'urunler'),
(32, 38, 'c80c056b7489bba79476f2dfe8a907e0x.jpg', 'urunler'),
(33, 38, '6ea33be08cd557ba8cc241f769d29d53x.jpg', 'urunler'),
(34, 39, 'bd091c3ebd45acbcb485d036c62bca60x.jpg', 'urunler'),
(35, 39, '0af67c94591f0ac8116ace64ebbc076ax.jpg', 'urunler'),
(36, 39, 'e7d75ecc2426c1b61c0524c41c1fbcf4x.jpg', 'urunler'),
(37, 39, '28bb9a7712d4bfc558e954117bb04f4bx.jpg', 'urunler'),
(38, 40, 'e04b2a90fc669dcebf9c29dbc9f76e93x.jpg', 'urunler'),
(39, 40, 'fa8fb3e98953a25fddeef4522510ef3ex.jpg', 'urunler'),
(40, 41, 'eb36b0705565efdd7da27d472d8ebdafx.jpg', 'urunler'),
(41, 41, '566b8d4d3a92667e7bc4821cbce95fb6x.jpg', 'urunler'),
(42, 41, 'fd42d660c33f7b5f7cc80c9ff0f7e9d6x.jpg', 'urunler'),
(43, 41, '77e761ef8522720ae550661d086a5f7bx.jpg', 'urunler'),
(44, 41, '99ea037efe842b1388749407309a22c1x.jpg', 'urunler'),
(45, 41, '0769666eba6a5198826f9adc6b5a0862x.jpg', 'urunler'),
(46, 41, 'b6e1b766fb1fce50b98b6f142f0b6b0bx.jpg', 'urunler'),
(47, 41, 'b87aea60f653e10755e96e4d953b5af8x.jpg', 'urunler'),
(48, 41, 'ab4322d9c6e99c9536e023f6edafa766x.jpg', 'urunler'),
(49, 41, 'c03177fb575e61f3fc09e86a1bf45672x.jpg', 'urunler'),
(50, 41, 'a3fb179b8fa3a5214f0b4ee9072b71b4x.jpg', 'urunler'),
(51, 41, '05c33e44bfa2952f2e1ffbf53c7b74b6x.jpg', 'urunler'),
(52, 41, 'f990789f383a123d6281c63b3da02e9dx.jpg', 'urunler'),
(57, 1, '90bba167ad20312e886146378f60df381.jpg', 'sayfalar');

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

--
-- Tablo için tablo yapısı `tumyorumlar`
--

CREATE TABLE IF NOT EXISTS `tumyorumlar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sayfaid` longtext COLLATE utf8_turkish_ci NOT NULL,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `yorum` longtext COLLATE utf8_turkish_ci,
  `tarih` text COLLATE utf8_turkish_ci,
  `dil` longtext COLLATE utf8_turkish_ci,
  `yildiz` longtext COLLATE utf8_turkish_ci,
  `uye` int(11) DEFAULT NULL,
  `cevap` longtext COLLATE utf8_turkish_ci,
  `durum` longtext COLLATE utf8_turkish_ci,
  `konu` longtext COLLATE utf8_turkish_ci,
  `email` longtext COLLATE utf8_turkish_ci,
  `ip` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=12 ;

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

INSERT INTO `tumyorumlar` (`id`, `sayfaid`, `adi`, `yorum`, `tarih`, `dil`, `yildiz`, `uye`, `cevap`, `durum`, `konu`, `email`, `ip`) VALUES
(1, '13', 'M. Özkan Boybeyi', 'Gerçekten çok uyguna topladım ve bayıldım mükemmel ötesi. Evime şıklık ve zarafet kattı', '19.06.2021 19:51:22', NULL, '5', NULL, '<p><b>Teşekkür ederim. Her zaman sizler için çalışıyoruz. </b><br></p>', '1', 'urunler', 'oziyweb@hotmail.com', '127.0.0.1'),
(6, '11', 'M. Özkan', 'Merhaba gerçekten mükemmel bir ürün severek aldık ve kullanıyoruz. Tavsiye ederim şiddetle', '25.01.2024 12:51:36', NULL, '5', NULL, '<p>Teşekkür eder <b>iyi günler dileriz.</b><br></p>', '1', 'urunler', 'oziyweb@hotmail.com', '127.0.0.1'),
(7, '11', 'M. Özkan', 'Merhaba gerçekten mükemmel bir ürün severek aldık ve kullanıyoruz. Tavsiye ederim şiddetle', '25.01.2024 12:51:36', NULL, '5', NULL, '<p>Teşekkür eder <b>iyi günler dileriz.</b><br></p>', '1', 'urunler', 'oziyweb@hotmail.com', '127.0.0.1'),
(8, '1', 'Başlangıç', 'Test deneme amaçlıdır.', '01.03.2024 11:25:41', NULL, NULL, NULL, '', '1', 'blog', 'eticaret@siteniz.com', '127.0.0.1'),
(9, '1', 'İsmail YK', 'Gerçekten bilgilendirici bir yazı olmuş . Teşekkür ederim sayenizde eticaretin genel amaç ve hedeflerini öğrendim.', '01.03.2024 11:26:27', NULL, NULL, NULL, '<p>Rica ederiz. Yazılarımızı takip edip düşüncelerinizi ilettiğiniz için.<br></p>', '1', 'blog', 'djozkanfanclub@hotmail.com', '127.0.0.1'),
(10, '36', 'Mehmet Özkan', 'Gerçekten mükemmel bir ürün. İşlerimi çok kolaylaştırdı birtane daha sipariş verdim.', '03.03.2024 20:38:42', NULL, '5', NULL, '', '1', 'urunler', 'oziyweb@hotmail.com', '127.0.0.1'),
(11, '36', 'Meral AKBUDAK', 'Fiyatı uygun iken aldım ve stokladım. Firmaya ilgisi ve alakası için çok teşekkür ederim.', '03.03.2024 20:39:24', NULL, '5', NULL, '<p>Biz teşekkür ederiz iyi günler dileriz.<br></p>', '1', 'urunler', 'meral@hotmail.com', '127.0.0.1');

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

--
-- Tablo için tablo yapısı `urunler`
--

CREATE TABLE IF NOT EXISTS `urunler` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `urunkodu` longtext COLLATE utf8_turkish_ci NOT NULL,
  `aciklama` longtext COLLATE utf8_turkish_ci NOT NULL,
  `fiyat` decimal(10,2) unsigned NOT NULL,
  `idurum` int(11) NOT NULL,
  `ifiyat` decimal(10,2) unsigned NOT NULL,
  `parabirimi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `dolar` decimal(10,2) NOT NULL,
  `idolar` decimal(10,2) NOT NULL,
  `euro` decimal(10,2) NOT NULL,
  `ieuro` decimal(10,0) NOT NULL,
  `resim` longtext COLLATE utf8_turkish_ci,
  `seo` longtext COLLATE utf8_turkish_ci,
  `kisa` longtext COLLATE utf8_turkish_ci NOT NULL,
  `instagram` longtext COLLATE utf8_turkish_ci NOT NULL,
  `yildiz` longtext COLLATE utf8_turkish_ci NOT NULL,
  `hit` int(11) DEFAULT '0',
  `stitle` longtext COLLATE utf8_turkish_ci,
  `skey` longtext COLLATE utf8_turkish_ci,
  `sdesc` longtext COLLATE utf8_turkish_ci,
  `seodurum` longtext COLLATE utf8_turkish_ci,
  `durum` longtext COLLATE utf8_turkish_ci NOT NULL,
  `sira` int(11) DEFAULT NULL,
  `tarih` text COLLATE utf8_turkish_ci,
  `dil` longtext COLLATE utf8_turkish_ci,
  `stok` int(11) unsigned DEFAULT '0',
  `kategori` longtext COLLATE utf8_turkish_ci,
  `marka` longtext COLLATE utf8_turkish_ci,
  `kdv` longtext COLLATE utf8_turkish_ci,
  `agoster` longtext COLLATE utf8_turkish_ci,
  `yeni` longtext COLLATE utf8_turkish_ci,
  `populer` longtext COLLATE utf8_turkish_ci,
  `coksatan` longtext COLLATE utf8_turkish_ci,
  `firsat` longtext COLLATE utf8_turkish_ci,
  `firsatresim` longtext COLLATE utf8_turkish_ci,
  `firsatsaat` longtext COLLATE utf8_turkish_ci,
  `filtre` longtext COLLATE utf8_turkish_ci,
  `yorum` int(11) DEFAULT '0',
  `havaledurum` int(11) DEFAULT '0',
  `hfiyat` decimal(10,2) unsigned DEFAULT '0.00',
  `ucretsizkargo` int(11) DEFAULT NULL,
  `alode` int(11) DEFAULT NULL,
  `al` int(11) DEFAULT NULL,
  `ode` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=42 ;

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

INSERT INTO `urunler` (`id`, `adi`, `urunkodu`, `aciklama`, `fiyat`, `idurum`, `ifiyat`, `parabirimi`, `dolar`, `idolar`, `euro`, `ieuro`, `resim`, `seo`, `kisa`, `instagram`, `yildiz`, `hit`, `stitle`, `skey`, `sdesc`, `seodurum`, `durum`, `sira`, `tarih`, `dil`, `stok`, `kategori`, `marka`, `kdv`, `agoster`, `yeni`, `populer`, `coksatan`, `firsat`, `firsatresim`, `firsatsaat`, `filtre`, `yorum`, `havaledurum`, `hfiyat`, `ucretsizkargo`, `alode`, `al`, `ode`) VALUES
(31, 'Laptop Apple MacBook Pro M1 16GB 512GB', 'MC88D', '<p>iPad Air with a vibrant 10.9-inch Liquid Retina display. Breakthrough\r\n Apple M1 chip for faster performance, making iPad Air super-powerful \r\nfor creativity and mobile gaming. Get Touch ID, an advanced camera, \r\nlightning-fast 5G2 and Wi-Fi 6, a USB-C port, and support for the Magic \r\nKeyboard and Apple Pencil (2nd generation).</p>\r\n<p> </p>\r\n<p><img src="https://cdn.shopify.com/s/files/1/0687/1177/6541/files/img_detail_0.png?v=1678077641" alt=""></p>\r\n<h3 class="py-30">Work wonders With ease</h3>\r\n<p>There are so many things you can do with iPad and all the amazing \r\napps designed for it. Now App Library automatically organizes those apps\r\n for you. And new widgets let you see information at a glance, right on \r\nyour Home Screen. iPad is the world’s best note-taking device. And now \r\nNotes goes system‑wide with Quick Note, a fast and easy way to get to a \r\nnote no matter what you’re doing. Highlight text in Safari or add a link\r\n from an app, and you’ll see a Quick Note thumbnail next time you visit \r\nthe site, taking you right to what you were viewing before. And if you \r\nmake a Quick Note on your iPad, it will be on your iPhone and Mac.</p>\r\n<p> </p><p></p>', '20000.00', 1, '15000.00', '0', '0.00', '0.00', '0.00', '0', 'products_12_2.jpg', 'laptop-apple-macbook-pro-m1-16gb-512gb', 'Screen Size 10.9 inch\r\nOperating System iOS 14.0\r\nProduct Length 9.74 inch', '0okuAwqTHs0', '5', 173, '', '', '', '', '1', 1, '29.02.2024 15:00:00', NULL, 997, '9,10,11,12,13,14,15,16', '2', '0', '0', '1', '0', '1', '1', NULL, '0', ',,', 0, 1, '9990.00', 1, 1, 3, 1),
(32, 'Laptop Dell Vostro 3400 Intel Core i3 - 256GB', 'DEL', '<p>Ürün açıklamasıdır.<br></p>', '15000.00', 0, '0.00', '0', '0.00', '0.00', '0.00', '0', 'products_14_1_1920x.jpg', 'laptop-dell-vostro-3400-intel-core-i3-256gb-32', '', '', '5', 2, '', '', '', '', '1', 0, '29.02.2024 15:01:49', NULL, 1111, '9,10,11,12,13,14,15,16', '0', '0', '0', '1', '0', '1', '1', NULL, '0', ',,', 0, 0, '0.00', 0, 0, 0, 0),
(33, 'Laptop MateBook 14 Ryzen Edition 256GB', 'MATE12DES', 'Ürün hakkında detaylı bilgi alanıdır.<br>', '25000.00', 0, '0.00', '0', '0.00', '0.00', '0.00', '0', 'products_15_2_1920x.jpg', 'laptop-matebook-14-ryzen-edition-256gb-33', 'Ürün hakkındaki kısa açıklama metnidir.', ' ', '3', 1, '', '', '', '', '1', 0, '29.02.2024 15:03:52', NULL, 11111, '9,10,11,12,13,14,15,16', '2', '0', '0', '0', '0', '0', '0', NULL, '0', ',,', 0, 0, '0.00', 0, 1, 2, 3),
(34, 'Stainless Steel Case with Braided Solo Loop Colorfull', 'WATCH1', '<p>iPad Air with a vibrant 10.9-inch Liquid Retina display. Breakthrough\r\n Apple M1 chip for faster performance, making iPad Air super-powerful \r\nfor creativity and mobile gaming. Get Touch ID, an advanced camera, \r\nlightning-fast 5G2 and Wi-Fi 6, a USB-C port, and support for the Magic \r\nKeyboard and Apple Pencil (2nd generation).</p><p></p>', '600.00', 0, '0.00', '0', '0.00', '0.00', '0.00', '0', 'products_30_1_1920x.jpg', 'stainless-steel-case-with-braided-solo-loop-colorfull', 'Stainless Steel Case with Braided Solo Loop', ' ', '5', 58, '', '', '', '', '1', 0, '29.02.2024 15:05:56', NULL, 999, '9,10,11,12,13,14,15,16', '1', '0', '0', '1', '0', '1', '1', NULL, '0', ',,', 0, 0, '0.00', 1, 0, 0, 0),
(35, 'Stainless Steel Case with Braided Solo Loop Black', 'WATCH1', '<p>iPad Air with a vibrant 10.9-inch Liquid Retina display. Breakthrough\r\n Apple M1 chip for faster performance, making iPad Air super-powerful \r\nfor creativity and mobile gaming. Get Touch ID, an advanced camera, \r\nlightning-fast 5G2 and Wi-Fi 6, a USB-C port, and support for the Magic \r\nKeyboard and Apple Pencil (2nd generation).</p><p></p>', '600.00', 0, '0.00', '0', '0.00', '0.00', '0.00', '0', 'products_31_1_1920x.jpg', 'stainless-steel-case-with-braided-solo-loop-34-35', 'Stainless Steel Case with Braided Solo Loop', ' ', '5', 33, '', '', '', '', '1', 0, '29.02.2024 15:05:56', NULL, 1000, '9,10,11,12,13,14,15,16', '1', '0', '0', '1', '0', '1', '1', NULL, '0', ',,', 0, 0, '0.00', 1, 0, 0, 0),
(36, 'Stainless Steel Case with Braided Solo Loop Blue', 'WATCH1', '<p>iPad Air with a vibrant 10.9-inch Liquid Retina display. Breakthrough\r\n Apple M1 chip for faster performance, making iPad Air super-powerful \r\nfor creativity and mobile gaming. Get Touch ID, an advanced camera, \r\nlightning-fast 5G2 and Wi-Fi 6, a USB-C port, and support for the Magic \r\nKeyboard and Apple Pencil (2nd generation).</p><p></p>', '600.00', 0, '0.00', '0', '0.00', '0.00', '0.00', '0', 'products_33_1_1920x.jpg', 'stainless-steel-case-with-braided-solo-loop-34-35-36', 'Stainless Steel Case with Braided Solo Loop', ' ', '5', 59, '', '', '', '', '1', 0, '29.02.2024 15:05:56', NULL, 1000, '9,10,11,12,13,14,15,16', '1', '0', '0', '1', '0', '1', '1', NULL, '0', ',,', 0, 0, '0.00', 1, 0, 0, 0),
(37, 'Logitech G203 Wired 8000 DPI For PCMac', 'LOGİTECH2', '<p>iPad Air with a vibrant 10.9-inch Liquid Retina display. Breakthrough\r\n Apple M1 chip for faster performance, making iPad Air super-powerful \r\nfor creativity and mobile gaming. Get Touch ID, an advanced camera, \r\nlightning-fast 5G2 and Wi-Fi 6, a USB-C port, and support for the Magic \r\nKeyboard and Apple Pencil (2nd generation).</p><p></p>', '800.00', 0, '0.00', '0', '0.00', '0.00', '0.00', '0', 'products_25_1_1920x.jpg', 'logitech-g203-wired-8000-dpi-for-pcmac', 'Stainless Steel Case with Braided Solo Loop', ' ', '5', 8, '', '', '', '', '1', 0, '29.02.2024 15:05:56', NULL, 1000, '9,10,11,12,13,14,15,16', '1', '0', '0', '1', '0', '1', '1', NULL, '0', ',Mavi,Beyaz,Açık Mavi,Siyah,,', 0, 0, '0.00', 1, 0, 0, 0),
(38, 'TalkWorks iPhone Charger Lightning Cable', 'CABLE', '<p>iPad Air with a vibrant 10.9-inch Liquid Retina display. Breakthrough\r\n Apple M1 chip for faster performance, making iPad Air super-powerful \r\nfor creativity and mobile gaming. Get Touch ID, an advanced camera, \r\nlightning-fast 5G2 and Wi-Fi 6, a USB-C port, and support for the Magic \r\nKeyboard and Apple Pencil (2nd generation).</p>\r\n<p> </p>\r\n<p><img src="https://cdn.shopify.com/s/files/1/0687/1177/6541/files/img_detail_0.png?v=1678077641" alt=""></p>\r\n<h3 class="py-30">Work wonders With ease</h3>\r\n<p>There are so many things you can do with iPad and all the amazing \r\napps designed for it. Now App Library automatically organizes those apps\r\n for you. And new widgets let you see information at a glance, right on \r\nyour Home Screen. iPad is the world’s best note-taking device. And now \r\nNotes goes system‑wide with Quick Note, a fast and easy way to get to a \r\nnote no matter what you’re doing. Highlight text in Safari or add a link\r\n from an app, and you’ll see a Quick Note thumbnail next time you visit \r\nthe site, taking you right to what you were viewing before. And if you \r\nmake a Quick Note on your iPad, it will be on your iPhone and Mac.</p>\r\n<p> </p><p></p>', '1000.00', 1, '500.00', '0', '0.00', '0.00', '0.00', '0', 'products_21_1_1920x.jpg', 'talkworks-iphone-charger-lightning-cable', 'Screen Size 10.9 inch\r\nOperating System iOS 14.0\r\nProduct Length 9.74 inch', ' ', '5', 3, '', '', '', '', '1', 1, '29.02.2024 15:00:00', NULL, 1000, '9,10,11,12,13,14,15,16', '2', '0', '0', '1', '0', '1', '1', NULL, '0', ',,', 0, 0, '0.00', 0, 0, 0, 0),
(39, 'Apple Airpods Pro MWP22A MA Bluetooth 7.1', 'MWP22A', '<p>iPad Air with a vibrant 10.9-inch Liquid Retina display. Breakthrough\r\n Apple M1 chip for faster performance, making iPad Air super-powerful \r\nfor creativity and mobile gaming. Get Touch ID, an advanced camera, \r\nlightning-fast 5G2 and Wi-Fi 6, a USB-C port, and support for the Magic \r\nKeyboard and Apple Pencil (2nd generation).</p>\r\n<p> </p>\r\n<p><img src="https://cdn.shopify.com/s/files/1/0687/1177/6541/files/img_detail_0.png?v=1678077641" alt=""></p>\r\n<h3 class="py-30">Work wonders With ease</h3>\r\n<p>There are so many things you can do with iPad and all the amazing \r\napps designed for it. Now App Library automatically organizes those apps\r\n for you. And new widgets let you see information at a glance, right on \r\nyour Home Screen. iPad is the world’s best note-taking device. And now \r\nNotes goes system‑wide with Quick Note, a fast and easy way to get to a \r\nnote no matter what you’re doing. Highlight text in Safari or add a link\r\n from an app, and you’ll see a Quick Note thumbnail next time you visit \r\nthe site, taking you right to what you were viewing before. And if you \r\nmake a Quick Note on your iPad, it will be on your iPhone and Mac.</p>\r\n<p> </p><p></p>', '1000.00', 1, '0.00', '0', '0.00', '0.00', '0.00', '0', 'products_23_1_1920x.jpg', 'apple-airpods-pro-mwp22a-ma-bluetooth-7-1', 'Screen Size 10.9 inch\r\nOperating System iOS 14.0\r\nProduct Length 9.74 inch', ' ', '5', 4, '', '', '', '', '1', 1, '29.02.2024 15:00:00', NULL, 1000, '9,10,11,12,13,14,15,16', '2', '0', '0', '1', '0', '1', '1', NULL, '0', ',,', 0, 0, '0.00', 0, 0, 0, 0),
(40, ' Zoom Dell Vostro 3888 i9 8GB 512GB - Win10', 'DELL', '<p>iPad Air with a vibrant 10.9-inch Liquid Retina display. Breakthrough\r\n Apple M1 chip for faster performance, making iPad Air super-powerful \r\nfor creativity and mobile gaming. Get Touch ID, an advanced camera, \r\nlightning-fast 5G2 and Wi-Fi 6, a USB-C port, and support for the Magic \r\nKeyboard and Apple Pencil (2nd generation).</p>\r\n<p> </p>\r\n<p><img src="https://cdn.shopify.com/s/files/1/0687/1177/6541/files/img_detail_0.png?v=1678077641" alt=""></p>\r\n<h3 class="py-30">Work wonders With ease</h3>\r\n<p>There are so many things you can do with iPad and all the amazing \r\napps designed for it. Now App Library automatically organizes those apps\r\n for you. And new widgets let you see information at a glance, right on \r\nyour Home Screen. iPad is the world’s best note-taking device. And now \r\nNotes goes system‑wide with Quick Note, a fast and easy way to get to a \r\nnote no matter what you’re doing. Highlight text in Safari or add a link\r\n from an app, and you’ll see a Quick Note thumbnail next time you visit \r\nthe site, taking you right to what you were viewing before. And if you \r\nmake a Quick Note on your iPad, it will be on your iPhone and Mac.</p>\r\n<p> </p><p></p>', '1000.00', 1, '0.00', '0', '0.00', '0.00', '0.00', '0', 'products_13_1_1920x.jpg', 'zoom-dell-vostro-3888-i9-8gb-512gb-win10', 'Screen Size 10.9 inch\r\nOperating System iOS 14.0\r\nProduct Length 9.74 inch', ' ', '5', 2, '', '', '', '', '1', 1, '29.02.2024 15:00:00', NULL, 1000, '9,10,11,12,13,14,15,16', '2', '0', '0', '1', '0', '1', '1', NULL, '0', ',,', 0, 0, '0.00', 0, 0, 0, 0),
(41, 'Apple iPad Pro M1 11-inch 2021 Wi-Fi 128GB', 'DELL', '<p>iPad Air with a vibrant 10.9-inch Liquid Retina display. Breakthrough\r\n Apple M1 chip for faster performance, making iPad Air super-powerful \r\nfor creativity and mobile gaming. Get Touch ID, an advanced camera, \r\nlightning-fast 5G2 and Wi-Fi 6, a USB-C port, and support for the Magic \r\nKeyboard and Apple Pencil (2nd generation).</p>\r\n<p> </p>\r\n<p><img src="https://cdn.shopify.com/s/files/1/0687/1177/6541/files/img_detail_0.png?v=1678077641" alt=""></p>\r\n<h3 class="py-30">Work wonders With ease</h3>\r\n<p>There are so many things you can do with iPad and all the amazing \r\napps designed for it. Now App Library automatically organizes those apps\r\n for you. And new widgets let you see information at a glance, right on \r\nyour Home Screen. iPad is the world’s best note-taking device. And now \r\nNotes goes system‑wide with Quick Note, a fast and easy way to get to a \r\nnote no matter what you’re doing. Highlight text in Safari or add a link\r\n from an app, and you’ll see a Quick Note thumbnail next time you visit \r\nthe site, taking you right to what you were viewing before. And if you \r\nmake a Quick Note on your iPad, it will be on your iPhone and Mac.</p>\r\n<p> </p><p></p>', '1000.00', 1, '200.00', '0', '0.00', '0.00', '0.00', '0', 'products_13_1_1920x.jpg', 'apple-ipad-pro-m1-11-inch-2021-wi-fi-128gb', 'Screen Size 10.9 inch\r\nOperating System iOS 14.0\r\nProduct Length 9.74 inch', ' ', '5', 63, '', '', '', '', '1', 1, '29.02.2024 15:00:00', NULL, 99, '9,10,11,12,13,14,15,16', '2', '0', '0', '1', '0', '1', '1', NULL, '0', 'Siyah,Gold,Rose,6 GB,12 GB,Siyah,Gold,Rose,6 GB,12 GB,,', 0, 0, '0.00', 0, 0, 0, 0);

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

--
-- Tablo için tablo yapısı `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `isim` longtext COLLATE utf8_turkish_ci,
  `email` longtext COLLATE utf8_turkish_ci,
  `sifre` longtext COLLATE utf8_turkish_ci,
  `telefon` longtext COLLATE utf8_turkish_ci,
  `ip` varchar(50) COLLATE utf8_turkish_ci NOT NULL,
  `tarih` longtext COLLATE utf8_turkish_ci,
  `uyetip` int(11) DEFAULT '0',
  `tc` longtext COLLATE utf8_turkish_ci NOT NULL,
  `vergi1` longtext COLLATE utf8_turkish_ci NOT NULL,
  `vergi2` longtext COLLATE utf8_turkish_ci NOT NULL,
  `vergi3` longtext COLLATE utf8_turkish_ci NOT NULL,
  `sozlesme` longtext COLLATE utf8_turkish_ci,
  `onay` int(11) DEFAULT NULL,
  `kod` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=3 ;

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

INSERT INTO `users` (`id`, `isim`, `email`, `sifre`, `telefon`, `ip`, `tarih`, `uyetip`, `tc`, `vergi1`, `vergi2`, `vergi3`, `sozlesme`, `onay`, `kod`) VALUES
(1, 'M. Özkan Boybeyi', 'oziyweb@hotmail.com', 'fe01ce2a7fbac8fafaed7c982a04e229', '05424922500', '', '18.06.2021 23:56:31', 0, '32342423423', '', '', '', '1', 1, NULL),
(2, 'eftal kulaoğlu', 'efdalkulaoglu@gmail.com', '8f06703cd1b86be5b481bad838aa508b', '05385262636', '159.146.14.107', '22.07.2022 16:52:51', 0, '', '', '', '', '1', 0, '24b62fc25ecd842fec41de7de80c5eb5');

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

--
-- Tablo için tablo yapısı `xml`
--

CREATE TABLE IF NOT EXISTS `xml` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `xmlurl` longtext COLLATE utf8_turkish_ci NOT NULL,
  `urunadi` longtext COLLATE utf8_turkish_ci NOT NULL,
  `urunkodu` longtext COLLATE utf8_turkish_ci NOT NULL,
  `stok` longtext COLLATE utf8_turkish_ci NOT NULL,
  `fiyat` longtext COLLATE utf8_turkish_ci NOT NULL,
  `kdv` longtext COLLATE utf8_turkish_ci NOT NULL,
  `aciklama` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resimtip` int(11) DEFAULT '0',
  `anaresim` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim1` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim2` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim3` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim4` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim5` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim6` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim7` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim8` longtext COLLATE utf8_turkish_ci NOT NULL,
  `resim9` longtext COLLATE utf8_turkish_ci NOT NULL,
  `kategori` longtext COLLATE utf8_turkish_ci NOT NULL,
  `kattip` int(11) NOT NULL DEFAULT '0',
  `parcatip` longtext COLLATE utf8_turkish_ci NOT NULL,
  `durum` longtext COLLATE utf8_turkish_ci,
  `yukledurum` int(11) NOT NULL DEFAULT '0',
  `marka` longtext COLLATE utf8_turkish_ci NOT NULL,
  `tarih` longtext COLLATE utf8_turkish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
