用网站来注册奇迹MU的账号
Published: Comment: No Comments
Last Modified:2025-09-03 21:06:48
现在用ASP+mssql数据库写一个MU账号注册的示例，学会运用此方便就可以不用再找GM工具注册账号了
<%
' 处理表单提交
If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
Call ProcessRegistration()
End If
' 注册处理函数
Sub ProcessRegistration()
' 数据库连接参数 - 请根据实际环境修改
Dim connStr
connStr = "Provider=SQLOLEDB;Data Source=你的服务器地址;Initial Catalog=muonline;User Id=你的用户名;Password=你的密码;"
' 获取表单数据
Dim username, password, email, character
username = Trim(Request.Form("username"))
password = Trim(Request.Form("password"))
email = Trim(Request.Form("email"))
character = Trim(Request.Form("character"))
' 基本验证
If username = "" Or password = "" Or email = "" Then
Response.Write "<script>alert('所有字段都必须填写！');</script>"
Exit Sub
End If
' 检查用户名长度 (MU通常要求5-10个字符)
If Len(username) < 5 Or Len(username) > 10 Then
Response.Write "<script>alert('用户名长度必须在5-10个字符之间！');</script>"
Exit Sub
End If
' 检查密码长度
If Len(password) < 4 Or Len(password) > 10 Then
Response.Write "<script>alert('密码长度必须在4-10个字符之间！');</script>"
Exit Sub
End If
Dim conn, rs, sql
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
On Error Resume Next ' 启用错误处理
' 打开数据库连接
conn.Open connStr
If Err.Number <> 0 Then
Response.Write "<script>alert('数据库连接失败！');</script>"
Exit Sub
End If
' 检查用户名是否已存在
sql = "SELECT COUNT(*) AS userCount FROM MEMB_INFO WHERE memb___id = '" & Replace(username, "'", "''") & "'"
rs.Open sql, conn
If rs("userCount") > 0 Then
Response.Write "<script>alert('用户名已存在，请选择其他用户名！');</script>"
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
Exit Sub
End If
rs.Close
' 插入新用户到MEMB_INFO表
sql = "INSERT INTO MEMB_INFO (memb___id, memb__pwd, memb_name, sno__numb, post_code, addr_info, " & _
"addr_deta, tel__numb, mail_addr, phon_numb, fpas_ques, fpas_answ, job__code, " & _
"appl_days, modi_days, out__days, true_days, mail_chek, bloc_code, ctl1_code) " & _
"VALUES ('" & Replace(username, "'", "''") & "', '" & Replace(password, "'", "''") & "', " & _
"'" & Replace(character, "'", "''") & "', '111111', '111111', 'MU', 'MU', '111111', " & _
"'" & Replace(email, "'", "''") & "', '111111', '问题', '答案', 0, " & _
"GETDATE(), GETDATE(), GETDATE(), 0, 1, 0, 0)"
conn.Execute sql
If Err.Number <> 0 Then
Response.Write "<script>alert('注册失败，请稍后再试！错误: " & Err.Description & "');</script>"
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
Exit Sub
End If
' 插入账户货币信息 (根据实际表结构调整)
sql = "INSERT INTO AccountCharacter (Id, GameIDC, Money) VALUES ('" & Replace(username, "'", "''") & "', '" & Replace(character, "'", "''") & "', 0)"
conn.Execute sql
' 关闭连接
conn.Close
Set conn = Nothing
Response.Write "<script>alert('注册成功！现在可以登录游戏了。');</script>"
End Sub
%>
<!DOCTYPE html>
<html>
<head>
<title>奇迹MU账号注册</title>
<meta charset="utf-8">
<style>
body {
font-family: Arial, sans-serif;
background-color: #f0f0f0;
margin: 0;
padding: 20px;
background-image: url('mu_background.jpg'); /* 可替换为MU主题背景 */
background-size: cover;
}
.container {
width: 400px;
margin: 50px auto;
background-color: rgba(255, 255, 255, 0.9);
padding: 20px;
border-radius: 10px;
box-shadow: 0 0 10px rgba(0, 0, 0, 0.3);
}
h2 {
text-align: center;
color: #d9534f;
}
.form-group {
margin-bottom: 15px;
}
label {
display: block;
margin-bottom: 5px;
font-weight: bold;
}
input[type="text"], input[type="password"], input[type="email"] {
width: 100%;
padding: 8px;
border: 1px solid #ccc;
border-radius: 4px;
box-sizing: border-box;
}
input[type="submit"] {
background-color: #d9534f;
color: white;
padding: 10px 15px;
border: none;
border-radius: 4px;
cursor: pointer;
width: 100%;
font-size: 16px;
}
input[type="submit"]:hover {
background-color: #c9302c;
}
.note {
font-size: 12px;
color: #777;
margin-top: 5px;
}
</style>
</head>
<body>
<div class="container">
<h2>奇迹MU账号注册</h2>
<form method="post" action="<%= Request.ServerVariables("SCRIPT_NAME") %>">
<div class="form-group">
<label for="username">用户名:</label>
<input type="text" id="username" name="username" required maxlength="10">
<div class="note">5-10个字符，只能使用字母和数字</div>
</div>
<div class="form-group">
<label for="password">密码:</label>
<input type="password" id="password" name="password" required maxlength="10">
<div class="note">4-10个字符</div>
</div>
<div class="form-group">
<label for="email">电子邮箱:</label>
<input type="email" id="email" name="email" required>
</div>
<div class="form-group">
<label for="character">账号别名:</label>
<input type="text" id="character" name="character" required maxlength="10">
<div class="note">账号别名</div>
</div>
<div class="form-group">
<input type="submit" value="注册账号">
</div>
</form>
</div>
</body>
</html>