--[[
Resource: OURGame v2
Developers: Split <split.programista@gmail.com>
You have no right to use this code without my permission.
(c) 2015 <split.programista@gmail.com>. All rights reserved.
]]
function getPremium(plr,premium)
if premium then
local result=exports["pystories-db"]:dbGet("SELECT * FROM pystories_users WHERE id=? AND premium=?",getElementData(plr,"player:sid"), premium)
if result and #result > 0 then
return true
else
return false
end
else
local result=exports["pystories-db"]:dbGet("SELECT * FROM pystories_users WHERE id=?", getElementData(plr,"player:sid"))
if result and #result > 0 then
return true
else
return false
end
end
end
function getGold(plr,gold)
if gold then
local result=exports["pystories-db"]:dbGet("SELECT * FROM pystories_users WHERE id=? AND gold=?",getElementData(plr,"player:sid"), gold)
if result and #result > 0 then
return true
else
return false
end
else
local result=exports["pystories-db"]:dbGet("SELECT * FROM pystories_users WHERE id=?", getElementData(plr,"player:sid"))
if result and #result > 0 then
return true
else
return false
end
end
end
function loadPlayerData(plr)
local result=exports["pystories-db"]:dbGet("SELECT * FROM pystories_users WHERE id=?", getElementData(plr,"player:sid"))
if result and #result > 0 then
local v=result[1]
setPlayerMoney(plr,v.money)
setElementModel(plr,v.skin)
setElementData(plr,"status","Aktywny")
local org=exports["pystories-db"]:dbGet("SELECT * FROM ms_organizacje WHERE uid=? LIMIT 1", getElementData(plr,"player:sid")) -- pobieramy tylko JEDEN rekord
local name = getPlayerName(plr):gsub("#%x%x%x%x%x%x","")
if org and #org > 0 then
setElementData(plr,"player:organization",org[1].code)
outputChatBox("* Jeste? w organizacji, kt?ra nosi nazwe: "..org[1].code.."", plr)
exports['pystories-db']:dbSet("UPDATE ms_organizacje SET actived=curdate() WHERE uid=?", getElementData(plr,"player:sid"))
end
setElementData(plr,"player:mandate",v.mandate)
setElementData(plr,"player:license:pjA",v.pjA)
setElementData(plr,"player:license:pjB",v.pjB)
setElementData(plr,"player:license:pjC",v.pjC)
setElementData(plr,"player:license:pjL",v.pjL)
setElementData(plr,"player:srp",v.srp)
setElementData(plr,"player:workinjob",v.worker)
setElementData(plr,"player:registerdate",v.registered)
setElementData(plr,"player:hours",v.hours)
setElementData(plr,"player:skin",v.skin)
setElementData(plr,"topy",v.topy)
setElementData(plr,"player:nickname", v.login)
setElementData(plr,"player:listy_kursy", v.listonosz)
setElementData(plr,"player:lawety", v.lawetki)
setElementData(plr,"player:lawetkisrp", v.lawetkisrp)
setElementData(plr,"player:lawetkimoney", v.lawetkimoney)
setElementData(plr,"player:airtransport", v.airtransport)
setElementData(plr,"player:airtransportsrp", v.airtransportsrp)
setElementData(plr,"player:airtransportmoney", v.airtransportmoney)
setElementData(plr,"player:mask", v.mask)
setElementData(plr, 'player:mask:putoff', true)
local resultA=exports["pystories-db"]:dbGet("SELECT * FROM pystories_users WHERE id=? AND golddate>NOW() LIMIT 1", getElementData(plr,"player:sid"))
if (resultA and #resultA > 0) then
setElementData(plr,"player:gold",true)
setElementData(plr,"player:golddate",v.golddate)
setPlayerName(plr,"#e79534"..getPlayerName(plr))
setPlayerNametagColor(plr, 231, 149, 52)
setElementData(plr,"gold:level",1)
else
setElementData(plr,"player:gold",false)
setPlayerName(plr,"#ffcc00"..getPlayerName(plr))
end
setElementData(plr,"player:premium",true)
setElementData(plr,"player:premiumdate","2030-01-01")
setElementData(plr,"premium:level",1)
if not getElementData(plr, "player:gold") then
setPlayerName(plr,"#ffcc00"..getPlayerName(plr))
setPlayerNametagColor(plr, 255, 200, 0)
end
local bron = exports["pystories-db"]:dbGet("SELECT * FROM `bronie` WHERE `owner` = ?", getElementData(plr, "player:sid"))
if #bron > 0 then
for i, v in ipairs(bron) do
giveWeapon(plr, v.weapon, 500000)
end
end
local mute = exports['pystories-db']:dbGet('select * from n_mute where serial=? AND time>now()',getPlayerSerial(plr))
if #mute > 0 then
setElementData(plr,'player:mute',true)
outputChatBox('Jeste? wyciszony do: '..mute[1].time,plr)
else
exports['pystories-db']:dbSet('delete from n_mute where serial=?',getPlayerSerial(plr))
end
local mask = exports['pystories-db']:dbGet('SELECT * FROM pystories_users WHERE mask= ?', getElementData(plr, 'player:sid'))
if #mask > 0 then
outputChatBox('* Posiadasz mask? antybakteryjn?, aby j? za?o?y? wpisz /maska-zaloz', plr, 255, 255, 255, true)
else
outputChatBox('* Na serwerze potrzebujesz mie? maske antybakteryjn?, inaczej mo?esz zosta? ukarany mandatem, aby j? zakupi? - udaj si? do sklepu po zakup. (BLIP KOSZYKA)', plr, 255, 255, 255, true)
end
return true
end
return false
end
addEvent("load:player",true)
addEventHandler("load:player", root, function(player)
if isElement(player) and player then
if getElementType(player) ~= "player" then return end
loadPlayerData(player)
outputDebugString("pystories_users> Za?adowano statystyki gracza: "..getPlayerName(player))
end
end)
function savePlayerData(plr)
local sid=getElementData(plr,"player:sid")
if not sid then return end
local money=getPlayerMoney(plr)
local mandate=getElementData(plr,"player:mandate")
local licensea=getElementData(plr,"player:license:pjA")
local licenseb=getElementData(plr,"player:license:pjB")
local licensec=getElementData(plr,"player:license:pjC")
local licensel=getElementData(plr,"player:license:pjL")
local srp=getElementData(plr,"player:srp")
local worker =getElementData(plr,"player:workinjob")
local hours= tonumber(getElementData(plr,"player:hours")) or 0
local topy = getElementData(plr, "topy") or 0
local lawety = getElementData(plr, "player:lawety") or 0
local lawetkisrp = getElementData(plr, "player:lawetkisrp") or 0
local lawetkimoney = getElementData(plr, "player:lawetkimoney") or 0
local airtransport = getElementData(plr, "player:airtransport") or 0
local airtransportsrp = getElementData(plr, "player:airtransportsrp") or 0
local airtransportmoney = getElementData(plr, "player:airtransportmoney") or 0
local listonosze = getElementData(plr, "player:listy_kursy") or 0
local mask = getElementData(plr, 'player:mask') or 0
local x, y, z = getElementPosition(plr)
local pozycja = x..","..y..","..z
local query=exports["pystories-db"]:dbSet("UPDATE pystories_users SET money=?, srp=?, mandate=?, mask=?, pjA=?, pjB=?, pjC=?, pjL=?, worker=?, hours=?, topy=?, position=?, listonosz = ?, lawetki = ? , lawetkisrp = ?, lawetkimoney = ?, airtransport = ?, airtransportsrp = ?, airtransportmoney = ? WHERE id=?",
money, srp, mandate, mask,licensea, licenseb, licensec, licensel, worker, hours, topy, pozycja, listonosze, lawety, lawetkisrp, lawetkimoney, airtransport, airtransportsrp, airtransportmoney, sid)
end
addEvent("save:player",true)
addEventHandler("save:player", root, function(player)
if isElement(player) and player then
if getElementType(player) ~= "player" then return end
savePlayerData(player)
outputDebugString("pystories_users> Zapisano statystyki gracza: "..getPlayerName(player))
end
end)
addEventHandler("onPlayerQuit", root, function() savePlayerData(source) end)
Piwa: 1
