DB calls and Global Monitoring

[arcady87]

hello! lately i have been reading many posts and topics about “security”. simply, the extraction of sensitive data from your own sources seems definitely to much easier. now i’m terrified, literally disappointed.

at least, how could i “protect” any request from/to MySQL? is there any real risk that user(s) themselves can send (by manipulating) such links?

example: //website/score.php?username=JohnDoe&score=10

in this forum, manys suggest to use WWWForm() instead of “plain” String variables. is this a “real” solution or just an attempt to “mask” the process?

there, my second question. let’s imagine a peer-to-peer system.
can you let users chat even if they are NOT connected to the same server?

example: //John and Jack are already playing, Tom is not.
how can Tom chat with John(or)Jack?
how can Jack know if Tom is online?

obviously many other questions can be related to this thought. i noticed this limited feature around Robocraft (indie game, developed by Freejam with Unity3D): friends can chat to each other only if-and-when they are in the menu.

shortly, is it possible to force a client to send and receive datas from two different sources? can i code and manage 2 sockets at the same time (MasterServer’s excluded)? maybe, by sending/retrieving data from another external application? @_@

i referred to this answer, but it sounded alien to me:

Multiple Server-Instances on one pc

my stupid idea is to save/store all the “offline” messages into the database (kinda buffer) and clean it when users relog. does it make any sense?

thanks ahead time for your dealing.
-arcady87

PS. please, excuse me if my questions sound silly. be patient. thanks.

[TehGM]

Am answer only few of your questions, as I am currently tired so I prefer to only say what I know 100% and can think of atm lol.
First of all, using WWWForm let’s you use POST in PHP requests. While they’re not as visible as in-link, they are easy to make up. You can read about it briefly here.
If something is really sensitive, I suggest you either doing it only on authorative server side, or use some encryption. Also, you can send some password in post that only your client/server knows to make it little harder - however it’s still fairly easy to bypass. There are other ways ofc, but those are the simplest that I can think of atm - and if anyone has a nice solution, I’d also like to hear.

If you want chat to be server-independent, you’d need a separate chat server. Normally it’d be rather straight-forward to do, but I’m not sure how could it be handled using Unity - I was thinking of using UNet for game stuff and Photon for chat. But I didn’t ran into a need to do so yet.

About storing offline messages - that you can do. Also it can work with message history, even if temporal. Or simple use in-game mailing system - basically any MMO can be example of this.

[arcady87]

@TehGM - first off, thank you very much for your dealing.

about “PHP Post requests” - indeed that’s how i currently handle PHP calls.

about “offline messages” - your confirmation and approvation was totally unexpected.

about “global chat” - working on it thru TCP, maybe i can close some results.

[TehGM]

Really nice… and inspiring I must admit. Now I might attempt to code my version later, too.

[arcady87]

@TehGM - thank you very much.

honestly i am not very familiar with sockets’ logic, but “logic” in general. i have made many researches to understand the basics of C# sockets, i saw the most complex scripts around.

on the Wiki you can look at a very complicated code that can handle everything from/to Unity3D via TCP. everyone use C# maybe beacuse of its hyper stability and flexibility to create and read custom DLL libraries. however i do not care, my necessities are definitely more specific.

[TehGM]

.NET libraries are not really hard to read, either. I can suggest you app called Confuser. It works really nice for obfuscating .NET code.

[arcady87]

let’s imagine a malicious user that find a way to inject the code. they could intercept the encrypted data and send it back with no-legal data infi. a persistent sniffing process sounds paranoid but, personally speaking, i know some nerds whom might spend hours on this.

how do i face this problem?

waiting for answers and help. thank you.
-arcady87

[TehGM]

I’m not sure about how to secure stuff well without dedicated server, and I was thinking of it too as for my current project design dedicated server seems pointless (making match PvP game with PvE raids). What I thought, besides anti-cheat system would be that only host sends match results data to database server. Like I want reward items at the end of my match, host would send all players’ data and match results via PHP, server would calculate it and send rewards info back.
Also, if I implement registering via website, web server would hold all the data of what player unlocked. And host would check it when player tries to spawn etc, and kicks out if player tries to use something he hasn’t unlocked yet.
Ofc, this doesn’t remove risk completely, but surely gives cheaters chance to cheat only if they host by themselves.

I also thought of having confirmation auth token generated by webserver and sent to player as he logins. This would be then used to send along with request to check if the player that sends it is actually the player that sent it. But now, as I was writting this post, I realized that this will be useless if host has to hold the data. I am thinking of using 2 tokens, one for private use and one for host use, but it’s just an initial idea and I’ll have to consider it properly later.

Those are just my ideas for future, as I am just slowly developing it and barely started. But better that than nothing.

[LevonRavel]

Arcady87, Actually i have a solution for your offline status etc… I would agree that this is an inconvenience and unity should implement this into their engine but here is how the story goes…

Run a thread <— so nice of unity to make this safe
The below code runs a small webclient and listens for incoming connections if theres a connection the server will write
Accept / Decline…

    public void Listener()
    {
        HttpListener listener = new HttpListener();

        listener.Prefixes.Add("http://*:"+mysqlInformation.webPort+"/");
        listener.Start();
        Debug.Log("Listening...");
        int maxPlayers = int.Parse (sqlEntries.maxPlayers);

        while (hosting)
        {
            HttpListenerContext context = listener.GetContext ();
            HttpListenerRequest request = context.Request;
            HttpListenerResponse response = context.Response;
            string responseString ="";

            if(network_connections <  maxPlayers )
            {
                network_connections++;
                responseString = "Accept";
            }else{
                responseString = "Decline";        
            }

            Debug.Log (responseString);

            byte[] buffer = System.Text.Encoding.UTF8.GetBytes (responseString);

            response.ContentLength64 = buffer.Length;
            System.IO.Stream output = response.OutputStream;
            output.Write (buffer, 0, buffer.Length);
            output.Close ();
        }
        listener.Stop ();
    }

This is pulled from Crossnet… Basically what this does is allows the client to check if the server is allowing connections before actually trying to join / connect…

There must be away to check for the running listener, I accomplish this by listing the ips in a mysql database, then the clients can communicate this way. You can send messages just like a chat or even send images what ever your hearts desire… Hope I was able to help out a bit with the offline / online chat method. (Might want to snag up Crossnet if you haven’t yet strip the Upnp from it and use that also to forward ports etc).

Now this one will blow your mind… Why wont unity protect the assets on the asset store from piracy some sort of security would be nice.

[arcady87]

@LevonRavel - thank you very much for your help and time.

i will limit myself to compare your own method with mine - i finished the global chat just yesterday, now i’m working on a bunch of methods to encrypt variables and packets. in particular, since i understand Java more than C#, i started with something called ByteArrayOutputStream.

please, keep in mind i’m not a coder.

thanks ahead time for your understanding.
-arcady87

[TehGM]

In .NET (C# for example), you have System.IO namespace, and it has Stream general purpose class, along with specialized inheriting classes such as FileStream or MemoryStream, as well as helper classes like StreamWriter or StreamReader.

[arcady87]

@TehGM - thanks for your feedback!

as i wrote, i don’t know C#, i am trying my best.

hugs
-arcady87

[LevonRavel]

Looking good Ill translate your share to c# then get back to you with it.

[arcady87]

@LevonRavel - thanks for your support.

by the way, that silly DLL is the top of the iceberg. i am realizing that you can bypass all Unity3D classes and import yours own pre-compiled. thanks this new approach, i am disclosing much more potential and flexibility. i would be curious to implement Ruby in Unity3D as well, it might be awesome and ridiculously fast in therms of development. anyway Javascript remains the most used code language.

[arcady87]

hey guys! i got my own MasterServer done! there i share a trial of what server and client send to each other. attention: these data are decrypted already.

SERVER LOG:
    CHECK FILES
    File found : [dataFiles.info]
    INITIALIZE : [ShowTimestamps]false, [Record]true, [Backup]true, [Upload]false
    START SERVER :
        Client c4d897cf-9386-4893-b757-b1f13629404f connected
            User saved (tmp) : c4d897cf-9386-4893-b757-b1f13629404f
        Client.SE_InitializeBufferRequest
        Client.ClientFilesRequest
            User deleted : c4d897cf-9386-4893-b757-b1f13629404f
        Client c4d897cf-9386-4893-b757-b1f13629404f disconnected

CLIENT LOG:
    Recevied TCP packet:
    pckL=10 data=09050000000000000000
    Sent TCP packet:
    pckL=10 data=09060000000000000000

    Recevied TCP packet:
    pckL=4 data=03062c0c
    Sent TCP packet:
    pckL=10 data=09070000000000000000

    Recevied TCP packet:
    pckL=3119 data=8c2d072c000b0024766964656f67616d65003700766964656f67616d655c746573743030312e6578652c663038633239353764383361343937616363626234363164363239656163626200180024766964656f67616d655c746573743030315f44617461003f00766964656f67616d655c746573743030315f446174615c6c6576656c302c6262346133333833396339623732643930306633643130643464343965363531003f00766964656f67616d655c746573743030315f446174615c6c6576656c312c6231613961323438313638643137393165353138356362366163376138366236003f00766964656f67616d655c746573743030315f446174615c6c6576656c322c3961633765356663373561343336323264663631613138373761646638373730004100766964656f67616d655c746573743030315f446174615c6d61696e446174612c376136363637316134363633616564396563313338376438356437613631356300200024766964656f67616d655c746573743030315f446174615c4d616e61676564005900766964656f67616d655c746573743030315f446174615c4d616e616765645c417373656d626c792d556e6974795363726970742e646c6c2c3132613464646561366438653831346334653739643338346131366163396639004d00766964656f67616d655c746573743030315f446174615c4d616e616765645c426f6f2e4c616e672e646c6c2c3136353234316538323038666464363339303435326665336561626631663237005200766964656f67616d655c746573743030315f446174615c4d616e616765645c4d6f6e6f2e53656375726974792e646c6c2c3565393237353431346336613030613466633338386233623663653333326166004d00766964656f67616d655c746573743030315f446174615c4d616e616765645c6d73636f726c69622e646c6c2c3264343861306239623963613431373431323363656135643732646665306638004d00766964656f67616d655c746573743030315f446174615c4d616e616765645c5365637572654d652e646c6c2c6536356562383666343066326533623838373431333139393439613030353261005000766964656f67616d655c746573743030315f446174615c4d616e616765645c53797374656d2e436f72652e646c6c2c3936643233333532343064346661653534643363336565653266613966643464004b00766964656f67616d655c746573743030315f446174615c4d616e616765645c53797374656d2e646c6c2c6138353966636431336364356132303537636230396537303136663863303132005000766964656f67616d655c746573743030315f446174615c4d616e616765645c556e697479456e67696e652e646c6c2c3065336331646132373134663537393631323266313665663035306536363163005300766964656f67616d655c746573743030315f446174615c4d616e616765645c556e697479456e67696e652e55492e646c6c2c6536396437643238653038646439326430633663663537363235616566393136005500766964656f67616d655c746573743030315f446174615c4d616e616765645c556e6974795363726970742e4c616e672e646c6c2c3431643361653938643132306363643163326238303236346235666133393331001d0024766964656f67616d655c746573743030315f446174615c4d6f6e6f00210024766964656f67616d655c746573743030315f446174615c4d6f6e6f5c65746300260024766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f002a0024766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f5c312e30006800766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f5c312e305c44656661756c745773646c48656c7047656e657261746f722e617370782c3636666564323431316331346130666338636534633539336566363031626662005900766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f5c312e305c6d616368696e652e636f6e6669672c3864636364396139386432353735313632616133363632323461393833633038002a0024766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f5c322e3000330024766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f5c322e305c42726f7773657273006200766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f5c322e305c42726f77736572735c436f6d7061742e62726f777365722c3064383331633132363462356233326133396661333437646533363866653438006800766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f5c322e305c44656661756c745773646c48656c7047656e657261746f722e617370782c3362333435326333393966323761323465613561353839633762666537353062005900766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f5c322e305c6d616368696e652e636f6e6669672c3630333137336435366163653437613264393062383766666263336266613931005700766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f5c322e305c73657474696e67732e6d61702c3535646163353632383738623764643938656538613761643230336132366536005500766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f5c322e305c7765622e636f6e6669672c3262363330336334663132373632623731303531646236653934376639306134005300766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f5c62726f77736361702e696e692c3337386265383039646637643135616163373561313735363933653235666262004d00766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f5c636f6e6669672c6639356333343563316335336238323034383766366237326536326435343835002e0024766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f5c6d636f6e666967005900766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6574635c6d6f6e6f5c6d636f6e6669675c636f6e6669672e786d6c2c6633346233333066323064636531626463636539303538666361323837303939004600766964656f67616d655c746573743030315f446174615c4d6f6e6f5c6d6f6e6f2e646c6c2c3937316534326665643534346132316661653434343864626333663566653964004700766964656f67616d655c746573743030315f446174615c6f75747075745f6c6f672e7478742c353936633735376638306538303637623233343666613465393731363038623200220024766964656f67616d655c746573743030315f446174615c5265736f7572636573005a00766964656f67616d655c746573743030315f446174615c5265736f75726365735c756e6974792064656661756c74207265736f75726365732c3631343332393130666530313032363663633135663539666436336438646361005600766964656f67616d655c746573743030315f446174615c5265736f75726365735c756e6974795f6275696c74696e5f65787472612c3731333030613130663461373137363461346237636436333032373134303764004d00766964656f67616d655c746573743030315f446174615c736861726564617373657473302e6173736574732c3833393738363636643633373765653963353630656237383037316535393961004d00766964656f67616d655c746573743030315f446174615c736861726564617373657473312e6173736574732c3130623030626630643761646537633138373235336561393137383766326561004d00766964656f67616d655c746573743030315f446174615c736861726564617373657473322e6173736574732c6338373930323938646431633734636364646462663362323139323335613262004d00766964656f67616d655c746573743030315f446174615c736861726564617373657473332e6173736574732c383330313262313139363162383762353033363032623934386531363833303100
    Sent TCP packet:
    pckL=2 data=ENCRYPTED ~REMOVED

    Recevied TCP packet:
    pckL=10 data=09050000000000000000

actually i’m working on the famous Lobby thing.

so, that’s.

thank you all for your attention and help during the past days.
-arcady87

special thanks: @LevonRavel and @TehGM .