Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: Query MasterSkillTree = Dbo.Character SET LevelUpPoint=LevelUpPoint+5  (Visto 973 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline wellwisher22 Posteado: September 28, 2021, 04:15:08 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 333
  • Gracias recibida: 3508
  • br
Alguém poderia me ajudar com uma quero que ao aumentar 1 level de MasterLevel ganhar 5 LevelupPoint

Gracias:


Offline wellwisher22 #1 Posteado: September 28, 2021, 09:49:28 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 333
  • Gracias recibida: 3508
  • br
Alguém para me ajudar com essa Query??
Funciona mas dá pontos a todos os personagens de todas as contas!

USE [MuOnline]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[PontosPorML]
ON [dbo].[MasterSkillTree]
after update
as
IF UPDATE(MasterLevel)
begin SET NOCOUNT ON;
Update [Character] set [Character].LevelUpPoint=LevelUpPoint+10
end


Offline wellwisher22 #2 Posteado: September 29, 2021, 01:31:47 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 333
  • Gracias recibida: 3508
  • br

Offline wellwisher22 #3 Posteado: October 03, 2021, 04:06:40 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 333
  • Gracias recibida: 3508
  • br

Offline lunaticodeveloper #4 Posteado: October 03, 2021, 08:38:20 PM

  • MAESTRO

  • US. DE HONOR

  • Anunciante
  • +4 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 1.790
  • Gracias recibida: 28171
  • ar
te esta faltando agregarle el where que identifique el personaje amigo :)

Soporte premium ya sabes contactame!
Experto en MuOnline! Mira mis aportes de primera!


Offline Pinponw #5 Posteado: October 04, 2021, 07:47:50 PM

  • 0 puntos por ventas
  • *
  • Rank: Principiante
  • Posts: 16
  • Gracias recibida: 13
  • br
USE [MuOnline]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[PontosPorML]
ON [dbo].[MasterSkillTree]
after update
as
IF UPDATE(MasterLevel)
begin SET NOCOUNT ON;
Update [Character] set [Character].LevelUpPoint=LevelUpPoint+10 where AccountID=Name
end


Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
3 Replies
2294 Views
Last post May 30, 2019, 06:00:26 PM
by josexluis
0 Replies
908 Views
Last post November 08, 2018, 09:37:27 AM
by CAPITOL
0 Replies
806 Views
Last post January 05, 2019, 09:30:00 PM
by CAPITOL
2 Replies
1573 Views
Last post August 31, 2019, 06:07:48 PM
by Yan Carlos
2 Replies
1320 Views
Last post October 18, 2019, 12:27:25 AM
by c4nhsatcodong