I need an extension from your Plugin.
very easy task. If someone is signing up we already write to the table 'calculator' in the WP Database.
I would extend the functiion that we write the values
$username to field name
$user_email to field email
actual date (timestamp) to field date
'1' as number to field nid
'1' as number to field active
'1' as number to field confirmed
add as new entry to the table 'wpr_subscribers'
Table Structure is:
CREATE TABLE IF NOT EXISTS `wp_3_wpr_subscribers` (
`nid` int(11) NOT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`date` varchar(12) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT '0',
`confirmed` tinyint(1) NOT NULL DEFAULT '0',
`fid` tinyint(1) NOT NULL DEFAULT '1',
`hash` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_email_for_newsletter` (`nid`,`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
I attach the WP_calculator file so you can edit directly-
Thanks for a fast reply.