| Code: |
|
$downloads_categories = $prefix . '_downloads_categories';
$pntable['downloads_categories'] = $downloads_categories; $pntable['downloads_categories_column'] = array ('cid' => $downloads_categories . '.pn_cid', 'title' => $downloads_categories . '.pn_title', 'cdescription' => $downloads_categories . '.pn_description'); $downloads_downloads = $prefix . '_downloads_downloads'; $pntable['downloads_downloads'] = $downloads_downloads; $pntable['downloads_downloads_column'] = array ('lid' => $downloads_downloads . '.pn_lid', 'cid' => $downloads_downloads . '.pn_cid', 'sid' => $downloads_downloads . '.pn_sid', 'title' => $downloads_downloads . '.pn_title', 'url' => $downloads_downloads . '.pn_url', 'image' => $downloads_downloads . '.pn_image', 'topic' => $downloads_downloads . '.pn_topic', 'description' => $downloads_downloads . '.pn_description', 'date' => $downloads_downloads . '.pn_date', 'name' => $downloads_downloads . '.pn_name', 'email' => $downloads_downloads . '.pn_email', 'hits' => $downloads_downloads . '.pn_hits', 'submitter' => $downloads_downloads . '.pn_submitter', 'downloadratingsummary' => $downloads_downloads . '.pn_ratingsummary', 'totalvotes' => $downloads_downloads . '.pn_totalvotes', 'totalcomments' => $downloads_downloads . '.pn_totalcomments', 'filesize' => $downloads_downloads . '.pn_filesize', 'version' => $downloads_downloads . '.pn_version', 'homepage' => $downloads_downloads . '.pn_homepage'); $downloads_editorials = $prefix . '_downloads_editorials'; $pntable['downloads_editorials'] = $downloads_editorials; $pntable['downloads_editorials_column'] = array ('downloadid' => $downloads_editorials . '.pn_id', 'adminid' => $downloads_editorials . '.pn_adminid', 'editorialtimestamp' => $downloads_editorials . '.pn_timestamp', 'editorialtext' => $downloads_editorials . '.pn_text', 'editorialtitle' => $downloads_editorials . '.pn_title'); $downloads_modrequest = $prefix . '_downloads_modrequest'; $pntable['downloads_modrequest'] = $downloads_modrequest; $pntable['downloads_modrequest_column'] = array ('requestid' => $downloads_modrequest . '.pn_requestid', 'lid' => $downloads_modrequest . '.pn_lid', 'cid' => $downloads_modrequest . '.pn_cid', 'sid' => $downloads_modrequest . '.pn_sid', 'title' => $downloads_modrequest . '.pn_title', 'url' => $downloads_modrequest . '.pn_url', 'image' => $downloads_modrequest . '.pn_image', 'topic' => $downloads_modrequest . '.pn_topic', 'description' => $downloads_modrequest . '.pn_description', 'modifysubmitter' => $downloads_modrequest . '.pn_modifysubmitter', 'brokendownload' => $downloads_modrequest . '.pn_brokendownload', 'name' => $downloads_modrequest . '.pn_name', 'email' => $downloads_modrequest . '.pn_email', 'filesize' => $downloads_modrequest . '.pn_filesize', 'version' => $downloads_modrequest . '.pn_version', 'homepage' => $downloads_modrequest . '.pn_homepage'); $downloads_newdownload = $prefix . '_downloads_newdownload'; $pntable['downloads_newdownload'] = $downloads_newdownload; $pntable['downloads_newdownload_column'] = array ('lid' => $downloads_newdownload . '.pn_lid', 'cid' => $downloads_newdownload . '.pn_cid', 'sid' => $downloads_newdownload . '.pn_sid', 'title' => $downloads_newdownload . '.pn_title', 'url' => $downloads_newdownload . '.pn_url', 'image' => $downloads_newdownload . '.pn_image', 'topic' => $downloads_newdownload . '.pn_topic', 'description' => $downloads_newdownload . '.pn_description', 'name' => $downloads_newdownload . '.pn_name', 'email' => $downloads_newdownload . '.pn_email', 'submitter' => $downloads_newdownload . '.pn_submitter', 'filesize' => $downloads_newdownload . '.pn_filesize', 'version' => $downloads_newdownload . '.pn_version', 'homepage' => $downloads_newdownload . '.pn_homepage'); $downloads_subcategories = $prefix . '_downloads_subcategories'; $pntable['downloads_subcategories'] = $downloads_subcategories; $pntable['downloads_subcategories_column'] = array ('sid' => $downloads_subcategories . '.pn_sid', 'cid' => $downloads_subcategories . '.pn_cid', 'title' => $downloads_subcategories . '.pn_title'); $downloads_votedata = $prefix . '_downloads_votedata'; $pntable['downloads_votedata'] = $downloads_votedata; $pntable['downloads_votedata_column'] = array ('ratingdbid' => $downloads_votedata . '.pn_id', 'ratinglid' => $downloads_votedata . '.pn_lid', 'ratinguser' => $downloads_votedata . '.pn_user', 'rating' => $downloads_votedata . '.pn_rating', 'ratinghostname' => $downloads_votedata . '.pn_hostname', 'ratingcomments' => $downloads_votedata . '.pn_comments', 'ratingtimestamp' => $downloads_votedata . '.pn_timestamp'); |