chrisastley

// Separate Progress Window Version
// Opens progress stats in a separate window you can move to another monitor

(function() {
    'use strict';
    
    const CONFIG = {
        linkClass: 'edit-link',
        processDelay: 7000, // Time to wait for each tab to process
        maxRetries: 3,

chrisastley

UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 0;
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB35 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB36 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB37 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB38 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB53 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB54 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB55 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'AB56 %';
UPDATE `evri_postcodes_nexday_excluded` SET `location_charge` = 1 WHERE `postcode` LIKE 'FK17 %';

chrisastley

dir /b> files.txt
="UPDATE `data_templates` SET `changed` = NOW() WHERE `middleton_code` LIKE "&SUBSTITUTE(A1, ".svg", "")&";"
="UPDATE `data_templates` SET `changed` = `changed`, `enabled` = 1 WHERE `enabled` = 2 AND `middleton_code` LIKE "&SUBSTITUTE(A1, ".svg", "")&";"


UPDATE `ukvehicledata_map` SET `UvidList` = replace(`UvidList`, ' | ', '|A');
UPDATE `ukvehicledata_map` SET `UvidList` = CONCAT('|A', `UvidList`, '|');

SELECT * FROM `data_templates` WHERE `middleton_code` = 'tbc' AND `is_coming_soon` != 1;