PHP DTTag::save 예제들

예제 #1

파일: tags.php 프로젝트: laiello/bitcero-modules

// Manage files for download in XOOPS
// Author: Eduardo Cortés <*****@*****.**>
// Email: i.bitcero@gmail.com
// License: GPL 2.0
// --------------------------------------------------------------
$xoopsOption['template_main'] = 'dtrans_tags.html';
$xoopsOption['module_subpage'] = 'tags';
if ($tag == '') {
    redirect_header(DT_URL, 1, __('Tag not specified!', 'dtransport'));
    die;
}
include 'header.php';
$tag = new DTTag($tag);
//Incrementamos los hits
$tag->setHit($tag->hit() + 1);
$tag->save();
// Descargas en esta etiqueta
$sql = "SELECT COUNT(*) FROM " . $db->prefix('dtrans_softtag') . " AS a INNER JOIN " . $db->prefix('dtrans_software') . " b ON (a.id_tag=" . $tag->id() . " AND a.id_soft=b.id_soft) WHERE b.approved='1' AND b.delete='0'";
list($num) = $db->fetchRow($db->query($sql));
$limit = $mc['xpage'];
$limit = $limit <= 0 ? 10 : $limit;
$tpages = ceil($num / $limit);
if ($tpages < $page && $tpages > 0) {
    header('location: ' . DT_URL . ($mc['permalinks'] ? '/tag/' . $tag->tagId() : '/?p=tag&tag=' . $tag->id()));
    die;
}
$p = $page > 0 ? $page - 1 : $page;
$start = $num <= 0 ? 0 : $p * $limit;
$nav = new RMPageNav($num, $limit, $page);
$nav->target_url(DT_URL . ($mc['permalinks'] ? '/tag/' . $tag->tagId() . '/page/{PAGE_NUM}/' : '/?p=tag&amp;tag=' . $tag->id() . '&amp;page={PAGE_NUM}'));
$xoopsTpl->assign('pagenav', $nav->render(true));

예제 #2

파일: dtsoftware.class.php 프로젝트: laiello/bitcero-modules

 /**
  * @desc Almacena las etiquetas del elemento
  */
 private function saveTags()
 {
     $sql = "DELETE FROM " . $this->db->prefix('dtrans_softtag') . " WHERE id_soft=" . $this->id();
     $this->db->queryF($sql);
     $tc = TextCleaner::getInstance();
     $tags = array();
     foreach ($this->_tags as $tag) {
         if (is_array($tag)) {
             $tag = $tag['tag'];
         }
         $ot = new DTTag($tc->sweetstring($tag));
         if ($ot->isNew()) {
             $ot->setVar('tag', $tag);
             $ot->setVar('tagid', $tc->sweetstring($tag));
             $ot->save();
         }
         $tags[] = $ot->id();
     }
     if (empty($tags)) {
         return;
     }
     $sql = "INSERT INTO " . $this->db->prefix('dtrans_softtag') . " (`id_soft`,`id_tag`) VALUES ";
     $sql1 = '';
     foreach ($tags as $k) {
         $sql1 .= $sql1 == "" ? "('" . $this->id() . "','{$k}')" : ",('" . $this->id() . "','{$k}')";
     }
     if ($this->db->queryF($sql . $sql1)) {
         return true;
     }
     $this->addError($this->db->error());
     return false;
 }