bom acho que o codigo de cima ta certo ;-; no caso assim o tempo online seria como?Citação:
Originally Posted by louis [Only registered and activated users can see links. Click Here To Register...]
Printable View
bom acho que o codigo de cima ta certo ;-; no caso assim o tempo online seria como?Citação:
Originally Posted by louis [Only registered and activated users can see links. Click Here To Register...]
O script que você mandou (vi depois kk) está correto.Citação:
Originally Posted by HorrorStory [Only registered and activated users can see links. Click Here To Register...]
sobre o tempo online você tem que ver se as jobs de 1 minuto estão rodando.
Arrumei so que nao consigo criar isso CREATE Procedure [dbo].[PREMIAR_TOPS] @Account varchar(10),Citação:
Originally Posted by louis [Only registered and activated users can see links. Click Here To Register...]
@Name varchar(10),
@WC int,
@WP int,
@GP int,
@XP int,
@VIP1 int,
@VIP2 int,
@VIP3 int,
@EVENTOS int
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
IF @WC > 0 or @WP > 0 or @GP > 0
BEGIN
UPDATE CashShopData
SET WCoinC = WCoinC + @WC, WCoinP = WCoinP + @WP, GoblinPoint = GoblinPoint + @GP where AccountID = @Account
END
IF @WC > 0
BEGIN
insert into log_creditos ( login, valor, ip, tipo ) values (@Account,@WC,'1','6')
END
IF @EVENTOS > 0 or @XP > 0
BEGIN
UPDATE Character
SET exp_war = exp_war + @XP, eventos = eventos + @EVENTOS where Name = @Name and AccountID = @Account
END
IF @VIP1 > 0
BEGIN
-- ADD VIP NA CONTA VIP_AL1
update memb_info set AccountExpireDate = AccountExpireDate+@VIP1 where memb___id = @Account and accountlevel = 1
-- ADD VIP NA CONTA VIP_AL0
update memb_info set accountlevel = 1, AccountExpireDate = (getdate())+@VIP1 where memb___id = @Account and accountlevel = 0
if (select COUNT(*) from MEMB_INFO where memb___id = @Account and AccountLevel = 1) > 0
Insert into log_vip (login,dias,tipo) values (@Account,@VIP1,'6' )
END
if @VIP2 > 0
BEGIN
-- ADD VIP NA CONTA VIP_AL2
update memb_info set AccountExpireDate = AccountExpireDate+@VIP2 where memb___id = @Account and accountlevel = 2
if (select COUNT(*) from MEMB_INFO where memb___id = @Account and AccountLevel = 2) > 0
Insert into log_vip (login,dias,tipo) values (@Account,@VIP2,'7' )
END
if @VIP3 > 0
BEGIN
-- ADD VIP NA CONTA VIP_AL3
update memb_info set AccountExpireDate = AccountExpireDate+@VIP3 where memb___id = @Account and accountlevel = 3
if (select COUNT(*) from MEMB_INFO where memb___id = @Account and AccountLevel = 3) > 0
Insert into log_vip (login,dias,tipo) values (@Account,@VIP3,'8' )
END
Na etapa NULL tem 2 linhas que devem ser removidas, uma tem o data_reset e a outra data_mreset (acho que são as 2 ultima se não me engano)Citação:
Originally Posted by HorrorStory [Only registered and activated users can see links. Click Here To Register...]
pode remover pois não são necessárias
ss removi isso, olha ali o codigo que mandei em cima na hora de rodar da erro de END na linha 62 tentei tirar mesmo assim nao deuCitação:
Originally Posted by louis [Only registered and activated users can see links. Click Here To Register...]
Isso você deve mudar nas jobs de 1 minuto que já estão criadas e não no script.Citação:
Originally Posted by HorrorStory [Only registered and activated users can see links. Click Here To Register...]
ent tipo dai na jobs da erro que a Procedure nao foi criada, so que quando tento criar da esse erro que te falei la em cimaCitação:
Originally Posted by louis [Only registered and activated users can see links. Click Here To Register...]
Se ela não foi criada me explica onde aparece esse erro:Citação:
Originally Posted by HorrorStory [Only registered and activated users can see links. Click Here To Register...]
Citação:
ele da o seguinte erro Executed as user: NT AUTHORITY\SYSTEM. Invalid column name 'data_reset'. [SQLSTATE 42S22] (Error 207). The step failed.
esse ai eu arrumei, to falando agora o do job de 1 mes;-; tipo ele fala que nao existe a procedure PREMIAR_TOPSCitação:
Originally Posted by louis [Only registered and activated users can see links. Click Here To Register...]
Citação:
Originally Posted by HorrorStory [Only registered and activated users can see links. Click Here To Register...]
Tenta executar issoCódigo:
CREATE Procedure [dbo].[PREMIAR_TOPS]
@Account varchar(10),
@Name varchar(10),
@WC int,
@WP int,
@GP int,
@XP int,
@VIP1 int,
@VIP2 int,
@VIP3 int,
@EVENTOS int
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
IF @WC > 0 or @WP > 0 or @GP > 0
BEGIN
UPDATE CashShopData
SET WCoinC = WCoinC + @WC, WCoinP = WCoinP + @WP, GoblinPoint = GoblinPoint + @GP where AccountID = @Account
END
IF @WC > 0
BEGIN
insert into log_creditos ( login, valor, ip, tipo ) values (@Account,@WC,'1','6')
END
IF @EVENTOS > 0 or @XP > 0
BEGIN
UPDATE Character
SET exp_war = exp_war + @XP, eventos = eventos + @EVENTOS where Name = @Name and AccountID = @Account
END
IF @VIP1 > 0
BEGIN
-- ADD VIP NA CONTA VIP_AL1
update memb_info set AccountExpireDate = AccountExpireDate+@VIP1 where memb___id = @Account and accountlevel = 1
-- ADD VIP NA CONTA VIP_AL0
update memb_info set accountlevel = 1, AccountExpireDate = (getdate())+@VIP1 where memb___id = @Account and accountlevel = 0
if (select COUNT(*) from MEMB_INFO where memb___id = @Account and AccountLevel = 1) > 0
Insert into log_vip (login,dias,tipo) values (@Account,@VIP1,'6' )
END
if @VIP2 > 0
BEGIN
-- ADD VIP NA CONTA VIP_AL2
update memb_info set AccountExpireDate = AccountExpireDate+@VIP2 where memb___id = @Account and accountlevel = 2
if (select COUNT(*) from MEMB_INFO where memb___id = @Account and AccountLevel = 2) > 0
Insert into log_vip (login,dias,tipo) values (@Account,@VIP2,'7' )
END
if @VIP3 > 0
BEGIN
-- ADD VIP NA CONTA VIP_AL3
update memb_info set AccountExpireDate = AccountExpireDate+@VIP3 where memb___id = @Account and accountlevel = 3
if (select COUNT(*) from MEMB_INFO where memb___id = @Account and AccountLevel = 3) > 0
Insert into log_vip (login,dias,tipo) values (@Account,@VIP3,'8' )
END
END
GO
CREATE Procedure [dbo].[PREMIAR_TOPS_MEDALHAS]
@Account varchar(10),
@Name varchar(10),
@MEDALHA int
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
IF @MEDALHA = 1
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_sresets=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_sresets) VALUES (@Account,@name,1)
END
IF @MEDALHA = 2
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_smresets=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_smresets) VALUES (@Account,@name,1)
END
IF @MEDALHA = 3
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_tempo=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_tempo) VALUES (@Account,@name,1)
END
IF @MEDALHA = 4
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_evento=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_evento) VALUES (@Account,@name,1)
END
IF @MEDALHA = 5
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_pk=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_pk) VALUES (@Account,@name,1)
END
IF @MEDALHA = 6
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_hr=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_hr) VALUES (@Account,@name,1)
END
IF @MEDALHA = 7
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_ds_s=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_ds_s) VALUES (@Account,@name,1)
END
IF @MEDALHA = 8
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_bc_s=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_bc_s) VALUES (@Account,@name,1)
END
IF @MEDALHA = 9
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_cc_s=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_cc_s) VALUES (@Account,@name,1)
END
IF @MEDALHA = 10
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_duel_semanal=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_duel_semanal) VALUES (@Account,@name,1)
END
IF @MEDALHA = 11
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_resets_m=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_resets_m) VALUES (@Account,@name,1)
END
IF @MEDALHA = 12
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_mresets_m=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_mresets_m) VALUES (@Account,@name,1)
END
IF @MEDALHA = 13
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_tempo_m=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_tempo_m) VALUES (@Account,@name,1)
END
IF @MEDALHA = 14
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_evento_m=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_evento_m) VALUES (@Account,@name,1)
END
IF @MEDALHA = 15
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_pk_m=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_pk_m) VALUES (@Account,@name,1)
END
IF @MEDALHA = 16
BEGIN
if exists (select login from mk_medalhas where login = @Account and name = @name)
UPDATE MK_MEDALHAS SET medal_hr_m=1 where name = @name
ELSE
INSERT INTO MK_MEDALHAS (login,name,medal_hr_m) VALUES (@Account,@name,1)
END
END
GO