[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] sitemgr/inc/class.Pages_SO.inc.php, 1.15
From: |
nomail |
Subject: |
[Phpgroupware-cvs] sitemgr/inc/class.Pages_SO.inc.php, 1.15 |
Date: |
Wed, 21 Jul 2004 01:22:53 +0200 |
Update of /sitemgr/inc
Modified Files:
Branch:
class.Pages_SO.inc.php
date: 2004/07/20 23:22:53; author: skwashd; state: Exp; lines: +92 -56
Log Message:
merge from 16
=====================================================================
Index: sitemgr/inc/class.Pages_SO.inc.php
diff -u sitemgr/inc/class.Pages_SO.inc.php:1.14
sitemgr/inc/class.Pages_SO.inc.php:1.15
--- sitemgr/inc/class.Pages_SO.inc.php:1.14 Fri May 30 04:01:43 2003
+++ sitemgr/inc/class.Pages_SO.inc.php Tue Jul 20 23:22:53 2004
@@ -20,9 +20,15 @@
}
$page_id_list = array();
- $cat_list = is_array($cats) ? implode(',',$cats) :
- ($cats ? $cats :
-
($GLOBALS['Common_BO']->cats->currentcats ?
implode(',',$GLOBALS['Common_BO']->cats->currentcats) : false)
+ $cat_list = (is_array($cats)
+ ? implode(',',$cats)
+ : ($cats
+ ? $cats
+ :
($GLOBALS['Common_BO']->cats->currentcats
+ ?
implode(',',$GLOBALS['Common_BO']->cats->currentcats)
+ : false
+ )
+ )
);
if ($cat_list)
{
@@ -43,34 +49,31 @@
function addPage($cat_id)
{
- $sql = 'INSERT INTO phpgw_sitemgr_pages (cat_id) VALUES
(\'' . $cat_id . '\')';
- $this->db->query($sql, __LINE__,__FILE__);
+ $this->db->query('INSERT INTO phpgw_sitemgr_pages
(cat_id)'
+ . ' VALUES (' . intval($cat_id) . ')',
__LINE__, __FILE__);
return
$this->db->get_last_insert_id('phpgw_sitemgr_pages','page_id');
}
function removePage($page_id)
{
- $sql = 'DELETE FROM phpgw_sitemgr_pages WHERE
page_id=\'' . $page_id . '\'';
- $this->db->query($sql, __LINE__,__FILE__);
- $sql = 'DELETE FROM phpgw_sitemgr_pages_lang WHERE
page_id=\'' . $page_id . '\'';
- $this->db->query($sql, __LINE__,__FILE__);
+ $this->db->query('DELETE FROM phpgw_sitemgr_pages'
+ . ' WHERE page_id=' . intval($page_id),
__LINE__, __FILE__);
+
+ $this->db->query('DELETE FROM phpgw_sitemgr_pages_lang'
+ . ' WHERE page_id=' . intval($page_id),
__LINE__, __FILE__);
}
- function pageExists($page_name,$exclude_page_id)
+ //this function should be a deprecated function - IMHO - skwashd
+ function pageExists($page_name, $exclude_page_id='')
{
- $sql = 'SELECT page_id FROM phpgw_sitemgr_pages WHERE
name=\'' . $page_name . '\'';
- if ($exclude_page_id)
- {
- $sql .= ' and page_id!=\''. $exclude_page_id .
'\'';
- }
- $this->db->query($sql,__LINE__,__FILE__);
- if ($this->db->next_record())
+ $page_id = $this->PagetoID($page_name);
+ if($page_id)
{
- return $this->db->f('page_id');
+ return ($page_id != $exclude_page_id ? $page_id
: False);
}
else
{
- return false;
+ return False;
}
}
@@ -78,7 +81,8 @@
function getlangarrayforpage($page_id)
{
$retval = array();
- $this->db->query("SELECT lang FROM
phpgw_sitemgr_pages_lang WHERE page_id='$page_id'");
+ $this->db->query('SELECT lang FROM
phpgw_sitemgr_pages_lang'
+ . ' WHERE page_id=' . intval($page_id),
__LINE__, __FILE__);
while ($this->db->next_record())
{
$retval[] = $this->db->f('lang');
@@ -88,7 +92,24 @@
function PagetoID($page_name)
{
- $sql = 'SELECT page_id FROM phpgw_sitemgr_pages WHERE
name=\'' . $page_name . '\'';
+ $cats = CreateObject('phpgwapi.categories', -1,
'sitemgr');
+ $cat_list = $cats->return_sorted_array(0, False, '',
'', '', False, CURRENT_SITE_ID);
+
+ if($cat_list)
+ {
+ foreach($cat_list as $null => $val)
+ {
+ $site_cats[] = $val['id'];
+ }
+ }
+
+ $sql = 'SELECT page_id FROM phpgw_sitemgr_pages '
+ . " WHERE name='" .
$this->db->db_addslashes($page_name) . "' ";
+ if($site_cats)
+ {
+ $sql .= 'AND cat_id IN(' . implode(',',
$site_cats) . ')';
+ }
+
$this->db->query($sql,__LINE__,__FILE__);
if ($this->db->next_record())
{
@@ -102,8 +123,8 @@
function getcatidforpage($page_id)
{
- $sql = "SELECT cat_id FROM phpgw_sitemgr_pages WHERE
page_id = $page_id";
- $this->db->query($sql,__LINE__,__FILE__);
+ $this->db->query('SELECT cat_id FROM
phpgw_sitemgr_pages'
+ . ' WHERE page_id = ' . intval($page_id),
__LINE__, __FILE__);
if ($this->db->next_record())
{
return $this->db->f('cat_id');
@@ -116,8 +137,8 @@
function getPage($page_id,$lang=False)
{
- $sql = "SELECT * FROM phpgw_sitemgr_pages WHERE
page_id= $page_id";
- $this->db->query($sql,__LINE__,__FILE__);
+ $this->db->query('SELECT * FROM phpgw_sitemgr_pages'
+ . ' WHERE page_id=' . intval($page_id),
__LINE__, __FILE__);
if ($this->db->next_record())
{
$page = CreateObject('sitemgr.Page_SO', True);
@@ -130,8 +151,10 @@
if ($lang)
{
- $sql = "SELECT * FROM
phpgw_sitemgr_pages_lang WHERE page_id=$page_id AND lang='$lang'";
-
$this->db->query($sql,__LINE__,__FILE__);
+ $this->db->query('SELECT * FROM
phpgw_sitemgr_pages_lang'
+ . ' WHERE page_id=' .
intval($page_id)
+ . " AND lang='" .
$this->db->db_addslashes($lang) . "'"
+ , __LINE__, __FILE__);
if ($this->db->next_record())
{
@@ -148,8 +171,8 @@
//if there is no lang argument we return the
content in whatever languages turns up first
else
{
- $sql = "SELECT * FROM
phpgw_sitemgr_pages_lang WHERE page_id='" . $page->id . "'";
-
$this->db->query($sql,__LINE__,__FILE__);
+ $this->db->query('SELECT * FROM
phpgw_sitemgr_pages_lang'
+ . ' WHERE page_id=' .
intval($page->id), __LINE__, __FILE__);
if ($this->db->next_record())
{
@@ -173,63 +196,76 @@
function savePageInfo($pageInfo)
{
- $sql = 'UPDATE phpgw_sitemgr_pages SET ' .
- 'cat_id=\'' . $pageInfo->cat_id . '\',' .
- 'name=\'' .
$this->db->db_addslashes($pageInfo->name) . '\',' .
- 'sort_order=\'' . (int) $pageInfo->sort_order .
'\',' .
- 'hide_page=\'' . $pageInfo->hidden . '\',' .
- 'state=\'' . $pageInfo->state . '\' ' .
- 'WHERE page_id=\'' . $pageInfo->id . '\'';
- $this->db->query($sql, __LINE__,__FILE__);
+ $this->db->query('UPDATE phpgw_sitemgr_pages SET '
+ . 'cat_id=' . intval($pageInfo->cat_id)
. ', '
+ . 'name=\'' .
$this->db->db_addslashes($pageInfo->name) . '\', '
+ . 'sort_order=' .
intval($pageInfo->sort_order) . ', '
+ . 'hide_page=' .
intval($pageInfo->hidden) . ', '
+ . 'state=' . intval($pageInfo->state) .
' '
+ . 'WHERE page_id=' .
intval($pageInfo->id) . '', __LINE__, __FILE__);
return true;
}
function savePageLang($pageInfo,$lang)
{
$page_id = $pageInfo->id;
- $this->db->query("SELECT * FROM
phpgw_sitemgr_pages_lang WHERE page_id='$page_id' and lang='$lang'",
__LINE__,__FILE__);
+ $this->db->query('SELECT * FROM
phpgw_sitemgr_pages_lang'
+ . ' WHERE page_id=' . intval($page_id)
+ . " AND lang='" .
$this->db->db_addslashes($lang). "'", __LINE__,__FILE__);
if ($this->db->next_record())
{
- $sql = "UPDATE phpgw_sitemgr_pages_lang SET " .
- "title='" .
$this->db->db_addslashes($pageInfo->title) . "'," .
- "subtitle='" .
$this->db->db_addslashes($pageInfo->subtitle) . "' WHERE page_id='$page_id' and
lang='$lang'";
- $this->db->query($sql, __LINE__,__FILE__);
+ $this->db->query('UPDATE
phpgw_sitemgr_pages_lang SET '
+ . " title='" .
$this->db->db_addslashes($pageInfo->title) . "',"
+ . " subtitle='" .
$this->db->db_addslashes($pageInfo->subtitle) . "'"
+ . ' WHERE page_id=' .
intval($page_id)
+ . " AND lang='" .
$this->db->db_addslashes($lang) . "'"
+ , __LINE__,__FILE__);
return true;
}
else
{
- $sql = "INSERT INTO phpgw_sitemgr_pages_lang
(page_id,lang,title,subtitle) VALUES ('$page_id','$lang','" .
-
$this->db->db_addslashes($pageInfo->title) . "','" .
-
$this->db->db_addslashes($pageInfo->subtitle) . "')";
- $this->db->query($sql, __LINE__,__FILE__);
+ $this->db->query('INSERT INTO
phpgw_sitemgr_pages_lang (page_id,lang,title,subtitle)'
+ . ' VALUES ('. intval($page_id)
. ','
+ . "'" .
$this->db->db_addslashes($lang) . "',"
+ . "'" .
$this->db->db_addslashes($pageInfo->title) . "',"
+ . "'" .
$this->db->db_addslashes($pageInfo->subtitle) . "')"
+ , __LINE__,__FILE__);
return true;
}
}
function removealllang($lang)
{
- $sql = "DELETE FROM phpgw_sitemgr_pages_lang WHERE
lang='$lang'";
- $this->db->query($sql, __LINE__,__FILE__);
+ $this->db->query('DELETE FROM phpgw_sitemgr_pages_lang '
+ . " WHERE lang='" .
$this->db->db_addslashes($lang) . "'", __LINE__, __FILE__);
}
function migratealllang($oldlang,$newlang)
{
- $sql = "UPDATE phpgw_sitemgr_pages_lang SET
lang='$newlang' WHERE lang='$oldlang'";
- $this->db->query($sql, __LINE__,__FILE__);
+ $this->db->query('UPDATE phpgw_sitemgr_pages_lang SET'
+ . " lang='" .
$this->db->db_addslashes($newlang) . "'"
+ . " WHERE lang='" .
$this->db->db_addslashes($oldlang) . "'", __LINE__, __FILE__);
}
function commit($page_id)
{
- $sql = "UPDATE phpgw_sitemgr_pages SET state = " .
SITEMGR_STATE_PUBLISH . " WHERE state = " . SITEMGR_STATE_PREPUBLISH . " AND
page_id = $page_id";
- $this->db->query($sql, __LINE__,__FILE__);
- $sql = "UPDATE phpgw_sitemgr_pages SET state = " .
SITEMGR_STATE_ARCHIVE . " WHERE state = " . SITEMGR_STATE_PREUNPUBLISH . " AND
page_id = $page_id";;
- $this->db->query($sql, __LINE__,__FILE__);
+ $this->db->query('UPDATE phpgw_sitemgr_pages SET'
+ . ' state = ' . SITEMGR_STATE_PUBLISH
+ . ' WHERE state = ' .
SITEMGR_STATE_PREPUBLISH
+ . ' AND page_id = ' . intval($page_id),
__LINE__, __FILE__);
+
+ $this->db->query('UPDATE phpgw_sitemgr_pages SET'
+ . ' state = ' . SITEMGR_STATE_ARCHIVE
+ . ' WHERE state = ' .
SITEMGR_STATE_PREUNPUBLISH
+ . ' AND page_id = ' . intval($page_id),
__LINE__, __FILE__);
}
function reactivate($page_id)
{
- $sql = "UPDATE phpgw_sitemgr_pages SET state = " .
SITEMGR_STATE_DRAFT . " WHERE state = " . SITEMGR_STATE_ARCHIVE . " AND page_id
= $page_id";
- $this->db->query($sql, __LINE__,__FILE__);
+ $this->db->query('UPDATE phpgw_sitemgr_pages SET'
+ . ' state = ' . SITEMGR_STATE_DRAFT
+ . ' WHERE state = ' .
SITEMGR_STATE_ARCHIVE
+ . ' AND page_id = ' . intval($page_id),
__LINE__, __FILE__);
}
}
?>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] sitemgr/inc/class.Pages_SO.inc.php, 1.15,
nomail <=