vSro 1.188 Server Files + client D12 Jupiter orginal

[therock2007e]

Done
Fixed Spawn npc- Mob
Fixed Traggers
Fixed Quest jupiter
Fixed Drop Rate

now Going to test Database ....

add Skill GM in Server Files

Done Test game and Database all work

upload Update v1.2

now setup server files + Database ver 1.2
if you need this update

Link DownLoad

[BananaOG]

fix F10 disconect???

[therock2007e]

upload ver 1.3 Fixed Temple jupiter

Originally Posted by BananaOG

fix F10 disconect???

all work in my server files

[GMKING1050]

screenshots of doors

[thanhson8197]

all pet spawn bug crash when enable all region

[therock2007e]

Originally Posted by thanhson8197

all pet spawn bug crash when enable all region

OK I WILL TEST This

[thanhson8197]

i restore databse and modify _RefRegionBindAssocServer only. not change everything. spawn pet will disconect.

[zagorodnov]

Originally Posted by thanhson8197

i restore databse and modify _RefRegionBindAssocServer only. not change everything. spawn pet will disconect.

Same... and jupiter room don't work .

[haiitsystem]

Originally Posted by thanhson8197

i restore databse and modify _RefRegionBindAssocServer only. not change everything. spawn pet will disconect.

USE SRO_VT_SHARD
update Tab_RefNest Set dwMaxTotalCount = 4 where dwMaxTotalCount >= 5 and dwMaxTotalCount <= 10
update Tab_RefNest Set dwMaxTotalCount = 4 where dwMaxTotalCount >= 10 and dwMaxTotalCount <= 15
update Tab_RefNest Set dwMaxTotalCount = 4 where dwMaxTotalCount >= 15

Originally Posted by zagorodnov

Same... and jupiter room don't work .

You check slot mob, and Reduce the number of mobs available
It will work normally

[thanhson8197]

Originally Posted by haiitsystem

USE SRO_VT_SHARD
update Tab_RefNest Set dwMaxTotalCount = 4 where dwMaxTotalCount >= 5 and dwMaxTotalCount <= 10
update Tab_RefNest Set dwMaxTotalCount = 4 where dwMaxTotalCount >= 10 and dwMaxTotalCount <= 15
update Tab_RefNest Set dwMaxTotalCount = 4 where dwMaxTotalCount >= 15



You check slot mob, and Reduce the number of mobs available
It will work normally

thx i will try

[jhoan3d]

man u add Auto Equipment System?

[igfnike666]

Beginner Temple of Jupiter don´t work

[jhoan3d]

This is the query if it generates some lag to future nose but it solves the respaw well believe me they are born of a the mob and this good xD

USE VSRO_SHARD
Go
declare @minLv int = 1
declare @MaxLv int = 120
declare @MaxSpawn int = 2 -- Düşük: 1~3 || Normal: 4~7 || Yüksek: 8~12
declare @respawnTimeMin int = 1 -- Saniye
declare @respawnTimeMax int = 2 -- Saniye

if (@MaxSpawn < 1 or @MaxSpawn > 12)
print '1''den küçük yada 12''den büyük spawn sayıları kararsız sonuçlar doğurabilir.'
else if (@respawnTimeMin < 1)
print '1''den küçük saniyede respawn kararsız sonuçlara neden olabilir.'
else if (@respawnTimeMin >= @respawnTimeMax)
print 'RespawnTimeMin, RespawnTimeMax değerine eşit yada bu değerden büyük olamaz.'
else if (@minLv > @MaxLv)
print 'MinLv MaxLv''den büyük olamaz.'
else
begin
--select D.*
update D set dwDelayTimeMin = @respawnTimeMin, dwDelayTimeMax = @respawnTimeMax, dwMaxTotalCount = @MaxSpawn
from _RefObjCommon as A
inner join _RefObjChar as B on A.Link = B.ID and A.CodeName128 like 'MOB%' and A.Rarity = 0 and B.Lvl between @minLv and @MaxLv
inner join Tab_RefTactics as C on C.dwObjID = A.ID
inner join Tab_RefNest as D on D.dwTacticsID = C.dwTacticsID and D.dwMaxTotalCount > 0 and D.dwDelayTimeMin > 0
end

[Mr Terrorist]

Nice, good job!

[GMKING1050]

Dead DB - Use Stattic DB Better