| Author |
Message |
vgamenews
MD user level 2
Joined: Feb 12, 2006
Posts: 21
Member
|
 Posted:
Feb 24, 2006 - 08:34 AM |
 
|
| Post subject: How did this work out?? |
Hey Shorty -
How did this work out - I want to use Maxdev becuase its got everything I need and looks sharp - but I have to have the subdomains - please let me know |
_________________
Thank you
Wade D Hinkle
Owner
Vgamenews.com |
|
|
|
eLGie
MD user level 5
Joined: Mar 15, 2004
Posts: 58
bannato
|
| Posted:
Feb 24, 2006 - 08:04 PM |
|
|
Did you get it figured yet Shorty? Should I flip the switch on for you? You might want to try /includes/pnSession.php and find some interesting code in that file that needs to be edited pertaining to your domain name. If you have trouble email linuxbag@linuxguru.ca but I highly doubt you will. Superb job. |
|
|
|
|
|
Shorty
MD user level 5
Joined: Jan 10, 2006
Posts: 149
bannato
|
| Posted:
Feb 24, 2006 - 11:01 PM |
|
|
my last post i added the tutorial on how to do this including the mdforum database share. i didn`t test the tutorial myself bocause i know what to do so it would be nice if someone else did and let me know if it`s ok and is easy to follow... |
|
|
|
|
|
eLGie
MD user level 5
Joined: Mar 15, 2004
Posts: 58
bannato
|
| Posted:
Feb 25, 2006 - 06:46 PM |
|
|
Session initialization failed - Been there Done that lots... Just recently too.
I'm serious I can replicate this error time and time again repetedly over and over for hours on end and find no apparent solution until I change the lines in the /includes/pnSession.php starting at line 79 to do with Cookie domain only needed for multi-server multisites. (Pause think of that. The original creators know what can be accomplished why else would it say multi-server multisites) - adapt as needed.
Typically my code at 82 would look like:
| Code:
|
ini_set('session.cookie_domain','workwanted.ca');
|
This vital yet so very unimportant piece of information is not listed in the tutorial and some users would never find the switch to fully turn on multi-sites functionality. Also your encoded should be changed to '0'.
I've never contemplated making a personal config like you are but it has made me think for a minute. How is it going? |
|
|
|
|
|
eLGie
MD user level 5
Joined: Mar 15, 2004
Posts: 58
bannato
|
| Posted:
Feb 25, 2006 - 06:54 PM |
|
|
Sorry about the double post I had no idea this thread had more than one page, lol. Good read. What are your site names? |
|
|
|
|
|
eLGie
MD user level 5
Joined: Mar 15, 2004
Posts: 58
bannato
|
| Posted:
Feb 25, 2006 - 07:59 PM |
|
|
Got those visited and just about signed up. Whenever I have a module or a block that doesn't behave with tables on the main site I go to the code for the module and remove any $prefix in the sql statements and hard code them to md_table etc...
Take for instance with five sites you don't want to have to end up reinstantiating some modules on all five sites it just makes no sense. Some more famous examples are of course the Mailbag module and pnTresMailer. Some blocks would be from a situation like a personals module only using the main md prefix and having the rest of the sites draw the information from there. Sure as shit when you flip the block you will be hemmoraging because the block will be calling from a prefix.
I've never worked if from the windows side but I would suggest you invest in your own private connection to the internet and run your own server appliance from home if you start investing a lot of time in this. I would use Linux as well both for the router and the server. There are far too many nasties out there that can whip your drives up thrashing in no time if you let them and I wouldn't trust a server host to handle this very important aspect of what traffic is actually on the server at any given time. Please see server logs on front page of of my linuxguru do ca site for what your server logs should look like.
I'll post a copy of a typical pnTables.php that I have very seldom changed but like you often thought about adding or modifying to. Oh yes, been there too. I found trying to alter things in that file best left alone or to the install.php people here, I'm sure they know who they are cause once you've been there every new release or disribution modifying and maintaing upgrade paths for database queries your not so very inclined to return to newtables.php.
I say strip the install and recode the admin panel or rather NS-MySql tools to provide prefix reiterations. This only requires the addition of one master table holding all your prefix names. From there a normal bare bones install would occurr. What this does is enable building of the multi-sites from one interface.
Say you have 300 sites. Your not going to every site to set up a new poll are you? Not a chance. Your going to either hand code the one huge database dump and run it against the database like mysql yourdatabase < nomistakes.sql or your going to take what usually amounts to the pninit.php out of each folder and stand up and code it into your new multisite admin interface. That way you can test immediatly for success. Shit I don't even put or drop damn dead and die statements in. I run the queries every time and know they either worked or didn't by doing a simple select all from the last field I was trying to update. Here I think I can show you one of my more tried and true pntables.php now. This is from my web root. Remember you do have options for individual pntables.php to exist in parameters folder by code as well as other files. My parameters folders only contain the config.php folder though 
pntables.php
[code:1:6e6755cad4]
<?php
// ----------------------------------------------------------------------
// eNvolution Content Management System
// Copyright (C) 2002 by the eNvolution Development Team.
// http://www.envolution.com/
// ----------------------------------------------------------------------
// Based on:
// Postnuke Content Management System - www.postnuke.com
// 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:
// ---------------------------------------------------------------------- ------
$prefix = $pnconfig['prefix'];
$pntable = array();
$autolinks = 'envo_autolinks';
$pntable['autolinks'] = $autolinks;
$pntable['autolinks_column'] = array ('lid' => $autolinks . '.pn_lid',
'keyword' => $autolinks . '.pn_keyword',
'title' => $autolinks . 'pn_title',
'url' => $autolinks . 'pn_url',
'comment' => $autolinks . 'pn_comment');
$autonews = $prefix . '_autonews';
$pntable['autonews'] = $autonews;
$pntable['autonews_column'] = array ('anid' => $autonews . '.pn_anid',
'catid' => $autonews . '.pn_catid',
'aid' => $autonews . '.pn_aid',
'title' => $autonews . '.pn_title',
'time' => $autonews . '.pn_time',
'hometext' => $autonews . '.pn_hometext',
'bodytext' => $autonews . '.pn_bodytext',
'topic' => $autonews . '.pn_topic',
'informant' => $autonews . '.pn_informant',
'notes' => $autonews . '.pn_notes',
'ihome' => $autonews . '.pn_ihome',
'alanguage' => $autonews . '.pn_language',
'language' => $autonews . '.pn_language',
'withcomm' => $autonews . '.pn_withcomm');
$banner = 'envo_banner';
$pntable['banner'] = $banner;
$pntable['banner_column'] = array ('bid' => $banner . '.pn_bid',
'cid' => $banner . '.pn_cid',
'type' => $banner . '.pn_type',
'imptotal' => $banner . '.pn_imptotal',
'impmade' => $banner . '.pn_impmade',
'clicks' => $banner . '.pn_clicks',
'imageurl' => $banner . '.pn_imageurl',
'clickurl' => $banner . '.pn_clickurl',
'date' => $banner . '.pn_date');
$bannerclient = 'envo_bannerclient';
$pntable['bannerclient'] = $bannerclient;
$pntable['bannerclient_column'] = array ('cid' => $bannerclient . '.pn_cid',
'name' => $bannerclient . '.pn_name',
'contact' => $bannerclient . '.pn_contact',
'email' => $bannerclient . '.pn_email',
'login' => $bannerclient . '.pn_login',
'passwd' => $bannerclient . '.pn_passwd',
'extrainfo' => $bannerclient . '.pn_extrainfo');
$bannerfinish = 'envo_bannerfinish';
$pntable['bannerfinish'] = $bannerfinish;
$pntable['bannerfinish_column'] = array ('bid' => $bannerfinish . '.pn_bid',
'cid' => $bannerfinish . '.pn_cid',
'impressions' => $bannerfinish . '.pn_impressions',
'clicks' => $bannerfinish . '.pn_clicks',
'datestart' => $bannerfinish . '.pn_datestart',
'dateend' => $bannerfinish . '.pn_dateend');
$blocks = 'envo_blocks';
$pntable['blocks'] = $blocks;
$pntable['blocks_column'] = array ('bid' => $blocks . '.pn_bid',
'bkey' => $blocks . '.pn_bkey',
'title' => $blocks . '.pn_title',
'content' => $blocks . '.pn_content',
'url' => $blocks . '.pn_url',
'mid' => $blocks . '.pn_mid',
'position' => $blocks . '.pn_position',
'weight' => $blocks . '.pn_weight',
'active' => $blocks . '.pn_active',
'refresh' => $blocks . '.pn_refresh',
'last_update' => $blocks . '.pn_last_update',
'blanguage' => $blocks . '.pn_language',
'language' => $blocks . '.pn_language');
$blocks_buttons = 'envo_blocks_buttons';
$pntable['blocks_buttons'] = $blocks_buttons;
$pntable['blocks_buttons_column'] = array ('id' => $blocks_buttons . '.pn_id',
'bid' => $blocks_buttons . '.pn_bid',
'title' => $blocks_buttons . '.pn_title',
'url' => $blocks_buttons . '.pn_url',
'images' => $blocks_buttons . '.pn_images');
$comments = $prefix . '_comments';
$pntable['comments'] = $comments;
$pntable['comments_column'] = array ('tid' => $comments . '.pn_tid',
'pid' => $comments . '.pn_pid',
'sid' => $comments . '.pn_sid',
'date' => $comments . '.pn_date',
'name' => $comments . '.pn_name',
'email' => $comments . '.pn_email',
'url' => $comments . '.pn_url',
'host_name' => $comments . '.pn_host_name',
'subject' => $comments . '.pn_subject',
'comment' => $comments . '.pn_comment',
'score' => $comments . '.pn_score',
'reason' => $comments . '.pn_reason');
$counter = $prefix . '_counter';
$pntable['counter'] = $counter;
$pntable['counter_column'] = array ('type' => $counter . '.pn_type',
'var' => $counter . '.pn_var',
'count' => $counter . '.pn_count');
$downloads_categories = 'envo_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 = 'envo_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',
'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 = 'envo_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 = 'envo_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',
'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 = 'envo_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',
'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 = 'envo_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 = 'envo_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');
$ephem = 'envo_ephem';
$pntable['ephem'] = $ephem;
$pntable['ephem_column'] = array ('eid' => $ephem . '.pn_eid',
'did' => $ephem . '.pn_did',
'mid' => $ephem . '.pn_mid',
'yid' => $ephem . '.pn_yid',
'content' => $ephem . '.pn_content',
'elanguage' => $ephem . '.pn_language',
'language' => $ephem . '.pn_language');
$faqanswer = 'envo_faqanswer';
$pntable['faqanswer'] = $faqanswer;
$pntable['faqanswer_column'] = array ('id' => $faqanswer . '.pn_id',
'id_cat' => $faqanswer . '.pn_id_cat',
'question' => $faqanswer . '.pn_question',
'answer' => $faqanswer . '.pn_answer',
'submittedby' => $faqanswer . '.pn_submittedby');
$faqcategories = 'envo_faqcategories';
$pntable['faqcategories'] = $faqcategories;
$pntable['faqcategories_column'] = array ('id_cat' => $faqcategories . '.pn_id_cat',
'categories' => $faqcategories . '.pn_categories',
'flanguage' => $faqcategories . '.pn_language',
'language' => $faqcategories . '.pn_language',
'parent_id' => $faqcategories . '.pn_parent_id');
$group_membership = 'envo_group_membership';
$pntable['group_membership'] = $group_membership;
$pntable['group_membership_column'] = array ('gid' => $group_membership . '.pn_gid',
'uid' => $group_membership . '.pn_uid');
$group_perms = 'envo_group_perms';
$pntable['group_perms'] = $group_perms;
$pntable['group_perms_column'] = array ('pid' => $group_perms . '.pn_pid',
'gid' => $group_perms . '.pn_gid',
'sequence' => $group_perms . '.pn_sequence',
'realm' => $group_perms . '.pn_realm',
'component' => $group_perms . '.pn_component',
'instance' => $group_perms . '.pn_instance',
'level' => $group_perms . '.pn_level',
'bond' => $group_perms . '.pn_bond');
$groups = 'envo_groups';
$pntable['groups'] = $groups;
$pntable['groups_column'] = array ('gid' => $groups . '.pn_gid',
'name' => $groups . '.pn_name');
$headlines = $prefix . '_headlines';
$pntable['headlines'] = $headlines;
$pntable['headlines_column'] = array ('id' => $headlines . '.pn_id',
'sitename' => $headlines . '.pn_sitename',
'rssuser' => $headlines . '.pn_rssuser',
'rsspasswd' => $headlines . '.pn_rsspasswd',
'use_proxy' => $headlines . '.pn_use_proxy',
'rssurl' => $headlines . '.pn_rssurl',
'maxrows' => $headlines . '.pn_maxrows',
'siteurl' => $headlines . '.pn_siteurl',
'options' => $headlines . '.pn_options');
$hooks = 'envo_hooks';
$pntable['hooks'] = $hooks;
$pntable['hooks_column'] = array ('id' => $hooks . '.pn_id',
'object' => $hooks . '.pn_object',
'action' => $hooks . '.pn_action',
'smodule' => $hooks . '.pn_smodule',
'stype' => $hooks . '.pn_stype',
'tarea' => $hooks . '.pn_tarea',
'tmodule' => $hooks . '.pn_tmodule',
'ttype' => $hooks . '.pn_ttype',
'tfunc' => $hooks . '.pn_tfunc');
$languages_constant = $prefix.'_languages_constant';
$pntable['languages_constant'] = $languages_constant;
$pntable['languages_constant_column'] = array ('constant' => $languages_constant . '.pn_constant',
'file' => $languages_constant . '.pn_file');
$languages_file = $prefix.'_languages_file';
$pntable['languages_file'] = $languages_file;
$pntable['languages_file_column'] = array ('target' => $languages_file . '.pn_target',
'source' => $languages_file . '.pn_source');
$languages_translation = 'envo_languages_translation';
$pntable['languages_translation'] = $languages_translation;
$pntable['languages_translation_column'] = array ('language' => $languages_translation . '.pn_language',
'constant' => $languages_translation . '.pn_constant',
'translation' => $languages_translation . '.pn_translation',
'level' => $languages_translation . '.pn_level');
$links_categories = 'envo_links_categories';
$pntable['links_categories'] = $links_categories;
$pntable['links_categories_column'] = array ('cat_id' => $links_categories . '.pn_cat_id',
'parent_id' => $links_categories . '.pn_parent_id',
'title' => $links_categories . '.pn_title',
'cdescription' => $links_categories . '.pn_description');
$links_editorials = 'envo_links_editorials';
$pntable['links_editorials'] = $links_editorials;
$pntable['links_editorials_column'] = array ('linkid' => $links_editorials . '.pn_linkid',
'adminid' => $links_editorials . '.pn_adminid',
'editorialtimestamp' => $links_editorials . '.pn_timestamp',
'editorialtext' => $links_editorials . '.pn_text',
'editorialtitle' => $links_editorials . '.pn_title');
$links_links = 'envo_links_links';
$pntable['links_links'] = $links_links;
$pntable['links_links_column'] = array ('lid' => $links_links . '.pn_lid',
'cat_id' => $links_links . '.pn_cat_id',
'title' => $links_links . '.pn_title',
'url' => $links_links . '.pn_url',
'image' => $links_links . '.pn_image',
'description' => $links_links . '.pn_description',
'date' => $links_links . '.pn_date',
'name' => $links_links . '.pn_name',
'email' => $links_links . '.pn_email',
'hits' => $links_links . '.pn_hits',
'submitter' => $links_links . '.pn_submitter',
'linkratingsummary' => $links_links . '.pn_ratingsummary',
'totalvotes' => $links_links . '.pn_totalvotes',
'totalcomments' => $links_links . '.pn_totalcomments');
$links_modrequest = 'envo_links_modrequest';
$pntable['links_modrequest'] = $links_modrequest;
$pntable['links_modrequest_column'] = array ('requestid' => $links_modrequest . '.pn_requestid',
'lid' => $links_modrequest . '.pn_lid',
'cat_id' => $links_modrequest . '.pn_cat_id',
'sid' => $links_modrequest . '.pn_sid',
'title' => $links_modrequest . '.pn_title',
'url' => $links_modrequest . '.pn_url',
'image' => $links_modrequest . '.pn_image',
'description' => $links_modrequest . '.pn_description',
'modifysubmitter' => $links_modrequest . '.pn_modifysubmitter',
'brokenlink' => $links_modrequest . '.pn_brokenlink');
$links_newlink = 'envo_links_newlink';
$pntable['links_newlink'] = $links_newlink;
$pntable['links_newlink_column'] = array ('lid' => $links_newlink . '.pn_lid',
'cat_id' => $links_newlink . '.pn_cat_id',
'title' => $links_newlink . '.pn_title',
'url' => $links_newlink . '.pn_url',
'image' => $links_newlink . '.pn_image',
'description' => $links_newlink . '.pn_description',
'name' => $links_newlink . '.pn_name',
'email' => $links_newlink . '.pn_email',
'submitter' => $links_newlink . '.pn_submitter');
$links_votedata = 'envo_links_votedata';
$pntable['links_votedata'] = $links_votedata;
$pntable['links_votedata_column'] = array ('ratingdbid' => $links_votedata . '.pn_id',
'ratinglid' => $links_votedata . '.pn_lid',
'ratinguser' => $links_votedata . '.pn_user',
'rating' => $links_votedata . '.pn_rating',
'ratinghostname' => $links_votedata . '.pn_hostname',
'ratingcomments' => $links_votedata . '.pn_comments',
'ratingtimestamp' => $links_votedata . '.pn_timestamp');
$message = 'envo_message';
$pntable['message'] = $message;
$pntable['message_column'] = array ('mid' => $message . '.pn_mid',
'title' => $message . '.pn_title',
'content' => $message . '.pn_content',
'date' => $message . '.pn_date',
'expire' => $message . '.pn_expire',
'active' => $message . '.pn_active',
'view' => $message . '.pn_view',
'mlanguage' => $message . '.pn_language',
'language' => $message . '.pn_language');
$module_vars = $prefix . '_module_vars';
$pntable['module_vars'] = $module_vars;
$pntable['module_vars_column'] = array ('id' => $module_vars . '.pn_id',
'modname' => $module_vars . '.pn_modname',
'name' => $module_vars . '.pn_name',
'value' => $module_vars . '.pn_value');
$modules = $prefix . '_modules';
$pntable['modules'] = $modules;
$pntable['modules_column'] = array ('id' => $modules . '.pn_id',
'name' => $modules . '.pn_name',
'type' => $modules . '.pn_type',
'displayname' => $modules . '.pn_displayname',
'description' => $modules . '.pn_description',
'regid' => $modules . '.pn_regid',
'directory' => $modules . '.pn_directory',
'version' => $modules . '.pn_version',
'admin_capable' => $modules . '.pn_admin_capable',
'user_capable' => $modules . '.pn_user_capable',
'state' => $modules . '.pn_state');
$nomoreblocks = 'envo_nomoreblocks';
$pntable['nomoreblocks'] = $nomoreblocks;
$pntable['nomoreblocks_column'] = array ('modulo' => $nomoreblocks . '.pn_modulo',
'blocco' => $nomoreblocks . '.pn_blocco',
'identi' => $nomoreblocks . '.pn_identi',
'posizione' => $nomoreblocks . '.pn_pos',
'peso' => $nomoreblocks . '.pn_peso',
'blocktemplate' => $nomoreblocks . '.pn_template');
$poll_check = 'envo_poll_check';
$pntable['poll_check'] = $poll_check;
$pntable['poll_check_column'] = array ('ip' => $poll_check . '.pn_ip',
'time' => $poll_check . '.pn_time');
$poll_data = 'envo_poll_data';
$pntable['poll_data'] = $poll_data;
$pntable['poll_data_column'] = array ('pollid' => $poll_data . '.pn_pollid',
'optiontext' => $poll_data . '.pn_optiontext',
'optioncount' => $poll_data . '.pn_optioncount',
'voteid' => $poll_data . '.pn_voteid',
'optioncolor' => $poll_data . '.pn_optioncolor');
$poll_desc = 'envo_poll_desc';
$pntable['poll_desc'] = $poll_desc;
$pntable['poll_desc'] = $poll_desc;
$pntable['poll_desc_column'] = array ('pollid' => $poll_desc . '.pn_pollid',
'polltitle' => $poll_desc . '.pn_title',
'timestamp' => $poll_desc . '.pn_timestamp',
'voters' => $poll_desc . '.pn_voters',
'planguage' => $poll_desc . '.pn_language',
'language' => $poll_desc . '.pn_language',
'votesystem' => $poll_desc . '.pn_votesystem',
'postfull' => $poll_desc . '.pn_postfull',
'votetracking' => $poll_desc .'.pn_votetracking');
$poll_voters = 'envo_poll_voters';
$pntable['poll_voters'] = $poll_voters;
$pntable['poll_voters_column'] = array ('pollid' => $poll_voters . '.pn_pollid ',
'voteid' => $poll_voters . '.pn_voteid ',
'uid' => $poll_voters . '.pn_uid',
'timestamp' => $poll_voters . '.pn_timestamp');
$pollcomments = 'envo_pollcomments';
$pntable['pollcomments'] = $pollcomments;
$pntable['pollcomments_column'] = array ('tid' => $pollcomments . '.pn_tid',
'pid' => $pollcomments . '.pn_pid',
'pollid' => $pollcomments . '.pn_pollid',
'date' => $pollcomments . '.pn_date',
'name' => $pollcomments . '.pn_name',
'email' => $pollcomments . '.pn_email',
'url' => $pollcomments . '.pn_url',
'host_name' => $pollcomments . '.pn_host_name',
'subject' => $pollcomments . '.pn_subject',
'comment' => $pollcomments . '.pn_comment',
'score' => $pollcomments . '.pn_score',
'reason' => $pollcomments . '.pn_reason');
$priv_msgs = 'envo_priv_msgs';
$pntable['priv_msgs'] = $priv_msgs;
$pntable['priv_msgs_column'] = array ('msg_id' => $priv_msgs . '.pn_msg_id',
'msg_image' => $priv_msgs . '.pn_msg_image',
'subject' => $priv_msgs . '.pn_subject',
'from_userid' => $priv_msgs . '.pn_from_userid',
'to_userid' => $priv_msgs . '.pn_to_userid',
'msg_time' => $priv_msgs . '.pn_msg_time',
'msg_text' => $priv_msgs . '.pn_msg_text',
'read_msg' => $priv_msgs . '.pn_read_msg');
$priv_msgs_out = 'envo_priv_msgs_outbox';
$pntable['priv_msgs_outbox'] = $priv_msgs_out;
$pntable['priv_msgs_outbox_column'] = array ('msg_id' => $priv_msgs_out . '.pn_msg_id',
'msg_image' => $priv_msgs_out . '.pn_msg_image',
'subject' => $priv_msgs_out . '.pn_subject',
'from_userid' => $priv_msgs_out . '.pn_from_userid',
'to_userid' => $priv_msgs_out . '.pn_to_userid',
'msg_time' => $priv_msgs_out . '.pn_msg_time',
'msg_text' => $priv_msgs_out . '.pn_msg_text',
'read_msg' => $priv_msgs_out . '.pn_read_msg');
$queue = 'envo_queue';
$pntable['queue'] = $queue;
$pntable['queue_column'] = array ('qid' => $queue . '.pn_qid',
'uid' => $queue . '.pn_uid',
'arcd' => $queue . '.pn_arcd',
'uname' => $queue . '.pn_uname',
'subject' => $queue . '.pn_subject',
'story' => $queue . '.pn_story',
'timestamp' => $queue . '.pn_timestamp',
'topic' => $queue . '.pn_topic',
'alanguage' => $queue . '.pn_language',
'language' => $queue . '.pn_language',
'bodytext' => $queue . '.pn_bodytext');
$realms = 'envo_realms';
$pntable['realms'] = $realms;
$pntable['realms_column'] = array ('rid' => $realms . '.pn_rid',
'name' => $realms . '.pn_name');
$referer = 'envo_referer';
$pntable['referer'] = $referer;
$pntable['referer_column'] = array ('rid' => $referer . '.pn_rid',
'url' => $referer . '.pn_url',
'frequency' => $referer . '.pn_frequency');
$related = 'envo_related';
$pntable['related'] = $related;
$pntable['related_column'] = array ('rid' => $related . '.pn_rid',
'tid' => $related . '.pn_tid',
'name' => $related . '.pn_name',
'url' => $related . '.pn_url');
$reviews = 'envo_reviews';
$pntable['reviews'] = $reviews;
$pntable['reviews_column'] = array ('id' => $reviews . '.pn_id',
'date' => $reviews . '.pn_date',
'title' => $reviews . '.pn_title',
'text' => $reviews . '.pn_text',
'reviewer' => $reviews . '.pn_reviewer',
'email' => $reviews . '.pn_email',
'score' => $reviews . '.pn_score',
'cover' => $reviews . '.pn_cover',
'url' => $reviews . '.pn_url',
'url_title' => $reviews . '.pn_url_title',
'hits' => $reviews . '.pn_hits',
'rlanguage' => $reviews . '.pn_language',
'language' => $reviews . '.pn_language');
$reviews_add = 'envo_reviews_add';
$pntable['reviews_add'] = $reviews_add;
$pntable['reviews_add_column'] = array ('id' => $reviews_add . '.pn_id',
'date' => $reviews_add . '.pn_date',
'title' => $reviews_add . '.pn_title',
'text' => $reviews_add . '.pn_text',
'reviewer' => $reviews_add . '.pn_reviewer',
'email' => $reviews_add . '.pn_email',
'score' => $reviews_add . '.pn_score',
'url' => $reviews_add . '.pn_url',
'url_title' => $reviews_add . '.pn_url_title',
'rlanguage' => $reviews_add . '.pn_language',
'language' => $reviews_add . '.pn_language');
$reviews_comments = 'envo_reviews_comments';
$pntable['reviews_comments'] = $reviews_comments;
$pntable['reviews_comments_column'] = array ('cid' => $reviews_comments . '.pn_cid',
'rid' => $reviews_comments . '.pn_rid',
'userid' => $reviews_comments . '.pn_userid',
'date' => $reviews_comments . '.pn_date',
'comments' => $reviews_comments . '.pn_comments',
'score' => $reviews_comments . '.pn_score');
$reviews_main = 'envo_reviews_main';
$pntable['reviews_main'] = $reviews_main;
$pntable['reviews_main_column'] = array ('title' => $reviews_main . '.pn_title',
'description' => $reviews_main . '.pn_description');
$seccont = 'envo_seccont';
$pntable['seccont'] = $seccont;
$pntable['seccont_column'] = array ('artid' => $seccont . '.pn_artid',
'secid' => $seccont . '.pn_secid',
'title' => $seccont . '.pn_title',
'content' => $seccont . '.pn_content',
'counter' => $seccont . '.pn_counter',
'slanguage' => $seccont . '.pn_language',
'language' => $seccont . '.pn_language');
//ak_comment added new column language
$sections = 'envo_sections';
$pntable['sections'] = $sections;
$pntable['sections_column'] = array ('secid' => $sections . '.pn_secid',
'secname' => $sections . '.pn_secname',
'language' => $sections . '.pn_language',
'image' => $sections . '.pn_image');
$session_info = 'envo_session_info';
$pntable['session_info'] = $session_info;
$pntable['session_info_column'] = array ('sessid' => $session_info . '.pn_sessid',
'ipaddr' => $session_info . '.pn_ipaddr',
'firstused' => $session_info . '.pn_firstused',
'lastused' => $session_info . '.pn_lastused',
'uid' => $session_info . '.pn_uid',
'vars' => $session_info . '.pn_vars');
$stats_date = $prefix . '_stats_date';
$pntable['stats_date'] = $stats_date;
$pntable['stats_date_column'] = array ('date' => $stats_date . '.pn_date',
'hits' => $stats_date . '.pn_hits');
$stats_hour = $prefix . '_stats_hour';
$pntable['stats_hour'] = $stats_hour;
$pntable['stats_hour_column'] = array ('hour' => $stats_hour . '.pn_hour',
'hits' => $stats_hour . '.pn_hits');
$stats_month = $prefix . '_stats_month';
$pntable['stats_month'] = $stats_month;
$pntable['stats_month_column'] = array ('month' => $stats_month . '.pn_month',
'hits' => $stats_month . '.pn_hits');
$stats_week = $prefix . '_stats_week';
$pntable['stats_week'] = $stats_week;
$pntable['stats_week_column'] = array ('weekday' => $stats_week . '.pn_weekday',
'hits' => $stats_week . '.pn_hits');
$stories = $prefix . '_stories';
//$stories = 'envo_stories';
$pntable['stories'] = $stories;
$pntable['stories_column'] = array ('sid' => $stories . '.pn_sid',
'cid' => $stories . '.pn_catid',
'catid' => $stories . '.pn_catid', // for back compat
'aid' => $stories . '.pn_aid',
'title' => $stories . '.pn_title',
'time' => $stories . '.pn_time',
'hometext' => $stories . '.pn_hometext',
'bodytext' => $stories . '.pn_bodytext',
'comments' => $stories . '.pn_comments',
'counter' => $stories . '.pn_counter',
'topic' => $stories . '.pn_topic',
'informant' => $stories . '.pn_informant',
'notes' => $stories . '.pn_notes',
'ihome' => $stories . '.pn_ihome',
'themeoverride' => $stories . '.pn_themeoverride',
'alanguage' => $stories . '.pn_language',
'language' => $stories . '.pn_language',
'withcomm' => $stories . '.pn_withcomm',
'format_type' => $stories . '.pn_format_type',
'skins' => $stories . '.pn_skins');
$stories_cat = 'envo_stories_cat';
$pntable['stories_cat'] = $stories_cat;
$pntable['stories_cat_column'] = array ('catid' => $stories_cat . '.pn_catid',
'title' => $stories_cat . '.pn_title',
'counter' => $stories_cat . '.pn_counter',
'themeoverride' => $stories_cat . '.pn_themeoverride');
// General config table and columns
// mh7: Added 'skin_id' to permit Skin specific configs
$pntable['theme_config'] = 'envo_theme_config';
$pntable['theme_config_column'] = array(
'name' => "$pntable[theme_config].name",
'skin_id' => "$pntable[theme_config].skin_id",
'description' => "$pntable[theme_config].description",
'setting' => "$pntable[theme_config].setting",
'data' => "$pntable[theme_config].data");
// Template to zone table and columns
$pntable['theme_layout'] = 'envo_theme_layout';
$pntable['theme_layout_column'] = array(
'skin_id' => "$pntable[theme_layout].skin_id",
'zone_label' => "$pntable[theme_layout].zone_label",
'tpl_file' => "$pntable[theme_layout].tpl_file");
// Skins and color table and columns
$pntable['theme_skins'] = 'envo_theme_skins';
$pntable['theme_skins_column'] = array(
'skin_id' => "$pntable[theme_skins].skin_id",
'name' => "$pntable[theme_skins].name",
'is_active' => "$pntable[theme_skins].is_active",
'is_multicolor' => "$pntable[theme_skins].is_multicolor",
'bgcolor1' => "$pntable[theme_skins].bgcolor1",
'bgcolor2' => "$pntable[theme_skins].bgcolor2",
'bgcolor3' => "$pntable[theme_skins].bgcolor3",
'bgcolor4' => "$pntable[theme_skins].bgcolor4",
'bgcolor5' => "$pntable[theme_skins].bgcolor5",
'bgcolor6' => "$pntable[theme_skins].bgcolor6",
'sepcolor' => "$pntable[theme_skins].sepcolor",
'textcolor1' => "$pntable[theme_skins].textcolor1",
'textcolor2' => "$pntable[theme_skins].textcolor2");
// Zones table and columns
// mh7: Added 'skin_id' to permit Skin specific layouts
$pntable['theme_zones'] = 'envo_theme_zones';
$pntable['theme_zones_column'] = array(
'zone_id' => "$pntable[theme_zones].zone_id",
'skin_id' => "$pntable[theme_zones].skin_id",
'name' => "$pntable[theme_zones].name",
'label' => "$pntable[theme_zones].label",
'type' => "$pntable[theme_zones].type",
'is_active' => "$pntable[theme_zones].is_active");
//ak_comment added new column language
$topics = 'envo_topics';
$pntable['topics'] = $topics;
$pntable['topics_column'] = array ('tid' => $topics . '.pn_topicid',
'topicid' => $topics . '.pn_topicid', // for back compat
'topicname' => $topics . '.pn_topicname',
'language' => $topics . '.pn_language',
'topicimage' => $topics . '.pn_topicimage',
'topictext' => $topics . '.pn_topictext',
'counter' => $topics . '.pn_counter');
$user_data = 'envo_user_data';
$pntable['user_data'] = $user_data;
$pntable['user_data_column'] = array ('uda_id' => $user_data . '.pn_uda_id',
'uda_propid' => $user_data . '.pn_uda_propid',
'uda_uid' => $user_data . '.pn_uda_uid',
'uda_value' => $user_data . '.pn_uda_value');
$user_perms = 'envo_user_perms';
$pntable['user_perms'] = $user_perms;
$pntable['user_perms_column'] = array ('pid' => $user_perms . '.pn_pid',
'uid' => $user_perms . '.pn_uid',
'sequence' => $user_perms . '.pn_sequence',
'realm' => $user_perms . '.pn_realm',
'component' => $user_perms . '.pn_component',
'instance' => $user_perms . '.pn_instance',
'level' => $user_perms . '.pn_level',
'bond' => $user_perms . '.pn_bond');
$user_property = 'envo_user_property';
$pntable['user_property'] = $user_property;
$pntable['user_property_column'] = array ('prop_id' => $user_property . '.pn_prop_id',
'prop_label' => $user_property . '.pn_prop_label',
'prop_dtype' => $user_property . '.pn_prop_dtype',
'prop_length' => $user_property . '.pn_prop_length',
'prop_weight' => $user_property . '.pn_prop_weight',
'prop_validation' => $user_property . '.pn_prop_validation'
);
$userblocks = $prefix . '_userblocks';
$pntable['userblocks'] = $userblocks;
$pntable['userblocks_column'] = array ('uid' => $userblocks . '.pn_uid',
'bid' => $userblocks . '.pn_bid',
'active' => $userblocks . '.pn_active',
'lastupdate' => $userblocks . '.pn_lastupdate');
$users = 'envo_users';
$pntable['users'] = $users;
$pntable['users_column'] = array ('uid' => $users . '.pn_uid',
'name' => $users . '.pn_name',
'uname' => $users . '.pn_uname',
'email' => $users . '.pn_email',
'femail' => $users . '.pn_femail',
'url' => $users . '.pn_url',
'user_avatar' => $users . '.pn_user_avatar',
'user_regdate' => $users . '.pn_user_regdate',
'user_icq' => $users . '.pn_user_icq',
'user_occ' => $users . '.pn_user_occ',
'user_from' => $users . '.pn_user_from',
'user_intrest' => $users . '.pn_user_intrest',
'user_sig' => $users . '.pn_user_sig',
'user_viewemail' => $users . '.pn_user_viewemail',
'user_theme' => $users . '.pn_user_theme',
'user_aim' => $users . '.pn_user_aim',
'user_yim' => $users . '.pn_user_yim',
'user_msnm' => $users . '.pn_user_msnm',
'pass' => $users . '.pn_pass',
'storynum' => $users . '.pn_storynum',
'umode' => $users . '.pn_umode',
'uorder' => $users . '.pn_uorder',
'thold' => $users . '.pn_thold',
'noscore' => $users . '.pn_noscore',
'bio' => $users . '.pn_bio',
'ublockon' => $users . '.pn_ublockon',
'ublock' => $users . '.pn_ublock',
'theme' => $users . '.pn_theme',
'commentmax' => $users . '.pn_commentmax',
'counter' => $users . '.pn_counter',
'timezone_offset' => $users . '.pn_timezone_offset');
$users_delrequest = 'envo_users_delrequest';
$pntable['users_delrequest'] = $users_delrequest;
$pntable['users_delrequest_column'] = array ('uid' => $users_delrequest . '.pn_uid',
'name' => $users_delrequest . '.pn_name',
'uname' => $users_delrequest . '.pn_uname',
'email' => $users_delrequest . '.pn_email',
'pass' => $users_delrequest . '.pn_pass');
$rtemulti = 'envo_rtemulti';
$pntable['rtemulti'] = $rtemulti;
$pntable['rtemulti_column'] = array('rid' => $rtemulti . '.pn_rid',
'editortype'=> $rtemulti . '.pn_editortype',
'modname' => $rtemulti . '.pn_modname',
'varname' => $rtemulti . '.pn_varname',
'keystring' => $rtemulti . '.pn_keystring',
'newstring' => $rtemulti . '.pn_newstring',
'comment' => $rtemulti . '.pn_comment');
$departments = 'envo_admin_lite_group';
$pntable['group_table'] = $departments;
$pntable['group'] = array('id' => $departments . '.groupID',
'name' => $departments . '.groupName',
'lock' => $departments . '.groupLock',
'all' => $departments . '.groupShowAllModules',
'default' => $departments . '.groupDefault',
'order' => $departments . '.sortOrder');
$departments_members = 'envo_admin_lite_group_members';
$pntable['member_table'] = $departments_members;
$pntable['members'] = array('gid' => $departments_members . '.groupID',
'order' => $departments_members . '.sortOrder',
'mid' => $departments_members . '.moduleID');
//TiMax envo 1.2.5
$stories_ratings = $prefix . '_stories_ratings';
$pntable['stories_ratings'] = $stories_ratings;
$pntable['stories_ratings_column'] = array ('sid' => $stories_ratings . '.pn_sid',
'rating' => $stories_ratings . '.pn_rating');
//eLGie SPCat
$spchat_access = 'envo_spchat_access';
$pntable['spchat_access'] = $spchat_access;
$pntable['spchat_access_column'] =
array('aid' => $spchat_access . '.aid',
'gid' => $spchat_access . '.gid',
'profile' => $spchat_access . '.profile',
'can_log' => $spchat_access . '.can_log',
'can_up' => $spchat_access . '.can_up',
'can_kick' => $spchat_access . '.can_kick',
'can_bann' => $spchat_access . '.can_bann',
'can_addsmile' => $spchat_access . '.can_addsmile',
'can_addsnd' => $spchat_access . '.can_addsnd',
'can_addroom' => $spchat_access . '.can_addroom');
$spchat_colors = 'envo_spchat_colors';
$pntable['spchat_colors'] = $spchat_colors;
$pntable['spchat_colors_column'] =
array('bgcolor1' => $spchat_colors . '.bgcolor1',
'bgcolor2' => $spchat_colors . '.bgcolor2',
'bgcolor3' => $spchat_colors . '.bgcolor3',
'bgcolor4' => $spchat_colors . '.bgcolor4',
'bgcolor5' => $spchat_colors . '.bgcolor5',
'txtcolor1' => $spchat_colors . '.txtcolor1',
'txtcolor2' => $spchat_colors . '.txtcolor2');
// nukeurl: obsoleted since version 0.6.913, but we still need it here
// to be backwards compatible.
// Todo: For setup area we need a smarter initialisation of db config vars.
// We could delete the obsoleted table fields then.
$spchat_config = 'envo_spchat_config';
$pntable['spchat_config'] = $spchat_config;
$pntable['spchat_config_column'] =
array('sid' => $spchat_config . '.sid',
'allowcreate' => $spchat_config . '.allowcreate',
'onlyreg' => $spchat_config . '.onlyreg',
'msg_refresh' => $spchat_config . '.msg_refresh',
'usertime' => $spchat_config . '.usertime',
'showsmiles' => $spchat_config . '.showsmiles',
'smilesdir' => $spchat_config . '.smilesdir',
'usesounds' => $spchat_config . '.usesounds',
'showsounds' => $spchat_config . '.showsounds',
'soundsdir' => $spchat_config . '.soundsdir',
'showusers' => $spchat_config . '.showusers',
'keeponline' => $spchat_config . '.keeponline',
'tz' => $spchat_config . '.tz',
'tf' => $spchat_config . '.tf',
'tsformat' => $spchat_config . '.tsformat',
'nukeurl' => $spchat_config . '.nukeurl',
'title' => $spchat_config . '.title',
'displaytitletable' => $spchat_config . '.displaytitletable',
'titletext' => $spchat_config . '.titletext',
'makelog' => $spchat_config . '.makelog',
'nr_lastmsgs2keep' => $spchat_config . '.nr_lastmsgs2keep',
'admin_entriesperpage' => $spchat_config . '.admin_entriesperpage',
'chatwindow_width' => $spchat_config . '.chatwindow_width',
'chatwindow_height' => $spchat_config . '.chatwindow_height',
'chatwindow_input_height' => $spchat_config . '.chatwindow_input_height',
'chatwindow_users_width' => $spchat_config . '.chatwindow_users_width',
'chatwindow_receive_height' => $spchat_config . '.chatwindow_receive_height',
'chatwindow_ticker_width' => $spchat_config . '.chatwindow_ticker_width',
'showticker' => $spchat_config . '.showticker',
'ticker_news' => $spchat_config . '.ticker_news',
'pversion' => $spchat_config . '.pversion',
|
|
|
|
|
|
eLGie
MD user level 5
Joined: Mar 15, 2004
Posts: 58
bannato
|
| Posted:
Feb 25, 2006 - 08:10 PM |
|
|
Here is how I easily maintain 1776 websites using the armageddon core module I've developed enough for my expert use.
| Code:
|
<?php
// ----------------------------------------------------------------------
// eNvolution Content Management System
// Copyright (C) 2002 by the eNvolution Development Team.
// http://www.envolution.com/
// ----------------------------------------------------------------------
// Based on:
// Postnuke Content Management System - www.postnuke.com
// 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
//
//******************************************************************** ****
//* Envolution: Web Portal System *
//* =========================== *
//* *
//* MySQL_Tools *
//* *
//* Copyright (c) 2002 by: *
//* *
//* Michaelius (michaelius@nukeland.de) *
//* http://www.nukeland.de *
//* in memory of my friend Michaelius *
//* hacked by TiMax timax@envolution.com - *
modules_get_language();
modules_get_manual();
function mysql_tools_admin_main() {
if (!(pnSecAuthAction(0, 'MySQL_Tools::', '::', ACCESS_ADMIN)))
{
include 'header.php';
OpenTable();
echo _BADAUTHKEY;
CloseTable();
include 'footer.php';
} else {
include 'header.php';
OpenTable();
GraphicAdmin();
echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">
<tr align=\"center\"><form action=\"admin.php?module=NS-MySQL_Tools&type=admin&op=updatedb\" method=\"POST\"><input type=submit value=\""._UPDATEDBVALUE."\"><i> "._UPDATEDBTEXT."</i></form></tr>
</table>";
CloseTable();
include 'footer.php';
}
}
function mysql_tools_admin_updatedb() {
modules_get_language();
if (!(pnSecAuthAction(0, 'MySQL_Tools::', '::', ACCESS_ADMIN)))
{
include 'header.php';
OpenTable();
echo _BADAUTHKEY;
CloseTable();
include 'footer.php';
} else {
list($dbconn) = pnDBGetConn();
$dbhost = pnConfigGetVar('dbhost');
$dbuname = pnConfigGetVar('dbuname');
$dbpass = pnConfigGetVar('dbpass');
$dbname = pnConfigGetVar('dbname');
include 'header.php';
OpenTable();
echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">
<tr>
<td align=\"center\">"._UPDATEMAIN."<form action=\"admin.php?module=NS-MySQL_Tools&type=admin&op=updatedb\" method=\"POST\"><input type=submit value=\""._UPDATEDB."\"><i> "._UPDATEDBTEXT1."</i></form></td>
</tr></table>";
CloseTable();
echo "<br>";
OpenTable();
echo "<center><b>"._UPDATEDB1." "."$dbname"."</b><br><br>";
echo "<table border=0 cellspacing=\"3\" cellpadding=\"2\"><tr><td align=center bgcolor=\"#FFFFFF\"><b>"._SQLTLS_LANG2."</b></td><td align=center bgcolor=\"#F3F3F3\"><b>"._SQLTLS_LANG3."</b></td><td align=center bgcolor=\"#FFFFFF\"><b>"._SQLTLS_LANG4."</b></td><td align=center bgcolor=\"#F3F3F3\"><b>"._SQLTLS_LANG5."</b></td></tr>";
$pntable = pnDBGetTables();
$query = "SELECT site from nuke_vista";
$results = $dbconn->Execute($query);
if ($dbconn->ErrorNo() <> 0) {
echo "DB Error: ".$dbconn->ErrorNo().": ".$dbconn->ErrorMsg()."<br>";
exit();
}
if ($results->EOF) return;
while (list($site) = $results->fields) {
//$tablez[ads] = $site . "_zc_ads";
$tablez[category] = $site . "_zc_category";
// $tablez[photo] = $site . "_zc_photo";
// $result = mysql_query( "DELETE FROM $tablez[ads]");
// $result = mysql_query( "DELETE FROM $tablez[category]");
// $result = mysql_query( "DELETE FROM $tablez[photo]");
//$tablez[photo] = $site . "_zc_photo";
//$result = mysql_query( "DROP TABLE $tablez[ads]");
// echo $tablez;
/*
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (1,0,'Westphalian',113789610)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (2,0,'Welsh',1137890644)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (3,0,'Warmblood',1137890653)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (4,0,'Takehner',1137890660)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (5,0,'Thoroughbred',113790665)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (6,0,'Tennessee Walker',1137890671)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (7,0,'SwedishWarmblood',1137890678)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (8,0,'Standardbred',1137890684)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (9,0,'Spotted Saddle',1137890695)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (10,0,'Shire',1137890703)");
$result = mysql_query("INSERT ITO $tablez[ads] VALUES (11,0,'Shetland Pony',1137890712)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (12,0,'Shagya',1137890717)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (13,0,'Selle Francais',1137890720)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (14,0,'Saddlebred',1137890725)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (15,0,'Rocky Mountain Horse',1137890734)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (16,0,'Racking Horse',1137890739)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (17,0,'Quarter Horse',1137890744)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (18,0,'POA',1137890748)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (1,0,'Pinto',1137890752)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (20,0,'Ponies',1137890756)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (21,0,'Peruvian Paso',1137890763)");
$result = mysql_query("INSERT INTO $tablez[ads] VAUES (22,0,'Percheron',1137890766)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (23,0,'Paso Fino',1137890770)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (24,0,'Paint',1137890775)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (25,0,'Oldenbrg',1137890781)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (26,0,'National Show Horse',1137890786)");
$result = mysql_query("INSERT INTO $talez[ads] VALUES (27,0,'Mustang',1137890790)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (28,0,'Mule',1137890793)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (29,0,'Morgan',113790796)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (30,0,'Morab',113780800)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (31,0,'Miniature Donkey',1137890805)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (32,0,'Miniature Hose',1137890808)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (33,0,'Lusitano',113890811)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (34,0,'Lipizzan',1137890820)");
$result = mysql_query("INSERT INTO $tablez[ads] VALUES (35,0,'Kentucky Mountain',1137890825)");
$result = mysql_query("INSRT INTO $tablz[ads] VALUES (36,0,'Ir | | | |
Forum FAQ
Search
Usergroups
Preferences
Options forum
Watched Topics
Latest forum posts
Log in to check your private messages
Log in
