<?
header('Content-Type: text/html; charset=utf-8');
session_start();


#error_reporting(E_ALL);
#ini_set('display_errors', '1');

	require_once $_SERVER["DOCUMENT_ROOT"].'/websocket/vendor/autoload.php';

use swentel\nostr\Key\Key;


$editpage = 1;
$dt = "edit profile";
include("db.php");
include("metas.php");
include("header2.php");


if($_REQUEST["update"] == 1){
	
	//echo 'c'.$_REQUEST["country2"];
	$username = str_replace(" ","",trim($_REQUEST["cuser4"]));
	$username = preg_replace("/[^A-Za-z0-9]/","",$username); 
	$username = str_replace("-","",$username);

/*
$stmt = $pdodb->prepare("SELECT username FROM girls WHERE username=:username");
$stmt->bindParam(':sessid',$_SESSION["uid"],PDO::PARAM_INT);
$stmt->execute();

while($i3=$stmt->fetch()) {

	$username = $i3["username"];

}
*/
$city = ucwords(trim(strip_tags($_REQUEST["city"])));

	if($city <> ""){
		#echo 'getting city';
		$geocode = getGeoCode($city." ".$c_codes[$_REQUEST["country"]]);
		#print_r($getcode);
		#echo $geocode["lat"];
		$d_lat2 = $geocode["lat"];
		$d_lon2 = $geocode["lon"];
		
	    if($d_dblat == 0){		
			/*
			$stmt = $pdodb->prepare("UPDATE LOW_PRIORITY forum SET dblat=:dblat, dblon=:dblon WHERE mid=:mid AND dblat=0");
			$stmt->bindParam(':dblat',$d_lat2);
			$stmt->bindParam(':dblon',$d_lon2);
			$stmt->bindParam(':mid',$_SESSION["uid"]);
			$stmt->execute();
			*/
		}

	}else{
		$d_lat2 = 0;
		$d_lon2 = 0;
	}


	$_REQUEST["paypal"] = str_ireplace("https://www.paypal.me/","",$_REQUEST["paypal"]);
	$_REQUEST["paypal"] = str_ireplace("paypal.me/","",$_REQUEST["paypal"]);

$cashapp["paypal"] = str_ireplace("$Cash.app/","",$_REQUEST["cashapp"]);

	if(stristr($_REQUEST["skyfeed"],"skyfeed") && stristr($_REQUEST["skyfeed"],"user")){
		$_REQUEST["skyfeed"] = $_REQUEST["skyfeed"];
	}else{
		$_REQUEST["skyfeed"] = "";
	}

    $bday = $_REQUEST["bday"];
    $bmonth = $_REQUEST["bmonth"];
    $byear = $_REQUEST["byear"];


		$stmt2 = $pdodb->prepare("UPDATE LOW_PRIORITY girls SET aboutme=:aboutme, country=:country,bmonth=:bmonth,byear=:byear,bday=:bday,rstatus=:rstatus,city=:city,fname=:fname,username=:username, jobdesc=:jobdesc, socmedia=:socmedia, 
		edu=:edu,emailis=:emailis,ffooter=:ffooter,dblon=:dblon,dblat=:dblat,tags=:tags,nostrnpub=:nostrnpub,cashapp=:cashapp,venmo=:venmo,favrelay=:favrelay,bitcoin=:bitcoin,onlyfans=:onlyfans,instagram=:instagram,twitter=:twitter,gender=:gender,datingact=:datingact,citylon=:dblon,citylat=:dblat,telegram=:telegram,kinaddress=:kinaddress,children_preference=:children_preference,height=:height,sorientation=:sorientation WHERE ID=:user_id");
		$stmt2->bindParam(':aboutme',trim(strip_tags($_REQUEST["aboutme"])));
		// Bind the new parameters
		$stmt2->bindParam(':bday', $bday, PDO::PARAM_INT);
		$stmt2->bindParam(':bmonth', $bmonth, PDO::PARAM_INT);
		$stmt2->bindParam(':byear', $byear, PDO::PARAM_INT);

		$stmt2->bindParam(':emailis',$_REQUEST["emailis"]);	
		$stmt2->bindParam(':bmonth',$_REQUEST["bmonth"]);
		$stmt2->bindParam(':byear',$_REQUEST["byear"]);
		$stmt2->bindParam(':country',$_REQUEST["country"]);
		$stmt2->bindParam(':rstatus',$_REQUEST["rstatus"]);
		$stmt2->bindParam(':user_id',$_SESSION["uid"],PDO::PARAM_INT);
		$stmt2->bindParam(':city',trim($city));	
		$stmt2->bindParam(':fname',ucwords($_REQUEST["fname"]));	
		$stmt2->bindParam(':jobdesc',strip_tags($_REQUEST["jobdesc"]));	
		$stmt2->bindParam(':socmedia',strip_tags($_REQUEST["socmedia"]));	
		$stmt2->bindParam(':edu',strip_tags($_REQUEST["edu"]));	
		$stmt2->bindParam(':ffooter',strip_tags($_REQUEST["ffooter"]));	
		$stmt2->bindParam(':username',$username);	
	
	    $stmt2->bindParam(':dblon',$d_lon2);	
		$stmt2->bindParam(':dblat',$d_lat2);	

		$stmt2->bindParam(':cashapp',trim($_REQUEST["cashapp"]));	
		$stmt2->bindParam(':venmo',trim($_REQUEST["venmo"]));	

		$stmt2->bindParam(':bitcoin',trim($_REQUEST["bitcoin"]));	
		$stmt2->bindParam(':instagram',trim($_REQUEST["instagram"]));
		$stmt2->bindParam(':onlyfans',trim($_REQUEST["onlyfans"]));	
		$stmt2->bindParam(':twitter',trim($_REQUEST["twitter"]));	

		$stmt2->bindParam(':gender',trim($_REQUEST["gender"]));	
		$stmt2->bindParam(':nostrnpub',trim($_REQUEST["nostrnpub"]));	
		$telegram = str_replace("@","",$_REQUEST["telegram"]);
		$stmt2->bindParam(':telegram',trim($telegram));
		$stmt2->bindParam(':datingact',trim($_REQUEST["datingact"]));
		$stmt2->bindParam(':favrelay',trim($_REQUEST["favrelay"]));	
		$stmt2->bindParam(':tags',trim($_REQUEST["tags"]));	
		$stmt2->bindParam(':kinaddress',trim($_REQUEST["kinaddress"]));	
		$stmt2->bindParam(':children_preference',$_REQUEST["children_preference"]);
		$stmt2->bindParam(':height',trim($_REQUEST["height"]));
		$stmt2->bindParam(':sorientation',trim($_REQUEST["sorientation"]));
		$stmt2->execute();

	if($city <> ""){
		if($_REQUEST["country"] <> ""){
			$fullplace = str_replace(" ","-",$city).'-'.str_replace(" ","-",$c_codes[$_REQUEST["country"]]);
		}else{
			$fullplace = str_replace(" ","-",$city);
		}
		$stmt = $pdodb->prepare("SELECT ID FROM forums WHERE forumseo=:name2 LIMIT 1");
		$stmt->bindParam(':name2',$fullplace);
		$stmt->execute();
		$nrows = $stmt->rowCount();

		if($nrows == 0){
			#echo 'fullplace'.$fullplace;
				$fullcity = $city.' '.$c_codes[$_REQUEST["country2"]];
				$stmt = $pdodb->prepare("INSERT IGNORE INTO forums (forumtitle, forumseo,dblat,dblon) VALUES(:name,:name2,:dblat,:dblon)");
				$stmt->bindParam(':name',$fullcity);
				$stmt->bindParam(':name2',$fullplace);
				$stmt->bindParam(':dblat',$d_lat2);
				$stmt->bindParam(':dblon',$d_lon2);
				$stmt->execute();
				$forumid = $pdodb->lastInsertId();	
		}else{
			#echo 'exists';
			while($i3=$stmt->fetch()) {  
				$forumid = $i3["ID"];
			}

		}
		/*
		$lastvoteint = intval(date("YmdHi")); 
		$preptitle = "I am ".$_REQUEST["fname"]." and new in ".$city." Forum";
		$seourl = str_replace(" ","-",$preptitle);
		$anon = 0;
		$cat = $city;
		$descis = "feel free to write me (".$_REQUEST["fname"].") here in the ".$city." Forum ";

		$stmt = $pdodb->prepare("INSERT IGNORE INTO forum (titleis, seox,descis,mid,timeposted,forum,forumseo,anon,lastvoteint,votepoints,dblon,dblat) VALUES(:titleis,:seourl,:descis,:mid,now(),:forumid,:forumseo,:anon,:lastvoteint,1,:dblon,:dblat)");
		$pdodb->setAttribute(PDO::ATTR_EMULATE_PREPARES,false); 
		$stmt->bindParam(':dblat',$d_lat2);
		$stmt->bindParam(':dblon',$d_lon2);
		$stmt->bindParam(':titleis',$preptitle);
		$stmt->bindParam(':seourl',$seourl);
		$stmt->bindParam(':anon',$anon);
		$stmt->bindParam(':forumid',$forumid);
		$stmt->bindParam(':forumseo',$fullplace);
		$stmt->bindParam(':descis',strip_tags($descis));
		$stmt->bindParam(':mid',$_SESSION["uid"],PDO::PARAM_INT);
		$stmt->bindParam(':lastvoteint',$lastvoteint);

		$stmt->execute();
							//print_r($pdodb->errorInfo());

		if($forumid > 0){
			#$nowis = intval(date("YmdHi")); 
			#$stmt = $pdodb->prepare("UPDATE LOW_PRIORITY forums SET lastactionint=:nowis WHERE ID=:forumid LIMIT 1");
			#$stmt->bindParam(':forumid',$forumid);
			#$stmt->bindParam(':nowis',$nowis);
			#$stmt->execute();

			#subscribeto($forumid);
		}
		
		$stmt = $pdodb->prepare("UPDATE LOW_PRIORITY subscribeto SET newstuff=newstuff+1 WHERE cid=:forumid");
		$stmt->bindParam(':forumid',$forumid);
		$stmt->execute();
		*/
	}

}

$stmt = $pdodb->prepare("SELECT mainpic,aboutme,nostrnpub,country,bday,tags,bmonth,byear,rstatus,city,fname,username,dblat,dblon,jobdesc,edu,emailis,ffooter,socmedia,cashapp,venmo,favrelay,bitcoin,instagram,twitter,onlyfans,gender,datingact,
nostrhash,telegram,kinaddress,children_preference,height,sorientation FROM girls WHERE ID=:sessid");
$stmt->bindParam(':sessid',$_SESSION["uid"],PDO::PARAM_INT);
$stmt->execute();

while($i3=$stmt->fetch()) {
	$aboutme = $i3["aboutme"];
	$country = $i3["country"];
	$bday = $i3["bday"];
	$bmonth = $i3["bmonth"];
	$byear = $i3["byear"];
	$rstatus = $i3["rstatus"];
	$city = $i3["city"];
	$fname = $i3["fname"];
	$username = $i3["username"];
	$mainpic = $i3["mainpic"];
	$jobdesc = $i3["jobdesc"];
	$dblat = $i3["dblat"];
	$dblon = $i3["dblon"];

	$edu = $i3["edu"];
	$emailis = $i3["emailis"];
	$ffooter = $i3["ffooter"];
	$socmedia = $i3["socmedia"];
	$cashapp = $i3["cashapp"];
	$venmo = $i3["venmo"];
	$favrelay = $i3["favrelay"];
	$bitcoin = $i3["bitcoin"];
	$instagram = $i3["instagram"];
	$twitter = $i3["twitter"];
	$onlyfans = $i3["onlyfans"];
	$gender = $i3["gender"];
	$datingact = $i3["datingact"];
	$nostrnpub = $i3["nostrnpub"];
	$tags = $i3["tags"];
	$nostrhash = $i3["nostrhash"];
	$telegram = $i3["telegram"];
	$kinaddress = $i3["kinaddress"];
	$currentPreference = $i3["children_preference"];
	$currentHeight = $i3["height"];
	$sorientationselect = $i3["sorientation"];
}

if($nostrnpub == ""){

	$key = new Key();

	$private_key = $key->generatePrivateKey();
	$nostrhash = $private_key;

	$nostrnpub = $key->getPublicKey($private_key);
	$nostrnpub = $key->convertPublicKeyToBech32($nostrnpub);

}

?>

<script src="/test/bech32.js?664a3e6a683cd" ></script>


<div class="container">
<BR>
<a href="/upload.php" style="font-weight:bold;">edit photos</a> |  <a href="/" style="font-weight:bold;">view profile</a><!-- | <a href="/blogs" style="font-weight:bold;">manage blogs</a>--><br>
<br>
<?
if($_SESSION["uid"] > 0){
?>
<b>Edit Profile</b><br>
edit the following fields<br>
<script>
$(document).ready(function() {
	$("#biotext").focus();
})
</script>


<form action="/editabout.php" id=cjoin method=post enctype="multipart/form-data" style="padding:3px 0px 0px 0px; margin:0px;">
<div style="padding:20px 0px;">

<b>Tell us about you</b><br>
<textarea  class="form-control" name=aboutme id="biotext" placeholder="something about you" rows=5></textarea><br>

<b>Birthday:</b><br>
<!-- Day dropdown -->
<select name="bday" class="form-control">
    <option value="1" >1</option>
    <option value="2" >2</option>
    <option value="3" >3</option>
    <option value="4" >4</option>
    <option value="5" >5</option>
    <option value="6" >6</option>
    <option value="7" >7</option>
    <option value="8" >8</option>
    <option value="9" >9</option>
    <option value="10" >10</option>
    <option value="11" >11</option>
    <option value="12" >12</option>
    <option value="13" >13</option>
    <option value="14" >14</option>
    <option value="15" >15</option>
    <option value="16" >16</option>
    <option value="17" >17</option>
    <option value="18" >18</option>
    <option value="19" >19</option>
    <option value="20" >20</option>
    <option value="21" >21</option>
    <option value="22" >22</option>
    <option value="23" >23</option>
    <option value="24" >24</option>
    <option value="25" >25</option>
    <option value="26" >26</option>
    <option value="27" >27</option>
    <option value="28" >28</option>
    <option value="29" >29</option>
    <option value="30" >30</option>
    <option value="31" >31</option>
</select>

<!-- Month dropdown -->
<select name="bmonth" class="form-control">
    <option value="1" >January</option>
    <option value="2" >February</option>
    <option value="3" >March</option>
    <option value="4" >April</option>
    <option value="5" >May</option>
    <option value="6" >June</option>
    <option value="7" >July</option>
    <option value="8" >August</option>
    <option value="9" >September</option>
    <option value="10" >October</option>
    <option value="11" >November</option>
    <option value="12" >December</option>
</select>

<!-- Year dropdown -->
<select name="byear" class="form-control">
    <option value="2024" >2024</option>
    <option value="2023" >2023</option>
    <option value="2022" >2022</option>
    <option value="2021" >2021</option>
    <option value="2020" >2020</option>
    <option value="2019" >2019</option>
    <option value="2018" >2018</option>
    <option value="2017" >2017</option>
    <option value="2016" >2016</option>
    <option value="2015" >2015</option>
    <option value="2014" >2014</option>
    <option value="2013" >2013</option>
    <option value="2012" >2012</option>
    <option value="2011" >2011</option>
    <option value="2010" >2010</option>
    <option value="2009" >2009</option>
    <option value="2008" >2008</option>
    <option value="2007" >2007</option>
    <option value="2006" >2006</option>
    <option value="2005" >2005</option>
    <option value="2004" >2004</option>
    <option value="2003" >2003</option>
    <option value="2002" >2002</option>
    <option value="2001" >2001</option>
    <option value="2000" >2000</option>
    <option value="1999" >1999</option>
    <option value="1998" >1998</option>
    <option value="1997" >1997</option>
    <option value="1996" >1996</option>
    <option value="1995" >1995</option>
    <option value="1994" >1994</option>
    <option value="1993" >1993</option>
    <option value="1992" >1992</option>
    <option value="1991" >1991</option>
    <option value="1990" >1990</option>
    <option value="1989" >1989</option>
    <option value="1988" >1988</option>
    <option value="1987" >1987</option>
    <option value="1986" >1986</option>
    <option value="1985" >1985</option>
    <option value="1984" >1984</option>
    <option value="1983" >1983</option>
    <option value="1982" >1982</option>
    <option value="1981" >1981</option>
    <option value="1980" >1980</option>
    <option value="1979" >1979</option>
    <option value="1978" >1978</option>
    <option value="1977" >1977</option>
    <option value="1976" >1976</option>
    <option value="1975" >1975</option>
    <option value="1974" >1974</option>
    <option value="1973" >1973</option>
    <option value="1972" >1972</option>
    <option value="1971" >1971</option>
    <option value="1970" >1970</option>
    <option value="1969" >1969</option>
    <option value="1968" >1968</option>
    <option value="1967" >1967</option>
    <option value="1966" >1966</option>
    <option value="1965" >1965</option>
    <option value="1964" >1964</option>
    <option value="1963" >1963</option>
    <option value="1962" >1962</option>
    <option value="1961" >1961</option>
    <option value="1960" >1960</option>
    <option value="1959" >1959</option>
    <option value="1958" >1958</option>
    <option value="1957" >1957</option>
    <option value="1956" >1956</option>
    <option value="1955" >1955</option>
    <option value="1954" >1954</option>
    <option value="1953" >1953</option>
    <option value="1952" >1952</option>
    <option value="1951" >1951</option>
    <option value="1950" >1950</option>
    <option value="1949" >1949</option>
    <option value="1948" >1948</option>
    <option value="1947" >1947</option>
    <option value="1946" >1946</option>
    <option value="1945" >1945</option>
    <option value="1944" >1944</option>
    <option value="1943" >1943</option>
    <option value="1942" >1942</option>
    <option value="1941" >1941</option>
    <option value="1940" >1940</option>
    <option value="1939" >1939</option>
    <option value="1938" >1938</option>
    <option value="1937" >1937</option>
    <option value="1936" >1936</option>
    <option value="1935" >1935</option>
    <option value="1934" >1934</option>
    <option value="1933" >1933</option>
    <option value="1932" >1932</option>
    <option value="1931" >1931</option>
    <option value="1930" >1930</option>
    <option value="1929" >1929</option>
    <option value="1928" >1928</option>
    <option value="1927" >1927</option>
    <option value="1926" >1926</option>
    <option value="1925" >1925</option>
    <option value="1924" >1924</option>
    <option value="1923" >1923</option>
    <option value="1922" >1922</option>
    <option value="1921" >1921</option>
    <option value="1920" >1920</option>
    <option value="1919" >1919</option>
    <option value="1918" >1918</option>
    <option value="1917" >1917</option>
    <option value="1916" >1916</option>
    <option value="1915" >1915</option>
    <option value="1914" >1914</option>
    <option value="1913" >1913</option>
    <option value="1912" >1912</option>
    <option value="1911" >1911</option>
    <option value="1910" >1910</option>
    <option value="1909" >1909</option>
    <option value="1908" >1908</option>
    <option value="1907" >1907</option>
    <option value="1906" >1906</option>
    <option value="1905" >1905</option>
    <option value="1904" >1904</option>
    <option value="1903" >1903</option>
    <option value="1902" >1902</option>
    <option value="1901" >1901</option>
    <option value="1900" >1900</option>
</select>
<b>Children:</b><br>
<select name="children_preference" id="children_preference" class="form-control">
    </select>
<b>Sexual Orientation:</b><br>
<select name="sorientation" id="sorientation" class="form-control">
    </select>

<?

echo '<label for="height" style="font-weight:bold;">Height:</label>';
echo '<select id="height" name="height" class="form-control">';

// Generate options
for ($cm = 140; $cm <= 210; $cm++) {
    $in = round($cm / 2.54); // Convert cm to inches
    $optionValue = "{$cm}cm / {$in}in"; // Create the option value

    // Check if the current option's centimeter part matches the current height and mark it as selected if it does
    $selected = ($cm == $currentHeight) ? 'selected' : '';

$heightInchesTotal = round($cm / 2.54);
$heightFeet = intval($heightInchesTotal / 12);
$heightInches = round($heightInchesTotal % 12);


    echo "<option value='{$optionValue}' {$selected}>{$cm} cm / " . $heightFeet . "' ". $heightInches . "\"</option>";
}

echo '</select>';
?>
<b>Your First Name or nickname</b><br>
<input type="text" name="fname" value="" class="form-control" placeholder="your first name or nickname">
<b>username</b><br>
<input type="text" name="cuser4" value=""  class="form-control"  required>
<b>E-Mail</b><br>
<input type="email" name="emailis" value=""  class="form-control" required>

<b>Relationship Status:</b><br>
		<select name=rstatus id=rstatus style="width:100%; overflow:hidden; display:block;" class="form-control">
		
		<?

echo '<option value="0" '.(($rstatus == 0)?'selected':'').'>not disclosed';

	echo '<option value="1" '.(($rstatus == 1)?'selected':'').'>Single (Looking)';
	echo '<option value="2" '.(($rstatus == 2)?'selected':'').'>Single (not looking)';

	echo '<option value="3" '.(($rstatus == 3)?'selected':'').'>Married (looking)';
	echo '<option value="4" '.(($rstatus == 4)?'selected':'').'>Married (not looking)';

	echo '<option value="5" '.(($rstatus == 5)?'selected':'').'>Open Relationship';
		
	echo '<option value="6" '.(($rstatus == 6)?'selected':'').'>Dating Someone (looking)';
	echo '<option value="7" '.(($rstatus == 7)?'selected':'').'>Dating Someone (not looking)';

	echo '<option value="8" '.(($rstatus == 8)?'selected':'').'>In a relationship (looking)';
	echo '<option value="9" '.(($rstatus == 9)?'selected':'').'>In a relationship (not looking)';
		?></select>	


<b>City</b><br>
<input type="city" name="city" value=""  class="form-control" required>

<b>Country:</b><br>
		<select name=country id=country style="width:100%; overflow:hidden; display:block;" class="form-control">
		
		<?

echo '<option value="">Click to Select Country';

foreach($c_codes_original as $c1 => $c2){
	echo '<option value="'.$c1.'" '.(($c1 == $country)?'selected':'').'>'.$c_codes_original[$c1].' / '.$c_codes[$c1].'';
}
		

		?></select>	

<b>tags which describe your interests (seperate by commas)</b><br>
<textarea  class="form-control" name=tags placeholder="etc. music, swimming, hiking, love game of thrones ..."></textarea>

<b>Code Wallet Mobile App Address</b> (to activate earnings download <a href="https://www.getcode.com" target=getcode>getcode.com</a>)<br>
in your code wallet go to account and deposit address. thats your code wallet address. do not enter other things like links or physical addresses<br>
<input type="text" name="kinaddress" value="" class="form-control" >

<!--
<b>Telegram Username</b> (optional)<br>
<input type="text" name="telegram" value="" class="form-control" >


<b>Twitter Username</b> (optional)<br>
<input type="text" name="twitter" value="" class="form-control">

<b>Onlyfans Username</b> (optional)<br>
<input type="text" name="onlyfans" value="" class="form-control" >

<b>Insta Username</b> (optional)<br>
<input type="text" name="instagram" value="" class="form-control" >
-->
<input type="submit" value=" update profile "  style="margin:10px 0px;" class="btn btn-success">
<input type="hidden" name="update" value="1" >
</form>

<script>
document.addEventListener("DOMContentLoaded", function() {
    var kinAddressInput = document.querySelector('input[name="kinaddress"]'); // Adjust the selector if necessary

    kinAddressInput.addEventListener("blur", function() {
        var address = kinAddressInput.value.trim();
        var isValid = /^[A-Za-z0-9]{32,44}$/.test(address); // Basic validation for Solana address format

        if (!isValid && address !== "") {
            alert("Please enter a valid token address found in the code wallet app.");
            kinAddressInput.value = ""; // Clear the invalid input
        }
    });
});
</script>


<br><br>
<?
}else{
	echo 'you must be registered and logged in to edit your profile';	
}
?>
</div></div></div>
<?
include('footer.php');

// Sort the array by its values
asort($c_codes_original);

// Output the full array as text
echo '$c_codes_sorted = ';
var_export($c_codes_original);
echo ";\n";
?>