API tools faq
paste
Guest User

Untitled

a guest
Dec 16th, 2018
105
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 85.50 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.6.5.2
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Jul 21, 2017 at 08:28 PM
  7. -- Server version: 10.1.21--MariaDB
  8. -- PHP Version: 5.6.30
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17.  
  18. --
  19. -- Database: `re`
  20. --
  21.  
  22. -- --------------------------------------------------------
  23.  
  24. --
  25. -- Table structure for table `admin_panel`
  26. --
  27.  
  28. CREATE TABLE `admin_panel` (
  29. `ID` int(11) NOT NULL,
  30. `Category` int(11) NOT NULL,
  31. `Status` int(11) NOT NULL,
  32. `Time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  33. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  34.  
  35. -- --------------------------------------------------------
  36.  
  37. --
  38. -- Table structure for table `apply_ques`
  39. --
  40.  
  41. CREATE TABLE `apply_ques` (
  42. `Faction` int(11) NOT NULL,
  43. `ID` int(10) NOT NULL,
  44. `Questions` text NOT NULL,
  45. `TQuestions` int(11) NOT NULL
  46. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  47.  
  48. --
  49. -- Dumping data for table `apply_ques`
  50. --
  51.  
  52. INSERT INTO `apply_ques` (`Faction`, `ID`, `Questions`, `TQuestions`) VALUES
  53. (1, 1, 'Care este varsta ta reala?|>Cum te-ai descrie in cateva randuri?|>Ai mai fost in alte departamente? Daca da, care este motivul parasirii acestora?|>De ce doresti sa te alaturi acestei factiuni?|>Ai posibilitatea de a filma dovezi clare?|>Ai mai fost in alte factiuni? Daca da, care este motivul parasirii acestora?|>Cate ore joci in medie zilnic pe server?|>Care sunt ultimele tale sanctiuni primite de la admini? (poza /mylp necesara)|>Te aflii pe blacklist-ul unei factiuni? (poza /mybl)|>Cu ce se ocupa Los Santos Police Department?|>De cat timp joci pe Burned?|>Ai avut tangente cu un membru din LSPD pana acum?|>Esti constient ca trebuie sa stai minim 14 zile in factiune pentru a nu iesi cu faction punish?|>Ce te face sa crezi ca esti potrivit pentru aceasta factiune?|>Alte precizari|>', 16),
  54. (2, 2, 'Nick:|>Nick-uri anterioare:|>Cunoasteti regulamentul intern? :|>Screenshot cu /stats (obligatoriu):|>Screenshot la profil la /mylp(obligatoriu): |>De cat timp jucati SAMP?: |>Cate ore acordati serverului/zi?: |>Ultima factiune si perioada de timp petrecuta acolo:|>De ce vrei sa intrii in acest departament(minim 20 de cuvinte):|>Esti de acord cu faptul ca trebuie respecti liderul si membrii cu rank mai mare?:|>Biografie personala(minim 20 de cuvinte):|>Esti constient ca daca nu stai minim 14 zile in departament, vei lua FP?: |>Esti capabil sa lucrezi in echipa si sa comunici decent?: |>Poti filma fiecare actiune pe care o faci pentru a avea dovezi?Sau poze?:|>Alte precizari:|>', 16),
  55. (3, 3, 'Varsta reala:|>Cate ore pe zi acorzi serverului? (fara sleep/afk):|>Ai fost vreodata banat? Daca da, din ce motiv?:|>De ce doresti sa te alaturi factiunii?|>Poza /stats:|>Poza /mybl:|>Poza /mylp|>Cu ce crezi ca te-ai remarcat pana acum pe server?|>Motivul iesirii din factiunea anterioara?|>Esti pe BlackList-ul unei factiuni? Daca da, esti dispus da platesti ca sa fi scos?|>De cat timp joci SA:MP?:|>Ai posibilitatea de a folosi programe cum ar fi Fraps/Bandicam pentru dovezi video?:|>Descrierea personala (minim 200 de cuvinte): |>Motivul intrarii aplicatiei:|>Alte precizari:|>', 16),
  56. (4, 4, 'Screenshot [/stats]:|>Screenshot [/mylp]: |>Screenshot [/mybl]: |>Nume Real:|>Varsta Reala:|>Ai invatat regulamentul intern Grove Street, cat si cel general de mafii ?:|>Esti de acord cu faptul ca trebuie sa stai in Grove Street pentru minim 14 zile, altfel vei fi dat afara cu 40/40FP?:|>Interval orar de joc(fara afk): |>Poti fii activ intre orele 13:00-15:00 pentru war-uri in zilele de luni pana vineri?: |>Ai mai facut parte din aceasta factiune? Daca da, de ce ai parasit-o?:|>Care a fost factiunea ta anterioara si de ce ai parasit-o?:|>De ce doresti sa intri in Grove Street ?(minim 15 de cuvinte): |>Descrierea ta personala (minim 15 de cuvinte):|>Cat timp petreci zilnic pe server?:|>Mai ai vreo informatie utila pentru lider?:|>', 16),
  57. (5, 5, 'Nick Name: |>Nick name secundar/anterioare:|>Data cererii:|>De ce ai parasit ultima factiune?:|>Poza cu /stats:|>Poza cu faction history de pe user panel:|>Poza /mylp:|>Varsta reala:|>Cum te poti descrie in realitate? (minim 20 cuvinte):|>De ce vrei sa intri in Los Vagos?:|>Poti intra in intervalul 19:30-22:30?:|>Te afli pe blacklist-ul unei factiuni? Daca da esti deacord sa platesti sa fii scos?:|>Cate ore petreci zilnic pe server-ul(fara /sleep):|>Ai citit regulamentul & informatiile Los Vagos? Vei fii testat din el:|>Alte precizari?:|>', 16),
  58. (6, 6, 'Nume real:|>Vârsta real?:|>Descriere (Minim 20 de cuvinte):|>Factiunile anterioare:|>Te afli pe blacklist-ul unei factiuni?:|>De ce ai ales sa aplici la aceasta factiune?|>Ce parere ai despre liderul acestei factiuni?|>Cât timp doresti sa ramâi în factiune?:|>Intervalul Online:|>Cu ce se pedepseste daca veti inactiv mai mult de 3 zile?:|>Poza cu [/stats]:|>Câte Faction Punish ai?:|>Esti sigur ca vei ramâne în factiune mai mult de 14 zile?:|>Care crezi ca sunt calitatile unui membru Ballas?:|>Spune in ce zile si intre ce ore este war:|>', 16),
  59. (7, 7, 'Nickname:|>Level:|>Hours Played:|>Poza cu [/stats]:|>Poza cu [/licenses]:|>Ce varsta ai?:|>Descrie-te in cateva cuvinte (minim 15):|>Care este intervalul de timp in care joci (aproximativ)?:|>Esti pe BlackList-ul unei factiuni?:|>Daca da, ai fi de acord sa platesti pentru a fi scos?:|>Care a fost ultima factiune? Si de ce ai iesit din ea?:|>Cu ce crezi ca se ocupa School Instructors?:|>Ai mai facut parte din School Instructors? Daca da, de ce ai iesit?:|>De ce doresti sa te alaturi factiunii?:|>Prin ce te-ai remarcat pana acum pe server?:|>', 16),
  60. (8, 8, 'Care este varsta ta reala si cum te cheama?|>Esti capabil sa lucrezi in echipa?|>Ce parere ai despre conducerea factiunii?|>Care sunt calitatile tale? Dar defectele?|>Ne poti face o descriere personala?|>Esti constient ca daca nu vei sta mai mult de 14 zile in factiune vei primi FP?|>Vei respecta restul membriilor?|>Cat timp doresti sa petreci in aceasta factiune?|>De ce doresti sa intri in aceasta factiune?|>Cu ce crezi ca poti ajuta aceasta factiune?|>Ai cunostinte in limba engleza sau franceza?|>Care este intervalul tau de joc? |>Poza cu /mybl. |>Poza cu /mylp.|> Poza cu /stats.|>', 16),
  61. (9, 9, 'Varsta Reala / Real age:|>Numar de ore pe zi petrecute in joc / Playing hours per day:|>Interval orar de joc / Playing hour interval:|>[/mylp]:|>[/stats]:|>[/mybl]:|>Factiuni anterioare / Previous faction:|>Explicatii pentru parasirea factiunilor anterioare / Explanations for leaving previous faction:|>Descrierea voastra ca persoana / Your description as a person:|>Ai cunostinte de limba Engleza? / Can you speak english?:|>De ce doresti sa te alaturi acestei factiuni? / What are your reasons for applying in this faction?:|>Care sunt planurile tale de viitor ca jucator? / What are your future plans as a player?:|>Alte informatii folositoare pentru lider / Other useful information for the leader:|>-|>-|>', 16),
  62. (10, 10, 'De ce doresti sa intrii in The Ballas?|>O scurta descriere (minim 15 cuvinte):|>Esti constient ca atunci cand un admin te someaza sa dai datele TW si tu iei crash sau dai /quit primesti ban ?|>Esti pe blacklist-ul unei factiunii, daca da, esti dispus sa platesti?|>Ai fost banat vreodata pe acest server? Daca da, de ce?|>Aveti licenta de arme suspendata? Daca da, cat?|>Poza /stats si /mylp|>Esti sigur ca poti ajunge la war-urile de la 13:00 - 15:00?|>Ne poti arata un video cum tragi? (Nu este obligatoriu)|>Ai mai fost intr-o mafie?|>Esti constient ca daca nu te vei prezenta la war vei primi Faction Warn?|>Ai invatat regulamentul? Vei fii testat din el !|>Esti constient ca trebuie sa asculti de lider/sublider?|>Poti sta in factiune cel putin 14 zile?|>Alte precizari ?|>', 16),
  63. (11, 11, 'Varsta reala :|>Numar de ore pe zi petrecute in joc :|>Interval orar de joc : |>Explicatii pentru parasirea factiunilor anterioare : |>Explicatii pentru sanctiunile primite de la admini :|>Descrierea voastra ca persoana :|>Care crezi ca sunt calitatile unui membru Hitman Agency?|>De ce doresti sa te alaturi acestei factiuni?|>Care sunt planurile tale de viitor ca jucator?|>De ce crezi ca aceasta factiune este potrivita pentru tine?|>Alte informatii folositoare pentru lider :|>Poza /mylp :|>Poza /status :|>Poza /mybl :|>Cat timp ti-ai propus sa stai in factiune ?|>', 16),
  64. (12, 12, 'Numele si varsta reala:|>Cum te-ai descrie in cateva randuri?|>Ai mai facut parte din alte factiuni? Daca da, de ce ai iesit din acestea?|>De ce doresti sa te alaturi acestei factiuni?|>Crezi ca poti respecta regulamentul factiunii cat si regulamentul factiunilor pasnice?|>Link catre profilul tau de forum:|>Cate ore petreci pe joc zilnic?|>Interval orar de joc:|>Te aflii pe blacklist-ul unei factiuni? (poza /mybl):|>Ce te face sa crezi ca esti potrivit pentru aceasta factiune?|>Care sunt calitatile unui taximetrist?|>De cat timp joci pe Burned?|>Cunosti locatiile importante de pe server?:|>Esti constient ca vei fi sanctionat daca incalci regulamentul factiunii?:|>Alte precizari?:|>', 16),
  65. (13, 13, 'Numele ?i vârsta real?: |>De ce dore?ti s? te al?turi fac?iunii?|>Cu ce crezi c? se ocup? membrii fac?iunii?|>Ai mai facut parte dintr-o fac?iune?|>Motivul ie?irii din ultima fac?iune :|>Esti constient ca vei fi testat din regulamentul factiunii?|>Esti pe Blacklist-ul unei factiuni?|>Daca da, esti de acord sa platesti pentru a fi scos?|>Cate ore acorzi jocului pe zi, fara [/sleep]?|>Ai fost banat vreodata? Precizeaza numarul banurilor si motivul acestora.|>Biografia ta in minim 50 de cuvinte:|>Esti constient ca vei fi sanctionat daca incalci regulamentul factiunii?|>De ce crezi ca aceasta factiune este potrivita pentru tine?|>Prin ce te-ai remarcat pana acum pe server?|>Poza [/mylp] [/mybl] [/stats]:|>', 16);
  66.  
  67. -- --------------------------------------------------------
  68.  
  69. --
  70. -- Table structure for table `app_factions`
  71. --
  72.  
  73. CREATE TABLE `app_factions` (
  74. `ID` int(10) NOT NULL,
  75. `UserID` int(11) NOT NULL,
  76. `Text` text NOT NULL,
  77. `Faction` int(11) NOT NULL,
  78. `Status` int(11) NOT NULL,
  79. `Time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  80. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  81.  
  82. -- --------------------------------------------------------
  83.  
  84. --
  85. -- Table structure for table `banlog`
  86. --
  87.  
  88. CREATE TABLE `banlog` (
  89. `ID` int(11) NOT NULL,
  90. `ip` varchar(25) NOT NULL,
  91. `player` varchar(25) NOT NULL,
  92. `admin` varchar(25) NOT NULL,
  93. `reason` varchar(60) NOT NULL,
  94. `day` int(11) NOT NULL DEFAULT '0',
  95. `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  96. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  97.  
  98. -- --------------------------------------------------------
  99.  
  100. --
  101. -- Table structure for table `bans`
  102. --
  103.  
  104. CREATE TABLE `bans` (
  105. `ID` int(11) NOT NULL,
  106. `PlayerName` varchar(30) NOT NULL,
  107. `AdminName` varchar(30) NOT NULL,
  108. `Reason` varchar(128) NOT NULL,
  109. `IP` varchar(16) NOT NULL,
  110. `Days` int(11) NOT NULL,
  111. `IPBan` int(11) NOT NULL,
  112. `Permanent` int(11) NOT NULL,
  113. `Time` int(15) NOT NULL,
  114. `BanTimeDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  115. `Active` int(11) NOT NULL
  116. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  117.  
  118. -- --------------------------------------------------------
  119.  
  120. --
  121. -- Table structure for table `bizz`
  122. --
  123.  
  124. CREATE TABLE `bizz` (
  125. `ID` int(11) NOT NULL,
  126. `Owned` int(11) NOT NULL,
  127. `Owner` varchar(25) NOT NULL DEFAULT 'The State',
  128. `Type` int(11) NOT NULL,
  129. `Message` varchar(50) NOT NULL,
  130. `EntranceX` float NOT NULL,
  131. `EntranceY` float NOT NULL,
  132. `EntranceZ` float NOT NULL,
  133. `ExitX` float NOT NULL,
  134. `ExitY` float NOT NULL,
  135. `ExitZ` float NOT NULL,
  136. `LevelNeeded` int(11) NOT NULL,
  137. `BuyPrice` int(11) NOT NULL,
  138. `EntranceCost` int(11) NOT NULL,
  139. `Till` int(11) NOT NULL,
  140. `Locked` int(11) NOT NULL,
  141. `Interior` int(11) NOT NULL,
  142. `Virtual` int(11) NOT NULL,
  143. `Radio` int(11) NOT NULL DEFAULT '-1',
  144. `Static` int(11) NOT NULL,
  145. `Gas` int(11) NOT NULL
  146. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  147.  
  148. --
  149. -- Dumping data for table `bizz`
  150. --
  151.  
  152. INSERT INTO `bizz` (`ID`, `Owned`, `Owner`, `Type`, `Message`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Locked`, `Interior`, `Virtual`, `Radio`, `Static`, `Gas`) VALUES
  153. (1, 1, 'TheVirus', 1, 'Banca Los Santos', 1457.08, -1010, 26.8438, 2306, -16, 27, 7, 0, 1000, 68000, 0, 0, 1, -1, 0, 0),
  154. (2, 1, 'Ciusca10', 2, 'Vrei arme bune? Intra.', 1368.87, -1279.74, 13.5469, 315.739, -143.134, 999.602, 7, 0, 1000, 1738000, 0, 7, 2, -1, 0, 0),
  155. (3, 1, 'Trebor', 3, 'Haide sa te racoresti', 1836.9, -1682.48, 13.3287, 493.46, -24.0736, 1000.68, 7, 13000000, 2000, 814890, 0, 17, 3, -1, 0, 0),
  156. (4, 1, 'ionut', 3, 'hai la o bere', 2421.41, -1220.3, 25.4937, 1204.83, -13.4011, 1000.92, 7, 0, 2000, 173860, 0, 2, 4, -1, 0, 0),
  157. (5, 1, 'FloriN04', 4, 'Rstaurant ', 1498.5, -1581.31, 13.5498, -794.942, 490.782, 1376.2, 7, 0, 1000, 19500, 0, 1, 5, -1, 0, 0),
  158. (6, 1, '[]KingAdY[]', 5, 'Intra pentru a cumpara ce ai nevoie. =))', 1087.66, -923.207, 43.3906, -100.403, -24.3921, 1000.72, 7, 10000000, 2000, 32600, 0, 3, 6, -1, 0, 0),
  159. (7, 1, 'VladTheKing', 6, 'Intra tasteaza /buy si cumpara ce ai de cumparat', 1352.42, -1758.4, 13.5078, -25.8845, -185.869, 1003.55, 7, 0, 1000, 354600, 0, 17, 7, -1, 0, 0),
  160. (8, 1, 'Kesso.', 6, 'Aici puteti vinde un peste cat mai niezz', 1832.3, -1842.5, 13.5781, -25.8845, -185.869, 1003.55, 7, 0, 2000, 834922, 0, 17, 8, -1, 0, 0),
  161. (9, 1, 'wHiTeViL', 6, 'Cumpara de aici tot ce vrei,ieftin!', 1929.83, -1776.2, 13.5469, -25.8845, -185.869, 1003.55, 7, 0, 1000, 52700, 0, 17, 9, -1, 0, 0),
  162. (10, 1, 'Vlaadut', 6, 'Biz de bastani', 1000.03, -920.278, 42.3281, -25.8845, -185.869, 1003.55, 7, 20000000, 2000, 324319, 0, 17, 10, -1, 0, 0),
  163. (11, 1, 'Flew.t', 7, 'Burned Clothes Center', 454.117, -1478.02, 30.8142, 207.774, -110.335, 1005.12, 7, 45000000, 2000, 814500, 0, 15, 11, -1, 0, 0),
  164. (12, 1, 'Sultan', 8, 'McDonald', 1199.1, -919.113, 43.1169, 364.037, -74.4941, 1001.51, 7, 25000000, 1000, 685350, 0, 10, 12, -1, 0, 0),
  165. (13, 1, 'Saffron204532', 9, 'Casa Pariurilor', 1290.78, -1160.8, 23.961, 2019.07, 1017.8, 996.936, 7, 0, 2000, 710000, 0, 10, 13, -1, 0, 0),
  166. (14, 1, 'Ryd3r.[]', 10, 'Vrei sa pui un anunt? /ad si anuntul', 648.503, -1357.35, 13.5701, 0, 0, 0, 7, 0, 2000, 0, 0, 0, 14, -1, 1, 0),
  167. (15, 1, 'Fane', 11, 'Nrg-uri pentru bãjeti adv', 1116.04, -924.068, 42.962, 0, 0, 0, 7, 0, 2000, 2082000, 0, 0, 15, -1, 1, 0),
  168. (16, 1, 'Kronoss', 12, 'Rent de Bajtan', 562.939, -1289.9, 17.2482, 0, 0, 0, 7, 0, 1000, 5739000, 0, 0, 16, -1, 1, 0),
  169. (17, 1, 'KIING', 13, '/enter pentru a intra !! DAU MAGIE !!', 2780.59, -1812.23, 11.8438, 0, 0, 0, 7, 0, 2000, 86000, 0, 0, 17, -1, 1, 0),
  170. (18, 1, 'Mr_Valy', 14, 'House upgrade.', 2352.01, -1412.23, 23.9924, 0, 0, 0, 7, 0, 1000, 899000, 0, 0, 18, -1, 1, 0),
  171. (19, 1, 'KhS1', 15, '. KhS1 .', 1702.71, -1470.21, 13.5469, 0, 0, 0, 7, 0, 2000, 333000, 0, 0, 19, -1, 1, 0),
  172. (20, 1, 'Steve11', 16, 'Bn ati venit la Paint', 1310.2, -1368.51, 13.5502, 0, 0, 0, 7, 0, 2000, 42000, 0, 0, 20, -1, 1, 0),
  173. (21, 1, 'HapPy', 17, 'Bine ati venit la Biz-ul 21 !', 1941.6, -1764.74, 13.6406, 0, 0, 0, 7, 0, 1000, 324800, 0, 0, 21, -1, 1, 1),
  174. (22, 1, 'Browstat.', 18, '/enter to enter', 2695.54, -1704.71, 11.8438, 0, 0, 0, 7, 0, 2000, 14000, 0, 0, 22, -1, 1, 0),
  175. (23, 1, 'Crixus99', 19, 'Reparatii a la Crixus99', 2073.44, -1834.56, 13.5469, 0, 0, 0, 7, 0, 2000, 0, 0, 0, 23, -1, 1, 0),
  176. (24, 1, 'TheLegendd', 19, 'De Vanzare!Astept Oferte.', 1021.93, -1030.89, 32.019, 0, 0, 0, 7, 0, 2000, 0, 0, 0, 24, -1, 1, 0),
  177. (25, 1, 'TheAndreiGamer', 19, 'PAY N SPRAY', 492.306, -1733.72, 11.2938, 0, 0, 0, 7, 0, 1000, 0, 0, 0, 25, -1, 1, 0),
  178. (26, 1, 'DeEuS', 17, 'Avem si pita cu pateu', 1011.62, -935.724, 42.3281, 0, 0, 0, 7, 0, 1000, 1842000, 0, 0, 26, -1, 1, 1),
  179. (27, 1, 'n00b.exe', 20, 'FishMarket', 812.422, -2113.21, 1.99306, -228.814, 1401.12, 27.7656, 7, 0, 2000, 0, 0, 18, 27, -1, 0, 0),
  180. (28, 1, 'LIMEX', 21, 'vand 3kk', 2104.82, -1806.39, 13.5547, -228.814, 1401.12, 27.7656, 7, 0, 1000, 273080, 0, 18, 28, -1, 0, 0),
  181. (29, 1, 'Vladimir', 22, 'KGB Industries', 1035, -1028.26, 32.1016, 0, 0, 0, 7, 0, 2000, 0, 0, 0, 29, -1, 1, 0);
  182.  
  183. -- --------------------------------------------------------
  184.  
  185. --
  186. -- Table structure for table `blacklist`
  187. --
  188.  
  189. CREATE TABLE `blacklist` (
  190. `ID` int(10) NOT NULL,
  191. `Userid` int(10) NOT NULL,
  192. `Name` varchar(256) NOT NULL,
  193. `Faction` int(10) NOT NULL,
  194. `Reason` int(10) NOT NULL,
  195. `Added` varchar(256) NOT NULL
  196. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  197.  
  198. -- --------------------------------------------------------
  199.  
  200. --
  201. -- Table structure for table `cars`
  202. --
  203.  
  204. CREATE TABLE `cars` (
  205. `ID` int(11) NOT NULL,
  206. `Model` int(11) NOT NULL,
  207. `Locationx` float NOT NULL,
  208. `Locationy` float NOT NULL,
  209. `Locationz` float NOT NULL,
  210. `Angle` float NOT NULL,
  211. `ColorOne` int(11) NOT NULL,
  212. `ColorTwo` int(11) NOT NULL,
  213. `Owner` varchar(25) NOT NULL DEFAULT 'Dealership',
  214. `Value` int(11) NOT NULL,
  215. `License` varchar(15) NOT NULL DEFAULT 'LS-01-RGM',
  216. `Alarm` int(11) NOT NULL,
  217. `Lockk` int(11) NOT NULL,
  218. `mod0` int(11) NOT NULL DEFAULT '0',
  219. `mod1` int(11) NOT NULL DEFAULT '0',
  220. `mod2` int(11) NOT NULL DEFAULT '0',
  221. `mod3` int(11) NOT NULL DEFAULT '0',
  222. `mod4` int(11) NOT NULL DEFAULT '0',
  223. `mod5` int(11) NOT NULL DEFAULT '0',
  224. `mod6` int(11) NOT NULL DEFAULT '0',
  225. `mod7` int(11) NOT NULL DEFAULT '0',
  226. `mod8` int(11) NOT NULL DEFAULT '0',
  227. `mod9` int(11) NOT NULL DEFAULT '0',
  228. `mod10` int(11) NOT NULL DEFAULT '0',
  229. `mod11` int(11) NOT NULL DEFAULT '0',
  230. `mod12` int(11) NOT NULL DEFAULT '0',
  231. `mod13` int(11) NOT NULL DEFAULT '0',
  232. `paintjob` int(11) NOT NULL DEFAULT '3',
  233. `KM` float NOT NULL,
  234. `Userid` int(11) NOT NULL DEFAULT '0',
  235. `Confiscated` int(2) NOT NULL,
  236. `Spawned` int(2) NOT NULL,
  237. `Special` int(2) NOT NULL DEFAULT '0',
  238. `Points` int(10) NOT NULL DEFAULT '5',
  239. `Tax` int(10) NOT NULL DEFAULT '50',
  240. `Fuel` int(10) NOT NULL DEFAULT '100',
  241. `Neon` int(10) NOT NULL,
  242. `Text` varchar(256) NOT NULL DEFAULT '-',
  243. `ColorText` int(11) NOT NULL
  244. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  245.  
  246. -- --------------------------------------------------------
  247.  
  248. --
  249. -- Table structure for table `clans`
  250. --
  251.  
  252. CREATE TABLE `clans` (
  253. `ID` int(10) NOT NULL,
  254. `Owner` varchar(64) NOT NULL,
  255. `OwnerSQL` int(11) NOT NULL,
  256. `Name` varchar(64) NOT NULL,
  257. `Motd` varchar(256) NOT NULL DEFAULT 'Nu este setat.',
  258. `Tag` varchar(32) NOT NULL,
  259. `RankName1` varchar(64) NOT NULL DEFAULT 'Rank 1',
  260. `RankName2` varchar(64) NOT NULL DEFAULT 'Rank 2',
  261. `RankName3` varchar(64) NOT NULL DEFAULT 'Rank 3',
  262. `RankName4` varchar(64) NOT NULL DEFAULT 'Rank 4',
  263. `RankName5` varchar(64) NOT NULL DEFAULT 'Rank 5',
  264. `RankName6` varchar(64) NOT NULL DEFAULT 'Rank 6',
  265. `Color` varchar(10) NOT NULL DEFAULT 'FFFFFF',
  266. `Slots` int(10) NOT NULL,
  267. `RegisterDate` varchar(64) NOT NULL,
  268. `Days` int(10) NOT NULL DEFAULT '60'
  269. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  270.  
  271. -- --------------------------------------------------------
  272.  
  273. --
  274. -- Table structure for table `commands`
  275. --
  276.  
  277. CREATE TABLE `commands` (
  278. `ID` int(11) NOT NULL,
  279. `Name` varchar(100) NOT NULL,
  280. `Reason` varchar(100) NOT NULL,
  281. `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  282. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  283.  
  284. -- --------------------------------------------------------
  285.  
  286. --
  287. -- Table structure for table `commentaries`
  288. --
  289.  
  290. CREATE TABLE `commentaries` (
  291. `Nickname` int(11) NOT NULL,
  292. `ID` int(10) NOT NULL,
  293. `Comment` text NOT NULL,
  294. `Time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  295. `Category` int(11) NOT NULL,
  296. `Cat_id` int(11) NOT NULL
  297. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  298.  
  299. -- --------------------------------------------------------
  300.  
  301. --
  302. -- Table structure for table `comm_req`
  303. --
  304.  
  305. CREATE TABLE `comm_req` (
  306. `Comm_Type` int(11) NOT NULL,
  307. `Comm_UserID` int(11) NOT NULL,
  308. `Comm_Comm` text NOT NULL,
  309. `Comm_Topic` int(11) NOT NULL,
  310. `Comm_Time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  311. `Model` int(11) NOT NULL,
  312. `ID` int(10) NOT NULL
  313. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  314.  
  315. -- --------------------------------------------------------
  316.  
  317. --
  318. -- Table structure for table `dsveh`
  319. --
  320.  
  321. CREATE TABLE `dsveh` (
  322. `ID` int(10) NOT NULL,
  323. `Model` int(11) NOT NULL,
  324. `Price` int(11) NOT NULL DEFAULT '1',
  325. `MaxSpeed` int(4) NOT NULL DEFAULT '1',
  326. `Type` int(10) NOT NULL,
  327. `Premium` int(10) NOT NULL,
  328. `Gold` int(10) NOT NULL DEFAULT '500',
  329. `Stock` int(11) NOT NULL DEFAULT '30'
  330. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  331.  
  332. --
  333. -- Dumping data for table `dsveh`
  334. --
  335.  
  336. INSERT INTO `dsveh` (`ID`, `Model`, `Price`, `MaxSpeed`, `Type`, `Premium`, `Gold`, `Stock`) VALUES
  337. (1, 404, 170000, 133, 1, 0, 20, 22),
  338. (2, 418, 190000, 115, 1, 0, 25, 26),
  339. (3, 422, 230000, 140, 1, 0, 30, 25),
  340. (4, 466, 350000, 140, 1, 0, 35, 28),
  341. (5, 549, 310000, 153, 1, 0, 35, 26),
  342. (6, 401, 290000, 147, 1, 0, 30, 27),
  343. (7, 400, 520000, 158, 1, 0, 40, 27),
  344. (8, 543, 325000, 151, 1, 0, 35, 30),
  345. (9, 482, 490000, 156, 1, 0, 50, 30),
  346. (10, 483, 520000, 129, 1, 0, 55, 30),
  347. (11, 508, 570000, 108, 1, 0, 55, 30),
  348. (12, 550, 410000, 130, 1, 0, 55, 21),
  349. (13, 585, 325000, 150, 1, 0, 55, 27),
  350. (14, 496, 500000, 162, 1, 0, 60, 16),
  351. (15, 542, 520000, 164, 1, 0, 65, 27),
  352. (16, 419, 410000, 149, 1, 0, 65, 30),
  353. (17, 554, 530000, 144, 1, 0, 70, 28),
  354. (18, 518, 390000, 164, 1, 0, 70, 26),
  355. (19, 458, 460000, 157, 1, 0, 70, 27),
  356. (20, 546, 310000, 149, 1, 0, 70, 30),
  357. (21, 424, 620000, 135, 1, 0, 80, 28),
  358. (22, 529, 380000, 149, 1, 0, 80, 29),
  359. (23, 540, 400000, 149, 1, 0, 80, 27),
  360. (24, 479, 420000, 140, 1, 0, 30, 29),
  361. (25, 600, 510000, 151, 1, 0, 50, 30),
  362. (26, 439, 670000, 168, 1, 0, 90, 25),
  363. (27, 426, 800000, 173, 1, 0, 100, 17),
  364. (28, 603, 910000, 171, 1, 0, 120, 0),
  365. (29, 589, 1100000, 162, 1, 0, 120, 22),
  366. (30, 421, 670000, 153, 1, 0, 110, 30),
  367. (31, 492, 735000, 140, 1, 0, 100, 30),
  368. (32, 517, 410000, 157, 1, 0, 90, 28),
  369. (33, 566, 350000, 160, 1, 0, 90, 29),
  370. (34, 580, 560000, 153, 1, 0, 90, 30),
  371. (35, 526, 320000, 158, 1, 0, 90, 24),
  372. (36, 500, 760000, 140, 1, 0, 90, 30),
  373. (37, 545, 920000, 147, 1, 0, 100, 30),
  374. (38, 445, 480000, 164, 1, 0, 60, 27),
  375. (39, 507, 600000, 166, 1, 0, 60, 28),
  376. (40, 555, 780000, 158, 1, 0, 90, 26),
  377. (41, 412, 520000, 168, 1, 0, 50, 29),
  378. (42, 575, 670000, 158, 1, 0, 100, 30),
  379. (43, 533, 6200000, 167, 1, 0, 100, 30),
  380. (44, 561, 9000000, 154, 1, 0, 100, 30),
  381. (45, 558, 11200000, 156, 1, 0, 150, 30),
  382. (46, 535, 9700000, 158, 1, 0, 130, 29),
  383. (47, 579, 27000000, 158, 1, 0, 200, 30),
  384. (48, 534, 5200000, 168, 1, 0, 150, 30),
  385. (49, 587, 2100000, 165, 1, 0, 150, 24),
  386. (50, 489, 5600000, 139, 1, 0, 150, 29),
  387. (51, 567, 6000000, 173, 1, 0, 150, 29),
  388. (52, 536, 12000000, 173, 1, 0, 160, 30),
  389. (53, 495, 36000000, 176, 1, 0, 250, 29),
  390. (54, 475, 32000000, 173, 1, 0, 200, 30),
  391. (55, 565, 37000000, 165, 1, 0, 200, 30),
  392. (56, 602, 9700000, 169, 1, 0, 150, 30),
  393. (57, 405, 1200000, 164, 1, 0, 100, 29),
  394. (58, 559, 40000000, 177, 1, 0, 250, 30),
  395. (59, 434, 50000000, 177, 1, 0, 350, 30),
  396. (60, 506, 55000000, 179, 1, 0, 350, 30),
  397. (61, 477, 49000000, 186, 1, 0, 350, 30),
  398. (62, 480, 38000000, 184, 1, 0, 250, 30),
  399. (63, 562, 65000000, 178, 1, 0, 400, 30),
  400. (64, 402, 70000000, 186, 1, 0, 400, 30),
  401. (65, 560, 82000000, 169, 1, 0, 450, 30),
  402. (66, 415, 61000000, 192, 1, 0, 450, 30),
  403. (67, 451, 85000000, 193, 1, 0, 450, 30),
  404. (68, 429, 52000000, 202, 1, 0, 450, 30),
  405. (69, 541, 90000000, 203, 1, 0, 500, 30),
  406. (70, 411, 100000000, 222, 1, 1, 550, 30),
  407. (71, 494, 150000000, 214, 1, 1, 600, 30),
  408. (72, 503, 150000000, 214, 1, 1, 600, 30),
  409. (73, 502, 150000000, 214, 1, 1, 600, 30),
  410. (74, 509, 80000, 83, 2, 0, 10, 29),
  411. (75, 510, 90000, 90, 2, 0, 15, 26),
  412. (76, 481, 100000, 90, 2, 0, 20, 28),
  413. (77, 462, 210000, 122, 2, 0, 20, 30),
  414. (78, 471, 270000, 110, 2, 0, 20, 26),
  415. (79, 586, 2000000, 157, 2, 0, 25, 30),
  416. (80, 581, 4000000, 59, 2, 0, 50, 30),
  417. (81, 461, 4200000, 171, 2, 0, 70, 26),
  418. (82, 468, 7200000, 157, 2, 0, 90, 30),
  419. (83, 463, 6400000, 157, 2, 0, 100, 30),
  420. (84, 521, 7600000, 176, 2, 0, 100, 30),
  421. (85, 522, 45000000, 191, 2, 0, 200, 30),
  422. (86, 473, 700000, 96, 3, 0, 20, 29),
  423. (87, 484, 20000000, 58, 3, 0, 50, 30),
  424. (88, 452, 30000000, 147, 3, 0, 100, 30),
  425. (89, 454, 45000000, 104, 3, 0, 150, 30),
  426. (90, 595, 50000000, 113, 3, 0, 150, 30),
  427. (91, 493, 70000000, 174, 3, 0, 150, 30),
  428. (92, 446, 60000000, 176, 3, 0, 200, 30),
  429. (93, 469, 100000000, 135, 4, 0, 700, 30),
  430. (94, 487, 200000000, 180, 4, 0, 700, 30),
  431. (95, 519, 300000000, 270, 4, 0, 700, 30);
  432.  
  433. -- --------------------------------------------------------
  434.  
  435. --
  436. -- Table structure for table `emails`
  437. --
  438.  
  439. CREATE TABLE `emails` (
  440. `ID` int(10) NOT NULL,
  441. `Type` int(10) NOT NULL,
  442. `Name` varchar(64) NOT NULL,
  443. `Text` varchar(256) NOT NULL,
  444. `By` varchar(64) NOT NULL DEFAULT 'AdmBot',
  445. `Date` varchar(256) NOT NULL,
  446. `Read` int(10) NOT NULL
  447. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  448.  
  449. -- --------------------------------------------------------
  450.  
  451. --
  452. -- Table structure for table `factionlog`
  453. --
  454.  
  455. CREATE TABLE `factionlog` (
  456. `ID` int(11) NOT NULL,
  457. `factionid` int(11) NOT NULL,
  458. `player` varchar(64) NOT NULL,
  459. `action` varchar(64) NOT NULL,
  460. `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  461. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  462.  
  463. -- --------------------------------------------------------
  464.  
  465. --
  466. -- Table structure for table `factions`
  467. --
  468.  
  469. CREATE TABLE `factions` (
  470. `ID` int(11) NOT NULL,
  471. `Name` varchar(50) NOT NULL,
  472. `X` float NOT NULL,
  473. `Y` float NOT NULL,
  474. `Z` float NOT NULL,
  475. `IntX` float NOT NULL,
  476. `IntY` float NOT NULL,
  477. `IntZ` float NOT NULL,
  478. `Interior` int(11) NOT NULL,
  479. `VW` int(11) NOT NULL,
  480. `Mats` int(11) NOT NULL,
  481. `Drugs` int(11) NOT NULL,
  482. `Bank` int(11) NOT NULL,
  483. `Anunt` varchar(128) NOT NULL,
  484. `PaydayMoney` int(11) NOT NULL,
  485. `Name1` varchar(64) NOT NULL DEFAULT 'Rank1',
  486. `Name2` varchar(64) NOT NULL DEFAULT 'Rank2',
  487. `Name3` varchar(64) NOT NULL DEFAULT 'Rank3',
  488. `Name4` varchar(64) NOT NULL DEFAULT 'Rank4',
  489. `Name5` varchar(64) NOT NULL DEFAULT 'Rank5',
  490. `Name6` varchar(64) NOT NULL DEFAULT 'Rank6',
  491. `Name7` varchar(64) NOT NULL DEFAULT 'Rank7',
  492. `App` int(10) NOT NULL,
  493. `Rank` int(10) NOT NULL,
  494. `Rank1` int(10) NOT NULL,
  495. `Rank2` int(10) NOT NULL,
  496. `Rank3` int(10) NOT NULL,
  497. `Rank4` int(10) NOT NULL,
  498. `Rank5` int(10) NOT NULL,
  499. `Rank6` int(10) NOT NULL,
  500. `Rank7` int(10) NOT NULL,
  501. `level` int(10) NOT NULL,
  502. `Lock` int(11) NOT NULL
  503. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  504.  
  505. --
  506. -- Dumping data for table `factions`
  507. --
  508.  
  509. INSERT INTO `factions` (`ID`, `Name`, `X`, `Y`, `Z`, `IntX`, `IntY`, `IntZ`, `Interior`, `VW`, `Mats`, `Drugs`, `Bank`, `Anunt`, `PaydayMoney`, `Name1`, `Name2`, `Name3`, `Name4`, `Name5`, `Name6`, `Name7`, `App`, `Rank`, `Rank1`, `Rank2`, `Rank3`, `Rank4`, `Rank5`, `Rank6`, `Rank7`, `level`, `Lock`) VALUES
  510. (1, 'Los Santos Police Departament', 1553.79, -1675.67, 16.1953, 246.78, 63.3446, 1003.64, 6, 0, 50000, 500, 5000, 'Ocupati-va de wanted, dati dovada de cea mai activa FACTIUNE de pe server.', 3000, '[1] Officer -', '[2] Detective -', '[3] Sergeant -', '[4] Lieutenant -', '[5] Captain -', '[6] Assistant Chief -', '[7] Chief -', 0, 0, 25, 20, 15, 10, 5, 1, 0, 7, 0),
  511. (2, 'Federal Bureau of Investigations', 627.636, -571.6, 17.6144, 238.567, 139.299, 1003.02, 3, 0, 50000, 500, 5000, 'None', 3000, '[1] Professional Staff -', '[2] Special Agent -', '[3] Supervisory Special Agent -', '[4] Special Agent in Charge -', '[5] Section Chief -', '[6] Assistant Director -', '[7] Director -', 1, 0, 35, 30, 25, 20, 15, 0, 0, 7, 0),
  512. (3, 'National Guard', 201.958, 1869.48, 13.1406, 288.763, 167.704, 1007.17, 3, 1, 50000, 500, 5000, 'None', 3000, '[1] Private -', '[2] Second Lieutenant -', '[3] First Lieutenant -', '[4] Captain -', '[5] Major -', '[6] Colonel -', '[7] General -', 1, 0, 20, 25, 30, 25, 10, 5, 0, 7, 0),
  513. (4, 'Grove Street Families', 2495.26, -1690.12, 14.7656, 2544.83, -1304.8, 1054.64, 2, 5, 50000, 500, 5000, 'Raportu zilnic va fi dezactivat o perioada. Aveti timp pana la 22:00 sa postati war-urile ca sa nu primiti FW.', 3000, '(1) Associate -', '(2) Street Soldier -', '(3) Enforcer -', '(4) Outsider -', '(5) Captain -', '(6) Underboss -', '(7) Godfather -', 1, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0),
  514. (5, 'Varrios Los Aztecas', 691.029, -1275.96, 13.5603, 2544.83, -1304.8, 1054.64, 2, 6, 50000, 500, 5000, 'None', 3000, '(1) Associate -', '(2) Street Soldier -', '(3) Enforcer -', '(4) Outsider -', '(5) Captain -', '(6) Underboss -', '(7) Godfather -', 1, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0),
  515. (6, 'Los Santos Vagos', 1123.72, -2036.94, 69.8863, 2544.83, -1304.8, 1054.64, 2, 7, 50000, 500, 5000, 'None', 3000, '(1) Soldato -', '(2) Batterie -', '(3) Picciotti -', '(4) Consigliere -', '(5) Uomini D onore -', '(6) El Jefe -', '(7) Don -', 1, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0),
  516. (7, 'School Instructors', 476.615, -1498.96, 20.4836, 1494.49, 1304.18, 1093.29, 3, 0, 50000, 500, 5000, 'Sedinta saptamanala o sa aiba loc sambata, ora 15:00. Invoirile se fac pe forum.', 0, '[1] Trainee -', '[2] Instructor -', '[3] Senior Instructor -', '[4] Supervisor -', '[5] Manager -', '[6] Under Boss -', '[7] Boss -', 1, 0, 10, 8, 7, 5, 3, 0, 0, 5, 0),
  517. (8, 'Tow Truck Company', 2448.53, -2120.41, 13.5469, 626.835, -12.0344, 1000.92, 1, 10, 50000, 500, 5000, 'None', 3000, '[1] Trainee -', '[2] Mechanic -', '[3] Senior Mechanic -', '[4] Supervisor -', '[5] Manager -', '[6] Under Boss -', '[7] Tow Company Owner -', 1, 0, 30, 25, 20, 15, 10, 0, 0, 5, 0),
  518. (9, 'News Reporters', -329.524, 1536.68, 76.6322, -2026.96, -104.033, 1035.17, 3, 0, 50000, 500, 5000, 'None', 3000, '[1] Intern -', '[2] Reporter -', '[3] Local Editor -', '[4] Network Anchor -', '[5] Network Editor -', '[6] Network Producer -', '[7] Network Director -', 1, 0, 30, 20, 5, 3, 1, 0, 0, 5, 0),
  519. (10, 'The Ballas', 2000.16, -1114.18, 27.125, 2544.83, -1304.8, 1054.64, 2, 8, 50000, 500, 5000, 'Indiferent de rezultat, vom tine capul sus!', 3000, '(1) Street Fish -', '(2) Pimp -', '(3) Capodecina -', '(4) Caporegime -', '(5) Fattam -', '(6) Sotto Capo -', '(7) Capofamiglia -', 1, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0),
  520. (11, 'Hitman Agency', 1051.77, -346.076, 73.9922, -2158.61, 642.401, 1052.38, 1, 0, 50000, 500, 5000, 'None', 3000, '[1] Freelancer -', '[2] Marksman -', '[3] Agent -', '[4] Special Agent -', '[5] Special Agent in Charge -', '[6] Vice-Director -', '[7] Agency Director -', 1, 0, 25, 20, 15, 10, 5, 0, 0, 5, 0),
  521. (12, 'Los Santos Taxi', 1754.7, -1893.82, 13.5569, 1701.24, -1668.03, 20.2188, 18, 2, 50000, 500, 5000, 'Aveti timp sa terminati raportul pana Duminica, 09.07.2017, ora 20:00.', 3000, '[1] Trainee -', '[2] Taxi Rookie -', '[3] Cabbie -', '[4] Dispatcher -', '[5] Shift Supervisor -', '[6] Taxi Company Manager -', '[7] Taxi Company Owner -', 1, 0, 30, 25, 20, 15, 10, 0, 0, 5, 0),
  522. (13, 'Paramedic & Fireman', 2034.23, -1402.56, 17.2954, 1494.46, 1304.12, 1093.29, 3, 7, 50000, 500, 5000, 'Astazi, 06.07.2017 este sedinta, sa ma cauti cand intrii pe server!', 3000, '[1] Candidate Paramedic -', '[2] Paramedic -', '[3] Paramedic in Charge -', '[4] Paramedic Ambulance Commander -', '[5] Paramedic Field Chief -', '[6] Assistant Chief Paramedic -', '[7] Chief Paramedic -', 0, 0, 25, 20, 15, 10, 5, 0, 0, 5, 0);
  523.  
  524. -- --------------------------------------------------------
  525.  
  526. --
  527. -- Table structure for table `faction_logs`
  528. --
  529.  
  530. CREATE TABLE `faction_logs` (
  531. `id` int(11) NOT NULL,
  532. `player` int(11) NOT NULL,
  533. `leader` int(11) NOT NULL,
  534. `Text` text NOT NULL,
  535. `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  536. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  537.  
  538. -- --------------------------------------------------------
  539.  
  540. --
  541. -- Table structure for table `fobjects`
  542. --
  543.  
  544. CREATE TABLE `fobjects` (
  545. `ID` int(10) NOT NULL,
  546. `Model` int(10) NOT NULL,
  547. `X` float NOT NULL,
  548. `Y` float NOT NULL,
  549. `Z` float NOT NULL,
  550. `RotX` float NOT NULL,
  551. `RotY` float NOT NULL,
  552. `RotZ` float NOT NULL,
  553. `Virtual` int(10) NOT NULL,
  554. `House` int(10) NOT NULL,
  555. `Name` varchar(64) NOT NULL DEFAULT 'No name'
  556. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  557.  
  558. -- --------------------------------------------------------
  559.  
  560. --
  561. -- Table structure for table `friends`
  562. --
  563.  
  564. CREATE TABLE `friends` (
  565. `ID` int(11) NOT NULL,
  566. `friendID` int(11) NOT NULL,
  567. `friendName` varchar(644) NOT NULL,
  568. `AddBy` int(11) NOT NULL
  569. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  570.  
  571. -- --------------------------------------------------------
  572.  
  573. --
  574. -- Table structure for table `graffiti`
  575. --
  576.  
  577. CREATE TABLE `graffiti` (
  578. `ID` int(10) NOT NULL,
  579. `X` float NOT NULL,
  580. `Y` float NOT NULL,
  581. `Z` float NOT NULL,
  582. `Rot` float NOT NULL,
  583. `Owned` int(10) NOT NULL
  584. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  585.  
  586. --
  587. -- Dumping data for table `graffiti`
  588. --
  589.  
  590. INSERT INTO `graffiti` (`ID`, `X`, `Y`, `Z`, `Rot`, `Owned`) VALUES
  591. (1, 1379.85, -1889.85, 14.2837, 0, 5),
  592. (2, 970.277, -1562.26, 14.2871, 90, 5),
  593. (3, 647.483, -1566.17, 16.2681, 0, 5),
  594. (4, 343.777, -1618.5, 33.8187, 0.6, 5),
  595. (5, 1712.68, -1128.88, 24.3249, -89.7, 1),
  596. (6, 1945.84, -1559.69, 14.3651, -44.88, 1),
  597. (7, 1827.12, -1406.32, 14.037, 90.06, 1),
  598. (8, 2023.79, -964.482, 40.3793, 20.7, 1),
  599. (9, 2376.64, -1512.32, 24.7612, 90.12, 1),
  600. (10, 2275.57, -1672.34, 16.0994, 0, 1),
  601. (11, 2052.53, -1884.5, 14.2526, 89.76, 1),
  602. (12, 1335.01, -2474.38, 8.5503, 90, 1),
  603. (13, 388.138, -1865.4, 8.5941, 0, 1),
  604. (14, 1315.29, -877.013, 40.2777, 90.24, 1),
  605. (15, 1604.71, -1199.53, 20.4763, 89.9399, 1),
  606. (16, 1704.7, -1326.65, 14.2448, -0.36, 1),
  607. (17, 1793.17, -1705.56, 14.2445, 90.06, 1),
  608. (18, 1213.94, -1689.02, 14.2392, 0.12, 1),
  609. (19, 517.352, -1308.77, 17.9526, 0, 1),
  610. (20, 315.955, -1357.01, 15.1888, 28.32, 1);
  611.  
  612. -- --------------------------------------------------------
  613.  
  614. --
  615. -- Table structure for table `houses`
  616. --
  617.  
  618. CREATE TABLE `houses` (
  619. `ID` int(10) NOT NULL,
  620. `Entrancex` float NOT NULL,
  621. `Entrancey` float NOT NULL,
  622. `Entrancez` float NOT NULL,
  623. `Exitx` float NOT NULL,
  624. `Exity` float NOT NULL,
  625. `Exitz` float NOT NULL,
  626. `Owner` varchar(25) NOT NULL DEFAULT 'The State',
  627. `Discription` varchar(50) NOT NULL DEFAULT 'Fara descriere.',
  628. `Value` int(20) NOT NULL,
  629. `Hel` int(11) NOT NULL,
  630. `Arm` int(11) NOT NULL,
  631. `Interior` int(11) NOT NULL,
  632. `Lockk` int(11) NOT NULL,
  633. `Owned` int(11) NOT NULL,
  634. `Rent` int(11) NOT NULL,
  635. `Rentabil` int(11) NOT NULL,
  636. `Takings` int(11) NOT NULL,
  637. `Level` int(11) NOT NULL,
  638. `Virtual` int(11) NOT NULL,
  639. `Radio` int(11) NOT NULL DEFAULT '-1'
  640. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  641.  
  642. --
  643. -- Dumping data for table `houses`
  644. --
  645.  
  646. INSERT INTO `houses` (`ID`, `Entrancex`, `Entrancey`, `Entrancez`, `Exitx`, `Exity`, `Exitz`, `Owner`, `Discription`, `Value`, `Hel`, `Arm`, `Interior`, `Lockk`, `Owned`, `Rent`, `Rentabil`, `Takings`, `Level`, `Virtual`, `Radio`) VALUES
  647. (1, 2385.39, -1711.66, 14.2422, 223.08, 1287.74, 1082.14, 'The State', 'va provoc sa dati rent', 0, 0, 0, 1, 0, 1, 4500, 1, 0, 5, 1, -1),
  648. (2, 2308.91, -1714.34, 14.9801, -42.5438, 1406.32, 1084.43, '[]KingAdY[]', 'Ori SuNtEm GoLaNi Ori Nu MaI SuNtEm. =))', 6000000, 1, 0, 8, 0, 1, 1000, 1, 0, 5, 2, -1),
  649. (3, 2307, -1679.2, 14.3316, 2233.62, -1114.58, 1050.88, 'FloriN04', 'giani', 0, 0, 0, 5, 0, 1, 500, 1, 0, 5, 3, -1),
  650. (4, 2326.88, -1681.95, 14.9297, 2308.81, -1212.24, 1049.02, 'Fane', 'Laboratorul lui Dexter', 0, 0, 0, 6, 0, 1, 1, 1, 0, 5, 4, -1),
  651. (5, 2282.32, -1641.22, 15.8898, 223.08, 1287.74, 1082.14, 'Galusca_Vlad', 'Primim doar cei mai mari mafiioti.', 0, 1, 0, 1, 0, 1, 100, 1, 0, 5, 5, -1),
  652. (6, 2244.5, -1637.63, 16.2379, 223.08, 1287.74, 1082.14, 'Ionutzz', '#Ballas4Ever', 0, 1, 0, 1, 0, 1, 400, 1, 0, 5, 6, -1),
  653. (7, 2067.05, -1731.6, 14.2066, -42.5438, 1406.32, 1084.43, 'Jhon', 'Fara descriere.', 0, 1, 0, 8, 0, 1, 4899, 1, 0, 5, 7, -1),
  654. (8, 2065.1, -1703.51, 14.1484, 244.105, 304.923, 999.148, 'FresH', 'FresH house rent 1$', 50000000, 1, 0, 1, 0, 1, 1, 1, 20, 5, 8, -1),
  655. (9, 2066.74, -1656.52, 14.1328, 2468.45, -1698.25, 1013.51, 'HazardOps12', 'Gangsters Paradise', 0, 1, 0, 2, 0, 1, 500, 1, 0, 5, 9, -1),
  656. (10, 2067.7, -1628.86, 14.2066, 376.281, 1417.53, 1081.33, 'giani', 'Te provoc da rent', 0, 1, 0, 15, 0, 1, 1, 1, 0, 5, 10, -1),
  657. (11, 2016.2, -1717.04, 14.125, -68.7771, 1351.97, 1080.21, 'HapPy', 'Bine ati venit la Casa 11', 4000000, 1, 0, 6, 0, 1, 500, 1, 0, 5, 11, -1),
  658. (12, 2015.35, -1732.64, 14.2344, 2233.62, -1114.58, 1050.88, 'The State', 'Casa Lecturatului', 0, 0, 0, 5, 0, 1, 500, 1, 2498, 5, 12, -1),
  659. (13, 1980.38, -1718.91, 17.0303, 225.662, 1022.08, 1084.02, 'Trebor', 'Pensiunea RFX', 10000000, 1, 0, 7, 0, 1, 500, 1, 0, 5, 13, -1),
  660. (14, 1854.01, -1914.26, 15.2568, 223.08, 1287.74, 1082.14, 'Sultan', 'Familia', 0, 1, 0, 1, 0, 1, 250, 1, 0, 5, 14, -1),
  661. (15, 1872.26, -1911.79, 15.2568, 223.08, 1287.74, 1082.14, 'StaLpu', 'Hey, ce faci?', 0, 1, 1, 1, 0, 1, 500, 1, 0, 5, 15, -1),
  662. (16, 1891.92, -1914.4, 15.2568, 223.08, 1287.74, 1082.14, 'Keul', 'Casa cu rent 1, intra cat e valabil.', 0, 1, 0, 1, 0, 1, 1, 1, 0, 5, 16, -1),
  663. (17, 1913.47, -1911.9, 15.2568, 223.08, 1287.74, 1082.14, 'appLe[]', 'Subscribe to Alex P. ', 0, 1, 0, 1, 0, 1, 500, 1, 0, 5, 17, -1),
  664. (18, 1928.63, -1915.9, 15.2568, 223.08, 1287.74, 1082.14, 'ProWolf', 'Nu servim silistrati', 0, 1, 0, 1, 0, 1, 69, 1, 0, 5, 18, -1),
  665. (19, 1894.25, -2133.21, 15.4663, 2282.79, -1139.4, 1050.9, 'GabiBiceps', 'Cu descriere.', 0, 0, 0, 11, 0, 1, 500, 1, 0, 5, 19, -1),
  666. (20, 1872.5, -2132.91, 15.482, 2282.79, -1139.4, 1050.9, 'The State', '|Welcome To player AnYone|', 0, 0, 0, 11, 0, 1, 1, 1, 0, 5, 20, -1),
  667. (21, 1851.88, -2134.84, 15.3882, 2282.79, -1139.4, 1050.9, 'AnImBist[]', 'Bist House', 0, 1, 0, 11, 0, 1, 10, 1, 0, 5, 21, -1),
  668. (22, 1684.81, -2098.16, 13.8343, -68.7771, 1351.97, 1080.21, 'BoBoDakes', 'Bun venit!', 0, 1, 0, 6, 0, 1, 500, 1, 0, 5, 22, -1),
  669. (23, 2149.86, -1433.75, 26.0703, 295.053, 1473.02, 1080.26, 'TGS', 'Fara descriere.', 0, 1, 0, 15, 0, 1, 500, 1, 0, 5, 23, -1),
  670. (24, 2151.18, -1400.65, 26.1285, 223.08, 1287.74, 1082.14, 'wHiTeViL', 'Rezidenta lui wHiTeViL', 0, 1, 1, 1, 0, 1, 500, 1, 0, 5, 24, -1),
  671. (25, 2129.63, -1361.69, 26.1363, -42.5438, 1406.32, 1084.43, 'Catalin.', 'Strada Budei nr 20', 0, 0, 0, 8, 0, 1, 1, 1, 0, 5, 25, -1),
  672. (26, 2185.17, -1363.71, 26.1598, 328.003, 1478.55, 1084.44, 'xzeusx', 'CASA FRUMOASA', 0, 0, 0, 15, 0, 1, 500, 1, 0, 5, 26, -1),
  673. (27, 2188.55, -1419.31, 26.1562, 2308.81, -1212.24, 1049.02, 'Anonim_black', 'Casa Moale', 0, 0, 0, 6, 0, 1, 500, 1, 0, 5, 27, -1),
  674. (28, 2256.48, -1397.24, 24.5738, 2233.62, -1114.58, 1050.88, 'Antonio_BFF', 'MATS HUMMELS', 30000000, 1, 0, 5, 0, 1, 0, 0, 0, 5, 28, -1),
  675. (29, 2243.52, -1397.24, 24.5738, 223.08, 1287.74, 1082.14, 'Dragos20', 'Fara descriere.', 0, 0, 0, 1, 0, 1, 1, 1, 0, 5, 29, -1),
  676. (30, 2230.4, -1397.24, 24.5738, 2282.79, -1139.4, 1050.9, 'seby1106', 'Dealer House !!', 0, 1, 0, 11, 0, 1, 1, 1, 0, 5, 30, -1),
  677. (31, 2207.95, -1280.82, 25.1207, 2259.82, -1135.76, 1050.63, 'Zmenta', 'Fara descriere.', 0, 0, 0, 10, 0, 1, 1, 1, 0, 5, 31, -1),
  678. (32, 2191.58, -1275.62, 25.1562, 2217.82, -1076.14, 1050.48, 'Dolores', 'HQ Bazooka', 0, 1, 0, 1, 0, 1, 1, 1, 0, 5, 32, -1),
  679. (33, 2126.69, -1320.86, 26.6241, 140.182, 1366.47, 1083.86, 'n00b.exe', 'N00B HQ', 0, 1, 0, 5, 0, 1, 5, 1, 0, 5, 33, -1),
  680. (34, 2091, -1277.84, 26.1797, 2308.81, -1212.24, 1049.02, 'Tr3vor', 'Fara descriere.', 0, 0, 0, 6, 0, 1, 1, 1, 0, 5, 34, -1),
  681. (35, 2229.6, -1241.61, 25.6562, -42.5438, 1406.32, 1084.43, 'Lakkee.', 'Ballas4Life', 0, 1, 0, 8, 0, 1, 500, 1, 0, 5, 35, -1),
  682. (36, 2191.79, -1239.23, 24.4879, 2233.62, -1114.58, 1050.88, 'VIICuSoricelu', 'Ai talent daca dai rent ;)', 0, 0, 0, 5, 0, 1, 1, 1, 0, 5, 36, -1),
  683. (37, 2470.37, -1295.51, 30.2332, 223.08, 1287.74, 1082.14, 'ionut', 'Fara descriere.', 3000000, 0, 0, 1, 0, 1, 500, 1, 0, 5, 37, -1),
  684. (38, 2434.8, -1289.31, 25.3479, 328.003, 1478.55, 1084.44, 'MariaQueen', '.sp1ke. Forta!', 0, 0, 0, 15, 0, 1, 1, 1, 0, 5, 38, -1),
  685. (39, 2433.6, -1274.99, 24.7567, 244.105, 304.923, 999.148, 'Adi.=]]', 'I Love Real Madrid', 0, 1, 0, 1, 0, 1, 500, 1, 0, 5, 39, -1),
  686. (40, 315.856, -1769.43, 4.62234, 2365.34, -1134.84, 1050.88, 'Saffron204532', 'Casa cu heal si garaj', 0, 1, 0, 8, 0, 1, 500, 1, 0, 5, 40, -1),
  687. (41, 1421.75, -886.232, 50.6863, 2233.62, -1114.58, 1050.88, 'Laurentiu18', 'Resedinta Laurentiu18', 0, 1, 0, 5, 0, 1, 500, 1, 505, 5, 41, -1),
  688. (42, 1468.56, -906.185, 54.8359, 490.865, 1399.2, 1080.26, 'Paul', '<< CASA MOBILATA >> Giveaway 100k', 50000000, 1, 0, 2, 0, 1, 1, 1, 0, 5, 42, -1),
  689. (43, 1540.47, -851.386, 64.3361, 244.105, 304.923, 999.148, 'RazvanRFX', 'Fara descriere.', 0, 0, 0, 1, 0, 1, 1, 1, 0, 5, 43, -1),
  690. (44, 1496.97, -687.892, 95.5633, 234.203, 1064.15, 1084.21, 'Ryd3r.[]', 'VIP House', 0, 1, 0, 6, 0, 1, 500, 1, 0, 5, 44, -1),
  691. (45, 1442.65, -628.831, 95.7186, 226.705, 1114.25, 1080.99, 'MrDan', 'Welcome to Los Angeles', 20000000, 1, 0, 5, 0, 1, 1, 1, 0, 5, 45, -1),
  692. (46, 1332.11, -633.503, 109.135, 225.662, 1022.08, 1084.02, 'BlueFanta', 'Fara descriere.', 0, 0, 0, 7, 0, 1, 1, 1, 0, 5, 46, -1),
  693. (47, 1298.52, -797.996, 84.1406, 225.662, 1022.08, 1084.02, 'L0RD.', '|Clandestin|', 0, 1, 0, 7, 0, 1, 1, 1, 0, 5, 47, -1),
  694. (48, 1093.88, -807.142, 107.42, 2468.45, -1698.25, 1013.51, 'Maybe', '#BallasIsMyLife', 0, 0, 0, 2, 0, 1, 1, 1, 0, 5, 48, -1),
  695. (49, 1094.99, -647.915, 113.648, 140.182, 1366.47, 1083.86, 'Browstat.', 'House of nigga', 0, 1, 1, 5, 0, 1, 1, 1, 0, 5, 49, -1),
  696. (50, 1045.11, -642.948, 120.117, 2308.81, -1212.24, 1049.02, 'ZEW.OBAMA', 'Conacu lu OBAMA', 0, 1, 0, 6, 0, 1, 500, 1, 0, 5, 50, -1),
  697. (51, 980.443, -677.291, 121.976, 234.203, 1064.15, 1084.21, 'Steve11', 'Bn ati venit la casa lui Steve11', 0, 1, 0, 6, 0, 1, 500, 1, 0, 5, 51, -1),
  698. (52, 891.195, -783.156, 101.314, 226.705, 1114.25, 1080.99, 'SeReaon', 'Casa de bastani', 0, 1, 0, 5, 0, 1, 500, 1, 0, 5, 52, -1),
  699. (53, 977.407, -771.717, 112.203, 225.662, 1022.08, 1084.02, 'Vladimir', 'KGB Hideout', 0, 1, 0, 7, 0, 1, 1, 1, 0, 5, 53, -1),
  700. (54, 1034.77, -813.199, 101.852, 235.407, 1187.37, 1080.26, 'CaSpp3r', 'Fara descriere.', 0, 0, 0, 3, 0, 1, 1, 1, 0, 5, 54, -1),
  701. (55, 937.817, -848.737, 93.5773, 223.08, 1287.74, 1082.14, 'Lecturatul', 'Casa Lecturatului !', 0, 1, 0, 1, 0, 1, 500, 1, 0, 5, 55, -1),
  702. (56, 835.966, -894.861, 68.7689, 226.705, 1114.25, 1080.99, 'Rs8', 'Bun venit !', 0, 0, 0, 5, 0, 1, 1, 1, 0, 5, 56, -1),
  703. (57, 827.767, -857.999, 70.3308, 2282.79, -1139.4, 1050.9, 'Oana', 'Oana s Crib', 3000000, 1, 0, 11, 1, 1, 500, 1, 0, 5, 57, -1),
  704. (58, 724.749, -999.403, 52.7344, 226.705, 1114.25, 1080.99, 'Florin_Z', 'La miezul noptii skin cu femei goale!', 16000000, 1, 0, 5, 0, 1, 1, 1, 0, 5, 58, -1),
  705. (59, 298.822, -1338.52, 53.4415, 2237.6, -1080.88, 1049.02, 'Cristy235', '<3 Casa Mare <3 ', 43000000, 1, 0, 2, 0, 1, 500, 1, 3, 5, 59, -1),
  706. (60, 254.399, -1367.15, 53.1094, 140.182, 1366.47, 1083.86, 'Dodo.', 'Dodo. pe zona.', 0, 1, 0, 5, 0, 1, 89, 1, 0, 5, 60, -1),
  707. (61, 189.639, -1308.13, 70.2494, 234.203, 1064.15, 1084.21, 'TheFakeKiller', '69 house', 0, 0, 0, 6, 0, 1, 1, 1, 0, 5, 61, -1),
  708. (62, 251.425, -1220.22, 76.1024, 225.662, 1022.08, 1084.02, 'Crixus99', 'Pensiunea Crixus99', 0, 1, 0, 7, 0, 1, 100, 1, 0, 5, 62, -1),
  709. (63, 300.266, -1154.48, 81.3887, 225.662, 1022.08, 1084.02, 'DeEuS', 'Fara descriere.', 0, 0, 0, 7, 0, 1, 1, 1, 0, 5, 63, -1),
  710. (64, 416.741, -1154.1, 76.6876, 226.705, 1114.25, 1080.99, 'MiYaGi[]', 'Fac cinste cu bere daca dai rent aici.', 0, 1, 0, 5, 0, 1, 1, 1, 0, 5, 64, -1),
  711. (65, 743.28, -509.318, 18.0129, -42.5438, 1406.32, 1084.43, 'luca14', 'Daca doresti casa lasa un mesaj.', 18000000, 1, 0, 8, 0, 1, 500, 1, 0, 5, 65, -1),
  712. (66, 745.139, -556.781, 18.0129, 223.08, 1287.74, 1082.14, 'The State', 'Va incurjez sa dati un rent la casa 66 hotel de 5 ', 0, 0, 0, 1, 0, 1, 1, 1, 0, 5, 66, -1),
  713. (67, 795.211, -506.149, 18.0129, -42.5438, 1406.32, 1084.43, 'costy_sTr', 'Haideti cu un rent si aci :D', 0, 0, 0, 8, 1, 1, 1, 1, 0, 5, 67, -1),
  714. (68, 2322.23, -124.957, 28.1536, -42.5438, 1406.32, 1084.43, 'AnYone', '|Welcome To player AnYone|', 0, 1, 0, 8, 0, 1, 0, 0, 0, 5, 68, -1),
  715. (69, 2245.42, -122.291, 28.1535, 300.862, 309.887, 1003.3, 'The State', 'Fara descriere.', 0, 0, 0, 4, 0, 1, 1, 1, 0, 5, 69, -1),
  716. (70, 2199.95, -37.3736, 28.1535, 267.158, 305.228, 999.148, 'The State', 'Fara descriere.', 0, 0, 0, 2, 0, 1, 1, 1, 0, 5, 70, -1),
  717. (71, 2245.5, -1.66466, 28.1536, 490.865, 1399.2, 1080.26, 'The State', 'Fara descriere.', 0, 0, 0, 2, 0, 1, 1, 1, 0, 5, 71, -1),
  718. (72, 2557.01, 87.8832, 27.6756, 223.08, 1287.74, 1082.14, 'The State', 'Fara descriere.', 0, 0, 0, 1, 0, 1, 1, 1, 0, 5, 72, -1),
  719. (73, 2513.33, -28.4033, 28.4416, 328.003, 1478.55, 1084.44, 'The State', 'Fara descriere.', 0, 0, 0, 15, 0, 1, 1, 1, 0, 5, 73, -1),
  720. (74, 2484.44, -28.4037, 28.4416, 2308.81, -1212.24, 1049.02, 'The State', 'Fara descriere.', 0, 0, 0, 6, 0, 1, 1, 1, 0, 5, 74, -1),
  721. (75, 2509.52, 11.7622, 28.4416, 2233.62, -1114.58, 1050.88, 'The State', 'Fara descriere.', 0, 0, 0, 5, 0, 1, 1, 1, 0, 5, 75, -1),
  722. (76, 2551.22, -5.51637, 27.6756, 223.08, 1287.74, 1082.14, 'The State', 'Fara descriere.', 0, 0, 0, 1, 0, 1, 1, 1, 0, 5, 76, -1),
  723. (77, 2480.61, 126.992, 27.6756, 2282.79, -1139.4, 1050.9, 'The State', 'Fara descriere.', 0, 0, 0, 11, 0, 1, 1, 1, 0, 5, 77, -1),
  724. (78, 2510.12, 88.6044, 27.6835, 2233.62, -1114.58, 1050.88, 'The State', 'Fara descriere.', 0, 0, 0, 5, 0, 1, 1, 1, 0, 5, 78, -1),
  725. (79, 2323.85, 136.381, 28.4416, -68.7771, 1351.97, 1080.21, 'The State', 'Fara descriere.', 0, 0, 0, 6, 0, 1, 1, 1, 0, 5, 79, -1),
  726. (80, 2364, 187.187, 28.4416, 328.003, 1478.55, 1084.44, 'The State', 'Fara descriere.', 0, 0, 0, 15, 0, 1, 1, 1, 0, 5, 80, -1);
  727.  
  728. -- --------------------------------------------------------
  729.  
  730. --
  731. -- Table structure for table `inf_complaints`
  732. --
  733.  
  734. CREATE TABLE `inf_complaints` (
  735. `complaint_id` int(11) NOT NULL,
  736. `complaint_user` int(11) NOT NULL,
  737. `complaint_against` int(11) NOT NULL,
  738. `complaint_reason` text NOT NULL,
  739. `complaint_proof` text NOT NULL,
  740. `complaint_description` text NOT NULL,
  741. `complaint_status` int(11) NOT NULL,
  742. `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  743. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  744.  
  745. -- --------------------------------------------------------
  746.  
  747. --
  748. -- Table structure for table `ipbans`
  749. --
  750.  
  751. CREATE TABLE `ipbans` (
  752. `ID` int(11) NOT NULL,
  753. `Name` varchar(32) NOT NULL DEFAULT 'No One',
  754. `Serial` varchar(64) NOT NULL,
  755. `By` varchar(64) NOT NULL,
  756. `Reason` varchar(64) NOT NULL,
  757. `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  758. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  759.  
  760. -- --------------------------------------------------------
  761.  
  762. --
  763. -- Table structure for table `iplogs`
  764. --
  765.  
  766. CREATE TABLE `iplogs` (
  767. `ID` int(11) NOT NULL,
  768. `ip` varchar(64) NOT NULL,
  769. `playerid` int(24) NOT NULL,
  770. `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  771. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  772.  
  773. -- --------------------------------------------------------
  774.  
  775. --
  776. -- Table structure for table `jobs`
  777. --
  778.  
  779. CREATE TABLE `jobs` (
  780. `ID` int(10) NOT NULL,
  781. `Name` varchar(32) NOT NULL DEFAULT 'No name',
  782. `NeedLevel` int(10) NOT NULL,
  783. `PosX` float NOT NULL,
  784. `PosY` float NOT NULL,
  785. `PosZ` float NOT NULL,
  786. `Legal` int(10) NOT NULL,
  787. `Skill1Veh` int(10) NOT NULL DEFAULT '400',
  788. `Skill2Veh` int(10) NOT NULL DEFAULT '400',
  789. `Skill3Veh` int(10) NOT NULL DEFAULT '400',
  790. `Skill4Veh` int(10) NOT NULL DEFAULT '400',
  791. `Skill5Veh` int(10) NOT NULL DEFAULT '400',
  792. `Skill6Veh` int(10) NOT NULL DEFAULT '400'
  793. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  794.  
  795. --
  796. -- Dumping data for table `jobs`
  797. --
  798.  
  799. INSERT INTO `jobs` (`ID`, `Name`, `NeedLevel`, `PosX`, `PosY`, `PosZ`, `Legal`, `Skill1Veh`, `Skill2Veh`, `Skill3Veh`, `Skill4Veh`, `Skill5Veh`, `Skill6Veh`) VALUES
  800. (1, 'Farmer', 1, -381.918, -1426.54, 26.053, 1, 531, 531, 532, 532, 532, 532),
  801. (2, 'Trucker', 1, -1052.17, -603.603, 32.0078, 1, 403, 403, 514, 514, 515, 515),
  802. (3, 'Wood Cutter', 1, -2016.16, -2396.52, 30.625, 1, 572, 572, 572, 572, 572, 572),
  803. (4, 'Car Jacker', 1, 1031.87, -1435.29, 13.5546, 1, 423, 423, 423, 423, 423, 423),
  804. (5, 'Arms Dealer', 3, 2795.01, -1619.17, 10.9219, 0, 499, 499, 459, 459, 482, 482),
  805. (6, 'Drugs Dealer', 3, 2178.54, -1660.49, 14.9631, 0, 400, 400, 400, 400, 400, 400),
  806. (7, 'Mechanic', 2, 915.582, -1235.24, 17.2109, 1, 400, 400, 400, 400, 400, 400),
  807. (8, 'Detective', 1, 487.191, -1639.79, 23.7031, 1, 400, 400, 400, 400, 400, 400),
  808. (9, 'Pizza Boy', 1, 2129.82, -1761.28, 13.5625, 1, 448, 448, 448, 448, 448, 448),
  809. (10, 'Curier', 1, 854.566, -604.842, 18.4219, 1, 498, 498, 498, 498, 498, 498),
  810. (11, 'Fisher', 1, 831.897, -2113.15, 2.22181, 1, 453, 453, 453, 453, 453, 453),
  811. (12, 'Pilot', 3, 1957.34, -2183.76, 13.5469, 1, 519, 519, 519, 519, 519, 519),
  812. (13, 'Forklift', 1, 2179.06, -2256.03, 14.7734, 0, 530, 530, 530, 530, 530, 530);
  813.  
  814. -- --------------------------------------------------------
  815.  
  816. --
  817. -- Table structure for table `leader_fac`
  818. --
  819.  
  820. CREATE TABLE `leader_fac` (
  821. `ID` int(11) NOT NULL,
  822. `Fac_ID` int(11) NOT NULL,
  823. `Fac_Status` int(11) NOT NULL,
  824. `Fac_Lv_Max` int(11) NOT NULL
  825. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  826.  
  827. -- --------------------------------------------------------
  828.  
  829. --
  830. -- Table structure for table `leadhelp_req`
  831. --
  832.  
  833. CREATE TABLE `leadhelp_req` (
  834. `UserID` int(11) NOT NULL,
  835. `ID` int(10) NOT NULL,
  836. `Text1` text NOT NULL,
  837. `Text2` text NOT NULL,
  838. `Category` int(11) NOT NULL,
  839. `Status` int(11) NOT NULL,
  840. `Created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  841. `Faction` int(11) NOT NULL
  842. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  843.  
  844. -- --------------------------------------------------------
  845.  
  846. --
  847. -- Table structure for table `logs`
  848. --
  849.  
  850. CREATE TABLE `logs` (
  851. `ID` int(10) NOT NULL,
  852. `Userid` int(10) NOT NULL,
  853. `Text` varchar(256) NOT NULL,
  854. `Date` varchar(256) NOT NULL,
  855. `Type` int(10) NOT NULL,
  856. `IP` varchar(256) NOT NULL
  857. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  858.  
  859. -- --------------------------------------------------------
  860.  
  861. --
  862. -- Table structure for table `safezones`
  863. --
  864.  
  865. CREATE TABLE `safezones` (
  866. `ID` int(10) NOT NULL,
  867. `X` float NOT NULL,
  868. `Y` float NOT NULL,
  869. `Z` float NOT NULL,
  870. `Range` int(10) NOT NULL
  871. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  872.  
  873. -- --------------------------------------------------------
  874.  
  875. --
  876. -- Table structure for table `sanctions`
  877. --
  878.  
  879. CREATE TABLE `sanctions` (
  880. `ID` int(10) NOT NULL,
  881. `Player` varchar(256) NOT NULL,
  882. `By` varchar(256) NOT NULL,
  883. `Time` varchar(256) NOT NULL,
  884. `Userid` int(10) NOT NULL,
  885. `Type` int(10) NOT NULL,
  886. `Reason` varchar(256) NOT NULL
  887. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  888.  
  889. -- --------------------------------------------------------
  890.  
  891. --
  892. -- Table structure for table `seif`
  893. --
  894.  
  895. CREATE TABLE `seif` (
  896. `sID` int(10) NOT NULL,
  897. `sFactionID` int(10) NOT NULL,
  898. `sPosX` float NOT NULL,
  899. `sPosY` float NOT NULL,
  900. `sPosZ` float NOT NULL,
  901. `sMoney` int(10) NOT NULL DEFAULT '500000',
  902. `sDrugs` int(10) NOT NULL DEFAULT '1000',
  903. `sMaterials` int(10) NOT NULL DEFAULT '100000',
  904. `sVirtualID` int(10) NOT NULL
  905. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  906.  
  907. --
  908. -- Dumping data for table `seif`
  909. --
  910.  
  911. INSERT INTO `seif` (`sID`, `sFactionID`, `sPosX`, `sPosY`, `sPosZ`, `sMoney`, `sDrugs`, `sMaterials`, `sVirtualID`) VALUES
  912. (1, 1, 240.603, 71.1406, 1005.04, 0, 12613, 59089, 0),
  913. (2, 2, 229.46, 168.602, 1003.02, 0, 1638, 50000, 0),
  914. (3, 3, 229.46, 168.602, 1003.02, 1669139, 251139, 654090, 1),
  915. (4, 4, 2548.21, -1281.55, 1060.98, 1031238, 125000, 199848, 4),
  916. (5, 5, 2548.21, -1281.55, 1060.98, 478359, 81886, 175420, 5),
  917. (6, 6, 2548.21, -1281.55, 1060.98, 5976, 623, 207771, 6),
  918. (7, 7, 1490.19, 1307.34, 1093.29, 11368823, 21445, 50000, 0),
  919. (8, 8, 606.258, -21.6006, 1000.9, 6002, 458, 174100, 10),
  920. (9, 9, -2033.7, -116.006, 1035.17, 783831, 197089, 182714, 0),
  921. (10, 10, 2548.21, -1281.55, 1060.98, 3063512, 1144, 15200, 10),
  922. (11, 11, -2166.13, 645.863, 1052.38, 359452, 4996, 50, 0),
  923. (12, 12, 1701.74, -1648.77, 20.2195, 125861, 100997, 167949, 1),
  924. (13, 13, 1490.32, 1307.48, 1093.29, 1908402, 145272, 24115910, 7);
  925.  
  926. -- --------------------------------------------------------
  927.  
  928. --
  929. -- Table structure for table `stuff`
  930. --
  931.  
  932. CREATE TABLE `stuff` (
  933. `ID` int(11) NOT NULL,
  934. `Tax` int(20) NOT NULL,
  935. `TaxValue` int(20) NOT NULL,
  936. `Giftbox` int(11) NOT NULL,
  937. `GiftMoney` int(20) NOT NULL,
  938. `GiftRP` int(10) NOT NULL,
  939. `GiftGold` int(10) NOT NULL,
  940. `GiftFP` int(10) NOT NULL,
  941. `GiftVehicle` int(10) NOT NULL,
  942. `GiftLevel` int(10) NOT NULL,
  943. `MaxPlayers` int(10) NOT NULL,
  944. `MaxPlayersDate` varchar(256) NOT NULL,
  945. `StaffMotd` varchar(256) NOT NULL
  946. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  947.  
  948. --
  949. -- Dumping data for table `stuff`
  950. --
  951.  
  952. INSERT INTO `stuff` (`ID`, `Tax`, `TaxValue`, `Giftbox`, `GiftMoney`, `GiftRP`, `GiftGold`, `GiftFP`, `GiftVehicle`, `GiftLevel`, `MaxPlayers`, `MaxPlayersDate`, `StaffMotd`) VALUES
  953. (1, 100, 100, 0, 154906231, 144, 740, 0, 17, 0, 96, '16/06/2017 - 20:21:02', 'Daca gresiti pe /nreply sau /nr, FACETI SCREENSHOT ca sa evitati sanctiunile.');
  954.  
  955. -- --------------------------------------------------------
  956.  
  957. --
  958. -- Table structure for table `svehicles`
  959. --
  960.  
  961. CREATE TABLE `svehicles` (
  962. `vID` int(11) NOT NULL,
  963. `vModel` int(10) NOT NULL,
  964. `LocationX` float NOT NULL,
  965. `LocationY` float NOT NULL,
  966. `LocationZ` float NOT NULL,
  967. `Angle` float NOT NULL,
  968. `Color1` int(10) NOT NULL,
  969. `Color2` int(10) NOT NULL,
  970. `Faction` int(10) NOT NULL,
  971. `Rank` int(10) NOT NULL,
  972. `NumberPlate` varchar(64) NOT NULL DEFAULT 'NewCar'
  973. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  974.  
  975. --
  976. -- Dumping data for table `svehicles`
  977. --
  978.  
  979. INSERT INTO `svehicles` (`vID`, `vModel`, `LocationX`, `LocationY`, `LocationZ`, `Angle`, `Color1`, `Color2`, `Faction`, `Rank`, `NumberPlate`) VALUES
  980. (1, 551, 489.932, -1493.65, 20.1645, -7.5, 154, -1, 7, 1, 'NewCar'),
  981. (2, 551, 489.022, -1505.19, 20.1645, -4.92, 154, -1, 7, 1, 'NewCar'),
  982. (3, 551, 490.086, -1519.65, 20.1645, 186.78, 154, -1, 7, 1, 'NewCar'),
  983. (4, 551, 479.63, -1526.72, 20.1645, 193.8, 154, -1, 7, 1, 'NewCar'),
  984. (5, 560, 494.473, -1535.04, 18.7582, 22.08, 154, -1, 7, 3, 'NewCar'),
  985. (6, 560, 499.4, -1545.92, 18.7582, 209.76, 154, -1, 7, 3, 'NewCar'),
  986. (7, 560, 484.661, -1541.69, 18.7582, 25.2599, 154, -1, 7, 3, 'NewCar'),
  987. (8, 560, 480.934, -1479.48, 19.4692, -13.2601, 154, -1, 7, 3, 'NewCar'),
  988. (9, 599, 1526.43, -1646.13, 5.964, 178.169, 0, 1, 1, 1, 'NewCar'),
  989. (10, 427, 1543.47, -1659.03, 6.0079, 89.5068, 0, 1, 1, 1, 'NewCar'),
  990. (11, 427, 1543.38, -1667.84, 5.9306, 91.0264, 0, 1, 1, 1, 'NewCar'),
  991. (12, 411, 1536.03, -1667.13, 13.1099, 359.619, 1, 1, 1, 1, 'NewCar'),
  992. (13, 596, 1553.83, -1614.46, 13.1039, 180.113, 0, 1, 1, 1, 'NewCar'),
  993. (14, 596, 1528.29, -1688.09, 5.61205, 269.386, 0, 1, 1, 1, 'NewCar'),
  994. (15, 596, 1558.76, -1710.88, 5.61231, 359.211, 0, 1, 1, 1, 'NewCar'),
  995. (16, 596, 1578.55, -1711.05, 5.61175, 359.505, 0, 1, 1, 1, 'NewCar'),
  996. (17, 523, 1599.98, -1704.36, 5.4587, 92.101, 0, 1, 1, 1, 'NewCar'),
  997. (18, 523, 1600.07, -1699.98, 5.4617, 91.1802, 0, 1, 1, 1, 'NewCar'),
  998. (19, 523, 1600.11, -1695.94, 5.4615, 94.0026, 0, 1, 1, 1, 'NewCar'),
  999. (20, 596, 1570.3, -1711, 5.61134, 359.818, 0, 1, 1, 1, 'NewCar'),
  1000. (21, 523, 1600.22, -1687.92, 5.46046, 90.2643, 0, 1, 1, 1, 'NewCar'),
  1001. (22, 523, 1600.15, -1692.2, 5.45955, 91.3169, 223, 223, 1, 1, 'NewCar'),
  1002. (23, 596, 1587.43, -1711.19, 5.61096, 359.514, 0, 1, 1, 1, 'NewCar'),
  1003. (24, 596, 1595.53, -1711.26, 5.61191, 359.657, 0, 1, 1, 1, 'NewCar'),
  1004. (25, 596, 1565.94, -1614.59, 13.1042, 180.246, 0, 1, 1, 1, 'NewCar'),
  1005. (26, 596, 1571.81, -1614.61, 13.1042, 180.463, 0, 1, 1, 1, 'NewCar'),
  1006. (27, 497, 1570.9, -1644.51, 28.5783, 2.0764, 0, 1, 1, 1, 'NewCar'),
  1007. (28, 411, 1535.97, -1676.62, 13.1099, 359.617, 1, 1, 1, 1, 'NewCar'),
  1008. (29, 490, 613.711, -596.918, 17.2782, -92.46, 0, 0, 2, 1, 'NewCar'),
  1009. (30, 528, 614.816, -601.38, 17.2782, -92.46, 0, 0, 2, 1, 'NewCar'),
  1010. (31, 599, 621.317, -610.203, 17.2782, -92.46, 0, 0, 2, 1, 'NewCar'),
  1011. (32, 599, 621.021, -605.742, 17.2782, -92.46, 0, 0, 2, 1, 'NewCar'),
  1012. (33, 490, 614.406, -591.345, 17.2782, -90.18, 0, 0, 2, 1, 'NewCar'),
  1013. (34, 490, 614.477, -586.549, 17.2782, -89.88, 0, 0, 2, 1, 'NewCar'),
  1014. (35, 528, 625.145, -585.555, 17.1605, -91.5, 0, 0, 2, 1, 'NewCar'),
  1015. (36, 490, 616.349, -543.416, 16.5824, -91.02, 0, 0, 2, 1, 'NewCar'),
  1016. (37, 490, 626.082, -543.2, 16.5824, -89.28, 0, 0, 2, 1, 'NewCar'),
  1017. (38, 497, 662.496, -585.318, 16.3516, 93.3, 0, 0, 2, 1, 'NewCar'),
  1018. (39, 541, 635.926, -577.919, 15.2722, 0, 0, 0, 2, 1, 'NewCar'),
  1019. (40, 541, 635.912, -563.584, 15.2722, -180, 0, 0, 2, 1, 'NewCar'),
  1020. (41, 470, 193.638, 1919.58, 17.654, 180.105, 0, 0, 3, 1, 'NewCar'),
  1021. (42, 470, 202.759, 1919.63, 17.654, 181.074, 0, 0, 3, 1, 'NewCar'),
  1022. (43, 470, 211.693, 1919.84, 17.6623, 181.501, 0, 0, 3, 1, 'NewCar'),
  1023. (44, 470, 220.739, 1920.07, 17.6579, 181.738, 0, 0, 3, 1, 'NewCar'),
  1024. (45, 433, 132.926, 1850.28, 18.0898, 89.3563, 0, 0, 3, 1, 'NewCar'),
  1025. (46, 520, 307.63, 1838.99, 18.3638, 358.652, 0, 0, 3, 1, 'NewCar'),
  1026. (47, 425, 226.018, 1887.66, 18.2148, 359.615, 0, 0, 3, 1, 'NewCar'),
  1027. (48, 425, 310.28, 2056.32, 18.2243, 90.7007, 0, 0, 3, 1, 'NewCar'),
  1028. (49, 476, 288.754, 2025.07, 18.3619, 267.447, 0, 0, 3, 1, 'NewCar'),
  1029. (50, 476, 288.568, 1990.84, 18.363, 268.122, 0, 0, 3, 1, 'NewCar'),
  1030. (51, 476, 287.008, 1957.08, 18.3637, 273.134, 0, 0, 3, 1, 'NewCar'),
  1031. (52, 411, 198.035, 1876.71, 17.5031, 0.96, 1, 1, 3, 1, 'NewCar'),
  1032. (53, 411, 205.513, 1876.71, 17.5031, 0, 1, 1, 3, 1, 'NewCar'),
  1033. (54, 488, -282.152, 1524.08, 75.5388, 131.035, 1, 220, 9, 1, 'NewCar'),
  1034. (55, 582, -300.181, 1577.34, 75.4164, 134.884, 1, 220, 9, 1, 'NewCar'),
  1035. (56, 582, -295.161, 1572.28, 75.4156, 134.996, 1, 220, 9, 1, 'NewCar'),
  1036. (57, 582, -290.116, 1567.36, 75.4152, 135.326, 1, 220, 9, 1, 'NewCar'),
  1037. (58, 582, -265.502, 1542.7, 75.414, 134.762, 1, 220, 9, 1, 'NewCar'),
  1038. (59, 582, -270.475, 1547.56, 75.415, 134.274, 1, 220, 9, 1, 'NewCar'),
  1039. (60, 525, 2437.65, -2078.74, 13.4393, 180.063, 0, 222, 8, 1, 'NewCar'),
  1040. (61, 525, 2448.25, -2078.74, 13.4393, 180.05, 0, 222, 8, 1, 'NewCar'),
  1041. (62, 525, 2458.35, -2078.74, 13.4393, 179.101, 0, 222, 8, 1, 'NewCar'),
  1042. (63, 525, 2468.97, -2078.74, 13.4393, 179.101, 0, 222, 8, 1, 'NewCar'),
  1043. (64, 525, 2429.85, -2111.86, 13.4329, 270.464, 0, 222, 8, 1, 'NewCar'),
  1044. (65, 525, 2430.07, -2120.12, 13.437, 270.755, 0, 222, 8, 1, 'NewCar'),
  1045. (66, 402, 1067.2, -295.447, 73.8167, 179.61, 129, 129, 11, 1, 'NewCar'),
  1046. (67, 402, 1071.4, -295.336, 73.8167, 180.648, 129, 129, 11, 1, 'NewCar'),
  1047. (68, 560, 1079.66, -294.474, 73.6938, 182.918, 129, 129, 11, 1, 'NewCar'),
  1048. (69, 487, 1113.67, -340.832, 74.1121, 87.7476, 129, 129, 11, 1, 'NewCar'),
  1049. (70, 469, 1016.87, -327.401, 74.0275, 271.39, 129, 129, 11, 1, 'NewCar'),
  1050. (71, 469, 1017.16, -338.346, 74.0143, 271.413, 129, 129, 11, 1, 'NewCar'),
  1051. (72, 469, 1017.4, -349.755, 74.0145, 271.384, 129, 129, 11, 1, 'NewCar'),
  1052. (73, 522, 1089.05, -318.092, 73.568, 89.8193, 129, 129, 11, 1, 'NewCar'),
  1053. (74, 560, 1075.35, -294.781, 73.6899, 183.618, 129, 129, 11, 1, 'NewCar'),
  1054. (75, 582, -280.262, 1557.45, 75.4151, 135.712, 1, 220, 9, 1, 'NewCar'),
  1055. (76, 582, -275.281, 1552.54, 75.4149, 135.238, 1, 220, 9, 1, 'NewCar'),
  1056. (77, 579, 1056.46, -303.512, 73.9025, 268.405, 129, 129, 11, 1, 'NewCar'),
  1057. (78, 582, -285.297, 1562.43, 75.4156, 134.901, 1, 220, 9, 1, 'NewCar'),
  1058. (79, 487, 1042.64, -350.72, 74.1562, 358.453, 129, 129, 11, 1, 'NewCar'),
  1059. (80, 487, 1098.8, -335.647, 74.1685, 180.861, 129, 129, 11, 1, 'NewCar'),
  1060. (81, 552, 2478.57, -2083.94, 13.2362, 89.3222, 222, 0, 8, 1, 'NewCar'),
  1061. (82, 552, 2488.49, -2084.05, 13.2452, 90.0184, 222, 0, 8, 1, 'NewCar'),
  1062. (83, 443, 2530.59, -2089.55, 14.181, 89.4972, 222, 0, 8, 1, 'NewCar'),
  1063. (84, 582, -304.992, 1582.27, 75.4144, 135.181, 1, 220, 9, 1, 'NewCar'),
  1064. (85, 492, 2509.88, -1672.34, 13.1908, 349.957, 234, 234, 4, 1, 'NewCar'),
  1065. (86, 560, 2473.73, -1694.81, 13.2212, 359.931, 234, 234, 4, 1, 'NewCar'),
  1066. (87, 409, 2498.52, -1683.63, 13.2576, 283.229, 234, 234, 4, 1, 'NewCar'),
  1067. (88, 560, 2500.61, -1654.46, 13.3598, 71.8017, 234, 234, 4, 1, 'NewCar'),
  1068. (89, 482, 2482.94, -1653.64, 13.2609, 89.8281, 234, 234, 4, 1, 'NewCar'),
  1069. (90, 567, 2474.45, -1680.65, 13.2925, 234.131, 234, 234, 4, 1, 'NewCar'),
  1070. (91, 482, 659.505, -1289.91, 13.6422, 179.342, 135, 135, 5, 1, 'NewCar'),
  1071. (92, 575, 660.472, -1248.59, 13.505, 345.811, 135, 135, 5, 1, 'NewCar'),
  1072. (93, 409, 659.638, -1268.81, 13.3425, 359.089, 135, 135, 5, 1, 'NewCar'),
  1073. (94, 567, 670.514, -1264.01, 13.4056, 2.5968, 135, 135, 5, 1, 'NewCar'),
  1074. (95, 560, 659.42, -1280.21, 13.2064, 358.732, 135, 135, 5, 1, 'NewCar'),
  1075. (96, 560, 670.353, -1290.46, 13.2196, 180.01, 135, 135, 5, 1, 'NewCar'),
  1076. (97, 567, 1258.7, -2010.87, 59.327, 181.808, 6, 6, 6, 1, 'NewCar'),
  1077. (98, 560, 1251.73, -2010.61, 59.3609, 181.196, 6, 6, 6, 1, 'NewCar'),
  1078. (99, 482, 1280.11, -2024.8, 59.1016, 180.992, 6, 6, 6, 1, 'NewCar'),
  1079. (100, 560, 1246.44, -2010.77, 59.5134, 179.833, 6, 6, 6, 1, 'NewCar'),
  1080. (101, 468, 1132.14, -2025.68, 68.6696, 289.191, 6, 6, 6, 1, 'NewCar'),
  1081. (102, 468, 1132.18, -2027.62, 68.6735, 283.883, 6, 6, 6, 1, 'NewCar'),
  1082. (103, 566, 1989.39, -1131.19, 25.4727, 94.2834, 179, 179, 10, 1, 'NewCar'),
  1083. (104, 409, 2002.21, -1130.54, 25.1515, 89.7879, 179, 179, 10, 1, 'NewCar'),
  1084. (105, 560, 2015.25, -1141.3, 24.6855, 88.1547, 179, 179, 10, 1, 'NewCar'),
  1085. (106, 560, 1998.69, -1141.4, 25.1536, 90.8606, 179, 179, 10, 1, 'NewCar'),
  1086. (107, 567, 2015.02, -1130.69, 24.8648, 90.6233, 179, 179, 10, 1, 'NewCar'),
  1087. (108, 482, 1986.13, -1141.24, 25.8615, 90.7514, 179, 179, 10, 1, 'NewCar'),
  1088. (109, 596, 1560.15, -1614.48, 13.1032, 180.324, 0, 1, 1, 1, 'NewCar'),
  1089. (110, 420, 1777.96, -1932.8, 13.1256, 270.707, 6, 6, 12, 1, 'NewCar'),
  1090. (111, 420, 1777.94, -1926.7, 13.1264, 270.171, 6, 6, 12, 1, 'NewCar'),
  1091. (112, 420, 1777.95, -1920.54, 13.1276, 270.065, 6, 6, 12, 1, 'NewCar'),
  1092. (113, 438, 1777.52, -1914.04, 13.3534, 271.345, 6, 6, 12, 1, 'NewCar'),
  1093. (114, 438, 1777.5, -1907.77, 13.3535, 270.304, 6, 6, 12, 1, 'NewCar'),
  1094. (115, 438, 1777.5, -1901.97, 13.3534, 269.538, 6, 6, 12, 1, 'NewCar'),
  1095. (116, 560, 1776.91, -1895.36, 13.092, 270.108, 6, 6, 12, 3, 'NewCar'),
  1096. (117, 560, 1777.01, -1888.01, 13.0926, 271.239, 6, 6, 12, 3, 'NewCar'),
  1097. (118, 416, 2041.27, -1447.72, 17.7196, 90.5719, 1, 3, 13, 1, 'NewCar'),
  1098. (119, 416, 2030.04, -1433.01, 17.2472, 177.329, 1, 3, 13, 1, 'NewCar'),
  1099. (120, 407, 2014.48, -1410.3, 17.2421, 91.0852, 3, 3, 13, 1, 'NewCar'),
  1100. (121, 416, 2000.72, -1402.95, 17.8324, 179.685, 1, 3, 13, 1, 'NewCar'),
  1101. (122, 599, 2038.57, -1426.55, 17.2919, 180.572, 1, 3, 13, 1, 'NewCar'),
  1102. (123, 599, 2038.88, -1418.99, 17.2695, 178.649, 1, 3, 13, 1, 'NewCar'),
  1103. (124, 407, 2013.88, -1418.95, 17.2275, 269.839, 3, 3, 13, 3, 'NewCar'),
  1104. (125, 445, 1024.51, -1507.89, 13.4081, 269.969, 112, 0, 0, 0, 'NewCar'),
  1105. (126, 421, 1635.18, -1907.28, 13.4339, 5.51622, 41, 2, 0, 0, 'NewCar'),
  1106. (127, 475, 1285.25, -1526.25, 13.3677, 269.382, 52, 3, 0, 0, 'NewCar'),
  1107. (128, 566, 956.348, -1187.23, 16.7255, 269.845, 25, 1, 0, 0, 'NewCar'),
  1108. (129, 458, 1506.33, -1284.33, 14.4, 178.728, 56, 2, 0, 0, 'NewCar'),
  1109. (130, 487, 1529.51, -2647.22, 13.7236, 358.528, 154, 154, 7, 1, 'NewCar'),
  1110. (131, 487, 1508.82, -2647.53, 13.7236, 356.978, 154, 154, 7, 1, 'NewCar'),
  1111. (132, 487, 1488.27, -2647.23, 13.7236, 358.508, 154, 154, 7, 1, 'NewCar'),
  1112. (133, 446, 140.919, -1920.95, -0.551752, 177.004, 154, 154, 7, 1, 'NewCar'),
  1113. (134, 446, 136.784, -1938.92, -0.520285, 149.837, 154, 154, 7, 1, 'NewCar'),
  1114. (135, 446, 135.573, -1960.84, -0.544881, 212.983, 154, 154, 7, 1, 'NewCar'),
  1115. (136, 487, 1983.49, -2647.09, 13.7235, 0.313807, 51, 71, 0, 0, 'NewCar'),
  1116. (137, 487, 1998.22, -2647.73, 13.7235, 359.699, 52, 64, 0, 0, 'NewCar'),
  1117. (138, 487, 2013.33, -2648.2, 13.7236, 359.528, 3, 64, 0, 0, 'NewCar'),
  1118. (139, 513, 1900.63, -2618.84, 14.0356, 0, 3, 2, 0, 0, 'NewCar'),
  1119. (140, 513, 1862.69, -2618.47, 14.0975, 359.327, 6, 0, 0, 0, 'NewCar'),
  1120. (141, 513, 1823.25, -2617.87, 14.098, 358.698, 9, 2, 0, 0, 'NewCar'),
  1121. (142, 511, 2091, -2636.93, 14.92, 57.4277, 211, 222, 0, 0, 'NewCar'),
  1122. (143, 461, 687.192, -1263.27, 13.1344, 90.8408, 135, 135, 5, 1, 'NewCar'),
  1123. (144, 461, 687.184, -1261.61, 13.1411, 91.2334, 135, 135, 5, 1, 'NewCar'),
  1124. (145, 461, 687.151, -1259.89, 13.1419, 85.4777, 135, 135, 5, 1, 'NewCar'),
  1125. (146, 461, 2491.35, -1686.81, 13.0981, 12.8996, 234, 234, 4, 1, 'NewCar'),
  1126. (147, 461, 2489.11, -1686.68, 13.0952, 8.19532, 234, 234, 4, 1, 'NewCar'),
  1127. (148, 461, 2486.58, -1686.53, 13.0952, 7.02641, 234, 234, 4, 1, 'NewCar'),
  1128. (149, 409, 1242.42, -2023.97, 59.7612, 180.497, 6, 6, 6, 1, 'NewCar'),
  1129. (150, 468, 1132.4, -2029.28, 68.6772, 281.85, 6, 6, 6, 1, 'NewCar'),
  1130. (151, 412, 1268.47, -2011.2, 59.0164, 181.008, 6, 6, 6, 1, 'NewCar'),
  1131. (152, 461, 1997.59, -1115.63, 26.359, 174.123, 179, 179, 10, 1, 'NewCar'),
  1132. (153, 461, 1995.76, -1115.71, 26.3571, 176.367, 179, 179, 10, 1, 'NewCar'),
  1133. (154, 461, 1993.9, -1115.73, 26.3591, 178.905, 179, 179, 10, 1, 'NewCar'),
  1134. (155, 522, 475.947, -1507.15, 20.149, 243.463, 154, 154, 7, 3, 'NewCar'),
  1135. (156, 522, 475.396, -1508.58, 20.1486, 242.868, 154, 154, 7, 3, 'NewCar'),
  1136. (157, 522, 474.83, -1509.96, 20.141, 246.643, 154, 154, 7, 3, 'NewCar'),
  1137. (158, 588, 1991.75, -2061.54, 13.2671, 178.615, 1, 1, 0, 0, 'NewCar');
  1138.  
  1139. -- --------------------------------------------------------
  1140.  
  1141. --
  1142. -- Table structure for table `tickets`
  1143. --
  1144.  
  1145. CREATE TABLE `tickets` (
  1146. `id` int(11) NOT NULL,
  1147. `Name` text NOT NULL,
  1148. `Ticket` text NOT NULL,
  1149. `Status` int(11) NOT NULL,
  1150. `Type` int(10) NOT NULL,
  1151. `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  1152. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  1153.  
  1154. -- --------------------------------------------------------
  1155.  
  1156. --
  1157. -- Table structure for table `tickets_panel`
  1158. --
  1159.  
  1160. CREATE TABLE `tickets_panel` (
  1161. `ID` int(11) NOT NULL,
  1162. `Nickname` int(11) NOT NULL,
  1163. `Ticket` text NOT NULL,
  1164. `Status` int(11) NOT NULL,
  1165. `Created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  1166. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  1167.  
  1168. -- --------------------------------------------------------
  1169.  
  1170. --
  1171. -- Table structure for table `transferlog`
  1172. --
  1173.  
  1174. CREATE TABLE `transferlog` (
  1175. `ID` int(11) NOT NULL,
  1176. `ip1` varchar(64) NOT NULL,
  1177. `ip2` varchar(64) NOT NULL,
  1178. `psql1` int(11) NOT NULL,
  1179. `psql2` int(11) NOT NULL,
  1180. `money` int(11) NOT NULL,
  1181. `time` varchar(64) NOT NULL
  1182. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  1183.  
  1184. -- --------------------------------------------------------
  1185.  
  1186. --
  1187. -- Table structure for table `turfs`
  1188. --
  1189.  
  1190. CREATE TABLE `turfs` (
  1191. `ID` int(11) NOT NULL,
  1192. `Name` varchar(64) NOT NULL,
  1193. `Owned` int(11) NOT NULL,
  1194. `Time` int(11) NOT NULL,
  1195. `MinX` float NOT NULL,
  1196. `MinY` float NOT NULL,
  1197. `MaxX` float NOT NULL,
  1198. `MaxY` float NOT NULL
  1199. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  1200.  
  1201. --
  1202. -- Dumping data for table `turfs`
  1203. --
  1204.  
  1205. INSERT INTO `turfs` (`ID`, `Name`, `Owned`, `Time`, `MinX`, `MinY`, `MaxX`, `MaxY`) VALUES
  1206. (1, 'Willowfield', 10, 24, 2500, -2246, 2892, -1804),
  1207. (2, 'Willowfield', 10, 24, 2108, -2246, 2500, -1804),
  1208. (3, 'El Corona', 10, 24, 1716, -2246, 2108, -1804),
  1209. (4, 'Verdant Bluffs', 5, 0, 1324, -2246, 1716, -1804),
  1210. (5, 'Verona Beach', 5, 0, 932, -2246, 1324, -1804),
  1211. (6, 'LS International', 5, 0, 1268, -2688, 1660, -2246),
  1212. (7, 'LS International', 4, 24, 1660, -2688, 2052, -2246),
  1213. (8, 'Ocean Docks', 4, 0, 2052, -2688, 2444, -2246),
  1214. (9, 'Ocean Docks', 4, 0, 2444, -2688, 2836, -2246),
  1215. (10, 'East Beach', 10, 24, 2500, -1804, 2892, -1362),
  1216. (11, 'Las Colinas', 10, 24, 2500, -1362, 2892, -920),
  1217. (12, 'Las Colinas', 10, 24, 2108, -1362, 2500, -920),
  1218. (13, 'Idlewood', 10, 24, 2108, -1804, 2500, -1362),
  1219. (14, 'Idlewood', 10, 24, 1716, -1804, 2108, -1362),
  1220. (15, 'Glen Park', 10, 0, 1716, -1362, 2108, -920),
  1221. (16, 'Commerce', 10, 24, 1324, -1804, 1716, -1362),
  1222. (17, 'Downtown', 10, 0, 1324, -1362, 1716, -920),
  1223. (18, 'Verona Beach', 5, 0, 932, -1804, 1324, -1362),
  1224. (19, 'Market', 5, 0, 932, -1362, 1324, -920),
  1225. (20, 'Marina', 5, 0, 540, -1804, 932, -1362),
  1226. (21, 'Vinewood', 6, 0, 540, -1362, 932, -920),
  1227. (22, 'Rodeo', 6, 0, 148, -1804, 540, -1362),
  1228. (23, 'Richman', 6, 0, 148, -1362, 540, -920),
  1229. (24, 'Mulholland', 6, 0, 592, -920, 984, -478),
  1230. (25, 'Red County', 6, 0, 984, -920, 1376, -478),
  1231. (26, 'Mulholland Intersection', 6, 0, 1376, -920, 1768, -478);
  1232.  
  1233. -- --------------------------------------------------------
  1234.  
  1235. --
  1236. -- Table structure for table `unban_req`
  1237. --
  1238.  
  1239. CREATE TABLE `unban_req` (
  1240. `ID` int(11) NOT NULL,
  1241. `User_ID` int(11) NOT NULL,
  1242. `User_Desc` text NOT NULL,
  1243. `User_Dove` text NOT NULL,
  1244. `User_Ban` text NOT NULL,
  1245. `User_Time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  1246. `User_Status` int(11) NOT NULL
  1247. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  1248.  
  1249. -- --------------------------------------------------------
  1250.  
  1251. --
  1252. -- Table structure for table `users`
  1253. --
  1254.  
  1255. CREATE TABLE `users` (
  1256. `id` int(11) NOT NULL,
  1257. `name` varchar(25) NOT NULL,
  1258. `password` varchar(50) NOT NULL,
  1259. `Security` varchar(256) NOT NULL DEFAULT 'no',
  1260. `IP` varchar(16) NOT NULL DEFAULT 'Not logged',
  1261. `Level` int(3) NOT NULL DEFAULT '0',
  1262. `Admin` int(2) NOT NULL DEFAULT '0',
  1263. `Helper` int(2) NOT NULL DEFAULT '0',
  1264. `Premium` int(2) NOT NULL DEFAULT '0',
  1265. `ConnectedTime` float NOT NULL DEFAULT '0',
  1266. `Registered` int(2) NOT NULL DEFAULT '0',
  1267. `Sex` int(2) NOT NULL DEFAULT '0',
  1268. `Age` int(3) NOT NULL DEFAULT '0',
  1269. `Muted` int(2) NOT NULL DEFAULT '0',
  1270. `MuteTime` int(11) NOT NULL DEFAULT '0',
  1271. `Respect` int(11) NOT NULL DEFAULT '0',
  1272. `Money` int(11) NOT NULL DEFAULT '0',
  1273. `Bank` int(11) NOT NULL DEFAULT '0',
  1274. `Crimes` int(11) NOT NULL DEFAULT '0',
  1275. `Kills` int(11) NOT NULL DEFAULT '0',
  1276. `Deaths` int(11) NOT NULL DEFAULT '0',
  1277. `Arrested` int(11) NOT NULL DEFAULT '0',
  1278. `WantedDeaths` int(11) NOT NULL DEFAULT '0',
  1279. `Phonebook` int(2) NOT NULL DEFAULT '0',
  1280. `LottoNr` int(5) NOT NULL DEFAULT '0',
  1281. `WantedLevel` int(11) NOT NULL DEFAULT '0',
  1282. `Job` int(3) NOT NULL DEFAULT '0',
  1283. `Paycheck` int(11) NOT NULL DEFAULT '0',
  1284. `Jailed` int(2) NOT NULL DEFAULT '0',
  1285. `JailTime` int(11) NOT NULL DEFAULT '0',
  1286. `Materials` int(11) NOT NULL DEFAULT '0',
  1287. `Drugs` int(11) NOT NULL DEFAULT '0',
  1288. `Leader` int(3) NOT NULL DEFAULT '0',
  1289. `Member` int(3) NOT NULL DEFAULT '0',
  1290. `Rank` int(2) NOT NULL DEFAULT '0',
  1291. `CChar` int(11) NOT NULL,
  1292. `FWarn` int(2) NOT NULL DEFAULT '0',
  1293. `FPunish` int(4) NOT NULL DEFAULT '0',
  1294. `Acceptpoints` int(2) NOT NULL DEFAULT '0',
  1295. `Team` int(3) NOT NULL DEFAULT '0',
  1296. `Model` int(11) NOT NULL,
  1297. `PhoneNr` int(5) NOT NULL DEFAULT '0',
  1298. `PhoneCredits` int(4) NOT NULL DEFAULT '0',
  1299. `House` int(11) NOT NULL DEFAULT '999',
  1300. `Bizz` int(11) NOT NULL DEFAULT '255',
  1301. `Rob` int(11) NOT NULL DEFAULT '0',
  1302. `CarLicT` int(11) NOT NULL DEFAULT '0',
  1303. `CarLic` int(2) NOT NULL DEFAULT '0',
  1304. `FlyLicT` int(11) NOT NULL DEFAULT '0',
  1305. `FlyLic` int(2) NOT NULL DEFAULT '0',
  1306. `BoatLicT` int(11) NOT NULL DEFAULT '0',
  1307. `BoatLic` int(2) NOT NULL DEFAULT '0',
  1308. `FishLicT` int(11) NOT NULL DEFAULT '0',
  1309. `FishLic` int(2) NOT NULL DEFAULT '0',
  1310. `GunLicT` int(11) NOT NULL DEFAULT '0',
  1311. `GunLic` int(2) NOT NULL DEFAULT '0',
  1312. `PayDay` int(20) NOT NULL DEFAULT '0',
  1313. `PayDayHad` int(20) NOT NULL DEFAULT '0',
  1314. `Tutorial` int(2) NOT NULL DEFAULT '0',
  1315. `Warnings` int(2) NOT NULL DEFAULT '0',
  1316. `Rented` int(111) NOT NULL DEFAULT '0',
  1317. `Fuel` int(11) NOT NULL DEFAULT '0',
  1318. `WTalkie` int(2) NOT NULL DEFAULT '0',
  1319. `Lighter` int(2) NOT NULL DEFAULT '0',
  1320. `Cigarettes` int(2) NOT NULL DEFAULT '0',
  1321. `Tow` int(20) NOT NULL DEFAULT '0',
  1322. `Email` varchar(50) NOT NULL DEFAULT '[email protected]',
  1323. `RegisterDate` varchar(50) NOT NULL DEFAULT 'Nu exista',
  1324. `lastOn` varchar(50) NOT NULL DEFAULT 'Nu exista',
  1325. `Banned` int(3) NOT NULL DEFAULT '0',
  1326. `Victim` varchar(64) NOT NULL,
  1327. `Radio2` int(2) NOT NULL DEFAULT '0',
  1328. `Status` int(11) NOT NULL DEFAULT '0',
  1329. `CRank` int(11) NOT NULL DEFAULT '0',
  1330. `Phone` int(11) NOT NULL DEFAULT '0',
  1331. `Accused` varchar(64) NOT NULL DEFAULT '********',
  1332. `Crime1` varchar(184) NOT NULL DEFAULT 'Fara',
  1333. `Crime2` varchar(184) NOT NULL DEFAULT 'Fara',
  1334. `Crime3` varchar(184) NOT NULL DEFAULT 'Fara',
  1335. `BTemp` int(11) NOT NULL DEFAULT '0',
  1336. `BYear` int(11) NOT NULL DEFAULT '0',
  1337. `BMonth` int(11) NOT NULL DEFAULT '0',
  1338. `BDay` int(11) NOT NULL DEFAULT '0',
  1339. `BBy` varchar(25) NOT NULL,
  1340. `BReason` varchar(184) NOT NULL,
  1341. `ALeader` int(11) NOT NULL DEFAULT '0',
  1342. `HPoints` int(11) NOT NULL DEFAULT '0',
  1343. `TruckerSkill` int(10) NOT NULL,
  1344. `GarbageSkill` int(10) NOT NULL,
  1345. `ShowJob` int(10) NOT NULL,
  1346. `ShowFP` int(10) NOT NULL,
  1347. `ShowLogo` int(10) NOT NULL DEFAULT '1',
  1348. `ShowCeas` int(10) NOT NULL DEFAULT '1',
  1349. `MowerSkill` int(10) NOT NULL,
  1350. `GoldPoints` int(10) NOT NULL,
  1351. `Clan` int(10) NOT NULL,
  1352. `ClanRank` int(10) NOT NULL,
  1353. `CarKey1` int(10) NOT NULL,
  1354. `CarKey2` int(10) NOT NULL,
  1355. `CarKey3` int(10) NOT NULL,
  1356. `CarKey4` int(10) NOT NULL,
  1357. `CarKey5` int(10) NOT NULL,
  1358. `Pin` int(10) NOT NULL DEFAULT '0',
  1359. `Seconds` int(10) NOT NULL,
  1360. `Commands` int(10) NOT NULL,
  1361. `Commands2` int(10) NOT NULL,
  1362. `Commands3` int(10) NOT NULL,
  1363. `Commands4` int(10) NOT NULL,
  1364. `Commands5` int(10) NOT NULL,
  1365. `ShowFaction` int(10) NOT NULL,
  1366. `GiftPoints` int(10) NOT NULL,
  1367. `NewbieMute` int(10) NOT NULL,
  1368. `HelpedPlayers` int(10) NOT NULL,
  1369. `SpawnChange` int(10) NOT NULL,
  1370. `DailyMission` int(11) NOT NULL DEFAULT '-1',
  1371. `DailyMission2` int(11) NOT NULL DEFAULT '-1',
  1372. `Progress` int(11) NOT NULL,
  1373. `Progress2` int(11) NOT NULL,
  1374. `NeedProgress1` int(10) NOT NULL,
  1375. `NeedProgress2` int(10) NOT NULL,
  1376. `Youtuber` int(10) NOT NULL,
  1377. `IceSkill` int(10) NOT NULL,
  1378. `ReportTime` int(10) NOT NULL,
  1379. `EvSeconds` int(100) NOT NULL,
  1380. `Descalificat` varchar(256) NOT NULL DEFAULT '0',
  1381. `WTChannel` int(10) NOT NULL,
  1382. `PizzaSkill` int(10) NOT NULL,
  1383. `GasCan` int(10) NOT NULL,
  1384. `CurierSkill` int(10) NOT NULL,
  1385. `ShowGlasses` int(10) NOT NULL,
  1386. `Glasses` int(10) NOT NULL,
  1387. `HelpedPlayersToday` int(10) NOT NULL,
  1388. `Used` int(10) NOT NULL,
  1389. `Days` int(10) NOT NULL,
  1390. `FarmerSkill` int(10) NOT NULL,
  1391. `PilotSkill` int(10) NOT NULL,
  1392. `ShowHP` int(10) NOT NULL,
  1393. `ShowAP` int(10) NOT NULL,
  1394. `Color` int(10) NOT NULL,
  1395. `Kicks` int(10) NOT NULL,
  1396. `Warns` int(10) NOT NULL,
  1397. `Bans` int(10) NOT NULL,
  1398. `Jails` int(10) NOT NULL,
  1399. `Mutes` int(10) NOT NULL,
  1400. `HoursMonth` int(10) NOT NULL,
  1401. `DayHours` int(10) NOT NULL,
  1402. `Slot1` int(10) NOT NULL,
  1403. `Slot2` int(10) NOT NULL,
  1404. `Slot3` int(10) NOT NULL,
  1405. `Slot4` int(10) NOT NULL,
  1406. `Slot5` int(10) NOT NULL,
  1407. `CarKey6` int(10) NOT NULL,
  1408. `CarKey7` int(10) NOT NULL,
  1409. `CarKey8` int(10) NOT NULL,
  1410. `CarKey9` int(10) NOT NULL,
  1411. `CarKey10` int(10) NOT NULL,
  1412. `Vip` int(10) NOT NULL,
  1413. `Mats` int(10) NOT NULL,
  1414. `ClanWarns` int(10) NOT NULL,
  1415. `ClanDays` int(10) NOT NULL,
  1416. `CarLicS` int(10) NOT NULL,
  1417. `FlyLicS` int(10) NOT NULL,
  1418. `BoatLicS` int(10) NOT NULL,
  1419. `GunLicS` int(10) NOT NULL,
  1420. `FishSkill` int(10) NOT NULL,
  1421. `ShowDMG` int(10) NOT NULL,
  1422. `EscapePoints` int(10) NOT NULL,
  1423. `AJail` int(10) NOT NULL,
  1424. `Hat` int(10) NOT NULL,
  1425. `ShowHat` int(10) NOT NULL,
  1426. `NewbieChat` int(10) NOT NULL,
  1427. `TogLC` int(10) NOT NULL,
  1428. `TogFC` int(10) NOT NULL,
  1429. `TogWT` int(10) NOT NULL,
  1430. `HidePM` int(10) NOT NULL,
  1431. `TogNews` int(10) NOT NULL,
  1432. `TogLicitatie` int(10) NOT NULL,
  1433. `TogClan` int(10) NOT NULL,
  1434. `TogEvent` int(10) NOT NULL,
  1435. `TogDing` int(10) NOT NULL,
  1436. `PhoneOnline` int(10) NOT NULL,
  1437. `DayLogin` int(10) NOT NULL,
  1438. `AW` int(10) NOT NULL,
  1439. `HW` int(10) NOT NULL,
  1440. `LW` int(10) NOT NULL,
  1441. `Tag` int(10) NOT NULL,
  1442. `MatSkill` int(10) NOT NULL,
  1443. `PaintKills1` int(10) NOT NULL,
  1444. `PaintKills2` int(10) NOT NULL,
  1445. `PaintKills3` int(10) NOT NULL,
  1446. `PaintDeaths1` int(10) NOT NULL,
  1447. `PaintDeaths2` int(10) NOT NULL,
  1448. `PaintDeaths3` int(10) NOT NULL,
  1449. `RacePoints` int(10) NOT NULL,
  1450. `RacePlace1` int(10) NOT NULL,
  1451. `RacePlace2` int(10) NOT NULL,
  1452. `RacePlace3` int(10) NOT NULL,
  1453. `RacePlace4` int(10) NOT NULL,
  1454. `ArenaKills` int(10) NOT NULL,
  1455. `ArenaDeaths` int(10) NOT NULL,
  1456. `Crash` int(11) NOT NULL,
  1457. `PosX` float NOT NULL,
  1458. `PosY` float NOT NULL,
  1459. `PosZ` float NOT NULL,
  1460. `InvalidCommands` int(10) NOT NULL,
  1461. `Referral` int(11) NOT NULL,
  1462. `ReferralMoney` int(11) NOT NULL,
  1463. `ReferralRP` int(11) NOT NULL,
  1464. `SpecialQuest` varchar(300) NOT NULL DEFAULT '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|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|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|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',
  1465. `Coins` int(10) NOT NULL,
  1466. `StivuitorSkill` int(10) NOT NULL,
  1467. `DM` int(10) NOT NULL,
  1468. `Propose` varchar(64) NOT NULL DEFAULT 'Nimeni',
  1469. `WarKills` int(11) NOT NULL,
  1470. `WarDeaths` int(11) NOT NULL,
  1471. `WarTurf` int(11) NOT NULL,
  1472. `TogVip` int(11) NOT NULL,
  1473. `Fires` int(11) NOT NULL,
  1474. `TogSurf` int(11) NOT NULL,
  1475. `TogFind` int(11) NOT NULL,
  1476. `TogRaport` int(11) NOT NULL,
  1477. `TogJob` int(11) NOT NULL,
  1478. `TogAlert` int(11) NOT NULL,
  1479. `ShowCP` int(11) NOT NULL,
  1480. `AchievementStatus` varchar(64) NOT NULL DEFAULT '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|0|0|0|0|0|0|0',
  1481. `WantedTime` int(10) NOT NULL,
  1482. `ShowProgress1` int(11) NOT NULL,
  1483. `ShowProgress2` int(11) NOT NULL,
  1484. `DailyLogin` int(11) NOT NULL,
  1485. `Backpack` int(11) NOT NULL
  1486. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  1487.  
  1488. --
  1489. -- Indexes for dumped tables
  1490. --
  1491.  
  1492. --
  1493. -- Indexes for table `apply_ques`
  1494. --
  1495. ALTER TABLE `apply_ques`
  1496. ADD PRIMARY KEY (`ID`);
  1497.  
  1498. --
  1499. -- Indexes for table `app_factions`
  1500. --
  1501. ALTER TABLE `app_factions`
  1502. ADD PRIMARY KEY (`ID`);
  1503.  
  1504. --
  1505. -- Indexes for table `banlog`
  1506. --
  1507. ALTER TABLE `banlog`
  1508. ADD PRIMARY KEY (`ID`);
  1509.  
  1510. --
  1511. -- Indexes for table `bans`
  1512. --
  1513. ALTER TABLE `bans`
  1514. ADD PRIMARY KEY (`ID`);
  1515.  
  1516. --
  1517. -- Indexes for table `bizz`
  1518. --
  1519. ALTER TABLE `bizz`
  1520. ADD PRIMARY KEY (`ID`);
  1521.  
  1522. --
  1523. -- Indexes for table `blacklist`
  1524. --
  1525. ALTER TABLE `blacklist`
  1526. ADD PRIMARY KEY (`ID`);
  1527.  
  1528. --
  1529. -- Indexes for table `cars`
  1530. --
  1531. ALTER TABLE `cars`
  1532. ADD PRIMARY KEY (`ID`);
  1533.  
  1534. --
  1535. -- Indexes for table `clans`
  1536. --
  1537. ALTER TABLE `clans`
  1538. ADD PRIMARY KEY (`ID`);
  1539.  
  1540. --
  1541. -- Indexes for table `commands`
  1542. --
  1543. ALTER TABLE `commands`
  1544. ADD PRIMARY KEY (`ID`);
  1545.  
  1546. --
  1547. -- Indexes for table `commentaries`
  1548. --
  1549. ALTER TABLE `commentaries`
  1550. ADD PRIMARY KEY (`ID`);
  1551.  
  1552. --
  1553. -- Indexes for table `comm_req`
  1554. --
  1555. ALTER TABLE `comm_req`
  1556. ADD PRIMARY KEY (`ID`);
  1557.  
  1558. --
  1559. -- Indexes for table `dsveh`
  1560. --
  1561. ALTER TABLE `dsveh`
  1562. ADD PRIMARY KEY (`ID`);
  1563.  
  1564. --
  1565. -- Indexes for table `emails`
  1566. --
  1567. ALTER TABLE `emails`
  1568. ADD PRIMARY KEY (`ID`);
  1569.  
  1570. --
  1571. -- Indexes for table `factionlog`
  1572. --
  1573. ALTER TABLE `factionlog`
  1574. ADD PRIMARY KEY (`ID`);
  1575.  
  1576. --
  1577. -- Indexes for table `factions`
  1578. --
  1579. ALTER TABLE `factions`
  1580. ADD PRIMARY KEY (`ID`);
  1581.  
  1582. --
  1583. -- Indexes for table `faction_logs`
  1584. --
  1585. ALTER TABLE `faction_logs`
  1586. ADD PRIMARY KEY (`id`);
  1587.  
  1588. --
  1589. -- Indexes for table `fobjects`
  1590. --
  1591. ALTER TABLE `fobjects`
  1592. ADD PRIMARY KEY (`ID`),
  1593. ADD KEY `ID` (`ID`);
  1594.  
  1595. --
  1596. -- Indexes for table `friends`
  1597. --
  1598. ALTER TABLE `friends`
  1599. ADD PRIMARY KEY (`ID`);
  1600.  
  1601. --
  1602. -- Indexes for table `graffiti`
  1603. --
  1604. ALTER TABLE `graffiti`
  1605. ADD PRIMARY KEY (`ID`);
  1606.  
  1607. --
  1608. -- Indexes for table `houses`
  1609. --
  1610. ALTER TABLE `houses`
  1611. ADD PRIMARY KEY (`ID`),
  1612. ADD KEY `ID` (`ID`);
  1613.  
  1614. --
  1615. -- Indexes for table `inf_complaints`
  1616. --
  1617. ALTER TABLE `inf_complaints`
  1618. ADD PRIMARY KEY (`complaint_id`);
  1619.  
  1620. --
  1621. -- Indexes for table `ipbans`
  1622. --
  1623. ALTER TABLE `ipbans`
  1624. ADD PRIMARY KEY (`ID`);
  1625.  
  1626. --
  1627. -- Indexes for table `iplogs`
  1628. --
  1629. ALTER TABLE `iplogs`
  1630. ADD PRIMARY KEY (`ID`);
  1631.  
  1632. --
  1633. -- Indexes for table `jobs`
  1634. --
  1635. ALTER TABLE `jobs`
  1636. ADD PRIMARY KEY (`ID`),
  1637. ADD KEY `ID` (`ID`);
  1638.  
  1639. --
  1640. -- Indexes for table `leader_fac`
  1641. --
  1642. ALTER TABLE `leader_fac`
  1643. ADD PRIMARY KEY (`ID`);
  1644.  
  1645. --
  1646. -- Indexes for table `leadhelp_req`
  1647. --
  1648. ALTER TABLE `leadhelp_req`
  1649. ADD PRIMARY KEY (`ID`);
  1650.  
  1651. --
  1652. -- Indexes for table `logs`
  1653. --
  1654. ALTER TABLE `logs`
  1655. ADD PRIMARY KEY (`ID`);
  1656.  
  1657. --
  1658. -- Indexes for table `safezones`
  1659. --
  1660. ALTER TABLE `safezones`
  1661. ADD PRIMARY KEY (`ID`),
  1662. ADD KEY `ID` (`ID`);
  1663.  
  1664. --
  1665. -- Indexes for table `sanctions`
  1666. --
  1667. ALTER TABLE `sanctions`
  1668. ADD PRIMARY KEY (`ID`);
  1669.  
  1670. --
  1671. -- Indexes for table `seif`
  1672. --
  1673. ALTER TABLE `seif`
  1674. ADD PRIMARY KEY (`sID`);
  1675.  
  1676. --
  1677. -- Indexes for table `stuff`
  1678. --
  1679. ALTER TABLE `stuff`
  1680. ADD PRIMARY KEY (`ID`);
  1681.  
  1682. --
  1683. -- Indexes for table `svehicles`
  1684. --
  1685. ALTER TABLE `svehicles`
  1686. ADD PRIMARY KEY (`vID`);
  1687.  
  1688. --
  1689. -- Indexes for table `tickets`
  1690. --
  1691. ALTER TABLE `tickets`
  1692. ADD PRIMARY KEY (`id`);
  1693.  
  1694. --
  1695. -- Indexes for table `tickets_panel`
  1696. --
  1697. ALTER TABLE `tickets_panel`
  1698. ADD PRIMARY KEY (`ID`);
  1699.  
  1700. --
  1701. -- Indexes for table `transferlog`
  1702. --
  1703. ALTER TABLE `transferlog`
  1704. ADD PRIMARY KEY (`ID`);
  1705.  
  1706. --
  1707. -- Indexes for table `turfs`
  1708. --
  1709. ALTER TABLE `turfs`
  1710. ADD PRIMARY KEY (`ID`);
  1711.  
  1712. --
  1713. -- Indexes for table `unban_req`
  1714. --
  1715. ALTER TABLE `unban_req`
  1716. ADD PRIMARY KEY (`ID`);
  1717.  
  1718. --
  1719. -- Indexes for table `users`
  1720. --
  1721. ALTER TABLE `users`
  1722. ADD PRIMARY KEY (`id`),
  1723. ADD UNIQUE KEY `id_2` (`id`),
  1724. ADD KEY `id` (`id`);
  1725.  
  1726. --
  1727. -- AUTO_INCREMENT for dumped tables
  1728. --
  1729.  
  1730. --
  1731. -- AUTO_INCREMENT for table `apply_ques`
  1732. --
  1733. ALTER TABLE `apply_ques`
  1734. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
  1735. --
  1736. -- AUTO_INCREMENT for table `app_factions`
  1737. --
  1738. ALTER TABLE `app_factions`
  1739. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=237;
  1740. --
  1741. -- AUTO_INCREMENT for table `banlog`
  1742. --
  1743. ALTER TABLE `banlog`
  1744. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=163;
  1745. --
  1746. -- AUTO_INCREMENT for table `bans`
  1747. --
  1748. ALTER TABLE `bans`
  1749. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  1750. --
  1751. -- AUTO_INCREMENT for table `bizz`
  1752. --
  1753. ALTER TABLE `bizz`
  1754. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
  1755. --
  1756. -- AUTO_INCREMENT for table `blacklist`
  1757. --
  1758. ALTER TABLE `blacklist`
  1759. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT;
  1760. --
  1761. -- AUTO_INCREMENT for table `cars`
  1762. --
  1763. ALTER TABLE `cars`
  1764. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=664;
  1765. --
  1766. -- AUTO_INCREMENT for table `clans`
  1767. --
  1768. ALTER TABLE `clans`
  1769. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  1770. --
  1771. -- AUTO_INCREMENT for table `commands`
  1772. --
  1773. ALTER TABLE `commands`
  1774. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  1775. --
  1776. -- AUTO_INCREMENT for table `commentaries`
  1777. --
  1778. ALTER TABLE `commentaries`
  1779. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=459;
  1780. --
  1781. -- AUTO_INCREMENT for table `comm_req`
  1782. --
  1783. ALTER TABLE `comm_req`
  1784. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT;
  1785. --
  1786. -- AUTO_INCREMENT for table `dsveh`
  1787. --
  1788. ALTER TABLE `dsveh`
  1789. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=96;
  1790. --
  1791. -- AUTO_INCREMENT for table `emails`
  1792. --
  1793. ALTER TABLE `emails`
  1794. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=599;
  1795. --
  1796. -- AUTO_INCREMENT for table `factionlog`
  1797. --
  1798. ALTER TABLE `factionlog`
  1799. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=181;
  1800. --
  1801. -- AUTO_INCREMENT for table `factions`
  1802. --
  1803. ALTER TABLE `factions`
  1804. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
  1805. --
  1806. -- AUTO_INCREMENT for table `faction_logs`
  1807. --
  1808. ALTER TABLE `faction_logs`
  1809. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=161;
  1810. --
  1811. -- AUTO_INCREMENT for table `fobjects`
  1812. --
  1813. ALTER TABLE `fobjects`
  1814. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1522;
  1815. --
  1816. -- AUTO_INCREMENT for table `friends`
  1817. --
  1818. ALTER TABLE `friends`
  1819. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1224;
  1820. --
  1821. -- AUTO_INCREMENT for table `graffiti`
  1822. --
  1823. ALTER TABLE `graffiti`
  1824. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
  1825. --
  1826. -- AUTO_INCREMENT for table `houses`
  1827. --
  1828. ALTER TABLE `houses`
  1829. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;
  1830. --
  1831. -- AUTO_INCREMENT for table `inf_complaints`
  1832. --
  1833. ALTER TABLE `inf_complaints`
  1834. MODIFY `complaint_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=159;
  1835. --
  1836. -- AUTO_INCREMENT for table `ipbans`
  1837. --
  1838. ALTER TABLE `ipbans`
  1839. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  1840. --
  1841. -- AUTO_INCREMENT for table `iplogs`
  1842. --
  1843. ALTER TABLE `iplogs`
  1844. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18526;
  1845. --
  1846. -- AUTO_INCREMENT for table `jobs`
  1847. --
  1848. ALTER TABLE `jobs`
  1849. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  1850. --
  1851. -- AUTO_INCREMENT for table `leader_fac`
  1852. --
  1853. ALTER TABLE `leader_fac`
  1854. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
  1855. --
  1856. -- AUTO_INCREMENT for table `leadhelp_req`
  1857. --
  1858. ALTER TABLE `leadhelp_req`
  1859. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT;
  1860. --
  1861. -- AUTO_INCREMENT for table `logs`
  1862. --
  1863. ALTER TABLE `logs`
  1864. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=203050;
  1865. --
  1866. -- AUTO_INCREMENT for table `safezones`
  1867. --
  1868. ALTER TABLE `safezones`
  1869. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  1870. --
  1871. -- AUTO_INCREMENT for table `sanctions`
  1872. --
  1873. ALTER TABLE `sanctions`
  1874. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1030;
  1875. --
  1876. -- AUTO_INCREMENT for table `seif`
  1877. --
  1878. ALTER TABLE `seif`
  1879. MODIFY `sID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
  1880. --
  1881. -- AUTO_INCREMENT for table `stuff`
  1882. --
  1883. ALTER TABLE `stuff`
  1884. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  1885. --
  1886. -- AUTO_INCREMENT for table `svehicles`
  1887. --
  1888. ALTER TABLE `svehicles`
  1889. MODIFY `vID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=159;
  1890. --
  1891. -- AUTO_INCREMENT for table `tickets`
  1892. --
  1893. ALTER TABLE `tickets`
  1894. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  1895. --
  1896. -- AUTO_INCREMENT for table `tickets_panel`
  1897. --
  1898. ALTER TABLE `tickets_panel`
  1899. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;
  1900. --
  1901. -- AUTO_INCREMENT for table `transferlog`
  1902. --
  1903. ALTER TABLE `transferlog`
  1904. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=224;
  1905. --
  1906. -- AUTO_INCREMENT for table `turfs`
  1907. --
  1908. ALTER TABLE `turfs`
  1909. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
  1910. --
  1911. -- AUTO_INCREMENT for table `unban_req`
  1912. --
  1913. ALTER TABLE `unban_req`
  1914. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
  1915. --
  1916. -- AUTO_INCREMENT for table `users`
  1917. --
  1918. ALTER TABLE `users`
  1919. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2631;
  1920. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  1921. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  1922. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!