3 // ----------------------------------------------------------------------
4 // POST-NUKE Content Management System
5 // Copyright (C) 2001 by the Post-Nuke Development Team.
6 // http://www.postnuke.com/
7 // ----------------------------------------------------------------------
9 // Thatware - http://thatware.org/
10 // PHP-NUKE Web Portal System - http://phpnuke.org/
11 // ----------------------------------------------------------------------
14 // This program is free software; you can redistribute it and/or
15 // modify it under the terms of the GNU General Public License (GPL)
16 // as published by the Free Software Foundation; either version 2
17 // of the License, or (at your option) any later version.
19 // This program is distributed in the hope that it will be useful,
20 // but WITHOUT ANY WARRANTY; without even the implied warranty of
21 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
22 // GNU General Public License for more details.
24 // To read the license please visit http://www.gnu.org/copyleft/gpl.html
25 // ----------------------------------------------------------------------
26 // Original Author of file:
28 // ----------------------------------------------------------------------
31 $prefix = $pnconfig['prefix'];
35 $autonews = $prefix . '_autonews';
36 $pntable['autonews'] = $autonews;
37 $pntable['autonews_column'] = array ('anid' => $autonews . '.pn_anid',
38 'catid' => $autonews . '.pn_catid',
39 'aid' => $autonews . '.pn_aid',
40 'title' => $autonews . '.pn_title',
41 'time' => $autonews . '.pn_time',
42 'hometext' => $autonews . '.pn_hometext',
43 'bodytext' => $autonews . '.pn_bodytext',
44 'topic' => $autonews . '.pn_topic',
45 'informant' => $autonews . '.pn_informant',
46 'notes' => $autonews . '.pn_notes',
47 'ihome' => $autonews . '.pn_ihome',
48 'alanguage' => $autonews . '.pn_language',
49 'language' => $autonews . '.pn_language',
50 'withcomm' => $autonews . '.pn_withcomm');
52 $banner = $prefix . '_banner';
53 $pntable['banner'] = $banner;
54 $pntable['banner_column'] = array ('bid' => $banner . '.pn_bid',
55 'cid' => $banner . '.pn_cid',
56 'type' => $banner . '.pn_type',
57 'imptotal' => $banner . '.pn_imptotal',
58 'impmade' => $banner . '.pn_impmade',
59 'clicks' => $banner . '.pn_clicks',
60 'imageurl' => $banner . '.pn_imageurl',
61 'clickurl' => $banner . '.pn_clickurl',
62 'date' => $banner . '.pn_date');
64 $bannerclient = $prefix . '_bannerclient';
65 $pntable['bannerclient'] = $bannerclient;
66 $pntable['bannerclient_column'] = array ('cid' => $bannerclient . '.pn_cid',
67 'name' => $bannerclient . '.pn_name',
68 'contact' => $bannerclient . '.pn_contact',
69 'email' => $bannerclient . '.pn_email',
70 'login' => $bannerclient . '.pn_login',
71 'passwd' => $bannerclient . '.pn_passwd',
72 'extrainfo' => $bannerclient . '.pn_extrainfo');
74 $bannerfinish = $prefix . '_bannerfinish';
75 $pntable['bannerfinish'] = $bannerfinish;
76 $pntable['bannerfinish_column'] = array ('bid' => $bannerfinish . '.pn_bid',
77 'cid' => $bannerfinish . '.pn_cid',
78 'impressions' => $bannerfinish . '.pn_impressions',
79 'clicks' => $bannerfinish . '.pn_clicks',
80 'datestart' => $bannerfinish . '.pn_datestart',
81 'dateend' => $bannerfinish . '.pn_dateend');
83 $blocks = $prefix . '_blocks';
84 $pntable['blocks'] = $blocks;
85 $pntable['blocks_column'] = array ('bid' => $blocks . '.pn_bid',
86 'bkey' => $blocks . '.pn_bkey',
87 'title' => $blocks . '.pn_title',
88 'content' => $blocks . '.pn_content',
89 'url' => $blocks . '.pn_url',
90 'mid' => $blocks . '.pn_mid',
91 'position' => $blocks . '.pn_position',
92 'weight' => $blocks . '.pn_weight',
93 'active' => $blocks . '.pn_active',
94 'refresh' => $blocks . '.pn_refresh',
95 'last_update' => $blocks . '.pn_last_update',
96 'blanguage' => $blocks . '.pn_language',
97 'language' => $blocks . '.pn_language');
99 $blocks_buttons = $prefix . '_blocks_buttons';
100 $pntable['blocks_buttons'] = $blocks_buttons;
101 $pntable['blocks_buttons_column'] = array ('id' => $blocks_buttons . '.pn_id',
102 'bid' => $blocks_buttons . '.pn_bid',
103 'title' => $blocks_buttons . '.pn_title',
104 'url' => $blocks_buttons . '.pn_url',
105 'images' => $blocks_buttons . '.pn_images');
107 $comments = $prefix . '_comments';
108 $pntable['comments'] = $comments;
109 $pntable['comments_column'] = array ('tid' => $comments . '.pn_tid',
110 'pid' => $comments . '.pn_pid',
111 'sid' => $comments . '.pn_sid',
112 'date' => $comments . '.pn_date',
113 'name' => $comments . '.pn_name',
114 'email' => $comments . '.pn_email',
115 'url' => $comments . '.pn_url',
116 'host_name' => $comments . '.pn_host_name',
117 'subject' => $comments . '.pn_subject',
118 'comment' => $comments . '.pn_comment',
119 'score' => $comments . '.pn_score',
120 'reason' => $comments . '.pn_reason');
122 $counter = $prefix . '_counter';
123 $pntable['counter'] = $counter;
124 $pntable['counter_column'] = array ('type' => $counter . '.pn_type',
125 'var' => $counter . '.pn_var',
126 'count' => $counter . '.pn_count');
128 $downloads_categories = $prefix . '_downloads_categories';
129 $pntable['downloads_categories'] = $downloads_categories;
130 $pntable['downloads_categories_column'] = array ('cid' => $downloads_categories . '.pn_cid',
131 'title' => $downloads_categories . '.pn_title',
132 'cdescription' => $downloads_categories . '.pn_description');
134 $downloads_downloads = $prefix . '_downloads_downloads';
135 $pntable['downloads_downloads'] = $downloads_downloads;
136 $pntable['downloads_downloads_column'] = array ('lid' => $downloads_downloads . '.pn_lid',
137 'cid' => $downloads_downloads . '.pn_cid',
138 'sid' => $downloads_downloads . '.pn_sid',
139 'title' => $downloads_downloads . '.pn_title',
140 'url' => $downloads_downloads . '.pn_url',
141 'description' => $downloads_downloads . '.pn_description',
142 'date' => $downloads_downloads . '.pn_date',
143 'name' => $downloads_downloads . '.pn_name',
144 'email' => $downloads_downloads . '.pn_email',
145 'hits' => $downloads_downloads . '.pn_hits',
146 'submitter' => $downloads_downloads . '.pn_submitter',
147 'downloadratingsummary' => $downloads_downloads . '.pn_ratingsummary',
148 'totalvotes' => $downloads_downloads . '.pn_totalvotes',
149 'totalcomments' => $downloads_downloads . '.pn_totalcomments',
150 'filesize' => $downloads_downloads . '.pn_filesize',
151 'version' => $downloads_downloads . '.pn_version',
152 'homepage' => $downloads_downloads . '.pn_homepage');
154 $downloads_editorials = $prefix . '_downloads_editorials';
155 $pntable['downloads_editorials'] = $downloads_editorials;
156 $pntable['downloads_editorials_column'] = array ('downloadid' => $downloads_editorials . '.pn_id',
157 'adminid' => $downloads_editorials . '.pn_adminid',
158 'editorialtimestamp' => $downloads_editorials . '.pn_timestamp',
159 'editorialtext' => $downloads_editorials . '.pn_text',
160 'editorialtitle' => $downloads_editorials . '.pn_title');
162 $downloads_modrequest = $prefix . '_downloads_modrequest';
163 $pntable['downloads_modrequest'] = $downloads_modrequest;
164 $pntable['downloads_modrequest_column'] = array ('requestid' => $downloads_modrequest . '.pn_requestid',
165 'lid' => $downloads_modrequest . '.pn_lid',
166 'cid' => $downloads_modrequest . '.pn_cid',
167 'sid' => $downloads_modrequest . '.pn_sid',
168 'title' => $downloads_modrequest . '.pn_title',
169 'url' => $downloads_modrequest . '.pn_url',
170 'description' => $downloads_modrequest . '.pn_description',
171 'modifysubmitter' => $downloads_modrequest . '.pn_modifysubmitter',
172 'brokendownload' => $downloads_modrequest . '.pn_brokendownload',
173 'name' => $downloads_modrequest . '.pn_name',
174 'email' => $downloads_modrequest . '.pn_email',
175 'filesize' => $downloads_modrequest . '.pn_filesize',
176 'version' => $downloads_modrequest . '.pn_version',
177 'homepage' => $downloads_modrequest . '.pn_homepage');
179 $downloads_newdownload = $prefix . '_downloads_newdownload';
180 $pntable['downloads_newdownload'] = $downloads_newdownload;
181 $pntable['downloads_newdownload_column'] = array ('lid' => $downloads_newdownload . '.pn_lid',
182 'cid' => $downloads_newdownload . '.pn_cid',
183 'sid' => $downloads_newdownload . '.pn_sid',
184 'title' => $downloads_newdownload . '.pn_title',
185 'url' => $downloads_newdownload . '.pn_url',
186 'description' => $downloads_newdownload . '.pn_description',
187 'name' => $downloads_newdownload . '.pn_name',
188 'email' => $downloads_newdownload . '.pn_email',
189 'submitter' => $downloads_newdownload . '.pn_submitter',
190 'filesize' => $downloads_newdownload . '.pn_filesize',
191 'version' => $downloads_newdownload . '.pn_version',
192 'homepage' => $downloads_newdownload . '.pn_homepage');
194 $downloads_subcategories = $prefix . '_downloads_subcategories';
195 $pntable['downloads_subcategories'] = $downloads_subcategories;
196 $pntable['downloads_subcategories_column'] = array ('sid' => $downloads_subcategories . '.pn_sid',
197 'cid' => $downloads_subcategories . '.pn_cid',
198 'title' => $downloads_subcategories . '.pn_title');
200 $downloads_votedata = $prefix . '_downloads_votedata';
201 $pntable['downloads_votedata'] = $downloads_votedata;
202 $pntable['downloads_votedata_column'] = array ('ratingdbid' => $downloads_votedata . '.pn_id',
203 'ratinglid' => $downloads_votedata . '.pn_lid',
204 'ratinguser' => $downloads_votedata . '.pn_user',
205 'rating' => $downloads_votedata . '.pn_rating',
206 'ratinghostname' => $downloads_votedata . '.pn_hostname',
207 'ratingcomments' => $downloads_votedata . '.pn_comments',
208 'ratingtimestamp' => $downloads_votedata . '.pn_timestamp');
210 $ephem = $prefix . '_ephem';
211 $pntable['ephem'] = $ephem;
212 $pntable['ephem_column'] = array ('eid' => $ephem . '.pn_eid',
213 'did' => $ephem . '.pn_did',
214 'mid' => $ephem . '.pn_mid',
215 'yid' => $ephem . '.pn_yid',
216 'content' => $ephem . '.pn_content',
217 'elanguage' => $ephem . '.pn_language',
218 'language' => $ephem . '.pn_language');
220 $faqanswer = $prefix . '_faqanswer';
221 $pntable['faqanswer'] = $faqanswer;
222 $pntable['faqanswer_column'] = array ('id' => $faqanswer . '.pn_id',
223 'id_cat' => $faqanswer . '.pn_id_cat',
224 'question' => $faqanswer . '.pn_question',
225 'answer' => $faqanswer . '.pn_answer',
226 'submittedby' => $faqanswer . '.pn_submittedby');
228 $faqcategories = $prefix . '_faqcategories';
229 $pntable['faqcategories'] = $faqcategories;
230 $pntable['faqcategories_column'] = array ('id_cat' => $faqcategories . '.pn_id_cat',
231 'categories' => $faqcategories . '.pn_categories',
232 'flanguage' => $faqcategories . '.pn_language',
233 'language' => $faqcategories . '.pn_language',
234 'parent_id' => $faqcategories . '.pn_parent_id');
236 $group_membership = $prefix . '_group_membership';
237 $pntable['group_membership'] = $group_membership;
238 $pntable['group_membership_column'] = array ('gid' => $group_membership . '.pn_gid',
239 'uid' => $group_membership . '.pn_uid');
241 $group_perms = $prefix . '_group_perms';
242 $pntable['group_perms'] = $group_perms;
243 $pntable['group_perms_column'] = array ('pid' => $group_perms . '.pn_pid',
244 'gid' => $group_perms . '.pn_gid',
245 'sequence' => $group_perms . '.pn_sequence',
246 'realm' => $group_perms . '.pn_realm',
247 'component' => $group_perms . '.pn_component',
248 'instance' => $group_perms . '.pn_instance',
249 'level' => $group_perms . '.pn_level',
250 'bond' => $group_perms . '.pn_bond');
252 $groups = $prefix . '_groups';
253 $pntable['groups'] = $groups;
254 $pntable['groups_column'] = array ('gid' => $groups . '.pn_gid',
255 'name' => $groups . '.pn_name');
257 $headlines = $prefix . '_headlines';
258 $pntable['headlines'] = $headlines;
259 $pntable['headlines_column'] = array ('id' => $headlines . '.pn_id',
260 'sitename' => $headlines . '.pn_sitename',
261 'rssuser' => $headlines . '.pn_rssuser',
262 'rsspasswd' => $headlines . '.pn_rsspasswd',
263 'use_proxy' => $headlines . '.pn_use_proxy',
264 'rssurl' => $headlines . '.pn_rssurl',
265 'maxrows' => $headlines . '.pn_maxrows',
266 'siteurl' => $headlines . '.pn_siteurl',
267 'options' => $headlines . '.pn_options');
269 $hooks = $prefix . '_hooks';
270 $pntable['hooks'] = $hooks;
271 $pntable['hooks_column'] = array ('id' => $hooks . '.pn_id',
272 'object' => $hooks . '.pn_object',
273 'action' => $hooks . '.pn_action',
274 'smodule' => $hooks . '.pn_smodule',
275 'stype' => $hooks . '.pn_stype',
276 'tarea' => $hooks . '.pn_tarea',
277 'tmodule' => $hooks . '.pn_tmodule',
278 'ttype' => $hooks . '.pn_ttype',
279 'tfunc' => $hooks . '.pn_tfunc');
281 $languages_constant = $prefix.'_languages_constant';
282 $pntable['languages_constant'] = $languages_constant;
283 $pntable['languages_constant_column'] = array ('constant' => $languages_constant . '.pn_constant',
284 'file' => $languages_constant . '.pn_file');
286 $languages_file = $prefix.'_languages_file';
287 $pntable['languages_file'] = $languages_file;
288 $pntable['languages_file_column'] = array ('target' => $languages_file . '.pn_target',
289 'source' => $languages_file . '.pn_source');
291 $languages_translation = $prefix.'_languages_translation';
292 $pntable['languages_translation'] = $languages_translation;
293 $pntable['languages_translation_column'] = array ('language' => $languages_translation . '.pn_language',
294 'constant' => $languages_translation . '.pn_constant',
295 'translation' => $languages_translation . '.pn_translation',
296 'level' => $languages_translation . '.pn_level');
298 $links_categories = $prefix . '_links_categories';
299 $pntable['links_categories'] = $links_categories;
300 $pntable['links_categories_column'] = array ('cat_id' => $links_categories . '.pn_cat_id',
301 'parent_id' => $links_categories . '.pn_parent_id',
302 'title' => $links_categories . '.pn_title',
303 'cdescription' => $links_categories . '.pn_description');
305 $links_editorials = $prefix . '_links_editorials';
306 $pntable['links_editorials'] = $links_editorials;
307 $pntable['links_editorials_column'] = array ('linkid' => $links_editorials . '.pn_linkid',
308 'adminid' => $links_editorials . '.pn_adminid',
309 'editorialtimestamp' => $links_editorials . '.pn_timestamp',
310 'editorialtext' => $links_editorials . '.pn_text',
311 'editorialtitle' => $links_editorials . '.pn_title');
313 $links_links = $prefix . '_links_links';
314 $pntable['links_links'] = $links_links;
315 $pntable['links_links_column'] = array ('lid' => $links_links . '.pn_lid',
316 'cat_id' => $links_links . '.pn_cat_id',
317 'title' => $links_links . '.pn_title',
318 'url' => $links_links . '.pn_url',
319 'description' => $links_links . '.pn_description',
320 'date' => $links_links . '.pn_date',
321 'name' => $links_links . '.pn_name',
322 'email' => $links_links . '.pn_email',
323 'hits' => $links_links . '.pn_hits',
324 'submitter' => $links_links . '.pn_submitter',
325 'linkratingsummary' => $links_links . '.pn_ratingsummary',
326 'totalvotes' => $links_links . '.pn_totalvotes',
327 'totalcomments' => $links_links . '.pn_totalcomments');
329 $links_modrequest = $prefix . '_links_modrequest';
330 $pntable['links_modrequest'] = $links_modrequest;
331 $pntable['links_modrequest_column'] = array ('requestid' => $links_modrequest . '.pn_requestid',
332 'lid' => $links_modrequest . '.pn_lid',
333 'cat_id' => $links_modrequest . '.pn_cat_id',
334 'sid' => $links_modrequest . '.pn_sid',
335 'title' => $links_modrequest . '.pn_title',
336 'url' => $links_modrequest . '.pn_url',
337 'description' => $links_modrequest . '.pn_description',
338 'modifysubmitter' => $links_modrequest . '.pn_modifysubmitter',
339 'brokenlink' => $links_modrequest . '.pn_brokenlink');
341 $links_newlink = $prefix . '_links_newlink';
342 $pntable['links_newlink'] = $links_newlink;
343 $pntable['links_newlink_column'] = array ('lid' => $links_newlink . '.pn_lid',
344 'cat_id' => $links_newlink . '.pn_cat_id',
345 'title' => $links_newlink . '.pn_title',
346 'url' => $links_newlink . '.pn_url',
347 'description' => $links_newlink . '.pn_description',
348 'name' => $links_newlink . '.pn_name',
349 'email' => $links_newlink . '.pn_email',
350 'submitter' => $links_newlink . '.pn_submitter');
352 $links_votedata = $prefix . '_links_votedata';
353 $pntable['links_votedata'] = $links_votedata;
354 $pntable['links_votedata_column'] = array ('ratingdbid' => $links_votedata . '.pn_id',
355 'ratinglid' => $links_votedata . '.pn_lid',
356 'ratinguser' => $links_votedata . '.pn_user',
357 'rating' => $links_votedata . '.pn_rating',
358 'ratinghostname' => $links_votedata . '.pn_hostname',
359 'ratingcomments' => $links_votedata . '.pn_comments',
360 'ratingtimestamp' => $links_votedata . '.pn_timestamp');
362 $message = $prefix . '_message';
363 $pntable['message'] = $message;
364 $pntable['message_column'] = array ('mid' => $message . '.pn_mid',
365 'title' => $message . '.pn_title',
366 'content' => $message . '.pn_content',
367 'date' => $message . '.pn_date',
368 'expire' => $message . '.pn_expire',
369 'active' => $message . '.pn_active',
370 'view' => $message . '.pn_view',
371 'mlanguage' => $message . '.pn_language',
372 'language' => $message . '.pn_language');
374 $module_vars = $prefix . '_module_vars';
375 $pntable['module_vars'] = $module_vars;
376 $pntable['module_vars_column'] = array ('id' => $module_vars . '.pn_id',
377 'modname' => $module_vars . '.pn_modname',
378 'name' => $module_vars . '.pn_name',
379 'value' => $module_vars . '.pn_value');
381 $modules = $prefix . '_modules';
382 $pntable['modules'] = $modules;
383 $pntable['modules_column'] = array ('id' => $modules . '.pn_id',
384 'name' => $modules . '.pn_name',
385 'type' => $modules . '.pn_type',
386 'displayname' => $modules . '.pn_displayname',
387 'description' => $modules . '.pn_description',
388 'regid' => $modules . '.pn_regid',
389 'directory' => $modules . '.pn_directory',
390 'version' => $modules . '.pn_version',
391 'admin_capable' => $modules . '.pn_admin_capable',
392 'user_capable' => $modules . '.pn_user_capable',
393 'state' => $modules . '.pn_state');
395 $poll_check = $prefix . '_poll_check';
396 $pntable['poll_check'] = $poll_check;
397 $pntable['poll_check_column'] = array ('ip' => $poll_check . '.pn_ip',
398 'time' => $poll_check . '.pn_time');
400 $poll_data = $prefix . '_poll_data';
401 $pntable['poll_data'] = $poll_data;
402 $pntable['poll_data_column'] = array ('pollid' => $poll_data . '.pn_pollid',
403 'optiontext' => $poll_data . '.pn_optiontext',
404 'optioncount' => $poll_data . '.pn_optioncount',
405 'voteid' => $poll_data . '.pn_voteid');
407 $poll_desc = $prefix . '_poll_desc';
408 $pntable['poll_desc'] = $poll_desc;
409 $pntable['poll_desc_column'] = array ('pollid' => $poll_desc . '.pn_pollid',
410 'polltitle' => $poll_desc . '.pn_title',
411 'timestamp' => $poll_desc . '.pn_timestamp',
412 'voters' => $poll_desc . '.pn_voters',
413 'planguage' => $poll_desc . '.pn_language',
414 'language' => $poll_desc . '.pn_language');
416 $pollcomments = $prefix . '_pollcomments';
417 $pntable['pollcomments'] = $pollcomments;
418 $pntable['pollcomments_column'] = array ('tid' => $pollcomments . '.pn_tid',
419 'pid' => $pollcomments . '.pn_pid',
420 'pollid' => $pollcomments . '.pn_pollid',
421 'date' => $pollcomments . '.pn_date',
422 'name' => $pollcomments . '.pn_name',
423 'email' => $pollcomments . '.pn_email',
424 'url' => $pollcomments . '.pn_url',
425 'host_name' => $pollcomments . '.pn_host_name',
426 'subject' => $pollcomments . '.pn_subject',
427 'comment' => $pollcomments . '.pn_comment',
428 'score' => $pollcomments . '.pn_score',
429 'reason' => $pollcomments . '.pn_reason');
431 $priv_msgs = $prefix . '_priv_msgs';
432 $pntable['priv_msgs'] = $priv_msgs;
433 $pntable['priv_msgs_column'] = array ('msg_id' => $priv_msgs . '.pn_msg_id',
434 'msg_image' => $priv_msgs . '.pn_msg_image',
435 'subject' => $priv_msgs . '.pn_subject',
436 'from_userid' => $priv_msgs . '.pn_from_userid',
437 'to_userid' => $priv_msgs . '.pn_to_userid',
438 'msg_time' => $priv_msgs . '.pn_msg_time',
439 'msg_text' => $priv_msgs . '.pn_msg_text',
440 'read_msg' => $priv_msgs . '.pn_read_msg');
442 $queue = $prefix . '_queue';
443 $pntable['queue'] = $queue;
444 $pntable['queue_column'] = array ('qid' => $queue . '.pn_qid',
445 'uid' => $queue . '.pn_uid',
446 'arcd' => $queue . '.pn_arcd',
447 'uname' => $queue . '.pn_uname',
448 'subject' => $queue . '.pn_subject',
449 'story' => $queue . '.pn_story',
450 'timestamp' => $queue . '.pn_timestamp',
451 'topic' => $queue . '.pn_topic',
452 'alanguage' => $queue . '.pn_language',
453 'language' => $queue . '.pn_language',
454 'bodytext' => $queue . '.pn_bodytext');
456 $realms = $prefix . '_realms';
457 $pntable['realms'] = $realms;
458 $pntable['realms_column'] = array ('rid' => $realms . '.pn_rid',
459 'name' => $realms . '.pn_name');
461 $referer = $prefix . '_referer';
462 $pntable['referer'] = $referer;
463 $pntable['referer_column'] = array ('rid' => $referer . '.pn_rid',
464 'url' => $referer . '.pn_url',
465 'frequency' => $referer . '.pn_frequency');
467 $related = $prefix . '_related';
468 $pntable['related'] = $related;
469 $pntable['related_column'] = array ('rid' => $related . '.pn_rid',
470 'tid' => $related . '.pn_tid',
471 'name' => $related . '.pn_name',
472 'url' => $related . '.pn_url');
474 $reviews = $prefix . '_reviews';
475 $pntable['reviews'] = $reviews;
476 $pntable['reviews_column'] = array ('id' => $reviews . '.pn_id',
477 'date' => $reviews . '.pn_date',
478 'title' => $reviews . '.pn_title',
479 'text' => $reviews . '.pn_text',
480 'reviewer' => $reviews . '.pn_reviewer',
481 'email' => $reviews . '.pn_email',
482 'score' => $reviews . '.pn_score',
483 'cover' => $reviews . '.pn_cover',
484 'url' => $reviews . '.pn_url',
485 'url_title' => $reviews . '.pn_url_title',
486 'hits' => $reviews . '.pn_hits',
487 'rlanguage' => $reviews . '.pn_language',
488 'language' => $reviews . '.pn_language');
490 $reviews_add = $prefix . '_reviews_add';
491 $pntable['reviews_add'] = $reviews_add;
492 $pntable['reviews_add_column'] = array ('id' => $reviews_add . '.pn_id',
493 'date' => $reviews_add . '.pn_date',
494 'title' => $reviews_add . '.pn_title',
495 'text' => $reviews_add . '.pn_text',
496 'reviewer' => $reviews_add . '.pn_reviewer',
497 'email' => $reviews_add . '.pn_email',
498 'score' => $reviews_add . '.pn_score',
499 'url' => $reviews_add . '.pn_url',
500 'url_title' => $reviews_add . '.pn_url_title',
501 'rlanguage' => $reviews_add . '.pn_language',
502 'language' => $reviews_add . '.pn_language');
504 $reviews_comments = $prefix . '_reviews_comments';
505 $pntable['reviews_comments'] = $reviews_comments;
506 $pntable['reviews_comments_column'] = array ('cid' => $reviews_comments . '.pn_cid',
507 'rid' => $reviews_comments . '.pn_rid',
508 'userid' => $reviews_comments . '.pn_userid',
509 'date' => $reviews_comments . '.pn_date',
510 'comments' => $reviews_comments . '.pn_comments',
511 'score' => $reviews_comments . '.pn_score');
513 $reviews_main = $prefix . '_reviews_main';
514 $pntable['reviews_main'] = $reviews_main;
515 $pntable['reviews_main_column'] = array ('title' => $reviews_main . '.pn_title',
516 'description' => $reviews_main . '.pn_description');
518 $seccont = $prefix . '_seccont';
519 $pntable['seccont'] = $seccont;
520 $pntable['seccont_column'] = array ('artid' => $seccont . '.pn_artid',
521 'secid' => $seccont . '.pn_secid',
522 'title' => $seccont . '.pn_title',
523 'content' => $seccont . '.pn_content',
524 'counter' => $seccont . '.pn_counter',
525 'slanguage' => $seccont . '.pn_language',
526 'language' => $seccont . '.pn_language');
528 $sections = $prefix . '_sections';
529 $pntable['sections'] = $sections;
530 $pntable['sections_column'] = array ('secid' => $sections . '.pn_secid',
531 'secname' => $sections . '.pn_secname',
532 'image' => $sections . '.pn_image');
534 $session_info = $prefix . '_session_info';
535 $pntable['session_info'] = $session_info;
536 $pntable['session_info_column'] = array ('sessid' => $session_info . '.pn_sessid',
537 'ipaddr' => $session_info . '.pn_ipaddr',
538 'firstused' => $session_info . '.pn_firstused',
539 'lastused' => $session_info . '.pn_lastused',
540 'uid' => $session_info . '.pn_uid',
541 'vars' => $session_info . '.pn_vars');
543 $stats_date = $prefix . '_stats_date';
544 $pntable['stats_date'] = $stats_date;
545 $pntable['stats_date_column'] = array ('date' => $stats_date . '.pn_date',
546 'hits' => $stats_date . '.pn_hits');
548 $stats_hour = $prefix . '_stats_hour';
549 $pntable['stats_hour'] = $stats_hour;
550 $pntable['stats_hour_column'] = array ('hour' => $stats_hour . '.pn_hour',
551 'hits' => $stats_hour . '.pn_hits');
553 $stats_month = $prefix . '_stats_month';
554 $pntable['stats_month'] = $stats_month;
555 $pntable['stats_month_column'] = array ('month' => $stats_month . '.pn_month',
556 'hits' => $stats_month . '.pn_hits');
558 $stats_week = $prefix . '_stats_week';
559 $pntable['stats_week'] = $stats_week;
560 $pntable['stats_week_column'] = array ('weekday' => $stats_week . '.pn_weekday',
561 'hits' => $stats_week . '.pn_hits');
563 $stories = $prefix . '_stories';
564 $pntable['stories'] = $stories;
565 $pntable['stories_column'] = array ('sid' => $stories . '.pn_sid',
566 'cid' => $stories . '.pn_catid',
567 'catid' => $stories . '.pn_catid', // for back compat
568 'aid' => $stories . '.pn_aid',
569 'title' => $stories . '.pn_title',
570 'time' => $stories . '.pn_time',
571 'hometext' => $stories . '.pn_hometext',
572 'bodytext' => $stories . '.pn_bodytext',
573 'comments' => $stories . '.pn_comments',
574 'counter' => $stories . '.pn_counter',
575 'topic' => $stories . '.pn_topic',
576 'informant' => $stories . '.pn_informant',
577 'notes' => $stories . '.pn_notes',
578 'ihome' => $stories . '.pn_ihome',
579 'themeoverride' => $stories . '.pn_themeoverride',
580 'alanguage' => $stories . '.pn_language',
581 'language' => $stories . '.pn_language',
582 'withcomm' => $stories . '.pn_withcomm',
583 'format_type' => $stories . '.pn_format_type');
585 $stories_cat = $prefix . '_stories_cat';
586 $pntable['stories_cat'] = $stories_cat;
587 $pntable['stories_cat_column'] = array ('catid' => $stories_cat . '.pn_catid',
588 'title' => $stories_cat . '.pn_title',
589 'counter' => $stories_cat . '.pn_counter',
590 'themeoverride' => $stories_cat . '.pn_themeoverride');
592 $topics = $prefix . '_topics';
593 $pntable['topics'] = $topics;
594 $pntable['topics_column'] = array ('tid' => $topics . '.pn_topicid',
595 'topicid' => $topics . '.pn_topicid', // for back compat
596 'topicname' => $topics . '.pn_topicname',
597 'topicimage' => $topics . '.pn_topicimage',
598 'topictext' => $topics . '.pn_topictext',
599 'counter' => $topics . '.pn_counter');
601 $user_data = $prefix . '_user_data';
602 $pntable['user_data'] = $user_data;
603 $pntable['user_data_column'] = array ('uda_id' => $user_data . '.pn_uda_id',
604 'uda_propid' => $user_data . '.pn_uda_propid',
605 'uda_uid' => $user_data . '.pn_uda_uid',
606 'uda_value' => $user_data . '.pn_uda_value');
608 $user_perms = $prefix . '_user_perms';
609 $pntable['user_perms'] = $user_perms;
610 $pntable['user_perms_column'] = array ('pid' => $user_perms . '.pn_pid',
611 'uid' => $user_perms . '.pn_uid',
612 'sequence' => $user_perms . '.pn_sequence',
613 'realm' => $user_perms . '.pn_realm',
614 'component' => $user_perms . '.pn_component',
615 'instance' => $user_perms . '.pn_instance',
616 'level' => $user_perms . '.pn_level',
617 'bond' => $user_perms . '.pn_bond');
619 $user_property = $prefix . '_user_property';
620 $pntable['user_property'] = $user_property;
621 $pntable['user_property_column'] = array ('prop_id' => $user_property . '.pn_prop_id',
622 'prop_label' => $user_property . '.pn_prop_label',
623 'prop_dtype' => $user_property . '.pn_prop_dtype',
624 'prop_length' => $user_property . '.pn_prop_length',
625 'prop_weight' => $user_property . '.pn_prop_weight',
626 'prop_validation' => $user_property . '.pn_prop_validation'
629 $userblocks = $prefix . '_userblocks';
630 $pntable['userblocks'] = $userblocks;
631 $pntable['userblocks_column'] = array ('uid' => $userblocks . '.pn_uid',
632 'bid' => $userblocks . '.pn_bid',
633 'active' => $userblocks . '.pn_active',
634 'lastupdate' => $userblocks . '.pn_lastupdate');
636 $users = $prefix . '_users';
637 $pntable['users'] = $users;
638 $pntable['users_column'] = array ('uid' => $users . '.pn_uid',
639 'name' => $users . '.pn_name',
640 'uname' => $users . '.pn_uname',
641 'email' => $users . '.pn_email',
642 'femail' => $users . '.pn_femail',
643 'url' => $users . '.pn_url',
644 'user_avatar' => $users . '.pn_user_avatar',
645 'user_regdate' => $users . '.pn_user_regdate',
646 'user_icq' => $users . '.pn_user_icq',
647 'user_occ' => $users . '.pn_user_occ',
648 'user_from' => $users . '.pn_user_from',
649 'user_intrest' => $users . '.pn_user_intrest',
650 'user_sig' => $users . '.pn_user_sig',
651 'user_viewemail' => $users . '.pn_user_viewemail',
652 'user_theme' => $users . '.pn_user_theme',
653 'user_aim' => $users . '.pn_user_aim',
654 'user_yim' => $users . '.pn_user_yim',
655 'user_msnm' => $users . '.pn_user_msnm',
656 'pass' => $users . '.pn_pass',
657 'storynum' => $users . '.pn_storynum',
658 'umode' => $users . '.pn_umode',
659 'uorder' => $users . '.pn_uorder',
660 'thold' => $users . '.pn_thold',
661 'noscore' => $users . '.pn_noscore',
662 'bio' => $users . '.pn_bio',
663 'ublockon' => $users . '.pn_ublockon',
664 'ublock' => $users . '.pn_ublock',
665 'theme' => $users . '.pn_theme',
666 'commentmax' => $users . '.pn_commentmax',
667 'counter' => $users . '.pn_counter',
668 'timezone_offset' => $users . '.pn_timezone_offset');
