Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [MySQL] [ERROR] [zombieoutbreak] An error happens for query "SELECT ID FROM users WHERE Identifier = ? : ["license:////////////////////////////////"]": ER_BAD_DB_ERROR: Unknown database 'es_extended.crafting'
- SCRIPT ERROR: [string "Load("Server/Events.lua")..."]:25: attempt to index a nil value (local 'Result')
- > CB (oad("Server/Events.lua")
- function Player(Source)
- local self = {}
- self.Source = Source
- self.Identifier = function()
- local Identifier
- for k, v in ipairs(GetPlayerIdentifiers(self.Source)) do
- if string.match(v, GlobalConfig.Identifier) then
- Identifier = v
- return Identifier
- end
- end
- end
- self.Exists = function()
- local Identifier = self.Identifier()
- local Data
- Database.ExecuteSelectQuery("SELECT ID FROM users WHERE Identifier = @Identifier", {
- ["@Identifier"] = Identifier
- }, function(Result)
- if (Result[1] ~= nil) then
- Data = true
- else
- Data = false
- end
- end)
- while Data == nil do Wait(0) end
- return Data
- end
- self.GetIdentity = function()
- local Identifier = self.Identifier()
- local Data
- Database.ExecuteSelectQuery("SELECT Name, `Date Of Birth`, Sex, Occupation FROM users WHERE Identifier = @Identifier", {
- ["@Identifier"] = Identifier
- }, function(Result)
- Data = Result[1]
- end)
- while Data == nil do Wait(0) end
- return Data
- end
- self.GetName = function()
- local Identifier = self.Identifier()
- local Data
- Database.ExecuteSelectQuery("SELECT Name FROM users WHERE Identifier = @Identifier", {
- ["@Identifier"] = Identifier
- }, function(Result)
- Data = Result[1]["Name"]
- end)
- while Data == nil do Wait(0) end
- return Data
- end
- self.GetSex = function()
- local Identifier = self.Identifier()
- local Data
- Database.ExecuteSelectQuery("SELECT Sex FROM users WHERE Identifier = @Identifier", {
- ["@Identifier"] = Identifier
- }, function(Result)
- Data = Result[1]["Sex"]
- end)
- while Data == nil do Wait(0) end
- return Data
- end
- self.GetGroup = function()
- local Identifier = self.Identifier()
- local Data
- Database.ExecuteSelectQuery("SELECT `Group` FROM users WHERE Identifier = @Identifier", {
- ["@Identifier"] = Identifier
- }, function(Result)
- Data = Result[1]["Group"]
- end)
- while Data == nil do Wait(0) end
- return Data
- end
- self.GetOccupation = function()
- local Identifier = self.Identifier()
- local Data
- Database.ExecuteSelectQuery("SELECT Occupation FROM users WHERE Identifier = @Identifier", {
- ["@Identifier"] = Identifier
- }, function(Result)
- Data = Result[1]["Occupation"]
- end)
- while Data == nil do Wait(0) end
- return Data
- end
- self.GetInventory = function()
- local Identifier = self.Identifier()
- local Data
- Database.ExecuteSelectQuery("SELECT Inventory FROM users WHERE Identifier = @Identifier", {
- ["@Identifier"] = Identifier
- }, function(Result)
- Data = Result[1]["Inventory"]
- end)
- while Data == nil do Wait(0) end
- local PlayerInventory = json.decode(Data)
- Inventory.RedefineItems(PlayerInventory)
- return PlayerInventory
- end
- self.GetSkin = function()
- local Identifier = self.Identifier()
- local Data
- Database.ExecuteSelectQuery("SELECT Skin FROM users WHERE Identifier = @Identifier", {
- ["@Identifier"] = Identifier
- }, function(Result)
- Data = Result[1]["Skin"]
- end)
- while Data == nil do Wait(0) end
- local PlayerSkin = json.decode(Data)
- return PlayerSkin
- end
- self.AddItem = function(Name, Count)
- if Inventory.PreventItem(Inventory.Items, Name) or Inventory.PreventItem(Inventory.Clothes, Name) then
- local PlayerInventory = Inventory.GetPlayerItems(self.Source)
- local Found = false
- for i in pairs(PlayerInventory) do
- if i == Name then
- PlayerInventory[i] = PlayerInventory[i] + Count
- Found = true
- break
- end
- end
- if not Found then
- PlayerInventory[Name] = Count
- end
- Inventory.Update(self.Source, PlayerInventory)
- else
- print("[Warning]Item [".. Name .."] doesn't exists in database")
- end
- end
- self.RemoveItem = function(Name, Count)
- if Inventory.PreventItem(Inventory.Items, Name) or Inventory.PreventItem(Inventory.Clothes, Name) then
- local PlayerInventory = Inventory.GetPlayerItems(self.Source)
- for i in pairs(PlayerInventory) do
- if i == Name then
- PlayerInventory[i] = PlayerInventory[i] - Count
- break
- end
- end
- if PlayerInventory[Name] < 1 then
- PlayerInventory[Name] = nil
- end
- Inventory.Update(self.Source, PlayerInventory)
- else
- print("[Warning]Item [".. Name .."] doesn't exists in database")
- end
- end
- self.CanCarryItem = function(Name, Count)
- if Inventory.PreventItem(Inventory.Items, Name) or Inventory.PreventItem(Inventory.Clothes, Name) then
- local PlayerInventory = self.GetInventory()
- local Found = false
- for i in pairs(PlayerInventory) do
- if i == Name then
- Found = true
- if PlayerInventory[i].Limit >= (PlayerInventory[i].Count + Count) then
- return true
- end
- end
- end
- if not Found then
- return true
- end
- return false
- else
- print("[Warning]Item [".. Name .."] doesn't exists in database")
- end
- end
- self.HasItem = function(Name)
- if Inventory.PreventItem(Inventory.Items, Name) or Inventory.PreventItem(Inventory.Clothes, Name) then
- local PlayerInventory = Inventory.GetPlayerItems(self.Source)
- for i in pairs(PlayerInventory) do
- if i == Name then
- return true, PlayerInventory[i]
- end
- end
- else
- print("[Warning]^Item [".. Name .."] doesn't exists in database")
- end
- return false, 0
- end
- self.AddWeapon = function(Name, Ammo, Components, Tint)
- if Inventory.PreventItem(Inventory.Weapons, Name) then
- Ammo = Ammo or 0
- Components = Components or nil
- Tint = Tint or 0
- local PlayerInventory = Inventory.GetPlayerItems(self.Source)
- local Found = false
- for i in pairs(PlayerInventory) do
- if i == Name then
- PlayerInventory[Name]["Ammo"] = Ammo
- PlayerInventory[Name]["Components"] = Components
- PlayerInventory[Name]["Tint"] = Tint
- Found = true
- break
- end
- end
- if not Found then
- PlayerInventory[Name] = {}
- PlayerInventory[Name]["Ammo"] = Ammo
- PlayerInventory[Name]["Components"] = Components
- PlayerInventory[Name]["Tint"] = Tint
- end
- Inventory.Update(self.Source, PlayerInventory)
- else
- print("[Warning]Weapon [".. Name .."] doesn't exists in database")
- end
- end
- self.RemoveWeapon = function(Name)
- if Inventory.PreventItem(Inventory.Weapons, Name) then
- local PlayerInventory = Inventory.GetPlayerItems(self.Source)
- for i in pairs(PlayerInventory) do
- if i == Name then
- PlayerInventory[i] = nil
- break
- end
- end
- Inventory.Update(self.Source, PlayerInventory)
- else
- print("[Warning]Weapon [".. Name .."] doesn't exists in database")
- end
- end
- self.AddWeaponAmmo = function(Name, Ammo)
- if Inventory.PreventItem(Inventory.Weapons, Name) then
- local PlayerInventory = Inventory.GetPlayerItems(self.Source)
- for i in pairs(PlayerInventory) do
- if i == Name then
- PlayerInventory[Name]["Ammo"] = PlayerInventory[Name]["Ammo"] + Ammo
- break
- end
- end
- Inventory.Update(self.Source, PlayerInventory)
- else
- print("[Warning]Weapon [".. Name .."] doesn't exists in database")
- end
- end
- self.RemoveWeaponAmmo = function(Name, Ammo)
- if Inventory.PreventItem(Inventory.Weapons, Name) then
- local PlayerInventory = Inventory.GetPlayerItems(self.Source)
- for i in pairs(PlayerInventory) do
- if i == Name then
- PlayerInventory[Name]["Ammo"] = PlayerInventory[Name]["Ammo"] - Ammo
- break
- end
- end
- Inventory.Update(self.Source, PlayerInventory)
- else
- print("[Warning]Weapon [".. Name .."] doesn't exists in database")
- end
- end
- self.HasWeapon = function(Name)
- if Inventory.PreventItem(Inventory.Weapons, Name) then
- local PlayerInventory = Inventory.GetPlayerItems(self.Source)
- for i in pairs(PlayerInventory) do
- if i == Name then
- return true
- end
- end
- else
- print("[Warning]^Weapon [".. Name .."] doesn't exists in database")
- end
- return false
- end
- self.CurrentWeight = function()
- local Weight = 0.0
- local PlayerInventory = self.GetInventory()
- for i in pairs(PlayerInventory) do
- if PlayerInventory[i].Type == "Item" then
- Weight = (Weight + (PlayerInventory[i].Weight * PlayerInventory[i].Count))
- elseif PlayerInventory[i].Type == "Weapon" then
- Weight = (Weight + PlayerInventory[i].Weight)
- end
- end
- return Weight
- end
- self.ShowNotification = function(Message)
- TriggerClientEvent("Player:ShowNotification", self.Source, Message)
- end
- return self
- end:25)
- > ref (@zombieoutbreak/Root/Server/Functions.lua:19)
- > (@mysql-async/mysql-async.js:15543)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement