IF @monsterfilter = 'int'
BEGIN
Select Distinct top 10 Monster.sSid,sPid as sPicNum, ABS((sStr + sIntel) - @characterInt) as OrderCalc, strname, ((sstr*2) + SAStr+ SWStr) /2 As Strength, (sStr + sIntel) as Intelligence from MONSTER
inner join MONSTERSET on Monster.sSid = stablenum
Where sNum > '1' and sregentype='0' and
( (sStr + sIntel)) BETWEEN (@characterInt - 10) AND (@characterInt + 50) and tType = '1'
and (sZone = '1'or sZone = '2' or sZone = '3' or sZone = '4' or sZone = '5' or sZone = '6'
or sZone = '7' or sZone = '12' or (sZone = '14' and Monsterset.sSid < 20000) or (sZone = '17' and Monsterset.sSid < 20000) or sZone = '22' ) and strName <> '' and sMagicNum01 <> '0' and sMagicNum01 <> '-1' and sDistance >= '1' and can_escape = '0'
order by OrderCalc asc
END
akemi wrote:Nice work Dan, how come it isn't including the STR, INT and DEX armours?
akemi wrote:Nice work Dan, how come it isn't including the STR, INT and DEX armours?
Users browsing this forum: No registered users and 1 guest