Referral-based Registration

Add the ability to turn on an referral-based registration from the admin panel and be able to set/manage a list of codes from there that could be used for new users when creating a new account. So when turned on, on registration page would be asked as required to type down a referral code to be able to create a new account.

Hi.

So, this would be a system where you can be invited by someone else and this person sends you a code and you have to fill it when you register, isn't it?

Well, you can do already something similar, but it would be a manual task.

You can create a custom profile field (text field), where people can say if they have been invited by other community member, and write the nickname.

Later, as admin, you can check if that other member exists, and, if so, you accept the new member and let him/her start posting on your forum (playing with permissions)

Is this not what you are suggesting:   https://help.forumotion.com/t146889-suggestion-for-a-full-invitation-system#1010808 ?

okamii wrote:Add the ability to turn on an referral-based registration from the admin panel and be able to set/manage a list of codes from there that could be used for new users when creating a new account Vantage ADP. So when turned on, on registration page would be asked as required to type down a referral code to be able to create a new account.

To implement a referral-based registration system with admin management, you'll need to follow these general steps:

1. Database Schema
Update your database schema to support referral codes and track their usage.

Referral Codes Table: Store the referral codes and their details.

sql
Copy code
CREATE TABLE referral_codes (
id INT AUTO_INCREMENT PRIMARY KEY,
code VARCHAR(255) UNIQUE NOT NULL,
is_active BOOLEAN DEFAULT TRUE,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
Users Table: Add a field to track which referral code was used.

sql
Copy code
ALTER TABLE users
ADD COLUMN referral_code_id INT,
ADD FOREIGN KEY (referral_code_id) REFERENCES referral_codes(id);
2. Admin Panel Interface
Create an interface in your admin panel to manage referral codes.

Add New Referral Code: Provide a form to create new referral codes.
List Referral Codes: Display existing referral codes with options to activate/deactivate or delete.
3. Registration Form
Modify the registration form to include a referral code field.

Frontend: Add an input field for the referral code in your registration form.

html
Copy code
<label for="referral_code">Referral Code</label>
<input type="text" id="referral_code" name="referral_code" required>
Backend Validation: Validate the referral code when the user submits the registration form.

javascript
Copy code
// Example in Node.js/Express
app.post('/register', async (req, res) => {
const { referral_code, ...userDetails } = req.body;
if (referral_code) {
const referral = await db.query('SELECT * FROM referral_codes WHERE code = ? AND is_active = TRUE', [referral_code]);
if (!referral.length) {
return res.status(400).send('Invalid referral code');
}
userDetails.referral_code_id = referral[0].id;
}
// Proceed with user registration
});
4. Admin Panel Functionality
Integrate the referral code management into your admin panel.

Create Referral Codes: Provide functionality to add new codes.
Manage Existing Codes: Allow activation, deactivation, or deletion.
Tracking Usage: Optionally, track which referral codes are used and by how many users.
5. Testing
Ensure thorough testing:

Create Referral Codes: Verify that codes can be created and managed correctly.
Register with Codes: Test registration with and without valid/invalid referral codes.
Admin Functions: Ensure that admins can manage referral codes as expected.
6. Deployment
Deploy your changes to the production environment.

Example Technologies
Backend: Node.js with Express, Python with Django, PHP with Laravel
Frontend: React, Vue, Angular
Database: MySQL, PostgreSQL, MongoDB
By following these steps, you'll be able to implement a referral-based registration system with admin management capabilities.