Wysłany: 2018-09-08, 18:36
CinusPL Wiek: 26 2973 dni Nick w MP: CinusPL
Witam, wgra?em wszystko z IT'S YOUR WORLD na ftp a nastepnie importowalem baze danych i wszytko poszlo pomyslnie, w DB2 i ogp-db edytowalem na moje dane do mysql i po wejsciu na serwer jak klikam zarejestruj sie to jest napisane ze pomyslnie zarejestrowano ale jak dam zaloguj potem to mam ze nie ma takiego w bazie, a gdy wpisze jakis nick z bazy danych z tabelki user to pokazuje ze zle haslo wiec wydaje mi sie ze gdy robie zarejestruj te konto nie zapisuje sie w bazie danych w tym user i mam pytanie i prosbe jak to naprawic bo utkna?em na logowaniu. Dzi?kuje z g?ry za pomoc.
Wysłany: 2018-09-08, 18:43
Nexisten Moderator Wiek: 22 4248 dni Nick w MP: Nexisten
Piwa 1486
Dzia? dobry.
Wysłany: 2018-09-08, 19:52
CinusPL Wiek: 26 2973 dni Nick w MP: CinusPL
"vNeXxuS" napisał/a :Dzia? dobry.
--[[
Obsluga baz danych , interfejs do bazy MySQL realizowany za pomoca wbudowanych w MTA funkcji db ...
@ author Lukasz Biegaj < wielebny @ bestplay . pl >
@ author WUBE < wube @ lss - rp . pl >
@ copyright 2011 - 2013 Lukasz Biegaj < wielebny @ bestplay . pl >
@ license Dual GPLv2 / MIT
@ package MTA - XyzzyRP
@ link https : //github.com/lpiob/MTA-XyzzyRP GitHub
]]--
local SQL
local function connect ()
-- w ponizszej linii uzupelnij dane autoryzacji
SQL = dbConnect ( "mysql" , "dbname=db_16014;host=127.0.0.1" , "LOGINDOMYSQL" , "HASLODOMYSQL" , "share=1" )
if ( not SQL ) then
outputServerLog ( "BRAK POLACZENIA Z BAZA DANYCH!" )
else
zapytanie ( "SET NAMES utf8;" )
end
end
addEventHandler ( "onResourceStart" , resourceRoot , connect )
function pobierzTabeleWynikow (...)
local h = dbQuery ( SQL ,...)
if ( not h ) then
return nil
end
local rows = dbPoll ( h , - 1 )
return rows
end
function pobierzWyniki (...)
local h = dbQuery ( SQL ,...)
if ( not h ) then
return nil
end
local rows = dbPoll ( h , - 1 )
if not rows then return nil end
return rows [ 1 ]
end
function zapytanie (...)
local h = dbQuery ( SQL ,...)
local result , numrows = dbPoll ( h ,- 1 )
return numrows
end
--[[
function insertID ()
return mysql_insert_id ( SQL )
end
function affectedRows ()
return mysql_affected_rows ( SQL )
end
]]--
function fetchRows ( query )
local result = mysql_query ( SQL , query )
if ( not result ) then return nil end
local tabela ={}
while true do
local row = mysql_fetch_row ( result )
if ( not row ) then break end
table . insert ( tabela , row )
end
mysql_free_result ( result )
return tabela
end
--[[
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 .
]]
-- Settings
DBHandler = nil
DBName = "db_16014"
DBUser = "logindomysql"
DBPass = "haslodomysql"
DBHost = "127.0.0.1"
-- Functions
function dbSet (...)
if not {...} then return end
local stringe = dbPrepareString ( DBHandler ,...)
local query = dbExec ( DBHandler , stringe )
return query
end
function dbGet (...)
if not {...} then return end
local stringe = dbPrepareString ( DBHandler ,...)
local query = dbQuery ( DBHandler , stringe )
local result = dbPoll ( query , - 1 )
return result
end
addEventHandler ( "onResourceStart" , resourceRoot , function()
DBHandler = dbConnect ( "mysql" , "dbname=" .. DBName .. ";host=" .. DBHost .. "" , DBUser , DBPass , "share=1;autoreconnect=1" )
if DBHandler then
outputDebugString ( "* Connect to server MYSQL..." )
dbSet ( "SET NAMES utf8" )
else
outputDebugString ( "* No Connecting to server MYSQL.." )
end
end )
local SQL_LOGIN = "logindomysql"
local SQL_PASSWD = "haslodomydql"
local SQL_DB = "db_16014"
local SQL_HOST = "127.0.0.1"
local SQL_PORT = 3306
local root = getRootElement ()
local SQL
local function connect ()
SQL = mysql_connect ( SQL_HOST , SQL_LOGIN , SQL_PASSWD , SQL_DB , SQL_PORT )
if ( not SQL ) then
outputServerLog ( "BRAK POLACZENIA Z BAZA DANYCH!" )
else
-- mysql_query ( SQL , "SET NAMES utf8" )
-- outputServerLog ( "Modul mysql polaczony!" )
end
end
local function keepAlive ()
if ( not mysql_ping ( SQL )) then
outputServerLog ( "Zerwane polaczenie z baza danych, nawiazywanie..." )
connect ()
end
end
addEventHandler ( "onResourceStart" , getResourceRootElement (),function()
connect ()
setTimer ( keepAlive , 30000 , 0 )
end )
function esc ( value )
return mysql_escape_string ( SQL , value )
end
function pobierzTabeleWynikow ( query )
local result = mysql_query ( SQL , query )
if ( not result ) then
outputDebugString ( "mysql_query failed: (" .. mysql_errno ( SQL ) .. ") " .. mysql_error ( SQL ))
outputServerLog ( "mysql_query failed: (" .. mysql_errno ( SQL ) .. ") " .. mysql_error ( SQL ))
return nil
end
local tabela ={}
for result , row in mysql_rows_assoc ( result ) do
table . insert ( tabela , row )
end
mysql_free_result ( result )
return tabela
end
function pobierzWyniki ( query )
local result = mysql_query ( SQL , query )
if ( not result ) then return nil end
row = mysql_fetch_assoc ( result )
mysql_free_result ( result )
return row
end
function zapytanie ( query )
local result = mysql_query ( SQL , query )
if ( result ) then mysql_free_result ( result ) return true end
return
end
function insertID ()
return mysql_insert_id ( SQL )
end
function affectedRows ()
return mysql_affected_rows ( SQL )
end
function fetchRows ( query )
local result = mysql_query ( SQL , query )
if ( not result ) then return nil end
local tabela ={}
while true do
local row = mysql_fetch_row ( result )
if ( not row ) then break end
table . insert ( tabela , row )
end
mysql_free_result ( result )
return tabela
end
function getSQLLink ()
return SQL
end
Wysłany: 2018-09-08, 20:06
Nexisten Moderator Wiek: 22 4248 dni Nick w MP: Nexisten
Piwa 1486
Pomagamy tylko i wy??cznie na forum.
Wysłany: 2018-09-08, 20:11
CinusPL Wiek: 26 2973 dni Nick w MP: CinusPL
"vNeXxuS" napisał/a :Pomagamy tylko i wy??cznie na forum.
[ Dodano : 2018-09-08, 20:15
"vNeXxuS" napisał/a :Pomagamy tylko i wy??cznie na forum.
Kod:
Wysłany: 2018-09-08, 21:19
Wilq Wiek: 24 4569 dniPiwa 739
Pr?bujesz postawi? serwer lokalnie?
Wysłany: 2018-09-08, 21:34
CinusPL Wiek: 26 2973 dni Nick w MP: CinusPL
"Wilq" napisał/a :Pr?bujesz postawi? serwer lokalnie?
if getElementData ( localPlayer , "player:uid" ) then return end
local root = getRootElement ()
local resourceRoot = getResourceRootElement ( getThisResource ())
local screenWidth , screenHeight = guiGetScreenSize ()
local blurStrength = 20
local myScreenSource = dxCreateScreenSource ( screenWidth , screenHeight )
blurShader , blurTec = dxCreateShader ( "shaders/BlurShader.fx" )
function renderblur ()
if blur == true then
dxUpdateScreenSource ( myScreenSource )
dxSetShaderValue ( blurShader , "ScreenSource" , myScreenSource );
dxSetShaderValue ( blurShader , "BlurStrength" , blurStrength );
dxSetShaderValue ( blurShader , "UVSize" , screenWidth , screenHeight );
dxDrawImage ( 0 , 0 , screenWidth , screenHeight , blurShader )
end
end
addEventHandler ( "onClientRender" , root , renderblur )
addEventHandler ( "onClientResourceStop" , resourceRoot ,
function()
if ( blurShader ) then
destroyElement ( blurShader )
blurShader = nil
end
end )
x , y = 2313.58 , 1282.80 -- my width
intro_step = math . random ( 0 , 850 )
local sx , sy = guiGetScreenSize ()
local data ={ showed = nil , button ={}, info = nil , misc = nil , }
function isMouseIn ( psx , psy , pssx , pssy , abx , aby )
if not isCursorShowing () then return end
cx , cy = getCursorPosition ()
cx , cy = cx * sx , cy * sy
if cx >= psx and cx <= psx + pssx and cy >= psy and cy <= psy + pssy then
return true , cx , cy
else
return false
end
end
local dist = 100
local angler = 0
function getPointFromDistanceRotation ( x , y , dist , angler )
local a = math . rad ( 90 - angler )
local dx = math . cos ( a ) * dist ;
local dy = math . sin ( a ) * dist ;
return x + dx , y + dy ;
end
function renderLoginBox ()
blur = true
-- dxDrawImage ( 0 , 0 , 1920 , 1080 , "misc/drift.png" , AristatesYuvarlak , 0 , 0 , tocolor ( 255 , 255 , 255 , 255 ), false )
dxDrawRectangle ( sx * 270 / 1025 , sy * 150 / 769 , sx * 500 / 1025 , sy * 458 / 767 , tocolor ( 0 , 0 , 0 , 135 ), false )
-- dxDrawImage ( 0 , 0 , 1920 , 1080 , "misc/drift.png" , AristatesYuvarlak , 0 , 0 , tocolor ( 255 , 255 , 255 , 255 ), false )
if data . info then dxDrawText ( data . info , sx * 252 / 1024 , sy * 272 / 768 , sx * 800 / 1024 , sy * 255 / 768 , tocolor ( 237 , 0 , 0 , 255 ), 1.00 , "default" , "center" , "center" , false ) end
-- dxDrawLine ( sx * 0 / 1024 , sy * 199 / 768 , sx * 1022 / 1024 , sy * 200 / 768 , tocolor ( 31 , 111 , 193 , 255 ), 5 , false )
-- dxDrawLine ( sx * 0 / 1024 , sy * 509 / 768 , sx * 1022 / 1024 , sy * 510 / 768 , tocolor ( 31 , 111 , 193 , 255 ), 5 , false )
dxDrawText ( "U?ytkownik" , sx * 280 / 1024 , sy * 270 / 768 , sx * 760 / 1024 , sy * 302 / 768 , white , 1.30 , "default-bold" , "center" , "center" , false )
dxDrawText ( "Has?o" , sx *- 240 / 1024 , sy * 480 / 768 , sx * 1280 / 1024 , sy * 302 / 768 , white , 1.30 , "default-bold" , "center" , "center" , false )
if not isMouseIn ( sx * 305 / 1024 , sy * 506 / 768 , sx * 200 / 1024 , sy * 45 / 768 ) then dxDrawRectangle ( sx * 305 / 1024 , sy * 506 / 768 , sx * 200 / 1024 , sy * 45 / 768 , tocolor ( 31 , 222 , 140 , 170 ), false )
else dxDrawRectangle ( sx * 305 / 1024 , sy * 506 / 768 , sx * 200 / 1024 , sy * 45 / 768 , tocolor ( 220 , 100 , 0 , 100 ), false ) end
if not isMouseIn ( sx * 535 / 1024 , sy * 506 / 768 , sx * 200 / 1024 , sy * 45 / 768 ) then dxDrawRectangle ( sx * 535 / 1024 , sy * 506 / 768 , sx * 200 / 1024 , sy * 45 / 768 , tocolor ( 31 , 222 , 140 , 170 ), false )
else dxDrawRectangle ( sx * 535 / 1024 , sy * 506 / 768 , sx * 200 / 1024 , sy * 45 / 768 , tocolor ( 220 , 100 , 0 , 100 ), false ) end
dxDrawText ( "Zaloguj si?" , sx * 685 / 1024 , sy * 1015 / 768 , sx * 130 / 1024 , sy * 45 / 768 , white , 1.00 , "default-bold" , "center" , "center" , false )
dxDrawText ( "Zarejestruj si?" , sx * 1140 / 1024 , sy * 1013 / 768 , sx * 130 / 1024 , sy * 45 / 768 , white , 1.00 , "default-bold" , "center" , "center" , false )
dxDrawImage ( sx * 0.3118 , sy * 0.1813 , sx * 0.3838 , sy * 0.1549 , "logo.png" , 0 , 0 , 0 , tocolor ( 255 , 255 , 255 , 255 ), false )
-- dxDrawImage ( sw / 2 - 295 , sh / 2 + 70 , 594 , 307 , "logo.png" , angle , 0 , - 120 )
local x , y = getPointFromDistanceRotation ( 2313.58 , 1282.80 , dist , angler )
setCameraMatrix ( x , y , 107.72 + 0.9 , 2323.69 , 1285.66 , 107.72 + 0.9 )
angler =( angler + 0.1 )
end
addEventHandler ( "onClientClick" , root , function( btn , state )
if btn == "left" and state == "down" then
if isMouseIn ( sx * 305 / 1024 , sy * 506 / 768 , sx * 200 / 1024 , sy * 45 / 768 ) and data . showed then
local login = guiGetText ( data . button [ 1 ])
local pass = guiGetText ( data . button [ 2 ])
if string . len ( login ) < 2 or string . len ( pass ) < 2 then
data . info = "Wype?nij wszystkie pola!"
return
end
triggerServerEvent ( "logging:checkAccount" , resourceRoot , login , pass )
end
if isMouseIn ( sx * 535 / 1024 , sy * 506 / 768 , sx * 200 / 1024 , sy * 45 / 768 ) and data . showed then
local login = guiGetText ( data . button [ 1 ])
local pass = guiGetText ( data . button [ 2 ])
if string . len ( login ) > 22 or string . len ( pass ) > 22 and string . len ( login ) < 3 or string . len ( pass ) < 3 then
data . info = "Login/Has?o musz? mie? mniej ni? od 3 do 22 znak?w."
return
end
triggerServerEvent ( "logging:newAccount" , resourceRoot , login , pass )
end
end
end )
addEvent ( "logging:result" , true )
addEventHandler ( "logging:result" , resourceRoot , function( value , info )
if not info then info = "" end
if value then
data . showed = false
showZones ( data . misc )
-- Usuwamy elementy
destroyElement ( data . button [ 1 ])
destroyElement ( data . button [ 2 ])
removeEventHandler ( "onClientRender" , root , renderLoginBox )
else
data . info = tostring ( info )
setTimer (function() data . info = nil end , 3000 , 1 )
end
end )
addEventHandler ( "onClientResourceStart" , resourceRoot , function()
showChat ( false )
showCursor ( true )
fadeCamera ( true )
data . showed = true
setElementAlpha ( localPlayer , 0 )
data . misc = playSound ( "misc/intro.mp3" , true )
setSoundVolume ( data . misc , 1.0 )
showPlayerHudComponent ( "all" , false )
guiSetInputMode ( "no_binds_when_editing" )
setElementData ( localPlayer , "status" , "Loguje si?" )
-- setElementData ( localPlayer , "player:logged" , false )
addEventHandler ( "onClientRender" , root , renderLoginBox )
data . button [ 1 ]= guiCreateEdit ( 0.40 , 0.40 , 0.22 , 0.04 , "" , true )
data . button [ 2 ]= guiCreateEdit ( 0.40 , 0.53 , 0.22 , 0.04 , "" , true )
guiEditSetMasked ( data . button [ 2 ], true )
end )
x , y = 36.63 , 82.19 -- my width
intro_step = math . random ( 0 , 850 )
local sx , sy = guiGetScreenSize ()
local data ={ showed = nil , button ={}, info = nil , misc = nil , }
function isMouseIn ( psx , psy , pssx , pssy , abx , aby )
if not isCursorShowing () then return end
cx , cy = getCursorPosition ()
cx , cy = cx * sx , cy * sy
if cx >= psx and cx <= psx + pssx and cy >= psy and cy <= psy + pssy then
return true , cx , cy
else
return false
end
end
function renderZoneBox ()
-- dxDrawRectangle ( sx * 0 / 1024 , sy * 201 / 768 , sx * 1024 / 1024 , sy * 308 / 768 , tocolor ( 0 , 0 , 0 , 188 ), false )
if data . info then dxDrawText ( data . info , sx * 252 / 1024 , sy * 232 / 768 , sx * 800 / 1024 , sy * 255 / 768 , tocolor ( 237 , 0 , 0 , 255 ), 1.00 , "default" , "center" , "center" , false ) end
-- dxDrawLine ( sx * 0 / 1024 , sy * 199 / 768 , sx * 1022 / 1024 , sy * 200 / 768 , tocolor ( 31 , 111 , 193 , 255 ), 5 , false )
-- dxDrawLine ( sx * 0 / 1024 , sy * 509 / 768 , sx * 1022 / 1024 , sy * 510 / 768 , tocolor ( 31 , 111 , 193 , 255 ), 5 , false )
-- dxDrawText ( "Your Adventure RPG" , sx * 0 / 1024 , sy * 157 / 768 , sx * 1024 / 1024 , sy * 237 / 768 , white , 2.00 , "pricedown" , "center" , "center" , false )
if not isMouseIn ( sx * 10 / 1024 , sy * 48 / 768 , sx * 225 / 1024 , sy * 92 / 768 ) then dxDrawRectangle ( sx * 10 / 1024 , sy * 48 / 768 , sx * 225 / 1024 , sy * 92 / 768 , tocolor ( 31 , 222 , 140 , 170 ), false )
else dxDrawRectangle ( sx * 10 / 1024 , sy * 48 / 768 , sx * 225 / 1024 , sy * 92 / 768 , tocolor ( 220 , 100 , 0 , 100 ), false ) end
if not isMouseIn ( sx * 10 / 1024 , sy * 192 / 768 , sx * 225 / 1024 , sy * 92 / 768 ) then dxDrawRectangle ( sx * 10 / 1024 , sy * 192 / 768 , sx * 225 / 1024 , sy * 92 / 768 , tocolor ( 31 , 222 , 140 , 170 ), false )
else dxDrawRectangle ( sx * 10 / 1024 , sy * 192 / 768 , sx * 225 / 1024 , sy * 92 / 768 , tocolor ( 220 , 100 , 0 , 100 ), false ) end
if not isMouseIn ( sx * 10 / 1024 , sy * 336 / 768 , sx * 225 / 1024 , sy * 92 / 768 ) then dxDrawRectangle ( sx * 10 / 1024 , sy * 336 / 768 , sx * 225 / 1024 , sy * 92 / 768 , tocolor ( 31 , 222 , 140 , 170 ), false )
else dxDrawRectangle ( sx * 10 / 1024 , sy * 336 / 768 , sx * 225 / 1024 , sy * 92 / 768 , tocolor ( 220 , 100 , 0 , 100 ), false ) end
if not isMouseIn ( sx * 10 / 1024 , sy * 480 / 768 , sx * 225 / 1024 , sy * 92 / 768 ) then dxDrawRectangle ( sx * 10 / 1024 , sy * 480 / 768 , sx * 225 / 1024 , sy * 92 / 768 , tocolor ( 31 , 222 , 140 , 170 ), false )
else dxDrawRectangle ( sx * 10 / 1024 , sy * 480 / 768 , sx * 225 / 1024 , sy * 92 / 768 , tocolor ( 220 , 100 , 0 , 100 ), false ) end
if not isMouseIn ( sx * 10 / 1024 , sy * 624 / 768 , sx * 225 / 1024 , sy * 92 / 768 ) then dxDrawRectangle ( sx * 10 / 1024 , sy * 624 / 768 , sx * 225 / 1024 , sy * 92 / 768 , tocolor ( 31 , 222 , 140 , 170 ), false )
else dxDrawRectangle ( sx * 10 / 1024 , sy * 624 / 768 , sx * 225 / 1024 , sy * 92 / 768 , tocolor ( 220 , 100 , 0 , 100 ), false ) end
dxDrawText ( "Spawn LS" , sx *- 80 / 1024 , sy *- 188 / 768 , sx * 323 / 1024 , sy * 386 / 768 , white , 1.00 , "default-bold" , "center" , "center" , false )
dxDrawText ( "Przechowywalnia pojazd?w LS" , sx *- 380 / 1024 , sy * 92 / 768 , sx * 641 / 1024 , sy * 386 / 768 , white , 1.00 , "default-bold" , "center" , "center" , false )
dxDrawText ( "Dom" , sx *- 700 / 1024 , sy * 373 / 768 , sx * 937 / 1024 , sy * 386 / 768 , white , 1.00 , "default-bold" , "center" , "center" , false )
dxDrawText ( "Baza organizacji" , sx *- 700 / 1024 , sy * 660 / 768 , sx * 937 / 1024 , sy * 386 / 768 , white , 1.00 , "default-bold" , "center" , "center" , false )
dxDrawText ( "Spawn LV" , sx *- 80 / 1024 , sy * 957 / 768 , sx * 323 / 1024 , sy * 386 / 768 , white , 1.00 , "default-bold" , "center" , "center" , false )
dxDrawImage ( sx * 0.3118 , sy * 0.0313 , sx * 0.3838 , sy * 0.1549 , "logo.png" , 0 , 0 , 0 , tocolor ( 255 , 255 , 255 , 255 ), false )
local zone1 = math . sin ( intro_step / 500 )* 9000
local zone2 = math . cos ( intro_step / 500 )* 9000
setCameraMatrix ( 2019.56 , 1343.03 , 14.00 , zone1 , zone2 , 2 )
-- setCameraMatrix ( zone1 , zone2 , 120 , zone1 , zone2 , 120 )
intro_step = intro_step - 1.5
end
addEventHandler ( "onClientClick" , root , function( btn , state )
if btn == "left" and state == "down" then
if isMouseIn ( sx * 10 / 1024 , sy * 54 / 768 , sx * 225 / 1024 , sy * 92 / 768 ) and data . showed then
setElementData ( localPlayer , "player:spawn" ,{ 1479.51 , - 1713.07 , 14.05 + 0.1 })
closeZones ()
end
if isMouseIn ( sx * 10 / 1024 , sy * 198 / 768 , sx * 225 / 1024 , sy * 92 / 768 ) and data . showed then
setElementData ( localPlayer , "player:spawn" ,{ 1588.83 , - 1406.00 , 13.82 + 0.1 })
closeZones ()
end
if isMouseIn ( sx * 10 / 1024 , sy * 624 / 768 , sx * 225 / 1024 , sy * 92 / 768 ) and data . showed then
setElementData ( localPlayer , "player:spawn" ,{ 2597.44 , 1889.67 , 11.03 + 0.1 })
closeZones ()
end
if isMouseIn ( sx * 10 / 1024 , sy * 342 / 768 , sx * 225 / 1024 , sy * 92 / 768 ) and data . showed then
local domek = getElementData ( localPlayer , "player:house" )
if not domek then
setElementData ( localPlayer , "player:spawn" ,{ 1479.51 , - 1713.07 , 14.05 + 0.1 })
outputChatBox ( "Nie posiadasz domku!" )
end
closeZones ()
end
if isMouseIn ( sx * 10 / 1024 , sy * 480 / 768 , sx * 225 / 1024 , sy * 92 / 768 ) and data . showed then
local org = getElementData ( localPlayer , "player:organization:spawn" )
if not org then
setElementData ( localPlayer , "player:spawn" ,{ 1479.51 , - 1713.07 , 14.05 + 0.1 })
outputChatBox ( "Nie posiadasz organizacji/Lub nie posiada ona spawnu!" )
closeZones ()
else
setTimer ( outputChatBox , 1500 , 1 , "Pomy?lnie zrespi?e? si? w organizacji." )
setElementData ( localPlayer , "player:spawn" ,{ tonumber ( org [ 1 ]), tonumber ( org [ 2 ]), tonumber ( org [ 3 ])})
closeZones ()
end
end
end
end )
function closeZones ()
showChat ( true )
showCursor ( false )
fadeCamera ( false )
setElementAlpha ( localPlayer , 255 )
stopSound ( data . misc )
showPlayerHudComponent ( "all" , false )
showPlayerHudComponent ( "radar" , true )
showPlayerHudComponent ( "crosshair" , true )
showPlayerHudComponent ( "weapon" , false )
showPlayerHudComponent ( "health" , false )
showPlayerHudComponent ( "breath" , false )
showPlayerHudComponent ( "ammo" , true )
data . showed = false
destroyElement ( blurShader )
-- Usuwamy elementy
triggerServerEvent ( "core:spawnPlayer" , localPlayer )
setTimer ( triggerEvent , 250 , 1 , "gui:start" , localPlayer )
removeEventHandler ( "onClientRender" , root , renderZoneBox )
blur = false
end
function showZones ( misc )
data . misc = misc
data . showed = true
showPlayerHudComponent ( "all" , false )
guiSetInputMode ( "no_binds_when_editing" )
addEventHandler ( "onClientRender" , root , renderZoneBox )
end
< meta >
<!-- FILES -->
< file src = "misc/intro.mp3" />
<!-- SERVERSIDE -->
< script src = "s_logging.lua" type = "server" />
<!-- CLIENTSIDE -->
< script src = "c_zone.lua" type = "client" />
< script src = "c_logging.lua" type = "client" />
< file src = "logo.png" />
< file src = "shaders/BlurShader.fx" type = "client" />
</ meta >
--[[
Panel Logowania by Kurianusz @ 2016 .
Regulamin / Licencja
Korzystanie z tego kodu tylko je ? eli posiadasz tzw . copyrights . Zakaz usuwania tej notatki !
Pami ? taj ? e nielegalne korzystanie z kodu podpada pod kodeks karny :> Tak samo jak usuni ? cie tej notatki !
]]
function sprawdzorganizacje ( plr )
local x = exports [ 'ogrpg-db' ]: dbGet ( "SELECT spawn from ogrpg_organization_list join ogrpg_organizations on ogrpg_organizations.code = ogrpg_organization_list.id WHERE uid=? and not(spawn=?)" , getElementData ( plr , "player:uid" ), "0,0,0" )
if x and #x > 0 then
local t = split ( x [ 1 ]. spawn , "," )
return t
end
return false
end
addEvent ( "logging:checkAccount" , true )
addEventHandler ( "logging:checkAccount" , resourceRoot , function( login , pass )
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
if result [ 1 ]. login == login and result [ 1 ]. pass == md5 ( pass ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "Trujeczka" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "Ryjek" ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "Trujeczka" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "Trujeczka" ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "*****" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "*****" ) then
for i , player in pairs ( getElementsByType ( "player" )) do
if getElementData ( player , "player:uid" ) == result [ 1 ]. id then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Kto? jest zalogowany na to konto!!!!!." , "blad" )
return
end
end
-- local result2 = exports [ 'ogrpg-db' ]: dbGet ( "SELECT login2 from ogrpg_users where id=?" , result [ 1 ]. id )
if not result [ 1 ]. login2 == false then
setPlayerName ( client , result [ 1 ]. login2 )
outputChatBox ( "Wykupiono us?uge zmiana pseudonimu, tw?j nick to: " .. result [ 1 ]. login2 .. "" , client , 255 , 255 , 255 )
else
setPlayerName ( client , login )
end
setElementData ( client , "player:uid" , result [ 1 ]. id )
triggerClientEvent ( client , "logging:result" , resourceRoot , true , "Zalogowa?e? si? pomyslnie" , "git" )
triggerEvent ( "SprawdzDom" , root , client )
setElementData ( client , "player:organization:spawn" , sprawdzorganizacje ( client ))
if result [ 1 ]. register_serial == false then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET register_serial=? WHERE login=?" , getPlayerSerial ( client ), login )
end
local logs = exports [ "ogrpg-db" ]: dbSet ( "INSERT INTO ogrpg_logs_login (name,serial,data) VALUES (?,?,NOW())" , string . format ( login .. "(" .. result [ 1 ]. id .. ")" ), getPlayerSerial ( client ))
else
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podane dane s? nieprawid?owe." , "blad" )
end
else
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podany login nie istnieje w bazie." , "blad" )
end
end )
local maks_ilosc_kont = 2 -- Maksymalna ilosc kont do rejestracji
addEvent ( "logging:newAccount" , true )
addEventHandler ( "logging:newAccount" , resourceRoot , function( login , pass )
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE register_serial=?" , getPlayerSerial ( client ))
if result and #result >= maks_ilosc_kont then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Na ten serial zostala utworzona maksymalna ilosc kont." , "blad" )
return end
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podany login ju? istnieje w bazie." , "blad" )
else
local query = exports [ "ogrpg-db" ]: dbSet ( "INSERT INTO ogrpg_users (login,pass,register_serial,changedpw) VALUES (?,?,?,??)" , login , teaEncode ( pass , "*****" ), getPlayerSerial ( client ), 1 )
if query then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Pomy?lnie zarejestrowa?e?(a?) si?" , "git" )
setElementData ( client , "player:logged" , true )
end
end
end )
Wysłany: 2018-09-08, 22:29
Wilq Wiek: 24 4569 dniPiwa 739
Spr?buj ten kod:
--[[
Panel Logowania by Kurianusz @ 2016 .
Regulamin / Licencja
Korzystanie z tego kodu tylko je ? eli posiadasz tzw . copyrights . Zakaz usuwania tej notatki !
Pami ? taj ? e nielegalne korzystanie z kodu podpada pod kodeks karny :> Tak samo jak usuni ? cie tej notatki !
]]
function sprawdzorganizacje ( plr )
local x = exports [ 'ogrpg-db' ]: dbGet ( "SELECT spawn from ogrpg_organization_list join ogrpg_organizations on ogrpg_organizations.code = ogrpg_organization_list.id WHERE uid=? and not(spawn=?)" , getElementData ( plr , "player:uid" ), "0,0,0" )
if x and #x > 0 then
local t = split ( x [ 1 ]. spawn , "," )
return t
end
return false
end
addEvent ( "logging:checkAccount" , true )
addEventHandler ( "logging:checkAccount" , resourceRoot , function( login , pass )
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
if result [ 1 ]. login == login and result [ 1 ]. pass == md5 ( pass ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "Trujeczka" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "Ryjek" ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "Trujeczka" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "Trujeczka" ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "*****" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "*****" ) then
for i , player in pairs ( getElementsByType ( "player" )) do
if getElementData ( player , "player:uid" ) == result [ 1 ]. id then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Kto? jest zalogowany na to konto!" , "blad" )
return
end
end
-- local result2 = exports [ 'ogrpg-db' ]: dbGet ( "SELECT login2 from ogrpg_users where id=?" , result [ 1 ]. id )
if not result [ 1 ]. login2 == false then
setPlayerName ( client , result [ 1 ]. login2 )
outputChatBox ( "Wykupiono us?uge zmiana pseudonimu, tw?j nick to: " .. result [ 1 ]. login2 .. "" , client , 255 , 255 , 255 )
else
setPlayerName ( client , login )
end
setElementData ( client , "player:uid" , result [ 1 ]. id )
triggerClientEvent ( client , "logging:result" , resourceRoot , true , "Zalogowa?e? si? pomyslnie" , "git" )
triggerEvent ( "SprawdzDom" , root , client )
setElementData ( client , "player:organization:spawn" , sprawdzorganizacje ( client ))
if result [ 1 ]. register_serial == false then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET register_serial=? WHERE login=?" , getPlayerSerial ( client ), login )
end
local logs = exports [ "ogrpg-db" ]: dbSet ( "INSERT INTO ogrpg_logs_login (name,serial,data) VALUES (?,?,NOW())" , string . format ( login .. "(" .. result [ 1 ]. id .. ")" ), getPlayerSerial ( client ))
else
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podane dane s? nieprawid?owe." , "blad" )
end
else
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podany login nie istnieje w bazie." , "blad" )
end
end )
local maks_ilosc_kont = 2 -- Maksymalna ilosc kont do rejestracji
addEvent ( "logging:newAccount" , true )
addEventHandler ( "logging:newAccount" , resourceRoot , function( login , pass )
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE register_serial=?" , getPlayerSerial ( client ))
if result and #result >= maks_ilosc_kont then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Na ten serial zostala utworzona maksymalna ilosc kont." , "blad" )
return
end
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podany login ju? istnieje w bazie." , "blad" )
else
local query = exports [ "ogrpg-db" ]: dbSet ( "INSERT INTO ogrpg_users (login,pass,register_serial,changedpw) VALUES (?,?,?,?)" , login , teaEncode ( pass , "*****" ), getPlayerSerial ( client ), 1 )
if query then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Pomy?lnie zarejestrowa?e?(a?) si?" , "git" )
setElementData ( client , "player:logged" , true )
end
end
end )
Wysłany: 2018-09-08, 23:08
CinusPL Wiek: 26 2973 dni Nick w MP: CinusPL
"Wilq" napisał/a :Spr?buj ten kod:
--[[
Panel Logowania by Kurianusz @ 2016 .
Regulamin / Licencja
Korzystanie z tego kodu tylko je ? eli posiadasz tzw . copyrights . Zakaz usuwania tej notatki !
Pami ? taj ? e nielegalne korzystanie z kodu podpada pod kodeks karny :> Tak samo jak usuni ? cie tej notatki !
]]
function sprawdzorganizacje ( plr )
local x = exports [ 'ogrpg-db' ]: dbGet ( "SELECT spawn from ogrpg_organization_list join ogrpg_organizations on ogrpg_organizations.code = ogrpg_organization_list.id WHERE uid=? and not(spawn=?)" , getElementData ( plr , "player:uid" ), "0,0,0" )
if x and #x > 0 then
local t = split ( x [ 1 ]. spawn , "," )
return t
end
return false
end
addEvent ( "logging:checkAccount" , true )
addEventHandler ( "logging:checkAccount" , resourceRoot , function( login , pass )
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
if result [ 1 ]. login == login and result [ 1 ]. pass == md5 ( pass ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "Trujeczka" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "Ryjek" ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "Trujeczka" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "Trujeczka" ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "*****" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "*****" ) then
for i , player in pairs ( getElementsByType ( "player" )) do
if getElementData ( player , "player:uid" ) == result [ 1 ]. id then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Kto? jest zalogowany na to konto!" , "blad" )
return
end
end
-- local result2 = exports [ 'ogrpg-db' ]: dbGet ( "SELECT login2 from ogrpg_users where id=?" , result [ 1 ]. id )
if not result [ 1 ]. login2 == false then
setPlayerName ( client , result [ 1 ]. login2 )
outputChatBox ( "Wykupiono us?uge zmiana pseudonimu, tw?j nick to: " .. result [ 1 ]. login2 .. "" , client , 255 , 255 , 255 )
else
setPlayerName ( client , login )
end
setElementData ( client , "player:uid" , result [ 1 ]. id )
triggerClientEvent ( client , "logging:result" , resourceRoot , true , "Zalogowa?e? si? pomyslnie" , "git" )
triggerEvent ( "SprawdzDom" , root , client )
setElementData ( client , "player:organization:spawn" , sprawdzorganizacje ( client ))
if result [ 1 ]. register_serial == false then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET register_serial=? WHERE login=?" , getPlayerSerial ( client ), login )
end
local logs = exports [ "ogrpg-db" ]: dbSet ( "INSERT INTO ogrpg_logs_login (name,serial,data) VALUES (?,?,NOW())" , string . format ( login .. "(" .. result [ 1 ]. id .. ")" ), getPlayerSerial ( client ))
else
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podane dane s? nieprawid?owe." , "blad" )
end
else
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podany login nie istnieje w bazie." , "blad" )
end
end )
local maks_ilosc_kont = 2 -- Maksymalna ilosc kont do rejestracji
addEvent ( "logging:newAccount" , true )
addEventHandler ( "logging:newAccount" , resourceRoot , function( login , pass )
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE register_serial=?" , getPlayerSerial ( client ))
if result and #result >= maks_ilosc_kont then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Na ten serial zostala utworzona maksymalna ilosc kont." , "blad" )
return
end
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podany login ju? istnieje w bazie." , "blad" )
else
local query = exports [ "ogrpg-db" ]: dbSet ( "INSERT INTO ogrpg_users (login,pass,register_serial,changedpw) VALUES (?,?,?,?)" , login , teaEncode ( pass , "*****" ), getPlayerSerial ( client ), 1 )
if query then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Pomy?lnie zarejestrowa?e?(a?) si?" , "git" )
setElementData ( client , "player:logged" , true )
end
end
end )
Wysłany: 2018-09-08, 23:19
Wilq Wiek: 24 4569 dniPiwa 739
W??cz skrypt ogrpg-logging i po??cz si? ponownie z serwerem.
--[[
Panel Logowania by Kurianusz @ 2016 .
Regulamin / Licencja
Korzystanie z tego kodu tylko je ? eli posiadasz tzw . copyrights . Zakaz usuwania tej notatki !
Pami ? taj ? e nielegalne korzystanie z kodu podpada pod kodeks karny :> Tak samo jak usuni ? cie tej notatki !
]]
function sprawdzorganizacje ( plr )
local x = exports [ 'DB2' ]: pobierzTabeleWynikow ( "SELECT spawn from ogrpg_organization_list join ogrpg_organizations on ogrpg_organizations.code = ogrpg_organization_list.id WHERE uid=? and not(spawn=?)" , getElementData ( plr , "player:uid" ), "0,0,0" )
if x and #x > 0 then
local t = split ( x [ 1 ]. spawn , "," )
return t
end
return false
end
addEvent ( "logging:checkAccount" , true )
addEventHandler ( "logging:checkAccount" , resourceRoot , function( login , pass )
local result = exports [ "DB2" ]: pobierzTabeleWynikow ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
if result [ 1 ]. login == login and result [ 1 ]. pass == md5 ( pass ) then
local query = exports [ "DB2" ]: zapytanie ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "Trujeczka" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "Ryjek" ) then
local query = exports [ "DB2" ]: zapytanie ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "Trujeczka" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "Trujeczka" ) then
local query = exports [ "DB2" ]: zapytanie ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "*****" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "*****" ) then
for i , player in pairs ( getElementsByType ( "player" )) do
if getElementData ( player , "player:uid" ) == result [ 1 ]. id then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Kto? jest zalogowany na to konto!" , "blad" )
return
end
end
-- local result2 = exports [ 'DB2' ]: dbGet ( "SELECT login2 from ogrpg_users where id=?" , result [ 1 ]. id )
if not result [ 1 ]. login2 == false then
setPlayerName ( client , result [ 1 ]. login2 )
outputChatBox ( "Wykupiono us?uge zmiana pseudonimu, tw?j nick to: " .. result [ 1 ]. login2 .. "" , client , 255 , 255 , 255 )
else
setPlayerName ( client , login )
end
setElementData ( client , "player:uid" , result [ 1 ]. id )
triggerClientEvent ( client , "logging:result" , resourceRoot , true , "Zalogowa?e? si? pomyslnie" , "git" )
triggerEvent ( "SprawdzDom" , root , client )
setElementData ( client , "player:organization:spawn" , sprawdzorganizacje ( client ))
if result [ 1 ]. register_serial == false then
local query = exports [ "DB2" ]: zapytanie ( "UPDATE ogrpg_users SET register_serial=? WHERE login=?" , getPlayerSerial ( client ), login )
end
local logs = exports [ "DB2" ]: zapytanie ( "INSERT INTO ogrpg_logs_login (name,serial,data) VALUES (?,?,NOW())" , string . format ( login .. "(" .. result [ 1 ]. id .. ")" ), getPlayerSerial ( client ))
else
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podane dane s? nieprawid?owe." , "blad" )
end
else
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podany login nie istnieje w bazie." , "blad" )
end
end )
local maks_ilosc_kont = 2 -- Maksymalna ilosc kont do rejestracji
addEvent ( "logging:newAccount" , true )
addEventHandler ( "logging:newAccount" , resourceRoot , function( login , pass )
local result = exports [ "DB2" ]: pobierzTabeleWynikow ( "SELECT * FROM ogrpg_users WHERE register_serial=?" , getPlayerSerial ( client ))
if result and #result >= maks_ilosc_kont then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Na ten serial zostala utworzona maksymalna ilosc kont." , "blad" )
return
end
local result = exports [ "DB2" ]: pobierzTabeleWynikow ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podany login ju? istnieje w bazie." , "blad" )
else
local query = exports [ "DB2" ]: zapytanie ( "INSERT INTO ogrpg_users (login,pass,register_serial,changedpw) VALUES (?,?,?,?)" , login , teaEncode ( pass , "*****" ), getPlayerSerial ( client ), 1 )
if query then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Pomy?lnie zarejestrowa?e?(a?) si?" , "git" )
setElementData ( client , "player:logged" , true )
end
end
end )
Wysłany: 2018-09-08, 23:30
CinusPL Wiek: 26 2973 dni Nick w MP: CinusPL
"Wilq" napisał/a :W??cz skrypt ogrpg-logging i po??cz si? ponownie z serwerem.
--[[
Panel Logowania by Kurianusz @ 2016 .
Regulamin / Licencja
Korzystanie z tego kodu tylko je ? eli posiadasz tzw . copyrights . Zakaz usuwania tej notatki !
Pami ? taj ? e nielegalne korzystanie z kodu podpada pod kodeks karny :> Tak samo jak usuni ? cie tej notatki !
]]
function sprawdzorganizacje ( plr )
local x = exports [ 'DB2' ]: pobierzTabeleWynikow ( "SELECT spawn from ogrpg_organization_list join ogrpg_organizations on ogrpg_organizations.code = ogrpg_organization_list.id WHERE uid=? and not(spawn=?)" , getElementData ( plr , "player:uid" ), "0,0,0" )
if x and #x > 0 then
local t = split ( x [ 1 ]. spawn , "," )
return t
end
return false
end
addEvent ( "logging:checkAccount" , true )
addEventHandler ( "logging:checkAccount" , resourceRoot , function( login , pass )
local result = exports [ "DB2" ]: pobierzTabeleWynikow ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
if result [ 1 ]. login == login and result [ 1 ]. pass == md5 ( pass ) then
local query = exports [ "DB2" ]: zapytanie ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "Trujeczka" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "Ryjek" ) then
local query = exports [ "DB2" ]: zapytanie ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "Trujeczka" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "Trujeczka" ) then
local query = exports [ "DB2" ]: zapytanie ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "*****" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "*****" ) then
for i , player in pairs ( getElementsByType ( "player" )) do
if getElementData ( player , "player:uid" ) == result [ 1 ]. id then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Kto? jest zalogowany na to konto!" , "blad" )
return
end
end
-- local result2 = exports [ 'DB2' ]: dbGet ( "SELECT login2 from ogrpg_users where id=?" , result [ 1 ]. id )
if not result [ 1 ]. login2 == false then
setPlayerName ( client , result [ 1 ]. login2 )
outputChatBox ( "Wykupiono us?uge zmiana pseudonimu, tw?j nick to: " .. result [ 1 ]. login2 .. "" , client , 255 , 255 , 255 )
else
setPlayerName ( client , login )
end
setElementData ( client , "player:uid" , result [ 1 ]. id )
triggerClientEvent ( client , "logging:result" , resourceRoot , true , "Zalogowa?e? si? pomyslnie" , "git" )
triggerEvent ( "SprawdzDom" , root , client )
setElementData ( client , "player:organization:spawn" , sprawdzorganizacje ( client ))
if result [ 1 ]. register_serial == false then
local query = exports [ "DB2" ]: zapytanie ( "UPDATE ogrpg_users SET register_serial=? WHERE login=?" , getPlayerSerial ( client ), login )
end
local logs = exports [ "DB2" ]: zapytanie ( "INSERT INTO ogrpg_logs_login (name,serial,data) VALUES (?,?,NOW())" , string . format ( login .. "(" .. result [ 1 ]. id .. ")" ), getPlayerSerial ( client ))
else
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podane dane s? nieprawid?owe." , "blad" )
end
else
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podany login nie istnieje w bazie." , "blad" )
end
end )
local maks_ilosc_kont = 2 -- Maksymalna ilosc kont do rejestracji
addEvent ( "logging:newAccount" , true )
addEventHandler ( "logging:newAccount" , resourceRoot , function( login , pass )
local result = exports [ "DB2" ]: pobierzTabeleWynikow ( "SELECT * FROM ogrpg_users WHERE register_serial=?" , getPlayerSerial ( client ))
if result and #result >= maks_ilosc_kont then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Na ten serial zostala utworzona maksymalna ilosc kont." , "blad" )
return
end
local result = exports [ "DB2" ]: pobierzTabeleWynikow ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podany login ju? istnieje w bazie." , "blad" )
else
local query = exports [ "DB2" ]: zapytanie ( "INSERT INTO ogrpg_users (login,pass,register_serial,changedpw) VALUES (?,?,?,?)" , login , teaEncode ( pass , "*****" ), getPlayerSerial ( client ), 1 )
if query then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Pomy?lnie zarejestrowa?e?(a?) si?" , "git" )
setElementData ( client , "player:logged" , true )
end
end
end )
Wysłany: 2018-09-08, 23:33
Wilq Wiek: 24 4569 dniPiwa 739
W skrypcie DB2, linijka:
SQL = dbConnect ( "mysql" , "dbname=db_16014;host=127.0.0.1" , "LOGINDOMYSQL" , "HASLODOMYSQL" , "share=1" ) DBName = "db_16014"
DBUser = "LOGINDOMYSQL"
DBPass = "HASLODOMYSQL"
DBHost = "127.0.0.1"
Wysłany: 2018-09-08, 23:36
CinusPL Wiek: 26 2973 dni Nick w MP: CinusPL
"Wilq" napisał/a :W??cz skrypt ogrpg-logging i po??cz si? ponownie z serwerem.
--[[
Panel Logowania by Kurianusz @ 2016 .
Regulamin / Licencja
Korzystanie z tego kodu tylko je ? eli posiadasz tzw . copyrights . Zakaz usuwania tej notatki !
Pami ? taj ? e nielegalne korzystanie z kodu podpada pod kodeks karny :> Tak samo jak usuni ? cie tej notatki !
]]
function sprawdzorganizacje ( plr )
local x = exports [ 'DB2' ]: pobierzTabeleWynikow ( "SELECT spawn from ogrpg_organization_list join ogrpg_organizations on ogrpg_organizations.code = ogrpg_organization_list.id WHERE uid=? and not(spawn=?)" , getElementData ( plr , "player:uid" ), "0,0,0" )
if x and #x > 0 then
local t = split ( x [ 1 ]. spawn , "," )
return t
end
return false
end
addEvent ( "logging:checkAccount" , true )
addEventHandler ( "logging:checkAccount" , resourceRoot , function( login , pass )
local result = exports [ "DB2" ]: pobierzTabeleWynikow ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
if result [ 1 ]. login == login and result [ 1 ]. pass == md5 ( pass ) then
local query = exports [ "DB2" ]: zapytanie ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "Trujeczka" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "Ryjek" ) then
local query = exports [ "DB2" ]: zapytanie ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "Trujeczka" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "Trujeczka" ) then
local query = exports [ "DB2" ]: zapytanie ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "*****" ), login )
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "git" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "*****" ) then
for i , player in pairs ( getElementsByType ( "player" )) do
if getElementData ( player , "player:uid" ) == result [ 1 ]. id then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Kto? jest zalogowany na to konto!" , "blad" )
return
end
end
-- local result2 = exports [ 'DB2' ]: dbGet ( "SELECT login2 from ogrpg_users where id=?" , result [ 1 ]. id )
if not result [ 1 ]. login2 == false then
setPlayerName ( client , result [ 1 ]. login2 )
outputChatBox ( "Wykupiono us?uge zmiana pseudonimu, tw?j nick to: " .. result [ 1 ]. login2 .. "" , client , 255 , 255 , 255 )
else
setPlayerName ( client , login )
end
setElementData ( client , "player:uid" , result [ 1 ]. id )
triggerClientEvent ( client , "logging:result" , resourceRoot , true , "Zalogowa?e? si? pomyslnie" , "git" )
triggerEvent ( "SprawdzDom" , root , client )
setElementData ( client , "player:organization:spawn" , sprawdzorganizacje ( client ))
if result [ 1 ]. register_serial == false then
local query = exports [ "DB2" ]: zapytanie ( "UPDATE ogrpg_users SET register_serial=? WHERE login=?" , getPlayerSerial ( client ), login )
end
local logs = exports [ "DB2" ]: zapytanie ( "INSERT INTO ogrpg_logs_login (name,serial,data) VALUES (?,?,NOW())" , string . format ( login .. "(" .. result [ 1 ]. id .. ")" ), getPlayerSerial ( client ))
else
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podane dane s? nieprawid?owe." , "blad" )
end
else
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podany login nie istnieje w bazie." , "blad" )
end
end )
local maks_ilosc_kont = 2 -- Maksymalna ilosc kont do rejestracji
addEvent ( "logging:newAccount" , true )
addEventHandler ( "logging:newAccount" , resourceRoot , function( login , pass )
local result = exports [ "DB2" ]: pobierzTabeleWynikow ( "SELECT * FROM ogrpg_users WHERE register_serial=?" , getPlayerSerial ( client ))
if result and #result >= maks_ilosc_kont then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Na ten serial zostala utworzona maksymalna ilosc kont." , "blad" )
return
end
local result = exports [ "DB2" ]: pobierzTabeleWynikow ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Podany login ju? istnieje w bazie." , "blad" )
else
local query = exports [ "DB2" ]: zapytanie ( "INSERT INTO ogrpg_users (login,pass,register_serial,changedpw) VALUES (?,?,?,?)" , login , teaEncode ( pass , "*****" ), getPlayerSerial ( client ), 1 )
if query then
triggerClientEvent ( client , "logging:result" , resourceRoot , false , "Pomy?lnie zarejestrowa?e?(a?) si?" , "git" )
setElementData ( client , "player:logged" , true )
end
end
end )
Wysłany: 2018-09-08, 23:39
Wilq Wiek: 24 4569 dniPiwa 739
Ale dane do MySQL masz poprawne? Dostajesz informacj? "BRAK POLACZENIA Z BAZA DANYCH" w consoli? O to mi chodzi.
Wysłany: 2018-09-08, 23:47
CinusPL Wiek: 26 2973 dni Nick w MP: CinusPL
"Wilq" napisał/a :Ale dane do MySQL masz poprawne? Dostajesz informacj? "BRAK POLACZENIA Z BAZA DANYCH" w consoli? O to mi chodzi.
Kod:
Tagi: its :: your :: world :: nie :: dziala
Anonymous 245 dni
Anonymous Koniecznie zajrzyj na:
Piwa: 1486
