New tables:
CREATE TABLE IF NOT EXISTS vtp_paymentlog (
id int(11) NOT NULL auto_increment,
members_id int(11) NOT NULL,
providor varchar(50) collate utf8_unicode_ci NOT NULL,
currency varchar(3) collate utf8_unicode_ci NOT NULL,
amount float NOT NULL,
receipt_date timestamp NOT NULL default CURRENT_TIMESTAMP,
`status` varchar(20) collate utf8_unicode_ci NOT NULL,
trans_id varchar(30) collate utf8_unicode_ci NOT NULL,
log text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS vtp_twitter (
id int(11) NOT NULL auto_increment,
newsletter_id int(11) NOT NULL,
members_id int(11) NOT NULL,
created timestamp NOT NULL default CURRENT_TIMESTAMP,
tweet varchar(140) collate utf8_unicode_ci NOT NULL,
done tinyint(1) NOT NULL default '0',
`type` tinyint(1) NOT NULL default '0',
PRIMARY KEY (id),
KEY created (created),
KEY members_id (members_id),
KEY newsletter_id (newsletter_id),
KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;
New Files:
/
callback.php
cron.php
twittercron.php
ipn.php
ipn_process.php
ipn.sql.php.txt (just holds a copy of the create code for the above payment log table).
/include
twitter.curl.php
twitterOAuth.php
OAuth.php
Modified/Added Manager files:
/manager/frames/
config.php
home.php
/manager/frames/config/
twitter.php
save.php
Modified/Added template files:
/templates/standard/inv/
buytraffic.tpl
addtext.tpl
websites.tpl
tweetad.tpl.htm
