//die(count($values).print_r($values).$RunExtra);
$ComData = AddMember($values, $RunExtra);
$ComParts = explode("**",$ComData);
CheckAdminEmail("register","register", $values, "-**1");
$sql = "SELECT members.id, members.email, members_privacy.SMS_number, members_data.gender AS genderD, package.name, package.wink, package.Highlighted, package.Featured, package.maxMessage, members.moderator, package.maxFiles, members.active, members.ip_long, members.ip_lat, members.ip_country, members.ip_code, members.id, members.activate_code, members.username, members.packageid, members.lastlogin, members_privacy.Language FROM members
INNER JOIN members_privacy ON ( members.id = members_privacy.uid )
LEFT JOIN members_data ON ( members.id = members_data.uid )
LEFT JOIN package ON ( members.packageid = package.pid )
WHERE members.id = '".$ComParts[0]."' LIMIT 1";
$values = $DB->Row($sql);
setSession($values, 0, 0);
$values['id'] = $ComParts[0];
$values['password'] = $ComParts[1];
$values['packageid'] = DEFAULT_PACKAGE;
$values['custom'] = $ComParts[2];
$D1 = $DB->Row("SELECT value1 FROM system_settings WHERE name='welcome_email' LIMIT 1");
SendTemplateMail($values, $D1['value1']);
$_SESSION['my_email'] =$values['email']; // used for activation account
$DB->Insert("INSERT INTO `album` ( `aid` , `uid` , `title` , `comment` , `filecount` , `cat` , `allow_f` , `allow_h` , `allow_n` , `allow_a`,password, time, date )
VALUES (NULL , '".$_SESSION['uid']."', '".$_SESSION['username']." Album', '', '0', 'public', '0', '0', '0', '0','',now(),now())");
$albumID = $DB->InsertID();
if(!isset($values['aid'])){ $values['aid']="new";} if( ( $value['error'] !=4 ) && is_array($Files["uploadFile0".$UploadMax]) && $Files["uploadFile0".$UploadMax]['type'] !="" ){ // error 4 = empty file
$Status = UploadFile($Files["uploadFile0".$UploadMax], $_SESSION['uid'], strip_tags($values['title']), strip_tags($values['comments']), 1, 'photo', $albumID,'no'); }
$UploadMax++; }
$D2 = $DB->Row("SELECT value2 FROM system_settings WHERE name='welcome_message' LIMIT 1");
$D3 = $DB->Row("SELECT value1 FROM system_settings WHERE name='welcome_subject' LIMIT 1");
$Subject = str_replace("(username)",$_SESSION['username'],$D3['value1']);
$Subject = str_replace("(password)",$ComParts[1],$Subject);
$Subject = str_replace("(code)",$ComParts[2],$Subject);
$Message = str_replace("(username)",$_SESSION['username'],$D2['value2']);
$Message = str_replace("(password)",$ComParts[1],$Message);
$Message = str_replace("(code)",$ComParts[2],$Message);
$DB->Insert("INSERT INTO `messages` ( `uid` , `mailnum` , `mail2id` , `mailstatus` , `maildate` , `mailtime` , `mail_subject` , `mail_message` , `mail_displayalert`, my_box, to_box )
VALUES ('0', NULL , '".$_SESSION['uid']."', 'unread', NOW(), NOW(), '".emInput($Subject)."', '".emInput($Message)."', '1', 'sent', 'inbox')");
$ReturnValue = RegisterCompleteRedirect();
return $ReturnValue;
} break;
}
} break;
case "email_contacts": {
if($values['totalrows'] > 1 ){
$Counter=0;
for($i = 1; $i < $values['totalrows']; $i++) {
if(isset($values['email'. $i])){
$data['username'] = $values['name'. $i];
$data['from_username'] = $_SESSION['username'];
$data['email'] = $values['email'. $i];
SendTemplateMail($data, 12);
$Counter++;
}
}
$Counter++;
}
return RegisterCompleteRedirect();
} break;
case "forward": {
return RegisterCompleteRedirect();
} break;
}
}
return "Balllls!!".$DoCall."-".$SwitchValue;
}
function AddMember($data, $extra){
global $DB;
$user = str_replace(" ", "", strip_tags($data['username']));
$email = str_replace(" ", "", strip_tags($data['email']));
$pass = str_replace(" ", "", strip_tags($data['password']));
$default_CC ="United States";
$MSGSTATUS= D_STATUSMSG;
$ip = $_SERVER['REMOTE_ADDR'];
$session = session_id();
$reg_long = $_SESSION['clever_ip_long'];
$reg_lat = $_SESSION['clever_ip_lat'];
$member_Package_id = DEFAULT_PACKAGE;
if(APPROVE_ACCOUNTS == "yes"){
$status = "unapproved";
}else{ $status = "active"; }
$packageData = $DB->Row("SELECT * FROM package WHERE pid='".$member_Package_id."' LIMIT 1");
// GEOIP SYSTEM DETECTION //
$reg_long=""; $reg_lat=""; $reg_country=""; $reg_code="";
if(!isset($_SESSION['clever_ip_country']) && MAPS_ID !="" && GOOGLE_MAPS_KEY !=""){
$exe_data = explode(",",ValidateExternalCountry($_SERVER['REMOTE_ADDR']));
if(is_array($exe_data) && $exe_data != 0){
$reg_long=$exe_data[4]; $reg_lat=$exe_data[3]; $reg_country=$exe_data[2]; $reg_code=$exe_data[0];
}
}elseif( isset($_SESSION['clever_ip_long']) ){
$reg_long = $_SESSION['clever_ip_long'];
$reg_lat = $_SESSION['clever_ip_lat'];
$reg_country = $_SESSION['clever_ip_country'];
$reg_code = $_SESSION['clever_ip_code'];
$default_CC = $_SESSION['clever_ip_country_name'];
}elseif(isset($data['country'])){
$reg_country = $data['country'];
$default_CC =$data['country'];
}
if(D_MD5 ==1){
$passcode = md5($pass);
}else{
$passcode = $pass;
}
$DB->Insert("INSERT INTO `members` ( `id` , `username` , `password` , `email` , `session` , `ip` , `lastlogin` , `visible` , active, `created`, packageid, hits, profile_complete, templateid, updated, moderator, activate_code, highlight, ip_long, ip_lat, ip_country, ip_code,member_rating, msgStatus, video_duration, video_live )
VALUES (NULL , '".$user."', '".$passcode."', '".$email."', '".$session."', '".$ip."', '".DATE_TIME."', 'yes', '".$status."', '".DATE_TIME."', '".$member_Package_id."','0','0','1','".DATE_TIME."', 'no', 'OK','off','".$reg_long."','".$reg_lat."','".$reg_country."','".$reg_code."', '0','".emInput($MSGSTATUS)."','0','no')");
$userid = $DB->InsertID();
if(VALIDATE_EMAIL ==1){
$ACTIVATION_CODE = makeRandomPassword(9);
if($ACTIVATION_CODE ==""){ $ACTIVATION_CODE = makeRandomPassword(9); }
$DB->Insert("UPDATE members SET activate_code ='".$ACTIVATION_CODE."' WHERE id= ( '".$userid."' ) LIMIT 1");
//---------------------
}
$DB->Insert("INSERT INTO `members_data` ( `uid` ) values ( '$userid' )");
$DB->Update("UPDATE `members_data` SET age='1974-JAN-15', country='".emInput($default_CC)."', headline='' WHERE uid='".$userid."' LIMIT 1"); // make default values
if(isset($data['news']) && $data['news'] =="yes"){ $nw ="yes"; }else{ $nw ="no";}
if(isset($data['notify']) && $data['notify'] =="yes"){ $nn ="yes"; }else{ $nn ="no";}
if(UPGRADE_SMS =="yes"){
$SMS_NUM=$data['smsnum'];$SMS_MSG=$data['sms_msg_alert'];$SMS_EMAIL=$data['sms_wink_alert'];}else{$SMS_NUM="";$SMS_MSG="";$SMS_EMAIL="";
}
$DB->Insert("INSERT INTO `members_privacy` (`uid` ,`Newsletters` ,`Notifications` ,`IM` ,`Language` ,`Time Zone` ,`friends` ,`comments` ,`profile_view` ,`im_window` ,`SMS_email` ,`SMS_wink` , SMS_number ,`SMS_credits` ,`SMS_country` ,`match_array` ,`email_winks` ,`email_msg` ,`email_friends` ,`email_match`)
VALUES ('".$userid."', '".$nw."', '".$nn."', 'yes', 'english', '', 'no', 'no', 'all', 'off', 'off', 'off', '".$SMS_NUM."', '".$packageData['SMS_credits']."', '".$reg_country."', '', 'yes', 'yes', 'yes', 'yes')");
if(strlen($extra)> 5){ $DB->Insert("UPDATE members_data SET uid= ( '".$userid."') $extra WHERE uid= ( '".$userid."' ) LIMIT 1"); }
$Str = "".$userid."**".$pass."**".$ACTIVATION_CODE;
if(isset($_COOKIE['affiliate'])){
$DB->Insert("INSERT INTO `aff_signup` (`affiliate_id` ,`member_id` ,`date` )VALUES ('".strip_tags($_COOKIE['affiliate'])."', '".$userid."', '".DATE_NOW."')");
$DB->Insert("UPDATE aff_members SET total_registered=total_registered+1 WHERE id= ( '".strip_tags($_COOKIE['affiliate'])."' ) LIMIT 1");
}
function ValidateAccount($data, $file, $obj){
global $DB;
$bad_username_array = explode(",",BLOCK_USERNAMES);
$check = $DB->Row("select count(username) AS result from members where username='".$data['username']."'");
if($check['result'] != 0){ return "username"; }
if(in_array($data['username'], $bad_username_array)){
return "username";
}
if (!preg_match('/^[\w-]+$/', $data['username'])){
return "username_chars";
}
## Check the username length
if ( strlen($data['username']) < 5 ) {
return "username_short";
}
$check2 = $DB->Row("select count(email) AS result from members where email ='".$data['email']."'");
if($check2['result'] != 0){ return "email"; }
/*if(eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $values['email'])) {
}else{
return "invalid_email";
}
list($userName, $mailDomain) = split("@", $data['email']);
if (strtoupper(substr(PHP_OS, 0, 3) == 'WIN')) {
## Custom check for windows servers
if (myCheckDNSRR($mailDomain) == 1){
return "invalid_email";
}
}else{
## Linus Server
if (!checkdnsrr($mailDomain, "MX")) {
return "invalid_email";
}
}
if ( strlen( $data['password'] ) < 5 ){
return "password_lenght";
}
if($data['password'] != $data['password_confirm']){
return "password";
}
$Exptions = $data['LinkedRows'];
for($i = 1; $i < 200; $i++) {
if($data['FieldName'.$i] == "age"){
if( ( isset($data['FieldValue'.$i]) && $data['FieldValue'.$i] =="1990-JAN-01" ) || ( isset($data['FieldValue'.$i.'a']) && $data['FieldValue'.$i.'a'] == "1990" ) ){
return "field_empty";
}
}
if(isset($data['FieldName'.$i]) && $data['FieldName'.$i] != "" && $data['FieldName'.$i] != "location" ){ // && $data['FieldName'.$i] != "country"
if(isset($data['FieldValue'.$i]) && ( ( $data['FieldValue'.$i] == "" ) || ( $data['FieldValue'.$i] == '0' ) ) ){
if($Exptions ==0){
return "field_empty";
}else{
$Exptions--;
}
}
}
}
return "complete";
}
function RegisterCompleteRedirect(){
global $DB;
if(VALIDATE_EMAIL ==1 || APPROVE_ACCOUNTS =="yes"){
$_SESSION['auth']="no";
return "activateAccount";
}elseif(isset($_SESSION['uid'])){
return "gogogo";
}
}
?>
