Increase Mobs Problem!

04/01/2019 03:18 devdash#1
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 [Only registered and activated users can see links. Click Here To Register...]
04/01/2019 03:31 bimbum*#2
Quote:
Originally Posted by alydandy View Post
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

[Only registered and activated users can see links. Click Here To Register...]

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
04/01/2019 04:32 devdash#3
Quote:
Originally Posted by bimbum* View Post
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.