shell修改充值点代码

作者:石中武圣

#/bin/bash
#为游戏某个账号充值点数；
#DB_HOST 主机地址
#DB_NAME 数据名称
#DB_USER 用户名
#DB_PASS 数据库密码
#point 需要充值的点数#
DB_HOST="127.0.0.1"
DB_NAME="web"
DB_USER="root"
DB_PORT="3306"
DB_PASS="8888888"
echo "请输入游戏账号:"
read user
username="${user}@game.sohu.com"
echo "请输入需要充值的点数："
read point
mysql -h "$DB_HOST" -P "$DB_PORT" -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" -e "UPDATE account SET point='$point' WHERE name='$username';"
# 检查结果
echo "正在为 '$username' 充值 $point点"

# 执行更新并获取影响行数
UPDATED_POINT=$(mysql -h "$DB_HOST" -P "$DB_PORT" -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" -sN -e "select point from account where name='$username'")
 if [ "$UPDATED_POINT" -eq "$point" ]; then
    echo "✅ 充值成功！'$username'当前拥有$point充值点。"
  else
    echo "❌ 充值失败：未找到账号 '$username'，请确认账号正确。"
 fi