Remover VIP - WebMorpheus - Outras Teams

[Denis Alves]

Olá gente!

Venho postar essa JOB que possa ser útil para alguns. Ela retira o VIP das contas de quem utiliza a Web Morpheus postada, só que em plataformas diferentes do MuEMU que não utilizem o sistema de verificação de contas como tem na mesma.

Acredito que tenham outros métodos mais fáceis, eu admito, mas esse funciona. Resumindo o que acontece, a cada 7 minutos ela faz verificação no banco de dados para ver quais as contas que já passaram do prazo do VIP acabar e retorna para FREE (Default 0).



USE [msdb]
GO


/****** Object: Job [Vip system] Script Date: 12/01/2019 11:32:52 ******/
BEGIN TRANSACTION
[Only registered and activated users can see links]
[Only registered and activated users can see links]
/****** Object: JobCategory [[Uncategorized (Local)]]] Script Date: 12/01/2019 11:32:52 ******/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]


END


[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
/****** Object: Step [Vip System] Script Date: 12/01/2019 11:32:53 ******/
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
[Only registered and activated users can see links]
EndSave:


GO


Obs.: Aonde está em destaque mude para o caminho do seu usuário administrativo e banco de dados utilizado para criar a JOB automaticamente.

Creditos: Denis :)

[godmorais]

Funciona em musite ?

[Denis Alves]

Funciona em musite ?

Hipoteticamente sim. Pois esse sistema ele vai retirar o vip da conta fazendo verificação diretamente na tabela do SQL. Ou seja, ele fará uma análise da data do plano vip adicionado, se passou um dia, uma hora ou um minuto do prazo ele retira. E, no musite, que tem o plugin para trabalhar com tabelas similares ao sistema de vip da Morpheus, então é bem capaz que sim

[admmu]

vc poderia montar uma Pra min usando o server IGC ele usa essa tabela






USE [MuOnline]GO


/****** Object: Table [dbo].[T_VIPList] Script Date: 07/12/2020 23:30:13 ******/
DROP TABLE [dbo].[T_VIPList]
GO


/****** Object: Table [dbo].[T_VIPList] Script Date: 07/12/2020 23:30:13 ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


SET ANSI_PADDING ON
GO


CREATE TABLE [dbo].[T_VIPList](
[AccountID] [varchar](10) NOT NULL,
[Date] [smalldatetime] NULL,
[Type] [tinyint] NULL,
CONSTRAINT [PK_T_VIPList] PRIMARY KEY CLUSTERED
(
[AccountID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


GO


SET ANSI_PADDING OFF
GO