http://www.bozkirinsesi.com
look at the center block..we call it HaberTV in Turkey
<?php
include("mainfile.php");
$yol = XOOPS_DB_HOST;
$kullanici_adi = XOOPS_DB_USER;
$kullanici_sifre = XOOPS_DB_PASS;
$veritabani_adi = XOOPS_DB_NAME;
$veritabani_oneki = XOOPS_DB_PREFIX;
$veri_yolu = mysql_connect($yol, $kullanici_adi, $kullanici_sifre);
if ( ! $veri_yolu ) die ("An error occured!");
mysql_select_db($veritabani_adi , $veri_yolu) or die ("An error occured!" . mysql_error() );
$sonuc = mysql_query("SELECT * FROM ".$veritabani_oneki."_users WHERE uid=".$_SESSION['xoopsUserId']." ORDER BY uname ASC limit 1",$veri_yolu);
while($satir = mysql_fetch_array($sonuc)) {
echo $satir['uname'];
}
mysql_close();
?>
SELECT * FROM xoops_users WHERE uid=".$_SESSION['xoopsUserId']." ORDER BY uname ASC limit 1
echo "Welcome, ".$xoopsUser->getVar('uname');