Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS `banidos`;
- CREATE TABLE IF NOT EXISTS `banidos` (
- `Nome` varchar(50) DEFAULT NULL,
- `IP` varchar(50) DEFAULT NULL,
- `Motivo` varchar(50) DEFAULT NULL,
- `Admin` varchar(50) DEFAULT NULL,
- `Data` varchar(50) DEFAULT NULL,
- `Temporario` int(11) DEFAULT NULL,
- `Dia` int(11) DEFAULT NULL,
- `Mes` int(11) DEFAULT NULL,
- `Ano` int(11) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `carros`;
- CREATE TABLE IF NOT EXISTS `carros` (
- `ID` int(128) NOT NULL AUTO_INCREMENT,
- `SID` int(128) DEFAULT NULL,
- `Modelo` int(101) DEFAULT NULL,
- `Nome` varchar(128) DEFAULT NULL,
- `Dono` varchar(30) DEFAULT NULL,
- `Preco` int(128) DEFAULT NULL,
- `Trancado` int(10) DEFAULT NULL,
- `Bloqueado` int(128) DEFAULT NULL,
- `Slot` int(15) DEFAULT NULL,
- `X` varchar(128) DEFAULT NULL,
- `Y` varchar(128) DEFAULT NULL,
- `Z` varchar(128) DEFAULT NULL,
- `Angulo` varchar(128) DEFAULT NULL,
- `RX` varchar(128) DEFAULT NULL,
- `RY` varchar(128) DEFAULT NULL,
- `RZ` varchar(128) DEFAULT NULL,
- `RAngulo` varchar(128) DEFAULT NULL,
- `Cor1` int(100) DEFAULT NULL,
- `Cor2` int(100) DEFAULT NULL,
- `Spoiler` int(100) DEFAULT NULL,
- `Nitro` int(100) DEFAULT NULL,
- `FBumper` int(100) DEFAULT NULL,
- `Exhaust` int(100) DEFAULT NULL,
- `BVentr` int(100) DEFAULT NULL,
- `BVent` int(100) DEFAULT NULL,
- `BScoop` int(100) DEFAULT NULL,
- `RScoop` int(100) DEFAULT NULL,
- `LSkirt` int(100) DEFAULT NULL,
- `RSkirt` int(100) DEFAULT NULL,
- `Hydraulics` int(100) DEFAULT NULL,
- `Base` int(100) DEFAULT NULL,
- `RBBars` int(100) DEFAULT NULL,
- `FBBars` int(100) DEFAULT NULL,
- `Whells` int(100) DEFAULT NULL,
- `Lights` int(100) DEFAULT NULL,
- `Painjob` int(100) DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `casas`;
- CREATE TABLE IF NOT EXISTS `casas` (
- `ID` int(128) NOT NULL AUTO_INCREMENT,
- `Dono` varchar(50) DEFAULT NULL,
- `Preco` int(101) DEFAULT NULL,
- `Criador` varchar(20) DEFAULT NULL,
- `Data` varchar(20) DEFAULT NULL,
- `Servidor` int(10) DEFAULT NULL,
- `Trancada` int(10) DEFAULT NULL,
- `Interior` int(10) DEFAULT NULL,
- `eInterior` int(10) DEFAULT NULL,
- `Mundo` int(10) DEFAULT NULL,
- `X` varchar(128) DEFAULT NULL,
- `Y` varchar(128) DEFAULT NULL,
- `Z` varchar(128) DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `contas`;
- CREATE TABLE IF NOT EXISTS `contas` (
- `Nome` varchar(50) DEFAULT NULL,
- `Senha` varchar(250) DEFAULT NULL,
- `IP` varchar(50) DEFAULT NULL,
- `Pais` varchar(50) DEFAULT NULL,
- `Cidade` varchar(50) DEFAULT NULL,
- `Data` varchar(11) NOT NULL,
- `Level` int(10) DEFAULT '0',
- `Vip` int(10) DEFAULT '0',
- `Sexo` int(10) NOT NULL,
- `Horas` int(11) NOT NULL,
- `Minutos` int(11) NOT NULL,
- `CorCmd` int(11) NOT NULL,
- `CtDia` int(10) NOT NULL,
- `CtMes` int(10) NOT NULL,
- `CtAno` int(10) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `dmcontas`;
- CREATE TABLE IF NOT EXISTS `dmcontas` (
- `Nome` varchar(50) DEFAULT NULL,
- `IP` varchar(50) DEFAULT NULL,
- `Casa` int(11) NOT NULL,
- `Skin` int(11) NOT NULL,
- `Dinheiro` int(11) NOT NULL,
- `Score` int(11) NOT NULL,
- `Matou` int(11) NOT NULL,
- `Morreu` int(11) NOT NULL,
- `Boost` int(11) NOT NULL DEFAULT '0',
- `C1` int(11) NOT NULL DEFAULT '0',
- `C2` int(11) NOT NULL DEFAULT '0',
- `C3` int(11) NOT NULL DEFAULT '0',
- `C4` int(11) NOT NULL,
- `C5` int(11) NOT NULL,
- `C6` int(11) NOT NULL,
- `C7` int(11) NOT NULL,
- `C8` int(11) NOT NULL,
- `Biz` int(11) NOT NULL,
- `Banco` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `empresas`;
- CREATE TABLE IF NOT EXISTS `empresas` (
- `ID` int(128) NOT NULL AUTO_INCREMENT,
- `Dono` varchar(50) DEFAULT NULL,
- `Nome` varchar(50) DEFAULT NULL,
- `Preco` int(101) DEFAULT NULL,
- `Ganho` int(10) DEFAULT NULL,
- `Criador` varchar(20) DEFAULT NULL,
- `Data` varchar(20) DEFAULT NULL,
- `X` varchar(128) DEFAULT NULL,
- `Y` varchar(128) DEFAULT NULL,
- `Z` varchar(128) DEFAULT NULL,
- `Interior` int(10) DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `kicklog`;
- CREATE TABLE IF NOT EXISTS `kicklog` (
- `Nome` varchar(50) DEFAULT NULL,
- `Motivo` varchar(50) DEFAULT NULL,
- `Data` varchar(50) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `log`;
- CREATE TABLE IF NOT EXISTS `log` (
- `Nome` varchar(50) DEFAULT NULL,
- `ID` int(10) DEFAULT NULL,
- `Data` varchar(50) DEFAULT NULL,
- `Acao` varchar(50) DEFAULT NULL,
- `Jogador1` varchar(50) DEFAULT NULL,
- `Jogador2` varchar(50) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `mapa`;
- CREATE TABLE IF NOT EXISTS `mapa` (
- `Nome` varchar(70) DEFAULT NULL,
- `Criador` varchar(70) DEFAULT NULL,
- `Modo` varchar(50) NOT NULL,
- `HX` varchar(100) DEFAULT NULL,
- `HY` varchar(100) DEFAULT NULL,
- `HZ` varchar(100) DEFAULT NULL,
- `HInterior` int(10) DEFAULT NULL,
- `ZX` varchar(100) DEFAULT NULL,
- `ZY` varchar(100) DEFAULT NULL,
- `ZZ` varchar(100) DEFAULT NULL,
- `ZInterior` int(10) DEFAULT NULL,
- `EX` varchar(100) NOT NULL,
- `EY` varchar(100) NOT NULL,
- `EZ` varchar(100) NOT NULL,
- `EInterior` int(100) NOT NULL,
- `AX` varchar(100) NOT NULL,
- `AY` int(100) NOT NULL,
- `AZ` varchar(100) NOT NULL,
- `Objeto` int(11) NOT NULL,
- `OX` varchar(100) NOT NULL,
- `OY` varchar(100) NOT NULL,
- `OZ` varchar(100) NOT NULL,
- `ORX` varchar(100) NOT NULL,
- `ORY` varchar(100) NOT NULL,
- `ORZ` varchar(100) NOT NULL,
- `OAX` varchar(100) NOT NULL,
- `OAY` varchar(100) NOT NULL,
- `OAZ` varchar(100) NOT NULL,
- `OARX` varchar(100) NOT NULL,
- `OARY` varchar(100) NOT NULL,
- `OARZ` varchar(100) NOT NULL,
- UNIQUE KEY `Nome` (`Nome`,`Criador`,`HX`,`HY`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- ALTER TABLE `mapa` CHANGE `EX` `EX` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '0', CHANGE `EY` `EY` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `EZ` `EZ` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '0', CHANGE `EInterior` `EInterior` INT(100) NOT NULL DEFAULT '0', CHANGE `AX` `AX` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `AY` `AY` INT(100) NOT NULL DEFAULT '0', CHANGE `AZ` `AZ` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `Objeto` `Objeto` INT(11) NOT NULL DEFAULT '0', CHANGE `OX` `OX` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OY` `OY` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OZ` `OZ` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `ORX` `ORX` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `ORY` `ORY` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `ORZ` `ORZ` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OAX` `OAX` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OAY` `OAY` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OAZ` `OAZ` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OARX` `OARX` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OARY` `OARY` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OARZ` `OARZ` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0';
- DROP TABLE IF EXISTS `pmblock`;
- CREATE TABLE IF NOT EXISTS `pmblock` (
- `Nome` varchar(50) DEFAULT NULL,
- `Block` varchar(50) DEFAULT NULL,
- `Data` varchar(10) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `portao`;
- CREATE TABLE IF NOT EXISTS `portao` (
- `ID` int(128) NOT NULL AUTO_INCREMENT,
- `Senha` varchar(50) DEFAULT NULL,
- `Criador` varchar(50) DEFAULT NULL,
- `Data` varchar(50) DEFAULT NULL,
- `Modelo` int(11) DEFAULT NULL,
- `Explodir` int(10) DEFAULT NULL,
- `X` varchar(50) DEFAULT NULL,
- `Y` varchar(50) DEFAULT NULL,
- `Z` varchar(50) DEFAULT NULL,
- `RX` varchar(50) DEFAULT NULL,
- `RY` varchar(50) DEFAULT NULL,
- `RZ` varchar(50) DEFAULT NULL,
- `AX` varchar(50) DEFAULT NULL,
- `AY` varchar(50) DEFAULT NULL,
- `AZ` varchar(50) DEFAULT NULL,
- `ARX` varchar(50) DEFAULT NULL,
- `ARY` varchar(50) DEFAULT NULL,
- `ARZ` varchar(50) DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `zscontas`;
- CREATE TABLE IF NOT EXISTS `zscontas` (
- `Nome` varchar(50) DEFAULT NULL,
- `Coins` int(10) DEFAULT '0',
- `Cookies` int(10) DEFAULT '0',
- `XP` int(10) DEFAULT '0',
- `Partidas` int(10) DEFAULT '0',
- `Matou` int(10) DEFAULT '0',
- `Morreu` int(10) DEFAULT '0',
- `Score` int(11) DEFAULT '0',
- `pEvac` int(11) NOT NULL DEFAULT '0',
- `pEvac2` int(11) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `labels`;
- CREATE TABLE IF NOT EXISTS `labels` (
- `ID` int(100) NOT NULL AUTO_INCREMENT,
- `Texto` varchar(100) DEFAULT NULL,
- `Cor` int(50) DEFAULT '0',
- `Interior` int(10) DEFAULT '0',
- `Distancia` varchar(100) DEFAULT '0',
- `X` varchar(100) DEFAULT '0',
- `Y` varchar(100) DEFAULT '0',
- `Z` varchar(100) DEFAULT '0',
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `gangs`;
- CREATE TABLE IF NOT EXISTS `gangs` (
- `ID` int(10) NOT NULL AUTO_INCREMENT,
- `Tag` varchar(10) DEFAULT NULL,
- `Nome` varchar(30) DEFAULT NULL,
- `Dono` varchar(30) DEFAULT NULL,
- `Criador` varchar(30) DEFAULT NULL,
- `Max` int(26) DEFAULT '5',
- `Cor` int(15) NOT NULL DEFAULT '-16776961',
- `Cor1` int(10) NOT NULL DEFAULT '18',
- `X` varchar(30) DEFAULT '0',
- `Y` varchar(30) DEFAULT '0',
- `Z` varchar(30) DEFAULT '0',
- `Interior` int(10) DEFAULT '0',
- `C1` varchar(30) DEFAULT 'Not Set',
- `C2` varchar(30) DEFAULT 'Not Set',
- `C3` varchar(30) DEFAULT 'Not Set',
- `A1` int(10) DEFAULT '0',
- `A2` int(10) DEFAULT '0',
- `A3` int(10) DEFAULT '0',
- `A4` int(10) DEFAULT '0',
- `A5` int(10) DEFAULT '0',
- `S1` int(10) DEFAULT '0',
- `S2` int(10) DEFAULT '0',
- `S3` int(10) DEFAULT '0',
- `S4` int(10) DEFAULT '0',
- `S5` int(10) DEFAULT '0',
- `S6` int(10) DEFAULT '0',
- `S7` int(10) DEFAULT '0',
- `S8` int(10) DEFAULT '0',
- `S9` int(10) DEFAULT '0',
- `S10` int(10) DEFAULT '0',
- `S11` int(10) DEFAULT '0',
- `S12` int(10) DEFAULT '0',
- `S13` int(10) DEFAULT '0',
- `S14` int(10) DEFAULT '0',
- `S15` int(10) DEFAULT '0',
- `S16` int(10) DEFAULT '0',
- `S17` int(10) DEFAULT '0',
- `S18` int(10) DEFAULT '0',
- `S19` int(10) DEFAULT '0',
- `S20` int(10) DEFAULT '0',
- `S21` int(10) DEFAULT '0',
- `S22` int(10) DEFAULT '0',
- `S23` int(10) DEFAULT '0',
- `S24` int(10) DEFAULT '0',
- `S25` int(10) DEFAULT '0',
- `N1` varchar(50) DEFAULT 'Rank 1',
- `N2` varchar(50) DEFAULT 'Rank 2',
- `N3` varchar(50) DEFAULT 'Rank 3',
- `N4` varchar(50) DEFAULT 'Rank 4',
- `N5` varchar(50) DEFAULT 'Rank 5',
- `N6` varchar(50) DEFAULT 'Rank 6',
- `N7` varchar(50) DEFAULT 'Rank 7',
- `N8` varchar(50) DEFAULT 'Rank 8',
- `N9` varchar(50) DEFAULT 'Rank 9',
- `N10` varchar(50) DEFAULT 'Rank 10',
- `N11` varchar(50) DEFAULT 'Rank 11',
- `N12` varchar(50) DEFAULT 'Rank 12',
- `N13` varchar(50) DEFAULT 'Rank 13',
- `N14` varchar(50) DEFAULT 'Rank 14',
- `N15` varchar(50) DEFAULT 'Rank 15',
- `N16` varchar(50) DEFAULT 'Rank 16',
- `N17` varchar(50) DEFAULT 'Rank 17',
- `N18` varchar(50) DEFAULT 'Rank 18',
- `N19` varchar(50) DEFAULT 'Rank 19',
- `N20` varchar(50) DEFAULT 'Rank 20',
- `N21` varchar(50) DEFAULT 'Rank 21',
- `N22` varchar(50) DEFAULT 'Rank 22',
- `N23` varchar(50) DEFAULT 'Rank 23',
- `N24` varchar(50) DEFAULT 'Rank 24',
- `N25` varchar(50) DEFAULT 'Rank 25',
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `membros`;
- CREATE TABLE IF NOT EXISTS `membros` (
- `Nome` varchar(30) DEFAULT NULL,
- `Tag` varchar(30) DEFAULT NULL,
- `Nivel` int(10) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- CREATE TABLE IF NOT EXISTS `config` (
- `Nome` Varchar(50),
- `Valor` int(30)
- );
- CREATE TABLE IF NOT EXISTS `clan` (`Nome` VARCHAR(30) NOT NULL ,`bG` INT(10) NOT NULL DEFAULT '0');
- CREATE TABLE IF NOT EXISTS discord (Nome VARCHAR(100),ID VARCHAR(100),Posicao INT(10),Inutil INT(10));
- INSERT INTO `mapa` (`Nome`, `Criador`, `Modo`, `HX`, `HY`, `HZ`, `HInterior`, `ZX`, `ZY`, `ZZ`, `ZInterior`, `EX`, `EY`, `EZ`, `EInterior`, `AX`, `AY`, `AZ`, `Objeto`, `OX`, `OY`, `OZ`, `ORX`, `ORY`, `ORZ`, `OAX`, `OAY`, `OAZ`, `OARX`, `OARY`, `OARZ`) VALUES
- ('Mb', 'Unknown', 'DM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,'0','0','0', 0,'0',0,'0', 0,'0','0','0','0','0','0','0','0','0','0','0','0'),
- ('Vinewood', 'RUFAT', 'ZS', '219.783523', '-1290.421020', '60.149578', 0, '179.565658', '-1224.333129', '78.375000', 0, '374.239685', '-1154.993041', '78.194122', 0, '242.568634', -1254, '69.701606', 0,'0','0','0','0','0','0','0','0','0','0','0','0'),
- ('Area51', 'LeoOliver', 'ZS', '298.058929', '1815.808471', '4.710937', 0, '297.674530', '1816.002441', '4.710937', 0, '-1751.831787', '889.133728', '347.371887', 0, '267.597381', 1817, '4.703125', 980, '96.741149', '1920.777343', '18.606916', '0.000000', '0.000000', '89.038185', '96.741149', '1920.777343', '13.756915', '0.000000', '0.000000', '89.038185'),
- ('DeathMatch', 'Misho1', 'ZS', '-1696.932373', '916.134094', '342.128448', 0, '-1792.224853', '775.130432', '349.774505', 0, '-1752.124145', '889.598937', '347.347381', 0, '-1718.573486', 916, '342.128448', 0,'0','0','0','0','0','0','0','0','0','0','0','0'),
- ('Rave', 'Youarex', 'ZS', '-96.146308', '63.567100', '78.779457', 0, '-27.045963', '1.655962', '67.845565', 0, '-6.309685', '114.880996', '64.120201', 0, '-78.035118', 79, '76.918289', 980, '-6.642311', '108.483329', '64.163894', '0.000000', '0.000000', '-0.064648', '-6.642311', '108.483329', '59.953899', '0.000000', '0.000000', '-0.064648'),
- ('Military Fuels', 'Ceedie', 'ZS', '2569.871582', '2809.995605', '10.820312', 0, '2547.154785', '2714.727294', '10.820312', 0, '2514.305175', '2730.200683', '10.901562', 0, '2567.143798', 2828, '10.820312', 0,'0','0','0','0','0','0','0','0','0','0','0','0'),
- ('Santa Maria', 'Ceedie', 'ZS', '439.405029', '-2007.722778', '12.507698', 0, '484.115173', '-2058.964599', '12.497947', 0, '492.163146', '-1995.207763', '12.582352', 0, '467.974395', -2015, '12.507698', 2933, '492.020324', '-1998.134521', '9.745809', '0.000000', '-90.399940', '0.208469', '492.038940', '-1998.134521', '7.075873', '0.000000', '-90.399940', '0.208469'),
- ('SF Radio Station', 'Ceedie', 'ZS', '-2534.591064', '-618.027893', '132.562500', 0, '-2418.011230', '-666.548583', '133.132812', 0, '-2476.272949', '-483.466766', '100.134017', 0, '-2498.623291', -623, '132.659576', 980, '-2439.643798', '-583.430664', '132.264282', '0.000000', '0.000000', '24.825296', '-2439.643798', '-583.430664', '126.684257', '0.000000', '0.000000', '24.825296'),
- ('Unity Station','hossa','ZS','1800.333618','-2012.873535','13.521794','0','1755.675292','-1917.188598','13.570697','0','1698.255493','-1960.723999','19.218750','0','1801.299926','-1990','13.525097','0','0','0','0','0','0','0','0','0','0','0','0','0');
Add Comment
Please, Sign In to add comment