· 10 years ago · May 12, 2016, 09:51 AM
1-- phpMyAdmin SQL Dump
2-- version 4.1.8
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 25, 2014 at 04:02 PM
7-- Server version: 5.5.37-cll
8-- PHP Version: 5.4.23
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-- Database: `felna_arena`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `community`
27--
28
29CREATE TABLE IF NOT EXISTS `community` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `rank_pts` float(10,6) NOT NULL DEFAULT '0.000000',
32 `naziv` varchar(30) NOT NULL,
33 `forum` varchar(50) NOT NULL,
34 `opis` text NOT NULL,
35 `owner` varchar(30) NOT NULL,
36 `ownerid` varchar(30) NOT NULL,
37 `maxslots` varchar(30) NOT NULL DEFAULT '0',
38 `playercount` varchar(1000) NOT NULL DEFAULT '000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000',
39 `chart_updates` varchar(64) NOT NULL DEFAULT '|00|00|00|00|00|00|00|00|00|00|00|00',
40 PRIMARY KEY (`id`)
41) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
42
43-- --------------------------------------------------------
44
45--
46-- Table structure for table `community_servers`
47--
48
49CREATE TABLE IF NOT EXISTS `community_servers` (
50 `id` int(11) NOT NULL AUTO_INCREMENT,
51 `comid` varchar(30) NOT NULL,
52 `srvid` varchar(30) NOT NULL,
53 PRIMARY KEY (`id`)
54) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
55
56-- --------------------------------------------------------
57
58--
59-- Table structure for table `points`
60--
61
62CREATE TABLE IF NOT EXISTS `points` (
63 `id` int(11) NOT NULL AUTO_INCREMENT,
64 `ip_user` varchar(100) NOT NULL,
65 `hostname` varchar(100) NOT NULL,
66 `vreme` varchar(100) NOT NULL,
67 `userid` varchar(100) NOT NULL,
68 PRIMARY KEY (`id`)
69) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
70
71-- --------------------------------------------------------
72
73--
74-- Table structure for table `serverinfo`
75--
76
77CREATE TABLE IF NOT EXISTS `serverinfo` (
78 `id` int(11) NOT NULL AUTO_INCREMENT,
79 `ip` varchar(128) NOT NULL,
80 `port` varchar(16) NOT NULL,
81 `rank_pts` float(10,6) NOT NULL DEFAULT '0.000000',
82 `rank` int(11) NOT NULL DEFAULT '0',
83 `best_rank` varchar(10) NOT NULL,
84 `worst_rank` varchar(10) NOT NULL,
85 `game` varchar(128) NOT NULL,
86 `gamemod` varchar(128) NOT NULL,
87 `online` tinyint(4) NOT NULL DEFAULT '0',
88 `hostname` varchar(128) NOT NULL DEFAULT 'n/a',
89 `mapname` varchar(128) NOT NULL DEFAULT 'n/a',
90 `playercount_hour` varchar(1000) NOT NULL DEFAULT '00,00,00,00,00,00,00,00,00,00,00,00',
91 `playercount` varchar(1000) NOT NULL DEFAULT '00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00',
92 `num_players` varchar(10) NOT NULL DEFAULT '0',
93 `max_players` varchar(10) NOT NULL DEFAULT '0',
94 `location` varchar(128) NOT NULL,
95 `last_update` int(11) NOT NULL DEFAULT '0',
96 `last_chart_update` int(11) NOT NULL DEFAULT '0',
97 `chart_updates` varchar(64) NOT NULL DEFAULT '|00|00|00|00|00|00|00|00|00|00|00|00',
98 `rank_chart_updates` varchar(60) NOT NULL DEFAULT '|00|00|00|00|00|00',
99 `rank_chart_count` varchar(1000) NOT NULL DEFAULT '00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000,00000',
100 `added` varchar(30) NOT NULL,
101 `addedid` varchar(30) NOT NULL,
102 `forum` text NOT NULL,
103 `owner` varchar(30) NOT NULL,
104 `ownerid` varchar(30) NOT NULL,
105 KEY `id` (`id`)
106) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=523533 ;
107
108-- --------------------------------------------------------
109
110--
111-- Table structure for table `servers`
112--
113
114CREATE TABLE IF NOT EXISTS `servers` (
115 `id` int(11) NOT NULL AUTO_INCREMENT,
116 `name` varchar(100) NOT NULL,
117 `surname` varchar(100) NOT NULL,
118 `city` varchar(100) NOT NULL,
119 `country` varchar(100) NOT NULL,
120 `email` varchar(100) NOT NULL,
121 `telephone` varchar(100) NOT NULL,
122 `payment` varchar(100) NOT NULL,
123 `box` varchar(100) NOT NULL,
124 `slots` varchar(100) NOT NULL,
125 `userid` varchar(100) NOT NULL,
126 `time` varchar(100) NOT NULL,
127 `status` varchar(1) NOT NULL DEFAULT '0',
128 `game` varchar(100) NOT NULL,
129 PRIMARY KEY (`id`)
130) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
131
132--
133-- Dumping data for table `servers`
134--
135
136INSERT INTO `servers` (`id`, `name`, `surname`, `city`, `country`, `email`, `telephone`, `payment`, `box`, `slots`, `userid`, `time`, `status`, `game`) VALUES
137(2, 'Demir', 'Izdirovic', 'Novi Pazar', 'Serbia', 'morphe_uS@live.com', '0010392138213', 'Uplatnica Banka/Posta', 'Lite', '32', '1', '1414243518', '0', 'Counter-Strike 1.6'),
138(3, 'Demir', 'Izdirovic', 'Novi Pazar', 'Serbia', 'morphe_uS@live.com', '0010392138213', 'Uplatnica Banka/Posta', 'Lite', '200', '1', '1414243606', '1', 'San Andreas MP');
139
140-- --------------------------------------------------------
141
142--
143-- Table structure for table `serv_comm`
144--
145
146CREATE TABLE IF NOT EXISTS `serv_comm` (
147 `id` int(11) NOT NULL AUTO_INCREMENT,
148 `username` varchar(100) NOT NULL,
149 `srvid` varchar(100) NOT NULL,
150 `time` varchar(100) NOT NULL,
151 `message` text NOT NULL,
152 PRIMARY KEY (`id`)
153) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
154
155--
156-- Dumping data for table `serv_comm`
157--
158
159INSERT INTO `serv_comm` (`id`, `username`, `srvid`, `time`, `message`) VALUES
160(2, 'MorpheuS ^^', '3', '1414244041', 'test'),
161(3, 'MorpheuS ^^', '3', '1414244114', 'radi');
162
163-- --------------------------------------------------------
164
165--
166-- Table structure for table `users`
167--
168
169CREATE TABLE IF NOT EXISTS `users` (
170 `userid` int(11) NOT NULL AUTO_INCREMENT,
171 `username` varchar(100) NOT NULL,
172 `ime` varchar(100) NOT NULL,
173 `prezime` varchar(100) NOT NULL,
174 `password` varchar(200) NOT NULL,
175 `email` varchar(100) NOT NULL,
176 `register_time` varchar(100) NOT NULL,
177 `rank` varchar(1) NOT NULL,
178 PRIMARY KEY (`userid`)
179) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
180
181--
182-- Dumping data for table `users`
183--
184
185INSERT INTO `users` (`userid`, `username`, `ime`, `prezime`, `password`, `email`, `register_time`, `rank`) VALUES
186(2, 'demo', 'demo', 'demo', 'fe01ce2a7fbac8fafaed7c982a04e229', 'demo@live.com', '25.10.2014 - 03:10:56', '1');
187
188/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
189/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
190/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;