JOB Premiação Castle Siege

[phillippec1]

Alguem pode me da uma força? Eu não manjo muito dessa parte de SQL...

O louis compartilhou um script para bonificar a guild vencedora e as aliandas do CS, porém, ele falou que tem que criar uma job e definir o horario para logos depois que o siege terminar, alguem pode me ajudar nessa parte?

[rian12]

Manda o link dessa job.

[phillippec1]

Manda o link dessa job.


declare
@nome varchar(10),
@acc varchar(10),
@guild varchar(8)

-- Premiar guild dona do castelo
DECLARE LISTA CURSOR LOCAL FOR
select Name from Guildmember where G_name = (select owner_guild from mucastle_data)
OPEN LISTA
[Only registered and activated users can see links]
[Only registered and activated users can see links]
begin

[Only registered and activated users can see links]
BEGIN

[Only registered and activated users can see links]
-- Defina sua query de bonificação abaixo
[Only registered and activated users can see links]
END

[Only registered and activated users can see links]
end
CLOSE LISTA
DEALLOCATE LISTA


-- Premiar Guilds aliadas
DECLARE LISTA CURSOR LOCAL FOR
select G_Name from Guild where G_union = (select G_union from guild where g_name = (select owner_guild from mucastle_data)) and g_name <> (select owner_guild from mucastle_data)
OPEN LISTA
[Only registered and activated users can see links]
[Only registered and activated users can see links]
begin

DECLARE LISTA2 CURSOR LOCAL FOR
[Only registered and activated users can see links]
OPEN LISTA2
[Only registered and activated users can see links]
[Only registered and activated users can see links]
begin

[Only registered and activated users can see links]
BEGIN

[Only registered and activated users can see links]
-- Defina sua query de bonificação abaixo
[Only registered and activated users can see links]

[Only registered and activated users can see links]
end
CLOSE LISTA2
DEALLOCATE LISTA2


[Only registered and activated users can see links]
end
CLOSE LISTA
DEALLOCATE LISTA

Creditos
Louis