· 8 years ago · Feb 14, 2018, 05:28 PM
1-- phpMyAdmin SQL Dump
2-- version 3.4.11.1deb2+deb7u8
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Czas wygenerowania: 14 Lut 2018, 18:25
7-- Wersja serwera: 5.5.59
8-- Wersja PHP: 5.4.45-0+deb7u12
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-- Baza danych: `csgo`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktura tabeli dla tabeli `game1`
27--
28
29CREATE TABLE IF NOT EXISTS `game1` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `userid` varchar(70) NOT NULL,
32 `username` varchar(70) NOT NULL,
33 `item` text,
34 `assetid` varchar(70) NOT NULL,
35 `offerid` varchar(70) NOT NULL,
36 `color` text,
37 `value` text,
38 `avatar` varchar(512) NOT NULL,
39 `image` text NOT NULL,
40 `from` text NOT NULL,
41 `to` text NOT NULL,
42 PRIMARY KEY (`id`)
43) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
44
45--
46-- Zrzut danych tabeli `game1`
47--
48
49INSERT INTO `game1` (`id`, `userid`, `username`, `item`, `assetid`, `offerid`, `color`, `value`, `avatar`, `image`, `from`, `to`) VALUES
50(1, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13545987323', '2914568689', 'D2D2D2', '0.01', 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk', '', ''),
51(2, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13545987408', '2914568689', 'D2D2D2', '0.01', 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk', '', ''),
52(3, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13545987491', '2914568689', 'D2D2D2', '0.01', 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk', '', '');
53
54-- --------------------------------------------------------
55
56--
57-- Struktura tabeli dla tabeli `game2`
58--
59
60CREATE TABLE IF NOT EXISTS `game2` (
61 `id` int(11) NOT NULL AUTO_INCREMENT,
62 `userid` varchar(70) NOT NULL,
63 `username` varchar(70) NOT NULL,
64 `item` text,
65 `assetid` varchar(70) NOT NULL,
66 `offerid` varchar(70) NOT NULL,
67 `color` text,
68 `value` float NOT NULL,
69 `avatar` varchar(512) NOT NULL,
70 `image` text NOT NULL,
71 PRIMARY KEY (`id`)
72) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
73
74--
75-- Zrzut danych tabeli `game2`
76--
77
78INSERT INTO `game2` (`id`, `userid`, `username`, `item`, `assetid`, `offerid`, `color`, `value`, `avatar`, `image`) VALUES
79(1, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546026527', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
80(2, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546026580', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
81(3, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546026659', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
82(4, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546026714', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
83(5, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546026761', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
84(6, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546026840', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
85(7, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546026868', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
86(8, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546026928', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
87(9, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546026978', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
88(10, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546027032', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
89(11, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546027087', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
90(12, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546027132', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
91(13, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546027182', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
92(14, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546027246', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
93(15, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546027285', '2914575617', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk');
94
95-- --------------------------------------------------------
96
97--
98-- Struktura tabeli dla tabeli `game3`
99--
100
101CREATE TABLE IF NOT EXISTS `game3` (
102 `id` int(11) NOT NULL AUTO_INCREMENT,
103 `userid` varchar(70) NOT NULL,
104 `username` varchar(70) NOT NULL,
105 `item` text,
106 `assetid` varchar(70) NOT NULL,
107 `offerid` varchar(70) NOT NULL,
108 `color` text,
109 `value` float NOT NULL,
110 `avatar` varchar(512) NOT NULL,
111 `image` text NOT NULL,
112 PRIMARY KEY (`id`)
113) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
114
115--
116-- Zrzut danych tabeli `game3`
117--
118
119INSERT INTO `game3` (`id`, `userid`, `username`, `item`, `assetid`, `offerid`, `color`, `value`, `avatar`, `image`) VALUES
120(1, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546056825', '2914581828', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
121(2, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546056915', '2914581828', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
122(3, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546057013', '2914581828', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
123(4, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546057055', '2914581828', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
124(5, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546057118', '2914581828', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
125(6, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546057212', '2914581828', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
126(7, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546057336', '2914581828', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
127(8, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546057387', '2914581828', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
128(9, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546057450', '2914581828', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
129(10, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546057529', '2914581828', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
130(11, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546128692', '2914595153', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
131(12, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546128750', '2914595153', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
132(13, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546128810', '2914595153', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
133(14, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546128881', '2914595153', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
134(15, '76561198348150543', 'MerfiK. SkinsProject.pl', 'Glove Case', '13546128933', '2914595153', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
135(16, '76561198089929908', 'Kamilaa ;* Youtubers 2k+', 'Gamma Case', '13546127587', '2914593740', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/4e/4ea283618bbfd94a4f1156a756c95aaa7d1b9964_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFYznarJJjkQ6ovjw4SPlfP3auqEl2oBuJB1j--WoY322QziqkdpZGr3IteLMlhpw4RJCv8'),
136(17, '76561198089929908', 'Kamilaa ;* Youtubers 2k+', 'Falchion Case', '13546127739', '2914593740', 'D2D2D2', 0.04, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/4e/4ea283618bbfd94a4f1156a756c95aaa7d1b9964_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FF8ugPDMIWpAuIq1w4KIlaChZOyFwzgJuZNy3-2T89T0jlC2rhZla2vwIJjVLFHz75yKpg'),
137(18, '76561198089929908', 'Kamilaa ;* Youtubers 2k+', 'Glove Case', '13546127521', '2914593740', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/4e/4ea283618bbfd94a4f1156a756c95aaa7d1b9964_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk'),
138(19, '76561198089929908', 'Kamilaa ;* Youtubers 2k+', 'Gamma Case', '13546127858', '2914593740', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/4e/4ea283618bbfd94a4f1156a756c95aaa7d1b9964_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFYznarJJjkQ6ovjw4SPlfP3auqEl2oBuJB1j--WoY322QziqkdpZGr3IteLMlhpw4RJCv8'),
139(20, '76561198089929908', 'Kamilaa ;* Youtubers 2k+', 'Glove Case', '13546127663', '2914593740', 'D2D2D2', 0.01, 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/4e/4ea283618bbfd94a4f1156a756c95aaa7d1b9964_full.jpg', '-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQNqhpOSV-fRPasw8rsUFJ5KBFZv668FFY1naTMdzwTtNrukteIkqT2MO_Uwz5Q6cYhibyXo4rw2ALsrkRoYjuncNCLMlhpEV4XDTk');
140
141-- --------------------------------------------------------
142
143--
144-- Struktura tabeli dla tabeli `game4`
145--
146
147CREATE TABLE IF NOT EXISTS `game4` (
148 `id` int(11) NOT NULL AUTO_INCREMENT,
149 `userid` varchar(70) NOT NULL,
150 `username` varchar(70) NOT NULL,
151 `item` text,
152 `assetid` varchar(70) NOT NULL,
153 `offerid` varchar(70) NOT NULL,
154 `color` text,
155 `value` float NOT NULL,
156 `avatar` varchar(512) NOT NULL,
157 `image` text NOT NULL,
158 PRIMARY KEY (`id`)
159) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
160
161-- --------------------------------------------------------
162
163--
164-- Struktura tabeli dla tabeli `games`
165--
166
167CREATE TABLE IF NOT EXISTS `games` (
168 `id` int(11) NOT NULL DEFAULT '0',
169 `starttime` int(11) NOT NULL,
170 `cost` text,
171 `winner` varchar(128) NOT NULL,
172 `userid` varchar(70) NOT NULL,
173 `percent` float DEFAULT NULL,
174 `itemsnum` int(11) NOT NULL,
175 `module` text NOT NULL,
176 `hash` varchar(250) NOT NULL,
177 `players` int(11) NOT NULL,
178 PRIMARY KEY (`id`)
179) ENGINE=MyISAM DEFAULT CHARSET=utf8;
180
181--
182-- Zrzut danych tabeli `games`
183--
184
185INSERT INTO `games` (`id`, `starttime`, `cost`, `winner`, `userid`, `percent`, `itemsnum`, `module`, `hash`, `players`) VALUES
186(1, 2147483647, '0.03', 'MerfiK. SkinsProject.pl', '76561198348150543', 100, 3, '0.673483750', 'c4ca4238a0b923820dcc509a6f75849b', 0),
187(2, 2147483647, '0.15', 'MerfiK. SkinsProject.pl', '76561198348150543', 100, 15, '0.701846544', 'c81e728d9d4c2f636f067f89cc14862c', 0),
188(3, 1517069980, '0.23000000000000004', 'MerfiK. SkinsProject.pl', '76561198348150543', 65.22, 20, '0.159376934', 'eccbc87e4b5ce2fe28308fd9f2a7baf3', 0),
189(4, 2147483647, '0', '', '', NULL, 0, '', 'a87ff679a2f3e71d9181a67b7542122c', 0);
190
191-- --------------------------------------------------------
192
193--
194-- Struktura tabeli dla tabeli `info`
195--
196
197CREATE TABLE IF NOT EXISTS `info` (
198 `name` varchar(255) NOT NULL,
199 `value` varchar(255) NOT NULL,
200 PRIMARY KEY (`name`)
201) ENGINE=MyISAM DEFAULT CHARSET=utf8;
202
203--
204-- Zrzut danych tabeli `info`
205--
206
207INSERT INTO `info` (`name`, `value`) VALUES
208('current_game', '4'),
209('state', 'waiting'),
210('rake', '10'),
211('minbet', '0.03'),
212('maxitems', '15'),
213('prake', '7'),
214('srake', '7'),
215('maxbet', '10'),
216('nmsg', '3'),
217('pmsg', '1'),
218('maxritem', '100');
219
220-- --------------------------------------------------------
221
222--
223-- Struktura tabeli dla tabeli `items`
224--
225
226CREATE TABLE IF NOT EXISTS `items` (
227 `id` int(11) NOT NULL AUTO_INCREMENT,
228 `name` text NOT NULL,
229 `cost` text NOT NULL,
230 `lastupdate` text NOT NULL,
231 PRIMARY KEY (`id`)
232) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ;
233
234--
235-- Zrzut danych tabeli `items`
236--
237
238INSERT INTO `items` (`id`, `name`, `cost`, `lastupdate`) VALUES
239(1, 'Chroma%20Case', '0.07', '1454346122'),
240(2, 'Operation%20Phoenix%20Weapon%20Case', '0.07', '1454353607'),
241(3, 'Falchion%20Case', '0.04', '1517069969'),
242(4, 'Revolver%20Case', '0.04', '1454353607'),
243(5, 'Revolver%20Case', '0.04', '1454353607'),
244(6, 'Revolver%20Case', '0.04', '1454353607'),
245(7, 'Falchion%20Case', '0.04', '1517069969'),
246(8, 'P90%20|%20Teardown%20(Field-Tested)', '0.1', '1454353607'),
247(9, 'USP-S%20|%20Forest%20Leaves%20(Field-Tested)', '0.04', '1454353645'),
248(10, 'P90%20|%20Elite%20Build%20(Field-Tested)', '0.09', '1454353645'),
249(11, 'P250%20|%20Boreal%20Forest%20(Well-Worn)', '0.02', '1454353645'),
250(12, 'Operation%20Breakout%20Weapon%20Case', '0.03', '1454353646'),
251(13, 'AWP%20|%20Safari%20Mesh%20(Field-Tested)', '0.13', '1454354439'),
252(14, 'Desert%20Eagle%20|%20Bronze%20Deco%20(Field-Tested)', '0.09', '1454354439'),
253(15, 'MP7%20|%20Armor%20Core%20(Field-Tested)', '0.08', '1454354439'),
254(16, 'SSG%2008%20|%20Abyss%20(Field-Tested)', '0.1', '1454354439'),
255(17, 'Chroma%202%20Case', '0.13', '1454354473'),
256(18, 'Chroma%202%20Case', '0.13', '1454354473'),
257(19, 'SCAR-20%20|%20Green%20Marine%20(Minimal%20Wear)', '0.09', '1454354674'),
258(20, 'Glock-18%20|%20Bunsen%20Burner%20(Field-Tested)', '0.11', '1454354674'),
259(21, 'MAC-10%20|%20Rangeen%20(Minimal%20Wear)', '0.1', '1454354674'),
260(22, 'Dual%20Berettas%20|%20Contractor%20(Battle-Scarred)', '0.02', '1454354795'),
261(23, 'Nova%20|%20Sand%20Dune%20(Field-Tested)', '0.02', '1454354795'),
262(24, 'Tec-9%20|%20Sandstorm%20(Field-Tested)', '0.09', '1454354795'),
263(25, 'P2000%20|%20Ivory%20(Well-Worn)', '0.08', '1454354795'),
264(26, 'G3SG1%20|%20VariCamo%20(Field-Tested)', '0.03', '1454354795'),
265(27, 'SSG%2008%20|%20Abyss%20(Battle-Scarred)', '0.09', '1454354795'),
266(28, 'Glove%20Case', '0.01', '1517069492'),
267(29, 'Glove%20Case', '0.01', '1517069492'),
268(30, 'Glove%20Case', '0.01', '1517069492'),
269(31, 'Gamma%20Case', '0.01', '1517069969'),
270(32, 'Gamma%20Case', '0.01', '1517069969'),
271(33, 'Falchion%20Case', '0.04', '1517069969');
272
273-- --------------------------------------------------------
274
275--
276-- Struktura tabeli dla tabeli `messages`
277--
278
279CREATE TABLE IF NOT EXISTS `messages` (
280 `ID` int(11) NOT NULL AUTO_INCREMENT,
281 `type` varchar(300) NOT NULL,
282 `app` int(11) NOT NULL,
283 `userid` varchar(300) NOT NULL,
284 `title` varchar(150) NOT NULL,
285 `msg` varchar(300) CHARACTER SET utf8 NOT NULL,
286 `time` int(11) NOT NULL,
287 `active` int(11) NOT NULL,
288 `delay` int(11) NOT NULL,
289 PRIMARY KEY (`ID`)
290) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
291
292--
293-- Zrzut danych tabeli `messages`
294--
295
296INSERT INTO `messages` (`ID`, `type`, `app`, `userid`, `title`, `msg`, `time`, `active`, `delay`) VALUES
297(1, 'error', 1, '76561198348150543', 'Trade Offer Declined!', 'Reason: Steam Market issues!', 25, 0, 0),
298(2, 'error', 1, '76561198348150543', 'Trade Offer Declined!', 'Reason: Steam Market issues!', 25, 0, 0),
299(3, 'error', 1, '76561198348150543', 'Trade Offer Declined!', 'Reason: Steam Market issues!', 25, 0, 0),
300(4, 'error', 1, '76561198348150543', 'Trade Offer Declined!', 'Reason: Steam Market issues!', 25, 0, 0),
301(5, 'error', 1, '76561198348150543', 'Trade Offer Declined!', 'Reason: Minimum deposit value: $0.03', 25, 0, 0),
302(6, 'success', 0, '76561198348150543', 'Trade Offer Accepted (Game #1)!', 'We wish you Good luck and happy betting!', 25, 0, 0),
303(7, 'success', 0, '76561198348150543', 'Congratulations!', 'You won $0.03 in Game #1 with a 100% chance!', 10, 0, 1517069601),
304(8, 'success', 0, '76561198348150543', 'Trade Offer Accepted (Game #2)!', 'We wish you Good luck and happy betting!', 25, 0, 0),
305(9, 'success', 0, '76561198348150543', 'Congratulations!', 'You won $0.15 in Game #2 with a 100% chance!', 10, 0, 1517069708),
306(10, 'success', 0, '76561198348150543', 'Trade Offer Accepted (Game #3)!', 'We wish you Good luck and happy betting!', 25, 0, 0),
307(11, 'error', 1, '76561198348150543', 'Trade Offer Declined!', 'Reason: You can not deposit more than 15 skins', 25, 0, 0),
308(12, 'success', 0, '76561198348150543', 'Trade Offer Accepted (Game #3)!', 'We wish you Good luck and happy betting!', 25, 0, 0),
309(13, 'success', 0, '76561198089929908', 'Trade Offer Accepted (Game #3)!', 'We wish you Good luck and happy betting!', 25, 0, 0),
310(14, 'success', 0, '76561198089929908', 'GL Next Game!', 'MerfiK. SkinsProject.pl won $0.23000000000000004 in Game #3 with a 65.22% chance!', 10, 0, 1517070110),
311(15, 'success', 0, '76561198348150543', 'Congratulations!', 'You won $0.23000000000000004 in Game #3 with a 65.22% chance!', 10, 0, 1517070110);
312
313-- --------------------------------------------------------
314
315--
316-- Struktura tabeli dla tabeli `online_users`
317--
318
319CREATE TABLE IF NOT EXISTS `online_users` (
320 `session` char(100) NOT NULL DEFAULT '',
321 `time` int(11) NOT NULL DEFAULT '0'
322) ENGINE=MyISAM DEFAULT CHARSET=utf8;
323
324-- --------------------------------------------------------
325
326--
327-- Struktura tabeli dla tabeli `p2game1`
328--
329
330CREATE TABLE IF NOT EXISTS `p2game1` (
331 `id` int(11) NOT NULL AUTO_INCREMENT,
332 `userid` varchar(70) NOT NULL,
333 `username` varchar(70) NOT NULL,
334 `item` text,
335 `assetid` varchar(70) NOT NULL,
336 `offerid` varchar(70) NOT NULL,
337 `color` text,
338 `value` float NOT NULL,
339 `avatar` varchar(512) NOT NULL,
340 `image` text NOT NULL,
341 PRIMARY KEY (`id`)
342) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
343
344-- --------------------------------------------------------
345
346--
347-- Struktura tabeli dla tabeli `p2games`
348--
349
350CREATE TABLE IF NOT EXISTS `p2games` (
351 `id` int(11) NOT NULL DEFAULT '0',
352 `starttime` int(11) NOT NULL,
353 `cost` text CHARACTER SET utf8,
354 `winner` varchar(128) CHARACTER SET utf8 NOT NULL,
355 `userid` varchar(70) CHARACTER SET utf8 NOT NULL,
356 `percent` float DEFAULT NULL,
357 `itemsnum` int(11) NOT NULL,
358 `module` text CHARACTER SET utf8 NOT NULL,
359 `hash` varchar(250) CHARACTER SET utf8 NOT NULL,
360 `players` int(11) NOT NULL,
361 PRIMARY KEY (`id`)
362) ENGINE=InnoDB DEFAULT CHARSET=latin1;
363
364--
365-- Zrzut danych tabeli `p2games`
366--
367
368INSERT INTO `p2games` (`id`, `starttime`, `cost`, `winner`, `userid`, `percent`, `itemsnum`, `module`, `hash`, `players`) VALUES
369(1, 1454292295, '0', '', '', NULL, 0, '', 'c4ca4238a0b923820dcc509a6f75849b', 0);
370
371-- --------------------------------------------------------
372
373--
374-- Struktura tabeli dla tabeli `p2info`
375--
376
377CREATE TABLE IF NOT EXISTS `p2info` (
378 `name` varchar(255) NOT NULL,
379 `value` varchar(255) NOT NULL,
380 PRIMARY KEY (`name`)
381) ENGINE=MyISAM DEFAULT CHARSET=utf8;
382
383--
384-- Zrzut danych tabeli `p2info`
385--
386
387INSERT INTO `p2info` (`name`, `value`) VALUES
388('current_game', '1'),
389('state', 'waiting'),
390('rake', '11'),
391('minbet', '0.5'),
392('maxitems', '10'),
393('prake', '7'),
394('srake', '7'),
395('maxbet', '1000'),
396('nmsg', '3'),
397('pmsg', '1'),
398('maxritem', '50');
399
400-- --------------------------------------------------------
401
402--
403-- Struktura tabeli dla tabeli `p2queue`
404--
405
406CREATE TABLE IF NOT EXISTS `p2queue` (
407 `id` int(11) NOT NULL AUTO_INCREMENT,
408 `userid` varchar(70) NOT NULL,
409 `token` varchar(128) NOT NULL,
410 `items` text CHARACTER SET utf8 NOT NULL,
411 `assetid` varchar(5000) NOT NULL,
412 `status` varchar(45) NOT NULL,
413 PRIMARY KEY (`id`)
414) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
415
416-- --------------------------------------------------------
417
418--
419-- Struktura tabeli dla tabeli `p2rakeitems`
420--
421
422CREATE TABLE IF NOT EXISTS `p2rakeitems` (
423 `id` int(11) NOT NULL AUTO_INCREMENT,
424 `userid` text NOT NULL,
425 `status` varchar(30) NOT NULL,
426 `token` varchar(10) NOT NULL,
427 `items` varchar(5000) CHARACTER SET utf8 NOT NULL,
428 `assetid` varchar(5000) NOT NULL,
429 `value` float NOT NULL,
430 PRIMARY KEY (`id`)
431) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
432
433-- --------------------------------------------------------
434
435--
436-- Struktura tabeli dla tabeli `queue`
437--
438
439CREATE TABLE IF NOT EXISTS `queue` (
440 `id` int(11) NOT NULL AUTO_INCREMENT,
441 `userid` varchar(70) NOT NULL,
442 `token` varchar(128) NOT NULL,
443 `items` text NOT NULL,
444 `assetid` varchar(5000) NOT NULL,
445 `status` varchar(45) NOT NULL,
446 PRIMARY KEY (`id`)
447) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
448
449--
450-- Zrzut danych tabeli `queue`
451--
452
453INSERT INTO `queue` (`id`, `userid`, `token`, `items`, `assetid`, `status`) VALUES
454(1, '76561198348150543', 'wbyO2gSN', 'Glove Case/Glove Case/Glove Case', '13545987323/13545987408/13545987491', 'sent'),
455(2, '76561198348150543', 'wbyO2gSN', 'Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case', '13546026527/13546026580/13546026659/13546026714/13546026761/13546026840/13546026868/13546026928/13546026978/13546027032/13546027087/13546027132/13546027182/13546027246/13546027285', 'sent'),
456(3, '76561198348150543', 'wbyO2gSN', 'Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Glove Case/Gamma Case/Glove Case/Falchion Case', '13546056825/13546056915/13546057013/13546057055/13546057118/13546057212/13546057336/13546057387/13546057450/13546057529/13546128692/13546128750/13546128810/13546128881/13546128933/13546127587/13546127739/13546127663', 'sent');
457
458-- --------------------------------------------------------
459
460--
461-- Struktura tabeli dla tabeli `rakeitems`
462--
463
464CREATE TABLE IF NOT EXISTS `rakeitems` (
465 `id` int(11) NOT NULL AUTO_INCREMENT,
466 `userid` text NOT NULL,
467 `status` varchar(30) NOT NULL,
468 `token` varchar(10) NOT NULL,
469 `items` varchar(5000) CHARACTER SET utf8 NOT NULL,
470 `assetid` varchar(5000) NOT NULL,
471 `value` float NOT NULL,
472 PRIMARY KEY (`id`)
473) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
474
475--
476-- Zrzut danych tabeli `rakeitems`
477--
478
479INSERT INTO `rakeitems` (`id`, `userid`, `status`, `token`, `items`, `assetid`, `value`) VALUES
480(3, '76561198348150543', 'sent', 'wbyO2gSN', 'Glove Case/Gamma Case', '13546127858/13546127521', 0.02);
481
482-- --------------------------------------------------------
483
484--
485-- Struktura tabeli dla tabeli `users`
486--
487
488CREATE TABLE IF NOT EXISTS `users` (
489 `id` int(11) NOT NULL AUTO_INCREMENT,
490 `steamid` varchar(70) NOT NULL,
491 `tlink` varchar(255) DEFAULT NULL,
492 `email` varchar(150) NOT NULL,
493 `won` float DEFAULT '0',
494 `admin` int(11) NOT NULL,
495 `name` varchar(128) NOT NULL,
496 `avatar` varchar(255) NOT NULL,
497 `games` int(11) NOT NULL,
498 `gameswon` int(11) NOT NULL,
499 `premium` int(11) NOT NULL,
500 `puntil` int(11) NOT NULL,
501 `reg` varchar(70) NOT NULL,
502 `login` varchar(70) NOT NULL,
503 `ban` int(11) NOT NULL,
504 `banby` varchar(300) NOT NULL,
505 `bandate` int(11) NOT NULL,
506 `banend` int(11) NOT NULL,
507 `banreason` varchar(300) NOT NULL,
508 `cban` int(11) NOT NULL,
509 `cbanby` varchar(300) NOT NULL,
510 `cbandate` int(11) NOT NULL,
511 `cbanend` int(11) NOT NULL,
512 `cbanreason` varchar(300) NOT NULL,
513 `profile` int(11) NOT NULL DEFAULT '1',
514 `lastmsg` int(11) NOT NULL,
515 `skinssent` int(11) NOT NULL,
516 `profit` float NOT NULL,
517 `lastseen` int(11) NOT NULL,
518 PRIMARY KEY (`id`)
519) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
520
521--
522-- Zrzut danych tabeli `users`
523--
524
525INSERT INTO `users` (`id`, `steamid`, `tlink`, `email`, `won`, `admin`, `name`, `avatar`, `games`, `gameswon`, `premium`, `puntil`, `reg`, `login`, `ban`, `banby`, `bandate`, `banend`, `banreason`, `cban`, `cbanby`, `cbandate`, `cbanend`, `cbanreason`, `profile`, `lastmsg`, `skinssent`, `profit`, `lastseen`) VALUES
526(8, '76561198348150543', 'https://steamcommunity.com/tradeoffer/new/?partner=387884815&token=wbyO2gSN', '', 0.41, 0, 'MerfiK CSGOEminence.com', 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/9d/9d78126798cdc180e8aa2ef011f27078d2c8a7b0_full.jpg', 3, 3, 0, 0, '1516994239', '', 0, '', 0, 0, '', 0, '', 0, 0, '', 1, 0, 33, 0.08, 1518598415),
527(10, '76561198089929908', 'https://steamcommunity.com/tradeoffer/new/?partner=129664180&token=aG0KcuV5', '', 0, 1, 'S3BA SZYMQ.SHOP', 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/dd/dd208b8aa51f273e6bccf0b2310672574af72121_full.jpg', 1, 0, 0, 0, '1516994889', '', 0, '', 0, 0, '', 0, '', 0, 0, '', 1, 0, 5, -0.23, 1518629051);
528
529-- --------------------------------------------------------
530
531--
532-- Struktura tabeli dla tabeli `user_online`
533--
534
535CREATE TABLE IF NOT EXISTS `user_online` (
536 `session` char(100) NOT NULL DEFAULT '',
537 `time` int(11) NOT NULL DEFAULT '0'
538) ENGINE=MyISAM DEFAULT CHARSET=utf8;
539
540--
541-- Zrzut danych tabeli `user_online`
542--
543
544INSERT INTO `user_online` (`session`, `time`) VALUES
545('5sv2uv67963o051l3ds3ea78u7', 1454118036);
546
547/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
548/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
549/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;