It says account doesnt exist when i tried to log in as admin

Page 2 of 2 1 2
07/04/2011 15:03 CaSTieL.URieL#16
Go to the dbo.Users_Master and check if there are accounts if not add one as i said u:

1 shaiya 0777 2010-08-07 17:50:00 True 255 False 16 0 NULL N NULL NULL NULL 10000000 NULL NULL
07/04/2011 18:41 BlueCh33se#17
Quote:
Originally Posted by CaSTieL.URieL View Post
Go to the dbo.Users_Master and check if there are accounts if not add one as i said u:

1 shaiya 0777 2010-08-07 17:50:00 True 255 False 16 0 NULL N NULL NULL NULL 10000000 NULL NULL

there is already the admin account there, i even tried making another account but it still persists and says account does not exist
07/04/2011 21:27 CaSTieL.URieL#18
Lol Delete PS_UserData and relink another psuserdata to the database
07/05/2011 21:12 ·Tyler·#19
Edit your login stored procedure to take out the OMG_GameWeb dependency, it's not needed, to do this, edit where the procedure calls for the Username and password from the dbo.Users_Master with the code below:

Code:
SELECT @UserUID=UserUID, @Status=Status, @Leave=Leave 
FROM Users_Master 
WHERE UserID = @UserID and Pw = @InPassword
Then comment out where it asks for the password from the OMG_GameWeb account table code below.

Code:
BEGIN
	 --Check Password
	EXEC dbo.sp_LoginSuccessCheck @UserID, @InPassword, @Check output
	IF ( @@ERROR = 0 )
	BEGIN
		IF( @Check <> 1 )
		BEGIN
			SET @Status = -1
		END
	END
	ELSE
	BEGIN
		SET @Status = -1
	END
After doing this, you can drop the OMG_GameWeb database, it will not be needed anymore. Hope this helps.

Tyler
Page 2 of 2 1 2