* @global $nick,$message
* @return string contains the error message
*/
/*
* Include some default values
*/
include ('defaults_inc.php');
/*
* Open a database connection
* The following include returns a database handle
*/
include ('connect_db_inc.php');
$db_handle=connect_db($DATABASEHOST,$DATABASEUSER,$DATABASEPASSWD);
require_once 'db/DatabaseFactory.class.php';
$db = DatabaseFactory::getInstance()->getDatabase( 'chat' );
if(!$db_handle){
echo 'ein Datenbankproblem ist aufgetreten';
exit;//the error message is printed in connect_db_inc.php
}
//adwords-besucher?
$sql = "update google_adwords_views set registriert = 1 where ip = '".$_SERVER['REMOTE_ADDR']."' and inserted > (now() - interval 1 day) limit 1";
$db->query($sql);
include ("login_inc.php");
$_POST['nick'] = trim($_POST['nick']);
if($password && $password2){ //new registration
check_register(trim($_POST['nick']),$password,$password2,$user_email);
if(!$fehler){
//set a cookie
//$Zeit = time();
//if we want to send an amail for konfimation, we have to set kicked to -1 (what means: not yet confirmed)
if($REGISTER_WITH_EMAIL){
$kicked = -1;
}else{
$kicked = 0;
}
SetCookie("PHPOPENCHAT_USER",$_POST['nick'],time()+10035200);
$result=$db->query("INSERT INTO
chat_data
(
Nick,
Zeit,
Raum,
Passwort,
PictureURL,
Email,
Online,
Host,
kicked,
RegTime
)
VALUES
(
'".trim($db->escapeString($_POST['nick']))."',
now(),
'".$db->escapeString($channel)."',
'".$db->escapeString($password)."',
'".$db->escapeString($pictureURL)."',
'".$db->escapeString($user_email)."',
0,
'".$db->escapeString($_SERVER['REMOTE_ADDR'])."',
$kicked,
CURRENT_TIMESTAMP()
)");
$nickid = $db->lastInsertID();
$birthdate = $birth_year.'-'.$birth_month.'-'.$birth_day;
$result = $db->query("INSERT INTO chat_userpages set
id = $nickid,
Gender = '".$db->escapeString($gender)."',
Hobbies = '".$db->escapeString(strip_tags($hobbies))."',
Info = '".$db->escapeString(strip_tags($info))."',
Picture = 'http://".$db->escapeString(strip_tags($pic_url))."',
Show_Friends = '".$db->escapeString($show_friend)."',
Show_Birthdate = '".$db->escapeString($show_birth)."',
Show_Email = '".$db->escapeString($show_email)."',
Homepage='".$db->escapeString(strip_tags($homepage))."',
Theme='".$db->escapeString(strip_tags($theme))."',
City='".$db->escapeString(strip_tags($city))."',
Land='".$db->escapeString(strip_tags($land))."',
ICQ='".$db->escapeString(strip_tags($icq))."',
Birthdate='".$db->escapeString(strip_tags($birthdate))."'");
$result=$db->query("INSERT INTO chat_mail (TIME,UNREAD,NICK,SENDER,SUBJECT,BODY) VALUES (CURRENT_TIMESTAMP(),1,'".$db->escapeString($_POST['nick'])."','$TEAM_NAME','$WELCOME_SUBJ','$WELCOME_MSG')");
$pruef=Crypt($_POST['nick'],$salt_nick);
$successlink = "";
if($REGISTER_WITH_EMAIL){
$salt_nick = substr(md5($_POST['nick'].$pass_phrase),strlen($pass_phrase)%30,2);
$code = substr(md5(Crypt($_POST['nick'],$salt_nick)),0,7);
#$code = Crypt($_POST['nick'],$salt_nick);
$confirmation_link = 'https://'.$CHATSERVERNAME.$INSTALL_DIR.'confirm.'.$FILE_EXTENSION.'?id='.$nickid.'&code='.rawurlencode($code);
$confirmation_link = ''.$confirmation_link.'';
$MAIL_BODY = nl2br($REGISTER_MAIL_1)."\n".$confirmation_link."\n".nl2br($REGISTER_MAIL_2);
#$MAIL_BODY = nl2br($REGISTER_MAIL_1)."\n".$confirmation_link."\n".nl2br($REGISTER_MAIL_2);
#include('send_mail_inc.'.$FILE_EXTENSION);
include_once 'phpmailer/class.phpmailer.php';
$mail = new PHPMailer();
$mail->From = "team@schulhofchat.de";
$mail->FromName = "SchulhofChat";
$mail->Sender = 'team@schulhofchat.de';
$mail->Host = "schulhofchat.de";
$mail->mailer = 'mail';
$mail->IsMail();
$mail->Hostname = 'schulhofchat.de';
$mail->Subject = $MAIL_SUBJECT.' '.$CHATNAME;
$mail->Body = $MAIL_BODY;
$mail->AltBody = strip_tags(str_replace('
',"\n",$MAIL_BODY));
$mail->AddAddress($user_email);
if(!$mail->send()) $success = 'fehler beim Mailversand. Bitte wende Dich an team@schulhofchat.de';
else {
$success = 'Eintragung erfolgreich. Wir haben soeben eine Email an Deine Adresse '.$user_email.' verschickt, in der ein Link zum Abschluß der Registrierung enthalten ist. Schau in Deinen Email-Postkasten nach Deinem Aktivierungscode. Nach dem Empfang der Email klick bitte auf den Link in der EMail, damit du bei uns chatten kannst. Also los, ruf am besten gleich mal deine Emails ab!';
$show = TRUE;
}
}else{
$show = TRUE;
$success = $REGISTER_SUCCESS_1.$successlink.$REGISTER_SUCCESS_2;
}
}
}else{
}
$result_land = $db->query("select country from country where land = 'Germany' order by country");
while($a = $result_land->next()){
$c_select .= '