function getAdsmanagerUser($userid)
{
$db = JFactory::getDBO();
$sql = "SELECT username FROM #__users WHERE id = " . (int) $userid;
$db->setQuery($sql);
$result = $db->loadResult();
$result = TTools::stringURLSafe($result);
$result = JString::substr($result, 0, 30);
return $result;
}
/**
* No args just to be compliant with joomla API
* @param unknown_type $src
* @param unknown_type $orderingFilter
* @param unknown_type $ignore
*/
function saveContent($src, $orderingFilter = '', $ignore = '')
{
$row = new JObject();
if ($this->id != 0) {
$row->id = $this->id;
}
//new_ad
$app = JFactory::getApplication();
if ($app->isAdmin() == true || $app->isAdmin() == false && @$this->new_ad == true) {
$row->date_created = $this->date_created;
$row->expiration_date = $this->expiration_date;
$row->publication_date = $this->publication_date;
}
//In case of bindContent / update Ad, $this->published is not set
if ($this->published !== null) {
$row->published = $this->published;
}
$row->date_modified = date('Y-m-d H:i:s');
$row->userid = $this->userid;
foreach ($this->data['fields'] as $name => $value) {
if (is_array($value)) {
$v = ',' . implode(',', $value) . ',';
} else {
$v = $value;
}
$row->{$name} = $v;
}
$row->metadata_description = $this->metadata_description;
$row->metadata_keywords = $this->metadata_keywords;
//Insert new record.
if ($this->id == 0) {
$ret = $this->_db->insertObject('#__adsmanager_ads', $row);
$contentid = (int) $this->_db->insertid();
} else {
$ret = $this->_db->updateObject('#__adsmanager_ads', $row, 'id');
$contentid = $this->id;
}
// Category
$query = "DELETE FROM #__adsmanager_adcat WHERE adid = {$contentid}";
$this->_db->setQuery($query);
$this->_db->query();
foreach ($this->data['categories'] as $cat) {
$query = "INSERT INTO #__adsmanager_adcat(adid,catid) VALUES ({$contentid},{$cat})";
$this->_db->setQuery($query);
$this->_db->query();
$this->catid = $cat;
}
//Images
$dir = JPATH_ROOT . "/images/com_adsmanager/ads/waiting/";
$dirfinal = JPATH_ROOT . "/images/com_adsmanager/ads/";
$current_images = json_decode($this->images);
if ($current_images == null) {
$current_images = array();
}
if (!is_array($current_images)) {
$current_images = get_object_vars($current_images);
}
foreach ($this->data['delimages'] as $image) {
if (is_file(JPATH_ROOT . "/images/com_adsmanager/ads/" . $image->image)) {
JFile::delete(JPATH_ROOT . "/images/com_adsmanager/ads/" . $image->image);
}
/* if(is_file(JPATH_ROOT."/images/com_adsmanager/ads/".$image->thumbnail)) {
JFile::delete(JPATH_ROOT."/images/com_adsmanager/ads/".$image->thumbnail);
}
if(is_file(JPATH_ROOT."/images/com_adsmanager/ads/".$image->medium)) {
@JFile::delete(JPATH_ROOT."/images/com_adsmanager/ads/".$image->medium);
}*/
foreach ($current_images as $key => $img) {
if ($img->index == $image->index) {
unset($current_images[$key]);
break;
}
}
}
if (!is_array($current_images)) {
$current_images = get_object_vars($current_images);
}
sort($current_images);
jimport('joomla.filter.output');
//True to force transliterate
$imgtitle = TTools::stringURLSafe($row->ad_headline, true);
if ($imgtitle == "") {
$imgtitle = "image";
}
foreach ($this->data['images'] as &$image) {
$src = $dir . $image->image;
$dest = $dirfinal . $imgtitle . "_" . $contentid . "_" . $image->index . ".jpg";
JFile::move($src, $dest);
$image->image = $imgtitle . "_" . $contentid . "_" . $image->index . ".jpg";
/*
$src =$dir.$image->thumbnail;
$dest =$dirfinal.$imgtitle."_".$contentid."_".$image->index."_t.jpg";
JFile::move($src,$dest);
$image->thumbnail = $imgtitle."_".$contentid."_".$image->index."_t.jpg";
$src =$dir.$image->medium;
$dest =$dirfinal.$imgtitle."_".$contentid."_".$image->index."_m.jpg";
JFile::move($src,$dest);
$image->medium = $imgtitle."_".$contentid."_".$image->index."_m.jpg";*/
$current_images[] = $image;
}
$orderlist = $this->data['orderimages'];
$newlistimages = array();
/* foreach($orderlist as $o) {
foreach($current_images as $image) {
if ($image->index == $o)
$newlistimages[] = $image;
}
}*/
$row = new JObject();
$row->id = $contentid;
// $row->images = json_encode($newlistimages);
// $this->images = $newlistimages;
$ret = $this->_db->updateObject('#__adsmanager_ads', $row, 'id');
if (function_exists('savePaidAd')) {
savePaidAd($this, $contentid);
}
$this->id = $contentid;
$this->_db->setQuery("DELETE FROM #__adsmanager_pending_ads WHERE contentid=" . intval($contentid));
$this->_db->query();
$cache =& JFactory::getCache('com_adsmanager');
$cache->clean();
}