Guest User

Untitled

a guest
Nov 23rd, 2017
52
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(138), char(115)), 1, 128);
  2. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(142), char(122)), 1, 128);
  3. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(154), char(115)), 1, 128);
  4. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(158), char(122)), 1, 128);
  5. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(159), char(121)), 1, 128);
  6. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(161), char(105)), 1, 128);
  7. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(170), char(97)), 1, 128);
  8.  
  9. IF i >= 192 AND i <= 197 THEN
  10.     UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(i), char(97)), 1, 128);
  11. END IF;
  12.  
  13. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(199), char(99)), 1, 128);
  14.  
  15. IF i >= 200 AND i <= 203 THEN
  16.     UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(i), char(101)), 1, 128);
  17. END IF;
  18.  
  19. IF i >= 204 AND i <= 207 THEN
  20.     UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(i), char(105)), 1, 128);
  21. END IF;
  22.  
  23. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(208), char(100)), 1, 128);
  24. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(209), char(110)), 1, 128);
  25.  
  26. IF i >= 210 AND i <= 214 THEN
  27.     UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(i), char(111)), 1, 128);
  28. END IF;
  29.  
  30. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(215), char(120)), 1, 128);
  31. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(216), char(111)), 1, 128);
  32.  
  33. IF i >= 217 AND i <= 220 THEN
  34.     UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(i), char(117)), 1, 128);
  35. END IF;
  36.  
  37. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(221), char(121)), 1, 128);
  38. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(223), char(98)), 1, 128);
  39.  
  40. IF i >= 224 AND i <= 229 THEN
  41.     UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(i), char(97)), 1, 128);
  42. END IF;
  43.  
  44. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(230), char(97)), 1, 128);
  45. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(231), char(99)), 1, 128);
  46.  
  47. IF i >= 232 AND i <= 235 THEN
  48.     UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(i), char(101)), 1, 128);
  49. END IF;
  50.  
  51. IF i >= 236 AND i <= 239 THEN
  52.     UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(i), char(105)), 1, 128);
  53. END IF;
  54.  
  55. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(241), char(110)), 1, 128);
  56.  
  57. IF i >= 242 AND i <= 246 THEN
  58.     UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(i), char(111)), 1, 128);
  59. END IF;
  60.  
  61. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(248), char(111)), 1, 128);
  62.  
  63. IF i >= 249 AND i <= 252 THEN
  64.     UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(i), char(117)), 1, 128);
  65. END IF;
  66.  
  67. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(253), char(121)), 1, 128);
  68. UPDATE `ps_product_lang` SET `link_rewrite` = SUBSTRING(replace(`link_rewrite`, char(255), char(121)), 1, 128);
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×