members only area

[liam1964]

Hi Liam

are you familiar with using ftp software and modifying zen cart files with text editors?

cheers

Derek

Hi Derek,
I had given in on a reply, stopped being lazy, and figured it out for myself. The answer I was looking for is already in this same thread, I guess my frustration at the time stopped my ability to read properly. Amazing how often that happens on this (and other) forums.

Thank you for whatever valuable information you were about to share.
Liam

[Derek Bryant]

Hi Liam

I presume you mean the my posting on 31st March 2009 (for anyone else struggling)

pleased you've cracked it!!

cheers

Derek

[greengreetings]

This the code:

<?php

$custID = $_SESSION['customer_id'];

if ($custID > 0)
{
$host="localhost";
$user="username";
$password="password";
$database="database name";
$connection = mysql_connect($host, $user, $password)
or die ("Could not connect");
$db = mysql_select_db($database, $connection)
or die ("Could not connect");

$query = "SELECT customers_firstname, customers_lastname, customers_id, customers_newsletter from customers WHERE customers_id=$custID";
$result = mysql_query($query)
or die ("couldn't execute query");

$row = mysql_fetch_array($result,MYSQL_BOTH);

$newlettercode = $row[3];

if ($newlettercode == 0)
{echo "non member - please purchase membership subscription above";}
else
{echo "link to members section";}

}
else
{ echo "<br>Please log in if you are a member<br> ";}

?>

The code works great, Derek. I'm using it to encourage customers to create accounts as members to take part in contests. Here's the work in progress:

http://www.janaygreen.com/index.php?main_page=contests

. It's awesome! Thanks. Awesome and easy!

[Derek Bryant]

Hi Greengreetings

thanks for the feedback - pleased to be of help

Derek