-- Run this once in phpMyAdmin (select the database, then SQL tab).
-- Reworks the free test: was GB/days + a one-time boolean flag; now
-- MB/hours + a per-user counter, so the admin can allow more than one
-- free test per person (free_test_max_count) and reset it whenever needed.
ALTER TABLE users
    ADD COLUMN free_test_used_count INT NOT NULL DEFAULT 0 AFTER used_free_test;

-- Carry over anyone who already used their (old, one-time) free test.
UPDATE users SET free_test_used_count = 1 WHERE used_free_test = 1;

INSERT INTO settings (setting_key, setting_value) VALUES ('free_test_mb', '1024')
    ON DUPLICATE KEY UPDATE setting_key = setting_key;
INSERT INTO settings (setting_key, setting_value) VALUES ('free_test_hours', '24')
    ON DUPLICATE KEY UPDATE setting_key = setting_key;
INSERT INTO settings (setting_key, setting_value) VALUES ('free_test_max_count', '1')
    ON DUPLICATE KEY UPDATE setting_key = setting_key;
-- Note: if you had customized free_test_gb / free_test_days before, those
-- old settings are left untouched but no longer used — re-set the new
-- free_test_mb / free_test_hours values from "تنظیمات ← تست رایگان" if needed.