Photon + GetRoomList + SqlLobby

Community Showcases
1

Heres what i am trying to do. I am creating a room in Unity Photon by passing in room optiosn and sqllobby. That does work but when i try to call GetRoomList, its empty. Is there no way of getting the list of rooms?
http://forum.exitgames.com/viewtopic.php?f=17&t=4829

What I wanted to do was something like this, so that i would be able to show how many players were in a room with that gametype. But apparently getroomList does not work with the sqllobby type.

        {
            if(playersOnlineText)
            {
                int playersInRoom = 0;
                RoomInfo[] roomInfo = PhotonNetwork.GetRoomList();
                int roomCount = 0;
                if(playersOnlineText)
                {
                    playersOnlineText.text = "Connected to Photon";
                }
                for(int i=0; i<roomInfo.Length; i++)
                {
                    if(roomInfo[i].open)
                    {
                        ExitGames.Client.Photon.Hashtable h = roomInfo[i].customProperties;
                        int gameType = (int)h["C1"];
                        if(gameType==Constants.getGameType())
                        {
                            roomCount++;
                        }
                    }
                    if(playersOnlineText)
                    {
                        playersOnlineText.text = "Players in Room:" + roomCount;
                    }

                }
            }

Okay I solved it turns out all i had to do was set the autoJoinLobby to false
PhotonNetwork.autoJoinLobby=false;

And then add

voidOnConnectedToMaster()
{
Debug.Log (“onConnectedToMaster”);
TypedLobbysqlLobby = newTypedLobby(“MyLobby”, LobbyType.SqlLobby);
PhotonNetwork.JoinLobby(sqlLobby);
}

2

The SQL Lobby does not have a room listing. It’s a special case for extended server-side matchmaking via JoinRandomRoom().

See this page’s SQL Lobby topic:

Let me know how you do. Sorry we missed your topic before.

3

Are you sure because it seemed to work, or maybe I changed something.

4

The SQL Lobby never shows rooms. Maybe you switched from the default lobby?

5

In the PhotonServerSettings you can check EnableLobbyStatistics. This allows the server to send you an event with the stats of lobbies in use and how many players and rooms there are.
Implement ILobbyCallbacks.OnLobbyStatisticsUpdate and handle the callback while being in the Master Server.

6

There is nothing else to add, as far as I can tell.
If you are stuck, explain your issue and what you tried.

7

Use the code tags (in posts). Makes it a lot easier to read.

The lobbies don’t exist unless there is a room belonging to the lobby. So you won’t see much, if you only use one client.
You can set EnableLobbyStatistics via the PhotonServerSettings config and using ConnectUsingSettings. Implement OptionalInfoCallbacks.OnLobbyStatisticsUpdate, to get the list of used lobbies (via callbacks).

8

I named the relevant APIs but don’t have specific sample code, sorry.
Check the docs and read the API manual for the methods and values.