Need to reduce nomper of mobs spawn...

[joocker]

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

[eminemsjunge]

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.

[IceAmStiel]

Originally Posted by eminemsjunge

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

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

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)

[Eroticus]

Originally Posted by IceAmStiel

Eminem, as an example

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

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 ?

[IceAmStiel]

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.

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.

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

[joocker]

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 (

[Eroticus]

Have fun



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

[joocker]

thanks i'll try it

nice song btw

Thanks+Thanks+Thanks All

except Eroticus , Unlimited Thank

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

[teamcoole]

[QUOTE=Eroticus;18092842]

Have fun

Can you help me with this error please


i cant find my server on server list