--[[
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 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")
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:license:Strzelanie", v.licS)
setElementData(plr,"player:registerdate",v.registered)
setElementData(plr,"player:hours",v.hours)
setElementData(plr,"player:skin",v.skin)
setElementData(plr,"player:nickname", v.login)
setElementData(plr,"bank:karta", v.karta_bank)
setElementData(plr,"player:praca:sv", v.pkt_sv)
setElementData(plr,"player:praca:magazynier", v.paczki_magazynier)
setElementData(plr,"hud:enabled", true)
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
-- premium+
local queryA=string.format("SELECT * FROM pystories_users WHERE id=%d AND premiumplusdate>NOW() LIMIT 1", getElementData(plr,"player:sid"))
local resultA=exports["DB2"]:pobierzWyniki(queryA)
if (resultA) then
setElementData(plr,"player:premiumplus",true)
setElementData(plr,"player:premiumdateplus",v.premiumplusdate)
setPlayerName(plr,"#ff6600"..getPlayerName(plr))
setPlayerNametagColor(plr, 255, 200, 0)
setElementData(plr,"premium:level",2)
else
setElementData(plr,"player:premiumplus",false)
end
-- premium
local queryA=string.format("SELECT * FROM pystories_users WHERE id=%d AND premiumdate>NOW() LIMIT 1", getElementData(plr,"player:sid"))
local resultA=exports["DB2"]:pobierzWyniki(queryA)
if (resultA) then
setElementData(plr,"player:premium",true)
setElementData(plr,"player:premiumdate",v.premiumdate)
setPlayerName(plr,"#ffcc00"..getPlayerName(plr))
setPlayerNametagColor(plr, 255, 200, 0)
setElementData(plr,"premium:level",1)
else
setElementData(plr,"player:premium",false)
end
-- biznesy
local biznes1=exports["pystories-db"]:dbGet("SELECT * FROM biznesy WHERE owner=? LIMIT 1", getElementData(plr,"player:sid"))
if (biznes1 and #biznes1 > 0) then
setElementData(plr,"player:biznes",true)
setElementData(plr,"player:biznesnazwa",biznes1[1].nazwa)
else
setElementData(plr,"player:biznes",false)
setElementData(plr,"player:biznesnazwa","")
end
local org=exports["pystories-db"]:dbGet("SELECT * FROM ms_organizacje WHERE code=? AND uid=? LIMIT 1", getElementData(plr,"player:organization"), 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
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 query=exports["pystories-db"]:dbSet("UPDATE pystories_users SET money=?, srp=?, mandate=?, pjA=?, pjB=?, pjC=?, pjL=?, worker=?, hours=? WHERE id=?",
money, srp, mandate, licensea, licenseb, licensec, licensel, worker, hours, 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)
str="Ranking\nTOP REP:"
local t=createElement("text")
setElementData(t,"scale",1)
setElementPosition(t,1472.50, -1717.51, 14.05+1.1)
function toprep()
local result=exports["pystories-db"]:dbGet("SELECT * from pystories_users ORDER BY srp DESC LIMIT 15")
str="Ranking TOP 15\nReputacji:\n"
for i,v in ipairs(result) do
if v["login2"] == false then
str=""..str.."\n"..i..". "..v["login"].." - "..v["srp"].." REP"
else
str=""..str.."\n"..i..". "..v["login2"].." - "..v["srp"].." REP"
end
end
setElementData(t, "name", str)
end
setTimer(toprep, 10000, 0)
toprep()
str="Ranking\nTOP REP:"
local t=createElement("text")
setElementData(t,"scale",1)
setElementPosition(t,1469.62, -1717.49, 14.05+1.1)
function toprep()
local result=exports["pystories-db"]:dbGet("SELECT * from pystories_users ORDER BY bank_money DESC LIMIT 15")
str="Ranking TOP 15\nPieniedzy w bankomacie:\n"
for i,v in ipairs(result) do
if v["login2"] == false then
str=""..str.."\n"..i..". "..v["login"].." - "..v["bank_money"].." $"
else
str=""..str.."\n"..i..". "..v["login2"].." - "..v["bank_money"].." $"
end
end
setElementData(t, "name", str)
end
setTimer(toprep, 10000, 0)
toprep()
str="Ranking\nTOP REP:"
local t=createElement("text")
setElementData(t,"scale",1)
setElementPosition(t,1466.70, -1717.51, 14.05+1.1)
function toprep()
local result=exports["pystories-db"]:dbGet("SELECT * from pystories_users ORDER BY hours DESC LIMIT 15")
str="Ranking TOP 15\nSpedzonego Czasu:\n"
for i,v in ipairs(result) do
if v["login2"] == false then
str=""..str.."\n"..i..". "..v["login"].." - "..v["hours"].." min"
else
str=""..str.."\n"..i..". "..v["login2"].." - "..v["hours"].." min"
end
end
setElementData(t, "name", str)
end
setTimer(toprep, 10000, 0)
toprep()
Piwa: 739
