webook_messages_insert.sql

-- WeBook Event Messages for Telegram Bot
-- These messages follow the messageManager.getMessage pattern used in the codebase
-- Each message has both Arabic (ar_value) and English (en_value) versions

-- Main Menu WeBook Buttons
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('btn_webook_events', 
 '🎭 أحداث WeBook', 
 '🎭 WeBook Events', 
 'Button text for WeBook events menu');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('btn_webook_book_by_url', 
 '🎟️ حجز التذاكر برابط الحدث', 
 '🎟️ Book Tickets by Event URL', 
 'Button text for booking tickets by event URL');

-- WeBook Event URL Input
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_enter_event_url', 
 '🔗 يرجى إرسال رابط الحدث الذي تريد حجز التذاكر له (مثال: https://webook.com/en/events/mdlbeast-beast-house-ec/book)', 
 '🔗 Please send the event URL you want to book tickets for (e.g. https://webook.com/en/events/mdlbeast-beast-house-ec/book)', 
 'Message asking user to enter WeBook event URL');

-- Invalid URL
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_invalid_url', 
 '❌ رابط الحدث غير صحيح. يرجى إرسال رابط صحيح لحدث WeBook.', 
 '❌ Invalid event URL. Please send a valid WeBook event URL.', 
 'Error message for invalid WeBook event URL');

-- URL Accepted
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_url_accepted', 
 '✅ تم قبول الرابط!

📍 الرابط الأصلي: {original_url}
🔗 الرابط المصحح: {fixed_url}

كم عدد التذاكر التي تريد حجزها؟ (يرجى إدخال رقم)', 
 '✅ URL accepted!

📍 Original URL: {original_url}
🔗 Fixed URL: {fixed_url}

How many tickets do you want to book? (Please enter a number)', 
 'Message confirming URL acceptance and asking for ticket count');

-- Invalid Ticket Count
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_invalid_ticket_count', 
 '❌ يرجى إدخال عدد صحيح من التذاكر.', 
 '❌ Please enter a valid number of tickets.', 
 'Error message for invalid ticket count');

-- No Tickets Available
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_no_tickets_available', 
 '❌ لا توجد تذاكر متاحة حالياً لهذا الحدث:

📍 رابط الحدث: {event_url}
🎫 التذاكر المطلوبة: {tickets_requested}

يرجى المحاولة مرة أخرى لاحقاً.', 
 '❌ No tickets are currently available for this event:

📍 Event URL: {event_url}
🎫 Tickets Requested: {tickets_requested}

Please try again later.', 
 'Message when no tickets are available for the event');

-- Booking Summary
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_booking_summary', 
 '📋 ملخص الحجز:

📍 رابط الحدث: {event_url}
🎫 التذاكر المطلوبة: {tickets_requested}
📊 الحد الأقصى للتذاكر لكل حساب: {max_tickets_per_account}

', 
 '📋 Booking Summary:

📍 Event URL: {event_url}
🎫 Tickets Requested: {tickets_requested}
📊 Max Tickets Per Account: {max_tickets_per_account}

', 
 'Booking summary message before payment question');

-- Payment Question
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_payment_question', 
 'هل تريد إجراء الدفع تلقائياً؟', 
 'Do you want to make payment automatically?', 
 'Question asking if user wants automatic payment');

-- Request Expired
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_request_expired', 
 'انتهت صلاحية طلبك أو أنه غير صحيح. يرجى البدء من جديد.', 
 'Your request expired or is invalid. Please start again.', 
 'Message when booking request has expired');

-- Processing Messages
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_processing_payment', 
 '💳 يرجى الانتظار بينما نعالج حجزك والدفع...', 
 '💳 Please wait while we process your booking and payment...', 
 'Message when processing booking with automatic payment');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_processing_manual', 
 '📝 حجز تذاكرك بدون دفع تلقائي...', 
 '📝 Booking your tickets without automatic payment...', 
 'Message when processing booking without automatic payment');

-- Account Related Messages
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_error_fetching_accounts', 
 'خطأ في جلب الحسابات للحجز.', 
 'Error fetching accounts for booking.', 
 'Error message when failing to fetch accounts');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_no_available_accounts', 
 'لا توجد حسابات نشطة متاحة مع بيانات الاعتماد للحجز.', 
 'No active accounts with credentials available for booking.', 
 'Message when no accounts are available for booking');

-- Payment Types
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_automatic_payment', 
 '💳 الدفع التلقائي', 
 '💳 Automatic Payment', 
 'Label for automatic payment type');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_manual_payment', 
 '📝 الدفع اليدوي', 
 '📝 Manual Payment', 
 'Label for manual payment type');

-- Starting Process
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_starting_process', 
 '🚀 بدء عملية الحجز:

📍 رابط الحدث: {event_url}
🔗 الرابط المصحح: {fixed_url}
🎫 التذاكر المطلوبة: {tickets_requested}
💳 نوع الدفع: {payment_type}
👥 الحسابات المتاحة: {available_accounts}
⚡ وضع المعالجة: متوازي ({max_concurrent} حسابات في وقت واحد)

معالجة الحسابات بالتوازي للحجز الأسرع...', 
 '🚀 Starting booking process:

📍 Event URL: {event_url}
🔗 Fixed URL: {fixed_url}
🎫 Tickets Requested: {tickets_requested}
💳 Payment Type: {payment_type}
👥 Available Accounts: {available_accounts}
⚡ Processing Mode: Parallel ({max_concurrent} accounts at once)

Processing accounts in parallel for faster booking...', 
 'Message when starting the booking process');

-- Booking Status Messages
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_all_tickets_booked', 
 'تم حجز جميع التذاكر المطلوبة.', 
 'All required tickets have been booked.', 
 'Message when all required tickets are booked');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_logging_in', 
 '🔐 تسجيل الدخول بالحساب: {email}', 
 '🔐 Logging in with account: {email}', 
 'Message when logging in with an account');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_login_failed', 
 '❌ فشل تسجيل الدخول بالحساب: {email}. جاري تجربة الحساب التالي...', 
 '❌ Login failed for account: {email}. Trying next account...', 
 'Message when login fails for an account');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_attempting_booking', 
 '🎯 محاولة حجز التذاكر مع: {email}', 
 '🎯 Attempting to book tickets with: {email}', 
 'Message when attempting to book with an account');

-- Booking Success Messages
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_booking_success_auto', 
 '✅ تم حجز {tickets} تذاكر بنجاح مع {email} (الدفع التلقائي)
📊 إجمالي التذاكر المحجوزة: {total_obtained}/{total_needed}', 
 '✅ Successfully booked {tickets} tickets with {email} (Auto Payment)
📊 Total tickets obtained: {total_obtained}/{total_needed}', 
 'Message when automatic booking is successful');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_booking_success_manual', 
 '✅ تم حجز {tickets} تذاكر بنجاح مع {email} (الدفع اليدوي)
📊 إجمالي التذاكر المحجوزة: {total_obtained}/{total_needed}', 
 '✅ Successfully booked {tickets} tickets with {email} (Manual Payment)
📊 Total tickets obtained: {total_obtained}/{total_needed}', 
 'Message when manual booking is successful');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_booking_success_manual_with_payment', 
 '🎟️ تم حجز {tickets} تذاكر بنجاح مع {email} (الدفع اليدوي)!

📊 إجمالي التذاكر المحجوزة: {total_obtained}/{total_needed}

لإكمال هذا الحجز، يرجى إنهاء الدفع:', 
 '🎟️ Successfully booked {tickets} tickets with {email} (Manual Payment)!

📊 Total tickets obtained: {total_obtained}/{total_needed}

To complete this booking, please finish the payment:', 
 'Message when manual booking is successful with payment URL');

-- Booking Failure Messages
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_booking_failed', 
 '❌ لا توجد تذاكر متاحة أو فشل الحجز مع الحساب: {email}. جاري تجربة الحساب التالي...', 
 '❌ No tickets available or booking failed with account: {email}. Trying next account...', 
 'Message when booking fails with an account');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_tickets_sold_out', 
 '❌ نفدت التذاكر للحساب {email}. جاري تجربة الحساب التالي...', 
 '❌ Tickets sold out for account {email}. Trying next account...', 
 'Message when tickets are sold out for an account');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_booking_error', 
 'حدث خطأ أثناء الحجز مع {email}: {error}', 
 'An error occurred while booking with {email}: {error}', 
 'Message when an error occurs during booking');

-- Final Results Messages
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_booking_completed', 
 '🏁 اكتملت عملية الحجز!

📍 رابط الحدث: {event_url}
🔗 الرابط المصحح: {fixed_url}
🎫 التذاكر المطلوبة: {tickets_requested}
✅ التذاكر المحجوزة: {tickets_obtained}
💳 نوع الدفع: {payment_type}
👥 الحسابات المستخدمة: {accounts_used}
⚡ وضع المعالجة: متوازي ({max_concurrent} حسابات في وقت واحد)', 
 '🏁 Booking process completed!

📍 Event URL: {event_url}
🔗 Fixed URL: {fixed_url}
🎫 Tickets Requested: {tickets_requested}
✅ Tickets Obtained: {tickets_obtained}
💳 Payment Type: {payment_type}
👥 Accounts Used: {accounts_used}
⚡ Processing Mode: Parallel ({max_concurrent} accounts at once)', 
 'Final completion message with booking summary');

-- Error Messages
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_general_error', 
 '❌ حدث خطأ أثناء معالجة طلبك. يرجى المحاولة مرة أخرى.', 
 '❌ An error occurred while processing your request. Please try again.', 
 'General error message for WeBook operations');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_network_error', 
 '❌ خطأ في الشبكة. يرجى التحقق من اتصالك بالإنترنت والمحاولة مرة أخرى.', 
 '❌ Network error. Please check your internet connection and try again.', 
 'Network error message for WeBook operations');

-- Confirmation Messages
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_confirm_booking', 
 'هل أنت متأكد من أنك تريد حجز {tickets} تذاكر لهذا الحدث؟', 
 'Are you sure you want to book {tickets} tickets for this event?', 
 'Confirmation message before proceeding with booking');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_booking_cancelled', 
 'تم إلغاء عملية الحجز.', 
 'Booking process cancelled.', 
 'Message when user cancels the booking process');

-- Status Update Messages
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_status_update', 
 '📊 تحديث الحالة: {current_step}/{total_steps} - {description}', 
 '📊 Status Update: {current_step}/{total_steps} - {description}', 
 'Status update message during booking process');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_processing_accounts', 
 '⚙️ معالجة الحسابات... ({processed}/{total})', 
 '⚙️ Processing accounts... ({processed}/{total})', 
 'Message showing account processing progress');

-- Success Messages
INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_success_message', 
 '🎉 تم إكمال العملية بنجاح!', 
 '🎉 Operation completed successfully!', 
 'General success message for WeBook operations');

INSERT INTO bot_messages (key, ar_value, en_value, description) VALUES 
('webook_partial_success', 
 '⚠️ تم إكمال العملية جزئياً. {successful}/{total} حسابات نجحت.', 
 '⚠️ Operation completed partially. {successful}/{total} accounts succeeded.', 
 'Message when some accounts succeed but others fail');