Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 5.1.1
- -- https://www.phpmyadmin.net/
- --
- -- Host: 127.0.0.1
- -- Generation Time: Jul 20, 2022 at 06:39 PM
- -- Server version: 10.4.22-MariaDB
- -- PHP Version: 8.0.13
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- START TRANSACTION;
- 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 utf8mb4 */;
- --
- -- Database: `zmajko`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `players`
- --
- CREATE TABLE `players` (
- `id` int(8) NOT NULL AUTO_INCREMENT,
- `name` varchar(32) NOT NULL,
- `password` int(32) NOT NULL,
- `money` int(18) NOT NULL,
- `admin` int(2) NOT NULL DEFAULT 0,
- `level` int(6) NOT NULL DEFAULT 0,
- `helper` int(1) NOT NULL DEFAULT 0,
- `skin` int(4) NOT NULL,
- `godine` int(3) NOT NULL,
- `sex` int(1) NOT NULL,
- `email` varchar(34) NOT NULL DEFAULT '[email protected]',
- `lider` int(2) NOT NULL DEFAULT 0,
- `clan` int(2) NOT NULL DEFAULT 0,
- `rank` int(1) NOT NULL DEFAULT 0,
- `mutiran` int(1) NOT NULL DEFAULT 0,
- `banka` int(16) NOT NULL DEFAULT 0,
- `zatvor` int(1) NOT NULL DEFAULT 0,
- `zatvorvreme` int(5) NOT NULL DEFAULT 0,
- `pakettime` int(6) NOT NULL DEFAULT 0,
- `respekt` int(8) NOT NULL DEFAULT 0,
- `mats` int(8) NOT NULL DEFAULT 0,
- `payday` int(4) NOT NULL DEFAULT 0,
- `satiigre` int(6) NOT NULL DEFAULT 0,
- `adozvola` int(1) NOT NULL DEFAULT 0,
- `aviondozvola` int(1) NOT NULL DEFAULT 0,
- `gundozvola` int(1) NOT NULL DEFAULT 0,
- `biznis` int(4) NOT NULL DEFAULT -1,
- `mobbroj` int(9) NOT NULL DEFAULT 0,
- `mobkredit` int(9) NOT NULL DEFAULT 0,
- `cigare` int(2) NOT NULL DEFAULT 0,
- `upaljac` int(3) NOT NULL DEFAULT 0,
- `posao` int(2) NOT NULL DEFAULT 0,
- `kuca` int(4) NOT NULL DEFAULT -1,
- `spawn` int(1) NOT NULL DEFAULT 0,
- `rent` int(4) NOT NULL DEFAULT -1,
- `stan` int(4) NOT NULL DEFAULT -1,
- `vozilo1` int(4) NOT NULL DEFAULT -1,
- `vozilo2` int(4) NOT NULL DEFAULT -1,
- `vozilo3` int(4) NOT NULL DEFAULT -1,
- `kradevreme` int(5) NOT NULL DEFAULT 0,
- `vip` int(1) NOT NULL DEFAULT 0,
- `orgmesto` int(2) NOT NULL DEFAULT 0,
- `adminid` int(2) NOT NULL DEFAULT 0,
- `helperid` int(2) NOT NULL DEFAULT 0,
- `uorg` int(6) NOT NULL DEFAULT 0,
- `adminska` int(1) NOT NULL DEFAULT 0,
- `registrovan` int(6) NOT NULL DEFAULT 0,
- `droga` int(6) NOT NULL DEFAULT 0,
- `lotto` int(3) NOT NULL DEFAULT 0,
- `povez` int(1) NOT NULL DEFAULT 0,
- `traka` int(1) NOT NULL DEFAULT 0,
- `zlato` int(8) NOT NULL DEFAULT 0,
- `invweap` int(2) NOT NULL DEFAULT 0,
- `invammo` int(6) NOT NULL DEFAULT 0,
- `kazneni` int(6) NOT NULL DEFAULT 0,
- `rp` int(4) NOT NULL DEFAULT 0,
- `ticket` int(3) NOT NULL DEFAULT 0,
- `uemail` int(1) NOT NULL DEFAULT 0,
- `vodjah` int(1) NOT NULL DEFAULT 0,
- `mutead` int(1) NOT NULL DEFAULT 0,
- `mutear` int(1) NOT NULL DEFAULT 0,
- `simanje` int(1) NOT NULL DEFAULT 0,
- `iimanje` int(6) NOT NULL DEFAULT 0,
- `sljivas` int(6) NOT NULL DEFAULT 0,
- `kruskas` int(6) NOT NULL DEFAULT 0,
- `jabukas` int(6) NOT NULL DEFAULT 0,
- `sljiva` int(6) NOT NULL DEFAULT 0,
- `kruska` int(6) NOT NULL DEFAULT 0,
- `jabuka` int(6) NOT NULL DEFAULT 0,
- `umro` int(2) NOT NULL DEFAULT 0,
- `adminjail` int(1) NOT NULL DEFAULT 0,
- `promoter` int(1) NOT NULL DEFAULT 0,
- `telefon` int(6) NOT NULL DEFAULT 0,
- `bakar` int(6) NOT NULL DEFAULT 0,
- `tajnikod` int(7) NOT NULL DEFAULT 0,
- `lastlogin` varchar(26) NOT NULL DEFAULT 'Nema podataka',
- `tocak` int(5) NOT NULL DEFAULT -1,
- `ngpaket` int(5) NOT NULL DEFAULT -1,
- `markeri` int(5) NOT NULL DEFAULT -1,
- `osiguranje` int(2) NOT NULL DEFAULT 0,
- `facility` int(3) NOT NULL DEFAULT 0,
- `fdroga` int(12) NOT NULL DEFAULT 0,
- `foruzje` int(12) NOT NULL DEFAULT 0,
- `fbtc` int(12) NOT NULL DEFAULT 0,
- `fbtcm` int(12) NOT NULL DEFAULT -1,
- `btclvl` int(3) NOT NULL DEFAULT -1,
- `druglvl` int(3) NOT NULL DEFAULT -1,
- `lock` int(2) NOT NULL DEFAULT -1,
- `neaktivnost` int(5) NOT NULL DEFAULT 0,
- `vipsati` int(5) NOT NULL DEFAULT 0
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- --
- -- Dumping data for table `players`
- --
- INSERT INTO `players` (`id`, `name`, `password`, `money`, `admin`, `level`, `helper`, `skin`, `godine`, `sex`, `email`, `lider`, `clan`, `rank`, `mutiran`, `banka`, `zatvor`, `zatvorvreme`, `pakettime`, `respekt`, `mats`, `payday`, `satiigre`, `adozvola`, `aviondozvola`, `gundozvola`, `biznis`, `mobbroj`, `mobkredit`, `cigare`, `upaljac`, `posao`, `kuca`, `spawn`, `rent`, `stan`, `vozilo1`, `vozilo2`, `vozilo3`, `kradevreme`, `vip`, `orgmesto`, `adminid`, `helperid`, `uorg`, `adminska`, `registrovan`, `droga`, `lotto`, `povez`, `traka`, `zlato`, `invweap`, `invammo`, `kazneni`, `rp`, `ticket`, `uemail`, `vodjah`, `mutead`, `mutear`, `simanje`, `iimanje`, `sljivas`, `kruskas`, `jabukas`, `sljiva`, `kruska`, `jabuka`, `umro`, `adminjail`, `promoter`, `telefon`, `bakar`, `tajnikod`, `lastlogin`, `tocak`, `ngpaket`, `markeri`, `osiguranje`, `facility`, `fdroga`, `foruzje`, `fbtc`, `fbtcm`, `btclvl`, `druglvl`, `lock`, `neaktivnost`, `vipsati`) VALUES
- (0, 'Zmajko', 960038427, 19700, 7, 1, 0, 299, 21, 1, '[email protected]', 0, 0, 0, 0, 3900000, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, -1, 0, 0, 0, 0, 0, -1, 0, -1, -1, -1, -1, -1, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2555, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 998877, '20.7.2022. - 18:26', -1, -1, 0, 0, 0, 0, 0, 0, -1, -1, -1, -1, 0, 0);
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `players`
- --
- /*!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 */;
Advertisement