· 11 years ago · Aug 27, 2015, 09:59 PM
1-- phpMyAdmin SQL Dump
2-- version 3.4.5
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Erstellungszeit: 28. Aug 2015 um 08:57
7-- Server Version: 5.5.16
8-- PHP-Version: 5.3.8
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Datenbank: `dobba`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Tabellenstruktur für Tabelle `users`
27--
28
29CREATE TABLE IF NOT EXISTS `users` (
30 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
31 `username` varchar(50) NOT NULL,
32 `real_name` varchar(100) NOT NULL DEFAULT '',
33 `password` varchar(50) NOT NULL,
34 `mail` varchar(50) NOT NULL DEFAULT 'defaultuser@meth0d.org',
35 `auth_ticket` text NOT NULL,
36 `rank` int(11) unsigned NOT NULL DEFAULT '1',
37 `credits` int(11) NOT NULL DEFAULT '50000',
38 `vip_points` int(11) NOT NULL DEFAULT '0',
39 `activity_points` int(11) NOT NULL DEFAULT '0',
40 `activity_points_lastupdate` double NOT NULL DEFAULT '0',
41 `look` varchar(255) NOT NULL DEFAULT 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62',
42 `gender` enum('M','F') NOT NULL DEFAULT 'M',
43 `motto` varchar(50) NOT NULL,
44 `account_created` varchar(50) NOT NULL,
45 `last_online` varchar(50) NOT NULL,
46 `online` enum('0','1') NOT NULL DEFAULT '0',
47 `ip_last` varchar(120) NOT NULL,
48 `ip_reg` varchar(120) NOT NULL,
49 `home_room` int(10) unsigned NOT NULL DEFAULT '0',
50 `respect` int(11) NOT NULL DEFAULT '0',
51 `daily_respect_points` int(11) NOT NULL DEFAULT '3',
52 `daily_pet_respect_points` int(11) NOT NULL DEFAULT '3',
53 `newbie_status` int(11) NOT NULL DEFAULT '0',
54 `is_muted` enum('0','1') NOT NULL DEFAULT '0',
55 `mutant_penalty` enum('0','1','2') NOT NULL DEFAULT '0',
56 `mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
57 `block_newfriends` enum('0','1') NOT NULL DEFAULT '0',
58 `hide_online` enum('0','1') NOT NULL DEFAULT '0',
59 `hide_inroom` enum('0','1') NOT NULL DEFAULT '0',
60 `mail_verified` varchar(6) NOT NULL DEFAULT '0',
61 `vip` enum('0','1') NOT NULL DEFAULT '0',
62 `volume` int(3) NOT NULL DEFAULT '100',
63 `accept_trading` enum('0','1') NOT NULL DEFAULT '1',
64 `seckey` varchar(999) DEFAULT NULL,
65 PRIMARY KEY (`id`)
66) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
67
68--
69-- Daten für Tabelle `users`
70--
71
72INSERT INTO `users` (`id`, `username`, `real_name`, `password`, `mail`, `auth_ticket`, `rank`, `credits`, `vip_points`, `activity_points`, `activity_points_lastupdate`, `look`, `gender`, `motto`, `account_created`, `last_online`, `online`, `ip_last`, `ip_reg`, `home_room`, `respect`, `daily_respect_points`, `daily_pet_respect_points`, `newbie_status`, `is_muted`, `mutant_penalty`, `mutant_penalty_expire`, `block_newfriends`, `hide_online`, `hide_inroom`, `mail_verified`, `vip`, `volume`, `accept_trading`, `seckey`) VALUES
73(1, 'Shaydie', '', '62658d8d418e71a3fe34590f1d99d3ed', 'shaydiebrugman@hotmail.com', 'RevCMS-304/32a1ca01e2ab9b439dba52d0dc0598fdb', 6, 5685, 1000000000, 250, 1440740888.88076, 'lg-280-110.ch-803-110.hr-831-60.hd-190-28.cc-3158-99.sh-295-104', 'M', 'Technische Manager', '1440734232', '1440742821', '1', '86.95.125.187', '86.95.125.187', 8, 0, 3, 3, 0, '0', '0', 0, '0', '0', '0', '0', '0', 100, '1', 'd41d8cd98f00b204e9800998ecf8427e'),
74(2, 'Messenger', '', 'e6a6ed64c05bc5fb1f75508045b1bf86', 'renzogame1345@hotmail.com', 'RevCMS-441/524a1df6156a502143e2cc036ed8c8278', 7, 5250, 100920, 412, 1440740077.95837, 'hr-165-61.hd-180-2.fa-1201-62.sh-295-62.lg-280-104.ch-3185-73', 'M', 'Nieuw Op Dobba', '1440734272', '1440740589', '0', '178.116.231.29', '178.116.231.29', 0, 0, 3, 3, 0, '0', '0', 0, '0', '0', '0', '0', '0', 100, '1', 'd41d8cd98f00b204e9800998ecf8427e'),
75(3, 'djmoen', '', '74ba120e4f6c371f8a0f684607d4d360', 'djkenroy1999@gmail.com', 'RevCMS-776/9adf0f088e5523045d650bbb08676c7c5', 7, 5767, 220, 430, 1440744834.53897, 'ch-210-102.hd-180-1.lg-270-102.hr-3163-34.sh-290-91', 'M', 'rezo is geil in ik ben de baas', '1440734656', '1440744839', '0', '85.150.49.124', '109.133.14.111', 0, 0, 3, 3, 0, '0', '0', 0, '0', '0', '0', '0', '0', 100, '1', 'd41d8cd98f00b204e9800998ecf8427e'),
76(5, 'darkie', '', '7e90ffa8cef2986b6461d33a5b9fcc75', 'joeytunder@gmail.com', 'RevCMS-869/f667cc226d87e2f6de37c61b7b6707269', 1, 1011, 0, 257, 1440742417.03777, 'ea-3168-96.lg-3078-110.ch-3185-108.hr-3163-1343.hd-180-4.sh-3089-100', 'M', 'joey :)', '1440736467', '1440742865', '0', '84.86.50.31', '84.86.50.31', 0, 0, 3, 3, 0, '0', '0', 0, '0', '0', '0', '0', '0', 100, '1', 'd41d8cd98f00b204e9800998ecf8427e'),
77(11, 'beckham004', '', '74ba120e4f6c371f8a0f684607d4d360', 'quinten87@live.be', 'RevCMS-453/7b356d0edc56a5f89ceb5fd168b292403', 1, 2052, 100, 422, 1440744023.71038, 'lg-3078-108.ch-3185-108.he-1604-62.hr-3163-37.hd-180-1.wa-2003-62.cc-3007-108-62.sh-290-108', 'M', 'Nieuw Op Friends', '1440740475', '1440744261', '0', '107.178.35.175', '109.133.14.111', 0, 0, 3, 3, 0, '0', '0', 0, '0', '0', '0', '0', '0', 100, '1', 'd41d8cd98f00b204e9800998ecf8427e'),
78(6, 'Lolskilz', '', '1139fff2b5a8985f518882028b573102', 'quinten.200@hotmail.com', 'RevCMS-603/9e11409251c982794dbccae1a96389995', 1, 5000, 0, 250, 0, 'hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100', 'M', 'Nieuw Op Dobba', '1440736827', '1440736827', '0', '91.179.146.8', '91.179.146.8', 0, 0, 3, 3, 0, '0', '0', 0, '0', '0', '0', '0', '0', 100, '1', 'd41d8cd98f00b204e9800998ecf8427e'),
79(7, 'Nick', '', '38836d242366b2ab661cb84f5fb174e7', 'hoi@hoin.eew', 'RevCMS-23/441acf57d6328e33664252b8dd2fd3f4a', 1, 5075, 0, 265, 1440737084.83189, 'hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100', 'M', 'Nieuw Op Dobba', '1440737015', '1440737498', '0', '85.150.49.124', '85.150.49.124', 0, 0, 3, 3, 0, '0', '0', 0, '0', '0', '0', '0', '0', 100, '1', 'd41d8cd98f00b204e9800998ecf8427e'),
80(8, 'Emotion', '', '750a525fcb772355b437b914f4c096b5', 'jari.dh@gmail.com', 'RevCMS-20/cf4f2d4c17ee5f13af8fefe4e40b1e694', 1, 15225, 10000, 250, 1440738992.75811, 'ch-3001-73-92.hr-3163-51.hd-190-1.sh-290-62.lg-275-89', 'M', '', '1440737095', '1440739344', '0', '213.119.100.131', '213.119.100.131', 0, 0, 3, 3, 0, '0', '0', 0, '0', '0', '0', '0', '0', 100, '1', 'd41d8cd98f00b204e9800998ecf8427e'),
81(9, 'Pedro', '', '98dae0e08c01f9e64dc3f9650eb5a714', 'Peetjeparkernl@hotmail.com', 'RevCMS-367/f1c440dc9d7c1077b4409acde81f897d1', 1, 13320, 1000000050, 330, 1440740528.4921, 'ea-1402-62.lg-3023-100.ch-3215-93.hr-155-1344.hd-195-1.fa-1206-110.cc-3269-73-73.ca-1813-62.sh-290-93', 'M', 'Nieuw Op Friends', '1440739455', '1440741293', '1', '141.134.241.149', '141.134.241.149', 0, 0, 3, 3, 0, '0', '0', 0, '0', '0', '0', '0', '0', 100, '1', 'd41d8cd98f00b204e9800998ecf8427e'),
82(10, 'Cynthia', '', '16a87b484af7664352e29b41089270c7', 'cynthiamorreels@hotmail.com', 'RevCMS-129/32f1b090fcc9067ada9ff3a6a95c806e2', 1, 5150, 0, 365, 1440740858.84946, 'lg-3023-107.ch-3005-95-108.ea-3168-62.hr-3012-36.sh-3035-95.hd-600-1', 'F', 'renzo is geil ', '1440739805', '1440741316', '0', '178.118.54.138', '178.118.54.138', 0, 0, 3, 3, 0, '0', '0', 0, '0', '0', '0', '0', '0', 100, '1', 'd41d8cd98f00b204e9800998ecf8427e'),
83(12, 'khalidboxer', '', '99ec1019e17895d70b7d407b10ae755b', 'khalidflix@hotmail.com', 'RevCMS-402/b2f75c75c5894822c528c2ed45e8f953c', 1, 5075, 0, 265, 1440741099.09957, 'hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100', 'M', 'Nieuw Op Friends', '1440741023', '1440741159', '0', '87.64.204.117', '87.64.204.117', 0, 0, 3, 3, 0, '0', '0', 0, '0', '0', '0', '0', '0', 100, '1', 'd41d8cd98f00b204e9800998ecf8427e');
84
85/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
86/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
87/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;