public function saveItemAsArticle($item) { $table = JTableContent::getInstance('content', 'JTable'); $article = array(); $article['id'] = 0; $article['catid'] = $this->categories[$item->catid]; $article['alias'] = $item->alias; $article['title'] = $item->title; $article['state'] = $item->published; $article['publish_up'] = $item->publish_up; $article['publish_down'] = $item->publish_down; $article['introtext'] = $item->introtext; $article['fulltext'] = $item->fulltext; $article['created'] = $item->created; $article['modified'] = $item->modified; $article['created_by'] = $item->created_by; $article['modified_by'] = $item->modified_by; $article['hits'] = $item->hits; $article['language'] = $item->language; if (file_exists(JPATH_BASE . '/media/k2/items/cache/' . md5("Image" . $item->id) . '_L.jpg')) { $images['image_intro'] = 'media/k2/items/cache/' . md5("Image" . $item->id) . '_L.jpg'; $images['image_intro_caption'] = $item->image_caption; $images['image_intro_alt'] = $item->image_credits; $images['image_fulltext'] = 'media/k2/items/cache/' . md5("Image" . $item->id) . '_XL.jpg'; $images['image_fulltext_caption'] = $item->image_caption; $images['image_fulltext_alt'] = $item->image_credits; } $k2tags = $this->getK2ItemTags($item->id); $recipetags = array(); if ($k2tags) { foreach ($k2tags as $key => $k2tag) { $recipetags[] = $this->getTagId($k2tag->name); } } //$article['tags'] = $recipetags ; $table->newTags = $recipetags; $article['images'] = json_encode($images); $retval = $table->save($article); if ($retval) { $item_pk = $table->getPrimaryKey(); $pk = $item_pk['id']; $this->out($item->title . " saved. item_pk = " . $pk); $this->article_ids[$pk] = $item->id; } else { $this->out("Failed to save " . $item->title . " Error: " . $table->getError()); } // update rating $query = "INSERT INTO `#__content_rating` (content_id,rating_sum,rating_count,lastip) SELECT " . $pk . ",rating_sum,rating_count,lastip FROM `#__k2_rating` WHERE itemID = " . $item->id . " ;"; $query_set = $this->dbo->setQuery($query); $this->dbo->execute(); }