Autor Tema: Castle Siege - Regalar coins para todos los membros del guild y alianzas  (Leído 3602 veces)

Desconectado Louis

  • *
  • *


  • 1273

    180

    26658
  • br
  • Louis Emulator
    • +55 15 997401274 +55 15 997401274
    • louisemulator louisemulator
Query para regalar wcoins para todos lo miembros del guild ganador del Castel Siege.

Solo configurar su premio y crear una JOB para ejecutar cuando el evento ha terminado.

Ejemplo: Su Cs cierra as 22:00, solo crear una job para ejecutar as 22:01



Credtios:
Louis
« Última Modificación: Enero 07, 2021, 05:08:49 pm por Louis »
Update 45 ready
www.jogandomu.com.br
Discord: louisemulator

Gracias:

=Hacker=, Necrophos, dieysonpt1, brazill, Orion88, conter, GLpendeex, osvaldo1811, mupk, Lena06, mabrio, youislife, Tck, muexp, Avatar11, AlbertoxD, vitordodo157, Katecat, muthunder, rafaelmt, jonhblay, murillo021, Sergio MuTeamServices, 03071994, loxa, Ailson Costa, fw356c2, Yalih, mulevels, DarkBlue, Wilker, CaiodaJoana, Valen1531, daniel4k4k, souzaash, honner, [ADM]Joker, leogandini, Mauro, amerigo, lolz3976, ArcSyS, Weberson(GWteam), gmuonline, Dyego, rando, Matheus Gomes, ibhost, lorranmota, sh9ik, eragon, sdbgss, Roy, comelon666, achilles31, Guga, PoccHaHa, chuvito91, liu008, Mineiro Mu Online, quarentine, rsaldanha, driosm3, sumoning, PsycheMU, vieja_b, muone, carper, wellwisher22, MADRUGA, DiegoShadow, FALCON, PolacoMU, aszxitalo, webamoev, hennedy, RPG PVP Configurações, admwoods, Plunder, hades45, Dr.Evil, boybudz321, Netplay3, dsgaming, Bumb1ebe, TitaniumDev, msiena017, erick05, xdjoa, plmcdx, sapoloko55, martin castro, shiguemoto159, emaspc93, xAppLy, luanalves, elitemu14, torales, josec19, tcheloft, carlocrow, near929, mpy, ToShirico, -DeviiL-, jeancccarlos, vinnydias, robiivagyok, richardjj, murdrsdrizzy, EzeQ, juampicdx, neoandaluz, bobike24, KempeK, NERA, meelfagg, MuConexão, Glopezcor, felipesk, JVigistain, AnDeR, stkmu, RaStRaBaN, dragon0729, darkider, Sandokan, loco1705, ninjanegro, mrtin, lemiks, Zteban, godrex, adir203, mudomumu, JeanPereiraJP, asadas, styloweoo, LTZIN, boicaolho, Artemia, rnx44, elclonemor, haskellmb, zettao, attack, NoeticR, asd111, adrianjrb, Velinho, ProMD, morethan, taurinho, kozoodev, birdy491, keky, NoobInMu, dark66, maeelzin, 4fun, nenedario, mangal, bhilou, keviinrdgs, eduhperes, briner2016, space, becasito, necronsed, ReaperKID, nitroxxx, JavierP, [email protected], swiety, datcom

Tck

Mais uma opção para a Galera.

Código
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 
« Última Modificación: Agosto 23, 2020, 09:49:58 am por Louis »

Gracias:

Louis, muexp, Avatar11, Exhurtum, alefmello, Katecat, muthunder, rafaelmt, Orion88, jonhblay, murillo021, TecnoBytesRS, 03071994, Sergio MuTeamServices, osvaldo1811, BooM, CaiodaJoana, Valen1531, lolz3976, [ADM]Joker, lorranmota, cousher, Roy, achilles31, ArcSyS, PsycheMU, muone, carper, wellwisher22, brazill, rsaldanha, plmcdx, luanalves, ibhost, eragon, EzeQ, juampicdx, Glopezcor, stkmu, darkider, godrex, adir203, rnx44, haskellmb, Velinho, morethan, Artemia, asadas, dark66, briner2016

Gracias:

muone

Desconectado Roy

  • *


  • 11

    2

    38
  • br
Teria como colocar essa JOB para premiar somente os players online da guild vencedora ?

Gracias:


Desconectado Louis

  • *
  • *


  • 1273

    180

    26658
  • br
  • Louis Emulator
    • +55 15 997401274 +55 15 997401274
    • louisemulator louisemulator
Teria como colocar essa JOB para premiar somente os players online da guild vencedora ?

IF EXISTS (select memb___id from memb_stat where connectstat = 1 and memb___id = @Acc)
BEGIN
   UPDATE CashShopData SET WcoinC = WCoinC + 10 where AccountID = @Acc
END
Update 45 ready
www.jogandomu.com.br
Discord: louisemulator

Gracias:


muone

Louis como seria se quisesse além de premiar a guild vencedora, premiar quem ficou no top1 de mortes do castle siege e zerar a tabela?

 

.