Käynnissä

Install 2 files via FTP - involves SQL & PHPMYADMIN

Hi,

There are 2 things that needs to be done.

Firstly, I need help to upload a file (look for the [url removed, login to view] 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 [url removed, login to view] in the tracking202/_config folder

2.) Copy [url removed, login to view] to the tracking202/_config folder

3.) Make a backup of [url removed, login to view] in the tracking202/analyze folder

4.) Copy [url removed, login to view] 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 [url removed, login to view] 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 [url removed, login to view] in the tracking202/_config folder

2.) Copy [url removed, login to view] to the tracking202/_config folder

3.) Make a backup of [url removed, login to view] in the tracking202/analyze folder

4.) Copy [url removed, login to view] 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;

Taidot: PHP, SQL

Näytä lisää: php ajax sql, need sql help, ftp engine, sql c, null, int, top webhost, sql required, php sql add, install work, copy tables, amp sql, create files folders, create folder upload php, via ajax, zip backup, add sql php, ftp php file copy, add tables sql, copy file ftp php, create install, backup contents, ftp sql table, bigint, sql work

About the Employer:
( 1 review ) singapore, Singapore

Projektin tunnus: #495616

Myönnetty käyttäjälle:

UmidKZ

Hello, ready to start - will finish this within hour or two.

30 $ USD 0 päivässä
(22 arvostelua)
5.1
skilledsir

hello.i can do it for you and i will work unitl you get 200% satisfication.i am online now.

30 $ USD 0 päivässä
(15 arvostelua)
3.7

4 freelanceria on tarjonnut keskimäärin 90 $ tähän työhön

swfprogrammer

check your pmb

50 $ USD 1 päivässä
(0 arvostelua)
0.0
pjill307

Hi Please see PM Thanks

250 $ USD 1 päivässä
(0 arvostelua)
0.0