Site can be viewed here. Condemned MMO :: Home
Should have everything you need to get it up and running.
No Support!
Credits : @Valkyrie
https://mega.nz/#!udAzSbxA!1bmFTZnRP...vExDIx134SDi_w
https://forum.ragezone.com/cache.php...%2FgNQSOLI.jpg
Printable View
Site can be viewed here. Condemned MMO :: Home
Should have everything you need to get it up and running.
No Support!
Credits : @Valkyrie
https://mega.nz/#!udAzSbxA!1bmFTZnRP...vExDIx134SDi_w
https://forum.ragezone.com/cache.php...%2FgNQSOLI.jpg
Looks nice! Thank you for this :) Great constribute
Could you post the procedure: ECLIPSE_LOGIN?
EDIT: Okay, got it to work. It´s useless without the procedure and the half of the code is crap. If anyone need help with this, PM me.
ECLIPSE_LOGIN ? please
Don´t use the "EXECUTE" commands in login exec. Just use "SELECT...." and it will work fine
Here you go....
Quote:
ALTER PROCEDURE [dbo].[ECLIPSE_LOGIN] @in_Email varchar(100),
@in_Password varchar(100),
@in_IP varchar(100)
AS
BEGIN
SET NOCOUNT ON;
declare @CustomerID int
declare @AccountStatus int
declare @MD5Password varchar(100)
-- search for record with username
SELECT
@CustomerID=CustomerID,
@MD5Password=MD5Password,
@AccountStatus=AccountStatus
FROM Accounts
WHERE email=@in_Email
if (@@RowCount = 0) begin
--EXEC FN_ADD_SECURITY_LOG 100, @in_IP, 0, @in_Username
select
0 as CustomerID,
0 as AccountStatus
return
end
-- check MD5 password
declare @MD5FromPwd varchar(100)
exec FN_CreateMD5Password @in_Password, @MD5FromPwd OUTPUT
if(@MD5Password <> @MD5FromPwd) begin
--EXEC FN_ADD_SECURITY_LOG 101, @in_IP, @CustomerID, ''
select
0 as CustomerID,
0 as AccountStatus
return
end
-- status greater or equal to 200 means that user is banned
if (@AccountStatus >= 200) begin
select
0 as CustomerID,
@AccountStatus as AccountStatus
return
end
-- check if that is gamerstfirst user
declare @PastSessionKey varchar(50) = ''
declare @PastSessionID int = 0
SELECT @PastSessionKey=SessionKey FROM LoginSessions WHERE CustomerID = @CustomerID
SELECT @PastSessionID=SessionID FROM LoginSessions WHERE CustomerID = @CustomerID
-- update session key/id
declare @SessionKey varchar(50) = NEWID()
declare @SessionID int = checksum(@SessionKey)
if exists (SELECT CustomerID FROM LoginSessions WHERE CustomerID = @CustomerID)
begin
UPDATE LoginSessions SET
LoginIP=@in_IP,
TimeLogged=GETDATE(),
TimeUpdated=GETDATE(),
SessionKey = @SessionKey,
SessionID = @PastSessionID
WHERE CustomerID=@CustomerID
set @SessionID = @PastSessionID
set @SessionKey = @PastSessionKey
end
else
begin
INSERT INTO LoginSessions
(CustomerID, SessionKey, SessionID, LoginIP, TimeLogged, TimeUpdated)
VALUES
(@CustomerID, @SessionKey, @SessionID, @in_IP, GETDATE(), GETDATE())
end
INSERT INTO Logins
(CustomerID, LoginTime, IP, LoginSource)
VALUES
(@CustomerID, GETDATE(), @in_IP, 0)
select
@CustomerID as CustomerID,
@AccountStatus as AccountStatus,
@SessionID as SessionID
END
Not e-pin used ?
- - - Updated - - -
And donate
Can someone tell how to add this to SQL ?
thank you works fine and @ImmorTaLPaSa it donate panel in there you need to change the paypal part of it tho and works fine but you have to add the gc your self as not a auto gc system
I need help in SQL I put the code more when the "Execute " the following error Msg 208, Level 16 , State 6 , Procedure ECLIPSE_LOGIN , Line 99
Invalid object name ' dbo.ECLIPSE_LOGIN ' .
how to perform this ECLIPSE USE CODE SQL command or navecat ?
Guys change alter to create in eclipse like this
CREATE PROCEDURE [dbo].[ECLIPSE_LOGIN] @in_Email varchar(100),
@in_Password varchar(100),
@in_IP varchar(100)
AS
BEGIN
SET NOCOUNT ON;
declare @CustomerID int
declare @accountStatus int
declare @MD5Password varchar(100)
-- search for record with username
SELECT @CustomerID=CustomerID, @MD5Password=MD5Password, @accountStatus=AccountStatus
FROM Accounts
WHERE email=@in_Email
if (@@RowCount = 0) begin
--EXEC FN_ADD_SECURITY_LOG 100, @in_IP, 0, @in_Username
select
0 as CustomerID,
0 as AccountStatus
return
end
-- check MD5 password
declare @MD5FromPwd varchar(100)
exec FN_CreateMD5Password @in_Password, @MD5FromPwd OUTPUT
if @MD5Password <> @MD5FromPwd) begin
--EXEC FN_ADD_SECURITY_LOG 101, @in_IP, @CustomerID, ''
select
0 as CustomerID,
0 as AccountStatus
return
end
-- status greater or equal to 200 means that user is banned
if @accountStatus >= 200) begin
select
0 as CustomerID, @accountStatus as AccountStatus
return
end
-- check if that is gamerstfirst user
declare @PaSTSessionKey varchar(50) = ''
declare @PaSTSessionID int = 0
SELECT @PaSTSessionKey=SessionKey FROM LoginSessions WHERE CustomerID = @CustomerID
SELECT @PaSTSessionID=SessionID FROM LoginSessions WHERE CustomerID = @CustomerID
-- update session key/id
declare @SessionKey varchar(50) = NEWID()
declare @SessionID int = checksum @SessionKey)
if exists (SELECT CustomerID FROM LoginSessions WHERE CustomerID = @CustomerID)
begin
UPDATE LoginSessions SET
LoginIP=@in_IP,
TimeLogged=GETDATE(),
TimeUpdated=GETDATE(),
SessionKey = @SessionKey,
SessionID = @PaSTSessionID
WHERE CustomerID @CustomerID
set @SessionID = @PaSTSessionID
set @SessionKey = @PaSTSessionKey
end
else
begin
INSERT INTO LoginSessions
(CustomerID, SessionKey, SessionID, LoginIP, TimeLogged, TimeUpdated)
VALUES
@CustomerID, @SessionKey, @SessionID, @in_IP, GETDATE(), GETDATE())
end
INSERT INTO Logins
(CustomerID, LoginTime, IP, LoginSource)
VALUES
@CustomerID, GETDATE(), @in_IP, 0)
select @CustomerID as CustomerID, @accountStatus as AccountStatus, @SessionID as SessionID
END