anyone who can give a full guide on where to edit this.
if i login on the server with incorrect password it will tell "incorrect password"
if i login a nonregistred account it will tell also "account not register"
if i login a account that has been login it will tell "user is already login"
is it on the Rohanauth/or on the dbo.rohan3_sendcode/dbo.rohan4_login?? anyone who can help us with this?
USE [RohanUser]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[LOCAL3_CheckAuth](
@login_id nvarchar(20)
,@login_pw nvarchar(50)
,@ip nvarchar(20)
,@grade tinyint output
,@species int output
,@bill_no int output
)
AS
SET NOCOUNT ON
declare @ret int
declare @pw nvarchar(50)
set @grade = 0
set @ret = 0;
select @pw = right(login_pw,32), @species = species, @grade = grade, @bill_no = bill_no
from tuser
where login_id = @login_id
if @pw is null set @ret = -1 -- incorect username
else if @pw <> @login_pw set @ret = -2 -- incorect pasword
else if exists(select user_id from tdeluser where login_id = @login_id) set @ret = -5 -- deleted username
else if exists(select id from sanction where id = @login_id) set @ret = -3 -- banned
else if exists(select ip from cut_ip where ip = @ip) set @ret = -4 -- ip ban
return @ret
It's up to you guys to check all the cases. I tested it locally and it outputs the desired results.
[REQUEST] "wrong password" or "wroong id" packets headers 01/10/2013 - Kal Online - 4 Replies Hello everyone , as mentioned above , i need headers for "wrong password" or " id doesn't exist" headers when attempting to login .
thanks =]
