Hello All Help Me For Procedure Fortress war

10/28/2017 21:06 MinaThabit#1
Help For Set ---
Quote:
--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)
10/28/2017 21:24 NorseGodTyr#2
Quote:
Originally Posted by MinaThabit View Post
Help For Set ---
what is that for Procedure ?
10/28/2017 21:33 MinaThabit#3
Quote:
Originally Posted by mialuisa View Post
what is that for Procedure ?
Reward Guild All In Fortress
10/28/2017 23:26 NorseGodTyr#4
Quote:
Originally Posted by MinaThabit View Post
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
10/29/2017 01:20 MinaThabit#5
Quote:
Originally Posted by mialuisa View Post
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
10/29/2017 08:30 NorseGodTyr#6
Quote:
Originally Posted by MinaThabit View Post
SRO_VT_SHARD =MODYZ_SHD for Name Me
I mean for the Procedure the Name :)

Quote:
--GuildID--CharID--Online--LatestRegion--Reward
DECLARE @[Only registered and activated users can see links. Click Here To Register...]DJ int @[Only registered and activated users can see links. Click Here To Register...]DB int @[Only registered and activated users can see links. Click Here To Register...]DH int @[Only registered and activated users can see links. Click Here To Register...]DC int @[Only registered and activated users can see links. Click Here To Register...] 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 ,
@[Only registered and activated users can see links. Click Here To Register...]PMGJ INT @[Only registered and activated users can see links. Click Here To Register...]PMGB INT @[Only registered and activated users can see links. Click Here To Register...]PMGH INT @[Only registered and activated users can see links. Click Here To Register...]PMGC INT,
@[Only registered and activated users can see links. Click Here To Register...]PMGJ varchar(60) @[Only registered and activated users can see links. Click Here To Register...]PMGB varchar(60) @[Only registered and activated users can see links. Click Here To Register...]PMGH varchar(60) @[Only registered and activated users can see links. Click Here To Register...]PMGC varchar(60),
@[Only registered and activated users can see links. Click Here To Register...]MGJ INT @[Only registered and activated users can see links. Click Here To Register...]MGB INT @[Only registered and activated users can see links. Click Here To Register...]MGH INT @[Only registered and activated users can see links. Click Here To Register...]MGC INT
------------- Jangan 1,BIJEOKDAN 6,Hotan 3,CONSTANTINOPLE 4 --------------
set @[Only registered and activated users can see links. Click Here To Register...]DJ =(SELECT GuildID FROM MODYZ_SHD.dbo._SiegeFortress where FortressID=1)
set @[Only registered and activated users can see links. Click Here To Register...]DB =(SELECT GuildID FROM MODYZ_SHD.dbo._SiegeFortress where FortressID=6)
set @[Only registered and activated users can see links. Click Here To Register...]DH =(SELECT GuildID FROM MODYZ_SHD.dbo._SiegeFortress where FortressID=3)
set @[Only registered and activated users can see links. Click Here To Register...]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 = @[Only registered and activated users can see links. Click Here To Register...]DJ AND Permission= -1)
set @charNameMGB =(SELECT CharName FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @[Only registered and activated users can see links. Click Here To Register...]DB AND Permission= -1)
set @charNameMGH =(SELECT CharName FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @[Only registered and activated users can see links. Click Here To Register...]DH AND Permission= -1)
set @charNameMGC =(SELECT CharName FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @[Only registered and activated users can see links. Click Here To Register...]DC AND Permission= -1)
------------------ CHAR ID MASTER GUILD -----
set @CharIDMGJ =(SELECT CharID FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @[Only registered and activated users can see links. Click Here To Register...]DJ AND Permission= -1)
set @CharIDMGB =(SELECT CharID FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @[Only registered and activated users can see links. Click Here To Register...]DB AND Permission= -1)
set @CharIDMGH =(SELECT CharID FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @[Only registered and activated users can see links. Click Here To Register...]DH AND Permission= -1)
set @CharIDMGC =(SELECT CharID FROM MODYZ_SHD.dbo._GuildMember Where GuildID = @[Only registered and activated users can see links. Click Here To Register...]DC AND Permission= -1)
----------------------Char ID PALYER & MASTER ----------------------

set @CharIDPMGJ = (select (CharID) from MODYZ_SHD.dbo._char where GuildID in @[Only registered and activated users can see links. Click Here To Register...]DJ))
--set @CharIDPMGB = (select (CharID) from MODYZ_SHD.dbo._char where GuildID IN @[Only registered and activated users can see links. Click Here To Register...]DB))
--set @CharIDPMGH = (select (CharID) from MODYZ_SHD.dbo._char where GuildID IN @[Only registered and activated users can see links. Click Here To Register...]DH))
--set @CharIDPMGC = (select (CharID) from MODYZ_SHD.dbo._char where GuildID IN @[Only registered and activated users can see links. Click Here To Register...]DC))
---------------------------- JID --------------------------------------------

--SET @[Only registered and activated users can see links. Click Here To Register...]PMGB =(Select (UserJID) from MODYZ_SHD.dbo._user where CharID IN (@CharIDPMGJ))
--SET @[Only registered and activated users can see links. Click Here To Register...]PMGB =(Select (UserJID) from MODYZ_SHD.dbo._user where CharID IN (@CharIDMGB))
--SET @[Only registered and activated users can see links. Click Here To Register...]PMGH =(Select (UserJID) from MODYZ_SHD.dbo._user where CharID IN (@CharIDMGH))
--SET @[Only registered and activated users can see links. Click Here To Register...]PMGC =(Select (UserJID) from MODYZ_SHD.dbo._user where CharID IN (@CharIDMGC))
----------------------------- online -----------------------------
--set @[Only registered and activated users can see links. Click Here To Register...]PMGJ =(select Status from MODYZ_LOG.dbo._OnlineOffline where CharID =@CharIDPMGJ)
--SET @[Only registered and activated users can see links. Click Here To Register...]PMGB =(select Status from MODYZ_LOG.dbo._OnlineOffline where CharID =@CharIDPMGB)
--SET @[Only registered and activated users can see links. Click Here To Register...]PMGH =(select Status from MODYZ_LOG.dbo._OnlineOffline where CharID =@CharIDPMGH)
--SET @[Only registered and activated users can see links. Click Here To Register...]PMGC =(select Status from MODYZ_LOG.dbo._OnlineOffline where CharID =@CharIDPMGC)
----------------------------- Latest Region -----------------------
--SET @[Only registered and activated users can see links. Click Here To Register...]MGJ =(select LatestRegion from MODYZ_SHD.dbo._Char where charid=@CharIDPMGJ)
--SET @[Only registered and activated users can see links. Click Here To Register...]MGB =(select LatestRegion from MODYZ_SHD.dbo._Char where charid=@CharIDPMGB)
--SET @[Only registered and activated users can see links. Click Here To Register...]MGH =(select LatestRegion from MODYZ_SHD.dbo._Char where charid=@CharIDPMGH)
--SET @[Only registered and activated users can see links. Click Here To Register...]MGC =(select LatestRegion from MODYZ_SHD.dbo._Char where charid=@CharIDPMGC)