[glow=green,2,300]Roda essa query manow[/glow]
USE [master]
GO
sp_addextendedproc 'XP_MD5_EncodeKeyVal', 'WZ_MD5_MOD.dll'
GO
sp_addextendedproc 'XP_MD5_CheckValue', 'WZ_MD5_MOD.dll'
GO
USE [MuOnline]
GO
ALTER TABLE dbo.MEMB_INFO ADD data datetime NULL
GO
ALTER TABLE dbo.MEMB_INFO ADD aniversario nvarchar(50) NULL
GO
ALTER TABLE dbo.MEMB_INFO ADD [vip] [smallint] NOT NULL DEFAULT 0
GO
ALTER TABLE dbo.MEMB_INFO ADD [type] [smallint] NOT NULL DEFAULT 0
GO
ALTER TABLE dbo.MEMB_INFO ADD [datebegin] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL DEFAULT 0
GO
ALTER TABLE dbo.MEMB_INFO ADD [dateend] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL DEFAULT 0
GO
ALTER TABLE dbo.MEMB_INFO ADD [amount] [int] NOT NULL DEFAULT 0
GO
ALTER TABLE dbo.MEMB_INFO ADD [gold] [int] NOT NULL DEFAULT 0
GO
ALTER TABLE dbo.Character ADD resetsWeek int NOT NULL DEFAULT 0
GO
ALTER TABLE dbo.Character ADD resetsMonth int NOT NULL DEFAULT 0
GO
ALTER TABLE dbo.Character ADD PkCountWeb int NOT NULL DEFAULT 0
GO
ALTER TABLE dbo.Character ADD Resets int NOT NULL DEFAULT 0
GO
ALTER TABLE dbo.Character ADD MResets int NOT NULL DEFAULT 0
GO
ALTER TABLE dbo.[Character] ADD image varchar(50) NULL
GO
CREATE TABLE [dbo].[ExtWareHouseVirtual](
[Number] [bigint] IDENTITY(1,1) NOT NULL,
[AccountId] [varchar](10) NOT NULL,
[item] [varbinary](16) NOT NULL,
[dbVersion] [tinyint] NOT NULL CONSTRAINT [DF_ExtWareHouseVirtual_dbVersion] DEFAULT ((0))
) ON [PRIMARY]
GO
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,
[description] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[bannedBy] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webCash](
[username] [varchar](12) NOT NULL,
[amount] [int] NOT NULL DEFAULT ((0)),
[amount2] [int] NOT NULL DEFAULT ((0))
) 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
CREATE TABLE [dbo].[webSendEmailLimit] (
[username] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[dateRequest] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[webSendEmailLimit] WITH NOCHECK ADD
CONSTRAINT [PK_webSendEmailLimit] PRIMARY KEY CLUSTERED
(
[username]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webPollQuestions](
[id] [int] IDENTITY(1,1) NOT NULL,
[question] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[active] [bit] NOT NULL CONSTRAINT [DF_webPollQuestions_active] DEFAULT ((0))
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webPollAnswers](
[idAnswer] [int] IDENTITY(1,1) NOT NULL,
[idPoll] [int] NOT NULL,
[answer] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[votes] [int] NOT NULL CONSTRAINT [DF_webPollAnswers_votes] DEFAULT ((0))
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webPollIps] (
[ip] [varchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[requestTime] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[webPollIps] WITH NOCHECK ADD
CONSTRAINT [PK_webPollIps] PRIMARY KEY CLUSTERED
(
[ip]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webCronjobConfig](
[execute] [bit] NOT NULL,
[lastExecution] [bigint] NOT NULL CONSTRAINT [DF_webCronjobConfig_lastExecution] DEFAULT ((0))
) ON [PRIMARY]
GO
INSERT INTO [dbo].[webCronjobConfig] ([execute]) VALUES (0);
GO
CREATE TABLE [dbo].[webRankingCharactersLevel](
[id] [int] IDENTITY(1,1) NOT NULL,
[account] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[character] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[clevel] [smallint] NOT NULL,
[pkcount] [int] NOT NULL,
[resets] [int] NOT NULL,
[mresets] [int] NOT NULL,
[resetsweek] [int] NOT NULL,
[resetsmonth] [int] NOT NULL,
[class] [smallint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[webRankingCharactersLevel] WITH NOCHECK ADD
CONSTRAINT [PK_webRankingCharactersLevel] PRIMARY KEY CLUSTERED
(
[account],
[character]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webRankingCharactersMasterReset](
[id] [int] IDENTITY(1,1) NOT NULL,
[account] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[character] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[clevel] [smallint] NOT NULL,
[pkcount] [int] NOT NULL,
[resets] [int] NOT NULL,
[mresets] [int] NOT NULL,
[resetsweek] [int] NOT NULL,
[resetsmonth] [int] NOT NULL,
[class] [smallint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[webRankingCharactersMasterReset] WITH NOCHECK ADD
CONSTRAINT [PK_webRankingCharactersMasterReset] PRIMARY KEY CLUSTERED
(
[account],
[character]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webRankingCharactersPk](
[id] [int] IDENTITY(1,1) NOT NULL,
[account] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[character] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[clevel] [smallint] NOT NULL,
[pkcount] [int] NOT NULL,
[resets] [int] NOT NULL,
[mresets] [int] NOT NULL,
[resetsweek] [int] NOT NULL,
[resetsmonth] [int] NOT NULL,
[class] [smallint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[webRankingCharactersPk] WITH NOCHECK ADD
CONSTRAINT [PK_webRankingCharactersPk] PRIMARY KEY CLUSTERED
(
[account],
[character]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webRankingCharactersResets](
[id] [int] IDENTITY(1,1) NOT NULL,
[account] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[character] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[clevel] [smallint] NOT NULL,
[pkcount] [int] NOT NULL,
[resets] [int] NOT NULL,
[mresets] [int] NOT NULL,
[resetsweek] [int] NOT NULL,
[resetsmonth] [int] NOT NULL,
[class] [smallint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[webRankingCharactersResets] WITH NOCHECK ADD
CONSTRAINT [PK_webRankingCharactersResets] PRIMARY KEY CLUSTERED
(
[account],
[character]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webRankingCharactersResetsMonth](
[id] [int] IDENTITY(1,1) NOT NULL,
[account] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[character] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[clevel] [smallint] NOT NULL,
[pkcount] [int] NOT NULL,
[resets] [int] NOT NULL,
[mresets] [int] NOT NULL,
[resetsweek] [int] NOT NULL,
[resetsmonth] [int] NOT NULL,
[class] [smallint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[webRankingCharactersResetsMonth] WITH NOCHECK ADD
CONSTRAINT [PK_webRankingCharactersResetsMonth] PRIMARY KEY CLUSTERED
(
[account],
[character]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webRankingCharactersResetsWeek](
[id] [int] IDENTITY(1,1) NOT NULL,
[account] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[character] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[clevel] [smallint] NOT NULL,
[pkcount] [int] NOT NULL,
[resets] [int] NOT NULL,
[mresets] [int] NOT NULL,
[resetsweek] [int] NOT NULL,
[resetsmonth] [int] NOT NULL,
[class] [smallint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[webRankingCharactersResetsWeek] WITH NOCHECK ADD
CONSTRAINT [PK_webRankingCharactersResetsWeek] PRIMARY KEY CLUSTERED
(
[account],
[character]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webNoticesComments](
[id] [int] IDENTITY(1,1) NOT NULL,
[idNotice] [smallint] NOT NULL,
[username] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[comment] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[datePost] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[remoteAddr] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[webScreenshots](
[id] [int] IDENTITY(1,1) NOT NULL,
[image] [varchar](50) NOT NULL,
[uploadBy] [varchar](10) NOT NULL,
[date] [int] NOT NULL,
[rate] [tinyint] NOT NULL,
[legend] [varchar](50) NOT NULL,
[sw] [smallint] NOT NULL CONSTRAINT [DF_webScreenshots_sw] DEFAULT ((0)),
[sy] [smallint] NOT NULL CONSTRAINT [DF_webScreenshots_sy] DEFAULT ((0)),
[cw] [smallint] NOT NULL CONSTRAINT [DF_webScreenshots_cw] DEFAULT ((0)),
[cy] [smallint] NOT NULL CONSTRAINT [DF_webScreenshots_cy] DEFAULT ((0))
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[webScreenshotsIps](
[id] [int] IDENTITY(1,1) NOT NULL,
[login] [varchar](10) NULL,
[ip] [varchar](15) NOT NULL,
[timestamp] [int] NOT NULL
) ON [PRIMARY]
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
