-- SHARK CRM Multi Language System
-- Run once in phpMyAdmin. Safe to re-run.

CREATE TABLE IF NOT EXISTS languages (
  id INT AUTO_INCREMENT PRIMARY KEY,
  code VARCHAR(10) NOT NULL UNIQUE,
  name VARCHAR(100) NOT NULL,
  direction ENUM('ltr','rtl') NOT NULL DEFAULT 'ltr',
  is_default TINYINT(1) NOT NULL DEFAULT 0,
  status TINYINT(1) NOT NULL DEFAULT 1,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS translation_keys (
  id INT AUTO_INCREMENT PRIMARY KEY,
  `key` VARCHAR(191) NOT NULL UNIQUE,
  group_name VARCHAR(80) NULL,
  description VARCHAR(255) NULL,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS translations (
  id INT AUTO_INCREMENT PRIMARY KEY,
  language_id INT NOT NULL,
  key_id INT NOT NULL,
  value TEXT NOT NULL,
  updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY uniq_lang_key (language_id, key_id),
  KEY idx_trans_language (language_id),
  KEY idx_trans_key (key_id),
  CONSTRAINT fk_trans_language FOREIGN KEY (language_id) REFERENCES languages(id) ON DELETE CASCADE,
  CONSTRAINT fk_trans_key FOREIGN KEY (key_id) REFERENCES translation_keys(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

SET @has_account_lang := (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='accounts' AND COLUMN_NAME='default_language_code');
SET @sql := IF(@has_account_lang=0, 'ALTER TABLE accounts ADD COLUMN default_language_code VARCHAR(10) DEFAULT ''en''', 'SELECT 1');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @has_user_lang := (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='users' AND COLUMN_NAME='language_code');
SET @sql := IF(@has_user_lang=0, 'ALTER TABLE users ADD COLUMN language_code VARCHAR(10) DEFAULT NULL', 'SELECT 1');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

INSERT IGNORE INTO languages (code, name, direction, is_default, status) VALUES
('en', 'English', 'ltr', 1, 1),
('ar', 'العربية', 'rtl', 0, 1);

-- Core translation keys used by PHP/JS. Auto captured UI text will be added while browsing pages.
INSERT IGNORE INTO translation_keys (`key`, group_name, description) VALUES
('menu.dashboard','menu','Dashboard'),('menu.leads','menu','Leads'),('menu.pipeline','menu','Pipeline'),('menu.customers','menu','Customers'),('menu.items','menu','Items'),('menu.quotations','menu','Quotations'),('menu.campaigns','menu','Campaigns'),('menu.audience','menu','Audience'),('menu.occasions','menu','Occasions'),('menu.settings','menu','Settings'),('menu.reminders','menu','Reminders'),('menu.activities','menu','Activities'),('menu.message_logs','menu','Message Logs'),('menu.deals','menu','Deals'),('menu.customer_report','menu','Customer Report'),
('buttons.save','buttons','Save'),('buttons.cancel','buttons','Cancel'),('buttons.add','buttons','Add'),('buttons.edit','buttons','Edit'),('buttons.delete','buttons','Delete'),('buttons.update','buttons','Update'),('buttons.search','buttons','Search'),('buttons.filter','buttons','Filter'),('buttons.export','buttons','Export'),('buttons.import','buttons','Import'),('buttons.send','buttons','Send'),('buttons.close','buttons','Close'),
('settings.languages','settings','Languages'),('languages.title','languages','Languages'),('languages.add_language','languages','Add Language'),('languages.translation_manager','languages','Translation Manager'),('languages.code','languages','Code'),('languages.name','languages','Name'),('languages.direction','languages','Direction'),('languages.default','languages','Default'),('languages.status','languages','Status'),('languages.key','languages','Key'),('languages.english_fallback','languages','English / Fallback'),('languages.translation','languages','Translation'),('languages.group','languages','Group'),('languages.save_translations','languages','Save Translations'),('languages.set_default','languages','Set Default'),('languages.active','languages','Active'),('languages.inactive','languages','Inactive'),
('js.request_failed','js','Request failed'),('js.creating','js','Creating...'),('js.adding','js','Adding...'),('js.updating','js','Updating...'),('js.saving','js','Saving...'),('js.sending','js','Sending...'),('js.removing','js','Removing...'),('js.loading','js','Loading...'),('js.working','js','Working...'),
('messages.unauthorized','messages','Unauthorized'),('messages.invalid_action','messages','Invalid action'),('messages.request_failed','messages','Request failed'),('messages.saved_successfully','messages','Saved successfully'),('messages.deleted_successfully','messages','Deleted successfully');

INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, k.id, k.description FROM languages l JOIN translation_keys k WHERE l.code='en';

INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, k.id,
CASE k.`key`
WHEN 'menu.dashboard' THEN 'لوحة التحكم' WHEN 'menu.leads' THEN 'العملاء المحتملون' WHEN 'menu.pipeline' THEN 'المراحل' WHEN 'menu.customers' THEN 'الزبائن' WHEN 'menu.items' THEN 'المنتجات' WHEN 'menu.quotations' THEN 'عروض الأسعار' WHEN 'menu.campaigns' THEN 'الحملات' WHEN 'menu.audience' THEN 'الجمهور' WHEN 'menu.occasions' THEN 'المناسبات' WHEN 'menu.settings' THEN 'الإعدادات' WHEN 'menu.reminders' THEN 'التذكيرات' WHEN 'menu.activities' THEN 'النشاطات' WHEN 'menu.message_logs' THEN 'سجل الرسائل' WHEN 'menu.deals' THEN 'الصفقات' WHEN 'menu.customer_report' THEN 'تقرير الزبائن'
WHEN 'buttons.save' THEN 'حفظ' WHEN 'buttons.cancel' THEN 'إلغاء' WHEN 'buttons.add' THEN 'إضافة' WHEN 'buttons.edit' THEN 'تعديل' WHEN 'buttons.delete' THEN 'حذف' WHEN 'buttons.update' THEN 'تحديث' WHEN 'buttons.search' THEN 'بحث' WHEN 'buttons.filter' THEN 'فلترة' WHEN 'buttons.export' THEN 'تصدير' WHEN 'buttons.import' THEN 'استيراد' WHEN 'buttons.send' THEN 'إرسال' WHEN 'buttons.close' THEN 'إغلاق'
WHEN 'settings.languages' THEN 'اللغات' WHEN 'languages.title' THEN 'اللغات' WHEN 'languages.add_language' THEN 'إضافة لغة' WHEN 'languages.translation_manager' THEN 'إدارة الترجمات' WHEN 'languages.code' THEN 'الكود' WHEN 'languages.name' THEN 'الاسم' WHEN 'languages.direction' THEN 'الاتجاه' WHEN 'languages.default' THEN 'الافتراضية' WHEN 'languages.status' THEN 'الحالة' WHEN 'languages.key' THEN 'المفتاح' WHEN 'languages.english_fallback' THEN 'النص الأساسي' WHEN 'languages.translation' THEN 'الترجمة' WHEN 'languages.group' THEN 'المجموعة' WHEN 'languages.save_translations' THEN 'حفظ الترجمات' WHEN 'languages.set_default' THEN 'تعيين كافتراضية' WHEN 'languages.active' THEN 'فعالة' WHEN 'languages.inactive' THEN 'غير فعالة'
WHEN 'js.request_failed' THEN 'فشل الطلب' WHEN 'js.creating' THEN 'جاري الإنشاء...' WHEN 'js.adding' THEN 'جاري الإضافة...' WHEN 'js.updating' THEN 'جاري التحديث...' WHEN 'js.saving' THEN 'جاري الحفظ...' WHEN 'js.sending' THEN 'جاري الإرسال...' WHEN 'js.removing' THEN 'جاري الحذف...' WHEN 'js.loading' THEN 'جاري التحميل...' WHEN 'js.working' THEN 'جاري العمل...'
WHEN 'messages.unauthorized' THEN 'غير مصرح' WHEN 'messages.invalid_action' THEN 'إجراء غير صالح' WHEN 'messages.request_failed' THEN 'فشل الطلب' WHEN 'messages.saved_successfully' THEN 'تم الحفظ بنجاح' WHEN 'messages.deleted_successfully' THEN 'تم الحذف بنجاح'
ELSE k.description END
FROM languages l JOIN translation_keys k WHERE l.code='ar';


-- Full pre-seeded translation keys extracted from pages, buttons, labels, placeholders, and AJAX messages.
INSERT IGNORE INTO translation_keys (`key`, group_name, description) VALUES
('auto.8c2084f0173c0d25','auto','" alt="'),
('auto.3182fe8c19e8cb6f','auto','" dir="'),
('auto.8403adda118c2a14','auto','" onchange="toggleExistingPagePermissions('''),
('auto.957149a27a7e13c4','auto','" title="WhatsApp:'),
('auto.39ba49fd18f29445','auto','''; echo '''),
('auto.d6bd9a8e0a35dd02','auto','(Android) or'),
('auto.0065cc443a28f64f','auto','(For SMS gateway integration)'),
('auto.13b791e3477b68f2','auto','(Include country code, e.g., +96171234567)'),
('auto.5aeb4a41c0d106ed','auto','(Sender email for communications)'),
('auto.fec67ac30b063da2','auto','(iPhone)'),
('auto.109b936ad40f2cfa','auto','+ Add'),
('auto.39dd2a578450442d','auto','+ Add Contact'),
('auto.941a1eb70be5bf22','auto','+ Add Customer'),
('auto.1f96de7f9d8eca95','auto','+ Add Email'),
('auto.46a8cbf831e7fb60','auto','+ Add Item'),
('auto.597a2bfc548b1897','auto','+ Add Lead'),
('auto.75aa66df6aaf2efb','auto','+ Add Occasion'),
('auto.474384d8b5b2c6c5','auto','+ Add Reason'),
('auto.0dc30e4b5d79d594','auto','+ Add Reminder'),
('auto.903349280e1767ac','auto','+ Add Stage'),
('auto.5d96d5ad6eb42a31','auto','+ Add User'),
('auto.8ab31fd013d60f68','auto','+ New Audience'),
('auto.5ec1c763e62687f6','auto','+ New Campaign'),
('auto.d2c1a29212a41db3','auto','+ New Category'),
('auto.737021c1b72121aa','auto','+ New Lead'),
('auto.964df5e8eb70f79f','auto','+ New Quotation'),
('auto.8a136d957b1fd146','auto',', Regarding your interest in'),
('auto.435e6404d30c3ae0','auto',', the price is'),
('auto.f16afa135d82e20c','auto','. Would you like more details?'),
('auto.1bfe7949d85b166a','auto','1 to 5 stars'),
('auto.2fcd5a8e4c67ff3b','auto',';--open:'),
('auto.d01b1f7768f99504','auto','= 40 ? ''#f59e0b'' : ''#ef4444''; return `'),
('auto.ccca155b28243114','auto','Accepted Value'),
('auto.12da7db7a532904e','auto','Accepted value by customer'),
('auto.7ea75d0f36ad7b85','auto','Account Emails'),
('auto.e32707613d1f53b9','auto','Account Settings'),
('auto.c764b0423d1782f6','auto','Account updated!'),
('auto.a82e28d13e1a829d','auto','Active Leads'),
('auto.1b59ae254562e354','auto','Activity Type'),
('auto.bb806700f4b57e5d','auto','Activity logged'),
('auto.a541a98f4f495787','auto','Activity notifications'),
('auto.9c4eb09e8cd2c4b3','auto','Add Category'),
('auto.c92c0c39c1e89e1a','auto','Add Customer'),
('auto.db49cada85a174d9','auto','Add Email'),
('auto.4dba3be550bc469a','auto','Add Item'),
('auto.8a58dfa0feb2735c','auto','Add Language'),
('auto.6a1df4c114950372','auto','Add Lead'),
('auto.52bf546199b48b5e','auto','Add Lost Reason'),
('auto.cd556de3309b5b8f','auto','Add Occasion'),
('auto.9d1c0460dd1190d3','auto','Add Reminder'),
('auto.7659b85f83ce9fe5','auto','Add Stage'),
('auto.874393854692c137','auto','Add User'),
('auto.80dce85980b248c5','auto','Add any language and translate the whole system from database without changing code.'),
('auto.ce8b1faaf8f86a4e','auto','Add specific people even if filters do not match'),
('auto.e484777b809fc082','auto','Added At'),
('auto.6daa0ff229e22c7a','auto','Added By'),
('auto.75a4b633a09baf6e','auto','Added by'),
('auto.d4dc76e140a2de53','auto','Added to my account'),
('auto.2daac4fb9c3483f4','auto','Added!'),
('auto.cf963e5241ce9c26','auto','Advanced Filters'),
('auto.080fa3b072d4021e','auto','All Activities'),
('auto.1fd266c217d796db','auto','All Categories'),
('auto.0b313a76be2d3e34','auto','All Countries'),
('auto.2f1873dfbe0d49dc','auto','All Items'),
('auto.31ecd13d5c801555','auto','All Priorities'),
('auto.b1b6108e947daee7','auto','All Sources'),
('auto.6c4e12af0abd6f7f','auto','All Stages'),
('auto.6b308de777df8080','auto','All Status'),
('auto.eb672cb3ba0260b3','auto','All Types'),
('auto.b4f25a14263364e1','auto','All Users'),
('auto.3b14cfa244431d83','auto','All connected'),
('auto.33c7d0a60fd40287','auto','All groups'),
('auto.ce832d9b31482cd6','auto','All users'),
('auto.eca8e6358271af92','auto','Allowed pages'),
('auto.ecb48b0c731febc6','auto','Assign To'),
('auto.a5531d4081f16ac9','auto','Audience Filters'),
('auto.a9d5c432b8db5d9a','auto','Audience Name *'),
('auto.b474ba7b75d80ac6','auto','Audience saved.'),
('auto.1613299941dfbce7','auto','Audience updated:'),
('auto.d4bcc7c35e6df5d6','auto','Available Languages');
INSERT IGNORE INTO translation_keys (`key`, group_name, description) VALUES
('auto.359a3bdb3f29dad3','auto','Back to users'),
('auto.1e6d5b542ecc21b1','auto','Body = '''),
('auto.81da2e4c7b18e885','auto','Business Logo'),
('auto.4fee51fde270837d','auto','Business Name'),
('auto.0129fff650c4c216','auto','Business ↕'),
('auto.b24c2b58fca9071f','auto','Campaign Name *'),
('auto.66f5ad8c080eb677','auto','Campaign Report:'),
('auto.b453f7f160f9b9bf','auto','Campaign Type'),
('auto.404e37b307e064c9','auto','Campaign can be sent one time only.'),
('auto.7cb6e4679fc77203','auto','Campaign create failed'),
('auto.1fb2653c81a1e00b','auto','Campaign deleted'),
('auto.f5392cd696b22cb3','auto','Campaign saved'),
('auto.fcd74e2576f86970','auto','Campaign saved. Sending now…'),
('auto.e805325fd0ebfd84','auto','Campaign start failed'),
('auto.5e23de497842794f','auto','Category deleted'),
('auto.49289db43e663a3d','auto','Change Password'),
('auto.3b70576bc2a7b49e','auto','Choose an image to send with WhatsApp or Email message.'),
('auto.12b2c5803ae019ee','auto','Choose at least one dynamic filter/customer before saving campaign'),
('auto.79ffe9a5a4caf114','auto','Choose filters then save the audience.'),
('auto.1e70d76c78f0d497','auto','Choose pages from sidebar. Any selected page gives full access inside it.'),
('auto.59786153a0d8cab8','auto','Choose who should receive this campaign'),
('auto.914a9b5ecc97d3b1','auto','Click the button below to reset your password. This link expires in 1 hour.'),
('auto.0ad9a792bab0c1da','auto','Click to upload image'),
('auto.8f561823924c2006','auto','Click view for full customer actions.'),
('auto.86e38ff184bb6a3c','auto','Client / Lead'),
('auto.7e1a0ccd0f30efcc','auto','Client ID:'),
('auto.130c62f72d54eb08','auto','Client Name'),
('auto.c25c95667be4a2cb','auto','Client created! Scan the QR.'),
('auto.774c99ea171cfe8d','auto','Client name'),
('auto.4088bcbba1776388','auto','Comment *'),
('auto.c06e61ad6bebea17','auto','Comment / Note *'),
('auto.f89a4840fb844679','auto','Comment added'),
('auto.68dcd71ce6baa65c','auto','Confirm New Password'),
('auto.c62ada101ff9abe6','auto','Connected but DB error:'),
('auto.10cb217100a30699','auto','Connected but could not save to DB'),
('auto.70416d44af6debdf','auto','Connected!'),
('auto.716dd1a7653060c6','auto','Connection Health'),
('auto.1edb3a3b19ef87db','auto','Connection Name *'),
('auto.64a3d272d601fd00','auto','Connection issue'),
('auto.4d09a88ff30fe08f','auto','Contact Customer'),
('auto.ba0f5bf3aefa7f4a','auto','Contact Lead'),
('auto.59ef057a42abf89f','auto','Contact add failed'),
('auto.0380cbc5a61c9743','auto','Controls all price display in lists, pipeline, quotations and invoices.'),
('auto.3f4f74ef54d64e54','auto','Could not save image'),
('auto.bd8e2043c0836b5b','auto','Could not save uploaded image'),
('auto.1893d110d8416181','auto','Countries updated!'),
('auto.5eac4067e26a002f','auto','Create & Send Now'),
('auto.eff4fd865f1aa136','auto','Create Account'),
('auto.931868cfb93a0619','auto','Create Account + Owner Full Access'),
('auto.b25c91fe6103401c','auto','Create User'),
('auto.f110f39edaed0e34','auto','Create WhatsApp Client'),
('auto.35814169a764ebc5','auto','Create a new customer'),
('auto.479fa82ac7623e85','auto','Created Date'),
('auto.b66c8f6ee4d73f0d','auto','Currency:'),
('auto.3d16cbd075f0c110','auto','Current Month'),
('auto.4d5967896006c8a6','auto','Current Password'),
('auto.e95dfbea9e03b9b0','auto','Current User'),
('auto.47f0e2ea5d990fd9','auto','Custom API endpoint for WhatsApp integration'),
('auto.6e28080e1b49ea3a','auto','Customer *'),
('auto.23312fdbb25d40a4','auto','Customer Details'),
('auto.37e67c3f12e12749','auto','Customer ID: #'),
('auto.c996cd1052deb897','auto','Customer Information'),
('auto.ed6073c9bb2d44bb','auto','Customer Labels'),
('auto.75636316f9d7169a','auto','Customer Name'),
('auto.e25608b4c207e7fc','auto','Customer Name *'),
('auto.8651d9a02eb5b122','auto','Customer Report'),
('auto.2ba6470eb874f29c','auto','Customer added'),
('auto.9b9dbd58338b3a06','auto','Customer and occasion name are required'),
('auto.5568bccdad5b1c29','auto','Customer birthdays / events / special dates'),
('auto.1f838468e184f9c5','auto','Customer communications'),
('auto.b172c12346c4b8db','auto','Customer contacts list'),
('auto.81393bb28003b7c9','auto','Customer deleted'),
('auto.8bded58ec989d7b4','auto','Customer details'),
('auto.3dc64cc466b55aae','auto','Customer has no'),
('auto.e5c5ca8ee16b3ca6','auto','Customer not found'),
('auto.a1bc62ebf0b7f8b6','auto','Customer report'),
('auto.ed6485ddea94a7bc','auto','Customer source'),
('auto.21ef9fa044ea3016','auto','Customer updated'),
('auto.663bc83be5eb37b9','auto','Customer ↕'),
('auto.56ebd803ff051e62','auto','Customers & Send Results');
INSERT IGNORE INTO translation_keys (`key`, group_name, description) VALUES
('auto.2cc1a257943ba1cc','auto','Customers who have leads'),
('auto.d36f1955ad71edee','auto','Date *'),
('auto.3cf45b40c8c5fa9a','auto','Date From'),
('auto.8a23403b68250894','auto','Date To'),
('auto.4a6be5e9c9205f6b','auto','Date from'),
('auto.cad6bd30b38680d4','auto','Date to'),
('auto.a720eaba64ac0894','auto','Deal Stages'),
('auto.23319b2f20da9a33','auto','Default Leads View'),
('auto.f82b602271f6f355','auto','Default email updated!'),
('auto.840023606d8ecb5a','auto','Delete this campaign?'),
('auto.8ba0355f5ba1eeb3','auto','Delete this lead? This cannot be undone.'),
('auto.860b588ede1e2523','auto','Delete this occasion?'),
('auto.d73eacb22cdd94a3','auto','Deleted!'),
('auto.1ebe50c1080b1a5a','auto','Demo: admin@sharkcrm.com / admin123'),
('auto.0ac7c388e19a25f9','auto','Disconnect WhatsApp and remove from CRM?'),
('auto.7513f9647738208d','auto','Due:'),
('auto.ad5d2c3c14a2d632','auto','Duplicate lead found'),
('auto.5707351bdab71c0d','auto','Dynamic Filter'),
('auto.859bdc1b54392984','auto','Dynamic Filters'),
('auto.ed6b5da66f916a67','auto','Edit Customer'),
('auto.0e457253adf2c3d8','auto','Edit User'),
('auto.604e4bff227bfca6','auto','Email *'),
('auto.09ba557fd106f101','auto','Email Address'),
('auto.ccde2b55da470573','auto','Email Message'),
('auto.ac4b5e72e8975a00','auto','Email Subject'),
('auto.4445224d24f7b550','auto','Email added!'),
('auto.7ea736982db10e34','auto','Email address that will appear as sender when sending emails from CRM'),
('auto.50a509f0ffa6047a','auto','Email form not found'),
('auto.82a8f0699c2fb634','auto','Email sent'),
('auto.990aa5c0892b4086','auto','Email sent successfully'),
('auto.7c9526afc3092cc0','auto','Email ↕'),
('auto.73b64b2588a4b71f','auto','Emails Sent'),
('auto.8aa8acf58374de73','auto','English / Fallback'),
('auto.efd8461ad1d5019d','auto','Enter a connection name'),
('auto.2561af4e3ae4688b','auto','Enter email'),
('auto.684bf9adf06738ec','auto','Enter label name'),
('auto.04ef342212565aac','auto','Enter stage name'),
('auto.8cdbba4325ba3ffd','auto','Enter your email'),
('auto.162d53ad8adaa819','auto','Error loading customer'),
('auto.787aa1617c370e45','auto','Error:'),
('auto.fb7328a3c8497e3c','auto','Est. Price'),
('auto.9b22572484c3c8de','auto','Estimated Price'),
('auto.6a71ed46899318d2','auto','Failed to load item'),
('auto.a879a2dbde3c4d31','auto','Failed to update stage'),
('auto.7fed9f64c55ad19d','auto','Filter by label'),
('auto.4c29f7f0335807c2','auto','Forgot password?'),
('auto.6b7587a9cdd9a908','auto','From Date'),
('auto.411b616bf22e6a46','auto','Full page access'),
('auto.b62f154091188177','auto','General customer reminder'),
('auto.5b7992e2d57b5b50','auto','General reminder - no lead'),
('auto.d2804b4b3c89a5b5','auto','Give all access'),
('auto.b673e054d448cc1f','auto','Give all pages'),
('auto.2e737fffa287c4a9','auto','Give your WhatsApp connection a name, then scan the QR code with your phone.'),
('auto.89a33439d1c6698e','auto','Google Ads / Social / Other'),
('auto.6c9562014ef361ef','auto','Graphs for customer activity, won leads, quotations and accepted value.'),
('auto.0ff183912b1ec455','auto','Has leads'),
('auto.51c1987c5523abe5','auto','Has leads or leads on specific items'),
('auto.65611e9520e76814','auto','Hello,'),
('auto.91e60261c06a1ca5','auto','How to scan:'),
('auto.5c9a22ce8000c8fe','auto','If you did not request this, ignore this email.'),
('auto.2ae508df1173fa8e','auto','Image is too large. Max 5MB'),
('auto.5975bc26bade01a4','auto','Image optional'),
('auto.0da7dbb70c1cea38','auto','Image removed'),
('auto.b7e01618f4bc9d3f','auto','Image too large. Max 5MB'),
('auto.ed893f3754b3cc44','auto','Image upload failed'),
('auto.ea79fccf74865d76','auto','Include item image if available'),
('auto.84fd64a1166caa77','auto','Invalid action'),
('auto.1b33c005ef316797','auto','Invalid image type'),
('auto.8fee112a49deb677','auto','Invalid image type. Allowed: JPG, PNG, GIF, WEBP'),
('auto.e7bec95431b3640a','auto','Item / Product'),
('auto.497c978bc23e248e','auto','Item Name'),
('auto.31b8182f1c05c365','auto','Item deleted'),
('auto.6eb32428ccdc840d','auto','Item name already exists. Do you still want to save it?'),
('auto.109547ba1b215d09','auto','Items *'),
('auto.365dd7eaa96ff276','auto','Items Listed'),
('auto.2f6eaf49d99fce6b','auto','JPG, PNG, GIF, WEBP up to 5MB'),
('auto.204eb333cec5081a','auto','JPG, PNG, WEBP, GIF — max 5MB each'),
('auto.1cbd6495f2602a3d','auto','Kanban View'),
('auto.c88a59de1ffbe10a','auto','Labels saved'),
('auto.4c24525b0aa0b06f','auto','Last Modified');
INSERT IGNORE INTO translation_keys (`key`, group_name, description) VALUES
('auto.0e544718ed9a67be','auto','Lead / Customer'),
('auto.8b2d0aace3e6995c','auto','Lead Details'),
('auto.9334d1f365c47876','auto','Lead Information'),
('auto.af0c9d68d44ded1e','auto','Lead Items'),
('auto.50564efb22d9783b','auto','Lead Reference: #'),
('auto.0036008febac6b75','auto','Lead added!'),
('auto.b84bc0066188d43c','auto','Lead deleted'),
('auto.cfb93ca9046e7b04','auto','Lead details page'),
('auto.cde1ef3e0ff4021d','auto','Lead follow-ups'),
('auto.a2a05a18c5be8f22','auto','Lead results'),
('auto.c3a4e7b9bcb2f127','auto','Leads count'),
('auto.a83d6707b34fcd01','auto','Leave blank to keep existing password'),
('auto.5bd27abe8787c1d3','auto','Lebanese number must be 8 digits starting with 71 or 76 or 78 or 81'),
('auto.4924c4717b17e19a','auto','Lebanon / Qatar / ...'),
('auto.95a5696457a713b1','auto','Link a Device'),
('auto.ef0544d06f13f1bc','auto','Link to Customer'),
('auto.fe25bb97b5774f18','auto','Link to Lead'),
('auto.0a5a1885e9d10d99','auto','Link to Lead optional'),
('auto.1c734f776206fcfe','auto','Link your WhatsApp number to send messages directly from the CRM'),
('auto.1e2ea95bd8c66bb8','auto','Linked Devices'),
('auto.a2b54c63fefe35ac','auto','Linked Lead:'),
('auto.e1a4ed370f85b911','auto','Live Match'),
('auto.5f38e52899ca0965','auto','Loading QR...'),
('auto.19edcb1cc92194ae','auto','Lost Deals'),
('auto.e27baae119c37624','auto','Lost Reasons'),
('auto.f299e2a71b2a6e82','auto','Lost reason updated!'),
('auto.c96a023948d6a1fb','auto','Mailer library not found'),
('auto.9a34917c9c0c3b5f','auto','Manage Categories'),
('auto.bbd43baf66e66724','auto','Marked as done!'),
('auto.9cf1b68c1b0ef27b','auto','Message sent'),
('auto.55086199cbe335ef','auto','Message sent successfully!'),
('auto.75c20a8df1cd57b5','auto','Messages Log'),
('auto.cd0103c9dc57b871','auto','Missing email'),
('auto.c91eddc42e53c5e4','auto','Missing phone'),
('auto.0aa16763d5540c86','auto','Missing required fields'),
('auto.d145bb8309369d67','auto','Name *'),
('auto.f3cb09d2ff12705c','auto','Name / Desc'),
('auto.6cc153f0e5df62ff','auto','Network error'),
('auto.b6c7606793d40447','auto','Network error:'),
('auto.b0b2e19c22ae857b','auto','New / Won / Lost are fixed system stage types. New custom stages are Normal only.'),
('auto.c3c81792c6eae709','auto','New Label'),
('auto.4894cb39ee419a77','auto','New Password'),
('auto.dcef481f416ae056','auto','New Password (leave blank to keep current)'),
('auto.cb9d9eb81406a0b1','auto','New Quotation'),
('auto.613871df7059d69c','auto','Next Month ›'),
('auto.0efc9a1e49d54c8b','auto','No Role'),
('auto.36dab9c15ad94f9d','auto','No WhatsApp campaign ID returned'),
('auto.fffbd89ac26e5e43','auto','No activities yet'),
('auto.4271877166d243b6','auto','No audiences found'),
('auto.108a9f6ec9801757','auto','No campaign ID returned'),
('auto.cd25b633452cb562','auto','No campaigns found'),
('auto.d14da379465a287c','auto','No comments yet'),
('auto.b7691e85c2db15f8','auto','No communications found'),
('auto.d6b56f0bec2d3fa2','auto','No contacts added'),
('auto.15600999ccafc014','auto','No customers'),
('auto.5288ca15b1bada56','auto','No customers found'),
('auto.d802d232a85b790c','auto','No data'),
('auto.8393a2700f281fb6','auto','No data found'),
('auto.1fc50aae4cc0755f','auto','No emails added yet.'),
('auto.da82049bdffc666c','auto','No items yet — add your first product or service!'),
('auto.ebcb3369a14b3f5e','auto','No labels'),
('auto.68cdb29b59400497','auto','No leads found'),
('auto.2f071731f140dda9','auto','No leads found matching the current filters'),
('auto.d1b908935f692907','auto','No leads yet'),
('auto.40b50d4ffbb3d299','auto','No messages found'),
('auto.8587bb10da94de52','auto','No new customers to add'),
('auto.9e3289b537352666','auto','No note added yet.'),
('auto.f03eb1de1e64d4aa','auto','No notes'),
('auto.396c8bcb2c85ff7b','auto','No occasions found'),
('auto.2d611cdaf732edb3','auto','No quotations found'),
('auto.15281f7890821113','auto','No reminders found'),
('auto.d5a0131c67c4e00c','auto','No reminders yet'),
('auto.e2dc86caab47bb92','auto','No results yet'),
('auto.1a92c0e3e058ba4f','auto','No sources found.'),
('auto.114a7c9f5347a062','auto','No upcoming reminders'),
('auto.692c4c2ae2e1e1c8','auto','No won deals found'),
('auto.582fc6dcd75ef166','auto','Not Added'),
('auto.61e25f419928cef9','auto','Note saved!'),
('auto.550ebf29d1bd2e71','auto','Number used for sending SMS messages via your SMS gateway'),
('auto.c862e9121feddc26','auto','Occasion Name *');
INSERT IGNORE INTO translation_keys (`key`, group_name, description) VALUES
('auto.0610e4e7a74309f8','auto','Occasion added'),
('auto.cf41d049c759dce4','auto','Occasion deleted'),
('auto.da3796977c5863e1','auto','Occasion updated'),
('auto.96c7ced5933090c3','auto','Open Lead'),
('auto.7895d0d5b36182ce','auto','Open WhatsApp on your phone'),
('auto.c73da6d5916d3187','auto','Open countries'),
('auto.46d4edeb0899883f','auto','Open leads filters'),
('auto.c0c981bb364d92f2','auto','Opportunity %'),
('auto.c30d3057c0e60554','auto','Or upload new image'),
('auto.bfe4cd42d2b330fb','auto','Overdue Reminders'),
('auto.d5378e60d0ee06d3','auto','Overview & Statistics'),
('auto.a0435e0cd039c5e9','auto','Owner Email'),
('auto.e5a05515a7590c59','auto','Owner Password'),
('auto.5a886140f6183d5e','auto','Page Access'),
('auto.b4c9fe4c165848d4','auto','Page access'),
('auto.c006e57e66ae1391','auto','Page access saved!'),
('auto.7cc2398c384f61f0','auto','Password *'),
('auto.79167df1dd0bc2f6','auto','Password Reset'),
('auto.2e56251139c06b98','auto','Password updated!'),
('auto.d69c3b1ac54be7da','auto','Passwords do not match'),
('auto.61266b2f848f7b32','auto','Pending Reminders'),
('auto.d016004473e0e58d','auto','Permission denied'),
('auto.2cdac5659132caac','auto','Phone number must be between 5-15 digits'),
('auto.cf72db517bc1a3b4','auto','Phone ↕'),
('auto.daeea4d0cc37b1e4','auto','Phone:'),
('auto.d4d9d46adf8e6ecb','auto','Pipeline Overview'),
('auto.c9ef3018c5bc9a06','auto','Pipeline Value'),
('auto.8ec4350688e3d1e5','auto','Please choose an image file'),
('auto.2c59e44512710eac','auto','Please enter a comment'),
('auto.d2b8f68e05729b9c','auto','Please enter a message'),
('auto.5ec5a131a90ffe8e','auto','Please enter a reason'),
('auto.1314162e06d1d734','auto','Please enter a subject'),
('auto.31e70aa5003993b9','auto','Please enter activity notes'),
('auto.4187bf72eab2fd9f','auto','Please enter reminder comment'),
('auto.f14b5de4c7317b85','auto','Please enter reminder note'),
('auto.cf172b5a3ed69934','auto','Please select a valid customer from the list'),
('auto.138a107c3f03bdf3','auto','Please select activity date'),
('auto.9eb4e8066ae5d517','auto','Please select reminder date'),
('auto.f301ca24f18b8ab6','auto','Please set a WhatsApp number first'),
('auto.e3342938730237f4','auto','Please set an email address first'),
('auto.e1f2cef844f58f84','auto','Please use this code to reset your password.'),
('auto.0550397c011cf036','auto','Point your phone at the QR code'),
('auto.54cc0b907d18376d','auto','Post Comment'),
('auto.3e9e6dc06f0f7b75','auto','Prepared message'),
('auto.787004617d6c907d','auto','Price Decimals'),
('auto.a9a48e298b62a977','auto','Primary image updated'),
('auto.096ac757f008bf12','auto','Priority (Stars)'),
('auto.a416758713cef691','auto','Priority (min ★)'),
('auto.d6f9b1ddf5f8b424','auto','Priority ↕'),
('auto.b274922fb5ee0fee','auto','Priority ≥'),
('auto.f7cbf7fa4b2e5188','auto','Quick Stats'),
('auto.496ad2c33c51378e','auto','Quick contact buttons'),
('auto.d2e53d19c0ea8c61','auto','Quotation saved'),
('auto.239605e2fd225030','auto','Quotations status'),
('auto.0c76fd5dd8ec7360','auto','Reason *'),
('auto.a9b8f0e4874aee79','auto','Recent Leads'),
('auto.f4bd058430049d1f','auto','Reminder Calendar -'),
('auto.544b89a212f95e05','auto','Reminder Date'),
('auto.18e5b40b9f9a7a25','auto','Reminder Time'),
('auto.e26907db8b4f0993','auto','Reminder Type'),
('auto.ca0d0e2a9c6ed0f6','auto','Reminder added'),
('auto.3fb75e3bfe4de94e','auto','Reset Password'),
('auto.b0d21bb97899242d','auto','Revenue Won'),
('auto.e05cd6a268b6cfcd','auto','Role updated!'),
('auto.62cc0077ab92adee','auto','SALES INTELLIGENCE PLATFORM'),
('auto.a75e9bb679c2ba5a','auto','SMS Message'),
('auto.9b1f098d6cdf02c7','auto','SMS Sent'),
('auto.1f767c71d82544b1','auto','SMS sent'),
('auto.ac4178b3bdb5a6df','auto','SMTP Password'),
('auto.40ec4bdc33210b19','auto','SMTP Port'),
('auto.c05323ba9bd468d6','auto','SMTP Username'),
('auto.16fc9a95a9622472','auto','Save Access'),
('auto.5ce047a8004f12d6','auto','Save Action'),
('auto.09a1f4de4200e82a','auto','Save Audience'),
('auto.a1f54af431bdf6bd','auto','Save Category'),
('auto.fa2984b367b8f2fc','auto','Save Changes'),
('auto.ffe9f842d7595338','auto','Save Customer'),
('auto.ea0e082d4d4bdffb','auto','Save Item'),
('auto.e9b75b84826ca78c','auto','Save Labels'),
('auto.80062221da9bd4c5','auto','Save Lead');
INSERT IGNORE INTO translation_keys (`key`, group_name, description) VALUES
('auto.f2158988d5389f65','auto','Save Only'),
('auto.2f5f40a6f06003d2','auto','Save Permissions'),
('auto.cb406af9a43e5af7','auto','Save Quotation'),
('auto.a13e3a61e9da556c','auto','Save Reminder'),
('auto.047744aab5d1cfaf','auto','Save Translations'),
('auto.82f6b304226ae488','auto','Saved Audience'),
('auto.05bd4f15f00bbbde','auto','Saved! Reloading...'),
('auto.76af964d40827982','auto','Saving to database...'),
('auto.4bbb1900e059cb03','auto','Scan QR Code with WhatsApp'),
('auto.5e8f2d6c5e3aa39a','auto','Select Audience'),
('auto.434b368d8f47d5aa','auto','Select Country'),
('auto.f4801ffc34e0d666','auto','Select Stage'),
('auto.c875cbd5b1af621d','auto','Select User'),
('auto.5cd4d2fedc4221f0','auto','Select a user from the list.'),
('auto.64d530273135c8fd','auto','Select a user to set page/action permissions.'),
('auto.08e975daa72ed44e','auto','Select an audience before saving campaign'),
('auto.3fa212a7b076147b','auto','Select audience to see customer count.'),
('auto.6817176b830546e6','auto','Select customer'),
('auto.e58e97bb67daed20','auto','Select source'),
('auto.f52423e61ba196ab','auto','Select stage...'),
('auto.fd192fa7ad074115','auto','Select type...'),
('auto.eb081600325e72fb','auto','Select user first'),
('auto.b30fa35abc3f3b0f','auto','Send Campaign Now'),
('auto.5192082ccb9ba9f1','auto','Send Details'),
('auto.b8ec554332fca521','auto','Send reset link'),
('auto.431b04c21a4bb8aa','auto','Send this campaign now? You cannot send it again after it is marked sent.'),
('auto.6eaa24bb52ca2503','auto','Set Default'),
('auto.5b6f739130d00f54','auto','Set as default'),
('auto.0263e40259594203','auto','Set up default contact methods for sending WhatsApp, SMS, and Email from leads'),
('auto.b4a3b2ff89a79db0','auto','Shark CRM /'),
('auto.b96354f9e51f3284','auto','Shark CRM Big Admin'),
('auto.63400cad7cc3283b','auto','Shark CRM –'),
('auto.704832844dbefc38','auto','Shark CRM – Login'),
('auto.4048a11f85e15bd0','auto','Show 0'),
('auto.91a980fb1e0fbb76','auto','Show 0.00'),
('auto.1cca4735cf5f9bc8','auto','Sign In →'),
('auto.bb7e79e8f7bf8c83','auto','Since ↕'),
('auto.2ddfb8dbb883d3db','auto','Specific recipients'),
('auto.913dfabc03e3841e','auto','Specified date'),
('auto.181c1139f12b7b05','auto','Stage Name *'),
('auto.b5c005dde9612ec6','auto','Stage added!'),
('auto.c6c88ddf17dcf599','auto','Stage deleted'),
('auto.75334b0c6abe10b9','auto','Stage updated'),
('auto.5289765264e85269','auto','Stage updated!'),
('auto.5a9cb8497b791640','auto','Stages checkbox filter'),
('auto.11dc9e1952928d4c','auto','Status:'),
('auto.d64fc80f74003153','auto','Stored Members'),
('auto.cdcae857019184dd','auto','Subject:'),
('auto.78674f4602f5af50','auto','Survey Completed'),
('auto.b984d7095bd0f6fb','auto','TVA %'),
('auto.170fe5272d78e236','auto','Take Action'),
('auto.652ac2cbbafccc62','auto','Target:'),
('auto.a12f4a2ed5e6e82e','auto','Team Members'),
('auto.89b360ecd0bd2e36','auto','Test email sent successfully!'),
('auto.5561918f01838562','auto','The WhatsApp number will be used when you click the WhatsApp button in:'),
('auto.68fd1247a7dd9054','auto','The email address will appear as the sender when sending emails from:'),
('auto.a810bcec2983c58e','auto','This logo appears on quotation/invoice print pages.'),
('auto.1f8133cb29f755f9','auto','Timeline & Comments'),
('auto.ea7490888dd7c691','auto','Tip: select all active stages and leave Lost/Won unchecked.'),
('auto.642cced347dab857','auto','To Date'),
('auto.7e7fbc811015943c','auto','To:'),
('auto.74ae5d0fdbe0cddf','auto','Today''s Reminders'),
('auto.89a36344d72896d4','auto','Top customers by leads'),
('auto.d4fc4a41820bf984','auto','Total Attempts'),
('auto.413a164d589fe3b3','auto','Total Leads'),
('auto.d8e7170f94e71360','auto','Total:'),
('auto.0775b4cd2cabb81e','auto','Translation Manager'),
('auto.ee3fb11d05c90c37','auto','Type:'),
('auto.1eea68d093d1561b','auto','Unit Price'),
('auto.e6cb55c694b8d022','auto','Unknown type'),
('auto.d3303568cf31b880','auto','Upcoming Reminders'),
('auto.e607df26437e2797','auto','Update Audience'),
('auto.5ef580aad2a08a42','auto','Update Customer'),
('auto.61dcf34e70921088','auto','Update Password'),
('auto.ad6539794a5fd881','auto','Update Stage'),
('auto.e27738c47f3ecda8','auto','Update User'),
('auto.22714274a44dd11e','auto','Updated At'),
('auto.58a8220ee6600f11','auto','Used when clicking WhatsApp button on lead contacts'),
('auto.c930fd60616af19a','auto','User Permissions'),
('auto.82977211a17b5e56','auto','User added!');
INSERT IGNORE INTO translation_keys (`key`, group_name, description) VALUES
('auto.882d726b0e049967','auto','User removed'),
('auto.503718be30dd257a','auto','User updated!'),
('auto.f7745eb0e73f87d0','auto','Users List'),
('auto.a144230d85488566','auto','Valid Until'),
('auto.5a57c6ff3f3187ce','auto','Valid until:'),
('auto.50cdc18b7b3e09a6','auto','Verification Code'),
('auto.efd83559209cb6ae','auto','View All'),
('auto.bae2691c691e5443','auto','View Leads'),
('auto.d71400f9537868ea','auto','Website / App / Pending'),
('auto.22077755e5f494b2','auto','WhatsApp Connect'),
('auto.10d76eb6f24cb380','auto','WhatsApp Connected'),
('auto.86f808611bf76612','auto','WhatsApp Image'),
('auto.4058de3ea99f8299','auto','WhatsApp Message'),
('auto.4d8ab6fff4cbdfbd','auto','WhatsApp Preview'),
('auto.49febdcc242a211b','auto','WhatsApp Sent'),
('auto.2f73d3ca28f74009','auto','WhatsApp campaign create failed'),
('auto.d10e8a825d33cb32','auto','WhatsApp client not found'),
('auto.467cad16bd1ca0f0','auto','WhatsApp connected! 🎉'),
('auto.617c139e48bad6a2','auto','WhatsApp contact add failed'),
('auto.2095224ef81cbbdc','auto','WhatsApp message sent successfully'),
('auto.29dd389964fcf10c','auto','WhatsApp sent'),
('auto.caddbe20d29a1e59','auto','WhatsApp start failed'),
('auto.48f8bbd487053bac','auto','When opening Leads from the menu, choose list or pipeline by default.'),
('auto.49a383890e53d7b4','auto','Win Rate'),
('auto.61c9433e5040e3b5','auto','Won Deals'),
('auto.95cbf72b9989e8e8','auto','Won Leads'),
('auto.96b0e2eec1cc6569','auto','Won leads only'),
('auto.89e7122da5844220','auto','Write short internal note here. It has more padding now so it does not stick to card edge.'),
('auto.21fa08b1b363db37','auto','Yes, save anyway'),
('auto.95226b851ad80369','auto','You do not have permission to open any Settings tab.'),
('auto.cc8b4db834d6b252','auto','You do not have permission to open this page.'),
('auto.3fa6f5fb505ace79','auto','Your email'),
('auto.7e9f2e0524c21813','auto','| Email:'),
('auto.37e6657c2c3a3d8e','auto','| SMS:'),
('auto.b3196daf354114e5','auto','— No category —'),
('auto.4635991fb59ea28a','auto','— Select Audience —'),
('auto.f8f7e32cb9ed71d4','auto','‹ Previous Month'),
('auto.c32ae9f4a77d1bb9','auto','← Back'),
('auto.4c2c64ee67c15c2d','auto','← Back to Customers'),
('auto.d66b344d32fdb5a1','auto','← Back to Leads'),
('auto.8a28792ab2b2b05b','auto','← Start Over'),
('auto.cdbe31e76616b83b','auto','⋮ Menu'),
('auto.510ba246a0dfe748','auto','⏰ Reminders ('),
('auto.678eb6275f804ede','auto','★ 1 Star'),
('auto.08ca33ab7e2a63d8','auto','★★ 2 Stars'),
('auto.80f05685b94b291b','auto','★★★ 3 Stars'),
('auto.25de639c3f435e65','auto','★★★★ 4 Stars'),
('auto.6d860244bc785068','auto','★★★★★ 5 Stars'),
('auto.079b9229cbec2efd','auto','☰ List'),
('auto.cb84ac49bd0e2bd4','auto','⚙ Manage Stages'),
('auto.91d60ac5239da680','auto','⚙️ Communication Configuration'),
('auto.472e61fd3adb74f6','auto','⚙️ Configuration'),
('auto.a23d1f00995c4392','auto','✅ Take Action ('),
('auto.d8b55ad91d2a2181','auto','✉️ Email'),
('auto.111426bf883193c5','auto','✉️ SMS'),
('auto.b00cd0a3d79ef0f0','auto','✉️ SMS Number'),
('auto.89c0831acfdf4409','auto','✕ Clear'),
('auto.5c70ced3ee4c5ee8','auto','✕ Reset'),
('auto.6a94c83bf9bed404','auto','⭐ By Priority'),
('auto.f362182160a2cc91','auto','🌍 Available Countries'),
('auto.8b0c3fa5ac7cadac','auto','🌍 By Country'),
('auto.17bf278e8d8520e3','auto','🌍 Countries'),
('auto.2550c141a4c352e9','auto','🏷️ By Labels'),
('auto.f1d677248ad78e6c','auto','👥 Pick Customers Manually'),
('auto.f4f44cc875aac610','auto','💬 Comments ('),
('auto.f5ab48e7ca6e725e','auto','💬 Communications ('),
('auto.726ee333bcc10620','auto','💬 WhatsApp'),
('auto.59aec56b0d816b36','auto','💾 Save Configuration'),
('auto.e386faacc385ea23','auto','💾 Save Countries'),
('auto.0a41a0ba5be4a112','auto','💾 Save Note'),
('auto.e14f036b3a4d5e4d','auto','📁 Categories'),
('auto.6d3bf27bbd34314a','auto','📊 Pipeline'),
('auto.703bcb02f01950f5','auto','📌 By Leads / Items'),
('auto.f98df297e2527b8d','auto','📌 Leads ('),
('auto.7f7e135c106fc94c','auto','📖 How to Use'),
('auto.c76c8b9c413446c3','auto','📝 Edit Note'),
('auto.b16ad276b6008efa','auto','📝 Lead Note'),
('auto.9bf5649007681c5d','auto','📝 Note'),
('auto.8d75daf9f88cc5da','auto','📝 View'),
('auto.aa3afb8cf5f261f5','auto','📞 Customer Contacts');
INSERT IGNORE INTO translation_keys (`key`, group_name, description) VALUES
('auto.a89bf7d0f859291a','auto','📧 Email'),
('auto.ada1cccc9bd7510b','auto','📧 Email From Address'),
('auto.298745aefcd4d8b3','auto','📧 Email Host / SMTP Server (Optional)'),
('auto.2b377b274c3f7a1e','auto','📧 Emails'),
('auto.b652ecda4a090d24','auto','📧 Test Email'),
('auto.7d40f000412ac0c0','auto','📨 Contact'),
('auto.056aa5be587a0168','auto','📨 Send'),
('auto.5f53e02263f13b56','auto','📱 SMS'),
('auto.0cccffb8385d7226','auto','📱 Test WhatsApp'),
('auto.90b67064a8a7a628','auto','📱 WhatsApp'),
('auto.b4c47b037a69e248','auto','📱 WhatsApp Number'),
('auto.c7b24163063fed62','auto','🔄 Change Stage'),
('auto.a6f0979502208fde','auto','🔄 Refresh QR'),
('auto.2dd32fc55477c2bc','auto','🔌 Disconnect'),
('auto.717b977a4d04c46b','auto','🔍 Apply'),
('auto.80bec918e85f4167','auto','🔍 Filters'),
('auto.6bc9d49c5faa1d4a','auto','🔗 Connect WhatsApp'),
('auto.ee56712e317dc08b','auto','🔗 WhatsApp API URL (Optional - for automated sending)'),
('auto.764bc1f48904976e','auto','🖼️ Click to upload or drag & drop images here'),
('auto.1a25f6aae74ee883','auto','🗑 Delete'),
('auto.8fb0a9354a21c153','auto','🗑️ Delete'),
('auto.6ac74d8d37e74631','auto','🦈 Shark CRM Big Admin'),
('auto.b6572e658c41b210','auto','🧭 By Source'),
('messages.account_updated','messages','Account updated!'),
('messages.activity_logged','messages','Activity logged'),
('messages.added','messages','Added!'),
('messages.audience_saved','messages','Audience saved.'),
('messages.audience_updated','messages','Audience updated:'),
('messages.campaign_create_failed','messages','Campaign create failed'),
('messages.campaign_deleted','messages','Campaign deleted'),
('messages.campaign_saved','messages','Campaign saved'),
('messages.campaign_saved_sending_now','messages','Campaign saved. Sending now…'),
('messages.campaign_start_failed','messages','Campaign start failed'),
('messages.category_deleted','messages','Category deleted'),
('messages.choose_at_least_one_dynamic_filter_customer_before_saving_campaign','messages','Choose at least one dynamic filter/customer before saving campaign'),
('messages.client_created_scan_the_qr','messages','Client created! Scan the QR.'),
('messages.comment_added','messages','Comment added'),
('messages.connected_but_db_error','messages','Connected but DB error:'),
('messages.connected_but_could_not_save_to_db','messages','Connected but could not save to DB'),
('messages.contact_add_failed','messages','Contact add failed'),
('messages.could_not_save_image','messages','Could not save image'),
('messages.could_not_save_uploaded_image','messages','Could not save uploaded image'),
('messages.countries_updated','messages','Countries updated!'),
('messages.customer_added','messages','Customer added'),
('messages.customer_and_occasion_name_are_required','messages','Customer and occasion name are required'),
('messages.customer_deleted','messages','Customer deleted'),
('messages.customer_has_no','messages','Customer has no'),
('messages.customer_not_found','messages','Customer not found'),
('messages.customer_updated','messages','Customer updated'),
('messages.default_email_updated','messages','Default email updated!'),
('messages.delete_this_campaign','messages','Delete this campaign?'),
('messages.delete_this_lead_this_cannot_be_undone','messages','Delete this lead? This cannot be undone.'),
('messages.delete_this_occasion','messages','Delete this occasion?'),
('messages.deleted','messages','Deleted!'),
('messages.disconnect_whatsapp_and_remove_from_crm','messages','Disconnect WhatsApp and remove from CRM?'),
('messages.email_added','messages','Email added!'),
('messages.email_form_not_found','messages','Email form not found'),
('messages.email_sent','messages','Email sent'),
('messages.email_sent_successfully','messages','Email sent successfully'),
('messages.enter_a_connection_name','messages','Enter a connection name'),
('messages.enter_email','messages','Enter email'),
('messages.enter_label_name','messages','Enter label name'),
('messages.enter_stage_name','messages','Enter stage name'),
('messages.enter_your_email','messages','Enter your email'),
('messages.error_loading_customer','messages','Error loading customer'),
('messages.error','messages','Error:'),
('messages.failed_to_load_item','messages','Failed to load item'),
('messages.failed_to_update_stage','messages','Failed to update stage'),
('messages.image_is_too_large_max_5mb','messages','Image is too large. Max 5MB'),
('messages.image_removed','messages','Image removed'),
('messages.image_too_large_max_5mb','messages','Image too large. Max 5MB'),
('messages.image_upload_failed','messages','Image upload failed'),
('messages.invalid_action','messages','Invalid action'),
('messages.invalid_image_type','messages','Invalid image type'),
('messages.invalid_image_type_allowed_jpg_png_gif_webp','messages','Invalid image type. Allowed: JPG, PNG, GIF, WEBP'),
('messages.item_deleted','messages','Item deleted'),
('messages.item_name_already_exists_do_you_still_want_to_save_it','messages','Item name already exists. Do you still want to save it?'),
('messages.labels_saved','messages','Labels saved'),
('messages.lead_added','messages','Lead added!'),
('messages.lead_deleted','messages','Lead deleted');
INSERT IGNORE INTO translation_keys (`key`, group_name, description) VALUES
('messages.lebanese_number_must_be_8_digits_starting_with_71_or_76_or_78_or_81','messages','Lebanese number must be 8 digits starting with 71 or 76 or 78 or 81'),
('messages.lost_reason_updated','messages','Lost reason updated!'),
('messages.mailer_library_not_found','messages','Mailer library not found'),
('messages.marked_as_done','messages','Marked as done!'),
('messages.message_sent','messages','Message sent'),
('messages.message_sent_successfully','messages','Message sent successfully!'),
('messages.missing_email','messages','Missing email'),
('messages.missing_phone','messages','Missing phone'),
('messages.missing_required_fields','messages','Missing required fields'),
('messages.network_error','messages','Network error:'),
('messages.no_whatsapp_campaign_id_returned','messages','No WhatsApp campaign ID returned'),
('messages.no_campaign_id_returned','messages','No campaign ID returned'),
('messages.no_new_customers_to_add','messages','No new customers to add'),
('messages.note_saved','messages','Note saved!'),
('messages.occasion_added','messages','Occasion added'),
('messages.occasion_deleted','messages','Occasion deleted'),
('messages.occasion_updated','messages','Occasion updated'),
('messages.page_access_saved','messages','Page access saved!'),
('messages.password_updated','messages','Password updated!'),
('messages.passwords_do_not_match','messages','Passwords do not match'),
('messages.permission_denied','messages','Permission denied'),
('messages.phone_number_must_be_between_5_15_digits','messages','Phone number must be between 5-15 digits'),
('messages.please_choose_an_image_file','messages','Please choose an image file'),
('messages.please_enter_a_comment','messages','Please enter a comment'),
('messages.please_enter_a_message','messages','Please enter a message'),
('messages.please_enter_a_reason','messages','Please enter a reason'),
('messages.please_enter_a_subject','messages','Please enter a subject'),
('messages.please_enter_activity_notes','messages','Please enter activity notes'),
('messages.please_enter_reminder_comment','messages','Please enter reminder comment'),
('messages.please_enter_reminder_note','messages','Please enter reminder note'),
('messages.please_select_a_valid_customer_from_the_list','messages','Please select a valid customer from the list'),
('messages.please_select_activity_date','messages','Please select activity date'),
('messages.please_select_reminder_date','messages','Please select reminder date'),
('messages.please_set_a_whatsapp_number_first','messages','Please set a WhatsApp number first'),
('messages.please_set_an_email_address_first','messages','Please set an email address first'),
('messages.primary_image_updated','messages','Primary image updated'),
('messages.quotation_saved','messages','Quotation saved'),
('messages.reminder_added','messages','Reminder added'),
('messages.role_updated','messages','Role updated!'),
('messages.sms_sent','messages','SMS sent'),
('messages.saved_reloading','messages','Saved! Reloading...'),
('messages.select_an_audience_before_saving_campaign','messages','Select an audience before saving campaign'),
('messages.select_user_first','messages','Select user first'),
('messages.431b04c21a4b','messages','Send this campaign now? You cannot send it again after it is marked sent.'),
('messages.stage_added','messages','Stage added!'),
('messages.stage_deleted','messages','Stage deleted'),
('messages.stage_updated','messages','Stage updated!'),
('messages.test_email_sent_successfully','messages','Test email sent successfully!'),
('messages.unknown_type','messages','Unknown type'),
('messages.user_added','messages','User added!'),
('messages.user_removed','messages','User removed'),
('messages.user_updated','messages','User updated!'),
('messages.whatsapp_campaign_create_failed','messages','WhatsApp campaign create failed'),
('messages.whatsapp_client_not_found','messages','WhatsApp client not found'),
('messages.whatsapp_connected','messages','WhatsApp connected! 🎉'),
('messages.whatsapp_contact_add_failed','messages','WhatsApp contact add failed'),
('messages.whatsapp_message_sent_successfully','messages','WhatsApp message sent successfully'),
('messages.whatsapp_sent','messages','WhatsApp sent'),
('messages.whatsapp_start_failed','messages','WhatsApp start failed');

INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, k.id, k.description FROM languages l JOIN translation_keys k WHERE l.code='en';
INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, tk.id, x.v FROM languages l JOIN translation_keys tk JOIN (
SELECT 'auto.8c2084f0173c0d25' AS k, '" alt="' AS v
UNION ALL
SELECT 'auto.3182fe8c19e8cb6f' AS k, '" dir="' AS v
UNION ALL
SELECT 'auto.8403adda118c2a14' AS k, '" onchange="toggleExistingPagePermissions(''' AS v
UNION ALL
SELECT 'auto.957149a27a7e13c4' AS k, '" title="WhatsApp:' AS v
UNION ALL
SELECT 'auto.39ba49fd18f29445' AS k, '''; echo ''' AS v
UNION ALL
SELECT 'auto.d6bd9a8e0a35dd02' AS k, '(Android) or' AS v
UNION ALL
SELECT 'auto.0065cc443a28f64f' AS k, '(For SMS gateway integration)' AS v
UNION ALL
SELECT 'auto.13b791e3477b68f2' AS k, '(Include country code, e.g., +96171234567)' AS v
UNION ALL
SELECT 'auto.5aeb4a41c0d106ed' AS k, '(إرسالer email for communications)' AS v
UNION ALL
SELECT 'auto.fec67ac30b063da2' AS k, '(iالهاتف)' AS v
UNION ALL
SELECT 'auto.109b936ad40f2cfa' AS k, 'إضافة' AS v
UNION ALL
SELECT 'auto.39dd2a578450442d' AS k, 'إضافة جهة اتصال' AS v
UNION ALL
SELECT 'auto.941a1eb70be5bf22' AS k, 'إضافة زبون' AS v
UNION ALL
SELECT 'auto.1f96de7f9d8eca95' AS k, 'إضافة بريد' AS v
UNION ALL
SELECT 'auto.46a8cbf831e7fb60' AS k, 'إضافة منتج' AS v
UNION ALL
SELECT 'auto.597a2bfc548b1897' AS k, 'إضافة Lead' AS v
UNION ALL
SELECT 'auto.75aa66df6aaf2efb' AS k, 'إضافة مناسبة' AS v
UNION ALL
SELECT 'auto.474384d8b5b2c6c5' AS k, 'إضافة سبب' AS v
UNION ALL
SELECT 'auto.0dc30e4b5d79d594' AS k, 'إضافة تذكير' AS v
UNION ALL
SELECT 'auto.903349280e1767ac' AS k, 'إضافة مرحلة' AS v
UNION ALL
SELECT 'auto.5d96d5ad6eb42a31' AS k, 'إضافة مستخدم' AS v
UNION ALL
SELECT 'auto.8ab31fd013d60f68' AS k, 'جمهور جديد' AS v
UNION ALL
SELECT 'auto.5ec1c763e62687f6' AS k, 'حملة جديدة' AS v
UNION ALL
SELECT 'auto.d2c1a29212a41db3' AS k, 'فئة جديدة' AS v
UNION ALL
SELECT 'auto.737021c1b72121aa' AS k, 'Lead جديد' AS v
UNION ALL
SELECT 'auto.964df5e8eb70f79f' AS k, 'عرض سعر جديد' AS v
UNION ALL
SELECT 'auto.8a136d957b1fd146' AS k, ', Regarding your interest in' AS v
UNION ALL
SELECT 'auto.435e6404d30c3ae0' AS k, ', the price is' AS v
UNION ALL
SELECT 'auto.f16afa135d82e20c' AS k, '. Would you like more details?' AS v
UNION ALL
SELECT 'auto.1bfe7949d85b166a' AS k, '1 to 5 stars' AS v
UNION ALL
SELECT 'auto.2fcd5a8e4c67ff3b' AS k, ';--open:' AS v
UNION ALL
SELECT 'auto.d01b1f7768f99504' AS k, '= 40 ? ''#f59e0b'' : ''#ef4444''; return `' AS v
UNION ALL
SELECT 'auto.ccca155b28243114' AS k, 'القيمة المقبولة' AS v
UNION ALL
SELECT 'auto.12da7db7a532904e' AS k, 'القيمة المقبولة من الزبون' AS v
UNION ALL
SELECT 'auto.7ea75d0f36ad7b85' AS k, 'إيميلات الحساب' AS v
UNION ALL
SELECT 'auto.e32707613d1f53b9' AS k, 'إعدادات الحساب' AS v
UNION ALL
SELECT 'auto.c764b0423d1782f6' AS k, 'تم تحديث الحساب!' AS v
UNION ALL
SELECT 'auto.a82e28d13e1a829d' AS k, 'Leads فعالين' AS v
UNION ALL
SELECT 'auto.1b59ae254562e354' AS k, 'نوع النشاط' AS v
UNION ALL
SELECT 'auto.bb806700f4b57e5d' AS k, 'تم تسجيل النشاط' AS v
UNION ALL
SELECT 'auto.a541a98f4f495787' AS k, 'إشعارات النشاط' AS v
UNION ALL
SELECT 'auto.9c4eb09e8cd2c4b3' AS k, 'إضافة فئة' AS v
UNION ALL
SELECT 'auto.c92c0c39c1e89e1a' AS k, 'إضافة زبون' AS v
UNION ALL
SELECT 'auto.db49cada85a174d9' AS k, 'إضافة بريد' AS v
UNION ALL
SELECT 'auto.4dba3be550bc469a' AS k, 'إضافة منتج' AS v
UNION ALL
SELECT 'auto.8a58dfa0feb2735c' AS k, 'إضافة لغة' AS v
UNION ALL
SELECT 'auto.6a1df4c114950372' AS k, 'إضافة Lead' AS v
UNION ALL
SELECT 'auto.52bf546199b48b5e' AS k, 'إضافة سبب خسارة' AS v
UNION ALL
SELECT 'auto.cd556de3309b5b8f' AS k, 'إضافة مناسبة' AS v
UNION ALL
SELECT 'auto.9d1c0460dd1190d3' AS k, 'إضافة تذكير' AS v
UNION ALL
SELECT 'auto.7659b85f83ce9fe5' AS k, 'إضافة مرحلة' AS v
UNION ALL
SELECT 'auto.874393854692c137' AS k, 'إضافة مستخدم' AS v
UNION ALL
SELECT 'auto.80dce85980b248c5' AS k, 'إضافة any language and translate the whole system from database without changing code.' AS v
UNION ALL
SELECT 'auto.ce8b1faaf8f86a4e' AS k, 'إضافة specific people even if filters do not match' AS v
UNION ALL
SELECT 'auto.e484777b809fc082' AS k, 'تاريخ الإضافة' AS v
UNION ALL
SELECT 'auto.6daa0ff229e22c7a' AS k, 'أضيف بواسطة' AS v
UNION ALL
SELECT 'auto.75a4b633a09baf6e' AS k, 'أضيف بواسطة' AS v
UNION ALL
SELECT 'auto.d4dc76e140a2de53' AS k, 'مضاف إلى حسابي' AS v
UNION ALL
SELECT 'auto.2daac4fb9c3483f4' AS k, 'تمت الإضافة!' AS v
UNION ALL
SELECT 'auto.cf963e5241ce9c26' AS k, 'فلاتر متقدمة' AS v
) x ON x.k=tk.`key` WHERE l.code='ar';
INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, tk.id, x.v FROM languages l JOIN translation_keys tk JOIN (
SELECT 'auto.080fa3b072d4021e' AS k, 'كل النشاطات' AS v
UNION ALL
SELECT 'auto.1fd266c217d796db' AS k, 'كل الفئات' AS v
UNION ALL
SELECT 'auto.0b313a76be2d3e34' AS k, 'كل البلدان' AS v
UNION ALL
SELECT 'auto.2f1873dfbe0d49dc' AS k, 'كل المنتجات' AS v
UNION ALL
SELECT 'auto.31ecd13d5c801555' AS k, 'كل الأولويات' AS v
UNION ALL
SELECT 'auto.b1b6108e947daee7' AS k, 'كل المصادر' AS v
UNION ALL
SELECT 'auto.6c4e12af0abd6f7f' AS k, 'كل المراحل' AS v
UNION ALL
SELECT 'auto.6b308de777df8080' AS k, 'كل الحالات' AS v
UNION ALL
SELECT 'auto.eb672cb3ba0260b3' AS k, 'كل الأنواع' AS v
UNION ALL
SELECT 'auto.b4f25a14263364e1' AS k, 'كل المستخدمين' AS v
UNION ALL
SELECT 'auto.3b14cfa244431d83' AS k, 'كلها متصلة' AS v
UNION ALL
SELECT 'auto.33c7d0a60fd40287' AS k, 'كل المجموعات' AS v
UNION ALL
SELECT 'auto.ce832d9b31482cd6' AS k, 'كل المستخدمين' AS v
UNION ALL
SELECT 'auto.eca8e6358271af92' AS k, 'الصفحات المسموحة' AS v
UNION ALL
SELECT 'auto.ecb48b0c731febc6' AS k, 'تعيين إلى' AS v
UNION ALL
SELECT 'auto.a5531d4081f16ac9' AS k, 'فلاتر الجمهور' AS v
UNION ALL
SELECT 'auto.a9d5c432b8db5d9a' AS k, 'اسم الجمهور *' AS v
UNION ALL
SELECT 'auto.b474ba7b75d80ac6' AS k, 'تم حفظ الجمهور.' AS v
UNION ALL
SELECT 'auto.1613299941dfbce7' AS k, 'الجمهور updated:' AS v
UNION ALL
SELECT 'auto.d4bcc7c35e6df5d6' AS k, 'اللغات المتاحة' AS v
UNION ALL
SELECT 'auto.359a3bdb3f29dad3' AS k, 'رجوع إلى المستخدمين' AS v
UNION ALL
SELECT 'auto.1e6d5b542ecc21b1' AS k, 'Body = ''' AS v
UNION ALL
SELECT 'auto.81da2e4c7b18e885' AS k, 'شعار الشركة' AS v
UNION ALL
SELECT 'auto.4fee51fde270837d' AS k, 'اسم الشركة' AS v
UNION ALL
SELECT 'auto.0129fff650c4c216' AS k, 'Business ↕' AS v
UNION ALL
SELECT 'auto.b24c2b58fca9071f' AS k, 'اسم الحملة *' AS v
UNION ALL
SELECT 'auto.66f5ad8c080eb677' AS k, 'تقرير الحملة:' AS v
UNION ALL
SELECT 'auto.b453f7f160f9b9bf' AS k, 'نوع الحملة' AS v
UNION ALL
SELECT 'auto.404e37b307e064c9' AS k, 'يمكن إرسال الحملة مرة واحدة فقط.' AS v
UNION ALL
SELECT 'auto.7cb6e4679fc77203' AS k, 'فشل إنشاء الحملة' AS v
UNION ALL
SELECT 'auto.1fb2653c81a1e00b' AS k, 'تم حذف الحملة' AS v
UNION ALL
SELECT 'auto.f5392cd696b22cb3' AS k, 'تم حفظ الحملة' AS v
UNION ALL
SELECT 'auto.fcd74e2576f86970' AS k, 'تم حفظ الحملة. جاري الإرسال…' AS v
UNION ALL
SELECT 'auto.e805325fd0ebfd84' AS k, 'فشل بدء الحملة' AS v
UNION ALL
SELECT 'auto.5e23de497842794f' AS k, 'تم حذف الفئة' AS v
UNION ALL
SELECT 'auto.49289db43e663a3d' AS k, 'تغيير كلمة المرور' AS v
UNION ALL
SELECT 'auto.3b70576bc2a7b49e' AS k, 'Choose an image to send with WhatsApp or البريد message.' AS v
UNION ALL
SELECT 'auto.12b2c5803ae019ee' AS k, 'Choose at least one dynamic filter/customer before saving campaign' AS v
UNION ALL
SELECT 'auto.79ffe9a5a4caf114' AS k, 'Choose filters then save the audience.' AS v
UNION ALL
SELECT 'auto.1e70d76c78f0d497' AS k, 'Choose pages from sidebar. Any selected page gives full access inside it.' AS v
UNION ALL
SELECT 'auto.59786153a0d8cab8' AS k, 'Choose who should receive this campaign' AS v
UNION ALL
SELECT 'auto.914a9b5ecc97d3b1' AS k, 'Click the button below to reset your password. This link expires in 1 hour.' AS v
UNION ALL
SELECT 'auto.0ad9a792bab0c1da' AS k, 'اضغط لرفع صورة' AS v
UNION ALL
SELECT 'auto.8f561823924c2006' AS k, 'Click view for full customer actions.' AS v
UNION ALL
SELECT 'auto.86e38ff184bb6a3c' AS k, 'العميل / Lead' AS v
UNION ALL
SELECT 'auto.7e1a0ccd0f30efcc' AS k, 'رقم العميل:' AS v
UNION ALL
SELECT 'auto.130c62f72d54eb08' AS k, 'اسم العميل' AS v
UNION ALL
SELECT 'auto.c25c95667be4a2cb' AS k, 'Client created! Scan the QR.' AS v
UNION ALL
SELECT 'auto.774c99ea171cfe8d' AS k, 'اسم العميل' AS v
UNION ALL
SELECT 'auto.4088bcbba1776388' AS k, 'تعليق *' AS v
UNION ALL
SELECT 'auto.c06e61ad6bebea17' AS k, 'تعليق / ملاحظة *' AS v
UNION ALL
SELECT 'auto.f89a4840fb844679' AS k, 'تمت إضافة التعليق' AS v
UNION ALL
SELECT 'auto.68dcd71ce6baa65c' AS k, 'تأكيد كلمة المرور الجديدة' AS v
UNION ALL
SELECT 'auto.c62ada101ff9abe6' AS k, 'Connected but DB error:' AS v
UNION ALL
SELECT 'auto.10cb217100a30699' AS k, 'Connected but could not save to DB' AS v
UNION ALL
SELECT 'auto.70416d44af6debdf' AS k, 'تم الاتصال!' AS v
UNION ALL
SELECT 'auto.716dd1a7653060c6' AS k, 'حالة الاتصال' AS v
UNION ALL
SELECT 'auto.1edb3a3b19ef87db' AS k, 'اسم الاتصال *' AS v
UNION ALL
SELECT 'auto.64a3d272d601fd00' AS k, 'مشكلة اتصال' AS v
UNION ALL
SELECT 'auto.4d09a88ff30fe08f' AS k, 'تواصل مع الزبون' AS v
) x ON x.k=tk.`key` WHERE l.code='ar';
INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, tk.id, x.v FROM languages l JOIN translation_keys tk JOIN (
SELECT 'auto.ba0f5bf3aefa7f4a' AS k, 'تواصل مع Lead' AS v
UNION ALL
SELECT 'auto.59ef057a42abf89f' AS k, 'فشل إضافة جهة الاتصال' AS v
UNION ALL
SELECT 'auto.0380cbc5a61c9743' AS k, 'يتحكم بعرض الأسعار في القوائم والمراحل وعروض الأسعار والفواتير.' AS v
UNION ALL
SELECT 'auto.3f4f74ef54d64e54' AS k, 'تعذر حفظ الصورة' AS v
UNION ALL
SELECT 'auto.bd8e2043c0836b5b' AS k, 'تعذر حفظ الصورة المرفوعة' AS v
UNION ALL
SELECT 'auto.1893d110d8416181' AS k, 'تم تحديث البلدان!' AS v
UNION ALL
SELECT 'auto.5eac4067e26a002f' AS k, 'إنشاء وإرسال الآن' AS v
UNION ALL
SELECT 'auto.eff4fd865f1aa136' AS k, 'إنشاء حساب' AS v
UNION ALL
SELECT 'auto.931868cfb93a0619' AS k, 'إنشاء حساب + صلاحية كاملة للمالك' AS v
UNION ALL
SELECT 'auto.b25c91fe6103401c' AS k, 'إنشاء مستخدم' AS v
UNION ALL
SELECT 'auto.f110f39edaed0e34' AS k, 'إنشاء عميل واتساب' AS v
UNION ALL
SELECT 'auto.35814169a764ebc5' AS k, 'إنشاء زبون جديد' AS v
UNION ALL
SELECT 'auto.479fa82ac7623e85' AS k, 'تاريخ الإنشاء' AS v
UNION ALL
SELECT 'auto.b66c8f6ee4d73f0d' AS k, 'العملة:' AS v
UNION ALL
SELECT 'auto.3d16cbd075f0c110' AS k, 'الشهر الحالي' AS v
UNION ALL
SELECT 'auto.4d5967896006c8a6' AS k, 'كلمة المرور الحالية' AS v
UNION ALL
SELECT 'auto.e95dfbea9e03b9b0' AS k, 'المستخدم الحالي' AS v
UNION ALL
SELECT 'auto.47f0e2ea5d990fd9' AS k, 'Custom API endpoint for WhatsApp integration' AS v
UNION ALL
SELECT 'auto.6e28080e1b49ea3a' AS k, 'الزبون *' AS v
UNION ALL
SELECT 'auto.23312fdbb25d40a4' AS k, 'تفاصيل الزبون' AS v
UNION ALL
SELECT 'auto.37e67c3f12e12749' AS k, 'رقم الزبون: #' AS v
UNION ALL
SELECT 'auto.c996cd1052deb897' AS k, 'معلومات الزبون' AS v
UNION ALL
SELECT 'auto.ed6073c9bb2d44bb' AS k, 'تصنيفات الزبون' AS v
UNION ALL
SELECT 'auto.75636316f9d7169a' AS k, 'اسم الزبون' AS v
UNION ALL
SELECT 'auto.e25608b4c207e7fc' AS k, 'اسم الزبون *' AS v
UNION ALL
SELECT 'auto.8651d9a02eb5b122' AS k, 'تقرير الزبائن' AS v
UNION ALL
SELECT 'auto.2ba6470eb874f29c' AS k, 'تمت إضافة الزبون' AS v
UNION ALL
SELECT 'auto.9b9dbd58338b3a06' AS k, 'اسم الزبون والمناسبة مطلوبان' AS v
UNION ALL
SELECT 'auto.5568bccdad5b1c29' AS k, 'الزبون birthdays / events / special dates' AS v
UNION ALL
SELECT 'auto.1f838468e184f9c5' AS k, 'تواصلات الزبون' AS v
UNION ALL
SELECT 'auto.b172c12346c4b8db' AS k, 'قائمة جهات اتصال الزبون' AS v
UNION ALL
SELECT 'auto.81393bb28003b7c9' AS k, 'تم حذف الزبون' AS v
UNION ALL
SELECT 'auto.8bded58ec989d7b4' AS k, 'تفاصيل الزبون' AS v
UNION ALL
SELECT 'auto.3dc64cc466b55aae' AS k, 'الزبون لا يملك' AS v
UNION ALL
SELECT 'auto.e5c5ca8ee16b3ca6' AS k, 'الزبون غير موجود' AS v
UNION ALL
SELECT 'auto.a1bc62ebf0b7f8b6' AS k, 'تقرير الزبائن' AS v
UNION ALL
SELECT 'auto.ed6485ddea94a7bc' AS k, 'مصدر الزبون' AS v
UNION ALL
SELECT 'auto.21ef9fa044ea3016' AS k, 'تم تحديث الزبون' AS v
UNION ALL
SELECT 'auto.663bc83be5eb37b9' AS k, 'الزبون ↕' AS v
UNION ALL
SELECT 'auto.56ebd803ff051e62' AS k, 'الزبائن ونتائج الإرسال' AS v
UNION ALL
SELECT 'auto.2cc1a257943ba1cc' AS k, 'الزبونs who have leads' AS v
UNION ALL
SELECT 'auto.d36f1955ad71edee' AS k, 'التاريخ *' AS v
UNION ALL
SELECT 'auto.3cf45b40c8c5fa9a' AS k, 'من تاريخ' AS v
UNION ALL
SELECT 'auto.8a23403b68250894' AS k, 'إلى تاريخ' AS v
UNION ALL
SELECT 'auto.4a6be5e9c9205f6b' AS k, 'من تاريخ' AS v
UNION ALL
SELECT 'auto.cad6bd30b38680d4' AS k, 'إلى تاريخ' AS v
UNION ALL
SELECT 'auto.a720eaba64ac0894' AS k, 'مراحل الصفقات' AS v
UNION ALL
SELECT 'auto.23319b2f20da9a33' AS k, 'طريقة عرض الـLeads الافتراضية' AS v
UNION ALL
SELECT 'auto.f82b602271f6f355' AS k, 'تم تحديث البريد الافتراضي!' AS v
UNION ALL
SELECT 'auto.840023606d8ecb5a' AS k, 'حذف هذه الحملة؟' AS v
UNION ALL
SELECT 'auto.8ba0355f5ba1eeb3' AS k, 'حذف هذا الـLead؟ لا يمكن التراجع.' AS v
UNION ALL
SELECT 'auto.860b588ede1e2523' AS k, 'حذف هذه المناسبة؟' AS v
UNION ALL
SELECT 'auto.d73eacb22cdd94a3' AS k, 'تم الحذف!' AS v
UNION ALL
SELECT 'auto.1ebe50c1080b1a5a' AS k, 'Demo: admin@sharkcrm.com / admin123' AS v
UNION ALL
SELECT 'auto.0ac7c388e19a25f9' AS k, 'Disconnect WhatsApp and remove from CRM?' AS v
UNION ALL
SELECT 'auto.7513f9647738208d' AS k, 'Due:' AS v
UNION ALL
SELECT 'auto.ad5d2c3c14a2d632' AS k, 'Duplicate lead found' AS v
UNION ALL
SELECT 'auto.5707351bdab71c0d' AS k, 'فلتر ديناميكي' AS v
UNION ALL
SELECT 'auto.859bdc1b54392984' AS k, 'فلاتر ديناميكية' AS v
UNION ALL
SELECT 'auto.ed6b5da66f916a67' AS k, 'تعديل الزبون' AS v
) x ON x.k=tk.`key` WHERE l.code='ar';
INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, tk.id, x.v FROM languages l JOIN translation_keys tk JOIN (
SELECT 'auto.0e457253adf2c3d8' AS k, 'تعديل المستخدم' AS v
UNION ALL
SELECT 'auto.604e4bff227bfca6' AS k, 'البريد *' AS v
UNION ALL
SELECT 'auto.09ba557fd106f101' AS k, 'عنوان البريد' AS v
UNION ALL
SELECT 'auto.ccde2b55da470573' AS k, 'رسالة البريد' AS v
UNION ALL
SELECT 'auto.ac4b5e72e8975a00' AS k, 'موضوع البريد' AS v
UNION ALL
SELECT 'auto.4445224d24f7b550' AS k, 'تمت إضافة البريد!' AS v
UNION ALL
SELECT 'auto.7ea736982db10e34' AS k, 'البريد address that will appear as sender when sending emails from CRM' AS v
UNION ALL
SELECT 'auto.50a509f0ffa6047a' AS k, 'نموذج البريد غير موجود' AS v
UNION ALL
SELECT 'auto.82a8f0699c2fb634' AS k, 'تم إرسال البريد' AS v
UNION ALL
SELECT 'auto.990aa5c0892b4086' AS k, 'تم إرسال البريد بنجاح' AS v
UNION ALL
SELECT 'auto.7c9526afc3092cc0' AS k, 'البريد ↕' AS v
UNION ALL
SELECT 'auto.73b64b2588a4b71f' AS k, 'الإيميلات المرسلة' AS v
UNION ALL
SELECT 'auto.8aa8acf58374de73' AS k, 'الإنكليزي / النص الأساسي' AS v
UNION ALL
SELECT 'auto.efd8461ad1d5019d' AS k, 'أدخل اسم الاتصال' AS v
UNION ALL
SELECT 'auto.2561af4e3ae4688b' AS k, 'أدخل البريد' AS v
UNION ALL
SELECT 'auto.684bf9adf06738ec' AS k, 'أدخل اسم التصنيف' AS v
UNION ALL
SELECT 'auto.04ef342212565aac' AS k, 'أدخل اسم المرحلة' AS v
UNION ALL
SELECT 'auto.8cdbba4325ba3ffd' AS k, 'أدخل بريدك' AS v
UNION ALL
SELECT 'auto.162d53ad8adaa819' AS k, 'خطأ في تحميل الزبون' AS v
UNION ALL
SELECT 'auto.787aa1617c370e45' AS k, 'خطأ:' AS v
UNION ALL
SELECT 'auto.fb7328a3c8497e3c' AS k, 'السعر المتوقع' AS v
UNION ALL
SELECT 'auto.9b22572484c3c8de' AS k, 'السعر المتوقع' AS v
UNION ALL
SELECT 'auto.6a71ed46899318d2' AS k, 'فشل تحميل المنتج' AS v
UNION ALL
SELECT 'auto.a879a2dbde3c4d31' AS k, 'فشل تحديث المرحلة' AS v
UNION ALL
SELECT 'auto.7fed9f64c55ad19d' AS k, 'فلترة حسب التصنيف' AS v
UNION ALL
SELECT 'auto.4c29f7f0335807c2' AS k, 'نسيت كلمة المرور؟' AS v
UNION ALL
SELECT 'auto.6b7587a9cdd9a908' AS k, 'من تاريخ' AS v
UNION ALL
SELECT 'auto.411b616bf22e6a46' AS k, 'صلاحية كاملة للصفحة' AS v
UNION ALL
SELECT 'auto.b62f154091188177' AS k, 'تذكير عام للزبون' AS v
UNION ALL
SELECT 'auto.5b7992e2d57b5b50' AS k, 'تذكير عام - بدون Lead' AS v
UNION ALL
SELECT 'auto.d2804b4b3c89a5b5' AS k, 'إعطاء كل الصلاحيات' AS v
UNION ALL
SELECT 'auto.b673e054d448cc1f' AS k, 'إعطاء كل الصفحات' AS v
UNION ALL
SELECT 'auto.2e737fffa287c4a9' AS k, 'Give your WhatsApp connection a name, then scan the QR code with your phone.' AS v
UNION ALL
SELECT 'auto.89a33439d1c6698e' AS k, 'Google Ads / سوشيال / غيره' AS v
UNION ALL
SELECT 'auto.6c9562014ef361ef' AS k, 'رسوم بيانية لنشاط الزبائن والـLeads الرابحة وعروض الأسعار والقيمة المقبولة.' AS v
UNION ALL
SELECT 'auto.0ff183912b1ec455' AS k, 'لديه Leads' AS v
UNION ALL
SELECT 'auto.51c1987c5523abe5' AS k, 'Has leads or leads on specific items' AS v
UNION ALL
SELECT 'auto.65611e9520e76814' AS k, 'مرحباً،' AS v
UNION ALL
SELECT 'auto.91e60261c06a1ca5' AS k, 'طريقة المسح:' AS v
UNION ALL
SELECT 'auto.5c9a22ce8000c8fe' AS k, 'If you did not request this, ignore this email.' AS v
UNION ALL
SELECT 'auto.2ae508df1173fa8e' AS k, 'الصورة كبيرة جداً. الحد 5MB' AS v
UNION ALL
SELECT 'auto.5975bc26bade01a4' AS k, 'الصورة اختيارية' AS v
UNION ALL
SELECT 'auto.0da7dbb70c1cea38' AS k, 'تم حذف الصورة' AS v
UNION ALL
SELECT 'auto.b7e01618f4bc9d3f' AS k, 'الصورة كبيرة جداً. الحد 5MB' AS v
UNION ALL
SELECT 'auto.ed893f3754b3cc44' AS k, 'فشل رفع الصورة' AS v
UNION ALL
SELECT 'auto.ea79fccf74865d76' AS k, 'إرفاق صورة المنتج إذا وجدت' AS v
UNION ALL
SELECT 'auto.84fd64a1166caa77' AS k, 'إجراء غير صالح' AS v
UNION ALL
SELECT 'auto.1b33c005ef316797' AS k, 'نوع الصورة غير صالح' AS v
UNION ALL
SELECT 'auto.8fee112a49deb677' AS k, 'نوع الصورة غير صالح. المسموح: JPG, PNG, GIF, WEBP' AS v
UNION ALL
SELECT 'auto.e7bec95431b3640a' AS k, 'المنتج' AS v
UNION ALL
SELECT 'auto.497c978bc23e248e' AS k, 'اسم المنتج' AS v
UNION ALL
SELECT 'auto.31b8182f1c05c365' AS k, 'تم حذف المنتج' AS v
UNION ALL
SELECT 'auto.6eb32428ccdc840d' AS k, 'المنتج name already exists. Do you still want to save it?' AS v
UNION ALL
SELECT 'auto.109547ba1b215d09' AS k, 'المنتجات *' AS v
UNION ALL
SELECT 'auto.365dd7eaa96ff276' AS k, 'المنتجات المعروضة' AS v
UNION ALL
SELECT 'auto.2f6eaf49d99fce6b' AS k, 'JPG, PNG, GIF, WEBP up to 5MB' AS v
UNION ALL
SELECT 'auto.204eb333cec5081a' AS k, 'JPG, PNG, WEBP, GIF — max 5MB each' AS v
UNION ALL
SELECT 'auto.1cbd6495f2602a3d' AS k, 'عرض Kanban' AS v
UNION ALL
SELECT 'auto.c88a59de1ffbe10a' AS k, 'تم حفظ التصنيفات' AS v
UNION ALL
SELECT 'auto.4c24525b0aa0b06f' AS k, 'آخر تعديل' AS v
) x ON x.k=tk.`key` WHERE l.code='ar';
INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, tk.id, x.v FROM languages l JOIN translation_keys tk JOIN (
SELECT 'auto.0e544718ed9a67be' AS k, 'Lead / زبون' AS v
UNION ALL
SELECT 'auto.8b2d0aace3e6995c' AS k, 'تفاصيل الـLead' AS v
UNION ALL
SELECT 'auto.9334d1f365c47876' AS k, 'معلومات الـLead' AS v
UNION ALL
SELECT 'auto.af0c9d68d44ded1e' AS k, 'منتجات الـLead' AS v
UNION ALL
SELECT 'auto.50564efb22d9783b' AS k, 'مرجع الـLead: #' AS v
UNION ALL
SELECT 'auto.0036008febac6b75' AS k, 'تمت إضافة الـLead!' AS v
UNION ALL
SELECT 'auto.b84bc0066188d43c' AS k, 'تم حذف الـLead' AS v
UNION ALL
SELECT 'auto.cfb93ca9046e7b04' AS k, 'صفحة تفاصيل الـLead' AS v
UNION ALL
SELECT 'auto.cde1ef3e0ff4021d' AS k, 'متابعات الـLead' AS v
UNION ALL
SELECT 'auto.a2a05a18c5be8f22' AS k, 'نتائج الـLead' AS v
UNION ALL
SELECT 'auto.c3a4e7b9bcb2f127' AS k, 'عدد الـLeads' AS v
UNION ALL
SELECT 'auto.a83d6707b34fcd01' AS k, 'اتركه فارغاً للإبقاء على كلمة المرور الحالية' AS v
UNION ALL
SELECT 'auto.5bd27abe8787c1d3' AS k, 'الرقم اللبناني يجب أن يكون 8 أرقام ويبدأ بـ 71 أو 76 أو 78 أو 81' AS v
UNION ALL
SELECT 'auto.4924c4717b17e19a' AS k, 'Lebanon / Qatar / ...' AS v
UNION ALL
SELECT 'auto.95a5696457a713b1' AS k, 'ربط جهاز' AS v
UNION ALL
SELECT 'auto.ef0544d06f13f1bc' AS k, 'ربط بزبون' AS v
UNION ALL
SELECT 'auto.fe25bb97b5774f18' AS k, 'ربط بـLead' AS v
UNION ALL
SELECT 'auto.0a5a1885e9d10d99' AS k, 'الربط بـLead اختياري' AS v
UNION ALL
SELECT 'auto.1c734f776206fcfe' AS k, 'Link your WhatsApp number to send messages directly from the CRM' AS v
UNION ALL
SELECT 'auto.1e2ea95bd8c66bb8' AS k, 'الأجهزة المرتبطة' AS v
UNION ALL
SELECT 'auto.a2b54c63fefe35ac' AS k, 'Lead مرتبط:' AS v
UNION ALL
SELECT 'auto.e1a4ed370f85b911' AS k, 'مطابقة مباشرة' AS v
UNION ALL
SELECT 'auto.5f38e52899ca0965' AS k, 'جاري تحميل QR...' AS v
UNION ALL
SELECT 'auto.19edcb1cc92194ae' AS k, 'الصفقات الخاسرة' AS v
UNION ALL
SELECT 'auto.e27baae119c37624' AS k, 'أسباب الخسارة' AS v
UNION ALL
SELECT 'auto.f299e2a71b2a6e82' AS k, 'تم تحديث سبب الخسارة!' AS v
UNION ALL
SELECT 'auto.c96a023948d6a1fb' AS k, 'مكتبة البريد غير موجودة' AS v
UNION ALL
SELECT 'auto.9a34917c9c0c3b5f' AS k, 'إدارة الفئات' AS v
UNION ALL
SELECT 'auto.bbd43baf66e66724' AS k, 'تم تحديده كمنجز!' AS v
UNION ALL
SELECT 'auto.9cf1b68c1b0ef27b' AS k, 'تم إرسال الرسالة' AS v
UNION ALL
SELECT 'auto.55086199cbe335ef' AS k, 'تم إرسال الرسالة بنجاح!' AS v
UNION ALL
SELECT 'auto.75c20a8df1cd57b5' AS k, 'سجل الرسائل' AS v
UNION ALL
SELECT 'auto.cd0103c9dc57b871' AS k, 'البريد ناقص' AS v
UNION ALL
SELECT 'auto.c91eddc42e53c5e4' AS k, 'رقم الهاتف ناقص' AS v
UNION ALL
SELECT 'auto.0aa16763d5540c86' AS k, 'حقول مطلوبة ناقصة' AS v
UNION ALL
SELECT 'auto.d145bb8309369d67' AS k, 'الاسم *' AS v
UNION ALL
SELECT 'auto.f3cb09d2ff12705c' AS k, 'الاسم / الوصف' AS v
UNION ALL
SELECT 'auto.6cc153f0e5df62ff' AS k, 'خطأ في الشبكة' AS v
UNION ALL
SELECT 'auto.b6c7606793d40447' AS k, 'خطأ في الشبكة:' AS v
UNION ALL
SELECT 'auto.b0b2e19c22ae857b' AS k, 'جديد / Won / Lost are fixed system stage types. جديد custom stages are Normal only.' AS v
UNION ALL
SELECT 'auto.c3c81792c6eae709' AS k, 'تصنيف جديد' AS v
UNION ALL
SELECT 'auto.4894cb39ee419a77' AS k, 'كلمة مرور جديدة' AS v
UNION ALL
SELECT 'auto.dcef481f416ae056' AS k, 'كلمة مرور جديدة (اتركها فارغة للإبقاء على الحالية)' AS v
UNION ALL
SELECT 'auto.cb9d9eb81406a0b1' AS k, 'عرض سعر جديد' AS v
UNION ALL
SELECT 'auto.613871df7059d69c' AS k, 'الشهر التالي ›' AS v
UNION ALL
SELECT 'auto.0efc9a1e49d54c8b' AS k, 'بدون دور' AS v
UNION ALL
SELECT 'auto.36dab9c15ad94f9d' AS k, 'لم يرجع رقم حملة واتساب' AS v
UNION ALL
SELECT 'auto.fffbd89ac26e5e43' AS k, 'لا توجد نشاطات بعد' AS v
UNION ALL
SELECT 'auto.4271877166d243b6' AS k, 'لا يوجد جمهور' AS v
UNION ALL
SELECT 'auto.108a9f6ec9801757' AS k, 'لم يرجع رقم الحملة' AS v
UNION ALL
SELECT 'auto.cd25b633452cb562' AS k, 'لا توجد حملات' AS v
UNION ALL
SELECT 'auto.d14da379465a287c' AS k, 'لا توجد تعليقات بعد' AS v
UNION ALL
SELECT 'auto.b7691e85c2db15f8' AS k, 'لا توجد تواصلات' AS v
UNION ALL
SELECT 'auto.d6b56f0bec2d3fa2' AS k, 'لا توجد جهات اتصال' AS v
UNION ALL
SELECT 'auto.15600999ccafc014' AS k, 'لا يوجد زبائن' AS v
UNION ALL
SELECT 'auto.5288ca15b1bada56' AS k, 'لا يوجد زبائن' AS v
UNION ALL
SELECT 'auto.d802d232a85b790c' AS k, 'لا توجد بيانات' AS v
UNION ALL
SELECT 'auto.8393a2700f281fb6' AS k, 'لا توجد بيانات' AS v
UNION ALL
SELECT 'auto.1fc50aae4cc0755f' AS k, 'لا توجد إيميلات مضافة بعد.' AS v
UNION ALL
SELECT 'auto.da82049bdffc666c' AS k, 'لا توجد منتجات بعد — أضف أول منتج أو خدمة!' AS v
) x ON x.k=tk.`key` WHERE l.code='ar';
INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, tk.id, x.v FROM languages l JOIN translation_keys tk JOIN (
SELECT 'auto.ebcb3369a14b3f5e' AS k, 'لا توجد تصنيفات' AS v
UNION ALL
SELECT 'auto.68cdb29b59400497' AS k, 'لا يوجد Leads' AS v
UNION ALL
SELECT 'auto.2f071731f140dda9' AS k, 'لا يوجد Leads حسب الفلاتر الحالية' AS v
UNION ALL
SELECT 'auto.d1b908935f692907' AS k, 'لا يوجد Leads بعد' AS v
UNION ALL
SELECT 'auto.40b50d4ffbb3d299' AS k, 'لا توجد رسائل' AS v
UNION ALL
SELECT 'auto.8587bb10da94de52' AS k, 'لا يوجد زبائن جدد للإضافة' AS v
UNION ALL
SELECT 'auto.9e3289b537352666' AS k, 'لا توجد ملاحظة بعد.' AS v
UNION ALL
SELECT 'auto.f03eb1de1e64d4aa' AS k, 'لا توجد ملاحظات' AS v
UNION ALL
SELECT 'auto.396c8bcb2c85ff7b' AS k, 'لا توجد مناسبات' AS v
UNION ALL
SELECT 'auto.2d611cdaf732edb3' AS k, 'لا توجد عروض أسعار' AS v
UNION ALL
SELECT 'auto.15281f7890821113' AS k, 'لا توجد تذكيرات' AS v
UNION ALL
SELECT 'auto.d5a0131c67c4e00c' AS k, 'لا توجد تذكيرات بعد' AS v
UNION ALL
SELECT 'auto.e2dc86caab47bb92' AS k, 'لا توجد نتائج بعد' AS v
UNION ALL
SELECT 'auto.1a92c0e3e058ba4f' AS k, 'لا توجد مصادر.' AS v
UNION ALL
SELECT 'auto.114a7c9f5347a062' AS k, 'لا توجد تذكيرات قادمة' AS v
UNION ALL
SELECT 'auto.692c4c2ae2e1e1c8' AS k, 'لا توجد صفقات رابحة' AS v
UNION ALL
SELECT 'auto.582fc6dcd75ef166' AS k, 'غير مضاف' AS v
UNION ALL
SELECT 'auto.61e25f419928cef9' AS k, 'تم حفظ الملاحظة!' AS v
UNION ALL
SELECT 'auto.550ebf29d1bd2e71' AS k, 'Number used for sending SMS messages via your SMS gateway' AS v
UNION ALL
SELECT 'auto.c862e9121feddc26' AS k, 'اسم المناسبة *' AS v
UNION ALL
SELECT 'auto.0610e4e7a74309f8' AS k, 'تمت إضافة المناسبة' AS v
UNION ALL
SELECT 'auto.cf41d049c759dce4' AS k, 'تم حذف المناسبة' AS v
UNION ALL
SELECT 'auto.da3796977c5863e1' AS k, 'تم تحديث المناسبة' AS v
UNION ALL
SELECT 'auto.96c7ced5933090c3' AS k, 'فتح Lead' AS v
UNION ALL
SELECT 'auto.7895d0d5b36182ce' AS k, 'افتح واتساب على هاتفك' AS v
UNION ALL
SELECT 'auto.c73da6d5916d3187' AS k, 'فتح البلدان' AS v
UNION ALL
SELECT 'auto.46d4edeb0899883f' AS k, 'فتح فلاتر الـLeads' AS v
UNION ALL
SELECT 'auto.c0c981bb364d92f2' AS k, 'نسبة الفرصة %' AS v
UNION ALL
SELECT 'auto.c30d3057c0e60554' AS k, 'أو ارفع صورة جديدة' AS v
UNION ALL
SELECT 'auto.bfe4cd42d2b330fb' AS k, 'تذكيرات متأخرة' AS v
UNION ALL
SELECT 'auto.d5378e60d0ee06d3' AS k, 'نظرة عامة وإحصائيات' AS v
UNION ALL
SELECT 'auto.a0435e0cd039c5e9' AS k, 'بريد المالك' AS v
UNION ALL
SELECT 'auto.e5a05515a7590c59' AS k, 'كلمة مرور المالك' AS v
UNION ALL
SELECT 'auto.5a886140f6183d5e' AS k, 'صلاحية الصفحة' AS v
UNION ALL
SELECT 'auto.b4c9fe4c165848d4' AS k, 'صلاحية الصفحة' AS v
UNION ALL
SELECT 'auto.c006e57e66ae1391' AS k, 'تم حفظ صلاحية الصفحة!' AS v
UNION ALL
SELECT 'auto.7cc2398c384f61f0' AS k, 'كلمة المرور *' AS v
UNION ALL
SELECT 'auto.79167df1dd0bc2f6' AS k, 'إعادة تعيين كلمة المرور' AS v
UNION ALL
SELECT 'auto.2e56251139c06b98' AS k, 'تم تحديث كلمة المرور!' AS v
UNION ALL
SELECT 'auto.d69c3b1ac54be7da' AS k, 'كلمات المرور غير متطابقة' AS v
UNION ALL
SELECT 'auto.61266b2f848f7b32' AS k, 'تذكيرات معلقة' AS v
UNION ALL
SELECT 'auto.d016004473e0e58d' AS k, 'الصلاحية مرفوضة' AS v
UNION ALL
SELECT 'auto.2cdac5659132caac' AS k, 'رقم الهاتف يجب أن يكون بين 5 و 15 رقم' AS v
UNION ALL
SELECT 'auto.cf72db517bc1a3b4' AS k, 'الهاتف ↕' AS v
UNION ALL
SELECT 'auto.daeea4d0cc37b1e4' AS k, 'الهاتف:' AS v
UNION ALL
SELECT 'auto.d4d9d46adf8e6ecb' AS k, 'نظرة عامة على Pipeline' AS v
UNION ALL
SELECT 'auto.c9ef3018c5bc9a06' AS k, 'قيمة Pipeline' AS v
UNION ALL
SELECT 'auto.8ec4350688e3d1e5' AS k, 'اختر ملف صورة' AS v
UNION ALL
SELECT 'auto.2c59e44512710eac' AS k, 'أدخل تعليق' AS v
UNION ALL
SELECT 'auto.d2b8f68e05729b9c' AS k, 'أدخل رسالة' AS v
UNION ALL
SELECT 'auto.5ec5a131a90ffe8e' AS k, 'أدخل سبب' AS v
UNION ALL
SELECT 'auto.1314162e06d1d734' AS k, 'أدخل موضوع' AS v
UNION ALL
SELECT 'auto.31e70aa5003993b9' AS k, 'أدخل ملاحظات النشاط' AS v
UNION ALL
SELECT 'auto.4187bf72eab2fd9f' AS k, 'أدخل تعليق التذكير' AS v
UNION ALL
SELECT 'auto.f14b5de4c7317b85' AS k, 'أدخل ملاحظة التذكير' AS v
UNION ALL
SELECT 'auto.cf172b5a3ed69934' AS k, 'اختر زبون صحيح من القائمة' AS v
UNION ALL
SELECT 'auto.138a107c3f03bdf3' AS k, 'اختر تاريخ النشاط' AS v
UNION ALL
SELECT 'auto.9eb4e8066ae5d517' AS k, 'اختر تاريخ التذكير' AS v
UNION ALL
SELECT 'auto.f301ca24f18b8ab6' AS k, 'ضع رقم واتساب أولاً' AS v
UNION ALL
SELECT 'auto.e3342938730237f4' AS k, 'ضع عنوان البريد أولاً' AS v
) x ON x.k=tk.`key` WHERE l.code='ar';
INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, tk.id, x.v FROM languages l JOIN translation_keys tk JOIN (
SELECT 'auto.e1f2cef844f58f84' AS k, 'Please use this code to reset your password.' AS v
UNION ALL
SELECT 'auto.0550397c011cf036' AS k, 'وجّه هاتفك إلى رمز QR' AS v
UNION ALL
SELECT 'auto.54cc0b907d18376d' AS k, 'نشر تعليق' AS v
UNION ALL
SELECT 'auto.3e9e6dc06f0f7b75' AS k, 'رسالة جاهزة' AS v
UNION ALL
SELECT 'auto.787004617d6c907d' AS k, 'خانات السعر العشرية' AS v
UNION ALL
SELECT 'auto.a9a48e298b62a977' AS k, 'تم تحديث الصورة الأساسية' AS v
UNION ALL
SELECT 'auto.096ac757f008bf12' AS k, 'الأولوية (نجوم)' AS v
UNION ALL
SELECT 'auto.a416758713cef691' AS k, 'Priority (min ★)' AS v
UNION ALL
SELECT 'auto.d6f9b1ddf5f8b424' AS k, 'Priority ↕' AS v
UNION ALL
SELECT 'auto.b274922fb5ee0fee' AS k, 'Priority ≥' AS v
UNION ALL
SELECT 'auto.f7cbf7fa4b2e5188' AS k, 'إحصائيات سريعة' AS v
UNION ALL
SELECT 'auto.496ad2c33c51378e' AS k, 'أزرار تواصل سريعة' AS v
UNION ALL
SELECT 'auto.d2e53d19c0ea8c61' AS k, 'تم حفظ عرض السعر' AS v
UNION ALL
SELECT 'auto.239605e2fd225030' AS k, 'حالة عروض الأسعار' AS v
UNION ALL
SELECT 'auto.0c76fd5dd8ec7360' AS k, 'السبب *' AS v
UNION ALL
SELECT 'auto.a9b8f0e4874aee79' AS k, 'أحدث الـLeads' AS v
UNION ALL
SELECT 'auto.f4bd058430049d1f' AS k, 'التذكير Calendar -' AS v
UNION ALL
SELECT 'auto.544b89a212f95e05' AS k, 'تاريخ التذكير' AS v
UNION ALL
SELECT 'auto.18e5b40b9f9a7a25' AS k, 'وقت التذكير' AS v
UNION ALL
SELECT 'auto.e26907db8b4f0993' AS k, 'نوع التذكير' AS v
UNION ALL
SELECT 'auto.ca0d0e2a9c6ed0f6' AS k, 'تمت إضافة التذكير' AS v
UNION ALL
SELECT 'auto.3fb75e3bfe4de94e' AS k, 'إعادة تعيين كلمة المرور' AS v
UNION ALL
SELECT 'auto.b0d21bb97899242d' AS k, 'الإيرادات الرابحة' AS v
UNION ALL
SELECT 'auto.e05cd6a268b6cfcd' AS k, 'تم تحديث الدور!' AS v
UNION ALL
SELECT 'auto.62cc0077ab92adee' AS k, 'SALES INTELLIGENCE PLATFORM' AS v
UNION ALL
SELECT 'auto.a75e9bb679c2ba5a' AS k, 'رسالة SMS' AS v
UNION ALL
SELECT 'auto.9b1f098d6cdf02c7' AS k, 'تم إرسال SMS' AS v
UNION ALL
SELECT 'auto.1f767c71d82544b1' AS k, 'تم إرسال SMS' AS v
UNION ALL
SELECT 'auto.ac4178b3bdb5a6df' AS k, 'كلمة مرور SMTP' AS v
UNION ALL
SELECT 'auto.40ec4bdc33210b19' AS k, 'منفذ SMTP' AS v
UNION ALL
SELECT 'auto.c05323ba9bd468d6' AS k, 'اسم مستخدم SMTP' AS v
UNION ALL
SELECT 'auto.16fc9a95a9622472' AS k, 'حفظ الصلاحية' AS v
UNION ALL
SELECT 'auto.5ce047a8004f12d6' AS k, 'حفظ الإجراء' AS v
UNION ALL
SELECT 'auto.09a1f4de4200e82a' AS k, 'حفظ الجمهور' AS v
UNION ALL
SELECT 'auto.a1f54af431bdf6bd' AS k, 'حفظ الفئة' AS v
UNION ALL
SELECT 'auto.fa2984b367b8f2fc' AS k, 'حفظ التغييرات' AS v
UNION ALL
SELECT 'auto.ffe9f842d7595338' AS k, 'حفظ الزبون' AS v
UNION ALL
SELECT 'auto.ea0e082d4d4bdffb' AS k, 'حفظ المنتج' AS v
UNION ALL
SELECT 'auto.e9b75b84826ca78c' AS k, 'حفظ التصنيفات' AS v
UNION ALL
SELECT 'auto.80062221da9bd4c5' AS k, 'حفظ Lead' AS v
UNION ALL
SELECT 'auto.f2158988d5389f65' AS k, 'حفظ فقط' AS v
UNION ALL
SELECT 'auto.2f5f40a6f06003d2' AS k, 'حفظ الصلاحيات' AS v
UNION ALL
SELECT 'auto.cb406af9a43e5af7' AS k, 'حفظ عرض السعر' AS v
UNION ALL
SELECT 'auto.a13e3a61e9da556c' AS k, 'حفظ التذكير' AS v
UNION ALL
SELECT 'auto.047744aab5d1cfaf' AS k, 'حفظ الترجمات' AS v
UNION ALL
SELECT 'auto.82f6b304226ae488' AS k, 'جمهور محفوظ' AS v
UNION ALL
SELECT 'auto.05bd4f15f00bbbde' AS k, 'تم الحفظ! جاري إعادة التحميل...' AS v
UNION ALL
SELECT 'auto.76af964d40827982' AS k, 'جاري الحفظ في قاعدة البيانات...' AS v
UNION ALL
SELECT 'auto.4bbb1900e059cb03' AS k, 'امسح رمز QR بواسطة واتساب' AS v
UNION ALL
SELECT 'auto.5e8f2d6c5e3aa39a' AS k, 'اختر الجمهور' AS v
UNION ALL
SELECT 'auto.434b368d8f47d5aa' AS k, 'اختر البلد' AS v
UNION ALL
SELECT 'auto.f4801ffc34e0d666' AS k, 'اختر المرحلة' AS v
UNION ALL
SELECT 'auto.c875cbd5b1af621d' AS k, 'اختر المستخدم' AS v
UNION ALL
SELECT 'auto.5cd4d2fedc4221f0' AS k, 'اختر مستخدم من القائمة.' AS v
UNION ALL
SELECT 'auto.64d530273135c8fd' AS k, 'Select a user to set page/action permissions.' AS v
UNION ALL
SELECT 'auto.08e975daa72ed44e' AS k, 'اختر جمهور قبل حفظ الحملة' AS v
UNION ALL
SELECT 'auto.3fa212a7b076147b' AS k, 'اختر الجمهور لرؤية عدد الزبائن.' AS v
UNION ALL
SELECT 'auto.6817176b830546e6' AS k, 'اختر الزبون' AS v
UNION ALL
SELECT 'auto.e58e97bb67daed20' AS k, 'اختر المصدر' AS v
UNION ALL
SELECT 'auto.f52423e61ba196ab' AS k, 'اختر المرحلة...' AS v
) x ON x.k=tk.`key` WHERE l.code='ar';
INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, tk.id, x.v FROM languages l JOIN translation_keys tk JOIN (
SELECT 'auto.fd192fa7ad074115' AS k, 'اختر النوع...' AS v
UNION ALL
SELECT 'auto.eb081600325e72fb' AS k, 'اختر المستخدم أولاً' AS v
UNION ALL
SELECT 'auto.b30fa35abc3f3b0f' AS k, 'إرسال الحملة الآن' AS v
UNION ALL
SELECT 'auto.5192082ccb9ba9f1' AS k, 'إرسال التفاصيل' AS v
UNION ALL
SELECT 'auto.b8ec554332fca521' AS k, 'إرسال رابط إعادة التعيين' AS v
UNION ALL
SELECT 'auto.431b04c21a4bb8aa' AS k, 'إرسال this campaign now? You cannot send it again after it is marked sent.' AS v
UNION ALL
SELECT 'auto.6eaa24bb52ca2503' AS k, 'تعيين افتراضي' AS v
UNION ALL
SELECT 'auto.5b6f739130d00f54' AS k, 'تعيين كافتراضي' AS v
UNION ALL
SELECT 'auto.0263e40259594203' AS k, 'Set up default contact methods for sending WhatsApp, SMS, and البريد from leads' AS v
UNION ALL
SELECT 'auto.b4a3b2ff89a79db0' AS k, 'Shark CRM /' AS v
UNION ALL
SELECT 'auto.b96354f9e51f3284' AS k, 'Shark CRM Big Admin' AS v
UNION ALL
SELECT 'auto.63400cad7cc3283b' AS k, 'Shark CRM –' AS v
UNION ALL
SELECT 'auto.704832844dbefc38' AS k, 'Shark CRM – Login' AS v
UNION ALL
SELECT 'auto.4048a11f85e15bd0' AS k, 'عرض 0' AS v
UNION ALL
SELECT 'auto.91a980fb1e0fbb76' AS k, 'عرض 0.00' AS v
UNION ALL
SELECT 'auto.1cca4735cf5f9bc8' AS k, 'تسجيل الدخول →' AS v
UNION ALL
SELECT 'auto.bb7e79e8f7bf8c83' AS k, 'Since ↕' AS v
UNION ALL
SELECT 'auto.2ddfb8dbb883d3db' AS k, 'مستلمون محددون' AS v
UNION ALL
SELECT 'auto.913dfabc03e3841e' AS k, 'تاريخ محدد' AS v
UNION ALL
SELECT 'auto.181c1139f12b7b05' AS k, 'اسم المرحلة *' AS v
UNION ALL
SELECT 'auto.b5c005dde9612ec6' AS k, 'تمت إضافة المرحلة!' AS v
UNION ALL
SELECT 'auto.c6c88ddf17dcf599' AS k, 'تم حذف المرحلة' AS v
UNION ALL
SELECT 'auto.75334b0c6abe10b9' AS k, 'تم تحديث المرحلة' AS v
UNION ALL
SELECT 'auto.5289765264e85269' AS k, 'تم تحديث المرحلة!' AS v
UNION ALL
SELECT 'auto.5a9cb8497b791640' AS k, 'فلتر اختيار المراحل' AS v
UNION ALL
SELECT 'auto.11dc9e1952928d4c' AS k, 'الحالة:' AS v
UNION ALL
SELECT 'auto.d64fc80f74003153' AS k, 'الأعضاء المحفوظون' AS v
UNION ALL
SELECT 'auto.cdcae857019184dd' AS k, 'الموضوع:' AS v
UNION ALL
SELECT 'auto.78674f4602f5af50' AS k, 'تم إكمال الاستبيان' AS v
UNION ALL
SELECT 'auto.b984d7095bd0f6fb' AS k, 'TVA %' AS v
UNION ALL
SELECT 'auto.170fe5272d78e236' AS k, 'اتخاذ إجراء' AS v
UNION ALL
SELECT 'auto.652ac2cbbafccc62' AS k, 'الهدف:' AS v
UNION ALL
SELECT 'auto.a12f4a2ed5e6e82e' AS k, 'أعضاء الفريق' AS v
UNION ALL
SELECT 'auto.89b360ecd0bd2e36' AS k, 'تم إرسال بريد الاختبار بنجاح!' AS v
UNION ALL
SELECT 'auto.5561918f01838562' AS k, 'The WhatsApp number will be used when you click the WhatsApp button in:' AS v
UNION ALL
SELECT 'auto.68fd1247a7dd9054' AS k, 'The email address will appear as the sender when sending emails from:' AS v
UNION ALL
SELECT 'auto.a810bcec2983c58e' AS k, 'This logo appears on quotation/invoice print pages.' AS v
UNION ALL
SELECT 'auto.1f8133cb29f755f9' AS k, 'الجدول الزمني والتعليقات' AS v
UNION ALL
SELECT 'auto.ea7490888dd7c691' AS k, 'Tip: select all active stages and leave Lost/Won unchecked.' AS v
UNION ALL
SELECT 'auto.642cced347dab857' AS k, 'إلى تاريخ' AS v
UNION ALL
SELECT 'auto.7e7fbc811015943c' AS k, 'إلى:' AS v
UNION ALL
SELECT 'auto.74ae5d0fdbe0cddf' AS k, 'تذكيرات اليوم' AS v
UNION ALL
SELECT 'auto.89a36344d72896d4' AS k, 'أفضل الزبائن حسب الـLeads' AS v
UNION ALL
SELECT 'auto.d4fc4a41820bf984' AS k, 'إجمالي المحاولات' AS v
UNION ALL
SELECT 'auto.413a164d589fe3b3' AS k, 'إجمالي الـLeads' AS v
UNION ALL
SELECT 'auto.d8e7170f94e71360' AS k, 'الإجمالي:' AS v
UNION ALL
SELECT 'auto.0775b4cd2cabb81e' AS k, 'إدارة الترجمات' AS v
UNION ALL
SELECT 'auto.ee3fb11d05c90c37' AS k, 'النوع:' AS v
UNION ALL
SELECT 'auto.1eea68d093d1561b' AS k, 'سعر الوحدة' AS v
UNION ALL
SELECT 'auto.e6cb55c694b8d022' AS k, 'نوع غير معروف' AS v
UNION ALL
SELECT 'auto.d3303568cf31b880' AS k, 'التذكيرات القادمة' AS v
UNION ALL
SELECT 'auto.e607df26437e2797' AS k, 'تحديث الجمهور' AS v
UNION ALL
SELECT 'auto.5ef580aad2a08a42' AS k, 'تحديث الزبون' AS v
UNION ALL
SELECT 'auto.61dcf34e70921088' AS k, 'تحديث كلمة المرور' AS v
UNION ALL
SELECT 'auto.ad6539794a5fd881' AS k, 'تحديث المرحلة' AS v
UNION ALL
SELECT 'auto.e27738c47f3ecda8' AS k, 'تحديث المستخدم' AS v
UNION ALL
SELECT 'auto.22714274a44dd11e' AS k, 'تاريخ التحديث' AS v
UNION ALL
SELECT 'auto.58a8220ee6600f11' AS k, 'Used when clicking WhatsApp button on lead contacts' AS v
UNION ALL
SELECT 'auto.c930fd60616af19a' AS k, 'صلاحيات المستخدم' AS v
UNION ALL
SELECT 'auto.82977211a17b5e56' AS k, 'تمت إضافة المستخدم!' AS v
) x ON x.k=tk.`key` WHERE l.code='ar';
INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, tk.id, x.v FROM languages l JOIN translation_keys tk JOIN (
SELECT 'auto.882d726b0e049967' AS k, 'تم حذف المستخدم' AS v
UNION ALL
SELECT 'auto.503718be30dd257a' AS k, 'تم تحديث المستخدم!' AS v
UNION ALL
SELECT 'auto.f7745eb0e73f87d0' AS k, 'قائمة المستخدمين' AS v
UNION ALL
SELECT 'auto.a144230d85488566' AS k, 'صالح حتى' AS v
UNION ALL
SELECT 'auto.5a57c6ff3f3187ce' AS k, 'صالح حتى:' AS v
UNION ALL
SELECT 'auto.50cdc18b7b3e09a6' AS k, 'رمز التحقق' AS v
UNION ALL
SELECT 'auto.efd83559209cb6ae' AS k, 'عرض الكل' AS v
UNION ALL
SELECT 'auto.bae2691c691e5443' AS k, 'عرض الـLeads' AS v
UNION ALL
SELECT 'auto.d71400f9537868ea' AS k, 'Website / App / Pending' AS v
UNION ALL
SELECT 'auto.22077755e5f494b2' AS k, 'ربط واتساب' AS v
UNION ALL
SELECT 'auto.10d76eb6f24cb380' AS k, 'واتساب متصل' AS v
UNION ALL
SELECT 'auto.86f808611bf76612' AS k, 'صورة واتساب' AS v
UNION ALL
SELECT 'auto.4058de3ea99f8299' AS k, 'رسالة واتساب' AS v
UNION ALL
SELECT 'auto.4d8ab6fff4cbdfbd' AS k, 'معاينة واتساب' AS v
UNION ALL
SELECT 'auto.49febdcc242a211b' AS k, 'تم إرسال واتساب' AS v
UNION ALL
SELECT 'auto.2f73d3ca28f74009' AS k, 'فشل إنشاء حملة واتساب' AS v
UNION ALL
SELECT 'auto.d10e8a825d33cb32' AS k, 'عميل واتساب غير موجود' AS v
UNION ALL
SELECT 'auto.467cad16bd1ca0f0' AS k, 'تم ربط واتساب! 🎉' AS v
UNION ALL
SELECT 'auto.617c139e48bad6a2' AS k, 'فشل إضافة جهة اتصال واتساب' AS v
UNION ALL
SELECT 'auto.2095224ef81cbbdc' AS k, 'تم إرسال رسالة واتساب بنجاح' AS v
UNION ALL
SELECT 'auto.29dd389964fcf10c' AS k, 'تم إرسال واتساب' AS v
UNION ALL
SELECT 'auto.caddbe20d29a1e59' AS k, 'فشل بدء واتساب' AS v
UNION ALL
SELECT 'auto.48f8bbd487053bac' AS k, 'When opening Leads from the menu, choose list or pipeline by default.' AS v
UNION ALL
SELECT 'auto.49a383890e53d7b4' AS k, 'نسبة الربح' AS v
UNION ALL
SELECT 'auto.61c9433e5040e3b5' AS k, 'الصفقات الرابحة' AS v
UNION ALL
SELECT 'auto.95cbf72b9989e8e8' AS k, 'Leads رابحة' AS v
UNION ALL
SELECT 'auto.96b0e2eec1cc6569' AS k, 'Leads الرابحة فقط' AS v
UNION ALL
SELECT 'auto.89e7122da5844220' AS k, 'Write short internal note here. It has more padding now so it does not stick to card edge.' AS v
UNION ALL
SELECT 'auto.21fa08b1b363db37' AS k, 'نعم، احفظ على كل حال' AS v
UNION ALL
SELECT 'auto.95226b851ad80369' AS k, 'لا تملك صلاحية فتح أي تبويب في الإعدادات.' AS v
UNION ALL
SELECT 'auto.cc8b4db834d6b252' AS k, 'لا تملك صلاحية فتح هذه الصفحة.' AS v
UNION ALL
SELECT 'auto.3fa6f5fb505ace79' AS k, 'بريدك' AS v
UNION ALL
SELECT 'auto.7e9f2e0524c21813' AS k, '| البريد:' AS v
UNION ALL
SELECT 'auto.37e6657c2c3a3d8e' AS k, '| SMS:' AS v
UNION ALL
SELECT 'auto.b3196daf354114e5' AS k, '— لا يوجد category —' AS v
UNION ALL
SELECT 'auto.4635991fb59ea28a' AS k, '— Select الجمهور —' AS v
UNION ALL
SELECT 'auto.f8f7e32cb9ed71d4' AS k, '‹ الشهر السابق' AS v
UNION ALL
SELECT 'auto.c32ae9f4a77d1bb9' AS k, '← رجوع' AS v
UNION ALL
SELECT 'auto.4c2c64ee67c15c2d' AS k, '← رجوع إلى الزبائن' AS v
UNION ALL
SELECT 'auto.d66b344d32fdb5a1' AS k, '← رجوع إلى الـLeads' AS v
UNION ALL
SELECT 'auto.8a28792ab2b2b05b' AS k, '← البدء من جديد' AS v
UNION ALL
SELECT 'auto.cdbe31e76616b83b' AS k, '⋮ القائمة' AS v
UNION ALL
SELECT 'auto.510ba246a0dfe748' AS k, '⏰ التذكيرs (' AS v
UNION ALL
SELECT 'auto.678eb6275f804ede' AS k, '★ 1 Star' AS v
UNION ALL
SELECT 'auto.08ca33ab7e2a63d8' AS k, '★★ 2 Stars' AS v
UNION ALL
SELECT 'auto.80f05685b94b291b' AS k, '★★★ 3 Stars' AS v
UNION ALL
SELECT 'auto.25de639c3f435e65' AS k, '★★★★ 4 Stars' AS v
UNION ALL
SELECT 'auto.6d860244bc785068' AS k, '★★★★★ 5 Stars' AS v
UNION ALL
SELECT 'auto.079b9229cbec2efd' AS k, '☰ القائمة' AS v
UNION ALL
SELECT 'auto.cb84ac49bd0e2bd4' AS k, '⚙ إدارة المراحل' AS v
UNION ALL
SELECT 'auto.91d60ac5239da680' AS k, '⚙️ إعدادات التواصل' AS v
UNION ALL
SELECT 'auto.472e61fd3adb74f6' AS k, '⚙️ الإعدادات' AS v
UNION ALL
SELECT 'auto.a23d1f00995c4392' AS k, '✅ Take Action (' AS v
UNION ALL
SELECT 'auto.d8b55ad91d2a2181' AS k, '✉️ البريد' AS v
UNION ALL
SELECT 'auto.111426bf883193c5' AS k, '✉️ SMS' AS v
UNION ALL
SELECT 'auto.b00cd0a3d79ef0f0' AS k, '✉️ رقم SMS' AS v
UNION ALL
SELECT 'auto.89c0831acfdf4409' AS k, '✕ مسح' AS v
UNION ALL
SELECT 'auto.5c70ced3ee4c5ee8' AS k, '✕ إعادة ضبط' AS v
UNION ALL
SELECT 'auto.6a94c83bf9bed404' AS k, '⭐ حسب الأولوية' AS v
UNION ALL
SELECT 'auto.f362182160a2cc91' AS k, '🌍 البلدان المتاحة' AS v
) x ON x.k=tk.`key` WHERE l.code='ar';
INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, tk.id, x.v FROM languages l JOIN translation_keys tk JOIN (
SELECT 'auto.8b0c3fa5ac7cadac' AS k, '🌍 حسب البلد' AS v
UNION ALL
SELECT 'auto.17bf278e8d8520e3' AS k, '🌍 البلدان' AS v
UNION ALL
SELECT 'auto.2550c141a4c352e9' AS k, '🏷️ حسب التصنيفات' AS v
UNION ALL
SELECT 'auto.f1d677248ad78e6c' AS k, '👥 اختيار زبائن يدوياً' AS v
UNION ALL
SELECT 'auto.f4f44cc875aac610' AS k, '💬 Comments (' AS v
UNION ALL
SELECT 'auto.f5ab48e7ca6e725e' AS k, '💬 Communications (' AS v
UNION ALL
SELECT 'auto.726ee333bcc10620' AS k, '💬 واتساب' AS v
UNION ALL
SELECT 'auto.59aec56b0d816b36' AS k, '💾 حفظ الإعدادات' AS v
UNION ALL
SELECT 'auto.e386faacc385ea23' AS k, '💾 حفظ البلدان' AS v
UNION ALL
SELECT 'auto.0a41a0ba5be4a112' AS k, '💾 حفظ الملاحظة' AS v
UNION ALL
SELECT 'auto.e14f036b3a4d5e4d' AS k, '📁 الفئات' AS v
UNION ALL
SELECT 'auto.6d3bf27bbd34314a' AS k, '📊 Pipeline' AS v
UNION ALL
SELECT 'auto.703bcb02f01950f5' AS k, '📌 By Leads / المنتجs' AS v
UNION ALL
SELECT 'auto.f98df297e2527b8d' AS k, '📌 Leads (' AS v
UNION ALL
SELECT 'auto.7f7e135c106fc94c' AS k, '📖 طريقة الاستخدام' AS v
UNION ALL
SELECT 'auto.c76c8b9c413446c3' AS k, '📝 تعديل الملاحظة' AS v
UNION ALL
SELECT 'auto.b16ad276b6008efa' AS k, '📝 ملاحظة Lead' AS v
UNION ALL
SELECT 'auto.9bf5649007681c5d' AS k, '📝 ملاحظة' AS v
UNION ALL
SELECT 'auto.8d75daf9f88cc5da' AS k, '📝 عرض' AS v
UNION ALL
SELECT 'auto.aa3afb8cf5f261f5' AS k, '📞 جهات اتصال الزبون' AS v
UNION ALL
SELECT 'auto.a89bf7d0f859291a' AS k, '📧 البريد' AS v
UNION ALL
SELECT 'auto.ada1cccc9bd7510b' AS k, '📧 عنوان البريد المرسل' AS v
UNION ALL
SELECT 'auto.298745aefcd4d8b3' AS k, '📧 SMTP Server (اختياري)' AS v
UNION ALL
SELECT 'auto.2b377b274c3f7a1e' AS k, '📧 الإيميلات' AS v
UNION ALL
SELECT 'auto.b652ecda4a090d24' AS k, '📧 اختبار البريد' AS v
UNION ALL
SELECT 'auto.7d40f000412ac0c0' AS k, '📨 تواصل' AS v
UNION ALL
SELECT 'auto.056aa5be587a0168' AS k, '📨 إرسال' AS v
UNION ALL
SELECT 'auto.5f53e02263f13b56' AS k, '📱 SMS' AS v
UNION ALL
SELECT 'auto.0cccffb8385d7226' AS k, '📱 اختبار واتساب' AS v
UNION ALL
SELECT 'auto.90b67064a8a7a628' AS k, '📱 واتساب' AS v
UNION ALL
SELECT 'auto.b4c47b037a69e248' AS k, '📱 رقم واتساب' AS v
UNION ALL
SELECT 'auto.c7b24163063fed62' AS k, '🔄 تغيير المرحلة' AS v
UNION ALL
SELECT 'auto.a6f0979502208fde' AS k, '🔄 تحديث QR' AS v
UNION ALL
SELECT 'auto.2dd32fc55477c2bc' AS k, '🔌 فصل الاتصال' AS v
UNION ALL
SELECT 'auto.717b977a4d04c46b' AS k, '🔍 تطبيق' AS v
UNION ALL
SELECT 'auto.80bec918e85f4167' AS k, '🔍 فلاتر' AS v
UNION ALL
SELECT 'auto.6bc9d49c5faa1d4a' AS k, '🔗 ربط واتساب' AS v
UNION ALL
SELECT 'auto.ee56712e317dc08b' AS k, '🔗 WhatsApp API URL (Optional - for automated sending)' AS v
UNION ALL
SELECT 'auto.764bc1f48904976e' AS k, '🖼️ اضغط للرفع أو اسحب الصور هنا' AS v
UNION ALL
SELECT 'auto.1a25f6aae74ee883' AS k, '🗑 حذف' AS v
UNION ALL
SELECT 'auto.8fb0a9354a21c153' AS k, '🗑️ حذف' AS v
UNION ALL
SELECT 'auto.6ac74d8d37e74631' AS k, '🦈 Shark CRM Big Admin' AS v
UNION ALL
SELECT 'auto.b6572e658c41b210' AS k, '🧭 حسب المصدر' AS v
UNION ALL
SELECT 'messages.account_updated' AS k, 'تم تحديث الحساب!' AS v
UNION ALL
SELECT 'messages.activity_logged' AS k, 'تم تسجيل النشاط' AS v
UNION ALL
SELECT 'messages.added' AS k, 'تمت الإضافة!' AS v
UNION ALL
SELECT 'messages.audience_saved' AS k, 'تم حفظ الجمهور.' AS v
UNION ALL
SELECT 'messages.audience_updated' AS k, 'الجمهور updated:' AS v
UNION ALL
SELECT 'messages.campaign_create_failed' AS k, 'فشل إنشاء الحملة' AS v
UNION ALL
SELECT 'messages.campaign_deleted' AS k, 'تم حذف الحملة' AS v
UNION ALL
SELECT 'messages.campaign_saved' AS k, 'تم حفظ الحملة' AS v
UNION ALL
SELECT 'messages.campaign_saved_sending_now' AS k, 'تم حفظ الحملة. جاري الإرسال…' AS v
UNION ALL
SELECT 'messages.campaign_start_failed' AS k, 'فشل بدء الحملة' AS v
UNION ALL
SELECT 'messages.category_deleted' AS k, 'تم حذف الفئة' AS v
UNION ALL
SELECT 'messages.choose_at_least_one_dynamic_filter_customer_before_saving_campaign' AS k, 'Choose at least one dynamic filter/customer before saving campaign' AS v
UNION ALL
SELECT 'messages.client_created_scan_the_qr' AS k, 'Client created! Scan the QR.' AS v
UNION ALL
SELECT 'messages.comment_added' AS k, 'تمت إضافة التعليق' AS v
UNION ALL
SELECT 'messages.connected_but_db_error' AS k, 'Connected but DB error:' AS v
UNION ALL
SELECT 'messages.connected_but_could_not_save_to_db' AS k, 'Connected but could not save to DB' AS v
UNION ALL
SELECT 'messages.contact_add_failed' AS k, 'فشل إضافة جهة الاتصال' AS v
) x ON x.k=tk.`key` WHERE l.code='ar';
INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, tk.id, x.v FROM languages l JOIN translation_keys tk JOIN (
SELECT 'messages.could_not_save_image' AS k, 'تعذر حفظ الصورة' AS v
UNION ALL
SELECT 'messages.could_not_save_uploaded_image' AS k, 'تعذر حفظ الصورة المرفوعة' AS v
UNION ALL
SELECT 'messages.countries_updated' AS k, 'تم تحديث البلدان!' AS v
UNION ALL
SELECT 'messages.customer_added' AS k, 'تمت إضافة الزبون' AS v
UNION ALL
SELECT 'messages.customer_and_occasion_name_are_required' AS k, 'اسم الزبون والمناسبة مطلوبان' AS v
UNION ALL
SELECT 'messages.customer_deleted' AS k, 'تم حذف الزبون' AS v
UNION ALL
SELECT 'messages.customer_has_no' AS k, 'الزبون لا يملك' AS v
UNION ALL
SELECT 'messages.customer_not_found' AS k, 'الزبون غير موجود' AS v
UNION ALL
SELECT 'messages.customer_updated' AS k, 'تم تحديث الزبون' AS v
UNION ALL
SELECT 'messages.default_email_updated' AS k, 'تم تحديث البريد الافتراضي!' AS v
UNION ALL
SELECT 'messages.delete_this_campaign' AS k, 'حذف هذه الحملة؟' AS v
UNION ALL
SELECT 'messages.delete_this_lead_this_cannot_be_undone' AS k, 'حذف هذا الـLead؟ لا يمكن التراجع.' AS v
UNION ALL
SELECT 'messages.delete_this_occasion' AS k, 'حذف هذه المناسبة؟' AS v
UNION ALL
SELECT 'messages.deleted' AS k, 'تم الحذف!' AS v
UNION ALL
SELECT 'messages.disconnect_whatsapp_and_remove_from_crm' AS k, 'Disconnect WhatsApp and remove from CRM?' AS v
UNION ALL
SELECT 'messages.email_added' AS k, 'تمت إضافة البريد!' AS v
UNION ALL
SELECT 'messages.email_form_not_found' AS k, 'نموذج البريد غير موجود' AS v
UNION ALL
SELECT 'messages.email_sent' AS k, 'تم إرسال البريد' AS v
UNION ALL
SELECT 'messages.email_sent_successfully' AS k, 'تم إرسال البريد بنجاح' AS v
UNION ALL
SELECT 'messages.enter_a_connection_name' AS k, 'أدخل اسم الاتصال' AS v
UNION ALL
SELECT 'messages.enter_email' AS k, 'أدخل البريد' AS v
UNION ALL
SELECT 'messages.enter_label_name' AS k, 'أدخل اسم التصنيف' AS v
UNION ALL
SELECT 'messages.enter_stage_name' AS k, 'أدخل اسم المرحلة' AS v
UNION ALL
SELECT 'messages.enter_your_email' AS k, 'أدخل بريدك' AS v
UNION ALL
SELECT 'messages.error_loading_customer' AS k, 'خطأ في تحميل الزبون' AS v
UNION ALL
SELECT 'messages.error' AS k, 'خطأ:' AS v
UNION ALL
SELECT 'messages.failed_to_load_item' AS k, 'فشل تحميل المنتج' AS v
UNION ALL
SELECT 'messages.failed_to_update_stage' AS k, 'فشل تحديث المرحلة' AS v
UNION ALL
SELECT 'messages.image_is_too_large_max_5mb' AS k, 'الصورة كبيرة جداً. الحد 5MB' AS v
UNION ALL
SELECT 'messages.image_removed' AS k, 'تم حذف الصورة' AS v
UNION ALL
SELECT 'messages.image_too_large_max_5mb' AS k, 'الصورة كبيرة جداً. الحد 5MB' AS v
UNION ALL
SELECT 'messages.image_upload_failed' AS k, 'فشل رفع الصورة' AS v
UNION ALL
SELECT 'messages.invalid_action' AS k, 'إجراء غير صالح' AS v
UNION ALL
SELECT 'messages.invalid_image_type' AS k, 'نوع الصورة غير صالح' AS v
UNION ALL
SELECT 'messages.invalid_image_type_allowed_jpg_png_gif_webp' AS k, 'نوع الصورة غير صالح. المسموح: JPG, PNG, GIF, WEBP' AS v
UNION ALL
SELECT 'messages.item_deleted' AS k, 'تم حذف المنتج' AS v
UNION ALL
SELECT 'messages.item_name_already_exists_do_you_still_want_to_save_it' AS k, 'المنتج name already exists. Do you still want to save it?' AS v
UNION ALL
SELECT 'messages.labels_saved' AS k, 'تم حفظ التصنيفات' AS v
UNION ALL
SELECT 'messages.lead_added' AS k, 'تمت إضافة الـLead!' AS v
UNION ALL
SELECT 'messages.lead_deleted' AS k, 'تم حذف الـLead' AS v
UNION ALL
SELECT 'messages.lebanese_number_must_be_8_digits_starting_with_71_or_76_or_78_or_81' AS k, 'الرقم اللبناني يجب أن يكون 8 أرقام ويبدأ بـ 71 أو 76 أو 78 أو 81' AS v
UNION ALL
SELECT 'messages.lost_reason_updated' AS k, 'تم تحديث سبب الخسارة!' AS v
UNION ALL
SELECT 'messages.mailer_library_not_found' AS k, 'مكتبة البريد غير موجودة' AS v
UNION ALL
SELECT 'messages.marked_as_done' AS k, 'تم تحديده كمنجز!' AS v
UNION ALL
SELECT 'messages.message_sent' AS k, 'تم إرسال الرسالة' AS v
UNION ALL
SELECT 'messages.message_sent_successfully' AS k, 'تم إرسال الرسالة بنجاح!' AS v
UNION ALL
SELECT 'messages.missing_email' AS k, 'البريد ناقص' AS v
UNION ALL
SELECT 'messages.missing_phone' AS k, 'رقم الهاتف ناقص' AS v
UNION ALL
SELECT 'messages.missing_required_fields' AS k, 'حقول مطلوبة ناقصة' AS v
UNION ALL
SELECT 'messages.network_error' AS k, 'خطأ في الشبكة:' AS v
UNION ALL
SELECT 'messages.no_whatsapp_campaign_id_returned' AS k, 'لم يرجع رقم حملة واتساب' AS v
UNION ALL
SELECT 'messages.no_campaign_id_returned' AS k, 'لم يرجع رقم الحملة' AS v
UNION ALL
SELECT 'messages.no_new_customers_to_add' AS k, 'لا يوجد زبائن جدد للإضافة' AS v
UNION ALL
SELECT 'messages.note_saved' AS k, 'تم حفظ الملاحظة!' AS v
UNION ALL
SELECT 'messages.occasion_added' AS k, 'تمت إضافة المناسبة' AS v
UNION ALL
SELECT 'messages.occasion_deleted' AS k, 'تم حذف المناسبة' AS v
UNION ALL
SELECT 'messages.occasion_updated' AS k, 'تم تحديث المناسبة' AS v
UNION ALL
SELECT 'messages.page_access_saved' AS k, 'تم حفظ صلاحية الصفحة!' AS v
UNION ALL
SELECT 'messages.password_updated' AS k, 'تم تحديث كلمة المرور!' AS v
UNION ALL
SELECT 'messages.passwords_do_not_match' AS k, 'كلمات المرور غير متطابقة' AS v
) x ON x.k=tk.`key` WHERE l.code='ar';
INSERT IGNORE INTO translations (language_id, key_id, value)
SELECT l.id, tk.id, x.v FROM languages l JOIN translation_keys tk JOIN (
SELECT 'messages.permission_denied' AS k, 'الصلاحية مرفوضة' AS v
UNION ALL
SELECT 'messages.phone_number_must_be_between_5_15_digits' AS k, 'رقم الهاتف يجب أن يكون بين 5 و 15 رقم' AS v
UNION ALL
SELECT 'messages.please_choose_an_image_file' AS k, 'اختر ملف صورة' AS v
UNION ALL
SELECT 'messages.please_enter_a_comment' AS k, 'أدخل تعليق' AS v
UNION ALL
SELECT 'messages.please_enter_a_message' AS k, 'أدخل رسالة' AS v
UNION ALL
SELECT 'messages.please_enter_a_reason' AS k, 'أدخل سبب' AS v
UNION ALL
SELECT 'messages.please_enter_a_subject' AS k, 'أدخل موضوع' AS v
UNION ALL
SELECT 'messages.please_enter_activity_notes' AS k, 'أدخل ملاحظات النشاط' AS v
UNION ALL
SELECT 'messages.please_enter_reminder_comment' AS k, 'أدخل تعليق التذكير' AS v
UNION ALL
SELECT 'messages.please_enter_reminder_note' AS k, 'أدخل ملاحظة التذكير' AS v
UNION ALL
SELECT 'messages.please_select_a_valid_customer_from_the_list' AS k, 'اختر زبون صحيح من القائمة' AS v
UNION ALL
SELECT 'messages.please_select_activity_date' AS k, 'اختر تاريخ النشاط' AS v
UNION ALL
SELECT 'messages.please_select_reminder_date' AS k, 'اختر تاريخ التذكير' AS v
UNION ALL
SELECT 'messages.please_set_a_whatsapp_number_first' AS k, 'ضع رقم واتساب أولاً' AS v
UNION ALL
SELECT 'messages.please_set_an_email_address_first' AS k, 'ضع عنوان البريد أولاً' AS v
UNION ALL
SELECT 'messages.primary_image_updated' AS k, 'تم تحديث الصورة الأساسية' AS v
UNION ALL
SELECT 'messages.quotation_saved' AS k, 'تم حفظ عرض السعر' AS v
UNION ALL
SELECT 'messages.reminder_added' AS k, 'تمت إضافة التذكير' AS v
UNION ALL
SELECT 'messages.role_updated' AS k, 'تم تحديث الدور!' AS v
UNION ALL
SELECT 'messages.sms_sent' AS k, 'تم إرسال SMS' AS v
UNION ALL
SELECT 'messages.saved_reloading' AS k, 'تم الحفظ! جاري إعادة التحميل...' AS v
UNION ALL
SELECT 'messages.select_an_audience_before_saving_campaign' AS k, 'اختر جمهور قبل حفظ الحملة' AS v
UNION ALL
SELECT 'messages.select_user_first' AS k, 'اختر المستخدم أولاً' AS v
UNION ALL
SELECT 'messages.431b04c21a4b' AS k, 'إرسال this campaign now? You cannot send it again after it is marked sent.' AS v
UNION ALL
SELECT 'messages.stage_added' AS k, 'تمت إضافة المرحلة!' AS v
UNION ALL
SELECT 'messages.stage_deleted' AS k, 'تم حذف المرحلة' AS v
UNION ALL
SELECT 'messages.stage_updated' AS k, 'تم تحديث المرحلة!' AS v
UNION ALL
SELECT 'messages.test_email_sent_successfully' AS k, 'تم إرسال بريد الاختبار بنجاح!' AS v
UNION ALL
SELECT 'messages.unknown_type' AS k, 'نوع غير معروف' AS v
UNION ALL
SELECT 'messages.user_added' AS k, 'تمت إضافة المستخدم!' AS v
UNION ALL
SELECT 'messages.user_removed' AS k, 'تم حذف المستخدم' AS v
UNION ALL
SELECT 'messages.user_updated' AS k, 'تم تحديث المستخدم!' AS v
UNION ALL
SELECT 'messages.whatsapp_campaign_create_failed' AS k, 'فشل إنشاء حملة واتساب' AS v
UNION ALL
SELECT 'messages.whatsapp_client_not_found' AS k, 'عميل واتساب غير موجود' AS v
UNION ALL
SELECT 'messages.whatsapp_connected' AS k, 'تم ربط واتساب! 🎉' AS v
UNION ALL
SELECT 'messages.whatsapp_contact_add_failed' AS k, 'فشل إضافة جهة اتصال واتساب' AS v
UNION ALL
SELECT 'messages.whatsapp_message_sent_successfully' AS k, 'تم إرسال رسالة واتساب بنجاح' AS v
UNION ALL
SELECT 'messages.whatsapp_sent' AS k, 'تم إرسال واتساب' AS v
UNION ALL
SELECT 'messages.whatsapp_start_failed' AS k, 'فشل بدء واتساب' AS v
) x ON x.k=tk.`key` WHERE l.code='ar';
