Php den hiç anlamıyorum buda sql
# ==========================================================
#
# Database dump of tables in `agligma40729com13437_`
# 2009-02-11
#
# ==========================================================
#
# Table structure for table `alis`
#
DROP TABLE IF EXISTS `alis`;
CREATE TABLE `alis` (
`alisid` int(11) NOT NULL auto_increment,
`bayiid` int(11),
`tutar` float,
`onay` tinyint(4) default 0,
`tarih` datetime,
`onaytarih` date,
`aciklama` text,
`banka` int(11) NOT NULL default 0,
PRIMARY KEY (`alisid`)
) TYPE=MyISAM;
#
# Dumping data in `alis`
#
/*!40000 ALTER TABLE `alis` DISABLE KEYS */;
INSERT INTO `alis`
(`alisid`, `bayiid`, `tutar`, `onay`, `tarih`, `onaytarih`, `aciklama`, `banka`)
VALUES (1, 1, 10, 1, '2008-07-05 15:36:13', '2008-07-05', NULL, 9999),
(2, 67, 10, 1, '2008-07-13 22:28:28', '2008-07-13', NULL, 9999),
(3, 67, 20, 1, '2008-07-14 12:15:24', '2008-07-14', 'deneme', 9999),
(4, 67, 100, 1, '2008-07-14 12:17:33', '2008-07-14', 'deneme', 9999),
(5, 68, 100, 1, '2008-07-14 12:22:23', '2008-07-14', 'DENEME', 9999),
(6, 68, 300, 1, '2008-07-14 13:35:12', NULL, 'hjkhlkj', 2),
(7, 71, 300, 1, '2008-07-18 13:41:33', '2008-07-18', 'KONS?NYE OLARAK YÜKLEND? HAYIRLI OLSUN', 9999),
(8, 70, 300, 1, '2008-07-18 13:42:01', '2008-07-18', 'KONS?NYE OLARAK YÜKLEND? HAYIRLI OLSUN', 9999),
(9, 69, 300, 1, '2008-07-18 13:42:59', '2008-07-18', 'KONS?NYE OLARAK YÜKLEND? HAYIRLI OLSUN', 9999),
(10, 72, 10, 1, '2008-07-18 20:58:10', '2008-07-18', NULL, 9999),
(11, 74, 200, 1, '2008-07-23 11:46:09', '2008-07-23', NULL, 9999),
(12, 75, 10, 1, '2008-07-24 21:44:11', '2008-07-24', NULL, 9999);
/*!40000 ALTER TABLE `alis` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `ayar`
#
DROP TABLE IF EXISTS `ayar`;
CREATE TABLE `ayar` (
`counter` int(11) NOT NULL auto_increment,
`baslik` varchar(10) NOT NULL default '',
`deger` varchar(100),
PRIMARY KEY (`counter`)
) TYPE=InnoDB COMMENT="InnoDB free: 10240 kB";
#
# Dumping data in `ayar`
#
/*!40000 ALTER TABLE `ayar` DISABLE KEYS */;
INSERT INTO `ayar`
(`counter`, `baslik`, `deger`)
VALUES (1, 'aktif', 'evet'),
(2, 'manuel', 'hay?r'),
(3, 'redmesaj', 'Ayl?k Al?m Limiti Dolu'),
(5, 'redmesaj', 'Abone Bulunamad?'),
(9, 'komisyon', 0),
(10, 'fiyatliste', 'hay?r'),
(13, 'hazirkart', 'evet'),
(17, 'hatkontrol', 'evet'),
(18, 'redmesaj', 'Bayi ?ste?i Üzerine ?ptal'),
(19, 'redmesaj', 'Hat Aktif De?il'),
(20, 'redmesaj', 'Kontör Payla? Servisi Kapal?'),
(21, 'redmesaj', '3 Ayl?k Limiti Dolu');
/*!40000 ALTER TABLE `ayar` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `banka`
#
DROP TABLE IF EXISTS `banka`;
CREATE TABLE `banka` (
`id` int(11) NOT NULL auto_increment,
`isim` varchar(30),
`banka` varchar(25),
`sube` varchar(30),
`sahip` varchar(30),
`hesapno` varchar(30),
`aciklama` text,
PRIMARY KEY (`id`)
) TYPE=InnoDB COMMENT="InnoDB free: 10240 kB";
#
# Dumping data in `banka`
#
/*!40000 ALTER TABLE `banka` DISABLE KEYS */;
INSERT INTO `banka`
(`id`, `isim`, `banka`, `sube`, `sahip`, `hesapno`, `aciklama`)
VALUES (2, 'Yeni', NULL, NULL, NULL, NULL, NULL),
(3, 'Yeni', NULL, NULL, NULL, NULL, NULL),
(4, 'Yeni', NULL, NULL, NULL, NULL, NULL);
/*!40000 ALTER TABLE `banka` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `bayi`
#
DROP TABLE IF EXISTS `bayi`;
CREATE TABLE `bayi` (
`bayiid` int(11) NOT NULL auto_increment,
`email` varchar(150),
`sifre` varchar(35),
`isim` varchar(25),
`telefon` varchar(15),
`fatura` text,
`aciklama` text,
`onay` tinyint(4) default 0,
`tarih` date,
`anabayi` int(11) default 0,
`komisyon` float default 0,
`satisfiyat` tinyint(4) NOT NULL default 0,
`y_altbayi` tinyint(4) NOT NULL default 0,
PRIMARY KEY (`bayiid`)
) TYPE=MyISAM;
#
# Dumping data in `bayi`
#
/*!40000 ALTER TABLE `bayi` DISABLE KEYS */;
INSERT INTO `bayi`
(`bayiid`, `email`, `sifre`, `isim`, `telefon`, `fatura`, `aciklama`, `onay`, `tarih`, `anabayi`, `komisyon`, `satisfiyat`, `y_altbayi`)
VALUES (75, 'annen4233', 'a9b0a24d9cfcba294ea2160cba6230a3', 'yaman internet', 02668357882, 'erdek', NULL, 1, '2008-07-24', 0, 0, 1, 0),
(74, 7112025, 'a7a908aaee3b4c1f3f066db05b724f6e', 'emre itisim', 02264612330, NULL, NULL, 1, '2008-07-23', 0, 0, 0, 0),
(73, 'net', 'ad2d543b0c75ed51f047c24e3ff650a5', 'net telekom', 2262454646, 'ç?narc?k', NULL, 1, '2008-07-18', 0, 0, 0, 0),
(71, 'saki', 'cee798b2a24b6bced451cb7231f7f3b8', 'selta?3', 0226, 'yalova', NULL, 1, '2008-07-18', 0, 0, 0, 0),
(72, 'ismail', 'f3b32717d5322d7ba7c505c230785468', 'ismail', 'ismail', 'ismail', NULL, 1, '2008-07-18', 0, 0, 0, 0),
(70, 'veysel', '7d33b80e662fab987bf13e948b610d6b', 'selta?2', '0226 811 0603', 'mimar sinan cad. yalova', NULL, 1, '2008-07-18', 0, 0, 0, 0),
(68, 'demo', 'fe01ce2a7fbac8fafaed7c982a04e229', 'demo', 8111919, NULL, NULL, 1, '2008-07-14', 0, 0, 0, 0),
(69, 'fatih', '62360790fa10d15b400446a408a24192', 'selta?1', '0266 8110677', 'yalova', NULL, 1, '2008-07-18', 0, 0, 0, 0);
/*!40000 ALTER TABLE `bayi` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `hatkontrol`
#
DROP TABLE IF EXISTS `hatkontrol`;
CREATE TABLE `hatkontrol` (
`id` int(11) NOT NULL auto_increment,
`ozelid` varchar(100),
`operator` varchar(100),
`onek` varchar(10),
`tel` varchar(100),
`onay` tinyint(4),
`durum` tinyint(4),
`konbara` int(11),
`kullanici` varchar(100),
`sifre` varchar(100),
`kontor` int(11),
`trans` int(11),
`transk` int(11),
`aktivasyon` date,
`yetkili` varchar(100),
PRIMARY KEY (`id`)
) TYPE=InnoDB COMMENT="InnoDB free: 10240 kB";
#
# Dumping data in `hatkontrol`
#
/*!40000 ALTER TABLE `hatkontrol` DISABLE KEYS */;
INSERT INTO `hatkontrol`
(`id`, `ozelid`, `operator`, `onek`, `tel`, `onay`, `durum`, `konbara`, `kullanici`, `sifre`, `kontor`, `trans`, `transk`, `aktivasyon`, `yetkili`)
VALUES (2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2008-07-11', NULL),
(3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2008-07-11', NULL),
(4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2008-07-18', NULL);
/*!40000 ALTER TABLE `hatkontrol` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `hazirkart`
#
DROP TABLE IF EXISTS `hazirkart`;
CREATE TABLE `hazirkart` (
`id` int(11) NOT NULL auto_increment,
`hazirkart` varchar(255),
`paket` int(4),
`operator` varchar(255),
`onay` tinyint(4),
`durum` tinyint(4),
PRIMARY KEY (`id`)
) TYPE=InnoDB COMMENT="InnoDB free: 10240 kB";
#
# Dumping data in `hazirkart`
#
/*!40000 ALTER TABLE `hazirkart` DISABLE KEYS */;
INSERT INTO `hazirkart`
(`id`, `hazirkart`, `paket`, `operator`, `onay`, `durum`)
VALUES (11, 'MjM0NTY3ODkyMzQ1Njc4', 100, 'turkcell_tam', 1, 1),
(12, 'NzY2Nzg2Nzg5MjM0NTY3', 100, 'avea_tam', 1, 1),
(13, 'NTY3NDg2Nzg5MjM2Nzg0', 100, 'avea_tam', 1, 0);
/*!40000 ALTER TABLE `hazirkart` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `mesaj`
#
DROP TABLE IF EXISTS `mesaj`;
CREATE TABLE `mesaj` (
`id` int(11) NOT NULL auto_increment,
`gonderen` int(11),
`alici` int(11),
`mesaj` text,
`okundu` tinyint(4) default 0,
`tarih` datetime,
PRIMARY KEY (`id`)
) TYPE=InnoDB COMMENT="InnoDB free: 10240 kB";
#
# Table structure for table `operator`
#
DROP TABLE IF EXISTS `operator`;
CREATE TABLE `operator` (
`operator` varchar(22) NOT NULL default '',
`onek` varchar(50),
`aktif` tinyint(4) default 1,
`hazirkart` tinyint(4) default 0,
`birlesik` tinyint(4) NOT NULL default 0,
`komisyon` float NOT NULL default 0,
PRIMARY KEY (`operator`)
) TYPE=MyISAM;
#
# Dumping data in `operator`
#
/*!40000 ALTER TABLE `operator` DISABLE KEYS */;
INSERT INTO `operator`
(`operator`, `onek`, `aktif`, `hazirkart`, `birlesik`, `komisyon`)
VALUES ('avea', '505,506,507,508,551,552,553,554,555,556,557,558', 1, 0, 0, 0),
('turkcell', '534,535,536,537,538,539', 1, 0, 0, 0),
('vodafone', '541,542,543,544,545,546,547,548,549', 1, 0, 0, 0),
('avea_kart', '501,504,505,506,554,555,556', 0, 0, 0, 0),
('turkcell_kart', '534,535,536,537,538,539', 0, 0, 0, 0),
('vodafone_kart', '541,542,543,544,545,546,547,548,549', 0, 0, 0, 0),
('avea_tam', '505,506,507,508,551,552,553,554,555,556,557,558', 1, 0, 0, 0),
('turkcell_tam', '534,535,536,537,538,539', 1, 0, 0, 0),
('vodafone_tam', '541,542,543,544,545,546,547,548,549', 1, 0, 0, 0);
/*!40000 ALTER TABLE `operator` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `paket`
#
DROP TABLE IF EXISTS `paket`;
CREATE TABLE `paket` (
`paketid` int(11) NOT NULL auto_increment,
`operator` varchar(22),
`kontor` int(11),
`fiyat` float,
`tavsiyefiyat` float NOT NULL default 0,
PRIMARY KEY (`paketid`)
) TYPE=InnoDB COMMENT="InnoDB free: 10240 kB";
#
# Dumping data in `paket`
#
/*!40000 ALTER TABLE `paket` DISABLE KEYS */;
INSERT INTO `paket`
(`paketid`, `operator`, `kontor`, `fiyat`, `tavsiyefiyat`)
VALUES (3, 'avea', 25, 4.12, 5.25),
(4, 'avea', 20, 3.3, 4.25),
(5, 'avea', 15, 2.8, 3.5),
(6, 'turkcell', 15, 2.5, 4),
(7, 'turkcell', 10, 1.85, 3),
(8, 'vodafone', 20, 3.5, 4.5),
(9, 'vodafone', 25, 4.35, 5.25),
(10, 'avea', 30, 4.9, 6),
(11, 'avea', 40, 6.55, 7.5),
(12, 'avea', 35, 5.75, 6.75),
(13, 'avea', 45, 7.4, 8.5),
(14, 'avea', 50, 8.5, 9.5),
(15, 'turkcell', 20, 3.35, 4.5),
(16, 'turkcell', 25, 4.2, 5),
(17, 'turkcell', 30, 5.05, 6),
(18, 'turkcell', 35, 5.9, 7),
(19, 'turkcell', 40, 6.75, 7.5),
(20, 'turkcell', 50, 8.2, 9.5),
(21, 'turkcell', 60, 10.15, 11.5),
(22, 'turkcell', 70, 11.85, 13),
(23, 'vodafone', 30, 5.25, 6.25),
(24, 'vodafone', 35, 6.12, 7.25),
(25, 'vodafone', 40, 7, 8.25),
(26, 'vodafone', 45, 7.85, 9),
(27, 'vodafone', 50, 8.7, 9.75),
(28, 'vodafone', 55, 9.6, 11),
(29, 'vodafone', 60, 10.45, 12),
(30, 'vodafone', 65, 11.37, 13),
(31, 'vodafone', 70, 12.2, 14),
(32, 'avea_tam', 50, 8.85, 9.5),
(33, 'avea_tam', 100, 15.95, 17),
(34, 'avea_tam', 150, 22.2, 24),
(35, 'avea_tam', 250, 36.9, 38.5),
(36, 'avea_tam', 500, 69, 72),
(37, 'avea_tam', 1000, 119, 127),
(38, 'turkcell_tam', 100, 17, 17.5),
(39, 'turkcell_tam', 250, 38.75, 39.5),
(40, 'turkcell_tam', 1000, 119, 127),
(41, 'turkcell_tam', 500, 73, 75),
(42, 'vodafone_tam', 100, 17, 17.5),
(43, 'vodafone_tam', 250, 35.2, 36.5),
(44, 'vodafone_tam', 500, 69.8, 73),
(45, 'TURCELL_HAZIRKART', 100, 17, 18);
/*!40000 ALTER TABLE `paket` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `paket_bayi`
#
DROP TABLE IF EXISTS `paket_bayi`;
CREATE TABLE `paket_bayi` (
`id` int(11) NOT NULL auto_increment,
`paketid` int(11),
`bayi` int(11),
`fiyat` float,
PRIMARY KEY (`id`)
) TYPE=InnoDB COMMENT="InnoDB free: 10240 kB";
#
# Dumping data in `paket_bayi`
#
/*!40000 ALTER TABLE `paket_bayi` DISABLE KEYS */;
INSERT INTO `paket_bayi`
(`id`, `paketid`, `bayi`, `fiyat`)
VALUES (4, 5, 72, 2),
(5, 4, 72, 3),
(6, 3, 72, 4);
/*!40000 ALTER TABLE `paket_bayi` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `satis`
#
DROP TABLE IF EXISTS `satis`;
CREATE TABLE `satis` (
`satisid` int(11) NOT NULL auto_increment,
`tarih` datetime,
`bayiid` int(11),
`tur` varchar(15),
`telefon` varchar(15),
`operator` varchar(22),
`kontor` int(11),
`tutar` float,
`onay` tinyint(4) default 0,
`onaytarih` datetime,
`mesaj` text,
`ip` varchar(20),
`user` varchar(20),
`komisyon` float,
`komisyonbayi` int(11),
`hatid` int(11) NOT NULL default 0,
PRIMARY KEY (`satisid`)
) TYPE=MyISAM;
#
# Dumping data in `satis`
#
/*!40000 ALTER TABLE `satis` DISABLE KEYS */;
INSERT INTO `satis`
(`satisid`, `tarih`, `bayiid`, `tur`, `telefon`, `operator`, `kontor`, `tutar`, `onay`, `onaytarih`, `mesaj`, `ip`, `user`, `komisyon`, `komisyonbayi`, `hatid`)
VALUES (1, '2008-07-05 15:44:04', 1, 'Parca Kontor', 5346425949, 'turkcell', 15, 3.25, 2, '2008-07-05 15:45:48', 'Kontör Payla? Servisi Kapal?', '85.97.184.206', NULL, 0, 0, 0),
(2, '2008-07-05 15:45:11', 1, 'Parca Kontor', 5346425949, 'turkcell', 15, 3.25, 2, '2008-07-05 15:51:57', 'Hat Aktif De?il', '85.97.184.206', NULL, 0, 0, 0),
(3, '2008-07-09 16:13:21', 1, 'Parca Kontor', 5382343800, 'turkcell', 50, 8.5, 2, '2008-07-10 10:00:45', 'Hat Aktif De?il', '78.179.40.88', NULL, 0, 0, 0),
(4, '2008-07-10 22:08:00', 1, 'Parca Kontor', 5345995454, 'turkcell', 10, 2.5, 2, '2008-07-10 22:10:36', 'Bayi ?ste?i Üzerine ?ptal', '85.97.184.206', NULL, 0, 0, 0),
(5, '2008-07-10 22:08:46', 1, 'Parca Kontor', 5345995454, 'turkcell', 10, 2.5, 2, '2008-07-10 22:10:44', 'Ayl?k Al?m Limiti Dolu', '85.97.184.206', NULL, 0, 0, 0),
(6, '2008-07-10 22:09:41', 1, 'Parca Kontor', 5345995454, 'turkcell', 10, 2.5, 2, '2008-07-10 22:10:39', 'Hat Aktif De?il', '85.97.184.206', NULL, 0, 0, 0),
(7, '2008-07-10 22:09:59', 1, 'Parca Kontor', 5345995454, 'turkcell', 10, 2.5, 2, '2008-07-10 22:37:07', 'Kontör Payla? Servisi Kapal?', '85.97.184.206', NULL, 0, 0, 0),
(8, '2008-07-11 22:43:09', 1, 'Parca Kontor', 5346425949, 'turkcell', 10, 1.85, 2, '2008-07-12 12:45:45', '3 Ayl?k Limiti Dolu', '85.97.184.206', NULL, 0, 0, 0),
(9, '2008-07-13 22:30:17', 67, 'Parca Kontor', 5443689725, 'vodafone', 20, 3.5, 2, '2008-07-13 22:31:02', 'Ayl?k Al?m Limiti Dolu', '78.172.94.77', NULL, 0, 0, 0),
(10, '2008-07-13 22:30:26', 67, 'Parca Kontor', 5443689725, 'vodafone', 25, 4.35, 2, '2008-07-13 22:31:06', 'Kontör Payla? Servisi Kapal?', '78.172.94.77', NULL, 0, 0, 0),
(11, '2008-07-14 12:15:47', 67, 'Parca Kontor', NULL, 'TURCELL_HAZIRKART', 100, 17, 1, '2008-07-14 12:16:31', 123, '78.179.40.88', NULL, 0, 0, 0),
(12, '2008-07-14 12:25:03', 68, 'Parca Kontor', NULL, 'TURKCELL_HAZIRKART', 100, 16, 2, '2008-07-14 12:32:22', 'Bayi ?ste?i Üzerine ?ptal', '78.179.40.88', NULL, 0, 0, 0),
(13, '2008-07-14 12:32:43', 68, 'Parca Kontor', NULL, 'TURKCELL_HAZIRKART', 100, 16, 1, '2008-07-14 12:32:43', 33453453453, '78.179.40.88', NULL, 0, 0, 0),
(14, '2008-07-14 19:12:54', 68, 'Parca Kontor', NULL, 'TURKCELL_HAZIRKART', 100, 16, 1, '2008-07-14 19:13:35', 1211111112121, '78.172.88.156', NULL, 0, 0, 0),
(15, '2008-07-14 23:25:39', 68, 'Parca Kontor', 5455443428, 'vodafone', 45, 7.85, 2, '2008-07-14 23:26:49', 'Hat Aktif De?il', '78.172.88.156', NULL, 0, 0, 0),
(16, '2008-07-17 01:19:28', 68, 'Parca Kontor', 5356425949, 'turkcell', 10, 1.85, 2, '2008-07-17 01:21:36', 'Hat Aktif De?il', '78.172.86.185', NULL, 0, 0, 0),
(17, '2008-07-17 01:19:43', 68, 'Parca Kontor', 5356425949, 'turkcell_tam', 100, 17, 2, '2008-07-17 01:21:43', '3 Ayl?k Limiti Dolu', '78.172.86.185', NULL, 0, 0, 0),
(18, '2008-07-17 01:20:04', 68, 'Parca Kontor', 5425186788, 'vodafone', 20, 3.5, 2, '2008-07-17 01:21:51', 'Abone Bulunamad?', '78.172.86.185', NULL, 0, 0, 0),
(19, '2008-07-17 01:20:22', 68, 'Parca Kontor', 5056362003, 'avea', 5, 1.5, 2, '2008-07-17 01:21:56', 'Kontör Payla? Servisi Kapal?', '78.172.86.185', NULL, 0, 0, 0),
(20, '2008-07-17 15:46:16', 68, 'Parca Kontor', 5347767424, 'turkcell', 25, 4.2, 2, '2008-07-17 22:54:19', 'Kontör Payla? Servisi Kapal?', '85.97.184.206', NULL, 0, 0, 0),
(21, '2008-07-18 15:49:20', 68, 'Parca Kontor', 5356425949, 'turkcell', 10, 1.85, 2, '2008-07-18 15:49:38', 'Hat Aktif De?il', '85.97.184.206', 'metin', 0, 0, 0),
(22, '2008-07-18 16:57:07', 68, 'Parca Kontor', 5354567890, 'turkcell_tam', 100, 17, 2, '2008-07-18 17:12:11', 'Bayi ?ste?i Üzerine ?ptal', '78.179.33.5', NULL, 0, 0, 0),
(23, '2008-07-18 17:05:29', 68, 'Parca Kontor', NULL, 'avea_tam', 100, 15.95, 1, '2008-07-18 17:05:29', 766786789234567, '78.179.33.5', NULL, 0, 0, 0),
(24, '2008-07-18 17:05:37', 68, 'Parca Kontor', NULL, 'turkcell_tam', 100, 17, 1, '2008-07-18 17:05:37', 234567892345678, '78.179.33.5', NULL, 0, 0, 0),
(25, '2008-07-18 17:05:47', 68, 'Parca Kontor', NULL, 'vodafone_tam', 100, 17, 2, '2008-07-18 17:12:14', 'Bayi ?ste?i Üzerine ?ptal', '78.179.33.5', NULL, 0, 0, 0),
(26, '2008-07-18 17:09:59', 68, 'Parca Kontor', 5072345678, 'avea', 30, 4.9, 2, '2008-07-18 17:12:18', 'Bayi ?ste?i Üzerine ?ptal', '78.179.33.5', NULL, 0, 0, 0),
(27, '2008-07-18 21:04:26', 72, 'Parca Kontor', 5385554433, 'turkcell', 10, 1.85, 2, '2008-07-18 21:04:57', 'Kontör Payla? Servisi Kapal?', '85.97.184.206', NULL, 0, 0, 0),
(28, '2008-07-22 17:06:32', 70, 'Parca Kontor', NULL, 'turkcell_tam', 1000, 119, 2, '2008-07-22 17:08:04', 'Abone Bulunamad?', '78.172.83.195', NULL, 0, 0, 0),
(29, '2008-07-23 19:37:07', 68, 'Parca Kontor', 5554055525, 'avea', 15, 2.8, 1, '2008-07-27 15:01:01', NULL, '78.172.93.158', NULL, 0, 0, 2147483647),
(30, '2008-07-24 21:46:59', 75, 'Parca Kontor', 5366152242, 'turkcell', 10, 1.85, 2, '2008-07-24 21:47:17', 'Ayl?k Al?m Limiti Dolu', '88.241.227.111', NULL, 0, 0, 0),
(31, '2008-07-27 12:18:33', 68, 'Parca Kontor', 5356425949, 'turkcell', 10, 1.85, 0, NULL, NULL, '85.108.182.162', NULL, 0, 0, 0);
/*!40000 ALTER TABLE `satis` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `simplenews_articles`
#
DROP TABLE IF EXISTS `simplenews_articles`;
CREATE TABLE `simplenews_articles` (
`news_id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`snippet` text NOT NULL default '',
`article` text NOT NULL default '',
`topic` int(11) NOT NULL default 0,
`poster` varchar(255) NOT NULL default '',
`date` varchar(255) NOT NULL default '',
`sticky` char(3) NOT NULL default 'on',
PRIMARY KEY (`news_id`)
) TYPE=MyISAM;
#
# Dumping data in `simplenews_articles`
#
/*!40000 ALTER TABLE `simplenews_articles` DISABLE KEYS */;
INSERT INTO `simplenews_articles`
(`news_id`, `title`, `snippet`, `article`, `topic`, `poster`, `date`, `sticky`)
VALUES (25, 'Hakk?m?zda', 'Bu bölüme içerik yönetim sisteminden yaz? ekleyebilirsiniz.\r\n', NULL, 21, 'admin', NULL, 'on'),
(26, '?leti?im', '<style type=\"text/css\">\r\n<!--\r\n.style7 {color: #0000CC;\r\n font-weight: bold;\r\n}\r\n-->\r\n</style>\r\n<p>Bizimle ileti?im kurabilmek için a?a??daki mail adreslerini kullanabilirsiniz</p>\r\n<table width=\"228\" border=\"0\" align=\"left\">\r\n <tr>\r\n <td width=\"47\" height=\"49\"><div align=\"left\"><img src=\"images/msn.gif\" width=\"48\" height=\"36\" /></div></td>\r\n <td width=\"171\"><div align=\"center\" class=\"style7\">\r\n <div align=\"left\"><a href=\"msnim:add?contact=info@jokerkontor.com\">info@jokerkontor.com</a></div>\r\n </div></td>\r\n </tr>\r\n</table>\r\n<p align=\"left\"> </p>\r\n<p align=\"left\"> </p>\r\n<div align=\"left\"></div>\r\n<div align=\"left\"></div>\r\n<table width=\"228\" border=\"0\" align=\"left\">\r\n <tr>\r\n <td width=\"47\" height=\"49\"><div align=\"left\"><img src=\"images/msn.gif\" width=\"48\" height=\"36\" /></div></td>\r\n <td width=\"171\"><div align=\"center\" class=\"style7\">\r\n <div align=\"left\"><a href=\"msnim:add?contact=destek@jokerkontor.com\">destek@jokerkontor.com</a></div>\r\n </div></td>\r\n </tr>\r\n</table>\r\n<p align=\"left\"> </p>\r\n', NULL, 6, 'admin', NULL, 'on'),
(27, 'Bayii Yard?m', 'Çok yak?nda yard?m konular?m?z burada olacakt?r', NULL, 7, 'admin', NULL, 'on'),
(28, 'Kontör Yükleme', 'Bu bölüme içerik yönetim sisteminden yaz? ekleyebilirsiniz.\r\n', NULL, 8, 'admin', NULL, 'on'),
(29, 'Bekleyen Yüklemeler', 'Bu bölüme içerik yönetim sisteminden yaz? ekleyebilirsiniz.', NULL, 9, NULL, NULL, 'on'),
(30, 'Onaylanan Yüklemeler', 'Bu bölüme içerik yönetim sisteminden yaz? ekleyebilirsiniz.', NULL, 10, NULL, NULL, 'on'),
(31, 'Sipari?', 'Bu bölüme içerik yönetim sisteminden yaz? ekleyebilirsiniz.\r\n', NULL, 11, 'admin', NULL, 'on'),
(32, 'Bekleyen Sipari?ler', 'Bu bölüme içerik yönetim sisteminden yaz? ekleyebilirsiniz.', NULL, 12, 'admin', NULL, 'on'),
(33, 'Onaylanan Sipari?ler', 'Bu bölüme içerik yönetim sisteminden yaz? ekleyebilirsiniz.\r\n', NULL, 13, 'admin', NULL, 'on'),
(34, 'JOKERKONTOR.COM', 'Türkiye\'nin her bölgesinde bayilikler verilecektir.</span><br>\r\n <br>\r\n Bayimiz olmak için herhangi bir evrak gerektirmeyen <a href=\"bayii_basvur.php?phpMyAdmin=7db1e2d73c7bec60099393211b50eb1a\">bayi ba?vuru</a> formunu doldurup \"<strong>Kay?t</strong>\" Tu?una basman?z yeterlidir. <br>\r\n Ba?vurunuz sistem yöneticilerimiz taraf?ndan incelenip hemen de?erlendirilir, ve bayi panelinizden size bildirilir.', NULL, 1, 'admin', 'July 11, 2008, 12:26 pm', 'on'),
(35, 'Ho?geldiniz', 'Türkiye\'nin her bölgesinde bayilikler verilecektir.', NULL, 2, 'admin', 'July 11, 2008, 12:29 pm', 'on'),
(36, 'Haberler', '<TABLE borderColor=\"#111111\" cellSpacing=\"0\" cellPadding=\"0\" width=\"100%\" border=\"0\">\r\n <TBODY>\r\n <TR>\r\n <TD><ul>\r\n <li>Lütfen bayi kodu, kullan?c? ad? ve parolan?z? gizli tutun. Bu bilgileri üçüncü ?ah?slarla payla?may?n.</li>\r\n <li>E-posta yoluyla hiç bir ?ekilde ?ifre i?lemleri yapt?r?lmamaktad?r.</li>\r\n <li>E-posta yoluyla hiç bir ?ekilde bayilerin ki?isel bilgileri istenmemektedir.</li>\r\n <li>Virüsler ve benzeri programlara kar?? bilgisayar?n?za antivirus program? yükleyin.<br>\r\n </li>\r\n <li>Bayimiz olmak için herhangi bir evrak gerektirmeyen <a href=\"http://www.jokerkontor.com/bayii_basvur.php\">bayi ba?vuru</a> formunu doldurup \"<strong>Kay?t</strong>\" Tu?una basman?z yeterlidir. </li>\r\n <li>Ba?vurunuz sistem yöneticilerimiz taraf?ndan incelenip hemen de?erlendirilir, ve bayi panelinizden size bildirilir.</li>\r\n </ul></TD>\r\n </TR>\r\n </TBODY>\r\n</TABLE>\r\n<p> </p>\r\n', NULL, 4, 'admin', 'July 11, 2008, 12:31 pm', 'on'),
(37, 'Bayi ba?vurusu', '<p align=\"justify\">Parça kontör bayili?imiz tamamen <strong>ücretsizdir</strong>. Parça kontör sistemi; herhangi bir operatöre istedi?iniz miktarda kontör yüklemek için kullan?*** sistemdir. Sistemimiz tamamen online olarak çal??maktad?r. Sistemde mü?terimiz oldu?unuz andan itibaren Turkcell, Vodafone ve Avea hatlar?na belirtti?iniz miktarlar do?rultusunda kontör yollayabilirsiniz. Sistemden kontör iste?inde bulunduktan sonra 1-5 dakika aras?nda kontörünüz yüklenir.<BR>\r\n <strong></strong> Sistemimizden parça kontör haricinde istedi?iniz numaraya an?nda 100-250-500 ?eklinde tüm kontör gönderimi de yapabilirsiniz.<BR>\r\n <BR>\r\n Sizde bu sistemin ayr?cal?klar?ndan yararlanmak istiyorsan?z yukar?daki bayi ba?vuru formunu doldurarak bize ula?abilirsiniz.</p>\r\n', NULL, 3, 'admin', 'July 12, 2008, 6:54 pm', 'on');
/*!40000 ALTER TABLE `simplenews_articles` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `simplenews_comments`
#
DROP TABLE IF EXISTS `simplenews_comments`;
CREATE TABLE `simplenews_comments` (
`comment_id` char(1) NOT NULL default ''
) TYPE=MyISAM;
#
# Table structure for table `simplenews_settings`
#
DROP TABLE IF EXISTS `simplenews_settings`;
CREATE TABLE `simplenews_settings` (
`postlimit` int(3) NOT NULL default 0,
`wordfilter` char(2),
`com_size` int(11) NOT NULL default 0,
`version` varchar(25) NOT NULL default '',
`allow_comments` char(2),
`allow_email` char(2),
`theme` varchar(255) NOT NULL default ''
) TYPE=MyISAM;
#
# Dumping data in `simplenews_settings`
#
/*!40000 ALTER TABLE `simplenews_settings` DISABLE KEYS */;
INSERT INTO `simplenews_settings`
(`postlimit`, `wordfilter`, `com_size`, `version`, `allow_comments`, `allow_email`, `theme`)
VALUES (6, NULL, 200, '1.0.0', NULL, NULL, 'SimpleNews');
/*!40000 ALTER TABLE `simplenews_settings` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `simplenews_topics`
#
DROP TABLE IF EXISTS `simplenews_topics`;
CREATE TABLE `simplenews_topics` (
`topic_id` int(11) NOT NULL auto_increment,
`topic` varchar(25) NOT NULL default '',
`icon` varchar(25) NOT NULL default '',
PRIMARY KEY (`topic_id`)
) TYPE=MyISAM;
#
# Dumping data in `simplenews_topics`
#
/*!40000 ALTER TABLE `simplenews_topics` DISABLE KEYS */;
INSERT INTO `simplenews_topics`
(`topic_id`, `topic`, `icon`)
VALUES (1, 'Anasayfa', 'news.png'),
(2, 'Bayii Anasayfa', 'news.png'),
(3, 'Bayii Ba?vuru', 'news.png'),
(4, 'Haberler', 'news.png'),
(6, '?leti?im', 'news.png'),
(7, 'Bayii Yard?m', 'news.png'),
(8, 'Bayii Kontör Yükle', 'news.png'),
(10, 'Onaylanan Yüklemeler', 'news.png'),
(11, 'Sipari?', 'news.png'),
(12, 'Bekleyen Sipari?ler', 'news.png'),
(13, 'Onaylanan Sipari?ler', 'news.png'),
(14, 'Bilgilerim', 'news.png'),
(21, 'Hakk?m?zda', 'news.png');
/*!40000 ALTER TABLE `simplenews_topics` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `simplenews_users`
#
DROP TABLE IF EXISTS `simplenews_users`;
CREATE TABLE `simplenews_users` (
`user_id` int(11) NOT NULL auto_increment,
`username` varchar(255) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`userlevel` int(1) NOT NULL default 0,
`reg_date` varchar(255) NOT NULL default '',
`login_time` varchar(255) NOT NULL default '',
PRIMARY KEY (`user_id`)
) TYPE=MyISAM;
#
# Dumping data in `simplenews_users`
#
/*!40000 ALTER TABLE `simplenews_users` DISABLE KEYS */;
INSERT INTO `simplenews_users`
(`user_id`, `username`, `password`, `email`, `userlevel`, `reg_date`, `login_time`)
VALUES (1, 'admin', 'f6d4649214540112cb19a3450b2accc9', 'c@d.com', 1, 'June 14, 2007, 4:04 pm', 'January 25, 2008, 12:37 pm');
/*!40000 ALTER TABLE `simplenews_users` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `user`
#
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`user` varchar(20) NOT NULL default '',
`sifre` varchar(35),
`operator` varchar(22),
`sonip` varchar(20),
`sontarih` datetime,
PRIMARY KEY (`user`)
) TYPE=InnoDB COMMENT="InnoDB free: 10240 kB";
#
# Dumping data in `user`
#
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user`
(`user`, `sifre`, `operator`, `sonip`, `sontarih`)
VALUES ('MET?N', 'e10adc3949ba59abbe56e057f20f883e', 'TURKCELL', NULL, NULL);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
# --------------------------------------------------------
#
# Table structure for table `yardim`
#
DROP TABLE IF EXISTS `yardim`;
CREATE TABLE `yardim` (
`id` int(11) NOT NULL default 0,
`baslik` varchar(60),
`metin` text,
PRIMARY KEY (`id`)
) TYPE=InnoDB COMMENT="InnoDB free: 10240 kB";