[DrkFusion]

Originally posted by Xenon
@Arunan: Thank would create an extra query for each post!!
It would work you are right, but one more query per post is not good

@Don:
open showthread.php find:

PHP Code:

    FROM post
    ".iif($forum[allowicons],'LEFT JOIN icon ON icon.iconid=post.iconid','')."
    LEFT JOIN user ON user.userid=post.userid
    LEFT JOIN userfield ON userfield.userid=user.userid 


DIRECTLY after that lines put this line:

PHP Code:

   LEFT JOIN stats_individual ON (stats_individual.name=userfield.field5) 


then few lines above there is this part:

PHP Code:

post.*,post.username AS postusername, 


change ti to:

PHP Code:

post.*,stats_individual.rank,post.username AS postusername, 


then you can use $post[rank] in your postbit template

ur rite...lost my mind, because I didn't tell him where to put it either lol.

That above should work.