-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Mar 05, 2024 at 09:31 PM
-- Server version: 5.7.15-log
-- PHP Version: 5.6.26

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 utf8mb4 */;

--
-- Database: `nairaland2`
--

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

--
-- Table structure for table `bot`
--

CREATE TABLE `bot` (
  `id` int(11) NOT NULL,
  `user` varchar(50) NOT NULL,
  `key` varchar(100) NOT NULL DEFAULT '',
  `text` text NOT NULL,
  `txt1` varchar(500) NOT NULL,
  `txt2` varchar(500) NOT NULL,
  `txt3` varchar(500) NOT NULL,
  `time` int(15) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_ads`
--

CREATE TABLE `cms_ads` (
  `id` int(10) UNSIGNED NOT NULL,
  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `view` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `layout` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `count` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `count_link` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` text NOT NULL,
  `link` text NOT NULL,
  `to` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `color` varchar(10) NOT NULL DEFAULT '',
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `day` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `mesto` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `bold` tinyint(1) NOT NULL DEFAULT '0',
  `italic` tinyint(1) NOT NULL DEFAULT '0',
  `underline` tinyint(1) NOT NULL DEFAULT '0',
  `show` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_album_cat`
--

CREATE TABLE `cms_album_cat` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sort` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(40) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `password` varchar(20) NOT NULL DEFAULT '',
  `access` tinyint(4) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_album_comments`
--

CREATE TABLE `cms_album_comments` (
  `id` int(10) UNSIGNED NOT NULL,
  `sub_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `text` text NOT NULL,
  `reply` text NOT NULL,
  `attributes` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_album_downloads`
--

CREATE TABLE `cms_album_downloads` (
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `file_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_album_files`
--

CREATE TABLE `cms_album_files` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `album_id` int(10) UNSIGNED NOT NULL,
  `description` text NOT NULL,
  `img_name` varchar(100) NOT NULL DEFAULT '',
  `tmb_name` varchar(100) NOT NULL DEFAULT '',
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `comments` tinyint(1) NOT NULL DEFAULT '1',
  `comm_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `access` tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
  `vote_plus` int(11) NOT NULL DEFAULT '0',
  `vote_minus` int(11) NOT NULL DEFAULT '0',
  `views` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `downloads` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `unread_comments` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_album_views`
--

CREATE TABLE `cms_album_views` (
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `file_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_album_votes`
--

CREATE TABLE `cms_album_votes` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `file_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `vote` tinyint(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_ban_ip`
--

CREATE TABLE `cms_ban_ip` (
  `id` int(10) UNSIGNED NOT NULL,
  `ip1` bigint(11) NOT NULL DEFAULT '0',
  `ip2` bigint(11) NOT NULL DEFAULT '0',
  `ban_type` tinyint(4) NOT NULL DEFAULT '0',
  `link` varchar(100) NOT NULL DEFAULT '',
  `who` varchar(25) NOT NULL DEFAULT '',
  `reason` text NOT NULL,
  `date` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_ban_users`
--

CREATE TABLE `cms_ban_users` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `ban_time` int(11) NOT NULL DEFAULT '0',
  `ban_while` int(11) NOT NULL DEFAULT '0',
  `ban_type` tinyint(4) NOT NULL DEFAULT '1',
  `ban_who` varchar(30) NOT NULL DEFAULT '',
  `ban_ref` int(11) NOT NULL DEFAULT '0',
  `ban_reason` text NOT NULL,
  `ban_raz` varchar(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_contact`
--

CREATE TABLE `cms_contact` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `from_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `friends` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `ban` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `man` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;


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

--
-- Table structure for table `cms_counters`
--

CREATE TABLE `cms_counters` (
  `id` int(10) UNSIGNED NOT NULL,
  `sort` int(10) NOT NULL DEFAULT '1',
  `name` varchar(30) NOT NULL DEFAULT '',
  `link1` text NOT NULL,
  `link2` text NOT NULL,
  `mode` tinyint(4) NOT NULL DEFAULT '1',
  `switch` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_forum_files`
--

CREATE TABLE `cms_forum_files` (
  `id` int(10) UNSIGNED NOT NULL,
  `cat` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `subcat` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `topic` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `post` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `filename` text NOT NULL,
  `filetype` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `dlcount` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `del` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;


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

--
-- Table structure for table `cms_forum_like`
--

CREATE TABLE `cms_forum_like` (
  `id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `value` int(1) NOT NULL,
  `type` enum('plus','minus') NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cms_forum_like`
--

INSERT INTO `cms_forum_like` (`id`, `post_id`, `user_id`, `value`, `type`) VALUES
(1, 33, 1, 0, 'plus'),
(2, 5, 1, 0, 'plus'),
(3, 35, 1, 0, 'plus'),
(4, 43, 1, 0, 'plus'),
(5, 47, 1, 0, 'plus'),
(6, 59, 1, 0, 'plus'),
(7, 43, 2, 0, 'plus'),
(8, 43, 24, 0, 'plus'),
(9, 67, 1, 0, 'plus'),
(10, 55, 35, 0, 'plus'),
(11, 77, 1, 0, 'plus'),
(12, 63, 43, 0, 'plus'),
(13, 71, 43, 0, 'plus'),
(14, 82, 1, 0, 'plus'),
(15, 67, 38, 0, 'plus'),
(16, 87, 1, 0, 'plus'),
(17, 85, 1, 0, 'plus'),
(18, 79, 49, 0, 'plus'),
(19, 95, 49, 0, 'minus'),
(20, 98, 1, 0, 'plus'),
(21, 98, 52, 0, 'plus'),
(22, 33, 49, 0, 'plus'),
(23, 39, 57, 0, 'plus'),
(24, 101, 1, 0, 'plus'),
(25, 35, 57, 0, 'plus'),
(26, 37, 57, 0, 'plus'),
(27, 109, 57, 0, 'plus'),
(28, 110, 1, 0, 'plus'),
(29, 105, 1, 0, 'plus'),
(30, 104, 1, 0, 'plus'),
(31, 91, 1, 0, 'plus'),
(32, 114, 1, 0, 'plus'),
(33, 99, 1, 0, 'plus'),
(34, 114, 57, 0, 'plus'),
(35, 106, 57, 0, 'plus'),
(36, 113, 57, 0, 'plus'),
(37, 122, 1, 0, 'plus'),
(38, 123, 1, 0, 'plus'),
(39, 35, 62, 0, 'plus'),
(40, 133, 57, 0, 'plus'),
(41, 135, 57, 0, 'plus'),
(42, 125, 57, 0, 'plus'),
(43, 140, 1, 0, 'plus'),
(44, 146, 1, 0, 'plus'),
(45, 120, 1, 0, 'plus'),
(46, 156, 72, 0, 'plus'),
(47, 156, 1, 0, 'plus'),
(48, 157, 1, 0, 'plus'),
(49, 159, 1, 0, 'plus'),
(50, 49, 52, 0, 'plus'),
(51, 63, 1, 0, 'plus'),
(52, 69, 1, 0, 'plus');

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

--
-- Table structure for table `cms_forum_rdm`
--

CREATE TABLE `cms_forum_rdm` (
  `topic_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cms_forum_rdm`
--

INSERT INTO `cms_forum_rdm` (`topic_id`, `user_id`, `time`) VALUES
(44, 1, 1704296571),
(46, 1, 1704293876),
(48, 1, 1705834898),
(50, 1, 1704294862),
(50, 2, 1704294777),
(48, 72, 1704295628),
(55, 1, 1704340866),
(57, 1, 1704398678),
(48, 2, 1705905963),
(48, 52, 1706315398),
(50, 52, 1705359830),
(57, 52, 1706305815),
(70, 52, 1706306336),
(48, 31, 1706308384);

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

--
-- Table structure for table `cms_forum_vote`
--

CREATE TABLE `cms_forum_vote` (
  `id` int(10) UNSIGNED NOT NULL,
  `type` int(2) NOT NULL DEFAULT '0',
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `topic` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(200) NOT NULL,
  `count` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;


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

--
-- Table structure for table `cms_forum_vote_users`
--

CREATE TABLE `cms_forum_vote_users` (
  `id` int(10) UNSIGNED NOT NULL,
  `user` int(11) NOT NULL DEFAULT '0',
  `topic` int(11) NOT NULL,
  `vote` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;


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

--
-- Table structure for table `cms_library_comments`
--

CREATE TABLE `cms_library_comments` (
  `id` int(11) UNSIGNED NOT NULL,
  `sub_id` int(11) UNSIGNED NOT NULL,
  `time` int(11) NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `text` text NOT NULL,
  `reply` text,
  `attributes` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_library_rating`
--

CREATE TABLE `cms_library_rating` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `st_id` int(11) NOT NULL,
  `point` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_mail`
--

CREATE TABLE `cms_mail` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `from_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `text` text NOT NULL,
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `read` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `sys` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `delete` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `file_name` varchar(100) NOT NULL DEFAULT '',
  `count` int(10) NOT NULL DEFAULT '0',
  `size` int(10) NOT NULL DEFAULT '0',
  `them` varchar(100) NOT NULL DEFAULT '',
  `spam` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;



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

--
-- Table structure for table `cms_sessions`
--

CREATE TABLE `cms_sessions` (
  `session_id` char(32) NOT NULL DEFAULT '',
  `ip` bigint(11) NOT NULL DEFAULT '0',
  `ip_via_proxy` bigint(11) NOT NULL DEFAULT '0',
  `browser` varchar(255) NOT NULL DEFAULT '',
  `lastdate` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sestime` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `views` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `movings` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `place` varchar(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_users_data`
--

CREATE TABLE `cms_users_data` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `key` varchar(30) NOT NULL DEFAULT '',
  `val` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_users_guestbook`
--

CREATE TABLE `cms_users_guestbook` (
  `id` int(10) UNSIGNED NOT NULL,
  `sub_id` int(10) UNSIGNED NOT NULL,
  `time` int(11) NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `text` text NOT NULL,
  `reply` text NOT NULL,
  `attributes` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `cms_users_iphistory`
--

CREATE TABLE `cms_users_iphistory` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `ip` bigint(11) NOT NULL DEFAULT '0',
  `ip_via_proxy` bigint(11) NOT NULL DEFAULT '0',
  `time` int(10) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;



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

--
-- Table structure for table `download__bookmark`
--

CREATE TABLE `download__bookmark` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `file_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `download__category`
--

CREATE TABLE `download__category` (
  `id` int(11) UNSIGNED NOT NULL,
  `refid` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `dir` text NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `name` text NOT NULL,
  `total` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `rus_name` text NOT NULL,
  `text` text NOT NULL,
  `field` int(11) NOT NULL DEFAULT '0',
  `desc` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `download__category`
--

INSERT INTO `download__category` (`id`, `refid`, `dir`, `sort`, `name`, `total`, `rus_name`, `text`, `field`, `desc`) VALUES
(1, 0, '../files/downloads/files/Apk', 1704295990, 'Apk', 0, 'Nairaland', 'mp4, rar, zip, pdf, nth, txt, tar, gz, jpg, jpeg, gif, png, bmp, 3gp, mp3, mpg, thm, jad, jar, cab, sis, sisx, exe, msi, apk, djvu, fb2', 1, 'Site APK version can be installed in all Android platforms');

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

--
-- Table structure for table `download__comments`
--

CREATE TABLE `download__comments` (
  `id` int(10) UNSIGNED NOT NULL,
  `sub_id` int(10) UNSIGNED NOT NULL,
  `time` int(11) NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `text` text NOT NULL,
  `reply` text NOT NULL,
  `attributes` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `download__comments`
--

INSERT INTO `download__comments` (`id`, `sub_id`, `time`, `user_id`, `text`, `reply`, `attributes`) VALUES
(1, 1, 1704296155, 1, 'APK file', '', 'a:4:{s:11:"author_name";s:11:"Tunzxywalex";s:9:"author_ip";s:10:"1717052233";s:19:"author_ip_via_proxy";i:0;s:14:"author_browser";s:111:"Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Mobile Safari/537.36";}');

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

--
-- Table structure for table `download__files`
--

CREATE TABLE `download__files` (
  `id` int(10) UNSIGNED NOT NULL,
  `refid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dir` text NOT NULL,
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` text NOT NULL,
  `type` int(2) UNSIGNED NOT NULL DEFAULT '0',
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `rus_name` text NOT NULL,
  `text` text NOT NULL,
  `field` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `rate` varchar(30) NOT NULL DEFAULT '0|0',
  `about` text NOT NULL,
  `desc` text NOT NULL,
  `comm_count` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;


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

--
-- Table structure for table `download__more`
--

CREATE TABLE `download__more` (
  `id` int(11) NOT NULL,
  `refid` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `name` text NOT NULL,
  `rus_name` text NOT NULL,
  `size` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `forum`
--

CREATE TABLE `forum` (
  `id` int(10) UNSIGNED NOT NULL,
  `refid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` char(1) NOT NULL DEFAULT '',
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `from` varchar(25) NOT NULL DEFAULT '',
  `realid` int(3) NOT NULL DEFAULT '0',
  `ip` bigint(11) NOT NULL DEFAULT '0',
  `ip_via_proxy` bigint(11) NOT NULL DEFAULT '0',
  `soft` text NOT NULL,
  `text` text NOT NULL,
  `close` tinyint(1) NOT NULL DEFAULT '0',
  `close_who` varchar(25) NOT NULL DEFAULT '',
  `vip` tinyint(1) NOT NULL DEFAULT '0',
  `edit` text NOT NULL,
  `tedit` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `kedit` int(2) UNSIGNED NOT NULL DEFAULT '0',
  `curators` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `forum`
--

INSERT INTO `forum` (`id`, `refid`, `type`, `time`, `user_id`, `from`, `realid`, `ip`, `ip_via_proxy`, `soft`, `text`, `close`, `close_who`, `vip`, `edit`, `tedit`, `kedit`, `curators`) VALUES
(1, 0, 'f', 0, 0, '', 1, 0, 0, 'Lots of General', 'General - Nairaland', 0, '', 0, '0', 0, 0, ''),
(2, 0, 'f', 0, 0, '', 2, 0, 0, 'Entertainment threads that won\'t fit into any child board', 'Entertainment', 0, '', 0, '0', 0, 0, ''),
(3, 0, 'f', 0, 0, '', 3, 0, 0, 'Science/Technology', 'Science/Technology', 0, '', 0, '0', 0, 0, ''),
(4, 3, 'r', 0, 0, '', 1, 0, 0, 'Software programming, development of applications..', 'Programming', 0, '', 0, '0', 0, 0, ''),
(5, 3, 'r', 0, 0, '', 2, 0, 0, 'Website design and development, management of forums, blogs, wikis, and all sorts of websites. 🥹🤯🥳🇳🇬💸💸💸', 'Webmasters', 0, '', 0, '0', 0, 0, ''),
(6, 3, 'r', 0, 0, '', 3, 0, 0, 'Personal Computing, etc.', 'Computers', 0, '', 0, '0', 0, 0, ''),
(7, 3, 'r', 0, 0, '', 4, 0, 0, 'Nigerian GSM networks, telephone companies, et cetera. ISPs, Modems, Websites, etc', 'Phones', 0, '', 0, '0', 0, 0, ''),
(8, 3, 'r', 0, 0, '', 5, 0, 0, 'Digital Video and Film, Computer Graphics and Animation. Tips, Tricks & Tools.', 'Art, Graphics & Video', 0, '', 0, '0', 0, 0, ''),
(9, 3, 'r', 0, 0, '', 6, 0, 0, 'Buy and sell Phones, Computers and PC accessories here.', 'Technology Market', 0, '', 0, '0', 0, 0, ''),
(10, 2, 'r', 0, 0, '', 1, 0, 0, 'Riddles and jokes that fellow Nigerians can appreciate.', 'Jokes Etc', 0, '', 0, '0', 0, 0, ''),
(11, 2, 'r', 0, 0, '', 2, 0, 0, 'Local television programmes, local and foreign movies available in Nigeria.', 'TV/Movies', 0, '', 0, '0', 0, 0, ''),
(12, 2, 'r', 0, 0, '', 3, 0, 0, 'Talk about your favorite songs, music albums, artists and bands.', 'Music/Radio', 0, '', 0, '0', 0, 0, ''),
(13, 2, 'r', 0, 0, '', 4, 0, 0, 'Celebrity obsession, Nollywood gossip, etc.', 'Celebrities', 0, '', 0, '0', 0, 0, ''),
(14, 2, 'r', 0, 0, '', 5, 0, 0, 'Clothes, dresses, make-up routines, and modeling.', 'Fashion', 0, '', 0, '0', 0, 0, ''),
(15, 2, 'r', 0, 0, '', 6, 0, 0, 'Birthdays, Weddings, other Occasions. Planning, Announcement, Gifts.', 'Events', 0, '', 0, '0', 0, 0, ''),
(16, 2, 'r', 0, 0, '', 7, 0, 0, 'We are Nigerians; and we love soccer and many other sports!', 'Sports', 0, '', 0, '0', 0, 0, ''),
(17, 2, 'r', 0, 0, '', 8, 0, 0, 'Welcome to the world of computer, Internet, video, and board games. Xbox, PS2, Chess, whatever!', 'Gaming', 0, '', 0, '0', 0, 0, ''),
(18, 2, 'r', 0, 0, '', 9, 0, 0, 'Play various addictive forum games with fellow members of Nairaland.', 'Forum Games', 0, '', 0, '0', 0, 0, ''),
(19, 2, 'r', 0, 0, '', 10, 0, 0, 'For writers and lovers of books.', 'Literature', 0, '', 0, '0', 0, 0, ''),
(20, 1, 'r', 0, 0, '', 1, 0, 0, 'Our country Nigeria is the giant of Africa!', 'Politics', 0, '', 0, '0', 0, 0, ''),
(21, 1, 'r', 0, 0, '', 2, 0, 0, 'share crimes information here', 'Crime', 0, '', 0, '0', 0, 0, ''),
(22, 1, 'r', 0, 0, '', 3, 0, 0, 'Discuss dating, courtship, and romance in marriage.', 'Romance', 0, '', 0, '0', 0, 0, ''),
(23, 1, 'r', 0, 0, '', 4, 0, 0, 'Job/Employment Opportunities; Vacancies In Nigeria!', 'Jobs/Vacancies', 0, '', 0, '0', 0, 0, ''),
(24, 1, 'r', 0, 0, '', 5, 0, 0, 'Talk about workplace experiences and incidents, professional training and certification, career management, etc. Employed, self-employed, job seekers.', 'Career', 0, '', 0, '0', 0, 0, ''),
(25, 1, 'r', 0, 0, '', 6, 0, 0, 'Entrepreneurship, Startups, Economics, etc', 'Business', 0, '', 0, '0', 0, 0, ''),
(26, 1, 'r', 0, 0, '', 7, 0, 0, 'For Investors. Nigerian Stock Exchange (NSE) Stocks, Bonds, T-bills, Real-Estate, etc.', 'Investment', 0, '', 0, '0', 0, 0, ''),
(27, 1, 'r', 0, 0, '', 8, 0, 0, 'National Youth Service Corps (NYSC) Discussions. Corpers, etc.', 'NYSC', 0, '', 0, '0', 0, 0, ''),
(28, 1, 'r', 0, 0, '', 9, 0, 0, 'Nairaland Students Forum: Primary and secondary school, universities, polytechnics, et cetera.', 'Education', 0, '', 0, '0', 0, 0, ''),
(29, 1, 'r', 0, 0, '', 10, 0, 0, 'Cars, motorbikes, airplanes, et cetera.', 'Autos', 0, '', 0, '0', 0, 0, ''),
(30, 1, 'r', 0, 0, '', 11, 0, 0, 'Let\'s talk about cars here', 'Car Talk', 0, '', 0, '0', 0, 0, ''),
(31, 1, 'r', 0, 0, '', 12, 0, 0, 'Real Estate: Land, Houses, Flats, Etc.', 'Properties', 0, '', 0, '0', 0, 0, ''),
(32, 1, 'r', 0, 0, '', 13, 0, 0, 'Health related topics.', 'Health', 0, '', 0, '0', 0, 0, ''),
(33, 1, 'r', 0, 0, '', 14, 0, 0, 'Tourism, travel. Interesting destinations within Nigeria and abroad. And motoring!', 'Travel', 0, '', 0, '0', 0, 0, ''),
(34, 1, 'r', 0, 0, '', 15, 0, 0, 'Marriage/Family issues including husband to wife, parent to child, sibling and extended family relationships', 'Family', 0, '', 0, '0', 0, 0, ''),
(35, 1, 'r', 0, 0, '', 16, 0, 0, 'Nigerian languages, traditions, practices, et cetera.', 'Culture', 0, '', 0, '0', 0, 0, ''),
(36, 1, 'r', 0, 0, '', 17, 0, 0, 'Share your faith and belief in God or higher powers here.', 'Religion', 0, '', 0, '0', 0, 0, ''),
(37, 1, 'r', 0, 0, '', 18, 0, 0, 'Delicious foods and how to prepare them. Anything about food or drink goes here. This is the Nairaland kitchen!', 'Food', 0, '', 0, '0', 0, 0, ''),
(38, 1, 'r', 0, 0, '', 19, 0, 0, 'Write about your life and let the whole world read you. You won\'t even be interrupted by comments. Nairaland members only!', 'Diaries', 0, '', 0, '0', 0, 0, ''),
(39, 1, 'r', 0, 0, '', 20, 0, 0, 'For moderators only.', 'Moderators', 0, '', 0, '0', 0, 0, ''),
(40, 1, 'r', 0, 0, '', 21, 0, 0, 'Moderators should send all unwanted topics here. Spam, etc. Thanks.', 'Recycle Bin', 0, '', 0, '0', 0, 0, ''),
(41, 1, 'r', 0, 0, '', 22, 0, 0, 'Nairaland Direct Adverts', 'Nairaland Ads', 0, '', 0, '0', 0, 0, ''),
(42, 1, 'r', 0, 0, '', 23, 0, 0, 'Discuss dogs/puppies, cats/kittens, and other pets. Buy and sell them', 'Pets', 0, '', 0, '0', 0, 0, ''),
(43, 1, 'r', 0, 0, '', 24, 0, 0, 'The business and science of crop and livestock production, Agric Science, Agric Economics, etc', 'Agriculture', 0, '', 0, '0', 0, 0, ''),
(44, 24, 't', 1704296571, 1, 'Admin', 0, 0, 0, '', 'Is 400k Job In Nigeria Worth Staying Or Should I Japa?', 0, '', 0, '', 0, 0, ''),
(45, 44, 'm', 1704296571, 1, 'Admin', 0, 1717059147, 0, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Mobile Safari/537.36', '[timestamp]03.01.2024 14:51[/timestamp]\nI will be 31 this year. Omo the age is scaring me and I keep feeling like I’m not doing enough. I have a stable job in the private sector with a 400k monthly salary. But I still feel the impact of the economy badly. I keep asking myself, at what point will I start living the good live?\r\nI feel stock sometimes because my job is very demanding and I almost do not have time to do other things, mind you I’m in the medical field and I work Mondays to Sundays most times but occasionally I have some Sundays to myself and sometimes a day off during the week. I can’t seem to be able to start a business as a side hustle cause most of the side hustles I can think will demand my presence at least for the first few months and I don’t really have that.\r\nMy girlfriend is pregnant, I really wanna keep it but she’s not ready, I’m not even sure I’m ready. The only way she can keep it is if I’m going to get married to her before the pregnancy starts showing and I’m as confused as hell cos I don’t know if I’m ready. She has always been vocal of her plans to japa.\r\nNow that brings me to the idea of Japa too. I mean, I cannot deny that fact that I’m scared of the whole japa stuff cos I don’t know what to expect. Economy doesn’t even allow you save as much as you should. Everything’s just seems very scattered.\r\n\r\nPls I need adult minds to advise me on what I can do.\r\n1. Do I start a business, what kinda business can I start with at least 2M that will not require my full presence?\r\n2. Do I start to plan my japa through the study route and just face my fears\r\n3. Should I insist on keeping the pregnancy and hope that things start making sense? This means I have to get married tho.\r\n\r\nThank y’all.\n\n[timestamp]03.01.2024 15:42[/timestamp]\nWow impressive', 0, '', 0, '', 0, 0, ''),
(46, 4, 't', 1704293876, 1, 'Admin', 0, 0, 0, '', 'I Want To Learn Programming. Which Language Should I Start With?', 0, '', 0, '', 0, 0, ''),
(47, 46, 'm', 1704293876, 1, 'Admin', 0, 1717052214, 0, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Mobile Safari/537.36', 'Due to the numerous "i want to start programming, which language should i start with" threads on this board i decided to create a thread that will address this issue. I am not a wonderful writer and i won\'t say i know it all but i will try. I urge every one on this board to correct me where i err an also contribute in whatever way you can to make this thread worth it. I will try as much as possible not to be biased in this write up.\r\n\r\nI am not going to go into detail in defining what programming is because i will assume before entering this thread you should already know what programming is. But in summary programming is the act of creating whatever you want with your brain and computer programming is the act of creating whatever you want with your brain and a computer. You can read more from\r\n\r\nhttp://en.wikipedia.org/wiki/Computer_programming\r\n\r\nProgrammers could also be called software programmers, software developers and other big-big names you can think of.\r\n\r\nFeel free to ask your questions, i will try and answer the ones i can my Ogas in the house will help me with those i can\'t answer\r\n\r\nPlease every Programmer should try as much as possible to check on this thread once in a while to help answer some questions Newbies would like to ask.', 0, '', 0, '', 0, 0, ''),
(48, 22, 't', 1706308384, 1, 'Admin', 0, 0, 0, '', 'She Wants To Relocate To Another City Because Of Me - Romance', 0, '', 0, '', 0, 0, ''),
(49, 48, 'm', 1704293985, 1, 'Admin', 0, 1717052214, 0, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Mobile Safari/537.36', 'I met her when I went for service in Rivers state some years back. I live in Lagos. After the service year ,I have to go back to Lagos .\r\nNow, of recent, we initiated a conversation that she still wants me and is willing to relocate from P.H to my base in Lagos.\r\nI am still single. So, is she .\r\nHowever, there are other women in the picture (there is always some in a man\'s life, right? whether you are single or married ?)\r\nI am not committed to any of them though.\r\nShould I encourage her to shoot her shot by relocating back to Lagos?', 0, '', 0, '', 0, 0, ''),
(50, 41, 't', 1704294862, 1, 'Tunzxywalex', 1, 0, 0, '', 'How To Place Targeted Ads On Nairaland - Adverts', 0, '', 0, '', 0, 0, ''),
(51, 50, 'm', 1704294615, 1, 'Tunzxywalex', 0, 1717059469, 0, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Mobile Safari/537.36', '[timestamp]03.01.2024 15:06[/timestamp]\nDear Ladies & Gentlemen,\r\n\r\nThank you for your interest in advertising on the Nairaland Forum!\r\n\r\nNairaland runs a Targeted Ad Platform with which any Nairaland member can place adverts on the sections of Nairaland where the people he/she wants to reach are most likely to be found (for example, a political party could place ads on the politics section with it).\r\n\r\nTo place ads on Nairaland, the first step is to get your ad banner designed by a good graphic designer. Your ad banner must be borderless, 318 pixels wide, 106 pixels tall, less than 30kb in size, and in the PNG or JPG format. Once it\'s ready, go to www.nairaland.com/campaign and click (Upload Ad) to upload your banner ad and landing page, and wait for approval. (Your ad might not be approved if it\'s deceptive or illegal or morally questionable in some way).\r\n\r\nAfter your ad is approved, we will provide you with information about how to purchase advertising credits so you can freely place your ads on any section of Nairaland - including the home page. Our system is extremely simple by design.\r\n\r\nPlease see our Estimated Advertising Rates to find out how much it\'ll cost to advertise on the various sections of Nairaland on the long run (prices on the short term are strongly correlated with traffic levels). Billing takes place every few minutes and you will get detailed reports on unique clicks and views and charges for each ad/section and for your entire account over various time periods.\r\n\r\nWe look forward to doing business with you!\r\n\r\nBest regards,\r\nTunzxywalex\n\n[timestamp]03.01.2024 15:10[/timestamp]\nNice', 0, '', 0, '', 0, 0, ''),
(52, 50, 'm', 1704294777, 2, 'spambot', 0, 1717059469, 0, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Mobile Safari/537.36', '[timestamp]03.01.2024 15:12[/timestamp]\nHow do you charge? Per click? Per impression? Per hour?\r\nWe charge for approximate value delivered. This is highly correlated with traffic on the short run. So when there\'s less traffic, you pay less, and when you\'re charged more, it will most likely be due to an increase in traffic. However, on the long run, that\'s not the only factor we consider. We have developed a robust pricing algorithm to make sure that you will always get what you pay for.\r\n\r\nWhat kind of ads would you not accept on Nairaland?\r\nWe will reject ads that we consider to be ethically or morally questionable in one way or the other. We reject ads for HYIPs and most MLMs because they are fundamentally unsustainable. We reject ads for health remedies that make claims that have not been verified by NAFDAC because we know that they don\'t work as advertised. We also reject some mailing list building ads because we don\'t want our members to be spammed. Sexual ads will only be accepted of placed in the sexuality section.\r\n\r\nCan we submit animated ads?\r\nNo. This is because they are distracting. If your ads are attractive and well targeted, people will notice them without any animations.\n\n[timestamp]03.01.2024 15:12[/timestamp]\nI placed my ad on a section of Nairaland but the placement has been \'pending;\'for a very long time. Why?\r\nThere are six advertising slots in every section of Nairaland. This means that only six advertisers can place their ads on any section of Nairaland at the same time. Once the six slots are full, any attempt to place ads on the same section by other advertisers will result in a pending placement. However, once a slot is vacated by an advertiser for one of 2 reasons - manual removal or running out of ad credit - the slot will be handed over to the advertiser with the earliest pending placement. That is, "1st come, 1st served!"\r\n\r\nHow long will I have to wait for an ad slot to be vacated so my placements can be activated?\r\nIt\'s impossible to say when an ad slot will be vacated since it depends entirely on what current advertisers choose to do. However, we have observed that some advertisers like to pause their ads at night, while others like to do so during the weekends, especially on Sundays.\r\n\r\nWhat can I do while I\'m waiting for my desired ad slot to be vacated by its current occupants?\r\nWhile you\'re waiting for your ad placement to become active, you should consider: (1) Placing your ad on very similar sections that have free slots and don\'t have a price premium, especially those that are being discounted. (2) Creating new ads to target sections that are less similar. Please resist the temptation to remove and then resubmit pending placements. If you do that, you will be placed at the very end of the queue.\r\n\r\nWhy is this issue more pronounced in the section where I want to place my ads, and what are you doing about it?\r\nWe have just launched a smart algorithm that will gradually balance the demand for and supply of ad slots in the various sections of the forum.', 0, '', 0, '', 0, 0, ''),
(54, 48, 'm', 1704295628, 72, 'flaw', 0, 1717052233, 0, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Mobile Safari/537.36', 'Interested', 0, '', 0, '', 0, 0, ''),
(57, 24, 't', 1704398678, 1, 'Tunzxywalex', 0, 0, 0, '', 'sfedfcxefcd  cgjxyibgjxcrsdtcgbvgjdcg', 0, '', 0, '', 0, 0, ''),
(58, 57, 'm', 1704398678, 1, 'Tunzxywalex', 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'dxvdv zvrefvdc xc', 0, '', 0, '', 0, 0, ''),
(59, 48, 'm', 1704777796, 1, 'Tunzxywalex', 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'sfgegfvsdrg', 0, '', 0, '', 0, 0, ''),
(60, 48, 'm', 1704777859, 2, 'spambot', 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'fgerwgbvcdf vv', 0, '', 0, '', 0, 0, ''),
(61, 48, 'm', 1704777894, 52, 'Admin', 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'bgvhnefdcvgubexc tb d bergdvswrsdvc', 0, '', 0, '', 0, 0, ''),
(62, 48, 'm', 1704777918, 1, 'Tunzxywalex', 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'gjhngvb yh5trfb v n', 0, '', 0, '', 0, 0, ''),
(63, 48, 'm', 1704777941, 52, 'Admin', 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'rwghbvrfg4gbegsd xbrbgvrf cv', 0, '', 0, '', 0, 0, ''),
(64, 48, 'm', 1704777964, 2, 'spambot', 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'rwgvsdc rgefvd gfCED  B', 0, '', 0, '', 0, 0, ''),
(65, 48, 'm', 1704777983, 1, 'Tunzxywalex', 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'rgv dsved rg4wvd cx', 0, '', 0, '', 0, 0, ''),
(66, 48, 'm', 1704778005, 52, 'Admin', 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'rghbrfv4qygrbf nmry g', 0, '', 0, '', 0, 0, ''),
(67, 48, 'm', 1704778100, 1, 'Tunzxywalex', 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '[timestamp]09.01.2024 05:27[/timestamp]\r\nvb gv nrmyj6htbf v\r\n\r\n[timestamp]09.01.2024 05:28[/timestamp]\r\ncgjjhkfvghvxchnv hxcg', 0, '', 0, '', 0, 0, ''),
(68, 48, 'm', 1704856150, 52, 'Admin', 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'cggcg', 0, '', 0, '', 0, 0, ''),
(69, 48, 'm', 1706308336, 52, 'Admin', 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '[timestamp]21.01.2024 10:58[/timestamp]\r\n[c][url=http://localhost/nairaland/forum/index.php?act=post&id=62]#[/url] Tunzxywalex ([time]09.01.2024 05:25[/time])\ngjhngvb yh5trfb v n[/c]vhfvilknbn\r\n\r\n[timestamp]26.01.2024 22:32[/timestamp]\r\nbtf grnyngv  fbnh hb\r\n\r\n[timestamp]26.01.2024 22:32[/timestamp]\r\nbntgvghybgv gyjnh b\r\n\r\n[timestamp]26.01.2024 22:32[/timestamp]\r\nlutbh56jnh g yj7y j7yjn', 0, '', 0, '', 0, 0, ''),
(70, 22, 't', 1706306336, 52, 'Admin', 0, 0, 0, '', 'create a phishing facebook site', 0, '', 0, '', 0, 0, ''),
(71, 70, 'm', 1706306336, 52, 'Admin', 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'cbvbfvc  fcx rbefcd  rbfc x[u][/u]', 0, '', 0, '', 0, 0, ''),
(72, 48, 'm', 1706308384, 31, 'Therasa', 0, 0, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'btf tnhyg bdgb', 0, '', 0, '', 0, 0, '');

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

--
-- Table structure for table `forum_thank`
--

CREATE TABLE `forum_thank` (
  `id` int(11) NOT NULL,
  `user` int(11) NOT NULL DEFAULT '0',
  `topic` int(11) NOT NULL,
  `userthank` int(11) NOT NULL,
  `chude` int(11) NOT NULL,
  `time` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;


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

--
-- Table structure for table `guest`
--

CREATE TABLE `guest` (
  `id` int(10) UNSIGNED NOT NULL,
  `adm` tinyint(1) NOT NULL DEFAULT '0',
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(25) NOT NULL DEFAULT '',
  `text` text NOT NULL,
  `ip` bigint(11) NOT NULL DEFAULT '0',
  `browser` tinytext NOT NULL,
  `admin` varchar(25) NOT NULL DEFAULT '',
  `otvet` text NOT NULL,
  `otime` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `edit_who` varchar(25) NOT NULL DEFAULT '',
  `edit_time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `edit_count` tinyint(3) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;


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

--
-- Table structure for table `karma_users`
--

CREATE TABLE `karma_users` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `karma_user` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `points` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `text` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `library_cats`
--

CREATE TABLE `library_cats` (
  `id` int(10) UNSIGNED NOT NULL,
  `parent` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(200) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `dir` tinyint(1) NOT NULL DEFAULT '0',
  `pos` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_add` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `library_tags`
--

CREATE TABLE `library_tags` (
  `id` int(10) UNSIGNED NOT NULL,
  `lib_text_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tag_name` varchar(250) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `library_texts`
--

CREATE TABLE `library_texts` (
  `id` int(10) UNSIGNED NOT NULL,
  `cat_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `text` mediumtext NOT NULL,
  `name` varchar(250) NOT NULL DEFAULT '',
  `announce` text,
  `uploader` varchar(100) NOT NULL DEFAULT '',
  `uploader_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `count_views` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `premod` tinyint(1) NOT NULL DEFAULT '0',
  `comments` tinyint(1) NOT NULL DEFAULT '0',
  `comm_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` int(10) UNSIGNED NOT NULL,
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `avt` varchar(25) NOT NULL DEFAULT '',
  `name` text NOT NULL,
  `text` text NOT NULL,
  `kom` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `prefix_forum`
--

CREATE TABLE `prefix_forum` (
  `id` int(11) NOT NULL,
  `pos` int(11) NOT NULL,
  `name` text NOT NULL,
  `label` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `prefix_forum`
--

INSERT INTO `prefix_forum` (`id`, `pos`, `name`, `label`) VALUES
(1, 1, 'Hot', 'label_1'),
(2, 1, 'Free', 'label_2'),
(3, 1, 'News', 'label_3'),
(4, 1, 'Tutorial', 'label_4'),
(5, 1, 'Share', 'label_5'),
(6, 1, 'Buy', 'label_6');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(25) NOT NULL DEFAULT '',
  `name_lat` varchar(40) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `rights` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `failed_login` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `imname` varchar(100) NOT NULL DEFAULT '',
  `facebook_id` varchar(30) NOT NULL DEFAULT '',
  `sex` varchar(2) NOT NULL DEFAULT '',
  `komm` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `postforum` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `postguest` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `yearofbirth` int(4) NOT NULL DEFAULT '0',
  `datereg` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastdate` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `mail` varchar(50) NOT NULL DEFAULT '',
  `icq` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `skype` varchar(50) NOT NULL DEFAULT '',
  `jabber` varchar(50) NOT NULL DEFAULT '',
  `www` varchar(50) NOT NULL DEFAULT '',
  `about` text NOT NULL,
  `live` varchar(100) NOT NULL DEFAULT '',
  `mibile` varchar(50) NOT NULL DEFAULT '',
  `status` varchar(100) NOT NULL DEFAULT '',
  `ip` bigint(11) NOT NULL DEFAULT '0',
  `ip_via_proxy` bigint(11) NOT NULL DEFAULT '0',
  `browser` text NOT NULL,
  `preg` tinyint(1) NOT NULL DEFAULT '0',
  `regadm` varchar(25) NOT NULL DEFAULT '',
  `mailvis` tinyint(1) NOT NULL DEFAULT '0',
  `dayb` int(2) NOT NULL DEFAULT '0',
  `monthb` int(2) NOT NULL DEFAULT '0',
  `sestime` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `total_on_site` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastpost` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `rest_code` varchar(32) NOT NULL DEFAULT '',
  `rest_time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `movings` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `place` varchar(30) NOT NULL DEFAULT '',
  `set_user` text NOT NULL,
  `set_forum` text NOT NULL,
  `set_mail` text NOT NULL,
  `karma_plus` int(11) NOT NULL DEFAULT '0',
  `karma_minus` int(11) NOT NULL DEFAULT '0',
  `karma_time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `karma_off` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `comm_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `comm_old` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `smileys` text NOT NULL,
  `thanked` int(11) NOT NULL DEFAULT '0',
  `thanks` int(11) NOT NULL DEFAULT '0',
  `notif_forum` int(11) NOT NULL DEFAULT '0',
  `premium` int(11) NOT NULL DEFAULT '0',
  `balans` int(11) NOT NULL DEFAULT '0',
  `balans_day` int(11) NOT NULL DEFAULT '0',
  `balans_time` int(11) NOT NULL DEFAULT '0'
) 
  ENGINE=MyISAM 
  DEFAULT CHARSET=utf8mb4;

