[geeklog-cvs] geeklog: sp_page_title missing from MS SQL and Postgres requests...

[geeklog-cvs at lists.geeklog.net]

changeset 7852:de03f58c601d
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/de03f58c601d
user: Dirk Haun <dirk at haun-online.de>
date: Sat Mar 27 20:20:07 2010 +0100
description:
sp_page_title missing from MS SQL and Postgres requests; also added a missing Postgres-specific request

diffstat:

 plugins/staticpages/services.inc.php |  10 +++++++---
 1 files changed, 7 insertions(+), 3 deletions(-)

diffs (37 lines):

diff -r 392a3754ef0e -r de03f58c601d plugins/staticpages/services.inc.php
--- a/plugins/staticpages/services.inc.php	Sat Mar 27 19:45:05 2010 +0100
+++ b/plugins/staticpages/services.inc.php	Sat Mar 27 20:20:07 2010 +0100
@@ -574,7 +574,7 @@
                       . "perm_members,perm_anon,sp_tid,sp_help,sp_php,"
                       . "sp_inblock FROM {$_TABLES['staticpage']} "
                       . "WHERE (sp_id = '$page')" . $perms;
-        $sql['mssql'] = "SELECT sp_title,"
+        $sql['mssql'] = "SELECT sp_title,sp_page_title,"
                       . "CAST(sp_content AS text) AS sp_content,sp_hits,"
                       . "created,modified,sp_format,commentcode,"
                       . "CAST(meta_description AS text) AS meta_description,"
@@ -583,7 +583,8 @@
                       . "perm_anon,sp_tid,sp_help,sp_php,sp_inblock "
                       . "FROM {$_TABLES['staticpage']} WHERE (sp_id = '$page')"
                       . $perms;
-        $sql['pgsql'] = "SELECT sp_title,sp_content,sp_hits,created,modified,sp_format,"
+        $sql['pgsql'] = "SELECT sp_title,sp_page_title,sp_content,sp_hits,"
+                      . "created,modified,sp_format,"
                       . "commentcode,owner_id,group_id,perm_owner,perm_group,"
                       . "perm_members,perm_anon,sp_tid,sp_help,sp_php,"
                       . "sp_inblock FROM {$_TABLES['staticpage']} "
@@ -694,10 +695,13 @@
         $sql['mysql'] = "SELECT sp_id,sp_title,sp_page_title,sp_content,sp_hits,created,modified,sp_format,meta_description,meta_keywords,draft_flag,owner_id,"
                 ."group_id,perm_owner,perm_group,perm_members,perm_anon,sp_tid,sp_help,sp_php,"
                 ."sp_inblock FROM {$_TABLES['staticpage']}" . $perms . $order . $limit;
-        $sql['mssql'] = "SELECT sp_id,sp_title,CAST(sp_content AS text) AS sp_content,sp_hits,"
+        $sql['mssql'] = "SELECT sp_id,sp_title,sp_page_title,CAST(sp_content AS text) AS sp_content,sp_hits,"
                 ."created,modified,sp_format,CAST(meta_description AS text) AS meta_description,CAST(meta_keywords AS text) AS meta_keywords,draft_flag,owner_id,group_id,perm_owner,perm_group,perm_members,"
                 ."perm_anon,sp_tid,sp_help,sp_php,sp_inblock FROM {$_TABLES['staticpage']}"
                 . $perms . $order . $limit;
+        $sql['pgsql'] = "SELECT sp_id,sp_title,sp_page_title,sp_content,sp_hits,created,modified,sp_format,meta_description,meta_keywords,draft_flag,owner_id,"
+                ."group_id,perm_owner,perm_group,perm_members,perm_anon,sp_tid,sp_help,sp_php,"
+                ."sp_inblock FROM {$_TABLES['staticpage']}" . $perms . $order . $limit;
         $result = DB_query($sql);
 
         $count = 0;