Location: PHPKode > scripts > OekakiPoteto > oekakipoteto/profile.php
<html>
<?
function rootpath(){
	global $DOCUMENT_ROOT;
	$rootdir = $DOCUMENT_ROOT;
	if ($DOCUMENT_ROOT[strlen($DOCUMENT_ROOT)] == "/"){
		return $rootdir;
	} else {
		$rootdir = $rootdir."/";
		return $rootdir;
	}
}
include('dbconn.php');
include('config.php');
	$testrslt = mysql_query("SELECT usrname, usrpass, templatesel, usrflags, language FROM ".$OekakiPoteto_MemberPrefix."oekaki WHERE usrname='$OekakiU'");
	
	//extract the fields selected above into variables
	$row = mysql_fetch_array($testrslt);

if($OekakiU == ""){
	include("language/".$language.".php");
	include("templates/".$template.".php");
	} else {
	include("templates/".$row[templatesel].".php");
	include("language/".$row[language].".php");
	$theflags = $row[usrflags];
}
$result2 = mysql_query("SELECT * FROM ".$OekakiPoteto_Prefix."oekakidta where usrname='$user' order by postdate desc");
$rownum = mysql_numrows($result2);
$i = 0;
$result = mysql_query("SELECT * FROM ".$OekakiPoteto_MemberPrefix."oekaki where usrname='$user'");
$row = mysql_fetch_array($result);

?>
<head>
<title><?=$BBStitle?> - OekakiPoteto</title>
<meta http-equiv="Content-Type" content="text/html; charset=<?=$charset?>">
</head>
<body bgcolor="<?=$bgColor?>" text="<?=$textColor?>" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" background="templates/<?=$bgImage?>" link="<?=$link?>" vlink="<?=$vLink?>" alink="<?=$aLink?>">
<table width="100%" cellpadding="<?=$hCellPadding?>" align="center" cellspacing="0" class="infotable">
  <tr> 
    <td>
      <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
        <tr> 
          <td> 
            <table width="100%" border="0" cellspacing="1" cellpadding="3" align="center" class="infotable">
              <tr> 
                <td colspan="2" class="header"><font size="-2">
                  <?=$langop_profile_title?>
                  <?=$user?>
                  (<a href="mailsend.php?sendto=<?=urlencode($user)?>" target="_blank">
                  <?=$langop_profile_sndmsg?>
                  </a>)</font> </td>
              </tr>
              <?if (($OekakiU != "") && (strstr($theflags,'O') || strstr($theflags,'S') || strstr($theflags,'A'))) { ?>
              <tr> 
                <td> <div align="right"><font size="-2"><strong>
                    <?=$langop_word_admin?>:</strong></font></div></td>
                <td><font size="-2">[<a href="modflags.php?usrname2=<?=urlencode($row[usrname])?>&muser=Submit" target="_blank">
                  <?=$langop_common_mflags?>
                  </a>] 
                  <? if (strstr($theflags,'O') || strstr($theflags,'S')) { ?>
                  [<a href="delusr.php?usrname2=<?=urlencode($row[ID])?>&pmember=Submit" target="_blank">
                  <?=$langop_common_delusr?>
                  </a>] 
                  <? } ?>
                  </font></td>
              </tr>
              <? } ?>
              <tr> 
                <td width="11%"> <div align="right"><b><font size="-2">
                    <?=$langop_word_name?>:</font></b></div></td>
                <td width="89%"><font size="-2"> 
                  <?=$row[name]?>
                  </font></td>
              </tr>
              <tr> 
                <td width="11%"> <div align="right"><b><font size="-2">
                    <?=$langop_word_email?>:</font></b></div></td>
                <td width="89%"><font size="-2"> <a href="mailto:<?=$row[email]?>"> 
                  <?=$row[email]?>
                  </a> </font></td>
              </tr>
              <tr> 
                <td><div align="right"><font size="-2"><strong>
                    <?=$langop_word_age?>:</strong></font></div></td>
                <td><font size="-2"> 
                  <?=$row[age]?>
                  </font></td>
              </tr>
              <tr> 
                <td><div align="right"><font size="-2"><strong>
                    <?=$langop_word_gender?>:</strong></font></div></td>
                <td><font size="-2">
                  <?=$row[gender]?>
                  </font></td>
              </tr>
              <tr> 
                <td><div align="right"><font size="-2"><b>
                    <?=$langop_word_location?>:</b></font></div></td>
                <td><font size="-2"> 
                  <?=$row[location]?>
                  </font></td>
              </tr>
              <tr> 
                <td width="11%"> <div align="right"><font size="-2"><b>
                    <?=$langop_word_joined?>:</b></font></div></td>
                <td width="89%"><font size="-2"> 
                  <?=$row[joindate]?>
                  </font></td>
              </tr>
              <tr> 
                <td><div align="right"><font size="-2"><b>
                    <?=$langop_common_lastlogin?>:</b></font></div></td>
                <td><font size="-2"> 
                  <?=$row[lastlogin]?>
                  </font></td>
              </tr>
              <tr> 
                <td><div align="right"><font size="-2"><b>
                    <?=$langop_common_picposts?>:</b></font></div></td>
                <td><font size="-2"> 
                  <?=$row[piccount]?>
                  </font></td>
              </tr>
              <tr> 
                <td><div align="right"><font size="-2"><b>
                    <?=$langop_common_compost?>:</b></font></div></td>
                <td><font size="-2"> 
                  <?=$row[commcount]?>
                  </font></td>
              </tr>
              <tr> 
                <td width="11%"> <div align="right"><b><font size="-2">
                    <?=$langop_word_url?>:</font></b></div></td>
                <td width="89%"><font size="-2"><a href="<?=$row[url]?>" target="New_window"> 
                  <?=$row[urltitle]?>
                  </a></font></td>
              </tr>
              <tr> 
                <td width="11%" height="26"> <div align="right"><b><font size="-2">
                    <?=$langop_word_aolinstantmessenger?>:</font></b></div></td>
                <td width="89%" height="26"><font size="-2"><a href="aim:AddBuddy?ScreenName=<?=$row[aim]?>&groupname=OekakiPoteto"> 
                  <?=$row[aim]?>
                  </a> </font></td>
              </tr>
              <tr> 
                <td width="11%"> <div align="right"><b><font size="-2">
                    <?=$langop_word_icq?>:</font></b></div></td>
                <td width="89%"><font size="-2"> 
                  <?=$row[icq]?>
                  </font></td>
              </tr>
              <tr> 
                <td><div align="right"><b><font size="-2">
                    <?=$langop_word_microsoftmessenger?>:</font></b></div></td>
                <td><font size="-2"> 
                  <?=$row[MSN]?>
                  </font></td>
              </tr>
              <tr> 
                <td><div align="right"><b><font size="-2">
                    <?=$langop_word_yahoomessenger?>:</font></b></div></td>
                <td><font size="-2"> 
                  <?=$row[Yahoo]?>
                  </font></td>
              </tr>
              <tr> 
                <td><div align="right"><b><font size="-2">
                    <?=$langop_word_template?>:</font></b></div></td>
                <td><font size="-2"> 
                  <?=$row[templatesel]?>
                  </font></td>
              </tr>
              <tr> 
                <td width="11%"> <div align="right"><b><font size="-2">
                    <?=$langop_word_comments?>:</font></b></div></td>
                <td width="89%"><font size="-2"> 
                  <?=nl2br($row[comment])?>
                  </font></td>
              </tr>
              <tr>
                <td><div align="right"> <strong> 
                    <?=$langop_word_language?></strong>:</div></td>
                <td><font size="-2">
                  <?=$row[language]?>
                  </font></td>
              </tr>
              <tr> 
                <td><div align="right"><b><font size="-2">
                    <?=$langop_word_special?>:</font> </b></div></td>
                <td><font size="-2"> 
                  <?
if (strstr($row[usrflags],"O")) {
	echo $langop_word_owner.'<br>';
	}
if (strstr($row[usrflags],"S")) {
	echo $langop_type_sadmin.'<br>';
	}
if (strstr($row[usrflags],"A")) {
	echo $langop_type_admin.'<br>';
	}
if (strstr($row[usrflags],"D")) {
	echo $langop_type_daccess.'<br>';
	}
if (strstr($row[usrflags],"M")) {
	echo $langop_type_aaccess.'<br>';
	}
if (strstr($row[usrflags],"I")) {
	echo $langop_type_immunity.'<br>';
	}	

if (strstr($row[usrflags],"X")) {
	echo $langop_type_adultview.'<br>';
	}
if (strstr($row[usrflags],"C")) {
	echo "Coolness<br>";
	}
if (strstr($row[usrflags],"F")) {
	echo "Free Trip<br>";
	}
if (strstr($row[usrflags],"B")) {
	echo "Likes anal sex<br>";
	}
if (strstr($row[usrflags],"H")) {
	echo "Pornstar<br>";
	}
if (strstr($row[usrflags],"R")) {
	echo "Robot slave master<br>";
	}
if (strstr($row[usrflags],"G")) {
	echo $langop_type_guser;
	}
?>
                  </font></td>
              </tr>
              <tr> 
                <td colspan="2">&nbsp;</td>
              </tr>
              <tr> 
                <td colspan="2" class="header"><font size="-2">
                  <?=$langop_eprofile_irctitle?>
                  </font></td>
              </tr>
              <tr> 
                <td><div align="right"><b><font size="-2">
                    <?=$langop_word_ircserver?>: </font></b></div></td>
                <td><font size="-2"> 
                  <?=$row[IRCServer]?>
                  </font></td>
              </tr>
              <tr> 
                <td><div align="right"><b><font size="-2">
                    <?=$langop_word_ircnickname?></font><font size="-2">:</font></b></div></td>
                <td><font size="-2"> 
                  <?=$row[IRCNick]?>
                  </font></td>
              </tr>
              <tr> 
                <td width="11%"> <div align="right"><b><font size="-2">
                    <?=$langop_word_ircchannel?>:</font></b></div></td>
                <td width="89%"><font size="-2"> 
                  <?=$row[IRCchan]?>
                  </font></td>
              </tr>
            </table>
            <br>
            <table width="100%" border="0" cellspacing="1" cellpadding="3">
              <tr> 
                <td colspan="2" class="header"><font size="-2"><?=$langop_profile_latest?> (<?=$BBStitle?>)</font></td>
              </tr>
              <? 
WHILE ($i < $rownum):
?>
              <tr> 
                <td width="18%"> <div align="center"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif"> 
                    <a href="<?=$OPpics?>/<?=mysql_result($result2,$i,"PIC_ID");?>.png" target="okpics"><?=mysql_result($result2,$i,"postdate");?></a>
                    </font></div></td>
                <td width="31%"> <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><a href="<?=$OPpics?>/<?=mysql_result($result2,$i,"PIC_ID");?>.png" target="okpics"><?=mysql_result($result2,$i,"title");?></a></font></div></td>
              </tr>
              <?
$i++; 
endwhile; 
mysql_close($dbconn);

?>
            </table>
          </td>

        </tr>
      </table>
    </td>
  </tr>
</table>

<p align="center"><a onclick="javascript: window.close();" href="#"><font size="-2" face="<?=$fontFace?>"><?=$langop_common_window?></font></a></p>
</body>
Return current item: OekakiPoteto