Declare @Guild varchar(10); Declare @GuildA varchar(10); Declare @Char varchar(10); Declare @Conta varchar(10); Declare @GUnion int;Declare @Premio int; Declare @G_Status int; Set @Guild = (Select OWNER_GUILD from MuCastle_DATA) Set @GUnion = (Select G_Union from Guild where G_Name = @Guild)Set @GuildA = (Select G_Name from Guild where G_Union = @GUnion)Set @GuildA = @Guild;IF (@Guild <> '') BEGIN DECLARE C CURSOR FOR SELECT Name,G_Status FROM GuildMember Where G_Name = @Guild Order By G_Status desc OPEN C FETCH NEXT FROM C INTO @Char,@G_Status WHILE @@FETCH_STATUS = 0 BEGIN IF @G_Status = 128 -- G_status = 128 (Guild Master) BEGIN SET @Premio = 100; END IF @G_Status = 64 -- G_status = 64 (Assistente Guild Master) BEGIN SET @Premio = 70; END IF @G_Status = 32 -- G_status = 32 (Batle Master) BEGIN SET @Premio = 50; END IF @G_Status = 0 -- G_status = 0 (Membro) BEGIN SET @Premio = 30; END SET @Conta = ''; SET @Conta = (Select AccountID From Character where Name = @Char) IF (@Conta <> '') BEGIN Update PcPointData set PcPoint = PcPoint + @Premio where AccountID = @Conta END FETCH NEXT FROM C INTO @Char,@G_Status END CLOSE C DEALLOCATE C END
Teria como colocar essa JOB para premiar somente os players online da guild vencedora ?