<?
	$site_id = 1; // za Poker Party

	include("inc/inc_db_ivan.php"); //conect db

	$sql = 'SELECT * FROM '. $config['tables']['sites'] . " WHERE id=$site_id";
	$q = mysql_query($sql);
	$r = mysql_fetch_array($q, MYSQL_ASSOC);
	// price without $ sign
	$amount = ($r['price'][0] == '$')? substr($r['price'],1) : $r['price'];
	// verify input data, if any
	$msg = verify_form();

	// if reffered_by answer is: OTHER, assign that to reff param
	if(!$_POST['reff'] and $_POST['rother']) $_POST['reff'] = $_POST['rother'];

	if($_POST['process'] && !$msg) {

		$descr = 'Subscription to Stats For Poker for Poker Party players';

		//check for discount
		$discount_codes = array('1234', '5678', '9101', '1112', '1314', '1516', '7181', '9202', '1222',
		'3242', '5262', '7282', '9303', '1323', '3343', '5363', '7383', '9404', '1424', '3444', '5464',
		'7484', '9505', '1525', '3545', '5565', '7585', '9606', '1626', '3646', '5666', '7686', '9707',
		'1727', '3747', '5767', '7787', '9808', '1828', '3848', '5868', '7888', '9909', '1929', '3949',
		'5969', '7989');

		if( strtolower( trim( $_POST['discount'] ) ) == 'youoweme') {
			$amount -= 10;
			$descr .= ' (with a $10 discount)';

		}elseif( in_array($_POST['discount'], $discount_codes) ) {
			$amount -= 5;
			$descr .= ' (with a $5 discount)';
		}


		unset($loginid, $txnkey); //protect data

		// NOTE:.key script will check if $amount is set, if not it will exit;
		//include('../.sim/.key_pokerparty.inc.php'); //transaction key
		include('/var/www/.sim/.key_pokerparadise.inc.php');
		include('inc/simlib.php'); //fingerprint functions

		// create link to gateway
		$pay_link  = 'https://secure.authorize.net/gateway/transact.dll';

		$pay_link .= '?x_login=' . urlencode($loginid);
		$pay_link .= '&x_amount=' . urlencode($amount);
		$pay_link .= '&x_show_form=PAYMENT_FORM';
		$pay_link .= '&x_relay_response=True';
		$pay_link .= '&x_relay_url=' . urlencode('https://www.statsforpoker.com/confirm_pokerparty.php');
		$pay_link .= '&x_duplicate_window=600'; // check next 10 minutes for duplicate transactions

		$pay_link .= '&x_description='. urlencode($descr);
		$pay_link .= '&x_cust_id='    . urlencode( $_POST['user'] );
		$pay_link .= '&user='         . urlencode( $_POST['user'] );
		$pay_link .= '&pass='         . urlencode( $_POST['pass'] );
		$pay_link .= '&x_email='      . urlencode( $_POST['email'] );
		$pay_link .= '&x_email_customer=FALSE';
		$pay_link .= '&discount='     . urlencode( $_POST['discount'] );

		$pay_link .= '&reff_by='      . urlencode( $_POST['reff'] );
		$pay_link .= '&our_hostname=' . urlencode( $_SERVER['SERVER_NAME'] );

		$sequence = md5(uniqid(rand(), TRUE));
		$tstamp   = time ();
		$fp_hash  = CalculateFP($loginid, $txnkey, $amount, $sequence, $tstamp);

		$pay_link .= '&x_fp_sequence=' . $sequence;
		$pay_link .= '&x_fp_timestamp=' . $tstamp;
		$pay_link .= '&x_fp_hash=' . $fp_hash;


		// redirect to the gateway
		header('Location: ' . $pay_link);
		exit;

	}

function verify_form() {

	global $config, $site_id;

	if(!$_POST['process']) return ''; //if nothing submited;

	if(!($_POST['user'] || $_POST['email'])) return 'Please enter either username or email.';

	if(!$_POST['pass']) return 'Password is missing, please enter it.';
	if($_POST['pass'] != $_POST['pass2']) return 'Passwords don\'t match';

	if($_POST['email'] and !strpos($_POST['email'], '@'))  return 'Email is invalid, please check it.';

	if(!$_POST['agree']) return 'You have to check that you agree on EULA in order to proceed with registration.';


	//all data is OK, lets check if user already exists

	if($_POST['user']) $cond1 = 'username=\''. $_POST['user'] . '\'';
	if($_POST['email']) $cond2 = 'email=\'' .  $_POST['email'] . '\'';

	if($_POST['user'] && $_POST['email']) $cond = $cond1 . ' OR '. $cond2;
	else $cond = $cond1 . $cond2;

	$sql = 'SELECT * FROM ' . $config['tables']['users'] . " WHERE $cond";
	$q = mysql_query($sql);

	if(!$q)
		return 'Database request timed out, server is probably busy. Please try again, and if problem persists contact our support.';

	if ($r = mysql_fetch_array($q, MYSQL_ASSOC)) {  // if user exists

		if($r['pword'] == $_POST['pass'] and $r['username'] == $_POST['user'] and $r['email'] == $_POST['email']) {
			//lets check if there's already subscription
			$sql = 'SELECT * FROM ' . $config['tables']['subscr'] . ' WHERE member_id=' . $r['id'] .
				   ' AND site_id=' . $site_id;
			$q = mysql_query($sql);

			if(mysql_num_rows($q)>0) return 'You\'re already subscribed to this site, no need to subscribe again.';

			return '';
		}

		if($r['username'] == $_POST['user']) {
			return 'This username already exists in our system, but the rest of the data is not correct for this user.<br>If you already have an account on Stats For Poker please re-enter the correct infomation for your account. Otherwise please choose another username to create a new account.';
		}elseif($r['email'] == $_POST['email']) {
			return 'This email is already registered in our system.<br>If you already have account on Stats For Poker, please use that existing username and password. Otherwise please choose a different email to create a new account';

		}
	}
	return '';
}

	$title = "Stats For Poker - Subscription to Poker Party players database";
	include("header.php");

?>

						<div class="wrapper2">
							<div class="wrapper3">
								<div class="col_1">
									<div class="indent">


<div id="center1">

<?

if(!$msg) {


?>

<h2>Start winning more now by signing up below!</h2>

<p>
The StatsForPoker&#174; database will provide you with the knowledge you
need to increase your earnings immediately. Either of its two main
functions will increase your winnings today.
</p>
<p>
First, you can use the software to scan tables and decide which tables you
want to play on. Sure you can beat the best, but why not take the easy
money?
</p>
<p>
Secondly, you will be able to identify the winning and losing players so
that you can focus on obtaining the losing player's chips, while being
somewhat less aggressive initially versus the winning players. The end
result is a huge upswing in profits for you.
</p>
<p>
This purchase also includes our cutting edge software. The software will
scan an entire table for you at the touch of a button, and if you choose,
provide an overlay of the statistics on the poker table.
</p>
<?
}
?>
  </p>
</p>
<p><strong>BUY Stats For Poker</strong><span class="super">&reg;</span><strong> NOW !!! </strong></p>
<p>&nbsp;</p>
<p>
	<img src="/images/creditcards.gif" style="border:0; float:left; margin-right:10px;">
	<strong>The prices below include complete and unlimited access to our database,
our software, technical support, and free updates.</strong> <strong>We take Visa, Mastercard, Discover, and American Express. </strong><br />
	<strong>$ </strong> (one time fee)
</p>

<p>&nbsp;</p>
<p style="color:red;"></p>
<p>Please choose your username and password below:</p>

<script type="text/javascript" language="Javascript">
	var flag = true;
</script>


<form action="" method="post" onSubmit="if(flag){flag=false}else{return false}">
<input type="hidden" name="process" value="Submit">

<table border="0" cellspacing="5" cellpadding="7">
    <tr>
        <td><div align="right">Username:</div></td>
        <td><input name="user" type="text" value="" size="30" /></td>
    </tr>
    <tr>
        <td><div align="right">Password:</div></td>
        <td><input name="pass" type="password" value="" size="30" /></td>
    </tr>
    <tr>
        <td nowrap><div align="right">Confirm password:</div></td>
        <td><input name="pass2" type="password" value="" size="30" /></td>
    </tr>
    <tr>
        <td><div align="right">Email:</div></td>
        <td><input name="email" type="text" value="" size="30" /></td>
    </tr>
	<tr>
        <td><div align="right">Discount code:</div></td>
        <td><input name="discount" type="text" value="" size="10" /></td>
    </tr>
    <tr>
		<td colspan="2">I found about Stats For Poker from : (<em>optional</em>)</td>
	</tr>
	<tr>
		<td>&nbsp;</td>
		<td>
			<input id="reff1" name="reff" type="radio" value="friend"
				onClick="var o=document.frm.rother;o.disabled=true;o.value='';" /><label for="reff1">a Friend</label><br>
			<input id="reff2" name="reff" type="radio" value="table"
				onClick="var o=document.frm.rother;o.disabled=true;o.value='';" /><label for="reff2">at a poker table</label><br>
			<input id="reff3" name="reff" type="radio" value="google"
				onClick="var o=document.frm.rother;o.disabled=true;o.value='';" /><label for="reff3">from a Google Ad</label><br>
			<input id="reff4" name="reff" type="radio" value="site"
				onClick="var o=document.frm.rother;o.disabled=true;o.value='';" /><label for="reff4">from another site</label><br>
			<input id="reff5" name="reff" type="radio" value=""
				onClick="document.frm.rother.disabled=false;"/><label for="reff5">other: </label><input name="rother" id="rother" type="text" disabled="disabled" />
		</td>
	</tr>
    <tr>
	   		<td colspan="2">Please read <em>carefully</em> our <a href="EULA.php" target="_blank">End User Licence Agreement (<strong>EULA</strong>)</a> first.<td>
	</tr>
	<tr>
	   		<td colspan="2"><input type="checkbox" name="agree" value="yes" id="agree" /> <label for="agree"><strong>Yes, I agree to EULA</strong></label>
	   		</td>
   	</tr>
    <tr>
        <td colspan="2" align="right">
			<br /><input type="image" src="/images/continue.jpg" width="162" height="29" border="0" />
        </td>
    </tr>
</table>

</form>

</div>
<div id="center2">

	<p> <strong>If you need help making your decision, please try our <a href="http://www.statsforpoker.com/try.php">"Free Sample Searches"</a>. You may also e-mail if
you have additional questions. </strong></p>
	<p>We will return your money within 30 days of purchase if you are unhappy for any reason.</p>
	<p>&nbsp;</p>
	<p>&nbsp;</p>
</div>

										</div>
								</div>
<? include("sidebar.php"); ?>
								<div
class="clear"></div>
							</div>
						</div>

<?
	include("footer.php");
?>