Wysłany: 2017-12-17, 17:47
kajetan254 Wiek: 28 3184 dni Nick w MP: Kajetan
Piwa 93
Witam ,Premium nie dzia?a
Ostatnio zmieniony przez kajetan254 2017-12-17, 21:57, w całości zmieniany 1 raz
Wysłany: 2017-12-17, 18:11
STOPseba Emeryt na scenie MTA Wiek: 25 3771 dni Nick w MP: STOPseba
Piwa 5014
Mo?e podasz kod ? Poniewa? nikt tu nie bazuje tylko na jednej pacz? skrypt?w
Wysłany: 2017-12-17, 21:57
kajetan254 Wiek: 28 3184 dni Nick w MP: Kajetan
Piwa 93
function loadPlayerData ( plr )
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE id=?" , getElementData ( plr , "player:uid" ))
if result and #result > 0 then
local v = result [ 1 ]
setPlayerMoney ( plr , v . money )
setElementModel ( plr , v . skin )
setElementData ( plr , "status" , "Aktywny" )
setElementData ( plr , "user:nickname" , v . login1 )
setElementData ( plr , "player:logged" , true )
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:reputation" , v . reputation )
setElementData ( plr , "player:workinjob" , v . worker )
setElementData ( plr , "player:registerdate" , v . registered )
setElementData ( plr , "player:hours" , v . hours )
setElementData ( plr , "nanky:x" , v . nankyx )
setElementData ( plr , "nanky:y" , v . nankyy )
setElementData ( plr , "nanky:z" , v . nankyz )
local queryA = string . format ( "SELECT * FROM ogrpg_users WHERE id=%d AND premiumdate>NOW() LIMIT 1" , getElementData ( plr , "player:uid" ))
local resultA = exports [ "ogrpg-db" ]: pobierzWyniki ( queryA )
if ( resultA ) then
setElementData ( plr , "player:premium" , true )
setElementData ( plr , "player:premiumdate" , v . premiumdate )
setPlayerName ( plr , "#FFBF00" .. getPlayerName ( plr ))
else
setElementData ( plr , "player:premium" , false )
end
setElementData ( plr , "player:skin" , v . skin )
local org = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_organizations WHERE uid=? LIMIT 1" , getElementData ( plr , "player:uid" )) -- pobieramy tylko JEDEN rekord
if org and #org > 0 then
setElementData ( plr , "player:organization" , org [ 1 ]. code )
exports [ 'ogrpg-db' ]: dbSet ( "UPDATE ogrpg_organizations SET actived=curdate() WHERE uid=?" , getElementData ( plr , "player:uid" ))
end
return true
end
return false
end
function savePlayerData ( plr )
local uid = getElementData ( plr , "player:uid" )
if not uid 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 reputation = getElementData ( plr , "player:reputation" )
local minuty = getElementData ( plr , "player:hours" )
local minutyduty = getElementData ( plr , "player:workinjob" )
local x , y , z = getElementPosition ( plr )
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET money=?, reputation=?, mandate=?, pjA=?, pjB=?, pjC=?, pjL=?, hours=?, worker=?, nankyx=?, nankyy=?, nankyz=? WHERE id=?" , money , reputation , mandate , licensea , licenseb , licensec , licensel , minuty , minutyduty , x , y , z , uid )
end
addEventHandler ( "onPlayerQuit" , root , function() savePlayerData ( source ) end )
addEvent ( "antyLost" , true )
addEventHandler ( "antyLost" , root , function()
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE id=?" , getElementData ( client , "player:uid" ))
if result [ 1 ]. login2 == false then
setPlayerName ( client , result [ 1 ]. login )
else
setPlayerName ( client , result [ 1 ]. login2 )
end
loadPlayerData ( client )
end )
Wysłany: 2017-12-18, 19:00
STOPseba Emeryt na scenie MTA Wiek: 25 3771 dni Nick w MP: STOPseba
Piwa 5014
Spraw w ten spos?b Ja tak mia?em i mi wszystko ?adnie dzia?a?o
function loadPlayerData ( plr )
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE id=?" , getElementData ( plr , "player:uid" ))
if result and #result > 0 then
local v = result [ 1 ]
setPlayerMoney ( plr , v . money )
setElementModel ( plr , v . skin )
setElementData ( plr , "status" , "Aktywny" )
setElementData ( plr , "user:nickname" , v . login1 )
setElementData ( plr , "player:logged" , true )
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:reputation" , v . reputation )
setElementData ( plr , "player:workinjob" , v . worker )
setElementData ( plr , "player:registerdate" , v . registered )
setElementData ( plr , "player:hours" , v . hours )
setElementData ( plr , "nanky:x" , v . nankyx )
setElementData ( plr , "nanky:y" , v . nankyy )
setElementData ( plr , "nanky:z" , v . nankyz )
local resultA = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE id=? AND premiumdate>NOW() LIMIT 1" , getElementData ( plr , "player:uid" ))
if ( resultA and #resultA > 0) then
setElementData ( plr , "player:premium" , true )
setElementData ( plr , "player:premiumdate" , v . premiumdate )
setPlayerName ( plr , "#dbb234" .. getPlayerName ( plr ))
else
setElementData ( plr , "player:premium" , false )
setPlayerName ( plr , getPlayerName ( plr ): gsub ( "#%x%x%x%x%x%x" , "" ))
end
setElementData ( plr , "player:skin" , v . skin )
local org = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_organizations WHERE uid=? LIMIT 1" , getElementData ( plr , "player:uid" )) -- pobieramy tylko JEDEN rekord
if org and #org > 0 then
setElementData ( plr , "player:organization" , org [ 1 ]. code )
exports [ 'ogrpg-db' ]: dbSet ( "UPDATE ogrpg_organizations SET actived=curdate() WHERE uid=?" , getElementData ( plr , "player:uid" ))
end
return true
end
return false
end
function savePlayerData ( plr )
local uid = getElementData ( plr , "player:uid" )
if not uid 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 reputation = getElementData ( plr , "player:reputation" )
local minuty = getElementData ( plr , "player:hours" )
local minutyduty = getElementData ( plr , "player:workinjob" )
local x , y , z = getElementPosition ( plr )
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET money=?, reputation=?, mandate=?, pjA=?, pjB=?, pjC=?, pjL=?, hours=?, worker=?, nankyx=?, nankyy=?, nankyz=? WHERE id=?" , money , reputation , mandate , licensea , licenseb , licensec , licensel , minuty , minutyduty , x , y , z , uid )
end
addEventHandler ( "onPlayerQuit" , root , function() savePlayerData ( source ) end )
addEvent ( "antyLost" , true )
addEventHandler ( "antyLost" , root , function()
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE id=?" , getElementData ( client , "player:uid" ))
if result [ 1 ]. login2 == false then
setPlayerName ( client , result [ 1 ]. login )
else
setPlayerName ( client , result [ 1 ]. login2 )
end
loadPlayerData ( client )
end )
Więcej szczegółów Wystawiono 1 piw(a):kajetan254
Wysłany: 2017-12-19, 17:36
kajetan254 Wiek: 28 3184 dni Nick w MP: Kajetan
Piwa 93
"STOPseba" napisał/a :Spraw w ten spos?b Ja tak mia?em i mi wszystko ?adnie dzia?a?o
function loadPlayerData ( plr )
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE id=?" , getElementData ( plr , "player:uid" ))
if result and #result > 0 then
local v = result [ 1 ]
setPlayerMoney ( plr , v . money )
setElementModel ( plr , v . skin )
setElementData ( plr , "status" , "Aktywny" )
setElementData ( plr , "user:nickname" , v . login1 )
setElementData ( plr , "player:logged" , true )
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:reputation" , v . reputation )
setElementData ( plr , "player:workinjob" , v . worker )
setElementData ( plr , "player:registerdate" , v . registered )
setElementData ( plr , "player:hours" , v . hours )
setElementData ( plr , "nanky:x" , v . nankyx )
setElementData ( plr , "nanky:y" , v . nankyy )
setElementData ( plr , "nanky:z" , v . nankyz )
local resultA = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE id=? AND premiumdate>NOW() LIMIT 1" , getElementData ( plr , "player:uid" ))
if ( resultA and #resultA > 0) then
setElementData ( plr , "player:premium" , true )
setElementData ( plr , "player:premiumdate" , v . premiumdate )
setPlayerName ( plr , "#dbb234" .. getPlayerName ( plr ))
else
setElementData ( plr , "player:premium" , false )
setPlayerName ( plr , getPlayerName ( plr ): gsub ( "#%x%x%x%x%x%x" , "" ))
end
setElementData ( plr , "player:skin" , v . skin )
local org = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_organizations WHERE uid=? LIMIT 1" , getElementData ( plr , "player:uid" )) -- pobieramy tylko JEDEN rekord
if org and #org > 0 then
setElementData ( plr , "player:organization" , org [ 1 ]. code )
exports [ 'ogrpg-db' ]: dbSet ( "UPDATE ogrpg_organizations SET actived=curdate() WHERE uid=?" , getElementData ( plr , "player:uid" ))
end
return true
end
return false
end
function savePlayerData ( plr )
local uid = getElementData ( plr , "player:uid" )
if not uid 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 reputation = getElementData ( plr , "player:reputation" )
local minuty = getElementData ( plr , "player:hours" )
local minutyduty = getElementData ( plr , "player:workinjob" )
local x , y , z = getElementPosition ( plr )
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET money=?, reputation=?, mandate=?, pjA=?, pjB=?, pjC=?, pjL=?, hours=?, worker=?, nankyx=?, nankyy=?, nankyz=? WHERE id=?" , money , reputation , mandate , licensea , licenseb , licensec , licensel , minuty , minutyduty , x , y , z , uid )
end
addEventHandler ( "onPlayerQuit" , root , function() savePlayerData ( source ) end )
addEvent ( "antyLost" , true )
addEventHandler ( "antyLost" , root , function()
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE id=?" , getElementData ( client , "player:uid" ))
if result [ 1 ]. login2 == false then
setPlayerName ( client , result [ 1 ]. login )
else
setPlayerName ( client , result [ 1 ]. login2 )
end
loadPlayerData ( client )
end )
Tagi: premium
Anonymous 245 dni
Anonymous Koniecznie zajrzyj na:
Piwa: 93
