Get Array out of Hashtable

[zauri2000]

hi community,

I am trying to send a HighScore list from the MySQL DB to my clients.

On my Server AS Script

Code: Select all

if (cmd=="list"){
   var mySql = "SELECT player.Nickname, player.Score FROM player ORDER BY player.Score DESC LIMIT 10"
   var queryRes = dbase.executeQuery(mySql)
   
   var response ={}
   response._cmd="getList"
   response.db = []
   
   if (queryRes != null){
           // Cycle through all records in the ResultSet
           for (var i = 0; i < queryRes.size(); i++){
                   // Get a record
                   var tempRow = queryRes.get(i)
                  
               // This object will hold the record data that we'll send to the client
               var item = {}

                // From the record object we can get each field value
                item.name       = tempRow.getItem("Nickname")
                item.score    = tempRow.getItem("Score")
                     trace(item.name + "   "+item.score)
                response.db.push( item )
   
           }   
    _server.sendResponse(response, fromRoom, null, [user])
     }


On my Clients in Unity :

Code: Select all

void onExtensionResp(object dataObj, string type) {
if (type == SmartFoxClient.XTMSG_TYPE_XML)
          {
              SFSObject responseData = (SFSObject)dataObj;
if (responseData.GetString("_cmd")=="getList"){
         
   // HERE is my problem, how do i get the array out of the Hashtable
         }



}

How did i get the Array data out of my Hashtable ?

best regards
Zauri2000

[zauri2000]

After 5h testing i get the solution

Code: Select all

if (responseData.GetString("_cmd")=="getList"){
            
         SFSObject myObject = responseData.GetObj("db");
         Debug.Log ("Size: "+ myObject.Size());
         for (int i=0; i< myObject.Size();i++){
         Debug.Log(myObject.GetObj(""+i).GetString("name")+' '+myObject.GetObj(""+i).GetString("score"));   
         }