Page 1 of 1

dbExtension.as

Posted: 02 Apr 2011, 10:37
by nabeelahmed87
my serverside code is

function handleRequest(cmd, params, user, fromRoom)
{
var loginName=params.name;
trace(loginName)
if (cmd == "getData")
{
var sql = "SELECT * FROM users WHERE username='"+loginName+"'";
var queryRes = dbase.executeQuery(sql)



var response = {}

response._cmd = "getData"


response.db = []


if (queryRes != null)
{

for (var i = 0; i < queryRes.size(); i++)
{
var tempRow = queryRes.get(i)


var item = {}

item.name = tempRow.getItem("username")


response.db.push( item )
}
}
else
{
trace("DB Query failed/ no data found")
response.db.push(-1);
}


_server.sendResponse(response, -1, null, [user]);

}
}
now i am in client side



function onExtensionResponseHandler (evt:SFSEvent):void
{


var type:String = evt.params.type;
var data:Object = evt.params.dataObj;
var command:String = data._cmd;

}

and i want to get username on client side?? what should i do??

i am using smartfox pro 1.6.6.. plz help

Posted: 02 Apr 2011, 20:44
by BigFIsh