'ko', 'message'=>"Error: Junk mail is not allowed here !")));
}
$token = uniqid();
$password = uniqid();
// test if ALREADY created
$webmaster = Webmaster::getByWP_URL($wp_url);
if (!$webmaster) {
$webmaster = Webmaster::replace(
array( 'username' => $username, 'email' => $email, 'password' => $password, 'token' => $token,
'wp_url' => $wp_url, 'wp_register_url' => $wp_register_url, 'wp_login_url' => $wp_login_url, 'confirmed' => 1),
$debug);
}
if ($debug) {
//echo "webmaster:";print_r($webmaster);
}
if (!$webmaster) {
//die(json_encode(array('result'=>'ko', 'message'=>"Error: $email is already used")));
$webmaster = DB::getOne(self::$table, "WHERE email='$email'");
} else {
Room::createDefaultRoom($webmaster->id);
Gender::createDefaultGenders($webmaster->id);
Config::createDefaultConfig($webmaster->id, $email, $lang);
Role::createDefaultRoles($webmaster->id);
}
$script = Webmaster::generateScript($webmaster->id);
$webmasterid = $webmaster->id;
ob_start();
include(__DIR__."/../email/registerWebmasterWP.php");
$body = ob_get_clean();
Services::sendEmail($email, $email, 'Your account is set up!', $body, EMAILFROM);
die(json_encode(array('result'=>'ok', 'message'=>"Your account has been set up. An email has been sent to $email. Please check your email to setup your account.")));
}
public static function createNewAccount($username, $email, $password, $lang='en', $debug=false) {
if (Services::isJunkMail($email)) {
die(json_encode(array('result'=>'ko', 'message'=>"Error: Junk mail is not allowed here !")));
}
$token = uniqid();
$webmaster = Webmaster::insert(array('username'=>$username, 'email'=>$email, 'password'=>$password, 'token'=>$token), $debug);
if ($debug) {
echo "webmaster:";print_r($webmaster);
}
if (!$webmaster) {
die(json_encode(array('result'=>'ko', 'message'=>"Error: $email is already used")));
}
Room::createDefaultRoom($webmaster->id);
Gender::createDefaultGenders($webmaster->id);
Config::createDefaultConfig($webmaster->id, $email, $lang);
Role::createDefaultRoles($webmaster->id);
$script = Webmaster::generateScript($webmaster->id);
$webmasterid = $webmaster->id;
$link = HOME_HTTP."confirm.php?id=$webmasterid&token=$token";
ob_start();
include(__DIR__."/../email/registerWebmaster.php");
$body = ob_get_clean();
Services::sendEmail($email, $email, "Your account is set up!", $body, EMAILFROM);
die(json_encode(array('result'=>'ok', 'message'=>"Your account has been set up. An email has been sent to $email. Please check your email to setup your account.")));
}
public static function generateScript($webmasterid, $token) {
$script = sprintf("", HOME_HTTP. "script/$webmasterid/$token");
return $script;
}
public static function generateLink($webmasterid, $token) {
$link = HOME_HTTP. "chat/$webmasterid/$token";
return $link;
}
public static function generateLinkJWT($webmasterid, $jwt) {
$link = HOME_HTTP. "chat/$webmasterid/$jwt";
return $link;
}
public static function loginJWT($jwt, $password) {
try {
$decoded = JWT::decode($jwt, $password, array('HS256'));
} catch(Exception $e) {
exit('error');
}
$myuser = (array)$decoded;
//$myuser['isAdmin'] = ($myuser['role']=='admin');
return $myuser;
}
public static function login($email, $password, $debug = false) {
return DB::getOne(Webmaster::$table, "WHERE (email='$email' or username='$email') and password='$password'",$debug);
}
public static function forgotten($email) {
$email = DB::real_escape_string($email);
$fromEmail = EMAILFROM;
$webmaster = DB::getOne(Webmaster::$table, "WHERE email='$email'", false);
$password = $webmaster->password;
if (!$webmaster) {
return 'ko';
} else {
ob_start();
include(__DIR__."/../email/forgottenWebmaster.php");
$body = ob_get_clean();
Services::sendEmail($email, $email, 'Forgotten password', $body, $fromEmail);
return 'ok';
}
}
public static function resendConfirmation($email) {
$email = DB::real_escape_string($email);
$fromEmail = EMAILFROM;
$webmaster = DB::getOne(Webmaster::$table, "WHERE email='$email'", false);
$webmasterid = $webmaster->id;
$token = $webmaster->token;
$link = $link = HOME_HTTP."confirm.php?id=$webmasterid&token=$token";
if (!$webmaster) {
return "ko";
} else {
ob_start();
include(__DIR__."/../email/registerWebmaster.php");
$body = ob_get_clean();
Services::sendEmail($email, $email, 'Account activation', $body, $fromEmail);
return "ok";
}
}
public static function get($id, $debug = false) {
$webmaster = DB::get($id, Webmaster::$table, '', $debug);
if ($webmaster) {
$webmaster->free = false;
$webmaster->expired = false;
if ($webmaster->paiduntil == '0000-00-00') {
$webmaster->free = true;
} else if ($webmaster->paiduntilexpired = true;
}
}
return $webmaster;
}
public static function update($id, $values) {
return DB::update(Webmaster::$table, $id, $values);
}
public static function insert($values, $debug=false) {
$id = DB::insert(Webmaster::$table, $values, $debug);
return DB::getOneById($id, Webmaster::$table);
}
public static function replace($values, $debug=false) {
$id = DB::replace(Webmaster::$table, $values, $debug);
return DB::getOneById($id, Webmaster::$table);
}
public static function delete($id, $webmasterid) {
return DB::delete(Webmaster::$table, $id);
}
public static function getAll() {
return DB::getAll(Webmaster::$table);
}
public static function incrementEntries($id)
{
$sql = "update ".self::$table." set entries=entries+1 WHERE id=$id";
DB::executeSQL($sql);
}
public static function generateScriptAutoConnect($webmasterid, $token, $sampleUsername, $sampleSex) {
$script = sprintf("", HOME_HTTP. "script/$webmasterid/$token/$sampleUsername/$sampleSex");
return $script;
}
public static function generateScriptAutoConnectWithAvatar($webmasterid, $token, $sampleUsername, $sampleSex,$avatar) {
$script = sprintf("", HOME_HTTP. "script/$webmasterid/$token/$sampleUsername/$sampleSex/".base64_encode($avatar));
return $script;
}
public static function getByWP_URL($wp_url) {
$wp_url = DB::real_escape_string($wp_url);
return DB::getOne(self::$table, "WHERE wp_url='$wp_url' Order by id DESC", false);
}
public static function getNumberActiveAccounts() {
$sql = "select count(id) as nombre from ".self::$table." where entries>0";
$obj = DB::fetchObject($sql);
return $obj;
}
public static function reportUserEmail($webmasterid, $emailUserWhoReports, $usernameAuthor, $usernameProblem, $content='', $reportReason=''){
$webmaster = Webmaster::get($webmasterid);
// title et content
$title = "Moderation requested by $usernameAuthor ($emailUserWhoReports) about $usernameProblem ($reportReason)";
ob_start();
include(__DIR__."/../email/template.php");
$body = ob_get_clean();
DB::insert('chat_alerts_webmaster',
array('webmasterid'=>$webmasterid, 'emailUserWhoReports'=>$emailUserWhoReports,
'usernameAuthor'=>$usernameAuthor, 'usernameProblem'=>$usernameProblem, 'description'=>$content, 'reportReason'=>$reportReason), false);
Services::sendEmail($webmaster->email, $emailUserWhoReports, "Moderation required from $emailUserWhoReports", $body, EMAILFROM);
$users = DB::getAll('chat_users',"WHERE webmasterid=$webmasterid and (role='admin' or role='moderator')");
foreach($users as $user) {
Services::sendEmail($user->email, $emailUserWhoReports, "Moderation required from $emailUserWhoReports", $body, EMAILFROM);
}
exit;
}
public static function reportUserRoomEmail($webmasterid, $emailUserWhoReports, $usernameAuthor, $roomNameProblem, $content='', $reportReason=''){
$webmaster = Webmaster::get($webmasterid);
// title et content
$title = "Room Moderation requested by $usernameAuthor ($emailUserWhoReports) about $roomNameProblem ($reportReason)";
ob_start();
include(__DIR__."/../email/template.php");
$body = ob_get_clean();
DB::insert('chat_alerts_webmaster_room',
array('webmasterid'=>$webmasterid, 'emailUserWhoReports'=>$emailUserWhoReports, 'roomNameProblem'=>$roomNameProblem, 'description'=>$content, 'reportReason'=>$reportReason), false);
Services::sendEmail($webmaster->email, $emailUserWhoReports, "Room Moderation required from $emailUserWhoReports", $body, EMAILFROM);
$users = DB::getAll('chat_users',"WHERE webmasterid=$webmasterid and (role='admin' or role='moderator')");
foreach($users as $user) {
Services::sendEmail($user->email, $emailUserWhoReports, "Room Moderation required from $emailUserWhoReports", $body, EMAILFROM);
}
exit;
}
public static function checkToken($webmasterid, $token) {
return DB::getOne(self::$table,"WHERE id=$webmasterid and token = '$token'",false);
}
public static function getNumberCreatedAccounts($days) {
$date = date('Y-m-d 00:00:00', strtotime("-$days days"));
$sql = "select count(id) as nombre from ".self::$table." where date>'$date'";
$obj = DB::fetchObject($sql);
//print_r($obj);
$obj->nombre;
return $obj->nombre;
}
}