Advertisement
stevelolp

Untitled

Dec 28th, 2020 (edited)
36
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.90 KB | None | 0 0
  1. [MySQL] [ERROR] [zombieoutbreak] An error happens for query "SELECT ID FROM users WHERE Identifier = ? : ["license:////////////////////////////////"]": ER_BAD_DB_ERROR: Unknown database 'es_extended.crafting'
  2. SCRIPT ERROR: [string "Load("Server/Events.lua")..."]:25: attempt to index a nil value (local 'Result')
  3. > CB (oad("Server/Events.lua")
  4.  
  5. function Player(Source)
  6.  
  7. local self = {}
  8.  
  9. self.Source = Source
  10.  
  11. self.Identifier = function()
  12. local Identifier
  13. for k, v in ipairs(GetPlayerIdentifiers(self.Source)) do
  14. if string.match(v, GlobalConfig.Identifier) then
  15. Identifier = v
  16. return Identifier
  17. end
  18. end
  19. end
  20.  
  21. self.Exists = function()
  22. local Identifier = self.Identifier()
  23. local Data
  24. Database.ExecuteSelectQuery("SELECT ID FROM users WHERE Identifier = @Identifier", {
  25. ["@Identifier"] = Identifier
  26. }, function(Result)
  27. if (Result[1] ~= nil) then
  28. Data = true
  29. else
  30. Data = false
  31. end
  32. end)
  33. while Data == nil do Wait(0) end
  34. return Data
  35. end
  36.  
  37. self.GetIdentity = function()
  38. local Identifier = self.Identifier()
  39. local Data
  40. Database.ExecuteSelectQuery("SELECT Name, `Date Of Birth`, Sex, Occupation FROM users WHERE Identifier = @Identifier", {
  41. ["@Identifier"] = Identifier
  42. }, function(Result)
  43. Data = Result[1]
  44. end)
  45. while Data == nil do Wait(0) end
  46. return Data
  47. end
  48.  
  49. self.GetName = function()
  50. local Identifier = self.Identifier()
  51. local Data
  52. Database.ExecuteSelectQuery("SELECT Name FROM users WHERE Identifier = @Identifier", {
  53. ["@Identifier"] = Identifier
  54. }, function(Result)
  55. Data = Result[1]["Name"]
  56. end)
  57. while Data == nil do Wait(0) end
  58. return Data
  59. end
  60.  
  61. self.GetSex = function()
  62. local Identifier = self.Identifier()
  63. local Data
  64. Database.ExecuteSelectQuery("SELECT Sex FROM users WHERE Identifier = @Identifier", {
  65. ["@Identifier"] = Identifier
  66. }, function(Result)
  67. Data = Result[1]["Sex"]
  68. end)
  69. while Data == nil do Wait(0) end
  70. return Data
  71. end
  72.  
  73. self.GetGroup = function()
  74. local Identifier = self.Identifier()
  75. local Data
  76. Database.ExecuteSelectQuery("SELECT `Group` FROM users WHERE Identifier = @Identifier", {
  77. ["@Identifier"] = Identifier
  78. }, function(Result)
  79. Data = Result[1]["Group"]
  80. end)
  81. while Data == nil do Wait(0) end
  82. return Data
  83. end
  84.  
  85. self.GetOccupation = function()
  86. local Identifier = self.Identifier()
  87. local Data
  88. Database.ExecuteSelectQuery("SELECT Occupation FROM users WHERE Identifier = @Identifier", {
  89. ["@Identifier"] = Identifier
  90. }, function(Result)
  91. Data = Result[1]["Occupation"]
  92. end)
  93. while Data == nil do Wait(0) end
  94.  
  95. return Data
  96. end
  97.  
  98. self.GetInventory = function()
  99. local Identifier = self.Identifier()
  100. local Data
  101. Database.ExecuteSelectQuery("SELECT Inventory FROM users WHERE Identifier = @Identifier", {
  102. ["@Identifier"] = Identifier
  103. }, function(Result)
  104. Data = Result[1]["Inventory"]
  105. end)
  106. while Data == nil do Wait(0) end
  107. local PlayerInventory = json.decode(Data)
  108. Inventory.RedefineItems(PlayerInventory)
  109.  
  110. return PlayerInventory
  111. end
  112.  
  113. self.GetSkin = function()
  114. local Identifier = self.Identifier()
  115. local Data
  116. Database.ExecuteSelectQuery("SELECT Skin FROM users WHERE Identifier = @Identifier", {
  117. ["@Identifier"] = Identifier
  118. }, function(Result)
  119. Data = Result[1]["Skin"]
  120. end)
  121. while Data == nil do Wait(0) end
  122. local PlayerSkin = json.decode(Data)
  123.  
  124. return PlayerSkin
  125. end
  126.  
  127. self.AddItem = function(Name, Count)
  128. if Inventory.PreventItem(Inventory.Items, Name) or Inventory.PreventItem(Inventory.Clothes, Name) then
  129. local PlayerInventory = Inventory.GetPlayerItems(self.Source)
  130. local Found = false
  131. for i in pairs(PlayerInventory) do
  132. if i == Name then
  133. PlayerInventory[i] = PlayerInventory[i] + Count
  134. Found = true
  135. break
  136. end
  137. end
  138. if not Found then
  139. PlayerInventory[Name] = Count
  140. end
  141. Inventory.Update(self.Source, PlayerInventory)
  142. else
  143. print("[Warning]Item [".. Name .."] doesn't exists in database")
  144. end
  145. end
  146.  
  147. self.RemoveItem = function(Name, Count)
  148. if Inventory.PreventItem(Inventory.Items, Name) or Inventory.PreventItem(Inventory.Clothes, Name) then
  149. local PlayerInventory = Inventory.GetPlayerItems(self.Source)
  150. for i in pairs(PlayerInventory) do
  151. if i == Name then
  152. PlayerInventory[i] = PlayerInventory[i] - Count
  153. break
  154. end
  155. end
  156. if PlayerInventory[Name] < 1 then
  157. PlayerInventory[Name] = nil
  158. end
  159.  
  160. Inventory.Update(self.Source, PlayerInventory)
  161. else
  162. print("[Warning]Item [".. Name .."] doesn't exists in database")
  163. end
  164. end
  165.  
  166. self.CanCarryItem = function(Name, Count)
  167. if Inventory.PreventItem(Inventory.Items, Name) or Inventory.PreventItem(Inventory.Clothes, Name) then
  168. local PlayerInventory = self.GetInventory()
  169. local Found = false
  170. for i in pairs(PlayerInventory) do
  171. if i == Name then
  172. Found = true
  173. if PlayerInventory[i].Limit >= (PlayerInventory[i].Count + Count) then
  174. return true
  175. end
  176. end
  177. end
  178. if not Found then
  179. return true
  180. end
  181.  
  182. return false
  183. else
  184. print("[Warning]Item [".. Name .."] doesn't exists in database")
  185. end
  186. end
  187.  
  188. self.HasItem = function(Name)
  189. if Inventory.PreventItem(Inventory.Items, Name) or Inventory.PreventItem(Inventory.Clothes, Name) then
  190. local PlayerInventory = Inventory.GetPlayerItems(self.Source)
  191. for i in pairs(PlayerInventory) do
  192. if i == Name then
  193. return true, PlayerInventory[i]
  194. end
  195. end
  196. else
  197. print("[Warning]^Item [".. Name .."] doesn't exists in database")
  198. end
  199.  
  200. return false, 0
  201. end
  202.  
  203. self.AddWeapon = function(Name, Ammo, Components, Tint)
  204. if Inventory.PreventItem(Inventory.Weapons, Name) then
  205. Ammo = Ammo or 0
  206. Components = Components or nil
  207. Tint = Tint or 0
  208.  
  209. local PlayerInventory = Inventory.GetPlayerItems(self.Source)
  210. local Found = false
  211. for i in pairs(PlayerInventory) do
  212. if i == Name then
  213. PlayerInventory[Name]["Ammo"] = Ammo
  214. PlayerInventory[Name]["Components"] = Components
  215. PlayerInventory[Name]["Tint"] = Tint
  216. Found = true
  217. break
  218. end
  219. end
  220. if not Found then
  221. PlayerInventory[Name] = {}
  222. PlayerInventory[Name]["Ammo"] = Ammo
  223. PlayerInventory[Name]["Components"] = Components
  224. PlayerInventory[Name]["Tint"] = Tint
  225. end
  226.  
  227. Inventory.Update(self.Source, PlayerInventory)
  228. else
  229. print("[Warning]Weapon [".. Name .."] doesn't exists in database")
  230. end
  231. end
  232.  
  233. self.RemoveWeapon = function(Name)
  234. if Inventory.PreventItem(Inventory.Weapons, Name) then
  235.  
  236. local PlayerInventory = Inventory.GetPlayerItems(self.Source)
  237. for i in pairs(PlayerInventory) do
  238. if i == Name then
  239. PlayerInventory[i] = nil
  240. break
  241. end
  242. end
  243.  
  244. Inventory.Update(self.Source, PlayerInventory)
  245. else
  246. print("[Warning]Weapon [".. Name .."] doesn't exists in database")
  247. end
  248. end
  249.  
  250. self.AddWeaponAmmo = function(Name, Ammo)
  251. if Inventory.PreventItem(Inventory.Weapons, Name) then
  252.  
  253. local PlayerInventory = Inventory.GetPlayerItems(self.Source)
  254. for i in pairs(PlayerInventory) do
  255. if i == Name then
  256. PlayerInventory[Name]["Ammo"] = PlayerInventory[Name]["Ammo"] + Ammo
  257. break
  258. end
  259. end
  260.  
  261. Inventory.Update(self.Source, PlayerInventory)
  262. else
  263. print("[Warning]Weapon [".. Name .."] doesn't exists in database")
  264. end
  265. end
  266.  
  267. self.RemoveWeaponAmmo = function(Name, Ammo)
  268. if Inventory.PreventItem(Inventory.Weapons, Name) then
  269.  
  270. local PlayerInventory = Inventory.GetPlayerItems(self.Source)
  271. for i in pairs(PlayerInventory) do
  272. if i == Name then
  273. PlayerInventory[Name]["Ammo"] = PlayerInventory[Name]["Ammo"] - Ammo
  274. break
  275. end
  276. end
  277.  
  278. Inventory.Update(self.Source, PlayerInventory)
  279. else
  280. print("[Warning]Weapon [".. Name .."] doesn't exists in database")
  281. end
  282. end
  283.  
  284. self.HasWeapon = function(Name)
  285. if Inventory.PreventItem(Inventory.Weapons, Name) then
  286. local PlayerInventory = Inventory.GetPlayerItems(self.Source)
  287. for i in pairs(PlayerInventory) do
  288. if i == Name then
  289. return true
  290. end
  291. end
  292. else
  293. print("[Warning]^Weapon [".. Name .."] doesn't exists in database")
  294. end
  295.  
  296. return false
  297. end
  298.  
  299. self.CurrentWeight = function()
  300. local Weight = 0.0
  301. local PlayerInventory = self.GetInventory()
  302.  
  303. for i in pairs(PlayerInventory) do
  304. if PlayerInventory[i].Type == "Item" then
  305. Weight = (Weight + (PlayerInventory[i].Weight * PlayerInventory[i].Count))
  306. elseif PlayerInventory[i].Type == "Weapon" then
  307. Weight = (Weight + PlayerInventory[i].Weight)
  308. end
  309. end
  310.  
  311. return Weight
  312. end
  313.  
  314. self.ShowNotification = function(Message)
  315. TriggerClientEvent("Player:ShowNotification", self.Source, Message)
  316. end
  317.  
  318. return self
  319. end:25)
  320. > ref (@zombieoutbreak/Root/Server/Functions.lua:19)
  321. > (@mysql-async/mysql-async.js:15543)
  322.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement