Maxik1988

Попробовал все тоже самое может я что то не то и не туда вставляю. посмотрите я хоть правильно в коде вставляю?

сейчас попробую

все тоже самое

сейчас проверю

А есть возможность проверить этот запрос если его вывести куда нибудь?

вот последний который я добавлял

в какой таблице находятся покупатели?

да тут как бы все добавляется

результат значит работает

когда я у них спрашивал они ответили так

обновлял я первым способом делал

в общем делал так и так результат такой: кеш очищал

эта сборка обошлась 6200 деревянных без без абонентной платы, я немного поторопился они через месяц выложили на opencart 3 и уже с открытым кодом, они перестали кодировать

я правильно понимаю если мне нужно что бы это поле отправлялась в письме я еще должен дописать в отправки вот так? $message .= $this->language->get('text_value') . ' ' . $num_card . "\n"; text_value - я в шаблоне написал значение "номер карты"

я покупал эту сборку только из-за одного модуля интеграции с С1

куда дальше?

нет у меня такой папки <?php //004fb if(!extension_loaded('ionCube Loader')){$__oc=strtolower(substr(php_uname(),0,3));$__ln='ioncube_loader_'.$__oc.'_'.substr(phpversion(),0,3).(($__oc=='win')?'.dll':'.so');if(function_exists('dl')){@dl($__ln);}if(function_exists('_il_exec')){return _il_exec();}$__ln='/ioncube/'.$__ln;$__oid=$__id=realpath(ini_get('extension_dir'));$__here=dirname(__FILE__);if(strlen($__id)>1&&$__id[1]==':'){$__id=str_replace('\\','/',substr($__id,2));$__here=str_replace('\\','/',substr($__here,2));}$__rd=str_repeat('/..',substr_count($__id,'/')).$__here.'/';$__i=strlen($__rd);while($__i--){if($__rd[$__i]=='/'){$__lp=substr($__rd,0,$__i).$__ln;if(file_exists($__oid.$__lp)){$__ln=$__lp;break;}}}if(function_exists('dl')){@dl($__ln);}}else{die('The file '.__FILE__." is corrupted.\n");}if(function_exists('_il_exec')){return _il_exec();}echo("Site error: the ".(php_sapi_name()=='cli'?'ionCube':'<a href="http://www.ioncube.com">ionCube</a>')." PHP Loader needs to be installed. This is a widely used PHP extension for running ionCube protected PHP code, website security and malware blocking.\n\nPlease visit ".(php_sapi_name()=='cli'?'get-loader.ioncube.com':'<a href="http://get-loader.ioncube.com">get-loader.ioncube.com</a>')." for install assistance.\n\n");exit(199); ?> HR+cPugdELWYFeAVa6MiUm9V3l+CXcpd1krFXzeN8gM+mHRssuTCXcJnt7HTiXcuNLJ2ZgJ7Puen D3C2hmXaHkzOXQ0Y9s4KU7KWGrvaNyH4ZLeimPGAE4jvzj/Yxz7bM/mbNEwFUSRwCwSR6FX4q4Nq 3hHCAFpLG31SruTWZ9OUl6/sH1hx92yTzfSkFYceVvzlrX9hfyY3xgG5l/EYazj09EUxkmNreLhd 5OWwP+Nf+jfVd4HHx9QFAm5kZMhOtqRvt55x9Cx4ne/48dOzWNupaC2cNDbFkykVqDCW37WRt2Cu nv5UIhzlNvjOpXM8BYsm623d0+lfWvU02p6FA6RaJTINz++BQvCWnU5IfJ6e/SmkEXGCB97fsZJE 0EBygn8a/TVckcjlnYJaUA33AkfHNuMPuJqMH/ovAJtIvN4sJD8IBWLecQMKoUWRTqo7RdO/rIn0 b0SSZ9SIcfDKugxT/cEXV+YIIKXkeX1wo4/XelkIm13GsNXOH/s3+cntP6+LJpFgGBM5GU0clhlZ Vw4Zee/38G64ULKPD939OhXk0sIlBM2h6F5ud+9IW1PZ7mZFRAkIVfgqGnf2odGz75lgOCraQeqh 7duBvkfR8dLuy2lYOGVdSCplgojXHBv9bZE9opWJvqDIyd9q8LQAimKWUeNQbhEd635J9ejCMLZJ dbtwpi44/HcCCxl7WpUJEL7dDr9712zRPZhcVuV2Rgg5XfRsSllhxNVb1le2mRW8fgFFr6WWqaCX UbDArIuf9Re6xbt8nqIBj7+HqJY4AJGeGJ9TOdKJ9Tp/dlzDUt8ru7q9zPIijPyfu1vTQAgezaIm q+ABP315OMXsHOh5uLIQEHcFjAcXE3BcEiusCWpBHl1H/9B99tYa5uzqmqzntwuvGQQQWuzfZFFO RESb8+Fz18358ikKWRSp6QnkIQFiBGyS6ZQkp4l31uLWIhQZlhTcXuJ+CNC9Ny41LLSMT//U0PUf kvXpD+op+zLPREp22gBtaKyRaKeOjtDad+p9WK6adDJB0jvl6/YVBx9i6dF3hCeRtk7atXtJPnW/ kL2w9F9aWTThN8rho1r8FHBwgQSaCVRTX39RpU5fpWRsU2PZ9gRe7ZIJbXPzMfzOxZYb+WEvLvCk fQrneOEkEHXUn+AganZZRTmaj1Nk3HExA7oK+KZqEX8u4nhJ/fR4Mb9sQ6DcC4kwcT10toREJeHR PQ5EIfsePpRy8qr3sQs4LgUd07JgrELFTFX+6XX6pDWJhaUBHuFDZPyAHaqTyWYul4ZYQtVkrrBq e6Dx0IIgfHuPNL89rtx1+yGWB3sgJL70HewVJff3OQxmfroQgmbVY9A18juiASmo22PAB+uZDDZG 8/MxWlpdbvdjGP8Gs1ZsblEIY0lES7Zi+QJ+PYMnc0hhOyrVI9oBXd4AI6chRV6zy4Ki2SEi03Z0 GuCJsXriGuwcvTsdVkudnYB9qOSsJCOp1xOCjzK02cp9bBlavKueFfpwm91N1b+7acMn3s9LnAJf A1XyQrTyadPyormOytKuzgtWBU2HtLJ/AowLihrdwV8qdwYquCWYVkkMjLYok51xkr4M/IJCqsJn mar0vuWPKtjEC/anbbVVu/6xqIPJp8sUhAPHtVNIqDdC7hQ73sm3GJPlZjPuVXP+mbwznKEnS6hk mcgtFx3GHTskd+Uvzl+qaMcgeZdWbf21J/WBebnqmJzIAEYtd//RNT8fwEwJEbfAq8fAaixro+ri qFA/G6HXy+gzIjJSaltWN3OLD+TSZVqErAPKH1sONAOi+Rjzt/Dt1Rg1DNUJXKNjPGdlSKDIpe+e CXWlHJ+28jnDZZldKCvRv/2eOeixaR8WqIE2YCeZCCqupCcybTSJYoGBq7moGFmNmaQt2057/lmH JkWJ3vDoH7QA268SL5fqiV7jniweU8Dm2rYDS7yZAVVYN6DeQeG35RDEBG1EW+PHUQgY38GdjuQU G1XY6bJ6l69gEOMmz+6FTYXgDMhc6K/qDPBb/AigVlVYDDuBjCrc9zteVjoq9HhFC2afXXL+8lDP Yo5WKmkSoFBBzvHb75P1Ke3wJaZ/TytzPx9uxOqaPYbBjISAIU6vQEZLxEB+f86gMcrimADYa09y e87/7vHN6vPH0qMqbSu2rFTqs8Ay/gv19wG53R/9LX3s2zMm4q+BQ8aGVPXBJQOQbemVJ7tPwTZp EgSJptzAcLeklLlbyk56WDS55rQbn5eml3d7uHUGYcScRKWtoLvZ9VaP1jFS86BljP1YGTlTVtzN +xPpaF7DSVUNyFnAvrgV64SwVnkOF/m+FwHWGGEspdlkAYAacOjY/y94KBvoXsUApEGkpSp3Xl6T 7Av2zQL0uv/zlxESI0/M3gWgj8SnA6Q4bizOS2vxRLgs8QvMArI5Is9fVoxi3zEHdlf8hK/V7ZFb UiaofAxsozQ6GTm1l8wqmo17xJaVizm8K7um+amk1HKdFdH3LnEjpxmVhkahtGndk3u21mf4BDBT 08avMRfetEEB11G9XLCADRV0TPe+UqHJzUnMFI1AFKiSFpHC51uKCHk7iVlqLYi2mJPn5olr+/1T HdBoEmg5X9Q+oc8xZM48bEGMwMnRw/jtd+jV9SC6FHxBeOL9dn1wmWTOU/ruhjlVKb+Jmd1U6gXl DGeY0YnGHqPMFfIL/lpvl/x1k0UjjEDVrBA/UJZ/7oc9obTvTQNYrqDc7ypAtXzwIq+IjHL6/up6 aYzEPugUqhjqVrmUYXladDWPslRwptevHHJ1+H0aicbc6a9tFiQcGkPBXNfUDfqsRaDFKB6Ic5E5 odrwk4KEhEt1WTNKjetg3KOBPiB+ArRvrRlmUPs+vi7jz3LMxNfUytR+ULp/a43yJ26U3pjVJYHj GWgFkHIvnTEKSIkNqvPUREjSbxpCdF4gsnMhZC98ellFke1HDKl0BhUkwLz3Os8gs99L/TNbr5cf na0jfnhvwvv8JeHsKviRNRY/wqF6Q6ou93rICRb8hK5MAs7DU+Sgh3l6W4S1t1z52qlc68OwI53B k3Q10FW1DmofIVo7qtRxv5ZqrBPJbdzmiMp30RSt2lUJ5XVQ7u8Jjs+qt+j02lY3UTpnS5a8U1Ut EdBYvZ4uXY2hGcpamh0aahfoxv3TKVV7dgApC5vA3WyQpgYVp/D6yawn7MFhQbntT02bCpfpAwUw mykF3oLvz5S/q4TmvGIkQvDJpDN0P9HsJeGGrmu7HLQrY9NFDyQjmFFP0CjqsYDGSQUiIzKWOKot +mZESc51lyPHAocsVO66vndcsCgYV2pcYwQqM7Mshep3t84uZ9bUeFYBPfKrHckTLqed4eWNg+aS /S7gy0rvra8iDNHv6qCNDxckovbA58fy47Bh/OAmVeCUo+F+1duf8E3SKxWFqsM0556BgXuPKuVV Bi8pRzoSQYRXkqbCS7lu3nn4aZjeMPxZLHpytgVcpvdRvvY0vQ4Ntt7t6QUxWZJBcu6CdFzZbRWi DEFII7WtPf2ZcSd9zGvRErNaWnEIcti4A/ML3E68T7xzWL3i3jm2/7cVKY19gOnjERSD6B1yNlWD BLEn9f8FGiwK/ymfL8o5t3wMlH/prFt+4e1RPujI9RaYeUBqmNoJ8aydt5fDwuchnHNrZ13o9s8e iH9/WDQdCx0NFew781ZjWwcOSVbMHfP/eWooFaB43rZgrbwSKmn4rSe+vKoy8MNw173PzDSCvH90 gOptGDgcISC9bOdRfRzqzjZq4L/EG/Y/da0kROXNiBgbZUVp6++a8HJAT7CfCra0/16CN0rRw0Ps oedoE4No69zTCIF/7060PwBxuE+fKzW6jc2uhikNh3ImSFCRgCZFJ+aj+XF9rH16TE42RO1SzZsE Wt7Palw+VtTqEkK3MZ4djhw93qrM1/GlrmDuVZFF7ardLsxO3USVJar34Qt9Yph389YUQeoJZ+ZX pPOvAse6Gm5KZjl7x39o0qDPnL0zgsEpvq+i6Qw+AJIG20JacprpXfsPqgjsT41BYCuWSWqdv2Dw 3gf/R4X6A/wfdLz2kx82XszUpKADLesF1vT4zlrH9E9qp/ena//CXRTASn1nUpRLNqKTlKCBk9+u jJhnDoIc8/kMCcuoqriFyEsxOO6eRq7p7FBfeziCn58EW/U/ZU/qHJyvYodsIVR2VpJ11VXVo/vL woWA0xfki1I1dXO7hHjBqTukkxQdT2urSlWNr/Eauin6WYlmpxKdy8raGxJh8QUXG70beMnXdu+j GkfVPHwb0/yzNMXwLtmiIt36JiG08bTIlMWPFbQzCO/qz8xWsWze/1yZWJIKEBHSwxojZM3c9rBz vDMDDvPjHQSmRqCtM/zFv4zuu1uDkdVaRO9m1jYvD+I9fgsHWV7K5eNz505zMUgXUU3ywER2z5pY WwwGjgVW6Zk60nxKSBgE1nAgBkNLLv9o1urm0sMvp2VAwCTMBJY3jxrKo2Giev01modkQ32YeiLS q0kaskeIZo2tV4/rxKscXvwGYTYl5f3JVzU82HfnobbYL8IAHRre//EV+gbul6ul4vIpq3LtSKoF V8frYcG6V4k0srQkA1/loexnmUFhTr9b+bCMKQDFvlLn3ovnBQzwqyACPfYo1PnbcU97c/gCDfAa EBOE4kXjVAOhgHAgfH5TCde6lujVtOqPgv7tLBRjY+Hld0L69czgejJzDKxVy5OXk0/xkOQB/KOH CQ0fBcTUe0am7BB2MDV93zh6wzFlifeF2VOm8WcM3Yq73Mrf540M7BBzzG9vbJ/LKhk7RbuxvyI7 E0u7Q/7rMZyIeQFQtrPz2MYLJ0Wiwdu2XzMGDob8HTLrfOaSG4IFZSs/lvBpahBkmtCHcLuTLGcP IP0J1bvUg2Tmg1UQVYEbOXRxwTlxPxTiSTb0RR94xxGwJUFHBX0BhPGdR1f9WfHS0Lkx+hECvpQQ 9gAeHpXocqHJGHAAQYk1YbLfWnDMqp3SIgnJX7AZJwxzagINP73bgi4q3VTDlc+09Bpts9cZja+E Wpzr3AKoUU+g3aMN0afWeP5OVCtqgBYqGROdmdIxLmfajqe54SI6fsR5AVUXCda00aW6amvneEmK qAMvWzmeMVw0kBn7UrhfgQbjTSH0/5oNrzolnmz4YuGOVPr3cmVEeLVqY8KpWIY1BRxAjFUdNtaa 7J8v6JOu4/i2zpKrCnk81IkZoD1D9r3D2ep3RlMqOvsNLqbHwkpWo7JLIVYr6iuSCH50oN/1hLpx 3trPdLZ91IvTokZPFYd6ezODEvbNGvg/1FrjSzCBcdTsD9h6jko5bqwgrEnLPHxjlIWpE0Dz1xf1 l4CRMwIAz6nV0fZHW2YWxPnTwfQ5qndW4ZZ6mh0q79gqX70FWuC1JTOpmW6Y5E6JrmE4DC0iTSNA /G1x0HgyJoqCFxqlvPZn3CRUfiIQfTTdY8U/csNcG/JQ8cZTwBDuCwNf7Qb9cjCuTISFEcE1f0lF c/VM1ClKNs+3SGDcKWrGeQp/zamEBMNkc1xqIa71BlSWuGIDtLpWGGLBtZy1U7NTDlXRHp6F1j2y AFDvs8fUk0X7O0Q1mZ94z2IKotrFbFLa5VSNI0XQvARldrY0qkjjJIz/SV2rMD83cwPPdHMzSg8i 2r5NMbDAUE+S+OxY3xYYePOJNMj4zFl9revIduDTGiV65SY9EmtvljYzBm9k9sm3JA734OSs9mWM MWzWOO6F24D12WQ3uVxIq4v2oK1KkPiA6mjUk9yWndfTxP0UsoP/r6b4PhRwG+ZHonsj91XUGS6x jjALtCyM4WQ6IKkKsUW50dV2a49jqlLpaPGpPM4lbrPaxnIdTTY6XQj4oCPSAOHrMcs2mqlb0iZa sqGu70tQBPqdTi9cL+MaX+H6AH5DuHt4N1fU/KohUOAOgRtK5eve0W/uOGTmrxga1x3MZ4a5bR06 qE+37lWMU1fRTEeGb1HFhfFAB1BnqdfH68eMFf0AV3JQutDHMFQ4XaWAu55vLsXu94lSpIF/FQJH QCGS7yD2Gc2q81u+ZDncGjxISq349OuXVyZYHx1qveTmqAFtJsGWIkZ8Kq5/V0hVbyw/qDJ9aRC/ /1qRqKhwqgKIuIDSfW5JwejvoZiRiHw7qKwvPV521XCw+bvoqm/GJSLkTxCl9T8l4gehm0cg8mdV tCcZ8kp3OEsYeQf7tNGtGbT65nz/rnJl3tLQDkSfcQGhtneCKKcTqpkYExrHPzMQRGAm3mMwWgrh Zu79uGlnSwDAwg53MMtgpYF/+yhZArvLFtGKqh9yCzujcCQo5TE34TUW86w4WmegN4UnxwmQ8j/m fFHw/1E4IaW7XIanHFK+xfhNP+cAmziwDaUi8YmWCRnQHn5KgO86Nbi/4ZEY5h5/x6Axo6XbPbID MCGIM6aB1E/tZVOqkqsA1um/Bs1Aqm40GJOAs8VlrJ9mjiVoL3K8d9RgHajlZWteKfWeJIE8fQZd y2EurEthAhNJtMuAE9cup/ThvHX1CLUY3GGNvj9UzvW/WUUrYdY5fP+Pt28FFXVHH5oqrfkAAtOA pfF5LJ26j1HDbkgLwQulaibnCI+/h/LR8q4B3/HlEH85ILF7qV2Zs9A2wrKQHzh3MedR93gnBjZs Hi4cvpcjPXNkHY3kyXzswxx3XNe8TUmnVMXdpk+KRHSTCl7mbCEyrALUccJ5IYYnD82ztItF7PmI nSZJPkPUEmoG5o35QEpFA0SKBy1xmcplVWWvW1mF0Q8NVVaOQ9re/ie9HU0B0E3xLELtHSNPXxTm xRQMKSkRqtppdWPxmxmrZ/gYthC+07mS7rJ6ecqZusHF5eT7rjqXhqr0vPF/rbexlXO5XnKt7Tgl HENlIbCY9iDmfWvjNCr8n0TUI2gKGoDsRsWEh75t5hC0FpjKV2yT0a80KvJ1DDBNiHAPz0ZeRdrm 5eCqgVQz0CYj1CBSmN6Xi9XZ0imXbEZ7wB5p/j76VkvtCRwKUQ5CXjrTK5LGeq72BdHcFYpBI5JC YtFPlYHGr3sRqvCCCnVbvIpO4Z4wuOcX3+ltzmY0Z1se7/4UQ6ALUyZumGTIe5vG4B0+SIZPV3Jr fxgP5RrsQ7L/IYT1AOZpT/isnbyEp9mqJhERWEqMa2S88y5ZmYdBDu7J0EKJdsj32jRPWoQZ85ad tPT7LoxULB74l3qdmWiOYVCfEs2NEmVqTvsdhYwG7eHN20X66maNWfHvtDGJQDqUEVYGIo0HCpJL XEesWjcsvuOokyATnxy2Y0A2x1vfWOOpVt2deETI7VDDsyshA5Ys/PYMQjwq3F3lvDUIyhsV/1NM bqiQV6GQj4LkhFC14cYwXd/fHTl0qEUZvqOhw3DHhRP40XnaNavG7rzQ90e4wHhMl6lMJkeSuDcd EXof39jKdArnzSl0Ilzjf8LPUWwVeuIL8+w1mGUOv2Ar+7mShjfQFM2a9AudWxyfzFTUJTXTplSD jb2Iqq+OGO8qgo1wb8BrqX+GXtc3XOsoy+2M2hMWMD5mlG/5yE2NtyDTLC4GKVmUW8LD+sgb12Du PiYCpEzGkPvWDsyoFfc14Btg1Bezyih+fQHUAcXzSxmAXKsYGvUW57YYqjaWX0nNnnG6RFzZBSju JD4voKR9/KaC10/iQlPIufPQeXNBMPOWjed71LX5UBYi9fqRp6wtaDn00KpyukR6qJAJr8+Paqvx c8m5qm0jLtmoLlw0TS2lEvYySF2MEFBffpOUDXGmekWI0MplJjsywHbLwN3El05mznjmunPt/rOr xb6hXpqZ2CD1VqdBhyy4FHNmamINtBEOdd3KGiOG80TI68FOz7RJQs/QZXzyQ3zWsTqGWxZWzlt1 Pr2d1Enlh5UyVjB7Phj6l6aqd6rhhLWYfF/DlULu4sNmL4Qofg4wksUbJXM+db4OwH1WtIn0HAKM yjsIiHmjWcA8ETb7//nfg6tu5rQlpOm9H+eXtiRRv/0/lghG35+pEEHSyvWIeL4LAunwXhqFQmb5 89sNNtfA+xjYSts49lREC3zYFbJLxfA2hwUmlHoGvps34nTndy8GuIc5ecV2/Dk0bTmn5NbhGvfT If/Pbp1THlW129R/rjuYNLGMmGfABRwpU4r4auG6NtBpkgwsSRZXEfI3D+W4lFGDtdmwj4j9b9WQ i9ilN9YTGL6pIOJJGaez2/OJ8zm7qx+qjfa/l6de0NNBjcqT6d/fBPGcjlT18oURphE5bpymZGIg urKHZbl5Y+WR/rIRcsvwEkye9zgGIp4KxoM2fiIcAxQrehui5jxNpbHsUrJPP8HcgkH8jRmutvYd CuOhGKFxXKOiu+6/a0KrRZTnYRTbEHcqpY8x+h4Jdv2I9ZMAxPKAoYT/P693As5gA3/WivvRLWBK /ghyt8eaPuBAG5Fni8VMFNkRjn2IUtUI+9tj2yBZgqKkaxjNyOQz2OC15xjm6KX0Q++J2dVpZafN ew0mE3ul6lDe+t2nlY9RGE/5SXZIjQQEnYamCS0qVG4UZQvy0uyl4hemThT5/AkD/mpJHcjx6f4h X6AdAoC/6q0x71fpiWjI/HbtuawBu87OJ13qix5eAN6wZfrSJNH7+KLHKpvYBOl2svtV/RxzVece QwBTE1QHNDuHb9V19KYSzsx0en5ovhLqWtaBTXpm/127tncn3riVfBkeZIwIejC3d49/pG6EFp9U 2oWhhlZ/6zc1qGXKMSdmeMDvJ1JW4G8Bn59pdY9mjqzmfo+eGONWdEPrvwwgrf7SQ13ujTzb1hax 7qw6Dgah3YHO он закодирован

<?php class ModelAccountCustomer extends Model { public function addCustomer($data) { $this->event->trigger('pre.customer.add', $data); if (isset($data['customer_group_id']) && is_array($this->config->get('config_customer_group_display')) && in_array($data['customer_group_id'], $this->config->get('config_customer_group_display'))) { $customer_group_id = $data['customer_group_id']; } else { $customer_group_id = $this->config->get('config_customer_group_id'); } $this->load->model('account/customer_group'); $customer_group_info = $this->model_account_customer_group->getCustomerGroup($customer_group_id); $this->db->query("INSERT INTO " . DB_PREFIX . "customer SET customer_group_id = '" . (int)$customer_group_id . "', store_id = '" . (int)$this->config->get('config_store_id') . "', firstname = '" . $this->db->escape($data['firstname']) . "', lastname = '" . $this->db->escape($data['lastname']) . "', email = '" . $this->db->escape($data['email']) . "', telephone = '" . $this->db->escape($data['telephone']) . "', fax = '" . $this->db->escape($data['fax']) . "', custom_field = '" . $this->db->escape(isset($data['custom_field']['account']) ? json_encode($data['custom_field']['account']) : '') . "', salt = '" . $this->db->escape($salt = token(9)) . "', password = '" . $this->db->escape(sha1($salt . sha1($salt . sha1($data['password'])))) . "', newsletter = '" . (isset($data['newsletter']) ? (int)$data['newsletter'] : 0) . "', ip = '" . $this->db->escape($this->request->server['REMOTE_ADDR']) . "', status = '1', approved = '" . (int)!$customer_group_info['approval'] . "', date_added = NOW()"); $customer_id = $this->db->getLastId(); $this->db->query("INSERT INTO " . DB_PREFIX . "address SET customer_id = '" . (int)$customer_id . "', firstname = '" . $this->db->escape($data['firstname']) . "', lastname = '" . $this->db->escape($data['lastname']) . "', company = '" . $this->db->escape($data['company']) . "', address_1 = '" . $this->db->escape($data['address_1']) . "', address_2 = '" . $this->db->escape($data['address_2']) . "', city = '" . $this->db->escape($data['city']) . "', postcode = '" . $this->db->escape($data['postcode']) . "', country_id = '" . (int)$data['country_id'] . "', zone_id = '" . (int)$data['zone_id'] . "', custom_field = '" . $this->db->escape(isset($data['custom_field']['address']) ? json_encode($data['custom_field']['address']) : '') . "'"); $address_id = $this->db->getLastId(); $this->db->query("UPDATE " . DB_PREFIX . "customer SET address_id = '" . (int)$address_id . "' WHERE customer_id = '" . (int)$customer_id . "'"); $this->load->language('mail/customer'); $subject = sprintf($this->language->get('text_subject'), html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8')); $message = sprintf($this->language->get('text_welcome'), html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8')) . "\n\n"; if (!$customer_group_info['approval']) { $message .= $this->language->get('text_login') . "\n"; } else { $message .= $this->language->get('text_approval') . "\n"; } $message .= $this->url->link('account/login', '', 'SSL') . "\n\n"; $message .= $this->language->get('text_services') . "\n\n"; $message .= $this->language->get('text_thanks') . "\n"; $message .= html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8'); $mail = new Mail(); $mail->protocol = $this->config->get('config_mail_protocol'); $mail->parameter = $this->config->get('config_mail_parameter'); $mail->smtp_hostname = $this->config->get('config_mail_smtp_hostname'); $mail->smtp_username = $this->config->get('config_mail_smtp_username'); $mail->smtp_password = html_entity_decode($this->config->get('config_mail_smtp_password'), ENT_QUOTES, 'UTF-8'); $mail->smtp_port = $this->config->get('config_mail_smtp_port'); $mail->smtp_timeout = $this->config->get('config_mail_smtp_timeout'); $mail->setTo($data['email']); $mail->setFrom($this->config->get('config_email')); $mail->setSender(html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8')); $mail->setSubject($subject); $mail->setText($message); $mail->send(); // Send to main admin email if new account email is enabled if ($this->config->get('config_account_mail')) { $message = $this->language->get('text_signup') . "\n\n"; $message .= $this->language->get('text_website') . ' ' . html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8') . "\n"; $message .= $this->language->get('text_firstname') . ' ' . $data['firstname'] . "\n"; $message .= $this->language->get('text_lastname') . ' ' . $data['lastname'] . "\n"; $message .= $this->language->get('text_customer_group') . ' ' . $customer_group_info['name'] . "\n"; $message .= $this->language->get('text_email') . ' ' . $data['email'] . "\n"; $message .= $this->language->get('text_telephone') . ' ' . $data['telephone'] . "\n"; $mail = new Mail(); $mail->protocol = $this->config->get('config_mail_protocol'); $mail->parameter = $this->config->get('config_mail_parameter'); $mail->smtp_hostname = $this->config->get('config_mail_smtp_hostname'); $mail->smtp_username = $this->config->get('config_mail_smtp_username'); $mail->smtp_password = html_entity_decode($this->config->get('config_mail_smtp_password'), ENT_QUOTES, 'UTF-8'); $mail->smtp_port = $this->config->get('config_mail_smtp_port'); $mail->smtp_timeout = $this->config->get('config_mail_smtp_timeout'); $mail->setTo($this->config->get('config_email')); $mail->setFrom($this->config->get('config_email')); $mail->setSender(html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8')); $mail->setSubject(html_entity_decode($this->language->get('text_new_customer'), ENT_QUOTES, 'UTF-8')); $mail->setText($message); $mail->send(); // Send to additional alert emails if new account email is enabled $emails = explode(',', $this->config->get('config_mail_alert')); foreach ($emails as $email) { if (utf8_strlen($email) > 0 && preg_match($this->config->get('config_mail_regexp'), $email)) { $mail->setTo($email); $mail->send(); } } } $this->event->trigger('post.customer.add', $customer_id); return $customer_id; } public function editCustomer($data) { $this->event->trigger('pre.customer.edit', $data); $customer_id = $this->customer->getId(); $this->db->query("UPDATE " . DB_PREFIX . "customer SET firstname = '" . $this->db->escape($data['firstname']) . "', lastname = '" . $this->db->escape($data['lastname']) . "', email = '" . $this->db->escape($data['email']) . "', telephone = '" . $this->db->escape($data['telephone']) . "', fax = '" . $this->db->escape($data['fax']) . "', custom_field = '" . $this->db->escape(isset($data['custom_field']) ? json_encode($data['custom_field']) : '') . "' WHERE customer_id = '" . (int)$customer_id . "'"); $this->event->trigger('post.customer.edit', $customer_id); } public function editPassword($email, $password) { $this->event->trigger('pre.customer.edit.password'); $this->db->query("UPDATE " . DB_PREFIX . "customer SET salt = '" . $this->db->escape($salt = token(9)) . "', password = '" . $this->db->escape(sha1($salt . sha1($salt . sha1($password)))) . "' WHERE LOWER(email) = '" . $this->db->escape(utf8_strtolower($email)) . "'"); $this->event->trigger('post.customer.edit.password'); } public function editNewsletter($newsletter) { $this->event->trigger('pre.customer.edit.newsletter'); $this->db->query("UPDATE " . DB_PREFIX . "customer SET newsletter = '" . (int)$newsletter . "' WHERE customer_id = '" . (int)$this->customer->getId() . "'"); $this->event->trigger('post.customer.edit.newsletter'); } public function getCustomer($customer_id) { $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "customer WHERE customer_id = '" . (int)$customer_id . "'"); return $query->row; } public function getCustomerByEmail($email) { $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "customer WHERE LOWER(email) = '" . $this->db->escape(utf8_strtolower($email)) . "'"); return $query->row; } public function getCustomerByToken($token) { $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "customer WHERE token = '" . $this->db->escape($token) . "' AND token != ''"); $this->db->query("UPDATE " . DB_PREFIX . "customer SET token = ''"); return $query->row; } public function getTotalCustomersByEmail($email) { $query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "customer WHERE LOWER(email) = '" . $this->db->escape(utf8_strtolower($email)) . "'"); return $query->row['total']; } public function getRewardTotal($customer_id) { $query = $this->db->query("SELECT SUM(points) AS total FROM " . DB_PREFIX . "customer_reward WHERE customer_id = '" . (int)$customer_id . "'"); return $query->row['total']; } public function getIps($customer_id) { $query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "customer_ip` WHERE customer_id = '" . (int)$customer_id . "'"); return $query->rows; } public function addLoginAttempt($email) { $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "customer_login WHERE email = '" . $this->db->escape(utf8_strtolower((string)$email)) . "' AND ip = '" . $this->db->escape($this->request->server['REMOTE_ADDR']) . "'"); if (!$query->num_rows) { $this->db->query("INSERT INTO " . DB_PREFIX . "customer_login SET email = '" . $this->db->escape(utf8_strtolower((string)$email)) . "', ip = '" . $this->db->escape($this->request->server['REMOTE_ADDR']) . "', total = 1, date_added = '" . $this->db->escape(date('Y-m-d H:i:s')) . "', date_modified = '" . $this->db->escape(date('Y-m-d H:i:s')) . "'"); } else { $this->db->query("UPDATE " . DB_PREFIX . "customer_login SET total = (total + 1), date_modified = '" . $this->db->escape(date('Y-m-d H:i:s')) . "' WHERE customer_login_id = '" . (int)$query->row['customer_login_id'] . "'"); } } public function getLoginAttempts($email) { $query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "customer_login` WHERE email = '" . $this->db->escape(utf8_strtolower($email)) . "'"); return $query->row; } public function deleteLoginAttempts($email) { $this->db->query("DELETE FROM `" . DB_PREFIX . "customer_login` WHERE email = '" . $this->db->escape(utf8_strtolower($email)) . "'"); } }

Он и становиться рабочим только потому что на нем учусь. Есть еще сайт на этом же движке он тестовый так что и на нем можно. это не проблема

все файлы которые необходимы выложу. помогите разобраться

вот что у меня в этом коталоге

Я упорно пытаюсь научиться это делать. я с БД некогда не работал

Добрый день! Имеется сторонняя сборка на opencart 2.1 в ней есть модуль заказа и в нем есть стандартные поля при регистрации и есть возможность добавить свое поле. мне нужно добавить свое поле "номер карты" оно добавляется и отрабатывает как надо и хранит значение в БД. но собственно вопрос в том что бы это поле приходило по почте в стандартной форме регистрации. От разработчиков модуля узнал что данные нового поля храниться в таблице oc_customer_scfield в колонке value сам шаблон письма хранится catalog/model/account/customer.php в блоке: if ($this->config->get('config_account_mail')) { $message = $this->language->get('text_signup') . "\n\n"; $message .= $this->language->get('text_website') . ' ' . html_entity_decode($this->config->get('config_name'), ENT_QUOTES, 'UTF-8') . "\n"; $message .= $this->language->get('text_firstname') . ' ' . $data['firstname'] . "\n"; $message .= $this->language->get('text_lastname') . ' ' . $data['lastname'] . "\n"; $message .= $this->language->get('text_customer_group') . ' ' . $customer_group_info['name'] . "\n"; $message .= $this->language->get('text_email') . ' ' . $data['email'] . "\n"; $message .= $this->language->get('text_telephone') . ' ' . $data['telephone'] . "\n"; добился что бы в письмо приходило но номер карты это только текст, а как значение вставить я не знаю. Прошу помощи знающих людей. Заранее спасибо!

Добрый день! Подскажите есть такая проблема, стоит opencart 2.1 товар выгружается с 1с на сайт, но в характеристиках минимальное количество для заказа стоит 0. товара почти 6000 , есть ли возможность сразу всем товарам поставить 1 вместо 0? Спасибо