@ADM_SnooP Você não rodou as querys corretamente. faça o seguinte.
- Vá no seu Setting.php procure a linha @Verificação Rápida para Busca de Salas usando o ConnectServer. Coloque false lá. primeiro erro solucionado !
Segundo execute a query:
CREATE TABLE [dbo].[webBanneds] (
[name] [varchar] (12) COLLATE Latin1_General_CI_AS NOT NULL ,
[datebegin] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL ,
[dateend] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL ,
[type] [smallint] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webCash] (
[username] [varchar] (12) COLLATE Latin1_General_CI_AS NOT NULL ,
[amount] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webComplaints] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[username] [varchar] (12) COLLATE Latin1_General_CI_AS NOT NULL ,
[image] [varchar] (255) COLLATE Latin1_General_CI_AS NOT NULL ,
[description] [text] COLLATE Latin1_General_CI_AS NOT NULL ,
[date] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,
[ip] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,
[status] [smallint] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[webLogBuyCash] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[username] [varchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[cash] [int] NULL ,
[banco] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[nterminal] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ntransferencia] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[agencia_acolhedora] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[nsequencia] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ctr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[caixa_eletronico] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[nenvelope] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ndocumento] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ncontrole] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[noperador] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[data] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[hora] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[pago_em] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[anexo] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[comentario] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[valor] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[status] [int] NOT NULL ,
[comentario_adm] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[webLogBuyVips] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[username] [varchar] (12) COLLATE Latin1_General_CI_AS NOT NULL ,
[type] [smallint] NOT NULL ,
[cashAmount] [int] NOT NULL ,
[days] [smallint] NOT NULL ,
[date] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webNotices] (
[id] [smallint] IDENTITY (1, 1) NOT NULL ,
[subject] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,
[content] [text] COLLATE Latin1_General_CI_AS NOT NULL ,
[date] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[webPrevilegy] (
[id] [smallint] IDENTITY (1, 1) NOT NULL ,
[username] [varchar] (12) COLLATE Latin1_General_CI_AS NOT NULL ,
[previlegy] [smallint] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webRecord] (
[record] [smallint] NOT NULL ,
[date] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
GO
INSERT INTO [dbo].[webRecord] ([record],[date]) VALUES (0,0)
GO
CREATE TABLE [dbo].[webTickets] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[username] [varchar] (12) COLLATE Latin1_General_CI_AS NOT NULL ,
[character] [varchar] (12) COLLATE Latin1_General_CI_AS NOT NULL ,
[sector] [varchar] (20) COLLATE Latin1_General_CI_AS NOT NULL ,
[subject] [varchar] (30) COLLATE Latin1_General_CI_AS NOT NULL ,
[description] [text] COLLATE Latin1_General_CI_AS NOT NULL ,
[date] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL ,
[ip] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,
[status] [smallint] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[webTicketsAnswers] (
[id] [int] NOT NULL ,
[description] [text] COLLATE Latin1_General_CI_AS NOT NULL ,
[answerBy] [varchar] (12) COLLATE Latin1_General_CI_AS NOT NULL ,
[date] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[webVips] (
[username] [varchar] (12) COLLATE Latin1_General_CI_AS NOT NULL ,
[type] [smallint] NOT NULL ,
[datebegin] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL ,
[dateend] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[webPwdHashWrite]
@login VARCHAR(10),
@senha VARCHAR(10)
AS
BEGIN
DECLARE @Hash BINARY(16);
EXEC master..XP_MD5_EncodeKeyVal @senha, @login, @Hash OUT;
UPDATE MuOnline.dbo.MEMB_INFO SET memb__pwd = @Hash WHERE memb___id = @login;
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
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 @Valid int;
SET @Valid = 0;
IF @md5 = 1
BEGIN
DECLARE @Hash BINARY(16);
EXEC master..XP_MD5_EncodeKeyVal @senha, @login, @Hash OUT;
SELECT @Valid = 1 FROM MuOnline.dbo.MEMB_INFO WHERE memb___id = @login AND memb__pwd = @Hash;
END
IF @md5 = 0
BEGIN
SELECT @Valid = 1 FROM MuOnline.dbo.MEMB_INFO WHERE memb___id = @login AND memb__pwd = @Senha;
END
SELECT @Valid;
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
