Page 16 of 17

Re: New Website Progress

PostPosted: Mon Jun 27, 2011 9:46 am
by akemi
Yeah maybe like Sylver is saying, where you can click a recommended for you button which displays 5 different mobs suited to you. Doesn't have to say where they are but some kind of hint would be nice.

Re: New Website Progress

PostPosted: Mon Jun 27, 2011 10:15 am
by iSylver
Like this?

http://www.myth-of-soma.com/Armory/Recommended.asp

might be a bit hit n miss but basically calculates the mobs with the most similar stats to you and then offers more difficult ones as it progresses down :).

Does it by the character pinned so give it a shot.

Re: New Website Progress

PostPosted: Mon Jun 27, 2011 10:34 am
by roachee
thats good at least people will kinda know what to hunt it might be useful for the old players aswell like me lol im only lvl 7 and i diddnt even no there was more then acouple of mobs to hunt

Re: New Website Progress

PostPosted: Mon Jun 27, 2011 11:54 am
by iSylver
Indeed suggestions can sometimes be off but that adds fun to it :).


Re: New Website Progress

PostPosted: Mon Jun 27, 2011 12:54 pm
by Corrupt
The suggestions were truly horrendous as far as INT mobs go.

Re: New Website Progress

PostPosted: Mon Jun 27, 2011 1:01 pm
by iSylver
The esoma db is terrible for not clearly defining what an "int" mob is. I.e. cant do it on range due to gazer having 1 range spell. Managed to lock out alot of mobs i.e ones that dont have spells and also ones that have arrows.

Code: Select all
 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

Re: New Website Progress

PostPosted: Tue Jun 28, 2011 9:12 am
by iSylver
Added recommended items now.

http://www.myth-of-soma.com/Armory/Reco ... .asp?f=dex

Essentially will predict dependant on your stats and for dsoma it predicts with class also.

Shields are mentioned as an intelligence item (the ones with MD on them).

Re: New Website Progress

PostPosted: Tue Jun 28, 2011 10:04 am
by akemi
Nice work Dan, how come it isn't including the STR, INT and DEX armours?

Re: New Website Progress

PostPosted: Tue Jun 28, 2011 10:38 am
by iSylver
akemi wrote:Nice work Dan, how come it isn't including the STR, INT and DEX armours?


Should do but it only searches in a -10/+30 str boundary. So if it cant find any it wont suggest it.

Edit:

Fixed Theres 2 sSpecials each for MA and MD -.-

Re: New Website Progress

PostPosted: Tue Jun 28, 2011 10:41 am
by roachee
akemi wrote:Nice work Dan, how come it isn't including the STR, INT and DEX armours?



obv if you are higher then the 108 str set and what ever highest dex and int sets are its not gonna find any as afaik there aint been no new added armours