Oyun İçi Clan Devretme Usko Tarzı

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[clandevret]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[clandevret]

GO



CREATE TABLE [dbo].[clandevret] (

    [devreden] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [alan] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [clanadi] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [kayit] [int] NULL ,

    [vicefame] [int] NULL ,

    [zaman] [datetime] NULL 

) ON [PRIMARY]

GO

declare @charId varchar(21),

@fame2 Int,

@kayIt2 Int,

@devreden varchar(21),

@alan varchar(21)

select @alan = alan from clandevret where alan = @struserID or devreden = @struserID

select @devreden = devreden from clandevret where alan = @struserID or devreden = @struserID

select @fame2 = vIcefame from clandevret where devreden = @struserID

select @charId = strcharId1 from account_char where straccountId = @accountId

select @kayIt2 = kayIt from clandevret where devreden =  @struserID or alan = @struserID

If @kayIt2 = 0

begIn

update userdata set fame = @fame2 where struserId = @devreden

update userdata set fame = 1 where struserId = @alan

update clandevret set kayIt = 1 where devreden = @struserID or alan = @struserID

end

EVENT 41801 ;clandevret

E SELECT_MSG 16544 19545 18855 18866 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1

END



EVENT 18866 ; 

E SEND_WEBPAGE_ADDRESS 5

END

delete from k_npcpos where npcid = 18445 and zoneid = 21



insert into [K_NPC] values ('18445','[Clan Devret]','2050','100','971650940','971720780','1','0','28','1','1','1','0','90','0','0','100000','0','0','15000','497','497','0','1500','0','0','1000','0','0','0','255','255','255','255','255','255','255','200','30','35','35','0','0','1','1','0');



insert into [k_npcpos] values ('21','18445','103','0','0','0','19','330','359','330','359','330','359','330','359','1','4400','0','3','NULL');