1397 serverlarla ugrasanlar içeri

CREATE PROCEDURE MAIL_CHECK_NEWLETTER

@strUserID	varchar(21),

@type           tinyint,

@nRet		smallint	OUTPUT



AS



IF @type=0

BEGIN

SELECT @nRet=COUNT(*) from MAIL_ITEM WHERE tId = @strUserID AND  type=2 

RETURN

END



SELECT @nRet=COUNT(*) from MAIL_ITEM WHERE tId = @strUserID AND  type=@type

RETURN

GO

CREATE PROCEDURE MAIL_CHECK_USER

@strUserID	varchar(21),

@nRet		smallint	OUTPUT



AS



SELECT @nRet=COUNT(strUserID) FROM USERDATA WHERE strUserID = @strUserID



RETURN

GO

CREATE PROCEDURE MAIL_DELETE_OLDLETTER

AS

DECLARE @sTime smalldatetime,@eTime smalldatetime

SET @eTime=getdate()

UPDATE MAIL_ITEM SET updatetime=getdate(),tId=sId,title='????????????!'   WHERE  type=2 AND tid<>sId AND datediff(d,updatetime,@eTime) >7 

DELETE MAIL_ITEM WHERE sId=tId AND type=2 AND datediff(d,updatetime,@eTime) >7

GO

CREATE PROCEDURE MAIL_OPEN_NEWLETTER

@id	int,

@userid	char(21),

@bType	tinyint,

@nRet		smallint	OUTPUT



AS

DECLARE @sTime smalldatetime,@eTime smalldatetime,@mailid int,@bTrue tinyint,@type tinyint

SELECT @nRet=count(*) FROM MAIL_ITEM WHERE id=@id AND bType=@bType AND tId=@userid

IF @nRet=0

RETURN



SELECT @nRet=count(*) FROM MAIL_ITEM WHERE bType=@bType AND tId=@userid AND type=3



SELECT @sTime=updatetime, @mailid = id, @bTrue=bAccess,@type=type FROM MAIL_ITEM WHERE id=@id AND bType=@bType AND tId=@userid

SET @eTime=getdate()



IF @bTrue<>2 AND @type<>3 AND @nRet<10

BEGIN

UPDATE MAIL_ITEM SET type=3, bDay=7-datediff(d,@sTime,@eTime) WHERE id=@mailid

END 



SELECT id,content FROM MAIL_ITEM WHERE id=@mailid

SET @nRet=1

RETURN

GO

CREATE PROCEDURE MAIL_TAKE_LETTERITEM

@id	int,

@userid	char(21),

@bType	tinyint,

@nRet		smallint	OUTPUT



AS

DECLARE @sTime smalldatetime,@eTime smalldatetime,@mailid int,@bTrue tinyint

SELECT @nRet=count(id) FROM MAIL_ITEM WHERE id=@id AND bType=@bType AND tId=@userid AND type=2 AND bAccess=2

IF @nRet=0

RETURN



SELECT @nRet=count(id) FROM MAIL_ITEM WHERE bType=@bType AND tId=@userid AND type=3

IF @nRet>=10

BEGIN

SET @nRet=0

RETURN

END



SELECT @sTime=updatetime, @mailid = id FROM MAIL_ITEM WHERE id=@id AND bType=@bType AND tId=@userid  AND type=2  AND bAccess=2

SET @eTime=getdate()

UPDATE MAIL_ITEM SET type=3, bDay=7-datediff(d,@sTime,@eTime) WHERE id=@mailid

SELECT itemid,sDur,sCount,serial,gold  FROM MAIL_ITEM WHERE id=@mailid

SET @nRet=1

RETURN

GO

INSERT INTO 

MAIL_ITEM (bType, sId, tId, title, bAccess, content, type, gold, itemId, sDur, sCount, serial, pos, bDay) 

VALUES 

(6, 'KOLADMIN', '[COLOR="red"]GidecekCharIsmi[/COLOR]', 'KOLADMIN', 2, '[COLOR="Red"]Mesajımız...[/COLOR]', 2, '[COLOR="red"]PARA[/COLOR]','[COLOR="red"]İtem Kodu[/COLOR]',1,1,0,0,7)

Kod:

/****** Object: Stored Procedure dbo.CREATE_NEW_CHAR script Date: 20/7/2006 11:03:33 ** ******/





/****** 개체: 저장 프로시저 dbo.CREATE_NEW_CHAR 스크립트 날짜: 2009-07-20 오전 11:18:03 ******/





-- scripted by cubeRt



CREATE PROCEDURE CREATE_NEW_CHAR



@nRet	 smallint OUTPUT, 

@AccountID char(21), 

@index tinyint,

@CharID	char(21),

@Race tinyint, 

 [MENTION=2874]class[/MENTION] smallint, 

@Hair tinyint,

@Face tinyint, 

@Str tinyint, 

@Sta tinyint, 

@Dex tinyint,

@Intel tinyint, 

@Cha tinyint



AS



DECLARE @Row tinyint, @Nation tinyint, @Zone tinyint, @PosX int, @PosZ int

SET @Row = 0	SET @Nation = 0 SET @Zone = 0 SET @PosX = 0 SET @PosZ = 0



SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID



IF @Row >= 5	SET @nRet = 1



IF @Nation = 1 AND @Race > 10	SET @nRet = 2

ELSE IF @Nation = 2 AND @Race < 10	SET @nRet = 2

ELSE IF @Nation <>1 AND @Nation <> 2	SET @nRet = 2



IF @nRet > 0

RETURN



SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID

IF @Row > 0 

BEGIN

SET @nRet = 3

RETURN

END



--SET @Zone = @Nation

SET @Zone=21

SELECT @PosX = InitX, @PosZ = InitZ FROM ZONE_INFO WHERE ZoneNo = @Zone





BEGIN TRAN	

IF @index = 0

UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 1

UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 2

UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 3

UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 4

UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID





INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ ) 

VALUES	 (@CharID, @Nation, @Race, [MENTION=2874]class[/MENTION], @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ )





IF @@ERROR <> 0

BEGIN	

ROLLBACK TRAN 

SET @nRet = 4

RETURN

END



COMMIT TRAN

SET @nRet = 0

GO