Need to reduce nomper of mobs spawn...

08/07/2012 04:00 joocker#1

:confused: I Need to reduce nomper of mobs spawn... in order to open new maps any help please??? :o

08/07/2012 10:02 eminemsjunge#2

Code:

USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/1.25

Press Thanks if i helped ;)

Change SRO_VT_SHARD if you have another name and run this query .
Press Thanks if i helped.

08/07/2012 10:23 IceAmStiel#3

Quote:
Originally Posted by eminemsjunge
Code:
USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/1.25
Press Thanks if i helped ;)

Change SRO_VT_SHARD if you have another name and run this query .
Press Thanks if i helped.

Eminem, as an example

Code:

SELECT CONVERT(INT,1/1.25)

You would set all spawns with a current amount of 1 to 0 (most likely all uniques)

You're better off using something like..

Code:

Declare @Rate float = 2.0;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = CASE WHEN CONVERT(INT,ROUND(dwmaxtotalcount/@Rate,0)) = 0 THEN 1 ELSE CONVERT(INT,ROUND(dwmaxtotalcount/@Rate,0)) END

(constructive criticism)

08/07/2012 11:04 Eroticus#4

Quote:
Originally Posted by IceAmStiel
Eminem, as an example
Code:
SELECT CONVERT(INT,1/1.25)
You would set all spawns with a current amount of 1 to 0 (most likely all uniques)

You're better off using something like..
Code:
Declare @Rate float = 2.0;
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = CASE WHEN CONVERT(INT,ROUND(dwmaxtotalcount/@Rate,0)) = 0 THEN 1 ELSE CONVERT(INT,ROUND(dwmaxtotalcount/@Rate,0)) END
(constructive criticism)

How to make spawn of uniq only :P ?

08/07/2012 11:23 IceAmStiel#5

Quote:

Originally Posted by Eroticus

How to make spawn of uniq only :P ?

I recommend you to prepare at first a proper SELECT statement to cover all monster you'd like to change up.

e.g.

Code:

SELECT ref.ID,ref.CodeName128, tabrn.*
FROM Tab_RefNest as tabrn
JOIN Tab_RefTactics as tabrt on tabrn.dwTacticsID = tabrt.dwTacticsID
JOIN _RefObjCommon as ref on tabrt.dwObjID = ref.ID
WHERE
TypeID1 = 1 AND TypeID2 = 2 AND TypeID3 = 1 AND Rarity = 3 AND [Service] = 1

When you completed your desired resultset you may start with building the UPDATE statement, example follows.

Code:

Declare @Rate float = 1.0;
UPDATE dbo.Tab_RefNest
SET dwmaxtotalcount = CASE WHEN CONVERT(INT,ROUND(dwmaxtotalcount*@Rate,0)) = 0 THEN 1 ELSE CONVERT(INT,ROUND(dwmaxtotalcount*@Rate,0)) END
FROM Tab_RefNest as tabrn
JOIN Tab_RefTactics as tabrt on tabrn.dwTacticsID = tabrt.dwTacticsID
JOIN _RefObjCommon as ref on tabrt.dwObjID = ref.ID
WHERE
TypeID1 = 1 AND TypeID2 = 2 AND TypeID3 = 1 AND Rarity = 3 AND [Service] = 1

-> all unique spawns (Rarity 3 = usually unique) * @Rate

08/07/2012 19:49 joocker#6

can any one please tell me how to add Query with some pics , cus it always need to save a DB but didn't work :S

[i have mssql 2005]

or just tell me under what table cuz i need also to make last plus items more than +8 :( but in DB when i tried to make it more than +12 it told me to save the DB again but no changes :((

08/07/2012 19:58 Eroticus#7

Have fun :)

IceAmStiel :) How to make them all spawn in Jangan :) ? Thanks !!! :)

08/07/2012 20:45 joocker#8

thanks i'll try it :D

nice song btw :)

Thanks+Thanks+Thanks All :D

except Eroticus , Unlimited Thank :)

but i still go an eror C++ cuz i have opened 7 maps with Ram 4GB :(

08/07/2012 23:50 teamcoole#9

[QUOTE=Eroticus;18092842]

Have fun :)

Can you help me with this error please :)
[Only registered and activated users can see links. Click Here To Register...]

i cant find my server on server list