New Website Progress

[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.

[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.

[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

[iSylver]

Indeed suggestions can sometimes be off but that adds fun to it .

[Corrupt]

The suggestions were truly horrendous as far as INT mobs go.

[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


[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).

[akemi]

Nice work Dan, how come it isn't including the STR, INT and DEX armours?

[iSylver]

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 -.-

[roachee]

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