API tools faq
paste
Advertisement
xt3z0ne

Createbiz help

xt3z0ne
Aug 15th, 2018
268
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.02 KB | None | 0 0
raw download clone embed print report
  1. Baza de date + Originala a sv 
  2. --
  3. -- Table structure for table `bizz`
  4. --
  5.  
  6. CREATE TABLE `bizz` (
  7. `ID` int(11) NOT NULL,
  8. `Owned` int(2) NOT NULL,
  9. `Owner` varchar(25) NOT NULL DEFAULT 'The State',
  10. `Message` varchar(50) NOT NULL,
  11. `EntranceX` float NOT NULL,
  12. `EntranceY` float NOT NULL,
  13. `EntranceZ` float NOT NULL,
  14. `ExitX` float NOT NULL,
  15. `ExitY` float NOT NULL,
  16. `ExitZ` float NOT NULL,
  17. `LevelNeeded` int(11) NOT NULL DEFAULT '15',
  18. `BuyPrice` int(11) NOT NULL DEFAULT '40000000',
  19. `EntranceCost` int(11) NOT NULL DEFAULT '5',
  20. `Till` int(11) NOT NULL,
  21. `Sbiz` int(2) NOT NULL,
  22. `Type` int(3) NOT NULL,
  23. `Locked` int(11) NOT NULL,
  24. `Interior` int(11) NOT NULL,
  25. `Virtual` int(11) NOT NULL
  26. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  27. --
  28. -- Dumping data for table `bizz`
  29. --
  30.  
  31. INSERT INTO `bizz` (`ID`, `Owned`, `Owner`, `Message`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Sbiz`, `Type`, `Locked`, `Interior`, `Virtual`) VALUES
  32. (1, 1, 'LegendSK', 'Banca LS', 1462.49, -1012.63, 26.8438, 2306, -16, 27, 15, 40000000, 500, 3702000, 0, 1, 0, 0, 0),
  33. (2, 1, 'MIRCESCU', 'Gun Shop LS', 1367.99, -1279.75, 13.5469, 316, -142, 1000, 15, 40000000, 2500, 127500, 0, 2, 0, 7, 0),
  34. (3, 0, 'The State', 'Alhambra', 1836.09, -1682.5, 13.3624, 493.46, -24.0736, 1000.68, 15, 60000000, 500, 0, 0, 3, 0, 17, 0),
  35. (4, 0, 'The State', 'Cluckin Bell', 2102.38, 2228.72, 11.0234, 364.942, -11.0787, 1001.85, 15, 40000000, 500, 1000, 0, 14, 0, 9, 0),
  36. (5, 0, 'The State', 'Bar ', 2421.41, -1220.3, 25.4937, 1204.83, -13.4011, 1000.92, 15, 40000000, 500, 0, 0, 3, 0, 2, 0),
  37. (6, 0, 'The State', 'CLUB ', 2309.85, -1643.54, 14.827, -794.942, 490.782, 1376.2, 15, 50000000, 500, 0, 0, 3, 0, 1, 0),
  38. (7, 0, 'The State', 'Sex Shop', 1087.63, -923.003, 43.3906, -100.403, -24.3921, 1000.72, 15, 40000000, 500, 500, 0, 4, 0, 3, 0),
  39. (8, 1, 'BoyManN_', 'Casino LV', 2019.6, 1007.68, 10.8203, 2015.45, 1017.09, 996.875, 15, 40000000, 500, 1000, 0, 5, 0, 10, 1),
  40. (9, 0, 'The State', 'GunShop LS', 1791.71, -1163.6, 23.8281, 316, -142, 1000, 15, 40000000, 500, 9400, 0, 2, 0, 7, 1),
  41. (10, 0, 'The State', '24/7', 1352.16, -1759.17, 13.5078, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 9550, 0, 6, 0, 18, 0),
  42. (11, 0, 'The State', '24/7', 999.932, -919.889, 42.3281, -31.0246, -91.3283, 1003.55, 15, 57000000, 500, 500, 0, 6, 0, 18, 1),
  43. (12, 0, 'The State', '24/7', 1833.14, -1842.5, 13.5781, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 53450, 0, 6, 0, 18, 2),
  44. (13, 0, 'The State', '24/7', 1929.37, -1776.14, 13.5469, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 0, 0, 6, 0, 18, 3),
  45. (14, 0, 'The State', '24/7', 1315.7, -898.097, 39.5781, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 8650, 0, 6, 0, 18, 4),
  46. (15, 0, 'The State', 'Burger Shot', 1199.38, -919.098, 43.1152, 363.134, -74.8469, 1001.51, 15, 45000000, 500, 800, 0, 7, 0, 10, 0),
  47. (16, 0, 'The State', 'Burger Shot', 810.737, -1616.19, 13.5469, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 500, 0, 7, 0, 10, 1),
  48. (17, 0, 'The State', 'Burger Shot', 2472.79, 2034.26, 11.0625, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 0, 0, 7, 0, 10, 2),
  49. (18, 0, 'The State', 'Burger Shot', 1158.14, 2072.27, 11.0625, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 0, 0, 7, 0, 10, 3),
  50. (19, 0, 'The State', 'Burger Shot', 2170.06, 2795.64, 10.8203, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 0, 0, 7, 0, 10, 4),
  51. (20, 0, 'The State', 'Burger Shot', 1872.71, 2071.67, 11.0625, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 0, 0, 7, 0, 10, 5),
  52. (21, 0, 'The State', 'Banca LV', 2194.99, 1676.89, 12.3672, 2306, -16, 27, 15, 40000000, 500, 0, 0, 1, 0, 0, 1),
  53. (22, 0, 'The State', 'GunShop LV', 2556.62, 2063.98, 11.0995, 316, -142, 1000, 15, 40000000, 500, 0, 0, 2, 0, 7, 2),
  54. (23, 0, 'The State', 'Sex Shop LV', 2515.95, 2297.69, 10.8203, -100.403, -24.3921, 1000.72, 15, 40000000, 500, 0, 0, 4, 0, 3, 1),
  55. (24, 0, 'The State', '24/7', 2637.61, 1129.28, 11.1797, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 500, 0, 6, 0, 18, 5),
  56. (25, 0, 'The State', 'Gym LS', 2229.22, -1721.89, 13.5671, 772.112, -3.89865, 1000.73, 15, 40600000, 500, 0, 0, 8, 0, 5, 0),
  57. (26, 0, 'The State', 'Pizza', 2104.57, -1806.67, 13.5547, 372.54, -133.009, 1001.49, 15, 45000000, 500, 0, 0, 9, 0, 5, 6),
  58. (27, 0, 'The State', 'Banca LS', 1102.91, -1440.13, 15.7969, 2306, -16, 27, 15, 55000000, 500, 1000, 0, 1, 0, 0, 2),
  59. (28, 0, 'The State', 'Tasteaza [/ad] LvL 5', 1168.43, -1489.36, 22.757, 0, 0, 0, 15, 40000000, 500, 0, 1, 15, 1, 0, 0),
  60. (29, 0, 'The State', 'Binco', 2102.56, 2257.37, 11.0234, 207.738, -109.02, 1005.13, 15, 45000000, 500, 2500, 0, 11, 0, 15, 2),
  61. (30, 0, 'The State', 'Zip', 499.936, -1359.74, 16.2911, 161.391, -93.1592, 1001.8, 15, 40000000, 500, 120000, 0, 11, 0, 18, 0),
  62. (31, 0, 'The State', 'Rent Car', 563.145, -1289.79, 17.2482, 0, 0, 0, 15, 40000000, 500, 1400, 1, 10, 1, 0, 0),
  63. (32, 0, 'The State', 'Zip', 1456.98, -1138.04, 23.9778, 161.391, -93.1592, 1001.8, 15, 40000000, 500, 1000, 0, 11, 0, 18, 1),
  64. (33, 0, 'The State', 'Gas Station', 1941.6, -1764.74, 13.6406, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0),
  65. (34, 0, 'The State', 'PNS', 723.409, -463.627, 16.3359, 0, 0, 0, 15, 57000000, 500, 0, 1, 13, 1, 0, 0),
  66. (35, 0, 'The State', 'PNS', 2072.57, -1828.03, 13.5469, 0, 0, 0, 15, 50000000, 500, 1500, 1, 13, 1, 0, 0),
  67. (36, 1, 'Fiv3$eveN.)', 'PNS', 1034.7, -1028.1, 32.1016, 0, 0, 0, 15, 40000000, 500, 9000, 1, 13, 1, 0, 0),
  68. (37, 1, 'SpriteTv', 'PNS', 485.37, -1733.32, 11.094, 0, 0, 0, 15, 40000000, 500, 6500, 1, 13, 1, 0, 0),
  69. (38, 0, 'The State', 'Mod Shop', 1037.11, -1025.04, 32.1016, 0, 0, 0, 15, 68000000, 500, 3500, 1, 16, 1, 0, 0),
  70. (39, 0, 'The State', 'Mod Shop', 2650.33, -2021.76, 14.1766, 0, 0, 0, 15, 40000000, 500, 0, 1, 16, 1, 0, 0),
  71. (40, 0, 'The State', 'PNS', 1966.45, 2156.36, 10.8203, 0, 0, 0, 15, 40000000, 500, 1000, 1, 13, 1, 0, 0),
  72. (41, 0, 'The State', 'PNS', -94.1097, 1109.86, 19.7422, 0, 0, 0, 15, 40000000, 500, 0, 1, 13, 1, 0, 0),
  73. (42, 0, 'The State', 'Gas Station', 1012.9, -935.545, 42.1797, 0, 0, 0, 15, 40000000, 500, 2300, 1, 12, 1, 0, 0),
  74. (43, 0, 'The State', 'Gas Station', 701.554, -567.347, 16.1459, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0),
  75. (44, 0, 'The State', 'Gas Station', -78.6301, -1169.16, 2.1491, 0, 0, 0, 15, 60000000, 500, 0, 1, 12, 1, 0, 0),
  76. (45, 0, 'The State', 'Gas Station', 2646.33, 1101.31, 10.9609, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0),
  77. (46, 0, 'The State', 'Gas Station', 2139.81, 2753.5, 10.8203, 0, 0, 0, 15, 60000000, 500, 0, 1, 12, 1, 0, 0),
  78. (47, 0, 'The State', 'Gas Station', 2207.51, 2482.56, 10.8203, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0),
  79. (48, 0, 'The State', 'Gas Station', 1604.09, 2204.47, 10.8203, 0, 0, 0, 15, 50000000, 500, 0, 1, 12, 1, 0, 0),
  80. (49, 0, 'The State', 'Gas Station', 2122.56, 914.539, 10.8203, 0, 0, 0, 15, 40000000, 500, 1140, 1, 12, 1, 0, 0),
  81. (50, 0, 'The State', 'Gas Station', 638.368, 1683.78, 7.1875, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0),
  82. (51, 0, 'The State', 'Mod Shop', 2392.17, 1042.01, 10.8203, 0, 0, 0, 15, 350000000, 500, 0, 1, 16, 1, 0, 0),
  83. (52, 0, 'The State', 'CNN LV', 2079.2, 2045.07, 11.0579, 0, 0, 0, 15, 40000000, 500, 0, 1, 15, 0, 0, 0),
  84. (53, 0, 'The State', 'Binco', 2244.38, -1665.16, 15.4766, 207.738, -109.02, 1005.13, 15, 40000000, 500, 11500, 0, 11, 0, 15, 1),
  85. (54, 0, 'The State', 'Cluckin Bell', 172.527, 1176.09, 14.7645, 364.942, -11.0787, 1001.85, 15, 40000000, 500, 0, 0, 14, 0, 9, 1);
  86.  
  87. -- --------------------------------------------------------
  88.  
  89.  
  90.  
  91. Baza de date Baza de date a comenzi din gm
  92.  
  93. -- phpMyAdmin SQL Dump
  94. -- version 4.8.2
  95. -- https://www.phpmyadmin.net/
  96. --
  97. -- Host: 127.0.0.1
  98. -- Generation Time: Aug 15, 2018 at 01:05 AM
  99. -- Server version: 10.1.34-MariaDB
  100. -- PHP Version: 7.2.7
  101.  
  102. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  103. SET AUTOCOMMIT = 0;
  104. START TRANSACTION;
  105. SET time_zone = "+00:00";
  106.  
  107.  
  108. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  109. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  110. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  111. /*!40101 SET NAMES utf8mb4 */;
  112.  
  113. --
  114. -- Database: `bazadedate`
  115. --
  116.  
  117. -- --------------------------------------------------------
  118.  
  119. --
  120. -- Table structure for table `bizz`
  121. --
  122.  
  123. CREATE TABLE `bizz` (
  124. `ID` int(11) NOT NULL,
  125. `Owned` int(2) NOT NULL,
  126. `Owner` varchar(25) NOT NULL DEFAULT 'The State',
  127. `Message` varchar(50) NOT NULL,
  128. `EntranceX` float NOT NULL,
  129. `EntranceY` float NOT NULL,
  130. `EntranceZ` float NOT NULL,
  131. `ExitX` float NOT NULL,
  132. `ExitY` float NOT NULL,
  133. `ExitZ` float NOT NULL,
  134. `LevelNeeded` int(11) NOT NULL DEFAULT '15',
  135. `BuyPrice` int(11) NOT NULL DEFAULT '20000000',
  136. `EntranceCost` int(11) NOT NULL DEFAULT '5',
  137. `Till` int(11) NOT NULL,
  138. `Sbiz` int(2) NOT NULL,
  139. `Type` int(3) NOT NULL,
  140. `Locked` int(11) NOT NULL,
  141. `Interior` int(11) NOT NULL,
  142. `Virtual` int(11) NOT NULL,
  143. `Prices` int(11) NOT NULL DEFAULT '0'
  144. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  145.  
  146. --
  147. -- Indexes for dumped tables
  148. --
  149.  
  150. --
  151. -- Indexes for table `bizz`
  152. --
  153. ALTER TABLE `bizz`
  154. ADD PRIMARY KEY (`ID`);
  155.  
  156. --
  157. -- AUTO_INCREMENT for dumped tables
  158. --
  159.  
  160. --
  161. -- AUTO_INCREMENT for table `bizz`
  162. --
  163. ALTER TABLE `bizz`
  164. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  165. COMMIT;
  166.  
  167. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  168. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  169. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  170.  
  171.  
  172.  
  173. Comanda
  174. CMD:createbiz(playerid, params[]) {
  175. if(PlayerInfo[playerid][pAdmin] < 6) return 1;
  176. new type, value, level, idd = bussines+1, Float: Pos[3], query[256];
  177. if(sscanf(params, "iii", type, value, level)) {
  178. SCM(playerid, COLOR_GREY, "Syntax: {FFFFFF}/createbiz <type> <value> <level>");
  179. SCM(playerid, COLOR_GREY, "(1) Banca, (2) Gun Shop, (3) Club, (4) Sex Shop, (5) Casino, (6) 24/7, (7) Burger Shot, (8) Gym");
  180. SCM(playerid, COLOR_GREY, "(9) Pizza, (11) Binco, (12) Gas Station, (13) PNS*, (14) Cluckin Bell, (15) CNN, (16) Tuning*");
  181. return 1;
  182. }
  183. if(type == 10 || type < 1) return SCM(playerid, COLOR_GREY, "Invalid type!");
  184. GetPlayerPos(playerid, Pos[0], Pos[1], Pos[2]);
  185. switch(type) {
  186. case 1: {
  187. format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '2306', '-16', '27', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  188. BizzInfo[idd][bExitX] = 2306; BizzInfo[idd][bExitY] = -16; BizzInfo[idd][bExitZ] = 27;
  189. }
  190. case 2: {
  191. format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '316', '-142', '1000', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  192. BizzInfo[idd][bExitX] = 316; BizzInfo[idd][bExitY] = -142; BizzInfo[idd][bExitZ] = 1000;
  193. }
  194. case 3: {
  195. format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '-794.942', '490.782', '1376.2', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  196. BizzInfo[idd][bExitX] = -794.942; BizzInfo[idd][bExitY] = 490.782; BizzInfo[idd][bExitZ] = 1376.2;
  197. }
  198. case 4: {
  199. format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '-100.403', '-24.3921', '1000.72', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  200. BizzInfo[idd][bExitX] = -100.403; BizzInfo[idd][bExitY] = -24.3921; BizzInfo[idd][bExitZ] = 1000.72;
  201. }
  202. case 5: {
  203. format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '2015.45', '1017.09', '996.875', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  204. BizzInfo[idd][bExitX] = 2015.45; BizzInfo[idd][bExitY] = 1017.09; BizzInfo[idd][bExitZ] = 996.875;
  205. }
  206. case 6: {
  207. format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '-31.0246', '-91.3283', '1003.55', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  208. BizzInfo[idd][bExitX] = -31.0246; BizzInfo[idd][bExitY] = -91.3283; BizzInfo[idd][bExitZ] = 1003.55;
  209. }
  210. case 7: {
  211. format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '363.134', '-74.8469', '1001.51', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  212. BizzInfo[idd][bExitX] = 363.134; BizzInfo[idd][bExitY] = -74.8469; BizzInfo[idd][bExitZ] = 1001.51;
  213. }
  214. case 8: {
  215. format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '772.112', '-3.89865', '1000.73', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  216. BizzInfo[idd][bExitX] = 772.112; BizzInfo[idd][bExitY] = -3.89865; BizzInfo[idd][bExitZ] = 1000.73;
  217. }
  218. case 9: {
  219. format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '372.54', '-133.009', '1001.49', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  220. BizzInfo[idd][bExitX] = 372.54; BizzInfo[idd][bExitY] = -133.009; BizzInfo[idd][bExitZ] = 1001.49;
  221. }
  222. case 11: {
  223. format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '207.738', '-109.02', '1005.13', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  224. BizzInfo[idd][bExitX] = 207.738; BizzInfo[idd][bExitY] = -109.02; BizzInfo[idd][bExitZ] = 1005.13;
  225. }
  226. case 12: format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Sbiz`) VALUES ('%f', '%f', '%f', '0', '0', '0', '%d', '%d', '%d', '1', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  227. //case 13: format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Sbiz`) VALUES ('%f', '%f', '%f', '0', '0', '0', '%d', '%d', '%d', '1', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  228. case 14: {
  229. format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '364.942', '-11.0787', '1001.85', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  230. BizzInfo[idd][bExitX] = 364.942; BizzInfo[idd][bExitY] = -11.0787; BizzInfo[idd][bExitZ] = 1001.85;
  231. }
  232. case 15: format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Sbiz`) VALUES ('%f', '%f', '%f', '0', '0', '0', '%d', '%d', '%d', '1', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  233. case 16: format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Sbiz`) VALUES ('%f', '%f', '%f', '0', '0', '0', '%d', '%d', '%d', '1', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
  234. }
  235. mysql_tquery(SQL, query, "", "");
  236. format(query, sizeof(query), "UPDATE `bizz` SET `Virtual`='%d' WHERE `ID`='%d'", idd, idd);
  237. mysql_tquery(SQL, query, "", "");
  238.  
  239. BizzInfo[idd][bEntranceX] = Pos[0];
  240. BizzInfo[idd][bEntranceY] = Pos[1];
  241. BizzInfo[idd][bEntranceZ] = Pos[2];
  242. BizzInfo[idd][bBuyPrice] = value;
  243. BizzInfo[idd][bLevelNeeded] = level;
  244. BizzInfo[idd][bVirtual] = idd;
  245. BizzInfo[idd][bType] = type;
  246. BizzInfo[idd][bInterior] = BizInteriorID(type);
  247. if(type >= 12 && type != 14) BizzInfo[idd][bSbiz] = 1;
  248.  
  249. new PropertyString[256];
  250. DestroyDynamic3DTextLabel(BizzLabel[idd]);
  251. format(PropertyString, sizeof(PropertyString),"{023d00}%s \n{EEEEEE}Business {023d00}#%d \n{0068CF}This Business is for sale(/buybusiness) ! \n {EEEEEE}Price: {023d00}%s \n{EEEEEE}Level: {023d00}%d %s",BizzInfo[idd][bMessage],idd,FormatNumber(BizzInfo[idd][bBuyPrice]),BizzInfo[idd][bLevelNeeded]);
  252. BizzLabel[idd] = CreateDynamic3DTextLabel(PropertyString ,0x0066FFCC,BizzInfo[idd][bEntranceX], BizzInfo[idd][bEntranceY], BizzInfo[idd][bEntranceZ],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0);
  253. CreateDynamicPickup(1239, 1, BizzInfo[idd][bEntranceX], BizzInfo[idd][bEntranceY], BizzInfo[idd][bEntranceZ]);
  254. pickups++;
  255. bussines++;
  256.  
  257. if(BizzInfo[idd][bType] == 1) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],52,0,-1,-1,-1,750.0); //Bank
  258. if(BizzInfo[idd][bType] == 2) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],18,0,-1,-1,-1,750.0); //GunShop
  259. if(BizzInfo[idd][bType] == 3) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],49,0,-1,-1,-1,750.0); //Bars
  260. if(BizzInfo[idd][bType] == 4) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],38,0,-1,-1,-1,750.0); //Sex Shop
  261. if(BizzInfo[idd][bType] == 5) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],25,0,-1,-1,-1,750.0); //Casino
  262. if(BizzInfo[idd][bType] == 6) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],17,0,-1,-1,-1,750.0); //24/7
  263. if(BizzInfo[idd][bType] == 7) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],10,0,-1,-1,-1,750.0); //Burger Shot
  264. if(BizzInfo[idd][bType] == 8) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],54,0,-1,-1,-1,750.0); //Gym
  265. if(BizzInfo[idd][bType] == 9) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],29,0,-1,-1,-1,750.0); //Pizza
  266. if(BizzInfo[idd][bType] == 10) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],51,0,-1,-1,-1,750.0); //Rent Car
  267. if(BizzInfo[idd][bType] == 11) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],45,0,-1,-1,-1,750.0); //Clothes
  268. if(BizzInfo[idd][bType] == 12) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],27,0,-1,-1,-1,750.0); //Gas Station
  269. if(BizzInfo[idd][bType] == 13) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],63,0,-1,-1,-1,750.0); //PNS
  270. if(BizzInfo[idd][bType] == 14) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],14,0,-1,-1,-1,750.0); //Cluckin Bell
  271.  
  272. new string[128];
  273. format(string, sizeof(string), "[@@ %d @@]%f, %f, %f, [$%s, %d lvl, %d int, %d type]", idd, Pos[0], Pos[1], Pos[2], FormatNumber(value), level, BizInteriorID(type), type);
  274. SCM(playerid, COLOR_YELLOW, string);
  275. return 1;
  276. }
  277.  
  278. function BizInteriorID(type) {
  279. new x;
  280. switch(type) {
  281. case 1: x = 0;
  282. case 2: x = 7;
  283. case 3: x = 1;
  284. case 4: x = 3;
  285. case 5: x = 10;
  286. case 6: x = 18;
  287. case 7: x = 10;
  288. case 8: x = 5;
  289. case 9: x = 5;
  290. case 11: x = 15;
  291. case 12..13: x = 0;
  292. case 15..16: x = 0;
  293. case 14: x = 9;
  294. }
  295. return x;
  296. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!