学习通讯框架源码 Mysql数据库操作

bool ＝ Processing_Receive_login (Receive_Data, Username, Password) ' 解析帐号密码
.如果真 (bool)
bool ＝ 假
调试输出 (Username, Password)
' SELECT * FROM `userinfo` WHERE `username` LIKE '“”'
' 查询帐号是否注册’
Permit.进入 ()
bool ＝ 执行SQL语句 (Mysql_linkhandle, “SELECT * FROM `userinfo` WHERE `username` LIKE '” ＋ Username ＋ “' AND `password` LIKE '” ＋ Password ＋ “'”) ' 查询帐号密码是否正确
记录集_句柄 ＝ 取记录集 (Mysql_linkhandle)
记录数 ＝ 取记录集行数 (记录集_句柄)
读字段值 (记录集_句柄, “customer_handle”, Customer_handle_s)
Permit.退出 ()
.判断开始 (记录数 ≥ 1)
' 发送被顶号信息
.如果真 (Customer_handle_s ≠ Customer_handle) ' 当已存客户句柄跟目前句柄不同时候则判定为异常登录’
Server_side.发送文本 (Customer_handle_s, Processing_Send_Text (#Text_cover_login, G_uuid))
.如果真结束
Permit.进入 ()
G_uuid ＝ _G_uuid ()
bool ＝ 执行SQL语句 (Mysql_linkhandle, “UPDATE `userinfo` SET `tooken` = '” ＋ G_uuid ＋ “', `ip` = '” ＋ Customer_IP ＋ “', `customer_handle` = '” ＋ 到文本 (Customer_handle) ＋ “' WHERE `username` LIKE '” ＋ Username ＋ “' AND `password` LIKE '” ＋ Password ＋ “'”) ' 更新GUUID
Permit.退出 ()
DATA_Text ＝ Processing_Send_Text (#Text_Account_login_ok, G_uuid)
.默认
DATA_Text ＝ Processing_Send_Text (#Text_Account_login_No, G_uuid)
.判断结束
Server_side.发送文本 (Customer_handle, DATA_Text)