Problema Template de MuSite

To usando na vps, erro sem imagem e login como resolve?


[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

Amigo eu lembro na época que esse template da NessTeam foi compartilhado na internet, é você precisa fazer alguns ajustes manuais para ele funcionar corretamente. ^^

Para segundo erro, você precisa rodar essa query

Código:

---

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[webVerifyLogin]
@login VARCHAR(10),
@senha VARCHAR(10),
@md5 int
AS
BEGIN
DECLARE @[Only registered and activated users can see links. Click Here To Register...]id int;
SET @[Only registered and activated users can see links. Click Here To Register...]id = 0;


IF @md5 = 1
BEGIN
    DECLARE @Hash BINARY(16);
    EXEC master..XP_MD5_EncodeKeyVal @senha, @login, @Hash OUT;
    SELECT @[Only registered and activated users can see links. Click Here To Register...]id = 1 FROM MuOnline.dbo.MEMB_INFO WHERE memb___id = @login AND memb__pwd = @Hash;
END
IF @md5 = 0
BEGIN
    SELECT @[Only registered and activated users can see links. Click Here To Register...]id = 1 FROM MuOnline.dbo.MEMB_INFO WHERE memb___id = @login AND memb__pwd = @Senha;
END


SELECT @[Only registered and activated users can see links. Click Here To Register...]id;
END

---

Para segundo erro, você precisa rodar essa query

Código:

---

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[webVerifyLogin]
@login VARCHAR(10),
@senha VARCHAR(10),
@md5 int
AS
BEGIN
DECLARE @[Only registered and activated users can see links. Click Here To Register...]id int;
SET @[Only registered and activated users can see links. Click Here To Register...]id = 0;


IF @md5 = 1
BEGIN
    DECLARE @Hash BINARY(16);
    EXEC master..XP_MD5_EncodeKeyVal @senha, @login, @Hash OUT;
    SELECT @[Only registered and activated users can see links. Click Here To Register...]id = 1 FROM MuOnline.dbo.MEMB_INFO WHERE memb___id = @login AND memb__pwd = @Hash;
END
IF @md5 = 0
BEGIN
    SELECT @[Only registered and activated users can see links. Click Here To Register...]id = 1 FROM MuOnline.dbo.MEMB_INFO WHERE memb___id = @login AND memb__pwd = @Senha;
END


SELECT @[Only registered and activated users can see links. Click Here To Register...]id;
END

---

[/QUOTE]


Bom dia @[Only registered and activated users can see links. Click Here To Register...], nao deu certo olha aqui print

[Only registered and activated users can see links. Click Here To Register...]

É simples, meu amigo... A database "MuOnline" não existe em seu banco de dados, como quer que a Web verifique os login's através dela???