joomla template, virtuemart, phpBB styles, virtuemart, drupal theme, virtuemart, phpBB styles, virtuemart, mootools, virtuemart, phpBB styles, virtuemart, drupal theme, virtuemart, phpBB styles, virtuemart, jQuery, virtuemart, phpBB styles, virtuemart, drupal theme, virtuemart, phpBB styles, virtuemart, mootools, virtuemart, phpBB styles, virtuemart, drupal theme, virtuemart, phpBB styles, virtuemart

PIN Codes 1.1.0 Beta 1 for VirtueMart gives you the ability to sell PIN codes through VirtueMart.

Features

• Upon purchase, the PIN code is automatically sent to the user’s email address.
• Once a PIN code has been purchased and sent to the user, it is marked as ‘sold’ and is attached to the user’s account for future reference.
• Enter PIN codes either manually or import via csv.
• Automatically notifies the administrator when PIN codes reach a minimum limit.
• All of the VirtueMart order forms have been updated to display PIN code information.

Compatibility

• VirtueMart 1.1.0.
• Joomla! 1.5.x
• Joomla! 1.0.x

Known Issues in Beta 1

• VirtueMart Simple Layout has minimal support.
• When large numbers of PIN codes are imported or created manually, the PIN code list is cut off at the bottom of the product form. Workaround: reload the product form.

Pin codes for VirtueMart 1.1.0

Installation:
Database
1. Create the pin code tables using the following 3 SQL statements:

CREATE TABLE `jos_vm_pin_config` (
 `id` int(11) NOT NULL auto_increment,
 `product_id` int(11) NOT NULL,
 `minimum` int(11) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `product_id` (`product_id`)
);

CREATE TABLE `jos_vm_pin_codes` (
 `id` int(11) NOT NULL auto_increment,
 `pin` varchar(255) NOT NULL,
 `product_id` int(11) NOT NULL,
 `enabled` int(11) unsigned NOT NULL default '0',
 `order_id` int(11) default NULL,
 `order_item_id` int(11) default NULL,
 PRIMARY KEY  (`id`),
 UNIQUE KEY `product_pin` (`pin`,`product_id`)
);

INSERT INTO `jos_vm_function` (`module_id`, `function_name`, `function_class`, `function_method`, `function_description`, `function_perms`) VALUES 
(2, 'pinAdd', 'pin.class', 'add', 'Inserts a new PIN number into the database.', 'storeadmin,admin'),
(2, 'pinDelete', 'pin.class', 'delete', 'Deletes a PIN number.', 'storeadmin,admin'),
(2, 'pinDisable', 'pin.class', 'disable', 'Disables a PIN number.', 'storeadmin,admin'),
(2, 'pinEnable', 'pin.class', 'enable', 'Enables a PIN number.', 'storeadmin,admin'),
(2, 'pinFree', 'pin.class', 'free', 'Disassociates a PIN number from any order.', 'storeadmin,admin'),
(2, 'pinImport', 'pin.class', 'import', 'Imports PIN numbers from a CSV file.', 'storeadmin,admin'),
(2, 'pinSetMinimum', 'pin.class', 'setMinimum', 'For a given product, sets the minimum number of pins at which the administrator is notified.', 'storeadmin,admin');

Files

1. Copy the following files to their respective VirtueMart directories:

- http://joomquery.com/components/com_virtuemart/class/pin.classs.php
- http://joomquery.com/components/com_virtuemart/html/product.product_form_pin_tab.php

2. For the following files, either copy them to their respective VirtueMart directories or copy the edits over to your existing files (search for Greg):
- http://joomquery.com/components/com_virtuemart/classes/ps_checkout.php
- http://joomquery.com/components/com_virtuemart/html/order.order_printdetails.php
- http://joomquery.com/components/com_virtuemart/html/order.order_print.php
- http://joomquery.com/components/com_virtuemart/html/product.product_form.php
- http://joomquery.com/components/com_virtuemart/themes/default/templates/order_emails/confirmation_email.tpl.php
- http://joomquery.com/components/com_virtuemart/themes/default/templates/page/account.order_details.tpl.php

3. Copy the language strings from common/english.php to your language file in the common directory (search for Greg).

Usage hints:

1. Do not create pin codes the first time you create a particular product. Save the product first, then close and open the product before creating pin codes. This is unfortunately necessary due to the way the Virtuemart product form is built.

2. Low number of pin codes notification
- You can set, for each product, the minimum number of pin codes. Once that minimum is reached, an email is sent to the administrator.

3. Pin code CSV import file format.
- Header row: do not include a header row; the first row should contain data.
- Columns (they must be in this order):
pin: required; must be alphanumeric
enabled: required; either 1 or 0
product_id: optional; if left empty, the current product's id will be used

- Delimiter: comma ,
- Enclosure character: double quote "

- Sample csv import file:

"mex100",0,17
"mex101",1,17
"asia100",0,18
"asia101",1,18
"noprod0",0
"noprod1",1
"asia102",1,18

Download Pin Codes 1.1.0 Beta 1:http://www.mediafire.com/?2ue18v299byhk5t