Put your site @http://www.xoops-topsites.com
include XOOPS_ROOT_PATH."/mainfile.php";
$story['categorytitle'] = $thisstory->textlink();
$story['topictitle'] = "<a href='".XOOPS_URL."/modules/news/article.php?storyid=".$sarray[$i]->storyid()."'>".$sarray[$i]->title()."</a>";
include("mainfile.php");
global $xoopsDB, $xoopsUser;
$query = $xoopsDB->query("SELECT flashbanner FROM dnet_user_profile WHERE profileid = "".$xoopsUser->uid().""");
while($row = $xoopsDB->fetchRow($query)){
echo $row['flashbanner'];
// to fetch result
}