// ルーム一覧リクエスト待ち受け
private void Exec_WaitReqRoomList(ref ServerChildJob job)
{
if (job.recvBuffer.Count > 0)
{
foreach (ArraySegment<byte> seg in job.recvBuffer)
{
byte[] bytes = seg.Array;
if (WWProtocolV1Helper.IsCmdV1(bytes) &&
WWProtocolV1Helper.GetCmd(bytes) == WWProtocolV1Helper.Cmd.CMD_REQ_ROOM_LIST
)
{
try
{
Sqlite3.sqlite3_exec(job.mainDb, "BEGIN", 0, 0, 0);
int rc = Sqlite3.sqlite3_exec(job.mainDb, "SELECT * FROM room;", 0, 0, 0);
if (rc != Sqlite3.SQLITE_OK)
{
Exception e = new Exception("sqlite3_exec error.");
throw e;
}
Sqlite3.sqlite3_exec(job.mainDb, "COMMIT", 0, 0, 0);
// 処理したのでバッファから削除
job.recvBuffer.Remove(seg);
}
catch (Exception e)
{
job.WriteLog(TraceEventType.Error, e.Message);
// 途中でエラー発生ならロールバック
Sqlite3.sqlite3_exec(job.mainDb, "ROLLBACK", 0, 0, 0);
}
}
}
}
}
// ユーザ情報パケット待ち受け
private void Exec_UserInfo(ref ServerChildJob job, byte[] bytes)
{
UserInfoPacket packet = new UserInfoPacket();
if (WWProtocolV1Helper.GetUserInfoPacket(ref packet, bytes))
{
try
{
job.userName = packet.name;
job.userComment = packet.comment;
// ユーザ情報をDbに登録
Sqlite3.sqlite3_exec(job.mainDb, "BEGIN", 0, 0, 0);
int rc = Sqlite3.sqlite3_exec(
job.mainDb,
"INSERT INTO user (id, room_id, name, comment) value (" +
job.socketID.ToString() + ", " +
job.roomID.ToString() + ", " +
"'" + job.userName + "', " +
"'" + job.userComment + "')",
0, 0, 0);
if (rc != Sqlite3.SQLITE_OK)
{
Exception e = new Exception("sqlite3_exec error.");
throw e;
}
Sqlite3.sqlite3_exec(job.mainDb, "COMMIT", 0, 0, 0);
// OKパケットをクライアントへ送信
byte[] okPacket = WWProtocolV1Helper.CreateOkPacket(++job.packetNum);
job.sendBuffer.Add(new ArraySegment<byte>(okPacket));
}
catch (Exception e)
{
job.WriteLog(TraceEventType.Error, e.Message);
// 途中でエラー発生ならロールバック
Sqlite3.sqlite3_exec(job.mainDb, "ROLLBACK", 0, 0, 0);
}
}
}
// メッセージ送信
private void Exec_SendMsg(ref ServerChildJob job, byte[] bytes)
{
}
// ルーム一覧リクエスト
private void Exec_ReqRoomList(ref ServerChildJob job, byte[] bytes)
{
try
{
List<RoomListPacket> list = new List<RoomListPacket>();
// Dbからルーム一覧を取得
Sqlite3.sqlite3_exec(job.mainDb, "BEGIN", 0, 0, 0);
int rc = Sqlite3.sqlite3_exec(job.mainDb, "SELECT * FROM room;", ReqRoomListCallback, list, 0);
if (rc != Sqlite3.SQLITE_OK)
{
Exception e = new Exception("sqlite3_exec error.");
throw e;
}
Sqlite3.sqlite3_exec(job.mainDb, "COMMIT", 0, 0, 0);
// 1つでも取得できればクライアントへ送信
if (list.Count > 0)
{
byte[] beginPacket = WWProtocolV1Helper.CreateBeginRoomListPacket(++job.packetNum);
job.sendBuffer.Add(new ArraySegment<byte>(beginPacket));
foreach (RoomListPacket var in list)
{
byte[] packet = WWProtocolV1Helper.CreateRoomListPacket(
++job.packetNum,
var.name,
var.comment,
var.numMenber,
var.maxMenber);
job.sendBuffer.Add(new ArraySegment<byte>(packet));
}
byte[] endPacket = WWProtocolV1Helper.CreateEndRoomListPacket(++job.packetNum);
job.sendBuffer.Add(new ArraySegment<byte>(endPacket));
}
}
catch (Exception e)
{
job.WriteLog(TraceEventType.Error, e.Message);
// 途中でエラー発生ならロールバック
Sqlite3.sqlite3_exec(job.mainDb, "ROLLBACK", 0, 0, 0);
}
}
// ルーム加入
private void Exec_JoinRoom(ref ServerChildJob job, byte[] bytes)
{
try
{
String roomName = WWProtocolV1Helper.GetJoinRoomPacket(bytes);
List<int> roomIDList = new List<int>();
Sqlite3.sqlite3_exec(job.mainDb, "BEGIN", 0, 0, 0);
int rc = Sqlite3.sqlite3_exec(job.mainDb, "SELECT id FROM room WHERE name = '" + roomName + "' ;", GetIDCallback, roomIDList, 0);
if (rc != Sqlite3.SQLITE_OK)
{
Exception e = new Exception("sqlite3_exec error.");
throw e;
}
Sqlite3.sqlite3_exec(job.mainDb, "COMMIT", 0, 0, 0);
// ルーム加入処理
if (roomIDList.Count > 0)
{
job.roomID = roomIDList[0];
job.roomName = roomName;
Sqlite3.sqlite3_exec(job.mainDb, "BEGIN", 0, 0, 0);
rc = Sqlite3.sqlite3_exec(
job.mainDb,
"UPDATE user SET room_id = " + job.roomID.ToString() + " WHERE name = '" + job.roomName + "' ;",
0, 0, 0);
if (rc != Sqlite3.SQLITE_OK)
{
Exception e = new Exception("sqlite3_exec error.");
throw e;
}
Sqlite3.sqlite3_exec(job.mainDb, "COMMIT", 0, 0, 0);
// OKパケットをクライアントへ送信
byte[] packet = WWProtocolV1Helper.CreateOkPacket(++job.packetNum);
job.sendBuffer.Add(new ArraySegment<byte>(packet));
}
else
{
// 見つからなかったのでFailedパケットをクライアントへ送信
byte[] packet = WWProtocolV1Helper.CreateFailedPacket(++job.packetNum);
job.sendBuffer.Add(new ArraySegment<byte>(packet));
}
}
catch (Exception e)
{
job.WriteLog(TraceEventType.Error, e.Message);
// 途中でエラー発生ならロールバック
Sqlite3.sqlite3_exec(job.mainDb, "ROLLBACK", 0, 0, 0);
}
}
// ルーム退室
private void Exec_ByeRoom(ref ServerChildJob job, byte[] bytes)
{
// 未加入ならすぐ戻る
if (job.roomID < 0)
{
return;
}
try
{
Sqlite3.sqlite3_exec(job.mainDb, "BEGIN", 0, 0, 0);
int rc = Sqlite3.sqlite3_exec(
job.mainDb,
"UPDATE user SET room_id = -1 WHERE name = '" + job.roomName + "' ;",
0, 0, 0);
if (rc != Sqlite3.SQLITE_OK)
{
Exception e = new Exception("sqlite3_exec error.");
throw e;
}
Sqlite3.sqlite3_exec(job.mainDb, "COMMIT", 0, 0, 0);
job.roomID = -1;
job.roomName = "";
// OKパケットをクライアントへ送信
byte[] packet = WWProtocolV1Helper.CreateOkPacket(++job.packetNum);
job.sendBuffer.Add(new ArraySegment<byte>(packet));
}
catch (Exception e)
{
job.WriteLog(TraceEventType.Error, e.Message);
// 途中でエラー発生ならロールバック
Sqlite3.sqlite3_exec(job.mainDb, "ROLLBACK", 0, 0, 0);
}
}
// 切断要求
private void Exec_Bye(ref ServerChildJob job, byte[] bytes)
{
}
// 接続処理用コールバック
private static void AcceptCallback(IAsyncResult ar)
{
AcceptWorker server = (AcceptWorker)ar.AsyncState;
Socket listener = server.listenerSocket;
Socket worker = null;
if (listener == null)
{
return;
}
try
{
worker = listener.EndAccept(ar);
// クライアント用ソケットをリストに追加
int id = Interlocked.Increment(ref server.workerSocketId);
server.workerSocketHash.Add(id, worker);
// 接続処理を再開
server.acceptDone.Set();
// ログにクライアント情報を出力
{
IPEndPoint remoteEP = (IPEndPoint)worker.RemoteEndPoint;
server.WriteLog(TraceEventType.Information, "Connected from -- [" + remoteEP.Address + "]");
}
ServerChildJob clientJob = null;
{
ServerChildJobState state = new ServerChildJobState();
state.socketID = id;
state.workerSocket = worker;
state.traceLog = server.traceLog;
state.mainDb = server.mainDb;
clientJob = new ServerChildJob(state);
}
// クライアント応対処理
while (!clientJob.IsShutdown())
{
clientJob.Update();
Thread.Sleep(0);
}
// クライアント用ソケットをから削除
server.workerSocketHash.Remove(id);
}
catch (Exception e)
{
server.WriteLog(TraceEventType.Error, "AcceptCallback: " + e.Message);
}
finally
{
// 終了処理
if (worker != null)
{
if (worker.Connected)
{
worker.Shutdown(SocketShutdown.Both);
}
worker.Close();
}
}
}