Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

jps001

Pioneers
  • Posts

    44
  • Joined

  • Last visited

Posts posted by jps001

  1. Hello,

     

    I have a error log problem and one of the main problems is this

    PHP Notice: Undefined variable: filename in /var/www/vhosts/***/product_thumb.php on line 276

    PHP Notice: Undefined variable: filename in /var/www/vhosts/***/product_thumb.php on line 327

     

    The lines 276 and 327 are:

    276 if (file_exists($filename) && $tn_server_cache && filemtime($filename) > filemtime($_GET['img'])
    327 $tmp_path = str_replace(basename($filename), '', $filename);
    

     

    Both for cache and someone told me a few weeks ago the generated thumbnail whas not recalled even when it whas a old image that was looked up a lot more times.

     

    Please help me out

     

    Regards,

     

    jasper

  2. Hello Again,

     

    I got some progress.

    Now on alternate method is dont have the http 500 error but i can new see some errors

    ERROR: Google Product Sitemap Generation FAILED!
    ERROR: Google Category Sitemap Generation FAILED!
    Opening /sitemapindex.xmlFS_CAT /var/www/vhosts/jps-autosport.nl/httpdocs/webshop/Server http://www.jps-autosport.nlSave Path /WS_CAT /webshop/ ERROR: Google Sitemap Index Generation FAILED!
    Array
    (
    [QUERY] => Array
    (
    [PRODUCTS] => Array
    (
    [sTATUS] => success
    [NUM_ROWS] => 30330
    )
    [CATEOGRY] => Array
    (
    [sTATUS] => success
    [NUM_ROWS] => 25413
    )
    )
    [sAVE_FILE_COMPRESS] => Array
    (
    [0] => Array
    (
    [file] => /sitemapproducts.xml.gz
    [status] => failure
    [file_exists] => false
    )
    [1] => Array
    (
    [file] => /sitemapcategories.xml.gz
    [status] => failure
    [file_exists] => false
    )
    )
    [sAVE_FILE_XML] => Array
    (
    [0] => Array
    (
    [file] => /sitemapindex.xml
    [status] => failure
    [file_exists] => false
    )
    )
    )
    
    

     

    Can someone help me out i dont know what to do.

    I placed all files under /webshop/ but the error is [file_exists] => false

    Now i made a copy and placed it in my root instead of /webshop/ but the error is the same.

     

    Greets,

     

    Jasper

  3. Hello,

     

    I use specials maintance for the first time now but when adding a product is says "Special Product Limit quantity 0 must be less than Product quantity 0!!"

    I dont use the quantity in OSCommerce but how can i turn off checking for it?

    It would be nice to sell a product only say 5 times for special price and then the normal price.

    That way i can say "For first 5 costumers jus 75€ instead of 99€" but i can't use the product quantity in oscommerce because not all is in stock and special orderd stuff..

     

    Can jou help?

     

    Jasper

  4. Hello.

     

    i moved the website to another server but now the sitemap will not be made anymore.

    I deleted all sitemaps and the map googlesitemap and uploaded a fresh one from the addons section but even then nothing.

     

    when i enter my.domain/googlesitemap/index.php it takes about 2 minuts and the i get a http 500 error.

    whit the alternate class he wont also work.

    and because of the http 500 diagnostic is not showing too in standard

    when i use alternate is shows this

    Opening   /sitemapproducts.xml
    FS_CAT    /var/www/vhosts/jps-autosport.nl/httpdocs/webshop/
    Server    http://www.jps-autosport.nl
    Save Path /
    WS_CAT    /webshop/ 
    ERROR: Google Product Sitemap Generation FAILED!
    
    Opening   /sitemapcategories.xml
    FS_CAT    /var/www/vhosts/jps-autosport.nl/httpdocs/webshop/
    Server    http://www.jps-autosport.nl
    Save Path /
    WS_CAT    /webshop/ 
    ERROR: Google Category Sitemap Generation FAILED!
    
    Opening   /sitemapmanufacturers.xml
    FS_CAT    /var/www/vhosts/jps-autosport.nl/httpdocs/webshop/
    Server    http://www.jps-autosport.nl
    Save Path /
    WS_CAT    /webshop/ 
    ERROR: Google Manufacturers Sitemap Generation FAILED!
    
    Opening   /sitemapspecials.xml
    FS_CAT    /var/www/vhosts/jps-autosport.nl/httpdocs/webshop/
    Server    http://www.jps-autosport.nl
    Save Path /
    WS_CAT    /webshop/ 
    ERROR: Google Specials Sitemap Generation FAILED!
    
    Opening   /sitemappages.xml
    FS_CAT    /var/www/vhosts/jps-autosport.nl/httpdocs/webshop/
    Server    http://www.jps-autosport.nl
    Save Path /
    WS_CAT    /webshop/ 
    ERROR: Google Pages Sitemap Generation FAILED!
    
    Opening   /sitemapindex.xml
    FS_CAT    /var/www/vhosts/jps-autosport.nl/httpdocs/webshop/
    Server    http://www.jps-autosport.nl
    Save Path /
    WS_CAT    /webshop/ 
    ERROR: Google Sitemap Index Generation FAILED!
    
    Array
    (
       [QUERY] => Array
           (
               [PRODUCTS] => Array
                   (
                       [sTATUS] => success
                       [NUM_ROWS] => 24648
                   )
    
               [CATEOGRY] => Array
                   (
                       [sTATUS] => success
                       [NUM_ROWS] => 25412
                   )
    
               [MANUFACTURERS] => Array
                   (
                       [sTATUS] => success
                       [NUM_ROWS] => 29
                   )
    
               [sPECIALS] => Array
                   (
                       [sTATUS] => success
                       [NUM_ROWS] => 1159
                   )
    
           )
    
       [sAVE_FILE_XML] => Array
           (
               [0] => Array
                   (
                       [file] => /sitemapproducts.xml
                       [status] => failure
                       [file_exists] => false
                   )
    
               [1] => Array
                   (
                       [file] => /sitemapcategories.xml
                       [status] => failure
                       [file_exists] => false
                   )
    
               [2] => Array
                   (
                       [file] => /sitemapmanufacturers.xml
                       [status] => failure
                       [file_exists] => false
                   )
    
               [3] => Array
                   (
                       [file] => /sitemapspecials.xml
                       [status] => failure
                       [file_exists] => false
                   )
    
               [4] => Array
                   (
                       [file] => /sitemappages.xml
                       [status] => failure
                       [file_exists] => false
                   )
    
               [5] => Array
                   (
                       [file] => /sitemapindex.xml
                       [status] => failure
                       [file_exists] => false
                   )
    
           )
    
    )

     

    i set all .xml to 777 and even tryed googlesitemap/ to set 777

     

    can someone help me out?

  5. I have a problem after generating the sitmap for products.

     

    I have one empty line in the sitmap and now google thinks it is an bad sitemap.

     

    I think one of the SEO url's has a bad sign in the name but i cant find out wich one.

     

    Is the sitemap making the file random or can i find out by line numer (654) witch URL has the bad name?

     

    In the sitemap i looks like this

    	<url>
    	<loc></loc>
    	<lastmod>2011-04-04</lastmod>
    	<changefreq>weekly</changefreq>
    	<priority>0.1</priority>
    </url> 

    loc /loc is empty an should be filled wiht a SEO URL.

    There is only one empty loc /loc from all 25.000

     

    Can some one help me out?

     

    Jasper

  6. The above problem is solved bij putting the admin inside the catalog folder again.

     

    But now the next problem.

     

    when clicking generate... button

    the following message whas givven when running

     

    cycle: 21
    
    products array built
    products attributes array built
    feed generation in process...
    
    Warning:  implode() [function.implode]: Invalid arguments passed in /home/auto/public_html/webshop/admin/feedmachine.php on line 71
    
    Warning:  implode() [function.implode]: Invalid arguments passed in /home/auto/public_html/webshop/admin/feedmachine.php on line 71
    
    Warning:  implode() [function.implode]: Invalid arguments passed in /home/auto/public_html/webshop/admin/feedmachine.php on line 71
    
    Warning:  implode() [function.implode]: Invalid arguments passed in /home/auto/public_html/webshop/admin/feedmachine.php on line 71
    

     

    Line 71 is about the catagories

     

    Can some one help me out with this problem?

     

    Regards,

     

    Jasper

  7. Hi,

     

    I have a problem running this contri,

     

    Warning: require(includes/configure.php) [function.require]: failed to open stream: No such file or directory in /home/auto/public_html/****shop***/***_admin_***/includes/application_top.php on line 32
    
    Warning: require(includes/configure.php) [function.require]: failed to open stream: No such file or directory in /home/auto/public_html/****shop***/***_admin_***/includes/application_top.php on line 32
    
    Fatal error: require() [function.require]: Failed opening required 'includes/configure.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/auto/public_html/****shop***/***_admin_***/includes/application_top.php on line 32
    
    

     

    Can someone help me out?

     

    Regards,

     

    jasper

  8. Here

     

    edit includes/application_top

     

    // navigation history

    if (tep_session_is_registered('navigation')) {

    if (PHP_VERSION < 4) {

    $broken_navigation = $navigation;

    $navigation = new navigationHistory;

    $navigation->unserialize($broken_navigation);

    } elseif (!is_object($navigation)) {

    $navigation = new navigationHistory;

    }

    } else {

    tep_session_register('navigation');

    $navigation = new navigationHistory;

    }

    $navigation->add_current_page();

     

    Source http://www.oscommerce.com/forums/topic/237743-login-redirect-to-index-instead-of-previous-page/page__st__20

  9. Hello,

     

    Yes i run it once before.

     

    Can the problem be in this part:

    				// early check to avoid processing when email was already sent
    			$chk_result = $mb_chk->check($this->module, $this->iteration, $item['subscribers_id']);
    			if ($chk_result != false) {
    				// this iteration for this customer was already sent -> skip
    				//this means if for this customer he has 2011 in mailbeez_tracking then skip him
    
    					continue;
    
    				}

     

    i dont know how i can send a new mail.

    I know it is not an option to send the newsletter 2 a day (i use cron job to run mailbeez 2 a day for review's)

    The newsletter may not do that so i tought i run once and turn off.

     

    Is that right or not?

     

    because i cant find a manual for bulkmail.

     

    Here is the complete bulkmail.php

    <?php
    /* 
     BULKMAIL MODULE by www.niora.com
     MailBeez Automatic Trigger Email Campaigns
     http://www.mailbeez.com
     Copyright (c) 2010 MailBeez
    inspired and in parts based on
     Copyright (c) 2003 osCommerce
     Released under the GNU General Public License
    */
    // make path work from admin
    
     require_once(DIR_FS_CATALOG . 'mailhive/common/classes/mailbeez.php');	
    // could be in language-file
    // just easier to define it in the mailbee
    
    define('MAILBEEZ_BULKMAIL_TEXT_TITLE', 'Bulkmail Sender');
    define('MAILBEEZ_BULKMAIL_TEXT_DESCRIPTION', 'This MailBeez Module sends the customer mailing list at a controlled rate.');	
    
     class bulkmail extends mailbeez {
    	// class constructor
    
       function bulkmail() {
    		// call constructor
    		mailbeez::mailbeez(); 
    
    		// set some stuff:	
         		$this->code = 'bulkmail';
    		$this->module = 'bulkmail';
    		$this->version = '1.4'; // float value
    		$this->required_mb_version = 1.4; // required mailbeez version
    		$this->iteration = '50'; // value not likely to be used in customers.customers_newletters 
         		$this->title = MAILBEEZ_BULKMAIL_TEXT_TITLE;
         		$this->description = MAILBEEZ_BULKMAIL_TEXT_DESCRIPTION;
         		$this->mailrate = MAILBEEZ_BULKMAIL_RATE;
         		$this->newsletter = MAILBEEZ_BULKMAIL_NEWSLETTER;
         		$this->sort_order = MAILBEEZ_BULKMAIL_SORT_ORDER;
         		$this->enabled = ((MAILBEEZ_BULKMAIL_STATUS == 'True') ? true : false);
    		$this->googleanalytics_enabled = ((MAILBEEZ_BULKMAIL_GA == 'True') ? 'True' : 'False');
    		$this->googleanalytics_rewrite_mode =  ((MAILBEEZ_BULKMAIL_GA_MODE == 'default') ? MAILBEEZ_MAILHIVE_GA_REWRITE_MODE : MAILBEEZ_BIRTHDAY_GA_MODE);
    		$this->sender = MAILBEEZ_BULKMAIL_SENDER;
    		$this->sender_name = MAILBEEZ_BULKMAIL_SENDER_NAME;
    		$this->status_key = 'MAILBEEZ_BULKMAIL_STATUS';			
    		$this->documentation_key = $this->module; // leave empty if no documentation available
    
    		// $this->documentation_root = 'http:://yoursite.com/' // modify documentation root if necessary
    		//short name of letter to use
    		$newsletter = $this->newsletter;
    		$this->htmlBodyTemplateResource = $newsletter.'.html-alternative.html'; // located in folder of this module
    		$this->txtBodyTemplateResource = $newsletter.'.text-alternative.html'; // located in folder of this module			
    		$this->subjectTemplateResource = $newsletter.'.subject-htmlandtext.html'; // located in folder of this module
    
    		$this->audience = array();
    		$this->additionalFields = array('subscribers_id' => '007','date_of_birth' => '31.01.'); // list of additional fields to show in listing with testvalues
    
    		// list of additional fields to show in listing with testvalues used for Test-Mail    
    }
    
    // class methods
    	function getAudience() {
    
         $query_raw = "select s.subscribers_firstname, s.subscribers_lastname, s.subscribers_id, s.subscribers_email_address
    				from " . TABLE_SUBSCRIBERS . " s where s.customers_newsletter = " . MAILBEEZ_BULKMAIL_CUSTOMERS . " ";		
    	$query = mh_db_query($query_raw);
    
    		// for early check
    		$mb_chk = new mailbeez_mailer($this);						
    		//start loop
    		while ($item = mh_db_fetch_array($query)) {
    		// mandatory fields:
    		// - firstname
    		// - lastname
    		// - email_address
    		// - customers-id -> block
    
    		// other keys are replaced while sending: $<key>
    
    			// early check to avoid processing when email was already sent
    			$chk_result = $mb_chk->check($this->module, $this->iteration, $item['subscribers_id']);
    			if ($chk_result != false) {
    				// this iteration for this customer was already sent -> skip
    				//this means if for this customer he has 2011 in mailbeez_tracking then skip him
    
    					continue;
    
    				}
    
    		$this->audience[$item['subscribers_id']] = array('firstname' => $item['subscribers_firstname'],
    															'lastname' => $item['subscribers_lastname'],
    		                                                    'email_address' => $item['subscribers_email_address'],
    															'subscribers_id' => $item['subscribers_id']
    																	);
    
    		$mailrate = $this->mailrate;             		
    
    			// if mode ='production' and 'run' is selected
    			if (preg_match('/run&module=bulkmail$/i', $_SERVER['QUERY_STRING'])&& MAILBEEZ_MAILHIVE_MODE == 'production') {
    				//count how many emails to send
    					$count_mail="SELECT customers_newsletter, COUNT(subscribers_email_address) FROM subscribers  WHERE customers_newsletter=" . MAILBEEZ_BULKMAIL_CUSTOMERS . " GROUP BY customers_newsletter";
       					$countmail=mh_db_query($count_mail);
       					while($rowmail = mh_db_fetch_array($countmail)){
       					$mail=$rowmail['COUNT(subscribers_email_address)'];
       					}
    
       				//count how many emails have been sent
    					$count_mailed="SELECT iteration, COUNT(iteration) FROM mailbeez_tracking  WHERE iteration='50' GROUP BY iteration";
       					$countmailed=mh_db_query($count_mailed);
       					while($rowmailed = mh_db_fetch_array($countmailed)){
       					$mailed=$rowmailed['COUNT(iteration)'];
       					}
    
       					echo '<blockquote>emails total: '.$mail.'<br>';
       					echo ' emails sent: '.$mailed.'</blockquote>';	
    
    					//since mode is production refresh page to restart loop and select next record to email					
    					echo "<meta http-equiv='refresh' content= $mailrate>"; 			
    					return $this->audience;								
    				}
    
    		  }  // end of loop
    		  		// mailing completed
    		 		if (preg_match('/run&module=bulkmail$/i', $_SERVER['QUERY_STRING'])&& MAILBEEZ_MAILHIVE_MODE == 'production') {			
    				tep_db_query("DELETE FROM mailbeez_tracking  WHERE  mailbeez_tracking.iteration = '50'");
    				echo '<h1>mailing complete</h1>';
    
    				}	    
    
    				//simulate mode list all
    				if (MAILBEEZ_MAILHIVE_MODE == 'simulate') {  
    
    				//count how many emails to send
    					$count_mail="SELECT customers_newsletter, COUNT(subscribers_email_address) FROM subscribers  WHERE customers_newsletter=" . MAILBEEZ_BULKMAIL_CUSTOMERS . " GROUP BY customers_newsletter";
       					$countmail=mh_db_query($count_mail);
       					while($rowmail = mh_db_fetch_array($countmail)){
       					$mail=$rowmail['COUNT(subscribers_email_address)'];
       					}
       					echo '<blockquote>emails total: '.$mail.'</blockquote>';						
    					return $this->audience;						
    					}					
    		}			
    
    	// installation methods
    
       function keys() {
         return array('MAILBEEZ_BULKMAIL_STATUS', 'MAILBEEZ_BULKMAIL_CUSTOMERS', 'MAILBEEZ_BULKMAIL_NEWSLETTER', 'MAILBEEZ_BULKMAIL_RATE', 'MAILBEEZ_BULKMAIL_SENDER', 'MAILBEEZ_BULKMAIL_SENDER_NAME', 'MAILBEEZ_BULKMAIL_SORT_ORDER', 'MAILBEEZ_BULKMAIL_GA', 'MAILBEEZ_BULKMAIL_GA_MODE');
       }
    
       function install() {
    		mh_insert_config_value(array('configuration_title' => 'Send Bulkmail', 
    																 'configuration_key' => 'MAILBEEZ_BULKMAIL_STATUS', 
    																 'configuration_value' => 'False', 
    																 'configuration_description' => 'Do you want to email a customer group?', 
    																 'set_function' => 'mh_cfg_select_option(array(\'True\', \'False\'), '
    																 ));
    
    
    		mh_insert_config_value(array('configuration_title' => 'newsletter status', 
    																 'configuration_key' => 'MAILBEEZ_BULKMAIL_CUSTOMERS', 
    																 'configuration_value' => '2', 
    																 'configuration_description' => 'customer group to mail(value in database table customers.customers_newsletter)', 
    																 'set_function' => ''
    																 ));
    
    
    		mh_insert_config_value(array('configuration_title' => 'newsletter name', 
    																 'configuration_key' => 'MAILBEEZ_BULKMAIL_NEWSLETTER', 
    																 'configuration_value' => 'newsletter', 
    																 'configuration_description' => 'newsletter to send.(must match first part of file name of a newsletter in mailhive/mailbeez/bulkmail folder)', 
    																 'set_function' => ''
    																 ));														 
    
    
    		mh_insert_config_value(array('configuration_title' => 'Set Mailing Speed', 
    																 'configuration_key' => 'MAILBEEZ_BULKMAIL_RATE', 
    																 'configuration_value' => '4', 
    																 'configuration_description' => 'seconds per email', 
    																 'set_function' => ''
    																 ));
    
    
    		mh_insert_config_value(array('configuration_title' => 'sender email', 
    															 	'configuration_key' => 'MAILBEEZ_BULKMAIL_SENDER', 
    																 'configuration_value' => STORE_OWNER_EMAIL_ADDRESS, 
    																 'configuration_description' => 'sender email', 
    																 'set_function' => ''
    																 ));
    
    
    		mh_insert_config_value(array('configuration_title' => 'sender name', 
    																 'configuration_key' => 'MAILBEEZ_BULKMAIL_SENDER_NAME', 
    																 'configuration_value' => STORE_NAME, 
    																 'configuration_description' => 'sender email', 
    																 'set_function' => ''
    																 ));
    
    
    		mh_insert_config_value(array('configuration_title' => 'Sort order of display.', 
    																 'configuration_key' => 'MAILBEEZ_BULKMAIL_SORT_ORDER', 
    																 'configuration_value' => '20', 
    																 'configuration_description' => 'Sort order of display. Lowest is displayed first.', 
    																 'set_function' => ''
    																 ));
    
    
    		mh_insert_config_value(array('configuration_title' => 'Google Analytics Integration', 
    																 'configuration_key' => 'MAILBEEZ_BULKMAIL_GA', 
    																 'configuration_value' => 'True', 
    																 'configuration_description' => 'Do you want to enable URL rewrite to track this MailBeez Module in Google Analytics?', 
    																 'set_function' => 'mh_cfg_select_option(array(\'True\', \'False\'), '
    																 ));
    
    
    		mh_insert_config_value(array('configuration_title' => 'Google Analytics Integration URL rewrite mode', 
    																 'configuration_key' => 'MAILBEEZ_BULKMAIL_GA_MODE', 
    																 'configuration_value' => 'default', 
    																 'configuration_description' => 'Google Analytics URL Rewrite Mode', 
    																 'set_function' => 'mh_cfg_select_option(array(\'default\', \'all\', \'shop\'), '
    																 ));
       }
     }
    ?>

     

    Thanks for helping.

     

    Jasper

  10. Thanks that realy works.

     

    But now the next problem,

     

    When trying sending mail it says:

    0 was already sent: 2011-03-25 13:41:26 MR Firstname Lastname [email protected]

    Result:0 items

    no matching customers or all items have been sent

     

    This means for me that i can not send more then one newsletter with Bulkmail?

    Am i correct?

     

    I send one last week and would like to send on now too.

     

    Can you help me out (again)

     

    The layout of bulkmail is much better then te regular newsletter from OSC

     

    Regards,

     

    jasper

  11. Hello,

     

    I use the Mailbeez with great pleasure for a little time now.

    But i now have a contri installed so people can subscribe to my newsletter who are not costumers (hope you know what i mean my english is not so good)

    But the problem is that Mailbeez (Bulkmail) gets the data from the costumers table and the contri i installed has a new table in the database called "subscribers"

     

    in this table my regular costumers with newsletter "on" and the manual subscribers are there.

     

    New Bulkmail is missing people that manualy subscribed.

     

    How can i get these subscribers in bulkmail?

     

    Table layout is like this:

     

    -- phpMyAdmin SQL Dump
    -- version 3.3.9.2
    -- http://www.phpmyadmin.net
    --
    -- Machine: localhost
    -- Genereertijd: 24 Mar 2011 om 14:00
    -- Serverversie: 5.1.52
    -- PHP-Versie: 5.2.9
    
    SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
    
    
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    
    --
    -- Database: `***osc13`
    --
    
    -- --------------------------------------------------------
    
    --
    -- Tabelstructuur voor tabel `subscribers`
    --
    
    CREATE TABLE IF NOT EXISTS `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`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;
    
    --
    -- Gegevens worden uitgevoerd voor tabel `subscribers`
    --
    
    INSERT INTO `subscribers` (`subscribers_id`, `customers_id`, `subscribers_email_address`, `subscribers_firstname`, `subscribers_lastname`, `language`, `subscribers_gender`, `subscribers_email_type`, `entry_date`, `undeliverable_count`, `mail_details_customers_id`, `list_number`, `source_import`, `date_account_created`, `date_account_last_modified`, `customers_newsletter`, `subscribers_blacklist`, `subscription_date`, `status_sent1`, `host_name`, `hardiness_zone`) VALUES
    (1, 0, 'info@my_domain.eu', 'Test First Name', 'Test Last Name', 'English', NULL, '', '0000-00-00', 0, 0, 0, 'subscribe_newsletter', '2011-03-24 12:59:51', '0000-00-00 00:00:00', 1, 0, '0000-00-00 00:00:00', 1, NULL, ''),
    (2, 2, '[email protected]', 'John', 'Doe', 'English', '', 'Text', '2011-03-24', 0, 0, 0, 'CUSTOMERS', '2011-03-24 13:15:08', '2011-03-24 13:15:16', 1, 0, '0000-00-00 00:00:00', 0, NULL, NULL),
    

     

    You can see there are firstname and lastname and "subscribers_email_type" like "CUSTOMERS" for regular and 'subscribe_newsletter' for manualy subscribers.

     

    Or if someone know's a better way visitors can subscribe too my newsletter let me know.

     

    Best regards,

     

    Jasper

×
×
  • Create New...