1
Herramientas / Re: ACTUALIZADOR CACHE WEBENGINE 1.2.0
« Posteado: June 04, 2021, 03:59:31 PM »
CAPOOOOOOOO MIL GRACIAS.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
CREATE PROCEDURE WZ_CONNECT_MEMBCitar
@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 = 1 , servername = @server , ConnectTM = (getdate())
WHERE memb___id = @uid
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
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE WZ_DISCONNECT_MEMBCitar
@uid 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 DisConnectTM = (getdate()), connectstat = 0 WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,DisConnectTM,connectstat) valueS (
@uid,
(getdate()),
0
)
End
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
End
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Si amigo todo eso hice todo eso y aún me sale el errorgracias por tu ayuda.. pero ya lo hice ejecute y la cree manualmente y aun sale eso :( estaba funcionando bien pero cambie de muonline a muonlines6 y empezo a salir eso.Cambiaste la configuración en el JoinServer modificaste el nombre de la base de datos?
Ejecutaste la DB pero editaste el archivo y le pusiste el nombre de la base de datos antes de ejecutar?