Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: Template MuStronda [ EFFECT WEB ]  (Visto 3083 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline iCoder Posteado: November 22, 2018, 06:46:58 PM | Modificado: October 23, 2019, 09:33:56 PM by iCoder

  • C# Coder
  • 0 puntos por ventas
  • *
  • Rank: Destacado
  • Posts: 93
  • Gracias recibida: 3295
  • br
Aluguel de licenças.
www.masterteam.com.br

Offline Cloud #1 Posteado: November 22, 2018, 07:04:47 PM

  • 0 puntos por ventas
  • *
  • Rank: Avanzado
  • Posts: 138
  • Gracias recibida: 12015
  • ar
Tema movido a su sección correspondiente

Gracias:


Offline llguhll4 #2 Posteado: January 09, 2019, 05:13:10 PM

  • 0 puntos por ventas
  • *
  • Rank: Principiante
  • Posts: 1
  • Gracias recibida: 0
  • br
CTM-Error #2: Erro ao executar Query : "SELECT login,block FROM MuOnline.dbo.brute_force WHERE login='accadm'"


Offline iCoder #3 Posteado: April 22, 2019, 12:12:15 AM

  • C# Coder
  • 0 puntos por ventas
  • *
  • Rank: Destacado
  • Posts: 93
  • Gracias recibida: 3295
  • br
CTM-Error #2: Erro ao executar Query : "SELECT login,block FROM MuOnline.dbo.brute_force WHERE login='accadm'"

USE [MuOnline]
GO
/****** Object:  Table [dbo].[BRUTE_FORCE]    Script Date: 10/13/2015 16:38:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BRUTE_FORCE](
   [login] [nvarchar](10) COLLATE Latin1_General_CI_AS NULL,
   [tentativas] [int] NOT NULL CONSTRAINT [DF_BRUTE_FORCE_tentativas]  DEFAULT ((0)),
   [block] [int] NOT NULL CONSTRAINT [DF_BRUTE_FORCE_block]  DEFAULT ((0))
) ON [PRIMARY]





USE [msdb]
GO
/****** Object:  Job [Proteção contra Brute  - EffectWeb]    Script Date: 10/13/2015 16:46:09 ******/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/****** Object:  JobCategory [[Uncategorized (Local)]]]    Script Date: 10/13/2015 16:46:09 ******/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)
BEGIN
EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END

DECLARE @jobId BINARY(16)
EXEC @ReturnCode =  msdb.dbo.sp_add_job @job_name=N'Proteção contra Brute  - EffectWeb',
      @enabled=1,
      @notify_level_eventlog=0,
      @notify_level_email=0,
      @notify_level_netsend=0,
      @notify_level_page=0,
      @delete_level=0,
      @description=N'No description available.',
      @category_name=N'[Uncategorized (Local)]',
      @owner_login_name=N'sa', @job_id = @jobId OUTPUT
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
/****** Object:  Step [1]    Script Date: 10/13/2015 16:46:09 ******/
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'1',
      @step_id=1,
      @cmdexec_success_code=0,
      @on_success_action=1,
      @on_success_step_id=0,
      @on_fail_action=2,
      @on_fail_step_id=0,
      @retry_attempts=0,
      @retry_interval=0,
      @os_run_priority=0, @subsystem=N'TSQL',
      @command=N'delete from brute_force where tentativas > 2',
      @database_name=N'MuOnline',
      @flags=0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'2',
      @enabled=1,
      @freq_type=4,
      @freq_interval=1,
      @freq_subday_type=4,
      @freq_subday_interval=5,
      @freq_relative_interval=0,
      @freq_recurrence_factor=0,
      @active_start_date=20151013,
      @active_end_date=99991231,
      @active_start_time=0,
      @active_end_time=235959
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
   IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:

Aluguel de licenças.
www.masterteam.com.br

Gracias:


Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
4 Replies
3053 Views
Last post April 22, 2019, 12:11:10 AM
by iCoder
0 Replies
1745 Views
Last post August 02, 2019, 01:45:43 PM
by alefmello1
0 Replies
1816 Views
Last post August 02, 2019, 05:00:22 PM
by alefmello1
0 Replies
1985 Views
Last post August 02, 2019, 05:11:33 PM
by alefmello1
1 Replies
581 Views
Last post October 05, 2020, 12:49:29 PM
by Ravoc