Hello All Help Me For Procedure Fortress war

[MinaThabit]

Help For Set ---

--GuildID--CharID--Online--LatestRegion--Reward
DECLARE @GuildIDJ int ,@GuildIDB int,@GuildIDH int,@GuildIDC int,@UserName varchar(max),
@charNameMGJ Varchar(60),@charNameMGB Varchar(60),@charNameMGH Varchar(60),@charNameMGC Varchar(60),
@CharIDMGJ int,@CharIDMGB int ,@CharIDMGH int,@CharIDMGC int ,
@CharIDPMGJ INT,@CharIDPMGB INT,@CharIDPMGH INT,@CharIDPMGC INT ,
@jidPMGJ INT,@jidPMGB INT,@jidPMGH INT,@jidPMGC INT,
@ONLINEPMGJ varchar(60),@ONLINEPMGB varchar(60),@ONLINEPMGH varchar(60),@ONLINEPMGC varchar(60),
@LRPMGJ INT,@LRPMGB INT,@LRPMGH INT,@LRPMGC INT
------------- Jangan 1,BIJEOKDAN 6,Hotan 3,CONSTANTINOPLE 4 --------------
set @GuildIDJ =(SELECT GuildID FROM MODYZ_SHD.dbo._SiegeFortress where FortressID=1)
set @GuildIDB =(SELECT GuildID FROM MODYZ_SHD.dbo._SiegeFortress where FortressID=6)
set @GuildIDH =(SELECT GuildID FROM MODYZ_SHD.dbo._SiegeFortress where FortressID=3)
set @GuildIDC =(SELECT GuildID FROM MODYZ_SHD.dbo._SiegeFortress where FortressID=4)
------------------- CHAR NAME MASTER GUILD-------
set @charNameMGJ =(SELECT CharName FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @GuildIDJ AND Permission= -1)
set @charNameMGB =(SELECT CharName FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @GuildIDB AND Permission= -1)
set @charNameMGH =(SELECT CharName FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @GuildIDH AND Permission= -1)
set @charNameMGC =(SELECT CharName FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @GuildIDC AND Permission= -1)
------------------ CHAR ID MASTER GUILD -----
set @CharIDMGJ =(SELECT CharID FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @GuildIDJ AND Permission= -1)
set @CharIDMGB =(SELECT CharID FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @GuildIDB AND Permission= -1)
set @CharIDMGH =(SELECT CharID FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @GuildIDH AND Permission= -1)
set @CharIDMGC =(SELECT CharID FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @GuildIDC AND Permission= -1)
----------------------Char ID PALYER & MASTER ----------------------

set @CharIDPMGJ = (select (CharID) from MODYZ_SHD.dbo._char where GuildID in (@GuildIDJ))
--set @CharIDPMGB = (select (CharID) from MODYZ_SHD.dbo._char where GuildID IN (@GuildIDB))
--set @CharIDPMGH = (select (CharID) from MODYZ_SHD.dbo._char where GuildID IN (@GuildIDH))
--set @CharIDPMGC = (select (CharID) from MODYZ_SHD.dbo._char where GuildID IN (@GuildIDC))
---------------------------- JID --------------------------------------------

--SET @jidPMGB =(Select (UserJID) from MODYZ_SHD.dbo._user where CharID IN (@CharIDPMGJ))
--SET @jidPMGB =(Select (UserJID) from MODYZ_SHD.dbo._user where CharID IN (@CharIDMGB))
--SET @jidPMGH =(Select (UserJID) from MODYZ_SHD.dbo._user where CharID IN (@CharIDMGH))
--SET @jidPMGC =(Select (UserJID) from MODYZ_SHD.dbo._user where CharID IN (@CharIDMGC))
----------------------------- online -----------------------------
--set @ONLINEPMGJ =(select Status from MODYZ_LOG.dbo._OnlineOffline where CharID =@CharIDPMGJ)
--SET @ONLINEPMGB =(select Status from MODYZ_LOG.dbo._OnlineOffline where CharID =@CharIDPMGB)
--SET @ONLINEPMGH =(select Status from MODYZ_LOG.dbo._OnlineOffline where CharID =@CharIDPMGH)
--SET @ONLINEPMGC =(select Status from MODYZ_LOG.dbo._OnlineOffline where CharID =@CharIDPMGC)
----------------------------- Latest Region -----------------------
--SET @LRPMGJ =(select LatestRegion from MODYZ_SHD.dbo._Char where charid=@CharIDPMGJ)
--SET @LRPMGB =(select LatestRegion from MODYZ_SHD.dbo._Char where charid=@CharIDPMGB)
--SET @LRPMGH =(select LatestRegion from MODYZ_SHD.dbo._Char where charid=@CharIDPMGH)
--SET @LRPMGC =(select LatestRegion from MODYZ_SHD.dbo._Char where charid=@CharIDPMGC)

[NorseGodTyr]

Originally Posted by MinaThabit

Help For Set ---

what is that for Procedure ?

[MinaThabit]

Originally Posted by mialuisa

what is that for Procedure ?

Reward Guild All In Fortress

[NorseGodTyr]

Originally Posted by MinaThabit

Reward Guild All In Fortress

you have create it self ?
or is it in SRO_VT_SHARD when yes say me name i will look

[MinaThabit]

Originally Posted by mialuisa

you have create it self ?
or is it in SRO_VT_SHARD when yes say me name i will look

SRO_VT_SHARD =MODYZ_SHD for Name Me

[NorseGodTyr]

Originally Posted by MinaThabit

SRO_VT_SHARD =MODYZ_SHD for Name Me

I mean for the Procedure the Name

--GuildID--CharID--Online--LatestRegion--Reward
DECLARE @DJ int @DB int @DH int @DC int @ varchar(max),
@charNameMGJ Varchar(60),@charNameMGB Varchar(60),@charNameMGH Varchar(60),@charNameMGC Varchar(60),
@CharIDMGJ int,@CharIDMGB int ,@CharIDMGH int,@CharIDMGC int ,
@CharIDPMGJ INT,@CharIDPMGB INT,@CharIDPMGH INT,@CharIDPMGC INT ,
@PMGJ INT @PMGB INT @PMGH INT @PMGC INT,
@PMGJ varchar(60) @PMGB varchar(60) @PMGH varchar(60) @PMGC varchar(60),
@MGJ INT @MGB INT @MGH INT @MGC INT
------------- Jangan 1,BIJEOKDAN 6,Hotan 3,CONSTANTINOPLE 4 --------------
set @DJ =(SELECT GuildID FROM MODYZ_SHD.dbo._SiegeFortress where FortressID=1)
set @DB =(SELECT GuildID FROM MODYZ_SHD.dbo._SiegeFortress where FortressID=6)
set @DH =(SELECT GuildID FROM MODYZ_SHD.dbo._SiegeFortress where FortressID=3)
set @DC =(SELECT GuildID FROM MODYZ_SHD.dbo._SiegeFortress where FortressID=4)
------------------- CHAR NAME MASTER GUILD-------
set @charNameMGJ =(SELECT CharName FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @DJ AND Permission= -1)
set @charNameMGB =(SELECT CharName FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @DB AND Permission= -1)
set @charNameMGH =(SELECT CharName FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @DH AND Permission= -1)
set @charNameMGC =(SELECT CharName FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @DC AND Permission= -1)
------------------ CHAR ID MASTER GUILD -----
set @CharIDMGJ =(SELECT CharID FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @DJ AND Permission= -1)
set @CharIDMGB =(SELECT CharID FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @DB AND Permission= -1)
set @CharIDMGH =(SELECT CharID FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @DH AND Permission= -1)
set @CharIDMGC =(SELECT CharID FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @DC AND Permission= -1)
----------------------Char ID PALYER & MASTER ----------------------

set @CharIDPMGJ = (select (CharID) from MODYZ_SHD.dbo._char where GuildID in @DJ))
--set @CharIDPMGB = (select (CharID) from MODYZ_SHD.dbo._char where GuildID IN @DB))
--set @CharIDPMGH = (select (CharID) from MODYZ_SHD.dbo._char where GuildID IN @DH))
--set @CharIDPMGC = (select (CharID) from MODYZ_SHD.dbo._char where GuildID IN @DC))
---------------------------- JID --------------------------------------------

--SET @PMGB =(Select (UserJID) from MODYZ_SHD.dbo._user where CharID IN (@CharIDPMGJ))
--SET @PMGB =(Select (UserJID) from MODYZ_SHD.dbo._user where CharID IN (@CharIDMGB))
--SET @PMGH =(Select (UserJID) from MODYZ_SHD.dbo._user where CharID IN (@CharIDMGH))
--SET @PMGC =(Select (UserJID) from MODYZ_SHD.dbo._user where CharID IN (@CharIDMGC))
----------------------------- online -----------------------------
--set @PMGJ =(select Status from MODYZ_LOG.dbo._OnlineOffline where CharID =@CharIDPMGJ)
--SET @PMGB =(select Status from MODYZ_LOG.dbo._OnlineOffline where CharID =@CharIDPMGB)
--SET @PMGH =(select Status from MODYZ_LOG.dbo._OnlineOffline where CharID =@CharIDPMGH)
--SET @PMGC =(select Status from MODYZ_LOG.dbo._OnlineOffline where CharID =@CharIDPMGC)
----------------------------- Latest Region -----------------------
--SET @MGJ =(select LatestRegion from MODYZ_SHD.dbo._Char where charid=@CharIDPMGJ)
--SET @MGB =(select LatestRegion from MODYZ_SHD.dbo._Char where charid=@CharIDPMGB)
--SET @MGH =(select LatestRegion from MODYZ_SHD.dbo._Char where charid=@CharIDPMGH)
--SET @MGC =(select LatestRegion from MODYZ_SHD.dbo._Char where charid=@CharIDPMGC)