# phpMyAdmin MySQL-Dump # version 2.5.1 # http://www.phpmyadmin.net/ (download page) # # Host: localhost # Generation Time: Jan 03, 2004 at 02:43 PM # Server version: 3.23.58 # PHP Version: 4.3.3 # Database : `ags_main` # -------------------------------------------------------- # # Table structure for table `phpcoin_admins` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_admins`; CREATE TABLE `phpcoin_admins` ( `admin_id` smallint(6) NOT NULL auto_increment, `admin_user_name` varchar(30) NOT NULL default '', `admin_user_pword` varchar(100) NOT NULL default '', `admin_name_first` varchar(20) NOT NULL default 'none', `admin_name_last` varchar(20) NOT NULL default 'none', `admin_email` varchar(50) NOT NULL default 'none', `admin_perms` int(11) NOT NULL default '0', PRIMARY KEY (`admin_id`), UNIQUE KEY `user_name` (`admin_user_name`) ) TYPE=MyISAM COMMENT='Site Admins Table' AUTO_INCREMENT=2 ; # # Dumping data for table `phpcoin_admins` # INSERT INTO `phpcoin_admins` (`admin_id`, `admin_user_name`, `admin_user_pword`, `admin_name_first`, `admin_name_last`, `admin_email`, `admin_perms`) VALUES (1, 'webmaster', '$1$zB.xB3C5$KEEsRYelDErDwt.GlQo5j1', 'none', 'none', 'webmaster@ageeksite.com', 65535); # -------------------------------------------------------- # # Table structure for table `phpcoin_articles` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_articles`; CREATE TABLE `phpcoin_articles` ( `id` int(9) NOT NULL auto_increment, `subject` varchar(50) NOT NULL default '', `topic_id` int(11) NOT NULL default '1', `cat_id` int(11) NOT NULL default '1', `time_stamp` varchar(10) default NULL, `entry` mediumtext NOT NULL, `followup_cnt` int(9) NOT NULL default '0', `auto_nl2br` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Site Articles Module Table' AUTO_INCREMENT=2 ; # # Dumping data for table `phpcoin_articles` # INSERT INTO `phpcoin_articles` (`id`, `subject`, `topic_id`, `cat_id`, `time_stamp`, `entry`, `followup_cnt`, `auto_nl2br`) VALUES (1, 'Welcome to our phpCOIN site', 1, 1, '1073158772', 'Just to note we are now running the phpCOIN package.\r\n\r\nCheck back for more info.', 0, 1); # -------------------------------------------------------- # # Table structure for table `phpcoin_banned` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_banned`; CREATE TABLE `phpcoin_banned` ( `banned_ip` varchar(15) NOT NULL default '' ) TYPE=MyISAM COMMENT='Site Banned IP Address Table'; # # Dumping data for table `phpcoin_banned` # INSERT INTO `phpcoin_banned` (`banned_ip`) VALUES ('000.000.000.000'); # -------------------------------------------------------- # # Table structure for table `phpcoin_categories` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_categories`; CREATE TABLE `phpcoin_categories` ( `cat_id` int(11) NOT NULL auto_increment, `cat_pos` smallint(6) NOT NULL default '0', `cat_name` varchar(50) NOT NULL default '', `cat_desc` varchar(50) NOT NULL default '', `cat_icon` smallint(6) NOT NULL default '1', PRIMARY KEY (`cat_id`), KEY `cat_id` (`cat_id`) ) TYPE=MyISAM COMMENT='Site Categories Table' AUTO_INCREMENT=4 ; # # Dumping data for table `phpcoin_categories` # INSERT INTO `phpcoin_categories` (`cat_id`, `cat_pos`, `cat_name`, `cat_desc`, `cat_icon`) VALUES (1, 0, 'General', 'General / Default Category', 1), (2, 0, 'News', 'For News Items', 1), (3, 0, 'Site Related', 'For Site Related Items', 1); # -------------------------------------------------------- # # Table structure for table `phpcoin_clients` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_clients`; CREATE TABLE `phpcoin_clients` ( `cl_id` int(11) NOT NULL default '0', `cl_join_ts` varchar(10) default NULL, `cl_status` varchar(20) NOT NULL default 'pending', `cl_company` varchar(50) NOT NULL default '', `cl_name_first` varchar(20) NOT NULL default '', `cl_name_last` varchar(20) NOT NULL default '', `cl_addr_01` varchar(50) NOT NULL default '', `cl_addr_02` varchar(50) NOT NULL default '', `cl_city` varchar(50) NOT NULL default '', `cl_state_prov` varchar(50) NOT NULL default '', `cl_country` varchar(50) NOT NULL default '', `cl_zip_code` varchar(12) NOT NULL default '', `cl_phone` varchar(20) NOT NULL default '', `cl_email` varchar(50) NOT NULL default '', `cl_user_name` varchar(20) NOT NULL default '', `cl_user_pword` varchar(50) NOT NULL default '', `cl_notes` text NOT NULL, `cl_groups` int(11) NOT NULL default '0', PRIMARY KEY (`cl_id`) ) TYPE=MyISAM COMMENT='Site Clients Module Table'; # # Dumping data for table `phpcoin_clients` # # -------------------------------------------------------- # # Table structure for table `phpcoin_components` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_components`; CREATE TABLE `phpcoin_components` ( `comp_id` mediumint(9) NOT NULL auto_increment, `comp_type` varchar(20) NOT NULL default '', `comp_name` varchar(20) NOT NULL default '', `comp_mod` varchar(20) NOT NULL default '', `comp_desc` varchar(50) NOT NULL default '', `comp_ptitle` varchar(50) NOT NULL default '', `comp_col_num` tinyint(1) NOT NULL default '3', `comp_isadmin` tinyint(1) NOT NULL default '0', `comp_isuser` tinyint(1) NOT NULL default '0', `comp_status` tinyint(1) NOT NULL default '1', PRIMARY KEY (`comp_id`), KEY `comp_id` (`comp_id`) ) TYPE=MyISAM COMMENT='Site Components Table' AUTO_INCREMENT=49 ; # # Dumping data for table `phpcoin_components` # INSERT INTO `phpcoin_components` (`comp_id`, `comp_type`, `comp_name`, `comp_mod`, `comp_desc`, `comp_ptitle`, `comp_col_num`, `comp_isadmin`, `comp_isuser`, `comp_status`) VALUES (1, 'site', 'index', '', 'Site index', 'Home Page', 2, 0, 0, 1), (2, 'site', 'login', '', 'Site Login', 'Site Login', 2, 0, 0, 1), (3, 'site', 'site_F01', '', 'Site Future 01', 'Site Future 01', 2, 1, 0, 0), (4, 'site', 'site_F02', '', 'Site Future 02', 'Site Future 02', 2, 1, 0, 0), (5, 'site', 'site_F03', '', 'Site Future 03', 'Site Future 03', 2, 1, 0, 0), (6, 'site', 'site_F04', '', 'Site Future 04', 'Site Future 04', 2, 1, 0, 0), (7, 'site', 'site_F05', '', 'Site Future 05', 'Site Future 05', 2, 1, 0, 0), (8, 'site', 'site_F06', '', 'Site Future 06', 'Site Future 06', 2, 1, 0, 0), (9, 'site', 'site_F07', '', 'Site Future 07', 'Site Future 07', 2, 1, 0, 0), (10, 'admin', 'cp_admins', '', 'Control Panel: Admins', 'Admin Admins', 2, 1, 0, 1), (11, 'admin', 'cp_banip', '', 'Control Panel: Banned IP', 'Admin Banned IP', 2, 1, 0, 1), (12, 'admin', 'cp_categories', '', 'Control Panel: Categories', 'Admin Categories', 2, 1, 0, 1), (13, 'admin', 'cp_components', '', 'Control Panel: Components', 'Admin Components', 2, 1, 0, 1), (14, 'admin', 'cp_icons', '', 'Control Panel: Icon', 'Admin Icons', 2, 1, 0, 1), (15, 'admin', 'cp_index', '', 'Control Panel: Admin Menu', 'Admin Menu', 2, 1, 0, 1), (16, 'admin', 'cp_mail_contacts', '', 'Control Panel: Mail Contacts', 'Admin Mail Contacts', 2, 1, 0, 1), (17, 'admin', 'cp_mail_templates', '', 'Control Panel: Mail Templates', 'Admin Mail Templates', 2, 1, 0, 1), (18, 'admin', 'cp_menu', '', 'Control Panel: Menu', 'Admin Menu', 2, 1, 0, 1), (19, 'admin', 'cp_parms', '', 'Control Panel: Parameters', 'Admin Parameters', 2, 1, 0, 1), (20, 'admin', 'cp_prods', '', 'Control Panel: Products', 'Admin Products', 2, 1, 0, 1), (21, 'admin', 'cp_server_info', '', 'Control Panel: Server Info', 'Admin Server Info', 2, 1, 0, 1), (22, 'admin', 'cp_siteinfo', '', 'Control Panel- Site Info', 'Admin SiteInfo', 2, 1, 0, 1), (23, 'admin', 'cp_topics', '', 'Control Panel: Topics', 'Admin Topics', 2, 1, 0, 1), (24, 'admin', 'cp_vendors', '', 'Control Panel: Vendors', 'Admin Vendors', 2, 1, 0, 1), (25, 'admin', 'cp_vprods', '', 'Control Panel: Vendor Products', 'Admin Vendor Products', 2, 1, 0, 1), (26, 'admin', 'admin_F01', '', 'Control Panel: Future 01', 'Admin Future 01', 2, 1, 0, 0), (27, 'admin', 'admin_F02', '', 'Control Panel: Future 02', 'Admin Future 02', 2, 1, 0, 0), (28, 'admin', 'admin_F03', '', 'Control Panel: Future 03', 'Admin Future 03', 2, 1, 0, 0), (29, 'admin', 'admin_F04', '', 'Control Panel: Future 04', 'Admin Future 04', 2, 1, 0, 0), (30, 'admin', 'admin_F05', '', 'Control Panel: Future 05', 'Admin Future 05', 2, 1, 0, 0), (31, 'auxpage', 'auxpage_example', '', 'Auxpage', 'Auxpage Example', 2, 0, 0, 1), (32, 'module', 'articles', '', 'Articles', 'Articles', 2, 0, 0, 1), (33, 'module', 'clients', '', 'Clients', 'Clients', 2, 0, 0, 1), (34, 'module', 'cc', '', 'Command Center', 'Command Center', 2, 0, 0, 1), (35, 'module', 'domains', '', 'Domains', 'Domains', 2, 0, 0, 1), (36, 'module', 'faq', '', 'FAQ Module', 'FAQ', 2, 0, 0, 1), (37, 'module', 'helpdesk', '', 'HelpDesk Module', 'HelpDesk Support Tickets', 2, 0, 0, 1), (38, 'module', 'invoices', '', 'Invoices', 'Invoices', 2, 0, 0, 1), (39, 'module', 'mail', '', 'Mail Module', 'Mail', 2, 0, 0, 1), (40, 'module', 'orders', '', 'Orders', 'Orders', 2, 0, 0, 1), (41, 'module', 'pages', '', 'Pages', 'Documentation', 2, 0, 0, 1), (42, 'module', 'search', '', 'Search Site', 'Search Site', 2, 0, 0, 1), (43, 'module', 'siteinfo', '', 'Site Info Related Output', 'Site Info', 2, 0, 0, 1), (44, 'module', 'mod_F02', '', 'Module: Future 02', 'Module Future 02', 2, 1, 0, 0), (45, 'module', 'mod_F03', '', 'Module: Future 03', 'Module Future 03', 2, 1, 0, 0), (46, 'module', 'mod_F04', '', 'Module: Future 04', 'Module Future 04', 2, 1, 0, 0), (47, 'module', 'mod_F05', '', 'Module: Future 05', 'Module Future 05', 2, 1, 0, 0), (48, 'module', 'mod_F06', '', 'Module: Future 06', 'Module Future 06', 2, 1, 0, 0); # -------------------------------------------------------- # # Table structure for table `phpcoin_domains` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_domains`; CREATE TABLE `phpcoin_domains` ( `dom_id` int(11) NOT NULL auto_increment, `dom_cl_id` int(11) NOT NULL default '0', `dom_domain` varchar(50) NOT NULL default '', `dom_status` tinyint(2) NOT NULL default '0', `dom_type` tinyint(2) NOT NULL default '0', `dom_registrar` varchar(32) NOT NULL default '', `dom_ts_expiration` varchar(10) NOT NULL default '', `dom_sa_expiration` varchar(10) NOT NULL default '', `dom_si_id` int(11) NOT NULL default '0', `dom_ip` varchar(16) NOT NULL default '', `dom_path` varchar(255) NOT NULL default '', `dom_path_temp` varchar(255) NOT NULL default '', `dom_url_cp` varchar(100) NOT NULL default '', `dom_user_name_cp` varchar(30) NOT NULL default '', `dom_user_pword_cp` varchar(30) NOT NULL default '', `dom_user_name_ftp` varchar(30) NOT NULL default '', `dom_user_pword_ftp` varchar(30) NOT NULL default '', `dom_allow_domains` smallint(6) NOT NULL default '0', `dom_allow_subdomains` smallint(6) NOT NULL default '0', `dom_allow_disk_space_mb` int(11) NOT NULL default '0', `dom_allow_traffic_mb` int(11) NOT NULL default '0', `dom_allow_mailboxes` smallint(6) NOT NULL default '0', `dom_allow_databases` smallint(6) NOT NULL default '0', `dom_enable_www_prefix` tinyint(1) NOT NULL default '0', `dom_enable_wu_scripting` tinyint(1) NOT NULL default '0', `dom_enable_webmail` tinyint(1) NOT NULL default '0', `dom_enable_frontpage` tinyint(1) NOT NULL default '0', `dom_enable_fromtpage_ssl` tinyint(1) NOT NULL default '0', `dom_enable_ssi` tinyint(1) NOT NULL default '0', `dom_enable_php` tinyint(1) NOT NULL default '0', `dom_enable_cgi` tinyint(1) NOT NULL default '0', `dom_enable_mod_perl` tinyint(1) NOT NULL default '0', `dom_enable_asp` tinyint(1) NOT NULL default '0', `dom_enable_ssl` tinyint(1) NOT NULL default '0', `dom_enable_stats` tinyint(1) NOT NULL default '0', `dom_enable_err_docs` tinyint(1) NOT NULL default '0', PRIMARY KEY (`dom_id`) ) TYPE=MyISAM COMMENT='Site Domains Module Table' AUTO_INCREMENT=1 ; # # Dumping data for table `phpcoin_domains` # # -------------------------------------------------------- # # Table structure for table `phpcoin_faq` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_faq`; CREATE TABLE `phpcoin_faq` ( `faq_id` int(9) NOT NULL auto_increment, `faq_position` int(9) NOT NULL default '1', `faq_time_stamp_mod` varchar(10) default NULL, `faq_status` tinyint(1) NOT NULL default '0', `faq_admin` tinyint(1) NOT NULL default '0', `faq_user` tinyint(1) NOT NULL default '0', `faq_title` varchar(50) NOT NULL default '', `faq_descrip` mediumtext NOT NULL, PRIMARY KEY (`faq_id`) ) TYPE=MyISAM COMMENT='Site FAQ Module Table' AUTO_INCREMENT=2 ; # # Dumping data for table `phpcoin_faq` # INSERT INTO `phpcoin_faq` (`faq_id`, `faq_position`, `faq_time_stamp_mod`, `faq_status`, `faq_admin`, `faq_user`, `faq_title`, `faq_descrip`) VALUES (1, 1, '1073158772', 1, 0, 0, 'General Information', 'For general information regarding this site.'); # -------------------------------------------------------- # # Table structure for table `phpcoin_faq_qa` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_faq_qa`; CREATE TABLE `phpcoin_faq_qa` ( `faqqa_id` int(9) NOT NULL auto_increment, `faqqa_faq_id` int(11) NOT NULL default '0', `faqqa_position` int(9) NOT NULL default '1', `faqqa_time_stamp_mod` varchar(10) default NULL, `faqqa_status` tinyint(1) NOT NULL default '0', `faqqa_question` varchar(255) NOT NULL default '', `faqqa_answer` mediumtext NOT NULL, `faqqa_auto_nl2br` tinyint(1) NOT NULL default '1', PRIMARY KEY (`faqqa_id`) ) TYPE=MyISAM COMMENT='Site FAQ Module QA Table' AUTO_INCREMENT=2 ; # # Dumping data for table `phpcoin_faq_qa` # INSERT INTO `phpcoin_faq_qa` (`faqqa_id`, `faqqa_faq_id`, `faqqa_position`, `faqqa_time_stamp_mod`, `faqqa_status`, `faqqa_question`, `faqqa_answer`, `faqqa_auto_nl2br`) VALUES (1, 1, 1, '1073158772', 1, 'Welcome to phpcoin.', 'Congratulations on this installation of the phpCOIN (Clients, Order, Invoices, and Notes) package. Please be sure to perform the following:
\r\n

Please review all documentation in the /docs folder of the package distribution.\r\n
Please be sure set / verify the settings in the site config file.\r\n
Please be sure set / verify the settings in the theme config file.\r\n
Please be sure to backup your database after the initial setup is completed.\r\n

\r\nPlease login to your admin control panel and set / verify required items.', 1); # -------------------------------------------------------- # # Table structure for table `phpcoin_helpdesk` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_helpdesk`; CREATE TABLE `phpcoin_helpdesk` ( `hd_tt_id` int(11) NOT NULL default '0', `hd_tt_cl_id` int(11) NOT NULL default '0', `hd_tt_cl_email` varchar(50) NOT NULL default '', `hd_tt_time_stamp` varchar(10) default NULL, `hd_tt_priority` varchar(20) NOT NULL default '', `hd_tt_category` varchar(20) NOT NULL default '', `hd_tt_subject` varchar(50) NOT NULL default '', `hd_tt_message` text NOT NULL, `hd_tt_cd_id` int(11) NOT NULL default '0', `hd_tt_url` varchar(50) NOT NULL default '', `hd_tt_status` varchar(20) NOT NULL default '', `hd_tt_closed` int(1) NOT NULL default '0', `hd_tt_rating` int(1) NOT NULL default '0', PRIMARY KEY (`hd_tt_id`) ) TYPE=MyISAM COMMENT='Site HelpDesk Module Table'; # # Dumping data for table `phpcoin_helpdesk` # # -------------------------------------------------------- # # Table structure for table `phpcoin_helpdesk_msgs` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_helpdesk_msgs`; CREATE TABLE `phpcoin_helpdesk_msgs` ( `hdi_tt_id` int(11) NOT NULL default '0', `hdi_tt_time_stamp` varchar(10) default NULL, `hdi_tt_cl_id` int(11) NOT NULL default '0', `hdi_tt_ad_id` int(11) NOT NULL default '0', `hdi_tt_message` text NOT NULL ) TYPE=MyISAM COMMENT='Site HelpDesk Module Messages Table'; # # Dumping data for table `phpcoin_helpdesk_msgs` # # -------------------------------------------------------- # # Table structure for table `phpcoin_icons` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_icons`; CREATE TABLE `phpcoin_icons` ( `icon_id` smallint(6) NOT NULL auto_increment, `icon_name` varchar(32) NOT NULL default '', `icon_desc` varchar(50) NOT NULL default '', `icon_filename` varchar(32) NOT NULL default 'default.gif', PRIMARY KEY (`icon_id`) ) TYPE=MyISAM COMMENT='Site Icons Table' AUTO_INCREMENT=2 ; # # Dumping data for table `phpcoin_icons` # INSERT INTO `phpcoin_icons` (`icon_id`, `icon_name`, `icon_desc`, `icon_filename`) VALUES (1, 'default', 'Default', 'default.gif'); # -------------------------------------------------------- # # Table structure for table `phpcoin_invoices` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_invoices`; CREATE TABLE `phpcoin_invoices` ( `invc_id` int(11) NOT NULL default '0', `invc_status` varchar(20) NOT NULL default 'draft', `invc_deliv_method` varchar(10) NOT NULL default '', `invc_delivered` tinyint(1) NOT NULL default '0', `invc_cl_id` int(11) NOT NULL default '0', `invc_total_cost` decimal(10,2) NOT NULL default '0.00', `invc_total_paid` decimal(10,2) NOT NULL default '0.00', `invc_subtotal_cost` decimal(10,2) NOT NULL default '0.00', `invc_tax_01_percent` decimal(3,2) NOT NULL default '0.00', `invc_tax_01_amount` decimal(10,2) NOT NULL default '0.00', `invc_tax_02_percent` decimal(3,2) NOT NULL default '0.00', `invc_tax_02_amount` decimal(10,2) NOT NULL default '0.00', `invc_tax_autocalc` tinyint(1) NOT NULL default '1', `invc_ts` varchar(10) default NULL, `invc_ts_due` varchar(10) default NULL, `invc_ts_paid` varchar(10) default NULL, `invc_bill_cycle` tinyint(1) NOT NULL default '1', `invc_recurring` tinyint(1) NOT NULL default '0', `invc_recurr_proc` tinyint(4) NOT NULL default '0', `invc_pay_link` text NOT NULL, `invc_terms` text NOT NULL, PRIMARY KEY (`invc_id`) ) TYPE=MyISAM COMMENT='Site Invoices Module Table'; # # Dumping data for table `phpcoin_invoices` # # -------------------------------------------------------- # # Table structure for table `phpcoin_invoices_items` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_invoices_items`; CREATE TABLE `phpcoin_invoices_items` ( `ii_invc_id` int(11) NOT NULL default '0', `ii_item_no` smallint(4) NOT NULL default '0', `ii_item_name` varchar(30) NOT NULL default '', `ii_item_desc` varchar(75) NOT NULL default '', `ii_item_cost` decimal(10,2) NOT NULL default '0.00', `ii_apply_tax_01` tinyint(1) NOT NULL default '1', `ii_apply_tax_02` tinyint(1) NOT NULL default '1', `ii_calc_tax_02_pb` tinyint(1) NOT NULL default '0', PRIMARY KEY (`ii_invc_id`,`ii_item_no`) ) TYPE=MyISAM COMMENT='Site Invoices Module Items Table'; # # Dumping data for table `phpcoin_invoices_items` # # -------------------------------------------------------- # # Table structure for table `phpcoin_invoices_trans` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_invoices_trans`; CREATE TABLE `phpcoin_invoices_trans` ( `it_id` bigint(11) NOT NULL auto_increment, `it_ts` varchar(10) default NULL, `it_invc_id` int(11) NOT NULL default '0', `it_type` tinyint(2) NOT NULL default '0', `it_origin` tinyint(2) NOT NULL default '0', `it_desc` varchar(50) NOT NULL default '', `it_amount` decimal(10,2) NOT NULL default '0.00', PRIMARY KEY (`it_id`) ) TYPE=MyISAM COMMENT='Site Invoices Module Transactions Table' AUTO_INCREMENT=1 ; # # Dumping data for table `phpcoin_invoices_trans` # # -------------------------------------------------------- # # Table structure for table `phpcoin_mail_archive` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_mail_archive`; CREATE TABLE `phpcoin_mail_archive` ( `ma_id` bigint(11) NOT NULL auto_increment, `ma_time_stamp` varchar(10) default NULL, `ma_fld_from` varchar(100) NOT NULL default '', `ma_fld_recip` varchar(100) NOT NULL default '', `ma_fld_cc` varchar(100) NOT NULL default '', `ma_fld_bcc` varchar(100) NOT NULL default '', `ma_fld_subject` varchar(100) NOT NULL default '', `ma_fld_message` text NOT NULL, PRIMARY KEY (`ma_id`) ) TYPE=MyISAM COMMENT='Site eMail Archive Table' AUTO_INCREMENT=1 ; # # Dumping data for table `phpcoin_mail_archive` # # -------------------------------------------------------- # # Table structure for table `phpcoin_mail_contacts` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_mail_contacts`; CREATE TABLE `phpcoin_mail_contacts` ( `mc_id` int(11) NOT NULL auto_increment, `mc_name` varchar(30) NOT NULL default '', `mc_email` varchar(50) NOT NULL default '', `mc_status` tinyint(1) NOT NULL default '1', PRIMARY KEY (`mc_id`) ) TYPE=MyISAM COMMENT='Site Mail Contacts Table' AUTO_INCREMENT=5 ; # # Dumping data for table `phpcoin_mail_contacts` # INSERT INTO `phpcoin_mail_contacts` (`mc_id`, `mc_name`, `mc_email`, `mc_status`) VALUES (1, 'Billing', 'billing@ageeksite.com', 1), (2, 'Orders', 'orders@ageeksite.com', 1), (3, 'Support', 'support@ageeksite.com', 1), (4, 'Webmaster', 'webmaster@ageeksite.com', 1); # -------------------------------------------------------- # # Table structure for table `phpcoin_mail_queue` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_mail_queue`; CREATE TABLE `phpcoin_mail_queue` ( `mq_id` bigint(11) NOT NULL default '0', `mq_time_stamp` varchar(10) default NULL, `mq_fld_from` varchar(100) NOT NULL default '', `mq_fld_recip` varchar(100) NOT NULL default '', `mq_fld_cc` varchar(100) NOT NULL default '', `mq_fld_bcc` varchar(100) NOT NULL default '', `mq_fld_subject` varchar(100) NOT NULL default '', `mq_fld_message` text NOT NULL, `mq_sent_flag` tinyint(1) NOT NULL default '0', PRIMARY KEY (`mq_id`) ) TYPE=MyISAM COMMENT='Site eMail Queue Table'; # # Dumping data for table `phpcoin_mail_queue` # # -------------------------------------------------------- # # Table structure for table `phpcoin_mail_templates` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_mail_templates`; CREATE TABLE `phpcoin_mail_templates` ( `mt_id` int(11) NOT NULL auto_increment, `mt_name` varchar(50) NOT NULL default '', `mt_text` text NOT NULL, PRIMARY KEY (`mt_id`) ) TYPE=MyISAM COMMENT='Site eMail Templates Table' AUTO_INCREMENT=21 ; # # Dumping data for table `phpcoin_mail_templates` # INSERT INTO `phpcoin_mail_templates` (`mt_id`, `mt_name`, `mt_text`) VALUES (1, 'email_password_reset', 'Hello $_MTP[username],\r\nThe following email from $_MTP[from_email] was triggered from a request to reset the password for this user name.\r\n\r\nThe new password is: $_MTP[password]\r\n\r\nPlease note the password has been reset. If you did not request the password change, we apologize for the inconvenience.\r\n\r\nAs a reminder, you can go to the following link to login and change you password.\r\n$_MTP[url]\r\n\r\n\r\n$_MTP[site] Support\r\n$_MTP[from_email]\r\n'), (2, 'email_contact_form', 'Hello $_MTP[to_name],\r\nThe following email from $_MTP[from_name] was sent through the $_MTP[site] contact form. Note- the sender has also been copied on this email.\r\n\r\nMessage as follows:\r\n-------------------\r\nTo: $_MTP[to_name]\r\nFrom: $_MTP[from_name]\r\nEmail: $_MTP[from_email]\r\n\r\nSubject: $_MTP[subject]\r\n\r\nMessage:\r\n$_MTP[message]\r\n\r\n-------------------\r\n'), (3, 'email_contact_client_form', 'Hello $_MTP[to_name],\r\nThe following email from $_MTP[from_name] was sent through the $_MTP[site] contact client form. Note- the sender may also be copied on this email.\r\n\r\nMessage as follows:\r\n-------------------\r\nTo: $_MTP[to_name]\r\nFrom: $_MTP[from_name]\r\nEmail: $_MTP[from_email]\r\n\r\nSubject: $_MTP[subject]\r\n\r\nMessage:\r\n$_MTP[message]\r\n\r\n-------------------\r\n'), (4, 'email_profile_copy', 'Hello $_MTP[to_name],\r\nThe following client profile copy is from $_MTP[site] $_MTP[from_name] department.\r\n\r\n-------------------\r\n$_MTP[cl_info]\r\n-------------------\r\n\r\nThis profile information can be edited online at the following link (requires login):\r\n $_MTP[cl_url]\r\n\r\nThank you for continuing to choose $_MTP[site] for your web service needs.\r\n\r\n $_MTP[from_name]\r\n $_MTP[from_email]\r\n'), (5, 'email_order_ack', 'Hello $_MTP[to_name],\r\nThe following order acknowledgement is from $_MTP[site] $_MTP[from_name] department.\r\n\r\n-------------------\r\n$_MTP[order]\r\n-------------------\r\n\r\nThis order can be monitored online at the following link (requires login):\r\n $_MTP[ord_url]\r\n\r\nThank you for continuing to choose $_MTP[site] for your web service needs.\r\n\r\n $_MTP[from_name]\r\n $_MTP[from_email]\r\n'), (6, 'email_order_copy', 'Hello $_MTP[to_name],\r\nThe following order copy is from $_MTP[site] $_MTP[from_name] department.\r\n\r\n-------------------\r\n$_MTP[order]\r\n-------------------\r\n\r\nThis order can be monitored online at the following link (requires login):\r\n $_MTP[ord_url]\r\n\r\nThank you for continuing to choose $_MTP[site] for your web service needs.\r\n\r\n $_MTP[from_name]\r\n $_MTP[from_email]\r\n'), (7, 'email_trans_ack', 'Hello $_MTP[to_name],\r\nThe following email transaction acknowledgement is from $_MTP[site] $_MTP[from_name] department.\r\n\r\n Invoice ID: $_MTP[invc_id]\r\n Invoice Date: $_MTP[invc_ts]\r\n Date Due: $_MTP[invc_ts_due]\r\n Date Paid: $_MTP[invc_ts_paid]\r\n Status: $_MTP[invc_status]\r\n ----------------------\r\n Trans ID: $_MTP[it_id]\r\n Date: $_MTP[it_ts]\r\n Type: $_MTP[it_type]\r\n Origin: $_MTP[it_origin]\r\n Description: $_MTP[it_desc]\r\n Amount: $_MTP[it_amount]\r\n ----------------------\r\n\r\nThe following is overall account balance with $_MTP[site] and includes all account activity:\r\n\r\n Acc Balance: $_MTP[cl_balance]\r\n\r\nThis transaction can be viewed when visiting following link (requires login):\r\n $_MTP[invc_url]\r\n\r\nThank you for continuing to choose $_MTP[site] for your web service needs.\r\n\r\n $_MTP[from_name]\r\n $_MTP[from_email]\r\n'), (8, 'email_invoice_copy', 'Hello $_MTP[to_name],\r\nThe following email invoice is from $_MTP[site] $_MTP[from_name] department.\r\n\r\n Invoice ID: $_MTP[invc_id]\r\n Invoice Date: $_MTP[invc_ts]\r\n Date Due: $_MTP[invc_ts_due]\r\n Date Paid: $_MTP[invc_ts_paid]\r\n Billing Cycle: $_MTP[invc_bill_cycle]\r\n\r\n Subtotal Due: $_MTP[invc_subtotal_cost]\r\n Tax-01: $_MTP[invc_tax_01_amount] ($_MTP[invc_tax_01_percent]%)\r\n Tax-02: $_MTP[invc_tax_02_amount] ($_MTP[invc_tax_02_percent]%)\r\n ----------------------\r\n Total Due: $_MTP[invc_total_cost]\r\n\r\n(see below for items included in this invoice)\r\n\r\nThis invoice can be paid by clicking on the Payment Link when visiting following link (requires login):\r\n $_MTP[invc_url]\r\n\r\nThank you for continuing to choose $_MTP[site] for your web service needs.\r\n\r\n $_MTP[from_name]\r\n $_MTP[from_email]\r\n\r\nThe following is a list of items included in this invoice:\r\n-------------------\r\n$_MTP[iitems]\r\n-------------------\r\n\r\n\r\n'), (9, 'future-09', 'Future'), (10, 'email_domain_acc_activate', 'Hello $_MTP[to_name],\r\n\r\nWelcome! Thank you for choosing $_MTP[site] for your hosting needs.\r\n\r\nThis email contains vital information about your server account. Please read it thoroughly and print these pages or copy to a safe place.\r\n\r\n-------------------------------------------------------------\r\n1. General Client Profile Information\r\n-------------------------------------------------------------\r\n\r\n$_MTP[cl_info]\r\n\r\n-------------------------------------------------------------\r\n2. General Account Information\r\n-------------------------------------------------------------\r\n\r\nTo log into your account, please access:\r\n\r\n$_MTP[si_cp_url]\r\n or:\r\nhttps://$_MTP[si_ip]:$_MTP[si_cp_url_port]/login.php3\r\n\r\nServer Name: $_MTP[si_name]\r\nIP Address: $_MTP[si_ip] (shared)\r\nDomain Name: $_MTP[dom_domain]\r\nPOP Server: mail.$_MTP[dom_domain]\r\nSMTP Server: mail.$_MTP[dom_domain]\r\n\r\nNameservers: $_MTP[si_ns_01] (IP: $_MTP[si_ns_01_ip])\r\n $_MTP[si_ns_02] (IP: $_MTP[si_ns_02_ip])\r\n\r\nPlesk Username: $_MTP[dom_user_name_cp]\r\nPlesk Password: $_MTP[dom_user_pword_cp]\r\n\r\nFTP Username: $_MTP[dom_user_name_ftp]\r\nFTP Password: $_MTP[dom_user_pword_ftp]\r\nFTP URL: ftp.$_MTP[dom_domain] (once resolved)\r\n\r\nPlease remember that it will take a short time for your Registrar to process the delegation request and for this new DNS to propagate around the internet. During that time, you will not be able to access this site as normal through a web browser. However, you can still access your site during this period by pointing your browser to:\r\n\r\n http://$_MTP[si_ip]/~$_MTP[dom_user_name_ftp]\r\n\r\nPlease note that CGI and PHP will not function properly while view your site through this special IP address. It is just a temporary measure to assist you in preparing your site while your new DNS transfer around the net.\r\n\r\nYou can upload your site by pointing your FTP software to your shared IP address ($_MTP[si_ip]). This means that you do not have to wait for your domain name to be transferred to our servers before you can upload your site. Once your domain has fully propagated around the net, you will be able to access your FTP account via your own domain name.\r\n\r\n\r\n-------------------------------------------------------------\r\n3. Once your domain resolves:\r\n-------------------------------------------------------------\r\n\r\n Your webmail URL is: http://webmail.$_MTP[dom_domain]\r\n\r\n Your Webstats URL is: http://$_MTP[dom_domain]/webstat/\r\n (stats can also be viewed from control panel)\r\n\r\n\r\n-------------------------------------------------------------\r\n4. Setting Up An Email Account\r\n-------------------------------------------------------------\r\n\r\n Before you can start sending or receiving email, you must\r\n set up at least one email account. To do this, please\r\n follow the instructions below:\r\n\r\n 1. Log in to the control panel\r\n ($_MTP[si_cp_url])\r\n using your control panel username and password.\r\n\r\n 2. Click on the MAIL button.\r\n\r\n 3. Enter the mail name that you want to create (i.e. "bob",\r\n "editor", "webmaster" etc., not the full address).\r\n\r\n 4. Click on the ADD button\r\n\r\n 5. Check/Tick the "Mailbox" box\r\n\r\n 6. Enter and confirm a password that you would like to use\r\n\r\n 7. Scroll down to the bottom and click UPDATE\r\n\r\n\r\n-------------------------------------------------------------\r\n5. Billing Information\r\n-------------------------------------------------------------\r\n\r\nFor increased security reasons we do not process credit cards ourselves on our servers. Depending on your selection of payment method when ordering, one of two third party processors will be used:\r\n\r\n Paypal: - Charge will appear as "Paypal"\r\n Credit Card: - Charge will appear as "2CheckOut.com Inc."\r\n\r\nRegardless of the method you selected, you will receive an order confirmation email detailing your order information.\r\n\r\nIf your email addresses changes, please notify us of your new email address and also update your profile in the control panel via the EDIT button.\r\n\r\n\r\n-------------------------------------------------------------\r\n6. Support Methods\r\n-------------------------------------------------------------\r\n\r\nWhen looking for information or support. Please go through the motions:\r\n(see $_MTP[site] on the Client Tools menu for all these links)\r\n\r\na. FAQ Knowledgebase:\r\nFor general and other information, browse and search our FAQ:\r\n\r\n http://www.yoursite.com/phpcoin/mod.php?mod=faq\r\n\r\n\r\nb. The $_MTP[site] Community:\r\nWe can�t stress enough, the importance of joining and participating in our community forums. Often, you can find the answers to your questions just by searching for keywords or posting a question. There are other members who can help you out with certain things that are not covered by our normal support options (Programming etc). You can also interact with $_MTP[site] staff, give us feedback and generally discuss our service at a community level.\r\n\r\n http://forums.yoursite.com\r\n\r\nImportant note: The community is installed on a different server than the primary website. The reason for this is in the event you cannot reach the main site due to server issues, you should be able to reach the community for information and updates.\r\n\r\n\r\nc. HelpDesk:\r\nIf you require assistance please contact our Technical Support Team by submitting a support form. We will be happy to assist you. All support requests MUST be done using our ticket support system, which can be accessed at:\r\n\r\n http://www.yoursite.com/phpcoin/mod.php?mod=helpdesk\r\n\r\n\r\nd. Quick Chat:\r\nFor immediate assistance, check the Quick Chat feature setup on the main site. Simply click on the "Quick Chat" link under the client Tools menu. Login and and quite possibly someone will be there who can assist you.\r\n\r\n\r\ne. Email Support:\r\nThis form of support is mostly used for sales, orders, or basic questions. Please view the Contacts Info link on the main site for up-to-date links for email options.\r\n\r\n\r\nf. Phone Support:\r\nCurrently, $_MTP[site] does not offer phone support.\r\n\r\n\r\nh. Regular Mail:\r\n\r\n $_UVAR[CO_INFO_01_NAME]\r\n c/o Customer Service\r\n $_UVAR[CO_INFO_02_ADDR_01]\r\n $_UVAR[CO_INFO_03_ADDR_02]\r\n $_UVAR[CO_INFO_04_CITY], $_UVAR[CO_INFO_05_STATE_PROV] $_UVAR[CO_INFO_06_POSTAL_CODE]\r\n $_UVAR[CO_INFO_07_COUNTRY]\r\n\r\n Phone: $_UVAR[CO_INFO_08_PHONE]\r\n Fax: $_UVAR[CO_INFO_09_FAX]\r\n\r\nOnce again, this email contains vital information about your account. \r\nPlease read it thoroughly and print these pages or copy to a safe place.\r\n\r\nThank you again for choosing $_MTP[site] as your service provider.\r\n\r\n $_MTP[from_name]\r\n $_MTP[from_email]\r\n'), (11, 'future-11', 'Future'), (12, 'email_helpdesk_tt_update', 'Hello $_MTP[to_name],\r\nThe following email HelpDesk Ticket is from $_MTP[site] $_MTP[from_name] department and is the result of $_MTP[req_type].\r\n\r\nThis ticket can be viewed by clicking on the following link (requires login):\r\n $_MTP[tt_url]\r\n\r\nThank you for continuing to choose $_MTP[site] for your web service needs.\r\n\r\n $_MTP[from_name]\r\n $_MTP[from_email]\r\n\r\n------------------------------\r\n Ticket ID: $_MTP[hd_tt_id]\r\n Date Opened: $_MTP[hd_tt_time_stamp]\r\n Priority: $_MTP[hd_tt_priority]\r\n Category: $_MTP[hd_tt_category]\r\n Domain: $_MTP[cd_cl_domain]\r\n\r\n Status: $_MTP[hd_tt_status]\r\n Open/Closed: $_MTP[hd_tt_closed]\r\n Rating: $_MTP[hd_tt_rating]\r\n\r\n Subject: $_MTP[hd_tt_subject]\r\n Message (below):\r\n ----------------\r\n$_MTP[hd_tt_message]\r\n------------------------------\r\n\r\nThe following is a listing of HelpDesk Support Ticket messages to date:\r\n\r\n$_MTP[tt_msgs]\r\n------------------------------\r\n'), (13, 'email_helpdesk_tt_alert', ' Ticket ID: $_MTP[hd_tt_id]\r\n Priority: $_MTP[hd_tt_priority]\r\n Subject: $_MTP[hd_tt_subject]\r\n'), (14, 'future-14', 'Future'), (15, 'email_custom_order_request', 'Hello $_MTP[to_name],\r\nThe following email from $_MTP[from_name] was sent through the $_MTP[site] Custom Order Request system, and is a copy for your records.\r\n\r\nWe will be contacting you with the results of our processing the information you requested.\r\n\r\nThe following client profile was created as a result of your order request. In the event you choose to place the order, you can login to place the order.\r\n\r\n-------------------\r\n$_MTP[cl_info]\r\n-------------------\r\n\r\nThe following is the information you entered into the Custom Order Request form.\r\n\r\n-------------------\r\n$_MTP[cor_info]\r\n-------------------\r\n\r\n\r\nThank you for continuing to choose $_MTP[site] for your web service needs.\r\n\r\n $_MTP[from_name]\r\n $_MTP[from_email]\r\n'), (16, 'future-16', 'Future'), (17, 'future-17', 'Future'), (18, 'future-18', 'Future'), (19, 'future-19', 'Future'), (20, 'future-20', 'Future'); # -------------------------------------------------------- # # Table structure for table `phpcoin_menu_blocks` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_menu_blocks`; CREATE TABLE `phpcoin_menu_blocks` ( `block_id` smallint(6) NOT NULL auto_increment, `block_pos` smallint(6) NOT NULL default '0', `block_title` varchar(30) NOT NULL default '', `block_status` tinyint(1) NOT NULL default '0', `block_admin` tinyint(1) NOT NULL default '0', `block_user` tinyint(1) NOT NULL default '0', `block_col` char(1) NOT NULL default 'L', PRIMARY KEY (`block_id`), UNIQUE KEY `block_id` (`block_id`) ) TYPE=MyISAM COMMENT='Site Menu Blocks Table' AUTO_INCREMENT=5 ; # # Dumping data for table `phpcoin_menu_blocks` # INSERT INTO `phpcoin_menu_blocks` (`block_id`, `block_pos`, `block_title`, `block_status`, `block_admin`, `block_user`, `block_col`) VALUES (1, 1, 'Main Menu', 1, 0, 0, 'L'), (2, 2, 'Administrator', 1, 1, 0, 'L'), (3, 3, 'Client Tools', 1, 0, 0, 'L'), (4, 4, 'Misc. Links', 1, 0, 0, 'R'); # -------------------------------------------------------- # # Table structure for table `phpcoin_menu_blocks_items` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_menu_blocks_items`; CREATE TABLE `phpcoin_menu_blocks_items` ( `block_id` smallint(6) NOT NULL default '0', `item_id` smallint(6) NOT NULL default '0', `item_text` varchar(30) NOT NULL default '', `item_url` varchar(100) NOT NULL default '', `item_target` tinyint(1) NOT NULL default '0', `item_type` tinyint(1) NOT NULL default '0', `item_status` tinyint(1) NOT NULL default '1', `item_admin` tinyint(1) NOT NULL default '0', `item_user` tinyint(1) NOT NULL default '0', PRIMARY KEY (`block_id`,`item_id`) ) TYPE=MyISAM COMMENT='Site Menu Blocks Items Table'; # # Dumping data for table `phpcoin_menu_blocks_items` # INSERT INTO `phpcoin_menu_blocks_items` (`block_id`, `item_id`, `item_text`, `item_url`, `item_target`, `item_type`, `item_status`, `item_admin`, `item_user`) VALUES (1, 1, 'Home', 'index.php', 0, 0, 1, 0, 0), (1, 3, 'About Us', 'mod.php?mod=siteinfo&id=4', 0, 0, 1, 0, 0), (1, 5, 'Contact Us', 'mod.php?mod=mail&mode=contact', 0, 0, 1, 0, 0), (2, 1, 'Admin', 'admin.php', 0, 0, 1, 1, 0), (2, 3, 'PHP-Info', 'phpinfo.php', 1, 0, 1, 1, 0), (2, 9, 'Logout', 'login.php?w=admin&o=logout', 0, 0, 1, 1, 0), (3, 1, 'Client Info.', 'mod.php?mod=clients', 0, 0, 1, 0, 0), (3, 3, 'Order Info.', 'mod.php?mod=orders&mode=view', 0, 0, 1, 0, 0), (3, 5, 'Invoice Info.', 'mod.php?mod=invoices', 0, 0, 1, 0, 0), (3, 7, 'Place Order', 'mod.php?mod=orders', 0, 0, 1, 0, 0), (3, 15, 'Log Out', 'login.php?w=user&o=logout', 0, 0, 1, 0, 1), (4, 1, 'phpCOIN.com', 'http://www.phpcoin.com', 1, 0, 1, 0, 0); # -------------------------------------------------------- # # Table structure for table `phpcoin_orders` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_orders`; CREATE TABLE `phpcoin_orders` ( `ord_id` int(11) NOT NULL default '0', `ord_ts` varchar(10) default NULL, `ord_ip` varchar(16) NOT NULL default '000.000.000.000', `ord_status` varchar(20) NOT NULL default 'pending', `ord_cl_id` int(11) NOT NULL default '0', `ord_company` varchar(50) NOT NULL default '', `ord_name_first` varchar(20) NOT NULL default '', `ord_name_last` varchar(20) NOT NULL default '', `ord_addr_01` varchar(50) NOT NULL default '', `ord_addr_02` varchar(50) NOT NULL default '', `ord_city` varchar(50) NOT NULL default '', `ord_state_prov` varchar(50) NOT NULL default '', `ord_country` varchar(50) NOT NULL default '', `ord_zip_code` varchar(12) NOT NULL default '', `ord_phone` varchar(20) NOT NULL default '', `ord_email` varchar(50) NOT NULL default '', `ord_domain` varchar(50) NOT NULL default '', `ord_domain_action` tinyint(1) NOT NULL default '0', `ord_user_name` varchar(20) NOT NULL default '', `ord_user_pword` varchar(50) NOT NULL default '', `ord_vendor_id` smallint(6) NOT NULL default '1', `ord_prod_id` smallint(6) NOT NULL default '0', `ord_unit_cost` decimal(10,2) NOT NULL default '0.00', `ord_accept_tos` tinyint(1) NOT NULL default '0', `ord_accept_aup` tinyint(1) NOT NULL default '0', `ord_referred_by` varchar(50) NOT NULL default '', `ord_comments` text NOT NULL, `ord_optfld_01` varchar(50) NOT NULL default '', `ord_optfld_02` varchar(50) NOT NULL default '', `ord_optfld_03` varchar(50) NOT NULL default '', `ord_optfld_04` varchar(50) NOT NULL default '', `ord_optfld_05` varchar(50) NOT NULL default '', PRIMARY KEY (`ord_id`) ) TYPE=MyISAM COMMENT='Site Orders Module Table'; # # Dumping data for table `phpcoin_orders` # # -------------------------------------------------------- # # Table structure for table `phpcoin_orders_sessions` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_orders_sessions`; CREATE TABLE `phpcoin_orders_sessions` ( `os_s_id` varchar(36) NOT NULL default '', `os_s_time_init` int(11) NOT NULL default '0', `os_s_time_last` int(11) NOT NULL default '0', `os_s_ip` varchar(16) NOT NULL default '000.000.000.000', `os_ord_processed` tinyint(1) NOT NULL default '0', `os_ord_ret_processed` tinyint(1) NOT NULL default '0', `os_ord_id` int(11) NOT NULL default '0', `os_ord_ts` varchar(10) default NULL, `os_ord_status` varchar(20) NOT NULL default 'pending', `os_ord_cl_id` int(11) NOT NULL default '0', `os_ord_company` varchar(50) NOT NULL default '', `os_ord_name_first` varchar(20) NOT NULL default '', `os_ord_name_last` varchar(20) NOT NULL default '', `os_ord_addr_01` varchar(50) NOT NULL default '', `os_ord_addr_02` varchar(50) NOT NULL default '', `os_ord_city` varchar(50) NOT NULL default '', `os_ord_state_prov` varchar(50) NOT NULL default '', `os_ord_country` varchar(50) NOT NULL default '', `os_ord_zip_code` varchar(12) NOT NULL default '', `os_ord_phone` varchar(20) NOT NULL default '', `os_ord_email` varchar(50) NOT NULL default '', `os_ord_domain` varchar(50) NOT NULL default '', `os_ord_domain_action` tinyint(1) NOT NULL default '0', `os_ord_user_name` varchar(20) NOT NULL default '', `os_ord_user_pword` varchar(50) NOT NULL default '', `os_ord_vendor_id` smallint(6) NOT NULL default '1', `os_ord_prod_id` smallint(6) NOT NULL default '0', `os_ord_unit_cost` decimal(10,2) NOT NULL default '0.00', `os_ord_accept_tos` tinyint(1) NOT NULL default '0', `os_ord_accept_aup` tinyint(1) NOT NULL default '0', `os_ord_referred_by` varchar(50) NOT NULL default '', `os_ord_comments` text NOT NULL, `os_ord_optfld_01` varchar(50) NOT NULL default '', `os_ord_optfld_02` varchar(50) NOT NULL default '', `os_ord_optfld_03` varchar(50) NOT NULL default '', `os_ord_optfld_04` varchar(50) NOT NULL default '', `os_ord_optfld_05` varchar(50) NOT NULL default '', `os_cor_flag` tinyint(1) NOT NULL default '0', `os_cor_type` varchar(32) NOT NULL default '', `os_cor_opt_bill_cycle` varchar(32) NOT NULL default '', `os_cor_opt_payment` varchar(32) NOT NULL default '', `os_cor_disk` smallint(6) NOT NULL default '0', `os_cor_disk_units` char(3) NOT NULL default 'Mb', `os_cor_traffic` smallint(6) NOT NULL default '0', `os_cor_traffic_units` char(3) NOT NULL default 'Gb', `os_cor_dbs` smallint(6) NOT NULL default '0', `os_cor_mailboxes` smallint(6) NOT NULL default '0', `os_cor_unique_ip` tinyint(1) NOT NULL default '0', `os_cor_shop_cart` tinyint(1) NOT NULL default '0', `os_cor_sec_cert` tinyint(1) NOT NULL default '0', `os_cor_site_pages` tinyint(4) NOT NULL default '0', `os_cor_comments` text NOT NULL, `os_cor_optfld_01` varchar(50) NOT NULL default '', `os_cor_optfld_02` varchar(50) NOT NULL default '', `os_cor_optfld_03` varchar(50) NOT NULL default '', `os_cor_optfld_04` varchar(50) NOT NULL default '', `os_cor_optfld_05` varchar(50) NOT NULL default '', PRIMARY KEY (`os_s_id`) ) TYPE=MyISAM COMMENT='Site Orders Module Sessions Table'; # # Dumping data for table `phpcoin_orders_sessions` # # -------------------------------------------------------- # # Table structure for table `phpcoin_pages` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_pages`; CREATE TABLE `phpcoin_pages` ( `id` int(9) NOT NULL auto_increment, `subject` varchar(50) NOT NULL default '', `topic_id` int(11) NOT NULL default '1', `cat_id` int(11) NOT NULL default '1', `time_stamp` varchar(10) default NULL, `pages_title` varchar(50) default NULL, `pages_code` longtext NOT NULL, `pages_block_it` tinyint(1) NOT NULL default '0', `pages_status` tinyint(1) NOT NULL default '0', `pages_admin` tinyint(1) NOT NULL default '0', `pages_link_menu` tinyint(1) NOT NULL default '0', `pages_link_prev` int(11) NOT NULL default '0', `pages_link_home` int(11) NOT NULL default '0', `pages_link_next` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Site Pages Module Table' AUTO_INCREMENT=2 ; # # Dumping data for table `phpcoin_pages` # INSERT INTO `phpcoin_pages` (`id`, `subject`, `topic_id`, `cat_id`, `time_stamp`, `pages_title`, `pages_code`, `pages_block_it`, `pages_status`, `pages_admin`, `pages_link_menu`, `pages_link_prev`, `pages_link_home`, `pages_link_next`) VALUES (1, 'Example Page', 1, 1, '1073158772', 'Example Page', '

Please note: This is a sample page.\r\n', 1, 1, 0, 0, 0, 0, 0); # -------------------------------------------------------- # # Table structure for table `phpcoin_parameters` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_parameters`; CREATE TABLE `phpcoin_parameters` ( `parm_id` smallint(6) NOT NULL auto_increment, `parm_group` varchar(10) NOT NULL default 'common', `parm_group_sub` varchar(10) NOT NULL default 'undefined', `parm_type` char(1) NOT NULL default 'S', `parm_name` varchar(50) NOT NULL default '', `parm_desc` varchar(50) NOT NULL default '', `parm_value` varchar(100) NOT NULL default '', `parm_notes` text NOT NULL, PRIMARY KEY (`parm_id`) ) TYPE=MyISAM COMMENT='Site Parameters Table' AUTO_INCREMENT=206 ; # # Dumping data for table `phpcoin_parameters` # INSERT INTO `phpcoin_parameters` (`parm_id`, `parm_group`, `parm_group_sub`, `parm_type`, `parm_name`, `parm_desc`, `parm_value`, `parm_notes`) VALUES (1, 'common', 'admin', 'I', '_MAX_MENU_BLK_POS', 'Menu Block Position List Max Select', '25', 'Determines the maximum number to appear in the menu block position field dropdown list.'), (2, 'common', 'admin', 'I', '_MAX_MENU_ITM_NO', 'Menu Block Item Position List Max Select', '25', 'Determines the maximum number to appear in the menu block item position field dropdown list.'), (3, 'common', 'admin', 'B', '_PARM_EDITOR_SHOW_NOTES', 'Parameter Editor Show Notes in Listing', '1', 'To enable the display of the parameter notes field in the main listing.'), (4, 'common', 'API', 'B', 'APIO_MASTER_ENABLE', 'API Output Master Enable', '0', 'Determines if the API Output function triggers (all) are enabled.'), (5, 'common', 'API', 'B', 'APIO_ORDER_COR_PROC_ENABLE', 'API Output Enable: Order COR Proc', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (6, 'common', 'API', 'B', 'APIO_ORDER_NEW_CLIENT_ENABLE', 'API Output Enable: Order New Client', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (7, 'common', 'API', 'B', 'APIO_ORDER_NEW_DOMAIN_ENABLE', 'API Output Enable: Order New Domain', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (8, 'common', 'API', 'B', 'APIO_ORDER_OUT_PROC_ENABLE', 'API Output Enable: Order Out Proc', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (9, 'common', 'API', 'B', 'APIO_ORDER_RET_PROC_ENABLE', 'API Output Enable: Order Return Proc', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (10, 'common', 'API', 'B', 'APIO_CLIENT_NEW_ENABLE', 'API Output Enable: Client Created', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (11, 'common', 'API', 'B', 'APIO_CLIENT_DEL_ENABLE', 'API Output Enable: Client Deleted', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (12, 'common', 'API', 'B', 'APIO_DOMAIN_NEW_ENABLE', 'API Output Enable: Domain Created', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (13, 'common', 'API', 'B', 'APIO_DOMAIN_DEL_ENABLE', 'API Output Enable: Domain Deleted', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (14, 'common', 'API', 'B', 'APIO_ORDER_NEW_ENABLE', 'API Output Enable: Order Created', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (15, 'common', 'API', 'B', 'APIO_ORDER_DEL_ENABLE', 'API Output Enable: Order Deleted', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (16, 'common', 'API', 'B', 'APIO_PRODUCT_NEW_ENABLE', 'API Output Enable: Product Created', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (17, 'common', 'API', 'B', 'APIO_PRODUCT_DEL_ENABLE', 'API Output Enable: Product Deleted', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (18, 'common', 'API', 'B', 'APIO_TRANS_NEW_ENABLE', 'API Output Enable: Trans Created', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (19, 'common', 'API', 'B', 'APIO_TRANS_DEL_ENABLE', 'API Output Enable: Trans Deleted', '0', 'Determines if the API Output function trigger is enabled for the indicated item.'), (20, 'common', 'articles', 'I', 'IPP_ARTICLES', 'Listing Items Per Page for: Articles', '10', 'Determines the number of articles that are displayed in listing form on a page.'), (21, 'common', 'articles', 'S', 'ARTICLES_DATE_DISPLAY_FORMAT', 'Articles Date/Time Display Format', '%A- %B %d, %Y @ %H:%M:%S %Z', 'Determines the display format for the Articles module date display. See http://www.php.net/manual/en/function.strftime.php for formatting options.'), (22, 'common', 'clients', 'I', 'BASE_CLIENT_ID', 'Client ID Base-Initial Value Minus 1', '1000', 'Determines the client id initial value for the first client entered in the system. Client ID will be this value plus one.'), (23, 'common', 'clients', 'I', 'IPP_CLIENTS', 'Listing Items Per Page for: Clients', '10', 'Determines the number of clients that are displayed on a page.'), (24, 'common', 'clients', 'I', 'IPL_CLIENTS_ACCOUNT', 'Listing Items Per List for: Client Account', '5', 'Determines the number of most recent items (orders, invoices, tickets) that are displayed on a clients account page.'), (25, 'common', 'clients', 'S', 'CLIENT_DEF_STATUS_NEW', 'Client Default Status on Create', 'active', 'Determines the default client status used when order placed, new auto-created.'), (26, 'common', 'clients', 'B', 'CLIENT_EMAIL_CC_ENABLE', 'Client Email CC Admin Enable', '1', 'Determines if the site admin will receive a copy each time a request is made to email a client profile.'), (27, 'common', 'clients', 'I', 'CLIENT_MAX_LEN_UNAME', 'Client Max. Characters for User Name', '16', 'Determines the maximum number of characters permitted in username form fields.'), (28, 'common', 'clients', 'I', 'CLIENT_MAX_LEN_PWORD', 'Client Max. Characters for Password', '16', 'Determines the maximum number of characters permitted in password form fields.'), (29, 'common', 'contacts', 'I', 'MC_ID_BILLING', 'Mail Contact ID For Billing', '1', 'Determines the mail contact id to be used when code requires an email address for: Billing'), (30, 'common', 'contacts', 'I', 'MC_ID_ORDERS', 'Mail Contact ID For Orders', '2', 'Determines the mail contact id to be used when code requires an email address for: Orders'), (31, 'common', 'contacts', 'I', 'MC_ID_SUPPORT', 'Mail Contact ID For Support', '3', 'Determines the mail contact id to be used when code requires an email address for: Support'), (32, 'common', 'contacts', 'I', 'MC_ID_WEBMASTER', 'Mail Contact ID For Webmaster', '4', 'Determines the mail contact id to be used when code requires an email address for: Webmaster'), (33, 'common', 'domains', 'I', 'IPP_DOMAINS', 'Listing Items Per Page for: Domains', '10', 'Determines the number of domains that are displayed in listing form on a page.'), (34, 'common', 'domains', 'I', 'DOM_DEFAULT_SERVER', 'Domain Account Default Server ID', '1', 'Determines the default server id that is inserted when a domain is created.'), (35, 'common', 'domains', 'S', 'DOM_DEFAULT_PATH', 'Domain Account Default Path', '/home/httpd/vhosts/domainname/httpdocs', 'Note: place "domainname" in path to have it replaced by domain name on entry create.'), (36, 'common', 'domains', 'B', 'DOM_EMAIL_CC_ENABLE', 'Domain Email CC Admin Enable', '1', 'Determines if the site admin will receive a copy each time a request is made to email a domain activation email.'), (37, 'common', 'domains', 'B', 'DOM_FORCE_CHECK_TRUE', 'Domain Name Validation Force True', '0', 'Determines if the domain validation logic always returns true. Only for those who not want to validate input domain names.'), (38, 'common', 'domains', 'S', 'DOM_DEFAULT_IP', 'Domain Account Default IP Address', '000.000.000.000', 'Determines the default domain IP address that is inserted when a domain account is created.'), (39, 'common', 'domains', 'S', 'DOM_DEFAULT_USERNAME', 'Domain CP/FTP Default User Name', 'username', 'Determines the default CP/FTP User Name inserted when a domain account is created. Choose "username" to insert client user name, or "domain" to insert the domain name.'), (40, 'common', 'domains', 'S', 'DOM_DEFAULT_CP_URL', 'Domain Default Control Panel URL', '', 'Determines the URL (fully qualified) that will be used for the control panel link shown in domain listings.'), (41, 'common', 'domains', 'B', 'DOM_CP_URL_LINK_ENABLE', 'Domain Listing CP Link Enable', '1', 'Determines if the control panel link will be shown in domain listings.'), (42, 'common', 'helpdesk', 'I', 'IPP_HELPDESK', 'Listing Items Per Page for: HelpDesk', '10', 'Determines the number of helpdesk tickets that are displayed in listing form on a page.\r\n'), (43, 'common', 'helpdesk', 'I', 'BASE_HELPDESK_ID', 'HelpDesk TT ID Base-Initial Value Minus 1', '1000', 'Determines the helpdesk ticket id initial value for the first helpdesk ticket entered in the system. Helpdesk Ticket ID will be this value plus one.'), (44, 'common', 'helpdesk', 'B', 'HELPDESK_ENABLE', 'Helpdesk Enable (Visible)', '1', 'Determines if the HelpDesk module is visible to the clients.'), (45, 'common', 'helpdesk', 'S', 'HELPDESK_ALERT_EMAIL_ADDRESS', 'HelpDesk TT Alert Email Address', 'webmaster@ageeksite.com', 'Determines the email (pager email) address the Alert Email is sent to. Does not effect normal support email received.'), (46, 'common', 'helpdesk', 'B', 'HELPDESK_ALERT_EMAIL_ENABLE', 'Helpdesk TT Alert Email Enable', '1', 'Determines if an Alert Email is also sent when a new ticket is created. In addition to normal email to support.'), (47, 'common', 'helpdesk', 'B', 'HELPDESK_ADMIN_REVEAL_ENABLE', 'Helpdesk Admin Reveal Identity Enable', '0', 'The setting is to enable the Admin responding to HelpDesk items to be identified by Admin information in listing and emails.'), (48, 'common', 'helpdesk', 'B', 'HELPDESK_MSG_CC_CLIENT_ENABLE', 'Helpdesk Message Email CC Client Enable', '0', 'The setting is to email CC to the client when they submit helpdesk messages. Set to no, only the support receives the message.'), (49, 'common', 'helpdesk', 'B', 'HELPDESK_REPLY_EMAIL_SET_LIMIT', 'Helpdesk Reply Email Limit Messages Sent', '0', 'The setting will limit the number of helpdesk messages included in the reply notice email, to the _LIMIT parameter most recent.'), (50, 'common', 'helpdesk', 'I', 'HELPDESK_REPLY_EMAIL_LIMIT', 'Helpdesk Reply Email Messages Limit Setting', '2', 'The setting is the number of most recent messages to include in the reply notice email.'), (51, 'common', 'helpdesk', 'B', 'HELPDESK_SHOW_CLIENT_NAME', 'Helpdesk Admin List Show Client Name', '0', 'The setting is to enable the Client column in the Admin Helpdesk listing.'), (52, 'common', 'invoices', 'I', 'IPP_INVOICES', 'Listing Items Per Page for: Invoices', '10', 'Determines the number of invoices that are displayed in listing form on a page.\r\n'), (53, 'common', 'invoices', 'I', 'BASE_INVOICE_ID', 'Invoice ID Base-Initial Value Minus 1', '1000', 'Determines the invoice id initial value for the first invoice entered in the system. Invoice ID will be this value plus one.'), (54, 'common', 'invoices', 'B', 'INVC_AUTO_EMAIL_ENABLE', 'Invoice Auto-Email to Clients Enable', '1', 'Determines if the auto-email of due invoices function is enabled when triggered by cron job or manually by command summary actions menu.'), (55, 'common', 'invoices', 'B', 'INVC_AUTO_EMAIL_CC_ENABLE', 'Invoice Auto-Email CC Admin Enable', '1', 'Determines if the site admin will receive a copy each time a the auto-email code sends an invoice.\r\n'), (56, 'common', 'invoices', 'B', 'INVC_AUTO_UPDATE_ENABLE', 'Invoice Auto-Update of Status Enable', '1', 'Determines if the auto-update of invoice status function is enabled when triggered by cron job or manually by command summary actions menu.'), (57, 'common', 'invoices', 'S', 'INVC_DEL_MTHD_DEFAULT', 'Invoice Delivery Method Default Value', 'email', 'Determines the default invoice delivery method presented on invoice create.'), (58, 'common', 'invoices', 'I', 'INVC_DUE_DAYS_OFFSET', 'Invoice Due Date Offset from Create in Days', '14', 'Determines the number of days to add to current date and set the due date to when creating a new invoice.'), (59, 'common', 'invoices', 'B', 'INVC_EMAIL_CC_ENABLE', 'Invoice Email CC Admin Enable', '1', 'Determines if the site admin will receive a copy each time a request is made to email an invoice.\r\n'), (60, 'common', 'invoices', 'B', 'INVC_TAX_01_ENABLE', 'Invoice Tax 01 Enable', '1', 'Determines if invoice tax 01 is enabled for display and calculation.'), (61, 'common', 'invoices', 'B', 'INVC_TAX_02_ENABLE', 'Invoice Tax 02 Enable', '1', 'Determines if invoice tax 02 is enabled for display and calculation.'), (62, 'common', 'invoices', 'B', 'INVC_TERMS_INSERT_DEF', 'Invoice Terms- Insert Default on New', '1', 'Determines if, when terms enabled, the default terms value is inserted on new invoice create (if left empty on save).'), (63, 'common', 'invoices', 'B', 'INVC_TERMS_ENABLE', 'Invoice Terms- Enable Display', '1', 'Determines if the invoice terms field is displayed on invoice views.'), (64, 'common', 'invoices', 'B', 'INVC_AUTO_COPY_ENABLE', 'Invoice Auto-Copy Recurring Enable', '1', 'Determines if the auto-copy of paid recurring invoices function is enabled when triggered by cron job or manually by command summary actions menu.'), (65, 'common', 'invoices', 'B', 'INVC_SHOW_CLIENT_PENDING', 'Invoice Show Client Pending Invoices', '1', 'Determines if the client will see invoices that are set to pending status.'), (66, 'common', 'invoices', 'B', 'INVC_SPLIT_TRANS_LIST_ENABLE', 'Invoice Transaction Listing Split Enable', '1', 'Determines if the invoice transaction listing is split to list charges on top, and then credits below (in seperate list).'), (67, 'common', 'invoices', 'B', 'INVC_TAX_BY_ITEM', 'Invoice Tax By Item Enable', '1', 'Determines if the taxes are applied at the items level (each item), or just on the total of items.'), (68, 'common', 'invoices', 'S', 'INVC_TAX_01_LABEL', 'Invoice Tax 01 Text Label', 'Tax 01:', 'Determines the text label displayed throughout the package in place of "Tax 01".'), (69, 'common', 'invoices', 'R', 'INVC_TAX_01_DEF_VAL', 'Invoice Tax 01 Rate Default Value', '0.00', 'Determines the default tax rate percentage value inserted for this tax. Example 1.00 equates to 1 percent.'), (70, 'common', 'invoices', 'S', 'INVC_TAX_02_LABEL', 'Invoice Tax 02 Text Label', 'Tax 02:', 'Determines the text label displayed throughout the package in place of "Tax 01".'), (71, 'common', 'invoices', 'R', 'INVC_TAX_02_DEF_VAL', 'Invoice Tax 02 Rate Default Value', '0.00', 'Determines the default tax rate percentage value inserted for this tax. Example 1.00 equates to 1 percent.'), (72, 'common', 'invoices', 'B', 'INVC_VIEW_SHOW_TRANS', 'Invoice View Show Transactions Enable', '1', 'Determines if the invoice transactions listing is displayed on lower portion of invoice view.'), (73, 'common', 'layout', 'S', '_PKG_FOOTER_LINE_01', 'Site Footer Block Line 01 Text', 'Copyright � ageeksite.com 2003-2004', 'Determines the line 01 text that will be displayed in footer of the page output.'), (74, 'common', 'layout', 'S', '_PKG_FOOTER_LINE_02', 'Site Footer Block Line 02 Text', '', 'Determines the line 02 text that will be displayed in footer of the page output.'), (75, 'undefined', 'module', 'I', 'IPP_MNEWS', 'Listing Items Per Page for: M-News', '30', 'Determines the number of news items that are displayed in listing form on a page. Future item.\r\n'), (76, 'common', 'operation', 'B', '_PKG_EMAIL_OUT_DISABLE', 'Package Email Out Disable', '0', 'Determines if the main email functions are disabled from sending.'), (77, 'common', 'operation', 'B', '_PKG_MODE_DEMO', 'Package Mode Enable- Demo', '0', 'Determines if the package is placed in demo mode.'), (78, 'common', 'operation', 'B', '_PKG_MODE_TEST', 'Package Mode Enable- Test.', '0', 'Determines if the package is placed in test mode. This mode is for admin setup and testing, and may display various items for convenience.'), (79, 'common', 'orders', 'I', 'IPP_ORDERS', 'Listing Items Per Page for: Orders', '10', 'Determines the number of orders that are displayed in listing form on a page.'), (80, 'common', 'orders', 'I', 'BASE_ORDER_ID', 'Order ID Base-Initial Value Minus 1', '1000', 'Determines the order id initial value for the first order entered in the system. Order ID will be this value plus one.'), (81, 'common', 'orders', 'B', 'ENABLE_EMAIL_ORDER_OUT', 'Email to Admin on Order Out Enable', '1', 'Determines if an email is sent to admin when client is showed the order paylinks (order inserted into system).'), (82, 'common', 'orders', 'B', 'ENABLE_EMAIL_ORDER_RET', 'Email to Admin on Order Return Enable', '1', 'Determines if an email is sent to admin when client is returned to site from billing vendor.'), (83, 'common', 'orders', 'B', 'ORDER_POLICY_BTTN_AUP', 'Order Policy Button Show: AUP', '1', 'Determines if order policy button for Acceptable Use Policy is shown on place order screens.'), (84, 'common', 'orders', 'B', 'ORDER_POLICY_BTTN_BC', 'Order Policy Button Show: BC', '1', 'Determines if order policy button for Banned Code is shown on place order screens.'), (85, 'common', 'orders', 'B', 'ORDER_POLICY_BTTN_PP', 'Order Policy Button Show: PP', '1', 'Determines if order policy button for Privacy Policy is shown on place order screens.'), (86, 'common', 'orders', 'B', 'ORDER_POLICY_BTTN_TOS', 'Order Policy Button Show: TOS', '1', 'Determines if order policy button for Terms Of Service is shown on place order screens.'), (87, 'common', 'orders', 'I', 'ORDER_POLICY_SI_ID_AUP', 'Order Policy SiteInfo ID for: AUP', '6', 'Determines the siteinfo page id for the Acceptable Use Policy button link.'), (88, 'common', 'orders', 'I', 'ORDER_POLICY_SI_ID_BC', 'Order Policy SiteInfo ID for: BC', '8', 'Determines the siteinfo page id for the Banned Code Policy button link.'), (89, 'common', 'orders', 'I', 'ORDER_POLICY_SI_ID_PP', 'Order Policy SiteInfo ID for: PP', '5', 'Determines the siteinfo page id for the Privacy Policy button link.'), (90, 'common', 'orders', 'I', 'ORDER_POLICY_SI_ID_TOS', 'Order Policy SiteInfo ID for: TOS', '7', 'Determines the siteinfo page id for the Terms Of Service button link.'), (91, 'common', 'orders', 'B', 'ORDER_EMAIL_CC_ENABLE', 'Order Email CC Admin Enable', '1', 'Determines if the site admin will receive a copy each time a request is made to email a order.'), (92, 'common', 'orders', 'B', 'ORDERS_ACK_EMAIL_ENABLE', 'Orders Ack Email To Client Enable', '0', 'Determines if an acknowledgment email will be sent to client on new order.'), (93, 'common', 'orders', 'B', 'ORDERS_ACK_EMAIL_ONRET', 'Orders Ack Email To Client On Return', '0', 'Determines if an acknowledgment email will be sent on return from vendor, instead of upon paylink display.'), (94, 'common', 'orders', 'B', 'ORDERS_ENABLE', 'Orders Module Enable', '1', 'Determines if the Orders module links / output is visible to clients.'), (95, 'common', 'orders', 'B', 'ORDERS_AUP_ENABLE', 'Orders Req. Acceptable Use Policy (AUP) Enable', '1', 'Determines if the agree to the Acceptable Use Policy button and requirement is visible during order placement.'), (96, 'common', 'orders', 'B', 'ORDERS_COR_ENABLE', 'Orders Custom Order Request (COR) Enable', '1', 'Determines if the Custom Order Request (COR) button / link is visible during the order placement.'), (97, 'common', 'orders', 'B', 'ORDERS_TOS_ENABLE', 'Orders Req. Terms Of Service (TOS) Enable', '1', 'Determines if the agree to the Terms Of Service button and requirement is visible during order placement.'), (98, 'common', 'orders', 'S', 'ORDERS_DEF_STATUS_NEW', 'Orders Default Status on Create', 'confirmed', 'Determines the default order status used when order placed, new auto-created.'), (99, 'common', 'orders', 'I', 'ORDERS_FIELD_ENABLE_COR', 'Orders Form Field Enable Settings- COR', '65504', 'Determines which fields are enabled (visible) on the orders COR form.'), (100, 'common', 'orders', 'I', 'ORDERS_FIELD_ENABLE_ORD', 'Orders Form Field Enable Settings- Order', '65504', 'Determines which fields are enabled (visible) on the orders order form. This also effects client editing forms.'), (101, 'common', 'orders', 'B', 'ORDERS_LIST_SHOW_PROD_DESC', 'Orders Listing Show Prod. Description', '1', 'Determines if the Product description will be displayed on Orders Listings instead of the default Vendor / Product Name columns.'), (102, 'common', 'orders', 'B', 'ORDERS_PROD_LIST_NAME_SHOW', 'Orders Product List Show Product Name', '1', 'Determines if the product name field is included in the order screen products list.'), (103, 'common', 'orders', 'I', 'ORDERS_PROD_LIST_SORT_ORDER', 'Orders Product List Primary Sort Field', '1', 'Determines which field will be the ascending sort order for the order screen products list.'), (104, 'common', 'package', 'S', '_CURRENCY_PREFIX', 'Currency Prefix String (ex. $)', '$', 'Determines the currency notation prefix, placed in front of currency amounts (where formatted to display).'), (105, 'common', 'package', 'S', '_CURRENCY_SUFFIX', 'Currency Suffix String (ex. USD)', '(USD)', 'Determines the currency notation suffix, placed following currency amounts (where formatted to display).'), (106, 'common', 'package', 'S', '_DB_PKG_LANG', 'Package Language (database setting)', 'lang_english', 'Determines which language files to load. The language file directory and files MUST exist prior to selection. Maybe be overridden by config.php setting.'), (107, 'common', 'package', 'S', '_DB_PKG_LOCALE', 'Package Locale Setting (datetime display)', 'en_EN', 'Some examples:\r\nBulgaria - bg_BG\r\nEnglish - en_EN (or English)\r\nFrench - fr_FR\r\nGerman - German\r\nSwedish - sv_SE\r\nSpanish - Spanish\r\n'), (108, 'common', 'package', 'S', '_DB_PKG_THEME', 'Package Theme (database setting)', 'earthtone', 'Determines which theme files to load. The theme file directory and files MUST exist prior to selection. Maybe be overridden by config.php setting.'), (109, 'common', 'package', 'I', '_NUMBER_FORMAT_ID', 'Number Format (see notes)', '3', 'Example number 1234.56\r\nValue = 1 Output: 1234\r\nValue = 2 Output: 1234.56\r\nValue = 3 Output: 1,234.56\r\nValue = 4 Output: 1 234,56\r\nValue = 5 Output: 1.234,56\r\n'), (110, 'common', 'package', 'S', '_PKG_NAME_SHORT', 'Site Name (short)', 'ageeksite.com', 'For display of site name (short version). This variable is used extensively in emails, and various pages.'), (111, 'common', 'package', 'S', '_PKG_NAME_LONG', 'Site Name (long)', 'ageeksite.com WebServices', 'Site long name for display, emails, etc. Basically longer version of the site short name.'), (112, 'common', 'package', 'S', '_PKG_EMAIL_MAIL', 'Package Email (default)', 'webmaster@ageeksite.com', 'Package last resort email address when it cannot locate a mail contacts entry.'), (113, 'common', 'package', 'S', '_PKG_TOP_GREETING', 'Site Top Block Greeting Text', 'Welcome To ageeksite.com WebServices', 'The Site Top Block (header) greeting text displayed if logo is not enabled.'), (114, 'common', 'package', 'B', '_PKG_DATE_SERVER_OFFSET', 'Date display server offset in hours (global)', '0', 'Determines any hour offset from server time for the timestamps recorded / displayed. Can be negative.'), (115, 'common', 'package', 'S', '_PKG_DATE_FORMAT_SHORT_DT', 'Date Display Format for: Short Date (numerical)', 'Y-m-d', 'Determines the display format for the short datetime, not locale setting dependent. See http://www.php.net/manual/en/function.date.php for formatting options.'), (116, 'common', 'package', 'S', '_PKG_DATE_FORMAT_SHORT_DTTM', 'Date Display Format for: Short DateTime (numerical', 'Y-m-d H:i:s', 'Determines the display format for the short datetime, not locale setting dependent. See http://www.php.net/manual/en/function.date.php for formatting options.'), (117, 'common', 'package', 'S', '_PKG_DATE_FORMAT_HEADER', 'Date Display Format for: Header Row', '%A- %B %d, %Y', 'Determines the display format for the header block date display. See http://www.php.net/manual/en/function.strftime.php for formatting options.'), (118, 'common', 'package', 'S', '_PKG_DATE_FORMAT_PRINT', 'Date Display Format for: Printing (includes time)', '%A- %B %d, %Y @ %H:%M:%S %Z', 'Determines the display format for the footer printed items date display. See http://www.php.net/manual/en/function.strftime.php for formatting options.'), (119, 'common', 'package', 'B', '_PKG_ENABLE_IP_BAN', 'Package Banned IP Feature Enable', '1', 'Package Banned IP Feature enables admin to create a list of banned IP addresses that can not view the site. Banned IPs are redirected to error message.'), (120, 'common', 'package', 'B', '_PKG_ENABLE_EMAIL_ARCHIVE', 'Package Email Archive Enable', '1', 'Package Email Archive Enable set to YES will archive ALL emails sent out of the package.'), (121, 'common', 'pages', 'I', 'IPP_PAGES', 'Listing Items Per Page for: Pages', '15', 'Determines the number of pages that are displayed in listing form on a page.\r\n'), (122, 'common', 'summary', 'I', 'CC_DOMAIN_EXP_IN_DAYS', 'Summary- Domains Expiring In Days', '30', 'The setting determines the number of days from current to show as expiring domains in summary listing.'), (123, 'common', 'summary', 'B', 'CC_DOMAIN_EXP_LIST_ENABLE', 'Summary- Domains Expiring List Enable', '1', 'The setting enables the display of the domains expiring list in summary listing.'), (124, 'common', 'summary', 'B', 'CC_DOMAIN_EXP_LIST_INCL_EXPRD', 'Summary- Domains Expiring List Include Expired', '1', 'The setting enables the display of the domains expiring list in summary listing to also include expired domains.'), (125, 'common', 'summary', 'I', 'CC_SACC_EXP_IN_DAYS', 'Summary- Server Accounts Expiring In Days', '30', 'The setting determines the number of days from current to show as expiring server accounts in summary listing.'), (126, 'common', 'summary', 'B', 'CC_SACC_EXP_LIST_ENABLE', 'Summary- Server Accounts Expiring List Enable', '1', 'The setting enables the display of the server account expiring list in summary listing.'), (127, 'common', 'summary', 'B', 'CC_SACC_EXP_LIST_INCL_EXPRD', 'Summary- Server Accounts Expiring List Include Exp', '1', 'The setting enables the display of the server account expiring list in summary listing to also include expired server accounts.'), (128, 'common', 'summary', 'B', 'CC_SERVER_LIST_ENABLE', 'Summary- Servers List Enable', '1', 'The setting enables the display of the servers list in summary listing.'), (129, 'theme', 'buttons', 'B', '_HDR_MENU_BTTN_01', 'Header Menu Button 01: Enable', '1', 'Determines whether the button appears in the top menu.'), (130, 'theme', 'buttons', 'B', '_HDR_MENU_BTTN_02', 'Header Menu Button 02: Enable', '1', 'Determines whether the button appears in the top menu.'), (131, 'theme', 'buttons', 'B', '_HDR_MENU_BTTN_03', 'Header Menu Button 03: Enable', '1', 'Determines whether the button appears in the top menu.'), (132, 'theme', 'buttons', 'B', '_HDR_MENU_BTTN_04', 'Header Menu Button 04: Enable', '1', 'Determines whether the button appears in the top menu.'), (133, 'theme', 'buttons', 'B', '_HDR_MENU_BTTN_05', 'Header Menu Button 05: Enable', '1', 'Determines whether the button appears in the top menu.'), (134, 'theme', 'buttons', 'B', '_HDR_MENU_BTTN_06', 'Header Menu Button 06: Enable', '1', 'Determines whether the button appears in the top menu.'), (135, 'theme', 'buttons', 'B', '_HDR_MENU_BTTN_07', 'Header Menu Button 07: Enable', '1', 'Determines whether the button appears in the top menu.'), (136, 'theme', 'buttons', 'B', '_HDR_MENU_BTTN_08', 'Header Menu Button 08: Enable', '0', 'Determines whether the button appears in the top menu.'), (137, 'theme', 'buttons', 'B', '_HDR_MENU_BTTN_09', 'Header Menu Button 09: Enable', '1', 'Determines whether the button appears in the top menu.'), (138, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_LINK_01', 'Header Menu Button 01: Link', 'index.php', 'Determines link (URL) for the corresponding button in main menu.'), (139, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_LINK_02', 'Header Menu Button 02: Link', 'mod.php?mod=siteinfo&id=4', 'Determines link (URL) for the corresponding button in main menu.'), (140, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_LINK_03', 'Header Menu Button 03: Link', 'mod.php?mod=articles', 'Determines link (URL) for the corresponding button in main menu.'), (141, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_LINK_04', 'Header Menu Button 04: Link', 'mod.php?mod=mail&mode=contact', 'Determines link (URL) for the corresponding button in main menu.'), (142, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_LINK_05', 'Header Menu Button 05: Link', 'mod.php?mod=faq', 'Determines link (URL) for the corresponding button in main menu.'), (143, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_LINK_06', 'Header Menu Button 06: Link', 'mod.php?mod=helpdesk', 'Determines link (URL) for the corresponding button in main menu.'), (144, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_LINK_07', 'Header Menu Button 07: Link', 'mod.php?mod=search', 'Determines link (URL) for the corresponding button in main menu.'), (145, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_LINK_08', 'Header Menu Button 08: Link', 'index.php', 'Determines link (URL) for the corresponding button in main menu.'), (146, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_LINK_09', 'Header Menu Button 09: Link', 'mod.php?mod=orders', 'Determines link (URL) for the corresponding button in main menu.'), (147, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_IMG_01', 'Header Menu Button 01: Image', '_IMG_MT_HOME_B', 'Determines image for the corresponding button in main menu.'), (148, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_IMG_02', 'Header Menu Button 02: Image', '_IMG_MT_ABOUT_US_B', 'Determines image for the corresponding button in main menu.'), (149, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_IMG_03', 'Header Menu Button 03: Image', '_IMG_MT_ARTICLES_B', 'Determines image for the corresponding button in main menu.'), (150, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_IMG_04', 'Header Menu Button 04: Image', '_IMG_MT_CONTACT_B', 'Determines image for the corresponding button in main menu.'), (151, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_IMG_05', 'Header Menu Button 05: Image', '_IMG_MT_FAQ_B', 'Determines image for the corresponding button in main menu.'), (152, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_IMG_06', 'Header Menu Button 06: Image', '_IMG_MT_HELPDESK_B', 'Determines image for the corresponding button in main menu.'), (153, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_IMG_07', 'Header Menu Button 07: Image', '_IMG_MT_SEARCH_B', 'Determines image for the corresponding button in main menu.'), (154, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_IMG_08', 'Header Menu Button 08: Image', '_IMG_MT_SERVICES_B', 'Determines image for the corresponding button in main menu.'), (155, 'theme', 'buttons', 'S', '_HDR_MENU_BTTN_IMG_09', 'Header Menu Button 09: Image', '_IMG_MT_PLACE_ORDER_B', 'Determines image for the corresponding button in main menu.'), (156, 'theme', 'buttons', 'B', '_USR_MENU_BTTN_02', 'User Menu Button 02: Enable', '1', 'Determines whether the button appears in the user menu.'), (157, 'theme', 'buttons', 'B', '_USR_MENU_BTTN_03', 'User Menu Button 03: Enable', '1', 'Determines whether the button appears in the user menu.'), (158, 'theme', 'buttons', 'B', '_USR_MENU_BTTN_04', 'User Menu Button 04: Enable', '1', 'Determines whether the button appears in the user menu.'), (159, 'theme', 'buttons', 'B', '_USR_MENU_BTTN_05', 'User Menu Button 05: Enable', '1', 'Determines whether the button appears in the user menu.'), (160, 'theme', 'buttons', 'B', '_USR_MENU_BTTN_06', 'User Menu Button 06: Enable', '1', 'Determines whether the button appears in the user menu.'), (161, 'theme', 'buttons', 'B', '_USR_MENU_BTTN_07', 'User Menu Button 07: Enable', '0', 'Determines whether the button appears in the user menu.'), (162, 'theme', 'buttons', 'B', '_USR_MENU_BTTN_08', 'User Menu Button 08: Enable', '0', 'Determines whether the button appears in the user menu.'), (163, 'theme', 'buttons', 'S', '_USR_MENU_BTTN_LINK_02', 'User Menu Button 02: Link', 'mod.php?mod=domains', 'Determines link (URL) for the corresponding button in user menu.'), (164, 'theme', 'buttons', 'S', '_USR_MENU_BTTN_LINK_03', 'User Menu Button 03: Link', 'mod.php?mod=orders&mode=view', 'Determines link (URL) for the corresponding button in user menu.'), (165, 'theme', 'buttons', 'S', '_USR_MENU_BTTN_LINK_04', 'User Menu Button 04: Link', 'mod.php?mod=invoices', 'Determines link (URL) for the corresponding button in user menu.'), (166, 'theme', 'buttons', 'S', '_USR_MENU_BTTN_LINK_05', 'User Menu Button 05: Link', 'mod.php?mod=helpdesk', 'Determines link (URL) for the corresponding button in user menu.'), (167, 'theme', 'buttons', 'S', '_USR_MENU_BTTN_LINK_06', 'User Menu Button 06: Link', 'mod.php?mod=cc', 'Determines link (URL) for the corresponding button in user menu.'), (168, 'theme', 'buttons', 'S', '_USR_MENU_BTTN_LINK_07', 'User Menu Button 07: Link', 'index.php', 'Determines link (URL) for the corresponding button in user menu.'), (169, 'theme', 'buttons', 'S', '_USR_MENU_BTTN_LINK_08', 'User Menu Button 08: Link', 'index.php', 'Determines link (URL) for the corresponding button in user menu.'), (170, 'theme', 'buttons', 'S', '_USR_MENU_BTTN_IMG_02', 'User Menu Button 02: Image', '_IMG_MU_DOMAINS_B', 'Determines image for the corresponding button in user menu.'), (171, 'theme', 'buttons', 'S', '_USR_MENU_BTTN_IMG_03', 'User Menu Button 03: Image', '_IMG_MU_ORDERS_B', 'Determines image for the corresponding button in user menu.'), (172, 'theme', 'buttons', 'S', '_USR_MENU_BTTN_IMG_04', 'User Menu Button 04: Image', '_IMG_MU_INVOICES_B', 'Determines image for the corresponding button in user menu.'), (173, 'theme', 'buttons', 'S', '_USR_MENU_BTTN_IMG_05', 'User Menu Button 05: Image', '_IMG_MU_HELPDESK_B', 'Determines image for the corresponding button in user menu.'), (174, 'theme', 'buttons', 'S', '_USR_MENU_BTTN_IMG_06', 'User Menu Button 06: Image', '_IMG_MU_SUMMARY_B', 'Determines image for the corresponding button in user menu.'), (175, 'theme', 'buttons', 'S', '_USR_MENU_BTTN_IMG_07', 'User Menu Button 07: Image', 'undefined', 'Determines image for the corresponding button in user menu.'), (176, 'theme', 'buttons', 'S', '_USR_MENU_BTTN_IMG_08', 'User Menu Button 08: Image', 'undefined', 'Determines image for the corresponding button in user menu.'), (177, 'theme', 'layout', 'B', '_DISABLE_MENU_COLS', 'Disable Menu Columns (Left / Right)', '1', 'Determines if the page left / right menu columns are hidden.'), (178, 'theme', 'layout', 'B', '_DISABLE_HEADER_BLK', 'Disable Header (top) Block', '0', 'Determines if the page header row is hidden.'), (179, 'theme', 'layout', 'B', '_DISABLE_FOOTER_BLK', 'Disable Footer (bottom) Block', '0', 'Determines if the page footer row is hidden.'), (180, 'theme', 'layout', 'B', '_ENABLE_ADMIN_LOGIN_LINK', 'Admin Login Link Button Enable', '1', 'Determines if the "Admin" login button link is displayed on the client login screen.'), (181, 'theme', 'layout', 'B', '_ENABLE_BTN_MOUSEOVER', 'Enable- Form Button Mouseover', '1', 'Enables the mouseover action on all form buttons throughout the package.'), (182, 'theme', 'layout', 'B', '_ENABLE_MENU_USER_HDR', 'Enable- Menu User in Header Block', '0', 'Determines if the logged in user / admin menu is visible as a line directly below the main header menu.'), (183, 'theme', 'layout', 'B', '_ENABLE_MENU_USER_HROW', 'Enable- Menu User in Header Row', '1', 'Determines if the logged in user / admin menu is visible as an additional row below the header.'), (184, 'theme', 'layout', 'B', '_ENABLE_MENU_USER_FROW', 'Enable- Menu User in Footer Row', '0', 'Determines if the logged in user / admin menu is visible as an additional row above the footer.'), (185, 'theme', 'layout', 'B', '_PAGE_HEADER_DATE', 'Site- Page Header Show Date', '1', 'Determines whether the date is displayed in the page header block.'), (186, 'theme', 'layout', 'B', '_PAGE_HEADER_LOGO', 'Site- Page Header Show Logo', '1', 'Determines whether the site logo, or greeting text is displayed in the page header block.'), (187, 'theme', 'layout', 'S', '_PAGE_HEADER_LOGO_FILE', 'Site- Page Logo Filename', 'logo_phpcoin.gif', 'Logo filename that is located in rhe site /images directory.'), (188, 'theme', 'layout', 'B', '_PAGE_HEADER_CLEAR', 'Site- Page Header Make Clear', '0', 'Determines if the site header row is colored (styles) or clear (underlying color).'), (189, 'theme', 'layout', 'B', '_PAGE_FOOTER_CLEAR', 'Site- Page Footer Make Clear', '1', 'Determines if the site footer row is colored (styles) or clear (underlying color).'), (190, 'theme', 'layout', 'B', '_PKG_WRAPPER_ENABLE', 'Enable- Package Wrapper', '0', 'Package Wrapper Feature enables "wrapper" code around the phpCOIN package.'), (191, 'theme', 'layout', 'S', '_WIDTH_OUTER_TABLE', 'Percent / Pixel (include % or px) of outmost table', '750px', 'Determines the pixel width of the package outermost table. Must be include either percent or pixel.'), (192, 'theme', 'layout', 'I', '_WIDTH_COL_BLOCK', 'Percentage Width Of Menu left / right columns', '15', 'Determines the percentage of total width for each left / right menu column.'), (193, 'theme', 'layout', 'I', '_WIDTH_MENU_BLOCK', 'Pixel Width Of Menu Block', '150', 'Determines the pixel width setting for a right / left column menu block.'), (194, 'theme', 'layout', 'S', '_WIDTH_CONTENT_AREA', 'Percentage width of Content Area Tables', '100%', 'Determines the percentage width of the center content area that non modules output will consume.'), (195, 'theme', 'layout', 'S', '_WIDTH_MODULE_AREA', 'Percentage Width Of Module Content', '100%', 'Determines the percentage width of the center content area that modules output will consume.'), (196, 'theme', 'layout', 'I', '_WIDTH_PRINT_AREA', 'Pixel width of Print Tables', '700', 'Determines the pixel width of the package outer most table when being printed.'), (197, 'user', 'package', 'S', 'CO_INFO_02_ADDR_01', 'Company Info 02: Address Line 01', '2112 Syrinx Ave.', 'Global scope variable, currently used in invoices.'), (198, 'user', 'package', 'S', 'CO_INFO_01_NAME', 'Company Info 01: Name', 'The phpCOIN Thing', 'Global scope variable, currently used in invoices.'), (199, 'user', 'package', 'S', 'CO_INFO_03_ADDR_02', 'Company Info 03: Address Line 02', 'Suite OU812', 'Global scope variable, currently used in invoices.'), (200, 'user', 'package', 'S', 'CO_INFO_04_CITY', 'Company Info 04: City', 'Rushville', 'Global scope variable, currently used in invoices.'), (201, 'user', 'package', 'S', 'CO_INFO_05_STATE_PROV', 'Company Info 05: State/Prov', 'Pa.', 'Global scope variable, currently used in invoices.'), (202, 'user', 'package', 'S', 'CO_INFO_06_POSTAL_CODE', 'Company Info 06: Postal Code', '12112', 'Global scope variable, currently used in invoices.'), (203, 'user', 'package', 'S', 'CO_INFO_07_COUNTRY', 'Company Info 07: Country', 'USA', 'Global scope variable, currently used in invoices.'), (204, 'user', 'package', 'S', 'CO_INFO_08_PHONE', 'Company Info 08: Phone No.', '(777)-555-2112', 'Global scope variable, currently used in invoices.'), (205, 'user', 'package', 'S', 'CO_INFO_09_FAX', 'Company Info 09: FAX', '(777)-555-2112', 'Global scope variable, currently used in invoices.'); # -------------------------------------------------------- # # Table structure for table `phpcoin_products` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_products`; CREATE TABLE `phpcoin_products` ( `prod_id` smallint(6) NOT NULL auto_increment, `prod_status` tinyint(1) NOT NULL default '1', `prod_name` varchar(20) NOT NULL default '', `prod_desc` varchar(75) NOT NULL default '', `prod_unit_cost` decimal(10,2) NOT NULL default '0.00', `prod_client_scope` int(11) NOT NULL default '0', `prod_apply_tax_01` tinyint(1) NOT NULL default '1', `prod_apply_tax_02` tinyint(1) NOT NULL default '1', `prod_calc_tax_02_pb` tinyint(1) NOT NULL default '0', `prod_dom_type` tinyint(2) NOT NULL default '0', `prod_allow_domains` smallint(6) NOT NULL default '0', `prod_allow_subdomains` smallint(6) NOT NULL default '0', `prod_allow_disk_space_mb` int(11) NOT NULL default '0', `prod_allow_traffic_mb` int(11) NOT NULL default '0', `prod_allow_mailboxes` smallint(6) NOT NULL default '0', `prod_allow_databases` smallint(6) NOT NULL default '0', `prod_cg_01` tinyint(1) NOT NULL default '0', `prod_cg_02` tinyint(1) NOT NULL default '0', `prod_cg_03` tinyint(1) NOT NULL default '0', `prod_cg_04` tinyint(1) NOT NULL default '0', `prod_cg_05` tinyint(1) NOT NULL default '0', `prod_cg_06` tinyint(1) NOT NULL default '0', `prod_cg_07` tinyint(1) NOT NULL default '0', `prod_cg_08` tinyint(1) NOT NULL default '0', PRIMARY KEY (`prod_id`) ) TYPE=MyISAM COMMENT='Site Products Table' AUTO_INCREMENT=3 ; # # Dumping data for table `phpcoin_products` # INSERT INTO `phpcoin_products` (`prod_id`, `prod_status`, `prod_name`, `prod_desc`, `prod_unit_cost`, `prod_client_scope`, `prod_apply_tax_01`, `prod_apply_tax_02`, `prod_calc_tax_02_pb`, `prod_dom_type`, `prod_allow_domains`, `prod_allow_subdomains`, `prod_allow_disk_space_mb`, `prod_allow_traffic_mb`, `prod_allow_mailboxes`, `prod_allow_databases`, `prod_cg_01`, `prod_cg_02`, `prod_cg_03`, `prod_cg_04`, `prod_cg_05`, `prod_cg_06`, `prod_cg_07`, `prod_cg_08`) VALUES (1, 1, 'ID-0001', 'Sample Product 01', '19.95', 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (2, 1, 'ID-0002', 'Sample Product 02', '29.95', 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); # -------------------------------------------------------- # # Table structure for table `phpcoin_server_info` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_server_info`; CREATE TABLE `phpcoin_server_info` ( `si_id` smallint(6) NOT NULL auto_increment, `si_name` varchar(20) NOT NULL default '', `si_ip` varchar(15) NOT NULL default '000.000.000.000', `si_ns_01` varchar(50) NOT NULL default '', `si_ns_01_ip` varchar(15) NOT NULL default '000.000.000.000', `si_ns_02` varchar(50) NOT NULL default '', `si_ns_02_ip` varchar(15) NOT NULL default '000.000.000.000', `si_cp_url` varchar(50) NOT NULL default '', `si_cp_url_port` int(11) NOT NULL default '0', PRIMARY KEY (`si_id`) ) TYPE=MyISAM COMMENT='Site Server Info Table' AUTO_INCREMENT=3 ; # # Dumping data for table `phpcoin_server_info` # INSERT INTO `phpcoin_server_info` (`si_id`, `si_name`, `si_ip`, `si_ns_01`, `si_ns_01_ip`, `si_ns_02`, `si_ns_02_ip`, `si_cp_url`, `si_cp_url_port`) VALUES (1, 'Alpha', '216.118.66.244', 'NS1.NAMESERVER.COM', '000.000.000.000', 'NS2.NAMESERVER.COM', '000.000.000.000', 'https://www.server.com:8443/login.php3', 8443), (2, 'Beta', '216.118.66.245', 'NS1.NAMESERVER.COM', '000.000.000.000', 'NS2.NAMESERVER.COM', '000.000.000.000', 'https://www.server.com:8443/login.php3', 8443); # -------------------------------------------------------- # # Table structure for table `phpcoin_sessions` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_sessions`; CREATE TABLE `phpcoin_sessions` ( `s_id` varchar(36) NOT NULL default '', `s_time_init` int(11) NOT NULL default '0', `s_time_last` int(11) NOT NULL default '0', `s_ip` varchar(16) NOT NULL default '000.000.000.000', `s_is_admin` tinyint(1) NOT NULL default '0', `s_is_user` tinyint(1) NOT NULL default '0', `s_time_last_contact` int(11) NOT NULL default '0', `s_time_last_order` int(11) NOT NULL default '0', PRIMARY KEY (`s_id`) ) TYPE=MyISAM COMMENT='Site Sessions Table'; # # Dumping data for table `phpcoin_sessions` # # -------------------------------------------------------- # # Table structure for table `phpcoin_site_info` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_site_info`; CREATE TABLE `phpcoin_site_info` ( `si_id` int(11) NOT NULL auto_increment, `si_group` varchar(32) default NULL, `si_name` varchar(32) default NULL, `si_seq_no` int(11) default NULL, `si_desc` varchar(50) default NULL, `si_block_it` tinyint(1) NOT NULL default '0', `si_title` varchar(50) default NULL, `si_code` longtext, `si_status` tinyint(1) NOT NULL default '0', `si_footer_menu` tinyint(1) NOT NULL default '1', PRIMARY KEY (`si_id`) ) TYPE=MyISAM COMMENT='Site SiteInfo Table' AUTO_INCREMENT=10 ; # # Dumping data for table `phpcoin_site_info` # INSERT INTO `phpcoin_site_info` (`si_id`, `si_group`, `si_name`, `si_seq_no`, `si_desc`, `si_block_it`, `si_title`, `si_code`, `si_status`, `si_footer_menu`) VALUES (1, 'site', 'index', 0, 'Index Block HTML code.', 1, 'Welcome', '

\r\nWelcome to your phpCOIN install at $_CCFG[_PKG_NAME_SHORT].\r\n

\r\nInstallation should be completed, be sure to read all associated docs. \r\n

\r\nThank you for trying out phpCOIN.\r\n

\r\nA Dream\r\n

\r\n
\r\n\r\n', 1, 1), (2, 'site', 'greeting', 0, 'Site greeting html code. Placed on index page', 1, 'Site Greeting', 'For a site greeting?', 0, 1), (3, 'site', 'announce', 0, 'For Top billing announcement on index page.', 1, 'Announcement', 'For a site announcment?', 0, 1), (4, 'site', 'about', 0, 'About this site info page.', 1, 'About This Site', '\r\n

This is where you tell them about $_CCFG[_PKG_NAME_SHORT].\r\n

\r\n

', 1, 1), (5, 'site', 'policy_privacy', 0, 'Privacy Policy', 1, 'Privacy Policy', '

$_CCFG[_PKG_NAME_SHORT] is committed to the privacy of our clients. ...... typical Privacy Polic policy page.
...... typical Acceptable Use Policy policy page.

\r\n', 1, 1), (7, 'site', 'policy_terms_of_service', 0, 'Terms Of Service', 1, 'Terms Of Service', '

When using the Service provided by $_CCFG[_PKG_NAME_SHORT], ...... typical Terms Of Service policy page.
', 1, 1), (8, 'site', 'policy_banned_code', 0, 'Banned Code', 1, 'Banned Code', '

...... typical Banned Code policy page.

\r\n', 1, 1), (9, 'site', 'dream', 0, 'A Kind Of Dream', 0, 'A Kind Of Dream', '\r\n

\r\n

\r\n

We can walk our road together
\r\n If our goals are all the same.
\r\n We can run alone and free
\r\n If we pursue a different aim.
\r\n Let the Truth of Love be lighted,
\r\n Let the Love of Truth shine clear. Sensibility,
\r\n Armed with sense and liberty,
\r\n With the Heart and Mind united in a single
\r\n Perfect
\r\n Sphere.

\r\n

The Sphere: A Kind of Dream (Rush: Hemispheres)

\r\n

\r\n\r\n', 1, 1); # -------------------------------------------------------- # # Table structure for table `phpcoin_topics` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_topics`; CREATE TABLE `phpcoin_topics` ( `topic_id` mediumint(9) NOT NULL auto_increment, `topic_pos` smallint(6) NOT NULL default '0', `topic_name` varchar(50) NOT NULL default '', `topic_desc` varchar(50) NOT NULL default '', `topic_icon` smallint(6) NOT NULL default '1', PRIMARY KEY (`topic_id`) ) TYPE=MyISAM COMMENT='Site Topics Table' AUTO_INCREMENT=5 ; # # Dumping data for table `phpcoin_topics` # INSERT INTO `phpcoin_topics` (`topic_id`, `topic_pos`, `topic_name`, `topic_desc`, `topic_icon`) VALUES (1, 0, 'General', 'General / Default Topic', 1), (2, 0, 'Announcements', 'For Announcements', 1), (3, 0, 'Documentation', 'For Documentation', 1), (4, 0, 'News', 'For News', 1); # -------------------------------------------------------- # # Table structure for table `phpcoin_vendors` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_vendors`; CREATE TABLE `phpcoin_vendors` ( `vendor_id` smallint(6) NOT NULL auto_increment, `vendor_status` tinyint(1) NOT NULL default '0', `vendor_name` varchar(20) NOT NULL default '', `vendor_buy_parm` varchar(30) NOT NULL default 'buy', `vendor_buy_parm_val` varchar(10) NOT NULL default '1', `vendor_url` varchar(50) NOT NULL default '', `vendor_notes` text NOT NULL, PRIMARY KEY (`vendor_id`) ) TYPE=MyISAM COMMENT='Site Vendors Table' AUTO_INCREMENT=3 ; # # Dumping data for table `phpcoin_vendors` # INSERT INTO `phpcoin_vendors` (`vendor_id`, `vendor_status`, `vendor_name`, `vendor_buy_parm`, `vendor_buy_parm_val`, `vendor_url`, `vendor_notes`) VALUES (1, 1, 'Paypal', 'buy', '1', 'http://www.paypal.com', 'Note- requires client to have a PayPal account.'), (2, 1, 'Credit Card', 'credit_card_processed', 'Y', 'http://www.2checkout.com', 'Note- fixed product id for price.'); # -------------------------------------------------------- # # Table structure for table `phpcoin_vendors_prods` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_vendors_prods`; CREATE TABLE `phpcoin_vendors_prods` ( `vprod_id` smallint(6) NOT NULL auto_increment, `vprod_vendor_id` smallint(6) NOT NULL default '0', `vprod_prod_id` smallint(6) NOT NULL default '0', `vprod_desc` varchar(50) NOT NULL default '', `vprod_order_link` text NOT NULL, PRIMARY KEY (`vprod_id`) ) TYPE=MyISAM COMMENT='Site Vendor Products Table' AUTO_INCREMENT=5 ; # # Dumping data for table `phpcoin_vendors_prods` # INSERT INTO `phpcoin_vendors_prods` (`vprod_id`, `vprod_vendor_id`, `vprod_prod_id`, `vprod_desc`, `vprod_order_link`) VALUES (1, 1, 1, 'Paypal- Buy Product 1', '

This is for the "pay link" html provided by your third party billing people.\r\n'), (2, 2, 1, '2Checkout- Buy Product 1', '

This is for the "pay link" html provided by your third party billing people.\r\n'), (3, 1, 2, 'Paypal- Buy Product 2', '

This is for the "pay link" html provided by your third party billing people.\r\n'), (4, 2, 2, '2Checkout- Buy Product 2', '

This is for the "pay link" html provided by your third party billing people.\r\n'); # -------------------------------------------------------- # # Table structure for table `phpcoin_versions` # # Creation: Jan 03, 2004 at 02:39 PM # Last update: Jan 03, 2004 at 02:39 PM # DROP TABLE IF EXISTS `phpcoin_versions`; CREATE TABLE `phpcoin_versions` ( `v_id` smallint(6) NOT NULL auto_increment, `v_ts` varchar(10) NOT NULL default '', `v_ver` varchar(8) NOT NULL default '', `v_type` varchar(10) NOT NULL default 'install', PRIMARY KEY (`v_id`) ) TYPE=MyISAM COMMENT='Package Versions Table' AUTO_INCREMENT=2 ; # # Dumping data for table `phpcoin_versions` # INSERT INTO `phpcoin_versions` (`v_id`, `v_ts`, `v_ver`, `v_type`) VALUES (1, '1073158772', 'V1.2.0', 'Install');