Posiadam skrypt:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body>
<?php
$mysqli = new mysqli('127.0.0.1',
'admin',
'p3IfewF?I^qsRbk#d,2x',
'admin' );
// mysqli_query("SET NAMES 'latin2'");
function zamiana( $string )
{
// $string = strtolower($string);
$polskie = array( ',', '-', ' ', 'ę', 'Ę', 'ó', 'Ó', 'Ą', 'ą', 'Ś', 's', 'ł', 'Ł', 'ż', 'Ż', 'Ź', 'ź', 'ć', 'Ć', 'ń', 'Ń', '-', "'", "/", "?", '"', ":", 'ś', '!', '&', '&', '#', ';', '[', ']', 'domena.pl', '(', ')', '`', '%', '”', '„', '…' );
$miedzyn = array( '-', '-', '-', 'e', 'e', 'o', 'o', 'a', 'a', 's', 's', 'l', 'l', 'z', 'z', 'z', 'z', 'c', 'c', 'n', 'n', '-', "", "", "", "", "", 's', '', '', '', '', '', '', '', '', '', '', '', '', '' );
$string = str_replace( $polskie, $miedzyn, $string );
// usuń wszytko co jest niedozwolonym znakiem
$string = preg_replace( '/[^0-9A-Za-z.\-]+/', '-', $string );
// zredukuj liczbę myślników do jednego obok siebie
// $string = preg_replace('/[\-]+/', '-', $string);
// usuwamy możliwe myślniki na początku i końcu
// $string = trim($string, '-');
$string = stripslashes( $string );
// na wszelki wypadek
// $string = urlencode($string);
return $string;
}
$page = "https://artelis.pl/";
$i = 0;
$list = "";
// $result2 = mysqli_query($mysqli, "SHOW TABLES");
// while ($row2 = $result2->fetch_object()){
// echo $row2->Tables_in_obswkkar_admin_nowa_prod."<br />";
// }
// $user = mysqli_query($mysqli, "SELECT * FROM patronats_categories");
// while ($row3 = $user->fetch_object()){
// var_dump($row3);
// }
// echo $page."autor/profil/".$row3->id."/".$row3->slug."<br />";
// autor/profil/184547/
// }
/**
* $result2 = mysqli_query($mysqli, "SHOW TABLES");
* while ($row2 = $result2->fetch_object()){
* echo $row2->Tables_in_obswkkar_admin_nowa_prod."<br />";
* $result3=mysqli_query($mysqli, "DESCRIBE ".$row2->Tables_in_obswkkar_admin_nowa_prod."");
*
* while ($row3 = $result3->fetch_object()){
* echo $row3->Field." , ";
* }
* echo"<hr />";
*
* }
*/
// $result2->close();
$mysqli -> query( "SET NAMES 'utf8mb4'" );
$strony = mysqli_query( $mysqli, "SELECT * FROM static_pages" );
while ( $row3 = $strony -> fetch_object() ) {
$list .= rtrim( $page, "/" ) . $row3 -> address . "/n";
}
$lista_artykuly = "";
$artykul = mysqli_query( $mysqli, "SELECT * FROM articles WHERE status='live' " );
while ( $row = $artykul -> fetch_object() ) {
$title = $row -> title;
$lista_artykuly .= $page . "artykuly/" . $row -> id . "/" . zamiana( $title ) . "\n";
} ;
$artykul -> close();
$fp_art = fopen( 'sitemap_art.txt', 'w' );
fwrite( $fp_art, $lista_artykuly );
fclose( $fp_art );
$kategorie = mysqli_query( $mysqli, "SELECT * FROM categories" );
while ( $row = $kategorie -> fetch_object() ) {
$list .= $page . $row -> slug . ".html\n";
$subkategorie = mysqli_query( $mysqli, "SELECT * FROM subcategories WHERE category_id='" . $row -> id . "' " );
while ( $row_sub = $subkategorie -> fetch_object() ) {
$list .= $page . "kategorie/" . $row -> slug . "/" . $row_sub -> slug . "\n";
}
} ;
$kategorie -> close();
// $artykuly = mysqli_query($mysqli, "SELECT * FROM articles");
// var_dump($artykuly);
// echo $list;
$tagi = mysqli_query( $mysqli, "SELECT * FROM tags GROUP BY slug" );
$it=0;
while ( $row = $tagi -> fetch_object() ) {
$list .= $page . "tag/" . $row -> slug . "\n";
$it++;
if($it>45000){
$it=0;
$ex = explode( "\n", $list );
echo count( $ex );
$fp = fopen( 'sitemap0.txt', 'w' );
fwrite( $fp, $list );
fclose( $fp );
$list="";
}
} ;
$tagi -> close();
$lista_user = "";
$user = mysqli_query( $mysqli, "SELECT * FROM users" );
while ( $row3 = $user -> fetch_object() ) {
// echo $page."autor/profil/".$row3->id."/".$row3->slug."<br />";
$lista_user .= $page . "autor/profil/" . $row3 -> id . "/" . $row3 -> slug . "\n";
}
$fp = fopen( 'sitemap_user.txt', 'w' );
fwrite( $fp, $lista_user );
fclose( $fp );
$user -> close();
$ex = explode( "\n", $list );
echo count( $ex );
$mysqli -> close();
$fp = fopen( 'sitemap.txt', 'w' );
fwrite( $fp, $list );
fclose( $fp );
Dla pliku sitemap_art.txt potrzebuję utworzyć maks 50 000 wierszy, po czym ma się utworzyć nowy plik, również z 50 000 wierszami. Proszę o podpowiedź.