newbie question!! please answer

devdash · 02/02/2018, 01:55

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.

ZαKuRα · 02/02/2018, 02:41

janicka · 02/02/2018, 11:10

If you set world service 0, server wont loading it.

devdash · 02/02/2018, 13:52

Quote:

Originally Posted by ZαKuRα

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

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...

janicka · 02/02/2018, 15:09

Read pls forum rules. Try search before asking question. Its not that hard press search button.

devdash · 02/02/2018, 16:44

Quote:

Originally Posted by janicka

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.

ZαKuRα · 02/02/2018, 17:19

devdash · 02/02/2018, 19:15

Quote:

Originally Posted by ZαKuRα

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

Snow* · 02/03/2018, 02:42

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.

devdash · 02/03/2018, 04:22

Quote:
Originally Posted by Snow*
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

Snow* · 02/03/2018, 04:51

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.

devdash · 02/03/2018, 05:30

Quote:

Originally Posted by Snow*

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..

Snow* · 02/03/2018, 06:03

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

Spoiler

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.

devdash · 02/03/2018, 21:01

Quote:
Originally Posted by Snow*
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

Spoiler

CHINA = Jangan
TQ = Qin-Shi Tomb (Jangan Cave)
West_China = Downhang
Oasis_Kingdom = Hotan
Thief Village = Thief town
Roc = Roc Mountain
Eu = Constantinople
Am = Asia Minor (Captain Ivy)
Ca = Central Asia (Samarkand)

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..