Wysłany: 2019-01-03, 12:10
DaVeCS
Mapper
Wiek: 31 Na forum: 3386 dni Posty: 193
Nick w MP: DaVe
Piwa : 59
Witam, powie mi kto? co musz? doda? i gdzie tak ?eby ka?dy po za?o?eniu konta mia? premk? na np. 200 dni?
Za pomoc stawiam
Wysłany: 2019-01-03, 12:40
Xrent
-
Wiek: 21 Na forum: 3047 dni Posty: 230
Nick w MP: Pazdam
Piwa : 535
"DaVeCS" napisał/a :Witam, powie mi kto? co musz? doda? i gdzie tak ?eby ka?dy po za?o?eniu konta mia? premk? na np. 200 dni?
Za pomoc stawiam
Jak masz tworzenie konta i masz 'insert into' to tam sobie daj by dawa?o dla kolumny premium date 200 dni
Najlepiej daj kod w [.lua] [./lua] bez kropek. To w razie gdyby? czego nie wiedzia? to ci pomog?.
Wysłany: 2019-01-03, 13:32
DaVeCS
Mapper
Wiek: 31 Na forum: 3386 dni Posty: 193
Nick w MP: DaVe
Piwa : 59
function onLogin ( login , pass , checkboxState , save )
if string . len ( login ) < 3 or string . len ( pass ) < 3 then
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Wype?nij wszystkie pola!" , "red" )
return
end
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
serial = getPlayerSerial ( client )
if result [ 1 ]. register_serial ~= serial then
tak = true
for i , v in ipairs ( split ( result [ 1 ]. seriale , "," )) do
if v == serial then tak = false end
end
if tak then
return triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Te konto nie nale?y do ciebie! Posiadasz inny serial! Napisz blad na forum!" , "red" )
end
end
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 , "Trujeczka321321" ), login )
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "green" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "dafgudhg63268" ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "Trujeczka1233213" ), login )
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "green" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "gdfdcvhj" ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "*****" ), login )
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "green" )
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 , "changeMessage" , getRootElement (), "1" , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "green" )
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 , "changeMessage" , getRootElement (), "1" , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "green" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "*****" ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "wypierdalacchuje" ), login )
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "green" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "wypierdalacchuje" ) then
for i , player in pairs ( getElementsByType ( "player" )) do
if getElementData ( player , "player:uid" ) == result [ 1 ]. id then
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Kto? jest zalogowany na to konto!!!!!." , "red" )
return
end
end
if result [ 1 ]. login2 == false then
setPlayerName ( client , login )
else
setPlayerName ( client , result [ 1 ]. login2 )
triggerClientEvent ( client , "iyw_notifications:send" , client , "info" , "Wykupiono us?uge zmiana pseudonimu, tw?j nick to: " .. result [ 1 ]. login2 .. "" )
end
setElementData ( client , "player:uid" , result [ 1 ]. id )
-- setElementData ( client , "_zalogowany" , true )
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Zalogowa?e? si? pomy?lnie!" , "green" )
triggerClientEvent ( client , "saveXML" , getRootElement (), login , pass , tostring ( checkboxState ))
triggerClientEvent ( client , "hideLoginPanel" , getRootElement ())
triggerClientEvent ( client , "pokaz:wyborspawnu" , getRootElement ())
triggerEvent ( "SprawdzDom" , root , client )
if result [ 1 ]. register_serial == false then
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 , "changeMessage" , getRootElement (), "1" , "Podane dane s? nieprawid?owe." , "red" )
end
else
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Podany login nie istnieje w bazie." , "red" )
end
end
addEvent ( "onLogin" , true )
addEventHandler ( "onLogin" , getRootElement (), onLogin )
local maks_ilosc_kont = 2
function onRegister ( login , pass )
if string . len ( login ) > 22 or string . len ( pass ) > 22 and string . len ( login ) < 4 or string . len ( pass ) < 4 then
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Login/Has?o musz? mie? mniej ni? od 4 do 22 znak?w." , "red" )
return
end
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 , "changeMessage" , getRootElement (), "1" , "Na ten serial zostala utworzona maksymalna ilosc kont." , "red" )
return end
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Podany login ju? istnieje w bazie." , "red" )
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 , "changeMessage" , getRootElement (), "1" , "Pomyslnie zarejestrowales(as) sie!" , "green" )
setElementData ( client , "player:logged" , true )
end
end
end
addEvent ( "onRegister" , true )
addEventHandler ( "onRegister" , getRootElement (), onRegister )
W kt?rej linijce mam to wpisa??
Wysłany: 2019-01-03, 13:54
Xrent
-
Wiek: 21 Na forum: 3047 dni Posty: 230
Nick w MP: Pazdam
Piwa : 535
"DaVeCS" napisał/a : function onLogin ( login , pass , checkboxState , save )
if string . len ( login ) < 3 or string . len ( pass ) < 3 then
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Wype?nij wszystkie pola!" , "red" )
return
end
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
serial = getPlayerSerial ( client )
if result [ 1 ]. register_serial ~= serial then
tak = true
for i , v in ipairs ( split ( result [ 1 ]. seriale , "," )) do
if v == serial then tak = false end
end
if tak then
return triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Te konto nie nale?y do ciebie! Posiadasz inny serial! Napisz blad na forum!" , "red" )
end
end
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 , "Trujeczka321321" ), login )
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "green" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "dafgudhg63268" ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "Trujeczka1233213" ), login )
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "green" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "gdfdcvhj" ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "*****" ), login )
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "green" )
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 , "changeMessage" , getRootElement (), "1" , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "green" )
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 , "changeMessage" , getRootElement (), "1" , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "green" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "*****" ) then
local query = exports [ "ogrpg-db" ]: dbSet ( "UPDATE ogrpg_users SET pass=? WHERE login=?" , teaEncode ( pass , "wypierdalacchuje" ), login )
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Zaaktualizowano twoj profil! Zaloguj sie ponownie!." , "green" )
return
end
if result [ 1 ]. login == login and result [ 1 ]. pass == teaEncode ( pass , "wypierdalacchuje" ) then
for i , player in pairs ( getElementsByType ( "player" )) do
if getElementData ( player , "player:uid" ) == result [ 1 ]. id then
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Kto? jest zalogowany na to konto!!!!!." , "red" )
return
end
end
if result [ 1 ]. login2 == false then
setPlayerName ( client , login )
else
setPlayerName ( client , result [ 1 ]. login2 )
triggerClientEvent ( client , "iyw_notifications:send" , client , "info" , "Wykupiono us?uge zmiana pseudonimu, tw?j nick to: " .. result [ 1 ]. login2 .. "" )
end
setElementData ( client , "player:uid" , result [ 1 ]. id )
-- setElementData ( client , "_zalogowany" , true )
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Zalogowa?e? si? pomy?lnie!" , "green" )
triggerClientEvent ( client , "saveXML" , getRootElement (), login , pass , tostring ( checkboxState ))
triggerClientEvent ( client , "hideLoginPanel" , getRootElement ())
triggerClientEvent ( client , "pokaz:wyborspawnu" , getRootElement ())
triggerEvent ( "SprawdzDom" , root , client )
if result [ 1 ]. register_serial == false then
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 , "changeMessage" , getRootElement (), "1" , "Podane dane s? nieprawid?owe." , "red" )
end
else
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Podany login nie istnieje w bazie." , "red" )
end
end
addEvent ( "onLogin" , true )
addEventHandler ( "onLogin" , getRootElement (), onLogin )
local maks_ilosc_kont = 2
function onRegister ( login , pass )
if string . len ( login ) > 22 or string . len ( pass ) > 22 and string . len ( login ) < 4 or string . len ( pass ) < 4 then
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Login/Has?o musz? mie? mniej ni? od 4 do 22 znak?w." , "red" )
return
end
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 , "changeMessage" , getRootElement (), "1" , "Na ten serial zostala utworzona maksymalna ilosc kont." , "red" )
return end
local result = exports [ "ogrpg-db" ]: dbGet ( "SELECT * FROM ogrpg_users WHERE login=?" , login )
if result and #result > 0 then
triggerClientEvent ( client , "changeMessage" , getRootElement (), "1" , "Podany login ju? istnieje w bazie." , "red" )
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 , "changeMessage" , getRootElement (), "1" , "Pomyslnie zarejestrowales(as) sie!" , "green" )
setElementData ( client , "player:logged" , true )
end
end
end
addEvent ( "onRegister" , true )
addEventHandler ( "onRegister" , getRootElement (), onRegister )
W kt?rej linijce mam to wpisa??
U mnie to 94
https://imgur.com/a/6HJnMJU
Nie b?d? taki z?y
local query = exports [ "ogrpg-db" ]: dbSet ( "INSERT INTO ogrpg_users (login,pass,register_serial,changedpw,premiumdate) VALUES (?,?,?,?,?)" , login , teaEncode ( pass , "*****" ), getPlayerSerial ( client ), 1 , "2019-04-04" ) masz
Ostatnio zmieniony przez Xrent 2019-01-03, 14:13, w całości zmieniany 1 raz
Więcej szczegółów
Wystawiono 1 piw(a):DaVeCS
Wysłany: 2019-01-03, 14:00
DaVeCS
Mapper
Wiek: 31 Na forum: 3386 dni Posty: 193
Nick w MP: DaVe
Piwa : 59
local query = exports [ "ogrpg-db" ]: dbSet ( "INSERT INTO ogrpg_users (login,pass,register_serial,changedpw,premiumdate) VALUES (?,?,?,?,200)" , login , teaEncode ( pass , "*****" ), getPlayerSerial ( client ), 1 )
Czy tak ma to wygl?da??
Wysłany: 2019-01-03, 14:14
Xrent
-
Wiek: 21 Na forum: 3047 dni Posty: 230
Nick w MP: Pazdam
Piwa : 535
"DaVeCS" napisał/a : local query = exports [ "ogrpg-db" ]: dbSet ( "INSERT INTO ogrpg_users (login,pass,register_serial,changedpw,premiumdate) VALUES (?,?,?,?,200)" , login , teaEncode ( pass , "*****" ), getPlayerSerial ( client ), 1 )
Czy tak ma to wygl?da??
Wy?ej da?em edytowa?em post i mia?em zw. Nie zapomnij o piwku i
Wysłany: 2019-01-10, 20:35
Loop
Inspektor
Wiek: 27 Na forum: 4289 dni Posty: 311
Nick w MP: Inspektor
Piwa : 201
local query = exports [ "ogrpg-db" ]: dbSet ( "INSERT INTO ogrpg_users (login,pass,register_serial,changedpw,premiumdate) VALUES (?,?,?,?,?)" , login , teaEncode ( pass , "*****" ), getPlayerSerial ( client ), 1 , "2019-04-04" )
Takim to sposobem ka?dy nie zale?nie kiedy si? zarejestruje b?dzie mia? premium do 2019-04-04.
Przyk?ad: Osoba kt?ra si? zarejestruje 2019-04-02 b?dzie mia?a dok?adnie premium na 2 dni.
Przy dodawaniu musisz pobra? aktualny czas i doda? te 200 dni.
Tagi: premium
Anonymous
Na forum: 245 dni
Posty: 1
Anonymous Koniecznie zajrzyj na: