query("
SELECT setting_key, setting_value
FROM settings
WHERE setting_key IN ('registration_bonus','referral_bonus')
");
while($s = $setQ->fetch_assoc()){
if($s['setting_key']=='registration_bonus'){
$registration_bonus = (float)$s['setting_value'];
}
if($s['setting_key']=='referral_bonus'){
$referral_bonus = (float)$s['setting_value'];
}
}
$error = "";
$success = "";
$redirect = false;
/* ---------- USER IP ---------- */
$ip_address = $_SERVER['REMOTE_ADDR'];
/* ---------- AUTO REFERRAL CODE ---------- */
function generateReferralCode($length = 8) {
return strtoupper(substr(str_shuffle("ABCDEFGHJKLMNPQRSTUVWXYZ23456789"), 0, $length));
}
/* ---------- FORM SUBMIT ---------- */
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$type = $_POST['type'];
$name = trim($_POST['name']);
$pass = trim($_POST['password']);
$invite = trim($_POST['invite']);
$email = $_POST['email'] ?? null;
$mobile = $_POST['mobile'] ?? null;
if ($name == "" || $pass == "") {
$error = "সব তথ্য পূরণ করুন";
}
elseif (strlen($pass) < 6) {
$error = "পাসওয়ার্ড কমপক্ষে ৬ অক্ষর";
}
else {
/* ---------- IP CHECK (ONE ACCOUNT PER IP) ---------- */
$ipCheck = $conn->prepare("SELECT id FROM users WHERE ip_address = ?");
$ipCheck->bind_param("s", $ip_address);
$ipCheck->execute();
if($ipCheck->get_result()->num_rows > 0){
$error = "এই IP ঠিকানা থেকে ইতিমধ্যে একাউন্ট খোলা হয়েছে";
} else {
/* ----- CHECK DUPLICATE ----- */
if($type == "number"){
$check = $conn->prepare("SELECT id FROM users WHERE mobile = ?");
$check->bind_param("s", $mobile);
}else{
$check = $conn->prepare("SELECT id FROM users WHERE email = ?");
$check->bind_param("s", $email);
}
$check->execute();
if($check->get_result()->num_rows > 0){
$error = "এই তথ্য দিয়ে আগেই একাউন্ট আছে";
}else{
/* ----- PASSWORD HASH ----- */
$hash = password_hash($pass, PASSWORD_DEFAULT);
/* ----- REFERRAL CODE ----- */
$my_referral = generateReferralCode();
/* ----- CHECK INVITE CODE ----- */
$referred_by = null;
if($invite != ""){
$ref = $conn->prepare("SELECT id FROM users WHERE referral_code = ?");
$ref->bind_param("s", $invite);
$ref->execute();
if($ref->get_result()->num_rows == 1){
$referred_by = $invite;
}
}
/* ----- INSERT USER ----- */
$balance = $registration_bonus;
$stmt = $conn->prepare(
"INSERT INTO users
(name, mobile, email, password, referral_code, referred_by, balance, ip_address)
VALUES (?, ?, ?, ?, ?, ?, ?, ?)"
);
$stmt->bind_param(
"ssssssds",
$name,
$mobile,
$email,
$hash,
$my_referral,
$referred_by,
$balance,
$ip_address
);
if($stmt->execute()){
/* ----- REFERRAL BONUS ----- */
if($referred_by){
$bonus = $conn->prepare(
"UPDATE users
SET referral_balance = referral_balance + ?
WHERE referral_code = ?"
);
$bonus->bind_param("ds", $referral_bonus, $referred_by);
$bonus->execute();
}
$_SESSION['user_id'] = $stmt->insert_id;
$success = "আপনার একাউন্ট সফলভাবে তৈরি হয়েছে";
$redirect = true;
}else{
$error = "রেজিস্ট্রেশন ব্যর্থ হয়েছে";
}
}
}
}
}
?>
AMD Registration
নিবন্ধন করুন
