dbExtension.as
Posted: 02 Apr 2011, 10:37
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
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