-- phpMyAdmin SQL Dump
-- version 3.2.4
-- [url=http://www.phpmyadmin.net]phpMyAdmin[/url]
--
-- Host: localhost
-- Czas wygenerowania: 05 Sty 2011, 15:04
-- Wersja serwera: 5.0.91
-- Wersja PHP: 5.2.9
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Baza danych: `startgam_amxbans`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `bf2ranks`
--
CREATE TABLE IF NOT EXISTS `bf2ranks` (
`playerid` varchar(35) collate utf8_unicode_ci NOT NULL default '',
`badge1` tinyint(4) default NULL,
`badge2` tinyint(4) default NULL,
`badge3` tinyint(4) default NULL,
`badge4` tinyint(4) default NULL,
`badge5` tinyint(4) default NULL,
`badge6` tinyint(4) default NULL,
`knife` smallint(6) default NULL,
`pistol` smallint(6) default NULL,
`sniper` smallint(6) default NULL,
`support` smallint(6) default NULL,
`kills` int(11) default NULL,
`defuses` int(11) default NULL,
`plants` int(11) default NULL,
`explosions` int(11) default NULL,
PRIMARY KEY (`playerid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Zrzut danych tabeli `bf2ranks`
--
INSERT INTO `bf2ranks` (`playerid`, `badge1`, `badge2`, `badge3`, `badge4`, `badge5`, `badge6`, `knife`, `pistol`, `sniper`, `support`, `kills`, `defuses`, `plants`, `explosions`) VALUES
('Gram4Fun', 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 2, 0, 0, 0),
('Shine', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('Paulina', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('^.ZaBoJca_
*', 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 38, 1, 1, 1),
('One Sh0T| no name', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0),
('Arnoldzik', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('PRO ZIUTEK', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('Lisica', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0),
('empty', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('Black Dragon', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0),
('bartek', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 1, 1),
('Staruch (L)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('Malibu', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('klllllllllll', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Struktura tabeli dla `bf2ranks2`
--
CREATE TABLE IF NOT EXISTS `bf2ranks2` (
`playerid` varchar(35) collate utf8_unicode_ci NOT NULL default '',
`badge7` tinyint(4) default NULL,
`badge8` tinyint(4) default NULL,
`shotgun` smallint(6) default NULL,
`smg` smallint(6) default NULL,
`rifle` smallint(6) default NULL,
`grenade` smallint(6) default NULL,
`gold` int(11) default NULL,
`silver` int(11) default NULL,
`bronze` int(11) default NULL,
`highestrank` varchar(35) collate utf8_unicode_ci default NULL,
`mostkills` varchar(35) collate utf8_unicode_ci default NULL,
`mostwins` varchar(35) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`playerid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Zrzut danych tabeli `bf2ranks2`
--
INSERT INTO `bf2ranks2` (`playerid`, `badge7`, `badge8`, `shotgun`, `smg`, `rifle`, `grenade`, `gold`, `silver`, `bronze`, `highestrank`, `mostkills`, `mostwins`) VALUES
('Server', 0, 0, 0, 0, 0, 0, 1, 32, 1, '^.ZaBoJca_
*', '^.ZaBoJca_
*', '^.ZaBoJca_
*'),
('Gram4Fun', 0, 0, 0, 0, 1, 0, 0, 0, 0, '0', '0', '0'),
('Shine', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0'),
('Paulina', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0'),
('^.ZaBoJca_
*', 0, 0, 0, 0, 27, 3, 1, 0, 0, '0', '0', '0'),
('One Sh0T| no name', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0'),
('Arnoldzik', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0'),
('PRO ZIUTEK', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0'),
('Lisica', 0, 0, 0, 0, 1, 0, 0, 0, 0, '0', '0', '0'),
('empty', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0'),
('Black Dragon', 0, 0, 0, 0, 0, 1, 0, 0, 0, '0', '0', '0'),
('bartek', 0, 0, 0, 0, 4, 0, 0, 0, 0, '0', '0', '0'),
('Staruch (L)', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0'),
('Malibu', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0'),
('klllllllllll', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0');