mob % reduciton[SOLVED]

[Loki]

Hello, could somebody correct my query please?

I am trying to reduce the mob level in a given region by 60% using the following :-

Code: Select all

UPDATE `mob` SET Level = round(x*.4,0) WHERE 'Region' = 'said region';

Thank you

[Loki]

UPDATE mob SET `Level` = round(`Level` * .4,0) WHERE Region = 'said region';

[LugusSkye]

This will update whole region the way you wanted. However, keep in mind, region could be just one zone such as 'Coruscating Mine' or a battleground but region can also encompass multiple zones example: region 1 in Albion is 'Camelot Hills', 'Salisbury Plains' and so on. If you want query to update a specific zone instead of whole region - it will cost you at least an introduction to your server

Here is the query for whole region update:

UPDATE mob m, zones z
SET m.Level = round(m.Level * .4,0)
WHERE m.region = z.regionid
and z.name = 'Braemar';

Good luck!

[Leodagan]

Lugus

You can't select mob by zone with this simple query...

you're just linking mob table to zone table using a common regionid, as long as the zone exists all mob in the region will still be updated with your query

You need at least some X, Y boundaries compared to mob position to achieve a zone update, this can be done using a "VIEW" for example...

[LugusSkye]

yep, that's why i said that it will only work for unique region to zone combinations.
for regions with multiple zones here is the query:

select distinct m.Name
, m.Level
, z.Name
from mob m
inner join zones z
on m.x - (8192 * z.offsetx) between 0 and 66000
and m.y - (8192 * z.offsety) between 0 and 66000
where z.name = 'Odin''s Gate';

Lugus

You can't select mob by zone with this simple query...

you're just linking mob table to zone table using a common regionid, as long as the zone exists all mob in the region will still be updated with your query

You need at least some X, Y boundaries compared to mob position to achieve a zone update, this can be done using a "VIEW" for example...

[Leodagan]

I must have read your previous post too quickly

But this other query looks pretty fine and elegant for a real "Zone Update"

Just one thing : you're not filtering on region id this time... All mobs in the table that match the given zone's coords would be updated

I didn't run any test but something like this should fix it ?

Code: Select all

// in the "ON" Clause AND M.RegionId = Z.RegionId

The thing is DOL use a 4D coords system, zones are virtual area that can be duplicated, you need a vector [X, Y, Z, Region] to pinpoint an area that can be handled by World Manager.