{"slug":"aryabyte-mobile-otp-login","name":"ورود و عضویت پیامکی آریابایت","description":"ورود و ثبت‌نام کاربران با شماره موبایل و رمز یکبار مصرف پیامکی برای وردپرس و ووکامرس، مناسب وب‌سایت‌های ایرانی.","author":"Armin Jamali","active_installs":10,"version":"1.1.3","wp_org_url":"https://wordpress.org/plugins/aryabyte-mobile-otp-login/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"aryabyte_otp_login_codes","full_table_name":"wp_aryabyte_otp_login_codes","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20)","nullable":false,"primary_key":true},{"name":"phone","type":"VARCHAR(15)","nullable":false,"primary_key":false},{"name":"code_hash","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"expires_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"is_used","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"attempts","type":"TINYINT(3)","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"identifier","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"action","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_aryabyte_otp_login_codes ( id BIGINT(20) NOT NULL AUTO_INCREMENT, phone VARCHAR(15) NOT NULL, code_hash VARCHAR(64) NOT NULL, created_at DATETIME NOT NULL, expires_at DATETIME NOT NULL, is_used TINYINT(1) NOT NULL DEFAULT 0, attempts TINYINT(3) NOT NULL DEFAULT 0, ip_address VARCHAR(45) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY phone (phone), KEY expires_at (expires_at) ) {$charset_collate};\"; // جدول rate limiting $sql_rate = \"CREATE TABLE IF NOT EXISTS wp_aryabyte_otp_login_rate_limits ( id BIGINT(20) NOT NULL AUTO_INCREMENT, identifier VARCHAR(50) NOT NULL, type VARCHAR(20) NOT NULL, action VARCHAR(20) NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY identifier (identifier), KEY created_at (created_at) ) {$charset_collate};\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql_codes );"},{"table_name":"aryabyte_otp_login_rate_limits","full_table_name":"wp_aryabyte_otp_login_rate_limits","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":2}