-- Perkthimet per fshirjen ne grup te perdoruesve.
-- Importoje ne phpMyAdmin dhe pastaj pastro cache.
SET NAMES utf8mb4;
START TRANSACTION;
UPDATE `translates` SET `value`='Select all' WHERE `key`='Select all' AND `lang`='en';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT 'Select all','Select all','dynamic','en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Select all' AND `lang`='en');
UPDATE `translates` SET `value`='Zgjidh te gjitha' WHERE `key`='Select all' AND `lang`='sq';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT 'Select all','Zgjidh te gjitha','dynamic','sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Select all' AND `lang`='sq');
UPDATE `translates` SET `value`='Clear selection' WHERE `key`='Clear selection' AND `lang`='en';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT 'Clear selection','Clear selection','dynamic','en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Clear selection' AND `lang`='en');
UPDATE `translates` SET `value`='Pastro perzgjedhjen' WHERE `key`='Clear selection' AND `lang`='sq';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT 'Clear selection','Pastro perzgjedhjen','dynamic','sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Clear selection' AND `lang`='sq');
UPDATE `translates` SET `value`='No users selected' WHERE `key`='No users selected' AND `lang`='en';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT 'No users selected','No users selected','dynamic','en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='No users selected' AND `lang`='en');
UPDATE `translates` SET `value`='Nuk eshte zgjedhur asnje perdorues' WHERE `key`='No users selected' AND `lang`='sq';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT 'No users selected','Nuk eshte zgjedhur asnje perdorues','dynamic','sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='No users selected' AND `lang`='sq');
UPDATE `translates` SET `value`='Select user' WHERE `key`='Select user' AND `lang`='en';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT 'Select user','Select user','dynamic','en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Select user' AND `lang`='en');
UPDATE `translates` SET `value`='Zgjidh perdoruesin' WHERE `key`='Select user' AND `lang`='sq';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT 'Select user','Zgjidh perdoruesin','dynamic','sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Select user' AND `lang`='sq');
UPDATE `translates` SET `value`='Delete selected' WHERE `key`='Delete selected' AND `lang`='en';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT 'Delete selected','Delete selected','dynamic','en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Delete selected' AND `lang`='en');
UPDATE `translates` SET `value`='Fshi te zgjedhurit' WHERE `key`='Delete selected' AND `lang`='sq';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT 'Delete selected','Fshi te zgjedhurit','dynamic','sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Delete selected' AND `lang`='sq');
UPDATE `translates` SET `value`='1 user selected' WHERE `key`='1 user selected' AND `lang`='en';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT '1 user selected','1 user selected','dynamic','en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='1 user selected' AND `lang`='en');
UPDATE `translates` SET `value`='1 perdorues i zgjedhur' WHERE `key`='1 user selected' AND `lang`='sq';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT '1 user selected','1 perdorues i zgjedhur','dynamic','sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='1 user selected' AND `lang`='sq');
UPDATE `translates` SET `value`=':count users selected' WHERE `key`=':count users selected' AND `lang`='en';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT ':count users selected',':count users selected','dynamic','en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`=':count users selected' AND `lang`='en');
UPDATE `translates` SET `value`=':count perdorues te zgjedhur' WHERE `key`=':count users selected' AND `lang`='sq';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT ':count users selected',':count perdorues te zgjedhur','dynamic','sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`=':count users selected' AND `lang`='sq');
UPDATE `translates` SET `value`='Are you sure you want to delete the selected users? This action cannot be undone.' WHERE `key`='Are you sure you want to delete the selected users? This action cannot be undone.' AND `lang`='en';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT 'Are you sure you want to delete the selected users? This action cannot be undone.','Are you sure you want to delete the selected users? This action cannot be undone.','dynamic','en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Are you sure you want to delete the selected users? This action cannot be undone.' AND `lang`='en');
UPDATE `translates` SET `value`='Je i sigurt qe deshiron t\'i fshish perdoruesit e zgjedhur? Ky veprim nuk mund te kthehet pas.' WHERE `key`='Are you sure you want to delete the selected users? This action cannot be undone.' AND `lang`='sq';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT 'Are you sure you want to delete the selected users? This action cannot be undone.','Je i sigurt qe deshiron t\'i fshish perdoruesit e zgjedhur? Ky veprim nuk mund te kthehet pas.','dynamic','sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`='Are you sure you want to delete the selected users? This action cannot be undone.' AND `lang`='sq');
UPDATE `translates` SET `value`=':count users deleted successfully' WHERE `key`=':count users deleted successfully' AND `lang`='en';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT ':count users deleted successfully',':count users deleted successfully','dynamic','en' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`=':count users deleted successfully' AND `lang`='en');
UPDATE `translates` SET `value`=':count perdorues u fshine me sukses' WHERE `key`=':count users deleted successfully' AND `lang`='sq';
INSERT INTO `translates` (`key`,`value`,`type`,`lang`) SELECT ':count users deleted successfully',':count perdorues u fshine me sukses','dynamic','sq' WHERE NOT EXISTS (SELECT 1 FROM `translates` WHERE `key`=':count users deleted successfully' AND `lang`='sq');
COMMIT;