protected function add(PHPBoostAccess $pba, stdClass $cat)
{
// Gestion de la catégorie parente
$parent_id = 0;
if (!is_null($cat->parent_slug)) {
$cats = $pba->getAllNewsCats();
if (array_key_exists($cat->parent_slug, $cats)) {
$parent_id = $cats[$cat->parent_slug]->id;
}
}
$query = $pba->getSql()->prepare('
INSERT INTO ' . $pba->getPrefix() . 'news_cats(name, rewrited_name, description, c_order, image, id_parent)
VALUES(:name, :rewrited_name, :description, :c_order, :image, :id_parent)
');
$query->execute(array('name' => $cat->name, 'rewrited_name' => $cat->slug, 'description' => $cat->description, 'c_order' => 1, 'image' => PHPBOOST_CAT_IMAGE, 'id_parent' => $parent_id));
}
public function importMedia(stdClass $media, $userId, WordPressAccess $wordPressAccess, PHPBoostAccess $phpBoostAccess)
{
$src = $wordPressAccess->getPath() . 'wp-content/uploads/' . $media->path;
$dest = $phpBoostAccess->getPath() . FILESYSTEM_IMPORT_LOCATION . $media->path;
if (!is_dir(dirname($dest))) {
mkdir(dirname($dest), 0777, true);
}
if (!file_exists($dest) && file_exists($src)) {
copy($src, $dest);
$file = pathinfo($dest);
// Ajout dans la base de données
$insert = $phpBoostAccess->getSql()->prepare('
INSERT IGNORE INTO ' . $phpBoostAccess->getPrefix() . 'upload(name, path, user_id, size, type, timestamp)
VALUES (:name, :path, :user_id, :size, :type, :timestamp)
');
$insert->execute(array('name' => $file['basename'], 'path' => str_replace('upload/', '', FILESYSTEM_IMPORT_LOCATION . $media->path), 'user_id' => $userId, 'size' => round(filesize($dest) / 1024), 'type' => $file['extension'], 'timestamp' => filemtime($dest)));
return true;
}
return false;
}
public function updateCommentsCount(PHPBoostAccess $PHPBoostAccess, $topic_id)
{
$update = $PHPBoostAccess->getSql()->prepare('
UPDATE ' . $PHPBoostAccess->getPrefix() . 'comments_topic ct
SET number_comments = (SELECT COUNT(*) FROM ' . $PHPBoostAccess->getPrefix() . 'comments c WHERE c.id_topic = ct.id_topic)
WHERE id_topic = :id_topic
');
$update->execute(array('id_topic' => $topic_id));
}
protected function addUser(PHPBoostAccess $pba, stdClass $wpUser)
{
$query = $pba->getSql()->prepare('INSERT INTO ' . $pba->getPrefix() . 'member(login, password, level, user_mail, user_show_mail, timestamp, last_connect) VALUES(:login, :password, :level, :user_mail, :user_show_mail, :timestamp, :last_connect)');
$query->execute(array('login' => $wpUser->user_login, 'password' => '', 'level' => '0', 'user_mail' => substr($wpUser->user_email, 0, 50), 'user_show_mail' => 0, 'timestamp' => (new DateTime($wpUser->user_registered))->getTimestamp(), 'last_connect' => '0'));
}
