Jump to content



Photo
- - - - -

PHPList integration to OsCommerce


  • Please log in to reply
115 replies to this topic

#1   higgalls

higgalls
  • Members
  • 315 posts
  • Real Name:Higgalls
  • Location:Australia

Posted 24 January 2006 - 09:14

This is the support/ideas/improvements thread for the PHPList for OsCommerce contribution.

Contribution can be found here: http://www.oscommerc...tributions,3976

Cheers,
Chris :)

Edited by stonebridgecomputing, 24 January 2006 - 09:15.


#2   Hasmik

Hasmik
  • Members
  • 7 posts
  • Real Name:Hasmik Durig
  • Location:switzerland

Posted 24 January 2006 - 12:13

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

#3   higgalls

higgalls
  • Members
  • 315 posts
  • Real Name:Higgalls
  • Location:Australia

Posted 24 January 2006 - 21:00

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 :)

#4   higgalls

higgalls
  • Members
  • 315 posts
  • Real Name:Higgalls
  • Location:Australia

Posted 29 January 2006 - 06:25

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) . '&nbsp;' . (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'); ?>


#5   basnyd

basnyd
  • Members
  • 54 posts
  • Real Name:Barb Snyderman

Posted 10 February 2006 - 20:20

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

Thanks,
Barb

#6   higgalls

higgalls
  • Members
  • 315 posts
  • Real Name:Higgalls
  • Location:Australia

Posted 10 February 2006 - 23:30

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

#7   NDComputers

NDComputers
  • Members
  • 65 posts
  • Real Name:Nick

Posted 18 February 2006 - 12:57

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

#8   higgalls

higgalls
  • Members
  • 315 posts
  • Real Name:Higgalls
  • Location:Australia

Posted 18 February 2006 - 22:57

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

#9   smashing_machine

smashing_machine
  • Members
  • 9 posts
  • Real Name:Mike Jones
  • Location:ATX

Posted 24 February 2006 - 21:36

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

#10   higgalls

higgalls
  • Members
  • 315 posts
  • Real Name:Higgalls
  • Location:Australia

Posted 25 February 2006 - 01:22

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

#11   smashing_machine

smashing_machine
  • Members
  • 9 posts
  • Real Name:Mike Jones
  • Location:ATX

Posted 25 February 2006 - 03:08

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

#12   higgalls

higgalls
  • Members
  • 315 posts
  • Real Name:Higgalls
  • Location:Australia

Posted 25 February 2006 - 03:40

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

#13   smashing_machine

smashing_machine
  • Members
  • 9 posts
  • Real Name:Mike Jones
  • Location:ATX

Posted 25 February 2006 - 05:45

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

#14   smashing_machine

smashing_machine
  • Members
  • 9 posts
  • Real Name:Mike Jones
  • Location:ATX

Posted 01 March 2006 - 01:14

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

#15   samoth

samoth
  • Members
  • 3 posts
  • Real Name:Thomas A
  • Location:Uppsala, Sweden

Posted 29 March 2006 - 11:45

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

#16   Salvo

Salvo
  • Members
  • 1,008 posts
  • Real Name:Salvo
  • Gender:Male

Posted 29 March 2006 - 13:01

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, 29 March 2006 - 13:02.


#17   Jk

Jk
  • Members
  • 9 posts
  • Real Name:JK

Posted 31 March 2006 - 13:24

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

#18   kevinsmit

kevinsmit
  • Members
  • 5 posts
  • Real Name:kevin smit

Posted 31 March 2006 - 16:35

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.

#19   higgalls

higgalls
  • Members
  • 315 posts
  • Real Name:Higgalls
  • Location:Australia

Posted 31 March 2006 - 22:47

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

#20   kevinsmit

kevinsmit
  • Members
  • 5 posts
  • Real Name:kevin smit

Posted 02 April 2006 - 19:25

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.