newbie question!! please answer

02/02/2018 01:55 devdash#1
i have disabled tp to alexandria and i have removed revers marks to there, is that will make the server faster ? or mobs and maps stil loading and i just disabled using it ? and if so , so how can i completly remove that "ALEXANDRIA MAP & MOBS AND EVERYTHING OF IT"
THanks in advanced.
02/02/2018 02:41 ZαKuRα#2
[Only registered and activated users can see links. Click Here To Register...]
02/02/2018 11:10 janicka#3
If you set world service 0, server wont loading it.
02/02/2018 13:52 devdash#4
Quote:
Originally Posted by ZαKuRα View Post
[Only registered and activated users can see links. Click Here To Register...]
sorry i may asked my question with a wrong way i wanted to say , if i disabled all alexandria map and mobs aswell and npcs aswell, how can i increase the other maps's mobs, because i have realy low mobs in all areas except Alexandria has like 9999 billions ,so after i disabled it can i add more mobs to all areas, like ong,penon,mejaju, etc...

Quote:
Originally Posted by janicka View Post
If you set world service 0, server wont loading it.

sorry i may asked my question with a wrong way i wanted to say , if i disabled all alexandria map and mobs aswell and npcs aswell, how can i increase the other maps's mobs, because i have realy low mobs in all areas except Alexandria has like 9999 billions ,so after i disabled it can i add more mobs to all areas, like ong,penon,mejaju, etc...
02/02/2018 15:09 janicka#5
[Only registered and activated users can see links. Click Here To Register...]

Read pls forum rules. Try search before asking question. Its not that hard press search button.
02/02/2018 16:44 devdash#6
Quote:
Originally Posted by janicka View Post
[Only registered and activated users can see links. Click Here To Register...]

Read pls forum rules. Try search before asking question. Its not that hard press search button.
dont blame me for ur misunderstand please, as i said
i want to increase mobs not spawn rate, Read carefully next time please, and thanks for trying to help me anyway.
02/02/2018 17:19 ZαKuRα#7
[Only registered and activated users can see links. Click Here To Register...]
02/02/2018 19:15 devdash#8
Quote:
Originally Posted by ZαKuRα View Post
[Only registered and activated users can see links. Click Here To Register...]
i want to increase mobs amount not spawn rate :(, wish means lets say in penon area there's 1000 mobs i want to make it 3000 ,i hope u understand me , because my server is empty :( while there was alot of mobs in Alexandria before i disabled it , so why dont i enjoy that in other areas
02/03/2018 02:42 Snow*#9
So basically this should update the mobs max total count spawn by 3 based on the region you provide. Didn't really test this but it should work, based on how the tables work.
Code:
Update Tab_RefNest set dwMaxTotalCount = dwMaxTotalCount*3 
where nRegionDBID in (select wRegionID from _RefRegion where ContinentName = 'Oasis_Kingdom') and dwMaxTotalCount > 3
Oasis_Kingdom = Oasis_Kingdom is Hotan (ALL OF IT)

set dwMaxTotalCount = dwMaxTotalCount*3
dwMaxTotalCount = the current spawn rate
*3 = the number it's multiplied by

Just an advice, it's pretty useless to change the monsters spawn rate in the low level areas, because once the players level up they will be useless.
02/03/2018 04:22 devdash#10
Quote:
Originally Posted by Snow* View Post
So basically this should update the mobs max total count spawn by 3 based on the region you provide. Didn't really test this but it should work, based on how the tables work.
Code:
Update Tab_RefNest set dwMaxTotalCount = dwMaxTotalCount*3 
where nRegionDBID in (select wRegionID from _RefRegion where ContinentName = 'Oasis_Kingdom') and dwMaxTotalCount > 3
Oasis_Kingdom = Oasis_Kingdom is Hotan (ALL OF IT)

set dwMaxTotalCount = dwMaxTotalCount*3
dwMaxTotalCount = the current spawn rate
*3 = the number it's multiplied by

Just an advice, it's pretty useless to change the monsters spawn rate in the low level areas, because once the players level up they will be useless.
please answer this, i dont want to increase the mobs spawn rate, i want to increase the mobs amount, wish means lets say in a area there's a 1000 mobs i want to make it 5000, and its not usless in my case becase my server is pve and its realy hard to level up..
thanks in advanced
02/03/2018 04:51 Snow*#11
dwMaxTotalCount refers to how many mobs spawn and not how fast they spawn. So spawn ratio is increasing the mobs amount, hence what me and the other have been telling you is correct.
02/03/2018 05:30 devdash#12
Quote:
Originally Posted by Snow* View Post
dwMaxTotalCount refers to how many mobs spawn and not how fast they spawn. So spawn ratio is increasing the mobs amount, hence what me and the other have been telling you is correct.
oh fianly some one answered that question, thank you very much, so iam on Tab_RefNest on dwMaxTotalCount, should i increase all the numbers on that table or what should i do exactly ? i mean i want to increase mobs on this towns Jangan-downhang-hotan-samrkand-constintnpol & caveJangan & caveDownhang aswell, like all of it triple or something what should i do exactly ?
please tell me this ...because i dont want to fck up my database..
02/03/2018 06:03 Snow*#13
You can't update all the rows, otherwise you'd double spawn the NPC's in town and even the uniques.
let me give you
Code:
Update Tab_RefNest set dwMaxTotalCount = dwMaxTotalCount*3 
where nRegionDBID in (select wRegionID from _RefRegion where ContinentName = 'Oasis_Kingdom') and dwMaxTotalCount > 3
So basically this should update the mobs max total count spawn by 3 based on the region you provide. Didn't really test this but it should work, based on how the tables work.


Oasis_Kingdom = Oasis_Kingdom is Hotan (ALL OF IT)
You can get the region name from _RefRegionBindAssocServer

set dwMaxTotalCount = dwMaxTotalCount*3
dwMaxTotalCount = the current spawn rate
*3 = the number it's multiplied by

The update query shouldn't update the lines which have spawn count less than 3, so it should skip the npc's and uniques

Just an advice, it's pretty useless to change the monsters spawn rate in the low level areas, because once the players level up they will be useless.
02/03/2018 21:01 devdash#14
Quote:
Originally Posted by Snow* View Post
You can't update all the rows, otherwise you'd double spawn the NPC's in town and even the uniques.
let me give you
Code:
Update Tab_RefNest set dwMaxTotalCount = dwMaxTotalCount*3 
where nRegionDBID in (select wRegionID from _RefRegion where ContinentName = 'Oasis_Kingdom') and dwMaxTotalCount > 3
So basically this should update the mobs max total count spawn by 3 based on the region you provide. Didn't really test this but it should work, based on how the tables work.


Oasis_Kingdom = Oasis_Kingdom is Hotan (ALL OF IT)
You can get the region name from _RefRegionBindAssocServer

set dwMaxTotalCount = dwMaxTotalCount*3
dwMaxTotalCount = the current spawn rate
*3 = the number it's multiplied by

The update query shouldn't update the lines which have spawn count less than 3, so it should skip the npc's and uniques

Just an advice, it's pretty useless to change the monsters spawn rate in the low level areas, because once the players level up they will be useless.
i just did that update query for all the towns, and it has executed successfully , but i see the mobs not that much still, in Mujigi area the mobs that lv49 i have like 10 mobs of it there, its realy low amount of mobs , i want more i want to have like 1000 in that area not just 10, because the exp is already so hard...
can i user ur update query and change the "3" number to higher so i can get more mobs ? or that will do problems or what should i do ..
sorry but iam learning..