/**
* page code function
*/
function PageCompPageMainCode()
{
global $site;
global $dir;
global $tmpl;
global $page;
global $join_page_check_limit;
global $join_pages_num;
global $p_arr;
global $_page;
global $en_aff;
global $oTemplConfig;
global $newusernotify;
$enable_security_image = getParam('enable_security_image');
$autoApproval_ifJoin = isAutoApproval('join');
ob_start();
switch ($page) {
// fill inputs with values from precede join pages
case $page > 1:
$hidden_vals = '';
// inputs with POST values
$respd = db_res("SELECT * FROM ProfilesDesc WHERE `visible` & 2 AND ( FIND_IN_SET('0',show_on_page) OR FIND_IN_SET('" . (int) $_page['name_index'] . "',show_on_page)) {$join_page_check_limit} ORDER BY `order` ASC");
while ($arrpd = mysql_fetch_array($respd)) {
$fname = get_input_name($arrpd);
switch ($arrpd['type']) {
case 'set':
// set of checkboxes
$vals = preg_split("/[,\\']+/", $arrpd['extra'], -1, PREG_SPLIT_NO_EMPTY);
$p_arr[$fname] = '';
foreach ($vals as $v) {
if (strlen(trim($v)) <= 0) {
continue;
}
$hidden_vals .= '<input type="hidden" name="' . ($fname . "_" . $v) . '" value="' . process_pass_data($_POST[$fname . "_" . $v]) . '">';
$p_arr[$fname . "_" . $v] = process_pass_data($_POST[$fname . "_" . $v]);
if ($_POST[$fname . "_" . $v] == 'on') {
if (strlen($p_arr[$fname])) {
$p_arr[$fname] .= ",{$v}";
} else {
$p_arr[$fname] .= $v;
}
}
}
break;
case 'date':
$p_arr[$fname] = sprintf("%04d-%02d-%02d", (int) $_POST[$fname . '_year'], (int) $_POST[$fname . '_month'], (int) $_POST[$fname . '_day']);
$hidden_vals .= '<input type="hidden" name="' . $fname . '_year" value="' . (int) $_POST[$fname . '_year'] . '" />';
$hidden_vals .= '<input type="hidden" name="' . $fname . '_month" value="' . (int) $_POST[$fname . '_month'] . '" />';
$hidden_vals .= '<input type="hidden" name="' . $fname . '_day" value="' . (int) $_POST[$fname . '_day'] . '">';
break;
default:
if ($arrpd['get_value']) {
$funcbody = $arrpd['get_value'];
$func = create_function('$arg0', $funcbody);
$hidden_vals .= '<input type="hidden" name="' . $fname . '" value="' . process_pass_data($_POST[$fname]) . '">';
$p_arr[$fname] = process_pass_data($func($_POST));
} else {
$hidden_vals .= '<input type="hidden" name="' . $fname . '" value="' . process_pass_data($_POST[$fname]) . '">';
$p_arr[$fname] = process_pass_data($_POST[$fname]);
}
break;
}
}
// check values
$query = "SELECT * FROM ProfilesDesc\n\t\t\t\tWHERE `visible` & 2 AND ( FIND_IN_SET('0',show_on_page) OR FIND_IN_SET('" . (int) $_page['name_index'] . "',show_on_page)) {$join_page_check_limit}\n\t\t\t\tORDER BY `join_page` ASC";
$respd = db_res($query);
while ($arrpd = mysql_fetch_array($respd)) {
if (!strlen($arrpd['check'])) {
continue;
}
$fname = get_input_name($arrpd);
$funcbody = $arrpd[check];
$func = create_function('$arg0', $funcbody);
if (!$func($p_arr[$fname])) {
$add_on .= report_err(_t($arrpd['because'], $arrpd['min_length'], $arrpd['max_length']));
}
}
$page = !$add_on ? $page : $page - 1;
break;
break;
case 'done':
// fill array with POST values
$respd = db_res("SELECT * FROM ProfilesDesc WHERE `visible` & 2 AND ( FIND_IN_SET('0',show_on_page) OR FIND_IN_SET('" . (int) $_page['name_index'] . "',show_on_page)) {$join_page_check_limit} ORDER BY `order` ASC");
while ($arrpd = mysql_fetch_array($respd)) {
$fname = get_input_name($arrpd);
switch ($arrpd['type']) {
case 'set':
// set of checkboxes
$vals = preg_split("/[,\\']+/", $arrpd['extra'], -1, PREG_SPLIT_NO_EMPTY);
$p_arr[$fname] = '';
foreach ($vals as $v) {
if (strlen(trim($v)) <= 0) {
continue;
}
$hidden_vals .= '<input type="hidden" name="' . ($fname . "_" . $v) . '" value="' . process_pass_data($_POST[$fname . "_" . $v]) . '">';
$p_arr[$fname . "_" . $v] = process_pass_data($_POST[$fname . "_" . $v]);
if ($_POST[$fname . "_" . $v] == 'on') {
if (strlen($p_arr[$fname])) {
$p_arr[$fname] .= ",{$v}";
} else {
$p_arr[$fname] .= $v;
}
}
}
break;
case 'date':
$p_arr[$fname] = sprintf("%04d-%02d-%02d", (int) $_POST[$fname . '_year'], (int) $_POST[$fname . '_month'], (int) $_POST[$fname . '_day']);
$hidden_vals .= '<input type="hidden" name="' . $fname . '_year" value="' . (int) $_POST[$fname . '_year'] . '" />';
$hidden_vals .= '<input type="hidden" name="' . $fname . '_month" value="' . (int) $_POST[$fname . '_month'] . '" />';
$hidden_vals .= '<input type="hidden" name="' . $fname . '_day" value="' . (int) $_POST[$fname . '_day'] . '">';
break;
default:
if ($arrpd['get_value']) {
$funcbody = $arrpd['get_value'];
$func = create_function('$arg0', $funcbody);
$hidden_vals .= '<input type="hidden" name="' . $fname . '" value="' . process_pass_data($_POST[$fname]) . '">';
$p_arr[$fname] = process_pass_data($func($_POST));
} else {
$hidden_vals .= '<input type="hidden" name="' . $fname . '" value="' . process_pass_data($_POST[$fname]) . '">';
$p_arr[$fname] = process_pass_data($_POST[$fname]);
}
break;
}
}
// check values
if ($enable_security_image) {
if (!isset($_POST['securityImageValue']) || !isset($_COOKIE['strSec']) || md5($_POST['securityImageValue']) != $_COOKIE['strSec']) {
$page = $join_pages_num;
$add_on .= report_err(_t("_SIMG_ERR"));
}
}
$respd = db_res("SELECT * FROM ProfilesDesc WHERE `visible` & 2 AND ( FIND_IN_SET('0',show_on_page) OR FIND_IN_SET('" . (int) $_page['name_index'] . "',show_on_page)) {$join_page_check_limit} AND `join_page` > 0 ORDER BY `order` ASC");
while ($arrpd = mysql_fetch_array($respd)) {
if (!strlen(trim($arrpd['check']))) {
continue;
}
$fname = get_input_name($arrpd);
$funcbody = $arrpd['check'];
$func = create_function('$arg0', $funcbody);
if (!$func($p_arr[$fname])) {
$page = floor($arrpd['join_page'] / 1000);
$add_on .= report_err(_t($arrpd['because'], $arrpd['min_length'], $arrpd['max_length']));
}
}
break;
default:
break;
}
switch ($page) {
default:
global $tmpl;
if ($oTemplConfig->customize['join_page']['showPageText']) {
$page_text = _t("_JOIN1", $page);
}
echo $add_on;
break;
}
switch ($page) {
case 'done':
// new profile creation
$cl_values = "INSERT INTO `Profiles` SET ";
$cl_first = 0;
$respd = db_res("SELECT * FROM ProfilesDesc WHERE `visible` & 2 AND `to_db` = 1 AND ( FIND_IN_SET('0',show_on_page) OR FIND_IN_SET('" . (int) $_page['name_index'] . "',show_on_page)) {$join_page_check_limit} ORDER BY `order` ASC");
while ($arrpd = mysql_fetch_array($respd)) {
$fname = get_input_name($arrpd);
$dbname = get_field_name($arrpd);
$fval = $p_arr[$fname];
if ($dbname == 'zip') {
$fval = strtoupper(str_replace(' ', '', $fval));
}
switch ($arrpd['type']) {
case 'set':
// set of checkboxes
// set of checkboxes
case 'r':
// reference to array for combo box
// reference to array for combo box
case 'a':
// text Area
// text Area
case 'c':
// input box
// input box
case 'rb':
// radio buttons
// radio buttons
case 'e':
// enum combo box
// enum combo box
case 'en':
// enum combo box with numbers
// enum combo box with numbers
case 'eny':
// enum combo box with numbers
// enum combo box with numbers
case 'date':
// date
$fval = process_db_input($fval, 0, 1);
$cl_values .= " `{$dbname}` = '{$fval}'";
$cl_values .= ", ";
break;
case 'p':
$fval = md5(process_pass_data($fval));
$cl_values .= " `{$dbname}` = '{$fval}'";
$cl_values .= ", ";
break;
}
}
$cl_values .= " `LastReg` = NOW()";
db_res($cl_values);
$IDnormal = mysql_insert_id();
$IDcrypt = crypt($IDnormal, "secret_string");
// encrypted ID for security purposes
setcookie("IDc", $IDcrypt, 0, "/");
$_COOKIE['IDc'] = $IDcrypt;
// Affiliate and friend checking
if ($en_aff && $_COOKIE['idAff']) {
$res = db_res("SELECT `ID` FROM `aff` WHERE `ID` = {$_COOKIE['idAff']} AND `Status` = 'active'");
if (mysql_num_rows($res)) {
$res = db_res("INSERT INTO `aff_members` (`idAff`,`idProfile`) VALUES ({$_COOKIE['idAff']}, {$IDnormal})");
}
}
if ($en_aff && $_COOKIE['idFriend']) {
$idFriend = getID($_COOKIE['idFriend']);
if ($idFriend) {
$res = db_res("UPDATE `Profiles` SET `aff_num` = `aff_num` + 1 WHERE `ID` = '{$idFriend}'");
createUserDataFile($idFriend);
}
}
if (strcmp(crypt($IDnormal, 'secret_string'), $_COOKIE['IDc']) != 0) {
ob_end_clean();
$_page['header'] = _t("_Error");
$ret = "<table width=\"100%\" cellpadding=4 cellspacing=4><tr><td align=center class=text2>";
$ret .= _t("_MUST_HAVE_COOKIES");
$ret .= "</td></tr></table>";
return $ret;
}
if (getParam('autoApproval_ifNoConfEmail') == 'on') {
if (getParam('autoApproval_ifJoin')) {
db_res("UPDATE `Profiles` SET `Status`='Active' WHERE `ID`='{$IDnormal}'");
$page_text = _t("_USER_ACTIVATION_SUCCEEDED") . $ret . $add_on;
$message = getParam("t_Activation");
$subject = getParam('t_Activation_subject');
sendMail($p_arr['Email'], $subject, $message, $IDnormal);
} else {
db_res("UPDATE `Profiles` SET `Status`='Approval' WHERE `ID`='{$IDnormal}'");
$page_text = _t("_USER_CONF_SUCCEEDED") . $add_on;
}
if ($newusernotify) {
$message = "New user {$p_arr['NickName']} with email {$p_arr['Email']} has been confirmed,\nhis/her ID is {$IDnormal}.\n--\n{$site['title']} mail delivery system\n<Auto-generated e-mail, please, do not reply>\n";
$subject = "New user confirmed";
sendMail($site['email_notify'], $subject, $message);
}
} else {
$page_text = _t("_JOIN3") . $add_on;
$page_text .= activation_mail($IDnormal);
$page_text .= "<br /><br /><br /><br /><center>" . _t("_UPLOAD_WHILE_WAITING", $site['url']) . "</center>";
}
modules_add($IDnormal);
if (!$autoApproval_ifJoin) {
modules_block($IDnormal);
}
createUserDataFile($IDnormal);
// ----------------------------------------------------------
echo "<div id=\"first_column\">";
echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td align=center class=text2>";
echo "<div align=justify>{$page_text}</div>";
break;
default:
echo "<div id=\"first_column\">";
echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td align=center class=text2>";
//-----------------------------------------------------------
do {
$join_page_limit = 'done' == $page ? " AND join_page > '" . $join_pages_num * 1000 . "'" : " AND join_page > '" . $page * 1000 . "' AND join_page < '" . ($page + 1) * 1000 . "'";
$query = "SELECT COUNT(*) FROM `ProfilesDesc` WHERE `visible` & 2 {$join_page_limit} AND (FIND_IN_SET('0',show_on_page) OR FIND_IN_SET('3',show_on_page))";
$res = db_res($query);
$item_num = mysql_fetch_row($res);
if ($item_num[0] <= 0 && $page < $join_pages_num) {
$page++;
}
} while ($item_num[0] <= 0 && $page < $join_pages_num);
$join_page_limit = 'done' == $page ? " AND join_page > '" . $join_pages_num * 1000 . "'" : " AND join_page > '" . $page * 1000 . "' AND join_page < '" . ($page + 1) * 1000 . "'";
$hidden_vals .= "<input type=\"hidden\" name=\"page\" value=\"{$page}\" />";
//-----------------------------------------------------------
echo "\n\t <form name=\"jform\" method=\"post\" action=\"{$_SERVER['PHP_SELF']}\" " . ($join_pages_num == $page ? "onSubmit=\"return validateJoinForm();\">" : ">") . "\n\n\t {$hidden_vals}\n\n\t <input type=hidden name=\"ID\" value=\"{$IDnormal}\" />\n\n\t <div align=justify>{$page_text}</div>\n<table width=\"100%\" cellspacing=\"2\" cellpadding=\"0\" border=\"0\">";
$first_row = 1;
$respd = db_res("SELECT * FROM ProfilesDesc\n\t\t\t WHERE `visible` & 2 AND ( FIND_IN_SET('0',show_on_page) OR FIND_IN_SET('" . (int) $_page['name_index'] . "',show_on_page)) {$join_page_limit}\n\t\t\t ORDER BY `join_page` ASC");
if ($oTemplConfig->customize['join_page']['show_3rd_col']) {
$columns = 3;
} else {
$columns = 2;
}
while ($arrpd = mysql_fetch_array($respd)) {
$fname = get_input_name($arrpd);
if ($arrpd['get_value'] && $arrpd['to_db'] == 0) {
$funcbody = $arrpd['get_value'];
$func = create_function('$arg0', $funcbody);
$p_arr[$fname] = $func($p_arr);
}
$not_first_row = 0;
switch ($arrpd['type']) {
case 'set':
// set of checkboxes
echo print_row_set($first_row, $arrpd, $p_arr[$fname], "table", 0, $columns);
break;
case 'rb':
// radio buttons
echo print_row_radio_button($first_row, $arrpd, $p_arr[$fname], "table", 0, $columns);
break;
case 'r':
// reference to array for combo box
if ($fname == 'Country') {
$onchange = "flagImage = document.getElementById('flagImageId'); flagImage.src = '{$site['flags']}' + this.value.toLowerCase() + '.gif';";
if (strlen($p_arr[$fname]) == 0) {
$p_arr[$fname] = getParam('default_country');
}
$imagecode = '<img id="flagImageId" src="' . ($site['flags'] . strtolower($p_arr[$fname])) . '.gif" alt="flag" />';
} else {
$onchange = '';
$imagecode = '';
}
echo print_row_ref($first_row, $arrpd, $p_arr[$fname], "table", 0, $columns, '', 0, $onchange, $imagecode);
break;
case '0':
// divider
echo print_row_delim($first_row, $arrpd, "panel", $columns);
$not_first_row = 1;
$first_row = 1;
break;
case 'e':
// enum combo box
echo print_row_enum($first_row, $arrpd, $p_arr[$fname], "table", $javascript, 0);
break;
case 'en':
// enum combo box with numbers
echo print_row_enum_n($first_row, $arrpd, $p_arr[$fname], "table", 0, $columns);
break;
case 'eny':
// enum combo box with years
echo print_row_enum_years($first_row, $arrpd, $p_arr[$fname], "table", 0, $columns);
break;
case 'date':
//date
echo print_row_date($first_row, $arrpd, $p_arr[$fname], "table", 0, $columns);
break;
case 'a':
// text Area
echo print_row_area($first_row, $arrpd, $p_arr[$fname], "table", 0, $columns);
break;
case 'c':
// input box
echo print_row_edit($first_row, $arrpd, $p_arr[$fname], "table", 0, $columns);
break;
case 'p':
// input box password
echo print_row_pwd($first_row, $arrpd, $p_arr[$fname], "table", 0, $columns);
break;
default:
$not_first_row = 1;
break;
}
if (!$not_first_row && $first_row == 1) {
$first_row = 0;
}
}
echo "</table>";
// show on the last page of join form
if ($join_pages_num == $page) {
?>
<script language=javascript>
<!--
function validateJoinForm()
{
if ( document.forms['jform'].elements['i_agree'].checked ) return true;
alert('<?php
echo _t("_CLICK_AGREE");
?>
');
return false;
}
-->
</script>
<?php
echo "<br /><div class=\"security_image_block\"><center>\n";
if ($enable_security_image) {
echo "\n\t\t <img alt=\"Security Image\" src=\"simg/simg.php\" /><br /><br />" . _t("_Enter what you see:") . "<input name=\"securityImageValue\" type=\"text\" size=\"15\"><br /><br />";
}
echo "</center>";
$ret = <<<ID
\t\t<script type="text/javascript">
\t\t\tfunction id_registration()
\t\t\t{
\t\t\t\toCheckBox = document.getElementById( "boonex_id" );
\t\t\t\tif( oCheckBox.checked )
\t\t\t\t\twindow.open( 'http://www.boonex.com/id/', '', 'width=800, height=600, menubar=yes, status=yes, resizable=yes, scrollbars=yes, toolbar=yes, location=yes')
\t\t\t}
\t\t</script>
ID;
echo $ret;
echo "\n\t\t <div style=\"text-align:center;\"><input type=checkbox name=i_agree id=i_agree /><label for=i_agree>" . _t("_I AGREE", $site['url']) . "</label> </div>\n";
// BoonEx ID implementation
// <div style=\"text-align:center;\"><input type=checkbox name=\"boonex_id\" id=\"boonex_id\" /><label for=boonex_id>" . _t("_ID_CREATE", "http://www.boonex.com/id/" ) . "</label> </div>";
}
echo "<br /><center><input onclick=\"id_registration();\" type=\"submit\" value=\"" . _t("_Join") . "\" /></center></form></div>";
break;
}
global $memberID;
echo "</td></tr></table>";
echo "</div>";
echo "<div id=\"second_column\">";
echo "<div class=\"member_login\">";
$action = "login";
$text = _t('_Member Login');
$table = "Profiles";
$login_page = "{$site['url']}member.php";
$join_page = "{$site['url']}join_form.php";
$forgot_page = "{$site['url']}forgot.php";
$template = "{$dir['root']}templates/tmpl_{$tmpl}/join_login_form.html";
echo LoginForm($text, $action, $table, $login_page, $forgot_page, $template);
echo "</div>";
if (getParam('enable_get_boonex_id')) {
echo "<div class=\"import_boonex_id\">";
$action = "boonex";
$text = '<div class="boonex_id">' . _t('_Import BoonEx ID') . '</div>';
$table = "Profiles";
$login_page = "{$site['url']}member.php";
$join_page = "{$site['url']}join_form.php";
$forgot_page = '';
$template = "{$dir['root']}templates/tmpl_{$tmpl}/join_login_form.html";
echo LoginForm($text, $action, $table, $login_page, $forgot_page, $template);
echo "</div>";
}
echo "</div>";
$ret = ob_get_clean();
return $ret;
}
$add_on = '';
}
if (trim($add_on) == '') {
$collge = mysql_fetch_assoc(mysql_query("select * from City where Title = '" . mysql_escape_string(trim($_POST['city'])) . "'"));
if (intval($collge['ID']) > 0) {
$collgeid = intval($collge['ID']);
} else {
mysql_query("insert into City set Title='" . mysql_escape_string(trim($_POST['city'])) . "'");
$collgeid = mysql_insert_id();
}
$cl_values = "INSERT INTO `Profiles` SET \n\t\t\t\t\t\tLastModified=" . time() . ",\n\t\t\t\t\t\tStatus='Active',\n\t\t\t\t\t\tNickName='" . mysql_escape_string($_POST['NickName']) . "',\t\t\t\t\t\t\n\t\t\t\t\t\tEmail='" . mysql_escape_string($_POST['Email']) . "',\t\t\t\t\t\t\t\n\t\t\t\t\t\tPassword='******'Password1']) . "', \n\t\t\t\t\t\tzip='" . mysql_escape_string($_POST['Zip']) . "',\n\t\t\t\t\t\tfname='" . mysql_escape_string($_POST['fname']) . "',\n\t\t\t\t\t\tlname='" . mysql_escape_string($_POST['lname']) . "',\n\t\t\t\t\t\tcity=" . $collgeid . ",\n\t\t\t\t\t\t{$Photo}\t\t\n\t\t\t\t\t\tintro='" . mysql_escape_string($_POST['intro']) . "',\n\t\t\t\t\t\tnote='" . mysql_escape_string($_POST['note']) . "',\n\t\t\t\t\t\taltemail='" . mysql_escape_string($_POST['altemail']) . "',\n\t\t\t\t\t\tphone='" . mysql_escape_string($_POST['phone']) . "',\n\t\t\t\t\t\tcell='" . mysql_escape_string($_POST['cell']) . "',\n\t\t\t\t\t\taim='" . mysql_escape_string($_POST['aim']) . "',\n\t\t\t\t\t\tskype='" . mysql_escape_string($_POST['skype']) . "' \t,\n\t\t\t\t\t\tphone_none='" . intval($_POST['phone_none']) . "',\n\t\t\t\t\t\tcell_none='" . intval($_POST['cell_none']) . "',\n\t\t\t\t\t\taim_none='" . intval($_POST['aim_none']) . "',\n\t\t\t\t\t\taltemail_none='" . intval($_POST['altemail_none']) . "',\n\t\t\t\t\t\tskype_none='" . intval($_POST['skype_none']) . "' ,\n\t\t\t\t\t\tLastReg = NOW()";
mysql_query($cl_values);
$IDnormal = mysql_insert_id();
if ($IDnormal > 0) {
if (!$_FILES['Photo'] or empty($_FILES['Photo'])) {
$add_on .= report_err('File not uploaded');
} else {
if ($_FILES['Photo']['error'] != 0) {
$sActionText = 'File upload error<br>';
} else {
$aFileInfo = getimagesize($_FILES['Photo']['tmp_name']);
if (!$aFileInfo) {
$sActionText = 'You uploaded not image file<br>';
} else {
$ext = false;
switch ($aFileInfo['mime']) {
case 'image/jpeg':
$ext = 'jpg';
break;
case 'image/gif':
$ext = 'gif';
/**
* page code function
*/
function PageCompPageMainCode()
{
global $site;
ob_start();
$min_nick = 2;
$max_nick = 10;
$min_passwd = 4;
$max_passwd = 8;
$page = $_POST[page];
$Name = $_POST[Name];
$Email = $_POST[Email];
$Email2 = $_POST[Email2];
$Pwd1 = $_POST[Password1];
$Pwd2 = $_POST[Password2];
switch ($page) {
case 2:
if (!isset($_POST['securityImageValue']) || !isset($_COOKIE['strSec']) || md5($_POST['securityImageValue']) != $_COOKIE['strSec']) {
$add_on .= report_err(_t("_SIMG_ERR"));
$page = 1;
}
if (strlen($Name) > 10 || strlen($Name) < 2) {
$add_on .= report_err(_t("_NICK_LEAST2", $min_nick, $max_nick));
$page = 1;
}
if (!strcmp($Email, $Email2) && (!eregi("^[_\\.0-9a-z-]+@([0-9a-z][0-9a-z-]+\\.)+[a-z]{2,4}\$", $Email) || db_arr("SELECT ID FROM aff WHERE UPPER(email) = UPPER('{$Email}')"))) {
$add_on .= report_err(_t("_EMAIL_INVALID_AFF"));
$page = 1;
}
if (!(strlen($Pwd1) >= 4 && strlen($Pwd1) <= 10 && !strcmp($Pwd1, $Pwd2))) {
$add_on .= report_err(_t("_PWD_INVALID2", $min_passwd, $max_passwd));
$page = 1;
}
break;
}
switch ($page) {
case 2:
$page_text = _t("_JOIN_AFF2", $site['url_aff'], $site['title']);
break;
default:
$page_text = _t("_JOIN1_AFF") . $add_on;
break;
}
switch ($page) {
case 2:
// new profile creation
$cl_values = "INSERT INTO aff SET ";
$seed = rand();
$cl_values .= " `seed` = " . $seed;
$cl_values .= ", `RegDate` = NOW()";
$cl_values .= ", `Percent` = 10 ";
$cl_values .= ", `Status` = 'active' ";
$cl_values .= ", `Name` = '{$Name}' ";
$cl_values .= ", `email` = '{$Email}' ";
$cl_values .= ", `Password` = '" . md5($Pwd1) . "' ";
$create_result = db_res($cl_values);
if ($create_result) {
$arr = db_arr("SELECT ID FROM aff WHERE `seed` = {$seed}");
if ($arr) {
db_res("UPDATE aff SET `seed` = 0 WHERE ID = {$arr['ID']}");
}
$ID_New_Aff = $arr[ID];
}
echo "<table width=\"100%\" cellpadding=4 cellspacing=4><td align=center class=text2>";
echo "<div align=justify>{$page_text}</div>";
echo "<div align=justify>" . _t("_JOIN_AFF_ID", $ID_New_Aff) . "</div>";
break;
default:
echo "<table width=\"100%\" cellpadding=4 cellspacing=4><td align=center class=text2>";
?>
<form method=post action="<?php
echo $_SERVER[PHP_SELF];
?>
">
<input type=hidden name=page value=2>
<div align=justify><?php
echo $page_text;
?>
</div>
<br /><br />
<table width=100% cellspacing=1 cellpadding=3 class=text>
<tr class=table>
<td width=30%><b><?php
echo _t("_Name");
?>
</b></td>
<td width=40%><input class=no type=text size=40 name="Name" value="<?php
echo $Name;
?>
"></td>
<td width=30%><?php
echo _t("_chars_to_chars", $min_nick, $max_nick);
?>
</td>
</tr>
<tr><td><br /></td></tr>
<tr class=table>
<td width=30%><b><?php
echo _t("_E-mail");
?>
</b></td>
<td width=40%><input class=no type=text size=40 name="Email" value="<?php
echo $Email;
?>
"></td>
<td width=30%><?php
echo _t("_Must be valid");
?>
</td>
</tr>
<tr class=table>
<td width=30%><b><?php
echo _t("_Confirm E-mail");
?>
</b></td>
<td width=40%><input class=no type=text size=40 name="Email2"></td>
<td width=30%><?php
echo _t("_Confirm your e-mail");
?>
</td>
</tr>
<tr><td><br /></td></tr>
<tr class=table>
<td width=30%><b><?php
echo _t("_Password");
?>
</b></td>
<td width=40%><input class=no type=password size=40 name="Password1" value=""></td>
<td width=30%></td>
</tr>
<tr class=table>
<td width=30%><b><?php
echo _t("_Confirm password");
?>
</b></td>
<td width=40%><input class=no type=password size=40 name="Password2" value=""></td>
<td width=30%><?php
echo _t("_Confirm your password");
?>
</td>
</tr>
</table>
<br /><center>
<img alt="Security Image" src="simg/simg.php" /><br /><br />
<?php
echo _t("_Enter what you see:");
?>
<input name="securityImageValue" type="text" size="15" ><br /><br />
<input class=no type="submit" value="<?php
echo _t("_Submit");
?>
" class="text"></center></form>
<?php
break;
}
echo "</td></table>";
$ret = ob_get_clean();
return $ret;
}
