[New - Offi] Fragen und Disskussions Thread

AddDungeon( "WI_INSTANCE_RUSTIA" )
--{
    SetClass( CLASS_NORMAL )
    SetLevel( 1, 80 )
    SetCoolTime( MIN(30) )
    --SetTeleportPos( ID_NORMAL, 1358, 102, 1315 )
    --SetTeleportPos( ID_MIDBOSS, 695, 90, 684 )
    --SetTeleportPos( ID_BOSS, 695, 100, 684 )

    SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE01", false, 513, 101, 953 )
    SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE02", false, 889, 101, 1121 )
    SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE03", false, 926, 101, 850 )
    SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE04", false, 1247, 101, 1272 )
    

    SetMonster( ID_BOSS, "MI_BESIBIGFOOT01", true, 1126, 103, 1505 )
--}

AddDungeon( "WI_INSTANCE_RUSTIA_1" )
--{
    SetClass( CLASS_MASTER )
    SetLevel( 1, 80 )
    SetCoolTime( MIN(30) )
    --SetTeleportPos( ID_NORMAL, 1358, 102, 1315 )
    --SetTeleportPos( ID_MIDBOSS, 695, 90, 684 )
    --SetTeleportPos( ID_BOSS, 695, 100, 684 )

    
    SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE01", false, 513, 101, 953 )
    SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE02", false, 889, 101, 1121 )
    SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE03", false, 926, 101, 850 )
    SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE04", false, 1247, 101, 1272 )

    SetMonster( ID_BOSS, "MI_BESIBIGFOOT02", true, 1126, 103, 1505 )
--}

--------------------------------------------------------------------
-- ÃʱâÈ* ----------------------------------------------------------
--------------------------------------------------------------------
dofile( ".\\LuaFunc\\InstanceDungeonBase.lua" )
--------------------------------------------------------------------
--[[
AddDungeon( "WI_DUNGEON_SECRET_L" )
--{	
	SetClass( dwClass )
	SetLevel( nMinLevel, nMaxLevel )
	SetCoolTime( dwCoolTime )
	SetMonster( nType, strMonsterId, bRed, x, y, z )
			:
			:
	SetTeleportPos( nType, x, y, z )
			:
			:
--}
--]]

--[[
-- Sample
AddDungeon( "WI_DUNGEON_FL_MAS" )
--{
	SetClass( CLASS_NORMAL, CLASS_MASTER, CLASS_HERO )
	SetLevel( 80, 120 )
	SetCoolTime( MIN(1) )
	SetTeleportPos( ID_NORMAL, 695, 90, 684 ) -- Á¤ÀÇÇÏÁö ¾ÊÀ¸¸é ¸Ê¿¡¼* ¼³Á¤ÇÑ ÁÂÇ¥·Î À̵¿ÇÑ´Ù.
	SetTeleportPos( ID_MIDBOSS, 695, 90, 684 )
	SetTeleportPos( ID_BOSS, 695, 100, 684 )
	SetMonster( ID_NORMAL, "MI_CAITSITH04_1", false, 695, 90, 684 )
	SetMonster( ID_NORMAL, "MI_CAITSITH04_1", false, 695, 90, 684 )
	SetMonster( ID_NORMAL, "MI_CAITSITH04_1", false, 695, 90, 684 )
	SetMonster( ID_MIDBOSS, "MI_AIBATT1", false, 695, 90, 684 )
	SetMonster( ID_BOSS, "MI_AIBATT1", true, 695, 100, 684 )
--}
--]]


AddDungeon( "WI_INSTANCE_OMINOUS" )
--{
	SetClass( CLASS_NORMAL )
	SetLevel( 1, 130 )
	SetCoolTime( MIN(30) )
	--SetTeleportPos( ID_NORMAL, 1358, 102, 1315 )
	--SetTeleportPos( ID_MIDBOSS, 695, 90, 684 )
	--SetTeleportPos( ID_BOSS, 695, 100, 684 )
	SetMonster( ID_NORMAL, "MI_PRICKANT04", true, 1280, 101, 1640 )
	SetMonster( ID_NORMAL, "MI_MAULMOUSE04", true, 1234, 101, 1393 )
	SetMonster( ID_NORMAL, "MI_CRIPESCENTIPEDE04", true, 1089, 101, 1590 )
	SetMonster( ID_MIDBOSS, "MI_LYCANOS01", true, 1078, 101, 1359 )
	SetMonster( ID_BOSS, "MI_VEMPAIN01", true, 1079, 101, 1457 )
--}

AddDungeon( "WI_INSTANCE_OMINOUS_1" )
--{
	SetClass( CLASS_MASTER, CLASS_HERO )
	SetLevel( 1, 130 )
	SetCoolTime( MIN(30) )
	--SetTeleportPos( ID_NORMAL, 1358, 102, 1315 )
	--SetTeleportPos( ID_MIDBOSS, 695, 90, 684 )
	--SetTeleportPos( ID_BOSS, 695, 100, 684 )
	SetMonster( ID_NORMAL, "MI_PRICKANT04_1", true, 1280, 101, 1640 )
	SetMonster( ID_NORMAL, "MI_MAULMOUSE04_1", true, 1234, 101, 1393 )
	SetMonster( ID_NORMAL, "MI_CRIPESCENTIPEDE04_1", true, 1089, 101, 1590 )
	SetMonster( ID_MIDBOSS, "MI_LYCANOS01_1", true, 1078, 101, 1359 )
	SetMonster( ID_BOSS, "MI_VEMPAIN01_1", true, 1079, 101, 1457 )
--}

AddDungeon( "WI_INSTANCE_DREADFULCAVE" )
--{
	SetClass( CLASS_HERO )
	SetLevel( 1, 160 )
	SetCoolTime( MIN(360) )
	--SetTeleportPos( ID_NORMAL, 1358, 102, 1315 )
	--SetTeleportPos( ID_MIDBOSS, 695, 90, 684 )
	--SetTeleportPos( ID_BOSS, 695, 100, 684 )

	SetMonster( ID_MIDBOSS, "MI_DREADSTONE01", false, 928, 101, 198 )
	SetMonster( ID_MIDBOSS, "MI_DREADSTONE02", false, 1504, 101, 419 )
	SetMonster( ID_MIDBOSS, "MI_DREADSTONE03", false, 1397, 101, 893 )
	SetMonster( ID_MIDBOSS, "MI_DREADSTONE04", false, 764, 101, 867 )
	SetMonster( ID_MIDBOSS, "MI_DREADSTONE05", false, 675, 101, 560 )

	SetMonster( ID_BOSS, "MI_SKELDEVIL", true, 1809, 101, 1395 )
--}

AddDungeon( "WI_INSTANCE_RUSTIA" )
--{
	SetClass( CLASS_NORMAL )
	SetLevel( 1, 80 )
	SetCoolTime( MIN(30) )
	--SetTeleportPos( ID_NORMAL, 1358, 102, 1315 )
	--SetTeleportPos( ID_MIDBOSS, 695, 90, 684 )
	--SetTeleportPos( ID_BOSS, 695, 100, 684 )

	SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE01", false, 513, 101, 953 )
	SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE02", false, 889, 101, 1121 )
	SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE03", false, 926, 101, 850 )
	SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE04", false, 1247, 101, 1272 )
	

	SetMonster( ID_BOSS, "MI_BESIBIGFOOT01", true, 1126, 103, 1505 )
--}

AddDungeon( "WI_INSTANCE_RUSTIA_1" )
--{
	SetClass( CLASS_MASTER )
	SetLevel( 1, 80 )
	SetCoolTime( MIN(30) )
	--SetTeleportPos( ID_NORMAL, 1358, 102, 1315 )
	--SetTeleportPos( ID_MIDBOSS, 695, 90, 684 )
	--SetTeleportPos( ID_BOSS, 695, 100, 684 )

	
	SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE01", false, 513, 101, 953 )
	SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE02", false, 889, 101, 1121 )
	SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE03", false, 926, 101, 850 )
	SetMonster( ID_MIDBOSS, "MI_RUSTIACRASHGATE04", false, 1247, 101, 1272 )

	SetMonster( ID_BOSS, "MI_BESIBIGFOOT02", true, 1126, 103, 1505 )
--}

nMaxInstanceDungeon = 40

tDungeon = {}
--------------------------------------------------------------------
-- ½Ã°£ ¼³Á¤ °ü·Ã ÇÔ¼ö ---------------------------------------------
--------------------------------------------------------------------
function SEC( a ) return a * 1000 end
function MIN( a ) return SEC( a ) * 60 end


function AddDungeon( strWorldId )
	local nIndex = table.getn( tDungeon ) + 1
	
	tDungeon[nIndex] = {}
	tDungeon[nIndex].strWorldId = strWorldId
	tDungeon[nIndex].dwClass = 65535
	tDungeon[nIndex].nMinLevel = 1
	tDungeon[nIndex].nMaxLevel = 120
	tDungeon[nIndex].dwCoolTime = MIN( 30 )
	tDungeon[nIndex].tMonster = {}
	tDungeon[nIndex].tTeleport = {}
end


CLASS_NORMAL	= 1
CLASS_MASTER	= 2
CLASS_HERO	= 4
function SetClass( ... )
	local nIndex = table.getn( tDungeon )
	local dwClass = 0
	if( arg.n > 0 ) then
		for indx = 1, arg.n do
			dwClass = dwClass + arg[indx]
		end
	end
	tDungeon[nIndex].dwClass = dwClass
end


function SetLevel( nMinLevel, nMaxLevel )
	local nIndex = table.getn( tDungeon )
	tDungeon[nIndex].nMinLevel = nMinLevel
	tDungeon[nIndex].nMaxLevel = nMaxLevel
end


function SetCoolTime( dwCoolTime )
	local nIndex = table.getn( tDungeon )
	tDungeon[nIndex].dwCoolTime = dwCoolTime
end


ID_NORMAL	= 0
ID_MIDBOSS 	= 1
ID_BOSS		= 2
function SetMonster( nType, strMonsterId, bRed, x, y, z )
	local nPDIndex = table.getn( tDungeon )
	local nMTIndex = table.getn( tDungeon[nPDIndex].tMonster ) + 1
		
	tDungeon[nPDIndex].tMonster[nMTIndex] = {}
	tDungeon[nPDIndex].tMonster[nMTIndex].nType = nType
	tDungeon[nPDIndex].tMonster[nMTIndex].strMonsterId = strMonsterId
	tDungeon[nPDIndex].tMonster[nMTIndex].bRed = bRed
	tDungeon[nPDIndex].tMonster[nMTIndex].x = x
	tDungeon[nPDIndex].tMonster[nMTIndex].y = y
	tDungeon[nPDIndex].tMonster[nMTIndex].z = z
end


function SetTeleportPos( nType, x, y, z )
	local nPDIndex = table.getn( tDungeon )
	local nTPIndex = table.getn( tDungeon[nPDIndex].tTeleport ) + 1
		
	tDungeon[nPDIndex].tTeleport[nTPIndex] = {}
	tDungeon[nPDIndex].tTeleport[nTPIndex].nType = nType
	tDungeon[nPDIndex].tTeleport[nTPIndex].x = x
	tDungeon[nPDIndex].tTeleport[nTPIndex].y = y
	tDungeon[nPDIndex].tTeleport[nTPIndex].z = z
end

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER  proc [dbo].[SECRET_ROOM_STR]
@iGu char(2),
@serverindex char(2),
@nTimes int,
@nContinent int,
@m_idGuild char(6),
@nPenya int,
@chState char(1),
@dwWorldID int,
@nWarState int,
@nKillCount int
as

set nocount on
set xact_abort on

if @iGu = 'S1'
begin
    select isnull(max(nTimes), 0) as nTimes from SECRET_ROOM_TBL where serverindex = @serverindex
end

if @iGu = 'S2'
begin
    select nContinent, m_idGuild, nPenya
    from SECRET_ROOM_TBL
    where serverindex = @serverindex and nTimes = @nTimes and chState = @chState
    order by nContinent asc, nPenya desc, s_date asc
end

if @iGu = 'I1'
begin
    insert into SECRET_ROOM_TBL (serverindex, nTimes, nContinent, m_idGuild, nPenya, chState, s_date)
    select @serverindex, @nTimes, @nContinent, @m_idGuild, @nPenya, @chState, getdate()
end


if @iGu = 'U1'
begin
    update SECRET_ROOM_TBL
    set nPenya = @nPenya, chState = @chState, s_date = getdate()
    where serverindex = @serverindex and nTimes = @nTimes and nContinent = @nContinent and m_idGuild = @m_idGuild and chState = 'T'
end

if @iGu = 'U2'
begin
    update SECRET_ROOM_TBL
    set nPenya = @nPenya, chState = @chState, dwWorldID = @dwWorldID, nWarState = @nWarState, nKillCount = @nKillCount, s_date = getdate()
    where serverindex = @serverindex and nTimes = @nTimes and nContinent = @nContinent and m_idGuild = @m_idGuild and chState = 'T'
end

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[SECRET_ROOM_MEMBER_STR]
@iGu char(2),
@serverindex char(2),
@nTimes int,
@nContinent int,
@m_idGuild char(6),
@m_idPlayer char(7)
as

set nocount on
set xact_abort on

if @iGu = 'S2'
begin
    select m_idPlayer
    from SECRET_ROOM_MEMBER_TBL
    where serverindex = @serverindex and nTimes = @nTimes and nContinent = @nContinent and m_idGuild = @m_idGuild
end

if @iGu = 'I1'
begin
    insert into SECRET_ROOM_MEMBER_TBL (serverindex, nTimes, nContinent, m_idGuild, m_idPlayer)
    select @serverindex, @nTimes, @nContinent, @m_idGuild, @m_idPlayer
end

if @iGu = 'D1'
begin
    delete SECRET_ROOM_MEMBER_TBL
    where serverindex = @serverindex and nTimes = @nTimes and nContinent = @nContinent and m_idGuild = @m_idGuild
end