-- phpMyAdmin SQL Dump
-- version 4.0.10.7
-- http://www.phpmyadmin.net
--
-- Anamakine: localhost:3306
-- Üretim Zamanı: 04 Kas 2015, 22:02:17
-- Sunucu sürümü: 5.5.46-cll
-- PHP Sürümü: 5.4.31

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


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

--
-- Veritabanı: `sohbetsi_demo`
--

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

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

CREATE TABLE IF NOT EXISTS `addons` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `banned` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ip` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `chat` (
  `post_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(5) NOT NULL,
  `post_date` int(10) NOT NULL,
  `post_time` varchar(6) NOT NULL,
  `post_user` varchar(16) NOT NULL,
  `post_message` text NOT NULL,
  `post_color` varchar(12) NOT NULL,
  `post_roomid` int(6) NOT NULL,
  `type` varchar(10) NOT NULL,
  `post_target` varchar(16) NOT NULL,
  `avatar` varchar(40) NOT NULL,
  PRIMARY KEY (`post_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=46 ;

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

INSERT INTO `chat` (`post_id`, `user_id`, `post_date`, `post_time`, `post_user`, `post_message`, `post_color`, `post_roomid`, `type`, `post_target`, `avatar`) VALUES
(18, 1, 1446068464, '00:41', 'Root', ':turkiyem: ', 'sadmin', 4, 'public', '', 'Root24942793_tumb.jpg'),
(28, 999999, 1446655627, '19:47', 'Sistem', 'Root kullanÄ±cÄ±sÄ± sohbetten ayrÄ±ldÄ±', 'bold', 1, 'system', '', 'default_system_tumb.png'),
(29, 999999, 1446655643, '19:47', 'Sistem', 'Lokman  kullanÄ±cÄ±sÄ± sohbete giriÅŸ yaptÄ±', 'bold', 1, 'system', '', 'default_system_tumb.png'),
(30, 1, 1446655662, '19:47', 'Sistem', 'root  kullanÄ±cÄ±sÄ± sohbete giriÅŸ yaptÄ±', 'bold', 1, 'system', '', 'default_system_tumb.png'),
(31, 31, 1446655663, '19:47', 'Lokman', ':admin: ', 'guest', 1, 'public', '', 'default_avatar_tumb.png'),
(32, 1, 1446655670, '19:47', 'Root', 'hi ', 'sadmin', 1, 'public', '', 'Root24942793_tumb.jpg'),
(33, 1, 1446655680, '19:48', 'Root', ':bozkurt: ', 'sadmin', 1, 'public', '', 'Root24942793_tumb.jpg'),
(34, 31, 1446655688, '19:48', 'Lokman', 'hi ', 'guest', 1, 'public', '', 'default_avatar_tumb.png'),
(35, 1, 1446655712, '19:48', 'Root', 'How are you? ', 'sadmin', 1, 'public', '', 'Root24942793_tumb.jpg'),
(36, 31, 1446655718, '19:48', 'Lokman', 'thanks ', 'guest', 1, 'public', '', 'default_avatar_tumb.png'),
(37, 31, 1446655723, '19:48', 'Lokman', 'currently broadcasting radio ', 'guest', 1, 'public', '', 'default_avatar_tumb.png'),
(38, 1, 1446655728, '19:48', 'Root', 'Emrah? ', 'sadmin', 1, 'public', '', 'Root24942793_tumb.jpg'),
(39, 31, 1446655733, '19:48', 'Lokman', 'yes ', 'guest', 1, 'public', '', 'default_avatar_tumb.png'),
(40, 1, 1446655733, '19:48', 'Root', 'Right? ', 'sadmin', 1, 'public', '', 'Root24942793_tumb.jpg'),
(41, 1, 1446655739, '19:48', 'Root', 'Okay good ', 'sadmin', 1, 'public', '', 'Root24942793_tumb.jpg'),
(42, 1, 1446655801, '19:50', 'Root', 'Is it useful for all users? ', 'sadmin', 1, 'public', '', 'Root24942793_tumb.jpg'),
(43, 31, 1446655819, '19:50', 'Lokman', 'yes ', 'guest', 1, 'public', '', 'default_avatar_tumb.png'),
(44, 1, 1446666068, '22:41', 'Root', 'gghgfh ', 'sadmin', 1, 'public', '', 'Root24942793_tumb.jpg'),
(45, 999999, 1446666420, '22:47', 'Sistem', 'Emrah  kullanÄ±cÄ±sÄ± sohbete giriÅŸ yaptÄ±', 'bold', 1, 'system', '', 'default_system_tumb.png');

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

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

CREATE TABLE IF NOT EXISTS `filter` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `word` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `friends` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `hunter` varchar(50) NOT NULL,
  `target` varchar(50) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `friends` (`id`, `hunter`, `target`, `status`) VALUES
(1, 'Reis', 'Root', 1);

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

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

CREATE TABLE IF NOT EXISTS `player` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `use_player` int(1) NOT NULL DEFAULT '0',
  `player_status` int(1) NOT NULL DEFAULT '1',
  `player_url` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `player` (`id`, `use_player`, `player_status`, `player_url`) VALUES
(1, 1, 1, 'http://46.20.3.204/;stream.mp3');

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

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

CREATE TABLE IF NOT EXISTS `private` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `time` int(13) NOT NULL,
  `message` text NOT NULL,
  `hunter` varchar(20) NOT NULL,
  `target` varchar(20) NOT NULL,
  `status` int(1) NOT NULL,
  `target_color` varchar(20) NOT NULL,
  `hunter_color` varchar(20) NOT NULL,
  `view` int(1) NOT NULL DEFAULT '0',
  `avatar` varchar(40) NOT NULL,
  `hunter_guest` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=170 ;

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

INSERT INTO `private` (`id`, `time`, `message`, `hunter`, `target`, `status`, `target_color`, `hunter_color`, `view`, `avatar`, `hunter_guest`) VALUES
(165, 1446475608, 'HoÅŸgeldiniz...', 'Sistem', 'DegisimPanel', 1, 'user', 'system', 0, 'default_system_tumb.png', 0),
(166, 1446540997, 'HoÅŸgeldiniz...', 'Sistem', 'SohbetSistem', 3, 'user', 'system', 1, 'default_system_tumb.png', 0),
(167, 1446655643, 'HoÅŸgeldiniz...', 'Sistem', 'Lokman', 1, 'user', 'system', 0, 'default_system_tumb.png', 0),
(168, 1446665468, 'hi ', 'Lokman', 'Root', 0, 'sadmin', 'guest', 0, 'default_avatar_tumb.png', 1),
(169, 1446666420, 'HoÅŸgeldiniz...', 'Sistem', 'Emrah', 1, 'user', 'system', 1, 'default_system_tumb.png', 0);

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

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

CREATE TABLE IF NOT EXISTS `rooms` (
  `room_id` int(10) NOT NULL AUTO_INCREMENT,
  `room_name` varchar(40) NOT NULL,
  `topic` text NOT NULL,
  `access` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`room_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

INSERT INTO `rooms` (`room_id`, `room_name`, `topic`, `access`) VALUES
(1, 'SohbetSistem', 'Mobil Sohbet Sistemleri - <span class="sub_color2">Root</span>', 1),
(2, 'YÃ¶netim', '', 4),
(3, 'Lobi', '', 1),
(4, 'Sohbet', '', 1);

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

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

CREATE TABLE IF NOT EXISTS `setting` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL DEFAULT 'Boomchat',
  `registration` int(1) NOT NULL DEFAULT '1',
  `maintenance` int(1) NOT NULL DEFAULT '1',
  `flood_delay` int(4) NOT NULL DEFAULT '300',
  `mute_delay` int(10) NOT NULL DEFAULT '86400',
  `away` int(6) NOT NULL DEFAULT '900',
  `gone` int(10) NOT NULL DEFAULT '86400',
  `default_theme` varchar(15) NOT NULL DEFAULT 'Gray',
  `allow_theme` int(1) NOT NULL DEFAULT '0',
  `allow_link` int(1) NOT NULL DEFAULT '0',
  `chat_history` int(3) NOT NULL DEFAULT '20',
  `log_history` int(4) NOT NULL DEFAULT '100',
  `data_delete` int(2) NOT NULL DEFAULT '1',
  `max_password` int(2) NOT NULL DEFAULT '30',
  `max_username` int(2) NOT NULL DEFAULT '16',
  `max_message` int(3) NOT NULL DEFAULT '300',
  `max_avatar` int(4) NOT NULL DEFAULT '200',
  `hosting` int(1) NOT NULL DEFAULT '1',
  `max_host` int(11) NOT NULL DEFAULT '5',
  `file_weight` int(5) NOT NULL DEFAULT '2',
  `domain` varchar(100) NOT NULL DEFAULT 'yourdomainhere.net',
  `emoticon` int(1) NOT NULL DEFAULT '1',
  `allow_private` int(1) NOT NULL DEFAULT '1',
  `allow_history` int(1) NOT NULL DEFAULT '1',
  `allow_image` int(1) NOT NULL DEFAULT '4',
  `version` int(1) NOT NULL DEFAULT '60',
  `language` varchar(20) NOT NULL DEFAULT 'English',
  `ads_delay` int(3) NOT NULL DEFAULT '30',
  `ads_time` int(10) NOT NULL DEFAULT '0',
  `ads_count` int(1) NOT NULL DEFAULT '1',
  `ads_stop` int(1) NOT NULL DEFAULT '0',
  `allow_ads` int(1) NOT NULL DEFAULT '0',
  `ads_select` int(1) NOT NULL DEFAULT '1',
  `orientation` int(1) NOT NULL DEFAULT '1',
  `welcome` int(1) NOT NULL DEFAULT '0',
  `guest` int(8) NOT NULL DEFAULT '1',
  `allow_guest` int(1) NOT NULL DEFAULT '0',
  `guest_chat` int(1) NOT NULL DEFAULT '0',
  `guest_clear` int(8) NOT NULL DEFAULT '3600',
  `activation` int(1) NOT NULL DEFAULT '0',
  `cookie_ban` int(1) NOT NULL DEFAULT '0',
  `allow_email` int(1) NOT NULL DEFAULT '1',
  `chat_speed` int(1) NOT NULL DEFAULT '2',
  `global_sound` int(1) NOT NULL DEFAULT '1',
  `silent_mode` int(1) NOT NULL DEFAULT '0',
  `show_topic` int(1) NOT NULL DEFAULT '1',
  `private_style` int(1) NOT NULL DEFAULT '1',
  `welcome_login_title` varchar(40) NOT NULL DEFAULT 'Chat news',
  `timezone` varchar(60) NOT NULL DEFAULT 'America/Montreal',
  `welcome_login` varchar(300) NOT NULL DEFAULT 'Welcome to Boomchat you can change this message in your setting panel.',
  `welcome_chat` varchar(500) NOT NULL DEFAULT 'Welcome new member please be respectfull with other users and keep conversation clean enjoy your chat.',
  `min_age` int(2) NOT NULL DEFAULT '14',
  `full_width` int(1) NOT NULL DEFAULT '0',
  `show_avatar` int(1) NOT NULL DEFAULT '1',
  `full_form` int(1) NOT NULL DEFAULT '0',
  `rules` int(1) NOT NULL DEFAULT '0',
  `allow_logs` int(1) NOT NULL DEFAULT '1',
  `full_sound` int(1) NOT NULL DEFAULT '0',
  `rtl` int(1) NOT NULL DEFAULT '0',
  `allow_colors` int(1) NOT NULL DEFAULT '1',
  `allow_avatar` int(1) NOT NULL DEFAULT '1',
  `allow_friend` int(1) NOT NULL DEFAULT '1',
  `allow_ignore` int(1) NOT NULL DEFAULT '1',
  `allow_username` int(1) NOT NULL DEFAULT '2',
  `custom_count` int(1) NOT NULL DEFAULT '0',
  `custom1` varchar(100) NOT NULL DEFAULT 'Custom1',
  `custom2` varchar(100) NOT NULL DEFAULT 'Custom2',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `setting` (`id`, `title`, `registration`, `maintenance`, `flood_delay`, `mute_delay`, `away`, `gone`, `default_theme`, `allow_theme`, `allow_link`, `chat_history`, `log_history`, `data_delete`, `max_password`, `max_username`, `max_message`, `max_avatar`, `hosting`, `max_host`, `file_weight`, `domain`, `emoticon`, `allow_private`, `allow_history`, `allow_image`, `version`, `language`, `ads_delay`, `ads_time`, `ads_count`, `ads_stop`, `allow_ads`, `ads_select`, `orientation`, `welcome`, `guest`, `allow_guest`, `guest_chat`, `guest_clear`, `activation`, `cookie_ban`, `allow_email`, `chat_speed`, `global_sound`, `silent_mode`, `show_topic`, `private_style`, `welcome_login_title`, `timezone`, `welcome_login`, `welcome_chat`, `min_age`, `full_width`, `show_avatar`, `full_form`, `rules`, `allow_logs`, `full_sound`, `rtl`, `allow_colors`, `allow_avatar`, `allow_friend`, `allow_ignore`, `allow_username`, `custom_count`, `custom1`, `custom2`) VALUES
(1, 'Sohbet Sistem', 1, 1, 300, 86400, 900, 86400, 'Blue', 1, 1, 20, 100, 1, 30, 16, 300, 200, 1, 5, 2, 'http://www.sohbetsistem.com/demo', 1, 1, 1, 4, 60, 'Turkish', 30, 1445732238, 1, 0, 0, 2, 2, 1, 42, 1, 1, 1800, 0, 1, 0, 4, 23, 0, 1, 1, 'HoÅŸgeldiniz !', 'Europe/Istanbul', 'Sohbet Sistem v1.0 Mobil uyumlu sohbet sistemi yayÄ±nda !', 'HoÅŸgeldiniz...', 14, 1, 1, 0, 0, 1, 0, 0, 1, 1, 1, 1, 2, 0, 'Custom1', 'Custom2');

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

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

CREATE TABLE IF NOT EXISTS `theme` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

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

INSERT INTO `theme` (`id`, `name`) VALUES
(1, 'Blue'),
(2, 'Corporate'),
(3, 'Default'),
(4, 'Dark'),
(5, 'Fancy_gold'),
(6, 'Gray'),
(7, 'Lite'),
(8, 'Lite_blue'),
(9, 'Midnight_cherry'),
(10, 'Pinky_winky'),
(11, 'Red');

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `user_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(16) NOT NULL,
  `old_name` varchar(30) NOT NULL DEFAULT 'e',
  `user_password` varchar(60) NOT NULL,
  `user_email` varchar(80) NOT NULL,
  `user_ip` varchar(30) NOT NULL,
  `user_join` int(12) NOT NULL,
  `last_action` int(10) NOT NULL,
  `last_message` varchar(500) NOT NULL,
  `user_status` int(1) NOT NULL DEFAULT '1',
  `user_action` int(1) NOT NULL DEFAULT '1',
  `user_color` varchar(10) NOT NULL DEFAULT 'user',
  `user_rank` int(1) NOT NULL DEFAULT '1',
  `user_access` int(1) NOT NULL DEFAULT '4',
  `user_roomid` int(6) NOT NULL DEFAULT '1',
  `user_kick` text NOT NULL,
  `user_mute` varchar(16) NOT NULL,
  `mute_time` int(12) NOT NULL,
  `user_flood` int(1) NOT NULL,
  `user_theme` varchar(16) NOT NULL DEFAULT 'Gray',
  `user_sex` int(1) NOT NULL DEFAULT '0',
  `user_age` int(2) NOT NULL DEFAULT '0',
  `user_description` text NOT NULL,
  `user_avatar` varchar(50) NOT NULL DEFAULT 'default_avatar.png',
  `alt_name` varchar(100) NOT NULL,
  `upload_count` int(11) NOT NULL DEFAULT '0',
  `upload_access` int(11) NOT NULL DEFAULT '1',
  `user_sound` int(1) NOT NULL DEFAULT '2',
  `temp_pass` varchar(40) NOT NULL DEFAULT '0',
  `temp_time` int(10) NOT NULL DEFAULT '0',
  `user_tumb` varchar(100) NOT NULL DEFAULT 'default_avatar_tumb.png',
  `guest` int(1) NOT NULL DEFAULT '0',
  `verified` int(1) NOT NULL DEFAULT '1',
  `valid_key` varchar(64) NOT NULL,
  `user_ignore` text NOT NULL,
  `first_check` int(10) NOT NULL DEFAULT '0',
  `join_chat` int(10) NOT NULL DEFAULT '0',
  `email_count` int(1) NOT NULL DEFAULT '0',
  `user_friends` text NOT NULL,
  `country` varchar(100) NOT NULL,
  `region` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `count` int(10) NOT NULL DEFAULT '0',
  `custom1` varchar(250) NOT NULL DEFAULT '',
  `custom2` varchar(250) NOT NULL DEFAULT '',
  `session_id` int(10) NOT NULL DEFAULT '1',
  `facebook` varchar(120) NOT NULL DEFAULT '',
  `twitter` varchar(120) NOT NULL DEFAULT '',
  `pinterest` varchar(120) NOT NULL DEFAULT '',
  `google` varchar(120) NOT NULL DEFAULT '',
  `youtube` varchar(120) NOT NULL DEFAULT '',
  `instagram` varchar(120) NOT NULL DEFAULT '',
  `linkedin` varchar(120) NOT NULL DEFAULT '',
  `tumblr` varchar(120) NOT NULL DEFAULT '',
  `flickr` varchar(120) NOT NULL DEFAULT '',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;

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

INSERT INTO `users` (`user_id`, `user_name`, `old_name`, `user_password`, `user_email`, `user_ip`, `user_join`, `last_action`, `last_message`, `user_status`, `user_action`, `user_color`, `user_rank`, `user_access`, `user_roomid`, `user_kick`, `user_mute`, `mute_time`, `user_flood`, `user_theme`, `user_sex`, `user_age`, `user_description`, `user_avatar`, `alt_name`, `upload_count`, `upload_access`, `user_sound`, `temp_pass`, `temp_time`, `user_tumb`, `guest`, `verified`, `valid_key`, `user_ignore`, `first_check`, `join_chat`, `email_count`, `user_friends`, `country`, `region`, `city`, `count`, `custom1`, `custom2`, `session_id`, `facebook`, `twitter`, `pinterest`, `google`, `youtube`, `instagram`, `linkedin`, `tumblr`, `flickr`) VALUES
(1, 'Root', 'admin', '3a67ea850395d1007cb73a2789e8123fe4ba6ade', 'bluebilisim@gmail.com', '115.118.74.240', 1, 1446666068, 'gghgfh ', 2, 1, 'sadmin', 5, 4, 1, '', '', 0, 0, 'Gray', 1, 29, 'Biz YaptÄ±k Oldu Åžimdi Test Edin !', 'Root24942793.jpg', '', 2, 1, 2, '0', 0, 'Root24942793_tumb.jpg', 0, 1, '', '', 1446666068, 6, 0, '', 'Turkey', 'Gaziantep', '', 706, '', '', 14, '', '', '', '', '', '', '', '', ''),
(2, 'demo', 'e', '769b81030909620fc9d51abce6aa32ed3d8c5f3e', 'demo@sohbetsistem.com', '78.166.152.97', 1, 1445722008, 'bayilik bile dagÄ±tÄ±rÄ±m :D ', 3, 1, 'user', 1, 4, 1, '', '', 0, 0, 'Lite_blue', 0, 0, '', 'demo65179240.jpg', '', 0, 1, 2, '0', 0, 'demo65179240_tumb.jpg', 0, 1, '', '', 1, 1, 0, '', '', '', '', 87, '', '', 4, '', '', '', '', '', '', '', '', ''),
(11, 'Reis', 'mavi', '3a67ea850395d1007cb73a2789e8123fe4ba6ade', 'mavi@sohbetsistem.com', '195.155.245.159', 1, 1445970638, 'bakcaz :D ', 3, 1, 'sadmin', 5, 4, 1, '', '', 0, 0, 'Corporate', 1, 24, '', 'mavi15386370.png', '', 1, 1, 2, '0', 0, 'mavi15386370_tumb.png', 0, 1, '', '', 1, 5, 0, '', 'Turkey', 'Samsun', '', 664, '', '', 6, '', '', '', '', '', '', '', '', ''),
(26, 'blacklotus', 'e', '6c691de7c810be43d74713f59b04e0acb1c144fd', 'blacklotus@gmail.com', '88.231.81.187', 1, 1445802672, ':) ', 3, 1, 'user', 1, 4, 1, '', '', 0, 0, 'Blue', 0, 0, '', 'default_avatar.png', '', 0, 1, 2, '0', 0, 'default_avatar_tumb.png', 0, 1, '', '', 1, 5, 0, '', '', '', '', 5, '', '', 2, '', '', '', '', '', '', '', '', ''),
(32, 'Emrah', 'e', '27ba9ea053989145c05ba7a0c822913c4df0dc2f', 'guest1000210002@guest.com', '88.245.236.42', 1446666421, 1446667126, '', 1, 1, 'guest', 1, 4, 1, '', '', 0, 0, 'Blue', 0, 0, '', 'default_avatar.png', '', 0, 1, 2, '0', 0, 'default_avatar_tumb.png', 1, 1, '', '', 1446667129, 5, 0, '', '', '', '', 0, '', '', 1, '', '', '', '', '', '', '', '', '');

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