<?require_once( dirname(__FILE__) . '/header.php');?>
<?
$cmd=$_GET['cmd'];
$event=$_GET['event'];
$pawn_id=$_GET['pawn_id'];
$authorized = "Y";

if ($link): 

	if ( $event == "save"):
	 
		$error_flag = "N";
		
		if ($cmd != "upload_image" && $cmd != "remove_image" ):
		
			$pawn_name=trim($_POST["pawn_name"]);
			$pawn_vocation=$_POST["pawn_vocation"];
			$psn_name=trim($_POST["psn_name"]);
			$pawn_id=$_POST["pawn_id"];
			$pawn_level=$_POST["pawn_level"];
			$pawn_inclination1=$_POST["pawn_inclination1"];
			$pawn_inclination2=$_POST["pawn_inclination2"];
			$top_need=$_POST["top_need"];
			$pawn_description=trim($_POST["pawn_description"]);
			$other_information=trim($_POST["other_information"]);
			$activity_status=$_POST["activity_status"];
			$show_image_flag = $_POST["show_image_flag"];
			$pawn_rank=$_POST["pawn_rank"];
			$gender=$_POST["gender"];
			$platform=$_POST["platform"];
			$steam_profile=$_POST["steam_profile"];
			
			if ( strlen($pawn_description) > 4999 ) { $pawn_description = substr($pawn_description,0,4999); }
			if ( strlen($other_information) > 4999 ) { $other_information = substr($other_information,0,4999); }
			
			if ($pawn_rank == ""):
				$pawn_rank = 0;
			else:
				settype($pawn_rank, "int");
			endif;
			
			if ($pawn_level == ""):
				$pawn_level = 1;
			else:
				settype($pawn_level, "int");
				if ($pawn_level == 0):
					$pawn_level = 1;
				endif;
			endif;
			
			$db_pawn_name = addslashes($pawn_name);
			$db_psn_name = addslashes($psn_name);
			$db_pawn_description = addslashes($pawn_description);
			$db_other_information = addslashes($other_information);
			$db_steam_profile = addslashes($steam_profile);

			if ($psn_name == ""):
				$error_flag = "Y";
				$error_message = "You must enter your PSN name";
			elseif ($pawn_name == ""):
				$error_flag = "Y";
				$error_message = "You must enter your pawn name";			
			elseif ($pawn_level < 1 || $pawn_level > 200 ):
				$error_flag = "Y";
				$error_message = "Pawn level must be between 1 and 200";			
			elseif ($pawn_rank < 0 || $pawn_rank > 9999999 ):
				$error_flag = "Y";
				$error_message = "Pawn rank must be between 0 and 9999999";						
			endif;
			
		endif;			
		
		if ( $cmd == "add" && $error_flag == "N"):
			$result  =  mysqli_query($link, "select count(*) from pawn where psn_name='$psn_name' and platform='$platform'");
			$row  =  mysqli_fetch_row($result);
			if ( $row[0] == 0 ):
				$sql = "insert  into  pawn  (member_id, psn_name, pawn_name, pawn_vocation, inclination1, inclination2, pawn_level, pawn_description, other_information, creation_date, activity_status, show_image_flag, top_need, pawn_rank, gender, instance_name, platform, steam_profile)  values   ($login_id,  '$db_psn_name', '$db_pawn_name', '$pawn_vocation', '$pawn_inclination1', '$pawn_inclination2', $pawn_level, '$db_pawn_description','$db_other_information', CURDATE(), '$activity_status', 'N', '$top_need', $pawn_rank, '$gender','$instance_name', '$platform', '$db_steam_profile' )";
				$result = mysqli_query($link, $sql );
				if(!$result):
						$error_flag = "Y";
						$error_message="Insert failed due " . mysqli_error($link);
				else:
						$result = mysqli_query($link,"select pawn_id from pawn where member_id='$login_id' and psn_name='$psn_name'");
						$row = mysqli_fetch_row($result);
						$pawn_id=$row[0];
						$cmd = "edit";
						$success_message = "Your new pawn " . stripslashes($pawn_name) . " was successfully added.";                          
				endif;
			else:
				$error_flag = "Y";
				$error_message = "Pawn already exists for this network ID and platform!";
			endif;
		elseif ( $cmd == "edit" && $error_flag == "N"):
			$sql = "update pawn set psn_name = '$db_psn_name', pawn_name = '$db_pawn_name', pawn_vocation = '$pawn_vocation', pawn_level = $pawn_level, inclination1 = '$pawn_inclination1', inclination2 = '$pawn_inclination2', pawn_description = '$db_pawn_description', other_information = '$db_other_information', activity_status='$activity_status', last_update_date=CURDATE(), platform = '$platform'";
			$sql = $sql . " ,top_need = '$top_need', pawn_rank = $pawn_rank, gender = '$gender', steam_profile='$db_steam_profile' where pawn_id=$pawn_id";
			$result = mysqli_query($link, $sql );
			if(!$result):
				$error_flag = "Y";
				$error_message="Update failed due " . mysqli_error($link);
			else:
				$success_message = "Changes made to your pawn " . stripslashes($pawn_name) . " were successfully updated.";
			endif;
		endif;
	elseif ( $cmd == "edit"):
			if ( $pawn_id != "" ):
				$sql = "select psn_name, pawn_name, pawn_vocation, pawn_level, inclination1, inclination2, pawn_description, other_information, activity_status, member_id, image_name, show_image_flag, top_need, pawn_rank, internal_image_name, gender, platform, steam_profile from pawn where pawn_id=$pawn_id";
				$result = mysqli_query($link, $sql );
				$row = mysqli_fetch_row($result);
				if ($row[9] != $login_id):
						$error_flag = "Y";
						$error_message = "You cannot edit a pawn which is not yours!";
						$authorized = "N";
				else:
					$psn_name = trim($row[0]);
					$pawn_name = trim($row[1]);
					$pawn_vocation = $row[2];
					$pawn_level = $row[3];
					$pawn_inclination1 = $row[4];
					$pawn_inclination2 = $row[5];
					$pawn_description = trim($row[6]);
					$other_information = trim($row[7]);
					$activity_status = $row[8];
					$image_name=$row[10];
					$top_need=$row[12];
					$pawn_rank=$row[13];
					$internal_image_name=$row[14];
					$gender=$row[15];
					$platform=$row[16];
					$steam_profile=$row[17];
				endif;                        
			endif;
	endif;
endif; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html><head><meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Official Dragon's Dogma Pawn Sharing Club - Pawn</title>
<link rel="stylesheet" href="jquery-ui.css">
<link rel="stylesheet" href="<?echo $opsc_theme;?>"/>
<script src="jquery-1.10.2.js"></script>
<script src="jquery-ui.js"></script>
<script src='autosize.min.js'></script>
<script>
  $(function() {
    $( document ).tooltip();
  });  
  </script>

</head><body>

<?require_once( dirname(__FILE__) . '/top.php');?>

<?if ($link && $login_id != 0):?>

<? if ( $authorized == "Y" ): ?>
 
	<? if ($cmd == "add"): ?>
		<div class="pagetitle">Add New Pawn Information</div>
		<div class="breadtext">Please complete the form below and remember to keep your pawn information up-to-date.</div>
	<? else: ?>
        <div class="pagetitle">Modify Your Pawn Information</div>
		<div class="breadtext">Remember to keep your pawn information up-to-date.</div>
	<? endif; ?>

<div class="breadtext">* indicates required field</div>       

<form class="vertical" action="pawn.php?cmd=<?echo "$cmd";?>&event=save" method="post" name="pawn">

<div class="form_box">
	<div class="form_title">Pawn Details</div>

	<p>
		<label for="psn_name">PSN Name *</label> 
		<input cols="30" maxlength="30" size="30" rows="1" id="psn_name" name="psn_name" value="<?echo htmlspecialchars($psn_name);?>">
		<input cols="30" rows="1" name="pawn_id" type="hidden" value="<?echo "$pawn_id"?>">
	</p>
	
	<p>
		<label for="platform">Platform *</label> 
		<select name="platform" id="platform">
			<option style="margin-bottom:1px;padding-left:30px;background: url('ps3-icon.png') 0 0 no-repeat;"   value="PS3">Sony PlayStation 3</option>
			<option style="margin-bottom:1px;padding-left:30px;background: url('ps4-icon.png') 0 0 no-repeat;"   value="PS4">Sony PlayStation 4</option>
			<option style="margin-bottom:1px;padding-left:30px;background: url('pc-icon.png') 0 0 no-repeat;"   value="PC">Personal Computer</option>
			<option style="margin-bottom:1px;padding-left:30px;background: url('xbox-icon.png') 0 0 no-repeat;"   value="XBOX">Microsoft Xbox</option>
			<option style="margin-bottom:1px;padding-left:30px;background: url('xboxone-icon.png') 0 0 no-repeat;"   value="XBOXONE">Microsoft Xbox One</option>
		</select>
	</p>
	
	<p>
		<label for="pawn_name">Pawn Name *</label>
		<input cols="30" size="30" maxlength="30" rows="1" id="pawn_name" name="pawn_name" value="<?echo htmlspecialchars($pawn_name);?>">
	</p>	

	<p>
		<label for="gender">Gender</label>
		<select name="gender" id="gender" style="width:15em;">
			<option value="male" <?if ($gender=="male"):?>selected="true"<?endif;?> >Male</option>
			<option value="female" <?if ($gender=="female"):?>selected="true"<?endif;?> >Female</option>
		</select>
	</p>	
	
	<p>
			<label for="pawn_vocation" >Vocation *</label>
			<select name="pawn_vocation" id="pawn_vocation" style="width:15em;">
				<option style="margin-bottom:1px;padding-left:30px;background: url('Fighter.jpg') 0 0 no-repeat;" value="Fighter" <?if ($pawn_vocation=="Fighter"):?>selected="true"<?endif;?> >Fighter</option>
				<option style="margin-bottom:1px;padding-left:30px;background: url('Strider.jpg') 0 0 no-repeat;"value="Strider" <?if ($pawn_vocation=="Strider"):?>selected="true"<?endif;?> >Strider</option>
				<option style="margin-bottom:1px;padding-left:30px;background: url('Mage.jpg') 0 0 no-repeat;" value="Mage" <?if ($pawn_vocation=="Mage"):?>selected="true"<?endif;?> >Mage</option>
				<option style="margin-bottom:1px;padding-left:30px;background: url('Warrior.jpg') 0 0 no-repeat;" value="Warrior" <?if ($pawn_vocation=="Warrior"):?>selected="true"<?endif;?> >Warrior</option>
				<option style="margin-bottom:1px;padding-left:30px;background: url('Ranger.jpg') 0 0 no-repeat;" value="Ranger" <?if ($pawn_vocation=="Ranger"):?>selected="true"<?endif;?> >Ranger</option>
				<option style="margin-bottom:1px;padding-left:30px;background: url('Sorcerer.jpg') 0 0 no-repeat;" value="Sorcerer" <?if ($pawn_vocation=="Sorcerer"):?>selected="true"<?endif;?> >Sorcerer</option>
			</select>
	</p>

	<p>
		<label for="pawn_level">Level *</label>
		<input type="number" min="1" max="200" size="3" id="pawn_level" name="pawn_level" style="width: 50px;" value="<?echo "$pawn_level"?>">				
	</p>	
	
	<p>
		<label for="pawn_inclination">Primary Inclination</label>
		<select name="pawn_inclination1" id="pawn_inclination" style="width:15em;">
			<option value=""></option>
			<option value="Scather" <?if ($pawn_inclination1=="Scather"):?>selected="true"<?endif;?> >Scather</option>
			<option value="Medicant" <?if ($pawn_inclination1=="Medicant"):?>selected="true"<?endif;?> >Medicant</option>
			<option value="Mitigator" <?if ($pawn_inclination1=="Mitigator"):?>selected="true"<?endif;?> >Mitigator</option>
			<option value="Challenger" <?if ($pawn_inclination1=="Challenger"):?>selected="true"<?endif;?> >Challenger</option>
			<option value="Utilitarian" <?if ($pawn_inclination1=="Utilitarian"):?>selected="true"<?endif;?> >Utilitarian</option>
			<option value="Guardian" <?if ($pawn_inclination1=="Guardian"):?>selected="true"<?endif;?> >Guardian</option>
			<option value="Nexus" <?if ($pawn_inclination1=="Nexus"):?>selected="true"<?endif;?> >Nexus</option>
			<option value="Pioneer" <?if ($pawn_inclination1=="Pioneer"):?>selected="true"<?endif;?> >Pioneer</option>
			<option value="Acquisitor" <?if ($pawn_inclination1=="Acquisitor"):?>selected="true"<?endif;?> >Acquisitor</option>
		</select>		
	</p>	
	
	<p>
		<label for="pawn_inclination2">Secondary Inclination</label>
		<select id="pawn_inclination2" name="pawn_inclination2" style="width:15em;">
			<option value=""></option>
			<option value="Scather" <?if ($pawn_inclination2=="Scather"):?>selected="true"<?endif;?> >Scather</option>
			<option value="Medicant" <?if ($pawn_inclination2=="Medicant"):?>selected="true"<?endif;?> >Medicant</option>
			<option value="Mitigator" <?if ($pawn_inclination2=="Mitigator"):?>selected="true"<?endif;?> >Mitigator</option>
			<option value="Challenger" <?if ($pawn_inclination2=="Challenger"):?>selected="true"<?endif;?> >Challenger</option>
			<option value="Utilitarian" <?if ($pawn_inclination2=="Utilitarian"):?>selected="true"<?endif;?> >Utilitarian</option>
			<option value="Guardian" <?if ($pawn_inclination2=="Guardian"):?>selected="true"<?endif;?> >Guardian</option>
			<option value="Nexus" <?if ($pawn_inclination2=="Nexus"):?>selected="true"<?endif;?> >Nexus</option>
			<option value="Pioneer" <?if ($pawn_inclination2=="Pioneer"):?>selected="true"<?endif;?> >Pioneer</option>
			<option value="Acquisitor" <?if ($pawn_inclination2=="Acquisitor"):?>selected="true"<?endif;?> >Acquisitor</option>
			</select>
	</p>

	<p>
		<label for="top_need">Needs (Top Priority)</label>
			<select id="top_need" name="top_need" style="width:15em;">
			<option value="" <?if ($top_need=="" || $top_need == "Unspecified"):?>selected="true"<?endif;?> ></option>
			<option value="Rift Crystals (RC)" <?if ($top_need=="Rift Crystals (RC)"):?>selected="true"<?endif;?> >Rift Crystals (RC)</option>
			<option value="Rents" <?if ($top_need=="Rents"):?>selected="true"<?endif;?> >Rents</option>
			<option value="Equipment" <?if ($top_need=="Equipment"):?>selected="true"<?endif;?> >Equipment</option>
			<option value="Area Knowledge" <?if ($top_need=="Area Knowledge"):?>selected="true"<?endif;?> >Area Knowledge</option>
			<option value="Bestiary Knowledge" <?if ($top_need=="Bestiary Knowledge"):?>selected="true"<?endif;?> >Bestiary Knowledge</option>
			<option value="Materials" <?if ($top_need=="Materials"):?>selected="true"<?endif;?> >Materials</option>
			<option value="Quest Items" <?if ($top_need=="Quest Items"):?>selected="true"<?endif;?> >Quest Items</option>
			<option value="BBI Items" <?if ($top_need=="BBI Items"):?>selected="true"<?endif;?> >BBI Items</option>
			<option value="Fondling" <?if ($top_need=="Fondling"):?>selected="true"<?endif;?> >Fondling</option>
			<option value="Soapy Massage" <?if ($top_need=="Soapy Massage"):?>selected="true"<?endif;?> >Soapy Massage</option>
			<option value="Fondling & Soapy Massage" <?if ($top_need=="Fondling & Soapy Massage"):?>selected="true"<?endif;?> >Fondling & Soapy Massage</option>
			<option value="Lurking" <?if ($top_need=="Lurking"):?>selected="true"<?endif;?> >Lurking</option>
			<option value="Nothing" <?if ($top_need=="Nothing"):?>selected="true"<?endif;?> >Nothing</option>
			</select>	
	</p>
	<div class="form_hint">You can specify your needs in the description or additional information fields.</div>
	
	<p>
		<label for="pawn_description">Description</label>
		<textarea cols="60" rows="4" maxlength="2000" id="pawn_description" name="pawn_description"><?echo htmlspecialchars($pawn_description);?></textarea>
	</p>
	
	<p>
		<label for="other_information">Additional information</label>
		<textarea cols="60" rows="4" maxlength="2000" id="other_information" name="other_information"><?echo htmlspecialchars($other_information);?></textarea>
	</p>	
	
	<p>
		<label for="pawn_rank">Current All-Time Ranking</label>
		<input type="number" min="0" max="99999999" id="pawn_rank" name="pawn_rank" size="7" style="width: 70px;" value="<?echo $pawn_rank;?>">
		<div class="form_hint">Your pawn ranking is based on the number of times he or she has been hired 
		by other players. You can check your own pawn ranking from the Rift, by searching Top Pawns.</div>
	</p>	

	<p>
		<label for="activity_status">Status</label>
		<select name="activity_status" id="activity_status" style="width:15em;">
			<option value="A" <?if ($activity_status=="A"):?>selected="true"<?endif;?> >Active</option>
			<option value="I" <?if ($activity_status=="I"):?>selected="true"<?endif;?> >Inactive</option>
		</select>		
	</p>
	
	<p>
		<label for="steam_profile">Steam Profile (for PC players only)</label>
		<input size="60" maxlength="255" id="steam_profile" name="steam_profile" value="<?echo htmlspecialchars($steam_profile);?>">
	</p>	
	<div class="form_hint">Enter link in format <i>http://steamcommunity.com/id/{your ID}</i></div>
	
	<div class="form_buttonbar">
		<a href="" class="bluebutton" onclick="document.pawn.submit();return false;">Save</a>
		<a href="mypawn.php" class="bluebutton">Back</a> 		
	</div>
	
</div>
</form>
<? endif;?>

<? else: require_once( dirname(__FILE__) . '/not_logged.php'); ?>
<? endif; ?>

<? if ($debug_flag == "Y"):
	 echo "Event: $event - SQL: $sql";
   endif; ?>
<? require_once( dirname(__FILE__) . '/footer.php');?>
<script>
	autosize(document.querySelectorAll('textarea'));
</script>
</body></html>