25
you didn't understand me..look at this
<?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();
?>
put this code in an external php file located in your XOOPS root directory..and call this file after login..you will see your user name
