[QUERY] Create Instance / Dungeons

[​Exo]

Originally Posted by ILowe

How it works?

It does not but, it has all the needed information you need to make it work.

Try reading it xD

[Bocc1337]

Please enplane how to use this im having trouble with it..thx

[ILowe]

exec dbo._RoyalCreateInstance 
@Charname='TEST', 
@AreaName='NEW_QUEST', 
@MaxWorlds='200', 
@MaxPlayers='200',
@MinEntranceLevel='110',
@MaxEnterPerDay='10',
@HorseAllowed='OFF'

error?

[​Exo]

Originally Posted by ILowe

exec dbo._RoyalCreateInstance 
@Charname='TEST', 
@AreaName='NEW_QUEST', 
@MaxWorlds='200', 
@MaxPlayers='200',
@MinEntranceLevel='110',
@MaxEnterPerDay='10',
@HorseAllowed='OFF'

error?

Did you even read the data types?

PHP Code:

@Charname VARCHAR(32), 
@AreaName VARCHAR(32), 
@MaxWorlds INT, 
@MaxPlayers INT, 
@MinEntranceLevel TINYINT, 
@MaxEnterPerDay TINYINT, 
@HorseAllowed BIT, 
@JobAllowed BIT, 
@PetAllowed BIT 


[Aaron*]

A little fix :

CREATE PROCEDURE _RoyalCreateInstance
@Charname VARCHAR(32),
@AreaName VARCHAR(32),
@MaxWorlds INT,
@MaxPlayers INT,
@MinEntranceLevel TINYINT,
@MaxEnterPerDay TINYINT,
@HorseAllowed BIT,
@JobAllowed BIT,
@PetAllowed BIT
AS

BEGIN TRAN
BEGIN TRY

DECLARE @JobAllowedString VARCHAR(3) = CASE
WHEN @JobAllowed = 1
THEN 'OFF'
ELSE 'ON'
END,
@PetAllowedString VARCHAR(3) = CASE
WHEN @PetAllowed = 1
THEN 'OFF'
ELSE 'ON'
END,
@HorseAllowedString VARCHAR(3) = CASE
WHEN @HorseAllowed = 1
THEN 'OFF'
ELSE 'ON'
END,
@WorldID INT,
@RegionID INT,
@PosX REAL,
@PosY REAL,
@PosZ REAL;

SELECT @RegionID = LatestRegion,
@PosX = PosX,
@PosY = PosY,
@PosZ = PosZ
FROM SRO_VT_SHARD.._Char
WHERE CharName16 = @Charname

IF @RegionID IS NULL
BEGIN
ROLLBACK TRAN
RAISERROR ('Charname not found', 16, 0)
RETURN
END

DELETE FROM SRO_VT_SHARD.._RefGame_World_Config WHERE GroupCodeName128 = 'GROUP_' + @AreaName
INSERT INTO SRO_VT_SHARD.._RefGame_World_Config (Service, GroupCodeName128, ValueCodeName128, Value, Type)
VALUES (1, 'GROUP' + @AreaName, 'GAME_WORLD_NORMALIZE_TYPE', 'GAME_WORLD_NORMALIZE_TYPE_A', 'STRING'),
(1, 'GROUP' + @AreaName, 'ENTER_LIMIT_CONDITION_ENTRY', 'NUM_LIMIT', 'STRING'),
(1, 'GROUP' + @AreaName, 'ENTER_LIMIT_CONDITION_PARTY', 'ON', 'STRING'),
(1, 'GROUP' + @AreaName, 'ENTER_LIMIT_CONDITION_LEVEL_MINIMUM_NUM', CAST(@MinEntranceLevel AS VARCHAR(5)), 'INT32'),
(1, 'GROUP' + @AreaName, 'ENTER_LIMIT_CONDITION_ENTRY_MAXIMUM_NUM', CAST(@MaxEnterPerDay AS VARCHAR(5)), 'INT32'),
(1, 'GROUP' + @AreaName, 'ENTER_LIMIT_CONDITION_REENTRY', 'ON', 'STRING'),
(1, 'GROUP' + @AreaName, 'ENTER_LIMIT_CONDITION_JOB_CLOTHES_TAKE_OFF', @JobAllowedString, 'STRING'),
(1, 'GROUP' + @AreaName, 'ENTER_LIMIT_CONDITION_RIDE_COS_NOT_RIDING', @HorseAllowedString, 'STRING'),
(1, 'GROUP' + @AreaName, 'ENTER_LIMIT_CONDITION_TRADE_COS_NOT_RIDING', @PetAllowedString, 'STRING'),
(1, 'GROUP' + @AreaName, 'ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED', 'ON', 'STRING'),
(1, 'GROUP' + @AreaName, 'PARTYMONSTER_SPAWN', 'OFF', 'STRING'),
(1, 'GROUP' + @AreaName, 'ENTER_LIMIT_CONDITION_FRPVP_VOUCHER_TAKE_OFF', 'ON', 'STRING'),
(1, 'GROUP' + @AreaName, 'REF_GAME_WORLD_NPC', 'INS_' + @AreaName, 'STRING')

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 where RegionID = @RegionID
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

END CATCH

COMMIT TRAN

But it will keep returning this error as well

Msg 50000, Level 16, State 1, Procedure _RoyalCreateInstance, Line
127 Error occured at RefGameWorld Update/Insert | ERR MSG: Conversion
failed when converting the varchar value 'GAME_WORLD_NORMALIZE_TYPE_A'
to data type bit.

i'm trying hard to fix this error.

[​Exo]

^You're probably doing something weird, like a wrong insert or something, 'GAME_WORLD_NORMALIZE_TYPE_A' is only used at 1 insertion which is the value of 'Value' column at the table I don't know why this is converted in your query

[​Bodo]

Originally Posted by blablaRoyal

but all the arabs are gonna fail.

We'll see about that

[Aaron*]

after fixing the whole errors,
That part f**ked up my db lol

DELETE FROM SRO_VT_SHARD.._RefInstance_World_Start_Pos

stop drinking alcohol dude xD

[​Exo]

Just read the **** query, add them manually... after you've done it once or twice re-write it.

[Bocc1337]

make a example .say like devils garden in the petra files or some thing

[Riddick*]

tried to make it works -.-

[Royalblade*]

I just love it how rabs fail. Check the first post *******, this is INCOMPLETE.

It has the logic. Read it, insert it manually. Done.
I finished inserting **** manually faster than writing that ****, so it wasn't ever finished. There are probably **** tons of errors since it wasnt even checked.

Still has the needed stuff.

[​Exo]

Akasch, please do not answer this question.... at least not here

Aeron => Personal reasons could be understood in the wrong way so if he answers and it offenses a race or a group it would be a problem for every side of the discussion so avoid this kind of ****.

[Bocc1337]

please show a example.

[Royalblade*]

Originally Posted by Aeron*

I already inserted it manually but it didn't work either,btw why do you hate arabs?

i dont hste araba. I just dont like the ppl living in the middle east. All those stupid people, 99% of them. Including you.

Exorcist is okay though.