Метаданные в DatsoGallery как в материалах - Модификации

ALTER TABLE `jos_datsogallery` ADD `metadesc` VARCHAR( 250 ) NOT NULL AFTER `imgtitle` ;

ALTER TABLE `jos_datsogallery` ADD `metakey` VARCHAR( 250 ) NOT NULL AFTER `imgtitle` ;

$metadesc = mosGetParam($_REQUEST, 'metadesc', '');
$metadesc = mosGetParam($_REQUEST, 'metakey', '');

var $metadesc=null;
var $metakey=null;

$database->setQuery( "insert into #__datsogallery(....)

$database->setQuery( "insert into #__datsogallery(id,catid,imgtitle,metadesc,metakey,imgauthor,imgtext,imgdate,imgcounter,ordering,imgvotes,imgvotesum,published,imgfilename,imgthumbname,imgoriginalname,checked_out,owner,approved) VALUES (NULL,'$catid','$imgtitle','$metadesc','$metakey','$imgauthor','$imgtext','$imgdate','0','$ordering','0','0','1','med_$org_screenshot_name','tn_$org_screenshot_name','$org_screenshot_name','0','$my->username',1)" );

<tr>
 <td width="20%"><b>Мета-тег описание (description):</b></td>
 <td width="80%">
 <input class="inputbox" type="text" name="metadesc" size="39" maxlength="100" value="<?php echo htmlspecialchars( $row->metadesc, ENT_QUOTES );?>" /></td>
</tr>
<tr>
 <td width="20%"><b>Мета-тег ключевые слова (keywords):</b></td>
 <td width="80%">
 <input class="inputbox" type="text" name="metakey" size="39" maxlength="100" value="<?php echo htmlspecialchars( $row->metakey, ENT_QUOTES );?>" /></td>
</tr>

	. " a.metadesc, "
	. " a.metakey, "

list($id,$catid,$imgtitle,$imgauthor,$imgtext,$imgdate,$imgcounter,$imgvotes,$imgvotesum,$published,
    $imgoriginalname,$imgfilename,$imgthumbname,$imgowner) = mysql_fetch_row($list);

list($id,$catid,$imgtitle,$imgauthor,$imgtext,$imgdate,$imgcounter,$imgvotes,$imgvotesum,$published,
    $imgoriginalname,$imgfilename,$imgthumbname,$metadesc,$metakey,$imgowner) = mysql_fetch_row($list);

$mainframe->appendMetaTag( 'description', $row->metadesc );
$mainframe->appendMetaTag( 'keywords', $row->metakey );

$metadesc = mosGetParam($_REQUEST, 'metadesc', '');
$metadesc = mosGetParam($_REQUEST, 'metakey', '');

    $database->setQuery( "select a.id, "				
    . " a.catid, "
    . " a.imgtitle, "
	. " a.place, "
    . " a.imgauthor, "
    . " a.imgtext, "
    . " a.imgdate, "
    . " a.imgcounter, "
    . " a.imgvotes, "
    . " a.imgvotesum, "
    . " a.published, "
    . " a.imgoriginalname, "
    . " a.imgfilename, "
    . " a.imgthumbname, "
	. " a.metadesc, "
	. " a.metakey, "	
    . " a.owner "
    . " from #__datsogallery as a "
    . " left join #__users as u on u.username = a.owner "
    . " where a.id = $id ");

    $list = $database->query();

    if (count($database->loadObjectList()) < 1) {
    mosRedirect(sefRelToAbs("$dgurl&func=userpannel"), _DG_PICSLAD);
    }

    list($id,$catid,$imgtitle,$place,$imgauthor,$imgtext,$imgdate,$imgcounter,$imgvotes,$imgvotesum,$published,
    $imgoriginalname,$imgfilename,$imgthumbname,$metadesc,$metakey,$imgowner,$imgownerid) = mysql_fetch_row($list);

    $id_cache = array();

    $query = "SELECT * FROM #__datsogallery where id = $id";
    $database->setQuery($query);
    $rows = $database->loadObjectList();
    $row = &$rows[0];
    $mainframe->setPageTitle ($row->imgtitle);
	$mainframe->appendMetaTag( 'description', $row->metadesc );
	$mainframe->appendMetaTag( 'keywords', $row->metakey );

    if ($ad_slideshow)
    require "$gallerydir/sub_slideshow.php";