x-MU.net форум

Есть такая хитрость когда сливают в калиме, закрываем клиент Alt+F4 .. заходим и мы на том же месте где нас слили .. В общем, вот измененная процедура WZ_DISCONNECT_MEMB .. при выходе с акк всех персонажей, которые в калиме мувает в Лору 142Х135

В этом почти ноль, потому код для знающих людей может показать корявым, да просто гавно-кодом, если так то переделайте правильней

Замените существующую процедуру на эту
CREATE PROCEDURE WZ_DISCONNECT_MEMB
@memb___id varchar(10)
AS
Begin
set nocount on
Declare  @find_id varchar(10)
Declare @ConnectStat tinyint
Set @ConnectStat = 0
Set @find_id = 'NOT'
select @find_id = S.memb___id from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id = I.memb___id
where I.memb___id = @memb___id

if( @find_id <> 'NOT' )
begin
update MEMB_STAT set ConnectStat = @ConnectStat, DisConnectTM = getdate()
where memb___id = @memb___id

Declare @g1 varchar(10), @g2 varchar(10), @g3 varchar(10), @g4 varchar(10), @g5 varchar(10), @MapNumber_data SMALLINT
select @g1=GameID1, @g2=GameID2, @g3=GameID3, @g4=GameID4, @g5=GameID5 FROM dbo.AccountCharacter Where Id = @memb___id
if @g1 IS NOT NULL
begin
select @MapNumber_data=MapNumber from dbo.Character where Name = @g1 AND AccountID = @memb___id
if(@MapNumber_data > 23 AND @MapNumber_data < 30)
begin
update Character set MapNumber = 0, MapPosX = 142, MapPosY = 135 where Name = @g1 AND AccountID = @memb___id
end
if(@MapNumber_data = 36)
begin
update Character set MapNumber = 0, MapPosX = 142, MapPosY = 135 where Name = @g1 AND AccountID = @memb___id
end
end
if @g2 IS NOT NULL
begin
select @MapNumber_data=MapNumber from dbo.Character where Name = @g2 AND AccountID = @memb___id
if(@MapNumber_data > 23 AND @MapNumber_data < 30)
begin
update Character set MapNumber = 0, MapPosX = 142, MapPosY = 135 where Name = @g2 AND AccountID = @memb___id
end
if(@MapNumber_data = 36)
begin
update Character set MapNumber = 0, MapPosX = 142, MapPosY = 135 where Name = @g2 AND AccountID = @memb___id
end
end
if @g3 IS NOT NULL
begin
select @MapNumber_data=MapNumber from dbo.Character where Name = @g3 AND AccountID = @memb___id
if(@MapNumber_data > 23 AND @MapNumber_data < 30)
begin
update Character set MapNumber = 0, MapPosX = 1402, MapPosY = 135 where Name = @g3 AND AccountID = @memb___id
end
if(@MapNumber_data = 36)
begin
update Character set MapNumber = 0, MapPosX = 142, MapPosY = 135 where Name = @g3 AND AccountID  = @memb___id
end
end
if @g4 IS NOT NULL
begin
select @MapNumber_data=MapNumber from dbo.Character where Name = @g4 AND AccountID = @memb___id
if(@MapNumber_data > 23 AND @MapNumber_data < 30)
begin
update Character set MapNumber = 0, MapPosX = 142, MapPosY = 135 where Name = @g4 AND AccountID = @memb___id
end
if(@MapNumber_data = 36)
begin
update Character set MapNumber = 0, MapPosX = 142, MapPosY = 135 where Name = @g4 AND AccountID = @memb___id
end
end
if @g5 IS NOT NULL
begin
select @MapNumber_data=MapNumber from dbo.Character where Name = @g5 AND AccountID = @memb___id
if(@MapNumber_data > 23 AND @MapNumber_data < 30)
begin
update Character set MapNumber = 0, MapPosX = 142, MapPosY = 135 where Name = @g5 AND AccountID = @memb___id
end
if(@MapNumber_data = 36)
begin
update Character set MapNumber = 0, MapPosX = 142, MapPosY = 135 where Name = @g5 AND AccountID = @memb___id
end
end
end
end
GO