ÿØÿà JFIF ` ` ÿþ
|
Server : Apache System : Linux cloud.heroica.com.br 4.18.0-553.36.1.el8_10.x86_64 #1 SMP Wed Jan 22 03:07:54 EST 2025 x86_64 User : farolpborg ( 1053) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/farolpborg/public_html/cms/ |
Upload File : |
<?
require_once("_configs/config.php");
$inicio = 0;
$final = 5508;
function remove_acentos($string){
$string = strtolower(strtr(utf8_decode($string),
utf8_decode(
'ŠŒŽšœžŸ¥µÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝßàáâãäåæçèéêëìíîïðñòóôõöøùúûüýÿ'), 'SOZsozYYuAAAAAAACEEEEIIIIDNOOOOOOUUUUYsaaaaaaaceeeeiiiionoooooouuuuyy'
));
$string = preg_replace('/^(")(.*)(")$/', "$2", $string);
$string = preg_replace('/^(«)(.*)(»)$/', "$2", $string);
$string = preg_replace('/^(“)(.*)(”)$/', "$2", $string);
$string = preg_replace('/^(')(.*)(')$/', "$2", $string);
$string = str_replace('!','',$string);
$string = str_replace('?','',$string);
$string = str_replace('º','',$string);
$string = str_replace('ª','',$string);
$string = str_replace('','',$string);
$string = str_replace('.','',$string);
$string = str_replace(',','',$string);
$string = str_replace('&','e',$string);
$string = str_replace(' ','-',$string);
$string = str_replace(':','-',$string);
$string = str_replace('( )','-',$string);
$string = str_replace('[^a-z0-9\-]','',$string);
$string = str_replace('--','-',$string);
$string = str_replace('---','-',$string);
return $string;
}
function gerar_caracteres2($tamanho = 7, $maiusculas = false, $numeros = false){
$lmin = 'abcdefghijklmnopqrstuvwxyz';
$lmai = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
$nums = '1234567890';
$retorno = '';
$caracteres = '';
$caracteres .= $lmin;
if($maiusculas){
$caracteres .= $lmai;
}
if($numeros){
$caracteres .= $nums;
}
$len = strlen($caracteres);
for($n = 1; $n <= $tamanho; $n++){
$rand = mt_rand(1, $len);
$retorno .= $caracteres[$rand-1];
}
return $retorno;
}
// $sqlnom = mysqli_query($conecta, "SELECT * FROM prematriculas_copy WHERE id_curso='32-61' ORDER BY nome");
// $sqlnom = mysqli_query($conecta, "SELECT * FROM prematriculas_copy ORDER BY id_curso");
// while($resnom = mysqli_fetch_object($sqlnom)){
// echo $resnom->nome." - ";
// echo $resnom->id." - ";
// echo $resnom->id_curso." - ";
// $removeold = substr(strstr($resnom->id_curso, '-'), strlen('-'))."<br>";
// mysqli_query($conecta, "UPDATE prematriculas_copy SET id_curso=replace(id_curso,'$resnom->id_curso','$removeold')");
// $sqlnom = mysqli_query($conecta, "SELECT * FROM prematriculas_copy WHERE id_curso = '9'");
// $sqlnom = mysqli_query($conecta, "SELECT * FROM prematriculas_copy WHERE id_curso='C39C39'");
// while($resnom = mysqli_fetch_object($sqlnom)){
// echo $resnom->nome." - ". $resnom->id_curso."<br>";
// }
/*$sqlnom = mysqli_query($conecta, "SELECT distinct a.id, a.cidade, a.cid_slug
FROM cidades a
INNER JOIN cidades b ON a.cid_slug = b.cid_slug
WHERE a.id <> b.id ORDER BY a.cidade");
while($resnom = mysqli_fetch_object($sqlnom)){
echo $resnom->cidade;
echo '<br>';
}*/
for($i = $inicio; $i < $final; $i++){
// $sqlnom = mysqli_query($conecta, "SELECT * FROM cidades WHERE id='$i'");
// $resnom = mysqli_fetch_object($sqlnom);
// $slug = remove_acentos($resnom->cidade);
// $atuali = date('dmY', strtotime($resnom->datahora)).gerar_caracteres2();
// mysqli_query($conecta, "UPDATE cidades SET cid_slug='$slug' WHERE id='$i'");
// echo $i.'<br>';
}
// $nomes = mysqli_query($conecta, "UPDATE prematriculas_copy SET cargo=replace(cargo, ' E ', ' e ')");
$sqnot = mysqli_query($conecta, "SELECT * FROM noticias");
while($resnot = mysqli_fetch_object($sqnot)){
echo $resnot->tags;
$split_tags = preg_split('/(\,\s?)/', $resnot->tags, -1, PREG_SPLIT_NO_EMPTY);
foreach($split_tags as $tag){
$sqtag = mysqli_query($conecta, "SELECT tag FROM noticias_tags WHERE tag='$tag'");
$iftag = mysqli_num_rows($sqtag);
if($iftag == 0){
mysqli_query($conecta, "INSERT INTO noticias_tags (tag) VALUES ('$tag')");
}
}
}
echo '<a href="javascript:window.location.reload();">Atualizar</a>';
exit;
?>