Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: Sentencia SQL para dar puntos  (Visto 1047 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline Evangelio Posteado: August 01, 2017, 07:15:31 PM | Modificado: August 01, 2017, 07:50:41 PM by ZabiinoOo

  • 0 puntos por ventas
  • *
  • Rank: Heroe
  • Posts: 172
  • Gracias recibida: 763
  • ar
Alguien me podria pasar una sentencia SQL para dar puntos a todos los personajes recien creados porfavor. Uso SQL_2008 Files MuEmu


Offline firemarcos #1 Posteado: August 01, 2017, 07:23:36 PM

  • MAESTRO

  • US. DE HONOR

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 781
  • Gracias recibida: 21954
  • ar
Code: [Select]
USE MuOnline
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'Bonus' AND type = 'TR')
DROP TRIGGER Bonus
GO

CREATE TRIGGER Bonus ON Dbo.Character FOR INSERT
AS
BEGIN

DECLARE
@Resets INT,
@Puntos INT,
@Zen INT,
@Char varchar(10)
SELECT @Char = Name FROM INSERTED

SET @Resets = 10 -- Cantidad de resets
SET @Puntos = 2000 -- Cantidad de puntos iniciales
SET @Zen = 5000000 -- Cantidad de zen

UPDATE Dbo.Character
SET Resets = @Resets, LevelUpPoint = @Puntos, Money = @zen
WHERE Name = @Char
END

espero te funcione.

Gracias:


Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
2 Replies
1998 Views
Last post August 01, 2017, 07:21:21 PM
by Joaquin
2 Replies
2434 Views
Last post September 05, 2017, 12:52:37 AM
by ZabiinoOo
2 Replies
1057 Views
Last post December 21, 2017, 07:05:33 PM
by -Rastaa.TSM☢
4 Replies
1327 Views
Last post June 12, 2018, 04:14:40 PM
by juanka2
4 Replies
1074 Views
Last post March 26, 2019, 01:35:55 PM
by ⚡ Zeus ⚡