DECLARE @USERNAME nvarchar(200),@UID int , @ATACKCOMPOSE int , @DEFENDCOMPOSE int , @LUCKCOMPOSE int , @AGILITYCOMPOSE int
/* NAO EDITE , ISSO SERVIRA PARA DECLARAR VARIAVEIS
AVISO : Quanto Maior os Status , Maior a Chance de Delay's do seu Inimigo */
SET @USERNAME = ' '; /* INSIRA O SEU USUÁRIO */
SET @AGILITYCOMPOSE = 1; /* INSIRA A AGILIDADE QUE VOCÊ QUER */
SET @ATACKCOMPOSE = 1; /* INSIRA O ATAQUE QUE VOCÊ QUER */
SET @LUCKCOMPOSE = 1; /* INSIRA A SORTE QUE VOCÊ QUER */
SET @DEFENDCOMPOSE = 1; /* INSIRA A DEFESA QUE VOCÊ QUER */
USE Db_Tank
IF EXISTS (SELECT UserName FROM Sys_Users_Detail WHERE UserName = @USERNAME)
 BEGIN
  SET @UID = (SELECT UserID FROM Sys_Users_Detail WHERE UserName = @USERNAME)
  IF @ATACKCOMPOSE < 1501 AND @DEFENDCOMPOSE < 1501 AND @LUCKCOMPOSE < 1501 AND @AGILITYCOMPOSE < 1501
   BEGIN
    IF @ATACKCOMPOSE > 0 AND @DEFENDCOMPOSE > 0 AND @LUCKCOMPOSE > 0 AND @AGILITYCOMPOSE > 0
     BEGIN
      USE Db_Tank
      UPDATE Sys_Users_Goods SET AttackCompose = @ATACKCOMPOSE WHERE UserID = @UID
      UPDATE Sys_Users_Goods SET DefendCompose = @DEFENDCOMPOSE WHERE UserID = @UID
      UPDATE Sys_Users_Goods SET AgilityCompose = @AGILITYCOMPOSE WHERE UserID = @UID
      UPDATE Sys_Users_Goods SET LuckCompose = @LUCKCOMPOSE WHERE UserID = @UID
      SELECT UserID,AttackCompose,DefendCompose,AgilityCompose,LuckCompose FROM Sys_Users_Goods WHERE UserID = @UID
     END ELSE
   PRINT 'O Numero Minimo é 1'
  END ELSE
  PRINT 'O Numero Máximo é 1500!'
 END ELSE
 PRINT 'O Usuário nao existe'
 /* QUERY FEITA POR GABRIEL