onokazu
onoka****@users*****
2005年 6月 11日 (土) 11:32:56 JST
Index: xoops2jp/html/modules/xoopsheadline/class/headline.php
diff -u xoops2jp/html/modules/xoopsheadline/class/headline.php:1.2 xoops2jp/html/modules/xoopsheadline/class/headline.php:1.3
--- xoops2jp/html/modules/xoopsheadline/class/headline.php:1.2 Fri Mar 18 21:52:49 2005
+++ xoops2jp/html/modules/xoopsheadline/class/headline.php Sat Jun 11 11:32:56 2005
@@ -1,5 +1,5 @@
<?php
-// $Id: headline.php,v 1.2 2005/03/18 12:52:49 onokazu Exp $
+// $Id: headline.php,v 1.3 2005/06/11 02:32:56 onokazu Exp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
@@ -31,151 +31,151 @@
class XoopsheadlineHeadline extends XoopsObject
{
- function XoopsheadlineHeadline()
- {
- $this->XoopsObject();
- $this->initVar('headline_id', XOBJ_DTYPE_INT, null, false);
- $this->initVar('headline_name', XOBJ_DTYPE_TXTBOX, null, true, 255);
- $this->initVar('headline_url', XOBJ_DTYPE_TXTBOX, null, true, 255);
- $this->initVar('headline_rssurl', XOBJ_DTYPE_TXTBOX, null, true, 255);
- $this->initVar('headline_cachetime', XOBJ_DTYPE_INT, 600, false);
- $this->initVar('headline_asblock', XOBJ_DTYPE_INT, 0, false);
- $this->initVar('headline_display', XOBJ_DTYPE_INT, 0, false);
- $this->initVar('headline_encoding', XOBJ_DTYPE_OTHER, null, false);
- $this->initVar('headline_weight', XOBJ_DTYPE_INT, 0, false);
- $this->initVar('headline_mainimg', XOBJ_DTYPE_INT, 1, false);
- $this->initVar('headline_mainfull', XOBJ_DTYPE_INT, 1, false);
- $this->initVar('headline_mainmax', XOBJ_DTYPE_INT, 10, false);
- $this->initVar('headline_blockimg', XOBJ_DTYPE_INT, 0, false);
- $this->initVar('headline_blockmax', XOBJ_DTYPE_INT, 10, false);
- $this->initVar('headline_xml', XOBJ_DTYPE_SOURCE, null, false);
- $this->initVar('headline_updated', XOBJ_DTYPE_INT, 0, false);
- }
-
- function cacheExpired()
- {
- if (time() - $this->getVar('headline_updated') > $this->getVar('headline_cachetime')) {
- return true;
- }
- return false;
- }
+ function XoopsheadlineHeadline()
+ {
+ $this->XoopsObject();
+ $this->initVar('headline_id', XOBJ_DTYPE_INT, null, false);
+ $this->initVar('headline_name', XOBJ_DTYPE_TXTBOX, null, true, 255);
+ $this->initVar('headline_url', XOBJ_DTYPE_TXTBOX, null, true, 255);
+ $this->initVar('headline_rssurl', XOBJ_DTYPE_TXTBOX, null, true, 255);
+ $this->initVar('headline_cachetime', XOBJ_DTYPE_INT, 600, false);
+ $this->initVar('headline_asblock', XOBJ_DTYPE_INT, 0, false);
+ $this->initVar('headline_display', XOBJ_DTYPE_INT, 0, false);
+ $this->initVar('headline_encoding', XOBJ_DTYPE_OTHER, null, false);
+ $this->initVar('headline_weight', XOBJ_DTYPE_INT, 0, false);
+ $this->initVar('headline_mainimg', XOBJ_DTYPE_INT, 1, false);
+ $this->initVar('headline_mainfull', XOBJ_DTYPE_INT, 1, false);
+ $this->initVar('headline_mainmax', XOBJ_DTYPE_INT, 10, false);
+ $this->initVar('headline_blockimg', XOBJ_DTYPE_INT, 0, false);
+ $this->initVar('headline_blockmax', XOBJ_DTYPE_INT, 10, false);
+ $this->initVar('headline_xml', XOBJ_DTYPE_SOURCE, null, false);
+ $this->initVar('headline_updated', XOBJ_DTYPE_INT, 0, false);
+ }
+
+ function cacheExpired()
+ {
+ if (time() - $this->getVar('headline_updated') > $this->getVar('headline_cachetime')) {
+ return true;
+ }
+ return false;
+ }
}
class xoopsheadlineHeadlineHandler
{
- var $db;
+ var $db;
- function XoopsheadlineHeadlineHandler(&$db)
- {
- $this->db =& $db;
- }
-
- function &getInstance(&$db)
- {
- static $instance;
- if (!isset($instance)) {
- $instance = new XoopsheadlineHeadlineHandler($db);
- }
- return $instance;
- }
-
- function &create()
- {
- return new XoopsheadlineHeadline();
- }
-
- function &get($id)
- {
- $id = intval($id);
- if ($id > 0) {
- $sql = 'SELECT * FROM '.$this->db->prefix('xoopsheadline').' WHERE headline_id='.$id;
- if (!$result = $this->db->query($sql)) {
- return false;
- }
- $numrows = $this->db->getRowsNum($result);
- if ($numrows == 1) {
- $headline = new XoopsheadlineHeadline();
- $headline->assignVars($this->db->fetchArray($result));
- return $headline;
- }
- }
- return false;
- }
-
- function insert(&$headline)
- {
- if (get_class($headline) != 'xoopsheadlineheadline') {
- return false;
- }
- if (!$headline->cleanVars()) {
- return false;
- }
- foreach ($headline->cleanVars as $k => $v) {
- ${$k} = $v;
- }
- if (empty($headline_id)) {
- $headline_id = $this->db->genId('xoopsheadline_headline_id_seq');
- $sql = 'INSERT INTO '.$this->db->prefix('xoopsheadline').' (headline_id, headline_name, headline_url, headline_rssurl, headline_encoding, headline_cachetime, headline_asblock, headline_display, headline_weight, headline_mainimg, headline_mainfull, headline_mainmax, headline_blockimg, headline_blockmax, headline_xml, headline_updated) VALUES ('.$headline_id.', '.$this->db->quoteString($headline_name).', '.$this->db->quoteString($headline_url).', '.$this->db->quoteString($headline_rssurl).', '.$this->db->quoteString($headline_encoding).', '.$headline_cachetime.', '.$headline_asblock.', '.$headline_display.', '.$headline_weight.', '.$headline_mainimg.', '.$headline_mainfull.', '.$headline_mainmax.', '.$headline_blockimg.', '.$headline_blockmax.', '.$this->db->quoteString($headline_xml).', '.time().')';
- } else {
- $sql = 'UPDATE '.$this->db->prefix('xoopsheadline').' SET headline_name='.$this->db->quoteString($headline_name).', headline_url='.$this->db->quoteString($headline_url).', headline_rssurl='.$this->db->quoteString($headline_rssurl).', headline_encoding='.$this->db->quoteString($headline_encoding).', headline_cachetime='.$headline_cachetime.', headline_asblock='.$headline_asblock.', headline_display='.$headline_display.', headline_weight='.$headline_weight.', headline_mainimg='.$headline_mainimg.', headline_mainfull='.$headline_mainfull.', headline_mainmax='.$headline_mainmax.', headline_blockimg='.$headline_blockimg.', headline_blockmax='.$headline_blockmax.', headline_xml = '.$this->db->quoteString($headline_xml).', headline_updated='.$headline_updated.' WHERE headline_id='.$headline_id;
- }
- if (!$result = $this->db->queryF($sql)) {
- return false;
- }
- if (empty($headline_id)) {
- $headline_id = $this->db->getInsertId();
- }
- $headline->assignVar('headline_id', $headline_id);
- return $headline_id;
- }
-
- function delete(&$headline)
- {
- if (get_class($headline) != 'xoopsheadlineheadline') {
- return false;
- }
- $sql = sprintf("DELETE FROM %s WHERE headline_id = %u", $this->db->prefix('xoopsheadline'), $headline->getVar('headline_id'));
- if (!$result = $this->db->query($sql)) {
- return false;
- }
- return true;
- }
-
- function &getObjects($criteria = null)
- {
- $ret = array();
- $limit = $start = 0;
- $sql = 'SELECT * FROM '.$this->db->prefix('xoopsheadline');
- if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
- $sql .= ' '.$criteria->renderWhere();
- $sql .= ' ORDER BY headline_weight '.$criteria->getOrder();
- $limit = $criteria->getLimit();
- $start = $criteria->getStart();
- }
- $result = $this->db->query($sql, $limit, $start);
- if (!$result) {
- return $ret;
- }
- while ($myrow = $this->db->fetchArray($result)) {
- $headline = new XoopsheadlineHeadline();
- $headline->assignVars($myrow);
- $ret[] =& $headline;
- unset($headline);
- }
- return $ret;
- }
-
- function getCount($criteria = null)
- {
- $sql = 'SELECT COUNT(*) FROM '.$this->db->prefix('xoopsheadline');
- if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
- $sql .= ' '.$criteria->renderWhere();
- }
- if (!$result =& $this->db->query($sql)) {
- return 0;
- }
- list($count) = $this->db->fetchRow($result);
- return $count;
- }
+ function XoopsheadlineHeadlineHandler(&$db)
+ {
+ $this->db =& $db;
+ }
+
+ function &getInstance(&$db)
+ {
+ static $instance;
+ if (!isset($instance)) {
+ $instance = new XoopsheadlineHeadlineHandler($db);
+ }
+ return $instance;
+ }
+
+ function &create()
+ {
+ return new XoopsheadlineHeadline();
+ }
+
+ function &get($id)
+ {
+ $id = intval($id);
+ if ($id > 0) {
+ $sql = 'SELECT * FROM '.$this->db->prefix('xoopsheadline').' WHERE headline_id='.$id;
+ if (!$result = $this->db->query($sql)) {
+ return false;
+ }
+ $numrows = $this->db->getRowsNum($result);
+ if ($numrows == 1) {
+ $headline = new XoopsheadlineHeadline();
+ $headline->assignVars($this->db->fetchArray($result));
+ return $headline;
+ }
+ }
+ return false;
+ }
+
+ function insert(&$headline)
+ {
+ if (strtolower(get_class($headline)) != 'xoopsheadlineheadline') {
+ return false;
+ }
+ if (!$headline->cleanVars()) {
+ return false;
+ }
+ foreach ($headline->cleanVars as $k => $v) {
+ ${$k} = $v;
+ }
+ if (empty($headline_id)) {
+ $headline_id = $this->db->genId('xoopsheadline_headline_id_seq');
+ $sql = 'INSERT INTO '.$this->db->prefix('xoopsheadline').' (headline_id, headline_name, headline_url, headline_rssurl, headline_encoding, headline_cachetime, headline_asblock, headline_display, headline_weight, headline_mainimg, headline_mainfull, headline_mainmax, headline_blockimg, headline_blockmax, headline_xml, headline_updated) VALUES ('.$headline_id.', '.$this->db->quoteString($headline_name).', '.$this->db->quoteString($headline_url).', '.$this->db->quoteString($headline_rssurl).', '.$this->db->quoteString($headline_encoding).', '.$headline_cachetime.', '.$headline_asblock.', '.$headline_display.', '.$headline_weight.', '.$headline_mainimg.', '.$headline_mainfull.', '.$headline_mainmax.', '.$headline_blockimg.', '.$headline_blockmax.', '.$this->db->quoteString($headline_xml).', '.time().')';
+ } else {
+ $sql = 'UPDATE '.$this->db->prefix('xoopsheadline').' SET headline_name='.$this->db->quoteString($headline_name).', headline_url='.$this->db->quoteString($headline_url).', headline_rssurl='.$this->db->quoteString($headline_rssurl).', headline_encoding='.$this->db->quoteString($headline_encoding).', headline_cachetime='.$headline_cachetime.', headline_asblock='.$headline_asblock.', headline_display='.$headline_display.', headline_weight='.$headline_weight.', headline_mainimg='.$headline_mainimg.', headline_mainfull='.$headline_mainfull.', headline_mainmax='.$headline_mainmax.', headline_blockimg='.$headline_blockimg.', headline_blockmax='.$headline_blockmax.', headline_xml = '.$this->db->quoteString($headline_xml).', headline_updated='.$headline_updated.' WHERE headline_id='.$headline_id;
+ }
+ if (!$result = $this->db->queryF($sql)) {
+ return false;
+ }
+ if (empty($headline_id)) {
+ $headline_id = $this->db->getInsertId();
+ }
+ $headline->assignVar('headline_id', $headline_id);
+ return $headline_id;
+ }
+
+ function delete(&$headline)
+ {
+ if (get_class($headline) != 'xoopsheadlineheadline') {
+ return false;
+ }
+ $sql = sprintf("DELETE FROM %s WHERE headline_id = %u", $this->db->prefix('xoopsheadline'), $headline->getVar('headline_id'));
+ if (!$result = $this->db->query($sql)) {
+ return false;
+ }
+ return true;
+ }
+
+ function &getObjects($criteria = null)
+ {
+ $ret = array();
+ $limit = $start = 0;
+ $sql = 'SELECT * FROM '.$this->db->prefix('xoopsheadline');
+ if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
+ $sql .= ' '.$criteria->renderWhere();
+ $sql .= ' ORDER BY headline_weight '.$criteria->getOrder();
+ $limit = $criteria->getLimit();
+ $start = $criteria->getStart();
+ }
+ $result = $this->db->query($sql, $limit, $start);
+ if (!$result) {
+ return $ret;
+ }
+ while ($myrow = $this->db->fetchArray($result)) {
+ $headline = new XoopsheadlineHeadline();
+ $headline->assignVars($myrow);
+ $ret[] =& $headline;
+ unset($headline);
+ }
+ return $ret;
+ }
+
+ function getCount($criteria = null)
+ {
+ $sql = 'SELECT COUNT(*) FROM '.$this->db->prefix('xoopsheadline');
+ if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
+ $sql .= ' '.$criteria->renderWhere();
+ }
+ if (!$result =& $this->db->query($sql)) {
+ return 0;
+ }
+ list($count) = $this->db->fetchRow($result);
+ return $count;
+ }
}
?>
\ No newline at end of file