-- phpMyAdmin SQL Dump
-- version 2.8.0.1
-- http://www.phpmyadmin.net
--
-- Host: custsql-ipg28.eigbox.net
-- Generation Time: Jan 01, 2013 at 10:12 AM
-- Server version: 5.0.91
-- PHP Version: 4.4.9
--
-- Database: `bfb`
--

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

--
-- Table structure for table `administrators`
--

CREATE TABLE `administrators` (
  `ADMINID` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `email` VARCHAR(80) NOT NULL DEFAULT '',
  `username` VARCHAR(80) NOT NULL DEFAULT '',
  `password` VARCHAR(50) NOT NULL DEFAULT '',
  PRIMARY KEY  (`ADMINID`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `administrators`
--

INSERT INTO `administrators` VALUES (1, '[email protected]', 'tomex009', '48238b7f2aa5f76a1d1e119f8942ebe7');

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

--
-- Table structure for table `advertisements`
--

CREATE TABLE `advertisements` (
  `AID` BIGINT(30) NOT NULL AUTO_INCREMENT,
  `description` VARCHAR(200) NOT NULL DEFAULT '',
  `code` text NOT NULL,
  `active` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY  (`AID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `advertisements`
--

INSERT INTO `advertisements` VALUES (1, '300 x 250 pixels', '<script type="text/javascript"><!--\r\ngoogle_ad_client = "ca-pub-4038454921391697";\r\n/* 250x250 21 */\r\ngoogle_ad_slot = "7681226835";\r\ngoogle_ad_width = 250;\r\ngoogle_ad_height = 250;\r\n//-->\r\n</script>\r\n<script type="text/javascript"\r\nsrc="http://pagead2.googlesyndication.com/pagead/show_ads.js">\r\n</script>', '1');
INSERT INTO `advertisements` VALUES (2, '300 x 300 pixels', '<script type="text/javascript"><!--\r\ngoogle_ad_client = "ca-pub-4038454921391697";\r\n/* 300x250 2 */\r\ngoogle_ad_slot = "5822717234";\r\ngoogle_ad_width = 300;\r\ngoogle_ad_height = 250;\r\n//-->\r\n</script>\r\n<script type="text/javascript"\r\nsrc="http://pagead2.googlesyndication.com/pagead/show_ads.js">\r\n</script>', '1');
INSERT INTO `advertisements` VALUES (3, '728 x 90 pixels', '<script type="text/javascript"><!--\r\ngoogle_ad_client = "ca-pub-4038454921391697";\r\n/* Down Banner */\r\ngoogle_ad_slot = "3166702349";\r\ngoogle_ad_width = 728;\r\ngoogle_ad_height = 90;\r\n//-->\r\n</script>\r\n<script type="text/javascript"\r\nsrc="http://pagead2.googlesyndication.com/pagead/show_ads.js">\r\n</script>', '1');

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

--
-- Table structure for table `bans_ips`
--

CREATE TABLE `bans_ips` (
  `ip` VARCHAR(20) NOT NULL,
  UNIQUE KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bans_ips`
--


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

--
-- Table structure for table `config`
--

CREATE TABLE `config` (
  `setting` VARCHAR(60) NOT NULL DEFAULT '',
  `value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `config`
--

INSERT INTO `config` VALUES ('site_email', '[email protected]');
INSERT INTO `config` VALUES ('site_name', 'Balkan Fail Blog');
INSERT INTO `config` VALUES ('max_syndicate_results', '25');
INSERT INTO `config` VALUES ('maximum_results', '1000000');
INSERT INTO `config` VALUES ('emailsender', 'Admin');
INSERT INTO `config` VALUES ('max_img_size', '200');
INSERT INTO `config` VALUES ('items_per_page', '10');
INSERT INTO `config` VALUES ('approve_stories', '0');
INSERT INTO `config` VALUES ('metadescription', 'Official Balkan Fail Blog Website');
INSERT INTO `config` VALUES ('metakeywords', '9gag clone, 9gag script, 9gag clone script, clone, script');
INSERT INTO `config` VALUES ('pub_mod', '1');
INSERT INTO `config` VALUES ('ver', '2.9');
INSERT INTO `config` VALUES ('FACEBOOK_PROFILE', 'BalkanFailBlog');
INSERT INTO `config` VALUES ('myes', '5');
INSERT INTO `config` VALUES ('mno', '5');
INSERT INTO `config` VALUES ('twitter', 'Scriptolution');
INSERT INTO `config` VALUES ('FACEBOOK_APP_ID', '128333383995241');
INSERT INTO `config` VALUES ('FACEBOOK_SECRET', 'a3459feb8732bcc1bfeff0b344da35fd');
INSERT INTO `config` VALUES ('enable_fc', '1');
INSERT INTO `config` VALUES ('mtrend', '1');
INSERT INTO `config` VALUES ('quota', '15');
INSERT INTO `config` VALUES ('contact_email', '[email protected]');
INSERT INTO `config` VALUES ('short_urls', '1');
INSERT INTO `config` VALUES ('FACEBOOK_ADMIN', '100000051390750');
INSERT INTO `config` VALUES ('wm', '0');
INSERT INTO `config` VALUES ('watermark', 'watermark.png');
INSERT INTO `config` VALUES ('points_gag', '10');
INSERT INTO `config` VALUES ('points_view', '1');
INSERT INTO `config` VALUES ('enable_featured', '0');
INSERT INTO `config` VALUES ('infinity_paging', '1');
INSERT INTO `config` VALUES ('wm', '0');
INSERT INTO `config` VALUES ('watermark', 'watermark.png');
INSERT INTO `config` VALUES ('FACEBOOK_ADMIN', '100000051390750');
INSERT INTO `config` VALUES ('re_mobile', '1');
INSERT INTO `config` VALUES ('m_url', 'http://mobilebfb.tk');

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

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `USERID` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `email` VARCHAR(80) NOT NULL DEFAULT '',
  `username` VARCHAR(80) NOT NULL DEFAULT '',
  `password` VARCHAR(50) NOT NULL DEFAULT '',
  `pwd` VARCHAR(50) NOT NULL,
  `fullname` VARCHAR(200) NOT NULL DEFAULT '',
  `gender` VARCHAR(6) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `country` VARCHAR(100) NOT NULL DEFAULT '',
  `yourviewed` INT(20) NOT NULL DEFAULT '0',
  `profileviews` INT(20) NOT NULL DEFAULT '0',
  `youviewed` BIGINT(20) NOT NULL DEFAULT '0',
  `addtime` VARCHAR(20) NOT NULL DEFAULT '',
  `lastlogin` VARCHAR(20) NOT NULL DEFAULT '',
  `verified` CHAR(1) NOT NULL DEFAULT '1',
  `status` enum('1','0') NOT NULL DEFAULT '1',
  `profilepicture` VARCHAR(100) NOT NULL DEFAULT '',
  `remember_me_key` VARCHAR(32) DEFAULT NULL,
  `remember_me_time` datetime DEFAULT NULL,
  `ip` VARCHAR(20) NOT NULL,
  `lip` VARCHAR(20) NOT NULL,
  `website` VARCHAR(200) NOT NULL,
  `news` INT(1) NOT NULL DEFAULT '0',
  `mylang` VARCHAR(20) NOT NULL,
  `color1` VARCHAR(6) NOT NULL DEFAULT '333333',
  `color2` VARCHAR(6) NOT NULL DEFAULT 'FFFFFF',
  `filter` BIGINT(1) NOT NULL DEFAULT '1',
  `points` BIGINT(50) NOT NULL,
  PRIMARY KEY  (`USERID`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `members`
--

INSERT INTO `members` VALUES (1, '[email protected]', 'tomex009', '48238b7f2aa5f76a1d1e119f8942ebe7', 'XlQ2v1356734945', '', '', '', '', 6, 0, 5, '1356734945', '', '1', '1', '', NULL, NULL, '89.172.31.197', '89.172.31.197', '', 0, '', '333333', 'FFFFFF', 1, 15);

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

--
-- Table structure for table `members_passcode`
--

CREATE TABLE `members_passcode` (
  `USERID` BIGINT(20) NOT NULL DEFAULT '0',
  `code` VARCHAR(30) NOT NULL DEFAULT '',
  PRIMARY KEY  (`USERID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `members_passcode`
--


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

--
-- Table structure for table `members_verifycode`
--

CREATE TABLE `members_verifycode` (
  `USERID` BIGINT(20) NOT NULL DEFAULT '0',
  `code` VARCHAR(30) NOT NULL DEFAULT '',
  PRIMARY KEY  (`USERID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `members_verifycode`
--

INSERT INTO `members_verifycode` VALUES (0, 'h394Y1328501678');

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `PID` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `USERID` BIGINT(20) NOT NULL DEFAULT '0',
  `story` text NOT NULL,
  `tags` VARCHAR(200) NOT NULL,
  `source` VARCHAR(200) NOT NULL,
  `nsfw` INT(1) NOT NULL DEFAULT '0',
  `pic` VARCHAR(20) NOT NULL,
  `youtube_key` VARCHAR(20) NOT NULL,
  `fod_key` VARCHAR(20) NOT NULL,
  `url` text NOT NULL,
  `time_added` VARCHAR(20) DEFAULT NULL,
  `date_added` DATE NOT NULL DEFAULT '0000-00-00',
  `active` CHAR(1) NOT NULL DEFAULT '',
  `phase` BIGINT(1) NOT NULL DEFAULT '0',
  `favclicks` BIGINT(50) NOT NULL DEFAULT '0',
  `last_viewed` VARCHAR(20) NOT NULL DEFAULT '',
  `mod_yes` BIGINT(20) NOT NULL DEFAULT '0',
  `mod_no` BIGINT(20) NOT NULL DEFAULT '0',
  `pip` VARCHAR(20) NOT NULL,
  `pip2` VARCHAR(20) NOT NULL,
  `unfavclicks` BIGINT(50) NOT NULL DEFAULT '0',
  `fix` BIGINT(20) NOT NULL DEFAULT '0',
  `short` VARCHAR(20) NOT NULL,
  `ttime` VARCHAR(20) NOT NULL,
  `htime` VARCHAR(20) NOT NULL,
  `feat` INT(1) NOT NULL DEFAULT '0',
  `rec` INT(1) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`PID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` VALUES (1, 1, 'ZM', '', '', 0, '1.jpg', '', '', '', '1357007005', '2012-12-31', '1', 0, 1, '1357007133', 0, 0, '89.172.25.214', '', 0, 0, '', '', '', 0, 0);

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

--
-- Table structure for table `posts_favorited`
--

CREATE TABLE `posts_favorited` (
  `FID` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `USERID` BIGINT(25) NOT NULL DEFAULT '0',
  `PID` BIGINT(25) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`FID`),
  UNIQUE KEY `USERID` (`USERID`,`PID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `posts_favorited`
--

INSERT INTO `posts_favorited` VALUES (1, 1, 1);

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

--
-- Table structure for table `posts_reports`
--

CREATE TABLE `posts_reports` (
  `RID` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `PID` BIGINT(20) NOT NULL DEFAULT '0',
  `time` VARCHAR(20) DEFAULT NULL,
  `ip` VARCHAR(20) NOT NULL,
  `reason` BIGINT(1) NOT NULL,
  PRIMARY KEY  (`RID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `posts_reports`
--


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

--
-- Table structure for table `posts_unfavorited`
--

CREATE TABLE `posts_unfavorited` (
  `FID` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `USERID` BIGINT(25) NOT NULL DEFAULT '0',
  `PID` BIGINT(25) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`FID`),
  UNIQUE KEY `USERID` (`USERID`,`PID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `posts_unfavorited`
--


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

--
-- Table structure for table `static`
--

CREATE TABLE `static` (
  `ID` BIGINT(30) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(255) NOT NULL DEFAULT '',
  `value` text NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `static`
--

INSERT INTO `static` VALUES (1, 'Terms Of Use', 'Insert your terms of use information here.<br><br>\r\n\r\nHTML is accepted.');
INSERT INTO `static` VALUES (2, 'Privacy Policy', 'Insert your privacy policy information here.<br><br>\r\n\r\nHTML is accepted.');
INSERT INTO `static` VALUES (3, 'About', 'Insert your about us information here.<br><br>\r\n\r\nHTML is accepted.');
INSERT INTO `static` VALUES (4, '9 Rules', 'Insert your 9 rules here.<br><br>\r\n\r\nHTML is accepted.');
INSERT INTO `static` VALUES (5, 'FAQ', 'Insert your frequently asked questions here.<br><br>\r\n\r\nHTML is accepted.');