OYun İçi Ncs Bugsuz

Kod:
CREATE PROCEDURE CHANGE_NEW_ID
@byType char(21),
@AccountID char(21),
@charid char(21),
@newid char(21),
@nRet smallint output
as
-- created by hasan 20/06/2008 reason : can skintisi
-- sanirim dahasi yok bütün hepsini updateledik.

--fixed dupid by Cecil
--Düzenleme TheDark

DECLARE @dupid INT

SELECT @dupid = struserid FROM [userdata] WHERE [struserid] = @newid
if @dupid = 1
BEGIN

SET @nRet = 1
RETURN
END

BEGIN
BEGIN TRAN
DELETE FROM userdata WHERE struserid = @newid


END

BEGIN

update userdata set strUserID = @newid where strUserID = @charid
update currentuser set strCharID = @newid where strCharID = @charid
update friend_list set strUserID = @newid where strUserID = @charid
update king_ballot_box set strCharID = @newid where strCharID = @charid
update king_candidacy_notice_board set strUserID = @newid where strUserID = @charid
update king_election_list set strName = @newid where strName = @charid
update king_system set strKingName = @newid where strKingName = @charid
update rental_item set strLenderCharID = @newid where strLenderCharID = @charid
update rental_item set strBorrowerCharID = @newid where strBorrowerCharID = @charid
update rental_item_list set strBorrowerCharID = @newid where strBorrowerCharID = @charid
update account_char set strCharID1 = @newid where strCharID1 = @charid
update account_char set strCharID2 = @newid where strCharID2 = @charid
update account_char set strCharID3 = @newid where strCharID3 = @charid


end
GO