public function actionBlogs()
{
$data = Yii::app()->ls->createCommand('SELECT * FROM prefix_blog')->queryAll();
$transaction = Yii::app()->db->beginTransaction();
try {
Blog::model()->deleteAll();
foreach ($data as $blog) {
echo "Import blog '{$blog['blog_title']}' !\n";
$slug = $blog['blog_url'] ? $blog['blog_url'] : yupe\helpers\YText::translit($blog['blog_title']);
$updateDate = $blog['blog_date_edit'] ? $blog['blog_date_edit'] : $blog['blog_date_add'];
$icon = '';
if ($blog['blog_avatar']) {
$url = parse_url($blog['blog_avatar']);
if (!empty($url['path'])) {
$icon = str_replace('/uploads/', '', $url['path']);
}
}
$type = $blog['blog_type'] == 'personal' ? Blog::TYPE_PRIVATE : Blog::TYPE_PUBLIC;
Yii::app()->db->createCommand('
INSERT INTO {{blog_blog}} (id, name, slug, description, create_user_id, update_user_id, create_date, update_date, icon, type)
VALUES (:id, :name, :slug, :description, :create_user_id, :update_user_id, :create_date, :update_date, :icon, :type)
')->bindValue(':id', $blog['blog_id'])->bindValue(':name', $blog['blog_title'])->bindValue(':slug', $slug)->bindValue(':description', strip_tags($blog['blog_description']))->bindValue(':create_user_id', $blog['user_owner_id'])->bindValue(':update_user_id', $blog['user_owner_id'])->bindValue(':create_date', strtotime($blog['blog_date_add']))->bindValue(':update_date', strtotime($updateDate))->bindValue(':icon', $icon)->bindValue(':type', $type)->execute();
}
$transaction->commit();
} catch (Exception $e) {
CVarDumper::dump($e);
$transaction->rollback();
die;
}
}