Location: PHPKode > projects > ProNuke. Postnuke To Oracle > postnuke/html/pntables.php
<?php
// File: $Id: pntables.php,v 1.17 2001/12/06 02:31:08 acm3 Exp $ $Name:  $
// ----------------------------------------------------------------------
// POST-NUKE Content Management System
// Copyright (C) 2001 by the Post-Nuke Development Team.
// http://www.postnuke.com/
// ----------------------------------------------------------------------
// Based on:
// PHP-NUKE Web Portal System - http://phpnuke.org/
// Thatware - http://thatware.org/
// ----------------------------------------------------------------------
// LICENSE
//
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License (GPL)
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// To read the license please visit http://www.gnu.org/copyleft/gpl.html
// ----------------------------------------------------------------------
// Original Author of file:
// Purpose of file:
// ----------------------------------------------------------------------
// Update history
// ORACLEDONE
// ===FTO. 26/02/2002.
// Changed SQL columnname for
// UID_,COMMENT_,LEVEL_,DATE,VIEW,TYPE,CONSTANT,FILE   (suffix _ _)
// because they are Oracle reserved words.
// Renammed TITLE to CATITLE fro nuke_stories_cat because ambigous
// with title of nuke_categories when you join with Oracle.
// ----------------------------------------------------------------------


$pntable = array();

$pntable['autolinks'] = $prefix.'_autolinks';
$pntable['autolinks_column'] = array ('lid'        => "$pntable[autolinks].lid",
                                      'keyword'        => "$pntable[autolinks].keyword",
                                      'title'        => "$pntable[autolinks].title",
                                      'url'        => "$pntable[autolinks].url",
                                      'comment'        => "$pntable[autolinks].comment_");

$pntable['autonews'] = $prefix.'_autonews';
$pntable['autonews_column'] = array ('anid'      => "$pntable[autonews].anid",
                                     'catid'     => "$pntable[autonews].catid",
                                     'aid'       => "$pntable[autonews].aid",
                                     'title'     => "$pntable[autonews].title",
                                     'time'      => "$pntable[autonews].time",
                                     'hometext'         => "$pntable[autonews].hometext",
                                     'bodytext'         => "$pntable[autonews].bodytext",
                                     'topic'         => "$pntable[autonews].topic",
                                     'informant' => "$pntable[autonews].informant",
                                     'notes'         => "$pntable[autonews].notes",
                                     'ihome'     => "$pntable[autonews].ihome",
                                     'alanguage' => "$pntable[autonews].alanguage",
                                     'withcomm'  => "$pntable[autonews].withcomm");

$pntable['banner'] = $prefix.'_banner';
$pntable['banner_column'] = array ('bid'      => "$pntable[banner].bid",
                                   'cid'      => "$pntable[banner].cid",
                                   'imptotal' => "$pntable[banner].imptotal",
                                   'impmade'  => "$pntable[banner].impmade",
                                   'clicks'   => "$pntable[banner].clicks",
                                   'imageurl' => "$pntable[banner].imageurl",
                                   'clickurl' => "$pntable[banner].clickurl",
                                   'date'     => "$pntable[banner].date_");

$pntable['bannerclient'] = $prefix.'_bannerclient';
$pntable['bannerclient_column'] = array ('cid'       => "$pntable[bannerclient].cid",
                                         'name'      => "$pntable[bannerclient].name",
                                         'contact'   => "$pntable[bannerclient].contact",
                                         'email'     => "$pntable[bannerclient].email",
                                         'login'     => "$pntable[bannerclient].login",
                                         'passwd'    => "$pntable[bannerclient].passwd",
                                         'extrainfo' => "$pntable[bannerclient].extrainfo");

$pntable['bannerfinish'] = $prefix.'_bannerfinish';
$pntable['bannerfinish_column'] = array ('bid'         => "$pntable[bannerfinish].bid",
                                         'cid'               => "$pntable[bannerfinish].cid",
                                         'impressions' => "$pntable[bannerfinish].impressions",
                                         'clicks'      => "$pntable[bannerfinish].clicks",
                                         'datestart'   => "$pntable[bannerfinish].date_start",
                                         'dateend'     => "$pntable[bannerfinish].date_end");

$pntable['blocks'] = $prefix.'_blocks';
$pntable['blocks_column'] = array ('bid'         => "$pntable[blocks].bid",
                                   'bkey'         => "$pntable[blocks].bkey",
                                   'title'         => "$pntable[blocks].title",
                                   'content'         => "$pntable[blocks].content",
                                   'url'         => "$pntable[blocks].url",
                                   'position'         => "$pntable[blocks].position",
                                   'weight'         => "$pntable[blocks].weight",
                                   'active'         => "$pntable[blocks].active",
                                   'refresh'         => "$pntable[blocks].refresh",
                                   'last_update' => "$pntable[blocks].last_update",
                                   'blanguage'         => "$pntable[blocks].blanguage");

$pntable['blocks_buttons'] = $prefix.'_blocks_buttons';
$pntable['blocks_buttons_column'] = array ('id'     => "$pntable[blocks_buttons].id",
                                           'bid'    => "$pntable[blocks_buttons].bid",
                                           'title'  => "$pntable[blocks_buttons].title",
                                           'url'    => "$pntable[blocks_buttons].url",
                                           'images' => "$pntable[blocks_buttons].images");

$pntable['comments'] = $prefix.'_comments';
$pntable['comments_column'] = array ('tid'       => "$pntable[comments].tid",
                                     'pid'       => "$pntable[comments].pid",
                                     'sid'         => "$pntable[comments].sid",
                                     'date'         => "$pntable[comments].date_",
                                     'name'         => "$pntable[comments].name",
                                     'email'         => "$pntable[comments].email",
                                     'url'         => "$pntable[comments].url",
                                     'host_name' => "$pntable[comments].host_name",
                                     'subject'         => "$pntable[comments].subject",
                                     'comment'         => "$pntable[comments].comment_",
                                     'score'         => "$pntable[comments].score",
                                     'reason'         => "$pntable[comments].reason");

$pntable['counter'] = $prefix.'_counter';
$pntable['counter_column'] = array ('type'  => "$pntable[counter].type_",
                                    'var'   => "$pntable[counter].var",
                                    'count' => "$pntable[counter].count");

$pntable['downloads_categories'] = $prefix.'_downloads_categories';
$pntable['downloads_categories_column'] = array ('cid'          => "$pntable[downloads_categories].cid",
                                                 'title'        => "$pntable[downloads_categories].title",
                                                 'cdescription' => "$pntable[downloads_categories].cdescription");

$pntable['downloads_downloads'] = $prefix.'_downloads_downloads';
$pntable['downloads_downloads_column'] = array ('lid'                         => "$pntable[downloads_downloads].lid",
                                                'cid'                         => "$pntable[downloads_downloads].cid",
                                                'sid'                         => "$pntable[downloads_downloads].sid",
                                                'title'                              => "$pntable[downloads_downloads].title",
                                                'url'                              => "$pntable[downloads_downloads].url",
                                                'description'                 => "$pntable[downloads_downloads].description",
                                                'date'                        => "$pntable[downloads_downloads].date_",
                                                'name'                        => "$pntable[downloads_downloads].name",
                                                'email'                       => "$pntable[downloads_downloads].email",
                                                'hits'                        => "$pntable[downloads_downloads].hits",
                                                'submitter'                   => "$pntable[downloads_downloads].submitter",
                                                'downloadratingsummary'        => "$pntable[downloads_downloads].downloadratingsummary",
                                                'totalvotes'                => "$pntable[downloads_downloads].totalvotes",
                                                'totalcomments'                => "$pntable[downloads_downloads].totalcomments",
                                                'filesize'                => "$pntable[downloads_downloads].filesize",
                                                'version'                => "$pntable[downloads_downloads].version",
                                                'homepage'                => "$pntable[downloads_downloads].homepage");

$pntable['downloads_editorials'] = $prefix.'_downloads_editorials';
$pntable['downloads_editorials_column'] = array ('downloadid'              => "$pntable[downloads_editorials].downloadid",
                                                 'adminid'              => "$pntable[downloads_editorials].adminid",
                                                 'editorialtimestamp' => "$pntable[downloads_editorials].editorialtimestamp",
                                                 'editorialtext'      => "$pntable[downloads_editorials].editorialtext",
                                                 'editorialtitle'     => "$pntable[downloads_editorials].editorialtitle");

$pntable['downloads_modrequest'] = $prefix.'_downloads_modrequest';
$pntable['downloads_modrequest_column'] = array ('requestid'       => "$pntable[downloads_modrequest].requestid",
                                                 'lid'                   => "$pntable[downloads_modrequest].lid",
                                                 'cid'                   => "$pntable[downloads_modrequest].cid",
                                                 'sid'                   => "$pntable[downloads_modrequest].sid",
                                                 'title'           => "$pntable[downloads_modrequest].title",
                                                 'url'             => "$pntable[downloads_modrequest].url",
                                                 'description'     => "$pntable[downloads_modrequest].description",
                                                 'modifysubmitter' => "$pntable[downloads_modrequest].modifysubmitter",
                                                 'brokendownload'  => "$pntable[downloads_modrequest].brokendownload",
                                                 'name'                   => "$pntable[downloads_modrequest].name",
                                                 'email'           => "$pntable[downloads_modrequest].email",
                                                 'filesize'        => "$pntable[downloads_modrequest].filesize",
                                                 'version'         => "$pntable[downloads_modrequest].version",
                                                 'homepage'        => "$pntable[downloads_modrequest].homepage");

$pntable['downloads_newdownload'] = $prefix.'_downloads_newdownload';
$pntable['downloads_newdownload_column'] = array ('lid'           => "$pntable[downloads_newdownload].lid",
                                                  'cid'                => "$pntable[downloads_newdownload].cid",
                                                  'sid'                => "$pntable[downloads_newdownload].sid",
                                                  'title'        => "$pntable[downloads_newdownload].title",
                                                  'url'                => "$pntable[downloads_newdownload].url",
                                                  'description' => "$pntable[downloads_newdownload].description",
                                                  'name'        => "$pntable[downloads_newdownload].name",
                                                  'email'        => "$pntable[downloads_newdownload].email",
                                                  'submitter'        => "$pntable[downloads_newdownload].submitter",
                                                  'filesize'        => "$pntable[downloads_newdownload].filesize",
                                                  'version'        => "$pntable[downloads_newdownload].version",
                                                  'homepage'        => "$pntable[downloads_newdownload].homepage");

$pntable['downloads_subcategories'] = $prefix.'_downloads_subcategories';
$pntable['downloads_subcategories_column'] = array ('sid'   => "$pntable[downloads_subcategories].sid",
                                                    'cid'   => "$pntable[downloads_subcategories].cid",
                                                    'title' => "$pntable[downloads_subcategories].title");

$pntable['downloads_votedata'] = $prefix.'_downloads_votedata';
$pntable['downloads_votedata_column'] = array ('ratingdbid'      => "$pntable[downloads_votedata].ratingdbid",
                                               'ratinglid'       => "$pntable[downloads_votedata].ratinglid",
                                               'ratinguser'      => "$pntable[downloads_votedata].ratinguser",
                                               'rating'          => "$pntable[downloads_votedata].rating",
                                               'ratinghostname'         => "$pntable[downloads_votedata].ratinghostname",
                                               'ratingcomments'  => "$pntable[downloads_votedata].ratingcomments",
                                               'ratingtimestamp' => "$pntable[downloads_votedata].ratingtimestamp");

$pntable['ephem'] = $prefix.'_ephem';
$pntable['ephem_column'] = array ('eid'              => "$pntable[ephem].eid",
                                  'did'              => "$pntable[ephem].did",
                                  'mid'              => "$pntable[ephem].mid",
                                  'yid'       => "$pntable[ephem].yid",
                                  'content'   => "$pntable[ephem].content",
                                  'elanguage' => "$pntable[ephem].elanguage");

$pntable['faqanswer'] = $prefix.'_faqanswer';
$pntable['faqanswer_column'] = array ('id'            => "$pntable[faqanswer].id",
                                      'id_cat'            => "$pntable[faqanswer].id_cat",
                                      'question'    => "$pntable[faqanswer].question",
                                      'answer'            => "$pntable[faqanswer].answer",
                                      'submittedby' => "$pntable[faqanswer].submittedby");

$pntable['faqcategories'] = $prefix.'_faqcategories';
$pntable['faqcategories_column'] = array ('id_cat'     => "$pntable[faqcategories].id_cat",
                                          'categories' => "$pntable[faqcategories].categories",
                                          'flanguage'  => "$pntable[faqcategories].flanguage",
                                          'parent_id'  => "$pntable[faqcategories].parent_id");

$pntable['group_membership'] = $prefix.'_group_membership';
$pntable['group_membership_column'] = array ('gid' => "$pntable[group_membership].gid",
                                             'uid' => "$pntable[group_membership].uid_");

$pntable['group_perms'] = $prefix.'_group_perms';
$pntable['group_perms_column'] = array ('pid'       => "$pntable[group_perms].pid",
                                        'gid'       => "$pntable[group_perms].gid",
                                        'sequence'  => "$pntable[group_perms].sequence",
                                        'realm'     => "$pntable[group_perms].realm",
                                        'component' => "$pntable[group_perms].component",
                                        'instance'  => "$pntable[group_perms].instance",
                                        'level'     => "$pntable[group_perms].level_",
                                        'bond'      => "$pntable[group_perms].bond");

$pntable['groups'] = $prefix.'_groups';
$pntable['groups_column'] = array ('gid'  => "$pntable[groups].gid",
                                   'name' => "$pntable[groups].name");

$pntable['headlines'] = $prefix.'_headlines';
$pntable['headlines_column'] = array ('id'          => "$pntable[headlines].id",
                                      'sitename'  => "$pntable[headlines].sitename",
                                      'rssuser'          => "$pntable[headlines].rssuser",
                                      'rsspasswd' => "$pntable[headlines].rsspasswd",
                                      'use_proxy' => "$pntable[headlines].use_proxy",
                                      'rssurl'          => "$pntable[headlines].rssurl",
                                      'maxrows'          => "$pntable[headlines].maxrows",
                                      'siteurl'          => "$pntable[headlines].siteurl",
                                      'options'          => "$pntable[headlines].options");

$pntable['links_categories'] = $prefix.'_links_categories';
$pntable['links_categories_column'] = array ('cat_id'            => "$pntable[links_categories].cat_id",
                                             'parent_id'    => "$pntable[links_categories].parent_id",
                                             'title'            => "$pntable[links_categories].title",
                                             'cdescription' => "$pntable[links_categories].cdescription");

$pntable['links_editorials'] = $prefix.'_links_editorials';
$pntable['links_editorials_column'] = array ('linkid'                  => "$pntable[links_editorials].linkid",
                                             'adminid'                  => "$pntable[links_editorials].adminid",
                                             'editorialtimestamp' => "$pntable[links_editorials].editorialtimestamp",
                                             'editorialtext'          => "$pntable[links_editorials].editorialtext",
                                             'editorialtitle'          => "$pntable[links_editorials].editorialtitle");

$pntable['links_links'] = $prefix.'_links_links';
$pntable['links_links_column'] = array ('lid'                    => "$pntable[links_links].lid",
                                        'cat_id'            => "$pntable[links_links].cat_id",
                                        'title'                    => "$pntable[links_links].title",
                                        'url'                    => "$pntable[links_links].url",
                                        'description'            => "$pntable[links_links].description",
                                        'date'                    => "$pntable[links_links].date_",
                                        'name'                    => "$pntable[links_links].name",
                                        'email'                    => "$pntable[links_links].email",
                                        'hits'                    => "$pntable[links_links].hits",
                                        'submitter'            => "$pntable[links_links].submitter",
                                        'linkratingsummary' => "$pntable[links_links].linkratingsummary",
                                        'totalvotes'            => "$pntable[links_links].totalvotes",
                                        'totalcomments'            => "$pntable[links_links].totalcomments");

$pntable['links_modrequest'] = $prefix.'_links_modrequest';
$pntable['links_modrequest_column'] = array ('requestid'       => "$pntable[links_modrequest].requestid",
                                             'lid'               => "$pntable[links_modrequest].lid",
                                             'cat_id'               => "$pntable[links_modrequest].cat_id",
                                             'title'               => "$pntable[links_modrequest].title",
                                             'url'               => "$pntable[links_modrequest].url",
                                             'description'     => "$pntable[links_modrequest].description",
                                             'modifysubmitter' => "$pntable[links_modrequest].modifysubmitter",
                                             'brokenlink'      => "$pntable[links_modrequest].brokenlink");

$pntable['links_newlink'] = $prefix.'_links_newlink';
$pntable['links_newlink_column'] = array ('lid'                => "$pntable[links_newlink].lid",
                                          'cat_id'        => "$pntable[links_newlink].cat_id",
                                          'title'        => "$pntable[links_newlink].title",
                                          'url'                => "$pntable[links_newlink].url",
                                          'description'        => "$pntable[links_newlink].description",
                                          'name'        => "$pntable[links_newlink].name",
                                          'email'        => "$pntable[links_newlink].email",
                                          'submitter'        => "$pntable[links_newlink].submitter");


//FTO Added column definition
$pntable['languages_constant']        = $prefix.'_languages_constant';
$pntable['languages_constant_column'] = array ('constant' => "$pntable[languages_constant].constant_",
                                               'file'     => "$pntable[languages_constant].file_");

//FTO Added column definition
$pntable['languages_file']            = $prefix.'_languages_file';
$pntable['languages_file_column']     = array ('target' => "$pntable[languages_file].target",
                                               'source' => "$pntable[languages_file].source");
//FTO Added column definition
$pntable['languages_translation']        = $prefix.'_languages_translation';
$pntable['languages_translation_column'] = array ('language'    => "$pntable[languages_translation].language",
                                                  'constant'    => "$pntable[languages_translation].constant_",
                                                  'translation' => "$pntable[languages_translation].translation",
                                                  'level'       => "$pntable[languages_translation].level_");


/*
 * hootbah: I assume that this is depricated, as I can't find any mention of
 * this table in any other files. Will leave in for the time being.
 */
$pntable['links_subcategories'] = $prefix.'_links_subcategories';

$pntable['links_votedata'] = $prefix.'_links_votedata';
$pntable['links_votedata_column'] = array ('ratingdbid'             => "$pntable[links_votedata].ratingdbid",
                                           'ratinglid'             => "$pntable[links_votedata].ratinglid",
                                           'ratinguser'             => "$pntable[links_votedata].ratinguser",
                                           'rating'             => "$pntable[links_votedata].rating",
                                           'ratinghostname'  => "$pntable[links_votedata].ratinghostname",
                                           'ratingcomments'  => "$pntable[links_votedata].ratingcomments",
                                           'ratingtimestamp' => "$pntable[links_votedata].ratingtimestamp");

$pntable['message'] = $prefix.'_message';
$pntable['message_column'] = array ('mid'        => "$pntable[message].mid",
                                    'title'        => "$pntable[message].title",
                                    'content'        => "$pntable[message].content",
                                    'date'        => "$pntable[message].date_",
                                    'expire'        => "$pntable[message].expire",
                                    'active'        => "$pntable[message].active",
                                    'view'        => "$pntable[message].view_",
                                    'mlanguage'        => "$pntable[message].mlanguage");

$pntable['poll_check'] = $prefix.'_poll_check';
$pntable['poll_check_column'] = array ('ip'   => "$pntable[poll_check].ip",
                                       'time' => "$pntable[poll_check].time");

$pntable['poll_data'] = $prefix.'_poll_data';
$pntable['poll_data_column'] = array ('pollid'            => "$pntable[poll_data].pollid",
                                      'optiontext'  => "$pntable[poll_data].optiontext",
                                      'optioncount' => "$pntable[poll_data].optioncount",
                                      'voteid'            => "$pntable[poll_data].voteid");

$pntable['poll_desc'] = $prefix.'_poll_desc';
$pntable['poll_desc_column'] = array ('pollid'          => "$pntable[poll_desc].pollid",
                                      'polltitle' => "$pntable[poll_desc].polltitle",
                                      'timestamp' => "$pntable[poll_desc].timestamp",
                                      'voters'          => "$pntable[poll_desc].voters",
                                      'planguage' => "$pntable[poll_desc].planguage");

$pntable['pollcomments'] = $prefix.'_pollcomments';
$pntable['pollcomments_column'] = array ('tid'             => "$pntable[pollcomments].tid",
                                         'pid'             => "$pntable[pollcomments].pid",
                                         'pollid'    => "$pntable[pollcomments].pollid",
                                         'date'             => "$pntable[pollcomments].date_",
                                         'name'             => "$pntable[pollcomments].name",
                                         'email'     => "$pntable[pollcomments].email",
                                         'url'             => "$pntable[pollcomments].url",
                                         'host_name' => "$pntable[pollcomments].host_name",
                                         'subject'   => "$pntable[pollcomments].subject",
                                         'comment'   => "$pntable[pollcomments].comment_",
                                         'score'     => "$pntable[pollcomments].score",
                                         'reason'    => "$pntable[pollcomments].reason");

$pntable['priv_msgs'] = $prefix.'_priv_msgs';
$pntable['priv_msgs_column'] = array ('msg_id'            => "$pntable[priv_msgs].msg_id",
                                      'msg_image'   => "$pntable[priv_msgs].msg_image",
                                      'subject'            => "$pntable[priv_msgs].subject",
                                      'from_userid' => "$pntable[priv_msgs].from_userid",
                                      'to_userid'   => "$pntable[priv_msgs].to_userid",
                                      'msg_time'    => "$pntable[priv_msgs].msg_time",
                                      'msg_text'    => "$pntable[priv_msgs].msg_text",
                                      'read_msg'    => "$pntable[priv_msgs].read_msg");

$pntable['queue'] = $prefix.'_queue';
$pntable['queue_column'] = array ('qid'              => "$pntable[queue].qid",
                                  'uid'              => "$pntable[queue].uid_",
                                  'arcd'      => "$pntable[queue].arcd",
                                  'uname'     => "$pntable[queue].uname",
                                  'subject'   => "$pntable[queue].subject",
                                  'story'     => "$pntable[queue].story",
                                  'timestamp' => "$pntable[queue].timestamp",
                                  'topic'     => "$pntable[queue].topic",
                                  'alanguage' => "$pntable[queue].alanguage",
                                  'bodytext'  => "$pntable[queue].bodytext");

$pntable['quotes'] = $prefix.'_quotes';
$pntable['quotes_column'] = array ('qid'    => "$pntable[quotes].qid",
                                   'quote'  => "$pntable[quotes].quote",
                                   'author' => "$pntable[quotes].author");

$pntable['realms'] = $prefix.'_realms';
$pntable['realms_column'] = array ('rid'  => "$pntable[realms].rid",
                                   'name' => "$pntable[realms].name");

$pntable['referer'] = $prefix.'_referer';
$pntable['referer_column'] = array ('rid'       => "$pntable[referer].rid",
                                    'url'       => "$pntable[referer].url",
                                    'frequency' => "$pntable[referer].frequency");

$pntable['related'] = $prefix.'_related';
$pntable['related_column'] = array ('rid'  => "$pntable[related].rid",
                                    'tid'  => "$pntable[related].tid",
                                    'name' => "$pntable[related].name",
                                    'url'  => "$pntable[related].url");

$pntable['reviews'] = $prefix.'_reviews';
$pntable['reviews_column'] = array ('id'        => "$pntable[reviews].id",
                                    'date'        => "$pntable[reviews].date_",
                                    'title'        => "$pntable[reviews].title",
                                    'text'        => "$pntable[reviews].text",
                                    'reviewer'        => "$pntable[reviews].reviewer",
                                    'email'        => "$pntable[reviews].email",
                                    'score'        => "$pntable[reviews].score",
                                    'cover'        => "$pntable[reviews].cover",
                                    'url'        => "$pntable[reviews].url",
                                    'url_title' => "$pntable[reviews].url_title",
                                    'hits'        => "$pntable[reviews].hits",
                                    'rlanguage'        => "$pntable[reviews].rlanguage");

$pntable['reviews_add'] = $prefix.'_reviews_add';
$pntable['reviews_add_column'] = array ('id'            => "$pntable[reviews_add].id",
                                        'date'            => "$pntable[reviews_add].date_",
                                        'title'            => "$pntable[reviews_add].title",
                                        'text'            => "$pntable[reviews_add].text",
                                        'reviewer'  => "$pntable[reviews_add].reviewer",
                                        'email'            => "$pntable[reviews_add].email",
                                        'score'            => "$pntable[reviews_add].score",
                                        'url'            => "$pntable[reviews_add].url",
                                        'url_title' => "$pntable[reviews_add].url_title",
                                        'rlanguage' => "$pntable[reviews_add].rlanguage");

$pntable['reviews_comments'] = $prefix.'_reviews_comments';
$pntable['reviews_comments_column'] = array ('cid'        => "$pntable[reviews_comments].cid",
                                             'rid'        => "$pntable[reviews_comments].rid",
                                             'userid'        => "$pntable[reviews_comments].userid",
                                             'date'        => "$pntable[reviews_comments].date_",
                                             'comments' => "$pntable[reviews_comments].comments",
                                             'score'        => "$pntable[reviews_comments].score");

$pntable['reviews_main'] = $prefix.'_reviews_main';
$pntable['reviews_main_column'] = array ('title'      => "$pntable[reviews_main].title",
                                        'description' => "$pntable[reviews_main].description");

$pntable['seccont'] = $prefix.'_seccont';
$pntable['seccont_column'] = array ('artid'        => "$pntable[seccont].artid",
                                    'secid'        => "$pntable[seccont].secid",
                                    'title'        => "$pntable[seccont].title",
                                    'content'        => "$pntable[seccont].content",
                                    'counter'        => "$pntable[seccont].counter",
                                    'slanguage'        => "$pntable[seccont].slanguage");

$pntable['sections'] = $prefix.'_sections';
$pntable['sections_column'] = array ('secid'   => "$pntable[sections].secid",
                                     'secname' => "$pntable[sections].secname",
                                     'image'   => "$pntable[sections].image");

$pntable['session'] = $prefix.'_session';
$pntable['session_column'] = array ('username'        => "$pntable[session].username",
                                    'time'        => "$pntable[session].time",
                                    'host_addr'        => "$pntable[session].host_addr",
                                    'guest'        => "$pntable[session].guest");

$pntable['stats_date'] = $prefix.'_stats_date';
$pntable['stats_date_column'] = array ('date' => "$pntable[stats_date].date_",
                                       'hits' => "$pntable[stats_date].hits");

$pntable['stats_hour'] = $prefix.'_stats_hour';
$pntable['stats_hour_column'] = array ('hour' => "$pntable[stats_hour].hour",
                                       'hits' => "$pntable[stats_hour].hits");

$pntable['stats_month'] = $prefix.'_stats_month';
$pntable['stats_month_column'] = array ('month'        => "$pntable[stats_month].month",
                                        'hits'        => "$pntable[stats_month].hits");

$pntable['stats_week'] = $prefix.'_stats_week';
$pntable['stats_week_column'] = array ('weekday' => "$pntable[stats_week].weekday",
                                       'hits'         => "$pntable[stats_week].hits");

$pntable['stories'] = $prefix.'_stories';
$pntable['stories_column'] = array ('sid'           => "$pntable[stories].sid",
                                    'cid'           => "$pntable[stories].catid",
                                    'catid'         => "$pntable[stories].catid",  // for back compat
                                    'aid'           => "$pntable[stories].aid",
                                    'title'         => "$pntable[stories].title",
                                    'time'          => "$pntable[stories].time",
                                    'hometext'      => "$pntable[stories].hometext",
                                    'bodytext'      => "$pntable[stories].bodytext",
                                    'comments'      => "$pntable[stories].comments",
                                    'counter'       => "$pntable[stories].counter",
                                    'topic'         => "$pntable[stories].topic",
                                    'informant'     => "$pntable[stories].informant",
                                    'notes'         => "$pntable[stories].notes",
                                    'ihome'         => "$pntable[stories].ihome",
                                    'themeoverride' => "$pntable[stories].themeoverride",
                                    'alanguage'     => "$pntable[stories].alanguage",
                                    'withcomm'      => "$pntable[stories].withcomm");

$pntable['stories_cat'] = $prefix.'_stories_cat';
$pntable['stories_cat_column'] = array ('catid'                => "$pntable[stories_cat].catid",
                                        'title'                => "$pntable[stories_cat].catitle",
                                        'counter'        => "$pntable[stories_cat].counter",
                                        'themeoverride'        => "$pntable[stories_cat].themeoverride");

$pntable['topics'] = $prefix.'_topics';
$pntable['topics_column'] = array ('tid'        => "$pntable[topics].topicid",
                                   'topicid'    => "$pntable[topics].topicid", // for back compat
                                   'topicname'  => "$pntable[topics].topicname",
                                   'topicimage' => "$pntable[topics].topicimage",
                                   'topictext'  => "$pntable[topics].topictext",
                                   'counter'    => "$pntable[topics].counter");

$pntable['user_perms'] = $prefix.'_user_perms';
$pntable['user_perms_column'] = array ('pid'       => "$pntable[user_perms].pid",
                                       'uid'       => "$pntable[user_perms].uid_",
                                       'sequence'  => "$pntable[user_perms].sequence",
                                       'realm'     => "$pntable[user_perms].realm",
                                       'component' => "$pntable[user_perms].component",
                                       'instance'  => "$pntable[user_perms].instance",
                                       'level'     => "$pntable[user_perms].level_",
                                       'bond'      => "$pntable[user_perms].bond");

$pntable['userblocks'] = $prefix.'_userblocks';
$pntable['userblocks_column'] = array ('uid'       		=> "$pntable[userblocks].uid_",
                                       'bid'       		=> "$pntable[userblocks].bid",
                                       'active'   		=> "$pntable[userblocks].active",
									   'last_update'	=> "$pntable[userblocks].last_update");

$pntable['users'] = $prefix.'_users';
$pntable['users_column'] = array ('uid'             => "$pntable[users].uid_",
                                  'name'            => "$pntable[users].name",
                                  'uname'           => "$pntable[users].uname",
                                  'email'           => "$pntable[users].email",
                                  'femail'          => "$pntable[users].femail",
                                  'url'             => "$pntable[users].url",
                                  'user_avatar'     => "$pntable[users].user_avatar",
                                  'user_regdate'    => "$pntable[users].user_regdate",
                                  'user_icq'        => "$pntable[users].user_icq",
                                  'user_occ'        => "$pntable[users].user_occ",
                                  'user_from'       => "$pntable[users].user_from",
                                  'user_intrest'    => "$pntable[users].user_intrest",
                                  'user_sig'        => "$pntable[users].user_sig",
                                  'user_viewemail'  => "$pntable[users].user_viewemail",
                                  'user_theme'      => "$pntable[users].user_theme",
                                  'user_aim'        => "$pntable[users].user_aim",
                                  'user_yim'        => "$pntable[users].user_yim",
                                  'user_msnm'       => "$pntable[users].user_msnm",
                                  'pass'            => "$pntable[users].pass",
                                  'storynum'        => "$pntable[users].storynum",
                                  'umode'           => "$pntable[users].umode",
                                  'uorder'          => "$pntable[users].uorder",
                                  'thold'           => "$pntable[users].thold",
                                  'noscore'         => "$pntable[users].noscore",
                                  'bio'             => "$pntable[users].bio",
                                  'ublockon'        => "$pntable[users].ublockon",
                                  'ublock'          => "$pntable[users].ublock",
                                  'theme'           => "$pntable[users].theme",
                                  'commentmax'      => "$pntable[users].commentmax",
                                  'counter'         => "$pntable[users].counter",
                                  'timezone_offset' => "$pntable[users].timezone_offset");
?>
Return current item: ProNuke. Postnuke To Oracle