-- MySQL dump 10.11 -- -- Host: localhost Database: duhagrou_kpsh -- ------------------------------------------------------ -- Server version 5.0.77 /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `aduan` -- DROP TABLE IF EXISTS `aduan`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `aduan` ( `bil` int(4) unsigned NOT NULL auto_increment, `trkh` varchar(255) default NULL, `no_siri` varchar(255) default NULL, `nama` varchar(255) default NULL, `no_kp` varchar(255) default NULL, `no_hp` varchar(255) default NULL, `aduan` varchar(255) default NULL, `jns_aduan` varchar(255) default NULL, `status` varchar(255) default NULL, `terima_oleh` varchar(255) default NULL, `tarikh_terima` varchar(255) default NULL, `komen_penerima` varchar(255) default NULL, `nama_pegawai` varchar(255) default NULL, `catitan_pegawai` varchar(255) default NULL, `tindakan_pegawai` varchar(255) default NULL, PRIMARY KEY (`bil`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `aduan` -- LOCK TABLES `aduan` WRITE; /*!40000 ALTER TABLE `aduan` DISABLE KEYS */; INSERT INTO `aduan` VALUES (2,'06 09 2010','KPSH2010/09/1','sha','890503045284','0197434730','','Kerosakan','Belum Disemak',NULL,NULL,NULL,NULL,NULL,NULL),(3,'08 09 2010','KPSH2010/09/3','Din','781127042324','062316810','Ikan susah nak dapat. ','Lain-lain','Belum Disemak',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20 09 2010','KPSH2010/09/4','sha','890503045284','22222','','Kecurian','Belum Disemak',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20 09 2010','KPSH2010/09/5','rara','840104015348','8764799','','Kerosakan','Belum Disemak',NULL,NULL,NULL,NULL,NULL,NULL),(6,'28 09 2010','KPSH2010/09/6','','','','','Kecurian','Belum Disemak',NULL,NULL,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `aduan` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cadangan` -- DROP TABLE IF EXISTS `cadangan`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `cadangan` ( `bil` int(4) unsigned NOT NULL auto_increment, `trkh` varchar(255) default NULL, `no_siri` varchar(255) default NULL, `nama` varchar(255) default NULL, `no_kp` varchar(255) default NULL, `no_hp` varchar(255) default NULL, `cadangan` varchar(255) default NULL, `status` varchar(255) default NULL, `terima_oleh` varchar(255) default NULL, `tarikh_terima` varchar(255) default NULL, `komen_penerima` varchar(255) default NULL, `nama_pegawai` varchar(255) default NULL, `catitan_pegawai` varchar(255) default NULL, `tindakan_pegawai` varchar(255) default NULL, PRIMARY KEY (`bil`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `cadangan` -- LOCK TABLES `cadangan` WRITE; /*!40000 ALTER TABLE `cadangan` DISABLE KEYS */; INSERT INTO `cadangan` VALUES (2,'06 09 2010','KPSH2010/09/3','sha','890503045284','0197434730','','Belum Disemak',NULL,NULL,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `cadangan` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `daftar` -- DROP TABLE IF EXISTS `daftar`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `daftar` ( `bil` int(4) unsigned NOT NULL auto_increment, `tarikh_daftar` varchar(255) NOT NULL, `nama_pemilik` varchar(255) NOT NULL, `status_pemilik` varchar(255) NOT NULL, `kp_pemilik` varchar(255) NOT NULL, `tel_pemilik` varchar(255) NOT NULL, `jantina_pemilik` varchar(255) NOT NULL, `addrumah` varchar(255) NOT NULL, `umur_pemilik` varchar(255) NOT NULL, `addmajikan` varchar(255) default NULL, `kerja_pemilik` varchar(255) default NULL, `emel_pemilik` varchar(255) default NULL, `trlahir_pemilik` varchar(255) default NULL, `nama_pasangan` varchar(255) default NULL, `tlahir_pasangan` varchar(255) default NULL, `kp_pasangan` varchar(255) default NULL, `tel_pasangan` varchar(255) default NULL, `jantina_pasangan` varchar(255) default NULL, `kerja_pasangan` varchar(255) default NULL, `umur_pasangan` varchar(255) default NULL, `addmajikan_pasangan` varchar(255) default NULL, `anak_1` varchar(255) default NULL, `anak_2` varchar(255) default NULL, `anak_3` varchar(255) default NULL, `anak_4` varchar(255) default NULL, `anak_5` varchar(255) default NULL, `anak_6` varchar(255) default NULL, `kp_anak1` varchar(255) default NULL, `kp_anak2` varchar(255) default NULL, `kp_anak3` varchar(255) default NULL, `kp_anak4` varchar(255) default NULL, `kp_anak5` varchar(255) default NULL, `kp_anak6` varchar(255) default NULL, `umur_anak1` varchar(255) default NULL, `umur_anak2` varchar(255) default NULL, `umur_anak3` varchar(255) default NULL, `umur_anak4` varchar(255) default NULL, `umur_anak5` varchar(255) default NULL, `umur_anak6` varchar(255) default NULL, `kerja_anak1` varchar(255) default NULL, `kerja_anak2` varchar(255) default NULL, `kerja_anak3` varchar(255) default NULL, `kerja_anak4` varchar(255) default NULL, `kerja_anak5` varchar(255) default NULL, `kerja_anak6` varchar(255) default NULL, `nama_waris` varchar(255) default NULL, `tel_waris` varchar(255) default NULL, `add_waris` varchar(255) default NULL, `nama_waris2` varchar(255) default NULL, `tel_waris2` varchar(255) default NULL, `add_waris2` varchar(255) default NULL, `nama_waris3` varchar(255) default NULL, `tel_waris3` varchar(255) default NULL, `add_waris3` varchar(255) default NULL, `nama_waris4` varchar(255) default NULL, `tel_waris4` varchar(255) default NULL, `add_waris4` varchar(255) default NULL, `nama_waris5` varchar(255) default NULL, `tel_waris5` varchar(255) default NULL, `add_waris5` varchar(255) default NULL, `nama_waris6` varchar(255) default NULL, `tel_waris6` varchar(255) default NULL, `add_waris6` varchar(255) default NULL, `nama_daftar` varchar(255) default NULL, `pword_daftar` varchar(255) default NULL, PRIMARY KEY (`bil`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `daftar` -- LOCK TABLES `daftar` WRITE; /*!40000 ALTER TABLE `daftar` DISABLE KEYS */; INSERT INTO `daftar` VALUES (4,'27 09 2010','saiful anuar bin razon','Bujang','870130015323','00163113514','Lelaki','c-5-12a apt sri melur,\r\nukay perdana, ampang,\r\nselangor','23','3k resources sdn bhd\r\nampang, selangor.','juruteknik','saifulanuar1987@yahoo.com','30 januari 1987','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','razon bin ahmad','0143242624','kg kesang tasek, sg mati, muar.','','','','','','','','','','','','','','','','saifulanuar1987','f3a4f27891db0ade9aef38fcca24728e'); /*!40000 ALTER TABLE `daftar` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `forum_answer` -- DROP TABLE IF EXISTS `forum_answer`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `forum_answer` ( `question_id` int(4) NOT NULL default '0', `a_id` int(4) NOT NULL auto_increment, `a_name` varchar(65) NOT NULL default '', `a_email` varchar(65) NOT NULL default '', `a_answer` longtext NOT NULL, `a_datetime` varchar(25) NOT NULL default '', `photo` varchar(65) NOT NULL default 'pic_asal.jpg', KEY `a_id` (`a_id`) ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `forum_answer` -- LOCK TABLES `forum_answer` WRITE; /*!40000 ALTER TABLE `forum_answer` DISABLE KEYS */; INSERT INTO `forum_answer` VALUES (3,4,'admin','kpsgharapan@gmail.com','betul!kalo xcaya dtg la ke kolam pancing sungai harapan..anda boleh melihat sendri kehebatan kolam kami...','06/09/10 10:47:12','pic_asal.jpg'),(5,5,'fish seeker','mika_red@hotmail.com','ya!para sume pemancing yang budiman,tiket 3jam percuma akan dihadiahkan kepada sesiapa saja di seluruh negara yang dapat membawa para pemacing lain seramai 4 org....saya sudah 3jam percuma...ko orang jangan lengah2 lagi...','21/09/10 00:20:35','pic_asal.jpg'),(6,6,'belanakboy','mika_red@hotmail.com','aku dr kl ade g mancing gak kat kolam tu..2kali aku pegi aisrim plak.tp langit x slalu mendung,mase ari raya ari tu aku balik kampung.bosan2 layan sedare dgt umah aku g layan kolam plak.mmg ari tu ari aku,jenak tanda 2.8 milik aku.huhu..dah le dpt tande dpt lak sekor lg siakap mase aku dah nak abis mase...melambung2 siakap sekilo lebih tu aku kejekan.gune pelampung je bro.gune belanak je pun boleh... ','21/09/10 00:42:38','pic_asal.jpg'),(6,7,'tomman angler','mika_red@hotmail.com','yo fish seeker.aku br brjinak2 main kolam air masin best gak..nak tanya ckit leh?bape bayaran masuk?berapa jam mimima mancing?Slalu pakai umpan ape?ade ade ape jenis lagi ikan kolam sg harapan kat sungai rambai tu?sor sbb byk tanya br nak blaja...','21/09/10 00:56:07','pic_asal.jpg'),(5,8,'aiman x keysah','','ishh. biar btol ni. err. de dpt discount x kalo sy nk bwk lg rmai kwn² sy?','21/09/10 12:28:23','pic_asal.jpg'),(5,9,'fish seeker','mika_red@hotmail.com','kpd aiman xkeysah dan para angler yg handal belaka..mmg btol ttg topik tu..lg ramai pemancing lg cantik..lg byk habuan utk org yg bw kwn2..yg penting cube dl..','22/09/10 02:03:11','pic_asal.jpg'),(5,10,'','','','22/09/10 02:03:42','pic_asal.jpg'),(5,11,'kerapu_mereng','gsr_virus@yahoo.com','kolam nie 100% melayu ker cine???denagr khabar angin, kolam nie boleh tahan jugak ngan jenak.betul ker??','23/09/10 11:19:06','pic_asal.jpg'),(4,12,'ader pertandingan ker???','','','23/09/10 11:20:32','pic_asal.jpg'),(4,13,'kerapu_mereng','','ade game ker???bile tue???nak join gak...','23/09/10 11:21:35','pic_asal.jpg'),(7,14,'kerapu_mereng','','power camne tue????besar ker??','23/09/10 11:30:51','pic_asal.jpg'),(7,15,'kakijoran','','kolam kat mne?','23/09/10 15:30:58','pic_asal.jpg'),(7,16,'genji','mustang_5k@yahoo.com','alup','23/09/10 15:31:32','pic_asal.jpg'),(6,17,'fish seeker','mika_red@hotmail.com','sori tomman angler lambat reply..no hal nye klu nak tanye ape2 pun slagi leh jwb.klu byrn msk tu kene rm50 deposit utk sorang pemancing maksudnye utk byrn masuk mancing minima 3jam iaitu rm36 dan rm14 akan dikembalikan kpd pemancing bl tamat 3jam mase memancing.leh faham kan..utk umpan lak leh guna udang idup,udang kopek,belanak dan ikan kembong yg biase digunakan oleh para pemancing kolam air masin..tp igt dilarang gunakan UMPAN TIRUAN.sume umpan tu leh bwk sendiri atau susah2 sgt leh beli kat kolam tu.utk jenis ikan plak ade siakap,siakap merah(bangla),jenak (tanda),gelama taiwan,kerapu,bawal(chaping).....','24/09/10 01:04:19','pic_asal.jpg'),(5,18,'f','','','24/09/10 01:25:43','pic_asal.jpg'),(5,19,'fish seeker','mika_red@hotmail.com','kpd kerapu_mereng dan para2 angler yg d hormati..utk makluman kpd sume,kolam air masin sg harapan ni milik melayu 100%..klu cite psl jenak plak mmg jenak kat kolam nie 18SG..ape2 pun sudi2 lah pd para pemancing dtg kolam nie test jenak tu..\r\n','24/09/10 01:33:17','pic_asal.jpg'),(3,20,'kerapu_mereng','','ape lagi ikan yang ader bro???','24/09/10 10:59:22','pic_asal.jpg'),(3,21,'shimano','mika_red@hotmail.com','aku dpt gelama taiwan 2kg dpt duit lg huhuhu...syukur....','28/09/10 01:09:45','pic_asal.jpg'),(4,22,'JOHORANGLER','mika_red@hotmail.com','Salam.kalau orang dr luar atau kelab pancing nak sewa 1 ari mancing utk ari keluarga kat kolam ni boleh ke?berapa bayaran yang akan dikenakan?please reply.','28/09/10 01:26:28','pic_asal.jpg'),(3,23,'bby','','','28/09/10 10:03:19','pic_asal.jpg'),(3,24,'555555gf','','t','28/09/10 10:04:24','pic_asal.jpg'); /*!40000 ALTER TABLE `forum_answer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `forum_question` -- DROP TABLE IF EXISTS `forum_question`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `forum_question` ( `id` int(4) NOT NULL auto_increment, `topic` varchar(255) NOT NULL default '', `detail` longtext NOT NULL, `name` varchar(65) NOT NULL default '', `email` varchar(65) NOT NULL default '', `datetime` varchar(25) NOT NULL default '', `view` int(4) NOT NULL default '0', `reply` int(4) NOT NULL default '0', `photo` varchar(65) NOT NULL default 'pic_asal.jpg', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `forum_question` -- LOCK TABLES `forum_question` WRITE; /*!40000 ALTER TABLE `forum_question` DISABLE KEYS */; INSERT INTO `forum_question` VALUES (3,'ikan baru naik','ikan baru 2kilo lbih','wan','wan_ahmad@gmail.com','06/09/10 10:42:32',40,5,'pic_asal.jpg'),(4,'Pertandingan Memancing','Bila nak buat pertandingan memancing? Ada ker? Camna nak join?','Mie','mie@gmail.com','20/09/10 09:35:04',30,3,'pic_asal.jpg'),(5,'Promosi Syawal','Tiket memancing 3jam percuma','fish seeker','mika_red@hotmail.com','21/09/10 12:12:14',51,7,'pic_asal.jpg'),(6,'ade braniiiiiiiii','sape2 nak try kolam air masin kat sini???','fish seeker','mika_red@hotmail.com','21/09/10 12:25:44',37,3,'pic_asal.jpg'),(7,'siakap power','','wan@kolam','','23/09/10 11:29:59',46,3,'pic_asal.jpg'),(8,'Khidmat Urut','Para pemancing yg dihormati...Selain dr memancing ikan,terdapat juga khidmat urut d kolam ini bg menghilangkan stress ke,sakit2 badan ke,terrkehel ke,khas kpd para pemancing lelaki saje...upah?pandai2 le adjust k... ','fish seeker','mika_red@hotmail.com','27/09/10 12:29:39',23,0,'pic_asal.jpg'),(9,'DAPAT BONUS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!','Aku nak kongsi pengalaman mancing dgn korang sume..Jgn x caye Bonus bulanan 1st rm500..2nd rm1000..3rd rm200..Ade lg... bonus harian lak 1st rm100..2nd rm50..3rd 3jam free.Mule2 aku xcye gak tp aku try mancing kat kolam tu dpt no1 naik gelama taiwan 2kg lak tp syg x dpt msk bonus bulanan sbb syarat nak msk bonus bulanan mesti dpt ikan 2.501 kg ke atas...Nie leh cr makan nie..xpe ar dpt rm100 pun dah pulang modal dah.kire cukup baik la tu.xsangke lak ade kolam air masin steady wat bonus camni..nasib baik aku duk jauh klu dekat leh cube2 nasib bonus2 tu slalu..ape2 pun slain dr tgk topik kat web kolam ni,pd otai2 yg mancing kat kolam tu yg tau ape2 bonus ke jackpot ke ape2 ke mintak tlg inform kat aku ttg kolam ni melalui topik ni leh x please.......','shimano','mika_red@hotmail.com','28/09/10 01:02:39',30,0,'pic_asal.jpg'); /*!40000 ALTER TABLE `forum_question` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kalendar` -- DROP TABLE IF EXISTS `kalendar`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `kalendar` ( `perkara` varchar(100) NOT NULL, `tarikh` varchar(100) NOT NULL, `mesej` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `kalendar` -- LOCK TABLES `kalendar` WRITE; /*!40000 ALTER TABLE `kalendar` DISABLE KEYS */; /*!40000 ALTER TABLE `kalendar` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2012-01-20 8:57:55