Latest News: (loading..)
Sign in to follow this  
Followers 0
higgalls

PHPList integration to OsCommerce

116 posts in this topic

Great idea, thanks for mentioning PHPlist. I was wondering two things.

1. Some paid services offer the possability of having a queu of newsletters with each new subscriber starting at newsletter no1 and progressing through the newsletters at specified intervals. Do you think that such a functionality could be added to PHP list?

 

2. How reliably integrated is PHPlist to OSC?

 

Thanks

Share this post


Link to post
Share on other sites
Great idea, thanks for mentioning PHPlist. I was wondering two things.

1. Some paid services offer the possability of having a queu of newsletters with each new subscriber starting at newsletter no1 and progressing through the newsletters at specified intervals. Do you think that such a functionality could be added to PHP list?

 

2. How reliably integrated is PHPlist to OSC?

 

Thanks

 

Hi,

 

1. Don't know how to do this. You would be best bringing this up on the phplist forums (http://www.phplist.com/forums/)

 

2. I haven't tested all the functions of the phplist integration into OsCommerce, but from what I can see it looks good.

I did have one problem with it where I dont have any attributes specified in PHPList, so in the phplist code on the create_account.php page I simply commented out the lines that do calls to the phplist attributes tables, and it is now adding their email address to the phplist database.

 

Hopefully it wont take me long to integrate it into the contact_us page so that every time someone emails me from there, they have the option of subscribing to our mailing list also.

 

My suggestion is to install it in a test environment and see how you go and then let us all know how you went.

 

Cheers,

Chris :)

Share this post


Link to post
Share on other sites

Hey Everyone,

 

Needing your help with finishing the phplist integration to the contact_us.php page.

Basically, it is not adding the email address to the phplist database.

 

Here is the code:

<?php
/*
 $Id: contact_us.php,v 1.42 2003/06/12 12:17:07 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce  Released under the GNU General Public License

Modified for VN2 Free Skin E by Kevin jeffery - www.vn2designs.com
*/

 require('includes/application_top.php');

 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CONTACT_US);

 $error = false;
 if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'send')) {
$name = tep_db_prepare_input($HTTP_POST_VARS['name']);
$email_address = tep_db_prepare_input($HTTP_POST_VARS['email']);
$enquiry = tep_db_prepare_input($HTTP_POST_VARS['enquiry']);


if (isset($HTTP_POST_VARS['newsletter'])) {
  $newsletter = tep_db_prepare_input($HTTP_POST_VARS['newsletter']);
} else {
  $newsletter = false;
}


if (tep_validate_email($email_address)) {
  tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, EMAIL_SUBJECT, $enquiry, $name, $email_address);
  if(SEND_CONTACT_US_RESPONSE=='true')
  tep_mail($name, $email_address, CONTACT_US_RESPONSE_EMAIL_SUBJECT, CONTACT_US_RESPONSE_EMAIL_TEXT."\n\n-------------------------Your Message:\n".$enquiry, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
  tep_redirect(tep_href_link(FILENAME_CONTACT_US, 'action=success'));
} else {
  $error = true;

  $messageStack->add('contact', ENTRY_EMAIL_ADDRESS_CHECK_ERROR);
}
}

// Begin PHPlist Newsletter add-on
   require(DIR_WS_INCLUDES . '/phplist_define.php'); //get the phplist specifics
   //get user specifics from PHPlist
   $existing_email_query = tep_db_query("select id, email, foreignkey from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user where email = '" . $email_address . "'"); //check for existing by email address
   $history_systeminfo_text = "\nHTTP_USER_AGENT = " . $_SERVER["HTTP_USER_AGENT"] ."\nHTTP_REFERER = " . $_SERVER["HTTP_REFERER"] . "\nREMOTE_ADDR = " . $_SERVER["REMOTE_ADDR"] . "";
   $history_detail_text = "";
   //subscribe logic
   if ($newsletter) {
	 if (tep_db_num_rows($existing_email_query) < 1) { //no existing user by email address found (therefore a new user - no id or email found)
	   $id = md5(uniqid(mt_rand())); //generate unique id and add new user to database
	   tep_db_query("insert into " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user (email, confirmed, subscribepage, entered, modified, disabled, uniqid, htmlemail, foreignkey) values ('" . $email_address . "', 1, " . PHPLIST_SPAGE . ", now(), now(), 0, '" . $id . "', " . PHPLIST_HTMLEMAIL . ", " . $customer_id . ")"); //insert the new user into phplist
	   $user_query=tep_db_query("select id from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user where email = '" . $email_address . "'"); //get the new user's phplist id
	   $user = tep_db_fetch_array($user_query);
	   //tep_db_query("insert into " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user_attribute (attributeid, userid, value) values (" . PHPLIST_FIRSTNAME . ", " . $user['id'] . ", '" . $firstname . "')"); //add the users firstname to the attributes table
	   //tep_db_query("insert into " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user_attribute (attributeid, userid, value) values (" . PHPLIST_LASTNAME . ", " . $user['id'] . ", '" . $lastname . "')"); //add the users lastname to the attributes table
	   tep_db_query("insert into " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "listuser (userid, listid, entered) values (" . $user['id'] . ", " . PHPLIST_LISTNO . ", now())"); //subscribe the new user to the correct list
	   //generating history
	   $history_detail_text .= "\nSubscribepage = " . PHPLIST_SPAGE . "\nforeign key = " . $customer_id . "\n";
	   //$attribute_name_query = tep_db_query("select name from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_attribute where id = " . PHPLIST_FIRSTNAME . "");
	   //$attribute_name = tep_db_fetch_array($attribute_name_query);
	   //$history_detail_text .= "" . $attribute_name[name] . " = " . $firstname . "\n";
	   //$attribute_name_query = tep_db_query("select name from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_attribute where id = " . PHPLIST_LASTNAME . "");
	   //$attribute_name = tep_db_fetch_array($attribute_name_query);
	   //$history_detail_text .= "" . $attribute_name[name] . " = " . $lastname . "\n";
	   $list_name_query = tep_db_query("select name from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "list where id = " . PHPLIST_LISTNO . "");
	   $list_name = tep_db_fetch_array($list_name_query);
	   $history_detail_text .= "\nList subscriptions:\n" . $list_name['name'] . "";
	   tep_db_query("insert into " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user_history (userid, ip, date, summary, detail, systeminfo) values (" . $user['id'] . ", '" . $_SERVER["REMOTE_ADDR"] . "', '" . date('Y-m-d H:i:s') . "', 'Update through osC', '" . $history_detail_text . "', '" . $history_systeminfo_text . "')"); //create history post
	 }
	 else { //subscribe the existing user if disabled and add foreignkey match to customer_id
	   $existing_email = tep_db_fetch_array($existing_email_query); //existing user by email found
	   tep_db_query("update " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user set disabled = 0, confirmed = 1, foreignkey = " . $customer_id . " where id = " . $existing_email['id'] . "");
	   $history_detail_text .= "foreign key = " . $customer_id . "\nchanged from ";
	   //check to see if they already are subscribed to the correct list
	   $list_query = tep_db_query("select * from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "listuser where userid = " . $existing_email['id'] . " and listid = " . PHPLIST_LISTNO . "");
	   if ($list=tep_db_num_rows($list_query) < 1) { //no existing subscription to the newsletter found
		 //generating history, previous subscriptions
		 $history_detail_text .= "\n\nList subscriptions:\n";
		 $existing_subscription_query = tep_db_query("select li.name from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "list li, " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "listuser lu where li.id = lu.listid and lu.userid = " . $existing_email['id'] . "");
		 if (tep_db_num_rows($existing_subscription_query) < 1) {
		   $history_detail_text .= "Was subscribed to: \n";
		 } else {
		   while($existing_subscription = tep_db_fetch_array($existing_subscription_query)){
			 $history_detail_text .= "Was subscribed to: " . $existing_subscription[name] . "\n";
		   }
		 }
		 tep_db_query("insert into " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "listuser (userid, listid, entered) values (" . $existing_email['id'] . ", " . PHPLIST_LISTNO . ", now())"); //subscribe the new user to the correct list
		 //generating history, current (updated) subscriptions
		 $updated_subscription_query = tep_db_query("select li.name from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "list li, " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "listuser lu where li.id = lu.listid and lu.userid = " . $existing_email['id'] . "");
		 while ($updated_subscription = tep_db_fetch_array($updated_subscription_query)) {
		   $history_detail_text .= "Is now subscribed to: " . $updated_subscription[name] . "\n";
		 }
	   }
	   tep_db_query("insert into " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user_history (userid, ip, date, summary, detail, systeminfo) values (" . $existing_email['id'] . ", '" . $_SERVER["REMOTE_ADDR"] . "', '" . date('Y-m-d H:i:s') . "', 'Update through osC', '" . $history_detail_text . "', '" . $history_systeminfo_text . "')"); //create history post
	 }
   }
// End PHPlist Newsletter add-on


 $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_CONTACT_US));
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<META NAME="publisher" CONTENT="HostingosCommerce.com">
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="760" align="center" cellspacing="0" cellpadding="0" background="images/mainbg.jpg">
 <tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="0">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><?php echo tep_draw_form('contact_us', tep_href_link(FILENAME_CONTACT_US, 'action=send')); ?><table border="0" width="440" align="center" cellspacing="0" cellpadding="0">
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
		<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_contact_us.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
	  </tr>
	</table></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
<?php
 if ($messageStack->size('contact') > 0) {
?>
  <tr>
	<td><?php echo $messageStack->output('contact'); ?></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
<?php
 }

 if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'success')) {
?>
  <tr>
	<td class="main" align="center"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_man_on_board.gif', HEADING_TITLE, '0', '0', 'align="left"') . TEXT_SUCCESS; ?></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
	  <tr class="infoBoxContents">
		<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
			<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
		  </tr>
		</table></td>
	  </tr>
	</table></td>
  </tr>
<?php
 } else {
?>
  <tr>
	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
	  <tr class="infoBoxContents">
		<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
	  <tr>
			<td class="main">If you have any enquries, please feel free to email us at <a href="mailto:sales@stonebridgecomputing.com.au">sales@stonebridgecomputing.com.au</a>, or feel free to use the following form.<br><br></td>
		  </tr>
		  <tr>
			<td class="main"><?php echo ENTRY_NAME; ?></td>
		  </tr>
		  <tr>
			<td class="main"><?php echo tep_draw_input_field('name'); ?></td>
		  </tr>
		  <tr>
			<td class="main"><?php echo ENTRY_EMAIL; ?></td>
		  </tr>
		  <tr>
			<td class="main"><?php echo tep_draw_input_field('email'); ?></td>
		  </tr>






<tr>
			<td class="main">Subscribe to Newsletter?
			<?php echo tep_draw_checkbox_field('newsletter', '1',checked) . ' ' . (tep_not_null(ENTRY_NEWSLETTER_TEXT) ? '<span class="inputRequirement">' . ENTRY_NEWSLETTER_TEXT . '</span>': ''); ?></td>
</tr>









		  <tr>
			<td class="main"><?php echo ENTRY_ENQUIRY; ?></td>
		  </tr>
		  <tr>
			<td><?php echo tep_draw_textarea_field('enquiry', 'soft', 50, 15); ?></td>
		  </tr>
		</table></td>
	  </tr>
	</table></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
	  <tr class="infoBoxContents">
		<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
			<td align="right"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></td>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
		  </tr>
		</table></td>
	  </tr>
	</table></td>
  </tr>
<?php
 }
?>
</table></form></td>
<!-- body_text_eof //-->
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="0">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
</table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Share this post


Link to post
Share on other sites

Do I install phplist separately under my domain before installing this contribution? I'm confused by the instructions. Has anyone used this?

 

Thanks,

Barb

Share this post


Link to post
Share on other sites
Do I install phplist separately under my domain before installing this contribution? I'm confused by the instructions. Has anyone used this?

 

Thanks,

Barb

 

Yes, you need to have PHPList installed and working BEFORE you install this contribution.

 

Cheers,

Chris

Share this post


Link to post
Share on other sites

Hi

I have been trying to install this on a new shop. It have tried it with phplist in a seperate db and also with it integrated into oscommerce db. When it is a seperate db i get no joy, i get an error each time when creating a new user. With the db integrated into the oscommerce db the customer sign up is ok and goes through fine. Now when in the admin panel of oscommerce, should i need to edit the clients details or even delete it i get the following:

 

1146 - Table 'ndink_osc1.ndink_phplistuser_user' doesn't exist

 

select id, email, foreignkey from ndink_phplistuser_user where email = 'nick.joslin@gmail.com'

 

[TEP STOP]

 

Any help would be much appreciated as i feel this is quite an important tool.

 

Nick

Share this post


Link to post
Share on other sites
Hi

I have been trying to install this on a new shop. It have tried it with phplist in a seperate db and also with it integrated into oscommerce db. When it is a seperate db i get no joy, i get an error each time when creating a new user. With the db integrated into the oscommerce db the customer sign up is ok and goes through fine. Now when in the admin panel of oscommerce, should i need to edit the clients details or even delete it i get the following:

Any help would be much appreciated as i feel this is quite an important tool.

 

Nick

 

Hi,

 

You firstly need your phplist db to be separate from the OsCommerce one.

What errors were you getting when it was in a separate db?

 

Cheers,

Chris

Share this post


Link to post
Share on other sites

Hello,

 

My host requires each mysql database to have a different host name. I don't see any definitions for hostname in the phplist define file. Anybody know if this is possible, and if so what mods would be required?

 

Thanks and Rock on,

 

Mike

Share this post


Link to post
Share on other sites
Hello,

 

My host requires each mysql database to have a different host name. I don't see any definitions for hostname in the phplist define file. Anybody know if this is possible, and if so what mods would be required?

 

Thanks and Rock on,

 

Mike

 

Can you please explain what you mean a bit further?

 

Regards,

Chris

Share this post


Link to post
Share on other sites
Can you please explain what you mean a bit further?

 

Regards,

Chris

 

Absolutely, I have a different hostname for my phpList database, and I didn't see anywhere in the configuration where you could specify the database hostname. That leads me to believe that for the database queries it's using the DB_Server define from the configure.php. I could be wrong, the error I'm recieving is an 1146 Table 'MyoScommerceDatabase.MyphpListDatabasephplist_user_user' doesn't exist. This is happens when I access the account_newletter.php from account.php.

 

Hope that helps, let me know if you need more info.

 

Cheers,

 

Mike

Share this post


Link to post
Share on other sites
Absolutely, I have a different hostname for my phpList database, and I didn't see anywhere in the configuration where you could specify the database hostname. That leads me to believe that for the database queries it's using the DB_Server define from the configure.php. I could be wrong, the error I'm recieving is an 1146 Table 'MyoScommerceDatabase.MyphpListDatabasephplist_user_user' doesn't exist. This is happens when I access the account_newletter.php from account.php.

 

Hope that helps, let me know if you need more info.

 

Cheers,

 

Mike

 

Hi,

 

It talks about Table 'MyoScommerceDatabase.MyphpListDatabasephplist_user_user'. Is PHPList using the same database as your OsCommerce database?

PHPList NEEDS to be on its own database. Is PHPList already running properly for you?

 

I believe there is a config file for PHPList where you need to set the hostname and database name. The hostname should simply be 'localhost' as the MySQL server is running on your web server.

 

Cheers,

Chris

Share this post


Link to post
Share on other sites
Hi,

 

It talks about Table 'MyoScommerceDatabase.MyphpListDatabasephplist_user_user'. Is PHPList using the same database as your OsCommerce database?

PHPList NEEDS to be on its own database. Is PHPList already running properly for you?

 

I believe there is a config file for PHPList where you need to set the hostname and database name. The hostname should simply be 'localhost' as the MySQL server is running on your web server.

 

Cheers,

Chris

 

Hey Chris,

 

PHPList is working fine and it's installed in a seperate database. After seeing the oscommerce database at the beginning of the that error I'm beginning to think it's a problem with the way the sql queries are put together in account_newsletter.php, but I'm not sure.

 

The host name isn't localhost for this installation because I'm in a shared server environment. When you create a new database you have to create a new hostname for that database, so no two are the same. That's why I thought that might be an issue.

 

Thanks again,

 

Mike

Share this post


Link to post
Share on other sites
Hi,

 

It talks about Table 'MyoScommerceDatabase.MyphpListDatabasephplist_user_user'. Is PHPList using the same database as your OsCommerce database?

PHPList NEEDS to be on its own database. Is PHPList already running properly for you?

 

I believe there is a config file for PHPList where you need to set the hostname and database name. The hostname should simply be 'localhost' as the MySQL server is running on your web server.

 

Cheers,

Chris

 

Chris,

 

I checked out the phplist forums, and found the topic where this contribution started out. It looks like there were some changes to the code to simplify things if you have phplist in the same database. Do you have the original files prior to those changes. If so, I'd appreciate if you could send those to me. I've got a solution for signing up via the home page without an account, and administration once they have an account, but I don't have a solution for the create account part of the process.

 

Thanks for your help Bro :thumbsup:,

 

Mike

Share this post


Link to post
Share on other sites

Hi all,

 

When I did this contribution I did it for a single host environment. Meaning that the Mysql databases must be on the same host, sorry. But maybe you can find information on Mysql's support site.

 

Though I am running osC and PHPlist in separate databases, you should be able to run both applications in the same database. If so you have to leave the definition of the variable PHPLIST_DB empty/blank in the file phplist_define.php. This should work:

 

define('PHPLIST_DB', '');

 

This 'MyoScommerceDatabase.MyphpListDatabasephplist_user_user' seems to point out that there is a little dot forgotten in the above statement. If you are using ver 0.6 you must remember to put a dot after the db name, like this:

 

define('PHPLIST_DB', 'phplistdb.');

 

I am using this on live osC and PHPlist installations and it is actually working as I intended it to. But maybe there is a problem in the description for account_newsletter.php, I will look into this.

 

Thanks for using this contrib and to Chris for setting up this forum thread. I have uploaded a new version with requirements description. If there is anything that seems unclear, let me know.

 

Regards

Thomas

Share this post


Link to post
Share on other sites

HI all

 

Maybe this is what I needed.

 

Can it send those funcy newsletters that I usually receive with photos,links etc?

 

Thanks

Edited by Salvo

Share this post


Link to post
Share on other sites

Hi,

 

 

I have just installed the phplist_mod. and I have few questions.

 

My Instalaltion :

phplist/admin + phplist.sql

oscommerce/admin + osc.sql

 

1/ In create_account.php :

=================

I am looking for showing all the news group purposed with phplist/?p=subscribe

at the present time, juste the defaut osc newsgroup is shown

 

2/ In oscommerce/admin/newsletters.php :

============================

News administration should be done through a. /phplist/admin or b. /admin/newsletters.php

 

 

Newsletter Manager

 

Newsletters Size Module Sent Status Action

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-12, 12' at line 1

 

select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -12, 12

 

[TEP STOP]

 

 

;)

 

JK

Share this post


Link to post
Share on other sites

Hi all, i integrated this contribution in my OSC store.

 

The contrib works fine, but i have a question:

 

I don't see news letters/lists from phplist showing up.

 

I also want to know if this is integrated in this contrib.

 

My intention is to create multiple newsletters in php list and showing

te different lists in create_account and edit_account, So people can choose

wich newsletter to subscribe.

 

If it already is integrated, can someone explain wich settings to change or

what to do in phplist.

 

Thanks for the nice contrib, gonna save me a lot of time.

Share this post


Link to post
Share on other sites
Hi all, i integrated this contribution in my OSC store.

 

The contrib works fine, but i have a question:

 

I don't see news letters/lists from phplist showing up.

 

I also want to know if this is integrated in this contrib.

 

My intention is to create multiple newsletters in php list and showing

te different lists in create_account and edit_account, So people can choose

wich newsletter to subscribe.

 

If it already is integrated, can someone explain wich settings to change or

what to do in phplist.

 

Thanks for the nice contrib, gonna save me a lot of time.

 

I believe it should only work for the one list at this stage, because upon setting it up you would have had to select the PHPList list that is to be used for OsCommerce.

 

I would imagine it would require some serious hacking in order to change this.

 

Regards,

Chris

Share this post


Link to post
Share on other sites

thanks for the reply,

 

I really wan't to show up different newsletters in my list, so i will have a look at it.

If i find a way to to this i will post is in the contrubution of phplist.

Share this post


Link to post
Share on other sites

Hi all

 

I have downloaded the program and is online for testing at moment.

 

I like to try it before having it with my OSC catalog...

 

I have one question.. Does anyone know how I could have ie. Specials from OSC to be sent as newsletter?

 

Thanks

 

Salvo

Share this post


Link to post
Share on other sites

Hi

 

I have installed PHPList and it works fine.

I have made the changes to the necessary OSC files and when submitting a new account (with the newsletter box ticked) I get the following error:

 

1146 - Table 'db72914343.PHPLIST_user_user' doesn't exist

 

I also get the same error if i try to edit any users details from within the OSC admin screens.

 

Any ideas from you genuises out there ?

 

thanks in advance!

Alan

Share this post


Link to post
Share on other sites
Hi

 

I have installed PHPList and it works fine.

I have made the changes to the necessary OSC files and when submitting a new account (with the newsletter box ticked) I get the following error:

 

1146 - Table 'db72914343.PHPLIST_user_user' doesn't exist

 

I also get the same error if i try to edit any users details from within the OSC admin screens.

 

Any ideas from you genuises out there ?

 

thanks in advance!

Alan

 

I just fixed this myself - i noticed that the table prefix default was PHPLIST_ whereas in phpMyAdmin, the table was showing up as phplist_ so i changed that and it now works.

Hope this info might be useful to anyone else who might have made this simple mistake!

Share this post


Link to post
Share on other sites

I have a few questions about this mod that I hope someone can answer:

 

1) Is the information flow both ways (someone uses phpList to opt out leads to an update in Zen Cart, and when someone opts out of Zen Cart it updates phpList)

 

2) Is additional information available within phpList (country, name etc)

 

3) Is there any reduction in the phpList functionality such as bounced email recording and automatic unsubscribe etc.

 

Thanks for your experienced comments.

 

Scott

Share this post


Link to post
Share on other sites
I have a few questions about this mod that I hope someone can answer:

 

1) Is the information flow both ways (someone uses phpList to opt out leads to an update in Zen Cart, and when someone opts out of Zen Cart it updates phpList)

 

2) Is additional information available within phpList (country, name etc)

 

3) Is there any reduction in the phpList functionality such as bounced email recording and automatic unsubscribe etc.

 

Thanks for your experienced comments.

 

Scott

 

Hey, Basically, the details about who is on the mailing list is stored directly in PHPList database (not in the oscommerce database). So, if someone unsubscribes in PHPList, it should reflect that change in OsCommerce also.

 

I believe you can add attributes to the PHPList, but I haven't tried doing it as I dont record those details in PHPList myself.

 

Because it links in with the PHPList database, all functionality in PHPList should remain exactly the same.

 

Hope this helps you out a little bit.

 

Cheers,

Chris :)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0