uname("E"); global $db, $xoopsTheme, $bcoosConfig, $xoopsModule; global $dateformat, $autoactive, $imagesize, $heightunit, $weightunit; if($autoactive==0){ $textdateformat = _ttmmjjjj; } else { $textdateformat = _jjjjmmtt; } if (!$xoopsUser) { include_once(XOOPS_ROOT_PATH."/header.php"); OpenTable(); echo "
"._TEXTNOXOOPSUSER.""._CLA_REGISTER."
"._CLA_OR." "._CLA_CONECT." "._CLA_IFAREMEMBER."
"; CloseTable(); include_once("../footer.php"); } else { OpenTable(); //************************************************************ if ($page == "update") { $sql = "UPDATE ".$db->prefix("friendfinder")." SET sex='$sex', active='$active', name='$name', partner='$partner', category='$category', country='$country', state='$state', city='$city', hobby='$hobby', Description='$Description', height='$height', weight='$weight', birth='$birth' WHERE user = '$username'"; $result = $db->query($sql); redirect_header("../index.php",2,_TEXTPROFILEUPDATED.""); } else { $sql = "SELECT * FROM ".$db->prefix("friendfinder")." inner join ".$db->prefix("friendfinder_state")." on state = cid inner join ".$db->prefix("friendfinder_sex")." on sex = sid inner join ".$db->prefix("friendfinder_category")." on category = catid WHERE user = '$username'"; $result = $db->query($sql); while ($i = $db->fetchArray($result)) { echo"
"._TEXTMEMBERCHANGEPIC."
"._TEXTSEX." "; list($numrows) = $db->fetchRow($db->query("select sid, sextitle from ".$db->prefix("friendfinder_sex")."")); if ($numrows>0) { $result = $db->query("select sid, sextitle from ".$db->prefix("friendfinder_sex")." order by sextitle"); echo "
"._TEXTREALNAME."
"._TEXTREGION." "; list($numrows) = $db->fetchRow($db->query("select cid, title from ".$db->prefix("friendfinder_state")."")); if ($numrows>0) { $result = $db->query("select cid, title from ".$db->prefix("friendfinder_state")." order by title"); echo "
"._TEXTCOUNTRY." "._SELECTCOUNTRY."
"._TEXTCITY."
"._TEXTPSEX." "; list($numrows) = $db->fetchRow($db->query("select sid, sextitle from ".$db->prefix("friendfinder_sex")."")); if ($numrows>0) { $result = $db->query("select sid, sextitle from ".$db->prefix("friendfinder_sex")." order by sextitle"); echo "
"._CATEGORY.':'." "; list($numrows) = $db->fetchRow($db->query("select catid, cattitle from ".$db->prefix("friendfinder_category")."")); if ($numrows>0) { $result = $db->query("select catid, cattitle from ".$db->prefix("friendfinder_category")." order by cattitle"); echo "
"._TEXTTANZ."
"._TEXTDESCRIPTION."
"._TEXTHEIGHT." ".$heightunit."
"._TEXTWEIGHT." ".$weightunit."
"._TEXTBIRTHDAY."
"; } } } include_once "admin/foot.php"; //************************************************************ CloseTable(); include_once("../../footer.php"); ?>