ecshop增加红包序列号字符的方法

ALTER TABLE `ecs_user_bonus` CHANGE `bonus_sn` `bonus_sn` VARCHAR( 32 ) NOT NULL DEFAULT '0';

var reg = /^[0-9]{10}$/;

var reg = /^[0-9a-zA-Z]{10}$/;

/* 生成红包序列号 */
//$num = $db->getOne(“SELECT MAX(bonus_sn) FROM “. $ecs->table(‘user_bonus’));
//$num = $num ? floor($num / 10000) : 100000;

for ($i = 0, $j = 0; $i < $bonus_sum; $i++)
{
//$bonus_sn = ($num + $i) . str_pad(mt_rand(0, 9999), 4, ’0′, STR_PAD_LEFT);
$bonus_sn = get_unique_id(10);
$db->query("INSERT INTO ".$ecs->table('user_bonus')." (bonus_type_id, bonus_sn) VALUES(
'$bonus_typeid', '$bonus_sn')");
$j++;
}
/*增加生成随机字符加数字的函数：*/
function get_unique_id($length=32, $pool="")
{
if($pool == "") $pool .= "abcdefghijklmnopqrstuvwxyz0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ
";
mt_srand ((double) microtime() * 1000000);
$unique_id = "";
for ($index = 0; $index < $length; $index++) {
$unique_id .= substr($pool, (mt_rand()%(strlen($pool))), 1);
}
return $unique_id;
}

/* 添加一个红包 */
elseif ($action == 'act_add_bonus')
{
include_once(ROOT_PATH . 'includes/lib_transaction.php');
//$bouns_sn = isset($_POST['bonus_sn']) ? intval($_POST['bonus_sn']) : "";
$bouns_sn = isset($_POST['bonus_sn']) ? trim($_POST['bonus_sn']) : "";
if (add_bonus($user_id, $bouns_sn))
{
show_message($_LANG['add_bonus_sucess'], $_LANG['back_up_page'], 'user.php?act=bonus',
'info');
}
else
{
$err->show($_LANG['back_up_page'], 'user.php?act=bonus');
}
}

$bouns_sn = isset($_POST['bonus_sn']) ? intval($_POST['bonus_sn']) : "";

$bouns_sn = isset($_POST['bonus_sn']) ? trim($_POST['bonus_sn']) : "";

if (is_numeric($bonus_sn))

if (is_string($bonus_sn))