Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jul 10th, 2012  |  syntax: None  |  size: 30.22 KB  |  hits: 25  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.2.5
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Jun 01, 2011 at 10:29 AM
  7. -- Server version: 5.0.91
  8. -- PHP Version: 5.2.9
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12.  
  13. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  14. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  15. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  16. /*!40101 SET NAMES utf8 */;
  17.  
  18. --
  19. -- Database: `d3lux_dgrp`
  20. --
  21.  
  22.  
  23. -- PUT THE MYSQL Database name HERE that you are going to use.
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Table structure for table `gmadmin_sessions`
  29. --
  30.  
  31. CREATE TABLE IF NOT EXISTS `gmadmin_sessions` (
  32.   `userid` int(11) NOT NULL,
  33.   `sessionid` text NOT NULL,
  34.   `access` int(11) NOT NULL default '0',
  35.   `last_action` bigint(20) NOT NULL default '0',
  36.   PRIMARY KEY  (`sessionid`(25))
  37. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  38.  
  39. --
  40. -- Dumping data for table `gmadmin_sessions`
  41. --
  42.  
  43.  
  44. -- --------------------------------------------------------
  45.  
  46. --
  47. -- Table structure for table `gmp_users`
  48. --
  49.  
  50. CREATE TABLE IF NOT EXISTS `gmp_users` (
  51.   `steamid` varchar(45) NOT NULL,
  52.   `stars` int(3) NOT NULL,
  53.   `models` varchar(50) default NULL,
  54.   `songs` varchar(50) default NULL,
  55.   PRIMARY KEY  (`steamid`)
  56. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  57.  
  58. --
  59. -- Dumping data for table `gmp_users`
  60. --
  61.  
  62.  
  63. -- --------------------------------------------------------
  64.  
  65. --
  66. -- Table structure for table `gmr2_records`
  67. --
  68.  
  69. CREATE TABLE IF NOT EXISTS `gmr2_records` (
  70.   `map` text NOT NULL,
  71.   `name` text NOT NULL,
  72.   `time` float NOT NULL,
  73.   `steamid` text NOT NULL
  74. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  75.  
  76. --
  77. -- Dumping data for table `gmr2_records`
  78. --
  79.  
  80.  
  81. -- --------------------------------------------------------
  82.  
  83. --
  84. -- Table structure for table `gmr2_users`
  85. --
  86.  
  87. CREATE TABLE IF NOT EXISTS `gmr2_users` (
  88.   `steamid` text NOT NULL,
  89.   `rank` int(11) NOT NULL default '1000',
  90.   `points` int(11) NOT NULL default '0',
  91.   `money` int(11) NOT NULL default '1000',
  92.   `vehicles` text NOT NULL,
  93.   `vehicle_selected` text NOT NULL,
  94.   `time_played` int(11) NOT NULL default '0',
  95.   `achievements` text NOT NULL,
  96.   `lifetime_wins` int(11) NOT NULL default '0',
  97.   `lifetime_races` int(11) NOT NULL default '0',
  98.   `lifetime_records` int(11) NOT NULL default '0',
  99.   `week_wins` int(11) NOT NULL default '0',
  100.   `week_races` int(11) NOT NULL default '0',
  101.   `hat_equipped` int(11) NOT NULL default '0',
  102.   `trinkets_owned` text NOT NULL,
  103.   `records` text NOT NULL,
  104.   PRIMARY KEY  (`steamid`(20))
  105. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  106.  
  107. --
  108. -- Dumping data for table `gmr2_users`
  109. --
  110.  
  111.  
  112. -- --------------------------------------------------------
  113.  
  114. --
  115. -- Table structure for table `ip_intel`
  116. --
  117.  
  118. CREATE TABLE IF NOT EXISTS `ip_intel` (
  119.   `steamid` text NOT NULL,
  120.   `ip` text,
  121.   `name` text,
  122.   `first_seen` bigint(20) default '0',
  123.   `last_seen` bigint(20) default '0',
  124.   `num_seen` int(11) default '0',
  125.   `unique_id` text,
  126.   `rp_name` text,
  127.   `play_time` bigint(20) default '0',
  128.   `strikes` int(11) default '0',
  129.   PRIMARY KEY  (`steamid`(20))
  130. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  131.  
  132. --
  133. -- Dumping data for table `ip_intel`
  134. --
  135.  
  136. INSERT INTO `ip_intel` (`steamid`, `ip`, `name`, `first_seen`, `last_seen`, `num_seen`, `unique_id`, `rp_name`, `play_time`, `strikes`) VALUES
  137. ('STEAM_0:0:10089559', '71.88.8.144', 'killa', 1304217347, 1304634187, 19, '1598655400', 'Johny Davis', 55047, 0),
  138. ('STEAM_0:0:11206044', '188.228.46.13', 'Appelon''', 1306581663, 1306584536, 2, '605537170', 'Kripp Jackson', 3888, 0),
  139. ('STEAM_0:0:11564966', '79.136.33.76', 'diablo@bored', 1304529667, 1304529667, 1, '3862985942', 'John Doe', 163, 0),
  140. ('STEAM_0:0:12355009', '94.145.17.205', '[ivG] |Bozhidar|', 1304252631, 1306661872, 12, '2797143606', 'John Keeth', 26453, 0),
  141. ('STEAM_0:0:18192505', '82.181.179.244', 'JS2-Fin', 1304262136, 1306911349, 6, '394181555', 'Jay Milswood', 25489, 0),
  142. ('STEAM_0:0:26436363', '142.167.100.7', 'RyanJamesJelinek', 1306607897, 1306607897, 1, '3275741684', 'Ryan Jelinek', 975, 0),
  143. ('STEAM_0:0:28425458', '192.168.1.13', 'D3luX - PERP3.5 For Sale!!', 1304187129, 1306512347, 15, '2903522861', 'Joey Moe', 4921, 0),
  144. ('STEAM_0:0:29003134', '70.188.37.134', 'Jedi Negotiator', 1306888416, 1306888416, 1, '2878402035', 'Dakota Brown', 75, 0),
  145. ('STEAM_0:0:29367281', '94.169.160.127', 'Clarkie', 1304463748, 1306604641, 16, '1722240815', 'Clarke Kent', 43362, 0),
  146. ('STEAM_0:0:34731259', '90.149.213.2', 'dead_tetris (nor)', 1304230663, 1306873070, 36, '422550867', 'Dead Doe', 51076, 1),
  147. ('STEAM_0:0:36894842', '81.231.75.84', 'martin 97', 1304247794, 1304625001, 53, '1247886343', 'Martindoe Doeef', 174384, 0),
  148. ('STEAM_0:0:38184055', '76.25.52.118', 'J47xx', 1304301281, 1304301719, 2, '2017798421', 'Bob Sanchez', 1812, 0),
  149. ('STEAM_0:0:5976660', '94.146.238.239', '.# SєσҳҲ» Smurf , Surf', 1304248050, 1304619277, 19, '2263051863', 'Doye Diesel', 24722, 0),
  150. ('STEAM_0:0:8184923', '212.10.9.126', 'Harry[DK]', 1304443899, 1304617828, 9, '2417622913', 'Harry Hansen', 6707, 0),
  151. ('STEAM_0:1:13800802', '', 'D3luX', 1304176832, 1304176832, 1, '926027519', 'Joey Moe', 88, 0),
  152. ('STEAM_0:1:14385382', '41.233.229.159', 'Gimli', 1304519819, 1304519819, 1, '2362508363', 'Sean Greiner', 153, 0),
  153. ('STEAM_0:1:16483968', '109.225.102.152', 'Erik', 1304220309, 1304620745, 29, '4270060006', 'Storrken Mask', 104055, 0),
  154. ('STEAM_0:1:1677849', '99.41.243.76', 'DankComando', 1306607548, 1306607548, 1, '1352743869', 'John Patten', 5740, 0),
  155. ('STEAM_0:1:18489709', '81.136.252.187', '|$|G.H.O.S.T|ツ', 1304366933, 1304366933, 1, '1238134190', 'Herbert Herb', 696, 0),
  156. ('STEAM_0:1:20428146', '94.145.102.122', 'Phreak', 1306578850, 1306593998, 3, '2415135148', 'Vinny Vicent', 16, 0),
  157. ('STEAM_0:1:22207883', '217.210.57.184', '^\\Commander Marcus Skyfallen', 1304367354, 1304638779, 4, '2572655476', 'Marcus Skyfallen', 17950, 0),
  158. ('STEAM_0:1:22211909', '97.95.149.148', 'S.E THEPuNiShEr', 1304210767, 1304644014, 33, '2730284752', 'Bob Sagget', 56428, 0),
  159. ('STEAM_0:1:26171385', '184.58.104.52', 'HavocBlast Education', 1306602843, 1306602843, 1, '2408092919', 'Jacob Kruse', 0, 0),
  160. ('STEAM_0:1:26647117', '76.118.100.61', '[HÏŸT] RobbieGT', 1304464046, 1304464046, 1, '3966222358', 'Jay Hood', 2075, 0),
  161. ('STEAM_0:1:26832224', '89.150.159.235', 'Bambi', 1304367223, 1304367920, 2, '2950273706', 'Jack Downer', 1951, 0),
  162. ('STEAM_0:1:29082872', '90.196.23.79', '^9Vi|NU7-CR4CK3R', 1306597857, 1306597857, 1, '4101016739', 'Derrick Vodka', 0, 0),
  163. ('STEAM_0:1:30800261', '86.150.121.186', '[CSN] xDiamondkingx xTBx', 1304279904, 1304621321, 4, '3087496469', 'Oliver Woods', 6944, 0),
  164. ('STEAM_0:1:31200460', '70.187.91.188', '[MX-Kid] Devineon [S.E]', 1304213588, 1304475021, 6, '2886602957', 'Dustin Leone', 4817, 0),
  165. ('STEAM_0:1:37593602', '95.109.40.140', 'Seok131', 1304212284, 1306614812, 45, '2203554005', 'Lukas Hinz', 109143, 0),
  166. ('STEAM_0:1:37638599', '85.80.132.158', 'ï»›kyline Selling PERP3 15 Doll', 1304261628, 1304262395, 2, '1972925436', 'Chris Doe', 739, 2),
  167. ('STEAM_0:1:38598443', '76.25.55.234', 'Disciple02', 1304301275, 1306613430, 12, '1890582284', 'Disciple Dis', 12893, 0),
  168. ('STEAM_0:1:39000242', '64.253.68.99', 'State Trooper', 1306603160, 1306606151, 3, '2545877065', 'Adam Mcknight', 4437, 0);
  169.  
  170. -- --------------------------------------------------------
  171.  
  172. --
  173. -- Table structure for table `jailbreak`
  174. --
  175.  
  176. CREATE TABLE IF NOT EXISTS `jailbreak` (
  177.   `id` text,
  178.   `admin` text,
  179.   `entered_time` text
  180. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  181.  
  182. --
  183. -- Dumping data for table `jailbreak`
  184. --
  185.  
  186.  
  187. -- --------------------------------------------------------
  188.  
  189. --
  190. -- Table structure for table `pending_users`
  191. --
  192.  
  193. CREATE TABLE IF NOT EXISTS `pending_users` (
  194.   `id` int(11) NOT NULL auto_increment,
  195.   `username` varchar(200) NOT NULL,
  196.   `password` varchar(200) NOT NULL,
  197.   `steamid` varchar(200) NOT NULL,
  198.   `ipaddress` varchar(200) NOT NULL,
  199.   PRIMARY KEY  (`id`)
  200. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  201.  
  202. --
  203. -- Dumping data for table `pending_users`
  204. --
  205.  
  206.  
  207. -- --------------------------------------------------------
  208.  
  209. --
  210. -- Table structure for table `perp_admintime_log`
  211. --
  212.  
  213. CREATE TABLE IF NOT EXISTS `perp_admintime_log` (
  214.   `steamid` varchar(45) NOT NULL,
  215.   `nick` varchar(45) NOT NULL,
  216.   `date` varchar(15) NOT NULL,
  217.   `length` int(11) NOT NULL,
  218.   `Server` smallint(6) NOT NULL
  219. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  220.  
  221. --
  222. -- Dumping data for table `perp_admintime_log`
  223. --
  224.  
  225.  
  226. -- --------------------------------------------------------
  227.  
  228. --
  229. -- Table structure for table `perp_bname`
  230. --
  231.  
  232. CREATE TABLE IF NOT EXISTS `perp_bname` (
  233.   `name` text NOT NULL
  234. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  235.  
  236. --
  237. -- Dumping data for table `perp_bname`
  238. --
  239.  
  240.  
  241. -- --------------------------------------------------------
  242.  
  243. --
  244. -- Table structure for table `perp_fuel`
  245. --
  246.  
  247. CREATE TABLE IF NOT EXISTS `perp_fuel` (
  248.   `uid` int(11) NOT NULL,
  249.   `1` int(11) NOT NULL default '10000',
  250.   `2` int(11) NOT NULL default '10000',
  251.   `3` int(11) NOT NULL default '10000',
  252.   `4` int(11) NOT NULL default '10000',
  253.   `5` int(11) NOT NULL default '10000',
  254.   `6` int(11) NOT NULL default '10000',
  255.   `7` int(11) NOT NULL default '10000',
  256.   `8` int(11) NOT NULL default '10000',
  257.   `9` int(11) NOT NULL default '10000',
  258.   `10` int(11) NOT NULL default '10000',
  259.   `11` int(11) NOT NULL default '10000',
  260.   `12` int(11) NOT NULL default '10000',
  261.   `13` int(11) NOT NULL default '10000',
  262.   `14` int(11) NOT NULL default '10000',
  263.   `15` int(11) NOT NULL default '10000',
  264.   `16` int(11) NOT NULL default '10000',
  265.   `17` int(11) NOT NULL default '10000',
  266.   `18` int(11) NOT NULL default '10000',
  267.   `19` int(11) NOT NULL default '10000',
  268.   `20` int(11) NOT NULL default '10000',
  269.   `21` int(11) NOT NULL default '10000',
  270.   `22` int(11) NOT NULL default '10000',
  271.   `23` int(11) NOT NULL default '10000',
  272.   `24` int(11) NOT NULL default '10000',
  273.   `25` int(11) NOT NULL default '10000',
  274.   `26` int(11) NOT NULL default '10000',
  275.   `27` int(11) NOT NULL default '10000',
  276.   `28` int(11) NOT NULL default '10000',
  277.   `29` int(11) NOT NULL default '10000',
  278.   `30` int(11) NOT NULL default '10000',
  279.   `31` int(11) NOT NULL default '10000',
  280.   `32` int(11) NOT NULL default '10000',
  281.   `33` int(11) NOT NULL default '10000',
  282.   `34` int(11) NOT NULL default '10000',
  283.   `35` int(11) NOT NULL default '10000',
  284.   `36` int(11) NOT NULL default '10000',
  285.   `37` int(11) NOT NULL default '10000',
  286.   `38` int(11) NOT NULL default '10000',
  287.   `39` int(11) NOT NULL default '10000',
  288.   `40` int(11) NOT NULL default '10000',
  289.   `41` int(11) NOT NULL default '10000',
  290.   `42` int(11) NOT NULL default '10000',
  291.   `43` int(11) NOT NULL default '10000',
  292.   `44` int(11) NOT NULL default '10000',
  293.   `45` int(11) NOT NULL default '10000',
  294.   `46` int(11) NOT NULL default '10000',
  295.   `47` int(11) NOT NULL default '10000',
  296.   `48` int(11) NOT NULL default '10000',
  297.   `49` int(11) NOT NULL default '10000',
  298.   `50` int(11) NOT NULL default '10000',
  299.   `51` int(11) NOT NULL default '10000',
  300.   `52` int(11) NOT NULL default '10000',
  301.   `53` int(11) NOT NULL default '10000',
  302.   `54` int(11) NOT NULL default '10000',
  303.   `55` int(11) NOT NULL default '10000',
  304.   PRIMARY KEY  (`uid`)
  305. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  306.  
  307. --
  308. -- Dumping data for table `perp_fuel`
  309. --
  310.  
  311. INSERT INTO `perp_fuel` (`uid`, `1`, `2`, `3`, `4`, `5`, `6`, `7`, `8`, `9`, `10`, `11`, `12`, `13`, `14`, `15`, `16`, `17`, `18`, `19`, `20`, `21`, `22`, `23`, `24`, `25`, `26`, `27`, `28`, `29`, `30`, `31`, `32`, `33`, `34`, `35`, `36`, `37`, `38`, `39`, `40`, `41`, `42`, `43`, `44`, `45`, `46`, `47`, `48`, `49`, `50`, `51`, `52`, `53`, `54`, `55`) VALUES
  312. (2147483647, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000),
  313. (1598655400, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000),
  314. (422550867, 10000, 10000, 10000, 595, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000),
  315. (1247886343, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 456, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 7516, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000),
  316. (1972925436, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000),
  317. (394181555, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000),
  318. (2017798421, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000),
  319. (1890582284, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 9779, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000),
  320. (1238134190, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000),
  321. (1722240815, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 8958, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000),
  322. (605537170, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000),
  323. (1352743869, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000, 10000);
  324.  
  325. -- --------------------------------------------------------
  326.  
  327. --
  328. -- Table structure for table `perp_organization`
  329. --
  330.  
  331. CREATE TABLE IF NOT EXISTS `perp_organization` (
  332.   `name` text NOT NULL,
  333.   `motd` text NOT NULL,
  334.   `owner` text NOT NULL,
  335.   `id` int(11) NOT NULL auto_increment,
  336.   PRIMARY KEY  (`id`)
  337. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=231 ;
  338.  
  339. --
  340. -- Dumping data for table `perp_organization`
  341. --
  342.  
  343. INSERT INTO `perp_organization` (`name`, `motd`, `owner`, `id`) VALUES
  344. ('West Wood Mafia', 'Grow weed, make meth, and plant shrooms XD', 'STEAM_0:0:10089559', 229),
  345. ('Evocity Taxi Service', 'There in a flash', 'STEAM_0:0:29367281', 230);
  346.  
  347. -- --------------------------------------------------------
  348.  
  349. --
  350. -- Table structure for table `perp_system`
  351. --
  352.  
  353. CREATE TABLE IF NOT EXISTS `perp_system` (
  354.   `key` text NOT NULL,
  355.   `value` text NOT NULL,
  356.   PRIMARY KEY  (`key`(15))
  357. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  358.  
  359. --
  360. -- Dumping data for table `perp_system`
  361. --
  362.  
  363.  
  364. -- --------------------------------------------------------
  365.  
  366. --
  367. -- Table structure for table `perp_users`
  368. --
  369.  
  370. CREATE TABLE IF NOT EXISTS `perp_users` (
  371.   `uid` bigint(11) NOT NULL,
  372.   `id` text NOT NULL,
  373.   `steamid` text NOT NULL,
  374.   `blacklists` text NOT NULL,
  375.   `rp_name_first` text NOT NULL,
  376.   `rp_name_last` text NOT NULL,
  377.   `time_played` bigint(20) NOT NULL,
  378.   `cash` bigint(20) NOT NULL,
  379.   `model` text NOT NULL,
  380.   `items` text NOT NULL,
  381.   `skills` text NOT NULL,
  382.   `genes` text NOT NULL,
  383.   `formulas` text NOT NULL,
  384.   `organization` int(11) NOT NULL default '0',
  385.   `bank` bigint(20) NOT NULL,
  386.   `vehicles` text NOT NULL,
  387.   `ringtones` text NOT NULL,
  388.   `ammo_pistol` int(11) unsigned zerofill NOT NULL default '00000000000',
  389.   `ammo_rifle` int(11) unsigned zerofill NOT NULL default '00000000000',
  390.   `ammo_shotgun` int(11) unsigned zerofill NOT NULL default '00000000000',
  391.   `ringtone` int(11) NOT NULL default '1',
  392.   `last_played` text NOT NULL,
  393.   `fuelleft` int(11) NOT NULL default '10000',
  394.   `lastcar` text,
  395.   PRIMARY KEY  (`uid`,`id`(15),`steamid`(15))
  396. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  397.  
  398. --
  399. -- Dumping data for table `perp_users`
  400. --
  401.  
  402. INSERT INTO `perp_users` (`uid`, `id`, `steamid`, `blacklists`, `rp_name_first`, `rp_name_last`, `time_played`, `cash`, `model`, `items`, `skills`, `genes`, `formulas`, `organization`, `bank`, `vehicles`, `ringtones`, `ammo_pistol`, `ammo_rifle`, `ammo_shotgun`, `ringtone`, `last_played`, `fuelleft`, `lastcar`) VALUES
  403. (2730284752, 'STEAM_0:1:22211909', 'STEAM_0:1:22211909', '', 'Bob', 'Sagget', 57633, 0, '1_7_8', '3,36,1;4,36,1;5,89,1;6,27,1;7,15,5;8,14,3;9,15,1;15,9,3;16,6,1;', '2108;1600;76;1516;10;158.25685168803;0;218;40;0;0;0;0;', '0;2;2;2;0;1;0;', '5;', 229, 46705, 'd,2,1,0,0;0,1,1,0,0;', '', 00000000000, 00000000000, 00000000000, 1, '1304644032', 6777, 'd'),
  404. (2903522861, 'STEAM_0:0:28425458', 'STEAM_0:0:28425458', '', 'Joey', 'Moe', 173170, 999890921, '1_4_8', '1,28,1;3,120,1;4,126,1;5,2,1;6,1,1;7,3,1;8,83,5;9,14,3;10,15,2;11,15,3;', '10000;10000;10000;10000;10000;10000;10000;10000;10000;10000;10000;10000;10000;', '0;5;5;5;5;5;5;', '11;12;9;4;8;', 0, 997594777, '0,1,1,0,0;3,1,1,0,0;2,1,1,0,0;4,1,1,0,0;s,3,17,1,1;6,1,1,0,0;', '', 00000000000, 00000000556, 00000000000, 1, '1304264657', 8884, 's'),
  405. (2203554005, 'STEAM_0:1:37593602', 'STEAM_0:1:37593602', '', 'Lukas', 'Hinz', 114822, 0, '1_4_1', '14,27,1;4,15,3;3,14,7;', '2566;2980;6;3566;0;290.14226874709;0;342;0;0;0;0;0;', '0;3;1;1;0;0;0;', '', 0, 412, '0,1,1,0,0;g,1,1,0,0;', '', 00000000000, 00000000000, 00000000000, 1, '1306616367', 4585, 'g'),
  406. (2886602957, 'STEAM_0:1:31200460', 'STEAM_0:1:31200460', '', 'Dustin', 'Leone', 5418, 1954, '1_7_1', '3,16,1;4,14,6;5,111,1;6,1,1;7,83,5;8,64,3;9,12,1;10,4,3;11,25,4;12,5,1;', '143;280;0;170;0;0;0;2;0;0;0;0;0;', '0;0;2;1;0;2;0;', '', 0, 100, 'd,1,1,0,0;0,1,1,0,0;', '', 00000000000, 00000000000, 00000000000, 1, '1304475637', 7951, 'd'),
  407. (1598655400, 'STEAM_0:0:10089559', 'STEAM_0:0:10089559', '', 'Johny', 'Davis', 54898, 5404, '1_1_1', '3,112,1;4,39,1;5,30,1;6,6,1;7,57,10;8,36,1;9,112,1;10,25,2;11,112,1;12,13,10;13,81,1;16,13,10;17,13,10;18,13,10;19,13,10;20,13,10;21,14,1;22,112,1;23,113,1;24,112,1;25,112,1;26,112,1;28,112,1;29,112,1;30,112,1;31,13,10;32,13,9;36,18,1;37,1,1;38,36,1;39,57,1;33,13,10;34,112,1;35,12,1;', '1140;1540;0;263;0;649.16318722814;0;396;104;0;0;0;0;', '0;0;4;2;0;2;0;', '5;', 229, 14848, '0', '', 00000000000, 00000000000, 00000000000, 1, '1304634218', 10000, ''),
  408. (4270060006, 'STEAM_0:1:16483968', 'STEAM_0:1:16483968', '', 'Storrken', 'Mask', 112147, 3211, '1_5_8', '3,36,1;4,13,10;5,13,10;6,13,10;7,2,1;8,14,5;9,13,9;10,15,3;', '3393;3360;2;5508;0;655.171875;0;190;4;0;0;0;0;', '0;2;1;1;0;0;1;', '', 229, 100, '0,1,1,0,0;p,1,1,0,0;', '', 00000000000, 00000000000, 00000000000, 1, '1304630394', 3653, 'p'),
  409. (422550867, 'STEAM_0:0:34731259', 'STEAM_0:0:34731259', '', 'Dead', 'Doe', 49308, 14108, '1_1_1', '3,86,1;4,14,5;5,86,1;6,120,1;7,29,1;8,86,1;9,23,2;10,18,3;11,60,1;12,20,1;13,42,1;14,12,1;', '2621;720;0;1572;10;157.5;0;116;0;0;0;0;0;', '0;2;3;2;0;1;0;', '5;', 229, 2445, '0,1,1,0,0;', '', 00000000055, 00000000000, 00000000000, 1, '1306874011', 7868, 'd'),
  410. (1247886343, 'STEAM_0:0:36894842', 'STEAM_0:0:36894842', '', 'Martindoe', 'Doeef', 184974, 1331, '1_1_8', '3,13,10;4,14,1;5,13,10;6,120,1;7,13,6;8,13,10;9,15,3;', '2809;3020;2;3763;0;429.328125;0;402;424;0;0;0;0;', '0;0;2;2;0;2;1;', '5;11;', 229, 8181, '0,1,1,0,0;E,1,1,0,0;', '', 00000000000, 00000000000, 00000000000, 1, '1304625921', 4474, 'E'),
  411. (2263051863, 'STEAM_0:0:5976660', 'STEAM_0:0:5976660', '', 'Doye', 'Diesel', 25661, 0, '1_4_8', '3,83,2;4,15,5;5,13,10;6,13,1;7,15,1;8,120,1;', '535;0;0;88;0;45;0;0;0;0;0;0;0;', '0;0;4;1;0;0;0;', '', 0, 86682, '0', '', 00000000000, 00000000000, 00000000000, 1, '1304626413', 10000, ''),
  412. (2797143606, 'STEAM_0:0:12355009', 'STEAM_0:0:12355009', '', 'John', 'Keeth', 29125, 0, '1_7_1', '3,27,1;', '1106;0;23;623;0;83.671875;50;52;0;0;0;0;0;', '0;3;1;1;0;0;0;', '', 0, 121224, '0', '', 00000000000, 00000000000, 00000000000, 1, '1306661925', 10000, ''),
  413. (1972925436, 'STEAM_0:1:37638599', 'STEAM_0:1:37638599', '', 'Chris', 'Doe', 726, 0, '1_1_1', '', '31;0;0;0;0;0;0;90;0;0;0;0;0;', '5;0;0;0;0;0;0;', '', 0, 60650, '0', '', 00000000000, 00000000000, 00000000000, 1, '1304262405', 10000, ''),
  414. (394181555, 'STEAM_0:0:18192505', 'STEAM_0:0:18192505', '', 'Jay', 'Milswood', 25316, 0, '1_2_3', '3,1,1;4,14,6;5,12,1;6,43,3;7,13,7;8,15,2;', '340;120;0;137;0;0;25;14;0;0;0;0;0;', '0;3;1;1;0;0;1;', '', 0, 73653, '0', '', 00000000035, 00000000000, 00000000000, 1, '1306912326', 10000, ''),
  415. (3087496469, 'STEAM_0:1:30800261', 'STEAM_0:1:30800261', '', 'Oliver', 'Woods', 6911, 0, '1_7_1', '3,36,1;', '217;0;0;356;0;0;0;0;0;0;0;0;0;', '0;3;0;1;0;0;1;', '', 0, 3208, 'd,1,1,0,0;0,1,1,0,0;', '', 00000000000, 00000000000, 00000000000, 1, '1304624874', 4200, 'd'),
  416. (2417622913, 'STEAM_0:0:8184923', 'STEAM_0:0:8184923', '', 'Harry', 'Hansen', 7434, 5700, '1_9_1', '18,30,2;5,36,1;4,12,1;3,111,1;', '244;300;0;0;0;241.44340234995;0;82;188;0;0;0;0;', '1;0;2;2;0;2;0;', '5;', 0, 36109, '0', '', 00000000000, 00000000000, 00000000000, 1, '1304619004', 10000, ''),
  417. (2017798421, 'STEAM_0:0:38184055', 'STEAM_0:0:38184055', '', 'Bob', 'Sanchez', 1774, 6955, '1_1_5', '', '35;0;0;52;0;0;0;0;0;0;0;0;0;', '0;0;2;1;0;1;1;', '', 0, 15500, 'b,1,1,0,0;0,1,1,0,0;', '', 00000000000, 00000000000, 00000000000, 1, '1304303228', 8454, 'b'),
  418. (2362508363, 'STEAM_0:1:14385382', 'STEAM_0:1:14385382', '', 'Sean', 'Greiner', 138, 60000, '1_9_1', '', '3;0;0;0;0;0;0;0;0;0;0;0;0;', '5;0;0;0;0;0;0;', '', 0, 100, '0', '', 00000000000, 00000000000, 00000000000, 1, '1304519973', 10000, ''),
  419. (1890582284, 'STEAM_0:1:38598443', 'STEAM_0:1:38598443', '', 'Disciple', 'Dis', 14067, 0, '1_7_8', '3,84,1;4,15,3;5,13,9;6,14,3;7,14,9;8,15,2;', '389;160;0;165;0;0;0;6;0;0;0;0;0;', '0;0;2;2;0;1;0;', '', 0, 16202, 'm,8,4,0,1;0,1,1,0,0;', '', 00000000055, 00000000000, 00000000000, 1, '1306616418', 7022, 'm'),
  420. (2415135148, 'STEAM_0:1:20428146', 'STEAM_0:1:20428146', '', 'Vinny', 'Vicent', 5340, 17416, '1_1_5', '4,14,10;5,14,7;', '102;300;0;0;0;0;0;0;0;0;0;0;0;', '3;0;1;1;0;0;0;', '', 0, 504, '0', '', 00000000000, 00000000000, 00000000000, 1, '1306594064', 10000, ''),
  421. (1238134190, 'STEAM_0:1:18489709', 'STEAM_0:1:18489709', '', 'Herbert', 'Herb', 687, 60150, '1_7_1', '', '24;0;0;0;0;0;0;0;0;0;0;0;0;', '5;0;0;0;0;0;0;', '', 0, 400, '0', '', 00000000000, 00000000000, 00000000000, 1, '1304367643', 10000, ''),
  422. (2950273706, 'STEAM_0:1:26832224', 'STEAM_0:1:26832224', '', 'Jack', 'Downer', 1934, 60300, '1_1_1', '3,111,1;', '52;0;0;0;0;0;0;0;0;0;0;0;0;', '5;0;0;0;0;0;0;', '', 0, 1050, '0', '', 00000000000, 00000000000, 00000000000, 1, '1304369253', 10000, ''),
  423. (2572655476, 'STEAM_0:1:22207883', 'STEAM_0:1:22207883', '', 'Marcus', 'Skyfallen', 17837, 0, '1_4_8', '3,2,1;16,2,1;4,57,1;5,15,5;', '265;0;14;823;0;0;0;0;0;0;0;0;0;', '0;0;2;2;1;0;0;', '', 0, 15017, 'd,3,1,0,0;0,1,1,0,0;', '', 00000000064, 00000000000, 00000000000, 1, '1304642052', 4734, 'd'),
  424. (1722240815, 'STEAM_0:0:29367281', 'STEAM_0:0:29367281', '', 'Clarke', 'Kent', 53305, 460, '1_7_8', '7,111,1;70,14,3;4,126,1;8,111,1;32,27,1;68,15,5;6,49,6;3,2,1;29,36,1;5,3,1;', '736;0;16;1249;0;45;0;124;0;0;0;0;0;', '0;2;1;1;0;1;0;', '', 230, 8238, '5,1,1,0,0;0,1,1,0,0;', '', 00000000000, 00000000000, 00000000000, 20, '1304633379', 8958, '5'),
  425. (3966222358, 'STEAM_0:1:26647117', 'STEAM_0:1:26647117', '', 'Jay', 'Hood', 2067, 0, '1_1_1', '3,15,1;', '72;0;0;32;0;0;0;0;0;0;0;0;0;', '0;0;1;1;0;0;3;', '', 0, 11750, 'c,1,1,0,0;0,1,1,0,0;', '', 00000000000, 00000000000, 00000000000, 1, '1304466181', 8849, 'c'),
  426. (3862985942, 'STEAM_0:0:11564966', 'STEAM_0:0:11564966', '', 'John', 'Doe', 150, 60000, '', '', '0;0;0;0;0;0;0;0;0;0;0;0;0;', '5;0;0;0;0;0;0;', '', 0, 150, '0', '', 00000000000, 00000000000, 00000000000, 1, '1304529831', 10000, ''),
  427. (605537170, 'STEAM_0:0:11206044', 'STEAM_0:0:11206044', '', 'Kripp', 'Jackson', 3878, 0, '1_4_1', '3,15,1;6,13,7;4,14,2;5,13,10;', '23;200;0;0;0;0;0;0;0;0;0;0;0;', '0;0;3;1;0;1;0;', '', 0, 16045, '0', '', 00000000000, 00000000000, 00000000000, 1, '1306587716', 10000, ''),
  428. (4101016739, 'STEAM_0:1:29082872', 'STEAM_0:1:29082872', '', 'Derrick', 'Vodka', 1560, 14364, '1_5_1', '3,15,4;', '22;0;0;0;0;0;0;0;0;0;0;0;0;', '5;0;0;0;0;0;0;', '', 0, 624, '0', '', 00000000000, 00000000000, 00000000000, 1, '1306599517', 10000, ''),
  429. (2408092919, 'STEAM_0:1:26171385', 'STEAM_0:1:26171385', '', 'Jacob', 'Kruse', 720, 0, '1_7_1', '', '29;0;0;0;0;0;0;0;0;0;0;0;0;', '0;0;1;2;0;2;0;', '', 0, 15576, '0', '', 00000000000, 00000000000, 00000000000, 1, '1306603560', 10000, ''),
  430. (2545877065, 'STEAM_0:1:39000242', 'STEAM_0:1:39000242', '', 'Adam', 'Mcknight', 4825, 7325, '1_7_1', '3,12,1;6,14,10;4,15,5;5,14,10;', '119;0;0;0;0;0;0;0;0;0;0;0;0;', '0;3;1;1;0;0;0;', '', 0, 3840, '0', '', 00000000000, 00000000000, 00000000000, 1, '1306608723', 10000, ''),
  431. (1352743869, 'STEAM_0:1:1677849', 'STEAM_0:1:1677849', '', 'John', 'Patten', 5687, 4037, '1_7_1', '2,16,1;3,126,1;4,61,2;5,83,6;', '29;0;0;0;0;0;0;0;0;0;0;0;0;', '0;1;1;1;1;0;1;', '', 0, 480, '0', '', 00000000000, 00000000000, 00000000000, 1, '1306613124', 10000, ''),
  432. (3275741684, 'STEAM_0:0:26436363', 'STEAM_0:0:26436363', '', 'Ryan', 'Jelinek', 956, 11952, '1_7_1', '3,15,4;4,29,1;5,23,1;6,18,2;7,62,3;', '101;0;0;0;0;0;0;0;0;0;0;0;0;', '0;0;2;1;0;2;0;', '', 0, 768, '0', '', 00000000000, 00000000000, 00000000000, 1, '1306608849', 10000, ''),
  433. (2878402035, 'STEAM_0:0:29003134', 'STEAM_0:0:29003134', '', 'Dakota', 'Brown', 67, 15000, '1_7_1', '', '8;0;0;0;0;0;0;0;0;0;0;0;0;', '5;0;0;0;0;0;0;', '', 0, 48, '0', '', 00000000000, 00000000000, 00000000000, 1, '1306888489', 10000, '');
  434.  
  435. -- --------------------------------------------------------
  436.  
  437. --
  438. -- Table structure for table `server_bans`
  439. --
  440.  
  441. CREATE TABLE IF NOT EXISTS `server_bans` (
  442.   `steamid` text NOT NULL,
  443.   `unban_time` bigint(20) NOT NULL,
  444.   `banner_name` text NOT NULL,
  445.   `reason` text NOT NULL,
  446.   `banned_name` text NOT NULL,
  447.   PRIMARY KEY  (`steamid`(20))
  448. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  449.  
  450. --
  451. -- Dumping data for table `server_bans`
  452. --
  453.  
  454. INSERT INTO `server_bans` (`steamid`, `unban_time`, `banner_name`, `reason`, `banned_name`) VALUES
  455. ('STEAM_0:1:37638599', 0, 'JS2-Fin', '', 'ï»›kyline Selling PERP3 15 Doll');
  456.  
  457. -- --------------------------------------------------------
  458.  
  459. --
  460. -- Table structure for table `server_bans_logs`
  461. --
  462.  
  463. CREATE TABLE IF NOT EXISTS `server_bans_logs` (
  464.   `id` int(11) NOT NULL auto_increment,
  465.   `steamid` varchar(20) NOT NULL,
  466.   `type` text NOT NULL,
  467.   `committed_by` text NOT NULL,
  468.   `reason` text NOT NULL,
  469.   `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  470.   PRIMARY KEY  (`id`)
  471. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=910 ;
  472.  
  473. --
  474. -- Dumping data for table `server_bans_logs`
  475. --
  476.  
  477. INSERT INTO `server_bans_logs` (`id`, `steamid`, `type`, `committed_by`, `reason`, `date`) VALUES
  478. (904, 'STEAM_0:1:37638599', 'server ban', 'JS2-Fin', '', '2011-05-01 16:06:05'),
  479. (905, 'STEAM_0:1:37638599', 'server ban', 'JS2-Fin', '', '2011-05-01 16:06:39'),
  480. (906, 'STEAM_0:0:10089559', 'server ban', '|DG|Clarkie', 'Anti-Afk', '2011-05-04 00:31:32'),
  481. (907, 'STEAM_0:1:22211909', 'server ban', '|DG|Clarkie', 'Anti-Afk', '2011-05-04 00:32:42'),
  482. (908, 'STEAM_0:1:14385382', 'server ban', 'Autobot', 'Cheats detected.', '2011-05-04 15:39:29'),
  483. (909, 'STEAM_0:0:34731259', 'server ban', '|DG|Clarkie', 'Poor RP', '2011-05-04 17:21:06');
  484.  
  485. -- --------------------------------------------------------
  486.  
  487. --
  488. -- Table structure for table `server_bans_points`
  489. --
  490.  
  491. CREATE TABLE IF NOT EXISTS `server_bans_points` (
  492.   `id` int(11) NOT NULL auto_increment,
  493.   `steamid` text NOT NULL,
  494.   `time` int(11) NOT NULL,
  495.   PRIMARY KEY  (`id`)
  496. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=223 ;
  497.  
  498. --
  499. -- Dumping data for table `server_bans_points`
  500. --
  501.  
  502. INSERT INTO `server_bans_points` (`id`, `steamid`, `time`) VALUES
  503. (220, 'STEAM_0:1:37638599', 1306940771),
  504. (221, 'STEAM_0:1:37638599', 1306940805),
  505. (222, 'STEAM_0:0:34731259', 1307204470);
create a new version of this paste RAW Paste Data