Path: csiph.com!eternal-september.org!feeder.eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: Jan Hansen <jhjjhjhhansen@gmail.com>
Newsgroups: dk.edb.internet.webdesign.serverside.php
Subject: Re: =?UTF-8?B?U8O4Zw==?= og erstat
Date: Fri, 8 Feb 2019 14:38:16 +0100
Organization: A noiseless patient Spider
Lines: 54
Message-ID: <20190208143816.fa093667c8306411e57e494e@gmail.com>
References: <q2udgd$uum$1@dont-email.me> <5c537e70$0$687$14726298@news.sunsite.dk> <q30u4n$10d$1@dont-email.me> <5c54a9b7$0$692$14726298@news.sunsite.dk> <5c54b2b7$0$680$14726298@news.sunsite.dk> <q362v1$98s$2@dont-email.me> <5c585ca3$0$686$14726298@news.sunsite.dk> <5c5c25ba$0$689$14726298@news.sunsite.dk> <q3j75v$t29$1@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Info: reader02.eternal-september.org; posting-host="855b47048eea51aa44772e4ace6df4e9"; logging-data="5540"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1+L2roXm70kzy3gW/yFI+mcWHe2ik72q7M="
User-Agent: Sylfide for Fedora (sylpheed.sraoss.jp)
Cancel-Lock: sha1:hHzQYk23gDyELCzJpyZlHdCQwSQ=
face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAMAAABg3Am1AAAAM1BMVEVAAAAEAgccGRcrKytDLQd pRQVKTEyPYw5naGazfQTNlQi3mFehnZfxuADsyBPLzMn6/PhA/qUdAAAAAXRSTlMAQObYZgAAAA FiS0dEAIgFHUgAAAAJcEhZcwAACxMAAAsTAQCanBgAAAAHdElNRQfgAg8RLTjt/9kiAAABlklEQVRIx7WV27qEIAiFB80TI+H7P+0Gm4OWTXax+bqi9csSjR6PccDjTsArburtLPFeP/pJ4g1YM+cKuvgfwKsZG/2sJV9Y9FyKnwSyZQ+R9ZkDojbURwCeruCI8GlqhQkCbCJaJchNAg6rfl3xHoCYZi0FFDHiM8thTBDgWYiUMrOBaKYAzk+Rl8Izt0PaX1ijlO2s4UqfRbjJS8nXJcCUNi6vrFzVDrAXhH6Y6qY60o3kayA36wvhwf4gQBrfORIEwPwEuOwi2h/DAPYFtIappk5uEZQjANXUiSN/BAqc7kLyeQCY086eAmYM6Gzke0AdRkfAnFlCMgNLbLbRP9LTgKC1AgYPepktMo1g31hZRIG0HlevEXb7YEnJrmWy9cBbXw1we/ekakpJFxwDJLPItIBIcas/tkSrzMf2rn7f0Bggio0lv7RvaAzg15CFDsC+pZ+0ey8v7XQ40ncFCIP8TaLf5sUHwO7kpG+IDfCNF4DpcNAhBMVU71pAjwBTGH/STqHglia1SCaFcD75nHN9Ytln/gB2JSmlFxN3ggAAAABJRU5ErkJggg==
X-Newsreader: Sylpheed 3.7.0 (GTK+ 2.24.27; x86_64-unknown-linux-gnu)
Xref: csiph.com dk.edb.internet.webdesign.serverside.php:7186

8 Feb 2019 07:21:51 +0100 skrev Kurt Hansen <kurt@invalid.dk>:

> > Sig til hvis du skal sparkes i gang med resten :)
> 
> Det ville jeg ikke selv have spurgt/bedt om, men når du nu selv tilbyder 
> det, så siger jeg da tak :-)

Når Martin Larsen har lavet det svære, er resten vel til at overse.
Hvis du udfylder $tabel, $felt og $forbindelse korrekt, kan dette lave 
en tabel "nytabel" med rettet indhold af den originale.
Kommer der ingen fejl - formentlig timeout - vil der stå 
"Tabellen er fremstillet." herefter kan den omdøbes til originalt navn.

<?php
$tabel='products_description';
$felt='products_description';
$forbindelse = mysqli_connect("server", "login", "password", "database") or die ("Der er ged i dine login oplysninger.");

$x = mysqli_query($forbindelse,"CREATE TABLE nytabel LIKE `$tabel`") or die ("nytabel findes eller $tabel findes ikke");
$x = mysqli_query($forbindelse,"INSERT nytabel SELECT * FROM `$tabel`") or die ("Dur ikke 1");
$x = mysqli_query($forbindelse,"SELECT `$felt` FROM nytabel") or die ("Dur ikke 2");
while ($t = mysqli_fetch_array($x)) { 
  $gammel=$t["$felt"];
  $ny = preg_replace_callback('%<a [^>]*href\s*=\s*(["\'])(.*?)\1[^>]*>%i', "callback", $gammel);
  $ny = preg_replace_callback('%<img [^>]*src\s*=\s*(["\'])(.*?)\1[^>]*>%i', "callback", $ny);
  if ($gammel!==$ny) {
    $gammel = mysqli_real_escape_string($forbindelse, $gammel);
    $ny = mysqli_real_escape_string($forbindelse, $ny);
    $y=mysqli_query($forbindelse,"UPDATE nytabel SET `$felt` = '$ny' WHERE `$felt` = '$gammel'") or die ("Dur ikke 3");
  }
}
echo 'Tabellen er fremstillet. <br>
Ser det rigtigt ud, så skriv <br>
RENAME '.$tabel.' TO '.$tabel.'_backup; <br>
RENAME nytabel TO '.$tabel.';';

function callback($match) {
     $tag = $match[0];
     $url = $match[2];
     if(strpos($url, " ") === false) {
	return $tag; // gør intet hvis der ikke er mellemrum i url
     }
     $newurl = str_replace(" ", "%20", $url);
     $newtag = str_replace($url, $newurl, $tag);
     return $newtag;
}

?>


-- 
mvh Jan.
Help Microsoft stamp out piracy. Give
Linux to a friend today!