RE: [GET] Modules for PES Pro 1.9.7
did that again.. reuploaded the files.. still does not save settings on the backend... hmmmm (02-14-2014 10:54 PM)mugrinic Wrote: Add this code in the SQL
Code:
CREATE TABLE IF NOT EXISTS `settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_name` text NOT NULL,
`site_description` text NOT NULL,
`site_url` varchar(255) NOT NULL,
`site_email` varchar(255) NOT NULL,
`paypal` varchar(64) NOT NULL,
`maintenance` int(11) NOT NULL DEFAULT '0',
`m_progress` int(11) NOT NULL DEFAULT '75',
`m_twitter` varchar(255) NOT NULL,
`fb_fan_url` varchar(255) NOT NULL,
`free_cpc` int(32) NOT NULL DEFAULT '5',
`premium_cpc` int(32) NOT NULL DEFAULT '10',
`daily_bonus` int(255) NOT NULL DEFAULT '0',
`daily_bonus_vip` int(255) NOT NULL DEFAULT '0',
`crf_bonus` int(64) NOT NULL DEFAULT '0',
`surf_time` int(11) NOT NULL DEFAULT '5',
`surf_time_type` int(11) NOT NULL DEFAULT '0',
`ref_coins` int(11) NOT NULL DEFAULT '10',
`reg_coins` int(11) NOT NULL DEFAULT '0',
`reg_cash` decimal(5,2) NOT NULL DEFAULT '0.00',
`reg_status` int(11) NOT NULL DEFAULT '0',
`reg_reqmail` int(11) NOT NULL DEFAULT '0',
`scf_api` varchar(255) NOT NULL,
`transfer_status` int(11) NOT NULL DEFAULT '0',
`transfer_fee` int(64) NOT NULL DEFAULT '10',
`refsys` int(11) NOT NULL DEFAULT '1',
`paysys` int(11) NOT NULL DEFAULT '0',
`ref_cash` decimal(5,2) NOT NULL DEFAULT '0.00',
`ref_sale` int(11) NOT NULL DEFAULT '10',
`pay_min` decimal(5,2) NOT NULL DEFAULT '0.00',
`surf_type` int(11) NOT NULL DEFAULT '0',
`currency_code` varchar(64) NOT NULL DEFAULT 'USD',
`banner_system` int(11) NOT NULL DEFAULT '1',
`def_lang` varchar(11) NOT NULL DEFAULT 'en',
`more_per_ip` int(11) NOT NULL DEFAULT '0',
`c_c_limit` int(11) NOT NULL DEFAULT '2',
`c_v_limit` int(11) NOT NULL DEFAULT '5',
`surf_fb_skip` int(11) NOT NULL DEFAULT '0',
`surf_fc_req` int(11) NOT NULL DEFAULT '0',
`hideref` int(11) NOT NULL DEFAULT '1',
`c_discount` int(64) NOT NULL DEFAULT '0',
`c_show_msg` int(11) NOT NULL DEFAULT '0',
`c_text_index` text NOT NULL,
`payza` varchar(64) NOT NULL,
`payza_security` varchar(255) NOT NULL,
`paypal_status` int(11) NOT NULL DEFAULT '1',
`payza_status` int(11) NOT NULL DEFAULT '0',
`captcha_sys` int(11) NOT NULL DEFAULT '0',
`recaptcha_pub` varchar(255) NOT NULL DEFAULT '0',
`recaptcha_sec` varchar(255) NOT NULL DEFAULT '0',
`target_system` int(11) NOT NULL DEFAULT '0',
`aff_reg_days` int(64) NOT NULL DEFAULT '0',
`analytics_id` varchar(32) NOT NULL,
`aff_click_req` int(64) NOT NULL DEFAULT '10',
`paypal_auto` int(11) NOT NULL DEFAULT '1',
`payza_auto` int(11) NOT NULL DEFAULT '1',
`report_limit` int(64) NOT NULL DEFAULT '0',
`mysql_random` int(11) NOT NULL DEFAULT '1',
`convert_enabled` int(11) NOT NULL DEFAULT '0',
`convert_rate` int(255) NOT NULL DEFAULT '1000',
`min_convert` int(64) NOT NULL DEFAULT '100',
`allow_withdraw` int(11) NOT NULL DEFAULT '0',
`instagram_id` varchar(255) NOT NULL DEFAULT '0',
`revshare_api` varchar(32) NOT NULL,
`fb_app_id` varchar(128) NOT NULL,
`fb_app_secret` varchar(128) NOT NULL,
`auto_country` int(11) NOT NULL DEFAULT '0',
`blog_comments` int(11) NOT NULL DEFAULT '1',
`twitter_token` varchar(255) NOT NULL,
`twitter_token_secret` varchar(255) NOT NULL,
`twitter_consumer_key` varchar(255) NOT NULL,
`twitter_consumer_secret` varchar(255) NOT NULL,
`yt_api` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Do not forget to add a reputation for me if I helped you!
did that again.. reuploaded the files.. still does not save settings on the backend... i do see the settings table with all the fields in the DB now.. but just the structure, no data even after trying to save stuff on the backend
(02-14-2014 10:54 PM)mugrinic Wrote: Add this code in the SQL
Code:
CREATE TABLE IF NOT EXISTS `settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_name` text NOT NULL,
`site_description` text NOT NULL,
`site_url` varchar(255) NOT NULL,
`site_email` varchar(255) NOT NULL,
`paypal` varchar(64) NOT NULL,
`maintenance` int(11) NOT NULL DEFAULT '0',
`m_progress` int(11) NOT NULL DEFAULT '75',
`m_twitter` varchar(255) NOT NULL,
`fb_fan_url` varchar(255) NOT NULL,
`free_cpc` int(32) NOT NULL DEFAULT '5',
`premium_cpc` int(32) NOT NULL DEFAULT '10',
`daily_bonus` int(255) NOT NULL DEFAULT '0',
`daily_bonus_vip` int(255) NOT NULL DEFAULT '0',
`crf_bonus` int(64) NOT NULL DEFAULT '0',
`surf_time` int(11) NOT NULL DEFAULT '5',
`surf_time_type` int(11) NOT NULL DEFAULT '0',
`ref_coins` int(11) NOT NULL DEFAULT '10',
`reg_coins` int(11) NOT NULL DEFAULT '0',
`reg_cash` decimal(5,2) NOT NULL DEFAULT '0.00',
`reg_status` int(11) NOT NULL DEFAULT '0',
`reg_reqmail` int(11) NOT NULL DEFAULT '0',
`scf_api` varchar(255) NOT NULL,
`transfer_status` int(11) NOT NULL DEFAULT '0',
`transfer_fee` int(64) NOT NULL DEFAULT '10',
`refsys` int(11) NOT NULL DEFAULT '1',
`paysys` int(11) NOT NULL DEFAULT '0',
`ref_cash` decimal(5,2) NOT NULL DEFAULT '0.00',
`ref_sale` int(11) NOT NULL DEFAULT '10',
`pay_min` decimal(5,2) NOT NULL DEFAULT '0.00',
`surf_type` int(11) NOT NULL DEFAULT '0',
`currency_code` varchar(64) NOT NULL DEFAULT 'USD',
`banner_system` int(11) NOT NULL DEFAULT '1',
`def_lang` varchar(11) NOT NULL DEFAULT 'en',
`more_per_ip` int(11) NOT NULL DEFAULT '0',
`c_c_limit` int(11) NOT NULL DEFAULT '2',
`c_v_limit` int(11) NOT NULL DEFAULT '5',
`surf_fb_skip` int(11) NOT NULL DEFAULT '0',
`surf_fc_req` int(11) NOT NULL DEFAULT '0',
`hideref` int(11) NOT NULL DEFAULT '1',
`c_discount` int(64) NOT NULL DEFAULT '0',
`c_show_msg` int(11) NOT NULL DEFAULT '0',
`c_text_index` text NOT NULL,
`payza` varchar(64) NOT NULL,
`payza_security` varchar(255) NOT NULL,
`paypal_status` int(11) NOT NULL DEFAULT '1',
`payza_status` int(11) NOT NULL DEFAULT '0',
`captcha_sys` int(11) NOT NULL DEFAULT '0',
`recaptcha_pub` varchar(255) NOT NULL DEFAULT '0',
`recaptcha_sec` varchar(255) NOT NULL DEFAULT '0',
`target_system` int(11) NOT NULL DEFAULT '0',
`aff_reg_days` int(64) NOT NULL DEFAULT '0',
`analytics_id` varchar(32) NOT NULL,
`aff_click_req` int(64) NOT NULL DEFAULT '10',
`paypal_auto` int(11) NOT NULL DEFAULT '1',
`payza_auto` int(11) NOT NULL DEFAULT '1',
`report_limit` int(64) NOT NULL DEFAULT '0',
`mysql_random` int(11) NOT NULL DEFAULT '1',
`convert_enabled` int(11) NOT NULL DEFAULT '0',
`convert_rate` int(255) NOT NULL DEFAULT '1000',
`min_convert` int(64) NOT NULL DEFAULT '100',
`allow_withdraw` int(11) NOT NULL DEFAULT '0',
`instagram_id` varchar(255) NOT NULL DEFAULT '0',
`revshare_api` varchar(32) NOT NULL,
`fb_app_id` varchar(128) NOT NULL,
`fb_app_secret` varchar(128) NOT NULL,
`auto_country` int(11) NOT NULL DEFAULT '0',
`blog_comments` int(11) NOT NULL DEFAULT '1',
`twitter_token` varchar(255) NOT NULL,
`twitter_token_secret` varchar(255) NOT NULL,
`twitter_consumer_key` varchar(255) NOT NULL,
`twitter_consumer_secret` varchar(255) NOT NULL,
`yt_api` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Do not forget to add a reputation for me if I helped you!
|