Active Zone Pvp 100% Working

Printable View

Show 100 post(s) from this thread on one page

31-07-12
denise456

1 Attachment(s)

Active Zone Pvp 100% Working

1° QUERY

Code:

USE [SRO_VT_SHARD] GO UPDATE dbo._RefInstance_World_Region SET WorldID = 1 WHERE RegionID BETWEEN 32475 AND 32476

2° QUERY

Code:

USE [SRO_VT_SHARD] GO UPDATE dbo._RefRegionBindAssocServer SET AssocServer = 1 WHERE AreaName = 'ARENA_OCCUPY' UPDATE dbo._RefRegionBindAssocServer SET AssocServer = 1 WHERE AreaName = 'ARENA_FLAG' UPDATE dbo._RefRegionBindAssocServer SET AssocServer = 1 WHERE AreaName = 'ARENA_SCORE' UPDATE dbo._RefRegionBindAssocServer SET AssocServer = 1 WHERE AreaName = 'ARENA_GNGWC'

ScreenShot
http://forum.ragezone.com/attachment...9&d=1343706595

Teleport Zone

Code:

/warp 32474 3933 659 959

Walks In The Area

Code:

/addwp NameChar

Walk On it

Code:

/wp NameChar

Credits:xxNukertube
Credits:LegendM
31-07-12
ahmedov

Re: Active Zone Pvp 100% Working

How Can i Add This PLace To Teleport In Jangan
31-07-12
denise456

Re: Active Zone Pvp 100% Working

add teleport zone http://forum.ragezone.com/f722/sql-q...custom-858564/
31-07-12
ahmedov

Re: Active Zone Pvp 100% Working

Can I Have Any Ur Contact i want some help in media please ?

Working Approved But Want to Ask ? Can i Make The Place Bigger Its Small
31-07-12
uTorrent

Re: Active Zone Pvp 100% Working

Thx To much

Have other's warps?
31-07-12
ahmedov

Re: Active Zone Pvp 100% Working

In The Query Of teleport Creat
I Get This __> Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'SE'.

In The Query Of teleport Creat
I Get This __> Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'SE'.
31-07-12
K4bo

Re: Active Zone Pvp 100% Working

it's not a pvp zone it's Arena Occupy M or L
31-07-12
denise456

Re: Active Zone Pvp 100% Working

I asked him?
31-07-12
adminsxza

Re: Active Zone Pvp 100% Working

Msg 8106, Level 16, State 1, Line 33
Table '_RefObjCommon' does not have the identity property. Cannot perform SET operation.
Error
31-07-12
uTorrent

Re: Active Zone Pvp 100% Working

Use query work sucefull try this

Code:

USE SRO_VT_SHARD /* Add new Teleport By Arabianfox */ DECLARE @Teleport VARCHAR (64) DECLARE @CHARNAME1 VARCHAR (30) DECLARE @CHARNAME2 VARCHAR (30) DECLARE @OwnTeleport INT DECLARE @Fee INT DECLARE @RequiredLVL INT /* Put your settings here */ SET @Teleport = 'PVP_ZONE' -- any name you want ex: PK_ZONE or PVP_ZONE SET @CHARNAME1 = 'CHARNAME1' -- Teleport position SET @CHARNAME2 = 'CHARNAME2' -- Spawn position after teleport SET @OwnTeleport = 1 -- Target teleport ID ex: 1 for Jangan - 5 for Hotan - 20 for Constantinople SET @Fee = 50000 -- Gold amount to Pass the teleport SET @RequiredLVL = 0 -- minimum level required to teleport 0 for no restriction - ex:90 lvl 90 and higher can teleport /* settings area end here */ IF EXISTS (SELECT CodeName128 FROM _RefObjCommon WHERE CodeName128 = 'STORE_'+@Teleport) BEGIN raiserror('The stated teleportname of %s is already exist!',11,1,@Teleport); RETURN; END DECLARE @MAXOBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1 DECLARE @REGION1 INT SET @REGION1 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME1) DECLARE @POSX1 INT SET @POSX1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME1) DECLARE @POSY1 INT SET @POSY1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME1) DECLARE @POSZ1 INT SET @POSZ1 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME1) DECLARE @LINK INT = (SELECT MAX (ID) FROM _RefObjStruct)+1 INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES (1,@MAXOBJ,'STORE_'+@Teleport,@Teleport,'xxx','SN_STORE_'+@Teleport,'xxx',0,0,4,1,1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,@REGION1,0,@POSX1,@POSY1,@POSZ1,0,0,50,50,30,0,'quest\teleport01.bsr','xxx','xxx','xxx','xxx',@link) print '' print 'Add the following line to teleportbuilding.txt @server_dep\silkroad\textdata folder' print '1 '+CONVERT(varchar(max),@MAXOBJ)+' '+'STORE_'+@Teleport+' '+@Teleport+' xxx '+'SN_STORE_'+@Teleport+' xxx 0 0 4 1 1 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 '+CONVERT(varchar(max),@REGION1)+' 0 '+CONVERT(varchar(max),@POSX1)+' '+CONVERT(varchar(max),@POSY1)+' '+CONVERT(varchar(max),@POSZ1)+' 0 0 50 50 30 0 quest\teleport01.bsr xxx xxx xxx xxx '+CONVERT(varchar(max),@link) print '' print 'Add the following line to textdata_object.txt @server_dep\silkroad\textdata folder' print '' print '1 '+'SN_STORE_'+@Teleport+' '+@Teleport print '' print '' SET IDENTITY_INSERT _RefObjStruct ON INSERT INTO _RefObjStruct (ID,Dummy_Data) VALUES (@LINK,0) SET IDENTITY_INSERT _RefObjStruct OFF DECLARE @MAXTELID INT = (SELECT MAX (ID) FROM _RefTeleport)+1 DECLARE @WORLDID INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME2) DECLARE @REGION2 INT SET @REGION2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME2) DECLARE @POSX2 INT SET @POSX2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME2) DECLARE @POSY2 INT SET @POSY2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME2) DECLARE @POSZ2 INT SET @POSZ2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME2) INSERT INTO _RefTeleport (Service,ID,CodeName128,AssocRefObjCodeName128,AssocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos_Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGotoResurrectPos,GenWorldID,BindInteractionMask,FixedService) VALUES (1,@MAXTELID,'GATE_'+@Teleport,'STORE_'+@Teleport,@MAXOBJ,'SN_STORE_'+@Teleport,@REGION2,@POSX2,@POSY2,@POSZ2,30,0,0,@WORLDID,1,0) print '' print 'Add the following line to teleportdata.txt @server_dep\silkroad\textdata folder' print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+'GATE_'+@Teleport+' '+CONVERT(varchar(max),@MAXOBJ)+' '+'SN_STORE_'+@Teleport+' '+CONVERT(varchar(max),@REGION2)+' '+CONVERT(varchar(max),@POSX2)+' '+CONVERT(varchar(max),@POSY2)+' '+CONVERT(varchar(max),@POSZ2)+' 30 0 0 '+CONVERT(varchar(max),@WORLDID)+' 1 0' print '' print '' IF @RequiredLVL = 0 BEGIN INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES (1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES (1,@MAXTELID,@OwnTeleport,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) print '' print 'Add the following lines to teleportlink.txt @server_dep\silkroad\textdata folder' print '1 '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0' print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0' print '' END ELSE BEGIN INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES (1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,1,@RequiredLVL,999,0,0,0,0,0,0,0,0,0,0,0,0) print '' print '' print 'Add the following line to teleportlink.txt @server_dep\silkroad\textdata folder' print '1 '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 1 '+CONVERT(varchar(max),@RequiredLVL)+' 999 0 0 0 0 0 0 0 0 0 0 0 0' print '' END print '' print 'Done!'

give thanks to http://forum.ragezone.com/f722/sql-q...custom-858564/
31-07-12
denise456

Re: Active Zone Pvp 100% Working

Feio D+
31-07-12
antoha

Re: Active Zone Pvp 100% Working

can u post the media files for that map? seems i dont have it, crashes constantly when i try to tp there.
31-07-12
uTorrent

Re: Active Zone Pvp 100% Working

you active in server?
you run this query?

Quote:

USE [SRO_VT_SHARD]
GO
UPDATE dbo._RefRegionBindAssocServer
SET AssocServer = 1
WHERE AreaName = 'ARENA_OCCUPY'
UPDATE dbo._RefRegionBindAssocServer
SET AssocServer = 1
WHERE AreaName = 'ARENA_FLAG'
UPDATE dbo._RefRegionBindAssocServer
SET AssocServer = 1
WHERE AreaName = 'ARENA_SCORE'
UPDATE dbo._RefRegionBindAssocServer
SET AssocServer = 1
WHERE AreaName = 'ARENA_GNGWC'

and restart server?
31-07-12
antoha

Re: Active Zone Pvp 100% Working

ye i did, i appear and try no move but the client crashes. nvm i fixed the issue with a different client.. some map txt files were facked i sepose.
31-07-12
MarquisX

Re: Active Zone Pvp 100% Working

umm, I think you've to put the lines of RefRegion about this area but i will try this one and see.

used the both querys and when i write the warp to go the area get a crash
I told you before you've to add lines in RefRegion.

I am added this 2 areas because I am added the RefRegion Lines of them and working fine and added a new custom teleport in them also

http://www12.0zz0.com/2012/07/31/15/686723469.jpg
http://www12.0zz0.com/2012/07/31/15/144407131.jpg
31-07-12
Over Limit

Re: Active Zone Pvp 100% Working

just saying , there's nothing call pvp zone/zone pvp -.-
what you did is just add teleport to battle arena zone lol
31-07-12
SupremeSRO

Re: Active Zone Pvp 100% Working

MarquisX could u gimme your Warps for these areas ?
31-07-12
MarquisX

Re: Active Zone Pvp 100% Working

If i get the area in this thread working on my server I will share my both areas also.
01-08-12
xxNukertube

Re: Active Zone Pvp 100% Working

Ty but vai tomar no cu
03-08-12
InsaneDev

Re: Active Zone Pvp 100% Working

i added the area successfully but when ad teleport i get crash on clicking select teleport area
03-08-12
xxNukertube

Re: Active Zone Pvp 100% Working

u noob
u cant add teleport
lol
03-08-12
InsaneDev

Re: Active Zone Pvp 100% Working

Quote:

Originally Posted by xxNukertube

u noob
u cant add teleport
lol

mind your own business and go to hell
03-08-12
Ezma

1 Attachment(s)

Re: Active Zone Pvp 100% Working

Come On Guys Just add My _RefInstance_World_Region in Your Database and All Arena Will Work [L] , [M] , [S] 100%
03-08-12
denise456

Re: Active Zone Pvp 100% Working

where warp all area?
03-08-12
InsaneDev

Re: Active Zone Pvp 100% Working

can anyone give me GM room warp??

Quote:

Originally Posted by MarquisX

If i get the area in this thread working on my server I will share my both areas also.

Giv me your skype and i will help you

Show 100 post(s) from this thread on one page