[Request] autoregister

[Advocate]

can someone post the procedure to make new accounts via game im tired of dealing with insecured panels.

[MentaL]

[shado165]

I have it ... but im not sure if it will works ;)

[Advocate]

CREATE PROCEDURE ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT

AS


select @nRet=count(*) from tb_user where straccountid=@AccountID
if @nRet=0
begin
insert into tb_user values (@AccountID , @Password , 1 , 6 , 1 ,1)
set @nRet=1
RETURN
end


DECLARE @Nero tinyint, @PlayerTurk smallint, @Lethe int, @Vipspawn int , @matrix1536 int
SET @Nero = 0
SET @PlayerTurk = 0

DECLARE @pwd varchar(13)

SET @pwd = null

IF @pwd <> @Password
BEGIN
SET @nRet = 3
RETURN
END

IF @Vipspawn=0
begin
set @nRet=11
RETURN
end
IF @Lethe = 0
begin
set @nRet=12
RETURN
end
IF @matrix1536=0
begin
set @nRet=4
RETURN
end

select @nRet=count(*) from currentuser where straccountid=@AccountID

IF @nRet>0
begin
set @nRet=5
RETURN
end



SELECT @Nero = bNation, @PlayerTurk = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @PlayerTurk = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = 1
RETURN
END

GO

wtf kind procedure is this??? has peoples names in it.... no thx

[iNeverDownAway]

Advocate add me msn
or just pm me at msn
ineverdownaway@hotmail.com
i will give u..

[Fjam]

Please can someone post the procedure?

[Si6]

Lmfao

As of today I resign from anywork involving with Knightonline Development.
It's been over 2 years in development and we as a whole have worked on same junk files, hand me downs, and half ass shit.

Development has lost its flair for me becuase some people has forgot the meaning of development. There letting greed, corruption, and vanity to get in the way of true development. Development is a learning phase for all but some that no longer applies.

It pointless to even try to develop with what we have
1098 many key features dont work or not working the way they should (capes , quest, skills, transformation scrolls , and events)

150X has many problems (armor bug, badly coded clients , map home cords, and few things listed with 1098)

1298 incomplete files ( the whole database structure, real login, billflex ect..)with out the key files this project will never get any further.

I had thought taking a break from ko things would change but i was wronge still same as before. and why continue. people just never gona change . they come here just to show off, or try to sell stuff knowing dam well people cannot and will not pay for stolen files that they leeched off someone eles.

I have wasted over 2 years on this project and still nothing good has come out of it. now its time to take my leave from it completly. tired of same crap everyday the bickering, showboating, disrespect that happens in the forums.
grown to old to tollerate it any longer..

as of today decided to work on other things then knightonline. SecretOnline is a project i was ask to help on think i will start with it see how it goes. have to files for it but there isnt english yet so alot of translation has to be done.

So dont bother me on msn about anything ko releated had enough of the bulshit that happens here.

Is this not a bit of a NOOB question when you have been in development for over 2 years and have your very own development forum for REAL developers?

[Fjam]

Lmfao



Is this not a bit of a NOOB question when you have been in development for over 2 years and have your very own development forum for REAL developers?

You are making advertisement of your own development KO forum on your signature, and you are desvirtuating this thread.

[Si6]

desvirtuating ---> hahahaha, run spellchecker please

dev forum, no! help forum yes.

[Si6]

USE [dbname]
GO
/****** Object: StoredProcedure [dbo].[ACCOUNT_LOGIN] Script Date: 07/22/2008 01:43:27 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.ACCOUNT_LOGIN Script Date: 6/6/2006 6:03:33 PM ******/


ALTER PROCEDURE [dbo].[ACCOUNT_LOGIN]
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS
-- Kubi3y

select @nRet = count(straccountid) from tb_user where straccountid = @AccountID

if @nRet = 0
begin
insert into tb_user (straccountid, strpasswd, strSocNo, idays) values (@AccountID, @password, 1, '6')
end

DECLARE @trance4ever int

--trance4ever tarafından editlenmistir.
select @trance4ever = count(straccountid) from dupe_check where straccountid = @AccountID
if @trance4ever <> 0
begin
set @nRet = 0
return
end

DECLARE @Nation tinyint
SET @Nation = 0
-- tid login method by samma 2004.02.24
DECLARE @pwd varchar(13)

SET @pwd = null

SELECT @pwd = strPasswd FROM TB_USER WHERE strAccountID = @AccountID
IF @pwd IS null
BEGIN
SET @nRet = 0
RETURN
END

DECLARE @gokhantasci varchar(21)
select @gokhantasci = count(straccountid) FROM premium_service WHERE strAccountID = @AccountID

if @gokhantasci = 0
begin
insert into PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3)
end

ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
RETURN
END

SELECT @Nation = bNation FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
BEGIN
SET @nRet = 1
RETURN
END
BEGIN
SET @nRet = @Nation+1
RETURN
-- Not my procedure, if it doesnt work i dont give a shit
END

NOOBIE DOOBIE DOOOOOO


now the problems most of u will face here is that it will take a little intelect to get this to work and to see what columns are needed.
...... probably waste of my time to post it ROFL
any1 here that can manage that?

[Advocate]

si go fuck your self only noob would go respond to some old post just to flame some NOOB>

[spamman]

Si, Perhaps Advocate doesn't know the SQL language?