Find Mob id + Name + Location

07/30/2016 07:11 intrepidklasse#1
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 ?
07/30/2016 11:50 blapanda#2
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)

[Only registered and activated users can see links. Click Here To Register...]
07/30/2016 11:53 DeviasOnline#3
...

Quote:
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
[Only registered and activated users can see links. Click Here To Register...]
07/30/2016 17:26 blapanda#4
Quote:
Originally Posted by milan1 View Post
...
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.
07/31/2016 00:03 DeviasOnline#5
Quote:
Originally Posted by blapanda View Post
right?
I just find this query in my own collection and release it nothing more.
Quote:
Originally Posted by blapanda View Post
On the other hand, your query won't work properly with mob nests having more than 1 nest.
right.
07/31/2016 22:35 Spidy.#6
Quote:
Originally Posted by blapanda View Post
#Closed