<?php check_login(); include SITEDIR . '/includes/navLeftSideVars.php'; if (!empty($_REQUEST['cty'])) { $status = 0; $insertSQL = sprintf("INSERT INTO geo_city_owners (cty_id, owner_id, expiry_date, subs_expiry_date, status) VALUES (%s, %s, %s, %s, %s)", GetSQLValueString($_REQUEST['cty'], "int"), GetSQLValueString($_SESSION['user']['id'], "text"), GetSQLValueString(date('Y-m-d H:i:s', strtotime("+1 month")), "date"), GetSQLValueString(date('Y-m-d H:i:s', strtotime("+1 year")), "date"), GetSQLValueString($status, "int")); mysql_select_db($database_connMain, $connMain); $Result1 = mysql_query($insertSQL, $connMain) or die(mysql_error()); $insertGoTo = $currentURL; header(sprintf("Location: %s", $insertGoTo)); exit; } //getting owern information $Models_Geo = new Models_Geo(); $ownerDetails = $Models_Geo->getOwnerDetails($city_id, 0); if (!empty($ownerDetails)) { header("Location: " . $currentURL); exit; } ?> <h1><?php echo $pageTitle; ?> </h1> <p>Apply For City Moderator</p> <form action="<?php echo PAYPAL_URL; ?> " method="post">
function check_city_owner_bk($city_id, $user_id) { $Models_Geo = new Models_Geo(); $ownerDetails = $Models_Geo->getOwnerDetails($city_id, 0); if ($ownerDetails['owner_id'] != $user_id) { throw new Exception('Invalid Owner'); } if ($ownerDetails['status'] != 1) { throw new Exception('Ownership not active'); } if (strtotime($ownerDetails['expiry_date']) < time()) { throw new Exception('Ownership expired'); } if (strtotime($ownerDetails['subs_expiry_date']) < time()) { throw new Exception('Subscription expired'); } }