Advertisement
Whitetigerswt

Untitled

Sep 2nd, 2011
171
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 40.53 KB | None | 0 0
  1. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  2.  
  3.  
  4. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  5. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  6. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  7. /*!40101 SET NAMES utf8 */;
  8.  
  9. --
  10. -- Database: `combinations`
  11. --
  12.  
  13. -- --------------------------------------------------------
  14.  
  15. --
  16. -- Table structure for table `dc_autoweps`
  17. --
  18.  
  19. CREATE TABLE IF NOT EXISTS `dc_autoweps` (
  20.   `slot` INT(11) NOT NULL DEFAULT '0',
  21.   `wep_id` INT(11) NOT NULL DEFAULT '0',
  22.   `wep_ammo` INT(11) NOT NULL DEFAULT '0'
  23. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  24.  
  25. --
  26. -- Dumping data for table `dc_autoweps`
  27. --
  28.  
  29. INSERT INTO `dc_autoweps` (`slot`, `wep_id`, `wep_ammo`) VALUES
  30. (1, 4, 1),
  31. (2, 31, 500),
  32. (3, 0, 0);
  33.  
  34. -- --------------------------------------------------------
  35.  
  36. --
  37. -- Table structure for table `dc_bases`
  38. --
  39.  
  40. CREATE TABLE IF NOT EXISTS `dc_bases` (
  41.   `id` INT(11) NOT NULL,
  42.   `date` VARCHAR(60) NOT NULL,
  43.   `creator` VARCHAR(60) NOT NULL,
  44.   `played` INT(11) NOT NULL,
  45.   `home_x` VARCHAR(60) NOT NULL DEFAULT '0',
  46.   `home_y` VARCHAR(60) NOT NULL DEFAULT '0',
  47.   `home_z` VARCHAR(60) NOT NULL DEFAULT '0',
  48.   `interior` INT(11) NOT NULL DEFAULT '0',
  49.   `d_x` VARCHAR(60) NOT NULL DEFAULT '0',
  50.   `d_y` VARCHAR(60) NOT NULL DEFAULT '0',
  51.   `d_z` VARCHAR(60) NOT NULL DEFAULT '0',
  52.   `a_x` VARCHAR(60) NOT NULL DEFAULT '0',
  53.   `a_y` VARCHAR(60) NOT NULL DEFAULT '0',
  54.   `a_z` VARCHAR(60) NOT NULL DEFAULT '0',
  55.   `name` VARCHAR(60) NOT NULL DEFAULT 'Custom Base',
  56.   `time` INT(11) NOT NULL DEFAULT '12',
  57.   `attwins` INT(11) NOT NULL DEFAULT '0',
  58.   `defwins` INT(11) NOT NULL DEFAULT '0',
  59.   PRIMARY KEY (`id`)
  60. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  61.  
  62. --
  63. -- Dumping data for table `dc_bases`
  64. --
  65.  
  66. INSERT INTO `dc_bases` (`id`, `date`, `creator`, `played`, `home_x`, `home_y`, `home_z`, `interior`, `d_x`, `d_y`, `d_z`, `a_x`, `a_y`, `a_z`, `name`, `time`, `attwins`, `defwins`) VALUES
  67. (83, '4/3/2009', 'Killadel Rydaz', 0, '-2424.823486', '337.387359', '37.002220', 0, '-2414.369628', '330.787841', '34.975502', '-1759.536987', '-160.848617', '3.554687', 'Vank Hoff in the Park', 8, 0, 0),
  68. (82, '4/3/2009', 'Killadel Rydaz', 0, '2262.218017', '62.656551', '26.484375', 0, '2278.775878', '63.355564', '26.484375', '2359.940185', '531.514343', '1.796875', 'Palomino Cheeck', 16, 0, 0),
  69. (81, '4/3/2009', 'Killadel Rydaz', 1, '1727.194458', '-1632.308227', '20.215084', 0, '1723.868530', '-1629.307617', '20.213619', '369.545257', '-2029.700073', '7.671875', 'Commerce Mall', 12, 1, 0),
  70. (80, '4/3/2009', 'Killadel Rydaz', 1, '2801.846923', '-1437.503906', '32.124591', 0, '2802.073486', '-1450.304077', '32.108024', '2500.492431', '-1667.009277', '13.353511', 'LS Parking Building', 12, 0, 0),
  71. (79, '4/3/2009', 'Killadel Rydaz', 1, '892.631652', '-1638.103149', '14.948328', 0, '889.534179', '-1660.444458', '13.546875', '114.163078', '-1658.446166', '9.919113', 'Marina Houses', 12, 0, 0),
  72. (78, '4/3/2009', 'Killadel Rydaz', 1, '1906.965332', '-1319.078979', '14.191029', 0, '1926.018554', '-1318.450561', '16.816658', '2500.492431', '-1667.009277', '13.353511', 'LS Construction Site', 0, 0, 0),
  73. (77, '4/3/2009', 'Killadel Rydaz', 0, '-1586.644897', '40.184814', '17.328125', 0, '-1574.006225', '53.039867', '17.328125', '-2033.042846', '476.847290', '35.171875', 'SF Exports', 0, 0, 0),
  74. (76, '4/3/2009', 'Killadel Rydaz', 1, '2200.556884', '-1144.471313', '1029.796875', 15, '2193.210693', '-1143.130371', '1029.796875', '2222.139160', '-1148.506103', '1025.796875', 'LS Hotel (Interior)', 12, 0, 0),
  75. (75, '4/3/2009', 'Killadel Rydaz', 1, '853.027221', '-1405.105712', '-1.592718', 0, '837.985229', '-1376.458374', '-0.501461', '-139.141128', '-1090.163940', '5.332539', 'LS Market Station', 0, 0, 0),
  76. (74, '4/3/2009', 'Killadel Rydaz', 0, '1217.026000', '-1641.941162', '11.796875', 0, '1223.448608', '-1654.476074', '11.796875', '280.164672', '-1829.182861', '3.853023', 'LS Hospital', 0, 0, 0),
  77. (73, '4/3/2009', 'Killadel Rydaz', 1, '-2535.781738', '47.409564', '8.507811', 0, '-2535.335693', '43.620933', '8.507811', '-2079.921386', '209.374298', '35.313148', 'Hashburry Underground', 12, 0, 0),
  78. (72, '4/3/2009', 'Killadel Rydaz', 2, '-2180.945068', '609.147338', '35.164062', 0, '-2181.870849', '608.322265', '35.164062', '-2079.921386', '209.374298', '35.313148', 'Chinatown Triad Turf', 12, 1, 0),
  79. (71, '4/3/2009', 'Killadel Rydaz', 0, '-2178.766113', '716.478759', '53.891033', 0, '-2177.489501', '703.073181', '53.890625', '-2078.807128', '209.541366', '35.311260', 'Chinatown Lockup', 12, 0, 0),
  80. (70, '4/3/2009', 'Killadel Rydaz', 0, '-1972.915771', '114.449089', '30.658203', 0, '-1974.800537', '126.964881', '27.694049', '-2704.881835', '391.692626', '4.367187', 'Cranberry Station', 12, 0, 0),
  81. (69, '4/3/2009', 'Killadel Rydaz', 0, '-1954.344360', '-858.959838', '35.890884', 0, '-1959.255126', '-888.942321', '35.890884', '-2398.491210', '-589.078613', '132.648437', 'Foster Valley', 12, 0, 0),
  82. (68, '4/3/2009', 'Killadel Rydaz', 0, '-1681.758056', '1210.116088', '21.156250', 0, '-1656.532226', '1207.222900', '21.156250', '-2264.612304', '1334.810791', '7.039062', 'Ottos Autos Showroom', 12, 0, 0),
  83. (67, '4/3/2009', 'Killadel Rydaz', 0, '1513.700439', '-1461.256469', '9.500000', 0, '1519.805175', '-1471.421020', '9.500000', '919.063110', '-1852.397827', '10.030567', 'Commerce Underground', 12, 0, 0),
  84. (66, '4/3/2009', 'Killadel Rydaz', 0, '1653.418212', '-1659.025146', '22.515625', 0, '1648.843017', '-1678.495605', '21.429037', '1529.369628', '-1899.581054', '14.059178', 'Commerce District', 12, 0, 0),
  85. (65, '4/3/2009', 'Killadel Rydaz', 0, '1908.809204', '-1585.400634', '29.049999', 0, '1908.809204', '-1585.400634', '29.049999', '1529.747680', '-1901.684448', '14.141422', 'Idlewood Apartments', 12, 0, 0),
  86. (64, '4/3/2009', 'Killadel Rydaz', 0, '2340.776367', '-1184.374877', '35.544151', 0, '2340.776367', '-1184.374877', '35.544151', '2900.436767', '-1057.820922', '11.040663', 'East LS Housing Complex', 12, 0, 0),
  87. (63, '4/3/2009', 'Killadel Rydaz', 0, '2336.816894', '-1245.159301', '22.500000', 0, '2336.816894', '-1245.159301', '22.500000', '2899.782958', '-1075.306640', '11.095686', 'East Los Santos Garage', 12, 0, 0),
  88. (62, '4/3/2009', 'Killadel Rydaz', 2, '2216.493652', '-1179.592041', '29.797086', 0, '2218.150878', '-1165.192749', '25.726562', '2904.921142', '-1023.717529', '11.046875', 'Ballas Motel', 12, 0, 1),
  89. (61, '4/3/2009', 'Killadel Rydaz', 0, '2249.098876', '-1092.890869', '41.601562', 0, '2249.098876', '-1092.890869', '41.601562', '2907.560302', '-1065.418945', '11.062216', 'Las Colinas', 12, 0, 0),
  90. (60, '4/3/2009', 'Killadel Rydaz', 2, '-91.224624', '-39.037811', '6.484375', 0, '-126.421981', '-55.633087', '3.117187', '-320.990722', '829.177062', '17.545433', 'Blueberry Acres Farm', 12, 1, 0),
  91. (59, '4/3/2009', 'Killadel Rydaz', 1, '1542.883789', '16.292411', '24.140625', 0, '1558.143432', '24.893451', '24.157894', '515.206665', '-220.578170', '15.196421', 'Red County Country Land', 1, 0, 0),
  92. (58, '4/3/2009', 'Killadel Rydaz', 0, '960.757690', '-71.379196', '22.809400', 0, '967.794555', '-85.626167', '19.607133', '1337.498535', '227.931396', '19.406250', 'Fern Ridge', 12, 0, 0),
  93. (57, '4/3/2009', 'Killadel Rydaz', 0, '1291.458251', '-788.069946', '96.460937', 0, '1291.458251', '-788.069946', '96.460937', '592.057556', '-64.161674', '19.889677', 'Custom Base', 12, 0, 0),
  94. (56, '4/3/2009', 'Killadel Rydaz', 0, '721.685791', '-1276.558227', '17.648437', 0, '723.205078', '-1262.555419', '17.648437', '-57.356506', '-1605.355224', '2.785868', 'Vinewood Country Club', 12, 0, 0),
  95. (55, '4/3/2009', 'Killadel Rydaz', 0, '715.628417', '-1692.981445', '2.429687', 0, '705.881530', '-1678.534667', '3.437500', '247.277099', '-1832.685180', '3.699224', 'Marina House Dock', 12, 0, 0),
  96. (54, '4/3/2009', 'Killadel Rydaz', 0, '1691.382202', '-1973.141845', '8.825299', 0, '1724.547973', '-1976.128417', '14.117819', '2780.801269', '-2019.243896', '13.554686', 'Unity Station', 12, 0, 0),
  97. (53, '4/3/2009', 'Killadel Rydaz', 1, '726.380187', '-1474.904052', '17.689085', 0, '704.817626', '-1457.127807', '17.695312', '1792.240966', '-1918.867675', '13.393119', 'Marina Complex', 12, 0, 0),
  98. (52, '4/3/2009', 'Killadel Rydaz', 2, '-1954.293823', '300.598083', '41.047080', 0, '-1951.275024', '267.448852', '41.047080', '-1531.964477', '924.565917', '7.039062', 'Wangs Cars', 12, 1, 0),
  99. (51, '4/3/2009', 'Killadel Rydaz', 1, '-1307.384765', '502.001953', '11.195311', 0, '-1312.941650', '506.004852', '11.195311', '-2079.331542', '208.931472', '35.313835', 'Army Carrier', 12, 0, 0),
  100. (50, '4/3/2009', 'Killadel Rydaz', 4, '2593.250244', '2825.785644', '19.992187', 0, '2578.880371', '2825.062500', '10.820311', '2873.742187', '2397.541015', '10.820311', 'K.A.C.C. Warehouse', 0, 0, 3),
  101. (49, '4/3/2009', 'Killadel Rydaz', 1, '1119.165039', '-1619.431518', '20.514097', 0, '1118.053710', '-1620.040161', '20.503959', '837.127685', '-1918.688476', '12.867186', 'LS Market Place', 1, 1, 0),
  102. (48, '4/3/2009', 'Killadel Rydaz', 2, '-2473.392333', '1549.803833', '33.227333', 0, '-2474.766845', '1549.381469', '33.227333', '-2902.000000', '462.243041', '4.914062', 'San Fierro Freighter', 0, 0, 0),
  103. (47, '4/3/2009', 'Killadel Rydaz', 0, '197.376312', '168.546066', '1003.023437', 3, '202.227706', '168.447006', '1003.023437', '294.007141', '174.704269', '1007.171875', 'SF Police Dep. (Interior)', 0, 0, 0),
  104. (46, '4/3/2009', 'Killadel Rydaz', 1, '2580.294921', '-1284.400268', '1065.358764', 2, '2571.429931', '-1282.672851', '1060.984375', '2526.386474', '-1293.747192', '1048.289062', 'Custom Base', 0, 0, 0),
  105. (44, '4/3/2009', 'Killadel Rydaz', 1, '1232.719726', '-812.038391', '1084.007812', 5, '1243.734985', '-834.619323', '1084.014892', '1263.788452', '-782.503540', '1091.906250', 'Custom Base', 0, 0, 0),
  106. (43, '4/3/2009', 'Killadel Rydaz', 0, '-2143.623535', '-263.656890', '40.719501', 0, '-2168.750976', '-263.140808', '36.515598', '-2083.898681', '214.623199', '35.180599', 'SF Crack Warehouse', 12, 0, 0),
  107. (42, '4/3/2009', 'Killadel Rydaz', 0, '-1845.081298', '-1708.843994', '41.106361', 0, '-1849.714477', '-1710.403808', '40.759475', '-1554.142211', '-2750.180419', '48.534919', 'Angel pines Junkyard', 12, 0, 0),
  108. (41, '4/3/2009', 'Killadel Rydaz', 0, '-2041.439331', '-2346.472656', '46.941406', 0, '-2035.826416', '-2343.680664', '46.383728', '-49.261501', '-1572.157958', '3.067100', 'Angel Pine Sawmill', 12, 0, 0),
  109. (40, '4/3/2009', 'Killadel Rydaz', 2, '2449.112792', '-1479.418579', '37.195312', 0, '2451.110839', '-1477.644165', '37.187995', '2769.362792', '-1955.843872', '13.375806', 'Custom Base', 12, 0, 0),
  110. (39, '4/3/2009', 'Killadel Rydaz', 1, '2562.673828', '788.186706', '10.954500', 0, '2602.265625', '805.283935', '10.954463', '1683.662963', '1620.504516', '10.820300', 'Rockshore East Construction', 12, 0, 1),
  111. (38, '4/3/2009', 'Killadel Rydaz', 2, '710.792724', '1985.064697', '3.459569', 0, '725.170471', '1997.136352', '4.929687', '1683.662963', '1620.504516', '10.820300', 'Bone County House', 12, 0, 0),
  112. (37, '4/3/2009', 'Killadel Rydaz', 0, '2005.501220', '2928.593505', '47.867767', 0, '2005.684814', '2923.526123', '48.312500', '1683.662963', '1620.504516', '10.820300', 'LV Sewage', 12, 0, 0),
  113. (36, '4/3/2009', 'Killadel Rydaz', 1, '1433.642456', '2621.250976', '11.392614', 0, '1433.642456', '2621.250976', '11.392614', '1683.662963', '1620.504516', '10.820300', 'Yellow Bell Station', 12, 0, 1),
  114. (35, '4/3/2009', 'Killadel Rydaz', 0, '2568.934326', '1561.601318', '19.274698', 0, '2567.699707', '1557.224853', '17.203493', '1683.662963', '1620.504516', '10.820300', 'Pilgrim Motel', 12, 0, 0),
  115. (34, '4/3/2009', 'Killadel Rydaz', 1, '2585.343505', '2373.207519', '17.820312', 0, '2571.529052', '2360.252929', '17.820312', '1512.035156', '2242.104736', '10.820311', 'Rock Hotel', 0, 0, 0),
  116. (33, '4/3/2009', 'Killadel Rydaz', 1, '-2187.991210', '-2428.364013', '35.516162', 0, '-2191.728515', '-2423.118652', '35.523437', '-49.261501', '-1572.157958', '3.067100', 'Angel Pine Storage', 12, 1, 0),
  117. (32, '4/3/2009', 'Killadel Rydaz', 0, '2225.770507', '2457.869384', '-7.874581', 0, '2248.812255', '2454.290283', '-7.922358', '2106.838378', '1410.278076', '10.820311', 'SF Police Dep.', 0, 0, 0),
  118. (31, '4/3/2009', 'Killadel Rydaz', 0, '2499.178466', '1153.525024', '25.391725', 0, '2495.642578', '1147.792358', '22.023197', '1683.662963', '1620.504516', '10.820300', 'Old Las Venturas', 12, 0, 0),
  119. (30, '4/3/2009', 'Killadel Rydaz', 0, '1315.276489', '270.412506', '31.628156', 0, '1325.595703', '269.742156', '26.227525', '1534.271484', '-41.287029', '21.096275', 'Abandoned Sprunk Factory', 12, 0, 0),
  120. (29, '4/3/2009', 'Killadel Rydaz', 2, '-2661.122070', '1423.517700', '23.898437', 0, '-2637.897460', '1410.411499', '23.898437', '-1978.614013', '284.990692', '35.171875', 'Custom Base', 0, 0, 1),
  121. (28, '4/3/2009', 'Killadel Rydaz', 0, '-720.827331', '1540.128417', '40.463596', 0, '-727.934082', '1547.070678', '38.990016', '-538.544372', '2628.374023', '53.414062', 'Tierra Robada', 12, 0, 0),
  122. (27, '4/3/2009', 'Killadel Rydaz', 0, '2227.565673', '1938.514770', '31.779699', 0, '2223.841552', '1952.982788', '31.779699', '1683.662963', '1620.504516', '10.820300', 'Starfish Casino Garage', 12, 0, 0),
  123. (26, '4/3/2009', 'Killadel Rydaz', 1, '849.664367', '-1344.428710', '26.050548', 0, '840.372314', '-1355.888061', '26.050548', '-49.261501', '-1572.157958', '3.067100', 'Market Station Rooftop', 12, 0, 0),
  124. (25, '4/3/2009', 'Killadel Rydaz', 0, '183.257629', '-108.058761', '2.023437', 0, '175.058090', '-100.279624', '1.550603', '1534.271484', '-41.287029', '21.096275', 'Blueberry Housing Complex', 12, 0, 0),
  125. (24, '4/3/2009', 'Killadel Rydaz', 2, '-1481.444213', '2626.578857', '58.781250', 0, '-1478.070434', '2634.123535', '62.328125', '-538.544372', '2628.374023', '53.414062', 'El Quebrados', 12, 0, 1),
  126. (23, '4/3/2009', 'Killadel Rydaz', 3, '2647.542480', '1211.278564', '26.923290', 0, '2656.092773', '1212.049072', '26.923290', '1683.662963', '1620.504516', '10.820300', 'LV Abandoned Building', 12, 1, 0),
  127. (22, '4/3/2009', 'Killadel Rydaz', 0, '2531.214843', '-1677.729370', '19.930225', 0, '2486.133300', '-1718.013305', '18.582065', '2769.395507', '-1959.232543', '13.376469', 'Grove Street', 12, 0, 0),
  128. (21, '4/3/2009', 'Killadel Rydaz', 1, '2168.519531', '-2245.367919', '20.158733', 0, '2184.697265', '-2261.592285', '13.422945', '2768.622314', '-1964.929809', '13.378944', 'Willowfield Cargo Hold', 12, 0, 0),
  129. (20, '4/3/2009', 'Killadel Rydaz', 2, '-1307.670776', '2543.107666', '87.742202', 0, '-1290.882568', '2491.188964', '87.017501', '-538.544372', '2628.374023', '53.414062', 'LV Deserted Site', 12, 1, 1),
  130. (19, '4/3/2009', 'Killadel Rydaz', 0, '1462.240844', '-1895.181640', '22.510921', 0, '1479.327148', '-1897.540161', '22.277399', '-65.240493', '-1586.483398', '2.617187', 'Verdant Bluffs Hotel', 12, 0, 0),
  131. (18, '4/3/2009', 'Killadel Rydaz', 1, '-2366.885253', '1536.221191', '2.117199', 0, '-2371.378173', '1551.403076', '2.117187', '-2083.898681', '214.623199', '35.180599', 'SF Cargo Ship', 12, 0, 0),
  132. (17, '4/3/2009', 'Killadel Rydaz', 0, '1197.803955', '-1196.580200', '31.812500', 0, '1187.486694', '-1199.944458', '31.812500', '-49.261501', '-1572.157958', '3.067100', 'Los Santos Market', 12, 0, 0),
  133. (16, '4/3/2009', 'Killadel Rydaz', 0, '2114.321044', '2416.648681', '49.523437', 0, '2090.402832', '2412.060546', '49.523437', '2888.056884', '2418.421630', '10.820311', 'Emerald Island Garage', 1, 0, 0),
  134. (13, '4/3/2009', 'Killadel Rydaz', 2, '-250.569229', '2599.775634', '62.858154', 0, '-237.646499', '2598.596191', '62.703125', '274.293731', '1404.212158', '10.451915', 'Las Payasadas', 16, 0, 1),
  135. (11, '4/3/2009', 'Killadel Rydaz', 0, '2837.407714', '-2371.748046', '31.007799', 0, '2838.500488', '-2370.270507', '31.007812', '2768.940185', '-1968.613037', '13.382082', 'Los Santos Freighter', 12, 0, 0),
  136. (10, '4/3/2009', 'Killadel Rydaz', 1, '-2218.497314', '-338.477661', '44.811080', 0, '-2204.853027', '-313.570709', '35.570312', '-2045.187866', '227.724761', '35.121738', 'Foster Valley Bridge', 0, 0, 0),
  137. (9, '4/3/2009', 'Killadel Rydaz', 0, '1271.475463', '295.177612', '20.656307', 0, '1263.160888', '290.448852', '19.554687', '1534.271484', '-41.287029', '21.096275', 'Montgomery', 12, 0, 0),
  138. (8, '4/3/2009', 'Killadel Rydaz', 0, '1920.498901', '703.002075', '11.132800', 0, '1942.517089', '694.325683', '16.989999', '1683.662963', '1620.504516', '10.820300', 'Last Dime Hotel', 12, 0, 0),
  139. (7, '4/3/2009', 'Killadel Rydaz', 1, '2387.138671', '1829.310668', '6.015625', 0, '2486.671142', '1870.614257', '10.420200', '1683.662963', '1620.504516', '10.820311', 'LV Construction Site', 12, 0, 1),
  140. (6, '4/3/2009', 'Killadel Rydaz', 2, '1428.411987', '1066.952636', '10.025970', 0, '1408.888183', '1066.438354', '10.820311', '1683.662963', '1620.504516', '10.820300', 'LVA Freigh Depot', 12, 2, 0),
  141. (5, '4/3/2009', 'Killadel Rydaz', 5, '-688.331787', '937.673400', '13.632800', 0, '-699.677307', '952.506469', '12.332839', '1683.662963', '1620.504516', '10.820300', 'Toreno Ranch', 12, 2, 2),
  142. (4, '4/3/2009', 'Killadel Rydaz', 2, '-1423.642089', '1490.140502', '1.867200', 0, '-1443.735595', '1485.917358', '11.808400', '-1759.018188', '-163.956558', '3.554687', 'Custom Base', 12, 0, 1),
  143. (3, '4/3/2009', 'Killadel Rydaz', 4, '-1634.193847', '665.850891', '-5.242199', 0, '-1641.587768', '673.655273', '-5.242199', '-2083.898681', '214.623199', '35.180599', 'SF Police Dept.', 12, 1, 1),
  144. (0, '4/3/2009', '[KR]Jose', 0, '1449.276123', '2773.997070', '27.303274', 0, '1484.834594', '2772.900146', '10.820311', '2504.921630', '2523.976318', '21.875000', 'Custom Base', 12, 0, 0),
  145. (1, '4/3/2009', 'Killadel Rydaz', 43, '381.467956', '-2058.532226', '10.718050', 0, '384.070800', '-2071.250488', '7.835937', '-64.920593', '-1590.161499', '2.617187', 'LS Farris Wheel', 12, 5, 4),
  146. (2, '4/3/2009', 'Killadel Rydaz', 1, '-2674.219238', '937.622070', '78.429100', 0, '-2660.477294', '877.740783', '79.773803', '-2083.898681', '214.623199', '35.180599', 'SF Paradiso district', 12, 0, 1),
  147. (45, '4/3/2009', 'Killadel Rydaz', 0, '297.581298', '1816.296142', '4.710937', 0, '292.480712', '1816.226684', '4.726562', '-315.216827', '1520.186035', '75.356956', 'Area 51 (Inside)', 12, 0, 0),
  148. (14, '4/3/2009', 'Killadel Rydaz', 0, '-1816.322875', '1304.382202', '41.148437', 0, '-1813.810424', '1297.423583', '41.497718', '-1762.995239', '-165.330429', '3.554687', 'SF Parking Garage', 16, 0, 0),
  149. (15, '4/3/2009', 'Killadel Rydaz', 2, '935.366638', '2069.948974', '10.820311', 0, '947.405822', '2070.415283', '10.820311', '1812.880981', '2736.020019', '10.835936', 'Whitewood Warehouse', 12, 1, 0),
  150. (12, '4/3/2009', 'Killadel Rydaz', 1, '2130.156250', '-2280.542236', '20.664308', 0, '2137.461181', '-2280.671142', '20.671875', '2768.597167', '-1970.989135', '13.382814', 'Ocean Docks Warehouse', 12, 1, 0),
  151. (84, '4/3/2009', 'Killadel Rydaz', 0, '-2185.960937', '2416.436523', '5.178991', 0, '-2193.890869', '2406.176513', '4.965225', '-1205.499755', '1821.192993', '41.718750', 'Bayside Boat School', 4, 0, 0),
  152. (85, '4/3/2009', 'Killadel Rydaz', 0, '414.274810', '2533.061279', '19.148437', 0, '400.652374', '2530.431152', '16.561435', '1683.466796', '1620.250244', '10.820311', 'Abandoned Airport', 20, 0, 0),
  153. (86, '4/3/2009', 'Killadel Rydaz', 2, '-2816.728027', '-1524.121704', '140.843750', 0, '-2816.547363', '-1522.675048', '140.843750', '-2321.568847', '-1616.064086', '483.731170', 'Chilliad Wood House', 4, 0, 1),
  154. (87, '4/3/2009', 'Killadel Rydaz', 0, '-1112.979736', '-1620.709838', '76.373939', 0, '-1098.832641', '-1646.996704', '76.367187', '-1344.296264', '-575.649719', '14.143964', 'Leafy Hollow', 8, 0, 0),
  155. (88, '4/3/2009', 'Killadel Rydaz', 0, '-1071.666992', '-1202.261108', '129.218750', 0, '-1072.647460', '-1212.938598', '129.218750', '-1344.296264', '-575.649719', '14.143964', 'The Farm', 12, 0, 0),
  156. (89, '4/3/2009', '[KR]Devastator', 0, '-1712.016479', '1037.104248', '17.914062', 0, '-1727.410644', '1033.560546', '17.585937', '-1754.204711', '-167.430236', '3.554687', 'Valet Parking', 16, 0, 0),
  157. (90, '4/3/2009', '[KR]Devastator', 3, '1628.247802', '579.328613', '1.757812', 0, '1628.384155', '582.936401', '1.757812', '314.126342', '37.067981', '2.924169', 'LV Docks', 0, 0, 1),
  158. (91, '4/3/2009', '[KR]Devastator', 0, '569.232788', '824.473815', '-29.843750', 0, '557.685852', '822.488769', '-30.172792', '1628.227905', '579.337036', '1.757812', 'Hunter Quarry', 0, 0, 0),
  159. (92, '4/3/2009', '[KR]Devastator', 1, '263.891479', '-196.376052', '7.061347', 0, '268.123504', '-187.290695', '7.061347', '721.700256', '-529.915771', '16.186794', 'Blueberry Ammunation', 4, 0, 0),
  160. (93, '4/3/2009', '[KR]Jose', 0, '1969.697143', '1644.186523', '12.242186', 0, '1967.941650', '1638.636474', '12.242186', '2349.306152', '1495.779541', '42.820312', 'Custom Base', 12, 0, 0),
  161. (94, '4/3/2009', '[KR]Jose', 0, '1449.276123', '2773.997070', '27.303274', 0, '1484.834594', '2772.900146', '10.820311', '2504.921630', '2523.976318', '21.875000', 'Custom Base', 12, 0, 0);
  162.  
  163. -- --------------------------------------------------------
  164.  
  165. --
  166. -- Table structure for table `dc_clan_stats`
  167. --
  168.  
  169. CREATE TABLE IF NOT EXISTS `dc_clan_stats` (
  170.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  171.   `name` VARCHAR(60) NOT NULL,
  172.   `kills` INT(11) NOT NULL DEFAULT '0',
  173.   `deaths` INT(11) NOT NULL DEFAULT '0',
  174.   `connections` INT(11) NOT NULL DEFAULT '0',
  175.   PRIMARY KEY (`id`)
  176. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
  177.  
  178. --
  179. -- Dumping data for table `dc_clan_stats`
  180. --
  181.  
  182. INSERT INTO `dc_clan_stats` (`id`, `name`, `kills`, `deaths`, `connections`) VALUES
  183. (1, '[KR]', 0, 11, 4),
  184. (3, '[PTM]', 0, 5, 11);
  185.  
  186. -- --------------------------------------------------------
  187.  
  188. --
  189. -- Table structure for table `dc_config`
  190. --
  191.  
  192. CREATE TABLE IF NOT EXISTS `dc_config` (
  193.   `var` VARCHAR(60) NOT NULL,
  194.   `data` VARCHAR(60) NOT NULL
  195. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  196.  
  197. --
  198. -- Dumping data for table `dc_config`
  199. --
  200.  
  201. INSERT INTO `dc_config` (`var`, `data`) VALUES
  202. ('clan_tag', 'PTM'),
  203. ('skin_auto', '0'),
  204. ('skin_home', '166'),
  205. ('skin_subhome', '252'),
  206. ('skin_away', '185'),
  207. ('skin_subaway', '146'),
  208. ('skin_ref', '140'),
  209. ('round_time', '12'),
  210. ('cp_time', '40'),
  211. ('stop_counting', '24'),
  212. ('lobby_coords', '-1310.544921,180.038208,14.148437'),
  213. ('lobby_int', '0'),
  214. ('lobby_weapons', '1'),
  215. ('duels', '1'),
  216. ('homeskin', '156'),
  217. ('awayskin', '292'),
  218. ('roundhealth', '100'),
  219. ('roundarmour', '100'),
  220. ('globalhealth', '100'),
  221. ('globalarmour', '100'),
  222. ('nametag_distance', '20'),
  223. ('rotatecamera', '1'),
  224. ('uavradar', '0'),
  225. ('tk', '1'),
  226. ('time', '22'),
  227. ('weather', '14'),
  228. ('explosives', '0'),
  229. ('timer', '1'),
  230. ('awaycolor1', '0x84000000'),
  231. ('votetime', '20'),
  232. ('homename', 'Home'),
  233. ('awayname', 'Away'),
  234. ('refname', 'Referee'),
  235. ('hintmessages', '1'),
  236. ('autohud', '1'),
  237. ('vehiclemod', '1'),
  238. ('weapondrop', '0'),
  239. ('pausemessages', '1'),
  240. ('textdrawlayout', '2'),
  241. ('saveresults', '1'),
  242. ('roundlimit', '10'),
  243. ('deadtag', 'DEAD'),
  244. ('gameplay', '1'),
  245. ('weaponsystem', '1'),
  246. ('lobbyvehicles', '1'),
  247. ('nick', '1'),
  248. ('autoreadd', '1'),
  249. ('autospec', '0'),
  250. ('cp_size', '2'),
  251. ('vehiclemsg', 'GTFO'),
  252. ('intro_string', 'Deadly Combinations'),
  253. ('intro_substring', 'Pro'),
  254. ('hud', '1'),
  255. ('lobby_td', '1'),
  256. ('use_intro', '1'),
  257. ('fullset', '4,24,27,29,31,34'),
  258. ('rule_1', 'No hacking or cheating'),
  259. ('rule_2', 'No flaming or swearing'),
  260. ('rule_3', 'No bug abusing'),
  261. ('rule_4', 'Vehicles are not weapons'),
  262. ('rule_5', 'Have Fun'),
  263. ('death_msg', 'PWNT NOOB'),
  264. ('speedmeter', '1'),
  265. ('autologin', '1'),
  266. ('skin', '1'),
  267. ('plimit', '0'),
  268. ('homecolor1', '0x58585800'),
  269. ('awaycolor2', '0xFFA6A600'),
  270. ('homecolor2', '0x9F9F9F00'),
  271. ('refmode', '2'),
  272. ('autobalance', '0'),
  273. ('autoinvert', '0'),
  274. ('classic_chat', '0'),
  275. ('diag', '0'),
  276. ('antisktime', '5000'),
  277. ('laser', '0'),
  278. ('forcereg', '0'),
  279. ('tdmpoints', '25');
  280.  
  281. -- --------------------------------------------------------
  282.  
  283. --
  284. -- Table structure for table `dc_country_stats`
  285. --
  286.  
  287. CREATE TABLE IF NOT EXISTS `dc_country_stats` (
  288.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  289.   `name` VARCHAR(60) NOT NULL,
  290.   `kills` INT(11) NOT NULL DEFAULT '0',
  291.   `deaths` INT(11) NOT NULL DEFAULT '0',
  292.   `connections` INT(11) NOT NULL DEFAULT '0',
  293.   PRIMARY KEY (`id`)
  294. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
  295.  
  296. --
  297. -- Dumping data for table `dc_country_stats`
  298. --
  299.  
  300. -- --------------------------------------------------------
  301.  
  302. --
  303. -- Table structure for table `dc_deathmatch`
  304. --
  305.  
  306. CREATE TABLE IF NOT EXISTS `dc_deathmatch` (
  307.   `id` INT(11) NOT NULL,
  308.   `name` VARCHAR(50) NOT NULL,
  309.   `min` VARCHAR(80) NOT NULL,
  310.   `max` VARCHAR(80) NOT NULL,
  311.   `center` VARCHAR(100) NOT NULL,
  312.   `guns` VARCHAR(120) NOT NULL
  313. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  314.  
  315. --
  316. -- Dumping data for table `dc_deathmatch`
  317. --
  318.  
  319. INSERT INTO `dc_deathmatch` (`id`, `name`, `min`, `max`, `center`, `guns`) VALUES
  320. (1, 'Deagle & Comb', '-2096.316650,-280.721832', '-2011.487060,-103.432769', '45', '24.000000,27.000000,31.000000,34.000000,0.000000'),
  321. (2, 'Random Weps FTW', '-2659.320800,2108.726074', '-2487.859863,2207.654052', '-2572.587890,2140.717041,-42.874614,0.000000', '-1');
  322.  
  323. -- --------------------------------------------------------
  324.  
  325. --
  326. -- Table structure for table `dc_duels`
  327. --
  328.  
  329. CREATE TABLE IF NOT EXISTS `dc_duels` (
  330.   `id` INT(11) NOT NULL,
  331.   `name` VARCHAR(60) NOT NULL,
  332.   `p1` VARCHAR(60) NOT NULL,
  333.   `p2` VARCHAR(60) NOT NULL,
  334.   `weapons` VARCHAR(180) NOT NULL,
  335.   PRIMARY KEY (`id`)
  336. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  337.  
  338. --
  339. -- Dumping data for table `dc_duels`
  340. --
  341.  
  342. INSERT INTO `dc_duels` (`id`, `name`, `p1`, `p2`, `weapons`) VALUES
  343. (1, 'Deagle', '1905.976196,-1655.214721,31.811527,87.348396', '1843.274414,-1653.131958,31.804687,270.626770,0.000000', '24.000000,0.000000,0.000000,0.000000,0.000000'),
  344. (2, 'Combat Shotgun', '1647.225219,-2286.111083,-1.211817,269.654541', '1718.403320,-2286.426513,-1.207459,89.341194,0.000000', '27.000000,0.000000,0.000000,0.000000,0.000000'),
  345. (3, 'Sniper Rifle', '365.722229,-2054.551757,15.406600,0.514208', '375.807342,-1885.813232,7.408961,353.307464,0.000000', '34.000000,0.000000,0.000000,0.000000,0.000000'),
  346. (4, 'Deagle & Pump', '-2182.614257,385.124267,59.548851,357.824768', '-2180.974121,445.272949,59.548851,177.029739,0.000000', '24.000000,25.000000,0.000000,0.000000,0.000000'),
  347. (5, 'Deagle & Combat', '1610.399169,1205.461303,10.812500,128.854141', '1557.784790,1164.993408,10.805154,308.790313,0.000000', '24.000000,27.000000,0.000000,0.000000,0.000000'),
  348. (6, 'M4', '2236.225585,-1188.724121,1029.804321,91.470809', '2193.265136,-1188.468261,1029.796875,270.362426,15.000000', '31.000000,0.000000,0.000000,0.000000,0.000000'),
  349. (7, 'Walking Combo', '-2263.641113,2285.985107,4.820213,359.784820', '-2263.083007,2337.642333,4.812500,180.411483,0.000000', '24.000000,27.000000,31.000000,34.000000,0.000000'),
  350. (8, 'Sawnies & Tec', '2519.756103,2355.932617,4.217899,358.044311', '2520.760498,2396.419433,4.210937,172.605468,0.000000', '26.000000,32.000000,0.000000,0.000000,0.000000'),
  351. (9, '', '-1489.734375,-3.569543,14.148437,133.867065', '', '');
  352.  
  353. -- --------------------------------------------------------
  354.  
  355. --
  356. -- Table structure for table `dc_game_sessions`
  357. --
  358.  
  359. CREATE TABLE IF NOT EXISTS `dc_game_sessions` (
  360.   `playerid` INT(11) NOT NULL,
  361.   `nickname` VARCHAR(60) NOT NULL,
  362.   `ip` VARCHAR(60) NOT NULL,
  363.   `country` VARCHAR(100) NOT NULL,
  364.   `team` VARCHAR(280) DEFAULT '-----',
  365.   `is_loggedin` INT(11) NOT NULL DEFAULT '0',
  366.   `kills` INT(11) NOT NULL,
  367.   `deaths` INT(11) NOT NULL
  368. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  369.  
  370. --
  371. -- Dumping data for table `dc_game_sessions`
  372. --
  373.  
  374.  
  375. -- --------------------------------------------------------
  376.  
  377. --
  378. -- Table structure for table `dc_players`
  379. --
  380.  
  381. CREATE TABLE IF NOT EXISTS `dc_players` (
  382.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  383.   `name` VARCHAR(60) NOT NULL,
  384.   `password` VARCHAR(80) NOT NULL,
  385.   `AdminLevel` INT(11) NOT NULL,
  386.   `RegisterDate` VARCHAR(80) NOT NULL,
  387.   `LastUpdate` VARCHAR(80) NOT NULL,
  388.   `RoundsPlayedEx` INT(11) NOT NULL DEFAULT '0',
  389.   `Kills` INT(11) NOT NULL DEFAULT '0',
  390.   `Deaths` INT(11) NOT NULL DEFAULT '0',
  391.   `KillSpree` INT(11) NOT NULL DEFAULT '0',
  392.   `DeathSpree` INT(11) NOT NULL DEFAULT '0',
  393.   `CaptureTimes` INT(11) NOT NULL DEFAULT '0',
  394.   `OnlineTime` INT(11) NOT NULL DEFAULT '0',
  395.   `RoundDeathsEx` INT(11) NOT NULL DEFAULT '0',
  396.   `RoundKillsEx` INT(11) NOT NULL DEFAULT '0',
  397.   `DuelsWon` INT(11) NOT NULL DEFAULT '0',
  398.   `DuelsLost` INT(11) NOT NULL DEFAULT '0',
  399.   `CarColor1` INT(11) NOT NULL DEFAULT '-1',
  400.   `CarColor2` INT(11) NOT NULL DEFAULT '-1',
  401.   `spawn` VARCHAR(100) NOT NULL DEFAULT '0',
  402.   `spawntype` INT(11) NOT NULL DEFAULT '0',
  403.   `unix_regtime` TIME NOT NULL DEFAULT '0',
  404.   `lastloginip` VARCHAR(60) NOT NULL DEFAULT '0',
  405.   `country` VARCHAR(200) NOT NULL DEFAULT 'Unknown',
  406.   `fightstyle` INT(11) NOT NULL DEFAULT '4',
  407.   `Language` INT(11) NOT NULL DEFAULT '0',
  408.   `DMKills` INT(11) NOT NULL DEFAULT '0',
  409.   `DMDeaths` INT(11) NOT NULL DEFAULT '0',
  410.   `DMPlayTime` INT(11) NOT NULL DEFAULT '0',
  411.   PRIMARY KEY (`id`)
  412. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
  413.  
  414. --
  415. -- Dumping data for table `dc_players`
  416. --
  417.  
  418.  
  419. -- --------------------------------------------------------
  420.  
  421. --
  422. -- Table structure for table `dc_players_getgun`
  423. --
  424.  
  425. CREATE TABLE IF NOT EXISTS `dc_players_getgun` (
  426.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  427.   `getgunweap_0` INT(11) NOT NULL DEFAULT '0',
  428.   `getgunammo_0` INT(11) NOT NULL DEFAULT '0',
  429.   `getgunweap_1` INT(11) NOT NULL DEFAULT '0',
  430.   `getgunammo_1` INT(11) NOT NULL DEFAULT '0',
  431.   `getgunweap_2` INT(11) NOT NULL DEFAULT '0',
  432.   `getgunammo_2` INT(11) NOT NULL DEFAULT '0',
  433.   `getgunweap_3` INT(11) NOT NULL DEFAULT '0',
  434.   `getgunammo_3` INT(11) NOT NULL DEFAULT '0',
  435.   `getgunweap_4` INT(11) NOT NULL DEFAULT '0',
  436.   `getgunammo_4` INT(11) NOT NULL DEFAULT '0',
  437.   `getgunweap_5` INT(11) NOT NULL DEFAULT '0',
  438.   `getgunammo_5` INT(11) NOT NULL DEFAULT '0',
  439.   `getgunweap_6` INT(11) NOT NULL DEFAULT '0',
  440.   `getgunammo_6` INT(11) NOT NULL DEFAULT '0',
  441.   `getgunweap_7` INT(11) NOT NULL DEFAULT '0',
  442.   `getgunammo_7` INT(11) NOT NULL DEFAULT '0',
  443.   `getgunweap_8` INT(11) NOT NULL DEFAULT '0',
  444.   `getgunammo_8` INT(11) NOT NULL DEFAULT '0',
  445.   `getgunweap_9` INT(11) NOT NULL DEFAULT '0',
  446.   `getgunammo_9` INT(11) NOT NULL DEFAULT '0',
  447.   `getgunweap_10` INT(11) NOT NULL DEFAULT '0',
  448.   `getgunammo_10` INT(11) NOT NULL DEFAULT '0',
  449.   `getgunweap_11` INT(11) NOT NULL DEFAULT '0',
  450.   `getgunammo_11` INT(11) NOT NULL DEFAULT '0',
  451.   `getgunweap_12` INT(11) NOT NULL DEFAULT '0',
  452.   `getgunammo_12` INT(11) NOT NULL DEFAULT '0',
  453.   PRIMARY KEY (`id`)
  454. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
  455.  
  456. --
  457. -- Dumping data for table `dc_players_getgun`
  458. --
  459.  
  460.  
  461. -- --------------------------------------------------------
  462.  
  463. --
  464. -- Table structure for table `dc_player_wepstats`
  465. --
  466.  
  467. CREATE TABLE IF NOT EXISTS `dc_player_wepstats` (
  468.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  469.   `knifekills` INT(11) NOT NULL DEFAULT '0',
  470.   `grenadekills` INT(11) NOT NULL DEFAULT '0',
  471.   `coltkills` INT(11) NOT NULL DEFAULT '0',
  472.   `scoltkills` INT(11) NOT NULL DEFAULT '0',
  473.   `desertkills` INT(11) NOT NULL DEFAULT '0',
  474.   `shotgunkills` INT(11) NOT NULL DEFAULT '0',
  475.   `sawnoffkills` INT(11) NOT NULL DEFAULT '0',
  476.   `cshotgunkills` INT(11) NOT NULL DEFAULT '0',
  477.   `uzikills` INT(11) NOT NULL DEFAULT '0',
  478.   `mp5kills` INT(11) NOT NULL DEFAULT '0',
  479.   `ak47kills` INT(11) NOT NULL DEFAULT '0',
  480.   `m4kills` INT(11) NOT NULL DEFAULT '0',
  481.   `tec9kills` INT(11) NOT NULL DEFAULT '0',
  482.   `sniperkills` INT(11) NOT NULL DEFAULT '0',
  483.   `knifedeaths` INT(11) NOT NULL DEFAULT '0',
  484.   `grenadedeaths` INT(11) NOT NULL DEFAULT '0',
  485.   `coltdeaths` INT(11) NOT NULL DEFAULT '0',
  486.   `scoltdeaths` INT(11) NOT NULL DEFAULT '0',
  487.   `desertdeaths` INT(11) NOT NULL DEFAULT '0',
  488.   `shotgundeaths` INT(11) NOT NULL DEFAULT '0',
  489.   `sawnoffdeaths` INT(11) NOT NULL DEFAULT '0',
  490.   `cshotgundeaths` INT(11) NOT NULL DEFAULT '0',
  491.   `uzideaths` INT(11) NOT NULL DEFAULT '0',
  492.   `mp5deaths` INT(11) NOT NULL DEFAULT '0',
  493.   `ak47deaths` INT(11) NOT NULL DEFAULT '0',
  494.   `m4deaths` INT(11) NOT NULL DEFAULT '0',
  495.   `tec9deaths` INT(11) NOT NULL DEFAULT '0',
  496.   `sniperdeaths` INT(11) NOT NULL DEFAULT '0',
  497.   PRIMARY KEY (`id`)
  498. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
  499.  
  500. --
  501. -- Dumping data for table `dc_player_wepstats`
  502. --
  503.  
  504.  
  505. -- --------------------------------------------------------
  506.  
  507. --
  508. -- Table structure for table `dc_runtime`
  509. --
  510.  
  511. CREATE TABLE IF NOT EXISTS `dc_runtime` (
  512.   `var` VARCHAR(160) NOT NULL,
  513.   `data` VARCHAR(160) NOT NULL
  514. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  515.  
  516. --
  517. -- Dumping data for table `dc_runtime`
  518. --
  519.  
  520. INSERT INTO `dc_runtime` (`var`, `data`) VALUES
  521. ('servname', 'hostname    «  Deadly Combinations ~ [PTM]  »'),
  522. ('slots', '50'),
  523. ('map', 'Lobby'),
  524. ('port', '7777');
  525.  
  526. -- --------------------------------------------------------
  527.  
  528. --
  529. -- Table structure for table `dc_serverdata`
  530. --
  531.  
  532. CREATE TABLE IF NOT EXISTS `dc_serverdata` (
  533.   `var` VARCHAR(60) NOT NULL,
  534.   `data` VARCHAR(60) NOT NULL
  535. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  536.  
  537. --
  538. -- Dumping data for table `dc_serverdata`
  539. --
  540.  
  541. INSERT INTO `dc_serverdata` (`var`, `data`) VALUES
  542. ('Last_Updated', '12/6/2011 | 22:07:13'),
  543. ('TotalRounds', '0'),
  544. ('ServerDeaths', '0'),
  545. ('ServerKills', '0'),
  546. ('TotalConnections', '2'),
  547. ('TotalCrashes', '0'),
  548. ('ServerRoundDeaths', '0'),
  549. ('ServerRoundKills', '0');
  550.  
  551. -- --------------------------------------------------------
  552.  
  553. --
  554. -- Table structure for table `dc_tdm`
  555. --
  556.  
  557. CREATE TABLE IF NOT EXISTS `dc_tdm` (
  558.   `id` INT(11) NOT NULL,
  559.   `name` VARCHAR(60) NOT NULL,
  560.   `time` INT(11) NOT NULL DEFAULT '12',
  561.   `interior` INT(11) NOT NULL DEFAULT '0',
  562.   `min` VARCHAR(80) NOT NULL DEFAULT '-9999.0,-9999.0',
  563.   `max` VARCHAR(80) NOT NULL DEFAULT '-9999.0,-9999.0',
  564.   `ata` VARCHAR(80) NOT NULL DEFAULT '0',
  565.   `def` VARCHAR(80) NOT NULL DEFAULT '0',
  566.   `home` VARCHAR(120) NOT NULL DEFAULT '0',
  567.   PRIMARY KEY (`id`)
  568. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  569.  
  570. --
  571. -- Dumping data for table `dc_tdm`
  572. --
  573.  
  574. INSERT INTO `dc_tdm` (`id`, `name`, `time`, `interior`, `min`, `max`, `ata`, `def`, `home`) VALUES
  575. (12, 'Blueberry', 0, 0, '87.819038,-336.780273', '344.699432,34.270050', '249.024780,26.205789,2.163225', '189.835586,-314.941650,1.572371', '224.684295,-130.930755,1.242852'),
  576. (11, 'Countryside Farm', 4, 0, '-1220.302612,-1064.009399', '-1002.833251,-909.376586', '-1199.015502,-985.661621,128.771163', '-1012.817810,-986.233215,128.759689', '-1085.112182,-982.546264,128.761734'),
  577. (10, 'Warehouse 2 (Int)', 1, 18, '', '', '1252.494262,-64.816482,1002.498901', '1304.929077,4.478727,1001.027465', '1282.675170,-24.921140,1001.015625'),
  578. (9, 'Warehouse (Int)', 1, 1, '', '', '1362.398193,-21.711326,1000.921875', '1413.143066,-20.130586,1000.924621', '1388.869750,-20.381008,1000.912780'),
  579. (8, 'Angel Pine', 1, 0, '-2297.377929,-2532.144287', '-2003.108276,-2238.375732', '-2196.904541,-2319.972656,30.625000', '-2115.950927,-2494.419433,30.625000', '-2170.111816,-2412.433837,34.296875'),
  580. (7, 'Montgomery', 1, 0, '1166.820434,137.793060', '1447.436645,482.026153', '1364.317382,473.646301,20.210937', '1285.585693,174.033798,20.410064', '1271.832519,294.906738,20.656307'),
  581. (6, 'Las Barrancadas', 1, 0, '-904.872497,1408.437011', '-642.451354,1661.622558', '-740.595458,1619.204711,27.117187', '-823.593444,1435.389648,13.789062', '-797.072937,1555.165283,27.144304'),
  582. (5, 'Ocean Flats Suburbs', 1, 0, '-2816.438964,-219.745162', '-2599.571777,-61.838706', '-2805.451171,-205.403259,7.031250', '-2618.076660,-75.666244,4.335937', '-2705.586425,-143.941177,4.179687'),
  583. (4, 'RC Arena', 0, 10, '-1137.559814,1018.701904', '-967.937316,1100.385864', '-1131.078002,1058.030761,1346.414062', '-972.503356,1061.434814,1345.666381', '-1039.674560,1061.539550,1358.914062'),
  584. (3, 'SF Airport', 1, 0, '-1547.629516,-186.970565', '-1301.795410,75.990135', '-1343.823730,33.533245,5.571537', '-1466.304809,-143.777328,5.564713', '-1412.838500,-83.053741,5.530676'),
  585. (2, 'Bayside', 1, 0, '-2670.436767,2218.489257', '-2172.165527,2472.297851', '-2615.521484,2260.510498,8.197558', '-2236.458984,2293.962402,6.347167', '-2430.859863,2336.115234,5.835937'),
  586. (1, 'Fort Carson', 1, 0, '-322.528350,938.086853', '69.800102,1231.955566', '-266.705200,1014.896362,19.593750', '31.867324,1196.485107,18.901647', '-109.998741,1098.806030,19.593750'),
  587. (13, 'Dillimore', 0, 0, '587.810363,-653.566406', '862.597717,-428.209350', '664.868591,-445.749328,16.335937', '792.531433,-607.935913,16.009807', '721.700256,-529.915771,16.186794'),
  588. (0, 'Glen Park', 20, 0, '1837.012573,-1271.443481', '2081.199462,-1125.264770', '1854.545654,-1258.038940,13.390625', '2063.665771,-1133.927734,23.303592', '1970.227172,-1197.787841,25.226654');
  589.  
  590. -- --------------------------------------------------------
  591.  
  592. --
  593. -- Table structure for table `dc_teleports`
  594. --
  595.  
  596. CREATE TABLE IF NOT EXISTS `dc_teleports` (
  597.   `id` INT(11) NOT NULL,
  598.   `name` VARCHAR(60) NOT NULL,
  599.   `coords` VARCHAR(60) NOT NULL,
  600.   PRIMARY KEY (`id`)
  601. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  602.  
  603. --
  604. -- Dumping data for table `dc_teleports`
  605. --
  606.  
  607. INSERT INTO `dc_teleports` (`id`, `name`, `coords`) VALUES
  608. (1, 'Lobby', '0.0,0.0,0.0,0.0'),
  609. (2, 'Abandoned Airstrip', '368.126495,2499.885009,16.484375,0.000000'),
  610. (3, 'Grove Street', '2500.492431,-1667.009277,13.353512,0.000000'),
  611. (4, 'SF Airport', '-1522.434692,-29.567268,14.148437,0.000000'),
  612. (5, 'Area 51', '214.395492,1903.411376,17.640625,0.000000'),
  613. (6, 'Four Dragons', '2027.122070,1007.783325,10.820312,0.000000'),
  614. (7, 'Mount Chilliad', '-2321.568847,-1616.064086,483.731170,0.000000'),
  615. (8, 'Jizzys', '-2633.278564,1384.137084,7.191876,0.000000'),
  616. (9, 'LS Skyscraper', '1543.824340,-1352.711059,329.475158,0.000000'),
  617. (10, 'Bayside', '-2264.257812,2308.000732,4.820213,0.000000');
  618.  
  619. -- --------------------------------------------------------
  620.  
  621. --
  622. -- Table structure for table `dc_weapons_classes`
  623. --
  624.  
  625. CREATE TABLE IF NOT EXISTS `dc_weapons_classes` (
  626.   `weap_id` INT(11) NOT NULL,
  627.   `weap_ammo` INT(11) NOT NULL,
  628.   `class` INT(11) NOT NULL
  629. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  630.  
  631. --
  632. -- Dumping data for table `dc_weapons_classes`
  633. --
  634.  
  635. INSERT INTO `dc_weapons_classes` (`weap_id`, `weap_ammo`, `class`) VALUES
  636. (1, 0, 0),
  637. (2, 0, 0),
  638. (3, 0, 0),
  639. (4, 0, 5),
  640. (5, 0, 0),
  641. (6, 0, 0),
  642. (7, 0, 0),
  643. (8, 0, 0),
  644. (9, 0, 0),
  645. (10, 0, 0),
  646. (11, 0, 0),
  647. (12, 0, 0),
  648. (13, 0, 0),
  649. (14, 0, 0),
  650. (15, 0, 0),
  651. (16, 0, 0),
  652. (17, 0, 0),
  653. (18, 6, 0),
  654. (22, 0, 0),
  655. (23, 0, 0),
  656. (24, 500, 2),
  657. (25, 0, 0),
  658. (26, 0, 0),
  659. (27, 999, 1),
  660. (28, 0, 0),
  661. (29, 0, 0),
  662. (30, 0, 0),
  663. (31, 400, 1),
  664. (32, 0, 0),
  665. (33, 0, 0),
  666. (34, 100, 3),
  667. (35, 0, 0),
  668. (36, 0, 0),
  669. (37, 0, 5),
  670. (38, 0, 0),
  671. (39, 0, 0),
  672. (40, 0, 0),
  673. (41, 0, 0),
  674. (42, 0, 0),
  675. (43, 0, 0),
  676. (44, 0, 0),
  677. (45, 0, 0),
  678. (46, 0, 0);
  679.  
  680. -- --------------------------------------------------------
  681.  
  682. --
  683. -- Table structure for table `dc_weapon_limits`
  684. --
  685.  
  686. CREATE TABLE IF NOT EXISTS `dc_weapon_limits` (
  687.   `weaponid` INT(11) NOT NULL,
  688.   `limit` INT(11) NOT NULL DEFAULT '100'
  689. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  690.  
  691. --
  692. -- Dumping data for table `dc_weapon_limits`
  693. --
  694.  
  695. INSERT INTO `dc_weapon_limits` (`weaponid`, `limit`) VALUES
  696. (1, 100),
  697. (2, 100),
  698. (3, 100),
  699. (4, 100),
  700. (5, 100),
  701. (6, 100),
  702. (7, 100),
  703. (8, 100),
  704. (9, 100),
  705. (10, 100),
  706. (11, 100),
  707. (12, 100),
  708. (13, 100),
  709. (14, 100),
  710. (15, 100),
  711. (16, 100),
  712. (17, 100),
  713. (18, 100),
  714. (19, 100),
  715. (20, 100),
  716. (21, 100),
  717. (22, 100),
  718. (23, 100),
  719. (24, 100),
  720. (25, 100),
  721. (26, 100),
  722. (27, 100),
  723. (28, 100),
  724. (29, 100),
  725. (30, 100),
  726. (31, 100),
  727. (32, 100),
  728. (33, 100),
  729. (34, 100),
  730. (35, 100),
  731. (36, 100),
  732. (37, 100),
  733. (38, 100),
  734. (39, 100),
  735. (40, 100),
  736. (41, 100),
  737. (42, 100),
  738. (43, 100),
  739. (44, 100),
  740. (45, 100),
  741. (46, 100);
  742.  
  743. -- --------------------------------------------------------
  744.  
  745. --
  746. -- Table structure for table `dc_weapon_skill`
  747. --
  748.  
  749. CREATE TABLE IF NOT EXISTS `dc_weapon_skill` (
  750.   `weaponid` INT(11) NOT NULL,
  751.   `skill` INT(11) NOT NULL DEFAULT '999'
  752. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  753.  
  754. --
  755. -- Dumping data for table `dc_weapon_skill`
  756. --
  757.  
  758. INSERT INTO `dc_weapon_skill` (`weaponid`, `skill`) VALUES
  759. (22, 999),
  760. (23, 999),
  761. (24, 999),
  762. (25, 999),
  763. (26, 999),
  764. (27, 999),
  765. (28, 999),
  766. (29, 999),
  767. (30, 999),
  768. (31, 999),
  769. (34, 999);
  770.  
  771. -- --------------------------------------------------------
  772.  
  773. --
  774. -- Table structure for table `dc_wepkill_data`
  775. --
  776.  
  777. CREATE TABLE IF NOT EXISTS `dc_wepkill_data` (
  778.   `var` VARCHAR(60) NOT NULL,
  779.   `data` VARCHAR(60) NOT NULL
  780. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  781.  
  782. --
  783. -- Dumping data for table `dc_wepkill_data`
  784. --
  785.  
  786. INSERT INTO `dc_wepkill_data` (`var`, `data`) VALUES
  787. ('knifekills', '0'),
  788. ('grenadekills', '0'),
  789. ('coltkills', '0'),
  790. ('scoltkills', '0'),
  791. ('desertkills', '0'),
  792. ('shotgunkills', '0'),
  793. ('sawnoffkills', '0'),
  794. ('cshotgunkills', '0'),
  795. ('uzikills', '0'),
  796. ('mp5kills', '0'),
  797. ('ak47kills', '0'),
  798. ('m4kills', '0'),
  799. ('tec9kills', '0'),
  800. ('sniperkills', '0');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement