Project Detail

Description

Hi,

There are 2 things that needs to be done.

Firstly, I need help to upload a file (look for the LPCTRModV3.zip attachment here) via FTP

That's actually pretty simple but in order for the file to work after it has been uploaded, from what I understand from the setup instructions, some modifications to the SQL tab in PHPMYADMIN is required.

Here is the full setup instructions:

1.) Make a backup of top.php in the tracking202/_config folder
2.) Copy top.php to the tracking202/_config folder
3.) Make a backup of index.php in the tracking202/analyze folder
4.) Copy index.php to the tracking202/analyze folder
5.) Copy contents of tracking202/ajax and tracking202/analyze to the corresponding folders (no backups are required since it doesn't overwrite anything)
a.) You can just overwrite the existing files in the _config, ajax, and analyze folders.
6.) Make sure to add the tables below using the SQL tab in PHPMYADMIN in your webhost.


CREATE TABLE IF NOT EXISTS `202_sort_keywords_lpctr` (
`sort_keyword_id` int(10) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL,
`keyword_id` bigint(20) unsigned NOT NULL,
`sort_keyword_clicks` mediumint(8) unsigned NOT NULL,
`sort_keyword_click_throughs` mediumint(8) unsigned NOT NULL,
`sort_keyword_ctr` decimal(10,2) NOT NULL,
`sort_keyword_leads` mediumint(8) unsigned NOT NULL,
`sort_keyword_su_ratio` decimal(10,2) NOT NULL,
`sort_keyword_payout` decimal(6,2) NOT NULL,
`sort_keyword_epc` decimal(10,2) NOT NULL,
`sort_keyword_avg_cpc` decimal(7,5) NOT NULL,
`sort_keyword_income` decimal(10,2) NOT NULL,
`sort_keyword_cost` decimal(13,5) NOT NULL,
`sort_keyword_net` decimal(13,5) NOT NULL,
`sort_keyword_roi` decimal(10,2) NOT NULL,
PRIMARY KEY (`sort_keyword_id`),
KEY `user_id` (`user_id`),
KEY `keyword_id` (`keyword_id`),
KEY `sort_keyword_clicks` (`sort_keyword_clicks`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `202_sort_text_ads_lpctr` (
`sort_text_ad_id` int(10) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL,
`text_ad_id` mediumint(8) unsigned NOT NULL,
`sort_text_ad_clicks` mediumint(8) unsigned NOT NULL,
`sort_text_ad_click_throughs` mediumint(8) unsigned NOT NULL,
`sort_text_ad_ctr` decimal(10,2) NOT NULL,
`sort_text_ad_leads` mediumint(8) unsigned NOT NULL,
`sort_text_ad_su_ratio` decimal(10,2) NOT NULL,
`sort_text_ad_payout` decimal(6,2) NOT NULL,
`sort_text_ad_epc` decimal(10,2) NOT NULL,
`sort_text_ad_avg_cpc` decimal(7,5) NOT NULL,
`sort_text_ad_income` decimal(10,2) NOT NULL,
`sort_text_ad_cost` decimal(13,5) NOT NULL,
`sort_text_ad_net` decimal(13,5) NOT NULL,
`sort_text_ad_roi` decimal(10,2) NOT NULL,
PRIMARY KEY (`sort_text_ad_id`),
KEY `user_id` (`user_id`),
KEY `keyword_id` (`text_ad_id`),
KEY `sort_keyword_clicks` (`sort_text_ad_clicks`),
KEY `sort_keyword_leads` (`sort_text_ad_leads`),
KEY `sort_keyword_signup_ratio` (`sort_text_ad_su_ratio`),
KEY `sort_keyword_payout` (`sort_text_ad_payout`),
KEY `sort_keyword_epc` (`sort_text_ad_epc`),
KEY `sort_keyword_cpc` (`sort_text_ad_avg_cpc`),
KEY `sort_keyword_income` (`sort_text_ad_income`),
KEY `sort_keyword_cost` (`sort_text_ad_cost`),
KEY `sort_keyword_net` (`sort_text_ad_net`),
KEY `sort_keyword_roi` (`sort_text_ad_roi`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `202_sort_referers_lpctr` (
`sort_referer_id` int(10) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL,
`referer_id` bigint(20) unsigned NOT NULL,
`sort_referer_clicks` mediumint(8) unsigned NOT NULL,
`sort_referer_click_throughs` mediumint(8) unsigned NOT NULL,
`sort_referer_ctr` decimal(10,2) NOT NULL,
`sort_referer_leads` mediumint(8) unsigned NOT NULL,
`sort_referer_su_ratio` decimal(10,2) NOT NULL,
`sort_referer_payout` decimal(6,2) NOT NULL,
`sort_referer_epc` decimal(10,2) NOT NULL,
`sort_referer_avg_cpc` decimal(7,5) NOT NULL,
`sort_referer_income` decimal(10,2) NOT NULL,
`sort_referer_cost` decimal(13,5) NOT NULL,
`sort_referer_net` decimal(13,5) NOT NULL,
`sort_referer_roi` decimal(10,2) NOT NULL,
PRIMARY KEY (`sort_referer_id`),
KEY `user_id` (`user_id`),
KEY `keyword_id` (`referer_id`),
KEY `sort_keyword_clicks` (`sort_referer_clicks`),
KEY `sort_keyword_leads` (`sort_referer_leads`),
KEY `sort_keyword_signup_ratio` (`sort_referer_su_ratio`),
KEY `sort_keyword_payout` (`sort_referer_payout`),
KEY `sort_keyword_epc` (`sort_referer_epc`),
KEY `sort_keyword_cpc` (`sort_referer_avg_cpc`),
KEY `sort_keyword_income` (`sort_referer_income`),
KEY `sort_keyword_cost` (`sort_referer_cost`),
KEY `sort_keyword_net` (`sort_referer_net`),
KEY `sort_keyword_roi` (`sort_referer_roi`)
) ENGINE=MyISAM;


After you've uploaded the first file, only then will you upload the second [look for the referermodforprosper202.zip attachment here] (according to the setup instructions, the first file must be uploaded first before the second for this thing to work)

Here are the full instructions for the second file:

1.) Make a backup of top.php in the tracking202/_config folder
2.) Copy top.php to the tracking202/_config folder
3.) Make a backup of index.php in the tracking202/analyze folder
4.) Copy index.php to the tracking202/analyze folder
5.) Copy contents of tracking202/ajax and tracking202/analyze to the corresponding folders (no backups are required since it doesn't overwrite anything)
a.) You can just overwrite the existing files in the _config, ajax, and analyze folders.
6.) Make sure to add the tables below using the SQL tab in PHPMYADMIN in your webhost.

CREATE TABLE IF NOT EXISTS `202_sort_keywords_lpctr` (
`sort_keyword_id` int(10) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL,
`keyword_id` bigint(20) unsigned NOT NULL,
`sort_keyword_clicks` mediumint(8) unsigned NOT NULL,
`sort_keyword_click_throughs` mediumint(8) unsigned NOT NULL,
`sort_keyword_ctr` decimal(10,2) NOT NULL,
`sort_keyword_leads` mediumint(8) unsigned NOT NULL,
`sort_keyword_su_ratio` decimal(10,2) NOT NULL,
`sort_keyword_payout` decimal(6,2) NOT NULL,
`sort_keyword_epc` decimal(10,2) NOT NULL,
`sort_keyword_avg_cpc` decimal(7,5) NOT NULL,
`sort_keyword_income` decimal(10,2) NOT NULL,
`sort_keyword_cost` decimal(13,5) NOT NULL,
`sort_keyword_net` decimal(13,5) NOT NULL,
`sort_keyword_roi` decimal(10,2) NOT NULL,
PRIMARY KEY (`sort_keyword_id`),
KEY `user_id` (`user_id`),
KEY `keyword_id` (`keyword_id`),
KEY `sort_keyword_clicks` (`sort_keyword_clicks`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `202_sort_text_ads_lpctr` (
`sort_text_ad_id` int(10) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL,
`text_ad_id` mediumint(8) unsigned NOT NULL,
`sort_text_ad_clicks` mediumint(8) unsigned NOT NULL,
`sort_text_ad_click_throughs` mediumint(8) unsigned NOT NULL,
`sort_text_ad_ctr` decimal(10,2) NOT NULL,
`sort_text_ad_leads` mediumint(8) unsigned NOT NULL,
`sort_text_ad_su_ratio` decimal(10,2) NOT NULL,
`sort_text_ad_payout` decimal(6,2) NOT NULL,
`sort_text_ad_epc` decimal(10,2) NOT NULL,
`sort_text_ad_avg_cpc` decimal(7,5) NOT NULL,
`sort_text_ad_income` decimal(10,2) NOT NULL,
`sort_text_ad_cost` decimal(13,5) NOT NULL,
`sort_text_ad_net` decimal(13,5) NOT NULL,
`sort_text_ad_roi` decimal(10,2) NOT NULL,
PRIMARY KEY (`sort_text_ad_id`),
KEY `user_id` (`user_id`),
KEY `keyword_id` (`text_ad_id`),
KEY `sort_keyword_clicks` (`sort_text_ad_clicks`),
KEY `sort_keyword_leads` (`sort_text_ad_leads`),
KEY `sort_keyword_signup_ratio` (`sort_text_ad_su_ratio`),
KEY `sort_keyword_payout` (`sort_text_ad_payout`),
KEY `sort_keyword_epc` (`sort_text_ad_epc`),
KEY `sort_keyword_cpc` (`sort_text_ad_avg_cpc`),
KEY `sort_keyword_income` (`sort_text_ad_income`),
KEY `sort_keyword_cost` (`sort_text_ad_cost`),
KEY `sort_keyword_net` (`sort_text_ad_net`),
KEY `sort_keyword_roi` (`sort_text_ad_roi`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `202_sort_referers_lpctr` (
`sort_referer_id` int(10) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL,
`referer_id` bigint(20) unsigned NOT NULL,
`sort_referer_clicks` mediumint(8) unsigned NOT NULL,
`sort_referer_click_throughs` mediumint(8) unsigned NOT NULL,
`sort_referer_ctr` decimal(10,2) NOT NULL,
`sort_referer_leads` mediumint(8) unsigned NOT NULL,
`sort_referer_su_ratio` decimal(10,2) NOT NULL,
`sort_referer_payout` decimal(6,2) NOT NULL,
`sort_referer_epc` decimal(10,2) NOT NULL,
`sort_referer_avg_cpc` decimal(7,5) NOT NULL,
`sort_referer_income` decimal(10,2) NOT NULL,
`sort_referer_cost` decimal(13,5) NOT NULL,
`sort_referer_net` decimal(13,5) NOT NULL,
`sort_referer_roi` decimal(10,2) NOT NULL,
PRIMARY KEY (`sort_referer_id`),
KEY `user_id` (`user_id`),
KEY `keyword_id` (`referer_id`),
KEY `sort_keyword_clicks` (`sort_referer_clicks`),
KEY `sort_keyword_leads` (`sort_referer_leads`),
KEY `sort_keyword_signup_ratio` (`sort_referer_su_ratio`),
KEY `sort_keyword_payout` (`sort_referer_payout`),
KEY `sort_keyword_epc` (`sort_referer_epc`),
KEY `sort_keyword_cpc` (`sort_referer_avg_cpc`),
KEY `sort_keyword_income` (`sort_referer_income`),
KEY `sort_keyword_cost` (`sort_referer_cost`),
KEY `sort_keyword_net` (`sort_referer_net`),
KEY `sort_keyword_roi` (`sort_referer_roi`)
) ENGINE=MyISAM;


Additional files submitted:
LPCTRModV3.zip
referermodforprosper202.zip