-- =====================================================
-- Sample Translations (English)
-- =====================================================
-- IMPORTANT: Select your database in phpMyAdmin BEFORE importing this file
-- =====================================================

INSERT INTO `translations` (`language_code`, `trans_key`, `trans_value`, `category`) VALUES

-- Welcome and Start
('en', 'welcome_message', '👋 Welcome to Investment Bot!\n\nStart your investment journey with us. Choose from our flexible investment plans and watch your profits grow!', 'start'),
('en', 'main_menu', '📱 Main Menu\n\nSelect an option below:', 'menu'),

-- Main Menu Buttons
('en', 'btn_balance', '💰 Balance', 'menu'),
('en', 'btn_deposit', '📥 Deposit', 'menu'),
('en', 'btn_withdraw', '📤 Withdraw', 'menu'),
('en', 'btn_reinvest', '🔄 Reinvest', 'menu'),
('en', 'btn_transactions', '📊 Transactions', 'menu'),
('en', 'btn_support', '🆘 Support', 'menu'),
('en', 'btn_about', 'ℹ️ About Us', 'menu'),
('en', 'btn_faq', '❓ FAQ', 'menu'),
('en', 'btn_team', '👥 My Team', 'menu'),

-- Balance
('en', 'balance_title', '💰 Your Balance', 'balance'),
('en', 'no_balance', 'You have no balance yet. Make a deposit to start!', 'balance'),
('en', 'statistics', '📊 Statistics', 'balance'),
('en', 'total_deposited', 'Total Deposited', 'balance'),
('en', 'total_withdrawn', 'Total Withdrawn', 'balance'),
('en', 'total_profit', 'Total Profit', 'balance'),
('en', 'total_referral', 'Total Referral Earnings', 'balance'),
('en', 'active_investments', '💼 Active Investments', 'balance'),
('en', 'investments', 'investments', 'balance'),
('en', 'total_amount', 'Total Amount', 'balance'),
('en', 'no_active_investments', 'You have no active investments.', 'balance'),

-- Deposit
('en', 'deposit_select_currency', '📥 Select currency to deposit:', 'deposit'),
('en', 'deposit_select_plan', 'Select an investment plan for {currency}:', 'deposit'),
('en', 'no_plans_available', 'No investment plans available at the moment.', 'deposit'),
('en', 'invalid_plan', 'Invalid plan selected.', 'deposit'),
('en', 'no_deposit_address', 'Deposit address not available. Please contact support.', 'deposit'),
('en', 'deposit_instructions', '📥 Deposit Instructions', 'deposit'),
('en', 'plan', 'Plan', 'deposit'),
('en', 'currency', 'Currency', 'deposit'),
('en', 'min_amount', 'Minimum', 'deposit'),
('en', 'max_amount', 'Maximum', 'deposit'),
('en', 'roi', 'ROI', 'deposit'),
('en', 'duration', 'Duration', 'deposit'),
('en', 'days', 'days', 'deposit'),
('en', 'deposit_address', 'Deposit Address', 'deposit'),
('en', 'deposit_note', '⚠️ Important:\n• Send only the selected cryptocurrency to this address\n• Your investment will be activated after admin confirmation\n• Minimum amount must be met', 'deposit'),

-- Withdrawal
('en', 'withdraw_select_currency', '📤 Select currency to withdraw:', 'withdraw'),
('en', 'no_balance_withdraw', 'You have no balance available for withdrawal.', 'withdraw'),
('en', 'withdraw_address_required', 'Please enter your {currency} withdrawal address:', 'withdraw'),
('en', 'withdraw_info', '📤 Withdrawal Information', 'withdraw'),
('en', 'available_balance', 'Available Balance', 'withdraw'),
('en', 'min_withdrawal', 'Minimum Withdrawal', 'withdraw'),
('en', 'max_withdrawal', 'Maximum Withdrawal', 'withdraw'),
('en', 'withdrawal_fee', 'Withdrawal Fee', 'withdraw'),
('en', 'your_address', 'Your Withdrawal Address', 'withdraw'),
('en', 'withdraw_enter_amount', '💵 Please enter the amount you wish to withdraw:', 'withdraw'),
('en', 'address_saved', '✓ Address saved successfully!', 'withdraw'),
('en', 'invalid_address', '❌ Invalid address format. Please try again.', 'withdraw'),
('en', 'withdraw_request_created', '✓ Withdrawal Request Created', 'withdraw'),
('en', 'amount', 'Amount', 'withdraw'),
('en', 'fee', 'Fee', 'withdraw'),
('en', 'net_amount', 'You will receive', 'withdraw'),
('en', 'withdraw_pending_note', '⏳ Your withdrawal request is pending admin approval. You will be notified once processed.', 'withdraw'),
('en', 'withdraw_request_failed', '❌ Withdrawal request failed. Please check your balance and try again.', 'withdraw'),

-- Transactions
('en', 'transactions_title', '📊 Transaction History', 'transactions'),
('en', 'no_transactions', 'You have no transactions yet.', 'transactions'),

-- Support
('en', 'support_title', '🆘 Support', 'support'),
('en', 'support_message', 'Need help? Our support team is here to assist you!', 'support'),
('en', 'contact_support', 'Contact Support', 'support'),
('en', 'open_support', 'Open Support Chat', 'support'),

-- Team/Referrals
('en', 'team_title', '👥 My Team', 'referrals'),
('en', 'your_referral_link', 'Your Referral Link', 'referrals'),
('en', 'referral_commission', 'Referral Commission', 'referrals'),
('en', 'total_referrals', 'Total Referrals', 'referrals'),
('en', 'total_earned_from_referrals', 'Total Earned', 'referrals'),
('en', 'your_team', 'Your Team Members', 'referrals'),
('en', 'no_referrals_yet', 'You haven\'t referred anyone yet. Share your referral link to earn commissions!', 'referrals'),
('en', 'and_more_referrals', '... and {count} more', 'referrals'),

-- Errors
('en', 'account_frozen', '🔒 Your account has been frozen. Please contact support.', 'error'),
('en', 'unknown_command', '❓ Unknown command. Please use the menu.', 'error'),
('en', 'invalid_amount', '❌ Invalid amount. Please enter a valid number.', 'error'),
('en', 'page_not_found', '❌ Page not found.', 'error'),

-- General
('en', 'help_message', '📖 Help\n\nUse the menu buttons to navigate:\n• Balance - View your balances\n• Deposit - Make a deposit\n• Withdraw - Request withdrawal\n• Transactions - View history\n• Team - Manage referrals\n• Support - Get help\n\nNeed assistance? Contact: @support', 'general');

-- =====================================================
-- Sample Static Pages (English)
-- =====================================================

INSERT INTO `pages` (`slug`, `language_code`, `title`, `content`) VALUES

('about', 'en', 'About Us', 
'🏢 About Our Investment Platform\n\nWe are a professional cryptocurrency investment platform offering secure and profitable investment opportunities.\n\n✅ Secure Platform\n✅ Multiple Investment Plans\n✅ 24/7 Support\n✅ Fast Withdrawals\n✅ Referral Program\n\nJoin thousands of satisfied investors today!'),

('faq', 'en', 'Frequently Asked Questions',
'❓ FAQ\n\nQ: How do I make a deposit?\nA: Click the Deposit button, select your currency and investment plan, then send funds to the provided address.\n\nQ: How long does withdrawal take?\nA: Withdrawals are processed within 24-48 hours after admin approval.\n\nQ: What is the minimum deposit?\nA: Minimum deposit varies by plan. Check the plan details when depositing.\n\nQ: How does the referral program work?\nA: Share your referral link and earn 5% commission on all deposits made by your referrals.\n\nQ: Is my investment safe?\nA: Yes, all investments are managed by our professional team with secure storage.');

-- End of translations