Jump to content

toyzonline

Members
  • Content count

    450
  • Joined

  • Last visited

Everything posted by toyzonline

  1. Just gone through this installation again and again I am simply getting a blank page when clicking on product attributes. I had uninstalled as per no support when I last asked about this, but really need this add on
  2. toyzonline

    [Addon} Modular Front Page

    No not moved anything just added the this add-on and then installed the front page. The error I am getting now appeared without any changes being made after I got the first error due to the apostrophes in the front page module text area. Hoping I can get this sorted as the front page is something I have been looking for. I am a bit confused that after restoring the DB that the error is still there. I am thinking that maybe I should remove all the added files, restore the DB and then re-install?
  3. toyzonline

    [Addon} Modular Front Page

    I had only removed the value. I have now removed all the like MODULE_FRONT_PAGE_%, but nothing has changed. I have even restored the database and still have the same situation.....a little confused to say the least...lol Ricardo
  4. toyzonline

    [Addon} Modular Front Page

    Right got access back to the database and there was indeed apostrophes in the text. I now removed the key value. However I am still getting the following error when I click on the front page module
  5. toyzonline

    [Addon} Modular Front Page

    Thanks Jim, not far from what I thought and after double checking the DB name just realised its not listed as a choice in myphpadmin (which could also answer all the failed connection errors I keeo getting). Just waiting on support now. Thanks Again
  6. toyzonline

    [Addon} Modular Front Page

    Jim, Sorry to be a complete pain in the ass, I did think I was getting used to finding my way around the files and structure.....lol Would you be able to give a little instruction how to complete your suggestion fix. I have cpanel and believe that the tool I should be using is phpmyadmin but had a look round and not afraid to admit it likes find needle in a haystack (guess I not used to looking around MySQL). Much appreciate for your help whether you can or cant Ricardo
  7. toyzonline

    [Addon} Modular Front Page

    Think best option for me is to restore database and files to before the front page module as cant find anything like that using my hosts only DB tool (phpmyadmin)
  8. toyzonline

    [Addon} Modular Front Page

    oh....lol sorry my bad....still a problem as since saving the text I cannot get in to edit (as per posted error) it was showing the order preference and true or false but not the text area.....And now getting the line 17 error (as above) when I click on the front page module link, which is just a blank page with the error?
  9. toyzonline

    [Addon} Modular Front Page

    Sorry Jim I probably blind but cant seem to find the out of place character, also despite not changing anything now getting <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2013 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); $set = (isset($HTTP_GET_VARS['set']) ? $HTTP_GET_VARS['set'] : ''); $modules = $cfgModules->getAll(); if (empty($set) || !$cfgModules->exists($set)) { $set = $modules[0]['code']; } $module_type = $cfgModules->get($set, 'code'); $module_directory = $cfgModules->get($set, 'directory'); $module_language_directory = $cfgModules->get($set, 'language_directory'); $module_key = $cfgModules->get($set, 'key');; define('HEADING_TITLE', $cfgModules->get($set, 'title')); $template_integration = $cfgModules->get($set, 'template_integration'); $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');
  10. toyzonline

    [Addon} Modular Front Page

    The above is sorted as simply moved the added code with the index file. However added some basic text saved it to look at the published page, and looks ok, so went to go back in it to edit and format it but get the following when I click on the Front Page link on the modules menu
  11. toyzonline

    [Addon} Modular Front Page

    Install seems to have gone well but when using the text main it creates a bit of a format issue: 1) Installed text main module 2) commented out the new products in index.php All fine up to now. However when I edit the text area the given text is published at the same level as the social boomarks, instead of above them? Have attached an image to visually explain.
  12. Was wondering if there was anybody that could spare a little time helping me reformat my product info page. The page currently consists of extra images, header tags SEO and Extra Fields Add-Ons. As it stands the page seems to format its self any which way it likes (literally different for different products, usually determined by the amount of images). This is how it currently stands http://www.raunchyrags.co.uk/shop/function-pinks-p-29.html (not suitable for work) The way I would like to have it, is to have the product description above the extra fields information (and in a slightly larger font helping separate all the information on the page. Then instead of the product options(attributes) below the extra fields it would be good if the could be alongside (like 2 table cells), thus making the page less in length. Sorry if this asking too much and thanks for taking the time to read Cheers Ricardo
  13. I am looking to replace the listing of products on the index.php with a good formatted introduction. Obviously I can change (and have already) the default text. However formatting within php are not really my thing. I have completed a site: search in google but have not found anything too relevant and obviously just creating a new .php file and calling it index.php creates linking problems etc. Are there any shortcuts or add-ons that I have not been able to find? Cheers Ricardo
  14. toyzonline

    Need Help Re-Formating Product Info Page

    obviously don't want someone to do it for me, just to possibly tag the code I should not touch and comment separate sections of code that relate to certain areas....I did consider coughing up for a designer but if I do that: a) I ain't never gonna learn b) Looking like I gonna have to cough up for a mobile version of the site with google new plans Cheers for looking any way chaps. As always ant input is always very much appreciated. Ricardo
  15. toyzonline

    Header Tags SEO

    Ok Jack I think it is time for you to either laugh at me or block me......... Just thinking about it and like I said I was using the sub text field to place a text image at the bottom of the page......but it was putting it twice at the bottom of the page, from the code below (which has been fixed) how would I get the second instance of the text back but at the top of the product info page above the product title? Also despite trying standard <center>, span alignment & <p> alignment I cant get the text centralised without the entire page going scew-wiff (if they are are words). Cheers & Sorry To Be A Pain Ricardo
  16. toyzonline

    Need Help Re-Formating Product Info Page

    My code as it stands <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2014 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); if (!isset($HTTP_GET_VARS['products_id'])) { tep_redirect(tep_href_link(FILENAME_DEFAULT)); } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO); $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_check = tep_db_fetch_array($product_check_query); require(DIR_WS_INCLUDES . 'template_top.php'); /*** Begin Header Tags SEO ***/ echo "<a name=\"\$header_tags_array['title']\"></a>"; /*** End Header Tags SEO ***/ if ($product_check['total'] < 1) { ?> <div class="contentContainer"> <div class="contentText"> <?php echo TEXT_PRODUCT_NOT_FOUND; ?> </div> <div style="float: right;"> <?php echo tep_draw_button(IMAGE_BUTTON_CONTINUE, 'triangle-1-e', tep_href_link(FILENAME_DEFAULT)); ?> </div> </div> <?php } else { /*** Begin Header Tags SEO ***/ $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, pd.products_head_sub_text from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); $product_info['products_name'] = $header_tags_array['title_alt']; /*** End Header Tags SEO ***/ tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $products_price = '<del>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</del> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name'] . '<br /><span class="smallText">[' . $product_info['products_model'] . ']</span>'; } else { $products_name = $product_info['products_name']; } ?> <?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?> <div> <h1 style="float: right;"><?php echo $products_price; ?></h1> <h1><?php echo $products_name; ?></h1> </div> <div class="contentContainer"> <div class="contentText"> <?php if (tep_not_null($product_info['products_image'])) { $photoset_layout = '1'; $pi_query = tep_db_query("select image, htmlcontent from " . TABLE_PRODUCTS_IMAGES . " where products_id = '" . (int)$product_info['products_id'] . "' order by sort_order"); $pi_total = tep_db_num_rows($pi_query); if ($pi_total > 0) { $pi_sub = $pi_total-1; while ($pi_sub > 5) { $photoset_layout .= 5; $pi_sub = $pi_sub-5; } if ($pi_sub > 0) { $photoset_layout .= ($pi_total > 5) ? 5 : $pi_sub; } ?> <div id="piGal"> <?php $pi_counter = 0; $pi_html = array(); while ($pi = tep_db_fetch_array($pi_query)) { $pi_counter++; if (tep_not_null($pi['htmlcontent'])) { $pi_html[] = '<div id="piGalDiv_' . $pi_counter . '">' . $pi['htmlcontent'] . '</div>'; } echo tep_image(DIR_WS_IMAGES . $pi['image'], '', '', '', 'id="piGalImg_' . $pi_counter . '"'); } ?> </div> <?php // START: Extra Fields Contribution v2.0b - mintpeel display fix $extra_fields_query = tep_db_query(" SELECT pef.products_extra_fields_order, pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=". (int)$HTTP_GET_VARS['products_id'] ." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".(int)$languages_id."') ORDER BY pef.products_extra_fields_order"); echo '<tr> <td> <table border="0" width="50%" cellspacing="0" cellpadding="2px">'; while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { if (! $extra_fields['status']) // show only enabled extra field continue; echo'<tr><td class="main" align="left" valign="middle"><font size="1" color="#666666"><b>'.$extra_fields['name'].': </b>' . stripslashes($extra_fields['value']).'</font></td></tr>'; } echo' </table> </td> </tr>'; // END: Extra Fields Contribution - mintpeel display fix ?> <?php if ( !empty($pi_html) ) { echo ' <div style="display: none;">' . implode('', $pi_html) . '</div>'; } } else { ?> <div id="piGal"> <?php echo tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name'])); ?> </div> <?php } } ?> <script type="text/javascript"> $(function() { $('#piGal').css({ 'visibility': 'hidden' }); $('#piGal').photosetGrid({ layout: '<?php echo $photoset_layout; ?>', width: '250px', highresLinks: true, rel: 'pigallery', onComplete: function() { $('#piGal').css({ 'visibility': 'visible'}); $('#piGal a').colorbox({ maxHeight: '90%', maxWidth: '90%', rel: 'pigallery' }); $('#piGal img').each(function() { var imgid = $(this).attr('id').substring(9); if ( $('#piGalDiv_' + imgid).length ) { $(this).parent().colorbox({ inline: true, href: "#piGalDiv_" + imgid }); } }); } }); }); </script> <?php /*** Begin Header Tags SEO ***/ ?> <?php echo HTS_Highlight(stripslashes($product_info['products_description']), $header_tags_array['keywords']); ?> <?php /*** End Header Tags SEO ***/ ?> <?php $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { ?> <p><?php echo TEXT_PRODUCT_OPTIONS; ?></p> <p> <?php $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { $products_options_array = array(); $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); while ($products_options = tep_db_fetch_array($products_options_query)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } if (is_string($HTTP_GET_VARS['products_id']) && isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } ?> <strong><?php echo $products_options_name['products_options_name'] . ':'; ?></strong><br /><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?><br /> <?php } ?> </p> <?php } ?> <div style="clear: both;"></div> <?php if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) { ?> <p style="text-align: center;"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></p> <?php } ?> </div> <?php $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "' and reviews_status = 1"); $reviews = tep_db_fetch_array($reviews_query); ?> <?php if ($product_info['products_quantity'] == 0 ) echo '<font color="red"><b><i><u>This item is currently out of stock, but can be backordered.</i></u></b></font>'; ?> <div class="buttonSet"> <span class="buttonAction"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_draw_button(IMAGE_BUTTON_IN_CART, 'cart', null, 'primary'); ?></span> <?php echo tep_draw_button(IMAGE_BUTTON_REVIEWS . (($reviews['count'] > 0) ? ' (' . $reviews['count'] . ')' : ''), 'comment', tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params())); ?> </div> <!--- BEGIN Header Tags SEO SUB TEXT --> <?php ?> <!--- END Header Tags SUB TEXT --> <?php if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_also_purchased(3600); } else { include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS); } ?> <?php /*** Begin Header Tags SEO ***/ if (tep_not_null($product_info['products_head_sub_text'])) { echo '<div class="hts_sub_text" style="padding:10px 0;">' . $product_info['products_head_sub_text'] . '</div>'; } if (HEADER_TAGS_DISPLAY_CURRENTLY_VIEWING == 'true') { echo '<div id="hts_viewing">' .TEXT_VIEWING; $header_tags_array['title'] = (tep_not_null($header_tags_array['title']) ? $header_tags_array['title'] : $product_info['products_name']); echo '<a title="' . $header_tags_array['title'] . '" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_info['products_id'], 'NONSSL') . '"/# ' . $header_tags_array['title'] . '">' . $header_tags_array['title'] . '</a>'; echo '</div>'; } if (HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS == 'true') { echo '<div style="float:right; margin-top:5px; margin-right:4px;">'; include(DIR_WS_MODULES . 'header_tags_social_bookmarks.php'); echo '</div>'; } /*** End Header Tags SEO ***/ ?> </div> </form> <?php } require(DIR_WS_INCLUDES . 'template_bottom.php'); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  17. toyzonline

    Header Tags SEO

    I have checked the product_info.php and found that code 4 times in total but only as per the install instructions: So mine reads: <!--- BEGIN Header Tags SEO SUB TEXT --> <?php if (tep_not_null($product_info['products_head_sub_text'])) { echo '<div class="contentText" style="margin-top:5px;">' . $product_info['products_head_sub_text'] . '</div>'; } ?> <!--- END Header Tags SUB TEXT --> <?php if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_also_purchased(3600); } else { include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS); } ?> <?php /*** Begin Header Tags SEO ***/ if (tep_not_null($product_info['products_head_sub_text'])) { echo '<div class="hts_sub_text" style="padding:10px 0;">' . $product_info['products_head_sub_text'] . '</div>'; } if (HEADER_TAGS_DISPLAY_CURRENTLY_VIEWING == 'true') { echo '<div id="hts_viewing">' .TEXT_VIEWING; $header_tags_array['title'] = (tep_not_null($header_tags_array['title']) ? $header_tags_array['title'] : $product_info['products_name']); echo '<a title="' . $header_tags_array['title'] . '" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_info['products_id'], 'NONSSL') . '"/# ' . $header_tags_array['title'] . '">' . $header_tags_array['title'] . '</a>'; echo '</div>'; } if (HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS == 'true') { echo '<div style="float:right; margin-top:5px; margin-right:4px;">'; include(DIR_WS_MODULES . 'header_tags_social_bookmarks.php'); echo '</div>'; } /*** End Header Tags SEO ***/
  18. toyzonline

    Header Tags SEO

    So after having this add-on installed for a while and finally deciding to make full use of it I have just realised something: When we enter something into the 'Product Page Sub Text' field it actually appears twice on the bottom of the products page. Is this meant to happen? I only ask as we were going to utilise this field to promote our newsletter for example: http://www.raunchyrags.co.uk/shop/function-pinks-p-29.html (not safe for work) Which if this is an error as we believe leads to the next issue: Are we able to format this text as standard or re we best just sticking to using an HTML input into the text field of the add-on? Cheers Amigos :thumbsup: (he says trying to speak cool today...lol)
  19. toyzonline

    Newsletters & Subscribers OSC 2.3

    I am getting a very large gap between the newsletter header and the main content. Has anyone else experienced this?
  20. I have looked at this add_on as it is what I need and having trouble with an alternative. However when I tried this one it asks for a change to be made in /admin/includes/column_left.php However the code it states to replace is not in this file: I am using osCommerce Online Merchant v2.3.4
  21. toyzonline

    Newsletters & Subscribers OSC 2.3

    Forgot to add SQL code incase any one who doesn't use this addon has any idea # # Base for Newsletters v.50+ # # -------------------------------------------------------- # # Table structure for table `subscribers` # CREATE TABLE `subscribers` ( `subscribers_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `subscribers_email_address` varchar(80) NOT NULL default '', `subscribers_firstname` varchar(40) default NULL, `subscribers_lastname` varchar(40) default NULL, `language` varchar(30) default NULL, `subscribers_gender` char(1) default NULL, `subscribers_email_type` varchar(5) default NULL, `entry_date` date default '0000-00-00', `undeliverable_count` mediumint(11) default '0', `mail_details_customers_id` int(5) default '0', `list_number` int(5) default '0', `source_import` varchar(70) default NULL, `date_account_created` datetime default '0000-00-00 00:00:00', `date_account_last_modified` datetime default '0000-00-00 00:00:00', `customers_newsletter` int(4) default NULL, `subscribers_blacklist` int(2) default '0', `subscription_date` datetime default '0000-00-00 00:00:00', `status_sent1` int(2) default '0', `host_name` varchar(25) default NULL, `hardiness_zone` char(3) default NULL, PRIMARY KEY (`subscribers_id`), KEY `list_number` (`list_number`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # -------------------------------------------------------- # # Table structure for table `subscribers_default` # CREATE TABLE `subscribers_default` ( `news_id` int(11) NOT NULL auto_increment, `module_subscribers` varchar(255) NOT NULL default '', `header` text NOT NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `status` tinyint(1) NOT NULL default '0', `news_order` int(2) NOT NULL default '0', `unsubscribea` longtext NOT NULL, `unsubscribeb` longtext NOT NULL, PRIMARY KEY (`news_id`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; # # Dumping data for table `subscribers_default` # INSERT INTO `subscribers_default` VALUES (1, 'Module newsletter_subscribers', '', '2002-11-28 09:31:06', 1, 0, 'You can unsubscribe from our newsletter here :', ''); INSERT INTO `subscribers_default` VALUES (2, 'Module newsletter', '', '2005-01-04 03:51:20', 1, 0, '<DIV>You can unsubscribe from our newsletter here :</DIV>', '<DIV>Thank you</DIV>'); INSERT INTO `subscribers_default` VALUES (3, 'Module product_notification', '', '2005-01-04 03:53:10', 1, 0, '<DIV>To unsubscribe please click the following: </DIV>', ''); # -------------------------------------------------------- # # Table structure for table `subscribers_infos` # CREATE TABLE `subscribers_infos` ( `news_id` int(11) NOT NULL auto_increment, `newsletters_id` int(11) NOT NULL default '0', `module_subscribers` varchar(255) NOT NULL default '', `header` text NOT NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `status` tinyint(1) NOT NULL default '0', `news_order` int(2) NOT NULL default '0', `unsubscribea` longtext NOT NULL, `unsubscribeb` longtext NOT NULL, PRIMARY KEY (`news_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `subscribers_infos` # # -------------------------------------------------------- # # Table structure for table `subscribers_update` # CREATE TABLE `subscribers_update` ( `newsletters_id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `content` text NOT NULL, `module` varchar(255) NOT NULL default '', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `date_sent` datetime default NULL, `status` int(1) default NULL, `locked` int(1) default '0', `action` text NOT NULL, `set_order` int(2) NOT NULL default '0', PRIMARY KEY (`newsletters_id`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; # # Dumping data for table `subscribers_update` # INSERT INTO `subscribers_update` VALUES (1, 'Update of the table of the Subscribers', 'Compare the table of the Members recorded on the site and the table of the anonymities having subscribed to the newsletter.', 'newsletter', '2002-11-27 15:13:25', '2002-11-27 15:13:25', 1, 1, 'update', 1); INSERT INTO `subscribers_update` VALUES (2, 'Update of the Names and First names', 'To update the whole of the data concerning the name and the first name modified by Customer Records', '', '2002-11-29 14:42:20', '2002-11-29 14:42:20', 1, 1, 'update', 2); # # Bulkmailer with interval # CREATE TABLE `customers_temp` ( `customers_id` int(11) NOT NULL auto_increment, `customers_firstname` varchar(32) NOT NULL default '', `customers_lastname` varchar(32) NOT NULL default '', `customers_email_address` varchar(96) NOT NULL default '', `subscribers_firstname` varchar(32) NOT NULL default '', `subscribers_lastname` varchar(32) NOT NULL default '', `subscribers_email_address` varchar(96) NOT NULL default '', PRIMARY KEY (`customers_id`) ) TYPE=MyISAM ; INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ( '', 'Bulk Mailer Limit', 'BULKMAILER_LIMIT', '5', 'Defines how many e-mails will be sent at a time', '3', '20', NULL , NOW( ) , NULL , NULL ); INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ( '', 'Bulk Mailer Interval [seconden]', 'BULKMAILER_INTERVAL', '12', 'Defines time between each bulk e-mails send', '3', '20', NULL , NOW( ) , NULL , NULL );
×