Printable View
I need to be able to assign my customers a "license number" for their account. So that each customer gets one unique (cannot duplicate) account number automatically generated when they register. Or, if this is not possible can each customer assign themselves a unique username and if they enter a username that is already in use it will bounce back and ask them to try again.
Any help with this will be GREATLY appreciated!!! Thanks in advance :D
What purpose does this serve?
I sell digital art downloads for others to use so long as they have a valid license. I need to be able to issue a unique license to each customer, it lets me and others know that they purchased the art ligitimately and they didn't pirate my art. So I really NEED to be able to assign each of my customers a license number, it can be short, 5 digits preferably, and if you can help me or direct me to a mod that can give each customer a unique id number that would be very helpfulQuote:
Originally Posted by DrByte
Each customer in your store already has a unique identifier: their email address.
Is that usable for your needs?
No, its really not. I need to assign short license number that my customers will display on the creations they make. I am one of many copyright compliant psp tube artists and my customers REQUIRE a license number as a terms of usage. For instance ©FourXDesigns www.fourxdesigns-store.com FXD79221 the FXD79221 part would be the computer generated portion that I would like, if possible, the zen cart interface to create.
Okay. And at what point should this be generated? Should it be generated for every customer, regardless of any purchases they've made?
Should the "number" have any set formula or pattern?
How should it be delivered to them? Perhaps in a "welcome email"?
How should it be delivered to *you*?
Does the store need to "remember" the code? Does it need to be displayed anywhere other than one-time when it is generated?
I could go on and on with a whole lot more questions about specifics of what your needs are. There's no point in me giving you a bunch of code that generates a number if there's no direction about what to *do* with that number. You'd just come back asking "where do I put that?" or "now how do I email it?", etc.
Can you continue with explaining the full big picture of what you're wanting to accomplish?
Ok, so a customer comes to my store, they must register before they can checkout. I would like a unique, random 5 digit number to be created at the time of registration that would be added to their customer field in the customer database so that I can know who has which specific license number, and also sent to each customer via welcome email once it is generated. Each customer only needs one license number regardless of the number of purchases they make, I undertand that if a customer would for some reason register two times they would be sent 2 license numbers via email. This 5 digit number should be random and unique for each customer as it serves as a "online proof of registration" that they are ligitimate customers and not digital image pirates. Much in the same way that a car license plate# cannot repeat with another car in that state, and should anouther car have the exact same license # as the next you would know that to be a red flag for fraud. These unique random licenses should not be listed anywhere in the store pages for customers to view, though it would not be harmful, it would be totally unnecessary. If a customer forgets or loses their unique number I can look in the customer database in the Zen admin and remind them of their number. I would prefer the license to be sent via email rather than just dispayed as a new page after registration because the customers wiill typically save this email on their personal email client.Quote:
Originally Posted by DrByte
This whole processes is a critical step because of internet copyright infringement and people who pirate/rip digital images to use for profit elsewhere. My store sells digital image rights for hobbyists to use noncommercially in online forums, facebook, and such. Each image that they purchase comes with a Terms of Use which states a full copyright must be on every image they create using my art. Should two people attempt to use the same license number, I would be able to look in the customer database and say "Jane Doe has the right to use this image which she purchased on XX/XX/2012, and John Doe's image was fraud for he has no license nor has he ever made a purchase from my store." I personally draw every image in the store and its just as important to me as it is to my customers that every buys them ligitimately, and doesn't share images or license numbers with others. Fair is fair.
I hope this is full enough a description. Its about protecting myself and protecting my customers because they will "brand" all of their creations with their unique license number before proudly displaying their images online. I know that the "Customer" panel shows "ID#", but a sequential 1+ digit license number would be insufficient, in the same way that no one has a 1 digit social security number.
Thanks again!!!!!
Attachment 11076
I hope this works, but this is what I mean that my images are used for online forums. See the © at the bottom SHOULD have a license number following it. Because this image has no license number there is no way on earth for me to verify that the lady "image" in this tag was purchased legally. I made this myself for myself by the way, so no copyright infringement here! :cool: And nobody wants to put their email address or their full name on the bottom of their tags. One, that wouldn't be "pretty". Two, if they did, people would solicit them to make tags for them, which they may not want to do. And ending the © with "3" :no:, well, that's just not proper tagging form. It needs a proper license number! :smartalec:
I also wanted to add that I only have SOME programming knowledge so if I have to change files or add files, or download modules, etc. could you please provide the paths to where I can find those files or paths to where to put them. Thanks!
I use FileZilla ftp and notepad++ I run Zen Cart 1.5 my hosting is through godaddy and its Linux
No matter how many digits the customer id has, it will always be unique and useable as a license identifier. If you don't want any one-digit licenses, create nine test customers and all of the real ones will have at least a two-digit id. If you want more digits to start, there will be a way to update the database with a specific number as a takeoff point.Quote:
I know that the "Customer" panel shows "ID#", but a sequential 1+ digit license number would be insufficient, in the same way that no one has a 1 digit social security number.
This is not a "random 5-digit number", but it is useable for your customers and immediately available without a lot of custom coding.
If that's the easiest way, to have the IDs start with say 10000, then that's fine. Could you guide me to how to set the code to do that? Also will/can Zen Cart email the customers that number in the Welcome Message as they register?Quote:
Originally Posted by gjh42
Thanks so much for you all help! I'm sorry if I am being a pain :(
You would need a SQL statement (or group of statements) to run once in adin > Tools > Install SQL Patches. I would have to do some research for the correct formulation; DrByte would be able to tell you quickly, and I would want his assurance that it only needs to be updated in one place.
I'm not sure if the welcome e-mail includes the customer id, but you could create a test customer (using an e-mail you have access to) and see what it says.
Well, don't go changing customer numbers to start at 10,000.
That will waste space in the number of customers your store can handle, since the current architecture is based off an auto-increment field of an INT data type. It's the same reason one should never force their order numbers to mysteriously start at a higher number.
If it's just a 5-digit code you're after, you can start out by pre-pending a leading zero, or maybe two, until your customer numbers are organically high enough.
You will need to write custom code to generate any additional prefixes, and also to include any of that information in a welcome email, and/or add it to their My Account screens, etc.
I do not posess nearly enough programming knowledge to be able to customize my code in that way. I was hoping that there was an addon out there somewhere that I just hadn't found that a techy guru had alreay created! Perhaps I should scour the internet for a spreadsheet formula that could preformat my columns to create ID numbers. Then I shall have to bite the bullet with manually emailing each customer their license numbers.Quote:
Originally Posted by DrByte
Thanks you all for giving it a good try!
You said you wanted to make your store tell the customer their unique customer code to use on graphics prepared using resources they purchase from your store.
Try the following code, which involves simply creating and uploading 2 files to your server:
1. /includes/classes/observers/class.send_extra_email_at_welcome.php
2. /includes/auto_loaders/config.send_extra_email_at_welcome.phpPHP Code:<?php
/**
* @package plugins
* @copyright Copyright 2003-2012 Zen Cart Development Team
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
*
* Designed for v1.5.0, 1.5.1
*/
/**
* If you need support for multiple languages, then ...
* the following defines could be copied into a new file at /includes/languages/OTHER_LANGUAGE_FOLDERNAME/extra_definitions/send_extra_email_at_welcome.php
* and then translated there.
*/
define('EMAIL_SUBJECT_WELCOME_WITH_SPECIAL_CUSTOMER_CODE', 'Your unique customer code!');
define('TEXT_WELCOME_WITH_SPECIAL_CUSTOMER_CODE1', 'Welcome! Here is your unique customer code: ');
define('TEXT_WELCOME_WITH_SPECIAL_CUSTOMER_CODE2', 'Please be sure to use it on all graphics you produce using graphics purchased from this site.');
/**
* Observer class for sending an extra email during customer-creation/welcome process
*/
class send_extra_email_at_welcome extends base {
function __construct() {
global $zco_notifier;
$zco_notifier->attach($this, array('NOTIFY_MODULE_CREATE_ACCOUNT_ADDED_CUSTOMER_RECORD'));
}
function update(&$class, $eventID, $paramsArray = array())
{
/**
* This means "take the customer number, and add enough zeros to the left of it to make it be 3 digits long.
* str_pad($_SESSION['customer_id'],3,'0',STR_PAD_LEFT);
*
*/
$code = str_pad($_SESSION['customer_id'],3,'0',STR_PAD_LEFT);
/**
* Then the 'FXP0' prefix is added to it:
*/
$code = 'FXP0' . $code;
/**
* Now send the email to the customer
*/
$email_subject = EMAIL_SUBJECT_WELCOME_WITH_SPECIAL_CUSTOMER_CODE;
$email_text = TEXT_WELCOME_WITH_SPECIAL_CUSTOMER_CODE1 . $code . "\n\n" . TEXT_WELCOME_WITH_SPECIAL_CUSTOMER_CODE2 . "\n\n";
$html_msg['EMAIL_SUBJECT'] = $email_subject;
$html_msg['EMAIL_MESSAGE_HTML'] .= nl2br($email_text);
$customer_name = $paramsArray['customers_firstname'] . ' ' . $paramsArray['customers_lastname'];
$customer_email_address = $paramsArray['customers_email_address'];
zen_mail($customer_name, $customer_email_address, $email_subject, $email_text, STORE_NAME, EMAIL_FROM, $html_msg);
/**
* Available variables:
* $_SESSION['customer_id'] or $paramsArray['customer_id']
* $paramsArray['customers_firstname']
* $paramsArray['customers_lastname']
* $paramsArray['customers_email_address']
* $paramsArray['customers_telephone']
*/
}
}
I ran a quick test with it, and received the expected email.Code:<?php
/**
* @package plugins
* @copyright Copyright 2003-2012 Zen Cart Development Team
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
*/
/**
* Designed for v1.5.0, 1.5.1
*/
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
$autoLoadConfig[190][] = array('autoType'=>'class',
'loadFile'=>'observers/class.send_extra_email_at_welcome.php');
$autoLoadConfig[190][] = array('autoType'=>'classInstantiate',
'className'=>'send_extra_email_at_welcome',
'objectName'=>'send_extra_email_at_welcome');
If this code is useful to you, please consider a meaningful donation to the Zen Cart project: www.zen-cart.com/donate