<?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");
?>