<?php //------------------------------------------------------// // INIT // //------------------------------------------------------// include '../functions.php'; include '../helpers/class.phpmailer.php'; $email = mysqli_real_escape_string($mysqli, $_POST['email']); $new_pass = ran_string(8, 8, true, false, true); $pass_encrypted = hash('sha512', $new_pass . 'PectGtma'); //------------------------------------------------------// // EVENTS // //------------------------------------------------------// $q = 'SELECT id, name, company, s3_key, s3_secret FROM login WHERE username = "******" LIMIT 1'; $r = mysqli_query($mysqli, $q); if ($r && mysqli_num_rows($r) > 0) { while ($row = mysqli_fetch_array($r)) { $uid = $row['id']; $company = stripslashes($row['company']); $name = stripslashes($row['name']); $aws_key = stripslashes($row['s3_key']); $aws_secret = stripslashes($row['s3_secret']); } //Change user's password to the new one $q = 'UPDATE login SET password = "******" WHERE id = ' . $uid; $r = mysqli_query($mysqli, $q); if ($r) { //send a message to let them know $plain_text = $name . ', ' . _('Your password has been reset, here\'s your new one') . ':
if ($day_today < $reset_on_day) { $month_to_reset = $month_today; } else { $month_to_reset = $month_next; } } else { if ($choose_limit == 'unlimited') { $monthly_limit = -1; $reset_on_day = 1; $month_to_reset = ''; } } //------------------------------------------------------// // FUNCTIONS // //------------------------------------------------------// $q = 'INSERT INTO apps (userID, app_name, from_name, from_email, reply_to, currency, delivery_fee, cost_per_recipient, smtp_host, smtp_port, smtp_ssl, smtp_username, smtp_password, app_key, allocated_quota, day_of_reset, month_of_next_reset) VALUES (' . get_app_info('userID') . ', "' . $app_name . '", "' . $from_name . '", "' . $from_email . '", "' . $reply_to . '", "' . $currency . '", "' . $delivery_fee . '", "' . $cost_per_recipient . '", "' . $smtp_host . '", "' . $smtp_port . '", "' . $smtp_ssl . '", "' . $smtp_username . '", "' . $smtp_password . '", "' . ran_string(30, 30, true, false, true) . '", ' . $monthly_limit . ', ' . $reset_on_day . ', "' . $month_to_reset . '")'; $r = mysqli_query($mysqli, $q); if ($r) { //app id $id = mysqli_insert_id($mysqli); //insert new record $q = 'INSERT INTO login (name, company, username, password, tied_to, app, timezone, language) VALUES ("' . $from_name . '", "' . $app_name . '", "' . $login_email . '", "' . $pass_encrypted . '", ' . get_app_info('userID') . ', ' . $id . ', "' . get_app_info('timezone') . '", "' . $language . '")'; $r = mysqli_query($mysqli, $q); if ($r) { //Upload brand logo //Create /logos/ directory in /uploads/ if it doesn't exist if (!file_exists("../../uploads/logos")) { //Create /csvs/ directory if (!mkdir("../../uploads/logos", 0777)) { //Could not create directory '/logos/'. //Please make sure permissions in /uploads/ folder is set to 777.
<?php include '../functions.php'; include '../login/auth.php'; //------------------------------------------------------// // VARIABLES // //------------------------------------------------------// $app = mysqli_real_escape_string($mysqli, $_POST['app']); $company = mysqli_real_escape_string($mysqli, $_POST['brand_name']); $name = mysqli_real_escape_string($mysqli, $_POST['from_name']); $username = mysqli_real_escape_string($mysqli, $_POST['from_email']); $password = ran_string(8, 8, true, false, true); $pass_encrypted = hash('sha512', $password . 'PectGtma'); //------------------------------------------------------// // FUNCTIONS // //------------------------------------------------------// $q = 'SELECT id FROM login WHERE app = ' . $app; $r = mysqli_query($mysqli, $q); if ($r && mysqli_num_rows($r) > 0) { //update password $q = 'UPDATE login SET password = "******" WHERE app = ' . $app; $r = mysqli_query($mysqli, $q); if ($r) { echo $password; } } else { //insert new record $q = 'INSERT INTO login (name, company, username, password, tied_to, app) VALUES ("' . $name . '", "' . $company . '", "' . $username . '", "' . $pass_encrypted . '", ' . get_app_info('userID') . ', ' . $app . ')'; $r = mysqli_query($mysqli, $q); if ($r) { echo $password;
} //================= Version 1.1.7 =================// //New column in table: apps //=================================================// $q = "SHOW COLUMNS FROM apps WHERE Field = 'app_key'"; $r = mysqli_query($mysqli, $q); if (mysqli_num_rows($r) == 0) { $q3 = 'alter table apps ADD COLUMN app_key VARCHAR (100)'; $r3 = mysqli_query($mysqli, $q3); if ($r3) { $q4 = 'SELECT id FROM apps'; $r4 = mysqli_query($mysqli, $q4); if (mysqli_num_rows($r4) > 0) { while ($row = mysqli_fetch_array($r4)) { $cid = $row['id']; $q5 = 'UPDATE apps SET app_key = "' . ran_string(30, 30, true, false, true) . '" WHERE id = ' . $cid; mysqli_query($mysqli, $q5); } } } } //================= Version 1.1.7.2 ===============// //New index in table: subscribers (email column) //=================================================// //add index to email column in subscribers table $q = 'SHOW INDEX FROM subscribers WHERE KEY_NAME = "s_email"'; $r = mysqli_query($mysqli, $q); if (mysqli_num_rows($r) == 0) { mysqli_query($mysqli, 'CREATE INDEX s_email ON subscribers (email)'); } //================= Version 1.1.8 ===============//