Need helps and an example of tranfering MS SQL data to Unity

[rivon3003]

I have an problem in database conection, get data from MS SQL, and add Data to MS SQL when using SmartFoxServer 2x with Unity (C#) and Microsoft SQL Server. Could someone gives me an completed example that can help me understand how to use SmartFox. Thank you so much!

My email: rivon.programmer@gmail.com

[Lapo]

Hi,
the type of language/technology used on the client side is irrelevant to the usage of a database because all DB interaction is done on the server side, via Extensions.

Are you familiar with how Extensions works in SmartFoxServer 2X?
If not I would highly recommend to check this video from our YouTube Channel:
https://www.youtube.com/watch?v=nKGxhwJ ... 94B9D7C3E5

and read more details in our documentation:
http://docs2x.smartfoxserver.com/Advanc ... extensions

Here's how you can setup SFS2X to use your database:
http://docs2x.smartfoxserver.com/Gettin ... wtos#item2

Here're code examples:
http://docs2x.smartfoxserver.com/Develo ... se-recipes

cheers

[rivon3003]

CustomLogin.zip

(1.68 KiB) Downloaded 538 times

Thanks so much for your help. I followed all doc on SFS tutorials and try to create my own project in Unity, but my practice (it attached in CustomLogin.zip) is still not woking. I use LoginRequest but SFSEvent doesnt handle, otherwise It doesnt show any error or warning to me. I dont know what I need to fix.

[mephi]

To use custom login you must check this:
<isCustomLogin>true</isCustomLogin>
in your zone.xml config.
Otherwise the user_login event will not be fired.

[Lapo]

Instead of writing your own Login handler you may use the LoginAssistant Component which provides a lot of helpful features for checking user credentials against a database.

Please see the documentation here:
http://docs2x.smartfoxserver.com/Develo ... -assistant

Tutorial here:
http://docs2x.smartfoxserver.com/Exampl ... gnup-login

[rivon3003]

Thanks "Mephi" and "Lapo" so much. My problem is solved but I do Remote debug and it throws "The source attachment does not contain the source for the file SFSEvent.class" , though I attached sfs2x.jar in my SmartFox Server. My error state is in my attachment file.

[Lapo]

That's normal, rivon.
The jar file doesn't contain the sources, only the compiled bytecode, therefore you get that message if you double click on the class file name in the debugger.

cheers

[rivon3003]

I understood SFS 2x more clearly when I follow your helps. Thanks Lapo again and a lots .