Cevap: [EcheLonV6] ~ Expansion Database V6 ON ~ V5 OFF Usko Database ~ Yeni ~ Full Fx
Clan Bugu İçin
Kod.
USE [kn_online]
GO
/****** Object: StoredProcedure [dbo].[CREATE_KNIGHTS] Script Date: 01/11/2021 19:39:01 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.CREATE_KNIGHTS Script Date: 6/6/2006 6:03:32 PM ******/
-- modify by sungyong 2002.09.27
CREATE PROCEDURE [dbo].[CREATE_KNIGHTS]
@nRet smallint OUTPUT,
@index smallint,
@nation tinyint,
@community tinyint,
@strName char(21),
@strChief char(21)
AS
DECLARE @Row tinyint, @knightsindex smallint, @knightsname char(21)
SET @Row = 0 SET @knightsindex = 0 SET @knightsname = ''
SELECT @Row = COUNT(*) FROM KNIGHTS WHERE IDNum = @index or IDName = @strName
IF @Row > 0 or @index = 0
BEGIN
SET @nRet = 3
RETURN
END
--SELECT @Row = COUNT(*) FROM KNIGHTS WHERE IDName = @strName
--IF @Row > 0
-- BEGIN
-- SET @nRet = 3
--RETURN
-- END
-- Zenocide 11/1/09 Illigal Name block
IF
@strName like '% %' -- alt 32
or @strName like '% %' -- alt 255
or @strName like '% %' -- alt 0160
or @strName like '%staff%'
or @strName like '%GM%'
or @strName like '%fuck%'
or @strName like '%fuk%'
or @strName like '%nigg%'
or @strName like '%wank%'
BEGIN
ROLLBACK TRAN
SET @nRet = 5
RETURN
END
else
BEGIN TRAN
INSERT INTO KNIGHTS (IDNum, Nation, Flag, IDName, Chief)
VALUES (@index, @nation, @community, @strName, @strChief)
INSERT INTO KNIGHTS_USER (sIDNum, strUserID)
VALUES (@index, @strChief)
IF @@ERROR <> 0
BEGIN
ROLLBACK TRAN
SET @nRet = 6
RETURN
END
-- UPDATE USERDATA SET Knights = @index, Fame = 1 WHERE strUserId = @strChief -- 1 == Chief Authority
IF @@ERROR <> 0
BEGIN
ROLLBACK TRAN
SET @nRet = 6
RETURN
END
COMMIT TRAN
SET @nRet = 0