I rarely ever release shit. But hey, let's see how you guys make this work
It's pretty simple actually and doesn't require much knowledge or work, however, it's still something that almost nobody can do properly.
Wrote this query when I was being lazy and didnt wanna do shit. I never tested it and never completed it.. BUT its gives you the basic idea of how dungeons and instances work.
Just so you know, the query probably doesnt work since I was under heavy alcohol abuse when i wrote it. Just read it and undnerstand what you gotta do.. then inser the needed lines and your done. It's pretty easy to do, but all the arabs are gonna fail. When you do, please post. I love having a good laugh at people when they fail while having all the needed information at hand.
IF EXISTS(SELECT * FROM SRO_VT_SHARD.._RefGame_World WHERE WorldCodeName128 = 'INS_' + @AreaName)
BEGIN
UPDATE SRO_VT_SHARD.._RefGame_World
SET Type = 1,
WorldMaxCount = @MaxWorlds,
WorldMaxUserCount = @MaxPlayers,
WorldDurationTime = 7200000,
WorldEmptyRemainTime = 300000
WHERE WorldCodeName128 = 'INS_' + @AreaName
END
ELSE IF NOT EXISTS(SELECT * FROM SRO_VT_SHARD.._RefGame_World WHERE WorldCodeName128 = 'INS_' + @AreaName)
BEGIN
INSERT INTO SRO_VT_SHARD.._RefGame_World (WorldCodeName128, Type, WorldMaxCount, WorldMaxUserCount, WorldEntryType, WorldEntranceType, WorldLeaveType, WorldDurationTime, WorldEmptyRemainTime, ConfigGroupCodeName128)
SELECT 'INS_' + @AreaName, 1, @MaxWorlds, @MaxPlayers, 0, 0, 0, 7200000, 300000, 'GROUP_' + @AreaName
END
IF EXISTS(SELECT * FROM SRO_VT_SHARD.._RefTeleport WHERE CodeName128 LIKE 'GATE_' + @AreaName)
BEGIN
UPDATE SRO_VT_SHARD.._RefTeleport
SET GenWorldID = @WorldID
WHERE CodeName128 LIKE 'GATE_' + @AreaName
SELECT Service, ID, CodeName128, AssocRefObjCodeName128, AssocRefObjID, ZoneName128, GenRegionID, GenPos_X, GenPos_Y, GenPos_Z, GenAreaRadius, CanBeResurrectPos, CanGotoResurrectPos, GenWorldID
FROM SRO_VT_SHARD.._RefTeleport
WHERE CodeName128 LIKE 'GATE_' + @AreaName
END
ELSE
BEGIN
SELECT 'Could''t find _RefTeleport line, after you''ve create a teleporter run the following query: '
SELECT 'UPDATE _RefTeleport SET GenWorldID = @WorldID WHERE CodeName128 LIKE ''PORTERNAMEHERE'' '
END
SELECT *, '', 'OLD LINES!!! @_RefInstance_World_Region'
FROM SRO_VT_SHARD.._RefInstance_World_Region
WHERE RegionID = @RegionID
DELETE FROM SRO_VT_SHARD.._RefInstance_World_Region WHERE RegionID = @RegionID
INSERT INTO SRO_VT_SHARD.._RefInstance_World_Region (WorldID, RegionID)
VALUES (1, @RegionID),
(@WorldID, @RegionID)
SELECT 'Old lines at _RefInstance_World_Region have been deleted'
SELECT *, '', 'OLD LINES!!! @_RefInstance_World_Start_Pos & new ones added'
FROM SRO_VT_SHARD.._RefInstance_World_Start_Pos
WHERE RegionID = @RegionID
DELETE FROM SRO_VT_SHARD.._RefInstance_World_Start_Pos
INSERT INTO SRO_VT_SHARD.._RefInstance_World_Start_Pos (WorldID, RegionID, PosX, PosY, PosZ, Param)
SELECT @WorldID, @RegionID, @PosX, @PosY, @PosZ, 0
SELECT 'Old lines at _RefInstance_World_Start_Pos have been deleted & new ones added'
END TRY
BEGIN CATCH
DECLARE @ErMessage NVARCHAR(2048) = 'Error occured at RefGameWorld Update/Insert | ERR MSG: ' + ERROR_MESSAGE(),
@ErSeverity INT = ERROR_SEVERITY(),
@ErState INT = ERROR_STATE();
RAISERROR (@ErMessage, @ErSeverity, @ErState)
ROLLBACK TRAN
RETURN
[SQL] Query to create HwanLevels in 3 seconds 04/29/2013 - SRO PServer Guides & Releases - 3 Replies so i made this quickly cuz i had to make some zerk levels.
its done pretty badly actually xD
however it works (it has a shitload of unnessesary code but who gives a shit)
Declare @1 varchar(max)
declare @2 varchar(max)
declare @3 varchar(max)
declare @4 varchar(max)
declare @5 int
[Question]How to create memver for array of class instance 10/19/2012 - C/C++ - 9 Replies Hey,
i dont know how do search in google for this question so i decided to ask it here.
I am trying to do something like that.
class A
{
private:
int variable;
};
Hidden Dungeons + Instance problem 07/22/2012 - Rappelz Private Server - 13 Replies Hello everyone
I have a problem with the hidden dungeons and the instance(cubric+volc)
when i enter the hidden dungeon everything is fine all the mobs are good
the boss are there , but i can use all the feathers + when i dc i stay there!
and the instance i cant use fethears but when i dc i stay ther
I've checked my 7.4 Newmaps and they're working 100% with the 7.3 gameserver but not with 7.4 :mad:
Sql query for create character got lv 170 02/04/2012 - Dekaron Private Server - 21 Replies stop saying nonsense words to me , i need help with sql query of create new character and login game got lv 170 .
![[QUERY] Create Instance / Dungeons](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/query-create-instance-dungeons_ltr.gif){kind=small}
read the query to know pretty easy
thanks anyway xD worked well ^^
