Ответить в теме

[SPOILER][CODE=php]<?

define('IN_PHPBB', true);

define('BB_ROOT', './');

include(BB_ROOT . 'common.php');

// Start session

$user->session_start();

echo 'Подготовка<br />';

$sql = DB()->fetch_rowset("SELECT t.topic_id, p.post_text

    FROM bb_topics t

    LEFT JOIN bb_posts_text p ON (p.post_id = t.topic_first_post_id)  WHERE descr = '' OR keywords = '' LIMIT 10000");

 

foreach($sql as $row)

{

    $meta = create_metatags($row['post_text']);

    DB()->sql_query("UPDATE bb_topics SET keywords = '".$meta['keywords']."', descr = '".$meta['description']."' WHERE topic_id = ".$row['topic_id']."");

}

echo 'Обновление готово.';[/CODE][/SPOILER]