-- Perkthimet per butonat AJAX te review-ve ne admin.
-- Importoje nje here ne phpMyAdmin dhe pastaj pastro cache.

SET NAMES utf8mb4;
START TRANSACTION;

INSERT INTO `translates` (`key`, `value`, `type`, `lang`)
SELECT 'Move to Pending', 'Move to Pending', 'dynamic', 'en'
WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Move to Pending' AND `lang`='en');
INSERT INTO `translates` (`key`, `value`, `type`, `lang`)
SELECT 'Move to Pending', 'Vendose në pritje', 'dynamic', 'sq'
WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Move to Pending' AND `lang`='sq');

INSERT INTO `translates` (`key`, `value`, `type`, `lang`)
SELECT 'Review moved to pending successfully', 'Review moved to pending successfully', 'dynamic', 'en'
WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Review moved to pending successfully' AND `lang`='en');
INSERT INTO `translates` (`key`, `value`, `type`, `lang`)
SELECT 'Review moved to pending successfully', 'Vlerësimi u vendos në pritje me sukses', 'dynamic', 'sq'
WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Review moved to pending successfully' AND `lang`='sq');

INSERT INTO `translates` (`key`, `value`, `type`, `lang`)
SELECT 'Are you sure you want to delete this review?', 'Are you sure you want to delete this review?', 'dynamic', 'en'
WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Are you sure you want to delete this review?' AND `lang`='en');
INSERT INTO `translates` (`key`, `value`, `type`, `lang`)
SELECT 'Are you sure you want to delete this review?', 'A jeni i sigurt që dëshironi ta fshini këtë vlerësim?', 'dynamic', 'sq'
WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Are you sure you want to delete this review?' AND `lang`='sq');

INSERT INTO `translates` (`key`, `value`, `type`, `lang`)
SELECT 'Action completed successfully', 'Action completed successfully', 'dynamic', 'en'
WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Action completed successfully' AND `lang`='en');
INSERT INTO `translates` (`key`, `value`, `type`, `lang`)
SELECT 'Action completed successfully', 'Veprimi u krye me sukses', 'dynamic', 'sq'
WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Action completed successfully' AND `lang`='sq');

INSERT INTO `translates` (`key`, `value`, `type`, `lang`)
SELECT 'Something went wrong. Please try again.', 'Something went wrong. Please try again.', 'dynamic', 'en'
WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Something went wrong. Please try again.' AND `lang`='en');
INSERT INTO `translates` (`key`, `value`, `type`, `lang`)
SELECT 'Something went wrong. Please try again.', 'Ndodhi një gabim. Provoni përsëri.', 'dynamic', 'sq'
WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Something went wrong. Please try again.' AND `lang`='sq');

COMMIT;