Find Mob id + Name + Location

[intrepidklasse]

have a question, HOW can i find a mob? i want reduce spawnrate on any mobs and need add more rate at other mobs, so its the plan. BUT i cannot found Mobs...

Tab_RefNest has only ids and coordinates, but i want to know whats mob are there.. any can help ?

[blapanda]

Just a quick image of the logical process finding your mob/unique or whatever, and then starting to fetch the information from the tables to the next crucial ones.
Writing the query is up to you.

(And searching by mob coordinate(s) is more a chore than just simply starting your search process with the mob name as first criteria)

[DeviasOnline]

...

use SRO_VT_SHARD
declare @MOB varchar(64)
declare @NESTID varchar(64)
declare @HiveID varchar(64)
declare @TacticsID varchar(64)
set @MOB = 'MOB_TK_BONELORD' -- mob name
set @NESTID = (SELECT dwNestID from Tab_RefNest where dwTacticsID = @TacticsID )
select @HiveID = dwHiveID from Tab_RefNest where dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = (SELECT ID FROM _RefObjCommon WHERE Codename128 like @MOB))
select @TacticsID = dwTacticsID from Tab_RefNest where dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = (SELECT ID FROM _RefObjCommon WHERE Codename128 like @MOB))

select * from Tab_RefHive where dwHiveID = @HiveID
select * from Tab_RefTactics where dwTacticsID = @TacticsID
select * from Tab_RefNest where dwTacticsID = @TacticsID

[blapanda]

Originally Posted by milan1

...

You are actually someone who doesn't leave others learning and doing anything on their own, right?
On the other hand, your query won't work properly with mob nests having more than 1 nest.

[DeviasOnline]

Originally Posted by blapanda

right?

I just find this query in my own collection and release it nothing more.

Originally Posted by blapanda

On the other hand, your query won't work properly with mob nests having more than 1 nest.

right.

[Spidy.]

Originally Posted by blapanda

 Spoiler

Just a quick image of the logical process finding your mob/unique or whatever, and then starting to fetch the information from the tables to the next crucial ones.
Writing the query is up to you.

(And searching by mob coordinate(s) is more a chore than just simply starting your search process with the mob name as first criteria)

#Closed