How do I add this to my existing vSRO files without overwriting the changes I've made?
Posted via Mobile Device
Printable View
How do I add this to my existing vSRO files without overwriting the changes I've made?
Posted via Mobile Device
There is a problem, Once your Spawn your grab pet, you get DC
if you find a fix, please let me know, I have the same problem with I spawn petQuote:
Originally Posted by arabcart
To fix the spawn use this queryQuote:
Originally Posted by elitebi
then use thisPHP Code:USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/2
and thisPHP Code:USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 1 where dwdelaytimemax = '21600' ;
U done i have a problem with jupiter caves i cant go inside, Just get frezze if someone have a fix? thxPHP Code:USE [SRO_VT_SHARD]
--B1
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32100 --B1 Unique
--B2
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32200 --Camp 8 Unique
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32300 --Camp 11 Unique
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32400 --Camp 11 Unique
--B3
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32500
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32600
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32700
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32800
ty antho, but can you please tell me how I put this querries?
To solve the problem that you can't buy from many shops at all towns:-
you need to insert this missing lines to _RefShopTab :
after adding all this lines copy all the contents of _RefShopTabCode:1 15 6417 STORE_KT_POTION_TAB2 STORE_KT_POTION_GROUP1 SN_TAB_SPECIAL
1 15 6418 STORE_KT_SMITH_TAB4 STORE_KT_SMITH_GROUP1 SN_TAB_SPECIAL
1 15 6419 STORE_KT_SMITH_EU_TAB4 STORE_KT_SMITH_EU_GROUP1 SN_TAB_SPECIAL
1 15 6420 STORE_KT_ACCESSORY_TAB4 STORE_KT_ACCESSORY_GROUP1 SN_TAB_SPECIAL
1 15 6421 STORE_KT_ACCESSORY_EU_TAB4 STORE_KT_ACCESSORY_EU_GROUP1 SN_TAB_SPECIAL
1 15 6422 STORE_KT_POTION_TAB3 STORE_KT_POTION_GROUP1 SN_TAB_SPECIAL
1 15 6423 STORE_KT_POTION_TAB4 STORE_KT_POTION_GROUP1 SN_TAB_SPECIAL
1 15 6424 STORE_KT_ARMOR_TAB7 STORE_KT_ARMOR_GROUP1 SN_TAB_SPECIAL
1 15 6426 STORE_KT_ARMOR_TAB8 STORE_KT_ARMOR_GROUP2 SN_TAB_SPECIAL
1 15 6427 STORE_KT_ARMOR_EU_TAB7 STORE_KT_ARMOR_EU_GROUP1 SN_TAB_SPECIAL
1 15 6428 STORE_KT_ARMOR_EU_TAB8 STORE_KT_ARMOR_EU_GROUP2 SN_TAB_SPECIAL
1 15 6429 STORE_CH_POTION_TAB2 STORE_CH_POTION_GROUP1 SN_TAB_SPECIAL
1 15 6430 STORE_CH_SMITH_TAB4 STORE_CH_SMITH_GROUP1 SN_TAB_SPECIAL
1 15 6431 STORE_CH_ACCESSORY_TAB4 STORE_CH_ACCESSORY_GROUP1 SN_TAB_SPECIAL
1 15 6432 STORE_CH_POTION_TAB3 STORE_CH_POTION_GROUP1 SN_TAB_SPECIAL
1 15 6433 STORE_CH_POTION_TAB4 STORE_CH_POTION_GROUP1 SN_TAB_SPECIAL
1 15 6434 STORE_CH_ARMOR_TAB7 STORE_CH_ARMOR_GROUP1 SN_TAB_SPECIAL
1 15 6435 STORE_CH_ARMOR_TAB8 STORE_CH_ARMOR_GROUP2 SN_TAB_SPECIAL
and past in new text file and rename it to "refshoptab.txt"
and replace this file with "refshoptab.txt" in media.pk2
to make sure that data is equal in the database and in the text files.
DB is bugged, any spawn for grab pet instant DC :(
hey u f10 open and prees e shut down game?Quote:
Originally Posted by elitebi
i will say that again,but for the last time.Quote:
Originally Posted by elitebi
This DB is not bugged,this is very good DB.
Because Refnest table has very large amount of mobs that spawn in all areas and jupiter zone in this DB has many champion and giant mobs.
<SO>
you have two solutions
1- Run this DB on two game server will fix all problems.
(OR)
2- Use this Query to reduce mobs numbers in Refnest
and disable some areas in _RefRegionBindAssocServerCode: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 will be fine
Thanks
I just get the DC when I'm in town, spawn pet, DC from serverQuote:
Originally Posted by arabianfox
well,
I thank you to Statiic for this great work but gotta ask about 13dg lucky powders,i would appreciate if somebody can tell me any way to add them.
Thanks
For PPL Got DC When Try to buy item mall or Spawn grab petQuote:
Originally Posted by elitebi
Try This way maybe it fix ur problem :) Just +Like if it help to know ur problem solved.
1- Make ur database account Like this
http://desmond.imageshack.us/Himg860...jpg&res=medium
2- Be Sure your DBConnect.asp Catalog=SRO_VT_ACCOUNT Same in database
http://desmond.imageshack.us/Himg813...jpg&res=medium
3-Be Sure u do it again with all DSN
http://desmond.imageshack.us/Himg10/...jpg&res=medium
I hope it help ppl :ehh:
Which tables i need to use from statiic db if i want to uinclued the d12 jupiter#mobs#skills any anything related to it for my exist db with players?
objcommon
refhive
refskills
reftatcis
gameworld_config
what more?
When I use other DB, I don't get the pet DC, so something wrong in this DB, I didn't play or edit anything just like it is posted but other DB doesn't have d13 items so I prefer to use statiic DB
Just copy querys right clic new query and execute it.Quote:
Originally Posted by elitebi
hello all i have small problem can anyone hellp me plz ?
i got DC every 5 or 10 min i think the problem in the event or when any uniqe appare coz i cant see any uniqe appere or event start btw i am useing the normal database with 1 gameserver only and i need to know how can i make my hp and mp slots take more than 50 unit only i need to make it 250 and arrow 1000 thx for your help and for your time trying to help pep