My Extension is drop into folder extension and is loaded on start SFS2X without problem
Server Side :
Extension Global
Code: Select all
package eod.extension;
import com.smartfoxserver.v2.extensions.SFSExtension;
public class EODClassicExtension extends SFSExtension
{
@Override
public void init()
{
trace("EOD Classic Extension Loaded...");
addRequestHandler("get_player_data", PlayerData.class);
}
}
The extension Request
Code: Select all
public class PlayerData extends BaseClientRequestHandler
{
public void init()
{
trace("Player Data Initialised");
}
@Override
public void handleClientRequest(User sender, ISFSObject params)
{
IDBManager dbManager = getParentExtension().getParentZone().getDBManager();
String sql = "SELECT * FROM users";
trace("Get Player Data Request From : " + sender + " database : "+ dbManager.toString());
try
{
// Obtain a result set
ISFSArray res = dbManager.executeQuery(sql, new Object[] {});
// Populate the response parameters
ISFSObject response = new SFSObject();
response.putSFSArray("users", res);
// Send back to requester
send("get_player_data", response, sender);
}
catch (SQLException e)
{
trace("SQL Failed: " + e.toString());
}
}
}
DataBase
Base : EOD
Table : users
In Table ( id, steam_id, steam_name ) i fill field for test
Client Side :
Code: Select all
private void OnExtensionResponse(BaseEvent evt)
{
Debug.Log("Extension Response Receive");
string cmd = (string)evt.Params["cmd"];
SFSObject sfso = (SFSObject)evt.Params["params"];
if (cmd == "get_player_data")
{
Debug.Log(sfso.GetSFSArray("users").ToString());
Debug.Log("SignUp error:" + sfso.GetUtfString("steam_id"));
//if (sfso.GetBool("success"))
// Debug.Log("Success, thanks for registering");
//else
// Debug.Log("SignUp error:" + (string)evt.Params["errorMessage"]);
}
}