Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 00:54

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



problem with unique spawn point

Discussion on problem with unique spawn point within the SRO Private Server forum part of the Silkroad Online category.

Closed Thread
 
Old   #1

 
devdash's Avatar
 
elite*gold: 14
Join Date: Feb 2016
Posts: 1,607
Received Thanks: 445
problem with unique spawn point

hello guys
i want to add medusa spown to a place, how can i do that ?
i tried to change the original medusa of JanganCave b4 place to the place i want, but i faild, i still can't see it
so i think i need to add new line or something, help me please..

THANKS IN ADVANCED
devdash is offline  
Old 02/04/2018, 23:04   #2
 
NorseGodTyr's Avatar
 
elite*gold: 0
Join Date: May 2013
Posts: 2,223
Received Thanks: 1,482
i can give you an example by me on my Cap80 server i have added old taishan Unique level 50 around Hotan with 7 Spawn Point and 2 World Boss Roc & Rage Cloud with 25 spawn Point random Jangan downhang hotan

also here a Example from Taishan

RefTactics
46061 24637 0 500 50 150 0 0 2 2 2 0 0 5 0 0 0 0 0 30 0 0 4 0 0 0 0 0 0 0 0 0 0 0 1 500 0 0 2 0 0 112 MOB_KT_BOSSSPIDER

RefHive
1575 0 1 0 0 0 0 1 1 MOB_KT_BOSSSPIDER

Refnest
36832 1575 46061 25226 1 21 1014 0 1000 600 0 7200 10800 1 0 1 0
36833 1575 46061 24711 440 27 1183 0 1000 600 0 7200 10800 1 0 1 0
36834 1575 46061 24196 1534 410 1570 0 1000 600 0 7200 10800 1 0 1 0
36835 1575 46061 23173 1565 266 1067 0 1000 600 0 7200 10800 1 0 1 0
36836 1575 46061 22919 1646 20 1180 0 1000 600 0 7200 10800 1 0 1 0
36837 1575 46061 23435 1564 -7 533 0 1000 600 0 7200 10800 1 0 1 0
36838 1575 46061 24202 161 -7 1254 0 1000 600 0 7200 10800 1 0 1 0
NorseGodTyr is offline  
Thanks
1 User
Old 02/05/2018, 04:07   #3

 
devdash's Avatar
 
elite*gold: 14
Join Date: Feb 2016
Posts: 1,607
Received Thanks: 445
Quote:
Originally Posted by mialuisa View Post
i can give you an example by me on my Cap80 server i have added old taishan Unique level 50 around Hotan with 7 Spawn Point and 2 World Boss Roc & Rage Cloud with 25 spawn Point random Jangan downhang hotan

also here a Example from Taishan

RefTactics
46061 24637 0 500 50 150 0 0 2 2 2 0 0 5 0 0 0 0 0 30 0 0 4 0 0 0 0 0 0 0 0 0 0 0 1 500 0 0 2 0 0 112 MOB_KT_BOSSSPIDER

RefHive
1575 0 1 0 0 0 0 1 1 MOB_KT_BOSSSPIDER

Refnest
36832 1575 46061 25226 1 21 1014 0 1000 600 0 7200 10800 1 0 1 0
36833 1575 46061 24711 440 27 1183 0 1000 600 0 7200 10800 1 0 1 0
36834 1575 46061 24196 1534 410 1570 0 1000 600 0 7200 10800 1 0 1 0
36835 1575 46061 23173 1565 266 1067 0 1000 600 0 7200 10800 1 0 1 0
36836 1575 46061 22919 1646 20 1180 0 1000 600 0 7200 10800 1 0 1 0
36837 1575 46061 23435 1564 -7 533 0 1000 600 0 7200 10800 1 0 1 0
36838 1575 46061 24202 161 -7 1254 0 1000 600 0 7200 10800 1 0 1 0
i realy appreciate ur help but i still didn't understand how can i do it , sorry iam kinda newbie on this ...
can u please explain more, u can tell me do that and do that, and i will do it, i can follow if u give me steps...
THANKS AGAIN
devdash is offline  
Old 02/05/2018, 09:22   #4
 
NorseGodTyr's Avatar
 
elite*gold: 0
Join Date: May 2013
Posts: 2,223
Received Thanks: 1,482
Quote:
Originally Posted by alydandy View Post
i realy appreciate ur help but i still didn't understand how can i do it , sorry iam kinda newbie on this ...
can u please explain more, u can tell me do that and do that, and i will do it, i can follow if u give me steps...
THANKS AGAIN
Also use any query to add new Unique spot
use it on more spawn point in any region ( dont forget alltimes to log off than use query and go next spot ) if you done with adding open 3 Table
Refnest & RefHive & RefTactics also an example you added 7x medusa
delete 6 lines from medusa in RefTactics
and 6 Lines from medusa in RefHive
Example you have only 1 line from Meduas RefTactics( Green is the TacticsID & Blue MobID
46061 24637 0 500 50 150 0 0 2 2 2 0 0 5 0 0 0 0 0 30 0 0 4 0 0 0 0 0 0 0 0 0 0 0 1 500 0 0 2 0 0 112 MOB_KT_BOSSSPIDER

and an example for RefHive ( rerHive ID isred
1575 0 1 0 0 0 0 1 1 MOB_KT_BOSSSPIDER

so after you do all go to Refnest dont delete a Line if you want 7 spawn Point
and Replace the old ID with the new RefHiveID and RefTacticsID
36832 1575 46061 25226 1 21 1014 0 1000 600 0 7200 10800 1 0 1 0
36833 1575 46061 24711 440 27 1183 0 1000 600 0 7200 10800 1 0 1 0
36834 1575 46061 24196 1534 410 1570 0 1000 600 0 7200 10800 1 0 1 0
36835 1575 46061 23173 1565 266 1067 0 1000 600 0 7200 10800 1 0 1 0
36836 1575 46061 22919 1646 20 1180 0 1000 600 0 7200 10800 1 0 1 0
36837 1575 46061 23435 1564 -7 533 0 1000 600 0 7200 10800 1 0 1 0
36838 1575 46061 24202 161 -7 1254 0 1000 600 0 7200 10800 1 0 1 0
NorseGodTyr is offline  
Thanks
1 User
Old 02/05/2018, 15:37   #5

 
devdash's Avatar
 
elite*gold: 14
Join Date: Feb 2016
Posts: 1,607
Received Thanks: 445
Quote:
Originally Posted by mialuisa View Post
Also use any query to add new Unique spot
use it on more spawn point in any region ( dont forget alltimes to log off than use query and go next spot ) if you done with adding open 3 Table
Refnest & RefHive & RefTactics also an example you added 7x medusa
delete 6 lines from medusa in RefTactics
and 6 Lines from medusa in RefHive
Example you have only 1 line from Meduas RefTactics( Green is the TacticsID & Blue MobID
46061 24637 0 500 50 150 0 0 2 2 2 0 0 5 0 0 0 0 0 30 0 0 4 0 0 0 0 0 0 0 0 0 0 0 1 500 0 0 2 0 0 112 MOB_KT_BOSSSPIDER

and an example for RefHive ( rerHive ID isred
1575 0 1 0 0 0 0 1 1 MOB_KT_BOSSSPIDER

so after you do all go to Refnest dont delete a Line if you want 7 spawn Point
and Replace the old ID with the new RefHiveID and RefTacticsID
36832 1575 46061 25226 1 21 1014 0 1000 600 0 7200 10800 1 0 1 0
36833 1575 46061 24711 440 27 1183 0 1000 600 0 7200 10800 1 0 1 0
36834 1575 46061 24196 1534 410 1570 0 1000 600 0 7200 10800 1 0 1 0
36835 1575 46061 23173 1565 266 1067 0 1000 600 0 7200 10800 1 0 1 0
36836 1575 46061 22919 1646 20 1180 0 1000 600 0 7200 10800 1 0 1 0
36837 1575 46061 23435 1564 -7 533 0 1000 600 0 7200 10800 1 0 1 0
36838 1575 46061 24202 161 -7 1254 0 1000 600 0 7200 10800 1 0 1 0
i will try that now and i will be back with the results

Quote:
Originally Posted by mialuisa View Post
Also use any query to add new Unique spot
use it on more spawn point in any region ( dont forget alltimes to log off than use query and go next spot ) if you done with adding open 3 Table
Refnest & RefHive & RefTactics also an example you added 7x medusa
delete 6 lines from medusa in RefTactics
and 6 Lines from medusa in RefHive
Example you have only 1 line from Meduas RefTactics( Green is the TacticsID & Blue MobID
46061 24637 0 500 50 150 0 0 2 2 2 0 0 5 0 0 0 0 0 30 0 0 4 0 0 0 0 0 0 0 0 0 0 0 1 500 0 0 2 0 0 112 MOB_KT_BOSSSPIDER

and an example for RefHive ( rerHive ID isred
1575 0 1 0 0 0 0 1 1 MOB_KT_BOSSSPIDER

so after you do all go to Refnest dont delete a Line if you want 7 spawn Point
and Replace the old ID with the new RefHiveID and RefTacticsID
36832 1575 46061 25226 1 21 1014 0 1000 600 0 7200 10800 1 0 1 0
36833 1575 46061 24711 440 27 1183 0 1000 600 0 7200 10800 1 0 1 0
36834 1575 46061 24196 1534 410 1570 0 1000 600 0 7200 10800 1 0 1 0
36835 1575 46061 23173 1565 266 1067 0 1000 600 0 7200 10800 1 0 1 0
36836 1575 46061 22919 1646 20 1180 0 1000 600 0 7200 10800 1 0 1 0
36837 1575 46061 23435 1564 -7 533 0 1000 600 0 7200 10800 1 0 1 0
36838 1575 46061 24202 161 -7 1254 0 1000 600 0 7200 10800 1 0 1 0
i just used ur lines for RefNest RefTactics RefHive and i changed the unique name and unique id and Unique spawn place and i changed dwDelayTimeMin and dwDelayTimeMax both with 300 , because i want to see that unique appeared every 5 minutes after death, but when i kill it, it never appear again, what should i do, please help...
devdash is offline  
Old 02/06/2018, 01:36   #6
 
elite*gold: 0
Join Date: Feb 2018
Posts: 7
Received Thanks: 6
USE SRO_VT_SHARD

DECLARE @ VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
DECLARE @mindealy INT
DECLARE @maxdelay int
DECLARE @INITRADIUS INT
DECLARE @ int
DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1

/* put your settings here */
SET @ = 'MOB_JUPITER_YUNO' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 60 -- Minimum time before appears in seconds
SET @maxdelay = 120 -- Maximum time before appears in seconds
SET @INITRADIUS = 100 -- Radius around spot unique can generated at
SET @ = 500 -- Radius around spot Unique can move in
/* end of settings area */

/* get ID of mob by code name */
Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @)

SET IDENTITY_INSERT Tab_RefTactics ON
INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStam inaVariance,nSightRange,btAggressType,AggressData, btChangeTarget,btHelpRequestTo,btHelpResponseTo,bt BattleStyle,BattleStyleData,btDiversionBasis,Diver sionBasisData1,DiversionBasisData2,DiversionBasisD ata3,DiversionBasisData4,DiversionBasisData5,Diver sionBasisData6,DiversionBasisData7,DiversionBasisD ata8,btDiversionKeepBasis,DiversionKeepBasisData1, DiversionKeepBasisData2,DiversionKeepBasisData3,Di versionKeepBasisData4,DiversionKeepBasisData5,Dive rsionKeepBasisData6,DiversionKeepBasisData7,Divers ionKeepBasisData8,btKeepDistance,KeepDistanceData, btTraceType,btTraceBoundary,TraceData,btHomingType ,HomingData,btAggressTypeOnHoming,btFleeType,dwCha mpionTacticsID,AdditionOptionFlag,szDescString128) VALUES
(@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0 ,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0, 2,0,0,112 @)
SET IDENTITY_INSERT Tab_RefTactics OFF

SET IDENTITY_INSERT Tab_RefHive ON
INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTot alCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRat e,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjTyp e,szDescString128) VALUES
(@MAXHIVE,0,1,0,0,0,0,1,1 @)
SET IDENTITY_INSERT Tab_RefHive OFF

/* get position coordinates of your character */

DECLARE @ INT SET @ = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @ INT SET @ = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @ INT SET @ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)

SET IDENTITY_INSERT Tab_RefNest ON
INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalP osX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGen erateRadius,nChampionGenPercentage,dwDelayTimeMin, dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,bt Type) VALUES
(@MAXNEST,@MAXHIVE,@MAXTACTICS @,@POSX @ @,0 @,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0)
SET IDENTITY_INSERT Tab_RefNest OFF


print ''
print ''
print 'Done!'
MrXEON is offline  
Thanks
1 User
Old 02/06/2018, 01:43   #7

 
devdash's Avatar
 
elite*gold: 14
Join Date: Feb 2016
Posts: 1,607
Received Thanks: 445
Quote:
Originally Posted by MrXEON View Post
USE SRO_VT_SHARD

DECLARE @ VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
DECLARE @mindealy INT
DECLARE @maxdelay int
DECLARE @INITRADIUS INT
DECLARE @ int
DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1

/* put your settings here */
SET @ = 'MOB_JUPITER_YUNO' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 60 -- Minimum time before appears in seconds
SET @maxdelay = 120 -- Maximum time before appears in seconds
SET @INITRADIUS = 100 -- Radius around spot unique can generated at
SET @ = 500 -- Radius around spot Unique can move in
/* end of settings area */

/* get ID of mob by code name */
Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @)

SET IDENTITY_INSERT Tab_RefTactics ON
INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStam inaVariance,nSightRange,btAggressType,AggressData, btChangeTarget,btHelpRequestTo,btHelpResponseTo,bt BattleStyle,BattleStyleData,btDiversionBasis,Diver sionBasisData1,DiversionBasisData2,DiversionBasisD ata3,DiversionBasisData4,DiversionBasisData5,Diver sionBasisData6,DiversionBasisData7,DiversionBasisD ata8,btDiversionKeepBasis,DiversionKeepBasisData1, DiversionKeepBasisData2,DiversionKeepBasisData3,Di versionKeepBasisData4,DiversionKeepBasisData5,Dive rsionKeepBasisData6,DiversionKeepBasisData7,Divers ionKeepBasisData8,btKeepDistance,KeepDistanceData, btTraceType,btTraceBoundary,TraceData,btHomingType ,HomingData,btAggressTypeOnHoming,btFleeType,dwCha mpionTacticsID,AdditionOptionFlag,szDescString128) VALUES
(@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0 ,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0, 2,0,0,112 @)
SET IDENTITY_INSERT Tab_RefTactics OFF

SET IDENTITY_INSERT Tab_RefHive ON
INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTot alCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRat e,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjTyp e,szDescString128) VALUES
(@MAXHIVE,0,1,0,0,0,0,1,1 @)
SET IDENTITY_INSERT Tab_RefHive OFF

/* get position coordinates of your character */

DECLARE @ INT SET @ = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @ INT SET @ = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @ INT SET @ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)

SET IDENTITY_INSERT Tab_RefNest ON
INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalP osX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGen erateRadius,nChampionGenPercentage,dwDelayTimeMin, dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,bt Type) VALUES
(@MAXNEST,@MAXHIVE,@MAXTACTICS @,@POSX @ @,0 @,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0)
SET IDENTITY_INSERT Tab_RefNest OFF


print ''
print ''
print 'Done!'
iam sure that u are trying to help and i realy appreciate that, but query without instruction about how to use it, is usless for me, because iam compeltly new on this scene...so Excuse me can u explain ...
devdash is offline  
Old 02/06/2018, 05:07   #8
 
elite*gold: 0
Join Date: Feb 2018
Posts: 7
Received Thanks: 6
Quote:
Originally Posted by alydandy View Post
iam sure that u are trying to help and i realy appreciate that, but query without instruction about how to use it, is usless for me, because iam compeltly new on this scene...so Excuse me can u explain ...
its already have the guide read the lines
charname > go to the spot what u want and wrote the char name

mob id > mob code

then execute it in SQL press F5
MrXEON is offline  
Thanks
1 User
Closed Thread


Similar Threads Similar Threads
Problem to create a Spawn Point!
01/08/2023 - Shaiya Private Server - 3 Replies
Hello, i want to create a spawn point in GM Aren (/cmove 39). i make it so when you go in the Portal in Apulune/Iris, where stands Battle Zone, you will be on GM Arena... but now when you I get killed in GM Arena I spawn at Apulune/Iris and i dont want it so... With the Tut from SrShaden (http://www.elitepvpers.com/.../959612-tutorial-sh aiya-updater.html) i have extract the 39.svmap file to any .csv files and then i write in spawns.csv this: Does anyone know why it doesnt work? **Sorry...
[Selling] Best Arma 3 Money spawn - Gear spawn - Vehicles spawn *ON EVERY SERVER*
12/26/2014 - ArmA Trading - 0 Replies
bojkastros Arma 3 Shop ist offen - Geld Spawn - Ausrüstungs Spawn- Fahrzeuge spawnen * auf jedem Server * Geld 2 mil = 1,50 euro 4 mil = 2,50 euro So viel geld wie ihr wollt = 8 euro
Unique spawn point
08/27/2013 - SRO Private Server - 0 Replies
Hey guys and girls, I want to change the spawn point from Yuno, Baal, Jupiter and Babilion. I searched for the ID's at refobjcommon after that i searched for the tacticsID at TAB_REFTACTICS after that i searched the corresponding id at tab_refnest. Here i changed the location and the spawn time. However.... The mobs don't spawn at the point where i want them ( made a char, logged it of and took those positions ) If i look in the cave's, then i can't find them. So they have moved but...
[Guide] Unique spawn Area & Multi-spawn! & hints to Add New Uniqes ! [Vsro]
02/17/2013 - SRO PServer Guides & Releases - 31 Replies
Please Follow this thread, this topic OUTDATE and it have alot of wrong information http://www.elitepvpers.com/forum/private-sro-expl oits-hacks-bots-guides/2339110-epic-release-us-uni que-spot.html Well as you can read from the topic title lets start USE
[Help] SQL Query to make all unique spawn in one point :P
08/09/2012 - SRO Private Server - 0 Replies
SQL Query to make all unique spawn in one point :P Thanks :) <3



All times are GMT +1. The time now is 00:54.


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.