13.07.2015, 01:34
[CENTER]Bonjour a tous et a toute, je vous partage aujourd'hui un gamemode que j'ai utiliser pour mon serveur "Play Roleplay", le GM est de base SCRP ( south central roleplay ) je le partage ici aprиs que j'ai passer pas mal de temps a le traduire ( traduction a revoir rapidement ) je le partage suite a un gamin de 12 ans qui me l'a volй car je l'ai pris pour quelqu'un de confiance et qui est mature mais a la fin voila quoi ( malgrй qu'il est bourrй des fails mais bon je le partage il me sert a rien ) , ce gamemode contient plusieurs modifications qui ont йtй effectuй ( comme les gros bug connu dans le GM ont йtй rйparer ), avec un mapping complиtement unique voila quelque modifications ajoutй au gamemode :[/CENTER]
- Mapping Unique.
- Script de braquage de banque unique.
- Les factions ont йtй complиtement revue.
- Ajout d'un nouveau type de faction ( Type Tunning ).
- Ajout des commandes pour la faction du type tunning + le garage.
- Systиme d'Exp et levels complиtement Unique.
- Rйparation des crashes du serveur ( j'vais le choix d'avoir 19 warnings dans le gamemode ou passer tout le gamemode en MySQL R39-2 et tellement que je suis flemmard j'ai pris le premier choix , si vous rйparer les warnings le GM va buggй sinon si vous avez le courage passer le en MySQL derniиre version ).
- Plusieurs Textdraws ont йtй refais et ajoutйs ( Payday / Braquage ect ... ).
- Systиme de banque / ATM complиtement revue et modifier ( sa fonctionne en textdraws credits a adri1 ).
Screens / plus d'infos ici : http://britania.ws/board/index.php?/topi...ype-de-rp/
Crйdits:
Scripteurs - Emmet_, Apple, AlexBlack
Fondateur - Risky
Co Fondateur - Evander
Saff - PerJon, Supreme, KuffPuff,
Mappings - Sn0k.
Autres - Golf, adri1
Il est obligatoire d'ajouter les crйdits en cas que vous dйcidez d'utiliser ce gamemode.
PS : si j'aurais le temps j'ai aussi la version sur SF et j'ai aussi une version sur Fort Carson.
Resources :
[SIZE="5"]GameMode[/SIZE]
http://www.mediafire.com/download/9071y7...PlayRP.rar
[SIZE="5"]Database[/SIZE]
La seule condition est de ne pas retirer les crйdits du serveur.
Avant mon poste a йtй supprimer pour une raison inconnue.
Bon jeu a tous :cool:
- Mapping Unique.
- Script de braquage de banque unique.
- Les factions ont йtй complиtement revue.
- Ajout d'un nouveau type de faction ( Type Tunning ).
- Ajout des commandes pour la faction du type tunning + le garage.
- Systиme d'Exp et levels complиtement Unique.
- Rйparation des crashes du serveur ( j'vais le choix d'avoir 19 warnings dans le gamemode ou passer tout le gamemode en MySQL R39-2 et tellement que je suis flemmard j'ai pris le premier choix , si vous rйparer les warnings le GM va buggй sinon si vous avez le courage passer le en MySQL derniиre version ).
- Plusieurs Textdraws ont йtй refais et ajoutйs ( Payday / Braquage ect ... ).
- Systиme de banque / ATM complиtement revue et modifier ( sa fonctionne en textdraws credits a adri1 ).
Screens / plus d'infos ici : http://britania.ws/board/index.php?/topi...ype-de-rp/
Crйdits:
Scripteurs - Emmet_, Apple, AlexBlack
Fondateur - Risky
Co Fondateur - Evander
Saff - PerJon, Supreme, KuffPuff,
Mappings - Sn0k.
Autres - Golf, adri1
Il est obligatoire d'ajouter les crйdits en cas que vous dйcidez d'utiliser ce gamemode.
Emmet_ Wrote:AlexBlack Wrote:Hi, i have translate SC:RP for my project then i didn't finish it and i still have the gamemode, if you can give me the permission to release it to the frensh part ( with your credits of course ), thank's for reading.
Yeah sure. You can release it if you wish
PS : si j'aurais le temps j'ai aussi la version sur SF et j'ai aussi une version sur Fort Carson.
Resources :
[SIZE="5"]GameMode[/SIZE]
http://www.mediafire.com/download/9071y7...PlayRP.rar
[SIZE="5"]Database[/SIZE]
PHP Code:
-- phpMyAdmin SQL Dump
-- version 3.3.7deb8
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Gйnйrй le : Dim 08 Mars 2015 а 20:47
-- Version du serveur: 5.1.73
-- Version de PHP: 5.3.3-7+squeeze25
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Base de donnйes: `Black`
--
-- --------------------------------------------------------
--
-- Structure de la table `accounts`
--
CREATE TABLE IF NOT EXISTS `accounts` (
`ID` int(12) NOT NULL AUTO_INCREMENT,
`Username` varchar(24) DEFAULT NULL,
`Password` varchar(129) DEFAULT NULL,
`RegisterDate` varchar(36) DEFAULT NULL,
`LoginDate` varchar(36) DEFAULT NULL,
`IP` varchar(16) DEFAULT 'n/a',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=161 ;
-- --------------------------------------------------------
--
-- Structure de la table `arrestpoints`
--
CREATE TABLE IF NOT EXISTS `arrestpoints` (
`arrestID` int(11) NOT NULL AUTO_INCREMENT,
`arrestX` float NOT NULL,
`arrestY` float NOT NULL,
`arrestZ` float NOT NULL,
`arrestInterior` int(11) NOT NULL,
`arrestWorld` int(11) NOT NULL,
PRIMARY KEY (`arrestID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Contenu de la table `arrestpoints`
--
INSERT INTO `arrestpoints` (`arrestID`, `arrestX`, `arrestY`, `arrestZ`, `arrestInterior`, `arrestWorld`) VALUES
(2, 1222.21, -1309.7, 796.787, 5, 10000);
-- --------------------------------------------------------
--
-- Structure de la table `atm`
--
CREATE TABLE IF NOT EXISTS `atm` (
`atmID` int(11) NOT NULL,
`atmA` float NOT NULL,
`atmX` float NOT NULL,
`atmY` float NOT NULL,
`atmZ` float NOT NULL,
`atmInterior` int(11) NOT NULL,
`atmWorld` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Contenu de la table `atm`
--
INSERT INTO `atm` (`atmID`, `atmA`, `atmX`, `atmY`, `atmZ`, `atmInterior`, `atmWorld`) VALUES
(0, 356.396, 1702.37, -1802.7, 13.5468, 0, 0);
-- --------------------------------------------------------
--
-- Structure de la table `backpackitems`
--
CREATE TABLE IF NOT EXISTS `backpackitems` (
`ID` int(12) DEFAULT '0',
`itemID` int(12) NOT NULL AUTO_INCREMENT,
`itemName` varchar(32) DEFAULT NULL,
`itemModel` int(12) DEFAULT '0',
`itemQuantity` int(12) DEFAULT '0',
PRIMARY KEY (`itemID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;
-- --------------------------------------------------------
--
-- Structure de la table `backpacks`
--
CREATE TABLE IF NOT EXISTS `backpacks` (
`backpackID` int(12) NOT NULL AUTO_INCREMENT,
`backpackPlayer` int(12) DEFAULT '0',
`backpackX` float DEFAULT '0',
`backpackY` float DEFAULT '0',
`backpackZ` float DEFAULT '0',
`backpackInterior` int(12) DEFAULT '0',
`backpackWorld` int(12) DEFAULT '0',
`backpackHouse` int(12) DEFAULT '0',
`backpackVehicle` int(12) DEFAULT '0',
PRIMARY KEY (`backpackID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
-- --------------------------------------------------------
--
-- Structure de la table `billboards`
--
CREATE TABLE IF NOT EXISTS `billboards` (
`bbID` int(12) NOT NULL AUTO_INCREMENT,
`bbExists` int(12) DEFAULT '0',
`bbName` varchar(32) DEFAULT NULL,
`bbOwner` int(12) NOT NULL DEFAULT '0',
`bbPrice` int(12) NOT NULL DEFAULT '0',
`bbRange` int(12) DEFAULT '10',
`bbPosX` float DEFAULT '0',
`bbPosY` float DEFAULT '0',
`bbPosZ` float DEFAULT '0',
`bbMessage` varchar(230) DEFAULT NULL,
PRIMARY KEY (`bbID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `billboards`
--
-- --------------------------------------------------------
--
-- Structure de la table `blacklist`
--
CREATE TABLE IF NOT EXISTS `blacklist` (
`IP` varchar(16) DEFAULT '0.0.0.0',
`Username` varchar(24) DEFAULT NULL,
`BannedBy` varchar(24) DEFAULT NULL,
`Reason` varchar(128) DEFAULT NULL,
`Date` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Contenu de la table `blacklist`
--
-- --------------------------------------------------------
--
-- Structure de la table `businesses`
--
CREATE TABLE IF NOT EXISTS `businesses` (
`bizID` int(12) NOT NULL AUTO_INCREMENT,
`bizName` varchar(32) DEFAULT NULL,
`bizOwner` int(12) DEFAULT '0',
`bizType` int(12) DEFAULT '0',
`bizPrice` int(12) DEFAULT '0',
`bizPosX` float DEFAULT '0',
`bizPosY` float DEFAULT '0',
`bizPosZ` float DEFAULT '0',
`bizPosA` float DEFAULT '0',
`bizIntX` float DEFAULT '0',
`bizIntY` float DEFAULT '0',
`bizIntZ` float DEFAULT '0',
`bizIntA` float DEFAULT '0',
`bizInterior` int(12) DEFAULT '0',
`bizExterior` int(12) DEFAULT '0',
`bizExteriorVW` int(12) DEFAULT '0',
`bizLocked` int(4) DEFAULT '0',
`bizVault` int(12) DEFAULT '0',
`bizProducts` int(12) DEFAULT '0',
`bizPrice1` int(12) DEFAULT '0',
`bizPrice2` int(12) DEFAULT '0',
`bizPrice3` int(12) DEFAULT '0',
`bizPrice4` int(12) DEFAULT '0',
`bizPrice5` int(12) DEFAULT '0',
`bizPrice6` int(12) DEFAULT '0',
`bizPrice7` int(12) DEFAULT '0',
`bizPrice8` int(12) DEFAULT '0',
`bizPrice9` int(12) DEFAULT '0',
`bizPrice10` int(12) DEFAULT '0',
`bizSpawnX` float DEFAULT '0',
`bizSpawnY` float DEFAULT '0',
`bizSpawnZ` float DEFAULT '0',
`bizSpawnA` float DEFAULT '0',
`bizDeliverX` float DEFAULT '0',
`bizDeliverY` float DEFAULT '0',
`bizDeliverZ` float DEFAULT '0',
`bizMessage` varchar(128) DEFAULT NULL,
`bizPrice11` int(12) DEFAULT '0',
`bizPrice12` int(12) DEFAULT '0',
`bizPrice13` int(12) DEFAULT '0',
`bizPrice14` int(12) DEFAULT '0',
`bizPrice15` int(12) DEFAULT '0',
`bizPrice16` int(12) DEFAULT '0',
`bizPrice17` int(12) DEFAULT '0',
`bizPrice18` int(12) DEFAULT '0',
`bizPrice19` int(12) DEFAULT '0',
`bizPrice20` int(12) DEFAULT '0',
`bizShipment` int(4) DEFAULT '0',
PRIMARY KEY (`bizID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;
-- --------------------------------------------------------
--
-- Structure de la table `cars`
--
CREATE TABLE IF NOT EXISTS `cars` (
`carID` int(12) NOT NULL AUTO_INCREMENT,
`carModel` int(12) DEFAULT '0',
`carOwner` int(12) DEFAULT '0',
`carPosX` float DEFAULT '0',
`carPosY` float DEFAULT '0',
`carPosZ` float DEFAULT '0',
`carPosR` float DEFAULT '0',
`carColor1` int(12) DEFAULT '0',
`carColor2` int(12) DEFAULT '0',
`carPaintjob` int(12) DEFAULT '-1',
`carLocked` int(4) DEFAULT '0',
`carMod1` int(12) DEFAULT '0',
`carMod2` int(12) DEFAULT '0',
`carMod3` int(12) DEFAULT '0',
`carMod4` int(12) DEFAULT '0',
`carMod5` int(12) DEFAULT '0',
`carMod6` int(12) DEFAULT '0',
`carMod7` int(12) DEFAULT '0',
`carMod8` int(12) DEFAULT '0',
`carMod9` int(12) DEFAULT '0',
`carMod10` int(12) DEFAULT '0',
`carMod11` int(12) DEFAULT '0',
`carMod12` int(12) DEFAULT '0',
`carMod13` int(12) DEFAULT '0',
`carMod14` int(12) DEFAULT '0',
`carImpounded` int(12) DEFAULT '0',
`carWeapon1` int(12) DEFAULT '0',
`carAmmo1` int(12) DEFAULT '0',
`carWeapon2` int(12) DEFAULT '0',
`carAmmo2` int(12) DEFAULT '0',
`carWeapon3` int(12) DEFAULT '0',
`carAmmo3` int(12) DEFAULT '0',
`carWeapon4` int(12) DEFAULT '0',
`carAmmo4` int(12) DEFAULT '0',
`carWeapon5` int(12) DEFAULT '0',
`carAmmo5` int(12) DEFAULT '0',
`carImpoundPrice` int(12) DEFAULT '0',
`carFaction` int(12) DEFAULT '0',
`carJob` int(12) DEFAULT '0',
PRIMARY KEY (`carID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=219 ;
-- --------------------------------------------------------
--
-- Structure de la table `carstorage`
--
CREATE TABLE IF NOT EXISTS `carstorage` (
`ID` int(12) DEFAULT '0',
`itemID` int(12) NOT NULL AUTO_INCREMENT,
`itemName` varchar(32) DEFAULT NULL,
`itemModel` int(12) DEFAULT '0',
`itemQuantity` int(12) DEFAULT '0',
PRIMARY KEY (`itemID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
-- --------------------------------------------------------
--
-- Structure de la table `characters`
--
CREATE TABLE IF NOT EXISTS `characters` (
`ID` int(12) NOT NULL AUTO_INCREMENT,
`Username` varchar(24) DEFAULT NULL,
`Character` varchar(24) DEFAULT NULL,
`Created` int(4) DEFAULT '0',
`Gender` int(4) DEFAULT '0',
`Birthdate` varchar(32) DEFAULT '01/01/1970',
`Origin` varchar(32) DEFAULT 'Not Specified',
`Skin` int(12) DEFAULT '0',
`Glasses` int(12) DEFAULT '0',
`Hat` int(12) DEFAULT '0',
`Bandana` int(12) DEFAULT '0',
`PosX` float DEFAULT '0',
`PosY` float DEFAULT '0',
`PosZ` float DEFAULT '0',
`PosA` float DEFAULT '0',
`Interior` int(12) DEFAULT '0',
`World` int(12) DEFAULT '0',
`GlassesPos` varchar(100) DEFAULT NULL,
`HatPos` varchar(100) DEFAULT NULL,
`BandanaPos` varchar(100) DEFAULT NULL,
`Hospital` int(12) DEFAULT '-1',
`HospitalInt` int(12) DEFAULT '0',
`Money` int(12) DEFAULT '0',
`BankMoney` int(12) DEFAULT '0',
`OwnsBillboard` int(12) DEFAULT '-1',
`Savings` int(12) DEFAULT '0',
`Admin` int(12) DEFAULT '0',
`JailTime` int(12) DEFAULT '0',
`Muted` int(4) DEFAULT '0',
`CreateDate` int(12) DEFAULT '0',
`LastLogin` int(12) DEFAULT '0',
`Tester` int(4) DEFAULT '0',
`Gun1` int(12) DEFAULT '0',
`Gun2` int(12) DEFAULT '0',
`Gun3` int(12) DEFAULT '0',
`Gun4` int(12) DEFAULT '0',
`Gun5` int(12) DEFAULT '0',
`Gun6` int(12) DEFAULT '0',
`Gun7` int(12) DEFAULT '0',
`Gun8` int(12) DEFAULT '0',
`Gun9` int(12) DEFAULT '0',
`Gun10` int(12) DEFAULT '0',
`Gun11` int(12) DEFAULT '0',
`Gun12` int(12) DEFAULT '0',
`Gun13` int(12) DEFAULT '0',
`Ammo1` int(12) DEFAULT '0',
`Ammo2` int(12) DEFAULT '0',
`Ammo3` int(12) DEFAULT '0',
`Ammo4` int(12) DEFAULT '0',
`Ammo5` int(12) DEFAULT '0',
`Ammo6` int(12) DEFAULT '0',
`Ammo7` int(12) DEFAULT '0',
`Ammo8` int(12) DEFAULT '0',
`Ammo9` int(12) DEFAULT '0',
`Ammo10` int(12) DEFAULT '0',
`Ammo11` int(12) DEFAULT '0',
`Ammo12` int(12) DEFAULT '0',
`Ammo13` int(12) DEFAULT '0',
`House` int(12) DEFAULT '-1',
`Business` int(12) DEFAULT '-1',
`Phone` int(12) DEFAULT '0',
`Lottery` int(12) DEFAULT '0',
`Hunger` int(12) DEFAULT '100',
`Thirst` int(12) DEFAULT '100',
`PlayingHours` int(12) DEFAULT '0',
`Minutes` int(12) DEFAULT '0',
`ArmorStatus` float DEFAULT '0',
`Entrance` int(12) DEFAULT '0',
`Job` int(12) DEFAULT '0',
`Faction` int(12) DEFAULT '-1',
`FactionRank` int(12) DEFAULT '0',
`Prisoned` int(4) DEFAULT '0',
`Warrants` int(12) DEFAULT '0',
`Injured` int(4) DEFAULT '0',
`Health` float DEFAULT '0',
`Channel` int(12) DEFAULT '0',
`Accent` varchar(24) DEFAULT NULL,
`Bleeding` int(4) DEFAULT '0',
`Warnings` int(12) DEFAULT '0',
`Warn1` varchar(32) DEFAULT NULL,
`Warn2` varchar(32) DEFAULT NULL,
`MaskID` int(12) DEFAULT '0',
`FactionMod` int(12) DEFAULT '0',
`Capacity` int(12) DEFAULT '35',
`AdminHide` int(4) DEFAULT '0',
`LotteryB` int(11) NOT NULL,
`SpawnPoint` int(11) NOT NULL,
`Experiance` int(11) DEFAULT '0',
`Niveau` int(11) DEFAULT '0',
`BraquageSac` int(11) DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=169 ;
-- --------------------------------------------------------
--
-- Structure de la table `contacts`
--
CREATE TABLE IF NOT EXISTS `contacts` (
`ID` int(12) DEFAULT '0',
`contactID` int(12) NOT NULL AUTO_INCREMENT,
`contactName` varchar(32) DEFAULT NULL,
`contactNumber` int(12) DEFAULT '0',
PRIMARY KEY (`contactID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
-- --------------------------------------------------------
--
-- Structure de la table `crates`
--
CREATE TABLE IF NOT EXISTS `crates` (
`crateID` int(12) NOT NULL AUTO_INCREMENT,
`crateType` int(12) DEFAULT '0',
`crateX` float DEFAULT '0',
`crateY` float DEFAULT '0',
`crateZ` float DEFAULT '0',
`crateA` float DEFAULT '0',
`crateInterior` int(12) DEFAULT '0',
`crateWorld` int(12) DEFAULT '0',
PRIMARY KEY (`crateID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;
-- --------------------------------------------------------
--
-- Structure de la table `dealervehicles`
--
CREATE TABLE IF NOT EXISTS `dealervehicles` (
`ID` int(12) DEFAULT '0',
`vehID` int(12) NOT NULL AUTO_INCREMENT,
`vehModel` int(12) DEFAULT '0',
`vehPrice` int(12) DEFAULT '0',
PRIMARY KEY (`vehID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=68 ;
-- --------------------------------------------------------
--
-- Structure de la table `detectors`
--
CREATE TABLE IF NOT EXISTS `detectors` (
`detectorID` int(12) NOT NULL AUTO_INCREMENT,
`detectorX` float DEFAULT '0',
`detectorY` float DEFAULT '0',
`detectorZ` float DEFAULT '0',
`detectorAngle` float DEFAULT '0',
`detectorInterior` int(12) DEFAULT '0',
`detectorWorld` int(12) DEFAULT '0',
PRIMARY KEY (`detectorID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Contenu de la table `detectors`
--
-- --------------------------------------------------------
--
-- Structure de la table `dropped`
--
CREATE TABLE IF NOT EXISTS `dropped` (
`ID` int(12) NOT NULL AUTO_INCREMENT,
`itemName` varchar(32) DEFAULT NULL,
`itemModel` int(12) DEFAULT '0',
`itemX` float DEFAULT '0',
`itemY` float DEFAULT '0',
`itemZ` float DEFAULT '0',
`itemInt` int(12) DEFAULT '0',
`itemWorld` int(12) DEFAULT '0',
`itemQuantity` int(12) DEFAULT '0',
`itemAmmo` int(12) DEFAULT '0',
`itemWeapon` int(12) DEFAULT '0',
`itemPlayer` varchar(24) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=146 ;
-- --------------------------------------------------------
--
-- Structure de la table `entrances`
--
CREATE TABLE IF NOT EXISTS `entrances` (
`entranceID` int(12) NOT NULL AUTO_INCREMENT,
`entranceName` varchar(32) DEFAULT NULL,
`entranceIcon` int(12) DEFAULT '0',
`entrancePosX` float DEFAULT '0',
`entrancePosY` float DEFAULT '0',
`entrancePosZ` float DEFAULT '0',
`entrancePosA` float DEFAULT '0',
`entranceIntX` float DEFAULT '0',
`entranceIntY` float DEFAULT '0',
`entranceIntZ` float DEFAULT '0',
`entranceIntA` float DEFAULT '0',
`entranceInterior` int(12) DEFAULT '0',
`entranceExterior` int(12) DEFAULT '0',
`entranceExteriorVW` int(12) DEFAULT '0',
`entranceType` int(12) DEFAULT '0',
`entrancePass` varchar(32) DEFAULT NULL,
`entranceLocked` int(12) DEFAULT '0',
`entranceCustom` int(4) DEFAULT '0',
`entranceWorld` int(12) DEFAULT '0',
PRIMARY KEY (`entranceID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=70 ;
--
-- Contenu de la table `entrances`
--
INSERT INTO `entrances` (`entranceID`, `entranceName`, `entranceIcon`, `entrancePosX`, `entrancePosY`, `entrancePosZ`, `entrancePosA`, `entranceIntX`, `entranceIntY`, `entranceIntZ`, `entranceIntA`, `entranceInterior`, `entranceExterior`, `entranceExteriorVW`, `entranceType`, `entrancePass`, `entranceLocked`, `entranceCustom`, `entranceWorld`) VALUES
(7, 'Los Santos Police Departement', 0, 1555.5, -1675.56, 16.1953, 268.392, 1587.61, -1709.62, -36.8138, 182.455, 1, 0, 0, 0, '', 0, 0, 0),
(10, 'Los Santos Bank', 0, 800.833, -1738.8, 13.5467, 84.8117, 1456.19, -987.942, 996.105, 90, 6, 0, 0, 2, 'D', 0, 0, 7010),
(12, 'Prйsidence Los Santos', 0, 1310.27, -1367.8, 13.5409, 359.531, 304.017, -141.989, 1004.06, 90, 7, 0, 0, 0, 'Sa', 0, 0, 7012),
(56, 'Mairie Los Santos', 0, 1481.05, -1770.86, 18.7957, 178.388, 390.169, 173.807, 1008.38, 90, 3, 0, 0, 4, '', 0, 0, 7056),
(58, 'San News', 0, 1700.27, -1772.51, 13.6315, 264.769, 1886.76, -900.474, 980.594, 85.4726, 0, 0, 0, 0, '', 0, 1, 7058),
(59, '2 иme Etage', 0, 1866.01, -891.867, 980.732, 91.6697, 1866.52, -891.74, 987.651, 89.163, 0, 0, 7059, 0, '', 0, 0, 7059),
(60, 'FBI', 0, 1654.02, -1655.51, 22.5156, 358.749, 288.839, 167.193, 1007.17, 178.291, 3, 0, 0, 0, '', 0, 0, 7060),
(61, 'C.I.A', 0, 1676.96, -1634.8, 14.2265, 92.0987, 238.648, 140.134, 1003.02, 177.374, 3, 0, 0, 0, '', 0, 0, 7061),
(62, 'Stand de tir', 0, 1739.31, -1583.28, 14.1582, 2.0409, 304.017, -141.989, 1004.06, 90, 7, 0, 0, 5, '', 0, 0, 7062),
(63, 'LSPD - Sous-sol', 0, 1525.7, -1677.88, 5.8906, 90.895, 1577.35, -1743.22, -36.8139, 88.4541, 1, 0, 0, 0, '', 0, 0, 7063),
(64, 'Dealer d''armes', 6, -86.2813, -299.681, 2.7646, 358.401, 2570.05, -1301.92, 1044.12, 270.668, 2, 0, 0, 0, '', 0, 0, 7013),
(67, 'Dock', 0, 1848.23, -1761.18, 13.5468, 142.311, 1307.93, -55.8922, 1002.5, 93.2057, 18, 0, 0, 3, '', 0, 0, 7067),
(68, '#Legendary Motors', 27, 2005.9, -1760.55, 13.539, 179.449, 1999.5, -1765.76, 13.2506, 3.0637, 0, 0, 0, 0, '', 0, 0, 0),
(69, 'Cosa Nostra', 0, 328.897, -1513.14, 36.039, 48.7978, 2214.64, -1150.51, 1025.8, 265.678, 15, 0, 0, 0, '', 0, 0, 7069);
-- --------------------------------------------------------
--
-- Structure de la table `factions`
--
CREATE TABLE IF NOT EXISTS `factions` (
`factionID` int(12) NOT NULL AUTO_INCREMENT,
`factionName` varchar(32) DEFAULT NULL,
`factionColor` int(12) DEFAULT '0',
`factionType` int(12) DEFAULT '0',
`factionRanks` int(12) DEFAULT '0',
`factionLockerX` float DEFAULT '0',
`factionLockerY` float DEFAULT '0',
`factionLockerZ` float DEFAULT '0',
`factionLockerInt` int(12) DEFAULT '0',
`factionLockerWorld` int(12) DEFAULT '0',
`factionWeapon1` int(12) DEFAULT '0',
`factionAmmo1` int(12) DEFAULT '0',
`factionWeapon2` int(12) DEFAULT '0',
`factionAmmo2` int(12) DEFAULT '0',
`factionWeapon3` int(12) DEFAULT '0',
`factionAmmo3` int(12) DEFAULT '0',
`factionWeapon4` int(12) DEFAULT '0',
`factionAmmo4` int(12) DEFAULT '0',
`factionWeapon5` int(12) DEFAULT '0',
`factionAmmo5` int(12) DEFAULT '0',
`factionWeapon6` int(12) DEFAULT '0',
`factionAmmo6` int(12) DEFAULT '0',
`factionWeapon7` int(12) DEFAULT '0',
`factionAmmo7` int(12) DEFAULT '0',
`factionWeapon8` int(12) DEFAULT '0',
`factionAmmo8` int(12) DEFAULT '0',
`factionWeapon9` int(12) DEFAULT '0',
`factionAmmo9` int(12) DEFAULT '0',
`factionWeapon10` int(12) DEFAULT '0',
`factionAmmo10` int(12) DEFAULT '0',
`factionRank1` varchar(32) DEFAULT NULL,
`factionRank2` varchar(32) DEFAULT NULL,
`factionRank3` varchar(32) DEFAULT NULL,
`factionRank4` varchar(32) DEFAULT NULL,
`factionRank5` varchar(32) DEFAULT NULL,
`factionRank6` varchar(32) DEFAULT NULL,
`factionRank7` varchar(32) DEFAULT NULL,
`factionRank8` varchar(32) DEFAULT NULL,
`factionRank9` varchar(32) DEFAULT NULL,
`factionRank10` varchar(32) DEFAULT NULL,
`factionRank11` varchar(32) DEFAULT NULL,
`factionRank12` varchar(32) DEFAULT NULL,
`factionRank13` varchar(32) DEFAULT NULL,
`factionRank14` varchar(32) DEFAULT NULL,
`factionRank15` varchar(32) DEFAULT NULL,
`factionSkin1` int(12) DEFAULT '0',
`factionSkin2` int(12) DEFAULT '0',
`factionSkin3` int(12) DEFAULT '0',
`factionSkin4` int(12) DEFAULT '0',
`factionSkin5` int(12) DEFAULT '0',
`factionSkin6` int(12) DEFAULT '0',
`factionSkin7` int(12) DEFAULT '0',
`factionSkin8` int(12) DEFAULT '0',
`SpawnX` float NOT NULL,
`SpawnY` float NOT NULL,
`SpawnZ` float NOT NULL,
`SpawnInterior` int(11) NOT NULL,
`SpawnVW` int(1) NOT NULL,
PRIMARY KEY (`factionID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
--
-- Contenu de la table `factions`
--
INSERT INTO `factions` (`factionID`, `factionName`, `factionColor`, `factionType`, `factionRanks`, `factionLockerX`, `factionLockerY`, `factionLockerZ`, `factionLockerInt`, `factionLockerWorld`, `factionWeapon1`, `factionAmmo1`, `factionWeapon2`, `factionAmmo2`, `factionWeapon3`, `factionAmmo3`, `factionWeapon4`, `factionAmmo4`, `factionWeapon5`, `factionAmmo5`, `factionWeapon6`, `factionAmmo6`, `factionWeapon7`, `factionAmmo7`, `factionWeapon8`, `factionAmmo8`, `factionWeapon9`, `factionAmmo9`, `factionWeapon10`, `factionAmmo10`, `factionRank1`, `factionRank2`, `factionRank3`, `factionRank4`, `factionRank5`, `factionRank6`, `factionRank7`, `factionRank8`, `factionRank9`, `factionRank10`, `factionRank11`, `factionRank12`, `factionRank13`, `factionRank14`, `factionRank15`, `factionSkin1`, `factionSkin2`, `factionSkin3`, `factionSkin4`, `factionSkin5`, `factionSkin6`, `factionSkin7`, `factionSkin8`, `SpawnX`, `SpawnY`, `SpawnZ`, `SpawnInterior`, `SpawnVW`) VALUES
(1, 'Los Santos Police Departement.', -256, 1, 5, 1591.01, -1753.53, -36.814, 1, 0, 24, 500, 31, 50, 25, 500, 34, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 286, 285, 280, 283, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(2, 'Legendary Motors', -256, 6, 5, 2000.92, -1768.07, 13.2505, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(3, 'Los Santos Medical Center', -256, 3, 5, -196.663, -1748.87, 675.769, 3, 5003, 42, 2000, 22, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 274, 275, 276, 277, 278, 279, 0, 0, 0, 0, 0, 0, 0),
(4, 'C.I.A', -256, 1, 5, 215.546, 187.762, 1003.03, 3, 7060, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(5, 'Groove street', -256, 5, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(7, '19Th Piru Street.', 3, 5, 5, 2055.87, -1717.78, 13.5546, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 14, 6, 19, 69, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(9, 'Cosa Nostra', -256, 2, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(10, 'Hells Angels', -256, 5, 5, 1083.14, -1227.01, 15.8203, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(11, 'Cartel De Sinaloa', -256, 5, 5, 2321.47, -1007.47, 1050.21, 9, 5037, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(12, 'Mairie', -256, 4, 5, 351.936, 197.19, 1008.38, 3, 7056, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rang 1', 'Rang 2', 'Rang 3', 'Rang 4', 'Rang 5', 'Rang 6', 'Rang 7', 'Rang 8', 'Rang 9', 'Rang 10', 'Rang 11', 'Rang 12', 'Rang 13', 'Rang 14', 'Rang 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Structure de la table `furniture`
--
CREATE TABLE IF NOT EXISTS `furniture` (
`ID` int(12) DEFAULT '0',
`furnitureID` int(12) NOT NULL AUTO_INCREMENT,
`furnitureName` varchar(32) DEFAULT NULL,
`furnitureModel` int(12) DEFAULT '0',
`furnitureX` float DEFAULT '0',
`furnitureY` float DEFAULT '0',
`furnitureZ` float DEFAULT '0',
`furnitureRX` float DEFAULT '0',
`furnitureRY` float DEFAULT '0',
`furnitureRZ` float DEFAULT '0',
`furnitureType` int(12) DEFAULT '0',
PRIMARY KEY (`furnitureID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Contenu de la table `furniture`
--
INSERT INTO `furniture` (`ID`, `furnitureID`, `furnitureName`, `furnitureModel`, `furnitureX`, `furnitureY`, `furnitureZ`, `furnitureRX`, `furnitureRY`, `furnitureRZ`, `furnitureType`) VALUES
(31, 5, 'Table 27', 2030, 2256.76, -1212.68, 1047.52, 0, 0, 58.353, 0),
(13, 6, 'Exercise Bike', 2630, 2257.54, -1213.85, 1048, 0, 0, -91.5989, 0),
(13, 7, 'Table 1', 1433, 2257.04, -1209.72, 1048.15, 0, 0, 179.868, 0);
-- --------------------------------------------------------
--
-- Structure de la table `garbage`
--
CREATE TABLE IF NOT EXISTS `garbage` (
`garbageID` int(12) NOT NULL AUTO_INCREMENT,
`garbageModel` int(12) DEFAULT '1236',
`garbageCapacity` int(12) DEFAULT '0',
`garbageX` float DEFAULT '0',
`garbageY` float DEFAULT '0',
`garbageZ` float DEFAULT '0',
`garbageA` float DEFAULT '0',
`garbageInterior` int(12) DEFAULT '0',
`garbageWorld` int(12) DEFAULT '0',
PRIMARY KEY (`garbageID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
--
-- Contenu de la table `garbage`
--
INSERT INTO `garbage` (`garbageID`, `garbageModel`, `garbageCapacity`, `garbageX`, `garbageY`, `garbageZ`, `garbageA`, `garbageInterior`, `garbageWorld`) VALUES
(6, 1300, 0, 1523.63, -1679.98, 13.5466, 0.18, 0, 0),
(7, 1236, 0, 1543.68, -1450.2, 13.5468, 178.238, 0, 0),
(8, 1300, 0, 1721.38, -1422.12, 13.5468, 358.144, 0, 0),
(13, 1236, 0, 1860.89, -1392.38, 13.5625, 268.911, 0, 0),
(14, 1300, 0, 2039.98, -1418.98, 17.1707, 169.95, 0, 0),
(17, 1236, 0, 2119.55, -1790.12, 13.5546, 179.271, 0, 0),
(18, 1300, 0, 1953.72, -1765.36, 13.5466, 159.831, 0, 0),
(19, 1300, 0, 1778.25, -1861.47, 13.5775, 269.077, 0, 0),
(21, 1236, 0, 1837.22, -1833.72, 13.5853, 178.378, 0, 0),
(22, 1300, 0, 1576.51, -1878.71, 13.5468, 92.6052, 0, 0),
(23, 1300, 0, 1468.58, -1738.63, 13.5466, 355.203, 0, 0),
(24, 1300, 0, 1254.53, -1534.78, 13.8196, 69.1896, 0, 0),
(25, 1300, 0, 1093.98, -1566.11, 13.5468, 88.0808, 0, 0),
(26, 1300, 0, 1189.49, -1344.44, 13.5652, 174.015, 0, 0),
(28, 1300, 0, 804.087, -1718.1, 13.5468, 328.387, 0, 0),
(30, 1300, 0, 1714.77, -1721.57, 13.5468, 16.9734, 0, 0),
(31, 1300, 0, 1068.67, -1353.43, 13.5468, 359.106, 0, 0);
-- --------------------------------------------------------
--
-- Structure de la table `gates`
--
CREATE TABLE IF NOT EXISTS `gates` (
`gateID` int(12) NOT NULL AUTO_INCREMENT,
`gateModel` int(12) DEFAULT '0',
`gateSpeed` float DEFAULT '0',
`gateTime` int(12) DEFAULT '0',
`gateX` float DEFAULT '0',
`gateY` float DEFAULT '0',
`gateZ` float DEFAULT '0',
`gateRX` float DEFAULT '0',
`gateRY` float DEFAULT '0',
`gateRZ` float DEFAULT '0',
`gateInterior` int(12) DEFAULT '0',
`gateWorld` int(12) DEFAULT '0',
`gateMoveX` float DEFAULT '0',
`gateMoveY` float DEFAULT '0',
`gateMoveZ` float DEFAULT '0',
`gateMoveRX` float DEFAULT '0',
`gateMoveRY` float DEFAULT '0',
`gateMoveRZ` float DEFAULT '0',
`gateLinkID` int(12) DEFAULT '0',
`gateFaction` int(12) DEFAULT '0',
`gatePass` varchar(32) DEFAULT NULL,
`gateRadius` float DEFAULT '0',
PRIMARY KEY (`gateID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
--
-- Contenu de la table `gates`
--
INSERT INTO `gates` (`gateID`, `gateModel`, `gateSpeed`, `gateTime`, `gateX`, `gateY`, `gateZ`, `gateRX`, `gateRY`, `gateRZ`, `gateInterior`, `gateWorld`, `gateMoveX`, `gateMoveY`, `gateMoveZ`, `gateMoveRX`, `gateMoveRY`, `gateMoveRZ`, `gateLinkID`, `gateFaction`, `gatePass`, `gateRadius`) VALUES
(1, 11416, 3, 0, 1975.73, -1764.38, 14.3127, 0, 0, -91.3395, 0, 0, 1975.68, -1766.52, 16.78, 0, 77.8, -91.3395, -1, 2, '', 20),
(2, 980, 3, 0, 1802.69, -1743.47, 15.3193, 0, 0, 179.875, 0, 0, 1791.11, -1743.45, 15.3193, 0, 0, 179.875, -1, -1, '', 10),
(8, 980, 3, 0, 1843.28, -1852.59, 12.7327, 0, 0, 89.6146, 0, 0, 1843.28, -1852.53, 14.7128, 0, 0, 89.6146, -1, -1, '', 0),
(9, 980, 3, 0, 1043.87, -1025.92, 33.1914, 0, 0, 179.08, 0, 0, 1041.72, -1026.77, 22.1014, -1000, -1000, -1000, -1, -1, '', 0),
(10, 980, 3, 0, 1579.18, -1613.14, 6.0744, 2.3, 0.7, 90.4639, 0, 7062, 1600.82, -1614.75, 13.0973, 0, 0, 117.464, -1, -1, '', 5),
(11, 980, 3, 17, 1587.7, -1638.59, 14.383, -1.9999, 0, -174.27, 0, 7062, 1587.56, -1638.42, 9.6471, 2.9, 0.7999, -174.67, -1, 8, 'N', 1),
(12, 968, 0.1, 0, 1544.69, -1630.67, 13.1627, -0.4999, -89.5999, -90.1151, 0, 0, 1544.69, -1630.67, 13.1627, -0.0999, -15.8999, -89.7151, -1, 1, '', 20),
(13, 971, 3, 0, 1588.96, -1637.9, 15.0427, 0, 0, -179.676, 0, 0, 1596.8, -1638, 15.0427, 0, 0, -179.676, -1, 1, '', 20),
(14, 1495, 3, 0, 1584.1, -1637.89, 12.4604, 0, 0, 182.35, 0, 0, 1584.1, -1637.89, 12.4604, 0, 0, -91.1495, -1, -1, '', 5),
(16, 980, 3, 0, 1024.75, -1029.28, 32.8389, 0, 0, 0.1225, 0, 0, 1024.82, -1029.61, 21.8989, -1000, -1000, -1000, -1, -1, '', 0),
(17, 980, 3, 0, 1621.96, -1861.93, 15.3087, -0.1999, -0.1999, -178.058, 0, 0, 1632.33, -1861.58, 15.2725, -0.1999, -0.1999, -178.058, -1, 1, '', 5),
(18, 1495, 3, 0, 1585.32, -1717.4, -37.854, 0, 0, 359.491, 1, 0, 1585.32, -1717.4, -37.854, 0, 0, -89.8094, -1, 1, '', 5),
(20, 980, 3, 0, 2071.51, -1831.66, 15.0193, -1.3999, 0.3, 90.3, 0, 0, 2073.64, -1832.36, 3.5545, -1000, -1000, -1000, -1, -1, '', 0),
(22, 980, 3, 0, 2571.22, -1301.85, 1045.79, 0, 0, 268.788, 2, 7013, 2572.11, -1301.87, 1034.12, -1000, -1000, -1000, -1, -1, '', 0),
(23, 980, 3, 0, 1141.08, -1207.23, 20.517, 0, 0, 267.752, 0, 0, 1140.66, -1217.8, 20.517, 0, 0, 267.752, -1, 10, '', 20),
(24, 18764, 3, 0, 1080.19, -1208.32, 17.9919, 0, 0, 89.392, 0, 0, 1075.09, -1206.71, 7.9919, -1000, -1000, -1000, -1, -1, '', 5),
(25, 18764, 3, 0, 1079.95, -1203.56, 17.9946, 0, 0, 93.6055, 0, 0, 1083.71, -1205.04, 7.8046, -1000, -1000, -1000, -1, -1, '', 0),
(26, 986, 3, 0, 1119.73, -1159.6, 24.1152, 0, 0, 178.411, 0, 0, 1126.82, -1159.79, 24.1152, 0, 0, 178.411, -1, -1, '', 5),
(29, 3037, 3, 0, 364.266, -1469.98, 32.5765, 0, 0, 125.941, 0, 0, 364.266, -1469.98, 27.9965, 0, 0, 125.941, -1, 9, '', 10),
(30, 3037, 3, 0, 310.264, -1554.46, 32.7229, 0, 0, -127.944, 0, 0, 310.264, -1554.46, 28.783, 0, 0, -127.944, -1, 9, '', 5);
-- --------------------------------------------------------
--
-- Structure de la table `gps`
--
CREATE TABLE IF NOT EXISTS `gps` (
`ID` int(12) DEFAULT '0',
`locationID` int(12) NOT NULL AUTO_INCREMENT,
`locationName` varchar(32) DEFAULT NULL,
`locationX` float DEFAULT '0',
`locationY` float DEFAULT '0',
`locationZ` float DEFAULT '0',
PRIMARY KEY (`locationID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
--
-- Structure de la table `graffiti`
--
CREATE TABLE IF NOT EXISTS `graffiti` (
`graffitiID` int(12) NOT NULL AUTO_INCREMENT,
`graffitiX` float DEFAULT '0',
`graffitiY` float DEFAULT '0',
`graffitiZ` float DEFAULT '0',
`graffitiAngle` float DEFAULT '0',
`graffitiColor` int(12) DEFAULT '0',
`graffitiText` varchar(64) DEFAULT NULL,
PRIMARY KEY (`graffitiID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Structure de la table `gunracks`
--
CREATE TABLE IF NOT EXISTS `gunracks` (
`rackID` int(12) NOT NULL AUTO_INCREMENT,
`rackHouse` int(12) DEFAULT '0',
`rackX` float DEFAULT '0',
`rackY` float DEFAULT '0',
`rackZ` float DEFAULT '0',
`rackA` float DEFAULT '0',
`rackInterior` int(12) DEFAULT '0',
`rackWorld` int(12) DEFAULT '0',
`rackWeapon1` int(12) DEFAULT '0',
`rackAmmo1` int(12) DEFAULT '0',
`rackWeapon2` int(12) DEFAULT '0',
`rackAmmo2` int(12) DEFAULT '0',
`rackWeapon3` int(12) DEFAULT '0',
`rackAmmo3` int(12) DEFAULT '0',
`rackWeapon4` int(12) DEFAULT '0',
`rackAmmo4` int(12) DEFAULT '0',
PRIMARY KEY (`rackID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `gunracks`
--
-- --------------------------------------------------------
--
-- Structure de la table `houses`
--
CREATE TABLE IF NOT EXISTS `houses` (
`houseID` int(12) NOT NULL AUTO_INCREMENT,
`houseOwner` int(12) DEFAULT '0',
`housePrice` int(12) DEFAULT '0',
`houseAddress` varchar(32) DEFAULT NULL,
`housePosX` float DEFAULT '0',
`housePosY` float DEFAULT '0',
`housePosZ` float DEFAULT '0',
`housePosA` float DEFAULT '0',
`houseIntX` float DEFAULT '0',
`houseIntY` float DEFAULT '0',
`houseIntZ` float DEFAULT '0',
`houseIntA` float DEFAULT '0',
`houseInterior` int(12) DEFAULT '0',
`houseExterior` int(12) DEFAULT '0',
`houseExteriorVW` int(12) DEFAULT '0',
`houseLocked` int(4) DEFAULT '0',
`houseWeapon1` int(12) DEFAULT '0',
`houseAmmo1` int(12) DEFAULT '0',
`houseWeapon2` int(12) DEFAULT '0',
`houseAmmo2` int(12) DEFAULT '0',
`houseWeapon3` int(12) DEFAULT '0',
`houseAmmo3` int(12) DEFAULT '0',
`houseWeapon4` int(12) DEFAULT '0',
`houseAmmo4` int(12) DEFAULT '0',
`houseWeapon5` int(12) DEFAULT '0',
`houseAmmo5` int(12) DEFAULT '0',
`houseWeapon6` int(12) DEFAULT '0',
`houseAmmo6` int(12) DEFAULT '0',
`houseWeapon7` int(12) DEFAULT '0',
`houseAmmo7` int(12) DEFAULT '0',
`houseWeapon8` int(12) DEFAULT '0',
`houseAmmo8` int(12) DEFAULT '0',
`houseWeapon9` int(12) DEFAULT '0',
`houseAmmo9` int(12) DEFAULT '0',
`houseWeapon10` int(12) DEFAULT '0',
`houseAmmo10` int(12) DEFAULT '0',
`houseMoney` int(12) DEFAULT '0',
PRIMARY KEY (`houseID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;
-- --------------------------------------------------------
--
-- Structure de la table `housestorage`
--
CREATE TABLE IF NOT EXISTS `housestorage` (
`ID` int(12) DEFAULT '0',
`itemID` int(12) NOT NULL AUTO_INCREMENT,
`itemName` varchar(32) DEFAULT NULL,
`itemModel` int(12) DEFAULT '0',
`itemQuantity` int(12) DEFAULT '0',
PRIMARY KEY (`itemID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- Structure de la table `impoundlots`
--
CREATE TABLE IF NOT EXISTS `impoundlots` (
`impoundID` int(12) NOT NULL AUTO_INCREMENT,
`impoundLotX` float DEFAULT '0',
`impoundLotY` float DEFAULT '0',
`impoundLotZ` float DEFAULT '0',
`impoundReleaseX` float DEFAULT '0',
`impoundReleaseY` float DEFAULT '0',
`impoundReleaseZ` float DEFAULT '0',
`impoundReleaseInt` int(12) DEFAULT '0',
`impoundReleaseWorld` int(12) DEFAULT '0',
`impoundReleaseA` float DEFAULT '0',
PRIMARY KEY (`impoundID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
-- --------------------------------------------------------
--
-- Structure de la table `inventory`
--
CREATE TABLE IF NOT EXISTS `inventory` (
`ID` int(12) DEFAULT '0',
`invID` int(12) NOT NULL AUTO_INCREMENT,
`invItem` varchar(32) DEFAULT NULL,
`invModel` int(12) DEFAULT '0',
`invQuantity` int(12) DEFAULT '0',
PRIMARY KEY (`invID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=415 ;
-- --------------------------------------------------------
--
-- Structure de la table `jobs`
--
CREATE TABLE IF NOT EXISTS `jobs` (
`jobID` int(12) NOT NULL AUTO_INCREMENT,
`jobPosX` float DEFAULT '0',
`jobPosY` float DEFAULT '0',
`jobPosZ` float DEFAULT '0',
`jobPointX` float DEFAULT '0',
`jobPointY` float DEFAULT '0',
`jobPointZ` float DEFAULT '0',
`jobDeliverX` float DEFAULT '0',
`jobDeliverY` float DEFAULT '0',
`jobDeliverZ` float DEFAULT '0',
`jobInterior` int(12) DEFAULT '0',
`jobWorld` int(12) DEFAULT '0',
`jobType` int(12) DEFAULT '0',
`jobPointInt` int(12) DEFAULT '0',
`jobPointWorld` int(12) DEFAULT '0',
PRIMARY KEY (`jobID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;
--
-- Contenu de la table `jobs`
--
INSERT INTO `jobs` (`jobID`, `jobPosX`, `jobPosY`, `jobPosZ`, `jobPointX`, `jobPointY`, `jobPointZ`, `jobDeliverX`, `jobDeliverY`, `jobDeliverZ`, `jobInterior`, `jobWorld`, `jobType`, `jobPointInt`, `jobPointWorld`) VALUES
(13, 2446.43, -2118.8, 13.5468, 2452.66, -2116.49, 13.5529, 0, 0, 0, 0, 0, 1, 0, 0),
(17, 1297.69, -63.7755, 1002.5, 0, 0, 0, 0, 0, 0, 18, 7067, 4, 0, 0),
(18, 790.254, -1620.72, 13.3905, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0),
(19, 2194.4, -1974.56, 13.5592, 2184.69, -1988.42, 13.5499, 0, 0, 0, 0, 0, 7, 0, 0),
(20, 2561.64, -1293.43, 1044.12, 2558.7, -1295.85, 1044.12, 0, 0, 0, 2, 7013, 9, 2, 7013),
(38, 1752.58, -1864.68, 13.5735, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0),
(39, 2038.98, -1949.62, 13.5468, 2017.13, -1977.75, 13.5468, 2050.95, -1966.17, 16.694, 0, 0, 8, 0, 0),
(40, 1331.08, -882.761, 39.5781, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0);
-- --------------------------------------------------------
--
-- Structure de la table `namechanges`
--
CREATE TABLE IF NOT EXISTS `namechanges` (
`ID` int(12) NOT NULL AUTO_INCREMENT,
`OldName` varchar(24) DEFAULT NULL,
`NewName` varchar(24) DEFAULT NULL,
`Date` varchar(36) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
-- --------------------------------------------------------
--
-- Structure de la table `plants`
--
CREATE TABLE IF NOT EXISTS `plants` (
`plantID` int(12) NOT NULL AUTO_INCREMENT,
`plantType` int(12) DEFAULT '0',
`plantDrugs` int(12) DEFAULT '0',
`plantX` float DEFAULT '0',
`plantY` float DEFAULT '0',
`plantZ` float DEFAULT '0',
`plantA` float DEFAULT '0',
`plantInterior` int(12) DEFAULT '0',
`plantWorld` int(12) DEFAULT '0',
PRIMARY KEY (`plantID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ;
-- --------------------------------------------------------
--
-- Structure de la table `pumps`
--
CREATE TABLE IF NOT EXISTS `pumps` (
`ID` int(12) DEFAULT '0',
`pumpID` int(12) NOT NULL AUTO_INCREMENT,
`pumpPosX` float DEFAULT '0',
`pumpPosY` float DEFAULT '0',
`pumpPosZ` float DEFAULT '0',
`pumpPosA` float DEFAULT '0',
`pumpFuel` int(12) DEFAULT '0',
PRIMARY KEY (`pumpID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;
--
-- Contenu de la table `pumps`
--
INSERT INTO `pumps` (`ID`, `pumpID`, `pumpPosX`, `pumpPosY`, `pumpPosZ`, `pumpPosA`, `pumpFuel`) VALUES
(12, 21, 1942.46, -1776.76, 14.0804, 273.092, 6558),
(12, 22, 1942.43, -1774.74, 14.0906, 275.912, 6769),
(12, 25, 1936.73, -1774.85, 14.1702, 91.0382, 6712),
(12, 26, 1936.79, -1776.81, 14.1105, 89.7851, 6800);
-- --------------------------------------------------------
--
-- Structure de la table `speedcameras`
--
CREATE TABLE IF NOT EXISTS `speedcameras` (
`speedID` int(12) NOT NULL AUTO_INCREMENT,
`speedRange` float DEFAULT '0',
`speedLimit` float DEFAULT '0',
`speedX` float DEFAULT '0',
`speedY` float DEFAULT '0',
`speedZ` float DEFAULT '0',
`speedAngle` float DEFAULT '0',
PRIMARY KEY (`speedID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Structure de la table `tickets`
--
CREATE TABLE IF NOT EXISTS `tickets` (
`ID` int(12) DEFAULT '0',
`ticketID` int(12) NOT NULL AUTO_INCREMENT,
`ticketFee` int(12) DEFAULT '0',
`ticketBy` varchar(24) DEFAULT NULL,
`ticketDate` varchar(36) DEFAULT NULL,
`ticketReason` varchar(32) DEFAULT NULL,
PRIMARY KEY (`ticketID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ;
-- --------------------------------------------------------
--
-- Structure de la table `vendors`
--
CREATE TABLE IF NOT EXISTS `vendors` (
`vendorID` int(12) NOT NULL AUTO_INCREMENT,
`vendorType` int(12) DEFAULT '0',
`vendorX` float DEFAULT '0',
`vendorY` float DEFAULT '0',
`vendorZ` float DEFAULT '0',
`vendorA` float DEFAULT '0',
`vendorInterior` int(12) DEFAULT '0',
`vendorWorld` int(12) DEFAULT '0',
PRIMARY KEY (`vendorID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;
-- --------------------------------------------------------
--
-- Structure de la table `warrants`
--
CREATE TABLE IF NOT EXISTS `warrants` (
`ID` int(12) NOT NULL AUTO_INCREMENT,
`Suspect` varchar(24) DEFAULT NULL,
`Username` varchar(24) DEFAULT NULL,
`Date` varchar(36) DEFAULT NULL,
`Description` varchar(128) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `warrants`
--
La seule condition est de ne pas retirer les crйdits du serveur.
Avant mon poste a йtй supprimer pour une raison inconnue.
Bon jeu a tous :cool:
