[RELEASE] Condemned-MMO Website

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

Quote:

---

Originally Posted by theundead

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

---

GC is automatic after donation.

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

Quote:

---

Originally Posted by Rigor Mortis

GC is automatic after donation.

---

i was not sure of that as not tryed to donation yet :)