Aqui está:
Código:
CREATE PROCEDURE WZ_CONNECT_MEMB
@uid varchar(20),
@server varchar(20),
@uip varchar(20)
as
begin
begin transaction
set nocount on
if exists (SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED) WHERE memb___id = @uid)
begin
UPDATE MEMB_STAT SET ip = @uip , connectstat = 0 , servername = @server , ConnectTM = (getdate()) WHERE memb___id = @uid;
UPDATE Character set MapNumber='0', MapPosX='125', MapPosY='125' WHERE AccountID = @uid AND MapNumber='30';
end
else
begin
INSERT INTO MEMB_STAT ( memb___id,ip,connectstat,servername) VALUES (@uid,@uip,1,@server)
end
if(@@error <> 0 )
rollback transaction
else
commit transaction
set nocount off
end
go
Com isso, no momento que a conta for logar, todos os chars da conta que estejam em valleyofloren serão movidos para dentro do bar de lorencia.