You are not logged in.

  • Login
Veuillez visiter notre nouveau forum à https://forum.nitrado.net

Veuillez visiter notre nouveau forum à

https://forum.nitrado.net

Dear visitor, welcome to Communauté - Forum Nitrado.net France - Serveurs de Jeux Prépayés. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

AnthonyFR

Beginner

  • "AnthonyFR" started this thread

Posts: 3

  • Send private message

1

Sunday, July 13th 2014, 4:15pm

Base de donnée

Bonjour la base de données ne sauvegarde pas les véhicule et les licences.
Pouvez vous me donner quelque chose qui fonctionne en version 3.1.3
Ma version:

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `arma3life`
--


-- --------------------------------------------------------

--
-- Table structure for table `players`
--

CREATE TABLE IF NOT EXISTS `players` (
`uid` int(12) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`playerid` varchar(50) NOT NULL,
`cash` int(100) NOT NULL DEFAULT '0',
`bankacc` int(100) NOT NULL DEFAULT '0',
`coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
`cop_licenses` text,
`civ_licenses` text,
`med_licenses` text,
`cop_gear` text NOT NULL,
`mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`arrested` tinyint(1) NOT NULL DEFAULT '0',
`aliases` text NOT NULL,
`adminlevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
`donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`civ_gear` text NOT NULL,
`blacklist` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`uid`),
UNIQUE KEY `playerid` (`playerid`),
KEY `name` (`name`),
KEY `blacklist` (`blacklist`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

-- --------------------------------------------------------

--
-- Table structure for table `vehicles`
--

CREATE TABLE IF NOT EXISTS `vehicles` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`side` varchar(15) NOT NULL,
`classname` varchar(32) NOT NULL,
`type` varchar(12) NOT NULL,
`pid` varchar(32) NOT NULL,
`alive` tinyint(1) NOT NULL DEFAULT '1',
`active` tinyint(1) NOT NULL DEFAULT '0',
`plate` int(20) NOT NULL,
`color` int(20) NOT NULL,
`inventory` varchar(500) NOT NULL,
PRIMARY KEY (`id`),
KEY `side` (`side`),
KEY `pid` (`pid`),
KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Similar threads

wbb.socialBookmark.thread

Rate this thread