Increase Mobs Problem!

[devdash]

hi elitepvpers, i hope you all having a great day

PHP Code:

DECLARE raRe FLOAT = 0.75 /*_#2 = 200%, 1 = 100%, 0.5 = 50%*/

UPDATE TRN 
    SET TRN.dwMaxTotalCount *= raRe
    FROM Tab_RefNest TRN
    JOIN Tab_RefTactics TRT ON TRN.dwTacticsID = TRT.dwTacticsID
    JOIN _RefObjCommon ROC ON TRT.dwObjID = ROC.ID
WHERE ROC.CodeName128 LIKE 'MOB%'
AND ROC.Rarity = 0
AND dwDelayTimeMin < 600
AND dwDelayTimeMin != 0
AND dwMaxTotalCount != 1 


i want to rebuild this query to change only dwmaxtotalcount

and i hope if the builder can make an option that make make me do triple or double instead of a number, wish means lets say there's a mob have 10 count, i can change it to 50, by typing 50 on the query, but what if i type 1 = same, 2 = double, 3 = triple , and so on, for a better result, because the same mob lines not necessary to have the same dwtotalcount value,


thanks in advance.


Copyright goes to

[bimbum*]

Originally Posted by alydandy

Hi elitepvpers, i hope everyone having a great day

my question is how can i increase the mob count, wish means 30 mobs in the spot instead of 10, that's just an example

i know that you will probably recommend me this link



but i see alot of negative posts there, one of em my friend actually and i trust him, so what should i do ?

iam begginer, iam afraid of destorying my database,

i will accept all the answers,

thanks in advance.

take backup of ur database and do whatever u want

[devdash]

Originally Posted by bimbum*

take backup of ur database and do whatever u want

seriously bruh ?

iam asking how can i increase the mobs count for a spcific mob


lets say i want to change the Ong mob count from "example" 500 to 15000 mobs in Samarkand

i can go to RefNest and change the DwTotalCount
but i can't do that for each line, i need a query


so i went to the link i shared early, and i saw the postats almost of em was negative, so i need a query that can help me to change all the lines for a spcific mob.