{"id":199333,"date":"2025-05-03T13:53:46","date_gmt":"2025-05-03T05:53:46","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199333\/"},"modified":"2025-05-03T13:53:46","modified_gmt":"2025-05-03T05:53:46","slug":"%e4%bf%ae%e6%94%b9ecshop%e7%b3%bb%e7%bb%9f%e7%ba%a2%e5%8c%85%e5%ba%8f%e5%88%97%e5%8f%b7%e8%a7%84%e5%be%8b","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199333\/","title":{"rendered":"\u4fee\u6539ECSHOP\u7cfb\u7edf\u7ea2\u5305\u5e8f\u5217\u53f7\u89c4\u5f8b"},"content":{"rendered":"

ECSHOP\u7cfb\u7edf\u7ebf\u4e0b\u53d1\u653e\u7ea2\u5305\u65f6\u7cfb\u7edf\u751f\u6210\u7684\u7ea2\u5305\u5e8f\u5217\u53f7\u662f\u572810000\u7684\u57fa\u7840\u4e0a\u589e\u52a0\u56db\u4f4d\u968f\u673a\u6570\u5b57\u3002\u5982\u679c\u5f53\u6211\u4eec\u8981\u53d1\u653e\u5927\u989d\u5ea6\u7ea2\u5305\u7684\u65f6\u5019\uff0c\u8fd9\u6837\u7684\u5e8f\u5217\u53f7\u89c4\u5219\u96be\u514d\u7ed9\u4eba\u4e0d\u5b89\u5168\u7684\u611f\u89c9\uff0c\u4e07\u4e00\u771f\u7684\u6709\u54ea\u4e2a\u65e0\u804a\u7684\u4eba,\u7528\u4e00\u5929\u65f6\u95f4\u6765\u8499\u51e0\u4e2a\u7ea2\u5305\u5e8f\u5217\u53f7\u51fa\u6765\uff0c\u90a3\u5c31\u4e8f\u5927\u4e86\u3002\u56e0\u4e3a\u6700\u591a\u53ea\u8981\u8bd510000\u6b21\u5c31\u53ef\u4ee5\u4e86\uff0c\u6240\u4ee5\u6211\u4eec\u9700\u8981\u66f4\u6539\u4e00\u4e0b\u7cfb\u7edf\u7684\u7ea2\u5305\u5e8f\u5217\u53f7\u53d1\u653e\u89c4\u5219\uff0c\u8ba9\u7ea2\u5305\u7684\u5e8f\u5217\u53f7\u662f\u7531a-z\uff0cA-Z\uff0c0-9\u7684\u5b57\u7b26\u7ec4\u5408\u800c\u6210\uff0c\u4e0b\u9762\u7ed9\u51fa\u4fee\u6539\u65b9\u6cd5\uff1a
 <\/p>\n

1\u3001\u4fee\u6539ecs_user_bonus\u8868\u4e2dbonus_sn\u5b57\u6bb5\u7684\u6570\u636e\u7c7b\u578b<\/p>\n

ECSHOP 2.7.2\u4e2d\u8be5\u5b57\u6bb5\u7c7b\u578b\u4e3abigint\uff0c\u6211\u4eec\u9700\u8981\u4fee\u6539\u4e3avarchar\u3002<\/p>\n

ALTER TABLE  `ecs_user_bonus` CHANGE  `bonus_sn`  `bonus_sn` VARCHAR( 32 ) NOT NULL DEFAULT  \u20190\u2032
 <\/p>\n

2\u3001\u4fee\u6539js\/user.js\u6587\u4ef6\u4e2d\u5bf9\u7ea2\u5305\u5e8f\u5217\u53f7\u9a8c\u8bc1\u7684\u90e8\u5206
 <\/p>\n

\u5728\u6587\u4ef6\u7684672\u884c\u5de6\u53f3\uff0c\u627e\u5230<\/p>\n

var reg = \/^[0-9]{10}$\/;<\/p>\n

\u4fee\u6539\u4e3a\uff1a<\/p>\n

var reg = \/^[0-9a-zA-Z]{10,32}$\/;
 <\/p>\n

3\u3001\u4fee\u6539admin\/bonus.php  \u6587\u4ef6\u4e2d\u7ea2\u5305\u5e8f\u5217\u53f7\u751f\u6210\u89c4\u5219<\/p>\n

 <\/p>\n

\u5728\u6587\u4ef6\u7684569\u884c\u5de6\u53f3\uff0c\u6ce8\u91ca\u6389\u5982\u4e0b\u4e24\u884c\uff1a<\/p>\n

\/* \u751f\u6210\u7ea2\u5305\u5e8f\u5217\u53f7 *\/
\/\/$num = $db->getOne(\u201cSELECT MAX(bonus_sn) FROM \u201c. $ecs->table(\u2018user_bonus\u2019));
\/\/$num = $num ? floor($num \/ 10000) : 100000;<\/p>\n

\u4fee\u6539for\u5faa\u73af\u4e2d\u5e8f\u5217\u53f7\u7684\u751f\u6210\u89c4\u5219\u5982\u4e0b\uff1a<\/p>\n

for ($i = 0, $j = 0; $i < $bonus_sum; $i++)
{
\/\/$bonus_sn = ($num + $i) . str_pad(mt_rand(0, 9999), 4, \u20190\u2032, STR_PAD_LEFT);
$bonus_sn = get_unique_id(10);
$db->query(\u201cINSERT INTO \u201c.$ecs->table(\u2018user_bonus\u2019).\u201d (bonus_type_id, bonus_sn) VALUES(\u2018$bonus_typeid\u2019, \u2018$bonus_sn\u2019)\u201d);<\/p>\n

$j++;
}<\/p>\n

\u589e\u52a0\u751f\u6210\u968f\u673a\u5b57\u7b26\u52a0\u6570\u5b57\u7684\u51fd\u6570\uff1a<\/p>\n

function get_unique_id($length=32, $pool=\u201d\u201d)
{
if($pool == \u201c\u201d) $pool .= \u201cabcdefghijklmnopqrstuvwxyz0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ\u201d;
mt_srand ((double) microtime() * 1000000);
$unique_id = \u201c\u201d;
for ($index = 0; $index < $length; $index++) {
$unique_id .= substr($pool, (mt_rand()%(strlen($pool))), 1);
}
return $unique_id;
}<\/p>\n

 <\/p>\n

4\u3001\u4fee\u6539user.php\u4e2d\u6dfb\u52a0\u7ea2\u5305\u7684\u9a8c\u8bc1\u90e8\u5206<\/p>\n

\u5728\u6587\u4ef6\u7684768\u884c \u5de6\u53f3\uff1a<\/p>\n

\/* \u6dfb\u52a0\u4e00\u4e2a\u7ea2\u5305 *\/
elseif ($action == \u2018act_add_bonus\u2019)
{
include_once(ROOT_PATH . \u2018includes\/lib_transaction.php\u2019);<\/p>\n

\/\/$bouns_sn = isset($_POST[‘bonus_sn’]) ? intval($_POST[‘bonus_sn’]) : \u201d;
$bouns_sn = isset($_POST[‘bonus_sn’]) ? trim($_POST[‘bonus_sn’]) : \u201d;<\/p>\n

if (add_bonus($user_id, $bouns_sn))
{
show_message($_LANG[‘add_bonus_sucess’], $_LANG[‘back_up_page’], \u2018user.php?act=bonus\u2019, \u2018info\u2019);
}
else
{
$err->show($_LANG[‘back_up_page’], \u2018user.php?act=bonus\u2019);
}
}<\/p>\n

\u5c06\u539f\u6765\u7684<\/p>\n

$bouns_sn = isset($_POST[‘bonus_sn’]) ? intval($_POST[‘bonus_sn’]) : \u201d;<\/p>\n

\u4fee\u6539\u4e3a\uff1a<\/p>\n

$bouns_sn = isset($_POST[‘bonus_sn’]) ? trim($_POST[‘bonus_sn’]) : \u201d;<\/p>\n

 <\/p>\n

5\u3001\u4fee\u6539\u8d2d\u7269\u6d41\u7a0b\u4e2d\u7ed3\u7b97\u90e8\u5206\u7684\u7ea2\u5305\u5e8f\u5217\u53f7\u9a8c\u8bc1<\/p>\n

flow.php \u6587\u4ef6 1914\u884c \u5de6\u53f3\uff0c\u627e\u5230<\/p>\n

if (is_numeric($bonus_sn))<\/p>\n

\u66f4\u6539\u4e3a<\/p>\n

if (is_string($bonus_sn))<\/p>\n

\u5230\u8fd9\u91cc\u4fee\u6539\u5c31\u5b8c\u6210\u4e86\uff0c\u540e\u53f0\u6e05\u9664\u4e0b\u7f13\u5b58\u5c31\u53ef\u4ee5\u4e3a\u7ea2\u5305\u751f\u6210\u5b57\u6bcd\u52a0\u6570\u5b57\u7684\u5e8f\u5217\u53f7\u4e86\uff0c\u73b0\u5728\u751f\u6210\u7684\u5e8f\u5217\u53f7\u662f\u7531a-z\u3001A-Z\u4ee5\u53ca0-9\u7ec4\u6210\uff0c\u5b89\u5168\u6027\u9ad8\u7684\u540c\u65f6\uff0c\u4e5f\u907f\u514d\u4e86\u5927\u6279\u91cf\u53d1\u653e\u5bfc\u81f4\u7684\u5e8f\u5217\u53f7\u91cd\u590d\u95ee\u9898\u3002<\/p>\n

\u95ee\u9898:\u5b9e\u9645\u4e2d\uff0c\u5e94\u8be5\u5728\u6dfb\u52a0\u7ea2\u5305\u7c7b\u578b\u7684\u65f6\u5019\u6307\u5b9a\u751f\u6210\u7ea2\u5305\u7684\u89c4\u5219\uff0c\u6bd5\u7adf\u6bcf\u6b21\u6d3b\u52a8\u7684\u89c4\u5219\u53ef\u80fd\u4e0d\u540c\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

ECSHOP\u7cfb\u7edf\u7ebf\u4e0b\u53d1\u653e\u7ea2\u5305\u65f6\u7cfb...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4925],"tags":[],"class_list":["post-199333","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199333","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/comments?post=199333"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199333\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}